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.

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

       {
         $this->data = $data;
         $this->db = $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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

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