root/trunk/lib/model/CompanyPeer.php

<?php
/**
 * Subclass for performing query and update operations on the 'company' table.
 *
 * @package lib.model
 */ 
class CompanyPeer extends BaseCompanyPeer
{

  protected static $countries = null;
  
  /**
   * Get recent companies
   *
   * @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_ACTIVE, true);
    $c->addDescendingOrderByColumn(self::CREATED_AT);
    $c->setLimit($number);
    return self::doSelect($c);
  }
  
  public static function retrieveBySlug($slug, $peer_method = null)
  {
    $c = new Criteria();
    $c->add(self::SLUG, $slug);
    if ($peer_method)
    {
      if (!is_callable(sprintf('%s::%s', __CLASS__, $peer_method)))
      {
        throw new PropelException(sprintf('Peer method "%s" does not exist',
                                          $peer_method));
      }
      $c->setLimit(1);
      $objects = call_user_func(array(__CLASS__, $peer_method), $c);
      if (!is_null($objects) && isset($objects[0]))
      {
        return $objects[0];
      }
      else 
      {
        return null;
      }
    }
    else
    {
      return self::doSelectOne($c);
    }
  }

  public static function retrieveCountries($reload = false)
  {
    if (is_null(self::$countries) or $reload)
    {
      sfLoader::loadHelpers('I18N');
      $countries = array();
      $c = new Criteria();
      $c->clearSelectColumns();
      $c->addSelectColumn(self::COUNTRY);
      $c->add(self::COUNTRY, null, Criteria::ISNOTNULL);
      $c->addGroupByColumn(self::COUNTRY);
      $c->addAscendingOrderByColumn(self::COUNTRY);
      $rs = self::doSelectRS($c);
      while ($rs->next())
      {
        if ($rs->getString(1) != '')
        {
          $countries[$rs->getString(1)] = format_country($rs->getString(1));
        }
      }
      asort($countries);
      self::$countries = $countries;
    }
    return self::$countries;
  }

}