Symfony Profiler

<?php
namespace App\Controller;
use App\Entity\News;
use App\Entity\VisitorCount;
use App\Repository\NewsRepository;
use App\Repository\TutoRepository;
use App\Repository\JurisprudenceRepository;
use App\Repository\VisitorCountRepository;
use Doctrine\ORM\EntityManagerInterface;
use Knp\Component\Pager\Paginator;
use Knp\Component\Pager\PaginatorInterface;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Routing\Annotation\Route;
class HomepageController extends AbstractController
{
private JurisprudenceRepository $jurisprudenceRepository;
private NewsRepository $newsRepository;
private TutoRepository $tutoRepository;
private VisitorCountRepository $visitorCountRepository;
private EntityManagerInterface $entityManager;
public function __construct(
JurisprudenceRepository $jurisprudenceRepository,
NewsRepository $newsRepository,
TutoRepository $tutoRepository,
VisitorCountRepository $visitorCountRepository,
EntityManagerInterface $entityManager
) {
$this->jurisprudenceRepository = $jurisprudenceRepository;
$this->newsRepository = $newsRepository;
$this->tutoRepository = $tutoRepository;
$this->visitorCountRepository = $visitorCountRepository;
$this->entityManager = $entityManager;
}
/**
* @Route("/", name="default")
*/
public function default(): Response
{
return $this->redirectToRoute('homepage');
}
/**
* @Route("/accueil", name="homepage")
*/
public function index(Request $request, PaginatorInterface $paginator): Response
{
// Stats total
$totalCount = $this->visitorCountRepository->findOneBy(['type' => VisitorCount::TOTAL_VISITORS_TYPE]);
if ($totalCount) {
$totalCount->setCounter($totalCount->getCounter() + 1);
} else {
$totalCount = new VisitorCount();
$totalCount->setType(VisitorCount::TOTAL_VISITORS_TYPE);
$totalCount->setCounter(1);
$this->entityManager->persist($totalCount);
}
$this->entityManager->flush();
$data = [];
$category = $request->query->get('categorie');
//Get news
if (null === $category || 'infos' === $category ) {
$news = $this->newsRepository->findBy(['active' => true]);
/** @var News $new */
foreach ($news as $new) {
if ($new->getChapo() != null) {
$content = $this->cleanContent($new->getChapo());
} else {
$content = $this->cleanContent($new->getContent());
}
$data[] = [
'title' => $new->getTitle(),
'date' => $new->getCreatedAt(),
'timestamp' => $new->getCreatedAt()->getTimestamp(),
'content' => $content,
'type' => 'news',
'id' => $new->getId(),
'pinned' => $new->getPinned()
];
}
}
// Get tutos
if(null === $category || 'tutos' === $category) {
$tutos = $this->tutoRepository->findBy(['active' => true]);
/** @var Tuto $tuto */
foreach ($tutos as $tuto) {
if ($tuto->getChapo() != null) {
$content = $this->cleanContent($tuto->getChapo());
} else {
$content = $this->cleanContent($tuto->getContent());
}
$data[] = [
'title' => $tuto->getTitle(),
'date' => $tuto->getCreatedAt(),
'timestamp' => $tuto->getCreatedAt()->getTimestamp(),
'content' => $content,
'type' => 'tuto',
'id' => $tuto->getId(),
'pinned' => $tuto->getPinned()
];
}
}
// Get jp
if(null === $category || 'jurisprudences' === $category) {
$jurisprudences = $this->jurisprudenceRepository->findBy(['active' => true]);
/** @var Jurisprudence $jurisprudence */
foreach ($jurisprudences as $jurisprudence) {
if ($jurisprudence->getChapo() != null) {
$content = $this->cleanContent($jurisprudence->getChapo());
} else {
$content = $this->cleanContent($jurisprudence->getContent());
}
$data[] = [
'title' => $jurisprudence->getName(),
'date' => $jurisprudence->getCreatedAt(),
'timestamp' => $jurisprudence->getCreatedAt()->getTimestamp(),
'content' => $content,
'type' => 'jurisprudence',
'id' => $jurisprudence->getId(),
'pinned' => $jurisprudence->getPinned()
];
}
}
//krsort($data);
//array_multisort(array_column($data, 'pinned'), SORT_DESC, $data);
array_multisort(
array_column($data, 'pinned'), SORT_DESC,
array_column($data, 'timestamp'), SORT_DESC,
$data
);
$pagination = $paginator->paginate($data, $request->query->get('page', 1), 6);
return $this->render('homepage/homepage_default.html.twig', [
'controller_name' => 'HomepageController',
'active_menu' => 'homepage',
'dataContent' => $pagination,
'categoryRequest' => $category,
//'search' => $search
]);
}
private function cleanContent(string $content)
{
$contentClean = strip_tags($content);
//$contentClean = str_replace("<br>", " ", $contentClean);
$contentClean = str_replace("’", "'", $contentClean);
$contentClean = str_replace("'", "'", $contentClean);
return $contentClean;
}
}

src/Controller/HomepageController.php line 53