a.id AS "id",
a.state AS "state",
a.name AS "name",
a.contact AS "contact",
a.org_code AS "orgCode",
a.end_date AS "endDate",
a.deposit AS "deposit",
a.deposit_date AS "depositDate",
a.org_type AS "orgType",
a.org_site AS "orgSite",
a.print_offset_left AS "printOffsetLeft",
a.print_offset_top AS "printOffsetTop",
a.create_date AS "createDate",
a.create_by AS "createBy.id",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.remarks AS "remarks",
a.del_flag AS "delFlag",
a.member_code AS "memberCode",
a.user_id AS "user.id",
a.scanner AS "scanner",
a.address AS "address",
a.tel AS "tel",
a.visible_flag AS "visibleFlag",
a.province AS "province",
a.city AS "city",
a.street AS "street",
a.user_id AS "userId",
a.display_onweb AS "displayOnWeb",
u19.name AS "user.name",
u19.login_name AS "user.loginName",
u19.password AS "user.password",
m.account_balance AS "member.accountBalance",
m.member_code AS "member.memberCode",
m.id AS "member.id",
m.name AS "member.name",
m.province AS "member.province",
m.city AS "member.city",
m.street AS "member.street",
a.landlinePhone as "landlinePhone",
a.yingyePic as "yingyePic",
a.shouYiPic as "shouYiPic",
a.mendian1Pic as "mendian1Pic",
a.jianDingshi1 as "jianDingshi1",
a.jianDingshi2 as "jianDingshi2",
a.tuijiansren as "tuijiansren",
a.shenHeState as "shenHeState",
a.authorized_province as "authorizedProvince",
a.authorized_city as "authorizedCity",
a.admin_code as "adminCode",
a.nose_line as "noseLine",
m.dog_nose_repeated_detection as "dogNoseRepeatedDetection",
m.dog_nose_liveness_detection as "dogNoseLivenessDetection"
LEFT JOIN jeesite_sys_user u19 ON u19.id = a.user_id
LEFT JOIN sys_member m ON m.member_code=a.member_code
update sys_member SET
dog_nose_repeated_detection=#{dogNoseRepeatedDetection},
dog_nose_liveness_detection=#{dogNoseLivenessDetection}
WHERE member_code = #{memberCode} and del_flag = 0
INSERT INTO sys_org(
id,
state,
name,
contact,
org_code,
end_date,
deposit,
deposit_date,
org_type,
org_site,
print_offset_left,
print_offset_top,
create_date,
create_by,
update_by,
update_date,
remarks,
del_flag,
display_onweb,
member_code,
user_id,
scanner,
address,
tel,
province,
city,
street,
landlinePhone,
yingyePic,
shouYiPic,
mendian1Pic,
jianDingshi1,
jianDingshi2,
tuijiansren,
shenHeState,
authorized_province,
authorized_city,
admin_code,
nose_line
) VALUES (
#{id},
#{state},
#{name},
#{contact},
#{orgCode},
#{endDate},
#{deposit},
#{depositDate},
#{orgType},
#{orgSite},
#{printOffsetLeft},
#{printOffsetTop},
#{createDate},
#{createBy.id},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{displayOnWeb},
#{memberCode},
#{user.id},
#{scanner},
#{address},
#{tel},
#{province},
#{city},
#{street},
#{landlinePhone},
#{yingyePic},
#{shouYiPic},
#{mendian1Pic},
#{jianDingshi1},
#{jianDingshi2},
#{tuijiansren},
#{shenHeState},
#{authorizedProvince},
#{authorizedCity},
#{adminCode},
#{noseLine}
)
UPDATE sys_org SET
state = #{state},
name = #{name},
contact = #{contact},
org_code = #{orgCode},
end_date = #{endDate},
deposit = #{deposit},
deposit_date = #{depositDate},
org_type = #{orgType},
org_site = #{orgSite},
print_offset_left = #{printOffsetLeft},
print_offset_top = #{printOffsetTop},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
display_onweb = #{displayOnWeb},
member_code = #{memberCode},
user_id = #{user.id},
scanner = #{scanner},
address = #{address},
province = #{province},
city = #{city},
street = #{street},
tel = #{tel},
visible_flag = #{visibleFlag},
landlinePhone=#{landlinePhone},
yingyePic=#{yingyePic},
shouYiPic=#{shouYiPic},
mendian1Pic=#{mendian1Pic},
jianDingshi1=#{jianDingshi1},
jianDingshi2=#{jianDingshi2},
tuijiansren=#{tuijiansren},
shenHeState=#{shenHeState},
authorized_province = #{authorizedProvince},
authorized_city = #{authorizedCity},
admin_code = #{adminCode},
nose_line = #{noseLine}
WHERE id = #{id}
UPDATE sys_org SET
remarks = concat(IFNULL(remarks,''),#{remarks}),
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE sys_org SET
address = #{address}
WHERE id = #{id}
UPDATE sys_org SET
admin_code = #{adminCode}
WHERE id = #{id}