a.id,
a.parent_id AS "parent.id",
a.parent_ids,
a.code,
a.name,
a.sort,
a.type,
a.sutong,
a.yunda,
a.yunda_add AS "yundaAdd",
a.remarks,
a.create_by AS "createBy.id",
a.create_date,
a.update_by AS "updateBy.id",
a.update_date,
a.del_flag,
p.name AS "parent.name"
LEFT JOIN jeesite_sys_office p ON p.id = a.parent_id
INSERT INTO jeesite_sys_area(
id,
parent_id,
parent_ids,
code,
name,
sort,
type,
sutong,
yunda,
yunda_add,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{parent.id},
#{parentIds},
#{code},
#{name},
#{sort},
#{type},
#{sutong},
#{yunda},
#{yundaAdd},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE jeesite_sys_area SET
parent_id = #{parent.id},
parent_ids = #{parentIds},
code = #{code},
name = #{name},
sort = #{sort},
type = #{type},
sutong = #{sutong},
yunda = #{yunda},
yunda_add = #{yundaAdd},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE jeesite_sys_area SET
parent_id = #{parent.id},
parent_ids = #{parentIds}
WHERE id = #{id}
UPDATE jeesite_sys_area SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id} OR parent_ids LIKE
'%,'||#{id}||',%'
'%,'+#{id}+',%'
CONCAT('%,', #{id}, ',%')