From 40a8157440e3b906da8f52e07d939d78c3f4c313 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期日, 12 四月 2026 16:14:06 +0800
Subject: [PATCH] feat: 任务增加统计、同步增加通知

---
 ruoyi-system/src/main/java/com/ruoyi/system/mapper/ServiceOrderMapper.java |   48 +++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 47 insertions(+), 1 deletions(-)

diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/ServiceOrderMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/ServiceOrderMapper.java
index 409f713..7071286 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/ServiceOrderMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/ServiceOrderMapper.java
@@ -1,11 +1,17 @@
 package com.ruoyi.system.mapper;
 
 import java.util.List;
+import java.util.Map;
+
 import com.ruoyi.system.domain.ServiceOrder;
+import com.ruoyi.common.annotation.DataSource;
+import com.ruoyi.common.enums.DataSourceType;
+import org.apache.ibatis.annotations.Param;
 
 /**
  * 鏈嶅姟璁㈠崟Mapper鎺ュ彛
  */
+@DataSource(DataSourceType.SQLSERVER)
 public interface ServiceOrderMapper {
     /**
      * 鏌ヨ鏈嶅姟璁㈠崟
@@ -19,9 +25,21 @@
      * 鏌ヨ鏈嶅姟璁㈠崟鍒楄〃
      * 
      * @param serviceOrder 鏈嶅姟璁㈠崟
+     * @param offset 璧峰浣嶇疆
+     * @param pageSize 姣忛〉澶у皬
      * @return 鏈嶅姟璁㈠崟闆嗗悎
      */
-    public List<ServiceOrder> selectServiceOrderList(ServiceOrder serviceOrder);
+    public List<ServiceOrder> selectServiceOrderList(@Param("serviceOrder") ServiceOrder serviceOrder, 
+                                                    @Param("offset") int offset, 
+                                                    @Param("pageSize") int pageSize);
+
+    /**
+     * 鏌ヨ鏈嶅姟璁㈠崟鎬绘暟
+     * 
+     * @param serviceOrder 鏈嶅姟璁㈠崟淇℃伅
+     * @return 鏈嶅姟璁㈠崟鎬绘暟
+     */
+    public int selectServiceOrderCount(@Param("serviceOrder") ServiceOrder serviceOrder);
 
     /**
      * 鏂板鏈嶅姟璁㈠崟
@@ -54,4 +72,32 @@
      * @return 缁撴灉
      */
     public int deleteServiceOrderByIds(Long[] serviceOrdIds);
+    
+    /**
+     * 鏇存柊鏈嶅姟璁㈠崟鍙栨秷淇℃伅
+     * 
+     * @param serviceOrdId 鏈嶅姟璁㈠崟ID
+     * @param cancelReason 鍙栨秷鍘熷洜ID
+     * @param cancelReasonText 鍙栨秷鍘熷洜鏂囨湰
+     * @return 褰卞搷琛屾暟
+     */
+    public int updateServiceOrderCancelInfo(@Param("serviceOrdId") Long serviceOrdId, 
+                                           @Param("cancelReason") Integer cancelReason,
+                                           @Param("cancelReasonText") String cancelReasonText);
+    
+    /**
+     * 鏍规嵁鏈嶅姟璁㈠崟ID鏌ヨ璁㈠崟鐘舵��
+     * 
+     * @param serviceOrdId 鏈嶅姟璁㈠崟ID
+     * @return 璁㈠崟鐘舵�佺爜
+     */
+    public Integer selectServiceOrderStateById(Long serviceOrdId);
+
+    /**
+     * 鏍规嵁鏈嶅姟璁㈠崟ID鏌ヨ鍙栨秷淇℃伅
+     * 
+     * @param serviceOrdId 鏈嶅姟璁㈠崟ID
+     * @return 鍙栨秷淇℃伅
+     */
+    public Map<String, Object> selectServiceCancelInfoById(Long serviceOrdId);
 } 
\ No newline at end of file

--
Gitblit v1.9.1