Collaboration diagram for ILIAS\Wiki\Page\PageDBRepository:

Public Member Functions
	__construct (InternalDataService $data, \ilDBInterface $db)

	delete ($id, $lang="-")

	getWikiPages (int $wiki_id, string $lang="-")

	getMasterPagesWithoutTranslation (int $wiki_id, string $trans)

	getAllPagesInfo (int $wiki_id)
	Queries last change and user per page regardless of language. More...

	getInfoOfSelected ($wiki_id, array $ids, $lang="-")

	getRecentChanges (int $wiki_id, int $period=30)
	Queries last change and user per page regardless of language. More...

	getNewPages (int $wiki_id)

	getPopularPages (int $a_wiki_id)

	getLanguages (int $wpg_id)

	doesAtLeastOnePageExist (int $wiki_id, array $ids)

	getPageIdForTitle (int $wiki_id, string $title, string $lang="-")

	existsByTitle (int $wiki_id, string $title, string $lang="-")

	exists (int $id, string $lang="-")

	getTitle (int $id, string $lang="-")

	getWikiIdByPageId (int $id)

Protected Member Functions
	getPageFromRecord (array $rec)

	getPageInfoFromRecord (array $rec)

Protected Attributes
InternalDataService	$data

ilDBInterface	$db

Detailed Description

Wiki page repo.

Definition at line 28 of file PageDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Wiki\Page\PageDBRepository::__construct	(	InternalDataService	$data,
		\ilDBInterface	$db
	)

Definition at line 33 of file PageDBRepository.php.

References ILIAS\Wiki\Page\PageDBRepository\$data, and ILIAS\Wiki\Page\PageDBRepository\$db.

       {
         $this->data = $data;
         $this->db = $db;
     }

Member Function Documentation

◆ delete()

ILIAS\Wiki\Page\PageDBRepository::delete	(	$id,
		$lang = `"-"`
	)

Definition at line 41 of file PageDBRepository.php.

References $id, and ilDBInterface\quote().

                                             : void
     {
         $and = in_array($lang, ["", "-"])
             ? ""
             : " AND lang = " . $this->db->quote($lang, "text");
         $query = "DELETE FROM il_wiki_page" .
             " WHERE id = " . $this->db->quote($id, "integer") .
             $and;
         $this->db->manipulate($query);
     }

Here is the call graph for this function:

◆ doesAtLeastOnePageExist()

ILIAS\Wiki\Page\PageDBRepository::doesAtLeastOnePageExist	(	int	$wiki_id,
		array	$ids
	)

Definition at line 238 of file PageDBRepository.php.

                                                                      : bool
     {
         // cross check existence of sources in il_wiki_page
         $query = "SELECT count(*) cnt FROM il_wiki_page" .
             " WHERE " . $this->db->in("id", $ids, false, "integer") .
             " AND wiki_id = " . $this->db->quote($wiki_id, "integer") .
             " GROUP BY wiki_id";
         $set = $this->db->query($query);
         $rec = $this->db->fetchAssoc($set);
         return ((int) $rec["cnt"]) > 0;
     }

◆ exists()

ILIAS\Wiki\Page\PageDBRepository::exists	(	int	$id,
		string	$lang = `"-"`
	)

Definition at line 285 of file PageDBRepository.php.

Referenced by ILIAS\Wiki\Page\PageDBRepository\existsByTitle().

      : bool {
         if ($lang === "") {
             $lang = "-";
         }
         $query = "SELECT w.id FROM il_wiki_page w " .
             " JOIN page_object p ON (w.id = p.page_id AND w.lang = p.lang) " .
             " WHERE w.id = " . $this->db->quote($id, "integer") .
             " AND w.lang = " . $this->db->quote($lang, "text");
         $set = $this->db->query($query);
         if ($rec = $this->db->fetchAssoc($set)) {
             return true;
         }
         return false;
     }

Here is the caller graph for this function:

◆ existsByTitle()

ILIAS\Wiki\Page\PageDBRepository::existsByTitle	(	int	$wiki_id,
		string	$title,
		string	$lang = `"-"`
	)

Definition at line 273 of file PageDBRepository.php.

References $id, ILIAS\Wiki\Page\PageDBRepository\exists(), and ILIAS\Wiki\Page\PageDBRepository\getPageIdForTitle().

      : bool {
         $id = $this->getPageIdForTitle($wiki_id, $title, $lang);
         if (is_null($id)) {
             return false;
         }
         return $this->exists($id, $lang);
     }

Here is the call graph for this function:

◆ getAllPagesInfo()

ILIAS\Wiki\Page\PageDBRepository::getAllPagesInfo ( int $wiki_id )

Queries last change and user per page regardless of language.

Returns: iterable<PageInfo>

Definition at line 117 of file PageDBRepository.php.

References ILIAS\Wiki\Page\PageDBRepository\getPageInfoFromRecord(), and ILIAS\Repository\int().

                                                  : \Iterator
     {
         $set = $this->db->queryF(
             "SELECT w.id, p.last_change_user, p.last_change, w.title " . "FROM page_object p JOIN il_wiki_page w " .
             " ON (w.wiki_id = %s AND p.parent_type = %s AND p.page_id = w.id AND w.lang = %s) " .
             " JOIN ( select page_id, max(last_change) mlc FROM page_object " .
             " WHERE parent_type='wpg' group by page_id) mp " .
             " ON (mp.page_id = p.page_id AND mp.mlc = p.last_change)",
             ["integer", "string", "string"],
             [$wiki_id, "wpg", "-"]
         );
         $ids = [];
         while ($rec = $this->db->fetchAssoc($set)) {
             // note: the query may get multiple entries for a page id, if multiple
             // languages share the same max(last_change). We only return one.
             if (isset($ids[(int) $rec["id"]])) {
                 continue;
             }
             $ids[(int) $rec["id"]] = (int) $rec["id"];
             yield $this->getPageInfoFromRecord($rec);
         }
     }

Here is the call graph for this function:

◆ getInfoOfSelected()

ILIAS\Wiki\Page\PageDBRepository::getInfoOfSelected	(		$wiki_id,
		array	$ids,
			$lang = `"-"`
	)

Definition at line 140 of file PageDBRepository.php.

References ILIAS\Wiki\Page\PageDBRepository\getPageInfoFromRecord().

                                                                         : \Iterator
     {
         $query = "SELECT wp.id, p.last_change_user, p.last_change, wp.title, wp.lang " .
             " FROM il_wiki_page wp JOIN page_object p " .
             " ON (wp.id = p.page_id AND wp.lang = p.lang) " .
             " WHERE " . $this->db->in("wp.id", $ids, false, "integer") .
             " AND p.parent_type = " . $this->db->quote("wpg", "text") .
             " AND wp.wiki_id = " . $this->db->quote($wiki_id, "integer") .
             " AND wp.lang = " . $this->db->quote($lang, "text") .
             " ORDER BY title";
         $set = $this->db->query($query);
 
         while ($rec = $this->db->fetchAssoc($set)) {
             yield $this->getPageInfoFromRecord($rec);
         }
     }

Here is the call graph for this function:

◆ getLanguages()

ILIAS\Wiki\Page\PageDBRepository::getLanguages ( int $wpg_id )

Returns: string[]

Definition at line 223 of file PageDBRepository.php.

                                              : array
     {
         $set = $this->db->queryF(
             "SELECT DISTINCT lang FROM  " .
             " il_wiki_page WHERE id = %s AND lang <> '-' ",
             ["integer"],
             [$wpg_id]
         );
         $langs = [];
         while ($rec = $this->db->fetchAssoc($set)) {
             $langs[] = $rec["lang"];
         }
         return $langs;
     }

◆ getMasterPagesWithoutTranslation()

ILIAS\Wiki\Page\PageDBRepository::getMasterPagesWithoutTranslation	(	int	$wiki_id,
		string	$trans
	)

Returns: iterable<Page>

Definition at line 99 of file PageDBRepository.php.

References ILIAS\Wiki\Page\PageDBRepository\getPageFromRecord().

                                                                                  : \Iterator
     {
         $set = $this->db->queryF(
             "SELECT w1.* FROM il_wiki_page w1 LEFT JOIN il_wiki_page w2 " .
             " ON w1.id = w2.id AND w2.lang = %s " .
             " WHERE w1.lang = %s AND w1.wiki_id = %s AND w2.id IS NULL ORDER BY w1.title",
             ["string", "string", "integer"],
             [$trans, "-", $wiki_id]
         );
         while ($rec = $this->db->fetchAssoc($set)) {
             yield $this->getPageFromRecord($rec);
         }
     }

Here is the call graph for this function:

◆ getNewPages()

ILIAS\Wiki\Page\PageDBRepository::getNewPages ( int $wiki_id )

Returns: iterable<PageInfo>

Definition at line 186 of file PageDBRepository.php.

References ILIAS\Wiki\Page\PageDBRepository\getPageInfoFromRecord().

                                              : \Iterator
     {
         $set = $this->db->queryF(
             "SELECT w.id, p.created, p.create_user, w.title, w.lang FROM page_object p " .
             " JOIN il_wiki_page w " .
             " ON w.id = p.page_id AND p.parent_type = %s AND w.lang = p.lang AND w.wiki_id = %s " .
             " ORDER BY created DESC",
             ["string", "integer"],
             ["wpg", $wiki_id]
         );
         while ($rec = $this->db->fetchAssoc($set)) {
             yield $this->getPageInfoFromRecord($rec);
         }
     }

Here is the call graph for this function:

◆ getPageFromRecord()

ILIAS\Wiki\Page\PageDBRepository::getPageFromRecord ( array $rec )

protected

Definition at line 52 of file PageDBRepository.php.

Referenced by ILIAS\Wiki\Page\PageDBRepository\getMasterPagesWithoutTranslation(), and ILIAS\Wiki\Page\PageDBRepository\getWikiPages().

                                                     : Page
     {
         return $this->data->page(
             (int) $rec["id"],
             (int) $rec["wiki_id"],
             $rec["title"],
             $rec["lang"],
             (bool) $rec["blocked"],
             (bool) $rec["rating"],
             (bool) $rec["hide_adv_md"]
         );
     }

Here is the caller graph for this function:

◆ getPageIdForTitle()

ILIAS\Wiki\Page\PageDBRepository::getPageIdForTitle	(	int	$wiki_id,
		string	$title,
		string	$lang = `"-"`
	)

Definition at line 250 of file PageDBRepository.php.

References ilWikiUtil\makeDbTitle(), and null.

Referenced by ILIAS\Wiki\Page\PageDBRepository\existsByTitle().

      : ?int {
         if ($lang === "") {
             $lang = "-";
         }
         $title = \ilWikiUtil::makeDbTitle($title);
 
         $query = "SELECT w.id  FROM il_wiki_page w " .
             " JOIN page_object p ON (w.id = p.page_id AND w.lang = p.lang) " .
             " WHERE w.wiki_id = " . $this->db->quote($wiki_id, "integer") .
             " AND w.title = " . $this->db->quote($title, "text") .
             " AND w.lang = " . $this->db->quote($lang, "text");
         $set = $this->db->query($query);
         if ($rec = $this->db->fetchAssoc($set)) {
             return (int) $rec["id"];
         }
 
         return null;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getPageInfoFromRecord()

ILIAS\Wiki\Page\PageDBRepository::getPageInfoFromRecord ( array $rec )

protected

Definition at line 65 of file PageDBRepository.php.

Referenced by ILIAS\Wiki\Page\PageDBRepository\getAllPagesInfo(), ILIAS\Wiki\Page\PageDBRepository\getInfoOfSelected(), ILIAS\Wiki\Page\PageDBRepository\getNewPages(), ILIAS\Wiki\Page\PageDBRepository\getPopularPages(), and ILIAS\Wiki\Page\PageDBRepository\getRecentChanges().

                                                         : PageInfo
     {
         return $this->data->pageInfo(
             (int) $rec["id"],
             $rec["lang"] ?? "",
             $rec["title"],
             (int) ($rec["last_change_user"] ?? 0),
             $rec["last_change"] ?? "",
             (int) ($rec["create_user"] ?? 0),
             $rec["created"] ?? "",
             (int) ($rec["cnt"] ?? 0),
             (int) ($rec["nr"] ?? 0)
         );
     }

Here is the caller graph for this function:

◆ getPopularPages()

ILIAS\Wiki\Page\PageDBRepository::getPopularPages ( int $a_wiki_id )

Returns: iterable<PageInfo>

Definition at line 204 of file PageDBRepository.php.

References ILIAS\Wiki\Page\PageDBRepository\getPageInfoFromRecord().

      : \Iterator {
 
         $query = "SELECT wp.id, wp.title, wp.lang, po.view_cnt as cnt FROM il_wiki_page wp JOIN page_object po" .
             " ON (wp.id = po.page_id AND wp.lang = po.lang) " .
             " WHERE wp.wiki_id = " . $this->db->quote($a_wiki_id, "integer") .
             " AND po.parent_type = " . $this->db->quote("wpg", "text") . " " .
             " ORDER BY po.view_cnt";
         $set = $this->db->query($query);
 
         while ($rec = $this->db->fetchAssoc($set)) {
             yield $this->getPageInfoFromRecord($rec);
         }
     }

Here is the call graph for this function:

◆ getRecentChanges()

ILIAS\Wiki\Page\PageDBRepository::getRecentChanges	(	int	$wiki_id,
		int	$period = `30`
	)

Queries last change and user per page regardless of language.

Returns: iterable<PageInfo>

Definition at line 161 of file PageDBRepository.php.

References $q, and ILIAS\Wiki\Page\PageDBRepository\getPageInfoFromRecord().

      : \Iterator {
         $limit_ts = date('Y-m-d H:i:s', time() - ($period * 24 * 60 * 60));
         $q1 = "SELECT w.id, p.last_change_user, p.last_change, w.title, w.lang, 0 nr FROM page_object p " .
             " JOIN il_wiki_page w ON (w.id = p.page_id AND p.parent_type = %s AND w.lang = p.lang AND w.wiki_id = %s) " .
             " WHERE p.last_change >= " . $this->db->quote($limit_ts, "timestamp");
         $q2 = "SELECT w.id, p.user_id last_change_user, p.hdate last_change, w.title, w.lang, p.nr FROM page_history p " .
             " JOIN il_wiki_page w ON (w.id = p.page_id AND p.parent_type = %s AND w.lang = p.lang AND w.wiki_id = %s) " .
             " WHERE p.hdate >= " . $this->db->quote($limit_ts, "timestamp");
         $q = $q1 . " UNION " . $q2 . " ORDER BY last_change DESC ";
         $set = $this->db->queryF(
             $q,
             ["string", "integer", "string", "integer"],
             ["wpg", $wiki_id,"wpg", $wiki_id]
         );
         while ($rec = $this->db->fetchAssoc($set)) {
             yield $this->getPageInfoFromRecord($rec);
         }
     }

Here is the call graph for this function:

◆ getTitle()

ILIAS\Wiki\Page\PageDBRepository::getTitle	(	int	$id,
		string	$lang = `"-"`
	)

Definition at line 303 of file PageDBRepository.php.

      : string {
         if ($lang === "") {
             $lang = "-";
         }
         $query = "SELECT title FROM il_wiki_page " .
             " WHERE id = " . $this->db->quote($id, "integer") .
             " AND lang = " . $this->db->quote($lang, "text");
         $set = $this->db->query($query);
         if ($rec = $this->db->fetchAssoc($set)) {
             return $rec["title"];
         }
         return "";
     }

◆ getWikiIdByPageId()

ILIAS\Wiki\Page\PageDBRepository::getWikiIdByPageId ( int $id )

Definition at line 320 of file PageDBRepository.php.

References null.

      : ?int {
         $query = "SELECT wiki_id FROM il_wiki_page" .
             " WHERE id = " . $this->db->quote($id, "integer") .
             " AND lang = " . $this->db->quote('-', "text");
         $set = $this->db->query($query);
         if ($rec = $this->db->fetchAssoc($set)) {
             return (int) $rec["wiki_id"];
         }
         return null;
     }

◆ getWikiPages()

ILIAS\Wiki\Page\PageDBRepository::getWikiPages	(	int	$wiki_id,
		string	$lang = `"-"`
	)

Returns: iterable<Page>

Definition at line 83 of file PageDBRepository.php.

References ILIAS\Wiki\Page\PageDBRepository\getPageFromRecord().

                                                                   : \Iterator
     {
         $set = $this->db->queryF(
             "SELECT * FROM il_wiki_page  " .
             " WHERE lang = %s AND wiki_id = %s ORDER BY title",
             ["string", "integer"],
             [$lang, $wiki_id]
         );
         while ($rec = $this->db->fetchAssoc($set)) {
             yield $this->getPageFromRecord($rec);
         }
     }

Here is the call graph for this function:

Field Documentation

◆ $data

InternalDataService ILIAS\Wiki\Page\PageDBRepository::$data

protected

Definition at line 30 of file PageDBRepository.php.

Referenced by ILIAS\Wiki\Page\PageDBRepository\__construct().

◆ $db

ilDBInterface ILIAS\Wiki\Page\PageDBRepository::$db

protected

Definition at line 31 of file PageDBRepository.php.

Referenced by ILIAS\Wiki\Page\PageDBRepository\__construct().

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

components/ILIAS/Wiki/Page/PageDBRepository.php

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ delete()

◆ doesAtLeastOnePageExist()

◆ exists()

◆ existsByTitle()

◆ getAllPagesInfo()

◆ getInfoOfSelected()

◆ getLanguages()

◆ getMasterPagesWithoutTranslation()

◆ getNewPages()

◆ getPageFromRecord()

◆ getPageIdForTitle()

◆ getPageInfoFromRecord()

◆ getPopularPages()

◆ getRecentChanges()

◆ getTitle()

◆ getWikiIdByPageId()

◆ getWikiPages()

Field Documentation

◆ $data

◆ $db