src/Controller/CommentController.php line 67

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 Doctrine\ORM\Tools\Pagination\Paginator;
  13. use Symfony\Component\HttpFoundation\Request;
  14. use App\Service\Paginator as ServicePaginator;
  15. use Symfony\Component\HttpFoundation\Response;
  16. use Symfony\Component\Routing\Annotation\Route;
  18. class CommentController extends AbstractASController
  19. {
  20.     public function __construct(
  21.         private EntityManagerInterface $em, 
  22.         private AppDTO $app, 
  23.         private CommentRepository $Comments,
  24.         private UserRepository $Users,
  25.     )
  26.     {        
  27.     }
  28.     
  29.     #[Route('/comments/add', name: 'comments_add_no_locale', defaults: ['_locale' => '%app.default_lang%'])]
  30.     #[Route('/{_locale}/comments/add', name: 'comments_add',  requirements: ['_locale' => '%app.langs%'])]
  31.     public function addComment(Request $request): Response
  32.     {
  33.         /** @var App\Entity\User $User */
  34.         $User = $this->getUser();
  36.         $type = $request->get("type");
  37.         $par = (int) $request->get('par');
  38.         $user = $User ? $User->getId() : 0;
  39.         $author = $request->get('author') ?? $User->getName();
  40.         $theme = (string) $request->get('theme');
  41.         $cont = (string) $request->get('cont');
  42.         
  43.         $Comment = new Comment();
  44.         $Comment->setType($type);
  45.         $Comment->setPar($par);
  46.         $Comment->setUser($user);
  47.         $Comment->setAuthor($author);
  48.         $Comment->setTheme($theme);
  49.         $Comment->setTstamp(time());
  50.         $Comment->setCont($cont);
  51.         $Comment->setAnswer('');
  52.         $Comment->setLang($request->getLocale());
  53.         $Comment->setVisible(0);
  54.         $this->em->persist($Comment);
  55.         $this->em->flush();
  57.         $msg = $this->app->labels->get('comments-mail-1');
  58.         $subj = $this->app->labels->get('comments-mail-2');
  59.             
  60.         // Func::mailhtml($sett['sitename'], Env::mail_from(), $sett['admin_email'], $subj, $msg);
  61.         $result = ["status" => "ok"];
  62.         return $this->json($result);
  63.     }
  65.     #[Route('/comments', name: 'comments_no_locale', defaults: ['_locale' => '%app.default_lang%'])]
  66.     #[Route('/{_locale}/comments', name: 'comments',  requirements: ['_locale' => '%app.langs%'])]
  67.     public function index(Request $request): Response
  68.     {
  69.         $results = 50;
  70.         $start = (int) $request->query->get('start');
  71.         $this->em->getClassMetadata(User::class)->setPrimaryTable(['name' => 'user']);
  72.         
  73.         $dql = "SELECT c FROM App\Entity\Comment c WHERE c.visible = 1 ORDER BY c.tstamp DESC";
  74.         $query = $this->em->createQuery($dql)
  75.                        ->setFirstResult($start)
  76.                        ->setMaxResults($results);
  78.         $comments = new Paginator($query);
  79.         $cnt = count($comments);
  80.         
  81.         foreach($comments as $k => $comment) {
  82.             $dql = "SELECT count(o) FROM App\Entity\Order o WHERE o.user = ".$comment->getUser()." and ".time()."-o.tstamp < 60*60*24*365";
  83.             // if (empty($comment->getAuthor())) {
  84.                 $user = $this->Users->find($comment->getUser());
  85.                 if ($user) {
  86.                     $comment->setAuthor($user->getName()." ".mb_strtoupper(mb_substr($user->getSurname(), 0, 1)).".");
  87.                 }                
  88.             // }
  89.             
  90.             $comment->orders_count = array_pop(($this->em->createQuery($dql)->getResult())[0]);
  91.         }
  92.         
  93.         $response = $this->render('comment/list.html.twig', [
  94.             'comments' => $comments,
  95.             'paginator' => new ServicePaginator('comments', $cnt, $results, $start),
  96.         ]);
  98.         $response = Cache::http($response, $this->getParameter('app.http_cache_time'));
  100.         return $response;
  101.     }
  102. }