DB survey codes (table. More...

Collaboration diagram for ILIAS\Survey\Code\CodeDBRepo:

Public Member Functions
	__construct (InternalDataService $data, \ilDBInterface $db)

	deleteAll (int $survey_id)
	Delete all codes of a survey. More...

	delete (int $survey_id, string $code)
	Delete single code. More...

	exists (int $survey_id, string $code)
	Does code exist in survey? More...

	add (int $survey_id, string $code="", int $user_id=0, string $email="", string $last_name="", string $first_name="", int $sent=0, int $tstamp=0)
	Saves a survey access code for a registered user to the database. More...

	addCodes (int $survey_id, int $nr)
	Add multiple codes. More...

	updateExternalData (int $code_id, string $email, string $last_name, string $first_name, int $sent)
	Update external data of a code. More...

	getAll (int $survey_id)
	Get all access keys of a survey. More...

	getAllData (int $survey_id)
	Get all codes of a survey. More...

	getByUserKey (int $survey_id, string $survey_key)

	bindUser (int $survey_id, string $code, int $user_id)
	Bind registered user to a code. More...

	getByUserId (int $survey_id, int $user_id)
	Get code for a registered user. More...

	getByCodeId (int $survey_id, int $code_id)

Protected Member Functions
	getNew (int $survey_id)
	Get a new unique code. More...

	getUserKey (int $user_id)
	Get user key for id. More...

Protected Attributes
ilDBInterface	$db

InternalDataService	$data

Detailed Description

DB survey codes (table.

Author: killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 29 of file class.CodeDBRepo.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Survey\Code\CodeDBRepo::__construct	(	InternalDataService	$data,
		\ilDBInterface	$db
	)

Definition at line 35 of file class.CodeDBRepo.php.

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

References ILIAS\Survey\Code\CodeDBRepo\$data, and ILIAS\Survey\Code\CodeDBRepo\$db.

Member Function Documentation

◆ add()

ILIAS\Survey\Code\CodeDBRepo::add	(	int	$survey_id,
		string	$code = `""`,
		int	$user_id = `0`,
		string	$email = `""`,
		string	$last_name = `""`,
		string	$first_name = `""`,
		int	$sent = `0`,
		int	$tstamp = `0`
	)

Saves a survey access code for a registered user to the database.

Returns: int new id

Exceptions

ilSurveyException

Definition at line 128 of file class.CodeDBRepo.php.

     : int {
        $db = $this->db;
 
        if ($code === "") {
            $code = $this->getNew($survey_id);
        }
        if ($this->exists($survey_id, $code)) {
            throw new \ilSurveyException("Code $code already exists.");
        }
 
        $user_key = $this->getUserKey($user_id);
 
        if ($tstamp === 0) {
            $tstamp = time();
        }
 
        $next_id = $db->nextId('svy_anonymous');
 
        $db->insert("svy_anonymous", [
            "anonymous_id" => ["integer", $next_id],
            "survey_key" => ["text", $code],
            "survey_fi" => ["integer", $survey_id],
            "user_key" => ["text", $user_key],
            "tstamp" => ["integer", $tstamp],
            "sent" => ["integer", $sent]
        ]);
 
        if ($email !== "" || $last_name !== "" || $first_name !== "") {
            $this->updateExternalData(
                $next_id,
                $email,
                $last_name,
                $first_name,
                $sent
            );
        }
        return $next_id;
    }

◆ addCodes()

ILIAS\Survey\Code\CodeDBRepo::addCodes	(	int	$survey_id,
		int	$nr
	)

Add multiple codes.

Parameters

int $nr number of codes that should be generated/added

Returns: int[]

Exceptions

ilSurveyException

Definition at line 182 of file class.CodeDBRepo.php.

     : array {
        $ids = [];
        while ($nr-- > 0) {
            $ids[] = $this->add($survey_id);
        }
        return $ids;
    }

References ILIAS\UI\examples\Symbol\Glyph\Add\add().

Here is the call graph for this function:

◆ bindUser()

ILIAS\Survey\Code\CodeDBRepo::bindUser	(	int	$survey_id,
		string	$code,
		int	$user_id
	)

Bind registered user to a code.

Definition at line 314 of file class.CodeDBRepo.php.

     : void {
        $db = $this->db;
 
        $user_key = $this->getUserKey($user_id);
 
        $db->update(
            "svy_anonymous",
            [
            "user_key" => ["text", $user_key]
        ],
            [    // where
                "survey_fi" => ["integer", $survey_id],
                "survey_key" => ["text", $code]
            ]
        );
    }

◆ delete()

ILIAS\Survey\Code\CodeDBRepo::delete	(	int	$survey_id,
		string	$code
	)

Delete single code.

Definition at line 61 of file class.CodeDBRepo.php.

                                                        : void
    {
        $db = $this->db;
 
        if ($code !== "") {
            $db->manipulateF(
                "DELETE FROM svy_anonymous WHERE " .
                " survey_fi = %s AND survey_key = %s",
                ["integer", "text"],
                [$survey_id, $code]
            );
        }
    }

References ILIAS\Survey\Code\CodeDBRepo\$db, and ilDBInterface\manipulateF().

Referenced by ILIAS\Survey\Code\CodeManager\delete().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ deleteAll()

ILIAS\Survey\Code\CodeDBRepo::deleteAll ( int $survey_id )

Delete all codes of a survey.

Definition at line 46 of file class.CodeDBRepo.php.

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

References ILIAS\Survey\Code\CodeDBRepo\$db, and ilDBInterface\manipulateF().

Referenced by ILIAS\Survey\Code\CodeManager\deleteAll().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ exists()

ILIAS\Survey\Code\CodeDBRepo::exists	(	int	$survey_id,
		string	$code
	)

Does code exist in survey?

Definition at line 98 of file class.CodeDBRepo.php.

     : bool {
        $db = $this->db;
        $set = $db->queryF(
            "SELECT anonymous_id FROM svy_anonymous " .
            " WHERE survey_fi = %s AND survey_key = %s ",
            ["integer", "text"],
            [$survey_id, $code]
        );
        return ($set->numRows() > 0);
    }

Referenced by ILIAS\Survey\Code\CodeManager\exists(), and ILIAS\Survey\Code\CodeDBRepo\getNew().

Here is the caller graph for this function:

◆ getAll()

ILIAS\Survey\Code\CodeDBRepo::getAll ( int $survey_id )

Get all access keys of a survey.

Returns: string[]

Definition at line 233 of file class.CodeDBRepo.php.

     : array {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT survey_key FROM svy_anonymous " .
            " WHERE survey_fi = %s ",
            ["integer"],
            [$survey_id]
        );
        $codes = [];
        while ($rec = $db->fetchAssoc($set)) {
            $codes[] = $rec["survey_key"];
        }
        return $codes;
    }

◆ getAllData()

ILIAS\Survey\Code\CodeDBRepo::getAllData ( int $survey_id )

Get all codes of a survey.

Returns: Code[]

Definition at line 255 of file class.CodeDBRepo.php.

     : array {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT * FROM svy_anonymous " .
            " WHERE survey_fi = %s ",
            ["integer"],
            [$survey_id]
        );
        $codes = [];
        while ($rec = $db->fetchAssoc($set)) {
            $codes[] = $this->data->code($rec["survey_key"])
                ->withId((int) $rec["anonymous_id"])
                ->withSurveyId((int) $rec["survey_fi"])
                ->withUserKey((string) $rec["user_key"])
                ->withTimestamp((int) $rec["tstamp"])
                ->withSent((int) $rec["sent"])
                ->withEmail((string) $rec["email"])
                ->withFirstName((string) $rec["firstname"])
                ->withLastName((string) $rec["lastname"]);
        }
 
        return $codes;
    }

◆ getByCodeId()

ILIAS\Survey\Code\CodeDBRepo::getByCodeId	(	int	$survey_id,
		int	$code_id
	)

Definition at line 356 of file class.CodeDBRepo.php.

     : string {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT survey_key FROM svy_anonymous " .
            " WHERE survey_fi = %s AND anonymous_id = %s ",
            ["integer", "integer"],
            [$survey_id, $code_id]
        );
        $rec = $db->fetchAssoc($set);
        return $rec["survey_key"] ?? "";
    }

◆ getByUserId()

ILIAS\Survey\Code\CodeDBRepo::getByUserId	(	int	$survey_id,
		int	$user_id
	)

Get code for a registered user.

Definition at line 338 of file class.CodeDBRepo.php.

     : string {
        $db = $this->db;
 
        $user_key = $this->getUserKey($user_id);
 
        $set = $db->queryF(
            "SELECT survey_key FROM svy_anonymous " .
            " WHERE survey_fi = %s AND user_key = %s ",
            ["integer", "string"],
            [$survey_id, $user_key]
        );
        $rec = $db->fetchAssoc($set);
        return $rec["survey_key"] ?? "";
    }

◆ getByUserKey()

ILIAS\Survey\Code\CodeDBRepo::getByUserKey	(	int	$survey_id,
		string	$survey_key
	)

Definition at line 282 of file class.CodeDBRepo.php.

     : ?Code {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT * FROM svy_anonymous " .
            " WHERE survey_fi = %s AND survey_key = %s",
            ["integer", "string"],
            [$survey_id, $survey_key]
        );
 
        if ($rec = $db->fetchAssoc($set)) {
            $ext_data = unserialize((string) $rec["externaldata"], ["allowed_classes" => false]);
            return $this->data->code($rec["survey_key"])
                                  ->withId((int) $rec["anonymous_id"])
                                  ->withSurveyId((int) $rec["survey_fi"])
                                  ->withUserKey((string) $rec["user_key"])
                                  ->withTimestamp((int) $rec["tstamp"])
                                  ->withSent((int) $rec["sent"])
                                  ->withEmail((string) ($ext_data["email"] ?? ""))
                                  ->withFirstName((string) ($ext_data["firstname"] ?? ""))
                                  ->withLastName((string) ($ext_data["lastname"] ?? ""));
        }
 
        return null;
    }

◆ getNew()

ILIAS\Survey\Code\CodeDBRepo::getNew ( int $survey_id )

protected

Get a new unique code.

Definition at line 78 of file class.CodeDBRepo.php.

                                             : string
    {
        // create a 5 character code
        $codestring = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
        mt_srand();
        $code = "";
        for ($i = 1; $i <= 5; $i++) {
            $index = random_int(0, strlen($codestring) - 1);
            $code .= substr($codestring, $index, 1);
        }
        // uniqueness
        while ($this->exists($survey_id, $code)) {
            $code = $this->getNew($survey_id);
        }
        return $code;
    }

References ILIAS\Survey\Code\CodeDBRepo\exists(), and ILIAS\Survey\Code\CodeDBRepo\getNew().

Referenced by ILIAS\Survey\Code\CodeDBRepo\getNew().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getUserKey()

ILIAS\Survey\Code\CodeDBRepo::getUserKey ( int $user_id )

protected

Get user key for id.

Definition at line 115 of file class.CodeDBRepo.php.

                                               : ?string
    {
        $user_key = ($user_id > 0)
            ? md5((string) $user_id)
            : null;
        return $user_key;
    }

References $user_id.

◆ updateExternalData()

ILIAS\Survey\Code\CodeDBRepo::updateExternalData	(	int	$code_id,
		string	$email,
		string	$last_name,
		string	$first_name,
		int	$sent
	)

Update external data of a code.

Definition at line 196 of file class.CodeDBRepo.php.

     : bool {
        $ilDB = $this->db;
 
        $email = trim($email);
 
        if ($email === "" || ($email && !\ilUtil::is_email($email))) {
            return false;
        }
 
        $data = array("email" => $email,
                      "lastname" => trim($last_name),
                      "firstname" => trim($first_name));
 
        $fields = array(
            "externaldata" => array("text", serialize($data)),
            "sent" => array("integer", $sent)
        );
 
        $ilDB->update(
            "svy_anonymous",
            $fields,
            array("anonymous_id" => array("integer", $code_id))
        );
 
        return true;
    }

Field Documentation

◆ $data

InternalDataService ILIAS\Survey\Code\CodeDBRepo::$data

protected

Definition at line 32 of file class.CodeDBRepo.php.

Referenced by ILIAS\Survey\Code\CodeDBRepo\__construct().

◆ $db

ilDBInterface ILIAS\Survey\Code\CodeDBRepo::$db

protected

Definition at line 31 of file class.CodeDBRepo.php.

Referenced by ILIAS\Survey\Code\CodeDBRepo\__construct(), ILIAS\Survey\Code\CodeDBRepo\delete(), and ILIAS\Survey\Code\CodeDBRepo\deleteAll().

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

components/ILIAS/Survey/Code/class.CodeDBRepo.php

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ add()

◆ addCodes()

◆ bindUser()

◆ delete()

◆ deleteAll()

◆ exists()

◆ getAll()

◆ getAllData()

◆ getByCodeId()

◆ getByUserId()

◆ getByUserKey()

◆ getNew()

◆ getUserKey()

◆ updateExternalData()

Field Documentation

◆ $data

◆ $db