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.

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

References $db, and $DIC.

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.

    {
        $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;
    }

References $db, and ilExAssignment\isInExercise().

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.

    {
        $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)
                ), []);
            }
        }
    }