import * as XLSX from 'xlsx';
import { MyDate } from '../../../../utils/my-date';
import { TrUtils } from '../../../../utils/tr-utils';

export class OperatorWiseSummaryXlsxFileService {
  static wb: any = {};
  static Row: any = 2;
  static MergeArray: any[] = [];
  static range = { s: { c: 0, r: 0 }, e: { c: 0, r: 0 } };
  static ws: any = {};

  static GetOperatorWiseSummaryExcelData(MainData: any,searchValue: any, HeaderName: any, EntitySettings: any) {
    this.wb={};
    this.ws = {};
    this.Row=0;
    this.range = { s: { c: 0, r: 0 }, e: { c: 0, r: 0 } };
    this.MergeArray=[];
    let ws_name = HeaderName;
    this.wb.Sheets = {};
    this.wb.Props = {};
    this.wb.SSF = {};
    this.wb.SheetNames = [];

    // MainData = this.GetTotals(MainData);
    let showSearch: any = [];
    for (const key in searchValue) {
      if (!TrUtils.IsNull(searchValue[key]) && key !== 'Date' && key !== 'DescCntrlId') {
        showSearch.push([{
          text: (key === 'StDate') ? 'Start Date' : (key === 'EnDate') ? 'End Date' : (key === 'DescCntrl') ?  'Item' : key,
          ColRange: 1,
          bold: true,
          ChildHeadings: [
            // { text: 'Central Tax', ColRange: 1 },
            // { text: 'State Tax', ColRange: 1 },
            // { text: 'IGST Tax', ColRange: 1 },
          ],
        }, {
          text: (key === 'StDate') ? MyDate.ConvertUTCDateToReadable(searchValue[key]) : (key === 'EnDate') ? MyDate.ConvertUTCDateToReadable(searchValue[key]) : searchValue[key],
          ColRange: 7,
          bold: true,
          ChildHeadings: [
            // { text: 'Central Tax', ColRange: 1 },
            // { text: 'State Tax', ColRange: 1 },
            // { text: 'IGST Tax', ColRange: 1 },
          ],
        }]);
      }

      // console.log(`${key}: ${searchValue[key]}`);
    }
    this.setHeadingInCell(HeaderName,showSearch);

    this.setInvoiceDetailsInCell(MainData, EntitySettings.DecimalsNumber);

    this.ws['!ref'] = XLSX.utils.encode_range(this.range);

    this.ws['!merges'] = this.MergeArray;
    this.ws["!cols"] = [{wch: 50},{wch: 10},{wch: 10},{wch: 15},{wch: 15},{wch: 15},{wch: 20}];

    this.wb.SheetNames.push(ws_name);

    this.wb.Sheets[ws_name] = this.ws;

    return this.wb;
  }

  static setHeadingInCell(HeaderName:any, searchValue:any) {

    let MainHeadings: any[] = [
    //   {
    //       text: 'Receipt No',
    //       ColRange: 1,
    //       bold: true,
    //       ChildHeadings: []
    //   },
      {
        text: 'Name',
        ColRange: 1,
        bold: true,
        ChildHeadings: []
    },
      {
        text: 'No. of Transactions',
        ColRange: 1,
        bold: true,
        ChildHeadings: [],
      },
   
      {
        text: 'SubTotal',
        ColRange: 1,
        bold: true,
        ChildHeadings: [
          // { text: 'Central Tax', ColRange: 1 },
          // { text: 'State Tax', ColRange: 1 },
          // { text: 'IGST Tax', ColRange: 1 },
        ],
      },
      {
        text: 'Discount',
        ColRange: 1,
        bold: true,
        ChildHeadings: [
          // { text: 'Central Tax', ColRange: 1 },
          // { text: 'State Tax', ColRange: 1 },
          // { text: 'IGST Tax', ColRange: 1 },
        ],
      },
      {
        text: 'Tax',
        ColRange: 1,
        bold: true,
        ChildHeadings: [
          // { text: 'Central Tax', ColRange: 1 },
          // { text: 'State Tax', ColRange: 1 },
          // { text: 'IGST Tax', ColRange: 1 },
        ],
      },
      {
        text: 'Adjustment',
        ColRange: 1,
        bold: true,
        ChildHeadings: [
          // { text: 'Central Tax', ColRange: 1 },
          // { text: 'State Tax', ColRange: 1 },
          // { text: 'IGST Tax', ColRange: 1 },
        ],
      },
      {
        text: 'Round Off',
        ColRange: 1,
        bold: true,
        ChildHeadings: [
          // { text: 'Central Tax', ColRange: 1 },
          // { text: 'State Tax', ColRange: 1 },
          // { text: 'IGST Tax', ColRange: 1 },
        ],
      },
      {
        text: 'Total',
        ColRange: 1,
        bold: true,
        ChildHeadings: [
          // { text: 'Central Tax', ColRange: 1 },
          // { text: 'State Tax', ColRange: 1 },
          // { text: 'IGST Tax', ColRange: 1 },
        ],
      },
     
    ];
   
    this.SetDataInCell(HeaderName, 0, this.Row);
    this.MergeArray.push({
        s: { r: this.Row, c: 0 },
        e: { r: this.Row, c: 0 + 8 - 1 },
      });
      this.Row += 2;
      searchValue.forEach((search: any) => {
        let ColStart: any = 0;
        // console.log('search', search, ColStart);
        search.forEach((item: any) => {
          // console.log('text', oyo.text, ColStart);
          this.SetDataInCell(item.text, ColStart, this.Row);
          this.MergeArray.push({
            s: { r: this.Row, c: ColStart },
            e: { r: this.Row, c: ColStart + item.ColRange - 1 },
          });
          ColStart += item.ColRange;
        });
        this.Row += 1;
      });
      this.Row += 1;
      let MainColStart: any = 0;
    MainHeadings.forEach((MainHeader: any) => {
      this.SetDataInCell(MainHeader.text, MainColStart, this.Row);
      this.MergeArray.push({
        s: { r: this.Row, c: MainColStart },
        e: { r: this.Row, c: MainColStart + MainHeader.ColRange - 1 },
      });
      MainColStart += MainHeader.ColRange;
    });

    this.Row += 2;
  }

  static setInvoiceDetailsInCell(MainData: any, DecimalsNumber: number) {
    MainData.forEach((InvoiceList: any) => {
      this.SetInvoiceDataInExcel(InvoiceList, DecimalsNumber);
    });
  }

  static SetInvoiceDataInExcel(InvoiceInfo: any, DecimalsNumber: number) {
    // InvoiceInfo.Date = TrUtils.ConvertDateToReadableFormat(InvoiceInfo.CrDate);

    let InvoiceData: any = [
    //   { text: InvoiceInfo.Code, ColRange: 1, IsString: true },
    //   { text: InvoiceInfo.Date, ColRange: 1, IsString: true },
      { text: InvoiceInfo.Name, ColRange: 1, IsString: true },
      { text: InvoiceInfo.Count, ColRange: 1, IsString: true },
      { text: InvoiceInfo.SubTotal, ColRange: 1, IsString: false },
      { text: InvoiceInfo.Disc, ColRange: 1, IsString: false },
      { text: InvoiceInfo.Tax, ColRange: 1, IsString: false },
      { text: InvoiceInfo.Adjust, ColRange: 1, IsString: false },
      { text: InvoiceInfo.Round, ColRange: 1, IsString: false },
      { text: InvoiceInfo.Total, ColRange: 1, IsString: false }
    ];
    let ColStart: any = 0;
    InvoiceData.forEach((InvData: any) => {
      InvData.text = this.ConvertToString(InvData.text, InvData.IsString, DecimalsNumber);
      this.SetDataInCell(InvData.text, ColStart, this.Row);
      this.MergeArray.push({
        s: { r: this.Row, c: ColStart },
        e: { r: this.Row, c: ColStart + InvData.ColRange - 1 },
      });
      ColStart += InvData.ColRange;
    });

    this.Row += 1;
  }

  static ConvertToString(Text: any, IsString: any, DecimalsNumber: number) {
    if (IsString) {
      if (Text == null) {
        Text = '';
      }
    } else {
      if (Text == null) {
        Text = 0;
      }
    }
    if (typeof Text === 'number') {
      return Number(TrUtils.FixedTo(Text, DecimalsNumber));
    } else {
      return Text;
    }
  }

  static SetDataInCell(Data: any, ColRange: number, RowNum: any) {
    var cell = { v: Data };
    var cell_ref = XLSX.utils.encode_cell({ c: ColRange, r: RowNum });
    if (this.range.e.c < ColRange) {
      this.range.e.c = ColRange;
    }
    if (this.range.e.r < RowNum) {
      this.range.e.r = RowNum;
    }
    cell = this.getcelltype(cell);
    this.ws[cell_ref] = cell;
  }

  static getcelltype(cell: any) {
    if (typeof cell.v === 'number') cell.t = 'n';
    else if (typeof cell.v === 'boolean') cell.t = 'b';
    else cell.t = 's';
    return cell;
  }

}