root/trunk/lib/model/QuestionPeer.php

<?php

  // include base peer class
  require_once 'model/om/BaseQuestionPeer.php';
  
  // include object class
  include_once 'model/Question.php';


/**
 * Skeleton subclass for performing query and update operations on the 'ask_question' table.
 *
 * 
 *
 * You should add additional methods to this class to meet the
 * application requirements.  This class will only be generated as
 * long as it does not already exist in the output directory.
 *
 * @package model
 */    
class QuestionPeer extends BaseQuestionPeer
{
  public static function getQuestionFromTitle($title)
  {
    $c = new Criteria();
    $c->add(self::STRIPPED_TITLE, $title);

    $questions = self::doSelectJoinUser($c);

    return $questions ? $questions[0] : null;
  }

  public static function getHomepagePager($page)
  {
    $pager = new sfPager('Question', APP_PAGER_HOMEPAGE_MAX);
    $c = new Criteria();
    $c->addDescendingOrderByColumn(self::INTERESTED_USERS);
    $pager->setCriteria($c);
    $pager->setPage($page);
    $pager->setPeerMethod('doSelectJoinUser');
    $pager->init();

    return $pager;
  }

  public static function getRecentPager($page)
  {
    $pager = new sfPager('Question', APP_PAGER_HOMEPAGE_MAX);
    $c = new Criteria();
    $c->addDescendingOrderByColumn(self::CREATED_AT);
    $pager->setCriteria($c);
    $pager->setPage($page);
    $pager->setPeerMethod('doSelectJoinUser');
    $pager->init();

    return $pager;
  }
}

?>