@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">Cash & Bank Payment Register</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-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="cqLedger" class="form-label">Payment Mode</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">Bank Entry</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>
                                                </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="download-pdf">
                                    <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 = [
                                        'cheque_issued' => 'Cheque Issued',
                                        'draft_issued' => 'Draft Issued',
                                        'withdraw_cash_from_bank' => 'Withdraw Cash From Bank',
                                        'bank_expense' => 'Bank Expense',
                                        'online_transfer' => '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->cqLedger->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_payment_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 src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
    <!-- html2canvas -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/1.4.1/html2canvas.min.js"></script>

    <script>
        $('#download-pdf').on('click', function() {
            const {
                jsPDF
            } = window.jspdf;
            const $table = $('#BankPaymentRegister');

            // Capture table with html2canvas
            html2canvas($table[0], {
                scale: 2
            }).then(function(canvas) {
                const imgData = canvas.toDataURL('image/png');
                const pdf = new jsPDF({
                    orientation: 'landscape', // or 'portrait'
                    unit: 'mm',
                    format: 'a4'
                });

                const imgWidth = 280; // A4 width in mm (landscape)
                const pageHeight = 210; // A4 height in mm (landscape)
                const imgHeight = canvas.height * imgWidth / canvas.width;
                let heightLeft = imgHeight;

                let position = 0;

                // Add image to PDF
                pdf.addImage(imgData, 'PNG', 10, 10, imgWidth, imgHeight);
                heightLeft -= pageHeight;

                // Handle multi-page tables
                while (heightLeft >= 0) {
                    position = heightLeft - imgHeight;
                    pdf.addPage();
                    pdf.addImage(imgData, 'PNG', 10, position, imgWidth, imgHeight);
                    heightLeft -= pageHeight;
                }

                // Download the PDF
                pdf.save('bootstrap-table.pdf');
            });
        });


        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