/**
  * @Route("/" , name="main")
  * @Template()
  */
 public function indexAction(Request $request)
 {
     $em = $this->getDoctrine()->getManager();
     $task = new Article();
     $form = $this->createForm(new NewsType($em), $task);
     $formData = $form->handleRequest($request);
     if ($formData->isValid()) {
         $task = $formData->getData();
         $latin_title = new LatinTitle();
         $number = $this->the_last_id2("article");
         $task->setType(5);
         $rus_title = $task->getTitle();
         $txt = $this->FromRusToLatin($rus_title);
         $latin_title->setTitle($txt);
         $latin_title->setArticleId($number + 1);
         $task->setCategory($this->loadOrCreateTags($task->getCategory()));
         $em->persist($latin_title);
         $em->persist($task);
         $em->flush();
         $em->refresh($task);
         return $this->redirect($this->generateUrl('main'));
     }
     //        -----------------
     $date = $this->getcalendar();
     //        $article = $this->getDoctrine()->getRepository("AdminBundle:Article")->findAll();
     $slider = $this->getDoctrine()->getRepository("AdminBundle:Slider");
     $slider_query = $slider->createQueryBuilder('a')->orderBy('a.id', 'DESC')->getQuery();
     $result_slider = $slider_query->getResult();
     //        $the_first_ten_articles_and_reviews = array();
     $the_first_ten_articles_and_reviews = $this->get_sorted_article_and_review(0);
     //!!!!!!!!!!!!!!!!!!!!
     return array('games' => $date['games'], 'films' => $date['films'], 'articles' => $the_first_ten_articles_and_reviews, 'slider' => $result_slider, 'form' => $form->createView());
 }
 /**
  * @Route("/admin/addreview", name="addReview")
  * @Template("AdminBundle:Review:addReview.html.twig")
  */
 public function addReviewAction(Request $request)
 {
     $em = $this->getDoctrine()->getManager();
     $review = new Review();
     $latin_title = new LatinTitle();
     $form = $this->createForm(new ReviewType($em), $review);
     $formData = $form->handleRequest($request);
     if ($formData->isValid()) {
         $task = $formData->getData();
         $rus_title = $task->getTitle();
         $txt = $this->FromRusToLatin($rus_title);
         $task->setCategory($this->loadOrCreateTags($task->getCategory()));
         $em->persist($task);
         $em->flush();
         $number = $this->the_last_id("review");
         $latin_title->setTitle($txt);
         $latin_title->setArticleId($number);
         $em->persist($latin_title);
         $em->flush();
         $type = "addReview";
         $html = $this->renderView("AdminBundle:Default:Success.html.twig", array('type' => $type));
         return new Response($html);
     }
     return array('form' => $form->createView());
 }