src/Controller/PageController.php line 100

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\AboutHim;
  6. use App\Entity\AboutMuseum;
  7. use App\Entity\Authors;
  8. use App\Entity\Comments;
  9. use App\Entity\Contact;
  10. use App\Entity\Creations;
  11. use App\Entity\Discuss;
  12. use App\Entity\HomePage;
  13. use App\Entity\Impact;
  14. use App\Entity\Interesting;
  15. use App\Entity\LastCreations;
  16. use App\Entity\Museum;
  17. use App\Entity\NewCreations;
  18. use App\Entity\NewImpact;
  19. use App\Entity\NewOptionAuthors;
  20. use App\Entity\OptionAuthors;
  21. use App\Entity\OurNotebooks;
  22. use App\Entity\Page;
  23. use App\Entity\Sayings;
  24. use App\Form\Type\CollapseType;
  25. use App\Form\Type\CollapseTypeFirst;
  26. use App\Repository\PageRepository;
  27. use App\Service\MailerService;
  28. use App\Service\UuidService;
  29. use Monolog\Handler\SwiftMailerHandler;
  30. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  31. use Symfony\Component\HttpFoundation\JsonResponse;
  32. use Symfony\Component\HttpFoundation\Response;
  33. use Symfony\Component\Routing\Annotation\Route;
  34. use Twig\Environment;
  35. use Knp\Component\Pager\PaginatorInterface;
  36. use Symfony\Component\HttpFoundation\Request;
  38. class PageController extends AbstractController
  39. {
  41.     /**
  42.      * @var PageRepository
  43.      */
  44.     private $pageRepository;
  46.     /**
  47.      * PageController constructor.
  48.      * @param PageRepository $pageRepository
  49.      */
  50.     public function __construct(PageRepository $pageRepository)
  51.     {
  52.         $this->pageRepository = $pageRepository;
  53.     }
  54.     public function footer()
  55.     {
  56.         $em = $this->getDoctrine();
  57.         $contact = $em->getRepository(Contact::class)->findAll();
  58.         return $this->render('parts/footer.html.twig', [
  59.             'contact' => $contact[0],
  60.         ]);
  61.     }
  63.     /**
  64.      * @Route("/", name="page_index")
  65.      */
  66.     public function index()
  67.     {
  68.         $em = $this->getDoctrine()->getManager();
  69.         $homePage = $em->getRepository(HomePage::class)->findAll();
  70.         $authors = $em->getRepository(Authors::class)->createQueryBuilder('a')
  71.             ->orderBy('a.orderId', 'ASC')
  72.             ->getQuery()
  73.             ->setMaxResults(4)
  74.             ->getResult();
  75.         $page = $em->getRepository(Page::class)->find(1);
  76.         return $this->render('page/index.html.twig', [
  77.             'homePage' => $homePage[0],
  78.             'authors' => $authors,
  79.             'page' => $page,
  80.         ]);
  81.     }
  83.     /**
  84.      * @Route("/view/{slug}", name="page_view")
  85.      */
  86.     public function view($slug)
  87.     {
  88.         $em = $this->getDoctrine()->getManager();
  89.         $authors = $em->getRepository(Authors::class)->findOneBy(['slug' => $slug]);
  90.         $page = $em->getRepository(Page::class)->find(5);
  91.         return $this->render('page/view.html.twig', [
  92.             'item' => $authors,
  93.             'page' => $page
  94.         ]);
  95.     }
  97.     /**
  98.      * @Route("/options/{slug}", name="page_options")
  99.      */
  100.     public function options($slug)
  101.     {
  102.         $em = $this->getDoctrine()->getManager();
  103.         $authors = $em->getRepository(Authors::class)->findOneBy(['slug' => $slug]);
  104.         $optionAuthors = $em->getRepository(OptionAuthors::class)->findOneBy(['authors' => $authors]);
  105.         $option = $em->getRepository(NewOptionAuthors::class)->findOneBy(['authors' => $authors]);
  106.         $page = $em->getRepository(Page::class)->find(6);
  107.         return $this->render('page/options.html.twig', [
  108.             'item' => $authors,
  109.             'optionAuthors' => $optionAuthors,
  110.             'option' => $option,
  111.             'page' => $page,
  113.         ]);
  114.     }
  116.     /**
  117.      * @Route("/authors", name="page_authors")
  118.      */
  119.     public function authors(PaginatorInterface $paginator, Request $request)
  120.     {
  121.         $em = $this->getDoctrine()->getManager();
  122.         $authors = $em->getRepository(Authors::class)->createQueryBuilder('a')
  123.             ->orderBy('a.orderId', 'ASC')
  124.             ->getQuery()
  125.             ->getResult();
  126.         $appointments = $paginator->paginate(
  127.             $authors,
  128.             $request->query->getInt('page', 1),
  129.             10
  130.         );
  131.         $page = $em->getRepository(Page::class)->find(2);
  132.         return $this->render('page/authors.html.twig', [
  133.             'authors' => $authors,
  134.             'appointments' => $appointments,
  135.             'page' => $page
  136.         ]);
  137.     }
  139.     /**
  140.      * @Route("/search", name="get_search")
  141.      */
  142.     public function search(Request $request)
  143.     {
  144.         $em = $this->getDoctrine()->getManager();
  145.         $authors = $em->getRepository(Authors::class)->createQueryBuilder('a');
  146.         $creat = $em->getRepository(LastCreations::class)->createQueryBuilder('nc');
  147.         $opt = $em->getRepository(NewOptionAuthors::class)->createQueryBuilder('op');
  148.         $say = $em->getRepository(Sayings::class)->createQueryBuilder('say');
  149.         $int = $em->getRepository(Interesting::class)->createQueryBuilder('int');
  150.         $imp = $em->getRepository(NewImpact::class)->createQueryBuilder('imp');
  151.         $abou = $em->getRepository(AboutHim::class)->createQueryBuilder('abou');
  152.         $mus = $em->getRepository(Museum::class)->createQueryBuilder('mus');
  153.         if ($request->get('search') && !empty($request->get('search'))) {
  154.             $allData = [];
  155.             $authors
  156.                 ->select('a.id as authors_id')
  157.                 ->where('a.fullName LIKE :search Or a.titleText LIKE :search Or a.shortText LIKE :search Or a.question LIKE :search Or a.bottomPartBoldText LIKE :search')
  158.                 ->setParameter('search', '%' . $request->get('search') . '%');
  159.             $authors_information = $authors->getQuery()->getResult();
  160.             if (!empty($authors_information)) {
  161.                 $allData['authors'] = $authors_information;
  162.             }
  163.             $creat
  164.                 ->select('nc.id as new_creations_id')
  165.                 ->Where('nc.collection  LIKE :search Or nc.title LIKE :search ')
  166.                 ->setParameter('search', '%' . $request->get('search') . '%');
  167.             $new_creations_information = $creat->getQuery()->getResult();
  168.             if (!empty($new_creations_information)) {
  169.                 $allData['creations'] = $new_creations_information;
  170.             }
  171.             $opt
  172.                 ->select('op.id as new_options_id')
  173.                 ->Where('op.collection LIKE :search')
  174.                 ->setParameter('search', '%' . $request->get('search') . '%');
  175.             $new_options = $opt->getQuery()->getResult();
  176.             if (!empty($new_options)) {
  177.                 $allData['options'] = $new_options;
  178.             }
  179.             $say
  180.                 ->select('say.id as new_sayings_id')
  181.                 ->Where('say.text LIKE :search Or say.bottomText LIKE :search')
  182.                 ->setParameter('search', '%' . $request->get('search') . '%');
  183.             $new_sayings = $say->getQuery()->getResult();
  184.             if (!empty($new_sayings)) {
  185.                 $allData['sayings'] = $new_sayings;
  186.             }
  187.             $int
  188.                 ->select('int.id as new_interesting_id')
  189.                 ->Where('int.rightText LIKE :search Or int.text LIKE :search')
  190.                 ->setParameter('search', '%' . $request->get('search') . '%');
  191.             $new_interesting = $int->getQuery()->getResult();
  192.             if (!empty($new_interesting)) {
  193.                 $allData['interesting'] = $new_interesting;
  194.             }
  195.             $imp
  196.                 ->select('imp.id as new_impact_id')
  197.                 ->Where('imp.collection LIKE :search')
  198.                 ->setParameter('search', '%' . $request->get('search') . '%');
  199.             $new_impact = $imp->getQuery()->getResult();
  200.             if (!empty($new_impact)) {
  201.                 $allData['impact'] = $new_impact;
  202.             }
  203.             $imp
  204.                 ->select('imp.id as new_impact_id')
  205.                 ->Where('imp.collection LIKE :search')
  206.                 ->setParameter('search', '%' . $request->get('search') . '%');
  207.             $new_impact = $imp->getQuery()->getResult();
  208.             if (!empty($new_impact)) {
  209.                 $allData['impact'] = $new_impact;
  210.             }
  211.             $abou
  212.                 ->select('abou.id as new_about_id')
  213.                 ->Where('abou.rightPart LIKE :search Or abou.BottomPart LIKE :search')
  214.                 ->setParameter('search', '%' . $request->get('search') . '%');
  215.             $new_about = $abou->getQuery()->getResult();
  216.             if (!empty($new_about)) {
  217.                 $allData['about'] = $new_about;
  218.             }
  219.             $mus
  220.                 ->select('mus.id as new_museum_id')
  221.                 ->Where('mus.museum LIKE :search')
  222.                 ->setParameter('search', '%' . $request->get('search') . '%');
  223.             $new_museum = $mus->getQuery()->getResult();
  224.             if (!empty($new_museum)) {
  225.                 $allData['museum'] = $new_museum;
  226.             }
  227.         }
  228.         $author = [];
  229.         $creation = [];
  230.         $options = [];
  231.         $sayings = [];
  232.         $interesting = [];
  233.         $impact = [];
  234.         $about = [];
  235.         $museum = [];
  236.         foreach ($allData as $items) {
  237.             foreach ($items as $item) {
  238.                 foreach ($item as $key => $value) {
  239.                     if ($key == "authors_id") {
  240.                         $aut[] = $em->getRepository(Authors::class)->findBy(['id' => $value]);
  241.                         $author = $aut;
  242.                     } elseif ($key == "new_creations_id") {
  243.                         $crea[] = $em->getRepository(LastCreations::class)->findBy(['id' => $value]);
  244.                         $creation = $crea;
  245.                     } elseif ($key == "new_options_id") {
  246.                         $op[] = $em->getRepository(NewOptionAuthors::class)->findBy(['id' => $value]);
  247.                         $options = $op;
  248.                     } elseif ($key == "new_sayings_id") {
  249.                         $sa[] = $em->getRepository(Sayings::class)->findBy(['id' => $value]);
  250.                         $sayings = $sa;
  251.                     } elseif ($key == "new_interesting_id") {
  252.                         $in[] = $em->getRepository(Interesting::class)->findBy(['id' => $value]);
  253.                         $interesting = $in;
  254.                     } elseif ($key == "new_impact_id") {
  255.                         $im[] = $em->getRepository(NewImpact::class)->findBy(['id' => $value]);
  256.                         $impact = $im;
  257.                     } elseif ($key == "new_about_id") {
  258.                         $ab[] = $em->getRepository(AboutHim::class)->findBy(['id' => $value]);
  259.                         $about = $ab;
  260.                     } elseif ($key == "new_museum_id") {
  261.                         $muse[] = $em->getRepository(Museum::class)->findBy(['id' => $value]);
  262.                         $museum = $muse;
  263.                     }
  264.                 }
  265.             }
  266.         }
  267.         $page = $em->getRepository(Page::class)->find(14);
  268.         return $this->render('parts/search.html.twig', [
  269.             'author' => $author,
  270.             'creations' => $creation,
  271.             'options' => $options,
  272.             'sayings' => $sayings,
  273.             'interesting' => $interesting,
  274.             'impact' => $impact,
  275.             'about' => $about,
  276.             'museum' => $museum,
  277.             'page' => $page,
  278.         ]);
  279.     }
  281.     /**
  282.      * @Route("/get_creation", name="get_creation")
  283.      */
  284.     public function getCreation(Request $request)
  285.     {
  286.         $em = $this->getDoctrine()->getManager();
  287.         if ($request->get('item')) {
  288.             $title = $request->get('item')["id"];
  289.             $slug = $request->get('item')["slug"];
  290.             $authors = $em->getRepository(Authors::class)->findOneBy(['slug' => $slug]);
  291.             $creat = $em->getRepository(LastCreations::class)->createQueryBuilder('n')
  292.                 ->where('n.authors = :author_id')
  293.                 ->setParameter('author_id', $authors->getId())
  294.                 ->getQuery()
  295.                 ->getArrayResult();
  296.             $newcreations = $em->getRepository(LastCreations::class)->createQueryBuilder('c')
  297.                 ->where('c.authors = :author_id')
  298.                 ->andWhere('c.title=:tit')
  299.                 ->setParameter('author_id', $authors->getId())
  300.                 ->setParameter('tit', $title)
  301.                 ->getQuery()
  302.                 ->getArrayResult();
  303.             $newArr = [];
  304.             foreach ($newcreations as $item) {
  306.             }
  307.         }
  308.         return new JsonResponse($item['title']);
  309.     }
  311.     /**
  312.      * @Route("/creations/{slug}", name="page_creations")
  313.      */
  314.     public function creations($slug)
  315.     {
  316.         $em = $this->getDoctrine()->getManager();
  317.         $comments = $em->getRepository(Comments::class)->findAll();
  318.         $authors = $em->getRepository(Authors::class)->findOneBy(['slug' => $slug]);
  319.         $creations = $em->getRepository(Creations::class)->createQueryBuilder('c')
  320.             ->where('c.authors = :author_id')
  321.             ->setParameter('author_id', $authors->getId())
  322.             ->getQuery()
  323.             ->getArrayResult();
  324.         $newcreations = $em->getRepository(NewCreations::class)->createQueryBuilder('c')
  325.             ->where('c.authors = :author_id')
  326.             ->setParameter('author_id', $authors->getId())
  327.             ->getQuery()
  328.             ->getArrayResult();
  329.         $lastcreations = $em->getRepository(LastCreations::class)->createQueryBuilder('c')
  330.             ->where('c.authors = :author_id')
  331.             ->setParameter('author_id', $authors->getId())
  332.             ->getQuery()
  333.             ->getArrayResult();
  334.         $page = $em->getRepository(Page::class)->find(7);
  335.         return $this->render('page/creations.html.twig', [
  336.             'newcreations' => $newcreations,
  337.             'lastcreations' => $lastcreations,
  338.             'comments' => $comments,
  339.             'item' => $authors,
  340.             'page' => $page,
  341. //            'creations' => count($creations) ? $creations[0] : [],
  342.         ]);
  343.     }
  345.     /**
  346.      * @Route("/sayings/{slug}", name="page_sayings")
  347.      */
  348.     public function sayings($slug)
  349.     {
  350.         $em = $this->getDoctrine()->getManager();
  351.         $authors = $em->getRepository(Authors::class)->findOneBy(['slug' => $slug]);
  352.         $sayings = $em->getRepository(Sayings::class)->findOneBy(['authors' => $authors]);
  353.         $comments = $em->getRepository(Comments::class);
  354.         $newData = [];
  355.         $page = $em->getRepository(Page::class)->find(8);
  356.         return $this->render('page/sayings.html.twig', [
  357.             'sayings' => $sayings,
  358.             'item' => $authors,
  359.             'page' => $page,
  360.         ]);
  361.     }
  363.     /**
  364.      * @Route("/interesting/{slug}", name="page_interesting")
  365.      */
  366.     public function interesting($slug)
  367.     {
  368.         $em = $this->getDoctrine()->getManager();
  369.         $authors = $em->getRepository(Authors::class)->findOneBy(['slug' => $slug]);
  370.         $interesting = $em->getRepository(Interesting::class)->findOneBy(['authors' => $authors]);
  371.         $page = $em->getRepository(Page::class)->find(9);
  372.         return $this->render('page/interesting.html.twig', [
  373.             'item' => $authors,
  374.             'interesting' => $interesting,
  375.             'page' => $page,
  377.         ]);
  378.     }
  380.     /**
  381.      * @Route("/about_him/{slug}", name="page_about_him")
  382.      */
  383.     public function about_him($slug)
  384.     {
  385.         $em = $this->getDoctrine()->getManager();
  386.         $authors = $em->getRepository(Authors::class)->findOneBy(['slug' => $slug]);
  387.         $aboutHim = $em->getRepository(AboutHim::class)->findOneBy(['authors' => $authors]);
  388.         $comments = $em->getRepository(Comments::class);
  389.         $newData = [];
  390.         $page = $em->getRepository(Page::class)->find(11);
  391.         return $this->render('page/about_him.html.twig', [
  392.             'item' => $authors,
  393.             'aboutHim' => $aboutHim,
  394.             'comments' => $newData,
  395.             'page' => $page,
  397.         ]);
  398.     }
  400.     /**
  401.      * @Route("/impact/{slug}", name="page_impact")
  402.      */
  403.     public function impact($slug)
  404.     {
  405.         $em = $this->getDoctrine()->getManager();
  406.         $authors = $em->getRepository(Authors::class)->findOneBy(['slug' => $slug]);
  407.         $impact = $em->getRepository(Impact::class)->findOneBy(['authors' => $authors]);
  408.         $comments = $em->getRepository(Comments::class);
  409.         $newImpact = $em->getRepository(NewImpact::class)->findOneBy(['authors' => $authors]);
  410.         if (isset($newImpact)) {
  411.             $new = $newImpact->getCollection();
  412.         } else {
  413.             $new = $newImpact;
  414.         }
  415.         $page = $em->getRepository(Page::class)->find(10);
  416.         return $this->render('page/impact.html.twig', [
  417.             'item' => $authors,
  418.             'impact' => $impact,
  419.             'newImpact' => $new,
  420.             'page' => $page,
  422.         ]);
  423.     }
  425.     /**
  426.      * @Route("/museum/{slug}", name="page_museum")
  427.      */
  428.     public function museum($slug)
  429.     {
  430.         $em = $this->getDoctrine()->getManager();
  431.         $authors = $em->getRepository(Authors::class)->findOneBy(['slug' => $slug]);
  432.         $museum = $em->getRepository(Museum::class)->findOneBy(['authors' => $authors]);
  433.         $page = $em->getRepository(Page::class)->find(12);
  434.         return $this->render('page/museum.html.twig', [
  435.             'item' => $authors,
  436.             'museum' => $museum,
  437.             'page' => $page,
  438.         ]);
  439.     }
  441.     /**
  442.      * @Route("/about_museum/{slug}", name="page_about_museum")
  443.      */
  444.     public function about_museum($slug)
  445.     {
  446.         $em = $this->getDoctrine()->getManager();
  447.         $authors = $em->getRepository(Authors::class)->findOneBy(['slug' => $slug]);
  448.         $aboutMuseum = $em->getRepository(AboutMuseum::class)->findOneBy(['authors' => $authors]);
  449.         return $this->render('page/about-museum.html.twig', [
  450.             'item' => $authors,
  451.             'aboutMuseum' => $aboutMuseum
  452.         ]);
  453.     }
  455.     /**
  456.      * @Route("/discuss/{slug}", name="page_discuss")
  457.      */
  458.     public function discuss($slug)
  459.     {
  460.         $em = $this->getDoctrine()->getManager();
  461.         $comment = $em->getRepository(Comments::class)->findOneBy(['id' => $slug]);
  462.         $discuss = $em->getRepository(Discuss::class)->findBy(['comments' => $slug], ['orderId' => 'DESC']);
  463.         $comments = $em->getRepository(Discuss::class)->CreateQueryBuilder('c')
  464.             ->where('c.comments =:id')
  465.             ->setParameter('id', $slug)
  466.             ->getQuery()
  467.             ->getArrayResult();
  468.         $page = $em->getRepository(Page::class)->find(13);
  469.         return $this->render('page/discuss.html.twig', [
  470.             'comment' => $comment,
  471.             'answer' => $comments,
  472.             'discuss' => $discuss,
  473.             'page' => $page,
  474.         ]);
  475.     }
  477.     /**
  478.      * @Route("/basket", name="page_basket")
  479.      */
  480.     public function basket()
  481.     {
  482.         $em = $this->getDoctrine()->getManager();
  483.         $page = $em->getRepository(Page::class)->find(4);
  484.         return $this->render('page/basket.html.twig', [
  485.             'page' => $page
  486.         ]);
  487.     }
  489.     /**
  490.      * @Route("/notebooks", name="page_notebooks")
  491.      */
  492.     public function notebooks()
  493.     {
  494.         $em = $this->getDoctrine()->getManager();
  495.         $homePage = $em->getRepository(HomePage::class)->findAll();
  496.         $notebooks = $em->getRepository(OurNotebooks::class)->findAll();
  497.         $page = $em->getRepository(Page::class)->find(3);
  498.         return $this->render('page/our_notebooks.html.twig', [
  499.             'homePage' => $homePage[0],
  500.             'notebooks' => $notebooks,
  501.             'page' => $page,
  502.         ]);
  503.     }
  505. }