PHP Advice::leftJoin Examples

Example #1

File: AdviceController.php Project: phucps89/Tour

 function index()
 {
     $adviceDetailTableName = AdviceDetail::getTableName();
     $adviceTableName = Advice::getTableName();
     $advices = Advice::leftJoin($adviceDetailTableName, $adviceDetailTableName . '.id_advice', '=', $adviceTableName . '.id')->groupBy($adviceTableName . '.id')->select([$adviceTableName . '.*', DB::raw("COUNT(DISTINCT {$adviceDetailTableName}.id_question) as sumQuestion")])->get();
     $sumQuestion = Question::count();
     return View::make('advice.index', ['advices' => $advices, 'sumQuestion' => $sumQuestion]);
 }