backup0626

binxie

2023-06-26 b5c5eb130ca0848124f9d136af4be142ad5aac07

 force-app/main/default/lwc/lexInventory/lexInventory.js

@@ -1,193 +1,222 @@
import { LightningElement, wire, api, track } from 'lwc';
import oninit from '@salesforce/apex/LexInventoryController.init';
import { LightningElement, wire, api, track } from "lwc";
import oninit from "@salesforce/apex/LexInventoryController.init";
// import sheetjs from '@salesforce/resourceUrl/sheetjs';
import barcodeEntry from '@salesforce/apex/LexInventoryController.searchConsumableorderdetails';
import save from '@salesforce/apex/LexInventoryController.save';
import datainit from '@salesforce/apex/LexInventoryListController.init';
import { ShowToastEvent } from 'lightning/platformShowToastEvent';
import { NavigationMixin } from 'lightning/navigation';
import barcodeEntry from "@salesforce/apex/LexInventoryController.searchConsumableorderdetails";
import save from "@salesforce/apex/LexInventoryController.save";
import datainit from "@salesforce/apex/LexInventoryListController.init";
import { ShowToastEvent } from "lightning/platformShowToastEvent";
import { NavigationMixin } from "lightning/navigation";

//table css
import { loadStyle } from 'lightning/platformResourceLoader';
import WrappedHeaderTable from '@salesforce/resourceUrl/lexdatatable';
import { loadStyle } from "lightning/platformResourceLoader";
import WrappedHeaderTable from "@salesforce/resourceUrl/lexdatatable";

//库存盘点主页面数据
const columns = [
    {
        label: '是否盘点',
        fieldName: 'iscount',
      label: "是否盘点",
      fieldName: "iscount",
        hideDefaultActions: true,
        initialWidth: 80
      initialWidth: 80,
	
    },
    {
        label: '消耗品名称',
        fieldName: 'Name__c',
      label: "消耗品名称",
      fieldName: "Name__c",
        hideDefaultActions: true,
        // initialWidth: 400,
        wrapText: true
		
    },
    {
        label: '规格',
      label: "规格",
        initialWidth: 50,
        fieldName: 'Packing_list_manual__c',
        cellAttributes: { alignment: 'right' },
        hideDefaultActions: true
      fieldName: "Packing_list_manual__c",
      cellAttributes: { alignment: "right" },
      hideDefaultActions: true,
		
		
    },
    {
        label: '单位',
        fieldName: 'boxPiece',
      label: "单位",
      fieldName: "boxPiece",
        initialWidth: 50,
        hideDefaultActions: true
      hideDefaultActions: true,
	
		
    },
    {
        label: '有效期内库存',
        fieldName: 'limitCount',
      label: "有效期内库存",
      fieldName: "limitCount",
        initialWidth: 120,
        hideDefaultActions: true,
        cellAttributes: { alignment: 'right' }
      cellAttributes: { alignment: "right" },
    },

    {
        label: '过期库存',
      label: "过期库存",
        initialWidth: 100,
        fieldName: 'overlimitCount',
      fieldName: "overlimitCount",
        hideDefaultActions: true,
        cellAttributes: { alignment: 'right' }
      cellAttributes: { alignment: "right" },
		

    },
    {
        label: '盘点',
      label: "盘点",
        initialWidth: 50,
        fieldName: 'Pandian',
      fieldName: "Pandian",
        hideDefaultActions: true,
        cellAttributes: { alignment: 'right' }
      cellAttributes: { alignment: "right" },
	
		
    },
    {
        label: '丢失',
      label: "丢失",
        initialWidth: 50,
        fieldName: 'Diff',
      fieldName: "Diff",
        hideDefaultActions: true,
        cellAttributes: { alignment: 'right' }
      cellAttributes: { alignment: "right" },
		
		
    },
    {
        label: '寻回',
      label: "寻回",
        initialWidth: 50,
        fieldName: 'refind',
      fieldName: "refind",
        hideDefaultActions: true,
        cellAttributes: { alignment: 'right' }
      cellAttributes: { alignment: "right" },
	
	
    },
    {
        label: '差异原因',
      label: "差异原因",
        // fieldName: "DiffReason",
        initialWidth: 200,
        hideDefaultActions: true,
        type: 'customDiffReason',
      type: "customDiffReason",
        typeAttributes: {
            DiffReason: { fieldName: 'DiffReason' },
            ProdId: { fieldName: 'ProdId' },
            boxPiece: { fieldName: 'boxPiece' }
        }
    }
         DiffReason: { fieldName: "DiffReason" },
         ProdId: { fieldName: "ProdId" },
         boxPiece: { fieldName: "boxPiece" }

      },
	
   },
];

//调整明细
const column = [
    {
        label: '消耗品名称',
        fieldName: 'Name__c',
      label: "消耗品名称",
      fieldName: "Name__c",
        wrapText: true,
        hideDefaultActions: true
      hideDefaultActions: true,
        // initialWidth: 550
    },
    {
        label: '单位',
        fieldName: 'Box_Piece__c',
      label: "单位",
      fieldName: "Box_Piece__c",
        hideDefaultActions: true,
        initialWidth: 50
      initialWidth: 50,
	
    },
    {
        label: 'BarCode',
        fieldName: 'Bar_Code__c',
      label: "BarCode",
      fieldName: "Bar_Code__c",
        hideDefaultActions: true,
        wrapText: true
      wrapText: true,
        // initialWidth: 300,
    },
    {
        label: '调整原因',
        fieldName: 'DiffReason',
      label: "调整原因",
      fieldName: "DiffReason",
        hideDefaultActions: true,
        wrapText: true
      wrapText: true,
        // initialWidth:
    }
		
   },
];
//盘点明细
const dcolumns = [
    {
        label: '消耗品名称',
        fieldName: 'Name__c',
      label: "消耗品名称",
      fieldName: "Name__c",
        hideDefaultActions: true,
        // initialWidth: 250,
        wrapText: true
      wrapText: true,
	

    },
    {
        label: '库存',
        fieldName: 'Count_Sum__c',
      label: "库存",
      fieldName: "Count_Sum__c",
        hideDefaultActions: true,
        initialWidth: 100,
        cellAttributes: { alignment: 'right' }
      cellAttributes: { alignment: "right" },
	
    },
    {
        label: '盘点',
        fieldName: 'inventory_sum__c',
      label: "盘点",
      fieldName: "inventory_sum__c",
        hideDefaultActions: true,
        initialWidth: 100,
        cellAttributes: { alignment: 'right' }
      cellAttributes: { alignment: "right" },
	
    },
    {
        label: '丢失',
        fieldName: 'Diff__c',
      label: "丢失",
      fieldName: "Diff__c",
        hideDefaultActions: true,
        initialWidth: 100,
        cellAttributes: { alignment: 'right' }
      cellAttributes: { alignment: "right" },
	
    },
    {
        label: '寻回',
        fieldName: 'Product_Refind__c',
      label: "寻回",
      fieldName: "Product_Refind__c",
        hideDefaultActions: true,
        initialWidth: 100,
        cellAttributes: { alignment: 'right' }
      cellAttributes: { alignment: "right" },
		
    },
    {
        label: '差异原因',
        fieldName: 'Lose_reason__c',
        hideDefaultActions: true
    }
      label: "差异原因",
      fieldName: "Lose_reason__c",
      hideDefaultActions: true,
	
   },
];

//在库调整明细
const stockadjustcolumns = [
    {
        label: '消耗品名称',
        fieldName: 'Name__c',
      label: "消耗品名称",
      fieldName: "Name__c",
        wrapText: true,
        hideDefaultActions: true
    },
    {
        label: '产品型号',
        fieldName: 'Asset_Model_No__c',
        hideDefaultActions: true
    },
    {
        label: '差异原因',
        fieldName: 'Lose_reason__c',
        hideDefaultActions: true,
        initialWidth: 150
	
    },
    {
        label: '是否丢失',
        type: 'boolean',
        fieldName: 'Lose_Flag__c',
        hideDefaultActions: true
    }
      label: "产品型号",
      fieldName: "Asset_Model_No__c",
      hideDefaultActions: true,
	
   },
   {
      label: "差异原因",
      fieldName: "Lose_reason__c",
      hideDefaultActions: true,
      initialWidth: 150,
	
   },
   {
      label: "是否丢失",
      type: "boolean",
      fieldName: "Lose_Flag__c",
      hideDefaultActions: true,
		
   },
];

export default class LexInventory extends NavigationMixin(LightningElement) {
@@ -201,24 +230,24 @@
    @track accountName;
    @track agencyProType;
    @track userWorkLocation;
    @track accountid;
    @track pandiandetailsMap;
    @track reSet;
    @track reSet1;
   @track accountid
   @track pandiandetailsMap
   @track reSet
   @track reSet1

    @track showTable = false;
    @track showbutton = false;
    @track barcode = '';
   @track barcode = "";
    @track ConsumableorderdetailsRecordsview = [];
    @track consumableorderdetailsRecords = [];
    @track showcount = true;

    @track iSinventory = false;
   @track iSinventory = false
    @track numberDetail;
    @track hidecheckbox = true;
    //分页start
    @track sortBy = '';
    @track sortDirection = 'asc';
   @track sortBy = "";
   @track sortDirection = "asc";
    @track pageSize = 10;
    error;
    records;
@@ -234,6 +263,7 @@
    @track recordEnd = 0;
    //end


    //加载框
    // @track casesSpinner = true;
    @track showSpinner = true;
@@ -243,10 +273,10 @@
    //inventoryList
    @track isSummonsFlag;
    //展开栏
    activeSections = ['dataExpand'];
    columnHeader = ['消耗品名称', '单位', 'BarCode', '调整原因'];
   activeSections = ["dataExpand"];
   columnHeader = ["消耗品名称", "单位", "BarCode", "调整原因"];
    //确认一览
    @track eSetId = '';
   @track eSetId = "";
    @track EditAble = false;
    @track selectedData;
    @track conId;
@@ -254,13 +284,14 @@
    @track adjustdata = [];
    @track detalipan = [];


    //导出csv
    xlsDataHeader = ['消耗品名称', '单位', 'barCode', '调整原因'];

    //获取链接参数
    getQueryString(name) {
        console.log('getQueryString name ' + name);
        let reg = new RegExp('(^|&)' + name + '=([^&]*)(&|$)', 'i');
      console.log("getQueryString name " + name);
      let reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)", "i");
        let r = window.location.search.substr(1).match(reg);
        if (r != null) {
            return decodeURIComponent(r[2]);
@@ -271,23 +302,24 @@
        if (!this.stylesLoaded) {
            Promise.all([loadStyle(this, WrappedHeaderTable)])
                .then(() => {
                    console.log('Custom styles loaded');
                    console.log("Custom styles loaded");
                    this.stylesLoaded = true;
                })
                .catch((error) => {
                    console.error('Error loading custom styles');
                    console.error("Error loading custom styles");
                });
        }
    }


    connectedCallback() {
        console.log('===>初始化');
      console.log("===>初始化");

        //获取ESetid
        this.eSetId = this.getQueryString('eSetId');
        this.eSetId = this.eSetId == null ? '' : this.eSetId;
        console.log(' this.eSetId' + this.eSetId);
        if (this.eSetId == '') {
      this.eSetId = this.getQueryString("eSetId");
      this.eSetId = this.eSetId == null ? "" : this.eSetId;
      console.log(" this.eSetId" + this.eSetId);
      if (this.eSetId == "") {
            this.EditAble = false;
            this.init();
        } else {
@@ -295,41 +327,29 @@
            this.showcount = false;
            this.EditAble = true;
        }

    }
    init() {

        this.showSpinner = true;
        oninit()
            .then((result) => {
                console.log('1112' + JSON.stringify(result));
            console.log("1112" + JSON.stringify(result));
                result = JSON.parse(JSON.stringify(result));
                console.log('result.status = ' + result.status);
                console.log(
                    'ConsumableorderdetailsRecordsview= ' +
                        result.entity.ConsumableorderdetailsRecordsview
                );
                this.ConsumableorderdetailsRecordsview = JSON.parse(
                    result.entity.ConsumableorderdetailsRecordsview
                );
                this.consumableorderdetailsRecords =
                    result.entity.consumableorderdetailsRecords;
                console.log(
                    'consumableorderdetailsRecords= ' +
                        result.entity.consumableorderdetailsRecords
                );
                console.log(
                    '传参类型',
                    typeof this.consumableorderdetailsRecords
                );
                if (result.status == 'Success') {
            console.log("result.status = " + result.status);
            console.log("ConsumableorderdetailsRecordsview= " + result.entity.ConsumableorderdetailsRecordsview);
            this.ConsumableorderdetailsRecordsview = JSON.parse(result.entity.ConsumableorderdetailsRecordsview);
            this.consumableorderdetailsRecords = result.entity.consumableorderdetailsRecords;
            console.log("consumableorderdetailsRecords= " + result.entity.consumableorderdetailsRecords);
            console.log("传参类型", typeof this.consumableorderdetailsRecords);
            if (result.status == "Success") {
                    this.data = [];
                    this.data = this.ConsumableorderdetailsRecordsview[0];
                    console.log('this.data ==>' + JSON.stringify(this.data));
               console.log("this.data ==>" + JSON.stringify(this.data));
                    for (let i in this.data) {
                        this.data[i]['key'] =
                            this.data[i]['ProdId'] + this.data[i]['boxPiece'];
                        this.data[i]['Name__c'] = this.data[i].Prod.Name__c;
                        this.data[i]['Packing_list_manual__c'] =
                            this.data[i].Prod.Packing_list_manual__c;
                  this.data[i]["key"] = this.data[i]["ProdId"] + this.data[i]["boxPiece"];
                  this.data[i]["Name__c"] = this.data[i].Prod.Name__c;
                  this.data[i]["Packing_list_manual__c"] = this.data[i].Prod.Packing_list_manual__c;
                    }
                    this.accountName = result.entity.accountName;
                    this.agencyProType = result.entity.agencyProType;
@@ -343,11 +363,11 @@
                }
            })
            .catch((error) => {
                console.log('error = ' + JSON.stringify(error));
            console.log("error = " + JSON.stringify(error));
                this.showSpinner = false;
            });
        //默认展开栏
        this.activeSections = ['dataExpand'];
      this.activeSections = ["dataExpand"];
        this.showTable = false;
        this.showbutton = false;
    }
@@ -360,27 +380,19 @@
        this.showSpinner = true;

        //查询有哪些选择了的然后check
        const selectedRows = this.template
            .querySelector('c-lex-custom-lightning-datatable')
            .getSelectedRows();
      const selectedRows = this.template.querySelector('c-lex-custom-lightning-datatable').getSelectedRows();
        console.log('selectedRows========> ' + JSON.stringify(selectedRows));
        for (var i in this.data) {
            this.data[i]['check'] = false;
         this.data[i]["check"] = false;
        }
        for (var i in this.data) {
            for (var j in selectedRows) {
                if (
                    this.data[i].ProdId + this.data[i]['boxPiece'] ==
                    selectedRows[j].ProdId + selectedRows[j]['boxPiece']
                ) {
                    this.data[i]['check'] = true;
            if (this.data[i].ProdId+this.data[i]["boxPiece"] == selectedRows[j].ProdId+ selectedRows[j]["boxPiece"]) {
               this.data[i]["check"] = true;
                }
                // console.log('this.data[i].ProdId+this.data[i]["boxPiece"]'+this.data[i].ProdId+this.data[i]["boxPiece"]);
                console.log(
                    'selectedRows[j].ProdId+this.data[i]["boxPiece"]' +
                        selectedRows[j].ProdId +
                        selectedRows[j]['boxPiece']
                );
            console.log('selectedRows[j].ProdId+this.data[i]["boxPiece"]'+selectedRows[j].ProdId+selectedRows[j]["boxPiece"]);

            }
        }
        // if(this.barcode == ''||this.barcode == null){
@@ -400,151 +412,95 @@
            pageTokenLWC: this.currentPageToken,
            sortFieldLWC: this.sortBy,
            sortOrderLWC: this.sortDirection

        })
            .then((result) => {
                result = JSON.parse(JSON.stringify(result));
                console.log('result ===>' + JSON.stringify(result));
                if (result.status == 'Success1') {
            console.log("result ===>" + JSON.stringify(result));
            if (result.status == "Success1") {
                    //分页start
                    this.nextPageToken =
                        result.entity.paginatedAccounts.nextPageToken;
                    this.totalRecords =
                        result.entity.paginatedAccounts.totalRecords;
                    this.recordStart =
                        result.entity.paginatedAccounts.recordStart;
                  this.nextPageToken = result.entity.paginatedAccounts.nextPageToken;
                  this.totalRecords = result.entity.paginatedAccounts.totalRecords;
                  this.recordStart = result.entity.paginatedAccounts.recordStart;
                    this.recordEnd = result.entity.paginatedAccounts.recordEnd;
                    this.totalPages = Math.ceil(
                        result.entity.paginatedAccounts.totalRecords /
                            this.pageSize
                    );
                  this.totalPages = Math.ceil(result.entity.paginatedAccounts.totalRecords / this.pageSize);
                    console.log('this.totalPages = ' + this.totalPages);
                    this.paginationVisibility =
                        this.totalPages > 1 ? true : false;
                  this.paginationVisibility = this.totalPages > 1 ? true : false;
                    console.log('this.sortDirection = ' + this.sortDirection);
                    //分页end
                    this.codPageRecords = JSON.parse(
                        result.entity.codPageRecords
                    );
                  this.codPageRecords = JSON.parse(result.entity.codPageRecords);
                    for (var i in this.codPageRecords) {
                        this.codPageRecords[i]['Name__c'] =
                            this.codPageRecords[i].Prod.Name__c;
                        this.codPageRecords[i]['Box_Piece__c'] =
                            this.codPageRecords[i].orderdetails2.Box_Piece__c;
                        this.codPageRecords[i]['Bar_Code__c'] =
                            this.codPageRecords[i].orderdetails2.Bar_Code__c;
                     this.codPageRecords[i]["Name__c"] = this.codPageRecords[i].Prod.Name__c;
                     this.codPageRecords[i]["Box_Piece__c"] = this.codPageRecords[i].orderdetails2.Box_Piece__c;
                     this.codPageRecords[i]["Bar_Code__c"] = this.codPageRecords[i].orderdetails2.Bar_Code__c;
                    }
                    this.pageCodeRecords = result.entity.pageCodeRecords;
                    for (var i in this.pageCodeRecords) {
                        this.pageCodeRecords[i]['Name__c'] =
                            this.pageCodeRecords[i].Prod.Name__c;
                        this.pageCodeRecords[i]['Box_Piece__c'] =
                            this.pageCodeRecords[i].orderdetails2.Box_Piece__c;
                        this.pageCodeRecords[i]['Bar_Code__c'] =
                            this.pageCodeRecords[i].orderdetails2.Bar_Code__c;
                     this.pageCodeRecords[i]["Name__c"] = this.pageCodeRecords[i].Prod.Name__c;
                     this.pageCodeRecords[i]["Box_Piece__c"] = this.pageCodeRecords[i].orderdetails2.Box_Piece__c;
                     this.pageCodeRecords[i]["Bar_Code__c"] = this.pageCodeRecords[i].orderdetails2.Bar_Code__c;
                    }
                    this.data = JSON.parse(
                        result.entity.consumableorderdetailsRecords
                    );
                  this.data = JSON.parse(result.entity.consumableorderdetailsRecords);
                    for (var i in this.data) {
                        this.data[i]['key'] =
                            this.data[i]['ProdId'] + this.data[i]['boxPiece'];
                        this.data[i]['Name__c'] = this.data[i].Prod.Name__c;
                        this.data[i]['Packing_list_manual__c'] =
                            this.data[i].Prod.Packing_list_manual__c;
                        if (this.data[i]['check']) {
                            this.selectedRows.push(
                                this.data[i].ProdId + this.data[i]['boxPiece']
                            );
                            console.log('selectedRows:' + this.selectedRows);
                     this.data[i]["key"] = this.data[i]["ProdId"] + this.data[i]["boxPiece"];
                     this.data[i]["Name__c"] = this.data[i].Prod.Name__c;
                     this.data[i]["Packing_list_manual__c"] = this.data[i].Prod.Packing_list_manual__c;
                     if (this.data[i]["check"]) {
                        this.selectedRows.push(this.data[i].ProdId + this.data[i]["boxPiece"]);
                        console.log("selectedRows:" + this.selectedRows);
                        }
                    }
                    this.iSinventory = result.entity.iSinventory;
                    this.pandiandetailsMap = result.entity.pandiandetailsMap;
                    this.reSet = result.entity.reSet1;
                    console.log('iSinventory:' + this.iSinventory);
                  console.log("iSinventory:" + this.iSinventory);
                    this.showTable = true;
                    this.showbutton = true;
                    this.showSpinner = false;
                    console.log('result录入= ' + JSON.stringify(result));
                } else {
                    if (result.status == 'Sucess') {
                  console.log("result录入= " + JSON.stringify(result));
            }
            else {
               if (result.status == "Sucess") {
                        //分页start
                        this.nextPageToken =
                            result.entity.paginatedAccounts.nextPageToken;
                        this.totalRecords =
                            result.entity.paginatedAccounts.totalRecords;
                        this.recordStart =
                            result.entity.paginatedAccounts.recordStart;
                        this.recordEnd =
                            result.entity.paginatedAccounts.recordEnd;
                        this.totalPages = Math.ceil(
                            result.entity.paginatedAccounts.totalRecords /
                                this.pageSize
                        );
                  this.nextPageToken = result.entity.paginatedAccounts.nextPageToken;
                  this.totalRecords = result.entity.paginatedAccounts.totalRecords;
                  this.recordStart = result.entity.paginatedAccounts.recordStart;
                  this.recordEnd = result.entity.paginatedAccounts.recordEnd;
                  this.totalPages = Math.ceil(result.entity.paginatedAccounts.totalRecords / this.pageSize);
                        console.log('this.totalPages = ' + this.totalPages);
                        this.paginationVisibility =
                            this.totalPages > 1 ? true : false;
                        console.log(
                            'this.sortDirection = ' + this.sortDirection
                        );
                  this.paginationVisibility = this.totalPages > 1 ? true : false;
                  console.log('this.sortDirection = ' + this.sortDirection);
                        //分页end
                        this.codPageRecords = JSON.parse(
                            result.entity.codPageRecords
                        );
                  this.codPageRecords = JSON.parse(result.entity.codPageRecords);
                        for (var i in this.codPageRecords) {
                            this.codPageRecords[i]['Name__c'] =
                                this.codPageRecords[i].Prod.Name__c;
                            this.codPageRecords[i]['Box_Piece__c'] =
                                this.codPageRecords[
                                    i
                                ].orderdetails2.Box_Piece__c;
                            this.codPageRecords[i]['Bar_Code__c'] =
                                this.codPageRecords[
                                    i
                                ].orderdetails2.Bar_Code__c;
                     this.codPageRecords[i]["Name__c"] = this.codPageRecords[i].Prod.Name__c;
                     this.codPageRecords[i]["Box_Piece__c"] = this.codPageRecords[i].orderdetails2.Box_Piece__c;
                     this.codPageRecords[i]["Bar_Code__c"] = this.codPageRecords[i].orderdetails2.Bar_Code__c;
                        }
                        this.pageCodeRecords = result.entity.pageCodeRecords;
                        for (var i in this.pageCodeRecords) {
                            this.pageCodeRecords[i]['Name__c'] =
                                this.pageCodeRecords[i].Prod.Name__c;
                            this.pageCodeRecords[i]['Box_Piece__c'] =
                                this.pageCodeRecords[
                                    i
                                ].orderdetails2.Box_Piece__c;
                            this.pageCodeRecords[i]['Bar_Code__c'] =
                                this.pageCodeRecords[
                                    i
                                ].orderdetails2.Bar_Code__c;
                     this.pageCodeRecords[i]["Name__c"] = this.pageCodeRecords[i].Prod.Name__c;
                     this.pageCodeRecords[i]["Box_Piece__c"] = this.pageCodeRecords[i].orderdetails2.Box_Piece__c;
                     this.pageCodeRecords[i]["Bar_Code__c"] = this.pageCodeRecords[i].orderdetails2.Bar_Code__c;
                        }
                        this.data = JSON.parse(
                            result.entity.consumableorderdetailsRecords
                        );
                  this.data = JSON.parse(result.entity.consumableorderdetailsRecords);
                        for (var i in this.data) {
                            this.data[i]['key'] =
                                this.data[i]['ProdId'] +
                                this.data[i]['boxPiece'];
                            this.data[i]['Name__c'] = this.data[i].Prod.Name__c;
                            this.data[i]['Packing_list_manual__c'] =
                                this.data[i].Prod.Packing_list_manual__c;
                            if (this.data[i]['check']) {
                                this.selectedRows.push(
                                    this.data[i].ProdId +
                                        this.data[i]['boxPiece']
                                );
                                console.log(
                                    'selectedRows:' + this.selectedRows
                                );
                     this.data[i]["key"] = this.data[i]["ProdId"] + this.data[i]["boxPiece"];
                     this.data[i]["Name__c"] = this.data[i].Prod.Name__c;
                     this.data[i]["Packing_list_manual__c"] = this.data[i].Prod.Packing_list_manual__c;
                     if (this.data[i]["check"]) {
                        this.selectedRows.push(this.data[i].ProdId + this.data[i]["boxPiece"]);
                        console.log("selectedRows:" + this.selectedRows);
                            }
                        }
                        this.iSinventory = result.entity.iSinventory;
                        this.pandiandetailsMap =
                            result.entity.pandiandetailsMap;
                  this.pandiandetailsMap = result.entity.pandiandetailsMap;
                        this.reSet = result.entity.reSet;
                        console.log('iSinventory:' + this.iSinventory);
                  console.log("iSinventory:" + this.iSinventory);
                        this.showTable = true;
                        this.showbutton = true;
                        this.showSpinner = false;
                        console.log('result录入= ' + JSON.stringify(result));
                  console.log("result录入= " + JSON.stringify(result));
                    } else {
                        console.log('Error:' + result.msg);
                        this.showMyToast(result.msg, '', 'error');
@@ -554,13 +510,13 @@
                }
            })
            .catch((error) => {
                console.log('error = ' + JSON.stringify(error));
            console.log("error = " + JSON.stringify(error));
            });
    }
    //获取当前输入值
    handleChange(event) {
        let value = event.detail.value;
        console.log('value' + value);
      console.log("value" + value);
        this.barcode = value;
    }

@@ -569,14 +525,8 @@
        this.selectedRows = [];
        for (var i in this.data) {
            for (var j in selectedRowsEvent) {
                if (
                    this.data[i].ProdId + this.data[i]['boxPiece'] ==
                    selectedRowsEvent[j].ProdId +
                        selectedRowsEvent[j]['boxPiece']
                ) {
                    this.selectedRows.push(
                        selectedRowsEvent[j].ProdId + this.data[i]['boxPiece']
                    );
               if (this.data[i].ProdId+this.data[i]["boxPiece"] == selectedRowsEvent[j].ProdId+ selectedRowsEvent[j]["boxPiece"]) {
                  this.selectedRows.push(selectedRowsEvent[j].ProdId+this.data[i]["boxPiece"])
                }
            }
            // for (var i in selectedRowsEvent) {
@@ -599,12 +549,12 @@
        doc += '</style>';
        // Add all the Table Headers
        doc += '<tr>';
        this.columnHeader.forEach((element) => {
            doc += '<th style="font-weight: bold";>' + element + '</th>';
      this.columnHeader.forEach(element => {
         doc += '<th style="font-weight: bold";>' + element + '</th>'
        });
        doc += '</tr>';
        // Add the data rows
        this.codPageRecords.forEach((record) => {
      this.codPageRecords.forEach(record => {
            doc += '<tr>';
            doc += '<td>' + record.Name__c + '</td>';
            doc += '<td>' + record.Box_Piece__c + '</td>';
@@ -614,73 +564,54 @@
        });
        doc += '</table>';
        console.log('doc' + doc);
        var bom = '\uFEFF';
        // link.href = 'data:text/csv;charset=utf-8,' + encodeURIComponent(bom + csv);
        var element =
            'data:application/vnd.ms-excel,' + encodeURIComponent(bom + doc);
      var bom = "\uFEFF";
      var element = 'data:application/vnd.ms-excel,' + encodeURIComponent(bom + doc);
        let downloadElement = document.createElement('a');
        downloadElement.href = element;
        downloadElement.target = '_self';
        // 设置响应头禁用缓存
        // downloadElement.setAttribute('data-turbolinks-cache-control', 'no-cache');
        // downloadElement.setAttribute('data-turbolinks-track', 'reload');
        // use .csv as extension on below line if you want to export data as csv
        downloadElement.download = '在库调整一览.xls';
        document.body.appendChild(downloadElement);
        downloadElement.click();
    }


    //自定义dataType

    diffreasons(event) {
        const numberDetail = event.detail;
        // this.numberDetail = numberDetail;
        console.log('numberDetail' + JSON.stringify(numberDetail));
      console.log("numberDetail" + JSON.stringify(numberDetail));
        for (var i in this.data) {
            console.log('this.data[i]["key"]' + this.data[i]['key']);
            console.log(
                'numberDetail.data.ProdId+numberDetail.data.boxPiece' +
                    numberDetail.data.ProdId +
                    numberDetail.data.boxPiece
            );
         console.log('this.data[i]["key"]' + this.data[i]["key"]);
         console.log('numberDetail.data.ProdId+numberDetail.data.boxPiece' + numberDetail.data.ProdId + numberDetail.data.boxPiece);

            if (
                this.data[i]['key'] ==
                numberDetail.data.ProdId + numberDetail.data.boxPiece
            ) {
                this.data[i]['DiffReason'] = numberDetail.data.DiffReason;
         if (this.data[i]["key"] == numberDetail.data.ProdId + numberDetail.data.boxPiece) {
            this.data[i]["DiffReason"] = numberDetail.data.DiffReason;
            }
        }
        console.log(' this.data==>' + JSON.stringify(this.data));
      console.log(" this.data==>" + JSON.stringify(this.data));
    }

    saveConfirm() {
        console.log('进入盘点确认');
      console.log("进入盘点确认");
        console.log('reSet' + this.reSet);
        this.showSpinner = true;
        console.log('pandiandetailsMap' + this.pandiandetailsMap);
        //查询有哪些选择了的然后check
        const selectedRows = this.template
            .querySelector('c-lex-custom-lightning-datatable')
            .getSelectedRows();
      const selectedRows = this.template.querySelector('c-lex-custom-lightning-datatable').getSelectedRows();
        console.log('selectedRows========> ' + JSON.stringify(selectedRows));
        for (var i in this.data) {
            this.data[i]['check'] = false;
         this.data[i]["check"] = false;
        }
        for (var i in this.data) {
            for (var j in selectedRows) {
                if (
                    this.data[i].ProdId + this.data[i]['boxPiece'] ==
                    selectedRows[j].ProdId + selectedRows[j]['boxPiece']
                ) {
                    this.data[i]['check'] = true;
            if (this.data[i].ProdId+this.data[i]["boxPiece"] == selectedRows[j].ProdId+ selectedRows[j]["boxPiece"]) {
               this.data[i]["check"] = true;
                }
                // console.log('this.data[i].ProdId+this.data[i]["boxPiece"]'+this.data[i].ProdId+this.data[i]["boxPiece"]);
                console.log(
                    'selectedRows[j].ProdId+this.data[i]["boxPiece"]' +
                        selectedRows[j].ProdId +
                        selectedRows[j]['boxPiece']
                );
            console.log('selectedRows[j].ProdId+this.data[i]["boxPiece"]'+selectedRows[j].ProdId+selectedRows[j]["boxPiece"]);

            }
        }

@@ -702,19 +633,19 @@
        })
            .then((result) => {
                result = JSON.parse(JSON.stringify(result));
                console.log('result = ' + JSON.stringify(result));
                console.log('111111');
            console.log("result = " + JSON.stringify(result));
            console.log("111111");

                if (result.status == 'Success') {
                    let url = '/lexinventory?ESetid=' + result.entity.eSetId;
            if (result.status == "Success") {
               let url = "/lexinventory?ESetid=" + result.entity.eSetId;
                    this[NavigationMixin.Navigate]({
                        type: 'standard__webPage',
                  type: "standard__webPage",
                        attributes: {
                            url: url
                        }
                     url: url,
                  },
                    });
                    this.showSpinner = false;
                    console.log('Id' + this.eSetId);
               console.log("Id" + this.eSetId);
                    // this.EditAble = true;
                    // this.showcount = false;
                } else {
@@ -723,15 +654,15 @@
                }
            })
            .catch((error) => {
                console.log('error = ' + JSON.stringify(error));
            console.log("error = " + JSON.stringify(error));
                this.showSpinner = false;
            });
    }

    inits() {
        this.showSpinner = true;
      this.showSpinner = true
        datainit({
            eSetId: this.eSetId
         eSetId: this.eSetId,
        })
            .then((result) => {
                result = JSON.parse(JSON.stringify(result));
@@ -740,59 +671,45 @@
                for (var i in result.entity.qs) {
                    this.conId = result.entity.qs[i].Id;
                }
                console.log('this.conId' + typeof this.conId);
                this.detailData = JSON.parse(
                    result.entity.consumableorderdetailsRecords
                );
            console.log("this.conId" + typeof this.conId);
            this.detailData = JSON.parse(result.entity.consumableorderdetailsRecords);
                if (result.entity.ConsumableorderdetailsRecordsError != null) {
                    this.adjustdata = JSON.parse(
                        result.entity.ConsumableorderdetailsRecordsError
                    );
                    for (let i in this.detailData) {
                        this.detailData[i].Name__c =
                            this.detailData[i].Prod.Name__c;
                        this.detailData[i].Count_Sum__c =
                            this.detailData[i].orderdetails1.Count_Sum__c;
                        this.detailData[i].inventory_sum__c =
                            this.detailData[i].orderdetails1.inventory_sum__c;
                        this.detailData[i].Diff__c =
                            this.detailData[i].orderdetails1.Diff__c;
                        this.detailData[i].Product_Refind__c =
                            this.detailData[i].orderdetails1.Product_Refind__c;
                        this.detailData[i].Lose_reason__c =
                            this.detailData[i].orderdetails1.Lose_reason__c;
                  this.detailData[i].Name__c = this.detailData[i].Prod.Name__c;
                  this.detailData[i].Count_Sum__c = this.detailData[i].orderdetails1.Count_Sum__c;
                  this.detailData[i].inventory_sum__c = this.detailData[i].orderdetails1.inventory_sum__c;
                  this.detailData[i].Diff__c = this.detailData[i].orderdetails1.Diff__c;
                  this.detailData[i].Product_Refind__c = this.detailData[i].orderdetails1.Product_Refind__c;
                  this.detailData[i].Lose_reason__c = this.detailData[i].orderdetails1.Lose_reason__c;
                    }
                    for (let i in this.adjustdata) {
                        this.adjustdata[i].Name__c =
                            this.adjustdata[i].Prod.Name__c;
                        this.adjustdata[i].Asset_Model_No__c =
                            this.adjustdata[i].Prod.Asset_Model_No__c;
                        this.adjustdata[i].Lose_reason__c =
                            this.adjustdata[i].orderdetails2.Lose_reason__c;
                        this.adjustdata[i].Lose_Flag__c =
                            this.adjustdata[i].orderdetails2.Lose_Flag__c;
                  this.adjustdata[i].Name__c = this.adjustdata[i].Prod.Name__c;
                  this.adjustdata[i].Asset_Model_No__c = this.adjustdata[i].Prod.Asset_Model_No__c;
                  this.adjustdata[i].Lose_reason__c = this.adjustdata[i].orderdetails2.Lose_reason__c;
                  this.adjustdata[i].Lose_Flag__c = this.adjustdata[i].orderdetails2.Lose_Flag__c;
                    }
                }
                this.showSpinner = false;
                console.log('result盘点Id' + JSON.stringify(this.conId));
                console.log('调整明细' + JSON.stringify(this.adjustdata));
            console.log("result盘点Id" + JSON.stringify(this.conId));
            console.log("调整明细" + JSON.stringify(this.adjustdata));
            })
            .catch((error) => {
                console.log('error = ' + JSON.stringify(error));
            console.log("error = " + JSON.stringify(error));
                this.showSpinner = false;
            });
    }
    //分页
    handlePrevious() {
        this.currentPageToken =
            Number(this.currentPageToken) - Number(this.pageSize);
      this.currentPageToken = Number(this.currentPageToken) - Number(this.pageSize);
        this.barcodeEntrys();
    }

    handleNext() {
        console.log('111');
        this.currentPageToken =
            Number(this.currentPageToken) + Number(this.pageSize);
      this.currentPageToken = Number(this.currentPageToken) + Number(this.pageSize);
        this.barcodeEntrys();
    }
    handleFirst() {
@@ -801,8 +718,7 @@
    }

    handleLast() {
        this.currentPageToken =
            this.totalPages > 1 ? (this.totalPages - 1) * this.pageSize : 0;
      this.currentPageToken = this.totalPages > 1 ? (this.totalPages - 1) * this.pageSize : 0;
        this.barcodeEntrys();
    }

@@ -821,11 +737,10 @@
    }

    handleLoad2() {
        console.log('handleLoad2');
        console.log('handleLoad2')
        try {
            const style2 = document.createElement('style');
            style2.innerText =
                '.hehe-layoutItem  .slds-form-element__label {padding : 0px}';
            style2.innerText = '.hehe-layoutItem  .slds-form-element__label {padding : 0px}';
            this.template.querySelector('.hideHelpText').appendChild(style2);
        } catch (error) {
            console.log(error);
@@ -841,17 +756,10 @@
            iconName = 'utility:error';
        }
        if (message != '') {
            content =
                '<h2><strong>' +
                title +
                '<strong/></h2><h5>' +
                message +
                '</h5>';
           content = '<h2><strong>'+title+'<strong/></h2><h5>'+message+'</h5>';
        } else {
            content = '<h2><strong>' + title + '<strong/></h2>';
        }
        this.template
            .querySelector('c-common-toast')
            .showToast(variant, content, iconName, 10000);
        this.template.querySelector('c-common-toast').showToast(variant,content,iconName,10000);
    }
}