public function executeQuestion()
{
$question = QuestionPeer::getQuestionFromTitle($this->getRequestParameter('stripped_title'));
$this->forward404Unless($question);
// answers
$c = new Criteria();
$c->add(AnswerPeer::QUESTION_ID, $question->getId());
$c->addDescendingOrderByColumn(AnswerPeer::CREATED_AT);
$c->setLimit(sfConfig::get('app_feed_max_questions'));
$answers = AnswerPeer::doSelect($c);
$feed = sfFeed::newInstance('rss201rev2');
// channel
$feed->setTitle($question->getTitle() . ' feed');
$feed->setLink('@question?stripped_title=' . $question->getStrippedTitle());
$feed->setFeedUrl('@feed_question?stripped_title=' . $question->getStrippedTitle());
$feed->setDescription('Latest answers to the question: ' . $question->getTitle());
// items
$feed->setItems($answers);
$this->feed = $feed;
}
public function getAnswers($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseAnswerPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collAnswers === null) {
if ($this->isNew()) {
$this->collAnswers = array();
} else {
$criteria->add(AnswerPeer::QUESTION_ID, $this->getId());
AnswerPeer::addSelectColumns($criteria);
$this->collAnswers = AnswerPeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(AnswerPeer::QUESTION_ID, $this->getId());
AnswerPeer::addSelectColumns($criteria);
if (!isset($this->lastAnswerCriteria) || !$this->lastAnswerCriteria->equals($criteria)) {
$this->collAnswers = AnswerPeer::doSelect($criteria, $con);
}
}
}
$this->lastAnswerCriteria = $criteria;
return $this->collAnswers;
}
public static function retrieveByPKs($pks, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria();
$criteria->add(AnswerPeer::ID, $pks, Criteria::IN);
$objs = AnswerPeer::doSelect($criteria, $con);
}
return $objs;
}
public function getPopularAnswers()
{
$c = new Criteria();
$c->add(AnswerPeer::QUESTION_ID, $this->getId());
$c->addAsColumn('relevancy', AnswerPeer::RELEVANCY_UP . ' / (' . AnswerPeer::RELEVANCY_UP . ' + ' . AnswerPeer::RELEVANCY_DOWN . ')');
$c->addDescendingOrderByColumn('relevancy');
$c->addDescendingOrderByColumn(AnswerPeer::RELEVANCY_UP);
return AnswerPeer::doSelect($c);
}
