From 256c59555e2a5dffdd6d127a519d4f0944b80e7f Mon Sep 17 00:00:00 2001 From: zjj <3272660260@qq.com> Date: 星期三, 14 五月 2025 16:29:38 +0800 Subject: [PATCH] #物料表动态字段搜索 --- rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderItemController.java | 113 ++++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 92 insertions(+), 21 deletions(-) diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderItemController.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderItemController.java index ab28479..5dd2240 100644 --- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderItemController.java +++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderItemController.java @@ -1,5 +1,8 @@ package com.vincent.rsf.server.manager.controller; + +import com.alibaba.fastjson.JSONArray; +import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.vincent.rsf.framework.common.Cools; @@ -10,33 +13,53 @@ import com.vincent.rsf.server.common.domain.BaseParam; import com.vincent.rsf.server.common.domain.KeyValVo; import com.vincent.rsf.server.common.domain.PageParam; -import com.vincent.rsf.server.manager.controller.params.AsnOrderItemParams; +import com.vincent.rsf.server.common.utils.FieldsUtils; import com.vincent.rsf.server.manager.entity.AsnOrderItem; +import com.vincent.rsf.server.manager.entity.Companys; +import com.vincent.rsf.server.manager.entity.Matnr; +import com.vincent.rsf.server.manager.entity.excel.AsnOrderTemplate; +import com.vincent.rsf.server.manager.enums.CompanysType; import com.vincent.rsf.server.manager.service.AsnOrderItemService; +import com.vincent.rsf.server.manager.service.CompanysService; import com.vincent.rsf.server.system.controller.BaseController; -import com.vincent.rsf.server.system.utils.SerialRuleUtils; +import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; +import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; -import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.*; +@Api(tags = "ASN鍗曟槑缁�") @RestController public class AsnOrderItemController extends BaseController { @Autowired private AsnOrderItemService asnOrderItemService; + @Autowired + private CompanysService companysService; + @PreAuthorize("hasAuthority('manager:asnOrderItem:list')") + @ApiOperation("鍒嗛〉鑾峰彇鍒楄〃") @PostMapping("/asnOrderItem/page") public R page(@RequestBody Map<String, Object> map) { BaseParam baseParam = buildParam(map, BaseParam.class); PageParam<AsnOrderItem, BaseParam> pageParam = new PageParam<>(baseParam, AsnOrderItem.class); - return R.ok().add(asnOrderItemService.page(pageParam, pageParam.buildWrapper(true))); + /**鎷兼帴鎵╁睍瀛楁*/ + PageParam<AsnOrderItem, BaseParam> page = asnOrderItemService.page(pageParam, pageParam.buildWrapper(true)); + List<AsnOrderItem> records = page.getRecords(); + for (AsnOrderItem record : records) { + if (!Objects.isNull(record.getFieldsIndex())) { + Map<String, String> fields = FieldsUtils.getFields(record.getFieldsIndex()); + record.setExtendFields(fields); + } + } + page.setRecords(records); + return R.ok(page); } @PreAuthorize("hasAuthority('manager:asnOrderItem:list')") @@ -60,18 +83,19 @@ @PreAuthorize("hasAuthority('manager:asnOrderItem:save')") @OperationLog("Create ASN鍗曟嵁") @PostMapping("/asnOrderItem/save") - public R save(@RequestBody AsnOrderItem asnOrderItem) { - asnOrderItem.setCreateBy(getLoginUserId()); - asnOrderItem.setUpdateBy(getLoginUserId()); - String code = SerialRuleUtils.generateRuleCode("sys_ans_order", asnOrderItem); - if (!Objects.isNull(code)) { - asnOrderItem.setAsnCode(code); + public R save(@RequestBody Map<String, Object> params) { + if (Objects.isNull(params)) { + throw new CoolException("淇℃伅涓嶈兘涓虹┖锛侊紒"); } - if (!asnOrderItemService.save(asnOrderItem)) { + params.put("createBy", getLoginUserId()); + params.put("updateBy", getLoginUserId()); + + if (!asnOrderItemService.fieldsSave(params, getLoginUserId())) { return R.error("Save Fail"); } - return R.ok("Save Success").add(asnOrderItem); + return R.ok("Save Success"); } + @PreAuthorize("hasAuthority('manager:asnOrderItem:update')") @OperationLog("Update ASN鍗曟嵁") @@ -79,6 +103,14 @@ public R update(@RequestBody AsnOrderItem asnOrderItem) { asnOrderItem.setUpdateBy(getLoginUserId()); asnOrderItem.setUpdateTime(new Date()); + if (!Objects.isNull(asnOrderItem.getSplrName()) && StringUtils.isNotBlank(asnOrderItem.getSplrName())) { + Companys companys = companysService.getOne(new LambdaQueryWrapper<Companys>() + .eq(Companys::getType, CompanysType.COMPANYS_TYPE_SUPPLIER.val) + .eq(Companys::getId, asnOrderItem.getSplrName())); + if (!Objects.isNull(companys)) { + asnOrderItem.setSplrCode(companys.getCode()).setSplrName(companys.getName()); + } + } if (!asnOrderItemService.updateById(asnOrderItem)) { return R.error("Update Fail"); } @@ -111,8 +143,34 @@ @PreAuthorize("hasAuthority('manager:asnOrderItem:list')") @PostMapping("/asnOrderItem/export") + @ApiOperation("瀵煎嚭鏀惰揣閫氱煡鍗曟槑缁�") public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception { - ExcelUtil.build(ExcelUtil.create(asnOrderItemService.list(), AsnOrderItem.class), response); + List<AsnOrderItem> orderItems = new ArrayList<>(); + if (!Objects.isNull(map.get("ids"))) { + List<Long> ids = JSONArray.parseArray(JSONObject.toJSONString(map.get("ids")), Long.class); + if (!ids.isEmpty()) { + orderItems = asnOrderItemService.list(new LambdaQueryWrapper<AsnOrderItem>() + .in(AsnOrderItem::getId, ids) + .eq(AsnOrderItem::getStatus, 1)); + } else { + orderItems = asnOrderItemService.list(new LambdaQueryWrapper<>()); + } + } else { + orderItems = asnOrderItemService.list(new LambdaQueryWrapper<>()); + } + + ExcelUtil.build(ExcelUtil.create(orderItems, AsnOrderItem.class, true), response); + } + + + @PostMapping("/asnOrderItem/generate/barcode") + @ApiOperation("鐢熸垚ASN鏍囩") + @PreAuthorize("hasAuthority('manager:asnOrder:list')") + public R generateBarcode(@RequestBody List<Long> orders) { + if (orders.isEmpty()) { + return R.error("鍗曟嵁涓嶈兘涓虹┖!!"); + } + return asnOrderItemService.generateBarcode(orders); } /** @@ -120,18 +178,31 @@ * @param file * @return */ - @PostMapping("/asnOrder/import") + @PostMapping("/asnOrderItem/import") @ApiOperation("ASN瀵煎叆鎺ュ彛") - @PreAuthorize("hasAuthority('manager:asnOrder:update')") - public R importExcel(@RequestParam(value = "file") MultipartFile file, HttpServletRequest request) throws Exception { + @PreAuthorize("hasAuthority('manager:asnOrderItem:update')") + public R importExcel(@RequestParam(value = "file") MultipartFile file) throws Exception { if (Objects.isNull(file)) { - throw new CoolException("鏂囦欢涓嶈兘涓虹┖锛侊紒"); + return R.error("鏂囦欢涓嶈兘涓虹┖锛侊紒"); } HashMap<String, Object> hashMap = new HashMap<>(); - if (!Objects.isNull(request.getParameter("asnId"))) { - hashMap.put("asnId", request.getParameter("asnId")); - } - return asnOrderItemService.excelImport(file, hashMap); + return asnOrderItemService.excelImport(file, hashMap, getLoginUserId()); + } + + /** + * @author Ryan + * @description 涓嬭浇妯℃澘 + * @param + * @return + * @time 2025/4/18 08:17 + */ + @PostMapping("/asnOrderItem/template/download") + @ApiOperation("涓嬭浇鏀惰揣鍗曟ā鏉�") + @PreAuthorize("hasAuthority('manager:asnOrderItem:update')") + public void downloadTemplate(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception { + AsnOrderTemplate template = ExcelUtil.mockData(AsnOrderTemplate.class); + List<AsnOrderTemplate> list = Arrays.asList(template); + ExcelUtil.build(ExcelUtil.create(list, AsnOrderTemplate.class, true), response); } } -- Gitblit v1.9.1