@extends('layouts.master')

@section('title', 'Dashboard')

@section('content')
    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <div class="content-header">
            <div class="container-fluid">
                <div class="row mb-2">
                    <div class="col-sm-6">
                        <h1 class="m-0 text-dark">Dashboard</h1>
                    </div><!-- /.col -->

                </div><!-- /.row -->
            </div><!-- /.container-fluid -->
        </div>
        <!-- /.content-header -->

        <!-- Main content -->
        <section class="content">
            <div class="container-fluid">
                <!-- Info boxes -->
                <div class="row">
                    <div class="col-12 col-sm-6 col-md-3">
                        <div class="info-box">
                            <span class="info-box-icon bg-warning elevation-1"><i class="fa fa-users"></i></span>

                            <div class="info-box-content">
                                <span class="info-box-text">Total Users</span>
                                <span class="info-box-number">{{$total_users}}</span>
                            </div>
                            <!-- /.info-box-content -->
                        </div>
                        <!-- /.info-box -->
                    </div>
                    <!-- /.col -->
                    <div class="col-12 col-sm-6 col-md-3">
                        <div class="info-box mb-3">
                            <span class="info-box-icon bg-info elevation-1"><i class="fa fa-tv"></i></span>

                            <div class="info-box-content">
                                <span class="info-box-text">Total Subscriptions</span>
                                <span class="info-box-number">{{$active_subscriptions}}</span>
                            </div>
                            <!-- /.info-box-content -->
                        </div>
                        <!-- /.info-box -->
                    </div>
                    <!-- /.col -->

                    <!-- fix for small devices only -->
                    <div class="clearfix hidden-md-up"></div>

                    <div class="col-12 col-sm-6 col-md-3">
                        <div class="info-box mb-3">
                            <span class="info-box-icon bg-danger elevation-1"><i class="fa fa-shopping-cart"></i></span>

                            <div class="info-box-content">
                                <span class="info-box-text">Today Subscriptions</span>
                                <span class="info-box-number">{{$new_subscriptions}}</span>
                            </div>
                            <!-- /.info-box-content -->
                        </div>
                        <!-- /.info-box -->
                    </div>
                    <!-- /.col -->
                    <div class="col-12 col-sm-6 col-md-3">
                        <div class="info-box mb-3">
                            <span class="info-box-icon bg-success elevation-1"><i class="fa fa-dollar-sign"></i></span>

                            <div class="info-box-content">
                                <span class="info-box-text">Estimated Revenue</span>
                                <span class="info-box-number">{{"$".$revenue}}</span>
                            </div>
                            <!-- /.info-box-content -->
                        </div>
                        <!-- /.info-box -->
                    </div>
                    <!-- /.col -->
                </div>
                <!-- /.row -->

                <!-- /.row -->

                <!-- Main row -->
                <div class="row">
                    {{--<!-- Left col -->--}}
                    <div class="col-md-6">

                        {{--<!-- /.card -->--}}

                        {{--<!-- TABLE: LATEST ORDERS -->--}}
                        <div class="card">
                            <div class="card-header border-transparent">
                                <h3 class="card-title">Latest Members</h3>
                            </div>
                            {{--<!-- /.card-header -->--}}
                            <div class="card-body p-0">
                                <div class="table-responsive">
                                   <table class="table m-0">
                                        <thead>
                                        <tr>
                                            <th>Id</th>
                                            <th>Name</th>
                                            <th>Email</th>
                                            <th>Package</th>
                                            <th>Joined on</th>
                                        </tr>
                                       </thead>
                                        <tbody>
                                            @foreach($latest_members as $lm)
                                                <tr>
                                                    <td>
                                                        {{$lm->id}}
                                                    </td>
                                                    <td>
                                                        {{$lm->name}}
                                                    </td>
                                                    <td>
                                                        {{$lm->email}}
                                                    </td>
                                                    <td>
                                                        @if($lm->package)
                                                        {{$lm->package->name}}
                                                        
                                                        @else
                                                        {{'NaN'}}
                                                        
                                                        @endif
                                                    </td>
                                                    <td>
                                                        {{$lm->created_at}}
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                    <a type="button" class="btn btn-primary" href="{{route('users')}}" style="margin: 20px 20px 20px 20px; float: right">All Members</a>
                                </div>
                            </div>

                       </div>
                    </div>
                    
                    
                    
                    <div class="col-md-6">

                        {{--<!-- /.card -->--}}

                        {{--<!-- TABLE: LATEST ORDERS -->--}}
                        <div class="card">
                            <div class="card-header border-transparent">
                                <h3 class="card-title">Latest Payments</h3>
                            </div>
                            {{--<!-- /.card-header -->--}}
                            <div class="card-body p-0">
                                <div class="table-responsive">
                                   <table class="table m-0">
                                        <thead>
                                        <tr>
                                            <th>Id</th>
                                            <th>Name</th>
                                            <th>Email</th>
                                            <th>Amount</th>
                                            <th>Payment Method</th>
                                            <th>Renewal Count</th>
                                            <th>Purchased on</th>
                                        </tr>
                                       </thead>
                                        <tbody>
                                            @foreach($latest_payments as $lp)
                                            <tr>
                                                    <td>
                                                        {{$lp->id}}
                                                    </td>
                                                    <td>
                                                        {{$lp->name}}
                                                    </td>
                                                    <td>
                                                        {{$lp->email}}
                                                    </td>
                                                    <td>
                                                        {{$lp->package->price}}
                                                    </td>
                                                    <td>
                                                        @if($lp->stripe_customer_id==="paypal")
                                                            {{"Paypal"}}
                                                        @else
                                                            {{"Stripe"}}
                                                        @endif
                                                    </td>
                                                    <td>
                                                        {{$lp->renewal_count}}
                                                    </td>
                                                    <td>
                                                        {{$lp->purchase_date}}
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                    
                                    <div>
                                        {{ $latest_payments->links() }}
                                    </div>
                                </div>
                            </div>

                       </div>
                    </div>
                    
                    <div class="col-md-6">

                        {{--<!-- /.card -->--}}

                        {{--<!-- TABLE: LATEST ORDERS -->--}}
                        <div class="card">
                            <div class="card-header border-transparent">
                                <h3 class="card-title">Today's expected payments</h3>
                            </div>
                            {{--<!-- /.card-header -->--}}
                            <div class="card-body p-0">
                                <div class="table-responsive">
                                   <table class="table m-0">
                                        <thead>
                                        <tr>
                                            <th>Id</th>
                                            <th>Name</th>
                                            <th>Amount</th>
                                            <th>Payment Method</th>
                                            <th>Renewal Count</th>
                                            <th>Purchased on</th>
                                            <th>Next Charge</th>
                                        </tr>
                                       </thead>
                                        <tbody>
                                            @foreach($expected_payments as $lp)
                                            <tr>
                                                    <td>
                                                        {{$lp->id}}
                                                    </td>
                                                    <td>
                                                        {{$lp->name}}
                                                    </td>
                                                    <td>
                                                        {{$lp->package->price}}
                                                    </td>
                                                    <td>
                                                        @if($lp->stripe_customer_id==="paypal")
                                                            {{"Paypal"}}
                                                        @else
                                                            {{"Stripe"}}
                                                        @endif
                                                    </td>
                                                    <td>
                                                        {{$lp->renewal_count}}
                                                    </td>
                                                    <td>
                                                        {{$lp->purchase_date}}
                                                    </td>
                                                    <td>
                                                        {{$lp->should_charge_on}}
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                    
                                    <div>
                                        {{ $expected_payments->links() }}
                                    </div>
                                </div>
                            </div>

                       </div>
                    </div>

                </div>
                <!-- /.row -->
            </div><!--/. container-fluid -->
        </section>
        <!-- /.content -->
    </div>
    <!-- /.content-wrapper -->
@endsection

@section('javascript')
    <!-- jQuery -->
    <script src="/public/dist/plugins/jquery/jquery.min.js"></script>
    <!-- jQuery UI 1.11.4 -->
    <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>
    <!-- Bootstrap 4 -->
    <script src="/public/dist/plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
    <!-- Sparkline -->
    <script src="/public/dist/plugins/sparkline/jquery.sparkline.min.js"></script>
    <!-- jvectormap -->
    <script src="/public/dist/plugins/jvectormap/jquery-jvectormap-1.2.2.min.js"></script>
    <script src="/public/dist/plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>
    <!-- Slimscroll -->
    <script src="/public/dist/plugins/slimScroll/jquery.slimscroll.min.js"></script>
    <!-- ChartJS 1.0.2 -->
    <script src="/public/dist/plugins/chartjs-old/Chart.min.js"></script>
    <!-- AdminLTE App -->
    <script src="/public/dist/js/adminlte.js"></script>
    <!-- AdminLTE dashboard demo (This is only for demo purposes) -->
    <script src="/public/dist/js/pages/dashboard2.js"></script>
    <!-- AdminLTE for demo purposes -->
    <script src="/public/dist/js/demo.js"></script>
@stop