Class ilUnitConfigurationRepository. More...

Collaboration diagram for ilUnitConfigurationRepository:

Public Member Functions
	__construct (?int $consumer_id=null)

	setConsumerId (?int $consumer_id)

	getConsumerId ()

	isCRUDAllowed (int $category_id)

	copyCategory (int $category_id, int $question_fi, ?string $category_name=null)

	copyUnitsByCategories (int $from_category_id, int $to_category_id, int $qustion_fi)

	getCategoryUnitCount (int $id)

	isUnitInUse (int $id)

	checkDeleteCategory (int $id)

	deleteUnit (int $id)

	getCategorizedUnits ()

	getUnits ()

	loadUnitsForCategory (int $category)

	getUnit (int $id)

	getUnitCategories ()

	getAdminUnitCategories ()

	saveUnitOrder (int $unit_id, int $sequence)

	checkDeleteUnit (int $id, ?int $category_id=null)

	getUnitCategoryById (int $id)

	saveCategory (assFormulaQuestionUnitCategory $category)

	saveNewUnitCategory (assFormulaQuestionUnitCategory $category)

	getAllUnitCategories ()

	deleteCategory (int $id)

	createNewUnit (assFormulaQuestionUnit $unit)

	saveUnit (assFormulaQuestionUnit $unit)

	cloneUnits (int $from_consumer_id, int $to_consumer_id)

Protected Member Functions
	loadUnits ()

	clearUnits ()

	addUnit (assFormulaQuestionUnit $unit)

Protected Attributes
int	$consumer_id = null

ilLanguage	$lng

ilDBInterface	$db

Private Attributes
array	$units = []

array	$categorizedUnits = []

Detailed Description

Class ilUnitConfigurationRepository.

Definition at line 24 of file class.ilUnitConfigurationRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilUnitConfigurationRepository::__construct ( ?int $consumer_id = null )

Definition at line 34 of file class.ilUnitConfigurationRepository.php.

    {
        global $DIC;
 
        $lng = $DIC->language();
 
        $this->db = $DIC->database();
        $this->consumer_id = $consumer_id;
        $this->lng = $lng;
    }

References $consumer_id, $DIC, $lng, and ILIAS\Repository\lng().

Here is the call graph for this function:

Member Function Documentation

◆ addUnit()

ilUnitConfigurationRepository::addUnit ( assFormulaQuestionUnit $unit )

protected

Definition at line 315 of file class.ilUnitConfigurationRepository.php.

                                                            : void
    {
        $this->units[$unit->getId()] = $unit;
    }

References assFormulaQuestionUnit\getId().

Referenced by loadUnits().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ checkDeleteCategory()

ilUnitConfigurationRepository::checkDeleteCategory ( int $id )

Definition at line 202 of file class.ilUnitConfigurationRepository.php.

                                                : ?string
    {
        $res = $this->db->queryF(
            'SELECT unit_id FROM il_qpl_qst_fq_unit WHERE category_fi = %s',
            ['integer'],
            [$id]
        );
 
        if ($this->db->numRows($res)) {
            while ($row = $this->db->fetchAssoc($res)) {
                $unit_res = $this->checkDeleteUnit((int) $row['unit_id'], $id);
                if (!is_null($unit_res)) {
                    return $unit_res;
                }
            }
        }
 
        return null;
    }

References $id, $res, and checkDeleteUnit().

Referenced by deleteCategory().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ checkDeleteUnit()

ilUnitConfigurationRepository::checkDeleteUnit	(	int	$id,
		?int	$category_id = `null`
	)

Definition at line 458 of file class.ilUnitConfigurationRepository.php.

                                                                      : ?string
    {
        $result = $this->db->queryF(
            "SELECT * FROM il_qpl_qst_fq_var WHERE unit_fi = %s",
            ['integer'],
            [$id]
        );
        if ($this->db->numRows($result) > 0) {
            return $this->lng->txt("err_unit_in_variables");
        }
 
        $result = $this->db->queryF(
            "SELECT * FROM il_qpl_qst_fq_res WHERE unit_fi = %s",
            ['integer'],
            [$id]
        );
        if ($this->db->numRows($result) > 0) {
            return $this->lng->txt("err_unit_in_results");
        }
 
        if (!is_null($category_id)) {
            $result = $this->db->queryF(
                "SELECT * FROM il_qpl_qst_fq_unit WHERE baseunit_fi = %s AND category_fi != %s",
                ['integer', 'integer', 'integer'],
                [$id, $id, $category_id]
            );
        } else {
            $result = $this->db->queryF(
                "SELECT * FROM il_qpl_qst_fq_unit WHERE baseunit_fi = %s AND unit_id != %s",
                ['integer', 'integer'],
                [$id, $id]
            );
        }
 
        if ($this->db->numRows($result) > 0) {
            return $this->lng->txt("err_unit_is_baseunit");
        }
 
        return null;
    }

References $id, and ILIAS\Repository\lng().

Referenced by checkDeleteCategory(), and deleteUnit().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ clearUnits()

ilUnitConfigurationRepository::clearUnits ( )

protected

Definition at line 310 of file class.ilUnitConfigurationRepository.php.

                                   : void
    {
        $this->units = [];
    }

Referenced by createNewUnit(), deleteCategory(), deleteUnit(), and saveUnit().

Here is the caller graph for this function:

◆ cloneUnits()

ilUnitConfigurationRepository::cloneUnits	(	int	$from_consumer_id,
		int	$to_consumer_id
	)

Definition at line 661 of file class.ilUnitConfigurationRepository.php.

                                                                          : void
    {
        $category_mapping = [];
 
        $res = $this->db->queryF("SELECT * FROM il_qpl_qst_fq_ucat WHERE question_fi = %s", ['integer'], [$from_consumer_id]);
        while ($row = $this->db->fetchAssoc($res)) {
            $new_category_id = $this->copyCategory((int) $row['category_id'], $to_consumer_id);
            $category_mapping[$row['category_id']] = $new_category_id;
        }
 
        foreach ($category_mapping as $old_category_id => $new_category_id) {
            $res = $this->db->queryF(
                'SELECT * FROM il_qpl_qst_fq_unit WHERE category_fi = %s',
                ['integer'],
                [$old_category_id]
            );
 
            $i = 0;
            $units = [];
            while ($row = $this->db->fetchAssoc($res)) {
                $next_id = $this->db->nextId('il_qpl_qst_fq_unit');
 
                $units[$i]['old_unit_id'] = $row['unit_id'];
                $units[$i]['new_unit_id'] = $next_id;
 
                $this->db->insert(
                    'il_qpl_qst_fq_unit',
                    [
                        'unit_id' => ['integer', $next_id],
                        'unit' => ['text', $row['unit']],
                        'factor' => ['float', $row['factor']],
                        'baseunit_fi' => ['integer', (int) $row['baseunit_fi']],
                        'category_fi' => ['integer', (int) $new_category_id],
                        'sequence' => ['integer', (int) $row['sequence']],
                        'question_fi' => ['integer', $to_consumer_id]
                    ]
                );
                $i++;
            }
 
            foreach ($units as $unit) {
                //update unit : baseunit_fi
                $this->db->update(
                    'il_qpl_qst_fq_unit',
                    ['baseunit_fi' => ['integer', (int) $unit['new_unit_id']]],
                    [
                        'baseunit_fi' => ['integer', (int) $unit['old_unit_id']],
                        'question_fi' => ['integer', $to_consumer_id]
                    ]
                );
 
                //update var : unit_fi
                $this->db->update(
                    'il_qpl_qst_fq_var',
                    ['unit_fi' => ['integer', (int) $unit['new_unit_id']]],
                    [
                        'unit_fi' => ['integer', (int) $unit['old_unit_id']],
                        'question_fi' => ['integer', $to_consumer_id]
                    ]
                );
 
                //update res : unit_fi
                $this->db->update(
                    'il_qpl_qst_fq_res',
                    ['unit_fi' => ['integer', (int) $unit['new_unit_id']]],
                    [
                        'unit_fi' => ['integer', (int) $unit['old_unit_id']],
                        'question_fi' => ['integer', $to_consumer_id]
                    ]
                );
 
                //update res_unit : unit_fi
                $this->db->update(
                    'il_qpl_qst_fq_res_unit',
                    ['unit_fi' => ['integer', (int) $unit['new_unit_id']]],
                    [
                        'unit_fi' => ['integer', (int) $unit['old_unit_id']],
                        'question_fi' => ['integer', $to_consumer_id]
                    ]
                );
            }
        }
    }

References $res, $units, and copyCategory().

Here is the call graph for this function:

◆ copyCategory()

ilUnitConfigurationRepository::copyCategory	(	int	$category_id,
		int	$question_fi,
		?string	$category_name = `null`
	)

Definition at line 66 of file class.ilUnitConfigurationRepository.php.

                                                                                                   : int
    {
        $res = $this->db->queryF(
            'SELECT category FROM il_qpl_qst_fq_ucat WHERE category_id = %s',
            ['integer'],
            [$category_id]
        );
        $row = $this->db->fetchAssoc($res);
 
        if (null === $category_name) {
            $category_name = $row['category'];
        }
 
        $next_id = $this->db->nextId('il_qpl_qst_fq_ucat');
        $this->db->insert(
            'il_qpl_qst_fq_ucat',
            [
                'category_id' => ['integer', $next_id],
                'category' => ['text', $category_name],
                'question_fi' => ['integer', (int) $question_fi]
            ]
        );
 
        return $next_id;
    }

References $res.

Referenced by cloneUnits().

Here is the caller graph for this function:

◆ copyUnitsByCategories()

ilUnitConfigurationRepository::copyUnitsByCategories	(	int	$from_category_id,
		int	$to_category_id,
		int	$qustion_fi
	)

Definition at line 92 of file class.ilUnitConfigurationRepository.php.

                                                                                                      : void
    {
        $res = $this->db->queryF(
            'SELECT * FROM il_qpl_qst_fq_unit WHERE category_fi = %s',
            ['integer'],
            [$from_category_id]
        );
        $i = 0;
        $units = [];
        while ($row = $this->db->fetchAssoc($res)) {
            $next_id = $this->db->nextId('il_qpl_qst_fq_unit');
 
            $units[$i]['old_unit_id'] = $row['unit_id'];
            $units[$i]['new_unit_id'] = $next_id;
 
            $this->db->insert(
                'il_qpl_qst_fq_unit',
                [
                    'unit_id' => ['integer', $next_id],
                    'unit' => ['text', $row['unit']],
                    'factor' => ['float', $row['factor']],
                    'baseunit_fi' => ['integer', (int) $row['baseunit_fi']],
                    'category_fi' => ['integer', (int) $to_category_id],
                    'sequence' => ['integer', (int) $row['sequence']],
                    'question_fi' => ['integer', (int) $qustion_fi]
                ]
            );
            $i++;
        }
 
        foreach ($units as $unit) {
            //update unit : baseunit_fi
            $this->db->update(
                'il_qpl_qst_fq_unit',
                ['baseunit_fi' => ['integer', (int) $unit['new_unit_id']]],
                [
                    'baseunit_fi' => ['integer', $unit['old_unit_id']],
                    'category_fi' => ['integer', $to_category_id]
                ]
            );
 
            //update var : unit_fi
            $this->db->update(
                'il_qpl_qst_fq_var',
                ['unit_fi' => ['integer', (int) $unit['new_unit_id']]],
                [
                    'unit_fi' => ['integer', $unit['old_unit_id']],
                    'question_fi' => ['integer', $qustion_fi]
                ]
            );
 
            //update res : unit_fi
            $this->db->update(
                'il_qpl_qst_fq_res',
                ['unit_fi' => ['integer', (int) $unit['new_unit_id']]],
                [
                    'unit_fi' => ['integer', $unit['old_unit_id']],
                    'question_fi' => ['integer', $qustion_fi]
                ]
            );
 
            //update res_unit : unit_fi
            $this->db->update(
                'il_qpl_qst_fq_res_unit',
                ['unit_fi' => ['integer', (int) $unit['new_unit_id']]],
                [
                    'unit_fi' => ['integer', $unit['old_unit_id']],
                    'question_fi' => ['integer', $qustion_fi]
                ]
            );
        }
    }

References $res, and $units.

◆ createNewUnit()

ilUnitConfigurationRepository::createNewUnit ( assFormulaQuestionUnit $unit )

Definition at line 606 of file class.ilUnitConfigurationRepository.php.

                                                               : void
    {
        $next_id = $this->db->nextId('il_qpl_qst_fq_unit');
        $this->db->manipulateF(
            'INSERT INTO il_qpl_qst_fq_unit (unit_id, unit, factor, baseunit_fi, category_fi, sequence, question_fi) VALUES (%s, %s, %s, %s, %s, %s, %s)',
            ['integer', 'text', 'float', 'integer', 'integer', 'integer', 'integer'],
            [
                $next_id,
                $unit->getUnit(),
                1,
                0,
                $unit->getCategory(),
                0,
                $this->getConsumerId()
            ]
        );
        $unit->setId($next_id);
        $unit->setFactor(1.0);
        $unit->setBaseUnit(0);
        $unit->setSequence(0);
 
        $this->clearUnits();
    }

References clearUnits(), assFormulaQuestionUnit\getCategory(), assFormulaQuestionUnit\getUnit(), assFormulaQuestionUnit\setBaseUnit(), assFormulaQuestionUnit\setFactor(), assFormulaQuestionUnit\setId(), and assFormulaQuestionUnit\setSequence().

Here is the call graph for this function:

◆ deleteCategory()

ilUnitConfigurationRepository::deleteCategory ( int $id )

Definition at line 577 of file class.ilUnitConfigurationRepository.php.

                                           : ?string
    {
        $res = $this->checkDeleteCategory($id);
        if (!is_null($res)) {
            return $this->lng->txt('err_category_in_use');
        }
 
        $res = $this->db->queryF(
            'SELECT * FROM il_qpl_qst_fq_unit WHERE category_fi = %s',
            ['integer'],
            [$id]
        );
        while ($row = $this->db->fetchAssoc($res)) {
            $this->deleteUnit((int) $row['unit_id']);
        }
 
        $ar = $this->db->manipulateF(
            'DELETE FROM il_qpl_qst_fq_ucat WHERE category_id = %s',
            ['integer'],
            [$id]
        );
 
        if ($ar > 0) {
            $this->clearUnits();
        }
 
        return null;
    }

References $id, $res, checkDeleteCategory(), clearUnits(), deleteUnit(), and ILIAS\Repository\lng().

Here is the call graph for this function:

◆ deleteUnit()

ilUnitConfigurationRepository::deleteUnit ( int $id )

Definition at line 222 of file class.ilUnitConfigurationRepository.php.

                                       : ?string
    {
        $res = $this->checkDeleteUnit($id);
        if (!is_null($res)) {
            return $res;
        }
 
        $affectedRows = $this->db->manipulateF(
            "DELETE FROM il_qpl_qst_fq_unit WHERE unit_id = %s",
            ['integer'],
            [$id]
        );
 
        if ($affectedRows > 0) {
            $this->clearUnits();
        }
 
        return null;
    }

References $id, $res, checkDeleteUnit(), and clearUnits().

Referenced by deleteCategory().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getAdminUnitCategories()

ilUnitConfigurationRepository::getAdminUnitCategories ( )

Returns: array<int, array{value: int, text: string, qst_id: int}>

Definition at line 419 of file class.ilUnitConfigurationRepository.php.

                                            : array
    {
        $categories = [];
 
        $result = $this->db->queryF(
            "SELECT * FROM il_qpl_qst_fq_ucat WHERE question_fi = %s  ORDER BY category",
            ['integer'],
            [0]
        );
 
        if ($result = $this->db->numRows($result)) {
            while ($row = $this->db->fetchAssoc($result)) {
                $value = strcmp('-qpl_qst_formulaquestion_' . $row['category'] . '-', $this->lng->txt($row['category'])) === 0
                    ? $row['category']
                    : $this->lng->txt($row['category']);
 
                if (trim($row['category']) !== '') {
                    $cat = [
                        'value' => (int) $row['category_id'],
                        'text' => $value,
                        'qst_id' => (int) $row['question_fi']
                    ];
                    $categories[(int) $row['category_id']] = $cat;
                }
            }
        }
 
        return $categories;
    }

References ILIAS\Repository\int(), and ILIAS\Repository\lng().

Here is the call graph for this function:

◆ getAllUnitCategories()

ilUnitConfigurationRepository::getAllUnitCategories ( )

Returns: assFormulaQuestionUnitCategory[]

Definition at line 558 of file class.ilUnitConfigurationRepository.php.

                                          : array
    {
        $categories = [];
        $result = $this->db->queryF(
            "SELECT * FROM il_qpl_qst_fq_ucat WHERE question_fi = %s OR question_fi = %s ORDER BY category",
            ['integer', 'integer'],
            [$this->getConsumerId(), 0]
        );
 
        if ($result->numRows() > 0) {
            while ($row = $this->db->fetchAssoc($result)) {
                $category = new assFormulaQuestionUnitCategory();
                $category->initFormArray($row);
                $categories[] = $category;
            }
        }
        return $categories;
    }

References getConsumerId().

Here is the call graph for this function:

◆ getCategorizedUnits()

ilUnitConfigurationRepository::getCategorizedUnits ( )

Returns: assFormulaQuestionUnit[]|assFormulaQuestionUnitCategory[]

Definition at line 265 of file class.ilUnitConfigurationRepository.php.

                                         : array
    {
        $consumer_id = $this->consumer_id;
        if ($consumer_id === null) {
            return [];
        }
 
        if (count($this->categorizedUnits) === 0) {
            $result = $this->db->queryF(
                "
                                SELECT  units.*, il_qpl_qst_fq_ucat.category, il_qpl_qst_fq_ucat.question_fi, baseunits.unit baseunit_title
                                FROM    il_qpl_qst_fq_unit units
                                INNER JOIN il_qpl_qst_fq_ucat ON il_qpl_qst_fq_ucat.category_id = units.category_fi
                                LEFT JOIN il_qpl_qst_fq_unit baseunits ON baseunits.unit_id = units.baseunit_fi
                                WHERE   units.question_fi = %s
                                ORDER BY il_qpl_qst_fq_ucat.category, units.sequence",
                ['integer'],
                [$consumer_id]
            );
 
            if ($this->db->numRows($result) > 0) {
                $category = 0;
                while ($row = $this->db->fetchAssoc($result)) {
                    $unit = new assFormulaQuestionUnit();
                    $unit->initFormArray($row);
 
                    if ($category !== $unit->getCategory()) {
                        $cat = new assFormulaQuestionUnitCategory();
                        $cat->initFormArray([
                            'category_id' => (int) $row['category_fi'],
                            'category' => $row['category'],
                            'question_fi' => (int) $row['question_fi'],
                        ]);
                        $this->categorizedUnits[] = $cat;
                        $category = $unit->getCategory();
                    }
 
                    $this->categorizedUnits[] = $unit;
                }
            }
        }
 
        return $this->categorizedUnits;
    }

References $categorizedUnits, and $consumer_id.

◆ getCategoryUnitCount()

ilUnitConfigurationRepository::getCategoryUnitCount ( int $id )

Definition at line 165 of file class.ilUnitConfigurationRepository.php.

                                                 : int
    {
        $result = $this->db->queryF(
            "SELECT * FROM il_qpl_qst_fq_unit WHERE category_fi = %s",
            ['integer'],
            [$id]
        );
 
        return $this->db->numRows($result);
    }

References $id.

◆ getConsumerId()

ilUnitConfigurationRepository::getConsumerId ( )

Definition at line 50 of file class.ilUnitConfigurationRepository.php.

                                   : ?int
    {
        return $this->consumer_id;
    }

References $consumer_id.

Referenced by getAllUnitCategories(), isCRUDAllowed(), and saveUnitOrder().

Here is the caller graph for this function:

◆ getUnit()

ilUnitConfigurationRepository::getUnit ( int $id )

Parameters

int $id

Returns: assFormulaQuestionUnit|null

Definition at line 367 of file class.ilUnitConfigurationRepository.php.

                                    : ?assFormulaQuestionUnit
    {
        if (count($this->units) === 0) {
            $this->loadUnits();
        }
 
        if (array_key_exists($id, $this->units)) {
            return $this->units[$id];
        }
 
        // Maybe this is a new unit, reload $this->units
 
        $this->loadUnits();
 
        return $this->units[$id] ?? null;
    }

References $id, and loadUnits().

Here is the call graph for this function:

◆ getUnitCategories()

ilUnitConfigurationRepository::getUnitCategories ( )

Returns: array<int, array{value: int, text: string, qst_id: int}>

Definition at line 387 of file class.ilUnitConfigurationRepository.php.

                                       : array
    {
        $categories = [];
        $result = $this->db->queryF(
            "SELECT * FROM il_qpl_qst_fq_ucat WHERE question_fi > %s ORDER BY category",
            ['integer'],
            [0]
        );
 
        if ($this->db->numRows($result)) {
            while ($row = $this->db->fetchAssoc($result)) {
                $value = strcmp('-qpl_qst_formulaquestion_' . $row['category'] . '-', $this->lng->txt($row['category'])) === 0
                    ? $row['category']
                    : $this->lng->txt($row['category']);
 
                if (trim($row['category']) !== '') {
                    $cat = [
                        'value' => (int) $row['category_id'],
                        'text' => $value,
                        'qst_id' => (int) $row['question_fi']
                    ];
                    $categories[(int) $row['category_id']] = $cat;
                }
            }
        }
 
        return $categories;
    }

References ILIAS\Repository\int(), and ILIAS\Repository\lng().

Here is the call graph for this function:

◆ getUnitCategoryById()

ilUnitConfigurationRepository::getUnitCategoryById ( int $id )

Definition at line 499 of file class.ilUnitConfigurationRepository.php.

                                                : assFormulaQuestionUnitCategory
    {
        $query = 'SELECT * FROM il_qpl_qst_fq_ucat WHERE category_id = ' . $this->db->quote($id, 'integer');
        $res = $this->db->query($query);
        if (!$this->db->numRows($res)) {
            throw new ilException('un_category_not_exist');
        }
 
        $row = $this->db->fetchAssoc($res);
        $category = new assFormulaQuestionUnitCategory();
        $category->initFormArray($row);
        return $category;
    }

References $id, and $res.

◆ getUnits()

ilUnitConfigurationRepository::getUnits ( )

Returns: assFormulaQuestionUnit[]

Definition at line 323 of file class.ilUnitConfigurationRepository.php.

                              : array
    {
        if (count($this->units) === 0) {
            $this->loadUnits();
        }
        return $this->units;
    }

References $units, and loadUnits().

Here is the call graph for this function:

◆ isCRUDAllowed()

ilUnitConfigurationRepository::isCRUDAllowed ( int $category_id )

Definition at line 55 of file class.ilUnitConfigurationRepository.php.

                                                   : bool
    {
        $res = $this->db->queryF(
            'SELECT * FROM il_qpl_qst_fq_ucat WHERE category_id = %s',
            ['integer'],
            [$category_id]
        );
        $row = $this->db->fetchAssoc($res);
        return isset($row['question_fi']) && (int) $row['question_fi'] === $this->getConsumerId();
    }

References $res, getConsumerId(), and ILIAS\Repository\int().

Here is the call graph for this function:

◆ isUnitInUse()

ilUnitConfigurationRepository::isUnitInUse ( int $id )

Definition at line 176 of file class.ilUnitConfigurationRepository.php.

                                        : bool
    {
        $result_1 = $this->db->queryF(
            "SELECT unit_fi FROM il_qpl_qst_fq_res_unit WHERE unit_fi = %s",
            ['integer'],
            [$id]
        );
 
        $result_2 = $this->db->queryF(
            "SELECT unit_fi FROM il_qpl_qst_fq_var WHERE unit_fi = %s",
            ['integer'],
            [$id]
        );
        $result_3 = $this->db->queryF(
            "SELECT unit_fi FROM il_qpl_qst_fq_res WHERE unit_fi = %s",
            ['integer'],
            [$id]
        );
 
        $cnt_1 = $this->db->numRows($result_1);
        $cnt_2 = $this->db->numRows($result_2);
        $cnt_3 = $this->db->numRows($result_3);
 
        return $cnt_1 > 0 || $cnt_2 > 0 || $cnt_3 > 0;
    }

References $id.

◆ loadUnits()

ilUnitConfigurationRepository::loadUnits ( )

protected

Definition at line 242 of file class.ilUnitConfigurationRepository.php.

                                  : void
    {
        $result = $this->db->query(
            "
                        SELECT units.*, il_qpl_qst_fq_ucat.category, baseunits.unit baseunit_title
                        FROM il_qpl_qst_fq_unit units
                        INNER JOIN il_qpl_qst_fq_ucat ON il_qpl_qst_fq_ucat.category_id = units.category_fi
                        LEFT JOIN il_qpl_qst_fq_unit baseunits ON baseunits.unit_id = units.baseunit_fi
                        ORDER BY il_qpl_qst_fq_ucat.category, units.sequence"
        );
 
        if ($this->db->numRows($result)) {
            while ($row = $this->db->fetchAssoc($result)) {
                $unit = new assFormulaQuestionUnit();
                $unit->initFormArray($row);
                $this->addUnit($unit);
            }
        }
    }

References addUnit().

Referenced by getUnit(), and getUnits().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadUnitsForCategory()

ilUnitConfigurationRepository::loadUnitsForCategory ( int $category )

Parameters

int $category

Returns: assFormulaQuestionUnit[]

Definition at line 335 of file class.ilUnitConfigurationRepository.php.

                                                       : array
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $units = [];
        $result = $ilDB->queryF(
            "SELECT units.*, baseunits.unit baseunit_title, il_qpl_qst_fq_ucat.category
                        FROM il_qpl_qst_fq_unit units
                        INNER JOIN il_qpl_qst_fq_ucat ON il_qpl_qst_fq_ucat.category_id = units.category_fi
                        LEFT JOIN il_qpl_qst_fq_unit baseunits ON baseunits.unit_id = units.baseunit_fi
                        WHERE il_qpl_qst_fq_ucat.category_id = %s
                        ORDER BY units.sequence",
            ['integer'],
            [$category]
        );
 
        if ($result->numRows() > 0) {
            while ($row = $ilDB->fetchAssoc($result)) {
                $unit = new assFormulaQuestionUnit();
                $unit->initFormArray($row);
                $units[] = $unit;
            }
        }
 
        return $units;
    }

References $DIC, $ilDB, and $units.

◆ saveCategory()

ilUnitConfigurationRepository::saveCategory ( assFormulaQuestionUnitCategory $category )

Definition at line 513 of file class.ilUnitConfigurationRepository.php.

                                                                          : void
    {
        $res = $this->db->queryF(
            'SELECT * FROM il_qpl_qst_fq_ucat WHERE category = %s AND question_fi = %s AND category_id != %s',
            ['text', 'integer', 'integer'],
            [$category->getCategory(), $this->getConsumerId(), $category->getId()]
        );
        if ($this->db->numRows($res)) {
            throw new ilException('err_wrong_categoryname');
        }
 
        $this->db->manipulateF(
            'UPDATE il_qpl_qst_fq_ucat SET category = %s WHERE question_fi = %s AND category_id = %s',
            ['text', 'integer', 'integer'],
            [$category->getCategory(), $this->getConsumerId(), $category->getId()]
        );
    }

References $res, assFormulaQuestionUnitCategory\getCategory(), and assFormulaQuestionUnitCategory\getId().

Here is the call graph for this function:

◆ saveNewUnitCategory()

ilUnitConfigurationRepository::saveNewUnitCategory ( assFormulaQuestionUnitCategory $category )

Definition at line 531 of file class.ilUnitConfigurationRepository.php.

                                                                                 : void
    {
        $res = $this->db->queryF(
            'SELECT category FROM il_qpl_qst_fq_ucat WHERE category = %s AND question_fi = %s',
            ['text', 'integer'],
            [$category->getCategory(), $this->getConsumerId()]
        );
        if ($this->db->numRows($res)) {
            throw new ilException('err_wrong_categoryname');
        }
 
        $next_id = $this->db->nextId('il_qpl_qst_fq_ucat');
        $this->db->manipulateF(
            "INSERT INTO il_qpl_qst_fq_ucat (category_id, category, question_fi) VALUES (%s, %s, %s)",
            ['integer', 'text', 'integer'],
            [
                $next_id,
                $category->getCategory(),
                $this->getConsumerId()
            ]
        );
        $category->setId($next_id);
    }

References $res, assFormulaQuestionUnitCategory\getCategory(), and assFormulaQuestionUnitCategory\setId().

Here is the call graph for this function:

◆ saveUnit()

ilUnitConfigurationRepository::saveUnit ( assFormulaQuestionUnit $unit )

Definition at line 630 of file class.ilUnitConfigurationRepository.php.

                                                          : void
    {
        $res = $this->db->queryF(
            'SELECT unit_id FROM il_qpl_qst_fq_unit WHERE unit_id = %s',
            ['integer'],
            [$unit->getId()]
        );
        if ($this->db->numRows($res)) {
            $row = $this->db->fetchAssoc($res);
 
            if ($unit->getBaseUnit() === 0 || $unit->getBaseUnit() === $unit->getId()) {
                $unit->setFactor(1);
            }
 
            $ar = $this->db->manipulateF(
                'UPDATE il_qpl_qst_fq_unit SET unit = %s, factor = %s, baseunit_fi = %s, category_fi = %s, sequence = %s WHERE unit_id = %s AND question_fi = %s',
                ['text', 'float', 'integer', 'integer', 'integer', 'integer', 'integer'],
                [
                    $unit->getUnit(), $unit->getFactor(), (int) $unit->getBaseUnit(),
                    $unit->getCategory(),
                    $unit->getSequence(),
                    $unit->getId(),
                    $this->getConsumerId()
                ]
            );
            if ($ar > 0) {
                $this->clearUnits();
            }
        }
    }

References $res, clearUnits(), assFormulaQuestionUnit\getBaseUnit(), assFormulaQuestionUnit\getCategory(), assFormulaQuestionUnit\getFactor(), assFormulaQuestionUnit\getId(), assFormulaQuestionUnit\getSequence(), assFormulaQuestionUnit\getUnit(), and assFormulaQuestionUnit\setFactor().

Here is the call graph for this function:

◆ saveUnitOrder()

ilUnitConfigurationRepository::saveUnitOrder	(	int	$unit_id,
		int	$sequence
	)

Definition at line 449 of file class.ilUnitConfigurationRepository.php.

                                                              : void
    {
        $this->db->manipulateF(
            'UPDATE il_qpl_qst_fq_unit SET sequence = %s WHERE unit_id = %s AND question_fi = %s',
            ['integer', 'integer', 'integer'],
            [$sequence, $unit_id, $this->getConsumerId()]
        );
    }

References getConsumerId().

Here is the call graph for this function:

◆ setConsumerId()

ilUnitConfigurationRepository::setConsumerId ( ?int $consumer_id )

Definition at line 45 of file class.ilUnitConfigurationRepository.php.

                                                    : void
    {
        $this->consumer_id = $consumer_id;
    }

References $consumer_id.

Field Documentation

◆ $categorizedUnits

array ilUnitConfigurationRepository::$categorizedUnits = []

private

Definition at line 32 of file class.ilUnitConfigurationRepository.php.

Referenced by getCategorizedUnits().

◆ $consumer_id

int ilUnitConfigurationRepository::$consumer_id = null

protected

Definition at line 26 of file class.ilUnitConfigurationRepository.php.

Referenced by __construct(), getCategorizedUnits(), getConsumerId(), and setConsumerId().

◆ $db

ilDBInterface ilUnitConfigurationRepository::$db

protected

Definition at line 28 of file class.ilUnitConfigurationRepository.php.

◆ $lng

ilLanguage ilUnitConfigurationRepository::$lng

protected

Definition at line 27 of file class.ilUnitConfigurationRepository.php.

Referenced by __construct().

◆ $units

array ilUnitConfigurationRepository::$units = []

private

Definition at line 30 of file class.ilUnitConfigurationRepository.php.

Referenced by cloneUnits(), copyUnitsByCategories(), getUnits(), and loadUnitsForCategory().

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

components/ILIAS/TestQuestionPool/classes/class.ilUnitConfigurationRepository.php

Public Member Functions

Protected Member Functions

Protected Attributes

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ addUnit()

◆ checkDeleteCategory()

◆ checkDeleteUnit()

◆ clearUnits()

◆ cloneUnits()

◆ copyCategory()

◆ copyUnitsByCategories()

◆ createNewUnit()

◆ deleteCategory()

◆ deleteUnit()

◆ getAdminUnitCategories()

◆ getAllUnitCategories()

◆ getCategorizedUnits()

◆ getCategoryUnitCount()

◆ getConsumerId()

◆ getUnit()

◆ getUnitCategories()

◆ getUnitCategoryById()

◆ getUnits()

◆ isCRUDAllowed()

◆ isUnitInUse()

◆ loadUnits()

◆ loadUnitsForCategory()

◆ saveCategory()

◆ saveNewUnitCategory()

◆ saveUnit()

◆ saveUnitOrder()

◆ setConsumerId()

Field Documentation

◆ $categorizedUnits

◆ $consumer_id

◆ $db

◆ $lng

◆ $units