a.id AS "id",
a.ad_name AS "adName",
a.status AS "status",
a.jump_type AS "jumpType",
a.jump_route AS "jumpRoute",
a.resident_seconds AS "residentSeconds",
a.start_date AS "startDate",
a.end_date AS "endDate",
a.priority AS "priority",
a.frequency AS "frequency",
a.file_url AS "fileUrl",
a.file_type AS "fileType",
a.program_id AS "programId",
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"
INSERT INTO app_splash_ads(
id,
ad_name,
status,
jump_type,
jump_route,
resident_seconds,
start_date,
end_date,
priority,
frequency,
file_url,
file_type,
program_id,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{adName},
#{status},
#{jumpType},
#{jumpRoute},
#{residentSeconds},
#{startDate},
#{endDate},
#{priority},
#{frequency},
#{fileUrl},
#{fileType},
#{programId},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE app_splash_ads SET
ad_name = #{adName},
status = #{status},
jump_type = #{jumpType},
jump_route = #{jumpRoute},
resident_seconds = #{residentSeconds},
start_date = #{startDate},
end_date = #{endDate},
priority = #{priority},
frequency = #{frequency},
file_url = #{fileUrl},
file_type = #{fileType},
program_id = #{programId},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE app_splash_ads SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}