a.id AS "id", a.member_code AS "memberCode", a.contract_type AS "contractType", a.contract_num AS "contractNum", a.start_date AS "startDate", a.man_in_charge AS "manInCharge", 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" m.name AS "memberName" LEFT JOIN sys_member m ON m.member_code = a.member_code SELECT , FROM member_vip a WHERE a.id = #{id} SELECT , FROM member_vip a a.del_flag = #{DEL_FLAG_NORMAL} AND a.member_code = #{memberCode} AND a.contract_type = #{contractType} AND a.start_date = #{startDate} AND a.man_in_charge = #{manInCharge} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT , FROM member_vip a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO member_vip( id, member_code, contract_type, contract_num, start_date, man_in_charge, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{memberCode}, #{contractType}, #{contractNum}, #{startDate}, #{manInCharge}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE member_vip SET member_code = #{memberCode}, contract_type = #{contractType}, contract_num = #{contractNum}, start_date = #{startDate}, man_in_charge = #{manInCharge}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} SELECT COUNT(dc.id) AS 'c' FROM dog_chip dc LEFT JOIN dog_birth_certificate dbc ON dbc.birth_cer_reg_code = dc.birth_code dc.del_flag = '0' AND dc.payment_state = '2' AND dc.payment_time >= #{startDate} AND dc.payment_time <= #{endDate} AND dbc.breeder_member_code = #{memberCode} GROUP BY dbc.breeder_member_code SELECT SUM(od.num) FROM payment_order o LEFT JOIN payment_order_detail od ON o.order_code = od.order_code o.payment_state = '2' AND o.del_flag = '0' AND o.payment_time >= #{startDate} AND o.payment_time <= #{endDate} AND o.member_code = #{memberCode} AND od.charging_item_id = '4ba9605460a84b32b3a00ef71c924e7f' ORDER BY o.payment_time DESC SELECT COUNT(DISTINCT IF(dbc.temp_member_code IS NOT NULL AND dbc.breeder_member_code != dbc.temp_member_code AND m.create_date >= #{startDate} AND m.create_date <= #{endDate},dbc.temp_member_code,NULL)) AS 'mCount' FROM dog_chip dc LEFT JOIN dog_birth_certificate dbc ON dbc.birth_cer_reg_code = dc.birth_code LEFT JOIN sys_member m ON m.member_code = dbc.member_code WHERE dc.del_flag = '0' AND dc.payment_state = '2' AND dc.payment_time >= #{startDate} AND dc.payment_time <= #{endDate} AND dbc.breeder_member_code = #{memberCode} GROUP BY dbc.breeder_member_code