| src/main/java/com/ruoyi/staff/controller/StaffOnJobController.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/main/resources/mapper/staff/StaffOnJobMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/java/com/ruoyi/staff/controller/StaffOnJobController.java
@@ -6,19 +6,18 @@ import com.ruoyi.framework.aspectj.lang.enums.BusinessType; import com.ruoyi.framework.web.domain.AjaxResult; import com.ruoyi.staff.dto.StaffOnJobDto; import com.ruoyi.staff.dto.StaffOnJobExcelDto; import com.ruoyi.staff.pojo.StaffContract; import com.ruoyi.staff.pojo.StaffOnJob; import com.ruoyi.staff.service.IStaffOnJobService; import io.swagger.v3.oas.annotations.tags.Tag; import io.swagger.v3.oas.annotations.Operation; import io.swagger.v3.oas.annotations.tags.Tag; import jakarta.annotation.Resource; import jakarta.servlet.http.HttpServletResponse; import org.springframework.util.CollectionUtils; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import com.ruoyi.staff.dto.StaffOnJobExcelDto; import jakarta.annotation.Resource; import jakarta.servlet.http.HttpServletResponse; import jakarta.validation.Valid; import java.util.List; /** @@ -103,7 +102,7 @@ * @return */ @PostMapping("/renewContract/{id}") public AjaxResult renewContract(@PathVariable("id") Long id, @RequestBody StaffContract staffContract) { public AjaxResult renewContract(@PathVariable Long id, @RequestBody StaffContract staffContract) { return AjaxResult.success(staffOnJobService.renewContract(id, staffContract)); } src/main/resources/mapper/staff/StaffOnJobMapper.xml
@@ -6,14 +6,13 @@ staff_on_job.*, sp.post_name as postName, sd.dept_name as deptName, t1.contract_start_time MIN(t1.contract_start_time) as contract_start_time, -- 取最早合同开始时间 MAX(t1.contract_end_time) as contract_end_time FROM staff_on_job LEFT JOIN sys_post sp ON sp.post_id = staff_on_job.sys_post_id LEFT JOIN sys_dept sd ON sd.dept_id = staff_on_job.sys_dept_id LEFT JOIN sys_post sp ON sp.post_id = staff_on_job.sys_post_id LEFT JOIN sys_dept sd ON sd.dept_id = staff_on_job.sys_dept_id LEFT JOIN staff_contract as t1 ON t1.staff_on_job_id = staff_on_job.id where 1=1 WHERE 1=1 <if test="staffOnJob.staffState != null"> AND staff_state = #{staffOnJob.staffState} </if> @@ -26,6 +25,7 @@ <if test="staffOnJob.entryDateEnd != null and staffOnJob.entryDateEnd != '' "> AND contract_expire_time <= DATE_FORMAT(#{staffOnJob.entryDateEnd},'%Y-%m-%d') </if> GROUP BY staff_on_job.id </select> <select id="staffOnJobList" resultType="com.ruoyi.staff.dto.StaffOnJobDto"> SELECT