a.id AS "id", a.origin_owner_member_code AS "originOwnerMemberCode", a.kennel_code AS "kennelCode", a.new_owner_member_code AS "newOwnerMemberCode", a.payment_money AS "paymentMoney", a.create_date AS "createDate", a.create_by AS "createBy.id", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag", a.review_state AS "reviewState", a.review_time AS "reviewTime", a.payment_state AS "paymentState", a.payment_time AS "paymentTime", a.process_state AS "processState", a.process_time AS "processTime", a.running_number AS "runningNumber", a.review_remarks AS "reviewRemarks", a.operator AS "operator", b1.name AS "member1.name", b2.name AS "member2.name", c.print_state AS "kennel.printState", c.fci_print_state AS "kennel.fciPrintState", c.id AS "kennel.id", c.name AS "kennel.name", c.name_en AS "kennel.nameEn" LEFT JOIN sys_member b1 ON b1.member_code = a.origin_owner_member_code LEFT JOIN sys_member b2 ON b2.member_code = a.new_owner_member_code LEFT JOIN kennel c ON c.kennel_code = a.kennel_code SELECT FROM kennel_owner_change a WHERE a.id = #{id} SELECT FROM kennel_owner_change a a.del_flag = #{DEL_FLAG_NORMAL} AND (c.name LIKE CONCAT('%', #{kennel.name}, '%') or c.name_en LIKE CONCAT('%',#{kennel.name}, '%')) AND (a.origin_owner_member_code = #{originOwnerMemberCode} or a.new_owner_member_code = #{originOwnerMemberCode} or b1.name LIKE CONCAT('%', #{originOwnerMemberCode}, '%') or b2.name LIKE CONCAT('%', #{originOwnerMemberCode}, '%')) AND (a.new_owner_member_code = #{newOwnerMemberCode} or a.new_owner_member_code = #{newOwnerMemberCode} or b1.name LIKE CONCAT('%', #{newOwnerMemberCode}, '%') or b2.name LIKE CONCAT('%', #{newOwnerMemberCode}, '%')) AND a.review_state = #{reviewState} AND a.payment_state = #{paymentState} AND a.process_state = #{processState} AND date_format(a.create_date, '%Y-%m-%d') = ]]> date_format(#{beginDate}, '%Y-%m-%d') AND date_format(a.create_date, '%Y-%m-%d') date_format(#{endDate}, '%Y-%m-%d') AND a.running_number = #{runningNumber} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM kennel_owner_change a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO kennel_owner_change( id, origin_owner_member_code, kennel_code, new_owner_member_code, payment_money, create_date, create_by, update_by, update_date, remarks, del_flag, review_state, review_time, payment_state, payment_time, process_state, process_time, running_number, review_remarks, operator ) VALUES ( #{id}, #{originOwnerMemberCode}, #{kennelCode}, #{newOwnerMemberCode}, #{paymentMoney}, #{createDate}, #{createBy.id}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{reviewState}, #{reviewTime}, #{paymentState}, #{paymentTime}, #{processState}, #{processTime}, #{runningNumber}, #{reviewRemarks}, #{operator} ) UPDATE kennel_owner_change SET origin_owner_member_code = #{originOwnerMemberCode}, kennel_code = #{kennelCode}, new_owner_member_code = #{newOwnerMemberCode}, payment_money = #{paymentMoney}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, review_state = #{reviewState}, review_time = #{reviewTime}, payment_state = #{paymentState}, payment_time = #{paymentTime}, process_state = #{processState}, process_time = #{processTime}, running_number = #{runningNumber}, review_remarks = #{reviewRemarks}, operator = #{operator} WHERE id = #{id} UPDATE kennel_owner_change SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} SELECT count(1) FROM `kennel_owner_change` WHERE payment_state = '2' AND review_state = '0' AND process_state ='0'; SELECT * FROM kennel_owner_change WHERE del_flag = '0' AND (review_state = '0' OR (review_state = '1' AND process_state = '0')) AND origin_owner_member_code = #{memberCode} SELECT * FROM kennel_owner_change WHERE del_flag = '0' AND (review_state = '0' OR (review_state = '1' AND process_state = '0')) AND new_owner_member_code = #{memberCode}