From e6068da47c1bef5517c9e5fdc8c726766867ad4e Mon Sep 17 00:00:00 2001
From: buli <137736985@qq.com>
Date: 星期五, 14 七月 2023 15:10:02 +0800
Subject: [PATCH] Merge branch 'master' into LEXUpgrade2023-Deloitte
---
force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImportHelper.js | 269 +++++++++++++++++++++++++++++++++--------------------
1 files changed, 165 insertions(+), 104 deletions(-)
diff --git a/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImportHelper.js b/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImportHelper.js
index cbd114b..dddc5bf 100644
--- a/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImportHelper.js
+++ b/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImportHelper.js
@@ -17,81 +17,93 @@
break; // noop
default:
alert('An error occurred reading this file.');
- };
- }
+ }
+ };
reader.onabort = function (e) {
alert('File read cancelled');
};
reader.onloadstart = function (e) {
- var output = '<ui type=\"disc\"><li><strong>' + file.name + '</strong> (' + file.type + ')- ' + file.size + 'bytes, last modified: ' + file.lastModifiedDate.toLocaleDateString() + '</li></ui>';
- component.set("v.filename", file.name);
- component.set("v.TargetFileName", output);
+ var output =
+ '<ui type="disc"><li><strong>' +
+ file.name +
+ '</strong> (' +
+ file.type +
+ ')- ' +
+ file.size +
+ 'bytes, last modified: ' +
+ file.lastModifiedDate.toLocaleDateString() +
+ '</li></ui>';
+ component.set('v.filename', file.name);
+ component.set('v.TargetFileName', output);
};
reader.onload = function (e) {
var data = e.target.result;
// data.replace(/\n/,"")
var allTextLines11 = data.split(/\r/);
var s = allTextLines11.toString();
- component.set("v.fileContentData", s);
- console.log("file dataqqq" + JSON.stringify(s));
+ component.set('v.fileContentData', s);
+ console.log('file dataqqq' + JSON.stringify(s));
var allTextLines = data.split(/\r\n|\n/);
var dataRows = allTextLines.length - 1;
var headers = allTextLines[0].split(',');
- var numOfRows = component.get("v.NumOfRecords");
- if (dataRows > numOfRows + 1 || dataRows == 1 || dataRows == 0) {
- alert("File Rows between 1 to " + numOfRows + " .");
- component.set("v.showMain", true);
- }
- else {
+ var numOfRows = component.get('v.NumOfRecords');
+ if (
+ dataRows > numOfRows + 1 ||
+ dataRows == 1 ||
+ dataRows == 0
+ ) {
+ alert('File Rows between 1 to ' + numOfRows + ' .');
+ component.set('v.showMain', true);
+ } else {
var lines = [];
var filecontentdata;
- var content = "<table class=\"table slds-table slds-table--bordered slds-table--cell-buffer\">";
- content += "<thead><tr class=\"slds-text-title--caps\">";
- content += '<th scope=\"col"\>' + '琛屽彿' + '</th>';
+ var content =
+ '<table class="table slds-table slds-table--bordered slds-table--cell-buffer">';
+ content += '<thead><tr class="slds-text-title--caps">';
+ content += '<th scope="col">' + '琛屽彿' + '</th>';
for (i = 0; i < headers.length; i++) {
- content += '<th scope=\"col"\>' + headers[i] + '</th>';
+ content += '<th scope="col">' + headers[i] + '</th>';
}
- content += "</tr></thead>";
+ content += '</tr></thead>';
for (var i = 1; i < allTextLines.length; i++) {
filecontentdata = allTextLines[i].split(',');
if (filecontentdata[0] != '') {
- content += "<tr>";
- content += "<td>" + i + "</td>";
+ content += '<tr>';
+ content += '<td>' + i + '</td>';
for (var j = 0; j < filecontentdata.length; j++) {
- content += '<td>' + filecontentdata[j] + '</td>';
+ content +=
+ '<td>' + filecontentdata[j] + '</td>';
}
- content += "</tr>";
+ content += '</tr>';
}
}
- content += "</table>";
+ content += '</table>';
console.log(content);
- component.set("v.TableContent", content);
- component.set("v.showMain", false);
+ component.set('v.TableContent', content);
+ component.set('v.showMain', false);
}
- }
+ };
reader.readAsText(file, 'gb2312');
-
}
var reader = new FileReader();
- reader.onloadend = function () {
- };
+ reader.onloadend = function () {};
reader.readAsDataURL(file);
},
- isNumber: function(str) {
+ isNumber: function (str) {
return /^\d+$/.test(str);
},
saveRecords: function (component, event, helper) {
component.set('v.login', true);
- var action = component.get("c.processData");
+ var action = component.get('c.processData');
var fieldsList = ['Name', 'Phone', 'AccountNumber']; //Please write your code dynamic fields
action.setParams({
- fileData: component.get("v.fileContentData"),
+ fileData: component.get('v.fileContentData'),
sobjectName: 'Account', //Any object
fields: fieldsList
});
action.setCallback(this, function (response) {
var state = response.getState();
- if (state === "SUCCESS") {
+ if (state === 'SUCCESS') {
var res = response.getReturnValue();
var res1 = '';
if (res != 'success') {
@@ -99,146 +111,190 @@
console.log(ress);
let errorDatas = [];
let errorDataRow = [];
- debugger
+ 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 errorData = {};
+ if (
+ !this.isNumber(
+ ress[i].substr(7).substring(1, 2)
+ )
+ ) {
+ continue;
}
- let index = errorDataRow.indexOf(ress[i].substr(7).substring(1, 2));
+ let index = errorDataRow.indexOf(
+ ress[i].substr(7).substring(1, 2)
+ );
if (index == -1) {
- errorData.errorRow = ress[i].substr(7).substring(1, 2);
+ errorData.errorRow = ress[i]
+ .substr(7)
+ .substring(1, 2);
errorDataRow.push(errorData.errorRow);
- errorData.errorInfo = ress[i].substr(7).substring(5);
+ errorData.errorInfo = ress[i]
+ .substr(7)
+ .substring(5);
errorDatas.push(errorData);
} else {
- errorDatas[index].errorInfo += '; ' + ress[i].substr(7).substring(5);
+ errorDatas[index].errorInfo +=
+ '; ' + ress[i].substr(7).substring(5);
}
}
}
- var fileContentData = component.get("v.fileContentData").split('\n');
+ 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 }
+ {
+ 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 - 1; i++) {
+ for (
+ var i = 0;
+ i < fileContentData[0].split(',').length - 1;
+ i++
+ ) {
errorColumns.push({
- label: fileContentData[0].split(',')[i],
- fieldName: 'field' + i,
- type: 'text',
+ label: fileContentData[0].split(',')[i],
+ fieldName: 'field' + i,
+ type: 'text',
hideDefaultActions: true,
wrapText: true,
initialWidth: 120
});
}
-
- for(var i = 0; i < errorDatas.length; i++){
+
+ 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++){
+ if (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))
-
+ console.log('errorDatas = ' + JSON.stringify(errorDatas));
+
component.set('v.errorColumns', errorColumns);
component.set('v.errorData', errorDatas);
- component.set("v.showErrorInfo", true);
+ component.set('v.showErrorInfo', true);
- console.log("==" + res1);
+ console.log('==' + res1);
// this.error( "璇蜂慨鏀瑰悗閲嶆柊涓婁紶");
- component.set('v.errorMessage', res1 + "璇蜂慨鏀瑰悗閲嶆柊涓婁紶");
+ component.set('v.errorMessage', res1 + '璇蜂慨鏀瑰悗閲嶆柊涓婁紶');
this.showErrorToast(component);
component.set('v.login', false);
- component.find('save_con').set('v.disabled', true);
+ component.find('save_con').set('v.disabled', true);
} else {
// this.success('瀵煎叆鎴愬姛');
component.set('v.successMessage', '瀵煎叆鎴愬姛');
this.showSuccessToast01(component);
- component.set("v.showMain", true);
+ component.set('v.showMain', true);
component.set('v.login', false);
- component.find('save_con').set('v.disabled', false);
+ component.find('save_con').set('v.disabled', false);
}
- }
- else if (state === "INCOMPLETE") {
+ } else if (state === 'INCOMPLETE') {
component.set('v.login', false);
- }
- else if (state === "ERROR") {
+ } else if (state === 'ERROR') {
var errors = response.getError();
if (errors) {
if (errors[0] && errors[0].message) {
- console.log("Error message: " + errors[0].message);
- let errorDatas = [{
- errorRow: '1',
- errorInfo: errors[0].message
- }];
+ console.log('Error message: ' + errors[0].message);
+ let errorDatas = [
+ {
+ errorRow: '1',
+ errorInfo: errors[0].message
+ }
+ ];
let errorColumns = [
- { label: '閿欒琛�', fieldName: 'errorRow', type: 'text', hideDefaultActions: true, initialWidth: 50 },
- { label: '閿欒淇℃伅', fieldName: 'errorInfo', type: 'text', hideDefaultActions: true,initialWidth: 300,wrapText: true }
+ {
+ label: '閿欒琛�',
+ fieldName: 'errorRow',
+ type: 'text',
+ hideDefaultActions: true,
+ initialWidth: 50
+ },
+ {
+ label: '閿欒淇℃伅',
+ fieldName: 'errorInfo',
+ type: 'text',
+ hideDefaultActions: true,
+ initialWidth: 300,
+ wrapText: true
+ }
];
component.set('v.errorData', errorDatas);
component.set('v.errorColumns', errorColumns);
- component.set("v.showErrorInfo", true);
+ component.set('v.showErrorInfo', true);
component.set('v.login', false);
}
} else {
- console.log("Unknown error");
+ console.log('Unknown error');
component.set('v.login', false);
}
}
});
$A.enqueueAction(action);
-
},
//寮瑰嚭 鎴愬姛鎻愮ず
showSuccessToast01: function (component) {
$A.util.removeClass(component.find('successDiv01'), 'slds-hide');
- window.setTimeout($A.getCallback(function () {
- $A.util.addClass(component.find('successDiv01'), 'slds-hide');
- }),
+ window.setTimeout(
+ $A.getCallback(function () {
+ $A.util.addClass(component.find('successDiv01'), 'slds-hide');
+ }),
3000
);
},
//寮瑰嚭 閿欒鎻愮ず
showErrorToast: function (component) {
$A.util.removeClass(component.find('errorDiv'), 'slds-hide');
- window.setTimeout($A.getCallback(function () {
- $A.util.addClass(component.find('errorDiv'), 'slds-hide');
- }),
+ window.setTimeout(
+ $A.getCallback(function () {
+ $A.util.addClass(component.find('errorDiv'), 'slds-hide');
+ }),
7000
);
},
success: function (message) {
- var toastEvent = $A.get("e.force:showToast");
+ var toastEvent = $A.get('e.force:showToast');
toastEvent.setParams({
- "title": "鎴愬姛!",
- "message": message,
- "duration": "5000"
+ title: '鎴愬姛!',
+ message: message,
+ duration: '5000'
});
toastEvent.fire();
},
warning: function (message) {
- var toastEvent = $A.get("e.force:showToast");
+ var toastEvent = $A.get('e.force:showToast');
toastEvent.setParams({
- "title": "璀﹀憡!",
- "message": message,
- "duration": "10000"
+ title: '璀﹀憡!',
+ message: message,
+ duration: '10000'
});
toastEvent.fire();
},
error: function (message) {
- var toastEvent = $A.get("e.force:showToast");
+ var toastEvent = $A.get('e.force:showToast');
toastEvent.setParams({
- "title": "閿欒!",
- "message": message,
- "duration": "sticky"
+ title: '閿欒!',
+ message: message,
+ duration: 'sticky'
});
toastEvent.fire();
},
@@ -249,7 +305,7 @@
var datas = [];
let errorColumnsArray = [];
- for(var i in errorColumns){
+ for (var i in errorColumns) {
errorColumnsArray.push(errorColumns[i].label);
}
datas.push(errorColumnsArray);
@@ -257,22 +313,22 @@
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])
+ 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))
+ console.log('csv = ' + JSON.stringify(csv));
this.downloadCSV(component, csv);
},
convertToCSV: function (component, data) {
- console.log('enter convertToCSV')
+ console.log('enter convertToCSV');
console.log('data = ' + data);
var csv = '';
for (var i = 0; i < data.length; i++) {
@@ -282,7 +338,11 @@
var val = '';
val = row[j] === null ? '' : row[j].toString();
console.log('val = ' + val);
- if (val.indexOf(',') !== -1 || val.indexOf('"') !== -1 || val.indexOf('\n') !== -1) {
+ if (
+ val.indexOf(',') !== -1 ||
+ val.indexOf('"') !== -1 ||
+ val.indexOf('\n') !== -1
+ ) {
//val = '"' + val.replace(/"/g,'""') + '"';
}
if (j > 0) {
@@ -298,13 +358,14 @@
downloadCSV: function (component, csv) {
var link = document.createElement('a');
// 璁剧疆瀛楃闆嗗拰鏂囦欢澶�
- var bom = "\uFEFF";
- link.href = 'data:text/csv;charset=utf-8,' + encodeURIComponent(bom + csv);
+ var bom = '\uFEFF';
+ link.href =
+ 'data:text/csv;charset=utf-8,' + encodeURIComponent(bom + csv);
//link.href = URL.createObjectURL(csvFile);
link.download = 'data.csv';
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
- },
+ }
//zhj 瀵煎嚭閿欒淇℃伅 2023-05-16 end
-})
\ No newline at end of file
+});
--
Gitblit v1.9.1