ilUnitConfigurationRepository Class Reference

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.

Referenced by loadUnits().

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

Here is the caller graph for this function:

checkDeleteUnit()

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

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

References $DIC, $i, $id, $ilDB, $query, $res, $result, $row, $units, clearUnits(), deleteUnit(), assFormulaQuestionUnit\getBaseUnit(), assFormulaQuestionUnitCategory\getCategory(), assFormulaQuestionUnit\getCategory(), getConsumerId(), assFormulaQuestionUnit\getFactor(), assFormulaQuestionUnitCategory\getId(), assFormulaQuestionUnit\getId(), assFormulaQuestionUnit\getSequence(), assFormulaQuestionUnit\getUnit(), assFormulaQuestionUnitCategory\initFormArray(), assFormulaQuestionUnit\setBaseUnit(), assFormulaQuestionUnit\setFactor(), assFormulaQuestionUnitCategory\setId(), assFormulaQuestionUnit\setId(), and assFormulaQuestionUnit\setSequence().

Referenced by deleteUnit(), and isUnitInUse().

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

Here is the call graph for this function:

Here is the caller graph for this function:

clearUnits()

ilUnitConfigurationRepository::clearUnits ( )

protected

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

Referenced by checkDeleteUnit(), and deleteUnit().

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

Here is the caller graph for this function:

deleteUnit()

ilUnitConfigurationRepository::deleteUnit

(

$id

)

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

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

Referenced by checkDeleteUnit().

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

Here is the call graph for this function:

Here is the caller graph for this function:

getAdminUnitCategories()

ilUnitConfigurationRepository::getAdminUnitCategories

(

)

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

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

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

Here is the call graph for this function:

getCategorizedUnits()

ilUnitConfigurationRepository::getCategorizedUnits

(

)

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

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

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

Here is the call graph for this function:

getCategoryUnitCount()

ilUnitConfigurationRepository::getCategoryUnitCount

(

$id

)

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

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

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

getConsumerId()

ilUnitConfigurationRepository::getConsumerId

(

)

Returns

int

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

References $consumer_id, $DIC, $i, $ilDB, $res, $row, and $units.

Referenced by checkDeleteUnit(), getAdminUnitCategories(), and getCategorizedUnits().

    {
        return $this->consumer_id;
    }

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.

References $id, and loadUnits().

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

Here is the call graph for this function:

getUnitCategories()

ilUnitConfigurationRepository::getUnitCategories

(

)

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

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

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

getUnits()

ilUnitConfigurationRepository::getUnits

(

)

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

References $units, and loadUnits().

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

Here is the call graph for this function:

isUnitInUse()

ilUnitConfigurationRepository::isUnitInUse

(

$id

)

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

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

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

Here is the call graph for this function:

loadUnits()

ilUnitConfigurationRepository::loadUnits ( )

protected

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

References $DIC, $ilDB, $result, $row, $units, and addUnit().

Referenced by getUnit(), and getUnits().

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

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.

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

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

setConsumerId()

ilUnitConfigurationRepository::setConsumerId

(

$consumer_id

)

Parameters

int

$context_id

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

References $consumer_id.

    {
        $this->consumer_id = $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.

$units

ilUnitConfigurationRepository::$units = array()

private

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

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

---

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

• Modules/TestQuestionPool/classes/class.ilUnitConfigurationRepository.php