| | |
| | | import com.alibaba.fastjson.JSON; |
| | | 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.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.core.annotations.ManagerAuth; |
| | | import com.core.common.BaseRes; |
| | | import com.core.common.Cools; |
| | |
| | | @RequestMapping(value = "/locMast/{id}/auth") |
| | | @ManagerAuth |
| | | public R get(@PathVariable("id") String id) { |
| | | return R.ok(locMastService.selectById(String.valueOf(id))); |
| | | return R.ok(locMastService.getById(String.valueOf(id))); |
| | | } |
| | | |
| | | @RequestMapping(value = "/locMast/list/auth") |
| | |
| | | @RequestParam(required = false)String orderByType, |
| | | @RequestParam Map<String, Object> param){ |
| | | excludeTrash(param); |
| | | EntityWrapper<LocMast> wrapper = new EntityWrapper<>(); |
| | | QueryWrapper<LocMast> wrapper = new QueryWrapper<>(); |
| | | convert(param, wrapper); |
| | | if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} |
| | | return R.ok(locMastService.selectPage(new Page<>(curr, limit), wrapper)); |
| | | if (!Cools.isEmpty(orderByField)){wrapper.orderBy(true, "asc".equals(orderByType), humpToLine(orderByField));} |
| | | return R.ok(locMastService.page(new Page<>(curr, limit), wrapper)); |
| | | } |
| | | |
| | | private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){ |
| | | private <T> void convert(Map<String, Object> map, QueryWrapper<T> wrapper){ |
| | | for (Map.Entry<String, Object> entry : map.entrySet()){ |
| | | String val = String.valueOf(entry.getValue()); |
| | | if (val.contains(RANGE_TIME_LINK)){ |
| | |
| | | if (entry.getKey().equals("loc_no") || entry.getKey().equals("row1") || entry.getKey().equals("bay1") || entry.getKey().equals("lev1")) { |
| | | wrapper.eq(entry.getKey(), val); |
| | | }else { |
| | | wrapper.eq(entry.getKey(), val); |
| | | wrapper.like(entry.getKey(), val); |
| | | } |
| | | } |
| | | } |
| | |
| | | return R.error(); |
| | | } |
| | | for (LocMast entity : list){ |
| | | locMastService.delete(new EntityWrapper<>(entity)); |
| | | locMastService.remove(new QueryWrapper<>(entity)); |
| | | } |
| | | return R.ok(); |
| | | } |
| | |
| | | @ManagerAuth(memo = "库位导出") |
| | | public R export(@RequestBody JSONObject param){ |
| | | List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class); |
| | | EntityWrapper<LocMast> wrapper = new EntityWrapper<>(); |
| | | QueryWrapper<LocMast> wrapper = new QueryWrapper<>(); |
| | | Map<String, Object> map = excludeTrash(param.getJSONObject("locMast")); |
| | | convert(map, wrapper); |
| | | List<LocMast> list = locMastService.selectList(wrapper); |
| | | List<LocMast> list = locMastService.list(wrapper); |
| | | return R.ok(exportSupport(list, fields)); |
| | | } |
| | | |
| | | @RequestMapping(value = "/locMastQuery/auth") |
| | | @ManagerAuth |
| | | public R query(String condition) { |
| | | EntityWrapper<LocMast> wrapper = new EntityWrapper<>(); |
| | | QueryWrapper<LocMast> wrapper = new QueryWrapper<>(); |
| | | wrapper.like("loc_no", condition); |
| | | Page<LocMast> page = locMastService.selectPage(new Page<>(0, 10), wrapper); |
| | | Page<LocMast> page = locMastService.page(new Page<>(0, 10), wrapper); |
| | | List<Map<String, Object>> result = new ArrayList<>(); |
| | | for (LocMast locMast : page.getRecords()){ |
| | | Map<String, Object> map = new HashMap<>(); |
| | |
| | | @RequestMapping(value = "/locMast/check/column/auth") |
| | | @ManagerAuth |
| | | public R query(@RequestBody JSONObject param) { |
| | | Wrapper<LocMast> wrapper = new EntityWrapper<LocMast>().eq(humpToLine(String.valueOf(param.get("key"))), param.get("val")); |
| | | if (null != locMastService.selectOne(wrapper)){ |
| | | QueryWrapper<LocMast> wrapper = new QueryWrapper<LocMast>().eq(humpToLine(String.valueOf(param.get("key"))), param.get("val")); |
| | | if (null != locMastService.getOne(wrapper)){ |
| | | return R.parse(BaseRes.REPEAT).add(getComment(LocMast.class, String.valueOf(param.get("key")))); |
| | | } |
| | | return R.ok(); |
| | |
| | | @ManagerAuth(memo = "初始化库位") |
| | | @Transactional |
| | | public R locMastInit(@RequestParam Integer lev) { |
| | | BasMap basMap = basMapService.selectOne(new EntityWrapper<BasMap>().eq("lev", 1)); |
| | | BasMap basMap = basMapService.getOne(new QueryWrapper<BasMap>().eq("lev", 1)); |
| | | if (Cools.isEmpty(basMap)){ |
| | | return R.error("请先初始化地图"); |
| | | } |
| | |
| | | initBay = 2; |
| | | } |
| | | |
| | | int userConfigRow = -1; |
| | | int userConfirmBay = -1; |
| | | try { |
| | | userConfirmBay = (int) Double.parseDouble(value); |
| | | String[] split = value.split("-"); |
| | | userConfigRow = Integer.parseInt(split[0]); |
| | | userConfirmBay = Integer.parseInt(split[1]); |
| | | }catch (Exception e){} |
| | | |
| | | if (userConfirmBay != -1) { |
| | | initRow = userConfigRow; |
| | | initBay = userConfirmBay; |
| | | } |
| | | |
| | |
| | | } |
| | | } |
| | | |
| | | locMastService.delete(new EntityWrapper<LocMast>()); |
| | | locMastService.remove(new QueryWrapper<LocMast>()); |
| | | |
| | | for (int i = 1; i <= lev; i++) { |
| | | int finalLev = i; |
| | |
| | | locMast.setLocType(Utils.getLocNo(mapX, mapY, finalLev)); |
| | | locMast.setStatus(1); |
| | | locMast.setAppeTime(new Date()); |
| | | locMastService.insert(locMast); |
| | | locMastService.save(locMast); |
| | | }); |
| | | } |
| | | |
| | | redisUtil.del(RedisKeyType.LOC_MAP_BASE.key); |
| | | redisUtil.del(RedisKeyType.LOC_MAST_MAP_LIST.key); |
| | | return R.ok(); |
| | | } |
| | | |