Newer
Older
activity-manager / src / Form / Activity / ActivityFilterForm.php
<?php
namespace App\Form\Activity;

use App\Entity\ActivityEntity;
use App\Entity\ActorEntity;
use App\Enum\StatusEnum;
use App\Form\AbstractFormManager;
use Symfony\Bridge\Doctrine\Form\Type\EntityType;
use Symfony\Component\Form\FormBuilderInterface;
use Symfony\Component\Form\Extension\Core\Type\SubmitType;
use App\Repository\ActivityRepository;
use Doctrine\ORM\Query;
use Doctrine\ORM\Query\Expr\Join;
use Doctrine\Common\Collections\Criteria;
use Symfony\Component\Form\Extension\Core\Type\CheckboxType;
use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
use Symfony\Component\Form\Extension\Core\Type\DateType;
use Symfony\Component\Form\Extension\Core\Type\ResetType;

class ActivityFilterForm extends AbstractFormManager
{

    /** @var array List of actors */
    protected $actors = [];

    /**
     * {@inheritdoc}
     */
    public function __construct(FormBuilderInterface $formBuilder, array $data = [], bool $usesToken = true)
    {
        $this->actors = $data['actors'];
        $formBuilder->setData([
            'actor' => null,
            'unassigned' => false,
            'followed' => false,

            'status' => null,
            'active' => false,
            'notClosed' => true,

            'endAfter' => null,
            'startBefore' => null,
        ]);
        parent::__construct($formBuilder, $data, $usesToken);
    }

    /**
     * Create query builder
     *
     * @param ActivityRepository $activityRepository
     * @return array
     */
    public function getActivities(ActivityRepository $activityRepository): array
    {
        $data = $this->getData();

        // Create query
        $query = $activityRepository->createQueryBuilder('activity');

        // Create filter
        $criteria = new Criteria();

        // Filter actors
        if ($data['followed']) {
            $query->join(ActorEntity::class, 'actor', Join::WITH, 'activity.actor = actor');
            $criteria->andWhere($criteria->expr()
                ->eq('actor.followed', true));
        }
        if (!is_null($data['actor'])) {
            $criteria->andWhere($criteria->expr()
                ->eq('activity.actor', $data['actor']));
        }
        if ($data['unassigned']) {
            $criteria->andWhere($criteria->expr()
                ->isNull('activity.actor'));
        }

        // Filter status
        if (!is_null($data['status'])) {
            $criteria->andWhere($criteria->expr()
                ->eq('activity.status', $data['status']));
        }
        if ($data['active']) {
            $criteria->andWhere($criteria->expr()
                ->in('activity.status', StatusEnum::ACTIVE_STATUS));
        }
        if ($data['notClosed']) {
            $criteria->andWhere($criteria->expr()
                ->neq('activity.status', StatusEnum::CLOSED));
        }

        // Filter dates
        if (!is_null($data['endAfter'])) {
            $criteria->andWhere($criteria->expr()
                ->orX($criteria->expr()
                ->isNull('activity.realEndDate'), $criteria->expr()
                ->gt('activity.realEndDate', $data['endAfter'])));
        }
        if (!is_null($data['startBefore'])) {
            $criteria->andWhere($criteria->expr()
                ->orX($criteria->expr()
                ->isNull('activity.realStartDate'), $criteria->expr()
                ->lt('activity.realStartDate', $data['startBefore'])));
        }

        $query->addCriteria($criteria);

        return $query->getQuery()->execute([], Query::HYDRATE_OBJECT);
    }

    /**
     * {@inheritdoc}
     */
    public function getTemplate(): string
    {
        return '_includes/html/form/activity/filter.html.twig';
    }

    /**
     * {@inheritdoc}
     */
    protected function addFields($formBuilder, $options): void
    {
        // Actor filters
        $formBuilder->add('actor', EntityType::class, [
            'class' => ActorEntity::class,
            'choices' => $this->actors,
            'group_by' => function (ActorEntity $choice) {
                if ($choice->getFollowed()) {
                    return 'Suivi';
                }
                if ($choice->getActive()) {
                    return 'Actif';
                }

                return 'Inactif';
            },
            'choice_label' => 'displayName',
            'required' => false,
        ])
            ->add('unassigned', CheckboxType::class, [
            'required' => false,
        ])
            ->add('followed', CheckboxType::class, [
            'required' => false,
        ]);

        // Status filters
        $formBuilder->add('status', ChoiceType::class, [
            'required' => false,
            'choices' => ActivityEntity::VALID_STATUS,
            'choice_label' => function ($choice, $key, $value) {
                return StatusEnum::STATUS_NAME[$choice];
            },
        ])
            ->add('active', CheckboxType::class, [
            'required' => false,
        ])
            ->add('notClosed', CheckboxType::class, [
            'required' => false,
        ]);

        // Date filters
        $formBuilder->add('endAfter', DateType::class, [
            'required' => false,
            'widget' => 'single_text',
        ])->add('startBefore', DateType::class, [
            'required' => false,
            'widget' => 'single_text',
        ]);

        // Submit
        $formBuilder->add('submit', SubmitType::class)->add('reset', ResetType::class);
    }
}