a.id AS "id", a.school_id AS "schoolId", a.code AS "code", a.course_name AS "courseName", a.course_type AS "type", a.cover AS "cover", a.introduce AS "introduce", a.video AS "video", a.states AS "states", a.diploma_level AS "diplomaLevel", a.price AS "price", a.registration_starte_time AS "registrationStarteTime", a.registration_end_time AS "registrationEndTime", a.start_date AS "startDate", a.end_date AS "endDate", a.teacher AS "teacher", a.teacher_id AS "teacherId", a.course_details AS "courseDetails", a.launch_time AS "launchTime", 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", a.review_remarks AS "reviewRemarks", a.play_times AS "playTimes", b.school_name_cn AS "schoolName", b.province AS "province", b.city AS "city" LEFT JOIN training_institution b ON a.school_id = b.id SELECT , (select count(*) from groomer_course_application where course_id=a.id and del_flag=0 and payment_state='2') AS "signUpcount" FROM groomer_course a WHERE a.id = #{id} SELECT FROM groomer_course a WHERE a.code = #{code} SELECT FROM groomer_course a LEFT JOIN groomer_course_application c ON c.course_id=a.id where a.id in #{item} GROUP BY a.id ORDER BY c.create_date DESC SELECT a.code FROM groomer_course a ORDER BY a.code DESC limit 1 SELECT , case when a.registration_end_time>NOW() then '1' else '0' end AS "timedesc", (select count(*) from groomer_course_application where course_id=a.id and del_flag=0) AS "signUpcount" FROM groomer_course a a.del_flag = #{DEL_FLAG_NORMAL} AND a.course_name = #{courseName} AND a.code = #{code} AND a.states = #{states} AND a.course_type = #{type} AND a.diploma_level = #{diplomaLevel} AND (b.school_short_name LIKE CONCAT('%', #{schoolId}, '%') OR b.id = #{schoolId} OR b.school_name_cn LIKE CONCAT('%', #{schoolId}, '%')) AND date_format(a.create_date, '%Y-%m-%d') = ]]> date_format(#{beginCreateDate}, '%Y-%m-%d') AND date_format(a.create_date, '%Y-%m-%d') date_format(#{endCreateDate}, '%Y-%m-%d') AND date_format(a.launch_time, '%Y-%m-%d') = ]]> date_format(#{beginLaunchTime}, '%Y-%m-%d') AND date_format(a.launch_time, '%Y-%m-%d') date_format(#{endLaunchTime}, '%Y-%m-%d') AND a.launch_time IS NOT null AND a.states in '${item}' AND a.states != #{excludeState} AND a.course_type != #{excludeType} ORDER BY timedesc DESC,signUpcount DESC,a.create_date DESC ORDER BY timedesc DESC, FIELD '${item}' DESC, signUpcount DESC,a.create_date DESC ORDER BY a.update_date DESC SELECT CASE WHEN ( CURDATE() a.registration_end_time AND CURDATE() = ]]> a.registration_starte_time) THEN 2 WHEN a.registration_end_time IS NULL THEN 1 END AS nums, FROM groomer_course a a.del_flag = '0' AND a.states IN ('3','6') AND a.launch_time IS NOT null AND a.course_type = #{type} AND a.diploma_level = #{diplomaLevel} ORDER BY a.${key} ${method} ORDER BY nums DESC, a.course_type ASC , COUNT(c.id) DESC, a.update_date DESC SELECT CASE WHEN ( CURDATE() a.registration_end_time AND CURDATE() = ]]> a.registration_starte_time) THEN 2 WHEN a.registration_end_time IS NULL THEN 1 END AS nums, FROM groomer_course a LEFT JOIN groomer_course_application c ON a.id = c.course_id a.del_flag = '0' AND a.states IN ('3','6') AND a.launch_time IS NOT null AND a.course_type = #{type} AND a.diploma_level = #{diplomaLevel} GROUP BY a.id ORDER BY COUNT(c.id) DESC, a.course_type DESC,a.launch_time DESC; ORDER BY COUNT(c.id) DESC, a.create_date DESC; ORDER BY nums DESC, a.course_type ASC , COUNT(c.id) DESC,a.launch_time DESC; SELECT FROM groomer_course a a.del_flag = #{DEL_FLAG_NORMAL} AND a.course_type = '3' AND date_format(a.start_date,'%Y-%m-%d') date_format(now(), '%Y-%m-%d') AND a.school_id = #{schoolId} ORDER BY ${page.orderBy} ORDER BY a.end_date DESC SELECT FROM groomer_course a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO groomer_course( id, school_id, code , course_name, course_type, cover , introduce, video, states, diploma_level, price, registration_starte_time, registration_end_time, start_date, end_date, teacher, teacher_id, course_details, launch_time, create_by, update_by, create_date, update_date, play_times, del_flag ) VALUES ( #{id}, #{schoolId}, #{code}, #{courseName}, #{type}, #{cover}, #{introduce}, #{video}, #{states}, #{diplomaLevel}, #{price}, #{registrationStarteTime}, #{registrationEndTime}, #{startDate}, #{endDate}, #{teacher}, #{teacherId}, #{courseDetails}, #{launchTime}, #{createBy.id}, #{updateBy.id}, #{createDate}, #{updateDate}, #{playTimes}, #{delFlag} ) UPDATE groomer_course SET course_name = #{courseName}, course_type = #{type}, cover = #{cover}, introduce = #{introduce}, video = #{video}, states = #{states}, price = #{price}, registration_starte_time = #{registrationStarteTime}, registration_end_time = #{registrationEndTime}, diploma_level = #{diplomaLevel}, start_date = #{startDate}, end_date = #{endDate}, course_details = #{courseDetails}, review_remarks = #{reviewRemarks}, launch_time = #{launchTime}, teacher = #{teacher}, play_times = #{playTimes}, teacher_id = #{teacherId} WHERE id = #{id} UPDATE groomer_course SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE groomer_course SET states = '6' WHERE registration_end_time < CURDATE() UPDATE groomer_course SET teacher_id = '', teacher = '' WHERE teacher_id = #{teacherId}