src/Controller/HomeController.php line 33

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Meta;
  6. use App\Entity\Post;
  7. use App\Form\FaqType;
  8. use App\Form\QuizType;
  9. use App\Repository\CategoryRepository;
  10. use App\Repository\MetaRepository;
  11. use App\Repository\PostRepository;
  12. use Doctrine\ORM\EntityManagerInterface;
  13. use Knp\Component\Pager\PaginatorInterface;
  14. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  15. use Symfony\Component\HttpFoundation\Request;
  16. use Symfony\Component\HttpFoundation\Response;
  17. use Symfony\Component\Routing\Annotation\Route;
  18. use Symfony\Contracts\Translation\TranslatorInterface;
  20. #[Route('/')]
  21. class HomeController extends AbstractController
  22. {
  24.     const POST_MAX_COUNT_PER_PAGE = 10;
  25.     private $translator;
  27.     public function __construct(TranslatorInterface $translator)
  28.     {
  29.         $this->translator = $translator;
  30.     }
  32.     #[Route('/', methods: ['GET'], name: 'homepage')]
  33.     public function index(PostRepository $postRepository, Request $request): Response
  34.     {
  35.         $domain = $request->getHost();
  37.         if (preg_match('/\.qr-pib\.kz$/', $domain) == false)
  38.             $domain = 'qr-pib.kz';
  40.         //convert test domains dgr.TEST.ITC.qr-pib.kz => mrd.qr-pib.kz
  41.         if (preg_match('/test\.itc\.qr-pib\.kz$/', $domain)) {
  42.             $domain = preg_replace('/test\.itc\./', '', $domain);
  43.         }
  45.         $newsCount = [
  46.             'qr-pib.kz' => 8,
  47.             'moa.qr-pib.kz' => 5,
  48.             'moseso.qr-pib.kz' => 5,
  49.         ];
  51.         $count = $newsCount[$domain] ?? 4;
  53.         $teaser = $postRepository->findOneBy([
  54.             'template' => 'about',
  55.             'isActive' => true
  56.         ]);
  58.         if (empty($teaser)) {
  59.             $teaser = new Post();
  60.             $teaser->setTitle('');
  61.             $teaser->setContent('');
  62.         }
  64.         $posts = $postRepository->createQueryBuilder('p')
  65.             ->andWhere("p.type = 'post'")
  66. //            @TODO change this
  67.             ->andWhere("p.title <> ''")
  68.             ->andWhere("p.isActive = 1")
  69.             ->andWhere("p.publishedAt < CURRENT_TIMESTAMP()")
  70.             ->orderBy('p.publishedAt', 'DESC')
  71.             ->setMaxResults($count)
  72.             ->getQuery()
  73.             ->setHint(
  74.                 \Gedmo\Translatable\TranslatableListener::HINT_TRANSLATABLE_LOCALE,
  75.                 $request->getLocale() // take locale from session or request etc.
  76.             )
  77.             ->setHint(\Gedmo\Translatable\TranslatableListener::HINT_INNER_JOIN, true)
  78.             ->setHint(\Doctrine\ORM\Query::HINT_CUSTOM_OUTPUT_WALKER, 'Gedmo\\Translatable\\Query\\TreeWalker\\TranslationWalker')
  79.             ->getResult();
  81.         return $this->render('main.html.twig', [
  82.             'posts' => $posts,
  83.             'teaser' => $teaser
  84.         ]);
  86.     }
  88.     #[Route('/{type}/', name: 'app_post_index', methods: ['GET'], requirements: [
  89.         'type' => 'page|post'
  90.     ])]
  91.     public function postlist(PostRepository $postRepository, string $type, Request $request, PaginatorInterface $paginator): Response
  92.     {
  93.         $query = $postRepository->createQueryBuilder('p')
  94.             ->andWhere("p.type = :type")
  95.             ->andWhere("p.title <> ''")
  96.             ->andWhere("p.isActive = 1")
  97.             ->andWhere("p.publishedAt < CURRENT_TIMESTAMP()")
  98.             ->setParameter('type', $type)
  99.             ->orderBy('p.publishedAt', 'DESC')
  100.             ->setMaxResults(self::POST_MAX_COUNT_PER_PAGE)
  101.             ->getQuery()
  102.             ->setHint(
  103.                 \Gedmo\Translatable\TranslatableListener::HINT_TRANSLATABLE_LOCALE,
  104.                 $request->getLocale() // take locale from session or request etc.
  105.             )
  106.             ->setHint(\Gedmo\Translatable\TranslatableListener::HINT_INNER_JOIN, true)
  107.             ->setHint(\Doctrine\ORM\Query::HINT_CUSTOM_OUTPUT_WALKER, 'Gedmo\\Translatable\\Query\\TreeWalker\\TranslationWalker');
  109.         $pagination = $paginator->paginate(
  110.             $query, /* query NOT result */
  111.             $request->query->getInt('page', 1), /*page number*/
  112.             self::POST_MAX_COUNT_PER_PAGE /*limit per page*/
  113.         );
  115.         return $this->render('news.html.twig', [
  116.             'pagination' => $pagination
  117.         ]);
  119.     }
  121.     #[Route('/cat/{category}', name: 'app_category_index', methods: ['GET'])]
  122.     public function categorylist(CategoryRepository $categoryRepository, PostRepository $postRepository, string $category, Request $request, PaginatorInterface $paginator): Response
  123.     {
  125.         $cat = $categoryRepository->find($category);
  126.         //find category
  127.         if (!$cat) {
  128.             throw $this->createNotFoundException('Category not found');
  129.         }
  131.         $query = $postRepository->createQueryBuilder('p')
  132.             ->andWhere("p.isActive = 1")
  133.             ->andWhere("p.title <> ''")
  134. //            ->andWhere("p.content <> ''")
  135.             ->andWhere("p.publishedAt < CURRENT_TIMESTAMP()")
  136.             ->andWhere(":category MEMBER OF p.category")
  137.             ->setParameter('category', $category)
  138.             ->orderBy('p.publishedAt', 'DESC')
  139.             ->setMaxResults(self::POST_MAX_COUNT_PER_PAGE)
  140.             ->getQuery()
  141.             ->setHint(
  142.                 \Gedmo\Translatable\TranslatableListener::HINT_TRANSLATABLE_LOCALE,
  143.                 $request->getLocale() // take locale from session or request etc.
  144.             )
  145.             ->setHint(\Gedmo\Translatable\TranslatableListener::HINT_INNER_JOIN, true)
  146.             ->setHint(\Doctrine\ORM\Query::HINT_CUSTOM_OUTPUT_WALKER, 'Gedmo\\Translatable\\Query\\TreeWalker\\TranslationWalker');
  148.         $pagination = $paginator->paginate(
  149.             $query, /* query NOT result */
  150.             $request->query->getInt('page', 1), /*page number*/
  151.             self::POST_MAX_COUNT_PER_PAGE /*limit per page*/
  152.         );
  154.         return $this->render('category.html.twig', [
  155.             'categoryName' => $cat->getTitle(),
  156.             'pagination' => $pagination
  157.         ]);
  158.     }
  160.     #[Route('/archive/{type}/', name: 'app_archives', methods: ['GET'], requirements: [
  161.         'type' => 'about|administration|contests.all_decisions|contests.all_notices|contests.all_sobes|contests.decision|contests.notice|contests.sobes|corporate.notice|corporate.docs|default|deyatelnost.all_articles|deyatelnost.article|ethics|ethics.worker|feedback|feedback.faq|feedback.faqs|feedback.review|feedback.reviews|history|main|napravleniya.auto|napravleniya.building|napravleniya.education|napravleniya.hotels'
  162.     ])]
  163.     public function arhives(PostRepository $postRepository, string $type, Request $request, PaginatorInterface $paginator): Response
  164.     {
  166.         //@TODO move to repository
  167.         $query = $postRepository->createQueryBuilder('p')
  168.             ->andWhere("p.template_old = :type or p.template = :type")
  169.             ->andWhere("p.title <> ''")
  170.             ->andWhere("p.isActive = 1")
  171.             ->setParameter('type', $type)
  172.             ->orderBy('p.publishedAt', 'DESC')
  173. //            ->setMaxResults(self::POST_MAX_COUNT_PER_PAGE)
  174.             ->getQuery()
  175.             ->setHint(
  176.                 \Gedmo\Translatable\TranslatableListener::HINT_TRANSLATABLE_LOCALE,
  177.                 $request->getLocale() // take locale from session or request etc.
  178.             )
  179.             ->setHint(\Gedmo\Translatable\TranslatableListener::HINT_INNER_JOIN, true)
  180.             ->setHint(\Doctrine\ORM\Query::HINT_CUSTOM_OUTPUT_WALKER, 'Gedmo\\Translatable\\Query\\TreeWalker\\TranslationWalker');
  182.         $pagination = $paginator->paginate(
  183.             $query, /* query NOT result */
  184.             $request->query->getInt('page', 1), /*page number*/
  185.             self::POST_MAX_COUNT_PER_PAGE /*limit per page*/
  186.         );
  188.         if ($type == 'deyatelnost.article') {
  189.             return $this->render('normativ.html.twig', [
  190.                 'pagination' => $pagination,
  191.                 'type' => $type
  192.             ]);
  193.         }
  195.         return $this->render('archive.html.twig', [
  196.             'pagination' => $pagination,
  197.             'type' => $type
  198.         ]);
  200.     }
  203.     #[Route('/search/', name: 'app_post_search', methods: ['GET', 'POST'])]
  204.     public function search(PostRepository $postRepository, Request $request, PaginatorInterface $paginator): Response
  205.     {
  206.         $query = $postRepository->findByPhrase($request->get('query'));
  208.         $pagination = $paginator->paginate(
  209.             $query,
  210.             $request->query->getInt('page', 1),
  211.             10
  212.         );
  214.         return $this->render('search.html.twig', [
  215.             'posts' => $pagination
  216.         ]);
  217.     }
  219.     #[Route('/search/post/', name: 'app_post_search_post', methods: ['GET', 'POST'])]
  220.     public function searchPost(PostRepository $postRepository, Request $request, PaginatorInterface $paginator): Response
  221.     {
  222.         $query = $postRepository->findPostsByQuery($request->get('query', ''));
  224.         $pagination = $paginator->paginate(
  225.             $query,
  226.             $request->query->getInt('page', 1),
  227.             self::POST_MAX_COUNT_PER_PAGE
  228.         );
  230.         return $this->render('search.html.twig', [
  231.             'posts' => $pagination
  232.         ]);
  234.     }
  236.     //@TODO @BUG deyatelnost.article crashing
  237.     //@TODO move domain checking to listener
  238.     #[Route('/p/{id}', name: 'app_post_show', methods: ['GET'])]
  239.     public function showById(Post $post, EntityManagerInterface $em, Request $request): Response
  240.     {
  241.         //@TODO move to service or listener
  242.         $domain = $request->getHost();
  244.         //@TODO refactor me
  245.         //convert test domains dgr.TEST.ITC.qr-pib.kz => mrd.qr-pib.kz
  246.         if (preg_match('/test\.itc\.qr-pib\.kz$/', $domain)) {
  247.             $domain = preg_replace('/test\.itc\./', '', $domain);
  248.         }
  250.         if ($domain == 'localhost' or $domain == '127.0.0.1')
  251.             $domain = 'qr-pib.kz';
  253.         if (preg_match('/qr-pib\.kz$/', $domain) == false)
  254.             return $this->redirectToRoute('homepage');
  256.         if ($post->getDomain() != $domain)
  257.             return $this->redirectToRoute('homepage');
  259.         if ($post->getTitle() == '')
  260.             return $this->redirectToRoute('homepage');
  262.         if(!$post->isIsActive())
  263.             return $this->redirectToRoute('homepage');
  265.         $count = $post->getCounter();
  266.         $post->setCounter($count + 1);
  267.         $em->persist($post);
  268.         $em->flush();
  270.         //@TODO clear this shit from here!!!
  271.         if ( $post->getTemplate() == 'template_wide_screen') {
  272.             return $this->render('template_wide_screen.html.twig', [
  273.                 'post' => $post,
  274.             ]);
  275.         }
  278.         if ( $post->getTemplate() != ''  && !in_array($post->getTemplate(), ['deyatelnost.article', 'contests.notice', 'contests.decision','corporate.notice', 'corporate.docs',  'contests.sobes'])) {
  279.             return $this->render('templater.html.twig', [
  280.                 'post' => $post,
  281.             ]);
  282.         }
  284.         $newsCount = [
  285.             'qr-pib.kz' => 8,
  286.         ];
  288.         return $this->render('newsview.html.twig', [
  289.             'post' => $post,
  290.         ]);
  291.     }
  293.     #[Route('/p/{id}/e', name: 'app_post_redirect_to_admin', methods: ['GET'])]
  294.     public function redirecToAdmin(Post $post, EntityManagerInterface $em, Request $request, $id): Response
  295.     {
  296.         // if is admin logged in
  297.         // redirect to admin page
  298.         return $this->redirect('/epir_adm?crudAction=edit&crudControllerFqcn=App%5CController%5CAdmin%5CPostCrudController&entityId='.$id.'&menuIndex=1&page=3');
  299.     }
  301. }