a.id AS "id", a.course_code AS "courseCode", a.course_id AS "courseId", a.course_price AS "coursePrice", a.member_code AS "memberCode", a.name AS "name", a.mobile AS "mobile", a.province AS "province", a.city AS "city", a.area AS "area", a.street AS "street", a.address AS "address", a.running_number AS "runningNumber", a.payment_state AS "paymentState", a.payment_time AS "paymentTime", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag", b.school_name_cn AS "trainingInstitution.schoolNameCn", b.school_name_en AS "trainingInstitution.schoolNameEn", b.school_short_name AS "trainingInstitution.schoolShortName", m.groomer_type AS "member.groomerType", m.mobile AS "member.mobile", m.gender AS "member.gender", m.member_card_type AS "member.memberCardType", c.code AS "groomerCourse.code", c.diploma_level AS "groomerCourse.diplomaLevel", c.course_type AS "groomerCourse.type", c.course_name AS "groomerCourse.courseName" LEFT JOIN sys_member m ON m.member_code=a.member_code LEFT JOIN groomer_course c ON c.id=a.course_id LEFT JOIN training_institution b ON b.id= c.school_id SELECT FROM groomer_course_application a WHERE a.id = #{id} SELECT FROM groomer_course_application a 1=1 AND a.name LIKE '%'||#{name}||'%' '%'+#{name}+'%' concat('%',#{name},'%') 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 a.course_id = #{courseId} AND a.course_code = #{courseCode} AND c.school_id = #{schoolId} AND a.payment_state = #{paymentState} AND c.course_name = #{groomerCourse.courseName} AND c.diploma_level = #{groomerCourse.diplomaLevel} AND c.code = #{groomerCourse.code} AND c.course_type = #{groomerCourse.type} AND b.school_name_cn LIKE concat('%',#{trainingInstitution.schoolNameCn},'%') AND (a.member_code = #{memberCode} or a.name LIKE CONCAT('%', #{memberCode}, '%')) ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM groomer_course_application a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO groomer_course_application( id, course_code, course_id, course_price, member_code, name, mobile, province, city, area, street, address, running_number, payment_state, payment_time, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{courseCode}, #{courseId}, #{coursePrice}, #{memberCode}, #{name}, #{mobile}, #{province}, #{city}, #{area}, #{street}, #{address}, #{runningNumber}, #{paymentState}, #{paymentTime}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE groomer_course_application SET course_code = #{courseCode}, course_id = #{courseId}, course_price = #{coursePrice}, member_code = #{memberCode}, name = #{name}, mobile = #{mobile}, province = #{province}, city = #{city}, area = #{area}, street = #{street}, address = #{address}, running_number = #{runningNumber}, payment_state = #{paymentState}, payment_time = #{paymentTime}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE groomer_course_application SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} SELECT FROM groomer_course_application a WHERE a.course_id = #{courseId} and a.member_code = #{memberCode} and a.del_flag='0' order by a.create_date desc limit 1 SELECT FROM groomer_course_application a WHERE a.member_code = #{memberCode} and a.del_flag='0' order by a.create_date desc SELECT count(*) FROM groomer_course_application a WHERE a.del_flag = '0' AND (a.payment_state = '2' OR a.payment_state = '' OR a.payment_state IS NULL ) AND a.course_id = #{courseId}