You can refer the following two triggers:
trigger TaskTrigger on Task (after insert,after delete) {
List<Id> leadIds = new List<Id>();
if (trigger.isInsert) {
for (Task task : trigger.new){
if (task.whoId !=null && string.valueOf(task.whoId).startsWith('00Q')) {
leadIds.add(task.whoId);
}
}
} else if (trigger.isDelete) {
for (Task task : trigger.old){
if (task.whoId !=null && string.valueOf(task.whoId).startsWith('00Q')) {
leadIds.add(task.whoId);
}
}
}
if (leadIds.size() > 0){
Map<Id,Lead> leadMap = new Map<Id,Lead>();
List<Lead> leads = [select id, Times_contacted_by_owner__c,ownerId,(select id,ownerId,subject from events) from lead where Id in :leadIds];
for (Lead lead : leads) {
Integer count = 0;
for (Event event : lead.events) {
if (event.ownerId == lead.OwnerId) {
count ++;
}
}
lead.Times_contacted_by_owner__c = count;
leadMap.put(lead.Id,lead);
}
leads = [select id, Times_contacted_by_owner__c,ownerId,(select id,ownerId,subject from tasks) from lead where Id in :leadIds];
for (Lead lead : leads) {
Integer count = 0;
for (Task task : lead.tasks) {
if (task.ownerId == lead.OwnerId) {
count ++;
}
}
if (leadMap.containsKey(lead.Id))
{
Lead l = leadMap.get(lead.Id);
l.Times_contacted_by_owner__c += count;
leadMap.put(lead.Id,l);
}
else
{
lead.Times_contacted_by_owner__c = count;
leadMap.put(lead.Id,lead);
}
}
update leadMap.values();
}
}
trigger EventTrigger on Event (after insert,after delete) {
List<Id> leadIds = new List<Id>();
if (trigger.isInsert) {
for (Event event : trigger.new){
if (event.whoId !=null && string.valueOf(event.whoId).startsWith('00Q')) {
leadIds.add(event.whoId);
}
}
} else if (trigger.isDelete) {
for (Event event : trigger.old){
if (event.whoId !=null && string.valueOf(event.whoId).startsWith('00Q')) {
leadIds.add(event.whoId);
}
}
}
if (leadIds.size() > 0){
Map<Id,Lead> leadMap = new Map<Id,Lead>();
List<Lead> leads = [select id, Times_contacted_by_owner__c,ownerId,(select id,ownerId,subject from events) from lead where Id in :leadIds];
for (Lead lead : leads) {
Integer count = 0;
for (Event event : lead.events) {
if (event.ownerId == lead.OwnerId) {
count ++;
}
}
lead.Times_contacted_by_owner__c = count;
leadMap.put(lead.Id,lead);
}
leads = [select id, Times_contacted_by_owner__c,ownerId,(select id,ownerId,subject from tasks) from lead where Id in :leadIds];
for (Lead lead : leads) {
Integer count = 0;
for (Task task : lead.tasks) {
if (task.ownerId == lead.OwnerId) {
count ++;
}
}
if (leadMap.containsKey(lead.Id))
{
Lead l = leadMap.get(lead.Id);
l.Times_contacted_by_owner__c += count;
leadMap.put(lead.Id,l);
}
else
{
lead.Times_contacted_by_owner__c = count;
leadMap.put(lead.Id,lead);
}
}
update leadMap.values();
}
}
4 risposte