From ec0e486ed828e2d6265cebaf5349a10eb656e389 Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期五, 23 一月 2026 15:36:38 +0800
Subject: [PATCH] 增加生产工单的附件上传功能
---
src/main/resources/mapper/production/ProductWorkOrderFileMapper.xml | 19 ++++
src/main/java/com/ruoyi/production/pojo/ProductWorkOrderFile.java | 65 ++++++++++++++++
src/main/java/com/ruoyi/production/service/ProductWorkOrderFileService.java | 16 ++++
src/main/java/com/ruoyi/production/controller/ProductWorkOrderFileController.java | 70 +++++++++++++++++
src/main/java/com/ruoyi/production/mapper/ProductWorkOrderFileMapper.java | 18 ++++
src/main/java/com/ruoyi/production/service/impl/ProductWorkOrderFileServiceImpl.java | 20 +++++
6 files changed, 208 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/ruoyi/production/controller/ProductWorkOrderFileController.java b/src/main/java/com/ruoyi/production/controller/ProductWorkOrderFileController.java
new file mode 100644
index 0000000..1f1b37e
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/controller/ProductWorkOrderFileController.java
@@ -0,0 +1,70 @@
+package com.ruoyi.production.controller;
+
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.production.pojo.ProductWorkOrderFile;
+import com.ruoyi.production.service.ProductWorkOrderFileService;
+import com.ruoyi.quality.pojo.QualityInspectFile;
+import com.ruoyi.quality.service.IQualityInspectFileService;
+import io.swagger.annotations.Api;
+import org.checkerframework.checker.units.qual.A;
+import org.springframework.util.CollectionUtils;
+import org.springframework.web.bind.annotation.*;
+
+import javax.annotation.Resource;
+import java.util.List;
+
+/**
+ * <p>
+ * 鐢熶骇宸ュ崟闄勪欢琛� 鍓嶇鎺у埗鍣�
+ * </p>
+ *
+ * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
+ * @since 2026-01-23 03:28:32
+ */
+@Api(tags = "鐢熶骇宸ュ崟闄勪欢琛�")
+@RestController
+@RequestMapping("/productWorkOrderFile")
+public class ProductWorkOrderFileController {
+
+ @Resource
+ private ProductWorkOrderFileService productWorkOrderFileService;
+
+
+ /**
+ * 鏂板
+ * @param productWorkOrderFile
+ * @return
+ */
+ @PostMapping("/add")
+ public AjaxResult add(@RequestBody ProductWorkOrderFile productWorkOrderFile) {
+ return AjaxResult.success(productWorkOrderFileService.save(productWorkOrderFile));
+ }
+
+ /**
+ * 鍒犻櫎
+ * @param ids
+ * @return
+ */
+ @DeleteMapping("/del")
+ public AjaxResult delQualityUnqualified(@RequestBody List<Integer> ids) {
+ if(CollectionUtils.isEmpty(ids)){
+ return AjaxResult.error("璇烽�夋嫨鑷冲皯涓�鏉℃暟鎹�");
+ }
+ //鍒犻櫎妫�楠岄檮浠�
+ return AjaxResult.success(productWorkOrderFileService.removeBatchByIds(ids));
+ }
+
+ /**
+ *鍒嗛〉鏌ヨ
+ * @param page
+ * @param productWorkOrderFile
+ * @return
+ */
+ @GetMapping("/listPage")
+ public AjaxResult listPage(Page page, ProductWorkOrderFile productWorkOrderFile) {
+ return AjaxResult.success(productWorkOrderFileService.page(page, Wrappers.<ProductWorkOrderFile>lambdaQuery().eq(ProductWorkOrderFile::getWorkOrderId,productWorkOrderFile.getWorkOrderId())));
+ }
+
+}
diff --git a/src/main/java/com/ruoyi/production/mapper/ProductWorkOrderFileMapper.java b/src/main/java/com/ruoyi/production/mapper/ProductWorkOrderFileMapper.java
new file mode 100644
index 0000000..72b8f94
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/mapper/ProductWorkOrderFileMapper.java
@@ -0,0 +1,18 @@
+package com.ruoyi.production.mapper;
+
+import com.ruoyi.production.pojo.ProductWorkOrderFile;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * <p>
+ * 鐢熶骇宸ュ崟闄勪欢琛� Mapper 鎺ュ彛
+ * </p>
+ *
+ * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
+ * @since 2026-01-23 03:28:32
+ */
+@Mapper
+public interface ProductWorkOrderFileMapper extends BaseMapper<ProductWorkOrderFile> {
+
+}
diff --git a/src/main/java/com/ruoyi/production/pojo/ProductWorkOrderFile.java b/src/main/java/com/ruoyi/production/pojo/ProductWorkOrderFile.java
new file mode 100644
index 0000000..028e1ab
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/pojo/ProductWorkOrderFile.java
@@ -0,0 +1,65 @@
+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 io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Getter;
+import lombok.Setter;
+
+/**
+ * <p>
+ * 鐢熶骇宸ュ崟闄勪欢琛�
+ * </p>
+ *
+ * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
+ * @since 2026-01-23 03:28:32
+ */
+@Getter
+@Setter
+@TableName("product_work_order_file")
+@ApiModel(value = "ProductWorkOrderFile瀵硅薄", description = "鐢熶骇宸ュ崟闄勪欢琛�")
+public class ProductWorkOrderFile implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ @TableId(value = "id", type = IdType.AUTO)
+ private Integer id;
+
+ @ApiModelProperty("鍏宠仈宸ュ崟id")
+ private Integer workOrderId;
+
+ @ApiModelProperty("鏂囦欢鍚嶇О")
+ private String name;
+
+ @ApiModelProperty("鏂囦欢璺緞")
+ private String url;
+
+ @ApiModelProperty("鏂囦欢澶у皬")
+ private Integer fileSize;
+
+ @ApiModelProperty("鍒涘缓鏃堕棿")
+ @TableField(fill = FieldFill.INSERT)
+ private LocalDateTime createTime;
+
+ @ApiModelProperty("鍒涘缓鐢ㄦ埛")
+ @TableField(fill = FieldFill.INSERT)
+ private Long createUser;
+
+ @ApiModelProperty("淇敼鏃堕棿")
+ @TableField(fill = FieldFill.INSERT_UPDATE)
+ private LocalDateTime updateTime;
+
+ @ApiModelProperty("淇敼鐢ㄦ埛")
+ @TableField(fill = FieldFill.INSERT_UPDATE)
+ private Long updateUser;
+
+ @ApiModelProperty("绉熸埛ID")
+ @TableField(fill = FieldFill.INSERT)
+ private Long tenantId;
+}
diff --git a/src/main/java/com/ruoyi/production/service/ProductWorkOrderFileService.java b/src/main/java/com/ruoyi/production/service/ProductWorkOrderFileService.java
new file mode 100644
index 0000000..0df0a8c
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/service/ProductWorkOrderFileService.java
@@ -0,0 +1,16 @@
+package com.ruoyi.production.service;
+
+import com.ruoyi.production.pojo.ProductWorkOrderFile;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+/**
+ * <p>
+ * 鐢熶骇宸ュ崟闄勪欢琛� 鏈嶅姟绫�
+ * </p>
+ *
+ * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
+ * @since 2026-01-23 03:28:32
+ */
+public interface ProductWorkOrderFileService extends IService<ProductWorkOrderFile> {
+
+}
diff --git a/src/main/java/com/ruoyi/production/service/impl/ProductWorkOrderFileServiceImpl.java b/src/main/java/com/ruoyi/production/service/impl/ProductWorkOrderFileServiceImpl.java
new file mode 100644
index 0000000..b0391ea
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductWorkOrderFileServiceImpl.java
@@ -0,0 +1,20 @@
+package com.ruoyi.production.service.impl;
+
+import com.ruoyi.production.pojo.ProductWorkOrderFile;
+import com.ruoyi.production.mapper.ProductWorkOrderFileMapper;
+import com.ruoyi.production.service.ProductWorkOrderFileService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.stereotype.Service;
+
+/**
+ * <p>
+ * 鐢熶骇宸ュ崟闄勪欢琛� 鏈嶅姟瀹炵幇绫�
+ * </p>
+ *
+ * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
+ * @since 2026-01-23 03:28:32
+ */
+@Service
+public class ProductWorkOrderFileServiceImpl extends ServiceImpl<ProductWorkOrderFileMapper, ProductWorkOrderFile> implements ProductWorkOrderFileService {
+
+}
diff --git a/src/main/resources/mapper/production/ProductWorkOrderFileMapper.xml b/src/main/resources/mapper/production/ProductWorkOrderFileMapper.xml
new file mode 100644
index 0000000..ae5686b
--- /dev/null
+++ b/src/main/resources/mapper/production/ProductWorkOrderFileMapper.xml
@@ -0,0 +1,19 @@
+<?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.ProductWorkOrderFileMapper">
+
+ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.production.pojo.ProductWorkOrderFile">
+ <id column="id" property="id" />
+ <result column="work_order_id" property="workOrderId" />
+ <result column="name" property="name" />
+ <result column="url" property="url" />
+ <result column="file_size" property="fileSize" />
+ <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>
+
+</mapper>
--
Gitblit v1.9.3