public static function getForSelectParent() { $c = new Criteria(); $passengers = PassengerPeer::doSelectJoinPerson($c); $arr = array(); $arr[0] = '-- select --'; foreach ($passengers as $passenger) { $arr[$passenger->getId()] = $passenger->getPerson()->getName(); } return $arr; }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this PassengerIllnessCategory is new, it will return * an empty collection; or if this PassengerIllnessCategory has previously * been saved, it will retrieve related Passengers from storage. * * This method is protected by default in order to keep the public * api reasonable. You can provide public methods for those you * actually need in PassengerIllnessCategory. */ public function getPassengersJoinPerson($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { if ($criteria === null) { $criteria = new Criteria(PassengerIllnessCategoryPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collPassengers === null) { if ($this->isNew()) { $this->collPassengers = array(); } else { $criteria->add(PassengerPeer::PASSENGER_ILLNESS_CATEGORY_ID, $this->id); $this->collPassengers = PassengerPeer::doSelectJoinPerson($criteria, $con, $join_behavior); } } else { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return the collection. $criteria->add(PassengerPeer::PASSENGER_ILLNESS_CATEGORY_ID, $this->id); if (!isset($this->lastPassengerCriteria) || !$this->lastPassengerCriteria->equals($criteria)) { $this->collPassengers = PassengerPeer::doSelectJoinPerson($criteria, $con, $join_behavior); } } $this->lastPassengerCriteria = $criteria; return $this->collPassengers; }
public function executeAjaxFilterPassenger(sfWebRequest $request) { if ($request->hasParameter('firstname')) { $fname = trim($request->getParameter('firstname')); } elseif ($request->hasParameter('lastname')) { $lname = trim($request->getParameter('lastname')); } $c = new Criteria(); $c->addJoin(PassengerPeer::PERSON_ID, PersonPeer::ID, Criteria::LEFT_JOIN); if (isset($fname)) { $c->add(PersonPeer::FIRST_NAME, "{$fname}%", Criteria::LIKE); } if (isset($lname)) { $c->add(PersonPeer::LAST_NAME, "{$lname}%", Criteria::LIKE); } $c->setLimit(10); $this->passengers = PassengerPeer::doSelectJoinPerson($c); }