From 6947068a02499b9d1022f9efca5bcf1bdd3f1c70 Mon Sep 17 00:00:00 2001
From: Denny Chen <chenbangcai@prec-tech.com>
Date: 星期一, 28 二月 2022 10:45:11 +0800
Subject: [PATCH] Note test
---
force-app/main/default/classes/RetrospectiveWeeklyReportController.cls | 293 +++++++++++++++++++++++++++++++++++-----------------------
1 files changed, 175 insertions(+), 118 deletions(-)
diff --git a/force-app/main/default/classes/RetrospectiveWeeklyReportController.cls b/force-app/main/default/classes/RetrospectiveWeeklyReportController.cls
index 40db4e8..4f7d67c 100644
--- a/force-app/main/default/classes/RetrospectiveWeeklyReportController.cls
+++ b/force-app/main/default/classes/RetrospectiveWeeklyReportController.cls
@@ -11,9 +11,15 @@
public RetrospectiveWeeklyReportController() {
}
public void UserDoin(){
+ system.debug('222222222222222================>');
+
User UserProTypec = LightningUtil.loginUserId();
+ system.debug('3333333333333================>'+UserProTypec);
+
this.UserProType = '';
this.UserProType = UserProTypec.UserPro_Type__c;
+ system.debug('444444444444444================>'+this.UserProType);
+
}
public void setalldata()
@@ -24,6 +30,7 @@
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>>();
@@ -43,6 +50,7 @@
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>();
@@ -51,7 +59,8 @@
space01.put('selected', 'true');
tmp01.add(space01);
// 缁忛攢鍟嗕汉鍛� DealerPersonnel__c
- List<Contact> agency_person_data01 = LightningUtil.selectAgencyPerson();
+ 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);
@@ -85,6 +94,9 @@
//浜у搧绫诲埆
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'));
@@ -190,6 +202,7 @@
@AuraEnabled
public static RetrospectiveWeeklyReportController getalldata(){
RetrospectiveWeeklyReportController li = new RetrospectiveWeeklyReportController();
+ system.debug('1111111111111111111111================>');
li.UserDoin();
li.setalldata();
return li;
@@ -205,7 +218,6 @@
@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;
}
@@ -228,6 +240,7 @@
@AuraEnabled
public static List<Agency_Hospital_Link__c> getHospitalList(String hospital_name) {
User login_user_id = LightningUtil.loginUserId();
+
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 Hospital_Name_readonly__c like :hospital_name and AgencyHos_ENG__c = true];
@@ -252,7 +265,6 @@
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>();
- boolean flag = false;
space.put('label', '');
space.put('value', '');
space.put('selected', 'true');
@@ -277,14 +289,14 @@
@RemoteAction
@AuraEnabled
public static String saveAgencyReport(String Department_Cateogy,Decimal ConsumptionOfConsumables,
- Boolean WorkMark,Decimal warlocksNumber,String DealerPersonnel,String ProductCcategory,String OtherBrandConsumables,
+ Boolean WorkMark,Decimal warlocksNumber,String DealerPersonnel,String ProductCcategory,String productCategories ,String OtherBrandConsumables,
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 = makeAgencyReport(Department_Cateogy,ConsumptionOfConsumables,
- WorkMark,warlocksNumber,DealerPersonnel,ProductCcategory,OtherBrandConsumables,ProductClassification, WorkRecord,
+ WorkMark,warlocksNumber,DealerPersonnel,ProductCcategory,productCategories,OtherBrandConsumables,ProductClassification, WorkRecord,
EffectProgress,Agency_Report_Header,
Agency_Hospital, Person_In_Charge2, doctor, Submit_date,
UseProduct1, UseProduct2, UseProduct3,
@@ -294,7 +306,7 @@
return agency_report.Id;
}
public static Agency_Report__c makeAgencyReport(String Department_Cateogy,Decimal ConsumptionOfConsumables,
- boolean WorkMark,Decimal warlocksNumber, String DealerPersonnel,String ProductCcategory,String OtherBrandConsumables,
+ boolean WorkMark,Decimal warlocksNumber, String DealerPersonnel,String ProductCcategory,String productCategories,String OtherBrandConsumables,
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,
@@ -342,8 +354,9 @@
if (UseProduct1 != '') { agency_report.UseProduct1__c = UseProduct1; }
if (UseProduct2 != '') { agency_report.UseProduct2__c = UseProduct2; }
if (UseProduct3 != '') { agency_report.UseProduct3__c = UseProduct3; }
- if (OtherBrandConsumables != '') { agency_report.OtherBrandConsumables__c = OtherBrandConsumables; }
+ if (OtherBrandConsumables != '') { agency_report.OtherBrandConsumables__c = OtherBrandConsumables; }
if (ProductCcategory != '') { agency_report.ProductCcategory__c = ProductCcategory; }
+ if (productCategories != '') { agency_report.productCategories__c = productCategories; }
if (warlocksNumber != null) { agency_report.warlocksNumber__c = warlocksNumber; }
if (WorkMark != false) {
agency_report.WorkMark__c = WorkMark;
@@ -355,7 +368,7 @@
@AuraEnabled
public static String editAgencyReport(String Agency_Report_Id, String Department_Cateogy,
Decimal ConsumptionOfConsumables,boolean WorkMark,Decimal warlocksNumber,
- String DealerPersonnel,String OtherBrandConsumables,String ProductCcategory,String ProductClassification,
+ String DealerPersonnel,String OtherBrandConsumables,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,
@@ -365,7 +378,7 @@
return null;
}
Agency_Report__c agency_report = [select Id, Name, Department_Cateogy__c, ConsumptionOfConsumables__c, WorkRecord__c,OtherBrandConsumables__c,
- ProductCcategory__c, warlocksNumber__c,WorkMark__c,ProductClassification__c,DealerPersonnel__c, Agency_Report_Header__c,Agency_Hospital__c,UseProduct1__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,Submit_date__c,Report_Date__c
from Agency_Report__c where id=:Agency_Report_Id];
Date week = Date.valueOf(Submit_date);
@@ -401,8 +414,9 @@
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 (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 (OtherBrandConsumables != '') { agency_report.OtherBrandConsumables__c = OtherBrandConsumables; } else { agency_report.OtherBrandConsumables__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; }
@@ -433,8 +447,6 @@
// 閫卞牨銉囥兗銈裤倰鍙栧緱
Date week = Date.valueOf(date_str);
this.reports = LightningUtil.selectAgencyReport01(week, person_str);
- system.debug('this.reports==========>'+this.reports);
-
}
@RemoteAction
@@ -452,9 +464,7 @@
Date date1_date = Date.valueOf(date1);
Date date2_date = Date.valueOf(date2);
RetrospectiveWeeklyReportController li = new RetrospectiveWeeklyReportController();
-
List<Contact> conMList = LightningUtil.selectAgencyPerson01();
- system.debug('conMList===========>'+conMList);
return LightningUtil.selectMAgencyReport(date1_date, date2_date, conMList);
}
@@ -466,6 +476,7 @@
@AuraEnabled
public static String processData(String fileData,String sobjectName,List<String> fields) {
String errorMag = '';
+ System.debug('fileData=================>'+fileData);
// 鍒涘缓鍛ㄦ姤
try{
if(fileData!=null){
@@ -486,6 +497,10 @@
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>();
// 缁忛攢鍟嗚浠峰悕绉發ist
@@ -532,53 +547,63 @@
errorMag += '=';
}
if(inputvalues[7] == '' || inputvalues[7] == null){
- errorMag += 'error1 绗�'+i+'琛屾暟鎹鎴蜂汉鍛樹笉鑳戒负绌�';
+ errorMag += 'error1 绗�'+i+'琛屾暟鎹尰闄汉鍛樹笉鑳戒负绌�';
errorMag += '=';
}
- if(inputvalues[10] == '' || inputvalues[10] == null){
+ if(inputvalues[8] == '' || inputvalues[8] == null){
+ errorMag += 'error1 绗�'+i+'琛屾暟鎹骇鍝佸垎绫�(绗笁鍒嗙被)涓嶈兘涓虹┖';
+ errorMag += '=';
+ }
+ if(inputvalues[9] == '' || inputvalues[9] == null){
errorMag += 'error1 绗�'+i+'琛屾暟鎹娇鐢ㄤ骇鍝�1涓嶈兘涓虹┖';
errorMag += '=';
}
- if((inputvalues[11] != '' && inputvalues[11] != null)&& inputvalues[10] == inputvalues[11]){
+ if((inputvalues[10] != '' && inputvalues[10] != null)&& inputvalues[9] == inputvalues[10]){
errorMag += 'error1 绗�'+i+'琛屾暟鎹娇鐢ㄤ骇鍝�1鍜屼娇鐢ㄤ骇鍝�2鐨勫�间笉鑳介噸澶�';
errorMag += '=';
}
- if((inputvalues[12] != '' && inputvalues[12] != null)&& inputvalues[10] == inputvalues[12]){
+ if((inputvalues[11] != '' && inputvalues[11] != null)&& inputvalues[9] == inputvalues[11]){
errorMag += 'error1 绗�'+i+'琛屾暟鎹娇鐢ㄤ骇鍝�1鍜屼娇鐢ㄤ骇鍝�3鐨勫�间笉鑳介噸澶�';
errorMag += '=';
}
- if((inputvalues[11] != '' && inputvalues[11] != null) && (inputvalues[12] != '' && inputvalues[12] != null) && inputvalues[11] == inputvalues[12]){
+ if((inputvalues[10] != '' && inputvalues[10] != null) && (inputvalues[11] != '' && inputvalues[11] != null) && inputvalues[10] == inputvalues[11]){
errorMag += 'error1 绗�'+i+'琛屾暟鎹娇鐢ㄤ骇鍝�2鍜屼娇鐢ㄤ骇鍝�3鐨勫�间笉鑳介噸澶�';
errorMag += '=';
}
- if(inputvalues[13] == '' || inputvalues[13] == null){
+ if(inputvalues[12] == '' || inputvalues[12] == null){
errorMag += 'error1 绗�'+i+'琛屾暟鎹晥鏋�/杩涘害涓嶈兘涓虹┖';
errorMag += '=';
}
- if(inputvalues[14] == '' || inputvalues[14] == null){
+ if(inputvalues[13] == '' || inputvalues[13] == null){
errorMag += 'error1 绗�'+i+'琛屾暟鎹瀹ゅ悓绫昏�楁潗鏈堜娇鐢ㄩ噺涓嶈兘涓虹┖';
errorMag += '=';
}
- boolean wanked = wncc(inputvalues[14]);
- if(!wanked && inputvalues[14] == '' || inputvalues[14] == null){
+ boolean wanked = wncc(inputvalues[13]);
+ if(!wanked && inputvalues[13] == '' || inputvalues[13] == null){
errorMag += 'error3 绗�'+i+'琛屾暟鎹敊璇�,璇锋鏌ヤ綘鐨勭瀹ゅ悓绫昏�楁潗鏈堜娇鐢ㄩ噺!';
errorMag += '=';
}
+ //鏆傛椂娉ㄦ帀鍥犱负ENG鐨勬湳澹垎绫讳负绌烘墍浠ユ殏鏃舵敞鎺�
+ // if(inputvalues[14] == '' || inputvalues[14] == null){
+ // errorMag += 'error1 绗�'+i+'琛屾暟鎹叾浠栧搧鐗岃�楁潗浣跨敤涓嶈兘涓虹┖';
+ // errorMag += '=';
+ // }
if(inputvalues[15] == '' || inputvalues[15] == null){
- errorMag += 'error1 绗�'+i+'琛屾暟鎹叾浠栧搧鐗岃�楁潗浣跨敤涓嶈兘涓虹┖';
+ errorMag += 'error1 绗�'+i+'琛屾暟鎹凡閲囩敤鍏朵粬浜у搧涓嶈兘涓虹┖';
errorMag += '=';
}
- if(inputvalues[16] == '' || inputvalues[16] == null){
- errorMag += 'error1 绗�'+i+'琛屾暟鎹骇鍝佺被鍒笉鑳戒负绌�';
- errorMag += '=';
- }
+ //鏆傛椂娉ㄦ帀鍥犱负ET鐨勫叾浠栧搧鐗屼骇鍝佺被鍒病鏈夋暟鎹�
+ // if(inputvalues[16] == '' || inputvalues[16] == null){
+ // errorMag += 'error1 绗�'+i+'琛屾暟鎹湳澹娇鐢ㄤ骇鍝佸搴旀暟閲忎笉鑳戒负绌�';
+ // errorMag += '=';
+ // }
if(inputvalues[17] == '' || inputvalues[17] == null){
- errorMag += 'error1 绗�'+i+'琛屾暟鎹湳澹娇鐢ㄤ骇鍝佸搴旀暟閲忎笉鑳戒负绌�';
+ errorMag += 'error1 绗�'+i+'琛屾暟鎹湳浜у搧鐢ㄩ噺涓嶈兘涓虹┖';
errorMag += '=';
}
boolean wankeds = wncc(inputvalues[17]);
if(!wankeds && inputvalues[17] == '' || inputvalues[17] == null){
- errorMag += 'error3 绗�'+i+'琛屾暟鎹敊璇�,璇锋鏌ヤ綘鐨勬湳澹娇鐢ㄤ骇鍝佸搴旀暟閲�!';
+ errorMag += 'error3 绗�'+i+'琛屾暟鎹敊璇�,璇锋鏌ヤ綘鐨勪骇鍝佺敤閲�!';
errorMag += '=';
}
system.debug('inputvalues[1]====='+inputvalues[1]);
@@ -592,12 +617,13 @@
system.debug('inputvalues[9]====='+inputvalues[9]);
system.debug('inputvalues[10]====='+inputvalues[10]);
system.debug('inputvalues[11]====='+inputvalues[11]);
- system.debug('inputvalues[7]====='+inputvalues[12]);
- system.debug('inputvalues[8]====='+inputvalues[13]);
- system.debug('inputvalues[9]====='+inputvalues[14]);
- system.debug('inputvalues[10]====='+inputvalues[15]);
- system.debug('inputvalues[11]====='+inputvalues[16]);
- system.debug('inputvalues[11]====='+inputvalues[17]);
+ 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]);
+ system.debug('inputvalues[18]====='+inputvalues[18]);
//鎷呭綋
nameList.add(inputvalues[1]);
//鎶ュ憡鏃�
@@ -605,20 +631,24 @@
//缁忛攢鍟嗗尰闄�
ahlNameList.add(inputvalues[3]);
-
+ //浣跨敤浜у搧1
Product2NameList.add(inputvalues[9]);
+ //浣跨敤浜у搧2
Product2NameList.add(inputvalues[10]);
+ //浣跨敤浜у搧3
Product2NameList.add(inputvalues[11]);
- EffectProgressList.add(inputvalues[14]);
- OtherBrandConsumablesList.add(inputvalues[12]);
-
-
+ //鏁堟灉杩涘害
+ EffectProgressList.add(inputvalues[12]);
+ //鏈＋鍒嗙被
+ OtherBrandConsumablesList.add(inputvalues[14]);
+ //宸查噰鐢ㄥ叾浠栧搧鐗�
+ ProductCcategoryList.add(inputvalues[15]);
+ //鍏朵粬鍝佺墝浜у搧绫诲埆
+ productCategoriesList.add(inputvalues[16]);
//绉戝
// departmentSet.add('%'+GetDepartment_Cateogy(inputvalues[4])+'%'+'-'+GetEPurposeType(inputvalues[10]));
-
//瀵煎叆鐨勬暟鎹�
inputList.add(inputvalues);
-
}
}
// 鎷呭綋鍚嶇О鍖归厤鐨刴ap
@@ -636,12 +666,20 @@
Map<String,EffectProgress__c> EffectProgressMap = new Map<String,EffectProgress__c>();
// 鏈＋鍒嗙被
Map<String,WarlockClassification__c> OtherBrandConsumablesMap = new Map<String,WarlockClassification__c>();
+ // 宸查噰鐢ㄥ叾浠栦骇鍝�
+ Map<String,ProductCcategory__c> ProductCcategorynMap = new Map<String,ProductCcategory__c>();
+ // 鍏朵粬鍝佺墝浜у搧绫诲埆
+ Map<String,productCategories__c> productCategoriesMap = new Map<String,productCategories__c>();
// 浣跨敤浜у搧id鐨凩ist
List<String> UseProductIdList = new List<String>();
// 鏁堟灉杩涘害id鐨凩ist
List<String> EffectProgressIdList = new List<String>();
// 鏈＋鍒嗙被id鐨凩ist
List<String> OtherBrandConsumablesIdList = new List<String>();
+ // 宸查噰鐢ㄥ叾浠栧搧鐗宨d鐨凩ist
+ List<String> ProductCcategorynIdList = new List<String>();
+ // 鍏朵粬鍝佺墝浜у搧绫诲埆id鐨凩ist productCategoriesMap
+ List<String> productCategoriesIdList = new List<String>();
// 浜у搧鍖哄垎鐨刴ap
Map<String,String> protypeMap = new Map<String,String>();
// 鑾峰彇姣忓懆绗竴澶╃殑map
@@ -654,15 +692,14 @@
Map<String,String> DealerPersonnelMap = new Map<String,String>();
// 缁忛攢鍟嗚浠风殑map
Map<String,Agency_Opportunity__c> aoMap = new Map<String,Agency_Opportunity__c>();
- // 绉戝鍜屼骇鍝佸尯鍒嗗叧绯籱ap
- // Map<String,List<Map<String,String>>> impProMap = new Map<String,List<Map<String,String>>>();
- // impProMap = getImplProductList(departmentSet);
List<Contact> conList = LightningUtil.selectAgencyPerson01();
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 = [select id,name,Hospital__c,MaxActivityDate__c from Agency_Hospital_Link__c where name = :ahlNameList and Agency_Campaign_Obj__c = true];
- List<Product2> pr2List = [select id,name from Product2 where name = :Product2NameList];
- List<EffectProgress__c> epList = [select id,name from EffectProgress__c where name = :EffectProgressList];
- List<WarlockClassification__c> ocList = [select id,name from WarlockClassification__c where name = :OtherBrandConsumablesList];
+ List<Product2> pr2List = [select id,name from Product2 where name in:Product2NameList];
+ List<EffectProgress__c> epList = [select id,name from EffectProgress__c where name in :EffectProgressList];
+ List<WarlockClassification__c> ocList = [select id,name from WarlockClassification__c where name in :OtherBrandConsumablesList];
+ List<ProductCcategory__c> PCList = [select id,name from ProductCcategory__c where name in :ProductCcategoryList];
+ List<productCategories__c> PctList = [select id,name from productCategories__c where name in :productCategoriesList];
for(OlympusCalendar__c olym : olympusDateList){
if(olym.DayOfTheWeek__c == 'Sun'){
@@ -694,16 +731,24 @@
EffectProgressMap.put(ep.Name, ep);
EffectProgressIdList.add(ep.Id);
}
- for(WarlockClassification__c oc : ocList){
+ for(WarlockClassification__c oc : ocList){
OtherBrandConsumablesMap.put(oc.Name, oc);
OtherBrandConsumablesIdList.add(oc.Id);
+ }
+ for(ProductCcategory__c pc : PCList){
+ ProductCcategorynMap.put(pc.Name, pc);
+ ProductCcategorynIdList.add(pc.Id);
+ }
+ for(productCategories__c pct : PctList){
+ productCategoriesMap.put(pct.Name, 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];
for(Agency_Contact__c ac : doctor2list){
doctor2Map.put(ac.Name.replace(' ',''), ac.Id);
}
//缁忛攢鍟嗕汉鍛� DealerPersonnel
- List<contact> conListLighrningUtil = LightningUtil.selectAgencyPerson();
+ List<contact> conListLighrningUtil = LightningUtil.selectAgencyPerson02();
for(contact de : conListLighrningUtil){
DealerPersonnelMap.put(de.Name.replace(' ',''), de.Id);
}
@@ -762,37 +807,34 @@
}
Agency_Report__c agencyReport = new Agency_Report__c();
if(week == null && lineList[2] != '' && lineList[2] != null){
- // return 'error2 绗�'+hang+'琛屾暟鎹姤鍛婃棩'+lineList[1]+'濉啓鏈夎';
errorMag += 'error2 绗�'+hang+'琛屾暟鎹姤鍛婃棩'+lineList[2]+'濉啓鏈夎';
errorMag += '=';
}
- agencyReport.Submit_date__c = week; // 鎻愬嚭鍛�
+ agencyReport.Submit_date__c = week;
if((s_agency == null || s_agency == '')&& lineList[1] != '' && lineList[1] != null){
errorMag += 'error2 绗�'+hang+'琛屾暟鎹媴褰�'+lineList[1]+'涓嶅瓨鍦�';
errorMag += '=';
}
- agencyReport.Person_In_Charge2__c = s_agency; // 鎷呭綋
+ agencyReport.Person_In_Charge2__c = s_agency;
if(lineList[2] != null && lineList[2] != ''){
- agencyReport.Report_Date__c = Date.valueOf(lineList[2].replace('/','-')); // 娲诲姩鏃�
+ agencyReport.Report_Date__c = Date.valueOf(lineList[2].replace('/','-'));
}
if(ahlMap.containsKey(lineList[3])){
- agencyReport.Agency_Hospital__c = ahlMap.get(lineList[3]).Id; //缁忛攢鍟嗗尰闄� UseProduct1__c
- // 鏇存柊缁忛攢鍟嗗尰闄㈢殑鏈�鏂板懆
+ agencyReport.Agency_Hospital__c = ahlMap.get(lineList[3]).Id;
ahlMap.get(lineList[3]).MaxActivityDate__c = week;
}else{
if(lineList[3] != '' && lineList[3] != null){
- // return 'error2 绗�'+hang+'琛屾暟鎹粡閿�鍟嗗尰闄�'+lineList[2]+'涓嶅瓨鍦�';
errorMag += 'error2 绗�'+hang+'琛屾暟鎹粡閿�鍟嗗尰闄�'+lineList[3]+'涓嶅瓨鍦�';
errorMag += '=';
}
}
String departmentE = GetDepartment_Cateogy(lineList[4]);
if(departmentE != 'no'){
- agencyReport.Department_Cateogy__c = departmentE; // 绉戝
+ agencyReport.Department_Cateogy__c = departmentE;
}else{
}
if(DealerPersonnelMap.containsKey(lineList[5].replace(' ',''))){
- agencyReport.DealerPersonnel__c = DealerPersonnelMap.get(lineList[5].replace(' ','')); // 缁忛攢鍟嗕汉鍛� DealerPersonnelMap
+ agencyReport.DealerPersonnel__c = DealerPersonnelMap.get(lineList[5].replace(' ',''));
}else{
if(lineList[5] != '' && lineList[5] != null){
errorMag += 'error2 绗�'+hang+'琛屾暟鎹粡閿�鍟嗕汉鍛�'+lineList[5]+'涓嶅瓨鍦�';
@@ -800,10 +842,10 @@
}
}
if(GetPurposeType(lineList[6])){
- agencyReport.WorkRecord__c = lineList[6]; // 娲诲姩鍖哄垎
+ agencyReport.WorkRecord__c = lineList[6];
}
if(doctor2Map.containsKey(lineList[7].replace(' ',''))){
- agencyReport.doctor2__c = doctor2Map.get(lineList[7].replace(' ','')); // 鎷滆浜�
+ agencyReport.doctor2__c = doctor2Map.get(lineList[7].replace(' ',''));
}else{
if(lineList[7] != '' && lineList[7] != null){
errorMag += 'error2 绗�'+hang+'琛屾暟鎹鎴蜂汉鍛�'+lineList[7]+'涓嶅瓨鍦�';
@@ -811,10 +853,10 @@
}
}
if(GetProductClassification(lineList[8])){
- agencyReport.ProductClassification__c = lineList[8]; // 浜у搧鍒嗙被
+ agencyReport.ProductClassification__c = lineList[8];
}
if(UseProductMap.containsKey(lineList[9])){
- agencyReport.UseProduct1__c = UseProductMap.get(lineList[9]).Id; //浣跨敤浜у搧1
+ agencyReport.UseProduct1__c = UseProductMap.get(lineList[9]).Id;
}else{
if(lineList[9] != '' && lineList[9] != null){
errorMag += 'error2 绗�'+hang+'琛屾暟鎹娇鐢ㄤ骇鍝�1'+lineList[9]+'涓嶅瓨鍦�';
@@ -822,7 +864,7 @@
}
}
if(UseProductMap.containsKey(lineList[10])){
- agencyReport.UseProduct2__c = UseProductMap.get(lineList[10]).Id; //浣跨敤浜у搧2 EffectProgressMap OtherBrandConsumablesMap
+ agencyReport.UseProduct2__c = UseProductMap.get(lineList[10]).Id;
}else{
if(lineList[10] != '' && lineList[10] != null){
errorMag += 'error2 绗�'+hang+'琛屾暟鎹娇鐢ㄤ骇鍝�2'+lineList[10]+'涓嶅瓨鍦�';
@@ -830,7 +872,7 @@
}
}
if(UseProductMap.containsKey(lineList[11])){
- agencyReport.UseProduct3__c = UseProductMap.get(lineList[11]).Id; //浣跨敤浜у搧3
+ agencyReport.UseProduct3__c = UseProductMap.get(lineList[11]).Id;
}else{
if(lineList[11] != '' && lineList[11] != null){
errorMag += 'error2 绗�'+hang+'琛屾暟鎹娇鐢ㄤ骇鍝�3'+lineList[11]+'涓嶅瓨鍦�';
@@ -838,41 +880,42 @@
}
}
if(EffectProgressMap.containsKey(lineList[12])){
- agencyReport.EffectProgress__c = EffectProgressMap.get(lineList[12]).Id; // 鏁堟灉/杩涘害
+ agencyReport.EffectProgress__c = EffectProgressMap.get(lineList[12]).Id;
}
if(lineList[13] != null){
- agencyReport.ConsumptionOfConsumables__c = Decimal.valueOf(lineList[13]); // 绉戝鍚岀被鑰楁潗鏈堜娇鐢ㄩ噺
+ agencyReport.ConsumptionOfConsumables__c = Decimal.valueOf(lineList[13]);
}
if(OtherBrandConsumablesMap.containsKey(lineList[14])){
- agencyReport.EffectProgress__c = OtherBrandConsumablesMap.get(lineList[14]).Id; // 鏈＋鍒嗙被
+ agencyReport.OtherBrandConsumables__c = OtherBrandConsumablesMap.get(lineList[14]).Id;
}
- // agencyReport.OtherBrandConsumables__c = lineList[14]; // 鏈＋鍒嗙被
- if(GetProductCcategory(lineList[15])){
- agencyReport.ProductCcategory__c = lineList[15]; // 浜у搧绫诲埆
+ if(ProductCcategorynMap.containsKey(lineList[15])){
+ agencyReport.ProductCcategory__c = ProductCcategorynMap.get(lineList[15]).Id;
}
- if(lineList[16] != null){
- agencyReport.warlocksNumber__c = Decimal.valueOf(lineList[16]); // 鏈＋浣跨敤浜у搧瀵瑰簲鏁伴噺 warlocksNumber__c EffectProgress__c
+ if(productCategoriesMap.containsKey(lineList[16])){
+ agencyReport.productCategories__c = productCategoriesMap.get(lineList[16]).Id;
}
- if(lineList[17] == 'true'){
- agencyReport.WorkMark__c = true; //宸ヤ綔鏍囪
+ if(lineList[17] != null){
+ agencyReport.warlocksNumber__c = Decimal.valueOf(lineList[17]);
+ }
+ if(lineList[18] == 'true'){
+ agencyReport.WorkMark__c = true;
}else{
agencyReport.WorkMark__c = false;
}
String headerStr = createHeader(week,s_agency);
if(agency_report_headerMap.containsKey(headerStr)){
- agencyReport.Agency_Report_Header__c = agency_report_headerMap.get(headerStr).Id; // 鍛ㄦ姤涓�瑙�
+ 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();
}
// 鏂板鍛ㄦ姤鏄庣粏
@@ -882,8 +925,8 @@
}
return 'success';
}catch(Exception e){
- System.debug('exception'+e);
- return 'exception'+e;
+ System.debug('exception'+e);
+ return 'exception'+e;
}
}
@@ -935,41 +978,6 @@
}
return false;
}
- // 鍒ゆ柇浜у搧绫诲埆鏄惁瀛樺湪
- public static boolean GetProductCcategory(String purposeType){
- Schema.DescribeFieldResult fieldResult = Agency_Report__c.ProductCcategory__c.getDescribe();
- List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues();
- for( Schema.PicklistEntry pickListVal : ple){
- if(pickListVal.getValue() == purposeType){
- return true;
- }
- }
- return false;
- }
-
- // 鍒ゆ柇鍏朵粬鍝佺墝鑰楁潗浣跨敤鏄惁瀛樺湪 OtherBrandConsumables__c
- // public static boolean GetOtherBrandConsumables(String purposeType){
- // Schema.DescribeFieldResult fieldResult = Agency_Report__c.OtherBrandConsumables__c.getDescribe();
- // List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues();
- // for( Schema.PicklistEntry pickListVal : ple){
- // if(pickListVal.getValue() == purposeType){
- // return true;
- // }
- // }
- // return false;
- // }
-
- // 鍒ゆ柇鏁堟灉/杩涘害鏄惁瀛樺湪 EffectProgress__c GetProductClassification
- // public static boolean GetEffectProgress(String purposeType){
- // Schema.DescribeFieldResult fieldResult = Agency_Report__c.EffectProgress__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();
@@ -1048,6 +1056,8 @@
@RemoteAction
@AuraEnabled
public static List<Map<String,String>> selectPurposeTypes(String doctor_value){
+ system.debug('doctor_value===============>'+doctor_value);
+
List<EffectProgress__c> eftpcList;
if(String.isNotBlank(doctor_value)){
eftpcList = [select id, Name , WorkRecord__c from EffectProgress__c where WorkRecord__c =: doctor_value];
@@ -1063,13 +1073,13 @@
efptcMap.put('value', efptc.Id);
options.add(efptcMap);
}
+ system.debug('options===============>'+options);
return options;
}
@RemoteAction
@AuraEnabled
public static List<Map<String,String>> selectProductClassificationc(String select_ProductClassification){
List<WarlockClassification__c> WarlockClassificationList;
- system.debug('select_ProductClassification==============='+select_ProductClassification);
if(String.isNotBlank(select_ProductClassification)){
WarlockClassificationList = [select id, Name , ProductClassification__c from WarlockClassification__c where ProductClassification__c =: select_ProductClassification];
}
@@ -1084,7 +1094,54 @@
WarlockClassificationMap.put('value', WarlockClassification.Id);
options.add(WarlockClassificationMap);
}
- system.debug('options==============='+options);
+ return options;
+ }
+ @RemoteAction
+ @AuraEnabled
+ public static List<Map<String,String>> selectProductCcategory(){
+ List<ProductCcategory__c> ProductCcategoryList;
+ User UserProETENG = LightningUtil.loginUserId();
+ if(UserProETENG.UserPro_Type__c == 'ET'){
+ ProductCcategoryList = [select id, Name , ConsumablesClassification__c from ProductCcategory__c where ConsumablesClassification__c =: 'ET'];
+ }else{
+ ProductCcategoryList = [select id, Name , ConsumablesClassification__c from ProductCcategory__c where ConsumablesClassification__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(ProductCcategory__c ProductCcategory : ProductCcategoryList){
+ Map<String,String> ProductCcategorynMap = new Map<String,String>();
+ ProductCcategorynMap.put('label', ProductCcategory.Name);
+ ProductCcategorynMap.put('value', ProductCcategory.Id);
+ options.add(ProductCcategorynMap);
+ }
+ return options;
+ }
+ @RemoteAction
+ @AuraEnabled
+ public static List<Map<String,String>> selectProductCcategory01(String select_ProductCcategory){
+ List<productCategories__c> productCategoriesList;
+ User UserProETENG = LightningUtil.loginUserId();
+ System.debug('UserProETENG.UserPro_Type__c=============>'+UserProETENG.UserPro_Type__c);
+ if(UserProETENG.UserPro_Type__c == 'ET'){
+ productCategoriesList = [select id, Name,ET_ENG_classification__c,ProductCcategory__c from productCategories__c where ProductCcategory__c =:select_ProductCcategory AND ET_ENG_classification__c =: 'ET'];
+ }else{
+ productCategoriesList = [select id, Name,ET_ENG_classification__c,ProductCcategory__c from productCategories__c where ProductCcategory__c =:select_ProductCcategory 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(productCategories__c productCategories : productCategoriesList){
+ Map<String,String> productCategoriesMap = new Map<String,String>();
+ productCategoriesMap.put('label', productCategories.Name);
+ productCategoriesMap.put('value', productCategories.Id);
+ options.add(productCategoriesMap);
+ }
+ System.debug('options=============>'+options);
return options;
}
}
\ No newline at end of file
--
Gitblit v1.9.1