public static function getLatestAssignments()
{
$sectionCodes = SectionCode::where('teacher_id', new MongoId(Auth::id()))->where('status', true)->get();
$arraySectionCodes = array();
$arrayGroups = array();
foreach ($sectionCodes as $sectionCode) {
array_push($arraySectionCodes, new MongoId($sectionCode->_id));
}
$groups = Group::whereIn('section_code_id', $arraySectionCodes)->get();
foreach ($groups as $group) {
array_push($arrayGroups, new MongoId($group->_id));
}
$assignments = Assignment::whereIn('group_id', $arrayGroups)->get();
$arrayAssignments = array();
foreach ($assignments as $assignment) {
if ($assignment->date_assigned->sec >= Auth::user()->last_activity->sec) {
array_push($arrayAssignments, $assignment);
}
}
return $arrayAssignments;
}
public function totalAssignmentsByTeamLeader($arrayGroups, $groups)
{
$arrayTeamLeader = array();
$arrayStudent = array();
$arrayAssignment = array();
$array = array();
foreach ($groups as $group) {
array_push($arrayStudent, new MongoId($group->teamleader_id));
}
$arrayStudent = array_unique($arrayStudent);
foreach ($arrayStudent as $id) {
$user = Student::find($id);
array_push($arrayTeamLeader, $user->name . ' ' . $user->last_name);
array_push($arrayAssignment, Assignment::whereIn('group_id', $arrayGroups)->whereIn('assigned_by', array(new MongoId($id)))->count());
}
$array['names'] = $arrayTeamLeader;
$array['score'] = $arrayAssignment;
return $array;
}
