Collaboration diagram for ILIAS\Blog\Posting\PostingDBRepository:

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

	create (Posting $posting)

	update (Posting $posting)

	getById (int $id)

	delete (int $id)

	deleteAllBlogPostings (int $blog_id)

	lookupBlogId (int $posting_id)

	getAllByBlog (int $blog_id, int $limit=1000, int $offset=0)

	exists (int $blog_id, int $posting_id)

	getLastPost (int $blog_id)

	searchBlogsByAuthor (int $user_id)

Protected Member Functions
	getPostingFromRecord (array $rec)

Detailed Description

Definition at line 27 of file class.PostingDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Blog\Posting\PostingDBRepository::__construct	(	protected ilDBInterface	$db,
		protected InternalDataService	$data
	)

Definition at line 29 of file class.PostingDBRepository.php.

32 {

33 }

Member Function Documentation

◆ create()

ILIAS\Blog\Posting\PostingDBRepository::create ( Posting $posting )

Definition at line 50 of file class.PostingDBRepository.php.

References $id, ILIAS\Blog\Posting\Posting\Posting\getAuthor(), ILIAS\Blog\Posting\Posting\Posting\getBlogId(), ILIAS\Blog\Posting\Posting\Posting\getCreated(), ILIAS\Blog\Posting\Posting\Posting\getLastWithdrawn(), ILIAS\Blog\Posting\Posting\Posting\getTitle(), IL_CAL_DATETIME, and ILIAS\Blog\Posting\Posting\Posting\isApproved().

                                             : int
     {
         $id = $this->db->nextId('il_blog_posting');
         $this->db->insert('il_blog_posting', [
             'id' => ['integer', $id],
             'blog_id' => ['integer', $posting->getBlogId()],
             'title' => ['text', $posting->getTitle()],
             'created' => ['timestamp', $posting->getCreated()->get(IL_CAL_DATETIME)],
             'author' => ['integer', $posting->getAuthor()],
             'approved' => ['integer', $posting->isApproved()],
             'last_withdrawn' => ['timestamp', $posting->getLastWithdrawn()?->get(IL_CAL_DATETIME)],
         ]);
         return $id;
     }

Here is the call graph for this function:

◆ delete()

ILIAS\Blog\Posting\PostingDBRepository::delete ( int $id )

Definition at line 90 of file class.PostingDBRepository.php.

References $id.

                                    : void
     {
         $this->db->manipulateF(
             'DELETE FROM il_blog_posting WHERE id = %s',
             ['integer'],
             [$id]
         );
     }

◆ deleteAllBlogPostings()

ILIAS\Blog\Posting\PostingDBRepository::deleteAllBlogPostings ( int $blog_id )

Definition at line 99 of file class.PostingDBRepository.php.

                                                        : void
     {
         $this->db->manipulateF(
             'DELETE FROM il_blog_posting WHERE blog_id = %s',
             ['integer'],
             [$blog_id]
         );
     }

◆ exists()

ILIAS\Blog\Posting\PostingDBRepository::exists	(	int	$blog_id,
		int	$posting_id
	)

Definition at line 138 of file class.PostingDBRepository.php.

                                                          : bool
     {
         $set = $this->db->queryF(
             'SELECT id FROM il_blog_posting WHERE blog_id = %s AND id = %s',
             ['integer', 'integer'],
             [$blog_id, $posting_id]
         );
         return $this->db->numRows($set) > 0;
     }

◆ getAllByBlog()

ILIAS\Blog\Posting\PostingDBRepository::getAllByBlog	(	int	$blog_id,
		int	$limit = `1000`,
		int	$offset = `0`
	)

Definition at line 121 of file class.PostingDBRepository.php.

References ILIAS\Blog\Posting\PostingDBRepository\getPostingFromRecord().

Referenced by ILIAS\Blog\Posting\PostingDBRepository\getLastPost().

                                                                                   : array
     {
         if ($limit) {
             $this->db->setLimit($limit, $offset);
         }
         $set = $this->db->queryF(
             'SELECT * FROM il_blog_posting WHERE blog_id = %s ORDER BY created DESC',
             ['integer'],
             [$blog_id]
         );
         $posts = [];
         while ($rec = $this->db->fetchAssoc($set)) {
             $posts[] = $this->getPostingFromRecord($rec);
         }
         return $posts;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getById()

ILIAS\Blog\Posting\PostingDBRepository::getById ( int $id )

Definition at line 77 of file class.PostingDBRepository.php.

References ILIAS\Blog\Posting\PostingDBRepository\getPostingFromRecord(), and null.

                                     : ?Posting
     {
         $set = $this->db->queryF(
             'SELECT * FROM il_blog_posting WHERE id = %s',
             ['integer'],
             [$id]
         );
         if ($rec = $this->db->fetchAssoc($set)) {
             return $this->getPostingFromRecord($rec);
         }
         return null;
     }

Here is the call graph for this function:

◆ getLastPost()

ILIAS\Blog\Posting\PostingDBRepository::getLastPost ( int $blog_id )

Definition at line 148 of file class.PostingDBRepository.php.

References ILIAS\Blog\Posting\PostingDBRepository\getAllByBlog().

                                              : int
     {
         $all = $this->getAllByBlog($blog_id, 1, 0);
         return $all ? $all[0]->getId() : 0;
     }

Here is the call graph for this function:

◆ getPostingFromRecord()

ILIAS\Blog\Posting\PostingDBRepository::getPostingFromRecord ( array $rec )

protected

Definition at line 35 of file class.PostingDBRepository.php.

References IL_CAL_DATETIME, and null.

Referenced by ILIAS\Blog\Posting\PostingDBRepository\getAllByBlog(), and ILIAS\Blog\Posting\PostingDBRepository\getById().

                                                        : Posting
     {
         return $this->data->posting(
             (int) $rec['id'],
             (int) $rec['blog_id'],
             (string) $rec['title'],
             new ilDateTime($rec['created'], IL_CAL_DATETIME),
             (int) $rec['author'],
             (bool) $rec['approved'],
             $rec['last_withdrawn'] !== null
                 ? new ilDateTime($rec['last_withdrawn'], IL_CAL_DATETIME)
                 : null
         );
     }

Here is the caller graph for this function:

◆ lookupBlogId()

ILIAS\Blog\Posting\PostingDBRepository::lookupBlogId ( int $posting_id )

Definition at line 108 of file class.PostingDBRepository.php.

References null.

                                                  : ?int
     {
         $set = $this->db->queryF(
             'SELECT blog_id FROM il_blog_posting WHERE id = %s',
             ['integer'],
             [$posting_id]
         );
         if ($rec = $this->db->fetchAssoc($set)) {
             return (int) $rec['blog_id'];
         }
         return null;
     }

◆ searchBlogsByAuthor()

ILIAS\Blog\Posting\PostingDBRepository::searchBlogsByAuthor ( int $user_id )

Definition at line 154 of file class.PostingDBRepository.php.

References ILIAS\Repository\int().

                                                      : array
     {
         $ids = [];
         $set = $this->db->queryF(
             'SELECT DISTINCT(blog_id) FROM il_blog_posting WHERE author = %s',
             ['integer'],
             [$user_id]
         );
         while ($row = $this->db->fetchAssoc($set)) {
             $ids[] = (int) $row['blog_id'];
         }
         return $ids;
     }

Here is the call graph for this function:

◆ update()

ILIAS\Blog\Posting\PostingDBRepository::update ( Posting $posting )

Definition at line 65 of file class.PostingDBRepository.php.

References ILIAS\Blog\Posting\Posting\Posting\getCreated(), ILIAS\Blog\Posting\Posting\Posting\getId(), ILIAS\Blog\Posting\Posting\Posting\getLastWithdrawn(), ILIAS\Blog\Posting\Posting\Posting\getTitle(), IL_CAL_DATETIME, and ILIAS\Blog\Posting\Posting\Posting\isApproved().

                                             : void
     {
         $this->db->update('il_blog_posting', [
             'title' => ['text', $posting->getTitle()],
             'created' => ['timestamp', $posting->getCreated()->get(IL_CAL_DATETIME)],
             'approved' => ['integer', $posting->isApproved()],
             'last_withdrawn' => ['timestamp', $posting->getLastWithdrawn()?->get(IL_CAL_DATETIME)],
         ], [
             'id' => ['integer', $posting->getId()],
         ]);
     }

Here is the call graph for this function:

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

components/ILIAS/Blog/Posting/class.PostingDBRepository.php

Public Member Functions

Protected Member Functions

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ create()

◆ delete()

◆ deleteAllBlogPostings()

◆ exists()

◆ getAllByBlog()

◆ getById()

◆ getLastPost()

◆ getPostingFromRecord()

◆ lookupBlogId()

◆ searchBlogsByAuthor()

◆ update()