a.id,
a.parent_id AS "parent.id",
a.parent_ids,
a.area_id AS "area.id",
a.code,
a.name,
a.sort,
a.type,
a.grade,
a.address,
a.zip_code,
a.master,
a.phone,
a.fax,
a.email,
a.remarks,
a.create_by AS "createBy.id",
a.create_date,
a.update_by AS "updateBy.id",
a.update_date,
a.del_flag,
a.useable AS useable,
a.data_permission AS dataPermission,
a.primary_person AS "primaryPerson.id",
a.deputy_person AS "deputyPerson.id",
p.name AS "parent.name",
ar.name AS "area.name",
ar.parent_ids AS "area.parentIds",
pp.name AS "primaryPerson.name",
dp.name AS "deputyPerson.name"
LEFT JOIN jeesite_sys_office p ON p.id = a.parent_id
LEFT JOIN jeesite_sys_area ar ON ar.id = a.area_id
LEFT JOIN jeesite_sys_user pp ON pp.id = a.primary_person
LEFT JOIN jeesite_sys_user dp ON dp.id = a.deputy_person
INSERT INTO jeesite_sys_office(
id,
parent_id,
parent_ids,
area_id,
code,
name,
sort,
type,
grade,
address,
zip_code,
master,
phone,
fax,
email,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
useable,
primary_person,
deputy_person,
data_permission
) VALUES (
#{id},
#{parent.id},
#{parentIds},
#{area.id},
#{code},
#{name},
#{sort},
#{type},
#{grade},
#{address},
#{zipCode},
#{master},
#{phone},
#{fax},
#{email},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{useable},
#{primaryPerson.id},
#{deputyPerson.id},
#{dataPermission}
)
UPDATE jeesite_sys_office SET
parent_id = #{parent.id},
parent_ids = #{parentIds},
area_id = #{area.id},
code = #{code},
name = #{name},
type = #{type},
grade = #{grade},
address = #{address},
zip_code = #{zipCode},
master = #{master},
phone = #{phone},
fax = #{fax},
email = #{email},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
useable=#{useable},
primary_person=#{primaryPerson.id},
deputy_person=#{deputyPerson.id},
data_permission=#{dataPermission}
WHERE id = #{id}
UPDATE jeesite_sys_office SET
parent_id = #{parent.id},
parent_ids = #{parentIds}
WHERE id = #{id}
UPDATE jeesite_sys_office SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id} OR parent_ids LIKE
'%,'||#{id}||',%'
'%,'+#{id}+',%'
CONCAT('%,', #{id}, ',%')