public function getMyAnswer($user_id = null)
{
$user_id || ($user_id = $GLOBALS['user']->id);
if (!$user_id || $user_id === "nobody") {
$answer = new QuestionnaireAnswer();
$answer['user_id'] = $user_id;
$answer['question_id'] = $this->getId();
return $answer;
}
$statement = DBManager::get()->prepare("\n SELECT *\n FROM questionnaire_answers\n WHERE question_id = :question_id\n AND user_id = :me\n ");
$statement->execute(array('question_id' => $this->getId(), 'me' => $user_id));
$data = $statement->fetch(PDO::FETCH_ASSOC);
if ($data) {
return QuestionnaireAnswer::buildExisting($data);
} else {
$answer = new QuestionnaireAnswer();
$answer['user_id'] = $user_id;
$answer['question_id'] = $this->getId();
return $answer;
}
}
