From 11bd127f2e80f8c2eb8d1b4e618e59dcf9d95834 Mon Sep 17 00:00:00 2001
From: yuan <123@>
Date: 星期六, 14 三月 2026 14:28:15 +0800
Subject: [PATCH] feat: 新增产品参数配置模块及CRUD接口
---
src/main/resources/mapper/production/ProductParameterMapper.xml | 39 +++++++
src/main/java/com/ruoyi/production/pojo/ProductParameter.java | 82 ++++++++++++++++
src/main/java/com/ruoyi/production/service/impl/ProductParameterServiceImpl.java | 42 ++++++++
src/main/java/com/ruoyi/production/controller/ProductParameterController.java | 74 ++++++++++++++
src/main/java/com/ruoyi/production/service/ProductParameterService.java | 25 +++++
src/main/java/com/ruoyi/production/mapper/ProductParameterMapper.java | 23 ++++
src/main/java/com/ruoyi/production/dto/ProductParameterDto.java | 13 ++
7 files changed, 298 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/ruoyi/production/controller/ProductParameterController.java b/src/main/java/com/ruoyi/production/controller/ProductParameterController.java
new file mode 100644
index 0000000..1fbf219
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/controller/ProductParameterController.java
@@ -0,0 +1,74 @@
+package com.ruoyi.production.controller;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.framework.aspectj.lang.annotation.Log;
+import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.framework.web.domain.R;
+import com.ruoyi.production.dto.ProductBomDto;
+import com.ruoyi.production.dto.ProductParameterDto;
+import com.ruoyi.production.pojo.*;
+import com.ruoyi.production.service.ProductParameterService;
+import io.swagger.annotations.ApiModelProperty;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.util.CollectionUtils;
+import org.springframework.web.bind.annotation.*;
+
+import javax.servlet.http.HttpServletResponse;
+import java.util.List;
+import java.util.ListResourceBundle;
+
+/**
+ * <p>
+ * 鍙傛暟閰嶇疆琛� 鍓嶇鎺у埗鍣�
+ * </p>
+ *
+ * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
+ * @since 2026-03-14 01:38:54
+ */
+@RestController
+@RequestMapping("/productParameter")
+public class ProductParameterController {
+
+ @Autowired
+ private ProductParameterService productParameterService;
+
+
+ @ApiOperation("鐢熶骇璁板綍 鍒嗛〉鏌ヨ")
+ @GetMapping("listPage")
+ @Log(title = "鐢熶骇璁板綍 鍒嗛〉鏌ヨ", businessType = BusinessType.OTHER)
+ public AjaxResult page(ProductParameterDto productParameter, Page<ProductParameterDto> page) {
+ return AjaxResult.success(productParameterService.pageProductParameter(page, productParameter));
+ }
+
+ @ApiOperation("鐢熶骇璁板綍 鏂板")
+ @PostMapping("/addProductParameter")
+ @Log(title = "鐢熶骇璁板綍 鏂板", businessType = BusinessType.INSERT)
+ public AjaxResult addProductParameter(@RequestBody ProductParameterDto productParameter) {
+ productParameterService.addProductParameter(productParameter);
+ return AjaxResult.success();
+ }
+
+
+ @ApiOperation("鐢熶骇璁板綍 淇敼")
+ @PutMapping("updProductParameter")
+ @Log(title = "鐢熶骇璁板綍 淇敼", businessType = BusinessType.UPDATE)
+ public AjaxResult updProductParameter(@RequestBody ProductParameterDto productParameter) {
+ productParameterService.updProductParameter(productParameter);
+ return AjaxResult.success();
+ }
+
+ @ApiOperation("鐢熶骇璁板綍 鍒犻櫎")
+ @DeleteMapping("/{ids}")
+ @Log(title = "鐢熶骇璁板綍 鍒犻櫎", businessType = BusinessType.DELETE)
+ public AjaxResult delete(@PathVariable("ids") List<Long> ids) {
+ productParameterService.removeBatchByIds(ids);
+ return AjaxResult.success();
+ }
+
+
+}
diff --git a/src/main/java/com/ruoyi/production/dto/ProductParameterDto.java b/src/main/java/com/ruoyi/production/dto/ProductParameterDto.java
new file mode 100644
index 0000000..bd749aa
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/dto/ProductParameterDto.java
@@ -0,0 +1,13 @@
+package com.ruoyi.production.dto;
+
+import com.ruoyi.production.pojo.ProductParameter;
+import lombok.Data;
+
+/**
+ * @author yuan
+ * @date 2026-03-14 13:42
+ * @description
+ */
+@Data
+public class ProductParameterDto extends ProductParameter {
+}
diff --git a/src/main/java/com/ruoyi/production/mapper/ProductParameterMapper.java b/src/main/java/com/ruoyi/production/mapper/ProductParameterMapper.java
new file mode 100644
index 0000000..bcee517
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/mapper/ProductParameterMapper.java
@@ -0,0 +1,23 @@
+package com.ruoyi.production.mapper;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.production.dto.ProductParameterDto;
+import com.ruoyi.production.pojo.ProductParameter;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+/**
+ * <p>
+ * 鍙傛暟閰嶇疆琛� Mapper 鎺ュ彛
+ * </p>
+ *
+ * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
+ * @since 2026-03-14 01:38:54
+ */
+@Mapper
+public interface ProductParameterMapper extends BaseMapper<ProductParameter> {
+
+ IPage<ProductParameterDto> pageProductParameter(@Param("page") Page<ProductParameterDto> page, @Param("productParameter") ProductParameterDto productParameter);
+}
diff --git a/src/main/java/com/ruoyi/production/pojo/ProductParameter.java b/src/main/java/com/ruoyi/production/pojo/ProductParameter.java
new file mode 100644
index 0000000..03ec610
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/pojo/ProductParameter.java
@@ -0,0 +1,82 @@
+package com.ruoyi.production.pojo;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import java.io.Serializable;
+import java.time.LocalDateTime;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.Getter;
+import lombok.Setter;
+import org.springframework.format.annotation.DateTimeFormat;
+
+/**
+ * <p>
+ * 鍙傛暟閰嶇疆琛�
+ * </p>
+ *
+ * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
+ * @since 2026-03-14 01:38:54
+ */
+@Data
+@TableName("product_parameter")
+@ApiModel(value = "ProductParameter瀵硅薄", description = "鍙傛暟閰嶇疆琛�")
+public class ProductParameter implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ @ApiModelProperty("涓婚敭ID")
+ @TableId(value = "id", type = IdType.AUTO)
+ private Long id;
+
+ @ApiModelProperty("鍙傛暟缂栫爜")
+ private String code;
+
+ @ApiModelProperty("鍙傛暟椤�")
+ private String parameterItem;
+
+ @ApiModelProperty("鍙傛暟绫诲瀷锛�0锛氭暟瀛楁牸寮忥紝1锛氭枃鏈牸寮忥級")
+ private String type;
+
+ @ApiModelProperty("鍗曚綅")
+ private String unit;
+
+ @ApiModelProperty("鍙傛暟鏍煎紡")
+ private String parameterFormat;
+
+ @ApiModelProperty("瀛楀吀鍊�")
+ private String dict;
+
+ @ApiModelProperty("鏄惁蹇呭～锛�0锛氬惁锛�1锛氭槸锛�")
+ private String isRequired;
+
+ @ApiModelProperty("鍒涘缓鏃堕棿")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @TableField(fill = FieldFill.INSERT)
+ private LocalDateTime createTime;
+
+ @ApiModelProperty("鍒涘缓浜�")
+ @TableField(fill = FieldFill.INSERT)
+ private String createUser;
+
+ @ApiModelProperty("鏇存柊鏃堕棿")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @TableField(fill = FieldFill.INSERT_UPDATE)
+ private LocalDateTime updateTime;
+
+ @ApiModelProperty("鏇存柊浜�")
+ @TableField(fill = FieldFill.INSERT_UPDATE)
+ private String updateUser;
+
+ @ApiModelProperty("绉熸埛ID")
+ @TableField(fill = FieldFill.INSERT)
+ private String tenantId;
+}
diff --git a/src/main/java/com/ruoyi/production/service/ProductParameterService.java b/src/main/java/com/ruoyi/production/service/ProductParameterService.java
new file mode 100644
index 0000000..f8e1c49
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/service/ProductParameterService.java
@@ -0,0 +1,25 @@
+package com.ruoyi.production.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.production.dto.ProductParameterDto;
+import com.ruoyi.production.pojo.ProductParameter;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+/**
+ * <p>
+ * 鍙傛暟閰嶇疆琛� 鏈嶅姟绫�
+ * </p>
+ *
+ * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
+ * @since 2026-03-14 01:38:54
+ */
+public interface ProductParameterService extends IService<ProductParameter> {
+
+ IPage<ProductParameterDto> pageProductParameter(Page<ProductParameterDto> page, ProductParameterDto productParameter);
+
+ void addProductParameter(ProductParameterDto productParameter);
+
+ void updProductParameter(ProductParameterDto productParameter);
+}
diff --git a/src/main/java/com/ruoyi/production/service/impl/ProductParameterServiceImpl.java b/src/main/java/com/ruoyi/production/service/impl/ProductParameterServiceImpl.java
new file mode 100644
index 0000000..db81263
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductParameterServiceImpl.java
@@ -0,0 +1,42 @@
+package com.ruoyi.production.service.impl;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.production.dto.ProductParameterDto;
+import com.ruoyi.production.pojo.ProductParameter;
+import com.ruoyi.production.mapper.ProductParameterMapper;
+import com.ruoyi.production.service.ProductParameterService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.stereotype.Service;
+
+/**
+ * <p>
+ * 鍙傛暟閰嶇疆琛� 鏈嶅姟瀹炵幇绫�
+ * </p>
+ *
+ * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
+ * @since 2026-03-14 01:38:54
+ */
+@Service
+public class ProductParameterServiceImpl extends ServiceImpl<ProductParameterMapper, ProductParameter> implements ProductParameterService {
+
+ @Override
+ public IPage<ProductParameterDto> pageProductParameter(Page<ProductParameterDto> page, ProductParameterDto productParameter) {
+ return baseMapper.pageProductParameter(page, productParameter);
+ }
+
+ @Override
+ public void addProductParameter(ProductParameterDto productParameter) {
+ boolean save = this.save(productParameter);
+ if (save) {
+ String no = "BP." + String.format("%06d", productParameter.getId());
+ productParameter.setCode(no);
+ this.updateById(productParameter);
+ }
+ }
+
+ @Override
+ public void updProductParameter(ProductParameterDto productParameter) {
+ this.updateById(productParameter);
+ }
+}
diff --git a/src/main/resources/mapper/production/ProductParameterMapper.xml b/src/main/resources/mapper/production/ProductParameterMapper.xml
new file mode 100644
index 0000000..ac0b1c6
--- /dev/null
+++ b/src/main/resources/mapper/production/ProductParameterMapper.xml
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ruoyi.production.mapper.ProductParameterMapper">
+
+ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.production.pojo.ProductParameter">
+ <id column="id" property="id" />
+ <result column="code" property="code" />
+ <result column="parameter_item" property="parameterItem" />
+ <result column="type" property="type" />
+ <result column="unit" property="unit" />
+ <result column="parameter_format" property="parameterFormat" />
+ <result column="dict" property="dict" />
+ <result column="is_required" property="isRequired" />
+ <result column="create_time" property="createTime" />
+ <result column="create_user" property="createUser" />
+ <result column="update_time" property="updateTime" />
+ <result column="update_user" property="updateUser" />
+ <result column="tenant_id" property="tenantId" />
+ </resultMap>
+ <select id="pageProductParameter" resultType="com.ruoyi.production.dto.ProductParameterDto">
+ select pp.*
+ from
+ product_parameter pp
+ <where>
+ <if test="productParameter.code != null and productParameter.code != ''">
+ and pp.code like concat('%',#{productParameter.code},'%')
+ </if>
+ <if test="productParameter.parameterItem != null and productParameter.parameterItem != ''">
+ and pp.parameter_item like concat('%',#{productParameter.parameterItem},'%')
+ </if>
+ <if test="productParameter.type != null and productParameter.type != ''">
+ and pp.type like concat('%',#{productParameter.type},'%')
+ </if>
+ </where>
+ order by pp.id
+ </select>
+
+</mapper>
--
Gitblit v1.9.3