Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function indexAction()
- {
- $year = $this->_getParam('year');
- $month = $this->_getParam('month');
- $day = $this->_getParam('day');
- $page = $this->_getParam('page');
- $query = Doctrine_Query::create()
- ->from('Writing');
- if ($year)
- $query->where('YEAR(date) = ?', $year);
- if ($month)
- $query->andWhere('MONTH(date) = ?', $month);
- if ($day)
- $query->andWhere('DAY(date) = ?', $day);
- $query->orderBy('id DESC');
- $pager = new Doctrine_Pager(
- $query,
- $page,
- 5
- );
- $writings = $pager->execute(array(), Doctrine_Core::HYDRATE_ARRAY);
- $this->view->writings = $writings;
- $pagerRange = new Doctrine_Pager_Range_Sliding(
- array(
- 'chunk' => 5 // Chunk length
- ),
- $pager
- );
- $pages = $pager_range->rangeAroundPage();
- $this->view->pages = $pages;
- }
- VIEW:
- <? foreach ($this->writings as $writing): ?>
- <div class="writing">
- <h2><?= $writing['name'] ?></h2>
- <p class='date']><?= $writing['date'] ?></p>
- <p><?= $writing['body'] ?></p>
- </div>
- <? endforeach; ?>
- <?= '['. implode('][', $this->pages) .']'; ?>
Add Comment
Please, Sign In to add comment