ILIAS\Glossary\Flashcard\FlashcardTermDBRepository Class Reference

Collaboration diagram for ILIAS\Glossary\Flashcard\FlashcardTermDBRepository:

Public Member Functions
	__construct (protected \ilDBInterface $db, protected InternalDataService $data_service)
	getEntry (int $term_id, int $user_id, int $glo_id)
	getUserEntriesForBox (int $box_nr, int $user_id, int $glo_id)
	getAllUserEntries (int $user_id, int $glo_id)
	createEntry (Term $term)
	updateEntry (Term $term)
	deleteEntries (int $glo_id, int $user_id)
	deleteAllUserEntries (int $user_id)
	deleteAllGlossaryEntries (int $glo_id)
	deleteAllTermEntries (int $term_id)

Protected Member Functions
	getFromRecord (array $rec)

Detailed Description

Author

Thomas Famula famul.nosp@m.a@le.nosp@m.ifos..nosp@m.de

Definition at line 28 of file class.FlashcardTermDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::__construct	(	protected \ilDBInterface	$db,
		protected InternalDataService	$data_service
	)

Definition at line 30 of file class.FlashcardTermDBRepository.php.

      {
    }

Member Function Documentation

createEntry()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::createEntry

(

Term

$term

)

Definition at line 113 of file class.FlashcardTermDBRepository.php.

References ILIAS\Glossary\Flashcard\Term\getBoxNr(), ILIAS\Glossary\Flashcard\Term\getGloId(), ILIAS\Glossary\Flashcard\Term\getLastAccess(), ILIAS\Glossary\Flashcard\Term\getTermId(), and ILIAS\Glossary\Flashcard\Term\getUserId().

     : void {
        $this->db->insert("glo_flashcard_term", [
            "term_id" => ["integer", $term->getTermId()],
            "user_id" => ["integer", $term->getUserId()],
            "glo_id" => ["integer", $term->getGloId()],
            "last_access" => ["date", $term->getLastAccess()],
            "box_nr" => ["integer", $term->getBoxNr()]
        ]);
    }

Here is the call graph for this function:

deleteAllGlossaryEntries()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::deleteAllGlossaryEntries

(

int

$glo_id

)

Definition at line 156 of file class.FlashcardTermDBRepository.php.

References $q.

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

deleteAllTermEntries()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::deleteAllTermEntries

(

int

$term_id

)

Definition at line 164 of file class.FlashcardTermDBRepository.php.

References $q.

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

deleteAllUserEntries()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::deleteAllUserEntries

(

int

$user_id

)

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

References $q.

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

deleteEntries()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::deleteEntries	(	int	$glo_id,
		int	$user_id
	)

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

References $q.

     : void {
        $q = "DELETE FROM glo_flashcard_term " .
            " WHERE glo_id = " . $this->db->quote($glo_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer");
        $this->db->manipulate($q);
    }

getAllUserEntries()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::getAllUserEntries	(	int	$user_id,
		int	$glo_id
	)

Returns

Term[]

Definition at line 93 of file class.FlashcardTermDBRepository.php.

References ILIAS\Glossary\Flashcard\FlashcardTermDBRepository\getFromRecord().

     : array {
        $set = $this->db->queryF(
            "SELECT * FROM glo_flashcard_term " .
            " WHERE user_id = %s AND glo_id = %s " .
            " ORDER BY last_access ASC ",
            ["integer", "integer"],
            [$user_id, $glo_id]
        );

        $entries = [];
        while ($rec = $this->db->fetchAssoc($set)) {
            $entries[] = $this->getFromRecord($rec);
        }

        return $entries;
    }

Here is the call graph for this function:

getEntry()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::getEntry	(	int	$term_id,
		int	$user_id,
		int	$glo_id
	)

Definition at line 47 of file class.FlashcardTermDBRepository.php.

References ILIAS\Glossary\Flashcard\FlashcardTermDBRepository\getFromRecord(), and null.

     : ?Term {
        $set = $this->db->queryF(
            "SELECT * FROM glo_flashcard_term " .
            " WHERE term_id = %s AND user_id = %s AND glo_id = %s ",
            ["integer", "integer", "integer"],
            [$term_id, $user_id, $glo_id]
        );

        if ($rec = $this->db->fetchAssoc($set)) {
            return $this->getFromRecord($rec);
        }

        return null;
    }

Here is the call graph for this function:

getFromRecord()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::getFromRecord ( array  $rec )

protected

Definition at line 36 of file class.FlashcardTermDBRepository.php.

Referenced by ILIAS\Glossary\Flashcard\FlashcardTermDBRepository\getAllUserEntries(), ILIAS\Glossary\Flashcard\FlashcardTermDBRepository\getEntry(), and ILIAS\Glossary\Flashcard\FlashcardTermDBRepository\getUserEntriesForBox().

                                                : Term
    {
        return $this->data_service->flashcardTerm(
            (int) $rec["term_id"],
            (int) $rec["user_id"],
            (int) $rec["glo_id"],
            (int) $rec["box_nr"],
            $rec["last_access"]
        );
    }

Here is the caller graph for this function:

getUserEntriesForBox()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::getUserEntriesForBox	(	int	$box_nr,
		int	$user_id,
		int	$glo_id
	)

Returns

Term[]

Definition at line 69 of file class.FlashcardTermDBRepository.php.

References ILIAS\Glossary\Flashcard\FlashcardTermDBRepository\getFromRecord().

     : array {
        $set = $this->db->queryF(
            "SELECT * FROM glo_flashcard_term " .
            " WHERE box_nr = %s AND user_id = %s AND glo_id = %s " .
            " ORDER BY last_access ASC ",
            ["integer", "integer", "integer"],
            [$box_nr, $user_id, $glo_id]
        );

        $entries = [];
        while ($rec = $this->db->fetchAssoc($set)) {
            $entries[] = $this->getFromRecord($rec);
        }

        return $entries;
    }

Here is the call graph for this function:

updateEntry()

ILIAS\Glossary\Flashcard\FlashcardTermDBRepository::updateEntry

(

Term

$term

)

Definition at line 125 of file class.FlashcardTermDBRepository.php.

References ILIAS\Glossary\Flashcard\Term\getBoxNr(), ILIAS\Glossary\Flashcard\Term\getGloId(), ILIAS\Glossary\Flashcard\Term\getLastAccess(), ILIAS\Glossary\Flashcard\Term\getTermId(), and ILIAS\Glossary\Flashcard\Term\getUserId().

     : void {
        $this->db->update("glo_flashcard_term", [
            "last_access" => ["date", $term->getLastAccess()],
            "box_nr" => ["integer", $term->getBoxNr()]
        ], [
            "term_id" => ["integer", $term->getTermId()],
            "user_id" => ["integer", $term->getUserId()],
            "glo_id" => ["integer", $term->getGloId()]
        ]);
    }

Here is the call graph for this function:

---

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

• components/ILIAS/Glossary/Flashcard/class.FlashcardTermDBRepository.php