/**
  * 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]);
     }
 }
Beispiel #2
0
 /**
  * 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();
 }