test

binxie

2023-06-19 41625c74ad92b72151f4d1009ea0c791635d9dac

 force-app/main/default/aura/WeeklyReport/WeeklyReportHelper.js

@@ -63,7 +63,7 @@
                        component.set('v.login',false);
                    }
                }else{
                    this.error('AWS search status : ' + result.status);
                    this.error('AWS search status1 : ' + result.status);
                    component.set('v.login',false);
                }
            },component);
@@ -221,7 +221,8 @@
                            b = true;
                            Foo();
                        }else{
                            this.error('AWS search status : ' + result.status);
                            //this.error('AWS search status2 : ' + result.status);
                            this.success('请重新刷新页面进行解密');
                        }
                    },component);
                }else{
@@ -243,7 +244,7 @@
                            b1 = true;
                            Foo();
                        }else{
                            this.error('AWS search status : ' + result.status);
                            this.error('AWS search status3 : ' + result.status);
                        }
                    },component);
                }else{
@@ -345,7 +346,7 @@
                var reports = component.get('v.reports');
                var Agency_Hospital_text = '';
                var Agency_Hospital_parent_id = '';

                debugger
            // 医院名
                if (select_data['Agency_Hospital__c'] != '') {
                    for (var i = 0; i < reports.length; i++) {
@@ -373,7 +374,12 @@
                    this.set_selected(component, 'select_purpose_type', select_data['Purpose_Type__c']);
                    this.select_purpose_type(component);
                }
                                
                //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start
                // 支援需求
                if (select_data['SupportNeeds__c'] != '') {
                    this.set_selected(component, 'SupportNeeds__c', select_data['SupportNeeds__c']);
                }  
                //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 end             
                // 結果
                if (select_data['Result__c'] != '' && typeof select_data['Result__c'] !== "undefined") {
                    component.find('select_result').set('v.value', select_data['Result__c']);
@@ -431,8 +437,9 @@
                    if (select_product_category3 != null && select_product_category3 != '') {
                        component.find('select_Product3').set('v.value', select_product_category3);
                    }

                    console.log('reportDate = ' + reportDate);
                    if (reportDate != null) {
                        console.log('reportDate = ' + reportDate);
                        component.set('v.data.Report_Date__c', reportDate);
                    }
                    
@@ -441,13 +448,14 @@
            }
        } else {
            // CLOSE

            console.log('reportDate = ' + reportDate);
            var select_report_data = component.get('v.select_report_data');
            var Report_Date__c = component.get('v.data.Report_Date__c');
            var Agency_Hospital__c = component.get('v.hospitalLinkId');
            var Department_Cateogy__c = component.find('select_department').get('v.value');
            var doctor2__c = component.find('select_doctor').get('v.value');
            var Purpose_Type__c = component.find('select_purpose_type').get('v.value');
            var SupportNeeds__c = component.find('SupportNeeds__c').get('v.value');
            var Opportunity__c = component.get('v.data.Opportunity__c');
            var Product_Category1__c = component.find('select_Product1').get('v.value');
            var Product_Category2__c = component.find('select_Product2').get('v.value');
@@ -481,6 +489,7 @@
                    !Department_Cateogy__c &&
                    !doctor2__c &&
                    !Purpose_Type__c &&
                    !SupportNeeds__c&&//WAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加
                    !Opportunity__c &&
                    !Product_Category1__c &&
                    !Product_Category2__c &&
@@ -502,6 +511,7 @@
                    select_report_data['Department_Cateogy__c'] == Department_Cateogy__c &&
                    select_report_data['doctor2__c'] == doctor2__c &&
                    select_report_data['Purpose_Type__c'] == Purpose_Type__c &&
                    select_report_data['SupportNeeds__c'] == SupportNeeds__c &&//WAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加
                    select_report_data['Opportunity__c'] == Opportunity__c &&
                    select_report_data['Product_Category1__c'] == Product_Category1__c &&
                    select_report_data['Product_Category2__c'] == Product_Category2__c &&
@@ -523,6 +533,7 @@
                    select_report_data['Department_Cateogy__c'] == Department_Cateogy__c &&
                    select_report_data['doctor2__c'] == doctor2__c &&
                    select_report_data['Purpose_Type__c'] == Purpose_Type__c &&
                    select_report_data['SupportNeeds__c'] == SupportNeeds__c &&//WAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加
                    select_report_data['Opportunity__c'] == Opportunity__c &&
                    select_report_data['Product_Category1__c'] == Product_Category1__c &&
                    select_report_data['Product_Category2__c'] == Product_Category2__c &&
@@ -945,11 +956,15 @@
        component.set('v.doctor_title', '');
        component.find('select_department').set('v.options', this.conv_selected(component.get('v.allselectlist.Department_Cateogy__c')));
        component.find('select_purpose_type').set('v.options', this.conv_selected(component.get('v.allselectlist.Purpose_Type__c')));
        //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start
        component.find('SupportNeeds__c').set('v.options', this.conv_selected(component.get('v.allselectlist.SupportNeeds__c')));
        //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 end
        // ToDo需要测试手机上能运行不
        component.set('v.data.Opportunity__c', '');
        component.find('select_Product1').set('v.value','');
        component.find('select_Product2').set('v.value','');
        component.find('select_Product3').set('v.value','');
        console.log('reportDate = 空');
        component.set('v.data.Report_Date__c', '');
        component.set('v.oppdata.Close_Forecasted_Date__c', '');
        component.set('v.oppdata.Amount__c', '');
@@ -1159,7 +1174,6 @@
                component.set('v.hospitalLinkId', hospital_data[i].Id);
                component.set('v.data.Agency_Hospital__c', hospital_data[i].Id);
                component.find('new_con').set('v.disabled', false);
                //break;
            }
        }
        component.set("v.hospital", accname);
@@ -1219,21 +1233,21 @@
        $A.enqueueAction(action);
    },

    insert_agencycontact : function(component,token,newUrl,payload,agencyHospitalid,helper) {
    insert_agencycontact : function(component,token,newUrl,payload,agencyHospitalid,helper,hospitalName) {

        AWSService.insert(newUrl,payload,function(result){
            if(result.status == '0'){
                $A.getCallback(function(){
                    helper.to_agencycontact(component,result,agencyHospitalid);
                })();
        // AWSService.insert(newUrl,payload,function(result){
        //     if(result.status == '0'){
        //         $A.getCallback(function(){
        //             helper.to_agencycontact(component,result,agencyHospitalid);
        //         })();

            }else{
                console.log('AWS status error:' + result)
                component.set('v.login',false);
                component.find('OppMessage').setError('AWS insert error.');
            }
        },token);
        /*
        //     }else{
        //         console.log('AWS status error:' + result)
        //         component.set('v.login',false);
        //         component.find('OppMessage').setError('AWS insert error.');
        //     }
        // },token);
        
        fetch(newUrl, {
            method: 'POST',
            body: payload,
@@ -1248,17 +1262,20 @@
                $A.getCallback(function(){
                    helper.to_agencycontact(component,result,agencyHospitalid);
                })();

            }else{
                console.log('AWS status error:' + result)
                component.set('v.login',false);
                component.find('OppMessage').setError('AWS insert error.');
                if(result.status == '129'){
                    component.find('OppMessage').setError('该客户人员名字已存在，在'+hospitalName+'医院，请修改');
                }else{
                    component.find('OppMessage').setError('AWS insert error.');
                }
            }
        }).catch(error => {
            console.log('AWS insert error:' + error)
            component.set('v.login',false);
            component.find('OppMessage').setError('AWS insert error.');
        });*/
        });
        
    },

@@ -1266,11 +1283,11 @@
        var action = component.get('c.saveAgencyContact');
        action.setParams({
            "name" : result.object[0].name,
            "nameEncrypt" : result.object[0].nameEncrypt,
            //"nameEncrypt" : result.object[0].nameEncrypt,
            "type" : result.object[0].type,
            "typeEncrypt" : result.object[0].typeEncrypt,
            //"typeEncrypt" : result.object[0].typeEncrypt,
            "doctorDivision1" : result.object[0].doctorDivision1,
            "doctorDivision1Encrypt" : result.object[0].doctorDivision1Encrypt,
            //"doctorDivision1Encrypt" : result.object[0].doctorDivision1Encrypt,
            "agencyHospitalid" : agencyHospitalid,
            "awsid" : result.object[0].dataId,
        });
@@ -1411,7 +1428,7 @@
            if(result.status == '0'){
                this.to_doctor_list(result,retMap,component);
            }else{
                this.error('AWS search status : ' + result.status);
                this.error('AWS search status4 : ' + result.status);
                component.set('v.login',false);
            }
        },component);
@@ -1432,6 +1449,9 @@
        // });
    },
    search_core : function(token,searchUrl,payload,callback,component) {
        console.log('token = ' + token);
        console.log('searchUrl = ' + searchUrl);
        console.log('payload = ' + payload);
        fetch(searchUrl, {
            method: 'POST',
            body: payload,
@@ -1445,6 +1465,7 @@
            component.set('v.login',false);
            if(callback)callback(result);
        }).catch(error => {
            console.log('error = ' + JSON.stringify(error));
            this.error('AWS search error.');
            component.set('v.login',false);
        });
@@ -1508,6 +1529,7 @@
    // },
    
    opportunityChange : function(component, event, helper) {
        debugger
        var opp_id = component.get('v.data.Opportunity__c');
        if (opp_id == '') {
            $A.util.addClass(component.find('input-opportunity-stage'), 'disp_none');
@@ -1571,24 +1593,28 @@
                        // }
                        component.set('v.login',false);
                        return false;
                    } else if (res[0]['StageName2__c'] != '3.询价' && !component.get('v.loadOpp')){
                        this.warning('请选择询价中的项目');
                        // ToDo需要测试手机上能运行不
                        component.set('v.data.Opportunity__c', '');
                        $A.util.addClass(component.find('input-opportunity-stage'), 'disp_none');
                        $A.util.addClass(component.find('input-opportunity-amount1'), 'disp_none');
                        $A.util.addClass(component.find('input-opportunity-amount2'), 'disp_none');
                        $A.util.addClass(component.find('input-opportunity-date'), 'disp_none');
                        $A.util.removeClass(component.find('input-opportunity-blank'), 'disp_none');
                        // if ($A.get("$Browser.formFactor") == 'DESKTOP') {
                        //     var values = [];
                        //     component.find('input-opportunity').get("v.body")[0].set('v.values', values);
                        // } else {
                        //     component.find('input-opportunity').get("v.body")[0].set('v.selectedLabel', '');            
                        // }
                        component.set('v.login',false);
                        return false;
                    } else {
                    }
                    //SWAG-CKH5M8  【委托】周报关联询价，可选择询价范围调整 fy start
                    //  else if (res[0]['StageName2__c'] != '3.询价' && !component.get('v.loadOpp')){
                    //     this.warning('请选择询价中的项目');
                    //     // ToDo需要测试手机上能运行不
                    //     component.set('v.data.Opportunity__c', '');
                    //     $A.util.addClass(component.find('input-opportunity-stage'), 'disp_none');
                    //     $A.util.addClass(component.find('input-opportunity-amount1'), 'disp_none');
                    //     $A.util.addClass(component.find('input-opportunity-amount2'), 'disp_none');
                    //     $A.util.addClass(component.find('input-opportunity-date'), 'disp_none');
                    //     $A.util.removeClass(component.find('input-opportunity-blank'), 'disp_none');
                    //     // if ($A.get("$Browser.formFactor") == 'DESKTOP') {
                    //     //     var values = [];
                    //     //     component.find('input-opportunity').get("v.body")[0].set('v.values', values);
                    //     // } else {
                    //     //     component.find('input-opportunity').get("v.body")[0].set('v.selectedLabel', '');            
                    //     // }
                    //     component.set('v.login',false);
                    //     return false;
                    // }
                    //SWAG-CKH5M8  【委托】周报关联询价，可选择询价范围调整 fy end
                     else {
                        component.set('v.loadOpp', false);
                        component.set('v.oppdata',res[0]);
                        this.set_selected(component, 'select_stageName', res[0].StageName__c);
@@ -1773,6 +1799,7 @@
        $A.util.addClass(modal_newAC, 'disp_none');
    },
    setOpportunity_cfilter : function(component) {
        debugger
        var hosId = component.get('v.hospitalId');
        var Department_Cateogy__c = component.find('select_department').get('v.value');
        var opportunity_cfilter = '';
@@ -1877,66 +1904,346 @@
        reader.readAsDataURL(file);
    },
    
    saveRecords : function(component,event){
    saveRecords : function(component,event,helper){
        debugger
        component.set('v.login',true);
        var action = component.get("c.processData");
        var selectDate = component.find('select_date').get('v.value');
        var fieldsList=['Name','Phone','AccountNumber']; //Please write your code dynamic 
        var sss=component.get("v.fileContentData");
        action.setParams({ 
        //fy 导入 20220424 start
        var action1 = component.get("c.processDataAWSId");
        action1.setParams({ 
            fileData : component.get("v.fileContentData"),
            //selectDateselectDate :component.find('select_date').get('v.value'),
            sobjectName:'Account', //Any object
            fields:fieldsList
            

        });        
        action.setCallback(this, function(response) {
        }); 
        debugger
        action1.setCallback(this, function(response) {
            console.log('response = '  + JSON.stringify(response));
            var state = response.getState();
            if (state === "SUCCESS") {
                
                var res = response.getReturnValue();
                var res1 = '';
                console.log("[[[[[["+res);
                if(res != 'success'){
                    var ress = res.split('=');
                    console.log(ress);
                    for (var i=0; i<ress.length; i++) {
                        res1 += ress[i].substr(7)+'\n';
                var ress = response.getReturnValue();
                console.log('ress = '  + JSON.stringify(ress));
                if(ress){
                    var valur =ress.split('error1');
                    if(valur.length<=1){
                        var res = JSON.parse(response.getReturnValue());
                        console.log('res = '  + JSON.stringify(res));
                        var dataArr = new Array();
                        var dataMap = new Map();
                        res.forEach(item => {
                            if(item.AWS_Data_Id__c){
                                dataArr.push(item.AWS_Data_Id__c);
                                //dataMap.set(item.AWS_Data_Id__c,item.Name_Encrypted__c);
                                dataMap.set(item.AWS_Data_Id__c,item.AWS_Data_Id__c);       //zhj 新方案改造 2022-12-21
                            }
                        });
                        let obj= Object.create(null);
                        obj['dataIds'] = dataArr;
                        var payload = JSON.stringify(obj);
                        console.log('payload zhj = ' + JSON.stringify(payload));
                        
                        this.search_contact_url(component, 'Agency_Contact__c', (result)=>{
                            var token = result.token;
                            var searchUrl = result.searchUrl;
                            this.search_core(token,searchUrl,payload,(result)=>{
                                if(result.status == '0'){
                                    if(result.object != null&&result.object.length != 0){
                                        // var resultjson = JSON.stringify(result.object);
                                        // if(resultjson){
                                        //     debugger
                                        //     console.warn('001');
                                        //     component.set('v.login',true);
                                        //     this.ImportMethod(component,resultjson);
                                        // }
                                        component.set('v.login',true);
                                        this.saveRecordsEditFile(component,dataMap,result.object,helper);
                                    }else{
                                        this.error('AWS 查询数据为空 ' );
                                        component.set('v.login',false);
                                    }
                                }else{
                                    this.error('AWS search status6 : ' + result.status);
                                    component.set('v.login',false);
                                }
                            },component);
                        //     var resultjson =null;
                        // this.ImportMethod(component,resultjson);
                            
                        });
                        // var resultjson =null;
                        // this.ImportMethod(component,resultjson);
                    }else{
                        this.error(valur[1]+'\n'+"请修改后重新上传");
                    }
                    // $('.forceToastManager').css('white-space', 'pre-wrap');
                    console.log("=="+res1);
                    this.error(res1+"请修改后重新上传");
                    component.set('v.login',false);
                }else{
                    component.set("v.showMain",true);
                    this.success("导入成功");
                    // alert('saved successfully');
                    component.set('v.login',false);
                }
                
            }
            else if (state === "INCOMPLETE") {
                // do something
                component.set('v.login',false);
            }
            else if (state === "ERROR") {
                var errors = response.getError();
                if (errors) {
                    if (errors[0] && errors[0].message) {
                        console.log("Error message: " + 
                                 errors[0].message);
                        component.set('v.login',false);
                    }
                } else {
                    console.log("Unknown error");
                    component.set('v.login',false);
                }
            }
        });
        $A.enqueueAction(action);
        $A.enqueueAction(action1);
        //fy 导入 20220424 end
        // var action = component.get("c.processData");
        // var selectDate = component.find('select_date').get('v.value');
        // var fieldsList=['Name','Phone','AccountNumber']; //Please write your code dynamic 
        // var sss=component.get("v.fileContentData");
        // action.setParams({ 
        //     fileData : component.get("v.fileContentData"),
        //     //selectDateselectDate :component.find('select_date').get('v.value'),
        //     sobjectName:'Account', //Any object
        //     fields:fieldsList
        // });        
        // action.setCallback(this, function(response) {
        //     var state = response.getState();
        //     if (state === "SUCCESS") {
                
        //         var res = response.getReturnValue();
        //         var res1 = '';
        //         console.log("[[[[[["+res);
        //         if(res != 'success'){
        //             debugger
        //             var ress = res.split('=');
        //             console.log(ress);
        //             for (var i=0; i<ress.length; i++) {
        //                 res1 += ress[i].substr(7)+'\n';
        //             }
        //             // $('.forceToastManager').css('white-space', 'pre-wrap');
        //             console.log("=="+res1);
        //             this.error(res1+"请修改后重新上传");
        //             component.set('v.login',false);
        //         }else{
        //             component.set("v.showMain",true);
        //             this.success("导入成功");
        //             // alert('saved successfully');
        //             component.set('v.login',false);
        //         }
                
        //     }
        //     else if (state === "INCOMPLETE") {
        //         // do something
        //         component.set('v.login',false);
        //     }
        //     else if (state === "ERROR") {
        //         var errors = response.getError();
        //         if (errors) {
        //             if (errors[0] && errors[0].message) {
        //                 console.log("Error message: " + 
        //                          errors[0].message);
        //                 component.set('v.login',false);
        //             }
        //         } else {
        //             console.log("Unknown error");
        //             component.set('v.login',false);
        //         }
        //     }
        // });
        // $A.enqueueAction(action);

    },
    },isNumber: function(str) {
        return /^\d+$/.test(str);
    },ImportMethod : function(component,fileStr){
        debugger
        var actionss = component.get("c.processData");
         var selectDate = component.find('select_date').get('v.value');
        var fieldsList=['Name','Phone','AccountNumber']; //Please write your code dynamic 
        var sss=component.get("v.fileContentData");
        actionss.setParams({ 
            // fileData : component.get("v.fileContentData"),
            fileData : fileStr,
            // selectDateselectDate :component.find('select_date').get('v.value'),
            sobjectName:'Account', //Any object
            fields:fieldsList
            // Agency_ContactListjson:resultjson
        }); 
        actionss.setCallback(this, function(response) {
                console.log('002');
                var state = response.getState();
                if (state === "SUCCESS") {
                    var res = response.getReturnValue();
                    var res1 = '';
                    console.log("[[[[[["+res);
                    if(res != 'success'){
                        var ress = res.split('=');
                        console.log(ress);
                        let errorDatas = [];
                        let errorDataRow = [];
                        debugger
                        for (var i=0; i<ress.length; i++) {
                            res1 += ress[i].substr(7)+'\n';
                            if (ress[i] != '') {
                                let errorData = {}
                                if(!this.isNumber(ress[i].substr(7).substring(1, 2))){
                                    continue
                                }
                                let index = errorDataRow.indexOf(ress[i].substr(7).substring(1, 2));
                                if (index == -1) {
                                    errorData.errorRow = ress[i].substr(7).substring(1, 2);
                                    errorDataRow.push(errorData.errorRow);
                                    errorData.errorInfo = ress[i].substr(7).substring(5).replace('=','');
                                    errorDatas.push(errorData);
                                } else {
                                    errorDatas[index].errorInfo += '; ' + ress[i].substr(7).substring(5);
                                }
                            }
                        }
                        var fileContentData = component.get("v.fileContentData").split('\n');
                        let errorColumns = [
                            { label: '错误行', fieldName: 'errorRow', type: 'text', hideDefaultActions: true, initialWidth: 100 },
                            { label: '错误信息', fieldName: 'errorInfo', type: 'text', hideDefaultActions: true, initialWidth: 300, wrapText: true }
                        ];
                        for (var i = 0; i < fileContentData[0].split(',').length; i++) {
                            errorColumns.push({
                                label: fileContentData[0].split(',')[i], 
                                fieldName: 'field' + i, 
                                type: 'text', 
                                hideDefaultActions: true, 
                                wrapText: true,
                                initialWidth: 120
                            });
                        }

                        for (var i = 0; i < errorDatas.length; i++) {
                            let data = fileContentData[errorDatas[i].errorRow];
                            console.log('data = ' + JSON.stringify(data));
                            if(data){
                                for (var j = 0; j < data.split(',').length; j++) {
                                    let label = 'field' + j;
                                    errorDatas[i][label] = data.split(',')[j];
                                }
                            }
                        }
                        component.set('v.errorColumns', errorColumns);
                        component.set('v.errorData', errorDatas);
                        component.set("v.showErrorInfo", true);
                        console.log("=="+res1);
                        this.error(res1+"请修改后重新上传");
                        component.set('v.login',false);
                    }else{
                        component.set("v.showMain",true);
                        this.success("导入成功");
                        // alert('saved successfully');
                        component.set('v.login',false);
                    }
                    
                }
                else if (state === "INCOMPLETE") {
                    // do something
                    component.set('v.login',false);
                }
                else if (state === "ERROR") {
                    var errors = response.getError();
                    if (errors) {
                        if (errors[0] && errors[0].message) {
                            console.log("Error message: " + 
                                    errors[0].message);
                            component.set('v.login',false);
                        }
                    } else {
                        console.log("Unknown error");
                        component.set('v.login',false);
                    }
                }
        });    
        $A.enqueueAction(actionss);
    },saveRecordsEditFile : function(component,dataMap,searchData,helper){
        var searchDataMap = new Map();
         for (var i = 0; i < searchData.length; i++) {
         var sd = searchData[i];
         if(sd.name)
         searchDataMap.set(sd.name.replace(' ',''),sd.dataId);
         }
         console.log('searchDataMap='+searchDataMap);
         var error = '';
         var fileData = component.get("v.fileContentData");
         var files = fileData.split('\n');

         var fileStr = files[0];
         fileStr += '\n';

       for (var i = 1; i < files.length-1; i++) {
         var filelist = files[i].split(',');
         var fileName = filelist[4];

         if (searchDataMap.get(fileName.replace(' ',''))) {
                 var nameDataId = searchDataMap.get(fileName.replace(' ',''));
                if (dataMap.get(nameDataId)) {
                     filelist[4] = dataMap.get(nameDataId);     //zhj 新方案改造 filelist[4]不再存的nameEncrpt 2022-12-21
                }else {
                     error += 'error1 第'+i+'行数据拜访人SF不存在';
                     error += '=';
                }
            }else {
                 error += 'error1 第'+i+'行数据拜访人AWS不存在';
                 error += '=';
            }
            fileStr += filelist.toString();
             fileStr += '\n';
        }

        if (error != '') {
            console.log('zhj error = ' + error);
            let errorArray = error.split('error1');
            let errorDatas = [];
            let errorDataRow = [];
            debugger
            console.log('errorArray = ' + JSON.stringify(errorArray))
            for (var i in errorArray) {
                if (errorArray[i] != '') {
                    let errorData = {}
                    if(!this.isNumber(errorArray[i].trim().substring(1, 2))){
                        continue
                    }
                    let index = errorDataRow.indexOf(errorArray[i].trim().substring(1, 2));
                    if (index == -1) {
                        errorData.errorRow = errorArray[i].trim().substring(1, 2);
                        errorDataRow.push(errorData.errorRow);
                        errorData.errorInfo = errorArray[i].trim().substring(5,errorArray[i].trim().length).replace('=','');
                        errorDatas.push(errorData);
                    } else {
                        errorDatas[index].errorInfo += '; ' + errorArray[i].trim().substring(5,errorArray[i].trim().length);
                    }
                }
            }
            var fileContentData = component.get("v.fileContentData").split('\n');
            let errorColumns = [
                { label: '错误行', fieldName: 'errorRow', type: 'text', hideDefaultActions: true, initialWidth: 100 },
                { label: '错误信息', fieldName: 'errorInfo', type: 'text', hideDefaultActions: true, initialWidth: 300, wrapText: true }
            ];
            for (var i = 0; i < fileContentData[0].split(',').length; i++) {
                errorColumns.push({
                    label: fileContentData[0].split(',')[i], 
                    fieldName: 'field' + i, 
                    type: 'text', 
                    hideDefaultActions: true, 
                    wrapText: true,
                    initialWidth: 120
                });
            }

            for (var i = 0; i < errorDatas.length; i++) {
                let data = fileContentData[errorDatas[i].errorRow];
                console.log('data = ' + JSON.stringify(data));
                for (var j = 0; j < data.split(',').length; j++) {
                    let label = 'field' + j;
                    errorDatas[i][label] = data.split(',')[j];
                }
            }
            console.log('errorDatas =' + JSON.stringify(errorDatas))
            component.set('v.errorColumns', errorColumns);
            component.set('v.errorData', errorDatas);
            component.set("v.showErrorInfo", true);



            console.log('error = ' + error);
            component.set('v.errorMessage', error);

            this.error(error);
            console.log('error='+error);
            component.set('v.login',false);
            return;
         }

         console.log('fileStr='+fileStr);
         $A.getCallback(function(){
             debugger
             helper.ImportMethod(component,fileStr);
         })();

     },
    convertArrayOfObjectsToCSV : function(component,objectRecords){
        var csvStringResult, counter, keys, columnDivider, lineDivider,thkeys;
        if (objectRecords == null || !objectRecords.length) {
@@ -1944,7 +2251,7 @@
         }
        columnDivider = ',';
        lineDivider =  '\n';
        //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start
        //SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start ,'SupportNeeds__c'  ,'支援需求'
        keys = ['Submit_date__c','Person_In_Charge2__c','Report_Date__c','Agency_Hospital__c','Department_Cateogy__c','doctor2__c','visitor_title__c','Product_Category1__c','Product_Category2__c','Product_Category3__c','Purpose_Type__c','Result__c','SupportNeeds__c'];
        thkeys = ['周','担当','活动日','医院','科室','拜访人','职位','产品区分1','产品区分2','产品区分3','活动区分','结果','支援需求']
        csvStringResult = '';
@@ -1974,9 +2281,11 @@
                    csvStringResult += '"'+ objectRecords[i].Product_Category2__r.Name+'"';
                }else if(skey == 'Product_Category3__c'){
                    csvStringResult += '"'+ objectRecords[i].Product_Category3__r.Name+'"';
                }else if(skey == 'SupportNeeds__c'){//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start
                }
                else if(skey == 'SupportNeeds__c'){//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start
                    csvStringResult += '"'+ objectRecords[i].SupportNeeds__c+'"';
                }else{
                }
                else{
                    csvStringResult += '"'+ objectRecords[i][skey]+'"';
                }
                counter++;
@@ -1990,7 +2299,7 @@
        return csvStringResult;        
    },
    showExportDate : function(component,objectRecords){
        console.log('进入showexceportdate'+objectRecords);//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start
        console.log('进入showexceportdate'+objectRecords);//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start  ,'SupportNeeds__c' ,'支援需求'
        var keys = ['Submit_date__c','Person_In_Charge2__c','Report_Date__c','Agency_Hospital__c','Department_Cateogy__c','doctor2__c','visitor_title__c','Product_Category1__c','Product_Category2__c','Product_Category3__c','Purpose_Type__c','Result__c','SupportNeeds__c'];
        var headers = ['周','担当','活动日','医院','科室','拜访人','职位','产品区分1','产品区分2','产品区分3','活动区分','结果','支援需求']
        var content = "<table class=\"table slds-table slds-table--bordered slds-table--cell-buffer\">";
@@ -2023,9 +2332,11 @@
                    content += '<td>'+ objectRecords[i].Product_Category2__r.Name+'</td>';
                }else if(skey == 'Product_Category3__c'){
                    content += '<td>'+ objectRecords[i].Product_Category3__r.Name+'</td>';
                }else if(skey == 'SupportNeeds__c'){//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start
                }
                else if(skey == 'SupportNeeds__c'){//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start
                    content += '<td>'+ objectRecords[i].SupportNeeds__c+'</td>';
                }else{
                }
                else{
                    content += '<td>'+ objectRecords[i][skey]+'</td>';
                }
            } // inner for loop close     
@@ -2136,8 +2447,89 @@
        var modalimportbg = component.find('modal_exportbg');
        $A.util.addClass(modalimport, 'disp_none');
        $A.util.addClass(modalimportbg,'disp_none');
    }
    
    },

    //zhj MEBG新方案改造 2022-11-29 start
    CallBackAction  : function(component,action_name,para,callback) {
      var action = component.get("c." + action_name.trimStart().replace("c.",""));
        if(para){
            action.setParams(para);
        }
        if(callback){
            action.setCallback(this,function(data){
                callback(data);
            });
        }
        
        $A.enqueueAction(action);
   },
    //zhj MEBG新方案改造 2022-11-29 end

    //zhj 导出错误信息 2023-05-16 start
    exportErrorInfoHelper: function (component) {
        var errorData = component.get('v.errorData');
        var errorColumns = component.get('v.errorColumns');

        var datas = [];
        let errorColumnsArray = [];
        for(var i in errorColumns){
            errorColumnsArray.push(errorColumns[i].label);
        }
        datas.push(errorColumnsArray);
        //datas.push(errorColumns);

        for (var i in errorData) {
            let data = [];
            data.push(errorData[i].errorRow)
            data.push(errorData[i].errorInfo)
            for(var j = 0 ; j < Object.keys(errorData[i]).length - 2 ; j++){
                data.push(errorData[i]['field' + j])
            }
            datas.push(data);
        }

        console.log('datas = ' + JSON.stringify(datas));
        var csv = this.convertToCSV(component, datas);
        console.log('csv = ' + JSON.stringify(csv))
        this.downloadCSV(component, csv);
    },

    convertToCSV: function (component, data) {
        console.log('enter convertToCSV')
        console.log('data = ' + data);
        var csv = '';
        for (var i = 0; i < data.length; i++) {
            var row = data[i];
            console.log('row = ' + JSON.stringify(row));
            for (var j = 0; j < row.length; j++) {
                var val = '';
                val = row[j] === null ? '' : row[j].toString();
                console.log('val = ' + val);
                if (val.indexOf(',') !== -1 || val.indexOf('"') !== -1 || val.indexOf('\n') !== -1) {
                    //val = '"' + val.replace(/"/g,'""') + '"';
                }
                if (j > 0) {
                    csv += ',';
                }
                csv += val;
            }
            csv += '\n';
        }
        return csv;
    },

    downloadCSV: function (component, csv) {
        var link = document.createElement('a');
        // 设置字符集和文件头
        var bom = "\uFEFF";
        link.href = 'data:text/csv;charset=utf-8,' + encodeURIComponent(bom + csv);
        link.download = 'data.csv';
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
    },
    //zhj 导出错误信息 2023-05-16 end

    // searchAgencyContact : function(res) {
    //     var agencyContacts = [];
    //     for (let idx = 0; idx < res.length; idx++) {