public function load(ObjectManager $em)
 {
     $design = new Category();
     $design->setName('Design');
     $programming = new Category();
     $programming->setName('Programming');
     $manager = new Category();
     $manager->setName('Manager');
     $administrator = new Category();
     $administrator->setName('Administrator');
     $em->persist($design);
     $em->persist($programming);
     $em->persist($manager);
     $em->persist($administrator);
     $em->flush();
     $this->addReference('category-design', $design);
     $this->addReference('category-programming', $programming);
     $this->addReference('category-manager', $manager);
     $this->addReference('category-administrator', $administrator);
 }
 /**
  * @Route(name="job_category", path="/{slug}/{page}")
  */
 public function showAction(Category $category, $page = 1)
 {
     $em = $this->getDoctrine()->getManager();
     $category->setActiveJobs($em->getRepository('JoBeetBundle:Job')->getActiveJobs($category->getId()));
     $total_jobs = $em->getRepository('JoBeetBundle:Job')->countActiveJobs($category->getId());
     $jobs_per_page = $this->container->getParameter('max_jobs_on_category');
     $last_page = ceil($total_jobs / $jobs_per_page);
     $previous_page = $page > 1 ? $page - 1 : 1;
     $next_page = $page < $last_page ? $page + 1 : $last_page;
     $category->setActiveJobs($em->getRepository('JoBeetBundle:Job')->getActiveJobs($category->getId(), $jobs_per_page, ($page - 1) * $jobs_per_page));
     return $this->render(':category:show.html.twig', array('category' => $category, 'last_page' => $last_page, 'previous_page' => $previous_page, 'current_page' => $page, 'next_page' => $next_page, 'total_jobs' => $total_jobs));
 }