Bulkify Trigger Example

By -
Trigger : Update Account Total_Amount field  by sum of all its Contact Money field (Roll up summary trigger)

For this following steps as follow:

 1. Create custom field

  • Create a custom field on Account named : Total Money
  • Create a custom field on Contact named : Money
2. Create a Apex Class (Handler class for Trigger) named : AccountTotalMoneyHandler

public class AccountTotalMoneyHandler{
    
    public static void onAfterInsert(List<Contact> lstNewContacts){
        Set<Id> setAccountIds= new Set<Id>();
        for(Contact con : lstNewContacts){
            if(con.AccountId != NULL){
                setAccountIds.add(con.AccountId);
            }
        }
        if(setAccountIds.size() > 0){
            populateMoneyOnAccount(setAccountIds);
        }
    }
      public static void onAfterUpdate(List<Contact> lstNewContacts,Map<Id,Contact> mapOldContact){
        Set<Id> setAccountIds= new Set<Id>();
        Set<Id> setOldAccountIds= new Set<Id>();
        for(Contact con : lstNewContacts){
            if(con.AccountId != mapOldContact.get(con.id).AccountId || 
                con.Money__c != mapOldContact.get(con.id).Money__c){
                setAccountIds.add(con.AccountId);
                setOldAccountIds.add(mapOldContact.get(con.id).AccountId);
            }
        }
        if(setOldAccountIds.size() > 0){
            List<Account> lsttoUpdateAccount = new List<Account>();
            List<Contact> lstoldcontacts = [Select Id from Contact where AccountId IN : setOldAccountIds];
            if(lstoldcontacts.size() == 0 ){
                for(Account acc : [Select Id, Total_Money__c from Account where Id IN : setOldAccountIds]){
                    acc.Total_Money__c = 0;
                    lsttoUpdateAccount.add(acc);
                }
            }
            if(lstoldcontacts.size() > 0 ){
                for(AggregateResult ar : [Select AccountId, sum(Money__c) totalmoney
                                    From Contact Where AccountId IN :setOldAccountIds Group By AccountId]){
                    Account acc = new Account(Id = (ID)ar.get('AccountId'));
                    acc.Total_Money__c = Integer.valueOf(ar.get('totalmoney'));
                    lsttoUpdateAccount.add(acc);    
                }
            }
            
            if(lsttoUpdateAccount.size() > 0){
                update lsttoUpdateAccount;
            }
            if(setAccountIds.size() > 0){
                populateMoneyOnAccount(setAccountIds);
            }
        }
    }
    
    public static void onAfterDelete(List<Contact> lstOldContacts){
        Set<Id> setAccountIds= new Set<Id>();
        for(Contact con : lstOldContacts){
            if(con.AccountId != NULL){
                setAccountIds.add(con.AccountId);
            }
        }
        system.debug('setAccountIds=='+setAccountIds);
        if(setAccountIds.size() > 0){
            List<Account> lsttoUpdateAccount = new List<Account>();
            Set<Id> setOldAccount = new Set<id>();
            for(AggregateResult ar : [Select AccountId, sum(Money__c) totalmoney
                                    From Contact Where AccountId IN :setAccountIds Group By AccountId]){
                    Account acc = new Account(Id = (ID)ar.get('AccountId'));
                    acc.Total_Money__c = Integer.valueOf(ar.get('totalmoney'));
                    lsttoUpdateAccount.add(acc);
                    setOldAccount.add((ID)ar.get('AccountId'));    
            }
            
            for(String accId : setAccountIds){
                if(!setOldAccount.contains(accId )){
                    Account acc = new Account(Id = accId );
                    acc.Total_Money__c = 0;
                    lsttoUpdateAccount.add(acc);
                }
            }
            if(lsttoUpdateAccount.size() > 0){
                update lsttoUpdateAccount;    
            }
            //populateMoneyOnAccount(setAccountIds);
        }
    }
    
    private static void populateMoneyOnAccount(Set<id> setAccountIds){
        List<Account> lsttoUpdateAccount = new List<Account>();
        Set<Id> processedCase = new Set<ID>();
        for(AggregateResult ar : [Select AccountId, sum(Money__c) totalmoney
                                    From Contact Where AccountId IN :setAccountIds Group By AccountId]){
            if(ar.get('totalmoney') != NULL && Integer.valueOf(ar.get('totalmoney')) != 0) {
            
                Account acc = new Account(Id = (ID)ar.get('AccountId'));
                acc.Total_Money__c = Integer.valueOf(ar.get('totalmoney'));
                lsttoUpdateAccount.add(acc);
                processedCase.add((Id)ar.get('AccountId'));
            }
        }
        
        if(lsttoUpdateAccount.size () > 0){
            update lsttoUpdateAccount;
        }
    }
}

3. Create a Trigger on Contact named : AccountTotalMoneyTrigger 
trigger AccountTotalMoneyTrigger on Contact (after insert,after Update,after Delete) {
if(trigger.isAfter) {
if(trigger.isInsert) {
AccountTotalMoneyHandler.onAfterInsert(trigger.new);    
}
if(trigger.isUpdate) {
AccountTotalMoneyHandler.onAfterUpdate(trigger.new,trigger.oldMap);    
}
if(trigger.isDelete) {
AccountTotalMoneyHandler.onAfterDelete(trigger.old);    
}
}
} 


Comments

Post a Comment

Popular posts from this blog

Service Cloud for Lightning Experience - All Steps Q&A [Salesforce][Trailhead]

By -
Service Cloud for Lightning Experience: Step 1 1. What is the Service Cloud? Ans. An easy-to-use customer service application 2. What are key benefits of the Lightning Service Console? Ans. Preconfigured pages and productivity tools for service 3. To update a customer case with a comment: Ans. Select a case from the Cases tab, and share a post. ------------------------------------------------------------- Service Cloud for Lightning Experience: Administer Service Cloud (Step2) 1. What are two key benefits of Lightning Service Setup? Ans. Service metrics and setup flows 2. To get to Lightning Service Setup: Ans. Click the gear icon, then Service Setup. 3. The second stage in the setup process for Service Cloud is to: Ans. Add channels so that your team can respond to customers. ------------------------------------------------------------- Service Cloud for Lightning Experience:  Create Digital Engagement on Multiple Channels 1. On-Demand Email-to-Case: Ans. Sends email traffic outsi...
Read more

Salesforce Process Builder in Brief (Learning/Interview)

By -
  1. What is  Process Builder ? Process Builder helps you automate your business processes and gives you a graphical representation as you build it. 2. How Many Type  of Processes? Process Builder supports three types of processes for your automation needs. The type determines what triggers the process. A record change process starts when a record is created or updated. An event process starts when a platform event message is received. An invocable process starts when something else, like another process, invokes it. 3. Process Builder vs. Workflow? Use the more powerful and flexible Process Builder to perform the same actions as Workflow. With Process Builder, you can: Create a record of any object type Update any related record—not just the record or its parent Use a quick action to create a record, update a record, or log a call Invoke a process from another process Launch a flow—you can’t schedule this action with workflow Send an email Send a custom notification Post...
Read more

Cloud Computing

By -
Image
Cloud computing is the delivery of computing services—including servers, storage, databases, networking, software, analytics, and intelligence—over the Internet (“the cloud”) to offer faster innovation, flexible resources, and economies of scale. You typically pay only for cloud services you use, helping lower your operating costs, run your infrastructure more efficiently and scale as your business needs change. By Sam Johnston - Created by Sam Johnston using OmniGroup's OmniGraffle and Inkscape (includes Computer.svg by Sasa Stefanovic)This W3C-unspecified vector image was created with Inkscape., CC BY-SA 3.0, https://commons.wikimedia.org/w/index.php?curid=6080417 Top benefits of cloud computing: Cost:  Cloud computing eliminates the capital expense of buying hardware and software and setting up and running on-site datacenters—the racks of servers, the round-the-clock electricity for power and cooling, the IT experts for managing the infrastructure. It adds up fast...
Read more

Copado Winter 21 Administrator Maintenance Dumps

By -
As we are trying hard to provide you latest questions and answers of Copado. Please do comment over the post and follow us on our Instagram Profile  SFDCMASTER Answer should be in Green Color. 1. What are some of the benefits of upgrading to Copado Winter '21? Select all that apply (3 answers).You have reached the max number of allowed answers a) You can integrate with external tools for which there is no built-in integration. b) You can avoid migrating duplicate records with an easy-to-build formula that populates external Id values. c) You get more meaningful information on your processes with new metrics and the option to filter custom metrics.  d) You need to uninstall the previous package and install the new one in order to upgrade and enjoy the new features of the Agile Integrations package. 2. Which deployment step allows you to trigger a Salesforce Flow as part of your deployment? a) Flow. b) URL Callout. c) Salesforce Flow. d) External CI. 3. True or False: Copado has...
Read more

Einstein Analytics Data Preparation Specialist

By -
Hi guys, In this post, you will know how to open "Einstein Analytics Data Preparation Specialist" Superbadge. Click here to redirect to Superbadge   To unlock your Superbadge you have to complete 4 Prerequisites Badges. Einstein Analytics Administration Basics Einstein Analytics Data Integration Basics Einstein Analytics Desktop Exploration You need to create Developer org for Einstein (It is free). There is another module through which you can learn how to setup developer org for Einstein and got new badge as well. Click Here Solution "Einstein Analytics Administration Basics"   - Click here Solution "Einstein Analytics Data Integration Basics" - Click here Solution "Einstein Analytics Desktop Exploration"     - Click here
Read more