public function calender() { $StartDateArray = strptime(Input::get('start'), '%Y-%m-%d'); $sStartDateTimeStamp = mktime(0, 0, 0, $StartDateArray['tm_mon'] + 1, $StartDateArray['tm_mday'], $StartDateArray['tm_year'] + 1900); $EndDateArray = strptime(Input::get('end'), '%Y-%m-%d'); $sEndDateTimeStamp = mktime(0, 0, 0, $EndDateArray['tm_mon'] + 1, $EndDateArray['tm_mday'], $EndDateArray['tm_year'] + 1900); $daysArray = $this->GetDays(Input::get('start'), Input::get('end')); $toReturn = array(); if ($this->data['users']->role == "admin") { $assignments = assignments::whereIn('AssignDeadLine', $daysArray)->get(); } elseif ($this->data['users']->role == "teacher") { $assignments = assignments::whereIn('AssignDeadLine', $daysArray)->where('teacherId', $this->data['users']->id)->get(); } elseif ($this->data['users']->role == "student") { $assignments = assignments::whereIn('AssignDeadLine', $daysArray)->where('classId', 'like', '%"' . $this->data['users']->studentClass . '"%')->get(); } if (isset($assignments)) { foreach ($assignments as $event) { $eventsArray['id'] = $event->id; $eventsArray['title'] = "Assignment : " . $event->AssignTitle; $eventsArray['start'] = date("c", strtotime($event->AssignDeadLine)); $eventsArray['backgroundColor'] = 'green'; $eventsArray['textColor'] = '#fff'; $eventsArray['url'] = "#assignments"; $eventsArray['allDay'] = true; $toReturn[] = $eventsArray; } } $events = events::whereIn('eventDate', $daysArray)->where('eventFor', $this->data['users']->role)->orWhere('eventFor', 'all')->get(); foreach ($events as $event) { $eventsArray['id'] = $event->id; $eventsArray['title'] = "Event : " . $event->eventTitle; $eventsArray['start'] = date("c", strtotime($event->eventDate)); $eventsArray['backgroundColor'] = 'blue'; $eventsArray['url'] = "#events/" . $event->id; $eventsArray['textColor'] = '#fff'; $eventsArray['allDay'] = true; $toReturn[] = $eventsArray; } $examsList = examsList::whereIn('examDate', $daysArray)->get(); foreach ($examsList as $event) { $eventsArray['id'] = $event->id; $eventsArray['title'] = "Exam : " . $event->examTitle; $eventsArray['start'] = date("c", strtotime($event->examDate)); $eventsArray['backgroundColor'] = 'red'; $eventsArray['url'] = "#examsList"; $eventsArray['textColor'] = '#fff'; $eventsArray['allDay'] = true; $toReturn[] = $eventsArray; } $newsboard = newsboard::where('creationDate', '>=', $sStartDateTimeStamp)->where('creationDate', '<=', $sEndDateTimeStamp)->where('newsFor', $this->data['users']->role)->orWhere('newsFor', 'all')->get(); foreach ($newsboard as $event) { $eventsArray['id'] = $event->id; $eventsArray['title'] = "News : " . $event->newsTitle; $eventsArray['start'] = date("c", $event->creationDate); $eventsArray['url'] = "#newsboard/" . $event->id; $eventsArray['backgroundColor'] = 'white'; $eventsArray['textColor'] = '#000'; $eventsArray['allDay'] = true; $toReturn[] = $eventsArray; } if ($this->data['users']->role == "admin") { $onlineExams = onlineExams::where('examDate', '>=', $sStartDateTimeStamp)->where('ExamEndDate', '<=', $sEndDateTimeStamp)->get(); } elseif ($this->data['users']->role == "teacher") { $onlineExams = onlineExams::where('examDate', '>=', $sStartDateTimeStamp)->where('ExamEndDate', '<=', $sEndDateTimeStamp)->where('examTeacher', $this->data['users']->id)->get(); } elseif ($this->data['users']->role == "student") { $onlineExams = onlineExams::where('examDate', '>=', $sStartDateTimeStamp)->where('ExamEndDate', '<=', $sEndDateTimeStamp)->where('examClass', 'like', '%"' . $this->data['users']->studentClass . '"%')->get(); } if (isset($onlineExams)) { foreach ($onlineExams as $event) { $eventsArray['id'] = $event->id; $eventsArray['title'] = "Online Exam : " . $event->examTitle; $eventsArray['start'] = date("c", strtotime($event->examDate)); $eventsArray['backgroundColor'] = 'red'; $eventsArray['url'] = "#onlineExams"; $eventsArray['textColor'] = '#000'; $eventsArray['allDay'] = true; $toReturn[] = $eventsArray; } } return $toReturn; }