ArrangeDutyOperateMiniDao_getUserNoLeave.sql 310 B

123456789101112131415161718192021
  1. <#--查询userList中没离职的id-->
  2. select
  3. GROUP_CONCAT(userid) as useridStr
  4. from t_bus_user_personnel
  5. where leave_date is null
  6. <#if ( useridList )?? && useridList ?size gt 0>
  7. and userid in(
  8. <#list useridList as item>
  9. '${item}'
  10. <#if item_has_next>,</#if>
  11. </#list>
  12. )
  13. </#if>