class companyActions extends sfActions { /** * Executes index action * */ public function executeIndex() { $c = new Criteria(); $c = $c->add(RequestCompanyPeer::CUSTOMER_ID,$this->getUser()->getAttribute('userID')); $c = $c->addJoin(RequestCompanyPeer::INDEX_ID,ShabFirmPeer::FIRMID,Criteria::LEFT_JOIN); $c->addGroupByColumn(ShabFirmPeer::FIRMID); $this->companys = ShabFirmPeer::doSelect($c); } }