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