public function getQuestionBySurvey(SxCms_Survey $survey) { $db = Zend_Registry::get('db'); $select = $db->select()->from(array('sq' => 'SurveyQuestion'), array('*'))->where('sq.survey_id = ?', $survey->getId())->where('sq.language = ?', $survey->getLanguage()); $results = $db->fetchAll($select); foreach ($results as $result) { $question = new SxCms_Survey_Question(); $question->setId($result['question_id'])->setSurveyId($result['survey_id'])->setLanguage($result['language'])->setQuestion($result['question'])->setType($result['type'])->setComment($result['comment']); $survey->addQuestion($question, $result['question_id']); $proxy = new SxCms_Survey_Question_Answer_Proxy(); $proxy->getAnswerByQuestion($question); } return; }
public function getAllSurveys() { $db = Zend_Registry::get('db'); $select = $db->select()->from(array('s' => 'Survey'), array('*'))->where('s.language = ?', $_SESSION['System']['lng']); $stmt = $db->query($select); $results = $stmt->fetchAll(); $surveys = array(); foreach ($results as $result) { $datePublished = split(' ', $result['date_published']); $dateExpired = split(' ', $result['date_expired']); $survey = new SxCms_Survey(); $survey->setId($result['survey_id'])->setLanguage($result['language'])->setTitle($result['title'])->setDescription($result['description'])->setDatePublished($datePublished[0])->setTimePublished($datePublished[1])->setDateExpired($dateExpired[0])->setTimeExpired($dateExpired[1]); $surveys[] = $survey; } return $surveys; }