a.id, a.company_id AS "company.id", a.office_id AS "office.id", a.login_name, a.password, a.no, a.name, a.email, a.phone, a.mobile, a.user_type, a.login_ip, a.login_date, a.remarks, a.login_flag, a.photo, a.create_by AS "createBy.id", a.create_date, a.update_by AS "updateBy.id", a.update_date, a.del_flag, c.name AS "company.name", c.parent_id AS "company.parent.id", c.parent_ids AS "company.parentIds", ca.id AS "company.area.id", ca.name AS "company.area.name", ca.parent_id AS "company.area.parent.id", ca.parent_ids AS "company.area.parentIds", o.name AS "office.name", o.parent_id AS "office.parent.id", o.parent_ids AS "office.parentIds", oa.id AS "office.area.id", oa.name AS "office.area.name", oa.parent_id AS "office.area.parent.id", oa.parent_ids AS "office.area.parentIds", cu.id AS "company.primaryPerson.id", cu.name AS "company.primaryPerson.name", cu2.id AS "company.deputyPerson.id", cu2.name AS "company.deputyPerson.name", ou.id AS "office.primaryPerson.id", ou.name AS "office.primaryPerson.name", ou2.id AS "office.deputyPerson.id", ou2.name AS "office.deputyPerson.name" JOIN sys_office c ON c.id = a.company_id JOIN sys_area ca ON ca.id = c.area_id JOIN sys_office o ON o.id = a.office_id JOIN sys_area oa ON oa.id = o.area_id LEFT JOIN sys_user cu ON cu.id = c.primary_person LEFT JOIN sys_user cu2 ON cu2.id = c.deputy_person LEFT JOIN sys_user ou ON ou.id = o.primary_person LEFT JOIN sys_user ou2 ON ou2.id = o.deputy_person SELECT FROM sys_user a WHERE a.id = #{id} SELECT FROM sys_user a WHERE a.login_name = #{loginName} AND a.del_flag = #{DEL_FLAG_NORMAL} SELECT FROM sys_user a JOIN sys_user_role ur ON ur.user_id = a.id AND ur.role_id = #{role.id} WHERE a.del_flag = #{DEL_FLAG_NORMAL} AND (c.id = #{company.id} OR c.parent_ids LIKE '%,'||#{company.id}||',%') '%,'+#{company.id}+',%') CONCAT('%,', #{company.id}, ',%')) AND (o.id = #{office.id} OR o.parent_ids LIKE '%,'||#{office.id}||',%') '%,'+#{office.id}+',%') CONCAT('%,', #{office.id}, ',%')) AND a.id != '1' AND a.login_name like '%'||#{loginName}||'%' '%'+#{loginName}+'%' CONCAT('%', #{loginName}, '%') AND a.name like '%'||#{name}||'%' '%'+#{name}+'%' CONCAT('%', #{name}, '%') ${sqlMap.dsf} ORDER BY ${page.orderBy} ORDER BY c.code, o.code, a.name SELECT a.id, a.name, a.login_name FROM sys_user a WHERE a.del_flag = #{DEL_FLAG_NORMAL} AND a.office_id = #{office.id} ORDER BY a.name SELECT FROM sys_user a WHERE a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY c.code, o.code, a.name SELECT COUNT(1) FROM sys_user a WHERE a.del_flag = #{DEL_FLAG_NORMAL} INSERT INTO sys_user( id, company_id, office_id, login_name, password, no, name, email, phone, mobile, user_type, create_by, create_date, update_by, update_date, remarks, login_flag, photo, del_flag ) VALUES ( #{id}, #{company.id}, #{office.id}, #{loginName}, #{password}, #{no}, #{name}, #{email}, #{phone}, #{mobile}, #{userType}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{loginFlag}, #{photo}, #{delFlag} ) UPDATE sys_user SET company_id = #{company.id}, office_id = #{office.id}, login_name = #{loginName}, password = #{password}, no = #{no}, name = #{name}, email = #{email}, phone = #{phone}, mobile = #{mobile}, user_type = #{userType}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, login_flag = #{loginFlag}, photo = #{photo} WHERE id = #{id} DELETE FROM sys_user_role WHERE user_id = #{id} INSERT INTO sys_user_role(user_id, role_id) SELECT #{id}, #{role.id} FROM dual UPDATE sys_user SET email = #{email}, phone = #{phone}, mobile = #{mobile}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, photo = #{photo} WHERE id = #{id} UPDATE sys_user SET password = #{password} WHERE id = #{id} UPDATE sys_user SET login_ip = #{loginIp}, login_Date = #{loginDate} WHERE id = #{id} UPDATE sys_user SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}