ilTermsOfServiceAcceptanceDatabaseGateway Class Reference

Class ilTermsOfServiceAcceptanceDatabaseGateway. More...

Inheritance diagram for ilTermsOfServiceAcceptanceDatabaseGateway:

Collaboration diagram for ilTermsOfServiceAcceptanceDatabaseGateway:

Public Member Functions
	__construct (\ilDBInterface $db)
	ilTermsOfServiceAcceptanceDatabaseGateway constructor. More...
	trackAcceptance (\ilTermsOfServiceAcceptanceEntity $entity)
	Parameters \ilTermsOfServiceAcceptanceEntity $entity More...
	loadCurrentAcceptanceOfUser (\ilTermsOfServiceAcceptanceEntity $entity)
	Parameters \ilTermsOfServiceAcceptanceEntity $entity Returns More...
	loadById (\ilTermsOfServiceAcceptanceEntity $entity)
	Parameters \ilTermsOfServiceAcceptanceEntity $entity Returns mixed More...
	deleteAcceptanceHistoryByUser (\ilTermsOfServiceAcceptanceEntity $entity)
	Parameters \ilTermsOfServiceAcceptanceEntity $entity More...

Protected Attributes
	$db

Detailed Description

Class ilTermsOfServiceAcceptanceDatabaseGateway.

Author

Michael Jansen mjans.nosp@m.en@d.nosp@m.ataba.nosp@m.y.de

Definition at line 8 of file class.ilTermsOfServiceAcceptanceDatabaseGateway.php.

Constructor & Destructor Documentation

__construct()

ilTermsOfServiceAcceptanceDatabaseGateway::__construct

(

\ilDBInterface

$db

)

ilTermsOfServiceAcceptanceDatabaseGateway constructor.

Parameters

\ilDBInterface

$db

Definition at line 17 of file class.ilTermsOfServiceAcceptanceDatabaseGateway.php.

References $db.

    {
        $this->db = $db;
    }

Member Function Documentation

deleteAcceptanceHistoryByUser()

ilTermsOfServiceAcceptanceDatabaseGateway::deleteAcceptanceHistoryByUser

(

\ilTermsOfServiceAcceptanceEntity

$entity

)

Parameters

\ilTermsOfServiceAcceptanceEntity

$entity

Implements ilTermsOfServiceAcceptanceDataGateway.

Definition at line 127 of file class.ilTermsOfServiceAcceptanceDatabaseGateway.php.

References ilTermsOfServiceAcceptanceEntity\getUserId().

    {
        $this->db->manipulate(
            'DELETE FROM tos_acceptance_track WHERE usr_id = ' . $this->db->quote($entity->getUserId(), 'integer')
        );
    }

Here is the call graph for this function:

loadById()

ilTermsOfServiceAcceptanceDatabaseGateway::loadById

(

\ilTermsOfServiceAcceptanceEntity

$entity

)

Parameters

\ilTermsOfServiceAcceptanceEntity

$entity

Returns

mixed

Implements ilTermsOfServiceAcceptanceDataGateway.

Definition at line 101 of file class.ilTermsOfServiceAcceptanceDatabaseGateway.php.

References $res, $row, ilTermsOfServiceAcceptanceEntity\getId(), and ilTermsOfServiceAcceptanceEntity\withId().

                                                                        : \ilTermsOfServiceAcceptanceEntity
    {
        $res = $this->db->queryF(
            '
                        SELECT *
                        FROM tos_versions
                        WHERE id = %s
                        ',
            array('integer'),
            array($entity->getId())
        );
        $row = $this->db->fetchAssoc($res);

        $entity = $entity
            ->withId($row['id'])
            ->withText($row['text'])
            ->withHash($row['hash'])
            ->withDocumentId($row['doc_id'])
            ->withTitle($row['title']);

        return $entity;
    }

Here is the call graph for this function:

loadCurrentAcceptanceOfUser()

ilTermsOfServiceAcceptanceDatabaseGateway::loadCurrentAcceptanceOfUser

(

\ilTermsOfServiceAcceptanceEntity

$entity

)

Parameters

\ilTermsOfServiceAcceptanceEntity

$entity

Returns

Implements ilTermsOfServiceAcceptanceDataGateway.

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

References $res, $row, ilTermsOfServiceAcceptanceEntity\getUserId(), and ilTermsOfServiceAcceptanceEntity\withId().

                                                                                           : \ilTermsOfServiceAcceptanceEntity
    {
        $this->db->setLimit(1, 0);

        $res = $this->db->queryF(
            '
                        SELECT tos_versions.*,
                                tos_acceptance_track.ts accepted_ts,
                                tos_acceptance_track.criteria,
                                tos_acceptance_track.usr_id
                        FROM tos_acceptance_track
                        INNER JOIN tos_versions ON id = tosv_id
                        WHERE usr_id = %s
                        ORDER BY tos_acceptance_track.ts DESC
                        ',
            ['integer'],
            [$entity->getUserId()]
        );
        $row = $this->db->fetchAssoc($res);

        $entity = $entity
            ->withId((int) $row['id'])
            ->withUserId((int) $row['usr_id'])
            ->withText((string) $row['text'])
            ->withTimestamp((int) $row['accepted_ts'])
            ->withHash((string) $row['hash'])
            ->withDocumentId((int) $row['doc_id'])
            ->withTitle((string) $row['title'])
            ->withSerializedCriteria((string) $row['criteria']);

        return $entity;
    }

Here is the call graph for this function:

trackAcceptance()

ilTermsOfServiceAcceptanceDatabaseGateway::trackAcceptance

(

\ilTermsOfServiceAcceptanceEntity

$entity

)

Parameters

\ilTermsOfServiceAcceptanceEntity

$entity

Implements ilTermsOfServiceAcceptanceDataGateway.

Definition at line 25 of file class.ilTermsOfServiceAcceptanceDatabaseGateway.php.

References $res, $row, ilTermsOfServiceAcceptanceEntity\getDocumentId(), ilTermsOfServiceAcceptanceEntity\getHash(), ilTermsOfServiceAcceptanceEntity\getSerializedCriteria(), ilTermsOfServiceAcceptanceEntity\getText(), ilTermsOfServiceAcceptanceEntity\getTimestamp(), ilTermsOfServiceAcceptanceEntity\getTitle(), and ilTermsOfServiceAcceptanceEntity\getUserId().

    {
        $res = $this->db->queryF(
            'SELECT id FROM tos_versions WHERE hash = %s AND doc_id = %s',
            array('text', 'integer'),
            array($entity->getHash(), $entity->getDocumentId())
        );

        if ($this->db->numRows($res)) {
            $row = $this->db->fetchAssoc($res);
            $versionId = $row['id'];
        } else {
            $versionId = $this->db->nextId('tos_versions');
            $this->db->insert(
                'tos_versions',
                [
                    'id' => ['integer', $versionId],
                    'text' => ['clob', $entity->getText()],
                    'hash' => ['text', $entity->getHash()],
                    'doc_id' => ['integer', $entity->getDocumentId()],
                    'title' => ['text', $entity->getTitle()],
                    'ts' => ['integer', $entity->getTimestamp()]
                ]
            );
        }

        $this->db->insert(
            'tos_acceptance_track',
            [
                'tosv_id' => ['integer', $versionId],
                'usr_id' => ['integer', $entity->getUserId()],
                'criteria' => ['clob', $entity->getSerializedCriteria()],
                'ts' => ['integer', $entity->getTimestamp()]
            ]
        );
    }

Here is the call graph for this function:

Field Documentation

$db

ilTermsOfServiceAcceptanceDatabaseGateway::$db

protected

Definition at line 11 of file class.ilTermsOfServiceAcceptanceDatabaseGateway.php.

Referenced by __construct().

---

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

• Services/TermsOfService/classes/History/class.ilTermsOfServiceAcceptanceDatabaseGateway.php