From d8dc84a3d56df839895f1c417a4d9cbee763d262 Mon Sep 17 00:00:00 2001
From: 高章伟 <gaozhangwei@prec-tech.com>
Date: 星期五, 03 三月 2023 14:50:59 +0800
Subject: [PATCH] gzw 测试环境代码更新

---
 force-app/main/default/classes/ET_Product_CategoryPrice_Table_Batch.cls |   41 +++++++++++++++++++++++++++++++++++++++--
 1 files changed, 39 insertions(+), 2 deletions(-)

diff --git a/force-app/main/default/classes/ET_Product_CategoryPrice_Table_Batch.cls b/force-app/main/default/classes/ET_Product_CategoryPrice_Table_Batch.cls
index ae7da7c..fc2d8a8 100644
--- a/force-app/main/default/classes/ET_Product_CategoryPrice_Table_Batch.cls
+++ b/force-app/main/default/classes/ET_Product_CategoryPrice_Table_Batch.cls
@@ -52,15 +52,16 @@
          *  }
          *  瀛楁
          */
-
+        // ETAPP閲嶇偣浜у搧鎷嗗垎 fy start Category5__c
         String query = 'SELECT Id, Intra_Trade_List_RMB__c, Asset_Model_No__c,' +
-                        ' Category3__c, Category4__c, Plan_Term__c' +
+                        ' Category3__c, Category4__c,Category5__c, Plan_Term__c' +
                         ' FROM Product2' +
                         ' where Is_ET_APP__c = true ';
         // if (true != this.isAllFlag) {
         //        query += ' and LastModifiedDate >= :systemDate ';
         // }
                query += ' and Category3__c <> \'\' ' +
+                        ' and Category5__c !=\'绔炰簤瀵规墜\''+
                         ' and SFDA_Status__c in :s';
         return Database.getQueryLocator(query);
     }
@@ -93,6 +94,42 @@
                         uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':鍏堢绯荤矘鑶滃垏寮�鍒�-DualJ浠ュ';
                     }
                 }
+                // ETAPP閲嶇偣浜у搧鎷嗗垎 fy start
+                else if ('瀵间笣' == pd.Category4__c ) {
+                    if (pd.Asset_Model_No__c.startsWith('G-240')) {
+                        uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':瀵间笣-G-240';
+                    }else{
+                        uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':瀵间笣-G-260';
+                    }
+                }
+                else if('涔冲ご鍒囧紑鍒�' == pd.Category4__c){
+                    if(pd.Category5__c.contains('涔冲ご鍒囧紑-涓夎厰')){
+                        uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':涔冲ご鍒囧紑鍒�-涓夎厰';
+                    }else{
+                        uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':涔冲ご鍒囧紑鍒�-鍏朵粬';
+                    }
+                } else if('娉ㄥ皠閽堬紙鑳冮暅锛�'== pd.Category4__c){
+                    if (pd.Asset_Model_No__c.startsWith('NM-20')){
+                        uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':娉ㄥ皠閽堬紙鑳冮暅锛�-200';
+                    }else{
+                        uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':娉ㄥ皠閽堬紙鑳冮暅锛�-400';
+                    }
+                } 
+                else if('娉ㄥ皠閽堬紙鑲犻暅锛�'== pd.Category4__c){
+                    if (pd.Asset_Model_No__c.startsWith('NM-20')){
+                        uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':娉ㄥ皠閽堬紙鑲犻暅锛�-200';
+                    }else{
+                        uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':娉ㄥ皠閽堬紙鑲犻暅锛�-400';
+                    }
+                }
+                else if('鍛煎惛绉慐T'==pd.Category3__c && '鍚稿紩娲绘閽�'==pd.Category4__c){
+                    if(pd.Asset_Model_No__c.startsWith('NA-U401SX')||pd.Asset_Model_No__c.startsWith('NA-U403SX')){
+                        uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':鍚稿紩娲绘閽�-Visishot2';
+                    }else{
+                        uniKey = pd.Plan_Term__c.left(4) + ':' + pd.Category3__c + ':鍚稿紩娲绘閽�-Visishot2浠ュ';
+                    }
+                }
+                // ETAPP閲嶇偣浜у搧鎷嗗垎 fy end
 
                 if(uniKeyToPDListMap.get(uniKey) == null){
                     uniKeyToPDListMap.put(uniKey,new List<Product2>());

--
Gitblit v1.9.1