#优化 1. 数据库关键字暂用修改

skyouc

2025-02-24 1acd2078398b7cd3141cea307f375165d39179e3

 rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/MatnrController.java

@@ -4,6 +4,8 @@
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;
@@ -12,14 +14,18 @@
import com.vincent.rsf.server.manager.entity.Matnr;
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 javax.servlet.http.HttpServletResponse;
import java.util.*;

@RestController
@Api(tags = "物料表接口")
public class MatnrController extends BaseController {

    @Autowired
@@ -52,7 +58,7 @@
    }

    @PreAuthorize("hasAuthority('manager:matnr:save')")
    @OperationLog("Create 物料表")
    @OperationLog("Create 物料信息表")
    @PostMapping("/matnr/save")
    public R save(@RequestBody Matnr matnr) {
        matnr.setCreateBy(getLoginUserId());
@@ -66,7 +72,7 @@
    }

    @PreAuthorize("hasAuthority('manager:matnr:update')")
    @OperationLog("Update 物料表")
    @OperationLog("Update 物料信息表")
    @PostMapping("/matnr/update")
    public R update(@RequestBody Matnr matnr) {
        matnr.setUpdateBy(getLoginUserId());
@@ -78,7 +84,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))) {
@@ -101,6 +107,27 @@
        return R.ok().add(vos);
    }

    @SecurityRequirement(name = HttpHeaders.AUTHORIZATION)
    @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')")
    @PostMapping("/matnr/export")
    public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {