ILIAS\Survey\Settings\SettingsDBRepository Class Reference

Survey settings db repository. More...

Collaboration diagram for ILIAS\Survey\Settings\SettingsDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null, SettingsFactory $set_factory=null)
	Constructor. More...
	hasEnded (array $survey_ids)
	Check if surveys have ended. More...
	getObjIdsForSurveyIds (array $survey_ids)
	Check if surveys have ended. More...
	getAccessSettings (array $survey_ids)
	Get access settings. More...

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

Protected Attributes
	$db
	$set_factory

Detailed Description

Survey settings db repository.

This should wrap all svy_svy calls in the future.

Author

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

Definition at line 14 of file SettingsDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Survey\Settings\SettingsDBRepository::__construct	(	\ilDBInterface	$db = null,
		SettingsFactory	$set_factory = null
	)

Constructor.

Definition at line 29 of file SettingsDBRepository.php.

References ILIAS\Survey\Settings\SettingsDBRepository\$db, $DIC, and ILIAS\Survey\Settings\SettingsDBRepository\$set_factory.

    {
        global $DIC;

        $this->db = (is_null($db))
            ? $DIC->database()
            : $db;

        $this->set_factory = (is_null($set_factory))
            ? new SettingsFactory()
            : $set_factory;
    }

Member Function Documentation

getAccessSettings()

ILIAS\Survey\Settings\SettingsDBRepository::getAccessSettings

(

array

$survey_ids

)

Get access settings.

Parameters

int[]

$survey_ids

Returns

AccessSettings[]

Definition at line 110 of file SettingsDBRepository.php.

References ILIAS\Survey\Settings\SettingsDBRepository\$db, and ILIAS\Survey\Settings\SettingsDBRepository\toUnixTS().

                                                         : 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"])
            );
        }
        return $settings;
    }

Here is the call graph for this function:

getObjIdsForSurveyIds()

ILIAS\Survey\Settings\SettingsDBRepository::getObjIdsForSurveyIds

(

array

$survey_ids

)

Check if surveys have ended.

Parameters

int[]

$survey_ids survey IDs

Returns

bool[] has ended true/false

Definition at line 71 of file SettingsDBRepository.php.

References ILIAS\Survey\Settings\SettingsDBRepository\$db.

                                                             : 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;
    }

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.

References ILIAS\Survey\Settings\SettingsDBRepository\$db, and ILIAS\Survey\Settings\SettingsDBRepository\toUnixTS().

                                                : 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"]] = !($rec["enddate"] == 0 || $this->toUnixTS($rec["enddate"]) > time());
        }
        return $has_ended;
    }

Here is the call graph for this function:

toUnixTS()

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

protected

Unix time from survey date.

Parameters

string

Returns

int

Definition at line 94 of file SettingsDBRepository.php.

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

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

Here is the caller graph for this function:

Field Documentation

$db

ILIAS\Survey\Settings\SettingsDBRepository::$db

protected

Definition at line 19 of file SettingsDBRepository.php.

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

$set_factory

ILIAS\Survey\Settings\SettingsDBRepository::$set_factory

protected

Definition at line 24 of file SettingsDBRepository.php.

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

---

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

• Modules/Survey/Settings/SettingsDBRepository.php