$xtemplate = $path . "templates/career/outstanding_assignments_plan.html"; $file = $common->return_file_content($db_object, $xtemplate); $pattern = "/<{row_loopstart}>(.*?)<{row_loopend}>/s"; preg_match($pattern, $file, $match); $match = $match[0]; for ($i = 0; $i < count($result); $i++) { $userid = $result[$i][assigned_to]; $username = $common->name_display($db_object, $userid); $date = $result[$i][date]; $position_name = $result[$i][position_name]; $sql = "select email from {$user_table} where user_id='{$userid}'"; $res = $db_object->get_a_line($sql); $email = $res[email]; $pos_id = $result[$i][position_id]; $status = $result[$i][status]; if ($status != "y") { $highlight = "class=TR"; } else { $highlight = ""; } $str .= preg_replace("/<{(.*?)}>/e", "\$\$1", $match); } $file = preg_replace($pattern, $str, $file); $file = $common->direct_replace($db_object, $file, $xArray); echo $file; } } } $obj = new assignments(); $obj->outstanding_assignments($db_object, $common, $user_id, $error_msg, $gbl_date_format); include_once 'footer.php';
if (count($users) > 1) { $users_id = @implode(",", $users); $users_id = "(" . $users_id . ")"; } else { $users_id = "(" . $users[0] . ")"; } $qry = "select {$user_table}.user_id,{$user_table}.username,date_format({$position}.date_added,'%m.%d.%Y.%i:%s'),\n\t\t\n\t\t{$position}.position_name,{$user_table}.email from {$user_table},{$position} where \n\t\t\n\t\t{$user_table}.position={$position}.pos_id and {$user_table}.user_id in {$users_id} order by \n\t\t\n\t\t{$position}.date_added asc"; $res = $db_object->get_rsltset($qry); $path = $common->path; $xtemplate = $path . "templates/career/outstanding_assignments.html"; $file = $common->return_file_content($db_object, $xtemplate); $pattern = "/<{user_loopstart}>(.*?)<{user_loopend}>/s"; preg_match($pattern, $file, $match); $match = $match[0]; for ($a = 0; $a < count($res); $a++) { $user = $res[$a][user_id]; $name = $common->name_display($db_object, $user); $date = $res[$a][2]; $pos = $res[$a][position_name]; $email = $res[$a][email]; $str .= preg_replace("/<{(.*?)}>/e", "\$\$1", $match); } $file = preg_replace($pattern, $str, $file); $file = $common->direct_replace($db_object, $file, $values); echo $file; } } } $obj = new assignments(); $obj->outstanding_assignments($db_object, $common, $user_id); include_once "footer.php";
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; }
function checkUpload() { $toReturn = assignments::where('id', Input::get('assignmentId'))->first(); $StartDateArray = strptime($toReturn->AssignDeadLine, '%m/%d/%Y'); $sStartDateTimeStamp = mktime(0, 0, 0, $StartDateArray['tm_mon'] + 1, $StartDateArray['tm_mday'], $StartDateArray['tm_year'] + 1900); if ($sStartDateTimeStamp < time()) { return $this->panelInit->apiOutput(false, $this->panelInit->language['applyAssAnswer'], $this->panelInit->language['assDeadTime']); } $assignmentsAnswers = assignmentsAnswers::where('assignmentId', Input::get('assignmentId'))->where('userId', $this->data['users']->id)->count(); if ($assignmentsAnswers > 0) { return $this->panelInit->apiOutput(false, $this->panelInit->language['applyAssAnswer'], $this->panelInit->language['assAlreadySub']); } return array("canApply" => "true"); }