root/trunk/lib/model/PluginsfGuardUserPeer.php

<?php
/*
 * This file is part of the symfony package.
 * (c) 2004-2006 Fabien Potencier <fabien.potencier@symfony-project.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

/**
 *
 * @package    symfony
 * @subpackage plugin
 * @author     Fabien Potencier <fabien.potencier@symfony-project.com>
 * @version    SVN: $Id: sfGuardUserPeer.php 3810 2007-04-17 19:37:51Z davedash $
 */
class PluginsfGuardUserPeer extends BasesfGuardUserPeer
{

  /**
   * Users countries
   * @var array
   */
  protected static $countries = null;

  /**
   * 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_ACTIVE, true);
    $c->addDescendingOrderByColumn(self::CREATED_AT);
    $c->setLimit($number);
    return self::doSelect($c);
  }

  public static function retrieveByEmail($email)
  {
    $c = new Criteria;
    $c->add(self::EMAIL, $email);
    return self::doSelectOne($c);
  }

  public static function retrieveByUsername($username, $isActive = true, $peer_method = null)
  {
    $c = new Criteria();
    $c->add(self::USERNAME, $username);
    $c->add(self::IS_ACTIVE, $isActive);
    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);
    }
  }

  /**
   * Retrieves people countries
   *
   * @param  boolean $reload
   * @return array
   */
  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::IS_ACTIVE, true);
      $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;
  }

  /**
   * Retrieves people cities for a given country
   *
   * @param  string $country_code
   * @return array
   */
  public static function retrieveCountryCities($country_code)
  {
    $cities = array();
    $c = new Criteria();
    $c->clearSelectColumns();
    $c->addSelectColumn(self::CITY);
    $c->add(self::COUNTRY, $country_code);
    $c->add(self::IS_ACTIVE, true);
    $c->addGroupByColumn(self::CITY);
    $c->addAscendingOrderByColumn(self::CITY);
    $rs = self::doSelectRS($c);
    while ($rs->next())
    {
      if ($rs->getString(1) != '')
      {
        $cities[$rs->getString(1)] = $rs->getString(1);
      }
    }
    asort($cities);
    return $cities;
  }

}