@extends('admin.layouts')
@section('title', 'GSTR-1 (Sales)')
@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') }}">
<link rel="stylesheet" href="{{ asset('/assets/css/datatable/buttons.dataTables.min.css') }}">
<!-- Page CSS -->
<link rel="stylesheet" href="{{ asset('/assets/css/formILY.css') }}">
@endsection
@section('content')
<div class="container-fluid page-wrapper category-container">
    <div class="row align-items-center mb-3">
        <div class="col-12 col-lg-6">
            <h3 class="page-top-heading mb-0">GSTR-1 (Sales)</h3>
        </div>

        <div class="col-12 col-lg-6 text-lg-end mt-2 mt-lg-0">
            <button class="btn btn-success excel-btn">Export to Excel</button>
        </div>
    </div>

    <div class="row mt-4">
        <!-- <div class="row mt-3">
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="fromDate">From Date:</label>
                                            <input type="date" class="form-control" id="fromDate">
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="toDate">To Date:</label>
                                            <input type="date" class="form-control" id="toDate">
                                        </div>
                                    </div>
                                    <div class="col-md-3 d-flex align-items-end justify-content-end">
                                        <button class="btn btn-primary mr-2" id="filterBtn">Filter</button>
                                        <button class="btn btn-secondary" id="resetBtn">Reset</button>
                                    </div>
                                </div> -->
        <div class="row mt-4">
            <div class="col-md-12">
                <div id="totalAmountDisplay" class="total-amount-display">
                </div>
            </div>
        </div>
        <div class="row mt-4">
            <div class="col-lg-12">
                <div class="card datatable-card">
                    <div class="row mt-3 m-2 align-items-end g-2 justify-content-end">
                        <!-- From Date -->
                        <div class="col-12 col-md-3">
                            <label for="fromDate" class="form-label">From Date</label>
                            <input type="date" class="form-control" id="fromDate">
                        </div>
                        <!-- To Date -->
                        <div class="col-12 col-md-3">
                            <label for="toDate" class="form-label">To Date</label>
                            <input type="date" class="form-control" id="toDate">
                        </div>
                        <!-- Buttons -->
                        <div class="col-12 col-md-3 d-flex justify-content-end gap-2">
                            <button class="btn btn-primary w-100 w-md-auto" id="filterBtn">Filter</button>
                            <button class="btn btn-secondary w-100 w-md-auto" id="resetBtn">Reset</button>
                        </div>
                    </div>
                    <div class="card-body">
                        {{-- <table id="salesTable" class="table table-bordered">
                                <thead>
                                    <tr>
                                        <th>#</th>
                                        <th>Customer Name</th>
                                        <th>Invoice Number</th>
                                        <th>Invoice Date</th>
                                        <th>Invoice Value</th>
                                        <th>Total Tax (%)</th>
                                        <th>Taxable Value</th>
                                        <th>CGST</th>
                                        <th>SGST</th>
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($sales as $sale)
                                        @php
                                            $customer = is_string($sale->customer_details)
                                                ? json_decode($sale->customer_details, true) ?? []
                                                : $sale->customer_details ?? [];
                                            $totalCgst = 0;
                                            $totalSgst = 0;
                                            $totalGstPercent = 0;
                                            $totalTaxable = 0;
                                            foreach ($sale->sale_items as $item) {
                                                $productId = $item['item_identifier'] ?? null;
                                                $product = \App\Models\Product::where(
                                                    'product_id',
                                                    $productId,
                                                )->first();
                                                $sellPrice = $item['sell_price'] ?? 0;
                                                $quantity = $item['quantity'] ?? 0;
                                                $taxableValue = $sellPrice * $quantity;
                                                $totalTaxable += $taxableValue;
                                                $cgst = $product->cgst ?? 0;
                                                $sgst = $product->sgst ?? 0;
                                                $totalGstPercent += $cgst + $sgst;
                                                $totalCgst += $cgst;
                                                $totalSgst += $sgst;
                                            }
                                        @endphp
                                        <tr>
                                            <td>{{ $loop->iteration }}</td>
                        <td>{{ $customer['name'] ?? 'N/A' }}</td>
                        <td>{{ $sale->order_id ?? '-' }}</td>
                        <td>{{ $sale->changed_date ? $sale->created_at->format('d-m-Y') : '-' }}</td>
                        <td>₹{{ number_format($sale->amount_payable ?? 0, 2) }}</td>
                        <td>{{ $totalGstPercent }}%</td>
                        <td>₹{{ number_format($totalTaxable, 2) }}</td>
                        <td>₹{{ number_format($totalCgst, 2) }}</td>
                        <td>₹{{ number_format($totalSgst, 2) }}</td>
                        <td>
                            <a href="{{ url('admin/invoice_a4/' . $sale->order_id) }}" target="_blank"
                                class="btn btn-info btn-sm">View Invoice</a>
                        </td>
                        </tr>
                        @endforeach
                        </tbody>
                        </tbody>
                        </table> --}}
                        {{-- ///////////////////////////// --}}
                        {{-- <table id="salesTable" class="table table-bordered">
    <thead>
        <tr>
            <th>#</th>
            <th>Customer Name</th>
            <th>Invoice Number</th>
            <th>Invoice Date</th>
            <th>Invoice Value</th>
            <th>Taxable Value</th>
            <th>CGST</th>
            <th>SGST</th>
            <th>Total Tax</th>
            <th>Action</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($sales as $sale)
            @php
                $customer = is_array($sale->customer_details)
                    ? $sale->customer_details
                    : (json_decode($sale->customer_details, true) ?? []);
            @endphp
            <tr>
                <td>{{ $loop->iteration }}</td>
                        <td>{{ $customer['name'] ?? 'N/A' }}</td>
                        <td>{{ $sale->order_id ?? '-' }}</td>
                        <td>{{ $sale->created_at?->format('d-m-Y') ?? '-' }}</td>
                        <td>₹{{ number_format($sale->amount_payable ?? 0, 2) }}</td>
                        <td>
                            ₹{{ number_format(($sale->amount_payable ?? 0) - ($sale->cgst ?? 0) - ($sale->sgst ?? 0), 2) }}
                        </td>
                        <td>₹{{ number_format($sale->tax_value ?? 0, 2) }}</td>
                        <td>₹{{ number_format($sale->cgst ?? 0, 2) }}</td>
                        <td>₹{{ number_format($sale->sgst ?? 0, 2) }}</td>
                        <td>
                            <a href="{{ url('admin/invoice_a4/' . $sale->order_id) }}"
                                target="_blank"
                                class="btn btn-info btn-sm">
                                View Invoice
                            </a>
                        </td>
                        </tr>
                        @endforeach
                        </tbody>
                        </table> --}}
                        {{-- ///////////////////////////// --}}
                        <table id="salesTable" class="table table-bordered">
                            <thead>
                                <tr class="text-center">
                                    <th>#</th>
                                    <th>Invoice Number</th>
                                    <th>Invoice Date</th>
                                    <th>Invoice Value</th>
                                    {{-- <th>Total Tax(%)</th> --}}
                                    <th>Taxable Value</th>
                                    <th>CGST</th>
                                    <th>SGST</th>
                                    <th>Total Tax Value</th>
                                    <th>Action</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($sales as $sale)
                                @php
                                $items = is_array($sale->sale_items)
                                ? $sale->sale_items
                                : json_decode($sale->sale_items, true);

                                $items = is_array($items) ? $items : [];

                                $gstItems = collect($items)->filter(function ($item) {
                                return (($item['cgst'] ?? 0) + ($item['sgst'] ?? 0)) > 0;
                                });

                                $invoice = $gstItems->sum(fn($i) => ($i['sell_price'] ?? 0) * ($i['quantity'] ?? 1));
                                $cgst = $gstItems->sum('cgst');
                                $sgst = $gstItems->sum('sgst');
                                $totalTax = $cgst + $sgst;
                                $taxable = $invoice - $totalTax;
                                @endphp

                                @if($gstItems->count() > 0)
                                <tr class="text-center">
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ $sale->order_id }}</td>
                                    <td>{{ $sale->created_at?->format('d-m-Y') }}</td>
                                    <td>₹{{ number_format($invoice, 2) }}</td>
                                    <td>₹{{ number_format($taxable, 2) }}</td>
                                    <td>₹{{ number_format($cgst, 2) }}</td>
                                    <td>₹{{ number_format($sgst, 2) }}</td>
                                    <td>₹{{ number_format($totalTax, 2) }}</td>
                                    <td>
                                        <a href="{{ url('admin/invoice_a4/' . $sale->order_id) }}" target="_blank"
                                            class="btn btn-info btn-sm">
                                            View Invoice
                                        </a>
                                    </td>
                                </tr>
                                @endif
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('footer')
<!-- <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script> -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></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/buttons.print.min.js') }}"></script>
<script src="{{ asset('/assets/js/datatable/jszip.min.js') }}"></script>
<script src="{{ asset('/assets/js/datatable/pdfmake.min.js') }}"></script>
<script src="{{ asset('/assets/js/datatable/vfs_fonts.js') }}"></script>
<script>
    $(document).ready(function() {
        var table = $('#salesTable').DataTable({
            responsive: false,
            scrollx: true,
            dom: 'frtip',
            pageLength: 10
        });
        new $.fn.dataTable.Buttons(table, {
            buttons: [{
                    extend: 'excel',
                    className: 'buttons-excel'
                },
                {
                    extend: 'pdf',
                    className: 'buttons-pdf'
                },
                {
                    extend: 'print',
                    className: 'buttons-print'
                }
            ]
        });
        table.buttons().container().appendTo('#salesTable_wrapper .col-md-6:eq(0)').hide();
        $('.excel-btn').on('click', function() {
            table.button('.buttons-excel').trigger();
        });
        $.fn.dataTable.ext.search.push(function(settings, data, dataIndex) {
            let fromDate = $('#fromDate').val();
            let toDate = $('#toDate').val();
            let dateText = data[3];
            if (!fromDate && !toDate) return true;
            let parts = dateText.split("-");
            let rowDate = new Date(parts[2], parts[1] - 1, parts[0]);
            if (fromDate && rowDate < new Date(fromDate)) return false;
            if (toDate && rowDate > new Date(toDate)) return false;
            return true;
        });
        $('#filterBtn').click(() => table.draw());
        $('#resetBtn').click(() => {
            $('#fromDate,#toDate').val("");
            table.draw();
        });

        function updateTotals() {
            let totalAmount = 0;
            table.rows({
                search: 'applied'
            }).every(function() {
                let raw = this.data()[4].replace('₹', '').replace(/,/g, '').trim();
                totalAmount += parseFloat(raw);
            });
            $('#totalAmountDisplay').html(
                `<strong>Total Invoice Value:</strong> ₹${totalAmount.toLocaleString('en-IN',{minimumFractionDigits:2})}`
            );
        }
        table.on('draw.dt', updateTotals);
        updateTotals();
    });
</script>
@endsection