blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
翟兴坤
2022-03-11 51e7078a45673692683962eaf1d9f924a0bb8b36 
 force-app/main/default/classes/RetrospectiveWeeklyReportController.cls


@@ -24,6 +24,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>>();


@@ -34,7 +35,7 @@


        tmp.add(space);


        


        // 代理店担当者 AgencyPerson__c


        List<Contact> agency_person_data = LightningUtil.selectAgencyPerson01();


        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);


@@ -43,6 +44,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 +53,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);


@@ -81,10 +84,13 @@


        this.allselectlist.put('StageName__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Opportunity__c','StageName__c'));




        //其他品牌耗材


        this.allselectlist.put('OtherBrandConsumables__c', RetrospectiveWeeklyReportController.getPicklistValues('Agency_Report__c','OtherBrandConsumables__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'));


@@ -205,10 +211,10 @@


    @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);


@@ -228,11 +234,21 @@


    @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 Hospital_Name_readonly__c like :hospital_name and AgencyHos_ENG__c = true];


            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 Hospital_Name_readonly__c like :hospital_name and AgencyHos_ET__c = true];


            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];


        }


        


    }


@@ -252,13 +268,11 @@


    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');


        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];


@@ -277,24 +291,24 @@


    @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 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 = makeAgencyReport(Department_Cateogy,ConsumptionOfConsumables,


        WorkMark,warlocksNumber,DealerPersonnel,ProductCcategory,OtherBrandConsumables,ProductClassification, WorkRecord,


        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 = LightningUtil.insertAgencyReport(agency_report);


        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 OtherBrandConsumables,


    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,


@@ -318,7 +332,6 @@


        }


        //经销商人员


        if (DealerPersonnel != '') {


           


            if(DealerPersonnel.contains(';')){


                DealerPersonnel = DealerPersonnel.split(';')[0];


            }


@@ -334,6 +347,7 @@


        if (Department_Cateogy != '') { agency_report.Department_Cateogy__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; }


@@ -342,20 +356,40 @@


        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 (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)) {


            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;


        }


        if (String.isBlank(data.Department_Class__c)) {


            String record_type_id = LightningUtil.getRecordTypeId(data.Department_Cateogy__c);


            List<Account> account = [select Id, RecordTypeId from account where Hospital_Department_Class__c=:data.Hospital__c and RecordTypeId=:record_type_id];


            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 OtherBrandConsumables,String ProductCcategory,String ProductClassification,


                                        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, 


@@ -364,8 +398,8 @@


        if (String.isBlank(Agency_Report_Id)) {


            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,


        Agency_Report__c agency_report = [select Id, Name, Department_Cateogy__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,Submit_date__c,Report_Date__c


                                            from Agency_Report__c where id=:Agency_Report_Id];


        Date week = Date.valueOf(Submit_date);


@@ -401,9 +435,10 @@


        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 (OtherBrandConsumables != '') { agency_report.OtherBrandConsumables__c = OtherBrandConsumables; } else { agency_report.OtherBrandConsumables__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; }


        agency_report = LightningUtil.updateAgencyReport(agency_report);


@@ -430,18 +465,17 @@


    }


    


    public void get_reports(String date_str, String person_str) {     


        // 週報データを取得


        Date week = Date.valueOf(date_str);


        this.reports = LightningUtil.selectAgencyReport01(week, person_str);


        system.debug('this.reports==========>'+this.reports);


       


    }


    


    @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.selectAgencyReportById(report_id);


        ret = LightningUtil.selectAgencyReportById01(report_id);


        system.debug('==Agency_Report_Header__r.WeeklyReportClassification__c=================>'+ret);


        return ret;


    }


    


@@ -452,10 +486,8 @@


        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);


        List<Contact> conMList = LightningUtil.selectAgencyPerson03();


        return LightningUtil.selectMAgencyReport01(date1_date, date2_date, conMList);


    }




    public List<contact> selectMAgencyPerson() {


@@ -466,6 +498,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 +519,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>();


                // 经销商询价名称list


@@ -532,53 +569,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 +639,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 +653,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);




                    }


                }


                // 担当名称匹配的map


@@ -633,15 +685,23 @@


                // 使用产品1，2，3


                Map<String,Product2> UseProductMap = new Map<String,Product2>();


                // 效果进度


                Map<String,EffectProgress__c> EffectProgressMap = new Map<String,EffectProgress__c>();


                Map<String,FieldClassification__c> EffectProgressMap = new Map<String,FieldClassification__c>();


                // 术士分类


                Map<String,WarlockClassification__c> OtherBrandConsumablesMap = new Map<String,WarlockClassification__c>();


                Map<String,FieldClassification__c> OtherBrandConsumablesMap = new Map<String,FieldClassification__c>();


                // 已采用其他产品


                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


@@ -654,15 +714,14 @@


                Map<String,String> DealerPersonnelMap = new Map<String,String>();


                // 经销商询价的map


                Map<String,Agency_Opportunity__c> aoMap = new Map<String,Agency_Opportunity__c>();


                // 科室和产品区分关系map


                // Map<String,List<Map<String,String>>> impProMap = new  Map<String,List<Map<String,String>>>();


                // impProMap = getImplProductList(departmentSet);


                List<Contact> conList = LightningUtil.selectAgencyPerson01();      


                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 = [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<FieldClassification__c> FieldClassification1List = [select id,EffectProgress__c from FieldClassification__c where EffectProgress__c  in :EffectProgressList]; 


                List<FieldClassification__c> FieldClassification2List = [select id,WarlockClassification__c from FieldClassification__c where WarlockClassification__c in :OtherBrandConsumablesList];


                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'){


@@ -690,20 +749,28 @@


                    UseProductMap.put(pr2.Name, pr2);


                    UseProductIdList.add(pr2.Id);


                }


                for(EffectProgress__c ep : epList){


                    EffectProgressMap.put(ep.Name, ep);


                for(FieldClassification__c ep : FieldClassification1List){


                    EffectProgressMap.put(ep.EffectProgress__c, ep);


                    EffectProgressIdList.add(ep.Id);


                }


                for(WarlockClassification__c oc : ocList){


                    OtherBrandConsumablesMap.put(oc.Name, oc);


                for(FieldClassification__c oc : FieldClassification2List){ 


                    OtherBrandConsumablesMap.put(oc.WarlockClassification__c, oc);


                    OtherBrandConsumablesIdList.add(oc.Id);


                }


                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];


                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);


                }


@@ -746,6 +813,8 @@


            }


                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;


@@ -762,37 +831,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 +866,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 +877,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 +888,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 +896,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,52 +904,55 @@


                        }


                    }


                    if(EffectProgressMap.containsKey(lineList[12])){


                        agencyReport.EffectProgress__c = EffectProgressMap.get(lineList[12]).Id; // 效果/进度       


                        agencyReport.EffectProgress__c = EffectProgressMap.get(lineList[12]).EffectProgress__c;    


                    }


                    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.WarlockClassification__c = OtherBrandConsumablesMap.get(lineList[14]).WarlockClassification__c;     


                    }


                        // 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]).ProductCcategory__c;      


                    }


                    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]).productCategories__c;   


                    }


                    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; 


                    }


                    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; // 周报一览


                        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 'exception'+e;   


                System.debug('exception'+e);


                return 'exception'+e;   


        }


    }




@@ -935,41 +1004,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,43 +1082,96 @@


    @RemoteAction


    @AuraEnabled


    public static List<Map<String,String>> selectPurposeTypes(String doctor_value){


        List<EffectProgress__c> eftpcList;


        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, 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(EffectProgress__c efptc : eftpcList){


        for(FieldClassification__c efptc : eftpcList){


            Map<String,String> efptcMap = new Map<String,String>();


            efptcMap.put('label', efptc.Name);


            efptcMap.put('value', efptc.Id);


            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){


        List<WarlockClassification__c> WarlockClassificationList;


        system.debug('select_ProductClassification==============='+select_ProductClassification);


        List<FieldClassification__c> WarlockClassificationList;


        if(String.isNotBlank(select_ProductClassification)){


            WarlockClassificationList = [select id, Name , ProductClassification__c from WarlockClassification__c where ProductClassification__c =: select_ProductClassification];


            // WarlockClassificationList = [select id, Name , ProductClassification__c from WarlockClassification__c where ProductClassification__c =: select_ProductClassification];


            WarlockClassificationList = [select id , ProductClassification__c,WarlockClassification__c from FieldClassification__c where ProductClassification__c =: select_ProductClassification];




        }


        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(WarlockClassification__c WarlockClassification : WarlockClassificationList){


        for(FieldClassification__c WarlockClassification : WarlockClassificationList){


            Map<String,String> WarlockClassificationMap = new Map<String,String>();


            WarlockClassificationMap.put('label', WarlockClassification.Name);


            WarlockClassificationMap.put('value', WarlockClassification.Id);


            WarlockClassificationMap.put('label', WarlockClassification.WarlockClassification__c);


            WarlockClassificationMap.put('value', WarlockClassification.WarlockClassification__c);


            options.add(WarlockClassificationMap);


        }


        system.debug('options==============='+options);


        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);


        FieldClassification__c fi = [Select ProductCcategory__c from FieldClassification__c where ID =: select_ProductCcategory];


        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;


    }


}