public function overview() { $departments = Department::select('id', 'name', 'icon')->where('hospital_id', $this->hospital_id)->get(); if ($departments) { $this->set_template('hospital.department.overview'); $this->set_data(array('departments' => $departments)); } else { $this->set_error_code($this->not_found_error_code); } return $this->response(); }
public static function getCollPrograms($collegeid) { $departments = Department::select('unitid')->where('parentunitid', $collegeid)->groupBy('unitid')->get(); $departmentids = []; foreach ($departments as $department) { array_push($departmentids, $department->unitid); } $programs = Program::select('programid')->whereIn('unitid', $departmentids)->where('degreelevel', 'U')->groupBy('programid')->get(); $programids = []; foreach ($programs as $program) { array_push($programids, $program->programid); } return $programids; }
/** * Run the migrations. * * @return void */ public function up() { $batches = [2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009]; $allStudents = []; $departments = Department::select('unitid')->get(); foreach ($departments as $department) { $departmentid = $department->unitid; foreach ($batches as $batch) { $allStudents[$batch] = Studentterm::getBatchStudentsDepartment($batch * 100000, $departmentid); } $this->seedEmployment($batches, $allStudents, $departmentid); $this->seedGrades($batches, $allStudents, $departmentid); $this->seedStbracket($batches, $allStudents, $departmentid); $this->seedRegion($batches, $allStudents, $departmentid); $this->seedUnemployment($batches, $allStudents, $departmentid); $this->seedHighGrades($batches, $allStudents, $departmentid); $this->seedOverload($batches, $allStudents, $departmentid); $this->seedUnits($batches, $allStudents, $departmentid); } }
public function department() { $pages = Department::select(array('id_dept', 'nm_dept')); return Datatables::of($pages)->make(); }