-
ChatterFeed
-
0Best Answers
-
0Likes Received
-
0Likes Given
-
5Questions
-
3Replies
Can any one help me accessing more than 1000 records from my LWC ?
here is an apex code, i have provided limit as 1000 because if i give more than 1000 my LWC not fetching any records, Any help will be appreciated . Thank you
==================
public with sharing class ND_SupportDirectMailingHCPController {
@readOnly
@RemoteAction
@AuraEnabled(Cacheable=true)
public static String findRecords(
String lastName,
String firstName,
String institution,
String professionaltitle,
String address,
String city,
String oneKeyID,
String country,
String territory,
String specialty,
String individualType,
String brickDescription,
String workPlaceType,
String building,
Boolean isHCP
) {
Map<String,String> DKSpecialityMap = new Map<String,String>();
Map<String,String> FISpecialityMap = new Map<String,String>();
Map<String,String> NOSpecialityMap = new Map<String,String>();
Map<String,String> SESpecialityMap = new Map<String,String>();
Map<String,String> DKProfessionalTitleMap = new Map<String,String>();
Map<String,String> FIProfessionalTitleMap = new Map<String,String>();
Map<String,String> NOProfessionalTitleMap = new Map<String,String>();
Map<String,String> SEProfessionalTitleMap = new Map<String,String>();
Map<String,String> DKIndividualTypeMap = new Map<String,String>();
Map<String,String> FIIndividualTypeMap = new Map<String,String>();
Map<String,String> NOIndividualTypeMap = new Map<String,String>();
Map<String,String> SEIndividualTypeMap = new Map<String,String>();
Map<String,String> DKWorkplaceTypeMap = new Map<String,String>();
Map<String,String> FIWorkplaceTypeMap = new Map<String,String>();
Map<String,String> NOWorkplaceTypeMap = new Map<String,String>();
Map<String,String> SEWorkplaceTypeMap = new Map<String,String>();
List<QIDC__OK_Codes_Translation_ims__c> translationsCodes = new List<QIDC__OK_Codes_Translation_ims__c>();
translationsCodes=[select id,QIDC__OK_Code_ims__r.name,
QIDC__OK_Code_ims__r.QIDC__Label_ims__c,
QIDC__Label_ims__c,
QIDC__OK_Code_ims__r.QIDC__Country_ims__c,
QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c
from QIDC__OK_Codes_Translation_ims__c
where
QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c in ('TIT','TYP','SP','LEX')
and QIDC__OK_Code_ims__r.QIDC__Country_ims__c in ('DK','FI','NO','SE')
and QIDC__OK_Code_ims__r.QIDC__Is_Active_ims__c =true limit 3000];
for(QIDC__OK_Codes_Translation_ims__c eachTransCountry :translationsCodes )
{
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
DKSpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
FISpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
NOSpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
SESpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
DKProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
FIProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
NOProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
SEProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
DKIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
FIIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
NOIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
SEIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
DKWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
FIWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
NOWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
SEWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
}
List<AccountWrapper> accountWrapperResult = new List<AccountWrapper>();
Boolean addressUsed = false;
String query = 'SELECT OCE__ExtendedCategory__c,OKOCE_Country__c,OCE__Specialty__c,OCE__IndividualTypes__c,OCE__UniqueIntegrationID__c,ND_Parent_Account__c,ND_Parent_ID_Name__c, OCE__AccountFullName__c,CHS_Building_Label__c,OCE__ProfessionalTitle__c,ND_Primary_Brick__c,ND_Primary_City__c,ND_Primary_Zip__c, ' +
' OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.Name,' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__Territories__c, ' +
' (' +
' SELECT Id, OCE__Country__c, OCE__FormattedAddress__c,OCE__Address__r.CHS_Brick_Description__c,OCE__Address__r.OCE__Building__c ' +
' FROM OCE__AccountAddresses__r ' +
' WHERE OCE__IsPrimary__c = true ';
if (String.isNotBlank(address)) {
query += ' AND OCE__FormattedAddress__c LIKE \'%' + String.escapeSingleQuotes(address) + '%\' ';
addressUsed = true;
}
if (String.isNotBlank(country)) {
query += ' AND OCE__Country__c LIKE \'%' + String.escapeSingleQuotes(country) + '%\' ';
addressUsed = true;
}
if(!isHCP)
{
query += ' And OCE__AddressType__c in (\'M\',\'P\') ';
}
if (String.isNotBlank(brickDescription)) {
query += ' AND OCE__Address__r.CHS_Brick_Description__c LIKE \'%' + String.escapeSingleQuotes(brickDescription) + '%\' ';
}
if (String.isNotBlank(building)) {
query += ' AND OCE__Address__r.OCE__Building__c LIKE \'%' + String.escapeSingleQuotes(building) + '%\' ';
}
query += ') ' +
' FROM Account ' +
' WHERE OCE__IsActive__c = true ' +
' AND IsPersonAccount = :isHCP ';
if (String.isNotBlank(lastName)) {
if (isHCP) {
query += ' AND LastName LIKE \'%' + String.escapeSingleQuotes(lastName) + '%\' ';
} else {
query += ' AND OCE__AccountFullName__c LIKE \'%' + String.escapeSingleQuotes(lastName) + '%\' ';
}
}
if (String.isNotBlank(firstName)) {
query += ' AND FirstName LIKE \'%' + String.escapeSingleQuotes(firstName) + '%\' ';
}
if (String.isNotBlank(institution)) {
query += ' AND ND_Parent_ID_Name__c LIKE \'%' + String.escapeSingleQuotes(institution) + '%\' ';
}
if (String.isNotBlank(individualType)) {
query += ' AND toLabel(OCE__IndividualTypes__c) LIKE \'%' + String.escapeSingleQuotes(individualType) + '%\' ';
}
if (String.isNotBlank(professionaltitle)) {
query += ' AND toLabel(OCE__ProfessionalTitle__c) LIKE \'%' + String.escapeSingleQuotes(professionaltitle) + '%\' ';
}
if (String.isNotBlank(city)) {
query += ' AND ND_Primary_City__c LIKE \'%' + String.escapeSingleQuotes(city) + '%\' ';
}
if (String.isNotBlank(oneKeyID)) {
query += ' AND OCE__UniqueIntegrationID__c LIKE \'%' + String.escapeSingleQuotes(oneKeyID) + '%\' ';
}
if (String.isNotBlank(workPlaceType)) {
query += ' AND toLabel(OCE__ExtendedCategory__c) LIKE \'%' + String.escapeSingleQuotes(workPlaceType) + '%\' ';
}
if (String.isNotBlank(territory)) {
query += ' AND OCE__Territories__c LIKE \'%' + String.escapeSingleQuotes(territory) + '%\' ';
}
if (String.isNotBlank(specialty))
{
query += ' AND (toLabel(OCE__Specialty__c) = :specialty OR toLabel(OCE__Specialty2__c) = :specialty OR toLabel(OCE__Specialty3__c) = :specialty)';
}
query += 'and OCE__IsPrivacyLaw__c =false and OCE__DoNotMail__c =false and OKOCE_Country__c in (\'DK\',\'FI\',\'NO\',\'SE\') LIMIT 1000 ';
List<Account> accounts = Database.query(query);
if (accounts == null) {
return null;
}
System.debug(accounts);
Set<id> acctIds = new Set<id>();
List<Account> acctsListToDisplay = new List<Account>();
if(isHCP)
{
for (Account acc : accounts)
{
acctIds.add(acc.id);
}
List<OCE__Affiliation__c> affLists = new List<OCE__Affiliation__c>();
affLists=[Select id,OCE__From__c from OCE__Affiliation__c where OCE__IsPrivacyLaw__c =false and OCE__DoNotMail__c =false and OCE__From__c in :acctIds and OCE__IsPrivacyLaw__c=false and OCE__DoNotMail__c=false and CHS_Preferred_Mailing_Flag__c=false limit 10000];
List<id> affFromIds= new List<id>();
for(OCE__Affiliation__c thisAff : affLists)
{
affFromIds.add(thisAff.OCE__From__c);
}
for(Account acc : accounts)
{
if(affFromIds.Contains(acc.id))
{
acctsListToDisplay.add(acc);
}
}
}
else{
acctsListToDisplay=accounts;
}
for (Account acc : acctsListToDisplay)
{
String specTranslated;
String professionaltitleTranslated;
String individualTypeTranslated;
String workPlaceTypeTranslated;
if(acc.OKOCE_Country__c=='DK')
{
specTranslated=DKSpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=DKProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=DKIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=DKWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='FI')
{
specTranslated=FISpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=FIProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=FIIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=FIWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='NO')
{
specTranslated=NOSpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=NOProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=NOIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=NOWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='SE')
{
specTranslated=SESpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=SEProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=SEIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=SEWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
if (addressUsed && acc.OCE__AccountAddresses__r.isEmpty()) {
continue;
} else {
String parentName;
if (String.isNotBlank(acc.OCE__ParentAccount__r.Name)) {
parentName = acc.OCE__ParentAccount__r.Name;
if (String.isNotBlank(acc.OCE__ParentAccount__r.OCE__ParentAccount__r.Name)) {
parentName += ';' + acc.OCE__ParentAccount__r.OCE__ParentAccount__r.Name;
if (String.isNotBlank(acc.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name)) {
parentName += ';' + acc.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name;
}
}
}
AccountWrapper aw = new AccountWrapper
(
acc.OCE__AccountFullName__c,
acc.OCE__UniqueIntegrationID__c,
acc.ND_Parent_ID_Name__c,
parentName,
acc.OCE__AccountAddresses__r[0].OCE__FormattedAddress__c,
acc.OCE__AccountAddresses__r[0].OCE__Address__r.CHS_Brick_Description__c,
acc.ND_Primary_Zip__c,
acc.ND_Primary_City__c,
professionaltitleTranslated,
individualTypeTranslated,
specTranslated,
workPlaceTypeTranslated,
acc.OCE__AccountAddresses__r[0].OCE__Address__r.OCE__Building__c
);
accountWrapperResult.add(aw);
}
}
return JSON.serialize(accountWrapperResult);
}
public class AccountWrapper {
@AuraEnabled
public String name {get; set;}
@AuraEnabled
public String oneKeyID {get; set;}
@AuraEnabled
public String institution {get; set;}
@AuraEnabled
public String parenNames {get; set;}
@AuraEnabled
public String workplaceAddress {get; set;}
@AuraEnabled
public String brickDescription {get; set;}
@AuraEnabled
public String postalCode {get; set;}
@AuraEnabled
public String city {get; set;}
@AuraEnabled
public String professionaltitle {get; set;}
@AuraEnabled
public String individualType {get; set;}
@AuraEnabled
public String specialty {get; set;}
@AuraEnabled
public String workPlaceType {get; set;}
@AuraEnabled
public String building {get; set;}
public AccountWrapper() {}
public AccountWrapper(
String name,
String oneKeyID,
String institution,
String parenNames,
String workplaceAddress,
String brickDescription,
String postalCode,
String city,
String professionaltitle,
String individualType,
String specialty,
String workPlaceType,
String building
) {
this.name = name;
this.oneKeyID = oneKeyID;
this.institution = institution;
this.parenNames = parenNames;
this.workplaceAddress = workplaceAddress;
this.brickDescription = brickDescription;
this.postalCode = postalCode;
this.city = city;
this.professionaltitle=professionaltitle;
this.individualType=individualType;
this.specialty=specialty;
this.workPlaceType=workPlaceType;
this.building=building;
}
}
}
==================
public with sharing class ND_SupportDirectMailingHCPController {
@readOnly
@RemoteAction
@AuraEnabled(Cacheable=true)
public static String findRecords(
String lastName,
String firstName,
String institution,
String professionaltitle,
String address,
String city,
String oneKeyID,
String country,
String territory,
String specialty,
String individualType,
String brickDescription,
String workPlaceType,
String building,
Boolean isHCP
) {
Map<String,String> DKSpecialityMap = new Map<String,String>();
Map<String,String> FISpecialityMap = new Map<String,String>();
Map<String,String> NOSpecialityMap = new Map<String,String>();
Map<String,String> SESpecialityMap = new Map<String,String>();
Map<String,String> DKProfessionalTitleMap = new Map<String,String>();
Map<String,String> FIProfessionalTitleMap = new Map<String,String>();
Map<String,String> NOProfessionalTitleMap = new Map<String,String>();
Map<String,String> SEProfessionalTitleMap = new Map<String,String>();
Map<String,String> DKIndividualTypeMap = new Map<String,String>();
Map<String,String> FIIndividualTypeMap = new Map<String,String>();
Map<String,String> NOIndividualTypeMap = new Map<String,String>();
Map<String,String> SEIndividualTypeMap = new Map<String,String>();
Map<String,String> DKWorkplaceTypeMap = new Map<String,String>();
Map<String,String> FIWorkplaceTypeMap = new Map<String,String>();
Map<String,String> NOWorkplaceTypeMap = new Map<String,String>();
Map<String,String> SEWorkplaceTypeMap = new Map<String,String>();
List<QIDC__OK_Codes_Translation_ims__c> translationsCodes = new List<QIDC__OK_Codes_Translation_ims__c>();
translationsCodes=[select id,QIDC__OK_Code_ims__r.name,
QIDC__OK_Code_ims__r.QIDC__Label_ims__c,
QIDC__Label_ims__c,
QIDC__OK_Code_ims__r.QIDC__Country_ims__c,
QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c
from QIDC__OK_Codes_Translation_ims__c
where
QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c in ('TIT','TYP','SP','LEX')
and QIDC__OK_Code_ims__r.QIDC__Country_ims__c in ('DK','FI','NO','SE')
and QIDC__OK_Code_ims__r.QIDC__Is_Active_ims__c =true limit 3000];
for(QIDC__OK_Codes_Translation_ims__c eachTransCountry :translationsCodes )
{
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
DKSpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
FISpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
NOSpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
SESpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
DKProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
FIProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
NOProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
SEProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
DKIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
FIIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
NOIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
SEIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
DKWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
FIWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
NOWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
SEWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
}
List<AccountWrapper> accountWrapperResult = new List<AccountWrapper>();
Boolean addressUsed = false;
String query = 'SELECT OCE__ExtendedCategory__c,OKOCE_Country__c,OCE__Specialty__c,OCE__IndividualTypes__c,OCE__UniqueIntegrationID__c,ND_Parent_Account__c,ND_Parent_ID_Name__c, OCE__AccountFullName__c,CHS_Building_Label__c,OCE__ProfessionalTitle__c,ND_Primary_Brick__c,ND_Primary_City__c,ND_Primary_Zip__c, ' +
' OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.Name,' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__Territories__c, ' +
' (' +
' SELECT Id, OCE__Country__c, OCE__FormattedAddress__c,OCE__Address__r.CHS_Brick_Description__c,OCE__Address__r.OCE__Building__c ' +
' FROM OCE__AccountAddresses__r ' +
' WHERE OCE__IsPrimary__c = true ';
if (String.isNotBlank(address)) {
query += ' AND OCE__FormattedAddress__c LIKE \'%' + String.escapeSingleQuotes(address) + '%\' ';
addressUsed = true;
}
if (String.isNotBlank(country)) {
query += ' AND OCE__Country__c LIKE \'%' + String.escapeSingleQuotes(country) + '%\' ';
addressUsed = true;
}
if(!isHCP)
{
query += ' And OCE__AddressType__c in (\'M\',\'P\') ';
}
if (String.isNotBlank(brickDescription)) {
query += ' AND OCE__Address__r.CHS_Brick_Description__c LIKE \'%' + String.escapeSingleQuotes(brickDescription) + '%\' ';
}
if (String.isNotBlank(building)) {
query += ' AND OCE__Address__r.OCE__Building__c LIKE \'%' + String.escapeSingleQuotes(building) + '%\' ';
}
query += ') ' +
' FROM Account ' +
' WHERE OCE__IsActive__c = true ' +
' AND IsPersonAccount = :isHCP ';
if (String.isNotBlank(lastName)) {
if (isHCP) {
query += ' AND LastName LIKE \'%' + String.escapeSingleQuotes(lastName) + '%\' ';
} else {
query += ' AND OCE__AccountFullName__c LIKE \'%' + String.escapeSingleQuotes(lastName) + '%\' ';
}
}
if (String.isNotBlank(firstName)) {
query += ' AND FirstName LIKE \'%' + String.escapeSingleQuotes(firstName) + '%\' ';
}
if (String.isNotBlank(institution)) {
query += ' AND ND_Parent_ID_Name__c LIKE \'%' + String.escapeSingleQuotes(institution) + '%\' ';
}
if (String.isNotBlank(individualType)) {
query += ' AND toLabel(OCE__IndividualTypes__c) LIKE \'%' + String.escapeSingleQuotes(individualType) + '%\' ';
}
if (String.isNotBlank(professionaltitle)) {
query += ' AND toLabel(OCE__ProfessionalTitle__c) LIKE \'%' + String.escapeSingleQuotes(professionaltitle) + '%\' ';
}
if (String.isNotBlank(city)) {
query += ' AND ND_Primary_City__c LIKE \'%' + String.escapeSingleQuotes(city) + '%\' ';
}
if (String.isNotBlank(oneKeyID)) {
query += ' AND OCE__UniqueIntegrationID__c LIKE \'%' + String.escapeSingleQuotes(oneKeyID) + '%\' ';
}
if (String.isNotBlank(workPlaceType)) {
query += ' AND toLabel(OCE__ExtendedCategory__c) LIKE \'%' + String.escapeSingleQuotes(workPlaceType) + '%\' ';
}
if (String.isNotBlank(territory)) {
query += ' AND OCE__Territories__c LIKE \'%' + String.escapeSingleQuotes(territory) + '%\' ';
}
if (String.isNotBlank(specialty))
{
query += ' AND (toLabel(OCE__Specialty__c) = :specialty OR toLabel(OCE__Specialty2__c) = :specialty OR toLabel(OCE__Specialty3__c) = :specialty)';
}
query += 'and OCE__IsPrivacyLaw__c =false and OCE__DoNotMail__c =false and OKOCE_Country__c in (\'DK\',\'FI\',\'NO\',\'SE\') LIMIT 1000 ';
List<Account> accounts = Database.query(query);
if (accounts == null) {
return null;
}
System.debug(accounts);
Set<id> acctIds = new Set<id>();
List<Account> acctsListToDisplay = new List<Account>();
if(isHCP)
{
for (Account acc : accounts)
{
acctIds.add(acc.id);
}
List<OCE__Affiliation__c> affLists = new List<OCE__Affiliation__c>();
affLists=[Select id,OCE__From__c from OCE__Affiliation__c where OCE__IsPrivacyLaw__c =false and OCE__DoNotMail__c =false and OCE__From__c in :acctIds and OCE__IsPrivacyLaw__c=false and OCE__DoNotMail__c=false and CHS_Preferred_Mailing_Flag__c=false limit 10000];
List<id> affFromIds= new List<id>();
for(OCE__Affiliation__c thisAff : affLists)
{
affFromIds.add(thisAff.OCE__From__c);
}
for(Account acc : accounts)
{
if(affFromIds.Contains(acc.id))
{
acctsListToDisplay.add(acc);
}
}
}
else{
acctsListToDisplay=accounts;
}
for (Account acc : acctsListToDisplay)
{
String specTranslated;
String professionaltitleTranslated;
String individualTypeTranslated;
String workPlaceTypeTranslated;
if(acc.OKOCE_Country__c=='DK')
{
specTranslated=DKSpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=DKProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=DKIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=DKWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='FI')
{
specTranslated=FISpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=FIProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=FIIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=FIWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='NO')
{
specTranslated=NOSpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=NOProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=NOIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=NOWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='SE')
{
specTranslated=SESpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=SEProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=SEIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=SEWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
if (addressUsed && acc.OCE__AccountAddresses__r.isEmpty()) {
continue;
} else {
String parentName;
if (String.isNotBlank(acc.OCE__ParentAccount__r.Name)) {
parentName = acc.OCE__ParentAccount__r.Name;
if (String.isNotBlank(acc.OCE__ParentAccount__r.OCE__ParentAccount__r.Name)) {
parentName += ';' + acc.OCE__ParentAccount__r.OCE__ParentAccount__r.Name;
if (String.isNotBlank(acc.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name)) {
parentName += ';' + acc.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name;
}
}
}
AccountWrapper aw = new AccountWrapper
(
acc.OCE__AccountFullName__c,
acc.OCE__UniqueIntegrationID__c,
acc.ND_Parent_ID_Name__c,
parentName,
acc.OCE__AccountAddresses__r[0].OCE__FormattedAddress__c,
acc.OCE__AccountAddresses__r[0].OCE__Address__r.CHS_Brick_Description__c,
acc.ND_Primary_Zip__c,
acc.ND_Primary_City__c,
professionaltitleTranslated,
individualTypeTranslated,
specTranslated,
workPlaceTypeTranslated,
acc.OCE__AccountAddresses__r[0].OCE__Address__r.OCE__Building__c
);
accountWrapperResult.add(aw);
}
}
return JSON.serialize(accountWrapperResult);
}
public class AccountWrapper {
@AuraEnabled
public String name {get; set;}
@AuraEnabled
public String oneKeyID {get; set;}
@AuraEnabled
public String institution {get; set;}
@AuraEnabled
public String parenNames {get; set;}
@AuraEnabled
public String workplaceAddress {get; set;}
@AuraEnabled
public String brickDescription {get; set;}
@AuraEnabled
public String postalCode {get; set;}
@AuraEnabled
public String city {get; set;}
@AuraEnabled
public String professionaltitle {get; set;}
@AuraEnabled
public String individualType {get; set;}
@AuraEnabled
public String specialty {get; set;}
@AuraEnabled
public String workPlaceType {get; set;}
@AuraEnabled
public String building {get; set;}
public AccountWrapper() {}
public AccountWrapper(
String name,
String oneKeyID,
String institution,
String parenNames,
String workplaceAddress,
String brickDescription,
String postalCode,
String city,
String professionaltitle,
String individualType,
String specialty,
String workPlaceType,
String building
) {
this.name = name;
this.oneKeyID = oneKeyID;
this.institution = institution;
this.parenNames = parenNames;
this.workplaceAddress = workplaceAddress;
this.brickDescription = brickDescription;
this.postalCode = postalCode;
this.city = city;
this.professionaltitle=professionaltitle;
this.individualType=individualType;
this.specialty=specialty;
this.workPlaceType=workPlaceType;
this.building=building;
}
}
}
- Wajeed Khan
- February 09, 2022
- Like
- 0
Change the Time value of DateTime field to exact time
Hi Guys,
I need to change the Time value of the DateTime field to the exact time based on the another filed call time having a picklist AM and PM, if it is AM the time value of DateTime is 10:00:00 else 15:00:00 .Any help will be appreciated.
Thanks
I need to change the Time value of the DateTime field to the exact time based on the another filed call time having a picklist AM and PM, if it is AM the time value of DateTime is 10:00:00 else 15:00:00 .Any help will be appreciated.
Thanks
- Wajeed Khan
- November 07, 2019
- Like
- 0
Can any body help me to write the test class for this
public class optSigntureCopyController {
public id AccountID{
get;
set;
}
public list<OCE__Opt__c> Opts{get;set;}
public list<OCE__OptDetail__c> Optdetails{get;set;}
public set<string> Optids;
public WrapperClass InnerClass {get;set;}
Public Account AccountRec {get;set;}
public list<OCE__AccountAddress__c> Accountaddress{get;set;}
public list<OCE__Affiliation__c> affs {get;set;}
Public WrapperClass getactualDetails(){
system.debug('AccountID in controller '+AccountID);
AccountRec = new Account();
InnerClass = new WrapperClass();
Opts = new list<OCE__Opt__c>();
Optdetails = new list<OCE__OptDetail__c>();
Optids = new set<string>();
Accountaddress = new list<OCE__AccountAddress__c>();
set<id> OptSig = new set<id>();
if(AccountID!=null){
AccountRec = [select id,lastname,firstname,PersonBirthdate,GI_Phone_Number__c,GI_Fiscal_Code__c,OCE__ProfessionalTitle__c,toLabel(OCE__Specialty__c) from account where id =: AccountID];
Accountaddress = [select OCE__Account__c, OCE__AddressLine1__c, OCE__City__c, GI_State__c, OCE__ZipCode__c from OCE__AccountAddress__c where OCE__IsPrimary__c = true and OCE__Account__c =:AccountID];
if(Accountaddress.size()==0){
Accountaddress = [select OCE__Account__c, OCE__AddressLine1__c, OCE__City__c, GI_State__c, OCE__ZipCode__c from OCE__AccountAddress__c where OCE__Account__c =:AccountID];
}
affs = [SELECT Id, OCE__To__c, OCE__From__r.Phone FROM OCE__Affiliation__c WHERE OCE__IsPrimary__c = true AND OCE__To__c = : AccountID];
InnerClass.Accountlastname = AccountRec.lastname;
InnerClass.AccountFirstName = AccountRec.firstname;
InnerClass.AccountBirthdate = AccountRec.PersonBirthdate;
InnerClass.Addressline1 = Accountaddress[0].OCE__AddressLine1__c;
InnerClass.ficalcode = AccountRec.GI_Fiscal_Code__c;
InnerClass.city = Accountaddress[0].OCE__City__c;
InnerClass.state = Accountaddress[0].GI_State__c;
InnerClass.Zip = Accountaddress[0].OCE__ZipCode__c;
//InnerClass.PhoneNo = affs[0].OCE__From__r.Phone;
InnerClass.PhoneNo = AccountRec.GI_Phone_Number__c;
InnerClass.professiontitle = AccountRec.OCE__ProfessionalTitle__c;
InnerClass.speciality = AccountRec.OCE__Specialty__c;
Opts = [select id,oce__account__c,OCE__Signature__c from OCE__Opt__c where oce__account__c =: AccountID and OCE__Active__c = true];
system.debug('Opts innn'+Opts);
if(Opts.size()>0){
for(OCE__Opt__c Opt : Opts){
Optids.add(Opt.id);
if(Opt.OCE__Signature__c!=null){
OptSig.add(Opt.id);
}
}
list<Attachment> sigAttachmentList = [SELECT Id FROM Attachment WHERE parentid IN : OptSig];
if(sigAttachmentList.size()>0){
InnerClass.signatureid = sigAttachmentList[0].id;
}
Optdetails = [SELECT Id, OCE__Topic__c, GI_Opt_Flag__c, OCE__Subscription__c, OCE__Channel__c, OCE__ChannelValue__c, OCE__OfflineCreatedDate__c, OCE__Opt__c,createdby.name,OCE__Topic__r.name FROM OCE__OptDetail__c WHERE OCE__Opt__c In : Optids];
InnerClass.Optdate = Optdetails[0].OCE__OfflineCreatedDate__c.date();
InnerClass.userName = Optdetails[0].createdby.name;
if(Optdetails[0].OCE__ChannelValue__c!=''){
InnerClass.emailvalue = Optdetails[0].OCE__ChannelValue__c;
}
if(Optdetails.size()>0){
for(OCE__OptDetail__c OptDetail : Optdetails){
if(OptDetail.OCE__Topic__r.name == Label.Opt_Topic_1 ){
InnerClass.topic1 = topicOpted(OptDetail);
}
if(OptDetail.OCE__Topic__r.name == Label.Opt_Topic_2){
InnerClass.topic2 = topicOpted(OptDetail);
}
if(OptDetail.OCE__Topic__r.name ==Label.Opt_Topic_3){
InnerClass.topic3 = topicOpted(OptDetail);
}
}
}
}
system.debug('Wrapper values final '+InnerClass);
}
return InnerClass;
}
public string topicOpted(OCE__OptDetail__c optDetail){
string istopicOpted;
if(optDetail.OCE__Subscription__c == 'Opt In')
istopicOpted = 'SI';
else if(optDetail.OCE__Subscription__c == 'Opt Out')
istopicOpted = 'NO';
else if(optDetail.OCE__Subscription__c == 'Not Asked')
istopicOpted = 'NO';
return istopicOpted;
}
Public class WrapperClass{
public date Optdate{get;set;}
public string userName {get;set;}
Public string Accountlastname {get;set;}
Public string AccountFirstName {get;set;}
public date AccountBirthdate {get;set;}
public string Addressline1 {get;set;}
public string ficalcode {get;set;}
public string city {get;set;}
public string state {get;set;}
public string Zip {get;set;}
public string PhoneNo{get;set;}
public string emailvalue{get;set;}
public string professiontitle {get;set;}
public string speciality {get;set;}
public id signatureid {get;set;}
public string topic1 {get;set;}
public string topic2 {get;set;}
public string topic3 {get;set;}
}
}
public id AccountID{
get;
set;
}
public list<OCE__Opt__c> Opts{get;set;}
public list<OCE__OptDetail__c> Optdetails{get;set;}
public set<string> Optids;
public WrapperClass InnerClass {get;set;}
Public Account AccountRec {get;set;}
public list<OCE__AccountAddress__c> Accountaddress{get;set;}
public list<OCE__Affiliation__c> affs {get;set;}
Public WrapperClass getactualDetails(){
system.debug('AccountID in controller '+AccountID);
AccountRec = new Account();
InnerClass = new WrapperClass();
Opts = new list<OCE__Opt__c>();
Optdetails = new list<OCE__OptDetail__c>();
Optids = new set<string>();
Accountaddress = new list<OCE__AccountAddress__c>();
set<id> OptSig = new set<id>();
if(AccountID!=null){
AccountRec = [select id,lastname,firstname,PersonBirthdate,GI_Phone_Number__c,GI_Fiscal_Code__c,OCE__ProfessionalTitle__c,toLabel(OCE__Specialty__c) from account where id =: AccountID];
Accountaddress = [select OCE__Account__c, OCE__AddressLine1__c, OCE__City__c, GI_State__c, OCE__ZipCode__c from OCE__AccountAddress__c where OCE__IsPrimary__c = true and OCE__Account__c =:AccountID];
if(Accountaddress.size()==0){
Accountaddress = [select OCE__Account__c, OCE__AddressLine1__c, OCE__City__c, GI_State__c, OCE__ZipCode__c from OCE__AccountAddress__c where OCE__Account__c =:AccountID];
}
affs = [SELECT Id, OCE__To__c, OCE__From__r.Phone FROM OCE__Affiliation__c WHERE OCE__IsPrimary__c = true AND OCE__To__c = : AccountID];
InnerClass.Accountlastname = AccountRec.lastname;
InnerClass.AccountFirstName = AccountRec.firstname;
InnerClass.AccountBirthdate = AccountRec.PersonBirthdate;
InnerClass.Addressline1 = Accountaddress[0].OCE__AddressLine1__c;
InnerClass.ficalcode = AccountRec.GI_Fiscal_Code__c;
InnerClass.city = Accountaddress[0].OCE__City__c;
InnerClass.state = Accountaddress[0].GI_State__c;
InnerClass.Zip = Accountaddress[0].OCE__ZipCode__c;
//InnerClass.PhoneNo = affs[0].OCE__From__r.Phone;
InnerClass.PhoneNo = AccountRec.GI_Phone_Number__c;
InnerClass.professiontitle = AccountRec.OCE__ProfessionalTitle__c;
InnerClass.speciality = AccountRec.OCE__Specialty__c;
Opts = [select id,oce__account__c,OCE__Signature__c from OCE__Opt__c where oce__account__c =: AccountID and OCE__Active__c = true];
system.debug('Opts innn'+Opts);
if(Opts.size()>0){
for(OCE__Opt__c Opt : Opts){
Optids.add(Opt.id);
if(Opt.OCE__Signature__c!=null){
OptSig.add(Opt.id);
}
}
list<Attachment> sigAttachmentList = [SELECT Id FROM Attachment WHERE parentid IN : OptSig];
if(sigAttachmentList.size()>0){
InnerClass.signatureid = sigAttachmentList[0].id;
}
Optdetails = [SELECT Id, OCE__Topic__c, GI_Opt_Flag__c, OCE__Subscription__c, OCE__Channel__c, OCE__ChannelValue__c, OCE__OfflineCreatedDate__c, OCE__Opt__c,createdby.name,OCE__Topic__r.name FROM OCE__OptDetail__c WHERE OCE__Opt__c In : Optids];
InnerClass.Optdate = Optdetails[0].OCE__OfflineCreatedDate__c.date();
InnerClass.userName = Optdetails[0].createdby.name;
if(Optdetails[0].OCE__ChannelValue__c!=''){
InnerClass.emailvalue = Optdetails[0].OCE__ChannelValue__c;
}
if(Optdetails.size()>0){
for(OCE__OptDetail__c OptDetail : Optdetails){
if(OptDetail.OCE__Topic__r.name == Label.Opt_Topic_1 ){
InnerClass.topic1 = topicOpted(OptDetail);
}
if(OptDetail.OCE__Topic__r.name == Label.Opt_Topic_2){
InnerClass.topic2 = topicOpted(OptDetail);
}
if(OptDetail.OCE__Topic__r.name ==Label.Opt_Topic_3){
InnerClass.topic3 = topicOpted(OptDetail);
}
}
}
}
system.debug('Wrapper values final '+InnerClass);
}
return InnerClass;
}
public string topicOpted(OCE__OptDetail__c optDetail){
string istopicOpted;
if(optDetail.OCE__Subscription__c == 'Opt In')
istopicOpted = 'SI';
else if(optDetail.OCE__Subscription__c == 'Opt Out')
istopicOpted = 'NO';
else if(optDetail.OCE__Subscription__c == 'Not Asked')
istopicOpted = 'NO';
return istopicOpted;
}
Public class WrapperClass{
public date Optdate{get;set;}
public string userName {get;set;}
Public string Accountlastname {get;set;}
Public string AccountFirstName {get;set;}
public date AccountBirthdate {get;set;}
public string Addressline1 {get;set;}
public string ficalcode {get;set;}
public string city {get;set;}
public string state {get;set;}
public string Zip {get;set;}
public string PhoneNo{get;set;}
public string emailvalue{get;set;}
public string professiontitle {get;set;}
public string speciality {get;set;}
public id signatureid {get;set;}
public string topic1 {get;set;}
public string topic2 {get;set;}
public string topic3 {get;set;}
}
}
- Wajeed Khan
- October 17, 2019
- Like
- 0
Can anyone give test code coverage for below code please ,thanks in advance
public with sharing class Call_Controller { public Call__c call{get;set;} public Id accountId {get;set;} public List<Account_Affiliation__c> accAf{get;Set;} public List<wrapperClass> wrapClassList{get;set;} public wrapperClass wc{get;set;} public Account acc{get;set;} Set<Id> ParentID = new Set<id>(); Set<id> CallId= new Set<Id>(); public Call_Controller(ApexPages.StandardController ctrl) { if(!test.isRunningTest()) ctrl.addFields(new List<String>{'Account__c'}); wrapClassList = new List<wrapperClass>(); accountId =ApexPages.currentPage().getParameters().get('accId'); accAf = new List<Account_Affiliation__c>(); call = (Call__c)ctrl.getRecord(); if(accountId==null) { accountId=call.Account__c; } else { call.Account__c = accountId; } acc=[select ID,Name from Account where id=:accountId]; accAf=[Select id,Status__c,To__r.name,From__c,To__c From Account_Affiliation__c where From__c=:accountId and Status__c=true]; Set<String> callName=new Set<String>(); if(ctrl.getId()!=null) { try{ List<Call__c> childCall = [select id,Account__r.Name,Call_Date__c,out_Of_Office__c,Comments__c,parent_call__c from call__c where Parent_call__c=:call.Id]; for(Call__c cc : childCall) { wc = new wrapperClass(cc.Account__r.Name,cc.Id); callName.add(cc.Account__r.Name); wc.flag=true; ParentID.add(cc.Account__c); callId.add(cc.Id); wrapClassList.add(wc); } } catch(Exception ex) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,ex.getMessage()+' at line number '+ex.getLineNumber())); } } for(Account_Affiliation__c af:accAf) { if(!callName.contains(af.To__r.Name)) { wc = new wrapperClass(af.To__r.Name,af.Id); wc.accWrap=af; wrapClassList.add(wc); } } } public class wrapperClass { public boolean flag{get;set;} public Account_Affiliation__c accWrap{get;set;} public String accName{get;set;} public Id Cid{get;set;} public wrapperClass(String Name,id Cid) { this.Cid=Cid; accName=Name; } } //Record Creation for Related Records on Save public void createRelRecordOnSave() { for(wrapperClass wc:wrapClassList) { if(wc.flag==true) { if(!callId.contains(wc.Cid)) { Call__c relCall= new Call__c(); relCall.Account__c=wc.accWrap.To__c; relCall.Out_of_office__c=call.Out_of_office__c; relcall.Parent_Call__c=call.id; relCall.Call_Date__c=call.Call_Date__c; relCall.Comments__c=call.Comments__c; relCall.Status__c='Draft'; insert relCall; } else { Call__c c1=[select id,Account__c,Out_of_office__c,Call_Date__c,Comments__c from Call__c where Account__c=:wc.accWrap.To__c]; c1.Call_Date__c=call.Call_Date__c; c1.Status__c='Draft'; c1.Comments__c=call.Comments__c; c1.Out_of_office__c=call.Out_of_office__c; update c1; } } } } public void clear() { call.Comments__c=null; } //Record Creation for Related Records on Submit public void createRelRecordOnSubmit() { for(wrapperClass wc:wrapClassList) { if(wc.flag==true ) { if(!callId.contains(wc.Cid)) { Call__c relCall= new Call__c(); relCall.Account__c=wc.accWrap.To__c; relCall.Out_of_office__c=call.Out_of_office__c; relcall.Parent_Call__c=call.id; relCall.Call_Date__c=call.Call_Date__c; relCall.Comments__c=call.Comments__c; relCall.Status__c='Submitted'; insert relCall; } else { Call__c c1=[select id,Account__c,Out_of_office__c,Call_Date__c,Comments__c from Call__c where Id = :wc.Cid]; c1.Call_Date__c=call.Call_Date__c; c1.Status__c='Submitted'; c1.Comments__c=call.Comments__c; c1.Out_of_office__c=call.Out_of_office__c; update c1; } } } } //Save Button public PageReference Save() { if(call.Call_Date__c>System.today()) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,'You Cannot Enter A future Date')); return null; } else { try{ call.Status__c='Draft'; upsert call; createRelRecordOnSave(); PageReference reRend = new PageReference('/'+AccountID); reRend.setRedirect(true); return reRend; } catch(Exception ex) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,ex.getMessage()+' at line number '+ex.getLineNumber())); } } return null; } public PageReference cancel() { PageReference reRend = new PageReference('/'+AccountID); reRend.setRedirect(true); return reRend; } //Submit Button public PageReference Submit() { if(call.Call_Date__c>system.today()) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,'You Cannot Enter A future Date')); } try{ call.Status__c='Submitted'; upsert call; createRelRecordOnSubmit(); PageReference reRend = new PageReference('/'+AccountID); reRend.setRedirect(true); return reRend; } catch(Exception ex) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,ex.getMessage()+' at line number '+ex.getLineNumber())); } return null; } }
- Wajeed Khan
- November 06, 2018
- Like
- 0
please can anyone give test code coverage for below code
public with sharing class Call_Controller { public apexpages.StandardController stdctrl{get;set;} public Call__c call{get;set;} public Id accountId {get;set;} public List<Account_Affiliation__c> accAf{get;Set;} public List<wrapperClass> wrapClassList{get;set;} public wrapperClass wc{get;set;} public List<Call__c> callList{get;set;} public Call_Controller(ApexPages.StandardController ctrl) { PageReference myVfPage = Page.Accounts; wrapClassList = new List<wrapperClass>(); accountId =ApexPages.currentPage().getParameters().get('accId'); accAf = new List<Account_Affiliation__c>(); callList=[Select Id,Status__c,Created__c,Account__c,Account__r.Name,Call_Date__c,Comments__c,Out_of_Office__c from Call__c where Account__c=:accountId]; if(callList.size()>0) { call=[Select Id,Status__c,Created__c,Account__c,Account__r.Name,Call_Date__c,Comments__c,Out_of_Office__c from Call__c where Account__c=:ApexPages.currentPage().getparameters().get('accId')][0]; } accAf=[Select Status__c,To__r.name,From__c,To__c From Account_Affiliation__c where From__c=:ApexPages.currentPage().getparameters().get('accId')]; for(Account_Affiliation__c af:accAf) { wc = new wrapperClass(af.To__r.Name); wc.flag=false; wc.accWrap=af; wrapClassList.add(wc); } // stdctrl=ctrl; } public class wrapperClass { public boolean flag{get;set;} public Account_Affiliation__c accWrap{get;set;} public String accName{get;set;} public wrapperClass(String Name) { accName=Name; flag=false; } } //Record Creation for Related Records on Save public void createRelRecordOnSave() { for(wrapperClass wc:wrapClassList) { if(wc.flag==true ) { Call__c Rcl =new Call__c(); Rcl.Account__c=wc.accWrap.To__c; Rcl.Call_Date__c=call.Call_Date__c; Rcl.Comments__c=call.Comments__c; Rcl.Out_of_office__c=call.Out_of_office__c; Rcl.Status__c='Draft'; upsert rcl; } } } //Record Creation for Related Records on Submit public void createRelRecordOnSubmit() { for(wrapperClass wc:wrapClassList) { if(wc.flag==true ) { Call__c Rcl =new Call__c(); Rcl.Account__c=wc.accWrap.To__c; Rcl.Call_Date__c=call.Call_Date__c; Rcl.Comments__c=call.Comments__c; Rcl.Out_of_office__c=call.Out_of_office__c; Rcl.Status__c='Submitted'; upsert rcl; } } } //Save Button public PageReference Save() { if(call.Call_Date__c>System.today() ) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,'You Cannot Enter A future Date')); return null; } else { try{ Call__c Call1=New Call__C(); call1.Account__c=call.Account__c; call1.Call_Date__c=call.Call_Date__c; call1.Comments__c=call.Comments__c; call1.Out_of_office__c=call.Out_of_office__c; call1.Status__c='Draft'; upsert call1; createRelRecordOnSave(); } catch(Exception ex) { ApexPages.addMessages(ex); } } PageReference reRend = new PageReference('/a0B?fcf'); reRend.setRedirect(true); return reRend; } //Submit Button public PageReference Submit() { if(call.Call_Date__c>system.today()) { call.Call_Date__c.addError('The Date Should not be Future Date'); } try{ Call__c Call1=New Call__C(); call1.Account__c=call.Account__c; call1.Call_Date__c=call.Call_Date__c; call1.Comments__c=call.Comments__c; call1.Out_of_office__c=call.Out_of_office__c; call1.Status__c='Submitted'; upsert call1; createRelRecordOnSubmit(); } catch(Exception ex) { ApexPages.addMessages(ex); } PageReference reRend = new PageReference('/a0B?fcf'); reRend.setRedirect(true); return reRend; } }
- Wajeed Khan
- October 31, 2018
- Like
- 0
Can any one help me accessing more than 1000 records from my LWC ?
here is an apex code, i have provided limit as 1000 because if i give more than 1000 my LWC not fetching any records, Any help will be appreciated . Thank you
==================
public with sharing class ND_SupportDirectMailingHCPController {
@readOnly
@RemoteAction
@AuraEnabled(Cacheable=true)
public static String findRecords(
String lastName,
String firstName,
String institution,
String professionaltitle,
String address,
String city,
String oneKeyID,
String country,
String territory,
String specialty,
String individualType,
String brickDescription,
String workPlaceType,
String building,
Boolean isHCP
) {
Map<String,String> DKSpecialityMap = new Map<String,String>();
Map<String,String> FISpecialityMap = new Map<String,String>();
Map<String,String> NOSpecialityMap = new Map<String,String>();
Map<String,String> SESpecialityMap = new Map<String,String>();
Map<String,String> DKProfessionalTitleMap = new Map<String,String>();
Map<String,String> FIProfessionalTitleMap = new Map<String,String>();
Map<String,String> NOProfessionalTitleMap = new Map<String,String>();
Map<String,String> SEProfessionalTitleMap = new Map<String,String>();
Map<String,String> DKIndividualTypeMap = new Map<String,String>();
Map<String,String> FIIndividualTypeMap = new Map<String,String>();
Map<String,String> NOIndividualTypeMap = new Map<String,String>();
Map<String,String> SEIndividualTypeMap = new Map<String,String>();
Map<String,String> DKWorkplaceTypeMap = new Map<String,String>();
Map<String,String> FIWorkplaceTypeMap = new Map<String,String>();
Map<String,String> NOWorkplaceTypeMap = new Map<String,String>();
Map<String,String> SEWorkplaceTypeMap = new Map<String,String>();
List<QIDC__OK_Codes_Translation_ims__c> translationsCodes = new List<QIDC__OK_Codes_Translation_ims__c>();
translationsCodes=[select id,QIDC__OK_Code_ims__r.name,
QIDC__OK_Code_ims__r.QIDC__Label_ims__c,
QIDC__Label_ims__c,
QIDC__OK_Code_ims__r.QIDC__Country_ims__c,
QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c
from QIDC__OK_Codes_Translation_ims__c
where
QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c in ('TIT','TYP','SP','LEX')
and QIDC__OK_Code_ims__r.QIDC__Country_ims__c in ('DK','FI','NO','SE')
and QIDC__OK_Code_ims__r.QIDC__Is_Active_ims__c =true limit 3000];
for(QIDC__OK_Codes_Translation_ims__c eachTransCountry :translationsCodes )
{
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
DKSpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
FISpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
NOSpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
SESpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
DKProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
FIProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
NOProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
SEProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
DKIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
FIIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
NOIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
SEIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
DKWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
FIWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
NOWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
SEWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
}
List<AccountWrapper> accountWrapperResult = new List<AccountWrapper>();
Boolean addressUsed = false;
String query = 'SELECT OCE__ExtendedCategory__c,OKOCE_Country__c,OCE__Specialty__c,OCE__IndividualTypes__c,OCE__UniqueIntegrationID__c,ND_Parent_Account__c,ND_Parent_ID_Name__c, OCE__AccountFullName__c,CHS_Building_Label__c,OCE__ProfessionalTitle__c,ND_Primary_Brick__c,ND_Primary_City__c,ND_Primary_Zip__c, ' +
' OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.Name,' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__Territories__c, ' +
' (' +
' SELECT Id, OCE__Country__c, OCE__FormattedAddress__c,OCE__Address__r.CHS_Brick_Description__c,OCE__Address__r.OCE__Building__c ' +
' FROM OCE__AccountAddresses__r ' +
' WHERE OCE__IsPrimary__c = true ';
if (String.isNotBlank(address)) {
query += ' AND OCE__FormattedAddress__c LIKE \'%' + String.escapeSingleQuotes(address) + '%\' ';
addressUsed = true;
}
if (String.isNotBlank(country)) {
query += ' AND OCE__Country__c LIKE \'%' + String.escapeSingleQuotes(country) + '%\' ';
addressUsed = true;
}
if(!isHCP)
{
query += ' And OCE__AddressType__c in (\'M\',\'P\') ';
}
if (String.isNotBlank(brickDescription)) {
query += ' AND OCE__Address__r.CHS_Brick_Description__c LIKE \'%' + String.escapeSingleQuotes(brickDescription) + '%\' ';
}
if (String.isNotBlank(building)) {
query += ' AND OCE__Address__r.OCE__Building__c LIKE \'%' + String.escapeSingleQuotes(building) + '%\' ';
}
query += ') ' +
' FROM Account ' +
' WHERE OCE__IsActive__c = true ' +
' AND IsPersonAccount = :isHCP ';
if (String.isNotBlank(lastName)) {
if (isHCP) {
query += ' AND LastName LIKE \'%' + String.escapeSingleQuotes(lastName) + '%\' ';
} else {
query += ' AND OCE__AccountFullName__c LIKE \'%' + String.escapeSingleQuotes(lastName) + '%\' ';
}
}
if (String.isNotBlank(firstName)) {
query += ' AND FirstName LIKE \'%' + String.escapeSingleQuotes(firstName) + '%\' ';
}
if (String.isNotBlank(institution)) {
query += ' AND ND_Parent_ID_Name__c LIKE \'%' + String.escapeSingleQuotes(institution) + '%\' ';
}
if (String.isNotBlank(individualType)) {
query += ' AND toLabel(OCE__IndividualTypes__c) LIKE \'%' + String.escapeSingleQuotes(individualType) + '%\' ';
}
if (String.isNotBlank(professionaltitle)) {
query += ' AND toLabel(OCE__ProfessionalTitle__c) LIKE \'%' + String.escapeSingleQuotes(professionaltitle) + '%\' ';
}
if (String.isNotBlank(city)) {
query += ' AND ND_Primary_City__c LIKE \'%' + String.escapeSingleQuotes(city) + '%\' ';
}
if (String.isNotBlank(oneKeyID)) {
query += ' AND OCE__UniqueIntegrationID__c LIKE \'%' + String.escapeSingleQuotes(oneKeyID) + '%\' ';
}
if (String.isNotBlank(workPlaceType)) {
query += ' AND toLabel(OCE__ExtendedCategory__c) LIKE \'%' + String.escapeSingleQuotes(workPlaceType) + '%\' ';
}
if (String.isNotBlank(territory)) {
query += ' AND OCE__Territories__c LIKE \'%' + String.escapeSingleQuotes(territory) + '%\' ';
}
if (String.isNotBlank(specialty))
{
query += ' AND (toLabel(OCE__Specialty__c) = :specialty OR toLabel(OCE__Specialty2__c) = :specialty OR toLabel(OCE__Specialty3__c) = :specialty)';
}
query += 'and OCE__IsPrivacyLaw__c =false and OCE__DoNotMail__c =false and OKOCE_Country__c in (\'DK\',\'FI\',\'NO\',\'SE\') LIMIT 1000 ';
List<Account> accounts = Database.query(query);
if (accounts == null) {
return null;
}
System.debug(accounts);
Set<id> acctIds = new Set<id>();
List<Account> acctsListToDisplay = new List<Account>();
if(isHCP)
{
for (Account acc : accounts)
{
acctIds.add(acc.id);
}
List<OCE__Affiliation__c> affLists = new List<OCE__Affiliation__c>();
affLists=[Select id,OCE__From__c from OCE__Affiliation__c where OCE__IsPrivacyLaw__c =false and OCE__DoNotMail__c =false and OCE__From__c in :acctIds and OCE__IsPrivacyLaw__c=false and OCE__DoNotMail__c=false and CHS_Preferred_Mailing_Flag__c=false limit 10000];
List<id> affFromIds= new List<id>();
for(OCE__Affiliation__c thisAff : affLists)
{
affFromIds.add(thisAff.OCE__From__c);
}
for(Account acc : accounts)
{
if(affFromIds.Contains(acc.id))
{
acctsListToDisplay.add(acc);
}
}
}
else{
acctsListToDisplay=accounts;
}
for (Account acc : acctsListToDisplay)
{
String specTranslated;
String professionaltitleTranslated;
String individualTypeTranslated;
String workPlaceTypeTranslated;
if(acc.OKOCE_Country__c=='DK')
{
specTranslated=DKSpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=DKProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=DKIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=DKWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='FI')
{
specTranslated=FISpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=FIProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=FIIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=FIWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='NO')
{
specTranslated=NOSpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=NOProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=NOIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=NOWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='SE')
{
specTranslated=SESpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=SEProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=SEIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=SEWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
if (addressUsed && acc.OCE__AccountAddresses__r.isEmpty()) {
continue;
} else {
String parentName;
if (String.isNotBlank(acc.OCE__ParentAccount__r.Name)) {
parentName = acc.OCE__ParentAccount__r.Name;
if (String.isNotBlank(acc.OCE__ParentAccount__r.OCE__ParentAccount__r.Name)) {
parentName += ';' + acc.OCE__ParentAccount__r.OCE__ParentAccount__r.Name;
if (String.isNotBlank(acc.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name)) {
parentName += ';' + acc.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name;
}
}
}
AccountWrapper aw = new AccountWrapper
(
acc.OCE__AccountFullName__c,
acc.OCE__UniqueIntegrationID__c,
acc.ND_Parent_ID_Name__c,
parentName,
acc.OCE__AccountAddresses__r[0].OCE__FormattedAddress__c,
acc.OCE__AccountAddresses__r[0].OCE__Address__r.CHS_Brick_Description__c,
acc.ND_Primary_Zip__c,
acc.ND_Primary_City__c,
professionaltitleTranslated,
individualTypeTranslated,
specTranslated,
workPlaceTypeTranslated,
acc.OCE__AccountAddresses__r[0].OCE__Address__r.OCE__Building__c
);
accountWrapperResult.add(aw);
}
}
return JSON.serialize(accountWrapperResult);
}
public class AccountWrapper {
@AuraEnabled
public String name {get; set;}
@AuraEnabled
public String oneKeyID {get; set;}
@AuraEnabled
public String institution {get; set;}
@AuraEnabled
public String parenNames {get; set;}
@AuraEnabled
public String workplaceAddress {get; set;}
@AuraEnabled
public String brickDescription {get; set;}
@AuraEnabled
public String postalCode {get; set;}
@AuraEnabled
public String city {get; set;}
@AuraEnabled
public String professionaltitle {get; set;}
@AuraEnabled
public String individualType {get; set;}
@AuraEnabled
public String specialty {get; set;}
@AuraEnabled
public String workPlaceType {get; set;}
@AuraEnabled
public String building {get; set;}
public AccountWrapper() {}
public AccountWrapper(
String name,
String oneKeyID,
String institution,
String parenNames,
String workplaceAddress,
String brickDescription,
String postalCode,
String city,
String professionaltitle,
String individualType,
String specialty,
String workPlaceType,
String building
) {
this.name = name;
this.oneKeyID = oneKeyID;
this.institution = institution;
this.parenNames = parenNames;
this.workplaceAddress = workplaceAddress;
this.brickDescription = brickDescription;
this.postalCode = postalCode;
this.city = city;
this.professionaltitle=professionaltitle;
this.individualType=individualType;
this.specialty=specialty;
this.workPlaceType=workPlaceType;
this.building=building;
}
}
}
==================
public with sharing class ND_SupportDirectMailingHCPController {
@readOnly
@RemoteAction
@AuraEnabled(Cacheable=true)
public static String findRecords(
String lastName,
String firstName,
String institution,
String professionaltitle,
String address,
String city,
String oneKeyID,
String country,
String territory,
String specialty,
String individualType,
String brickDescription,
String workPlaceType,
String building,
Boolean isHCP
) {
Map<String,String> DKSpecialityMap = new Map<String,String>();
Map<String,String> FISpecialityMap = new Map<String,String>();
Map<String,String> NOSpecialityMap = new Map<String,String>();
Map<String,String> SESpecialityMap = new Map<String,String>();
Map<String,String> DKProfessionalTitleMap = new Map<String,String>();
Map<String,String> FIProfessionalTitleMap = new Map<String,String>();
Map<String,String> NOProfessionalTitleMap = new Map<String,String>();
Map<String,String> SEProfessionalTitleMap = new Map<String,String>();
Map<String,String> DKIndividualTypeMap = new Map<String,String>();
Map<String,String> FIIndividualTypeMap = new Map<String,String>();
Map<String,String> NOIndividualTypeMap = new Map<String,String>();
Map<String,String> SEIndividualTypeMap = new Map<String,String>();
Map<String,String> DKWorkplaceTypeMap = new Map<String,String>();
Map<String,String> FIWorkplaceTypeMap = new Map<String,String>();
Map<String,String> NOWorkplaceTypeMap = new Map<String,String>();
Map<String,String> SEWorkplaceTypeMap = new Map<String,String>();
List<QIDC__OK_Codes_Translation_ims__c> translationsCodes = new List<QIDC__OK_Codes_Translation_ims__c>();
translationsCodes=[select id,QIDC__OK_Code_ims__r.name,
QIDC__OK_Code_ims__r.QIDC__Label_ims__c,
QIDC__Label_ims__c,
QIDC__OK_Code_ims__r.QIDC__Country_ims__c,
QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c
from QIDC__OK_Codes_Translation_ims__c
where
QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c in ('TIT','TYP','SP','LEX')
and QIDC__OK_Code_ims__r.QIDC__Country_ims__c in ('DK','FI','NO','SE')
and QIDC__OK_Code_ims__r.QIDC__Is_Active_ims__c =true limit 3000];
for(QIDC__OK_Codes_Translation_ims__c eachTransCountry :translationsCodes )
{
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
DKSpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
FISpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
NOSpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='SP')
{
SESpecialityMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
DKProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
FIProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
NOProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TIT')
{
SEProfessionalTitleMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
DKIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
FIIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
NOIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='TYP')
{
SEIndividualTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='DK' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
DKWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='FI' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
FIWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='NO' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
NOWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
else if(eachTransCountry.QIDC__OK_Code_ims__r.QIDC__Country_ims__c=='SE' && eachTransCountry.QIDC__OK_Code_ims__r.QIDC__LIS_Code_ims__c=='LEX')
{
SEWorkplaceTypeMap.put(eachTransCountry.QIDC__OK_Code_ims__r.Name,eachTransCountry.QIDC__Label_ims__c);
}
}
List<AccountWrapper> accountWrapperResult = new List<AccountWrapper>();
Boolean addressUsed = false;
String query = 'SELECT OCE__ExtendedCategory__c,OKOCE_Country__c,OCE__Specialty__c,OCE__IndividualTypes__c,OCE__UniqueIntegrationID__c,ND_Parent_Account__c,ND_Parent_ID_Name__c, OCE__AccountFullName__c,CHS_Building_Label__c,OCE__ProfessionalTitle__c,ND_Primary_Brick__c,ND_Primary_City__c,ND_Primary_Zip__c, ' +
' OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.Name,' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name, ' +
' OCE__Territories__c, ' +
' (' +
' SELECT Id, OCE__Country__c, OCE__FormattedAddress__c,OCE__Address__r.CHS_Brick_Description__c,OCE__Address__r.OCE__Building__c ' +
' FROM OCE__AccountAddresses__r ' +
' WHERE OCE__IsPrimary__c = true ';
if (String.isNotBlank(address)) {
query += ' AND OCE__FormattedAddress__c LIKE \'%' + String.escapeSingleQuotes(address) + '%\' ';
addressUsed = true;
}
if (String.isNotBlank(country)) {
query += ' AND OCE__Country__c LIKE \'%' + String.escapeSingleQuotes(country) + '%\' ';
addressUsed = true;
}
if(!isHCP)
{
query += ' And OCE__AddressType__c in (\'M\',\'P\') ';
}
if (String.isNotBlank(brickDescription)) {
query += ' AND OCE__Address__r.CHS_Brick_Description__c LIKE \'%' + String.escapeSingleQuotes(brickDescription) + '%\' ';
}
if (String.isNotBlank(building)) {
query += ' AND OCE__Address__r.OCE__Building__c LIKE \'%' + String.escapeSingleQuotes(building) + '%\' ';
}
query += ') ' +
' FROM Account ' +
' WHERE OCE__IsActive__c = true ' +
' AND IsPersonAccount = :isHCP ';
if (String.isNotBlank(lastName)) {
if (isHCP) {
query += ' AND LastName LIKE \'%' + String.escapeSingleQuotes(lastName) + '%\' ';
} else {
query += ' AND OCE__AccountFullName__c LIKE \'%' + String.escapeSingleQuotes(lastName) + '%\' ';
}
}
if (String.isNotBlank(firstName)) {
query += ' AND FirstName LIKE \'%' + String.escapeSingleQuotes(firstName) + '%\' ';
}
if (String.isNotBlank(institution)) {
query += ' AND ND_Parent_ID_Name__c LIKE \'%' + String.escapeSingleQuotes(institution) + '%\' ';
}
if (String.isNotBlank(individualType)) {
query += ' AND toLabel(OCE__IndividualTypes__c) LIKE \'%' + String.escapeSingleQuotes(individualType) + '%\' ';
}
if (String.isNotBlank(professionaltitle)) {
query += ' AND toLabel(OCE__ProfessionalTitle__c) LIKE \'%' + String.escapeSingleQuotes(professionaltitle) + '%\' ';
}
if (String.isNotBlank(city)) {
query += ' AND ND_Primary_City__c LIKE \'%' + String.escapeSingleQuotes(city) + '%\' ';
}
if (String.isNotBlank(oneKeyID)) {
query += ' AND OCE__UniqueIntegrationID__c LIKE \'%' + String.escapeSingleQuotes(oneKeyID) + '%\' ';
}
if (String.isNotBlank(workPlaceType)) {
query += ' AND toLabel(OCE__ExtendedCategory__c) LIKE \'%' + String.escapeSingleQuotes(workPlaceType) + '%\' ';
}
if (String.isNotBlank(territory)) {
query += ' AND OCE__Territories__c LIKE \'%' + String.escapeSingleQuotes(territory) + '%\' ';
}
if (String.isNotBlank(specialty))
{
query += ' AND (toLabel(OCE__Specialty__c) = :specialty OR toLabel(OCE__Specialty2__c) = :specialty OR toLabel(OCE__Specialty3__c) = :specialty)';
}
query += 'and OCE__IsPrivacyLaw__c =false and OCE__DoNotMail__c =false and OKOCE_Country__c in (\'DK\',\'FI\',\'NO\',\'SE\') LIMIT 1000 ';
List<Account> accounts = Database.query(query);
if (accounts == null) {
return null;
}
System.debug(accounts);
Set<id> acctIds = new Set<id>();
List<Account> acctsListToDisplay = new List<Account>();
if(isHCP)
{
for (Account acc : accounts)
{
acctIds.add(acc.id);
}
List<OCE__Affiliation__c> affLists = new List<OCE__Affiliation__c>();
affLists=[Select id,OCE__From__c from OCE__Affiliation__c where OCE__IsPrivacyLaw__c =false and OCE__DoNotMail__c =false and OCE__From__c in :acctIds and OCE__IsPrivacyLaw__c=false and OCE__DoNotMail__c=false and CHS_Preferred_Mailing_Flag__c=false limit 10000];
List<id> affFromIds= new List<id>();
for(OCE__Affiliation__c thisAff : affLists)
{
affFromIds.add(thisAff.OCE__From__c);
}
for(Account acc : accounts)
{
if(affFromIds.Contains(acc.id))
{
acctsListToDisplay.add(acc);
}
}
}
else{
acctsListToDisplay=accounts;
}
for (Account acc : acctsListToDisplay)
{
String specTranslated;
String professionaltitleTranslated;
String individualTypeTranslated;
String workPlaceTypeTranslated;
if(acc.OKOCE_Country__c=='DK')
{
specTranslated=DKSpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=DKProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=DKIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=DKWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='FI')
{
specTranslated=FISpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=FIProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=FIIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=FIWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='NO')
{
specTranslated=NOSpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=NOProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=NOIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=NOWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
else if(acc.OKOCE_Country__c=='SE')
{
specTranslated=SESpecialityMap.get(acc.OCE__Specialty__c);
professionaltitleTranslated=SEProfessionalTitleMap.get(acc.OCE__ProfessionalTitle__c);
individualTypeTranslated=SEIndividualTypeMap.get(acc.OCE__IndividualTypes__c);
workPlaceTypeTranslated=SEWorkplaceTypeMap.get(acc.OCE__ExtendedCategory__c);
}
if (addressUsed && acc.OCE__AccountAddresses__r.isEmpty()) {
continue;
} else {
String parentName;
if (String.isNotBlank(acc.OCE__ParentAccount__r.Name)) {
parentName = acc.OCE__ParentAccount__r.Name;
if (String.isNotBlank(acc.OCE__ParentAccount__r.OCE__ParentAccount__r.Name)) {
parentName += ';' + acc.OCE__ParentAccount__r.OCE__ParentAccount__r.Name;
if (String.isNotBlank(acc.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name)) {
parentName += ';' + acc.OCE__ParentAccount__r.OCE__ParentAccount__r.OCE__ParentAccount__r.Name;
}
}
}
AccountWrapper aw = new AccountWrapper
(
acc.OCE__AccountFullName__c,
acc.OCE__UniqueIntegrationID__c,
acc.ND_Parent_ID_Name__c,
parentName,
acc.OCE__AccountAddresses__r[0].OCE__FormattedAddress__c,
acc.OCE__AccountAddresses__r[0].OCE__Address__r.CHS_Brick_Description__c,
acc.ND_Primary_Zip__c,
acc.ND_Primary_City__c,
professionaltitleTranslated,
individualTypeTranslated,
specTranslated,
workPlaceTypeTranslated,
acc.OCE__AccountAddresses__r[0].OCE__Address__r.OCE__Building__c
);
accountWrapperResult.add(aw);
}
}
return JSON.serialize(accountWrapperResult);
}
public class AccountWrapper {
@AuraEnabled
public String name {get; set;}
@AuraEnabled
public String oneKeyID {get; set;}
@AuraEnabled
public String institution {get; set;}
@AuraEnabled
public String parenNames {get; set;}
@AuraEnabled
public String workplaceAddress {get; set;}
@AuraEnabled
public String brickDescription {get; set;}
@AuraEnabled
public String postalCode {get; set;}
@AuraEnabled
public String city {get; set;}
@AuraEnabled
public String professionaltitle {get; set;}
@AuraEnabled
public String individualType {get; set;}
@AuraEnabled
public String specialty {get; set;}
@AuraEnabled
public String workPlaceType {get; set;}
@AuraEnabled
public String building {get; set;}
public AccountWrapper() {}
public AccountWrapper(
String name,
String oneKeyID,
String institution,
String parenNames,
String workplaceAddress,
String brickDescription,
String postalCode,
String city,
String professionaltitle,
String individualType,
String specialty,
String workPlaceType,
String building
) {
this.name = name;
this.oneKeyID = oneKeyID;
this.institution = institution;
this.parenNames = parenNames;
this.workplaceAddress = workplaceAddress;
this.brickDescription = brickDescription;
this.postalCode = postalCode;
this.city = city;
this.professionaltitle=professionaltitle;
this.individualType=individualType;
this.specialty=specialty;
this.workPlaceType=workPlaceType;
this.building=building;
}
}
}
- Wajeed Khan
- February 09, 2022
- Like
- 0
ERROR MESSAGE: Argument 2 cannot be null Error is in expression '{!methodName}' in component <apex:page> in page namespace:className: External entry point
Hi,
I'm facing a problem regarding PageReference object. When I use the following code in Scratch Org and push the Package to client Org then all works as expected:
PageReference pdf = Page.pageName;
pdf.getParameters().put('id',si.id);
pdf.setRedirect(true);
Blob b = pdf.getContent(); //it works and blob content created to insert the document record
However, updating the code like following only works in Scratch Org but failed when moving Package to client org.
PageReference pdf = new PageReference('/apex/'+si.Invoice_Template__r.Visualforce_Page__c);
pdf.getParameters().put('id',si.id);
pdf.setRedirect(true);
Blob b = pdf.getContent(); //this fails to execute and the following error thrown
ERROR MESSAGE: Argument 2 cannot be null Error is in expression '{!methodName}' in component <apex:page> in page namespace:className: External entry point
Looking forward to get some help on this please. Thanks
I'm facing a problem regarding PageReference object. When I use the following code in Scratch Org and push the Package to client Org then all works as expected:
PageReference pdf = Page.pageName;
pdf.getParameters().put('id',si.id);
pdf.setRedirect(true);
Blob b = pdf.getContent(); //it works and blob content created to insert the document record
However, updating the code like following only works in Scratch Org but failed when moving Package to client org.
PageReference pdf = new PageReference('/apex/'+si.Invoice_Template__r.Visualforce_Page__c);
pdf.getParameters().put('id',si.id);
pdf.setRedirect(true);
Blob b = pdf.getContent(); //this fails to execute and the following error thrown
ERROR MESSAGE: Argument 2 cannot be null Error is in expression '{!methodName}' in component <apex:page> in page namespace:className: External entry point
Looking forward to get some help on this please. Thanks
- babaKhan
- October 17, 2019
- Like
- 0
Can anyone give test code coverage for below code please ,thanks in advance
public with sharing class Call_Controller { public Call__c call{get;set;} public Id accountId {get;set;} public List<Account_Affiliation__c> accAf{get;Set;} public List<wrapperClass> wrapClassList{get;set;} public wrapperClass wc{get;set;} public Account acc{get;set;} Set<Id> ParentID = new Set<id>(); Set<id> CallId= new Set<Id>(); public Call_Controller(ApexPages.StandardController ctrl) { if(!test.isRunningTest()) ctrl.addFields(new List<String>{'Account__c'}); wrapClassList = new List<wrapperClass>(); accountId =ApexPages.currentPage().getParameters().get('accId'); accAf = new List<Account_Affiliation__c>(); call = (Call__c)ctrl.getRecord(); if(accountId==null) { accountId=call.Account__c; } else { call.Account__c = accountId; } acc=[select ID,Name from Account where id=:accountId]; accAf=[Select id,Status__c,To__r.name,From__c,To__c From Account_Affiliation__c where From__c=:accountId and Status__c=true]; Set<String> callName=new Set<String>(); if(ctrl.getId()!=null) { try{ List<Call__c> childCall = [select id,Account__r.Name,Call_Date__c,out_Of_Office__c,Comments__c,parent_call__c from call__c where Parent_call__c=:call.Id]; for(Call__c cc : childCall) { wc = new wrapperClass(cc.Account__r.Name,cc.Id); callName.add(cc.Account__r.Name); wc.flag=true; ParentID.add(cc.Account__c); callId.add(cc.Id); wrapClassList.add(wc); } } catch(Exception ex) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,ex.getMessage()+' at line number '+ex.getLineNumber())); } } for(Account_Affiliation__c af:accAf) { if(!callName.contains(af.To__r.Name)) { wc = new wrapperClass(af.To__r.Name,af.Id); wc.accWrap=af; wrapClassList.add(wc); } } } public class wrapperClass { public boolean flag{get;set;} public Account_Affiliation__c accWrap{get;set;} public String accName{get;set;} public Id Cid{get;set;} public wrapperClass(String Name,id Cid) { this.Cid=Cid; accName=Name; } } //Record Creation for Related Records on Save public void createRelRecordOnSave() { for(wrapperClass wc:wrapClassList) { if(wc.flag==true) { if(!callId.contains(wc.Cid)) { Call__c relCall= new Call__c(); relCall.Account__c=wc.accWrap.To__c; relCall.Out_of_office__c=call.Out_of_office__c; relcall.Parent_Call__c=call.id; relCall.Call_Date__c=call.Call_Date__c; relCall.Comments__c=call.Comments__c; relCall.Status__c='Draft'; insert relCall; } else { Call__c c1=[select id,Account__c,Out_of_office__c,Call_Date__c,Comments__c from Call__c where Account__c=:wc.accWrap.To__c]; c1.Call_Date__c=call.Call_Date__c; c1.Status__c='Draft'; c1.Comments__c=call.Comments__c; c1.Out_of_office__c=call.Out_of_office__c; update c1; } } } } public void clear() { call.Comments__c=null; } //Record Creation for Related Records on Submit public void createRelRecordOnSubmit() { for(wrapperClass wc:wrapClassList) { if(wc.flag==true ) { if(!callId.contains(wc.Cid)) { Call__c relCall= new Call__c(); relCall.Account__c=wc.accWrap.To__c; relCall.Out_of_office__c=call.Out_of_office__c; relcall.Parent_Call__c=call.id; relCall.Call_Date__c=call.Call_Date__c; relCall.Comments__c=call.Comments__c; relCall.Status__c='Submitted'; insert relCall; } else { Call__c c1=[select id,Account__c,Out_of_office__c,Call_Date__c,Comments__c from Call__c where Id = :wc.Cid]; c1.Call_Date__c=call.Call_Date__c; c1.Status__c='Submitted'; c1.Comments__c=call.Comments__c; c1.Out_of_office__c=call.Out_of_office__c; update c1; } } } } //Save Button public PageReference Save() { if(call.Call_Date__c>System.today()) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,'You Cannot Enter A future Date')); return null; } else { try{ call.Status__c='Draft'; upsert call; createRelRecordOnSave(); PageReference reRend = new PageReference('/'+AccountID); reRend.setRedirect(true); return reRend; } catch(Exception ex) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,ex.getMessage()+' at line number '+ex.getLineNumber())); } } return null; } public PageReference cancel() { PageReference reRend = new PageReference('/'+AccountID); reRend.setRedirect(true); return reRend; } //Submit Button public PageReference Submit() { if(call.Call_Date__c>system.today()) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,'You Cannot Enter A future Date')); } try{ call.Status__c='Submitted'; upsert call; createRelRecordOnSubmit(); PageReference reRend = new PageReference('/'+AccountID); reRend.setRedirect(true); return reRend; } catch(Exception ex) { ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,ex.getMessage()+' at line number '+ex.getLineNumber())); } return null; } }
- Wajeed Khan
- November 06, 2018
- Like
- 0