ILIAS\Exercise\Team\TeamDBRepository Class Reference

Table exc_team_data: Team Table il_exc_team: Team participants (holds the sequence due to historic reasons) More...

Collaboration diagram for ILIAS\Exercise\Team\TeamDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db, InternalDataService $data)
	create ()
	addUser (int $team_id, int $ass_id, int $user_id)
	removeUser (int $team_id, int $ass_id, int $user_id)
	getMembers (int $team_id)
	getMemberIds (int $team_id)
	getTeamForMember (int $ass_id, int $user_id)
	getAllMemberIdsOfAssignment (int $assignment_id)
	getUserTeamMap (int $assignment_id)
	getAssignmentForTeam (int $team_id)
	getTeamIdsOfAssignment (int $ass_id)
	deleteTeam (int $team_id)
	deleteTeamLog (int $team_id)

Protected Attributes
InternalDataService	$data
ilDBInterface	$db

Detailed Description

Table exc_team_data: Team Table il_exc_team: Team participants (holds the sequence due to historic reasons)

Definition at line 29 of file TeamDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Exercise\Team\TeamDBRepository::__construct	(	\ilDBInterface	$db,
		InternalDataService	$data
	)

Definition at line 34 of file TeamDBRepository.php.

References ILIAS\Exercise\Team\TeamDBRepository\$data, and ILIAS\Exercise\Team\TeamDBRepository\$db.

      {
        $this->db = $db;
        $this->data = $data;
    }

Member Function Documentation

addUser()

ILIAS\Exercise\Team\TeamDBRepository::addUser	(	int	$team_id,
		int	$ass_id,
		int	$user_id
	)

Definition at line 51 of file TeamDBRepository.php.

                                                                    : void
    {
        $this->db->insert("il_exc_team", [
            "id" => ["integer", $team_id],
            "ass_id" => ["integer", $ass_id],
            "user_id" => ["integer", $user_id]
        ]);
    }

create()

ILIAS\Exercise\Team\TeamDBRepository::create

(

)

Definition at line 42 of file TeamDBRepository.php.

References $id.

                            : int
    {
        $id = $this->db->nextId("il_exc_team");
        $this->db->insert("exc_team_data", [
            "id" => ["integer", $id]
        ]);
        return $id;
    }

deleteTeam()

ILIAS\Exercise\Team\TeamDBRepository::deleteTeam

(

int

$team_id

)

Definition at line 183 of file TeamDBRepository.php.

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

deleteTeamLog()

ILIAS\Exercise\Team\TeamDBRepository::deleteTeamLog

(

int

$team_id

)

Definition at line 203 of file TeamDBRepository.php.

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

getAllMemberIdsOfAssignment()

ILIAS\Exercise\Team\TeamDBRepository::getAllMemberIdsOfAssignment

(

int

$assignment_id

)

Definition at line 128 of file TeamDBRepository.php.

                                                                   : \Generator
    {
        $set = $this->db->queryF(
            "SELECT DISTINCT user_id FROM il_exc_team " .
            " WHERE ass_id = %s ",
            ["integer"],
            [$assignment_id]
        );
        while ($rec = $this->db->fetchAssoc($set)) {
            yield (int) $rec["user_id"];
        }
    }

getAssignmentForTeam()

ILIAS\Exercise\Team\TeamDBRepository::getAssignmentForTeam

(

int

$team_id

)

Definition at line 156 of file TeamDBRepository.php.

                                                      : int
    {
        $set = $this->db->queryF(
            "SELECT ass_id FROM il_exc_team " .
            " WHERE id = %s ",
            ["integer"],
            [$team_id]
        );
        $rec = $this->db->fetchAssoc($set);
        return (int) ($rec["ass_id"] ?? 0);
    }

getMemberIds()

ILIAS\Exercise\Team\TeamDBRepository::getMemberIds

(

int

$team_id

)

Returns

int[]

Definition at line 97 of file TeamDBRepository.php.

References ILIAS\Repository\int().

                                              : array
    {
        $set = $this->db->queryF(
            "SELECT user_id FROM il_exc_team " .
            " WHERE id = %s ",
            ["integer"],
            [$team_id]
        );
        $ids = [];
        while ($rec = $this->db->fetchAssoc($set)) {
            $ids[] = (int) $rec["user_id"];
        }
        return $ids;
    }

Here is the call graph for this function:

getMembers()

ILIAS\Exercise\Team\TeamDBRepository::getMembers

(

int

$team_id

)

Returns

[TeamMember]

Definition at line 77 of file TeamDBRepository.php.

                                            : \Generator
    {
        $set = $this->db->queryF(
            "SELECT * FROM il_exc_team " .
            " WHERE id = %s ",
            ["integer"],
            [$team_id]
        );
        while ($rec = $this->db->fetchAssoc($set)) {
            yield $this->data->teamMember(
                (int) $rec["id"],
                (int) $rec["ass_id"],
                (int) $rec["user_id"]
            );
        }
    }

getTeamForMember()

ILIAS\Exercise\Team\TeamDBRepository::getTeamForMember	(	int	$ass_id,
		int	$user_id
	)

Definition at line 113 of file TeamDBRepository.php.

References null.

                                                               : ?int
    {
        $set = $this->db->queryF(
            "SELECT id FROM il_exc_team " .
            " WHERE ass_id = %s AND user_id = %s",
            ["integer", "integer"],
            [$ass_id, $user_id]
        );
        $rec = $this->db->fetchAssoc($set);
        if (isset($rec["id"])) {
            return (int) $rec["id"];
        }
        return null;
    }

getTeamIdsOfAssignment()

ILIAS\Exercise\Team\TeamDBRepository::getTeamIdsOfAssignment

(

int

$ass_id

)

Definition at line 168 of file TeamDBRepository.php.

References ILIAS\Repository\int().

                                                       : array
    {
        $set = $this->db->queryF(
            "SELECT DISTINCT(id) FROM il_exc_team " .
            " WHERE ass_id = %s ",
            ["integer"],
            [$ass_id]
        );
        $team_ids = [];
        while ($rec = $this->db->fetchAssoc($set)) {
            $team_ids[] = (int) $rec["id"];
        }
        return $team_ids;
    }

Here is the call graph for this function:

getUserTeamMap()

ILIAS\Exercise\Team\TeamDBRepository::getUserTeamMap

(

int

$assignment_id

)

Definition at line 141 of file TeamDBRepository.php.

References ILIAS\Repository\int().

                                                      : array
    {
        $map = [];
        $set = $this->db->queryF(
            "SELECT * FROM il_exc_team " .
            " WHERE ass_id = %s ",
            ["integer"],
            [$assignment_id]
        );
        while ($rec = $this->db->fetchAssoc($set)) {
            $map[(int) $rec["user_id"]] = (int) $rec["id"];
        }
        return $map;
    }

Here is the call graph for this function:

removeUser()

ILIAS\Exercise\Team\TeamDBRepository::removeUser	(	int	$team_id,
		int	$ass_id,
		int	$user_id
	)

Definition at line 60 of file TeamDBRepository.php.

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

Field Documentation

$data

InternalDataService ILIAS\Exercise\Team\TeamDBRepository::$data

protected

Definition at line 31 of file TeamDBRepository.php.

Referenced by ILIAS\Exercise\Team\TeamDBRepository\__construct().

$db

ilDBInterface ILIAS\Exercise\Team\TeamDBRepository::$db

protected

Definition at line 32 of file TeamDBRepository.php.

Referenced by ILIAS\Exercise\Team\TeamDBRepository\__construct().

---

The documentation for this class was generated from the following file:

• components/ILIAS/Exercise/Team/TeamDBRepository.php