a.id AS "id",
a.apply_code AS "applyCode",
a.course_id AS "courseId",
a.apply_channel AS "applyChannel",
a.payment_time AS "paymentTime",
a.payment_state AS "paymentState",
a.running_number AS "runningNumber",
a.member_code AS "memberCode",
a.member_name AS "memberName",
a.mobile AS "mobile",
a.shop_name AS "shopName",
a.province AS "province",
a.city AS "city",
a.area AS "area",
a.apply_type AS "applyType",
a.certificate_code AS "certificateCode",
a.issue_date AS "issueDate",
a.remarks AS "remarks",
a.create_by AS "createBy.id",
a.update_by AS "updateBy.id",
a.create_date AS "createDate",
a.update_date AS "updateDate",
a.del_flag AS "delFlag"
INSERT INTO appreciation_apply(
id,
apply_code,
course_id,
apply_channel,
payment_time,
payment_state,
running_number,
member_code,
member_name,
mobile,
shop_name,
province,
city,
area,
apply_type,
certificate_code,
issue_date,
remarks,
create_by,
update_by,
create_date,
update_date,
del_flag
) VALUES (
#{id},
#{applyCode},
#{courseId},
#{applyChannel},
#{paymentTime},
#{paymentState},
#{runningNumber},
#{memberCode},
#{memberName},
#{mobile},
#{shopName},
#{province},
#{city},
#{area},
#{applyType},
#{certificateCode},
#{issueDate},
#{remarks},
#{createBy.id},
#{updateBy.id},
#{createDate},
#{updateDate},
#{delFlag}
)
UPDATE appreciation_apply SET
apply_code = #{applyCode},
course_id = #{courseId},
apply_channel = #{applyChannel},
payment_time = #{paymentTime},
payment_state = #{paymentState},
running_number = #{runningNumber},
member_code = #{memberCode},
member_name = #{memberName},
mobile = #{mobile},
shop_name = #{shopName},
province = #{province},
city = #{city},
area = #{area},
apply_type = #{applyType},
certificate_code = #{certificateCode},
issue_date = #{issueDate},
remarks = #{remarks},
update_by = #{updateBy.id},
update_date = #{updateDate}
WHERE id = #{id}
UPDATE appreciation_apply SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE appreciation_apply SET
course_id = ''
WHERE id = #{id}
UPDATE appreciation_apply SET
course_id = #{courseId}
WHERE id = #{id}
UPDATE appreciation_apply SET
course_id = #{cid}
WHERE id in
#{item}
UPDATE appreciation_apply SET
certificate_code = #{certificateCode},
issue_date = #{issueDate}
WHERE id = #{id}