Survey invitations repository. More...

Collaboration diagram for ILIAS\Survey\Participants\InvitationsDBRepository:

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

	remove (int $survey_id, int $user_id)
	Remove invitation. More...

	removeAll (int $survey_id)

	add (int $survey_id, int $user_id)
	Add invitation. More...

	getAllForSurvey (int $survey_id)
	Get invitations for survey. More...

	getAllForUser (int $user_id)
	Get surveys where user is invited. More...

Protected Attributes
ilDBInterface	$db

InternalDataService	$data

Detailed Description

Survey invitations repository.

Author: Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

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

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Survey\Participants\InvitationsDBRepository::__construct	(	InternalDataService	$data,
		\ilDBInterface	$db
	)

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

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

References ILIAS\Survey\Participants\InvitationsDBRepository\$data, and ILIAS\Survey\Participants\InvitationsDBRepository\$db.

Member Function Documentation

◆ add()

ILIAS\Survey\Participants\InvitationsDBRepository::add	(	int	$survey_id,
		int	$user_id
	)

Add invitation.

Parameters

int	$survey_id	Survey ID not object ID!
int	$user_id

Definition at line 81 of file class.InvitationsDBRepository.php.

                                                     : void
    {
        $db = $this->db;
 
        $db->replace(
            "svy_invitation",
            [           // pk
                "survey_id" => ["integer", $survey_id],
                "user_id" => ["integer", $user_id]
            ],
            []
        );
    }

References ILIAS\Survey\Participants\InvitationsDBRepository\$db, and ilDBInterface\replace().

Here is the call graph for this function:

◆ getAllForSurvey()

ILIAS\Survey\Participants\InvitationsDBRepository::getAllForSurvey ( int $survey_id )

Get invitations for survey.

Parameters

int $survey_id Survey ID not object ID!

Returns: int[]

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

                                                   : array
    {
        $db = $this->db;
 
        $items = [];
        $set = $db->queryF(
            "SELECT user_id FROM svy_invitation " .
            " WHERE survey_id = %s ",
            ["integer"],
            [$survey_id]
        );
 
        while ($rec = $db->fetchAssoc($set)) {
            $items[] = (int) $rec["user_id"];
        }
        return $items;
    }

References ILIAS\Survey\Participants\InvitationsDBRepository\$db, ilDBInterface\fetchAssoc(), ILIAS\Repository\int(), and ilDBInterface\queryF().

Here is the call graph for this function:

◆ getAllForUser()

ILIAS\Survey\Participants\InvitationsDBRepository::getAllForUser ( int $user_id )

Get surveys where user is invited.

Parameters

int $user_id user id

Returns: int[] survey IDs

Definition at line 124 of file class.InvitationsDBRepository.php.

                                               : array
    {
        $db = $this->db;
 
        $items = [];
        $set = $db->queryF(
            "SELECT survey_id FROM svy_invitation " .
            " WHERE user_id = %s ",
            ["integer"],
            [$user_id]
        );
 
        while ($rec = $db->fetchAssoc($set)) {
            $items[] = (int) $rec["survey_id"];
        }
        return $items;
    }

References ILIAS\Survey\Participants\InvitationsDBRepository\$db, ilDBInterface\fetchAssoc(), ILIAS\Repository\int(), and ilDBInterface\queryF().

Here is the call graph for this function:

◆ remove()

ILIAS\Survey\Participants\InvitationsDBRepository::remove	(	int	$survey_id,
		int	$user_id
	)

Remove invitation.

Parameters

int	$survey_id	Survey ID not object ID!
int	$user_id

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

                                                        : void
    {
        $db = $this->db;
 
        $db->manipulateF(
            "DELETE FROM svy_invitation WHERE " .
            " survey_id = %s AND user_id = %s",
            ["integer", "integer"],
            [$survey_id, $user_id]
        );
    }

References ILIAS\Survey\Participants\InvitationsDBRepository\$db, and ilDBInterface\manipulateF().

Here is the call graph for this function:

◆ removeAll()

ILIAS\Survey\Participants\InvitationsDBRepository::removeAll ( int $survey_id )

Definition at line 62 of file class.InvitationsDBRepository.php.

                                             : void
    {
        $db = $this->db;
 
        $db->manipulateF(
            "DELETE FROM svy_invitation WHERE " .
            " survey_id = %s",
            ["integer"],
            [$survey_id]
        );
    }