<?php
    namespace App\Repository\Filters;
    
    use Doctrine\ORM\Mapping\ClassMetaData;
    use Doctrine\ORM\Query\Filter\SQLFilter;

    class DeletedFilter extends SQLFilter
    {
        public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
        {
            if ($targetEntity->hasField("deletedOn")) {
                $date = date("Y-m-d h:m:s");
                return $targetTableAlias." . deleted_on < '" . $date . "' OR " . $targetTableAlias.".deleted_on IS NULL";
            }
            return "";
        }
    }