package com.zy.asrs.wms.controller; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.zy.asrs.common.domain.dto.SafeStoDo; import com.zy.asrs.common.domain.dto.SafeStoDto; import com.zy.asrs.common.wms.entity.Mat; import com.zy.asrs.common.wms.entity.Prior; import com.zy.asrs.common.wms.service.MatService; import com.zy.asrs.common.wms.service.PriorService; import com.zy.asrs.framework.annotations.ManagerAuth; import com.zy.asrs.framework.common.*; import com.zy.asrs.framework.domain.KeyValueVo; import com.zy.asrs.common.web.BaseController; import com.zy.asrs.framework.exception.CoolException; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.bind.annotation.*; import java.util.*; @RestController public class PriorController extends BaseController { @Autowired private PriorService priorService; @Autowired private MatService matService; @Autowired private SnowflakeIdWorker snowflakeIdWorker; @RequestMapping(value = "/prior/{id}/auth") @ManagerAuth public R get(@PathVariable("id") String id) { return R.ok(priorService.getById(String.valueOf(id))); } @RequestMapping(value = "/prior/page/auth") @ManagerAuth public R page(@RequestParam(defaultValue = "1") Integer curr, @RequestParam(defaultValue = "10") Integer limit, @RequestParam(required = false) String condition, @RequestParam(required = false) String timeRange, @RequestParam Map param) { LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); if (!Cools.isEmpty(condition)) { wrapper.like(Prior::getId, condition); } if (!Cools.isEmpty(timeRange)) { String[] range = timeRange.split(RANGE_TIME_LINK); wrapper.ge(Prior::getCreateTime, DateUtils.convert(range[0])); wrapper.le(Prior::getCreateTime, DateUtils.convert(range[1])); } return R.ok(priorService.page(new Page<>(curr, limit), wrapper)); } @RequestMapping(value = "/prior/add/auth") @ManagerAuth public R add(Prior prior) { priorService.save(prior); return R.ok(); } @RequestMapping(value = "/prior/update/auth") @ManagerAuth public R update(Prior prior){ if (Cools.isEmpty(prior) || null==prior.getId()){ return R.error(); } priorService.updateById(prior); return R.ok(); } @RequestMapping(value = "/prior/delete/auth") @ManagerAuth public R delete(@RequestParam(value="ids[]") Long[] ids){ for (Long id : ids){ priorService.removeById(id); } return R.ok(); } @RequestMapping(value = "/priorQuery/auth") @ManagerAuth public R query(String condition) { LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); wrapper.like(Prior::getId, condition); Page page = priorService.page(new Page<>(0, 10), wrapper); List> result = new ArrayList<>(); for (Prior prior : page.getRecords()){ Map map = new HashMap<>(); map.put("id", prior.getId()); map.put("value", prior.getId()); result.add(map); } return R.ok(result); } @RequestMapping("/prior/all/get/kv") @ManagerAuth public R getDataKV(@RequestParam(required = false) String condition) { List vos = new ArrayList<>(); LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); if (!Cools.isEmpty(condition)) { wrapper.like(Prior::getId, condition); } priorService.page(new Page<>(1, 30), wrapper).getRecords().forEach(item -> vos.add(new KeyValueVo(String.valueOf(item.getId()), item.getId()))); return R.ok().add(vos); } /** * 安全库存警告分页 */ @RequestMapping(value = "/safeSto/list/auth") @ManagerAuth public R safeStoList(@RequestParam(defaultValue = "1")Integer curr, @RequestParam(defaultValue = "10")Integer limit, @RequestParam Map param){ Long hostId = getHostId(); if (hostId != null) { param.put("host_id", hostId); } IPage safeQtyPage = priorService.getSafeQtyPage(curr, limit, param); return R.ok(safeQtyPage); } @RequestMapping(value = "/safeSto/add/auth") @ManagerAuth(memo = "添加安全库存") public R del(@RequestBody SafeStoDto dto){ if (Cools.isEmpty(dto.getMatId(), dto.getSafeQua())) { return R.parse(BaseRes.PARAM); } if (dto.getSafeQua() <= 0.0D) { return R.error("安全库存量必须大于零"); } Mat mat = matService.getOne(new LambdaQueryWrapper().eq(Mat::getId, dto.getMatId()).eq(Mat::getHostId, getHostId())); if (mat != null) { Prior prior = new Prior(); prior.setHostId(getHostId()); prior.setUuid("SP" + snowflakeIdWorker.nextId()); prior.setMatId(mat.getId()); prior.setMatnr(mat.getMatnr()); prior.setMaktx(mat.getMaktx()); prior.setLocNo(dto.getLocNo()); prior.setSafeQua(dto.getSafeQua()); prior.setCreateBy(getUserId()); prior.setCreateTime(new Date()); prior.setUpdateBy(getUserId()); prior.setUpdateTime(new Date()); prior.setStatus(1); prior.setMemo(dto.getMemo()); if (!priorService.save(prior)) { throw new CoolException("数据保存失败"); } } else { throw new CoolException("服务器内部错误"); } return R.ok(); } @RequestMapping(value = "/safeSto/delete/auth") @ManagerAuth(memo = "删除库存预警") @Transactional public R del(@RequestBody List dtos){ if (Cools.isEmpty(dtos)) { return R.parse(BaseRes.PARAM); } for (SafeStoDto dto : dtos) { if (!priorService.remove(new LambdaQueryWrapper().eq(Prior::getId, dto.getId()).eq(Prior::getHostId, getHostId()))) { throw new CoolException("删除安全库存失败,请重新尝试"); } } return R.ok(); } }