WmsInboundScanResultServiceImpl.java 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395
  1. package com.steerinfo.dil.service.impl;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.TypeReference;
  4. import com.steerinfo.dil.mapper.WmspInboundScanResultMapper;
  5. import com.steerinfo.dil.mapper.WmspInboundStackResultMapper;
  6. import com.steerinfo.dil.model.WmspInboundScanResult;
  7. import com.steerinfo.dil.model.WmspInboundStackResult;
  8. import com.steerinfo.dil.service.IRmsMaterialSteelService;
  9. import com.steerinfo.dil.service.IWmsInboundScanResultService;
  10. import com.steerinfo.dil.service.IWmspInboundGroupService;
  11. import org.springframework.beans.factory.annotation.Autowired;
  12. import org.springframework.stereotype.Service;
  13. import java.math.BigDecimal;
  14. import java.text.ParseException;
  15. import java.text.SimpleDateFormat;
  16. import java.util.Date;
  17. import java.util.HashMap;
  18. import java.util.List;
  19. import java.util.Map;
  20. /**
  21. * @author luobang
  22. * @create 2021-09-07 15:12
  23. */
  24. @Service
  25. public class WmsInboundScanResultServiceImpl implements IWmsInboundScanResultService {
  26. @Autowired
  27. private WmspInboundScanResultMapper wmspInboundScanResultMapper;
  28. @Autowired
  29. private WmspInboundStackResultMapper wmspInboundStackResultMapper;
  30. @Autowired
  31. private IWmspInboundGroupService wmspInboundGroupService;
  32. @Autowired
  33. private IRmsMaterialSteelService rmsMaterialSteelService;
  34. //判断是否重复扫码
  35. @Override
  36. public Integer checkScanTag(Map<String,Object>map,BigDecimal loadId){
  37. //获取扫描吊牌实绩
  38. String resultMaterial = (String) map.get("resultMaterial");
  39. //获取物资扫描实绩
  40. String subResultMaterial = resultMaterial.substring(0,resultMaterial.length() - 1);
  41. Map<String,Object> checkScanMap = new HashMap<>();
  42. checkScanMap.put("resultMaterial",subResultMaterial);
  43. checkScanMap.put("loadId",loadId);
  44. //根据扫描实绩查询出扫描实绩个数
  45. Integer j=(checkScanResult(checkScanMap)).size();
  46. if (j!=0)
  47. return 0;
  48. return 1;
  49. }
  50. /**
  51. * 1.新增吊钢工扫描吊牌实绩
  52. * @param wmspInboundScanResult
  53. * @return
  54. */
  55. @Override
  56. public Integer insertWmsInboundScanResult(WmspInboundScanResult wmspInboundScanResult) {
  57. return wmspInboundScanResultMapper.insertSelective(wmspInboundScanResult);
  58. }
  59. /**
  60. * 2.获取最大ID
  61. * @return
  62. */
  63. @Override
  64. public BigDecimal count() {
  65. return wmspInboundScanResultMapper.getCount();
  66. }
  67. /**
  68. * 3.获取吊钢工最大扫描数
  69. * @param
  70. * @return
  71. */
  72. @Override
  73. public int scanNumber(Map<String, Object> map) {
  74. if (wmspInboundScanResultMapper.getScanNumber(map)==null){
  75. return 0;
  76. }
  77. return wmspInboundScanResultMapper.getScanNumber(map).intValue();
  78. }
  79. /**
  80. * 4.更新扫描吊牌实绩
  81. * @param wmspInboundScanResult
  82. * @return
  83. */
  84. @Override
  85. public Integer updateWmsInboundScanResult(WmspInboundScanResult wmspInboundScanResult) {
  86. return wmspInboundScanResultMapper.updateByPrimaryKeySelective(wmspInboundScanResult);
  87. }
  88. /**
  89. * 更新异常值
  90. // * @param wmspInboundScanResult
  91. * @return
  92. */
  93. @Override
  94. public Integer updateInboundAbnormal(Map<String,Object> map) {
  95. return wmspInboundScanResultMapper.updateInboundAbnormal(map);
  96. }
  97. @Override
  98. public Integer updateWmsInboundScanById(Map<String, Object> map) {
  99. return wmspInboundScanResultMapper.updateInboundScanResult(map);
  100. }
  101. /**
  102. * 获取扫描吊牌实绩
  103. * @param map
  104. * @return
  105. */
  106. @Override
  107. public List<Map<String, Object>> getScanTagResult(Map<String, Object> map) {
  108. return wmspInboundScanResultMapper.selectScanTagResult(map);
  109. }
  110. /**
  111. * 获取正常入库
  112. * @param map
  113. * @return
  114. */
  115. @Override
  116. public List<Map<String, Object>> getIssuedScanTagResult(Map<String, Object> map) {
  117. return wmspInboundScanResultMapper.selectIssuedScanTagResult(map);
  118. }
  119. /**
  120. * 获取异常入库
  121. * @param map
  122. * @return
  123. */
  124. @Override
  125. public List<Map<String, Object>> getIssuedScanTagNoResult(Map<String, Object> map) {
  126. return wmspInboundScanResultMapper.selectIssuedScanTagNoResult(map);
  127. }
  128. /**
  129. * 判断是否重复插入
  130. * @param
  131. * @param
  132. * @return
  133. */
  134. @Override
  135. public List<Map<String, Object>> checkScanResult(Map<String,Object>map) {
  136. return wmspInboundScanResultMapper.checkScanResult(map);
  137. }
  138. /*
  139. 更新退库扫描实绩
  140. */
  141. @Override
  142. public Integer updateWmsReboundScanById(Map<String, Object> map5) {
  143. return wmspInboundScanResultMapper.updateReboundScanResult(map5);
  144. }
  145. /*
  146. 展示已下发退库实绩
  147. */
  148. @Override
  149. public List<Map<String, Object>> getIssuedScanResult(Map<String, Object> map) {
  150. return wmspInboundScanResultMapper.selectReIssuedScanResult(map);
  151. }
  152. /*
  153. 展示未下发退库实绩
  154. */
  155. @Override
  156. public List<Map<String, Object>> getReScanTagResult(Map<String, Object> map) {
  157. return wmspInboundScanResultMapper.selectReScanTagResult(map);
  158. }
  159. /*
  160. 展示已下发退库实绩
  161. */
  162. @Override
  163. public List<Map<String, Object>> getIssuedScanIvResult(Map<String, Object> map) {
  164. return wmspInboundScanResultMapper.selectIvIssuedScanResult(map);
  165. }
  166. /*
  167. 展示未下发退库实绩
  168. */
  169. @Override
  170. public List<Map<String, Object>> getIvScanTagResult(Map<String, Object> map) {
  171. return wmspInboundScanResultMapper.selectIvScanTagResult(map);
  172. }
  173. @Override
  174. public List<Map<String, Object>>getScanResult(BigDecimal loadId) {
  175. return wmspInboundScanResultMapper.getScanResult(loadId);
  176. }
  177. @Override
  178. public BigDecimal getLoadId(Map<String, Object> map) {
  179. return wmspInboundScanResultMapper.getLoadId(map);
  180. }
  181. /**
  182. * 得到另外一个扫描实绩ID
  183. * @param otherLoadMap
  184. * @return
  185. */
  186. @Override
  187. public List<Map<String,Object>> getOntherLoadId(Map<String, Object> otherLoadMap) {
  188. return wmspInboundScanResultMapper.getOtherScanResultId(otherLoadMap);
  189. }
  190. @Override
  191. public BigDecimal getOtherLoadId(Map<String, Object> map) {
  192. return wmspInboundScanResultMapper.getOtherLoadId(map);
  193. }
  194. @Override
  195. public Integer getOtherMaterialSteelId(Map<String, Object> map) {
  196. return wmspInboundScanResultMapper.getOtherMaterialSteelId(map);
  197. }
  198. @Override
  199. public List<Map<String, Object>> selectStacking(Map<String, Object> map) {
  200. return wmspInboundScanResultMapper.selectStackNo(map);
  201. }
  202. @Override
  203. public Integer updateStatus(Map<String, Object> map) {
  204. return wmspInboundScanResultMapper.updataStatus(map);
  205. }
  206. /**
  207. * 判断物资是否为线材
  208. * @param materialId
  209. * @return
  210. */
  211. @Override
  212. public BigDecimal selectMaterialTypeByMaterialId(BigDecimal materialId) {
  213. return wmspInboundScanResultMapper.selectMaterialTypeByMaterialId(materialId);
  214. }
  215. /**
  216. * 判断物质是否已经被扫
  217. * @param userName
  218. * @param resultMaterial
  219. * @return
  220. */
  221. @Override
  222. public int isExist(String userName, String resultMaterial) {
  223. return wmspInboundScanResultMapper.isExist(userName,resultMaterial);
  224. }
  225. /**
  226. * 查询扫描没有下发的物质
  227. * @param userName
  228. * @return
  229. */
  230. @Override
  231. public List<Map<String, Object>> noIssueScanResult(String userName) {
  232. return wmspInboundScanResultMapper.noIssueScanResult(userName);
  233. }
  234. @Override
  235. public Map<String, Object> createInboundScanResultByResultMaterial(Integer scanedCount, String userName,String resultMaterial) throws ParseException {
  236. //创建入库扫描实绩、并且给对象赋值
  237. WmspInboundScanResult wmspInboundScanResult=new WmspInboundScanResult();
  238. //设置主键自增,这里需要修改
  239. wmspInboundScanResult.setId(count());
  240. //获取班次次序的吊牌信息
  241. String[] result = resultMaterial.split("-");
  242. String shiftOrder = result[9];
  243. wmspInboundScanResult.setShiftOrder(shiftOrder);
  244. //分组
  245. //根据用户名和分组状态查询到分组信息
  246. BigDecimal groupId= wmspInboundGroupService.getGroupIdByUserName(userName);
  247. wmspInboundScanResult.setInboundGroupId(groupId);
  248. //吊钢工扫描吊牌结果
  249. wmspInboundScanResult.setResultMaterial(resultMaterial);
  250. //扫描吊牌信息
  251. wmspInboundScanResult.setResultLoadTime(new Date());
  252. //新增钢材物资ID
  253. Map<String,Object> materialSteel = rmsMaterialSteelService.insertRmsMaterialSteel2(resultMaterial);
  254. wmspInboundScanResult.setMaterialId(new BigDecimal(materialSteel.get("materialSteelId").toString()));
  255. //创建用户
  256. //insertUsername
  257. wmspInboundScanResult.setInboundAbnormalis(new BigDecimal(0));
  258. //设置入库物资件数,默认一件
  259. wmspInboundScanResult.setInboundMaterialNumber(new BigDecimal(1));
  260. // 状态:0:未下发;1:已下发
  261. wmspInboundScanResult.setResultStatus(new BigDecimal(0));
  262. //吊钢工已扫物资次数 ,目前已扫描为没有下发的物质
  263. //BigDecimal scanCount= wmspInboundScanResultMapper.getScanedNumber(userId);
  264. wmspInboundScanResult.setResultNumber(new BigDecimal(scanedCount));
  265. //逻辑删除:1:删除,0:未删除
  266. wmspInboundScanResult.setResultDeleted(new BigDecimal(0));
  267. //扫码用户
  268. wmspInboundScanResult.setInsertUsername(userName);
  269. //创建时间
  270. wmspInboundScanResult.setInsertTime(new Date());
  271. int status = wmspInboundScanResultMapper.insertSelective(wmspInboundScanResult);
  272. //判断是否创建成功
  273. if (status>0){
  274. materialSteel.putAll(JSON.parseObject(JSON.toJSONString(wmspInboundScanResult),new TypeReference<Map<String,Object>>(){}));
  275. return materialSteel;
  276. }
  277. return null;
  278. }
  279. @Override
  280. public List<Map<String, Object>> noIssueScanResultList(String userName) {
  281. return wmspInboundScanResultMapper.noIssueScanResultList(userName);
  282. }
  283. @Override
  284. public int changeInboundIscomplete(BigDecimal stackResultId) {
  285. // 根据stackResultId找到对应的成品并修改其状态
  286. WmspInboundStackResult wmspInboundStackResult =new WmspInboundStackResult();
  287. wmspInboundStackResult.setResultId(stackResultId);
  288. wmspInboundStackResult.setStackingStatus(new BigDecimal(1));
  289. return wmspInboundStackResultMapper.updateByPrimaryKeySelective(wmspInboundStackResult);
  290. }
  291. public int updateInboundScanStatus(BigDecimal resultId,BigDecimal inboundId) {
  292. return wmspInboundScanResultMapper.updataStatusByResultId(resultId,inboundId);
  293. }
  294. @Override
  295. public Integer getResultStatusByResultId(String resultId) {
  296. return wmspInboundScanResultMapper.getResultStatusByResultId(resultId);
  297. }
  298. @Override
  299. public int isExist2(String userName, String resultMaterial) {
  300. return wmspInboundScanResultMapper.isExist2(userName,resultMaterial);
  301. }
  302. @Override
  303. public Map<String, Object> createInboundScanResultByResultMaterial2(int scanedCount, String userName, String resultMaterial) throws ParseException {
  304. //创建入库扫描实绩、并且给对象赋值
  305. WmspInboundScanResult wmspInboundScanResult=new WmspInboundScanResult();
  306. //设置主键自增,这里需要修改
  307. wmspInboundScanResult.setId(count());
  308. //分组 只需要扫一次没有分组信息
  309. //根据用户名和分组状态查询到分组信息
  310. // BigDecimal groupId= wmspInboundGroupService.getGroupIdByUserName(userName);
  311. // wmspInboundScanResult.setInboundGroupId(groupId);
  312. //吊钢工扫描吊牌结果
  313. wmspInboundScanResult.setResultMaterial(resultMaterial);
  314. //扫描吊牌信息
  315. wmspInboundScanResult.setResultLoadTime(new Date());
  316. //新增钢材物资ID
  317. Map<String,Object> materialSteel = rmsMaterialSteelService.insertRmsMaterialSteel2(resultMaterial);
  318. wmspInboundScanResult.setMaterialId(new BigDecimal(materialSteel.get("materialSteelId").toString()));
  319. //创建用户
  320. //insertUsername
  321. wmspInboundScanResult.setInboundAbnormalis(new BigDecimal(0));
  322. //设置入库物资件数,默认一件
  323. wmspInboundScanResult.setInboundMaterialNumber(new BigDecimal(1));
  324. // 状态:0:未下发;1:已下发
  325. wmspInboundScanResult.setResultStatus(new BigDecimal(0));
  326. //吊钢工已扫物资次数 ,目前已扫描为没有下发的物质
  327. //BigDecimal scanCount= wmspInboundScanResultMapper.getScanedNumber(userId);
  328. wmspInboundScanResult.setResultNumber(new BigDecimal(scanedCount));
  329. //逻辑删除:1:删除,0:未删除
  330. wmspInboundScanResult.setResultDeleted(new BigDecimal(0));
  331. //扫码用户
  332. wmspInboundScanResult.setInsertUsername(userName);
  333. //创建时间
  334. wmspInboundScanResult.setInsertTime(new Date());
  335. int status = wmspInboundScanResultMapper.insertSelective(wmspInboundScanResult);
  336. //判断是否创建成功
  337. if (status>0){
  338. materialSteel.putAll(JSON.parseObject(JSON.toJSONString(wmspInboundScanResult),new TypeReference<Map<String,Object>>(){}));
  339. return materialSteel;
  340. }
  341. return null;
  342. }
  343. @Override
  344. public List<Map<String, Object>> noIssueScanResultList2(String userName) {
  345. return wmspInboundScanResultMapper.noIssueScanResultList2(userName);
  346. }
  347. }