package com.zy.asrs.controller; import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.plugins.Page; import com.core.annotations.AppAuth; import com.core.common.*; import com.core.exception.CoolException; import com.zy.asrs.domain.dto.AxisBean; import com.zy.asrs.domain.dto.WorkChartAxis; import com.zy.asrs.domain.vo.LocChartPie; import com.zy.asrs.entity.LocDetl; import com.zy.asrs.entity.Mat; import com.zy.asrs.entity.WrkDetl; import com.zy.asrs.entity.WrkMast; import com.zy.asrs.entity.param.*; import com.zy.asrs.mapper.ReportQueryMapper; import com.zy.asrs.service.*; import com.zy.common.model.DetlDto; import com.zy.common.web.BaseController; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletRequest; import java.text.SimpleDateFormat; import java.util.*; import java.util.concurrent.TimeUnit; /** * Created by vincent on 2022/4/8 */ @Slf4j @RestController @RequestMapping("open/asrs") public class OpenController extends BaseController { private static final boolean auth = true; public static final ArrayList APP_KEY_LIST = new ArrayList() {{ add("ea1f0459efc02a79f046f982767939ae"); }}; @Autowired private OpenService openService; @Autowired private WrkMastService wrkMastService; @Autowired private WorkService workService; @Autowired private WrkDetlService wrkDetlService; @Autowired private ReportQueryMapper reportQueryMapper; @Autowired private LocDetlService locDetlService; @Autowired private MatService matService; /** * 任务查询接口 */ @PostMapping("/queryTask") public synchronized R queryTask(@RequestBody QueryTaskParam param) { if (Cools.isEmpty(param)) { return R.parse(BaseRes.PARAM); } if (Cools.isEmpty(param.getTaskNo())) { return R.error("任务号[taskNo]不能为空"); } WrkMast wrkMast = wrkMastService.selectByTaskNo(param.getTaskNo()); if (wrkMast == null) { return R.error("任务不存在"); } List wrkDetls = wrkDetlService.selectByWrkNo(Integer.valueOf(param.getTaskNo())); HashMap map = new HashMap<>(); map.put("taskNo", param.getTaskNo()); map.put("ioType", wrkMast.getIoType()); map.put("wrkDetls", wrkDetls); return R.ok().add(map); } /** * 库存信息查询接口 */ @GetMapping("/queryLoc") public synchronized R queryLoc() { List> pie = new ArrayList<>(); LocChartPie locUseRate = reportQueryMapper.getLocUseRate(); if (locUseRate != null) { Map map = new HashMap<>(); map.put("name", "在库"); map.put("value", locUseRate.getFqty()); pie.add(map); Map map1 = new HashMap<>(); map1.put("name", "空"); map1.put("value", locUseRate.getOqty()); pie.add(map1); Map map2 = new HashMap<>(); map2.put("name", "使用"); map2.put("value", locUseRate.getUqty()); pie.add(map2); Map map3 = new HashMap<>(); map3.put("name", "禁用"); map3.put("value", locUseRate.getXqty()); pie.add(map3); } // 总库位数 Integer total = (int) Arith.add(0, locUseRate.getFqty(), locUseRate.getOqty(), locUseRate.getUqty(), locUseRate.getXqty()); // 使用中 Integer used = locUseRate.getFqty() + locUseRate.getUqty(); // 库位使用率 double usedDivides = Arith.divides(3, used, total); double usedPr = Arith.multiplys(1, usedDivides, 100); return R.ok( Cools.add("pie", pie) .add("stockCount", locUseRate.getFqty()) .add("emptyCount", locUseRate.getOqty()) .add("disableCount", locUseRate.getXqty()) .add("total", total) .add("used", used) .add("usedPr", usedPr) ); } @GetMapping("/line/charts") public R locIoLineCharts(){ Map map=new HashMap(); List list = new ArrayList(); List listChart = reportQueryMapper.getChartAxis(); if(listChart!=null) { ArrayList data1 = new ArrayList(); ArrayList data2 = new ArrayList(); SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd"); Calendar calendar = Calendar.getInstance(); calendar.add(Calendar.DATE, -12); for(int i=0;i<12;i++) { boolean flag = true; calendar.add(Calendar.DATE, 1); String str = sf.format(calendar.getTime()); for(WorkChartAxis workChart : listChart) { if(str.equals(workChart.getYmd())) { data1.add(workChart.getInqty()); data2.add(workChart.getOutqty()); flag = false; break; } } if(flag) { data1.add(0); data2.add(0); } } AxisBean inqty = new AxisBean(); inqty.setName("入库数量"); Integer[] array1 = new Integer[data1.size()]; inqty.setData(data1.toArray(array1)); list.add(inqty); AxisBean outqty = new AxisBean(); outqty.setName("出库数量"); Integer[] array2 = new Integer[data2.size()]; outqty.setData(data2.toArray(array2)); list.add(outqty); } map.put("rows",list); return R.ok(map); } @GetMapping("/locDetl/statistics") public R locDetlStatistics(){ HashMap param = new HashMap<>(); Page stockStatis = locDetlService.getStockStatis(toPage(1, 100, param, LocDetl.class)); for (LocDetl locDetl : stockStatis.getRecords()) { Mat mat = matService.selectByMatnr(locDetl.getMatnr()); if (mat != null) { locDetl.sync(mat); } } return R.ok(stockStatis); } @PostMapping("/order/matSync/default/v1") @AppAuth(memo = "商品信息同步接口") public synchronized R syncMatInfo(@RequestHeader(required = false) String appkey, @RequestBody(required = false) MatSyncParam param, HttpServletRequest request) { auth(appkey, param, request); if (Cools.isEmpty(param)) { return R.parse(BaseRes.PARAM); } openService.syncMat(param); return R.ok(); } /****************************************************************************/ /********************************* 打包上线 **********************************/ /****************************************************************************/ // @PostMapping("/order/pakin/new/package/v1") // @AppAuth(memo = "打包上线接口") // public synchronized R pakinOrderPackage(@RequestHeader(required = false) String appkey, // @RequestBody(required = false) PackParam param, // HttpServletRequest request) { // auth(appkey, param, request); // if (Cools.isEmpty(param)) { // return R.parse(BaseRes.PARAM); // } // openService.packageUp(param); // return R.ok(); // } /** * 添加入库单 */ @PostMapping("/order/pakin/default/v1") public synchronized R pakinOrderCreate(@RequestHeader(required = false) String appkey, @RequestBody OpenOrderPakinParam param, HttpServletRequest request) { auth(appkey, param, request); if (Cools.isEmpty(param)) { return R.parse(BaseRes.PARAM); } if (Cools.isEmpty(param.getOrderNo())) { return R.error("单据编号[orderNo]不能为空"); } if (Cools.isEmpty(param.getOrderType())) { return R.error("单据类型[orderType]不能为空"); } if (Cools.isEmpty(param.getOrderDetails())) { return R.error("单据明细[orderDetails]不能为空"); } openService.pakinOrderCreate(param); return R.ok(); } /** * 入库单回写 */ @PostMapping("/order/pakin/complete/default/v1") public synchronized R orderPakinComplete(@RequestHeader(required = false) String appkey, @RequestBody(required = false) OpenOrderCompleteParam param, HttpServletRequest request) { auth(appkey, param, request); return R.ok().add(openService.pakinOrderComplete(param)); } /** * 添加出库单 */ @PostMapping("/order/pakout/default/v1") @AppAuth(memo = "添加订单出库") public synchronized R pakoutOrderCreate(@RequestHeader(required = false) String appkey, @RequestBody OpenOrderPakoutParam param, HttpServletRequest request) { auth(appkey, param, request); if (Cools.isEmpty(param)) { return R.parse(BaseRes.PARAM); } if (Cools.isEmpty(param.getLgort())) { return R.error("单据编号[lgort]不能为空"); } if (!param.getLgort().equals("5006")) { return R.ok(); } if (Cools.isEmpty(param.getOrderNo())) { return R.error("单据编号[orderNo]不能为空"); } if (Cools.isEmpty(param.getOrderType())) { return R.error("单据类型[orderType]不能为空"); } if (Cools.isEmpty(param.getOrderDetails())) { return R.error("单据明细[orderDetails]不能为空"); } openService.pakoutOrderCreate(param); return R.ok(); } /** * 出库单回写 */ @PostMapping("/order/pakout/complete/default/v1") public synchronized R orderPakoutComplete(@RequestHeader(required = false) String appkey, @RequestBody(required = false) OpenOrderCompleteParam param, HttpServletRequest request) { auth(appkey, param, request); return R.ok().add(openService.pakoutOrderComplete(param)); } /** * 库存统计 */ @RequestMapping("/stock/default/v1") public R queryStock(@RequestHeader(required = false) String appkey, HttpServletRequest request) { auth(appkey, null, request); return R.ok().add(openService.queryStock()); } private void auth(String appkey, Object obj, HttpServletRequest request) { log.info("{}接口被访问;appkey:{};请求数据:{}", "open/sensorType/list/auth/v1", appkey, JSON.toJSONString(obj)); request.setAttribute("cache", obj); if (!auth) { return; } if (Cools.isEmpty(appkey)) { throw new CoolException("认证失败,请确认appkey无误!"); } if (!APP_KEY_LIST.contains(appkey)) { throw new CoolException("认证失败,请确认appkey无误!"); } } public static void main(String[] args) { // 1 System.out.println("======================================"); OpenOrderPakinParam param = new OpenOrderPakinParam(); param.setOrderNo(String.valueOf(new SnowflakeIdWorker().nextId())); param.setOrderType("打包上线单"); param.setOrderTime(DateUtils.convert(new Date())); List orderDetails = new ArrayList<>(); param.setOrderDetails(orderDetails); for (int i = 0; i < 3; i++) { DetlDto detlDto = new DetlDto(); switch (i) { case 0: detlDto.setMatnr("MDH020030530"); detlDto.setBatch("500"); detlDto.setAnfme(18.0); break; case 1: detlDto.setMatnr("MDH020016416"); detlDto.setBatch("500"); detlDto.setAnfme(32.0); break; case 2: detlDto.setMatnr("LSH90152025"); detlDto.setAnfme(50.0); break; default: break; } orderDetails.add(detlDto); } System.out.println(JSON.toJSONString(param)); // 2 System.out.println("======================================"); OpenOrderCompleteParam param1 = new OpenOrderCompleteParam(); param1.setOrderNo("963001846497017856"); System.out.println(JSON.toJSONString(param1)); } /*********************************同步物料档案和订单****************************************************/ /*********************************wcs接口对接****************************************************/ /** * 任务开始 */ @RequestMapping("/start/task") public HashMap startTask(@RequestBody HashMap map) { String taskNo = map.get("TaskNo") + ""; HashMap map1 = new HashMap<>(); if (Cools.isEmpty(taskNo)) { map1.put("ReturnStatus", "1"); map1.put("ErrorMessage", "任务号为空"); } else { WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper().eq("wrk_no", Integer.valueOf(taskNo))); if (wrkMast == null) { map1.put("ReturnStatus", "1"); map1.put("ErrorMessage", "没有找到该任务号:" + taskNo); } else { if (wrkMast.getIoType() == 1||wrkMast.getIoType() == 57|| wrkMast.getIoType() == 53) { wrkMast.setWrkSts(3L);//入库开始 } else if (wrkMast.getIoType() == 11 ||wrkMast.getIoType() == 107|| wrkMast.getIoType() == 103 ) { wrkMast.setWrkSts(13L);//出库开始 } wrkMast.setModiTime(new Date()); if (wrkMastService.updateById(wrkMast)) { log.info("WMS任务开始更新"+wrkMast); map1.put("ReturnStatus", "0"); map1.put("ErrorMessage", ""); } else { map1.put("ReturnStatus", "1"); map1.put("ErrorMessage", "更新任务状态失败" + wrkMast); } } } return map1; } /** * 搬运到目的地 */ @RequestMapping("/destination/task") public HashMap destinationTask(@RequestBody HashMap map) { String taskNo = map.get("TaskNo") + ""; HashMap map1 = new HashMap<>(); if (Cools.isEmpty(taskNo)) { map1.put("ReturnStatus", "1"); map1.put("ErrorMessage", "任务号为空"); } else { //任务完成 if (map.get("Result").equals(1)) { WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper().eq("wrk_no", Integer.valueOf(taskNo))); if (wrkMast == null) { map1.put("ReturnStatus", "1"); map1.put("ErrorMessage", "没有找到该任务号:" + taskNo); } else { if (wrkMast.getIoType() == 1 || wrkMast.getIoType() == 10) { wrkMast.setWrkSts(4L);//任务结束 } else if (wrkMast.getIoType() == 101) { wrkMast.setWrkSts(13L);//出库到站点上 } else if (wrkMast.getIoType() == 53 || wrkMast.getIoType() == 57) { wrkMast.setWrkSts(4L);//4.任务结束 } else if (wrkMast.getIoType() == 103 || wrkMast.getIoType() == 107 || wrkMast.getIoType() == 110) { wrkMast.setWrkSts(14L); }else if(wrkMast.getIoType() == 11) { wrkMast.setWrkSts(4L); } wrkMast.setModiTime(new Date()); if (wrkMastService.update(wrkMast,new EntityWrapper().eq("wrk_no",wrkMast.getWrkNo()))) { log.info("WMS任务完成更新"+wrkMast); map1.put("ReturnStatus", "0"); map1.put("ErrorMessage", ""); } else { map1.put("ReturnStatus", "1"); map1.put("ErrorMessage", "更新任务状态失败" + wrkMast); } } } else { //任务取消 WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper().eq("wrk_no", Integer.valueOf(taskNo))); if (wrkMast == null) { map1.put("ReturnStatus", "1"); map1.put("ErrorMessage", "没有找到该任务号:" + taskNo); return map1; } workService.cancelWrkMast(String.valueOf(wrkMast.getWrkNo()),9999L); map1.put("ReturnStatus", "0"); map1.put("ErrorMessage", ""); } } return map1; } /** * 出库---目的地搬离 */ @RequestMapping("/leave/task") public R leaveTask(@RequestBody HashMap map) { String taskNo = String.valueOf(map.get("taskNo")); String status = String.valueOf(map.get("status")); HashMap map1 = new HashMap<>(); if (Cools.isEmpty(taskNo)) { return R.error("任务号为空"); } else { WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper().eq("wrk_no", Integer.valueOf(taskNo))); if (wrkMast == null) { return R.error("没有找到该任务号:" + taskNo); } if (status.equals("complete")) { // 入库 + 库位转移 if (wrkMast.getWrkSts() < 4 || (wrkMast.getWrkSts() > 10 && wrkMast.getIoType()==11)) { wrkMast.setWrkSts(4L); // 出库 } else if (wrkMast.getWrkSts() > 10) { wrkMast.setWrkSts(14L); } Date now = new Date(); wrkMast.setWrkSts(14L);//出库到站点上 wrkMast.setCrnStrTime(DateUtils.calculate(now, 1L, TimeUnit.SECONDS, true)); wrkMast.setCrnEndTime(now); wrkMast.setModiTime(now); wrkMastService.updateById(wrkMast); return R.ok(); } else if (status.equals("cancel")) { workService.cancelWrkMast(taskNo, 9527L); return R.ok(); } } return R.error(); } }