public static function getPager($max = 10, $page = 1, $date_req = null, $pass_name = null, $req_name = null, $pass_lname = null, $req_lname = null) { $c = new Criteria(); $c->addJoin(self::PASSENGER_ID, PassengerPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(self::REQUESTER_ID, RequesterPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(PassengerPeer::PERSON_ID, PersonPeer::alias('c1', PersonPeer::ID), Criteria::LEFT_JOIN); $c->addJoin(RequesterPeer::PERSON_ID, PersonPeer::alias('c2', PersonPeer::ID), Criteria::LEFT_JOIN); $c->addAlias('c1', PersonPeer::TABLE_NAME); $c->addAlias('c2', PersonPeer::TABLE_NAME); if ($date_req) { $c->add(self::DATE_REQUESTED, '%' . date('Y-m-d', strtotime($date_req)) . '%', Criteria::LIKE); } if ($pass_name) { $c->add(PersonPeer::alias("c1", PersonPeer::FIRST_NAME), $pass_name . '%', Criteria::LIKE); } if ($req_name) { $c->add(PersonPeer::alias("c2", PersonPeer::FIRST_NAME), $req_name . '%', Criteria::LIKE); } if ($pass_lname) { $c->add(PersonPeer::alias("c1", PersonPeer::LAST_NAME), $pass_lname . '%', Criteria::LIKE); } if ($req_lname) { $c->add(PersonPeer::alias("c2", PersonPeer::LAST_NAME), $req_lname . '%', Criteria::LIKE); } $c->addAscendingOrderByColumn(self::DATE_REQUESTED); $pager = new sfPropelPager('Itinerary', $max); $pager->setCriteria($c); $pager->setPage($page); $pager->init(); return $pager; }
public static function getPager($max = 10, $page = 1, $miss_ext_id = null, $miss_type = null, $miss_date1 = null, $miss_date2 = null, $pass_fname = null, $pass_lname = null, $mreq_fname = null, $mreq_lname = null) { $c = new Criteria(); $c->addJoin(self::MISSION_TYPE_ID, MissionTypePeer::ID, Criteria::LEFT_JOIN); $c->addJoin(self::REQUESTER_ID, RequesterPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(self::PASSENGER_ID, PassengerPeer::ID, Criteria::LEFT_JOIN); //person $c->addJoin(PassengerPeer::PERSON_ID, PersonPeer::alias('p1', PersonPeer::ID), Criteria::LEFT_JOIN); $c->addJoin(RequesterPeer::PERSON_ID, PersonPeer::alias('p2', PersonPeer::ID), Criteria::LEFT_JOIN); $c->addAlias('p1', PersonPeer::TABLE_NAME); $c->addAlias('p2', PersonPeer::TABLE_NAME); if ($miss_ext_id) { $c->add(self::EXTERNAL_ID, $miss_ext_id); } if ($miss_type) { $c->add(MissionTypePeer::NAME, $miss_type . '%', Criteria::LIKE); } if ($miss_date1 != null && $miss_date2 != null) { $criterion = $c->getNewCriterion(self::MISSION_DATE, date('Y-m-d', strtotime($miss_date1)) . ' 00:00:00', Criteria::GREATER_EQUAL); $criterion->addAnd($c->getNewCriterion(self::MISSION_DATE, date('Y-m-d', strtotime($miss_date2)) . ' 00:00:00', Criteria::LESS_EQUAL)); $c->add($criterion); } elseif ($miss_date1) { $c->add(self::MISSION_DATE, date('Y-m-d', strtotime($miss_date1)) . ' 00:00:00', Criteria::GREATER_EQUAL); } elseif ($miss_date2) { $c->add(self::MISSION_DATE, date('Y-m-d', strtotime($miss_date2)) . ' 00:00:00', Criteria::LESS_EQUAL); } if ($pass_fname) { $c->add(PersonPeer::alias("p1", PersonPeer::FIRST_NAME), $pass_fname . '%', Criteria::LIKE); } if ($pass_lname) { $c->add(PersonPeer::alias("p1", PersonPeer::LAST_NAME), $pass_lname . '%', Criteria::LIKE); } if ($mreq_fname) { $c->add(PersonPeer::alias("p2", PersonPeer::FIRST_NAME), $mreq_fname . '%', Criteria::LIKE); } if ($mreq_lname) { $c->add(PersonPeer::alias("p2", PersonPeer::LAST_NAME), $mreq_lname . '%', Criteria::LIKE); } // $sort_date = time(); // $mis = self::MISSION_DATE; // echo $mis;die; //$c->add self::addSelectColumns($c); $c->addAsColumn("sort_order", "ABS(DATEDIFF(COALESCE(" . self::MISSION_DATE . ", \"1970-01-01\"), NOW()))"); $c->addAscendingOrderByColumn('sort_order'); $pager = new sfPropelPager('Mission', $max); $pager->setCriteria($c); $pager->setPage($page); $pager->init(); return $pager; }
public static function getMissingWaiversPager($max = 10, $page = 1, $miss_date1 = null, $miss_date2 = null, $pass_name = null, $pilot_name = null, $wing = null) { $c = new Criteria(); $c->addJoin(self::MISSION_ID, MissionPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(MissionPeer::PASSENGER_ID, PassengerPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(self::PILOT_ID, PilotPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(PilotPeer::MEMBER_ID, MemberPeer::alias('m2', MemberPeer::ID), Criteria::LEFT_JOIN); //person $c->addJoin(PassengerPeer::PERSON_ID, PersonPeer::alias('p1', PersonPeer::ID), Criteria::LEFT_JOIN); $c->addJoin(MemberPeer::alias('m2', MemberPeer::PERSON_ID), PersonPeer::alias('p2', PersonPeer::ID), Criteria::LEFT_JOIN); $c->addAlias('p1', PersonPeer::TABLE_NAME); $c->addAlias('p2', PersonPeer::TABLE_NAME); $c->addAlias('m1', MemberPeer::TABLE_NAME); $c->addAlias('m2', MemberPeer::TABLE_NAME); //member $c->addJoin(PersonPeer::alias('p1', PersonPeer::ID), MemberPeer::alias('m1', MemberPeer::PERSON_ID), Criteria::LEFT_JOIN); if (!empty($miss_date1) && !empty($miss_date2)) { $miss_date1 = date('Y-m-d', strtotime($miss_date1)) . ' 00:00:00'; $miss_date2 = date('Y-m-d', strtotime($miss_date2)) . ' 00:00:00'; $criterion = $c->getNewCriterion(MissionPeer::MISSION_DATE, $miss_date1, Criteria::GREATER_EQUAL); $criterion->addAnd($c->getNewCriterion(MissionPeer::MISSION_DATE, $miss_date2, Criteria::LESS_EQUAL)); $c->add($criterion); } elseif ($miss_date1) { $miss_date1 = date('Y-m-d', strtotime($miss_date1)) . ' 00:00:00'; $c->add(MissionPeer::MISSION_DATE, $miss_date1, Criteria::GREATER_EQUAL); } elseif ($miss_date2) { $miss_date2 = date('Y-m-d', strtotime($miss_date2)) . ' 00:00:00'; $c->add(MissionPeer::MISSION_DATE, $miss_date2, Criteria::GREATER_EQUAL); } if ($pass_name) { $criterion = $c->getNewCriterion(PersonPeer::alias("p1", PersonPeer::FIRST_NAME), $pass_name . '%', Criteria::LIKE); $criterion->addOr($c->getNewCriterion(PersonPeer::alias("p1", PersonPeer::LAST_NAME), $pass_name . '%', Criteria::LIKE)); $c->add($criterion); } if ($pilot_name) { $criterion = $c->getNewCriterion(PersonPeer::alias("p2", PersonPeer::FIRST_NAME), $pilot_name . '%', Criteria::LIKE); $criterion->addOr($c->getNewCriterion(PersonPeer::alias("p2", PersonPeer::LAST_NAME), $pilot_name . '%', Criteria::LIKE)); $c->add($criterion); } if ($wing) { $c->add(MemberPeer::alias('m1', MemberPeer::WING_ID), $wing); } $c->add(self::WAIVER_RECEIVED, null, Criteria::ISNULL); $c->addAscendingOrderByColumn(self::ID); // return self::doSelect($c); $pager = new sfPropelPager('MissionLeg', $max); $pager->setCriteria($c); $pager->setPage($page); $pager->init(); return $pager; }