【UPDATE】修改工艺路线列表接口,物料列表接口BUG
| | |
| | | <if test="shopCode != null and shopCode != ''"> and shop_code = #{shopCode}</if> |
| | | <if test="plantCode != null and plantCode != ''"> and plant_code = #{plantCode}</if> |
| | | <if test="status != null and status != ''"> and status = #{status}</if> |
| | | and status='1' |
| | | </where> |
| | | order by id asc |
| | | </select> |
| | |
| | | <if test="endDate != null and endDate != ''"> and end_date = #{endDate}</if> |
| | | <if test="orgCode != null and orgCode != ''"> and org_code = #{orgCode}</if> |
| | | <if test="itemCode != null and itemCode != ''"> and item_code like '%' || #{itemCode} || '%'</if> |
| | | <if test="orgCode != null and orgCode != ''"> and org_code = #{orgCode}</if> |
| | | and del_flag = '0' |
| | | </where> |
| | | ORDER BY version desc |