ILIAS\Help\Tooltips\TooltipsDBRepository Class Reference

Collaboration diagram for ILIAS\Help\Tooltips\TooltipsDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db)
	getTooltipPresentationText (string $a_tt_id, array $module_ids)
	getAllTooltips (string $a_comp="", int $a_module_id=0)
	addTooltip (string $a_tt_id, string $a_text, int $a_module_id=0)
	updateTooltip (int $a_id, string $a_text, string $a_tt_id)
	getTooltipComponents (int $a_module_id=0)
	Get all tooltip components. More...
	deleteTooltip (int $a_id)
	deleteTooltipsOfModule (int $a_id)

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 23 of file TooltipsDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Help\Tooltips\TooltipsDBRepository::__construct

(

\ilDBInterface

$db

)

Definition at line 27 of file TooltipsDBRepository.php.

      {
        $this->db = $db;
    }

References ILIAS\Help\Tooltips\TooltipsDBRepository\$db.

Member Function Documentation

addTooltip()

ILIAS\Help\Tooltips\TooltipsDBRepository::addTooltip	(	string	$a_tt_id,
		string	$a_text,
		int	$a_module_id = 0
	)

Definition at line 95 of file TooltipsDBRepository.php.

     : void {
        $fu = strpos($a_tt_id, "_");
        $comp = substr($a_tt_id, 0, $fu);
 
        $nid = $this->db->nextId("help_tooltip");
        $this->db->manipulate("INSERT INTO help_tooltip " .
            "(id, tt_text, tt_id, comp,module_id) VALUES (" .
            $this->db->quote($nid, "integer") . "," .
            $this->db->quote($a_text, "text") . "," .
            $this->db->quote($a_tt_id, "text") . "," .
            $this->db->quote($comp, "text") . "," .
            $this->db->quote($a_module_id, "integer") .
            ")");
    }

deleteTooltip()

ILIAS\Help\Tooltips\TooltipsDBRepository::deleteTooltip

(

int

$a_id

)

Definition at line 148 of file TooltipsDBRepository.php.

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

deleteTooltipsOfModule()

ILIAS\Help\Tooltips\TooltipsDBRepository::deleteTooltipsOfModule

(

int

$a_id

)

Definition at line 157 of file TooltipsDBRepository.php.

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

getAllTooltips()

ILIAS\Help\Tooltips\TooltipsDBRepository::getAllTooltips	(	string	$a_comp = "",
		int	$a_module_id = 0
	)

Definition at line 77 of file TooltipsDBRepository.php.

     : array {
        $q = "SELECT * FROM help_tooltip";
        $q .= " WHERE module_id = " . $this->db->quote($a_module_id, "integer");
        if ($a_comp !== "") {
            $q .= " AND comp = " . $this->db->quote($a_comp, "text");
        }
        $set = $this->db->query($q);
        $tts = array();
        while ($rec = $this->db->fetchAssoc($set)) {
            $tts[$rec["id"]] = array("id" => $rec["id"], "text" => $rec["tt_text"],
                                     "tt_id" => $rec["tt_id"]);
        }
        return $tts;
    }

References $q.

getTooltipComponents()

ILIAS\Help\Tooltips\TooltipsDBRepository::getTooltipComponents

(

int

$a_module_id = 0

)

Get all tooltip components.

Definition at line 135 of file TooltipsDBRepository.php.

     : array {
        $set = $this->db->query("SELECT DISTINCT comp FROM help_tooltip " .
            " WHERE module_id = " . $this->db->quote($a_module_id, "integer") .
            " ORDER BY comp ");
        $comps = [];
        while ($rec = $this->db->fetchAssoc($set)) {
            $comps[] = $rec["comp"];
        }
        return $comps;
    }

getTooltipPresentationText()

ILIAS\Help\Tooltips\TooltipsDBRepository::getTooltipPresentationText	(	string	$a_tt_id,
		array	$module_ids
	)

Definition at line 33 of file TooltipsDBRepository.php.

     : string {
        $set = $this->db->query(
            $q =
            "SELECT tt.tt_text FROM help_tooltip tt LEFT JOIN help_module hmod " .
            " ON (tt.module_id = hmod.id) " .
            " WHERE tt.tt_id = " . $this->db->quote($a_tt_id, "text") .
            " AND " . $this->db->in("tt.module_id", $module_ids, false, "integer") .
            " ORDER BY hmod.order_nr "
        );
        $rec = $this->db->fetchAssoc($set);
        if (is_array($rec) && $rec["tt_text"] != "") {
            $t = $rec["tt_text"];
            if (count($module_ids) === 1 && current($module_ids) === 0) {
                $t .= "<br/><i>(" . $a_tt_id . ")</i>";
            }
            return $t;
        } else { // try to get general version
            $fu = (int) strpos($a_tt_id, "_");
            $gen_tt_id = "*" . substr($a_tt_id, $fu);
            $set = $this->db->query(
                "SELECT tt.tt_text FROM help_tooltip tt LEFT JOIN help_module hmod " .
                " ON (tt.module_id = hmod.id) " .
                " WHERE tt.tt_id = " . $this->db->quote($gen_tt_id, "text") .
                " AND " . $this->db->in("tt.module_id", $module_ids, false, "integer") .
                " ORDER BY hmod.order_nr "
            );
            $rec = $this->db->fetchAssoc($set);
            if (is_array($rec) && $rec["tt_text"] != "") {
                $t = $rec["tt_text"];
                if (count($module_ids) === 1 && current($module_ids) === 0) {
                    $t .= "<br/><i>(" . $a_tt_id . ")</i>";
                }
                return $t;
            }
        }
        if (count($module_ids) === 1 && current($module_ids) === 0) {
            return "<i>" . $a_tt_id . "</i>";
        }
        return "";
    }

updateTooltip()

ILIAS\Help\Tooltips\TooltipsDBRepository::updateTooltip	(	int	$a_id,
		string	$a_text,
		string	$a_tt_id
	)

Definition at line 114 of file TooltipsDBRepository.php.

     : void {
        $fu = strpos($a_tt_id, "_");
        $comp = substr($a_tt_id, 0, $fu);
 
        $this->db->manipulate(
            "UPDATE help_tooltip SET " .
            " tt_text = " . $this->db->quote($a_text, "text") . ", " .
            " tt_id = " . $this->db->quote($a_tt_id, "text") . ", " .
            " comp = " . $this->db->quote($comp, "text") .
            " WHERE id = " . $this->db->quote($a_id, "integer")
        );
    }

Field Documentation

$db

ilDBInterface ILIAS\Help\Tooltips\TooltipsDBRepository::$db

protected

Definition at line 25 of file TooltipsDBRepository.php.

Referenced by ILIAS\Help\Tooltips\TooltipsDBRepository\__construct().

---

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

• components/ILIAS/Help/Tooltips/TooltipsDBRepository.php