import { LightningElement,api, track } from 'lwc';
|
import { loadScript } from 'lightning/platformResourceLoader';
|
import sheet from '@salesforce/resourceUrl/sheet';
|
import {ShowToastEvent} from 'lightning/platformShowToastEvent';
|
import importSpecialPrice from '@salesforce/apex/ImportdataController.importSpecialPrice';
|
import submitApproval from '@salesforce/apex/ImportdataController.submitApproval';
|
const columns = [
|
{
|
label: '追溯特价申请',
|
fieldName: 'name',
|
type: 'text'
|
},
|
{
|
label: '合同名称',
|
fieldName: 'accountName',
|
type: 'text'
|
},
|
{
|
label: '状态',
|
fieldName: 'status',
|
type: 'text'
|
},
|
{
|
label: '特价类型',
|
fieldName: 'type',
|
type: 'text'
|
}
|
];
|
|
export default class LexImportSpecialPrice extends LightningElement {
|
@track wrapperList;
|
@track columns = columns;
|
@track showLoadingSpinner = false;
|
connectedCallback(){
|
//导入xlsx文件
|
Promise.all([
|
loadScript(this, sheet),
|
]).then(() => {
|
console.log('导入xlsx成功')
|
})
|
.catch(() => {
|
console.log('导入xlsx失败')
|
});
|
}
|
|
|
analyseExcelToJson(e){
|
this.showLoadingSpinner = true;
|
let file = this.template.querySelector('.fileUpload').files[0];
|
return new Promise((resolve, reject) => {
|
if (file instanceof File) {
|
const reader = new FileReader();
|
reader.onloadend = (progressEvent) => {
|
const arrayBuffer = reader.result;
|
// const options = { type: 'array binary' };
|
const options = { type: 'array' };
|
const workbook = XLSX.read(arrayBuffer, options);
|
const sheetNames = workbook.SheetNames;
|
const result = sheetNames.map((sheetName) => workbook.Sheets[sheetName]);
|
console.log('result',result)
|
let data=[];
|
for(const sheet in workbook.Sheets){
|
if(workbook.Sheets.hasOwnProperty(sheet)){
|
data.push(
|
XLSX.utils.sheet_to_json(workbook.Sheets[sheet])
|
)
|
}
|
}
|
resolve(data);
|
console.log(data);
|
this.importData(data[0]);
|
};
|
e.target.value='';
|
reader.readAsArrayBuffer(file);
|
} else {
|
reject(new Error('入参不是 File 类型'));
|
this.showLoadingSpinner = false;
|
}
|
});
|
}
|
|
async importData(data){
|
|
const result = await importSpecialPrice({dataStr:JSON.stringify(data)});
|
this.showLoadingSpinner = false;
|
if(result.msg == 'Success'){
|
this.wrapperList = result.data;
|
}else{
|
this.dispatchEvent(
|
new ShowToastEvent({
|
title: 'Error',
|
message: result.msg,
|
variant: 'error'
|
})
|
);
|
}
|
}
|
|
async massSubmit(event){
|
this.showLoadingSpinner = true;
|
console.log('test');
|
var el = this.template.querySelector('lightning-datatable');
|
var selectedrows = el.getSelectedRows();
|
console.log(selectedrows);
|
var processrows = [];
|
for (var i = 0; i < selectedrows.length; i++) {
|
// selectedrows[i].comments=this.comments;
|
processrows.push(selectedrows[i]);
|
}
|
console.log(111);
|
console.log(processrows)
|
const result = await submitApproval(processrows);
|
console.log(result)
|
if(result == 'Success'){
|
this.dispatchEvent(
|
new ShowToastEvent({
|
title: 'Success',
|
message:'提交成功',
|
variant: 'success'
|
})
|
);
|
}else{
|
this.dispatchEvent(
|
new ShowToastEvent({
|
title: 'Error',
|
message: result,
|
variant: 'error'
|
})
|
);
|
}
|
this.showLoadingSpinner = false;
|
}
|
|
|
|
}
|
