a.id AS "id", a.courseware_name AS "coursewareName", a.url AS "url", a.states AS "states", a.remarks AS "remarks", a.create_by AS "createBy.id", a.update_by AS "updateBy.id", a.create_date AS "createDate", a.update_date AS "updateDate", a.del_flag AS "delFlag" (SELECT COUNT(1) FROM appreciation_courses_courseware_ref sr WHERE sr.courseware_id = a.id AND sr.del_flag = '0') AS "coursesCount" LEFT JOIN appreciation_courses_courseware_ref r ON r.courseware_id = a.id AND r.del_flag = '0' LEFT JOIN appreciation_courses c ON r.course_id = c.id SELECT , FROM appreciation_courseware a WHERE a.id = #{id} SELECT , FROM appreciation_courseware a a.del_flag = #{DEL_FLAG_NORMAL} AND a.courseware_name LIKE concat('%',#{coursewareName},'%') AND c.course_name LIKE concat('%',#{coursesName},'%') AND r.course_id = #{coursesId} AND a.states = #{states} AND a.update_date >= #{beginUpdateDate} AND a.update_date <= #{endUpdateDate} GROUP BY a.id ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM appreciation_courseware a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT acw.* FROM appreciation_courses_courseware_ref cr JOIN appreciation_courseware acw ON cr.courseware_id = acw.id WHERE cr.del_flag ='0' AND acw.del_flag ='0' AND cr.course_id = #{courseId} AND acw.states = '1' ORDER BY acw.courseware_name INSERT INTO appreciation_courseware( id, courseware_name, url, states, remarks, create_by, update_by, create_date, update_date, del_flag ) VALUES ( #{id}, #{coursewareName}, #{url}, #{states}, #{remarks}, #{createBy.id}, #{updateBy.id}, #{createDate}, #{updateDate}, #{delFlag} ) UPDATE appreciation_courseware SET courseware_name = #{coursewareName}, url = #{url}, states = #{states}, remarks = #{remarks}, update_by = #{updateBy.id}, update_date = #{updateDate} WHERE id = #{id} UPDATE appreciation_courseware SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE appreciation_courseware SET states = #{states} WHERE id = #{id}