lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/dto/DailyResponsibleInfo.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,24 @@ package org.jeecg.modules.eam.dto; import lombok.Data; import lombok.experimental.Accessors; @Data @Accessors(chain = true) public class DailyResponsibleInfo { /** æä½åå§åæ°ç» (1-31æ¥) */ private String[] operators = new String[31]; /** 确认人å§åæ°ç» (1-31æ¥) */ private String[] confirmUsers = new String[31]; /** * 设置æå¤©çè´£ä»»äººä¿¡æ¯ */ public void setResponsibleForDay(int day, String operator, String confirmUser) { if (day >= 1 && day <= 31) { operators[day - 1] = operator; confirmUsers[day - 1] = confirmUser; } } } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/dto/EamInspectionOrderDetailExport.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,60 @@ package org.jeecg.modules.eam.dto; import com.baomidou.mybatisplus.annotation.TableName; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.experimental.Accessors; import org.jeecg.common.aspect.annotation.Dict; import org.jeecg.common.system.base.entity.JeecgEntity; import org.jeecg.modules.eam.entity.EamMaintenanceStandardDetail; import org.jeecgframework.poi.excel.annotation.Excel; import java.io.Serializable; /** * @Description: ç¹æ£å·¥åæç» * @Author: jeecg-boot * @Date: 2025-04-02 * @Version: V1.0 */ @Data @Accessors(chain = true) @EqualsAndHashCode(callSuper = false) public class EamInspectionOrderDetailExport extends JeecgEntity implements Serializable { private static final long serialVersionUID = 1L; /**å·¥åID*/ @Excel(name = "å·¥åID", width = 15) @ApiModelProperty(value = "å·¥åID") private String orderId; /**ç¹æ£ç»æ*/ @Excel(name = "ç¹æ£ç»æ", width = 15) @ApiModelProperty(value = "ç¹æ£ç»æ-æ£å¸¸-å¼å¸¸-æ é-å ³æº") private String inspectionResult; /**å¼å¸¸æè¿°*/ @Excel(name = "å¼å¸¸æè¿°", width = 15) @ApiModelProperty(value = "å¼å¸¸æè¿°") private String exceptionDescription; /**ä¿å »é¡¹åºå·*/ @ApiModelProperty(value = "ä¿å »é¡¹åºå·") private Integer itemCode; /**ä¿å »é¡¹*/ @ApiModelProperty(value = "ä¿å »é¡¹") private String itemName; /**ä¿å »è¦æ±*/ @ApiModelProperty(value = "ä¿å »è¦æ±") private String itemDemand; /** * 1-31æ¥ææ å¿ */ private String[] dateFlag; /** * 1-5卿 å¿ */ private String[] weekFlag; } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/dto/EamInspectionOrderExport.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,71 @@ package org.jeecg.modules.eam.dto; import com.baomidou.mybatisplus.annotation.*; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.experimental.Accessors; import org.jeecg.common.aspect.annotation.Dict; import org.jeecg.common.system.base.entity.JeecgEntity; import org.jeecgframework.poi.excel.annotation.Excel; import org.springframework.format.annotation.DateTimeFormat; import java.io.Serializable; import java.util.Date; import java.util.List; /** * @Description: ç¹æ£å·¥åæ¹éå¯¼åº */ @Data @Accessors(chain = true) @EqualsAndHashCode(callSuper = false) public class EamInspectionOrderExport { @ApiModelProperty(value = "设å¤åç§°") private String equipmentName; @ApiModelProperty(value = "设å¤åå·") private String equipmentModel; @ApiModelProperty(value = "设å¤ç¼å·") private String equipmentCode; @ApiModelProperty(value = "åä½") @Dict(dictTable = "eam_base_factory",dicText = "factory_name",dicCode = "org_code") private String factoryName; @ApiModelProperty(value = "å¹´") private String inspectionYear; @ApiModelProperty(value = "æ") private String inspectionMonth; @ApiModelProperty(value = "hfç¼ç ") private String hfCode; /** * æ¥ç¹æ£å表 */ @ApiModelProperty(value = "æ¥ç¹æ£å表") @TableField(exist = false) private List<EamInspectionOrderDetailExport> eamDailyInspectionList; /** * å¨ç¹æ£å表 */ @ApiModelProperty(value = "å¨ç¹æ£å表") @TableField(exist = false) private List<EamInspectionOrderDetailExport> eamWeeklyInspectionList; /**æ¥ç¹æ£è´£ä»»äººä¿¡æ¯ (1-31æ¥) */ @ApiModelProperty(value = "æ¥ç¹æ£è´£ä»»äººä¿¡æ¯") private DailyResponsibleInfo dailyResponsibleInfo; /**å¨ç¹æ£è´£ä»»äººä¿¡æ¯ (1-5å¨) */ @ApiModelProperty(value = "å¨ç¹æ£è´£ä»»äººä¿¡æ¯") private WeeklyResponsibleInfo weeklyResponsibleInfo; } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/dto/EamReportAccidentsRegisterDto.java
@@ -333,4 +333,6 @@ @TableField(exist = false) @ApiModelProperty(value = "åºåä»·å¼") private String scrapPartValue; /**ç产åä½*/ private String factoryName; } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/dto/EamReportProductHazardsDto.java
@@ -10,6 +10,7 @@ import lombok.Data; import lombok.EqualsAndHashCode; import lombok.experimental.Accessors; import org.jeecg.common.aspect.annotation.Dict; import org.jeecg.modules.flowable.domain.vo.FlowTaskVo; import org.jeecgframework.poi.excel.annotation.Excel; import org.springframework.format.annotation.DateTimeFormat; @@ -64,6 +65,7 @@ /**æä½å·¥*/ @Excel(name = "æä½å·¥", width = 15) @ApiModelProperty(value = "æä½å·¥") @Dict(dictTable = "sys_user", dicCode = "username", dicText = "realname") private String confirmer; /**æä½å·¥ç¡®è®¤æ¶é´*/ @Excel(name = "æä½å·¥ç¡®è®¤æ¶é´", width = 15, format = "yyyy-MM-dd") @@ -74,6 +76,7 @@ /**产åæå¤±æ åµ*/ @Excel(name = "产åæå¤±æ åµ", width = 15) @ApiModelProperty(value = "产åæå¤±æ åµ") @Dict(dicCode = "yn") private String productLoss; /**产åæå¤±è´¨éå½±ååæ*/ @Excel(name = "产åæå¤±è´¨éå½±ååæ", width = 15) @@ -82,6 +85,7 @@ /**主管工èº*/ @Excel(name = "主管工èº", width = 15) @ApiModelProperty(value = "主管工èº") @Dict(dictTable = "sys_user", dicCode = "username", dicText = "realname") private String technologist; /**主管工èºç¡®è®¤æ¶é´*/ @Excel(name = "主管工èºç¡®è®¤æ¶é´", width = 15, format = "yyyy-MM-dd") @@ -100,6 +104,7 @@ /**é¨çº§é¢å¯¼*/ @Excel(name = "é¨çº§é¢å¯¼", width = 15) @ApiModelProperty(value = "é¨çº§é¢å¯¼") @Dict(dictTable = "sys_user", dicCode = "username", dicText = "realname") private String deputyDepartment; /**é¨çº§é¢å¯¼ç¡®è®¤æ¶é´*/ @Excel(name = "é¨çº§é¢å¯¼ç¡®è®¤æ¶é´", width = 15, format = "yyyy-MM-dd") @@ -124,5 +129,14 @@ private String equipmentModel; @TableField(exist = false) private String installationPosition; /**ç产åä½*/ private String factoryName; /**æ éç°è±¡*/ private String faultDescription; /**æ¹æ¬¡å·*/ private String batchNumber; /**å å·¥é¶ä»¶å·*/ private String processingPart; /**ä»¶æ°*/ private String quantity; } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/dto/EamThirdMaintenanceOrderExport.java
@@ -259,12 +259,6 @@ private String maintenanceDateFormatted; //使ç¨åä½ private String factoryName; /** * å¤ä»¶æç» */ @ApiModelProperty(value = "å¤ä»¶ä½¿ç¨æç»") @DictList private List<EamThirdMaintenanceSpare> eamThirdMaintenanceSpareList; /** * å表 ä¿å »é¡¹æç» lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/dto/EamThirdMaintenanceOrderExportYj.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,268 @@ package org.jeecg.modules.eam.dto; import com.baomidou.mybatisplus.annotation.FieldStrategy; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.experimental.Accessors; import org.jeecg.common.aspect.annotation.Dict; import org.jeecg.common.aspect.annotation.DictList; import org.jeecg.modules.eam.entity.EamThirdMaintenanceOrderDetail; import org.jeecg.modules.eam.entity.EamThirdMaintenanceSpare; import org.jeecgframework.poi.excel.annotation.Excel; import org.springframework.format.annotation.DateTimeFormat; import java.util.Date; import java.util.List; /** * @Description: 设å¤ä¸çº§ä¿å » * @Author: jeecg-boot * @Date: 2025-04-29 * @Version: V1.0 */ @Data @EqualsAndHashCode(callSuper = false) @Accessors(chain = true) public class EamThirdMaintenanceOrderExportYj { /** * ID */ @TableId(type = IdType.ASSIGN_ID) @ApiModelProperty(value = "ID") private String id; /** * å 餿 è®° */ @ApiModelProperty(value = "å 餿 è®°") private Integer delFlag; /** * å·¥åå· */ @Excel(name = "å·¥åå·", width = 15) @ApiModelProperty(value = "å·¥åå·") private String orderNum; /** * 设å¤ID */ @Excel(name = "设å¤ID", width = 15) @ApiModelProperty(value = "设å¤ID") private String equipmentId; /** * æ åID */ @Excel(name = "æ åID", width = 15) @ApiModelProperty(value = "æ åID") @Dict(dictTable = "eam_maintenance_standard", dicCode = "id", dicText = "standard_name") private String standardId; /** * 计åä¿å »æ¥æ */ @ApiModelProperty(value = "计åä¿å »æ¥æ;æå70天çæå·¥å") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") @TableField(updateStrategy = FieldStrategy.IGNORED) private String maintenanceDate; /** * éå®å·¥åæ¥æ */ @ApiModelProperty(value = "éå®å·¥åæ¥æ;æå55天éå®å·¥å") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") private Date freezeOrderDate; /** * å·¥åè¿ææ¥æ */ @ApiModelProperty(value = "å·¥åè¿ææ¥æ;å°ææªåç´æ¥è¿æ") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") private Date orderExpirationDate; /** * å®é å¼å§æ¶é´ */ @Excel(name = "å®é å¼å§æ¶é´", width = 20, format = "yyyy-MM-dd HH:mm:ss") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") @ApiModelProperty(value = "å®é å¼å§æ¶é´") private Date actualStartTime; /** * å®é ç»ææ¶é´ */ @Excel(name = "å®é ç»ææ¶é´", width = 20, format = "yyyy-MM-dd HH:mm:ss") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") @ApiModelProperty(value = "å®é ç»ææ¶é´") private Date actualEndTime; /** * 维修人 */ @Excel(name = "维修人", width = 15) @ApiModelProperty(value = "维修人") @Dict(dictTable = "sys_user", dicCode = "username", dicText = "realname") private String repairman; /** * ä¿å »ç¶æ */ @Excel(name = "ä¿å »ç¶æ", width = 15) @ApiModelProperty(value = "ä¿å »ç¶æ;å¾ ä¿å »ãä¿å »ä¸ãå¾ æ£æ¥ãæä½äººç¾åã维修人ç¾åã维修室主任ç¾åãè®¾å¤æ£æ¥äººç¾åã已宿ãå·²éå®ãåæ´ä¸ã已忶") @Dict(dicCode = "third_maintenance_status") private String maintenanceStatus; /** * å建æ¹å¼ */ @Excel(name = "å建æ¹å¼", width = 15) @ApiModelProperty(value = "å建æ¹å¼") @Dict(dicCode = "order_creation_method") private String creationMethod; /** * 设å¤åè½æ¯å¦é½å¤;æ¯å¦ */ @Excel(name = "设å¤åè½æ¯å¦é½å¤;æ¯å¦", width = 15) @ApiModelProperty(value = "设å¤åè½æ¯å¦é½å¤;æ¯å¦") @Dict(dicCode = "yn") private String fullyFunctional; /** * 设å¤åè½æ¯å¦é½å¤;æ¯å¦ */ @Excel(name = "设å¤è½å¦æ£å¸¸è¿è½¬;æ¯å¦", width = 15) @ApiModelProperty(value = "设å¤åè½æ¯å¦é½å¤;æ¯å¦") @Dict(dicCode = "yn") private String runningNormally; /** * é®é¢æè¿° */ @Excel(name = "é®é¢æè¿°", width = 30) @ApiModelProperty(value = "é®é¢æè¿°") private String problemDescription; /** * æ£æ¥äºº */ @Excel(name = "æ£æ¥äºº", width = 15) @ApiModelProperty(value = "æ£æ¥äºº") @Dict(dictTable = "sys_user", dicCode = "username", dicText = "realname") private String inspector; /** * æ£æ¥æ¶é´ */ @ApiModelProperty(value = "æ£æ¥æ¶é´") @Excel(name = "æ£æ¥æ¶é´", width = 20, format = "yyyy-MM-dd HH:mm:ss") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date inspectTime; /** * æä½äººç¾å */ @Excel(name = "æä½äººç¾å", width = 15) @ApiModelProperty(value = "æä½äººç¾å") @Dict(dictTable = "sys_user", dicCode = "username", dicText = "realname") private String operatorSignature; /** * å婿ä½äºº */ @Excel(name = "å婿ä½äºº", width = 15) @ApiModelProperty(value = "å婿ä½äºº") private String assistantOperator; /** * æä½äººç¾åæ¶é´ */ @ApiModelProperty(value = "æä½äººç¾åæ¶é´") @Excel(name = "æä½äººç¾åæ¶é´", width = 20, format = "yyyy-MM-dd HH:mm:ss") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date operatorSignatureTime; /** * 维修人ç¾å */ @Excel(name = "维修人ç¾å", width = 15) @ApiModelProperty(value = "维修人ç¾å") @Dict(dictTable = "sys_user", dicCode = "username", dicText = "realname") private String repairmanSignature; /** * åå©ç»´ä¿®äºº */ @Excel(name = "åå©ç»´ä¿®äºº", width = 15) @ApiModelProperty(value = "åå©ç»´ä¿®äºº") private String assistantRepairman; /** * 维修人ç¾åæ¶é´ */ @ApiModelProperty(value = "维修人ç¾åæ¶é´") @Excel(name = "维修人ç¾åæ¶é´", width = 20, format = "yyyy-MM-dd HH:mm:ss") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date repairmanSignatureTime; /** * 维修室主任ç¾å */ @Excel(name = "维修室主任ç¾å", width = 15) @ApiModelProperty(value = "维修室主任ç¾å") @Dict(dictTable = "sys_user", dicCode = "username", dicText = "realname") private String repairManagerSignature; /** * 维修室主任ç¾åæ¶é´ */ @ApiModelProperty(value = "维修室主任ç¾åæ¶é´") @Excel(name = "维修室主任ç¾åæ¶é´", width = 20, format = "yyyy-MM-dd HH:mm:ss") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date repairManagerSignatureTime; /** * è®¾å¤æ£æ¥äººç¾å */ @Excel(name = "è®¾å¤æ£æ¥äººç¾å", width = 15) @ApiModelProperty(value = "è®¾å¤æ£æ¥äººç¾å") @Dict(dictTable = "sys_user", dicCode = "username", dicText = "realname") private String inspectorSignature; /** * è®¾å¤æ£æ¥äººç¾åæ¶é´ */ @ApiModelProperty(value = "è®¾å¤æ£æ¥äººç¾åæ¶é´") @Excel(name = "è®¾å¤æ£æ¥äººç¾åæ¶é´", width = 20, format = "yyyy-MM-dd HH:mm:ss") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date inspectorSignatureTime; /** * 夿³¨ */ @Excel(name = "夿³¨", width = 15) @ApiModelProperty(value = "夿³¨") private String remark; /** * 移交åHFç¼ç */ @Excel(name = "移交åHFç¼ç ", width = 15) @ApiModelProperty(value = "移交åHFç¼ç ") private String hfCodeA; /** * éªæ¶åHFç¼ç */ @Excel(name = "éªæ¶åHFç¼ç ", width = 15) @ApiModelProperty(value = "éªæ¶åHFç¼ç ") private String hfCodeB; //å表å±ç¤º @TableField(exist = false) private String equipmentCode; @TableField(exist = false) private String equipmentName; //åå· @TableField(exist = false) private String equipmentModel; @ApiModelProperty(value = "设å¤ç±»å«") @Dict(dicCode = "equipment_category") private String equipmentCategory; //ä¿å »æ¥æ private String maintenanceDateFormatted; //使ç¨åä½ private String factoryName; /** * å¤ä»¶æç» */ @ApiModelProperty(value = "å¤ä»¶ä½¿ç¨æç»") @DictList private List<EamThirdMaintenanceSpare> eamThirdMaintenanceSpareList; } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/dto/WeeklyResponsibleInfo.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,24 @@ package org.jeecg.modules.eam.dto; import lombok.Data; import lombok.experimental.Accessors; @Data @Accessors(chain = true) public class WeeklyResponsibleInfo { /** æä½åå§åæ°ç» (1-5å¨) */ private String[] operators = new String[5]; /** 确认人å§åæ°ç» (1-5å¨) */ private String[] confirmUsers = new String[5]; /** * 设置æå¨çè´£ä»»äººä¿¡æ¯ */ public void setResponsibleForWeek(int week, String operator, String confirmUser) { if (week >= 1 && week <= 5) { operators[week - 1] = operator; confirmUsers[week - 1] = confirmUser; } } } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/entity/EamInspectionOrder.java
@@ -122,4 +122,17 @@ @Excel(name = "HFç¼ç ", width = 15) @ApiModelProperty(value = "HFç¼ç ") private String hfCode; //æµè½¬èç¹ä½¿ç¨æ¥è¯¢ @TableField(exist = false) private String procInstId; /**æµç¨å®ä¹key ä¸ä¸ªkey伿å¤ä¸ªçæ¬çid*/ @TableField(exist = false) private String processDefinitionKey; /**æµç¨å®ä¹id ä¸ä¸ªæµç¨å®ä¹å¯ä¸*/ @TableField(exist = false) private String processDefinitionId; /**æµç¨ä¸å¡å®ä¾id ä¸ä¸ªæµç¨ä¸å¡å¯ä¸ï¼æ¬è¡¨ä¸ä¹å¯ä¸*/ @TableField(exist = false) private String processInstanceId; } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/entity/EamSecondMaintenanceOrder.java
@@ -187,4 +187,14 @@ //æµè½¬èç¹ä½¿ç¨æ¥è¯¢ @TableField(exist = false) private String procInstId; /**æµç¨å®ä¹key ä¸ä¸ªkey伿å¤ä¸ªçæ¬çid*/ @TableField(exist = false) private String processDefinitionKey; /**æµç¨å®ä¹id ä¸ä¸ªæµç¨å®ä¹å¯ä¸*/ @TableField(exist = false) private String processDefinitionId; /**æµç¨ä¸å¡å®ä¾id ä¸ä¸ªæµç¨ä¸å¡å¯ä¸ï¼æ¬è¡¨ä¸ä¹å¯ä¸*/ @TableField(exist = false) private String processInstanceId; } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/entity/EamThirdMaintenanceOrder.java
@@ -247,4 +247,16 @@ private String equipmentName; @TableField(exist = false) private String equipmentModel; //æµè½¬èç¹ä½¿ç¨æ¥è¯¢ @TableField(exist = false) private String procInstId; /**æµç¨å®ä¹key ä¸ä¸ªkey伿å¤ä¸ªçæ¬çid*/ @TableField(exist = false) private String processDefinitionKey; /**æµç¨å®ä¹id ä¸ä¸ªæµç¨å®ä¹å¯ä¸*/ @TableField(exist = false) private String processDefinitionId; /**æµç¨ä¸å¡å®ä¾id ä¸ä¸ªæµç¨ä¸å¡å¯ä¸ï¼æ¬è¡¨ä¸ä¹å¯ä¸*/ @TableField(exist = false) private String processInstanceId; } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/mapper/EamReportAccidentsRegisterMapper.java
@@ -6,6 +6,8 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.Constants; import org.apache.ibatis.annotations.Param; import org.jeecg.modules.eam.dto.EamReportAccidentsRegisterDto; import org.jeecg.modules.eam.dto.EamThirdMaintenanceOrderExport; import org.jeecg.modules.eam.entity.EamReportAccidentsRegister; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.jeecg.modules.eam.request.EamReportAccidentsRegisterQuery; @@ -19,4 +21,10 @@ public interface EamReportAccidentsRegisterMapper extends BaseMapper<EamReportAccidentsRegister> { IPage<EamReportAccidentsRegisterQuery> queryPageList(IPage<EamReportAccidentsRegisterQuery> page, @Param(Constants.WRAPPER) QueryWrapper<EamReportAccidentsRegisterQuery> eamReportAccidentsRegisterQuery); /** * å表æ¥è¯¢ * param */ List<EamReportAccidentsRegisterDto> queryList(@Param(Constants.WRAPPER) QueryWrapper<EamReportAccidentsRegisterDto> queryWrapper); } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/mapper/EamReportProductHazardsMapper.java
@@ -7,6 +7,7 @@ import com.baomidou.mybatisplus.core.toolkit.Constants; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.apache.ibatis.annotations.Param; import org.jeecg.modules.eam.dto.EamReportProductHazardsDto; import org.jeecg.modules.eam.entity.EamReportProductHazards; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.jeecg.modules.eam.request.EamReportProductHazardsQuery; @@ -21,4 +22,9 @@ IPage<EamReportProductHazardsQuery> queryPageList(Page<EamReportProductHazardsQuery> page, @Param(Constants.WRAPPER) QueryWrapper<EamReportProductHazardsQuery> eamReportProductHazardsQuery); /** * å表æ¥è¯¢ * @param queryWrapper */ List<EamReportProductHazardsDto> queryList(@Param(Constants.WRAPPER) QueryWrapper<EamReportProductHazardsDto> queryWrapper); } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/mapper/xml/EamReportAccidentsRegisterMapper.xml
@@ -21,4 +21,25 @@ AND e.del_flag = 0 ${ew.customSqlSegment} </select> <select id="queryList" resultType="org.jeecg.modules.eam.dto.EamReportAccidentsRegisterDto"> SELECT aar.*, e.equipment_code, e.equipment_name, e.equipment_model, e.installation_position, wmo.scrap_part_number, wmo.scrap_part_quantity, wmo.scrap_part_value , f.factory_name FROM eam_report_accidents_register aar LEFT JOIN eam_report_repair wmo ON aar.report_id = wmo.id AND wmo.del_flag = 0 INNER JOIN eam_equipment e ON wmo.equipment_id = e.id AND e.del_flag = 0 LEFT JOIN eam_base_factory f ON f.org_code = SUBSTRING ( e.factory_org_code , 1, 6 ) ${ew.customSqlSegment} </select> </mapper> lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/mapper/xml/EamReportProductHazardsMapper.xml
@@ -14,4 +14,18 @@ and arr.del_flag=0 ${ew.customSqlSegment} </select> <select id="queryList" resultType="org.jeecg.modules.eam.dto.EamReportProductHazardsDto"> select erph.*, e.equipment_code, e.equipment_name,e.equipment_model, e.installation_position, arr.processing_part,arr.batch_number,arr.quantity,arr.fault_description, f.factory_name from eam_report_product_hazards erph inner join eam_equipment e on erph.equipment_id = e.id and e.del_flag=0 left join eam_report_repair arr on erph.report_id = arr.id and arr.del_flag=0 LEFT JOIN eam_base_factory f ON f.org_code = SUBSTRING ( e.factory_org_code , 1, 6 ) ${ew.customSqlSegment} </select> </mapper> lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/IEamReportAccidentsRegisterService.java
@@ -10,6 +10,8 @@ import org.jeecg.modules.eam.request.EamRepairOrderQuery; import org.jeecg.modules.eam.request.EamReportAccidentsRegisterQuery; import java.util.List; /** * @Description: 设å¤äºæ ç»è®°è¡¨ * @Author: jeecg-boot @@ -52,4 +54,11 @@ * @return */ boolean cancelled(String id); /** * 设å¤äºæ ç»è®°è¡¨æå° * @param ids * @return */ List<EamReportAccidentsRegisterDto> findListByIds(String ids); } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/IEamReportProductHazardsService.java
@@ -3,11 +3,14 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.jeecg.common.api.vo.Result; import org.jeecg.modules.eam.dto.EamReportAccidentsRegisterDto; import org.jeecg.modules.eam.dto.EamReportProductHazardsDto; import org.jeecg.modules.eam.entity.EamReportProductHazards; import com.baomidou.mybatisplus.extension.service.IService; import org.jeecg.modules.eam.request.EamReportAccidentsRegisterQuery; import org.jeecg.modules.eam.request.EamReportProductHazardsQuery; import java.util.List; /** * @Description: 产åå®å ¨éæ£ç¡®è®¤ @@ -51,4 +54,11 @@ * @return */ boolean cancelled(String id); /** * 产åå®å ¨éæ£ç¡®è®¤æå° * @param ids * @return */ List<EamReportProductHazardsDto> findListByIds(String ids); } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/impl/EamReportAccidentsRegisterServiceImpl.java
@@ -21,6 +21,7 @@ import org.jeecg.common.util.oConvertUtils; import org.jeecg.modules.eam.constant.*; import org.jeecg.modules.eam.dto.EamReportAccidentsRegisterDto; import org.jeecg.modules.eam.dto.EamReportProductHazardsDto; import org.jeecg.modules.eam.entity.*; import org.jeecg.modules.eam.mapper.EamReportAccidentsRegisterMapper; import org.jeecg.modules.eam.request.EamReportAccidentsRegisterQuery; @@ -631,6 +632,47 @@ return true; } /** * 设å¤äºæ ç»è®°è¡¨æå° * @param ids * @return */ @Override public List<EamReportAccidentsRegisterDto> findListByIds(String ids){ QueryWrapper<EamReportAccidentsRegisterDto> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("aar.del_flag",CommonConstant.DEL_FLAG_0.toString()); queryWrapper.eq("aar.register_status",EamReportAccidentsRegisterEnum.REPAIR_COMPLETED.name()); //ç¨æ·æ°æ®æé LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); if (sysUser == null) { return new ArrayList<>(); } if (StringUtils.isNotBlank(sysUser.getEamEquipmentIds())) { //éæ©äºè®¾å¤ï¼æ ¹æ®è®¾å¤idè¿æ»¤è®¾å¤ List<String> equipArr = Arrays.asList(sysUser.getEamEquipmentIds().split(",")); queryWrapper.in("e.equipment_code", equipArr); } else { //没æéæ©è®¾å¤ï¼æ ¹æ®ä¸å¿è¿æ»¤è®¾å¤ List<BaseFactoryUser> baseFactoryUserList=baseFactoryUserService. list(new LambdaQueryWrapper<BaseFactoryUser>().eq(BaseFactoryUser::getUserId,sysUser.getId())); if(!CollectionUtils.isEmpty(baseFactoryUserList)){ Set<String> factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toSet()); Set<String> factoryCode= baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getOrgCode).collect(Collectors.toSet()); queryWrapper.in("e.factory_org_code", factoryCode); } else { return new ArrayList<>(); } } //æ¥è¯¢æ¡ä»¶è¿æ»¤ if (StrUtil.isNotEmpty(ids)) { List<String> idList = Arrays.asList(ids.split(",")); queryWrapper.in("aar.id", idList); } else { queryWrapper.orderByDesc("aar.create_time"); } return this.baseMapper.queryList(queryWrapper); } @Override public void afterFlowHandle(FlowMyBusiness business) { lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/impl/EamReportProductHazardsServiceImpl.java
@@ -22,6 +22,8 @@ import org.jeecg.modules.eam.constant.BusinessCodeConst; import org.jeecg.modules.eam.constant.EamReportAccidentsRegisterEnum; import org.jeecg.modules.eam.constant.EamReportProductHazardsEnum; import org.jeecg.modules.eam.constant.SecondMaintenanceStatusEnum; import org.jeecg.modules.eam.dto.EamReportProductHazardsDto; import org.jeecg.modules.eam.dto.EamReportProductHazardsDto; import org.jeecg.modules.eam.entity.EamEquipment; import org.jeecg.modules.eam.entity.EamReportAccidentsRegister; @@ -380,6 +382,47 @@ return true; } /** * 产åå®å ¨éæ£ç¡®è®¤æå° * @param ids * @return */ @Override public List<EamReportProductHazardsDto> findListByIds(String ids){ QueryWrapper<EamReportProductHazardsDto> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("erph.del_flag",CommonConstant.DEL_FLAG_0.toString()); queryWrapper.eq("erph.confirm_status",EamReportProductHazardsEnum.REPAIR_COMPLETED.name() ); //ç¨æ·æ°æ®æé LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); if (sysUser == null) { return new ArrayList<>(); } if (StringUtils.isNotBlank(sysUser.getEamEquipmentIds())) { //éæ©äºè®¾å¤ï¼æ ¹æ®è®¾å¤idè¿æ»¤è®¾å¤ List<String> equipArr = Arrays.asList(sysUser.getEamEquipmentIds().split(",")); queryWrapper.in("e.equipment_code", equipArr); } else { //没æéæ©è®¾å¤ï¼æ ¹æ®ä¸å¿è¿æ»¤è®¾å¤ List<BaseFactoryUser> baseFactoryUserList=baseFactoryUserService. list(new LambdaQueryWrapper<BaseFactoryUser>().eq(BaseFactoryUser::getUserId,sysUser.getId())); if(!CollectionUtils.isEmpty(baseFactoryUserList)){ Set<String> factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toSet()); Set<String> factoryCode= baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getOrgCode).collect(Collectors.toSet()); queryWrapper.in("e.factory_org_code", factoryCode); } else { return new ArrayList<>(); } } //æ¥è¯¢æ¡ä»¶è¿æ»¤ if (StrUtil.isNotEmpty(ids)) { List<String> idList = Arrays.asList(ids.split(",")); queryWrapper.in("erph.id", idList); } else { queryWrapper.orderByDesc("erph.create_time"); } return this.baseMapper.queryList(queryWrapper); } @Override public void afterFlowHandle(FlowMyBusiness business) { lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamInspectionOrderController.java
@@ -19,6 +19,7 @@ import org.jeecg.modules.eam.constant.InspectionItemCategroyEnum; import org.jeecg.modules.eam.constant.InspectionStatus; import org.jeecg.modules.eam.constant.OrderCreationMethodEnum; import org.jeecg.modules.eam.dto.EamInspectionOrderExport; import org.jeecg.modules.eam.entity.EamInspectionOrder; import org.jeecg.modules.eam.entity.EamInspectionOrderDetail; import org.jeecg.modules.eam.entity.EamMaintenanceStandardDetail; @@ -364,4 +365,14 @@ return eamInspectionOrderService.exportWeekInsOrderDetailUserList(equipmentCode, inspectionDate); } /** * ç产设å¤èªä¸»ç»´æ¤ç¹æ£è¡¨æå° * @param ids * @return */ @ApiOperation(value = "ç产设å¤èªä¸»ç»´æ¤ç¹æ£è¡¨æå°", notes = "ç产设å¤èªä¸»ç»´æ¤ç¹æ£è¡¨æå°") @GetMapping("/printInspectionOrder") public Result<?> printInspectionOrder(String ids) { return Result.ok(eamInspectionOrderService.printInspectionOrder(ids)); } } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamReportAccidentsRegisterController.java
@@ -270,4 +270,16 @@ return super.importExcel(request, response, EamReportAccidentsRegister.class); } /** * 设å¤äºæ ç»è®°è¡¨æå° * @param ids * @return */ @AutoLog(value = "设å¤äºæ ç»è®°è¡¨-设å¤äºæ ç»è®°è¡¨æå°") @ApiOperation(value="设å¤äºæ ç»è®°è¡¨-设å¤äºæ ç»è®°è¡¨æå°", notes="设å¤äºæ ç»è®°è¡¨-设å¤äºæ ç»è®°è¡¨æå°") @GetMapping(value = "/batchExport") public Result<?> batchExport(String ids){ return Result.ok(eamReportAccidentsRegisterService.findListByIds(ids)); } } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamReportProductHazardsController.java
@@ -160,6 +160,18 @@ return Result.error("å é¤å¤±è´¥!"); } /** * 产åå®å ¨éæ£ç¡®è®¤æå° * @param ids * @return */ @AutoLog(value = "产åå®å ¨éæ£ç¡®è®¤-产åå®å ¨éæ£ç¡®è®¤æå°") @ApiOperation(value="产åå®å ¨éæ£ç¡®è®¤-产åå®å ¨éæ£ç¡®è®¤æå°", notes="产åå®å ¨éæ£ç¡®è®¤-产åå®å ¨éæ£ç¡®è®¤æå°") @GetMapping(value = "/batchExport") public Result<?> batchExport(String ids){ return Result.ok(eamReportProductHazardsService.findListByIds(ids)); } /** * æ¹éå é¤ * lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamMaintenanceStandard.java
@@ -186,6 +186,15 @@ //æµè½¬èç¹ä½¿ç¨æ¥è¯¢ @TableField(exist = false) private String procInstId; /**æµç¨å®ä¹key ä¸ä¸ªkey伿å¤ä¸ªçæ¬çid*/ @TableField(exist = false) private String processDefinitionKey; /**æµç¨å®ä¹id ä¸ä¸ªæµç¨å®ä¹å¯ä¸*/ @TableField(exist = false) private String processDefinitionId; /**æµç¨ä¸å¡å®ä¾id ä¸ä¸ªæµç¨ä¸å¡å¯ä¸ï¼æ¬è¡¨ä¸ä¹å¯ä¸*/ @TableField(exist = false) private String processInstanceId; public String getEquipmentText() { return equipmentCode + "[" + equipmentName + "]"; lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/EamInspectionOrderMapper.java
@@ -6,6 +6,7 @@ import com.baomidou.mybatisplus.core.toolkit.Constants; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.apache.ibatis.annotations.Param; import org.jeecg.modules.eam.dto.EamInspectionOrderExport; import org.jeecg.modules.eam.entity.EamInspectionOrder; import org.jeecg.modules.eam.request.*; @@ -27,6 +28,12 @@ */ IPage<EamInspectionOrder> queryPageList(Page<EamInspectionOrder> page, @Param(Constants.WRAPPER) QueryWrapper<EamInspectionOrder> queryWrapper); /** * å表æ¥è¯¢ * @return */ List<EamInspectionOrderExport> queryList(@Param("ids") List<String> ids); EamInspectionOrderBaseResponse findInsOrderBaseInfo(@Param("equipmentCode") String equipmentCode, @Param("inspectionDate") String inspectionDate); List<EamInsOrderDetailResultResponse> findInsOrderDetailList(@Param("equipmentCode") String equipmentCode, @Param("inspectionDate") String inspectionDate); lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamInspectionOrderMapper.xml
@@ -3,10 +3,14 @@ <mapper namespace="org.jeecg.modules.eam.mapper.EamInspectionOrderMapper"> <select id="queryPageList" resultType="org.jeecg.modules.eam.entity.EamInspectionOrder"> select wmo.*, e.equipment_code, e.equipment_name, e.equipment_model select wmo.*, e.equipment_code, e.equipment_name, e.equipment_model,f.process_instance_id as 'procInstId', f.process_definition_key, f.process_definition_id, f.process_instance_id from eam_inspection_order wmo inner join eam_equipment e on wmo.equipment_id = e.id left join flow_my_business f on f.data_id=wmo.id ${ew.customSqlSegment} </select> @@ -124,5 +128,35 @@ ORDER BY t1.plan_inspection_date ASC </select> <select id="queryList" resultType="org.jeecg.modules.eam.dto.EamInspectionOrderExport"> SELECT t2.equipment_name equipmentName, t2.equipment_code equipmentCode, t2.equipment_model equipmentModel, SUBSTRING(t2.factory_org_code,1,6) factoryName, DATEPART( YEAR, t1.inspection_date ) AS inspectionYear, DATEPART( MONTH, t1.inspection_date ) AS inspectionMonth, t1.hf_code hfCode FROM eam_inspection_order t1 LEFT JOIN eam_equipment t2 ON t1.equipment_id = t2.id WHERE 1=1 <if test="ids != null and ids.size() > 0"> AND t1.id IN <foreach collection="ids" item="id" index="index" open="(" close=")" separator=","> #{id} </foreach> </if> AND t1.inspection_status = 'COMPLETE' GROUP BY t2.equipment_name, t2.equipment_code, t2.equipment_model , t2.factory_org_code , DATEPART( YEAR, t1.inspection_date ), DATEPART( MONTH, t1.inspection_date ), t1.hf_code </select> </mapper> lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamMaintenanceStandardMapper.xml
@@ -3,7 +3,10 @@ <mapper namespace="org.jeecg.modules.eam.mapper.EamMaintenanceStandardMapper"> <select id="queryPageList" resultType="org.jeecg.modules.eam.entity.EamMaintenanceStandard"> select ems.*, e.equipment_code, e.equipment_name, e.equipment_model,f.process_instance_id as 'procInstId' e.equipment_model,f.process_instance_id as 'procInstId', f.process_definition_key, f.process_definition_id, f.process_instance_id from eam_maintenance_standard ems inner join eam_equipment e on ems.equipment_id = e.id lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamSecondMaintenanceOrderMapper.xml
@@ -3,7 +3,10 @@ <mapper namespace="org.jeecg.modules.eam.mapper.EamSecondMaintenanceOrderMapper"> <select id="queryPageList" resultType="org.jeecg.modules.eam.entity.EamSecondMaintenanceOrder"> select wmo.*, e.equipment_code, e.equipment_name,e.equipment_model,f.process_instance_id as 'procInstId' select wmo.*, e.equipment_code, e.equipment_name,e.equipment_model,f.process_instance_id as 'procInstId', f.process_definition_key, f.process_definition_id, f.process_instance_id from eam_second_maintenance_order wmo inner join eam_equipment e on wmo.equipment_id = e.id lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamThirdMaintenanceOrderMapper.xml
@@ -3,10 +3,14 @@ <mapper namespace="org.jeecg.modules.eam.mapper.EamThirdMaintenanceOrderMapper"> <select id="queryPageList" resultType="org.jeecg.modules.eam.entity.EamThirdMaintenanceOrder"> select wmo.*, e.equipment_code, e.equipment_name, e.equipment_model select wmo.*, e.equipment_code, e.equipment_name, e.equipment_model,f.process_instance_id as 'procInstId', f.process_definition_key, f.process_definition_id, f.process_instance_id from eam_third_maintenance_order wmo inner join eam_equipment e on wmo.equipment_id = e.id left join flow_my_business f on f.data_id=wmo.id ${ew.customSqlSegment} </select> lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamInspectionOrderService.java
@@ -1,19 +1,16 @@ package org.jeecg.modules.eam.service; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.IService; import org.jeecg.common.api.vo.Result; import org.jeecg.modules.eam.dto.EamInspectionOrderExport; import org.jeecg.modules.eam.entity.EamInspectionOrder; import org.jeecg.modules.eam.entity.EamMaintenanceStandardDetail; import org.jeecg.modules.eam.request.EamInspectionOrderQuery; import org.jeecg.modules.eam.request.EamInspectionOrderRequest; import org.jeecg.modules.eam.vo.InspectionVo; import java.util.List; import java.util.Map; /** * @Description: ç¹æ£å·¥å @@ -112,4 +109,11 @@ * å¨ç¹æ£è´£ä»»äººå表 */ JSONObject exportWeekInsOrderDetailUserList(String equipmentCode, String inspectionDate); /** * ç产设å¤èªä¸»ç»´æ¤ç¹æ£è¡¨æå° * @param ids * @return */ List<EamInspectionOrderExport> printInspectionOrder(String ids); } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamThirdMaintenanceOrderService.java
@@ -5,6 +5,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.jeecg.common.api.vo.Result; import org.jeecg.modules.eam.dto.EamThirdMaintenanceOrderExport; import org.jeecg.modules.eam.dto.EamThirdMaintenanceOrderExportYj; import org.jeecg.modules.eam.entity.EamThirdMaintenanceOrder; import com.baomidou.mybatisplus.extension.service.IService; import org.jeecg.modules.eam.request.EamThirdMaintenanceQuery; @@ -95,7 +96,7 @@ * @param ids * @return */ List<EamThirdMaintenanceOrderExport> export(String ids); List<EamThirdMaintenanceOrderExportYj> export(String ids); /** * æ¹éæå°å 工设å¤ä¸çº§ä¿å »éªæ¶å lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamInspectionOrderServiceImpl.java
@@ -11,6 +11,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.apache.commons.lang3.StringUtils; import org.apache.ibatis.annotations.Param; import org.apache.shiro.SecurityUtils; import org.flowable.engine.TaskService; import org.flowable.task.api.Task; @@ -23,6 +24,10 @@ import org.jeecg.common.util.oConvertUtils; import org.jeecg.modules.eam.aspect.annotation.EquipmentHistoryLog; import org.jeecg.modules.eam.constant.*; import org.jeecg.modules.eam.dto.DailyResponsibleInfo; import org.jeecg.modules.eam.dto.EamInspectionOrderDetailExport; import org.jeecg.modules.eam.dto.EamInspectionOrderExport; import org.jeecg.modules.eam.dto.WeeklyResponsibleInfo; import org.jeecg.modules.eam.request.*; import org.jeecg.modules.system.entity.BaseFactory; import org.jeecg.modules.system.entity.BaseFactoryUser; @@ -49,6 +54,7 @@ import java.time.LocalDate; import java.time.ZoneId; import java.time.format.DateTimeFormatter; import java.time.format.DateTimeParseException; import java.util.*; import java.util.concurrent.atomic.AtomicInteger; import java.util.stream.Collectors; @@ -698,6 +704,270 @@ } } /** * ç产设å¤èªä¸»ç»´æ¤ç¹æ£è¡¨æå° * @param ids * @return */ @Override public List<EamInspectionOrderExport> printInspectionOrder(String ids) { List<EamInspectionOrderExport> eamInspectionOrderExports = this.eamInspectionOrderMapper.queryList(Arrays.asList(ids.split(","))); if (eamInspectionOrderExports == null || eamInspectionOrderExports.isEmpty()) { return null; } eamInspectionOrderExports.forEach(eamInspectionOrderExport -> { // æ¥æå¤ç if (StrUtil.isNotEmpty(eamInspectionOrderExport.getInspectionMonth())){ if (eamInspectionOrderExport.getInspectionMonth().length() == 1) { eamInspectionOrderExport.setInspectionMonth("0" + eamInspectionOrderExport.getInspectionMonth()); } } String finalInspectionDate = eamInspectionOrderExport.getInspectionYear()+"-" + eamInspectionOrderExport.getInspectionMonth(); // è·å该设å¤çæ¥ç¹æ£æç»æ°æ® List<EamInsOrderDetailResultResponse> detailResponseList = eamInspectionOrderMapper.findInsOrderDetailList( eamInspectionOrderExport.getEquipmentCode(), finalInspectionDate ); if (!detailResponseList.isEmpty()) { // æé¡¹ç®åç»åå¨ï¼é¡¹ç®ç¼ç 为keyï¼ Map<Integer, EamInspectionOrderDetailExport> detailExportMap = new HashMap<>(); // åå§å项ç®ä¿¡æ¯ï¼æ¯ä¸ªé¡¹ç®å¯¹åºä¸ä¸ª31å¤©ç¶æçå¯¹è±¡ï¼ detailResponseList.forEach(detail -> { Integer itemCode = detail.getItemCode(); EamInspectionOrderDetailExport export = detailExportMap.get(itemCode); if (export == null) { // å建æ°çç¹æ£é¡¹ç®å¯¹è±¡ export = new EamInspectionOrderDetailExport() .setItemCode(itemCode) .setItemName(detail.getItemName()) .setItemDemand(detail.getItemDemand()) .setDateFlag(new String[31]); // åå§å31å¤©ç¶ææ°ç» detailExportMap.put(itemCode, export); } }); // å¡«å åé¡¹ç®æ¯æ¥çç¹æ£ç¶æ detailResponseList.forEach(detail -> { Integer itemCode = detail.getItemCode(); EamInspectionOrderDetailExport export = detailExportMap.get(itemCode); try { Date newinspectionDate = detail.getInspectionDate(); // å¤çç©ºæ¥ææ åµ if (newinspectionDate == null) { log.warn("æ£æµå°ç©ºæ¥æå¼, itemCode: {}"); return; } // 转æ¢ä¸ºLocalDate LocalDate date = newinspectionDate.toInstant() .atZone(ZoneId.systemDefault()) .toLocalDate(); int day = date.getDayOfMonth(); // å®å ¨è®¾ç½®æ¥æç¶æ if (day >= 1 && day <= 31) { String[] dateFlags = export.getDateFlag(); if (dateFlags == null) { dateFlags = new String[31]; export.setDateFlag(dateFlags); } if (StrUtil.isNotEmpty(detail.getInspectionResult())){ switch (detail.getInspectionResult()) { case "NORMAL": dateFlags[day - 1] = "â"; break; case "ANOMALY": dateFlags[day - 1] = "Ã"; break; case "FAULT": dateFlags[day - 1] = "â³"; break; case "CLOSE": dateFlags[day - 1] = "T"; break; } } } else { log.warn("éæ³æ¥æå¼: {}, itemCode: {}"); } } catch (DateTimeParseException | NullPointerException e) { log.error("æ¥æå¤çé误 - åå§å¼: {}, 项ç®: {}, é误: {}"); } }); // å°ç¹æ£é¡¹ç®éå转æ¢ä¸ºå表 List<EamInspectionOrderDetailExport> detailExports = new ArrayList<>(detailExportMap.values()); // 设置å°ä¸»å¯¼åºå¯¹è±¡ä¸ eamInspectionOrderExport.setEamDailyInspectionList(detailExports); }else { eamInspectionOrderExport.setEamDailyInspectionList(null); } // è·å该设å¤çå¨ç¹æ£æç»æ°æ® List<EamWeekInsDetailResultResponse> eamWeekInsDetailResultResponseList = eamInspectionOrderMapper.findWeekInsDetailList( eamInspectionOrderExport.getEquipmentCode(), finalInspectionDate ); if (!eamWeekInsDetailResultResponseList.isEmpty()) { // æé¡¹ç®åç»åå¨ï¼é¡¹ç®ç¼ç 为keyï¼ Map<Integer, EamInspectionOrderDetailExport> detailExportMap = new HashMap<>(); // åå§å项ç®ä¿¡æ¯ eamWeekInsDetailResultResponseList.forEach(detail -> { Integer itemCode = detail.getItemCode(); EamInspectionOrderDetailExport export = detailExportMap.get(itemCode); if (export == null) { // å建æ°çç¹æ£é¡¹ç®å¯¹è±¡å¹¶åå§åweekFlagæ°ç» export = new EamInspectionOrderDetailExport() .setItemCode(itemCode) .setItemName(detail.getItemName()) .setItemDemand(detail.getItemDemand()) .setWeekFlag(new String[5]); // æç¡®åå§åé¿åº¦ä¸º5 detailExportMap.put(itemCode, export); } }); // å¡«å åé¡¹ç®æ¯å¨çç¹æ£ç¶æ eamWeekInsDetailResultResponseList.forEach(detail -> { Integer itemCode = detail.getItemCode(); EamInspectionOrderDetailExport export = detailExportMap.get(itemCode); Date newinspectionDate = detail.getPlanInspectionDate(); if (newinspectionDate == null) { log.warn("æ£æµå°ç©ºæ¥æå¼, itemCode: {}"); return; } // 计ç®è¯¥æ¥ææ¯å½æç¬¬å å¨ (1-5) int week = calculateWeekOfMonth(newinspectionDate); if (week >= 1 && week <= 5) { String[] weekFlags = export.getWeekFlag(); if (weekFlags == null) { weekFlags = new String[31]; export.setWeekFlag(weekFlags); } if (StrUtil.isNotEmpty(detail.getInspectionResult())){ switch (detail.getInspectionResult()) { case "NORMAL": weekFlags[week - 1] = "â"; break; case "ANOMALY": weekFlags[week - 1] = "Ã"; break; case "FAULT": weekFlags[week - 1] = "â³"; break; case "CLOSE": weekFlags[week - 1] = "T"; break; } } } }); // å°ç¹æ£é¡¹ç®éå转æ¢ä¸ºå表 List<EamInspectionOrderDetailExport> weekDetailExports = new ArrayList<>(detailExportMap.values()); // 设置å°ä¸»å¯¼åºå¯¹è±¡ä¸ eamInspectionOrderExport.setEamWeeklyInspectionList(weekDetailExports); }else { eamInspectionOrderExport.setEamWeeklyInspectionList(null); } // ================== æ·»å æ¥ç¹æ£è´£ä»»äººä¿¡æ¯ ================== DailyResponsibleInfo dailyResponsible = new DailyResponsibleInfo(); List<EamInsOrderDetailUserResponse> dailyUserResponses = eamInspectionOrderMapper.findInspectionOrderDetailUserList( eamInspectionOrderExport.getEquipmentCode(), finalInspectionDate ); if (dailyUserResponses != null && !dailyUserResponses.isEmpty()) { dailyUserResponses.forEach(response -> { try { Date date = response.getInspectionDate(); if (date == null) return; LocalDate localDate = date.toInstant() .atZone(ZoneId.systemDefault()) .toLocalDate(); int day = localDate.getDayOfMonth(); if (day < 1 || day > 31) return; // è·åæä½åå确认人å§å String operator = sysDictService.queryTableDictTextByKey( "sys_user", "realname", "username", response.getOperator()); String confirmUser = sysDictService.queryTableDictTextByKey( "sys_user", "realname", "username", response.getConfirmUser()); // è®¾ç½®è´£ä»»äººä¿¡æ¯ dailyResponsible.setResponsibleForDay(day, operator, confirmUser); } catch (Exception e) { log.error("å¤çæ¥ç¹æ£è´£ä»»äººä¿¡æ¯åºé: {}"); } }); } eamInspectionOrderExport.setDailyResponsibleInfo(dailyResponsible); // ================== æ·»å å¨ç¹æ£è´£ä»»äººä¿¡æ¯ ================== WeeklyResponsibleInfo weeklyResponsible = new WeeklyResponsibleInfo(); List<EamWeekInsDetailUserResponse> weeklyUserResponses = eamInspectionOrderMapper.findWeekInsOrderDetailUserList( eamInspectionOrderExport.getEquipmentCode(), finalInspectionDate ); if (weeklyUserResponses != null && !weeklyUserResponses.isEmpty()) { weeklyUserResponses.forEach(response -> { try { Date date = response.getPlanInspectionDate(); if (date == null) return; // 计ç®å¨æ° Calendar calendar = Calendar.getInstance(); calendar.setTime(date); int week = calendar.get(Calendar.WEEK_OF_MONTH); if (week < 1 || week > 5) return; // è·åæä½åå确认人å§å String operator = sysDictService.queryTableDictTextByKey( "sys_user", "realname", "username", response.getInspector()); String confirmUser = sysDictService.queryTableDictTextByKey( "sys_user", "realname", "username", response.getConfirmUser()); // è®¾ç½®è´£ä»»äººä¿¡æ¯ weeklyResponsible.setResponsibleForWeek(week, operator, confirmUser); } catch (Exception e) { log.error("å¤çå¨ç¹æ£è´£ä»»äººä¿¡æ¯åºé: {}"); } }); } eamInspectionOrderExport.setWeeklyResponsibleInfo(weeklyResponsible); }); return eamInspectionOrderExports; } /** * è®¡ç®æ¥æå¨å½ææ¯ç¬¬å å¨ï¼1-5ï¼ */ private int calculateWeekOfMonth(Date date) { Calendar calendar = Calendar.getInstance(); calendar.setTime(date); return calendar.get(Calendar.WEEK_OF_MONTH); } private boolean isValidRequest(EamInspectionOrderRequest request) { return StrUtil.isNotBlank(request.getTaskId()) && StrUtil.isNotBlank(request.getDataId()); lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamThirdMaintenanceOrderServiceImpl.java
@@ -26,6 +26,7 @@ import org.jeecg.modules.eam.constant.*; import org.jeecg.modules.eam.dto.EamThirdMaintenanceOrderExport; import org.jeecg.modules.eam.dto.EamThirdMaintenanceOrderExport; import org.jeecg.modules.eam.dto.EamThirdMaintenanceOrderExportYj; import org.jeecg.modules.eam.entity.*; import org.jeecg.modules.eam.mapper.EamThirdMaintenanceOrderMapper; import org.jeecg.modules.eam.request.EamThirdMaintenanceBaseResponse; @@ -598,7 +599,7 @@ * @return */ @Override public List<EamThirdMaintenanceOrderExport> export(String ids){ public List<EamThirdMaintenanceOrderExportYj> export(String ids){ QueryWrapper<EamThirdMaintenanceOrderExport> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("wmo.del_flag",CommonConstant.DEL_FLAG_0.toString()); queryWrapper.eq("wmo.maintenance_status",SecondMaintenanceStatusEnum.COMPLETE.name()); @@ -631,15 +632,23 @@ queryWrapper.orderByDesc("wmo.create_time"); } List<EamThirdMaintenanceOrderExport> eamThirdMaintenanceOrderExports=this.baseMapper.queryList(queryWrapper); List<EamThirdMaintenanceOrderExportYj> eamThirdMaintenanceOrderExportYjs=new ArrayList<>(); if (!eamThirdMaintenanceOrderExports.isEmpty()){ for (EamThirdMaintenanceOrderExport eamThirdMaintenanceOrderExport:eamThirdMaintenanceOrderExports) { EamThirdMaintenanceOrderExportYj eamThirdMaintenanceOrderExportYj = new EamThirdMaintenanceOrderExportYj(); BeanUtils.copyProperties(eamThirdMaintenanceOrderExport, eamThirdMaintenanceOrderExportYj); eamThirdMaintenanceOrderExportYjs.add(eamThirdMaintenanceOrderExportYj); } } //å¡«å 对åºä¿®çæ´æ¢å¤ä»¶æç» eamThirdMaintenanceOrderExports.forEach(eamThirdMaintenanceOrderExport->{ eamThirdMaintenanceOrderExportYjs.forEach(eamThirdMaintenanceOrderExportYj->{ List<EamThirdMaintenanceSpare> eamThirdMaintenanceSpares=eamThirdMaintenanceSpareService.list( new QueryWrapper<EamThirdMaintenanceSpare>().eq("order_Id",eamThirdMaintenanceOrderExport.getId())); new QueryWrapper<EamThirdMaintenanceSpare>().eq("order_Id",eamThirdMaintenanceOrderExportYj.getId())); if (!eamThirdMaintenanceSpares.isEmpty()){ eamThirdMaintenanceOrderExport.setEamThirdMaintenanceSpareList(eamThirdMaintenanceSpares); eamThirdMaintenanceOrderExportYj.setEamThirdMaintenanceSpareList(eamThirdMaintenanceSpares); } }); return eamThirdMaintenanceOrderExports; return eamThirdMaintenanceOrderExportYjs; } /**