buli
2023-07-11 80a3f59e2d3df07805bc67e329300b8de90a5b3a
force-app/main/default/lwc/lexinventoryViewLWC/lexinventoryViewLWC.js
@@ -1,18 +1,19 @@
import { LightningElement, wire, api, track } from 'lwc';
import oninit from "@salesforce/apex/LexInventoryViewController.init";
import { ShowToastEvent } from "lightning/platformShowToastEvent";
import searchOrder from "@salesforce/apex/LexInventoryViewController.searchConsumableorderdetails";
import categoryAllload from "@salesforce/apex/LexInventoryViewController.categoryAllload";
import { NavigationMixin } from "lightning/navigation";
import oninit from '@salesforce/apex/LexInventoryViewController.init';
import { ShowToastEvent } from 'lightning/platformShowToastEvent';
import searchOrder from '@salesforce/apex/LexInventoryViewController.searchConsumableorderdetails';
import categoryAllload from '@salesforce/apex/LexInventoryViewController.categoryAllload';
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';
export default class LexinventoryViewLWC extends NavigationMixin(LightningElement) {
export default class LexinventoryViewLWC extends NavigationMixin(
    LightningElement
) {
   //分页start
   @track sortBy = "";
    @track sortBy = '';
   //@track sortDirection = "asc";
   @track pageSize = 10;
   error;
@@ -30,7 +31,7 @@
   //end
   @track data = [];
   @track message = "";
    @track message = '';
   @track Name;
   @track CategoryThree;
@@ -43,10 +44,11 @@
   @track accountName;
   @track agencyProType;
   @track userWorkLocation;
   @track value = "";
    @track value = '';
   @track showTable = false;
   @track hidecheckboxcolumn = true;
   @track check = false;
    @track productkucun;
   //加载
   @track showSpinner = false;
   @track showSpinners = false;
@@ -55,137 +57,132 @@
   //表头样式
   stylesLoaded = false;
   @track columns = [
      {
         label: "消耗品名称",
         fieldName: "Name__c",
         type: "Name",
            label: '消耗品名称',
            fieldName: 'Name__c',
            type: 'Name',
         sortable: true,
         hideDefaultActions: true,
         // initialWidth: 300,
            // initialWidth: 200,
         wrapText: true,
         cellAttributes: { alignment: "left" }
            cellAttributes: { alignment: 'left' }
      },
      {
         label: "第三分类",
         fieldName: "Category3__c",
         initialWidth: 90,
         cellAttributes: { alignment: "left" },
            label: '第三分类',
            fieldName: 'Category3__c',
            initialWidth: 102,
            cellAttributes: { alignment: 'left' },
         hideDefaultActions: true,
         sortable: true,
         wrapText: true,
            wrapText: true
      },
      {
         label: "第四分类",
         fieldName: "Category4__c",
         cellAttributes: { alignment: "left" },
         initialWidth: 90,
            label: '第四分类',
            fieldName: 'Category4__c',
            cellAttributes: { alignment: 'left' },
            initialWidth: 102,
         hideDefaultActions: true,
         wrapText: true,
         sortable: true,
            sortable: true
      },
      {
         label: "第五分类",
         fieldName: "Category5__c",
         cellAttributes: { alignment: "left" },
         initialWidth: 90,
            label: '第五分类',
            fieldName: 'Category5__c',
            cellAttributes: { alignment: 'left' },
            initialWidth: 102,
         hideDefaultActions: true,
         wrapText: true,
         sortable: true,
            sortable: true
      },
   
      {
         label: "规格",
         fieldName: "packing_list",
         cellAttributes: { alignment: "right" },
         initialWidth: 55,
            label: '规格',
            fieldName: 'packing_list',
            cellAttributes: { alignment: 'right' },
            initialWidth: 50,
         wrapText: true,
         hideDefaultActions: true,
            hideDefaultActions: true
      },
      {
         label: "单位",
         fieldName: "BoxPiece",
         cellAttributes: { alignment: "left" },
         initialWidth: 55,
            label: '单位',
            fieldName: 'BoxPiece',
            cellAttributes: { alignment: 'left' },
            initialWidth: 50,
         wrapText: true,
         hideDefaultActions: true,
            hideDefaultActions: true
      },
      {
         label: "注册证编码号",
         fieldName: "approbation_No",
         cellAttributes: { alignment: "left" },
            label: '注册证编码号',
            fieldName: 'approbation_No',
            cellAttributes: { alignment: 'left' },
         wrapText: true,
         initialWidth: 155,
         hideDefaultActions: true,
            initialWidth: 104,
            hideDefaultActions: true
      },
      {
         label: "注册有效期",
         fieldName: "expiration_Date",
         cellAttributes: { alignment: "left" },
            label: '注册有效期',
            fieldName: 'expiration_Date',
            cellAttributes: { alignment: 'left' },
         wrapText: true,
         hideDefaultActions: true,
         initialWidth: 100
            initialWidth: 95
      },
      {
         label: "CFDA状态",
         fieldName: "SFDA_Status__c",
         cellAttributes: { alignment: "left" },
         initialWidth: 95,
            label: 'CFDA状态',
            fieldName: 'SFDA_Status__c',
            cellAttributes: { alignment: 'left' },
            initialWidth: 84,
         wrapText: true,
         hideDefaultActions: true,
            hideDefaultActions: true
      },
      {
         label: "使用期限",
         fieldName: "guaranteeperiod",
         cellAttributes: { alignment: "left" },
            label: '使用期限',
            fieldName: 'guaranteeperiod',
            cellAttributes: { alignment: 'left' },
         hideDefaultActions: true,
         initialWidth: 105
            initialWidth: 95
      },
      {
         label:'有效期内库存',
         type: "customInventoryColor",
         // sortable: true,
         cellAttributes: {alignment: "right" },
            type: 'customInventoryColor',
            fieldName: 'limitCount',
            sortable: true,
            cellAttributes: { alignment: 'right' },
         typeAttributes: {
         value: { fieldName:"limitCount"},
         upperlimit: { fieldName: "upperlimit" },
         lowerlimit: { fieldName: "lowerlimit" },
         boxPrice:{ fieldName: "BoxPiece" },
                value: { fieldName: 'limitCount' },
                upperlimit: { fieldName: 'upperlimit' },
                lowerlimit: { fieldName: 'lowerlimit' },
                boxPrice: { fieldName: 'BoxPiece' }
         },
         hideDefaultActions: true,
         initialWidth:150
            initialWidth: 110
      },
      {
         label: "过期库存",
         fieldName: "overlimitCount",
            label: '过期库存',
            fieldName: 'overlimitCount',
         hideDefaultActions: true,
         cellAttributes: { alignment: "right" },
         initialWidth:80
            cellAttributes: { alignment: 'right' },
            initialWidth: 78
      }
   ];
   defaultSortDirection = "asc";
   sortDirection = "asc";
    defaultSortDirection = 'asc';
    sortDirection = 'asc';
   sortedBy;
   
    renderedCallback() {
        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() {
      this.loader = true;
@@ -199,36 +196,59 @@
         pageTokenLWC: this.currentPageToken,
         sortFieldLWC: this.sortBy,
         sortOrderLWC: this.sortDirection
      }).then((result) => {
        })
            .then((result) => {
         result = JSON.parse(JSON.stringify(result));
         console.log("result.pageRecords = " + JSON.stringify(result.entity.pageRecords));
         console.log("result.consumableorderdetailsRecords = " + JSON.stringify(result.entity.consumableorderdetailsRecords));
         console.log("result.status = " + result.status);
         console.log("result = " + JSON.stringify(result));
         console.log("result 1= " + JSON.stringify(result.entity));
         console.log("result 2= " + JSON.stringify(result.entity.pageRecords));
         console.log("result.entity.categoryOptionMap 2= " + JSON.stringify(result.entity.categoryOptionMap));
         console.log("result.entity.categoryOptionMap 2= " + JSON.stringify(result.entity.category4OptionMap));
         console.log("result.entity.categoryOptionMap 2= " + JSON.stringify(result.entity.category5OptionMap));
         if (result.status == "Success") {
            console.log('result.entity.paginatedAccounts = ' + JSON.stringify(result.entity.paginatedAccounts));
            this.nextPageToken = result.entity.paginatedAccounts.nextPageToken;
            this.totalRecords = result.entity.paginatedAccounts.totalRecords;
            this.recordStart = result.entity.paginatedAccounts.recordStart;
                console.log(
                    'result.pageRecords = ' +
                        JSON.stringify(result.entity.pageRecords)
                );
                console.log(
                    'result.consumableorderdetailsRecords = ' +
                        JSON.stringify(
                            result.entity.consumableorderdetailsRecords
                        )
                );
                console.log('result.status = ' + result.status);
                console.log('result = ' + JSON.stringify(result));
                console.log('result 1= ' + JSON.stringify(result.entity));
                console.log(
                    'result 2= ' + JSON.stringify(result.entity.pageRecords)
                );
                if (result.status == 'Success') {
                    console.log(
                        'result.entity.paginatedAccounts = ' +
                            JSON.stringify(result.entity.paginatedAccounts)
                    );
                    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;
            this.loader = false;
            this.data = result.entity.pageRecords;
                    this.productkucun = result.entity.productkucun;
            for (var i in this.data) {
               this.data[i]["Name__c"] = this.data[i].Prod.Name__c;
               this.data[i]["Category3__c"] = this.data[i].Prod.Category3__c;
               this.data[i]["Category4__c"] = this.data[i].Prod.Category3__c;
               this.data[i]["Category5__c"] = this.data[i].Prod.Category3__c;
               this.data[i]["SFDA_Status__c"] = this.data[i].Prod.SFDA_Status__c;
                        this.data[i]['Name__c'] = this.data[i].Prod.Name__c;
                        this.data[i]['Category3__c'] =
                            this.data[i].Prod.Category3__c;
                        this.data[i]['Category4__c'] =
                            this.data[i].Prod.Category4__c;
                        this.data[i]['Category5__c'] =
                            this.data[i].Prod.Category5__c;
                        this.data[i]['SFDA_Status__c'] =
                            this.data[i].Prod.SFDA_Status__c;
            }
            this.showTable = true;
            this.orderDetZaikuList = result.entity.orderDetZaikuList;
@@ -243,20 +263,23 @@
               option1ValueTemp.push(object);
            }
            this.category3Options = option1ValueTemp;
            console.log(' this.optionscatone===>' + JSON.stringify(this.optionscatone));
                    console.log(
                        ' this.optionscatone===>' +
                            JSON.stringify(this.optionscatone)
                    );
            let option2ValueTemp = [];
            for (var key in result.entity.category4OptionMap) {
               let object = {};
               object["label"] = result.entity.category4OptionMap[key];
               object["value"] = key;
                        object['label'] = result.entity.category4OptionMap[key];
                        object['value'] = key;
               option2ValueTemp.push(object);
            }
            this.category4Options = option2ValueTemp;
            let option3ValueTemp = [];
            for (var key in result.entity.category5OptionMap) {
               let object = {};
               object["label"] = result.entity.category5OptionMap[key];
               object["value"] = key;
                        object['label'] = result.entity.category5OptionMap[key];
                        object['value'] = key;
               option3ValueTemp.push(object);
            }
            this.category5Options = option3ValueTemp;
@@ -267,24 +290,31 @@
              //hasHos = true 医院特价
              if (this.hasHos) {
                    let object1 = {
                        label: "医院特价",
                        fieldName: "hospitalSpecialOffer__c",
                            label: '医院特价',
                            fieldName: 'hospitalSpecialOffer__c',
                        hideDefaultActions: true,
                  type:'boolean',
                  cellAttributes: { alignment: "left" },
                            cellAttributes: { alignment: 'left' },
                  initialWidth:80
                    };
                    this.columns.push(object1);
               console.log(' this.columns'+  this.columns);
               for (var j in this.data) {
                  this.data[j]["Name__c"] = this.data[j].Prod.Name__c;
                  this.data[j]["Category3__c"] = this.data[j].Prod.Category3__c;
                  this.data[j]["Category4__c"] = this.data[j].Prod.Category3__c;
                  this.data[j]["Category5__c"] = this.data[j].Prod.Category3__c;
                  this.data[j]["SFDA_Status__c"] = this.data[j].Prod.SFDA_Status__c;
                  this.data[j]["hospitalSpecialOffer__c"] = this.data[j].hospitalSpecialOffer;
                  console.log('this.data[j].hospitalSpecialOffer__c'+this.data[j].hospitalSpecialOffer);
                            this.data[j]['Name__c'] = this.data[j].Prod.Name__c;
                            this.data[j]['Category3__c'] =
                                this.data[j].Prod.Category3__c;
                            this.data[j]['Category4__c'] =
                                this.data[j].Prod.Category4__c;
                            this.data[j]['Category5__c'] =
                                this.data[j].Prod.Category5__c;
                            this.data[j]['SFDA_Status__c'] =
                                this.data[j].Prod.SFDA_Status__c;
                            this.data[j]['hospitalSpecialOffer__c'] =
                                this.data[j].hospitalSpecialOffer;
                            console.log(
                                'this.data[j].hospitalSpecialOffer__c' +
                                    this.data[j].hospitalSpecialOffer
                            );
               }
                }
            this.showSpinner = false;
@@ -292,44 +322,45 @@
            // this.showToast("Error",'Error', result.msg);
            this.showMyToast('初始化失败',result.msg,'error');
         }
      }).catch((error) => {
            })
            .catch((error) => {
         this.loader = false;
         this.showSpinner = false;
         console.log("error = " + JSON.stringify(error));
                console.log('error = ' + JSON.stringify(error));
      });
   }
   handleChange(event) {
      let fieldName = event.target.getAttribute("data-field");
        let fieldName = event.target.getAttribute('data-field');
      let value = event.detail.value;
      console.log("======>fieldName" + fieldName);
      console.log("======>value" + value);
        console.log('======>fieldName' + fieldName);
        console.log('======>value' + value);
      switch (fieldName) {
         case "Name":
            case 'Name':
            this.Name = value;
            break;
         case "CategoryThree":
            case 'CategoryThree':
            this.CategoryThree = value;
            break;
         case "CategoryFour":
            case 'CategoryFour':
            this.CategoryFour = value;
            break;
         case "CategoryFive":
            case 'CategoryFive':
            this.CategoryFive = value;
            break;
         default:
            console.log("no data");
                console.log('no data');
      }
   }
   dataChange(event) {
        let fieldName = event.target.getAttribute("data-field");
        let fieldName = event.target.getAttribute('data-field');
        let value = event.detail.value;
        console.log("fieldName = " + fieldName + " value = " + value);
        console.log('fieldName = ' + fieldName + ' value = ' + value);
        switch (fieldName) {
         case "Name":
            case 'Name':
            this.Name = value;
            break;
            case "CategoryThree":
            case 'CategoryThree':
                this.CategoryThree = value;
                //调用后台显示第四五分类
                this.showAllCate();
@@ -338,57 +369,62 @@
                    this.CategoryFive = '';
                }
                break;
            case "CategoryFour":
                this.Category4 = value;
            case 'CategoryFour':
                this.CategoryFour = value;
                //调用后台显示第五分类
                this.showCate();
                if (this.CategoryFour == '') {
                    this.CategoryFive = '';
                }
                break;
            case "CategoryFive":
            case 'CategoryFive':
                this.CategoryFive = value;
                break;
        }
    }
   showAllCate() {
        categoryAllload({
            category3LWC: this.CategoryThree,
         agencyProTypeLWC:this.agencyProType
        }).then((result) => {
        })
            .then((result) => {
            result = JSON.parse(JSON.stringify(result));
            console.log("result = " + JSON.stringify(result));
            if (result.status == "Success") {
                console.log('result = ' + JSON.stringify(result));
                if (result.status == 'Success') {
                this.category4Options = [];
                this.category5Options = [];
                //第4分类
                for (var key in result.entity.category4OptionMap) {
                    let object = {};
                    object["label"] = result.entity.category4OptionMap[key];
                    object["value"] = key;
                        object['label'] = result.entity.category4OptionMap[key];
                        object['value'] = key;
                    this.category4Options.push(object);
                }
                console.log("this.category4Options = " + JSON.stringify(this.category4Options));
                    console.log(
                        'this.category4Options = ' +
                            JSON.stringify(this.category4Options)
                    );
                //第5分类
                for (var key in result.entity.category5OptionMap) {
                    let object = {};
                    object["label"] = result.entity.category5OptionMap[key];
                    object["value"] = key;
                        object['label'] = result.entity.category5OptionMap[key];
                        object['value'] = key;
                    this.category5Options.push(object);
                }
            } else {
                console.log("result = " + JSON.stringify(result));
                    console.log('result = ' + JSON.stringify(result));
                this.showMyToast(result.msg,'','error');
            }
        }).catch((error) => {
            console.log("error" + JSON.stringify(error));
            })
            .catch((error) => {
                console.log('error' + JSON.stringify(error));
        });
    }
   searchOrderDetail() {
      this.showTable = false;
        this.showSpinner = true;
      searchOrder({
         category1: this.Name,
         Category3: this.CategoryThree,
@@ -400,42 +436,71 @@
         userWorkLocation: this.userWorkLocation,
         pageSizeLWC: this.pageSize,
         pageTokenLWC: this.currentPageToken,
            productkucunLWC: this.productkucun
         // sortFieldLWC: this.sortBy,
         // sortOrderLWC: this.sortDirection
      })
         .then((result) => {
            result = JSON.parse(JSON.stringify(result));
            if (result.status == "Success") {
               this.nextPageToken = result.entity.paginatedAccounts.nextPageToken;
               this.totalRecords = result.entity.paginatedAccounts.totalRecords;
               this.recordStart = result.entity.paginatedAccounts.recordStart;
                if (result.status == 'Success') {
                    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(
                        'result.entity.paginatedAccounts = ' +
                            JSON.stringify(result.entity.paginatedAccounts)
                    );
               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);
               // this.showToast("Success",'搜索成功', result.msg);
               this.showMyToast('搜索成功',result.msg,'success');
                    // this.showMyToast('搜索成功',result.msg,'success');
               this.data = result.entity.pageRecords;
               console.log('搜索Data==>'+JSON.stringify(this.data));
               for (var i in this.data) {
                  this.data[i]["Name__c"] = this.data[i].Prod.Name__c;
                  this.data[i]["Category3__c"] = this.data[i].Prod.Category3__c;
                  this.data[i]["Category4__c"] = this.data[i].Prod.Category3__c;
                  this.data[i]["Category5__c"] = this.data[i].Prod.Category3__c;
                  this.data[i]["SFDA_Status__c"] = this.data[i].Prod.SFDA_Status__c;
                  this.data[i]["hospitalSpecialOffer__c"] = this.data[i].hospitalSpecialOffer;
                        this.data[i]['Name__c'] = this.data[i].Prod.Name__c;
                        this.data[i]['Category3__c'] =
                            this.data[i].Prod.Category3__c;
                        this.data[i]['Category4__c'] =
                            this.data[i].Prod.Category4__c;
                        this.data[i]['Category5__c'] =
                            this.data[i].Prod.Category5__c;
                        this.data[i]['SFDA_Status__c'] =
                            this.data[i].Prod.SFDA_Status__c;
                        this.data[i]['hospitalSpecialOffer__c'] =
                            this.data[i].hospitalSpecialOffer;
                        this.data[i]['guaranteeperiod'] =
                            this.data[i].guaranteeperiod;
               }
               this.data = [...this.data];
               console.log('this.data = ' + JSON.stringify(this.data));
               this.showTable = true;
                    this.showSpinner = false;
            } else {
                    this.nextPageToken = this.pageSize;
                    this.totalRecords = 0;
                    this.recordStart = 0;
                    this.recordEnd = 0;
                    this.totalPages = 0;
               // this.showToast("Error",'Error', result.msg);
               this.showMyToast('搜索失败',result.msg,'error');
                    // this.showMyToast('搜索失败',result.msg,'error');
                    this.showSpinner = false;
            }
         })
         .catch((error) => {
            console.log("error = " + JSON.stringify(error));
                console.log('error = ' + JSON.stringify(error));
                this.showSpinner = false;
         });
   }
   inventoryCount() {
@@ -455,7 +520,6 @@
            url: '/lexoverduestock'
         }
      });
   }
   removeBox() {
      this[NavigationMixin.Navigate]({
@@ -464,7 +528,6 @@
            url: '/lexremovebox'
         }
      });
   }
   cancelremoveBox() {
      this[NavigationMixin.Navigate]({
@@ -473,7 +536,6 @@
            url: '/lexcancelremovebox'
         }
      });
   }
   clearAll() {
@@ -483,7 +545,7 @@
      this.CategoryThree = '';
      this.CategoryFour = '';
      this.CategoryFive = '';
      this.template.querySelectorAll("lightning-combobox").forEach((each) => {
        this.template.querySelectorAll('lightning-combobox').forEach((each) => {
         each.value = null;
      });
      console.log(' this.CategoryThree' + this.CategoryThree);
@@ -499,41 +561,55 @@
         userWorkLocation: this.userWorkLocation,
         pageSizeLWC: this.pageSize,
         pageTokenLWC: this.currentPageToken,
            productkucunLWC: this.productkucun
      })
         .then((result) => {
            console.log("result搜索 = " + JSON.stringify(result));
                console.log('result搜索 = ' + JSON.stringify(result));
            result = JSON.parse(JSON.stringify(result));
            if (result.status == "Success") {
               this.nextPageToken = result.entity.paginatedAccounts.nextPageToken;
               this.totalRecords = result.entity.paginatedAccounts.totalRecords;
               this.recordStart = result.entity.paginatedAccounts.recordStart;
                if (result.status == 'Success') {
                    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);
               this.data = result.entity.pageRecords;
               for (var i in this.data) {
                  this.data[i]["Name__c"] = this.data[i].Prod.Name__c;
                  this.data[i]["Category3__c"] = this.data[i].Prod.Category3__c;
                  this.data[i]["Category4__c"] = this.data[i].Prod.Category3__c;
                  this.data[i]["Category5__c"] = this.data[i].Prod.Category3__c;
                  this.data[i]["SFDA_Status__c"] = this.data[i].Prod.SFDA_Status__c;
                        this.data[i]['Name__c'] = this.data[i].Prod.Name__c;
                        this.data[i]['Category3__c'] =
                            this.data[i].Prod.Category3__c;
                        this.data[i]['Category4__c'] =
                            this.data[i].Prod.Category4__c;
                        this.data[i]['Category5__c'] =
                            this.data[i].Prod.Category5__c;
                        this.data[i]['SFDA_Status__c'] =
                            this.data[i].Prod.SFDA_Status__c;
                        this.data[i]['guaranteeperiod'] =
                            this.data[i].guaranteeperiod;
               }
               this.showSpinner = false;
               this.showTable = true;
               this.showMyToast('搜索成功',result.msg,'success');
                    // this.showMyToast('搜索成功',result.msg,'success');
               // this.showToast("Success",'搜索成功', result.msg);
               this.showSpinner = false;
            } else {
               // this.showToast("Error", 'Error',result.msg);
               this.showMyToast('搜索失败',result.msg,'error');
                    // this.showMyToast('搜索失败',result.msg,'error');
                    this.showSpinner = false;
            }
         })
         .catch((error) => {
            console.log("error = " + JSON.stringify(error));
                console.log('error = ' + JSON.stringify(error));
                this.showSpinner = false;
         });
   }
@@ -554,12 +630,12 @@
    }
   onHandleSort(event) {
      console.log("Sort");
        console.log('Sort');
      this.sortBy = event.detail.fieldName;
      this.sortDirection = event.detail.sortDirection;
      this.currentPageToken = 0;
      console.log('this.sortBy = ' + this.sortBy)
      console.log('this.sortDirection = ' + this.sortDirection)
        console.log('this.sortBy = ' + this.sortBy);
        console.log('this.sortDirection = ' + this.sortDirection);
      // if('limitCount' != this.sortBy)
      //    this.searchOrderDetail();
      // else{
@@ -572,7 +648,9 @@
      // }
      const { fieldName: sortedBy, sortDirection } = event.detail;
      const cloneData = [...this.data];
      cloneData.sort(this.sortByMethod(sortedBy, sortDirection === 'asc' ? 1 : -1));
        cloneData.sort(
            this.sortByMethod(sortedBy, sortDirection === 'asc' ? 1 : -1)
        );
      this.data = cloneData;
      this.sortDirection = sortDirection;
      this.sortedBy = sortedBy;
@@ -588,12 +666,14 @@
   }
   handlePrevious() {
      this.currentPageToken = Number(this.currentPageToken) - Number(this.pageSize);
        this.currentPageToken =
            Number(this.currentPageToken) - Number(this.pageSize);
      this.searchOrderDetail();
   }
   handleNext() {
      this.currentPageToken = Number(this.currentPageToken) + Number(this.pageSize);
        this.currentPageToken =
            Number(this.currentPageToken) + Number(this.pageSize);
      this.searchOrderDetail();
   }
   handleFirst() {
@@ -602,7 +682,8 @@
   }
   handleLast() {
      this.currentPageToken = this.totalPages > 1 ? (this.totalPages - 1) * this.pageSize : 0;
        this.currentPageToken =
            this.totalPages > 1 ? (this.totalPages - 1) * this.pageSize : 0;
      this.searchOrderDetail();
   }
@@ -629,28 +710,17 @@
           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);
   // showToast(type,title,msg) {
   //    this.showSpinner = false;
   //    let mode = '';
   //    if (type.toLowerCase() != 'success') {
   //       mode = 'sticky';
   //    } else {
   //       mode = 'dismissable';
   //    }
   //    const event = new ShowToastEvent({
   //       title: title,
   //       variant: type,
   //       message: msg,
   //       mode: mode
   //    });
   //    this.dispatchEvent(event);
   // }
        this.template
            .querySelector('c-common-toast')
            .showToast(variant, content, iconName, 10000);
   }
}