@extends('admin.layouts.layout') @section('content')
Total Revenue
@php $startOfThisMonth = \Carbon\Carbon::now()->startOfMonth(); $endOfThisMonth = \Carbon\Carbon::now()->endOfMonth(); $startOfLastMonth = \Carbon\Carbon::now()->subMonth()->startOfMonth(); $endOfLastMonth = \Carbon\Carbon::now()->subMonth()->endOfMonth(); $thisMonthAmount_order = \App\Models\Order::whereBetween('created_at', [$startOfThisMonth, $endOfThisMonth])->where('payment_status','Paid')->sum('grand_total'); $lastMonthAmount_order = \App\Models\Order::whereBetween('created_at', [$startOfLastMonth, $endOfLastMonth])->where('payment_status','Paid')->sum('grand_total'); $thisMonthAmount_advertisement = \App\Models\AdvertiserPaymentdetails::whereBetween('created_at', [$startOfThisMonth, $endOfThisMonth])->where('paymentstatus','1')->sum('total'); $lastMonthAmount_advertisement = \App\Models\AdvertiserPaymentdetails::whereBetween('created_at', [$startOfLastMonth, $endOfLastMonth])->where('paymentstatus','1')->sum('total'); $thisMonthAmount_Manufactor = \App\Models\ManufactorPaymentdetails::whereBetween('created_at', [$startOfThisMonth, $endOfThisMonth])->where('paymentstatus','1')->sum('total'); $lastMonthAmount_Manufactor = \App\Models\ManufactorPaymentdetails::whereBetween('created_at', [$startOfLastMonth, $endOfLastMonth])->where('paymentstatus','1')->sum('total'); $thismonth_overall_amount=$thisMonthAmount_order+$thisMonthAmount_advertisement+$thisMonthAmount_Manufactor; $lastmonth_overall_amount=$lastMonthAmount_order+$lastMonthAmount_advertisement+$lastMonthAmount_Manufactor; if ($lastmonth_overall_amount > 0) { $percentageChange = (($thismonth_overall_amount - $lastmonth_overall_amount) / $lastmonth_overall_amount) * 100; } else { $percentageChange = $thismonth_overall_amount > 0 ? 100 : 0; } $percentageChange = number_format($percentageChange, 0); @endphp {{ $percentageChange }} % {{-- This month : {{ $thismonth_overall_amount }} , Last month {{ $lastmonth_overall_amount }}--}}
@php $assetorderamount=\App\Models\Order::where('payment_status','Paid')->sum('grand_total'); $advertiseramount=\App\Models\AdvertiserPaymentdetails::where('paymentstatus','1')->sum('total'); $brandamount=\App\Models\ManufactorPaymentdetails::where('paymentstatus','1')->sum('total'); $displaytotalamount=$assetorderamount+$advertiseramount+$brandamount; $displaytotalamount = number_format($displaytotalamount, 2); @endphp
{{ $displaytotalamount }}
View net earnings
Total Assets
@php $startOfThisMonth = \Carbon\Carbon::now()->startOfMonth(); $endOfThisMonth = \Carbon\Carbon::now()->endOfMonth(); $startOfLastMonth = \Carbon\Carbon::now()->subMonth()->startOfMonth(); $endOfLastMonth = \Carbon\Carbon::now()->subMonth()->endOfMonth(); $thisMonthAmount_order = \App\Models\Order::whereBetween('created_at', [$startOfThisMonth, $endOfThisMonth])->where('payment_status','Paid')->sum('grand_total'); $lastMonthAmount_order = \App\Models\Order::whereBetween('created_at', [$startOfLastMonth, $endOfLastMonth])->where('payment_status','Paid')->sum('grand_total'); $thismonth_overall_amount=$thisMonthAmount_order; $lastmonth_overall_amount=$lastMonthAmount_order; if ($lastmonth_overall_amount > 0) { $percentageChange = (($thismonth_overall_amount - $lastmonth_overall_amount) / $lastmonth_overall_amount) * 100; } else { $percentageChange = $thismonth_overall_amount > 0 ? 100 : 0; } $percentageChange = number_format($percentageChange, 0); @endphp {{ $percentageChange }} % {{--This month : {{ $thismonth_overall_amount }} , Last month {{ $lastmonth_overall_amount }}--}} {{-- 0 %--}}
{{ \App\Models\Order::where('payment_status','Paid')->count() }}
View all assets
Users
@php $startOfThisMonth = \Carbon\Carbon::now()->startOfMonth(); $endOfThisMonth = \Carbon\Carbon::now()->endOfMonth(); $startOfLastMonth = \Carbon\Carbon::now()->subMonth()->startOfMonth(); $endOfLastMonth = \Carbon\Carbon::now()->subMonth()->endOfMonth(); $thisMonthAmount_user = \App\Models\User::whereBetween('created_at', [$startOfThisMonth, $endOfThisMonth])->count(); $lastMonthAmount_user = \App\Models\User::whereBetween('created_at', [$startOfLastMonth, $endOfLastMonth])->count(); $thismonth_overall_amount=$thisMonthAmount_user; $lastmonth_overall_amount=$lastMonthAmount_user; if ($lastmonth_overall_amount > 0) { $percentageChange = (($thismonth_overall_amount - $lastmonth_overall_amount) / $lastmonth_overall_amount) * 100; } else { $percentageChange = $thismonth_overall_amount > 0 ? 100 : 0; } $percentageChange = number_format($percentageChange, 0); @endphp {{ $percentageChange }} % {{--This month : {{ $thismonth_overall_amount }} , Last month {{ $lastmonth_overall_amount }}--}}
{{ \App\Models\User::count(); }}
See details
Active Ads
@php $startOfThisMonth = \Carbon\Carbon::now()->startOfMonth(); $endOfThisMonth = \Carbon\Carbon::now()->endOfMonth(); $startOfLastMonth = \Carbon\Carbon::now()->subMonth()->startOfMonth(); $endOfLastMonth = \Carbon\Carbon::now()->subMonth()->endOfMonth(); $thisMonthAmount_advertisement = \App\Models\AdvertisementDetails::where('advertisement_displaystatus','1')->whereBetween('created_at', [$startOfThisMonth, $endOfThisMonth])->count(); $lastMonthAmount_advertisement = \App\Models\AdvertisementDetails::where('advertisement_displaystatus','1')->whereBetween('created_at', [$startOfLastMonth, $endOfLastMonth])->count(); $thismonth_overall_amount=$thisMonthAmount_advertisement; $lastmonth_overall_amount=$lastMonthAmount_advertisement; if ($lastmonth_overall_amount > 0) { $percentageChange = (($thismonth_overall_amount - $lastmonth_overall_amount) / $lastmonth_overall_amount) * 100; } else { $percentageChange = $thismonth_overall_amount > 0 ? 100 : 0; } $percentageChange = number_format($percentageChange, 0); @endphp {{ $percentageChange }} % {{--This month : {{ $thismonth_overall_amount }} , Last month {{ $lastmonth_overall_amount }}--}}
{{ \App\Models\AdvertisementDetails::where('advertisement_displaystatus','1')->whereDate('scheduledclose', '>=', \Carbon\Carbon::now())->count() }}
View all assets




Recent Order


{{-- --}}
S.noOrder no User Id Date Amount


Popular Assets
Asset Price
@endsection @section('script') @include('admin.dashboard.chartjs') @php $admincount=\App\Models\User::where('user_type_id','1')->count(); $actorcount=\App\Models\User::where('user_type_id','2')->count(); $clientcount=\App\Models\User::where('user_type_id','3')->count(); $manufactorcount=\App\Models\User::where('user_type_id','4')->count(); $advertisercount=\App\Models\User::where('user_type_id','5')->count(); @endphp @php $adminadvertisementDetails=\App\Models\AdvertisementDetails::where('advertisement_type','1')->count(); $advertiseradvertisementDetails=\App\Models\AdvertisementDetails::where('advertisement_type','!=','1')->count(); $useradvertisementDetails=0; @endphp @endsection