From 89c6a02c36153a85b15e016650526fa795a551bf Mon Sep 17 00:00:00 2001
From: buli <137736985@qq.com>
Date: 星期二, 23 五月 2023 11:37:45 +0800
Subject: [PATCH] signfunctionbackup

---
 force-app/main/default/classes/DNUpsertBatch.cls |   37 ++++++++++++++++++++++++++++++++-----
 1 files changed, 32 insertions(+), 5 deletions(-)

diff --git a/force-app/main/default/classes/DNUpsertBatch.cls b/force-app/main/default/classes/DNUpsertBatch.cls
index 66ba7d8..b23a318 100644
--- a/force-app/main/default/classes/DNUpsertBatch.cls
+++ b/force-app/main/default/classes/DNUpsertBatch.cls
@@ -291,11 +291,12 @@
             Map < String, String > provinceGIMap = new Map< String, String > ();
             //妫�绱CSM绠$悊鐪佸璞�
             //闆嗕腑閲囪喘璇环 澧炲姞妫�绱㈠姪鐞� 
-            List < OCM_Management_Province__c > ompList = [select id, Name, SalesManage__c,GI_assistant__c   from OCM_Management_Province__c ];
+            List < OCM_Management_Province__c > ompList = [select id, Name, SalesManage__c,GI_assistant__c,Window1__c   from OCM_Management_Province__c ];
             //瀛樻斁map<鐪侊紝鎷呭綋>
             for (OCM_Management_Province__c omp: ompList) {
                 provinceOwnerMap.put(omp.Name, omp.SalesManage__c);
-                provinceGIMap.put(omp.Name,omp.GI_assistant__c);
+                //provinceGIMap.put(omp.Name,omp.GI_assistant__c); //Commented by Li Jun 20230420
+                provinceGIMap.put(omp.Name, omp.Window1__c);// Add By Li Jun 鏇存柊 绛炬敹鍗曠殑銆愯惀涓氬姪鐞嗐�戝�硷紝浠嶰CSM绠$悊鐪佸搴旂殑銆愯惀涓氱獥鍙c�戝瓧娈佃幏鍙�
             }
             // 鐢靛瓙绛炬敹鍗� end
 
@@ -573,12 +574,30 @@
                  Statu_Achievements__r.orderType__c 
                  //鏃犲伩鍑哄簱鏍囪瘑 thh 2021-11-01 end
                  //acc鏍囪瘑 end
+                 //Add by Li Jun 20230420 start 
+                 ,Opportunity__r.OCM_man_province_cus__c
+                 //Add By Li Jun 20230420 end
                  from Statu_Achievements_DN__c where
                  Name in: DNNoSet];
         return DNList;
     }
     global void finish(Database.BatchableContext BC) {
     }
+
+    //Add By Li Jun 0420 Start query management province
+    private static Map<String,OCM_Management_Province__c> provinceManagementMap{set;get;}
+    public static Map<String,OCM_Management_Province__c> getManagementProvince(){ 
+        if(provinceManagementMap !=null && provinceManagementMap.keySet().size()>0 ){
+            return provinceManagementMap;
+        }
+        provinceManagementMap = new Map<String,OCM_Management_Province__c>();
+        List <OCM_Management_Province__c > ompList = [select id, Name, SalesManage__c,GI_assistant__c,Window1__c   from OCM_Management_Province__c];
+        for (OCM_Management_Province__c omp: ompList) {
+            provinceManagementMap.put(omp.Name,omp);
+        }
+        return provinceManagementMap;
+    }
+      //Add By Li Jun 0420 End
     /* 鏋勫缓绛炬敹鍗曪細
      * eSFMap 鏄郴缁熼噷闈㈢幇鏈夌殑绛炬敹鍗�
      * key 涓� DN鍙凤紱
@@ -603,8 +622,13 @@
             tempeSF.DNName__c = tempDN.Name;
             tempeSF.Statu_Achievements__c = tempDN.Statu_Achievements__c;
             tempeSF.Statu_Achievements_DN__c = tempDN.ID;
-            tempeSF.Sales_assistant_name_text__c = tempDN.Sales_assistant_name_text__c;
+            //Updated By Li Jun 20230420 start 
+            //tempeSF.Sales_assistant_name_text__c = tempDN.Sales_assistant_name_text__c;
+            tempeSF.Sales_assistant_name_text__c = tempDN.Opportunity__c != null && tempDN.Opportunity__r.OCM_man_province_cus__c != '' && getManagementProvince().containsKey(tempDN.Opportunity__r.OCM_man_province_cus__c)? 
+                                                    getManagementProvince().get(tempDN.Opportunity__r.OCM_man_province_cus__c).Window1__c: null;
+            
             tempeSF.RC_Manager__c = tempDN.RC_Manager__c;
+            //Updated By Li Jun 20230420 end
             //鐢熸垚绛炬敹鍗曟椂锛岀粰鏄惁鏃犲伩鍑哄簱璧嬪��  绮剧悽鎶�鏈� thh 2021-10-15 start
             if(tempDN.Statu_Achievements__r.orderType__c == 'ZM16'){
                 tempeSF.isFreeDelivery__c = true;
@@ -730,11 +754,14 @@
                     tempSADN.Is_Corrosion__c=opp.Is_Corrosion__c;
                     // 鐢靛瓙绛炬敹鍗�  璧嬪�艰惀涓氬姪鐞嗗拰钀ヤ笟绠$悊閮ㄦ媴褰� start
                     //闆嗕腑閲囪喘鐨勮浠� 绮剧悽鎶�鏈� wql 2020/01/11 start 
+                    //Add By Li Jun 20230420 Start 
+                    tempSADN.Sales_assistant_name_text__c =opp.OCM_man_province_cus__c!='' && provinceGIMap.containskey(opp.OCM_man_province_cus__c)?provinceGIMap.get(opp.OCM_man_province_cus__c):null;
+                    //Add By Li Jun 20230420 End
                     if(opp.Group_purchase_PCL__c){
-                        tempSADN.Sales_assistant_name_text__c = provinceGIMap.get('闆嗛噰璇�');
+                        //tempSADN.Sales_assistant_name_text__c = provinceGIMap.get('闆嗛噰璇�'); //Commented By Li Jun 20230420
                         tempSADN.RC_Manager__c =  provinceOwnerMap.get('闆嗛噰璇�');
                     }else{
-                        tempSADN.Sales_assistant_name_text__c = opp.Sales_assistant_name_text__c;
+                        //tempSADN.Sales_assistant_name_text__c = opp.Sales_assistant_name_text__c; //Commented By Li Jun 20230420
                         tempSADN.RC_Manager__c =  provinceOwnerMap.get(opp.OCM_man_province_cus__c);
                     }
                     //闆嗕腑閲囪喘鐨勮浠� 绮剧悽鎶�鏈� wql 2020/01/11 end

--
Gitblit v1.9.1