| | |
| | | <if test="item != null and item != ''"> |
| | | t.item like concat('%', #{item}, '%') and |
| | | </if> |
| | | <if test="disabled != null and disabled != ''"> |
| | | t.disabled != 1 and -- FIND_IN_SET(t.disabled, #{disabled}) and |
| | | </if> |
| | | </trim> |
| | | order by sort desc |
| | | <trim prefix="limit " > |
| | |
| | | <if test="item != null and item != ''"> |
| | | t.item like concat('%', #{item}, '%') and |
| | | </if> |
| | | <if test="disabled != null and disabled != ''"> |
| | | t.disabled != 1 and -- FIND_IN_SET(t.disabled, #{disabled}) and |
| | | </if> |
| | | </trim> |
| | | </select> |
| | | |
| | |
| | | public List<PltProductQualityInspectionItems> getQualityItems(String proId) { |
| | | Map<String, Object> params = new HashMap<>(); |
| | | params.put("proId", proId);//item start count |
| | | params.put("disabled", "0"); |
| | | //查询符合条件的记录 |
| | | return qualityItemsDao.selectSome(params); |
| | | } |
| | |
| | | public List<PltProductTestInspectionItems> getTestItems(String proId) { |
| | | Map<String, Object> params = new HashMap<>(); |
| | | params.put("proId", proId); |
| | | params.put("disabled", "0"); |
| | | return testItemsDao.selectSome(params); |
| | | } |
| | | |