a.id AS "id",
a.main_show_id AS "mainShowId",
a.show_code AS "showCode",
s.show_name AS "showName",
s.start_time AS "startTime",
s.end_time as "endTime",
a.look_count AS "lookCount",
a.judge_id AS "judgeId",
a.judge_pic AS "judgePic",
a.bis_pic AS "bisPic",
a.bis1_order AS "bis1Order",
a.bis1_pic AS "bis1Pic",
a.bis2_order AS "bis2Order",
a.bis2_pic AS "bis2Pic",
a.bis3_order AS "bis3Order",
a.bis3_pic AS "bis3Pic",
a.bis4_order AS "bis4Order",
a.bis4_pic AS "bis4Pic",
a.jbis_pic AS "jbisPic",
a.jbis1_order AS "jbis1Order",
a.jbis1_pic AS "jbis1Pic",
a.jbis2_order AS "jbis2Order",
a.jbis2_pic AS "jbis2Pic",
a.jbis3_order AS "jbis3Order",
a.jbis3_pic AS "jbis3Pic",
a.jbis4_order AS "jbis4Order",
a.jbis4_pic AS "jbis4Pic",
a.pbis_pic AS "pbisPic",
a.pbis1_order AS "pbis1Order",
a.pbis1_pic AS "pbis1Pic",
a.pbis2_order AS "pbis2Order",
a.pbis2_pic AS "pbis2Pic",
a.pbis3_order AS "pbis3Order",
a.pbis3_pic AS "pbis3Pic",
a.pbis4_order AS "pbis4Order",
a.pbis4_pic AS "pbis4Pic",
a.bbis_pic AS "bbisPic",
a.bbis1_order AS "bbis1Order",
a.bbis1_pic AS "bbis1Pic",
a.bbis2_order AS "bbis2Order",
a.bbis2_pic AS "bbis2Pic",
a.bbis3_order AS "bbis3Order",
a.bbis3_pic AS "bbis3Pic",
a.bbis4_order AS "bbis4Order",
a.bbis4_pic AS "bbis4Pic",
a.create_by AS "createBy.id",
u.name AS "createBy.name",
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"
LEFT JOIN show_child s on a.show_code = s.show_code and a.main_show_id = s.main_show_id
LEFT join jeesite_sys_user u on a.create_by = u.id
INSERT INTO show_report_info(
id,
main_show_id,
show_code,
look_count,
judge_id,
judge_pic,
bis_pic,
bis1_order,
bis1_pic,
bis2_order,
bis2_pic,
bis3_order,
bis3_pic,
bis4_order,
bis4_pic,
jbis_pic,
jbis1_order,
jbis1_pic,
jbis2_order,
jbis2_pic,
jbis3_order,
jbis3_pic,
jbis4_order,
jbis4_pic,
pbis_pic,
pbis1_order,
pbis1_pic,
pbis2_order,
pbis2_pic,
pbis3_order,
pbis3_pic,
pbis4_order,
pbis4_pic,
bbis_pic,
bbis1_order,
bbis1_pic,
bbis2_order,
bbis2_pic,
bbis3_order,
bbis3_pic,
bbis4_order,
bbis4_pic,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{mainShowId},
#{showCode},
#{lookCount},
#{judgeId},
#{judgePic},
#{bisPic},
#{bis1Order},
#{bis1Pic},
#{bis2Order},
#{bis2Pic},
#{bis3Order},
#{bis3Pic},
#{bis4Order},
#{bis4Pic},
#{jbisPic},
#{jbis1Order},
#{jbis1Pic},
#{jbis2Order},
#{jbis2Pic},
#{jbis3Order},
#{jbis3Pic},
#{jbis4Order},
#{jbis4Pic},
#{pbisPic},
#{pbis1Order},
#{pbis1Pic},
#{pbis2Order},
#{pbis2Pic},
#{pbis3Order},
#{pbis3Pic},
#{pbis4Order},
#{pbis4Pic},
#{bbisPic},
#{bbis1Order},
#{bbis1Pic},
#{bbis2Order},
#{bbis2Pic},
#{bbis3Order},
#{bbis3Pic},
#{bbis4Order},
#{bbis4Pic},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE show_report_info SET
main_show_id = #{mainShowId},
show_code = #{showCode},
look_count = #{lookCount},
judge_id = #{judgeId},
judge_pic = #{judgePic},
bis_pic = #{bisPic},
bis1_order = #{bis1Order},
bis1_pic = #{bis1Pic},
bis2_order = #{bis2Order},
bis2_pic = #{bis2Pic},
bis3_order = #{bis3Order},
bis3_pic = #{bis3Pic},
bis4_order = #{bis4Order},
bis4_pic = #{bis4Pic},
jbis_pic = #{jbisPic},
jbis1_order = #{jbis1Order},
jbis1_pic = #{jbis1Pic},
jbis2_order = #{jbis2Order},
jbis2_pic = #{jbis2Pic},
jbis3_order = #{jbis3Order},
jbis3_pic = #{jbis3Pic},
jbis4_order = #{jbis4Order},
jbis4_pic = #{jbis4Pic},
pbis_pic = #{pbisPic},
pbis1_order = #{pbis1Order},
pbis1_pic = #{pbis1Pic},
pbis2_order = #{pbis2Order},
pbis2_pic = #{pbis2Pic},
pbis3_order = #{pbis3Order},
pbis3_pic = #{pbis3Pic},
pbis4_order = #{pbis4Order},
pbis4_pic = #{pbis4Pic},
bbis_pic = #{bbisPic},
bbis1_order = #{bbis1Order},
bbis1_pic = #{bbis1Pic},
bbis2_order = #{bbis2Order},
bbis2_pic = #{bbis2Pic},
bbis3_order = #{bbis3Order},
bbis3_pic = #{bbis3Pic},
bbis4_order = #{bbis4Order},
bbis4_pic = #{bbis4Pic},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE show_report_info SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE show_report_info SET
look_count = look_count+1
WHERE id = #{id}