/** * 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; }