From da42e2995c00293af89c71fe5ba6e16cbb77e1b3 Mon Sep 17 00:00:00 2001 From: binxie <137736985@qq.com> Date: 星期五, 16 六月 2023 17:24:31 +0800 Subject: [PATCH] backup code --- force-app/main/default/triggers/MaintenanceContractAfterUpdate.trigger | 76 +++++++++++++++++++------------------- 1 files changed, 38 insertions(+), 38 deletions(-) diff --git a/force-app/main/default/triggers/MaintenanceContractAfterUpdate.trigger b/force-app/main/default/triggers/MaintenanceContractAfterUpdate.trigger index a057531..e148938 100644 --- a/force-app/main/default/triggers/MaintenanceContractAfterUpdate.trigger +++ b/force-app/main/default/triggers/MaintenanceContractAfterUpdate.trigger @@ -7,47 +7,47 @@ return; } - // ---------------------------------------------------------------------- + // ---------------------------------------------------------------------- // 銇撱亾銈堛倞銆佷慨鐞嗐伄銈点兗銉撱偣銈炽兂銉堛儵銈儓闋呯洰銈掕嚜鍕曠殑銇洿鏂般仚銈嬨儹銈搞儍銈� // ---------------------------------------------------------------------- - - List<Maintenance_Contract__c> targetList = new List<Maintenance_Contract__c>(); - - for ( Integer i = 0; i < Trigger.new.size(); i++) { - // 濂戠磩闁嬪鏃ャ仺濂戠磩绲備簡鏃ャ伄銇┿仭銈夈亱銇屽銈忋仯銇︺亜銇熷牬鍚堛伄銇垮嚘鐞嗐倰銇欍倠 - if ( - Trigger.old[i].Contract_Start_Date__c != Trigger.new[i].Contract_Start_Date__c - || - Trigger.old[i].Contract_End_Date__c != Trigger.new[i].Contract_End_Date__c - ) { - // 鍑︾悊瀵捐薄銇姞銇堛倠 - targetList.add( Trigger.new[i]); - } - } - - if ( targetList.size() > 0) { - // 绱嶅叆鍟嗗搧銈掑緱銈嬪嚘鐞� - - // 涓�鎰忋伄绱嶅叆鍟嗗搧ID銈掑緱銈� - List<Maintenance_Contract_Asset__c> assetlist = [SELECT Asset__c FROM Maintenance_Contract_Asset__c WHERE Maintenance_Contract__c IN :targetList]; - Set<Id> assetIds = new Set<Id>(); - for ( Maintenance_Contract_Asset__c middleTable : assetList) { - assetIds.add( middleTable.Asset__c); - } - - // 淇悊銈掑緱銈� - List<Repair__c> repairList = [SELECT Id FROM Repair__c WHERE Delivered_Product__c IN :assetIds - and Status2__c !='00.鍒犻櫎' - and Status2__c !='00.鍙栨秷' - and Status2__c !='17.浠樻瀹屾瘯' - and Status2__c !='00.鍏抽棴' - and Status2__c !='16.瀹屾瘯']; - - // 淇悊銈掔┖鏇存柊 - update repairList; - } + + List<Maintenance_Contract__c> targetList = new List<Maintenance_Contract__c>(); + + for ( Integer i = 0; i < Trigger.new.size(); i++) { + // 濂戠磩闁嬪鏃ャ仺濂戠磩绲備簡鏃ャ伄銇┿仭銈夈亱銇屽銈忋仯銇︺亜銇熷牬鍚堛伄銇垮嚘鐞嗐倰銇欍倠 + if ( + Trigger.old[i].Contract_Start_Date__c != Trigger.new[i].Contract_Start_Date__c + || + Trigger.old[i].Contract_End_Date__c != Trigger.new[i].Contract_End_Date__c + ) { + // 鍑︾悊瀵捐薄銇姞銇堛倠 + targetList.add( Trigger.new[i]); + } + } + + if ( targetList.size() > 0) { + // 绱嶅叆鍟嗗搧銈掑緱銈嬪嚘鐞� + + // 涓�鎰忋伄绱嶅叆鍟嗗搧ID銈掑緱銈� + List<Maintenance_Contract_Asset__c> assetlist = [SELECT Asset__c FROM Maintenance_Contract_Asset__c WHERE Maintenance_Contract__c IN :targetList]; + Set<Id> assetIds = new Set<Id>(); + for ( Maintenance_Contract_Asset__c middleTable : assetList) { + assetIds.add( middleTable.Asset__c); + } + + // 淇悊銈掑緱銈� + List<Repair__c> repairList = [SELECT Id FROM Repair__c WHERE Delivered_Product__c IN :assetIds + and Status2__c !='00.鍒犻櫎' + and Status2__c !='00.鍙栨秷' + and Status2__c !='17.浠樻瀹屾瘯' + and Status2__c !='00.鍏抽棴' + and Status2__c !='16.瀹屾瘯']; + + // 淇悊銈掔┖鏇存柊 + update repairList; + } - // ---------------------------------------------------------------------- + // ---------------------------------------------------------------------- // 銇撱亾銇俱仹銆佷慨鐞嗐伄銈点兗銉撱偣銈炽兂銉堛儵銈儓闋呯洰銈掕嚜鍕曠殑銇洿鏂般仚銈嬨儹銈搞儍銈� // ---------------------------------------------------------------------- -- Gitblit v1.9.1