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_ScoreTableHistory_Batch3.cls | 56 ++++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 48 insertions(+), 8 deletions(-)
diff --git a/force-app/main/default/classes/ET_Product_ScoreTableHistory_Batch3.cls b/force-app/main/default/classes/ET_Product_ScoreTableHistory_Batch3.cls
index c41c98f..2b68bc1 100644
--- a/force-app/main/default/classes/ET_Product_ScoreTableHistory_Batch3.cls
+++ b/force-app/main/default/classes/ET_Product_ScoreTableHistory_Batch3.cls
@@ -163,10 +163,10 @@
delete pcts;
// Id devRecordTypeId = Schema.SObjectType.Account.getRecordTypeInfosByDeveloperName().get('Agency').getRecordTypeId();
-
+ // ETAPP閲嶇偣浜у搧鎷嗗垎 fy start Consumable_product__r.Product2__r.Category5__c
String query =
' SELECT Detail_Count__c, Intra_Trade_Without_Tax__c, Dealer_Info_text__c, Dealer_Info_ID__c, OCM_man_province__c, HospItal_Name__c, HospItal_Code__c, Hospital_ID__c, Consumable_product__c, Deliver_date__c, Asset_Model_No__c, ' +
- ' Consumable_product__r.Product2__r.Category3__c, Consumable_product__r.Product2__r.Category4__c,Consumable_product__r.Product2__r.Plan_Term__c,Consumable_Sale_order__r.Opportunity__r.Sales_Root__c' +
+ ' Consumable_product__r.Product2__r.Category3__c, Consumable_product__r.Product2__r.Category4__c,Consumable_product__r.Product2__r.Category5__c,Consumable_product__r.Product2__r.Plan_Term__c,Consumable_Sale_order__r.Opportunity__r.Sales_Root__c' +
' FROM Consumable_order_details2__c '+
' WHERE (NOT Dealer_Info_text__c LIKE \'%TEST%\') ';
// if (true != this.isAllFlag) {
@@ -196,7 +196,8 @@
List<String> pstIdList = new List<String>();
for (Consumable_order_details2__c cod : codList) {
String pSTUniqueKey = term + ':' + cod.Consumable_product__r.Product2__r.Category3__c + ':';
- pstIdList.add(uniqueCalculate(pSTUniqueKey, cod.Consumable_product__r.Product2__r.Category4__c, cod.Consumable_product__r.Product2__r.Category3__c, cod.Asset_Model_No__c));
+ // ETAPP閲嶇偣浜у搧鎷嗗垎 fy start Consumable_product__r.Product2__r.Category5__c
+ pstIdList.add(uniqueCalculate(pSTUniqueKey,cod.Consumable_product__r.Product2__r.Category5__c, cod.Consumable_product__r.Product2__r.Category4__c, cod.Consumable_product__r.Product2__r.Category3__c, cod.Asset_Model_No__c));
}
Map<String, Product_Score_Table__c> pstIdMap = new Map<String, Product_Score_Table__c>();
for(Product_Score_Table__c tmpObj : [SELECT Id, UniqueKey__c
@@ -231,7 +232,8 @@
//uniqueKeyATR : U:璁＄敾璐㈠勾(151P):鍙戣揣鏈�:OCM绠＄悊鐪�:鍖婚櫌:缁忛攢鍟�:绗笁鍒嗙被 :鏂�4.5鍒嗙被
String uniqueKeyPSTH = 'U:' + term + ':' + cod.Deliver_date__c.month() + ':' + cod.OCM_man_province__c + ':' + cod.HospItal_Code__c + ':' + cod.Dealer_Info_ID__c + ':' + cod.Consumable_product__r.Product2__r.Category3__c + ':';
- uniqueKeyPSTH = uniqueCalculate(uniqueKeyPSTH, cod.Consumable_product__r.Product2__r.Category4__c, cod.Consumable_product__r.Product2__r.Category3__c, cod.Asset_Model_No__c);
+ // ETAPP閲嶇偣浜у搧鎷嗗垎 fy start Consumable_product__r.Product2__r.Category5__c
+ uniqueKeyPSTH = uniqueCalculate(uniqueKeyPSTH, cod.Consumable_product__r.Product2__r.Category5__c,cod.Consumable_product__r.Product2__r.Category4__c, cod.Consumable_product__r.Product2__r.Category3__c, cod.Asset_Model_No__c);
// Shipping_date__c yyyy/mm/01
Date sd = Date.newInstance(cod.Deliver_date__c.year(), cod.Deliver_date__c.month(), 1);
@@ -247,7 +249,8 @@
//浜у搧寰楀垎琛� step: soql map id
String pstUniqueKey = term + ':' + cod.Consumable_product__r.Product2__r.Category3__c + ':';
- pstUniqueKey = uniqueCalculate(pstUniqueKey, cod.Consumable_product__r.Product2__r.Category4__c, cod.Consumable_product__r.Product2__r.Category3__c, cod.Asset_Model_No__c);
+ // ETAPP閲嶇偣浜у搧鎷嗗垎 fy start Consumable_product__r.Product2__r.Category5__c
+ pstUniqueKey = uniqueCalculate(pstUniqueKey, cod.Consumable_product__r.Product2__r.Category5__c,cod.Consumable_product__r.Product2__r.Category4__c, cod.Consumable_product__r.Product2__r.Category3__c, cod.Asset_Model_No__c);
if (pstIdMap.containsKey(pstUniqueKey)) {
psth.Product_Score_Table__c = pstIdMap.get(pstUniqueKey).Id;
}
@@ -353,8 +356,8 @@
eb.send();
System.debug('ET_Product_ScoreTableHistory_Batch3 finish method end');
}
-
- private static String uniqueCalculate(String uniqueKey, String category4, String category3, String assetModelNo) {
+ // ETAPP閲嶇偣浜у搧鎷嗗垎 fy start Consumable_product__r.Product2__r.Category5__c
+ private static String uniqueCalculate(String uniqueKey,String category5, String category4, String category3, String assetModelNo) {
if ('鍚稿紩娲绘閽�' == category4 && 'EUS' == category3) {
if (assetModelNo.startsWith('NA-U200H')) {
uniqueKey += '鍚稿紩娲绘閽�-EZ3P';
@@ -367,7 +370,44 @@
} else {
uniqueKey += '鍏堢绯荤矘鑶滃垏寮�鍒�-DualJ浠ュ';
}
- } else {
+ }
+ // ETAPP閲嶇偣浜у搧鎷嗗垎 fy start
+ else if('瀵间笣' == category4){
+ if (assetModelNo.startsWith('G-240')) {
+ uniqueKey += '瀵间笣-G-240';
+ }else{
+ uniqueKey += '瀵间笣-G-260';
+ }
+ }
+ else if('涔冲ご鍒囧紑鍒�' == category4){
+ if(category5.contains('涔冲ご鍒囧紑-涓夎厰')){
+ uniqueKey +='涔冲ご鍒囧紑鍒�-涓夎厰';
+ }else{
+ uniqueKey +='涔冲ご鍒囧紑鍒�-鍏朵粬';
+ }
+ } else if('娉ㄥ皠閽堬紙鑳冮暅锛�'== category4){
+ if (assetModelNo.startsWith('NM-20')){
+ uniqueKey += '娉ㄥ皠閽堬紙鑳冮暅锛�-200';
+ }else{
+ uniqueKey += '娉ㄥ皠閽堬紙鑳冮暅锛�-400';
+ }
+ }
+ else if('娉ㄥ皠閽堬紙鑲犻暅锛�'== category4){
+ if (assetModelNo.startsWith('NM-20')){
+ uniqueKey += '娉ㄥ皠閽堬紙鑲犻暅锛�-200';
+ }else{
+ uniqueKey += '娉ㄥ皠閽堬紙鑲犻暅锛�-400';
+ }
+ }
+ else if('鍛煎惛绉慐T'==category3 && '鍚稿紩娲绘閽�'==category4){
+ if(assetModelNo.startsWith('NA-U401SX')||assetModelNo.startsWith('NA-U403SX')){
+ uniqueKey +='鍚稿紩娲绘閽�-Visishot2';
+ }else{
+ uniqueKey +='鍚稿紩娲绘閽�-Visishot2浠ュ';
+ }
+ }
+ // ETAPP閲嶇偣浜у搧鎷嗗垎 fy end
+ else {
uniqueKey += category4;
}
--
Gitblit v1.9.1