/** * 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(); }