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; }