src/Controller/CommentController.php line 79

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\DTO\AppDTO;
  6. use App\Entity\User;
  7. use App\Entity\Comment;
  8. use App\Service\Cache\Cache;
  9. use App\Repository\UserRepository;
  10. use App\Repository\CommentRepository;
  11. use Doctrine\ORM\EntityManagerInterface;
  12. use Symfony\Contracts\Cache\CacheInterface;
  13. use Doctrine\ORM\Tools\Pagination\Paginator;
  14. use Symfony\Component\HttpFoundation\Request;
  15. use App\Service\Paginator as ServicePaginator;
  16. use Symfony\Component\HttpFoundation\Response;
  17. use Symfony\Component\Routing\Annotation\Route;
  18. use Symfony\Component\HttpFoundation\RequestStack;
  19. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  21. class CommentController extends AbstractASController
  22. {
  23.     protected EntityManagerInterface $em;
  24.     protected CacheInterface $Cache;
  25.     protected AppDTO $app;
  27.     //Repositories
  28.     protected CommentRepository $Comments;
  29.     protected UserRepository $Users;
  31.     public function __construct(EntityManagerInterface $em, CacheInterface $Cache, AppDTO $app, RequestStack $requestStack)
  32.     {
  33.         $this->requestStack = $requestStack;
  34.         $this->Cache = $Cache;
  35.         $this->em = $em;
  36.         $this->app = $app;
  37.         $this->Comments = $em->getRepository(Comment::class);
  38.         $this->Users = $em->getRepository(User::class);
  39.     }
  40.     
  41.     #[Route('/comments/add', name: 'comments_add_no_locale', defaults: ['_locale' => '%app.default_lang%'])]
  42.     #[Route('/{_locale}/comments/add', name: 'comments_add',  requirements: ['_locale' => '%app.langs%'])]
  43.     public function addComment(Request $request): Response
  44.     {
  45.         /** @var App\Entity\User $User */
  46.         $User = $this->getUser();
  48.         $type = $request->get("type");
  49.         $par = (int) $request->get('par');
  50.         $user = $User ? $User->getId() : 0;
  51.         $author = $request->get('author') ?? $User->getName();
  52.         $theme = (string) $request->get('theme');
  53.         $cont = (string) $request->get('cont');
  54.         
  55.         $Comment = new Comment();
  56.         $Comment->setType($type);
  57.         $Comment->setPar($par);
  58.         $Comment->setUser($user);
  59.         $Comment->setAuthor($author);
  60.         $Comment->setTheme($theme);
  61.         $Comment->setTstamp(time());
  62.         $Comment->setCont($cont);
  63.         $Comment->setAnswer('');
  64.         $Comment->setLang($request->getLocale());
  65.         $Comment->setVisible(0);
  66.         $this->em->persist($Comment);
  67.         $this->em->flush();
  69.         $msg = $this->app->labels->get('comments-mail-1');
  70.         $subj = $this->app->labels->get('comments-mail-2');
  71.             
  72.         // Func::mailhtml($sett['sitename'], Env::mail_from(), $sett['admin_email'], $subj, $msg);
  73.         $result = ["status" => "ok"];
  74.         return $this->json($result);
  75.     }
  77.     #[Route('/comments', name: 'comments_no_locale', defaults: ['_locale' => '%app.default_lang%'])]
  78.     #[Route('/{_locale}/comments', name: 'comments',  requirements: ['_locale' => '%app.langs%'])]
  79.     public function index(Request $request): Response
  80.     {
  81.         $results = 50;
  82.         $start = (int) $request->query->get('start');
  84.         $dql = "SELECT c FROM App\Entity\Comment c WHERE c.visible = 1 ORDER BY c.tstamp DESC";
  85.         $query = $this->em->createQuery($dql)
  86.                        ->setFirstResult($start)
  87.                        ->setMaxResults($results);
  89.         $comments = new Paginator($query);
  90.         $cnt = count($comments);
  92.         foreach($comments as $comment) {            
  93.             $dql = "SELECT count(o) FROM App\Entity\Order o WHERE o.user = ".$comment->getUser()." and ".time()."-o.tstamp < 60*60*24*365";
  94.             if (empty($comment->author)) {
  95.                 $user = $this->Users->find($comment->getUser());
  96.                 if ($user) {
  97.                     $comment->setAuthor($user->getName()." ".$user->getSurname());
  98.                 }                
  99.             }
  100.             
  101.             $comment->orders_count = array_pop(($this->em->createQuery($dql)->getResult())[0]);
  102.         }
  104.         $response = $this->render('comment/list.html.twig', [
  105.             'comments' => $comments,
  106.             'paginator' => new ServicePaginator('comments', $cnt, $results, $start),
  107.         ]);
  109.         $response = Cache::http($response, $this->getParameter('app.http_cache_time'));
  111.         return $response;
  112.     }
  113. }