// App\Providers\ViewServiceProvider.php use Illuminate\Support\Facades\View; use App\Models\User; use App\Models\Vendor; use App\Models\Campaign; use App\Models\Contact; use App\Models\Template; use App\Models\BotReply; View::composer('layouts.headers.cards', function ($view) { $view->with([ 'totalVendors' => Vendor::count(), 'totalActiveVendors' => Vendor::where('status',1)->count(), 'totalCampaigns' => Campaign::count(), 'messagesInQueue' => Campaign::where('status','pending')->count(), 'totalContacts' => Contact::count(), 'totalMessagesProcessed' => Campaign::where('status','sent')->count(), 'totalGroups' => Contact::distinct('group_id')->count(), 'totalTemplates' => Template::count(), 'totalBotReplies' => BotReply::count(), 'activeTeamMembers' => User::where('status',1)->count() ]); });