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