From a935fc71d8e52f2ba10e42cfdb9e75ef9cb32bd7 Mon Sep 17 00:00:00 2001
From: skyouc
Date: 星期三, 26 三月 2025 09:52:15 +0800
Subject: [PATCH] #修复 初始化时库区关系未绑定
---
rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/MatnrController.java | 136 ++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 120 insertions(+), 16 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..19837d8 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,36 @@
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.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.controller.params.MatnrToGroupParams;
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 org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletResponse;
import java.util.*;
@RestController
+@Api(tags = "鐗╂枡琛ㄦ帴鍙�")
public class MatnrController extends BaseController {
@Autowired
@@ -30,7 +41,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')")
@@ -48,37 +59,55 @@
@PreAuthorize("hasAuthority('manager:matnr:list')")
@GetMapping("/matnr/{id}")
public R get(@PathVariable("id") Long id) {
- return R.ok().add(matnrService.getById(id));
+ return R.ok(matnrService.selectMatnrById(id));
}
@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)) {
- return R.error("Save Fail");
+ public R save(@RequestBody Map<String, Object> matnr) {
+ if (Objects.isNull(matnr)) {
+ throw new CoolException("鍙傛暟涓嶈兘涓虹┖锛侊紒");
}
- return R.ok("Save Success").add(matnr);
+ if (Objects.isNull(matnr.get("name"))) {
+ throw new CoolException("鍚嶇О涓嶈兘涓虹┖锛侊紒");
+ }
+ if (Objects.isNull(matnr.get("groupId"))) {
+ throw new CoolException("鐗╂枡鍒嗙粍涓嶈兘涓虹┖锛侊紒");
+ }
+ matnr.put("createBy", getLoginUserId());
+ matnr.put("updateBy", getLoginUserId());
+ return matnrService.saveMatnrs(matnr);
+
}
@PreAuthorize("hasAuthority('manager:matnr:update')")
- @OperationLog("Update 鐗╂枡琛�")
+ @OperationLog("Update 鐗╂枡淇℃伅琛�")
@PostMapping("/matnr/update")
- public R update(@RequestBody Matnr matnr) {
+ @Transactional(rollbackFor = Exception.class)
+ public R update(@RequestBody Map<String, Object> params) throws Exception {
+ Matnr matnr = JSONObject.parseObject(JSONObject.toJSONString(params), Matnr.class);
+ if (Objects.isNull(matnr.getCode())) {
+ throw new CoolException("缂栫爜涓嶈兘涓虹┖锛侊紒");
+ }
+ if (Objects.isNull(matnr.getName())) {
+ throw new CoolException("鍚嶇О涓嶈兘涓虹┖锛侊紒");
+ }
matnr.setUpdateBy(getLoginUserId());
- matnr.setUpdateTime(new Date());
if (!matnrService.updateById(matnr)) {
return R.error("Update Fail");
}
+ if (!FieldsUtils.getFieldsSta().isEmpty()) {
+ Matnr matnr1 = matnrService.getById(matnr.getId());
+ params.put("fieldsIndex", matnr1.getFieldsIndex());
+ FieldsUtils.updateFieldsValue(params);
+ }
+
return R.ok("Update Success").add(matnr);
}
@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 +131,84 @@
}
@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/group/bind")
+ public R bindMatnrToGroup(@RequestBody MatnrToGroupParams params) {
+ if (Objects.isNull(params)) {
+ return R.error("鍙傛暟涓嶈兘涓虹┖锛侊紒");
+ }
+ if (matnrService.bindMatnrs(params)) {
+ return R.ok();
+ } else {
+ return R.error("鎿嶄綔澶辫触锛侊紒");
+ }
+ }
+
+ @PreAuthorize("hasAuthority('manager:matnr:update')")
+ @ApiOperation("鎵归噺淇敼")
+ @PostMapping("/matnr/batch/update")
+ public R batchUpdate(@RequestBody MatnrToGroupParams params) {
+ if (Objects.isNull(params)) {
+ return R.error("鍙傛暟涓嶈兘涓虹┖锛侊紒");
+ }
+ if (Objects.isNull(params.getMatnr())) {
+ return R.error("鐗╂枡灞炴�т笉鑳戒负绌猴紒锛�");
+ }
+ if (matnrService.batchUpdate(params)) {
+ return R.ok();
+ }else {
+ return R.error("鎿嶄綔澶辫触锛侊紒");
+ }
+ }
+
+ @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