| | |
| | | WHERE |
| | | a.deleted=0 |
| | | <if test="departmentId != null and departmentId.size() > 0"> |
| | | AND b.department_id IN <foreach collection="departmentId" item="item" index="index" open="(" separator="," close=")"> #{item} </foreach> |
| | | AND b.department_id IN <foreach collection="departmentId" item="item" open="(" separator="," close=")"> #{item} </foreach> |
| | | </if> |
| | | <if test="userName != null and userName != ''"> |
| | | AND real_name LIKE concat('%',#{userName},'%') |
| | |
| | | <if test="role != null and role.size() > 0"> |
| | | AND role IN <foreach collection="role" item="item" open="(" separator="," close=")"> #{item} </foreach> |
| | | </if> |
| | | GROUP BY a.id |
| | | </select> |
| | | |
| | | |