a.id AS "id", a.register_code AS "registerCode", a.member_code AS "memberCode", a.name AS "name", a.gender AS "gender", a.mobile AS "mobile", a.show_level AS "showLevel", a.school_name_cn AS "schoolNameCn", a.fee AS "fee", a.leave_cancel AS "leaveCancel", a.show_leave AS "showLeave", a.order_price AS "orderPrice", a.payment_member_code AS "paymentMemberCode", a.reviewer AS "reviewer", a.grade AS "grade", a.referee AS "referee", a.payment_item_id AS "paymentItemId", a.desktop_reviewer_dog AS "desktopReviewerDog", a.floor_reviewer_dog AS "floorReviewerDog", a.any_breed AS "anyBreed", a.groomer_breed AS "groomerBreed", a.review_state AS "reviewState", a.review_time AS "reviewTime", a.payment_state AS "paymentState", a.payment_time AS "paymentTime", a.proccess_state AS "proccessState", a.proccess_time AS "proccessTime", a.running_number AS "runningNumber", a.review_remarks AS "reviewRemarks", 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", a.avatar AS "avatar", a.grade_time AS "gradeTime", a.show_code AS "showCode", a.test_no AS "testNo", a.show_dog AS "showDog", a.take_certificate_date AS "takeCertificateDate", b.show_name AS "handlerShow.showName", b.show_type AS "handlerShow.showType", b.start_time AS "handlerShow.startTime", b.end_time AS "handlerShow.endTime", m.avatar AS "member.avatar" , a.show_group AS "showGroup" LEFT JOIN handler_show b ON a.show_code=b.show_code and b.del_flag='0' LEFT JOIN sys_member m ON m.member_code=a.member_code SELECT FROM handler_register a WHERE a.id = #{id} SELECT FROM handler_register a a.del_flag = #{DEL_FLAG_NORMAL} AND a.register_code = #{registerCode} AND (a.member_code = #{memberCode} or a.name LIKE CONCAT('%',#{memberCode},'%') ) AND a.show_code LIKE CONCAT('%',#{showCode},'%') AND a.show_level = #{showLevel} AND a.school_name_cn LIKE CONCAT('%',#{schoolNameCn},'%') AND a.running_number = #{runningNumber} AND a.payment_state =#{paymentState} AND a.review_state =#{reviewState} AND a.show_leave =#{showLeave} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM handler_register a a.del_flag = #{DEL_FLAG_NORMAL} AND (b.show_type ='5' or b.show_type ='6' ) AND a.show_code LIKE CONCAT('%',#{showCode},'%') AND (a.member_code = #{memberCode} or a.name LIKE CONCAT('%',#{memberCode},'%') ) ORDER BY a.create_date DESC SELECT FROM handler_register a AND b.end_time now() AND (b.show_type='0' or b.show_type='1' or b.show_type='9') AND a.payment_state='2' AND a.show_leave='1' AND a.leave_cancel='0' AND a.register_code = #{registerCode} AND a.show_code = #{showCode} AND (a.member_code = #{memberCode} or a.name LIKE CONCAT('%',#{memberCode},'%') ) AND a.show_level = #{showLevel} AND a.grade = #{grade} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM handler_register a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO handler_register( id, register_code, member_code, name, gender, mobile, show_level, school_name_cn, fee, leave_cancel, show_leave, order_price, payment_member_code, reviewer, grade, referee, payment_item_id, desktop_reviewer_dog, floor_reviewer_dog, any_breed, groomer_breed, review_state, payment_state, proccess_state, create_by, create_date, update_by, update_date, remarks, del_flag, show_dog, avatar, show_code, show_group ) VALUES ( #{id}, #{registerCode}, #{memberCode}, #{name}, #{gender}, #{mobile}, #{showLevel}, #{schoolNameCn}, #{fee}, #{leaveCancel}, #{showLeave}, #{orderPrice}, #{paymentMemberCode}, #{reviewer}, #{grade}, #{referee}, #{paymentItemId}, #{desktopReviewerDog}, #{floorReviewerDog}, #{anyBreed}, #{groomerBreed}, #{reviewState}, #{paymentState}, #{proccessState}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{showDog}, #{avatar}, #{showCode}, #{showGroup} ) INSERT INTO handler_register( id, register_code, member_code, name, gender, mobile, show_level, school_name_cn, fee, leave_cancel, show_leave, order_price, payment_member_code, reviewer, grade, referee, payment_item_id, desktop_reviewer_dog, floor_reviewer_dog, any_breed, groomer_breed, review_state, payment_state, proccess_state, create_by, create_date, update_by, update_date, remarks, del_flag, show_dog, avatar, show_code, show_group ) VALUES ( #{id}, #{registerCode}, #{memberCode}, #{name}, #{gender}, #{mobile}, #{showLevel}, #{schoolNameCn}, #{fee}, #{leaveCancel}, #{showLeave}, #{orderPrice}, #{paymentMemberCode}, #{reviewer}, #{grade}, #{referee}, #{paymentItemId}, #{desktopReviewerDog}, #{floorReviewerDog}, #{anyBreed}, #{groomerBreed}, #{reviewState}, #{paymentState}, #{proccessState}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{showDog}, #{avatar}, #{showCode}, #{showGroup} ) UPDATE handler_register SET register_code = #{registerCode}, member_code = #{memberCode}, name = #{name}, gender = #{gender}, mobile = #{mobile}, show_level = #{showLevel}, school_name_cn = #{schoolNameCn}, fee = #{fee}, leave_cancel = #{leaveCancel}, show_leave = #{showLeave}, order_price = #{orderPrice}, payment_member_code = #{paymentMemberCode}, reviewer = #{reviewer}, grade = #{grade}, referee = #{referee}, payment_item_id = #{paymentItemId}, desktop_reviewer_dog = #{desktopReviewerDog}, floor_reviewer_dog = #{floorReviewerDog}, any_breed = #{anyBreed}, groomer_breed = #{groomerBreed}, review_state = #{reviewState}, review_time = #{reviewTime}, payment_state = #{paymentState}, payment_time = #{paymentTime}, proccess_state = #{proccessState}, proccess_time = #{proccessTime}, running_number = #{runningNumber}, review_remarks = #{reviewRemarks}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, show_dog = #{showDog}, avatar = #{avatar}, show_code=#{showCode}, show_group=#{showGroup} WHERE id = #{id} UPDATE handler_register SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} update handler_register SET avatar=#{avatar}, review_state=#{reviewState}, review_time=#{reviewTime}, review_remarks=#{reviewRemarks} WHERE id=#{id} select a.id AS "id", a.register_code AS "registerCode", a.member_code AS "memberCode", a.name AS "name", a.gender AS "gender", a.mobile AS "mobile", a.show_level AS "showLevel", a.school_name_cn AS "schoolNameCn", a.fee AS "fee", a.leave_cancel AS "leaveCancel", a.show_leave AS "showLeave", a.order_price AS "orderPrice", a.payment_member_code AS "paymentMemberCode", a.reviewer AS "reviewer", a.grade AS "grade", a.referee AS "referee", a.payment_item_id AS "paymentItemId", a.desktop_reviewer_dog AS "desktopReviewerDog", a.floor_reviewer_dog AS "floorReviewerDog", a.any_breed AS "anyBreed", a.groomer_breed AS "groomerBreed", a.review_state AS "reviewState", a.review_time AS "reviewTime", a.payment_state AS "paymentState", a.payment_time AS "paymentTime", a.proccess_state AS "proccessState", a.proccess_time AS "proccessTime", a.running_number AS "runningNumber", a.review_remarks AS "reviewRemarks", 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", a.avatar AS "avatar", a.grade_time AS "gradeTime", a.show_code AS "showCode", a.take_certificate_date AS "takeCertificateDate", a.test_no AS "testNo" FROM handler_register a LEFT JOIN handler_show c ON a.show_code=c.show_code and c.del_flag='0' a.payment_state='2' AND a.del_flag = #{DEL_FLAG_NORMAL} AND a.register_code = #{registerCode} AND (a.member_code = #{memberCode} or a.name LIKE CONCAT('%',#{memberCode},'%') ) AND a.show_code LIKE CONCAT('%',#{showCode},'%') AND a.show_level = #{showLevel} AND a.school_name_cn LIKE CONCAT('%',#{schoolNameCn},'%') AND a.running_number = #{runningNumber} AND a.review_state =#{reviewState} AND a.show_leave =#{showLeave} AND DATE_FORMAT( c.end_time, '%Y-%m-%d' ) > CURRENT_DATE () ORDER BY a.show_level ASC update handler_register SET show_leave =#{showLeave}, remarks=#{remarks} where id=#{id} update handler_register set test_no=#{testNo}, referee=#{referee}, remarks=#{remarks}, grade_time=now(), grade=#{grade}, take_certificate_date=#{takeCertificateDate} where id=#{id} select school_name_cn From handler_diploma where handler_type='0' AND member_code=#{memberCode} limit 1 SELECT COUNT(1) FROM handler_register WHERE payment_state='2' AND show_leave='0' and del_flag='0' select id from handler_register WHERE show_code=#{showCode} and member_code=#{memberCode} and del_flag='0' select id from handler_register WHERE show_code=#{showCode} and member_code=#{memberCode} and del_flag='0' AND review_state = '1' SELECT FROM handler_register a WHERE a.member_code = #{memberCode} and a.del_flag = '0' and b.show_type != '10' ORDER BY a.create_date DESC SELECT FROM handler_register a WHERE a.member_code = #{memberCode} and a.del_flag = '0' and b.show_type in ('10','11') ORDER BY a.create_date DESC update handler_register set review_state = '0' where id = #{id} update handler_register set review_state = '3' where id = #{id}