class.ilECSCourseMemberAssignment.php

Go to the documentation of this file.

<?php

declare(strict_types=1);
class ilECSCourseMemberAssignment
{
    public const STATUS_ASSIGNED = 0;
    public const STATUS_LOCAL_DELETED = 1;

    private ilDBInterface $db;

    private int $id;
    private int $server;
    private int $mid;
    private int $cms_id;
    private ?int $cms_sub_id = 0;
    private int $obj_id;
    private ?string $uid;
    private bool $status = false;


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

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

        $this->id = $a_id;

        $this->read();
    }

    public static function lookupMissingAssignmentsOfUser(string $a_usr_id): array
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        $query = 'SELECT id FROM ecs_course_assignments ' .
                'WHERE usr_id = ' . $ilDB->quote($a_usr_id, 'text');
        $res = $ilDB->query($query);

        $assignments = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $assignments[] = new self((int) $row->id);
        }
        return $assignments;
    }

    public static function deleteByObjId(int $a_obj_id): bool
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        $query = 'DELETE FROM ecs_course_assignments ' .
                'WHERE obj_id = ' . $ilDB->quote($a_obj_id, 'integer');
        $ilDB->manipulate($query);
        return true;
    }

    public static function deleteByServerId(int $a_server_id): bool
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        $query = 'DELETE FROM ecs_course_assignments ' .
                'WHERE sid = ' . $ilDB->quote($a_server_id, 'integer');
        $ilDB->manipulate($query);
        return true;
    }

    public static function lookupUserIds(int $a_cms_id, ?int $a_cms_sub_id, int $a_obj_id): array
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        if (is_null($a_cms_sub_id)) {
            $cms_sub_id_query = 'AND (cms_sub_id IS NULL or cms_sub_id = 0) ';
        } else {
            $cms_sub_id_query = 'AND cms_sub_id = ' . $ilDB->quote($a_cms_sub_id, 'integer') . ' ';
        }

        $query = 'SELECT usr_id FROM ecs_course_assignments ' .
                'WHERE cms_id = ' . $ilDB->quote($a_cms_id, 'integer') . ' ' .
                $cms_sub_id_query .
                'AND obj_id = ' . $ilDB->quote($a_obj_id, 'integer');
        $res = $ilDB->query($query);

        $usr_ids = [];
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $usr_ids[] = $row->usr_id;
        }
        return $usr_ids;
    }

    public static function lookupAssignment(int $a_cms_id, ?int $a_cms_sub_id, int $a_obj_id, string $a_usr_id): ?ilECSCourseMemberAssignment
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        if (is_null($a_cms_sub_id)) {
            $cms_sub_id_query = 'AND (cms_sub_id IS NULL or cms_sub_id = 0) ';
        } else {
            $cms_sub_id_query = 'AND cms_sub_id = ' . $ilDB->quote($a_cms_sub_id, 'integer') . ' ';
        }

        $query = 'SELECT id FROM ecs_course_assignments ' .
                'WHERE cms_id = ' . $ilDB->quote($a_cms_id, 'integer') . ' ' .
                $cms_sub_id_query .
                'AND obj_id = ' . $ilDB->quote($a_obj_id, 'integer') . ' ' .
                'AND usr_id = ' . $ilDB->quote($a_usr_id, 'text');
        $res = $ilDB->query($query);
        if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return new ilECSCourseMemberAssignment((int) $row->id);
        }
        return null;
    }


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

    public function setServer(int $a_server): void
    {
        $this->server = $a_server;
    }

    public function getServer(): int
    {
        return $this->server;
    }

    public function setMid(int $a_mid): void
    {
        $this->mid = $a_mid;
    }

    public function getMid(): int
    {
        return $this->mid;
    }

    public function setCmsId(int $a_id): void
    {
        $this->cms_id = $a_id;
    }

    public function getCmsId(): int
    {
        return $this->cms_id;
    }

    public function setCmsSubId(int $a_id): void
    {
        $this->cms_sub_id = $a_id;
    }

    public function getCmsSubId(): ?int
    {
        return $this->cms_sub_id;
    }

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

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

    public function setUid(string $a_id): void
    {
        $this->uid = $a_id;
    }

    public function getUid(): ?string
    {
        return $this->uid;
    }

    public function setStatus(bool $a_status): void
    {
        $this->status = $a_status;
    }

    public function getStatus(): bool
    {
        return $this->status;
    }

    public function save(): bool
    {
        $this->id = $this->db->nextId('ecs_course_assignments');

        $assignment = self::lookupAssignment(
            $this->getCmsId(),
            $this->getCmsSubId(),
            $this->getObjId(),
            $this->getUid()
        );
        if ($assignment instanceof self) {
            $assignment->update();
            return true;
        }

        $query = 'INSERT INTO ecs_course_assignments ' .
                '(id,sid,mid,cms_id,cms_sub_id,obj_id,usr_id,status) ' .
                'VALUES( ' .
                $this->db->quote($this->getId(), 'integer') . ', ' .
                $this->db->quote($this->getServer(), 'integer') . ', ' .
                $this->db->quote($this->getMid(), 'integer') . ', ' .
                $this->db->quote($this->getCmsId(), 'integer') . ', ' .
                $this->db->quote($this->getCmsSubId(), 'integer') . ', ' .
                $this->db->quote($this->getObjId(), 'integer') . ', ' .
                $this->db->quote($this->getUid(), 'text') . ', ' .
                $this->db->quote($this->getStatus(), 'integer') . ' ' .
                ')';
        $this->db->manipulate($query);
        return true;
    }

    public function update(): bool
    {
        $query = 'UPDATE ecs_course_assignments ' .
                'SET ' .
                'sid = ' . $this->db->quote($this->getServer(), 'integer') . ', ' .
                'mid = ' . $this->db->quote($this->getMid(), 'integer') . ', ' .
                'cms_id = ' . $this->db->quote($this->getCmsId(), 'integer') . ', ' .
                'cms_sub_id = ' . $this->db->quote($this->getCmsSubId(), 'integer') . ', ' .
                'obj_id = ' . $this->db->quote($this->getObjId(), 'integer') . ', ' .
                'usr_id = ' . $this->db->quote($this->getUid(), 'text') . ', ' .
                'status = ' . $this->db->quote($this->getStatus(), 'integer') . ' ' .
                'WHERE id = ' . $this->db->quote($this->getId(), 'integer');
        $this->db->manipulate($query);
        return true;
    }

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



    protected function read(): bool
    {
        if (!$this->getId()) {
            return false;
        }

        $query = 'SELECT * FROM ecs_course_assignments ' .
            'WHERE id = ' . $this->db->quote($this->getId(), 'integer');
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->setServer((int) $row->sid);
            $this->setMid((int) $row->mid);
            $this->setCmsId((int) $row->cms_id);
            if (!is_null($row->cms_sub_id)) {
                $this->setCmsSubId((int) $row->cms_sub_id);
            }
            $this->setObjId((int) $row->obj_id);
            if (!is_null($row->usr_id)) {
                $this->setUid($row->usr_id);
            }
            $this->setStatus((bool) $row->status);
        }
        return true;
    }
}