コード例 #1
0
 /**
  * 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();
 }