orderRepository = $orderRepository; $this->companiesRepository = $companiesRepository; } public function execute() { $active = $this->orderRepository->whereYear('created_at', '=', Carbon::now()->year)->whereMonth('created_at', '=', Carbon::now()->month)->orderBy('company_id')->get()->groupBy('company_id'); $company = $this->companiesRepository->count(); if ($company > $active->count()) $company -= $active->count(); else $company = $active->count() - $company; return [$active->count(), $company]; } }