ILIAS  Release_4_4_x_branch Revision 61816
 All Data Structures Namespaces Files Functions Variables Groups Pages
class.ilGlossaryTerm.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
3 
12 class ilGlossaryTerm
13 {
14  var $ilias;
15  var $lng;
16  var $tpl;
17 
18  var $id;
19  var $glossary;
20  var $term;
21  var $language;
22  var $glo_id;
23  var $import_id;
24 
29  function ilGlossaryTerm($a_id = 0)
30  {
31  global $lng, $ilias, $tpl;
32 
33  $this->lng =& $lng;
34  $this->ilias =& $ilias;
35  $this->tpl =& $tpl;
36 
37  $this->id = $a_id;
38  $this->type = "term";
39  if ($a_id != 0)
40  {
41  $this->read();
42  }
43  }
44 
48  function read()
49  {
50  global $ilDB;
51 
52  $q = "SELECT * FROM glossary_term WHERE id = ".
53  $ilDB->quote($this->id, "integer");
54  $term_set = $ilDB->query($q);
55  $term_rec = $ilDB->fetchAssoc($term_set);
56 
57  $this->setTerm($term_rec["term"]);
58  $this->setImportId($term_rec["import_id"]);
59  $this->setLanguage($term_rec["language"]);
60  $this->setGlossaryId($term_rec["glo_id"]);
61 
62  }
63 
71  function _getIdForImportId($a_import_id)
72  {
73  global $ilDB;
74 
75  if ($a_import_id == "")
76  {
77  return 0;
78  }
79 
80  $q = "SELECT * FROM glossary_term WHERE import_id = ".
81  $ilDB->quote($a_import_id, "text").
82  " ORDER BY create_date DESC";
83  $term_set = $ilDB->query($q);
84  while ($term_rec = $ilDB->fetchAssoc($term_set))
85  {
86  $glo_id = ilGlossaryTerm::_lookGlossaryID($term_rec["id"]);
87 
88  if (ilObject::_hasUntrashedReference($glo_id))
89  {
90  return $term_rec["id"];
91  }
92  }
93 
94  return 0;
95  }
96 
97 
105  function _exists($a_id)
106  {
107  global $ilDB;
108 
109  include_once("./Services/COPage/classes/class.ilInternalLink.php");
110  if (is_int(strpos($a_id, "_")))
111  {
112  $a_id = ilInternalLink::_extractObjIdOfTarget($a_id);
113  }
114 
115  $q = "SELECT * FROM glossary_term WHERE id = ".
116  $ilDB->quote($a_id, "integer");
117  $obj_set = $ilDB->query($q);
118  if ($obj_rec = $ilDB->fetchAssoc($obj_set))
119  {
120  return true;
121  }
122  else
123  {
124  return false;
125  }
126 
127  }
128 
129 
135  function setId($a_id)
136  {
137  $this->id = $a_id;
138  }
139 
140 
146  function getId()
147  {
148  return $this->id;
149  }
150 
156  function setGlossary(&$a_glossary)
157  {
158  $this->glossary =& $a_glossary;
159  $this->setGlossaryId($a_glossary->getId());
160  }
161 
162 
168  function setGlossaryId($a_glo_id)
169  {
170  $this->glo_id = $a_glo_id;
171  }
172 
173 
179  function getGlossaryId()
180  {
181  return $this->glo_id;
182  }
183 
184 
190  function setTerm($a_term)
191  {
192  $this->term = $a_term;
193  }
194 
195 
201  function getTerm()
202  {
203  return $this->term;
204  }
205 
206 
212  function setLanguage($a_language)
213  {
214  $this->language = $a_language;
215  }
216 
221  function getLanguage()
222  {
223  return $this->language;
224  }
225 
226 
230  function setImportId($a_import_id)
231  {
232  $this->import_id = $a_import_id;
233  }
234 
235 
239  function getImportId()
240  {
241  return $this->import_id;
242  }
243 
244 
248  function create()
249  {
250  global $ilDB;
251 
252  $this->setId($ilDB->nextId("glossary_term"));
253  $ilDB->manipulate("INSERT INTO glossary_term (id, glo_id, term, language, import_id, create_date, last_update)".
254  " VALUES (".
255  $ilDB->quote($this->getId(), "integer").", ".
256  $ilDB->quote($this->getGlossaryId(), "integer").", ".
257  $ilDB->quote($this->term, "text").", ".
258  $ilDB->quote($this->language, "text").",".
259  $ilDB->quote($this->getImportId(), "text").",".
260  $ilDB->now().", ".
261  $ilDB->now().")");
262  }
263 
264 
268  function delete()
269  {
270  global $ilDB;
271 
272  require_once("./Modules/Glossary/classes/class.ilGlossaryDefinition.php");
273  $defs = ilGlossaryDefinition::getDefinitionList($this->getId());
274  foreach($defs as $def)
275  {
276  $def_obj =& new ilGlossaryDefinition($def["id"]);
277  $def_obj->delete();
278  }
279  $ilDB->manipulate("DELETE FROM glossary_term ".
280  " WHERE id = ".$ilDB->quote($this->getId(), "integer"));
281  }
282 
283 
287  function update()
288  {
289  global $ilDB;
290 
291  $ilDB->manipulate("UPDATE glossary_term SET ".
292  " glo_id = ".$ilDB->quote($this->getGlossaryId(), "integer").", ".
293  " term = ".$ilDB->quote($this->getTerm(), "text").", ".
294  " import_id = ".$ilDB->quote($this->getImportId(), "text").", ".
295  " language = ".$ilDB->quote($this->getLanguage(), "text").", ".
296  " last_update = ".$ilDB->now()." ".
297  " WHERE id = ".$ilDB->quote($this->getId(), "integer"));
298  }
299 
303  function _lookGlossaryID($term_id)
304  {
305  global $ilDB;
306 
307  $query = "SELECT * FROM glossary_term WHERE id = ".
308  $ilDB->quote($term_id, "integer");
309  $obj_set = $ilDB->query($query);
310  $obj_rec = $ilDB->fetchAssoc($obj_set);
311 
312  return $obj_rec["glo_id"];
313  }
314 
318  function _lookGlossaryTerm($term_id)
319  {
320  global $ilDB;
321 
322  $query = "SELECT * FROM glossary_term WHERE id = ".
323  $ilDB->quote($term_id, "integer");
324  $obj_set = $ilDB->query($query);
325  $obj_rec = $ilDB->fetchAssoc($obj_set);
326 
327  return $obj_rec["term"];
328  }
329 
333  function _lookLanguage($term_id)
334  {
335  global $ilDB;
336 
337  $query = "SELECT * FROM glossary_term WHERE id = ".
338  $ilDB->quote($term_id, "integer");
339  $obj_set = $ilDB->query($query);
340  $obj_rec = $ilDB->fetchAssoc($obj_set);
341 
342  return $obj_rec["language"];
343  }
344 
353  static function getTermList($a_glo_id, $searchterm = "", $a_first_letter = "", $a_def = "",
354  $a_tax_node = 0, $a_add_amet_fields = false, $a_amet_filter = "")
355  {
356  global $ilDB;
357 
358  $terms = array();
359 
360  // get all term ids under taxonomy node (if given)
361  if ($a_tax_node > 1)
362  {
363  include_once("./Services/Taxonomy/classes/class.ilObjTaxonomy.php");
364  $tax_ids = ilObjTaxonomy::getUsageOfObject($a_glo_id);
365  if (count($tax_ids) > 0)
366  {
367  $items = ilObjTaxonomy::getSubTreeItems("glo", $a_glo_id, "term", $tax_ids[0], $a_tax_node);
368  $sub_tree_ids = array();
369  foreach ($items as $i)
370  {
371  $sub_tree_ids[] = $i["item_id"];
372  }
373  $in = " AND ".$ilDB->in("gt.id", $sub_tree_ids, false, "integer");
374  }
375  }
376 
377  if ($a_def != "")
378  {
379  $join = " JOIN glossary_definition gd ON (gd.term_id = gt.id)".
380  " JOIN page_object ON (".
381  "page_object.parent_id = ".$ilDB->quote($a_glo_id, "integer").
382  " AND page_object.parent_type = ".$ilDB->quote("gdf", "text").
383  " AND page_object.page_id = gd.id".
384  " AND ".$ilDB->like("page_object.content", "text", "%".$a_def."%").
385  ")";
386  }
387 
388  $searchterm = (!empty ($searchterm))
389  ? " AND ".$ilDB->like("term", "text", "%".$searchterm."%")." "
390  : "";
391 
392  if ($a_first_letter != "")
393  {
394  $searchterm.= " AND ".$ilDB->upper($ilDB->substr("term", 1, 1))." = ".$ilDB->upper($ilDB->quote($a_first_letter, "text"))." ";
395  }
396 
397  // meta glossary
398  if (is_array($a_glo_id))
399  {
400  $where = $ilDB->in("glo_id", $a_glo_id, false, "integer");
401  }
402  else
403  {
404  $where = " glo_id = ".$ilDB->quote($a_glo_id, "integer")." ";
405  }
406 
407  $where.= $in;
408 
409  $q = "SELECT gt.term, gt.id, gt.glo_id, gt.language FROM glossary_term gt ".$join." WHERE ".$where.$searchterm." ORDER BY term";
410  $term_set = $ilDB->query($q);
411 //var_dump($q);
412  while ($term_rec = $ilDB->fetchAssoc($term_set))
413  {
414  $terms[] = array("term" => $term_rec["term"],
415  "language" => $term_rec["language"], "id" => $term_rec["id"], "glo_id" => $term_rec["glo_id"]);
416  }
417 
418  // add advanced metadata
419  if ($a_add_amet_fields || is_array($a_amet_filter))
420  {
421  include_once("./Services/AdvancedMetaData/classes/class.ilAdvancedMDValues.php");
422  $terms = ilAdvancedMDValues::queryForRecords($a_glo_id, "term", $terms, "glo_id", "id", $a_amet_filter);
423  }
424  return $terms;
425  }
426 
435  static function getFirstLetters($a_glo_id, $a_tax_node = 0)
436  {
437  global $ilDB;
438 
439  $terms = array();
440 
441  // meta glossary
442  if (is_array($a_glo_id))
443  {
444  $where = $ilDB->in("glo_id", $a_glo_id, false, "integer");
445  }
446  else
447  {
448  $where = " glo_id = ".$ilDB->quote($a_glo_id, "integer")." ";
449 
450  // get all term ids under taxonomy node (if given)
451  if ($a_tax_node > 1)
452  {
453  include_once("./Services/Taxonomy/classes/class.ilObjTaxonomy.php");
454  $tax_ids = ilObjTaxonomy::getUsageOfObject($a_glo_id);
455  if (count($tax_ids) > 0)
456  {
457  $items = ilObjTaxonomy::getSubTreeItems("glo", $a_glo_id, "term", $tax_ids[0], $a_tax_node);
458  $sub_tree_ids = array();
459  foreach ($items as $i)
460  {
461  $sub_tree_ids[] = $i["item_id"];
462  }
463  $in = " AND ".$ilDB->in("id", $sub_tree_ids, false, "integer");
464  }
465  }
466 
467  $where.= $in;
468  }
469 
470  $q = "SELECT DISTINCT ".$ilDB->upper($ilDB->substr("term", 1, 1))." let FROM glossary_term WHERE ".$where." ORDER BY let";
471  $let_set = $ilDB->query($q);
472 
473  $lets = array();
474  while ($let_rec = $ilDB->fetchAssoc($let_set))
475  {
476  $let[$let_rec["let"]] = $let_rec["let"];
477  }
478  return $let;
479  }
480 
484  function exportXML(&$a_xml_writer, $a_inst)
485  {
486 
487  $attrs = array();
488  $attrs["Language"] = $this->getLanguage();
489  $attrs["Id"] = "il_".IL_INST_ID."_git_".$this->getId();
490  $a_xml_writer->xmlStartTag("GlossaryItem", $attrs);
491 
492  $attrs = array();
493  $a_xml_writer->xmlElement("GlossaryTerm", $attrs, $this->getTerm());
494 
495  $defs = ilGlossaryDefinition::getDefinitionList($this->getId());
496 
497  foreach($defs as $def)
498  {
499  $definition = new ilGlossaryDefinition($def["id"]);
500  $definition->exportXML($a_xml_writer, $a_inst);
501  }
502 
503  $a_xml_writer->xmlEndTag("GlossaryItem");
504  }
505 
512  static function getNumberOfUsages($a_term_id)
513  {
514  return count(ilGlossaryTerm::getUsages($a_term_id));
515  }
516 
523  static function getUsages($a_term_id)
524  {
525  include_once("./Services/COPage/classes/class.ilInternalLink.php");
526  return (ilInternalLink::_getSourcesOfTarget("git", $a_term_id, 0));
527  }
528 
535  function _copyTerm($a_term_id, $a_glossary_id)
536  {
537  $old_term = new ilGlossaryTerm($a_term_id);
538 
539  // copy the term
540  $new_term = new ilGlossaryTerm();
541  $new_term->setTerm($old_term->getTerm());
542  $new_term->setLanguage($old_term->getLanguage());
543  $new_term->setGlossaryId($a_glossary_id);
544  $new_term->create();
545 
546  // copy the definitions
547  include_once("./Modules/Glossary/classes/class.ilGlossaryDefinition.php");
548  $def_list = ilGlossaryDefinition::getDefinitionList($a_term_id);
549  foreach ($def_list as $def)
550  {
551  $old_def = new ilGlossaryDefinition($def["id"]);
552 
553  $new_def = new ilGlossaryDefinition();
554  $new_def->setShortText($old_def->getShortText());
555  $new_def->setNr($old_def->getNr());
556  $new_def->setTermId($new_term->getId());
557  $new_def->create();
558 
559  // copy meta data
560  include_once("Services/MetaData/classes/class.ilMD.php");
561  $md = new ilMD($old_term->getGlossaryId(),
562  $old_def->getPageObject()->getId(),
563  $old_def->getPageObject()->getParentType());
564  $new_md = $md->cloneMD($a_glossary_id,
565  $new_def->getPageObject()->getId(),
566  $old_def->getPageObject()->getParentType());
567 
568 
569  $new_page = $new_def->getPageObject();
570  $old_def->getPageObject()->copy($new_page->getId(), $new_page->getParentType(), $new_page->getParentId(), true);
571 
572  // page content
573  //$new_def->getPageObject()->setXMLContent($old_def->getPageObject()->copyXmlContent(true));
574  //$new_def->getPageObject()->buildDom();
575  //$new_def->getPageObject()->update();
576 
577  }
578 
579  return $new_term->getId();
580  }
581 
588  static function getTermsOfGlossary($a_glo_id)
589  {
590  global $ilDB;
591 
592  $set = $ilDB->query("SELECT id FROM glossary_term WHERE ".
593  " glo_id = ".$ilDB->quote($a_glo_id, "integer")
594  );
595  $ids = array();
596  while ($rec = $ilDB->fetchAssoc($set))
597  {
598  $ids[] = $rec["id"];
599  }
600  return $ids;
601  }
602 }
603 
604 ?>