public static function getBatchShiftsCollege($batch, $collegeid) { $batchEnd = $batch + 100000; $programids = Studentshift::getCollPrograms($collegeid); return Studentshift::select('studentid')->where('studentid', '>=', $batch)->where('studentid', '<', $batchEnd)->whereIn('program1id', $programids)->get(); }
public function getShiftSpecificBatchSTBracketCount($batch) { $min = $batch * 100000; $max = $batch + 100000; $bracketArray = []; $dropouts = DB::table('studentdropouts')->where('lastprogramid', $this->programid)->lists('studentid'); if ($this->programid == 28) { $programShiftees = Studentshift::select('studentid')->where('studentid', '>', $min)->where('studentid', '<', $max)->where('program1id', $this->programid)->where('program2id', '!=', 38)->where('program1years', '<=', $this->numyears) > whereNotIn('studentid', $dropouts)->groupBy('studentid')->lists('studentid'); } else { $programShiftees = Studentshift::select('studentid')->where('studentid', '>', $min)->where('studentid', '<', $max)->where('program1id', $this->programid)->where('program1years', '<', $this->numyears) > whereNotIn('studentid', $dropouts)->groupBy('studentid')->lists('studentid'); } $programShiftees = array_unique($programShiftees); $shifteeCount = count($programShiftees); $bracketA = 0; $bracketB = 0; $bracketC = 0; $bracketD = 0; $bracketE1 = 0; $bracketE2 = 0; $unstated = 0; foreach ($programShiftees as $shiftee) { $results = Studentterm::select('stfapbracket')->where('studentid', $shiftee)->where('programid', $this->programid)->groupBy('stfapbracket')->lists('stfapbracket'); foreach ($results as $result) { switch ($result) { case strpos($result, 'A') !== false || strpos($result, '9') !== false: $bracketA++; break; case strpos($result, 'B') !== false: $bracketB++; break; case strpos($result, 'C') !== false: $bracketC++; break; case strpos($result, 'D') !== false: $bracketD++; break; case strpos($result, 'E1') !== false: $bracketE1++; break; case strpos($result, 'E2') !== false || strpos($result, '1') !== false: $bracketE2++; break; default: } } } if ($shifteeCount != 0) { $tagged = $bracketA + $bracketB + $bracketC + $bracketD + $bracketE1 + $bracketE2; $bracketArray["A"] = round($bracketA / $tagged * 100, 2); $bracketArray["B"] = round($bracketB / $tagged * 100, 2); $bracketArray["C"] = round($bracketC / $tagged * 100, 2); $bracketArray["D"] = round($bracketD / $tagged * 100, 2); $bracketArray["E1"] = round($bracketE1 / $tagged * 100, 2); $bracketArray["E2"] = round($bracketE2 / $tagged * 100, 2); } else { $bracketArray["No Shiftees"] = 0; } return $bracketArray; }