ILIAS  eassessment Revision 61809
 All Data Structures Namespaces Files Functions Variables Groups Pages
class.ilLPCollections.php
Go to the documentation of this file.
1 <?php
2 
3 /* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */
4 
15 class ilLPCollections
16 {
17  var $db = null;
18 
19  var $obj_id = null;
20  var $items = array();
21 
22  function ilLPCollections($a_obj_id)
23  {
24  global $ilObjDataCache,$ilDB;
25 
26  $this->db =& $ilDB;
27 
28  $this->obj_id = $a_obj_id;
29 
30  $this->__read();
31  }
32 
40  public function cloneCollections($a_target_id,$a_copy_id)
41  {
42  global $ilObjDataCache,$ilLog;
43 
44  $target_obj_id = $ilObjDataCache->lookupObjId($a_target_id);
45 
46  include_once('Services/CopyWizard/classes/class.ilCopyWizardOptions.php');
47  $cwo = ilCopyWizardOptions::_getInstance($a_copy_id);
48  $mappings = $cwo->getMappings();
49 
50  $new_collections = new ilLPCollections($target_obj_id);
51  foreach($this->items as $item)
52  {
53  if(!isset($mappings[$item]) or !$mappings[$item])
54  {
55  continue;
56  }
57  $new_collections->add($mappings[$item]);
58  $ilLog->write(__METHOD__.': Added learning progress collection.');
59  }
60  }
61 
62  function getObjId()
63  {
64  return (int) $this->obj_id;
65  }
66 
67  function getItems()
68  {
69  return $this->items;
70  }
71 
72  function isAssigned($a_ref_id)
73  {
74  return (bool) in_array($a_ref_id,$this->items);
75  }
76 
77  function add($item_id)
78  {
79  global $ilDB;
80 
81  $query = "DELETE FROM ut_lp_collections ".
82  "WHERE obj_id = ".$ilDB->quote($this->obj_id ,'integer')." ".
83  "AND item_id = ".$ilDB->quote($item_id ,'integer')." ";
84  $res = $ilDB->manipulate($query);
85 
86  $query = "INSERT INTO ut_lp_collections (obj_id, item_id) ".
87  "VALUES( ".
88  $ilDB->quote($this->obj_id ,'integer').", ".
89  $ilDB->quote($item_id ,'integer').
90  ")";
91  $res = $ilDB->manipulate($query);
92  $this->__read();
93 
94  return true;
95  }
96 
97  function delete($item_id)
98  {
99  global $ilDB;
100 
101  $query = "DELETE FROM ut_lp_collections ".
102  "WHERE item_id = ".$ilDB->quote($item_id ,'integer')." ".
103  "AND obj_id = ".$ilDB->quote($this->obj_id ,'integer')." ";
104  $res = $ilDB->manipulate($query);
105 
106  $this->__read();
107 
108  return true;
109  }
110 
111 
112  // Static
113  function _getPossibleItems($a_target_id)
114  {
115  global $tree;
116 
117  if($tree->isDeleted($a_target_id))
118  {
119  return array();
120  }
121 
122  $node_data = $tree->getNodeData($a_target_id);
123  foreach($tree->getSubTree($node_data) as $node)
124  {
125  // avoid recursion
126  if($node['ref_id'] == $a_target_id)
127  {
128  continue;
129  }
130 
131  switch($node['type'])
132  {
133  case 'sess':
134  case 'exc':
135  case 'fold':
136  case 'grp':
137  case 'sahs':
138  case 'lm':
139  case 'tst':
140  case 'htlm':
141  $all_possible[] = $node['ref_id'];
142  break;
143  }
144  }
145 
146  return $all_possible ? $all_possible : array();
147  }
148 
149  function _getCountPossibleItems($a_target_id)
150  {
151  return count(ilLPCollections::_getPossibleItems($a_target_id));
152  }
153 
154  function _getCountPossibleSAHSItems($a_target_id)
155  {
156  return count(ilLPCollections::_getPossibleSAHSItems($a_target_id));
157  }
158 
159 
164  function _getPossibleSAHSItems($target_id)
165  {
166  include_once './Modules/ScormAicc/classes/class.ilObjSAHSLearningModule.php';
167 
168  switch(ilObjSAHSLearningModule::_lookupSubType($target_id))
169  {
170  case 'hacp':
171  case 'aicc':
172  include_once './Modules/ScormAicc/classes/class.ilObjAICCLearningModule.php';
173 
174  foreach(ilObjAICCLearningModule::_getTrackingItems($target_id) as $item)
175  {
176  $items["$item[obj_id]"]['title'] = $item['title'];
177  #$items[$item->getId()]['title'] = $item->getTitle();
178  }
179  return $items ? $items : array();
180 
181  case 'scorm':
182  include_once './Modules/ScormAicc/classes/class.ilObjSCORMLearningModule.php';
183  include_once './Modules/ScormAicc/classes/SCORM/class.ilSCORMItem.php';
184 
185  foreach(ilObjSCORMLearningModule::_getTrackingItems($target_id) as $item)
186  {
187  $items[$item->getId()]['title'] = $item->getTitle();
188  }
189  return $items ? $items : array();
190 
191  case 'scorm2004':
192  include_once './Modules/Scorm2004/classes/class.ilObjSCORM2004LearningModule.php';
193 
194  foreach(ilObjSCORM2004LearningModule::_getTrackingItems($target_id) as $item)
195  {
196  $items[$item["id"]]['title'] = $item["title"];
197  }
198  return $items ? $items : array();
199  }
200  return array();
201  }
202 
203  function deleteAll()
204  {
205  return ilLPCollections::_deleteAll($this->getObjId());
206  }
207 
208 
209  function _deleteAll($a_obj_id)
210  {
211  global $ilDB;
212 
213  $query = "DELETE FROM ut_lp_collections ".
214  "WHERE obj_id = ".$ilDB->quote($a_obj_id ,'integer')."";
215  $res = $ilDB->manipulate($query);
216 
217  return true;
218  }
219 
220  function &_getItems($a_obj_id)
221  {
222  global $ilObjDataCache;
223  global $ilDB;
224 
225  include_once 'Services/Tracking/classes/class.ilLPObjSettings.php';
226 
227  $mode = ilLPObjSettings::_lookupMode($a_obj_id);
228  if($mode == LP_MODE_OBJECTIVES)
229  {
230  include_once 'Modules/Course/classes/class.ilCourseObjective.php';
231  return ilCourseObjective::_getObjectiveIds($a_obj_id);
232  }
233  if($mode != LP_MODE_SCORM and $mode != LP_MODE_COLLECTION and $mode != LP_MODE_MANUAL_BY_TUTOR)
234  {
235  return array();
236  }
237 
238  if($ilObjDataCache->lookupType($a_obj_id) != 'sahs')
239  {
240  $course_ref_ids = ilObject::_getAllReferences($a_obj_id);
241  $course_ref_id = end($course_ref_ids);
242  $possible_items = ilLPCollections::_getPossibleItems($course_ref_id);
243 
244  $query = "SELECT * FROM ut_lp_collections utc ".
245  "JOIN object_reference obr ON item_id = ref_id ".
246  "JOIN object_data obd ON obr.obj_id = obd.obj_id ".
247  "WHERE utc.obj_id = ".$ilDB->quote($a_obj_id,'integer')." ".
248  "ORDER BY title";
249  }
250  else
251  {
252  // SAHS
253  $query = "SELECT * FROM ut_lp_collections WHERE obj_id = ".$ilDB->quote($a_obj_id ,'integer')." ";
254  }
255 
256  $res = $ilDB->query($query);
257  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
258  {
259  if($ilObjDataCache->lookupType($a_obj_id) != 'sahs')
260  {
261  if(!in_array($row->item_id,$possible_items))
262  {
263  ilLPCollections::__deleteEntry($a_obj_id,$row->item_id);
264  continue;
265  }
266  }
267  // Check anonymized
268  if($ilObjDataCache->lookupType($item_obj_id = $ilObjDataCache->lookupObjId($row->item_id)) == 'tst')
269  {
270  include_once './Modules/Test/classes/class.ilObjTest.php';
271  if(ilObjTest::_lookupAnonymity($item_obj_id))
272  {
273  ilLPCollections::__deleteEntry($a_obj_id,$row->item_id);
274  continue;
275  }
276  }
277  $items[] = $row->item_id;
278  }
279  return $items ? $items : array();
280  }
281 
282  // Private
283  function __deleteEntry($a_obj_id,$a_item_id)
284  {
285  global $ilDB;
286 
287  $query = "DELETE FROM ut_lp_collections ".
288  "WHERE obj_id = ".$ilDB->quote($a_obj_id ,'integer')." ".
289  "AND item_id = ".$ilDB->quote($a_item_id ,'integer')." ";
290  $res = $ilDB->manipulate($query);
291  return true;
292  }
293 
294 
295  function __read()
296  {
297  global $ilObjDataCache, $ilDB;
298 
299  $this->items = array();
300 
301  if($ilObjDataCache->lookupType($this->getObjId()) != 'sahs')
302  {
303  $course_ref_ids = ilObject::_getAllReferences($this->getObjId());
304  $course_ref_id = end($course_ref_ids);
305  $query = "SELECT * FROM ut_lp_collections utc ".
306  "JOIN object_reference obr ON item_id = ref_id ".
307  "JOIN object_data obd ON obr.obj_id = obd.obj_id ".
308  "WHERE utc.obj_id = ".$this->db->quote($this->obj_id,'integer')." ".
309  "ORDER BY title";
310  }
311  else
312  {
313  $query = "SELECT * FROM ut_lp_collections WHERE obj_id = ".$ilDB->quote($this->getObjId() ,'integer')." ";
314  }
315  $res = $this->db->query($query);
316  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
317  {
318  if($ilObjDataCache->lookupType($this->getObjId()) != 'sahs')
319  {
320  if(!in_array($row->item_id,ilLPCollections::_getPossibleItems($course_ref_id)))
321  {
322  $this->__deleteEntry($this->getObjId(),$row->item_id);
323  continue;
324  }
325  }
326  // Check anonymized
327  if($ilObjDataCache->lookupType($item_obj_id = $ilObjDataCache->lookupObjId($row->item_id)) == 'tst')
328  {
329  include_once './Modules/Test/classes/class.ilObjTest.php';
330  if(ilObjTest::_lookupAnonymity($item_obj_id))
331  {
332  $this->__deleteEntry($this->getObjId(),$row->item_id);
333  continue;
334  }
335  }
336  $this->items[] = $row->item_id;
337  }
338 
339  }
340 }
341 ?>