class.ilExcAssMemberStateRepository.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2019 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilExcAssMemberStateRepository
{
    public function __construct(\ilDBInterface $db = null)
    {
        global $DIC;
 
        $this->db = (is_null($db))
            ? $DIC->database()
            : $db;
    }
    
    public function getSubmitableAssignmentIdsOfUser(array $exc_ids, int $user_id) : array
    {
        $db = $this->db;
        $set = $db->queryF(
            'SELECT ass.id FROM exc_assignment ass LEFT JOIN exc_idl idl
                        ON (ass.id = idl.ass_id AND idl.member_id = %s)
                        WHERE ' . $db->in("ass.exc_id", $exc_ids, false, "integer") . ' 
                                AND ((  ass.deadline_mode = %s
                                                AND (ass.start_time IS NULL OR ass.start_time < %s )
                                                AND (ass.time_stamp IS NULL OR ass.time_stamp > %s OR ass.deadline2 > %s OR idl.tstamp > %s))
                                        ) OR (
                                                ass.deadline_mode = %s
                                                AND (idl.starting_ts > 0)
                                                AND (idl.starting_ts + (ass.relative_deadline * 24 * 60 * 60) > %s)
                                        )',
            array("integer", "integer", "integer", "integer", "integer", "integer", "integer", "integer"),
            array($user_id, 0, time(), time(), time(), time(), 1, time())
        );
        $ids = [];
        while ($rec = $db->fetchAssoc($set)) {
            $ids[] = $rec["id"];
        }
        return $ids;
    }
 
    public function getAssignmentIdsWithGradingNeeded(array $exc_ids)
    {
        $db = $this->db;
 
        $set = $db->queryF(
            'SELECT ass.id, COUNT(*) open_grading FROM exc_mem_ass_status st LEFT JOIN exc_assignment ass 
                        ON (st.ass_id = ass.id)
                        WHERE ' . $db->in("ass.exc_id", $exc_ids, false, "integer") . '
                        AND st.status = %s
                        AND st.returned = %s
                        GROUP BY (ass.id)',
            array("text","integer"),
            array("notgraded", 1)
        );
        $open_gradings = [];
        while ($rec = $db->fetchAssoc($set)) {
            $open_gradings[$rec["id"]] = $rec["open_grading"];
        }
        return $open_gradings;
    }
 
    public function getAssignmentIdsWithPeerFeedbackNeeded(array $exc_ids, int $user_id) : array
    {
        $db = $this->db;
 
        // peer groups exist
        $set = $db->queryF(
            'SELECT ass.id, count(*) nr_given, ass.peer_dl, ass.peer_min, max(idl.tstamp) maxidl, max(peer.tstamp) maxpeer 
                        FROM exc_assignment ass
                        LEFT JOIN exc_assignment_peer peer ON (ass.id = peer.ass_id)
                        LEFT JOIN exc_idl idl ON (ass.id = idl.ass_id)
                        WHERE ' . $db->in("ass.exc_id", $exc_ids, false, "integer") . ' 
                                AND ass.deadline_mode = %s
                                AND ass.time_stamp < %s
                                AND (ass.deadline2 < %s OR ass.deadline2 IS NULL)
                                AND ass.peer = %s
                                AND (peer.giver_id = %s)
                                AND (ass.peer_dl > %s OR ass.peer_dl IS NULL)
                                AND (peer.is_valid = %s)
                        GROUP BY (ass.id)
                        HAVING (ass.peer_min > nr_given) AND (maxidl < %s OR maxidl IS NULL)
                                        ',
            array("integer", "integer", "integer", "integer", "integer", "integer", "integer", "integer"),
            array(0, time(), time(), 1, $user_id, time(), 1, time())
        );
        $ids = [];
        while ($rec = $db->fetchAssoc($set)) {
            $ids[] = $rec["id"];
        }
 
        // peer groups do not exist
        $set = $db->queryF(
            'SELECT ass.id, count(*) nr_given, ass.peer_dl, ass.peer_min, max(idl.tstamp) maxidl, max(peer.tstamp) maxpeer 
                        FROM exc_assignment ass
                        LEFT JOIN exc_assignment_peer peer ON (ass.id = peer.ass_id)
                        LEFT JOIN exc_idl idl ON (ass.id = idl.ass_id)
                        WHERE ' . $db->in("ass.exc_id", $exc_ids, false, "integer") . ' 
                                AND ass.deadline_mode = %s
                                AND ass.time_stamp < %s
                                AND (ass.deadline2 < %s OR ass.deadline2 IS NULL)
                                AND ass.peer = %s
                                AND (peer.giver_id IS NULL)
                                AND (ass.peer_dl > %s OR ass.peer_dl IS NULL)
                                AND (peer.tstamp IS NULL)
                        GROUP BY (ass.id)
                        HAVING (maxpeer IS NULL) AND (maxidl < %s OR maxidl IS NULL)
                                        ',
            array("integer", "integer", "integer", "integer", "integer", "integer"),
            array(0, time(), time(), 1, time(), time())
        );
        while ($rec = $db->fetchAssoc($set)) {
            $ids[] = $rec["id"];
        }
 
 
        return $ids;
    }
}