@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">Bank Reconciliation statement</h3>
                    <div class="d-flex ms-auto">

                    </div>
                </div>
                <div class="card-body">
                    <form method="GET" action="" id="filter" class="mb-3">
                        @csrf
                        <div class="row g-3 align-items-end">
                            {{-- From and To Date --}}
                            <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">
                                    OK
                                </button>
                            </div>
                            <div class="col-md-1">
                            </div>
                            <div class="col-md-1">
                                <label class="form-check-label fw-bold fs-5">
                                    <input type="checkbox" name="clear" id="clear" value="1"
                                        {{ request('clear') ? 'checked' : '' }}> Clear
                                </label>
                            </div>

                            <div class="col-md-1">
                                <label class="form-check-label fw-bold fs-5">
                                    <input type="checkbox" name="unclear" id="unclear" value="1"
                                        {{ request('unclear') ? 'checked' : '' }}> Unclear
                                </label>
                            </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="cqLedger" class="form-label">Bank Entry</label>
                                                <input type="text" id="cqLedger" name="cqLedger" class="form-control"
                                                    placeholder="Search..." value="{{ request('cqLedger') }}" />
                                            </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">Payment Mode</label>
                                                <select name="payment_mode_bank" id="payment_mode_bank"
                                                    class="form-control">
                                                    <option value="">-- Select Payment Mode --</option>
                                                    <option value="cheque_issued"
                                                        {{ request('payment_mode_bank') == 'cheque_issued' ? 'selected' : '' }}>
                                                        Cheque Issued</option>
                                                    <option value="draft_issued"
                                                        {{ request('payment_mode_bank') == 'draft_issued' ? 'selected' : '' }}>
                                                        Draft Issued</option>
                                                    <option value="withdraw_cash_from_bank"
                                                        {{ request('payment_mode_bank') == 'withdraw_cash_from_bank' ? 'selected' : '' }}>
                                                        Withdraw Cash From Bank</option>
                                                    <option value="bank_expense"
                                                        {{ request('payment_mode_bank') == 'bank_expense' ? 'selected' : '' }}>
                                                        Bank Expense</option>
                                                    <option value="online_transfer"
                                                        {{ request('payment_mode_bank') == 'online_transfer' ? 'selected' : '' }}>
                                                        Online Transfer</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" placeholder="Search..."
                                                    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>Deposit</th>
                                    <th>Withdrawal</th>
                                    <th>CLEAR DATE</th> {{-- 👈 Add this --}}
                                </tr>
                            </thead>
                            <tbody id="table-list">
                                @php
                                    $totalDeposit = 0;
                                    $totalWithdrawal = 0;
                                    $paymentModes = [
                                        'cheque_issued' => 'Cheque Issued',
                                        'draft_issued' => 'Draft Issued',
                                        'withdraw_cash_from_bank' => 'Withdraw Cash From Bank',
                                        'bank_expense' => 'Bank Expense',
                                        'online_transfer' => 'Online Transfer',
                                        '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
                                        $deposit =
                                            $voucher->transaction_type === 'Quick Receipt' ? $voucher->net_amount : 0;
                                        $withdrawal =
                                            $voucher->transaction_type === 'Quick Payment' ? $voucher->net_amount : 0;

                                        $totalDeposit += $deposit;
                                        $totalWithdrawal += $withdrawal;
                                    @endphp
                                    <tr>
                                        <td>{{ $voucher->date }}</td>
                                        <td>{{ $voucher->voucher_no }}</td>
                                        <td>{{ $paymentModes[$voucher->payment_mode_bank] ?? 'N/A' }}</td>
                                        <td>{{ $voucher->bankStatement->account->name ?? '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>{{ $deposit > 0 ? number_format($deposit, 2) : '' }}</td>
                                        <td>{{ $withdrawal > 0 ? number_format($withdrawal, 2) : '' }}</td>
                                        <td>
                                            <input type="date" class="clear-date" data-id="{{ $voucher->id }}"
                                                value="{{ $voucher->clear_date }}">
                                        </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 Deposit</h6>
                                    <hr>
                                    <h5 class="text-dark mb-0">₹{{ number_format($totalDeposit, 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 Withdrawal</h6>
                                    <hr>
                                    <h5 class="text-dark mb-0">₹{{ number_format($totalWithdrawal, 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://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.25/jspdf.plugin.autotable.min.js"></script>


    <script>
        $('#clear').on('change', function() {
            if (this.checked) {
                $('#unclear').prop('checked', false);
            }
        });

        $('#unclear').on('change', function() {
            if (this.checked) {
                $('#clear').prop('checked', false);
            }
        });
        $('#clear, #unclear').on('change', function() {
            $(this).closest('form').submit();
        });
        $(document).on('change', '.clear-date', function() {
            let input = $(this);
            let date = input.val();
            let voucherId = input.data('id');

            $.ajax({
                url: '{{ route('admin.reports.update_clear_date') }}',
                method: 'POST',
                data: {
                    _token: '{{ csrf_token() }}',
                    id: voucherId,
                    clear_date: date === '' ? null : date
                },
                success: function(response) {
                    console.log("Clear Date updated");
                },
                error: function(xhr) {
                    console.error("Failed to update clear date");
                }
            });
        });

        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');
        });
    </script>
@endsection