src/Controller/Frontend/ListPublikasiController.php line 52

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Frontend;
  5. use App\Controller\Base\BaseController;
  6. use App\Entity\TInfografik;
  7. use App\Filter\TInfografikFilterType;
  8. use App\Repository\MKategoriDetailRepository;
  9. use App\Repository\MUrusanDetailRepository;
  10. use App\Repository\TDokumenRepository;
  11. use Knp\Component\Pager\PaginatorInterface;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\HttpFoundation\Response;
  14. use Symfony\Component\Routing\Annotation\Route;
  15. use Sonata\SeoBundle\Seo\SeoPageInterface;
  18. class ListPublikasiController extends BaseController
  19. {
  20.     /**
  21.      * @Route("/list-publikasi", name="list-publikasi")
  22.      */
  24.     public function index(SeoPageInterface $seoPage, TDokumenRepository $tDokumenRepo, MKategoriDetailRepository $mKategoriDetailRepo, MUrusanDetailRepository $mUrusanDetailRepository,
  25.     PaginatorInterface $paginatorInterface, Request $request): Response
  26.     {
  27.         $seoPage->addTitlePrefix("Daftar Rilis Publikasi");
  28.         
  29.         // Set tahun yang diinginkan
  30.         $year = 2023;
  31.         $startDate = new \DateTime("$year-01-01");
  32.         $endDate = new \DateTime(($year + 1) . "-01-01");
  34.         $queryBuilder = $this->getQueryBuilder(TInfografik::class)
  35.             ->andWhere("this.is_arsip = false")
  36.             ->andWhere("lower(this.judul) LIKE lower(:judul)")
  37.             ->andWhere("this.release_date >= :startDate")
  38.             ->andWhere("this.release_date < :endDate")
  39.             ->setParameter('judul', '%' . $request->get('judul', '') . '%')
  40.             ->setParameter('startDate', $startDate)
  41.             ->setParameter('endDate', $endDate)
  42.             ->addOrderBy('this.release_date', 'desc');
  44.         $pagination = $paginatorInterface->paginate($queryBuilder, $request->query->getInt('page', 1), 10);
  46.         $filter = TInfografikFilterType::class;
  47.         $classInfo =  TInfografik::class;
  48.         $form = $this->get('form.factory')->create($filter, $this->getFilters($filter));
  49.         $queryBuilder = $this->getQueryBuilder($classInfo);
  50.         $queryBuilder = $this->buildFilter($request, $form, $queryBuilder)->addOrderBy("this.id", "DESC");
  52.         dump($pagination);
  53.         return $this->render('frontend/list_publikasi/index.html.twig', [
  54.             'pagination' => $pagination,
  55.             'search' => array('judul'=>$request->get('judul', '')),
  56.             'page_name' => 'list_publikasi',
  57.             'filter' => $form->createView(),
  58.         ]);
  59.     }
  60. }