From 0f44cb1a0b7b36860e9ce81c1eac9e395d87f0b4 Mon Sep 17 00:00:00 2001
From: buli <137736985@qq.com>
Date: 星期一, 05 六月 2023 13:53:18 +0800
Subject: [PATCH] mergecode into lex dtt
---
force-app/main/default/classes/OpdAmountBatch.cls | 134 ++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 128 insertions(+), 6 deletions(-)
diff --git a/force-app/main/default/classes/OpdAmountBatch.cls b/force-app/main/default/classes/OpdAmountBatch.cls
index 69310ef..8c0862d 100644
--- a/force-app/main/default/classes/OpdAmountBatch.cls
+++ b/force-app/main/default/classes/OpdAmountBatch.cls
@@ -91,6 +91,7 @@
}
global void execute(Database.BatchableContext BC, List<sObject> dcList) {
+
List<Account_Number_of_target__c> upsertList = new List<Account_Number_of_target__c>();
//WLIG-BZD684 銆愬鎵樸�慔灞傚鎴� 鎴樼暐绉戝 鐥呬緥鏁拌嚜杩愯 gwy 2021-03-25 start
List<Account_Number_of_case__c> insertNextList = new List<Account_Number_of_case__c>();
@@ -145,6 +146,8 @@
}
public static List<Account_Number_of_target__c> main(List<sObject> dcList) {
+ system.debug('==dcList=='+dcList.size()+'======'+dcList);
+ //浠ユ垬鐣ョ瀹ゅ緱褰㈠紡锛屼竴娆¤繘鏉�1鏉℃暟鎹�
List<Account2__c> acc2List = [select id,
Account_Org__c,
Account_Org__r.Department_Class_Label__c,
@@ -177,6 +180,10 @@
OPD_ESG400__c,
OPD_TB__c,
// LHJ End
+ //20220602 WLIG-CEWDWS you start
+ OPD_TB_0520__c,
+ OPD_TB_0535__c,
+ //20220602 WLIG-CEWDWS you end
Opp_Actual_ThousandY__c,
BO_Forecast_ThousandY__c,
OP_ThousandY__c,
@@ -275,6 +282,10 @@
Delivery_cnt_OTVS300__c,
Delivery_cnt_ESG400__c,
Delivery_cnt_TB__c,
+ //20220602 WLIG-CEWDWS you start
+ Delivery_cnt_TB_0520__c,
+ Delivery_cnt_TB_0535__c,
+ //20220602 WLIG-CEWDWS you end
Opp_cnt_290MiroBF__c,
Opp_cnt_290MiroGI__c,
Opp_cnt_290MiroGI_CF__c,
@@ -283,6 +294,10 @@
Opp_cnt_OTVS300__c,
Opp_cnt_ESG400__c,
Opp_cnt_TB__c,
+ //20220602 WLIG-CEWDWS you start
+ Opp_cnt_TB_0520__c,
+ Opp_cnt_TB_0535__c,
+ //20220602 WLIG-CEWDWS you end
Order_cnt_290MiroBF__c,
Order_cnt_290MiroGI__c,
Order_cnt_290MiroGI_CF__c,
@@ -291,6 +306,10 @@
Order_cnt_OTVS300__c,
Order_cnt_ESG400__c,
Order_cnt_TB__c,
+ //20220602 WLIG-CEWDWS you start
+ Order_cnt_TB_0520__c,
+ Order_cnt_TB_0535__c,
+ //20220602 WLIG-CEWDWS you end
Rental_Cnt_290MiroBF__c,
Rental_Cnt_290MiroGI__c,
Rental_Cnt_290MiroGI_CF__c,
@@ -322,14 +341,29 @@
Asset_Cnt_OTVS300__c,
Asset_Cnt_OTVS400__c,
Asset_Cnt_TB__c,
+ //20220602 WLIG-CEWDWS you start
+ Asset_Cnt_TB_0520__c,
+ Asset_Cnt_TB_0535__c,
+ //20220602 WLIG-CEWDWS you end
Asset_Cnt_USG400__c,
//SWAG-C9WCE5 鎴樼暐绉戝鍜岀洰鏍囧鎴疯瀹氶〉闈㈠鍔犲瓧娈� lt 20211228 start
AllHostsNumber__c,
RivalHostsNumber__c
//SWAG-C9WCE5 鎴樼暐绉戝鍜岀洰鏍囧鎴疯瀹氶〉闈㈠鍔犲瓧娈� lt 20211228 end
- //SWAG-BSC5WP you-20201021 start
+ //SWAG-BSC5WP you-20201021 end
+ //20230222 DB202302339407 you start
+ ,LostPrices__c
+ ,Dealer_Final_Price__c
+ ,HospitalTransactionAmount__c
+ //20230222 DB202302339407 you end
+ //20230327 DB202303372329 you start
+ ,OP_ThousandY_Order__c
+ ,OrderThisYearQY__c
+ ,Opportunity__c
+ //20230327 DB202303372329 you end
from Account2__c
where Account_Org__c = :dcList];
+
// 2018骞�7鏈�12鏃� SWAG-B2D4QK 浠嶢ccount涓幏鍙� 鎻愭鐩爣瀹㈡埛绛�5涓瓧娈� by 寮犵帀灞�
list<Account> accs = [select Id, Proposal_target_customer__c, Submit_proposal_document_SD__c,
Submit_proposal_document__c, Proposal_target_customer_number__c,
@@ -365,6 +399,33 @@
}
List<Account_Number_of_target__c> upsertList = new List<Account_Number_of_target__c>();
+ //20230224 you start DB202302339407 鎴樼暐绉戝鍏朵粬鐨勭粺璁″埌鏅
+ system.debug('==test0==='+acc2List.size()+'========='+acc2List);
+ //Map<String, Account2__c> acc2QTMap = new Map<String, Account2__c>();
+ Map<String, String> acc2QTMap1 = new Map<String, String>();
+ Map<String, String> acc2QTMap2 = new Map<String, String>();
+ for (Account2__c acc1 : acc2List) {
+ String dclabel1 = acc1.Account_Org__r.Department_Class_Label__c;//鎴樼暐绉戝鍒嗙被
+ //if(null!= dclabel1 && ''!=dclabel1 && dclabel1=='鍏朵粬'){
+ // acc2QTMap.put(acc1.Account_Org__r.ParentId, acc1);//鍙湁鎴樼暐绉戝鏄叾浠栫殑锛堝鎴穒d锛屽鎴�2锛�
+ // system.debug('==test1==='+acc2QTMap);
+ //}
+ if(null!= dclabel1 && ''!=dclabel1 && dclabel1=='鏅绉�'){
+ acc2QTMap1.put(acc1.Account_Org__c,acc1.Account_Org__r.ParentId);
+ acc2QTMap2.put(acc1.Account_Org__r.ParentId,acc1.Account_Org__c);
+ }
+
+ }
+ system.debug(acc2QTMap1+'===test7===='+acc2QTMap1.values());
+ List<Account2__c> acc3List = [select id,
+ Account_Org__c, Account_Org__r.ParentId,LostPrices__c,Dealer_Final_Price__c,HospitalTransactionAmount__c from Account2__c where Account_Org__r.ParentId in :acc2QTMap1.values() and Account_Org__r.Department_Class_Label__c='鍏朵粬'];
+ Map<String, Account2__c> acc2QTMap3 = new Map<String, Account2__c>();
+ for(Account2__c acc3 : acc3List){
+ acc2QTMap3.put(acc2QTMap2.get(acc3.Account_Org__r.ParentId), acc3);
+ }
+
+ system.debug('==test6==='+acc2QTMap3);
+ //20230224 you end DB202302339407
for (Account2__c acc2 : acc2List) {
String dclabel = acc2.Account_Org__r.Department_Class_Label__c;//鎴樼暐绉戝鍒嗙被
Account_Number_of_target__c accTar = new Account_Number_of_target__c();
@@ -432,7 +493,11 @@
accTar.OPD_amount_GFUCT260__c = acc2.OPD_GFUCT260__c;
accTar.OPD_amount_OTVS300__c = acc2.OPD_OTV_S300__c;
accTar.OPD_amount_ESG400__c = acc2.OPD_ESG400__c;
- accTar.OPD_amount_TB__c = acc2.OPD_TB__c;
+ //20220602 WLIG-CEWDWS you start
+ //accTar.OPD_amount_TB__c = acc2.OPD_TB__c;
+ accTar.OPD_amount_TB_0520__c = acc2.OPD_TB_0520__c;
+ accTar.OPD_amount_TB_0535__c = acc2.OPD_TB_0535__c;
+ //20220602 WLIG-CEWDWS you end
// 202020604 LHJ SWAG-BQ75WE End
// SWAG-BC832V 浠庡鎴�2 淇濆瓨鑷崇洰鏍囧鎴凤細CYF start
@@ -448,10 +513,51 @@
accTar.Opportunity_ThousandY__c = acc2.Opportunity_ThousandY__c;
accTar.Amount_Without_Tax_Thousand__c = acc2.Amount_Without_Tax_Thousand__c;
+ //20230327 DB202303372329 you start
+ accTar.OP_ThousandY_Order__c = acc2.OP_ThousandY_Order__c;
+ accTar.OrderThisYearQY__c = acc2.OrderThisYearQY__c;
+ accTar.Opportunity__c = acc2.Opportunity__c;
+ //20230327 DB202303372329 you end
+
//20220111 SWAG-C8MBB6 鍔�7.璇环 lt start
accTar.AllOP_ThousandY__c = acc2.AllOP_ThousandY__c;
//20220111 SWAG-C8MBB6 鍔�7.璇环 lt end
+ //20230222 DB202302339407 you start
+ accTar.LostPrices__c = acc2.LostPrices__c;
+ accTar.Dealer_Final_Price__c = acc2.Dealer_Final_Price__c;
+ accTar.HospitalTransactionAmount__c = acc2.HospitalTransactionAmount__c;
+ //鎴樼暐绉戝鍏朵粬鐨勭粺璁″埌鏅
+ if(dclabel == '鏅绉�'){
+
+ if(null!=acc2QTMap3 && acc2QTMap3.containsKey(acc2.Account_Org__c)){
+ system.debug('==test3==='+acc2.Dealer_Final_Price__c+'==test3==='+acc2QTMap3.get(acc2.Account_Org__c).Dealer_Final_Price__c);
+ //accTar.LostPricesqt__c = acc2.LostPrices__c ==null ? 0 :acc2.LostPrices__c + acc2QTMap3.get(acc2.Account_Org__c).LostPrices__c == null ? 0 : acc2QTMap3.get(acc2.Account_Org__c).LostPrices__c;
+ //accTar.Dealer_Final_Priceqt__c = acc2.Dealer_Final_Price__c ==null ? 0 : acc2.Dealer_Final_Price__c + acc2QTMap3.get(acc2.Account_Org__c).Dealer_Final_Price__c ==null ? 0:acc2QTMap3.get(acc2.Account_Org__c).Dealer_Final_Price__c;
+ //accTar.HospitalTransactionAmountqt__c = acc2.HospitalTransactionAmount__c ==null ? 0 : acc2.HospitalTransactionAmount__c + acc2QTMap3.get(acc2.Account_Org__c).HospitalTransactionAmount__c ==null ? 0:acc2QTMap3.get(acc2.Account_Org__c).HospitalTransactionAmount__c;
+ //accTar.LostPricesqt__c = acc2.LostPrices__c+ acc2QTMap3.get(acc2.Account_Org__c).LostPrices__c;
+ //accTar.Dealer_Final_Priceqt__c = acc2.Dealer_Final_Price__c + acc2QTMap3.get(acc2.Account_Org__c).Dealer_Final_Price__c;
+ //accTar.HospitalTransactionAmountqt__c = acc2.HospitalTransactionAmount__c + acc2QTMap3.get(acc2.Account_Org__c).HospitalTransactionAmount__c;
+ Decimal a1 = acc2.LostPrices__c == null ? 0 : acc2.LostPrices__c;
+ Decimal a2 = acc2QTMap3.get(acc2.Account_Org__c).LostPrices__c == null ? 0 : acc2QTMap3.get(acc2.Account_Org__c).LostPrices__c;
+ Decimal a3 = acc2.Dealer_Final_Price__c == null ? 0 : acc2.Dealer_Final_Price__c;
+ Decimal a4 = acc2QTMap3.get(acc2.Account_Org__c).Dealer_Final_Price__c == null ? 0 : acc2QTMap3.get(acc2.Account_Org__c).Dealer_Final_Price__c;
+ Decimal a5 = acc2.HospitalTransactionAmount__c == null ? 0 : acc2.HospitalTransactionAmount__c;
+ Decimal a6 = acc2QTMap3.get(acc2.Account_Org__c).HospitalTransactionAmount__c == null ? 0 : acc2QTMap3.get(acc2.Account_Org__c).HospitalTransactionAmount__c;
+ accTar.LostPricesqt__c = a1 + a2;
+ accTar.Dealer_Final_Priceqt__c = a3 + a4;
+ accTar.HospitalTransactionAmountqt__c = a5 +a6;
+
+ }
+ }else{
+ system.debug('==test4==='+dclabel);
+ accTar.LostPricesqt__c = acc2.LostPrices__c;
+ accTar.Dealer_Final_Priceqt__c = acc2.Dealer_Final_Price__c;
+ accTar.HospitalTransactionAmountqt__c = acc2.HospitalTransactionAmount__c;
+ }
+
+ //20230222 DB202302339407 you end
+
// SWAG-BD24SU 鍙戣揣鏁板浠藉埌鐩爣瀹㈡埛 start
accTar.Delivery_cnt_3D__c = acc2.Delivery_cnt_3D__c;
accTar.Delivery_cnt_CYF__c = acc2.Delivery_cnt_CYF__c;
@@ -474,7 +580,11 @@
accTar.Delivery_cnt_GFUCT260__c = acc2.Delivery_cnt_GFUCT260__c;
accTar.Delivery_cnt_OTVS300__c = acc2.Delivery_cnt_OTVS300__c;
accTar.Delivery_cnt_ESG400__c = acc2.Delivery_cnt_ESG400__c;
- accTar.Delivery_cnt_TB__c = acc2.Delivery_cnt_TB__c;
+ //20220602 WLIG-CEWDWS you start
+ //accTar.Delivery_cnt_TB__c = acc2.Delivery_cnt_TB__c;
+ accTar.Delivery_cnt_TB_0520__c = acc2.Delivery_cnt_TB_0520__c;
+ accTar.Delivery_cnt_TB_0535__c = acc2.Delivery_cnt_TB_0535__c;
+ //20220602 WLIG-CEWDWS you end
// 202020604 LHJ SWAG-BQ75WE End
accTar.Order_cnt_290Miro__c = acc2.Order_cnt_290Miro__c;
@@ -499,7 +609,11 @@
accTar.Order_cnt_GFUCT260__c = acc2.Order_cnt_GFUCT260__c;
accTar.Order_cnt_OTVS300__c = acc2.Order_cnt_OTVS300__c;
accTar.Order_cnt_ESG400__c = acc2.Order_cnt_ESG400__c;
- accTar.Order_cnt_TB__c = acc2.Order_cnt_TB__c;
+ //20220602 WLIG-CEWDWS you start
+ //accTar.Order_cnt_TB__c = acc2.Order_cnt_TB__c;
+ accTar.Order_cnt_TB_0520__c = acc2.Order_cnt_TB_0520__c;
+ accTar.Order_cnt_TB_0535__c = acc2.Order_cnt_TB_0535__c;
+ //20220602 WLIG-CEWDWS you end
// 202020604 LHJ SWAG-BQ75WE End
accTar.Opp_cnt_3D__c = acc2.Opp_cnt_3D__c;
accTar.Opp_cnt_CHS400XZ__c = acc2.Opp_cnt_CHS400XZ__c;
@@ -523,7 +637,11 @@
accTar.Opp_cnt_GFUCT260__c = acc2.Opp_cnt_GFUCT260__c;
accTar.Opp_cnt_OTVS300__c = acc2.Opp_cnt_OTVS300__c;
accTar.Opp_cnt_ESG400__c = acc2.Opp_cnt_ESG400__c;
- accTar.Opp_cnt_TB__c = acc2.Opp_cnt_TB__c;
+ //20220602 WLIG-CEWDWS you start
+ //accTar.Opp_cnt_TB__c = acc2.Opp_cnt_TB__c;
+ accTar.Opp_cnt_TB_0520__c = acc2.Opp_cnt_TB_0520__c;
+ accTar.Opp_cnt_TB_0535__c = acc2.Opp_cnt_TB_0535__c;
+ //20220602 WLIG-CEWDWS you end
// 202020604 LHJ SWAG-BQ75WE End
//SWAG-C9WCE5 鎴樼暐绉戝鍜岀洰鏍囧鎴疯瀹氶〉闈㈠鍔犲瓧娈� lt 20211228 start
@@ -563,7 +681,11 @@
accTar.Asset_Cnt_OTVS190__c = acc2.Asset_Cnt_OTVS190__c==0?null:acc2.Asset_Cnt_OTVS190__c;
accTar.Asset_Cnt_OTVS300__c = acc2.Asset_Cnt_OTVS300__c==0?null:acc2.Asset_Cnt_OTVS300__c;
accTar.Asset_Cnt_OTVS400__c = acc2.Asset_Cnt_OTVS400__c==0?null:acc2.Asset_Cnt_OTVS400__c;
- accTar.Asset_Cnt_TB__c = acc2.Asset_Cnt_TB__c==0?null:acc2.Asset_Cnt_TB__c;
+ //20220602 WLIG-CEWDWS you start
+ //accTar.Asset_Cnt_TB__c = acc2.Asset_Cnt_TB__c==0?null:acc2.Asset_Cnt_TB__c;
+ accTar.Asset_Cnt_TB_0520__c = acc2.Asset_Cnt_TB_0520__c==0?null:acc2.Asset_Cnt_TB_0520__c;
+ accTar.Asset_Cnt_TB_0535__c = acc2.Asset_Cnt_TB_0535__c==0?null:acc2.Asset_Cnt_TB_0535__c;
+ //20220602 WLIG-CEWDWS you end
accTar.Asset_Cnt_USG400__c = acc2.Asset_Cnt_USG400__c==0?null:acc2.Asset_Cnt_USG400__c;
//SWAG-BSC5WP you-20201021 end
Date nowDate = Date.today();
--
Gitblit v1.9.1