package zy.cloud.wms.manager.controller; import com.alibaba.fastjson.JSONArray; 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.common.*; import org.apache.poi.ss.formula.functions.Now; import zy.cloud.wms.manager.entity.Quality; import zy.cloud.wms.manager.entity.QualityDetl; import zy.cloud.wms.manager.entity.Receive; import zy.cloud.wms.manager.entity.ReceiveDetl; import zy.cloud.wms.manager.service.QualityDetlService; import zy.cloud.wms.manager.service.QualityService; import com.core.annotations.ManagerAuth; import zy.cloud.wms.common.web.BaseController; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import zy.cloud.wms.manager.service.ReceiveDetlService; import zy.cloud.wms.manager.utils.AddZero; import java.text.DecimalFormat; import java.text.SimpleDateFormat; import java.util.*; @RestController public class QualityController extends BaseController { @Autowired private QualityService qualityService; @Autowired private ReceiveDetlService receiveDetlService; @Autowired private QualityDetlService qualityDetlService; @Autowired private SnowflakeIdWorker snowflakeIdWorker; @RequestMapping(value = "/quality/{id}/auth") @ManagerAuth public R get(@PathVariable("id") String id) { return R.ok(qualityService.selectById(String.valueOf(id))); } @RequestMapping(value = "/quality/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 param){ EntityWrapper wrapper = new EntityWrapper<>(); excludeTrash(param); convert(param, wrapper); if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} return R.ok(qualityService.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); } } } @RequestMapping(value = "/quality/add/auth") @ManagerAuth public R add(Quality quality) { qualityService.insert(quality); Wrapper wrapper = new EntityWrapper(); List list = receiveDetlService.selectList(wrapper.eq("order_no",quality.getUuid() )); if(list.size()>0){ for(ReceiveDetl detl:list){ QualityDetl qualityDetl = new QualityDetl(); qualityDetl.setAnfme(detl.getAnfme()); qualityDetl.setBillNo(quality.getBillNo()); qualityDetl.setOrderNo(detl.getOrderNo()); qualityDetl.setMatnr(detl.getMatnr()); qualityDetl.setMaktx(detl.getMaktx()); qualityDetl.setProdDate(new Date()); qualityDetlService.insert(qualityDetl); } } return R.ok(); } @RequestMapping("/quality/orderNo/init1") @ManagerAuth(memo = "生成单据编号") public R initOrderNo() { String billNo = "QC-" + new SimpleDateFormat("yyyyMMdd").format(new Date())+"-"; String currNum = qualityService.getCurrNum(billNo); String orderNo=null; if (!Cools.isEmpty(currNum)) { String[] split = currNum.split("-"); if (split.length < 2){ orderNo= billNo + "0001"; } Integer newNum = Integer.parseInt(split[2]) +1; String format = AddZero.addZeroForNum(newNum + "", 4); orderNo = billNo + format; }else { orderNo = billNo + "0001"; } return R.ok().add(orderNo); } @RequestMapping(value = "/quality/update/auth") @ManagerAuth public R update(Quality quality){ if (Cools.isEmpty(quality) || null==quality.getId()){ return R.error(); } qualityService.updateById(quality); return R.ok(); } @RequestMapping(value = "/quality/delete/auth") @ManagerAuth public R delete(@RequestParam(value="ids[]") Long[] ids){ for (Long id : ids){ qualityService.deleteById(id); } return R.ok(); } // @RequestMapping("/orderNo/init1") // @ManagerAuth(memo = "生成单据编号") // public R initOrderNo() { // long nextId = snowflakeIdWorker.nextId(); // String orderNo = "QC-" + String.valueOf(nextId).substring(0, 15); // if (qualityService.selectByOrderNo(orderNo, getHostId()) != null) { // return R.error("抱歉,单据编号已存在"); // } // return R.ok().add(orderNo); // } @RequestMapping(value = "/quality/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("quality")); convert(map, wrapper); List list = qualityService.selectList(wrapper); return R.ok(exportSupport(list, fields)); } @RequestMapping(value = "/qualityQuery/auth") @ManagerAuth public R query(String condition) { EntityWrapper wrapper = new EntityWrapper<>(); wrapper.like("id", condition); Page page = qualityService.selectPage(new Page<>(0, 10), wrapper); List> result = new ArrayList<>(); for (Quality quality : page.getRecords()){ Map map = new HashMap<>(); map.put("id", quality.getId()); map.put("value", quality.getId()); result.add(map); } return R.ok(result); } @RequestMapping(value = "/quality/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 != qualityService.selectOne(wrapper)){ return R.parse(BaseRes.REPEAT).add(getComment(Quality.class, String.valueOf(param.get("key")))); } return R.ok(); } }