/**
* 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;
}
/**
* Executes index action
*
* @param sfRequest $request A request object
*/
public function executeIndex(sfWebRequest $request)
{
$this->getContext()->getConfiguration()->loadHelpers(array('Url'));
$feed = new sfAtom1Feed();
$feed->setTitle('日本Symfonyユーザー会 コンテンツ更新情報');
$feed->setLink($this->getController()->genUrl('@homepage'));
$feed->setAuthorEmail('*****@*****.**');
$feed->setAuthorName('日本Symfonyユーザー会');
$feedImage = new sfFeedImage();
$feedImage->setFavicon(public_path('images/favicon.ico'));
$pages = Doctrine_Query::create()->from('Page p')->limit(10)->orderBy('p.last_updated desc')->execute();
foreach ($pages as $page) {
$item = new sfFeedItem();
$item->setTitle($page->getTitle());
$item->setLink(url_for_page($page->getPath()));
$item->setPubdate($page->getDateTimeObject('last_updated')->format('U'));
$item->setDescription(strip_tags($page->getContentRendered()));
$item->setContent($page->getContentRendered());
$feed->addItem($item);
}
$this->feed = $feed;
}
public function executeNoticiesCulturalsLastPosts()
{
$this->IDS = 1;
$feed = new sfAtom1Feed();
$feed->setTitle('NotÃcies Culturals de Girona');
$feed->setLink('http://www.casadecultura.org/noticiesculturals');
$feed->setAuthorEmail('*****@*****.**');
$feed->setAuthorName('Giroscopi || Casa de Cultura de Girona');
$feedImage = new sfFeedImage();
$feedImage->setFavicon('http://www.casadecultura.cat/images/blogs/Dissenys/noticies_culturals/blog_02.png');
$feed->setImage($feedImage);
$C = new Criteria();
$C = AppBlogsEntriesPeer::getCriteriaActiu($C, $this->IDS);
$C->add(AppBlogsEntriesPeer::PAGE_ID, 1);
$C->addDescendingOrderByColumn(AppBlogsEntriesPeer::ID);
$Q = AppBlogsEntriesPeer::doSelect($C);
$WEBROOTURL = OptionsPeer::getString('SF_WEBROOTURL', $this->IDS);
foreach ($Q as $post) {
$item = new sfFeedItem();
$item->setTitle($post->getTitle());
$item->setLink($WEBROOTURL . 'noticiesculturals?NOTICIA_ID=' . $post->getId());
$item->setAuthorName('Giroscopi');
$item->setAuthorEmail('*****@*****.**');
$IMG = $post->getImages();
if (!$IMG) {
$url = "";
} else {
$url = '<img width="100px" src="' . $WEBROOTURL . 'images/blogs/' . $IMG[0]->getUrl() . '">';
}
$url_web = $WEBROOTURL . 'noticiesculturals?NOTICIA_ID=' . $post->getId();
$item->setUniqueId($url_web);
$TEXT = "\t\r\n\t \t\t <table border=\"0\"><tr><td>{$url}</td><td>\t \t\t \r\n\t\t <h1>{$post->getTitle()}</h1><br />\r\n\t\t <h2>{$post->getSubtitle1()}</h2><br />\r\n\t\t <h3>{$post->getSubtitle2()}</h3><br />\r\n\t\t <a href=\"{$post->getUrl()}\">Web</a><br />\r\n\t\t <a href=\"{$url_web}\">NotÃcia original</a>\r\n\t\t </td></tr></table>\t \r\n\t ";
$item->setContent($TEXT);
$feed->addItem($item);
}
$this->feed = $feed;
$this->setLayout('blank');
$this->setTemplate('RSS');
}
/**
* Displays the latest changes to the registry
*
*/
public function getChangeFeed()
{
try {
$feed1 = sfFeedPeer::createFromWeb($this->getRequest()->getUriPrefix() . "/schemahistory/feed.atom");
$feed2 = sfFeedPeer::createFromWeb($this->getRequest()->getUriPrefix() . "/history/feed.atom");
if ($feed1 && $feed2) {
$image = new sfFeedImage();
$image->setFavicon($this->getRequest()->getUriPrefix() . "/favicon.ico");
$image->setFeed($this->getRequest()->getUriPrefix() . "/allhistoryfeeds.atom");
$image->setLink($image->getFeed());
$image->setTitle("Metadata Registry Change History");
$this->feed = sfFeedPeer::aggregate(array($feed1, $feed2), array('limit' => 100, 'format' => 'atom1', 'link' => $image->getLink(), 'title' => $image->getTitle(), 'feedUrl' => $image->getFeed(), 'image' => $image, 'description' => 'A statement-level list of all of the recent changes to the vocabularies and element sets maintained in the Metadata registry.'));
$this->changeFeedItems = $this->feed->getItems();
}
} catch (Exception $e) {
}
}
