服务和供应品采购/供应商管理/设施和环境条件代码迁移

gaoluyang

2025-02-24 c89b4a74d3d770da0ccdd679e5942b1e9028776b

服务和供应品采购/供应商管理/设施和环境条件代码迁移

 cnas-require/src/main/java/com/ruoyi/require/controller/FeIlluminationController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,88 @@
package com.ruoyi.require.controller;

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.ruoyi.common.core.domain.Result;
import com.ruoyi.require.dto.FeIlluminationAddDto;
import com.ruoyi.require.dto.FeIlluminationDto;
import com.ruoyi.require.pojo.FeIllumination;
import com.ruoyi.require.pojo.FeIlluminationDetectionArea;
import com.ruoyi.require.service.FeIlluminationDetectionAreaService;
import com.ruoyi.require.service.FeIlluminationService;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-照度记录表 å‰ç«¯æŽ§åˆ¶å™¨
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:15:57
 */
@RestController
@RequestMapping("/feIllumination")
public class FeIlluminationController {

    @Autowired
    private FeIlluminationService feIlluminationService;

    @Autowired
    private FeIlluminationDetectionAreaService feIlluminationDetectionAreaService;

    @PostMapping("addFeLightningProtection")
    @ApiOperation("设施和环境条件要求-照度记录表-检测区域 æ–°å¢ž/修改")
    public Result<?> addFeLightningProtection(@RequestBody FeIlluminationAddDto feIlluminationAddDto) {
        FeIllumination feIllumination = new FeIllumination();
        BeanUtils.copyProperties(feIlluminationAddDto, feIllumination);
        feIlluminationService.saveOrUpdate(feIllumination);
        if (CollectionUtils.isNotEmpty(feIlluminationAddDto.getIlluminationDetectionAreaList())) {
            feIlluminationAddDto.getIlluminationDetectionAreaList().forEach(i -> i.setIntensityIlluminationId(feIllumination.getIntensityIlluminationId()));
            feIlluminationDetectionAreaService.saveOrUpdateBatch(feIlluminationAddDto.getIlluminationDetectionAreaList());
        }
        return Result.success();
    }

    @DeleteMapping("deleteFeLightningProtection")
    @ApiOperation("设施和环境条件要求-照度记录表-检测区域 åˆ é™¤")
    public Result<?> deleteFeLightningProtection(@RequestParam("intensityIlluminationId") Integer intensityIlluminationId) {
        feIlluminationService.removeById(intensityIlluminationId);
        return Result.success();
    }

    @GetMapping("getFeLightningProtection")
    @ApiOperation("照度记录表-检测区域 æŸ¥è¯¢")
    public Result<IPage<FeIlluminationDto>> getFeLightningProtection(Page page) {
        IPage<FeIlluminationDto> page1 = feIlluminationService.getFeLightningProtection(page);
        return Result.success(page1);
    }

    @DeleteMapping("deleteFeIlluminationDetectionArea")
    @ApiOperation("照度记录表-检测区域 åˆ é™¤")
    public Result<?> deleteFeIlluminationDetectionArea(@RequestParam("detectionAreaId") Integer detectionAreaId) {
        return Result.success(feIlluminationDetectionAreaService.removeById(detectionAreaId));
    }

    @GetMapping("getFeIlluminationDetectionArea")
    @ApiOperation("照度记录表-检测区域 æ ¹æ®ç…§åº¦è®°å½•æŸ¥è¯¢")
    public Result<?> getFeIlluminationDetectionArea(@RequestParam("intensityIlluminationId") Integer intensityIlluminationId) {
        return Result.success(feIlluminationDetectionAreaService.list(Wrappers.<FeIlluminationDetectionArea>lambdaQuery()
                .eq(FeIlluminationDetectionArea::getIntensityIlluminationId, intensityIlluminationId)));
    }

    /**
     * å¯¼å‡ºç…§åº¦è®°å½•
     * @return
     */
    @ApiOperation(value = "导出照度记录")
    @GetMapping("/exportFeIllumination")
    public void exportFeIllumination(Integer intensityIlluminationId, HttpServletResponse response){
        feIlluminationService.exportFeIllumination(intensityIlluminationId, response);
    }
}

 cnas-require/src/main/java/com/ruoyi/require/controller/FeLightningProtectionController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,80 @@
package com.ruoyi.require.controller;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.common.core.domain.Result;
import com.ruoyi.common.utils.FileSaveUtil;
import com.ruoyi.require.excel.FeLightningProtectionExcel;
import com.ruoyi.require.pojo.FeLightningProtection;
import com.ruoyi.require.service.FeLightningProtectionService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-防雷检测 å‰ç«¯æŽ§åˆ¶å™¨
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:36
 */
@Api(tags = "设施和环境条件要求-防雷检测")
@RestController
@RequestMapping("/feLightningProtection")
public class FeLightningProtectionController {

    @Autowired
    private FeLightningProtectionService feLightningProtectionService;

    @PostMapping("addLightningProtectionDetection")
    @ApiOperation("设施和环境条件要求-防雷检测新增/修改")
    public Result<?> addLightningProtectionDetection(FeLightningProtection feLightningProtection,
                                                     @RequestPart(value = "file", required = false) MultipartFile file) {
        if (ObjectUtils.isNotEmpty(file)) {
            String s = FileSaveUtil.StoreFile(file);
            feLightningProtection.setSystemFileName(s);
            feLightningProtection.setFileName(file.getOriginalFilename());
        }
        feLightningProtectionService.saveOrUpdate(feLightningProtection);
        return Result.success();
    }

    @DeleteMapping("deleteLightningProtectionDetection")
    @ApiOperation("设施和环境条件要求-防雷检测删除")
    public Result<?> deleteFeLightningProtection(@RequestParam("lightningProtectionId") Integer lightningProtectionId) {
        feLightningProtectionService.removeById(lightningProtectionId);
        return Result.success();
    }

    @GetMapping("getLightningProtectionDetection")
    @ApiOperation("设施和环境条件要求-防雷检测查询")
    public Result<IPage<FeLightningProtection>> getFeLightningProtection(Page page) {
        IPage<FeLightningProtection> page1 = feLightningProtectionService.page(page);
        return Result.success(page1);
    }

    @ApiOperation(value = "设施和环境条件要求-防雷检测导出")
    @GetMapping("exportOfLightningProtectionDetection")
    public void exportOfLightningProtectionDetection(HttpServletResponse response) throws Exception {
        List<FeLightningProtectionExcel> ipage = feLightningProtectionService.exportOfLightningProtectionDetection();
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setHeader("requestType", "excel");
        response.setHeader("Access-Control-Expose-Headers", "requestType");
        // è®¾ç½®å•å…ƒæ ¼æ ·å¼
        // ä¿å­˜åˆ°ç¬¬ä¸€ä¸ªsheet中
        EasyExcel.write(response.getOutputStream())
                .head(FeLightningProtectionExcel.class)
                .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) // è‡ªé€‚应列宽
                .sheet("sheet")
                .doWrite(ipage);
    }
}

 cnas-require/src/main/java/com/ruoyi/require/controller/FePowerStableController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,99 @@
package com.ruoyi.require.controller;

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.ruoyi.common.core.domain.Result;
import com.ruoyi.require.dto.FePowerStableAddDto;
import com.ruoyi.require.dto.FePowerStableDto;
import com.ruoyi.require.pojo.FeMeasuredQuantity;
import com.ruoyi.require.pojo.FePowerStable;
import com.ruoyi.require.service.FeMeasuredQuantityService;
import com.ruoyi.require.service.FePowerStableService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-电源稳定性 å‰ç«¯æŽ§åˆ¶å™¨
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:52
 */
@Api(tags = "设施和环境条件-设施和环境条件要求-电源稳定性")
@RestController
@RequestMapping("/fePowerStable")
public class FePowerStableController {

    @Autowired
    private FeMeasuredQuantityService feMeasuredQuantityService;

    @Autowired
    private FePowerStableService fePowerStableService;

    @PostMapping("addLaboratoryFacilityPowerStable")
    @ApiOperation("电源稳定性新增/修改")
    public Result<?> addLaboratoryFacilityPowerStable(@RequestBody FePowerStableAddDto fePowerStableAddDto) {
        FePowerStable fePowerStable = new FePowerStable();
        BeanUtils.copyProperties(fePowerStableAddDto, fePowerStable);
        fePowerStableService.saveOrUpdate(fePowerStable);
        if (CollectionUtils.isNotEmpty(fePowerStableAddDto.getFeMeasuredQuantityList())) {
            fePowerStableAddDto.getFeMeasuredQuantityList().forEach(i -> i.setPowerStableId(fePowerStable.getPowerStableId()));
            feMeasuredQuantityService.saveOrUpdateBatch(fePowerStableAddDto.getFeMeasuredQuantityList());
        }
        return Result.success();
    }

    @DeleteMapping("deleteLaboratoryFacilityPowerStable")
    @ApiOperation("电源稳定性删除")
    public Result<FePowerStable> deleteLaboratoryFacilityPowerStable(@RequestParam("powerStableId") Integer powerStableId) {
        fePowerStableService.removeById(powerStableId);
        feMeasuredQuantityService.remove(Wrappers.<FeMeasuredQuantity>lambdaQuery()
                .eq(FeMeasuredQuantity::getPowerStableId, powerStableId));
        return Result.success();
    }

    @GetMapping("getLaboratoryFacilityPowerStablePage")
    @ApiOperation("电源稳定性查询")
    public Result<IPage<FePowerStableDto>> getLaboratoryFacilityPowerStablePage(
            Page page) {
        IPage<FePowerStableDto> page1 = fePowerStableService.getLaboratoryFacilityPowerStablePage(page);
        return Result.success(page1);
    }

    @ApiOperation("选择设备后查询最新设备编号，校准日期")
    @GetMapping("getCalibrationDate")
    public Result<?> getCalibrationDate(@RequestParam("deviceId") Integer deviceId) {
        return Result.success(fePowerStableService.getCalibrationDate(deviceId));
    }

    @DeleteMapping("deleteFeMeasuredQuantity")
    @ApiOperation("电源稳定性-测定量 åˆ é™¤")
    public Result<?> deleteFeMeasuredQuantity(@RequestParam("measuredQuantityId") Integer measuredQuantityId) {
        return Result.success(feMeasuredQuantityService.removeById(measuredQuantityId));
    }

    @GetMapping("getFeMeasuredQuantityService")
    @ApiOperation("电源稳定性-测定量 æ ¹æ®ç”µæºç¨³å®šæ€§æŸ¥è¯¢")
    public Result<?> getFeMeasuredQuantityService(@RequestParam("powerStableId") Integer powerStableId) {
        return Result.success(feMeasuredQuantityService.list(Wrappers.<FeMeasuredQuantity>lambdaQuery()
                .eq(FeMeasuredQuantity::getPowerStableId, powerStableId)));
    }

    /**
     * å¯¼å‡ºç”µæºç¨³å®šæ€§
     * @return
     */
    @ApiOperation(value = "导出电源稳定性")
    @GetMapping("/exportFePowerStable")
    public void exportFePowerStable(Integer powerStableId, HttpServletResponse response){
        fePowerStableService.exportFePowerStable(powerStableId, response);
    }
}

 cnas-require/src/main/java/com/ruoyi/require/controller/FeTempHumDateController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,103 @@
package com.ruoyi.require.controller;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.common.core.domain.Result;
import com.ruoyi.require.dto.FeTempHumDateDto;
import com.ruoyi.require.dto.FeTempHumRecordDto;
import com.ruoyi.require.pojo.FeTempHumDate;
import com.ruoyi.require.pojo.FeTempHumRecord;
import com.ruoyi.require.service.FeTempHumDateService;
import com.ruoyi.require.service.FeTempHumRecordService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-温湿度 åŒºåŸŸ -父 å‰ç«¯æŽ§åˆ¶å™¨
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-09 11:02:18
 */
@Api(tags = "温湿度记录")
@RestController
@RequestMapping("/feTempHumDate")
public class FeTempHumDateController {

    @Autowired
    private FeTempHumDateService feTempHumDateService;

    @Autowired
    private FeTempHumRecordService feTempHumRecordService;

    @PostMapping("addFeTempHumDate")
    @ApiOperation("试验区域-新增/修改")
    public Result<?> addFeTempHumDate(@RequestBody FeTempHumDate feTempHumDate) {
        feTempHumDateService.saveOrUpdate(feTempHumDate);
        return Result.success();
    }

    @DeleteMapping("deleteFeTempHumDate")
    @ApiOperation("试验区域-删除")
    public Result<?> deleteFeTempHumDate(
            @RequestParam("dateId") Integer dateId) {
        feTempHumDateService.removeById(dateId);
        return Result.success();
    }

    @GetMapping("getFeTempHumDate")
    @ApiOperation("试验区域-查询")
    public Result<IPage<FeTempHumDateDto>> getFeTempHumDate(Page page, FeTempHumDateDto feTempHumDateDto) {
        IPage<FeTempHumDateDto> page1 = feTempHumDateService.getFeTempHumDate(page, feTempHumDateDto);
        return Result.success(page1);
    }

    @PostMapping("addFeTempHumRecord")
    @ApiOperation("温湿度记录新增/修改")
    public Result<FeTempHumRecord> addFeTempHumRecord(@RequestBody FeTempHumRecord feTempHumRecord) {
        feTempHumRecordService.saveOrUpdate(feTempHumRecord);
        return Result.success();
    }

    @DeleteMapping("deleteFeTempHumRecord")
    @ApiOperation("温湿度记录删除")
    public Result<?> deleteFeTempHumRecord(
            @RequestParam("tempHumId") Integer tempHumId) {
        feTempHumRecordService.removeById(tempHumId);
        return Result.success();
    }

    @GetMapping("getFeTempHumRecordPage")
    @ApiOperation("温湿度记录查询")
    public Result<IPage<FeTempHumRecordDto>> getFeTempHumRecordPage(Page page, Integer dateId) {
        IPage<FeTempHumRecordDto> page1 = feTempHumRecordService.getFeTempHumRecordPage(page, dateId);
        return Result.success(page1);
    }

    /**
     * æ¸©æ¹¿åº¦è®°å½•å¯¼å‡º
     * @return
     */
    @ApiOperation(value = "导出")
    @GetMapping("/exportTemperatureAndHumidityRecords")
    public void exportTemperatureAndHumidityRecords(Integer dateId, HttpServletResponse response){
        feTempHumDateService.exportTemperatureAndHumidityRecords(dateId, response);
    }

    /**
     * æ¸©æ¹¿åº¦ç¡®è®¤
     * @param feTempHumDate
     * @return
     */
    @ApiOperation("温湿度确认")
    @PostMapping("affirmFeTempHumDate")
    public Result<?> affirmFeTempHumDate(@RequestBody FeTempHumDate feTempHumDate) {
        feTempHumDateService.affirmFeTempHumDate(feTempHumDate);
        return Result.success();
    }
}

 cnas-require/src/main/java/com/ruoyi/require/controller/ForeignRegisterController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,97 @@
package com.ruoyi.require.controller;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.common.core.domain.Result;
import com.ruoyi.common.utils.JackSonUtil;
import com.ruoyi.require.dto.ForeignRegisterDto;
import com.ruoyi.require.pojo.ForeignRegister;
import com.ruoyi.require.service.ForeignRegisterService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.util.Map;

/**
 * <p>
 * å¤–来人员登记 å‰ç«¯æŽ§åˆ¶å™¨
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 07:17:35
 */
@Api(tags = "外来人员登记")
@AllArgsConstructor
@RestController
@RequestMapping("/foreignRegister")
public class ForeignRegisterController {

    private ForeignRegisterService foreignRegisterService;

    /**
     * å¤–来人员登记分页查询
     * @param data
     * @return
     */
    @ApiOperation(value = "外来人员登记分页查询")
    @PostMapping("/pageForeignRegister")
    public Result<IPage<ForeignRegisterDto>> pageForeignRegister(@RequestBody Map<String, Object> data) throws Exception {
        Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class);
        ForeignRegisterDto foreignRegister = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("entity")), ForeignRegisterDto.class);
        return Result.success(foreignRegisterService.pageForeignRegister(page, foreignRegister));
    }

    /**
     * å¤–来人员登记新增
     * @return
     */
    @ApiOperation(value = "外来人员登记新增")
    @PostMapping("/addForeignRegister")
    public Result addForeignRegister(@RequestBody ForeignRegister foreignRegister){
        return Result.success(foreignRegisterService.save(foreignRegister));
    }

    /**
     * å¤–来人员登记修改
     * @return
     */
    @ApiOperation(value = "外来人员登记修改")
    @PostMapping("/updateForeignRegister")
    public Result updateForeignRegister(@RequestBody ForeignRegister foreignRegister){
        return Result.success(foreignRegisterService.updateById(foreignRegister));
    }

    /**
     * å¤–来人员登记删除
     * @return
     */
    @ApiOperation(value = "外来人员登记删除")
    @GetMapping("/delForeignRegister")
    public Result delForeignRegister(Integer registerId){
        return Result.success(foreignRegisterService.removeById(registerId));
    }

    /**
     * å¤–来人员登记查看详情
     * @return
     */
    @ApiOperation(value = "外来人员登记查看详情")
    @GetMapping("/getForeignRegisterOne")
    public Result<ForeignRegister> getForeignRegisterOne(Integer registerId){
        return Result.success(foreignRegisterService.getById(registerId));
    }

    /**
     * å¯¼å‡ºå¤–来人员登记
     * @return
     */
    @ApiOperation(value = "导出外来人员登记")
    @PostMapping("/exportForeignRegister")
    public void exportForeignRegister(@RequestBody ForeignRegisterDto foreignRegister, HttpServletResponse response){
        foreignRegisterService.exportForeignRegister(foreignRegister, response);
    }

}

 cnas-require/src/main/java/com/ruoyi/require/controller/InternalWastesController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,97 @@
package com.ruoyi.require.controller;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.common.core.domain.Result;
import com.ruoyi.common.utils.JackSonUtil;
import com.ruoyi.require.dto.InternalWastesDto;
import com.ruoyi.require.pojo.InternalWastes;
import com.ruoyi.require.service.InternalWastesService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.util.Map;

/**
 * <p>
 * å®‰å…¨å†…务三废登记 å‰ç«¯æŽ§åˆ¶å™¨
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 06:39:27
 */
@Api(tags = "安全内务三废登记")
@AllArgsConstructor
@RestController
@RequestMapping("/internalWastes")
public class InternalWastesController {

    private InternalWastesService internalWastesService;

    /**
     * å®‰å…¨å†…务三废处理分页查询
     * @param data
     * @return
     */
    @ApiOperation(value = "安全内务三废处理分页查询")
    @PostMapping("/pageInternalWastes")
    public Result<IPage<InternalWastesDto>> pageInternalWastes(@RequestBody Map<String, Object> data) throws Exception {
        Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class);
        InternalWastes internalWastes = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("entity")), InternalWastes.class);
        return Result.success(internalWastesService.pageInternalWastes(page, internalWastes));
    }

    /**
     * å®‰å…¨å†…务三废处理新增
     * @return
     */
    @ApiOperation(value = "安全内务三废处理新增")
    @PostMapping("/addInternalWastes")
    public Result addInternalWastes(@RequestBody InternalWastesDto internalWastes){
        return Result.success(internalWastesService.addInternalWastes(internalWastes));
    }

    /**
     * å®‰å…¨å†…务三废处理修改
     * @return
     */
    @ApiOperation(value = "安全内务三废处理修改")
    @PostMapping("/updateInternalWastes")
    public Result updateInternalWastes(@RequestBody InternalWastesDto internalWastes){
        return Result.success(internalWastesService.updateInternalWastes(internalWastes));
    }

    /**
     * å®‰å…¨å†…务三废处理删除
     * @return
     */
    @ApiOperation(value = "安全内务三废处理删除")
    @GetMapping("/delInternalWastes")
    public Result delInternalWastes(Integer wastesId){
        return Result.success(internalWastesService.delInternalWastes(wastesId));
    }

    /**
     * å®‰å…¨å†…务三废处理查看详情
     * @return
     */
    @ApiOperation(value = "安全内务三废处理查看详情")
    @GetMapping("/getInternalWastesOne")
    public Result<InternalWastesDto> getInternalWastesOne(Integer wastesId){
        return Result.success(internalWastesService.getInternalWastesOne(wastesId));
    }

    /**
     * å¯¼å‡ºä¸‰åºŸå¤„理
     * @return
     */
    @ApiOperation(value = "导出三废处理")
    @GetMapping("/exportInternalWastes")
    public void exportInternalWastes(Integer wastesId, HttpServletResponse response){
        internalWastesService.exportInternalWastes(wastesId, response);
    }

}

 cnas-require/src/main/java/com/ruoyi/require/controller/ProcurementSuppliesListController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,93 @@
package com.ruoyi.require.controller;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.common.core.domain.Result;
import com.ruoyi.common.core.domain.entity.User;
import com.ruoyi.require.dto.ProcurementSuppliesListDto;
import com.ruoyi.require.mapper.ProcurementSuppliesListMapper;
import com.ruoyi.require.mapper.SupplierManagementMapper;
import com.ruoyi.require.pojo.ProcurementSuppliesList;
import com.ruoyi.require.pojo.SupplierManagement;
import com.ruoyi.require.service.ProcurementSuppliesListService;
import com.ruoyi.system.mapper.UserMapper;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;

/**
 * <p>
 * æœåŠ¡ä¸Žä¾›åº”商 è€—材列表 å‰ç«¯æŽ§åˆ¶å™¨
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-15 04:04:32
 */
@Api(tags = "服务和供应品采购耗材")
@RestController
@RequestMapping("/procurementSuppliesList")
public class ProcurementSuppliesListController {
    @Autowired
    private ProcurementSuppliesListService procurementSuppliesListService;

    @Autowired
    private ProcurementSuppliesListMapper listMapper;

    @Autowired
    private UserMapper userMapper;

    @Autowired
    private SupplierManagementMapper supplierManagementMapper;

    @ApiOperation(value = "分页查询")
    @GetMapping("/procurementSuppliesList")
    public Result<IPage<ProcurementSuppliesListDto>> procurementSuppliesList(Page page, ProcurementSuppliesListDto list) {
        return Result.success(procurementSuppliesListService.selectList(page, list));
    }

    @ApiOperation(value = "根据id查询耗材")
    @GetMapping("/selectProcurementSuppliesListById")
    public Result selectProcurementSuppliesListById(Integer id) {
        ProcurementSuppliesList procurementSuppliesStore = listMapper.selectById(id);
        ProcurementSuppliesListDto dto = new ProcurementSuppliesListDto();
        BeanUtils.copyProperties(procurementSuppliesStore, dto);

        User user = userMapper.selectById(procurementSuppliesStore.getPersonInCharge());
        User updateUser = userMapper.selectById(procurementSuppliesStore.getUpdateUser());
        SupplierManagement supplierManagement = supplierManagementMapper.selectById(procurementSuppliesStore.getSupplier());

        dto.setPersonInChargeName(user.getName());
        dto.setUpdateUserName(updateUser.getName());
        dto.setSupplierName(supplierManagement.getSupplierName());
        return Result.success(dto);
    }

    @ApiOperation(value = "新增耗材")
    @PostMapping("/addProcurementSuppliesList")
    public Result addProcurementSuppliesList(@RequestBody ProcurementSuppliesListDto dto) {
        return Result.success(procurementSuppliesListService.addProcurementSuppliesList(dto));
    }

    @ApiOperation(value = "编辑耗材")
    @PostMapping("/updateProcurementSuppliesList")
    public Result updateProcurementSuppliesList(@RequestBody ProcurementSuppliesListDto dto) {
        return Result.success(procurementSuppliesListService.updateProcurementSuppliesList(dto));
    }

    @ApiOperation(value = "删除耗材")
    @PostMapping("/deleteProcurementSuppliesList")
    public Result deleteProcurementSuppliesList(@RequestBody ProcurementSuppliesListDto dto) {
        return Result.success(listMapper.deleteById(dto.getId()));
    }

    @ApiOperation(value = "导出耗材列表")
    @PostMapping("/exportProcurementSuppliesList/{parentId}")
    public void exportProcurementSuppliesList( @PathVariable Integer parentId ,HttpServletResponse response) throws Exception {
        procurementSuppliesListService.exportProcurementSuppliesList(parentId,response);

    }
}

 cnas-require/src/main/java/com/ruoyi/require/controller/SupplierManagementController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,91 @@
package com.ruoyi.require.controller;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.common.core.domain.Result;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.require.pojo.SupplierManagement;
import com.ruoyi.require.service.ProcurementSuppliesContentsService;
import com.ruoyi.require.service.SupplierManagementService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.util.List;
import java.util.Map;

/**
 * <p>
 * å‰ç«¯æŽ§åˆ¶å™¨
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-15 02:46:45
 */
@Api(tags = "供应商管理")
@RestController
@RequestMapping("/supplierManagement")
@AllArgsConstructor
public class SupplierManagementController {

    @Autowired
    private SupplierManagementService supplierManagementService;

    @Autowired
    private ProcurementSuppliesContentsService procurementSuppliesContentsService;


    @ApiOperation("查询供方名录")
    @GetMapping("/selectSupplierManagementByParentId/{parentId}")
    public Result<List<SupplierManagement>> selectSupplierManagementByParentId(@PathVariable Integer parentId) throws Exception {
        return Result.success(supplierManagementService.selectSupplierManagementByParentId(parentId));
    }


    @ApiOperation("分页查询合格供方名录")
    @GetMapping("/selectQualifiedSupplierManagementPage")
    public Result<IPage<SupplierManagement>> selectQualifiedSupplierManagement(SupplierManagement supplierManagement, Page page) throws Exception {
        return Result.success(supplierManagementService.selectQualifiedSupplierManagement(page, supplierManagement));
    }

    @ApiOperation("根据ID查询供应商")
    @GetMapping("/selectQualifiedSupplierManagementById/{supplierManagementId}")
    public Result<List<SupplierManagement>> selectQualifiedSupplierManagementById(@PathVariable Integer supplierManagementId) throws Exception {
        return Result.success(supplierManagementService.selectQualifiedSupplierManagementById(supplierManagementId));
    }

    @ApiOperation("新增供应商")
    @PostMapping("/addSupplierManagement")
    public Result addSupplierManagement(@RequestBody SupplierManagement supplierManagement) {
        return Result.success(supplierManagementService.save(supplierManagement));
    }

    @ApiOperation("修改供应商")
    @PostMapping("/updateSupplierManagement")
    public Result updateSupplierManagement(@RequestBody SupplierManagement supplierManagement) {
        supplierManagement.setUpdateUser(SecurityUtils.getUserId().intValue());
        return Result.success(supplierManagementService.updateById(supplierManagement));
    }

    @ApiOperation("删除供应商")
    @PostMapping("/delSupplierManagement")
    public Result delSupplierManagement(Integer supplierManagementId) {
        return Result.success(supplierManagementService.removeById(supplierManagementId));
    }

    @ApiOperation("导出供应商")
    @PostMapping("/exportSupplierManagement/{parentId}")
    public void exportSupplierManagement(@PathVariable Integer parentId, HttpServletResponse response) throws Exception {
        supplierManagementService.exportSupplierManagement(parentId, response);
    }

    @ApiOperation("查询全部供方名录")
    @GetMapping("/selectSupplierManagementAll")
    public Result<List<SupplierManagement>> selectSupplierManagementAll() throws Exception {
        return Result.success(supplierManagementService.selectSupplierManagementAll());
    }

}

 cnas-require/src/main/java/com/ruoyi/require/dto/FeIlluminationAddDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
package com.ruoyi.require.dto;

import com.ruoyi.require.pojo.FeIllumination;
import com.ruoyi.require.pojo.FeIlluminationDetectionArea;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.List;

@Data
public class FeIlluminationAddDto extends FeIllumination {

    @ApiModelProperty("设施和环境条件要求-照度记录表-检测区域")
    private List<FeIlluminationDetectionArea> illuminationDetectionAreaList;
}

 cnas-require/src/main/java/com/ruoyi/require/dto/FeIlluminationDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
package com.ruoyi.require.dto;

import com.ruoyi.require.pojo.FeIllumination;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
public class FeIlluminationDto extends FeIllumination {
    @ApiModelProperty("检测者")
    private String checkerUser;

    @ApiModelProperty("核查人")
    private String testerUser;

    @ApiModelProperty("设备名称")
    private String deviceName;

    @ApiModelProperty("设备编号")
    private String managementNumber;

}

 cnas-require/src/main/java/com/ruoyi/require/dto/FeIlluminationExportDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,25 @@
package com.ruoyi.require.dto;

import com.ruoyi.require.pojo.FeIllumination;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

/**
 * @Author zhuo
 * @Date 2024/11/28
 */
@Data
public class FeIlluminationExportDto extends FeIllumination {

    @ApiModelProperty("设备名称")
    private String deviceName;

    @ApiModelProperty("设备编号")
    private String managementNumber;

    @ApiModelProperty("校准日期")
    private String calibrationDateString;

    @ApiModelProperty("下次校准日期")
    private String nextCalibrationDateString;
}

 cnas-require/src/main/java/com/ruoyi/require/dto/FePowerStableAddDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
package com.ruoyi.require.dto;

import com.ruoyi.require.pojo.FeMeasuredQuantity;
import com.ruoyi.require.pojo.FePowerStable;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.List;

@Data
public class FePowerStableAddDto extends FePowerStable {

    @ApiModelProperty("设施和环境条件要求-电源稳定性-测定量")
    private List<FeMeasuredQuantity> feMeasuredQuantityList;
}

 cnas-require/src/main/java/com/ruoyi/require/dto/FePowerStableDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,22 @@
package com.ruoyi.require.dto;

import com.ruoyi.require.pojo.FePowerStable;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
public class FePowerStableDto extends FePowerStable {

    @ApiModelProperty("检测者")
    private String checkerUser;

    @ApiModelProperty("核查人")
    private String testerUser;

    @ApiModelProperty("设备名称")
    private String deviceName;

    @ApiModelProperty("设备编号")
    private String managementNumber;

}

 cnas-require/src/main/java/com/ruoyi/require/dto/FePowerStableExportDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,30 @@
package com.ruoyi.require.dto;

import com.ruoyi.require.pojo.FePowerStable;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

/**
 * @Author zhuo
 * @Date 2024/11/28
 */
@Data
public class FePowerStableExportDto extends FePowerStable {

    @ApiModelProperty("测试日期")
    private String testDateString;

    @ApiModelProperty("设备名称")
    private String deviceName;

    @ApiModelProperty("设备编号")
    private String managementNumber;

    @ApiModelProperty("校准日期")
    private String calibrationDateString;

    @ApiModelProperty("下次校准日期")
    private String nextCalibrationDateString;


}

 cnas-require/src/main/java/com/ruoyi/require/dto/FeTempHumDateDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,12 @@
package com.ruoyi.require.dto;

import com.ruoyi.require.pojo.FeTempHumDate;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
public class FeTempHumDateDto extends FeTempHumDate {

    @ApiModelProperty("创建人")
    private String createName;
}

 cnas-require/src/main/java/com/ruoyi/require/dto/FeTempHumRecordDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,27 @@
package com.ruoyi.require.dto;

import com.ruoyi.require.pojo.FeTempHumRecord;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
public class FeTempHumRecordDto extends FeTempHumRecord {

    @ApiModelProperty("下午记录员名称")
    private String afternoonRecorderUser;

    @ApiModelProperty("上午记录员名称")
    private String morningRecorderUser;

    @ApiModelProperty("检测天")
    private Integer month;

    @ApiModelProperty("下午时间")
    private String afternoonTimeStr;

    @ApiModelProperty("上午-时间")
    private String morningTestTimeStr;

    @ApiModelProperty("检测天")
    private Integer monthDay;
}

 cnas-require/src/main/java/com/ruoyi/require/dto/ForeignRegisterDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,32 @@
package com.ruoyi.require.dto;

import com.deepoove.poi.data.PictureRenderData;
import com.ruoyi.require.pojo.ForeignRegister;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

/**
 * @Author zhuo
 * @Date 2024/11/19
 */
@Data
public class ForeignRegisterDto extends ForeignRegister {

    @ApiModelProperty("开始时间")
    private String beginDate;

    @ApiModelProperty("结束时间")
    private String endDate;

    @ApiModelProperty("陪同人员签名")
    private PictureRenderData accompanyingRender;

    @ApiModelProperty("批准人员签名")
    private PictureRenderData approveRender;

    @ApiModelProperty("陪同人员签名地址")
    private String accompanyingUrl;

    @ApiModelProperty("陪同人员签名地址")
    private String approveUrl;
}

 cnas-require/src/main/java/com/ruoyi/require/dto/InternalWastesDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,26 @@
package com.ruoyi.require.dto;

import com.ruoyi.require.pojo.InternalWastes;
import com.ruoyi.require.pojo.InternalWastesDetail;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.List;

/**
 * @Author zhuo
 * @Date 2024/11/19
 */
@Data
public class InternalWastesDto extends InternalWastes {

    @ApiModelProperty("三废登记详情")
    private List<InternalWastesDetail> wastesDetailList;

    @ApiModelProperty("创建人")
    private String createUserName;

    @ApiModelProperty("修改人")
    private String updateUserName;

}

 cnas-require/src/main/java/com/ruoyi/require/dto/ProcurementSuppliesListDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
package com.ruoyi.require.dto;

import com.alibaba.excel.annotation.ExcelProperty;
import com.ruoyi.require.pojo.ProcurementSuppliesList;
import lombok.Data;

@Data
public class ProcurementSuppliesListDto extends ProcurementSuppliesList {
    @ExcelProperty("参考供应商")
    private String supplierName; // ä¾›åº”商名称
    @ExcelProperty("更新人")
    private String updateUserName; // æ›´æ–°äººåç§°
    @ExcelProperty("负责人")
    private String personInChargeName; // è´Ÿè´£äººåç§°
}

 cnas-require/src/main/java/com/ruoyi/require/dto/SupplierManagementDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,67 @@
package com.ruoyi.require.dto;

import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
@ExcelIgnoreUnannotated
public class SupplierManagementDto {

    @ApiModelProperty("供应商")
    @ExcelProperty("供应商")
    private String supplierName;

    @ApiModelProperty("编号")
    @ExcelProperty("编号")
    private String supplierRef;

    @ApiModelProperty("供应商物品服务名称")
    @ExcelProperty("供应商物品服务名称")
    private String supplierItemServiceName;

    @ApiModelProperty("邮编")
    @ExcelProperty("邮编")
    private String postalCode;

    @ApiModelProperty("地址")
    @ExcelProperty("地址")
    private String adress;

    @ApiModelProperty("联系人")
    @ExcelProperty("联系人")
    private String contacts;

    @ApiModelProperty("联系电话")
    @ExcelProperty("联系电话")
    private String phone;

    @ApiModelProperty("户名")
    @ExcelProperty("户名")
    private String householdName;

    @ApiModelProperty("传真")
    @ExcelProperty("传真")
    private String fax;

    @ApiModelProperty("开户行")
    @ExcelProperty("开户行")
    private String openingName;

    @ApiModelProperty("网址")
    @ExcelProperty("网址")
    private String website;

    @ApiModelProperty("账号")
    @ExcelProperty("账号")
    private String accountName;

    @ApiModelProperty("email")
    @ExcelProperty("email")
    private String email;

    @ApiModelProperty("备注")
    @ExcelProperty("备注")
    private String remarks;
}

 cnas-require/src/main/java/com/ruoyi/require/mapper/FeIlluminationDetectionAreaMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,16 @@
package com.ruoyi.require.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.require.pojo.FeIlluminationDetectionArea;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-照度记录表-检测区域 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:28
 */
public interface FeIlluminationDetectionAreaMapper extends BaseMapper<FeIlluminationDetectionArea> {

}

 cnas-require/src/main/java/com/ruoyi/require/mapper/FeIlluminationMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,28 @@
package com.ruoyi.require.mapper;

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.require.dto.FeIlluminationDto;
import com.ruoyi.require.dto.FeIlluminationExportDto;
import com.ruoyi.require.pojo.FeIllumination;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-照度记录表 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:15:57
 */
public interface FeIlluminationMapper extends BaseMapper<FeIllumination> {

    IPage<FeIlluminationDto> getFeLightningProtection(Page page);

    /**
     * æŸ¥è¯¢ç…§æ˜Žè®°å½•
     * @param intensityIlluminationId
     * @return
     */
    FeIlluminationExportDto selectFeIllumination(Integer intensityIlluminationId);
}

 cnas-require/src/main/java/com/ruoyi/require/mapper/FeLightningProtectionMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
package com.ruoyi.require.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.require.excel.FeLightningProtectionExcel;
import com.ruoyi.require.pojo.FeLightningProtection;

import java.util.List;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-防雷检测 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:36
 */
public interface FeLightningProtectionMapper extends BaseMapper<FeLightningProtection> {

    List<FeLightningProtectionExcel> exportOfLightningProtectionDetection();

}

 cnas-require/src/main/java/com/ruoyi/require/mapper/FeMeasuredQuantityMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,16 @@
package com.ruoyi.require.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.require.pojo.FeMeasuredQuantity;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-电源稳定性-测定量 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:44
 */
public interface FeMeasuredQuantityMapper extends BaseMapper<FeMeasuredQuantity> {

}

 cnas-require/src/main/java/com/ruoyi/require/mapper/FePowerStableMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,34 @@
package com.ruoyi.require.mapper;

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.require.dto.FePowerStableDto;
import com.ruoyi.require.dto.FePowerStableExportDto;
import com.ruoyi.require.pojo.FePowerStable;
import org.apache.ibatis.annotations.Param;

import java.util.Map;
import java.util.Objects;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-电源稳定性 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:52
 */
public interface FePowerStableMapper extends BaseMapper<FePowerStable> {

    IPage<FePowerStableDto> getLaboratoryFacilityPowerStablePage(Page page);

    Map<String, Objects> getCalibrationDate(Integer deviceId);

    /**
     * æŸ¥è¯¢ç”µæºç¨³å®šæ€§
     * @param powerStableId
     * @return
     */
    FePowerStableExportDto selectPowerStable(@Param("powerStableId") Integer powerStableId);
}

 cnas-require/src/main/java/com/ruoyi/require/mapper/FeTempHumDateMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,30 @@
package com.ruoyi.require.mapper;

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.require.dto.FeTempHumDateDto;
import com.ruoyi.require.pojo.FeTempHumDate;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-温湿度 åŒºåŸŸ -父 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-09 11:02:18
 */
public interface FeTempHumDateMapper extends BaseMapper<FeTempHumDate> {

    IPage<FeTempHumDateDto> getFeTempHumDate(Page page, @Param("ew") QueryWrapper<FeTempHumDateDto> ew);

    /**
     * æŸ¥è¯¢è¿™ä¸ªæœˆæ˜¯å¦æœ‰è¯¥å®žéªŒå®¤çš„任务
     * @param laboratory å®žéªŒå®¤
     * @param formattedDate å½“前月份
     * @return è¿”回条数
     */
    int selectFeTempHumDateIncludeFormattedDate(@Param("laboratory") String laboratory, @Param("formattedDate") String formattedDate);
}

 cnas-require/src/main/java/com/ruoyi/require/mapper/FeTempHumRecordMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
package com.ruoyi.require.mapper;

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.require.dto.FeTempHumRecordDto;
import com.ruoyi.require.pojo.FeTempHumRecord;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-温湿度记录 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:28:52
 */
public interface FeTempHumRecordMapper extends BaseMapper<FeTempHumRecord> {

    IPage<FeTempHumRecordDto> getFeTempHumRecordPage(Page page, Integer dateId);
}

 cnas-require/src/main/java/com/ruoyi/require/mapper/ForeignRegisterMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,39 @@
package com.ruoyi.require.mapper;

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.require.dto.ForeignRegisterDto;
import com.ruoyi.require.pojo.ForeignRegister;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * å¤–来人员登记 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 07:17:35
 */
public interface ForeignRegisterMapper extends BaseMapper<ForeignRegister> {

    /**
     * å¤–来人员登记分页查询
     * @return
     */
    IPage<ForeignRegisterDto> pageForeignRegister(Page page, @Param("ew") QueryWrapper<ForeignRegisterDto> ew,
                                                  @Param("beginDate") String beginDate,
                                                  @Param("endDate") String endDate);

    /**
     * æŸ¥è¯¢å¤–来人员登记列表
     * @param foreignRegister
     * @return
     */
    List<ForeignRegisterDto> getForeignRegisterList(@Param("ew") QueryWrapper<ForeignRegisterDto> ew,
                                                    @Param("beginDate") String beginDate,
                                                    @Param("endDate") String endDate);
}

 cnas-require/src/main/java/com/ruoyi/require/mapper/InternalWastesDetailMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,16 @@
package com.ruoyi.require.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.require.pojo.InternalWastesDetail;

/**
 * <p>
 * å®‰å…¨å†…务三废登记详情 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 06:39:54
 */
public interface InternalWastesDetailMapper extends BaseMapper<InternalWastesDetail> {

}

 cnas-require/src/main/java/com/ruoyi/require/mapper/InternalWastesMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,31 @@
package com.ruoyi.require.mapper;

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.require.dto.InternalWastesDto;
import com.ruoyi.require.pojo.InternalWastes;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
 * å®‰å…¨å†…务三废登记 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 06:39:27
 */
@Mapper
public interface InternalWastesMapper extends BaseMapper<InternalWastes> {


    /**
     * å®‰å…¨å†…务三废登记分页查询
     * @param page
     * @param ew
     * @return
     */
    IPage<InternalWastesDto> pageInternalWastes(Page page, @Param("ew") QueryWrapper<InternalWastes> ew);
}

 cnas-require/src/main/java/com/ruoyi/require/mapper/ProcurementSuppliesContentsMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
package com.ruoyi.require.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.require.pojo.ProcurementSuppliesContents;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface ProcurementSuppliesContentsMapper extends BaseMapper<ProcurementSuppliesContents> {
}

 cnas-require/src/main/java/com/ruoyi/require/mapper/ProcurementSuppliesListMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,30 @@
package com.ruoyi.require.mapper;

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.require.dto.ProcurementSuppliesListDto;
import com.ruoyi.require.pojo.ProcurementSuppliesList;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * æœåŠ¡ä¸Žä¾›åº”商 è€—材列表 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-15 04:04:32
 */
@Mapper
public interface ProcurementSuppliesListMapper extends BaseMapper<ProcurementSuppliesList> {
    IPage<ProcurementSuppliesList> selectProcurementSuppliesList(Page page, @Param("ew") ProcurementSuppliesListDto ew);

    ProcurementSuppliesList selectProcurementSuppliesListForUpdate(@Param("id") Long id);

    List<ProcurementSuppliesList> selectProcurementSuppliesListAll(@Param("ew") ProcurementSuppliesListDto ew);

    List<ProcurementSuppliesList> selectProcurementSuppliesListByContentsId(@Param("id") Integer contentsId);
}

 cnas-require/src/main/java/com/ruoyi/require/mapper/SupplierManagementMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,31 @@
package com.ruoyi.require.mapper;

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.require.pojo.SupplierManagement;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 *  Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-15 02:46:45
 */
@Mapper
public interface SupplierManagementMapper extends BaseMapper<SupplierManagement> {

    IPage<SupplierManagement> pageSupplierManagement(Page page, @Param("ew") QueryWrapper<SupplierManagement> supplierManagementQueryWrapper);

    IPage<SupplierManagement> selectQualifiedSupplierManagement(Page page, @Param("ew") QueryWrapper<SupplierManagement> supplierManagementQueryWrapper);

    List<SupplierManagement> selectSupplierManagementAll(@Param("parentId") Integer parentId);

    List<SupplierManagement> selectSupplierManagement(@Param("parentId")Integer parentId);
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/FeIllumination.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,62 @@
package com.ruoyi.require.pojo;

import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import lombok.Setter;

import java.io.Serializable;
import java.time.LocalDate;
import java.time.LocalDateTime;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-照度记录表
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:15:57
 */
@Getter
@Setter
@TableName("cnas_fe_illumination")
@ApiModel(value = "FeIllumination对象", description = "设施和环境条件-设施和环境条件要求-照度记录表")
public class FeIllumination implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty("照度记录表id")
    @TableId(value = "intensity_illumination_id", type = IdType.AUTO)
    private Integer intensityIlluminationId;

    @ApiModelProperty("设备id")
    private Integer deviceId;

    @ApiModelProperty("结论")
    private String conclusion;

    @ApiModelProperty("检测人")
    private Integer testerId;

    @ApiModelProperty("核查人")
    private Integer checkerId;

    @ApiModelProperty("检测日期")
    private LocalDate testDate;

    @ApiModelProperty("校准日期")
    private LocalDateTime lastCalibrationDate;

    @ApiModelProperty("下次校准日期")
    private LocalDateTime nextCalibrationDate;

    @ApiModelProperty("创建时间")
    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

    @ApiModelProperty("更新时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;

}

 cnas-require/src/main/java/com/ruoyi/require/pojo/FeIlluminationDetectionArea.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,59 @@
package com.ruoyi.require.pojo;

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 io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import lombok.Setter;

import java.io.Serializable;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-照度记录表-检测区域
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:28
 */
@Getter
@Setter
@TableName("cnas_fe_illumination_detection_area")
@ApiModel(value = "FeIlluminationDetectionArea对象", description = "设施和环境条件-设施和环境条件要求-照度记录表-检测区域")
public class FeIlluminationDetectionArea implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty("检测区域id")
    @TableId(value = "detection_area_id", type = IdType.AUTO)
    private Integer detectionAreaId;

    @ApiModelProperty("检测区域名称")
    private String detectionAreaLabel;

    @ApiModelProperty("检测值-第一次")
    private Integer valueOne;

    @ApiModelProperty("检测值-第二次")
    private Integer valueTwo;

    @ApiModelProperty("检测值-第三次")
    private Integer valueThree;

    @ApiModelProperty("平均值")
    private Integer average;

    @ApiModelProperty("备注")
    private String remark;

    @ApiModelProperty("照度记录表id")
    private Integer intensityIlluminationId;

    // å¯¼å‡ºä½¿ç”¨
    @TableField(select = false, exist = false)
    @ApiModelProperty("序号(导出使用)")
    private Integer index;
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/FeLightningProtection.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,58 @@
package com.ruoyi.require.pojo;

import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import lombok.Setter;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.time.LocalDate;
import java.time.LocalDateTime;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-防雷检测
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:36
 */
@Getter
@Setter
@TableName("cnas_fe_lightning_protection")
@ApiModel(value = "FeLightningProtection对象", description = "设施和环境条件-设施和环境条件要求-防雷检测")
public class FeLightningProtection implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty("主键id")
    @TableId(value = "lightning_protection_id", type = IdType.AUTO)
    private Integer lightningProtectionId;

    @ApiModelProperty("原文件名")
    private String fileName;

    @ApiModelProperty("系统生成文件名")
    private String systemFileName;

    @ApiModelProperty("检测日期")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    private LocalDate detectionDate;

    @ApiModelProperty("有效期")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    private LocalDate termValidity;

    @ApiModelProperty("检测单位")
    private String detectionUnit;

    @ApiModelProperty("创建时间")
    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

    @ApiModelProperty("更新时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/FeMeasuredQuantity.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,54 @@
package com.ruoyi.require.pojo;

import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import lombok.Setter;

import java.io.Serializable;
import java.time.LocalDateTime;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-电源稳定性-测定量
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:44
 */
@Getter
@Setter
@TableName("cnas_fe_measured_quantity")
@ApiModel(value = "FeMeasuredQuantity对象", description = "设施和环境条件-设施和环境条件要求-电源稳定性-测定量")
public class FeMeasuredQuantity implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty("主键id")
    @TableId(value = "measured_quantity_id", type = IdType.AUTO)
    private Integer measuredQuantityId;

    @ApiModelProperty("测定量名称")
    private String measuredQuantityLabel;

    @ApiModelProperty("值A")
    private String valueA;

    @ApiModelProperty("值B")
    private String valueB;

    @ApiModelProperty("值C")
    private String valueC;

    @ApiModelProperty("创建时间")
    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

    @ApiModelProperty("更新时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;

    @ApiModelProperty("电源稳定性id")
    private Integer powerStableId;
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/FePowerStable.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,64 @@
package com.ruoyi.require.pojo;

import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import lombok.Setter;

import java.io.Serializable;
import java.time.LocalDate;
import java.time.LocalDateTime;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-电源稳定性
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:52
 */
@Getter
@Setter
@TableName("cnas_fe_power_stable")
@ApiModel(value = "FePowerStable对象", description = "设施和环境条件-设施和环境条件要求-电源稳定性")
public class FePowerStable implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty("电源稳定性id")
    @TableId(value = "power_stable_id", type = IdType.AUTO)
    private Integer powerStableId;

    @ApiModelProperty("测试地点")
    private String testLocation;

    @ApiModelProperty("测试日期")
    private LocalDate testDate;

    @ApiModelProperty("设备id")
    private Integer deviceId;

    @ApiModelProperty("结论")
    private String conclusion;

    @ApiModelProperty("检测者id")
    private Integer testerId;

    @ApiModelProperty("核查人id")
    private Integer checkerId;

    @ApiModelProperty("校准日期")
    private LocalDateTime lastCalibrationDate;

    @ApiModelProperty("下次校准日期")
    private LocalDateTime nextCalibrationDate;

    @ApiModelProperty("创建时间")
    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

    @ApiModelProperty("更新时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/FeTempHumDate.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,56 @@
package com.ruoyi.require.pojo;

import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import lombok.Setter;

import java.time.LocalDateTime;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-温湿度 åŒºåŸŸ -父
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-09 11:02:18
 */
@Getter
@Setter
@TableName("cnas_fe_temp_hum_date")
@ApiModel(value = "FeTempHumDate对象", description = "设施和环境条件-设施和环境条件要求-温湿度 åŒºåŸŸ -父")
public class FeTempHumDate {

    @ApiModelProperty("主键ID")
    @TableId(value = "date_id", type = IdType.AUTO)
    private Integer dateId;

    @ApiModelProperty("月度时间")
    private String monthDate;

    @ApiModelProperty("试验区域名称")
    private String testAreaName;

    @ApiModelProperty("增补信息")
    private String subjoin;

    @ApiModelProperty("是否确认")
    private String isAffirm;

    @ApiModelProperty("创建时间")
    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

    @ApiModelProperty("更新时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;

    @ApiModelProperty("创建人")
    @TableField(fill = FieldFill.INSERT)
    private Integer createUser;

    @ApiModelProperty("更新人")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Integer updateUser;
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/FeTempHumRecord.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,67 @@
package com.ruoyi.require.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import lombok.Setter;

import java.io.Serializable;
import java.time.LocalDate;
import java.time.LocalTime;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-温湿度记录
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:28:52
 */
@Getter
@Setter
@TableName("cnas_fe_temp_hum_record")
@ApiModel(value = "FeTempHumRecord对象", description = "设施和环境条件-设施和环境条件要求-温湿度记录")
public class FeTempHumRecord implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty("温湿度记录")
    @TableId(value = "temp_hum_id", type = IdType.AUTO)
    private Integer tempHumId;

    @ApiModelProperty("记录日期")
    private LocalDate recordDate;

    @ApiModelProperty("上午-时间")
    private LocalTime morningTestTime;

    @ApiModelProperty("上午温度")
    private String morningTemp;

    @ApiModelProperty("上午湿度")
    private String morningHum;

    @ApiModelProperty("上午记录员")
    private Integer morningRecorderId;

    @ApiModelProperty("下午时间")
    private LocalTime afternoonTime;

    @ApiModelProperty("下午温度")
    private String afternoonTemp;

    @ApiModelProperty("下午湿度")
    private String afternoonHum;

    @ApiModelProperty("下午记录员")
    private Integer afternoonRecorderId;

    @ApiModelProperty("备注")
    private String note;

    @ApiModelProperty("温度循环主表id")
    private Integer dateId;
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/ForeignRegister.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,72 @@
package com.ruoyi.require.pojo;

import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.time.LocalDate;
import java.time.LocalDateTime;

/**
 * <p>
 * å¤–来人员登记
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 07:17:35
 */
@Data
@TableName("cnas_foreign_register")
@ApiModel(value = "ForeignRegister对象", description = "外来人员登记")
public class ForeignRegister {

    @TableId(value = "register_id", type = IdType.AUTO)
    private Integer registerId;

    @ApiModelProperty("登记如期")
    private LocalDate registerDate;

    @ApiModelProperty("进入区域")
    private String area;

    @ApiModelProperty("进入人员")
    private String personnel;

    @ApiModelProperty("进入原因")
    private String reason;

    @ApiModelProperty("陪同人员id")
    private Integer accompanyingId;

    @ApiModelProperty("陪同人员")
    private String accompanyingName;

    @ApiModelProperty("批准人id")
    private Integer approveId;

    @ApiModelProperty("批准人")
    private String approveName;

    @ApiModelProperty("保密及其他情况")
    private String confidentiality;

    @ApiModelProperty("备注")
    private String remark;

    @ApiModelProperty("创建人")
    @TableField(fill = FieldFill.INSERT)
    private Integer createUser;

    @ApiModelProperty("创建时间")
    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

    @ApiModelProperty("修改人")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Integer updateUser;

    @ApiModelProperty("修改时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/InternalWastes.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,44 @@
package com.ruoyi.require.pojo;

import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.time.LocalDateTime;

/**
 * <p>
 * å®‰å…¨å†…务三废登记
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 06:39:27
 */
@Data
@TableName("cnas_internal_wastes")
@ApiModel(value = "InternalWastes对象", description = "安全内务三废登记")
public class InternalWastes {

    @TableId(value = "wastes_id", type = IdType.AUTO)
    private Integer wastesId;

    @ApiModelProperty("备注")
    private String remark;

    @ApiModelProperty("创建人")
    @TableField(fill = FieldFill.INSERT)
    private Integer createUser;

    @ApiModelProperty("创建时间")
    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

    @ApiModelProperty("修改人")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Integer updateUser;

    @ApiModelProperty("修改时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/InternalWastesDetail.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,66 @@
package com.ruoyi.require.pojo;

import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.time.LocalDateTime;

/**
 * <p>
 * å®‰å…¨å†…务三废登记详情
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 06:39:54
 */
@Data
@TableName("cnas_internal_wastes_detail")
@ApiModel(value = "InternalWastesDetail对象", description = "安全内务三废登记详情")
public class InternalWastesDetail {

    @TableId(value = "wastes_detail_id", type = IdType.AUTO)
    private Integer wastesDetailId;

    @ApiModelProperty("主表id")
    private Integer wastesId;

    @ApiModelProperty("名称")
    private String designation;

    @ApiModelProperty("体积")
    private String volume;

    @ApiModelProperty("送处理日期")
    private String deliveryDate;

    @ApiModelProperty("移交人")
    private String transferPeople;

    @ApiModelProperty("接收人")
    private String acceptor;

    @ApiModelProperty("接收单位")
    private String receivingUnit;

    @ApiModelProperty("创建人")
    @TableField(fill = FieldFill.INSERT)
    private Integer createUser;

    @ApiModelProperty("创建时间")
    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

    @ApiModelProperty("修改人")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Integer updateUser;

    @ApiModelProperty("修改时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;

    // å¯¼å‡ºä½¿ç”¨
    @TableField(select = false, exist = false)
    private Integer index;
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/ProcurementSuppliesContents.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,42 @@
package com.ruoyi.require.pojo;

import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.time.LocalDateTime;
import java.util.List;

@Data
@TableName("procurement_supplies_contents")
@ApiModel("服务和供应品采购表")
public class ProcurementSuppliesContents {

    @TableId(type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty("节点名称")
    private String nodeName;

    @ApiModelProperty("代号")
    private String code;


    @ApiModelProperty("更新人")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Integer updateUser;

    @ApiModelProperty("更新时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;

    @ApiModelProperty("父节点")
    private Integer parentId;

    @TableField(exist = false)
    private List<ProcurementSuppliesContents> children;



}

 cnas-require/src/main/java/com/ruoyi/require/pojo/ProcurementSuppliesList.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,101 @@
package com.ruoyi.require.pojo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import lombok.Setter;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 * <p>
 * æœåŠ¡ä¸Žä¾›åº”商 è€—材列表
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-15 04:04:32
 */
@Getter
@Setter
@TableName("procurement_supplies_list")
@ApiModel(value = "ProcurementSuppliesList对象", description = "服务与供应商 è€—材列表")
public class ProcurementSuppliesList implements Serializable {


    @TableId(value = "id", type = IdType.AUTO)
    @ApiModelProperty("编号")
    @ExcelProperty("编号")
    private Long id;

    @ApiModelProperty("目录id")
    private Long contentsId;

    @ApiModelProperty("耗材类型")
    @ExcelProperty("类别")
    private String consumablesType;

    @ApiModelProperty("货号")
    @ExcelProperty("货号")
    private String itemNumber;

    @ApiModelProperty("耗材名称")
    @ExcelProperty("名称")
    private String consumablesName;

    @ApiModelProperty("规格")
    @ExcelProperty("规格")
    private String specifications;

    @ApiModelProperty("计量单位")
    @ExcelProperty("计量单位")
    private String unit;

    @ApiModelProperty("参考价格")
    private BigDecimal referencePrice;

    @ApiModelProperty("存放位置")
    private Integer contentId;

    @ApiModelProperty("负责人")
    private Integer personInCharge;

    @ApiModelProperty("库存上限")
    private Integer upperLimit;

    @ApiModelProperty("库存下限")
    @ExcelProperty("库存下限")
    private Integer lowerLimit;

    @ApiModelProperty("供应商")
    private Integer supplier;

    @ApiModelProperty("耗材图标")
    private String consumablesIcon;

    @ApiModelProperty("耗材附件")
    private String attachment;

    @ApiModelProperty("备注")
    @ExcelProperty("备注")
    private String remark;

    @TableField(fill = FieldFill.INSERT)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime createTime;

    @TableField(fill = FieldFill.INSERT_UPDATE)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime updateTime;

    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Integer updateUser;

    @ApiModelProperty("当前库存数量")
    @ExcelProperty("当前库存")
    private Integer currentAmount;
}

 cnas-require/src/main/java/com/ruoyi/require/pojo/SupplierManagement.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,110 @@
package com.ruoyi.require.pojo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.*;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import lombok.Setter;
import java.io.Serializable;
import java.time.LocalDateTime;

/**
 * <p>
 * 
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-15 02:46:45
 */
@Getter
@Setter
@TableName("cnas_supplier_management")
@ApiModel(value = "SupplierManagement对象", description = "")
public class SupplierManagement implements Serializable {


    @ApiModelProperty("主表Id")
    @TableId(value = "supplier_management_id", type = IdType.AUTO)
    private Integer supplierManagementId;

    @ApiModelProperty("供应商")
    @ExcelProperty("供应商")
    private String supplierName;

    @ApiModelProperty("编号")
    @ExcelProperty("编号")
    private String supplierRef;

    @ApiModelProperty("供应商物品服务名称")
    @ExcelProperty("供应商物品服务名称")
    private String supplierItemServiceName;

    @ApiModelProperty("邮编")
    @ExcelProperty("邮编")
    private String postalCode;

    @ApiModelProperty("地址")
    @ExcelProperty("地址")
    private String adress;

    @ApiModelProperty("logo")
    private String logo;

    @ApiModelProperty("联系人")
    @ExcelProperty("联系人")
    private String contacts;

    @ApiModelProperty("联系电话")
    @ExcelProperty("联系电话")
    private String phone;

    @ApiModelProperty("户名")
    @ExcelProperty("户名")
    private String householdName;

    @ApiModelProperty("传真")
    @ExcelProperty("传真")
    private String fax;

    @ApiModelProperty("开户行")
    @ExcelProperty("开户行")
    private String openingName;

    @ApiModelProperty("网址")
    @ExcelProperty("网址")
    private String website;

    @ApiModelProperty("账号")
    @ExcelProperty("账号")
    private String accountName;

    @ApiModelProperty("email")
    @ExcelProperty("email")
    private String email;

    @ApiModelProperty("备注")
    @ExcelProperty("备注")
    private String remarks;

    @ApiModelProperty("附件")
    private String enclosure;

    @ApiModelProperty("状态")
    private String status;

    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createTime;

    @TableField(fill = FieldFill.INSERT)
    private Integer createUser;

    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;

    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Integer updateUser;

    @ApiModelProperty("父id")
    private Integer parentId;
}

 cnas-require/src/main/java/com/ruoyi/require/service/FeIlluminationDetectionAreaService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,16 @@
package com.ruoyi.require.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.require.pojo.FeIlluminationDetectionArea;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-照度记录表-检测区域 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:28
 */
public interface FeIlluminationDetectionAreaService extends IService<FeIlluminationDetectionArea> {

}

 cnas-require/src/main/java/com/ruoyi/require/service/FeIlluminationService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,29 @@
package com.ruoyi.require.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.require.dto.FeIlluminationDto;
import com.ruoyi.require.pojo.FeIllumination;

import javax.servlet.http.HttpServletResponse;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-照度记录表 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:15:57
 */
public interface FeIlluminationService extends IService<FeIllumination> {

    IPage<FeIlluminationDto> getFeLightningProtection(Page page);

    /**
     * å¯¼å‡ºç…§åº¦è®°å½•
     * @param intensityIlluminationId
     * @param response
     */
    void exportFeIllumination(Integer intensityIlluminationId, HttpServletResponse response);
}

 cnas-require/src/main/java/com/ruoyi/require/service/FeLightningProtectionService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
package com.ruoyi.require.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.require.excel.FeLightningProtectionExcel;
import com.ruoyi.require.pojo.FeLightningProtection;

import java.util.List;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-防雷检测 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:36
 */
public interface FeLightningProtectionService extends IService<FeLightningProtection> {

    List<FeLightningProtectionExcel> exportOfLightningProtectionDetection();

}

 cnas-require/src/main/java/com/ruoyi/require/service/FeMeasuredQuantityService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,16 @@
package com.ruoyi.require.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.require.pojo.FeMeasuredQuantity;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-电源稳定性-测定量 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:44
 */
public interface FeMeasuredQuantityService extends IService<FeMeasuredQuantity> {

}

 cnas-require/src/main/java/com/ruoyi/require/service/FePowerStableService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,33 @@
package com.ruoyi.require.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.require.dto.FePowerStableDto;
import com.ruoyi.require.pojo.FePowerStable;

import javax.servlet.http.HttpServletResponse;
import java.util.Map;
import java.util.Objects;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-电源稳定性 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:52
 */
public interface FePowerStableService extends IService<FePowerStable> {

    IPage<FePowerStableDto> getLaboratoryFacilityPowerStablePage(Page page);

    Map<String, Objects> getCalibrationDate(Integer deviceId);

    /**
     * å¯¼å‡ºç”µæºç¨³å®šæ€§
     * @param powerStableId
     * @param response
     */
    void exportFePowerStable(Integer powerStableId, HttpServletResponse response);
}

 cnas-require/src/main/java/com/ruoyi/require/service/FeTempHumDateService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,30 @@
package com.ruoyi.require.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.require.dto.FeTempHumDateDto;
import com.ruoyi.require.pojo.FeTempHumDate;

import javax.servlet.http.HttpServletResponse;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-温湿度 åŒºåŸŸ -父 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-09 11:02:18
 */
public interface FeTempHumDateService extends IService<FeTempHumDate> {

    IPage<FeTempHumDateDto> getFeTempHumDate(Page page, FeTempHumDateDto feTempHumDateDto);

    void exportTemperatureAndHumidityRecords(Integer dateId, HttpServletResponse response);

    /**
     * æ¸©æ¹¿åº¦ç¡®è®¤
     * @param feTempHumDate
     */
    void affirmFeTempHumDate(FeTempHumDate feTempHumDate);
}

 cnas-require/src/main/java/com/ruoyi/require/service/FeTempHumRecordService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
package com.ruoyi.require.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.require.dto.FeTempHumRecordDto;
import com.ruoyi.require.pojo.FeTempHumRecord;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-温湿度记录 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:28:52
 */
public interface FeTempHumRecordService extends IService<FeTempHumRecord> {

    IPage<FeTempHumRecordDto> getFeTempHumRecordPage(Page page, Integer dateId);
}

 cnas-require/src/main/java/com/ruoyi/require/service/ForeignRegisterService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,34 @@
package com.ruoyi.require.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.require.dto.ForeignRegisterDto;
import com.ruoyi.require.pojo.ForeignRegister;

import javax.servlet.http.HttpServletResponse;

/**
 * <p>
 * å¤–来人员登记 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 07:17:35
 */
public interface ForeignRegisterService extends IService<ForeignRegister> {

    /**
     * å¤–来人员登记分页查询
     * @param page
     * @param foreignRegister
     * @return
     */
    IPage<ForeignRegisterDto> pageForeignRegister(Page page, ForeignRegisterDto foreignRegister);

    /**
     * å¯¼å‡ºå¤–来人员登记
     * @param foreignRegister
     */
    void exportForeignRegister(ForeignRegisterDto foreignRegister, HttpServletResponse response);
}

 cnas-require/src/main/java/com/ruoyi/require/service/InternalWastesDetailService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,16 @@
package com.ruoyi.require.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.require.pojo.InternalWastesDetail;

/**
 * <p>
 * å®‰å…¨å†…务三废登记详情 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 06:39:54
 */
public interface InternalWastesDetailService extends IService<InternalWastesDetail> {

}

 cnas-require/src/main/java/com/ruoyi/require/service/InternalWastesService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.ruoyi.require.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.require.dto.InternalWastesDto;
import com.ruoyi.require.pojo.InternalWastes;

import javax.servlet.http.HttpServletResponse;

/**
 * <p>
 * å®‰å…¨å†…务三废登记 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 06:39:27
 */
public interface InternalWastesService extends IService<InternalWastes> {

    /**
     * å®‰å…¨å†…务三废处理分页查询
     * @param page
     * @param internalWastes
     * @return
     */
    IPage<InternalWastesDto> pageInternalWastes(Page page, InternalWastes internalWastes);

    /**
     * å®‰å…¨å†…务三废处理新增
     * @param internalWastes
     * @return
     */
    boolean addInternalWastes(InternalWastesDto internalWastes);

    /**
     * å®‰å…¨å†…务三废处理修改
     * @param internalWastes
     * @return
     */
    boolean updateInternalWastes(InternalWastesDto internalWastes);

    /**
     * å®‰å…¨å†…务三废处理删除
     * @param wastesId
     * @return
     */
    boolean delInternalWastes(Integer wastesId);

    /**
     * å®‰å…¨å†…务三废处理查看详情
     * @param wastesId
     * @return
     */
    InternalWastesDto getInternalWastesOne(Integer wastesId);

    /**
     * å¯¼å‡ºä¸‰åºŸå¤„理
     * @param wastesId
     * @param response
     */
    void exportInternalWastes(Integer wastesId, HttpServletResponse response);
}

 cnas-require/src/main/java/com/ruoyi/require/service/ProcurementSuppliesContentsService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,16 @@
package com.ruoyi.require.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.require.pojo.ProcurementSuppliesContents;

import java.util.List;
import java.util.Map;

public interface ProcurementSuppliesContentsService extends IService<ProcurementSuppliesContents> {

    List<ProcurementSuppliesContents> directoryListing();

    List<Map<String,Object>> getNodeNames();

    List<Map<String,Object>> getUserList();
}

 cnas-require/src/main/java/com/ruoyi/require/service/ProcurementSuppliesListService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,28 @@
package com.ruoyi.require.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.require.dto.ProcurementSuppliesListDto;
import com.ruoyi.require.pojo.ProcurementSuppliesList;

import javax.servlet.http.HttpServletResponse;

/**
 * <p>
 * æœåŠ¡ä¸Žä¾›åº”商 è€—材列表 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-15 04:04:32
 */
public interface ProcurementSuppliesListService extends IService<ProcurementSuppliesList> {
    IPage<ProcurementSuppliesListDto> selectList(Page page, ProcurementSuppliesListDto list);

    public Integer addProcurementSuppliesList(ProcurementSuppliesListDto dto);

    public Integer updateProcurementSuppliesList(ProcurementSuppliesListDto dto);

    void exportProcurementSuppliesList(Integer contentsId,HttpServletResponse response);

}

 cnas-require/src/main/java/com/ruoyi/require/service/SupplierManagementService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,32 @@
package com.ruoyi.require.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.require.pojo.SupplierManagement;

import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
 * <p>
 *  æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-15 02:46:45
 */
public interface SupplierManagementService extends IService<SupplierManagement> {

    List<SupplierManagement> selectSupplierManagement(SupplierManagement supplierManagement);

    void exportSupplierManagement(Integer parentId, HttpServletResponse response);

    IPage<SupplierManagement> selectQualifiedSupplierManagement(Page page, SupplierManagement supplierManagement);

    List<SupplierManagement> selectQualifiedSupplierManagementById(Integer supplierManagementId);

    List<SupplierManagement> selectSupplierManagementByParentId(Integer parentId);

    List<SupplierManagement> selectSupplierManagementAll();
}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/FeIlluminationDetectionAreaServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
package com.ruoyi.require.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.require.mapper.FeIlluminationDetectionAreaMapper;
import com.ruoyi.require.pojo.FeIlluminationDetectionArea;
import com.ruoyi.require.service.FeIlluminationDetectionAreaService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-照度记录表-检测区域 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:28
 */
@Service
public class FeIlluminationDetectionAreaServiceImpl extends ServiceImpl<FeIlluminationDetectionAreaMapper, FeIlluminationDetectionArea> implements FeIlluminationDetectionAreaService {

}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/FeIlluminationServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,123 @@
package com.ruoyi.require.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
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;
import com.deepoove.poi.data.Pictures;
import com.ruoyi.common.utils.DateImageUtil;
import com.ruoyi.framework.exception.ErrorException;
import com.ruoyi.inspect.util.HackLoopTableRenderPolicy;
import com.ruoyi.require.dto.FeIlluminationDto;
import com.ruoyi.require.dto.FeIlluminationExportDto;
import com.ruoyi.require.mapper.FeIlluminationDetectionAreaMapper;
import com.ruoyi.require.mapper.FeIlluminationMapper;
import com.ruoyi.require.pojo.FeIllumination;
import com.ruoyi.require.pojo.FeIlluminationDetectionArea;
import com.ruoyi.require.service.FeIlluminationService;
import com.ruoyi.system.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.time.LocalDateTime;
import java.util.HashMap;
import java.util.List;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-照度记录表 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:15:57
 */
@Service
public class FeIlluminationServiceImpl extends ServiceImpl<FeIlluminationMapper, FeIllumination> implements FeIlluminationService {

    @Resource
    private FeIlluminationDetectionAreaMapper feIlluminationDetectionAreaMapper;
    @Resource
    private UserMapper userMapper;

    @Value("${file.path}")
    private String imgUrl;


    @Override
    public IPage<FeIlluminationDto> getFeLightningProtection(Page page) {
        return baseMapper.getFeLightningProtection(page);
    }

    /**
     * å¯¼å‡ºç…§åº¦è®°å½•
     * @param intensityIlluminationId
     * @param response
     */
    @Override
    public void exportFeIllumination(Integer intensityIlluminationId, HttpServletResponse response) {
        FeIlluminationExportDto illuminationExportDto = baseMapper.selectFeIllumination(intensityIlluminationId);
        // æ£€æµ‹äºº
        String testerUrl = null;
        if (illuminationExportDto.getTesterId() != null) {
            testerUrl = userMapper.selectById(illuminationExportDto.getTesterId()).getSignatureUrl();
            if (StringUtils.isBlank(testerUrl)) {
                throw new ErrorException("找不到检测人的签名");
            }
        }

        // æ ¸æŸ¥äºº
        String checkerUrl = null;
        if (illuminationExportDto.getCheckerId() != null) {
            checkerUrl = userMapper.selectById(illuminationExportDto.getCheckerId()).getSignatureUrl();
            if (StringUtils.isBlank(checkerUrl)) {
                throw new ErrorException("找不到核查人的签名");
            }
        }

        // æŸ¥è¯¢è¯¦æƒ…
        List<FeIlluminationDetectionArea> feIlluminationDetectionAreas = feIlluminationDetectionAreaMapper.selectList(Wrappers.<FeIlluminationDetectionArea>lambdaQuery()
                .eq(FeIlluminationDetectionArea::getIntensityIlluminationId, intensityIlluminationId));

        // èŽ·å–路径
        InputStream inputStream = this.getClass().getResourceAsStream("/static/illumination.docx");
        Configure configure = Configure.builder()
                .bind("detectionAreaList", new HackLoopTableRenderPolicy())
                .build();
        String finalTesterUrl = testerUrl;
        String finalCheckerUrl = checkerUrl;

        // åˆ¤æ–­æ£€æµ‹æ—¥æœŸæ˜¯å¦ä¸ºç©º
        LocalDateTime finalLocalDateTime = illuminationExportDto.getTestDate() == null ? null : illuminationExportDto.getTestDate().atStartOfDay();
        XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render(
                new HashMap<String, Object>() {{
                    put("illumination", illuminationExportDto);
                    put("detectionAreaList", feIlluminationDetectionAreas);
                    put("testerUrl", StringUtils.isNotBlank(finalTesterUrl) ? Pictures.ofLocal(imgUrl + "/" + finalTesterUrl).create() : null);
                    put("checkerUrl", StringUtils.isNotBlank(finalCheckerUrl) ? Pictures.ofLocal(imgUrl + "/" + finalCheckerUrl).create() : null);
                    put("testDateUrl", finalLocalDateTime != null ?
                            Pictures.ofStream(DateImageUtil.createDateImage(finalLocalDateTime)).create() : null);
                }});
        try {
            response.setContentType("application/msword");
            String fileName = URLEncoder.encode(
                    "照明记录导出", "UTF-8");
            response.setHeader("Content-disposition",
                    "attachment;filename=" + fileName + ".docx");
            OutputStream os = response.getOutputStream();
            template.write(os);
            os.flush();
            os.close();
        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException("导出失败");
        }
    }
}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/FeLightningProtectionServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,27 @@
package com.ruoyi.require.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.require.excel.FeLightningProtectionExcel;
import com.ruoyi.require.mapper.FeLightningProtectionMapper;
import com.ruoyi.require.pojo.FeLightningProtection;
import com.ruoyi.require.service.FeLightningProtectionService;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-防雷检测 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:36
 */
@Service
public class FeLightningProtectionServiceImpl extends ServiceImpl<FeLightningProtectionMapper, FeLightningProtection> implements FeLightningProtectionService {

    @Override
    public List<FeLightningProtectionExcel> exportOfLightningProtectionDetection() {
        return baseMapper.exportOfLightningProtectionDetection();
    }
}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/FeMeasuredQuantityServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
package com.ruoyi.require.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.require.mapper.FeMeasuredQuantityMapper;
import com.ruoyi.require.pojo.FeMeasuredQuantity;
import com.ruoyi.require.service.FeMeasuredQuantityService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-电源稳定性-测定量 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:44
 */
@Service
public class FeMeasuredQuantityServiceImpl extends ServiceImpl<FeMeasuredQuantityMapper, FeMeasuredQuantity> implements FeMeasuredQuantityService {

}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/FePowerStableServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,123 @@
package com.ruoyi.require.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
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;
import com.deepoove.poi.data.Pictures;
import com.ruoyi.framework.exception.ErrorException;
import com.ruoyi.inspect.util.HackLoopTableRenderPolicy;
import com.ruoyi.require.dto.FePowerStableDto;
import com.ruoyi.require.dto.FePowerStableExportDto;
import com.ruoyi.require.mapper.FeMeasuredQuantityMapper;
import com.ruoyi.require.mapper.FePowerStableMapper;
import com.ruoyi.require.pojo.FeMeasuredQuantity;
import com.ruoyi.require.pojo.FePowerStable;
import com.ruoyi.require.service.FePowerStableService;
import com.ruoyi.system.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Objects;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-电源稳定性 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:16:52
 */
@Service
public class FePowerStableServiceImpl extends ServiceImpl<FePowerStableMapper, FePowerStable> implements FePowerStableService {

    @Resource
    private FeMeasuredQuantityMapper feMeasuredQuantityMapper;
    @Resource
    private UserMapper userMapper;

    @Value("${file.path}")
    private String imgUrl;

    @Override
    public IPage<FePowerStableDto> getLaboratoryFacilityPowerStablePage(Page page) {
        return baseMapper.getLaboratoryFacilityPowerStablePage(page);
    }

    @Override
    public Map<String, Objects> getCalibrationDate(Integer deviceId) {
        return baseMapper.getCalibrationDate(deviceId);
    }

    /**
     * å¯¼å‡ºç”µæºç¨³å®šæ€§
     * @param powerStableId
     * @param response
     */
    @Override
    public void exportFePowerStable(Integer powerStableId, HttpServletResponse response) {
        FePowerStableExportDto powerStable = baseMapper.selectPowerStable(powerStableId);

        // æ£€æµ‹äºº
        String testerUrl = null;
        if (powerStable.getTesterId() != null) {
            testerUrl = userMapper.selectById(powerStable.getTesterId()).getSignatureUrl();
            if (StringUtils.isBlank(testerUrl)) {
                throw new ErrorException("找不到检测人的签名");
            }
        }

        // æ ¸æŸ¥äºº
        String checkerUrl = null;
        if (powerStable.getCheckerId() != null) {
            checkerUrl = userMapper.selectById(powerStable.getCheckerId()).getSignatureUrl();
            if (StringUtils.isBlank(checkerUrl)) {
                throw new ErrorException("找不到核查人的签名");
            }
        }

        // æŸ¥è¯¢è¯¦æƒ…
        List<FeMeasuredQuantity> feMeasuredQuantities = feMeasuredQuantityMapper.selectList(Wrappers.<FeMeasuredQuantity>lambdaQuery()
                .eq(FeMeasuredQuantity::getPowerStableId, powerStableId));

        // èŽ·å–路径
        InputStream inputStream = this.getClass().getResourceAsStream("/static/power-stable.docx");
        Configure configure = Configure.builder()
                .bind("measuredQuantityList", new HackLoopTableRenderPolicy())
                .build();
        String finalTesterUrl = testerUrl;
        String finalCheckerUrl = checkerUrl;
        XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render(
                new HashMap<String, Object>() {{
                    put("stable", powerStable);
                    put("measuredQuantityList", feMeasuredQuantities);
                    put("testerUrl", StringUtils.isNotBlank(finalTesterUrl) ? Pictures.ofLocal(imgUrl + "/" + finalTesterUrl).create() : null);
                    put("checkerUrl", StringUtils.isNotBlank(finalCheckerUrl) ? Pictures.ofLocal(imgUrl + "/" + finalCheckerUrl).create() : null);
                }});
        try {
            response.setContentType("application/msword");
            String fileName = URLEncoder.encode(
                    "电源稳定性测试导出", "UTF-8");
            response.setHeader("Content-disposition",
                    "attachment;filename=" + fileName + ".docx");
            OutputStream os = response.getOutputStream();
            template.write(os);
            os.flush();
            os.close();
        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException("导出失败");
        }
    }
}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/FeTempHumDateServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,141 @@
package com.ruoyi.require.service.impl;

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;
import com.ruoyi.common.utils.QueryWrappers;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.inspect.util.HackLoopTableRenderPolicy;
import com.ruoyi.require.dto.FeTempHumDateDto;
import com.ruoyi.require.dto.FeTempHumRecordDto;
import com.ruoyi.require.mapper.FeTempHumDateMapper;
import com.ruoyi.require.pojo.FeTempHumDate;
import com.ruoyi.require.pojo.FeTempHumRecord;
import com.ruoyi.require.service.FeTempHumDateService;
import com.ruoyi.require.service.FeTempHumRecordService;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-温湿度 åŒºåŸŸ -父 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-09 11:02:18
 */
@Service
public class FeTempHumDateServiceImpl extends ServiceImpl<FeTempHumDateMapper, FeTempHumDate> implements FeTempHumDateService {

    @Resource
    private FeTempHumRecordService feTempHumRecordService;

    @Override
    public IPage<FeTempHumDateDto> getFeTempHumDate(Page page, FeTempHumDateDto feTempHumDateDto) {
        return baseMapper.getFeTempHumDate(page, QueryWrappers.queryWrappers(feTempHumDateDto));
    }

    @Override
    public void exportTemperatureAndHumidityRecords(Integer dateId, HttpServletResponse response) {
        FeTempHumDate feTempHumDate = baseMapper.selectById(dateId);
        // èŽ·å–年度月度时间
        String[] month = feTempHumDate.getMonthDate().split("-");

        IPage<FeTempHumRecordDto> list = feTempHumRecordService.getFeTempHumRecordPage(new Page<>(1, -1), dateId);
        List<FeTempHumRecordDto> feTempHumRecordDtos = list.getRecords();
        // æŒ‰ç…§å¤©æ•°åˆ†ç»„
        Map<Integer, List<FeTempHumRecordDto>> groupMap = feTempHumRecordDtos.stream().peek(feTempHumRecordDto -> {
                    feTempHumRecordDto.setMonthDay(feTempHumRecordDto.getRecordDate().getDayOfMonth());
                })
                .collect(Collectors.groupingBy(FeTempHumRecordDto::getMonthDay));

        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("HH:mm");
        // éåŽ†31获取31个对象
        List<FeTempHumRecordDto> recordDtoList = new ArrayList<>();
        for (int i = 1; i <= 31; i++) {
            FeTempHumRecordDto recordDto = new FeTempHumRecordDto();
            recordDto.setMonth(i);
            recordDtoList.add(recordDto);
            // èŽ·å–当前月的
            List<FeTempHumRecordDto> recordDtos = groupMap.get(i);
            if (CollectionUtils.isNotEmpty(recordDtos)) {
                // å¤åˆ¶å¯¹è±¡
                BeanUtils.copyProperties(recordDtos.get(0), recordDto, "month");
                recordDto.setMorningTestTimeStr(recordDto.getMorningTestTime() == null ? null : recordDto.getMorningTestTime().format(formatter));
                recordDto.setAfternoonTimeStr(recordDto.getAfternoonTime() == null ? null : recordDto.getAfternoonTime().format(formatter));
            }

        }

        // èŽ·å–路径
        InputStream inputStream = this.getClass().getResourceAsStream("/static/temp_hum_date.docx");
        Configure configure = Configure.builder()
                .bind("recordList", new HackLoopTableRenderPolicy())
                .build();

        HashMap<String, Object> map = new HashMap<>();
        map.put("testAreaName", feTempHumDate.getTestAreaName());
        map.put("experimentalYear", month[0]);
        map.put("experimentalMonth", month[1]);
        map.put("subjoin", feTempHumDate.getSubjoin());

        XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render(
                new HashMap<String, Object>() {{
                    put("feTempHum", map);
                    put("recordList", recordDtoList);
                }});

        try {
            response.setContentType("application/msword");
            String fileName = URLEncoder.encode(
                    "温湿度记录导出", "UTF-8");
            response.setHeader("Content-disposition",
                    "attachment;filename=" + fileName + ".docx");
            OutputStream os = response.getOutputStream();
            template.write(os);
            os.flush();
            os.close();
        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException("导出失败");
        }
    }

    /**
     * æ¸©æ¹¿åº¦ç¡®è®¤
     * @param feTempHumDate
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public void affirmFeTempHumDate(FeTempHumDate feTempHumDate) {
        // æ¸©æ¹¿åº¦ç¡®è®¤
        this.update(Wrappers.<FeTempHumDate>lambdaUpdate()
                .eq(FeTempHumDate::getDateId, feTempHumDate.getDateId())
                .set(FeTempHumDate::getSubjoin, feTempHumDate.getSubjoin())
                .set(FeTempHumDate::getIsAffirm, 1));

        // æ¸©æ¹¿åº¦è®°å½•æ·»åŠ è®°å½•å‘˜
        Integer userId = SecurityUtils.getUserId().intValue();
        feTempHumRecordService.update(Wrappers.<FeTempHumRecord>lambdaUpdate()
                .eq(FeTempHumRecord::getDateId, feTempHumDate.getDateId())
                .set(FeTempHumRecord::getAfternoonRecorderId, userId)
                .set(FeTempHumRecord::getMorningRecorderId, userId));
    }
}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/FeTempHumRecordServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,27 @@
package com.ruoyi.require.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.require.dto.FeTempHumRecordDto;
import com.ruoyi.require.mapper.FeTempHumRecordMapper;
import com.ruoyi.require.pojo.FeTempHumRecord;
import com.ruoyi.require.service.FeTempHumRecordService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * è®¾æ–½å’ŒçŽ¯å¢ƒæ¡ä»¶-设施和环境条件要求-温湿度记录 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-07 04:28:52
 */
@Service
public class FeTempHumRecordServiceImpl extends ServiceImpl<FeTempHumRecordMapper, FeTempHumRecord> implements FeTempHumRecordService {

    @Override
    public IPage<FeTempHumRecordDto> getFeTempHumRecordPage(Page page, Integer dateId) {
        return baseMapper.getFeTempHumRecordPage(page, dateId);
    }
}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/ForeignRegisterServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,101 @@
package com.ruoyi.require.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
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;
import com.deepoove.poi.data.Pictures;
import com.ruoyi.common.utils.QueryWrappers;
import com.ruoyi.inspect.util.HackLoopTableRenderPolicy;
import com.ruoyi.require.dto.ForeignRegisterDto;
import com.ruoyi.require.mapper.ForeignRegisterMapper;
import com.ruoyi.require.pojo.ForeignRegister;
import com.ruoyi.require.service.ForeignRegisterService;
import com.ruoyi.system.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.List;

/**
 * <p>
 * å¤–来人员登记 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 07:17:35
 */
@Service
public class ForeignRegisterServiceImpl extends ServiceImpl<ForeignRegisterMapper, ForeignRegister> implements ForeignRegisterService {
    @Resource
    private UserMapper userMapper;
    @Value("${file.path}")
    private String imgUrl;

    /**
     * å¤–来人员登记分页查询
     * @param page
     * @param foreignRegister
     * @return
     */
    @Override
    public IPage<ForeignRegisterDto> pageForeignRegister(Page page, ForeignRegisterDto foreignRegister) {
        String beginDate = foreignRegister.getBeginDate();
        String endDate = foreignRegister.getEndDate();
        foreignRegister.setBeginDate(null);
        foreignRegister.setEndDate(null);
        return baseMapper.pageForeignRegister(page, QueryWrappers.queryWrappers(foreignRegister), beginDate, endDate);
    }

    /**
     * å¯¼å‡ºå¤–来人员登记
     * @param foreignRegister
     */
    @Override
    public void exportForeignRegister(ForeignRegisterDto foreignRegister, HttpServletResponse response) {
        String beginDate = foreignRegister.getBeginDate();
        String endDate = foreignRegister.getEndDate();
        foreignRegister.setBeginDate(null);
        foreignRegister.setEndDate(null);
        List<ForeignRegisterDto> register = baseMapper.getForeignRegisterList(QueryWrappers.queryWrappers(foreignRegister), beginDate, endDate);

        for (ForeignRegisterDto foreignRegisterDto : register) {
            // æ·»åŠ ååŒäººå’Œæ‰¹å‡†äººç­¾å
            foreignRegisterDto.setAccompanyingRender(StringUtils.isNotBlank(foreignRegisterDto.getAccompanyingUrl())
                    ? Pictures.ofLocal(imgUrl + "/" + foreignRegisterDto.getAccompanyingUrl()).create() : null);
            foreignRegisterDto.setApproveRender(StringUtils.isNotBlank(foreignRegisterDto.getApproveUrl())
                    ? Pictures.ofLocal(imgUrl + "/" + foreignRegisterDto.getApproveUrl()).create() : null);
        }
        // èŽ·å–路径
        InputStream inputStream = this.getClass().getResourceAsStream("/static/foreign-register.docx");
        Configure configure = Configure.builder()
                .bind("register", new HackLoopTableRenderPolicy())
                .build();
        XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render(
                new HashMap<String, Object>() {{
                    put("register", register);
                }});
        try {
            response.setContentType("application/msword");
            String fileName = URLEncoder.encode(
                    "外来人员登记", "UTF-8");
            response.setHeader("Content-disposition",
                    "attachment;filename=" + fileName + ".docx");
            OutputStream os = response.getOutputStream();
            template.write(os);
            os.flush();
            os.close();
        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException("导出失败");
        }
    }
}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/InternalWastesDetailServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
package com.ruoyi.require.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.require.mapper.InternalWastesDetailMapper;
import com.ruoyi.require.pojo.InternalWastesDetail;
import com.ruoyi.require.service.InternalWastesDetailService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * å®‰å…¨å†…务三废登记详情 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 06:39:54
 */
@Service
public class InternalWastesDetailServiceImpl extends ServiceImpl<InternalWastesDetailMapper, InternalWastesDetail> implements InternalWastesDetailService {

}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/InternalWastesServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,170 @@
package com.ruoyi.require.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
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;
import com.ruoyi.common.utils.QueryWrappers;
import com.ruoyi.inspect.util.HackLoopTableRenderPolicy;
import com.ruoyi.require.dto.InternalWastesDto;
import com.ruoyi.require.mapper.InternalWastesMapper;
import com.ruoyi.require.pojo.InternalWastes;
import com.ruoyi.require.pojo.InternalWastesDetail;
import com.ruoyi.require.service.InternalWastesDetailService;
import com.ruoyi.require.service.InternalWastesService;
import lombok.AllArgsConstructor;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.servlet.http.HttpServletResponse;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.List;

/**
 * <p>
 * å®‰å…¨å†…务三废登记 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-19 06:39:27
 */
@Service
@AllArgsConstructor
@Transactional(rollbackFor = Exception.class)
public class InternalWastesServiceImpl extends ServiceImpl<InternalWastesMapper, InternalWastes> implements InternalWastesService {

    private InternalWastesDetailService internalWastesDetailService;

    /**
     * å®‰å…¨å†…务三废登记分页查询
     * @param page
     * @param internalWastes
     * @return
     */
    @Override
    public IPage<InternalWastesDto> pageInternalWastes(Page page, InternalWastes internalWastes) {
        return baseMapper.pageInternalWastes(page, QueryWrappers.queryWrappers(internalWastes));
    }

    /**
     * å®‰å…¨å†…务三废登记新增
     * @param internalWastes
     * @return
     */
    @Override
    public boolean addInternalWastes(InternalWastesDto internalWastes) {

        baseMapper.insert(internalWastes);
        // æ–°å¢žè¯¦æƒ…
        for (InternalWastesDetail internalWastesDetail : internalWastes.getWastesDetailList()) {
            internalWastesDetail.setWastesId(internalWastes.getWastesId());
        }
        internalWastesDetailService.saveBatch(internalWastes.getWastesDetailList());
        return true;
    }

    /**
     * å®‰å…¨å†…务三废登记修改
     * @param internalWastes
     * @return
     */
    @Override
    public boolean updateInternalWastes(InternalWastesDto internalWastes) {
        baseMapper.updateById(internalWastes);

        // åˆ é™¤ä¹‹å‰çš„详情
        internalWastesDetailService.remove(Wrappers.<InternalWastesDetail>lambdaQuery()
                .eq(InternalWastesDetail::getWastesId, internalWastes.getWastesId()));

        // æ–°å¢žè¯¦æƒ…
        for (InternalWastesDetail internalWastesDetail : internalWastes.getWastesDetailList()) {
            internalWastesDetail.setWastesId(internalWastes.getWastesId());
        }
        internalWastesDetailService.saveBatch(internalWastes.getWastesDetailList());

        return true;
    }

    /**
     * å®‰å…¨å†…务三废登记删除
     * @param WastesId
     * @return
     */
    @Override
    public boolean delInternalWastes(Integer WastesId) {
        internalWastesDetailService.remove(Wrappers.<InternalWastesDetail>lambdaQuery()
                .eq(InternalWastesDetail::getWastesId, WastesId));
        baseMapper.deleteById(WastesId);
        return true;
    }

    /**
     * å®‰å…¨å†…务三废登记查看详情
     * @param WastesId
     * @return
     */
    @Override
    public InternalWastesDto getInternalWastesOne(Integer WastesId) {
        InternalWastes internalWastes = baseMapper.selectById(WastesId);
        InternalWastesDto internalWastesDto = new InternalWastesDto();
        BeanUtils.copyProperties(internalWastes, internalWastesDto);

        // æŸ¥è¯¢è¯¦ç»†ä¿¡æ¯
        internalWastesDto.setWastesDetailList(internalWastesDetailService.list(Wrappers.<InternalWastesDetail>lambdaQuery()
                .eq(InternalWastesDetail::getWastesId, WastesId)));
        return internalWastesDto;
    }

    /**
     * å¯¼å‡ºä¸‰åºŸå¤„理
     * @param wastesId
     * @param response
     */
    @Override
    public void exportInternalWastes(Integer wastesId, HttpServletResponse response) {
        InternalWastes internalWastes = baseMapper.selectById(wastesId);

        List<InternalWastesDetail> wastesDetailList = internalWastesDetailService.list(Wrappers.<InternalWastesDetail>lambdaQuery()
                .eq(InternalWastesDetail::getWastesId, wastesId));

        int index = 1;
        for (InternalWastesDetail detail : wastesDetailList) {
            detail.setIndex(index);
            index++;
        }


        // èŽ·å–路径
        InputStream inputStream = this.getClass().getResourceAsStream("/static/internal-wastes.docx");
        Configure configure = Configure.builder()
                .bind("wastesDetailList", new HackLoopTableRenderPolicy())
                .build();
        XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render(
                new HashMap<String, Object>() {{
                    put("remark", internalWastes.getRemark());
                    put("wastesDetailList", wastesDetailList);
                }});

        try {
            response.setContentType("application/msword");
            String fileName = URLEncoder.encode(
                    "安全内务三废处理", "UTF-8");
            response.setHeader("Content-disposition",
                    "attachment;filename=" + fileName + ".docx");
            OutputStream os = response.getOutputStream();
            template.write(os);
            os.flush();
            os.close();
        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException("导出失败");
        }

    }
}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/ProcurementSuppliesContentsServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,91 @@
package com.ruoyi.require.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.core.domain.entity.User;
import com.ruoyi.require.mapper.ProcurementSuppliesContentsMapper;
import com.ruoyi.require.pojo.ProcurementSuppliesContents;
import com.ruoyi.require.service.ProcurementSuppliesContentsService;
import com.ruoyi.system.mapper.UserMapper;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

@Service
@AllArgsConstructor
public class ProcurementSuppliesContentsServiceImpl extends ServiceImpl<ProcurementSuppliesContentsMapper, ProcurementSuppliesContents>
        implements ProcurementSuppliesContentsService {

    private UserMapper userMapper;

    @Override
    public List<ProcurementSuppliesContents> directoryListing() {
        ArrayList<ProcurementSuppliesContents> list = new ArrayList<>();
        // æŸ¥å‡ºä¸€çº§ç›®å½•
        List<ProcurementSuppliesContents> firstLevel = baseMapper.selectList(new LambdaQueryWrapper<ProcurementSuppliesContents>()
                .isNull(ProcurementSuppliesContents::getParentId));

        // æŸ¥å‡ºå«æœ‰çˆ¶èŠ‚点的 å¹¶é€šè¿‡çˆ¶èŠ‚点分组
        List<ProcurementSuppliesContents> seconds = baseMapper.selectList(new LambdaQueryWrapper<ProcurementSuppliesContents>()
                .isNotNull(ProcurementSuppliesContents::getParentId));
        if(firstLevel.size() > 0){
            Map<Integer, List<ProcurementSuppliesContents>> collect = seconds.stream()
                    .collect(Collectors.groupingBy(ProcurementSuppliesContents::getParentId));
            // æ ¹æ®åˆ†ç»„çš„key èµ‹å€¼å¯¹åº”çš„children
            for (int i = 0; i < firstLevel.size(); i++) {
                recursion(firstLevel.get(i),collect);
                list.add(firstLevel.get(i));
            }
        }
        return list;
    }

    // é€’归赋值children
    public ProcurementSuppliesContents recursion(ProcurementSuppliesContents firstLevel, Map<Integer, List<ProcurementSuppliesContents>> collect) {
        // å°†çˆ¶èŠ‚点的children赋值
        if(collect.containsKey(firstLevel.getId())) {
            List<ProcurementSuppliesContents> procurementSupplies = collect.get(firstLevel.getId());
            firstLevel.setChildren(procurementSupplies);
            for (int i = 0; i < procurementSupplies.size(); i++) {
                recursion(procurementSupplies.get(i),collect);
            }
        }
        return firstLevel;
    }

    @Override
    public List<Map<String, Object>> getNodeNames() {
        List<ProcurementSuppliesContents> procurementSuppliesContents = baseMapper.selectList(null);
        List<Map<String, Object>> collect = new ArrayList<>();
        if(procurementSuppliesContents.size() > 0) {
            collect = procurementSuppliesContents.stream().map(item -> {
                HashMap<String, Object> map = new HashMap<>();
                map.put("id", item.getId());
                map.put("nodeName", item.getNodeName());
                return map;
            }).collect(Collectors.toList());
        }
        return collect;
    }

    @Override
    public List<Map<String, Object>> getUserList() {
        // 1 åœç”¨
        List<User> users = userMapper.selectList(new LambdaQueryWrapper<User>().eq(User::getStatus, 0));
        List<Map<String, Object>> collect = new ArrayList<>();
        if(users.size() > 0) {
            collect = users.stream().map(item -> {
                HashMap<String, Object> map = new HashMap<>();
                map.put("id", item.getId());
                map.put("nodeName", item.getName());
                return map;
            }).collect(Collectors.toList());
        }
        return collect;
    }
}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/ProcurementSuppliesListServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,130 @@
package com.ruoyi.require.service.impl;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.core.domain.entity.User;
import com.ruoyi.inspect.dto.ProcurementSuppliesListEDto;
import com.ruoyi.require.dto.ProcurementSuppliesListDto;
import com.ruoyi.require.mapper.ProcurementSuppliesListMapper;
import com.ruoyi.require.mapper.SupplierManagementMapper;
import com.ruoyi.require.pojo.ProcurementSuppliesList;
import com.ruoyi.require.pojo.SupplierManagement;
import com.ruoyi.require.service.ProcurementSuppliesListService;
import com.ruoyi.system.mapper.UserMapper;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.List;

/**
 * <p>
 * æœåŠ¡ä¸Žä¾›åº”商 è€—材列表 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-15 04:04:32
 */
@Service
public class ProcurementSuppliesListServiceImpl extends ServiceImpl<ProcurementSuppliesListMapper, ProcurementSuppliesList> implements ProcurementSuppliesListService {
    @Autowired
    private UserMapper userMapper;

    @Autowired
    private SupplierManagementMapper supplierManagementMapper;

    @Autowired
    private ProcurementSuppliesListMapper procurementSuppliesListMapper;

    @Override
    public IPage<ProcurementSuppliesListDto> selectList(Page page, ProcurementSuppliesListDto list) {
        IPage<ProcurementSuppliesList> iPage = baseMapper.selectProcurementSuppliesList(page, list);
        IPage<ProcurementSuppliesListDto> result = new Page<>();
        List<ProcurementSuppliesListDto> dtos = new ArrayList<>();
        BeanUtils.copyProperties(iPage, result);
        for (int i = 0; i < iPage.getRecords().size(); i++) {
            ProcurementSuppliesList record = iPage.getRecords().get(i);
            ProcurementSuppliesListDto dto = new ProcurementSuppliesListDto();
            BeanUtils.copyProperties(record, dto);
            if (record.getPersonInCharge() != 0) {
                User user = userMapper.selectById(record.getPersonInCharge());
                dto.setPersonInChargeName(user.getName());
            }
            if (record.getUpdateUser() != 0) {
                User updateUser = userMapper.selectById(record.getUpdateUser());
                dto.setUpdateUserName(updateUser.getName());
            }

            if (record.getSupplier() != 0) {
                SupplierManagement supplierManagement = supplierManagementMapper.selectById(record.getSupplier());
                dto.setSupplierName(supplierManagement.getSupplierName());
            }

            dtos.add(dto);
        }
        result.setRecords(dtos);

        return result;
    }

    @Override
    public Integer addProcurementSuppliesList(ProcurementSuppliesListDto dto) {
        ProcurementSuppliesList list = new ProcurementSuppliesList();
        BeanUtils.copyProperties(dto, list);
        return baseMapper.insert(list);
    }

    @Override
    public Integer updateProcurementSuppliesList(ProcurementSuppliesListDto dto) {
        ProcurementSuppliesList list = new ProcurementSuppliesList();
        BeanUtils.copyProperties(dto, list);
        return baseMapper.updateById(list);
    }

    @Override
    public void exportProcurementSuppliesList(Integer contentsId,HttpServletResponse response) {
//        List<ProcurementSuppliesList> data = this.list(new QueryWrapper<ProcurementSuppliesList>().lambda()
//                .select(ProcurementSuppliesList::getId
//                        , ProcurementSuppliesList::getUnit
//                        , ProcurementSuppliesList::getLowerLimit
//                        , ProcurementSuppliesList::getConsumablesType
//                        , ProcurementSuppliesList::getItemNumber
//                        , ProcurementSuppliesList::getConsumablesName
//                        , ProcurementSuppliesList::getSpecifications
//                        , ProcurementSuppliesList::getCurrentAmount
//                        , ProcurementSuppliesList::getRemark).eq(ProcurementSuppliesList::getContentsId, contentsId));
        List<ProcurementSuppliesList> data = procurementSuppliesListMapper.selectProcurementSuppliesListByContentsId(contentsId);
        if (data.size()==0) {
            throw new RuntimeException("无数据");
        }
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("UTF-8");
        // è¿™é‡ŒURLEncoder.encode可以防止中文乱码 å½“然和easyexcel没有关系
        try {
            String fileName = URLEncoder.encode("耗材列表", "UTF-8");
            response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
            // æ–°å»ºExcelWriter
            ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).build();
            WriteSheet writeSheet = EasyExcel.writerSheet(0, "耗材列表").head(ProcurementSuppliesListEDto.class).build();
            excelWriter.write(data, writeSheet);
            // å…³é—­æµ
            excelWriter.finish();
        } catch (UnsupportedEncodingException e) {
            e.printStackTrace();
            throw new RuntimeException("导出失败");
        } catch (IOException e) {
            e.printStackTrace();
            throw new RuntimeException("导出失败");
        }
    }
}

 cnas-require/src/main/java/com/ruoyi/require/service/impl/SupplierManagementServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,91 @@
package com.ruoyi.require.service.impl;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.utils.QueryWrappers;
import com.ruoyi.require.dto.SupplierManagementDto;
import com.ruoyi.require.mapper.SupplierManagementMapper;
import com.ruoyi.require.pojo.SupplierManagement;
import com.ruoyi.require.service.SupplierManagementService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.List;

/**
 * <p>
 * æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2024-11-15 02:46:45
 */
@Service
public class SupplierManagementServiceImpl extends ServiceImpl<SupplierManagementMapper, SupplierManagement> implements SupplierManagementService {

    @Autowired
    private SupplierManagementMapper supplierManagementMapper;

    public SupplierManagementServiceImpl(SupplierManagementMapper supplierManagementMapper) {
        this.supplierManagementMapper = supplierManagementMapper;
    }

    @Override
    public List<SupplierManagement> selectSupplierManagement(SupplierManagement supplierManagement) {
        return this.list();
    }

    @Override
    public void exportSupplierManagement(Integer parentId, HttpServletResponse response) {
        List<SupplierManagement> data = supplierManagementMapper.selectSupplierManagementAll(parentId);
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("UTF-8");
        // è¿™é‡ŒURLEncoder.encode可以防止中文乱码 å½“然和easyexcel没有关系
        try {
            String fileName = URLEncoder.encode("供应商管理", "UTF-8");
            response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
            // æ–°å»ºExcelWriter
            ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).build();
            WriteSheet writeSheet = EasyExcel.writerSheet(0, "供应商管理").head(SupplierManagementDto.class).build();
            excelWriter.write(data, writeSheet);
            // å…³é—­æµ
            excelWriter.finish();
        } catch (UnsupportedEncodingException e) {
            e.printStackTrace();
            throw new RuntimeException("导出失败");
        } catch (IOException e) {
            e.printStackTrace();
            throw new RuntimeException("导出失败");
        }
    }

    @Override
    public IPage<SupplierManagement> selectQualifiedSupplierManagement(Page page, SupplierManagement supplierManagement) {
        return baseMapper.selectQualifiedSupplierManagement(page, QueryWrappers.queryWrappers(supplierManagement));
    }

    @Override
    public List<SupplierManagement> selectQualifiedSupplierManagementById(Integer supplierManagementId) {
        return this.list(new QueryWrapper<SupplierManagement>().lambda().eq(SupplierManagement::getSupplierManagementId , supplierManagementId));
    }

    @Override
    public List<SupplierManagement> selectSupplierManagementByParentId(Integer parentId) {
        return supplierManagementMapper.selectSupplierManagement(parentId);
    }

    @Override
    public List<SupplierManagement> selectSupplierManagementAll() {
        return supplierManagementMapper.selectList(null);
    }
}

 cnas-require/src/main/resources/mapper/ProcurementSuppliesListMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,71 @@
<?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.require.mapper.ProcurementSuppliesListMapper">

    <!-- é€šç”¨æŸ¥è¯¢æ˜ å°„结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.require.pojo.ProcurementSuppliesList">
        <id column="id" property="id" />
        <result column="contents_id" property="contentsId" />
        <result column="consumables_type" property="consumablesType" />
        <result column="item_number" property="itemNumber" />
        <result column="consumables_name" property="consumablesName" />
        <result column="specifications" property="specifications" />
        <result column="unit" property="unit" />
        <result column="reference_price" property="referencePrice" />
        <result column="content_id" property="contentId" />
        <result column="person_in_charge" property="personInCharge" />
        <result column="upper_limit" property="upperLimit" />
        <result column="lower_limit" property="lowerLimit" />
        <result column="supplier" property="supplier" />
        <result column="consumables_icon" property="consumablesIcon" />
        <result column="attachment" property="attachment" />
        <result column="remark" property="remark" />
        <result column="create_time" property="createTime" />
        <result column="update_time" property="updateTime" />
        <result column="update_user" property="updateUser" />
        <result column="current_amount" property="currentAmount" />
    </resultMap>

    <select id="selectProcurementSuppliesList" resultMap="BaseResultMap">
        select * from procurement_supplies_list
        <where>
            <if test="ew.contentId != null and ew.contentId != ''">
                and content_id = ${ew.contentId}
            </if>
        </where>
    </select>

    <select id="selectProcurementSuppliesListForUpdate" resultMap="BaseResultMap">
        select * from procurement_supplies_list where id = ${id} for update
    </select>

    <select id="selectProcurementSuppliesListAll" resultMap="BaseResultMap">
        select
            contents_id,item_number, consumables_type, consumables_name, specifications, supplier, upper_limit,
        lower_limit, unit, remark, person_in_charge, update_user, update_time
        from procurement_supplies_list
        <where>
            <if test="ew.contentId != null and ew.contentId != ''">
                and content_id = ${ew.contentId}
            </if>
        </where>
    </select>
    <select id="selectProcurementSuppliesListByContentsId"
            resultType="com.ruoyi.require.pojo.ProcurementSuppliesList">
        select id,
               item_number,
               consumables_type,
               consumables_name,
               specifications,
               lower_limit,
               unit,
               remark
        from procurement_supplies_list
        where contents_id = ${id}
           or contents_id in
              (SELECT id
               FROM `procurement_supplies_contents`
               WHERE id = ${id}
                  OR parent_id = ${id})
    </select>
</mapper>

 cnas-require/src/main/resources/mapper/SupplierManagementMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,81 @@
<?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.require.mapper.SupplierManagementMapper">

    <!-- é€šç”¨æŸ¥è¯¢æ˜ å°„结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.require.pojo.SupplierManagement">
        <id column="supplier_management_id" property="supplierManagementId" />
        <result column="supplier_name" property="supplierName" />
        <result column="supplier_ref" property="supplierRef" />
        <result column="supplier_item_service_name" property="supplierItemServiceName" />
        <result column="postal_code" property="postalCode" />
        <result column="adress" property="adress" />
        <result column="logo" property="logo" />
        <result column="contacts" property="contacts" />
        <result column="phone" property="phone" />
        <result column="household_name" property="householdName" />
        <result column="fax" property="fax" />
        <result column="opening_name" property="openingName" />
        <result column="website" property="website" />
        <result column="account_name" property="accountName" />
        <result column="email" property="email" />
        <result column="remarks" property="remarks" />
        <result column="enclosure" property="enclosure" />
        <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="status" property="status" />
        <result column="parent_id" property="parentId" />
    </resultMap>
    <select id="pageSupplierManagement" resultType="com.ruoyi.require.pojo.SupplierManagement">
        select *
        from (select *
        from cnas_supplier_management
        order by create_time desc
        ) a
        <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''">
            ${ew.customSqlSegment}
        </if>
    </select>

    <select id="selectQualifiedSupplierManagement" resultType="com.ruoyi.require.pojo.SupplierManagement">
        select *
        from (select *
        from cnas_supplier_management
        where status = 0
        order by create_time desc
        ) a
        <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''">
            ${ew.customSqlSegment}
        </if>
    </select>
    <select id="selectSupplierManagementAll" resultType="com.ruoyi.require.pojo.SupplierManagement">
        SELECT
            csm.supplier_name,
            csm.supplier_ref,
            csm.supplier_item_service_name,
            csm.postal_code,
            csm.adress,
            csm.contacts,
            csm.phone,
            csm.household_name,
            csm.fax,
            csm.opening_name,
            csm.website,
            csm.account_name,
            csm.email
        FROM
            cnas_supplier_management csm
        where csm.parent_id in (select id from procurement_supplies_contents where id = #{parentId} or parent_id = #{parentId})
    </select>
    <select id="selectSupplierManagement" resultType="com.ruoyi.require.pojo.SupplierManagement">
        select
            *
        from cnas_supplier_management csm
        where
            csm.parent_id = #{parentId} or
            csm.parent_id in
        (select id from procurement_supplies_contents where id = #{parentId} or parent_id = #{parentId})
    </select>
</mapper>

 inspect-server/src/main/java/com/ruoyi/inspect/dto/ProcurementSuppliesListEDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,54 @@
package com.ruoyi.inspect.dto;

import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
public class ProcurementSuppliesListEDto {

    @TableId(value = "id", type = IdType.AUTO)
    @ApiModelProperty("编号")
    @ExcelProperty("编号")
    private Long id;

    @ApiModelProperty("耗材类型")
    @ExcelProperty("类别")
    private String consumablesType;

    @ApiModelProperty("货号")
    @ExcelProperty("货号")
    private String itemNumber;

    @ApiModelProperty("耗材名称")
    @ExcelProperty("名称")
    private String consumablesName;

    @ApiModelProperty("规格")
    @ExcelProperty("规格")
    private String specifications;

    @ApiModelProperty("计量单位")
    @ExcelProperty("计量单位")
    private String unit;




    @ApiModelProperty("库存下限")
    @ExcelProperty("库存下限")
    private Integer lowerLimit;



    @ApiModelProperty("备注")
    @ExcelProperty("备注")
    private String remark;


    @ApiModelProperty("当前库存数量")
    @ExcelProperty("当前库存")
    private Integer currentAmount;
}