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

export class ProductWithoutOwnerXlsxFileService {
    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 GetProductWithoutOwnerExcelData(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 !== 'CustCntrlId' && key !== 'DescCntrlId') {
                showSearch.push([{
                    text: (key === 'StDate') ? 'Start Date' : (key === 'EnDate') ? 'End Date' : (key === 'CustCntrl') ? 'Customer' : (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.setProductsDetailsInCell(MainData, EntitySettings.DecimalsNumber);

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

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

        this.wb.SheetNames.push(ws_name);

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

        return this.wb;
    }

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

        let MainHeadings: any[] = [
            // {
            //     text: 'SNo',
            //     ColRange: 1,
            //     bold: true,
            //     ChildHeadings: []
            // },
            {
                text: 'Customer Name',
                ColRange: 1,
                bold: true,
                ChildHeadings: [],
            },
            {
                text: 'Phone',
                ColRange: 1,
                bold: true,
                ChildHeadings: [
                    // { text: 'No', ColRange: 1 },
                    // { text: 'Date', ColRange: 1 },
                    // { text: 'Invoice Total', ColRange: 1 }
                ],
            },
            {
                text: 'Vehicle',
                ColRange: 1,
                bold: true,
                ChildHeadings: [
                    // { text: 'Central Tax', ColRange: 1 },
                    // { text: 'State Tax', ColRange: 1 },
                    // { text: 'IGST Tax', ColRange: 1 },
                ],
            },
            {
                text: 'Regn No',
                ColRange: 1,
                bold: true,
                ChildHeadings: [
                    // { text: 'Central Tax', ColRange: 1 },
                    // { text: 'State Tax', ColRange: 1 },
                    // { text: 'IGST Tax', ColRange: 1 },
                ],
            },
            {
                text: 'VIN',
                ColRange: 1,
                bold: true,
                ChildHeadings: [
                    // { text: 'Central Tax', ColRange: 1 },
                    // { text: 'State Tax', ColRange: 1 },
                    // { text: 'IGST Tax', ColRange: 1 },
                ],
            },
            {
                text: 'Owner Ship Start Date',
                ColRange: 1,
                bold: true,
                ChildHeadings: [
                    // { text: 'Central Tax', ColRange: 1 },
                    // { text: 'State Tax', ColRange: 1 },
                    // { text: 'IGST Tax', ColRange: 1 },
                ],
            },
            {
                text: 'Owner Ship End 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;
        // console.log('showSearch', showSearch);
        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 setProductsDetailsInCell(MainData: any, DecimalsNumber: number) {
        MainData.forEach((ProductsList: any) => {
            this.SetProductsDataInExcel(ProductsList, DecimalsNumber);
        });
    }

    static SetProductsDataInExcel(ProductInfo: any, DecimalsNumber: number) {
        ProductInfo.OwnershipStartDate = MyDate.ConvertUTCDateToReadable(ProductInfo.OwnershipStartDate || ProductInfo.OwnershipFrom);
        ProductInfo.OwnershipEndDate = MyDate.ConvertUTCDateToReadable(ProductInfo.OwnershipEndDate || ProductInfo.OwnershipTo);
        let Vehicle: string = this.ProductValue(ProductInfo);
        let ProductData: any = [
            { text: ProductInfo.LastOwnerName || ProductInfo.CustomerName, ColRange: 1, IsString: true },
            { text: ProductInfo.LastOwnerPhone || ProductInfo.Phone, ColRange: 1, IsString: true },
            { text: Vehicle, ColRange: 1, IsString: true },
            { text: ProductInfo.RegistrationNo, ColRange: 1, IsString: false },
            { text: ProductInfo.VIN, ColRange: 1, IsString: false },
            { text: ProductInfo.OwnershipStartDate, ColRange: 1, IsString: false },
            { text: ProductInfo.OwnershipEndDate, ColRange: 1, IsString: false },
            //   { text: TrUtils.FixPriceValue(ProductInfo.Items.UnAmt), ColRange: 1, IsString: false }
        ];
        let ColStart: any = 0;
        ProductData.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 ProductValue(InvoiceInfo: any) {
        // if (!this.isOtherIndustry) {
        let prod: string = '';
        if (!TrUtils.IsNull(InvoiceInfo.Model)) {
            prod = prod + InvoiceInfo.Model;
        }
        if (!TrUtils.IsNull(InvoiceInfo.Year)) {
            prod = prod + ' ' + InvoiceInfo.Year;
        }
        if (!TrUtils.IsNull(InvoiceInfo.Variant)) {
            prod = prod + ' ' + InvoiceInfo.Variant;
        }
        return prod;
        // } else {
        //   return params.data.Model;
        // }

    }

    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) {
        // console.log(ColRange, RowNum);
        var cell = { v: Data, bold: true };
        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;
    }

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

}