public function getSpecificBatchRegionCount($batch)
{
$batch = $batch * 100000;
$batchEnd = $batch + 100000;
$regionArray = [];
$programDropouts = Studentdropout::where('lastprogramid', $this->programid)->where('studentid', '>', $batch)->where('studentid', '<', $batchEnd)->get();
$luzon = 0;
$visayas = 0;
$mindanao = 0;
$unstated = 0;
$luzonRegions = ['NCR', 'I', 'CAR', 'II', 'III', 'IV', 'V'];
$visayasRegions = ['VI', 'VII', 'VIII'];
$mindanaoRegions = ['IX', 'X', 'XI', 'XII', 'XIII', 'ARMM'];
foreach ($programDropouts as $dropout) {
$regionHolder = Studentaddress::getOneRegion($dropout->studentid);
if (count($regionHolder) > 0) {
if (in_array($regionHolder->regioncode, $luzonRegions)) {
$luzon++;
} elseif (in_array($regionHolder->regioncode, $visayasRegions)) {
$visayas++;
} elseif (in_array($regionHolder->regioncode, $mindanaoRegions)) {
$mindanao++;
}
} else {
$unstated++;
}
}
$regionArray['Luzon'] = $luzon;
$regionArray['Visayas'] = $visayas;
$regionArray['Mindanao'] = $mindanao;
$regionArray['Unstated'] = $unstated;
return $regionArray;
}
