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