Survey invitations repository. More...

Collaboration diagram for ILIAS\Survey\Participants\InvitationsDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null)
	Constructor. More...

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

	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
	$db

Detailed Description

Survey invitations repository.

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

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

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Survey\Participants\InvitationsDBRepository::__construct ( \ilDBInterface $db = null )

Constructor.

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

    {
        global $DIC;
 
        $this->db = (is_null($db))
            ? $DIC->database()
            : $db;
    }

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

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 57 of file class.InvitationsDBRepository.php.

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

References ILIAS\Survey\Participants\InvitationsDBRepository\$db.

◆ 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 77 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[] = $rec["user_id"];
        }
        return $items;
    }

References ILIAS\Survey\Participants\InvitationsDBRepository\$db.

◆ 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 101 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.

◆ 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 38 of file class.InvitationsDBRepository.php.

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