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