package com.zy.common.web;
|
|
import com.baomidou.mybatisplus.mapper.EntityWrapper;
|
import com.baomidou.mybatisplus.mapper.Wrapper;
|
import com.core.common.Cools;
|
import com.core.common.R;
|
import com.core.exception.CoolException;
|
import com.zy.asrs.entity.*;
|
import com.zy.asrs.entity.param.EmptyPlateOutParam;
|
import com.zy.asrs.entity.result.FindLocNoAttributeVo;
|
import com.zy.asrs.service.*;
|
import com.zy.common.CodeRes;
|
import com.zy.common.model.LocTypeDto;
|
import com.zy.common.model.StartupDto;
|
import com.zy.common.service.CommonService;
|
import com.zy.common.web.param.SearchLocParam;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.web.bind.annotation.*;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.stream.Collectors;
|
|
/**
|
* Created by vincent on 2020/10/30
|
*/
|
@Slf4j
|
@RestController
|
@RequestMapping("/rpc")
|
public class WcsController {
|
@Autowired
|
private WrkLastnoService wrkLastnoService;
|
@Autowired
|
private WrkMastService wrkMastService;
|
@Autowired
|
private BasDevpService basDevpService;
|
@Autowired
|
private CommonService commonService;
|
@Autowired
|
private WrkDetlService wrkDetlService;
|
@Autowired
|
private LocMastService locMastService;
|
@Autowired
|
private WaitPakinService waitPakinService;
|
@Autowired
|
private LocDetlService locDetlService;
|
@Autowired
|
private RowLastnoService rowLastnoService;
|
@Autowired
|
private WorkService workService;
|
|
@PostMapping("/pakin/loc/v1")
|
@ResponseBody
|
public synchronized R getLocNo(@RequestBody SearchLocParam param) {
|
log.info("收到WCS入库接口请求====>>入参:{}", param);
|
if (Cools.isEmpty(param.getIoType())) {
|
return R.error("入出库类型不能为空");
|
}
|
if (Cools.isEmpty(param.getSourceStaNo())) {
|
return R.error("源站编号不能为空");
|
}
|
List<WaitPakin> waitPakins = null;
|
if (param.getIoType() == 1) {
|
if (Cools.isEmpty(param.getBarcode())) {
|
return R.error("条码不能为空");
|
}
|
waitPakins = waitPakinService.selectList(new EntityWrapper<WaitPakin>().eq("zpallet", param.getBarcode()));
|
if (Cools.isEmpty(waitPakins)) {
|
WrkMast wrkMast = wrkMastService.selectByBarcode(param.getBarcode());
|
if (wrkMast != null && wrkMast.getIoType() == 103) {
|
return R.parse(CodeRes.PICK_600);
|
}
|
return R.parse(CodeRes.NO_COMB_700);
|
}
|
int countLoc = locDetlService.selectCount(new EntityWrapper<LocDetl>().eq("zpallet",param.getBarcode()));
|
int countWrk = wrkDetlService.selectCount(new EntityWrapper<WrkDetl>().eq("zpallet",param.getBarcode()));
|
if (countLoc > 0 || countWrk > 0) {
|
return R.error(CodeRes.EXIST_500);
|
}
|
}
|
if (Cools.isEmpty(param.getLocType1())){
|
return R.error("高低检测信号不能为空");
|
}
|
|
// 源站点状态检测
|
BasDevp sourceStaNo = basDevpService.checkSiteStatus(param.getSourceStaNo(), true);
|
sourceStaNo.setLocType1(param.getLocType1());
|
LocTypeDto locTypeDto = new LocTypeDto(sourceStaNo);
|
|
StartupDto dto = null;
|
switch (param.getIoType()) {
|
case 1://满托盘入库
|
assert waitPakins != null;
|
dto = startupFullPutStore(param.getSourceStaNo(), param.getBarcode(), locTypeDto, waitPakins);
|
break;
|
case 10://空托盘入库
|
dto = emptyPlateIn(param.getSourceStaNo(), locTypeDto, param.getBarcode());
|
break;
|
default:
|
break;
|
}
|
log.info("WCS入库接口返参:{},托盘码:{}", dto, param.getBarcode());
|
return R.ok().add(dto);
|
}
|
|
@PostMapping("/auto/emptyIn/v1")
|
@ResponseBody
|
public R autoEmptyIn(@RequestBody LocTypeDto locTypeDto){
|
// 源站点状态检测
|
BasDevp sourceStaNo = basDevpService.checkSiteStatus(1038, true);
|
|
// 检索库位
|
FindLocNoAttributeVo findLocNoAttributeVo = new FindLocNoAttributeVo();
|
|
StartupDto dto = commonService.getLocNo( 10, 1038, findLocNoAttributeVo, locTypeDto);
|
if (dto == null){
|
throw new CoolException("查询库位失败");
|
}
|
Date now = new Date();
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(dto.getWorkNo());
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(2L);
|
wrkMast.setIoPri(13D);
|
wrkMast.setIoType(10);
|
wrkMast.setCrnNo(dto.getCrnNo());
|
wrkMast.setSourceStaNo(dto.getSourceStaNo());
|
wrkMast.setStaNo(dto.getStaNo());
|
wrkMast.setLocNo(dto.getLocNo());
|
wrkMast.setFullPlt("N"); // 满板：N
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("Y"); // 空板
|
wrkMast.setLinkMis("Y");
|
wrkMast.setCtnType(sourceStaNo.getCtnType()); // 容器类型
|
// 操作人员数据
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiTime(now);
|
wrkMast.setMemo("自动空托入库");
|
// 更新源站点信息
|
sourceStaNo.setWrkNo(dto.getWorkNo());
|
sourceStaNo.setModiUser(9999L);
|
sourceStaNo.setModiTime(now);
|
if (!basDevpService.updateById(sourceStaNo)){
|
throw new CoolException("更新源站失败");
|
}
|
// 更新目标库位状态
|
LocMast locMast = locMastService.selectById(dto.getLocNo());
|
if (locMast.getLocSts().equals("O")){
|
locMast.setLocSts("S"); // S.入库预约
|
locMast.setModiUser(9999L);
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)){
|
throw new CoolException("改变库位状态失败");
|
}
|
} else {
|
throw new CoolException(dto.getLocNo()+"目标库位已被占用");
|
}
|
return wrkMastService.insert(wrkMast) ? R.ok("自动空托入库成功,工作号:"+wrkMast.getWrkNo()).add(wrkMast.getWrkNo()) : R.error("生成自动空托入库失败");
|
}
|
|
@PostMapping("auto/emptyOut/v1")
|
@ResponseBody
|
public R autoEmptyOut(@RequestBody LocTypeDto locTypeDto){
|
LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>()
|
.eq("loc_sts", "D"));
|
if (Cools.isEmpty(locMast)) {
|
return R.error("库存没有空板");
|
}
|
EmptyPlateOutParam emptyPlateOutParam = new EmptyPlateOutParam();
|
emptyPlateOutParam.setOutSite(locTypeDto.getSiteId());
|
emptyPlateOutParam.setLocNos(new ArrayList<String>(){{add(locMast.getLocNo()+"");}});
|
WrkMast wrkMast = workService.emptyPlateOut(emptyPlateOutParam);
|
return R.ok(!Cools.isEmpty(wrkMast)? R.ok("自动空托出库成功,工作号:" + wrkMast.getWrkNo()) : R.error("生成自动空托出库失败"));
|
}
|
|
|
/**
|
* 生成工作号
|
*
|
* @param wrkMk
|
* @return workNo(工作号)
|
*/
|
public int getWorkNo(Integer wrkMk) {
|
WrkLastno wrkLastno = wrkLastnoService.selectById(wrkMk);
|
if (Cools.isEmpty(wrkLastno)) {
|
throw new CoolException("数据异常，请联系管理员");
|
}
|
|
int workNo = wrkLastno.getWrkNo();
|
int sNo = wrkLastno.getSNo();
|
int eNo = wrkLastno.getENo();
|
workNo = workNo >= eNo ? sNo : workNo + 1;
|
while (true) {
|
WrkMast wrkMast = wrkMastService.selectById(workNo);
|
if (null != wrkMast) {
|
workNo = workNo >= eNo ? sNo : workNo + 1;
|
} else {
|
break;
|
}
|
}
|
// 修改序号记录
|
if (workNo > 0) {
|
wrkLastno.setWrkNo(workNo);
|
wrkLastnoService.updateById(wrkLastno);
|
}
|
// 检验
|
if (workNo == 0) {
|
throw new CoolException("生成工作号失败，请联系管理员");
|
} else {
|
if (wrkMastService.selectById(workNo) != null) {
|
throw new CoolException("生成工作号" + workNo + "在工作档中已存在");
|
}
|
}
|
return workNo;
|
}
|
@PostMapping("/auto/TransplantingOut/v1")
|
@ResponseBody
|
public R autoTransplantingOut(@RequestBody TransplantWork transplantWork){
|
// 源站点状态检测
|
BasDevp sourceStaNo = basDevpService.checkSiteStatus(transplantWork.getStaNo(), true);
|
WrkMast wrkMast1 = wrkMastService.selectWrkMast(transplantWork.getWorkNo(),transplantWork.getBarcode());
|
if(sourceStaNo ==null ){
|
return R.error("该站点盘点移栽许可，请查看源站点状态检测");
|
}
|
if(wrkMast1== null){
|
return R.error("无该盘点移栽任务");
|
}
|
List<WrkDetl> wrkDetls = wrkDetlService.selectByWrkNo(transplantWork.getWorkNo());
|
Date now = new Date();
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
int workNo = getWorkNo(0);
|
wrkMast.setWrkNo(9997);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(11L);
|
wrkMast.setIoPri(14D);
|
wrkMast.setIoType(12);
|
wrkMast.setCrnNo(3);
|
wrkMast.setBarcode(transplantWork.getBarcode());
|
wrkMast.setSourceStaNo(transplantWork.getSourceStaNo());
|
wrkMast.setStaNo(transplantWork.getStaNo());
|
wrkMast.setFullPlt("Y"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("N"); // 空板
|
wrkMast.setLinkMis("Y");
|
// 操作人员数据
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiTime(now);
|
wrkMast.setMemo("自动3号堆垛机移栽");
|
for (WrkDetl item : wrkDetls) {
|
WrkDetl newDetl = new WrkDetl();
|
newDetl.sync(item);
|
newDetl.setWrkNo(wrkMast.getWrkNo());
|
newDetl.setIoTime(wrkMast.getIoTime());
|
newDetl.setAppeTime(now);
|
newDetl.setModiTime(now);
|
if (!wrkDetlService.insert(newDetl)) {
|
throw new CoolException("保存工作明细失败");
|
}
|
}
|
return wrkMastService.insert(wrkMast) ? R.ok("自动3号堆垛机移栽成功,工作号:"+wrkMast.getWrkNo()) : R.error("生成自动3号堆垛机移栽失败");
|
}
|
|
@PostMapping("/auto/TransplantingIn/v1")
|
@ResponseBody
|
public R autoTransplantingIn(@RequestBody TransplantWork transplantWork){
|
// 源站点状态检测
|
BasDevp sourceStaNo = basDevpService.checkSiteStatus(transplantWork.getStaNo(), true);
|
WrkMast wrkMast1 = wrkMastService.selectWrkMast(transplantWork.getWorkNo(),transplantWork.getBarcode());
|
if(sourceStaNo == null){
|
|
}
|
if(wrkMast1== null){
|
return R.error("无该盘点移栽任务");
|
}
|
List<WrkDetl> wrkDetls = wrkDetlService.selectByWrkNo(transplantWork.getWorkNo());
|
Date now = new Date();
|
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(9996);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(2L);
|
wrkMast.setIoPri(14D);
|
wrkMast.setIoType(12);
|
wrkMast.setCrnNo(3);
|
wrkMast.setBarcode(transplantWork.getBarcode());
|
wrkMast.setSourceStaNo(4001);
|
wrkMast.setStaNo(transplantWork.getStaNo());
|
wrkMast.setFullPlt("Y"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("N"); // 空板
|
wrkMast.setLinkMis("Y");
|
// 操作人员数据
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiTime(now);
|
wrkMast.setMemo("自动3号堆垛机移栽");
|
for (WrkDetl item : wrkDetls) {
|
WrkDetl newDetl = new WrkDetl();
|
newDetl.sync(item);
|
newDetl.setWrkNo(wrkMast.getWrkNo());
|
newDetl.setIoTime(wrkMast.getIoTime());
|
newDetl.setAppeTime(now);
|
newDetl.setModiTime(now);
|
if (!wrkDetlService.insert(newDetl)) {
|
throw new CoolException("保存工作明细失败");
|
}
|
}
|
return wrkMastService.insert(wrkMast) ? R.ok("自动3号堆垛机移栽成功,工作号:"+wrkMast.getWrkNo()) : R.error("生成自动3号堆垛机移栽失败");
|
}
|
|
|
/**
|
* 全板入库
|
*/
|
@Transactional
|
public StartupDto startupFullPutStore(Integer devpNo, String barcode, LocTypeDto locTypeDto, List<WaitPakin> waitPakins) {
|
// 源站点状态检测
|
BasDevp sourceStaNo = basDevpService.checkSiteStatus(devpNo, true);
|
// 检索库位
|
List<String> matnrs = waitPakins.stream().map(WaitPakin::getMatnr).distinct().collect(Collectors.toList());
|
List<String> batchs = waitPakins.stream().map(WaitPakin::getBatch).distinct().collect(Collectors.toList());
|
FindLocNoAttributeVo findLocNoAttributeVo = new FindLocNoAttributeVo(matnrs.get(0), batchs.get(0));
|
// FindLocNoAttributeVo findLocNoAttributeVo = new FindLocNoAttributeVo(waitPakins.get(0));
|
StartupDto dto = commonService.getLocNo( 1, devpNo,findLocNoAttributeVo, locTypeDto);
|
int workNo = dto.getWorkNo();
|
Date now = new Date();
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(new Date());
|
wrkMast.setWrkSts(2L); // 工作状态：生成入库ID
|
wrkMast.setIoType(1); // 入出库状态：1.入库
|
wrkMast.setIoPri(13D); // 优先级
|
wrkMast.setCrnNo(dto.getCrnNo());
|
wrkMast.setSourceStaNo(dto.getSourceStaNo());
|
wrkMast.setStaNo(dto.getStaNo());
|
wrkMast.setLocNo(dto.getLocNo());
|
wrkMast.setBarcode(barcode); // 托盘码
|
wrkMast.setFullPlt("Y"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("N"); // 空板
|
wrkMast.setLinkMis("Y");
|
wrkMast.setCtnType(sourceStaNo.getCtnType()); // 容器类型
|
// 操作人员数据
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiTime(now);
|
boolean res = wrkMastService.insert(wrkMast);
|
if (!res) {
|
throw new CoolException("保存工作档失败");
|
}
|
// 生成工作档明细
|
waitPakins.forEach(waitPakin -> {
|
WrkDetl wrkDetl = new WrkDetl();
|
wrkDetl.sync(waitPakin);
|
wrkDetl.setWrkNo(wrkMast.getWrkNo());
|
wrkDetl.setIoTime(wrkMast.getIoTime());
|
wrkDetl.setAppeTime(now);
|
wrkDetl.setModiTime(now);
|
if (!wrkDetlService.insert(wrkDetl)) {
|
throw new CoolException("保存工作明细失败");
|
}
|
});
|
// 更新入库通知档 ioStatus ===>> Y
|
Wrapper<WaitPakin> wrapper = new EntityWrapper<WaitPakin>()
|
.eq("zpallet", barcode);
|
WaitPakin setParam = new WaitPakin();
|
setParam.setLocNo(dto.getLocNo());
|
setParam.setIoStatus("Y");
|
setParam.setModiTime(now);
|
if (!waitPakinService.update(setParam, wrapper)) {
|
throw new CoolException("更新通知档失败");
|
}
|
// 更新源站点信息
|
sourceStaNo.setWrkNo(workNo);
|
sourceStaNo.setModiTime(now);
|
if (!basDevpService.updateById(sourceStaNo)){
|
throw new CoolException("更新源站失败");
|
}
|
// 更新目标库位状态
|
LocMast locMast = locMastService.selectById(dto.getLocNo());
|
if (locMast.getLocSts().equals("O")){
|
locMast.setLocSts("S"); // S.入库预约
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)){
|
throw new CoolException("改变库位状态失败");
|
}
|
} else {
|
throw new CoolException(dto.getLocNo()+"目标库位已被占用");
|
}
|
return dto;
|
}
|
|
@Transactional
|
public StartupDto emptyPlateIn(Integer devpNo, LocTypeDto locTypeDto, String barcode) {
|
// 源站点状态检测
|
BasDevp sourceStaNo = basDevpService.checkSiteStatus(devpNo, true);
|
// 检索库位
|
FindLocNoAttributeVo findLocNoAttributeVo = new FindLocNoAttributeVo();
|
|
StartupDto dto = commonService.getLocNo( 10, devpNo, findLocNoAttributeVo, locTypeDto);
|
int workNo = dto.getWorkNo();
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(new Date());
|
wrkMast.setWrkSts(2L); // 工作状态：生成入库ID
|
wrkMast.setIoType(10); // 入出库状态：10.空板入库
|
wrkMast.setIoPri(13D); // 优先级
|
wrkMast.setCrnNo(dto.getCrnNo());
|
wrkMast.setSourceStaNo(dto.getSourceStaNo());
|
wrkMast.setStaNo(dto.getStaNo());
|
wrkMast.setLocNo(dto.getLocNo());
|
wrkMast.setFullPlt("N"); // 满板
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("Y"); // 空板
|
wrkMast.setLinkMis("Y");
|
wrkMast.setBarcode(barcode);
|
wrkMast.setCtnType(sourceStaNo.getCtnType()); // 容器类型
|
// 操作人员数据
|
wrkMast.setAppeTime(new Date());
|
wrkMast.setModiTime(new Date());
|
boolean res = wrkMastService.insert(wrkMast);
|
if (!res) {
|
throw new CoolException("保存工作档失败");
|
}
|
// 更新源站点信息
|
sourceStaNo.setWrkNo(workNo);
|
sourceStaNo.setModiTime(new Date());
|
if (!basDevpService.updateById(sourceStaNo)){
|
throw new CoolException("更新源站失败");
|
}
|
// 更新目标库位状态
|
LocMast locMast = locMastService.selectById(dto.getLocNo());
|
if (locMast.getLocSts().equals("O")){
|
locMast.setLocSts("S"); // S.入库预约
|
locMast.setModiTime(new Date());
|
if (!locMastService.updateById(locMast)){
|
throw new CoolException("改变库位状态失败");
|
}
|
} else {
|
throw new CoolException(dto.getLocNo()+"目标库位已被占用");
|
}
|
return dto;
|
}
|
|
}
|
