salesforce的功能_salesforce开发

Product2 obj = (Product2)Product2.sObjectType.newSObject(
    null, // null will make it the default record type for the user
    true // loadDefaultValues
);

String NAME_TEMPLATE_INVALID = '{"en-US":"{0}","th-TH":"","vi-VN":"","zh-Hans":"","zh-Hant":""}',// 转义前
NAME_TEMPLATE = '\'{\'"en-US":"{0}","th-TH":"","vi-VN":"","zh-Hans":"","zh-Hant":""\'}\'',// 转义后
fname = 'SFDC',
lname = 'Wilson';

Contact con = new Contact();
con.Multilingual_First_Name__c = String.format(NAME_TEMPLATE, new List<String> {fname});
con.Multilingual_Last_Name__c = String.format(NAME_TEMPLATE, new List<String> {lname});

System.debug(LoggingLevel.INFO, '*** JSON.serialize(con): ' + JSON.serialize(con));

SELECT Stagename, COUNT(Id) Records FROM Opportunity GROUP BY ROLLUP (Stagename)

SELECT WEEK_IN_YEAR(CloseDate), CALENDAR_YEAR(CloseDate), COUNT(id)
FROM Opportunity
GROUP BY ROLLUP(WEEK_IN_YEAR(CloseDate),CALENDAR_YEAR(CloseDate))
ORDER BY CALENDAR_YEAR(CloseDate), WEEK_IN_YEAR(CloseDate)

Global class Building _Delete implements Database.Batchable<Sobject>{
    Global Database.QueryLocator start(Database.BatchableContext bc){

        String query='SELECT Id FROM Building__c';
        return Database.getQueryLocator(query);

    }
    Global void execute(Database.BatchableContext bc,List<Building__c>scope){

        delete scope;
        // empty soft-deleted records from recycle bin
        Database.emptyRecycleBin(scope);

    }
    Global void Finish(Database.BatchableContext bc){

        messaging.SingleEmailMessage mail = new messaging.SingleEmailMessage();
        string[] toadd = new string []{'xxxxxxxxxx@gmail.com'} ;//our own mail 
        mail.setToAddresses(toadd);
        mail.setSubject('Batch Completion Alert');
        mail.setPlainTextBody('BatchJob'+bc.getJobId()+'is Processed Successfully');
        messaging.Email[] emails = new messaging.Email[]{mail};
        messaging.sendEmail(emails);

    }
}

// 包含Fullname则需要使用Limit 1
SELECT Fullname, IsActive, Description FROM RemoteSiteSetting LIMIT 1

// 不包含Fullname无需限制
SELECT Id, IsActive, Description FROM RemoteSiteSetting

// 折中办法
查询所有id，然后再便利id list指定id参数查询含Fullname的数据

Map<String, Account> accMap = new Map<String, Account>([SELECT Id, Name FROM Account]);
System.debug(LoggingLevel.INFO, '*** accMap: ' + accMap);
Set<String> accidSet = accMap.keySet();

List<String> strList = new List<String> {'I', 'II'};
String valList = '(';
for(String str : strList){
    valList += '\'' + (String)str + '\',';
}
valList = strList <> null && strList.size() > 0 ? 
         valList.substringBeforeLast(',') + ')' : 
         '(\'\')';

String soql = 'SELECT Id, Account__c, Multi_Picklist__c FROM Test__c WHERE Multi_Picklist__c INCLUDES ' + valList + ' AND Account__c IN :accidSet';
List<Test__c> records = Database.query(soql);
System.debug(LoggingLevel.INFO, '*** records: ' + records);

SELECT Id,
TYPEOF Who
    WHEN Lead THEN Email, Phone
    WHEN Contact THEN Id, Name, Email, Phone
END
FROM Event WHERE Subject = 'your subject'

String message = '12345678901';
System.debug(message.abbreviate(10));

// 14:45:40:003 USER_DEBUG [2]|DEBUG|1234567...

SELECT Id, Name, UrlPathPrefix, Status, OptionsSiteAsContainerEnabled FROM Network 

// 方法一：正则替换
String s = '["A", "B"]';
System.debug(LoggingLevel.INFO, '*** s: ' + s);
String result = s.replaceAll('\\[', '').replaceAll('\\]', '');
System.debug(LoggingLevel.INFO, '*** result: ' + result);
List<String> aList = result.split(',');
System.debug(LoggingLevel.INFO, '*** aList: ' + aList);

// 方法二：字符串截取
String s = '["A", "B"]';
System.debug(LoggingLevel.INFO, '*** s: ' + s);
String result = s.substring(1, s.length()-1);
System.debug(LoggingLevel.INFO, '*** result: ' + result);
List<String> aList = result.split(',');
System.debug(LoggingLevel.INFO, '*** aList: ' + aList);

SELECT Profile.Name FROM PermissionSet WHERE IsCustom = FALSE AND Profile.UserType = 'Standard' AND Profile.PermissionsAuthorApex = TRUE

SELECT Floor_Unit__c, COUNT(Id) totalSize FROM Unit__c WHERE Floor_Unit__c != null GROUP BY Floor_Unit__c HAVING COUNT(Id) > 1

// 调整前
String rfieldStr = 'Owner.Email;
List<String> fields = rfieldStr .split('.');
System.debug(fields);// empty result

// 调整后
String rfieldStr = 'Owner.Email;
List<String> fields = rfieldStr .split('\\.');
System.debug(fields);// result as we expected

// #1 示例1
if (object!= null){
    String s = object.fieldName;
}

// 使用v50.0及以上api版本，可改写为
String s = object?.fieldName;

// #2 示例2
String accountName;
if(accountIdAccountMap <> null && accountIdAccountMap.get(accId) <> null)
    accountName = accountIdAccountMap.get(accId).Name;

// 使用v50.0及以上api版本，可改写为
String accountName = accountIdAccountMap?.get(accId)?.Name;

FIND {United Oil*} 
IN ALL FIELDS  
RETURNING Account(Id), Contact(Id), Lead(Id)

public class CustomSearchController {
    @AuraEnabled
    public static List<String> searchForIds(String searchText) {
        List<List<SObject>> results = [FIND :searchText IN ALL FIELDS  RETURNING Account(Id), Contact(Id), Lead(Id)];
        List<String> ids = new List<String>();
        for (List<SObject> sobjs : results) {
            for (SObject sobj : sobjs) {
                ids.add(sobj.Id);
            }
        }
        return ids;
    }
}

Public with sharing class SOSLController{
    Public List<Opportunity> optyList{get;set;}
    Public List<contact> conList{get;set;}
    Public List<account> accList{get;set;}
    
    Public String searchStr{get;set;}
    Public SOSLController() {

    }
    
    Public void soslDemo_method() {
        optyList = New List<Opportunity>();
        conList = New List<contact>();
        accList = New List<account>();
        if(searchStr.length() > 1) {
            String searchStr1 = '*'+searchStr+'*';
            String searchQuery = 'FIND \'' + searchStr1 + '\' IN ALL FIELDS RETURNING  Account (Id,Name,type),Contact(name,email),Opportunity(name,StageName)';
            List<List <sObject>> searchList = search.query(searchQuery);
            accList = ((List<Account>)searchList[0]);
            conList  = ((List<contact>)searchList[1]);
            optyList = ((List<Opportunity>)searchList[2]);
            System.debug('dk..'+searchList +':account:'+accList );
            if(accList.size() == 0 && conList.size() == 0 && optyList.size() == 0) {
                apexPages.addmessage(new apexpages.message(apexpages.severity.Error, 'Sory, no results returned with matching string...'));
                return;
            }
        }else {
            apexPages.addmessage(new apexpages.message(apexpages.severity.Error, 'Please enter at least two characters...'));
            return;
        }
    }
}

SELECT RiskType, Setting, SettingGroup, OrgValue, StandardValue FROM SecurityHealthCheckRisks where RiskType='HIGH_RISK'

SELECT Setting, SettingGroup, StandardValue, SettingRiskCategory FROM SecurityHealthCheckRisks

String template = '{0}, has updated the following new task: \n\n';
template+= 'Subject - {1}\n';
template+= 'Status - {2}\n';
template+= 'Priority - {3}\n';

List<String> args = new List<String>();
//args.add(tsk.LastModifiedBy.name);
//args.add(tsk.Subject);
//args.add(tsk.Status);
//args.add(tsk.Priority);

args.add('Tom');
args.add('Lead01');
args.add('Completed');
args.add('Normal');

String formattedHtml = String.format(template, args);
System.debug('......formattedHtml: ' + formattedHtml);

public static String SOQL_TEMPLATE = 'SELECT {0} FROM {1} WHERE {3} in :masterIds {2} GROUP BY {3}';

String soql = String.format(SOQL_TEMPLATE, new String[]{'COUNT(Id)', 'Contact', 'AccountId', 'LeadSource'});
System.debug('SOQL is ' + soql);

List<User> uList = [SELECT Id, Name, Email, UserRole.Name FROM User WHERE IsActive = TRUE AND (NOT Email LIKE '%invalid') ORDER BY Email];

List<Task> myTasks = new List<Task>();
for(integer i = 0; i < 5; i ++){
    Task newTask = new Task();
    newTask.Subject='Automated Task';
    newTask.OwnerId = ;
    myTasks.add(newTask);
}
Database.DMLOptions notifyOption = new Database.DMLOptions();
notifyOption.EmailHeader.triggerUserEmail = true;

//we need to use the Database.insert() with the DMLOptions to insert the task instead of using the standard insert DML command
Database.insert(myTasks, notifyOption);

SELECT Id, Name FROM RecentlyViewed WHERE Type ='Account'

Id recId = '00Q0l000005pF5A';
String sobj1 = String.valueOf(recId.getSObjectType());
String sobj2 = recId.getSObjectType().getDescribe().getName();

SELECT Id, Name, Country, DefaultLocaleSidKey, TimeZoneSidKey, LanguageLocaleKey, 
       ReceivesInfoEmails, ReceivesAdminInfoEmails, 
       UiSkin, TrialExpirationDate, OrganizationType, NamespacePrefix, 
       InstanceName, IsSandbox, IsReadOnly, 
       MonthlyPageViewsUsed, MonthlyPageViewsEntitlement 
FROM Organization

List<Schema.DescribeTabSetResult> dtsrList = Schema.describeTabs();
for(DescribeTabSetResult dtsr : dtsrList){
    String appLabel = dtsr.getLabel();
    System.debug('App label: ' + appLabel);
    
    if(appLabel == 'Sales'){
        List<Schema.DescribeTabResult> dtrList = dtsr.getTabs();
        for(Schema.DescribeTabResult dtr : dtrList){
            System.debug('Tab label: ' + dtr.getLabel());
            System.debug('Tab icon url: ' + dtr.getIconUrl());
            System.debug('Tab url: ' + dtr.getUrl());
        }
    }
}

String rid = [SELECT Id, Developername FROM Report WHERE Developername = 'ContactExportReport' LIMIT 1].Id;
PageReference file = new PageReference('/'+rid+'?export=1&enc=UTF-8&xf=csv');
Http http = new Http();
            
HttpRequest request = new HttpRequest();
string sURL=label.File_Server_Domain+'/hornet/backup2?suffix=csv&module='+umoduleName;
request.setEndpoint(sURL);
request.setMethod('POST');
request.setHeader('Content-Type','application/csv');
if(!test.isrunningtest()) request.setBodyAsBlob(file.getcontent());

request.setTimeout(120000);
            
HttpResponse response = http.send(request);

Map<String, Object> result = (Map<String, Object>)JSON.deserializeUntyped(response.getBody());

datetime.now().format('E');

List<String> fNames = new List<String>{'Name', 'Industry', 'Type'};
String objectName = 'Account';
String query = 'SELECT Id'+ (fNames.size() > 0 ? ',' + String.join(fNames,',') : '') +' FROM '+ objectName;
System.debug(query);

ConnectApi.CommunityPage cc = ConnectApi.Communities.getCommunities();
System.debug(cc.communities[0].siteUrl);

/*---------Demo--------*/
System.debug(String.valueOf(System.now().format('yyyy/MM/dd hh:mm')));

Date dt = Date.today().addDays(15);
Datetime dtDateTime = dt; // Implicit cast
System.debug(dtDateTime.format('yyyy/MM/dd'));


/*---------公共方法--------*/
public static String dateOrTimeFormat(String type, Object dateOrTime) {
    Datetime dt = (Datetime) dateOrTime;
    return 'Date'.equals(type) ? dt.format('yyyy/MM/dd') : dt.format('yyyy/MM/dd HH:mm');
}

/*---------应用--------*/
Test__c t = [SELECT Id, Date__c, DateTime__c FROM Test__c WHERE Id = 'a0F7F00000DdKfe'];
System.debug('before convert...');
System.debug(t.Date__c);
System.debug(t.DateTime__c);

System.debug('after convert...');
Datetime dtDateTime = t.Date__c;
System.debug(UtilityClass.dateOrTimeFormat('Date', dtDateTime));
System.debug(UtilityClass.dateOrTimeFormat('DateTime', t.DateTime__c));

String query = 'SELECT Id, Name, (SELECT Id, Name FROM Contacts) FROM Account LIMIT 2';
List<SObject> parents = Database.query(query);
for(SObject parent : parents) {
    for(SObject child : parent.getSObjects('Contacts')) {
        system.debug('Child=' + child);
    }
}

String countString = '520';
System.debug(countString.leftPad(5, '0'));

<!-- make sure escape=”false”
Thanks & Regards, <br/>
sfdcsrini.blogspot.com Team <br/>
Testing by sfdcsrini.blogspot.com <br/>
 -->
<apex:outputText value="{!$Label.Test_With_Line_Breaks}" escape="false" />

Set<String> codes = new Set<String>{'001', '002', '003'};
//String mergeSet = String.join(codes, ';');// 语法错误
String mergeStr = String.join(new List<String>(codes), ';');
//System.debug(mergeSet);
System.debug(mergeStr);

List<String> sl = new List<String> {'a','b','c'};
system.debug(sl);
String s = String.join(sl, ';');
system.debug(s);

List<String> sLst = new List<String> {'1', '2', '1'};
System.debug(new Set<String> (sLst));

15 Listing(s) Skipped - {"a060k000005XppaAAC":["Listing's [E&V ID] doesn't start with 'EVHK': 是的發生分散","Listing's [Description] invalid content length: For description at least 30 words and maximum 2500 words"],"a060k000005fAKjAAM":["Listing's [E&V ID] doesn't start with 'EVHK': 435325","Listing's [Property Type](Complexd) doesn't match the property type those set in Squarefoot: Apartment公寓, Stand-alone building 單橦式大廈, Estate 屋苑, Public / HOS flat 公共屋邨 /居屋, Village house 村屋, House / Villa 獨立屋 / 洋房 / 別墅, Car park 停車場, Boat遊艇 / 船.","Listing's [Description] is missing"],"a060k000005YYwoAAG":["Listing's [E&V ID] doesn't start with 'EVHK': sdfsfsf","Listing's [Property Type](Complexd) doesn't match the property type those set in Squarefoot: Apartment公寓, Stand-alone building 單橦式大廈, Estate 屋苑, Public / HOS flat 公共屋邨 /居屋, Village house 村屋, House / Villa 獨立屋 / 洋房 / 別墅, Car park 停車場, Boat遊艇 / 船.","Listing's [Description] is missing"],"a060k000005fC7cAAE":["Listing's [Property Type] is missing","Listing's [Description] is missing"],"a060k000005LopTAAS":["Listing's [E&V ID] doesn't start with 'EVHK': 33252","Listing's [Property Type] is missing","Listing's [Description] is missing"],"a060k000005fBtQAAU":["Listing's [E&V ID] doesn't start with 'EVHK': 34534","Listing's [Description] is missing"],"a060k000005MCLfAAO":["Listing's [Description] is missing"],"a060k000005fDTzAAM":["Listing's [E&V ID] doesn't start with 'EVHK': 324566","Listing's [Description] is missing"],"a060k000005eWhPAAU":["Listing's [E&V ID] doesn't start with 'EVHK': 23552352435235","Listing's [Property Type] is missing","Listing's [Description] invalid content length: For description at least 30 words and maximum 2500 words"],"a060k000005f9spAAA":["Listing's [E&V ID] doesn't start with 'EVHK': 1233321","Listing's [Description] is missing"],"a060k000005fBtaAAE":["Listing's [E&V ID] doesn't start with 'EVHK': 4333228","Listing's [Description] is missing"],"a060k000005dAThAAM":["Listing's [Property Type](Complexd) doesn't match the property type those set in Squarefoot: Apartment公寓, Stand-alone building 單橦式大廈, Estate 屋苑, Public / HOS flat 公共屋邨 /居屋, Village house 村屋, House / Villa 獨立屋 / 洋房 / 別墅, Car park 停車場, Boat遊艇 / 船.","Listing's [Description] invalid content length: For description at least 30 words and maximum 2500 words"],"a060k000005XpjEAAS":["Listing's [E&V ID] doesn't start with 'EVHK': ewetw","Listing's [Description] is missing"],"a060k000005fAQhAAM":["Listing's [E&V ID] doesn't start with 'EVHK': 23423","Listing's [Description] is missing"],"a060k000005cmyGAAQ":["Listing's [Property Type] is missing","Listing's [Description] is missing"]}

List<Integration_Log__c> logs = [SELECT Id, Excepition__c  FROM Integration_Log__c WHERE Id = 'a080k00000DPLgG' LIMIT 1];
System.debug(logs[0].Excepition__c.length());
String content  = logs[0].Excepition__c;
Attachment att = new Attachment();
att.Parentid = 'a080k00000DPLgG';
att.Name = 'SfdcSyncListingsTosquarefoot partial success!';
att.Body = blob.valueOf(content);
insert att;

List<Attachment> atts = [SELECT Id, ParentId, Name, ContentType, Body, Description FROM Attachment WHERE Id = '00P0k000002yNQm'];
Blob contentBlob = atts[0].Body;
String str = contentBlob.toString();
System.debug(str);

/**********************周期性执行*********************/
ScheduledListingSyncToEVJob sc1 = new ScheduledListingSyncToEVJob();
String cronExp1 = '0 0 * * * ?'; 
String jobID1 = System.schedule('ScheduledListingSyncToEVJob0', cronExp1, sc1);
ScheduledListingSyncToEVJob sc2 = new ScheduledListingSyncToEVJob();
String cronExp2 = '0 10 * * * ?'; 
String jobID2 = System.schedule('ScheduledListingSyncToEVJob10', cronExp2, sc2);
ScheduledListingSyncToEVJob sc3 = new ScheduledListingSyncToEVJob();
String cronExp3 = '0 20 * * * ?'; 
String jobID3 = System.schedule('ScheduledListingSyncToEVJob20', cronExp3, sc3);
ScheduledListingSyncToEVJob sc4 = new ScheduledListingSyncToEVJob();
String cronExp4 = '0 30 * * * ?'; 
String jobID4 = System.schedule('ScheduledListingSyncToEVJob30', cronExp4, sc4);
ScheduledListingSyncToEVJob sc5 = new ScheduledListingSyncToEVJob();
String cronExp5 = '0 40 * * * ?'; 
String jobID5 = System.schedule('ScheduledListingSyncToEVJob40', cronExp5, sc5);
ScheduledListingSyncToEVJob sc6 = new ScheduledListingSyncToEVJob();
String cronExp6 = '0 50 * * * ?'; 
String jobID6 = System.schedule('ScheduledListingSyncToEVJob50', cronExp6, sc6);

email 2 case
TARGET:
do search in both contact and lead and populate the lead or contact value on case.
LOGIC:
1. email match sigle client -> relate to client
2. email match sigle lead   -> relate to lead
3. email match more than one lead or client or <both 1 lead + 1 contact> -> not relate
4. no match lead or contact -> no relate
RECORDTYPE:
case      -> Enquiry Case Record Type
contact   -> all<contact + personal contact>
Note:
SuppliedEmail on case will be the end client's email;
End clients will send email to the service email not the real email when using email to case;
Trigger Logic Design:
1. before insert

SELECT count(Phone) FROM Lead

User currentUser = [SELECT Id, Name, Email, Contact.Phone, Profile.Name FROM User WHERE Id = :UserInfo.getUserId() LIMIT 1];
Map<String, Object> tmap = new Map<String, Object>(currentUser.getPopulatedFieldsAsMap());
tmap.put('Oid', UserInfo.getOrganizationId());

List<Listing__c> lsts = [SELECT Id, Landlord__r.Email 
FROM Listing__c 
WHERE Is_Main_Record__c = TRUE AND 
IsDeleted__c = FALSE AND 
Sole_Agency__c = TRUE AND 
Agency_End_Date__c = TOMORROW AND 
Listing_Status__c = 'Active'  
ORDER BY Company_ID__c];
for(Listing__c lst : lsts) {
Map<String, Object> aMap = lst.getPopulatedFieldsAsMap();
System.debug(LoggingLevel.INFO, '*** aMap: ' + aMap);
for(String rfield : aMap.keySet()) {
if(rfield.endsWithIgnoreCase('__r') ) {
SObject obj = (SObject)aMap.get(rfield);
String email = (String)obj.get('Email');
System.debug(LoggingLevel.INFO, '*** Email: ' + Email);
}
}
System.debug(LoggingLevel.INFO, '*** lst: ' + lst);
System.debug(LoggingLevel.INFO, '*** lst.Landlord__r.Email: ' + lst.Landlord__r.Email);
/*
System.SObjectException: SObject row was retrieved via SOQL without querying the requested field: Listing__c.Landlord__r
String email = (String)lst.get('Landlord__r.Email');
*/
}

HYPERLINK(LEFT($Api.Partner_Server_URL_260, FIND( '/services', $Api.Partner_Server_URL_260))+ Email_Template_ID__c +'?setupid=CommunicationTemplatesEmail', Email_Template_Name__c )

SELECT Id, Name From School__c WHERE Network_Code__c IN (SELECT Name From School_Networks__c WHERE Location__c = 'a015D000003SVcz')

List<Account> accs;
for(Account acc : accs) {
System.debug('check point1');
}
System.debug('check point2');

SELECT Id, Name,Recordtype.Name, Account_Status__c, (SELECT Field, OldValue, NewValue, CreatedById, CreatedDate FROM Account.Histories WHERE Field = 'RecordType') FROM Account

public class StagePickListController {
private static String DEFAULT_STAGENAME = 'S0 - Pre-Opportunity';
private final Opportunity opp;
public List<SelectOption> stages {get; set;}
public StagePickListController(ApexPages.StandardController stdController) {
this.opp = (Opportunity)stdController.getRecord();
initFields();
}
private void initFields(){
this.opp.StageName = DEFAULT_STAGENAME;
initStages();
}
private void initStages(){
stages = new List<SelectOption>();
// it is better to not hard-code picklist values
stages.add(new SelectOption('S0 - Pre-Opportunity','S0 - Pre-Opportunity'));
stages.add(new SelectOption('Qualified','Qualified'));
stages.add(new SelectOption('Closed Lost','Closed Lost'));
}
}

<apex:page standardcontroller="Opportunity" extensions="stagePickListController" tabstyle="Opportunity">
<apex:form id="Form">   
<apex:sectionHeader title="Opportunity Edit" subtitle="{!if(Opportunity.Id==null,'New Pre-Opportunity',Opportunity.Name)}"/>  
<apex:pageBlock mode="edit" id="oppPB" title="Opportunity Edit">
<apex:pageBlockButtons >
<apex:commandButton action="{!save}" value="Save"/>
<apex:commandButton action="{!cancel}" value="Cancel"/>
</apex:pageBlockButtons>
<apex:pagemessages/>
<apex:pageBlockSection id="OpportunityInformation" title="Pre-Opportunity Information">
<apex:inputField value="{!Opportunity.OwnerId}"/>
<apex:inputField value="{!Opportunity.AccountId}" required="true"/>
<apex:inputField value="{!Opportunity.CloseDate}" required="true"/>
<apex:selectList value="{!Opportunity.StageName}" size="4" multiselect="false">
<apex:selectOptions value="{!stages}"/>
</apex:selectList>
<apex:inputField value="{!Opportunity.Name}" required="true"/>
</apex:pageBlockSection>
</apex:pageBlock>    
</apex:form>

(System.SelectOption[value="00X0I000001qK51UAE", label="Bonus 10% CN", disabled="false"], 
System.SelectOption[value="00X0I000001qK4mUAE", label="Bonus 10% EN", disabled="false"], 
System.SelectOption[value="00X0I000001qK56UAE", label="Bonus 20% CN", disabled="false"], 
System.SelectOption[value="00X0I000001qK4rUAE", label="Bonus 20% EN", disabled="false"], 
System.SelectOption[value="00X0I0000019TWnUAM", label="PDF Bonus Policy for IB IC CN", disabled="false"], 
System.SelectOption[value="00X0I0000019TWsUAM", label="PDF Bonus Policy for IB Imperial CN", disabled="false"], 
System.SelectOption[value="00X0I0000019TWxUAM", label="PDF Bonus Policy for IB Welcome CN", disabled="false"], 
System.SelectOption[value="00X0I0000019TX2UAM", label="PDF Bonus Policy for Loyalty CN", disabled="false"], 
System.SelectOption[value="00X0I0000019TX7UAM", label="PDF Multibank Advantages CN", disabled="false"], 
System.SelectOption[value="00X0I0000019TXCUA2", label="PDF Relatives and friends bonus", disabled="false"])

emailTemplate = emailTemplateOptions[0].getValue();

List<Sobject> originalParents = Database.query(queryStr);
System.debug('originalParents: ' + originalParents);
for(Sobject obj : originalParents) {
for(String s : allWritableFields) {
if(!exceptionSet.contains(s)) {
if(obj.get(s) != parentId2ChildMap.get(obj.id).get(s)) 
obj.put(s, parentId2ChildMap.get(obj.id).get(s));
if('version_no__c'.equals(s))
obj.put(s, String.valueOf(Integer.valueOf(obj.get(s)) + 1));// 父级版本号+1
}
}
}

MAP<ID,Opportunity> os = new MAP<Id,Opportunity>([Select ID from Opportunity]);
SET<ID> keys = os.keyset();// 此处必须转一下，不能直接在soql里面使用
String s = 'SELECT  RecordTypeId, COUNT(Id) os FROM Opportunity Where Id IN ';
s+=':keys GROUP BY RecordTypeId';
AggregateResult[] ars = Database.query(s);
System.debug(ars[0].get('RecordTypeId'));

Set<Id> recordIdSet = new Set<Id>();
switch on sobjectType {
when 'lead'    {recordIdSet = leadIdSet;}
when 'contact' {recordIdSet = contIdSet;}
}
String queryStr = 'select id, email from ' + sobjectType + ' where id in :recordIdSet';
List<Sobject> sobjList = Database.query(queryStr);

Boolean isConfig = 'config__c'.equals(sobj.toLowerCase());
String queryStr = (isConfig ? 'SELECT Value__c n' : 'SELECT Name n') + ' FROM ' + sobj + ' WHERE Id = \'' + recId + '\' GROUP BY ' + (isConfig ? 'Value__c' : 'Name');
// Note: 部分時候會出現使用'Id = '\' + recId + '\'過濾未生效，需要變更成：'Id = :recId'；

field.toLowerCase().endsWith('id');

public static Boolean isValid(String stringValue, Schema.SObjectType sObjectType) {
Id sObjectId;
if(isId(stringValue)) sObjectId = (Id)stringValue;
return isValid(sObjectId, sObjectType);
}
public static Boolean isValid(Id sObjectId, Schema.SObjectType sObjectType) {
return !(sObjectId==null || sObjectId.getSObjectType()!=sObjectType);
}
public static Boolean isId(String stringValue) {
return stringValue InstanceOf Id;
}

public static String getConvertedNameById(Id recId) {
String sobj = String.valueOf(recId.getsobjecttype());
Boolean isConfig = 'config__c'.equals(sobj.toLowerCase());
String queryStr = (isConfig ? 'SELECT Value__c n' : 'SELECT Name n') + ' FROM ' + sobj + ' WHERE Id = \'' + recId + '\' GROUP BY ' + (isConfig ? 'Value__c' : 'Name');
System.debug('queryStr: ' + queryStr);
return String.valueOf(Database.query(queryStr)[0].get('n'));
}

// 根据Id获取相关Name值 - 用于字段历史跟踪转义
// 注意：由于Listing Name为自动编号，所以不可Group
public static String getConvertedNameById(Id recId) {
String sobj = String.valueOf(recId.getsobjecttype());
Boolean isConfig = 'config__c'.equals(sobj.toLowerCase());
Boolean isListing = 'listing__c'.equals(sobj.toLowerCase());
String queryStr = (isConfig ? 'SELECT Value__c n' : (isListing ? 'SELECT Name_as__c n' : 'SELECT Name n')) + ' FROM ' + sobj + ' WHERE Id = \'' + recId + '\' GROUP BY ' + (isConfig ? 'Value__c' : (isListing ? 'Name_as__c' : 'Name'));
System.debug('queryStr: ' + queryStr);
return String.valueOf(Database.query(queryStr)[0].get('n'));
}

Schema.DescribeFieldResult grp = CustomObject__c.CustomField__c.getDescribe();
system.debug('Can CustomField__c be groupable?'+grp.groupable);

Id myId = Id.valueOf('001xa000003DIlo');

String suffix = 'History';
Id recId = (Id)parmmap.get('recordid');
String sobj = String.valueOf(recId.getsobjecttype());//根据记录id获取对象api name
Boolean isCustomObj = sobj.contains('__c');
System.debug('recId\'s sobject type is: ' + sobj);
String sobjectHistory = (isCustomObj ? sobj.left(sobj.length() - 1) : sobj) + suffix;
String parentType = isCustomObj ? 'ParentId' : (sobj + 'Id');
System.debug('sobjectHistory: ' + sobjectHistory);
System.debug('parentType: ' + parentType);
List<sobject> histories = Database.query('SELECT Id, IsDeleted, ' + parentType + ', CreatedById, CreatedDate, Field, OldValue, NewValue FROM ' + sobjectHistory + ' WHERE ' + parentType + ' = \'' + recId + '\' ORDER BY CreatedDate');
System.debug('histories: ' + histories);

<apex:commandButton value="New" onclick="navigateToUrl('/setup/ui/recordtypeselect.jsp?ent=Lead&retURL=%2F00Q%2Fo&save_new_url=%2F00Q%2Fe%3FretURL%3D%252F00Q%252Fo',null,'new');return false;"/>

{!$Setup.CustomSettingName__c.CustomFieldName__c}

SELECT ApexClassOrTrigger.Name, NumLinesCovered, NumLinesUncovered 
FROM ApexCodeCoverageAggregate 
WHERE ApexClassOrTrigger.Name = 'TaskUtil'

SELECT ApexTestClass.Name,TestMethodName,NumLinesCovered,NumLinesUncovered 
FROM ApexCodeCoverage 
WHERE ApexClassOrTrigger.Name = 'TaskUtil'

var hasLine = '{!Opportunity.HasOpportunityLineItem}';
alert('{!Opportunity.HasOpportunityLineItem}');0
alert(hasLine);0
alert('hasLine == 0: ' + hasLine == 0);false
alert('hasLine == 1: ' + hasLine == 1);false
alert('hasLine === 0: ' + hasLine === 0);false
alert('hasLine === 1: ' + hasLine === 1);false
alert(hasLine == false);true

{!$ObjectType.ACC_Return_Order_Product__c.LabelPlural}

{!$ObjectType.ACC_Return_Order_Product__c.Fields.ACC_Product__c.Label}

select count() from DTT__Geographic_Region__c

select count() from DTT__Geographic_Region__c

select count() from DTT__Geographic_Region__c

select count() from DTT__Geographic_Region__c

select count() from DTT__Geographic_Region__c

Map<String, String> accIDs = new Map<String,String>();
for(Quote qt: (List<Quote>)Trigger.New){
if(!accIDs.containsKey(qt.Quote_To_Account__c))
accIDs.put(qt.Quote_To_Account__c,'');
}
Map<String, Account> accs = new Map<String, Account>([SELECT id,BillingStreet,BillingCity, BillingState, BillingPostalCode, BillingCountry FROM Account WHERE Id IN : accIDs.keySet()]);

Date d = System.today();
Integer numberDays = date.daysInMonth(d.Year(), d.Month());
System.debug(numberDays);

Map<Id, List<Case>> userCaseMap = new Map<Id, List<Case>>();
List<Case> allCaseLoggedToday = new List<Case>();
List<Id> salesIds = new List<Id>();
List<User> salesRep = [SELECT Id , Name , Email , ManagerId 
FROM User 
WHERE Profile.Name = 'System Administrator'];
for(User u : salesRep) {
salesIds.add(u.Id);  
}
allCaseLoggedToday = [SELECT Id, CaseNumber,CreatedById, Owner.Name , Account.Name , Contact.Name  
FROM Case 
WHERE CreatedDate = TODAY AND CreatedById in : salesIds];
for(Case c : allCaseLoggedToday) {
if(userCaseMap.containsKey(c.CreatedById)) {
//Fetch the list of case and add the new case in it
List<Case> tempList = userCaseMap.get(c.CreatedById);
tempList.add(c);
//Putting the refreshed case list in map
userCaseMap.put(c.CreatedById , tempList);
}else {
//Creating a list of case and outting it in map
userCaseMap.put(c.CreatedById , new List<Case>{c});
}
}

Set<Integer> s = new Set<Integer> {1,2,3,2,1};
system.debug('s: ' + s);

List<Account> accs = [select id, name from account limit 3];
map<Id, Account> m = new map<Id, Account>();
String lastId = '';
if(accs != null && !accs.isEmpty()) {
Integer i = 0;
for(Account a : accs) {
System.debug('a['+i+'] : ' + a);
lastId = a.Id;
m.put(a.Id, a);
i++;
}
}
// 验证List有顺序，Map无顺序
System.debug(m);
System.debug(m.get(lastId));
Map<String, String> m1 = new Map<String, String> {
'key1' => 'value1',
'key2' => 'value2',
'key1' => 'value2',
'key2' => 'value3',  
'key1' => 'value3'
};
System.debug('m1: ' +m1);
System.debug('m1.key1: ' + m1.get('key1'));

任务：
Task task = new Task();
task.Subject = ‘A信息修改申请';
task.status = 'open';
task.priority = 'High';
task.whatId = '0017F00000CfcdsQAB';// 相关项目，这里是供应商Id
task.ownerId = '0057F000000pe6uQAA';// 被分配人，这里是UserId
// 以下两行是设置提醒
task.IsReminderSet = true;
task.ReminderDateTime = System.now();
insert task;

Select Id, Address__c, Geographic_Coordinates__Longitude__s, Geographic_Coordinates__Latitude__s From Store__c

filterStr = 'AND Type__c = \'Text\' ';// 注意写成转义字符形式
query = 'SELECT Name, Type__c, Message__c, Msgpic__c, Mediaid__c, VioceRecognition__c, VoiceFormat__c, VoiceSrc__c ' + 
'FROM BD_CaseDetail__c ' + 
'WHERE Case__c = :caseId ' + filterStr + 'ORDER BY CreatedDate ASC LIMIT 500';
caseDetailList = Database.query(query);

caseDetailList = [SELECT Name, Type__c, Message__c, Msgpic__c, Mediaid__c, VioceRecognition__c, VoiceFormat__c, VoiceSrc__c
FROM BD_CaseDetail__c
WHERE Case__c = :caseId AND Type__c = 'Text' ORDER BY CreatedDate ASC LIMIT 500];

public class OuterClass {
public class InnerClass {
String name = '';
Blob body = '';
}
}
// 实例化内部类
OuterClass outer = new OuterClass();
OuterClass.InnerClass inner = new OuterClass.InnerClass();
/*接口类实例化*/
global class SyncInterface {    
    // 封装数据结构 - 返回结果  
    global class SyncResults{  
        global List<Response> responses;  
    }  
      
    global class Response{  
        public String TYPE;  
        public String MSG;  
        public String BUSINESS_ID;  
        public String SALESFORCE_ID;  
        public String PROC_TYPE;              
    }  
}
// 实例化接口response list
SyncResults syncResponseList = new SyncResults();  
syncResponseList.responses = new List<Response>();

/**
功能说明：判别用户是否为项目比选相关专员
参数说明：用户Id
返回值：true/false
作者：Wilson Xu
日期：2017-07-26
**/   
public static Boolean isValidUser(String userId){
Set<String> profileSet = new Set<String>{'品牌专员','事件行销专员','物料制作专员','线上媒介专员','线下媒介专员','展览展示专员','子公司企划专员'};
String profileName = [SELECT Profile.Name FROM User WHERE Id = :userId].Profile.Name;        
return profileSet.contains(profileName);
}

// 验证该用户是否为专员简档用户
if(!isValidUser(UserInfo.getUserId())){
result.code = '1';
result.msg = '只有相关专员才能发起定向谈判！'; 
return JSON.serialize(result);
}

DateTime nowTime = System.now();
String now_date = nowTime.format('yyyy-MM-dd');
String now_dateTime = nowTime.format('yyyy-MM-dd HH:mm:ss');
System.debug(now_date+'<------>'+now_dateTime);

14:23:00:002 USER_DEBUG [4]|DEBUG|2017-07-26<------>2017-07-26 14:23:00

String strDate1 = '2018-6-6';
String strDate2 = '2018-06-06';
String strDate3 = '2018/6/6';
Date myDate1 = date.valueOf(strDate1);
Date myDate2 = date.valueOf(strDate2);
//Date myDate3 = date.valueOf(strDate3);//System.TypeException: Invalid date: 2018/6/6
System.debug('myDate1: ' + myDate1);
System.debug('myDate2: ' + myDate2);
//System.debug('myDate3: ' + myDate3);

<!--
setup="true";show sidebar as setup format;
renderAs="pdf";the body you development will show as pdf;
action="someMethods";excute the action first before render the page;
-->

<apex:sectionHeader title="Section Header Practice" subtitle="Home" description="draw your page using code" help="https://baidu.com" printUrl="https://baidu.com"/>

<span style="color:#ff0000">如果page中用到了setup="true"属性，那么sectionHeader中就不能显示对象图标。</span>

<apex:page id="pg">
<apex:form id="fm">
<apex:inputText id="name" onchange="show()"/>
<script>
function show() {
var el1 = document.getElementById('{!$Component.name}').value;
var el2 = document.getElementById('{!$Component.bk.age}').value;
alert('name: '+el1+', age: '+el2);
}
function demo() {
// getting specific dom element by this format, you shold write every level id.
var el1 = document.getElementById('pg:fm:name').value;
var el2 = document.getElementById('pg:fm:bk:age').value;
alert('name: '+el1+', age: '+el2);
}
</script>
<apex:pageBlock id="bk">
<apex:inputText id="age" onchange="demo()"/>
<apex:pageBlockSection id="bks1">
<apex:inputText id="ip1"/>
</apex:pageBlockSection>
<apex:pageBlockSection id="bks2">
<apex:inputText id="ip2"/>
<apex:outputText id="op"/>
</apex:pageBlockSection>
<apex:pageBlockButtons >
<apex:commandButton value="populateAutomaticly" onclick="al()" oncomplete="populateAutomaticly()"/>
</apex:pageBlockButtons>
<script>
function populateAutomaticly() {
var el = document.getElementById('{!$Component.bks1.ip1}').value;
document.getElementById('pg:fm:bk:bks2:ip2').value = el;
document.getElementById('pg:fm:bk:bks2:op').innerHTML = el;
}
function al() {
alert('Testing...');
}
</script>
</apex:pageBlock>
</apex:form>
</apex:page>

@RestResource(urlMapping='/Cases/*')
global with sharing class CaseManager {
@HttpGet
global static Case getCaseById() {
RestRequest req = RestContext.request;
String caseId = req.requestURI.substring(req.requestURI.lastIndexOf('/')+1);
Case result = [SELECT CaseNumber, Subject, Status, Origin, Priority
FROM Case
WHERE Id = :caseId];
return result;
}
/*
HttpGet步骤：
1、创建RestRequest类型的req对象(RestContext.request的返回值类型就是RestRequest)
2、通过req对象的requestURI属性利用字符串检索技术拿到caseId
3、创建Case对象result，并将通过caseId查到的记录赋值给该对象,注意“WHERE Id = :caseId”
4、返回Case对象
*/
@HttpPost
global static ID createCase(String subject, String status,
String origin, String priority) {
Case thisCase = new Case(
Subject=subject,
Status=status,
Origin=origin,
Priority=priority);
insert thisCase;
return thisCase.Id;
}
/*
HttpPost步骤：
1、声明并创建一个Case类型对象thisCase，并为该对象的标准字段赋值
2、将自定义对象插入到Case表中形成一条记录
3、返回一个新纪录的类型为ID的变量Id用于查找新纪录
*/
@HttpDelete
global static void deleteCase() {
RestRequest req = RestContext.request;
String caseId = req.requestURI.substring(req.requestURI.lastIndexOf('/')+1);
Case thisCase = [SELECT Id FROM Case WHERE Id = :caseId];
delete thisCase;
}
/*
思路：
要删除某一条记录首先要找到该记录，而方法可以是利用soql语言查找到某一记录的主码，这里是Id（使用rest服务请求获取到uri后从uri中取得的id）
HttpDelete步骤：
1、创建ResrRequest对象req
2、声明caseId，并将rest请求到的uri截取/后的值赋给该变量
3、利用soql语句查到Id = :caseId的那条记录
4、删除该记录
*/
@HttpPut
global static ID upsertCase(String id, String subject, String status, String origin, String priority) {
Case thisCase = new Case(
Id = id,
Subject = subject,
Status = status,
Origin = origin,
Priority = priority
);
upsert thisCase;
return thisCase.Id;
}
/*
HttpPut步骤：
1、声明并创建一个Case类型对象thisCase，并为该对象定义标准字段赋值
2、将自定义对象插入到Case表中形成一条记录或者更新Id为id的记录
3、返回一个新纪录的类型为ID的变量Id用于查找新纪录
*/
@HttpPatch
global static ID updateCaseFields() {
RestRequest req = RestContext.request;
String caseId = req.requestURI.substring(req.requestURI.lastIndexOf('/')+1);
Case thisCase = [SELECT Id FROM Case WHERE Id = :caseId];
Map<String, Object> params = (Map<String, Object>)JSON.deserializeUntyped(req.requestBody.toString());
for(String fieldName : params.keySet()) {
thisCase.put(fieldName, params.get(fieldName));
}
update thisCase;
return thisCase.Id;
}
/*
HttpPatch步骤：
1、创建RestRequest类型的req对象(RestContext.request的返回值类型就是RestRequest)
2、通过req对象的requestURI属性利用字符串检索技术拿到caseId
3、创建Case对象，并把按Id查到的Case表记录赋值给该对象
4、将请求获得的requestBody转化成字符串后，反序列化为对象强制转化为Map<String, Object>后赋值给Map变量params
5、遍历对象的key，并在通过id找到的Case对象thisCase中写入key-value
6、更新记录
7、返回记录的id
*/
}
/*
共性：
1、每个对象系统自带一个Id属性，它是系统自动分配的；
2、每一种Http方法均为global static
3、@HttpPut与@HttpPost的区别（upsert，insert）
*/

<apex:page>
<!-- Add the static resource to page's <head> -->
<apex:includeScript value="{! $Resource.jQuery }"/>
<!-- A short bit of jQuery to test it's there -->
<script type="text/javascript">
jQuery.noConflict();
jQuery(document).ready(function() {
jQuery("#message").html("Hello from jQuery!");
});
</script>
<!-- Where the jQuery message will appear -->
<h1 id="message"></h1>
</apex:page>

<apex:page standardController="Contact" recordSetVar="contacts">
<apex:pageBlock title="Contact List">
<apex:repeat value="{!contacts}" var="ct">
<li>
<apex:outputLink value="/{!ct.Id}">{!ct.Name}</apex:outputLink>
<!-- <apex:outputLink value="{!URLFOR($Action.Contact.View,ct.id,[retURL=''])}">{!ct.Name}</apex:outputLink> -->
<!-- <apex:outputLink value="https://componentstest-dev-ed.my.salesforce.com/{!ct.Id}">{!ct.Name}</apex:outputLink>  -->
</li>
</apex:repeat> 
</apex:pageBlock>
</apex:page> 

<apex:page docType="html-5.0" sidebar="false" showHeader="false" standardStylesheets="false" 
action="{!URLFOR($Resource.ShangpinhuiZip, 'shangpinhui/index.html')}">
</apex:page>