class.ilDclSelectionOption.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilDclSelectionOption extends ActiveRecord
{
    public const DB_TABLE_NAME = "il_dcl_sel_opts";

    public static function returnDbTableName(): string
    {
        return self::DB_TABLE_NAME;
    }

    protected ?int $id;
    protected int $field_id;
    protected int $opt_id;
    protected int $sorting;
    protected string $value;

    public function getId(): int
    {
        return $this->id;
    }

    public function setId(int $id): void
    {
        $this->id = $id;
    }

    public function getFieldId(): int
    {
        return $this->field_id;
    }

    public function setFieldId(int $field_id): void
    {
        $this->field_id = $field_id;
    }

    public function getOptId(): int
    {
        return $this->opt_id;
    }

    public function setOptId(int $opt_id): void
    {
        $this->opt_id = $opt_id;
    }

    public function getValue(): string
    {
        return $this->value;
    }

    public function setValue(string $value): void
    {
        $this->value = $value;
    }

    public function getSorting(): int
    {
        return $this->sorting;
    }

    public function setSorting(int $sorting): void
    {
        $this->sorting = $sorting;
    }

    public static function storeOption(int $field_id, int $opt_id, int $sorting, string $value): void
    {
        $option = self::where(["field_id" => $field_id, "opt_id" => $opt_id])->first();
        if (!$option) {
            $option = new self();
        }
        $option->setFieldId($field_id);
        $option->setOptId((int) $opt_id);
        $option->setSorting($sorting);
        $option->setValue($value);
        $option->store();
    }

    public static function flushOptions(int $field_id): void
    {
        foreach (self::getAllForField($field_id) as $option) {
            $option->delete();
        }
    }

    public static function getAllForField(int $field_id): array
    {
        return self::where(["field_id" => $field_id])->orderBy('sorting')->get();
    }

    public static function getValues(int $field_id, $opt_ids): array
    {
        $operators = ['field_id' => '='];
        if (is_array($opt_ids)) {
            if (empty($opt_ids)) {
                return [];
            }
            $operators['opt_id'] = 'IN';
        } else {
            $operators['opt_id'] = '=';
        }
        $return = [];
        foreach (self::where(
            ["field_id" => $field_id, "opt_id" => $opt_ids],
            $operators
        )->orderBy('sorting')->get() as $opt) {
            $return[] = $opt->getValue();
        }

        return $return;
    }

    public function cloneOption(ilDclSelectionOption $original_option): void
    {
        $this->setValue($original_option->getValue());
        $this->setSorting($original_option->getSorting());
        $this->setOptId($original_option->getOptId());
    }
}