/***create two backend fields on Object(below sampple code is written on Opportunity Object, so create two fields on Opportunity)
Field1---> Date Field ----> Next Alert Schduled Date
Field2---> Picklist Field--> Approval Status with Options "In Progress, Approved, Rejected"
Update both the fields once record is submitted for Approval using "Initial Submission Actions" as below
Field1 = System.today()+3;
Field2 = In Progress;
****/
global class BatchSendEmailAlerts implements Database.Batchable<SObject>
{
Public String status = 'In Progress';
public List<Opportunity> opptyUpdateList = new List<Opportunity>();
Public String Query='select Id,Name,StageName,closedate from Opportunity where Approval_status__c ='+status+' and Next_Alert_Schduled_Date__c=
global database.querylocator start(Database.
{
return Database.getQueryLocator(
}
global void execute(Database.
{
system.debug('~~~~~~~~~~~~
List<Messaging.
for(Opportunity opptyRec: listOppty)
{
List<Messaging.
String subject = ' ';
Messaging.SingleEmailMessage email = new Messaging.SingleEmailMessage()
email.
email.setSubject(subject);
String sHtmlBody1='<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><style>
String sHtmlBody2='<br/><br/>Hello '+fname+'<br/>Write your boday here<br/><br/>Thank you,<br/>SFDC Admin Team<br/><br/><br><img id="r5sp1" bLabel="footerImage" border="0" bEditID="r5sp1" src="https://c.na11.content.
String shtmlbody = sHtmlBody1+sHtmlBody2;
email.setHtmlBody(shtmlbody);
String[] toaddress= new String[]{'+Email+'};
email.setToAddresses(
emails.add(email);
OpptyRec.Next_Alert_Schduled_
opptyUpdateList.add(OpptyRec);
}
try
{
if(opptyUpdateList!=null and opptyUpdateList.size()>0)
{
update opptyUpdateList;
}
if(emails!=null && emails.size()>0)
{
Messaging.sendEmail(emails);
}
}
catch(exception e)
{
//do nothing
}
}
global void finish(Database.
{
//do nothing
}
}
/****
Again go back to Approval Process update "Approval Status" with value as follows
Update with value Approved using "Final Approval Actions"
Update with value Rejected using "Final Rejection Actions"
****/
+++++++++++++++-
++++++++++++++++-
global class ScheduleSendAlerts implements Schedulable
{
global void Execute (SchedulableContext SC)
{
BatchSendEmailAlerts sendalerts = new BatchSendEmailAlerts();
database.executebatch(
system.debug('In the batch class');
}
}
Thanks & Regards,
Thallada
No comments:
Post a Comment