Java, Salesforce, Android Samples : Salesforce - Summarize Totals in Apex based on Date

global class RoundRobinSectors {
Date today;
Date yesterday;
Date last7Days;
Date last14Days;
Date last30Days;
Date firstDay_Currentweek;
Date lastDay_Currentweek;
Date firstDay_Lastweek;
Date lastDay_Lastweek;
Date firstDay_CurrentMonth;
Date lastDay_CurrentMonth;
Date firstDay_LastMonth;
Date lastDay_LastMonth;
Date LastTwoMonths;
Date LastThreeMonths;
Date LastSixMonths;
Date Last12Months;
global enum DateType {
Today,Yesterday,CurrentWeek,Last7Days,Last14Days,Last30Days,LastWeek,CurrentMonth,LastMonth,TwoMonths,ThreeMonths,SixMonths,Last12Months
}
global void InitilizeDates(){
Integer days=7;
date myDate = date.today();
today=myDate;
yesterday=myDate.addDays(-1);
last7Days=myDate.addDays(-7);
last14Days=myDate.addDays(-14);
last30Days=myDate.addDays(-30);
firstDay_Currentweek = myDate.toStartofWeek();
lastDay_Currentweek = myDate.toStartofWeek().addDays(days);
firstDay_Lastweek = myDate.addDays(-days).toStartofWeek();// need to check it
lastDay_Lastweek = myDate.addDays(-days).toStartofWeek().addDays(days);
firstDay_CurrentMonth = myDate.toStartOfMonth();
lastDay_CurrentMonth = firstDay_CurrentMonth.addDays(date.daysInMonth(myDate.year() , myDate.month()) - 1);
firstDay_LastMonth = myDate.addMonths(-1).toStartOfMonth();
lastDay_LastMonth = firstDay_LastMonth.addDays(date.daysInMonth(firstDay_LastMonth.year() , firstDay_LastMonth.month()));
LastTwoMonths = myDate.addMonths(-2);
LastThreeMonths = myDate.addMonths(-3);
LastSixMonths = myDate.addMonths(-6);
Last12Months = myDate.addMonths(-12);
}
global DateType IsCurrentDay(Date compareDate){
system.debug('compareDate= '+compareDate);
system.debug('today'+today);
if(compareDate == today)
return DateType.Today;
return null;
}
global DateType IsYesterday(Date compareDate){
if(compareDate == yesterday)
return DateType.Yesterday;
return null;
}
global DateType IsCurrentWeek(Date compareDate){
if(compareDate > firstDay_Currentweek && compareDate <=lastDay_Currentweek)
return DateType.CurrentWeek;
return null;
}
global DateType IsLast7Days(Date compareDate){
if(compareDate > last7Days && compareDate <=today)
return DateType.Last7Days;
return null;
}
global DateType IsLast14Days(Date compareDate){
if(compareDate > last14Days && compareDate <=today)
return DateType.Last14Days;
return null;
}
global DateType IsLast30Days(Date compareDate){
if(compareDate > last30Days && compareDate <=today)
return DateType.Last30Days;
return null;
}
global DateType IsLastWeek(Date compareDate){
if(compareDate > firstDay_Lastweek && compareDate <=lastDay_Lastweek)
return DateType.LastWeek;
return null;
}

global DateType IsCurrentMonth(Date compareDate){
/*system.debug('this is compareDate'+compareDate);
system.debug('this is firstDay_CurrentMonth'+firstDay_CurrentMonth);
system.debug('this is lastDay_CurrentMonth'+lastDay_CurrentMonth);*/

if(compareDate >= firstDay_CurrentMonth && compareDate <=lastDay_CurrentMonth)
return DateType.CurrentMonth;
return null;
}

global DateType IsLastMonth(Date compareDate){
system.debug('this is compareDate'+compareDate);
system.debug('this is firstDay_LastMonth'+firstDay_LastMonth);
system.debug('this is lastDay_LastMonth'+lastDay_LastMonth);

if(compareDate >= firstDay_LastMonth && compareDate <=lastDay_LastMonth)
return DateType.LastMonth;
return null;
}

global DateType IsLastTwoMonths(Date compareDate){
if(compareDate <= today && compareDate >=LastTwoMonths)
return DateType.TwoMonths;
return null;
}

global DateType IsLastThreeMonths(Date compareDate){
if(compareDate <= today && compareDate >=LastThreeMonths)
return DateType.ThreeMonths;
return null;
}
global DateType IsLastSixMonths(Date compareDate){
if(compareDate <= today && compareDate >=LastSixMonths)
return DateType.SixMonths;
return null;
}
global DateType IsLast12Months(Date compareDate){
if(compareDate <= today && compareDate >=Last12Months)
return DateType.Last12Months;
return null;
}
public Decimal getSum(Decimal x,Decimal y){
Decimal result=0;
if(x==null)
x=0;
if(y==null)
y=0;
if(x!=null
&& y!=null){
result=Math.abs(x+y);
}
return result;
}
public String getSum(String x,String y){
Decimal result=0;
if(x==null)
x='0';
if(y==null)
y='0';
if(x!=null
&& y!=null){
result=Math.abs(Decimal.valueOf(x)+Decimal.valueOf(y));
}
return String.valueOf(result);
}
public Decimal getDiv(Decimal x,Decimal y){
Decimal result=0;
if(x!=null
&& y!=null
&& y!=0){
result=Math.abs(x/y);
}
return result;
}
public Decimal getDiv(String x,Decimal y){
Decimal result=0;
if(x!=null
&& y!=null
&& y!=0){
result=Math.abs(Decimal.valueOf(x)/y);
}
return result;
}
public String getTwoDecimals(String x){
String val='0.00';
if(x.length()>5 && x.contains('.'))
val=x.subString(0,5);
else
val=x;
return val;
}
public Leadshare__c getSectorToday(List<Leadshare__c> p_leadsharelist){
Leadshare__c leadshare;
for(Leadshare__c s:p_leadsharelist){
if(IsCurrentDay(s.Date__c)==DateType.Today){
leadshare=s;
break;
}
}
return leadshare;
}
public Leadshare__c getSectorYesterday(List<Leadshare__c> p_leadsharelist){
Leadshare__c leadshare;
for(Leadshare__c s:p_leadsharelist){
if(IsYesterday(s.Date__c)==DateType.Yesterday){
leadshare=s;
break;
}
}
return leadshare;
}
public Leadshare__c getSectorThisWeek(List<Leadshare__c> p_leadsharelist){
Leadshare__c leadshare=new Leadshare__c();
for(Leadshare__c ps:p_leadsharelist){
if(IsCurrentWeek(ps.Date__c)==DateType.CurrentWeek){
leadshare.No_of_Leads_Called__c=getSum(leadshare.No_of_Leads_Called__c,ps.No_of_Leads_Called__c);
leadshare.Talk_Time__c=getSum(leadshare.Talk_Time__c,ps.Talk_Time__c);
leadshare.Inbound_Calls__c=getSum(leadshare.Inbound_Calls__c,ps.Inbound_Calls__c);
leadshare.Outbound_Calls__c=getSum(leadshare.Outbound_Calls__c,ps.Outbound_Calls__c);
leadshare.Invalid_Lead__c=getSum(leadshare.Invalid_Lead__c,ps.Invalid_Lead__c);
leadshare.Initial_Contact__c=getSum(leadshare.Initial_Contact__c,ps.Initial_Contact__c);
leadshare.Lost__c=getSum(leadshare.Lost__c,ps.Lost__c);
leadshare.Closed__c=getSum(leadshare.Closed__c,ps.Closed__c);
leadshare.No_of_Leads_Worked_Modified__c=getSum(leadshare.No_of_Leads_Worked_Modified__c,ps.No_of_Leads_Worked_Modified__c);
leadshare.Working__c=getSum(leadshare.Working__c,ps.Working__c);
leadshare.Total_Leads_Sales_Rep_Lead_Type__c=getSum(leadshare.Total_Leads_Sales_Rep_Lead_Type__c,ps.Total_Leads_Sales_Rep_Lead_Type__c);
}
}
return leadshare;
}
public Leadshare__c getSectorLast7Days(List<Leadshare__c> p_leadsharelist){
Leadshare__c leadshare=new Leadshare__c();
for(Leadshare__c ps:p_leadsharelist){
if(IsLast7Days(ps.Date__c)==DateType.Last7Days){
leadshare.No_of_Leads_Called__c=getSum(leadshare.No_of_Leads_Called__c,ps.No_of_Leads_Called__c);
leadshare.Talk_Time__c=getSum(leadshare.Talk_Time__c,ps.Talk_Time__c);
leadshare.Inbound_Calls__c=getSum(leadshare.Inbound_Calls__c,ps.Inbound_Calls__c);
leadshare.Outbound_Calls__c=getSum(leadshare.Outbound_Calls__c,ps.Outbound_Calls__c);
leadshare.Invalid_Lead__c=getSum(leadshare.Invalid_Lead__c,ps.Invalid_Lead__c);
leadshare.Initial_Contact__c=getSum(leadshare.Initial_Contact__c,ps.Initial_Contact__c);
leadshare.Lost__c=getSum(leadshare.Lost__c,ps.Lost__c);
leadshare.Closed__c=getSum(leadshare.Closed__c,ps.Closed__c);
leadshare.No_of_Leads_Worked_Modified__c=getSum(leadshare.No_of_Leads_Worked_Modified__c,ps.No_of_Leads_Worked_Modified__c);
leadshare.Working__c=getSum(leadshare.Working__c,ps.Working__c);
leadshare.Total_Leads_Sales_Rep_Lead_Type__c=getSum(leadshare.Total_Leads_Sales_Rep_Lead_Type__c,ps.Total_Leads_Sales_Rep_Lead_Type__c);
}
}
return leadshare;
}
public Leadshare__c getSectorLast14Days(List<Leadshare__c> p_leadsharelist){
Leadshare__c leadshare=new Leadshare__c();
for(Leadshare__c ps:p_leadsharelist){
if(IsLast14Days(ps.Date__c)==DateType.Last14Days){
leadshare.No_of_Leads_Called__c=getSum(leadshare.No_of_Leads_Called__c,ps.No_of_Leads_Called__c);
leadshare.Talk_Time__c=getSum(leadshare.Talk_Time__c,ps.Talk_Time__c);
leadshare.Inbound_Calls__c=getSum(leadshare.Inbound_Calls__c,ps.Inbound_Calls__c);
leadshare.Outbound_Calls__c=getSum(leadshare.Outbound_Calls__c,ps.Outbound_Calls__c);
leadshare.Invalid_Lead__c=getSum(leadshare.Invalid_Lead__c,ps.Invalid_Lead__c);
leadshare.Initial_Contact__c=getSum(leadshare.Initial_Contact__c,ps.Initial_Contact__c);
leadshare.Lost__c=getSum(leadshare.Lost__c,ps.Lost__c);
leadshare.Closed__c=getSum(leadshare.Closed__c,ps.Closed__c);
leadshare.No_of_Leads_Worked_Modified__c=getSum(leadshare.No_of_Leads_Worked_Modified__c,ps.No_of_Leads_Worked_Modified__c);
leadshare.Working__c=getSum(leadshare.Working__c,ps.Working__c);
leadshare.Total_Leads_Sales_Rep_Lead_Type__c=getSum(leadshare.Total_Leads_Sales_Rep_Lead_Type__c,ps.Total_Leads_Sales_Rep_Lead_Type__c);
}
}
return leadshare;
}
public Leadshare__c getSectorLast30Days(List<Leadshare__c> p_leadsharelist){
Leadshare__c leadshare=new Leadshare__c();
for(Leadshare__c ps:p_leadsharelist){
if(IsLast30Days(ps.Date__c)==DateType.Last30Days){
leadshare.No_of_Leads_Called__c=getSum(leadshare.No_of_Leads_Called__c,ps.No_of_Leads_Called__c);
leadshare.Talk_Time__c=getSum(leadshare.Talk_Time__c,ps.Talk_Time__c);
leadshare.Inbound_Calls__c=getSum(leadshare.Inbound_Calls__c,ps.Inbound_Calls__c);
leadshare.Outbound_Calls__c=getSum(leadshare.Outbound_Calls__c,ps.Outbound_Calls__c);
leadshare.Invalid_Lead__c=getSum(leadshare.Invalid_Lead__c,ps.Invalid_Lead__c);
leadshare.Initial_Contact__c=getSum(leadshare.Initial_Contact__c,ps.Initial_Contact__c);
leadshare.Lost__c=getSum(leadshare.Lost__c,ps.Lost__c);
leadshare.Closed__c=getSum(leadshare.Closed__c,ps.Closed__c);
leadshare.No_of_Leads_Worked_Modified__c=getSum(leadshare.No_of_Leads_Worked_Modified__c,ps.No_of_Leads_Worked_Modified__c);
leadshare.Working__c=getSum(leadshare.Working__c,ps.Working__c);
leadshare.Total_Leads_Sales_Rep_Lead_Type__c=getSum(leadshare.Total_Leads_Sales_Rep_Lead_Type__c,ps.Total_Leads_Sales_Rep_Lead_Type__c);
}
}
return leadshare;
}
public Leadshare__c getSectorLastWeek(List<Leadshare__c> p_leadsharelist){
Leadshare__c leadshare=new Leadshare__c();
for(Leadshare__c ps:p_leadsharelist){
if(IsLastWeek(ps.Date__c)==DateType.LastWeek){
leadshare.No_of_Leads_Called__c=getSum(leadshare.No_of_Leads_Called__c,ps.No_of_Leads_Called__c);
leadshare.Talk_Time__c=getSum(leadshare.Talk_Time__c,ps.Talk_Time__c);
leadshare.Inbound_Calls__c=getSum(leadshare.Inbound_Calls__c,ps.Inbound_Calls__c);
leadshare.Outbound_Calls__c=getSum(leadshare.Outbound_Calls__c,ps.Outbound_Calls__c);
leadshare.Invalid_Lead__c=getSum(leadshare.Invalid_Lead__c,ps.Invalid_Lead__c);
leadshare.Initial_Contact__c=getSum(leadshare.Initial_Contact__c,ps.Initial_Contact__c);
leadshare.Lost__c=getSum(leadshare.Lost__c,ps.Lost__c);
leadshare.Closed__c=getSum(leadshare.Closed__c,ps.Closed__c);
leadshare.No_of_Leads_Worked_Modified__c=getSum(leadshare.No_of_Leads_Worked_Modified__c,ps.No_of_Leads_Worked_Modified__c);
leadshare.Working__c=getSum(leadshare.Working__c,ps.Working__c);
leadshare.Total_Leads_Sales_Rep_Lead_Type__c=getSum(leadshare.Total_Leads_Sales_Rep_Lead_Type__c,ps.Total_Leads_Sales_Rep_Lead_Type__c);
}
}
return leadshare;
}
public Leadshare__c getSectorThisMonth(List<Leadshare__c> p_leadsharelist){
Leadshare__c leadshare=new Leadshare__c();
for(Leadshare__c ps:p_leadsharelist){
if(IsCurrentMonth(ps.Date__c)==DateType.CurrentMonth){
leadshare.No_of_Leads_Called__c=getSum(leadshare.No_of_Leads_Called__c,ps.No_of_Leads_Called__c);
leadshare.Talk_Time__c=getSum(leadshare.Talk_Time__c,ps.Talk_Time__c);
leadshare.Inbound_Calls__c=getSum(leadshare.Inbound_Calls__c,ps.Inbound_Calls__c);
leadshare.Outbound_Calls__c=getSum(leadshare.Outbound_Calls__c,ps.Outbound_Calls__c);
leadshare.Invalid_Lead__c=getSum(leadshare.Invalid_Lead__c,ps.Invalid_Lead__c);
leadshare.Initial_Contact__c=getSum(leadshare.Initial_Contact__c,ps.Initial_Contact__c);
leadshare.Lost__c=getSum(leadshare.Lost__c,ps.Lost__c);
leadshare.Closed__c=getSum(leadshare.Closed__c,ps.Closed__c);
leadshare.No_of_Leads_Worked_Modified__c=getSum(leadshare.No_of_Leads_Worked_Modified__c,ps.No_of_Leads_Worked_Modified__c);
leadshare.Working__c=getSum(leadshare.Working__c,ps.Working__c);
leadshare.Total_Leads_Sales_Rep_Lead_Type__c=getSum(leadshare.Total_Leads_Sales_Rep_Lead_Type__c,ps.Total_Leads_Sales_Rep_Lead_Type__c);
}
}
return leadshare;
}
public Leadshare__c getSectorLastMonth(List<Leadshare__c> p_leadsharelist){
Leadshare__c leadshare=new Leadshare__c();
for(Leadshare__c ps:p_leadsharelist){
if(IsLastMonth(ps.Date__c)==DateType.LastMonth){
leadshare.No_of_Leads_Called__c=getSum(leadshare.No_of_Leads_Called__c,ps.No_of_Leads_Called__c);
leadshare.Talk_Time__c=getSum(leadshare.Talk_Time__c,ps.Talk_Time__c);
leadshare.Inbound_Calls__c=getSum(leadshare.Inbound_Calls__c,ps.Inbound_Calls__c);
leadshare.Outbound_Calls__c=getSum(leadshare.Outbound_Calls__c,ps.Outbound_Calls__c);
leadshare.Invalid_Lead__c=getSum(leadshare.Invalid_Lead__c,ps.Invalid_Lead__c);
leadshare.Initial_Contact__c=getSum(leadshare.Initial_Contact__c,ps.Initial_Contact__c);
leadshare.Lost__c=getSum(leadshare.Lost__c,ps.Lost__c);
leadshare.Closed__c=getSum(leadshare.Closed__c,ps.Closed__c);
leadshare.No_of_Leads_Worked_Modified__c=getSum(leadshare.No_of_Leads_Worked_Modified__c,ps.No_of_Leads_Worked_Modified__c);
leadshare.Working__c=getSum(leadshare.Working__c,ps.Working__c);
leadshare.Total_Leads_Sales_Rep_Lead_Type__c=getSum(leadshare.Total_Leads_Sales_Rep_Lead_Type__c,ps.Total_Leads_Sales_Rep_Lead_Type__c);
}
}
return leadshare;
}
}

/*
@date: 11/June/2018
@description: A batch class for Round robin improvements
*/
global class RoundRobinImprovementsBatch implements Database.Batchable<sObject>,Database.Stateful, Schedulable {
public List<Round_Robin_Client__c> round_robin_list;
public RoundRobinSectors sector;
global void scheduleMe(){
String CRON=System.Label.RoundRobinImprovementsBatch_CRON;
//Run the batch daily at mid night
System.schedule('RoundRobinImprovementsBatch__'+DateTime.now(), CRON, new RoundRobinImprovementsBatch());
}
global void execute(SchedulableContext sc){
RoundRobinImprovementsBatch batch=new RoundRobinImprovementsBatch();
ID batchprocessid=Database.executeBatch(batch);
}
//query RoundRobin records
global Database.QueryLocator start(Database.BatchableContext BC) {
round_robin_list=new List<Round_Robin_Client__c>();
sector=new RoundRobinSectors();
sector.InitilizeDates();
//Query RoundRobin with recently created 90 Leadshares
String query = 'SELECT '+ showFields('Round_Robin_Client__c')+
', (SELECT '+showFields('Leadshare__c')+' FROM Leadshare__r ORDER BY lastmodifieddate DESC LIMIT 90) '+
'FROM Round_Robin_Client__c '+
'WHERE Active_Lead_Type__c!=NULL'+
' AND Status__c=\'Active\'';
System.debug('query: '+query);
return Database.getQueryLocator(query);
}
global void execute(Database.BatchableContext BC, List<Round_Robin_Client__c> scope) {
//add all records of each batch
round_robin_list.addAll(scope);
}
global void finish(Database.BatchableContext BC) {
List<Round_Robin_Client__c> rr_update_list=new List<Round_Robin_Client__c>();
// Map<Id,List<Leadshare__c>> rrId_leadshare_map=new Map<Id,List<Leadshare__c>>();
for(Round_Robin_Client__c r:round_robin_list){
//assigned yesterday - assigned current date
r.Assigned_today__c=getAssigned(system.today()-1,system.today(),r.leadshare__r);
//Assigned yesterday = day before yesterday - assigned yesterday
r.Assigned_yesterday__c=getAssigned(system.today()-2,system.today()-1,r.leadshare__r);
// assigned 7th day - assigned current date
r.Assigned_last_7_days__c=getAssigned(system.today()-7,system.today(),r.leadshare__r);
// assigned 14th day - assigned current date
r.Assigned_last_14_days__c=getAssigned(system.today()-14,system.today(),r.leadshare__r);
// assigned 30th day - assigned current date
r.Assigned_last_30_days__c=getAssigned(system.today()-30,system.today(),r.leadshare__r);
//update leadshare %
r.Current_Per__c=getCurrentLeadPercent(system.today(),r.leadshare__r);
r.Yesterday_per__c=getLeadPercent(System.today()-1,System.today(),r.leadshare__r);
r.Last_7_Days__c=getLeadPercent(System.today()-7,System.today(),r.leadshare__r);
r.Last_14_Days__c=getLeadPercent(System.today()-14,System.today(),r.leadshare__r);
r.Last_30_Days__c=getLeadPercent(System.today()-30,System.today(),r.leadshare__r);
//Today
LeadShare__c todayLS=sector.getSectorToday(r.leadshare__r);
if(todayLS!=null){
// r.No_of_Leads_Called_Today__c=todayLS.No_of_Leads_Called__c;
// r.Talk_Time_Today__c=todayLS.Talk_Time__c;
// r.Inbound_Calls_Today__c=todayLS.Inbound_Calls__c;
// r.Outbound_Calls_Today__c=todayLS.Outbound_Calls__c;
r.Invalid_Percent_Today__c=sector.getDiv(todayLS.Invalid_Lead__c,todayLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Initial_Contact_Uncalled_Per_Today__c=sector.getDiv(todayLS.Initial_Contact__c,todayLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Lost_Percent_Today__c=sector.getDiv(todayLS.Lost__c,todayLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Closed_Percent_Today__c=sector.getDiv(todayLS.Closed__c,todayLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Working_Today__c=sector.getDiv(todayLS.Working__c,todayLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.No_of_Leads_Worked_Modified_Today__c=todayLS.No_of_Leads_Worked_Modified__c;
}
else{
// r.No_of_Leads_Called_Today__c=0;
// r.Talk_Time_Today__c='0';
// r.Inbound_Calls_Today__c=0;
// r.Outbound_Calls_Today__c=0;
r.Invalid_Percent_Today__c=0;
r.Initial_Contact_Uncalled_Per_Today__c=0;
r.Lost_Percent_Today__c=0;
r.Closed_Percent_Today__c=0;
r.No_of_Leads_Worked_Modified_Today__c=0;
r.Working_Today__c=0;
}
//Yesterday
LeadShare__c yesterdayLS=sector.getSectorYesterday(r.leadshare__r);
if(yesterdayLS!=null){
// r.No_of_Leads_Called_Yesterday__c=yesterdayLS.No_of_Leads_Called__c;
// r.Talk_Time_Yesterday__c=yesterdayLS.Talk_Time__c;
// r.Inbound_Calls_Yesterday__c=yesterdayLS.Inbound_Calls__c;
// r.Outbound_Calls_Yesterday__c=yesterdayLS.Outbound_Calls__c;
r.Invalid_Per_Yesterday__c=sector.getDiv(yesterdayLS.Invalid_Lead__c,yesterdayLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Initial_Contact_Uncalled_Yesterday__c=sector.getDiv(yesterdayLS.Initial_Contact__c,yesterdayLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Lost_Per_Yesterday__c=sector.getDiv(yesterdayLS.Lost__c,yesterdayLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Closed_Per_Yesterday__c=sector.getDiv(yesterdayLS.Closed__c,yesterdayLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Working_Yesterday__c=sector.getDiv(yesterdayLS.Working__c,yesterdayLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.No_of_Leads_Worked_Modified_Yesterday__c=yesterdayLS.No_of_Leads_Worked_Modified__c;
}
else{
// r.No_of_Leads_Called_Yesterday__c=0;
// r.Talk_Time_Yesterday__c='0';
// r.Inbound_Calls_Yesterday__c=0;
// r.Outbound_Calls_Yesterday__c=0;
r.Invalid_Per_Yesterday__c=0;
r.Initial_Contact_Uncalled_Yesterday__c=0;
r.Lost_Per_Yesterday__c=0;
r.Closed_Per_Yesterday__c=0;
r.Working_Yesterday__c=0;
r.No_of_Leads_Worked_Modified_Yesterday__c=0;
}
//This Week
LeadShare__c thisWeekLS=sector.getSectorThisWeek(r.leadshare__r);
if(thisWeekLS!=null){
// r.No_of_Leads_Called_ThisWeek__c=sector.getDiv(thisWeekLS.No_of_Leads_Called__c,thisWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Talk_Time_ThisWeek__c=String.valueOf(sector.getDiv(thisWeekLS.Talk_Time__c,thisWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100);
//Take two decimal points
// r.Talk_Time_ThisWeek__c=sector.getTwoDecimals(r.Talk_Time_ThisWeek__c);
// r.Inbound_Calls_ThisWeek__c=sector.getDiv(thisWeekLS.Inbound_Calls__c,thisWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Outbound_Calls_ThisWeek__c=sector.getDiv(thisWeekLS.Outbound_Calls__c,thisWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Invalid_Per_ThisWeek__c=sector.getDiv(thisWeekLS.Invalid_Lead__c,thisWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Initial_Contact_Uncalled_ThisWeek__c=sector.getDiv(thisWeekLS.Initial_Contact__c,thisWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Lost_Per_ThisWeek__c=sector.getDiv(thisWeekLS.Lost__c,thisWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Closed_Per_ThisWeek__c=sector.getDiv(thisWeekLS.Closed__c,thisWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Working_ThisWeek__c=sector.getDiv(thisWeekLS.Working__c,thisWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.No_of_Leads_Worked_Modified_ThisWeek__c=thisWeekLS.No_of_Leads_Worked_Modified__c;
}
else{
// r.No_of_Leads_Called_ThisWeek__c=0;
// r.Talk_Time_ThisWeek__c='0';
// r.Inbound_Calls_ThisWeek__c=0;
// r.Outbound_Calls_ThisWeek__c=0;
r.Invalid_Per_ThisWeek__c=0;
r.Initial_Contact_Uncalled_ThisWeek__c=0;
r.Lost_Per_ThisWeek__c=0;
r.Closed_Per_ThisWeek__c=0;
r.Working_ThisWeek__c=0;
r.No_of_Leads_Worked_Modified_ThisWeek__c=0;
}
//Last 7 Days
LeadShare__c last7DaysLS=sector.getSectorLast7Days(r.leadshare__r);
if(last7DaysLS!=null){
// r.No_of_Leads_Called_Last7Days__c=sector.getDiv(last7DaysLS.No_of_Leads_Called__c,last7DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Talk_Time_Last7Days__c=String.valueOf(sector.getDiv(last7DaysLS.Talk_Time__c,last7DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100);
// r.Talk_Time_Last7Days__c=sector.getTwoDecimals(r.Talk_Time_Last7Days__c);
// r.Inbound_Calls_Last7Days__c=sector.getDiv(last7DaysLS.Inbound_Calls__c,last7DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Outbound_Calls_Last7Days__c=sector.getDiv(last7DaysLS.Outbound_Calls__c,last7DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Invalid_Per_Last7Days__c=sector.getDiv(last7DaysLS.Invalid_Lead__c,last7DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Initial_Contact_Uncalled_Last7Days__c=sector.getDiv(last7DaysLS.Initial_Contact__c,last7DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Lost_Per_Last7Days__c=sector.getDiv(last7DaysLS.Lost__c,last7DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Closed_Per_Last7Days__c=sector.getDiv(last7DaysLS.Closed__c,last7DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Working_Last7Days__c=sector.getDiv(last7DaysLS.Working__c,last7DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.No_of_Leads_Worked_Modified_Last7Days__c=last7DaysLS.No_of_Leads_Worked_Modified__c;
}
else{
// r.No_of_Leads_Called_Last7Days__c=0;
// r.Talk_Time_Last7Days__c='0';
// r.Inbound_Calls_Last7Days__c=0;
// r.Outbound_Calls_Last7Days__c=0;
r.Invalid_Per_Last7Days__c=0;
r.Initial_Contact_Uncalled_Last7Days__c=0;
r.Lost_Per_Last7Days__c=0;
r.Closed_Per_Last7Days__c=0;
r.Working_Last7Days__c=0;
r.No_of_Leads_Worked_Modified_Last7Days__c=0;
}
//Last Week
LeadShare__c lastWeekLS=sector.getSectorLastWeek(r.leadshare__r);
if(lastWeekLS!=null){
// r.No_of_Leads_Called_LastWeek__c=sector.getDiv(lastWeekLS.No_of_Leads_Called__c,lastWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Talk_Time_LastWeek__c=String.valueOf(sector.getDiv(lastWeekLS.Talk_Time__c,lastWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100);
//get only two decimals
// r.Talk_Time_LastWeek__c=sector.getTwoDecimals(r.Talk_Time_LastWeek__c);
// r.Inbound_Calls_LastWeek__c=sector.getDiv(lastWeekLS.Inbound_Calls__c,lastWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Outbound_Calls_LastWeek__c=sector.getDiv(lastWeekLS.Outbound_Calls__c,lastWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Invalid_Per_LastWeek__c=sector.getDiv(lastWeekLS.Invalid_Lead__c,lastWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Initial_Contact_Uncalled_LastWeek__c=sector.getDiv(lastWeekLS.Initial_Contact__c,lastWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Lost_Per_LastWeek__c=sector.getDiv(lastWeekLS.Lost__c,lastWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Closed_Per_LastWeek__c=sector.getDiv(lastWeekLS.Closed__c,lastWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.No_of_Leads_Worked_Modified_LastWeek__c=lastWeekLS.No_of_Leads_Worked_Modified__c;
r.Working_LastWeek__c=sector.getDiv(lastWeekLS.Working__c,lastWeekLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
}
else{
// r.No_of_Leads_Called_LastWeek__c=0;
// r.Talk_Time_LastWeek__c='0';
// r.Inbound_Calls_LastWeek__c=0;
// r.Outbound_Calls_LastWeek__c=0;
r.Invalid_Per_LastWeek__c=0;
r.Initial_Contact_Uncalled_LastWeek__c=0;
r.Lost_Per_LastWeek__c=0;
r.Closed_Per_LastWeek__c=0;
r.No_of_Leads_Worked_Modified_LastWeek__c=0;
r.Working_LastWeek__c=0;
}
//Last 14 Days
LeadShare__c last14DaysLS=sector.getSectorLast14Days(r.leadshare__r);
if(last14DaysLS!=null){
// r.No_of_Leads_Called_Last14Days__c=sector.getDiv(last14DaysLS.No_of_Leads_Called__c,last14DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Talk_Time_Last14Days__c=String.valueOf(sector.getDiv(last14DaysLS.Talk_Time__c,last14DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100);
//get only two decimals
// r.Talk_Time_Last14Days__c=sector.getTwoDecimals(r.Talk_Time_Last14Days__c);
// r.Inbound_Calls_Last14Days__c=sector.getDiv(last14DaysLS.Inbound_Calls__c,last14DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Outbound_Calls_Last14Days__c=sector.getDiv(last14DaysLS.Outbound_Calls__c,last14DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Invalid_Per_Last14Days__c=sector.getDiv(last14DaysLS.Invalid_Lead__c,last14DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Initial_Contact_Uncalled_Last14Days__c=sector.getDiv(last14DaysLS.Initial_Contact__c,last14DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Lost_Per_Last14Days__c=sector.getDiv(last14DaysLS.Lost__c,last14DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Closed_Per_Last14Days__c=sector.getDiv(last14DaysLS.Closed__c,last14DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.No_of_Leads_Worked_Modified_Last14Days__c=last14DaysLS.No_of_Leads_Worked_Modified__c;
r.Working_Last14Days__c=sector.getDiv(last14DaysLS.Working__c,last14DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
}
else{
// r.No_of_Leads_Called_Last14Days__c=0;
// r.Talk_Time_Last14Days__c='0';
// r.Inbound_Calls_Last14Days__c=0;
// r.Outbound_Calls_Last14Days__c=0;
r.Invalid_Per_Last14Days__c=0;
r.Initial_Contact_Uncalled_Last14Days__c=0;
r.Lost_Per_Last14Days__c=0;
r.Closed_Per_Last14Days__c=0;
r.No_of_Leads_Worked_Modified_Last14Days__c=0;
r.Working_Last14Days__c=0;
}
//This Month
LeadShare__c thisMonthLS=sector.getSectorThisMonth(r.leadshare__r);
if(thisMonthLS!=null){
// r.No_of_Leads_Called_ThisMonth__c=sector.getDiv(thisMonthLS.No_of_Leads_Called__c,thisMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Talk_Time_ThisMonth__c=String.valueOf(sector.getDiv(thisMonthLS.Talk_Time__c,thisMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100);
//get Two Decimals
// r.Talk_Time_ThisMonth__c=sector.getTwoDecimals(r.Talk_Time_ThisMonth__c);
// r.Inbound_Calls_ThisMonth__c=sector.getDiv(thisMonthLS.Inbound_Calls__c,thisMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Outbound_Calls_ThisMonth__c=sector.getDiv(thisMonthLS.Outbound_Calls__c,thisMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Invalid_ThisMonth__c=sector.getDiv(thisMonthLS.Invalid_Lead__c,thisMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Initial_Contact_Uncalled_ThisMonth__c=sector.getDiv(thisMonthLS.Initial_Contact__c,thisMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Lost_Per_ThisMonth__c=sector.getDiv(thisMonthLS.Lost__c,thisMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Closed_Per_ThisMonth__c=sector.getDiv(thisMonthLS.Closed__c,thisMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.No_of_Leads_Worked_Modified_ThisMonth__c=thisMonthLS.No_of_Leads_Worked_Modified__c;
r.Working_ThisMonth__c=sector.getDiv(thisMonthLS.Working__c,thisMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
}
else{
// r.No_of_Leads_Called_ThisMonth__c=0;
// r.Talk_Time_ThisMonth__c='0';
// r.Inbound_Calls_ThisMonth__c=0;
// r.Outbound_Calls_ThisMonth__c=0;
r.Invalid_ThisMonth__c=0;
r.Initial_Contact_Uncalled_ThisMonth__c=0;
r.Lost_Per_ThisMonth__c=0;
r.Closed_Per_ThisMonth__c=0;
r.No_of_Leads_Worked_Modified_ThisMonth__c=0;
r.Working_ThisMonth__c=0;
}
//Last Month
Leadshare__c lastMonthLS=sector.getSectorLastMonth(r.leadshare__r);
if(lastMonthLS!=null){
// r.No_of_Leads_Called_LastMonth__c=sector.getDiv(lastMonthLS.No_of_Leads_Called__c,lastMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Talk_Time_LastMonth__c=String.valueOf(sector.getDiv(lastMonthLS.Talk_Time__c,lastMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100);
//get Two Decimals
// r.Talk_Time_LastMonth__c=sector.getTwoDecimals(r.Talk_Time_LastMonth__c);
// r.Inbound_Calls_LastMonth__c=sector.getDiv(lastMonthLS.Inbound_Calls__c,lastMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Outbound_Calls_LastMonth__c=sector.getDiv(lastMonthLS.Outbound_Calls__c,lastMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Invalid_Per_LastMonth__c=sector.getDiv(lastMonthLS.Invalid_Lead__c,lastMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Initial_Contact_Uncalled_LastMonth__c=sector.getDiv(lastMonthLS.Initial_Contact__c,lastMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Lost_Per_LastMonth__c=sector.getDiv(lastMonthLS.Lost__c,lastMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Closed_Per_LastMonth__c=sector.getDiv(lastMonthLS.Closed__c,lastMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.No_of_Leads_Worked_Modified_LastMonth__c=lastMonthLS.No_of_Leads_Worked_Modified__c;
r.Working_LastMonth__c=sector.getDiv(lastMonthLS.Working__c,lastMonthLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
}
else{
// r.No_of_Leads_Called_LastMonth__c=0;
// r.Talk_Time_LastMonth__c='0';
// r.Inbound_Calls_LastMonth__c=0;
// r.Outbound_Calls_LastMonth__c=0;
r.Invalid_Per_LastMonth__c=0;
r.Initial_Contact_Uncalled_LastMonth__c=0;
r.Lost_Per_LastMonth__c=0;
r.Closed_Per_LastMonth__c=0;
r.No_of_Leads_Worked_Modified_LastMonth__c=0;
r.Working_LastMonth__c=0;
}
//Last 30 Days
LeadShare__c last30DaysLS=sector.getSectorLast30Days(r.leadshare__r);
if(last30DaysLS!=null){
// r.No_of_Leads_Called_Last30Days__c=sector.getDiv(last30DaysLS.No_of_Leads_Called__c,last30DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.TalkTime_Last30Days__c=String.valueOf(sector.getDiv(last30DaysLS.Talk_Time__c,last30DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100);
// get Two Decimals
// r.TalkTime_Last30Days__c=sector.getTwoDecimals(r.TalkTime_Last30Days__c);
// r.Inbound_Calls_Last30Days__c=sector.getDiv(last30DaysLS.Inbound_Calls__c,last30DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
// r.Outbound_Calls_Last30Days__c=sector.getDiv(last30DaysLS.Outbound_Calls__c,last30DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Invalid_Per_Last30Days__c=sector.getDiv(last30DaysLS.Invalid_Lead__c,last30DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Initial_Contact_Uncalled_Last30Days__c=sector.getDiv(last30DaysLS.Initial_Contact__c,last30DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Lost_Per_Last30Days__c=sector.getDiv(last30DaysLS.Lost__c,last30DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.Closed_Per_Last30Days__c=sector.getDiv(last30DaysLS.Closed__c,last30DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
r.No_of_Leads_Worked_Modified_Last30Days__c=last30DaysLS.No_of_Leads_Worked_Modified__c;
r.Working_Last30Days__c=sector.getDiv(last30DaysLS.Working__c,last30DaysLS.Total_Leads_Sales_Rep_Lead_Type__c)*100;
}
else{
// r.No_of_Leads_Called_Last30Days__c=0;
// r.TalkTime_Last30Days__c='0';
// r.Inbound_Calls_Last30Days__c=0;
// r.Outbound_Calls_Last30Days__c=0;
r.Invalid_Per_Last30Days__c=0;
r.Initial_Contact_Uncalled_Last30Days__c=0;
r.Lost_Per_Last30Days__c=0;
r.Closed_Per_Last30Days__c=0;
r.No_of_Leads_Worked_Modified_Last30Days__c=0;
r.Working_Last30Days__c=0;
}
rr_update_list.add(r);
}
update rr_update_list;
}

public Decimal getAssigned(Date lastdate,Date currentdate,List<Leadshare__c> leadshares){
Decimal current_val=0;
Decimal last_val=0;
Decimal result=0;
List<Date> dateslist=new List<Date>();
Map<date,Leadshare__c> datesmap=new Map<date,Leadshare__c>();
//today and yesterday records available
if(leadshares.size()>1){
for(Leadshare__c ls:leadshares){
if(ls.Date__c==currentdate){
current_val=ls.assigned__c;
}
else if(ls.Date__c==lastdate){
last_val=ls.assigned__c;
}
else if(current_val>0
&& last_val>0){
break;
}
dateslist.add(ls.Date__c);
datesmap.put(ls.date__c,ls);
}
}
dateslist.sort();
if(last_val==0
&& leadshares.size()>1){
last_val=datesmap.get(dateslist[0]).assigned__c;
}
System.debug('('+lastdate+' - '+currentdate+')=>'+last_val+'-'+current_val);
if(current_val!=null
&& last_val!=null){
result=Math.abs(last_val-current_val);
}
return result;
}
public String showFields(String sobjectname) {
//fields.clear();
String fields='';
system.debug('name' + sobjectname);
Map <String, Schema.SObjectType> schemaMap = Schema.getGlobalDescribe();
Map <String, Schema.SObjectField> fieldMap = schemaMap.get(sobjectname).getDescribe().fields.getMap();
for(Schema.SObjectField sfield : fieldMap.Values())
{
schema.describefieldresult dfield = sfield.getDescribe();
// system.debug(dfield.getname()+'=>'+dfield.getLabel());
fields+=dfield.getName()+',';
}
fields=fields.removeEnd(',');
System.debug('fields: '+fields);
return fields;
}

public Decimal getCurrentLeadPercent(Date currentdate,List<Leadshare__c> leadshares){
Decimal current_val=0;
for(Leadshare__c ls:leadshares){
if(ls.Date__c==currentdate){
current_val=ls.Round_robin__c;
break;
}
}
return current_val;
}
public Decimal getLeadPercent(Date lastdate,Date currentdate,List<Leadshare__c> leadshares){
Decimal current_val=0;
Decimal last_val=0;
Decimal result=0;
List<Date> dateslist=new List<Date>();
Map<date,Leadshare__c> datesmap=new Map<date,Leadshare__c>();
//today and yesterday records available
if(leadshares.size()>1){
for(Leadshare__c ls:leadshares){
if(ls.Date__c==currentdate){
current_val=ls.Round_robin__c;
}
else if(ls.Date__c==lastdate){
last_val=ls.Round_robin__c;
}
else if(current_val>0
&& last_val>0){
break;
}
dateslist.add(ls.Date__c);
datesmap.put(ls.date__c,ls);
}
}
dateslist.sort();
if(last_val==0
&& leadshares.size()>1){
last_val=datesmap.get(dateslist[0]).Round_robin__c;
}
System.debug('('+lastdate+' - '+currentdate+')=>'+last_val+'-'+current_val);
if(current_val!=null
&& last_val!=null){
result=Math.abs(last_val-current_val);
}
return result;
}
}

Java, Salesforce, Android Samples

Thursday, 28 June 2018

Salesforce - Summarize Totals in Apex based on Date

No comments:

Post a Comment