a.id AS "id",
a.school_name_cn AS "schoolNameCn",
a.school_name_en AS "schoolNameEn",
a.school_short_name AS "schoolShortName",
a.school_user_id AS "schoolUserId",
a.school_member_code AS "schoolMemberCode",
a.member_code AS "memberCode",
a.responsibler AS "responsibler",
a.telephone AS "telephone",
a.province AS "province",
a.city AS "city",
a.street AS "street",
a.address AS "address",
a.start_date AS "startDate",
a.end_date AS "endDate",
a.school_type AS "schoolType",
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",
a.introduce AS "introduce",
a.avatar AS "avatar",
a.school_web AS "schoolWeb",
a.qualifications AS "qualifications",
a.display_onweb AS "displayOnWeb",
a.first_school_type AS "firstSchoolType",
b.id AS "user.id",
b.login_flag AS "user.loginFlag",
b.login_name AS "user.loginName",
b.name AS "user.name",
b.password AS "user.password",
c.member_end_date AS "member.memberEndDate",
c.account_balance AS "member.accountBalance"
LEFT JOIN jeesite_sys_user b ON a.school_user_id = b.id
LEFT JOIN sys_member c ON a.school_member_code = c.member_code
INSERT INTO training_institution(
id,
school_name_cn,
school_name_en,
school_short_name,
school_user_id,
school_member_code,
member_code,
responsibler,
telephone,
province,
city,
street,
qualifications,
first_school_type,
avatar,
introduce,
address,
start_date,
end_date,
school_type,
school_web,
display_onweb,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{schoolNameCn},
#{schoolNameEn},
#{schoolShortName},
#{schoolUserId},
#{schoolMemberCode},
#{memberCode},
#{responsibler},
#{telephone},
#{province},
#{city},
#{street},
#{qualifications},
#{firstSchoolType},
#{avatar},
#{introduce},
#{address},
#{startDate},
#{endDate},
#{schoolType},
#{schoolWeb},
#{displayOnWeb},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE training_institution SET
school_name_cn = #{schoolNameCn},
school_name_en = #{schoolNameEn},
school_short_name = #{schoolShortName},
member_code = #{memberCode},
responsibler = #{responsibler},
telephone = #{telephone},
province = #{province},
city = #{city},
street = #{street},
qualifications = #{qualifications},
first_school_type = #{firstSchoolType},
first_school_type = #{firstSchoolType},
avatar = #{avatar},
introduce= #{introduce},
address = #{address},
start_date = #{startDate},
end_date = #{endDate},
school_type = #{schoolType},
school_web = #{schoolWeb},
display_onweb = #{displayOnWeb},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE training_institution SET
remarks = concat(IFNULL(remarks,''),#{remarks}),
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE training_institution SET
introduce = '${introduce}',
avatar = #{avatar}
WHERE id = #{id}
UPDATE training_institution SET
telephone = #{telephone},
province = #{province},
city = #{city},
street = #{street},
address = #{address}
WHERE school_name_cn = #{schoolNameCn}
AND del_flag = '0'