class.NoteSettingsDBRepository.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Notes;

class NoteSettingsDBRepository
{
    protected \ilDBInterface $db;
    protected InternalDataService $data;

    public function __construct(
        InternalDataService $data,
        \ilDBInterface $db
    ) {
        $this->db = $db;
        $this->data = $data;
    }

    public function commentsActive(
        int $obj_id
    ): bool {
        $db = $this->db;
        $set = $db->query(
            "SELECT rep_obj_id FROM note_settings " .
            " WHERE rep_obj_id = " . $db->quote($obj_id, "integer") .
            " AND activated = " . $db->quote(1, "integer")
        );
        if ($db->fetchAssoc($set)) {
            return true;
        }
        return false;
    }

    public function commentsActiveMultiple(
        array $obj_ids
    ): array {
        $db = $this->db;

        $set = $db->query("SELECT * FROM note_settings " .
            " WHERE " . $db->in("rep_obj_id", $obj_ids, false, "integer") .
            " AND obj_id = 0 ");
        $activations = [];
        while ($rec = $db->fetchAssoc($set)) {
            if ($rec["activated"]) {
                $activations[$rec["rep_obj_id"]] = true;
            }
        }

        return $activations;
    }


    public function activateComments(
        int $obj_id,
        int $sub_obj_id,
        string $obj_type,
        bool $a_activate = true
    ): void {
        $db = $this->db;

        if ($obj_type === "") {
            $obj_type = "-";
        }

        $db->replace(
            "note_settings",
            [
           "rep_obj_id" => ["integer", $obj_id],
           "obj_id" => ["integer", $sub_obj_id],
           "obj_type" => ["string", $obj_type],
        ],
            [
                "activated" => ["integer", (int) $a_activate]
            ]
        );
    }
}