/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('units', function (Blueprint $table) {
//
$departmentlist = Department::whereHas('programs', function ($q) {
$q->whereNotIn('programid', array(62, 66, 38, 22));
$q->where('degreelevel', 'U');
})->get();
foreach ($departmentlist as $department) {
$unitname = $department->unitname;
if (strpos($unitname, 'Department of') !== false) {
$unitname = str_replace("Department of ", "", $unitname);
$unitname = substr_replace($unitname, " Department", strlen($unitname), 0);
}
$department->unitname = $unitname;
$department->save(['timestamps' => false]);
}
foreach ($departmentlist as $department) {
$unitname = $department->unitname;
if (strpos($unitname, ' Department') !== false) {
$unitname = str_replace(" Department", "", $unitname);
$unitname = substr_replace($unitname, "Department of ", 0, 0);
}
$department->unitname = $unitname;
$department->save(['timestamps' => false]);
}
});
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$departmentlist = Department::whereHas('programs', function ($q) {
$q->whereNotIn('programid', array(62, 66, 38));
$q->where('degreelevel', 'U');
})->get();
$collegelist = [];
foreach ($departmentlist as $department) {
array_push($collegelist, $department->college);
}
$collegelist = array_unique($collegelist);
//Average students per program
$collegeAveArray = [];
foreach ($collegelist as $college) {
$unitname = substr_replace($college->unitname, "\n", 11, 0);
//if colllege of allied medical professsions
if ($college->unitid === 9) {
$unitname = substr_replace($college->unitname, "\n", 18, 0);
}
$collStudents = round($college->getAveStudents(), 2);
$collegeAveArray[$unitname] = $collStudents;
$collAttrition = $college->getAveAttrition();
$collegeAveAttritionArray[$unitname] = $collAttrition;
}
//return page
return View::make('college.college', ['collegelist' => $collegelist, 'collegeAveArray' => $collegeAveArray, 'collegeAveAttritionArray' => $collegeAveAttritionArray]);
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('units', function (Blueprint $table) {
$table->decimal('years_before_drop')->nullable();
});
//campus
$campus = Campus::where('unitid', 2)->first();
$campus->years_before_drop = $campus->getAveYearsBeforeDropout();
$campus->ave_batch_attrition = $campus->getAveAttrition();
$campus->save(['timestamps' => false]);
//program
$programlist = Program::where('programs.degreelevel', 'U')->whereNotIn('programs.programid', array(62, 66, 38, 22))->get();
foreach ($programlist as $program) {
$program->years_stay = $program->getAveYearsOfStay();
$program->years_before_shift = $program->getAveYearsBeforeShifting();
$program->years_before_drop = $program->getAveYearsBeforeDropout();
$program->ave_batch_attrition = $program->getAveAttrition();
$program->ave_batch_shift = $program->getAveShiftRate();
$program->ave_students = $program->getAveStudents();
$program->save(['timestamps' => false]);
}
//department
$departmentlist = Department::whereHas('programs', function ($q) {
$q->whereNotIn('programid', array(62, 66, 38, 22));
$q->where('degreelevel', 'U');
})->get();
foreach ($departmentlist as $department) {
$department->ave_batch_attrition = $department->getAveAttrition();
$department->ave_batch_shift = $department->getAveShiftRate();
$department->ave_students = $department->getAveStudents();
$department->save(['timestamps' => false]);
}
//college
$departmentlist = Department::whereHas('programs', function ($q) {
$q->whereNotIn('programid', array(62, 66, 38, 22));
$q->where('degreelevel', 'U');
})->get();
$collegelist = [];
foreach ($departmentlist as $department) {
array_push($collegelist, $department->college);
}
$collegelist = array_unique($collegelist);
foreach ($collegelist as $college) {
$college->ave_batch_attrition = $college->getAveAttrition();
$college->ave_batch_shift = $college->getAveShiftRate();
$college->ave_students = $college->getAveStudents();
$college->save(['timestamps' => false]);
}
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$departmentlist = Department::whereHas('programs', function ($q) {
$q->whereNotIn('programid', array(62, 66, 38, 22));
$q->where('degreelevel', 'U');
})->get();
$collegelist = [];
foreach ($departmentlist as $department) {
array_push($collegelist, $department->college);
}
$collegelist = array_unique($collegelist);
foreach ($collegelist as $college) {
$college->ave_batch_attrition = $college->getAveAttrition();
$college->ave_batch_shift = $college->getAveShiftRate();
$college->ave_students = $college->getAveStudents();
$college->save(['timestamps' => false]);
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$departmentlist = Department::whereHas('programs', function ($q) {
$q->whereNotIn('programid', array(62, 66, 38));
$q->where('degreelevel', 'U');
})->get();
//Averaage students per program
$departmentAveArray = [];
$departmentAveAttritionArray = [];
foreach ($departmentlist as $department) {
$collStudents = round($department->getAveStudents(), 2);
$departmentAveArray[$department->unitname] = $collStudents;
$deptAttrition = $department->getAveAttrition();
$departmentAveAttritionArray[$department->unitname] = $deptAttrition;
}
//return page
return View::make('department.department', ['departmentlist' => $departmentlist, 'departmentAveArray' => $departmentAveArray, 'departmentAveAttritionArray' => $departmentAveAttritionArray]);
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('correlations', function (Blueprint $table) {
//
});
$departmentlist = Department::whereHas('programs', function ($q) {
$q->whereNotIn('programid', array(62, 66, 38));
$q->where('degreelevel', 'U');
})->get();
$collegelist = [];
$departmentids = [];
foreach ($departmentlist as $department) {
array_push($collegelist, $department->college);
array_push($departmentids, $department->unitid);
}
$collegelist = array_unique($collegelist);
$collegeids = [];
foreach ($collegelist as $college) {
array_push($collegeids, $college->unitid);
}
$entries = Correlation::where('unittype', 'college')->orWhere('unittype', 'department')->get();
foreach ($entries as $entry) {
if ($entry->unittype === 'college') {
$collegeid = $entry->collegeid;
if (in_array($collegeid, $collegeids)) {
} else {
$entry->delete();
}
} elseif ($entry->unittype === 'department') {
$departmentid = $entry->departmentid;
if (in_array($departmentid, $departmentids)) {
} else {
$entry->delete();
}
} else {
}
}
}
/**
* 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'));
}
