ILIAS  Release_4_1_x_branch Revision 61804
 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  {
355  global $ilDB;
356 
357  $terms = array();
358 
359  if ($a_def != "")
360  {
361  $join = " JOIN glossary_definition gd ON (gd.term_id = gt.id)".
362  " JOIN page_object ON (".
363  "page_object.parent_id = ".$ilDB->quote($a_glo_id, "integer").
364  " AND page_object.parent_type = ".$ilDB->quote("gdf", "text").
365  " AND page_object.page_id = gd.id".
366  " AND ".$ilDB->like("page_object.content", "text", "%".$a_def."%").
367  ")";
368  }
369 
370  $searchterm = (!empty ($searchterm))
371  ? " AND ".$ilDB->like("term", "text", "%".$searchterm."%")." "
372  : "";
373 
374  if ($a_first_letter != "")
375  {
376  $searchterm.= " AND ".$ilDB->upper($ilDB->substr("term", 1, 1))." = ".$ilDB->upper($ilDB->quote($a_first_letter, "text"))." ";
377  }
378 
379  // meta glossary
380  if (is_array($a_glo_id))
381  {
382  $where = $ilDB->in("glo_id", $a_glo_id, false, "integer");
383  }
384  else
385  {
386  $where = " glo_id = ".$ilDB->quote($a_glo_id, "integer")." ";
387  }
388 
389  $q = "SELECT gt.term, gt.id, gt.glo_id, gt.language FROM glossary_term gt ".$join." WHERE ".$where.$searchterm." ORDER BY term";
390  $term_set = $ilDB->query($q);
391 //var_dump($q);
392  while ($term_rec = $ilDB->fetchAssoc($term_set))
393  {
394  $terms[] = array("term" => $term_rec["term"],
395  "language" => $term_rec["language"], "id" => $term_rec["id"], "glo_id" => $term_rec["glo_id"]);
396  }
397  return $terms;
398  }
399 
408  static function getFirstLetters($a_glo_id)
409  {
410  global $ilDB;
411 
412  $terms = array();
413 
414  // meta glossary
415  if (is_array($a_glo_id))
416  {
417  $where = $ilDB->in("glo_id", $a_glo_id, false, "integer");
418  }
419  else
420  {
421  $where = " glo_id = ".$ilDB->quote($a_glo_id, "integer")." ";
422  }
423 
424  $q = "SELECT DISTINCT ".$ilDB->upper($ilDB->substr("term", 1, 1))." let FROM glossary_term WHERE ".$where." ORDER BY let";
425  $let_set = $ilDB->query($q);
426 
427  $lets = array();
428  while ($let_rec = $ilDB->fetchAssoc($let_set))
429  {
430  $let[$let_rec["let"]] = $let_rec["let"];
431  }
432  return $let;
433  }
434 
438  function exportXML(&$a_xml_writer, $a_inst)
439  {
440 
441  $attrs = array();
442  $attrs["Language"] = $this->getLanguage();
443  $attrs["Id"] = "il_".IL_INST_ID."_git_".$this->getId();
444  $a_xml_writer->xmlStartTag("GlossaryItem", $attrs);
445 
446  $attrs = array();
447  $a_xml_writer->xmlElement("GlossaryTerm", $attrs, $this->getTerm());
448 
449  $defs = ilGlossaryDefinition::getDefinitionList($this->getId());
450 
451  foreach($defs as $def)
452  {
453  $definition = new ilGlossaryDefinition($def["id"]);
454  $definition->exportXML($a_xml_writer, $a_inst);
455  }
456 
457  $a_xml_writer->xmlEndTag("GlossaryItem");
458  }
459 
466  static function getNumberOfUsages($a_term_id)
467  {
468  return count(ilGlossaryTerm::getUsages($a_term_id));
469  }
470 
477  static function getUsages($a_term_id)
478  {
479  include_once("./Services/COPage/classes/class.ilInternalLink.php");
480  return (ilInternalLink::_getSourcesOfTarget("git", $a_term_id, 0));
481  }
482 
489  function _copyTerm($a_term_id, $a_glossary_id)
490  {
491  $old_term = new ilGlossaryTerm($a_term_id);
492 
493  // copy the term
494  $new_term = new ilGlossaryTerm();
495  $new_term->setTerm($old_term->getTerm());
496  $new_term->setLanguage($old_term->getLanguage());
497  $new_term->setGlossaryId($a_glossary_id);
498  $new_term->create();
499 
500  // copy the definitions
501  include_once("./Modules/Glossary/classes/class.ilGlossaryDefinition.php");
502  $def_list = ilGlossaryDefinition::getDefinitionList($a_term_id);
503  foreach ($def_list as $def)
504  {
505  $old_def = new ilGlossaryDefinition($def["id"]);
506 
507  $new_def = new ilGlossaryDefinition();
508  $new_def->setShortText($old_def->getShortText());
509  $new_def->setNr($old_def->getNr());
510  $new_def->setTermId($new_term->getId());
511  $new_def->create();
512 
513  // copy meta data
514  include_once("Services/MetaData/classes/class.ilMD.php");
515  $md = new ilMD($old_term->getGlossaryId(),
516  $old_def->getPageObject()->getId(),
517  $old_def->getPageObject()->getParentType());
518  $new_md = $md->cloneMD($a_glossary_id,
519  $new_def->getPageObject()->getId(),
520  $old_def->getPageObject()->getParentType());
521 
522  // page content
523  $new_def->getPageObject()->setXMLContent($old_def->getPageObject()->getXMLContent());
524  $new_def->getPageObject()->buildDom();
525  $new_def->getPageObject()->update();
526 
527  }
528 
529  return $new_term->getId();
530  }
531 
538  static function getTermsOfGlossary($a_glo_id)
539  {
540  global $ilDB;
541 
542  $set = $ilDB->query("SELECT id FROM glossary_term WHERE ".
543  " glo_id = ".$ilDB->quote($a_glo_id, "integer")
544  );
545  $ids = array();
546  while ($rec = $ilDB->fetchAssoc($set))
547  {
548  $ids[] = $rec["id"];
549  }
550  return $ids;
551  }
552 
553 }
554 
555 ?>