ILIAS  release_4-3 Revision
 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)
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($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  return $terms;
418  }
419 
428  static function getFirstLetters($a_glo_id, $a_tax_node = 0)
429  {
430  global $ilDB;
431 
432  $terms = array();
433 
434  // meta glossary
435  if (is_array($a_glo_id))
436  {
437  $where = $ilDB->in("glo_id", $a_glo_id, false, "integer");
438  }
439  else
440  {
441  $where = " glo_id = ".$ilDB->quote($a_glo_id, "integer")." ";
442 
443  // get all term ids under taxonomy node (if given)
444  if ($a_tax_node > 1)
445  {
446  include_once("./Services/Taxonomy/classes/class.ilObjTaxonomy.php");
447  $tax_ids = ilObjTaxonomy::getUsageOfObject($a_glo_id);
448  if (count($tax_ids) > 0)
449  {
450  $items = ilObjTaxonomy::getSubTreeItems($tax_ids[0], $a_tax_node);
451  $sub_tree_ids = array();
452  foreach ($items as $i)
453  {
454  $sub_tree_ids[] = $i["item_id"];
455  }
456  $in = " AND ".$ilDB->in("id", $sub_tree_ids, false, "integer");
457  }
458  }
459 
460  $where.= $in;
461  }
462 
463  $q = "SELECT DISTINCT ".$ilDB->upper($ilDB->substr("term", 1, 1))." let FROM glossary_term WHERE ".$where." ORDER BY let";
464  $let_set = $ilDB->query($q);
465 
466  $lets = array();
467  while ($let_rec = $ilDB->fetchAssoc($let_set))
468  {
469  $let[$let_rec["let"]] = $let_rec["let"];
470  }
471  return $let;
472  }
473 
477  function exportXML(&$a_xml_writer, $a_inst)
478  {
479 
480  $attrs = array();
481  $attrs["Language"] = $this->getLanguage();
482  $attrs["Id"] = "il_".IL_INST_ID."_git_".$this->getId();
483  $a_xml_writer->xmlStartTag("GlossaryItem", $attrs);
484 
485  $attrs = array();
486  $a_xml_writer->xmlElement("GlossaryTerm", $attrs, $this->getTerm());
487 
488  $defs = ilGlossaryDefinition::getDefinitionList($this->getId());
489 
490  foreach($defs as $def)
491  {
492  $definition = new ilGlossaryDefinition($def["id"]);
493  $definition->exportXML($a_xml_writer, $a_inst);
494  }
495 
496  $a_xml_writer->xmlEndTag("GlossaryItem");
497  }
498 
505  static function getNumberOfUsages($a_term_id)
506  {
507  return count(ilGlossaryTerm::getUsages($a_term_id));
508  }
509 
516  static function getUsages($a_term_id)
517  {
518  include_once("./Services/COPage/classes/class.ilInternalLink.php");
519  return (ilInternalLink::_getSourcesOfTarget("git", $a_term_id, 0));
520  }
521 
528  function _copyTerm($a_term_id, $a_glossary_id)
529  {
530  $old_term = new ilGlossaryTerm($a_term_id);
531 
532  // copy the term
533  $new_term = new ilGlossaryTerm();
534  $new_term->setTerm($old_term->getTerm());
535  $new_term->setLanguage($old_term->getLanguage());
536  $new_term->setGlossaryId($a_glossary_id);
537  $new_term->create();
538 
539  // copy the definitions
540  include_once("./Modules/Glossary/classes/class.ilGlossaryDefinition.php");
541  $def_list = ilGlossaryDefinition::getDefinitionList($a_term_id);
542  foreach ($def_list as $def)
543  {
544  $old_def = new ilGlossaryDefinition($def["id"]);
545 
546  $new_def = new ilGlossaryDefinition();
547  $new_def->setShortText($old_def->getShortText());
548  $new_def->setNr($old_def->getNr());
549  $new_def->setTermId($new_term->getId());
550  $new_def->create();
551 
552  // copy meta data
553  include_once("Services/MetaData/classes/class.ilMD.php");
554  $md = new ilMD($old_term->getGlossaryId(),
555  $old_def->getPageObject()->getId(),
556  $old_def->getPageObject()->getParentType());
557  $new_md = $md->cloneMD($a_glossary_id,
558  $new_def->getPageObject()->getId(),
559  $old_def->getPageObject()->getParentType());
560 
561  // page content
562  $new_def->getPageObject()->setXMLContent($old_def->getPageObject()->copyXmlContent(true));
563  $new_def->getPageObject()->buildDom();
564  $new_def->getPageObject()->update();
565 
566  }
567 
568  return $new_term->getId();
569  }
570 
577  static function getTermsOfGlossary($a_glo_id)
578  {
579  global $ilDB;
580 
581  $set = $ilDB->query("SELECT id FROM glossary_term WHERE ".
582  " glo_id = ".$ilDB->quote($a_glo_id, "integer")
583  );
584  $ids = array();
585  while ($rec = $ilDB->fetchAssoc($set))
586  {
587  $ids[] = $rec["id"];
588  }
589  return $ids;
590  }
591 }
592 
593 ?>