Exemple #1
0
 public function executeQuestion()
 {
     $user = $this->authenticateUser();
     if (!$user) {
         $this->error_code = 1;
         $this->error_message = 'login failed';
         return array('api', 'errorSuccess');
     }
     if (!$this->getRequestParameter('stripped_title')) {
         $this->error_code = 2;
         $this->error_message = 'the API returns answers to a specific question. Please provide a stripped_title parameter';
         return array('api', 'errorSuccess');
     } else {
         // get the question
         $question = QuestionPeer::getQuestionFromTitle($this->getRequestParameter('stripped_title'));
         if ($question->getUserId() != $user->getId()) {
             $this->error_code = 3;
             $this->error_message = 'You can only use the API for the questions you asked';
             return array('api', 'errorSuccess');
         } else {
             // get the answers
             $this->answers = $question->getAnswers();
             $this->question = $question;
         }
     }
 }
 public function executeResetQuestionReports()
 {
     $question = QuestionPeer::getQuestionFromTitle($this->getRequestParameter('stripped_title'));
     $this->forward404Unless($question);
     $question->deleteReports();
     $question->save();
     $this->redirect($this->getRequest()->getReferer());
 }
Exemple #3
0
 public function executeSearch()
 {
     if ($this->getRequestParameter('search')) {
         $this->questions = QuestionPeer::search($this->getRequestParameter('search'), $this->getRequestParameter('search_all', false), ($this->getRequestParameter('page', 1) - 1) * sfConfig::get('app_search_results_max'), sfConfig::get('app_search_results_max'));
     } else {
         $this->redirect('@homepage');
     }
 }
 public function executeShow()
 {
     $this->question = QuestionPeer::retrieveByPk($this->getRequestParameter('id'));
     $c = new Criteria();
     $c->add(SolutionPeer::QUESTION_ID, $this->question->getId());
     $c->addDescendingOrderByColumn(SolutionPeer::CREATED_AT);
     $this->solutions = SolutionPeer::doSelect($c);
     $this->forward404Unless($this->question);
 }
Exemple #5
0
 public function executeInterested()
 {
     $this->question = QuestionPeer::retrieveByPk($this->getRequestParameter('id'));
     $this->forward404Unless($this->question);
     $user = $this->getUser()->getSubscriber();
     $interest = new Interest();
     $interest->setQuestion($this->question);
     $interest->setUser($user);
     $interest->save();
 }
Exemple #6
0
 public function executeRemove()
 {
     // disable web debug toolbar
     sfConfig::set('sf_web_debug', false);
     $this->question = QuestionPeer::getQuestionFromTitle($this->getRequestParameter('stripped_title'));
     $this->forward404Unless($this->question);
     // remove tag for this user and question
     $user = $this->getUser()->getSubscriber();
     $tag = $this->getRequestParameter('tag');
     $user->removeTag($this->question, $tag);
     $this->tags = $this->question->getTags();
     // clear the question tag list fragment in cache
     if (sfConfig::get('sf_cache')) {
         $this->getContext()->getViewCacheManager()->remove('@question?stripped_title=' . $this->question->getStrippedTitle(), 'fragment_question_tags');
     }
 }
Exemple #7
0
 public function executeAdd()
 {
     if ($this->getRequest()->getMethod() == sfRequest::POST) {
         if (!$this->getRequestParameter('body')) {
             return sfView::NONE;
         }
         $question = QuestionPeer::retrieveByPk($this->getRequestParameter('question_id'));
         $this->forward404Unless($question);
         // user or anonymous coward
         $user = $this->getUser()->isAuthenticated() ? $this->getUser()->getSubscriber() : UserPeer::getUserFromNickname('anonymous');
         // create answer
         $this->answer = new Answer();
         $this->answer->setQuestion($question);
         $this->answer->setBody($this->getRequestParameter('body'));
         $this->answer->setUser($user);
         $this->answer->save();
         return sfView::SUCCESS;
     }
     $this->forward404();
 }
Exemple #8
0
 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;
 }
Exemple #9
0
 public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
 {
     $keys = QuestionPeer::getFieldNames($keyType);
     if (array_key_exists($keys[0], $arr)) {
         $this->setId($arr[$keys[0]]);
     }
     if (array_key_exists($keys[1], $arr)) {
         $this->setUserId($arr[$keys[1]]);
     }
     if (array_key_exists($keys[2], $arr)) {
         $this->setTitle($arr[$keys[2]]);
     }
     if (array_key_exists($keys[3], $arr)) {
         $this->setBody($arr[$keys[3]]);
     }
     if (array_key_exists($keys[4], $arr)) {
         $this->setCreatedAt($arr[$keys[4]]);
     }
     if (array_key_exists($keys[5], $arr)) {
         $this->setUpdatedAt($arr[$keys[5]]);
     }
     if (array_key_exists($keys[6], $arr)) {
         $this->setInterestedUsers($arr[$keys[6]]);
     }
     if (array_key_exists($keys[7], $arr)) {
         $this->setStrippedTitle($arr[$keys[7]]);
     }
     if (array_key_exists($keys[8], $arr)) {
         $this->setHtmlBody($arr[$keys[8]]);
     }
 }
Exemple #10
0
 public static function doSelectJoinAllExceptUser(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     AnswerPeer::addSelectColumns($c);
     $startcol2 = AnswerPeer::NUM_COLUMNS - AnswerPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     QuestionPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + QuestionPeer::NUM_COLUMNS;
     $c->addJoin(AnswerPeer::QUESTION_ID, QuestionPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = AnswerPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = QuestionPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getQuestion();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addAnswer($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initAnswers();
             $obj2->addAnswer($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
<?php

define('SF_ROOT_DIR', realpath(dirname(__FILE__) . '/..'));
define('SF_APP', 'frontend');
define('SF_ENVIRONMENT', 'dev');
define('SF_DEBUG', true);
require_once SF_ROOT_DIR . DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR . SF_APP . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'config.php';
sfContext::getInstance();
$questions = QuestionPeer::doSelect(new Criteria());
foreach ($questions as $question) {
    $question->updateSearchIndex();
}
Exemple #12
0
 public function getQuestion($con = null)
 {
     include_once 'lib/model/om/BaseQuestionPeer.php';
     if ($this->aQuestion === null && $this->question_id !== null) {
         $this->aQuestion = QuestionPeer::retrieveByPK($this->question_id, $con);
     }
     return $this->aQuestion;
 }
<?php

if ($sf_user->hasCredential(array(0 => 'moderator'))) {
    ?>
  <h2><?php 
    echo __('moderation');
    ?>
</h2>

  <ul>
    <li><?php 
    echo link_to(__('reported questions'), 'moderator/reportedQuestions');
    ?>
 (<?php 
    echo QuestionPeer::getReportCount();
    ?>
)</li>
    <li><?php 
    echo link_to(__('reported answers'), 'moderator/reportedAnswers');
    ?>
 (<?php 
    echo AnswerPeer::getReportCount();
    ?>
)</li>
    <li><?php 
    echo link_to(__('unpopular tags'), 'moderator/unpopularTags');
    ?>
</li>
  </ul>
<?php 
}
 public function executeQuestion()
 {
     $this->question = QuestionPeer::getQuestionFromTitle($this->getRequestParameter('stripped_title'));
 }
 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(QuestionPeer::ID, $pks, Criteria::IN);
         $objs = QuestionPeer::doSelect($criteria, $con);
     }
     return $objs;
 }
Exemple #16
0
 public function countQuestions($criteria = null, $distinct = false, $con = null)
 {
     include_once 'lib/model/om/BaseQuestionPeer.php';
     if ($criteria === null) {
         $criteria = new Criteria();
     } elseif ($criteria instanceof Criteria) {
         $criteria = clone $criteria;
     }
     $criteria->add(QuestionPeer::USER_ID, $this->getId());
     return QuestionPeer::doCount($criteria, $distinct, $con);
 }
Exemple #17
0
 public function executeReportQuestion()
 {
     $this->question = QuestionPeer::retrieveByPk($this->getRequestParameter('id'));
     $this->forward404Unless($this->question);
     $spam = new ReportQuestion();
     $spam->setQuestionId($this->question->getId());
     $spam->setUserId($this->getUser()->getSubscriberId());
     $spam->save();
 }
<?php

$qid = $sf_request->getParameter('qid');
$c = new Criteria();
$c->add(QuestionPeer::ID, $qid);
$data = QuestionPeer::doSelect($c);
if ($data[0]) {
    echo $data[0]->getQuestion();
    echo input_hidden_tag('question_id', $qid);
    echo input_hidden_tag('qid', $qid);
}