Salesforce Developer Community

Arundhati Deb
NEWBIE
20 Points
Member since 2018

Chatter

Feed
0

Best Answers
1

Likes Received
0

Likes Given
10

Questions
8

Replies

integration of sfdc and sap system with esb as middleware. Esb needs the endpoint url of salesforce. How to find the endpoint url of salesforce production environment

We are doing Integration of sfdc and sap system with esb as middleware. Esb needs the endpoint url of salesforce. How to find the endpoint url of salesforce production environment.

Arundhati Deb
February 10, 2020
Like
0

1 replies

i want to write a test class for below class. Please help.

global class Schedule_CreditEvaluation_LastYearDetail implements Schedulable {

   global void execute(SchedulableContext sc) {

       String body;
       String bodyHeader;
       String footer;
       List<Messaging.SingleEmailMessage> listMessageEmail = new List<Messaging.SingleEmailMessage>();
       Set<Id> setCustomerId = new Set<Id>();
       Map<Id, List<Credit_Evaluation__c>> mapCustomerCreditEvaluation = new Map<Id, List<Credit_Evaluation__c>>();
       map<Id, Credit_Evaluation__c> mapCustIdToCE = new map<Id, Credit_Evaluation__c>();
       List<Credit_Evaluation__c> ceCustomer = new List<Credit_Evaluation__c>();

       // getting the start date and end date for fetching credit evaluations approved last year
       Date dtLastYearEndDate = null;
       Date dtLastYearStartDate = date.newInstance(System.today().year() - 1, System.today().month() , 01);
       if(System.today().month() == 1 || System.today().month() == 3 || System.today().month() == 5 || System.today().month() == 7 || System.today().month() == 8 || System.today().month() == 10 || System.today().month() == 12) {
           dtLastYearEndDate = date.newInstance(System.today().year() - 1, System.today().month(), 31);
       } else if (System.today().month() == 4 || System.today().month() == 6 || System.today().month() == 9 || System.today().month() == 11) {
           dtLastYearEndDate = date.newInstance(System.today().year() - 1, System.today().month(), 30);
       } else {
           dtLastYearEndDate = date.newInstance(System.today().year() - 1, System.today().month(), 29);
       }
       // comment the below two lines later
       // Date dtLastYearStartDate = date.newInstance(2013, 06, 01);
       // Date dtLastYearEndDate = date.newInstance(2013, 06, 31);

       List<Credit_Evaluation__c> creditEval = [Select c.Approved_By__c,c.Customer_Owner_ID__c,c.Last_Approved_Credit_Limit_Internal__c,c.Last_Approved_Credit_Limit_Customer__c, c.CreatedDate, c.Credit_Term__c, c.Proposed_Credit_Limit__c, c.Customer_Name__r.Name, c.Customer_Sold_to_Party_Code__c, c.Customer_Name__c, c.Id, c.Name, c.Current_Approval_date__c, c.Status__c, c.Customer_Name__r.Customer_Type__c From Credit_Evaluation__c c where Status__c =: 'Approved' AND Current_Approval_date__c >=: dtLastYearStartDate AND Current_Approval_date__c <=: dtLastYearEndDate AND Customer_Name__r.Type = 'Customer' limit 50000];
       System.debug('@@ creditEval @@' + creditEval);
       if(creditEval.size() > 0) {
           for(Credit_Evaluation__c ce: creditEval) {
               setCustomerId.add(ce.Customer_Name__c);
           }
           List<Credit_Evaluation__c> checkRenewalDoneCE = [Select c.Approved_By__c,c.Customer_Owner_ID__c,c.Last_Approved_Credit_Limit_Internal__c,c.Last_Approved_Credit_Limit_Customer__c,c.Insured_Credit_Limit__c,c.Last_Approved_Credit_Term_Customer__c, c.CreatedDate, c.Credit_Term__c, c.Proposed_Credit_Limit__c, c.Customer_Name__r.Name, c.Customer_Sold_to_Party_Code__c, c.Customer_Name__c, c.Id, c.Name, c.Current_Approval_date__c, c.Status__c, c.Customer_Name__r.Customer_Type__c From Credit_Evaluation__c c where Status__c =: 'Approved' AND Customer_Name__c IN: setCustomerId ORDER BY Customer_Name__c ASC limit 50000];
           if(!checkRenewalDoneCE.isEmpty() && checkRenewalDoneCE != null) {
               for(Credit_Evaluation__c chkRenewal: checkRenewalDoneCE) {
                   if(chkRenewal.Current_Approval_date__c >= dtLastYearStartDate) {
                       if(!mapCustomerCreditEvaluation.isEmpty() && mapCustomerCreditEvaluation != null) {
                           if(chkRenewal != null && chkRenewal.Customer_Name__c != null && !mapCustIdToCE.isEmpty() && mapCustIdToCE != null && mapCustIdToCE.get(chkRenewal.Customer_Name__c) != null && mapCustIdToCE.get(chkRenewal.Customer_Name__c).Customer_Name__c != null && mapCustIdToCE.get(chkRenewal.Customer_Name__c).Customer_Name__c == chkRenewal.Customer_Name__c) {
                          ceCustomer.add(chkRenewal);
                          mapCustomerCreditEvaluation.put(chkRenewal.Customer_Name__c, ceCustomer);
                           } else {
                               ceCustomer = new List<Credit_Evaluation__c>();
                          ceCustomer.add(chkRenewal);
                          mapCustIdToCE.put(chkRenewal.Customer_Name__c, chkRenewal);
                          mapCustomerCreditEvaluation.put(chkRenewal.Customer_Name__c, ceCustomer);
                           }
                       } else {
                           ceCustomer = new List<Credit_Evaluation__c>();
                      ceCustomer.add(chkRenewal);
                      mapCustIdToCE.put(chkRenewal.Customer_Name__c, chkRenewal);
                      mapCustomerCreditEvaluation.put(chkRenewal.Customer_Name__c, ceCustomer);
                       }
                   }
               }
           }
           System.debug('@@ mapCustomerCreditEvaluation @@' +mapCustomerCreditEvaluation);
           Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();

           //Ishwar 08-Oct-15 Removed hardcoded emails, get emails ids from given Public Group
           String[] toAddresses = CommonUtil.getGroupMemberEmailIds('CreditEvalRenew_Email');

           // change shirlin tan email address
           //String[] toAddresses = new String[] {'ST@natsteel.com.sg'};

           // Setting the To Address & Cc Address
           mail.setToAddresses(toAddresses);
           mail.setBccSender(false);
           mail.setUseSignature(false);

           // Creating the main table for Credit Evaluations for the Email Body
           bodyHeader = '<table width="100%" cellpadding="0", border="1">';
           bodyHeader += '<th> Customer Name </th> <th> Customer Code </th> <th> Last Approved Credit Limit (Customer) </th><th>Last Approved Credit Limit (Internal)</th> <th> Last Approved Credit Term (Customer) </th> <th>Insured Limit</th> <th>Last Approved Date</th> <th>Customer Owner</th>';
           body = '';

           // querying the Credit Evaluations for the ones which are approved 1 year before and also only for those Customers with Type Customer
           for(Credit_Evaluation__c ce: [Select c.Approved_By__c,c.Customer_Owner_ID__c,c.Last_Approved_Credit_Limit_Internal__c,
c.Last_Approved_Credit_Limit_Customer__c,
c.Insured_Credit_Limit__c,c.Last_Approved_Credit_Term_Customer__c,
c.CreatedDate, c.Credit_Term__c, c.Proposed_Credit_Limit__c,
c.Customer_Name__r.Name, c.Customer_Sold_to_Party_Code__c, c.Customer_Name__c, c.Id,
c.Name, c.Current_Approval_date__c, c.Status__c,
c.Customer_Name__r.Customer_Type__c From Credit_Evaluation__c c where
Status__c =: 'Approved' AND Current_Approval_date__c >=: dtLastYearStartDate AND
Current_Approval_date__c <=: dtLastYearEndDate AND Customer_Name__r.Type = 'Customer'
AND Last_Approved_Credit_Term_Customer__c != 'COD' AND
Last_Approved_Credit_Limit_Customer__c != 0
limit 50000])
{
               if(!mapCustomerCreditEvaluation.isEmpty() && mapCustomerCreditEvaluation != null) {
                   if(mapCustomerCreditEvaluation.get(ce.Customer_Name__c).size() == 1) {
                       String strApprovalDate = ce.Current_Approval_date__c.format();
                       body += '<td>' +ce.Customer_Name__r.Name + '</td>';
                       body += '<td>' +ce.Customer_Sold_to_Party_Code__c + '</td>';
                       body += '<td>' +ce.Last_Approved_Credit_Limit_Customer__c + '</td>';
body += '<td>' + ce.Last_Approved_Credit_Limit_Internal__c + '</td>';
body += '<td>' + ce.Last_Approved_Credit_Term_Customer__c + '</td>';
       body += '<td>' + ce.Insured_Credit_Limit__c + '</td>';
                       body += '<td>' +strApprovalDate+ '</td>';
                       body += '<td>' +ce.Customer_Owner_ID__c+ '</td></tr>';
                   }
               }
           }



           // setting the footer for Email body
           footer = '<p> The above customer'+ '\'' +'s credit evaluation is due for renewal. </p>';
           footer += '<p> Please do the evaluation in Salesforce within 14 days. </p>';
           footer += 'Thank you.';

           // Set the Email body content
           if(body != null && body != '') {
               body += '</table>';
               body = body.replace('null' , '') ;
           }

           //Ishwar 08-Oct-15 Removed hardcoded name, get name from given Public Group
           String toNames='';
           for(User u : [SELECT Name FROM User WHERE Email in :toAddresses])
           {
               toNames = toNames + u.Name +', ';
           }
           //mail.setHtmlBody('<p> Hi ' + toNames + '</p>' +bodyHeader + body + footer);
mail.setHtmlBody('<p> Dear Credit Controllers' + '</p>' +bodyHeader + body + footer);

           // set the subject Name

           Integer iMonth = System.today().month();
           String strMonth;
           if(iMonth == 1) strMonth = 'Jan';
           else if(iMonth == 2) strMonth = 'Feb';
           else if(iMonth == 3) strMonth = 'Mar';
           else if(iMonth == 4) strMonth = 'Apr';
           else if(iMonth == 5) strMonth = 'May';
           else if(iMonth == 6) strMonth = 'June';
           else if(iMonth == 7) strMonth = 'July';
           else if(iMonth == 8) strMonth = 'Aug';
           else if(iMonth == 9) strMonth = 'Sep';
           else if(iMonth == 10) strMonth = 'Oct';
           else if(iMonth == 11) strMonth = 'Nov';
           else if(iMonth == 12) strMonth = 'Dec';

           String strSubject = String.valueof((System.today().year())) + ' - ' + strMonth;
           mail.setSubject('Renewal of Credit Evaluation for ' +strSubject);
           if(body != null && body != '') {
               listMessageEmail.add(mail);
           }
           System.debug('@@ listMessageEmail @@' +listMessageEmail);
           // send the email to respective customer Owners with details of Credit Request
           if(!listMessageEmail.isEmpty() && listMessageEmail != null) {
               Messaging.sendEmail(listMessageEmail);
           }
       }
   }
}

Arundhati Deb
December 19, 2019
Like
0

2 replies

how to default checkbox to true in visualforce and show the corresponding data accordingly

Hi,I have a vf page where there are multiple checkboxes. Once a checkbox is checked to true, the corresponding data is shown visible. This has been already done by us. But now we want to make checkbox default to true and also show the corresponding data as soon as the checkbox is checked by default:
VF page :

<div class="selectAllDiv">
<apex:inputCheckbox onclick="selectAllCheckboxes(this,'inputId1','inputId2','inputId3','inputId4','inputId5','inputId6','inputId7','inputId8','inputId9',
'inputIdWirerd','inputIdHDWIC','inputIdDrwnWire', 'inputIdPcSt','inputIdSteelFab','inputIdCarpet')">
<apex:actionSupport event="onchange" />
</apex:inputCheckbox><span>Select all</span>
</div>
<table class="blueTable" style="width:730px">
<tbody>
<tr>
<td>Product Type:</td>
<td>
<apex:inputCheckbox id="inputId1" selected ="true" value="{!Opportunity.barCheckBox__c}" style="margin-left:8px">
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Rebar
<br/>
<apex:inputCheckbox id="inputId2" value="{!Opportunity.CutAndBend__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Cut And Bend
<br/>
<apex:inputCheckbox id="inputId3" value="{!Opportunity.PreFabCage__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Prefabricated Cage
<br/>
<apex:inputCheckbox id="inputId4" value="{!Opportunity.BorePileCage__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Bored Pile Cage
<br/>
<apex:inputCheckbox id="inputId5" styleClass="chkwc" onclick="disableMPCWoC(this,'inputId6')" value="{!Opportunity.Micro_Pile_Cage_with_centraliser__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Micro Pile Cage (w/ centraliser)
<br/>
<apex:inputCheckbox id="inputId6" styleClass="chkwoc" onclick="disableMPCWC(this,'inputId5')" value="{!Opportunity.Micro_Pile_Cage_w_o_centraliser__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Micro Pile Cage (w/o centraliser)
<br/>
<apex:inputCheckbox id="inputId7" value="{!Opportunity.Coupler1__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Coupler
<br/>
</td>
<td><apex:inputCheckbox id="inputId8" value="{!Opportunity.Deformed_Bar_In_Coil__c}" style="margin-left:8px">
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Deformed Bar in Coil
<br/>
<apex:inputCheckbox id="inputId9" value="{!Opportunity.Deformed_Bar_In_Coil_Semi__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Deformed Bar in Coil (semi)
<br/>
<apex:inputCheckbox id="inputIdWirerd" value="{!Opportunity.Wire_Rod__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Wire Rod
<br/>
<apex:inputCheckbox id="inputIdHDWIC" value="{!Opportunity.Hard_drawn_wire_in_Coil__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Hard Drawn wire in Coil
<br/>
<apex:inputCheckbox id="inputIdDrwnWire" value="{!Opportunity.Hard_drawn_wire__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Hard Drawn wire
<br/>
<apex:inputCheckbox id="inputIdPcSt" value="{!Opportunity.PC_Strand__c}" >
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> PC Strand
<br/>
<br/>
</td>
<td><apex:inputCheckbox id="inputIdSteelFab" value="{!Opportunity.Steel_Fabric_Products__c}" style="margin-left:8px;">
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Steel Fabric Products
<br/>
<apex:inputCheckbox id="inputIdCarpet" value="{!Opportunity.Carpet__c}">
<apex:actionSupport event="onchange" />
</apex:inputCheckbox> Carpet
<br/><br/><br/><br/><br/><br/>
</td>
</tr>
</tbody>
</table><br/>
<apex:outputPanel rendered="{!Opportunity.barCheckBox__c}" id="barCheckBox">
<table class="blueTable" style="width:730px">
<thead>
<tr>
<th>Rebar (w/o DS) in mm </th>
<th>Volume (mt)</th>
</tr>
</thead>
<tbody>
<tr>
<td>8</td>
<td><apex:inputField value="{!Opportunity.Material_w_o_DS_8__c}"/></td>
</tr>
<tr>
<td>10,13 </td>
<td><apex:inputField value="{!Opportunity.Material_w_o_DS_10_13_volume__c}"/></td>
</tr>
<tr>
<td>28,40 </td>
<td><apex:inputField value="{!Opportunity.Material_w_o_DS_28_40_volume__c}"/></td>
</tr>
<tr>
<td> 16,20,25,32</td>
<td><apex:inputField value="{!Opportunity.Material_w_o_DS_16_20_25_32_volume__c}"/></td>
</tr>
<tr>
<td> 50 </td>
<td><apex:inputField value="{!Opportunity.Material_w_o_DS_50_Volume__c}"/></td>
</tr>
<tr>
<td><b>Total Rebar            </b></td>
<td><apex:inputField value="{!Opportunity.Total_w_o_DS__c}"/></td>
</tr>
</tbody>
</table>
</apex:outputPanel><br/>

Arundhati Deb
November 15, 2019
Like
0

1 replies

write a trigger to update one account depending on another account

We have to a update child account depending on parent account. We have the same record type for both the accounts. When a checkbox called "entity" is checked, and a look up field called parent account is filled, that account is considered a child account. Whenever a new address is added or edited on the parent account, the same should flow on child account in the same field of address.
We have to write a trigger for the same

Arundhati Deb
May 22, 2019
Like
0

0 replies

I have a formula field 'vendor' on quote line which gets it's value from a field in product called 'vendor'. I want to get the vendor values in a field of quote and use that field in approval process

I have a formula field 'vendor' on quote line which gets it's value from a field in product called 'vendor'. I want to get the vendor values of different quote lines in a field of quote. Also if there are different vendors in multiple quote lines , names of all the vendors should come in the quote field. Also, I have to use this quote field in approval process. How to write a trigger for this.

Arundhati Deb
April 10, 2019
Like
0

1 replies

Write a trigger to get details of all the products in the opportunity line items on opportunity

Hi,
I need to write a trigger to get the details of all products in the opportunity line item on fileds in opportunity.

Thanks

Arundhati Deb
March 07, 2019
Like
0

1 replies

write a trigger on opportunity to update opportunity fields based on the contract licence type

Hi

I have to write a trigger to update the different opportunity fields based on the contract licence type. Contract id is a lookup field on opportunity and we have to see the contract licence type and update opportunity fields

Arundhati Deb
January 12, 2019
Like
0

3 replies

hi, i want to write a trigger to update opportunity currency same as the opportunity owner currency

Hi
The opportunity currency should be the same as opportunity owner currency. I have to write a trigger for it. Can anyone help me with it.

Arundhati Deb
December 12, 2018
Like
0

SOLVED

13 replies

hi, i want to write a trigger to update opportunity currency same as the opportunity owner currency in before insert.

Hi

I have a scenario where the account currency and opportunity currency can be different. The opportunity currency should be the same as opportunity owner currency. I have to write a trigger for it. Can anyone help me with it.
Highly appreciated.

Arundhati Deb
December 12, 2018
Like
1

SOLVED

2 replies

How to write a trigger to update a field in account by adding the amount field of different opportunities against that account.

I have a field called '"credit blocked" on account. I need to update this field by adding the amount field of different opportunities against this account. Also only those opportunities have to be considered whose stage is not "closed won" or "closed lost." I have to write a trigger.

Arundhati Deb
September 10, 2018
Like
0

SOLVED

13 replies

hi, i want to write a trigger to update opportunity currency same as the opportunity owner currency in before insert.

Arundhati Deb
December 12, 2018
Like
1

6 replies

integration of sfdc and sap system with esb as middleware. Esb needs the endpoint url of salesforce. How to find the endpoint url of salesforce production environment

We are doing Integration of sfdc and sap system with esb as middleware. Esb needs the endpoint url of salesforce. How to find the endpoint url of salesforce production environment.

Arundhati Deb
February 10, 2020
Like
0

2 replies

how to default checkbox to true in visualforce and show the corresponding data accordingly

Arundhati Deb
November 15, 2019
Like
0

3 replies

hi, i want to write a trigger to update opportunity currency same as the opportunity owner currency

Hi
The opportunity currency should be the same as opportunity owner currency. I have to write a trigger for it. Can anyone help me with it.

Arundhati Deb
December 12, 2018
Like
0

SOLVED

13 replies

hi, i want to write a trigger to update opportunity currency same as the opportunity owner currency in before insert.

Arundhati Deb
December 12, 2018
Like
1

SOLVED

16 replies

Trigger to prevent delete

Hi ,

Can some one help me to write a trigger to prevent delete of all Account records and its supporting test class.
Doesn't matter who the user is (Sys Admin/Custom Profile/Read Only...etc), the user should not be able to delete the account record.
There cannot be any exception.

Any help is appreciate.
Thanks!
A

Cloud Atlas
December 02, 2015
Like
1