@extends('admin.layouts.layout')

@section('content')

    <div class="container-fluid">
        <div class="row clearfix">
            <div class="col-12">
                <div class="top_report">
                    <div class="row clearfix">
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('admincustomerlist.index') }}">
                            <div class="body">
                                <div class="clearfix">
                                    <div class="float-left">
                                        <i class="fa fa-2x fa-user text-col-blue"></i>
                                    </div>
                                    <div class="number float-right text-right">
                                        <h6>Customer</h6>
                                        <span class="font700">{{ \App\Models\User::where('user_type','Customer')->count() }}</span>
                                    </div>
                                </div>
                                <div class="progress progress-xs progress-transparent custom-color-green mb-0 mt-3">
                                    <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                </div>
                                <small class="text-muted">100%</small>
                            </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('actorlogindetails.index') }}">
                            <div class="body">
                                <div class="clearfix">
                                    <div class="float-left">
                                        <i class="fa fa-2x fa-address-card text-col-blue"></i>
                                    </div>
                                    <div class="number float-right text-right">
                                        <h6>Actor</h6>
                                        <span class="font700">{{ \App\Models\User::where('user_type','Actor')->count() }}</span>
                                    </div>
                                </div>
                                <div class="progress progress-xs progress-transparent custom-color-yellow mb-0 mt-3">
                                    <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                </div>
                                <small class="text-muted">100%</small>
                            </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('assetdetails.index') }}">
                            <div class="body">
                                <div class="clearfix">
                                    <div class="float-left">
                                        <i class="fa fa-2x fa-pencil text-col-blue"></i>
                                    </div>
                                    <div class="number float-right text-right">
                                        <h6>Asset</h6>
                                        <span class="font700">{{ \App\Models\AssetDetails::count() }}</span>
                                    </div>
                                </div>
                                <div class="progress progress-xs progress-transparent custom-color-blue mb-0 mt-3">
                                    <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                </div>
                                <small class="text-muted">100%</small>
                            </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('assatcategory.index') }}">
                            <div class="body">
                                <div class="clearfix">
                                    <div class="float-left">
                                        <i class="fa fa-2x fa-building text-col-red"></i>
                                    </div>
                                    <div class="number float-right text-right">
                                        <h6>Asset Category</h6>
                                        <span class="font700">{{ \App\Models\AssetCategory::count() }}</span>
                                    </div>
                                </div>
                                <div class="progress progress-xs progress-transparent custom-color-green mb-0 mt-3">
                                    <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                </div>
                                <small class="text-muted">100%</small>
                            </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('advertisementdetails.index') }}">
                            <div class="body">
                                <div class="clearfix">
                                    <div class="float-left">
                                        <i class="fa fa-2x fa-television text-col-yellow"></i>
                                    </div>
                                    <div class="number float-right text-right">
                                        <h6>Advertisement</h6>
                                        <span class="font700">{{ \App\Models\AdvertisementDetails::count() }}</span>
                                    </div>
                                </div>
                                <div class="progress progress-xs progress-transparent custom-color-yellow mb-0 mt-3">
                                    <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                </div>
                                <small class="text-muted">100%</small>
                            </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('blogdetails.index') }}">
                            <div class="body">
                                <div class="clearfix">
                                    <div class="float-left">
                                        <i class="fa fa-2x fa-thumbs-up text-col-yellow"></i>
                                    </div>
                                    <div class="number float-right text-right">
                                        <h6>Blog</h6>
                                        <span class="font700">{{ \App\Models\Blogdetails::count() }}</span>
                                    </div>
                                </div>
                                <div class="progress progress-xs progress-transparent custom-color-green mb-0 mt-3">
                                    <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                </div>
                                <small class="text-muted">100%</small>
                            </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('assetdetails.index') }}">
                            <div class="body">
                                <div class="clearfix">
                                    <div class="float-left">
                                        <i class="fa fa-2x fa-pencil text-col-yellow"></i>
                                    </div>
                                    <div class="number float-right text-right">
                                        <h6>Verified Asset</h6>
                                        <span class="font700">{{ \App\Models\AssetDetails::where('verified_id','1')->count() }}</span>
                                    </div>
                                </div>
                                <div class="progress progress-xs progress-transparent custom-color-yellow mb-0 mt-3">
                                    <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                </div>
                                <small class="text-muted">100%</small>
                            </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('advertisementdetails.index') }}">
                            <div class="body">
                                <div class="clearfix">
                                    <div class="float-left">
                                        <i class="fa fa-2x fa-television text-col-yellow"></i>
                                    </div>
                                    <div class="number float-right text-right">
                                        <h6>Verified Advertisement</h6>
                                        <span class="font700">{{ \App\Models\AdvertisementDetails::where('advertisement_verified','1')->count() }}</span>
                                    </div>
                                </div>
                                <div class="progress progress-xs progress-transparent custom-color-blue mb-0 mt-3">
                                    <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                </div>
                                <small class="text-muted">100%</small>
                            </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('adminorderlist.index') }}">
                                <div class="body">
                                    <div class="clearfix">
                                        <div class="float-left">
                                            <i class="fa fa-2x fa-shopping-bag text-col-yellow"></i>
                                        </div>
                                        <div class="number float-right text-right">
                                            <h6>Today Order</h6>
                                            <span class="font700">{{ \App\Models\Order::where('date',date('Y-m-d'))->count() }}</span>
                                        </div>
                                    </div>
                                    <div class="progress progress-xs progress-transparent custom-color-blue mb-0 mt-3">
                                        <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                    </div>
                                    <small class="text-muted">100%</small>
                                </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('adminorderlist.index') }}">
                                <div class="body">
                                    <div class="clearfix">
                                        <div class="float-left">
                                            <i class="fa fa-2x fa-shopping-bag text-col-yellow"></i>
                                        </div>
                                        <div class="number float-right text-right">
                                            <h6>Weekly Order</h6>
                                            <span class="font700">{{ $orderweeklycount }}</span>
                                        </div>
                                    </div>
                                    <div class="progress progress-xs progress-transparent custom-color-yellow mb-0 mt-3">
                                        <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                    </div>
                                    <small class="text-muted">100%</small>
                                </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('adminorderlist.index') }}">
                                <div class="body">
                                    <div class="clearfix">
                                        <div class="float-left">
                                            <i class="fa fa-2x fa-shopping-bag text-col-yellow"></i>
                                        </div>
                                        <div class="number float-right text-right">
                                            <h6>Monthly Order</h6>
                                            <span class="font700">{{ $ordermonthlycount }}</span>
                                        </div>
                                    </div>
                                    <div class="progress progress-xs progress-transparent custom-color-blue mb-0 mt-3">
                                        <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                    </div>
                                    <small class="text-muted">100%</small>
                                </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('adminorderlist.index') }}">
                                <div class="body">
                                    <div class="clearfix">
                                        <div class="float-left">
                                            <i class="fa fa-2x fa-shopping-bag text-col-yellow"></i>
                                        </div>
                                        <div class="number float-right text-right">
                                            <h6>Yearly Order</h6>
                                            <span class="font700">{{ $ordermonthlycount }}</span>
                                        </div>
                                    </div>
                                    <div class="progress progress-xs progress-transparent custom-color-green mb-0 mt-3">
                                        <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                    </div>
                                    <small class="text-muted">100%</small>
                                </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('adminorderlist.index') }}">
                                <div class="body">
                                    <div class="clearfix">
                                        <div class="float-left">
                                            <i class="fa fa-2x fa-shopping-bag text-col-yellow"></i>
                                        </div>
                                        <div class="number float-right text-right">
                                            <h6>Today Amount</h6>
                                            <span class="font700">{{ \App\Models\Order::where('date',date('Y-m-d'))->sum('grand_total') }}</span>
                                        </div>
                                    </div>
                                    <div class="progress progress-xs progress-transparent custom-color-blue mb-0 mt-3">
                                        <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                    </div>
                                    <small class="text-muted">100%</small>
                                </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('adminorderlist.index') }}">
                                <div class="body">
                                    <div class="clearfix">
                                        <div class="float-left">
                                            <i class="fa fa-2x fa-shopping-bag text-col-yellow"></i>
                                        </div>
                                        <div class="number float-right text-right">
                                            <h6>Weekly Amount</h6>
                                            <span class="font700">{{ $ordermonthlyamount }}</span>
                                        </div>
                                    </div>
                                    <div class="progress progress-xs progress-transparent custom-color-yellow mb-0 mt-3">
                                        <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                    </div>
                                    <small class="text-muted">100%</small>
                                </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('adminorderlist.index') }}">
                                <div class="body">
                                    <div class="clearfix">
                                        <div class="float-left">
                                            <i class="fa fa-2x fa-shopping-bag text-col-yellow"></i>
                                        </div>
                                        <div class="number float-right text-right">
                                            <h6>Monthly Amount</h6>
                                            <span class="font700">{{ $ordermonthlycount }}</span>
                                        </div>
                                    </div>
                                    <div class="progress progress-xs progress-transparent custom-color-blue mb-0 mt-3">
                                        <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                    </div>
                                    <small class="text-muted">100%</small>
                                </div>
                            </a>
                        </div>
                        <div class="col-lg-3 col-md-6 col-sm-6 card">
                            <a href="{{ route('adminsubscriptionhistorylist.index') }}">
                                <div class="body">
                                    <div class="clearfix">
                                        <div class="float-left">
                                            <i class="fa fa-2x fa-shopping-bag text-col-yellow"></i>
                                        </div>
                                        <div class="number float-right text-right">
                                            <h6>Actor Subscription</h6>
                                            <span class="font700">{{ $totalactorsubscriptionplancount }}</span>
                                        </div>
                                    </div>
                                    <div class="progress progress-xs progress-transparent custom-color-yellow mb-0 mt-3">
                                        <div class="progress-bar" data-transitiongoal="100" aria-valuenow="100" style="width: 100%;"></div>
                                    </div>
                                    <small class="text-muted">100%</small>
                                </div>
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="row clearfix">
            <div class="col-lg-12 col-md-12 col-sm-12">
                <div class="card">
                    <div class="header">
                        <div class="row">
                            <div class="col-md-6"><h2 class="text-left">Recent Order List</h2></div>
                            <div class="col-md-6"><a href="{{ route('adminorderlist.index') }}"><h2 class="text-right">All Order List</h2></a></div>
                        </div>

                    </div>
                    <div class="body">
                        <div class="table-responsive">
                            <table class="table table-hover js-basic-example dataTable table-custom mb-0">
                                <thead class="thead-dark">
                                <tr>
                                    <th>S.no</th>
                                    <th>Customer Name</th>
                                    <th>Order Code</th>
                                    <th>Date</th>
                                    <th>Price</th>
                                </tr>
                                </thead>
                                <tbody>
                                @php
                                    $orders=\App\Models\Order::orderByDesc('created_at')->limit(10)->get();
                                @endphp
                                @foreach($orders as $key => $order)
                                    @php
                                        $userdetails=\App\Models\User::select('name')->where('id', $order->user_id)->first();
                                    @endphp
                                <tr>
                                    <td>{{ $key+1 }}</td>
                                    <td>{{ $userdetails->name }}</td>
                                    <td>{{ $order->order_id }}</td>
                                    <td>{{ $order->created_at }}</td>
                                    <td>{{ $order->grand_total }}</td>
                                </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>

                    </div>
                </div>
            </div>
        </div>

        <div class="row clearfix">
            <div class="col-lg-12 col-md-12 col-sm-12">
                <div class="card">
                    <div class="header">
                        <div class="row">
                            <div class="col-md-6"><h2 class="text-left">Recent Asset Report List</h2></div>
                            <div class="col-md-6"><a href="{{ route('adminassetreportlist.index') }}"><h2 class="text-right">All Asset Report List</h2></a></div>
                        </div>
                    </div>
                    <div class="body">
                        <div class="table-responsive">
                            <table class="table table-hover js-basic-example dataTable table-custom mb-0">
                                <thead class="thead-dark">
                                <tr>
                                    <th>S.no</th>
                                    <th>Asset Name</th>
                                    <th>Customer Name</th>
                                    <th>Date</th>
                                    <th>Message</th>
                                </tr>
                                </thead>
                                <tbody>

                                </tbody>
                            </table>
                        </div>

                    </div>
                </div>
            </div>
        </div>

        <div class="row clearfix">
            <div class="col-lg-12 col-md-12 col-sm-12">
                <div class="card">
                    <div class="header">
                        <div class="row">
                            <div class="col-md-6"><h2 class="text-left">Recent Actor Report List</h2></div>
                            <div class="col-md-6"><a href="{{ route('adminactorreportlist.index') }}"><h2 class="text-right">All Actor Report List</h2></a></div>
                        </div>
                    </div>
                    <div class="body">
                        <div class="table-responsive">
                            <table class="table table-hover js-basic-example dataTable table-custom mb-0">
                                <thead class="thead-dark">
                                <tr>
                                    <th>S.no</th>
                                    <th>Actor Name</th>
                                    <th>Customer Name</th>
                                    <th>Date</th>
                                    <th>Message</th>
                                </tr>
                                </thead>
                                <tbody>
                                @php
                                    $reportactordetails=\App\Models\ReportActorDetails::orderByDesc('created_at')->limit(10)->get();
                                @endphp
                                @foreach($reportactordetails as $key => $reportactordetail)
                                    @php
                                        $userdetails=\App\Models\User::select('name')->where('id', $reportactordetail->user_id)->first();
                                        $actordetails=\App\Models\ActorController::select('name')->where('id', $reportactordetail->actor_id)->first();
                                    @endphp
                                    <tr>
                                        <td>{{ $key+1 }}</td>
                                        <td>{{ $actordetails->name }}</td>
                                        <td>{{ $userdetails->name }}</td>
                                        <td>{{ $reportactordetail->created_at }}</td>
                                        <td>{{ $reportactordetail->message }}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>

                    </div>
                </div>
            </div>
        </div>

    </div>

@endsection