class.assClozeGapCombination.php

Go to the documentation of this file.

<?php

class assClozeGapCombination
{
    public function loadFromDb($question_id): array
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $result = $ilDB->queryF(
            '
                                                                        SELECT  combinations.combination_id,
                                                                                        combinations.gap_fi,
                                                                                        combinations.answer,
                                                                                        combinations.row_id,
                                                                                        combinations.points,
                                                                                        combinations.best_solution,
                                                                                        combinations.question_fi,
                                                                                        cloze.cloze_type
                                                                        FROM    qpl_a_cloze_combi_res AS combinations
                                                                        INNER JOIN qpl_a_cloze AS cloze
                                                                                                        WHERE combinations.question_fi = cloze.question_fi
                                                                                                        AND combinations.gap_fi = cloze.gap_id
                                                                                                        AND combinations.question_fi = %s
                                                                        ORDER BY combination_id, row_id, gap_fi ASC
                                                                        ',
            array('integer'),
            array($question_id)
        );

        $return_array = array();
        while ($data = $ilDB->fetchAssoc($result)) {
            if (isset($return_array[$data['combination_id'] . '::' . $data['gap_fi']])) {
                continue;
            }

            $return_array[$data['combination_id'] . '::' . $data['row_id'] . '::' . $data['gap_fi']] = array(
                                    'cid' => $data['combination_id'],
                                    'gap_fi' => $data['gap_fi'],
                                    'answer' => $data['answer'],
                                    'points' => $data['points'],
                                    'row_id' => $data['row_id'],
                                    'type' => $data['cloze_type'],
                                    'best_solution' => $data['best_solution']
                                 );
        }

        return array_values($return_array);
    }

    public function getCleanCombinationArray($question_id): array
    {
        $assClozeGapCombinationObj = new assClozeGapCombination();
        $combination_from_db = $assClozeGapCombinationObj->loadFromDb($question_id);
        $clean_array = array();
        foreach ($combination_from_db as $key => $value) {
            $clean_array[$value['cid']][$value['row_id']][$value['gap_fi']]['answer'] = $value['answer'];
            $clean_array[$value['cid']][$value['row_id']]['points'] = $value['points'];
            $clean_array[$value['cid']][$value['row_id']][$value['gap_fi']]['type'] = $value['type'];
        }
        return $clean_array;
    }

    public function saveGapCombinationToDb($question_id, $gap_combinations, $gap_values): void
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $best_solutions = array();
        for ($i = 0; $i < count($gap_combinations['points']); $i++) {
            $highest_points = 0;
            for ($j = 0; $j < count($gap_combinations['points'][$i]); $j++) {
                if ($highest_points < $gap_combinations['points'][$i][$j]) {
                    $highest_points = $gap_combinations['points'][$i][$j];
                    $best_solutions[$i] = $j;
                }
            }
        }
        for ($i = 0; $i < count($gap_values); $i++) {
            for ($j = 0; $j < count($gap_values[$i]); $j++) {
                for ($k = 0; $k < count($gap_values[$i][$j]); $k++) {
                    if ($best_solutions[$i] == $j) {
                        $best_solution = 1;
                    } else {
                        $best_solution = 0;
                    }
                    $ilDB->manipulateF(
                        'INSERT INTO qpl_a_cloze_combi_res
                                                        (combination_id, question_fi, gap_fi, row_id, answer, points, best_solution) VALUES (%s, %s, %s, %s, %s, %s, %s)',
                        array(
                            'integer',
                            'integer',
                            'integer',
                            'integer',
                            'text',
                            'float',
                            'integer'
                        ),
                        array(
                            $i,
                            $question_id,
                            $gap_combinations['select'][$i][$k],
                            $j,
                            $gap_values[$i][$j][$k],
                            (float) str_replace(',', '.', $gap_combinations['points'][$i][$j]),
                            $best_solution
                        )
                    );
                }
            }
        }
    }
    public static function importGapCombinationToDb($question_id, $gap_combinations): void
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        foreach ($gap_combinations as $key => $row) {
            if (is_object($row)) {
                $row = get_object_vars($row);
            }
            if ($question_id != -1) {
                $ilDB->manipulateF(
                    'INSERT INTO qpl_a_cloze_combi_res
                                                        (combination_id, question_fi, gap_fi, row_id, answer, points, best_solution) VALUES (%s, %s, %s, %s, %s, %s, %s)',
                    array(
                        'integer',
                        'integer',
                        'integer',
                        'integer',
                        'text',
                        'float',
                        'integer'
                    ),
                    array(
                        $row['cid'],
                        $question_id,
                        $row['gap_fi'],
                        $row['row_id'],
                        $row['answer'],
                        $row['points'],
                        $row['best_solution']
                    )
                );
            }
        }
    }

    public static function clearGapCombinationsFromDb($question_id): void
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        $ilDB->manipulateF(
            'DELETE FROM qpl_a_cloze_combi_res WHERE question_fi = %s',
            array( 'integer' ),
            array( $question_id )
        );
    }

    public function combinationExistsForQid($question_id): bool
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        $result = $ilDB->queryF(
            'SELECT * FROM qpl_a_cloze_combi_res WHERE question_fi = %s ORDER BY gap_fi ASC',
            array('integer'),
            array($question_id)
        );
        if ($result->numRows() > 0) {
            return true;
        } else {
            return false;
        }
    }

    public function getGapsWhichAreUsedInCombination($question_id): array
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        $result = $ilDB->queryF(
            'SELECT gap_fi, combination_id FROM ' . $ilDB->quoteIdentifier('qpl_a_cloze_combi_res') . ' WHERE question_fi = %s GROUP BY gap_fi, combination_id',
            array('integer'),
            array($question_id)
        );
        $gaps = array();
        if ($result->numRows() > 0) {
            while ($data = $ilDB->fetchAssoc($result)) {
                $gaps[$data['gap_fi']] = $data['combination_id'];
            }
        }
        return $gaps;
    }

    public function getMaxPointsForCombination(int $question_id, int $combination_id = -1): float
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        if ($combination_id == -1) {
            $result = $ilDB->queryF(
                'SELECT combination_id, points FROM qpl_a_cloze_combi_res WHERE question_fi = %s AND best_solution=1 GROUP BY combination_id, points',
                array('integer'),
                array($question_id)
            );
            if ($result->numRows() > 0) {
                $points = 0;
                while ($data = $ilDB->fetchAssoc($result)) {
                    $points += $data['points'];
                }
                return $points;
            }
        } else {
            $result = $ilDB->queryF(
                'SELECT combination_id, points FROM qpl_a_cloze_combi_res WHERE question_fi = %s AND  combination_id = %s AND best_solution=1 GROUP BY combination_id, points',
                array('integer', 'integer'),
                array($question_id, $combination_id)
            );
            if ($result->numRows() > 0) {
                $points = 0;
                while ($data = $ilDB->fetchAssoc($result)) {
                    $points += $data['points'];
                }
                return $points;
            }
        }
        return 0;
    }

    public function getBestSolutionCombination($question_id)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $lng = $DIC['lng'];

        $result = $ilDB->queryF(
            'SELECT * FROM qpl_a_cloze_combi_res WHERE question_fi = %s AND best_solution=1 ORDER BY gap_fi',
            array('integer'),
            array($question_id)
        );
        if ($result->numRows() > 0) {
            $return_string = '<br>';
            $combination_id = 0;
            $points = 0;
            while ($data = $ilDB->fetchAssoc($result)) {
                if ($combination_id != $data['combination_id']) {
                    $combination_id = $data['combination_id'];
                    $return_string .= $points;
                    $return_string .= '<br>';
                    $return_string .= $data['answer'] . '|';
                } else {
                    $return_string .= $data['answer'] . '|';
                }

                $points = ' (' . $data['points'] . ' ' . $lng->txt('points') . ')';
            }
            return rtrim($return_string, '|') . $points;
        } else {
            return 0;
        }
    }
}