root/trunk/lib/model/Company.php

<?php
/**
 * Subclass for representing a row from the 'company' table.
 *
 * @package lib.model
 */
class Company extends BaseCompany
{

  /**
   * Returns company object string representation
   *
   * @return string
   */
  public function __toString()
  {
    return $this->getName();
  }

  /**
   * Retrieves related applications
   *
   * @param  Criteria  $c
   * @return array
   */
  public function getApplications(Criteria $c = null)
  {
    if (!$c instanceof Criteria)
    {
      $c = new Criteria;
    }
    $c->addJoin(ApplicationCompanyPeer::APPLICATION_ID, ApplicationPeer::ID);
    $c->addJoin(ApplicationCompanyPeer::COMPANY_ID, CompanyPeer::ID);
    $c->add(CompanyPeer::ID, $this->getId());
    return ApplicationPeer::doSelect($c);
  }

  /**
   * Retrieves related applications and return their names in a string
   *
   * @param  string  $separator
   * @return string
   */
  public function getApplicationsString(Criteria $c = null, $separator = ', ')
  {
    if (!$c instanceof Criteria)
    {
      $c = new Criteria;
    }
    $applications = array();
    foreach ($this->getApplications($c) as $application)
    {
     $applications[] = $application->getName();
    }
    return implode($separator, $applications);
  }

  /**
   * Returns company country name
   *
   * @return string
   */
  public function getCountryName()
  {
    if ($this->getCountry())
    {
      sfLoader::loadHelpers('I18N');
      return format_country($this->getCountry());
    }
  }

  /**
   * Retrieves related people for this company
   *
   * @param  Criteria  $c
   * @return array
   */
  public function getPeople(Criteria $c = null)
  {
    if (!$c instanceof Criteria)
    {
      $c = new Criteria;
    }
    $c->addJoin(CompanyPersonPeer::COMPANY_ID, CompanyPeer::ID);
    $c->addJoin(CompanyPersonPeer::USER_ID, sfGuardUserPeer::ID);
    $c->add(CompanyPeer::ID, $this->getId());
    $c->add(sfGuardUserPeer::IS_ACTIVE, true);
    return sfGuardUserPeer::doSelect($c);
  }

  /**
   * Retrieves related people and return their names in a string
   *
   * @param  Criteria  $c
   * @param  string    $separator
   * @return string
   */
  public function getPeopleString(Criteria $c = null, $separator = ', ')
  {
    if (!$c instanceof Criteria)
    {
      $c = new Criteria;
    }
    $people = array();
    foreach ($this->getPeople($c) as $person)
    {
     $people[] = $person->getDisplayName();
    }
    return implode($separator, $people);
  }

  /**
   * Returns full address in one line
   *
   * @return string
   */
  public function getFullAddress()
  {
    sfLoader::loadHelpers('I18N');
    $address= sprintf('%s %s %s %s, %s (%s)',
                      $this->getAddress(),
                      $this->getZip(),
                      $this->getCity(),
                      $this->getState(),
                      format_country($this->getCountry()),
                      $this->getName());
    return SymfoniansToolkit::onelinize($address);
  }

  /**
   * Checks if company has an address
   *
   * @return string
   */
  public function hasAddress()
  {
    return $this->getCountry() && $this->getCity();
  }

  /**
   * Checks if company is related to given person
   *
   * @param  mixed $user
   * @return boolean
   */
  public function hasMember($user)
  {
    if (is_null($user))
    {
      return false;
    }
    elseif ($user instanceof sfGuardUser)
    {
      $user = $user->getId();
    }
    elseif (!is_int($user))
    {
      throw new sfException('Impossible to check user from value '.
                            var_export($user, true));
    }
    $c = new Criteria();
    $c->add(CompanyPersonPeer::USER_ID, $user);
    return ($this->countCompanyPersons($c) > 0);
  }

  /**
   * Saves Company instance
   *
   * @param  Connection $con
   * @return int
   */
  public function save($con = null)
  {
    $new = $this->isNew();
    $modified = $this->isModified();
    $affectedRows = parent::save($con);

    // Create "company created" event object
    if ($modified)
    {
      $event = new Event();
      $event->setSourceModel('sfGuardUser');
      $event->setSourceSlug($this->getsfGuardUser()->getUsername());
      $event->setSourceName($this->getsfGuardUser()->getDisplayName());
      $event->setTargetModel('Company');
      $event->setTargetSlug($this->getSlug());
      $event->setTargetName($this->getName());
      if ($new)
      {
        $event->setType('addition');
      }
      else
      {
        $event->setType('update');
      }
      $event->save();
    }

    return $affectedRows;
  }

}

$columns_map = array('from' => CompanyPeer::NAME,
                     'to'   => CompanyPeer::SLUG);

sfPropelBehavior::add('Company',
                      array('sfPropelActAsSluggableBehavior' =>
                              array('columns'   => $columns_map,
                                    'separator' => '-',
                                    'permanent' => true),
                            'sfPropelActAsLocalizableBehavior' =>
                              array('location_getter' => 'getFullAddress')));

//sfLucenePropelBehavior::getInitializer()->setupModel('Company');