public function executePage(sfWebRequest $request)
{
$this->forward404Unless($this->page = sfSimpleBlogPageQuery::create()->filterByStrippedTitle($request->getParameter('page_title'))->findOne());
}
public function executeMainNavigation()
{
$this->pages = sfSimpleBlogPageQuery::create()->filterByIsPublished(true)->find();
}
<div id="sf_admin_container" class="clearfix">
<div class="dashboard_box">
<div class="box">
<h2><?php echo __('At a Glance', null, 'sf_simple_blog') ?></h2>
<table>
<tbody>
<tr>
<td><h3><?php echo __('Contents', null, 'sf_simple_blog') ?></h3></td>
<td><h3><?php echo __('Comments', null, 'sf_simple_blog') ?></h3></td>
</tr>
<tr>
<td><?php echo sfSimpleBlogPostQuery::create()->count() ?> Posts</td>
<td><?php echo $nbComments = sfNestedCommentQuery::create()->count() ?> Comments</td>
</tr>
<tr>
<td><?php echo sfSimpleBlogPageQuery::create()->count() ?> Pages</td>
<td><?php echo $nbApprovedComments = sfNestedCommentQuery::create()->approved()->count() ?> Approved</td>
</tr>
<tr>
<td><?php echo sfSimpleBlogCategoryQuery::create()->count() ?> Categories</td>
<td><?php echo $nbComments - $nbApprovedComments ?> Pending</td>
</tr>
<tr>
<td><?php echo TagQuery::create()->count() ?> Tags</td>
</tr>
</tbody>
</table>
</div>
<div class="box">
<h2><?php echo __('Recent Comments', null, 'sf_simple_blog') ?></h2>
<table>
<?php $pages = sfSimpleBlogPageQuery::create()->published()->find() ?>
<div id="globalnav">
<div class="menu">
<ul>
<li>
<a href="<?php echo url_for('@homepage') ?>" title="<?php echo __('Home', '', 'twentyten') ?>"><?php echo __('Home', '', 'twentyten') ?></a>
</li>
<?php foreach ($pages as $page): ?>
<li>
<a href="<?php echo url_for('@sf_simple_blog_show_page?page_title='.$page->getStrippedTitle()) ?>" title="<?php echo $page->getName() ?>"><?php echo $page->getName() ?></a>
</li>
<?php endforeach; ?>
</ul>
</div><!-- #menu -->
</div><!-- #globalnav -->