How to populate maximum time string repeat in record /Child Record - Similar Rollup summary Max function.

Hi Rowdies,

This is a Sample code for displaying maximum time repeat string in child records like Invoice and Invoice line.

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-9744265961313227"
     crossorigin="anonymous"></script>

Set<String> strSetTaxCode = new Set<String>();
 for (custom__c obc : [SELECT  Id , customfield__c, customfield2__c FROM custom__c ]){
            if(String.isNotBlank(oinvline.customfield__c)){
                lstTaxCode.add(oinvline.customfield__c);
            }
 }
for (string settemp : lstTaxCode){
    strSetTaxCode.add(settemp);
}        
for(String str: strSetTaxCode){
    Integer countofChar = 0;
     for(String strl: lstTaxCode ){
                if(str == strl){
                    countofChar++;
                    
                }
            }
            myMap.put(str, countofChar);
        }
        
        for(String strcode: strSetCountryCode){
            Integer countofCharccode = 0;
            for(String strl: lstTaxCountryCode ){
                if(strcode == strl){
                    countofCharccode++;
                }
            }
            myMapcode.put(strcode, countofCharccode);
        }
        
        for(String strPrimary: setPrimaryTaxRate){
            Integer countofChar = 0;
            for(String strlPr: lstPrimaryTaxRate ){
                if(strPrimary == strlPr){
                    countofChar++;
                    
                }
            }
            myMapPrimaryTAX.put(strPrimary, countofChar);
        }
        for(String strSecondaryTax: setSecondaryTaxRate){
            Integer countofChar = 0;
            for(String strl: lstSecondaryTaxRate ){
                if(strSecondaryTax == strl){
                    countofChar++;
                    
                }
            }
            myMapSecondaryTAX.put(strSecondaryTax, countofChar);
        }
        List<Integer> i_valuesPrimaryTax = myMapPrimaryTAX.values();
        i_valuesPrimaryTax.sort();
        //get the max value of the count
        string sSAPPrimaryTaxes ;
        if (i_valuesPrimaryTax.size() > 0 ){
            Integer i_max_value = i_valuesPrimaryTax[(i_valuesPrimaryTax.size()-1)];
            for(String sSAPPrimaryTax : myMapPrimaryTAX.keySet()){
                Integer isapSecondaryTax = myMapPrimaryTAX.get(sSAPPrimaryTax);
                if(isapSecondaryTax == i_max_value){
                    System.debug(' The Maximum value is' + sSAPPrimaryTax + 'and repeated for Primary Tax ' + isapSecondaryTax + 'times' );
                    sSAPPrimaryTaxes=sSAPPrimaryTax;
                }
            }
        }
        
        List<Integer> i_valuesSecondary = myMapSecondaryTAX.values();
        i_valuesSecondary.sort();
        //get the max value of the count
        string sSapSecondaryTaxes ;
        if (i_valuesSecondary.size() > 0 ){
            Integer i_max_value = i_valuesSecondary[(i_valuesSecondary.size()-1)];
            for(String sSapSecondary : myMapSecondaryTAX.keySet()){
                Integer isapSecondaryTax = myMapSecondaryTAX.get(sSapSecondary);
                if(isapSecondaryTax == i_max_value){
                    System.debug(' The Maximum value is' + sSapSecondary + 'and repeated for Secondary Tax ' + isapSecondaryTax + 'times' );
                    sSapSecondaryTaxes=sSapSecondary;
                }
            }
        }
        
        List<Integer> i_values = myMapcode.values();
        i_values.sort();
        //get the max value of the count
        string staxcountrycode ;
        if (i_values.size() > 0 ){
            Integer i_max_value = i_values[(i_values.size()-1)];
            for(String scountrycode : myMapcode.keySet()){
                Integer sapTaxCountryCode = myMapcode.get(scountrycode);
                if(sapTaxCountryCode == i_max_value){
                    System.debug(' The Maximum value is' + scountrycode + 'and repeated ' + sapTaxCountryCode + 'times' );
                    staxcountrycode=scountrycode;
                }
            }
        }
        
        
        
        List<Integer> i_valuestax = myMap.values();
        i_valuestax.sort();
        string staxcode ;
        //get the max value of the count
        if (i_valuestax.size() >0 ){
            Integer i_max_valuecode = i_valuestax[(i_valuestax.size()-1)];
            for(String stax : myMap.keySet()){
                Integer saptaxcode = myMap.get(stax);
                if(saptaxcode == i_max_valuecode){
                    System.debug(' The Maximum value is' + stax + 'and repeated ' + saptaxcode + 'times' );
                    staxcode= stax;
                    
                }    
            }
        }
        Map<String , Tax_Mapping_Configuration__c> tableofTaxMappingRecords = New Map<String , Tax_Mapping_Configuration__c>();
        for(Tax_Mapping_Configuration__c taxData : [Select id,Tax_Code__c,Tax_Country__c,Primary_Tax_Rate__c,Local_Currency_ISO_Code__c,Secondary_Tax_Rate__c,Tax_Text__c , Tax_Registration_No__c from Tax_Mapping_Configuration__c])
        {
            String str = taxData.Tax_Code__c+taxData.Tax_Country__c+taxData.Primary_Tax_Rate__c;
            System.debug('TaxMappingStr' +str);
            tableofTaxMappingRecords.put(str , taxData);
        }
        
        for (blng__Invoice__c oInvoice :[Select id, Active__c , CurrencyIsoCode,ShowReverseCharge__c,VAT_Country_Conga__c, SAP_Tax_Country__c , SAP_Tax_Code__c, SAP_Primary_Tax_Rate__c,SAP_Secondary_Tax_Rate__c,Event_Series_Alternate_Currency__c,InformaTRN__c from blng__Invoice__c where Id IN : ids]){
            if(!String.isBlank(staxcountrycode) || !String.isBlank(staxcode) ){
                oInvoice.SAP_Tax_Country__c = staxcountrycode;
                oInvoice.SAP_Tax_Code__c  = staxcode;
            }
            oInvoice.SAP_Primary_Tax_Rate__c = sSAPPrimaryTaxes;
            oInvoice.SAP_Secondary_Tax_Rate__c = sSapSecondaryTaxes;
            String strtax  = '';
            if (oInvoice.SAP_Primary_Tax_Rate__c != '' && oInvoice.SAP_Primary_Tax_Rate__c != null){
                strtax = oInvoice.SAP_Primary_Tax_Rate__c.remove('%');
                

            }


<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-9744265961313227"

     crossorigin="anonymous"></script>

Comments

Post a Comment

Popular posts from this blog

Adding a red asterisk to required fields using label in LWC

Image
I am trying to add a double or single asterisk to lightning: input tags in LWC, by using "required" tag inside the tag I am able to see the asterisk, but two issues with this are I have to show a red asterisk to some conditionally mandatory issues. Solution -  You can use  label-hidden  variant and put a label. <template> <label>Middle Name</label> <abbr title="required" class="slds-required">**</abbr> <lightning-input label="Middle Name" variant="label-hidden" aria-required="true" maxlength="80"></lightning-input> </template>
Read more

The Developer Console didn't set the DEVELOPER_LOG trace flag on your user. Having an active trace flag triggers debug logging. You have 1,978 MB of the maximum 1,000 MB of debug logs. Before you can edit trace flags, delete some debug logs.

1. In developer console, Select tab "Query Editor" at the bottom of the console. 2. Select check box "Use Tooling API". 3. Execute the below query: SELECT Id FROM ApexLog   4. Select All Rows. Click the first row and then press Shift button and click last row to select all the rows. Delete all rows using Delete button. https://help.salesforce.com/articleView?id=code_debug_log_delete.htm&type=5
Read more

Salesforce: Serial and Parallel Approval

Image
Approval process has been introduced in Salesforce platform sometimes back. But when someone ask you, if Salesforce support Parallel and Serial approval process? The answer is YES, although Salesforce do not implicitly said it is parallel or serial approval process. The good thing is, this functionality available out of the box. So you do not need to write any code. Just with point and click configuration, you can build this process within hours. Parallel Approval Parallel Approval means you are sending multiple approvals out in one step of the approval process. Any approver able to approve without need to wait for other approvers to approve. The approver can be specific  users ,  a queue  or  related user  in the record. How to configure this in Salesforce? When you reach Approval Steps -  Select Assigned Approver , choose  Automatically assign to approver(s) In sample above, when user submit for approval, it will go to a user 'Maria Ann' a...
Read more