public function executeToggleComment()
{
$post = sfSimpleBlogPostPeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($post);
$post->setAllowComments(!$post->getAllowComments());
$post->save();
if ($referer = $this->getRequest()->getReferer()) {
$this->redirect($referer);
} else {
$this->redirect('sfSimpleBlogPostAdmin/list');
}
}
public static function retrieveByStrippedTitleAndDate($text, $date, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$criteria = new Criteria(sfSimpleBlogPostPeer::DATABASE_NAME);
$criteria->add(sfSimpleBlogPostPeer::STRIPPED_TITLE, $text);
if (sfConfig::get('app_sfSimpleBlog_use_date_in_url', false)) {
$criteria->add(sfSimpleBlogPostPeer::PUBLISHED_AT, $date);
}
$v = sfSimpleBlogPostPeer::doSelect($criteria, $con);
return !empty($v) > 0 ? $v[0] : null;
}
public function getTagsAsString()
{
$c = new Criteria();
$c->clearSelectColumns()->clearOrderByColumns();
$c->addSelectColumn(sfSimpleBlogTagPeer::TAG);
$c->add(sfSimpleBlogTagPeer::SF_BLOG_POST_ID, $this->getId());
$rs = sfSimpleBlogPostPeer::doSelectRS($c);
$tags = array();
while ($rs->next()) {
$tags[] = $rs->getString(1);
}
return implode($tags, ',');
}
public function executeIndex()
{
$this->getResponse()->setTitle('Monitora i tuoi rappresentanti - ' . sfConfig::get('app_main_title'));
$this->getResponse()->addMeta('description', 'Cosa fanno i tuoi rappresentanti? Tutte le attività parlamentari aggiornate quotidianamente.', true);
deppFiltersAndSortVariablesManager::resetVars($this->getUser(), 'module', 'module', array('acts_filter', 'sf_admin/opp_atto/sort', 'votes_filter', 'sf_admin/opp_votazione/sort', 'pol_camera_filter', 'pol_senato_filter', 'sf_admin/opp_carica/sort', 'argomento/atti_filter', 'argomento_leggi/sort', 'argomento_nonleg/sort', 'monitoring_filter'));
// ultime attivita' della community
$this->latest_activities = CommunityNewsPeer::getLatestActivities(4);
// ultime news dal parlamento
$c = oppNewsPeer::getHomeNewsCriteria();
$c->addDescendingOrderByColumn(NewsPeer::DATE);
$itemsperpage = 4;
$pager = new deppNewsPager('News', $itemsperpage);
$pager->setCriteria($c);
$pager->setPage($this->getRequestParameter('page', 1));
$pager->init();
$this->pager = $pager;
// atti in evidenza
$this->lanci = array();
$c = new Criteria();
$c->add(sfLaunchingPeer::LAUNCH_NAMESPACE, 'home');
$c->add(sfLaunchingPeer::OBJECT_MODEL, 'OppAtto');
$c->setLimit(8);
$c->addDescendingOrderByColumn(sfLaunchingPeer::PRIORITY);
$evidences = sfLaunchingPeer::doSelect($c);
foreach ($evidences as $evidence) {
$atto = OppAttoPeer::retrieveByPk($evidence->getObjectId());
$this->lanci[] = $atto->getId();
}
// post del blog
$this->post_pager = sfSimpleBlogPostPeer::getTaggedPager('in evidenza', sfConfig::get('app_sfSimpleBlog_post_max_per_page', 10), $this->getRequestParameter('page', 1));
// estrae le circoscrizioni, compreso il valore 0
$this->senato_constituencies = OppCaricaPeer::getAllConstituencies('senato', false);
$this->camera_constituencies = OppCaricaPeer::getAllConstituencies('camera', false);
}
public function handleErrorAddComment()
{
if ($this->getRequest()->isXmlHttpRequest()) {
$this->post = sfSimpleBlogPostPeer::retrieveByStrippedTitleAndDate($this->getRequestParameter('stripped_title'), $this->getRequestParameter('date'));
$this->forward404Unless($this->post);
$this->comments = $this->post->getComments();
$this->getResponse()->setContentType('text/html; charset=utf-8');
return 'Ajax';
} else {
$this->forward('sfSimpleBlog', 'show');
}
}
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(sfSimpleBlogPostPeer::ID, $pks, Criteria::IN);
$objs = sfSimpleBlogPostPeer::doSelect($criteria, $con);
}
return $objs;
}
public static function doSelectJoinAll(Criteria $c, $con = null)
{
$c = clone $c;
if ($c->getDbName() == Propel::getDefaultDB()) {
$c->setDbName(self::DATABASE_NAME);
}
sfSimpleBlogTagPeer::addSelectColumns($c);
$startcol2 = sfSimpleBlogTagPeer::NUM_COLUMNS - sfSimpleBlogTagPeer::NUM_LAZY_LOAD_COLUMNS + 1;
sfSimpleBlogPostPeer::addSelectColumns($c);
$startcol3 = $startcol2 + sfSimpleBlogPostPeer::NUM_COLUMNS;
$c->addJoin(sfSimpleBlogTagPeer::SF_BLOG_POST_ID, sfSimpleBlogPostPeer::ID);
$rs = BasePeer::doSelect($c, $con);
$results = array();
while ($rs->next()) {
$omClass = sfSimpleBlogTagPeer::getOMClass();
$cls = Propel::import($omClass);
$obj1 = new $cls();
$obj1->hydrate($rs);
$omClass = sfSimpleBlogPostPeer::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->getsfSimpleBlogPost();
if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
$newObject = false;
$temp_obj2->addsfSimpleBlogTag($obj1);
break;
}
}
if ($newObject) {
$obj2->initsfSimpleBlogTags();
$obj2->addsfSimpleBlogTag($obj1);
}
$results[] = $obj1;
}
return $results;
}
public function executeCommentsForPostFeed()
{
sfLoader::loadHelpers(array('I18N'));
$post = sfSimpleBlogPostPeer::retrieveByStrippedTitleAndDate($this->getRequestParameter('stripped_title'), $this->getDateFromRequest());
$this->forward404Unless($post);
$comments = sfSimpleBlogCommentPeer::getForPost($post, $this->getRequestParameter('nb', sfConfig::get('app_sfSimpleBlog_feed_count', 5)));
$this->feed = sfFeedPeer::createFromObjects($comments, array('format' => $this->getRequestParameter('format', 'atom1'), 'title' => __('Comments on post "%1%" from %2%', array('%1%' => $post->getTitle(), '%2%' => sfConfig::get('app_sfSimpleBlog_title', ''))), 'link' => $this->getController()->genUrl('sfSimpleBlog/show?stripped_title=' . $post->getStrippedTitle()), 'authorName' => sfConfig::get('app_sfSimpleBlog_author', ''), 'methods' => array('title' => 'getPostTitle', 'authorEmail' => '')));
$this->setTemplate('feed');
}
public function executeRecentPosts()
{
$this->post_pager = sfSimpleBlogPostPeer::getRecentPager(sfConfig::get('app_sfSimpleBlog_post_recent', 5), 1);
}
