ET产品-效期修改

高章伟

2023-03-28 32ca554edf2f2533790ad095e5691bbe478468a3

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

@@ -373,7 +373,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']);
@@ -448,6 +453,7 @@
            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 +487,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 +509,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 +531,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,6 +954,9 @@
        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','');
@@ -1220,6 +1232,20 @@
    },

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

        // 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);
        
        fetch(newUrl, {
            method: 'POST',
            body: payload,
@@ -1234,7 +1260,6 @@
                $A.getCallback(function(){
                    helper.to_agencycontact(component,result,agencyHospitalid);
                })();

            }else{
                console.log('AWS status error:' + result)
                component.set('v.login',false);
@@ -1863,65 +1888,232 @@
        reader.readAsDataURL(file);
    },
    
    saveRecords : function(component,event){
    saveRecords : function(component,event,helper){
        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 fields
        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) {
        }); 
        action1.setCallback(this, function(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();
                if(ress){
                    var valur =ress.split('error1');
                    if(valur.length<=1){
                        var res = JSON.parse(response.getReturnValue());
                        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);
                            }
                        });
                        debugger
                        let obj= Object.create(null);
                        obj['dataIds'] = dataArr;
                        var payload = JSON.stringify(obj);
                        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 search status ' );
                                        component.set('v.login',false);
                                    }
                                }else{
                                    this.error('AWS search status : ' + 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);

    },
    },ImportMethod : function(component,fileStr){
        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);
                        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(actionss);
    },saveRecordsEditFile : function(component,dataMap,searchData,helper){
        var searchDataMap = new Map();
         for (var i = 0; i < searchData.length; i++) {
         var sd = searchData[i];
         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);
                }else {
                     error += 'error1 第'+i+'行数据拜访人SF不存在';
                     error += '=';
                }
            }else {
                 error += 'error1 第'+i+'行数据拜访人AWS不存在';
                 error += '=';
            }
            fileStr += filelist.toString();
             fileStr += '\n';
        }

        if (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) {
@@ -1929,8 +2121,9 @@
         }
        columnDivider = ',';
        lineDivider =  '\n';
        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'];
        thkeys = ['周','担当','活动日','医院','科室','拜访人','职位','产品区分1','产品区分2','产品区分3','活动区分','结果']
        //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 = '';
        csvStringResult += thkeys.join(columnDivider);
        csvStringResult += lineDivider;
@@ -1958,7 +2151,11 @@
                    csvStringResult += '"'+ objectRecords[i].Product_Category2__r.Name+'"';
                }else if(skey == 'Product_Category3__c'){
                    csvStringResult += '"'+ objectRecords[i].Product_Category3__r.Name+'"';
                }else{
                }
                else if(skey == 'SupportNeeds__c'){//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start
                    csvStringResult += '"'+ objectRecords[i].SupportNeeds__c+'"';
                }
                else{
                    csvStringResult += '"'+ objectRecords[i][skey]+'"';
                }
                counter++;
@@ -1972,9 +2169,9 @@
        return csvStringResult;        
    },
    showExportDate : function(component,objectRecords){
        console.log('进入showexceportdate'+objectRecords);
        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'];
        var headers = ['周','担当','活动日','医院','科室','拜访人','职位','产品区分1','产品区分2','产品区分3','活动区分','结果']
        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\">";
        content += "<thead><tr class=\"slds-text-title--caps\">";
        for(i=0;i<headers.length; i++){
@@ -2005,7 +2202,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{
                }
                else if(skey == 'SupportNeeds__c'){//SWAG-CBX68C fy 【委托】DAMS系统周报模块内容需求增加 start
                    content += '<td>'+ objectRecords[i].SupportNeeds__c+'</td>';
                }
                else{
                    content += '<td>'+ objectRecords[i][skey]+'</td>';
                }
            } // inner for loop close     
@@ -2036,7 +2237,47 @@
                var res = response.getReturnValue();
                console.log('输入的开始日期3'+res);
                component.set('v.login',false);
                this.showExportDate(component,res);

                // PI 改造 By Bright 20220328
                if(true){
                    let awsids = [];
                    for (let ri in res) {
                        if(res[ri] && res[ri].doctor2__r && res[ri].doctor2__r.AWS_Data_Id__c){
                            awsids.push(res[ri].doctor2__r.AWS_Data_Id__c);
                        }
                    }                    
                    if(awsids.length > 0){
                        let awsurl = component.get('v.awsurl');
                        
                        AWSService.search(awsurl.searchUrl,{
                            dataIds:awsids
                        }, function(data){
                            if(data && data.object && data.object.length){
                                let m = {};
                                for(let di in data.object){
                                    if(data.object[di] && data.object[di].dataId){
                                        m[data.object[di].dataId] = data.object[di];
                                    }
                                }
                                
                                for(let ri in res){
                                    if(res[ri] && res[ri].doctor2__r && res[ri].doctor2__r.AWS_Data_Id__c && m.hasOwnProperty(res[ri].doctor2__r.AWS_Data_Id__c)){
                                        res[ri].doctor2__r.Name = m[res[ri].doctor2__r.AWS_Data_Id__c].name;
                                        res[ri].visitor_title__c = m[res[ri].doctor2__r.AWS_Data_Id__c].doctorDivision1;
                                        
                                    }
                                }
                            }
                            helper.showExportDate(component, res);
                            
                            component.set('v.login', false);
                        }, awsurl.token);
                    }else{
                        helper.showExportDate(component, res);
                    }
                }
                

                component.set('v.reports_date', res);
                
            }else{
@@ -2112,5 +2353,4 @@
    //     var data = this.search(searchUrl,data,token);
    //     return data;searchUrl,requestSearchPayload,token
    // },
    
})