Salesforce Live

jQuery with callouts and Lightning Process

	<html>

	<head>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
	<link href="https://cdnjs.cloudflare.com/ajax/libs/multiple-select/1.2.0/multiple-select.css" rel="stylesheet"/>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/multiple-select/1.2.0/multiple-select.js"></script>
	<script>

	$(document).ready(function() {
	$.get("https://restcountries.eu/rest/v2/all", function(response) {
	$.each(response, function(idx, obj) {
	var select = $("#countValues");
	$('<option>').val(obj.name).text(obj.name).appendTo(select);
	});
	});
	var select1 = $("#myTable");
	select1.empty();
	var cstmTr1 = '<thead style="background: lightskyblue;"><tr>' +
	'<th>Flag</th>' +
	'<th>Name</th>' +
	'<th>TopLevel Domain</th>' +
	'<th>Alpha Code</th>' +
	'<th>Alpha Code</th>' +
	'<th>Calling Codes</th>' +
	'<th>Capital</th>' +
	'<th>Alt Spellings</th>' +
	'<th>Region</th>' +
	'<th>Subregion</th>' +
	'<th>Population</th>' +
	'<th>Latlng</th>' +
	'<th>Demonym</th>' +
	'<th>Area</th>' +
	'<th>Gini</th>' +
	'<th>Timezones</th>' +
	'<th>Native Name</th>' +
	'<th>Numeric Code</th>' +
	'<th>Currencies</th>' +
	'<th>Languages</th>' +
	'</tr></thead>';
	select1.attr('border', 2);
	$(cstmTr1).appendTo(select1);
	$('<tbody>').appendTo(select1);
	var url = "https://restcountries.eu/rest/v2/all";
	var select = $("#myTable tbody");
	$.get(url, function(response) {

	$.each(response, function(idx, obj) {
	var cstmTr = '<tr>' +
	'<td><img src="' + obj.flag + '" style="width:50px;height:50px;"/></td>' +
	'<td>' + obj.name + '</td>' +
	'<td>' + obj.topLevelDomain + '</td>' +
	'<td>' + obj.alpha2Code + '</td>' +
	'<td>' + obj.alpha3Code + '</td>' +
	'<td>' + obj.callingCodes + '</td>' +
	'<td>' + obj.capital + '</td>' +
	'<td>' + obj.altSpellings + '</td>' +
	'<td>' + obj.region + '</td>' +
	'<td>' + obj.subregion + '</td>' +
	'<td>' + obj.population + '</td>' +
	'<td>' + obj.latlng + '</td>' +
	'<td>' + obj.demonym + '</td>' +
	'<td>' + obj.area + '</td>' +
	'<td>' + obj.gini + '</td>' +
	'<td>' + obj.timezones + '</td>' +
	'<td>' + obj.nativeName + '</td>' +
	'<td>' + obj.numericCode + '</td>' +
	'<td>' + dynamicOption(obj.currencies) + '</td>' +
	'<td>' + dynamicOption1(obj.languages) + '</td>' +
	'</tr>';
	$(cstmTr).appendTo(select);
	});
	});
	});


	$(document).on("change", "#countValues", function() {
	var select1 = $("#myTable");
	select1.empty();
	var cstmTr1 = '<thead style="background: lightskyblue;"><tr>' +
	'<th>Flag</th>' +
	'<th>Name</th>' +
	'<th>TopLevel Domain</th>' +
	'<th>Alpha Code</th>' +
	'<th>Alpha Code</th>' +
	'<th>Calling Codes</th>' +
	'<th>Capital</th>' +
	'<th>Alt Spellings</th>' +
	'<th>Region</th>' +
	'<th>Subregion</th>' +
	'<th>Population</th>' +
	'<th>Latlng</th>' +
	'<th>Demonym</th>' +
	'<th>Area</th>' +
	'<th>Gini</th>' +
	'<th>Timezones</th>' +
	'<th>Native Name</th>' +
	'<th>Numeric Code</th>' +
	'<th>Currencies</th>' +
	'<th>Languages</th>' +
	'</tr></thead>';
	select1.attr('border', 2);
	$(cstmTr1).appendTo(select1);
	$('<tbody>').appendTo(select1);
	var countryValue = this.value;
	var url = "https://restcountries.eu/rest/v2/name/" + countryValue;
	var select = $("#myTable tbody");
	$.get(url, function(response) {

	$.each(response, function(idx, obj) {
	var cstmTr = '<tr>' +
	'<td><img src="' + obj.flag + '" style="width:50px;height:50px;"/></td>' +
	'<td>' + obj.name + '</td>' +
	'<td>' + obj.topLevelDomain + '</td>' +
	'<td>' + obj.alpha2Code + '</td>' +
	'<td>' + obj.alpha3Code + '</td>' +
	'<td>' + obj.callingCodes + '</td>' +
	'<td>' + obj.capital + '</td>' +
	'<td>' + obj.altSpellings + '</td>' +
	'<td>' + obj.region + '</td>' +
	'<td>' + obj.subregion + '</td>' +
	'<td>' + obj.population + '</td>' +
	'<td>' + obj.latlng + '</td>' +
	'<td>' + obj.demonym + '</td>' +
	'<td>' + obj.area + '</td>' +
	'<td>' + obj.gini + '</td>' +
	'<td>' + obj.timezones + '</td>' +
	'<td>' + obj.nativeName + '</td>' +
	'<td>' + obj.numericCode + '</td>' +
	'<td>' + dynamicOption(obj.currencies) + '</td>' +
	'<td>' + dynamicOption1(obj.languages) + '</td>' +
	'</tr>';
	$(cstmTr).appendTo(select);
	});
	});
	});
	function dynamicOption(parameter1) {
	$select = $('<select></select>', {
	"class": "fazu"
	});
	var tempString = '';
	$.each(parameter1, function(index, value) {
	tempString += value.code+",";
	tempString += value.name+",";
	tempString += value.symbol;
	});
	for(var temp in tempString.split(",")){
	console.log("tempString value ::"+tempString.split(",")[temp]);
	var $option = $("<option></option>", {
	"text": tempString.split(",")[temp],
	"value": tempString.split(",")[temp]
	});
	$select.append($option);

	}
	return $select.prop("outerHTML");
	}
	function dynamicOption1(parameter1) {
	$select = $('<select></select>', {"class": "fazu"});
	var tempString = '';
	$.each(parameter1, function(index, value) {
	console.log(JSON.stringify(value));
	tempString += value.iso639_1+","+value.iso639_2+","+value.name+","+value.nativeName;
	});
	for(var temp in tempString.split(",")){
	console.log("tempString value ::"+tempString.split(",")[temp]);
	var $option = $("<option></option>", {
	"text": tempString.split(",")[temp],
	"value": tempString.split(",")[temp]
	});
	$select.append($option);
	}
	return $select.prop("outerHTML");
	}
	</script>
	</head>

	<body>
	<select id="countValues"></select>
	<br/>
	<table id="myTable">

	<tbody></tbody>
	</table>
	</body>

	</html>

Integration between Spark to salesforce using Gupshup platform salesforce

Code Here :

/*
* ******************************************************************************************************************
* Author : Fazurulla Ganganapalli
* Controller : MarketingBot.js
* Marketing Bot : This controller is rsponsible for integration between Spark to salesforce using Gupshup platform
* Date : 05/13/2017
* History :
*******************************************************************************************************************
*/

//Variable declaration
var access_token = null;
var choiceString = '';
var moreChoiceString = '';
var userName ='';
var listLeadIds = '';
var choiceUniqueNumber;
var firstName ='';
var mainQuery = '';
var lastName='';
var userCECId='';
var contactCenter ='';
var profileName = '';
var tempAppString ='';
var tempSplitGreetString ='';
var permissionSet = '';
var userID_P = '';
var userPermission_P = '';

//Salesforce Oauth 2.0 settings and url's
var url_AccessToken = "https://login.salesforce.com/services/oauth2/token";
var url_getMethodAuth = "https://ap1.salesforce.com/services/data/v20.0/sobjects/Marketing_ChatBot__c/Application__c";
var authParams = "grant_type=password&client_id=3MVG9Y6d_Btp4xp5fHfBCvTWgHlfBKxrEf0lFIt9p71zfTmei0q9P8QxoaRowTIefchOoNdY8syyWOriUKYlV&client_secret=7975635620731036814&redirect_uri=https://localhost:8443/_callback&username=apex_integration@sfdc.com&password=Mardal786*k7Q58cu1ffXZEm0NOEgWi8vIv";
var authHeader = {"Content-Type":"application/x-www-form-urlencoded"};
var leadReopen_Url = "https://ap1.salesforce.com/services/apexrest/marketingActivities";
var url_CompleteApps = "https://ap1.salesforce.com/services/apexrest/marketingChatBotOprions";
var url_Application ="https://ap1.salesforce.com/services/apexrest/marketingChatBot";

//@Method : This method is responsible for handling choice based options
function MessageHandler(context, event) {
var StrMain = event.message;
var splitString = "ngcc,mods,jifflenow,grs,eloqua,cpc";
var splitGreetString ="Hi,hi,Hello,hello,Bot,bot,Chatbot,chatbot,Marketing,marketing,SFDC,Sfdc,sfdc";

if(splitString != "" || splitString != NULL){
var resString = splitString.split(",");
for(var i in resString){
if(resString[i] == StrMain){
tempAppString = resString[i];
context.console.log("tempAppString---->>>>"+tempAppString);
}
}
}

if(splitGreetString != "" || splitGreetString != NULL){
var resString = splitGreetString.split(",");
for(var i in resString){
if(resString[i] == StrMain){
tempSplitGreetString = resString[i];
context.console.log("tempSplitGreetString---->>>>"+tempSplitGreetString);
}
}
}

if(event.message.toLowerCase() == tempSplitGreetString){
context.sendResponse("Hello There- \n"+
"Welcome to Markting Bot- \n"+
"I. Help (This will provide quick help about the issues in an application which we get on daily basis)\n "+
"II. Lead (This would help to Re-Open closed leads) \n "+
"II. Access (We will be able to create new users in SFDC through Spark) \n "
);
}else if(event.message.toLowerCase() == "your from which location"){
context.sendResponse("I am from Bengalore City");
}else if(event.message.toLowerCase() == "fine thanks" || event.message.toLowerCase() == "fine"){
context.sendResponse("Ok. How may i help you today !");
}else if(event.message.toLowerCase() == "what is your name"){
context.sendResponse("My name is Marketing Bot");
}else if(event.message.toLowerCase() == "may i know you name"){
context.sendResponse("My name is Marketing Bot");
}else if(event.message.toLowerCase() == "how are you"){
context.sendResponse("I am doing great thanks..How about you ?");
}else if(event.message.toLowerCase() == "I need some help from you"){
context.sendResponse("Sure. How can I help you today?");
}else if(event.message.toLowerCase() == "how can i start"){
context.sendResponse("Search with any keyword like : help, lead, access");
}else if(event.message.toLowerCase() == "bye"){
context.sendResponse("Bye have a good day !");
}else if(event.message.toLowerCase() == "help"){
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setApplication);

//*******************************************Applciation Search Start here********************************************************
}else if(event.message.toLowerCase() == "ngcc"){
moreChoiceString = event.message;
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setHelp);
}else if(event.message.toLowerCase() == "mods"){
moreChoiceString = event.message;
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setHelp);
}else if(event.message.toLowerCase() == "jifflenow"){
moreChoiceString = event.message;
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setHelp);
}else if(event.message.toLowerCase() == "grs"){
moreChoiceString = event.message;
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setHelp);
}else if(event.message.toLowerCase() == "eloqua"){
moreChoiceString = event.message;
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setHelp);
}else if(event.message.toLowerCase() == "cpc"){
moreChoiceString = event.message;
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setHelp);

//*****************************************Application Search end here**********************************************************
}else if(event.message.toLowerCase() == "lead"){
context.sendResponse(
"Please make a selection - \n"+
"A). Lead Re-Open \n "+
"B). Access Help\n "+
"C). Create New User/Access Provide\n "+
"D). Assign Permission Sets\n "+
"E). SOQL Records\n "
);
}else if(event.message.toLowerCase() == "access"){
context.sendResponse(
"Please make a selection - \n"+
"A). Lead Re-Open \n "+
"B). Access Help\n "+
"C). Create New User\n "+
"D). Assign Permission Sets\n "+
"E). SOQL Records\n "
);
}else{
var StrMain = event.message;
var res = StrMain.split(/,|:|-| /);
for(var i in res){
if(i==0){
choiceString = res[i];
}else if(i==1){
userName = res[i];
}else{
listLeadIds += res[i]+",";
}
}

for(var i in res){
if(i==0){
choiceString = res[i];
}else if(i==1){
firstName = res[i];
}else if(i==2){
lastName = res[i];
}else if(i==3){
userCECId = res[i];
}else if(i==4){
contactCenter = res[i];
}else if(i==5){
profileName = res[i];
}else if(i==6){
permissionSet = res[i];
}
}
var permissionString = event.message;
var permission = permissionString.split(' ');
for(var i in permission){
if(i==0){
choiceString = permission[i];
}else if(i==1){
userID_P = permission[i];
}else{
userPermission_P += permission[i]+",";
}
}

var soqlQuery = event.message;
var soql = soqlQuery.split(' ');
for(var i in soql){
if(i==0){
choiceString = soql[i];
}else{
mainQuery += soql[i]+" ";
}
}

if(choiceString.toLowerCase() == "a"){
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setNGCC);
}else if(choiceString.toLowerCase() == "b"){
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setAccessProfile);
}else if(choiceString.toLowerCase() == "c"){
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setUserCreation);
}else if(choiceString.toLowerCase() == "d"){
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setUserPermission);
}else if(choiceString.toLowerCase() == "e"){
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setSOQL);
}else if(event.message.toLowerCase() == StrMain){
choiceUniqueNumber = event.message;
context.simplehttp.makePost(url_AccessToken,authParams,authHeader,setNumbers);
}else{
context.sendResponse("Sorry you have entered an invalid keyword");
}
}
}

//***************************************************************************************************
//@Method : Responsible for iterate response and get values from salesforce.com database
function setNGCC(context,event){
if(userName ==''&& listLeadIds ==''){
context.sendResponse(
"Please enter User CECID and list of Lead IDs.Below are the possible ways to follow- \n"+
"I. A,UserID,Single LeadID or List of LeadIDs(Separated with comma) \n"+
"II. A UserID Single LeadID or List of LeadIDs(separated with space)\n"
);
}else{
var result= JSON.parse(event.getresp);
access_token = result.access_token;
context.simplehttp.makeGet(leadReopen_Url+"?username="+userName+"&LeadId="+listLeadIds,{"Content-Type":"application/json","Authorization":"OAuth "+access_token},getNGCC);
}
}

//@Method: Responsible for iterating and parsing JSON response into user understandable language
function getNGCC(context,event){
context.sendResponse(event.getresp);
}
//@Method : Responsible for iterate response and get values from salesforce.com database
function setNumbers(context,event){
var result= JSON.parse(event.getresp);
access_token = result.access_token;
context.simplehttp.makeGet("https://ap1.salesforce.com/services/data/v20.0/sobjects/Marketing_ChatBot__c/Choice_Unique_Number__c/"+choiceUniqueNumber,{"Content-Type":"application/json","Authorization":"OAuth "+access_token},getNumbers);
}

//@Method: Responsible for iterating and parsing JSON response into user understandable language
function getNumbers(context,event){
//context.sendResponse(event.getresp);
var contacts = JSON.parse(event.getresp);
var tempStr = '';
var Application__c = contacts.Application__c;
var Entity__c = contacts.Entity__c;
var Issue__c = contacts.Issue__c;
var Solution__c = contacts.Solution__c;
var Description__c = contacts.Description__c;
tempStr += "Application Name :"+Application__c+"\n Entity Name : "+Entity__c+"\n Issue : "+Issue__c+"\n Issue Description :"+Solution__c+"\n Answer Steps : \n"+Description__c+"\n";
context.sendResponse(tempStr);

}
//***************************************************************************************************

//***************************************************************************************************
//@Method : Responsible for iterate response and get values from salesforce.com database
function setApplication(context,event){
var result= JSON.parse(event.getresp);
access_token = result.access_token;
context.simplehttp.makeGet(url_Application,{"Content-Type":"application/json","Authorization":"OAuth "+access_token},getApplication);
}

//@Method: Responsible for iterating and parsing JSON response into user understandable language
function getApplication(context,event){
//context.sendResponse(event.getresp);
var contacts = JSON.parse(event.getresp);
var tempStr = '';
for(var i in contacts){
tempStr +="*. "+i+"\n";
}
context.sendResponse("Please make a selection - \n"+tempStr);
}
//***************************************************************************************************

//***************************************************************************************************
//@Method : Responsible for iterate response and get values from salesforce.com database
function setHelp(context,event){
var result= JSON.parse(event.getresp);
access_token = result.access_token;
context.simplehttp.makeGet(url_CompleteApps+'/'+moreChoiceString,{"Content-Type":"application/json","Authorization":"OAuth "+access_token},getHelp);
}

//@Method: Responsible for iterating and parsing JSON response into user understandable language
function getHelp(context,event){
var contacts = JSON.parse(event.getresp);
var tempStr = '';
for(var i in contacts){
tempStr +=i+". "+contacts[i]+"\n";
}
context.sendResponse("Please Search with numbers only-\n\n"+tempStr);
}
//***************************************************************************************************
function EventHandler(context, event) {
if(! context.simpledb.botleveldata.numinstance)
context.simpledb.botleveldata.numinstance = 0;
numinstances = parseInt(context.simpledb.botleveldata.numinstance) + 1;
context.simpledb.botleveldata.numinstance = numinstances;
context.sendResponse("Thanks for adding me. You are:" + numinstances);
}

function setAccessProfile(context,event){
var result= JSON.parse(event.getresp);
access_token = result.access_token;
context.simplehttp.makeGet("https://ap1.salesforce.com/services/apexrest/marketingActivitiesUser",{"Content-Type":"application/json","Authorization":"OAuth "+access_token},getAccessProfile);
}

//@Method: Responsible for iterating and parsing JSON response into user understandable language
function getAccessProfile(context,event){
var contacts = JSON.parse(event.getresp);
var tempStr = '';
for(var i in contacts){
tempStr +=i+" - "+contacts[i]+"\n";
}
context.sendResponse("\n"+tempStr);
}
//***************************************************************************************************
//@Method : Responsible for iterate response and get values from salesforce.com database
function setUserCreation(context,event){
if(firstName =='' && lastName =='' && userCECId =='' && contactCenter =='' && profileName==''&& permissionSet==''){
context.sendResponse(
"Please provide the below details- \n"+
"I. Option you need to select - C \n"+
"II. First Name\n" +
"III. Last Name\n"+
"IV. User CEC ID\n"+
"V. Marketing Contact Center(Press *B* and copy paste your Contact Center)\n"+
"V. User Profile Name(Press *B* you will get help from SFDC)\n"+
"VI. Permission Set (Press *B* you will get help from SFDC)\n"
);
}else{
var result= JSON.parse(event.getresp);
access_token = result.access_token;
context.simplehttp.makeGet("https://ap1.salesforce.com/services/apexrest/marktingUserCreating?firstName="+firstName+"&lastName="+lastName+"&userId="+userCECId+"&contactCenter="+contactCenter+"&profileName="+profileName+"&permissionSet="+permissionSet,{"Content-Type":"application/json","Authorization":"OAuth "+access_token},getUserCreation);
}
}

//@Method: Responsible for iterating and parsing JSON response into user understandable language
function getUserCreation(context,event){
context.sendResponse(event.getresp);
}

function setUserPermission(context,event){
if(userID_P =='' && userPermission_P ==''){
context.sendResponse(
"Please provide the below details- \n"+
"I. Option you need to select as - D \n"+
"II. Provide User CEC ID\n" +
"III. List of Permission Sets\n"
);
}else{
var result= JSON.parse(event.getresp);//setSOQL
access_token = result.access_token;
context.simplehttp.makeGet("https://ap1.salesforce.com/services/apexrest/marktingUserCreatingPermissions?userId="+userID_P+"&permissions="+userPermission_P,{"Content-Type":"application/json","Authorization":"OAuth "+access_token},getUserPermission);
}
}

//@Method: Responsible for iterating and parsing JSON response into user understandable language
function getUserPermission(context,event){
context.sendResponse(event.getresp);
}
function setSOQL(context,event){
if(userID_P =='' && userPermission_P ==''){
context.sendResponse(
"Please provide the below details- \n"+
"I. Option you need to select as - E \n"+
"II. Write SOQL query "
);
}else{
var result= JSON.parse(event.getresp);//setSOQL
access_token = result.access_token;
context.simplehttp.makeGet("https://ap1.salesforce.com/services/data/v20.0/query/?q="+mainQuery,{"Content-Type":"application/json","Authorization":"OAuth "+access_token},getSOQL);
}
}

//@Method: Responsible for iterating and parsing JSON response into user understandable language
function getSOQL(context,event){
var contacts = JSON.parse(event.getresp);
context.sendResponse("\n"+event.getresp);
var tempStr = '';
var TotalSize = contacts.totalSize;
var Status = contacts.done;
tempStr +="TotalSize : "+TotalSize+"\n Status : "+Status+"\n";
var recordsList = contacts.records;
//context.sendResponse("\n"+recordsList);
for(var i in recordsList){

if(recordsList[i].Id == ''){}
else
tempStr += "Id :"+recordsList[i].Id+"\n";

if(recordsList[i].Username == ''){}
else
tempStr += "Username :"+recordsList[i].Username+"\n";

if(recordsList[i].FirstName == ''){}
else
tempStr += "FirstName :"+recordsList[i].FirstName+"\n";

tempStr += "LastName :"+recordsList[i].LastName+"\n";
tempStr += "Name :"+recordsList[i].Name+"\n";
tempStr += "Title :"+recordsList[i].Title+"\n";
tempStr += "CompanyName "+recordsList[i].CompanyName+"\n";
tempStr += "Address :"+recordsList[i].Address+"\n";
tempStr += "Email "+recordsList[i].Email+"\n";
tempStr += "Phone :"+recordsList[i].Phone+"\n";
tempStr += "CommunityNickname :"+recordsList[i].CommunityNickname+"\n";
tempStr += "UserRoleId :"+recordsList[i].UserRoleId+"\n";
tempStr += "ProfileId :"+recordsList[i].ProfileId+"\n";
tempStr += "UserPermissionsMarketingUser :"+recordsList[i].UserPermissionsMarketingUser+"\n";
tempStr += "UserPermissionsSupportUser :"+recordsList[i].UserPermissionsSupportUser+"\n";
tempStr += "Marketing_Call_Center__c : "+recordsList[i].Marketing_Call_Center__c+"\n";
}
//context.sendResponse("\n"+tempStr);
}

//######
//Auto generated code from devbox
//######

exports.onMessage = MessageHandler;
exports.onEvent = EventHandler;
exports.onHttpResponse = HttpResponseHandler;
exports.onDbGet = DbGetHandler;
exports.onDbPut = DbPutHandler;
if(typeof LocationHandler == 'function'){exports.onLocation = LocationHandler;}

if(typeof HttpEndpointHandler == 'function'){exports.onHttpEndpoint = HttpEndpointHandler;}

Parent field update with all related childs in salesforce

Trigger :

trigger answerOptionManagement on Employees__c (before update) {
Set<Id> setIDS = new Set<Id>();
List<Employees__c> listIDS = new List<Employees__c>();
for(Employees__c emp : trigger.new){
setIDS.add(emp.Id);
listIDS.add(emp);
}
if(!listIDS.isEmpty() && listIDS.size()>0){
cmdMainOperation(listIDS,setIDS);
}
public static void cmdMainOperation(List<Employees__c> listIDS,Set<Id> setIDS){
AggregateResult [] aggr = [select count(id),First_Name__c fristName,Employees__c employeeId from Contact_Us__c where Employees__c IN :setIDS and First_Name__c != null group by First_Name__c,Employees__c order by First_Name__c desc];
system.debug(aggr);
Map<Id,String> mapAggr = new Map<Id,String>();
for(AggregateResult agr : aggr){
system.debug(mapAggr);
string category=String.valueOf(agr.get('fristName'));
category = category.subString(category.indexOf(':')+1,category.length());
if(mapAggr.containsKey(String.valueOf(agr.get('employeeId')))){
String strCategory = mapAggr.get(String.valueOf(agr.get('employeeId')))+ ','+category;
mapAggr.put(String.valueOf(agr.get('employeeId')),strCategory );
system.debug('mapAggr in if 21 line--->>'+mapAggr);
}else{
mapAggr.put(String.valueOf(agr.get('employeeId')),category);
system.debug('mapAggr in if 24 line--->>'+mapAggr);
}
}
for(Employees__c emp : listIDS){
if(mapAggr.containsKey(emp.id)){
emp.Answer_Options__c = mapAggr.get(emp.id);
system.debug('emp.Answer_Options__c in if 30 line--->>'+emp.Answer_Options__c);
}

}

}

}

Standard Report charts in Lightning component Salesforce

Create summary report using standard Report tab. For this example, I have created a simple report which groups ContactUS__c by City__c.

Apex code snippet :

public class ChartOnContactUS {
@AuraEnabled
public static List<Report> getDynamicReport(){
return [SELECT Id,Name FROM Report];
}
@AuraEnabled
public static String getreport(String reportId){
Report reportRec = [SELECT Id FROM Report WHERE Id =:reportId];
Reports.ReportResults reportResult = Reports.ReportManager.runReport(reportRec.Id, true);
system.debug(JSON.serialize(reportResult));
return JSON.serialize(reportResult);
}
}

ChartComponent.cmp

<aura:component controller="ChartOnContactUS" implements="force:appHostable,flexipage:availableForAllPageTypes,flexipage:availableForRecordHome,force:hasRecordId,forceCommunity:availableForAllPageTypes,force:lightningQuickAction" access="global" >
<ltng:require scripts="{!$Resource.ChartJs}" afterScriptsLoaded="{!c.afterScriptsLoaded}"/>
<aura:attribute name="ready" type="Boolean" default="false"/>
<aura:attribute name="countryName" type="String" default="00O0Y000007eZRnUAM"/>
<aura:attribute name="report" type="sobject"/>
<div class="slds-grid slds-p-top_small">
<div class="slds-size_4-of-12 slds-p-left_xx-small slds-p-horizontal_x-large ">
<lightning:select label="Report Name" value="{!v.countryName}" onchange="{!c.cmdCountryEvt}">>
<aura:iteration items="{!v.report}" var="reportValue">
<option value="{!reportValue.Id}">{!reportValue.Name}</option>
</aura:iteration>
</lightning:select>
</div>
</div>
<div class="slds-grid slds-wrap slds-grid--pull-padded ">
<div class="slds-p-horizontal--small slds-size--1-of-3 slds-m-top--medium">
<canvas aura:id="chart" height="200" width="200"></canvas>
</div>
</div>
</aura:component>

ChartComponentController.js

({
afterScriptsLoaded : function(component, event, helper) {
component.set("v.ready", true);
helper.createChart(component);
helper.cmdDynamicRepor(component);
},
cmdCountryEvt : function(component,event,helper){
console.log(component.get("v.countryName"));
helper.createChart(component);
}

})

ChartComponentHelper.js

({
createChart : function (component) {
var chartCanvas = component.find("chart").getElement();
var action = component.get("c.getreport");
action.setParams({reportId : component.get("v.countryName")});
action.setCallback(this, function(response) {
console.log("faz response"+JSON.stringify(response.getReturnValue()));
var state = response.getState();
if (state === "SUCCESS") {
var reportResultData = JSON.parse(response.getReturnValue());
var chartData = [];
var chartLabels = [];
if( reportResultData.groupingsDown.groupings.length > 0 ) {
for(var i=0; i < (reportResultData.groupingsDown.groupings.length); i++){
chartLabels.push(reportResultData.groupingsDown.groupings[i].label);
var keyTemp = reportResultData.groupingsDown.groupings[i].key;
var valueTemp = reportResultData.factMap[keyTemp + '!T'].aggregates[0].value ;
chartData.push(valueTemp);
}
console.log(" chartLabels :: " + JSON.stringify(chartLabels));
console.log( " chartData :: " + JSON.stringify(chartData));
var chartdata = {
labels: chartLabels,
datasets: [
{
label:'Country',
data: chartData,
borderColor:'rgba(62, 159, 222, 1)',
fill: false,
pointBackgroundColor: "#FFFFFF",
pointBorderWidth: 4,
pointHoverRadius: 5,
pointRadius: 3,
bezierCurve: true,
pointHitRadius: 10
}
]
}
var ctx = component.find("chart").getElement();
var chart = new Chart(ctx ,{
type: 'line',
data: chartdata,
options: {
legend: {
position: 'bottom',
padding: 10,
},
responsive: true
}
});
}
} else if (state === "ERROR") {
var errors = response.getError();
if (errors) {
if (errors[0] && errors[0].message) {
console.log("Error message on createReport: " +errors[0].message);
}
} else {
console.log("Unknown error");
}
}
});
$A.enqueueAction(action);
},
cmdDynamicRepor : function(component,event,helper){
var dynamicPicklist = component.get("c.getDynamicReport");
dynamicPicklist.setCallback(this,function(response){
console.log("getDynamicReport====>>"+JSON.stringify(response.getReturnValue()));
if(response.getState() === "SUCCESS"){
component.set("v.report",response.getReturnValue());
}
});
$A.enqueueAction(dynamicPicklist);
}
})

D3ComponentApp

<aura:application extends="force:slds">

<c:ChartComponent ></c:ChartComponent>

</aura:application>

Screenshot

Salesforce Lightning Events with example

Passing values from child component to parent component using Lightning Events.

CeeeEvent:

<aura:event type="COMPONENT">
<aura:attribute name="firstName" type="String"/>
<aura:attribute name="lastName" type="String"/>
<aura:attribute name="emailId" type="String"/>
<aura:attribute name="mobileNumber" type="String"/>
<aura:attribute name="contactDetails" type="Contact[]"/>

</aura:event>

Child component : CeeeCmponent1

<aura:component controller="contactHanler">
<aura:attribute name="firstName" type="String"/>
<aura:attribute name="lastName" type="String"/>
<aura:attribute name="emailId" type="String"/>
<aura:attribute name="mobileNumber" type="String"/>
<aura:attribute name="contactDetails" type="Contact[]"/>
<aura:registerEvent name="cmpEvent" type="c:CeeeEvent"/>
<lightning:input type="text" label="First Name" value="{!v.firstName}"/>
<lightning:input type="text" label="Last Name" value="{!v.lastName}"/>
<lightning:input type="text" label="Email ID" value="{!v.emailId}"/>
<lightning:input type="text" label="Phone" value="{!v.mobileNumber}"/>
<lightning:button label="Search" onclick="{!c.fireComponentEvent}" />

</aura:component>

ControllerJS :

({
fireComponentEvent : function(cmp, event) {
var cmpEvent = cmp.getEvent("cmpEvent");
var action = cmp.get("c.getAFewContacts");
action.setCallback(this,function(response){
console.log("response.getState---"+response.getState());
console.log("response.code---"+response.getReturnValue());
cmp.set("v.contactDetails",response.getReturnValue());
if(response.getState() === "SUCCESS"){
cmpEvent.setParams({
"firstName" : cmp.get("v.firstName"),
"lastName" : cmp.get("v.lastName"),
"emailId" : cmp.get("v.emailId"),
"mobileNumber" : cmp.get("v.mobileNumber"),
"contactDetails" : cmp.get("v.contactDetails")
});
cmpEvent.fire();
console.log("contact list---"+JSON.stringify(cmp.get("v.contactDetails")));
}
});
$A.enqueueAction(action);
}

})

Parent Handler : CeeeParentHandler

<aura:component>
<aura:attribute name="firstName" type="String"/>
<aura:attribute name="lastName" type="String"/>
<aura:attribute name="emailId" type="String"/>
<aura:attribute name="mobileNumber" type="String"/>
<aura:attribute name="contactDetails" type="Contact[]"/>
<aura:attribute name="numEvents" type="Integer" default="0"/>
<aura:handler name="cmpEvent" event="c:CeeeEvent" action="{!c.handleComponentEvent}"/>
<c:CeeeCmponent1/>
<p>{!v.firstName}</p>
<p>{!v.lastName}</p>
<p>{!v.emailId}</p>
<p>{!v.mobileNumber}</p>
<p>Number of events: {!v.numEvents}</p>
<aura:iteration items="{!v.contactDetails}" var="item">
{!item.Id}{!item.Email}<br/>
</aura:iteration>
</aura:component>

ControllerJS:

({
handleComponentEvent : function(cmp, event) {
console.log(event.getParams().firstName);
console.log(event.getParams().lastName);
console.log(event.getParams().emailId);
console.log(event.getParams().mobileNumber);
cmp.set("v.firstName", event.getParams().firstName);
cmp.set("v.lastName", event.getParams().lastName);
cmp.set("v.emailId", event.getParams().emailId);
cmp.set("v.mobileNumber", event.getParams().mobileNumber);
cmp.set("v.contactDetails", event.getParams().contactDetails);
var numEventsHandled = parseInt(cmp.get("v.numEvents")) + 1;
cmp.set("v.numEvents", numEventsHandled);
}
})

Apex Controller : contactHanler

public class contactHanler {
@AuraEnabled public static List<Contact> getAFewContacts(){
return [select Id,Name,Email from contact];
}
}

CeeeHandlerApp :

<aura:application extends="force:slds">
<c:CeeeHandler></c:CeeeHandler>
</aura:application>

Salesforce Database.saveResult and Database.Error example

Code snippet :

List<Contact> con = [select id,lastname,AccountId from contact order by createddate desc Limit 20];
//Map<Id,Contact> conAcc = new Map<Id,Contact>();
Set<Id> conSet = new Set<Id>();
for(contact conn : con){
if(String.isNotBlank(conn.AccountId)){
conSet.add(conn.AccountId);
}
}
Map<Id,Account> conAcc = new Map<Id,Account>([select Id,name from account where Id IN : conSet]);
for(contact connn :con){
if(conAcc.containsKey(connn.AccountId)){
connn.lastname = connn.lastname +'--'+ conAcc.get(connn.AccountId).name;
}
}
Database.SaveResult[] res = database.update(con,false);
List<Database.Error> dError = new List<Database.Error>();
system.debug(res);
for(Database.SaveResult result :res){
if(result.isSuccess()){
system.debug('Pass--->>'+result.getId());
}else{
system.debug('faled--->>'+result.getErrors());
dError.addAll(result.getErrors());
}
}
for(Database.Error r : dError){
system.debug('Fields ---->>>'+r.getFields());
system.debug('Messages ---->>>'+r.getMessage());
system.debug('Status Code ---->>>'+r.getStatusCode());

}

Callouts from lightining components salesforce

Class Code Snippet :

public class httpCallOutCtrl {

@AuraEnabled public static List < String > getBaseValues() {

List < String > options = new List < String > ();

options.add('AUD');

options.add('BGN');

options.add('BRL');

options.add('CAD');

options.add('CHF');

options.add('CNY');

options.add('CZK');

options.add('DKK');

options.add('EUR');

options.add('GBP');

options.add('HKD');

options.add('HRK');

options.add('HUF');

options.add('IDR');

options.add('ILS');

options.add('INR');

options.add('JPY');

options.add('KRW');

options.add('MXN');

options.add('MYR');

options.add('NOK');

options.add('NZD');

options.add('PHP');

options.add('PLN');

options.add('RON');

options.add('RUB');

options.add('SEK');

options.add('SGD');

options.add('THB');

options.add('TRY');

options.add('ZAR');

List<Account> acct = [select name from account where name != null order by name desc];

for(Account a : acct){

options.add(a.name);

}

return options;

}

@AuraEnabled public static Map < String,Object > getCalloutResponseContents(String url) {

Http h = new Http();

HttpRequest req = new HttpRequest();

req.setEndpoint(url);

req.setMethod('GET');

HttpResponse res = h.send(req);

System.debug('response:--> ' + res.getBody());

Map < String, Object > resultsMap = (Map < String, Object > ) JSON.deserializeUntyped(res.getBody());

system.debug('resultsMap-->' + resultsMap);

return resultsMap;

}

Aura App :

<aura:application extends="force:slds">

<ltng:require styles="/resource/slds202/assets/styles/salesforce-lightning-design-system.css"/>

<c:SampleComponent/>

</aura:application>

Component :

<aura:component controller="httpCallOutCtrl">

<aura:attribute name="response" type="Map" />

<aura:attribute name="ListOfCurrency" type="String[]" />

<aura:handler name="init" value="{!this}" action="{!c.doInit}" />

<div class="slds-m-around--medium">

<div class="slds-page-header" role="banner">

<div class="slds-media__body">

<p class="slds-page-header__title slds-truncate" title="foreign exchange rates">HTTP Callout Exchange Rates</p><br/><br/>

<div class="slds-form-element">

<div class="slds-form-element__control">

<div class="slds-select_container">

<ui:inputSelect label="Select Industry   " class="dynamic" aura:id="InputAccountIndustry" change="{!c.onPicklistChange}" />

</div>

<h3 class="slds-section-title--divider"> Base : {!v.response.base}</h3>

<h3 class="slds-section-title--divider"> Date : {!v.response.date}</h3>

<ul class="slds-list--dotted">

<aura:iteration items="{!v.ListOfCurrency}" var="rateLst">

<li>{!rateLst}</li>

</aura:iteration>

</ul>

</div>

</aura:component>

ControllerJS :

({

doInit: function(component, event, helper) {

var action = component.get("c.getBaseValues");

var inputIndustry = component.find("InputAccountIndustry");

var opts = [];

action.setCallback(this, function(a) {

opts.push({

class: "optionClass",

label: "--- None ---",

value: ""

});

for (var i = 0; i < a.getReturnValue().length; i++) {

opts.push({

"class": "optionClass",

label: a.getReturnValue()[i],

value: a.getReturnValue()[i]

});

}

inputIndustry.set("v.options", opts);

});

$A.enqueueAction(action);

calloutCtrl: function(component, event, helper) {

var base = 'USD';

console.log(base);

helper.getResponse(component, base);

onSingleSelectChange: function(cmp) {

var selectCmp = cmp.find("InputSelectSingle");

var resultCmp = cmp.find("singleResult");

resultCmp.set("v.value", selectCmp.get("v.value"));

onPicklistChange: function(component, event, helper) {

var selectedIndustry = component.find("InputAccountIndustry");

var base = selectedIndustry.get("v.value");

console.log(base);

if(base === "--- None ---"){

alert("Please select valid option");

}else{

helper.getResponse(component, base);

}

});

HelperJs :

({

getResponse: function(component, base) {

var action = component.get("c.getCalloutResponseContents");

action.setParams({

"url": 'http://api.fixer.io/latest?base=' + base

});

action.setCallback(this, function(response) {

var state = response.getState();

console.log(state);

console.log(response.getReturnValue());

if (component.isValid() && state === "SUCCESS") {

component.set("v.response", response.getReturnValue());

var getAllRates = component.get("v.response")['rates'];

var CurrencyList = [];

for (var key in getAllRates) {

CurrencyList.push(key + ' = ' + getAllRates[key]);

}

component.set("v.ListOfCurrency", CurrencyList);

}

});

$A.enqueueAction(action);

},

})

Output :

Salesforce Live

jQuery with callouts and Lightning Process

Integration between Spark to salesforce using Gupshup platform salesforce

Parent field update with all related childs in salesforce

Standard Report charts in Lightning component Salesforce

Salesforce Lightning Events with example

Salesforce Database.saveResult and Database.Error example

Callouts from lightining components salesforce

Featured

What is Cryptography in salesforce and what are all the algorithms provided by them ?

Popular

Translate