import { LightningElement,wire,track,api} from 'lwc';
|
import { CurrentPageReference } from "lightning/navigation";
|
import { CloseActionScreenEvent } from 'lightning/actions';
|
import { NavigationMixin } from 'lightning/navigation';
|
import { ShowToastEvent } from 'lightning/platformShowToastEvent';
|
|
import NAME_FIELD from '@salesforce/schema/Repair__c.Incharge_Staff__c';
|
import MY_CUSTOM_OBJECT from '@salesforce/schema/Repair__c';
|
|
import search from '@salesforce/apex/lexBatchSelectRepairLWCController.search';
|
import showPDF from '@salesforce/apex/lexBatchSelectRepairLWCController.showPDF';
|
|
/*
|
const actions = [
|
{ label: 'Show details', name: 'show_details' },
|
{ label: 'Delete', name: 'delete' },
|
];*/
|
|
const columns = [
|
{ label: '状态1', fieldName: 'Status1__c'},
|
{ label: '状态2', fieldName: 'Status2__c' },
|
{ label: 'RS修理单号', fieldName: 'Name' },
|
{ label: 'SAP修理单号', fieldName: 'SAP_Service_Repair_No__c' },
|
// { label: '型号', fieldName: 'deliveredProductName' },
|
{ label: '型号', fieldName: 'deliveredProductUrl',type:'url',
|
typeAttributes:{
|
label:{
|
fieldName:'deliveredProductName'
|
},
|
target:'_balank'
|
}
|
},
|
{ label: '机身编号', fieldName: 'SerialNumber__c' },
|
{ label: '医院名称', fieldName: 'HP_Name__c' },
|
{ label: '省份', fieldName: 'State_Hospital__c' },
|
// { label: '修理委托者', fieldName: 'Incharge_Staff_Name' },
|
{ label: '修理委托者', fieldName: 'inchargeStaffUrl',type:'url',
|
typeAttributes:{
|
label:{
|
fieldName:'inchargeStaffName'
|
},
|
target:'_balank'
|
}
|
},
|
{ label: 'FSE申请日期', fieldName: 'FSE_ApplyForRepair_Day__c' },
|
{ label: '维修中心', fieldName: 'work_location_select__c' },
|
{ label: '服务方式', fieldName: 'On_site_repair__c' },
|
{ label: '有无维修合同对象', fieldName: 'Number_of_EffectiveContract__c' },
|
{ label: '无偿区别标志', fieldName: 'NewProductGuaranteeObject__c' }
|
/* {
|
type: 'action',
|
typeAttributes: { rowActions: actions },
|
},*/
|
];
|
|
export default class lexBatchSelectRepairLWC extends LightningElement {
|
// Expose a field to make it available in the template
|
nameField = NAME_FIELD;
|
|
// Flexipage provides recordId and objectApiName
|
@api recordId;
|
@api objectApiName;
|
|
data = [];
|
columns = columns;
|
|
//状态1
|
status1Options = [{ label: '--无--', value: '' },
|
{ label: '0.申请完毕', value: '0.申请完毕' },
|
{ label: '2.维修报价阶段', value: '2.维修报价阶段' },
|
{ label: '3.维修阶段', value: '3.维修阶段' },
|
{ label: '4.修理品返送阶段', value: '4.修理品返送阶段' },
|
{ label: '5.完毕', value: '5.完毕' },
|
{ label: '0.删除', value: '0.删除' },
|
{ label: '0.取消', value: '0.取消' }];
|
//状态2
|
status2Options = [{label:'00.申请完毕', value:'00.申请完毕'},
|
{label:'01.分公司受理完毕', value:'01.分公司受理完毕'},
|
{label:'02.RC受理完毕', value:'02.RC受理完毕'},
|
{label:'03.报价检查结束', value:'03.报价检查结束'},
|
{label:'04.报价跟进中', value:'04.报价跟进中'},
|
{label:'05.报价同意完备', value:'05.报价同意完备'},
|
{label:'06.零件齐备', value:'06.零件齐备'},
|
{label:'07.修理開始', value:'07.修理開始'},
|
{label:'08.修理预计完成', value:'08.修理预计完成'},
|
{label:'09.修理完成', value:'09.修理完成'},
|
{label:'10.最终检查完成', value:'10.最终检查完成'},
|
{label:'11.RC修理品已返送', value:'11.RC修理品已返送'},
|
{label:'12.发票已发送', value:'12.发票已发送'},
|
{label:'13.已返送到用户', value:'13.已返送到用户'},
|
{label:'14.收到验收单', value:'14.收到验收单'},
|
{label:'15.验收单签收复核通过', value:'15.验收单签收复核通过'},
|
{label:'16.部分付款', value:'16.部分付款'},
|
{label:'16.完毕', value:'16.完毕'},
|
{label:'17.付款完毕', value:'17.付款完毕'},
|
{label:'00.取消', value:'00.取消'},
|
{label:'00.删除', value:'00.删除'},
|
{label:'00.关闭', value:'00.关闭'}];
|
//服务方式
|
siteRepairItems = [{label:'--无--',value:''},
|
{label:'RC修理',value:'RC修理'},
|
{label:'直送SORC修理',value:'直送SORC修理'},
|
{label:'直送OGZ修理',value:'直送OGZ修理'},
|
{label:'办事处修理',value:'办事处修理'},
|
{label:'现场修理',value:'现场修理'}];
|
|
searchObj = {};
|
repair = {};
|
selectedRepairs;
|
|
/* @wire(CurrentPageReference)
|
getStateParameters(currentPageReference) {
|
console.log(111);
|
console.log(currentPageReference);
|
|
if (currentPageReference) {
|
const urlValue = currentPageReference.state.recordId;
|
if (urlValue) {
|
let str = `${urlValue}`;
|
console.log("str");
|
console.log(str);
|
this.recordId = str;
|
}
|
}
|
}*/
|
|
connectedCallback(){
|
// console.log(this.recordId);
|
}
|
//状态1
|
handleStatus1Change(event){
|
/*console.log(event);
|
console.log(event.detail);*/
|
this.searchObj.Status1 = event.detail.value;
|
// console.log(JSON.stringify(this.searchObj));
|
}
|
//状态2
|
handleStatus2Change(event){
|
this.searchObj.Status2 = event.detail.value;
|
// console.log(this.searchObj);
|
}
|
//服务方式
|
handleSiteChange(event){
|
this.searchObj.onSiteRepair = event.detail.value;
|
// console.log(this.searchObj);
|
}
|
//RS修理单号 RepairName
|
handleRepairNameChange(event){
|
this.searchObj.RepairName = event.detail.value;
|
// console.log(this.searchObj);
|
}
|
//SAP修理单号 SAPRepairNo
|
handleSAPRepairNoChange(event){
|
this.searchObj.SAPRepairNo = event.detail.value;
|
// console.log(this.searchObj);
|
}
|
//维修中心 workLocationSelect
|
handleWorkLocationChange(event){
|
this.searchObj.workLocationSelect = event.detail.value;
|
}
|
//机身编码 SerialNumber
|
handleSerialNumberChange(event){
|
this.searchObj.SerialNumber = event.detail.value;
|
}
|
// 省份 State_Hospital
|
handleStateHospitalChange(event){
|
this.searchObj.State_Hospital = event.detail.value;
|
}
|
//医院名称 HospitalName
|
handleHospitalChange(event){
|
this.searchObj.HospitalName = event.detail.value;
|
}
|
//FSE申请日 repair.Aware_date__c
|
handleAwareDateDStart(event){
|
this.repair.Aware_date__c = event.detail.value;
|
console.log(this.repair.Aware_date__c);
|
}
|
// repair.Aware_date2__c
|
handleAwareDateDEnd(event){
|
this.repair.Aware_date2__c = event.detail.value;
|
// console.log(this.repair.Aware_date2__c);
|
}
|
// 修理委托者 repair.Incharge_Staff__c
|
handleInchargeStaffChange(event){
|
this.repair.Incharge_Staff__c = event.detail.value;
|
// console.log(this.repair.Aware_date2__c);
|
}
|
|
//检索
|
searchRepair(event) {
|
console.log(this.repair.Aware_date__c);
|
if (JSON.stringify(this.repair) != "{}") {
|
console.log('this.repair');
|
this.searchObj.repair = this.repair;
|
// fse 时间条件
|
/*if (!(this.repair.Aware_date__c != null && this.repair.Aware_date2__c != null) || this.repair.Aware_date__c > this.repair.Aware_date2__c) {
|
const event = new ShowToastEvent({
|
title: 'error',
|
message: 'FSE申请日输入有误',
|
variant:'error',
|
});
|
this.dispatchEvent(event);
|
return;
|
}*/
|
}
|
let jsonStr = JSON.stringify(this.searchObj);
|
if (jsonStr === "{}") {
|
const event = new ShowToastEvent({
|
title: 'error',
|
message: '请至少添加一个检索条件!',
|
variant:'error',
|
});
|
this.dispatchEvent(event);
|
}else{
|
console.log(jsonStr);
|
search({
|
json: jsonStr
|
}).then(result => {
|
console.log(result.repairData);
|
console.log('length:'+result.repairData.length);
|
if (result.repairData.length == 0 || result.repairData.length == 200) {
|
const event = new ShowToastEvent({
|
title: 'warning',
|
message: result.status,
|
variant:'warning',
|
});
|
this.dispatchEvent(event);
|
}
|
let returnArr = [];
|
result.repairData.forEach(function(v){
|
let objRepair = v.repair;
|
//添加修理委托者和型号名称
|
objRepair.deliveredProductName = objRepair.Delivered_Product__r.Name;
|
objRepair.deliveredProductUrl = "/"+objRepair.Delivered_Product__c;
|
objRepair.inchargeStaffName = objRepair.Incharge_Staff__r.Name;
|
objRepair.inchargeStaffUrl = "/"+objRepair.Incharge_Staff__c;
|
// console.log(objRepair);
|
returnArr.push(objRepair);
|
});
|
/*console.log('arr');
|
console.log(arr);
|
console.log(arr.length);*/
|
this.data = returnArr;
|
// console.log(this.data);
|
}).catch(error => {
|
console.log("error");
|
console.log(error);
|
}).finally(() => {
|
|
});
|
}
|
|
|
}
|
//导出为Excel 画table
|
exportContactData(){
|
// Prepare a html table
|
let doc = '<table>';
|
// Add styles for the table
|
doc += '<style>';
|
doc += 'table, th, td {';
|
doc += ' border: 1px solid black;';
|
doc += ' border-collapse: collapse;';
|
doc += '}';
|
doc += '</style>';
|
// Add all the Table Headers
|
doc += '<tr>';
|
this.columns.forEach(element => {
|
doc += '<th>'+ element.label +'</th>'
|
});
|
doc += '</tr>';
|
// Add the data rows
|
let fieldNameArr =[];
|
this.columns.forEach(function(v){
|
if (v['typeAttributes']) {
|
fieldNameArr.push(v['typeAttributes'].label.fieldName);
|
}else{
|
fieldNameArr.push(v.fieldName);
|
}
|
});
|
console.log(fieldNameArr);
|
fieldNameArr.forEach(v=>{
|
console.log(v);
|
// console.log(this.data[0].v);
|
})
|
this.data.forEach(record => {
|
doc += '<tr>';
|
if (record.Status1__c != null) {
|
doc += '<th>'+record.Status1__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.Status2__c != null) {
|
doc += '<th>'+record.Status2__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.Name != null) {
|
doc += '<th>'+record.Name+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.SAP_Service_Repair_No__c != null) {
|
doc += '<th>'+record.SAP_Service_Repair_No__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.deliveredProductName != null) {
|
doc += '<th>'+record.deliveredProductName+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.SerialNumber__c != null) {
|
doc += '<th>'+record.SerialNumber__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.HP_Name__c != null) {
|
doc += '<th>'+record.HP_Name__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.State_Hospital__c != null) {
|
doc += '<th>'+record.State_Hospital__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.inchargeStaffName != null) {
|
doc += '<th>'+record.inchargeStaffName+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.FSE_ApplyForRepair_Day__c != null) {
|
doc += '<th>'+record.FSE_ApplyForRepair_Day__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.work_location_select__c != null) {
|
doc += '<th>'+record.work_location_select__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.On_site_repair__c != null) {
|
doc += '<th>'+record.On_site_repair__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.Number_of_EffectiveContract__c != null) {
|
doc += '<th>'+record.Number_of_EffectiveContract__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
if (record.NewProductGuaranteeObject__c != null) {
|
doc += '<th>'+record.NewProductGuaranteeObject__c+'</th>';
|
}else{
|
doc += '<th></th>'
|
}
|
// fieldNameArr.forEach(fieldName =>{
|
// doc += '<th>'+record.fieldName+'</th>';
|
// });
|
doc += '</tr>';
|
});
|
doc += '</table>';
|
var element = 'data:application/vnd.ms-excel,' + encodeURIComponent(doc);
|
let downloadElement = document.createElement('a');
|
downloadElement.href = element;
|
downloadElement.target = '_self';
|
// use .csv as extension on below line if you want to export data as csv
|
downloadElement.download = '修理明细表.xls';
|
document.body.appendChild(downloadElement);
|
downloadElement.click();
|
}
|
|
// this method validates the data and creates the csv file to download this.data的所有字段
|
downloadCSVFile1() {
|
console.log("downloadCSVFile1");
|
let rowEnd = '\n';
|
let csvString = '';
|
// this set elminates the duplicates if have any duplicate keys
|
let rowData = new Set();
|
let columnsData = new Set();
|
let columnsLabelData = new Set();
|
|
// getting keys from data
|
this.data.forEach(function (record) {
|
Object.keys(record).forEach(function (key) {
|
rowData.add(key);
|
});
|
});
|
console.log(rowData);
|
|
// Array.from() method returns an Array object from any object with a length property or an iterable object.
|
rowData = Array.from(rowData);
|
console.log(rowData);
|
|
// splitting using ','
|
csvString += rowData.join(',');
|
csvString += rowEnd;
|
console.log(csvString);
|
this.columns.forEach(function(v){
|
columnsLabelData.add(v.label);
|
if (v['typeAttributes']) {
|
columnsData.add(v['typeAttributes'].label.fieldName);
|
}else{
|
columnsData.add(v.fieldName);
|
}
|
});
|
console.log("columnsData");
|
console.log(columnsLabelData);
|
console.log(columnsData);
|
console.log(rowData[1]);
|
console.log(Array.from(columnsData));
|
console.log(Array.from(columnsData).hasOwnProperty(rowData[1]));
|
console.log(this.data[0].Name);
|
console.log(this.data[0][rowData[1]]);
|
// main for loop to get the data based on key value
|
for(let i=0; i < this.data.length; i++){
|
let colValue = 0;
|
|
// validating keys in data
|
for(let key in rowData) {
|
if(rowData.hasOwnProperty(key)) {
|
// Key value
|
// Ex: Id, Name
|
let rowKey = rowData[key];
|
// add , after every value except the first.
|
if(colValue > 0){
|
csvString += ',';
|
}
|
// If the column is undefined, it as blank in the CSV file.
|
let value = this.data[i][rowKey] === undefined ? '' : this.data[i][rowKey];
|
csvString += '"'+ value +'"';
|
colValue++;
|
}
|
}
|
csvString += rowEnd;
|
}
|
|
// Creating anchor element to download
|
let downloadElement = document.createElement('a');
|
|
// This encodeURI encodes special characters, except: , / ? : @ & = + $ # (Use encodeURIComponent() to encode these characters).
|
downloadElement.href = 'data:text/csv;charset=utf-8,' + encodeURI(csvString);
|
downloadElement.target = '_self';
|
// CSV File Name
|
downloadElement.download = 'Account Data.csv';
|
// below statement is required if you are using firefox browser
|
document.body.appendChild(downloadElement);
|
// click() Javascript function to download CSV file
|
downloadElement.click();
|
}
|
//导出为Excel
|
downloadCSVFile() {
|
console.log("downloadCSVFile");
|
let rowEnd = '\n';
|
let csvString = '';
|
// this set elminates the duplicates if have any duplicate keys
|
//表格标题
|
let columnsData = new Set();
|
//表格字段
|
let rowData = new Set();
|
|
// getting keys from data
|
this.columns.forEach(function(v){
|
columnsData.add(v.label);
|
if (v['typeAttributes']) {
|
rowData.add(v['typeAttributes'].label.fieldName);
|
}else{
|
rowData.add(v.fieldName);
|
}
|
});
|
console.log(columnsData);
|
console.log(rowData);
|
// Array.from() method returns an Array object from any object with a length property or an iterable object.
|
rowData = Array.from(rowData);
|
columnsData = Array.from(columnsData);
|
// getting keys from data
|
/* console.log("rowData");
|
rowData.forEach(function(v){
|
console.log(v);
|
});
|
console.log("columnsData");
|
columnsData.forEach(function(v){
|
console.log(v);
|
}); */
|
|
// splitting using ','
|
csvString += columnsData.join(',');
|
csvString += rowEnd;
|
// console.log(csvString);
|
// main for loop to get the data based on key value
|
for(let i=0; i < this.data.length; i++){
|
let colValue = 0;
|
|
// validating keys in data
|
for(let key in rowData) {
|
if(rowData.hasOwnProperty(key)) {//del
|
// Key value
|
// Ex: Id, Name
|
let rowKey = rowData[key];
|
// add , after every value except the first.
|
if(colValue > 0){
|
csvString += ',';
|
}
|
// If the column is undefined, it as blank in the CSV file.
|
let value = this.data[i][rowKey] === undefined ? '' : this.data[i][rowKey];
|
csvString += '"'+ value +'"';
|
colValue++;
|
}
|
}
|
csvString += rowEnd;
|
}
|
|
// Creating anchor element to download
|
let downloadElement = document.createElement('a');
|
|
// This encodeURI encodes special characters, except: , / ? : @ & = + $ # (Use encodeURIComponent() to encode these characters).
|
downloadElement.href = 'data:text/csv;charset=utf-8,' + encodeURI(csvString);
|
downloadElement.target = '_self';
|
// CSV File Name
|
downloadElement.download = '修理明细表.csv';
|
// below statement is required if you are using firefox browser
|
document.body.appendChild(downloadElement);
|
// click() Javascript function to download CSV file
|
downloadElement.click();
|
}
|
//获取选中Repair
|
getSelectedRows(event) {
|
const selectedRows = event.detail.selectedRows;
|
console.log(selectedRows);
|
//Repair__c selectedRepairs
|
// Display that fieldName of the selected rows
|
let selectedRepairsArr = [];
|
for (let i = 0; i < selectedRows.length; i++) {
|
selectedRepairsArr.push(selectedRows[i]);
|
}
|
this.selectedRepairs = selectedRepairsArr;
|
}
|
|
//跳转到pdf页面
|
skipPage() {
|
console.log("selectedRows");
|
// console.log(jsonStr);
|
if (this.selectedRepairs.length <= 0 ) {
|
const event = new ShowToastEvent({
|
title: 'error',
|
message: '请至少选择一个修理',
|
variant:'error',
|
});
|
this.dispatchEvent(event);
|
return;
|
}
|
let jsonStr = JSON.stringify(this.selectedRepairs);
|
showPDF({
|
json: jsonStr
|
}).then(result => {
|
console.log(result);
|
if (result.indexOf("https://ocsm") != -1) {
|
window.open(result, "维修委托书PDF", "");
|
}else{
|
const event = new ShowToastEvent({
|
title: 'error',
|
message: result,
|
variant:'error',
|
});
|
this.dispatchEvent(event);
|
}
|
}).catch(error => {
|
console.log("error");
|
console.log(error);
|
}).finally(() => {
|
|
});
|
}
|
|
}
|
