package com.zy.asrs.controller; 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.BaseRes; import com.core.common.Cools; import com.core.common.DateUtils; import com.core.common.R; import com.zy.asrs.entity.InventoryCheckOrder; import com.zy.asrs.entity.InventoryCheckOrderDetl; import com.zy.asrs.entity.WrkDetl; import com.zy.asrs.entity.WrkMast; import com.zy.asrs.service.InventoryCheckOrderDetlService; import com.zy.asrs.service.InventoryCheckOrderService; import com.zy.asrs.service.WrkDetlService; import com.zy.asrs.service.WrkMastService; import com.zy.common.web.BaseController; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.*; @RestController public class InventoryCheckOrderController extends BaseController { @Autowired private InventoryCheckOrderService inventoryCheckOrderService; @Autowired private InventoryCheckOrderDetlService inventoryCheckOrderDetlService; @Autowired private WrkMastService wrkMastService; @Autowired private WrkDetlService wrkDetlService; @RequestMapping("/inventoryCheckOrder/StockCheck/select/barcode") @ManagerAuth() public R StockCheckSelectBarcode(@RequestParam String barcode) { if (Cools.isEmpty(barcode)) { return R.ok(); } WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper().eq("barcode", barcode)); if (Cools.isEmpty(wrkMast)) { return R.error("该条码未查询到盘点任务"); } ArrayList checkOrderDetls = new ArrayList<>(); List wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo()); for (WrkDetl wrkDetl : wrkDetls) { InventoryCheckOrderDetl checkDetl = inventoryCheckOrderDetlService.selectOne(new EntityWrapper() .eq("order_no", wrkMast.getSheetNo()) .eq("matnr", wrkDetl.getMatnr()) .eq("batch", wrkDetl.getBatch())); if (Cools.isEmpty(checkDetl)) { continue; } checkOrderDetls.add(checkDetl); } return R.ok(checkOrderDetls); } @RequestMapping("/inventoryCheckOrder/select/status/1") @ManagerAuth() public R availableTakeCheckSite(){ return R.ok().add(inventoryCheckOrderService.selectList(new EntityWrapper().eq("status", "1"))); } @RequestMapping(value = "/inventoryCheckOrder/nav/list/auth") @ManagerAuth public R navList(@RequestParam(required = false) String orderNo){ EntityWrapper wrapper = new EntityWrapper<>(); if (!Cools.isEmpty(orderNo)) { wrapper.like("order_no", orderNo); } wrapper.eq("status", 1); wrapper.orderBy("create_time", false); List orders = inventoryCheckOrderService.selectList(wrapper); return R.ok().add(orders); } @RequestMapping(value = "/inventoryCheckOrder/{id}/auth") @ManagerAuth public R get(@PathVariable("id") String id) { return R.ok(inventoryCheckOrderService.selectById(String.valueOf(id))); } @RequestMapping(value = "/inventoryCheckOrder/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(required = false)String condition, @RequestParam Map param){ EntityWrapper wrapper = new EntityWrapper<>(); excludeTrash(param); convert(param, wrapper); allLike(InventoryCheckOrder.class, param.keySet(), wrapper, condition); if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} return R.ok(inventoryCheckOrderService.selectPage(new Page<>(curr, limit), wrapper)); } private void convert(Map map, EntityWrapper wrapper){ for (Map.Entry 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); } } } @PostMapping (value = "/inventoryCheckOrder/add/auth") @ManagerAuth public R add(@RequestBody InventoryCheckOrder inventoryCheckOrder) { String orderNo = inventoryCheckOrder.getOrderNo(); long time = new Date().getTime(); if (Cools.isEmpty(orderNo)) { switch (inventoryCheckOrder.getArea()){ case "堆垛机": orderNo = "DDJ"+time; break; case "四向库": orderNo = "SXK"+time; break; case "CTU": orderNo = "CTU"+time; break; } inventoryCheckOrder.setOrderNo(orderNo); } int count = inventoryCheckOrderService.selectCount(new EntityWrapper().eq("order_no", orderNo)); if (count > 0) { return R.parse("单据编号已经存在:" + orderNo); } inventoryCheckOrder.setCreateBy(getUserId().toString()); inventoryCheckOrder.setCreateTime(new Date()); inventoryCheckOrder.setStatus("1"); inventoryCheckOrderService.insert(inventoryCheckOrder); return R.ok(orderNo + "新增成功"); } @RequestMapping(value = "/inventoryCheckOrder/update/auth") @ManagerAuth public R update(InventoryCheckOrder inventoryCheckOrder){ if (Cools.isEmpty(inventoryCheckOrder) || null==inventoryCheckOrder.getId()){ return R.error(); } inventoryCheckOrderService.updateById(inventoryCheckOrder); return R.ok(); } @RequestMapping(value = "/inventoryCheckOrder/delete/auth") @ManagerAuth public R delete(@RequestParam(value="ids[]") Long[] ids){ for (Long id : ids){ inventoryCheckOrderService.deleteById(id); } return R.ok(); } @RequestMapping(value = "/inventoryCheckOrder/export/auth") @ManagerAuth public R export(@RequestBody JSONObject param){ EntityWrapper wrapper = new EntityWrapper<>(); List fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class); Map map = excludeTrash(param.getJSONObject("inventoryCheckOrder")); convert(map, wrapper); List list = inventoryCheckOrderService.selectList(wrapper); return R.ok(exportSupport(list, fields)); } @RequestMapping(value = "/inventoryCheckOrderQuery/auth") @ManagerAuth public R query(String condition) { EntityWrapper wrapper = new EntityWrapper<>(); wrapper.like("id", condition); Page page = inventoryCheckOrderService.selectPage(new Page<>(0, 10), wrapper); List> result = new ArrayList<>(); for (InventoryCheckOrder inventoryCheckOrder : page.getRecords()){ Map map = new HashMap<>(); map.put("id", inventoryCheckOrder.getId()); map.put("value", inventoryCheckOrder.getId()); result.add(map); } return R.ok(result); } @RequestMapping(value = "/inventoryCheckOrder/check/column/auth") @ManagerAuth public R query(@RequestBody JSONObject param) { Wrapper wrapper = new EntityWrapper().eq(humpToLine(String.valueOf(param.get("key"))), param.get("val")); if (null != inventoryCheckOrderService.selectOne(wrapper)){ return R.parse(BaseRes.REPEAT).add(getComment(InventoryCheckOrder.class, String.valueOf(param.get("key")))); } return R.ok(); } }