public static function create_token(Token $clientid, Token $userid, $tokenType, $expires)
{
$token = Token::generateToken($tokenType, $userid->getUserSecret());
$query = Database::generate_query("token_create", [$token->toString(), $userid->toString(), $clientid->toString(), $expires]);
$query->execute();
return $token;
}
public static function fetch_assignment_profile(Token $token)
{
$query = Database::generate_query("assignment_lookup_id", [$token->toString()]);
$result = $query->execute();
$row = $result->fetch_data();
return ["assignment-id" => $token->toString(), "assessment-id" => Token::decode($row['assessment_id']), "deadline" => $row['assignment_deadline']];
}
public static function delete_question(AssessmentProfile $profile, Token $id)
{
$query = Database::generate_query("assessment_question_delete", [$profile->getAssessmentId()->toString(), $id->toString()]);
$query->execute();
}
public static function check_group_permission(GroupProfile $profile, $permission)
{
$query = Database::generate_query("group_permission_check", [$profile->getGroupId()->toString(), $permission]);
$result = $query->execute();
$count = $result->count();
$result->close();
return $count >= 1;
}
public static function fetch_user_scores(UserProfile $user, array $assignment)
{
$query = Database::generate_query("user_assignment_score", [$user->getUserId()->toString(), $assignment["assignment-id"]]);
$result = $query->execute();
$row = $result->fetch_data();
if ($row['score_id'] == null) {
return null;
}
$data = ["completed" => $row['date_completed'], "score" => $row['score']];
$query = Database::generate_query("user_assignment_question_scores", [$user->getUserId()->toString(), $assignment["assignment-id"], $row['score_id']]);
$result = $query->execute();
$i = 1;
while ($row = $result->fetch_data()) {
$data["questions"]["" . $i++] = $row['score'];
}
return $data;
}
