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)

	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 164 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 184 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 109 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 137 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);
     }

◆ 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 94 of file TeamDBRepository.php.

                                                                : ?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 149 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 122 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