$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");
}
