From 11e66b7bb5b4a12339dbbbaf3f7d52edcd2ef9bb Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期四, 03 七月 2025 12:45:01 +0800
Subject: [PATCH] 1

---
 src/main/resources/mapper/LocDetlMapper.xml |  141 ++++++++++++++++++++++++-----------------------
 1 files changed, 72 insertions(+), 69 deletions(-)

diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 42dec5e..9deabb8 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -447,8 +447,9 @@
         </if>
 
         order by
-        a.anfme asc,DATEPART(yyyy,a.modi_time),DATEPART(mm,a.modi_time),DATEPART(dd,a.modi_time)
-        desc,
+        sku,
+        <!-- a.anfme asc,DATEPART(yyyy,a.modi_time),DATEPART(mm,a.modi_time),DATEPART(dd,a.modi_time)
+        desc,-->
         NEWID(),
         case
         when (left(a.loc_no, 2) = '01') then 0
@@ -545,72 +546,73 @@
         </if>
 
         order by
-        DATEPART(yyyy,a.modi_time),DATEPART(mm,a.modi_time),DATEPART(dd,a.modi_time), a.anfme
-        desc,
-        NEWID(),
-        case
-        when (left(a.loc_no, 2) = '01') then 0
-        when (left(a.loc_no, 2) = '02') then 1
-        when (left(a.loc_no, 2) = '03') then 1
-        when (left(a.loc_no, 2) = '04') then 0
-        when (left(a.loc_no, 2) = '05') then 0
-        when (left(a.loc_no, 2) = '06') then 1
-        when (left(a.loc_no, 2) = '07') then 1
-        when (left(a.loc_no, 2) = '08') then 0
-        when (left(a.loc_no, 2) = '09') then 0
-        when (left(a.loc_no, 2) = '10') then 1
-        when (left(a.loc_no, 2) = '11') then 1
-        when (left(a.loc_no, 2) = '12') then 0
-        when (left(a.loc_no, 2) = '13') then 0
-        when (left(a.loc_no, 2) = '14') then 1
-        when (left(a.loc_no, 2) = '15') then 1
-        when (left(a.loc_no, 2) = '16') then 0
-        when (left(a.loc_no, 2) = '17') then 0
-        when (left(a.loc_no, 2) = '18') then 1
-        when (left(a.loc_no, 2) = '19') then 1
-        when (left(a.loc_no, 2) = '20') then 0
-        when (left(a.loc_no, 2) = '21') then 0
-        when (left(a.loc_no, 2) = '22') then 1
-        when (left(a.loc_no, 2) = '23') then 1
-        when (left(a.loc_no, 2) = '24') then 0
-        when (left(a.loc_no, 2) = '25') then 0
-        when (left(a.loc_no, 2) = '26') then 1
-        when (left(a.loc_no, 2) = '27') then 1
-        when (left(a.loc_no, 2) = '28') then 0
-        when (left(a.loc_no, 2) = '29') then 0
-        when (left(a.loc_no, 2) = '30') then 1
-        when (left(a.loc_no, 2) = '31') then 1
-        when (left(a.loc_no, 2) = '32') then 0
-        when (left(a.loc_no, 2) = '33') then 0
-        when (left(a.loc_no, 2) = '34') then 1
-        when (left(a.loc_no, 2) = '35') then 1
-        when (left(a.loc_no, 2) = '36') then 0
-        when (left(a.loc_no, 2) = '37') then 0
-        when (left(a.loc_no, 2) = '38') then 1
-        when (left(a.loc_no, 2) = '39') then 1
-        when (left(a.loc_no, 2) = '40') then 0
-        when (left(a.loc_no, 2) = '41') then 0
-        when (left(a.loc_no, 2) = '42') then 1
-        when (left(a.loc_no, 2) = '43') then 1
-        when (left(a.loc_no, 2) = '44') then 0
-        when (left(a.loc_no, 2) = '45') then 0
-        when (left(a.loc_no, 2) = '46') then 1
-        when (left(a.loc_no, 2) = '47') then 1
-        when (left(a.loc_no, 2) = '48') then 0
-        else 0
-        end
-        desc
-    </select>
+            sku,
+        <!--  DATEPART(yyyy,a.modi_time),DATEPART(mm,a.modi_time),DATEPART(dd,a.modi_time), a.anfme
+       desc, -->
+       NEWID(),
+       case
+       when (left(a.loc_no, 2) = '01') then 0
+       when (left(a.loc_no, 2) = '02') then 1
+       when (left(a.loc_no, 2) = '03') then 1
+       when (left(a.loc_no, 2) = '04') then 0
+       when (left(a.loc_no, 2) = '05') then 0
+       when (left(a.loc_no, 2) = '06') then 1
+       when (left(a.loc_no, 2) = '07') then 1
+       when (left(a.loc_no, 2) = '08') then 0
+       when (left(a.loc_no, 2) = '09') then 0
+       when (left(a.loc_no, 2) = '10') then 1
+       when (left(a.loc_no, 2) = '11') then 1
+       when (left(a.loc_no, 2) = '12') then 0
+       when (left(a.loc_no, 2) = '13') then 0
+       when (left(a.loc_no, 2) = '14') then 1
+       when (left(a.loc_no, 2) = '15') then 1
+       when (left(a.loc_no, 2) = '16') then 0
+       when (left(a.loc_no, 2) = '17') then 0
+       when (left(a.loc_no, 2) = '18') then 1
+       when (left(a.loc_no, 2) = '19') then 1
+       when (left(a.loc_no, 2) = '20') then 0
+       when (left(a.loc_no, 2) = '21') then 0
+       when (left(a.loc_no, 2) = '22') then 1
+       when (left(a.loc_no, 2) = '23') then 1
+       when (left(a.loc_no, 2) = '24') then 0
+       when (left(a.loc_no, 2) = '25') then 0
+       when (left(a.loc_no, 2) = '26') then 1
+       when (left(a.loc_no, 2) = '27') then 1
+       when (left(a.loc_no, 2) = '28') then 0
+       when (left(a.loc_no, 2) = '29') then 0
+       when (left(a.loc_no, 2) = '30') then 1
+       when (left(a.loc_no, 2) = '31') then 1
+       when (left(a.loc_no, 2) = '32') then 0
+       when (left(a.loc_no, 2) = '33') then 0
+       when (left(a.loc_no, 2) = '34') then 1
+       when (left(a.loc_no, 2) = '35') then 1
+       when (left(a.loc_no, 2) = '36') then 0
+       when (left(a.loc_no, 2) = '37') then 0
+       when (left(a.loc_no, 2) = '38') then 1
+       when (left(a.loc_no, 2) = '39') then 1
+       when (left(a.loc_no, 2) = '40') then 0
+       when (left(a.loc_no, 2) = '41') then 0
+       when (left(a.loc_no, 2) = '42') then 1
+       when (left(a.loc_no, 2) = '43') then 1
+       when (left(a.loc_no, 2) = '44') then 0
+       when (left(a.loc_no, 2) = '45') then 0
+       when (left(a.loc_no, 2) = '46') then 1
+       when (left(a.loc_no, 2) = '47') then 1
+       when (left(a.loc_no, 2) = '48') then 0
+       else 0
+       end
+       desc
+   </select>
 
-    <select id="queryStockFour" resultMap="BaseResultMap">
-        select a.*
-        from asr_loc_detl a
-        left join asr_loc_mast b on a.loc_no = b.loc_no
-        where 1=1
-        and b.loc_sts = 'F'
-        and a.matnr = #{matnr}
-        and b.crn_no in (7)
-        <!--        <choose>-->
+   <select id="queryStockFour" resultMap="BaseResultMap">
+       select a.*
+       from asr_loc_detl a
+       left join asr_loc_mast b on a.loc_no = b.loc_no
+       where 1=1
+       and b.loc_sts = 'F'
+       and a.matnr = #{matnr}
+       and b.crn_no in (7)
+       <!--        <choose>-->
         <!--            <when test="batch != null and batch != ''">-->
         <!--                and a.batch = #{batch}-->
         <!--            </when>-->
@@ -642,8 +644,9 @@
         </if>
 
         order by
-        DATEPART(yyyy,a.modi_time),DATEPART(mm,a.modi_time),DATEPART(dd,a.modi_time), a.anfme
-        desc,
+       sku,
+       <!--  DATEPART(yyyy,a.modi_time),DATEPART(mm,a.modi_time),DATEPART(dd,a.modi_time), a.anfme
+      desc, -->
         NEWID(),
         case
         when (left(a.loc_no, 2) = '01') then 0

--
Gitblit v1.9.1