@extends('admin.layouts')

@section('title', 'GST Sales History')

@section('header')

<link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/dataTables.bootstrap5.min.css">
<link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/responsive.bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/datatable/buttons.dataTables.min.css">
<link rel="stylesheet" type="text/css" href="{{ asset('/assets') }}/css/formILY.css">
<link rel="stylesheet" href="{{ asset('assets/css/bootstrap.min.css') }}">

<style>
    .report-total-card {
        border-radius: 12px;
        padding: 14px 18px;
        background: #fff;
        border: 1px solid #e9ecef;
    }

    .report-total-card .label {
        font-size: 13px;
        color: #6c757d;
    }

    .report-total-card .amount {
        font-size: 21px;
        font-weight: 700;
    }
</style>

@endsection


@section('content')

<div class="container-fluid page-wrapper category-container">

    {{-- =========================================================
         PAGE HEADING
    ========================================================== --}}

    <div class="row">

        <div class="d-flex justify-content-between align-items-center flex-wrap gap-2">

            <h3 class="page-top-heading mb-0">
                GST Sales History
            </h3>

            <div class="text-muted">
                GST Return Report From 01-Aug-2026
            </div>

        </div>

    </div>


    {{-- =========================================================
         CURRENT MONTH TOTAL
    ========================================================== --}}

    <div class="row mt-3 g-3">

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

           <div class="report-total-card">

    <div class="label">

        @if(request('from_date') && request('to_date'))

            Filtered GST Sales Total

        @elseif(request('phone'))

            Filtered GST Sales Total

        @else

            Current Month GST Sales Total

        @endif

    </div>


    <div class="amount">

        ₹{{ number_format($currentMonthTotal ?? 0, 2) }}

    </div>

</div>

        </div>

    </div>


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

    <div class="row mt-3">

        <div class="col-lg-12">

            <div class="card m-0 datatable-card">


                {{-- =========================================================
                     FILTERS
                ========================================================== --}}

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


                    {{-- FROM DATE --}}
                    <div class="col-12 col-sm-6 col-md-3">

                        <label
                            for="fromDate"
                            class="form-label"
                        >
                            From Date
                        </label>

                        <input
                            type="date"
                            class="form-control"
                            id="fromDate"
                            min="2026-08-01"
                            value="{{ request('from_date') }}"
                        >

                    </div>


                    {{-- TO DATE --}}
                    <div class="col-12 col-sm-6 col-md-3">

                        <label
                            for="toDate"
                            class="form-label"
                        >
                            To Date
                        </label>

                        <input
                            type="date"
                            class="form-control"
                            id="toDate"
                            min="2026-08-01"
                            value="{{ request('to_date') }}"
                        >

                    </div>


                    {{-- PHONE --}}
                    <div class="col-12 col-md-2">

                        <label
                            for="phoneSearch"
                            class="form-label"
                        >
                            Search Phone No
                        </label>

                        <input
                            type="text"
                            id="phoneSearch"
                            class="form-control"
                            placeholder="Enter phone number"
                            value="{{ request('phone') }}"
                        >

                    </div>


                    {{-- FILTER --}}
                    <div class="col-6 col-md-2">

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

                    </div>


                    {{-- RESET --}}
                    <div class="col-6 col-md-2">

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

                    </div>

                </div>


                {{-- =========================================================
                     EXCEL EXPORT
                ========================================================== --}}

                <div class="card-header bg-white border-bottom d-flex justify-content-end">

                    <button
                        type="button"
                        class="btn btn-success excel-btn"
                    >
                        Export to Excel
                    </button>

                </div>


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

                <div class="card-body">

                    <div class="table-responsive">

                        <table
                            id="data-table"
                            class="table align-middle mb-0 w-100"
                        >

                            <thead>

                                <tr>

                                    <th>GST SN</th>

                                    <th>GST ORDER ID</th>

                                    <th>NAME</th>

                                    <th>USER ID</th>

                                    <th>PHONE No</th>

                                    <th>DATE</th>

                                    <th>MEMBERSHIP</th>

                                    <th>PAYMENT MODE</th>

                                    <th>REMARK</th>

                                    <th>GST AMOUNT</th>

                                    <th>ACTION</th>

                                </tr>

                            </thead>


                            <tbody>

                                @forelse ($gstSales as $index => $sale)

                                    <tr>

                                        <td>
                                            {{ $index + 1 }}
                                        </td>


                                        <td>
                                            {{ $sale->report_order_id }}
                                        </td>


                                        <td>
                                            {{ $sale->user->name ?? 'N/A' }}
                                        </td>


                                        <td>
                                            {{ $sale->user_id }}
                                        </td>


                                        <td>
                                            {{ preg_replace('/\D/', '', $sale->user->phone_number ?? '') }}
                                        </td>


                                        <td>
                                            {{ $sale->report_date->format('Y-m-d') }}
                                        </td>


                                        <td>
                                            {{ $sale->user->membership ?? 'N/A' }}
                                        </td>


                                        <td>
                                            {{ $sale->payment_mode ?? 'N/A' }}
                                        </td>


                                        <td>
                                            {{ $sale->status ?? 'N/A' }}
                                        </td>


                                        <td>
                                            ₹{{ number_format($sale->report_amount ?? 0, 2) }}
                                        </td>


                                        <td>

                                            <a
                                                href="{{ url('admin/invoice_a4/' . $sale->report_order_id) }}"
                                                target="_blank"
                                                rel="noopener"
                                                class="btn btn-info btn-sm"
                                            >
                                                View Invoice
                                            </a>

                                        </td>

                                    </tr>

                                @empty

                                    <tr>

                                        <td
                                            colspan="11"
                                            class="text-center"
                                        >
                                            No GST sales records found.
                                        </td>

                                    </tr>

                                @endforelse

                            </tbody>

                        </table>

                    </div>

                </div>

            </div>

        </div>

    </div>

</div>

@endsection


@section('footer')

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

<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>
<script src="{{ asset('/assets') }}/js/datatable/dataTables.buttons.min.js"></script>
<script src="{{ asset('/assets') }}/js/datatable/buttons.html5.min.js"></script>
<script src="{{ asset('/assets') }}/js/datatable/jszip.min.js"></script>


<script>

$(function () {

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

    const table = $('#data-table').DataTable({

        dom:
            '<"row mb-3"' +
                '<"col-12 col-md-6"B>' +
                '<"col-12 col-md-6 d-flex justify-content-md-end"f>' +
            '>' +
            'rt' +
            '<"row mt-3"' +
                '<"col-12 col-md-6"i>' +
                '<"col-12 col-md-6 d-flex justify-content-md-end"p>' +
            '>',


        buttons: [

            {

                extend: 'excelHtml5',

                className: 'buttons-excel d-none',

                filename: 'gst_sales_history',

                title: 'GST Sales History',

                exportOptions: {

                    columns: ':visible:not(:last-child)'

                }

            }

        ],


        /*
        |--------------------------------------------------------------------------
        | DATE COLUMN INDEX = 5
        |--------------------------------------------------------------------------
        */

        order: [
            [5, 'desc']
        ],


        responsive: true,


        pageLength: 10,


        lengthMenu: [
            10,
            25,
            50,
            100
        ]

    });


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

    $('.excel-btn').on('click', function () {

        table
            .button('.buttons-excel')
            .trigger();

    });


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

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

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

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

        const phone =
            $('#phoneSearch')
                .val()
                .trim();


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

        if (
            (fromDate && !toDate)
            ||
            (!fromDate && toDate)
        ) {

            alert(
                'Please select both From Date and To Date.'
            );

            return;
        }


        /*
        |--------------------------------------------------------------------------
        | REPORT START DATE VALIDATION
        |--------------------------------------------------------------------------
        */

        if (
            fromDate
            &&
            fromDate < '2026-08-01'
        ) {

            alert(
                'GST report is available only from 01-Aug-2026.'
            );

            return;
        }


        /*
        |--------------------------------------------------------------------------
        | DATE ORDER VALIDATION
        |--------------------------------------------------------------------------
        */

        if (
            fromDate
            &&
            toDate
            &&
            fromDate > toDate
        ) {

            alert(
                'From Date cannot be greater than To Date.'
            );

            return;
        }


        /*
        |--------------------------------------------------------------------------
        | BUILD QUERY STRING
        |--------------------------------------------------------------------------
        */

        const params =
            new URLSearchParams();


        if (
            fromDate
            &&
            toDate
        ) {

            params.set(
                'from_date',
                fromDate
            );

            params.set(
                'to_date',
                toDate
            );

        }


        if (phone) {

            params.set(
                'phone',
                phone
            );

        }


        /*
        |--------------------------------------------------------------------------
        | REDIRECT
        |--------------------------------------------------------------------------
        */

        window.location.href =
            "{{ route('gst_sales_history') }}"
            +
            (
                params.toString()
                    ? '?' + params.toString()
                    : ''
            );

    });


    /*
    |--------------------------------------------------------------------------
    | RESET
    |--------------------------------------------------------------------------
    |
    | Reset URL has no filters.
    | Controller will automatically show current month.
    |
    */

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

        window.location.href =
            "{{ route('gst_sales_history') }}";

    });

});

</script>

@endsection