<?php

/**
 * @link https://www.humhub.org/
 * @copyright Copyright (c) 2017 HumHub GmbH & Co. KG
 * @license https://www.humhub.com/licences
 *
 */

namespace humhub\modules\calendar\interfaces\event;

use DateInterval;
use DateTime;
use Exception;
use humhub\modules\calendar\helpers\CalendarUtils;
use humhub\modules\calendar\models\CalendarEntry;
use humhub\modules\content\components\ContentContainerActiveRecord;
use humhub\modules\user\models\User;
use humhub\modules\content\components\ActiveQueryContent;
use Yii;
use yii\base\Component;
use yii\db\ActiveQuery;
use yii\db\ActiveRecord;
use yii\db\Query;

/**
 * Created by PhpStorm.
 * User: buddha
 * Date: 14.09.2017
 * Time: 12:31
 *
 */
abstract class AbstractCalendarQuery extends Component
{
    /**
     * Available filters
     */
    public const FILTER_PARTICIPATE = 1;

    /**
     * @deprecated This is a legacy filter which is not active anymore
     */
    public const FILTER_NOT_RESPONDED = 3;

    /**
     * @deprecated This is a legacy filter which is not active anymore
     */
    public const FILTER_RESPONDED = 4;
    public const FILTER_MINE = 5;
    public const FILTER_DASHBOARD = 6;
    public const FILTER_USERRELATED = 'userRelated';

    /**
     * If this filter is set, non readable entries will be included
     */
    public const FILTER_INCLUDE_NONREADABLE = 'includeNonReadable';
    public const FILTER_INCLUDE_ARCHIVED = 'includeArchived';

    public const DATE_QUERY_TYPE_TIME = 0;
    public const DATE_QUERY_TYPE_DATE = 1;
    public const DATE_QUERY_TYPE_MIXED = 2;

    /**
     * @var string Defines the ActiveRecord class used for this query
     */
    protected static $recordClass;

    /**
     * Defines the way how to handle a timezone differences between user and system.
     * An event type can either contain
     *
     * - only all day events e.g. holiday
     * - only time relevant events e.g. meetings
     * - both types of events
     *
     * All day events should always be saved either in DATE format or in DATETIME format with time 00:00 (no timezone translation)
     *
     * Depending on the type of events the `$dateQueryType` has to be set to one of the following:
     *
     * [[DATE_QUERY_TYPE_TIME]] (default) will respect timezone differences between user and system and should only be used for event types
     * with only time relevant events. The default $dateFormat used in the query will be `Y-m-d H:i:s`.
     *
     * [[DATE_QUERY_TYPE_DATE]] will ignore any timezone offset between user and system timezone and should only be used for event
     * types with only all day events. The default $dateFormat used in the query will be `Y-m-d`.
     *
     * [[DATE_QUERY_TYPE_MIXED]] should be used for event types which support both, all day and non all day events. This mode requires
     * the `$allDayField` to be set to an boolean field differentiating between all day and non all day events.
     * The default $dateFormat used in the query will be `Y-m-d H:i:s`.
     *
     * @var int
     * @see $allDayField
     */
    protected $dateQueryType = self::DATE_QUERY_TYPE_TIME;

    /**
     * The name of the all day field, which is only required if [[dateQueryType]] is set to [[DATE_QUERY_TYPE_MIXED]].
     * @var string
     * @see $dateQueryType
     */
    protected $allDayField = 'all_day';

    /**
     * @var string database field for start date
     */
    public $startField = 'start_datetime';

    /**
     * @var string database field for end date
     */
    public $endField = 'end_datetime';

    /**
     * @var string This field has to exist on the record class in order for [[autoAssignUid]] to work.
     * @deprecated since v1.0 won't be used when implementing the new interfaces in v1.0
     */
    protected $uidField = 'uid';

    /**
     * Defines if expanded recurrent instances should be safed after the query.
     * Note: setting this to true may impacts the performance.
     * @var bool
     */
    public $autoSaveRecurrentInstances = false;

    /**
     * @var string database date format
     */
    public $dateFormat;

    /**
     * @var array Activated query filters
     */
    protected $_filters = [];

    /**
     * @var array Activated query types
     */
    protected $_types = [];

    /**
     * @var ActiveQuery the actual query instance
     */
    protected $_query;

    /**
     * @var User user instance used for some of the filters e.g. mine() filter
     */
    protected $_user;

    /**
     * @var DateTime start date of the filter interval
     */
    protected $_from;

    /**
     * @var DateTime end date of the filter interval
     */
    protected $_to;

    /**
     * @var bool flag to enable/disable the openRange behaviour (default true)
     */
    protected $_openRange = true;

    /**
     * @var string query order string
     */
    protected $_orderBy;

    /**
     * @var int query limit
     */
    protected $_limit = 0;

    /**
     * @var \humhub\modules\content\components\ContentContainerActiveRecord used to filter entries by contentContainer
     */
    protected $_container;

    /**
     * @var array user related scopes used for [[userRelated()]] filters
     */
    protected $_userScopes;

    /**
     * @var bool if set to false (default) will ignore time information in date filter intervals
     */
    protected $_withTime = true;

    /**
     * @var bool determines if the query was already built
     */
    protected $_built = false;

    /**
     * @var bool determines if the query logic should try to auto assign a uid for the resulting events
     * @deprecated since v1.0 won't be used when implementing the new interfaces in v1.0
     */
    protected $autoAssignUid = true;

    /**
     * @var bool if set to true, the [[expand()]] function can be used to expand events e.g. recurrences
     */
    protected $expand = true;

    /**
     * @inheritDoc
     */
    public function init()
    {
        parent::init();
        // Make sure the date format is initialized
        $this->getDateFormat();
    }

    /**
     * @param DateTime $start
     * @param DateTime $end
     * @param ContentContainerActiveRecord $container
     * @param array $filters
     * @param int $limit
     * @param bool $expand
     * @return array|ActiveRecord[]
     * @throws \Throwable
     */
    public static function findForFilter(?DateTime $start = null, ?DateTime $end = null, ?ContentContainerActiveRecord $container = null, $filters = [], $limit = 50, $expand = true, $types = [])
    {
        $query = static::find(null, $expand)
            ->container($container)
            ->filter($filters)
            ->types($types)
            ->limit($limit);

        if ($end) {
            $query->to($end);
        }

        if ($start) {
            $query->withTime();
            $query->from($start);
        }

        $result = $query->all();

        $expandResult = [];

        foreach ($result as $entry) {
            static::autoAssignUid($entry, $query);

            if ($expand) {
                $query->expand($entry, $expandResult);
            }
        }

        return $expand ? $query->preFilter($expandResult) : $result;
    }

    /**
     * @param $entry ActiveRecord
     * @param $query static
     */
    private static function autoAssignUid($entry, $query)
    {
        if ($entry instanceof EditableEventIF && empty($entry->getUid())) {
            $entry->setUid(CalendarUtils::generateEventUid($entry));
            $entry->saveEvent();
            return;
        }

        // LEGACY MODELS ONLY
        if (!($entry instanceof CalendarEntry) && $query->autoAssignUid && $entry->hasProperty($query->uidField)
            && empty($entry->{$query->uidField})) {
            $entry->updateAttributes([$query->uidField => CalendarUtils::generateUUid()]);
        }

    }

    /**
     * This function can be used for subclasses to expand e.g. recurrent events by adding all expanded events to the
     * endResult array.
     *
     * > Note: currently there is no defaul timplementation/helper for recurring events
     * > Note: the $endResult array does not contain the given $entry.
     *
     * @param $entry
     * @param $endResult
     * @throws Exception
     */
    protected function expand($entry, &$expandResult)
    {
        $expandResult[] = $entry;
    }

    /**
     * @param CalendarItemsEvent $event
     * @return array|ActiveRecord[]
     * @throws \Throwable
     */
    public static function findForEvent(CalendarItemsEvent $event)
    {
        return static::findForFilter($event->start, $event->end, $event->contentContainer, $event->filters, $event->limit, $event->expand);
    }


    /**
     * Static initializer.
     * @param User $user user instance used for some of the filter e.g. [[mine()]] by default current logged in user.
     * @param bool $xpand
     * @return \self
     * @throws \Throwable
     */
    public static function find(?User $user = null, bool $expand = true)
    {
        if (!$user && !Yii::$app->user->isGuest) {
            $user = Yii::$app->user->getIdentity();
        }

        $instance = new static();
        $instance->expand = $expand;
        $instance->_query = static::createQuery();
        $instance->_user = $user;

        return $instance;
    }

    /**
     * Static initializer.
     * @return ActiveQuery
     */
    protected static function createQuery()
    {
        return call_user_func(static::$recordClass . '::find');
    }

    /**
     * Filters user related entries by means of the given scope as.
     * If no scope is given this method will fitler entries with the following scope:
     *
     *  - ActiveQueryContent::USER_RELATED_SCOPE_OWN_PROFILE
     *  - ActiveQueryContent::USER_RELATED_SCOPE_SPACES
     *
     * @param int|array $scopes user related filter scopes
     * @return $this
     * @see ActiveQueryContent::userRelated()
     */
    public function userRelated($scopes = [ActiveQueryContent::USER_RELATED_SCOPE_OWN_PROFILE, ActiveQueryContent::USER_RELATED_SCOPE_SPACES])
    {
        if (!empty($scopes)) {
            $scopes = (is_array($scopes)) ? $scopes : [$scopes];
            $this->_userScopes = $scopes;
        }

        return $this;
    }

    /**
     * Used to respect time settings of [[from()]] and [[to()]] filters.
     * Note: This method has to be called before the [[from()]] and [[to()]] or any other
     * date interval filter in order to affect the query.
     *
     * @param bool $withTime
     * @return $this
     */
    public function withTime($withTime = true)
    {
        $this->_withTime = $withTime;
        return $this;
    }

    /**
     * Sets the filter array.
     *
     * @param array $filters
     * @return $this
     */
    public function filter($filters = [])
    {
        $this->_filters = $filters;
        return $this;
    }

    /**
     * Sets the types array.
     *
     * @param array $types
     * @return $this
     */
    public function types($types = [])
    {
        $this->_types = $types;
        return $this;
    }

    /**
     * Filters entries the given user has accepted to.
     * @return $this
     */
    public function participate()
    {
        return $this->addFilter(self::FILTER_PARTICIPATE);
    }

    /**
     * Filters entries the given user has responded (Accept/Decline).
     * @return $this
     */
    public function responded()
    {
        return $this->addFilter(self::FILTER_RESPONDED);
    }

    /**
     * Filters entries the given user has not responded yet.
     * @return $this
     */
    public function notResponded()
    {
        return $this->addFilter(self::FILTER_NOT_RESPONDED);
    }

    /**
     * Filters entries of the given user.
     * @return $this
     */
    public function mine()
    {
        return $this->addFilter(self::FILTER_MINE);
    }

    /**
     * Adds a single filter to the query.
     * @param int $filter
     * @return $this
     */
    public function addFilter($filter)
    {
        if (!in_array($filter, $this->_filters)) {
            $this->_filters[] = $filter;
        }

        return $this;
    }

    /**
     * Filter entries of the given [[ContentContainerActiveRecord]].
     * @param ContentContainerActiveRecord $container
     * @return $this
     */
    public function container(?ContentContainerActiveRecord $container = null)
    {
        $this->_container = $container;
        return $this;
    }

    /**
     * Used to deactivate the openRange behaviour, which includes entries if
     * either the start or end date is within the given date filter interval.
     *
     * If this behaviour is deactivated, only entries where the start and end date
     * is within the date filter interval will be included.
     *
     * @param bool $openRange false to deactivate the openRange behaviour else ture (default)
     * @return $this
     */
    public function openRange($openRange = true)
    {
        $this->_openRange = $openRange;
        return $this;
    }

    /**
     * Sets the query order string.
     *
     * By default `start_datetime ASC`
     *
     * @param string $order sql order string
     * @return $this
     */
    public function orderBy($order)
    {
        $this->_orderBy = $order;
        return $this;
    }

    /**
     * Sets the result limit.
     *
     * @param int $limit
     * @return $this
     */
    public function limit($limit)
    {
        $this->_limit = $limit;
        return $this;
    }

    /**
     * Sets the date filter interval end date.
     *
     * Note: If the [[withTime()]] behaviour is deactivated (default) the time of the
     * end date will be set to 23:59:59 by default.
     *
     * This method accepts either an DateTime instance or an int value:
     *
     * ```php
     * // Set the current date as end date
     * CalendarEntryQuery::find()->to();
     *
     * // Set a specific date as end date
     * CalendarEntryQuery::find()->to($someDate);
     *
     * // Set date three days in the future as end date
     * CalendarEntryQuery::find()->to(3)->all();
     *
     * // Set date three days in the past as end date
     * CalendarEntryQuery::find()->to(-3)->all();
     *
     *  // Set date three month in the future as end date
     * CalendarEntryQuery::find()->to(3, 'M')->all();
     * ```
     * The dateUnit added or substracted to the current date if using an int value can
     * be managed by the second $dateUnit parameter.
     *
     * @param int|DateTime $to specifies the actual end date either by an interval (int) or an actual DateTime instance
     * @return $this
     * @throws Exception
     */
    public function to($to = null, $dateUnit = 'D')
    {
        if (!$to) {
            $to = new DateTime();
        }

        if (is_int($to)) {
            if ($to >= 0) {
                $to = (new DateTime())->add(new DateInterval('P' . $to . $dateUnit));
            } else {
                $to = (new DateTime())->sub(new DateInterval('P' . abs($to) . $dateUnit));
            }
        }

        $this->_to = clone $to;

        if (!$this->_withTime) {
            $this->_to->setTime(23, 59, 59);
        }

        return $this;
    }

    /**
     * Sets the date filter interval start date.
     *
     * Note: If the [[withTime()]] behaviour is deactivated (default) the time of the
     * start date will be set to 00:00:00 by default.
     *
     * This method accepts either an DateTime instance or an int value:
     *
     * ```php
     * // Set the current date as start date
     * CalendarEntryQuery::find()->from();
     *
     * // Set a specific date as start date
     * CalendarEntryQuery::find()->from($someDate);
     *
     * // Set date three days in the future as start date
     * CalendarEntryQuery::find()->from(3)->all();
     *
     * // Set date three days in the past as start date
     * CalendarEntryQuery::find()->from(-3)->all();
     *
     *  // Set date three month in the future as start date
     * CalendarEntryQuery::find()->from(3, 'M')->all();
     * ```
     * The dateUnit added or substracted to the current date if using an int value can
     * be managed by the second $dateUnit parameter.
     *
     * @param int|DateTime $to specifies the actual end date either by an interval (int) or an actual DateTime instance
     * @return $this
     * @throws Exception
     */
    public function from($from = null, $dateUnit = 'D')
    {
        if (!$from) {
            $from = new DateTime();
        }

        if (is_int($from)) {
            if ($from >= 0) {
                $from = (new DateTime())->add(new DateInterval('P' . $from . $dateUnit));
            } else {
                $from = (new DateTime())->sub(new DateInterval('P' . abs($from) . $dateUnit));
            }
        }

        $this->_from = clone $from;

        if (!$this->_withTime) {
            $this->_from->setTime(0, 0, 0);
        }

        return $this;
    }

    /**
     * Used to set the date filter interval in days.
     *
     * ```php
     * // Include all entries from $someDate to $someDate + 3 days
     * CalendarEntryQuery::find()->from($someDate)->days(3)->all();
     *
     * // Include all entries from $someDate -3 to $someDate
     * CalendarEntryQuery::find()->to($someDate)->days(-3)->all();
     *
     * // Find all entries from today till 3 days in the future
     * CalendarEntryQuery::find()->days(3)->all();
     *
     * // Find all entries from 3 days in the past until today
     * CalendarEntryQuery::find()->days(-3)->all();
     * ```
     * @param int $days interval either positive or negative
     * @return $this
     * @throws Exception
     * @see interval()
     */
    public function days($days)
    {
        $this->withTime(false);
        return $this->interval($days);
    }

    /**
     * Used to set the date filter interval in months.
     *
     * ```php
     * // Include all entries from $someDate to $someDate + 3 months
     * CalendarEntryQuery::find()->from($someDate)->months(3)->all();
     *
     * // Include all entries from $someDate -3 months to $someDate
     * CalendarEntryQuery::find()->to($someDate)->months(-3)->all();
     *
     * // Find all entries from today till 3 months in the future
     * CalendarEntryQuery::find()->months(3)->all();
     *
     * // Find all entries from 3 months in the past until today
     * CalendarEntryQuery::find()->months(-3)->all();
     * ```
     * @param int $months interval either positive or negative
     * @return $this
     * @throws Exception
     * @see interval()
     */
    public function months($months)
    {
        return $this->interval($months, 'M');
    }

    /**
     * Used to set the date filter interval in years.
     *
     * ```php
     * // Include all entries from $someDate to $someDate + 3 years
     * CalendarEntryQuery::find()->from($someDate)->years(3)->all();
     *
     * // Include all entries from $someDate -3 to $someDate
     * CalendarEntryQuery::find()->to($someDate)->years(-3)->all();
     *
     * // Find all entries from today till 3 years in the future
     * CalendarEntryQuery::find()->years(3)->all();
     *
     * // Find all entries from 3 years in the past until today
     * CalendarEntryQuery::find()->years(-3)->all();
     * ```
     * @param int $years interval either positive or negative
     * @return $this
     * @throws Exception
     * @see interval()
     */
    public function years($years)
    {
        return $this->interval($years, 'Y');
    }

    /**
     * Used to either add the given $interval to the start date (end date = start date + interval)
     * or substract the given $interval  from the end date (start date = end date - interval).
     *
     * @param int $dayRange
     * @param string $dateUnit
     * @return $this
     * @throws Exception
     */
    public function interval($interval, $dateUnit = "D")
    {
        if ($interval >= 0) {
            if (!$this->_from) {
                $this->from(); // set from now
            }

            $to = clone $this->_from;
            $to->add(new DateInterval("P" . $interval . $dateUnit));
            $this->to($to);
            return $this;
        } else {
            if (!$this->_to) {
                $this->_to = new DateTime();
            }

            $from = clone $this->_to;
            $from->sub(new DateInterval("P" . abs($interval) . $dateUnit));
            $this->from($from);
            return $this;
        }
    }


    /**
     * Returns the actual \yii\db\ActiveQuery instance.
     * If $build is set to true, this method will build the filter query before.
     *
     * @param bool $build if ture this method will build the filter query before returning
     * @return ActiveQuery
     */
    public function query($build = false)
    {
        if ($build) {
            $this->setupQuery();
        }

        return $this->_query;
    }

    /**
     * Builds and executes the filter query.
     * This method will filter out entries not readable by the current logged in user.
     * @return ContentContainerActiveRecord[] result
     */
    public function all()
    {
        try {
            if (!$this->_built) {
                $this->setupQuery();
            }

            return $this->preFilter($this->_query->all());
        } catch (FilterNotSupportedException) {
            return [];
        }
    }

    /**
     * Sets up the actual filter query.
     */
    protected function setupQuery()
    {
        $this->setUpRelations();
        $this->setupCriteria();
        $this->setupFilters();
        $this->setupTypes();
        $this->_built = true;
    }

    /**
     * Can be used for eager loading of relations etc
     */
    public function setUpRelations()
    {
        return $this;
    }

    /**
     * Sets up the non _filter array related queries.
     */
    protected function setupCriteria()
    {
        $this->setupDateCriteria();

        if (!$this->_orderBy) {
            $this->_query->orderBy($this->startField . ' ASC');
        } else {
            $this->_query->orderBy($this->_orderBy);
        }

        if ($this->_limit) {
            $this->_query->limit($this->_limit);
        }
    }

    protected function createDateCriteriaQuery(Query $query)
    {
        if ($this->_from) {
            $fromTime = clone $this->_from;
            $fromTime->setTimezone(CalendarUtils::getSystemTimeZone());
        }

        if ($this->_to) {
            $toTime = clone $this->_to->setTimezone(CalendarUtils::getSystemTimeZone());
            $toTime->setTimezone(CalendarUtils::getSystemTimeZone());
        }

        if ($this->_openRange && $this->_from && $this->_to) {
            //Search for all dates with start and/or end within the given range

            if ($this->dateQueryType === static::DATE_QUERY_TYPE_DATE) {
                $query->andFilterWhere(['or',
                    ['and', $this->getStartCriteria($this->_from, '<'), $this->getEndCriteria($this->_to, '>')],
                    ['and', $this->getStartCriteria($this->_from, '>='), $this->getStartCriteria($this->_to, '<')],
                    ['and', $this->getEndCriteria($this->_from, '>'), $this->getEndCriteria($this->_to, '<=')],
                    $this->isRecurrenceRootCondition(),
                ]);
            } elseif ($this->dateQueryType === static::DATE_QUERY_TYPE_TIME) {
                $query->andFilterWhere(['or',
                    ['and', $this->getStartCriteria($fromTime, '<'), $this->getEndCriteria($toTime, '>')],
                    ['and', $this->getStartCriteria($fromTime, '>='), $this->getStartCriteria($toTime, '<')],
                    ['and', $this->getEndCriteria($fromTime, '>'), $this->getEndCriteria($toTime, '<=')],
                    $this->isRecurrenceRootCondition(),
                ]);
            } elseif ($this->dateQueryType === static::DATE_QUERY_TYPE_MIXED) {
                $query->andFilterWhere(
                    ['or',
                        ['or',
                            ['and',
                                [$this->allDayField => 0],
                                ['or',
                                    ['and', $this->getStartCriteria($fromTime, '<'), $this->getEndCriteria($toTime, '>')],
                                    ['and', $this->getStartCriteria($fromTime, '>='), $this->getStartCriteria($toTime, '<')],
                                    ['and', $this->getEndCriteria($fromTime, '>'), $this->getEndCriteria($toTime, '<=')],
                                ],
                            ],
                            ['and',
                                [$this->allDayField => 1],
                                ['or',
                                    ['and', $this->getStartCriteria($this->_from, '<'), $this->getEndCriteria($this->_to, '>')],
                                    ['and', $this->getStartCriteria($this->_from, '>='), $this->getStartCriteria($this->_to, '<')],
                                    ['and', $this->getEndCriteria($this->_from, '>'), $this->getEndCriteria($this->_to, '<=')],
                                ],
                            ],
                        ],
                        $this->isRecurrenceRootCondition(),
                    ],
                );
            }
        } else {
            if ($this->_from) {
                if ($this->dateQueryType === static::DATE_QUERY_TYPE_DATE) {
                    $query->andWhere(['or', $this->getStartCriteria($this->_from, '>='), $this->isRecurrenceRootCondition()]);
                } elseif ($this->dateQueryType === static::DATE_QUERY_TYPE_TIME) {
                    $query->andWhere(['or', $this->getStartCriteria($fromTime, '>='), $this->isRecurrenceRootCondition()]);
                } elseif ($this->dateQueryType === static::DATE_QUERY_TYPE_MIXED) {
                    $query->andWhere(
                        ['or',
                            ['and', [$this->allDayField => 0], $this->getStartCriteria($fromTime, '>=')],
                            ['and', [$this->allDayField => 1], $this->getStartCriteria($this->_from, '>=')],
                            $this->isRecurrenceRootCondition(),
                        ],
                    );
                }
            }

            if ($this->_to) {
                if ($this->dateQueryType === static::DATE_QUERY_TYPE_DATE) {
                    $query->andWhere(['or', $this->getEndCriteria($this->_to, '<='), $this->isRecurrenceRootCondition()]);
                } elseif ($this->dateQueryType === static::DATE_QUERY_TYPE_TIME) {
                    $query->andWhere(['or', $this->getEndCriteria($toTime, '<='), $this->isRecurrenceRootCondition()]);
                } elseif ($this->dateQueryType === static::DATE_QUERY_TYPE_MIXED) {
                    $query->andWhere(
                        ['or',
                            ['and', [$this->allDayField => 0], $this->getEndCriteria($toTime, '<=')],
                            ['and', [$this->allDayField => 1], $this->getEndCriteria($this->_to, '<=')],
                            $this->isRecurrenceRootCondition(),
                        ],
                    );
                }

            }
        }
    }

    /**
     * Sets up the date interval filter with respect to the openRange setting.
     * This will also include all recurrent event roots if $expand is true and recurrence evets are supported
     */
    protected function setupDateCriteria()
    {
        $this->createDateCriteriaQuery($this->_query);
    }

    /**
     * Returns a sql condition filtering recurrent root events if supported. Returns empty string if not supported.
     *
     * @return string
     */
    protected function isRecurrenceRootCondition()
    {
        return '';
    }

    /**
     * Helper function to get the start_datetime query filter.
     * @param DateTime $date
     * @param string $eq
     * @return array
     */
    protected function getStartCriteria(DateTime $date, $eq = '>=')
    {
        return [$eq, $this->startField, $date->format($this->getDateFormat())];
    }

    /**
     * Helper function to get the end_datetime query filter.
     * @param DateTime $date
     * @param string $eq
     * @return array
     */
    protected function getEndCriteria(DateTime $date, $eq = '<=')
    {
        return [$eq, $this->endField, $date->format($this->getDateFormat())];
    }

    protected function getDateFormat()
    {
        if (!empty($this->dateFormat)) {
            return $this->dateFormat;
        }

        $this->dateFormat = match ($this->dateQueryType) {
            static::DATE_QUERY_TYPE_DATE => CalendarUtils::DATE_FORMAT_SHORT,
            default => CalendarUtils::DB_DATE_FORMAT,
        };
    }

    /**
     * Sets up the filters contained in the $_filter array.
     */
    protected function setupFilters()
    {
        if ($this->_container) {
            $this->filterContentContainer();
        }


        if (!$this->hasFilter(self::FILTER_INCLUDE_NONREADABLE)) {
            $this->filterReadable();
        }

        if (!$this->hasFilter(self::FILTER_INCLUDE_ARCHIVED)) {
            $this->filterArchived();
        }

        if (Yii::$app->user->isGuest) {
            $this->filterGuests($this->_container);
        } else {
            $hasUserRelatedFilter = $this->hasFilter(self::FILTER_USERRELATED);
            if ($hasUserRelatedFilter) {
                $this->_userScopes = $this->_filters[self::FILTER_USERRELATED];
            }

            if ($hasUserRelatedFilter || !empty($this->_userScopes)) {
                $this->filterUserRelated();
            }

            if ($this->hasFilter(self::FILTER_DASHBOARD)) {
                $this->filterDashboard();
            }

            if (empty($this->_filters)) {
                return;
            }

            if ($this->hasFilter(self::FILTER_PARTICIPATE)) {
                $this->filterIsParticipant();
            }

            if ($this->hasFilter(self::FILTER_RESPONDED)) {
                $this->filterResponded();
            }

            if ($this->hasFilter(self::FILTER_NOT_RESPONDED)) {
                $this->filterNotResponded();
            }

            if ($this->hasFilter(self::FILTER_MINE)) {
                $this->filterMine();
            }
        }
    }

    /**
     * @param ContentContainerActiveRecord|null $container
     * @throws FilterNotSupportedException
     */
    protected function filterGuests(?ContentContainerActiveRecord $container = null)
    {
        if (!$this->_query instanceof ActiveQueryContent) {
            throw new FilterNotSupportedException('Guest filter not supported for this query');
        }
    }

    protected function hasFilter($filter)
    {
        return in_array($filter, $this->_filters) || array_key_exists($filter, $this->_filters);
    }

    protected function filterReadable()
    {
        if ($this->_query instanceof ActiveQueryContent) {
            $this->_query->readable();
        }
    }

    protected function filterArchived()
    {
        if ($this->_query instanceof ActiveQueryContent) {
            if (!$this->isJoinedWith('content')) {
                $this->_query->joinWith('content');
            }
            $this->_query->andWhere('content.archived = 0');
        }
    }

    /**
     * Sets up the types contained in the $_types array.
     */
    protected function setupTypes()
    {
        if (empty($this->_types) || !is_array($this->_types)) {
            return;
        }

        if ($this->_query instanceof ActiveQueryContent) {
            if (!$this->isJoinedWith('content')) {
                $this->_query->joinWith('content');
            }
            $this->_query->innerJoin('content_tag_relation', 'content_tag_relation.content_id = content.id');
            $this->_query->andWhere(['IN', 'content_tag_relation.tag_id', $this->_types]);
        }
    }

    /**
     * Checks if the query is joined with a given relation.
     * Note, this only works for relations created by `joinWith`.
     *
     * @param $relation string
     * @return bool
     */
    protected function isJoinedWith($relation)
    {
        $joinWith = $this->_query->joinWith;

        if (empty($joinWith)) {
            return false;
        }

        foreach ($joinWith as $join) {
            if (isset($join[0][0]) && $join[0][0] === $relation) {
                return true;
            }
        }

        return false;
    }

    protected function filterContentContainer()
    {
        if ($this->_query instanceof ActiveQueryContent) {
            $this->_query->contentContainer($this->_container);
        } else {
            throw new FilterNotSupportedException('Contentcontainer filter not supported for this query');
        }
    }

    protected function filterUserRelated()
    {
        if ($this->_query instanceof ActiveQueryContent) {
            $this->_query->userRelated($this->_userScopes);
        } else {
            throw new FilterNotSupportedException('User related filter not supported for this query');
        }
    }

    protected function filterDashboard()
    {
        if (Yii::$app->user->isGuest) {
            throw new FilterNotSupportedException('User related filter not supported for this query');
        }

        if (empty($this->_userScopes)) {
            $this->_userScopes = [
                ActiveQueryContent::USER_RELATED_SCOPE_SPACES,
                ActiveQueryContent::USER_RELATED_SCOPE_OWN_PROFILE,
                ActiveQueryContent::USER_RELATED_SCOPE_FOLLOWED_SPACES,
                ActiveQueryContent::USER_RELATED_SCOPE_FOLLOWED_USERS,
            ];
            $this->filterUserRelated();
        }

        $this->filterOrIsParticipant();
    }

    /**
     * @throws FilterNotSupportedException
     */
    public function filterMine()
    {
        if ($this->_query instanceof ActiveQueryContent) {
            $this->_query->andWhere(['content.created_by' => $this->_user->id]);
        } else {
            throw new FilterNotSupportedException('Mine filter not supported for this query');
        }
    }

    /**
     * @deprecated This is a legacy filter which is not in use anymore.
     */
    public function filterResponded()
    {
        throw new FilterNotSupportedException('Responded filter not supported for this query');
    }

    /**
     * @deprecated This is a legacy filter which is not in use anymore.
     */
    public function filterNotResponded()
    {
        throw new FilterNotSupportedException('Not Responded filter not supported for this query');
    }

    public function filterIsParticipant()
    {
        throw new FilterNotSupportedException('Participant filter not supported for this query');
    }

    public function filterOrIsParticipant()
    {
        throw new FilterNotSupportedException('Participant filter not supported for this query');
    }

    /**
     * Can be used to pre filter the result list
     * @param $result
     * @return [] result
     */
    protected function preFilter($result = [])
    {
        return $result;
    }
}
