public static function getBatchDropoutsCollege($batch, $collegeid) { $batchEnd = $batch + 100000; $programids = Studentdropout::getCollPrograms($collegeid); return Studentdropout::select('studentid')->where('studentid', '>=', $batch)->where('studentid', '<', $batchEnd)->whereIn('programid', $programids)->get(); }