优化代码 获取工单详情接口 增加处理结果状态ID返回 修改处理结果状态
获取工单列表接口 增加处理结果状态ID返回 修改处理结果状态
| | |
| | | */ |
| | | |
| | | @Data |
| | | @JsonPropertyOrder({"workOrderId", "dispatcherId", "dispatcher", "inspectorId", "inspector", "taskTypeId", "taskType", "taskContent", "completeCriteria", "deadLine", "clientReportId", "inspectorReportId", "completeTime", "dispatchTime", "rejectTimes", "state", "processingState", "proResultId"}) |
| | | @JsonPropertyOrder({"workOrderId", "dispatcherId", "dispatcher", "inspectorId", "inspector", "taskTypeId", "taskType", "taskContent", "completeCriteria", "deadLine", "clientReportId", "inspectorReportId", "completeTime", "dispatchTime", "rejectTimes", "state", "processingState", "proResultId", "proResultStateId"}) |
| | | public class VoWorkOrder implements BaseEntity { |
| | | public static final long serialVersionUID = 202411061524001L; |
| | | |
| | |
| | | */ |
| | | @JSONField(serializeUsing= ObjectWriterImplToString.class) |
| | | private Long proResultId; |
| | | /** |
| | | * 处理结果状态id |
| | | */ |
| | | private Integer proResultStateId; |
| | | } |
| | |
| | | ord.dispatch_time AS dispatchTime, |
| | | ord.reject_times AS rejectTimes, |
| | | res.id AS proResultId, |
| | | res.state AS proResultStateId, |
| | | CASE |
| | | WHEN ord.state = 1 THEN '未完成' |
| | | WHEN ord.state = 2 THEN '已完成' |
| | | END AS state, |
| | | CASE |
| | | WHEN res.state = 1 THEN '已上报' |
| | | WHEN res.state = 1 THEN '待审核' |
| | | WHEN res.state = 2 THEN '已通过' |
| | | WHEN res.state = 3 THEN '已驳回' |
| | | WHEN res.state = 3 THEN '被驳回' |
| | | ELSE '未上报' |
| | | END AS processingState |
| | | FROM ope_work_order ord |
| | |
| | | ord.complete_time AS completeTime, |
| | | ord.dispatch_time AS dispatchTime, |
| | | ord.reject_times AS rejectTimes, |
| | | res.state AS proResultStateId, |
| | | CASE |
| | | WHEN ord.state = 1 THEN '未完成' |
| | | WHEN ord.state = 2 THEN '已完成' |
| | | END AS state, |
| | | CASE |
| | | WHEN res.state = 1 THEN '已上报' |
| | | WHEN res.state = 1 THEN '待审核' |
| | | WHEN res.state = 2 THEN '已通过' |
| | | WHEN res.state = 3 THEN '已驳回' |
| | | WHEN res.state = 3 THEN '被驳回' |
| | | ELSE '未上报' |
| | | END AS processingState, |
| | | res.id AS proResultId |