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, a.permissions, a.permission_values, a.mail_check AS "mailCheck", a.weixin_id AS "weixinId", a.ticket AS "ticket", a.ticket_time AS "ticketTime", a.print_left AS "printLeft", a.print_top AS "printTop", a.user_list_office AS "userListOffice", a.is_show_sensitive_data AS "isShowSensitiveData", c.name AS "company.name", c.parent_id AS "company.parent.id", c.parent_ids AS "company.parentIds", o.name AS "office.name", o.code AS "office.code", o.parent_id AS "office.parent.id", o.parent_ids AS "office.parentIds", o.data_permission AS "office.dataPermission", a.bind_mobile AS "bindMobile" LEFT JOIN jeesite_sys_office c ON c.id = a.company_id LEFT JOIN jeesite_sys_office o ON o.id = a.office_id SELECT FROM jeesite_sys_user a WHERE a.id = #{id} SELECT * FROM jeesite_sys_user a WHERE a.id in #{item} SELECT FROM jeesite_sys_user a WHERE a.login_name = #{loginName} AND a.del_flag = #{DEL_FLAG_NORMAL} AND a.user_type = #{userType} LIMIT 1 SELECT * FROM jeesite_sys_user a WHERE a.login_name = #{loginName} AND a.del_flag = '0' LIMIT 1 SELECT FROM jeesite_sys_user a WHERE a.email = #{email} AND a.del_flag = #{DEL_FLAG_NORMAL} AND a.user_type = #{userType} SELECT , cku.token AS "mobileToken" , cku.create_time AS "mobileTokenTime" FROM cku_token cku left join jeesite_sys_user a on cku.create_user = a.id WHERE cku.token = #{token} SELECT FROM jeesite_sys_user a JOIN jeesite_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}, '%') AND a.user_type = #{userType} AND a.email = #{email} AND a.mobile = #{mobile} AND a.office_id IN (${userListOffice}) ORDER BY ${page.orderBy} ORDER BY c.code, o.code, a.name SELECT a.id, a.name, a.login_name FROM jeesite_sys_user a WHERE a.del_flag = #{DEL_FLAG_NORMAL} AND a.office_id = #{office.id} ORDER BY a.name SELECT FROM jeesite_sys_user a WHERE a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY c.code, o.code, a.name SELECT COUNT(1) FROM jeesite_sys_user a WHERE a.del_flag = #{DEL_FLAG_NORMAL} INSERT INTO jeesite_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, ticket, ticket_time, del_flag, bind_mobile, is_show_sensitive_data ) VALUES ( #{id}, #{company.id}, #{office.id}, #{loginName}, #{password}, #{no}, #{name}, #{email}, #{phone}, #{mobile}, #{userType}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{loginFlag}, #{photo}, #{ticket}, #{ticketTime}, #{delFlag}, #{bindMobile}, #{isShowSensitiveData} ) UPDATE jeesite_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}, ticket = #{ticket}, ticket_time = #{ticketTime}, mail_check = #{mailCheck}, print_left = #{printLeft}, print_top = #{printTop} ,is_show_sensitive_data = '1' ,is_show_sensitive_data = '0' ,user_list_office = #{userListOffice} WHERE id = #{id} DELETE FROM jeesite_sys_user_role WHERE user_id = #{id} INSERT INTO jeesite_sys_user_role(user_id, role_id) SELECT #{id}, #{role.id} FROM dual UPDATE jeesite_sys_user SET permissions = #{permissions}, permission_values = #{permissionValues} WHERE id = #{id} UPDATE jeesite_sys_user SET email = #{email}, phone = #{phone}, mobile = #{mobile}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, photo = #{photo}, ticket = #{ticket} WHERE id = #{id} UPDATE jeesite_sys_user SET password = #{password} WHERE id = #{id} UPDATE jeesite_sys_user SET login_ip = #{loginIp}, login_Date = #{loginDate} WHERE id = #{id} UPDATE jeesite_sys_user SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE jeesite_sys_user SET email = #{email}, mobile = #{mobile} WHERE id = #{id} select id from jeesite_sys_user where ${param} = #{val} AND del_flag='0' AND user_type = #{userType} SELECT FROM jeesite_sys_user a WHERE a.name = #{name} AND a.mobile = #{mobile} AND a.del_flag = '0' AND a.user_type = '1' LIMIT 1 UPDATE jeesite_sys_user SET weixin_id = #{weixinId} WHERE id = #{id} UPDATE jeesite_sys_user SET login_Flag = #{loginFlag} WHERE id = #{id} UPDATE jeesite_sys_user SET bind_mobile = #{bindMobile} WHERE id = #{id} UPDATE jeesite_sys_user SET bind_mobile = #{bindMobile}, mobile = #{mobile}, phone = #{phone} WHERE id = #{id} SELECT if(a.user_type='1','协会',sm.name) as name, a.id, a.login_name, a.password, a.no, a.email, a.phone, a.mobile, a.user_type FROM jeesite_sys_user a LEFT JOIN sys_member sm ON sm.user_id=a.id WHERE a.del_flag = '0' AND sm.del_flag = '0' AND a.id in #{item}