@extends('sub-admin.layout.subadmin')
@section('title', 'Payments Report')
@section('content')
<style>
    .page-wrapper {
        display: block !important;
    }
</style>
<div class="container mt-5">
    <h1 class="heading_sub">Payments Report</h1>
    <div class="mb-3">
        <label for="package-filter" class="form-label">Filter by Package:</label>
        <select class="form-select" id="package-filter">
            <option value="">All</option>
            <option value="annual">Annual</option>
            <option value="benevolent">Benevolent</option>
        </select>
    </div>
    <div class="mb-3">
        <label for="status-filter" class="form-label">Filter by Payment Status:</label>
        <select class="form-select" id="status-filter">
            <option value="">All</option>
            <option value="success">Success</option>
            <option value="failed">Failed</option>
            <option value="pending">Pending Approval</option>
        </select>
    </div>
    <table id="payments-table" class="table table-striped table-bordered" style="width:100%">
        <thead>
            <tr>
                <th>ID</th>
                <th>User Name</th>
                <th>Package Name</th>
                <th>Payment Type</th>
                <th>Receipt Number</th>
                <th>Receipt Document</th>
                <th>Payment Status</th>
                <th>Amount</th>
                <th>Date</th>
                {{-- <th>Actions</th> --}}
            </tr>
        </thead>
        <tbody>
            @foreach($payments as $payment)
            <tr>
                <td>{{ $payment->id }}</td>
                <td>{{ $payment->user->name }}</td>
                <td>{{ $payment->package_name }}</td>
                <td>{{ $payment->payment_type }}</td>
                <td>{{ $payment->main_receipt_id }}</td>
                <td>
                    @if (empty($payment->receipt_document))
                    {{ 'N/A' }}
                    @elseif (pathinfo($payment->receipt_document, PATHINFO_EXTENSION) === 'pdf')
                    <a href="{{ asset($payment->receipt_document) }}" target="_blank">View Document</a>
                    @else
                    <img src="{{ asset($payment->receipt_document) }}" alt="Receipt Document" style="max-width: 100px;">
                    @endif
                </td>
                <td>{{ $payment->payment_status }}</td>
                <td>{{ $payment->amount }}</td>
                <td>{{ $payment->created_at }}</td>
                {{-- <td>
                    <a href="{{ route('sub.payments.show', $payment->id) }}" class="btn btn-primary btn-sm">View</a>
                </td> --}}
            </tr>
            @endforeach
        </tbody>
    </table>
</div>

@endsection

@push('scripts')
<script src="https://cdn.datatables.net/1.10.24/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.24/js/dataTables.bootstrap4.min.js"></script>
<script>
    $(document).ready(function () {
        var dataTable = $('#payments-table').DataTable({
            "paging": true,
            "lengthChange": false,
            "searching": true,
            "ordering": true,
            "info": true,
            "autoWidth": false,
        });

        // Event listener for package filter dropdown
        $('#package-filter').on('change', function () {
            var packageName = $(this).val();
            var status = $('#status-filter').val();
            updateDataTableFilters(packageName, status);
        });

        // Event listener for status filter dropdown
        $('#status-filter').on('change', function () {
            var packageName = $('#package-filter').val();
            var status = $(this).val();
            updateDataTableFilters(packageName, status);
        });

        function updateDataTableFilters(packageName, status) {
            dataTable.column(2).search(packageName).draw(); // Filter by Package Name
            dataTable.column(6).search(status).draw(); // Filter by Payment Status
        }
    });
</script>
@endpush