@extends('admin.layouts.layout') @section('content')


All Userdetails
All User
{{ \App\Models\User::count() }}
Admin
{{ \App\Models\User::where('user_type_id','1')->count() }}
Client
{{ \App\Models\User::where('user_type_id','3')->count() }}
Actor
{{ \App\Models\User::where('user_type_id','2')->count() }}
Manufactor
{{ \App\Models\User::where('user_type_id','4')->count() }}
Advertiser
{{ \App\Models\User::where('user_type_id','5')->count() }}

All Assetdetails
All Assetdetails
{{ \App\Models\AssetDetails::count() }}
Admin Asset
{{ \App\Models\AssetDetails::where('asset_user_type','1')->count() }}
Actor Asset
{{ \App\Models\AssetDetails::where('asset_user_type','2')->count() }}
Manufactor Asset
{{ \App\Models\AssetDetails::where('asset_user_type','3')->count() }}

All Advertishmentdetails
All Advertishment
{{ \App\Models\AdvertisementDetails::count() }}
Admin Advertishment
{{ \App\Models\AdvertisementDetails::where('userid','1')->count() }}
Without Admin Advertishment
{{ \App\Models\AdvertisementDetails::where('userid','!+','1')->count() }}


All Payment Details
Asset Order Count
{{ \App\Models\Order::where('payment_status','Paid')->count() }}
Asset Order Amount
{{ \App\Models\Order::where('payment_status','Paid')->sum('grand_total') }}
Brand Payment Count
{{ \App\Models\ManufactorPaymentdetails::where('paymentstatus','1')->count() }}
Brand Amount
{{ \App\Models\ManufactorPaymentdetails::where('paymentstatus','1')->sum('total') }}
Advertiser Payment Count
{{ \App\Models\AdvertiserPaymentdetails::where('paymentstatus','1')->count() }}
Advertiser Amount
{{ \App\Models\AdvertiserPaymentdetails::where('paymentstatus','1')->sum('total') }}

All User & Orderdetails
@endsection @section('script') @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 $ManufactorPaymentdetail = \App\Models\ManufactorPaymentdetails::selectRaw('YEAR(created_at) as year, MONTH(created_at) as month, SUM(total) as total') ->where('created_at', '>=', \Carbon\Carbon::now()->subMonths(12))->where('paymentstatus','1') ->groupBy('year', 'month') ->orderBy('year') ->orderBy('month') ->get(); $months = $ManufactorPaymentdetail->map(function ($record) { return \Carbon\Carbon::createFromDate($record->year, $record->month, 1)->format('M Y'); }); $totals = $ManufactorPaymentdetail->pluck('total'); @endphp @endsection