/** * Get Total Annotation status by type * @param $statusType * @return mixed */ public function getStatusCountByType($statusType) { return $this->contract->distinct()->select('contracts.id', 'a.status')->from('contracts')->leftJoin('contract_annotations as a', function ($join) use($statusType) { $join->on('contracts.id', '=', 'a.contract_id')->where('a.status', '=', $statusType); })->get(); }