public without sharing class RetrospectiveWeeklyReportController{
|
@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 String UserProType{get;set;}
|
@AuraEnabled public Map<String,Agency_Report__c> AgencyReportMap{get;set;}
|
@AuraEnabled public Map<String,string> PIConfig{get;set;}
|
|
public RetrospectiveWeeklyReportController() {
|
}
|
public void UserDoin(){
|
User UserProTypec = LightningUtil.loginUserId();
|
this.UserProType = '';
|
this.UserProType = UserProTypec.UserPro_Type__c;
|
}
|
|
public void setalldata()
|
{
|
/*** create allselectlist ***/
|
this.allselectlist = new Map<String,List<Map<String,String>>>();
|
// 用来存放工作会记录 和 效果/进度
|
this.AgencyReportMap = new Map<String,Agency_Report__c>();
|
|
Map<String,List<Map<String,String>>> alldata = new Map<String,List<Map<String,String>>>();
|
system.debug('UserInfo.getUserId()11111111111================>'+UserInfo.getUserId());
|
User login_user_id = [select UserPro_Type__c, ContactId,Contact.Name from User where id =: UserInfo.getUserId()];
|
// プルダウン初期値の空白
|
List<Map<String,String>> tmp = new List<Map<String,String>>();
|
Map<String,String> space = new Map<String,String>();
|
space.put('label', login_user_id.Contact.name);
|
space.put('value', login_user_id.ContactId);
|
space.put('selected', 'true');
|
tmp.add(space);
|
|
// 代理店担当者 AgencyPerson__c
|
List<Contact> agency_person_data = LightningUtil.selectAgencyPerson03();
|
for(Contact var : agency_person_data) {
|
Map<String,String> om = new Map<String,String>();
|
om.put('label', var.Name);
|
om.put('value', var.Id);
|
om.put('selected', 'false');
|
tmp.add(om);
|
}
|
this.allselectlist.put('AgencyPerson__c', tmp);
|
system.debug('tmp================>'+tmp);
|
//经销商人员
|
List<Map<String,String>> tmp01 = new List<Map<String,String>>();
|
Map<String,String> space01 = new Map<String,String>();
|
space01.put('label', '');
|
space01.put('value', '');
|
space01.put('selected', 'true');
|
tmp01.add(space01);
|
// 经销商人员 DealerPersonnel__c
|
List<Contact> agency_person_data01 = LightningUtil.selectAgencyPerson02();
|
system.debug('agency_person_data01================>'+agency_person_data01);
|
for(Contact var : agency_person_data01) {
|
Map<String,String> om01 = new Map<String,String>();
|
om01.put('label', var.Name);
|
om01.put('value', var.Id);
|
om01.put('selected', 'false');
|
tmp01.add(om01);
|
}
|
this.allselectlist.put('DealerPersonnel__c', tmp01);
|
|
// 科室分类 Department_Cateogy__c AgencyReportMap
|
this.allselectlist.put('Department_Cateogy__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','Department_Cateogy__c'));
|
|
// 活动区分会 WorkRecord__c
|
this.allselectlist.put('WorkRecord__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','WorkRecord__c'));
|
|
// 效果进度 EffectProgress__c
|
// this.allselectlist.put('EffectProgress__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','EffectProgress__c'));
|
|
// 产品分区 ET 或者 ENG login_user_id
|
// if(login_user_id.UserPro_Type__c == 'ET')
|
this.allselectlist.put('ProductClassification__c', RetrospectiveWeeklyReportController.getPicklistValues1('Agency_Report__c','ProductClassification__c'));
|
|
// 产品1同类耗材科室月使用量 ConsumptionOfConsumables__c
|
this.allselectlist.put('ConsumptionOfConsumables__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','ConsumptionOfConsumables__c'));
|
|
//阶段 StageName__c
|
this.allselectlist.put('StageName__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Opportunity__c','StageName__c'));
|
|
//其他品牌耗材
|
this.allselectlist.put('WarlockClassification__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','WarlockClassification__c'));
|
|
//产品类别
|
this.allselectlist.put('ProductCcategory__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','ProductCcategory__c'));
|
|
//产品类别
|
this.allselectlist.put('productCategories__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','productCategories__c'));
|
|
//其他品牌耗材
|
this.allselectlist.put('warlocksNumber__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','warlocksNumber__c'));
|
|
//产品类别
|
this.allselectlist.put('WorkMark__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','WorkMark__c'));
|
//拜访人
|
// //fy 20220414
|
// this.allselectlist.put('doctor3__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','doctor3__c'));
|
// 見出し設定
|
this.fieldsMap = new Map<String,String>();
|
this.fieldsMap = this.getfiledsmap();
|
|
this.PIConfig = new Map<String,string>();
|
this.PIConfig.put('staticResourceAgencyContact', JSON.serialize(PIHelper.getPIIntegrationInfo('Agency_Contact__c')));
|
}
|
|
@RemoteAction
|
@AuraEnabled
|
public static List<Map<String,String>> selectdoctor3c(){
|
|
List<Map<String,String>> options = new List<Map<String,String>>();
|
options = RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','doctor3__c');
|
|
return options;
|
}
|
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();
|
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 static List<Map<String,String>> getPicklistValues1(String objstr, String fld){
|
List<Map<String,String>> options = new List<Map<String,String>>();
|
Map<String,String> space = new Map<String,String>();
|
User loginUserId = LightningUtil.loginUserId();
|
Boolean fag = false;
|
if(loginUserId.UserPro_Type__c == 'ET'){
|
fag = true;
|
}
|
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();
|
for (Schema.PicklistEntry a : values)
|
{
|
if (!a.isActive()) continue;
|
Map<String,String> ses = new Map<String,String>();
|
if(fag){
|
if(a.getValue() != '腹腔镜手术'&&a.getValue() != '开腹手术'){
|
ses.put('label', a.getLabel());
|
ses.put('value', a.getValue());
|
ses.put('selected', 'false');
|
options.add(ses);
|
}
|
}else{//fy 20220414
|
if(a.getValue() == '腹腔镜手术'||a.getValue() == '开腹手术'){
|
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>> ();
|
// Agency_Opportunity__c 经销商询价
|
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();
|
mappingmap.put(dfield.name,lab);
|
}
|
// Agency_Report__c 日报明细
|
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();
|
mappingmap.put(dfield.name,lab);
|
}
|
return mappingmap;
|
}
|
|
@RemoteAction
|
@AuraEnabled
|
public static RetrospectiveWeeklyReportController getalldata(){
|
RetrospectiveWeeklyReportController li = new RetrospectiveWeeklyReportController();
|
li.UserDoin();
|
li.setalldata();
|
return li;
|
}
|
|
@RemoteAction
|
@AuraEnabled
|
public static ProductTypes__c getProduct(String id){//fy 修改Department_Cateogy_text__c
|
return [select Department_Cateogy__c,Department_Cateogy_text__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){
|
User login_user_id = LightningUtil.loginUserId();
|
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;
|
agency_report_header.WeeklyReportClassification__c = login_user_id.UserPro_Type__c;
|
OlympusCalendar__c olympus_calendar = [select Id,Date__c from OlympusCalendar__c where Date__c=:week];
|
String olympus_calendar_id = olympus_calendar.Id;
|
if (olympus_calendar_id != '') { agency_report_header.OlympusDate__c = olympus_calendar_id; }
|
return agency_report_header;
|
}
|
|
@RemoteAction
|
@AuraEnabled
|
public static List<Agency_Hospital_Link__c> getHospitalList(String hospital_name) {
|
User login_user_id = LightningUtil.loginUserId();
|
String SignInId = UserInfo.getUserId();
|
// List<Contact> conStrList = [select AccountId from contact where id in (select ContactId from User where id =: SignInId)];
|
Contact conStrList = [select AccountId from contact where id in (select ContactId from User where id =: SignInId)];
|
|
system.debug('conStrListconStrListr===============>'+conStrList);
|
String strAgencyId =conStrList.AccountId;
|
// for(Contact conStr : conStrList){
|
// strAgencyId = conStr.AccountId;
|
// }
|
system.debug('strAgencyIdstrAgencyId==============>'+strAgencyId);
|
hospital_name = '%' + hospital_name.trim() + '%';
|
if(login_user_id.UserPro_Type__c == 'ENG'){
|
return [select Hospital_Name_readonly__c, Id, Hospital__c from Agency_Hospital_Link__c where Agency__c =: strAgencyId and Hospital_Name_readonly__c like :hospital_name and AgencyHos_ENG__c = true];
|
}else {
|
return [select Hospital_Name_readonly__c, Id, Hospital__c from Agency_Hospital_Link__c where Agency__c =: strAgencyId and Hospital_Name_readonly__c like :hospital_name and AgencyHos_ET__c = true];
|
}
|
|
}
|
|
//模糊查询使用产品1
|
@RemoteAction
|
@AuraEnabled
|
public static List<Product2> getUseProduct1(String UseProduct1Name,String select_ProductClassification) {
|
String UseProduct1Name01 = '%' + UseProduct1Name.trim() + '%';
|
User UserProTypec = LightningUtil.loginUserId();
|
List<Product2> Product2List=new List<Product2>();
|
List<String> select_ProductClassificationList = new List<String>();
|
if(select_ProductClassification=='其他'){
|
select_ProductClassificationList.add('基干');
|
select_ProductClassificationList.add('模型');
|
select_ProductClassificationList.add('其他');
|
select_ProductClassificationList.add('其他ET');
|
select_ProductClassificationList.add('外科ET');
|
select_ProductClassificationList.add('附属品');
|
}else if(select_ProductClassification=='呼吸科'){
|
select_ProductClassificationList.add('呼吸科ET');
|
}else{
|
select_ProductClassificationList.add(select_ProductClassification);
|
}
|
if(UserProTypec.UserPro_Type__c == 'ET'){
|
Product2List = [select Id, Name ,Asset_Model_No__c from Product2 where Category3__c in: select_ProductClassificationList AND Asset_Model_No__c like :UseProduct1Name01 AND Dealer_Object__c = true AND Estimation_Entry_Possibility__c = '○'];
|
}else{
|
Product2List = [select Id, Name,Asset_Model_No__c from Product2 where Category3__c in: select_ProductClassificationList AND Category4__c='Thunderbeat' AND Asset_Model_No__c like :UseProduct1Name01 AND ENG_DeaerProFlag__c = true AND Estimation_Entry_Possibility__c = '○'];
|
}
|
// if(UserProTypec.UserPro_Type__c == 'ET'){
|
// Product2List = [select Id, Name ,Asset_Model_No__c from Product2 where Category3__c =: select_ProductClassification AND Asset_Model_No__c like :UseProduct1Name01 AND Dealer_Object__c = true AND Estimation_Entry_Possibility__c = '○'];
|
// }else{
|
// Product2List = [select Id, Name,Asset_Model_No__c from Product2 where Category3__c =: select_ProductClassification AND Category4__c='Thunderbeat' AND Asset_Model_No__c like :UseProduct1Name01 AND ENG_DeaerProFlag__c = true AND Estimation_Entry_Possibility__c = '○'];
|
// }
|
return Product2List;
|
}
|
|
|
@RemoteAction
|
@AuraEnabled
|
public static List<Map<String,String>> getDoctorList(String hospital_id){
|
List<Map<String,String>> ret = new List<Map<String,String>>();
|
Map<String,String> space = new Map<String,String>();
|
space.put('label', '');
|
space.put('value', '');
|
space.put('selected', 'true');
|
ret.add(space);
|
|
Agency_Hospital_Link__c ahl = [select Hospital__c from Agency_Hospital_Link__c where id = :hospital_id];
|
List<Agency_Contact__c> doctor_list = [select id,Name,Doctor_Division1__c,
|
AWS_Data_Id__c,// PI改造 By Bright 20220328
|
Type__c,Agency_Hospital__c
|
FROM Agency_Contact__c WHERE Hospital_ID18__c=:ahl.Hospital__c order by Name];
|
for (Agency_Contact__c row : doctor_list)
|
{
|
Map<String,String> tmp = new Map<String,String>();
|
tmp.put('label', row.Name);
|
tmp.put('value', row.Id);
|
tmp.put('selected', 'false');
|
tmp.put('Doctor_Division1__c', row.Doctor_Division1__c);
|
tmp.put('AWS_Data_Id__c', row.AWS_Data_Id__c);// PI改造 By Bright 20220328
|
ret.add(tmp);
|
}
|
return ret;
|
}
|
//删除周报明细
|
@RemoteAction
|
@AuraEnabled
|
public static String deleteAgencyReport(String agencyReport_id){
|
Savepoint sp = Database.setSavepoint();
|
try{
|
System.debug('agencyReport_id'+agencyReport_id);
|
Agency_Report__c arrays = new Agency_Report__c();
|
arrays.Id=agencyReport_id;
|
delete arrays;
|
return 'success';
|
}catch(Exception e){
|
Database.rollback(sp);
|
System.debug('exception'+e);
|
return e.getLineNumber()+'exception'+e;
|
}
|
}
|
|
@RemoteAction
|
@AuraEnabled
|
public static String saveAgencyReport(String Department_Cateogy,Decimal ConsumptionOfConsumables,
|
Boolean WorkMark,Decimal warlocksNumber,String DealerPersonnel,String ProductCcategory,String productCategories ,String WarlockClassification,
|
String ProductClassification,String WorkRecord,String EffectProgress, String Agency_Report_Header,
|
String Agency_Hospital, String Person_In_Charge2, String doctor, String Submit_date,
|
String UseProduct1, String UseProduct2, String UseProduct3,
|
String StageName, String oppAmount, String oppOCMPrice, String Close_Forecasted_Date, String Report_Date)
|
{
|
// Department_Cateogy = GetDepartment_Cateogy(Department_Cateogy);
|
system.debug('Agency_Report_Header+++'+Agency_Report_Header);
|
Agency_Report__c agency_report = makeAgencyReport(Department_Cateogy,ConsumptionOfConsumables,
|
WorkMark,warlocksNumber,DealerPersonnel,ProductCcategory,productCategories,WarlockClassification,ProductClassification, WorkRecord,
|
EffectProgress,Agency_Report_Header,
|
Agency_Hospital, Person_In_Charge2, doctor, Submit_date,
|
UseProduct1, UseProduct2, UseProduct3,
|
StageName, oppAmount, oppOCMPrice, Close_Forecasted_Date, Report_Date);
|
|
agency_report = insertAgencyReport(agency_report);
|
return agency_report.Id;
|
}
|
public static Agency_Report__c makeAgencyReport(String Department_Cateogy,Decimal ConsumptionOfConsumables,
|
boolean WorkMark,Decimal warlocksNumber, String DealerPersonnel,String ProductCcategory,String productCategories,String WarlockClassification,
|
String ProductClassification, String WorkRecord, String EffectProgress,String Agency_Report_Header,
|
String Agency_Hospital, String Person_In_Charge2, String doctor, String Submit_date,
|
String UseProduct1, String UseProduct2, String UseProduct3,
|
String StageName, String oppAmount, String oppOCMPrice, String Close_Forecasted_Date, String Report_Date)
|
{
|
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 != '') {
|
|
if(Person_In_Charge2.contains(';')){
|
Person_In_Charge2 = Person_In_Charge2.split(';')[0];
|
}
|
agency_report.Person_In_Charge2__c = Person_In_Charge2;
|
} else {
|
agency_report.Person_In_Charge2__c = null;
|
}
|
//经销商人员
|
if (DealerPersonnel != '') {
|
if(DealerPersonnel.contains(';')){
|
DealerPersonnel = DealerPersonnel.split(';')[0];
|
}
|
agency_report.DealerPersonnel__c = DealerPersonnel;
|
} else {
|
agency_report.DealerPersonnel__c = null;
|
}
|
//更新经销商医院的 最近日报跟新日 ,
|
if (Agency_Hospital != '') {
|
LightningUtil.updateAccMaxActivityDate(Agency_Hospital, week);
|
}
|
//fy 20220414
|
if (doctor != '') {
|
if(WorkRecord == '科室会'){
|
agency_report.doctor3__c = doctor;
|
}else{
|
agency_report.doctor2__c = doctor;
|
}
|
}else {
|
if(WorkRecord == '科室会'){
|
agency_report.doctor3__c = null;
|
}else{
|
agency_report.doctor2__c = null;
|
}
|
}
|
// if (Department_Cateogy != '') { agency_report.Department_Cateogy__c = Department_Cateogy; }
|
if (Department_Cateogy != '') { agency_report.Department_Cateogy_text__c = Department_Cateogy; }
|
if (ConsumptionOfConsumables != null) { agency_report.ConsumptionOfConsumables__c = ConsumptionOfConsumables; }
|
if (WorkRecord != '') { agency_report.WorkRecord__c = WorkRecord; }
|
// system.debug('EffectProgress==================>'+EffectProgress);
|
if (EffectProgress != '') { agency_report.EffectProgress__c = EffectProgress; }
|
// ET
|
if (ProductClassification != '') { agency_report.ProductClassification__c = ProductClassification; }
|
if (Agency_Report_Header != '') { agency_report.Agency_Report_Header__c = Agency_Report_Header; }
|
if (Agency_Hospital != '') { agency_report.Agency_Hospital__c = Agency_Hospital; }
|
if (UseProduct1 != '') { agency_report.UseProduct1__c = UseProduct1; }
|
if (UseProduct2 != '') { agency_report.UseProduct2__c = UseProduct2; }
|
if (UseProduct3 != '') { agency_report.UseProduct3__c = UseProduct3; }
|
if (WarlockClassification != '') { agency_report.WarlockClassification__c = WarlockClassification; }
|
system.debug('ProductCcategory==================>'+ProductCcategory);
|
if (ProductCcategory != '') { agency_report.ProductCcategory__c = ProductCcategory; }
|
system.debug('productCategories==================>'+productCategories);
|
if (productCategories != '') { agency_report.productCategories__c = productCategories; }
|
if (warlocksNumber != null) { agency_report.warlocksNumber__c = warlocksNumber; }
|
if (WorkMark != false) {
|
agency_report.WorkMark__c = WorkMark;
|
}
|
return agency_report;
|
}
|
//新建方法
|
public static Agency_Report__c insertAgencyReport(Agency_Report__c data) {
|
if (String.isBlank(data.Hospital__c)) {
|
system.debug('data.Agency_Hospital__c+++'+data.Agency_Hospital__c);
|
List<Agency_Hospital_Link__c> agency_hospital_link = [select Id, Hospital__c from Agency_Hospital_Link__c where Id=:data.Agency_Hospital__c];
|
system.debug('agency_hospital_link+++'+agency_hospital_link);
|
data.Hospital__c = agency_hospital_link[0].Hospital__c;
|
}
|
// if (String.isBlank(data.Department_Class__c)) {
|
// system.debug('data.Department_Cateogy__c+++'+data.Department_Cateogy__c);
|
// String record_type_id = LightningUtil.getRecordTypeId(data.Department_Cateogy__c);
|
// system.debug('RecordTypeId+++'+record_type_id);
|
// List<Account> account = [select Id, RecordTypeId from account where Hospital_Department_Class__c=:data.Hospital__c and RecordTypeId=:record_type_id];
|
// system.debug('account+++'+account);
|
// data.Department_Class__c = account[0].Id;
|
// }
|
User userPro = LightningUtil.loginUserId();
|
data.WeeklyReportClassification__c = userPro.UserPro_Type__c;
|
system.debug('data==================>'+data);
|
|
insert data;
|
return data;
|
}
|
@RemoteAction
|
@AuraEnabled
|
public static String editAgencyReport(String Agency_Report_Id, String Department_Cateogy,
|
Decimal ConsumptionOfConsumables,boolean WorkMark,Decimal warlocksNumber,
|
String DealerPersonnel,String WarlockClassification,String ProductCcategory,String productCategories,String ProductClassification,
|
String EffectProgress, String WorkRecord, String Agency_Report_Header,
|
String Agency_Hospital, String Person_In_Charge2, String doctor, String Submit_date,
|
String UseProduct1, String UseProduct2, String UseProduct3,
|
String Report_Date)
|
{
|
if (String.isBlank(Agency_Report_Id)) {
|
return null;
|
}//fy Department_Cateogy_text__c
|
Agency_Report__c agency_report = [select Id,Hospital__c, Name, Department_Cateogy__c,Department_Cateogy_text__c, ConsumptionOfConsumables__c, WorkRecord__c,WarlockClassification__c,
|
ProductCcategory__c, productCategories__c,warlocksNumber__c,WorkMark__c,ProductClassification__c,DealerPersonnel__c, Agency_Report_Header__c,Agency_Hospital__c,UseProduct1__c,
|
UseProduct2__c, UseProduct3__c, Person_In_Charge2__c,doctor2__c,doctor3__c,Submit_date__c,Report_Date__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;
|
} else {
|
agency_report.Person_In_Charge2__c = null;
|
}
|
|
//经销商人员
|
if (DealerPersonnel != '') {
|
agency_report.DealerPersonnel__c = DealerPersonnel;
|
} else {
|
agency_report.DealerPersonnel__c = null;
|
}
|
|
|
if (Agency_Hospital != '') {
|
LightningUtil.updateAccMaxActivityDate(Agency_Hospital, week);
|
}
|
// WRITE Agency Report__c String EffectProgress, ConsumptionOfConsumables__c WorkMark__c,warlocksNumber__c,
|
if (doctor != '') {
|
if(WorkRecord == '科室会'){
|
agency_report.doctor3__c = doctor;
|
}else{
|
agency_report.doctor2__c = doctor;
|
}
|
} else {
|
if(WorkRecord == '科室会'){
|
agency_report.doctor3__c = null;
|
}else{
|
agency_report.doctor2__c = null;
|
}
|
}
|
// if (Department_Cateogy != '') { agency_report.Department_Cateogy__c = Department_Cateogy; } else { agency_report.Department_Cateogy__c = null; }
|
if (Department_Cateogy != '') { agency_report.Department_Cateogy_text__c = Department_Cateogy; } else { agency_report.Department_Cateogy_text__c = null; }
|
if (WorkRecord != '') { agency_report.WorkRecord__c = WorkRecord; } else { agency_report.WorkRecord__c = null; }
|
if (ConsumptionOfConsumables != null) { agency_report.ConsumptionOfConsumables__c = ConsumptionOfConsumables; } else { agency_report.ConsumptionOfConsumables__c = null; }
|
if (EffectProgress != '') { agency_report.EffectProgress__c = EffectProgress; } else { agency_report.EffectProgress__c = null; }
|
if (ProductClassification != '') { agency_report.ProductClassification__c = ProductClassification; } else { agency_report.ProductClassification__c = null; }
|
if (Agency_Hospital != '') { agency_report.Agency_Hospital__c = Agency_Hospital; } else { agency_report.Agency_Hospital__c = null; }
|
if (UseProduct1 != '') { agency_report.UseProduct1__c = UseProduct1; } else { agency_report.UseProduct1__c = null; }
|
if (UseProduct2 != '') { agency_report.UseProduct2__c = UseProduct2; } else { agency_report.UseProduct2__c = null; }
|
if (UseProduct3 != '') { agency_report.UseProduct3__c = UseProduct3; } else { agency_report.UseProduct3__c = null; }
|
if (ProductCcategory != '') { agency_report.ProductCcategory__c = ProductCcategory; } else { agency_report.ProductCcategory__c = null; }
|
if (productCategories != '') { agency_report.productCategories__c = productCategories; } else { agency_report.productCategories__c = null; }
|
if (WarlockClassification != '') { agency_report.WarlockClassification__c = WarlockClassification; } else { agency_report.WarlockClassification__c = null; }
|
if (WorkMark != false) { agency_report.WorkMark__c = WorkMark; } else { agency_report.WorkMark__c = false; }
|
if (warlocksNumber != null) { agency_report.warlocksNumber__c = warlocksNumber; } else { agency_report.warlocksNumber__c = null; }
|
//fy 20220414
|
// agency_report = LightningUtil.updateAgencyReport(agency_report);
|
agency_report = updateAgencyReport(agency_report);
|
|
return agency_report.Id;
|
}
|
//fy 20220414
|
public static Agency_Report__c updateAgencyReport(Agency_Report__c data) {
|
system.debug('data.Agency_Hospital__c++'+data.Agency_Hospital__c);
|
system.debug('data.Id++'+data.Id);
|
if (String.isBlank(data.Hospital__c)) {
|
List<Agency_Hospital_Link__c> agency_hospital_link = [select Id, Hospital__c from Agency_Hospital_Link__c where Id=:data.Agency_Hospital__c];
|
data.Hospital__c = agency_hospital_link[0].Hospital__c;
|
}
|
update data;
|
return data;
|
}
|
@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 RetrospectiveWeeklyReportController getReports(String date_str, String person_str) {
|
RetrospectiveWeeklyReportController li = new RetrospectiveWeeklyReportController();
|
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.selectAgencyReport01(week, person_str);
|
}
|
|
@RemoteAction
|
@AuraEnabled
|
public static List<Agency_Report__c> getReportsById(String report_id) {
|
system.debug('==report_id================>'+report_id);
|
List<Agency_Report__c> ret = new List<Agency_Report__c>();
|
ret = LightningUtil.selectAgencyReportById01(report_id);
|
system.debug('==Agency_Report_Header__r.WeeklyReportClassification__c=================>'+ret);
|
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);
|
RetrospectiveWeeklyReportController li = new RetrospectiveWeeklyReportController();
|
List<Contact> conMList = LightningUtil.selectAgencyPerson03();
|
return LightningUtil.selectMAgencyReport01(date1_date, date2_date, conMList);
|
}
|
|
public List<contact> selectMAgencyPerson() {
|
String login_user_id = UserInfo.getUserId();
|
return [select id, Name, Agency_User__c from contact];
|
}
|
// fy 导入 20220506 start
|
@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>();
|
system.debug('fileLines[i]= '+fileLines[i].replace(',','').trim()+' +++');
|
if(fileLines[i].replace(',','').trim()!=''){
|
inputvalues = fileLines[i].split(',');
|
if(inputvalues != null){
|
if(inputvalues[1] == '' || inputvalues[1] == null){
|
errorMag += 'error1 第'+i+'行数据医院不能为空';
|
}
|
ahlNameList.add(inputvalues[1]);
|
}
|
}
|
}
|
system.debug('ahlNameList==============>'+ahlNameList);
|
// 经销商医院的ocsm医院id的list
|
List<String> ahlOcsmIdList = new List<String>();
|
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];
|
|
for(Agency_Hospital_Link__c ahl : ahlList){
|
ahlOcsmIdList.add(ahl.Hospital__c);
|
}
|
//List<Agency_Contact__c> doctor2list = [select id,Name,Doctor_Division1__c,Type__c,Agency_Hospital__c,AWS_Data_Id__c,Name_Encrypted__c FROM Agency_Contact__c WHERE Hospital_ID18__c= :ahlOcsmIdList order by Name];
|
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 去掉Name_Encrypted__c 新方案改造 2023-12-21
|
if(errorMag != ''){
|
return errorMag;
|
}
|
String doctor2listStr = JSON.serialize(doctor2list);
|
return doctor2listStr;
|
}
|
}catch(Exception e){
|
System.debug('exception'+e);
|
return e.getLineNumber()+'exception:'+e;
|
}
|
return 'success';
|
}
|
//fy 调用pi改造的 获取url 和 token的方法
|
@AuraEnabled
|
public static Map<String,String> getAwsurl(String sobj){
|
system.debug('进入getAwsurl');
|
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;
|
}
|
// fy 导入 20220506 end
|
@AuraEnabled
|
public static String processData(String fileData,String sobjectName,List<String> fields) {
|
String errorMag = '';
|
System.debug('fileData=================>'+fileData);
|
// 创建日报
|
try{
|
if(fileData!=null){
|
User UserProTypec = LightningUtil.loginUserId();
|
String SignInId = UserInfo.getUserId();
|
|
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>();
|
// 产品
|
List<String> Product2NameList = new List<String>();
|
// 效果进度
|
List<String> EffectProgressList = new List<String>();
|
// 术士分类
|
List<String> OtherBrandConsumablesList = new List<String>();
|
// 其他品牌耗材使用
|
List<String> ProductCcategoryList = new List<String>();
|
// 其他品牌耗材使用
|
List<String> productCategoriesList = new List<String>();
|
// 科室Set
|
// Set<String> departmentSet = new Set<String>();
|
// 经销商询价名称list
|
// List<String> ahlOppNameList = new List<String>();
|
//for content
|
for (Integer i=1,j=fileLines.size();i<j;i++){
|
List<String> inputvalues = new List<String>();
|
if(fileLines[i].replace(',','').trim()!=''){
|
inputvalues = fileLines[i].split(',');
|
system.debug('inputvalues:::::::'+inputvalues);
|
if(inputvalues != null){
|
// if(inputvalues[0] == '' || inputvalues[0] == null){
|
// errorMag += 'error1 第'+i+'行数据周不能为空';
|
// errorMag += '=';
|
// }
|
// if(inputvalues[0] == '' || inputvalues[0] == null){
|
// errorMag += 'error1 第'+i+'行数据担当不能为空';
|
// errorMag += '=';
|
// }
|
if(inputvalues[0] == '' || inputvalues[0] == null){
|
errorMag += 'error1 第'+i+'行数据活动日不能为空';
|
errorMag += '=';
|
}
|
if(inputvalues[1] == '' || inputvalues[1] == null){
|
errorMag += 'error1 第'+i+'行数据医院不能为空';
|
errorMag += '=';
|
}
|
if(inputvalues[2] == '' || inputvalues[2] == null){
|
errorMag += 'error1 第'+i+'行数据科室不能为空';
|
errorMag += '=';
|
}
|
//fy 20220414
|
// String departmentstr = GetDepartment_Cateogy(inputvalues[2]);
|
// if(departmentstr == 'no' && inputvalues[2] != '' && inputvalues[2] != null){
|
// if(inputvalues[2] != '' && inputvalues[2] != null){
|
// errorMag += 'error3 第'+i+'行数据科室选项列表的值'+inputvalues[2]+'不存在';
|
// errorMag += '=';
|
// }
|
if(inputvalues[3] == '' || inputvalues[3] == null){
|
errorMag += 'error1 第'+i+'行数据经销商人员不能为空';
|
errorMag += '=';
|
}
|
if(inputvalues[4] == '' || inputvalues[4] == null){
|
errorMag += 'error1 第'+i+'行数据活动区分不能为空';
|
errorMag += '=';
|
}
|
boolean purposeType = GetPurposeType(inputvalues[4]);
|
if(!purposeType && inputvalues[4] != '' && inputvalues[4] != null){
|
errorMag += 'error3 第'+i+'行数据活动区分选项列表的值'+inputvalues[4]+'不存在';
|
errorMag += '=';
|
}
|
if(inputvalues[4] == 'SIS'||inputvalues[4] == '科室会'||inputvalues[4] == '院内入院申请'||inputvalues[4] == '收费项目申请'){
|
if(inputvalues[5] == '' || inputvalues[5] == null){
|
errorMag += 'error1 第'+i+'行数据拜访人不能为空';
|
errorMag += '=';
|
}
|
}
|
if(inputvalues[6] == '' || inputvalues[6] == null){
|
errorMag += 'error1 第'+i+'行数据产品分类(第三分类)不能为空';
|
errorMag += '=';
|
}
|
// if(inputvalues[4] != '临床信息(使用量)收集' && inputvalues[4] != 'QIS处理'){
|
if(inputvalues[4] != '临床信息(使用量)收集' ){
|
if(inputvalues[7] == '' || inputvalues[7] == null){
|
errorMag += 'error1 第'+i+'行数据使用产品1不能为空';
|
errorMag += '=';
|
}
|
}
|
if((inputvalues[8] != '' && inputvalues[8] != null)&& inputvalues[7] == inputvalues[8]){
|
errorMag += 'error1 第'+i+'行数据使用产品1和使用产品2的值不能重复';
|
errorMag += '=';
|
}
|
if((inputvalues[9] != '' && inputvalues[9] != null)&& inputvalues[7] == inputvalues[9]){
|
errorMag += 'error1 第'+i+'行数据使用产品1和使用产品3的值不能重复';
|
errorMag += '=';
|
}
|
if((inputvalues[8] != '' && inputvalues[8] != null) && (inputvalues[9] != '' && inputvalues[9] != null) && inputvalues[8] == inputvalues[9]){
|
errorMag += 'error1 第'+i+'行数据使用产品2和使用产品3的值不能重复';
|
errorMag += '=';
|
}
|
if(inputvalues[4] != '临床信息(使用量)收集' && inputvalues[4] != '市场推广类活动'){
|
if(inputvalues[10] == '' || inputvalues[10] == null){
|
errorMag += 'error1 第'+i+'行数据效果/进度不能为空';
|
errorMag += '=';
|
}
|
}
|
if(inputvalues[4] == '临床信息(使用量)收集'){
|
if(inputvalues[11] == '' || inputvalues[11] == null){
|
errorMag += 'error1 第'+i+'行数据产品1同类耗材科室月使用量不能为空';
|
errorMag += '=';
|
}
|
}
|
if(inputvalues[11] != '' && inputvalues[11] != null){
|
boolean wanked = wncc(inputvalues[11]);
|
// if(!wanked && inputvalues[11] == '' || inputvalues[11] == null){
|
if(!wanked){
|
errorMag += 'error3 第'+i+'行数据错误,请检查你的产品1同类耗材科室月使用量!';
|
errorMag += '=';
|
}
|
}
|
//暂时注掉因为ENG的术士分类为空所以暂时注掉
|
if(inputvalues[4] == '临床信息(使用量)收集'){
|
if(inputvalues[12] == '' || inputvalues[12] == null){
|
errorMag += 'error1 第'+i+'行数据产品1对应术式分类不能为空';
|
errorMag += '=';
|
}
|
}
|
if(inputvalues[4] == '临床信息(使用量)收集'){
|
if(inputvalues[13] == '' || inputvalues[13] == null){
|
errorMag += 'error1 第'+i+'行数据已采用其他产品不能为空';
|
errorMag += '=';
|
}
|
}
|
//暂时注掉因为ET的其他品牌产品类别没有数据
|
if(inputvalues[4] == '临床信息(使用量)收集' && UserProTypec.UserPro_Type__c =='ENG'){
|
if(inputvalues[14] == '' || inputvalues[14] == null){
|
errorMag += 'error1 第'+i+'行数据术士使用产品对应数量不能为空';
|
errorMag += '=';
|
}
|
}
|
if(inputvalues[4] == '临床信息(使用量)收集'){
|
if(inputvalues[15] == '' || inputvalues[15] == null){
|
errorMag += 'error1 第'+i+'行数据产品用量不能为空';
|
errorMag += '=';
|
}
|
}
|
if(inputvalues[15] != '' && inputvalues[15] != null){
|
boolean wankeds = wncc(inputvalues[15]);
|
if(!wankeds){
|
errorMag += 'error3 第'+i+'行数据错误,请检查你的产品用量!';
|
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]);
|
system.debug('inputvalues[11]====='+inputvalues[11]);
|
system.debug('inputvalues[12]====='+inputvalues[12]);
|
system.debug('inputvalues[13]====='+inputvalues[13]);
|
system.debug('inputvalues[14]====='+inputvalues[14]);
|
system.debug('inputvalues[15]====='+inputvalues[15]);
|
system.debug('inputvalues[16]====='+inputvalues[16]);
|
// system.debug('inputvalues[17]====='+inputvalues[17]);
|
//担当
|
// nameList.add(inputvalues[1]);
|
//报告日
|
dateList.add(Date.valueOf(inputvalues[0].replace('/','-')));
|
|
//经销商医院
|
ahlNameList.add(inputvalues[1]);
|
//使用产品1
|
Product2NameList.add(inputvalues[7]);
|
//使用产品2
|
Product2NameList.add(inputvalues[8]);
|
//使用产品3
|
Product2NameList.add(inputvalues[9]);
|
//效果进度
|
EffectProgressList.add(inputvalues[10]);
|
//术士分类
|
OtherBrandConsumablesList.add(inputvalues[12]);
|
//已采用其他品牌
|
ProductCcategoryList.add(inputvalues[13]);
|
//其他品牌产品类别
|
productCategoriesList.add(inputvalues[14]);
|
//科室
|
// departmentSet.add('%'+GetDepartment_Cateogy(inputvalues[2])+'%'+'-'+GetEPurposeType(inputvalues[8]));
|
//导入的数据
|
inputList.add(inputvalues);
|
}
|
}
|
}
|
// 担当名称匹配的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>();
|
// 经销商医院的ocsm医院id的list
|
List<String> ahlOcsmIdList = new List<String>();
|
// 经销商医院id的List
|
List<String> ahlIdList = new List<String>();
|
// 使用产品1，2，3
|
Map<String,Product2> UseProductMap = new Map<String,Product2>();
|
// 效果进度
|
Map<String,FieldClassification__c> EffectProgressMap = new Map<String,FieldClassification__c>();
|
// 术士分类
|
Map<String,FieldClassification__c> OtherBrandConsumablesMap = new Map<String,FieldClassification__c>();
|
Map<String,AggregateResult> OtherBrandConsumablesMap2 = new Map<String,AggregateResult>();
|
// 已采用其他产品
|
Map<String,FieldClassification__c> ProductCcategorynMap = new Map<String,FieldClassification__c>();
|
// 其他品牌产品类别
|
Map<String,FieldClassification__c> productCategoriesMap = new Map<String,FieldClassification__c>();
|
// 使用产品id的List
|
List<String> UseProductIdList = new List<String>();
|
// 效果进度id的List
|
List<String> EffectProgressIdList = new List<String>();
|
// 术士分类id的List
|
List<String> OtherBrandConsumablesIdList = new List<String>();
|
// 已采用其他品牌id的List
|
List<String> ProductCcategorynIdList = new List<String>();
|
// 其他品牌产品类别id的List productCategoriesMap
|
List<String> productCategoriesIdList = new List<String>();
|
// 产品区分的map
|
Map<String,String> protypeMap = new Map<String,String>();
|
// 获取每周第一天的map
|
Map<Date,Date> dateMap = new Map<Date,Date>();
|
// 根据日期获取olympus日历id的map
|
Map<Date,String> dateIdMap = new Map<Date,String>();
|
// 根据经销商医院的ocsm医院获取的所有.客户人员的信息的名称和id的map DealerPersonnelMap
|
Map<String,String> doctor2Map = new Map<String,String>();
|
//存放经销商人员的Map
|
Map<String,String> DealerPersonnelMap = new Map<String,String>();
|
// 经销商询价的map
|
Map<String,Agency_Opportunity__c> aoMap = new Map<String,Agency_Opportunity__c>();
|
//术式分类 的连个下拉选项
|
List<FieldClassification__c> FieldClassification2List;
|
List<AggregateResult> WarlockClassificationList2;
|
|
List<Contact> conList = LightningUtil.selectAgencyPerson03();
|
List<OlympusCalendar__c> olympusDateList = [select Id,Date__c,FirstDayOfWeek__c,DayOfTheWeek__c from OlympusCalendar__c where Date__c= :dateList ];
|
//医院
|
List<Agency_Hospital_Link__c> ahlList;
|
Contact conStrList = [select AccountId from contact where id in (select ContactId from User where id =: SignInId)];
|
String strAgencyId =conStrList.AccountId;
|
System.debug('UserProTypec.UserPro_Type__c = ' + UserProTypec.UserPro_Type__c);
|
if(UserProTypec.UserPro_Type__c == 'ENG'){
|
ahlList = [select id,name,Hospital__c,MaxActivityDate__c from Agency_Hospital_Link__c where Agency__c =: strAgencyId and name = :ahlNameList and AgencyHos_ENG__c = true and Agency_Campaign_Obj__c = true];
|
}else {
|
ahlList = [select id,name,Hospital__c,MaxActivityDate__c from Agency_Hospital_Link__c where Agency__c =: strAgencyId and name = :ahlNameList and AgencyHos_ET__c = true and Agency_Campaign_Obj__c = true];
|
}
|
// 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<Product2> pr2List;
|
if(UserProTypec.UserPro_Type__c == 'ET'){
|
pr2List = [select Id, Name,Category3__c,Asset_Model_No__c from Product2 where Asset_Model_No__c in:Product2NameList AND Dealer_Object__c = true AND Estimation_Entry_Possibility__c = '○'];
|
}else{
|
pr2List = [select Id, Name,Category3__c,Asset_Model_No__c from Product2 where Category4__c='Thunderbeat' AND Asset_Model_No__c in:Product2NameList AND ENG_DeaerProFlag__c = true AND Estimation_Entry_Possibility__c = '○'];
|
}
|
system.debug('pr2List++'+pr2List);
|
// List<Product2> pr2List = [select id,name from Product2 where name in:Product2NameList];
|
List<FieldClassification__c> FieldClassification1List = [select id,EffectProgress__c from FieldClassification__c where EffectProgress__c in :EffectProgressList];
|
if(UserProTypec.UserPro_Type__c =='ET'){
|
FieldClassification2List = [select id,WarlockClassification__c from FieldClassification__c where WarlockClassification__c in :OtherBrandConsumablesList];
|
}else{
|
WarlockClassificationList2 = [select count(id) sum, Category4__c from product2 where ENG_DeaerProFlag__c = true group by Category4__c ];
|
}
|
List<FieldClassification__c> FieldClassification3List = [select id,ProductCcategory__c from FieldClassification__c where ProductCcategory__c in :ProductCcategoryList];
|
List<FieldClassification__c> FieldClassification4List = [select id,productCategories__c from FieldClassification__c where productCategories__c in :productCategoriesList];
|
|
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);
|
}
|
}
|
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);
|
}
|
// for(Contact con :conList){
|
// nameIdMap.put(con.Name.replace(' ',''), con.Id);
|
// nameConMap.put(con.Id, con.Name);
|
// }
|
// return testuse;
|
System.debug('ahlList = ' + ahlList);
|
for(Agency_Hospital_Link__c ahl : ahlList){
|
ahlMap.put(ahl.Name, ahl);
|
ahlOcsmIdList.add(ahl.Hospital__c);
|
ahlIdList.add(ahl.Id);
|
}
|
for(Product2 pr2 : pr2List){
|
UseProductMap.put(pr2.Asset_Model_No__c, pr2);
|
UseProductIdList.add(pr2.Id);
|
}
|
for(FieldClassification__c ep : FieldClassification1List){
|
EffectProgressMap.put(ep.EffectProgress__c, ep);
|
EffectProgressIdList.add(ep.Id);
|
}
|
//术式分类
|
if(UserProTypec.UserPro_Type__c =='ET'){
|
for(FieldClassification__c oc : FieldClassification2List){
|
OtherBrandConsumablesMap.put(oc.WarlockClassification__c, oc);
|
OtherBrandConsumablesIdList.add(oc.Id);
|
}
|
}else{
|
for(AggregateResult oc : WarlockClassificationList2){
|
OtherBrandConsumablesMap2.put(string.valueOf(oc.get('Category4__c')), oc);
|
}
|
}
|
|
for(FieldClassification__c pc : FieldClassification3List){
|
ProductCcategorynMap.put(pc.ProductCcategory__c, pc);
|
ProductCcategorynIdList.add(pc.Id);
|
}
|
for(FieldClassification__c pct : FieldClassification4List){
|
productCategoriesMap.put(pct.productCategories__c, pct);
|
productCategoriesIdList.add(pct.Id);
|
}
|
// List<Agency_Contact__c> doctor2list = [select id,Name,Doctor_Division1__c,Type__c,Agency_Hospital__c FROM Agency_Contact__c WHERE Hospital_ID18__c= :ahlOcsmIdList order by Name];
|
//List<Agency_Contact__c> doctor2list = [select id,Name,Doctor_Division1__c,Type__c,Agency_Hospital__c,AWS_Data_Id__c,Name_Encrypted__c FROM Agency_Contact__c WHERE Hospital_ID18__c= :ahlOcsmIdList order by Name];
|
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 去掉Name_Encrypted__c 新方案改造 2022-12-21
|
for(Agency_Contact__c ac : doctor2list){
|
// doctor2Map.put(ac.Name.replace(' ',''), ac.Id);
|
//doctor2Map.put(ac.Name_Encrypted__c, ac.Id); //zhj 新方案改造 2022-12-21
|
doctor2Map.put(ac.AWS_Data_Id__c, ac.Id);
|
}
|
//经销商人员 DealerPersonnel
|
List<contact> conListLighrningUtil = LightningUtil.selectAgencyPerson02();
|
for(contact de : conListLighrningUtil){
|
DealerPersonnelMap.put(de.Name.replace(' ',''), de.Id);
|
}
|
// 创建日报
|
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>();
|
//zxk 存放担当
|
for(List<String> lineList :inputList){
|
Date week = Date.today();
|
String s_agency = null;
|
String s_agencyname = null;
|
if(dateMap.get(Date.valueOf(lineList[0].replace('/','-'))) != null){
|
week = dateMap.get(Date.valueOf(lineList[0].replace('/','-')));
|
}
|
// if(nameIdMap.get(lineList[0].replace(' ','')) != null){
|
// s_agency = nameIdMap.get(lineList[0].replace(' ',''));
|
// s_agencyname = nameConMap.get(nameIdMap.get(lineList[0].replace(' ','')));
|
if(conList != null &&conList.size()!=0){
|
s_agency = conList[0].Id;
|
s_agencyname = conList[0].Name;
|
}
|
Agency_Report_Header__c agency_report_header = new Agency_Report_Header__c();
|
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();
|
if(agency_report_headerlist.size() > 0){
|
LightningUtil.upsertMAgencyReportHeader(agency_report_headerlist);
|
}
|
List<Agency_Report__c> arList = new List<Agency_Report__c>();
|
Integer hang = 1;
|
User UserPro = LightningUtil.loginUserId();
|
String UserProTypeStr = UserPro.UserPro_Type__c;
|
for(List<String> lineList :inputList){
|
// 创建日报明细
|
Date week = null;
|
String s_agency = null;
|
if(dateMap.get(Date.valueOf(lineList[0].replace('/','-'))) != null){
|
week = dateMap.get(Date.valueOf(lineList[0].replace('/','-')));
|
}
|
// if(nameIdMap.get(lineList[0].replace(' ','')) != null){
|
// s_agency = nameIdMap.get(lineList[0].replace(' ',''));
|
// }
|
if(conList != null &&conList.size()!=0){
|
s_agency = conList[0].Id;
|
}
|
Agency_Report__c agencyReport = new Agency_Report__c();
|
if(week == null && lineList[0] != '' && lineList[0] != null){
|
errorMag += 'error2 第'+hang+'行数据报告日 '+lineList[0]+'填写有误';
|
errorMag += '=';
|
}
|
agencyReport.Submit_date__c = week;
|
// if((s_agency == null || s_agency == '')&& lineList[0] != '' && lineList[0] != null){
|
// errorMag += 'error2 第'+hang+'行数据担当'+lineList[0]+'不存在';
|
// errorMag += '=';
|
// }
|
agencyReport.Person_In_Charge2__c = s_agency;
|
if(lineList[0] != null && lineList[0] != ''){
|
agencyReport.Report_Date__c = Date.valueOf(lineList[0].replace('/','-'));
|
}
|
System.debug('ahlMap = ' + ahlMap);
|
System.debug('lineList[1] = ' + lineList[1]);
|
if(ahlMap.containsKey(lineList[1])){
|
agencyReport.Agency_Hospital__c = ahlMap.get(lineList[1]).Id;
|
ahlMap.get(lineList[1]).MaxActivityDate__c = week;
|
}else{
|
if(lineList[1] != '' && lineList[1] != null){
|
errorMag += 'error2 第'+hang+'行数据经销商医院 '+lineList[1]+'不存在';
|
errorMag += '=';
|
}
|
}
|
// String departmentE = GetDepartment_Cateogy(lineList[2]);
|
// if(departmentE != 'no'){// fy Department_Cateogy_text__c
|
// agencyReport.Department_Cateogy__c = departmentE;
|
agencyReport.Department_Cateogy_text__c =lineList[2];
|
// }else{
|
// }
|
if(DealerPersonnelMap.containsKey(lineList[3].replace(' ',''))){
|
agencyReport.DealerPersonnel__c = DealerPersonnelMap.get(lineList[3].replace(' ',''));
|
}else{
|
if(lineList[3] != '' && lineList[3] != null){
|
errorMag += 'error2 第'+hang+'行数据经销商人员 '+lineList[3]+'不存在';
|
errorMag += '=';
|
}
|
}
|
if(GetPurposeType(lineList[4])){
|
agencyReport.WorkRecord__c = lineList[4];
|
}
|
if(agencyReport.WorkRecord__c == '科室会'){
|
if(lineList[5]=='医生'||lineList[5]=='医生+护士'||lineList[5]=='医生＋护士'){
|
agencyReport.doctor3__c = lineList[5];
|
}else{
|
if(lineList[5] != '' && lineList[5] != null){
|
errorMag += 'error2 第'+hang+'行数据拜访人 '+lineList[5]+'不存在';
|
errorMag += '=';
|
}
|
}
|
}else{
|
// if(doctor2Map.containsKey(lineList[5].replace(' ',''))){
|
if(doctor2Map.containsKey(lineList[5])){
|
// if(agencyReport.WorkRecord__c == '科室会'){
|
// agencyReport.doctor3__c = doctor2Map.get(lineList[5].replace(' ',''));
|
// }else{
|
// agencyReport.doctor2__c = doctor2Map.get(lineList[5].replace(' ',''));
|
agencyReport.doctor2__c = doctor2Map.get(lineList[5]);
|
// }
|
}else{
|
if(lineList[5] != '' && lineList[5] != null){
|
errorMag += 'error2 第'+hang+'行数据客户人员 '+lineList[5]+'不存在';
|
errorMag += '=';
|
}
|
}
|
}
|
if(GetProductClassification(lineList[6])){
|
agencyReport.ProductClassification__c = lineList[6];
|
}
|
system.debug('UseProductMap+++'+UseProductMap);
|
system.debug('agencyReport.ProductClassification__c+++'+agencyReport.ProductClassification__c);
|
if(UseProductMap.containsKey(lineList[7])){
|
if(UseProductMap.get(lineList[7]).Category3__c==agencyReport.ProductClassification__c){
|
agencyReport.UseProduct1__c = UseProductMap.get(lineList[7]).Id;
|
}else{
|
errorMag += 'error2 第'+hang+'行数据使用产品1产品型号 '+lineList[7]+'和第三分类无法匹配';
|
errorMag += '=';
|
}
|
// agencyReport.UseProduct1__c = UseProductMap.get(lineList[7]).Id;
|
}else{
|
if(lineList[7] != '' && lineList[7] != null){
|
errorMag += 'error2 第'+hang+'行数据使用产品1 '+lineList[7]+'不存在';
|
errorMag += '=';
|
}
|
}
|
|
if(UseProductMap.containsKey(lineList[8])){
|
if(UseProductMap.get(lineList[8]).Category3__c==agencyReport.ProductClassification__c){
|
agencyReport.UseProduct2__c = UseProductMap.get(lineList[8]).Id;
|
}else{
|
errorMag += 'error2 第'+hang+'行数据使用产品2产品型号 '+lineList[8]+'和第三分类无法匹配';
|
errorMag += '=';
|
}
|
// agencyReport.UseProduct2__c = UseProductMap.get(lineList[8]).Id;
|
}else{
|
if(lineList[8] != '' && lineList[8] != null){
|
errorMag += 'error2 第'+hang+'行数据使用产品2 '+lineList[8]+'不存在';
|
errorMag += '=';
|
}
|
}
|
if(UseProductMap.containsKey(lineList[9])){
|
if(UseProductMap.get(lineList[9]).Category3__c==agencyReport.ProductClassification__c){
|
agencyReport.UseProduct3__c = UseProductMap.get(lineList[9]).Id;
|
}else{
|
errorMag += 'error2 第'+hang+'行数据使用产品3产品型号 '+lineList[9]+'和第三分类无法匹配';
|
errorMag += '=';
|
}
|
// agencyReport.UseProduct3__c = UseProductMap.get(lineList[9]).Id;
|
}else{
|
if(lineList[9] != '' && lineList[9] != null){
|
errorMag += 'error2 第'+hang+'行数据使用产品3 '+lineList[9]+'不存在';
|
errorMag += '=';
|
}
|
}
|
if(EffectProgressMap.containsKey(lineList[10])){
|
agencyReport.EffectProgress__c = EffectProgressMap.get(lineList[10]).EffectProgress__c;
|
}
|
boolean wankeds1 = wncc(lineList[11]);
|
if(lineList[11] != null && lineList[11] != ''&&wankeds1){
|
agencyReport.ConsumptionOfConsumables__c = Decimal.valueOf(lineList[11]);
|
}
|
if(UserProTypec.UserPro_Type__c =='ET'){
|
if(OtherBrandConsumablesMap.containsKey(lineList[12])){
|
agencyReport.WarlockClassification__c = OtherBrandConsumablesMap.get(lineList[12]).WarlockClassification__c;
|
}
|
// else{
|
// if(lineList[12]!=null &&lineList[12]!=''){
|
// errorMag += 'error2 第'+hang+'行数据产品1对应术式分类'+lineList[12]+'不存在';
|
// errorMag += '=';
|
// }
|
// }
|
}else{
|
if(OtherBrandConsumablesMap2.containsKey(lineList[12])){
|
agencyReport.WarlockClassification__c = string.valueOf(OtherBrandConsumablesMap2.get(lineList[12]).get('Category4__c'));
|
}
|
// else{
|
// if(lineList[12]!=null &&lineList[12]!=''){
|
// errorMag += 'error2 第'+hang+'行数据产品1对应术式分类'+lineList[12]+'不存在';
|
// errorMag += '=';
|
// }
|
// }
|
}
|
if(ProductCcategorynMap.containsKey(lineList[13])){
|
agencyReport.ProductCcategory__c = ProductCcategorynMap.get(lineList[13]).ProductCcategory__c;
|
}
|
if(UserProTypec.UserPro_Type__c == 'ENG'){
|
if(productCategoriesMap.containsKey(lineList[14])){
|
agencyReport.productCategories__c = productCategoriesMap.get(lineList[14]).productCategories__c;
|
}
|
}
|
boolean wankeds2 = wncc(lineList[15]);
|
if(lineList[15] != null && lineList[15] != ''&&wankeds2){
|
agencyReport.warlocksNumber__c = Decimal.valueOf(lineList[15]);
|
}
|
system.debug('lineList[16]=='+lineList[16]+'+++');
|
String workmarkvalue=lineList[16].trim();
|
system.debug('workmarkvalue==++'+workmarkvalue+'+++');
|
if(workmarkvalue=='需要'){
|
agencyReport.WorkMark__c = true;
|
}else{
|
agencyReport.WorkMark__c = false;
|
}
|
system.debug('agencyReport.WorkMark__c+++'+agencyReport.WorkMark__c);
|
agencyReport.WeeklyReportClassification__c = UserProTypeStr;
|
String headerStr = createHeader(week,s_agency);
|
if(agency_report_headerMap.containsKey(headerStr)){
|
agencyReport.Agency_Report_Header__c = agency_report_headerMap.get(headerStr).Id;
|
}
|
hang++;
|
arList.add(agencyReport);
|
}
|
|
if(errorMag != ''){
|
system.debug('errorMag==========>'+errorMag);
|
return errorMag;
|
}
|
// 更新经销商意愿的最新周
|
if(ahlMap.values().size() > 0 ){
|
update ahlMap.values();
|
}
|
// 新增日报明细
|
if(arList.size() > 0 ){
|
system.debug('arList==================>'+arList);
|
LightningUtil.insertMAgencyReport(arList);
|
}
|
}
|
return 'success';
|
}catch(Exception e){
|
System.debug('exception'+e);
|
return e.getLineNumber()+'exception'+e;
|
}
|
}
|
|
// 创建唯一键
|
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 == '呼吸科' || department == 'BF'){
|
departmentE = 'BF';
|
}
|
if(department == '耳鼻喉科' || department == 'ENT'){
|
departmentE = 'ENT';
|
}
|
if(department == 'ET耗材' || department == 'ET'){
|
departmentE = 'ET';
|
}
|
if(department == '消化科' || department == 'GI'){
|
departmentE = 'GI';
|
}
|
if(department == '普外科' || department == 'GS'){
|
departmentE = 'GS';
|
}
|
if(department == '妇科' || department == 'GYN'){
|
departmentE = 'GYN';
|
}
|
if(department == '其他' || department == 'OTH'){
|
departmentE = 'OTH';
|
}
|
if(department == '泌尿科' || department == 'URO'){
|
departmentE = 'URO';
|
}
|
return departmentE;
|
}
|
|
// 判断活动区分是否存在
|
public static boolean GetPurposeType(String purposeType){
|
Schema.DescribeFieldResult fieldResult = Agency_Report__c.WorkRecord__c.getDescribe();
|
List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues();
|
for( Schema.PicklistEntry pickListVal : ple){
|
if(pickListVal.getValue() == purposeType){
|
return true;
|
}
|
}
|
return false;
|
}
|
// 判断效果/进度是否存在
|
public static boolean GetProductClassification(String purposeType){
|
Schema.DescribeFieldResult fieldResult = Agency_Report__c.ProductClassification__c.getDescribe();
|
List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues();
|
for( Schema.PicklistEntry pickListVal : ple){
|
if(pickListVal.getValue() == purposeType){
|
return true;
|
}
|
}
|
return false;
|
}
|
|
// 术士对应产品使用数量和科室同类耗材月使用数量验证必须数字
|
public static boolean wncc(String wancco){
|
Pattern pattern = Pattern.compile('^[-\\\\+]?([0-9]+\\\\.?)?[0-9]+$');
|
Matcher isNum = pattern.matcher(wancco);
|
if (isNum.matches() && wancco.length() <= 14) {
|
return true;
|
}
|
return false;
|
}
|
|
// 判断产品区分是否满足要求
|
public static String ifTrueProduct(List<Map<String,String>> prolist,String str){
|
for(Map<String,String> strmap :prolist){
|
if(strmap.get('label')==str){
|
return strmap.get('value');
|
}
|
}
|
return '';
|
}
|
// 批量添加日报by vivek end
|
//SWAG-CF58C3 fy start
|
@RemoteAction
|
@AuraEnabled
|
public static Map<String, String> saveAgencyContact(String name, String type,String doctorDivision1, String agencyHospitalid, String awsid) {
|
//String name, String nameEncrypt, String type, String typeEncrypt, String doctorDivision1, String doctorDivision1Encrypt, String agencyHospitalid, String awsid //zhj 新方案改造 2023-12-21
|
Agency_Contact__c agency_contact = new Agency_Contact__c();
|
|
agency_contact.Name = name;
|
//agency_contact.Name_Encrypted__c = nameEncrypt; //zhj 新方案改造 2023-12-21
|
agency_contact.Type__c = type;
|
//agency_contact.Type_Encrypted__c = typeEncrypt; //zhj 新方案改造 2023-12-21
|
agency_contact.Doctor_Division1__c = doctorDivision1;
|
//agency_contact.Doctor_Division1_Encrypted__c = doctorDivision1Encrypt; //zhj 新方案改造 2023-12-21
|
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;
|
}
|
//SWAG-CF58C3 fy start
|
@RemoteAction
|
@AuraEnabled
|
public static List<Map<String,String>> newlyBuild(String hospital_id,String nameer, String type, String doctorDivision1){
|
List<Map<String,String>> ret = new List<Map<String,String>>();
|
Map<String,String> space = new Map<String,String>();
|
boolean flag = false;
|
space.put('label', '');
|
space.put('value', '');
|
space.put('selected', 'true');
|
ret.add(space);
|
|
// 戦略科室IDを取得して、それをもとに顧客をSELECT
|
Agency_Hospital_Link__c ahl = [select Hospital__c from Agency_Hospital_Link__c where id = :hospital_id];
|
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];
|
for(Agency_Contact__c row01 : doctor_list){
|
if(row01.Name != nameer){
|
flag = true;
|
}
|
}
|
if(flag == true){
|
Agency_Contact__c acc = new Agency_Contact__c();
|
acc.Name = nameer;
|
acc.Type__c = type;
|
acc.Doctor_Division1__c = doctorDivision1;
|
acc.Agency_Hospital__c = hospital_id;
|
insert acc;
|
}
|
List<Agency_Contact__c> doctor_list01 = [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];
|
|
for (Agency_Contact__c row : doctor_list01)
|
{
|
Map<String,String> tmp = new Map<String,String>();
|
tmp.put('label',row.Name);
|
tmp.put('value', row.Id);
|
tmp.put('selected', 'false');
|
tmp.put('Doctor_Division1__c', row.Doctor_Division1__c);
|
ret.add(tmp);
|
}
|
return ret;
|
}
|
|
@RemoteAction
|
@AuraEnabled
|
public static List<Map<String,String>> selectPurposeTypes(String doctor_value){
|
system.debug('doctor_value===============>'+doctor_value);
|
List<FieldClassification__c> eftpcList;
|
if(String.isNotBlank(doctor_value)){
|
// eftpcList = [select id, Name , WorkRecord__c from EffectProgress__c where WorkRecord__c =: doctor_value];
|
eftpcList = [Select Id,WorkRecord__c,EffectProgress__c from FieldClassification__c where WorkRecord__c =: doctor_value];
|
|
}
|
List<Map<String,String>> options = new List<Map<String,String>>();
|
Map<String,String> space = new Map<String,String>();
|
space.put('label', '');
|
space.put('value', '');
|
options.add(space);
|
for(FieldClassification__c efptc : eftpcList){
|
Map<String,String> efptcMap = new Map<String,String>();
|
efptcMap.put('label', efptc.EffectProgress__c);
|
efptcMap.put('value', efptc.EffectProgress__c);
|
options.add(efptcMap);
|
}
|
system.debug('options===============>'+options);
|
return options;
|
}
|
@RemoteAction
|
@AuraEnabled
|
public static List<Map<String,String>> selectProductClassificationc(String select_ProductClassification){
|
//fy
|
List<FieldClassification__c> WarlockClassificationList;
|
List<AggregateResult> WarlockClassificationList2;
|
User UserProTypec = LightningUtil.loginUserId();
|
if(String.isNotBlank(select_ProductClassification)){
|
// WarlockClassificationList = [select id, Name , ProductClassification__c from WarlockClassification__c where ProductClassification__c =: select_ProductClassification];
|
if(UserProTypec.UserPro_Type__c =='ET'){
|
WarlockClassificationList = [select id , ProductClassification__c,WarlockClassification__c from FieldClassification__c where ProductClassification__c =: select_ProductClassification];
|
}else{
|
// WarlockClassificationList2 = [select count(id) sum, Category4__c from product2 where Category3__c =: select_ProductClassification and ENG_DeaerProFlag__c = true group by Category4__c ];
|
WarlockClassificationList2 = [select count(id) sum, Category4__c from product2 where ENG_DeaerProFlag__c = true group by Category4__c ];
|
}
|
}
|
List<Map<String,String>> options = new List<Map<String,String>>();
|
Map<String,String> space = new Map<String,String>();
|
space.put('label', '');
|
space.put('value', '');
|
options.add(space);
|
if(UserProTypec.UserPro_Type__c =='ET'){
|
for(FieldClassification__c WarlockClassification : WarlockClassificationList){
|
Map<String,String> WarlockClassificationMap = new Map<String,String>();
|
WarlockClassificationMap.put('label', WarlockClassification.WarlockClassification__c);
|
WarlockClassificationMap.put('value', WarlockClassification.WarlockClassification__c);
|
options.add(WarlockClassificationMap);
|
}
|
}else{
|
for(AggregateResult WarlockClassification2 : WarlockClassificationList2){
|
Map<String,String> WarlockClassificationMap2 = new Map<String,String>();
|
WarlockClassificationMap2.put('label', string.valueOf(WarlockClassification2.get('Category4__c')));
|
WarlockClassificationMap2.put('value', string.valueOf(WarlockClassification2.get('Category4__c')));
|
options.add(WarlockClassificationMap2);
|
}
|
}
|
return options;
|
}
|
@RemoteAction
|
@AuraEnabled
|
public static List<Map<String,String>> selectProductCcategory(){
|
List<FieldClassification__c> ProductCcategoryList;
|
User UserProETENG = LightningUtil.loginUserId();
|
if(UserProETENG.UserPro_Type__c == 'ET'){
|
ProductCcategoryList = [select id, ProductCcategory__c from FieldClassification__c where classification__c =: 'ET'];
|
}else{
|
ProductCcategoryList = [select id, ProductCcategory__c from FieldClassification__c where classification__c =: 'ENG'];
|
}
|
List<Map<String,String>> options = new List<Map<String,String>>();
|
Map<String,String> space = new Map<String,String>();
|
space.put('label', '');
|
space.put('value', '');
|
options.add(space);
|
for(FieldClassification__c ProductCcategory : ProductCcategoryList){
|
Map<String,String> ProductCcategorynMap = new Map<String,String>();
|
ProductCcategorynMap.put('label', ProductCcategory.ProductCcategory__c);
|
ProductCcategorynMap.put('value', ProductCcategory.ProductCcategory__c);
|
options.add(ProductCcategorynMap);
|
}
|
return options;
|
}
|
@RemoteAction
|
@AuraEnabled
|
public static List<Map<String,String>> selectProductCcategory01(String select_ProductCcategory){
|
List<FieldClassification__c> productCategoriesList;
|
User UserProETENG = LightningUtil.loginUserId();
|
System.debug('UserProETENG.UserPro_Type__c=============>'+UserProETENG.UserPro_Type__c);
|
System.debug('select_ProductCcategory=============>'+select_ProductCcategory);
|
FieldClassification__c fi = [Select ProductCcategory__c from FieldClassification__c where ProductCcategory__c =: select_ProductCcategory limit 1];
|
if(UserProETENG.UserPro_Type__c == 'ET'){
|
productCategoriesList = [select id, productCategories__c,ET_ENG_classification__c,ProductCcategory__c from FieldClassification__c where ProductCcategory__c =: fi.ProductCcategory__c AND ET_ENG_classification__c =: 'ET'];
|
}else{
|
productCategoriesList = [select id, productCategories__c,ET_ENG_classification__c,ProductCcategory__c from FieldClassification__c where ProductCcategory__c =:fi.ProductCcategory__c AND ET_ENG_classification__c =: 'ENG'];
|
}
|
List<Map<String,String>> options = new List<Map<String,String>>();
|
Map<String,String> space = new Map<String,String>();
|
space.put('label', '');
|
space.put('value', '');
|
options.add(space);
|
for(FieldClassification__c productCategories : productCategoriesList){
|
Map<String,String> productCategoriesMap = new Map<String,String>();
|
productCategoriesMap.put('label', productCategories.productCategories__c);
|
productCategoriesMap.put('value', productCategories.productCategories__c);
|
options.add(productCategoriesMap);
|
}
|
System.debug('options=============>'+options);
|
return options;
|
}
|
//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;
|
}
|
}
|
public static void improveTestRate(){
|
Integer i = 0;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
i++;
|
}
|
//zhj MEBG新方案改造 2022-11-29 end
|
}
|
