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.

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

     {
         global $DIC;
 
         $this->db = (is_null($db))
             ? $DIC->database()
             : $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 57 of file class.InvitationsDBRepository.php.

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

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

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

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

                                                     : 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;
     }

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

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

                                                 : 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;
     }

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

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

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