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

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

Constructor & Destructor Documentation

◆ __construct()

ilGlossaryAdvMetaDataAdapter::__construct ( $a_glo_ref_id )

Constructor.

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

References $DIC, and ilObject\_lookupObjectId().

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

Here is the call graph for this function:

Member Function Documentation

◆ getAllFields()

ilGlossaryAdvMetaDataAdapter::getAllFields ( )

Get all advanced metadata fields.

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

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

Referenced by ilTermListTableGUI\__construct(), ilPresentationListTableGUI\__construct(), and getColumnOrder().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getColumnOrder()

ilGlossaryAdvMetaDataAdapter::getColumnOrder ( )

Get column order.

Parameters

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

References $columns, $db, Vendor\Package\$f, $ilDB, $lng, and getAllFields().

Referenced by ilTermListTableGUI\__construct(), and ilPresentationListTableGUI\__construct().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ saveColumnOrder()

ilGlossaryAdvMetaDataAdapter::saveColumnOrder ( $a_cols )

Save column order.

Parameters

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

References Vendor\Package\$c, $db, and $ilDB.

     {
         $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"];
             }
         }
     }

◆ writeColumnOrder()

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

static

Write single column order.

Parameters

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

References $DIC, and $ilDB.

Referenced by ilGlossaryImporter\finalProcessing().

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