public function executeIndex(sfWebRequest $request)
{
#security
#Public pages
$c = new Criteria();
$c->addAscendingOrderByColumn(EventPeer::ID);
$this->event_list = EventPeer::doSelect($c);
# for navigation menu
/*sfContext::getInstance()->getConfiguration()->loadHelpers('Partial');
slot('nav_menu', array('mission_coord', ''));*/
# filter
$this->processFilter($request);
$this->pager = EventPeer::getPager($this->max, $this->page, $this->event_name, $this->event_date, $this->event_time, $this->location);
$this->events = $this->pager->getResults();
$this->getUser()->addRecentItem('Events', 'events', 'events/index');
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param Connection $con the connection to use
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria();
$criteria->add(EventPeer::EVN_UID, $pks, Criteria::IN);
$objs = EventPeer::doSelect($criteria, $con);
}
return $objs;
}
private function getAllEvents()
{
$id = $this->getRequestParameter('id');
$c1 = new Criteria();
$c1->add(MissionPhotoPeer::ID, $id);
$eId = MissionPhotoPeer::doSelect($c1);
$c = new Criteria();
$events = EventPeer::doSelect($c);
$str = '';
$str .= '<th>Events</th><td><select name="event_id">';
foreach ($events as $event) {
if (!empty($eId)) {
if ($eId[0]->getEventId() == $event->getId()) {
$str .= '<option value="' . $event->getId() . '" selected="selected">' . $event->getEventName() . '</option>';
} else {
$str .= '<option value="' . $event->getId() . '">' . $event->getEventName() . '</option>';
}
} else {
$str .= '<option value="' . $event->getId() . '">' . $event->getEventName() . '</option>';
}
}
$str .= '</select></td>';
return $str;
}
public function getEvents($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseEventPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collEvents === null) {
if ($this->isNew()) {
$this->collEvents = array();
} else {
$criteria->add(EventPeer::CATEGORY_ID, $this->getId());
EventPeer::addSelectColumns($criteria);
$this->collEvents = EventPeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(EventPeer::CATEGORY_ID, $this->getId());
EventPeer::addSelectColumns($criteria);
if (!isset($this->lastEventCriteria) || !$this->lastEventCriteria->equals($criteria)) {
$this->collEvents = EventPeer::doSelect($criteria, $con);
}
}
}
$this->lastEventCriteria = $criteria;
return $this->collEvents;
}
public function executeList()
{
$this->events = EventPeer::doSelect(new Criteria());
}
