ILIAS\Glossary\Flashcard\FlashcardBoxDBRepository Class Reference

Collaboration diagram for ILIAS\Glossary\Flashcard\FlashcardBoxDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db)
	getEntry (int $box_nr, int $user_id, int $glo_id)
	createOrUpdateEntry (int $box_nr, int $user_id, int $glo_id, string $date)
	deleteEntries (int $glo_id, int $user_id)
	deleteAllUserEntries (int $user_id)
	deleteAllGlossaryEntries (int $glo_id)

Protected Attributes
ilDBInterface	$db

Detailed Description

Author

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

Definition at line 26 of file class.FlashcardBoxDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Glossary\Flashcard\FlashcardBoxDBRepository::__construct

(

\ilDBInterface

$db

)

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

References ILIAS\Glossary\Flashcard\FlashcardBoxDBRepository\$db.

      {
        $this->db = $db;
    }

Member Function Documentation

createOrUpdateEntry()

ILIAS\Glossary\Flashcard\FlashcardBoxDBRepository::createOrUpdateEntry	(	int	$box_nr,
		int	$user_id,
		int	$glo_id,
		string	$date
	)

Definition at line 61 of file class.FlashcardBoxDBRepository.php.

     : void {
        $this->db->replace(
            "glo_flashcard_box",
            [
            "box_nr" => ["integer", $box_nr],
            "user_id" => ["integer", $user_id],
            "glo_id" => ["integer", $glo_id]
            ],
            [
            "last_access" => ["date", $date]
            ]
        );
    }

deleteAllGlossaryEntries()

ILIAS\Glossary\Flashcard\FlashcardBoxDBRepository::deleteAllGlossaryEntries

(

int

$glo_id

)

Definition at line 98 of file class.FlashcardBoxDBRepository.php.

References $q.

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

deleteAllUserEntries()

ILIAS\Glossary\Flashcard\FlashcardBoxDBRepository::deleteAllUserEntries

(

int

$user_id

)

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

References $q.

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

deleteEntries()

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

Definition at line 80 of file class.FlashcardBoxDBRepository.php.

References $q.

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

getEntry()

ILIAS\Glossary\Flashcard\FlashcardBoxDBRepository::getEntry	(	int	$box_nr,
		int	$user_id,
		int	$glo_id
	)

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

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

        $entry = [];
        if ($rec = $this->db->fetchAssoc($set)) {
            $entry = [
                "box_nr" => $rec["box_nr"],
                "user_id" => $rec["user_id"],
                "glo_id" => $rec["glo_id"],
                "last_access" => $rec["last_access"],
            ];
        }

        return $entry;
    }

Field Documentation

$db

ilDBInterface ILIAS\Glossary\Flashcard\FlashcardBoxDBRepository::$db

protected

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

Referenced by ILIAS\Glossary\Flashcard\FlashcardBoxDBRepository\__construct().

---

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

• Modules/Glossary/Flashcard/class.FlashcardBoxDBRepository.php