Advanced meta data adapter. More...

Collaboration diagram for ilGlossaryAdvMetaDataAdapter:

Public Member Functions
	__construct ($a_glo_ref_id)
	Constructor. More...

	getAllFields ()
	Get all advanced metadata fields. More...

	getColumnOrder ()
	Get column order. More...

	saveColumnOrder ($a_cols)
	Save column order. More...

Static Public Member Functions
static	writeColumnOrder ($a_glo_id, $a_field_id, $a_order_nr)
	Write single column order. More...

Protected Attributes
	$db

	$lng

Detailed Description

Advanced meta data adapter.

Author: Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version: $Id$

Definition at line 12 of file class.ilGlossaryAdvMetaDataAdapter.php.

Constructor & Destructor Documentation

◆ __construct()

ilGlossaryAdvMetaDataAdapter::__construct ( $a_glo_ref_id )

Constructor.

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

    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->lng = $DIC->language();
        $this->glo_id = ilObject::_lookupObjectId($a_glo_ref_id);
        $this->glo_ref_id = $a_glo_ref_id;
    }

References $DIC, and ilObject\_lookupObjectId().

Here is the call graph for this function:

Member Function Documentation

◆ getAllFields()

ilGlossaryAdvMetaDataAdapter::getAllFields ( )

Get all advanced metadata fields.

Definition at line 41 of file class.ilGlossaryAdvMetaDataAdapter.php.

    {
        $fields = array();
        include_once('Services/AdvancedMetaData/classes/class.ilAdvancedMDRecord.php');
        $recs = ilAdvancedMDRecord::_getSelectedRecordsByObject("glo", $this->glo_ref_id, "term");
 
        foreach ($recs as $record_obj) {
            include_once('Services/AdvancedMetaData/classes/class.ilAdvancedMDFieldDefinition.php');
            foreach (ilAdvancedMDFieldDefinition::getInstancesByRecordId($record_obj->getRecordId()) as $def) {
                $fields[$def->getFieldId()] = array(
                    "id" => $def->getFieldId(),
                    "title" => $def->getTitle(),
                    "type" => $def->getType()
                    );
            }
        }
 
        return $fields;
    }

References $def, ilAdvancedMDRecord\_getSelectedRecordsByObject(), and ilAdvancedMDFieldDefinition\getInstancesByRecordId().

Referenced by getColumnOrder().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getColumnOrder()

ilGlossaryAdvMetaDataAdapter::getColumnOrder ( )

Get column order.

Parameters

return

Definition at line 67 of file class.ilGlossaryAdvMetaDataAdapter.php.

    {
        $ilDB = $this->db;
        $lng = $this->lng;
        
        $columns = array();
        
        $set = $ilDB->query(
            "SELECT * FROM glo_advmd_col_order " .
                " WHERE glo_id = " . $ilDB->quote($this->glo_id, "integer") .
                " ORDER BY order_nr"
        );
        $order = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $order[$rec["field_id"]] = $rec["order_nr"];
        }
        //var_dump($order);
        // add term at beginning, if not included
        if (!isset($order[0])) {
            $columns[] = array("id" => 0,
                "text" => $lng->txt("cont_term"));
        }
 
        $fields = $this->getAllFields();
        
        // add all fields that have been already sorted
        foreach ($order as $id => $order_nr) {
            if (isset($fields[$id])) {
                $columns[] = array("id" => $id,
                    "text" => $fields[$id]["title"]);
                unset($fields[$id]);
            } elseif ($id == 0) {
                $columns[] = array("id" => 0,
                    "text" => $lng->txt("cont_term"));
            }
        }
        
        // add all fields that have not been sorted
        foreach ($fields as $f) {
            $columns[] = array("id" => $f["id"],
                "text" => $f["title"]);
        }
        
        return $columns;
    }

References $columns, $db, $id, $ilDB, $lng, and getAllFields().

Here is the call graph for this function:

◆ saveColumnOrder()

ilGlossaryAdvMetaDataAdapter::saveColumnOrder ( $a_cols )

Save column order.

Parameters

return

Definition at line 119 of file class.ilGlossaryAdvMetaDataAdapter.php.

    {
        $ilDB = $this->db;
        
        $ilDB->manipulate(
            "DELETE FROM glo_advmd_col_order WHERE " .
            " glo_id = " . $ilDB->quote($this->glo_id, "integer")
        );
 
        $nr = 10;
        $set = array();
        foreach ($a_cols as $c) {
            //var_dump($c);
            if (!isset($set[$c["id"]])) {
                $ilDB->manipulate("INSERT INTO glo_advmd_col_order " .
                        "(glo_id, field_id, order_nr) VALUES (" .
                        $ilDB->quote($this->glo_id, "integer") . "," .
                        $ilDB->quote($c["id"], "integer") . "," .
                        $ilDB->quote($nr+=10, "integer") .
                        ")");
                $set[$c["id"]] = $c["id"];
            }
        }
    }

References $db, and $ilDB.

◆ writeColumnOrder()

static ilGlossaryAdvMetaDataAdapter::writeColumnOrder	(	$a_glo_id,
		$a_field_id,
		$a_order_nr
	)

static

Write single column order.

Parameters

return

Definition at line 150 of file class.ilGlossaryAdvMetaDataAdapter.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $ilDB->replace(
            "glo_advmd_col_order",
            array("glo_id" => array("integer", $a_glo_id),
                "field_id" => array("integer", $a_field_id)),
            array("order_nr" => array("integer", $a_order_nr))
        );
    }