PHP Modules\Classrooms\Entities ClassroomInterval::selectRaw Examples

Example #1

File: IntervalsController.php Project: hisambahaa/DARES

 public function index()
 {
     $intervals = ClassroomInterval::selectRaw('classroom_intervals.*, COUNT(cs.id) as hasSemesters')->inCurrentSemester()->leftJoin('classroom_sessions as cs', 'cs.interval_id', '=', 'classroom_intervals.id')->groupBy('classroom_intervals.id')->paginate(30);
     return view('classrooms::intervals.index', compact('intervals'));
 }