WmspIvboundMakeResultServiceImpl.java 7.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177
  1. package com.steerinfo.dil.service.impl;
  2. import com.steerinfo.dil.mapper.AmstruckInwardRequirementMapper;
  3. import com.steerinfo.dil.mapper.WmspGridMaterialMapper;
  4. import com.steerinfo.dil.mapper.WmspIvboundMakeMaterialMapper;
  5. import com.steerinfo.dil.mapper.WmspIvboundMakeResultMapper;
  6. import com.steerinfo.dil.model.AmstruckInwardRequirement;
  7. import com.steerinfo.dil.model.WmspGridMaterial;
  8. import com.steerinfo.dil.model.WmspIvboundMakeMaterial;
  9. import com.steerinfo.dil.model.WmspIvboundMakeResult;
  10. import com.steerinfo.dil.service.IWmspIvboundMakeResultService;
  11. import com.steerinfo.dil.util.NoUtil;
  12. import org.springframework.beans.factory.annotation.Autowired;
  13. import org.springframework.stereotype.Service;
  14. import java.math.BigDecimal;
  15. import java.util.Date;
  16. import java.util.List;
  17. import java.util.Map;
  18. /**
  19. * WmspIvboundMakeResult服务实现:
  20. * @author generator
  21. * @version 1.0-SNAPSHORT 2021-12-01 05:46
  22. * 类描述
  23. * 修订历史:
  24. * 日期:2021-12-01
  25. * 作者:generator
  26. * 参考:
  27. * 描述:WmspIvboundMakeResult服务实现
  28. * @see null
  29. * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
  30. */
  31. @Service
  32. public class WmspIvboundMakeResultServiceImpl implements IWmspIvboundMakeResultService {
  33. @Autowired
  34. private WmspIvboundMakeResultMapper wmspIvboundMakeResultMapper;
  35. @Autowired
  36. WmspIvboundMakeMaterialMapper wmspIvboundMakeMaterialMapper;
  37. @Autowired
  38. AmstruckInwardRequirementMapper amstruckInwardRequirementMapper;
  39. @Autowired
  40. WmspGridMaterialMapper wmspGridMaterialMapper;
  41. /**
  42. * 逻辑删除倒库实绩
  43. * @param resultId
  44. * @return
  45. */
  46. @Override
  47. public int deleteIvboundMakeResult(BigDecimal resultId) {
  48. WmspIvboundMakeResult wmspIvboundMakeResult = wmspIvboundMakeResultMapper.selectByPrimaryKey(resultId);
  49. wmspIvboundMakeResult.setDeleted(new BigDecimal(1));
  50. int result = wmspIvboundMakeResultMapper.updateByPrimaryKeySelective(wmspIvboundMakeResult);
  51. return result;
  52. }
  53. /**
  54. * 修改倒库实绩
  55. * @param wmspIvboundMakeResult
  56. * @return
  57. */
  58. @Override
  59. public int updateIvboundMakeResult(WmspIvboundMakeResult wmspIvboundMakeResult) {
  60. int result = wmspIvboundMakeResultMapper.updateByPrimaryKeySelective(wmspIvboundMakeResult);
  61. return result;
  62. }
  63. /**
  64. * 新增倒库实绩
  65. * @param mapValue
  66. * @return
  67. */
  68. @Override
  69. public int addIvboundMakeResult(Map<String, Object> mapValue) {
  70. int result = 0;
  71. WmspIvboundMakeResult wmspIvboundMakeResult = new WmspIvboundMakeResult();
  72. WmspIvboundMakeMaterial wmspIvboundMakeMaterial = new WmspIvboundMakeMaterial();
  73. BigDecimal resultId = wmspIvboundMakeResultMapper.selectResultId();
  74. String resultNo = NoUtil.setResultNo("WDK",resultId);
  75. BigDecimal resultMaterialId = wmspIvboundMakeMaterialMapper.selectResultMaterialId();
  76. // 新仓库id
  77. BigDecimal resultAfterWarehouseId = new BigDecimal((Integer)mapValue.get("resultAfterWarehouseId"));
  78. // 原仓库id
  79. BigDecimal resultBeforeWarehouseId = new BigDecimal((Integer)mapValue.get("resultBeforeWarehouseId"));
  80. // 设置实绩表
  81. wmspIvboundMakeResult.setResultId(resultId);
  82. wmspIvboundMakeResult.setResultNo(resultNo);
  83. wmspIvboundMakeResult.setResultAfterWarehouseId(resultAfterWarehouseId);
  84. wmspIvboundMakeResult.setResultBeforeWarehouseId(resultBeforeWarehouseId);
  85. wmspIvboundMakeResult.setDeleted(new BigDecimal(0));
  86. wmspIvboundMakeResult.setInsertTime(new Date());
  87. wmspIvboundMakeResult.setUpdateTime(new Date());
  88. wmspIvboundMakeResult.setInsertUsername("admin");
  89. wmspIvboundMakeResult.setUpdateUsername("admin");
  90. wmspIvboundMakeResult.setInsertUpdateRemark("无");
  91. result += wmspIvboundMakeResultMapper.insertSelective(wmspIvboundMakeResult);
  92. // 设置倒库物资中间表
  93. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  94. if(mapList==null){
  95. return 0;
  96. }
  97. // 物资钢材id
  98. for (Map<String,Object> map : mapList) {
  99. BigDecimal materialSteelId = new BigDecimal((Integer)map.get("materialId"));
  100. // 原垛位id
  101. BigDecimal beforeStackingId = new BigDecimal((Integer)map.get("stackingId"));
  102. // 原层次
  103. BigDecimal beforeGradutionNumber = new BigDecimal((Integer)map.get("gridGradationNumber"));
  104. wmspIvboundMakeMaterial.setResultMaterialId(resultMaterialId);
  105. wmspIvboundMakeMaterial.setResultId(resultId);
  106. wmspIvboundMakeMaterial.setMaterialSteelId(materialSteelId);
  107. wmspIvboundMakeMaterial.setBeforeStackingId(beforeStackingId);
  108. wmspIvboundMakeMaterial.setBeforeGradutionNumber(beforeGradutionNumber);
  109. wmspIvboundMakeMaterial.setInsertTime(new Date());
  110. wmspIvboundMakeMaterial.setUpdateTime(new Date());
  111. wmspIvboundMakeMaterial.setInsertUsername("admin");
  112. wmspIvboundMakeMaterial.setUpdateUsername("admin");
  113. wmspIvboundMakeMaterial.setInsertUpdateRemark("无");
  114. // 修改实时库存
  115. // BigDecimal gmId = DataChange(map.get("GridId"));
  116. BigDecimal gmId = wmspIvboundMakeResultMapper.selectGmId(materialSteelId);
  117. WmspGridMaterial wmspGridMaterial = wmspGridMaterialMapper.selectByPrimaryKey(gmId);
  118. wmspGridMaterial.setStatus(new BigDecimal(1));
  119. wmspGridMaterialMapper.updateByPrimaryKeySelective(wmspGridMaterial);
  120. result += wmspIvboundMakeMaterialMapper.insertSelective(wmspIvboundMakeMaterial);
  121. }
  122. // 新增用车需求
  123. AmstruckInwardRequirement amstruckInwardRequirement = new AmstruckInwardRequirement();
  124. BigDecimal requirementId = amstruckInwardRequirementMapper.selectOtherId();
  125. String requirementNumber = NoUtil.setResultNo("YSXQ",requirementId);
  126. amstruckInwardRequirement.setRequirementId(requirementId);
  127. amstruckInwardRequirement.setRequirementNumber(requirementNumber);
  128. amstruckInwardRequirement.setRequirementTruckTime(new Date());
  129. amstruckInwardRequirement.setRequirementWorkType(new BigDecimal(0));
  130. amstruckInwardRequirement.setRequiremntUnitId(resultBeforeWarehouseId);
  131. amstruckInwardRequirement.setRequirementStatus(new BigDecimal(0));
  132. amstruckInwardRequirement.setDeleted(new BigDecimal(0));
  133. amstruckInwardRequirement.setRequirementUnloadUnitId(resultAfterWarehouseId);
  134. amstruckInwardRequirement.setRequirementLinkType(new BigDecimal(0));
  135. amstruckInwardRequirement.setInsertTime(new Date());
  136. amstruckInwardRequirement.setInsertUsername("admin");
  137. amstruckInwardRequirement.setInsertUpdateRemark("无");
  138. result += amstruckInwardRequirementMapper.insertSelective(amstruckInwardRequirement);
  139. return result;
  140. }
  141. /**
  142. * 查询倒库实绩
  143. * @param resultId
  144. * @return
  145. */
  146. @Override
  147. public List<Map<String, Object>> selectIvboundMakeResult(BigDecimal resultId) {
  148. return wmspIvboundMakeResultMapper.selectIvboundMakeResult(resultId);
  149. }
  150. /**
  151. * 展示倒库实绩
  152. * @param mapVal
  153. * @return
  154. */
  155. @Override
  156. public List<Map<String, Object>> getIvboundMakeResultList(Map<String, Object> mapVal) {
  157. List<Map<String,Object>> mapList = wmspIvboundMakeResultMapper.getIvboundMakeResultList(mapVal);
  158. for (Map<String,Object> map : mapList) {
  159. map.put("materialNumber",1);
  160. }
  161. return mapList;
  162. }
  163. }