WmsInboundScanResultController.java 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461
  1. package com.steerinfo.dil.controller;
  2. import com.github.pagehelper.PageHelper;
  3. import com.steerinfo.dil.feign.BmsTruckFeign;
  4. import com.steerinfo.dil.feign.ColumnDataFeign;
  5. import com.steerinfo.dil.feign.OmsFeign;
  6. import com.steerinfo.dil.feign.TmstruckFeign;
  7. import com.steerinfo.dil.mapper.WmspInboundResultMapper;
  8. import com.steerinfo.dil.model.*;
  9. import com.steerinfo.dil.service.impl.RmsMaterialServiceImpl;
  10. import com.steerinfo.dil.service.impl.RmsMaterialSteelServiceImpl;
  11. import com.steerinfo.dil.service.impl.WmsInboundResultServiceImpl;
  12. import com.steerinfo.dil.service.impl.WmsInboundScanResultServiceImpl;
  13. import com.steerinfo.dil.util.BaseRESTfulController;
  14. import com.steerinfo.dil.util.ColumnDataUtil;
  15. import com.steerinfo.dil.util.DataChange;
  16. import com.steerinfo.dil.util.PageListAdd;
  17. import com.steerinfo.framework.controller.RESTfulResult;
  18. import io.swagger.annotations.ApiImplicitParam;
  19. import io.swagger.annotations.ApiImplicitParams;
  20. import io.swagger.annotations.ApiOperation;
  21. import org.springframework.beans.factory.annotation.Autowired;
  22. import org.springframework.core.annotation.Order;
  23. import org.springframework.transaction.annotation.Transactional;
  24. import org.springframework.web.bind.annotation.PostMapping;
  25. import org.springframework.web.bind.annotation.RequestBody;
  26. import org.springframework.web.bind.annotation.RequestMapping;
  27. import org.springframework.web.bind.annotation.RestController;
  28. import java.math.BigDecimal;
  29. import java.text.DateFormat;
  30. import java.text.ParseException;
  31. import java.util.*;
  32. /**
  33. * @author luobang
  34. * @create 2021-09-07 15:15
  35. */
  36. @RestController
  37. @RequestMapping("${api.version}/inboundScanResult")
  38. public class WmsInboundScanResultController extends BaseRESTfulController {
  39. @Autowired
  40. WmsInboundResultServiceImpl wmsInboundResultService;
  41. @Autowired
  42. WmsInboundScanResultServiceImpl wmsInboundScanResultService;
  43. @Autowired
  44. RmsMaterialServiceImpl rmsMaterialService;
  45. @Autowired
  46. RmsMaterialSteelServiceImpl rmsMaterialSteelService;
  47. @Autowired
  48. WmspInboundResultMapper wmspInboundResultMapper;
  49. @Autowired
  50. ColumnDataUtil columnDataUtil;
  51. @Autowired
  52. ColumnDataFeign columnDataFeign;
  53. @Autowired
  54. OmsFeign omsFeign;
  55. @Autowired
  56. BmsTruckFeign bmsTruckFeign;
  57. @Autowired
  58. TmstruckFeign tmstruckFeign;
  59. @Autowired
  60. WmsInboundResultController inboundResultController;
  61. /**
  62. * 1.新增扫描吊牌实绩!!!此时入库实绩未生成
  63. * @param
  64. * @return
  65. */
  66. @ApiOperation(value = "新增扫描吊牌实绩")
  67. @PostMapping("/insertResult")
  68. @Transactional
  69. public synchronized RESTfulResult insertResult(@RequestBody(required = false)Map<String,Object>map) throws Exception {
  70. //这里需要的参数包括 扫码人账号 userId、二维码信息 resultMaterial
  71. //首先判断二维码是否已经被扫过了
  72. //判断条件是查询扫描实绩判断是否已经存在改唯一标识码并且扫码人是否是自己
  73. System.out.println(map.get("resultMaterial"));
  74. //订单类型为倒库,直接扫码所有并返回数据
  75. Map<String,Object> order=wmsInboundScanResultService.getOrderTypeByNum((String)map.get("resultMaterial"));
  76. if(order !=null && order.get("orderType")!=null && DataChange.dataToBigDecimal(order.get("orderType")).intValue() == 25){
  77. Integer orderType=DataChange.dataToBigDecimal(order.get("orderType")).intValue();
  78. BigDecimal orderId=DataChange.dataToBigDecimal(order.get("orderId"));
  79. //校验是否有装货实绩,若没有则不允许入库
  80. Integer count=wmsInboundScanResultService.isExistLoad((String)map.get("resultMaterial"));
  81. if(count==null|| count<=0){
  82. return failed(null);
  83. }
  84. //根据运输订单号查询出库扫码实绩
  85. List<Map<String,Object>> inboundOld= wmsInboundScanResultService.findInboundScanResult((String)map.get("resultMaterial"));
  86. //批量新增扫码实绩
  87. if(inboundOld!=null || inboundOld.size()>0 || inboundOld.get(0)!=null){
  88. wmsInboundScanResultService.createInboundScanResultByFind(inboundOld,map);
  89. }
  90. else{
  91. System.out.println("物资暂未出库,请先出库再入库!");
  92. return failed(null);
  93. }
  94. //返回新建的扫码实绩数据
  95. List<Map<String,Object>> mapList= wmsInboundScanResultService.noIssueScanResultList(map.get("userName").toString());
  96. //新增卸货实绩
  97. tmstruckFeign.updateUnloadResult(order);
  98. //关闭运输订单
  99. omsFeign.closeInwardOrder(orderId.intValue(),2,null);
  100. //生成计费详单
  101. bmsTruckFeign.addInwardDetailsOrder(order);
  102. return success(mapList);
  103. }
  104. int isExist= wmsInboundScanResultService.isExist(map.get("userName").toString(),map.get("resultMaterial").toString().substring(0,map.get("resultMaterial").toString().length()-1));
  105. //通过用户ID查询、当前扫描没有下发的物质、最终展示的集合
  106. List<Map<String,Object>>mapList= wmsInboundScanResultService.noIssueScanResultList(map.get("userName").toString());
  107. if (isExist>0){
  108. //如果已经被扫过了返回扫码实绩集合
  109. //返回结果显示
  110. return failed(mapList);
  111. }else {
  112. //如果没有被扫
  113. //创建一个扫码实绩
  114. Map<String, Object> wmspInboundScanResult =wmsInboundScanResultService.createInboundScanResultByResultMaterial(mapList.size(),map.get("userName").toString(),map.get("resultMaterial").toString(),""+map.get("hookNo"));
  115. //判断是否创建成功、成功在添加
  116. // if (wmspInboundScanResult!=null){
  117. // mapList.add(wmspInboundScanResult);
  118. // }
  119. mapList= wmsInboundScanResultService.noIssueScanResultList(map.get("userName").toString());
  120. }
  121. System.out.println(mapList);
  122. return success(mapList);
  123. }
  124. /**
  125. * 1.新增扫描吊牌实绩!!!此时入库实绩未生成
  126. * @param
  127. * @return
  128. */
  129. @ApiOperation(value = "新增扫描吊牌实绩")
  130. @PostMapping("/insertScanResultGroup")
  131. @Transactional
  132. public synchronized RESTfulResult insertScanResultGroup(@RequestBody(required = false)Map<String,Object>map) throws ParseException {
  133. //这里需要的参数包括 扫码人账号 userId、二维码信息 resultMaterial
  134. //首先判断二维码是否已经被扫过了
  135. int isExist= wmsInboundScanResultService.isExistInboundScanResult(map.get("resultMaterial").toString().substring(0,map.get("resultMaterial").toString().length()-1));
  136. //通过用户ID查询、当前扫描没有下发的物质、最终展示的集合
  137. List<Map<String,Object>>mapList= wmsInboundScanResultService.noIssueScanResultList(map.get("userName").toString());
  138. if (isExist>0){
  139. //如果已经被少扫过了返回扫码实绩集合
  140. //返回结果显示
  141. return failed(mapList);
  142. }else {
  143. //如果没有被扫
  144. //创建一个扫码实绩
  145. Map<String, Object> wmspInboundScanResult =wmsInboundScanResultService.createInboundScanResultByResultMaterial(mapList.size(),map.get("userName").toString(),map.get("resultMaterial").toString(),""+map.get("hookNo"));
  146. //判断是否创建成功、成功在添加
  147. // if (wmspInboundScanResult!=null){
  148. // mapList.add(wmspInboundScanResult);
  149. // }
  150. mapList= wmsInboundScanResultService.noIssueScanResultList(map.get("userName").toString());
  151. }
  152. return success(mapList);
  153. }
  154. /**
  155. * 1.新增扫描吊牌实绩!!!此时入库实绩未生成
  156. * @param
  157. * @return
  158. */
  159. @ApiOperation(value = "新增扫描吊牌实绩")
  160. @PostMapping("/insertResult2")
  161. @Transactional
  162. public synchronized RESTfulResult insertResult2(@RequestBody(required = false)Map<String,Object>map) throws ParseException {
  163. int i=0;
  164. WmspInboundScanResult wmspInboundScanResult = new WmspInboundScanResult();
  165. //获取工号查找id
  166. BigDecimal loadId = wmsInboundScanResultService.getLoadId(map);
  167. map.put("loadId",loadId);
  168. BigDecimal inboundResultId = new BigDecimal((Integer)map.get("inboundId"));
  169. //判断是否重复扫码
  170. //调用判断是否重复扫码的方法
  171. if(inboundResultId.intValue() == -1){
  172. if(wmsInboundScanResultService.checkScanTag(map,loadId) == 0){
  173. List<Map<String,Object>>mapList =wmsInboundScanResultService.getScanResult(loadId);
  174. return failed(mapList);
  175. }
  176. }
  177. wmspInboundScanResult.setResultId(new BigDecimal(String.valueOf(wmsInboundScanResultService.count())));
  178. //设置入库物资件数,默认一件
  179. wmspInboundScanResult.setInboundMaterialNumber(new BigDecimal(1));
  180. //设置吊钢工已扫物资件数
  181. wmspInboundScanResult.setResultNumber(new BigDecimal(wmsInboundScanResultService.scanNumber(map)+1));
  182. map.put("resultNumber",wmspInboundScanResult.getResultNumber());
  183. //设置常规字段 插入人为吊钢工的名字
  184. wmspInboundScanResult.setInsertTime(new Date());
  185. //设置吊钢工扫描吊牌时间
  186. wmspInboundScanResult.setResultLoadTime(new Date());
  187. //设置状态为未下发
  188. wmspInboundScanResult.setResultStatus(new BigDecimal(0));
  189. //设置吊钢工Id
  190. wmspInboundScanResult.setLoadId(loadId);
  191. //设置扫描吊牌实绩
  192. String str = (String) map.get("resultMaterial");
  193. wmspInboundScanResult.setResultMaterial(str);
  194. //设置入库实绩ID
  195. if (inboundResultId.intValue() != -1){
  196. BigDecimal hh=wmspInboundScanResult.getInboundResultId() ;
  197. wmspInboundScanResult.setInboundResultId(inboundResultId);
  198. wmspInboundScanResult.setResultStatus(new BigDecimal(1));
  199. }
  200. //设置逻辑删除字段
  201. wmspInboundScanResult.setResultDeleted(new BigDecimal(1));
  202. //新增钢材物资ID
  203. Integer k = rmsMaterialSteelService.insertRmsMaterialSteel(str,""+map.get("hookNo"));
  204. wmspInboundScanResult.setMaterialId(new BigDecimal(k));
  205. //根据班次班组查找同一车间的另一位小伙伴
  206. //判断物资是否为线材
  207. BigDecimal count = wmsInboundScanResultService.selectMaterialTypeByMaterialId(new BigDecimal(k));
  208. wmspInboundScanResult.setInboundAbnormalis(new BigDecimal(0));
  209. if(count != null){
  210. BigDecimal otherLoadId = wmsInboundScanResultService.getOtherLoadId(map);
  211. map.put("otherLoadId",otherLoadId);
  212. //查找另一位兄弟的相同次数的扫描实绩里面的物资ID
  213. Integer otherMaterialId = wmsInboundScanResultService.getOtherMaterialSteelId(map);
  214. if (otherMaterialId==k) {
  215. wmspInboundScanResult.setInboundAbnormalis(new BigDecimal(1));
  216. }
  217. else{
  218. wmspInboundScanResult.setInboundAbnormalis(new BigDecimal(0));
  219. }
  220. }
  221. //插入扫描吊牌实绩
  222. Integer integer = wmsInboundScanResultService.insertWmsInboundScanResult(wmspInboundScanResult);
  223. System.out.println("-----------"+integer);
  224. if (integer!=1){
  225. return failed();
  226. }
  227. //判断物资是否为线材
  228. if(count != null){
  229. //如果不为线材
  230. //更新异常值
  231. wmsInboundScanResultService.updateInboundAbnormal(map);
  232. }
  233. List<Map<String,Object>>mapList =wmsInboundScanResultService.getScanResult(loadId);
  234. return success(mapList);
  235. }
  236. /**
  237. * 展示未下发扫描实绩
  238. * @return
  239. */
  240. @ApiOperation(value="展示未下发扫描实绩")
  241. @PostMapping("/getScanResult")
  242. public RESTfulResult getScanResult(@RequestBody(required = false) Map<String,Object>map){
  243. BigDecimal loadId = wmsInboundScanResultService.getLoadId(map);
  244. map.put("loadId",loadId);
  245. List<Map<String,Object>>mapList =wmsInboundScanResultService.getScanResult(loadId);
  246. return success(mapList);
  247. }
  248. /**
  249. *
  250. * @return
  251. */
  252. @ApiOperation(value="展示垛位")
  253. @PostMapping("/selectStackingInfoByWarehouseId")
  254. public RESTfulResult selectStackingInfoByWarehouseId(@RequestBody(required = false) Map<String,Object>map){
  255. List<Map<String,Object>>mapList =wmsInboundScanResultService.selectStacking(map);
  256. return success(mapList);
  257. }
  258. /**
  259. *
  260. * @return
  261. */
  262. @ApiOperation(value="更新状态")
  263. @PostMapping("/updateStatus")
  264. public RESTfulResult updateStatus(@RequestBody(required = false) Map<String,Object>map){
  265. Integer integer =wmsInboundScanResultService.updateStatus(map);
  266. return success(integer);
  267. }
  268. /**
  269. * 展示异常入库吊钢工扫描吊牌实绩
  270. * @return
  271. */
  272. @ApiOperation(value="展示异常入库吊钢工扫描吊牌实绩")
  273. @PostMapping("/getIssuedTagNoResult")
  274. public RESTfulResult getIssuedTagNoResult(){
  275. HashMap<String, Object> map = new HashMap<>();
  276. List<Map<String, Object>> scanIssuedTagResult = wmsInboundScanResultService.getIssuedScanTagNoResult(map);
  277. return success(scanIssuedTagResult);
  278. }
  279. //根据入库实绩id查找扫描实绩
  280. @PostMapping("/selectScanResultByIboundResultId")
  281. @ApiOperation(value = "根据入库实绩id获得扫描实绩数据")
  282. @ApiImplicitParams({
  283. @ApiImplicitParam(name = "apiId", value = "", required = false, dataType = "BigDecimal"),
  284. })
  285. public RESTfulResult selectScanResultByIboundResultId(@RequestBody(required = false) Map<String, Object> mapValue,
  286. Integer apiId,
  287. Integer pageNum,
  288. Integer pageSize,
  289. Integer inboundId) {
  290. if (inboundId!=null){
  291. mapValue.put("inboundId",inboundId);
  292. }
  293. List<Map<String, Object>> reboundResultTotal = wmsInboundResultService.selectScanResultByIboundResultId(mapValue);
  294. List<Map<String, Object>> columnDataList = columnDataFeign.getColumnData(apiId);
  295. /*分页*/
  296. PageHelper.startPage(pageNum, pageSize);
  297. /*返回中英文对照结果,计算表头*/
  298. List<Map<String, Object>> reboundResult = wmsInboundResultService.selectScanResultByIboundResultId(mapValue);
  299. for (Map<String, Object> columnData : columnDataList) {
  300. columnData.put("filters", setListMap(reboundResultTotal, columnData.get("prop").toString()));
  301. }
  302. PageListAdd pageList = new PageListAdd(reboundResult);
  303. pageList.setColumnData(columnDataList);
  304. return success(pageList);
  305. }
  306. Set<Map<String, Object>> setListMap(List<Map<String, Object>> list, String name) {
  307. Set<Map<String, Object>> setString = new HashSet<>();
  308. for (Map<String, Object> map : list) {
  309. Map<String, Object> map1 = new HashMap<>();
  310. map1.put("text", map.get(name));
  311. if (map.get(name) != null) {
  312. //判断是否是运力类型
  313. if ("capacity_type".equals(name)) {
  314. switch (map.get(name).toString().trim()) {
  315. case "自有电车":
  316. map1.put("value", 0);
  317. break;
  318. case "自有汽车":
  319. map1.put("value", 1);
  320. break;
  321. case "社会车辆":
  322. map1.put("value", 2);
  323. break;
  324. }
  325. } else {
  326. map1.put("value", map.get(name));
  327. }
  328. setString.add(map1);
  329. }
  330. }
  331. return setString;
  332. }
  333. // 根据index找到对应的成品并改变其入库状态
  334. @ApiOperation(value="展示垛位")
  335. @PostMapping("/changeInboundIscomplete")
  336. public RESTfulResult changeInboundIscomplete(@RequestBody(required = false) Map<String,Object>map){
  337. Integer stackResultId1= (Integer) map.get("stackResultId");
  338. BigDecimal stackResultId=new BigDecimal(stackResultId1);
  339. int result =wmsInboundScanResultService.changeInboundIscomplete(stackResultId);
  340. return success(result);
  341. }
  342. /**
  343. * 1.新增退货扫描吊牌实绩!!!此时入库实绩未生成
  344. * @param
  345. * @return
  346. */
  347. @ApiOperation(value = "新增扫描吊牌实绩")
  348. @PostMapping("/insertReboundScanResult")
  349. @Transactional
  350. public synchronized RESTfulResult insertReboundScanResult(@RequestBody(required = false)Map<String,Object>map) throws ParseException {
  351. //判断自己是否已经扫过了、并且没有出库过
  352. int isExist= wmsInboundScanResultService.isExist2(map.get("userName").toString(),map.get("resultMaterial").toString().substring(0,map.get("resultMaterial").toString().length()-1));
  353. //通过用户ID查询、当前扫描没有下发的物质、最终展示的集合
  354. List<Map<String,Object>>mapList= wmsInboundScanResultService.noIssueScanResultList2(map.get("userName").toString());
  355. if (isExist>0){
  356. //如果已经被少扫过了返回扫码实绩集合
  357. //返回结果显示
  358. return failed(mapList);
  359. }else {
  360. //如果没有被扫
  361. //创建一个扫码实绩
  362. Map<String, Object> wmspInboundScanResult =wmsInboundScanResultService.createInboundScanResultByResultMaterial2(mapList.size(),map.get("userName").toString(),map.get("resultMaterial").toString(),""+map.get("hookNo"));
  363. //判断是否创建成功、成功在添加
  364. if (wmspInboundScanResult!=null){
  365. mapList.add(wmspInboundScanResult);
  366. }
  367. }
  368. return success(mapList);
  369. }
  370. @ApiOperation(value = "补录吊牌入库实绩")
  371. @PostMapping("/recordScanResult")
  372. @Transactional
  373. public synchronized RESTfulResult recordScanResult(@RequestBody(required = false)Map<String,Object> map) throws Exception {
  374. //System.out.println(map);
  375. if(map.get("materialOnlyCode") != null && DataChange.dataToBigDecimal(map.get("deleteFlag")).intValue() == 1) {
  376. //走删除接口
  377. int i = wmsInboundScanResultService.deleteMaterialSteelMes(map);
  378. if(i == 0) {
  379. return failed("物资不存在");
  380. }
  381. return success();
  382. }
  383. if(map.get("number")==null){
  384. //return failed("请输入数量");
  385. map.put("number",1);
  386. }
  387. if(map.get("materialCode")==null){
  388. return failed("请输入物资编码");
  389. }
  390. if(map.get("furnaceNumber")==null){
  391. return failed("请输入炉号");
  392. }
  393. if(map.get("userName")==null){
  394. map.put("userName","L1267");
  395. //return failed("请输入用户名");
  396. }
  397. if(map.get("theoreticalWeight")==null){
  398. return failed("请输入理重");
  399. }
  400. if(map.get("warehouseId")==null && map.get("warehouseName") == null){
  401. return failed("请输入仓库id");
  402. }
  403. //根据仓库名称寻找仓库id
  404. BigDecimal warehouseId = wmspInboundResultMapper.selectWarehouseIdByName(map.get("warehouseName").toString());
  405. if(warehouseId != null) {
  406. map.put("warehouseId",warehouseId);
  407. }
  408. Integer number=Integer.parseInt(map.get("number").toString());
  409. String userName=map.get("userName").toString();
  410. if(number<=0){
  411. return failed("数量错误,结束");
  412. }
  413. //创建扫描实绩
  414. List<Map<String,Object>> resultMaterials=wmsInboundScanResultService.createResultMaterials(map);//创建吊牌
  415. wmsInboundScanResultService.createInboundScanResultByFind(resultMaterials,map);//新增扫描实绩
  416. List<Map<String,Object>> inboundScans=wmsInboundScanResultService.noIssueScanResultList(userName);//查询入库扫描实绩
  417. //创建入库实绩
  418. BigDecimal groupId=new BigDecimal(2),personnelWorkshopid=DataChange.dataToBigDecimal(map.get("warehouseId").toString());
  419. return inboundResultController.addInvoice(userName,groupId,personnelWorkshopid,inboundScans,"物流系统补录");
  420. }
  421. }