From 973032dc914e84cec5ab18c4c23784a77599b2bc Mon Sep 17 00:00:00 2001
From: hjg <hjg@123.com>
Date: 星期五, 17 一月 2025 16:53:48 +0800
Subject: [PATCH] Revert "CRM>分单系统销售退货单同步"
---
JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java | 13 ++++++++++++-
1 files changed, 12 insertions(+), 1 deletions(-)
diff --git a/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java b/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java
index b056fd7..29738eb 100644
--- a/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java
+++ b/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java
@@ -167,14 +167,25 @@
public List<Map> getHwList(String sdepartNo);
/** 涔夌憺銆佺鎶�LED鏄剧ず 搴忓彿 杞﹀彿 瑁呰溅鍖� 鐘舵�� **/
+ @Deprecated
@Select({
"select bs.numberplates,businessNo,zcWz,firstzxhtime," ,
"case WHEN EXISTS ( SELECT * FROM bussinessitems WHERE bussinessNo = x.businessNo ) THEN '鍦ㄨ'" ,
" when x.firstgbtime is not null then '寰呰' else '瀹屾垚' end zcStatus " ,
" from xs_taskmonitor x" ,
" join bussinesssheet bs on x.businessNo=bs.bussinessNo and bs.sstatus='鍦ㄥ姙' " ,
- " where sdepartNo=#{sdepartNo} and firstgbtime is not null and x.lastgbtime is null "
+ " where sdepartNo=#{sdepartNo} and firstgbtime is not null and x.lastgbtime is null order by jctime"
})
public List<Map> yRZcList(String sdepartNo);
+ // 涔夌憺銆佺鎶�LED鏄剧ず 绉戞妧杞﹁締杩涘巶鍚庢樉绀虹瓑寰咃紝鎵爜鍚庢樉绀鸿杞︼紝浜屾杩囩鍚庝笉鍐嶆樉绀�
+ @Select({
+ "select bs.numberplates,businessNo,zcWz,firstzxhtime," ,
+ "case WHEN EXISTS ( SELECT * FROM bussinessitems WHERE bussinessNo = x.businessNo ) THEN '瑁呰溅'" ,
+ " when x.jctime is not null then '绛夊緟' else '' end zcStatus " ,
+ " from xs_taskmonitor x" ,
+ " join bussinesssheet bs on x.businessNo=bs.bussinessNo and bs.sstatus='鍦ㄥ姙' " ,
+ " where sdepartNo=#{sdepartNo} and jctime is not null and x.lastgbtime is null order by jctime"
+ })
+ public List<Map> kjZcList(String sdepartNo);
}
--
Gitblit v1.9.3