/** * Run the migrations. * * @return void */ public function up() { Schema::create('studentdelayed', function (Blueprint $table) { $table->increments('id'); $table->integer('studentid'); $table->integer('programid'); $table->integer('collegeid'); $table->integer('semesters'); $table->timestamps(); }); $students = Studentdropout::select('studentid', 'programid', 'collegeid', 'semesters')->where('semesters', '>', 8)->get(); foreach ($students as $student) { $programid = $student->programid; $semesters = $student->semesters; $programYears = Program::select('numyears')->where('programid', $programid)->first()->numyears; if ($semesters > $programYears * 2) { $newEntry = new Studentdelayed(); $newEntry->studentid = $student->studentid; $newEntry->programid = $programid; $newEntry->collegeid = $student->collegeid; $newEntry->semesters = $semesters; $newEntry->save(); } } }
/** * Run the migrations. * * @return void */ public function up() { Schema::table('studentdropouts', function (Blueprint $table) { // }); $students = Studentdropout::select('id', 'programid', 'semesters')->where('semesters', '>', 8)->get(); foreach ($students as $student) { $programYears = Program::select('numyears')->where('programid', $student->programid)->first()->numyears; if ($student->semesters > $programYears * 2) { Studentdropout::find($student->id)->delete(); } } }
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() { Schema::table('correlations', function (Blueprint $table) { // }); $batches = [2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009]; $allStudents = []; $programs = Program::select('programid')->get(); foreach ($programs as $program) { $programid = $program->programid; foreach ($batches as $batch) { $allStudents[$batch] = Studentterm::getBatchStudentsProgram($batch * 100000, $programid); } $this->alterOverload($batches, $allStudents, $programid); $this->alterUnits($batches, $allStudents, $programid); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::table('studentdropouts', function (Blueprint $table) { // }); $students = Studentterm::getAllStudents(); foreach ($students as $student) { $studentid = $student->studentid; $programid = $this->getFinProgram($studentid); $programYears = Program::select('numyears')->where('programid', $programid)->first()->numyears; $studentsems = $this->countStudentSem($studentid, $programid); if ($studentsems > $programYears * 2) { $newEntry = new Studentdropout(); $newEntry->studentid = $studentid; $newEntry->programid = $programid; $newEntry->collegeid = Program::select('unitid')->where('programid', $programid)->first()->unitid; $newEntry->semesters = $studentsems; $newEntry->save(); } } }
/** * Display a listing of the resource. * * @return Response */ public function index() { $correlation = []; $rawCorrelation = []; //Factors dropdown + names $factors = Factor::select('factorid', 'factorname')->get(); $factorNames = []; foreach ($factors as $factor) { $factorNames[$factor->factorid] = $factor->factorname; } //Programs dropdown + names $programs = Program::select('programtitle', 'programid')->where('degreelevel', 'U')->whereNotIn('programid', array(62, 66, 38, 22))->get(); $programNames = []; foreach ($programs as $program) { $programNames[$program->programid] = $program->programtitle; } //Departments dropdown $departments = Department::whereHas('programs', function ($q) { $q->whereNotIn('programid', array(62, 66, 38, 22)); $q->where('degreelevel', 'U'); })->get(); $departmentNames = []; foreach ($departments as $department) { $departmentNames[$department->unitid] = $department->unitname; } //Colleges dropdown $colleges = []; $collegeNames = []; foreach ($departments as $department) { $college = $department->college; array_push($colleges, $college); $collegeNames[$college->unitid] = $college->unitname; } $colleges = array_unique($colleges); //Campus Level $level = 'campus'; $id = -1; $rawCorrelation[$level][$id][1] = $this->corrEmployment($level); if ($rawCorrelation[$level][$id][1] < 0) { $correlation[$level][$id][1] = -$rawCorrelation[$level][$id][1]; } else { $correlation[$level][$id][1] = $rawCorrelation[$level][$id][1]; } $rawCorrelation[$level][$id][2] = $this->corrGrades($level); if ($rawCorrelation[$level][$id][2] < 0) { $correlation[$level][$id][2] = -$rawCorrelation[$level][$id][2]; } else { $correlation[$level][$id][2] = $rawCorrelation[$level][$id][2]; } $rawCorrelation[$level][$id][3] = $this->corrStbracket($level); if ($rawCorrelation[$level][$id][3] < 0) { $correlation[$level][$id][3] = -$rawCorrelation[$level][$id][3]; } else { $correlation[$level][$id][3] = $rawCorrelation[$level][$id][3]; } $rawCorrelation[$level][$id][4] = $this->corrRegion($level); if ($rawCorrelation[$level][$id][4] < 0) { $correlation[$level][$id][4] = -$rawCorrelation[$level][$id][4]; } else { $correlation[$level][$id][4] = $rawCorrelation[$level][$id][4]; } $rawCorrelation[$level][$id][6] = $this->corrUnits($level); if ($rawCorrelation[$level][$id][6] < 0) { $correlation[$level][$id][6] = -$rawCorrelation[$level][$id][6]; } else { $correlation[$level][$id][6] = $rawCorrelation[$level][$id][6]; } $rawCorrelation[$level][$id][8] = $this->corrUnemployment($level); if ($rawCorrelation[$level][$id][8] < 0) { $correlation[$level][$id][8] = -$rawCorrelation[$level][$id][8]; } else { $correlation[$level][$id][8] = $rawCorrelation[$level][$id][8]; } $rawCorrelation[$level][$id][7] = $this->corrHighGrades($level); if ($rawCorrelation[$level][$id][7] < 0) { $correlation[$level][$id][7] = -$rawCorrelation[$level][$id][7]; } else { $correlation[$level][$id][7] = $rawCorrelation[$level][$id][7]; } $rawCorrelation[$level][$id][9] = $this->corrOverloading($level); if ($rawCorrelation[$level][$id][9] < 0) { $correlation[$level][$id][9] = -$rawCorrelation[$level][$id][9]; } else { $correlation[$level][$id][9] = $rawCorrelation[$level][$id][9]; } //College Level $level = 'college'; foreach ($colleges as $college) { $id = $college->unitid; $rawCorrelation[$level][$id][1] = $this->corrEmployment($level, $id); if ($rawCorrelation[$level][$id][1] < 0) { $correlation[$level][$id][1] = -$rawCorrelation[$level][$id][1]; } else { $correlation[$level][$id][1] = $rawCorrelation[$level][$id][1]; } $rawCorrelation[$level][$id][2] = $this->corrGrades($level, $id); if ($rawCorrelation[$level][$id][2] < 0) { $correlation[$level][$id][2] = -$rawCorrelation[$level][$id][2]; } else { $correlation[$level][$id][2] = $rawCorrelation[$level][$id][2]; } $rawCorrelation[$level][$id][3] = $this->corrStbracket($level, $id); if ($rawCorrelation[$level][$id][3] < 0) { $correlation[$level][$id][3] = -$rawCorrelation[$level][$id][3]; } else { $correlation[$level][$id][3] = $rawCorrelation[$level][$id][3]; } $rawCorrelation[$level][$id][4] = $this->corrRegion($level, $id); if ($rawCorrelation[$level][$id][4] < 0) { $correlation[$level][$id][4] = -$rawCorrelation[$level][$id][4]; } else { $correlation[$level][$id][4] = $rawCorrelation[$level][$id][4]; } $rawCorrelation[$level][$id][6] = $this->corrUnits($level, $id); if ($rawCorrelation[$level][$id][6] < 0) { $correlation[$level][$id][6] = -$rawCorrelation[$level][$id][6]; } else { $correlation[$level][$id][6] = $rawCorrelation[$level][$id][6]; } $rawCorrelation[$level][$id][8] = $this->corrUnemployment($level, $id); if ($rawCorrelation[$level][$id][8] < 0) { $correlation[$level][$id][8] = -$rawCorrelation[$level][$id][8]; } else { $correlation[$level][$id][8] = $rawCorrelation[$level][$id][8]; } $rawCorrelation[$level][$id][7] = $this->corrHighGrades($level, $id); if ($rawCorrelation[$level][$id][7] < 0) { $correlation[$level][$id][7] = -$rawCorrelation[$level][$id][7]; } else { $correlation[$level][$id][7] = $rawCorrelation[$level][$id][7]; } $rawCorrelation[$level][$id][9] = $this->corrOverloading($level, $id); if ($rawCorrelation[$level][$id][9] < 0) { $correlation[$level][$id][9] = -$rawCorrelation[$level][$id][9]; } else { $correlation[$level][$id][9] = $rawCorrelation[$level][$id][9]; } } //Department Level $level = 'department'; foreach ($departments as $department) { $id = $department->unitid; $rawCorrelation[$level][$id][1] = $this->corrEmployment($level, $id); if ($rawCorrelation[$level][$id][1] < 0) { $correlation[$level][$id][1] = -$rawCorrelation[$level][$id][1]; } else { $correlation[$level][$id][1] = $rawCorrelation[$level][$id][1]; } $rawCorrelation[$level][$id][2] = $this->corrGrades($level, $id); if ($rawCorrelation[$level][$id][2] < 0) { $correlation[$level][$id][2] = -$rawCorrelation[$level][$id][2]; } else { $correlation[$level][$id][2] = $rawCorrelation[$level][$id][2]; } $rawCorrelation[$level][$id][3] = $this->corrStbracket($level, $id); if ($rawCorrelation[$level][$id][3] < 0) { $correlation[$level][$id][3] = -$rawCorrelation[$level][$id][3]; } else { $correlation[$level][$id][3] = $rawCorrelation[$level][$id][3]; } $rawCorrelation[$level][$id][4] = $this->corrRegion($level, $id); if ($rawCorrelation[$level][$id][4] < 0) { $correlation[$level][$id][4] = -$rawCorrelation[$level][$id][4]; } else { $correlation[$level][$id][4] = $rawCorrelation[$level][$id][4]; } $rawCorrelation[$level][$id][6] = $this->corrUnits($level, $id); if ($rawCorrelation[$level][$id][6] < 0) { $correlation[$level][$id][6] = -$rawCorrelation[$level][$id][6]; } else { $correlation[$level][$id][6] = $rawCorrelation[$level][$id][6]; } $rawCorrelation[$level][$id][8] = $this->corrUnemployment($level, $id); if ($rawCorrelation[$level][$id][8] < 0) { $correlation[$level][$id][8] = -$rawCorrelation[$level][$id][8]; } else { $correlation[$level][$id][8] = $rawCorrelation[$level][$id][8]; } $rawCorrelation[$level][$id][7] = $this->corrHighGrades($level, $id); if ($rawCorrelation[$level][$id][7] < 0) { $correlation[$level][$id][7] = -$rawCorrelation[$level][$id][7]; } else { $correlation[$level][$id][7] = $rawCorrelation[$level][$id][7]; } $rawCorrelation[$level][$id][9] = $this->corrOverloading($level, $id); if ($rawCorrelation[$level][$id][9] < 0) { $correlation[$level][$id][9] = -$rawCorrelation[$level][$id][9]; } else { $correlation[$level][$id][9] = $rawCorrelation[$level][$id][9]; } } //Program Level $level = 'program'; foreach ($programs as $program) { $id = $program->programid; $rawCorrelation[$level][$id][1] = $this->corrEmployment($level, $id); if ($rawCorrelation[$level][$id][1] < 0) { $correlation[$level][$id][1] = -$rawCorrelation[$level][$id][1]; } else { $correlation[$level][$id][1] = $rawCorrelation[$level][$id][1]; } $rawCorrelation[$level][$id][2] = $this->corrGrades($level, $id); if ($rawCorrelation[$level][$id][2] < 0) { $correlation[$level][$id][2] = -$rawCorrelation[$level][$id][2]; } else { $correlation[$level][$id][2] = $rawCorrelation[$level][$id][2]; } $rawCorrelation[$level][$id][3] = $this->corrStbracket($level, $id); if ($rawCorrelation[$level][$id][3] < 0) { $correlation[$level][$id][3] = -$rawCorrelation[$level][$id][3]; } else { $correlation[$level][$id][3] = $rawCorrelation[$level][$id][3]; } $rawCorrelation[$level][$id][4] = $this->corrRegion($level, $id); if ($rawCorrelation[$level][$id][4] < 0) { $correlation[$level][$id][4] = -$rawCorrelation[$level][$id][4]; } else { $correlation[$level][$id][4] = $rawCorrelation[$level][$id][4]; } $rawCorrelation[$level][$id][6] = $this->corrUnits($level, $id); if ($rawCorrelation[$level][$id][6] < 0) { $correlation[$level][$id][6] = -$rawCorrelation[$level][$id][6]; } else { $correlation[$level][$id][6] = $rawCorrelation[$level][$id][6]; } $rawCorrelation[$level][$id][8] = $this->corrUnemployment($level, $id); if ($rawCorrelation[$level][$id][8] < 0) { $correlation[$level][$id][8] = -$rawCorrelation[$level][$id][8]; } else { $correlation[$level][$id][8] = $rawCorrelation[$level][$id][8]; } $rawCorrelation[$level][$id][7] = $this->corrHighGrades($level, $id); if ($rawCorrelation[$level][$id][7] < 0) { $correlation[$level][$id][7] = -$rawCorrelation[$level][$id][7]; } else { $correlation[$level][$id][7] = $rawCorrelation[$level][$id][7]; } $rawCorrelation[$level][$id][9] = $this->corrOverloading($level, $id); if ($rawCorrelation[$level][$id][9] < 0) { $correlation[$level][$id][9] = -$rawCorrelation[$level][$id][9]; } else { $correlation[$level][$id][9] = $rawCorrelation[$level][$id][9]; } } return View::make('correlation.correlation', compact('rawCorrelation', 'correlation', 'programs', 'departments', 'colleges', 'factors', 'factorNames', 'programNames', 'departmentNames', 'collegeNames')); }