| | |
| | | <script> |
| | | select distinct factory || '##' || material_code from aps_material_product_group_management |
| | | where 1 = 0 |
| | | <if test="!facs.isEmpty()">or factory in |
| | | <foreach collection="facs" item="item" open="(" separator="," close=")"> |
| | | <if test="!keys.isEmpty()">or factory || '##' || material_code in |
| | | <foreach collection="keys" item="item" open="(" separator="," close=")"> |
| | | #{item} |
| | | </foreach> |
| | | </if> |
| | | <if test="!facs.isEmpty()">or material_code in |
| | | <foreach collection="codes" item="item" open="(" separator="," close=")"> |
| | | #{item} |
| | | </foreach> |
| | | </if> |
| | | </foreach> |
| | | </if> |
| | | </script> |
| | | """) |
| | | Set<String> selectByFacOrMaterial(@NotNull Set<String> facs, @NotNull Set<String> codes); |
| | | Set<String> selectByFacOrMaterial(@NotNull Set<String> keys); |
| | | } |