public function create() { $users = User::where('username', Input::get('toId'))->orWhere('email', Input::get('toId')); if ($users->count() == 0) { echo $this->panelInit->language['userisntExist']; exit; } $users = $users->first(); $messagesList = messagesList::where('userId', $this->data['users']->id)->where('toId', $users->id); if ($messagesList->count() == 0) { $messagesList = new messagesList(); $messagesList->userId = $this->data['users']->id; $messagesList->toId = $users->id; } else { $messagesList = $messagesList->first(); } $messagesList->lastMessage = Input::get('messageText'); $messagesList->lastMessageDate = time(); $messagesList->messageStatus = 0; $messagesList->save(); $toReturnId = $messagesList->id; $messagesList_ = messagesList::where('userId', $users->id)->where('toId', $this->data['users']->id); if ($messagesList_->count() == 0) { $messagesList_ = new messagesList(); $messagesList_->userId = $users->id; $messagesList_->toId = $this->data['users']->id; } else { $messagesList_ = $messagesList_->first(); } $messagesList_->lastMessage = Input::get('messageText'); $messagesList_->lastMessageDate = time(); $messagesList_->messageStatus = 1; $messagesList_->save(); $toReturnId_ = $messagesList_->id; $messages = new messages(); $messages->messageId = $toReturnId; $messages->userId = $this->data['users']->id; $messages->fromId = $this->data['users']->id; $messages->toId = $users->id; $messages->messageText = Input::get('messageText'); $messages->dateSent = time(); $messages->save(); $messages = new messages(); $messages->messageId = $toReturnId_; $messages->userId = $users->id; $messages->fromId = $this->data['users']->id; $messages->toId = $users->id; $messages->messageText = Input::get('messageText'); $messages->dateSent = time(); $messages->save(); return json_encode(array('messageId' => $toReturnId)); }
public function dashboardData() { $toReturn = array(); $toReturn['selectedAcYear'] = $this->panelInit->selectAcYear; $toReturn['language'] = $this->panelInit->language; $toReturn['role'] = $this->data['users']->role; $toReturn['stats'] = array(); $toReturn['stats']['classes'] = classes::count(); $toReturn['stats']['students'] = User::where('role', 'student')->where('activated', 1)->count(); $toReturn['stats']['teachers'] = User::where('role', 'teacher')->where('activated', 1)->count(); $toReturn['stats']['newMessages'] = messagesList::where('userId', $this->data['users']->id)->where('messageStatus', 1)->count(); $toReturn['messages'] = DB::select(DB::raw("SELECT messagesList.id as id,messagesList.lastMessageDate as lastMessageDate,messagesList.lastMessage as lastMessage,messagesList.messageStatus as messageStatus,users.fullName as fullName,users.id as userId FROM messagesList LEFT JOIN users ON users.id=IF(messagesList.userId = '" . $this->data['users']->id . "',messagesList.toId,messagesList.userId) where userId='" . $this->data['users']->id . "' order by id DESC limit 5")); $toReturn['attendanceModel'] = $this->data['panelInit']->settingsArray['attendanceModel']; if ($this->data['panelInit']->settingsArray['attendanceModel'] == "subject") { $subjects = subject::get(); foreach ($subjects as $subject) { $toReturn['subjects'][$subject->id] = $subject->subjectTitle; } } $date = date('m/Y'); $date = explode("/", $date); if ($this->data['users']->role == "student") { $attendanceArray = attendance::where('studentId', $this->data['users']->id)->where('date', 'like', $date[0] . "%")->where('date', 'like', "%" . $date[1])->get(); foreach ($attendanceArray as $value) { $toReturn['studentAttendance'][] = array("date" => $value->date, "status" => $value->status, "subject" => isset($toReturn['subjects'][$value->subjectId]) ? $toReturn['subjects'][$value->subjectId] : ""); } } elseif ($this->data['users']->role == "parent") { if ($this->data['users']->parentOf != "") { $parentOf = json_decode($this->data['users']->parentOf, true); $ids = array(); while (list(, $value) = each($parentOf)) { $ids[] = $value['id']; } $studentArray = User::where('role', 'student')->whereIn('id', $ids)->get(); foreach ($studentArray as $stOne) { $students[$stOne->id] = array('name' => $stOne->fullName, 'studentRollId' => $stOne->studentRollId); } if (count($ids) > 0) { $attendanceArray = attendance::whereIn('studentId', $ids)->where('date', 'like', $date[0] . "%")->where('date', 'like', "%" . $date[1])->get(); foreach ($attendanceArray as $value) { if (!isset($toReturn['studentAttendance'][$value->studentId])) { $toReturn['studentAttendance'][$value->studentId]['n'] = $students[$value->studentId]; $toReturn['studentAttendance'][$value->studentId]['d'] = array(); } $toReturn['studentAttendance'][$value->studentId]['d'][] = array("date" => $value->date, "status" => $value->status, "subject" => $value->subjectId); } } } } $toReturn['teacherLeaderBoard'] = User::where('role', 'teacher')->where('isLeaderBoard', '!=', '')->where('isLeaderBoard', '!=', '0')->get()->toArray(); $toReturn['studentLeaderBoard'] = User::where('role', 'student')->where('isLeaderBoard', '!=', '')->where('isLeaderBoard', '!=', '0')->get()->toArray(); $toReturn['newsEvents'] = array(); $newsboard = newsboard::where('newsFor', $this->data['users']->role)->orWhere('newsFor', 'all')->orderBy('id', 'desc')->limit(5)->get(); foreach ($newsboard as $event) { $eventsArray['id'] = $event->id; $eventsArray['title'] = $event->newsTitle; $eventsArray['type'] = "news"; $eventsArray['start'] = date("F j, Y", strtotime($event->newsDate)); $toReturn['newsEvents'][] = $eventsArray; } $events = events::orderBy('id', 'desc')->where('eventFor', $this->data['users']->role)->orWhere('eventFor', 'all')->limit(5)->get(); foreach ($events as $event) { $eventsArray['id'] = $event->id; $eventsArray['title'] = $event->eventTitle; $eventsArray['type'] = "event"; $eventsArray['start'] = date("F j, Y", strtotime($event->eventDate)); $toReturn['newsEvents'][] = $eventsArray; } $toReturn['academicYear'] = academicYear::get()->toArray(); $toReturn['baseUser'] = array("id" => $this->data['users']->id, "fullName" => $this->data['users']->fullName, "username" => $this->data['users']->username); $polls = polls::where('pollTarget', $this->data['users']->role)->orWhere('pollTarget', 'all')->where('pollStatus', '1')->first(); if (count($polls) > 0) { $toReturn['polls']['title'] = $polls->pollTitle; $toReturn['polls']['id'] = $polls->id; $toReturn['polls']['view'] = "vote"; $userVoted = json_decode($polls->userVoted, true); if (is_array($userVoted) and in_array($this->data['users']->id, $userVoted)) { $toReturn['polls']['voted'] = true; $toReturn['polls']['view'] = "results"; } $toReturn['polls']['items'] = json_decode($polls->pollOptions, true); $toReturn['polls']['totalCount'] = 0; if (is_array($toReturn['polls']['items']) and count($toReturn['polls']['items']) > 0) { while (list($key, $value) = each($toReturn['polls']['items'])) { if (isset($value['count'])) { $toReturn['polls']['totalCount'] += $value['count']; } if (!isset($toReturn['polls']['items'][$key]['prec'])) { $toReturn['polls']['items'][$key]['prec'] = 0; } } } } return json_encode($toReturn); }