| | |
| | | @ApiModelProperty("检查时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") |
| | | private LocalDateTime checkTime; |
| | | @ApiModelProperty("整改情况 true已整改 false未整改") |
| | | private Boolean reformed; |
| | | |
| | | @ApiModelProperty("整改情况0未复查1-未整改 2-部分整改 3-已整改") |
| | | private Integer state; |
| | | @ApiModelProperty("责任人") |
| | | private String responsiblePerson; |
| | | |
| | |
| | | <select id="errorList" resultType="com.ruoyi.system.vo.ErrorListVo"> |
| | | select t1.*,t2.project_id,t2.plan_id,t3.`name` as projectName,t4.`name` as planName |
| | | ,t5.`name` as problemName,IF(t1.device_id is null ,1,2) as type,t1.create_time as checkTime |
| | | ,t6.state as state |
| | | ,IF(t6.state is null,0,t6.state) as state |
| | | from record t1 |
| | | LEFT JOIN task t2 on t1.check_task_id = t2.id |
| | | LEFT JOIN project t3 on t2.project_id = t3.id |
| | |
| | | <select id="deviceErrorList" resultType="com.ruoyi.system.vo.ErrorListVo"> |
| | | select t1.*,t2.project_id,t2.plan_id,t3.`name` as projectName,t4.`name` as planName |
| | | ,t5.`name` as problemName,IF(t1.device_id is null ,1,2) as type,t1.create_time as checkTime |
| | | ,t6.state as state |
| | | ,IF(t6.state is null,0,t6.state) as state |
| | | from record t1 |
| | | LEFT JOIN task t2 on t1.check_task_id = t2.id |
| | | LEFT JOIN project t3 on t2.project_id = t3.id |
| | |
| | | <select id="safetyErrorList" resultType="com.ruoyi.system.vo.ErrorListVo"> |
| | | select t1.*,t2.project_id,t2.plan_id,t3.`name` as projectName,t4.`name` as planName |
| | | ,t5.`name` as problemName,IF(t1.device_id is null ,1,2) as type,t1.create_time as checkTime |
| | | ,t6.state as state |
| | | ,IF(t6.state is null,0,t6.state) as state |
| | | from record t1 |
| | | LEFT JOIN task t2 on t1.check_task_id = t2.id |
| | | LEFT JOIN project t3 on t2.project_id = t3.id |