root/trunk/lib/model/BlogPostPeer.php

<?php
/**
 * Subclass for performing query and update operations on the 'blog_posts' table.
 *
 * @package lib.model
 */ 
class BlogPostPeer extends BaseBlogPostPeer
{
  
  /**
   * Get recent users
   *
   * @param int      $number  (default 10)
   * @param Criteria $c
   * @return array
   */
  public static function getRecent($number = 10, Criteria $c = null)
  {
    if (!$c instanceof Critreria)
    {
      $c = new Criteria;
    }
    
    $c->add(self::IS_PUBLISHED, true);
    $c->setLimit($number);
    return self::doSelectJoinsfGuardUserOrderedByCreateAtDesc($c);
  }
  
  /**
   * Retrieves BlogPost objects joinded with sfGuardUser (authors) ordered by
   * creation date desc 
   *
   * @param  Criteria $c
   * @return array
   */
  public static function doSelectJoinsfGuardUserOrderedByCreateAtDesc(Criteria $c = null)
  {
    if (!$c instanceof Criteria)
    {
      $c = new Criteria;
    }
    $c->addDescendingOrderByColumn(self::CREATED_AT);
    return self::doSelectJoinsfGuardUser($c);
  }
  
  /**
   * Retrieves a blog post by its slug
   *
   * @param  string $slug
   * @return BlogPost
   */
  public static function retrieveBySlug($slug)
  {
    $c = new Criteria;
    $c->add(self::SLUG, $slug);
    return self::doSelectOne($c);
  }
  
}