ILIAS\Survey\Settings\SettingsDBRepository Class Reference

Survey settings db repository. More...

Collaboration diagram for ILIAS\Survey\Settings\SettingsDBRepository:

Public Member Functions
	__construct (InternalDataService $data, \ilDBInterface $db)
	hasEnded (array $survey_ids)
	Check if surveys have ended. More...
	getObjIdsForSurveyIds (array $survey_ids)
	getAccessSettings (array $survey_ids)

Protected Member Functions
	toUnixTS (string $date)
	Unix time from survey date. More...

Protected Attributes
ilDBInterface	$db
SettingsFactory	$set_factory

Detailed Description

Survey settings db repository.

This should wrap all svy_svy calls in the future.

Author

Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 30 of file SettingsDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Survey\Settings\SettingsDBRepository::__construct	(	InternalDataService	$data,
		\ilDBInterface	$db
	)

Definition at line 35 of file SettingsDBRepository.php.

      {
        $this->db = $db;
        $this->set_factory = $data->settings();
    }

References $data, and ILIAS\Survey\Settings\SettingsDBRepository\$db.

Member Function Documentation

getAccessSettings()

ILIAS\Survey\Settings\SettingsDBRepository::getAccessSettings

(

array

$survey_ids

)

Parameters

int[]

$survey_ids

Returns

AccessSettings[]

Definition at line 105 of file SettingsDBRepository.php.

     : array {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT startdate, enddate, anonymize, survey_id FROM svy_svy " .
            " WHERE " . $db->in("survey_id", $survey_ids, false, "integer"),
            [],
            []
        );
        $settings = [];
        while ($rec = $db->fetchAssoc($set)) {
            $settings[(int) $rec["survey_id"]] = $this->set_factory->accessSettings(
                $this->toUnixTS($rec["startdate"] ?? ''),
                $this->toUnixTS($rec["enddate"] ?? ''),
                in_array($rec["anonymize"], ["1", "3"], true)
            );
        }
        return $settings;
    }

References ILIAS\Repository\int().

Here is the call graph for this function:

getObjIdsForSurveyIds()

ILIAS\Survey\Settings\SettingsDBRepository::getObjIdsForSurveyIds

(

array

$survey_ids

)

Parameters

int[]

$survey_ids

Returns

array<int,int>

Definition at line 69 of file SettingsDBRepository.php.

     : array {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT survey_id, obj_fi FROM svy_svy " .
            " WHERE " . $db->in("survey_id", $survey_ids, false, "integer"),
            [],
            []
        );
        $obj_ids = [];
        while ($rec = $db->fetchAssoc($set)) {
            $obj_ids[(int) $rec["survey_id"]] = (int) $rec["obj_fi"];
        }
        return $obj_ids;
    }

References ILIAS\Repository\int().

Here is the call graph for this function:

hasEnded()

ILIAS\Survey\Settings\SettingsDBRepository::hasEnded

(

array

$survey_ids

)

Check if surveys have ended.

Parameters

int[]

$survey_ids

survey IDs

Returns

bool[] has ended true/false

Definition at line 48 of file SettingsDBRepository.php.

                                               : array
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT survey_id, enddate FROM svy_svy " .
            " WHERE " . $db->in("survey_id", $survey_ids, false, "integer"),
            [],
            []
        );
        $has_ended = [];
        while ($rec = $db->fetchAssoc($set)) {
            $has_ended[(int) $rec["survey_id"]] = !((int) $rec["enddate"] === 0 || $this->toUnixTS($rec["enddate"]) > time());
        }
        return $has_ended;
    }

References ILIAS\Survey\Settings\SettingsDBRepository\$db, ilDBInterface\fetchAssoc(), ilDBInterface\in(), ILIAS\Repository\int(), ilDBInterface\queryF(), and ILIAS\Survey\Settings\SettingsDBRepository\toUnixTS().

Here is the call graph for this function:

toUnixTS()

ILIAS\Survey\Settings\SettingsDBRepository::toUnixTS ( string  $date )

protected

Unix time from survey date.

Parameters

string

Returns

int

Definition at line 92 of file SettingsDBRepository.php.

     : int {
        if ($date > 0 && preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $date, $matches)) {
            return (int) mktime((int) $matches[4], (int) $matches[5], (int) $matches[6], (int) $matches[2], (int) $matches[3], (int) $matches[1]);
        }
        return 0;
    }

Referenced by ILIAS\Survey\Settings\SettingsDBRepository\hasEnded().

Here is the caller graph for this function:

Field Documentation

$db

ilDBInterface ILIAS\Survey\Settings\SettingsDBRepository::$db

protected

Definition at line 32 of file SettingsDBRepository.php.

Referenced by ILIAS\Survey\Settings\SettingsDBRepository\__construct(), and ILIAS\Survey\Settings\SettingsDBRepository\hasEnded().

$set_factory

SettingsFactory ILIAS\Survey\Settings\SettingsDBRepository::$set_factory

protected

Definition at line 33 of file SettingsDBRepository.php.

---

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

• components/ILIAS/Survey/Settings/SettingsDBRepository.php