@extends('layouts.admin')
@section('title', 'Product | Mintavia Admin')
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
<style>
    .card {
        border-radius: 10px;
    }

    .card-body h5 {
        font-size: 1.5rem;
        font-weight: bold;
    }

    .table-responsive {
        max-height: 550px;
        /* Adjust height as needed */
        overflow-y: auto;
    }

    .table thead th {
        position: sticky;
        top: 0;
        background: white;
        z-index: 1000;
    }
</style>
@section('content')
    <div class="row">
        <div class="col-12">
            @if (isset($message) && $message)
                <script>
                    window.onload = function() {
                        @if ($message['status'] === 'success')
                            toastr.success("{{ $message['message'] }}");
                        @elseif ($message['status'] === 'error')
                            toastr.error("{{ $message['message'] }}");
                        @endif
                    };
                </script>
            @endif

            <div class="card card-primary">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h3 class="card-title mb-0">Cash & Bank Receipt Register</h3>
                </div>

                <div class="card-body">
                    <form method="GET" action="" id="filter" class="mb-3">
                        @csrf
                        <div class="row g-3 align-items-end">
                            <div class="col-md-2">
                                <x-admin-input type="date" name="fromDate" id="from-date"
                                    value="{{ request('fromDate') }}" label="From Date" />
                            </div>
                            <div class="col-md-2">
                                <x-admin-input type="date" name="toDate" id="to-date" value="{{ request('toDate') }}"
                                    label="To Date" />
                            </div>
                            <div class="col-md-1">
                                <button class="btn btn-success w-100" type="submit" id="ok-button">
                                    OK
                                </button>
                            </div>
                            <div class="col-md-3">

                            </div>
                            <div class="col-md-1">
                                <div class="dropdown">
                                    <button class="btn btn-primary dropdown-toggle w-100" type="button" id="searchDropdown"
                                        data-bs-toggle="dropdown" aria-expanded="false">
                                        <i class="fas fa-search"></i> Search
                                    </button>
                                    <div class="dropdown-menu p-3" style="min-width: 300px;"
                                        aria-labelledby="searchDropdown">

                                        <div class="mb-2 d-flex">
                                            <div class="flex-grow-1 me-2">
                                                <label for="voucher_no" class="form-label">Receipt No.</label>
                                                <input type="text" id="voucher_no" name="voucher_no" class="form-control"
                                                    placeholder="Search..." value="{{ request('voucher_no') }}" />
                                            </div>
                                            <button type="submit" class="btn btn-sm btn-success align-self-end"><i
                                                    class="fas fa-search"></i></button>
                                        </div>

                                        <div class="mb-2 d-flex">
                                            <div class="flex-grow-1 me-2">
                                                <label for="drLedger" class="form-label">Payment Mode</label>
                                                <input type="text" id="drLedger" name="drLedger" class="form-control"
                                                    placeholder="Search..." value="{{ request('drLedger') }}" />
                                            </div>
                                            <button type="submit" class="btn btn-sm btn-success align-self-end"><i
                                                    class="fas fa-search"></i></button>
                                        </div>

                                        <div class="mb-2 d-flex">
                                            <div class="flex-grow-1 me-2">
                                                <label for="payment_mode_bank" class="form-label">Bank Entry</label>
                                                <select name="payment_mode_bank" id="payment_mode_bank"
                                                    class="form-control">
                                                    <option value="">-- Select Payment Mode --</option>
                                                    <option value="1"
                                                        {{ request('payment_mode_bank') == '1' ? 'selected' : '' }}>Cheque
                                                        Received</option>
                                                    <option value="2"
                                                        {{ request('payment_mode_bank') == '2' ? 'selected' : '' }}>Draft
                                                        Received</option>
                                                    <option value="3"
                                                        {{ request('payment_mode_bank') == '3' ? 'selected' : '' }}>Received
                                                        Cash into Bank</option>
                                                    <option value="4"
                                                        {{ request('payment_mode_bank') == '4' ? 'selected' : '' }}>Bank
                                                        Transfer from Another Account</option>
                                                    <option value="5"
                                                        {{ request('payment_mode_bank') == '5' ? 'selected' : '' }}>Credit
                                                        Card Payment Received</option>
                                                    <option value="6"
                                                        {{ request('payment_mode_bank') == '6' ? 'selected' : '' }}>Online
                                                        Transfer</option>
                                                </select>
                                            </div>
                                            <button type="submit" class="btn btn-sm btn-success align-self-end"><i
                                                    class="fas fa-search"></i></button>
                                        </div>

                                        <div class="mb-2 d-flex">
                                            <div class="flex-grow-1 me-2">
                                                <label for="account" class="form-label">Party Name</label>
                                                <input type="text" id="account" name="account" class="form-control"
                                                    placeholder="Search..." value="{{ request('account') }}" />
                                            </div>
                                            <button type="submit" class="btn btn-sm btn-success align-self-end"><i
                                                    class="fas fa-search"></i></button>
                                        </div>

                                        <div class="mb-2 d-flex">
                                            <div class="flex-grow-1 me-2">
                                                <label for="cheque_number" class="form-label">Cheque No</label>
                                                <input type="text" id="cheque_number" name="cheque_number"
                                                    class="form-control" placeholder="Search..."
                                                    value="{{ request('cheque_number') }}" />
                                            </div>
                                            <button type="submit" class="btn btn-sm btn-success align-self-end"><i
                                                    class="fas fa-search"></i></button>
                                        </div>

                                        <div class="mb-2 d-flex">
                                            <div class="flex-grow-1 me-2">
                                                <label for="cheque_date" class="form-label">Cheque Date</label>
                                                <input type="date" id="cheque_date" name="cheque_date"
                                                    class="form-control" value="{{ request('cheque_date') }}" />
                                            </div>
                                            <button type="submit" class="btn btn-sm btn-success align-self-end"><i
                                                    class="fas fa-search"></i></button>
                                        </div>

                                        <div class="mb-2 d-flex">
                                            <div class="flex-grow-1 me-2">
                                                <label for="net_amount" class="form-label">Amount</label>
                                                <input type="text" id="net_amount" name="net_amount"
                                                    class="form-control" placeholder="Search..."
                                                    value="{{ request('net_amount') }}" />
                                            </div>
                                            <button type="submit" class="btn btn-sm btn-success align-self-end"><i
                                                    class="fas fa-search"></i></button>
                                        </div>

                                        <div class="mb-2 d-flex">
                                            <div class="flex-grow-1 me-2">
                                                <label for="narration" class="form-label">Narration</label>
                                                <input type="text" id="narration" name="narration"
                                                    class="form-control" placeholder="Search..."
                                                    value="{{ request('narration') }}" />
                                            </div>
                                            <button type="submit" class="btn btn-sm btn-success align-self-end"><i
                                                    class="fas fa-search"></i></button>
                                        </div>

                                        <div class="mb-2 d-flex">
                                            <div class="flex-grow-1 me-2">
                                                <label for="bill_discount_amount" class="form-label">Discount</label>
                                                <input type="text" id="bill_discount_amount"
                                                    name="bill_discount_amount" class="form-control"
                                                    placeholder="Search..."
                                                    value="{{ request('bill_discount_amount') }}" />
                                            </div>
                                            <button type="submit" class="btn btn-sm btn-success align-self-end"><i
                                                    class="fas fa-search"></i></button>
                                        </div>

                                        <div class="mb-2 d-flex">
                                            <div class="flex-grow-1 me-2">
                                                <label for="expenses" class="form-label">Expenses</label>
                                                <input type="text" id="expenses" name="expenses"
                                                    class="form-control" placeholder="Search..."
                                                    value="{{ request('expenses') }}" />
                                            </div>
                                            <button type="submit" class="btn btn-sm btn-success align-self-end"><i
                                                    class="fas fa-search"></i></button>
                                        </div>

                                    </div>
                                </div>
                            </div>
                            <div class="col-md-1">
                                <button type="button" class="btn btn-success w-100" id="excel-export">
                                    <i class="fas fa-file-excel"></i>Excel
                                </button>
                            </div>
                            <div class="col-md-1">
                                <button type="button" class="btn btn-warning w-100" id="pdf-print">
                                    <i class="fas fa-file-pdf"></i> PDF
                                </button>
                            </div>
                            <div class="col-md-1">
                                <a href="{{ route('admin.dashboard') }}" class="btn btn-danger w-100">
                                    <i class="fa fa-arrow-circle-left"></i> Exit
                                </a>
                            </div>
                        </div>
                    </form>

                    <div class="table-responsive">
                        <table class="table table-sm table-bordered table-hover text-center" id="BankPaymentRegister">
                            <thead class="thead-light">
                                <tr>
                                    <th>Date</th>
                                    <th>Receipt No.</th>
                                    <th>Payment Mode</th>
                                    <th>Bank Entry</th>
                                    <th>Party Name</th>
                                    <th>Cheque No</th>
                                    <th>Cheque Date</th>
                                    <th>Narration</th>
                                    <th>Amount</th>
                                    <th>Discount</th>
                                    <th>Expenses</th>
                                    <th>Total Amt.</th>
                                    <th>Action</th> {{-- 👈 Add this --}}
                                </tr>
                            </thead>
                            <tbody id="table-list">
                                @php
                                    $totalAmount = 0;
                                    $totalDiscount = 0;
                                    $totalExpenses = 0;
                                    $grandTotal = 0;
                                    $paymentModes = [
                                        '1' => 'Cheque Received',
                                        '2' => 'Draft Received',
                                        '3' => 'Received Cash into Bank',
                                        '4' => 'Bank Transfer from Another Account',
                                        '5' => 'Credit Card Payment Received',
                                        '6' => 'Online Transfer',
                                    ];
                                @endphp
                                @foreach ($vouchers as $voucher)
                                    @php
                                        $rowTotal =
                                            $voucher->net_amount - $voucher->bill_discount_amount - $voucher->expenses;
                                        $totalAmount += $rowTotal;
                                    @endphp
                                    @php
                                        $totalAmount += $voucher->net_amount;
                                        $totalDiscount += $voucher->bill_discount_amount;
                                        $totalExpenses += $voucher->expenses;
                                        $grandTotal +=
                                            $voucher->net_amount - $voucher->bill_discount_amount - $voucher->expenses;
                                    @endphp
                                    <tr>
                                        <td>{{ \Carbon\Carbon::parse($voucher->date)->format('d/m/Y') }}</td>
                                        <td>{{ $voucher->voucher_no }}</td>
                                        <td>{{ $voucher->drLedger->account->name ?? 'N/A' }}</td>
                                        <td>{{ $paymentModes[$voucher->payment_mode_bank] ?? 'N/A' }}</td>
                                        <td>{{ $voucher->account->name ?? 'N/A' }}</td>
                                        <td>{{ $voucher->cheque_number }}</td>
                                        <td>{{ $voucher->cheque_date }}</td>
                                        <td>{{ $voucher->narration }}</td>
                                        <td>{{ number_format($voucher->net_amount, 2) }}</td>
                                        <td>{{ number_format($voucher->bill_discount_amount, 2) }}</td>
                                        <td>{{ number_format($voucher->expenses, 2) }}</td>
                                        <td>{{ number_format($rowTotal, 2) }}</td>
                                        <td>
                                            <a href="{{ route('admin.quick_receipt_edit', $voucher->id) }}"
                                                class="btn btn-sm btn-primary"><i class="fas fa-edit"></i></a>
                                            {{-- View Button --}}
                                            <a href="" class="btn btn-sm btn-info" title="View">
                                                <i class="fas fa-eye"></i>
                                            </a>

                                            {{-- Print Button --}}
                                            <a href="" class="btn btn-sm btn-secondary" title="Print"
                                                target="_blank">
                                                <i class="fas fa-print"></i>
                                            </a>
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>

                        </table>
                    </div>
                    <div class="row justify-content-end mt-4">
                        <div class="col-md-3">
                            <div class="card shadow-sm border-primary">
                                <div class="card-body text-center">
                                    <h6 class="text-primary">Total Amount</h6>
                                    <hr>
                                    <h5 class="text-dark mb-0">₹{{ number_format($totalAmount, 2) }}</h5>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card shadow-sm border-warning">
                                <div class="card-body text-center">
                                    <h6 class="text-warning">Total Discount</h6>
                                    <hr>
                                    <h5 class="text-dark mb-0">₹{{ number_format($totalDiscount, 2) }}</h5>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card shadow-sm border-success">
                                <div class="card-body text-center">
                                    <h6 class="text-success">Total Expenses</h6>
                                    <hr>
                                    <h5 class="text-dark mb-0">₹{{ number_format($totalExpenses, 2) }}</h5>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card shadow-sm border-danger">
                                <div class="card-body text-center">
                                    <h6 class="text-danger">Grand Total</h6>
                                    <hr>
                                    <h5 class="text-dark mb-0">₹{{ number_format($grandTotal, 2) }}</h5>
                                </div>
                            </div>
                        </div>
                    </div>

                </div>
            </div>
        </div>

    </div>
@endsection


@section('js')
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
    <script src="https://cdn.sheetjs.com/xlsx-latest/package/dist/xlsx.full.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.25/jspdf.plugin.autotable.min.js"></script>


    <script>
        document.getElementById('pdf-print').addEventListener('click', function() {
            const {
                jsPDF
            } = window.jspdf;
            const doc = new jsPDF();

            doc.autoTable({
                html: '#BankPaymentRegister'
            }); // Replace with your table ID

            doc.save('exported_data.pdf');
        });

        document.getElementById('excel-export').addEventListener('click', function() {
            const table = document.getElementById('BankPaymentRegister'); // Replace with your actual table ID
            const workbook = XLSX.utils.table_to_book(table, {
                sheet: "Sheet1"
            });
            XLSX.writeFile(workbook, 'exported_data.xlsx');
        });

        $(document).ready(function() {
            const table = $('#your-table-id').DataTable(); // Replace with your actual table ID

            $('#apply-filter').click(function() {
                const column = $('#filter-column').val();
                const value = $('#filter-value').val();

                // Column index mapping
                const columnIndexMap = {
                    date: 0,
                    receipt_no: 1,
                    payment_mode: 2,
                    bank_entry: 3,
                    party_name: 4,
                    cheque_no: 5,
                    cheque_date: 6,
                    narration: 7,
                    amount: 8,
                    discount: 9,
                    expenses: 10
                };

                const columnIndex = columnIndexMap[column];

                table.columns().search(""); // Clear all
                table.column(columnIndex).search(value).draw();
            });
        });
    </script>
@endsection