Changeset 55 for trunk/lib

Timestamp:

12/20/05 11:44:03 (3 years ago)

Author:

fabien

Message:

day 20 modifications

Files:

• trunk/lib/model/Answer.php (modified) (1 diff)
• trunk/lib/model/AnswerPeer.php (modified) (2 diffs)
• trunk/lib/model/Question.php (modified) (1 diff)
• trunk/lib/model/QuestionPeer.php (modified) (1 diff)
• trunk/lib/model/QuestionTagPeer.php (modified) (1 diff)
• trunk/lib/model/ReportAnswer.php (added)
• trunk/lib/model/ReportAnswerPeer.php (added)
• trunk/lib/model/ReportQuestion.php (added)
• trunk/lib/model/ReportQuestionPeer.php (added)
• trunk/lib/model/UserPeer.php (modified) (1 diff)
• trunk/lib/model/map/AnswerMapBuilder.php (modified) (1 diff)
• trunk/lib/model/map/QuestionMapBuilder.php (modified) (1 diff)
• trunk/lib/model/map/QuestionTagMapBuilder.php (modified) (2 diffs)
• trunk/lib/model/map/ReportAnswerMapBuilder.php (added)
• trunk/lib/model/map/ReportQuestionMapBuilder.php (added)
• trunk/lib/model/map/UserMapBuilder.php (modified) (1 diff)
• trunk/lib/model/om/BaseAnswer.php (modified) (16 diffs)
• trunk/lib/model/om/BaseAnswerPeer.php (modified) (5 diffs)
• trunk/lib/model/om/BaseQuestion.php (modified) (16 diffs)
• trunk/lib/model/om/BaseQuestionPeer.php (modified) (5 diffs)
• trunk/lib/model/om/BaseQuestionTag.php (modified) (3 diffs)
• trunk/lib/model/om/BaseQuestionTagPeer.php (modified) (5 diffs)
• trunk/lib/model/om/BaseReportAnswer.php (added)
• trunk/lib/model/om/BaseReportAnswerPeer.php (added)
• trunk/lib/model/om/BaseReportQuestion.php (added)
• trunk/lib/model/om/BaseReportQuestionPeer.php (added)
• trunk/lib/model/om/BaseUser.php (modified) (16 diffs)
• trunk/lib/model/om/BaseUserPeer.php (modified) (5 diffs)

trunk/lib/model/Answer.php

@@ -39 +39 @@
-    $this->setHtmlBody(markdown($v));
-  }
+
+  public function deleteReports()
+  {
+    $reports = $this->getReportQuestions();
+    foreach ($reports as $report)
+    {
+      $report->delete();
+    }
+
+    $this->setReports(0);
+  }
+
+  public function deleteSpam($moderator)
+  {
+    $con = Propel::getConnection();
+    try
+    {
+      $con->begin();
+
+      $user = $this->getUser();
+      if ($user->getNickname() != 'anonymous')
+      {
+        $user->setDeletions($user->getDeletions() + 1);
+        $user->save();
+      }
+
+      $this->delete();
+
+      $con->commit();
+
+      $log = 'moderator "%s" deleted answer "%s" for question "%s" (%s)';
+      $log = sprintf($log, $moderator->getNickname(), $this->getId(), $this->getQuestion()->getTitle(), substr($this->getBody(), 0, 50));
+      sfContext::getInstance()->getLogger()->warning($log);
+    }
+    catch (PropelException $e)
+    {
+      $con->rollback();
+      throw $e;
+    }
+  }
-}
-

trunk/lib/model/AnswerPeer.php

@@ -50 +50 @@
-  }
-
-
+static 
-  {
-    $c = new Criteria();
@@ -58 +58 @@
-
-    return self::doSelectJoinUser($c);
+  }
+
+  public static function getReportedSpamPager($page)
+  {
+    $pager = new sfPager('Answer', APP_PAGER_HOMEPAGE_MAX);
+    $c = new Criteria();
+    $c->add(self::REPORTS, 0, Criteria::GREATER_THAN);
+    $c->setLimit(20);
+    $c->addDescendingOrderByColumn(self::REPORTS);
+    $c->addAscendingOrderByColumn(self::CREATED_AT);
+    $c = self::addPermanentTagToCriteria($c);
+    $pager->setCriteria($c);
+    $pager->setPage($page);
+    $pager->setPeerMethod('doSelectJoinUser');
+    $pager->init();
+
+    return $pager;
+  }
+
+  public static function getReportCount()
+  {
+    $c = new Criteria();
+    $c->add(self::REPORTS, 0, Criteria::GREATER_THAN);
+    $c = self::addPermanentTagToCriteria($c);
+
+    return self::doCount($c);
-  }
-

trunk/lib/model/Question.php

@@ -145 +145 @@
-    $c->addAsColumn('relevancy', AnswerPeer::RELEVANCY_UP.' / ('.AnswerPeer::RELEVANCY_UP.' + '.AnswerPeer::RELEVANCY_DOWN.')');
-    $c->addDescendingOrderByColumn('relevancy');
+    $c->addDescendingOrderByColumn(AnswerPeer::RELEVANCY_UP);
-
-    return AnswerPeer::doSelect($c);
+  }
+
+  public function deleteReports()
+  {
+    $reports = $this->getReportQuestions();
+    foreach ($reports as $report)
+    {
+      $report->delete();
+    }
+
+    $this->setReports(0);
+  }
+
+  public function deleteSpam($moderator)
+  {
+    $con = Propel::getConnection();
+    try
+    {
+      $con->begin();
+
+      $user = $this->getUser();
+      $user->setDeletions($user->getDeletions() + 1);
+      $user->save();
+
+      $this->delete();
+
+      $con->commit();
+
+      $log = 'moderator "%s" deleted question "%s"';
+      $log = sprintf($log, $moderator->getNickname(), $this->getTitle());
+      sfContext::getInstance()->getLogger()->warning($log);
+    }
+    catch (PropelException $e)
+    {
+      $con->rollback();
+      throw $e;
+    }
-  }
-}

trunk/lib/model/QuestionPeer.php

@@ -103 +103 @@
-  }
-
+  public static function getReportedSpamPager($page)
+  {
+    $pager = new sfPager('Question', APP_PAGER_HOMEPAGE_MAX);
+    $c = new Criteria();
+    $c->add(self::REPORTS, 0, Criteria::GREATER_THAN);
+    $c->setLimit(20);
+    $c->addDescendingOrderByColumn(self::REPORTS);
+    $c->addAscendingOrderByColumn(self::CREATED_AT);
+    $c = self::addPermanentTagToCriteria($c);
+    $pager->setCriteria($c);
+    $pager->setPage($page);
+    $pager->setPeerMethod('doSelectJoinUser');
+    $pager->init();
+
+    return $pager;
+  }
+
+  public static function getReportCount()
+  {
+    $c = new Criteria();
+    $c->add(self::REPORTS, 0, Criteria::GREATER_THAN);
+    $c = self::addPermanentTagToCriteria($c);
+
+    return self::doCount($c);
+  }
+
-  private static function addPermanentTagToCriteria($criteria)
-  {

trunk/lib/model/QuestionTagPeer.php

@@ -147 +147 @@
-    return $tags;
-  }
+
+  public static function getUnpopularTags()
+  {
+    $tags = array();
+
+    $con = Propel::getConnection();
+    $query = '
+      SELECT t1.normalized_tag AS tag,
+      COUNT(t1.normalized_tag) AS count
+      FROM '.QuestionTagPeer::TABLE_NAME.' AS t1';
+
+    if (defined('APP_PERMANENT_TAG'))
+    {
+      $query .= '
+        INNER JOIN '.QuestionTagPeer::TABLE_NAME.' AS t2 ON t1.question_id = t2.question_id
+        WHERE t2.normalized_tag = ? AND t1.normalized_tag != ?
+        AND count < 5
+      ';
+    }
+
+    $query .= '
+      GROUP BY t1.normalized_tag
+      ORDER BY count ASC
+    ';
+
+    $stmt = $con->prepareStatement($query);
+    if (defined('APP_PERMANENT_TAG'))
+    {
+      $stmt->setString(1, APP_PERMANENT_TAG);
+      $stmt->setString(2, APP_PERMANENT_TAG);
+    }
+    $rs = $stmt->executeQuery();
+    while ($rs->next())
+    {
+      $tags[$rs->getString('tag')] = $rs->getInt('count');
+    }
+
+    return $tags;
+  }
+
+  public static function getByNormalizedTag($tag)
+  {
+    $c = new Criteria();
+    $c->add(self::NORMALIZED_TAG, Tag::normalize($tag));
+
+    return self::doSelect($c);
+  }
+
+  public static function deleteSpam($moderator, $tag, $question_id = null)
+  {
+    if ($question_id === null)
+    {
+      $tags = self::getByNormalizedTag($tag);
+    }
+    else
+    {
+      $c = new Criteria();
+      $c->add(self::NORMALIZED_TAG, Tag::normalize($tag));
+      $c->add(self::QUESTION_ID, $question_id);
+
+      $tags = self::doSelect($c);
+    }
+
+    $con = Propel::getConnection();
+    try
+    {
+      $con->begin();
+
+      foreach ($tags as $tag)
+      {
+        $user = $tag->getUser();
+        $user->setDeletions($user->getDeletions() + 1);
+        $user->save();
+
+        $tag->delete();
+      }
+
+      $con->commit();
+
+      $log = 'moderator "%s" deleted tag "%s"';
+      $log = sprintf($log, $moderator->getNickname(), $tag->getNormalizedTag());
+      sfContext::getInstance()->getLogger()->warning($log);
+    }
+    catch (PropelException $e)
+    {
+      $con->rollback();
+      throw $e;
+    }
+  }
-}
-

trunk/lib/model/UserPeer.php

@@ -45 +45 @@
-    return null;
-  }
+
+  public static function getModeratorCandidatesCount()
+  {
+    $c = new Criteria();
+    $c->add(self::WANT_TO_BE_MODERATOR, true);
+
+    return self::doCount($c);
+  }
+
+  public static function getModeratorCandidates()
+  {
+    $c = new Criteria();
+    $c->add(self::WANT_TO_BE_MODERATOR, true);
+    $c->addAscendingOrderByColumn(self::CREATED_AT);
+
+    return self::doSelect($c);
+  }
+
+  public static function getModerators()
+  {
+    $c = new Criteria();
+    $c->add(self::IS_MODERATOR, true);
+    $c->addAscendingOrderByColumn(self::CREATED_AT);
+
+    return self::doSelect($c);
+  }
+
+  public static function getAdministrators()
+  {
+    $c = new Criteria();
+    $c->add(self::IS_ADMINISTRATOR, true);
+    $c->addAscendingOrderByColumn(self::CREATED_AT);
+
+    return self::doSelect($c);
+  }
+
+  public static function getProblematicUsersCount()
+  {
+    $c = new Criteria();
+    $c->add(self::DELETIONS, 0, Criteria::GREATER_THAN);
+
+    return self::doCount($c);
+  }
+
+  public static function getProblematicUsers()
+  {
+    $c = new Criteria();
+    $c->add(self::DELETIONS, 0, Criteria::GREATER_THAN);
+    $c->addDescendingOrderByColumn(self::DELETIONS);
+
+    return self::doSelect($c);
+  }
-}
-

trunk/lib/model/map/AnswerMapBuilder.php

@@ -79 +79 @@
-        $tMap->addColumn('RELEVANCY_DOWN', 'RelevancyDown', 'int', CreoleTypes::INTEGER, false);
-
+        $tMap->addColumn('REPORTS', 'Reports', 'int', CreoleTypes::INTEGER, false);
+
-        $tMap->addColumn('CREATED_AT', 'CreatedAt', 'int', CreoleTypes::TIMESTAMP, false);
-                

trunk/lib/model/map/QuestionMapBuilder.php

@@ -79 +79 @@
-        $tMap->addColumn('INTERESTED_USERS', 'InterestedUsers', 'int', CreoleTypes::INTEGER, false);
-
+        $tMap->addColumn('REPORTS', 'Reports', 'int', CreoleTypes::INTEGER, false);
+
-        $tMap->addColumn('CREATED_AT', 'CreatedAt', 'int', CreoleTypes::TIMESTAMP, false);
-

trunk/lib/model/map/QuestionTagMapBuilder.php

@@ -65 +65 @@
-        $tMap->setUseIdGenerator(false);
-
-Key('QUESTION_ID', 'QuestionId', 'int', CreoleTypes::INTEGER, 'ask_question', 'ID', fals
+PrimaryKey('QUESTION_ID', 'QuestionId', 'int' , CreoleTypes::INTEGER, 'ask_question', 'ID', tru
-
-Key('USER_ID', 'UserId', 'int', CreoleTypes::INTEGER, 'ask_user', 'ID', fals
+PrimaryKey('USER_ID', 'UserId', 'int' , CreoleTypes::INTEGER, 'ask_user', 'ID', tru
-
-        $tMap->addColumn('CREATED_AT', 'CreatedAt', 'int', CreoleTypes::TIMESTAMP, false);
@@ -73 +73 @@
-        $tMap->addColumn('TAG', 'Tag', 'string', CreoleTypes::VARCHAR, false);
-
-Column('NORMALIZED_TAG', 'NormalizedTag', 'string', CreoleTypes::VARCHAR, false
+PrimaryKey('NORMALIZED_TAG', 'NormalizedTag', 'string', CreoleTypes::VARCHAR, true, 100
-                
-    } // doBuild()

trunk/lib/model/map/UserMapBuilder.php

@@ -81 +81 @@
-        $tMap->addColumn('HAS_PAYPAL', 'HasPaypal', 'boolean', CreoleTypes::BOOLEAN, false);
-
+        $tMap->addColumn('WANT_TO_BE_MODERATOR', 'WantToBeModerator', 'boolean', CreoleTypes::BOOLEAN, false);
+
+        $tMap->addColumn('IS_MODERATOR', 'IsModerator', 'boolean', CreoleTypes::BOOLEAN, false);
+
+        $tMap->addColumn('IS_ADMINISTRATOR', 'IsAdministrator', 'boolean', CreoleTypes::BOOLEAN, false);
+
+        $tMap->addColumn('DELETIONS', 'Deletions', 'int', CreoleTypes::INTEGER, false);
+
-        $tMap->addColumn('CREATED_AT', 'CreatedAt', 'int', CreoleTypes::TIMESTAMP, false);
-                

trunk/lib/model/om/BaseAnswer.php

@@ -79 +79 @@
-
-    /**
+     * The value for the reports field.
+     * @var int
+     */
+    protected $reports = 0;
+
+
+    /**
-     * The value for the created_at field.
-     * @var int
@@ -105 +112 @@
-     */
-    private $lastRelevancyCriteria = null;
+
+    /**
+     * Collection to store aggregation of collReportAnswers.
+     * @var array
+     */
+    protected $collReportAnswers;
+    
+    /**
+     * The criteria used to select the current contents of collReportAnswers.
+     * @var Criteria
+     */
+    private $lastReportAnswerCriteria = null;
-
-    /**
@@ -195 +214 @@
-
-        return $this->relevancy_down;
+    }
+
+    /**
+     * Get the [reports] column value.
+     * 
+     * @return int
+     */
+    public function getReports()
+    {
+
+        return $this->reports;
-    }
-
@@ -349 +379 @@
-
-    /**
+     * Set the value of [reports] column.
+     * 
+     * @param int $v new value
+     * @return void
+     */
+    public function setReports($v)
+    {
+
+        if ($this->reports !== $v || $v === 0) {
+            $this->reports = $v;
+            $this->modifiedColumns[] = AnswerPeer::REPORTS;
+        }
+
+    } // setReports()
+
+    /**
-     * Set the value of [created_at] column.
-     * 
@@ -403 +449 @@
-            $this->relevancy_down = $rs->getInt($startcol + 6);
-
-
+
+
+
-
-            $this->resetModified();
@@ -410 +458 @@
-
-            // FIXME - using NUM_COLUMNS may be clearer.
-8; // 8
+9; // 9
-
-        } catch (Exception $e) {
@@ -546 +594 @@
-            }
-
+            if ($this->collReportAnswers !== null) {
+                foreach($this->collReportAnswers as $referrerFK) {
+                    if (!$referrerFK->isDeleted()) {
+                        $affectedRows += $referrerFK->save($con);
+                    }
+                }
+            }
+
-            $this->alreadyInSave = false;
-        }
@@ -620 +676 @@
-                }
-
+                if ($this->collReportAnswers !== null) {
+                    foreach($this->collReportAnswers as $referrerFK) {
+                        if (($retval = $referrerFK->validate()) !== true) {
+                            $failureMap = array_merge($failureMap, $retval);
+                        }
+                    }
+                }
+
-
-            $this->alreadyInValidation = false;
@@ -675 +739 @@
-                break;
-            case 7:
+                return $this->getReports();
+                break;
+            case 8:
-                return $this->getCreatedAt();
-                break;
@@ -704 +771 @@
-            $keys[5] => $this->getRelevancyUp(),
-            $keys[6] => $this->getRelevancyDown(),
-
+
+
-        );
-        return $result;
@@ -759 +827 @@
-                break;
-            case 7:
+                $this->setReports($value);
+                break;
+            case 8:
-                $this->setCreatedAt($value);
-                break;
@@ -791 +862 @@
-        if (array_key_exists($keys[5], $arr)) $this->setRelevancyUp($arr[$keys[5]]);
-        if (array_key_exists($keys[6], $arr)) $this->setRelevancyDown($arr[$keys[6]]);
-
+
+
-    }
-
@@ -810 +882 @@
-        if ($this->isColumnModified(AnswerPeer::RELEVANCY_UP)) $criteria->add(AnswerPeer::RELEVANCY_UP, $this->relevancy_up);
-        if ($this->isColumnModified(AnswerPeer::RELEVANCY_DOWN)) $criteria->add(AnswerPeer::RELEVANCY_DOWN, $this->relevancy_down);
+        if ($this->isColumnModified(AnswerPeer::REPORTS)) $criteria->add(AnswerPeer::REPORTS, $this->reports);
-        if ($this->isColumnModified(AnswerPeer::CREATED_AT)) $criteria->add(AnswerPeer::CREATED_AT, $this->created_at);
-
@@ -876 +949 @@
-
-        $copyObj->setRelevancyDown($this->relevancy_down);
+
+        $copyObj->setReports($this->reports);
-
-        $copyObj->setCreatedAt($this->created_at);
@@ -887 +962 @@
-            foreach($this->getRelevancys() as $relObj) {
-                $copyObj->addRelevancy($relObj->copy($deepCopy));
+            }
+
+            foreach($this->getReportAnswers() as $relObj) {
+                $copyObj->addReportAnswer($relObj->copy($deepCopy));
-            }
-
@@ -1193 +1272 @@
-    }
-
+    /**
+     * Temporary storage of collReportAnswers to save a possible db hit in
+     * the event objects are add to the collection, but the
+     * complete collection is never requested.
+     * @return void
+     */
+    public function initReportAnswers()
+    {
+        if ($this->collReportAnswers === null) {
+            $this->collReportAnswers = array();
+        }
+    }
+
+    /**
+     * If this collection has already been initialized with
+     * an identical criteria, it returns the collection.
+     * Otherwise if this Answer has previously
+     * been saved, it will retrieve related ReportAnswers from storage.
+     * If this Answer is new, it will return
+     * an empty collection or the current collection, the criteria
+     * is ignored on a new object.
+     *
+     * @param Connection $con
+     * @param Criteria $criteria
+     * @throws PropelException
+     */
+    public function getReportAnswers($criteria = null, $con = null)
+    {
+        // include the Peer class
+        include_once 'model/om/BaseReportAnswerPeer.php';
+        if ($criteria === null) {
+            $criteria = new Criteria();
+        }
+        elseif ($criteria instanceof Criteria)
+        {
+            $criteria = clone $criteria;
+        }
+
+        if ($this->collReportAnswers === null) {
+            if ($this->isNew()) {
+               $this->collReportAnswers = array();
+            } else {
+
+                $criteria->add(ReportAnswerPeer::ANSWER_ID, $this->getId());
+
+                ReportAnswerPeer::addSelectColumns($criteria);
+                $this->collReportAnswers = ReportAnswerPeer::doSelect($criteria, $con);
+            }
+        } else {
+            // criteria has no effect for a new object
+            if (!$this->isNew()) {
+                // the following code is to determine if a new query is
+                // called for.  If the criteria is the same as the last
+                // one, just return the collection.
+
+
+                $criteria->add(ReportAnswerPeer::ANSWER_ID, $this->getId());
+
+                ReportAnswerPeer::addSelectColumns($criteria);
+                if (!isset($this->lastReportAnswerCriteria) || !$this->lastReportAnswerCriteria->equals($criteria)) {
+                    $this->collReportAnswers = ReportAnswerPeer::doSelect($criteria, $con);
+                }
+            }
+        }
+        $this->lastReportAnswerCriteria = $criteria;
+        return $this->collReportAnswers;
+    }
+
+    /**
+     * Returns the number of related ReportAnswers.
+     *
+     * @param Criteria $criteria
+     * @param Connection $con
+     * @throws PropelException
+     */
+    public function countReportAnswers($criteria = null, $con = null)
+    {
+        // include the Peer class
+        include_once 'model/om/BaseReportAnswerPeer.php';
+        if ($criteria === null) {
+            $criteria = new Criteria();
+        }
+        elseif ($criteria instanceof Criteria)
+        {
+            $criteria = clone $criteria;
+        }
+
+        $criteria->add(ReportAnswerPeer::ANSWER_ID, $this->getId());
+
+        return ReportAnswerPeer::doCount($criteria, $con);
+    }
+
+    /**
+     * Method called to associate a ReportAnswer object to this object
+     * through the ReportAnswer foreign key attribute
+     *
+     * @param ReportAnswer $l ReportAnswer
+     * @return void
+     * @throws PropelException
+     */
+    public function addReportAnswer(ReportAnswer $l)
+    {
+        $this->collReportAnswers[] = $l;
+        $l->setAnswer($this);
+    }
+
+
+    /**
+     * If this collection has already been initialized with
+     * an identical criteria, it returns the collection.
+     * Otherwise if this Answer is new, it will return
+     * an empty collection; or if this Answer has previously
+     * been saved, it will retrieve related ReportAnswers from storage.
+     *
+     * This method is protected by default in order to keep the public
+     * api reasonable.  You can provide public methods for those you
+     * actually need in Answer.
+     */
+    public function getReportAnswersJoinUser($criteria = null, $con = null)
+    {
+        // include the Peer class
+        include_once 'model/om/BaseReportAnswerPeer.php';
+        if ($criteria === null) {
+            $criteria = new Criteria();
+        }
+        elseif ($criteria instanceof Criteria)
+        {
+            $criteria = clone $criteria;
+        }
+
+        if ($this->collReportAnswers === null) {
+            if ($this->isNew()) {
+                $this->collReportAnswers = array();
+            } else {
+
+                $criteria->add(ReportAnswerPeer::ANSWER_ID, $this->getId());
+
+                $this->collReportAnswers = ReportAnswerPeer::doSelectJoinUser($criteria, $con);
+            }
+        } else {
+            // the following code is to determine if a new query is
+            // called for.  If the criteria is the same as the last
+            // one, just return the collection.
+
+            $criteria->add(ReportAnswerPeer::ANSWER_ID, $this->getId());
+
+            if (!isset($this->lastReportAnswerCriteria) || !$this->lastReportAnswerCriteria->equals($criteria)) {
+                $this->collReportAnswers = ReportAnswerPeer::doSelectJoinUser($criteria, $con);
+            }
+        }
+        $this->lastReportAnswerCriteria = $criteria;
+
+        return $this->collReportAnswers;
+    }
+
-} // BaseAnswer

trunk/lib/model/om/BaseAnswerPeer.php

@@ -25 +25 @@
-
-    /** The total number of columns. */
-8
+9
-
-    /** The number of lazy-loaded columns. */
@@ -52 +52 @@
-    const RELEVANCY_DOWN = 'ask_answer.RELEVANCY_DOWN';
-
+    /** the column name for the REPORTS field */
+    const REPORTS = 'ask_answer.REPORTS';
+
-    /** the column name for the CREATED_AT field */
-    const CREATED_AT = 'ask_answer.CREATED_AT';
@@ -66 +69 @@
-     */
-    private static $fieldNames = array (
-
-
-
-
+Reports', '
+REPORTS, AnswerPeer::
+reports', '
+8, 
-    );
-
@@ -79 +82 @@
-     */
-    private static $fieldKeys = array (
-CreatedAt' => 7
-CREATED_AT => 7
-created_at' => 7
-
+Reports' => 7, 'CreatedAt' => 8
+REPORTS => 7, AnswerPeer::CREATED_AT => 8
+reports' => 7, 'created_at' => 8
+8, 
-    );
-
@@ -196 +199 @@
-
-        $criteria->addSelectColumn(AnswerPeer::RELEVANCY_DOWN);
+
+        $criteria->addSelectColumn(AnswerPeer::REPORTS);
-
-        $criteria->addSelectColumn(AnswerPeer::CREATED_AT);

trunk/lib/model/om/BaseQuestion.php

@@ -79 +79 @@
-
-    /**
+     * The value for the reports field.
+     * @var int
+     */
+    protected $reports = 0;
+
+
+    /**
-     * The value for the created_at field.
-     * @var int
@@ -131 +138 @@
-     */
-    private $lastQuestionTagCriteria = null;
+
+    /**
+     * Collection to store aggregation of collReportQuestions.
+     * @var array
+     */
+    protected $collReportQuestions;
+    
+    /**
+     * The criteria used to select the current contents of collReportQuestions.
+     * @var Criteria
+     */
+    private $lastReportQuestionCriteria = null;
-
-    /**
@@ -221 +240 @@
-
-        return $this->interested_users;
+    }
+
+    /**
+     * Get the [reports] column value.
+     * 
+     * @return int
+     */
+    public function getReports()
+    {
+
+        return $this->reports;
-    }
-
@@ -402 +432 @@
-
-    /**
+     * Set the value of [reports] column.
+     * 
+     * @param int $v new value
+     * @return void
+     */
+    public function setReports($v)
+    {
+
+        if ($this->reports !== $v || $v === 0) {
+            $this->reports = $v;
+            $this->modifiedColumns[] = QuestionPeer::REPORTS;
+        }
+
+    } // setReports()
+
+    /**
-     * Set the value of [created_at] column.
-     * 
@@ -480 +526 @@
-            $this->interested_users = $rs->getInt($startcol + 6);
-
-
-
-
+
+
+
+
+
-
-            $this->resetModified();
@@ -489 +537 @@
-
-            // FIXME - using NUM_COLUMNS may be clearer.
-9; // 9
+10; // 10
-
-        } catch (Exception $e) {
@@ -635 +683 @@
-            }
-
+            if ($this->collReportQuestions !== null) {
+                foreach($this->collReportQuestions as $referrerFK) {
+                    if (!$referrerFK->isDeleted()) {
+                        $affectedRows += $referrerFK->save($con);
+                    }
+                }
+            }
+
-            $this->alreadyInSave = false;
-        }
@@ -719 +775 @@
-                }
-
+                if ($this->collReportQuestions !== null) {
+                    foreach($this->collReportQuestions as $referrerFK) {
+                        if (($retval = $referrerFK->validate()) !== true) {
+                            $failureMap = array_merge($failureMap, $retval);
+                        }
+                    }
+                }
+
-
-            $this->alreadyInValidation = false;
@@ -774 +838 @@
-                break;
-            case 7:
+                return $this->getReports();
+                break;
+            case 8:
-                return $this->getCreatedAt();
-                break;
-8
+9
-                return $this->getUpdatedAt();
-                break;
@@ -806 +873 @@
-            $keys[5] => $this->getHtmlBody(),
-            $keys[6] => $this->getInterestedUsers(),
-
-
+
+
+
-        );
-        return $result;
@@ -862 +930 @@
-                break;
-            case 7:
+                $this->setReports($value);
+                break;
+            case 8:
-                $this->setCreatedAt($value);
-                break;
-8
+9
-                $this->setUpdatedAt($value);
-                break;
@@ -897 +968 @@
-        if (array_key_exists($keys[5], $arr)) $this->setHtmlBody($arr[$keys[5]]);
-        if (array_key_exists($keys[6], $arr)) $this->setInterestedUsers($arr[$keys[6]]);
-
-
+
+
+
-    }
-
@@ -917 +989 @@
-        if ($this->isColumnModified(QuestionPeer::HTML_BODY)) $criteria->add(QuestionPeer::HTML_BODY, $this->html_body);
-        if ($this->isColumnModified(QuestionPeer::INTERESTED_USERS)) $criteria->add(QuestionPeer::INTERESTED_USERS, $this->interested_users);
+        if ($this->isColumnModified(QuestionPeer::REPORTS)) $criteria->add(QuestionPeer::REPORTS, $this->reports);
-        if ($this->isColumnModified(QuestionPeer::CREATED_AT)) $criteria->add(QuestionPeer::CREATED_AT, $this->created_at);
-        if ($this->isColumnModified(QuestionPeer::UPDATED_AT)) $criteria->add(QuestionPeer::UPDATED_AT, $this->updated_at);
@@ -984 +1057 @@
-
-        $copyObj->setInterestedUsers($this->interested_users);
+
+        $copyObj->setReports($this->reports);
-