/**
* 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]);
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
//up manila
$campus = Campus::where('unitid', 2)->first();
$yearlyStudentAverage = $campus->getStudentAverage();
$aveAttrition = $campus->getAveAttrition();
$batchAttrition = $campus->getBatchAttrition();
$aveDropouts = $campus->getAveDropouts();
$batchDropouts = $campus->getBatchDropouts();
$aveYearsBeforeDropout = $campus->getAveYearsBeforeDropout();
$aveDelayed = $campus->getAveDelayed();
$batchDelayed = $campus->getBatchDelayed();
//return page
return View::make('campus.campus', ['yearlyStudentAverage' => $yearlyStudentAverage, 'aveAttrition' => $aveAttrition, 'batchAttrition' => $batchAttrition, 'aveDropouts' => $aveDropouts, 'batchDropouts' => $batchDropouts, 'aveYearsBeforeDropout' => $aveYearsBeforeDropout, 'aveDelayed' => $aveDelayed, 'batchDelayed' => $batchDelayed]);
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('unitfactors', function (Blueprint $table) {
//
$table->increments('id');
$table->integer('unitid');
$table->integer('factorid');
$table->string('type');
$table->decimal('value');
$table->timestamps();
});
//seed table
$campus = Campus::where('unitid', 2)->first();
//employment
$employmentArray = $campus->getEmploymentCount();
//employed
$employmentFactor = new Unitfactor();
$employmentFactor->unitid = 2;
$employmentFactor->factorid = 1;
$employmentFactor->type = "Employed";
$employmentFactor->value = $employmentArray['Employed'];
$employmentFactor->save();
//unemployed
$employmentFactor = new Unitfactor();
$employmentFactor->unitid = 2;
$employmentFactor->factorid = 1;
$employmentFactor->type = "Unemployed";
$employmentFactor->value = $employmentArray['Unemployed'];
$employmentFactor->save();
//grades
$gradeArray = $campus->getGradeCount();
//passed
$gradeFactor = new Unitfactor();
$gradeFactor->unitid = 2;
$gradeFactor->factorid = 2;
$gradeFactor->type = "Passed";
$gradeFactor->value = $gradeArray['Passed'];
$gradeFactor->save();
//failed
$gradeFactor = new Unitfactor();
$gradeFactor->unitid = 2;
$gradeFactor->factorid = 2;
$gradeFactor->type = "Failed";
$gradeFactor->value = $gradeArray['Failed'];
$gradeFactor->save();
//region
$regionArray = $campus->getRegionCount();
//Luzon
$regionFactor = new Unitfactor();
$regionFactor->unitid = 2;
$regionFactor->factorid = 4;
$regionFactor->type = "Luzon";
$regionFactor->value = $regionArray['Luzon'];
$regionFactor->save();
//Visayas
$regionFactor = new Unitfactor();
$regionFactor->unitid = 2;
$regionFactor->factorid = 4;
$regionFactor->type = "Visayas";
$regionFactor->value = $regionArray['Visayas'];
$regionFactor->save();
//Mindanao
$regionFactor = new Unitfactor();
$regionFactor->unitid = 2;
$regionFactor->factorid = 4;
$regionFactor->type = "Mindanao";
$regionFactor->value = $regionArray['Mindanao'];
$regionFactor->save();
//stbracketKey
$stbracketArray = $campus->getSTBracketCount();
//A
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "A";
$stbracketFactor->value = $stbracketArray['A'];
$stbracketFactor->save();
//B
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "B";
$stbracketFactor->value = $stbracketArray['B'];
$stbracketFactor->save();
//C
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "C";
$stbracketFactor->value = $stbracketArray['C'];
$stbracketFactor->save();
//D
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "D";
$stbracketFactor->value = $stbracketArray['D'];
$stbracketFactor->save();
//E1
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "E1";
$stbracketFactor->value = $stbracketArray['E1'];
$stbracketFactor->save();
//E2
$stbracketFactor = new Unitfactor();
$stbracketFactor->unitid = 2;
$stbracketFactor->factorid = 3;
$stbracketFactor->type = "E2";
$stbracketFactor->value = $stbracketArray['E2'];
$stbracketFactor->save();
}
