@php $onsale_assetdetails=\App\Models\Orderdetails::select('asset_id')->orderBy('id', 'DESC')->count(); @endphp On Sale ({{ $onsale_assetdetails }})
@php $topselling_assetdetails=\App\Models\Orderdetails::select('asset_id')->groupBy('asset_id')->count(); @endphp Top Selling ({{ $topselling_assetdetails }})
@php $asset_details_all= \App\Models\AssetDetails::where('assetdisplay','1')->orderByDesc('created_at')->count(); @endphp Top New ({{ $asset_details_all }})
@php $asset_details_all= \App\Models\AssetDetails::where('assetdisplay','1')->where('pricetype','2')->count(); @endphp Top Free({{ $asset_details_all }})

@php $asset_details_all= \App\Models\AssetDetails::where('verified_id','1')->orderByDesc('created_at')->count(); @endphp Asset Verified ({{ $asset_details_all }})
@php $asset_details_all= \App\Models\AssetDetails::where('verified_id','2')->orderByDesc('created_at')->count(); @endphp Asset Unverified ({{ $asset_details_all }})

@php $asset_classs = \App\Models\ClassDetails::orderByDesc('created_at')->get(); @endphp @if (count($asset_classs) > 0) @foreach ($asset_classs as $key => $asset_class) {{ $asset_class->classname }} ({{ \App\Models\AssetDetails::where('class_id',$asset_class->id)->count() }})
@endforeach @endif

@php $asset_lods= \App\Models\LevelofDevelopment::orderByDesc('created_at')->get(); @endphp @if (count($asset_lods) > 0) @foreach ($asset_lods as $key => $asset_lod) {{ $asset_lod->levelofdevelopmentsname }} ({{ \App\Models\AssetDetails::where('assetlodid',$asset_lod->id)->count() }})
@endforeach @endif

On Sale ({{ $onsale_assetdetails }})
@php $topselling_assetdetails=\App\Models\Orderdetails::select('asset_id')->groupBy('asset_id')->count(); @endphp Top Selling ({{ $topselling_assetdetails }})
@php $asset_details_all= \App\Models\AssetDetails::orderByDesc('created_at')->count(); @endphp Top New ({{ $asset_details_all }})
@php $asset_details_all= \App\Models\AssetDetails::where('pricetype','2')->count(); @endphp Top Free({{ $asset_details_all }})

@php $topselling_assetdetails=\App\Models\Orderdetails::select('asset_id')->groupBy('asset_id')->count(); @endphp Crompton ({{ $topselling_assetdetails }})
@php $topselling_assetdetails=\App\Models\Orderdetails::select('asset_id')->groupBy('asset_id')->count(); @endphp Philips ({{ $topselling_assetdetails }})