OlyMEBG.git - Gitblit

			@@ -1,125 +1,150 @@
			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>();
			@@ -136,159 +161,217 @@
			}
			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>>();
			@@ -300,11 +383,15 @@
			*/
			// 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];

			@@ -319,32 +406,43 @@
			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);
			@@ -360,14 +458,14 @@
			}
			*/

			// 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){
			@@ -393,1304 +491,1985 @@
			}
			*/

			@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
			}