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.

    {
        global $DIC;
 
        $this->db = (is_null($db))
            ? $DIC->database()
            : $db;
 
        $this->set_factory = (is_null($set_factory))
            ? new SettingsFactory()
            : $set_factory;
    }

References ILIAS\Survey\Settings\SettingsDBRepository\$db, $DIC, and ILIAS\Survey\Settings\SettingsDBRepository\$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.

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

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

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.

                                                             : 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\Survey\Settings\SettingsDBRepository\$db.

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

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

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.

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