Guest User

Untitled

a guest
Nov 25th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. public function indexAction()
  2. {
  3. $year = $this->_getParam('year');
  4. $month = $this->_getParam('month');
  5. $day = $this->_getParam('day');
  6. $page = $this->_getParam('page');
  7.  
  8. $query = Doctrine_Query::create()
  9. ->from('Writing');
  10. if ($year)
  11. $query->where('YEAR(date) = ?', $year);
  12. if ($month)
  13. $query->andWhere('MONTH(date) = ?', $month);
  14. if ($day)
  15. $query->andWhere('DAY(date) = ?', $day);
  16. $query->orderBy('id DESC');
  17.  
  18. $pager = new Doctrine_Pager(
  19. $query,
  20. $page,
  21. 5
  22. );
  23.  
  24. $writings = $pager->execute(array(), Doctrine_Core::HYDRATE_ARRAY);
  25. $this->view->writings = $writings;
  26.  
  27. $pagerRange = new Doctrine_Pager_Range_Sliding(
  28. array(
  29. 'chunk' => 5 // Chunk length
  30. ),
  31. $pager
  32. );
  33. $pages = $pager_range->rangeAroundPage();
  34. $this->view->pages = $pages;
  35.  
  36. }
  37.  
  38. VIEW:
  39.  
  40. <? foreach ($this->writings as $writing): ?>
  41. <div class="writing">
  42. <h2><?= $writing['name'] ?></h2>
  43. <p class='date']><?= $writing['date'] ?></p>
  44. <p><?= $writing['body'] ?></p>
  45. </div>
  46. <? endforeach; ?>
  47. <?= '['. implode('][', $this->pages) .']'; ?>
Add Comment
Please, Sign In to add comment