public function uploadCollaborationData($group_id, $text, $voice, $drawing, $code) { if (isset($group_id)) { $user_id = user::authService()['user_id']; $sql = "INSERT INTO collaboration_data (group_id, user_id, text_msg_no, voice_msg_no, drawing_no, code_no) VALUES ('{$group_id}', '{$user_id}', '{$text}', '{$voice}', '{$drawing}', '{$code}')"; $this->query($sql); } }
public static function logout() { if (session_status() == PHP_SESSION_NONE) { session_start(); } unset($_SESSION['codeTogether']); session_destroy(); user::authService(); }
public function __construct($file = null) { parent::__construct(); $this->basePath = dirname(dirname(dirname(__FILE__))); $this->user = user::authService(); if (!is_null($file)) { $this->file = $file; } $this->questionPath = $this->basePath . "/" . $this->masterFolder . "/questions/"; }
public function submitMessage($group_id, $message, $type) { $user_id = user::authService()['user_id']; $message = $this->escape($message); $sql = "INSERT INTO chat (group_id, user_id, content, type) VALUES ('{$group_id}', '{$user_id}', '{$message}', '{$type}')"; $this->query($sql); if ($type == 'voice') { $sql = "SELECT chat_id FROM chat WHERE group_id = '{$group_id}' ORDER BY chat_id DESC LIMIT 1"; $result = $this->query($sql); $row = $result->fetch_assoc(); return $row["chat_id"]; } }
public function info($assignment_id = null) { global $db; if (is_null($assignment_id)) { $assignment_id = $this->assignment_id; } $user_id = user::authService()['user_id']; if (!isset($assignment_id) && !isset($user_id)) { return -1; } $db->where("assignment_id", $assignment_id); $result = $db->get("assignment")[0]; $db->where("type_id", $assignment_id); $db->where("type", "question"); $resultFile = $db->get("file"); $files = array(); foreach ($resultFile as $rowFile) { $filepath = file::getFilename($rowFile['file_id'], $rowFile['extension']); $rowFile['filepath'] = $filepath; $files[] = $rowFile; } $result['files'] = $files; if (user::isStudent()) { $result['group_id'] = Assignment::groupID($assignment_id); $result['editor'] = Assignment::getEditor($result['group_id']); } elseif (user::isTeacher()) { $db->where("assignment_id", $assignment_id); $result2 = $db->get("assignment_group", "COUNT(*) as group_count")[0]; $result['group_count'] = $result2['group_count']; $deadline = explode(" ", $result['deadline']); $result['due_date'] = $deadline[0]; $result['due_time'] = $deadline[1]; $db->where("assignment_id", $assignment_id); $sample_codes = $db->get("assignment_sample_code"); $result['sample_code'] = $sample_codes; } $result['deadline_time'] = strtotime($result['deadline']); if (time() > $result['deadline_time']) { $result['overdue'] = true; } else { $result['overdue'] = false; $diff = $result['deadline_time'] - time(); $result['deadline_day'] = ceil($diff / 60 / 60 / 24); } return $result; }
; var group_id = <?php echo isset($assignment['group_id']) ? $assignment['group_id'] : (isset($group_id) ? $group_id : 0); ?> ; var assignment_id = <?php echo isset($assignment) ? $assignment['assignment_id'] : 0; ?> ; var user_name = "<?php echo user::authService()['user_name']; ?> "; var user_id = <?php echo user::authService()['user_id']; ?> ; var user_avatar = "<?php echo user::avatar(); ?> "; </script> <script> var notification = function(msg, type){ if(typeof type === undefined){ type = 'info'; } $('body').pgNotification({ message: msg,
?> </div> </div> <!-- <div class=" pull-right"> <div class="header-inner"> <a href="#" class="btn-link icon-set menu-hambuger-plus m-l-20 sm-no-margin hidden-sm hidden-xs" data-toggle="quickview" data-toggle-element="#quickview"></a> </div> </div> --> <div class=" pull-right"> <!-- START User Info--> <div class="visible-lg visible-md m-t-10"> <div class="pull-left p-r-10 p-t-10 fs-16 font-heading"> <span class="semi-bold"><?php echo user::authService()['user_name']; ?> </span> <span class="text-master"></span> </div> <div class="thumbnail-wrapper d32 circular inline m-t-5"> <img src="<?php echo user::avatar(); ?> " alt="" width="32" height="32"> </div> </div> <!-- END User Info--> </div> </div> <!-- END HEADER -->
public function courseAssignmentList($course_id = null) { global $db; $user_id = user::authService()['user_id']; if (is_null($course_id)) { $course_id = $this->course_id; } if (!isset($course_id) && !isset($user_id)) { return -1; } if (user::isTeacher()) { } else { $db->where("status", 'publish'); } $db->where("course_id", $course_id); $db->where("is_questionbank", 0); $db->where("is_deleted", 0); $data = $db->get("assignment"); $assignments = array(); foreach ($data as $assignment) { $assignments[] = Assignment::info($assignment['assignment_id']); } return $assignments; }
public function courseAssignmentList($course_id = null) { $user_id = user::authService()['user_id']; if (is_null($course_id)) { $course_id = $this->course_id; } if (!isset($course_id) && !isset($user_id)) { return -1; } if (user::isTeacher()) { $sql = "SELECT assignment_id FROM assignment WHERE course_id = '{$course_id}' "; } else { $sql = "SELECT assignment_id FROM assignment WHERE course_id = '{$course_id}' AND status = 'publish' "; } //echo $sql; $result = $this->query($sql); $assignment = array(); while ($row = $result->fetch_assoc()) { $assignment[] = assignment::assignmentInfo($row['assignment_id']); } return $assignment; }
/** * assignmentInfo function. * * @access public * @param mixed $assignment_id * @return void */ public function assignmentInfo($assignment_id) { $user_id = user::authService()['user_id']; if (!isset($assignment_id) && !isset($user_id)) { return -1; } $sql = "SELECT * FROM assignment WHERE assignment_id = '{$assignment_id}' "; $result = $this->query($sql); $row = $result->fetch_assoc(); $sqlFile = "SELECT * FROM file WHERE type_id = {$assignment_id} AND type = 'question' "; $resultFile = $this->query($sqlFile); $files = array(); while ($rowFile = $resultFile->fetch_assoc()) { $filepath = file::getFilename($rowFile['file_id'], $rowFile['extension']); $rowFile['filepath'] = $filepath; $files[] = $rowFile; } $row['files'] = $files; if (user::isStudent()) { $row['group_id'] = assignment::groupID($assignment_id); $row['editor'] = assignment::getEditor($row['group_id']); } elseif (user::isTeacher()) { $sql2 = "SELECT COUNT(*) as group_count FROM assignment_group WHERE assignment_id = '{$assignment_id}' "; $result2 = $this->query($sql2); $row2 = $result2->fetch_assoc(); $row['group_count'] = $row2['group_count']; $deadline = explode(" ", $row['deadline']); $row['due_date'] = $deadline[0]; $row['due_time'] = $deadline[1]; $sql3 = "SELECT * FROM assignment_sample_code WHERE assignment_id = '{$assignment_id}' "; $result3 = $this->query($sql3); $sample_codes = array(); while ($row3 = $result3->fetch_assoc()) { $sample_codes[] = $row3; } $row['sample_code'] = $sample_codes; } return $row; }
public static function avatar($user_id = null) { if (is_null($user_id)) { $user_id = user::authService()['user_id']; } if (file_exists(dirname(dirname(dirname(__FILE__))) . "/files/avatar/{$user_id}.jpg")) { return "/files/avatar/{$user_id}.jpg"; } else { return "/files/avatar/user.jpg"; } }