From efa392d963d11000ef22c6778684648042a80ac6 Mon Sep 17 00:00:00 2001 From: skyouc Date: 星期六, 09 八月 2025 16:19:33 +0800 Subject: [PATCH] 8月8号问题修复 --- zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java | 38 ++++++++++++++++++++++++-------------- 1 files changed, 24 insertions(+), 14 deletions(-) diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java index 6c98627..48eb374 100644 --- a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java +++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java @@ -1,6 +1,7 @@ package com.zy.asrs.wms.asrs.controller; import com.alibaba.fastjson.JSON; +import com.alibaba.fastjson.JSONObject; import com.alibaba.fastjson.parser.Feature; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; @@ -22,6 +23,7 @@ import com.zy.asrs.wms.asrs.service.LocDetlService; import com.zy.asrs.wms.system.controller.BaseController; import com.zy.asrs.wms.utils.ExcelUtil; +import com.zy.asrs.wms.utils.Utils; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; @@ -45,33 +47,41 @@ @PreAuthorize("hasAuthority('asrs:locDetl:list')") @PostMapping("/locDetl/page") - @CacheData(tableName = {"man_loc_detl"}) public R page(@RequestBody Map<String, Object> map) { -// String orderType = null; -// if (Objects.isNull(map.get("orderType"))) { -// orderType = map.get("orderType").toString(); -// map.remove("orderType"); -// } + Map<String, String> order = new HashMap<>(); + if (!Objects.isNull(map.get("orderBy"))) { + order = JSONObject.parseObject(JSON.toJSONString(map.get("orderBy")), Map.class); + } BaseParam baseParam = buildParam(map, BaseParam.class); PageParam<ViewLocDetl, BaseParam> pageParam = new PageParam<>(baseParam, ViewLocDetl.class); - PageParam<ViewLocDetl, BaseParam> data = locDetlService.getPage(pageParam, pageParam.buildWrapper(true)); + QueryWrapper<ViewLocDetl> wrapper = pageParam.ignoreWrapper(true); + if (!Cools.isEmpty(order)) { + String fileds = Utils.toSymbolCase(order.get("field"), '_'); + if (order.get("order").equals("asc")) { + wrapper.orderByAsc(fileds); + } else { + wrapper.orderByDesc(fileds); + } + } else { + wrapper.orderByDesc("create_time"); + } + PageParam<ViewLocDetl, BaseParam> data = locDetlService.getPage(pageParam, wrapper); - return R.ok(data); + return R.ok().add(data); } @PreAuthorize("hasAuthority('asrs:locDetl:list')") @PostMapping("/locDetl/outPage") - @CacheData(tableName = {"man_loc_detl"}) public R outPage(@RequestBody Map<String, Object> map) { BaseParam baseParam = buildParam(map, BaseParam.class); PageParam<ViewLocDetl, BaseParam> pageParam = new PageParam<>(baseParam, ViewLocDetl.class); QueryWrapper<ViewLocDetl> queryWrapper = pageParam.buildWrapper(true); - List<Long> locIds = locService.listBySts(LocStsType.F.val()); - if (locIds.isEmpty()) { - locIds.add(-1L); - } - queryWrapper.in("loc_id", locIds); +// List<Long> locIds = locService.listBySts(LocStsType.F.val()); +// if (locIds.isEmpty()) { +// locIds.add(-1L); +// } +// queryWrapper.in("loc_id", locIds); PageParam<ViewLocDetl, BaseParam> data = locDetlService.getPage(pageParam, queryWrapper); return R.ok().add(data); } -- Gitblit v1.9.1