public function newsAction(Request $request) { $news = $this->get('doctrine')->getRepository('AcmeInfoBundle:News')->findAll(); $order_by = ''; //get Entity manager instance $em = $this->get('doctrine.orm.entity_manager'); //get repository for class 'Language' : LanguageRepository.php $repository = $em->getRepository('Acme\\InfoBundle\\Entity\\News'); //get count of languages for using with Paginator class //Using custom made database query function in LanguageRepository class $languagesCount = $repository->getIdCount(); //When creating new paginator object it takes care for pages and items //organization based on numbers of items from database and limit variable in $_GET $paginator = new News($languagesCount); //get returned HTML string from Paginator to render paginator HTML //elements in the template $strPaginator = $paginator->RenderPaginator(); //If we have POST variable defined, than it is defined order of items //from inside form (clicking on sorting column for example) $sort_direction = "asc"; $news = $this->get('doctrine')->getRepository('AcmeInfoBundle:News')->findAll(); $page = $languagesCount / 3; $news = $repository->getProductListWithPagination($sort_direction, $paginator->getOffset(), $paginator->getLimit()); $newsletter = new \Acme\HomeBundle\Entity\Newsletter(); $newsletter->setEmail(''); $form = $this->createFormBuilder($newsletter)->add('email')->getForm(); $form->handleRequest($request); $validator = $this->get('validator'); $errors = $validator->validate($newsletter); if (count($errors) > 0) { return $this->render('AcmeHomeBundle:Default:news.html.twig', array('news' => $news, 'sort_dir' => $sort_direction, 'paginator' => $strPaginator, 'count' => $languagesCount, 'page' => $page, 'form' => $form->createView())); } else { if ($request->getMethod() == 'POST') { $a = $request->request->get('form'); $add = Newsletter::addNewsletter($a['email']); return $this->render('AcmeHomeBundle:Default:news.html.twig', array('news' => $news, 'sort_dir' => $sort_direction, 'paginator' => $strPaginator, 'count' => $languagesCount, 'page' => $page, 'form' => $form->createView())); } } return $this->render('AcmeHomeBundle:Default:news.html.twig', array('news' => $news, 'sort_dir' => $sort_direction, 'paginator' => $strPaginator, 'count' => $languagesCount, 'page' => $page, 'form' => $form->createView())); }
public function newsAction(Request $request) { $news = $this->get('doctrine')->getRepository('AcmeInfoBundle:News')->findAll(); $order_by = ''; //get Entity manager instance $em = $this->get('doctrine.orm.entity_manager'); //get repository for class 'Language' : LanguageRepository.php $repository = $em->getRepository('Acme\\InfoBundle\\Entity\\News'); //get count of languages for using with Paginator class //Using custom made database query function in LanguageRepository class $languagesCount = $repository->getIdCount(); //When creating new paginator object it takes care for pages and items //organization based on numbers of items from database and limit variable in $_GET $paginator = new News($languagesCount); //get returned HTML string from Paginator to render paginator HTML //elements in the template $strPaginator = $paginator->RenderPaginator(); //If we have POST variable defined, than it is defined order of items //from inside form (clicking on sorting column for example) $sort_direction = "asc"; /*if ('POST' === $this->get('request')->getMethod()) { $order_by = array($_POST['filter_order'] => $_POST['filter_order_Dir']); $sort_direction = $_POST['filter_order_Dir'] == 'asc' ? 'desc' : 'asc'; } else { //We know that nothing is changed for ordering columns - //this is alse default order of items when page is first opened $order_by = array('sort_order' => 'asc', 'id' => 'asc'); $sort_direction = 'desc'; }*/ //To fill $languages for forwarding it to the template, we first call database function //with $offset and $limit to get items we wanted //$languages = $repository->getProductListWithPagination($order_by, $paginator->getOffset(), $paginator->getLimit()); //Finally - return array to templating engine for displaying data. $news = $this->get('doctrine')->getRepository('AcmeInfoBundle:News')->findAll(); $page = $languagesCount / 3; $news = $repository->getProductListWithPagination($sort_direction, $paginator->getOffset(), $paginator->getLimit()); return $this->render('AcmeHomeBundle:Default:news.html.twig', array('news' => $news, 'sort_dir' => $sort_direction, 'paginator' => $strPaginator, 'count' => $languagesCount, 'page' => $page)); }
/** * {@inheritDoc} */ public function getLimit() { $this->__initializer__ && $this->__initializer__->__invoke($this, 'getLimit', array()); return parent::getLimit(); }