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

export class NextServiceDateXlsxFileService {
    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 GetNextServiceDateExcelData(MainData: any, searchValue: any, HeaderName: any, isDetails: boolean, 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 = [];
        let showSearch: any = [];
        for (const key in searchValue) {
            if (!TrUtils.IsNull(searchValue[key]) && key !== 'Date' && key !== 'ManfCntrlId' && key !== 'VenCntrlId') {
                showSearch.push([{
                    text: (key === 'StDate') ? 'Start Date' : (key === 'EnDate') ? 'End Date' : (key === 'ManfCntrl') ? 'Manufacturer' : (key === 'VenCntrl') ? 'Vendor' : 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]}`);
        }
        MainData = this.GetTotals(MainData);

        this.setHeadingInCell(HeaderName, showSearch, isDetails);

        this.setInvoiceDetailsInCell(MainData, isDetails, 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: 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 GetTotals(MainData: any) {
        MainData.forEach((InvoiceInfo: any) => {

            //   InvoiceInfo.Tax =
            //     InvoiceInfo.ItemsCGST + InvoiceInfo.ItemsSGST + InvoiceInfo.ItemsIGST;
            InvoiceInfo.TotalAmount = InvoiceInfo.Tax + InvoiceInfo.NetAmt;
        });
        return MainData;
    }

    static setHeadingInCell(HeaderName: any, showSearch: any, isDetails: boolean) {

        let MainHeadings: any[] = [
            // {
            //     text: 'SNo',
            //     ColRange: 1,
            //     bold: true,
            //     ChildHeadings: []
            // },
            {
                text: 'Customer Name',
                ColRange: 1,
                bold: true,
                ChildHeadings: [],
            },
               {
                text: 'Mobile No',
                ColRange: 1,
                bold: true,
                ChildHeadings: [],
            },
            {
                text: 'Reg. No',
                ColRange: 1,
                bold: true,
                ChildHeadings: [
                    // { text: 'Central Tax', ColRange: 1 },
                    // { text: 'State Tax', ColRange: 1 },
                    // { text: 'IGST Tax', ColRange: 1 },
                ],
            },
            {
                text: 'Vehicle',
                ColRange: 1,
                bold: true,
                ChildHeadings: [
                    // { text: 'No', ColRange: 1 },
                    // { text: 'Date', ColRange: 1 },
                    // { text: 'Invoice Total', ColRange: 1 }
                ],
            },

            {
                text: 'Sale Date',
                ColRange: 1,
                bold: true,
                ChildHeadings: [
                    // { text: 'Central Tax', ColRange: 1 },
                    // { text: 'State Tax', ColRange: 1 },
                    // { text: 'IGST Tax', ColRange: 1 },
                ],
            },

            {
                text: 'Last Service Date',
                ColRange: 1,
                bold: true,
                ChildHeadings: [
                    // { text: 'Central Tax', ColRange: 1 },
                    // { text: 'State Tax', ColRange: 1 },
                    // { text: 'IGST Tax', ColRange: 1 },
                ],
            },
            {
                text: 'Last Mileage',
                ColRange: 1,
                bold: true,
                ChildHeadings: [
                    // { text: 'Central Tax', ColRange: 1 },
                    // { text: 'State Tax', ColRange: 1 },
                    // { text: 'IGST Tax', ColRange: 1 },
                ],
            },
            {
                text: 'Next Service Date',
                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;
        showSearch.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, isDetails: boolean, DecimalsNumber: number) {
        MainData.forEach((InvoiceList: any) => {
            this.SetInvoiceDataInExcel(InvoiceList, isDetails, DecimalsNumber);
        });
    }

     static PhoneGetter(Customer: any) {
    if (!TrUtils.IsEmpty(Customer) && !TrUtils.IsEmpty(Customer.Cons) &&
      !TrUtils.IsNull(Customer.Cons.Phones)) {
      return Customer.Cons.Phones.Main;
    } else {
      return '';
    }
  }

    static SetInvoiceDataInExcel(InvoiceInfo: any, isDetails: boolean, DecimalsNumber: number) {
        InvoiceInfo.LSDate = this.ConvertDateToReadableFormat(InvoiceInfo.LSDate);
        InvoiceInfo.NSDate = this.ConvertDateToReadableFormat(InvoiceInfo.NSDate);
        InvoiceInfo.DDate = this.ConvertDateToReadableFormat(InvoiceInfo.DDate);

        let InvoiceData: any = [
            { text: InvoiceInfo.Customer?.DName, ColRange: 1, IsString: true },
            { text: this.PhoneGetter(InvoiceInfo.Customer), ColRange: 1, IsString: true },
            { text: InvoiceInfo.RegNo, ColRange: 1, IsString: true },
            { text: InvoiceInfo.Make + '' + InvoiceInfo.Model + '' + InvoiceInfo.Var, ColRange: 1, IsString: false },
            { text: InvoiceInfo.DDate, ColRange: 1, IsString: false },
            { text: InvoiceInfo.LSDate, ColRange: 1, IsString: false },
            { text: InvoiceInfo.LMileage, ColRange: 1, IsString: false },
            { text: InvoiceInfo.NSDate, 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 ConvertDateToReadableFormat(DateObject: any) {
        if (!TrUtils.IsEmpty(DateObject)) {
            let date: any = new Date(DateObject);
            let Month: any;
            let Day: any;

            let MonthName = new Array();
            MonthName[0] = 'Jan';
            MonthName[1] = 'Feb';
            MonthName[2] = 'Mar';
            MonthName[3] = 'Apr';
            MonthName[4] = 'May';
            MonthName[5] = 'Jun';
            MonthName[6] = 'Jul';
            MonthName[7] = 'Aug';
            MonthName[8] = 'Sept';
            MonthName[9] = 'Oct';
            MonthName[10] = 'Nov';
            MonthName[11] = 'Dec';

            Month = MonthName[date.getMonth()];

            if (date.getDate() < 10) {
                Day = '0' + date.getDate();
            } else {
                Day = date.getDate();
            }

            date = Day + '-' + Month + '-' + date.getFullYear();
            return date;
        } else {
            return null;
        }
    }

    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;
    }

}