src/Form/Channel/Filter/ChannelTrainingFilter.php line 51

Open in your IDE?
  1. <?php
  3. /*
  4.  * This file is part of the nellapp package.
  5.  *
  6.  * (c) Benjamin Georgeault <https://www.drosalys-web.fr/>
  7.  *
  8.  * For the full copyright and license information, please view the LICENSE
  9.  * file that was distributed with this source code.
  10.  */
  12. namespace App\Form\Channel\Filter;
  14. use App\Entity\Account\Advice;
  15. use Spiriit\Bundle\FormFilterBundle\Filter\Doctrine\ORMQuery;
  16. use Spiriit\Bundle\FormFilterBundle\Filter\Form\Type\ChoiceFilterType;
  17. use Spiriit\Bundle\FormFilterBundle\Filter\Form\Type\TextFilterType;
  18. use Symfony\Component\Form\AbstractType;
  19. use Symfony\Component\Form\FormBuilderInterface;
  20. use Symfony\Component\OptionsResolver\OptionsResolver;
  22. /**
  23.  * Class ChannelFilter
  24.  *
  25.  * @author Benjamin Georgeault
  26.  */
  27. class ChannelTrainingFilter extends AbstractType
  28. {
  29.     public function buildForm(FormBuilderInterface $builder, array $options): void
  30.     {
  31.         $builder
  32.             ->add('order', ChoiceFilterType::class, [
  33.                 'label' => false,
  34.                 'required' => true,
  35.                 'choices' => [
  36.                     'Trier par' => null,
  37.                     'Les plus récentes' => 'newest',
  38.                     'Les plus anciennes' => 'oldest',
  39.                     'Les plus populaires' => 'most-popular',
  40.                 ],
  41.                 'attr' => [
  42.                     'class' => 'select-order-channel-trainings',
  43.                 ],
  44.                 'choice_attr' => function($key, $val, $index) {
  45.                     if ($key === null) {
  46.                         return ['disabled' => 'disabled', 'hidden' => 'hidden'];
  47.                     }
  49.                     return [];
  50.                 },
  51.                 'apply_filter' => function (ORMQuery $filterQuery, $field, $values) {
  52.                     if (empty($values['value'])) {
  53.                         return null;
  54.                     }
  56.                     if ($values['value'] === 'newest') {
  57.                         return $filterQuery->getQueryBuilder()->orderBy($filterQuery->getRootAlias().'.createdAt', 'DESC');
  58.                     } elseif ($values['value'] === 'oldest') {
  59.                         return $filterQuery->getQueryBuilder()->orderBy($filterQuery->getRootAlias().'.createdAt', 'ASC');
  60.                     } elseif ($values['value'] === 'most-popular') {
  61.                         return $filterQuery->getQueryBuilder()
  62.                             ->addSelect('avg(a.note) AS HIDDEN avgmark')
  63.                             ->leftJoin(Advice::class, 'a', 'WITH', $filterQuery->getRootAlias() . ' = a.training')
  64.                             ->groupBy($filterQuery->getRootAlias() . '.id')
  65.                             ->orderBy('avgmark', 'DESC')
  66.                             ->addOrderBy($filterQuery->getRootAlias() . '.createdAt', 'DESC');
  67.                     }
  69.                     return null;
  70.                 },
  71.             ])
  72.             ->add('search', TextFilterType::class, [
  73.                 'label' => false,
  74.                 'required' => false,
  75.                 'attr' => [
  76.                     'placeholder' => 'Rechercher une formation',
  77.                     'autocomplete' => 'off',
  78.                 ],
  79.                 'apply_filter' => function (ORMQuery $filterQuery, $field, $values) {
  80.                     return null;
  81.                 },
  82.             ])
  83.         ;
  84.     }
  86.     public function configureOptions(OptionsResolver $resolver): void
  87.     {
  88.         $resolver->setDefaults([
  89.             'method' => 'GET',
  90.             'csrf_protection' => false,
  91.             'validation_groups' => [
  92.                 'filtering',
  93.             ],
  94.         ]);
  95.     }
  97.     public function getBlockPrefix(): string
  98.     {
  99.         return 'channel_channel_training_filter';
  100.     }
  101. }