public function alterStbracket($batches, $allStudents) { foreach ($batches as $batch) { $students = $allStudents[$batch]; $totalPoor = 0; foreach ($students as $student) { $results = Studentterm::getOneStbracket($student->studentid); $poor = 0; foreach ($results as $result) { if (strpos($result->stfapbracket, 'A') !== false || strpos($result->stfapbracket, 'B') !== false || strpos($result->stfapbracket, '8') !== false || strpos($result->stfapbracket, '9') !== false) { $poor = 1; } } $totalPoor = $totalPoor + $poor; } $entry = Correlation::where('batch', $batch)->where('unittype', 'campus')->where('factorid', 3)->first(); $countStudents = count($students); if ($countStudents > 0) { $entry->ratio = $totalPoor / $countStudents; } else { $entry->ratio = 0; } $entry->save(); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::table('correlations', function (Blueprint $table) { // }); $entries = Correlation::where('unittype', 'program')->get(); foreach ($entries as $entry) { $batch = $entry->batch; $programid = $entry->programid; $dropoutsRaw = Studentdropout::getBatchDropoutsProgram($batch * 100000, $programid); $shiftsRaw = Studentshift::getBatchShiftsProgram($batch * 100000, $programid); $delayedRaw = Studentdelayed::getBatchDelayedProgram($batch * 100000, $programid); $studentids = []; foreach ($dropoutsRaw as $doRaw) { array_push($studentids, $doRaw->studentid); } foreach ($shiftsRaw as $sRaw) { array_push($studentids, $sRaw->studentid); } foreach ($delayedRaw as $dRaw) { array_push($studentids, $dRaw->studentid); } $studentids = array_values(array_unique($studentids)); $students = Studentterm::getBatchStudentsCountProgram($batch * 100000, $programid); if ($students > 0) { $entry->dropouts = count($studentids) / $students; } else { $entry->dropouts = 0; } $entry->save(); } }
public function alterUnits($batches, $allStudents, $programid) { foreach ($batches as $batch) { $students = $allStudents[$batch]; $totalUnderload = 0; $totalNodata = 0; foreach ($students as $student) { $units = Assessment::getOneAveUnitsProgram($student->studentid, $programid); if ($units === -1) { $totalNodata++; } else { if ($units < 15) { $totalUnderload++; } else { } } } $entry = Correlation::where('batch', $batch)->where('unittype', 'program')->where('programid', $programid)->where('factorid', 6)->first(); $countStudents = count($students); if ($countStudents - $totalNodata > 0) { $entry->ratio = $totalUnderload / ($countStudents - $totalNodata); } else { $entry->ratio = 0; } $entry->save(); } }
/** * Run the migrations. * * @return void */ public function up() { Schema::table('correlations', function (Blueprint $table) { // }); $entries = Correlation::where('unittype', 'campus')->get(); foreach ($entries as $entry) { $batch = $entry->batch; $dropouts = Studentdropout::getBatchDropoutsCount($batch * 100000); $delayed = Studentdelayed::getBatchDelayedCount($batch * 100000); $students = Studentterm::getBatchStudentsCount($batch * 100000); if ($students > 0) { $entry->dropouts = ($dropouts + $delayed) / $students; } else { $entry->dropouts = 0; } $entry->save(); } }
/** * 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 { } } }