@extends('backend.layouts.master')
@section('content')
<div class="content-wrapper">
    <section class="content-header">
        @include('backend.common-views.messages')
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="{{ route('admin.home') }}">Home</a></li>
                        <li class="breadcrumb-item active">Expire Subscription Details</li>
                    </ol>
                </div>
            </div>
        </div>
    </section>
    <section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header">
                            <h3 class="card-title">Subscription To Be Expired In Next 7 Days</h3>
                        </div>
                        <div class="card-body">
                            <table id="example1" class="table table-bordered table-striped">
                                <thead>
                                    <tr>
                                        <th style="width:5%;">SR No</th>
                                        <th style="width:10%">User Name </th>
                                        <th style="width:10%;">Subscription Start Date</th>
                                        <th style="width:10%;">Subscription End Date</th>
                                        <th style="width:10%;">Mobile No.</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $i=0;
                                    @endphp
                                    @foreach ($subscriptions as $subscription)
                                        <tr>
                                            <td>{{++$i}}</td>
                                            <td>{{$subscription->name}}</td>
                                            <td data-order="{{ date('Y-m-d', strtotime($subscription->subscription_start_date)) }}">
                                                @if(!empty($subscription->subscription_start_date))
                                                    {{date("d-m-Y", strtotime($subscription->subscription_start_date)) }}
                                                @else
                                                    -
                                                @endif
                                            </td>
                                            <td data-order="{{ date('Y-m-d', strtotime($subscription->subscription_end_date)) }}">
                                                @if(!empty($subscription->subscription_end_date))
                                                    {{date("d-m-Y", strtotime($subscription->subscription_end_date)) }}
                                                @else
                                                    -
                                                @endif
                                            </td>
                                            <td>
                                                @if (!empty( $subscription->phone_no))
                                                    {{ $subscription->phone_no}}
                                                @else
                                                    -
                                                @endif
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header">
                            <h3 class="card-title">Expired Subscription Details</h3>
                        </div>
                        <div class="card-body">
                            <table id="example2" class="table table-bordered table-striped">
                                <thead>
                                    <tr>
                                        <th style="width:5%;">SR No</th>
                                        <th style="width:10%">User Name </th>
                                        <th style="width:10%;">Subscription Start Date</th>
                                        <th style="width:10%;">Subscription End Date</th>
                                        <th style="width:10%;">Mobile No.</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $i=0;
                                    @endphp
                                    @foreach ($expireSub as $expire)
                                        <tr>
                                            <td>{{++$i}}</td>
                                            <td>{{$expire->name}}</td>
                                            <td data-order="{{ date('Y-m-d', strtotime($expire->subscription_start_date)) }}">
                                                @if(!empty($expire->subscription_start_date))
                                                    {{date("d-m-Y", strtotime($expire->subscription_start_date)) }}
                                                @else
                                                    -
                                                @endif
                                            </td>
                                            <td data-order="{{ date('Y-m-d', strtotime($expire->subscription_end_date)) }}">
                                                @if(!empty($expire->subscription_end_date))
                                                    {{date("d-m-Y", strtotime($expire->subscription_end_date)) }}
                                                @else
                                                    -
                                                @endif
                                            </td>
                                            <td>
                                                @if (!empty( $expire->phone_no))
                                                    {{ $expire->phone_no}}
                                                @else
                                                    -
                                                @endif
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
</div>
@endsection
@push('js')
<script src="{{ asset('admin/plugins/moment/moment.min.js')}}"></script>
<script src="{{ asset('admin/plugins/daterangepicker/daterangepicker.js') }}"></script>
<script>
$(function() {
    $("#example1").DataTable({
        "responsive": true,
        "autoWidth": false,
        "columnDefs": [
        { "orderable": false, "targets": [4] }]
    });
});
$(function() {
    $("#example2").DataTable({
        "responsive": true,
        "autoWidth": false,
        "columnDefs": [
        { "orderable": false, "targets": [4] }]
    });
});
</script>
@endpush