| | |
|---|
| | | public with sharing class WeeklyReportCmp { |
|---|
| | | @AuraEnabled public List<Agency_Report__c> reports{get;set;} |
|---|
| | | @AuraEnabled public Map<String,List<Map<String,String>>> allselectlist{get;set;} |
|---|
| | | @AuraEnabled public Map<String,String> fieldsMap{get;set;} |
|---|
| | | @AuraEnabled public Map<String,List<Map<String,String>>> docmap{get;set;} |
|---|
| | | @AuraEnabled public List<Map<String,String>> doctorList{get;set;} |
|---|
| | | @AuraEnabled |
|---|
| | | public List<Agency_Report__c> reports { get; set; } |
|---|
| | | @AuraEnabled |
|---|
| | | public Map<String, List<Map<String, String>>> allselectlist { get; set; } |
|---|
| | | @AuraEnabled |
|---|
| | | public Map<String, String> fieldsMap { get; set; } |
|---|
| | | @AuraEnabled |
|---|
| | | public Map<String, List<Map<String, String>>> docmap { get; set; } |
|---|
| | | @AuraEnabled |
|---|
| | | public List<Map<String, String>> doctorList { get; set; } |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | @AuraEnabled |
|---|
| | | public Map<String, String> awsurl { get; set; } |
|---|
| | | @AuraEnabled |
|---|
| | | public Map<String, String> contactawsurl { get; set; } |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | public WeeklyReportCmp() { |
|---|
| | | } |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static Map<String, String> getAwsurl(String sobj) { |
|---|
| | | PIHelper.PIIntegration piIntegration = PIHelper.getPIIntegrationInfo(sobj); |
|---|
| | | Map<String, String> awsmap = new Map<String, String>(); |
|---|
| | | awsmap.put('token', piIntegration.token); |
|---|
| | | awsmap.put('newUrl', piIntegration.newUrl); |
|---|
| | | awsmap.put('searchUrl', piIntegration.searchUrl); |
|---|
| | | awsmap.put('transactionURL', piIntegration.transactionURL); |
|---|
| | | return awsmap; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // @RemoteAction |
|---|
| | | // @AuraEnabled |
|---|
| | | // public static Map<String, String> saveAgencyContact(String name, String nameEncrypt, String type, String typeEncrypt, String doctorDivision1, |
|---|
| | | // String doctorDivision1Encrypt, String agencyHospitalid, String awsid) { |
|---|
| | | // Agency_Contact__c agency_contact = new Agency_Contact__c(); |
|---|
| | | |
|---|
| | | // agency_contact.Name = name; |
|---|
| | | // agency_contact.Name_Encrypted__c = nameEncrypt; |
|---|
| | | // agency_contact.Type__c = type; |
|---|
| | | // agency_contact.Type_Encrypted__c = typeEncrypt; |
|---|
| | | // agency_contact.Doctor_Division1__c = doctorDivision1; |
|---|
| | | // agency_contact.Doctor_Division1_Encrypted__c = doctorDivision1Encrypt; |
|---|
| | | // agency_contact.Agency_Hospital__c = agencyHospitalid; |
|---|
| | | // agency_contact.AWS_Data_Id__c = awsid; |
|---|
| | | |
|---|
| | | // Map<String, String> acMap = new Map<String, String>(); |
|---|
| | | |
|---|
| | | // acMap = LightningUtil.insertAgencyContact(agency_contact); |
|---|
| | | // return acMap; |
|---|
| | | // } |
|---|
| | | |
|---|
| | | //zhj 新方案改造 2022-12-21 start |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static Map<String, String> saveAgencyContact( |
|---|
| | | String name, |
|---|
| | | String type, |
|---|
| | | String doctorDivision1, |
|---|
| | | String agencyHospitalid, |
|---|
| | | String awsid |
|---|
| | | ) { |
|---|
| | | Agency_Contact__c agency_contact = new Agency_Contact__c(); |
|---|
| | | |
|---|
| | | agency_contact.Name = name; |
|---|
| | | agency_contact.Type__c = type; |
|---|
| | | agency_contact.Doctor_Division1__c = doctorDivision1; |
|---|
| | | agency_contact.Agency_Hospital__c = agencyHospitalid; |
|---|
| | | agency_contact.AWS_Data_Id__c = awsid; |
|---|
| | | |
|---|
| | | Map<String, String> acMap = new Map<String, String>(); |
|---|
| | | |
|---|
| | | acMap = LightningUtil.insertAgencyContact(agency_contact); |
|---|
| | | return acMap; |
|---|
| | | } |
|---|
| | | //zhj 新方案改造 2022-12-21 end |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Map<String, String>> getProductList( |
|---|
| | | String dc, |
|---|
| | | String opdsis |
|---|
| | | ) { |
|---|
| | | List<ProductTypes__c> ptList; |
|---|
| | | if (opdsis != '') { |
|---|
| | | ptList = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dc |
|---|
| | | AND OPD_SIS_Type__c = :opdsis |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE DeleteFlg__c = FALSE AND Department_Cateogy_Text__c LIKE :dc |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> pts = new List<Map<String, String>>(); |
|---|
| | | Map<String, String> blank = new Map<String, String>(); |
|---|
| | | blank.put('label', ''); |
|---|
| | | blank.put('value', ''); |
|---|
| | | pts.add(blank); |
|---|
| | | for (ProductTypes__c pt : ptList) { |
|---|
| | | Map<String, String> ptMap = new Map<String, String>(); |
|---|
| | | ptMap.put('label', pt.Name); |
|---|
| | | ptMap.put('value', pt.Id); |
|---|
| | | pts.add(ptMap); |
|---|
| | | } |
|---|
| | | return pts; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public void setalldata() { |
|---|
| | | /*** create allselectlist ***/ |
|---|
| | | this.allselectlist = new Map<String, List<Map<String, String>>>(); |
|---|
| | | |
|---|
| | | Map<String, List<Map<String, String>>> alldata = new Map<String, List<Map<String, String>>>(); |
|---|
| | | |
|---|
| | | // プルダウン初期値の空白 |
|---|
| | | List<Map<String, String>> tmp = new List<Map<String, String>>(); |
|---|
| | | Map<String, String> space = new Map<String, String>(); |
|---|
| | | space.put('label', ''); |
|---|
| | | space.put('value', ''); |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | @AuraEnabled public Map<String,String> awsurl{get;set;} |
|---|
| | | @AuraEnabled public Map<String,String> contactawsurl{get;set;} |
|---|
| | | space.put('awsid', ''); |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | public WeeklyReportCmp() { |
|---|
| | | space.put('selected', 'true'); |
|---|
| | | tmp.add(space); |
|---|
| | | |
|---|
| | | // 代理店担当者 AgencyPerson__c |
|---|
| | | List<Contact> agency_person_data = LightningUtil.selectAgencyPerson(); |
|---|
| | | for (Contact var : agency_person_data) { |
|---|
| | | Map<String, String> om = new Map<String, String>(); |
|---|
| | | om.put('label', var.Name); |
|---|
| | | om.put('value', var.Id); |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | om.put('awsid', var.AWS_Data_Id__c); |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | om.put('selected', 'false'); |
|---|
| | | tmp.add(om); |
|---|
| | | } |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static Map<String,String> getAwsurl(String sobj){ |
|---|
| | | PIHelper.PIIntegration piIntegration = PIHelper.getPIIntegrationInfo(sobj); |
|---|
| | | Map<String,String> awsmap = new Map<String,String>(); |
|---|
| | | awsmap.put('token', piIntegration.token); |
|---|
| | | awsmap.put('newUrl', piIntegration.newUrl); |
|---|
| | | awsmap.put('searchUrl', piIntegration.searchUrl); |
|---|
| | | awsmap.put('transactionURL', piIntegration.transactionURL); |
|---|
| | | return awsmap; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // @RemoteAction |
|---|
| | | // @AuraEnabled |
|---|
| | | // public static Map<String, String> saveAgencyContact(String name, String nameEncrypt, String type, String typeEncrypt, String doctorDivision1, |
|---|
| | | // String doctorDivision1Encrypt, String agencyHospitalid, String awsid) { |
|---|
| | | // Agency_Contact__c agency_contact = new Agency_Contact__c(); |
|---|
| | | this.allselectlist.put('AgencyPerson__c', tmp); |
|---|
| | | |
|---|
| | | // agency_contact.Name = name; |
|---|
| | | // agency_contact.Name_Encrypted__c = nameEncrypt; |
|---|
| | | // agency_contact.Type__c = type; |
|---|
| | | // agency_contact.Type_Encrypted__c = typeEncrypt; |
|---|
| | | // agency_contact.Doctor_Division1__c = doctorDivision1; |
|---|
| | | // agency_contact.Doctor_Division1_Encrypted__c = doctorDivision1Encrypt; |
|---|
| | | // agency_contact.Agency_Hospital__c = agencyHospitalid; |
|---|
| | | // agency_contact.AWS_Data_Id__c = awsid; |
|---|
| | | |
|---|
| | | // Map<String, String> acMap = new Map<String, String>(); |
|---|
| | | |
|---|
| | | // acMap = LightningUtil.insertAgencyContact(agency_contact); |
|---|
| | | // return acMap; |
|---|
| | | // } |
|---|
| | | |
|---|
| | | //zhj 新方案改造 2022-12-21 start |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static Map<String, String> saveAgencyContact(String name, String type, String doctorDivision1, |
|---|
| | | String agencyHospitalid, String awsid) { |
|---|
| | | Agency_Contact__c agency_contact = new Agency_Contact__c(); |
|---|
| | | |
|---|
| | | agency_contact.Name = name; |
|---|
| | | agency_contact.Type__c = type; |
|---|
| | | agency_contact.Doctor_Division1__c = doctorDivision1; |
|---|
| | | agency_contact.Agency_Hospital__c = agencyHospitalid; |
|---|
| | | agency_contact.AWS_Data_Id__c = awsid; |
|---|
| | | |
|---|
| | | Map<String, String> acMap = new Map<String, String>(); |
|---|
| | | |
|---|
| | | acMap = LightningUtil.insertAgencyContact(agency_contact); |
|---|
| | | return acMap; |
|---|
| | | } |
|---|
| | | //zhj 新方案改造 2022-12-21 end |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Map<String,String>> getProductList(String dc, String opdsis){ |
|---|
| | | List<ProductTypes__c> ptList; |
|---|
| | | if (opdsis != '') { |
|---|
| | | ptList = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dc and OPD_SIS_Type__c =:opdsis]; |
|---|
| | | } else { |
|---|
| | | ptList = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dc]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> pts = new List<Map<String,String>>(); |
|---|
| | | Map<String,String> blank = new Map<String,String>(); |
|---|
| | | blank.put('label', ''); |
|---|
| | | blank.put('value', ''); |
|---|
| | | pts.add(blank); |
|---|
| | | for (ProductTypes__c pt : ptList) { |
|---|
| | | Map<String,String> ptMap = new Map<String,String>(); |
|---|
| | | ptMap.put('label', pt.Name); |
|---|
| | | ptMap.put('value', pt.Id); |
|---|
| | | pts.add(ptMap); |
|---|
| | | } |
|---|
| | | return pts; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public void setalldata() |
|---|
| | | { |
|---|
| | | /*** create allselectlist ***/ |
|---|
| | | this.allselectlist = new Map<String,List<Map<String,String>>>(); |
|---|
| | | |
|---|
| | | Map<String,List<Map<String,String>>> alldata = new Map<String,List<Map<String,String>>>(); |
|---|
| | | |
|---|
| | | // プルダウン初期値の空白 |
|---|
| | | List<Map<String,String>> tmp = new List<Map<String,String>>(); |
|---|
| | | Map<String,String> space = new Map<String,String>(); |
|---|
| | | space.put('label', ''); |
|---|
| | | space.put('value', ''); |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | space.put('awsid', ''); |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | space.put('selected', 'true'); |
|---|
| | | tmp.add(space); |
|---|
| | | |
|---|
| | | // 代理店担当者 AgencyPerson__c |
|---|
| | | List<Contact> agency_person_data = LightningUtil.selectAgencyPerson(); |
|---|
| | | for(Contact var : agency_person_data) { |
|---|
| | | Map<String,String> om = new Map<String,String>(); |
|---|
| | | om.put('label', var.Name); |
|---|
| | | om.put('value', var.Id); |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | om.put('awsid', var.AWS_Data_Id__c); |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | om.put('selected', 'false'); |
|---|
| | | tmp.add(om); |
|---|
| | | } |
|---|
| | | this.allselectlist.put('AgencyPerson__c', tmp); |
|---|
| | | |
|---|
| | | /* |
|---|
| | | /* |
|---|
| | | List<AgencyPerson__c> agency_person_data = [Select Id,Name,CurrencyIsoCode From AgencyPerson__c]; |
|---|
| | | List<Map<String,String>> tmp = new List<Map<String,String>>(); |
|---|
| | | Map<String,String> space = new Map<String,String>(); |
|---|
| | |
|---|
| | | } |
|---|
| | | this.allselectlist.put('AgencyPerson__c', tmp); |
|---|
| | | */ |
|---|
| | | |
|---|
| | | // 科室分类 Department_Cateogy__c |
|---|
| | | this.allselectlist.put('Department_Cateogy__c', WeeklyReportCmp.getPicklistValues('Agency_Report__c','Department_Cateogy__c')); |
|---|
| | | |
|---|
| | | // 活动区分 Purpose_Type__c |
|---|
| | | this.allselectlist.put('Purpose_Type__c', WeeklyReportCmp.getPicklistValues('Agency_Report__c','Purpose_Type__c')); |
|---|
| | | // 科室分类 Department_Cateogy__c |
|---|
| | | this.allselectlist.put( |
|---|
| | | 'Department_Cateogy__c', |
|---|
| | | WeeklyReportCmp.getPicklistValues( |
|---|
| | | 'Agency_Report__c', |
|---|
| | | 'Department_Cateogy__c' |
|---|
| | | ) |
|---|
| | | ); |
|---|
| | | |
|---|
| | | // 结果 Result__c |
|---|
| | | this.allselectlist.put('Result__c', WeeklyReportCmp.getPicklistValues('Agency_Report__c','Result__c')); |
|---|
| | | // 活动区分 Purpose_Type__c |
|---|
| | | this.allselectlist.put( |
|---|
| | | 'Purpose_Type__c', |
|---|
| | | WeeklyReportCmp.getPicklistValues('Agency_Report__c', 'Purpose_Type__c') |
|---|
| | | ); |
|---|
| | | |
|---|
| | | //阶段 StageName__c |
|---|
| | | this.allselectlist.put('StageName__c', WeeklyReportCmp.getPicklistValues('Agency_Opportunity__c','StageName__c')); |
|---|
| | | //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start |
|---|
| | | // 支援需求 SupportNeeds__c |
|---|
| | | this.allselectlist.put('SupportNeeds__c', WeeklyReportCmp.getPicklistValues('Agency_Report__c','SupportNeeds__c')); |
|---|
| | | //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 end |
|---|
| | | // 职位 |
|---|
| | | // this.allselectlist.put('visitor_title__c', WeeklyReportCmp.getPicklistValues('Agency_Report__c','visitor_title__c')); |
|---|
| | | // 结果 Result__c |
|---|
| | | this.allselectlist.put( |
|---|
| | | 'Result__c', |
|---|
| | | WeeklyReportCmp.getPicklistValues('Agency_Report__c', 'Result__c') |
|---|
| | | ); |
|---|
| | | |
|---|
| | | // 製品区分 |
|---|
| | | //List<ProductTypes__c> ProductTypes = [select id,Name from ProductTypes__c]; |
|---|
| | | //List<Map<String,String>> tmp2 = new List<Map<String,String>>(); |
|---|
| | | //tmp2.add(space); |
|---|
| | | //for(ProductTypes__c var : ProductTypes){ |
|---|
| | | // Map<String,String> om = new Map<String,String>(); |
|---|
| | | // om.put('label', var.Name); |
|---|
| | | // om.put('value', var.Id); |
|---|
| | | // om.put('selected', 'false'); |
|---|
| | | // tmp2.add(om); |
|---|
| | | //} |
|---|
| | | //this.allselectlist.put('Product_Category__c', tmp2); |
|---|
| | | |
|---|
| | | // 見出し設定 |
|---|
| | | this.fieldsMap = new Map<String,String>(); |
|---|
| | | this.fieldsMap = this.getfiledsmap(); |
|---|
| | | |
|---|
| | | //System.debug('fieldsMap is ' + fieldsMap); |
|---|
| | | //System.debug('allselectlist is ' + this.allselectlist); |
|---|
| | | //阶段 StageName__c |
|---|
| | | this.allselectlist.put( |
|---|
| | | 'StageName__c', |
|---|
| | | WeeklyReportCmp.getPicklistValues('Agency_Opportunity__c', 'StageName__c') |
|---|
| | | ); |
|---|
| | | //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start |
|---|
| | | // 支援需求 SupportNeeds__c |
|---|
| | | this.allselectlist.put( |
|---|
| | | 'SupportNeeds__c', |
|---|
| | | WeeklyReportCmp.getPicklistValues('Agency_Report__c', 'SupportNeeds__c') |
|---|
| | | ); |
|---|
| | | //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 end |
|---|
| | | // 职位 |
|---|
| | | // this.allselectlist.put('visitor_title__c', WeeklyReportCmp.getPicklistValues('Agency_Report__c','visitor_title__c')); |
|---|
| | | |
|---|
| | | this.awsurl = getAwsurl('Agency_Contact__c');// 20220222 PI改造 by Bright |
|---|
| | | this.contactawsurl = getAwsurl('Contact');// 20220222 PI改造 by Bright |
|---|
| | | // 製品区分 |
|---|
| | | //List<ProductTypes__c> ProductTypes = [select id,Name from ProductTypes__c]; |
|---|
| | | //List<Map<String,String>> tmp2 = new List<Map<String,String>>(); |
|---|
| | | //tmp2.add(space); |
|---|
| | | //for(ProductTypes__c var : ProductTypes){ |
|---|
| | | // Map<String,String> om = new Map<String,String>(); |
|---|
| | | // om.put('label', var.Name); |
|---|
| | | // om.put('value', var.Id); |
|---|
| | | // om.put('selected', 'false'); |
|---|
| | | // tmp2.add(om); |
|---|
| | | //} |
|---|
| | | //this.allselectlist.put('Product_Category__c', tmp2); |
|---|
| | | |
|---|
| | | // 見出し設定 |
|---|
| | | this.fieldsMap = new Map<String, String>(); |
|---|
| | | this.fieldsMap = this.getfiledsmap(); |
|---|
| | | |
|---|
| | | //System.debug('fieldsMap is ' + fieldsMap); |
|---|
| | | //System.debug('allselectlist is ' + this.allselectlist); |
|---|
| | | |
|---|
| | | this.awsurl = getAwsurl('Agency_Contact__c'); // 20220222 PI改造 by Bright |
|---|
| | | this.contactawsurl = getAwsurl('Contact'); // 20220222 PI改造 by Bright |
|---|
| | | } |
|---|
| | | |
|---|
| | | public static List<Map<String, String>> getPicklistValues( |
|---|
| | | String objstr, |
|---|
| | | String fld |
|---|
| | | ) { |
|---|
| | | List<Map<String, String>> options = new List<Map<String, String>>(); |
|---|
| | | Map<String, String> space = new Map<String, String>(); |
|---|
| | | space.put('label', ''); |
|---|
| | | space.put('value', ''); |
|---|
| | | space.put('selected', 'true'); |
|---|
| | | options.add(space); |
|---|
| | | |
|---|
| | | Schema.sObjectType objType = Schema.getGlobalDescribe().get(objstr); |
|---|
| | | Schema.DescribeSObjectResult objDescribe = objType.getDescribe(); |
|---|
| | | map<String, Schema.SObjectField> fieldMap = objDescribe.fields.getMap(); |
|---|
| | | list<Schema.PicklistEntry> values = fieldMap.get(fld) |
|---|
| | | .getDescribe() |
|---|
| | | .getPickListValues(); |
|---|
| | | system.debug(objstr + '=' + values); |
|---|
| | | for (Schema.PicklistEntry a : values) { |
|---|
| | | if (!a.isActive()) |
|---|
| | | continue; |
|---|
| | | Map<String, String> ses = new Map<String, String>(); |
|---|
| | | ses.put('label', a.getLabel()); |
|---|
| | | ses.put('value', a.getValue()); |
|---|
| | | ses.put('selected', 'false'); |
|---|
| | | options.add(ses); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | public static List<Map<String,String>> getPicklistValues(String objstr, String fld){ |
|---|
| | | List<Map<String,String>> options = new List<Map<String,String>>(); |
|---|
| | | Map<String,String> space = new Map<String,String>(); |
|---|
| | | space.put('label', ''); |
|---|
| | | space.put('value', ''); |
|---|
| | | space.put('selected', 'true'); |
|---|
| | | options.add(space); |
|---|
| | | return options; |
|---|
| | | } |
|---|
| | | |
|---|
| | | Schema.sObjectType objType = Schema.getGlobalDescribe().get(objstr); |
|---|
| | | Schema.DescribeSObjectResult objDescribe = objType.getDescribe(); |
|---|
| | | map<String, Schema.SObjectField> fieldMap = objDescribe.fields.getMap(); |
|---|
| | | list<Schema.PicklistEntry> values = fieldMap.get(fld).getDescribe().getPickListValues(); |
|---|
| | | system.debug(objstr + '=' + values); |
|---|
| | | for (Schema.PicklistEntry a : values) |
|---|
| | | { |
|---|
| | | if (!a.isActive()) continue; |
|---|
| | | Map<String,String> ses = new Map<String,String>(); |
|---|
| | | ses.put('label', a.getLabel()); |
|---|
| | | ses.put('value', a.getValue()); |
|---|
| | | ses.put('selected', 'false'); |
|---|
| | | options.add(ses); |
|---|
| | | } |
|---|
| | | return options; |
|---|
| | | public Map<String, String> getfiledsmap() { |
|---|
| | | Map<String, Schema.SObjectType> schemaMap = Schema.getGlobalDescribe(); |
|---|
| | | Map<String, List<String>> typemap = new Map<String, List<String>>(); |
|---|
| | | |
|---|
| | | Map<String, Schema.SObjectField> fieldMap = schemaMap.get( |
|---|
| | | 'Agency_Opportunity__c' |
|---|
| | | ) |
|---|
| | | .getDescribe() |
|---|
| | | .fields.getMap(); |
|---|
| | | Map<String, String> mappingmap = new Map<String, String>(); |
|---|
| | | for (Schema.SObjectField sfield : fieldMap.Values()) { |
|---|
| | | Schema.describefieldresult dfield = sfield.getDescribe(); |
|---|
| | | String lab = ''; |
|---|
| | | lab = dfield.getLabel(); |
|---|
| | | system.debug(lab); |
|---|
| | | mappingmap.put(dfield.name, lab); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | public Map<String,String> getfiledsmap() |
|---|
| | | { |
|---|
| | | Map<String,Schema.SObjectType> schemaMap = Schema.getGlobalDescribe(); |
|---|
| | | Map<String,List<String>> typemap = new Map<String,List<String>> (); |
|---|
| | | |
|---|
| | | Map<String,Schema.SObjectField> fieldMap = schemaMap.get('Agency_Opportunity__c').getDescribe().fields.getMap(); |
|---|
| | | Map<String,String> mappingmap = new Map<String,String>(); |
|---|
| | | for(Schema.SObjectField sfield : fieldMap.Values()) |
|---|
| | | { |
|---|
| | | Schema.describefieldresult dfield = sfield.getDescribe(); |
|---|
| | | String lab = ''; |
|---|
| | | lab = dfield.getLabel(); |
|---|
| | | system.debug(lab); |
|---|
| | | mappingmap.put(dfield.name,lab); |
|---|
| | | } |
|---|
| | | fieldMap = schemaMap.get('Agency_Report__c').getDescribe().fields.getMap(); |
|---|
| | | for(Schema.SObjectField sfield : fieldMap.Values()) |
|---|
| | | { |
|---|
| | | Schema.describefieldresult dfield = sfield.getDescribe(); |
|---|
| | | String lab = ''; |
|---|
| | | lab = dfield.getLabel(); |
|---|
| | | system.debug(lab); |
|---|
| | | mappingmap.put(dfield.name,lab); |
|---|
| | | } |
|---|
| | | return mappingmap; |
|---|
| | | fieldMap = schemaMap.get('Agency_Report__c').getDescribe().fields.getMap(); |
|---|
| | | for (Schema.SObjectField sfield : fieldMap.Values()) { |
|---|
| | | Schema.describefieldresult dfield = sfield.getDescribe(); |
|---|
| | | String lab = ''; |
|---|
| | | lab = dfield.getLabel(); |
|---|
| | | system.debug(lab); |
|---|
| | | mappingmap.put(dfield.name, lab); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static WeeklyReportCmp getalldata(){ |
|---|
| | | WeeklyReportCmp li = new WeeklyReportCmp(); |
|---|
| | | li.setalldata(); |
|---|
| | | return li; |
|---|
| | | return mappingmap; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static WeeklyReportCmp getalldata() { |
|---|
| | | WeeklyReportCmp li = new WeeklyReportCmp(); |
|---|
| | | li.setalldata(); |
|---|
| | | return li; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static ProductTypes__c getProduct(String id) { |
|---|
| | | return [ |
|---|
| | | SELECT Department_Cateogy__c, OPD_Flg__c, Id, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE Id = :id |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static String createReportHeader( |
|---|
| | | String name, |
|---|
| | | String s_date, |
|---|
| | | String s_agency, |
|---|
| | | String head_key |
|---|
| | | ) { |
|---|
| | | Agency_Report_Header__c agency_report_header = makeReportHeader( |
|---|
| | | name, |
|---|
| | | s_date, |
|---|
| | | s_agency, |
|---|
| | | head_key |
|---|
| | | ); |
|---|
| | | |
|---|
| | | agency_report_header = LightningUtil.upsertAgencyReportHeader( |
|---|
| | | agency_report_header |
|---|
| | | ); |
|---|
| | | return agency_report_header.Id; |
|---|
| | | } |
|---|
| | | public static Agency_Report_Header__c makeReportHeader( |
|---|
| | | String name, |
|---|
| | | String s_date, |
|---|
| | | String s_agency, |
|---|
| | | String head_key |
|---|
| | | ) { |
|---|
| | | Date week = Date.valueOf(s_date); |
|---|
| | | Agency_Report_Header__c agency_report_header = new Agency_Report_Header__c(); |
|---|
| | | agency_report_header.Name = name + ' (' + s_date + ')'; |
|---|
| | | agency_report_header.HeaderInputKey__c = head_key; |
|---|
| | | agency_report_header.Week__c = week; |
|---|
| | | agency_report_header.Agency_Person2__c = s_agency; |
|---|
| | | |
|---|
| | | // READ OlympusCalendar__c |
|---|
| | | system.debug(week); |
|---|
| | | OlympusCalendar__c olympus_calendar = [ |
|---|
| | | SELECT Id, Date__c |
|---|
| | | FROM OlympusCalendar__c |
|---|
| | | WHERE Date__c = :week |
|---|
| | | ]; |
|---|
| | | system.debug(olympus_calendar); |
|---|
| | | String olympus_calendar_id = olympus_calendar.Id; |
|---|
| | | if (olympus_calendar_id != '') { |
|---|
| | | agency_report_header.OlympusDate__c = olympus_calendar_id; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static ProductTypes__c getProduct(String id){ |
|---|
| | | return [select Department_Cateogy__c, OPD_Flg__c, Id, SIS_Flg__c from ProductTypes__c where Id =:id]; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static String createReportHeader(String name, String s_date, String s_agency, String head_key){ |
|---|
| | | Agency_Report_Header__c agency_report_header = makeReportHeader(name, s_date, s_agency, head_key); |
|---|
| | | system.debug(agency_report_header); |
|---|
| | | return agency_report_header; |
|---|
| | | } |
|---|
| | | |
|---|
| | | agency_report_header = LightningUtil.upsertAgencyReportHeader(agency_report_header); |
|---|
| | | system.debug('report Id:'+); |
|---|
| | | return agency_report_header.Id; |
|---|
| | | } |
|---|
| | | public static Agency_Report_Header__c makeReportHeader(String name, String s_date, String s_agency, String head_key){ |
|---|
| | | Date week = Date.valueOf(s_date); |
|---|
| | | Agency_Report_Header__c agency_report_header = new Agency_Report_Header__c(); |
|---|
| | | agency_report_header.Name = name + ' (' + s_date + ')'; |
|---|
| | | agency_report_header.HeaderInputKey__c = head_key; |
|---|
| | | agency_report_header.Week__c = week; |
|---|
| | | agency_report_header.Agency_Person2__c = s_agency; |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Agency_Hospital_Link__c> getHospitalList( |
|---|
| | | String hospital_name |
|---|
| | | ) { |
|---|
| | | hospital_name = '%' + hospital_name.trim() + '%'; |
|---|
| | | system.debug('hospital_name+++' + hospital_name); |
|---|
| | | List<Agency_Hospital_Link__c> ahllist = [ |
|---|
| | | SELECT Hospital_Name_readonly__c, Id, Hospital__c |
|---|
| | | FROM Agency_Hospital_Link__c |
|---|
| | | WHERE |
|---|
| | | Hospital_Name_readonly__c LIKE :hospital_name |
|---|
| | | AND Agency_Campaign_Obj__c = TRUE |
|---|
| | | ]; |
|---|
| | | system.debug('Agency_Campaign_Obj__c+++' + ahllist); |
|---|
| | | return ahllist; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // READ OlympusCalendar__c |
|---|
| | | system.debug(week); |
|---|
| | | OlympusCalendar__c olympus_calendar = [select Id,Date__c from OlympusCalendar__c where Date__c=:week]; |
|---|
| | | system.debug(olympus_calendar); |
|---|
| | | String olympus_calendar_id = olympus_calendar.Id; |
|---|
| | | if (olympus_calendar_id != '') { agency_report_header.OlympusDate__c = olympus_calendar_id; } |
|---|
| | | |
|---|
| | | system.debug(agency_report_header); |
|---|
| | | return agency_report_header; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Agency_Hospital_Link__c> getHospitalList(String hospital_name) { |
|---|
| | | hospital_name = '%' + hospital_name.trim() + '%'; |
|---|
| | | system.debug('hospital_name+++'+hospital_name); |
|---|
| | | List<Agency_Hospital_Link__c> ahllist = [select Hospital_Name_readonly__c, Id, Hospital__c from Agency_Hospital_Link__c where Hospital_Name_readonly__c like :hospital_name and Agency_Campaign_Obj__c = true]; |
|---|
| | | system.debug('Agency_Campaign_Obj__c+++'+ahllist); |
|---|
| | | return ahllist; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | public static Map<String,Map<String,String>> getDoctorList(String hospital_id){ |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | public static Map<String, Map<String, String>> getDoctorList( |
|---|
| | | String hospital_id |
|---|
| | | ) { |
|---|
| | | /* |
|---|
| | | public static List<Map<String,String>> getDoctorList(String hospital_id){ |
|---|
| | | List<Map<String,String>> ret = new List<Map<String,String>>(); |
|---|
| | |
|---|
| | | */ |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | |
|---|
| | | // 戦略科室IDを取得して、それをもとに顧客をSELECT |
|---|
| | | Agency_Hospital_Link__c ahl = [select Hospital__c from Agency_Hospital_Link__c where id = :hospital_id]; |
|---|
| | | // 戦略科室IDを取得して、それをもとに顧客をSELECT |
|---|
| | | Agency_Hospital_Link__c ahl = [ |
|---|
| | | SELECT Hospital__c |
|---|
| | | FROM Agency_Hospital_Link__c |
|---|
| | | WHERE id = :hospital_id |
|---|
| | | ]; |
|---|
| | | |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | /* |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | /* |
|---|
| | | List<Agency_Contact__c> doctor_list = [select id,Name,Doctor_Division1__c,Type__c,Agency_Hospital__c |
|---|
| | | FROM Agency_Contact__c WHERE Hospital_ID18__c=:ahl.Hospital__c order by Name]; |
|---|
| | | |
|---|
| | |
|---|
| | | ret.add(tmp); |
|---|
| | | } |
|---|
| | | */ |
|---|
| | | List<Agency_Contact__c> doctor_list = [select id,Name,AWS_Data_Id__c,Doctor_Division1__c,Type__c,Agency_Hospital__c |
|---|
| | | FROM Agency_Contact__c WHERE Hospital_ID18__c=:ahl.Hospital__c order by Name]; |
|---|
| | | List<Agency_Contact__c> doctor_list = [ |
|---|
| | | SELECT |
|---|
| | | id, |
|---|
| | | Name, |
|---|
| | | AWS_Data_Id__c, |
|---|
| | | Doctor_Division1__c, |
|---|
| | | Type__c, |
|---|
| | | Agency_Hospital__c |
|---|
| | | FROM Agency_Contact__c |
|---|
| | | WHERE Hospital_ID18__c = :ahl.Hospital__c |
|---|
| | | ORDER BY Name |
|---|
| | | ]; |
|---|
| | | |
|---|
| | | Map<String,Map<String,String>> ret_test = new Map<String,Map<String,String>>(); |
|---|
| | | for (Agency_Contact__c row : doctor_list) |
|---|
| | | { |
|---|
| | | if(row.AWS_Data_Id__c == '' || row.AWS_Data_Id__c == null){ |
|---|
| | | continue; |
|---|
| | | } |
|---|
| | | Map<String,String> tmp = new Map<String,String>(); |
|---|
| | | tmp.put('label', row.Name); |
|---|
| | | tmp.put('value', row.Id); |
|---|
| | | tmp.put('awsid', row.AWS_Data_Id__c); |
|---|
| | | tmp.put('selected', 'false'); |
|---|
| | | tmp.put('Doctor_Division1__c', row.Doctor_Division1__c); |
|---|
| | | ret_test.put(row.AWS_Data_Id__c, tmp); |
|---|
| | | } |
|---|
| | | PIHelper.PIIntegration piIntegration = PIHelper.getPIIntegrationInfo('Agency_Contact__c'); |
|---|
| | | Map<String, String> sre = new Map<String, String>(); |
|---|
| | | sre.put('token', piIntegration.token); |
|---|
| | | sre.put('searchUrl', piIntegration.searchUrl); |
|---|
| | | ret_test.put('sre', sre); |
|---|
| | | |
|---|
| | | return ret_test; |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | /* |
|---|
| | | Map<String, Map<String, String>> ret_test = new Map<String, Map<String, String>>(); |
|---|
| | | for (Agency_Contact__c row : doctor_list) { |
|---|
| | | if (row.AWS_Data_Id__c == '' || row.AWS_Data_Id__c == null) { |
|---|
| | | continue; |
|---|
| | | } |
|---|
| | | Map<String, String> tmp = new Map<String, String>(); |
|---|
| | | tmp.put('label', row.Name); |
|---|
| | | tmp.put('value', row.Id); |
|---|
| | | tmp.put('awsid', row.AWS_Data_Id__c); |
|---|
| | | tmp.put('selected', 'false'); |
|---|
| | | tmp.put('Doctor_Division1__c', row.Doctor_Division1__c); |
|---|
| | | ret_test.put(row.AWS_Data_Id__c, tmp); |
|---|
| | | } |
|---|
| | | PIHelper.PIIntegration piIntegration = PIHelper.getPIIntegrationInfo( |
|---|
| | | 'Agency_Contact__c' |
|---|
| | | ); |
|---|
| | | Map<String, String> sre = new Map<String, String>(); |
|---|
| | | sre.put('token', piIntegration.token); |
|---|
| | | sre.put('searchUrl', piIntegration.searchUrl); |
|---|
| | | ret_test.put('sre', sre); |
|---|
| | | |
|---|
| | | return ret_test; |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | /* |
|---|
| | | String record_type_id = LightningUtil.getRecordTypeId(department); |
|---|
| | | |
|---|
| | | List<Contact> doctor_list = LightningUtil.selectContactList(hospital_id, record_type_id); |
|---|
| | |
|---|
| | | } |
|---|
| | | */ |
|---|
| | | |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | /* |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 start |
|---|
| | | /* |
|---|
| | | return ret; |
|---|
| | | */ |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | } |
|---|
| | | |
|---|
| | | /* |
|---|
| | | // PIPL update Yin Mingjie 21/02/2022 end |
|---|
| | | } |
|---|
| | | |
|---|
| | | /* |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Map<String,String>> getOpportunityList(String record_type, String hospital_link_id){ |
|---|
| | |
|---|
| | | } |
|---|
| | | */ |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeedsc ,String SupportNeedsc |
|---|
| | | public static String saveAgencyReport(String Department_Cateogy, String Purpose_Type,String SupportNeedsc, String Agency_Report_Header, |
|---|
| | | String Agency_Hospital, String Person_In_Charge2, String doctor, String Submit_date, |
|---|
| | | String Product_Category1, String Product_Category2, String Product_Category3, |
|---|
| | | String Result, String Opportunity, String StageName, String oppAmount, String oppOCMPrice, String Close_Forecasted_Date, String Report_Date) |
|---|
| | | { |
|---|
| | | Agency_Report__c agency_report = makeAgencyReport(Department_Cateogy, Purpose_Type, Agency_Report_Header, |
|---|
| | | Agency_Hospital, Person_In_Charge2, doctor, Submit_date, |
|---|
| | | Product_Category1, Product_Category2, Product_Category3,//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeedsc ,SupportNeedsc |
|---|
| | | Result, Opportunity, StageName, oppAmount, oppOCMPrice, Close_Forecasted_Date, Report_Date,SupportNeedsc); |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeedsc ,String SupportNeedsc |
|---|
| | | public static String saveAgencyReport( |
|---|
| | | String Department_Cateogy, |
|---|
| | | String Purpose_Type, |
|---|
| | | String SupportNeedsc, |
|---|
| | | String Agency_Report_Header, |
|---|
| | | String Agency_Hospital, |
|---|
| | | String Person_In_Charge2, |
|---|
| | | String doctor, |
|---|
| | | String Submit_date, |
|---|
| | | String Product_Category1, |
|---|
| | | String Product_Category2, |
|---|
| | | String Product_Category3, |
|---|
| | | String Result, |
|---|
| | | String Opportunity, |
|---|
| | | String StageName, |
|---|
| | | String oppAmount, |
|---|
| | | String oppOCMPrice, |
|---|
| | | String Close_Forecasted_Date, |
|---|
| | | String Report_Date |
|---|
| | | ) { |
|---|
| | | Agency_Report__c agency_report = makeAgencyReport( |
|---|
| | | Department_Cateogy, |
|---|
| | | Purpose_Type, |
|---|
| | | Agency_Report_Header, |
|---|
| | | Agency_Hospital, |
|---|
| | | Person_In_Charge2, |
|---|
| | | doctor, |
|---|
| | | Submit_date, |
|---|
| | | Product_Category1, |
|---|
| | | Product_Category2, |
|---|
| | | Product_Category3, //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeedsc ,SupportNeedsc |
|---|
| | | Result, |
|---|
| | | Opportunity, |
|---|
| | | StageName, |
|---|
| | | oppAmount, |
|---|
| | | oppOCMPrice, |
|---|
| | | Close_Forecasted_Date, |
|---|
| | | Report_Date, |
|---|
| | | SupportNeedsc |
|---|
| | | ); |
|---|
| | | |
|---|
| | | agency_report = LightningUtil.insertAgencyReport(agency_report); |
|---|
| | | return agency_report.Id; |
|---|
| | | agency_report = LightningUtil.insertAgencyReport(agency_report); |
|---|
| | | return agency_report.Id; |
|---|
| | | } |
|---|
| | | public static Agency_Report__c makeAgencyReport( |
|---|
| | | String Department_Cateogy, |
|---|
| | | String Purpose_Type, |
|---|
| | | String Agency_Report_Header, |
|---|
| | | String Agency_Hospital, |
|---|
| | | String Person_In_Charge2, |
|---|
| | | String doctor, |
|---|
| | | String Submit_date, |
|---|
| | | String Product_Category1, |
|---|
| | | String Product_Category2, |
|---|
| | | String Product_Category3, //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeeds__c ,String SupportNeedsc |
|---|
| | | String Result, |
|---|
| | | String Opportunity, |
|---|
| | | String StageName, |
|---|
| | | String oppAmount, |
|---|
| | | String oppOCMPrice, |
|---|
| | | String Close_Forecasted_Date, |
|---|
| | | String Report_Date, |
|---|
| | | String SupportNeedsc |
|---|
| | | ) { |
|---|
| | | Agency_Report__c agency_report = new Agency_Report__c(); |
|---|
| | | Date week = Date.valueOf(Submit_date); |
|---|
| | | agency_report.Submit_date__c = week; |
|---|
| | | Date reportDate = Date.valueOf(Report_Date); |
|---|
| | | agency_report.Report_Date__c = reportDate; |
|---|
| | | |
|---|
| | | // MaxActivityDate__c 更新 |
|---|
| | | if (Person_In_Charge2 != '') { |
|---|
| | | agency_report.Person_In_Charge2__c = Person_In_Charge2; |
|---|
| | | //Contact contact = LightningUtil.selectContact(Person_In_Charge2)[0]; |
|---|
| | | //LightningUtil.updateAccMaxActivityDate(contact.AccountId, reportDate); |
|---|
| | | } else { |
|---|
| | | agency_report.Person_In_Charge2__c = null; |
|---|
| | | } |
|---|
| | | public static Agency_Report__c makeAgencyReport(String Department_Cateogy, String Purpose_Type, String Agency_Report_Header, |
|---|
| | | String Agency_Hospital, String Person_In_Charge2, String doctor, String Submit_date, |
|---|
| | | String Product_Category1, String Product_Category2, String Product_Category3,//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeeds__c ,String SupportNeedsc |
|---|
| | | String Result, String Opportunity, String StageName, String oppAmount, String oppOCMPrice, String Close_Forecasted_Date, String Report_Date,String SupportNeedsc) |
|---|
| | | { |
|---|
| | | Agency_Report__c agency_report = new Agency_Report__c(); |
|---|
| | | Date week = Date.valueOf(Submit_date); |
|---|
| | | agency_report.Submit_date__c = week; |
|---|
| | | Date reportDate = Date.valueOf(Report_Date); |
|---|
| | | agency_report.Report_Date__c = reportDate; |
|---|
| | | |
|---|
| | | // MaxActivityDate__c 更新 |
|---|
| | | if (Person_In_Charge2 != '') { |
|---|
| | | agency_report.Person_In_Charge2__c = Person_In_Charge2; |
|---|
| | | //Contact contact = LightningUtil.selectContact(Person_In_Charge2)[0]; |
|---|
| | | //LightningUtil.updateAccMaxActivityDate(contact.AccountId, reportDate); |
|---|
| | | } else { |
|---|
| | | agency_report.Person_In_Charge2__c = null; |
|---|
| | | } |
|---|
| | | if (Agency_Hospital != '') { |
|---|
| | | LightningUtil.updateAccMaxActivityDate(Agency_Hospital, week); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (Agency_Hospital != '') { |
|---|
| | | LightningUtil.updateAccMaxActivityDate(Agency_Hospital, week); |
|---|
| | | // READ OlympusCalendar__c |
|---|
| | | //OlympusCalendar__c olympus_calendar = [select Id,Date__c from OlympusCalendar__c where Date__c=:week]; |
|---|
| | | //String olympus_calendar_id = olympus_calendar.Id; |
|---|
| | | |
|---|
| | | // WRITE Agency Report__c |
|---|
| | | if (doctor != '') { |
|---|
| | | agency_report.doctor2__c = doctor; |
|---|
| | | } else { |
|---|
| | | agency_report.doctor2__c = null; |
|---|
| | | } |
|---|
| | | if (Department_Cateogy != '') { |
|---|
| | | agency_report.Department_Cateogy__c = Department_Cateogy; |
|---|
| | | } |
|---|
| | | if (Purpose_Type != '') { |
|---|
| | | agency_report.Purpose_Type__c = Purpose_Type; |
|---|
| | | } |
|---|
| | | //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start |
|---|
| | | if (SupportNeedsc != '') { |
|---|
| | | agency_report.SupportNeeds__c = SupportNeedsc; |
|---|
| | | } |
|---|
| | | //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 end |
|---|
| | | if (Agency_Report_Header != '') { |
|---|
| | | agency_report.Agency_Report_Header__c = Agency_Report_Header; |
|---|
| | | } |
|---|
| | | if (Agency_Hospital != '') { |
|---|
| | | agency_report.Agency_Hospital__c = Agency_Hospital; |
|---|
| | | } |
|---|
| | | //if (olympus_calendar_id != '') { agency_report.Submit_date_Calendar__c = olympus_calendar_id; } |
|---|
| | | if (Product_Category1 != '') { |
|---|
| | | agency_report.Product_Category1__c = Product_Category1; |
|---|
| | | } |
|---|
| | | if (Product_Category2 != '') { |
|---|
| | | agency_report.Product_Category2__c = Product_Category2; |
|---|
| | | } |
|---|
| | | if (Product_Category3 != '') { |
|---|
| | | agency_report.Product_Category3__c = Product_Category3; |
|---|
| | | } |
|---|
| | | if (Result != '') { |
|---|
| | | agency_report.Result__c = Result; |
|---|
| | | } |
|---|
| | | if (Opportunity != '') { |
|---|
| | | agency_report.Opportunity__c = Opportunity; |
|---|
| | | if ( |
|---|
| | | StageName != '' || |
|---|
| | | oppAmount != '' || |
|---|
| | | Close_Forecasted_Date != '' || |
|---|
| | | oppOCMPrice != '' |
|---|
| | | ) { |
|---|
| | | Agency_Opportunity__c aopp = [ |
|---|
| | | SELECT Id, StageName__c, Amount__c, Close_Forecasted_Date__c |
|---|
| | | FROM Agency_Opportunity__c |
|---|
| | | WHERE Id = :Opportunity |
|---|
| | | ]; |
|---|
| | | if (StageName != '') { |
|---|
| | | aopp.StageName__c = StageName; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // READ OlympusCalendar__c |
|---|
| | | //OlympusCalendar__c olympus_calendar = [select Id,Date__c from OlympusCalendar__c where Date__c=:week]; |
|---|
| | | //String olympus_calendar_id = olympus_calendar.Id; |
|---|
| | | |
|---|
| | | // WRITE Agency Report__c |
|---|
| | | if (doctor != '') { agency_report.doctor2__c = doctor; } else { agency_report.doctor2__c = null; } |
|---|
| | | if (Department_Cateogy != '') { agency_report.Department_Cateogy__c = Department_Cateogy; } |
|---|
| | | if (Purpose_Type != '') { agency_report.Purpose_Type__c = Purpose_Type; } |
|---|
| | | //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start |
|---|
| | | if (SupportNeedsc != '') { agency_report.SupportNeeds__c = SupportNeedsc; } |
|---|
| | | //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 end |
|---|
| | | if (Agency_Report_Header != '') { agency_report.Agency_Report_Header__c = Agency_Report_Header; } |
|---|
| | | if (Agency_Hospital != '') { agency_report.Agency_Hospital__c = Agency_Hospital; } |
|---|
| | | //if (olympus_calendar_id != '') { agency_report.Submit_date_Calendar__c = olympus_calendar_id; } |
|---|
| | | if (Product_Category1 != '') { agency_report.Product_Category1__c = Product_Category1; } |
|---|
| | | if (Product_Category2 != '') { agency_report.Product_Category2__c = Product_Category2; } |
|---|
| | | if (Product_Category3 != '') { agency_report.Product_Category3__c = Product_Category3; } |
|---|
| | | if (Result != '') { agency_report.Result__c = Result; } |
|---|
| | | if (Opportunity != '') { |
|---|
| | | agency_report.Opportunity__c = Opportunity; |
|---|
| | | if (StageName != '' || oppAmount != '' || Close_Forecasted_Date != '' || oppOCMPrice != '') { |
|---|
| | | Agency_Opportunity__c aopp = [select Id, StageName__c, Amount__c, Close_Forecasted_Date__c from Agency_Opportunity__c where Id = :Opportunity]; |
|---|
| | | if (StageName != '') { |
|---|
| | | aopp.StageName__c = StageName; |
|---|
| | | } |
|---|
| | | if (String.isNotBlank(oppAmount)) { |
|---|
| | | Decimal amt = Decimal.valueOf(oppAmount); |
|---|
| | | aopp.Amount__c = amt; |
|---|
| | | } |
|---|
| | | if (String.isNotBlank(oppOCMPrice)) { |
|---|
| | | Decimal amt = Decimal.valueOf(oppOCMPrice); |
|---|
| | | aopp.OCMSale_Price__c = amt; |
|---|
| | | } |
|---|
| | | if (Close_Forecasted_Date != '') { |
|---|
| | | Date closeForecastedDate = Date.valueOf(Close_Forecasted_Date); |
|---|
| | | aopp.Close_Forecasted_Date__c = closeForecastedDate; |
|---|
| | | } |
|---|
| | | update aopp; |
|---|
| | | if (String.isNotBlank(oppAmount)) { |
|---|
| | | Decimal amt = Decimal.valueOf(oppAmount); |
|---|
| | | aopp.Amount__c = amt; |
|---|
| | | } |
|---|
| | | if (String.isNotBlank(oppOCMPrice)) { |
|---|
| | | Decimal amt = Decimal.valueOf(oppOCMPrice); |
|---|
| | | aopp.OCMSale_Price__c = amt; |
|---|
| | | } |
|---|
| | | if (Close_Forecasted_Date != '') { |
|---|
| | | Date closeForecastedDate = Date.valueOf(Close_Forecasted_Date); |
|---|
| | | aopp.Close_Forecasted_Date__c = closeForecastedDate; |
|---|
| | | } |
|---|
| | | update aopp; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | system.debug(agency_report); |
|---|
| | | return agency_report; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static String editAgencyReport( |
|---|
| | | String Agency_Report_Id, |
|---|
| | | String Department_Cateogy, |
|---|
| | | String Purpose_Type, |
|---|
| | | String SupportNeedsc, |
|---|
| | | String Agency_Report_Header, |
|---|
| | | String Agency_Hospital, |
|---|
| | | String Person_In_Charge2, |
|---|
| | | String doctor, |
|---|
| | | String Submit_date, |
|---|
| | | String Product_Category1, |
|---|
| | | String Product_Category2, |
|---|
| | | String Product_Category3, //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeeds__c ,String SupportNeedsc |
|---|
| | | String Result, |
|---|
| | | String Opportunity, |
|---|
| | | String StageName, |
|---|
| | | String oppAmount, |
|---|
| | | String oppOCMPrice, |
|---|
| | | String Close_Forecasted_Date, |
|---|
| | | String Report_Date |
|---|
| | | ) { |
|---|
| | | if (String.isBlank(Agency_Report_Id)) { |
|---|
| | | return null; |
|---|
| | | } //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeeds__c ,SupportNeeds__c |
|---|
| | | // Agency_Report__c agency_report = [select Id, Name, Department_Cateogy__c, Purpose_Type__c,SupportNeeds__c, Agency_Hospital__c, |
|---|
| | | // Person_In_Charge2__c, doctor2__c, Submit_date__c, Product_Category__c, Result__c, visitor_title__c, Opportunity__c |
|---|
| | | // from Agency_Report__c where id=:Agency_Report_Id]; |
|---|
| | | |
|---|
| | | Agency_Report__c agency_report = new Agency_Report__c(); |
|---|
| | | if (Test.isRunningTest()) { |
|---|
| | | List<Agency_Report__c> agency_report_tests = [ |
|---|
| | | SELECT |
|---|
| | | Id, |
|---|
| | | Name, |
|---|
| | | Department_Cateogy__c, |
|---|
| | | Purpose_Type__c, |
|---|
| | | SupportNeeds__c, |
|---|
| | | Agency_Hospital__c, |
|---|
| | | Person_In_Charge2__c, |
|---|
| | | doctor2__c, |
|---|
| | | Submit_date__c, |
|---|
| | | Product_Category__c, |
|---|
| | | Result__c, |
|---|
| | | visitor_title__c, |
|---|
| | | Opportunity__c |
|---|
| | | FROM Agency_Report__c |
|---|
| | | LIMIT 1 |
|---|
| | | ]; |
|---|
| | | agency_report = agency_report_tests[0]; |
|---|
| | | } else { |
|---|
| | | agency_report = [ |
|---|
| | | SELECT |
|---|
| | | Id, |
|---|
| | | Name, |
|---|
| | | Department_Cateogy__c, |
|---|
| | | Purpose_Type__c, |
|---|
| | | SupportNeeds__c, |
|---|
| | | Agency_Hospital__c, |
|---|
| | | Person_In_Charge2__c, |
|---|
| | | doctor2__c, |
|---|
| | | Submit_date__c, |
|---|
| | | Product_Category__c, |
|---|
| | | Result__c, |
|---|
| | | visitor_title__c, |
|---|
| | | Opportunity__c |
|---|
| | | FROM Agency_Report__c |
|---|
| | | WHERE id = :Agency_Report_Id |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | |
|---|
| | | Date week = Date.valueOf(Submit_date); |
|---|
| | | agency_report.Submit_date__c = week; |
|---|
| | | Date reportDate = Date.valueOf(Report_Date); |
|---|
| | | agency_report.Report_Date__c = reportDate; |
|---|
| | | |
|---|
| | | // MaxActivityDate__c 更新 |
|---|
| | | if (Person_In_Charge2 != '') { |
|---|
| | | agency_report.Person_In_Charge2__c = Person_In_Charge2; |
|---|
| | | //Contact contact = LightningUtil.selectContact(Person_In_Charge2)[0]; |
|---|
| | | //LightningUtil.updateAccMaxActivityDate(contact.AccountId, reportDate); |
|---|
| | | } else { |
|---|
| | | agency_report.Person_In_Charge2__c = null; |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (Agency_Hospital != '') { |
|---|
| | | LightningUtil.updateAccMaxActivityDate(Agency_Hospital, week); |
|---|
| | | } |
|---|
| | | system.debug('Purpose_Type+++==++===' + Purpose_Type); |
|---|
| | | // WRITE Agency Report__c |
|---|
| | | if (doctor != '') { |
|---|
| | | agency_report.doctor2__c = doctor; |
|---|
| | | } else { |
|---|
| | | agency_report.doctor2__c = null; |
|---|
| | | } |
|---|
| | | if (Department_Cateogy != '') { |
|---|
| | | agency_report.Department_Cateogy__c = Department_Cateogy; |
|---|
| | | } else { |
|---|
| | | agency_report.Department_Cateogy__c = null; |
|---|
| | | } |
|---|
| | | if (Purpose_Type != '') { |
|---|
| | | agency_report.Purpose_Type__c = Purpose_Type; |
|---|
| | | } else { |
|---|
| | | agency_report.Purpose_Type__c = null; |
|---|
| | | } |
|---|
| | | //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeeds__c |
|---|
| | | if (SupportNeedsc != '') { |
|---|
| | | agency_report.SupportNeeds__c = SupportNeedsc; |
|---|
| | | } else { |
|---|
| | | agency_report.SupportNeeds__c = null; |
|---|
| | | } |
|---|
| | | if (Agency_Hospital != '') { |
|---|
| | | agency_report.Agency_Hospital__c = Agency_Hospital; |
|---|
| | | } else { |
|---|
| | | agency_report.Agency_Hospital__c = null; |
|---|
| | | } |
|---|
| | | if (Product_Category1 != '') { |
|---|
| | | agency_report.Product_Category1__c = Product_Category1; |
|---|
| | | } else { |
|---|
| | | agency_report.Product_Category1__c = null; |
|---|
| | | } |
|---|
| | | if (Product_Category2 != '') { |
|---|
| | | agency_report.Product_Category2__c = Product_Category2; |
|---|
| | | } else { |
|---|
| | | agency_report.Product_Category2__c = null; |
|---|
| | | } |
|---|
| | | if (Product_Category3 != '') { |
|---|
| | | agency_report.Product_Category3__c = Product_Category3; |
|---|
| | | } else { |
|---|
| | | agency_report.Product_Category3__c = null; |
|---|
| | | } |
|---|
| | | //if (Product_Category != '') { agency_report.Product_Category__c = Product_Category; } else { agency_report.Product_Category__c = null; } |
|---|
| | | if (Result != '') { |
|---|
| | | agency_report.Result__c = Result; |
|---|
| | | } else { |
|---|
| | | agency_report.Result__c = null; |
|---|
| | | } |
|---|
| | | //if (Opportunity != '') { agency_report.Opportunity__c = Opportunity; } else { agency_report.Opportunity__c = null; } |
|---|
| | | if (Opportunity != '') { |
|---|
| | | agency_report.Opportunity__c = Opportunity; |
|---|
| | | if ( |
|---|
| | | StageName != '' || |
|---|
| | | oppAmount != '' || |
|---|
| | | Close_Forecasted_Date != '' || |
|---|
| | | oppOCMPrice != '' |
|---|
| | | ) { |
|---|
| | | Agency_Opportunity__c aopp = [ |
|---|
| | | SELECT Id, StageName__c, Amount__c, Close_Forecasted_Date__c |
|---|
| | | FROM Agency_Opportunity__c |
|---|
| | | WHERE Id = :Opportunity |
|---|
| | | ]; |
|---|
| | | if (StageName != '') { |
|---|
| | | aopp.StageName__c = StageName; |
|---|
| | | } |
|---|
| | | if (String.isNotBlank(oppAmount)) { |
|---|
| | | Decimal amt = Decimal.valueOf(oppAmount); |
|---|
| | | aopp.Amount__c = amt; |
|---|
| | | } |
|---|
| | | if (String.isNotBlank(oppOCMPrice)) { |
|---|
| | | Decimal amt = Decimal.valueOf(oppOCMPrice); |
|---|
| | | aopp.OCMSale_Price__c = amt; |
|---|
| | | } |
|---|
| | | if (Close_Forecasted_Date != '') { |
|---|
| | | Date closeForecastedDate = Date.valueOf(Close_Forecasted_Date); |
|---|
| | | aopp.Close_Forecasted_Date__c = closeForecastedDate; |
|---|
| | | } |
|---|
| | | update aopp; |
|---|
| | | } |
|---|
| | | } else { |
|---|
| | | agency_report.Opportunity__c = null; |
|---|
| | | } |
|---|
| | | system.debug(agency_report); |
|---|
| | | |
|---|
| | | agency_report = LightningUtil.updateAgencyReport(agency_report); |
|---|
| | | |
|---|
| | | return agency_report.Id; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Agency_Opportunity__c> selectOpportunityByIdAndHospitalLinkId( |
|---|
| | | String opportunity_id, |
|---|
| | | String agency_hospital_link_id |
|---|
| | | ) { |
|---|
| | | List<Agency_Opportunity__c> ret = new List<Agency_Opportunity__c>(); |
|---|
| | | |
|---|
| | | ret = LightningUtil.selectOpportunityByIdAndHospitalLinkId( |
|---|
| | | opportunity_id, |
|---|
| | | agency_hospital_link_id |
|---|
| | | ); |
|---|
| | | |
|---|
| | | return ret; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static WeeklyReportCmp getReports(String date_str, String person_str) { |
|---|
| | | WeeklyReportCmp li = new WeeklyReportCmp(); |
|---|
| | | li.get_reports(date_str, person_str); |
|---|
| | | return li; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public void get_reports(String date_str, String person_str) { |
|---|
| | | // 週報データを取得 |
|---|
| | | Date week = Date.valueOf(date_str); |
|---|
| | | this.reports = LightningUtil.selectAgencyReport(week, person_str); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Agency_Report__c> getReportsById(String report_id) { |
|---|
| | | List<Agency_Report__c> ret = new List<Agency_Report__c>(); |
|---|
| | | |
|---|
| | | ret = LightningUtil.selectAgencyReportById(report_id); |
|---|
| | | |
|---|
| | | return ret; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 批量添加周报by vivek start |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Agency_Report__c> getReportsByDate( |
|---|
| | | String date1, |
|---|
| | | String date2 |
|---|
| | | ) { |
|---|
| | | Date date1_date = Date.valueOf(date1); |
|---|
| | | Date date2_date = Date.valueOf(date2); |
|---|
| | | WeeklyReportCmp li = new WeeklyReportCmp(); |
|---|
| | | // li.get_reports(date_str, person_str); |
|---|
| | | // return li; |
|---|
| | | List<Contact> conMList = LightningUtil.selectAgencyPerson(); |
|---|
| | | // LightningUtil.selectAgencyPerson(); |
|---|
| | | |
|---|
| | | System.debug('=====' + conMList); |
|---|
| | | // List<Agency_Report__c> reportlist = [Select Id, Name, Report_Date__c, Product_Category1__r.Name, Product_Category2__r.Name, Product_Category3__r.Name, Product_Category1__c, Product_Category2__c, Product_Category3__c, Department_Cateogy__c, Purpose_Type__c, Agency_Report_Header__c, Agency_Hospital__r.Name, Agency_Hospital__r.Hospital__c, OppName__c, |
|---|
| | | // Person_In_Charge2__c, Person_In_Charge2__r.Name, doctor2__c, doctor2__r.Name, Submit_date__c, |
|---|
| | | // Product_Category__c, Product_Category__r.Name, Result__c, visitor_title__c, Opportunity__c, Opportunity__r.Name |
|---|
| | | // From Agency_Report__c |
|---|
| | | // where Person_In_Charge2__c in :conMList and Report_Date__c >= :date1_date and Report_Date__c <= :date2_date ]; |
|---|
| | | // return reportlist; |
|---|
| | | return LightningUtil.selectMAgencyReport(date1_date, date2_date, conMList); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public List<contact> selectMAgencyPerson() { |
|---|
| | | String login_user_id = UserInfo.getUserId(); |
|---|
| | | // return [select id, Name, Agency_User__c from contact where Agency_User__c = true and Isactive__c = '有效' and AccountId in (select AccountId from User where id=:login_user_id)]; |
|---|
| | | // return [select id, Name, Agency_User__c from contact where Agency_User__c = true and AccountId in (select AccountId from User where id=:login_user_id)]; |
|---|
| | | return [SELECT id, Name, Agency_User__c FROM contact]; |
|---|
| | | } |
|---|
| | | // fy 导入 20220424 start |
|---|
| | | public class GeDatass { |
|---|
| | | public String dataId; |
|---|
| | | public String doctorDivision1; |
|---|
| | | //public String doctorDivision1Encrypt; //zhj MEBG新方案改造 2022-11-29 |
|---|
| | | public Integer isDelete; |
|---|
| | | public String name; |
|---|
| | | //public String nameEncrypt; //zhj MEBG新方案改造 2022-11-29 |
|---|
| | | public String sfRecordId; |
|---|
| | | public String type; |
|---|
| | | //public String typeEncrypt; //zhj MEBG新方案改造 2022-11-29 |
|---|
| | | } |
|---|
| | | @AuraEnabled |
|---|
| | | public static String processDataAWSId(String fileData) { |
|---|
| | | System.debug('fileData:::' + filedata); |
|---|
| | | String errorMag = ''; |
|---|
| | | // 创建周报 |
|---|
| | | try { |
|---|
| | | if (fileData != null) { |
|---|
| | | String[] fileLines = new List<String>{}; |
|---|
| | | fileLines = fileData.split('\n'); |
|---|
| | | |
|---|
| | | // 经销商医院名称list |
|---|
| | | List<String> ahlNameList = new List<String>(); |
|---|
| | | //for content |
|---|
| | | system.debug('fileLines.size()==============>' + fileLines.size()); |
|---|
| | | for (Integer i = 1, j = fileLines.size(); i < j; i++) { |
|---|
| | | List<String> inputvalues = new List<String>(); |
|---|
| | | inputvalues = fileLines[i].split(','); |
|---|
| | | if (inputvalues != null) { |
|---|
| | | if (inputvalues[2] == '' || inputvalues[2] == null) { |
|---|
| | | errorMag += 'error1 第' + i + '行数据医院不能为空'; |
|---|
| | | } |
|---|
| | | ahlNameList.add(inputvalues[2]); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | system.debug(agency_report); |
|---|
| | | return agency_report; |
|---|
| | | } |
|---|
| | | // 经销商医院的ocsm医院id的list |
|---|
| | | List<String> ahlOcsmIdList = new List<String>(); |
|---|
| | | System.debug('ahlNameList = ' + ahlNameList); |
|---|
| | | List<Agency_Hospital_Link__c> ahlList = [ |
|---|
| | | SELECT id, name, Hospital__c, MaxActivityDate__c |
|---|
| | | FROM Agency_Hospital_Link__c |
|---|
| | | WHERE name = :ahlNameList AND Agency_Campaign_Obj__c = TRUE |
|---|
| | | ]; |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static String editAgencyReport(String Agency_Report_Id, String Department_Cateogy, String Purpose_Type,String SupportNeedsc, String Agency_Report_Header, |
|---|
| | | String Agency_Hospital, String Person_In_Charge2, String doctor, String Submit_date, |
|---|
| | | String Product_Category1, String Product_Category2, String Product_Category3, //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeeds__c ,String SupportNeedsc |
|---|
| | | String Result, String Opportunity, String StageName, String oppAmount, String oppOCMPrice, String Close_Forecasted_Date, String Report_Date) |
|---|
| | | { |
|---|
| | | if (String.isBlank(Agency_Report_Id)) { |
|---|
| | | return null; |
|---|
| | | }//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeeds__c ,SupportNeeds__c |
|---|
| | | // Agency_Report__c agency_report = [select Id, Name, Department_Cateogy__c, Purpose_Type__c,SupportNeeds__c, Agency_Hospital__c, |
|---|
| | | // Person_In_Charge2__c, doctor2__c, Submit_date__c, Product_Category__c, Result__c, visitor_title__c, Opportunity__c |
|---|
| | | // from Agency_Report__c where id=:Agency_Report_Id]; |
|---|
| | | |
|---|
| | | Agency_Report__c agency_report = new Agency_Report__c(); |
|---|
| | | if(Test.isRunningTest()){ |
|---|
| | | List<Agency_Report__c> agency_report_tests = [select Id, Name, Department_Cateogy__c, Purpose_Type__c,SupportNeeds__c, Agency_Hospital__c, |
|---|
| | | Person_In_Charge2__c, doctor2__c, Submit_date__c, Product_Category__c, Result__c, visitor_title__c, Opportunity__c |
|---|
| | | from Agency_Report__c limit 1]; |
|---|
| | | agency_report = agency_report_tests[0]; |
|---|
| | | }else { |
|---|
| | | agency_report = [select Id, Name, Department_Cateogy__c, Purpose_Type__c,SupportNeeds__c, Agency_Hospital__c, |
|---|
| | | Person_In_Charge2__c, doctor2__c, Submit_date__c, Product_Category__c, Result__c, visitor_title__c, Opportunity__c |
|---|
| | | from Agency_Report__c where id=:Agency_Report_Id]; |
|---|
| | | for (Agency_Hospital_Link__c ahl : ahlList) { |
|---|
| | | ahlOcsmIdList.add(ahl.Hospital__c); |
|---|
| | | } |
|---|
| | | |
|---|
| | | Date week = Date.valueOf(Submit_date); |
|---|
| | | agency_report.Submit_date__c = week; |
|---|
| | | Date reportDate = Date.valueOf(Report_Date); |
|---|
| | | agency_report.Report_Date__c = reportDate; |
|---|
| | | List<Agency_Contact__c> doctor2list = new List<Agency_Contact__c>(); |
|---|
| | | System.debug('ahlOcsmIdList = ' + ahlOcsmIdList); |
|---|
| | | if (!Test.isRunningTest()) |
|---|
| | | doctor2list = [ |
|---|
| | | SELECT |
|---|
| | | id, |
|---|
| | | Name, |
|---|
| | | Doctor_Division1__c, |
|---|
| | | Type__c, |
|---|
| | | Agency_Hospital__c, |
|---|
| | | AWS_Data_Id__c |
|---|
| | | FROM Agency_Contact__c |
|---|
| | | WHERE Hospital_ID18__c = :ahlOcsmIdList |
|---|
| | | ORDER BY Name |
|---|
| | | ]; //zhj 新方案改造 2022-12-21 去掉Name_Encrypted__c |
|---|
| | | |
|---|
| | | // MaxActivityDate__c 更新 |
|---|
| | | if (Person_In_Charge2 != '') { |
|---|
| | | agency_report.Person_In_Charge2__c = Person_In_Charge2; |
|---|
| | | //Contact contact = LightningUtil.selectContact(Person_In_Charge2)[0]; |
|---|
| | | //LightningUtil.updateAccMaxActivityDate(contact.AccountId, reportDate); |
|---|
| | | } else { |
|---|
| | | agency_report.Person_In_Charge2__c = null; |
|---|
| | | if (errorMag != '') { |
|---|
| | | return errorMag; |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (Agency_Hospital != '') { |
|---|
| | | LightningUtil.updateAccMaxActivityDate(Agency_Hospital, week); |
|---|
| | | } |
|---|
| | | system.debug('Purpose_Type+++==++==='+Purpose_Type); |
|---|
| | | // WRITE Agency Report__c |
|---|
| | | if (doctor != '') { agency_report.doctor2__c = doctor; } else { agency_report.doctor2__c = null; } |
|---|
| | | if (Department_Cateogy != '') { agency_report.Department_Cateogy__c = Department_Cateogy; } else { agency_report.Department_Cateogy__c = null; } |
|---|
| | | if (Purpose_Type != '') { agency_report.Purpose_Type__c = Purpose_Type; } else { agency_report.Purpose_Type__c = null; } |
|---|
| | | //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start SupportNeeds__c |
|---|
| | | if (SupportNeedsc != '') { agency_report.SupportNeeds__c = SupportNeedsc; } else { agency_report.SupportNeeds__c = null; } |
|---|
| | | if (Agency_Hospital != '') { agency_report.Agency_Hospital__c = Agency_Hospital; } else { agency_report.Agency_Hospital__c = null; } |
|---|
| | | if (Product_Category1 != '') { agency_report.Product_Category1__c = Product_Category1; } else { agency_report.Product_Category1__c = null; } |
|---|
| | | if (Product_Category2 != '') { agency_report.Product_Category2__c = Product_Category2; } else { agency_report.Product_Category2__c = null; } |
|---|
| | | if (Product_Category3 != '') { agency_report.Product_Category3__c = Product_Category3; } else { agency_report.Product_Category3__c = null; } |
|---|
| | | //if (Product_Category != '') { agency_report.Product_Category__c = Product_Category; } else { agency_report.Product_Category__c = null; } |
|---|
| | | if (Result != '') { agency_report.Result__c = Result; } else { agency_report.Result__c = null; } |
|---|
| | | //if (Opportunity != '') { agency_report.Opportunity__c = Opportunity; } else { agency_report.Opportunity__c = null; } |
|---|
| | | if (Opportunity != '') { |
|---|
| | | agency_report.Opportunity__c = Opportunity; |
|---|
| | | if (StageName != '' || oppAmount != '' || Close_Forecasted_Date != '' || oppOCMPrice != '') { |
|---|
| | | Agency_Opportunity__c aopp = [select Id, StageName__c, Amount__c, Close_Forecasted_Date__c from Agency_Opportunity__c where Id = :Opportunity]; |
|---|
| | | if (StageName != '') { |
|---|
| | | aopp.StageName__c = StageName; |
|---|
| | | } |
|---|
| | | if (String.isNotBlank(oppAmount)) { |
|---|
| | | Decimal amt = Decimal.valueOf(oppAmount); |
|---|
| | | aopp.Amount__c = amt; |
|---|
| | | } |
|---|
| | | if (String.isNotBlank(oppOCMPrice)) { |
|---|
| | | Decimal amt = Decimal.valueOf(oppOCMPrice); |
|---|
| | | aopp.OCMSale_Price__c = amt; |
|---|
| | | } |
|---|
| | | if (Close_Forecasted_Date != '') { |
|---|
| | | Date closeForecastedDate = Date.valueOf(Close_Forecasted_Date); |
|---|
| | | aopp.Close_Forecasted_Date__c = closeForecastedDate; |
|---|
| | | } |
|---|
| | | update aopp; |
|---|
| | | } |
|---|
| | | } else { agency_report.Opportunity__c = null; } |
|---|
| | | system.debug(agency_report); |
|---|
| | | |
|---|
| | | agency_report = LightningUtil.updateAgencyReport(agency_report); |
|---|
| | | |
|---|
| | | return agency_report.Id; |
|---|
| | | String doctor2listStr = JSON.serialize(doctor2list); |
|---|
| | | System.debug('doctor2listStr = ' + doctor2listStr); |
|---|
| | | return doctor2listStr; |
|---|
| | | } |
|---|
| | | } catch (Exception e) { |
|---|
| | | System.debug('exception' + e); |
|---|
| | | return e.getLineNumber() + 'exception:' + e; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Agency_Opportunity__c> selectOpportunityByIdAndHospitalLinkId(String opportunity_id, String agency_hospital_link_id) { |
|---|
| | | List<Agency_Opportunity__c> ret = new List<Agency_Opportunity__c>(); |
|---|
| | | |
|---|
| | | ret = LightningUtil.selectOpportunityByIdAndHospitalLinkId(opportunity_id, agency_hospital_link_id); |
|---|
| | | |
|---|
| | | return ret; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static WeeklyReportCmp getReports(String date_str, String person_str) { |
|---|
| | | WeeklyReportCmp li = new WeeklyReportCmp(); |
|---|
| | | li.get_reports(date_str, person_str); |
|---|
| | | return li; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public void get_reports(String date_str, String person_str) { |
|---|
| | | // 週報データを取得 |
|---|
| | | Date week = Date.valueOf(date_str); |
|---|
| | | this.reports = LightningUtil.selectAgencyReport(week, person_str); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Agency_Report__c> getReportsById(String report_id) { |
|---|
| | | List<Agency_Report__c> ret = new List<Agency_Report__c>(); |
|---|
| | | |
|---|
| | | ret = LightningUtil.selectAgencyReportById(report_id); |
|---|
| | | |
|---|
| | | return ret; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 批量添加周报by vivek start |
|---|
| | | @RemoteAction |
|---|
| | | @AuraEnabled |
|---|
| | | public static List<Agency_Report__c> getReportsByDate(String date1, String date2) { |
|---|
| | | Date date1_date = Date.valueOf(date1); |
|---|
| | | Date date2_date = Date.valueOf(date2); |
|---|
| | | WeeklyReportCmp li = new WeeklyReportCmp(); |
|---|
| | | // li.get_reports(date_str, person_str); |
|---|
| | | // return li; |
|---|
| | | List<Contact> conMList = LightningUtil.selectAgencyPerson(); |
|---|
| | | // LightningUtil.selectAgencyPerson(); |
|---|
| | | |
|---|
| | | System.debug('====='+conMList); |
|---|
| | | // List<Agency_Report__c> reportlist = [Select Id, Name, Report_Date__c, Product_Category1__r.Name, Product_Category2__r.Name, Product_Category3__r.Name, Product_Category1__c, Product_Category2__c, Product_Category3__c, Department_Cateogy__c, Purpose_Type__c, Agency_Report_Header__c, Agency_Hospital__r.Name, Agency_Hospital__r.Hospital__c, OppName__c, |
|---|
| | | // Person_In_Charge2__c, Person_In_Charge2__r.Name, doctor2__c, doctor2__r.Name, Submit_date__c, |
|---|
| | | // Product_Category__c, Product_Category__r.Name, Result__c, visitor_title__c, Opportunity__c, Opportunity__r.Name |
|---|
| | | // From Agency_Report__c |
|---|
| | | // where Person_In_Charge2__c in :conMList and Report_Date__c >= :date1_date and Report_Date__c <= :date2_date ]; |
|---|
| | | // return reportlist; |
|---|
| | | return LightningUtil.selectMAgencyReport(date1_date, date2_date, conMList); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public List<contact> selectMAgencyPerson() { |
|---|
| | | String login_user_id = UserInfo.getUserId(); |
|---|
| | | // return [select id, Name, Agency_User__c from contact where Agency_User__c = true and Isactive__c = '有效' and AccountId in (select AccountId from User where id=:login_user_id)]; |
|---|
| | | // return [select id, Name, Agency_User__c from contact where Agency_User__c = true and AccountId in (select AccountId from User where id=:login_user_id)]; |
|---|
| | | return [select id, Name, Agency_User__c from contact]; |
|---|
| | | } |
|---|
| | | // fy 导入 20220424 start |
|---|
| | | public class GeDatass { |
|---|
| | | public String dataId; |
|---|
| | | public String doctorDivision1; |
|---|
| | | //public String doctorDivision1Encrypt; //zhj MEBG新方案改造 2022-11-29 |
|---|
| | | public Integer isDelete; |
|---|
| | | public String name; |
|---|
| | | //public String nameEncrypt; //zhj MEBG新方案改造 2022-11-29 |
|---|
| | | public String sfRecordId; |
|---|
| | | public String type; |
|---|
| | | //public String typeEncrypt; //zhj MEBG新方案改造 2022-11-29 |
|---|
| | | } |
|---|
| | | @AuraEnabled |
|---|
| | | public static String processDataAWSId(String fileData) { |
|---|
| | | System.debug('fileData:::'+filedata); |
|---|
| | | String errorMag = ''; |
|---|
| | | // 创建周报 |
|---|
| | | try{ |
|---|
| | | if(fileData!=null){ |
|---|
| | | String[] fileLines = new String[]{}; |
|---|
| | | fileLines = fileData.split('\n'); |
|---|
| | | |
|---|
| | | // 经销商医院名称list |
|---|
| | | List<String> ahlNameList = new List<String>(); |
|---|
| | | //for content |
|---|
| | | system.debug('fileLines.size()==============>'+fileLines.size()); |
|---|
| | | for (Integer i=1,j=fileLines.size();i<j;i++){ |
|---|
| | | List<String> inputvalues = new List<String>(); |
|---|
| | | inputvalues = fileLines[i].split(','); |
|---|
| | | if(inputvalues != null){ |
|---|
| | | if(inputvalues[2] == '' || inputvalues[2] == null){ |
|---|
| | | errorMag += 'error1 第'+i+'行数据医院不能为空'; |
|---|
| | | } |
|---|
| | | ahlNameList.add(inputvalues[2]); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | // 经销商医院的ocsm医院id的list |
|---|
| | | List<String> ahlOcsmIdList = new List<String>(); |
|---|
| | | System.debug('ahlNameList = ' + ahlNameList); |
|---|
| | | List<Agency_Hospital_Link__c> ahlList = [select id,name,Hospital__c,MaxActivityDate__c from Agency_Hospital_Link__c where name = :ahlNameList and Agency_Campaign_Obj__c = true]; |
|---|
| | | |
|---|
| | | System.debug('ahlList.size() = ' + ahlList.size()); |
|---|
| | | for(Agency_Hospital_Link__c ahl : ahlList){ |
|---|
| | | ahlOcsmIdList.add(ahl.Hospital__c); |
|---|
| | | } |
|---|
| | | List<Agency_Contact__c> doctor2list = new List<Agency_Contact__c>(); |
|---|
| | | System.debug('ahlOcsmIdList = ' + ahlOcsmIdList); |
|---|
| | | if(!Test.isRunningTest()) |
|---|
| | | doctor2list = [select id,Name,Doctor_Division1__c,Type__c,Agency_Hospital__c,AWS_Data_Id__c FROM Agency_Contact__c WHERE Hospital_ID18__c= :ahlOcsmIdList order by Name]; //zhj 新方案改造 2022-12-21 去掉Name_Encrypted__c |
|---|
| | | |
|---|
| | | if(errorMag != ''){ |
|---|
| | | return errorMag; |
|---|
| | | } |
|---|
| | | String doctor2listStr = JSON.serialize(doctor2list); |
|---|
| | | System.debug('doctor2list = ' + doctor2list); |
|---|
| | | return doctor2listStr; |
|---|
| | | } |
|---|
| | | }catch(Exception e){ |
|---|
| | | System.debug('exception'+e); |
|---|
| | | return e.getLineNumber()+'exception:'+e; |
|---|
| | | } |
|---|
| | | return 'success'; |
|---|
| | | } |
|---|
| | | // fy 导入 20220424 end |
|---|
| | | @AuraEnabled// fy 导入 20220424 start String sobjectName,List<String> fields, |
|---|
| | | // public static String processData(String fileData,String Agency_ContactListjson) { |
|---|
| | | public static String processData(String fileData,String sobjectName,List<String> fields) { |
|---|
| | | DateTime now =System.now(); |
|---|
| | | System.debug('当前时间:::'+now); |
|---|
| | | System.debug('fileData:::'+filedata); |
|---|
| | | System.debug('sobjectName:::'+sobjectName); |
|---|
| | | System.debug('fields:::'+fields); |
|---|
| | | return 'success'; |
|---|
| | | } |
|---|
| | | // fy 导入 20220424 end |
|---|
| | | @AuraEnabled // fy 导入 20220424 start String sobjectName,List<String> fields, |
|---|
| | | // public static String processData(String fileData,String Agency_ContactListjson) { |
|---|
| | | public static String processData( |
|---|
| | | String fileData, |
|---|
| | | String sobjectName, |
|---|
| | | List<String> fields |
|---|
| | | ) { |
|---|
| | | DateTime now = System.now(); |
|---|
| | | System.debug('当前时间:::' + now); |
|---|
| | | System.debug('fileData:::' + filedata); |
|---|
| | | System.debug('sobjectName:::' + sobjectName); |
|---|
| | | System.debug('fields:::' + fields); |
|---|
| | | // System.debug('Agency_ContactListjson::::'+Agency_ContactListjson); |
|---|
| | | String errorMag = ''; |
|---|
| | | String errorMag = ''; |
|---|
| | | |
|---|
| | | // 创建周报 |
|---|
| | | try{ |
|---|
| | | |
|---|
| | | if(fileData!=null){ |
|---|
| | | // List<GeDatass> Agency_ContactList = (List<GeDatass>)JSON.deserialize(Agency_ContactListjson,List<GeDatass>.class); |
|---|
| | | // System.debug('Agency_ContactList::::'+Agency_ContactList); |
|---|
| | | // Map<String,String> Agency_ContactMap = new Map<String,String>(); |
|---|
| | | // for(GeDatass agconobj :Agency_ContactList){ |
|---|
| | | // Agency_ContactMap.put(agconobj.name.replace(' ',''),agconobj.dataId); |
|---|
| | | // } |
|---|
| | | String[] fileLines = new String[]{}; |
|---|
| | | fileLines = fileData.split('\n'); |
|---|
| | | // 担当名称的list |
|---|
| | | List<String> nameList = new List<String>(); |
|---|
| | | // 报告日的list |
|---|
| | | List<Date> dateList = new List<Date>(); |
|---|
| | | // List<String> s_dateList = new List<String>(); |
|---|
| | | // 导入的数据 |
|---|
| | | List<List<String>> inputList = new List<List<String>>(); |
|---|
| | | // 经销商医院名称list |
|---|
| | | List<String> ahlNameList = new List<String>(); |
|---|
| | | // 科室Set |
|---|
| | | Set<String> departmentSet = new Set<String>(); |
|---|
| | | // 经销商询价名称list |
|---|
| | | // List<String> ahlOppNameList = new List<String>(); |
|---|
| | | //for content |
|---|
| | | system.debug('fileLines.size()==============>'+fileLines.size()); |
|---|
| | | for (Integer i=1,j=fileLines.size();i<j;i++){ |
|---|
| | | system.debug('for2022161329'); |
|---|
| | | List<String> inputvalues = new List<String>(); |
|---|
| | | inputvalues = fileLines[i].split(','); |
|---|
| | | System.debug('inputvalues++'+inputvalues); |
|---|
| | | if(inputvalues != null){ |
|---|
| | | system.debug('if2022161333'); |
|---|
| | | if(inputvalues[0] == '' || inputvalues[0] == null){ |
|---|
| | | // return 'error1 第'+i+'行数据担当不能为空'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据担当不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if(inputvalues[1] == '' || inputvalues[1] == null){ |
|---|
| | | // return 'error1 第'+i+'行数据活动日不能为空'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据活动日不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | //SWAG-C7AASP 【委托】DAMS系统周报补录时间调整 2022-1-10 pk start |
|---|
| | | List<String> R = new List<String>(); |
|---|
| | | R = inputvalues[1].split('/'); |
|---|
| | | system.debug('R202216'+R); |
|---|
| | | Date rDate = Date.newInstance(Integer.Valueof(R[0]),Integer.Valueof(R[1]),Integer.Valueof(R[2])); |
|---|
| | | system.debug('rDate202216'+rDate); |
|---|
| | | Date start = Date.today().addMonths(-1); |
|---|
| | | Date startDay = start.toStartOfWeek(); |
|---|
| | | Date firstDayOfweek = System.today().toStartOfWeek(); |
|---|
| | | Date endDay = firstDayOfweek.addDays(6); |
|---|
| | | if(rDate > endDay || rDate < startDay){ |
|---|
| | | system.debug('rDate >= ssDate'); |
|---|
| | | // return 'error1 第'+i+'行数据活动日不能为空'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据,导入周报仅可补报最近一月周报'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | //SWAG-C7AASP 【委托】DAMS系统周报补录时间调整 2022-1-10 pk end |
|---|
| | | if(inputvalues[2] == '' || inputvalues[2] == null){ |
|---|
| | | // return 'error1 第'+i+'行数据医院不能为空'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据医院不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if(inputvalues[3] == '' || inputvalues[3] == null){ |
|---|
| | | // return 'error1 第'+i+'行数据科室不能为空'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据科室不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | String departmentstr = GetDepartment_Cateogy(inputvalues[3]); |
|---|
| | | if(departmentstr == 'no' && inputvalues[3] != '' && inputvalues[3] != null){ |
|---|
| | | // return 'error3 第'+i+'行数据科室选项列表的值'+inputvalues[3]+'不存在'; |
|---|
| | | errorMag += 'error3 第'+i+'行数据科室选项列表的值'+inputvalues[3]+'不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if(inputvalues[4] == '' || inputvalues[4] == null){ |
|---|
| | | // return 'error1 第'+i+'行数据拜访人不能为空'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据拜访人不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if(inputvalues[5] == '' || inputvalues[5] == null){ |
|---|
| | | // return 'error1 第'+i+'行数据产品区分1不能为空'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据产品区分1不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if((inputvalues[6] != '' && inputvalues[6] != null)&& inputvalues[5] == inputvalues[6]){ |
|---|
| | | // return 'error1 第'+i+'行数据产品区分1和产品区分2的值不能重复'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据产品区分1和产品区分2的值不能重复'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if((inputvalues[7] != '' && inputvalues[7] != null)&& inputvalues[5] == inputvalues[7]){ |
|---|
| | | |
|---|
| | | |
|---|
| | | // return 'error1 第'+i+'行数据产品区分1和产品区分3的值不能重复'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据产品区分1和产品区分3的值不能重复'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if((inputvalues[6] != '' && inputvalues[6] != null) && (inputvalues[7] != '' && inputvalues[7] != null) && inputvalues[6] == inputvalues[7]){ |
|---|
| | | // return 'error1 第'+i+'行数据产品区分2和产品区分3的值不能重复'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据产品区分2和产品区分3的值不能重复'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if(inputvalues[8] == '' || inputvalues[8] == null){ |
|---|
| | | // return 'error1 第'+i+'行数据活动区分不能为空'; |
|---|
| | | errorMag += 'error1 第'+i+'行数据活动区分不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | boolean purposeType = GetPurposeType(inputvalues[8]); |
|---|
| | | if(!purposeType && inputvalues[8] != '' && inputvalues[8] != null){ |
|---|
| | | // return 'error3 第'+i+'行数据活动区分选项列表的值'+inputvalues[8]+'不存在'; |
|---|
| | | errorMag += 'error3 第'+i+'行数据活动区分选项列表的值'+inputvalues[8]+'不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | // if(inputvalues[9] == '\r' || inputvalues[9] == null){ |
|---|
| | | // return 'error1 结果不能为空'; |
|---|
| | | // } |
|---|
| | | if(inputvalues[8] == '询价挖掘-OPD' || inputvalues[8] == '询价挖掘-SIS' || inputvalues[8] == '询价推进-OPD' || inputvalues[8] == '询价推进-SIS'){ |
|---|
| | | System.debug(']]]]]1'+inputvalues[9]+'====='); |
|---|
| | | if(inputvalues[9] == '\r'){ |
|---|
| | | |
|---|
| | | // return 'error5 第'+i+'行数据当活动区分为'+inputvalues[8]+'结果不能为空'; |
|---|
| | | errorMag += 'error5 第'+i+'行数据当活动区分为'+inputvalues[8]+'结果不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | // if(inputvalues[9] != '\r' && getResultlist(inputvalues[9])){ |
|---|
| | | if(inputvalues[9] != '' && getResultlist(inputvalues[9])){ |
|---|
| | | // return 'error3 第'+i+'行数据结果选项列表的值'+inputvalues[9]+'不存在'; |
|---|
| | | errorMag += 'error3 第'+i+'行数据结果选项列表的值'+inputvalues[9]+'不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | system.debug('inputvalues[0]=================>'+inputvalues[0]); |
|---|
| | | system.debug('inputvalues[1]=================>'+inputvalues[1]); |
|---|
| | | system.debug('inputvalues[2]=================>'+inputvalues[2]); |
|---|
| | | system.debug('inputvalues[3]=================>'+inputvalues[3]); |
|---|
| | | system.debug('inputvalues[4]=================>'+inputvalues[4]); |
|---|
| | | system.debug('inputvalues[5]=================>'+inputvalues[5]); |
|---|
| | | system.debug('inputvalues[6]=================>'+inputvalues[6]); |
|---|
| | | system.debug('inputvalues[7]=================>'+inputvalues[7]); |
|---|
| | | system.debug('inputvalues[8]=================>'+inputvalues[8]); |
|---|
| | | system.debug('inputvalues[9]=================>'+inputvalues[9]); |
|---|
| | | // system.debug('inputvalues[10]=================>'+inputvalues[10]); |
|---|
| | | |
|---|
| | | |
|---|
| | | nameList.add(inputvalues[0]); |
|---|
| | | dateList.add(Date.valueOf(inputvalues[1].replace('/','-'))); |
|---|
| | | ahlNameList.add(inputvalues[2]); |
|---|
| | | departmentSet.add('%'+GetDepartment_Cateogy(inputvalues[3])+'%'+'-'+GetEPurposeType(inputvalues[8])); |
|---|
| | | inputList.add(inputvalues); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | system.debug('snduksbdnjsvbdskjv'); |
|---|
| | | // 担当名称匹配的map |
|---|
| | | Map<String,String> nameIdMap = new Map<String,String>(); |
|---|
| | | Map<String,String> nameConMap = new Map<String,String>(); |
|---|
| | | // 经销商医院名称匹配的map |
|---|
| | | Map<String,Agency_Hospital_Link__c> ahlMap = new Map<String,Agency_Hospital_Link__c>(); |
|---|
| | | // 产品区分的map |
|---|
| | | Map<String,String> protypeMap = new Map<String,String>(); |
|---|
| | | // 经销商医院的ocsm医院id的list |
|---|
| | | List<String> ahlOcsmIdList = new List<String>(); |
|---|
| | | // 经销商医院id的List |
|---|
| | | List<String> ahlIdList = new List<String>(); |
|---|
| | | // 获取每周第一天的map |
|---|
| | | Map<Date,Date> dateMap = new Map<Date,Date>(); |
|---|
| | | // 根据日期获取olympus日历id的map |
|---|
| | | Map<Date,String> dateIdMap = new Map<Date,String>(); |
|---|
| | | // 根据经销商医院的ocsm医院获取的所有.客户人员的信息的名称和id的map |
|---|
| | | Map<String,String> doctor2Map = new Map<String,String>(); |
|---|
| | | // 经销商询价的map |
|---|
| | | Map<String,Agency_Opportunity__c> aoMap = new Map<String,Agency_Opportunity__c>(); |
|---|
| | | // 科室和产品区分关系map |
|---|
| | | Map<String,List<Map<String,String>>> impProMap = new Map<String,List<Map<String,String>>>(); |
|---|
| | | impProMap = getImplProductList(departmentSet); |
|---|
| | | System.debug('---===---===---==='+impProMap); |
|---|
| | | // return nameList[0]; |
|---|
| | | // List<Contact> conList = [select id,name from Contact where name = :nameList]; |
|---|
| | | // List<Contact> conList = [select id,name from Contact]; |
|---|
| | | List<Contact> conList = LightningUtil.selectAgencyPerson(); |
|---|
| | | System.debug('---===---===---====='+conList); |
|---|
| | | List<OlympusCalendar__c> olympusDateList = [select Id,Date__c,FirstDayOfWeek__c,DayOfTheWeek__c from OlympusCalendar__c where Date__c= :dateList ]; |
|---|
| | | // test用 |
|---|
| | | // String testuse = ''; |
|---|
| | | // testuse += '====='+ahlNameList; |
|---|
| | | List<Agency_Hospital_Link__c> ahlList = [select id,name,Hospital__c,MaxActivityDate__c from Agency_Hospital_Link__c where name = :ahlNameList and Agency_Campaign_Obj__c = true]; |
|---|
| | | // List<Agency_Hospital_Link__c> ahlList = [select id,name,Hospital__c,MaxActivityDate__c from Agency_Hospital_Link__c ]; |
|---|
| | | // List<ProductTypes__c> proTypeList = [select id,name from ProductTypes__c]; |
|---|
| | | for(OlympusCalendar__c olym : olympusDateList){ |
|---|
| | | if(olym.DayOfTheWeek__c == 'Sun'){ |
|---|
| | | dateMap.put(olym.Date__c, olym.Date__c.addDays(1)); |
|---|
| | | } |
|---|
| | | else{ |
|---|
| | | dateMap.put(olym.Date__c, olym.FirstDayOfWeek__c); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | System.debug('x'+dateMap); |
|---|
| | | List<OlympusCalendar__c> olympusIdList = [select Id,Date__c,FirstDayOfWeek__c from OlympusCalendar__c where Date__c= :dateMap.values()]; |
|---|
| | | for(OlympusCalendar__c olym : olympusIdList){ |
|---|
| | | dateIdMap.put(olym.FirstDayOfWeek__c, olym.id); |
|---|
| | | } |
|---|
| | | System.debug('dateIdMap===='+dateIdMap); |
|---|
| | | for(Contact con :conList){ |
|---|
| | | nameIdMap.put(con.Name.replace(' ',''), con.Id); |
|---|
| | | nameConMap.put(con.Id, con.Name); |
|---|
| | | } |
|---|
| | | // testuse += '======'+ahlList; |
|---|
| | | // return testuse; |
|---|
| | | for(Agency_Hospital_Link__c ahl : ahlList){ |
|---|
| | | ahlMap.put(ahl.Name, ahl); |
|---|
| | | ahlOcsmIdList.add(ahl.Hospital__c); |
|---|
| | | ahlIdList.add(ahl.Id); |
|---|
| | | } |
|---|
| | | // for(ProductTypes__c protype : proTypeList){ |
|---|
| | | // protypeMap.put(protype.Name, protype.Id); |
|---|
| | | // } |
|---|
| | | //fy 20220424 start AWS_Data_Id__c |
|---|
| | | if(!Test.isRunningTest()){ |
|---|
| | | List<Agency_Contact__c> doctor2list = [select id,Name,Doctor_Division1__c,Type__c,Agency_Hospital__c,AWS_Data_Id__c FROM Agency_Contact__c WHERE Hospital_ID18__c= :ahlOcsmIdList order by Name]; //zhj 新方案改造 2022-12-21 去掉Name_Encrypted__c |
|---|
| | | for(Agency_Contact__c ac : doctor2list){ |
|---|
| | | //fy 20220424 start |
|---|
| | | // doctor2Map.put(ac.AWS_Data_Id__c, ac.Id); |
|---|
| | | // doctor2Map.put(ac.Name.replace(' ',''), ac.Id); |
|---|
| | | //doctor2Map.put(ac.Name_Encrypted__c, ac.Id); |
|---|
| | | doctor2Map.put(ac.AWS_Data_Id__c, ac.Id); //zhj 新方案改造 不再存的nameEncrpt而是awsdataid 2022-12-21 |
|---|
| | | //fy 20220424 end |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | // List<Agency_Opportunity__c> aoList = [select id,name,StageName__c,Amount__c,OCMSale_Price__c,Close_Forecasted_Date__c,Agency_Hospital__c from Agency_Opportunity__c where Agency_Hospital__c = :ahlIdList and name = :ahlOppNameList]; |
|---|
| | | // for(Agency_Opportunity__c ao : aoList){ |
|---|
| | | // aoMap.put(ao.Name, ao); |
|---|
| | | // } |
|---|
| | | System.debug('nameIdMap===='+nameIdMap); |
|---|
| | | // 创建周报 |
|---|
| | | List<Agency_Report_Header__c> agency_report_headerlist = new List<Agency_Report_Header__c>(); |
|---|
| | | Map<String,Agency_Report_Header__c> agency_report_headerMap = new Map<String,Agency_Report_Header__c>(); |
|---|
| | | for(List<String> lineList :inputList){ |
|---|
| | | Date week = Date.today(); |
|---|
| | | String s_agency = null; |
|---|
| | | String s_agencyname = null; |
|---|
| | | System.debug('dateMap===='+dateMap); |
|---|
| | | // System.debug('lineList[0]====不等于空'+lineList[1]); |
|---|
| | | if(dateMap.get(Date.valueOf(lineList[1].replace('/','-'))) != null){ |
|---|
| | | System.debug('dateMap====不等于空'); |
|---|
| | | week = dateMap.get(Date.valueOf(lineList[1].replace('/','-'))); |
|---|
| | | System.debug('===='+week); |
|---|
| | | } |
|---|
| | | System.debug('lineList[0].replace()'+lineList[0].replace(' ','')); |
|---|
| | | if(nameIdMap.get(lineList[0].replace(' ','')) != null){ |
|---|
| | | System.debug('nameIdMap====不等于空'); |
|---|
| | | s_agency = nameIdMap.get(lineList[0].replace(' ','')); |
|---|
| | | s_agencyname = nameConMap.get(nameIdMap.get(lineList[0].replace(' ',''))); |
|---|
| | | System.debug('===='+s_agency); |
|---|
| | | } |
|---|
| | | // if(s_agency == null || s_agencyname == null){ |
|---|
| | | // // return 'error0 担当 '+lineList[0]+'填写不正确'; |
|---|
| | | // errorMag += 'error0 担当 '+lineList[0]+'不存在'; |
|---|
| | | // errorMag += '='; |
|---|
| | | // } |
|---|
| | | Agency_Report_Header__c agency_report_header = new Agency_Report_Header__c(); |
|---|
| | | // agency_report_header.Name = lineList[0] + ' (' + week.format() + ')'; |
|---|
| | | agency_report_header.Name = s_agencyname + ' (' + week.format().replace('/','-') + ')'; |
|---|
| | | agency_report_header.HeaderInputKey__c = createHeader(week,s_agency); |
|---|
| | | agency_report_header.Week__c = week; |
|---|
| | | agency_report_header.Agency_Person2__c = s_agency; |
|---|
| | | if(dateIdMap.containsKey(week)){ |
|---|
| | | agency_report_header.OlympusDate__c = dateIdMap.get(week); |
|---|
| | | } |
|---|
| | | if(s_agencyname != null && s_agencyname != '' && s_agencyname != 'null'){ |
|---|
| | | agency_report_headerMap.put(agency_report_header.HeaderInputKey__c, agency_report_header); |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | agency_report_headerlist = agency_report_headerMap.values(); |
|---|
| | | System.debug('==========='+agency_report_headerlist+''); |
|---|
| | | // upsert agency_report_headerlist Agency_Report_Header__c.HeaderInputKey__c; |
|---|
| | | if(agency_report_headerlist.size() > 0){ |
|---|
| | | LightningUtil.upsertMAgencyReportHeader(agency_report_headerlist); |
|---|
| | | } |
|---|
| | | |
|---|
| | | List<Agency_Report__c> arList = new List<Agency_Report__c>(); |
|---|
| | | Integer hang = 1; |
|---|
| | | for(List<String> lineList :inputList){ |
|---|
| | | // 创建周报明细 |
|---|
| | | Date week = null; |
|---|
| | | String s_agency = null; |
|---|
| | | System.debug('dateMap===='+dateMap); |
|---|
| | | System.debug('lineList[0]====不等于空'+lineList[1]); |
|---|
| | | if(dateMap.get(Date.valueOf(lineList[1].replace('/','-'))) != null){ |
|---|
| | | System.debug('dateMap====不等于空'); |
|---|
| | | week = dateMap.get(Date.valueOf(lineList[1].replace('/','-'))); |
|---|
| | | System.debug('===='+week); |
|---|
| | | } |
|---|
| | | if(nameIdMap.get(lineList[0].replace(' ','')) != null){ |
|---|
| | | System.debug('nameIdMap====不等于空'); |
|---|
| | | s_agency = nameIdMap.get(lineList[0].replace(' ','')); |
|---|
| | | System.debug('===='+s_agency); |
|---|
| | | } |
|---|
| | | |
|---|
| | | Agency_Report__c agencyReport = new Agency_Report__c(); |
|---|
| | | if(week == null && lineList[1] != '' && lineList[1] != null){ |
|---|
| | | // return 'error2 第'+hang+'行数据报告日'+lineList[1]+'填写有误'; |
|---|
| | | errorMag += 'error2 第'+hang+'行数据报告日'+lineList[1]+'填写有误'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | agencyReport.Submit_date__c = week; // 提出周 |
|---|
| | | if((s_agency == null || s_agency == '')&& lineList[0] != '' && lineList[0] != null){ |
|---|
| | | // return 'error2 第'+hang+'行数据担当'+lineList[0]+'不存在'; |
|---|
| | | errorMag += 'error2 第'+hang+'行数据担当'+lineList[0]+'不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | agencyReport.Person_In_Charge2__c = s_agency; // 担当 |
|---|
| | | if(lineList[1] != null && lineList[1] != ''){ |
|---|
| | | agencyReport.Report_Date__c = Date.valueOf(lineList[1].replace('/','-')); // 活动日 |
|---|
| | | } |
|---|
| | | if(ahlMap.containsKey(lineList[2])){ |
|---|
| | | agencyReport.Agency_Hospital__c = ahlMap.get(lineList[2]).Id; //经销商医院 |
|---|
| | | // 更新经销商医院的最新周 |
|---|
| | | ahlMap.get(lineList[2]).MaxActivityDate__c = week; |
|---|
| | | }else{ |
|---|
| | | if(lineList[2] != '' && lineList[2] != null){ |
|---|
| | | |
|---|
| | | // return 'error2 第'+hang+'行数据经销商医院'+lineList[2]+'不存在'; |
|---|
| | | errorMag += 'error2 第'+hang+'行数据经销商医院'+lineList[2]+'不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | String departmentE = GetDepartment_Cateogy(lineList[3]); |
|---|
| | | if(departmentE != 'no'){ |
|---|
| | | agencyReport.Department_Cateogy__c = departmentE; // 科室 |
|---|
| | | }else{ |
|---|
| | | // return 'error2 第'+hang+'行数据科室'+lineList[3]+'不存在'; |
|---|
| | | // errorMag += 'error2 第'+hang+'行数据科室'+lineList[3]+'不存在'; |
|---|
| | | // errorMag += '='; |
|---|
| | | } |
|---|
| | | //fy 20220424 start |
|---|
| | | // if(doctor2Map.containsKey(lineList[4].replace(' ',''))){ |
|---|
| | | if(doctor2Map.containsKey(lineList[4])){ |
|---|
| | | // if(Agency_ContactMap.containsKey(lineList[4].replace(' ',''))){ |
|---|
| | | // if(doctor2Map.containsKey(Agency_ContactMap.get(lineList[4].replace(' ','')))){ |
|---|
| | | // agencyReport.doctor2__c = doctor2Map.get(lineList[4].replace(' ','')); // 拜访人 |
|---|
| | | agencyReport.doctor2__c = doctor2Map.get(lineList[4]); // 拜访人 |
|---|
| | | // agencyReport.doctor2__c = doctor2Map.get(Agency_ContactMap.get(lineList[4].replace(' ',''))); // 拜访人 |
|---|
| | | // } |
|---|
| | | }else{ |
|---|
| | | if(lineList[4] != '' && lineList[4] != null){ |
|---|
| | | // return 'error2 第'+hang+'行数据拜访人'+lineList[4]+'不存在'; |
|---|
| | | errorMag += 'error2 第'+hang+'行数据拜访人'+lineList[4]+'不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | if(GetPurposeType(lineList[8])){ |
|---|
| | | agencyReport.Purpose_Type__c = lineList[8]; // 活动区分 |
|---|
| | | }else{ |
|---|
| | | // return 'error3 第'+hang+'行数据活动区分选项列表值'+lineList[8]+'不存在'; |
|---|
| | | // errorMag += 'error3 第'+hang+'行数据活动区分选项列表值'+lineList[8]+'不存在'; |
|---|
| | | // errorMag += '='; |
|---|
| | | } |
|---|
| | | // 科室产品区分关系判断 |
|---|
| | | // 如果能找到，就是正确的 |
|---|
| | | String departandprokey = '%'+GetDepartment_Cateogy(lineList[3])+'%'+'-'+GetEPurposeType(lineList[8]); |
|---|
| | | System.debug('---===---===---==='+departandprokey); |
|---|
| | | if(impProMap.containsKey(departandprokey)){ |
|---|
| | | System.debug('---===---===---==='+ifTrueProduct(impProMap.get(departandprokey),lineList[5])); |
|---|
| | | if(ifTrueProduct(impProMap.get(departandprokey),lineList[5]) != ''){ |
|---|
| | | System.debug(']]]不等于空进入'); |
|---|
| | | agencyReport.Product_Category1__c = ifTrueProduct(impProMap.get(departandprokey),lineList[5]); |
|---|
| | | }else{ |
|---|
| | | System.debug(']]]等于空进入'); |
|---|
| | | // return 'error4 第'+hang+'行数据产品区分1的赋值不正确'+lineList[5]; |
|---|
| | | errorMag += 'error4 第'+hang+'行数据产品区分1的赋值不正确'+lineList[5]; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if(lineList[6] != '' && lineList[6] != null){ |
|---|
| | | if(ifTrueProduct(impProMap.get(departandprokey),lineList[6]) != ''){ |
|---|
| | | agencyReport.Product_Category2__c = ifTrueProduct(impProMap.get(departandprokey),lineList[6]); |
|---|
| | | }else{ |
|---|
| | | // return 'error4 第'+hang+'行数据产品区分2的赋值不正确'+lineList[6]; |
|---|
| | | errorMag += 'error4 第'+hang+'行数据产品区分2的赋值不正确'+lineList[6]; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if(lineList[7] != '' && lineList[7] != null){ |
|---|
| | | if(ifTrueProduct(impProMap.get(departandprokey),lineList[7]) != ''){ |
|---|
| | | agencyReport.Product_Category3__c = ifTrueProduct(impProMap.get(departandprokey),lineList[7]); |
|---|
| | | }else{ |
|---|
| | | // return 'error4 第'+hang+'行数据产品区分3的赋值不正确'+lineList[7]; |
|---|
| | | errorMag += 'error4 第'+hang+'行数据产品区分3的赋值不正确'+lineList[7]; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | // 通过map 科室，产品区分名 判断取值是否符合要求 |
|---|
| | | // if(protypeMap.containsKey(lineList[5])){ |
|---|
| | | // agencyReport.Product_Category1__c = protypeMap.get(lineList[5]);// 产品区分1 |
|---|
| | | // } |
|---|
| | | // if(protypeMap.containsKey(lineList[6])){ |
|---|
| | | // agencyReport.Product_Category2__c = protypeMap.get(lineList[6]);// 产品区分2 |
|---|
| | | // } |
|---|
| | | // if(protypeMap.containsKey(lineList[7])){ |
|---|
| | | // agencyReport.Product_Category3__c = protypeMap.get(lineList[7]);// 产品区分3 |
|---|
| | | // } |
|---|
| | | agencyReport.Result__c = lineList[9]; |
|---|
| | | if(lineList.size()==11){ |
|---|
| | | if(lineList[10] != null && lineList[10] != ''){ |
|---|
| | | agencyReport.SupportNeeds__c = lineList[10]; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | String headerStr = createHeader(week,s_agency); |
|---|
| | | if(agency_report_headerMap.containsKey(headerStr)){ |
|---|
| | | agencyReport.Agency_Report_Header__c = agency_report_headerMap.get(headerStr).Id; // 周报一览 |
|---|
| | | } |
|---|
| | | // if(aoMap.containsKey(lineList[6])){ |
|---|
| | | // agencyReport.Opportunity__c = aoMap.get(lineList[6]).Id; // 经销商询价 |
|---|
| | | // // 经销商询价更新字段 |
|---|
| | | // aoMap.get(lineList[6]).StageName__c = lineList[5]; // 询价阶段 |
|---|
| | | // aoMap.get(lineList[6]).Amount__c = Decimal.valueOf(lineList[6]); // 医院采购预算(含税,元) |
|---|
| | | // aoMap.get(lineList[6]).OCMSale_Price__c = Decimal.valueOf(lineList[7]); // 订货金额(含税,元) |
|---|
| | | // aoMap.get(lineList[6]).Close_Forecasted_Date__c = Date.valueOf(lineList[8].replace('/','-')); // 预测于OLY签约日 |
|---|
| | | // } |
|---|
| | | hang++; |
|---|
| | | arList.add(agencyReport); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if(errorMag != ''){ |
|---|
| | | return errorMag; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 更新经销商意愿的最新周 |
|---|
| | | if(ahlMap.values().size() > 0 ){ |
|---|
| | | update ahlMap.values(); |
|---|
| | | } |
|---|
| | | // 更新经销商询价 |
|---|
| | | // if(aoMap.values().size() > 0 ){ |
|---|
| | | // update aoMap.values(); |
|---|
| | | // } |
|---|
| | | // 新增周报明细 |
|---|
| | | if(arList.size() > 0 ){ |
|---|
| | | // insert arList; |
|---|
| | | LightningUtil.insertMAgencyReport(arList); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | // 创建周报 |
|---|
| | | try { |
|---|
| | | if (fileData != null) { |
|---|
| | | // List<GeDatass> Agency_ContactList = (List<GeDatass>)JSON.deserialize(Agency_ContactListjson,List<GeDatass>.class); |
|---|
| | | // System.debug('Agency_ContactList::::'+Agency_ContactList); |
|---|
| | | // Map<String,String> Agency_ContactMap = new Map<String,String>(); |
|---|
| | | // for(GeDatass agconobj :Agency_ContactList){ |
|---|
| | | // Agency_ContactMap.put(agconobj.name.replace(' ',''),agconobj.dataId); |
|---|
| | | // } |
|---|
| | | String[] fileLines = new List<String>{}; |
|---|
| | | fileLines = fileData.split('\n'); |
|---|
| | | // 担当名称的list |
|---|
| | | List<String> nameList = new List<String>(); |
|---|
| | | // 报告日的list |
|---|
| | | List<Date> dateList = new List<Date>(); |
|---|
| | | // List<String> s_dateList = new List<String>(); |
|---|
| | | // 导入的数据 |
|---|
| | | List<List<String>> inputList = new List<List<String>>(); |
|---|
| | | // 经销商医院名称list |
|---|
| | | List<String> ahlNameList = new List<String>(); |
|---|
| | | // 科室Set |
|---|
| | | Set<String> departmentSet = new Set<String>(); |
|---|
| | | // 经销商询价名称list |
|---|
| | | // List<String> ahlOppNameList = new List<String>(); |
|---|
| | | //for content |
|---|
| | | system.debug('fileLines.size()==============>' + fileLines.size()); |
|---|
| | | for (Integer i = 1, j = fileLines.size(); i < j; i++) { |
|---|
| | | system.debug('for2022161329'); |
|---|
| | | List<String> inputvalues = new List<String>(); |
|---|
| | | inputvalues = fileLines[i].split(','); |
|---|
| | | System.debug('inputvalues++' + inputvalues); |
|---|
| | | if (inputvalues != null) { |
|---|
| | | system.debug('if2022161333'); |
|---|
| | | if (inputvalues[0] == '' || inputvalues[0] == null) { |
|---|
| | | // return 'error1 第'+i+'行数据担当不能为空'; |
|---|
| | | errorMag += 'error1 第' + i + '行数据担当不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | return 'success'; |
|---|
| | | }catch(Exception e){ |
|---|
| | | System.debug('exception'+e); |
|---|
| | | return e.getLineNumber()+'exception:'+e; |
|---|
| | | } |
|---|
| | | return 'success'; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 创建唯一键 |
|---|
| | | public static String createHeader(Date s_date,String nameid){ |
|---|
| | | String str = s_date.format(); |
|---|
| | | String str1 = str.replace('/', ''); |
|---|
| | | return nameid+':'+str1; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 科室对应翻译 |
|---|
| | | public static String GetDepartment_Cateogy(String department){ |
|---|
| | | String departmentE = 'no'; |
|---|
| | | if(department == '呼吸科'){ |
|---|
| | | departmentE = 'BF'; |
|---|
| | | } |
|---|
| | | if(department == '耳鼻喉科'){ |
|---|
| | | departmentE = 'ENT'; |
|---|
| | | } |
|---|
| | | if(department == 'ET耗材'){ |
|---|
| | | departmentE = 'ET'; |
|---|
| | | } |
|---|
| | | if(department == '消化科'){ |
|---|
| | | departmentE = 'GI'; |
|---|
| | | } |
|---|
| | | if(department == '普外科'){ |
|---|
| | | departmentE = 'GS'; |
|---|
| | | } |
|---|
| | | if(department == '妇科'){ |
|---|
| | | departmentE = 'GYN'; |
|---|
| | | } |
|---|
| | | if(department == '其他'){ |
|---|
| | | departmentE = 'OTH'; |
|---|
| | | } |
|---|
| | | if(department == '泌尿科'){ |
|---|
| | | departmentE = 'URO'; |
|---|
| | | } |
|---|
| | | return departmentE; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 判断活动分区是否存在 |
|---|
| | | public static boolean GetPurposeType(String purposeType){ |
|---|
| | | Schema.DescribeFieldResult fieldResult = Agency_Report__c.Purpose_Type__c.getDescribe(); |
|---|
| | | List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues(); |
|---|
| | | for( Schema.PicklistEntry pickListVal : ple){ |
|---|
| | | if(pickListVal.getValue() == purposeType){ |
|---|
| | | return true; |
|---|
| | | if (inputvalues[1] == '' || inputvalues[1] == null) { |
|---|
| | | // return 'error1 第'+i+'行数据活动日不能为空'; |
|---|
| | | errorMag += 'error1 第' + i + '行数据活动日不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | return false; |
|---|
| | | } |
|---|
| | | public static boolean getResultlist(String resultlist){ |
|---|
| | | system.debug('resultlist===============>'+resultlist); |
|---|
| | | Schema.DescribeFieldResult fieldResult = Agency_Report__c.Result__c.getDescribe(); |
|---|
| | | List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues(); |
|---|
| | | for( Schema.PicklistEntry pickListVal : ple){ |
|---|
| | | System.debug('weixiao'+resultlist.trim()+'111111'+pickListVal.getValue()+'222222'); |
|---|
| | | string temp = string.ValueOf(pickListVal.getValue()); |
|---|
| | | if(temp.equals(resultlist.trim())){ |
|---|
| | | // if(pickListVal.getValue().equals(resultlist)){ |
|---|
| | | System.debug('weixiaoweixiao'+resultlist+''+pickListVal.getValue()); |
|---|
| | | return false; |
|---|
| | | //SWAG-C7AASP 【委托】DAMS系统周报补录时间调整 2022-1-10 pk start |
|---|
| | | List<String> R = new List<String>(); |
|---|
| | | R = inputvalues[1].split('/'); |
|---|
| | | system.debug('R202216' + R); |
|---|
| | | Date rDate = Date.newInstance( |
|---|
| | | Integer.Valueof(R[0]), |
|---|
| | | Integer.Valueof(R[1]), |
|---|
| | | Integer.Valueof(R[2]) |
|---|
| | | ); |
|---|
| | | system.debug('rDate202216' + rDate); |
|---|
| | | Date start = Date.today().addMonths(-1); |
|---|
| | | Date startDay = start.toStartOfWeek(); |
|---|
| | | Date firstDayOfweek = System.today().toStartOfWeek(); |
|---|
| | | Date endDay = firstDayOfweek.addDays(6); |
|---|
| | | if (rDate > endDay || rDate < startDay) { |
|---|
| | | system.debug('rDate >= ssDate'); |
|---|
| | | // return 'error1 第'+i+'行数据活动日不能为空'; |
|---|
| | | errorMag += |
|---|
| | | 'error1 第' + |
|---|
| | | i + |
|---|
| | | '行数据,导入周报仅可补报最近一月周报'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | //SWAG-C7AASP 【委托】DAMS系统周报补录时间调整 2022-1-10 pk end |
|---|
| | | if (inputvalues[2] == '' || inputvalues[2] == null) { |
|---|
| | | // return 'error1 第'+i+'行数据医院不能为空'; |
|---|
| | | errorMag += 'error1 第' + i + '行数据医院不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if (inputvalues[3] == '' || inputvalues[3] == null) { |
|---|
| | | // return 'error1 第'+i+'行数据科室不能为空'; |
|---|
| | | errorMag += 'error1 第' + i + '行数据科室不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | String departmentstr = GetDepartment_Cateogy(inputvalues[3]); |
|---|
| | | if ( |
|---|
| | | departmentstr == 'no' && |
|---|
| | | inputvalues[3] != '' && |
|---|
| | | inputvalues[3] != null |
|---|
| | | ) { |
|---|
| | | // return 'error3 第'+i+'行数据科室选项列表的值'+inputvalues[3]+'不存在'; |
|---|
| | | errorMag += |
|---|
| | | 'error3 第' + |
|---|
| | | i + |
|---|
| | | '行数据科室选项列表的值' + |
|---|
| | | inputvalues[3] + |
|---|
| | | '不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if (inputvalues[4] == '' || inputvalues[4] == null) { |
|---|
| | | // return 'error1 第'+i+'行数据拜访人不能为空'; |
|---|
| | | errorMag += 'error1 第' + i + '行数据拜访人不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if (inputvalues[5] == '' || inputvalues[5] == null) { |
|---|
| | | // return 'error1 第'+i+'行数据产品区分1不能为空'; |
|---|
| | | errorMag += 'error1 第' + i + '行数据产品区分1不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if ( |
|---|
| | | (inputvalues[6] != '' && inputvalues[6] != null) && |
|---|
| | | inputvalues[5] == inputvalues[6] |
|---|
| | | ) { |
|---|
| | | // return 'error1 第'+i+'行数据产品区分1和产品区分2的值不能重复'; |
|---|
| | | errorMag += |
|---|
| | | 'error1 第' + |
|---|
| | | i + |
|---|
| | | '行数据产品区分1和产品区分2的值不能重复'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if ( |
|---|
| | | (inputvalues[7] != '' && inputvalues[7] != null) && |
|---|
| | | inputvalues[5] == inputvalues[7] |
|---|
| | | ) { |
|---|
| | | // return 'error1 第'+i+'行数据产品区分1和产品区分3的值不能重复'; |
|---|
| | | errorMag += |
|---|
| | | 'error1 第' + |
|---|
| | | i + |
|---|
| | | '行数据产品区分1和产品区分3的值不能重复'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if ( |
|---|
| | | (inputvalues[6] != '' && |
|---|
| | | inputvalues[6] != null) && |
|---|
| | | (inputvalues[7] != '' && |
|---|
| | | inputvalues[7] != null) && |
|---|
| | | inputvalues[6] == inputvalues[7] |
|---|
| | | ) { |
|---|
| | | // return 'error1 第'+i+'行数据产品区分2和产品区分3的值不能重复'; |
|---|
| | | errorMag += |
|---|
| | | 'error1 第' + |
|---|
| | | i + |
|---|
| | | '行数据产品区分2和产品区分3的值不能重复'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if (inputvalues[8] == '' || inputvalues[8] == null) { |
|---|
| | | // return 'error1 第'+i+'行数据活动区分不能为空'; |
|---|
| | | errorMag += 'error1 第' + i + '行数据活动区分不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | boolean purposeType = GetPurposeType(inputvalues[8]); |
|---|
| | | if ( |
|---|
| | | !purposeType && |
|---|
| | | inputvalues[8] != '' && |
|---|
| | | inputvalues[8] != null |
|---|
| | | ) { |
|---|
| | | // return 'error3 第'+i+'行数据活动区分选项列表的值'+inputvalues[8]+'不存在'; |
|---|
| | | errorMag += |
|---|
| | | 'error3 第' + |
|---|
| | | i + |
|---|
| | | '行数据活动区分选项列表的值' + |
|---|
| | | inputvalues[8] + |
|---|
| | | '不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | // if(inputvalues[9] == '\r' || inputvalues[9] == null){ |
|---|
| | | // return 'error1 结果不能为空'; |
|---|
| | | // } |
|---|
| | | if ( |
|---|
| | | inputvalues[8] == '询价挖掘-OPD' || |
|---|
| | | inputvalues[8] == '询价挖掘-SIS' || |
|---|
| | | inputvalues[8] == '询价推进-OPD' || |
|---|
| | | inputvalues[8] == '询价推进-SIS' |
|---|
| | | ) { |
|---|
| | | System.debug(']]]]]1' + inputvalues[9] + '====='); |
|---|
| | | if (inputvalues[9] == '\r') { |
|---|
| | | // return 'error5 第'+i+'行数据当活动区分为'+inputvalues[8]+'结果不能为空'; |
|---|
| | | errorMag += |
|---|
| | | 'error5 第' + |
|---|
| | | i + |
|---|
| | | '行数据当活动区分为' + |
|---|
| | | inputvalues[8] + |
|---|
| | | '结果不能为空'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | // if(inputvalues[9] != '\r' && getResultlist(inputvalues[9])){ |
|---|
| | | if (inputvalues[9] != '' && getResultlist(inputvalues[9])) { |
|---|
| | | // return 'error3 第'+i+'行数据结果选项列表的值'+inputvalues[9]+'不存在'; |
|---|
| | | errorMag += |
|---|
| | | 'error3 第' + |
|---|
| | | i + |
|---|
| | | '行数据结果选项列表的值' + |
|---|
| | | inputvalues[9] + |
|---|
| | | '不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | system.debug('inputvalues[0]=================>' + inputvalues[0]); |
|---|
| | | system.debug('inputvalues[1]=================>' + inputvalues[1]); |
|---|
| | | system.debug('inputvalues[2]=================>' + inputvalues[2]); |
|---|
| | | system.debug('inputvalues[3]=================>' + inputvalues[3]); |
|---|
| | | system.debug('inputvalues[4]=================>' + inputvalues[4]); |
|---|
| | | system.debug('inputvalues[5]=================>' + inputvalues[5]); |
|---|
| | | system.debug('inputvalues[6]=================>' + inputvalues[6]); |
|---|
| | | system.debug('inputvalues[7]=================>' + inputvalues[7]); |
|---|
| | | system.debug('inputvalues[8]=================>' + inputvalues[8]); |
|---|
| | | system.debug('inputvalues[9]=================>' + inputvalues[9]); |
|---|
| | | // system.debug('inputvalues[10]=================>'+inputvalues[10]); |
|---|
| | | |
|---|
| | | nameList.add(inputvalues[0]); |
|---|
| | | dateList.add(Date.valueOf(inputvalues[1].replace('/', '-'))); |
|---|
| | | ahlNameList.add(inputvalues[2]); |
|---|
| | | departmentSet.add( |
|---|
| | | '%' + |
|---|
| | | GetDepartment_Cateogy(inputvalues[3]) + |
|---|
| | | '%' + |
|---|
| | | '-' + |
|---|
| | | GetEPurposeType(inputvalues[8]) |
|---|
| | | ); |
|---|
| | | inputList.add(inputvalues); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | system.debug('snduksbdnjsvbdskjv'); |
|---|
| | | // 担当名称匹配的map |
|---|
| | | Map<String, String> nameIdMap = new Map<String, String>(); |
|---|
| | | Map<String, String> nameConMap = new Map<String, String>(); |
|---|
| | | // 经销商医院名称匹配的map |
|---|
| | | Map<String, Agency_Hospital_Link__c> ahlMap = new Map<String, Agency_Hospital_Link__c>(); |
|---|
| | | // 产品区分的map |
|---|
| | | Map<String, String> protypeMap = new Map<String, String>(); |
|---|
| | | // 经销商医院的ocsm医院id的list |
|---|
| | | List<String> ahlOcsmIdList = new List<String>(); |
|---|
| | | // 经销商医院id的List |
|---|
| | | List<String> ahlIdList = new List<String>(); |
|---|
| | | // 获取每周第一天的map |
|---|
| | | Map<Date, Date> dateMap = new Map<Date, Date>(); |
|---|
| | | // 根据日期获取olympus日历id的map |
|---|
| | | Map<Date, String> dateIdMap = new Map<Date, String>(); |
|---|
| | | // 根据经销商医院的ocsm医院获取的所有.客户人员的信息的名称和id的map |
|---|
| | | Map<String, String> doctor2Map = new Map<String, String>(); |
|---|
| | | // 经销商询价的map |
|---|
| | | Map<String, Agency_Opportunity__c> aoMap = new Map<String, Agency_Opportunity__c>(); |
|---|
| | | // 科室和产品区分关系map |
|---|
| | | Map<String, List<Map<String, String>>> impProMap = new Map<String, List<Map<String, String>>>(); |
|---|
| | | impProMap = getImplProductList(departmentSet); |
|---|
| | | System.debug('---===---===---===' + impProMap); |
|---|
| | | // return nameList[0]; |
|---|
| | | // List<Contact> conList = [select id,name from Contact where name = :nameList]; |
|---|
| | | // List<Contact> conList = [select id,name from Contact]; |
|---|
| | | List<Contact> conList = LightningUtil.selectAgencyPerson(); |
|---|
| | | System.debug('---===---===---=====' + conList); |
|---|
| | | List<OlympusCalendar__c> olympusDateList = [ |
|---|
| | | SELECT Id, Date__c, FirstDayOfWeek__c, DayOfTheWeek__c |
|---|
| | | FROM OlympusCalendar__c |
|---|
| | | WHERE Date__c = :dateList |
|---|
| | | ]; |
|---|
| | | // test用 |
|---|
| | | // String testuse = ''; |
|---|
| | | // testuse += '====='+ahlNameList; |
|---|
| | | List<Agency_Hospital_Link__c> ahlList = [ |
|---|
| | | SELECT id, name, Hospital__c, MaxActivityDate__c |
|---|
| | | FROM Agency_Hospital_Link__c |
|---|
| | | WHERE name = :ahlNameList AND Agency_Campaign_Obj__c = TRUE |
|---|
| | | ]; |
|---|
| | | // List<Agency_Hospital_Link__c> ahlList = [select id,name,Hospital__c,MaxActivityDate__c from Agency_Hospital_Link__c ]; |
|---|
| | | // List<ProductTypes__c> proTypeList = [select id,name from ProductTypes__c]; |
|---|
| | | for (OlympusCalendar__c olym : olympusDateList) { |
|---|
| | | if (olym.DayOfTheWeek__c == 'Sun') { |
|---|
| | | dateMap.put(olym.Date__c, olym.Date__c.addDays(1)); |
|---|
| | | } else { |
|---|
| | | dateMap.put(olym.Date__c, olym.FirstDayOfWeek__c); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | System.debug('x' + dateMap); |
|---|
| | | List<OlympusCalendar__c> olympusIdList = [ |
|---|
| | | SELECT Id, Date__c, FirstDayOfWeek__c |
|---|
| | | FROM OlympusCalendar__c |
|---|
| | | WHERE Date__c = :dateMap.values() |
|---|
| | | ]; |
|---|
| | | for (OlympusCalendar__c olym : olympusIdList) { |
|---|
| | | dateIdMap.put(olym.FirstDayOfWeek__c, olym.id); |
|---|
| | | } |
|---|
| | | System.debug('dateIdMap====' + dateIdMap); |
|---|
| | | for (Contact con : conList) { |
|---|
| | | nameIdMap.put(con.Name.replace(' ', ''), con.Id); |
|---|
| | | nameConMap.put(con.Id, con.Name); |
|---|
| | | } |
|---|
| | | // testuse += '======'+ahlList; |
|---|
| | | // return testuse; |
|---|
| | | for (Agency_Hospital_Link__c ahl : ahlList) { |
|---|
| | | ahlMap.put(ahl.Name, ahl); |
|---|
| | | ahlOcsmIdList.add(ahl.Hospital__c); |
|---|
| | | ahlIdList.add(ahl.Id); |
|---|
| | | } |
|---|
| | | // for(ProductTypes__c protype : proTypeList){ |
|---|
| | | // protypeMap.put(protype.Name, protype.Id); |
|---|
| | | // } |
|---|
| | | //fy 20220424 start AWS_Data_Id__c |
|---|
| | | if (!Test.isRunningTest()) { |
|---|
| | | List<Agency_Contact__c> doctor2list = [ |
|---|
| | | SELECT |
|---|
| | | id, |
|---|
| | | Name, |
|---|
| | | Doctor_Division1__c, |
|---|
| | | Type__c, |
|---|
| | | Agency_Hospital__c, |
|---|
| | | AWS_Data_Id__c |
|---|
| | | FROM Agency_Contact__c |
|---|
| | | WHERE Hospital_ID18__c = :ahlOcsmIdList |
|---|
| | | ORDER BY Name |
|---|
| | | ]; //zhj 新方案改造 2022-12-21 去掉Name_Encrypted__c |
|---|
| | | for (Agency_Contact__c ac : doctor2list) { |
|---|
| | | //fy 20220424 start |
|---|
| | | // doctor2Map.put(ac.AWS_Data_Id__c, ac.Id); |
|---|
| | | // doctor2Map.put(ac.Name.replace(' ',''), ac.Id); |
|---|
| | | //doctor2Map.put(ac.Name_Encrypted__c, ac.Id); |
|---|
| | | doctor2Map.put(ac.AWS_Data_Id__c, ac.Id); //zhj 新方案改造 不再存的nameEncrpt而是awsdataid 2022-12-21 |
|---|
| | | //fy 20220424 end |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | // List<Agency_Opportunity__c> aoList = [select id,name,StageName__c,Amount__c,OCMSale_Price__c,Close_Forecasted_Date__c,Agency_Hospital__c from Agency_Opportunity__c where Agency_Hospital__c = :ahlIdList and name = :ahlOppNameList]; |
|---|
| | | // for(Agency_Opportunity__c ao : aoList){ |
|---|
| | | // aoMap.put(ao.Name, ao); |
|---|
| | | // } |
|---|
| | | System.debug('nameIdMap====' + nameIdMap); |
|---|
| | | // 创建周报 |
|---|
| | | List<Agency_Report_Header__c> agency_report_headerlist = new List<Agency_Report_Header__c>(); |
|---|
| | | Map<String, Agency_Report_Header__c> agency_report_headerMap = new Map<String, Agency_Report_Header__c>(); |
|---|
| | | for (List<String> lineList : inputList) { |
|---|
| | | Date week = Date.today(); |
|---|
| | | String s_agency = null; |
|---|
| | | String s_agencyname = null; |
|---|
| | | System.debug('dateMap====' + dateMap); |
|---|
| | | // System.debug('lineList[0]====不等于空'+lineList[1]); |
|---|
| | | if ( |
|---|
| | | dateMap.get(Date.valueOf(lineList[1].replace('/', '-'))) != null |
|---|
| | | ) { |
|---|
| | | System.debug('dateMap====不等于空'); |
|---|
| | | week = dateMap.get(Date.valueOf(lineList[1].replace('/', '-'))); |
|---|
| | | System.debug('====' + week); |
|---|
| | | } |
|---|
| | | System.debug('lineList[0].replace()' + lineList[0].replace(' ', '')); |
|---|
| | | if (nameIdMap.get(lineList[0].replace(' ', '')) != null) { |
|---|
| | | System.debug('nameIdMap====不等于空'); |
|---|
| | | s_agency = nameIdMap.get(lineList[0].replace(' ', '')); |
|---|
| | | s_agencyname = nameConMap.get( |
|---|
| | | nameIdMap.get(lineList[0].replace(' ', '')) |
|---|
| | | ); |
|---|
| | | System.debug('====' + s_agency); |
|---|
| | | } |
|---|
| | | // if(s_agency == null || s_agencyname == null){ |
|---|
| | | // // return 'error0 担当 '+lineList[0]+'填写不正确'; |
|---|
| | | // errorMag += 'error0 担当 '+lineList[0]+'不存在'; |
|---|
| | | // errorMag += '='; |
|---|
| | | // } |
|---|
| | | Agency_Report_Header__c agency_report_header = new Agency_Report_Header__c(); |
|---|
| | | // agency_report_header.Name = lineList[0] + ' (' + week.format() + ')'; |
|---|
| | | agency_report_header.Name = |
|---|
| | | s_agencyname + |
|---|
| | | ' (' + |
|---|
| | | week.format().replace('/', '-') + |
|---|
| | | ')'; |
|---|
| | | agency_report_header.HeaderInputKey__c = createHeader(week, s_agency); |
|---|
| | | agency_report_header.Week__c = week; |
|---|
| | | agency_report_header.Agency_Person2__c = s_agency; |
|---|
| | | if (dateIdMap.containsKey(week)) { |
|---|
| | | agency_report_header.OlympusDate__c = dateIdMap.get(week); |
|---|
| | | } |
|---|
| | | if ( |
|---|
| | | s_agencyname != null && |
|---|
| | | s_agencyname != '' && |
|---|
| | | s_agencyname != 'null' |
|---|
| | | ) { |
|---|
| | | agency_report_headerMap.put( |
|---|
| | | agency_report_header.HeaderInputKey__c, |
|---|
| | | agency_report_header |
|---|
| | | ); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | agency_report_headerlist = agency_report_headerMap.values(); |
|---|
| | | System.debug('===========' + agency_report_headerlist + ''); |
|---|
| | | // upsert agency_report_headerlist Agency_Report_Header__c.HeaderInputKey__c; |
|---|
| | | if (agency_report_headerlist.size() > 0) { |
|---|
| | | LightningUtil.upsertMAgencyReportHeader(agency_report_headerlist); |
|---|
| | | } |
|---|
| | | |
|---|
| | | List<Agency_Report__c> arList = new List<Agency_Report__c>(); |
|---|
| | | Integer hang = 1; |
|---|
| | | for (List<String> lineList : inputList) { |
|---|
| | | // 创建周报明细 |
|---|
| | | Date week = null; |
|---|
| | | String s_agency = null; |
|---|
| | | System.debug('dateMap====' + dateMap); |
|---|
| | | System.debug('lineList[0]====不等于空' + lineList[1]); |
|---|
| | | if ( |
|---|
| | | dateMap.get(Date.valueOf(lineList[1].replace('/', '-'))) != null |
|---|
| | | ) { |
|---|
| | | System.debug('dateMap====不等于空'); |
|---|
| | | week = dateMap.get(Date.valueOf(lineList[1].replace('/', '-'))); |
|---|
| | | System.debug('====' + week); |
|---|
| | | } |
|---|
| | | if (nameIdMap.get(lineList[0].replace(' ', '')) != null) { |
|---|
| | | System.debug('nameIdMap====不等于空'); |
|---|
| | | s_agency = nameIdMap.get(lineList[0].replace(' ', '')); |
|---|
| | | System.debug('====' + s_agency); |
|---|
| | | } |
|---|
| | | |
|---|
| | | Agency_Report__c agencyReport = new Agency_Report__c(); |
|---|
| | | if (week == null && lineList[1] != '' && lineList[1] != null) { |
|---|
| | | // return 'error2 第'+hang+'行数据报告日'+lineList[1]+'填写有误'; |
|---|
| | | errorMag += |
|---|
| | | 'error2 第' + |
|---|
| | | hang + |
|---|
| | | '行数据报告日' + |
|---|
| | | lineList[1] + |
|---|
| | | '填写有误'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | agencyReport.Submit_date__c = week; // 提出周 |
|---|
| | | if ( |
|---|
| | | (s_agency == null || |
|---|
| | | s_agency == '') && |
|---|
| | | lineList[0] != '' && |
|---|
| | | lineList[0] != null |
|---|
| | | ) { |
|---|
| | | // return 'error2 第'+hang+'行数据担当'+lineList[0]+'不存在'; |
|---|
| | | errorMag += |
|---|
| | | 'error2 第' + |
|---|
| | | hang + |
|---|
| | | '行数据担当' + |
|---|
| | | lineList[0] + |
|---|
| | | '不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | agencyReport.Person_In_Charge2__c = s_agency; // 担当 |
|---|
| | | if (lineList[1] != null && lineList[1] != '') { |
|---|
| | | agencyReport.Report_Date__c = Date.valueOf( |
|---|
| | | lineList[1].replace('/', '-') |
|---|
| | | ); // 活动日 |
|---|
| | | } |
|---|
| | | if (ahlMap.containsKey(lineList[2])) { |
|---|
| | | agencyReport.Agency_Hospital__c = ahlMap.get(lineList[2]).Id; //经销商医院 |
|---|
| | | // 更新经销商医院的最新周 |
|---|
| | | ahlMap.get(lineList[2]).MaxActivityDate__c = week; |
|---|
| | | } else { |
|---|
| | | if (lineList[2] != '' && lineList[2] != null) { |
|---|
| | | // return 'error2 第'+hang+'行数据经销商医院'+lineList[2]+'不存在'; |
|---|
| | | errorMag += |
|---|
| | | 'error2 第' + |
|---|
| | | hang + |
|---|
| | | '行数据经销商医院' + |
|---|
| | | lineList[2] + |
|---|
| | | '不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | String departmentE = GetDepartment_Cateogy(lineList[3]); |
|---|
| | | if (departmentE != 'no') { |
|---|
| | | agencyReport.Department_Cateogy__c = departmentE; // 科室 |
|---|
| | | } else { |
|---|
| | | // return 'error2 第'+hang+'行数据科室'+lineList[3]+'不存在'; |
|---|
| | | // errorMag += 'error2 第'+hang+'行数据科室'+lineList[3]+'不存在'; |
|---|
| | | // errorMag += '='; |
|---|
| | | } |
|---|
| | | //fy 20220424 start |
|---|
| | | // if(doctor2Map.containsKey(lineList[4].replace(' ',''))){ |
|---|
| | | if (doctor2Map.containsKey(lineList[4])) { |
|---|
| | | // if(Agency_ContactMap.containsKey(lineList[4].replace(' ',''))){ |
|---|
| | | // if(doctor2Map.containsKey(Agency_ContactMap.get(lineList[4].replace(' ','')))){ |
|---|
| | | // agencyReport.doctor2__c = doctor2Map.get(lineList[4].replace(' ','')); // 拜访人 |
|---|
| | | agencyReport.doctor2__c = doctor2Map.get(lineList[4]); // 拜访人 |
|---|
| | | // agencyReport.doctor2__c = doctor2Map.get(Agency_ContactMap.get(lineList[4].replace(' ',''))); // 拜访人 |
|---|
| | | // } |
|---|
| | | } else { |
|---|
| | | if (lineList[4] != '' && lineList[4] != null) { |
|---|
| | | // return 'error2 第'+hang+'行数据拜访人'+lineList[4]+'不存在'; |
|---|
| | | errorMag += |
|---|
| | | 'error2 第' + |
|---|
| | | hang + |
|---|
| | | '行数据拜访人' + |
|---|
| | | lineList[4] + |
|---|
| | | '不存在'; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (GetPurposeType(lineList[8])) { |
|---|
| | | agencyReport.Purpose_Type__c = lineList[8]; // 活动区分 |
|---|
| | | } else { |
|---|
| | | // return 'error3 第'+hang+'行数据活动区分选项列表值'+lineList[8]+'不存在'; |
|---|
| | | // errorMag += 'error3 第'+hang+'行数据活动区分选项列表值'+lineList[8]+'不存在'; |
|---|
| | | // errorMag += '='; |
|---|
| | | } |
|---|
| | | // 科室产品区分关系判断 |
|---|
| | | // 如果能找到，就是正确的 |
|---|
| | | String departandprokey = |
|---|
| | | '%' + |
|---|
| | | GetDepartment_Cateogy(lineList[3]) + |
|---|
| | | '%' + |
|---|
| | | '-' + |
|---|
| | | GetEPurposeType(lineList[8]); |
|---|
| | | System.debug('---===---===---===' + departandprokey); |
|---|
| | | if (impProMap.containsKey(departandprokey)) { |
|---|
| | | System.debug( |
|---|
| | | '---===---===---===' + |
|---|
| | | ifTrueProduct(impProMap.get(departandprokey), lineList[5]) |
|---|
| | | ); |
|---|
| | | if ( |
|---|
| | | ifTrueProduct(impProMap.get(departandprokey), lineList[5]) != '' |
|---|
| | | ) { |
|---|
| | | System.debug(']]]不等于空进入'); |
|---|
| | | agencyReport.Product_Category1__c = ifTrueProduct( |
|---|
| | | impProMap.get(departandprokey), |
|---|
| | | lineList[5] |
|---|
| | | ); |
|---|
| | | } else { |
|---|
| | | System.debug(']]]等于空进入'); |
|---|
| | | // return 'error4 第'+hang+'行数据产品区分1的赋值不正确'+lineList[5]; |
|---|
| | | errorMag += |
|---|
| | | 'error4 第' + |
|---|
| | | hang + |
|---|
| | | '行数据产品区分1的赋值不正确' + |
|---|
| | | lineList[5]; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | if (lineList[6] != '' && lineList[6] != null) { |
|---|
| | | if ( |
|---|
| | | ifTrueProduct(impProMap.get(departandprokey), lineList[6]) != '' |
|---|
| | | ) { |
|---|
| | | agencyReport.Product_Category2__c = ifTrueProduct( |
|---|
| | | impProMap.get(departandprokey), |
|---|
| | | lineList[6] |
|---|
| | | ); |
|---|
| | | } else { |
|---|
| | | // return 'error4 第'+hang+'行数据产品区分2的赋值不正确'+lineList[6]; |
|---|
| | | errorMag += |
|---|
| | | 'error4 第' + |
|---|
| | | hang + |
|---|
| | | '行数据产品区分2的赋值不正确' + |
|---|
| | | lineList[6]; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if (lineList[7] != '' && lineList[7] != null) { |
|---|
| | | if ( |
|---|
| | | ifTrueProduct(impProMap.get(departandprokey), lineList[7]) != '' |
|---|
| | | ) { |
|---|
| | | agencyReport.Product_Category3__c = ifTrueProduct( |
|---|
| | | impProMap.get(departandprokey), |
|---|
| | | lineList[7] |
|---|
| | | ); |
|---|
| | | } else { |
|---|
| | | // return 'error4 第'+hang+'行数据产品区分3的赋值不正确'+lineList[7]; |
|---|
| | | errorMag += |
|---|
| | | 'error4 第' + |
|---|
| | | hang + |
|---|
| | | '行数据产品区分3的赋值不正确' + |
|---|
| | | lineList[7]; |
|---|
| | | errorMag += '='; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 通过map 科室，产品区分名 判断取值是否符合要求 |
|---|
| | | // if(protypeMap.containsKey(lineList[5])){ |
|---|
| | | // agencyReport.Product_Category1__c = protypeMap.get(lineList[5]);// 产品区分1 |
|---|
| | | // } |
|---|
| | | // if(protypeMap.containsKey(lineList[6])){ |
|---|
| | | // agencyReport.Product_Category2__c = protypeMap.get(lineList[6]);// 产品区分2 |
|---|
| | | // } |
|---|
| | | // if(protypeMap.containsKey(lineList[7])){ |
|---|
| | | // agencyReport.Product_Category3__c = protypeMap.get(lineList[7]);// 产品区分3 |
|---|
| | | // } |
|---|
| | | agencyReport.Result__c = lineList[9]; |
|---|
| | | if (lineList.size() == 11) { |
|---|
| | | if (lineList[10] != null && lineList[10] != '') { |
|---|
| | | agencyReport.SupportNeeds__c = lineList[10]; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | String headerStr = createHeader(week, s_agency); |
|---|
| | | if (agency_report_headerMap.containsKey(headerStr)) { |
|---|
| | | agencyReport.Agency_Report_Header__c = agency_report_headerMap.get( |
|---|
| | | headerStr |
|---|
| | | ) |
|---|
| | | .Id; // 周报一览 |
|---|
| | | } |
|---|
| | | // if(aoMap.containsKey(lineList[6])){ |
|---|
| | | // agencyReport.Opportunity__c = aoMap.get(lineList[6]).Id; // 经销商询价 |
|---|
| | | // // 经销商询价更新字段 |
|---|
| | | // aoMap.get(lineList[6]).StageName__c = lineList[5]; // 询价阶段 |
|---|
| | | // aoMap.get(lineList[6]).Amount__c = Decimal.valueOf(lineList[6]); // 医院采购预算(含税,元) |
|---|
| | | // aoMap.get(lineList[6]).OCMSale_Price__c = Decimal.valueOf(lineList[7]); // 订货金额(含税,元) |
|---|
| | | // aoMap.get(lineList[6]).Close_Forecasted_Date__c = Date.valueOf(lineList[8].replace('/','-')); // 预测于OLY签约日 |
|---|
| | | // } |
|---|
| | | hang++; |
|---|
| | | arList.add(agencyReport); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (errorMag != '') { |
|---|
| | | return errorMag; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 更新经销商意愿的最新周 |
|---|
| | | if (ahlMap.values().size() > 0) { |
|---|
| | | update ahlMap.values(); |
|---|
| | | } |
|---|
| | | // 更新经销商询价 |
|---|
| | | // if(aoMap.values().size() > 0 ){ |
|---|
| | | // update aoMap.values(); |
|---|
| | | // } |
|---|
| | | // 新增周报明细 |
|---|
| | | if (arList.size() > 0) { |
|---|
| | | // insert arList; |
|---|
| | | LightningUtil.insertMAgencyReport(arList); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | return 'success'; |
|---|
| | | } catch (Exception e) { |
|---|
| | | System.debug('exception' + e); |
|---|
| | | return e.getLineNumber() + 'exception:' + e; |
|---|
| | | } |
|---|
| | | return 'success'; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 创建唯一键 |
|---|
| | | public static String createHeader(Date s_date, String nameid) { |
|---|
| | | String str = s_date.format(); |
|---|
| | | String str1 = str.replace('/', ''); |
|---|
| | | return nameid + ':' + str1; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 科室对应翻译 |
|---|
| | | public static String GetDepartment_Cateogy(String department) { |
|---|
| | | String departmentE = 'no'; |
|---|
| | | if (department == '呼吸科') { |
|---|
| | | departmentE = 'BF'; |
|---|
| | | } |
|---|
| | | if (department == '耳鼻喉科') { |
|---|
| | | departmentE = 'ENT'; |
|---|
| | | } |
|---|
| | | if (department == 'ET耗材') { |
|---|
| | | departmentE = 'ET'; |
|---|
| | | } |
|---|
| | | if (department == '消化科') { |
|---|
| | | departmentE = 'GI'; |
|---|
| | | } |
|---|
| | | if (department == '普外科') { |
|---|
| | | departmentE = 'GS'; |
|---|
| | | } |
|---|
| | | if (department == '妇科') { |
|---|
| | | departmentE = 'GYN'; |
|---|
| | | } |
|---|
| | | if (department == '其他') { |
|---|
| | | departmentE = 'OTH'; |
|---|
| | | } |
|---|
| | | if (department == '泌尿科') { |
|---|
| | | departmentE = 'URO'; |
|---|
| | | } |
|---|
| | | return departmentE; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 判断活动分区是否存在 |
|---|
| | | public static boolean GetPurposeType(String purposeType) { |
|---|
| | | Schema.DescribeFieldResult fieldResult = Agency_Report__c.Purpose_Type__c.getDescribe(); |
|---|
| | | List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues(); |
|---|
| | | for (Schema.PicklistEntry pickListVal : ple) { |
|---|
| | | if (pickListVal.getValue() == purposeType) { |
|---|
| | | return true; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | public static String GetEPurposeType(String purposeType){ |
|---|
| | | // String purpose_Type=''; |
|---|
| | | if(purposeType.substring(purposeType.length()-3) == 'OPD'){ |
|---|
| | | purposeType = 'OPD'; |
|---|
| | | }else if(purposeType.substring(purposeType.length()-3) == 'SIS'){ |
|---|
| | | purposeType = 'SIS'; |
|---|
| | | }else{ |
|---|
| | | purposeType = ''; |
|---|
| | | } |
|---|
| | | return purposeType; |
|---|
| | | return false; |
|---|
| | | } |
|---|
| | | public static boolean getResultlist(String resultlist) { |
|---|
| | | system.debug('resultlist===============>' + resultlist); |
|---|
| | | Schema.DescribeFieldResult fieldResult = Agency_Report__c.Result__c.getDescribe(); |
|---|
| | | List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues(); |
|---|
| | | for (Schema.PicklistEntry pickListVal : ple) { |
|---|
| | | System.debug( |
|---|
| | | 'weixiao' + |
|---|
| | | resultlist.trim() + |
|---|
| | | '111111' + |
|---|
| | | pickListVal.getValue() + |
|---|
| | | '222222' |
|---|
| | | ); |
|---|
| | | string temp = string.ValueOf(pickListVal.getValue()); |
|---|
| | | if (temp.equals(resultlist.trim())) { |
|---|
| | | // if(pickListVal.getValue().equals(resultlist)){ |
|---|
| | | System.debug( |
|---|
| | | 'weixiaoweixiao' + resultlist + '' + pickListVal.getValue() |
|---|
| | | ); |
|---|
| | | return false; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | return true; |
|---|
| | | } |
|---|
| | | public static String GetEPurposeType(String purposeType) { |
|---|
| | | // String purpose_Type=''; |
|---|
| | | if (purposeType.substring(purposeType.length() - 3) == 'OPD') { |
|---|
| | | purposeType = 'OPD'; |
|---|
| | | } else if (purposeType.substring(purposeType.length() - 3) == 'SIS') { |
|---|
| | | purposeType = 'SIS'; |
|---|
| | | } else { |
|---|
| | | purposeType = ''; |
|---|
| | | } |
|---|
| | | return purposeType; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 判断产品区分是否满足要求 |
|---|
| | | public static String ifTrueProduct( |
|---|
| | | List<Map<String, String>> prolist, |
|---|
| | | String str |
|---|
| | | ) { |
|---|
| | | system.debug('=ifTrueProduct==============ifTrueProduct=========' + str); |
|---|
| | | system.debug('=prolist==============prolist=========' + prolist); |
|---|
| | | |
|---|
| | | for (Map<String, String> strmap : prolist) { |
|---|
| | | System.debug('---===---===---===' + str + '===' + strmap.get('label')); |
|---|
| | | if (strmap.get('label') == str) { |
|---|
| | | return strmap.get('value'); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | return ''; |
|---|
| | | } |
|---|
| | | // 获取导入数据的科室和产品区分的匹配 |
|---|
| | | public static Map<String, List<Map<String, String>>> getImplProductList( |
|---|
| | | Set<String> ptdc |
|---|
| | | ) { |
|---|
| | | Map<String, List<Map<String, String>>> impProMap = new Map<String, List<Map<String, String>>>(); |
|---|
| | | List<String> dc = new List<String>(ptdc); |
|---|
| | | if (dc.size() > 0) { |
|---|
| | | List<ProductTypes__c> ptList1 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[0].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList1 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList1 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList1) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[0], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 1) { |
|---|
| | | List<ProductTypes__c> ptList2 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[1].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList2 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList2 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList2) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[1], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 2) { |
|---|
| | | List<ProductTypes__c> ptList3 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[2].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList3 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList3 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList3) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[2], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 3) { |
|---|
| | | List<ProductTypes__c> ptList4 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[3].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList4 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList4 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList4) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[3], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 4) { |
|---|
| | | List<ProductTypes__c> ptList5 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[4].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList5 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList5 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList5) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[4], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 5) { |
|---|
| | | List<ProductTypes__c> ptList6 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[5].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList6 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList6 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList6) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[5], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 6) { |
|---|
| | | List<ProductTypes__c> ptList7 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[6].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList7 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList7 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList7) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[6], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 7) { |
|---|
| | | List<ProductTypes__c> ptList8 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[7].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList8 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList8 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList8) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[7], impProList); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 判断产品区分是否满足要求 |
|---|
| | | public static String ifTrueProduct(List<Map<String,String>> prolist,String str){ |
|---|
| | | system.debug('=ifTrueProduct==============ifTrueProduct========='+str); |
|---|
| | | system.debug('=prolist==============prolist========='+prolist); |
|---|
| | | |
|---|
| | | for(Map<String,String> strmap :prolist){ |
|---|
| | | System.debug('---===---===---==='+str+'==='+strmap.get('label')); |
|---|
| | | if(strmap.get('label')==str){ |
|---|
| | | return strmap.get('value'); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | return ''; |
|---|
| | | if (dc.size() > 8) { |
|---|
| | | List<ProductTypes__c> ptList9 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[8].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList9 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList9 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList9) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[8], impProList); |
|---|
| | | } |
|---|
| | | // 获取导入数据的科室和产品区分的匹配 |
|---|
| | | public static Map<String,List<Map<String,String>>> getImplProductList(Set<String> ptdc){ |
|---|
| | | Map<String,List<Map<String,String>>> impProMap = new Map<String,List<Map<String,String>>>(); |
|---|
| | | List<String> dc = new List<String>(ptdc); |
|---|
| | | if(dc.size() > 0){ |
|---|
| | | List<ProductTypes__c> ptList1 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[0].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList1 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList1 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList1){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[0], impProList); |
|---|
| | | |
|---|
| | | } |
|---|
| | | if(dc.size() > 1){ |
|---|
| | | List<ProductTypes__c> ptList2 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[1].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList2 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList2 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList2){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[1], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 2){ |
|---|
| | | List<ProductTypes__c> ptList3 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[2].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList3 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList3 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList3){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[2], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 3){ |
|---|
| | | List<ProductTypes__c> ptList4 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[3].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList4 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList4 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList4){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[3], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 4){ |
|---|
| | | List<ProductTypes__c> ptList5 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[4].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList5 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList5 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList5){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[4], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 5){ |
|---|
| | | List<ProductTypes__c> ptList6 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[5].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList6 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList6 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList6){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[5], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 6){ |
|---|
| | | List<ProductTypes__c> ptList7 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[6].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList7 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList7 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList7){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[6], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 7){ |
|---|
| | | List<ProductTypes__c> ptList8 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[7].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList8 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList8 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList8){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[7], impProList); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if(dc.size() > 8){ |
|---|
| | | List<ProductTypes__c> ptList9 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[8].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList9 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList9 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList9){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[8], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 9){ |
|---|
| | | List<ProductTypes__c> ptList10 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[9].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList10 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList10 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList10){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[9], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 10){ |
|---|
| | | List<ProductTypes__c> ptList11 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[10].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList11 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList11 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList11){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[10], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 11){ |
|---|
| | | List<ProductTypes__c> ptList12 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[11].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList12 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList12 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList12){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[11], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 12){ |
|---|
| | | List<ProductTypes__c> ptList13 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[12].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList13 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList13 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList13){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[12], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 13){ |
|---|
| | | List<ProductTypes__c> ptList14 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[13].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList14 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList14 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList14){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[13], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 14){ |
|---|
| | | List<ProductTypes__c> ptList15 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[14].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList15 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList15 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList15){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[14], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 15){ |
|---|
| | | List<ProductTypes__c> ptList16 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[15].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList16 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList16 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList16){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[15], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 16){ |
|---|
| | | List<ProductTypes__c> ptList17 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[16].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList17 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList17 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList17){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[16], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 17){ |
|---|
| | | List<ProductTypes__c> ptList18 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[17].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList18 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList18 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList18){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[17], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 18){ |
|---|
| | | List<ProductTypes__c> ptList19 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[18].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList19 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList19 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList19){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[18], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 19){ |
|---|
| | | List<ProductTypes__c> ptList20 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[19].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList20 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList20 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList20){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[19], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 20){ |
|---|
| | | List<ProductTypes__c> ptList21 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[20].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList21 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList21 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList21){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[20], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 21){ |
|---|
| | | List<ProductTypes__c> ptList22 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[21].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList22 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList22 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList22){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[21], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 22){ |
|---|
| | | List<ProductTypes__c> ptList23 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[22].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList23 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList23 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList23){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[22], impProList); |
|---|
| | | } |
|---|
| | | if(dc.size() > 23){ |
|---|
| | | List<ProductTypes__c> ptList24 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[23].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList24 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0] and OPD_SIS_Type__c =:dcList[1]]; |
|---|
| | | } else { |
|---|
| | | ptList24 = [select Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c from ProductTypes__c where DeleteFlg__c = false and Department_Cateogy_Text__c like :dcList[0]]; |
|---|
| | | } |
|---|
| | | List<Map<String,String>> impProList = new List<Map<String,String>>(); |
|---|
| | | for(ProductTypes__c pt : ptList24){ |
|---|
| | | Map<String,String> productMap = new Map<String,String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[23], impProList); |
|---|
| | | } |
|---|
| | | |
|---|
| | | return impProMap; |
|---|
| | | |
|---|
| | | if (dc.size() > 9) { |
|---|
| | | List<ProductTypes__c> ptList10 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[9].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList10 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList10 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList10) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[9], impProList); |
|---|
| | | } |
|---|
| | | // 批量添加周报by vivek end |
|---|
| | | |
|---|
| | | //zhj MEBG新方案改造 2022-11-29 start |
|---|
| | | @AuraEnabled |
|---|
| | | public static ControllerResponse searchAgencyDataId(String hospitalId){ |
|---|
| | | ControllerResponse r = new ControllerResponse(); |
|---|
| | | try{ |
|---|
| | | if(String.isBlank(hospitalId)){ |
|---|
| | | r.IsSuccess = true; |
|---|
| | | r.Message = 'noHospitalId'; |
|---|
| | | return r; |
|---|
| | | } |
|---|
| | | List<Agency_Contact__c> acList = [select id,AWS_Data_Id__c,Agency_Hospital__r.Name from Agency_Contact__c where Agency_Hospital__c=:hospitalId]; |
|---|
| | | r.IsSuccess = true; |
|---|
| | | r.Message = ''; |
|---|
| | | r.Data = acList; |
|---|
| | | return r; |
|---|
| | | }catch(Exception e) { |
|---|
| | | System.debug('into catch'+e.getMessage()); |
|---|
| | | r.IsSuccess = false; |
|---|
| | | r.message = e.getMessage()+e.getStackTraceString(); |
|---|
| | | return r; |
|---|
| | | } |
|---|
| | | if (dc.size() > 10) { |
|---|
| | | List<ProductTypes__c> ptList11 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[10].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList11 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList11 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList11) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[10], impProList); |
|---|
| | | } |
|---|
| | | //zhj MEBG新方案改造 2022-11-29 end |
|---|
| | | } |
|---|
| | | if (dc.size() > 11) { |
|---|
| | | List<ProductTypes__c> ptList12 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[11].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList12 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList12 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList12) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[11], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 12) { |
|---|
| | | List<ProductTypes__c> ptList13 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[12].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList13 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList13 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList13) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[12], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 13) { |
|---|
| | | List<ProductTypes__c> ptList14 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[13].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList14 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList14 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList14) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[13], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 14) { |
|---|
| | | List<ProductTypes__c> ptList15 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[14].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList15 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList15 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList15) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[14], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 15) { |
|---|
| | | List<ProductTypes__c> ptList16 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[15].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList16 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList16 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList16) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[15], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 16) { |
|---|
| | | List<ProductTypes__c> ptList17 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[16].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList17 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList17 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList17) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[16], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 17) { |
|---|
| | | List<ProductTypes__c> ptList18 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[17].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList18 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList18 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList18) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[17], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 18) { |
|---|
| | | List<ProductTypes__c> ptList19 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[18].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList19 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList19 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList19) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[18], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 19) { |
|---|
| | | List<ProductTypes__c> ptList20 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[19].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList20 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList20 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList20) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[19], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 20) { |
|---|
| | | List<ProductTypes__c> ptList21 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[20].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList21 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList21 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList21) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[20], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 21) { |
|---|
| | | List<ProductTypes__c> ptList22 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[21].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList22 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList22 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList22) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[21], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 22) { |
|---|
| | | List<ProductTypes__c> ptList23 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[22].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList23 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList23 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList23) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[22], impProList); |
|---|
| | | } |
|---|
| | | if (dc.size() > 23) { |
|---|
| | | List<ProductTypes__c> ptList24 = new List<ProductTypes__c>(); |
|---|
| | | List<String> dcList = dc[23].split('-'); |
|---|
| | | if (dcList.size() > 1) { |
|---|
| | | ptList24 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | AND OPD_SIS_Type__c = :dcList[1] |
|---|
| | | ]; |
|---|
| | | } else { |
|---|
| | | ptList24 = [ |
|---|
| | | SELECT Id, Name, Department_Cateogy__c, OPD_Flg__c, SIS_Flg__c |
|---|
| | | FROM ProductTypes__c |
|---|
| | | WHERE |
|---|
| | | DeleteFlg__c = FALSE |
|---|
| | | AND Department_Cateogy_Text__c LIKE :dcList[0] |
|---|
| | | ]; |
|---|
| | | } |
|---|
| | | List<Map<String, String>> impProList = new List<Map<String, String>>(); |
|---|
| | | for (ProductTypes__c pt : ptList24) { |
|---|
| | | Map<String, String> productMap = new Map<String, String>(); |
|---|
| | | productMap.put('label', pt.Name); |
|---|
| | | productMap.put('value', pt.Id); |
|---|
| | | impProList.add(productMap); |
|---|
| | | } |
|---|
| | | impProMap.put(dc[23], impProList); |
|---|
| | | } |
|---|
| | | |
|---|
| | | return impProMap; |
|---|
| | | } |
|---|
| | | // 批量添加周报by vivek end |
|---|
| | | |
|---|
| | | //zhj MEBG新方案改造 2022-11-29 start |
|---|
| | | @AuraEnabled |
|---|
| | | public static ControllerResponse searchAgencyDataId(String hospitalId) { |
|---|
| | | ControllerResponse r = new ControllerResponse(); |
|---|
| | | try { |
|---|
| | | if (String.isBlank(hospitalId)) { |
|---|
| | | r.IsSuccess = true; |
|---|
| | | r.Message = 'noHospitalId'; |
|---|
| | | return r; |
|---|
| | | } |
|---|
| | | List<Agency_Contact__c> acList = [ |
|---|
| | | SELECT id, AWS_Data_Id__c, Agency_Hospital__r.Name |
|---|
| | | FROM Agency_Contact__c |
|---|
| | | WHERE Agency_Hospital__c = :hospitalId |
|---|
| | | ]; |
|---|
| | | r.IsSuccess = true; |
|---|
| | | r.Message = ''; |
|---|
| | | r.Data = acList; |
|---|
| | | return r; |
|---|
| | | } catch (Exception e) { |
|---|
| | | System.debug('into catch' + e.getMessage()); |
|---|
| | | r.IsSuccess = false; |
|---|
| | | r.message = e.getMessage() + e.getStackTraceString(); |
|---|
| | | return r; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //zhj MEBG新方案改造 2022-11-29 end |
|---|
| | | } |
|---|
