package com.zy.asrs.wms.controller; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.zy.asrs.common.wms.entity.*; import com.zy.asrs.common.wms.service.*; import com.zy.asrs.framework.annotations.ManagerAuth; import com.zy.asrs.framework.common.Cools; import com.zy.asrs.framework.common.R; import com.zy.asrs.framework.domain.KeyValueVo; import com.zy.asrs.framework.common.DateUtils; import com.zy.asrs.common.web.BaseController; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.*; @RestController public class OrderDetlController extends BaseController { @Autowired private OrderDetlService orderDetlService; @Autowired private WaitPakinService waitPakinService; @Autowired private OrderService orderService; @Autowired private WrkMastService wrkMastService; @Autowired private DocTypeService docTypeService; @Autowired private WrkDetlService wrkDetlService; @Autowired private WorkService workService; @Autowired private LocDetlService locDetlService; @RequestMapping(value = "/orderDetl/forOrderNo/auth") @ManagerAuth public R forOrderNo(@RequestParam String orderNo) { return R.ok(orderDetlService.list(new LambdaQueryWrapper().eq(OrderDetl::getOrderNo,orderNo).eq(OrderDetl::getHostId,getHostId()))); } @RequestMapping(value = "/orderDetl/{id}/auth") @ManagerAuth public R get(@PathVariable("id") String id) { return R.ok(orderDetlService.getById(String.valueOf(id))); } @RequestMapping(value = "/orderDetl/page/auth") @ManagerAuth public R page(@RequestParam(defaultValue = "1") Integer curr, @RequestParam(defaultValue = "10") Integer limit, @RequestParam(required = false) String condition, @RequestParam(required = false) String timeRange, @RequestParam Map param) { LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); wrapper.eq(OrderDetl::getHostId, getHostId()); if (!Cools.isEmpty(condition)) { wrapper.like(OrderDetl::getId, condition); } if (!Cools.isEmpty(timeRange)) { String[] range = timeRange.split(RANGE_TIME_LINK); wrapper.ge(OrderDetl::getCreateTime, DateUtils.convert(range[0])); wrapper.le(OrderDetl::getCreateTime, DateUtils.convert(range[1])); } if (!Cools.isEmpty(param.get("order_id"))) { wrapper.eq(OrderDetl::getOrderId, param.get("order_id")); } return R.ok(orderDetlService.page(new Page<>(curr, limit), wrapper)); } @RequestMapping(value = "/orderDetl/forOrderNo/auth/v1") @ManagerAuth public R forOrderNoV1(@RequestParam String orderNo,@RequestParam String locNo,@RequestParam String batch,@RequestParam String matnr) { LambdaQueryWrapper locDetlLambdaQueryWrapper = new LambdaQueryWrapper() .eq(LocDetl::getLocNo, locNo) .eq(LocDetl::getHostId, getHostId()) .eq(LocDetl::getMatnr, matnr); List detls = locDetlService.list(locDetlLambdaQueryWrapper); if (Cools.isEmpty(detls)){ return R.error("未查询到库存数据"); } if (detls.size()>1){ return R.error("库存数据大于1条,为保证数据准确性,请用正常流程出库!!!"); } List orderDetlList = orderDetlService.list(new LambdaQueryWrapper() .eq(OrderDetl::getMatnr, matnr) .eq(OrderDetl::getHostId, getHostId()) .like(OrderDetl::getOrderNo, orderNo) ); if (Cools.isEmpty(orderDetlList)){ return R.error("未查询到此订单此物料数据"); } if (orderDetlList.size()>1){ return R.error("此订单此物料数据数据大于1条,为保证数据准确性,请用正常流程出库!!!"); } ArrayList orderDetls = new ArrayList<>(); for(OrderDetl orderDetl:orderDetlList){ double count = orderDetl.getAnfme() - orderDetl.getWorkQty(); if (count <= 0D) { continue; } orderDetl.setAnfme(count); orderDetls.add(orderDetl); } return R.ok(orderDetls); } @RequestMapping(value = "/orderDetl/forOrderNo/mergePakin/v1") @ManagerAuth public R forOrderNoMergePakinV1(@RequestParam String orderNo) { List docTypes = docTypeService.list(new LambdaQueryWrapper().eq(DocType::getPakin, 1)); ArrayList docTypeIds = new ArrayList<>(); for (DocType docType : docTypes) { docTypeIds.add(docType.getDocId()); } if (docTypeIds.isEmpty()) { return R.error("单据类型不存在"); } List orders = orderService.list(new LambdaQueryWrapper().in(Order::getDocType, docTypeIds).in(Order::getSettle, 0, 1, 2)); if (orders.isEmpty()) { return R.error("未查询到订单"); } ArrayList orderIds = new ArrayList<>(); for (Order order : orders) { orderIds.add(order.getId()); } List orderDetlList = orderDetlService.list(new LambdaQueryWrapper() .eq(OrderDetl::getHostId, getHostId()) .in(OrderDetl::getOrderId, orderIds) .like(OrderDetl::getOrderNo, orderNo) ); if (Cools.isEmpty(orderDetlList)){ return R.error("未查询到此订单此物料数据"); } ArrayList orderDetls = new ArrayList<>(); for(OrderDetl orderDetl:orderDetlList){ double count = orderDetl.getAnfme() - orderDetl.getWorkQty(); if (count <= 0D) { continue; } orderDetl.setAnfme(count); orderDetls.add(orderDetl); } return R.ok(orderDetls); } @RequestMapping(value = "/orderDetl/add/auth") @ManagerAuth public R add(OrderDetl orderDetl) { orderDetl.setHostId(getHostId()); orderDetlService.save(orderDetl); return R.ok(); } @RequestMapping(value = "/order/cancel/wrk/auth") @ManagerAuth public R cancelWrk(String orderId) { Order order = orderService.getById(orderId); DocType docType = docTypeService.getById(order.getDocType()); if (null != docType && docType.getPakin() == 1) { List waitPakinList = waitPakinService.list(new LambdaQueryWrapper().eq(WaitPakin::getOrderNo, order.getOrderNo())); if (!Cools.isEmpty(waitPakinList)){ for (WaitPakin entity : waitPakinList){ List wrkMasts = wrkMastService.list(new QueryWrapper().eq("barcode", entity.getZpallet())); if(!Cools.isEmpty(wrkMasts) || wrkMasts.size() > 0){ continue; } waitPakinService.removeById(entity.getId()); //订单关联,修改订单作业数量 if (!Cools.isEmpty(entity.getOrderNo())) { if (!orderDetlService.decrease(entity.getOrderNo(),entity.getHostId(), entity.getMatnr(), entity.getBatch(), entity.getAnfme())) { return R.error("订单数据回滚失败"); } } } } } else if (null != docType && docType.getPakout() == 1) { List wrkDetlList = wrkDetlService.list(new LambdaQueryWrapper().eq(WrkDetl::getOrderNo, order.getOrderNo())); if (!Cools.isEmpty(wrkDetlList)){ List wrkNoList = new ArrayList<>(); for (WrkDetl wrkDetl:wrkDetlList){ if (!wrkNoList.contains(wrkDetl.getWrkNo())){ wrkNoList.add(wrkDetl.getWrkNo()); } } for (Integer wrkNo:wrkNoList){ List wrkMasts = wrkMastService.list(new QueryWrapper().eq("wrk_no", wrkNo)); if (wrkMasts.size()==1){ if (wrkMasts.get(0).getWrkSts()==101){ workService.cancelWrkMast(wrkNo.toString(), getUserId(), getHostId()); } } } } } return R.ok(); } @RequestMapping(value = "/orderDetl/update/auth") @ManagerAuth public R update(OrderDetl orderDetl){ if (Cools.isEmpty(orderDetl) || null==orderDetl.getId()){ return R.error(); } orderDetlService.updateById(orderDetl); return R.ok(); } @RequestMapping(value = "/orderDetl/delete/auth") @ManagerAuth public R delete(@RequestParam(value="ids[]") Long[] ids){ for (Long id : ids){ orderDetlService.removeById(id); } return R.ok(); } @RequestMapping(value = "/orderDetlQuery/auth") @ManagerAuth public R query(String condition) { LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); wrapper.like(OrderDetl::getId, condition); wrapper.eq(OrderDetl::getHostId, getHostId()); Page page = orderDetlService.page(new Page<>(0, 10), wrapper); List> result = new ArrayList<>(); for (OrderDetl orderDetl : page.getRecords()){ Map map = new HashMap<>(); map.put("id", orderDetl.getId()); map.put("value", orderDetl.getId()); result.add(map); } return R.ok(result); } @RequestMapping("/orderDetl/all/get/kv") @ManagerAuth public R getDataKV(@RequestParam(required = false) String condition) { List vos = new ArrayList<>(); LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); wrapper.eq(OrderDetl::getHostId, getHostId()); if (!Cools.isEmpty(condition)) { wrapper.like(OrderDetl::getId, condition); } orderDetlService.page(new Page<>(1, 30), wrapper).getRecords().forEach(item -> vos.add(new KeyValueVo(String.valueOf(item.getId()), item.getId()))); return R.ok().add(vos); } @RequestMapping(value = "/orderDetl/pakout/list/auth") @ManagerAuth public R pakoutList(@RequestParam(defaultValue = "1")Integer curr, @RequestParam(defaultValue = "10")Integer limit, @RequestParam Map param){ IPage pakoutPage = orderDetlService.getPakoutPage(curr, limit, param); return R.ok(pakoutPage); } }