From 41625c74ad92b72151f4d1009ea0c791635d9dac Mon Sep 17 00:00:00 2001 From: binxie <137736985@qq.com> Date: 星期一, 19 六月 2023 22:02:56 +0800 Subject: [PATCH] test --- force-app/main/default/aura/WeeklyReport/WeeklyReportHelper.js | 637 +++++++++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 541 insertions(+), 96 deletions(-) diff --git a/force-app/main/default/aura/WeeklyReport/WeeklyReportHelper.js b/force-app/main/default/aura/WeeklyReport/WeeklyReportHelper.js index f49b1b0..10a6ca0 100644 --- a/force-app/main/default/aura/WeeklyReport/WeeklyReportHelper.js +++ b/force-app/main/default/aura/WeeklyReport/WeeklyReportHelper.js @@ -12,8 +12,8 @@ component.set('v.allselectlist',res.allselectlist); component.set('v.doclist',res.doclist); // PIPL update Yin Mingjie 21/02/2022 start - // component.find('select_agency_person').set('v.options', this.conv_selected(res.allselectlist.AgencyPerson__c)); - this.search_contact(component, event, helper,res.allselectlist.AgencyPerson__c); + component.find('select_agency_person').set('v.options', this.conv_selected(res.allselectlist.AgencyPerson__c)); + // this.search_contact(component, event, helper,res.allselectlist.AgencyPerson__c); // PIPL update Yin Mingjie 21/02/2022 end component.find('select_department').set('v.options', this.conv_selected(res.allselectlist.Department_Cateogy__c)); component.find('select_purpose_type').set('v.options', this.conv_selected(res.allselectlist.Purpose_Type__c)); @@ -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 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� start + // 鏀彺闇�姹� + if (select_data['SupportNeeds__c'] != '') { + this.set_selected(component, 'SupportNeeds__c', select_data['SupportNeeds__c']); + } + //SWAG-CBX68C fy 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� 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 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� !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 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� 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 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� 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 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� start + component.find('SupportNeeds__c').set('v.options', this.conv_selected(component.get('v.allselectlist.SupportNeeds__c'))); + //SWAG-CBX68C fy 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� 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,7 +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); + // })(); + + // }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,11 +1262,14 @@ $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) @@ -1252,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, }); @@ -1397,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); @@ -1418,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, @@ -1431,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); }); @@ -1494,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'); @@ -1557,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); @@ -1759,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 = ''; @@ -1863,67 +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"); - debugger; - var selectDate = component.find('select_date').get('v.value'); - var fieldsList=['Name','Phone','AccountNumber']; //Please write your code dynamic fields - 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) { @@ -1931,7 +2251,7 @@ } columnDivider = ','; lineDivider = '\n'; - //SWAG-CBX68C fy 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� start + //SWAG-CBX68C fy 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� 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 = ''; @@ -1961,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 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� start + } + else if(skey == 'SupportNeeds__c'){//SWAG-CBX68C fy 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� start csvStringResult += '"'+ objectRecords[i].SupportNeeds__c+'"'; - }else{ + } + else{ csvStringResult += '"'+ objectRecords[i][skey]+'"'; } counter++; @@ -1977,7 +2299,7 @@ return csvStringResult; }, showExportDate : function(component,objectRecords){ - console.log('杩涘叆showexceportdate'+objectRecords);//SWAG-CBX68C fy 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� start + console.log('杩涘叆showexceportdate'+objectRecords);//SWAG-CBX68C fy 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� 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\">"; @@ -2010,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 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� start + } + else if(skey == 'SupportNeeds__c'){//SWAG-CBX68C fy 銆愬鎵樸�慏AMS绯荤粺鍛ㄦ姤妯″潡鍐呭闇�姹傚鍔� start content += '<td>'+ objectRecords[i].SupportNeeds__c+'</td>'; - }else{ + } + else{ content += '<td>'+ objectRecords[i][skey]+'</td>'; } } // inner for loop close @@ -2043,7 +2367,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{ @@ -2083,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++) { -- Gitblit v1.9.1