| | |
|---|
| | | |
|---|
| | | <select id="groupUserWorking" resultType="com.thhy.staff.modules.biz.platuser.entity.GroupWorking"> |
|---|
| | | select sg.group_id as groupId,sg.group_name as groupName, |
|---|
| | | (select count(user_id) from sys_group_user where and is_use = 1 and group_id = sg.group_id) as groupUserCount |
|---|
| | | (select count(user_id) from sys_group_user where is_use = 1 and group_id = sg.group_id) as groupUserCount |
|---|
| | | from sys_group sg |
|---|
| | | left join sys_com_depart sd on sg.depart_id = sd.depart_id |
|---|
| | | where sg.is_use = 1 and sd.company_id = #{companyId} |
|---|
