class.ilDclNumberFieldModel.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilDclNumberFieldModel extends ilDclBaseFieldModel
{
    public function getRecordQueryFilterObject(
        $filter_value = "",
        ?ilDclBaseFieldModel $sort_field = null
    ): ?ilDclRecordQueryObject {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        if (is_array($filter_value)) {
            $from = (isset($filter_value['from'])) ? (int) $filter_value['from'] : null;
            $to = (isset($filter_value['to'])) ? (int) $filter_value['to'] : null;
        }

        $join_str
            = "INNER JOIN il_dcl_record_field AS filter_record_field_{$this->getId()} ON (filter_record_field_{$this->getId()}.record_id = record.id AND filter_record_field_{$this->getId()}.field_id = "
            . $ilDB->quote($this->getId(), 'integer') . ") ";
        $join_str .= "INNER JOIN il_dcl_stloc{$this->getStorageLocation()}_value AS filter_stloc_{$this->getId()} ON (filter_stloc_{$this->getId()}.record_field_id = filter_record_field_{$this->getId()}.id";
        if (isset($from)) {
            $join_str .= " AND filter_stloc_{$this->getId()}.value >= " . $ilDB->quote($from, 'integer');
        }
        if (isset($to)) {
            $join_str .= " AND filter_stloc_{$this->getId()}.value <= " . $ilDB->quote($to, 'integer');
        }
        $join_str .= ") ";

        $sql_obj = new ilDclRecordQueryObject();
        $sql_obj->setJoinStatement($join_str);

        return $sql_obj;
    }

    public function hasNumericSorting(): bool
    {
        return true;
    }

    public function checkValidity($value, ?int $record_id = null): bool
    {
        //mantis 30758, 36585: uniqueness for all types of fields

        //value from the form comes as float
        if (!is_numeric($value)) {
            throw new ilDclInputException(ilDclInputException::TYPE_EXCEPTION);
        }

        //dcl currently only works with integer type, when
        //field is of type number (see ilDcldatatype::INPUTFORMAT_NUMBER)
        $valid = parent::checkValidity((int) $value, $record_id);

        return $valid;
    }
}