class.ilForumPostsTree.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilForumPostsTree
{
    private readonly ilDBInterface $db;
    private int $pos_fk = 0;
    private int $parent_pos = 0;
    private int $lft = 0;
    private int $rgt = 0;
    private int $depth = 0;
    private int $source_thread_id = 0;
    private int $target_thread_id = 0;

    public function __construct()
    {
        global $DIC;
        $this->db = $DIC->database();
    }

    public function setDepth(int $depth): void
    {
        $this->depth = $depth;
    }

    public function getDepth(): int
    {
        return $this->depth;
    }

    public function setLft(int $lft): void
    {
        $this->lft = $lft;
    }

    public function getLft(): int
    {
        return $this->lft;
    }

    public function setParentPos(int $parent_pos): void
    {
        $this->parent_pos = $parent_pos;
    }

    public function getParentPos(): int
    {
        return $this->parent_pos;
    }

    public function setPosFk(int $pos_fk): void
    {
        $this->pos_fk = $pos_fk;
    }

    public function getPosFk(): int
    {
        return $this->pos_fk;
    }

    public function setRgt(int $rgt): void
    {
        $this->rgt = $rgt;
    }

    public function getRgt(): int
    {
        return $this->rgt;
    }

    public function setSourceThreadId(int $source_thread_id): void
    {
        $this->source_thread_id = $source_thread_id;
    }

    public function getSourceThreadId(): int
    {
        return $this->source_thread_id;
    }

    public function setTargetThreadId(int $target_thread_id): void
    {
        $this->target_thread_id = $target_thread_id;
    }

    public function getTargetThreadId(): int
    {
        return $this->target_thread_id;
    }

    public function merge(): void
    {
        $this->db->update(
            'frm_posts_tree',
            [
                'lft' => ['integer', $this->getLft()],
                'rgt' => ['integer', $this->getRgt()],
                'depth' => ['integer', $this->getDepth()],
                'thr_fk' => ['integer', $this->getTargetThreadId()],
                'parent_pos' => ['integer', $this->getParentPos()],
            ],
            [
                'pos_fk' => ['integer', $this->getPosFk()],
                'thr_fk' => ['integer', $this->getSourceThreadId()]
            ]
        );
    }

    public static function updateTargetRootRgt(int $root_node_id, int $rgt): void
    {
        global $DIC;

        $ilDB = $DIC->database();

        $ilDB->update(
            'frm_posts_tree',
            [
                'rgt' => ['integer', $rgt]
            ],
            [
                'parent_pos' => ['integer', 0],
                'pos_fk' => ['integer', $root_node_id]
            ]
        );
    }
}