class.ilExcRandomAssignmentDBRepository.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2019 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilExcRandomAssignmentDBRepository
{

    protected $db;

    public function __construct(ilDBInterface $db = null)
    {
        global $DIC;

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

    public function getAssignmentsOfUser(int $user_id, int $exc_id)
    {
        $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;
    }

    public function saveAssignmentsOfUser(int $user_id, int $exc_id, array $ass_ids)
    {
        $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)
                ), []);
            }
        }
    }
}