root/trunk/lib/model/ApplicationPeer.php

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

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

  /**
   * Selects and returns apps and related members whenever then do not exist in
   * database anymore
   *
   * @param  Criteria $c
   * @param  mixed    $con
   * @return array
   */
  public static function doSelectLeftJoinsfGuardUser(Criteria $c, $con = null)
  {
    $c = clone $c;
    if ($c->getDbName() == Propel::getDefaultDB())
    {
      $c->setDbName(self::DATABASE_NAME);
    }
    ApplicationPeer::addSelectColumns($c);
    $startcol = (ApplicationPeer::NUM_COLUMNS - ApplicationPeer::NUM_LAZY_LOAD_COLUMNS) + 1;
    sfGuardUserPeer::addSelectColumns($c);
    $c->addJoin(ApplicationPeer::SUBMITTER_ID, sfGuardUserPeer::ID, Criteria::LEFT_JOIN);
    $rs = BasePeer::doSelect($c, $con);
    $results = array();
    while($rs->next())
    {
      $omClass = ApplicationPeer::getOMClass();
      $cls = Propel::import($omClass);
      $obj1 = new $cls();
      $obj1->hydrate($rs);
      $omClass = sfGuardUserPeer::getOMClass();
      $cls = Propel::import($omClass);
      $obj2 = new $cls();
      $obj2->hydrate($rs, $startcol);
      $newObject = true;
      foreach($results as $temp_obj1)
      {
        $temp_obj2 = $temp_obj1->getsfGuardUser();
        if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey())
        {
          $newObject = false;
          $temp_obj2->addApplication($obj1);
          break;
        }
      }
      if ($newObject)
      {
        $obj2->initApplications();
        $obj2->addApplication($obj1);
      }
      $results[] = $obj1;
    }
    return $results;
  }
  
  /**
   * Get recent applications
   *
   * @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->addDescendingOrderByColumn(self::CREATED_AT);
    $c->setLimit($number);
    return self::doSelect($c);
  }

  /**
   * Retrieves an Application by its slug
   *
   * @param string $slug
   * @param string $peer_method
   * @return Application
   */
  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);
    }
  }

  /**
   * Retrieves all application 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::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;
  }

  /**
   * Retrieves all countries and application counts
   *
   * @return array
   */
  public static function retrieveCountriesWithCount()
  {
    $c = new Criteria();
    $c->clearSelectColumns();
    $c->addSelectColumn(self::COUNTRY);
    $c->add(self::COUNTRY, null, Criteria::ISNOTNULL);
    $c->addAsColumn('nb', 'COUNT('.self::ID.')');
    $c->addGroupByColumn(self::COUNTRY);
    $c->addAscendingOrderByColumn(self::COUNTRY);
    $rs = self::doSelectRS($c);
    while ($rs->next())
    {
      if ($rs->getString(1) != '')
      {
        $countries[$rs->getString(1)] = $rs->getInt(2);
      }
    }
    arsort($countries);
    return $countries;
  }

}