datefield.php

<?php
namespace Bitrix\Sender\Connector\Filter;
 
use Bitrix\Main\Application;
use Bitrix\Main\Type\Date;
use Bitrix\Main\UI\Filter\Options as FilterOptions;
use Bitrix\Main\UI\Filter\AdditionalDateType;
use Bitrix\Main\UserFieldTable;
 
class DateField extends AbstractField
{
    public function fetchFieldValue($filterFields)
    {
        $result = FilterOptions::fetchDateFieldValue(
            $this->getId() . '_datesel',
            $filterFields
        );
 
        $allowYearName = $this->getAllowYearName();
        if (!isset($result[$allowYearName]) && isset($filterFields[$allowYearName]))
        {
            $result[$allowYearName] = $filterFields[$allowYearName];
        }
 
        if (!empty($result))
        {
            return $result;
        }
 
        if (!$this->isCustomDate())
        {
            return [];
        }
 
        $result = [];
        foreach(['days', 'month', 'year'] as $key)
        {
            $fieldKey = $this->getId() . '_' . $key;
            if (empty($filterFields[$fieldKey]))
            {
                continue;
            }
 
            $result[$fieldKey] = $filterFields[$fieldKey];
        }
 
        return $result;
    }
 
    public function applyFilter(array &$filter = array())
    {
        $filterKey = $this->getFilterKey();
        $from = $this->isMoreThanDaysAgo() ? null : $this->getFrom();
        $to = $this->isAfterDays() ? null : $this->getTo();
 
        if ($from)
        {
            if ($this->isAllowYears())
            {
                $filter[">=$filterKey"] = $from;
            }
            else
            {
                $filter[] = $this->getFilterYearLess('FROM', $from, ">=");
            }
        }
        if ($to)
        {
            if ($this->isAllowYears())
            {
                $filter["<=$filterKey"] = $to;
            }
            else
            {
                $filter[] = $this->getFilterYearLess('TO', $to, "<=", $from);
            }
        }
        if ($this->getDays())
        {
            $fieldId = $this->getId();
            $filterKey = $this->getId() . '_EXPR_DAYS';
            $filter[] = (new RuntimeFilter())
                ->setFilter(
                    '=' . $filterKey,
                    $this->getDays()
                )
                ->addRuntime([
                    'name' => $filterKey,
                    'expression' => "EXTRACT(DAY from %s)",
                    'buildFrom' => [$fieldId],
                    'parameters' => []
                ]);
        }
        if ($this->getMonths())
        {
            $fieldId = $this->getId();
            $filterKey = $this->getId() . '_EXPR_MONTHS';
            $filter[] = (new RuntimeFilter())
                ->setFilter(
                    '=' . $filterKey,
                    $this->getMonths()
                )
                ->addRuntime([
                    'name' => $filterKey,
                    'expression' => "EXTRACT(MONTH from %s)",
                    'buildFrom' => [$fieldId],
                    'parameters' => []
                ]);
        }
        if ($this->getYears())
        {
            $fieldId = $this->getId();
            $filterKey = $this->getId() . '_EXPR_YEARS';
            $filter[] = (new RuntimeFilter())
                ->setFilter(
                    '=' . $filterKey,
                    $this->getYears()
                )
                ->addRuntime([
                    'name' => $filterKey,
                    'expression' => "EXTRACT(YEAR from %s)",
                    'buildFrom' => [$fieldId],
                    'parameters' => []
                ]);
        }
    }
 
    public function getFrom($defaultValue = null)
    {
        return $this->getDate($defaultValue, true);
    }
 
    public function getTo($defaultValue = null)
    {
        return $this->getDate($defaultValue, false);
    }
 
    public function getDays()
    {
        return $this->getCustomDateData('days');
    }
 
    public function getMonths()
    {
        return $this->getCustomDateData('month');
    }
 
    public function getYears()
    {
        return $this->getCustomDateData('year');
    }
 
    private function getCustomDateData($key)
    {
        $value = $this->getDateDataByKey($key);
        if (!$value || !is_array($value))
        {
            return [];
        }
 
        return array_map(
            function ($item)
            {
                return (int) $item;
            },
            $value
        );
    }
 
    private function isMoreThanDaysAgo()
    {
        return $this->getDateDataByKey('datesel') === AdditionalDateType::MORE_THAN_DAYS_AGO;
    }
 
    private function isAfterDays()
    {
        return $this->getDateDataByKey('datesel') === AdditionalDateType::AFTER_DAYS;
    }
 
    private function getDateDataByKey($key)
    {
        $key = $this->getId() . '_' . $key;
        $value = $this->getValue();
        if (!is_array($value) || count($value) === 0)
        {
            return null;
        }
 
        if (empty($value[$key]))
        {
            return null;
        }
 
        return $value[$key];
    }
 
    private function getDate($defaultValue = null, $isFrom = true)
    {
        $name = $this->getId();
        $value = $this->getValue();
        if (!is_array($value) || count($value) === 0)
        {
            return $defaultValue;
        }
 
        $calcData = array();
        FilterOptions::calcDates($name, $value, $calcData);
 
        if ($isFrom)
        {
            return isset($calcData[$name . '_from']) ? $calcData[$name . '_from'] : $defaultValue;
        }
        else
        {
            return isset($calcData[$name . '_to']) ? $calcData[$name . '_to'] : $defaultValue;
        }
    }
 
    private function isCustomDate()
    {
        return isset($this->data['include']) && in_array(AdditionalDateType::CUSTOM_DATE, $this->data['include']);
    }
 
    private function isAllowYears()
    {
        if (!isset($this->data['allow_years_switcher']) || !$this->data['allow_years_switcher'])
        {
            return true;
        }
 
        return !empty($this->data['value'][$this->getAllowYearName()]);
    }
 
    private function getAllowYearName()
    {
        return $this->getId() . '_allow_year';
    }
 
    private function getFilterYearLess($tag, $value, $operation =  "=", $fromValue = null)
    {
        $addOneYear = '';
        $date = new Date($value);
        if ($fromValue)
        {
            $dateFrom = new Date($fromValue);
            if ($dateFrom->getTimestamp() > $date->getTimestamp())
            {
                $addOneYear = '+ 1';
            }
        }
 
        $fieldId = $this->getId();
        $expressionFieldName = $fieldId . "_YEAR_LESS_" . $tag;
        $filterKey = $this->getFilterKey();
 
        // hack for multiple user field of date type.
        $uf = explode('.', $filterKey);
        foreach ($uf as $item)
        {
            if (mb_strpos($item, 'UF_') !== 0)
            {
                continue;
            }
 
            $userField = UserFieldTable::getRow([
                'select' => ['USER_TYPE_ID', 'MULTIPLE'],
                'filter' => ['=FIELD_NAME' => $item]
            ]);
            if (!$userField || $userField['USER_TYPE_ID'] != 'date')
            {
                continue;
            }
            if ($userField['MULTIPLE'] != 'Y')
            {
                continue;
            }
 
            $filterKey .= '_SINGLE'; // Magic ORM postfix
        }
        // end hack
 
        $sqlHelper = Application::getConnection()->getSqlHelper();
 
        $charDate = $sqlHelper->getConcatFunction(
            "(EXTRACT(YEAR from %s) $addOneYear)",
            "'-{$date->format('m')}-{$date->format('d')}'"
        );
        $sqlDate = $sqlHelper->getDatetimeToDateFunction($charDate); // char -> date conversion
 
        return (new RuntimeFilter())
            ->setFilter(
                "=$expressionFieldName",
                1
            )
            ->addRuntime([
                'name' => $expressionFieldName,
                'expression' => "case when %s $operation $sqlDate then 1 else 0 end",
                'buildFrom' => [
                    $filterKey,
                    $filterKey
                ],
                'parameters' => []
            ]);
    }
}