<?php

namespace Bundle\PageBundle\Controller;

use Symfony\Bundle\FrameworkBundle\Controller\Controller;

class BackendController extends Controller
{
    public function indexAction()
    {
      $entity_manager = $this->get('doctrine.orm.entity_manager');
      $query = $entity_manager->createQuery('SELECT p FROM Bundle\PageBundle\Entity\Page p LEFT JOIN p.menu_node m ORDER BY p.menu_title ASC');
      $pages = $query->getResult();

      return $this->render('PageBundle:Backend:index.php', array('pages' => $pages));
    }

    public function editAction($id)
    {
      $entity_manager = $this->get('doctrine.orm.entity_manager');
      $page = $entity_manager->find('Bundle\PageBundle\Entity\Page', $id);

      return $this->render('PageBundle:Backend:edit.php');
    }
}