a.id,
a.office_id AS "office.id",
a.name,
a.enname,
a.role_type AS roleType,
a.data_scope AS dataScope,
a.remarks,
a.create_by AS "createBy.id",
a.create_date,
a.update_by AS "updateBy.id",
a.update_date,
a.del_flag,
o.name AS "office.name",
o.code,
a.useable AS useable,
a.is_sys AS sysData
INSERT INTO jeesite_sys_role(
id,
office_id,
name,
enname,
role_type,
data_scope,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
is_sys,
useable
) VALUES (
#{id},
#{office.id},
#{name},
#{enname},
#{roleType},
#{dataScope},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{sysData},
#{useable}
)
UPDATE jeesite_sys_role SET
office_id = #{office.id},
name = #{name},
enname = #{enname},
role_type = #{roleType},
data_scope = #{dataScope},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
is_sys = #{sysData},
useable = #{useable}
WHERE id = #{id}
DELETE FROM jeesite_sys_role_office WHERE role_id = #{id}
INSERT INTO jeesite_sys_role_office(role_id, office_id)
SELECT #{id}, #{office.id}
FROM dual
UPDATE jeesite_sys_role SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}