src/Controller/BlogController.php line 126

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\{BlogCategorie, BlogCategorieTranslation};
  6. use App\Entity\{BlogArticle, BlogArticleTranslation};
  8. use Doctrine\ORM\EntityManagerInterface;
  9. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  10. use Symfony\Component\HttpFoundation\{Response, Request};
  11. use Symfony\Component\Routing\Annotation\Route;
  12. use Symfony\Component\Mailer\MailerInterface;
  13. use Symfony\Component\HttpFoundation\JsonResponse;
  15. use App\Entity\Contact;
  16. use App\Form\ContactType;
  17. use App\Manager\ContactManager;
  19. class BlogController extends AbstractController
  20. {
  21.     #[Route('/blog', name: 'blog')]
  22.     #[Route('/{_locale}/blog', name: 'blog.es', requirements: ['_locale' => 'es'])]
  23.     #[Route('/{_locale}/blog', name: 'blog.de', requirements: ['_locale' => 'de'])]
  25.     #[Route('/{_locale}/blog/page/{page}', name: 'blog.page.es', requirements: ['_locale' => 'es'])]
  26.     #[Route('/{_locale}/blog/page/{page}', name: 'blog.page.de', requirements: ['_locale' => 'de'])]
  27.     #[Route('/blog/page/{page}', name: 'blog.page')]
  28.     public function index(Request $request, ContactManager $contactManager, EntityManagerInterface $em, $page = 1): Response
  29.     {
  30.         $totalArticles = 8;
  31.         $start = ($page * $totalArticles) -$totalArticles;
  33.         $articles_total = $em->createQueryBuilder()
  34.             ->select('count(a)')
  35.             ->from(BlogArticle::class, 'a')
  36.             ->join('a.translations', 't', 'WITH', 't.locale LIKE :locale')
  37.             ->where('a.isActive = true')
  38.             ->andWhere('t.slug is not null')
  39.             ->orderBy('a.datePublication', 'DESC')
  40.             ->setParameter(':locale', $request->getLocale() )
  41.             ->getQuery()
  42.             ->getSingleScalarResult()
  43.         ;
  44.         $pages = ceil($articles_total / $totalArticles);
  46.         $articles = $em->createQueryBuilder()
  47.             ->select('a')
  48.             ->from(BlogArticle::class, 'a')
  49.             ->join('a.translations', 't', 'WITH', 't.locale LIKE :locale')
  50.             ->where('a.isActive = true')
  51.             ->andWhere('t.slug is not null')
  52.             ->orderBy('a.datePublication', 'DESC')
  53.             ->setParameter(':locale', $request->getLocale() )
  54.             ->setMaxResults($totalArticles)
  55.             ->setFirstResult($start)
  56.             ->getQuery()
  57.             ->getResult()
  58.         ;
  61.         return $this->render('blog/index.html.twig', [
  62.             'articles' => $articles,
  63.             'articles_total' => $articles_total,
  64.             'pages' => $pages,
  65.             'current_page' => $page
  66.         ]);
  67.     }
  70.     #[Route('/blog/category/{slug}', name: 'blog.category')]
  71.     #[Route('/blog/category/{slug}/page/{page}', name: 'blog.category.page')]
  72.     #[Route('/{_locale}/blog/category/{slug}', name: 'blog.category.es', requirements: ['_locale' => 'es'])]
  73.     #[Route('/{_locale}/blog/category/{slug}/page/{page}', name: 'blog.category.page.es', requirements: ['_locale' => 'es'])]
  74.     #[Route('/{_locale}/blog/category/{slug}', name: 'blog.category.de',requirements: ['_locale' => 'de'])]
  75.     #[Route('/{_locale}/blog/category/{slug}/page/{page}', name: 'blog.category.page.de', requirements: ['_locale' => 'de'])]
  76.     public function category(BlogCategorieTranslation $blogCategorieTranslation, Request $request,EntityManagerInterface $em, $page=1): Response
  77.     {
  78.         $blogCategorie = $blogCategorieTranslation->getTranslatable();
  79.         $totalArticles = 8;
  80.         $start = ($page * $totalArticles) -$totalArticles;
  82.         $articles_total = $em->createQueryBuilder()
  83.             ->select('count(a)')
  84.             ->from(BlogArticle::class, 'a')
  85.             ->join('a.categories', 'b')
  86.             ->join('a.translations', 't', 'WITH', 't.locale LIKE :locale')
  87.             ->where('b.id = :categorie_id')
  88.             ->andWhere('b.isActive = true')
  89.             ->andWhere('t.slug is not null')
  90.             ->setParameter(':categorie_id', $blogCategorie->getId())
  91.             ->setParameter(':locale', $request->getLocale() )
  92.             ->getQuery()
  93.             ->getSingleScalarResult()
  94.         ;
  95.         $pages = ceil($articles_total / $totalArticles);
  97.         $articles = $em->createQueryBuilder()
  98.             ->select('a')
  99.             ->from(BlogArticle::class, 'a')
  100.             ->join('a.categories', 'b')
  101.             ->join('a.translations', 't', 'WITH', 't.locale LIKE :locale')
  102.             ->where('b.id = :categorie_id')
  103.             ->andWhere('b.isActive = true')
  104.             ->andWhere('t.slug is not null')
  105.             ->setParameter(':categorie_id', $blogCategorie->getId())
  106.             ->setParameter(':locale', $request->getLocale() )
  107.             ->orderBy('a.datePublication', 'DESC')
  108.             ->setMaxResults($totalArticles)
  109.             ->setFirstResult($start)
  110.             ->getQuery()
  111.             ->getResult()
  112.             ;
  114.         return $this->render('blog/categorie.html.twig', [
  115.             'blogCategorie' => $blogCategorie,
  116.             'articles' => $articles,
  117.             'articles_total' => $articles_total,
  118.             'pages' => $pages,
  119.             'current_page' => $page
  120.         ]);
  121.     }
  123.     #[Route('/blog/{slug}', name: 'blog.show')]
  124.     #[Route('/{_locale}/blog/{slug}', name: 'blog.show.es', requirements: ['_locale' => 'es'])]
  125.     #[Route('/{_locale}/blog/{slug}', name: 'blog.show.de', requirements: ['_locale' => 'de'])]
  126.     public function show(BlogArticleTranslation $articleTranslate, Request $request,EntityManagerInterface $em): Response
  127.     {
  128.         $article = $articleTranslate->getTranslatable();
  130.         if(!$article->isIsActive()){
  131.           return $this->redirectToRoute('blog.list');
  132.         }
  134.         $articles_query = $em->createQueryBuilder()
  135.             ->select('a')
  136.             ->from(BlogArticle::class, 'a')
  137.             ->join('a.translations', 't', 'WITH', 't.locale LIKE :locale')
  138.             ->leftJoin('a.categories', 'c')
  139.             ->where('a.isActive = true')
  140.             ->andWhere('t.slug is not null')
  141.             ->andWhere('a.id != :current')
  142.             ->orderBy('a.datePublication', 'DESC')
  143.             ->setParameter(':locale', $request->getLocale() )
  144.             ->setParameter(':current', $article->getId())
  145.         ;
  147.     //    $orStatements = $articles_query->expr()->orX();
  148.         $orX = $articles_query->expr()->orX();
  152.         foreach($article->getCategories() as $c){
  153.           $conditions[] =  $articles_query->expr()->literal($c->getId());
  154.         }
  156.         $articles = [];
  158.         if(!empty($conditions)){
  159.           $articles = $articles_query->andWhere($articles_query->expr()->in('c.id', $conditions))->setMaxResults(3)->getQuery()->getResult();
  160.         }
  161.         if(empty($articles)){
  162.           $articles = $articles_query->setMaxResults(3)->getQuery()->getResult();
  163.         }
  164.         return $this->render('blog/show.html.twig', [
  165.             'article' => $article,
  166.             'articles' => $articles
  167.         ]);
  168.     }
  170.     public function lastArticles(Request $request, EntityManagerInterface $em): Response
  171.     {
  172.         $lastArticles = $em->createQueryBuilder()
  173.             ->select('b')
  174.             ->from(BlogArticle::class, 'b')
  175.             ->join('b.translations', 't', 'WITH', 't.locale = :locale AND t.slug IS NOT NULL')
  176.             ->setParameter(':locale', $request->getLocale() )
  177.             ->orderBy('b.datePublication', 'DESC')
  178.             ->setMaxResults(5)
  179.             ->getQuery()
  180.             ->getResult()
  181.         ;
  183.         return $this->render('blog/includes/last_articles.html.twig', [
  184.             'articles' => $lastArticles,
  185.         ]);
  186.     }
  188.     public function categories(Request $request, EntityManagerInterface $em): Response
  189.     {
  190.         $categories = $em->createQueryBuilder()
  191.             ->select('b')
  192.             ->from(BlogCategorieTranslation::class, 'b')
  193.             ->leftJoin('b.translatable', 'bc')
  194.             ->where('b.locale LIKE :locale')
  195.             ->andWhere('bc.categoryParent is null')
  196.             ->setParameter(':locale', $request->getLocale())
  197.             ->orderBy('b.nom', 'ASC')
  198.             ->getQuery()
  199.             ->getResult()
  200.         ;
  202.         return $this->render('blog/includes/categories.html.twig', [
  203.             'categories' => $categories,
  204.         ]);
  205.     }
  207.     public function last3Articles(Request $request, EntityManagerInterface $em): Response
  208.     {
  209.         $lastArticles = $em->createQueryBuilder()
  210.             ->select('b')
  211.             ->from(BlogArticle::class, 'b')
  212.             ->join('b.translations', 't', 'WITH', 't.locale = :locale AND t.slug IS NOT NULL')
  213.             ->setParameter(':locale', $request->getLocale() )
  214.             ->orderBy('b.datePublication', 'DESC')
  215.             ->setMaxResults(3)
  216.             ->getQuery()
  217.             ->getResult()
  218.         ;
  220.         return $this->render('includes/blog.html.twig', [
  221.             'articles' => $lastArticles,
  222.         ]);
  223.     }
  227.     #[Route('/blog-update-image', name: 'blog-update-image')]
  228.     public function updateImageAction(Request $request){
  229.           //$projet_id = $request->getSession()->get('projet');
  230.           $time = time();
  231.           $date = new \Datetime();
  233.           $year = $date->format('Y');
  234.           $months = $date->format('m');
  236.           $path = $this->getParameter('app.public')."wp-content/uploads/".$time."_".$_FILES['upload']['name'];
  237.           $folder = $this->getParameter('app.public')."wp-content/uploads/";
  240.           $url = "/wp-content/uploads/".$time."_".$_FILES['upload']['name'];
  243.           if (!file_exists($folder)) {
  244.               mkdir($folder, 0777, true);
  245.           }
  247.           $psd_type = array(
  248.               0 => 'image/psd',
  249.               1 => 'image/x-photoshop',
  250.               2 => 'application/photoshop',
  251.               3 => 'zz-application/zz-winassoc-psd',
  252.               4 => 'application/psd',
  253.               5 => 'image/vnd.adobe.photoshop'
  254.           );
  256.           $move = false;
  258.           if (($_FILES['upload'] == "none") OR (empty($_FILES['upload']['name'])) )
  259.           {
  260.              $message = "No file uploaded.";
  261.           }
  262.           else if ($_FILES['upload']["size"] == 0)
  263.           {
  264.              $message = "The file is of zero length.";
  265.           }
  266.           else if (($_FILES['upload']["type"] != "image/pjpeg") AND ($_FILES['upload']["type"] != "image/jpeg") AND ($_FILES['upload']["type"] != "image/png") /*AND !(in_array($_FILES['upload']["type"], $psd_type))*/)
  267.           {
  268.              $message = "The image must be in either JPG or PNG format. Please upload a JPG or PNG instead.";
  269.           }
  270.           else if (!is_uploaded_file($_FILES['upload']["tmp_name"]))
  271.           {
  272.              $message = "You may be attempting to hack our server. We're on to you; expect a knock on the door sometime soon.";
  273.           }
  274.           else {
  275.             $message = "";
  276.             $move = @ move_uploaded_file($_FILES['upload']['tmp_name'], $path);
  277.             if(!$move)
  278.             {
  279.                $message = "Error moving uploaded file. Check the script is granted Read/Write/Modify permissions.";
  280.             }
  281.             $url = $url;
  283.           }
  285.           if($move){
  286.                return new JsonResponse((array("uploaded" =>1, "fileName" => $_FILES['upload']['tmp_name'], 'url' => $url, 'width' => '100%', 'height' => '100%')));
  288.           }else{
  289.                return new JsonResponse(array("uploaded" =>0, "error" => array('message' => $message)));
  291.           }
  292.   }
  293. }