| 123456789101112131415161718192021 |
- <#--查询userList中没离职的id-->
- select
- GROUP_CONCAT(userid) as useridStr
- from t_bus_user_personnel
- where leave_date is null
- <#if ( useridList )?? && useridList ?size gt 0>
- and userid in(
- <#list useridList as item>
- '${item}'
- <#if item_has_next>,</#if>
- </#list>
- )
- </#if>
|