PassPresentedVariablesRepo.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class PassPresentedVariablesRepo
{
    public const TABLE_NAME = 'tst_qst_var_presented';
 
    public function __construct(
        protected ilDBInterface $db
    ) {
    }
 
    public function getFor(
        int $question_id,
        int $active_id,
        int $pass
    ): ?array {
        $query = 'SELECT variable, value FROM ' . self::TABLE_NAME . ' WHERE '
            . 'question_id = %s AND '
            . 'active_id = %s AND '
            . 'pass = %s';
 
        $result = $this->db->queryF(
            $query,
            ['integer','integer','integer'],
            [$question_id, $active_id, $pass]
        );
 
        if($result->numRows() === 0) {
            return null;
        }
 
        $values = [];
        while ($row = $this->db->fetchAssoc($result)) {
            $values[$row['variable']] = $row['value'];
        }
        return $values;
    }
 
    public function store(
        int $question_id,
        int $active_id,
        int $pass,
        array $values
    ): void {
        $query = 'INSERT INTO ' . self::TABLE_NAME
            . ' (question_id, active_id, pass, variable, value) '
            . ' VALUES (%s,%s,%s,%s,%s)';
 
        foreach ($values as $k => $v) {
            $this->db->manipulateF(
                $query,
                ['integer','integer','integer', 'text', 'text'],
                [$question_id, $active_id, $pass, $k, $v]
            );
        }
    }
}