The ContactId is internal contact attached to the user.
JS Controller:
({
loadContact : function(component, event, helper) {
var action = component.get("c.getContact");
action.setCallback(this, function(response) {
var state = response.getState();
if(state === "SUCCESS") {
component.set("v.contact", response.getReturnValue());
console.log(response.getReturnValue());
}
});
$A.enqueueAction(action);
},
save : function(component, event, helper) {
var action = component.get("c.createCaseRecord");
action.setParams({"caseObj":component.get("v.caseObj")});
action.setCallback(this,function(result){
component.set("v.isShow",true);
var caseId = result.getReturnValue();
var toastEvent = $A.get("e.force:showToast");
toastEvent.setParams({
title: "Success!",
message: "You have successfully submitted the case",
type: "Success"
});
toastEvent.fire();
});
$A.enqueueAction(action);
}
})
Apex class:
public class caseCreate {
@auraenabled
public static Id createCaseRecord(Case caseObj){
upsert caseObj;
return caseObj.id;
}
@AuraEnabled
public static Contact getContact(){
return [SELECT id, Name FROM Contact WHERE Email=: UserInfo.getUserEmail() LIMIT 1];
}
}
The business requirement is to have a lookup relation ship between a Contract and Opportunity. A field on the opportunity must get the SUM of a custom field on the Contracts which belong to the opportunity.
On mass update, I get an error "first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record"
After I lock the Account record, I get "First error: Record Currently Unavailable: The record you are attempting to edit, or one of its related records, is currently being modified by another user. Please try again."
public class contractRollUpCLASS {
@future
public static void calculate(Set<Id> recordIds) {
List<Contract> contrList = [SELECT Id, AccountId, Renewal_Opportunity__c FROM Contract WHERE Id IN : recordIds];
Set<Id> oppIds = new Set<Id>();
Set<Id> accIds = new Set<Id>();
for(Contract con : contrList) {
oppIds.add(con.Renewal_Opportunity__c);
accIds.add(con.AccountId);
}
//lock the account
List<Account> accList = [SELECT Id FROM Account WHERE Id IN : accIds FOR UPDATE];
//Map will contain one Opportunity Id to one sum value.
map<Id, Double> OpportunityMap = new Map<Id,Double>();
List<Opportunity> oppsToUpdate = new List<Opportunity>();
//aggregate result.
for(AggregateResult q : [SELECT Renewal_Opportunity__c, SUM(Latest_PD_Renewal_Amount__c) sumLatest FROM Contract WHERE Renewal_Opportunity__c IN : oppIds AND Latest_PD_Renewal_Amount__c != null GROUP BY Renewal_Opportunity__c]) {
OpportunityMap.put((Id)q.get('Renewal_Opportunity__c'),(Double)q.get('sumLatest'));
}
for(Opportunity opp : [SELECT Id, Annual_Maintenance_Value__c, AccountId FROM Opportunity WHERE Id IN : oppIds]) {
Double sumLatestPD = OpportunityMap.get(opp.Id);
opp.Annual_Maintenance_Value__c = sumLatestPD;
oppsToUpdate.add(opp);
}
update oppsToUpdate;
}
}
The business requirement is to have a lookup relation ship between a Contract and Opportunity. A field on the opportunity must get the SUM of a custom field on the Contracts which belong to the opportunity. I use the @future annotation to increase the CPU time, however, I get an error "Attempt to de-reference a null object".
Here's the code. I got the error on line 6 where I define the Set<ID>
public class contractRollUpCLASS {
@future
public static void calculate() {
//limit the size of list by using Sets which do not contain duplicate elements.
Set<ID> oppIds = new Set<ID>();
//when adding new or updating existing contracts.
if(trigger.isInsert || trigger.isUpdate) {
for(Contract con : (List<Contract>)trigger.new) {
if(con.Is_Obsolete__c == false)
oppIds.add(con.Renewal_Opportunity__c);
}
}
//when deleting contracts.
if(trigger.isDelete){
for(Contract con : (List<Contract>)trigger.old ) {
if(con.Is_Obsolete__c == false)
oppIds.add(con.Renewal_Opportunity__c);
}
}
System.debug('***************NUMBER OF IDS ************** : '+ String.ValueOf(oppIds.size()));
//Map will contain one Opportunity Id to one sum value.
map<Id, Double> OpportunityMap = new Map<Id,Double>();
List<Opportunity> oppsToUpdate = new List<Opportunity>();
//aggregate result.
for(AggregateResult q : [SELECT Renewal_Opportunity__c, SUM(Latest_PD_Renewal_Amount__c) sumLatest FROM Contract WHERE Renewal_Opportunity__c IN : oppIds AND Latest_PD_Renewal_Amount__c != null GROUP BY Renewal_Opportunity__c]) {
OpportunityMap.put((Id)q.get('Renewal_Opportunity__c'),(Double)q.get('sumLatest'));
}
for(Opportunity opp : [SELECT Id, Annual_Maintenance_Value__c FROM Opportunity WHERE Id IN : oppIds]) {
Double sumLatestPD = OpportunityMap.get(opp.Id);
opp.Annual_Maintenance_Value__c = sumLatestPD;
oppsToUpdate.add(opp);
}
update oppsToUpdate;
}
}
The idea is: When a user has been deactivated, assign all of his/her contacts to the owner of the account they belong to. Using the "isActive" field in the IF condition does not work. If I use different field, the code works.
public class InactiveUser {
public static void deactivateUser(List<User> triggerNew, Map<Id, User> oldMap) {
Set<Id> usersId = new Set<Id>();
for(User us : triggerNew) {
if(oldMap.get(us.Id).isActive != us.isActive && us.isActive == false) {
usersId.add(us.Id);
}
}
//create a list of all contacts which belong to the inactive users
List<Contact> contactsList = new List<Contact>();
contactsList = [SELECT Id, OwnerId, Account.OwnerId FROM Contact WHERE OwnerId IN: usersId];
List<Contact> contactsToBeUpdated = new List<Contact>();
//loop through the Contact list and change the ownerId to the Account.OwnerId
for(Contact c : contactsList) {
c.OwnerId = c.Account.OwnerId;
contactsToBeUpdated.add(c);
}
if(contactsToBeUpdated.size() > 0) {
try {
update contactsToBeUpdated;
} catch (System.DmlException ex) {
System.debug(ex);
}
}
}
}
