From 6f3f068606f1f18ce859def1b6960571fd742605 Mon Sep 17 00:00:00 2001
From: yangyang
Date: 星期四, 20 三月 2025 08:59:19 +0800
Subject: [PATCH] #新增 1. 物料保存扩展字段优化
---
rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/MatnrController.java | 101 +++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 90 insertions(+), 11 deletions(-)
diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/MatnrController.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/MatnrController.java
index 24e5621..12ed36f 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/MatnrController.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/MatnrController.java
@@ -1,25 +1,39 @@
package com.vincent.rsf.server.manager.controller;
+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;
import com.vincent.rsf.framework.common.R;
+import com.vincent.rsf.framework.exception.CoolException;
+import com.vincent.rsf.server.common.domain.PageResult;
+import com.vincent.rsf.server.common.utils.CommonUtil;
import com.vincent.rsf.server.common.utils.ExcelUtil;
import com.vincent.rsf.server.common.annotation.OperationLog;
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.common.utils.FieldsUtils;
import com.vincent.rsf.server.manager.entity.Matnr;
+import com.vincent.rsf.server.manager.entity.excel.MatnrsTemplate;
import com.vincent.rsf.server.manager.service.MatnrService;
import com.vincent.rsf.server.system.controller.BaseController;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import io.swagger.v3.oas.annotations.security.SecurityRequirement;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.http.HttpHeaders;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletResponse;
+import javax.validation.Valid;
+import javax.validation.constraints.NotNull;
import java.util.*;
@RestController
+@Api(tags = "鐗╂枡琛ㄦ帴鍙�")
public class MatnrController extends BaseController {
@Autowired
@@ -30,7 +44,7 @@
public R page(@RequestBody Map<String, Object> map) {
BaseParam baseParam = buildParam(map, BaseParam.class);
PageParam<Matnr, BaseParam> pageParam = new PageParam<>(baseParam, Matnr.class);
- return R.ok().add(matnrService.page(pageParam, pageParam.buildWrapper(true)));
+ return R.ok().add( matnrService.getMatnrPage(pageParam));
}
@PreAuthorize("hasAuthority('manager:matnr:list')")
@@ -45,6 +59,7 @@
return R.ok().add(matnrService.listByIds(Arrays.asList(ids)));
}
+
@PreAuthorize("hasAuthority('manager:matnr:list')")
@GetMapping("/matnr/{id}")
public R get(@PathVariable("id") Long id) {
@@ -52,21 +67,42 @@
}
@PreAuthorize("hasAuthority('manager:matnr:save')")
- @OperationLog("Create 鐗╂枡琛�")
+ @OperationLog("Create 鐗╂枡淇℃伅琛�")
@PostMapping("/matnr/save")
- public R save(@RequestBody Matnr matnr) {
- matnr.setCreateBy(getLoginUserId());
- matnr.setCreateTime(new Date());
- matnr.setUpdateBy(getLoginUserId());
- matnr.setUpdateTime(new Date());
- if (!matnrService.save(matnr)) {
+ public R save(@RequestBody Map<String, Object> matnr) {
+ if (Objects.isNull(matnr)) {
+ throw new CoolException("鍙傛暟涓嶈兘涓虹┖锛侊紒");
+ }
+ if (Objects.isNull(matnr.get("matnr"))) {
+ throw new CoolException("鍚嶇О涓嶈兘涓虹┖锛侊紒");
+ }
+ if (Objects.isNull(matnr.get("code"))) {
+ throw new CoolException("缂栫爜涓嶈兘涓虹┖锛侊紒");
+ }
+ if (Objects.isNull(matnr.get("groupId"))) {
+ throw new CoolException("鐗╂枡鍒嗙粍涓嶈兘涓虹┖锛侊紒");
+ }
+
+ /**
+ * 鎵╁睍瀛楁瀛樺叆搴�
+ */
+ if (!FieldsUtils.getFieldsSta().isEmpty()) {
+ String uuid16 = CommonUtil.randomUUID16();
+ FieldsUtils.saveFields(matnr, uuid16);
+ }
+
+ Matnr matnr1 = JSONObject.parseObject(JSONObject.toJSONString(matnr), Matnr.class);
+ matnr1.setCreateBy(getLoginUserId());
+ matnr1.setUpdateBy(getLoginUserId());
+
+ if (!matnrService.save(matnr1)) {
return R.error("Save Fail");
}
return R.ok("Save Success").add(matnr);
}
@PreAuthorize("hasAuthority('manager:matnr:update')")
- @OperationLog("Update 鐗╂枡琛�")
+ @OperationLog("Update 鐗╂枡淇℃伅琛�")
@PostMapping("/matnr/update")
public R update(@RequestBody Matnr matnr) {
matnr.setUpdateBy(getLoginUserId());
@@ -78,7 +114,7 @@
}
@PreAuthorize("hasAuthority('manager:matnr:remove')")
- @OperationLog("Delete 鐗╂枡琛�")
+ @OperationLog("Delete 鐗╂枡淇℃伅琛�")
@PostMapping("/matnr/remove/{ids}")
public R remove(@PathVariable Long[] ids) {
if (!matnrService.removeByIds(Arrays.asList(ids))) {
@@ -102,9 +138,52 @@
}
@PreAuthorize("hasAuthority('manager:matnr:list')")
+ @ApiOperation(value = "鑾峰彇鍒嗙被鐗╂枡鏄庣粏鍒楄〃")
+ @PostMapping("/matnr/group")
+ public R getGroupMatnrs(@RequestBody Map<String, Object> map) {
+ BaseParam baseParam = buildParam(map, BaseParam.class);
+ PageParam<Matnr, BaseParam> pageParam = new PageParam<>(baseParam, Matnr.class);
+ LambdaQueryWrapper<Matnr> wrapper = new LambdaQueryWrapper<>();
+ if (!Cools.isEmpty(map.get("condition"))) {
+ wrapper.like(Matnr::getName, map.get("condition"));
+ }
+ if (Cools.isEmpty(map.get("groupId"))) {
+ throw new CoolException("鍒嗙被ID涓嶈兘涓虹┖锛侊紒");
+ }
+ wrapper.eq(Matnr::getGroupId, map.get("groupId"));
+ Page<Matnr> matnrPage = matnrService.page(new Page<>(1, 30), wrapper);
+ return R.ok(new PageResult().setRecords(matnrPage.getRecords()).setTotal(matnrPage.getTotal()));
+ }
+
+ @PreAuthorize("hasAuthority('manager:matnr:list')")
+ @ApiOperation("瀵煎嚭鐗╂枡淇℃伅")
@PostMapping("/matnr/export")
public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
- ExcelUtil.build(ExcelUtil.create(matnrService.list(), Matnr.class), response);
+ List<Matnr> matnrs = new ArrayList<>();
+ if (!Objects.isNull(map.get("ids"))) {
+ matnrs = matnrService.list(new LambdaQueryWrapper<Matnr>().in(Matnr::getId, map.get("ids")).eq(Matnr::getStatus, 1));
+ } else {
+ matnrs = matnrService.list(new LambdaQueryWrapper<Matnr>().last("limit 1"));
+ }
+ ExcelUtil.build(ExcelUtil.create(null, MatnrsTemplate.class, true), response);
+ }
+
+ @PreAuthorize("hasAuthority('manager:matnr:list')")
+ @ApiOperation("涓嬭浇鐗╂枡妯℃澘")
+ @PostMapping("/matnr/template/download")
+ public void download(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
+ ExcelUtil.build(ExcelUtil.create(null, MatnrsTemplate.class, true), response);
+ }
+
+
+ @PreAuthorize("hasAuthority('manager:matnr:update')")
+ @ApiOperation(value = "excel琛ㄦ牸瀵煎叆鐗╂枡淇℃伅")
+ @PostMapping("/matnr/import")
+ public R listImport(MultipartFile file) throws Exception {
+ if (Objects.isNull(file)) {
+ throw new CoolException("鏂囦欢涓嶈兘涓虹┖锛侊紒");
+ }
+ return matnrService.importExcels(file);
}
}
--
Gitblit v1.9.1