Collaboration diagram for ilMailTemplateRepository:

Public Member Functions
	__construct (ilDBInterface $db=null)

	getAll ()

	findById (int $templateId)

	findByContextId (string $contextId)

	deleteByIds (array $templateIds)

	store (ilMailTemplate $template)

Protected Attributes
ilDBInterface	$db

Detailed Description

Class ilMailTemplateRepository.

Definition at line 24 of file class.ilMailTemplateRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilMailTemplateRepository::__construct ( ilDBInterface $db = null )

Definition at line 28 of file class.ilMailTemplateRepository.php.

    {
        global $DIC;
        $this->db = $db ?? $DIC->database();
    }

References $db, and $DIC.

Member Function Documentation

◆ deleteByIds()

ilMailTemplateRepository::deleteByIds ( array $templateIds )

Parameters

int[] $templateIds

Definition at line 84 of file class.ilMailTemplateRepository.php.

                                                   : void
    {
        if (count($templateIds) > 0) {
            $this->db->manipulate(
                'DELETE FROM mail_man_tpl WHERE ' . $this->db->in('tpl_id', $templateIds, false, ilDBConstants::T_INTEGER)
            );
        }
    }

References ilDBConstants\T_INTEGER.

◆ findByContextId()

ilMailTemplateRepository::findByContextId ( string $contextId )

Parameters

string $contextId

Returns: ilMailTemplate[]

Definition at line 74 of file class.ilMailTemplateRepository.php.

                                                      : array
    {
        return array_filter($this->getAll(), static function (ilMailTemplate $template) use ($contextId): bool {
            return $contextId === $template->getContext();
        });
    }

References getAll(), and ilMailTemplate\getContext().

Here is the call graph for this function:

◆ findById()

ilMailTemplateRepository::findById ( int $templateId )

Parameters

int $templateId

Returns: ilMailTemplate

Definition at line 54 of file class.ilMailTemplateRepository.php.

                                             : ilMailTemplate
    {
        $res = $this->db->queryF(
            'SELECT * FROM mail_man_tpl WHERE tpl_id  = %s',
            [ilDBConstants::T_INTEGER],
            [$templateId]
        );
 
        if (1 === $this->db->numRows($res)) {
            $row = $this->db->fetchAssoc($res);
            return new ilMailTemplate($row);
        }
 
        throw new OutOfBoundsException(sprintf("Could not find template by id: %s", $templateId));
    }

References $res, and ilDBConstants\T_INTEGER.

◆ getAll()

ilMailTemplateRepository::getAll ( )

Returns: ilMailTemplate[]

Definition at line 37 of file class.ilMailTemplateRepository.php.

                            : array
    {
        $templates = [];
 
        $res = $this->db->query('SELECT * FROM mail_man_tpl');
        while ($row = $this->db->fetchAssoc($res)) {
            $template = new ilMailTemplate($row);
            $templates[] = $template;
        }
 
        return $templates;
    }

References $res.

Referenced by findByContextId().

Here is the caller graph for this function:

◆ store()

ilMailTemplateRepository::store ( ilMailTemplate $template )

Definition at line 93 of file class.ilMailTemplateRepository.php.

                                                   : void
    {
        if ($template->getTplId() > 0) {
            $this->db->update(
                'mail_man_tpl',
                [
                    'title' => [ilDBConstants::T_TEXT, $template->getTitle()],
                    'context' => [ilDBConstants::T_TEXT, $template->getContext()],
                    'lang' => [ilDBConstants::T_TEXT, $template->getLang()],
                    'm_subject' => [ilDBConstants::T_TEXT, $template->getSubject()],
                    'm_message' => [ilDBConstants::T_TEXT, $template->getMessage()],
                    'is_default' => [ilDBConstants::T_INTEGER, $template->isDefault()],
                ],
                [
                    'tpl_id' => [ilDBConstants::T_INTEGER, $template->getTplId()],
                ]
            );
        } else {
            $nextId = $this->db->nextId('mail_man_tpl');
            $this->db->insert('mail_man_tpl', [
                'tpl_id' => [ilDBConstants::T_INTEGER, $nextId],
                'title' => [ilDBConstants::T_TEXT, $template->getTitle()],
                'context' => [ilDBConstants::T_TEXT, $template->getContext()],
                'lang' => [ilDBConstants::T_TEXT, $template->getLang()],
                'm_subject' => [ilDBConstants::T_TEXT, $template->getSubject()],
                'm_message' => [ilDBConstants::T_TEXT, $template->getMessage()],
                'is_default' => [ilDBConstants::T_INTEGER, $template->isDefault()],
            ]);
            $template->setTplId($nextId);
        }
    }