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.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.zy.asrs.common.wms.entity.WrkMast; import com.zy.asrs.common.wms.service.WrkMastService; import com.zy.asrs.framework.annotations.ManagerAuth; import com.zy.asrs.framework.common.Cools; import com.zy.asrs.framework.common.R; import com.zy.asrs.framework.domain.KeyValueVo; import com.zy.asrs.framework.common.DateUtils; import com.zy.asrs.common.web.BaseController; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.*; @RestController public class WrkMastController extends BaseController { @Autowired private WrkMastService wrkMastService; @RequestMapping(value = "/wrkMast/{id}/auth") @ManagerAuth public R get(@PathVariable("id") String id) { return R.ok(wrkMastService.getById(String.valueOf(id))); } @RequestMapping(value = "/wrkMast/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) { excludeTrash(param); QueryWrapper wrapper = new QueryWrapper<>(); wrapper.eq("host_id",getHostId()); wrapper.orderByDesc("io_pri"); convert(param, wrapper); if (!Cools.isEmpty(condition)) { wrapper.and(item -> { item.like("wrk_no", condition) .or().like("wrk_sts", condition) .or().like("sta_no", condition) .or().like("source_sta_no", condition) .or().like("loc_no", condition) .or().like("barcode",condition) .or().like("source_loc_no", condition); }); } return R.ok(wrkMastService.page(new Page<>(curr, limit), wrapper)); } private void convert(Map map, QueryWrapper 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 = "/wrkMast/add/auth") @ManagerAuth public R add(WrkMast wrkMast) { wrkMast.setHostId(getHostId()); wrkMastService.save(wrkMast); return R.ok(); } @RequestMapping(value = "/wrkMast/update/auth") @ManagerAuth public R update(WrkMast wrkMast){ if (Cools.isEmpty(wrkMast) || null==wrkMast.getId()){ return R.error(); } wrkMastService.updateById(wrkMast); return R.ok(); } @RequestMapping(value = "/wrkMast/delete/auth") @ManagerAuth public R delete(@RequestParam(value="ids[]") Long[] ids){ for (Long id : ids){ wrkMastService.removeById(id); } return R.ok(); } @RequestMapping(value = "/wrkMastQuery/auth") @ManagerAuth public R query(String condition) { LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); wrapper.eq(WrkMast::getHostId, getHostId()); wrapper.like(WrkMast::getWrkNo, condition); Page page = wrkMastService.page(new Page<>(0, 10), wrapper); List> result = new ArrayList<>(); for (WrkMast wrkMast : page.getRecords()){ Map map = new HashMap<>(); map.put("id", wrkMast.getId()); map.put("value", wrkMast.getWrkNo()); result.add(map); } return R.ok(result); } @RequestMapping("/wrkMast/all/get/kv") @ManagerAuth public R getDataKV(@RequestParam(required = false) String condition) { List vos = new ArrayList<>(); LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); wrapper.eq(WrkMast::getHostId, getHostId()); if (!Cools.isEmpty(condition)) { wrapper.like(WrkMast::getWrkNo, condition); } wrkMastService.page(new Page<>(1, 30), wrapper).getRecords().forEach(item -> vos.add(new KeyValueVo(String.valueOf(item.getWrkNo()), item.getId()))); return R.ok().add(vos); } @RequestMapping(value = "/wrkMast/add/pri/auth") @ManagerAuth(memo = "工作档增加优先级") public R addPri(@RequestBody List list) { if (list.isEmpty()) { return R.error("请至少选择一行数据"); } for (WrkMast entity : list){ entity.setIoPri(entity.getIoPri() + 1); } wrkMastService.updateBatchById(list); return R.ok(); } @RequestMapping(value = "/wrkMast/red/pri/auth") @ManagerAuth(memo = "工作档降低优先级") public R redPri(@RequestBody List list) { if (list.isEmpty()) { return R.error("请至少选择一行数据"); } for (WrkMast entity : list){ entity.setIoPri(entity.getIoPri() - 1); } wrkMastService.updateBatchById(list); return R.ok(); } }