@extends('admin.layouts')

@section('title', 'GST Purchase With HSN')

@section('header')

    {{-- =========================================================
        DATATABLE CSS
    ========================================================== --}}

    <link rel="stylesheet"
        href="{{ asset('/assets/css/datatable/dataTables.bootstrap5.min.css') }}">

    <link rel="stylesheet"
        href="{{ asset('/assets/css/datatable/responsive.bootstrap.min.css') }}">


    <style>

        .gst-page {
            padding: 12px;
        }

        .gst-top-bar {
            display: flex;
            justify-content: space-between;
            align-items: center;
            margin-bottom: 15px;
            gap: 10px;
            flex-wrap: wrap;
        }

        .gst-top-bar-left {
            display: flex;
            align-items: center;
            gap: 10px;
        }

        .gst-top-bar-right {
            display: flex;
            align-items: center;
            gap: 10px;
        }

        .fiscal-select {
            min-width: 250px;
            height: 52px;
            border: 1px solid #d8dce3;
            border-radius: 7px;
            font-size: 16px;
            color: #65728a;
            padding: 0 15px;
            background: #fff;
        }

        .report-buttons {
            display: flex;
            gap: 10px;
        }

        .report-buttons .btn {
            height: 46px;
            border: 1px solid #d9dce2;
            background: #fff;
            color: #343a40;
            border-radius: 7px;
            padding: 0 18px;
            font-size: 15px;
        }

        .report-buttons .btn:hover {
            background: #f5f5f5;
        }

        .filter-card {
            background: #fff;
            border: 1px solid #e5e5e5;
            border-radius: 8px;
            padding: 15px;
            margin-bottom: 15px;
        }

        .filter-card label {
            font-size: 13px;
            font-weight: 600;
        }

        #gstPurchaseTable {
            width: 100% !important;
        }

        #gstPurchaseTable thead th {
            background: #f8f8fa;
            color: #111827;
            font-size: 13px;
            font-weight: 600;
            white-space: nowrap;
            vertical-align: middle;
            padding: 10px 12px;
        }

        #gstPurchaseTable tbody td {
            font-size: 13px;
            color: #1f2937;
            white-space: nowrap;
            vertical-align: middle;
            padding: 10px 12px;
        }

        #gstPurchaseTable tbody tr:hover {
            background: #fafafa;
        }

        .item-name {
            white-space: normal !important;
            min-width: 180px;
            max-width: 240px;
            line-height: 1.4;
        }

        .amount-cell {
            font-weight: 600;
        }

        .gst-cell {
            min-width: 80px;
            text-align: center;
        }

        .empty-report {
            text-align: center;
            padding: 60px 20px !important;
            color: #777;
            font-size: 15px;
        }

        .table-responsive {
            overflow-x: auto;
        }

        .report-card {
            background: #fff;
            border: 1px solid #ddd;
            border-radius: 0;
            padding: 0;
        }

        .dataTables_wrapper {
            padding: 10px 0;
        }

        .dataTables_wrapper .dataTables_filter input {
            margin-left: 8px;
        }

        .dataTables_wrapper .dataTables_length select {
            margin: 0 5px;
        }

        .invoice-btn {
            white-space: nowrap;
        }

        .sno-column {
            text-align: center;
            width: 60px;
        }

        @media(max-width: 768px) {

            .gst-top-bar {
                align-items: stretch;
            }

            .gst-top-bar-left,
            .gst-top-bar-right,
            .report-buttons {
                width: 100%;
            }

            .fiscal-select {
                width: 100%;
            }

            .report-buttons .btn {
                flex: 1;
            }

        }

    </style>

@endsection


@section('content')

<div class="container-fluid gst-page">

    {{-- =========================================================
        TOP BAR
    ========================================================== --}}

    <div class="gst-top-bar">

        <div class="gst-top-bar-left">

           

        </div>


        <div class="gst-top-bar-right report-buttons">

            <button
                type="button"
                class="btn"
                id="excelBtn">

                <i class="fas fa-file-excel me-1"></i>

                Export Excel

            </button>

        </div>

    </div>


    {{-- =========================================================
        DATE FILTER
    ========================================================== --}}

    <div class="filter-card">

        <div class="row align-items-end g-3">

            {{-- FROM DATE --}}

            <div class="col-md-3">

                <label
                    for="fromDate"
                    class="form-label">

                    From Date

                </label>

                <input
                    type="date"
                    id="fromDate"
                    class="form-control">

            </div>


            {{-- TO DATE --}}

            <div class="col-md-3">

                <label
                    for="toDate"
                    class="form-label">

                    To Date

                </label>

                <input
                    type="date"
                    id="toDate"
                    class="form-control">

            </div>


            {{-- FILTER --}}

            <div class="col-md-2">

                <button
                    type="button"
                    id="filterBtn"
                    class="btn btn-primary w-100">

                    <i class="fas fa-filter"></i>

                    Filter

                </button>

            </div>


            {{-- RESET --}}

            <div class="col-md-2">

                <button
                    type="button"
                    id="resetBtn"
                    class="btn btn-secondary w-100">

                    <i class="fas fa-sync-alt"></i>

                    Reset

                </button>

            </div>

        </div>

    </div>


    {{-- =========================================================
        REPORT TABLE
    ========================================================== --}}

    <div class="report-card">

        <div class="table-responsive">

            <table
                id="gstPurchaseTable"
                class="table table-bordered table-hover mb-0">

                <thead>

                    <tr>

                        <th class="sno-column">
                            S.NO
                        </th>

                        <th>
                            DATE
                        </th>

                        <th>
                            INVOICE NO
                        </th>

                        <th>
                            PARTY GSTIN
                        </th>

                        <th>
                            PARTY NAME
                        </th>

                        <th>
                            ITEM NAME
                        </th>

                        <th>
                            HSN CODE
                        </th>

                        <th>
                            QTY
                        </th>

                        <th>
                            PRICE/UNIT
                        </th>

                        <th>
                            SGST
                        </th>

                        <th>
                            CGST
                        </th>

                        <th>
                            AMOUNT
                        </th>

                        <th>
                            ACTION
                        </th>

                    </tr>

                </thead>


                <tbody>

                    @forelse($report ?? [] as $index => $row)

                        <tr>

                            {{-- S.NO --}}

                            <td class="text-center">

                                {{ $index + 1 }}

                            </td>


                            {{-- DATE --}}

                            <td>

                                {{ $row['date'] ?? '-' }}

                            </td>


                            {{-- INVOICE NO --}}

                            <td>

                                <strong>
                                    {{ $row['invoice_no'] ?? '-' }}
                                </strong>

                            </td>


                            {{-- PARTY GSTIN --}}

                            <td>

                                {{ $row['party_gstin'] ?? '-' }}

                            </td>


                            {{-- PARTY NAME --}}

                            <td>

                                {{ $row['party_name'] ?? '-' }}

                            </td>


                            {{-- ITEM NAME --}}

                            <td class="item-name">

                                {{ $row['item_name'] ?? '-' }}

                            </td>


                            {{-- HSN CODE --}}

                            <td>

                                <strong>
                                    {{ $row['hsn_code'] ?? '-' }}
                                </strong>

                            </td>


                            {{-- QTY --}}

                            <td>

                                {{ number_format(
                                    (float)($row['qty'] ?? 0),
                                    2
                                ) }}

                                {{ $row['unit'] ?? '' }}

                            </td>


                            {{-- PRICE --}}

                            <td>

                                ₹{{ number_format(
                                    (float)($row['price'] ?? 0),
                                    2
                                ) }}

                            </td>


                            {{-- SGST --}}

                            <td class="gst-cell">

                                @if(
                                    (float)($row['sgst'] ?? 0) > 0
                                )

                                    ₹{{ number_format(
                                        (float)$row['sgst'],
                                        2
                                    ) }}

                                    @if(
                                        !empty($row['gst_rate'])
                                    )

                                        <br>

                                        <small>

                                            (
                                            {{ number_format(
                                                (float)$row['gst_rate'] / 2,
                                                2
                                            ) }}%
                                            )

                                        </small>

                                    @endif

                                @else

                                    -

                                @endif

                            </td>


                            {{-- CGST --}}

                            <td class="gst-cell">

                                @if(
                                    (float)($row['cgst'] ?? 0) > 0
                                )

                                    ₹{{ number_format(
                                        (float)$row['cgst'],
                                        2
                                    ) }}

                                    @if(
                                        !empty($row['gst_rate'])
                                    )

                                        <br>

                                        <small>

                                            (
                                            {{ number_format(
                                                (float)$row['gst_rate'] / 2,
                                                2
                                            ) }}%
                                            )

                                        </small>

                                    @endif

                                @else

                                    -

                                @endif

                            </td>


                            {{-- AMOUNT --}}

                            <td class="amount-cell">

                                ₹{{ number_format(
                                    (float)($row['amount'] ?? 0),
                                    2
                                ) }}

                            </td>


                            {{-- ACTION --}}

                            <td class="text-center">

                                @if(
                                    !empty($row['purchase_id'])
                                )

                                    <a
                                        href="{{ route(
                                            'gstPurchaseInvoiceA4',
                                            [
                                                'order_id' => $row['purchase_id']
                                            ]
                                        ) }}"
                                        target="_blank"
                                        class="btn btn-sm btn-primary invoice-btn">

                                        <i class="fas fa-file-invoice"></i>

                                        Invoice

                                    </a>

                                @else

                                    <span class="text-muted">
                                        -
                                    </span>

                                @endif

                            </td>

                        </tr>

                    @empty

                        <tr>

                            <td
                                colspan="13"
                                class="empty-report">

                                No GST purchase transactions available.

                            </td>

                        </tr>

                    @endforelse

                </tbody>

            </table>

        </div>

    </div>

</div>

@endsection


@section('footer')

    {{-- =========================================================
        JQUERY
    ========================================================== --}}

    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>


    {{-- =========================================================
        DATATABLE JS
    ========================================================== --}}

    <script src="{{ asset('/assets/js/datatable/jquery.dataTables.min.js') }}"></script>

    <script src="{{ asset('/assets/js/datatable/dataTables.bootstrap5.min.js') }}"></script>

    <script src="{{ asset('/assets/js/datatable/dataTables.responsive.min.js') }}"></script>


    {{-- =========================================================
        SHEETJS
    ========================================================== --}}

    <script src="https://cdn.sheetjs.com/xlsx-0.20.3/package/dist/xlsx.full.min.js"></script>


    <script>

    $(document).ready(function () {


        /*
        |--------------------------------------------------------------------------
        | REPORT DATA
        |--------------------------------------------------------------------------
        */

        const reportData =
            @json($report ?? []);


        /*
        |--------------------------------------------------------------------------
        | DATATABLE
        |--------------------------------------------------------------------------
        */

        let table =
            $('#gstPurchaseTable').DataTable({

                responsive: false,

                scrollX: true,

                pageLength: 10,

                lengthMenu: [
                    [10, 25, 50, 100, -1],
                    [10, 25, 50, 100, "All"]
                ],

                ordering: true,

                searching: true,

                lengthChange: true,

                autoWidth: false,

                order: [
                    [1, 'desc']
                ],

                columnDefs: [

                    {
                        targets: 0,
                        orderable: false,
                        searchable: false
                    },

                    {
                        targets: 12,
                        orderable: false,
                        searchable: false
                    }

                ],

                language: {

                    search: "Search:",

                    searchPlaceholder:
                        "Search GST purchases...",

                    lengthMenu:
                        "Show _MENU_ entries",

                    info:
                        "Showing _START_ to _END_ of _TOTAL_ entries",

                    infoEmpty:
                        "No entries available",

                    zeroRecords:
                        "No matching records found",

                    emptyTable:
                        "No GST purchase transactions available.",

                    paginate: {

                        first: "First",

                        last: "Last",

                        next: "Next",

                        previous: "Previous"

                    }

                }

            });


        /*
        |--------------------------------------------------------------------------
        | NUMBER HELPER
        |--------------------------------------------------------------------------
        */

        function numberValue(value) {

            let number =
                parseFloat(value);


            return isNaN(number)
                ? 0
                : number;

        }


        /*
        |--------------------------------------------------------------------------
        | DATE PARSER
        |--------------------------------------------------------------------------
        */

        function parseReportDate(dateValue) {

            if (!dateValue) {

                return null;

            }


            let value =
                String(dateValue).trim();


            /*
            |--------------------------------------------------------------------------
            | YYYY-MM-DD
            |--------------------------------------------------------------------------
            */

            if (
                /^\d{4}-\d{2}-\d{2}$/.test(value)
            ) {

                let parts =
                    value.split('-');


                return new Date(
                    parseInt(parts[0]),
                    parseInt(parts[1]) - 1,
                    parseInt(parts[2])
                );

            }


            /*
            |--------------------------------------------------------------------------
            | DD-MM-YYYY
            |--------------------------------------------------------------------------
            */

            if (
                /^\d{2}-\d{2}-\d{4}$/.test(value)
            ) {

                let parts =
                    value.split('-');


                return new Date(
                    parseInt(parts[2]),
                    parseInt(parts[1]) - 1,
                    parseInt(parts[0])
                );

            }


            /*
            |--------------------------------------------------------------------------
            | DD/MM/YYYY
            |--------------------------------------------------------------------------
            */

            if (
                /^\d{2}\/\d{2}\/\d{4}$/.test(value)
            ) {

                let parts =
                    value.split('/');


                return new Date(
                    parseInt(parts[2]),
                    parseInt(parts[1]) - 1,
                    parseInt(parts[0])
                );

            }


            return null;

        }


        /*
        |--------------------------------------------------------------------------
        | DATATABLE DATE FILTER
        |--------------------------------------------------------------------------
        */

        $.fn.dataTable.ext.search.push(

            function (
                settings,
                data,
                dataIndex
            ) {

                /*
                |--------------------------------------------------------------------------
                | Only Purchase Table
                |--------------------------------------------------------------------------
                */

                if (
                    settings.nTable.id !==
                    'gstPurchaseTable'
                ) {

                    return true;

                }


                let fromDate =
                    $('#fromDate').val();


                let toDate =
                    $('#toDate').val();


                /*
                |--------------------------------------------------------------------------
                | DATE COLUMN
                |--------------------------------------------------------------------------
                */

                let dateText =
                    data[1];


                /*
                |--------------------------------------------------------------------------
                | No filter
                |--------------------------------------------------------------------------
                */

                if (
                    !fromDate &&
                    !toDate
                ) {

                    return true;

                }


                if (
                    !dateText ||
                    dateText === '-'
                ) {

                    return false;

                }


                let rowDate =
                    parseReportDate(
                        dateText
                    );


                if (!rowDate) {

                    return false;

                }


                rowDate.setHours(
                    0,
                    0,
                    0,
                    0
                );


                /*
                |--------------------------------------------------------------------------
                | FROM DATE
                |--------------------------------------------------------------------------
                */

                if (fromDate) {

                    let from =
                        new Date(
                            fromDate
                        );


                    from.setHours(
                        0,
                        0,
                        0,
                        0
                    );


                    if (
                        rowDate < from
                    ) {

                        return false;

                    }

                }


                /*
                |--------------------------------------------------------------------------
                | TO DATE
                |--------------------------------------------------------------------------
                */

                if (toDate) {

                    let to =
                        new Date(
                            toDate
                        );


                    to.setHours(
                        0,
                        0,
                        0,
                        0
                    );


                    if (
                        rowDate > to
                    ) {

                        return false;

                    }

                }


                return true;

            }

        );


        /*
        |--------------------------------------------------------------------------
        | FILTER BUTTON
        |--------------------------------------------------------------------------
        */

        $('#filterBtn').on(
            'click',
            function () {

                table.draw();

            }
        );


        /*
        |--------------------------------------------------------------------------
        | RESET BUTTON
        |--------------------------------------------------------------------------
        */

        $('#resetBtn').on(
            'click',
            function () {

                $('#fromDate').val('');

                $('#toDate').val('');

                table.search('');

                table.draw();

            }
        );


        /*
        |--------------------------------------------------------------------------
        | DATE CHANGE
        |--------------------------------------------------------------------------
        */

        $('#fromDate, #toDate').on(
            'change',
            function () {

                table.draw();

            }
        );


        /*
        |--------------------------------------------------------------------------
        | GET FILTERED REPORT DATA
        |--------------------------------------------------------------------------
        */

        function getFilteredReportData() {

            let fromDate =
                $('#fromDate').val();


            let toDate =
                $('#toDate').val();


            /*
            |--------------------------------------------------------------------------
            | DATATABLE SEARCH
            |--------------------------------------------------------------------------
            */

            let searchValue =
                table.search()
                    .trim()
                    .toLowerCase();


            return reportData.filter(
                function (row) {


                    /*
                    |--------------------------------------------------------------------------
                    | DATE FILTER
                    |--------------------------------------------------------------------------
                    */

                    if (
                        fromDate ||
                        toDate
                    ) {

                        let rowDate =
                            parseReportDate(
                                row.date
                            );


                        if (!rowDate) {

                            return false;

                        }


                        rowDate.setHours(
                            0,
                            0,
                            0,
                            0
                        );


                        if (fromDate) {

                            let from =
                                new Date(
                                    fromDate
                                );


                            from.setHours(
                                0,
                                0,
                                0,
                                0
                            );


                            if (
                                rowDate < from
                            ) {

                                return false;

                            }

                        }


                        if (toDate) {

                            let to =
                                new Date(
                                    toDate
                                );


                            to.setHours(
                                0,
                                0,
                                0,
                                0
                            );


                            if (
                                rowDate > to
                            ) {

                                return false;

                            }

                        }

                    }


                    /*
                    |--------------------------------------------------------------------------
                    | DATATABLE SEARCH FILTER
                    |--------------------------------------------------------------------------
                    */

                    if (
                        searchValue !== ''
                    ) {

                        let searchableText = [

                            row.date,

                            row.invoice_no,

                            row.party_gstin,

                            row.party_name,

                            row.item_name,

                            row.hsn_code,

                            row.qty,

                            row.unit,

                            row.price,

                            row.sgst,

                            row.cgst,

                            row.igst,

                            row.amount,

                            row.gst_rate

                        ]
                        .map(
                            function (value) {

                                return (
                                    value === null ||
                                    value === undefined
                                )
                                    ? ''
                                    : String(value);

                            }
                        )
                        .join(' ')
                        .toLowerCase();


                        if (
                            !searchableText.includes(
                                searchValue
                            )
                        ) {

                            return false;

                        }

                    }


                    return true;

                }
            );

        }


        /*
        |--------------------------------------------------------------------------
        | GET UNIQUE PURCHASE INVOICES
        |--------------------------------------------------------------------------
        */

        function getPurchaseInvoiceRows(rows) {

            const invoiceMap =
                new Map();


            rows.forEach(
                function (row) {

                    let invoiceNo =
                        row.invoice_no || '-';


                    if (
                        !invoiceMap.has(
                            invoiceNo
                        )
                    ) {

                        invoiceMap.set(
                            invoiceNo,
                            {

                                date:
                                    row.date || '',

                                invoice_no:
                                    invoiceNo,

                                party_gstin:
                                    row.party_gstin || '',

                                party_name:
                                    row.party_name || '',

                                qty: 0,

                                sgst: 0,

                                cgst: 0,

                                igst: 0,

                                amount: 0

                            }
                        );

                    }


                    let invoice =
                        invoiceMap.get(
                            invoiceNo
                        );


                    invoice.qty +=
                        numberValue(
                            row.qty
                        );


                    invoice.sgst +=
                        numberValue(
                            row.sgst
                        );


                    invoice.cgst +=
                        numberValue(
                            row.cgst
                        );


                    invoice.igst +=
                        numberValue(
                            row.igst
                        );


                    invoice.amount +=
                        numberValue(
                            row.amount
                        );

                }
            );


            return Array.from(
                invoiceMap.values()
            );

        }


        /*
        |--------------------------------------------------------------------------
        | TAB 1 - PURCHASES
        |--------------------------------------------------------------------------
        */

        function buildPurchasesSheet(rows) {

            let data = [

                [

                    'S.No',

                    'Date',

                    'Invoice No',

                    'Party GSTIN',

                    'Party Name',

                    'Item Name',

                    'HSN Code',

                    'Qty',

                    'Unit',

                    'Price/Unit',

                    'GST %',

                    'SGST',

                    'CGST',

                    'IGST',

                    'Amount'

                ]

            ];


            rows.forEach(
                function (
                    row,
                    index
                ) {

                    data.push([

                        index + 1,

                        row.date || '',

                        row.invoice_no !== null &&
                        row.invoice_no !== undefined
                            ? String(
                                row.invoice_no
                            )
                            : '',

                        row.party_gstin !== null &&
                        row.party_gstin !== undefined
                            ? String(
                                row.party_gstin
                            )
                            : '',

                        row.party_name !== null &&
                        row.party_name !== undefined
                            ? String(
                                row.party_name
                            )
                            : '',

                        row.item_name !== null &&
                        row.item_name !== undefined
                            ? String(
                                row.item_name
                            )
                            : '',

                        row.hsn_code !== null &&
                        row.hsn_code !== undefined
                            ? String(
                                row.hsn_code
                            )
                            : '',

                        numberValue(
                            row.qty
                        ),

                        row.unit || '',

                        numberValue(
                            row.price
                        ),

                        numberValue(
                            row.gst_rate
                        ),

                        numberValue(
                            row.sgst
                        ),

                        numberValue(
                            row.cgst
                        ),

                        numberValue(
                            row.igst
                        ),

                        numberValue(
                            row.amount
                        )

                    ]);

                }
            );


            return data;

        }


        /*
        |--------------------------------------------------------------------------
        | TAB 2 - B2B
        |--------------------------------------------------------------------------
        */

        function buildB2BSheet(rows) {

            let invoices =
                getPurchaseInvoiceRows(
                    rows
                );


            let data = [

                [

                    'Invoice No',

                    'Date',

                    'Supplier',

                    'GSTIN',

                    'Quantity',

                    'SGST',

                    'CGST',

                    'IGST',

                    'GST',

                    'Total'

                ]

            ];


            invoices
                .filter(
                    function (invoice) {

                        return (
                            invoice.party_gstin &&
                            String(
                                invoice.party_gstin
                            ).trim() !== ''
                        );

                    }
                )
                .forEach(
                    function (invoice) {

                        let gst =
                            invoice.sgst +
                            invoice.cgst +
                            invoice.igst;


                        data.push([

                            String(
                                invoice.invoice_no
                            ),

                            invoice.date,

                            invoice.party_name || '',

                            String(
                                invoice.party_gstin
                            ),

                            Number(
                                invoice.qty.toFixed(2)
                            ),

                            Number(
                                invoice.sgst.toFixed(2)
                            ),

                            Number(
                                invoice.cgst.toFixed(2)
                            ),

                            Number(
                                invoice.igst.toFixed(2)
                            ),

                            Number(
                                gst.toFixed(2)
                            ),

                            Number(
                                invoice.amount.toFixed(2)
                            )

                        ]);

                    }
                );


            return data;

        }


        /*
        |--------------------------------------------------------------------------
        | TAB 3 - B2C
        |--------------------------------------------------------------------------
        */

        function buildB2CSheet(rows) {

            let invoices =
                getPurchaseInvoiceRows(
                    rows
                );


            let data = [

                [

                    'Invoice No',

                    'Date',

                    'Supplier',

                    'Quantity',

                    'SGST',

                    'CGST',

                    'IGST',

                    'GST',

                    'Total'

                ]

            ];


            invoices
                .filter(
                    function (invoice) {

                        return (
                            !invoice.party_gstin ||
                            String(
                                invoice.party_gstin
                            ).trim() === ''
                        );

                    }
                )
                .forEach(
                    function (invoice) {

                        let gst =
                            invoice.sgst +
                            invoice.cgst +
                            invoice.igst;


                        data.push([

                            String(
                                invoice.invoice_no
                            ),

                            invoice.date,

                            invoice.party_name || '',

                            Number(
                                invoice.qty.toFixed(2)
                            ),

                            Number(
                                invoice.sgst.toFixed(2)
                            ),

                            Number(
                                invoice.cgst.toFixed(2)
                            ),

                            Number(
                                invoice.igst.toFixed(2)
                            ),

                            Number(
                                gst.toFixed(2)
                            ),

                            Number(
                                invoice.amount.toFixed(2)
                            )

                        ]);

                    }
                );


            return data;

        }


        /*
        |--------------------------------------------------------------------------
        | TAB 4 - HSN SUMMARY
        |--------------------------------------------------------------------------
        */

        function buildHSNSheet(rows) {

            const hsnMap =
                new Map();


            rows.forEach(
                function (row) {

                    let hsnCode =
                        row.hsn_code || 'N/A';


                    let itemName =
                        row.item_name || '';


                    let key =
                        hsnCode +
                        '|' +
                        itemName;


                    if (
                        !hsnMap.has(key)
                    ) {

                        hsnMap.set(
                            key,
                            {

                                hsn_code:
                                    hsnCode,

                                item_name:
                                    itemName,

                                qty: 0,

                                gst_rate: 0,

                                sgst: 0,

                                cgst: 0,

                                igst: 0,

                                amount: 0

                            }
                        );

                    }


                    let hsn =
                        hsnMap.get(
                            key
                        );


                    hsn.qty +=
                        numberValue(
                            row.qty
                        );


                    hsn.sgst +=
                        numberValue(
                            row.sgst
                        );


                    hsn.cgst +=
                        numberValue(
                            row.cgst
                        );


                    hsn.igst +=
                        numberValue(
                            row.igst
                        );


                    hsn.amount +=
                        numberValue(
                            row.amount
                        );


                    let currentRate =
                        numberValue(
                            row.gst_rate
                        );


                    if (
                        currentRate >
                        hsn.gst_rate
                    ) {

                        hsn.gst_rate =
                            currentRate;

                    }

                }
            );


            let data = [

                [

                    'HSN Code',

                    'Item',

                    'Qty',

                    'GST %',

                    'SGST',

                    'CGST',

                    'IGST',

                    'Amount'

                ]

            ];


            hsnMap.forEach(
                function (hsn) {

                    data.push([

                        String(
                            hsn.hsn_code
                        ),

                        hsn.item_name,

                        Number(
                            hsn.qty.toFixed(2)
                        ),

                        Number(
                            hsn.gst_rate.toFixed(2)
                        ),

                        Number(
                            hsn.sgst.toFixed(2)
                        ),

                        Number(
                            hsn.cgst.toFixed(2)
                        ),

                        Number(
                            hsn.igst.toFixed(2)
                        ),

                        Number(
                            hsn.amount.toFixed(2)
                        )

                    ]);

                }
            );


            return data;

        }


        /*
        |--------------------------------------------------------------------------
        | CALCULATION TOTALS
        |--------------------------------------------------------------------------
        */

        function calculateTotals(rows) {

            let totals = {

                qty: 0,

                sgst: 0,

                cgst: 0,

                igst: 0,

                gst: 0,

                amount: 0

            };


            rows.forEach(
                function (row) {

                    totals.qty +=
                        numberValue(
                            row.qty
                        );


                    totals.sgst +=
                        numberValue(
                            row.sgst
                        );


                    totals.cgst +=
                        numberValue(
                            row.cgst
                        );


                    totals.igst +=
                        numberValue(
                            row.igst
                        );


                    totals.amount +=
                        numberValue(
                            row.amount
                        );

                }
            );


            totals.gst =
                totals.sgst +
                totals.cgst +
                totals.igst;


            return totals;

        }


        /*
        |--------------------------------------------------------------------------
        | TAB 5 - CALCULATION
        |--------------------------------------------------------------------------
        */

        function buildCalculationSheet(rows) {

            let totals =
                calculateTotals(
                    rows
                );


            return [

                [

                    'Particular',

                    'Amount'

                ],

                [

                    'Total Quantity',

                    Number(
                        totals.qty.toFixed(2)
                    )

                ],

                [

                    'Total SGST',

                    Number(
                        totals.sgst.toFixed(2)
                    )

                ],

                [

                    'Total CGST',

                    Number(
                        totals.cgst.toFixed(2)
                    )

                ],

                [

                    'Total IGST',

                    Number(
                        totals.igst.toFixed(2)
                    )

                ],

                [

                    'Total GST',

                    Number(
                        totals.gst.toFixed(2)
                    )

                ],

                [

                    'Purchase Total',

                    Number(
                        totals.amount.toFixed(2)
                    )

                ]

            ];

        }


        /*
        |--------------------------------------------------------------------------
        | TAB 6 - AUDIT
        |--------------------------------------------------------------------------
        */

        function buildAuditSheet(rows) {

            let totals =
                calculateTotals(
                    rows
                );


            let hsnData =
                buildHSNSheet(
                    rows
                );


            let hsnSGST = 0;

            let hsnCGST = 0;

            let hsnIGST = 0;

            let hsnAmount = 0;


            /*
            |--------------------------------------------------------------------------
            | SKIP HEADER
            |--------------------------------------------------------------------------
            */

            for (
                let i = 1;
                i < hsnData.length;
                i++
            ) {

                hsnSGST +=
                    numberValue(
                        hsnData[i][4]
                    );


                hsnCGST +=
                    numberValue(
                        hsnData[i][5]
                    );


                hsnIGST +=
                    numberValue(
                        hsnData[i][6]
                    );


                hsnAmount +=
                    numberValue(
                        hsnData[i][7]
                    );

            }


            /*
            |--------------------------------------------------------------------------
            | AUDIT ROW
            |--------------------------------------------------------------------------
            */

            function auditRow(
                particular,
                purchaseTotal,
                hsnTotal
            ) {

                let difference =
                    purchaseTotal -
                    hsnTotal;


                difference =
                    Math.round(
                        difference * 100
                    ) / 100;


                let status =
                    Math.abs(
                        difference
                    ) < 0.01
                        ? 'Matched'
                        : 'Mismatch';


                return [

                    particular,

                    Number(
                        purchaseTotal.toFixed(2)
                    ),

                    Number(
                        hsnTotal.toFixed(2)
                    ),

                    Number(
                        difference.toFixed(2)
                    ),

                    status

                ];

            }


            let data = [

                [

                    'Particular',

                    'Purchase Total',

                    'HSN Total',

                    'Difference',

                    'Status'

                ],


                auditRow(
                    'SGST',
                    totals.sgst,
                    hsnSGST
                ),


                auditRow(
                    'CGST',
                    totals.cgst,
                    hsnCGST
                ),


                auditRow(
                    'IGST',
                    totals.igst,
                    hsnIGST
                ),


                auditRow(
                    'Total GST',
                    totals.gst,
                    hsnSGST +
                    hsnCGST +
                    hsnIGST
                ),


                auditRow(
                    'Purchase Amount',
                    totals.amount,
                    hsnAmount
                )

            ];


            /*
            |--------------------------------------------------------------------------
            | OVERALL STATUS
            |--------------------------------------------------------------------------
            */

            let allMatched =
                data
                    .slice(1)
                    .every(
                        function (row) {

                            return (
                                row[4] ===
                                'Matched'
                            );

                        }
                    );


            data.push([

                'OVERALL STATUS',

                '',

                '',

                '',

                allMatched
                    ? 'Matched'
                    : 'Mismatch'

            ]);


            return data;

        }


        /*
        |--------------------------------------------------------------------------
        | FORMAT WORKSHEET
        |--------------------------------------------------------------------------
        */

        function formatWorksheet(
            worksheet,
            widths
        ) {

            worksheet['!cols'] =
                widths.map(
                    function (width) {

                        return {
                            wch: width
                        };

                    }
                );


            worksheet['!freeze'] = {

                xSplit: 0,

                ySplit: 1

            };

        }


        /*
        |--------------------------------------------------------------------------
        | FORCE TEXT FORMAT
        |--------------------------------------------------------------------------
        */

        function forceTextColumns(
            worksheet,
            data,
            columns
        ) {

            for (
                let rowIndex = 1;
                rowIndex < data.length;
                rowIndex++
            ) {

                columns.forEach(
                    function (columnIndex) {

                        let cell =
                            XLSX.utils.encode_cell({

                                r: rowIndex,

                                c: columnIndex

                            });


                        if (
                            worksheet[cell]
                        ) {

                            worksheet[cell].t =
                                's';


                            worksheet[cell].z =
                                '@';

                        }

                    }
                );

            }

        }


        /*
        |--------------------------------------------------------------------------
        | CREATE WORKBOOK
        |--------------------------------------------------------------------------
        */

        function createGSTPurchaseWorkbook(
            rows
        ) {

            let workbook =
                XLSX.utils.book_new();


            /*
            |--------------------------------------------------------------------------
            | SHEET 1 - PURCHASES
            |--------------------------------------------------------------------------
            */

            let purchasesData =
                buildPurchasesSheet(
                    rows
                );


            let purchasesSheet =
                XLSX.utils.aoa_to_sheet(
                    purchasesData
                );


            formatWorksheet(
                purchasesSheet,
                [

                    8,
                    14,
                    22,
                    22,
                    28,
                    35,
                    15,
                    12,
                    12,
                    15,
                    12,
                    15,
                    15,
                    15,
                    18

                ]
            );


            /*
            |--------------------------------------------------------------------------
            | Invoice No = C
            | GSTIN = D
            | HSN = G
            |--------------------------------------------------------------------------
            */

            forceTextColumns(
                purchasesSheet,
                purchasesData,
                [
                    2,
                    3,
                    6
                ]
            );


            XLSX.utils.book_append_sheet(
                workbook,
                purchasesSheet,
                'Purchases'
            );


            /*
            |--------------------------------------------------------------------------
            | SHEET 2 - B2B
            |--------------------------------------------------------------------------
            */

            let b2bData =
                buildB2BSheet(
                    rows
                );


            let b2bSheet =
                XLSX.utils.aoa_to_sheet(
                    b2bData
                );


            formatWorksheet(
                b2bSheet,
                [

                    22,
                    14,
                    30,
                    22,
                    12,
                    15,
                    15,
                    15,
                    15,
                    18

                ]
            );


            /*
            |--------------------------------------------------------------------------
            | Invoice No = A
            | GSTIN = D
            |--------------------------------------------------------------------------
            */

            forceTextColumns(
                b2bSheet,
                b2bData,
                [
                    0,
                    3
                ]
            );


            XLSX.utils.book_append_sheet(
                workbook,
                b2bSheet,
                'B2B'
            );


            /*
            |--------------------------------------------------------------------------
            | SHEET 3 - B2C
            |--------------------------------------------------------------------------
            */

            let b2cData =
                buildB2CSheet(
                    rows
                );


            let b2cSheet =
                XLSX.utils.aoa_to_sheet(
                    b2cData
                );


            formatWorksheet(
                b2cSheet,
                [

                    22,
                    14,
                    30,
                    12,
                    15,
                    15,
                    15,
                    15,
                    18

                ]
            );


            forceTextColumns(
                b2cSheet,
                b2cData,
                [
                    0
                ]
            );


            XLSX.utils.book_append_sheet(
                workbook,
                b2cSheet,
                'B2C'
            );


            /*
            |--------------------------------------------------------------------------
            | SHEET 4 - HSN SUMMARY
            |--------------------------------------------------------------------------
            */

            let hsnData =
                buildHSNSheet(
                    rows
                );


            let hsnSheet =
                XLSX.utils.aoa_to_sheet(
                    hsnData
                );


            formatWorksheet(
                hsnSheet,
                [

                    15,
                    35,
                    12,
                    12,
                    15,
                    15,
                    15,
                    18

                ]
            );


            /*
            |--------------------------------------------------------------------------
            | HSN = A
            |--------------------------------------------------------------------------
            */

            forceTextColumns(
                hsnSheet,
                hsnData,
                [
                    0
                ]
            );


            XLSX.utils.book_append_sheet(
                workbook,
                hsnSheet,
                'HSN Summary'
            );


            /*
            |--------------------------------------------------------------------------
            | SHEET 5 - CALCULATION
            |--------------------------------------------------------------------------
            */

            let calculationData =
                buildCalculationSheet(
                    rows
                );


            let calculationSheet =
                XLSX.utils.aoa_to_sheet(
                    calculationData
                );


            formatWorksheet(
                calculationSheet,
                [
                    30,
                    20
                ]
            );


            XLSX.utils.book_append_sheet(
                workbook,
                calculationSheet,
                'Calculation'
            );


            /*
            |--------------------------------------------------------------------------
            | SHEET 6 - AUDIT
            |--------------------------------------------------------------------------
            */

            let auditData =
                buildAuditSheet(
                    rows
                );


            let auditSheet =
                XLSX.utils.aoa_to_sheet(
                    auditData
                );


            formatWorksheet(
                auditSheet,
                [
                    30,
                    20,
                    20,
                    20,
                    18
                ]
            );


            XLSX.utils.book_append_sheet(
                workbook,
                auditSheet,
                'Audit'
            );


            return workbook;

        }


        /*
        |--------------------------------------------------------------------------
        | EXCEL EXPORT BUTTON
        |--------------------------------------------------------------------------
        */

        $('#excelBtn').on(
            'click',
            function () {

                let button =
                    $(this);


                /*
                |--------------------------------------------------------------------------
                | PREVENT DOUBLE CLICK
                |--------------------------------------------------------------------------
                */

                if (
                    button.prop('disabled')
                ) {

                    return;

                }


                /*
                |--------------------------------------------------------------------------
                | GET FILTERED DATA
                |--------------------------------------------------------------------------
                */

                let filteredRows =
                    getFilteredReportData();


                /*
                |--------------------------------------------------------------------------
                | NO DATA
                |--------------------------------------------------------------------------
                */

                if (
                    filteredRows.length === 0
                ) {

                    alert(
                        'No GST purchase data available for export.'
                    );

                    return;

                }


                /*
                |--------------------------------------------------------------------------
                | SAVE ORIGINAL BUTTON
                |--------------------------------------------------------------------------
                */

                let originalHtml =
                    button.html();


                /*
                |--------------------------------------------------------------------------
                | LOADING
                |--------------------------------------------------------------------------
                */

                button.prop(
                    'disabled',
                    true
                );


                button.html(
                    '<i class="fas fa-spinner fa-spin"></i> Preparing Excel...'
                );


                /*
                |--------------------------------------------------------------------------
                | GENERATE EXCEL
                |--------------------------------------------------------------------------
                */

                setTimeout(
                    function () {

                        try {

                            /*
                            |--------------------------------------------------------------------------
                            | CREATE 6 SHEETS
                            |--------------------------------------------------------------------------
                            */

                            let workbook =
                                createGSTPurchaseWorkbook(
                                    filteredRows
                                );


                            /*
                            |--------------------------------------------------------------------------
                            | FILE NAME
                            |--------------------------------------------------------------------------
                            */

                            let fromDate =
                                $('#fromDate').val();


                            let toDate =
                                $('#toDate').val();


                            let fileName =
                                'GST_Purchase_Report';


                            /*
                            |--------------------------------------------------------------------------
                            | BOTH DATES
                            |--------------------------------------------------------------------------
                            */

                            if (
                                fromDate &&
                                toDate
                            ) {

                                fileName +=
                                    '_' +
                                    fromDate +
                                    '_to_' +
                                    toDate;

                            }


                            /*
                            |--------------------------------------------------------------------------
                            | FROM ONLY
                            |--------------------------------------------------------------------------
                            */

                            else if (
                                fromDate
                            ) {

                                fileName +=
                                    '_From_' +
                                    fromDate;

                            }


                            /*
                            |--------------------------------------------------------------------------
                            | TO ONLY
                            |--------------------------------------------------------------------------
                            */

                            else if (
                                toDate
                            ) {

                                fileName +=
                                    '_Upto_' +
                                    toDate;

                            }


                            /*
                            |--------------------------------------------------------------------------
                            | NO FILTER
                            |--------------------------------------------------------------------------
                            */

                            else {

                                let now =
                                    new Date();


                                let month =
                                    now.toLocaleString(
                                        'en-US',
                                        {
                                            month: 'long'
                                        }
                                    );


                                let year =
                                    now.getFullYear();


                                fileName +=
                                    '_' +
                                    month +
                                    '_' +
                                    year;

                            }


                            fileName +=
                                '.xlsx';


                            /*
                            |--------------------------------------------------------------------------
                            | DOWNLOAD
                            |--------------------------------------------------------------------------
                            */

                            XLSX.writeFile(
                                workbook,
                                fileName
                            );

                        }
                        catch (error) {

                            console.error(
                                'GST Purchase Excel Export Error:',
                                error
                            );


                            alert(
                                'Unable to generate GST Purchase Excel report. Please try again.'
                            );

                        }


                        /*
                        |--------------------------------------------------------------------------
                        | RESTORE BUTTON
                        |--------------------------------------------------------------------------
                        */

                        button.prop(
                            'disabled',
                            false
                        );


                        button.html(
                            originalHtml
                        );

                    },
                    100
                );

            }
        );


    });

    </script>

@endsection