From ac4341ea6b66ae02427d39d35f41d42d78b2eb2e Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期五, 14 二月 2025 10:08:32 +0800 Subject: [PATCH] # --- zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java | 125 ++++++++++++++++++++++++++++++++++------- 1 files changed, 104 insertions(+), 21 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 26147cd..984a684 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,14 +1,20 @@ 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; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.zy.asrs.framework.common.Cools; import com.zy.asrs.framework.common.R; +import com.zy.asrs.framework.exception.CoolException; import com.zy.asrs.wms.asrs.entity.*; +import com.zy.asrs.wms.asrs.entity.enums.LocStsType; +import com.zy.asrs.wms.asrs.entity.param.LocDetlFreezeParam; import com.zy.asrs.wms.asrs.service.LocDetlFieldService; +import com.zy.asrs.wms.asrs.service.LocService; import com.zy.asrs.wms.asrs.service.MatFieldService; +import com.zy.asrs.wms.common.annotation.CacheData; import com.zy.asrs.wms.common.annotation.OperationLog; import com.zy.asrs.wms.common.domain.BaseParam; import com.zy.asrs.wms.common.domain.KeyValVo; @@ -21,15 +27,14 @@ import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; -import java.util.ArrayList; -import java.util.Arrays; -import java.util.List; -import java.util.Map; +import java.util.*; @RestController @RequestMapping("/api") public class LocDetlController extends BaseController { + @Autowired + private LocService locService; @Autowired private LocDetlService locDetlService; @Autowired @@ -39,20 +44,8 @@ @PreAuthorize("hasAuthority('asrs:locDetl:list')") @PostMapping("/locDetl/page") + @CacheData(tableName = {"man_loc_detl"}) public R page(@RequestBody Map<String, Object> map) { -// BaseParam baseParam = buildParam(map, BaseParam.class); -// PageParam<LocDetl, BaseParam> pageParam = new PageParam<>(baseParam, LocDetl.class); -// -// PageParam<LocDetl, BaseParam> page = locDetlService.page(pageParam, pageParam.buildWrapper(true)); -// JSONObject data = JSON.parseObject(JSON.toJSONString(page)); -// -// List<LocDetl> records = page.getRecords(); -// data.put("records", records); -// for (LocDetl locDetl : records) { -// List<LocDetlField> list = locDetlFieldService.list(new LambdaQueryWrapper<LocDetlField>().eq(LocDetlField::getDetlId, locDetl.getId())); -// locDetl.syncField(list); -// } - 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)); @@ -60,14 +53,64 @@ } @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); + PageParam<ViewLocDetl, BaseParam> data = locDetlService.getPage(pageParam, queryWrapper); + return R.ok().add(data); + } + + @PreAuthorize("hasAuthority('asrs:locDetl:list')") @PostMapping("/locDetl/list") + @CacheData(tableName = {"man_loc_detl"}) public R list(@RequestBody Map<String, Object> map) { List<LocDetl> list = locDetlService.getLocDetlList(map); return R.ok().add(list); } @PreAuthorize("hasAuthority('asrs:locDetl:list')") + @PostMapping("/locDetl/listByIds") + @CacheData(tableName = {"man_loc_detl"}) + public R listByIds(@RequestBody List<Long> ids) { + List<LocDetl> list = locDetlService.listByIds(ids); + List<LocDetl> locDetls = locDetlService.parseLocDetl(list); + return R.ok().add(locDetls); + } + + @PreAuthorize("hasAuthority('asrs:locDetl:list')") + @GetMapping("/locDetl/locId/{locId}") + @CacheData(tableName = {"man_loc_detl"}) + public R list(@PathVariable("locId") Long locId) { + List<LocDetl> list = locDetlService.list(new LambdaQueryWrapper<LocDetl>().eq(LocDetl::getLocId, locId)); + List<LocDetl> locDetls = locDetlService.parseLocDetl(list); + return R.ok().add(locDetls); + } + + @PreAuthorize("hasAuthority('asrs:locDetl:list')") + @GetMapping("/locDetl/locNo/{locNo}") + @CacheData(tableName = {"man_loc_detl"}) + public R list(@PathVariable("locNo") String locNo) { + Loc loc = locService.getOne(new LambdaQueryWrapper<Loc>().eq(Loc::getLocNo, locNo)); + if (loc == null) { + return R.error("搴撲綅涓嶅瓨鍦�"); + } + List<LocDetl> list = locDetlService.list(new LambdaQueryWrapper<LocDetl>().eq(LocDetl::getLocId, loc.getId())); + List<LocDetl> locDetls = locDetlService.parseLocDetl(list); + return R.ok().add(locDetls); + } + + @PreAuthorize("hasAuthority('asrs:locDetl:list')") @GetMapping("/locDetl/{id}") + @CacheData(tableName = {"man_loc_detl"}) public R get(@PathVariable("id") Long id) { return R.ok().add(locDetlService.getById(id)); } @@ -97,14 +140,17 @@ locDetlField.setName(matField.getName()); locDetlFieldService.save(locDetlField); } - return R.ok("娣诲姞鎴愬姛"); } @PreAuthorize("hasAuthority('asrs:locDetl:update')") @OperationLog("淇敼搴撳瓨鏄庣粏") @PostMapping("/locDetl/update") - public R update(@RequestBody LocDetl locDetl) { + public R update(@RequestBody HashMap<String,Object> param) { + LocDetl locDetl = JSON.parseObject(JSON.toJSONString(param), LocDetl.class, Feature.DisableCircularReferenceDetect); + //璁剧疆鎵╁睍瀛楁 + setLocDetlField(param, locDetl); + if (!locDetlService.updateById(locDetl)) { return R.error("淇敼澶辫触"); } @@ -138,7 +184,44 @@ @PreAuthorize("hasAuthority('asrs:locDetl:list')") @PostMapping("/locDetl/export") public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception { - ExcelUtil.build(ExcelUtil.create(locDetlService.list(), LocDetl.class), response); + BaseParam baseParam = buildParam(map, BaseParam.class); + PageParam<LocDetl, BaseParam> pageParam = new PageParam<>(baseParam, LocDetl.class); + List<LocDetl> data = locDetlService.list(pageParam.buildWrapper(true)); + + List<LocDetl> locDetls = locDetlService.parseLocDetl(data); + List<MatField> locFields = matFieldService.getLocFields(); + ExcelUtil.build(ExcelUtil.create(locDetls, LocDetl.class, locFields), response); + } + + private void setLocDetlField(HashMap<String, Object> param, LocDetl locDetl) { + //鑾峰彇鎵╁睍瀛楁 + List<MatField> matFields = matFieldService.list(new LambdaQueryWrapper<MatField>().eq(MatField::getFieldType, 1)); + for (MatField matField : matFields) { + if (param.containsKey(matField.getName())) { + LocDetlField fieldValue = locDetlFieldService.getOne(new LambdaQueryWrapper<LocDetlField>() + .eq(LocDetlField::getDetlId, locDetl.getId()) + .eq(LocDetlField::getFieldId, matField.getId())); + if (fieldValue == null) { + fieldValue = new LocDetlField(); + fieldValue.setDetlId(locDetl.getId()); + fieldValue.setFieldId(matField.getId()); + fieldValue.setName(matField.getName()); + fieldValue.setValue(param.get(matField.getName()).toString()); + locDetlFieldService.save(fieldValue); + }else { + fieldValue.setValue(param.get(matField.getName()).toString()); + locDetlFieldService.updateById(fieldValue); + } + } + } + } + + @PreAuthorize("hasAuthority('asrs:locDetl:update')") + @OperationLog("搴撳瓨鍐荤粨") + @PostMapping("/locDetl/freeze") + public R freeze(@RequestBody LocDetlFreezeParam param) { + locDetlService.locDetlFreeze(param); + return R.ok(); } } -- Gitblit v1.9.1