Class ilUnitConfigurationRepository. More...

Collaboration diagram for ilUnitConfigurationRepository:

Public Member Functions
	__construct (int $consumer_id)

	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 = 0

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 )

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

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

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

Here is the call graph for this function:

Member Function Documentation

◆ addUnit()

ilUnitConfigurationRepository::addUnit ( assFormulaQuestionUnit $unit )

protected

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

References assFormulaQuestionUnit\getId().

Referenced by loadUnits().

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

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.

References $res, checkDeleteUnit(), and null.

Referenced by deleteCategory().

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

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 453 of file class.ilUnitConfigurationRepository.php.

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

Referenced by checkDeleteCategory(), and deleteUnit().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ clearUnits()

ilUnitConfigurationRepository::clearUnits ( )

protected

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

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

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

Here is the caller graph for this function:

◆ cloneUnits()

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

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

References $res, and copyCategory().

                                                                           : 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]
                     ]
                 );
             }
         }
     }

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.

References $res, and null.

Referenced by cloneUnits().

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

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.

References $res.

                                                                                                       : 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]
                 ]
             );
         }
     }

◆ createNewUnit()

ilUnitConfigurationRepository::createNewUnit ( assFormulaQuestionUnit $unit )

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

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

                                                                : 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();
     }

Here is the call graph for this function:

◆ deleteCategory()

ilUnitConfigurationRepository::deleteCategory ( int $id )

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

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

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

Here is the call graph for this function:

◆ deleteUnit()

ilUnitConfigurationRepository::deleteUnit ( int $id )

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

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

Referenced by deleteCategory().

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

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 414 of file class.ilUnitConfigurationRepository.php.

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

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

Here is the call graph for this function:

◆ getAllUnitCategories()

ilUnitConfigurationRepository::getAllUnitCategories ( )

Returns: assFormulaQuestionUnitCategory[]

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

References getConsumerId().

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

Here is the call graph for this function:

◆ getCategorizedUnits()

ilUnitConfigurationRepository::getCategorizedUnits ( )

Returns: assFormulaQuestionUnit[]|assFormulaQuestionUnitCategory[]

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

References $categorizedUnits, and getConsumerId().

                                          : array
     {
         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'],
                 [$this->getConsumerId()]
             );
 
             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;
     }

Here is the call graph for this function:

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

◆ getConsumerId()

ilUnitConfigurationRepository::getConsumerId ( )

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

References $consumer_id.

Referenced by createNewUnit(), getAllUnitCategories(), getCategorizedUnits(), isCRUDAllowed(), saveCategory(), saveNewUnitCategory(), saveUnit(), and saveUnitOrder().

                                    : int
     {
         return $this->consumer_id;
     }

Here is the caller graph for this function:

◆ getUnit()

ilUnitConfigurationRepository::getUnit ( int $id )

Parameters

int $id

Returns: assFormulaQuestionUnit|null

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

References $id, loadUnits(), and null.

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

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 382 of file class.ilUnitConfigurationRepository.php.

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

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

Here is the call graph for this function:

◆ getUnitCategoryById()

ilUnitConfigurationRepository::getUnitCategoryById ( int $id )

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

References $res.

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

◆ getUnits()

ilUnitConfigurationRepository::getUnits ( )

Returns: assFormulaQuestionUnit[]

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

References $units, and loadUnits().

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

Here is the call graph for this function:

◆ isCRUDAllowed()

ilUnitConfigurationRepository::isCRUDAllowed ( int $category_id )

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

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

                                                    : 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();
     }

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

◆ loadUnits()

ilUnitConfigurationRepository::loadUnits ( )

protected

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

References addUnit().

Referenced by getUnit(), and getUnits().

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

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 330 of file class.ilUnitConfigurationRepository.php.

References $DIC, $ilDB, and $units.

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

◆ saveCategory()

ilUnitConfigurationRepository::saveCategory ( assFormulaQuestionUnitCategory $category )

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

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

                                                                           : 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()]
         );
     }

Here is the call graph for this function:

◆ saveNewUnitCategory()

ilUnitConfigurationRepository::saveNewUnitCategory ( assFormulaQuestionUnitCategory $category )

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

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

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

Here is the call graph for this function:

◆ saveUnit()

ilUnitConfigurationRepository::saveUnit ( assFormulaQuestionUnit $unit )

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

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

                                                           : 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();
             }
         }
     }

Here is the call graph for this function:

◆ saveUnitOrder()

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

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

References getConsumerId().

                                                               : 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()]
         );
     }

Here is the call graph for this function:

◆ setConsumerId()

ilUnitConfigurationRepository::setConsumerId ( int $consumer_id )

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

References $consumer_id.

                                                    : void
     {
         $this->consumer_id = $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 = 0

protected

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

Referenced by __construct(), 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 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