class.ilMailingLists.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilMailingLists
{
    private readonly ilDBInterface $db;
    private ?ilMailingList $ml = null;

    public function __construct(private readonly ilObjUser $user)
    {
        global $DIC;

        $this->db = $DIC['ilDB'];
    }

    public function isOwner(int $a_ml_id, int $a_usr_id): bool
    {
        $res = $this->db->queryF(
            'SELECT EXISTS(SELECT 1 FROM addressbook_mlist WHERE ml_id = %s AND user_id = %s) cnt',
            ['integer', 'integer'],
            [$a_ml_id, $a_usr_id]
        );
        $row = $this->db->fetchAssoc($res);

        return is_array($row) && (int) $row['cnt'] === 1;
    }

    public function get(int $id = 0): ilMailingList
    {
        return new ilMailingList($this->user, $id);
    }

    public function getSelected(array $a_ids = []): array
    {
        $entries = [];

        foreach ($a_ids as $id) {
            $entries[] = new ilMailingList($this->user, $id);
        }

        return $entries;
    }

    public function hasAny(): bool
    {
        $res = $this->db->queryF(
            'SELECT EXISTS(SELECT 1 FROM addressbook_mlist WHERE user_id = %s) cnt',
            ['integer'],
            [$this->user->getId()]
        );
        $row = $this->db->fetchAssoc($res);

        return (is_array($row) && (int) $row['cnt'] === 1);
    }

    public function getAll(): array
    {
        $res = $this->db->queryF(
            'SELECT * FROM addressbook_mlist WHERE user_id = %s',
            ['integer'],
            [$this->user->getId()]
        );

        $entries = [];

        $counter = 0;
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $tmpObj = new ilMailingList($this->user, 0);
            $tmpObj->setId((int) $row->ml_id);
            $tmpObj->setUserId((int) $row->user_id);
            $tmpObj->setTitle($row->title);
            $tmpObj->setDescription($row->description);
            $tmpObj->setCreatedate($row->createdate);
            $tmpObj->setChangedate($row->changedate);
            $tmpObj->setMode((int) $row->lmode);

            $entries[$counter] = $tmpObj;

            unset($tmpObj);

            ++$counter;
        }

        return $entries;
    }

    public function mailingListExists(string $a_list_name): bool
    {
        $ml_id = (int) substr($a_list_name, strrpos($a_list_name, '_') + 1);
        if (!is_numeric($ml_id) || $ml_id <= 0) {
            return false;
        }

        $this->setCurrentMailingList($ml_id);

        return $this->getCurrentMailingList()->doesExist();
    }

    public function setCurrentMailingList(int $id = 0): void
    {
        $this->ml = $this->get($id);
    }


    public function getCurrentMailingList(): ?ilMailingList
    {
        return $this->ml;
    }

    public function deleteTemporaryLists(): void
    {
        foreach ($this->getAll() as $mlist) {
            if ($mlist->getMode() === ilMailingList::MODE_TEMPORARY) {
                $mlist->delete();
            }
        }
    }

    public function deleteLists(): void
    {
        $this->db->manipulateF(
            'DELETE ass FROM addressbook_mlist_ass ass INNER JOIN addressbook_mlist list ON ass.ml_id = list.ml_id WHERE list.user_id = %s',
            ['integer'],
            [$this->user->getId()]
        );
        $this->db->manipulateF(
            'DELETE FROM addressbook_mlist WHERE user_id = %s',
            ['integer'],
            [$this->user->getId()]
        );
    }

    public function deleteAssignments(): void
    {
        $this->db->manipulate(
            'DELETE FROM addressbook_mlist_ass WHERE usr_id = ' . $this->db->quote($this->user->getId(), 'integer')
        );
    }
}