class.ilAdvancedMDRecordObjectOrdering.php

Go to the documentation of this file.

<?php

declare(strict_types=1);
class ilAdvancedMDRecordObjectOrdering
{
    private int $record_id;
    private int $obj_id;
    private int $position = 0;

    protected ilDBInterface $db;

    public function __construct(int $record_id, int $obj_id, ilDBInterface $db)
    {
        $this->record_id = $record_id;
        $this->obj_id = $obj_id;
        $this->db = $db;
    }

    public function setPosition(int $position): void
    {
        $this->position = $position;
    }

    public function getPosition(): int
    {
        return $this->position;
    }

    public function save(): void
    {
        $this->delete();

        $query = 'INSERT INTO adv_md_record_obj_ord (record_id, obj_id, position ) ' .
            'VALUES ( ' .
            $this->db->quote($this->record_id, 'integer') . ', ' .
            $this->db->quote($this->obj_id, 'integer') . ', ' .
            $this->db->quote($this->position, 'integer') . ' ' .
            ')';

        $this->db->manipulate($query);
    }

    public function delete(): void
    {
        $query = 'DELETE FROM adv_md_record_obj_ord WHERE ' .
            'record_id = ' . $this->db->quote($this->record_id, 'integer') . ' ' .
            'AND obj_id = ' . $this->db->quote($this->obj_id, 'integer');
        $this->db->manipulate($query);
    }
}