root/trunk/lib/model/CompanyPersonPeer.php

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

  public static function retrieveByCompanyIdAndUserId($company_id, $user_id, Criteria $c = null)
  {
    if (!$c instanceof Criteria)
    {
      $c = new Criteria();
    }
    $c->add(self::COMPANY_ID, $company_id);
    $c->add(self::USER_ID, $user_id);
    return self::doSelectOne($c);
  }
  
  public static function retrieveForUser($user, Criteria $c = null)
  {
    if (!$c instanceof Criteria)
    {
      $c = new Criteria();
    }
    $c->addJoin(self::COMPANY_ID, CompanyPeer::ID);
    $c->add(self::USER_ID, $user->getId());
    $c->addDescendingOrderByColumn(self::STARTED_AT);
    return self::doSelectJoinAll($c);
  }
  
}