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