class.ilOerHarvesterObjectStatus.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilOerHarvesterObjectStatus
{
    private int $obj_id;

    private int $harvest_ref_id = 0;

    private bool $blocked = false;

    protected ilDBInterface $db;

    public function __construct(int $obj_id = 0)
    {
        global $DIC;

        $this->db = $DIC->database();

        $this->obj_id = $obj_id;
        if ($this->obj_id) {
            $this->read();
        }
    }

    public static function lookupHarvested(): array
    {
        global $DIC;

        $db = $DIC->database();

        $query = 'SELECT href_id FROM il_meta_oer_stat ';
        $res = $db->query($query);

        $hids = [];
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $hids[] = (int) $row->href_id;
        }
        return $hids;
    }

    public static function lookupObjIdByHarvestingId(int $a_href_id): int
    {
        global $DIC;

        $db = $DIC->database();
        $query = 'SELECT obj_id FROM il_meta_oer_stat ' .
            'WHERE href_id = ' . $db->quote($a_href_id, 'integer');
        $res = $db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (int) $row->obj_id;
        }
        return 0;
    }

    public function setObjId(int $a_obj_id): void
    {
        $this->obj_id = $a_obj_id;
    }

    public function getObjId(): int
    {
        return $this->obj_id;
    }

    public function setHarvestRefId(int $a_ref_id): void
    {
        $this->harvest_ref_id = $a_ref_id;
    }

    public function getHarvestRefId(): int
    {
        return $this->harvest_ref_id;
    }

    public function setBlocked(bool $a_stat): void
    {
        $this->blocked = $a_stat;
    }

    public function isBlocked(): bool
    {
        return $this->blocked;
    }

    public function isCreated(): bool
    {
        return (bool) $this->harvest_ref_id;
    }

    public function save(): bool
    {
        $this->delete();
        $query = 'INSERT INTO il_meta_oer_stat ' .
            '(obj_id, href_id, blocked ) ' .
            'VALUES (' .
            $this->db->quote($this->getObjId(), 'integer') . ', ' .
            $this->db->quote($this->getHarvestRefId(), 'integer') . ', ' .
            $this->db->quote($this->isBlocked(), 'integer') .
            ')';
        $res = $this->db->manipulate($query);
        return true;
    }

    public function delete(): bool
    {
        $query = 'DELETE FROM il_meta_oer_stat ' .
            'WHERE obj_id = ' . $this->db->quote($this->getObjId(), 'integer');
        $this->db->manipulate($query);
        return true;
    }

    public function read(): void
    {
        $query = 'SELECT * FROM il_meta_oer_stat ' .
            'WHERE obj_id = ' . $this->db->quote($this->getObjId(), 'integer');
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->setObjId((int) $row->obj_id);
            $this->setHarvestRefId((int) $row->href_id);
            $this->setBlocked((bool) $row->blocked);
        }
    }
}