public function getAnswerByQuestion(SxCms_Survey_Question $question)
{
$db = Zend_Registry::get('db');
$select = $db->select()->from(array('sqa' => 'SurveyQuestionAnswer'), array('*'))->where('sqa.survey_question_id = ?', $question->getId());
$results = $db->fetchAll($select);
foreach ($results as $result) {
$answer = new SxCms_Survey_Question_Answer();
$answer->setId($result['answer_id'])->setSurveyQuestionId($result['survey_question_id'])->setAnswer($result['answer']);
$question->addAnswer($answer, $result['answer_id']);
}
return;
}
public function addAnswerAction()
{
$questionId = $this->_getParam('questionId');
$key = $this->_getParam('key');
if ($key != "") {
$question = $this->_questions[$questionId];
$answer = $question->getAnswer($key);
} else {
$answer = new SxCms_Survey_Question_Answer();
}
if ($this->getRequest()->isPost()) {
$answer->setSurveyQuestionId($questionId)->setAnswer($this->_getParam('answer'));
if ($key != "") {
$question = $this->_questions[$questionId];
$question->removeAnswer($key);
}
$question = $this->_questions[$answer->getSurveyQuestionId()];
$question->addAnswer($answer, $key);
}
$this->view->survey = $this->_survey;
$this->_helper->layout()->disableLayout();
$this->render('answertable');
}
