| | |
| | | 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<Contact> conList = new List<Contact>(); |
| | | system.debug('Account Id from Front-end:'+accountId); |
| | | if(String.isNotBlank(accountId) && String.isNotEmpty(accountId)){ |
| | | conList = new List<Contact>([select Id,AWS_Data_Id__c from Contact where AccountId=:accountId and AWS_Data_Id__c!='' limit 500]); |
| | | } |
| | | //2. Prepare the Contact Info |
| | | Map<String,Contact> awsIdToContactMap = new Map<String,Contact>(); |
| | | List<String> conAWSIds = new List<String>(); |
| | | 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() { |
| | |
| | | |
| | | |
| | | public PageReference searchContact() { |
| | | String searchStr = 'select Id, Name, Department__c, Type__c, AccountName__c, Supplement__c, Phone '; |
| | | 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 = \'有效\' '; |
| | | searchStr += ' where Isactive__c = \'有效\' and AWS_Data_Id__c!=\'\' '; |
| | | searchStr += ' and AccountId = :accountId '; |
| | | if (searchCon.Search_LastName__c != null && searchCon.Search_LastName__c != '') { |
| | | searchStr += ' and LastName like \'%' + searchCon.Search_LastName__c + '%\''; |
| | | |
| | | //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 + ')'; |
| | | } |
| | | if (searchCon.Search_FirstName__c != null && searchCon.Search_FirstName__c != '') { |
| | | searchStr += ' and FirstName like \'%' + searchCon.Search_FirstName__c + '%\''; |
| | | } |
| | | //2022/02/15 张华建 检索 end |
| | | |
| | | system.debug('=====searchStr:' + searchStr); |
| | | |
| | | searchStr += 'limit 500'; |
| | | |
| | | List<Contact> searchResult = Database.query(searchStr); |
| | | |
| | |
| | | |
| | | public PageReference editContact() { |
| | | if (conId != null && conId != '') { |
| | | newCon = [select Id, Name, Department__c, Type__c, Search_LastName__c, Search_FirstName__c, Phone, Supplement__c, |
| | | FirstName, LastName |
| | | 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 clearLineInfoList() { |
| | | lineInfoList = new List<LineInfo>(); |
| | | return null; |
| | | } |
| | | |
| | | class LineInfo { |
| | | public Integer lineNo { get; set; } |
| | | public Contact con { get; set; } |