package com.zy.asrs.controller;
|
|
import com.alibaba.excel.EasyExcel;
|
import com.alibaba.fastjson.JSONObject;
|
import com.baomidou.mybatisplus.mapper.EntityWrapper;
|
import com.baomidou.mybatisplus.mapper.Wrapper;
|
import com.baomidou.mybatisplus.plugins.Page;
|
import com.core.annotations.ManagerAuth;
|
import com.core.common.*;
|
import com.zy.asrs.entity.*;
|
import com.zy.asrs.entity.result.WrkTraceVo;
|
import com.zy.asrs.excel.CloseOrderReadListener;
|
import com.zy.asrs.excel.ExcelOrder;
|
import com.zy.asrs.service.*;
|
import com.zy.common.web.BaseController;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import java.io.IOException;
|
import java.util.*;
|
|
@Slf4j
|
@RestController
|
public class OrderLogController extends BaseController {
|
|
@Autowired
|
private OrderLogService orderLogService;
|
@Autowired
|
private OrderDetlLogService orderDetlLogService;
|
@Autowired
|
private SnowflakeIdWorker snowflakeIdWorker;
|
@Autowired
|
private DocTypeService docTypeService;
|
@Autowired
|
private WrkDetlService wrkDetlService;
|
@Autowired
|
private WrkMastService wrkMastService;
|
@Autowired
|
private WrkMastLogService wrkMastLogService;
|
@Autowired
|
private LocDetlService locDetlService;
|
@Autowired
|
private MatService matService;
|
|
@Autowired
|
private OrderService orderService;
|
|
@RequestMapping(value = "/orderLog/nav/list/auth")
|
@ManagerAuth
|
public R navList(@RequestParam(required = false) String orderNo){
|
EntityWrapper<OrderLog> wrapper = new EntityWrapper<>();
|
if (!Cools.isEmpty(orderNo)) {
|
wrapper.like("order_no", orderNo);
|
}
|
wrapper.le("settle", 2).eq("status", 1);
|
wrapper.orderBy("create_time", false);
|
List<OrderLog> orders = orderLogService.selectList(wrapper);
|
// 保留出库单
|
if (!Cools.isEmpty(orders)) {
|
Iterator<OrderLog> iterator = orders.iterator();
|
while (iterator.hasNext()) {
|
OrderLog order = iterator.next();
|
if (order.getDocType() != null) {
|
DocType docType = docTypeService.selectById(order.getDocType());
|
if (docType != null) {
|
if (docType.getPakout() == 0) {
|
iterator.remove();
|
}
|
}
|
}
|
}
|
}
|
return R.ok().add(orders);
|
}
|
|
@RequestMapping(value = "/orderLog/head/page/auth")
|
@ManagerAuth
|
public R head(@RequestParam(defaultValue = "1")Integer curr,
|
@RequestParam(defaultValue = "10")Integer limit,
|
@RequestParam(required = false)String orderByField,
|
@RequestParam(required = false)String orderByType,
|
@RequestParam Map<String, Object> param){
|
EntityWrapper<OrderLog> wrapper = new EntityWrapper<>();
|
excludeTrash(param);
|
convert(param, wrapper);
|
if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} else {
|
wrapper.orderBy("settle").orderBy("create_time", false);
|
}
|
wrapper.eq("status", 1);
|
return R.ok(orderLogService.selectPage(new Page<>(curr, limit), wrapper));
|
}
|
|
@RequestMapping(value = "/orderLog/detl/all/auth")
|
@ManagerAuth
|
public R head(@RequestParam Long orderId){
|
return R.ok().add(orderDetlLogService.selectList(new EntityWrapper<OrderDetlLog>().eq("order_id", orderId)));
|
}
|
|
|
|
|
|
@PostMapping(value = "/orderLog/wrk/trace/auth")
|
@ManagerAuth
|
public R orderWrkTrace(@RequestParam("orderId") Long orderId) {
|
OrderLog order = orderLogService.selectById(orderId);
|
if (null == order) {
|
return R.error("单据不存在");
|
}
|
// 数量统计
|
List<OrderDetlLog> orderDetls = orderDetlLogService.selectList(new EntityWrapper<OrderDetlLog>().eq("order_id", orderId));
|
double totalQty = 0;
|
double wrkQty = 0;
|
double lackQty = 0;
|
for (OrderDetlLog orderDetl : orderDetls) {
|
totalQty = totalQty + orderDetl.getAnfme();
|
wrkQty = wrkQty + orderDetl.getQty();
|
double issued = Optional.of(orderDetl.getAnfme() - orderDetl.getQty()).orElse(0.0D);
|
if (issued > 0.0) {
|
List<LocDetl> locDetls = locDetlService.queryStock(orderDetl.getMatnr(), orderDetl.getBatch(), orderDetl.getOrigin(), null);
|
for (LocDetl locDetl : locDetls) {
|
if (issued > 0) {
|
issued = issued - locDetl.getAnfme();
|
} else {
|
break;
|
}
|
}
|
}
|
if (issued > 0.0) {
|
lackQty = lackQty + issued;
|
}
|
}
|
// 任务追溯
|
List<WrkTraceVo> wrkTraceVos = new ArrayList<>();
|
List<WrkDetl> wrkDetls = wrkDetlService.selectAndLogByOrderNoGroupByMatnrOfSum(order.getOrderNo());
|
for (WrkDetl wrkDetl : wrkDetls) {
|
WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("wrk_no", wrkDetl.getWrkNo()).eq("io_time", wrkDetl.getIoTime()));
|
if (wrkMast == null) {
|
WrkMastLog wrkMastLog = wrkMastLogService.selectOne(new EntityWrapper<WrkMastLog>().eq("wrk_no", wrkDetl.getWrkNo()).eq("io_time", wrkDetl.getIoTime()));
|
if (wrkMastLog != null) {
|
wrkMast = new WrkMast();
|
BeanUtils.copyProperties(wrkMastLog, wrkMast);
|
} else {
|
continue;
|
}
|
}
|
boolean exist = false;
|
for (WrkTraceVo vo : wrkTraceVos) {
|
if (vo.getWrkNo().equals(wrkMast.getWrkNo()) && vo.getIoTimeStr().equals(DateUtils.convert(wrkMast.getIoTime()))) {
|
vo.getWrkDetls().add(wrkDetl);
|
exist = true;
|
}
|
}
|
if (!exist) {
|
WrkTraceVo vo = new WrkTraceVo(wrkMast.getWrkNo(), DateUtils.convert(wrkMast.getIoTime()), wrkMast, wrkDetl);
|
wrkTraceVos.add(vo);
|
}
|
}
|
if (!Cools.isEmpty(wrkTraceVos) && wrkTraceVos.size() > 1) {
|
wrkTraceVos.sort((o1, o2) -> (int) (o2.getWrkMast().getIoTime().getTime() - o1.getWrkMast().getIoTime().getTime()));
|
}
|
return R.ok().add(Cools
|
.add("list", wrkTraceVos)
|
.add("orderNo", order.getOrderNo())
|
.add("totalQty", totalQty)
|
.add("wrkQty", wrkQty)
|
.add("lackQty", lackQty)
|
);
|
}
|
|
|
// ------------------------------------------------------------------------------------------------
|
|
@RequestMapping(value = "/orderLog/{id}/auth")
|
@ManagerAuth
|
public R get(@PathVariable("id") String id) {
|
return R.ok(orderLogService.selectById(String.valueOf(id)));
|
}
|
|
@RequestMapping(value = "/orderLog/list/auth")
|
@ManagerAuth
|
public R list(@RequestParam(defaultValue = "1")Integer curr,
|
@RequestParam(defaultValue = "10")Integer limit,
|
@RequestParam(required = false)String orderByField,
|
@RequestParam(required = false)String orderByType,
|
@RequestParam Map<String, Object> param){
|
EntityWrapper<OrderLog> wrapper = new EntityWrapper<>();
|
excludeTrash(param);
|
convert(param, wrapper);
|
if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));}
|
return R.ok(orderLogService.selectPage(new Page<>(curr, limit), wrapper));
|
}
|
|
private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){
|
for (Map.Entry<String, Object> entry : map.entrySet()){
|
String val = String.valueOf(entry.getValue());
|
if (val.contains(RANGE_TIME_LINK)){
|
String[] dates = val.split(RANGE_TIME_LINK);
|
wrapper.ge(entry.getKey(), DateUtils.convert(dates[0]));
|
wrapper.le(entry.getKey(), DateUtils.convert(dates[1]));
|
} else {
|
wrapper.like(entry.getKey(), val);
|
}
|
}
|
}
|
|
|
@RequestMapping(value = "/orderLog/export/auth")
|
@ManagerAuth
|
public R export(@RequestBody JSONObject param){
|
EntityWrapper<OrderLog> wrapper = new EntityWrapper<>();
|
List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);
|
Map<String, Object> map = excludeTrash(param.getJSONObject("order"));
|
convert(map, wrapper);
|
List<OrderLog> list = orderLogService.selectList(wrapper);
|
return R.ok(exportSupport(list, fields));
|
}
|
|
@RequestMapping(value = "/orderLogQuery/auth")
|
@ManagerAuth
|
public R query(String condition) {
|
EntityWrapper<OrderLog> wrapper = new EntityWrapper<>();
|
wrapper.like("id", condition);
|
Page<OrderLog> page = orderLogService.selectPage(new Page<>(0, 10), wrapper);
|
List<Map<String, Object>> result = new ArrayList<>();
|
for (OrderLog order : page.getRecords()){
|
Map<String, Object> map = new HashMap<>();
|
map.put("id", order.getId());
|
map.put("value", order.getOrderNo());
|
result.add(map);
|
}
|
return R.ok(result);
|
}
|
|
@RequestMapping(value = "/orderLog/check/column/auth")
|
@ManagerAuth
|
public R query(@RequestBody JSONObject param) {
|
Wrapper<OrderLog> wrapper = new EntityWrapper<OrderLog>().eq(humpToLine(String.valueOf(param.get("key"))), param.get("val"));
|
if (null != orderLogService.selectOne(wrapper)){
|
return R.parse(BaseRes.REPEAT).add(getComment(Order.class, String.valueOf(param.get("key"))));
|
}
|
return R.ok();
|
}
|
|
/**
|
* 文件上传,关闭单据
|
*/
|
@PostMapping("/order/close")
|
@ResponseBody
|
@ManagerAuth
|
public R upload(MultipartFile file) throws IOException {
|
EasyExcel.read(file.getInputStream(), ExcelOrder.class, new CloseOrderReadListener(orderService)).sheet().doRead();
|
return R.ok();
|
}
|
|
}
|
