| | |
| | | List<QualityUnqualified> qualityUnqualifiedExport(@Param("qualityUnqualified") QualityUnqualified qualityUnqualified); |
| | | |
| | | QualityUnqualified getUnqualified(@Param("id") Integer id); |
| | | |
| | | //手动新增不合格的时候,根据产品名称和规格型号查出对应的规格型号id |
| | | Long getModelId(@Param("productName") String productName, @Param("model") String model); |
| | | } |
| | |
| | | break; |
| | | } |
| | | } else { |
| | | //查询对应的规格型号id |
| | | Long modelId = qualityUnqualifiedMapper.getModelId(qualityUnqualified.getProductName(), qualityUnqualified.getModel()); |
| | | switch (qualityUnqualified.getDealResult()) { |
| | | case "报废": |
| | | //调用不合格库存接口 入不合格库 |
| | | stockUtils.addUnStock(Long.valueOf(unqualified.getModel()), unqualified.getQuantity(), StockInUnQualifiedRecordTypeEnum.DEFECTIVE_SCRAP.getCode(), unqualified.getId()); |
| | | stockUtils.addUnStock(modelId, unqualified.getQuantity(), StockInUnQualifiedRecordTypeEnum.DEFECTIVE_SCRAP.getCode(), unqualified.getId()); |
| | | break; |
| | | case "让步放行": |
| | | //调用提交合格的接口 |
| | | stockUtils.addStock(Long.valueOf(unqualified.getModel()), unqualified.getQuantity(), StockInQualifiedRecordTypeEnum.DEFECTIVE_PASS.getCode(), unqualified.getId()); |
| | | stockUtils.addStock(modelId, unqualified.getQuantity(), StockInQualifiedRecordTypeEnum.DEFECTIVE_PASS.getCode(), unqualified.getId()); |
| | | break; |
| | | default: |
| | | break; |
| | |
| | | 1=1 |
| | | and qu.id = #{id} |
| | | </select> |
| | | <select id="getModelId" resultType="java.lang.Long"> |
| | | select pm.id |
| | | from product_model pm |
| | | left join product p on pm.product_id=p.id |
| | | where pm.model=#{model} |
| | | and p.product_name=#{productName} |
| | | </select> |
| | | </mapper> |