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

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. }