a.id AS "id",
a.member_code AS "memberCode",
a.contract_code AS "contractCode",
a.start_date AS "startDate",
a.end_date AS "endDate",
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 "member.name",
m.gender AS "member.gender",
m.card_type AS "member.cardType",
m.card_no AS "member.cardNo",
m.mobile AS "member.mobile",
CONCAT(ifnull(m.province,''),ifnull(m.city,''),ifnull(m.street,''),ifnull(m.address,'')) AS "member.address",
m.member_type AS "member.memberType",
m.member_end_date AS "member.memberEndDate",
k.name AS "kennel.name",
k.end_time AS "kennel.endTime"
LEFT JOIN sys_member m ON m.member_code = a.member_code
LEFT JOIN kennel k ON k.member_code = a.member_code
INSERT INTO tcb_kennel(
id,
member_code,
contract_code,
start_date,
end_date,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{memberCode},
#{contractCode},
#{startDate},
#{endDate},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE tcb_kennel SET
start_date = #{startDate},
end_date = #{endDate},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE tcb_kennel SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}