package com.zy.asrs.controller;
|
|
import com.baomidou.mybatisplus.mapper.EntityWrapper;
|
import com.core.annotations.ManagerAuth;
|
import com.core.common.BaseRes;
|
import com.core.common.Cools;
|
import com.core.common.R;
|
import com.zy.asrs.entity.*;
|
import com.zy.asrs.service.*;
|
import com.zy.asrs.utils.MatUtils;
|
import com.zy.common.model.LocDto;
|
import com.zy.common.model.TaskDto;
|
import com.zy.common.web.BaseController;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.web.bind.annotation.PostMapping;
|
import org.springframework.web.bind.annotation.RequestBody;
|
import org.springframework.web.bind.annotation.RequestParam;
|
import org.springframework.web.bind.annotation.RestController;
|
|
import javax.annotation.Resource;
|
import java.math.BigDecimal;
|
import java.util.*;
|
import java.util.stream.Collectors;
|
|
/**
|
* Created by vincent on 2022/3/26
|
*/
|
|
@RestController
|
public class OutController extends BaseController {
|
|
@Autowired
|
private OrderService orderService;
|
@Autowired
|
private OrderDetlService orderDetlService;
|
@Autowired
|
private OrderDetlPakoutService orderDetlPakoutService;
|
@Autowired
|
private LocDetlService locDetlService;
|
@Autowired
|
private LocMastService locMastService;
|
@Autowired
|
private StaDescService staDescService;
|
@Autowired
|
private WorkService workService;
|
@Autowired
|
private BasDevpService basDevpService;
|
|
@Resource
|
private OrderPakoutService orderPakOutService;
|
|
|
@PostMapping("/out/pakout/orderDetlIds/auth")
|
@ManagerAuth
|
public R pakoutOrderDetlIds(@RequestParam Long orderId) throws InterruptedException {
|
Thread.sleep(200);
|
return R.ok().add(orderDetlPakoutService.selectByOrderId(orderId).stream().map(OrderDetlPakout::getId).distinct().collect(Collectors.toList()));
|
}
|
|
@PostMapping("/out/pakout/preview/auth")
|
@ManagerAuth
|
public R pakoutPreview(@RequestBody List<Long> ids) {
|
if (Cools.isEmpty(ids)) {
|
return R.parse(BaseRes.PARAM);
|
}
|
List<OrderDetlPakout> orderDetlPakouts = orderDetlPakoutService.selectBatchIds(ids);
|
|
if (orderDetlPakouts.size() == 0) {
|
return R.parse("订单明细为空");
|
}
|
|
List<LocDto> locDtos = new ArrayList<>();
|
|
Set<String> exist = new HashSet<>();
|
|
// 获取订单主表
|
OrderPakout orderPakOut = orderPakOutService.selectByNo(orderDetlPakouts.get(0).getOrderNo());
|
// 盘点单出库
|
if (orderPakOut.getDocType() == 8) {
|
for (OrderDetlPakout orderDetl : orderDetlPakouts) {
|
BigDecimal issuedBigDecimal = Optional.of(BigDecimal.valueOf(orderDetl.getAnfme()).subtract(BigDecimal.valueOf(orderDetl.getWorkQty()))).orElse(new BigDecimal(0));
|
double issued = issuedBigDecimal.doubleValue();
|
if (issued <= 0.0D) {
|
continue;
|
}
|
List<LocDetl> locDetls = locDetlService.queryStockAll(null, exist,orderDetl.getMatnr(), orderDetl.getBatch(),
|
orderDetl.getBrand(),orderDetl.getStandby1(),orderDetl.getStandby2(),orderDetl.getStandby3(),orderDetl.getBoxType1(),orderDetl.getBoxType2(),orderDetl.getBoxType3());
|
for (LocDetl locDetl : locDetls) {
|
if (issued > 0) {
|
LocDto locDto = new LocDto(locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getMaktx(), locDetl.getBatch(), orderDetl.getOrderNo(),
|
issued >= locDetl.getAnfme() ? locDetl.getAnfme() : issued);
|
LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", locDetl.getLocNo()));
|
locDto.setFrozen(locDetl.getFrozen());
|
locDto.setFrozenLoc(locMast.getFrozen());
|
List<Integer> staNos = staDescService.queryOutStaNosByLocNo(locDetl.getLocNo(), 107);
|
locDto.setBrand(orderDetl.getBrand());
|
locDto.setStandby1(orderDetl.getStandby1());
|
locDto.setStandby2(orderDetl.getStandby2());
|
locDto.setStandby3(orderDetl.getStandby3());
|
locDto.setBoxType1(orderDetl.getBoxType1());
|
locDto.setBoxType2(orderDetl.getBoxType2());
|
locDto.setBoxType3(orderDetl.getBoxType3());
|
|
//计算辅单位
|
Double weight = MatUtils.calcWeight(locDto.getMatnr(), locDto.getAnfme());
|
locDto.setWeight(weight);
|
|
locDto.setUnit(orderDetl.getUnit());
|
|
locDto.setStaNos(staNos);
|
locDtos.add(locDto);
|
// 剩余待出数量递减
|
issuedBigDecimal = issuedBigDecimal.subtract(BigDecimal.valueOf(locDetl.getAnfme()));
|
issued = issuedBigDecimal.doubleValue();
|
} else {
|
break;
|
}
|
}
|
if (issued > 0) {
|
LocDto locDto = new LocDto(null, orderDetl.getMatnr(), orderDetl.getMaktx(), orderDetl.getBatch(), orderDetl.getOrderNo(), issued);
|
locDto.setBrand(orderDetl.getBrand());
|
|
locDto.setStandby1(orderDetl.getStandby1());
|
locDto.setStandby2(orderDetl.getStandby2());
|
locDto.setStandby3(orderDetl.getStandby3());
|
locDto.setBoxType1(orderDetl.getBoxType1());
|
locDto.setBoxType2(orderDetl.getBoxType2());
|
locDto.setBoxType3(orderDetl.getBoxType3());
|
|
//计算辅单位
|
Double weight = MatUtils.calcWeight(locDto.getMatnr(), locDto.getAnfme());
|
locDto.setWeight(weight);
|
|
locDto.setUnit(orderDetl.getUnit());
|
locDto.setLack(Boolean.TRUE);
|
locDtos.add(locDto);
|
}
|
}
|
} else {
|
for (OrderDetlPakout orderDetl : orderDetlPakouts) {
|
BigDecimal issuedBigDecimal = Optional.of(BigDecimal.valueOf(orderDetl.getAnfme()).subtract(BigDecimal.valueOf(orderDetl.getWorkQty()))).orElse(new BigDecimal(0));
|
double issued = issuedBigDecimal.doubleValue();
|
if (issued <= 0.0D) {
|
continue;
|
}
|
|
//第一次搜索，主要搜索可全板出库的托盘
|
List<LocDetl> locDetls = locDetlService.queryStockAll(null, exist,orderDetl.getMatnr(), orderDetl.getBatch(),
|
orderDetl.getBrand(),orderDetl.getStandby1(),orderDetl.getStandby2(),orderDetl.getStandby3(),orderDetl.getBoxType1(),orderDetl.getBoxType2(),orderDetl.getBoxType3());
|
//根据排序结果获取库位号
|
List<String> locList = new ArrayList<>();
|
for (LocDetl locDetl : locDetls) {
|
if (locList.contains(locDetl.getLocNo())) {
|
continue;
|
}
|
locList.add(locDetl.getLocNo());
|
}
|
|
List<String> containLocList = new ArrayList<>();
|
for (String locNo : locList) {
|
BigDecimal allStockDecimal = new BigDecimal(0);
|
List<LocDetl> locDetls1 = locDetlService.selectList(new EntityWrapper<LocDetl>()
|
.eq("loc_no", locNo));
|
for (LocDetl locDetl : locDetls1) {
|
allStockDecimal = allStockDecimal.add(BigDecimal.valueOf(locDetl.getAnfme()));
|
}
|
|
//此库位总库存
|
double allStock = allStockDecimal.doubleValue();
|
if (issued <= 0) {
|
break;
|
}
|
|
//库存过大，无法全板出库，搜索下一条
|
if(allStock > issued) {
|
continue;
|
}
|
|
containLocList.add(locNo);
|
|
for (LocDetl locDetl : locDetls1) {
|
LocDto locDto = new LocDto(locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getMaktx(), locDetl.getBatch(), orderDetl.getOrderNo(),
|
issued >= locDetl.getAnfme() ? locDetl.getAnfme() : issued);
|
LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", locDetl.getLocNo()));
|
locDto.setFrozen(locDetl.getFrozen());
|
locDto.setFrozenLoc(locMast.getFrozen());
|
// int ioType = (issued >= locDetl.getAnfme() && locDetlService.selectCount(new EntityWrapper<LocDetl>().eq("loc_no", locDto.getLocNo())) == 1) ? 101 : 103;
|
int ioType = 101;
|
List<Integer> staNos = staDescService.queryOutStaNosByLocNo(locDetl.getLocNo(), ioType);
|
locDto.setStaNos(staNos);
|
locDto.setBrand(orderDetl.getBrand());
|
|
locDto.setStandby1(orderDetl.getStandby1());
|
locDto.setStandby2(orderDetl.getStandby2());
|
locDto.setStandby3(orderDetl.getStandby3());
|
locDto.setBoxType1(orderDetl.getBoxType1());
|
locDto.setBoxType2(orderDetl.getBoxType2());
|
locDto.setBoxType3(orderDetl.getBoxType3());
|
locDto.setUnit(orderDetl.getUnit());
|
|
//计算辅单位
|
Double weight = MatUtils.calcWeight(locDto.getMatnr(), locDto.getAnfme());
|
locDto.setWeight(weight);
|
|
locDtos.add(locDto);
|
exist.add(locDetl.getLocNo());
|
// 剩余待出数量递减
|
issuedBigDecimal = issuedBigDecimal.subtract(BigDecimal.valueOf(locDetl.getAnfme()));
|
issued = issuedBigDecimal.doubleValue();
|
}
|
}
|
|
//全板搜索结束后，还有未出数量，则搜索拣选出库
|
if(issued > 0) {
|
for (LocDetl locDetl : locDetls) {
|
if (issued <= 0) {
|
break;
|
}
|
|
if(containLocList.contains(locDetl.getLocNo())) {
|
continue;
|
}
|
|
LocDto locDto = new LocDto(locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getMaktx(), locDetl.getBatch(), orderDetl.getOrderNo(),
|
issued >= locDetl.getAnfme() ? locDetl.getAnfme() : issued);
|
LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", locDetl.getLocNo()));
|
locDto.setFrozen(locDetl.getFrozen());
|
locDto.setFrozenLoc(locMast.getFrozen());
|
// int ioType = (issued >= locDetl.getAnfme() && locDetlService.selectCount(new EntityWrapper<LocDetl>().eq("loc_no", locDto.getLocNo())) == 1) ? 101 : 103;
|
int ioType = 103;
|
List<Integer> staNos = staDescService.queryOutStaNosByLocNo(locDetl.getLocNo(), ioType);
|
locDto.setStaNos(staNos);
|
locDto.setBrand(orderDetl.getBrand());
|
|
locDto.setStandby1(orderDetl.getStandby1());
|
locDto.setStandby2(orderDetl.getStandby2());
|
locDto.setStandby3(orderDetl.getStandby3());
|
locDto.setBoxType1(orderDetl.getBoxType1());
|
locDto.setBoxType2(orderDetl.getBoxType2());
|
locDto.setBoxType3(orderDetl.getBoxType3());
|
locDto.setUnit(orderDetl.getUnit());
|
|
//计算辅单位
|
Double weight = MatUtils.calcWeight(locDto.getMatnr(), locDto.getAnfme());
|
locDto.setWeight(weight);
|
|
locDtos.add(locDto);
|
exist.add(locDetl.getLocNo());
|
// 剩余待出数量递减
|
issuedBigDecimal = issuedBigDecimal.subtract(BigDecimal.valueOf(locDetl.getAnfme()));
|
issued = issuedBigDecimal.doubleValue();
|
}
|
}
|
|
if (issued > 0) {
|
LocDto locDto = new LocDto(null, orderDetl.getMatnr(), orderDetl.getMaktx(), orderDetl.getBatch(), orderDetl.getOrderNo(), issued);
|
locDto.setBrand(orderDetl.getBrand());
|
locDto.setStandby1(orderDetl.getStandby1());
|
locDto.setStandby2(orderDetl.getStandby2());
|
locDto.setStandby3(orderDetl.getStandby3());
|
locDto.setBoxType1(orderDetl.getBoxType1());
|
locDto.setBoxType2(orderDetl.getBoxType2());
|
locDto.setBoxType3(orderDetl.getBoxType3());
|
|
//计算辅单位
|
Double weight = MatUtils.calcWeight(locDto.getMatnr(), locDto.getAnfme());
|
locDto.setWeight(weight);
|
|
locDto.setUnit(orderDetl.getUnit());
|
locDto.setLack(Boolean.TRUE);
|
locDtos.add(locDto);
|
}
|
}
|
|
// // 重新计算出库站点，可能存在一个托盘多条明细，多条明细统计下来可全板出库，但实际给出的站点只能拣选出库
|
// HashMap<String, Double> locAnfmeMap = new HashMap<>();
|
// for (LocDto locDto : locDtos) {
|
// if(locAnfmeMap.containsKey(locDto.getLocNo())) {
|
// Double anfme = locAnfmeMap.get(locDto.getLocNo());
|
// BigDecimal decimal = BigDecimal.valueOf(locDto.getAnfme()).add(BigDecimal.valueOf(anfme));
|
// locAnfmeMap.put(locDto.getLocNo(), decimal.doubleValue());
|
// }else {
|
// locAnfmeMap.put(locDto.getLocNo(), locDto.getAnfme());
|
// }
|
// }
|
//
|
// HashMap<String, List<Integer>> locStaNosMap = new HashMap<>();
|
// for (Map.Entry<String, Double> entry : locAnfmeMap.entrySet()) {
|
// String locNo = entry.getKey();
|
// Double realAnfme = entry.getValue();
|
//
|
// double stockAnfme = 0D;
|
// List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("loc_no", locNo));
|
// for (LocDetl locDetl : locDetls) {
|
// BigDecimal decimal = BigDecimal.valueOf(stockAnfme).add(BigDecimal.valueOf(locDetl.getAnfme()));
|
// stockAnfme = decimal.doubleValue();
|
// }
|
//
|
// int ioType = 103;
|
// if(stockAnfme == realAnfme) {
|
// ioType = 101;
|
// }
|
//
|
// List<Integer> staNos = staDescService.queryOutStaNosByLocNo(locNo, ioType);
|
// locStaNosMap.put(locNo, staNos);
|
// }
|
//
|
// for (LocDto locDto : locDtos) {
|
// List<Integer> staNos = locStaNosMap.get(locDto.getLocNo());
|
// locDto.setStaNos(staNos);
|
// }
|
}
|
|
return R.ok().add(locDtos);
|
}
|
|
@PostMapping("/out/pakout/auth")
|
@ManagerAuth(memo = "订单出库")
|
public synchronized R pakout(@RequestBody List<LocDto> locDtos) throws InterruptedException {
|
if (Cools.isEmpty(locDtos)) {
|
return R.parse(BaseRes.PARAM);
|
}
|
List<LocDto> locDtoArrayList = new ArrayList<>();
|
for (LocDto locDto : locDtos){
|
if (locDto.getFrozen()!=1 && locDto.getFrozenLoc()!=1){
|
locDtoArrayList.add(locDto);
|
}
|
}
|
locDtos = locDtoArrayList;
|
if (Cools.isEmpty(locDtos)) {
|
return R.parse("库存/库位被冻结，请处理后出库！！！");
|
}
|
boolean lack = true;
|
for (LocDto locDto : locDtos) {
|
if (!locDto.isLack()) {
|
lack = false;
|
break;
|
}
|
}
|
if (lack) {
|
return R.error("库存不足");
|
}
|
|
Thread.sleep(1000L);
|
|
List<TaskDto> taskDtos = new ArrayList<>();
|
// 根据 （库位 & 出库站） 分组； 理想状态：一组为一次出库任务
|
for (LocDto locDto : locDtos) {
|
if (locDto.isLack()) { continue; }
|
TaskDto taskDto = new TaskDto(locDto.getLocNo(), locDto.getStaNo(), locDto);
|
if (TaskDto.has(taskDtos, taskDto)) {
|
TaskDto dto = TaskDto.find(taskDtos, taskDto);
|
assert dto != null;
|
dto.getLocDtos().addAll(taskDto.getLocDtos());
|
} else {
|
taskDtos.add(taskDto);
|
}
|
}
|
// -----------------------------------------------------------------------------------------------
|
for (TaskDto taskDto : taskDtos) {
|
BasDevp staNo = basDevpService.checkSiteStatus(taskDto.getStaNo());
|
workService.stockOut(staNo, taskDto, getUserId());
|
}
|
return R.ok();
|
}
|
|
}
|
