public function index() { $data['system'] = $this->system; $data['count'] = DB::table('tbl_completion')->where('academicterm', $this->system->phaseterm)->where('stage', 2)->where('completedby', Session::get('uid'))->count(); $data['$sql'] = Subject::getSubject($this->owner, $this->system); return view('dean.manage_section', $data); }