ILIAS\Survey\Sequence\SequenceDBRepository Class Reference

Collaboration diagram for ILIAS\Survey\Sequence\SequenceDBRepository:

Public Member Functions
	__construct (InternalDataService $data, \ilDBInterface $db)
	insert (int $survey_id, int $svy_question_id)

Protected Member Functions
	count (int $survey_id)

Protected Attributes
InternalDataService	$data
ilDBInterface	$db

Detailed Description

Definition at line 25 of file SequenceDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Survey\Sequence\SequenceDBRepository::__construct	(	InternalDataService	$data,
		\ilDBInterface	$db
	)

Definition at line 30 of file SequenceDBRepository.php.

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

References ILIAS\Survey\Sequence\SequenceDBRepository\$data, and ILIAS\Survey\Sequence\SequenceDBRepository\$db.

Member Function Documentation

count()

ILIAS\Survey\Sequence\SequenceDBRepository::count ( int  $survey_id )

protected

Definition at line 38 of file SequenceDBRepository.php.

                                            : int
    {
        $set = $this->db->queryF(
            "SELECT count(*) cnt FROM svy_svy_qst " .
            " WHERE survey_fi = %s ",
            ["integer"],
            [$survey_id]
        );
        if ($rec = $this->db->fetchAssoc($set)) {
            return (int) $rec["cnt"];
        }
        return 0;
    }

Referenced by ILIAS\Survey\Sequence\SequenceDBRepository\insert().

Here is the caller graph for this function:

insert()

ILIAS\Survey\Sequence\SequenceDBRepository::insert	(	int	$survey_id,
		int	$svy_question_id
	)

Definition at line 52 of file SequenceDBRepository.php.

                                                                : int
    {
        $order_nr = $this->count($survey_id);
        $next_id = $this->db->nextId('svy_svy_qst');
        $this->db->manipulateF(
            "INSERT INTO svy_svy_qst (survey_question_id, survey_fi," .
            "question_fi, sequence, tstamp) VALUES (%s, %s, %s, %s, %s)",
            array('integer', 'integer', 'integer', 'integer', 'integer'),
            array($next_id, $survey_id, $svy_question_id, $order_nr, time())
        );
        return $next_id;
    }

References ILIAS\Survey\Sequence\SequenceDBRepository\count().

Here is the call graph for this function:

Field Documentation

$data

InternalDataService ILIAS\Survey\Sequence\SequenceDBRepository::$data

protected

Definition at line 27 of file SequenceDBRepository.php.

Referenced by ILIAS\Survey\Sequence\SequenceDBRepository\__construct().

$db

ilDBInterface ILIAS\Survey\Sequence\SequenceDBRepository::$db

protected

Definition at line 28 of file SequenceDBRepository.php.

Referenced by ILIAS\Survey\Sequence\SequenceDBRepository\__construct().

---

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

• components/ILIAS/Survey/Sequence/SequenceDBRepository.php