设备维修修改

qushaowei

2025-06-10 9ca176b77f2572f433f44784fd24602aeb6d0e85

设备维修修改

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentReportRepairMapper.xml

@@ -151,6 +151,7 @@
        t2.num equipmentNum,
        t2.name equipmentName,
        t2.model equipmentModel,
        t2.model,
        t2.team_id teamId,
        t2.specification specification,
        t2.use_id useId,

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/FaultInfoMapper.xml

@@ -62,5 +62,7 @@
            <if test="id != null and id != ''">
                and t1.id = #{id}
            </if>
            order by t1.num desc

    </select>
</mapper>

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/QuanlityConfirmMapper.xml

@@ -37,5 +37,6 @@
            <if test="id != null and id != ''">
                and t1.id = #{id}
            </if>
            order by t1.create_time desc
    </select>
</mapper>

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/vo/RepairReportExportVo.java

@@ -15,10 +15,7 @@
 */
@Data
public class RepairReportExportVo implements Serializable {
    @Excel(name = "关键设备标识", width = 15,orderNum = "0",dicCode = "specific_equipment")
    private String specificEquipment;
    @Excel(name = "状态", width = 15,orderNum = "1",dicCode = "equipment_report_repair_status")
    private String status;

    @Excel(name = "单据号", width = 15,orderNum = "2")
    private String num;
    /**设备编码*/
@@ -32,6 +29,10 @@
    private String model;
    @Excel(name = "使用部门", width = 15,orderNum = "6",dicCode = "id",dictTable="sys_depart",dicText="depart_name")
    private String useId;
    @Excel(name = "关键设备标识", width = 15,orderNum = "0",dicCode = "specific_equipment")
    private String specificEquipment;
    @Excel(name = "状态", width = 15,orderNum = "1",dicCode = "equipment_report_repair_status")
    private String status;
    @Excel(name = "报修人", width = 15,orderNum = "7")
    private String errUda2;
    @Excel(name = "故障时间", width = 15,orderNum = "8",databaseFormat = "yyyy-MM-dd HH:mm:ss",exportFormat = "yyyy-MM-dd HH:mm:ss")