From 6873d560b235e04a2e95c8240f00dc8e8b6e1ac6 Mon Sep 17 00:00:00 2001
From: TWW <15834156+tangweiwei111@user.noreply.gitee.com>
Date: 星期五, 08 八月 2025 13:17:04 +0800
Subject: [PATCH] 添加附件上传后端代码

---
 src/main/java/com/ruoyi/personnelManagement/controller/EmployeeContractController.java    |   78 +++++++++++++++
 src/main/java/com/ruoyi/personnelManagement/service/impl/EmployeeContractServiceImpl.java |   39 +++++++
 src/main/java/com/ruoyi/personnelManagement/service/IEmployeeContractService.java         |   24 ++++
 src/main/java/com/ruoyi/personnelManagement/mapper/EmployeeContractMapper.java            |   24 ++++
 src/main/java/com/ruoyi/personnelManagement/pojo/EmployeeContract.java                    |   68 +++++++++++++
 src/main/resources/mapper/personnelManagement/EmployeeContractMapper.xml                  |   16 +++
 6 files changed, 249 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/ruoyi/personnelManagement/controller/EmployeeContractController.java b/src/main/java/com/ruoyi/personnelManagement/controller/EmployeeContractController.java
new file mode 100644
index 0000000..eb06c21
--- /dev/null
+++ b/src/main/java/com/ruoyi/personnelManagement/controller/EmployeeContractController.java
@@ -0,0 +1,78 @@
+package com.ruoyi.personnelManagement.controller;
+
+import java.io.IOException;
+import java.util.List;
+import javax.servlet.http.HttpServletResponse;
+
+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.controller.BaseController;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.framework.web.page.TableDataInfo;
+import com.ruoyi.other.service.TempFileService;
+import com.ruoyi.quality.pojo.QualityInspectFile;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import io.swagger.annotations.ApiParam;
+import org.jetbrains.annotations.Contract;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.util.CollectionUtils;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.PutMapping;
+import org.springframework.web.bind.annotation.DeleteMapping;
+import org.springframework.web.bind.annotation.PathVariable;
+import org.springframework.web.bind.annotation.RequestBody;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+import com.ruoyi.personnelManagement.pojo.EmployeeContract;
+import com.ruoyi.personnelManagement.service.IEmployeeContractService;
+import org.springframework.web.multipart.MultipartFile;
+
+/**
+ * 鍛樺伐鍚堝悓淇℃伅Controller
+ * 
+ * @author ruoyi
+ * @date 2025-08-08
+ */
+@RestController
+@RequestMapping("/contractManagement/contract")
+@Api(tags = "鍛樺伐鍚堝悓淇℃伅鐨勬帴鍙�")
+public class EmployeeContractController extends BaseController
+{
+    @Autowired
+    private IEmployeeContractService employeeContractService;
+    @Autowired
+    private TempFileService tempFileService;
+
+    /**
+     * 鏌ヨ鍛樺伐鍚堝悓淇℃伅鍒楄〃
+     */
+    @GetMapping("/list")
+    public AjaxResult contractListPage(Page page, EmployeeContract employeeContract) {
+        return AjaxResult.success(employeeContractService.contractList(page, employeeContract));
+    }
+
+    /**
+     * 涓婁紶鍛樺伐鍚堝悓
+     */
+
+    @PostMapping("/upload")
+    public AjaxResult uploadFile(@RequestBody EmployeeContract employeeContract) {
+    return AjaxResult.success(employeeContractService.save(employeeContract));
+    }
+
+    @DeleteMapping("/delete")
+    public AjaxResult deleteContract(@RequestBody List<Integer> ids) {
+        if(CollectionUtils.isEmpty(ids)){
+            return AjaxResult.error("璇烽�夋嫨鑷冲皯涓�鏉℃暟鎹�");
+        }
+        //鍒犻櫎闄勪欢
+        return AjaxResult.success(employeeContractService.removeBatchByIds(ids));
+    }
+
+}
diff --git a/src/main/java/com/ruoyi/personnelManagement/mapper/EmployeeContractMapper.java b/src/main/java/com/ruoyi/personnelManagement/mapper/EmployeeContractMapper.java
new file mode 100644
index 0000000..eef7e94
--- /dev/null
+++ b/src/main/java/com/ruoyi/personnelManagement/mapper/EmployeeContractMapper.java
@@ -0,0 +1,24 @@
+package com.ruoyi.personnelManagement.mapper;
+
+import java.util.List;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.personnelManagement.pojo.EmployeeContract;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+/**
+ * 鍛樺伐鍚堝悓淇℃伅Mapper鎺ュ彛
+ * 
+ * @author ruoyi
+ * @date 2025-08-08
+ */
+@Mapper
+public interface EmployeeContractMapper extends BaseMapper<EmployeeContract>
+{
+
+
+    IPage<EmployeeContract> contractList(Page page,@Param("employeeContract") EmployeeContract employeeContract);
+}
diff --git a/src/main/java/com/ruoyi/personnelManagement/pojo/EmployeeContract.java b/src/main/java/com/ruoyi/personnelManagement/pojo/EmployeeContract.java
new file mode 100644
index 0000000..7165851
--- /dev/null
+++ b/src/main/java/com/ruoyi/personnelManagement/pojo/EmployeeContract.java
@@ -0,0 +1,68 @@
+package com.ruoyi.personnelManagement.pojo;
+
+import java.io.Serializable;
+import java.time.LocalDateTime;
+
+import com.baomidou.mybatisplus.annotation.*;
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
+import com.ruoyi.framework.web.domain.BaseEntity;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import javax.validation.constraints.NotBlank;
+
+
+/**
+ * 鍛樺伐鍚堝悓淇℃伅瀵硅薄 employee_contract
+ * 
+ * @author ruoyi
+ * @date 2025-08-08
+ */
+@TableName("employee_contract")
+@Data
+public class EmployeeContract implements Serializable
+{
+    private static final long serialVersionUID = 1L;
+
+    @TableId(type = IdType.AUTO)
+    private Long id;
+
+    /** 鍚堝悓鐘舵�侊細0-鏃犳晥锛�1-鏈夋晥锛�2-鍗冲皢鍒版湡锛�3-宸茶繃鏈� */
+    @Excel(name = "鍚堝悓鐘舵�侊細0-鏃犳晥锛�1-鏈夋晥锛�2-鍗冲皢鍒版湡锛�3-宸茶繃鏈�")
+    private Integer status;
+
+    @ApiModelProperty(value = "鏂囦欢鍚嶇О")
+    private String name;
+
+    @ApiModelProperty(value = "鏂囦欢璺緞")
+    private String url;
+
+    @ApiModelProperty(value = "鏂囦欢澶у皬")
+    private int fileSize;
+
+    @ApiModelProperty(value = "鍚堝悓ID")
+    @NotBlank(message = "鍚堝悓id涓嶈兘涓虹┖!")
+    private Long contractId;
+
+    @ApiModelProperty(value = "鍒涘缓鏃堕棿")
+    @TableField(fill = FieldFill.INSERT)
+    private LocalDateTime createTime;
+
+    @ApiModelProperty(value = "淇敼鏃堕棿")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private LocalDateTime updateTime;
+
+    @ApiModelProperty(value = "鍒涘缓鐢ㄦ埛")
+    @TableField(fill = FieldFill.INSERT)
+    private Integer createUser;
+
+    @ApiModelProperty(value = "淇敼鐢ㄦ埛")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private Integer updateUser;
+
+    @ApiModelProperty(value = "绉熸埛ID")
+    @TableField(fill = FieldFill.INSERT)
+    private Long tenantId;
+
+
+}
diff --git a/src/main/java/com/ruoyi/personnelManagement/service/IEmployeeContractService.java b/src/main/java/com/ruoyi/personnelManagement/service/IEmployeeContractService.java
new file mode 100644
index 0000000..af6bba4
--- /dev/null
+++ b/src/main/java/com/ruoyi/personnelManagement/service/IEmployeeContractService.java
@@ -0,0 +1,24 @@
+package com.ruoyi.personnelManagement.service;
+
+import java.util.List;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.personnelManagement.pojo.EmployeeContract;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+/**
+ * 鍛樺伐鍚堝悓淇℃伅Service鎺ュ彛
+ * 
+ * @author ruoyi
+ * @date 2025-08-08
+ */
+public interface IEmployeeContractService extends IService<EmployeeContract>
+{
+
+
+    IPage<EmployeeContract> contractList(Page page, EmployeeContract employeeContract);
+
+
+    int insertContract(EmployeeContract employeeContract);
+}
diff --git a/src/main/java/com/ruoyi/personnelManagement/service/impl/EmployeeContractServiceImpl.java b/src/main/java/com/ruoyi/personnelManagement/service/impl/EmployeeContractServiceImpl.java
new file mode 100644
index 0000000..cc26766
--- /dev/null
+++ b/src/main/java/com/ruoyi/personnelManagement/service/impl/EmployeeContractServiceImpl.java
@@ -0,0 +1,39 @@
+package com.ruoyi.personnelManagement.service.impl;
+
+import java.util.List;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import com.ruoyi.personnelManagement.mapper.EmployeeContractMapper;
+import com.ruoyi.personnelManagement.pojo.EmployeeContract;
+import com.ruoyi.personnelManagement.service.IEmployeeContractService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import java.util.Arrays;
+/**
+ * 鍛樺伐鍚堝悓淇℃伅Service涓氬姟灞傚鐞�
+ * 
+ * @author ruoyi
+ * @date 2025-08-08
+ */
+@Service
+public class EmployeeContractServiceImpl extends ServiceImpl<EmployeeContractMapper,EmployeeContract> implements IEmployeeContractService
+{
+    @Autowired
+    private EmployeeContractMapper employeeContractMapper;
+
+
+    @Override
+    public IPage<EmployeeContract> contractList(Page page, EmployeeContract employeeContract) {
+        return employeeContractMapper.contractList(page, employeeContract);
+    }
+
+
+
+    @Override
+    public int insertContract(EmployeeContract employeeContract) {
+        return 0;
+    }
+
+}
diff --git a/src/main/resources/mapper/personnelManagement/EmployeeContractMapper.xml b/src/main/resources/mapper/personnelManagement/EmployeeContractMapper.xml
new file mode 100644
index 0000000..1e7dd8c
--- /dev/null
+++ b/src/main/resources/mapper/personnelManagement/EmployeeContractMapper.xml
@@ -0,0 +1,16 @@
+<?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.personnelManagement.mapper.EmployeeContractMapper">
+
+    <select id="contractList" resultType="com.ruoyi.personnelManagement.pojo.EmployeeContract">
+
+        select *
+        from employee_contract
+        where contract_id =  #{employeeContract.contractId}
+
+    </select>
+
+
+</mapper>
\ No newline at end of file

--
Gitblit v1.9.3