Stores info about random assignments for users in exercises. More...

Collaboration diagram for ilExcRandomAssignmentDBRepository:

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

	getAssignmentsOfUser (int $user_id, int $exc_id)
	Get mandatory assignments of user. More...

	saveAssignmentsOfUser (int $user_id, int $exc_id, array $ass_ids)
	Save assignments of user. More...

Protected Attributes
	$db

Detailed Description

Stores info about random assignments for users in exercises.

(repository)

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

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

Constructor & Destructor Documentation

◆ __construct()

ilExcRandomAssignmentDBRepository::__construct ( ilDBInterface $db = null )

Constructor.

Definition at line 23 of file class.ilExcRandomAssignmentDBRepository.php.

References $db, and $DIC.

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

Member Function Documentation

◆ getAssignmentsOfUser()

ilExcRandomAssignmentDBRepository::getAssignmentsOfUser	(	int	$user_id,
		int	$exc_id
	)

Get mandatory assignments of user.

Parameters

int	$user_id
int	$exc_id

Returns: int[]

Definition at line 39 of file class.ilExcRandomAssignmentDBRepository.php.

References $db, and ilExAssignment\isInExercise().

     {
         $db = $this->db;
 
         $set = $db->queryF(
             "SELECT * FROM exc_mandatory_random " .
             " WHERE usr_id  = %s " .
             " AND exc_id  = %s ",
             array("integer", "integer"),
             array($user_id, $exc_id)
         );
         $ass_ids = [];
         while ($rec = $db->fetchAssoc($set)) {
             if (ilExAssignment::isInExercise($rec["ass_id"], $exc_id)) {
                 $ass_ids[] = $rec["ass_id"];
             }
         }
         return $ass_ids;
     }

Here is the call graph for this function:

◆ saveAssignmentsOfUser()

ilExcRandomAssignmentDBRepository::saveAssignmentsOfUser	(	int	$user_id,
		int	$exc_id,
		array	$ass_ids
	)

Save assignments of user.

Parameters

int	$user_id
int	$exc_id
	int[]	$ass_ids

Definition at line 66 of file class.ilExcRandomAssignmentDBRepository.php.

References $db, and ilExAssignment\isInExercise().

     {
         $db = $this->db;
 
         $db->manipulateF(
             "DELETE FROM exc_mandatory_random  WHERE " .
             " exc_id = %s" .
             " AND usr_id = %s",
             array("integer", "integer"),
             array($exc_id, $user_id)
         );
 
         foreach ($ass_ids as $ass_id) {
             if (ilExAssignment::isInExercise((int) $ass_id, $exc_id)) {
                 $db->replace("exc_mandatory_random", array(        // pk
                     "usr_id" => array("integer", $user_id),
                     "exc_id" => array("integer", $exc_id),
                     "ass_id" => array("integer", $ass_id)
                 ), []);
             }
         }
     }