Class ilUnitConfigurationRepository. More...

Collaboration diagram for ilUnitConfigurationRepository:

Public Member Functions
	setConsumerId ($consumer_id)

	getConsumerId ()

	getCategoryUnitCount ($id)

	isUnitInUse ($id)

	deleteUnit ($id)

	getCategorizedUnits ()

	getUnits ()

	loadUnitsForCategory ($category)

	getUnit ($id)

	getUnitCategories ()

	getAdminUnitCategories ()

	checkDeleteUnit ($id, $category_id=null)

Static Public Attributes
static	$result_buffer

Protected Member Functions
	loadUnits ()

	clearUnits ()

	addUnit ($unit)

Protected Attributes
	$consumer_id = 0

	$lng

Private Attributes
	$units = array()

	$categorizedUnits = array()

Detailed Description

Class ilUnitConfigurationRepository.

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

Member Function Documentation

◆ addUnit()

ilUnitConfigurationRepository::addUnit ( $unit )

protected

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

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

Referenced by loadUnits().

Here is the caller graph for this function:

◆ checkDeleteUnit()

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

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

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

References $DIC, $id, $ilDB, and $result.

Referenced by deleteUnit().

Here is the caller graph for this function:

◆ clearUnits()

ilUnitConfigurationRepository::clearUnits ( )

protected

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

    {
        $this->units = array();
        self::$result_buffer = null;
    }

Referenced by deleteUnit().

Here is the caller graph for this function:

◆ deleteUnit()

ilUnitConfigurationRepository::deleteUnit ( $id )

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

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

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

Here is the call graph for this function:

◆ getAdminUnitCategories()

ilUnitConfigurationRepository::getAdminUnitCategories ( )

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

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

References $DIC, $ilDB, $result, and $row.

◆ getCategorizedUnits()

ilUnitConfigurationRepository::getCategorizedUnits ( )

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

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        if (count($this->categorizedUnits) == 0) {
            $result = $ilDB->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",
                array('integer'),
                array($this->getConsumerId())
            );
 
            if ($result->numRows()) {
                $category = '';
                while ($row = $ilDB->fetchAssoc($result)) {
                    $unit = new assFormulaQuestionUnit();
                    $unit->initFormArray($row);
                    if (strcmp($category, $unit->getCategory()) != 0) {
                        $cat = new assFormulaQuestionUnitCategory();
                        $cat->initFormArray(array(
                            'category_id' => $row['category_fi'],
                            'category' => $row['category'],
                            'question_fi' => $row['question_fi'],
                        ));
                        array_push($this->categorizedUnits, $cat);
                        $category = $unit->getCategory();
                    }
                    array_push($this->categorizedUnits, $unit);
                }
            }
        }
 
        return $this->categorizedUnits;
    }

References $categorizedUnits, $DIC, $ilDB, $result, $row, and getConsumerId().

Here is the call graph for this function:

◆ getCategoryUnitCount()

ilUnitConfigurationRepository::getCategoryUnitCount ( $id )

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

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $result = $ilDB->queryF(
            "SELECT * FROM il_qpl_qst_fq_unit WHERE category_fi = %s",
            array('integer'),
            array($id)
        );
        return $result->numRows();
    }

References $DIC, $id, $ilDB, and $result.

◆ getConsumerId()

ilUnitConfigurationRepository::getConsumerId ( )

Returns: int

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

    {
        return $this->consumer_id;
    }

References $consumer_id.

Referenced by getCategorizedUnits().

Here is the caller graph for this function:

◆ getUnit()

ilUnitConfigurationRepository::getUnit ( $id )

Parameters

int $id

Returns: assFormulaQuestionUnit

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

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

References $id, and loadUnits().

Here is the call graph for this function:

◆ getUnitCategories()

ilUnitConfigurationRepository::getUnitCategories ( )

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

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

References $DIC, $ilDB, $result, and $row.

◆ getUnits()

ilUnitConfigurationRepository::getUnits ( )

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

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

References $units, and loadUnits().

Here is the call graph for this function:

◆ isUnitInUse()

ilUnitConfigurationRepository::isUnitInUse ( $id )

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

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $result_1 = $ilDB->queryF(
            "SELECT unit_fi FROM il_qpl_qst_fq_res_unit WHERE unit_fi = %s",
            array('integer'),
            array($id)
        );
 
        $result_2 = $ilDB->queryF(
            "SELECT unit_fi FROM il_qpl_qst_fq_var WHERE unit_fi = %s",
            array('integer'),
            array($id)
        );
        $result_3 = $ilDB->queryF(
            "SELECT unit_fi FROM il_qpl_qst_fq_res WHERE unit_fi = %s",
            array('integer'),
            array($id)
        );
 
        $cnt_1 = $ilDB->numRows($result_1);
        $cnt_2 = $ilDB->numRows($result_2);
        $cnt_3 = $ilDB->numRows($result_3);
 
        if ($cnt_1 || $cnt_2 || $cnt_3) {
            return true;
        } else {
            return false;
        }
    }

References $DIC, $id, and $ilDB.

◆ loadUnits()

ilUnitConfigurationRepository::loadUnits ( )

protected

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

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        if (self::$result_buffer == null) {
            $result = $ilDB->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 ($result->numRows()) {
                while ($row = $ilDB->fetchAssoc($result)) {
                    $unit = new assFormulaQuestionUnit();
                    $unit->initFormArray($row);
                    $this->addUnit($unit);
                }
            }
            self::$result_buffer = $this->units;
        }
        $this->units = self::$result_buffer;
    }

References $DIC, $ilDB, $result, $result_buffer, $row, $units, and 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 ( $category )

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

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $units = array();
        $result = $ilDB->queryF(
            "
                        SELECT units.*, 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 il_qpl_qst_fq_ucat.category_id = %s 
                        ORDER BY units.sequence",
            array('integer'),
            array($category)
        );
        if ($result->numRows()) {
            while ($row = $ilDB->fetchAssoc($result)) {
                $unit = new assFormulaQuestionUnit();
                $unit->initFormArray($row);
                array_push($units, $unit);
            }
        }
        return $units;
    }

References $DIC, $ilDB, $result, $row, and $units.

◆ setConsumerId()

ilUnitConfigurationRepository::setConsumerId ( $consumer_id )

Parameters

int $context_id

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

    {
        $this->consumer_id = $consumer_id;
    }

References $consumer_id.

Field Documentation

◆ $categorizedUnits

ilUnitConfigurationRepository::$categorizedUnits = array()

private

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

Referenced by getCategorizedUnits().

◆ $consumer_id

ilUnitConfigurationRepository::$consumer_id = 0

protected

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

Referenced by getConsumerId(), and setConsumerId().

◆ $lng

ilUnitConfigurationRepository::$lng

protected

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

◆ $result_buffer

ilUnitConfigurationRepository::$result_buffer

static

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

Referenced by loadUnits().

◆ $units

ilUnitConfigurationRepository::$units = array()

private

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

Referenced by getUnits(), loadUnits(), and loadUnitsForCategory().

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

Modules/TestQuestionPool/classes/class.ilUnitConfigurationRepository.php

Public Member Functions

Static Public Attributes

Protected Member Functions

Protected Attributes

Private Attributes

Detailed Description

Member Function Documentation

◆ addUnit()

◆ checkDeleteUnit()

◆ clearUnits()

◆ deleteUnit()

◆ getAdminUnitCategories()

◆ getCategorizedUnits()

◆ getCategoryUnitCount()

◆ getConsumerId()

◆ getUnit()

◆ getUnitCategories()

◆ getUnits()

◆ isUnitInUse()

◆ loadUnits()

◆ loadUnitsForCategory()

◆ setConsumerId()

Field Documentation

◆ $categorizedUnits

◆ $consumer_id

◆ $lng

◆ $result_buffer

◆ $units