From 18c7a44d2e9db3f4a5322389c3ee94468cce4de1 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期二, 06 五月 2025 10:10:06 +0800
Subject: [PATCH] feat: 新增获取状态写入库，供广交集团的接口使用

---
 Report_WXCXOrdAnalysis_Data.php |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/Report_WXCXOrdAnalysis_Data.php b/Report_WXCXOrdAnalysis_Data.php
index fa3855b..87e0bbc 100644
--- a/Report_WXCXOrdAnalysis_Data.php
+++ b/Report_WXCXOrdAnalysis_Data.php
@@ -56,7 +56,7 @@
 ,ServiceOrdTraTxnPrice as OrdSumPrice
 ,OrdSumPriceDel=(select sum(ServiceOrdTraTxnPrice) from ServiceOrder as b where ServiceOrdState=4 and a.ServiceOrdID=b.ServiceOrdID)
 from ServiceOrder as a 
-where ((ServiceOrdCancelReason<>10 or ServiceOrdCancelReason is null) and (ServiceOrdCancelReasonTXT<>'鑷姩鍙栨秷' or ServiceOrdCancelReasonTXT is null)) and (ServiceOrdOperationRemarks<>'[瀹㈡埛鏈寮忔彁浜ら渶姹傦紝鍙笉鑱旂郴]' or ServiceOrdOperationRemarks is null) and ServiceOrdUserID not in (4,53) and ServiceOrd_CC_Time ".$SqlDateType." and ServiceOrdSource=5
+where ((ServiceOrdCancelReason<>10 or ServiceOrdCancelReason is null) and (ServiceOrdCancelReasonTXT<>'鑷姩鍙栨秷' or ServiceOrdCancelReasonTXT is null)) and (ServiceOrdOperationRemarks<>'[瀹㈡埛鏈寮忔彁浜ら渶姹傦紝鍙笉鑱旂郴]' or ServiceOrdOperationRemarks is null) and ServiceOrdUserID not in (4,53,116368,93481) and ServiceOrd_CC_Time ".$SqlDateType." and ServiceOrdSource=5
 ) as aa GROUP BY SourceName,UserSource";
 //echo $sql;//exit;
 $data = sqlsrv_query($conn,$sql);

--
Gitblit v1.9.1