ILIAS\Help\Module\ModuleDBRepository Class Reference

Collaboration diagram for ILIAS\Help\Module\ModuleDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db)
	create ()
	writeHelpModuleLmId (int $a_id, int $a_lm_id)
	saveOrder (array $order)
	getHelpModules ()
	lookupModuleTitle (int $a_id)
	lookupModuleLmId (int $a_id)
	deleteModule (int $id)
	isHelpLM (int $a_lm_id)
	Check if LM is a help LM. More...
	writeActive (int $module_id, bool $active)

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 23 of file ModuleDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Help\Module\ModuleDBRepository::__construct

(

\ilDBInterface

$db

)

Definition at line 27 of file ModuleDBRepository.php.

References ILIAS\Help\Module\ModuleDBRepository\$db.

      {
        $this->db = $db;
    }

Member Function Documentation

create()

ILIAS\Help\Module\ModuleDBRepository::create

(

)

Definition at line 33 of file ModuleDBRepository.php.

References $id.

                            : int
    {
        $id = $this->db->nextId("help_module");

        $this->db->manipulate("INSERT INTO help_module " .
            "(id) VALUES (" .
            $this->db->quote($id, "integer") .
            ")");

        return $id;
    }

deleteModule()

ILIAS\Help\Module\ModuleDBRepository::deleteModule

(

int

$id

)

Definition at line 114 of file ModuleDBRepository.php.

     : void {
        $this->db->manipulate("DELETE FROM help_module WHERE " .
            " id = " . $this->db->quote($id, "integer"));
    }

getHelpModules()

ILIAS\Help\Module\ModuleDBRepository::getHelpModules

(

)

Definition at line 71 of file ModuleDBRepository.php.

References ilObject\_lookupCreationDate(), ilObject\_lookupTitle(), and ilObject\_lookupType().

                                    : array
    {
        $set = $this->db->query("SELECT * FROM help_module ORDER BY order_nr ASC");

        $mods = array();
        while ($rec = $this->db->fetchAssoc($set)) {
            if (\ilObject::_lookupType((int) $rec["lm_id"]) === "lm") {
                $rec["title"] = \ilObject::_lookupTitle((int) $rec["lm_id"]);
                $rec["create_date"] = \ilObject::_lookupCreationDate((int) $rec["lm_id"]);
            }

            $mods[] = $rec;
        }

        return $mods;
    }

Here is the call graph for this function:

isHelpLM()

ILIAS\Help\Module\ModuleDBRepository::isHelpLM

(

int

$a_lm_id

)

Check if LM is a help LM.

Definition at line 124 of file ModuleDBRepository.php.

     : bool {
        $set = $this->db->query(
            "SELECT id FROM help_module " .
            " WHERE lm_id = " . $this->db->quote($a_lm_id, "integer")
        );
        if ($rec = $this->db->fetchAssoc($set)) {
            return true;
        }
        return false;
    }

lookupModuleLmId()

ILIAS\Help\Module\ModuleDBRepository::lookupModuleLmId

(

int

$a_id

)

Definition at line 103 of file ModuleDBRepository.php.

     : int {
        $set = $this->db->query(
            "SELECT lm_id FROM help_module " .
            " WHERE id = " . $this->db->quote($a_id, "integer")
        );
        $rec = $this->db->fetchAssoc($set);
        return (int) $rec["lm_id"];
    }

lookupModuleTitle()

ILIAS\Help\Module\ModuleDBRepository::lookupModuleTitle

(

int

$a_id

)

Definition at line 88 of file ModuleDBRepository.php.

References ilObject\_lookupType().

     : string {

        $set = $this->db->query(
            "SELECT * FROM help_module " .
            " WHERE id = " . $this->db->quote($a_id, "integer")
        );
        $rec = $this->db->fetchAssoc($set);
        if (\ilObject::_lookupType((int) $rec["lm_id"]) === "lm") {
            return \ilObject::_lookupTitle((int) $rec["lm_id"]);
        }
        return "";
    }

Here is the call graph for this function:

saveOrder()

ILIAS\Help\Module\ModuleDBRepository::saveOrder

(

array

$order

)

Definition at line 56 of file ModuleDBRepository.php.

References $id.

                                           : void
    {
        foreach ($order as $id => $order_nr) {
            $this->db->update(
                "help_module",
                [
                "order_nr" => ["integer", (int) $order_nr]
            ],
                [    // where
                    "id" => ["integer", (int) $id]
                ]
            );
        }
    }

writeActive()

ILIAS\Help\Module\ModuleDBRepository::writeActive	(	int	$module_id,
		bool	$active
	)

Definition at line 137 of file ModuleDBRepository.php.

                                                             : void
    {
        $this->db->update(
            "help_module",
            [
            "active" => ["integer", (int) $active]
        ],
            [    // where
                "id" => ["integer", $module_id]
            ]
        );

    }

writeHelpModuleLmId()

ILIAS\Help\Module\ModuleDBRepository::writeHelpModuleLmId	(	int	$a_id,
		int	$a_lm_id
	)

Definition at line 45 of file ModuleDBRepository.php.

     : void {
        $this->db->manipulate(
            "UPDATE help_module SET " .
            " lm_id = " . $this->db->quote($a_lm_id, "integer") .
            " WHERE id = " . $this->db->quote($a_id, "integer")
        );
    }

Field Documentation

$db

ilDBInterface ILIAS\Help\Module\ModuleDBRepository::$db

protected

Definition at line 25 of file ModuleDBRepository.php.

Referenced by ILIAS\Help\Module\ModuleDBRepository\__construct().

---

The documentation for this class was generated from the following file:

• components/ILIAS/Help/Module/ModuleDBRepository.php