| | |
| | | } |
| | | |
| | | //1.查询出对应修理的数据 |
| | | Repair__c repair = [select Id,Hospital__c,address_Contacts__c,AWS_Data_Id__c from Repair__c where id=:rid]; |
| | | // gzw DB202212270703 20230301 备品地址导入改造 start |
| | | // Repair__c repair = [select Id,Hospital__c,address_Contacts__c,AWS_Data_Id__c from Repair__c where id=:rid]; |
| | | Repair__c repair = [select Id,Hospital__c,address_Contacts__c,AWS_Data_Id__c,Returns_Product_way__c, |
| | | Incharge_Staff__r.Profile.name,Incharge_Staff__r.UserRole.name, |
| | | Incharge_Staff__r.Branch__c from Repair__c where id=:rid]; |
| | | // gzw DB202212270703 20230301 备品地址导入改造 end |
| | | Account ac = [SELECT id,OCM_man_province_txt__c,FieldCity_Master_Name__c from Account where id =:repair.Hospital__c]; |
| | | String province = ''; |
| | | String city = ''; |
| | | String provinceAndCity = ''; |
| | | if('山东' == ac.OCM_man_province_txt__c){ |
| | | if('烟台市' == ac.FieldCity_Master_Name__c || '威海市' == ac.FieldCity_Master_Name__c || '日照市' == ac.FieldCity_Master_Name__c |
| | | || '青岛市' == ac.FieldCity_Master_Name__c || '潍坊市' == ac.FieldCity_Master_Name__c){ |
| | | provinceAndCity = matchupMap.get('山东,青岛市'); |
| | | }else{ |
| | | provinceAndCity = matchupMap.get('山东,济南市'); |
| | | } |
| | | //DB202303246427 LY 20230329 start |
| | | // if('山东' == ac.OCM_man_province_txt__c){ |
| | | // if('烟台市' == ac.FieldCity_Master_Name__c || '威海市' == ac.FieldCity_Master_Name__c || '日照市' == ac.FieldCity_Master_Name__c |
| | | // || '青岛市' == ac.FieldCity_Master_Name__c || '潍坊市' == ac.FieldCity_Master_Name__c){ |
| | | // provinceAndCity = matchupMap.get('山东,青岛市'); |
| | | // }else{ |
| | | // provinceAndCity = matchupMap.get('山东,济南市'); |
| | | // } |
| | | |
| | | if ('青岛' == ac.OCM_man_province_txt__c) { |
| | | provinceAndCity = matchupMap.get('山东,青岛市'); |
| | | }else if ('山东' == ac.OCM_man_province_txt__c) { |
| | | provinceAndCity = matchupMap.get('山东,济南市'); |
| | | //DB202303246427 LY 20230329 end |
| | | }else{ |
| | | provinceAndCity = matchupMap.get(ac.OCM_man_province_txt__c); |
| | | } |
| | |
| | | province = provinceAndCity.split(',')[0]; |
| | | city = provinceAndCity.split(',')[1]; |
| | | } |
| | | String addressSQl = 'SELECT ID,AWS_Data_Id__c,Customer__c,Customer_Name__c,Contacts__c,Contacts__r.AWS_Data_Id__c,Contacts_Name__c,Telephone__c,Province__c,Province_Name__c,City__c,City_Name__c,Detailed_Address__c,ZipCode__c' |
| | | + ' from Address__c ' |
| | | + ' where Address_Classification__c = \'办事处\' and Province_Name__c =: province and City_Name__c =: city ' |
| | | + ' order by Using_Datetime__c desc NULLS LAST '; |
| | | system.debug('addressSQl='+addressSQl); |
| | | // DB202212270703 20230301 备品地址导入改造 start |
| | | String beipCenter = ''; |
| | | if (repair.Returns_Product_way__c == '备品中心') { |
| | | if(repair.Incharge_Staff__c == null){ |
| | | beipCenter = ''; |
| | | }else if (repair.Incharge_Staff__r.Profile.name.startsWith('2B3')) { |
| | | beipCenter = '北京备品中心'; |
| | | }else if (repair.Incharge_Staff__r.Profile.name.startsWith('2B2')) { |
| | | if (repair.Incharge_Staff__r.Branch__c == '北京') { |
| | | beipCenter = '北京备品中心'; |
| | | }else if (repair.Incharge_Staff__r.Branch__c == '上海') { |
| | | beipCenter = '华东备品中心'; |
| | | }else if (repair.Incharge_Staff__r.Branch__c == '广州') { |
| | | beipCenter = '广州备品中心'; |
| | | } |
| | | }else if (repair.Incharge_Staff__r.UserRole.name == 'CTEC教育本部') { |
| | | if (repair.Incharge_Staff__r.Branch__c == '北京') { |
| | | beipCenter = '北京C-TEC'; |
| | | }else if (repair.Incharge_Staff__r.Branch__c == '上海') { |
| | | beipCenter = '上海C-TEC'; |
| | | }else if (repair.Incharge_Staff__r.Branch__c == '广州') { |
| | | beipCenter = '广州C-TEC'; |
| | | } |
| | | } |
| | | } |
| | | system.debug('beipCenter=========='+beipCenter); |
| | | String addressSQl = 'SELECT ID,AWS_Data_Id__c,Customer__c,Customer_Name__c,Contacts__c,Contacts__r.AWS_Data_Id__c,Contacts_Name__c,Telephone__c,Province__c,Province_Name__c,City__c,City_Name__c,Detailed_Address__c,ZipCode__c from Address__c '; |
| | | if (String.isNotBlank(beipCenter)) { |
| | | addressSQl += ' where Address_Classification__c = \'备品\' and Beipin_Center__c = \'' + beipCenter + '\''; |
| | | }else{ |
| | | addressSQl += ' where Address_Classification__c = \'办事处\' and Province_Name__c =\'' + province + '\''; |
| | | addressSQl += 'and City_Name__c =\'' + city + '\''; |
| | | } |
| | | addressSQl += ' order by Using_Datetime__c desc NULLS LAST '; |
| | | system.debug('addressSQl=============='+addressSQl); |
| | | List<Address__c> addressList = Database.query(addressSQl); |
| | | |
| | | |
| | | |
| | | |
| | | // String addressSQl = 'SELECT ID,AWS_Data_Id__c,Customer__c,Customer_Name__c,Contacts__c,Contacts__r.AWS_Data_Id__c,Contacts_Name__c,Telephone__c,Province__c,Province_Name__c,City__c,City_Name__c,Detailed_Address__c,ZipCode__c' |
| | | // + ' from Address__c ' |
| | | // + ' where Address_Classification__c = \'办事处\' and Province_Name__c =: province and City_Name__c =: city ' |
| | | // + ' order by Using_Datetime__c desc NULLS LAST '; |
| | | // system.debug('addressSQl='+addressSQl); |
| | | // List<Address__c> addressList = Database.query(addressSQl); |
| | | // DB202212270703 20230301 备品地址导入改造 end |
| | | //开始组装数据 |
| | | List<AWSServiceTool2V2.EncryptPushRequestBody> EncryptPushList = new List<AWSServiceTool2V2.EncryptPushRequestBody>(); |
| | | AWSServiceTool2V2.EncryptPushRequestBody EncryptPush = new AWSServiceTool2V2.EncryptPushRequestBody(); |