binxie
2023-06-20 6d14c34d9a4e304bf3289e4ad957b091f27ef3b8
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++) {
@@ -438,6 +439,7 @@
                    }
                    if (reportDate != null) {
                        console.log('reportDate = ' + reportDate);
                        component.set('v.data.Report_Date__c', reportDate);
                    }
                    
@@ -962,6 +964,7 @@
        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', '');
@@ -1171,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);
@@ -1231,7 +1233,7 @@
        $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'){
@@ -1263,7 +1265,11 @@
            }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)
@@ -1277,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,
        });
@@ -1422,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);
@@ -1443,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,
@@ -1456,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);
        });
@@ -1519,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');
@@ -1582,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);
@@ -1784,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 = '';
@@ -1889,32 +1905,39 @@
    },
    
    saveRecords : function(component,event,helper){
        debugger
        component.set('v.login',true);
        //fy 导入 20220424 start
        var action1 = component.get("c.processDataAWSId");
        action1.setParams({ 
            fileData : component.get("v.fileContentData"),
        }); 
        debugger
        action1.setCallback(this, function(response) {
            console.log('response = '  + JSON.stringify(response));
            var state = response.getState();
            if (state === "SUCCESS") {
                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.Name_Encrypted__c);
                                dataMap.set(item.AWS_Data_Id__c,item.AWS_Data_Id__c);       //zhj 新方案改造 2022-12-21
                            }
                        });
                        debugger
                        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;
@@ -1931,11 +1954,11 @@
                                        component.set('v.login',true);
                                        this.saveRecordsEditFile(component,dataMap,result.object,helper);
                                    }else{
                                        this.error('AWS search status ' );
                                        this.error('AWS 查询数据为空 ' );
                                        component.set('v.login',false);
                                    }
                                }else{
                                    this.error('AWS search status : ' + result.status);
                                    this.error('AWS search status6 : ' + result.status);
                                    component.set('v.login',false);
                                }
                            },component);
@@ -2009,7 +2032,10 @@
        // });
        // $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 
@@ -2032,10 +2058,56 @@
                    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);
                                }
                            }
                        }
                        // $('.forceToastManager').css('white-space', 'pre-wrap');
                        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);
@@ -2070,6 +2142,7 @@
        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);
@@ -2087,7 +2160,7 @@
         if (searchDataMap.get(fileName.replace(' ',''))) {
                 var nameDataId = searchDataMap.get(fileName.replace(' ',''));
                if (dataMap.get(nameDataId)) {
                     filelist[4] = dataMap.get(nameDataId);
                     filelist[4] = dataMap.get(nameDataId);     //zhj 新方案改造 filelist[4]不再存的nameEncrpt 2022-12-21
                }else {
                     error += 'error1 第'+i+'行数据拜访人SF不存在';
                     error += '=';
@@ -2101,6 +2174,63 @@
        }
        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);
@@ -2317,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++) {