From 78ac43791ac9e9d75ce4c33e9dddbdffa88fec2f Mon Sep 17 00:00:00 2001 From: 涂煌豪 <tuhuanghao@prec-tech.com> Date: 星期一, 23 五月 2022 19:00:04 +0800 Subject: [PATCH] 客户人员重复判断 --- force-app/main/default/classes/NFM624Rest.cls | 422 ++++++++++++++++++++++++++++++---------------------- 1 files changed, 245 insertions(+), 177 deletions(-) diff --git a/force-app/main/default/classes/NFM624Rest.cls b/force-app/main/default/classes/NFM624Rest.cls index 254feb4..6af9655 100644 --- a/force-app/main/default/classes/NFM624Rest.cls +++ b/force-app/main/default/classes/NFM624Rest.cls @@ -7,9 +7,13 @@ } *************************************************************************/ - + @RestResource(urlMapping = '/NFM624/*') global with sharing class NFM624Rest { + //add to AWS 鍥炲 start sushanhu 20220225 + static Boolean SFStatus=true; + static String SFMessage=''; + //add to AWS 鍥炲 end sushanhu 20220225 private static final String LOG_TYPE = 'NFM624'; // global class GeDatasRest { // public GeDatas GeDatas; @@ -19,15 +23,17 @@ public NFMUtil.Monitoring Monitoring; public GeData[] GeData; } - + global class GeData { - public String ContactId; //缁熶竴骞冲彴ID + public String ContactId; //缁熶竴骞冲彴ID//Update to aws 瀛樺偍鐨凙WSContactId 20220225 SUSHANHU public String ServiceUserId; //鏈嶅姟骞冲彴鐢ㄦ埛ID public String PersonManagementCode; //浜哄憳绠$悊缂栫爜 public String HospitalManagementCode2; //鍖婚櫌骞冲彴缂栫爜 骞冲彴缂栫爜 PlatformCode__c public String DepartmentManagementCode2; //绉戝骞冲彴缂栫爜 骞冲彴缂栫爜 PlatformCode__c public String Name; //濮撳悕 + public String NameEncrypted;//濮撳悕瀵嗘枃 add 20220215 public String Mobile; //鎵嬫満鍙风爜 + public String MobileEncrypted;//鎵嬫満鍙风爜瀵嗘枃 add 20220215 public String State; //鍗曚綅鎵�鍦ㄧ渷浠� public String City; //甯� public String AccountName; //鍖婚櫌鍚� @@ -36,58 +42,72 @@ public String DepartmentName; //鎵�灞炵瀹� public String RelatedDepartment; //鍏宠仈SFDC绉戝 瀹㈡埛绠$悊缂栫爜(鎵嬪啓) AgentCode_Ext__c public String Type; //鑱岀 + public String TypeEncrypted;//鑱岀Hash add for pipl 20220316 sushanhu public String ContactAddress; //鑱旂郴鍦板潃 - public Boolean ForbiddenStatus; //骞冲彴鐢ㄦ埛绂佺敤鏍囪瘑 + public String ContactAddressEncrypted;//鑱旂郴鍦板潃瀵嗘枃 + public Boolean ForbiddenStatus; //骞冲彴鐢ㄦ埛绂佺敤鏍囪瘑 public String RegSource; //娉ㄥ唽骞冲彴鏉ユ簮 public Boolean AgentFlag; //缁忛攢鍟嗘爣璇� public String ApproverID; //瀹℃牳浜哄憳鍛樺伐缂栫爜 + public String DataId;//aws瀛樺偍鍑嵁 } - + @HttpPost global static void execute() { - + // 鍙栧緱鎺ュ彛浼犺緭鍐呭 String strData = RestContext.request.requestBody.toString(); GeDatas ges = (GeDatas) JSON.deserializeStrict(strData, GeDatas.class); - - + system.debug('ges---'+ges); + if (ges == null) { return; } - + NFMUtil.Monitoring Monitoring = ges.Monitoring; if (Monitoring == null) { return; } - + BatchIF_Log__c rowData = NFMUtil.saveRowData(Monitoring, LOG_TYPE, ges.GeData); system.debug('String.isBlank(rowData.Log__c) == false?'); if (String.isBlank(rowData.Log__c) == false) { System.debug('杩涘叆if鏂规硶锛屾垚鍔熻皟鐢╡xecutefuture'); executefuture(rowData.Id); } - + // JSON銈掓埢銇� RestResponse res = RestContext.response; res.addHeader('Content-Type', 'application/json'); res.statusCode = 200; - String jsonResponse = '{"status": "Success", "Message":""}'; - res.responseBody = blob.valueOf(jsonResponse); + // String jsonResponse = '{"status": "Success", "Message":""}'; + // res.responseBody = blob.valueOf(jsonResponse); + //updata response toAWS 20220225 sushanhu start + NFMUtil.NFMResponse result = NFMUtil.getNFMResponse(); + result.SFStatus=SFStatus; + result.SFMessage=SFMessage; + String jsonResponse =JSON.serialize(result); + system.debug('result---'+jsonResponse); + res.responseBody = blob.valueOf(jsonResponse); + //updata response toAWS 20220225 sushanhu end return; } - - + + @future global static void executefuture(String rowData_Id) { system.debug('杩涘叆executefuture鏂规硶' + rowData_Id); main(rowData_Id); } - + global static void main(String rowData_Id) { - // Map<String,String> RecordTypeMap = new Map<String,String>(); // RecordTypeMap.put('','') +//List<RecordType> rectDpt = [select Id from RecordType where IsActive = true and SobjectType = 'Account' and DeveloperName IN ('Department_OTH','Department_GI', 'Department_BF','Department_GYN','Department_GS','Department_URO','Department_ENT','Department_Class_ET') order by DeveloperName desc]; Map < string, string > RecordTypeMap = new Map < string, string > (); //瀛樻斁璁板綍绫诲瀷Id + //for(ID temp : rectDpt){ + // + //} RecordTypeMap.put('鍛煎惛绉�', '01210000000QfmR'); RecordTypeMap.put('鍏朵粬', '01210000000Qfmb'); RecordTypeMap.put('濡囩', '01210000000QfmM'); @@ -105,7 +125,7 @@ iflog.Log__c = logstr; iflog.ErrorLog__c = ''; insert iflog; - + String rowDataStr = NFMUtil.getRowDataStr(rowData); List < GeData > GeDataList = (List < GeData > ) JSON.deserialize(rowDataStr, List < GeData > .class); if (GeDataList == null || GeDataList.size() == 0) { @@ -119,7 +139,7 @@ // continue; // } // } - + Savepoint sp = Database.setSavepoint(); List<string> ApproverIDList = new List <string>();// List < string > PersonManagementCodeList = new List < String > (); //浜哄憳绠$悊缂栫爜List @@ -127,21 +147,28 @@ List < String > ManagementList = new List < String > (); //鍖婚櫌銆佺瀹ゅ钩鍙扮紪鐮丩ist List < String > StateList = new List < String > (); List < String > CityList = new List < String > (); + List < String > NameList = new List < String >(); try { //鏍规嵁浼犺繃鏉ョ殑绠$悊缂栫爜鏌ヨ濡傛灉鍙互鏌ヨ寰楀埌缁撴灉鍒欐洿鏂帮紝鏌ヨ涓嶅埌鍒欐柊澧� List < Gedata > newGeDataList = new List < Gedata > (); for (Gedata gedata: GeDataList) { string dataComplete = verify(gedata); + if (!String.isBlank(dataComplete)) { logstr += dataComplete; rowData.Is_Error__c = 1; + rowData.retry_cnt__c = 0; continue; } if (!gedata.AgentFlag) { StateList.add(gedata.State); CityList.add(gedata.City); ApproverIDList.add(gedata.ApproverID); - ManagementList.add(gedata.HospitalManagementCode2); - ManagementList.add(gedata.DepartmentManagementCode2); + if(string.isnotblank(gedata.HospitalManagementCode2)){ + ManagementList.add(gedata.HospitalManagementCode2); + } + if(string.isnotblank(gedata.DepartmentManagementCode2)){ + ManagementList.add(gedata.DepartmentManagementCode2); + } //system.debug('AccountCodeList'+AccountCodeList); if (string.isnotblank(gedata.RelatedHospital)) { SFDCCodeList.add(gedata.RelatedHospital); @@ -152,6 +179,9 @@ } if (string.isnotblank(gedata.PersonManagementCode)) { PersonManagementCodeList.add(gedata.PersonManagementCode); + } + if(String.isnotBlank(gedata.NameEncrypted)){ + NameList.add(gedata.NameEncrypted); } newGeDataList.add(gedata); System.debug('ManagementList'+ManagementList); @@ -171,53 +201,73 @@ for (Address_Level2__c temp: citytempList) { CityMap.put(temp.Name, temp.Id); } - + //鏌ヨ鍖婚櫌鎵�鏈変汉 Map<string,String> ownerMap = new Map<string,String>(); List<User> ownerList = [select Id,Employee_No__c from User where Employee_No__c IN:ApproverIDList]; for(User temp : ownerList){ ownerMap.put(temp.Employee_No__c,temp.Id); } - + //鏌ヨOCSM钀ヤ笟绐楀彛 Map<string,Id> OCSMMap = new Map<string,Id>(); List<OCM_Management_Province__c> OCSMList = [select Id,Name,Window1__c from OCM_Management_Province__c]; for(OCM_Management_Province__c ocsm : OCSMList){ OCSMMap.put(ocsm.name,ocsm.Window1__c); } - + //鏌ヨ鑱旂郴浜� Map < String, Map < String, Contact >> nameMap = new Map < String, Map < String, Contact >> (); //澶栧眰鎴樼暐绉戝锛屽唴灞傜瀹ゅ悕+鑱旂郴浜哄悕 List < Contact > peopleList = [select Id, - Account.Name, + Account.Name, Department__c, + UnifiedI_Contact_ID__c, Account.parent.Name, Account.PlatformCode__c, Account.Management_Code__c, Account.parent.Department_Class_Label__c, - Name, + Name,LastName_Encrypted__c, Account.Parent_Management_Code__c, Account.Parent_PlatformCode__c, CManageCode__c, - AccountId + AccountId, + // 閫氳繃濮撳悕+鎵嬫満鍙峰垽鏂汉鍛樻槸鍚﹂噸澶� thh 20220518 start + MobilePhone_Encrypted__c + // 閫氳繃濮撳悕+鎵嬫満鍙峰垽鏂汉鍛樻槸鍚﹂噸澶� thh 20220518 end from Contact where CManageCode__c IN: PersonManagementCodeList - OR Account.Parent_PlatformCode__c IN: ManagementList - OR Account.Parent_Management_Code__c IN: SFDCCodeList]; //鏍规嵁浜哄憳绠$悊缂栫爜妫�绱㈣仈绯讳汉 + OR (Account.Parent_PlatformCode__c IN: ManagementList AND LastName_Encrypted__c IN:NameList) + OR (Account.Parent_Management_Code__c IN: SFDCCodeList AND LastName_Encrypted__c IN:NameList ) + ORDER BY MobilePhone ASC,CManageCode__c ASC]; //鏍规嵁浜哄憳绠$悊缂栫爜妫�绱㈣仈绯讳汉 Map < String, Contact > peopleMap = new Map < String, Contact > (); //鑱旂郴浜� system.debug('peopleList '+peopleList); for (Contact ct: peopleList) { if (string.isnotblank(ct.Account.parent.Name)) { Map < String, Contact > snameMap = new Map < String, Contact > (); - string Name = ct.Name.replaceAll(' ',''); - string namekey = ct.Account.Name + ' ' + Name; + string namekey; + string nameKey2; + if(String.isBlank(ct.MobilePhone_Encrypted__c)){ + namekey = ct.Account.Name + ' ' + ct.LastName_Encrypted__c.trim(); + nameKey2 = ct.Account.Management_Code__c + ' ' + ct.LastName_Encrypted__c.trim(); + } else{ + namekey = ct.Account.Name + ' ' + ct.LastName_Encrypted__c.trim() + ' ' + ct.MobilePhone_Encrypted__c.trim(); + nameKey2 = ct.Account.Management_Code__c + ' ' + ct.LastName_Encrypted__c.trim() + ' ' + ct.MobilePhone_Encrypted__c.trim(); + } // snameMap.put(namekey,ct); if (nameMap.containsKey(ct.Account.parent.Name)) { snameMap = nameMap.get(ct.Account.parent.Name); } snameMap.put(namekey, ct); - snameMap.put(ct.Name, ct); + snameMap.put(nameKey2,ct); + // // 閫氳繃濮撳悕+鎵嬫満鍙峰垽鏂汉鍛樻槸鍚﹂噸澶� thh 20220518 start + // if(String.isBlank(ct.MobilePhone_Encrypted__c)){ + // snameMap.put(ct.LastName_Encrypted__c.trim(), ct); + // } else{ + // snameMap.put(ct.LastName_Encrypted__c.trim() + ct.MobilePhone_Encrypted__c.trim(), ct); + // } + // // 閫氳繃濮撳悕+鎵嬫満鍙峰垽鏂汉鍛樻槸鍚﹂噸澶� thh 20220518 end nameMap.put(ct.Account.parent.Name, snameMap); + system.debug('snameMap'+snameMap); } peopleMap.put(ct.CManageCode__c, ct); System.debug('peopleMap'+peopleMap); @@ -225,7 +275,7 @@ //string temp = ct.Name + ct.Account.parent.Department_Class_Label__c; // peopleMap.put(temp, ct); } - + //鏌ヨ鍖婚櫌绉戝 //List<Account> AccountList = [select Id,PlatformCode__c,PlatformCode__c,Department_Class_Label__c,Name,Management_Code__c,Is_Active__c,AgentCode_Ext__c,ParentId,Parent.ParentId from Account where PlatformCode__c IN :HpCodeList OR parent.PlatformCode__c IN :HpCodeList OR PlatformCode__c IN :HpCodeList OR Management_Code__c IN :RelatedHospitalList OR Parent_Management_Code__c IN :RelatedHospitalList]; //List < Account > AccountList = [select Id, PlatformCode__c, Department_Class_Label__c, Name, Management_Code__c, Is_Active__c, AgentCode_Ext__c, ParentId, Parent.ParentId from Account where Management_Code__c IN :AccountCodeList OR Parent_Management_Code__c IN :AccountCodeList OR PlatformCode__c IN :AccountCodeList OR Parent.Parent.PlatformCode__c IN :AccountCodeList]; @@ -255,47 +305,63 @@ } system.debug('AccountMap '+AccountMap); System.debug('DepartmentClassMap '+DepartmentClassMap); - - + + //瀹㈡埛List锛堟洿鏂扮敤锛� List < Account > upsertAccountList = new List < Account > (); //鑱旂郴浜篖ist锛堟洿鏂扮敤锛� List < Contact > upsertContactList = new List < Contact > (); - + for (Gedata gedata: newGeDataList) { logstr += gedata.Name; logstr += gedata.AccountName; logstr += gedata.DepartmentClass; logstr += gedata.DepartmentName; - - - string comefrom = gedata.RegSource == '1' ? '鏅烘収鍖荤枟' : '鏈嶅姟瀹㈡埛绔�'; //骞冲彴鏉ユ簮 - + + + string comefrom = gedata.RegSource == '1' ? '鏅烘収鍖荤枟' : (gedata.RegSource == '2' ? '鏈嶅姟瀹㈡埛绔�' :'鍖绘嫇缃�'); //骞冲彴鏉ユ簮 + //鏂板缓鍖婚櫌 Account hp = new Account(); - + //鏂板缓鑱旂郴浜� Contact ct = new Contact(); - ct.LastName = gedata.Name; - ct.FirstName = ''; - ct.Type__c = gedata.Type; - ct.MobilePhone = gedata.Mobile; - ct.RegSource__c = comefrom; - ct.UnifiedI_Contact_ID__c = gedata.ContactId; //缁熶竴骞冲彴Id - ct.ServicePlatformCode__c = gedata.ServiceUserId; //鏈嶅姟骞冲彴鐢ㄦ埛Id - ct.Contact_address__c = gedata.ContactAddress;//鑱旂郴鍦板潃 - ct.Platform_disabled_representation__c = gedata.ForbiddenStatus;//骞冲彴绂佺敤鏍囪瘑 - //ct.IsFromPlatform__c = true; //鏉ヨ嚜鏅烘収鍖荤枟鍒涘缓 - ct.Ignore_Same_Name__c = true; //涓嶆槸閲嶅鐨勫鎴峰悕 - //ct.SendToComPlat__c = true; - + if(gedata.AgentFlag){ + //ct.FirstName = ''; 2022-4-7 yjk 娉ㄩ噴鎺� + ct.UnifiedI_Contact_ID__c = gedata.ContactId; //缁熶竴骞冲彴Id + ct.ServicePlatformCode__c = gedata.ServiceUserId; //鏈嶅姟骞冲彴鐢ㄦ埛Id + //ct.CManageCode__c = gedata.PersonManagementCode;//浜哄憳绠$悊缂栫爜 + }else{ + ct.LastName = gedata.Name; + ct.FirstName = ''; + ct.Type__c = gedata.Type; + ct.Type_Encrypted__c = gedata.TypeEncrypted;//add for pipl sushanhu 20220316 + ct.MobilePhone = gedata.Mobile; + ct.RegSource__c = comefrom; + ct.UnifiedI_Contact_ID__c = gedata.ContactId; //缁熶竴骞冲彴Id + // //UPDATE TO AWS 瀛樺偍鐨勭粺涓�骞冲彴id + // ct.AWS_UnifiedI_Contact_ID__c=gedata.ContactId; //缁熶竴骞冲彴Id + ct.ServicePlatformCode__c = gedata.ServiceUserId; //鏈嶅姟骞冲彴鐢ㄦ埛Id + ct.Contact_address__c = gedata.ContactAddress;//鑱旂郴鍦板潃 + ct.Contact_address_Encrypted__c=gedata.ContactAddressEncrypted;//鑱旂郴鍦板潃瀵嗘枃 add 20220215 + ct.Platform_disabled_representation__c = gedata.ForbiddenStatus;//骞冲彴绂佺敤鏍囪瘑 + //ct.IsFromPlatform__c = true; //鏉ヨ嚜鏅烘収鍖荤枟鍒涘缓 + ct.Ignore_Same_Name__c = true; //涓嶆槸閲嶅鐨勫鎴峰悕 + //ct.SendToComPlat__c = true; + ct.AWS_Data_Id__c =gedata.DataId;//add 20220215 aws瀛樺偍鍑瘉 + ct.MobilePhone_Encrypted__c =gedata.MobileEncrypted;//add 20220215 鎵嬫満瀵嗘枃 + ct.LastName_Encrypted__c =gedata.NameEncrypted;//add 20220215 濮撳悕瀵嗘枃 + } + + String personCode = gedata.PersonManagementCode; - + Map < String, Contact > contactMap = new Map < String, Contact > ();//鐢ㄤ簬鏆傚瓨鏇存柊鑱旂郴浜� //1缁忛攢鍟唗rue if (gedata.AgentFlag == true) { //鏇存柊缁忛攢鍟嗚仈绯讳汉 if (!peopleMap.containsKey(personCode)) { + rowData.Is_Error__c = 1; logstr += 'error:浜哄憳绠$悊缂栫爜 [PersonManagementCode] 瀵瑰簲鐨勮仈绯讳汉涓嶅瓨鍦紝姝ゆ潯鏁版嵁璺宠繃'; continue; } @@ -316,6 +382,7 @@ if ('鏈夋晥'.equals(hospital.Is_Active_Formula__c)) { string DepartmentCode = string.isNotBlank(gedata.RelatedDepartment) ? gedata.RelatedDepartment : gedata.DepartmentManagementCode2; string DepartmentClasskey = gedata.AccountName + ' ' + gedata.DepartmentClass; + system.debug('DepartmentClasskey------->'+DepartmentClasskey); //绉戝瀛樺湪 if (AccountMap.containsKey(DepartmentCode)) { //浜哄憳绠$悊缂栫爜瀛樺湪 @@ -331,21 +398,33 @@ upsertContactList.add(ct); } else { //鑱旂郴浜轰笉瀛樺湪 2 瀹屾垚 system.debug('2閫昏緫 鏈夊尰闄� 鏈夌瀹� 鏈変汉鍛樼鐞嗙紪鐮佷絾鏌ユ壘鏃犳浜� 鍔ㄤ綔锛氭姤閿�'); + rowData.Is_Error__c = 1; logstr += 'error:浜哄憳绠$悊缂栫爜 [PersonManagementCode] 瀵瑰簲鐨勮仈绯讳汉涓嶅瓨鍦紝姝ゆ潯鏁版嵁璺宠繃'; continue; } } else { //浜哄憳绠$悊缂栫爜涓嶅瓨鍦� //鎼滅储浜哄悕/涓斿湪褰撳墠鎴樼暐绉戝绉戝涓� System.debug('浜哄憳绠$悊缂栫爜涓嶅瓨鍦�'); - string namekey = gedata.Name; + string namekey = gedata.RelatedDepartment + ' ' + gedata.NameEncrypted + ' ' + gedata.MobileEncrypted; + string namekey1 = gedata.RelatedDepartment + ' ' + gedata.NameEncrypted; system.debug('DepartmentClasskey = '+DepartmentClasskey); system.debug('nameMap22222222 '+nameMap); if (nameMap.containskey(DepartmentClasskey)) { // 6 瀹屾垚 鏇存柊鎿嶄綔 Map < String, Contact > sMap = nameMap.get(DepartmentClasskey); + System.debug('sMap'+sMap); + System.debug('sMap.containsKey(namekey)'+sMap.containsKey(namekey)); + System.debug('sMap.containsKey(gedata.NameEncrypted)'+sMap.containsKey(gedata.NameEncrypted)); if (sMap.containsKey(namekey)) { system.debug('Id璧嬪��'+sMap); ct.id = sMap.get(namekey).id; - } else { // 7 瀹屾垚 + } else if (sMap.containsKey(namekey1) && sMap.get(namekey1).UnifiedI_Contact_ID__c == null) { + ct.id = sMap.get(namekey1).id; + + // // 閫氳繃濮撳悕+鎵嬫満鍙峰垽鏂汉鍛樻槸鍚﹂噸澶� thh 20220518 start + // } else if(sMap.containsKey(gedata.NameEncrypted + gedata.MobileEncrypted) && sMap.get(gedata.NameEncrypted + gedata.MobileEncrypted).UnifiedI_Contact_ID__c == null){ + // ct.id = sMap.get(gedata.NameEncrypted + gedata.MobileEncrypted).id; + // // 閫氳繃濮撳悕+鎵嬫満鍙峰垽鏂汉鍛樻槸鍚﹂噸澶� thh 20220518 end + }else { // 7 瀹屾垚 system.debug('7閫昏緫 鏃犱汉鍛樼鐞嗙紪鐮� 鏈夊尰闄� 鏈夌瀹� 浜哄悕鏌ユ壘鏃� 鍔ㄤ綔锛氭柊寤鸿仈绯讳汉 '); } } @@ -371,12 +450,13 @@ //upsertContactList.add(ct); } else { //浜哄憳绠$悊缂栫爜鏌ユ壘鏃犲�� 4 瀹屾垚 system.debug('4閫昏緫'); + rowData.Is_Error__c = 1; logstr += 'error:浜哄憳绠$悊缂栫爜 [PersonManagementCode] 瀵瑰簲鐨勮仈绯讳汉涓嶅瓨鍦紝姝ゆ潯鏁版嵁璺宠繃'; continue; } } else { //浜哄憳绠$悊缂栫爜涓嶅瓨鍦� system.debug('浜哄憳绠$悊缂栫爜涓嶅瓨鍦�'); - string namekey = gedata.DepartmentName+ ' ' + gedata.Name; + string namekey = gedata.DepartmentName + ' ' + gedata.NameEncrypted + ' ' + gedata.MobileEncrypted; //string namekey = gedata.AccountName + ' ' + gedata.DepartmentName + ' ' + gedata.DepartmentClass + ' ' + gedata.Name; system.debug('DepartmentClasskey'+DepartmentClasskey); system.debug('351nameMap '+nameMap); @@ -384,23 +464,31 @@ System.debug('浜哄憳绠$悊缂栫爜涓嶅瓨鍦ㄧ殑鎯呭喌涓嬫垬鐣ョ瀹ゅ瓨鍦�'); system.debug('鎴樼暐绉戝瀛樺湪' + nameMap.get(DepartmentClasskey)); Map < String, Contact > sMap = nameMap.get(DepartmentClasskey); + system.debug('namekey'+namekey); + system.debug('sMap.containsKey(namekey)'+sMap.containsKey(namekey)); if (sMap.containsKey(namekey)) { //鏌ユ壘瀛樺湪 8 瀹屾垚 system.debug('8閫昏緫'); system.debug('璇ヨ仈绯讳汉瀛樺湪'); ct.id = sMap.get(namekey).id; - upsertAccountList.add(dpt); + //upsertAccountList.add(dpt);//鍙互娉ㄩ噴 upsertContactList.add(ct); // if(sMap.containsKey(gedata.Name)){ // ct.Id = sMap.get(gedata.Name).Id; // } - }else if(sMap.containsKey(gedata.Name)){ - system.debug('1234567890'); - ct.Id = sMap.get(gedata.Name).Id; - //upsertAccountList.add(dpt); } + // 閫氳繃濮撳悕+鎵嬫満鍙峰垽鏂汉鍛樻槸鍚﹂噸澶� thh 20220518 start + // else if(sMap.containsKey(gedata.NameEncrypted + gedata.MobileEncrypted) && sMap.get(gedata.NameEncrypted + gedata.MobileEncrypted).UnifiedI_Contact_ID__c == null){ + // system.debug('1234567890'); + // ct.Id = sMap.get(gedata.NameEncrypted + gedata.MobileEncrypted).Id; + // //upsertAccountList.add(dpt); + // upsertContactList.add(ct); + // } + // 閫氳繃濮撳悕+鎵嬫満鍙峰垽鏂汉鍛樻槸鍚﹂噸澶� thh 20220518 end system.debug('contactMap ' + contactMap); System.debug('9閫昏緫'); contactMap.put(Gedata.DepartmentManagementCode2, ct); + system.debug('contactMap ' + contactMap); + //upsertContactList.add(ct); } system.debug('鍒涘缓鑱旂郴浜哄拰绉戝'); dpt.Department_Name__c = gedata.DepartmentName; @@ -409,6 +497,7 @@ } } }else if('鏃犳晥'.equals(hospital.Is_Active_Formula__c)){ + rowData.Is_Error__c = 1; logstr += 'error:璇ュ尰闄㈡棤鏁堬紝姝ゆ潯鏁版嵁璺宠繃'; continue; }else{ @@ -440,10 +529,16 @@ StaticParameter.EscapeNFM001AgencyContractTrigger2 = true; system.debug('upsertAccountList ' + upsertAccountList); upsert upsertAccountList; + system.debug('SFDCCodeList'+SFDCCodeList); + system.debug('SFDCCodeList'+ManagementList); List < Account > List1 = [select Id,RecordTypeId,Is_Active__c,PlatformCode__c,OCM_man_province_HP__c,OwnerId from Account where PlatformCode__c In: SFDCCodeList OR PlatformCode__c IN: ManagementList];//瀹㈡埛鎵�鏈変汉淇敼11.18 11.35 鏈畬鎴� + system.debug('List1'+List1); List<Account> updateHPList = new List<Account>(); for (Account ac: List1) { Contact c = new contact(); + system.debug('ac.PlatformCode__c'+ac.PlatformCode__c); + system.debug('ContactMap'+ContactMap); + system.debug('ContactMap.containsKey(ac.PlatformCode__c)'+ContactMap.containsKey(ac.PlatformCode__c)); if(ContactMap.containsKey(ac.PlatformCode__c)){ c = contactMap.get(ac.PlatformCode__c); if(string.isblank(c.Id)|| c.AccountId != ac.Id){ @@ -454,7 +549,7 @@ system.debug('OwnerId'+ac.OwnerId); system.debug('upsertContactList'+upsertContactList); } - + if(ac.RecordTypeId == '01210000000QemGAAS' && ac.Is_Active__c == '鑽夋涓�' && string.isNotBlank( OCSMMap.get(ac.OCM_man_province_HP__c))){ ac.OwnerId = OCSMMap.get(ac.OCM_man_province_HP__c); updateHPList.add(ac); @@ -473,7 +568,7 @@ //2022/2/10 淇敼 鍦ㄦ柊寤鸿仈绯讳汉涔嬪悗鎵嬪姩鎵цNFM620RestBatch NFM623RestBatch // Database.executeBatch(new NFM620RestBatch(), 1); // Database.executeBatch(new NFM623RestBatch(), 1); - // supplement(gedata.ContactId); + supplement(gedata.ContactId); } } } @@ -506,34 +601,37 @@ } update iflog; } - + private static String verify(GeData gda) { String result = ''; - if (string.isblank(gda.ContactId)) { - result += 'DataError: ContactId 缁熶竴骞冲彴ID涓虹┖\n'; - } - if (gda.AgentFlag == null) { - result += 'DataError:缁忛攢鍟嗘爣璇嗕负绌篭n'; - } - if (string.isblank(gda.Name)) { - result += 'DataError锛氬鍚嶄负绌篭n'; - } - if (string.isblank(gda.Mobile)) { - result += 'DataError锛氭墜鏈哄彿涓虹┖\n'; - } - if (string.isblank(gda.RegSource)) { - result += 'DataError锛氭敞鍐屽钩鍙版潵婧愪负绌篭n'; - } if (gda.AgentFlag) { + if (string.isblank(gda.ContactId)) { + result += 'DataError: ContactId 缁熶竴骞冲彴ID涓虹┖\n'; + } if (string.isblank(gda.PersonManagementCode)) { result += 'DataError锛歅ersonManagementCode 浜哄憳绠$悊缂栫爜涓虹┖\n'; } - } else { - // if (string.isnotblank(gda.PersonManagementCode) && string.isBlank(gda.RelatedHospital)) { - // result += 'DataError: 鍏宠仈鍖婚櫌缂栫爜涓虹┖\n'; - // } - if(string.isBlank(gda.RelatedDepartment) && String.isBlank(gda.ApproverID)){ - result += 'DataError: 鍦ㄥ叧鑱擲FDC绉戝[RelatedDepartment]涓虹┖鏃讹紝瀹℃牳浜哄憳鍛樺伐缂栫爜[ApproverID]蹇呭~\n'; + if (string.isblank(gda.ServiceUserId)) { + result += 'ServiceUserId 鏈嶅姟骞冲彴鐢ㄦ埛Id涓虹┖\n'; + } + }else{ + if (string.isblank(gda.ContactId)) { + result += 'DataError: ContactId 缁熶竴骞冲彴ID涓虹┖\n'; + } + if (gda.AgentFlag == null) { + result += 'DataError:缁忛攢鍟嗘爣璇嗕负绌篭n'; + } + if (string.isblank(gda.Name)) { + result += 'DataError锛氬鍚嶄负绌篭n'; + } + if (string.isblank(gda.Mobile)) { + result += 'DataError锛氭墜鏈哄彿涓虹┖\n'; + } + if (string.isblank(gda.RegSource)) { + result += 'DataError锛氭敞鍐屽钩鍙版潵婧愪负绌篭n'; + } + if(string.isBlank(gda.RelatedHospital) && String.isBlank(gda.HospitalManagementCode2) && String.isBlank(gda.ApproverID)){ + result += 'DataError: 鏂板缓鍖婚櫌鏃讹紝瀹℃牳浜哄憳鍛樺伐缂栫爜[ApproverID]蹇呭~\n'; } if (string.isblank(gda.HospitalManagementCode2)) { result += 'DataError锛氬尰闄㈠钩鍙扮紪鐮佷负绌篭n'; @@ -559,59 +657,12 @@ } return result; } - // global static String contactAllName(String contactName){ - // // 涓浗 澶嶅澶у叏 - // String CompoundSurname = '婵槼銆佸叕鍐躲�佸お鍙斻�佺敵灞犮�佸叕瀛欍�佹厱瀹广�佷徊瀛欍�侀挓绂汇�侀暱瀛欍�佸畤鏂囥�佸徃寰掋�侀矞浜庛�佸徃绌恒�侀椌涓樸�佸瓙杞︺�佷簱瀹樸�佸徃瀵囥�佸帆椹�佸叕瑗裤�侀瀛欍�佸¥椹枫�佸叕鑹�佹紗闆曘�佷箰姝c�佸鐖躲�佽胺姊併�佹嫇璺嬨�佸す璋枫�佽僵杈曘�佷护鐙愩�佹骞层�佺櫨閲屻�佸懠寤躲�佷笢閮�佸崡闂ㄣ�佺緤鑸屻�佸井鐢熴�佸叕鎴枫�佸叕鐜夈�佸叕浠�佹涓樸�佸叕浠层�佸叕涓娿�佸叕闂ㄣ�佸叕灞便�佸叕鍧氥�佸乏涓樸�佸叕浼�佽タ闂ㄣ�佸叕绁栥�佺浜斻�佸叕涔樸�佽疮涓樸�佸叕鐨欍�佸崡鑽c�佷笢閲屻�佷笢瀹�佷徊闀裤�佸瓙涔︺�佸瓙妗戙�佸嵆澧ㄣ�佽揪濂氥�佽甯堛�佸惔閾�'; - // // string allname = '鏈卞惎璐�'; - // // contactName = '绗簲鎯嗘��'; - // String lastName = ''; - // String firstName = ''; - // String result = ''; - // if (contactName.contains('路')) { - // lastName = contactName.split('路')[0]; - // firstName = contactName.split('路')[1]; - // } else { - // if (contactName.length() > 2) { - - // system.debug('CompoundSurname--->01' + contactName.subString(0, 2)); - // if (CompoundSurname.contains(contactName.subString(0, 2))) { - // lastName = contactName.substring(0,2); - // firstName = contactName.substring(2,contactName.length()); - // system.debug('lastName--->'+lastName); - // system.debug('firstName--->'+firstName); - // } else { - // lastName = contactName.substring(0,1); - // firstName = contactName.substring(1,contactName.length()); - // system.debug('lastName--->'+lastName); - // system.debug('firstName--->'+firstName); - // } - // } else { - // if (contactName.length() == 2) { - // lastName = contactName.substring(0,1); - // firstName = contactName.substring(1,contactName.length()); - // system.debug('lastName--->'+lastName); - // system.debug('firstName--->'+firstName); - // } else { - // lastName = contactName; - // firstName = contactName; - // system.debug('lastName--->'+lastName); - // system.debug('firstName--->'+firstName); - // } - // } - // } - // if (!contactName.equals(lastName+firstName)) { - // lastName = contactName; - // firstName = contactName; - // } - // result = lastName + '_' + firstName; - // //system.debug('CompoundSurname--->02' + CompoundSurname); - // return result; - // } - + private static void supplement (String ContactId){ //鎶�620Batch 鍜� 623Batch 鎼繃鏉� //琛ュ厖璇㈤棶鍗曢儴鍒� start //鏇存柊鐢� + List<CampaignMember__c> campaignMemberList = new List<CampaignMember__c>(); List<Inquiry_form__c> inquiryFormList = new List<Inquiry_form__c>(); //鏍规嵁缁熶竴鐢ㄦ埛Id鏌ヨ璇㈤棶鍗� List<Inquiry_form__c> InquiryList = [select Id,Inquiry_No__c,ContactId__c,Hospital_Name__c,Department_Class__c,Contact_Name__c from Inquiry_form__c where ContactId__c = :ContactId]; @@ -619,54 +670,71 @@ //鏍规嵁缁熶竴鐢ㄦ埛Id鏌ヨ鑱旂郴浜� List<Contact> contactList = [select Id,Name,UnifiedI_Contact_ID__c,Account.Id,Strategic_dept_Class__c,AccountId,Account.Name,Strategic_dept_Class__r.OwnerId from Contact where UnifiedI_Contact_ID__c = :ContactId]; system.debug('contactList' + contactList); - //缁熶竴鐢ㄦ埛ID瀛樺叆List銆佽闂崟ID瀛楳ap - Map<String, String> inquiryMap = new Map<String, String>(); - //List<String> contactIdList = new List<String>(); - for (Inquiry_form__c inquiryInfo : inquiryList) { - //contactIdList.add(inquiryInfo.ContactId__c); - inquiryMap.put(inquiryInfo.ContactId__c, inquiryInfo.Id); - } - if (contactList.size() >0 ) { - for (Contact contactInfo : contactList) { - Inquiry_form__c inquiry = new Inquiry_form__c(); - inquiry.Id = inquiryMap.get(contactInfo.UnifiedI_Contact_ID__c); //ID - inquiry.Hospital_Name__c = contactInfo.Account.Id; //绉戝鍚� - inquiry.Department_Class__c = contactInfo.Strategic_dept_Class__c; //鎴樼暐绉戝鍒嗙被 - inquiry.Contact_Name__c = contactInfo.Id; //瀹㈡埛濮撳悕 - inquiry.OwnerId = contactInfo.Strategic_dept_Class__r.OwnerId; //鎵�鏈変汉 - inquiryFormList.add(inquiry); + + if(InquiryList.size()>0){ + //缁熶竴鐢ㄦ埛ID瀛樺叆List銆佽闂崟ID瀛楳ap + Map<String, String> inquiryMap = new Map<String, String>(); + //List<String> contactIdList = new List<String>(); + for (Inquiry_form__c inquiryInfo : inquiryList) { + //contactIdList.add(inquiryInfo.ContactId__c); + // map鐨刱-v鏀归�� thh 20220517 start + inquiryMap.put(inquiryInfo.Id, inquiryInfo.ContactId__c); + // map鐨刱-v鏀归�� thh 20220517 end } - } - if(inquiryFormList.size()>0){ - update inquiryFormList; + // map鐨刱-v鏀归�� thh 20220517 start + if (contactList.size() >0 && inquiryMap.size() > 0) { + for(String Id : inquiryMap.keySet()){ + Inquiry_form__c inquiry = new Inquiry_form__c(); + for (Contact contactInfo : contactList) { + if(inquiryMap.get(Id) == contactInfo.UnifiedI_Contact_ID__c){ + inquiry.Id = Id; //ID + inquiry.Hospital_Name__c = contactInfo.Account.Id; //绉戝鍚� + inquiry.Department_Class__c = contactInfo.Strategic_dept_Class__c; //鎴樼暐绉戝鍒嗙被 + inquiry.Contact_Name__c = contactInfo.Id; //瀹㈡埛濮撳悕 + inquiry.OwnerId = contactInfo.Strategic_dept_Class__r.OwnerId; //鎵�鏈変汉 + inquiryFormList.add(inquiry); + } + } + } + } + // map鐨刱-v鏀归�� thh 20220517 end + system.debug('inquiryFormList=========>'+inquiryFormList); + if(inquiryFormList.size()>0){ + update inquiryFormList; + } } //琛ュ厖璇㈤棶鍗曢儴鍒� end //琛ュ厖瀛︿細閮ㄥ垎 start - List<CampaignMember__c> campaignMemberList = new List<CampaignMember__c>(); + //List<CampaignMember__c> campaignMemberList = new List<CampaignMember__c>(); List<CampaignMember__c> capMemList = [select Id,Contact_ID__c,Campaign__c,Campaign__r.Num__c,ViewContactId__c from CampaignMember__c where Contact_ID__c = :ContactId]; - Map<String, String> capMemMap = new Map<String, String>(); - //缁熶竴鐢ㄦ埛ID瀛樺叆List,鍙備細浜哄憳璁板綍ID瀛樺叆MAP - //List<String> contactIdList = new List<String>(); - for (CampaignMember__c capMemInfo : capMemList) { - //contactIdList.add(capMemInfo.ViewContactId__c); - capMemMap.put(capMemInfo.ViewContactId__c,capMemInfo.Id); - } - //List<Contact> contactList = [select Id,Name,UnifiedI_Contact_ID__c,Account.Id,Strategic_dept_Class__c,AccountId,Account.Name,Strategic_dept_Class__r.OwnerId,Id from Contact where UnifiedI_Contact_ID__c = ContactId]; - if (contactList.size() > 0) { - for (Contact contactInfo : contactList) { - CampaignMember__c camMemberInfo = new CampaignMember__c(); - camMemberInfo.Id = capMemMap.get(contactInfo.UnifiedI_Contact_ID__c); - camMemberInfo.Contact_ID__c = contactInfo.ID; //鍙備細浜哄憳ID - camMemberInfo.Department_ID__c = contactInfo.AccountId; //鍖婚櫌绉戝 - camMemberInfo.Department__c = contactInfo.Account.Name; //鍖婚櫌绉戝锛堟枃鏈級 - camMemberInfo.Contact__c = contactInfo.Name; //瀹㈡埛浜哄憳濮撳悕 - campaignMemberList.add(camMemberInfo); + if(capMemList.size() > 0){ + system.debug('capMemList=================>'+capMemList); + Map<String, String> capMemMap = new Map<String, String>(); + //缁熶竴鐢ㄦ埛ID瀛樺叆List,鍙備細浜哄憳璁板綍ID瀛樺叆MAP + //List<String> contactIdList = new List<String>(); + for (CampaignMember__c capMemInfo : capMemList) { + //contactIdList.add(capMemInfo.ViewContactId__c); + capMemMap.put(capMemInfo.ViewContactId__c,capMemInfo.Id); } - - } - if (campaignMemberList.size() > 0) { - update campaignMemberList; + system.debug('capMemMap======>'+capMemMap); + //List<Contact> contactList = [select Id,Name,UnifiedI_Contact_ID__c,Account.Id,Strategic_dept_Class__c,AccountId,Account.Name,Strategic_dept_Class__r.OwnerId,Id from Contact where UnifiedI_Contact_ID__c = ContactId]; + if (contactList.size() > 0) { + for (Contact contactInfo : contactList) { + CampaignMember__c camMemberInfo = new CampaignMember__c(); + camMemberInfo.Id = capMemMap.get(contactInfo.UnifiedI_Contact_ID__c); + camMemberInfo.Contact_ID__c = contactInfo.Id; //鍙備細浜哄憳ID + camMemberInfo.Department_ID__c = contactInfo.AccountId; //鍖婚櫌绉戝 + camMemberInfo.Department__c = contactInfo.Account.Name; //鍖婚櫌绉戝锛堟枃鏈級 + camMemberInfo.Contact__c = contactInfo.Name; //瀹㈡埛浜哄憳濮撳悕 + campaignMemberList.add(camMemberInfo); + } + } + system.debug('campaignMemberList================>'+campaignMemberList); + if (campaignMemberList.size() > 0) { + System.debug('--------1-------'); + update campaignMemberList; + } } //琛ュ厖瀛︿細閮ㄥ垎 end } -- Gitblit v1.9.1