@extends('layouts.admin')
@section('content')
<!-- start page title -->
<div class="row">
    <div class="col-12">
        <div class="page-title-box d-sm-flex align-items-center justify-content-between bg-galaxy-transparent">
            <h4 class="mb-sm-0">Subscriptions</h4>

            <div class="page-title-right">
                <ol class="breadcrumb m-0">
                    <li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
                    <li class="breadcrumb-item active">Subscriptions</li>
                </ol>
            </div>
        </div>
    </div>
</div>
<!-- end page title -->

<div class="row">
    <div class="col-lg-12">
        <div class="card" id="orderList">
            <div class="card-header border-0">
                <div class="row align-items-center gy-3">
                    <div class="col-sm">
                        <h5 class="card-title mb-0">Subscriptions</h5>
                    </div>
                    <div class="col-sm-auto">
                        <div class="d-flex gap-2 flex-wrap align-items-center">
                            <a type="button" class="btn btn-info" href="{{ route('admin.subscriptions.export') }}">
                                <i class="ri-file-download-line align-bottom me-1"></i> Export
                            </a>

                            <select id="statusFilter" class="form-select form-select-sm" style="width: auto;">
                                <option value="">All Statuses</option>
                                <option value="active">Active</option>
                                <option value="past_due">Past Due</option>
                                <option value="canceled">Canceled</option>
                                <option value="incomplete">Incomplete</option>
                                <option value="incomplete_expired">Incomplete Expired</option>
                                <option value="trialing">Trialing</option>
                                <option value="unpaid">Unpaid</option>
                                <option value="expired">Expired</option>

                            </select>

                            <button class="btn btn-soft-danger" id="remove-actions" onClick="deleteMultiple()">
                                <i class="ri-delete-bin-2-line"></i>
                            </button>
                        </div>
                    </div>

                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table id="subscriptionsTable" class="table table-bordered nowrap align-middle" style="width: 100%;">
                        <thead class="">
                            <tr class="text-uppercase">
                                <th>Sl No</th>
                                <th>User Name</th>
                                <th>User Email</th>
                                <th>Plan</th>
                                <th>Interval</th>
                                <th>Price</th>
                                <th>Currency</th>
                                <th>Status</th>
                                <th>Current Period Start</th>
                                <th>Current Period End</th>
                                <th>Canceled At</th>
                                <th>Actions</th>

                            </tr>
                        </thead>
                        <tbody class="list form-check-all">
                            @foreach ($subscriptions as $subscription)
                            <tr>
                                <td class="id">{{ $loop->iteration }}</td>

                                <td>{{ $subscription->user?->name ?? '-' }}</td>
                                <td>{{ $subscription->user?->email ?? '-' }}</td>
                                <td>{{ $subscription->plan?->name ?? '-' }}</td>
                                <td>{{ $subscription->interval }}</td>
                                <td>{{ $subscription->price }}</td>
                                <td>{{ $subscription->currency }}</td>
                                <td>{{ $subscription->status }}</td>
                                <td>{{ $subscription->current_period_start }}</td>
                                <td>{{ $subscription->current_period_end }}</td>
                                <td>{{ $subscription->canceled_at }}</td>
                                <td>
                                    <div class="dropdown">
                                        <a href="#" class="btn btn-soft-secondary btn-sm" role="button" id="dropdownMenuLink5" data-bs-toggle="dropdown" aria-expanded="false">
                                            <i class="ri-more-2-fill"></i>
                                        </a>

                                        <ul class="dropdown-menu" aria-labelledby="dropdownMenuLink5">
                                            <li><a class="dropdown-item" href="{{ route('admin.subscriptions.details', $subscription->id) }}">Show</a></li>
                                        </ul>
                                    </div>
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <!--end col-->
</div>
<!--end row-->

<!-- /.modal -->

@endsection
@section('script')
<script src="https://cdn.jsdelivr.net/npm/jquery-validation@1.19.5/dist/jquery.validate.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/jquery-validation@1.19.5/dist/additional-methods.min.js"></script>

<script>
    $(document).ready(function() {
        // Initialize DataTable once
        var table = $('#subscriptionsTable').DataTable({
            responsive: true,
            paging: true,
            searching: true,
            ordering: true,
            lengthChange: true,
        });

        // Custom filter for status dropdown
        $('#statusFilter').on('change', function() {
            var value = $(this).val();
            if (value) {
                // Filter by exact match in Status column (8th column, zero-indexed 7)
                table.column(7).search('^' + value + '$', true, false).draw();
            } else {
                // Show all if empty
                table.column(7).search('').draw();
            }
        });
    });
</script>




@endsection