class.ilAdvancedMDRecordObjectOrdering.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilAdvancedMDRecordObjectOrdering
{
    private $record_id;

    private $obj_id;

    private $position;


    private $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)
    {
        $this->position = $position;
    }

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

    public function save()
    {
        $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()
    {
        $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);
    }
}