From cc7487a59bd4b0fa5bed1dd59f6d0565ace81b8b Mon Sep 17 00:00:00 2001
From: 李金换 <lijinhuan@prec-tech.com>
Date: 星期五, 21 四月 2023 09:48:22 +0800
Subject: [PATCH] opd计划Cl3
---
force-app/main/default/triggers/NFM010UpsertStatuAchievements.trigger | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 56 insertions(+), 0 deletions(-)
diff --git a/force-app/main/default/triggers/NFM010UpsertStatuAchievements.trigger b/force-app/main/default/triggers/NFM010UpsertStatuAchievements.trigger
index 452007f..b63edfd 100644
--- a/force-app/main/default/triggers/NFM010UpsertStatuAchievements.trigger
+++ b/force-app/main/default/triggers/NFM010UpsertStatuAchievements.trigger
@@ -2,6 +2,11 @@
* 娉ㄦ畫鍑虹磵琛ㄣ倰upsert
*/
trigger NFM010UpsertStatuAchievements on Statu_Achievements__c (after insert, after update) {
+ // SWAG-CE55BX 棰勬祴浼樺寲 start
+ if (StaticParameter.EscapeOppandStaTrigger) {
+ return;
+ }
+ // SWAG-CE55BX 棰勬祴浼樺寲 end
// CHAN-AZM8SE 2018/8/27 start
if (Label.update_Statu_Achievements_Journal.equals('true')) {
return;
@@ -426,6 +431,57 @@
}
}
+ //20230203 lt DB202301351834 鏂板搧鍙戣揣鏃ヨ祴鍊� start
+ List<String> SIDList = new List<String>();
+ List<QIS_Report__c> UpdQISList = new List<QIS_Report__c>();
+ if(Trigger.isInsert || Trigger.isUpdate){
+ System.debug('---lt123---杩涘垽鏂�---');
+ for (Statu_Achievements__c sta : Trigger.new){
+ if(Trigger.isInsert){
+ if(sta.Status_1__c != '閫�璐�' && sta.Status_1__c != '鏃犳晥' && sta.ContractNO__c != null && sta.DeliveryDate__c != null){
+ if(!SIDList.contains(sta.ContractNO__c)){
+ SIDList.add(sta.ContractNO__c);
+ }
+ }
+ }else{
+ Statu_Achievements__c OldSta = Trigger.oldMap.get(sta.id);
+ if(sta.Status_1__c != '閫�璐�' && sta.Status_1__c != '鏃犳晥' && sta.ContractNO__c != null && sta.DeliveryDate__c != null && (sta.DeliveryDate__c != OldSta.DeliveryDate__c || (System.Label.onlyupdate == '1' && UserInfo.getUserId() == '00510000005sEEMAA2'))){
+ if(!SIDList.contains(sta.ContractNO__c)){
+ SIDList.add(sta.ContractNO__c);
+ }
+ }
+ }
+ }
+ }
+
+ System.debug('---lt123---鍚堝悓缂栧彿list---'+SIDList);
+ System.debug('---lt123---鍚堝悓缂栧彿listSize---'+SIDList.size());
+ if(SIDList.size() > 0 ){
+ list<QIS_Report__c> QISList =
+ [Select id, NewProDeliveryDate__c, Order_No__c
+ From QIS_Report__c
+ Where Order_No__c in: SIDList];
+
+ System.debug('---lt123---QISlist---'+QISList);
+ System.debug('---lt123---QISlistSize---'+QISList.size());
+ if(QISList.size() > 0 ){
+ for(QIS_Report__c qiss : QISList){
+ for (Statu_Achievements__c sta : Trigger.new){
+ if(qiss.Order_No__c == sta.ContractNO__c){
+ qiss.NewProDeliveryDate__c = sta.DeliveryDate__c;
+ UpdQISList.add(qiss);
+ }
+ }
+ }
+ }
+
+ if(UpdQISList.size() > 0 ){
+ update UpdQISList;
+ }
+
+ }
+ //20230203 lt DB202301351834 鏂板搧鍙戣揣鏃ヨ祴鍊� end
+
// SoNo_DeliveryDate_Text__c 銇仸 upsert
if (stajUpsertMap.size() > 0) {
ControllerUtil.upsertStatuAchievementsJournalByKey(stajUpsertMap.values());
--
Gitblit v1.9.1