public function executeList()
{
$this->processSort();
$this->processFilters();
$this->etime = EtimePeer::retrieveByPk($this->getRequestParameter('etime_id'));
$this->forward404Unless($this->etime);
$this->form_fields = $this->getFormFields($this->etime->getEventId());
$this->pager = new sfPropelPager('Guest', 10);
$c = new Criteria();
$c->add(GuestPeer::ETIME_ID, $this->getRequestParameter('etime_id'));
$this->addSortCriteria($c);
$this->addFiltersCriteria($c);
$this->pager->setCriteria($c);
$this->pager->setPage($this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'sf_admin/guest')));
$this->pager->init();
if ($this->getRequestParameter('page')) {
$this->getUser()->setAttribute('page', $this->getRequestParameter('page'), 'sf_admin/guest');
}
}
/**
* Executes index action
*
*/
public function executeShow()
{
$feed = new sfAtom1Feed();
$feed->setTitle('Flinders University Events');
$feed->setLink('http://www.flinders.edu.au/');
$feed->setAuthorEmail('*****@*****.**');
$feed->setAuthorName('Web Development');
$feedImage = new sfFeedImage();
$feedImage->setFavicon('http://www.flinders.edu.au/favicon.ico');
$feed->setImage($feedImage);
$conn = Propel::getConnection();
$query = '
SELECT *
FROM %s
JOIN %s ON (%s = %s)
WHERE
%s = true
AND %s::date >= now()::date
ORDER BY %s ASC
';
$query = sprintf($query, EtimePeer::TABLE_NAME, EventPeer::TABLE_NAME, EtimePeer::EVENT_ID, EventPeer::ID, EventPeer::PUBLISHED, EtimePeer::START_DATE, EtimePeer::START_DATE);
$stmt = $conn->prepareStatement($query);
$resultset = $stmt->executeQuery(ResultSet::FETCHMODE_NUM);
$etimes = EtimePeer::populateObjects($resultset);
foreach ($etimes as $etime) {
$item = new sfFeedItem();
$item->setTitle($etime->getEvent()->getTitle() . ' - ' . $etime->getTitle());
$item->setLink('@show_outside_event?slug=' . $etime->getEvent()->getSlug());
$item->setAuthorName($etime->getEtimePeoples());
$item->setPubdate($etime->getStartDate('U'));
$item->setUniqueId($etime->getId());
if ($etime->getDescription()) {
$item->setDescription($etime->getDescription());
} else {
$item->setDescription($etime->getEvent()->getDescription());
}
$feed->addItem($item);
}
$this->feed = $feed;
}
public function getEtime($con = null)
{
if ($this->aEtime === null && $this->etime_id !== null) {
include_once 'lib/model/om/BaseEtimePeer.php';
$this->aEtime = EtimePeer::retrieveByPK($this->etime_id, $con);
}
return $this->aEtime;
}
public static function doSelectJoinAllExceptAudience(Criteria $c, $con = null)
{
$c = clone $c;
if ($c->getDbName() == Propel::getDefaultDB()) {
$c->setDbName(self::DATABASE_NAME);
}
EtimeAudiencePeer::addSelectColumns($c);
$startcol2 = EtimeAudiencePeer::NUM_COLUMNS - EtimeAudiencePeer::NUM_LAZY_LOAD_COLUMNS + 1;
EtimePeer::addSelectColumns($c);
$startcol3 = $startcol2 + EtimePeer::NUM_COLUMNS;
$c->addJoin(EtimeAudiencePeer::ETIME_ID, EtimePeer::ID);
$rs = BasePeer::doSelect($c, $con);
$results = array();
while ($rs->next()) {
$omClass = EtimeAudiencePeer::getOMClass();
$cls = Propel::import($omClass);
$obj1 = new $cls();
$obj1->hydrate($rs);
$omClass = EtimePeer::getOMClass();
$cls = Propel::import($omClass);
$obj2 = new $cls();
$obj2->hydrate($rs, $startcol2);
$newObject = true;
for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
$temp_obj1 = $results[$j];
$temp_obj2 = $temp_obj1->getEtime();
if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
$newObject = false;
$temp_obj2->addEtimeAudience($obj1);
break;
}
}
if ($newObject) {
$obj2->initEtimeAudiences();
$obj2->addEtimeAudience($obj1);
}
$results[] = $obj1;
}
return $results;
}
public function countEtimes($criteria = null, $distinct = false, $con = null)
{
include_once 'lib/model/om/BaseEtimePeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
$criteria->add(EtimePeer::EVENT_ID, $this->getId());
return EtimePeer::doCount($criteria, $distinct, $con);
}
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(EtimePeer::ID, $pks, Criteria::IN);
$objs = EtimePeer::doSelect($criteria, $con);
}
return $objs;
}
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = EtimePeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setEventId($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setTitle($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setStartDate($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setEndDate($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setAllDay($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setLocation($arr[$keys[6]]);
}
if (array_key_exists($keys[7], $arr)) {
$this->setDescription($arr[$keys[7]]);
}
if (array_key_exists($keys[8], $arr)) {
$this->setNotes($arr[$keys[8]]);
}
if (array_key_exists($keys[9], $arr)) {
$this->setCapacity($arr[$keys[9]]);
}
if (array_key_exists($keys[10], $arr)) {
$this->setAdditionalGuests($arr[$keys[10]]);
}
if (array_key_exists($keys[11], $arr)) {
$this->setHasFee($arr[$keys[11]]);
}
if (array_key_exists($keys[12], $arr)) {
$this->setAudioVisualSupport($arr[$keys[12]]);
}
if (array_key_exists($keys[13], $arr)) {
$this->setUpdatedAt($arr[$keys[13]]);
}
}
protected function getEtimeOrCreate($id = 'id')
{
if (!$this->getRequestParameter($id)) {
$etime = new Etime();
} else {
$etime = EtimePeer::retrieveByPk($this->getRequestParameter($id));
$this->forward404Unless($etime);
}
return $etime;
}
