From 32ba5ac318edf01cccc7b4d8827c4c1dc9c90f30 Mon Sep 17 00:00:00 2001 From: zhuo <2089219845@qq.com> Date: 星期二, 04 三月 2025 10:08:43 +0800 Subject: [PATCH] Merge branch 'dev' into dev_dz --- cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceMaintenanceImpl.java | 7 ++ cnas-device/src/main/java/com/ruoyi/device/mapper/InstructionMapper.java | 4 + cnas-device/src/main/java/com/ruoyi/device/service/DeviceInspectionRecordService.java | 3 cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceInspectionRecordServiceImpl.java | 7 + cnas-device/src/main/java/com/ruoyi/device/controller/DeviceStateController.java | 4 cnas-personnel/src/main/resources/mapper/PersonPersonnelCapacityMapper.xml | 6 +- cnas-device/src/main/resources/mapper/DeviceInspectionRecordMapper.xml | 5 - cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceInstructionServiceImpl.java | 3 cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonRewardPunishmentRecordMapper.java | 5 + inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderPlanServiceImpl.java | 6 +- cnas-device/src/main/java/com/ruoyi/device/service/DeviceInstructionService.java | 4 + cnas-device/src/main/java/com/ruoyi/device/controller/DeviceMaintenanceController.java | 2 cnas-device/src/main/resources/mapper/InstructionMapper.xml | 21 ++++--- cnas-device/src/main/java/com/ruoyi/device/mapper/DeviceInspectionRecordMapper.java | 3 cnas-device/src/main/java/com/ruoyi/device/controller/DeviceInspectionRecordController.java | 2 cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonPersonnelCapacityMapper.java | 2 cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonCommunicationAbilityController.java | 2 cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonJobResponsibilitiesController.java | 2 cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonPostAuthorizationRecordMapper.java | 3 cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonPostAuthorizationRecordController.java | 2 cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonTrainingRecordMapper.java | 4 cnas-process/src/main/java/com/ruoyi/process/controller/ProcessMethodVerifyController.java | 2 cnas-device/src/main/java/com/ruoyi/device/controller/DeviceInstructionController.java | 16 +++-- inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsReportServiceImpl.java | 8 +- cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonJobResponsibilitiesMapper.java | 3 25 files changed, 74 insertions(+), 52 deletions(-) diff --git a/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceInspectionRecordController.java b/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceInspectionRecordController.java index 9db6182..f4b3b1e 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceInspectionRecordController.java +++ b/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceInspectionRecordController.java @@ -35,7 +35,7 @@ */ @ApiOperation("鍒嗛〉鏌ヨ璁惧鐐规璁板綍") @GetMapping("/getDeviceInspectionRecordByPage") - public Result<IPage<DeviceInspectionRecord>> getDeviceInspectionRecordByPage(IPage page, DeviceInspectionRecordDto itemParameter) { + public Result<IPage<DeviceInspectionRecord>> getDeviceInspectionRecordByPage(Page page, DeviceInspectionRecordDto itemParameter) { return deviceInspectionRecordService.getDeviceInspectionRecordByPage(page, itemParameter); } diff --git a/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceInstructionController.java b/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceInstructionController.java index a4af938..f9d4d7f 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceInstructionController.java +++ b/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceInstructionController.java @@ -41,9 +41,9 @@ private DeviceOperationInstructionService deviceOperationInstructionService; - @ApiOperation(value = "浣滀笟鎸囧涔� 鍒嗛〉") + @ApiOperation(value = "浣滀笟鎸囧涔﹀垎椤�") @GetMapping("/pageByPageQueryOfHomeworkInstructions") - public Result<IPage<DeviceInstruction>> pageByPageQueryOfHomeworkInstructions(Page page, DeviceOperationInstructionDto operationInstructionDto){ + public Result<IPage<DeviceOperationInstructionDto>> pageByPageQueryOfHomeworkInstructions(Page page, DeviceOperationInstructionDto operationInstructionDto){ return Result.success(deviceInstructionService.pageByPageQueryOfHomeworkInstructions(page, operationInstructionDto)); } @@ -54,7 +54,7 @@ return Result.success(); } - @ApiOperation(value = "浣滀笟鎸囧涔︾紪杈�") + @ApiOperation(value = "浣滀笟鎸囧涔﹁鎯�") @GetMapping("/homeworkGuidebookEditor") public Result<Map<String, Object>> homeworkGuidebookEditor(Integer instructionId){ DeviceInstruction instruction = deviceInstructionService.getById(instructionId); @@ -66,7 +66,7 @@ } @ApiOperation(value = "浣滀笟鎸囧涔﹀彈鎺ф枃浠跺垹闄�") - @GetMapping("/deleteHomeworkGuidebook") + @DeleteMapping("/deleteHomeworkGuidebook") public Result deleteHomeworkGuidebook(String ids){ if (ObjectUtils.isNotEmpty(ids)) { String[] idArray = ids.split(","); @@ -76,7 +76,7 @@ } @ApiOperation(value = "浣滀笟鎸囧涔﹀垹闄�") - @GetMapping("/homeworkGuidebook") + @DeleteMapping("/homeworkGuidebook") public Result homeworkGuidebook(String id, String instructionId){ // 鍒犻櫎瀛愯〃鏁版嵁 deviceOperationInstructionService.removeById(id); @@ -91,8 +91,10 @@ } @ApiOperation(value = "浣滀笟鎸囧涔﹀鎵�") - @GetMapping("/approvalOfHomeworkInstructionManual") - public Result approvalOfHomeworkInstructionManual(String id, Boolean status){ + @PostMapping("/approvalOfHomeworkInstructionManual") + public Result approvalOfHomeworkInstructionManual(@RequestBody Map<String,Object> map){ + Integer id =(Integer) map.get("id"); + Boolean status =(Boolean) map.get("status"); deviceOperationInstructionService.update(Wrappers.<OperationInstruction>lambdaUpdate() .eq(OperationInstruction::getId, id) .set(OperationInstruction::getStatus, status) diff --git a/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceMaintenanceController.java b/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceMaintenanceController.java index a7bf0df..44cf11a 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceMaintenanceController.java +++ b/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceMaintenanceController.java @@ -71,7 +71,7 @@ */ @ApiOperation(value = "鏂板璁惧缁存姢淇濆吇") @DeleteMapping("/deleteDeviceMaintenance") - public void deleteDeviceMaintenance(@PathVariable Integer id) { + public void deleteDeviceMaintenance( Integer id) { deviceMaintenanceService.removeById(id); } diff --git a/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceStateController.java b/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceStateController.java index 4c73996..1d2ff28 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceStateController.java +++ b/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceStateController.java @@ -63,9 +63,9 @@ return Result.success(deviceStateService.removeById(stateId)); } - @PostMapping("/deviceStateExport") + @GetMapping("/deviceStateExport") public Result deviceStateExport(@RequestParam("deviceId") Integer deviceId, String processNumber, HttpServletResponse response) throws Exception { - IPage<DeviceStateDto> deviceBorrows = deviceStateService.getDeviceStatePage(deviceId, new Page<>(1, -1), processNumber); + IPage<DeviceStateDto> deviceBorrows = deviceStateService.getDeviceStatePage(deviceId, new Page<>(-1, -1), processNumber); List<DeviceStateExport> studentList = JSONObject.parseArray(JSON.toJSONString(deviceBorrows.getRecords()), DeviceStateExport.class); response.setHeader("requestType", "excel"); response.setHeader("Access-Control-Expose-Headers", "requestType"); diff --git a/cnas-device/src/main/java/com/ruoyi/device/mapper/DeviceInspectionRecordMapper.java b/cnas-device/src/main/java/com/ruoyi/device/mapper/DeviceInspectionRecordMapper.java index 5cb34ee..9a05395 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/mapper/DeviceInspectionRecordMapper.java +++ b/cnas-device/src/main/java/com/ruoyi/device/mapper/DeviceInspectionRecordMapper.java @@ -3,6 +3,7 @@ import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ruoyi.device.dto.DeviceInspectionRecordDto; import com.ruoyi.device.pojo.DeviceInspectionRecord; import org.apache.ibatis.annotations.Param; @@ -23,6 +24,6 @@ * @param queryWrappers * @return */ - IPage<DeviceInspectionRecord> selectDeviceParameterPage(IPage page, @Param("ew") QueryWrapper<DeviceInspectionRecordDto> queryWrappers); + IPage<DeviceInspectionRecord> selectDeviceParameterPage(Page page, @Param("ew") QueryWrapper<DeviceInspectionRecordDto> queryWrappers); } diff --git a/cnas-device/src/main/java/com/ruoyi/device/mapper/InstructionMapper.java b/cnas-device/src/main/java/com/ruoyi/device/mapper/InstructionMapper.java index 12fd129..022c5e4 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/mapper/InstructionMapper.java +++ b/cnas-device/src/main/java/com/ruoyi/device/mapper/InstructionMapper.java @@ -8,6 +8,8 @@ import com.ruoyi.device.pojo.DeviceInstruction; import org.apache.ibatis.annotations.Param; +import java.util.Map; + /** * <p> * 浣滀笟鎸囧涔︽坊鍔犲彈鎺ф枃浠惰〃 Mapper 鎺ュ彛 @@ -19,5 +21,5 @@ public interface InstructionMapper extends BaseMapper<DeviceInstruction> { - IPage<DeviceInstruction> pageByPageQueryOfHomeworkInstructions(Page page, @Param("ew") QueryWrapper<DeviceOperationInstructionDto> ew); + IPage<DeviceOperationInstructionDto> pageByPageQueryOfHomeworkInstructions(Page page, @Param("ew") QueryWrapper<DeviceOperationInstructionDto> ew); } diff --git a/cnas-device/src/main/java/com/ruoyi/device/service/DeviceInspectionRecordService.java b/cnas-device/src/main/java/com/ruoyi/device/service/DeviceInspectionRecordService.java index 7278b3c..2a7e72d 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/service/DeviceInspectionRecordService.java +++ b/cnas-device/src/main/java/com/ruoyi/device/service/DeviceInspectionRecordService.java @@ -1,6 +1,7 @@ package com.ruoyi.device.service; import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.IService; import com.ruoyi.common.core.domain.Result; import com.ruoyi.device.dto.DeviceInspectionRecordDto; @@ -22,7 +23,7 @@ * 鍒嗛〉鏌ヨ璁惧鐐规璁板綍 * @param page */ - Result<IPage<DeviceInspectionRecord>> getDeviceInspectionRecordByPage(IPage page, DeviceInspectionRecordDto deviceInspectionRecord); + Result<IPage<DeviceInspectionRecord>> getDeviceInspectionRecordByPage(Page page, DeviceInspectionRecordDto deviceInspectionRecord); /** diff --git a/cnas-device/src/main/java/com/ruoyi/device/service/DeviceInstructionService.java b/cnas-device/src/main/java/com/ruoyi/device/service/DeviceInstructionService.java index 70e5f1c..8d1c73a 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/service/DeviceInstructionService.java +++ b/cnas-device/src/main/java/com/ruoyi/device/service/DeviceInstructionService.java @@ -7,6 +7,8 @@ import com.ruoyi.device.dto.DeviceOperationInstructionDto; import com.ruoyi.device.pojo.DeviceInstruction; +import java.util.Map; + /** * <p> * 浣滀笟鎸囧涔︽坊鍔犲彈鎺ф枃浠惰〃 鏈嶅姟绫� @@ -17,7 +19,7 @@ */ public interface DeviceInstructionService extends IService<DeviceInstruction> { - IPage<DeviceInstruction> pageByPageQueryOfHomeworkInstructions(Page page, DeviceOperationInstructionDto operationInstructionDto); + IPage<DeviceOperationInstructionDto> pageByPageQueryOfHomeworkInstructions(Page page, DeviceOperationInstructionDto operationInstructionDto); void newHomeworkGuidebookAdded(DeviceInstructionDto instructionDto); } diff --git a/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceInspectionRecordServiceImpl.java b/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceInspectionRecordServiceImpl.java index 2c8041d..1a3f00a 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceInspectionRecordServiceImpl.java +++ b/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceInspectionRecordServiceImpl.java @@ -4,6 +4,7 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.deepoove.poi.XWPFTemplate; import com.deepoove.poi.config.Configure; @@ -52,6 +53,8 @@ private DeviceMapper deviceMapper; @Resource private DeviceInspectionRecordDetailsService deviceInspectionRecordDetailsService; + @Resource + private DeviceInspectionRecordMapper deviceInspectionRecordMapper; /** * 鍒嗛〉鏌ヨ璁惧鐐规璁板綍 @@ -59,8 +62,8 @@ * @param page 褰撳墠椤电爜 */ @Override - public Result<IPage<DeviceInspectionRecord>> getDeviceInspectionRecordByPage(IPage page, DeviceInspectionRecordDto deviceInspectionRecordDto) { - IPage<DeviceInspectionRecord> iPage = baseMapper.selectDeviceParameterPage(page, QueryWrappers.queryWrappers(deviceInspectionRecordDto)); + public Result<IPage<DeviceInspectionRecord>> getDeviceInspectionRecordByPage(Page page, DeviceInspectionRecordDto deviceInspectionRecordDto) { + IPage<DeviceInspectionRecord> iPage = deviceInspectionRecordMapper.selectDeviceParameterPage(page, QueryWrappers.queryWrappers(deviceInspectionRecordDto)); return Result.success(iPage); } diff --git a/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceInstructionServiceImpl.java b/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceInstructionServiceImpl.java index 6f5bb5b..a43a987 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceInstructionServiceImpl.java +++ b/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceInstructionServiceImpl.java @@ -21,6 +21,7 @@ import java.time.LocalDateTime; import java.util.Date; import java.util.Locale; +import java.util.Map; /** * <p> @@ -41,7 +42,7 @@ private NumberGenerator<DeviceInstruction> numberGenerator; @Override - public IPage<DeviceInstruction> pageByPageQueryOfHomeworkInstructions(Page page, DeviceOperationInstructionDto operationInstructionDto) { + public IPage<DeviceOperationInstructionDto> pageByPageQueryOfHomeworkInstructions(Page page, DeviceOperationInstructionDto operationInstructionDto) { return baseMapper.pageByPageQueryOfHomeworkInstructions(page, QueryWrappers.queryWrappers(operationInstructionDto)); } diff --git a/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceMaintenanceImpl.java b/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceMaintenanceImpl.java index 5b0d72c..7c28152 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceMaintenanceImpl.java +++ b/cnas-device/src/main/java/com/ruoyi/device/service/impl/DeviceMaintenanceImpl.java @@ -12,6 +12,7 @@ import com.ruoyi.device.pojo.DeviceMaintenance; import com.ruoyi.device.service.DeviceMaintenanceService; import com.ruoyi.inspect.util.HackLoopTableRenderPolicy; +import org.apache.commons.lang3.ObjectUtils; import org.springframework.stereotype.Service; import javax.annotation.Resource; @@ -27,7 +28,11 @@ @Override public IPage<DeviceMaintenance> getDeviceMaintenancePage(Page page, Integer deviceId, String deviceNumber) { - return baseMapper.selectPage(page, Wrappers.<DeviceMaintenance>lambdaQuery() + if (ObjectUtils.isEmpty(deviceNumber)){ + return baseMapper.selectPage(page, Wrappers.<DeviceMaintenance>lambdaQuery() + .eq(DeviceMaintenance::getDeviceId, deviceId)); + } + else return baseMapper.selectPage(page, Wrappers.<DeviceMaintenance>lambdaQuery() .eq(DeviceMaintenance::getDeviceId, deviceId) .like(DeviceMaintenance::getDeviceNumber, deviceNumber)); } diff --git a/cnas-device/src/main/resources/mapper/DeviceInspectionRecordMapper.xml b/cnas-device/src/main/resources/mapper/DeviceInspectionRecordMapper.xml index af4ac42..8540d74 100644 --- a/cnas-device/src/main/resources/mapper/DeviceInspectionRecordMapper.xml +++ b/cnas-device/src/main/resources/mapper/DeviceInspectionRecordMapper.xml @@ -4,9 +4,8 @@ <select id="selectDeviceParameterPage" resultType="com.ruoyi.device.pojo.DeviceInspectionRecord"> - SELECT - * - from device_inspection_record + select * from ( SELECT * + from device_inspection_record ) a <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''"> ${ew.customSqlSegment} </if> diff --git a/cnas-device/src/main/resources/mapper/InstructionMapper.xml b/cnas-device/src/main/resources/mapper/InstructionMapper.xml index 2d1a823..8404014 100644 --- a/cnas-device/src/main/resources/mapper/InstructionMapper.xml +++ b/cnas-device/src/main/resources/mapper/InstructionMapper.xml @@ -1,17 +1,20 @@ <?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.device.mapper.InstructionMapper"> - - - <select id="pageByPageQueryOfHomeworkInstructions" resultType="com.ruoyi.device.pojo.DeviceInstruction"> + <select id="pageByPageQueryOfHomeworkInstructions" resultType="com.ruoyi.device.dto.DeviceOperationInstructionDto"> SELECT - doi.*,di.*,d.device_name, d.management_number device_number, d.specification_model device_model, u.name uploader_name, u1.name approver_name + doi.*,di.*, + d.device_name deviceName, + d.management_number deviceNumber, + d.specification_model deviceModel, + u.name uploaderName, + u1.name approverName FROM - device_operation_instruction doi - LEFT JOIN device_instruction di ON di.id = doi.instruction_id - left join device d on d.id = doi.device_id - left join user u on u.id = doi.uploader - left join user u1 on u1.id = doi.approver_id + device_operation_instruction doi + LEFT JOIN device_instruction di ON di.id = doi.instruction_id + left join device d on d.id = doi.device_id + left join user u on u.id = doi.uploader + left join user u1 on u1.id = doi.approver_id <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''"> ${ew.customSqlSegment} </if> diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonCommunicationAbilityController.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonCommunicationAbilityController.java index 3aef8b9..6fa8de7 100644 --- a/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonCommunicationAbilityController.java +++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonCommunicationAbilityController.java @@ -54,7 +54,7 @@ } @ApiOperation(value = "瀵煎嚭娌熼�氳褰�") - @PostMapping("exportPersonCommunicationAbility") + @GetMapping("exportPersonCommunicationAbility") public void exportPersonCommunicationAbility(Integer id, HttpServletResponse response) throws Exception{ personCommunicationAbilityService.exportPersonCommunicationAbility(id,response); } diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonJobResponsibilitiesController.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonJobResponsibilitiesController.java index 615af7b..f91692b 100644 --- a/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonJobResponsibilitiesController.java +++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonJobResponsibilitiesController.java @@ -46,7 +46,7 @@ @ApiOperation(value = "鏌ヨ 宀椾綅鑱岃矗") @GetMapping("/personJobResponsibilitiesSelect") - public Result<IPage<PersonJobResponsibilitiesDto>> personJobResponsibilitiesSelect(Page page, String userId, String departmentId, String userName) { + public Result personJobResponsibilitiesSelect(Page page, String userId, String departmentId, String userName) { IPage<PersonJobResponsibilitiesDto> iPage = personJobResponsibilitiesService.personJobResponsibilitiesSelect(page, userId, departmentId, userName); return Result.success(iPage); } diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonPostAuthorizationRecordController.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonPostAuthorizationRecordController.java index c65f312..aba3e7a 100644 --- a/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonPostAuthorizationRecordController.java +++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/controller/PersonPostAuthorizationRecordController.java @@ -59,7 +59,7 @@ } @ApiOperation(value = "瀵煎嚭宀椾綅鑱屼笟璧勬牸璇佷功") - @PostMapping("/exportPersonPostAuthorizationRecord") + @GetMapping("/exportPersonPostAuthorizationRecord") public void exportPersonPostAuthorizationRecord(Integer id, HttpServletResponse response){ personPostAuthorizationRecordService.exportPersonPostAuthorizationRecord(id,response); } diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonJobResponsibilitiesMapper.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonJobResponsibilitiesMapper.java index a46e3bf..948c100 100644 --- a/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonJobResponsibilitiesMapper.java +++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonJobResponsibilitiesMapper.java @@ -5,6 +5,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ruoyi.personnel.dto.PersonJobResponsibilitiesDto; import com.ruoyi.personnel.pojo.PersonJobResponsibilities; +import org.apache.ibatis.annotations.Param; /** * <p> @@ -16,5 +17,5 @@ */ public interface PersonJobResponsibilitiesMapper extends BaseMapper<PersonJobResponsibilities> { - IPage<PersonJobResponsibilitiesDto> personJobResponsibilitiesSelect(Page page, String userId, String departmentId, String userName); + IPage<PersonJobResponsibilitiesDto> personJobResponsibilitiesSelect(Page page, @Param("userId") String userId, @Param("departmentId") String departmentId, @Param("userName") String userName); } diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonPersonnelCapacityMapper.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonPersonnelCapacityMapper.java index b2bb671..71c7246 100644 --- a/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonPersonnelCapacityMapper.java +++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonPersonnelCapacityMapper.java @@ -18,7 +18,7 @@ */ public interface PersonPersonnelCapacityMapper extends BaseMapper<PersonPersonnelCapacity> { - IPage<PersonPersonnelCapacityDto> personPersonnelCapacityPage(Page page, Integer departLimsId, Integer userId, String userName); + IPage<PersonPersonnelCapacityDto> personPersonnelCapacityPage(Page page, @Param("departLimsId") Integer departLimsId,@Param("userId") Integer userId,@Param("userName") String userName); /** * 鏌ヨ浜哄憳鑳藉姏鎺ュ彛 diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonPostAuthorizationRecordMapper.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonPostAuthorizationRecordMapper.java index 1121811..25e4906 100644 --- a/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonPostAuthorizationRecordMapper.java +++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonPostAuthorizationRecordMapper.java @@ -5,6 +5,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ruoyi.personnel.dto.PersonPostAuthorizationRecordDto; import com.ruoyi.personnel.pojo.PersonPostAuthorizationRecord; +import org.apache.ibatis.annotations.Param; /** * <p> @@ -16,5 +17,5 @@ */ public interface PersonPostAuthorizationRecordMapper extends BaseMapper<PersonPostAuthorizationRecord> { - IPage<PersonPostAuthorizationRecordDto> personPostAuthorizationRecordPage(Page page, Integer departLimsId, Integer userId, String userName); + IPage<PersonPostAuthorizationRecordDto> personPostAuthorizationRecordPage(Page page, @Param("departLimsId") Integer departLimsId, @Param("userId") Integer userId, @Param("userName") String userName); } diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonRewardPunishmentRecordMapper.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonRewardPunishmentRecordMapper.java index a77cb79..bc99f12 100644 --- a/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonRewardPunishmentRecordMapper.java +++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonRewardPunishmentRecordMapper.java @@ -6,6 +6,7 @@ import com.ruoyi.personnel.dto.PersonRewardPunishmentRecordDto; import com.ruoyi.personnel.excel.PersonRewardPunishmentRecordExcel; import com.ruoyi.personnel.pojo.PersonRewardPunishmentRecord; +import org.apache.ibatis.annotations.Param; import java.util.Date; import java.util.List; @@ -20,7 +21,7 @@ */ public interface PersonRewardPunishmentRecordMapper extends BaseMapper<PersonRewardPunishmentRecord> { - IPage<PersonRewardPunishmentRecordDto> rewardPunishmentPage(Page page, Integer userId, String userName, Date startTime, Date endTime, Integer departmentId); + IPage<PersonRewardPunishmentRecordDto> rewardPunishmentPage(Page page, @Param("userId") Integer userId, @Param("userName") String userName,@Param("startTime") Date startTime, @Param("endTime") Date endTime,@Param("departmentId") Integer departmentId); - List<PersonRewardPunishmentRecordExcel> rewardPunishmentExport(Integer userId, Integer departmentId, String userName, Date startTime, Date endTime); + List<PersonRewardPunishmentRecordExcel> rewardPunishmentExport(@Param("userId") Integer userId, @Param("departmentId") Integer departmentId, @Param("userName") String userName, @Param("startTime") Date startTime, @Param("endTime") Date endTime); } diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonTrainingRecordMapper.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonTrainingRecordMapper.java index 6f59398..50acbc4 100644 --- a/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonTrainingRecordMapper.java +++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/mapper/PersonTrainingRecordMapper.java @@ -23,7 +23,7 @@ List<PersonTrainingRecordDto> trainingAndAssessmentRecordsPage(@Param("trainingDetailedId") Integer trainingDetailedId,@Param("userName") String userName); - IPage<PersonTrainingRecordListDto> personnelTrainingPersonnel(Page page, String userName, Integer userId, Integer departLimsId); + IPage<PersonTrainingRecordListDto> personnelTrainingPersonnel(Page page, @Param("userName") String userName, @Param("userId") Integer userId,@Param("departLimsId") Integer departLimsId); IPage<TrainingRecordPersonDetailedDto> queryPersonnelDetails(Page page, Integer userId); @@ -55,7 +55,7 @@ * @param year * @return */ - IPage<TrainingRecordPersonDetailedDto> queryPersonnelDetailsOfUserIdAndYear(Page page, Integer userId, Integer year); + IPage<TrainingRecordPersonDetailedDto> queryPersonnelDetailsOfUserIdAndYear(Page page, @Param("userId") Integer userId, @Param("year") Integer year); /** * 鏍规嵁鐢ㄦ埛id鍜屽勾浠芥煡璇汉鍛樻槑缁� 鍩硅璁板綍瀵煎嚭 diff --git a/cnas-personnel/src/main/resources/mapper/PersonPersonnelCapacityMapper.xml b/cnas-personnel/src/main/resources/mapper/PersonPersonnelCapacityMapper.xml index 96e0358..a4d9133 100644 --- a/cnas-personnel/src/main/resources/mapper/PersonPersonnelCapacityMapper.xml +++ b/cnas-personnel/src/main/resources/mapper/PersonPersonnelCapacityMapper.xml @@ -16,10 +16,10 @@ -- 鍙栧矖浣� left join cnas_person_basic_info cpbi on cpbi.user_id = cppc.user_id -- 鍙栦汉鍛樿兘鍔涚殑宀椾綅鑱岃矗 - left join (SELECT GROUP_CONCAT(e.label) responsibilities, cppc.id + left join (SELECT GROUP_CONCAT(e.dict_label) responsibilities, cppc.id from cnas_person_personnel_capacity cppc - left join enums e on FIND_IN_SET(e.value, cppc.job_responsibilities) - where e.category = '宀椾綅鑱岃矗' + left join sys_dict_data e on FIND_IN_SET(e.dict_value, cppc.job_responsibilities) + where e.dict_type = 'responsibilities_list' GROUP BY cppc.id) ecp on ecp.id = cppc.id <where> <if test="userId != null and userId != ''"> diff --git a/cnas-process/src/main/java/com/ruoyi/process/controller/ProcessMethodVerifyController.java b/cnas-process/src/main/java/com/ruoyi/process/controller/ProcessMethodVerifyController.java index d265511..88ec27c 100644 --- a/cnas-process/src/main/java/com/ruoyi/process/controller/ProcessMethodVerifyController.java +++ b/cnas-process/src/main/java/com/ruoyi/process/controller/ProcessMethodVerifyController.java @@ -146,7 +146,7 @@ * @return */ @ApiOperation(value = "鏍囧噯鏂规硶鍒犻櫎楠岃瘉鍘熷璁板綍鍒楄〃") - @GetMapping("/delVerifyMethodFileList") + @DeleteMapping("/delVerifyMethodFileList") public Result delVerifyMethodFileList(Integer methodFileId){ return Result.success(processMethodVerifyMethodFileService.removeById(methodFileId)); } diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderPlanServiceImpl.java b/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderPlanServiceImpl.java index 69d71dc..7e74e76 100644 --- a/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderPlanServiceImpl.java +++ b/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderPlanServiceImpl.java @@ -55,6 +55,7 @@ import org.apache.commons.lang3.StringUtils; import org.apache.poi.xwpf.usermodel.*; import org.springframework.beans.factory.annotation.Value; +import org.springframework.core.io.ClassPathResource; import org.springframework.mock.web.MockMultipartFile; import org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor; import org.springframework.stereotype.Service; @@ -141,8 +142,7 @@ private InsOrderFactoryVerifyMapper insOrderFactoryVerifyMapper; @Resource private InsOrderFactoryVerifyItemService insOrderFactoryVerifyItemService; - @Value("${file.licenseUrl}") - private String licenseUrl; + @Resource private SpotCheckQuarterItemMapper spotCheckQuarterItemMapper; @Resource @@ -4227,7 +4227,7 @@ FileOutputStream os = null; try { //鍑瘉 涓嶇劧鍒囨崲鍚庢湁姘村嵃 - InputStream is = Files.newInputStream(new File(licenseUrl).toPath()); + InputStream is = new ClassPathResource("/lib/license.xml").getInputStream(); License license = new License(); license.setLicense(is); if (!license.getIsLicensed()) { diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsReportServiceImpl.java b/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsReportServiceImpl.java index 7d61ac8..a76f10e 100644 --- a/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsReportServiceImpl.java +++ b/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsReportServiceImpl.java @@ -39,6 +39,7 @@ import lombok.extern.slf4j.Slf4j; import org.apache.poi.xwpf.usermodel.*; import org.springframework.beans.factory.annotation.Value; +import org.springframework.core.io.ClassPathResource; import org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; @@ -83,8 +84,7 @@ private String wordUrl; @Value("${file.path}") private String imgUrl; - @Value("${file.licenseUrl}") - private String licenseUrl; + @Resource private InsOrderMapper insOrderMapper; @Resource @@ -676,7 +676,7 @@ FileOutputStream os = null; try { //鍑瘉 涓嶇劧鍒囨崲鍚庢湁姘村嵃 - InputStream is = Files.newInputStream(new File(licenseUrl).toPath()); + InputStream is = new ClassPathResource("/lib/license.xml").getInputStream(); License license = new License(); license.setLicense(is); if (!license.getIsLicensed()) { @@ -1115,7 +1115,7 @@ FileOutputStream os = null; try { //鍑瘉 涓嶇劧鍒囨崲鍚庢湁姘村嵃 - InputStream is = Files.newInputStream(new File(licenseUrl).toPath()); + InputStream is = new ClassPathResource("/lib/license.xml").getInputStream(); License license = new License(); license.setLicense(is); if (!license.getIsLicensed()) { -- Gitblit v1.9.3