attiya/ebike-plus
SHA256
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

工单看板

Browse Source
This commit is contained in:
PC 2026-01-28 13:55:50 +08:00
parent c61e663fe3
commit ec32a83aae
4 changed files with 24 additions and 9 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

7
ebike-operations/src/main/java/com/cdzy/operations/model/dto/EbikeBikeOrderDayCountDto.java
View File

@ -24,10 +24,15 @@ public class EbikeBikeOrderDayCountDto implements Serializable {
@Serial
private static final long serialVersionUID = 1L;
/**
* 工单类型名称：1 巡检工单 2 换电工单 3 调度工单 4 维修工单
*/
private String orderTypeName;
/**
* 工单类型：1 巡检工单 2 换电工单 3 调度工单 4 维修工单
*/
private String orderType;
private Integer orderType;
/**
* 处理人ID

7
ebike-operations/src/main/java/com/cdzy/operations/model/dto/EbikeBikeOrderMonthCountDto.java
View File

@ -24,10 +24,15 @@ public class EbikeBikeOrderMonthCountDto implements Serializable {
@Serial
private static final long serialVersionUID = 1L;
/**
* 工单类型名称：1 巡检工单 2 换电工单 3 调度工单 4 维修工单
*/
private String orderTypeName;
/**
* 工单类型：1 巡检工单 2 换电工单 3 调度工单 4 维修工单
*/
private String orderType;
private Integer orderType;
/**
* 处理人ID

7
ebike-operations/src/main/java/com/cdzy/operations/model/dto/EbikeBikeOrderWeekCountDto.java
View File

@ -24,10 +24,15 @@ public class EbikeBikeOrderWeekCountDto implements Serializable {
@Serial
private static final long serialVersionUID = 1L;
/**
* 工单类型名称：1 巡检工单 2 换电工单 3 调度工单 4 维修工单
*/
private String orderTypeName;
/**
* 工单类型：1 巡检工单 2 换电工单 3 调度工单 4 维修工单
*/
private String orderType;
private Integer orderType;
/**
* 处理人ID

12
ebike-operations/src/main/resources/mapper/EbikeBikeOrderMapper.xml
View File

@ -6,13 +6,13 @@
<select id="monthCount" resultType="com.cdzy.operations.model.dto.EbikeBikeOrderMonthCountDto">
<![CDATA[
SELECT #{receiverId} as receiverId,
SELECT #{receiverId} as receiverId,aot.order_type AS orderType,
CASE aot.order_type
WHEN 1 THEN '巡检工单'
WHEN 2 THEN '换电工单'
WHEN 3 THEN '调度工单'
WHEN 4 THEN '维修工单'
END as orderType,
END as orderTypeName,
COALESCE(COUNT(CASE
WHEN DATE_TRUNC('month', ebo.handle_at) = DATE_TRUNC('month', CURRENT_DATE)
THEN 1
@ -61,13 +61,13 @@
</select>
<select id="dayCount" resultType="com.cdzy.operations.model.dto.EbikeBikeOrderDayCountDto">
<![CDATA[
SELECT #{receiverId} as receiverId,
SELECT #{receiverId} as receiverId,aot.order_type AS orderType,
CASE aot.order_type
WHEN 1 THEN '巡检工单'
WHEN 2 THEN '换电工单'
WHEN 3 THEN '调度工单'
WHEN 4 THEN '维修工单'
END as orderType,
END as orderTypeName,
COALESCE(COUNT(CASE
WHEN DATE (ebo.handle_at) = CURRENT_DATE
THEN 1
@ -119,13 +119,13 @@
WITH week_range AS (SELECT DATE_TRUNC('week', CURRENT_DATE) as current_week_start,
DATE_TRUNC('week', CURRENT_DATE) + INTERVAL '1 week' as current_week_end, DATE_TRUNC('week', CURRENT_DATE - INTERVAL '1 week') as last_week_start
)
SELECT #{receiverId} as receiverId,
SELECT #{receiverId} as receiverId,aot.order_type AS orderType,
CASE aot.order_type
WHEN 1 THEN '巡检工单'
WHEN 2 THEN '换电工单'
WHEN 3 THEN '调度工单'
WHEN 4 THEN '维修工单'
END as orderType,
END as orderTypeName,
COALESCE(COUNT(CASE
WHEN ebo.handle_at >= wr.current_week_start
AND ebo.handle_at < wr.current_week_end