public with sharing class CM_SearchContactServiceController { public Contact newCon { get; set; } public Contact searchCon { get; set; } public List lineInfoList { get; set; } public String conId { get; set; } public String openLine { get; set; } private String accountId; private String nowValue; public String staticResource {get; set;} public String contactAWSIds {set;get;} public String contactsInfo {set;get;} public String awsDataIdArray {set;get;} public CM_SearchContactServiceController() { openLine = Apexpages.currentPage().getParameters().get('line'); accountId = Apexpages.currentPage().getParameters().get('acc'); nowValue = Apexpages.currentPage().getParameters().get('now'); //2022/02/15 张华建 PI PL start //1. Query Contact by accountId List conList = new List(); system.debug('Account Id from Front-end:'+accountId); if(String.isNotBlank(accountId) && String.isNotEmpty(accountId)){ conList = new List([select Id,AWS_Data_Id__c from Contact where AccountId=:accountId and AWS_Data_Id__c!='' limit 500]); } //2. Prepare the Contact Info Map awsIdToContactMap = new Map(); List conAWSIds = new List(); for(Contact con:conList){ conAWSIds.add(con.AWS_Data_Id__c); awsIdToContactMap.put(con.AWS_Data_Id__c,con); } //conAWSIds.add('943114607025717249'); contactsInfo = JSON.serialize(awsIdToContactMap); contactAWSIds = JSON.serialize(conAWSIds); staticResource = JSON.serialize(PIHelper.getPIIntegrationInfo('Contact')); //2022/02/15 张华建 PI PL end } public void init() { searchCon = new Contact(); if (nowValue != null && nowValue != '') { searchCon = [select Id, Name, Department__c, Type__c, Search_LastName__c, Search_FirstName__c, Phone, Supplement__c, FirstName, LastName from Contact where Id = :nowValue]; searchCon.Search_LastName__c = searchCon.LastName; searchCon.Search_FirstName__c = searchCon.FirstName; } searchContact(); newCon = new Contact(); newCon.AccountId = accountId; return; } public PageReference searchContact() { String searchStr = 'select Id, Name, Department__c, Type__c, AccountName__c, Supplement__c, Phone,AWS_Data_Id__c '; searchStr += ', City__c , State__c '; //2018/11/19 HWAG-B399RW 读取省和市 searchStr += ' from Contact '; searchStr += ' where Isactive__c = \'有效\' and AWS_Data_Id__c!=\'\' '; searchStr += ' and AccountId = :accountId '; //2022/02/15 张华建 检索 start // if (searchCon.Search_LastName__c != null && searchCon.Search_LastName__c != '') { // searchStr += ' and LastName like \'%' + searchCon.Search_LastName__c + '%\''; // } // if (searchCon.Search_FirstName__c != null && searchCon.Search_FirstName__c != '') { // searchStr += ' and FirstName like \'%' + searchCon.Search_FirstName__c + '%\''; // } System.debug('awsDataIdArray = ' + awsDataIdArray); if (awsDataIdArray != null && awsDataIdArray != '') { String[] arr = awsDataIdArray.split(','); System.debug('arr = ' + arr); String awsDataIdSql = ''; for(String s : arr){ System.debug('s = ' + s); awsDataIdSql = awsDataIdSql + ',' + '\'' + s+'\''; } awsDataIdSql = awsDataIdSql.substring(1); System.debug('awsDataIdSql = ' + awsDataIdSql); searchStr += ' and AWS_Data_Id__c in (' + awsDataIdSql + ')'; } //2022/02/15 张华建 检索 end system.debug('=====searchStr:' + searchStr); searchStr += 'limit 500'; List searchResult = Database.query(searchStr); lineInfoList = new List(); Integer line = 0; for (Contact con : searchResult) { line += 1; LineInfo li = new LineInfo(line, con); lineInfoList.add(li); } editClear(); return null; } public PageReference editContact() { if (conId != null && conId != '') { newCon = [select Id, Name, Department__c, Type__c, Search_LastName__c, Search_FirstName__c, Phone, Supplement__c,LastName_Encrypted__c,Phone_Encrypted__c, FirstName, LastName,AWS_Data_Id__c from Contact where Id = :conId]; newCon.Search_LastName__c = newCon.LastName; newCon.Search_FirstName__c = newCon.FirstName; } return null; } public PageReference saveNew() { if (newCon.Search_LastName__c == null || newCon.Search_LastName__c == '') { newCon.Search_LastName__c.addError('必须填写。'); return null; } newCon.LastName = newCon.Search_LastName__c; newCon.FirstName = newCon.Search_FirstName__c; upsert newCon; searchCon.Search_LastName__c = newCon.LastName; searchCon.Search_FirstName__c = newCon.FirstName; searchContact(); return null; } public PageReference editClear() { newCon = new Contact(); newCon.AccountId = accountId; return null; } public PageReference clearLineInfoList() { lineInfoList = new List(); return null; } class LineInfo { public Integer lineNo { get; set; } public Contact con { get; set; } public LineInfo(Integer in_line) { lineNo = in_line; con = new Contact(); } public LineInfo(Integer in_line, Contact in_con) { lineNo = in_line; con = in_con; } } }