ILIAS  release_4-4 Revision
•All Data Structures Namespaces Files Functions Variables Modules Pages
class.ilCalendarCategories.php
Go to the documentation of this file.
1 <?php
2 /*
3  +-----------------------------------------------------------------------------+
4  | ILIAS open source |
5  +-----------------------------------------------------------------------------+
6  | Copyright (c) 1998-2006 ILIAS open source, University of Cologne |
7  | |
8  | This program is free software; you can redistribute it and/or |
9  | modify it under the terms of the GNU General Public License |
10  | as published by the Free Software Foundation; either version 2 |
11  | of the License, or (at your option) any later version. |
12  | |
13  | This program is distributed in the hope that it will be useful, |
14  | but WITHOUT ANY WARRANTY; without even the implied warranty of |
15  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
16  | GNU General Public License for more details. |
17  | |
18  | You should have received a copy of the GNU General Public License |
19  | along with this program; if not, write to the Free Software |
20  | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
21  +-----------------------------------------------------------------------------+
22 */
23 
24 include_once('./Services/Calendar/classes/class.ilCalendarCategory.php');
25 include_once('./Services/Calendar/classes/class.ilCalendarSettings.php');
26 include_once './Services/Calendar/classes/class.ilCalendarCache.php';
27 
37 class ilCalendarCategories
38 {
39  const MODE_REPOSITORY = 2;
40  const MODE_REMOTE_ACCESS = 3;
41  const MODE_PERSONAL_DESKTOP_MEMBERSHIP = 4;
42  const MODE_PERSONAL_DESKTOP_ITEMS = 5;
43  const MODE_MANAGE = 6;
44  const MODE_CONSULTATION = 7;
45  const MODE_PORTFOLIO_CONSULTATION = 8;
46  const MODE_REMOTE_SELECTED = 9;
47 
48  protected static $instance = null;
49 
50  protected $db;
51 
52  protected $user_id;
53 
54  protected $mode = 0;
55 
56  protected $categories = array();
57  protected $categories_info = array();
58  protected $subitem_categories = array();
59 
60  protected $root_ref_id = 0;
61  protected $root_obj_id = 0;
62 
63 
64  protected $ch_user_id = 0;
65  protected $target_ref_id = 0;
66 
74  protected function __construct($a_usr_id = 0)
75  {
76  global $ilUser,$ilDB;
77 
78  $this->user_id = $a_usr_id;
79  if(!$this->user_id)
80  {
81  $this->user_id = $ilUser->getId();
82  }
83  $this->db = $ilDB;
84  }
85 
94  public static function _getInstance($a_usr_id = 0)
95  {
96  if(self::$instance)
97  {
98  return self::$instance;
99  }
100  return self::$instance = new ilCalendarCategories($a_usr_id);
101  }
102 
111  public static function _lookupCategoryIdByObjId($a_obj_id)
112  {
113  global $ilDB;
114 
115  $query = "SELECT cat_id FROM cal_categories ".
116  "WHERE obj_id = ".$ilDB->quote($a_obj_id ,'integer')." ".
117  "AND type = ".$ilDB->quote(ilCalendarCategory::TYPE_OBJ,'integer')." ";
118 
119  $res = $ilDB->query($query);
120  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
121  {
122  return $row->cat_id;
123  }
124  return 0;
125  }
126 
127 
137  public static function _isOwner($a_usr_id,$a_cal_id)
138  {
139  global $ilDB;
140 
141  $query = "SELECT * FROM cal_categories ".
142  "WHERE cat_id = ".$ilDB->quote($a_cal_id ,'integer')." ".
143  "AND obj_id = ".$ilDB->quote($a_usr_id ,'integer')." ".
144  "AND type = ".$ilDB->quote(ilCalendarCategory::TYPE_USR ,'integer')." ";
145  $res = $ilDB->query($query);
146  return $res->numRows() ? true : false;
147  }
148 
154  public static function deletePDItemsCache($a_usr_id)
155  {
156  ilCalendarCache::getInstance()->deleteByAdditionalKeys(
157  $a_usr_id,
158  self::MODE_PERSONAL_DESKTOP_ITEMS,
159  'categories'
160  );
161  }
162 
168  public static function deleteRepositoryCache($a_usr_id)
169  {
170  ilCalendarCache::getInstance()->deleteByAdditionalKeys(
171  $a_usr_id,
172  self::MODE_REPOSITORY,
173  'categories'
174  );
175 
176  }
177 
178 
183  protected function sleep()
184  {
185  return serialize(
186  array(
187  'categories' => $this->categories,
188  'categories_info' => $this->categories_info,
189  'subitem_categories'=> $this->subitem_categories
190  )
191  );
192  }
193 
199  protected function wakeup($a_ser)
200  {
201  $info = unserialize($a_ser);
202 
203  $this->categories = $info['categories'];
204  $this->categories_info = $info['categories_info'];
205  $this->subitem_categories = $info['subitem_categories'];
206  }
207 
212  public function setCHUserId($a_user_id)
213  {
214  $this->ch_user_id = $a_user_id;
215  }
216 
217 
222  public function getCHUserId()
223  {
224  return $this->ch_user_id;
225  }
226 
227  protected function setMode($a_mode)
228  {
229  $this->mode = $a_mode;
230  }
231 
232  public function getMode()
233  {
234  return $this->mode;
235  }
236 
237  protected function setTargetRefId($a_ref_id)
238  {
239  $this->target_ref_id = $a_ref_id;
240  }
241 
242  public function getTargetRefId()
243  {
244  return $this->target_ref_id;
245  }
246 
255  public function initialize($a_mode,$a_source_ref_id = 0,$a_use_cache = false)
256  {
257  $this->setMode($a_mode);
258  if($a_use_cache)
259  {
260  // Read categories from cache
261  if($cats = ilCalendarCache::getInstance()->getEntry($this->user_id.':'.$a_mode.':categories:'.(int) $a_source_ref_id))
262  {
263  if($this->getMode() != self::MODE_CONSULTATION &&
264  $this->getMode() != self::MODE_PORTFOLIO_CONSULTATION)
265  {
266  $this->wakeup($cats);
267  return;
268  }
269  }
270  }
271 
272 
273  switch($this->getMode())
274  {
275  case self::MODE_REMOTE_ACCESS:
276  include_once('./Services/Calendar/classes/class.ilCalendarUserSettings.php');
277  if(ilCalendarUserSettings::_getInstance()->getCalendarSelectionType() == ilCalendarUserSettings::CAL_SELECTION_MEMBERSHIP)
278  {
279  $this->readPDCalendars();
280  }
281  else
282  {
283  $this->readSelectedItemCalendars();
284  }
285  break;
286 
287  case self::MODE_REMOTE_SELECTED:
288  $this->readSelectedCalendar($a_source_ref_id);
289  break;
290 
291  case self::MODE_PERSONAL_DESKTOP_MEMBERSHIP:
292  $this->readPDCalendars();
293  break;
294 
295  case self::MODE_PERSONAL_DESKTOP_ITEMS:
296  $this->readSelectedItemCalendars();
297  break;
298 
299  case self::MODE_REPOSITORY:
300  $this->root_ref_id = $a_source_ref_id;
301  $this->root_obj_id = ilObject::_lookupObjId($this->root_ref_id);
302  $this->readReposCalendars();
303  break;
304 
305  case self::MODE_MANAGE:
306  $this->readPDCalendars();
307  $this->readSelectedItemCalendars();
308  break;
309 
310  case self::MODE_CONSULTATION:
311  #$this->readPrivateCalendars();
312  $this->setTargetRefId($a_source_ref_id);
313  $this->readConsultationHoursCalendar($a_source_ref_id);
314  break;
315 
316  case self::MODE_PORTFOLIO_CONSULTATION:
317  $this->readConsultationHoursCalendar();
318  break;
319  }
320 
321  if($a_use_cache)
322  {
323  // Store in cache
324  ilCalendarCache::getInstance()->storeEntry(
325  $this->user_id.':'.$a_mode.':categories:'.(int) $a_source_ref_id,
326  $this->sleep(),
327  $this->user_id,
328  $a_mode,
329  'categories'
330  );
331  }
332  }
333 
341  public function getCategoryInfo($a_cat_id)
342  {
343  if(isset($this->categories_info[$a_cat_id]))
344  {
345  return $this->categories_info[$a_cat_id];
346  }
347 
348  if(in_array($a_cat_id,(array) $this->subitem_categories))
349  {
350  foreach($this->categories as $cat_id)
351  {
352  if(in_array($a_cat_id,$this->categories_info[$cat_id]['subitem_ids']))
353  {
354  return $this->categories_info[$cat_id];
355  }
356  }
357  }
358  }
359 
360 
368  public function getCategoriesInfo()
369  {
370  return $this->categories_info ? $this->categories_info : array();
371  }
372 
379  public function getCategories($a_include_subitem_calendars = false)
380  {
381  if($a_include_subitem_calendars)
382  {
383  return array_merge((array) $this->categories, (array) $this->subitem_categories);
384  }
385 
386  return $this->categories ? $this->categories : array();
387  }
388 
395  public function getSubitemCategories($a_cat_id)
396  {
397  if(!isset($this->categories_info[$a_cat_id]['subitem_ids']))
398  {
399  return array($a_cat_id);
400  }
401  return array_merge((array) $this->categories_info[$a_cat_id]['subitem_ids'],array($a_cat_id));
402  }
403 
404 
412  public function prepareCategoriesOfUserForSelection()
413  {
414  global $lng;
415 
416  $has_personal_calendar = false;
417  foreach($this->categories_info as $info)
418  {
419  if($info['obj_type'] == 'sess')
420  {
421  continue;
422  }
423  if($info['type'] == ilCalendarCategory::TYPE_USR and $info['editable'])
424  {
425  $has_personal_calendar = true;
426  }
427 
428  if($info['editable'])
429  {
430  $cats[$info['cat_id']] = $info['title'];
431  }
432  }
433  // If there
434  if(!$has_personal_calendar)
435  {
436  $cats[0] = $lng->txt('cal_default_calendar');
437  }
438  return $cats ? $cats : array();
439  }
440 
446  public function getNotificationCalendars()
447  {
448  $not = array();
449  foreach($this->categories_info as $info)
450  {
451  if($info['type'] == ilCalendarCategory::TYPE_OBJ and $info['editable'] == true)
452  {
453  if(ilObject::_lookupType($info['obj_id']) == 'crs' or ilObject::_lookupType($info['obj_id']) == 'grp')
454  {
455  $not[] = $info['cat_id'];
456  }
457  }
458  }
459  return $not;
460  }
461 
469  public function isEditable($a_cat_id)
470  {
471  return isset($this->categories_info[$a_cat_id]['editable']) and $this->categories_info[$a_cat_id]['editable'];
472  }
473 
481  public function isVisible($a_cat_id)
482  {
483  return in_array($a_cat_id,$this->categories) or
484  in_array($a_cat_id,(array) $this->subitem_categories);
485  }
486 
487 
488 
489 
497  protected function readPDCalendars()
498  {
499  global $rbacsystem;
500 
501 
502  $this->readPublicCalendars();
503  $this->readPrivateCalendars();
504  $this->readConsultationHoursCalendar();
505  $this->readBookingCalendar();
506 
507  include_once('./Services/Membership/classes/class.ilParticipants.php');
508  $this->readSelectedCategories(ilParticipants::_getMembershipByType($this->user_id,'crs'));
509  $this->readSelectedCategories(ilParticipants::_getMembershipByType($this->user_id,'grp'));
510 
511  $this->addSubitemCalendars();
512  }
513 
518  protected function readSelectedCalendar($a_cal_id)
519  {
520  include_once './Services/Calendar/classes/class.ilCalendarCategory.php';
521  $cat = new ilCalendarCategory($a_cal_id);
522  if($cat->getType() == ilCalendarCategory::TYPE_OBJ)
523  {
524  $this->readSelectedCategories(array($cat->getObjId()));
525  $this->addSubitemCalendars();
526  }
527  else
528  {
529  $this->categories[] = $a_cal_id;
530  }
531  }
532 
539  protected function readSelectedItemCalendars()
540  {
541  global $ilUser,$ilAccess;
542 
543  $this->readPublicCalendars();
544  $this->readPrivateCalendars();
545  $this->readConsultationHoursCalendar();
546  $this->readBookingCalendar();
547 
548  $obj_ids = array();
549 
550  $courses = array();
551  $groups = array();
552  $sessions = array();
553  foreach(ilObjUser::_lookupDesktopItems($ilUser->getId(),array('crs','grp','sess')) as $item)
554  {
555  if($ilAccess->checkAccess('read','',$item['ref_id']))
556  {
557  switch($item['type'])
558  {
559  case 'crs':
560  $courses[] = $item['obj_id'];
561  break;
562 
563  case 'sess':
564  $sessions[] = $item['obj_id'];
565  break;
566 
567  case 'grp':
568  $groups[] = $item['obj_id'];
569  break;
570 
571  }
572  }
573  }
574  $this->readSelectedCategories($courses);
575  $this->readSelectedCategories($sessions);
576  $this->readSelectedCategories($groups);
577 
578  $this->addSubitemCalendars();
579 
580  }
581 
589  protected function readReposCalendars()
590  {
591  global $ilAccess,$tree;
592  global $ilDB;
593 
594  $this->readPublicCalendars();
595  $this->readPrivateCalendars();
596  $this->readConsultationHoursCalendar();
597 
598  #$query = "SELECT ref_id,obd.obj_id obj_id FROM tree t1 ".
599  # "JOIN object_reference obr ON t1.child = obr.ref_id ".
600  # "JOIN object_data obd ON obd.obj_id = obr.obj_id ".
601  # "WHERE t1.lft >= (SELECT lft FROM tree WHERE child = ".$this->db->quote($this->root_ref_id,'integer')." ) ".
602  # "AND t1.lft <= (SELECT rgt FROM tree WHERE child = ".$this->db->quote($this->root_ref_id,'integer')." ) ".
603  # "AND ".$ilDB->in('type',array('crs','grp','sess'),false,'text')." ".
604  # "AND tree = 1";
605 
606  $subtree_query = $GLOBALS['tree']->getSubTreeQuery(
607  $this->root_ref_id,
608  array('object_reference.ref_id','object_data.obj_id'),
609  array('crs','grp','sess')
610  );
611 
612  $res = $ilDB->query($subtree_query);
613  $obj_ids = array();
614  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
615  {
616  if($tree->isDeleted($row->ref_id))
617  {
618  continue;
619  }
620 
621  $obj_type = ilObject::_lookupType($row->obj_id);
622  if($obj_type == 'crs' or $obj_type == 'grp')
623  {
624  // Check for global/local activation
625  if(!ilCalendarSettings::_getInstance()->lookupCalendarActivated($row->obj_id))
626  {
627  continue;
628  }
629  }
630  if($ilAccess->checkAccess('read','',$row->ref_id))
631  {
632  $obj_ids[] = $row->obj_id;
633  }
634  }
635  $this->readSelectedCategories($obj_ids);
636  }
637 
644  protected function readPublicCalendars()
645  {
646  global $rbacsystem,$ilAccess;
647 
648  // global categories
649  $query = "SELECT * FROM cal_categories ".
650  "WHERE type = ".$this->db->quote(ilCalendarCategory::TYPE_GLOBAL ,'integer')." ".
651  "ORDER BY title ";
652 
653  $res = $this->db->query($query);
654  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
655  {
656  $this->categories[] = $row->cat_id;
657  $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
658  $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
659  $this->categories_info[$row->cat_id]['title'] = $row->title;
660  $this->categories_info[$row->cat_id]['color'] = $row->color;
661  $this->categories_info[$row->cat_id]['type'] = $row->type;
662  $this->categories_info[$row->cat_id]['editable'] = $rbacsystem->checkAccess('edit_event',ilCalendarSettings::_getInstance()->getCalendarSettingsId());
663  $this->categories_info[$row->cat_id]['accepted'] = false;
664  $this->categories_info[$row->cat_id]['remote'] = ($row->loc_type == ilCalendarCategory::LTYPE_REMOTE);
665  }
666 
667  return true;
668  }
669 
676  protected function readPrivateCalendars()
677  {
678  global $ilUser;
679  global $ilDB;
680 
681  // First read private calendars of user
682  $query = "SELECT cat_id FROM cal_categories ".
683  "WHERE type = ".$this->db->quote(ilCalendarCategory::TYPE_USR ,'integer')." ".
684  "AND obj_id = ".$this->db->quote($ilUser->getId(),'integer')." ";
685  $res = $this->db->query($query);
686  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
687  {
688  $cat_ids[] = $row->cat_id;
689  }
690 
691  // Read shared calendars
692  include_once('./Services/Calendar/classes/class.ilCalendarSharedStatus.php');
693  $accepted_ids = ilCalendarSharedStatus::getAcceptedCalendars($ilUser->getId());
694  if(!$cat_ids = array_merge((array) $cat_ids, $accepted_ids))
695  {
696  return true;
697  }
698 
699 
700  // user categories
701  $query = "SELECT * FROM cal_categories ".
702  "WHERE type = ".$this->db->quote(ilCalendarCategory::TYPE_USR ,'integer')." ".
703  "AND ".$ilDB->in('cat_id',$cat_ids,false,'integer')." ".
704  "ORDER BY title ";
705 
706  $res = $this->db->query($query);
707  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
708  {
709  $this->categories[] = $row->cat_id;
710  $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
711  $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
712  $this->categories_info[$row->cat_id]['title'] = $row->title;
713  $this->categories_info[$row->cat_id]['color'] = $row->color;
714  $this->categories_info[$row->cat_id]['type'] = $row->type;
715 
716  include_once './Services/Calendar/classes/class.ilCalendarShared.php';
717  if(in_array($row->cat_id, $accepted_ids))
718  {
719  $shared = new ilCalendarShared($row->cat_id);
720  if($shared->isEditableForUser($ilUser->getId()))
721  {
722  $this->categories_info[$row->cat_id]['editable'] = true;
723  }
724  else
725  {
726  $this->categories_info[$row->cat_id]['editable'] = false;
727  }
728  }
729  else
730  {
731  $this->categories_info[$row->cat_id]['editable'] = true;
732  }
733 
734  $this->categories_info[$row->cat_id]['accepted'] = in_array($row->cat_id, $accepted_ids);
735  $this->categories_info[$row->cat_id]['remote'] = ($row->loc_type == ilCalendarCategory::LTYPE_REMOTE);
736  }
737  }
738 
744  public function readConsultationHoursCalendar($a_target_ref_id = NULL)
745  {
746  global $ilDB;
747 
748  if(!$this->getCHUserId())
749  {
750  $this->setCHUserId($this->user_id);
751  }
752 
753  if($a_target_ref_id)
754  {
755  $target_obj_id = ilObject::_lookupObjId($a_target_ref_id);
756 
757  $query = 'SELECT DISTINCT(cc.cat_id) FROM booking_entry be '.
758  'LEFT JOIN booking_obj_assignment bo ON be.booking_id = bo.booking_id '.
759  'JOIN cal_entries ce ON be.booking_id = ce.context_id '.
760  'JOIN cal_cat_assignments ca ON ce.cal_id = ca.cal_id '.
761  'JOIN cal_categories cc ON ca.cat_id = cc.cat_id '.
762  'WHERE ((bo.target_obj_id IS NULL) OR bo.target_obj_id = '.$ilDB->quote($target_obj_id,'integer').' ) '.
763  'AND cc.obj_id = '.$ilDB->quote($this->getCHUserId(),'integer');
764 
765 
766  $res = $ilDB->query($query);
767  $categories = array();
768  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
769  {
770  $categories[] = $row->cat_id;
771  }
772 
773  if($categories)
774  {
775  $query = 'SELECT * FROM cal_categories '.
776  'WHERE '.$ilDB->in('cat_id',$categories,false,'integer');
777  $res = $ilDB->query($query);
778  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
779  {
780  $this->categories[] = $row->cat_id;
781  $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
782  $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
783  $this->categories_info[$row->cat_id]['title'] = $row->title;
784  $this->categories_info[$row->cat_id]['color'] = $row->color;
785  $this->categories_info[$row->cat_id]['type'] = $row->type;
786  $this->categories_info[$row->cat_id]['editable'] = false;
787  $this->categories_info[$row->cat_id]['accepted'] = false;
788  $this->categories_info[$row->cat_id]['remote'] = false;
789  }
790  }
791  }
792  else // no category given
793  {
794  $query = "SELECT * FROM cal_categories cc ".
795  "WHERE type = ".$ilDB->quote(ilCalendarCategory::TYPE_CH,'integer').' '.
796  "AND obj_id = ".$ilDB->quote($this->getCHUserId(),'integer');
797  $res = $ilDB->query($query);
798  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
799  {
800  $this->categories[] = $row->cat_id;
801  $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
802  $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
803  $this->categories_info[$row->cat_id]['title'] = $row->title;
804  $this->categories_info[$row->cat_id]['color'] = $row->color;
805  $this->categories_info[$row->cat_id]['type'] = $row->type;
806  $this->categories_info[$row->cat_id]['editable'] = false;
807  $this->categories_info[$row->cat_id]['accepted'] = false;
808  $this->categories_info[$row->cat_id]['remote'] = false;
809  }
810  }
811  return true;
812  }
813 
819  public function readBookingCalendar($user_id = NULL)
820  {
821  global $ilDB;
822 
823  if(!$user_id)
824  {
825  $user_id = $this->user_id;
826  }
827 
828  $query = "SELECT * FROM cal_categories ".
829  "WHERE type = ".$ilDB->quote(ilCalendarCategory::TYPE_BOOK,'integer').' '.
830  "AND obj_id = ".$ilDB->quote($user_id,'integer');
831  $res = $ilDB->query($query);
832  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
833  {
834  $this->categories[] = $row->cat_id;
835  $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
836  $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
837  $this->categories_info[$row->cat_id]['title'] = $row->title;
838  $this->categories_info[$row->cat_id]['color'] = $row->color;
839  $this->categories_info[$row->cat_id]['type'] = $row->type;
840  $this->categories_info[$row->cat_id]['editable'] = false;
841  $this->categories_info[$row->cat_id]['accepted'] = false;
842  $this->categories_info[$row->cat_id]['remote'] = false;
843  }
844  }
845 
852  protected function readSelectedCategories($a_obj_ids)
853  {
854  global $ilAccess,$tree;
855  global $ilDB;
856 
857  if(!count($a_obj_ids))
858  {
859  return true;
860  }
861 
862  $query = "SELECT * FROM cal_categories ".
863  "WHERE type = ".$this->db->quote(ilCalendarCategory::TYPE_OBJ ,'integer')." ".
864  "AND ".$ilDB->in('obj_id',$a_obj_ids,false,'integer')." ".
865  "ORDER BY title ";
866 
867  $res = $this->db->query($query);
868  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
869  {
870  // check activation/deactivation
871  $obj_type = ilObject::_lookupType($row->obj_id);
872  if($obj_type == 'crs' or $obj_type == 'grp')
873  {
874  if(!ilCalendarSettings::_getInstance()->lookupCalendarActivated($row->obj_id))
875  {
876  continue;
877  }
878  }
879 
880  $editable = false;
881  $exists = false;
882  foreach(ilObject::_getAllReferences($row->obj_id) as $ref_id)
883  {
884  if($ilAccess->checkAccess('edit_event','',$ref_id))
885  {
886  $exists = true;
887  $editable = true;
888  break;
889  }
890  elseif($ilAccess->checkAccess('read','',$ref_id))
891  {
892  $exists = true;
893  }
894  }
895  if(!$exists)
896  {
897  continue;
898  }
899  $this->categories_info[$row->cat_id]['editable'] = $editable;
900 
901  $this->categories[] = $row->cat_id;
902  $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
903  $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
904  $this->categories_info[$row->cat_id]['color'] = $row->color;
905  #$this->categories_info[$row->cat_id]['title'] = ilObject::_lookupTitle($row->obj_id);
906  $this->categories_info[$row->cat_id]['title'] = $row->title;
907  $this->categories_info[$row->cat_id]['obj_type'] = ilObject::_lookupType($row->obj_id);
908  $this->categories_info[$row->cat_id]['type'] = $row->type;
909  $this->categories_info[$row->cat_id]['remote'] = false;
910 
911  }
912  }
913 
920  protected function addSubitemCalendars()
921  {
922  global $ilDB;
923 
924  $course_ids = array();
925  foreach($this->categories as $cat_id)
926  {
927  if($this->categories_info[$cat_id]['obj_type'] == 'crs' or $this->categories_info[$cat_id]['obj_type'] == 'grp')
928  {
929  $course_ids[] = $this->categories_info[$cat_id]['obj_id'];
930  }
931  }
932 
933  $query = "SELECT od2.obj_id sess_id, od1.obj_id crs_id,cat_id FROM object_data od1 ".
934  "JOIN object_reference or1 ON od1.obj_id = or1.obj_id ".
935  "JOIN tree t ON or1.ref_id = t.parent ".
936  "JOIN object_reference or2 ON t.child = or2.ref_id ".
937  "JOIN object_data od2 ON or2.obj_id = od2.obj_id ".
938  "JOIN cal_categories cc ON od2.obj_id = cc.obj_id ".
939  "WHERE od2.type = 'sess' ".
940  "AND (od1.type = 'crs' OR od1.type = 'grp') ".
941  "AND ".$ilDB->in('od1.obj_id',$course_ids,false,'integer').' '.
942  "AND or2.deleted IS NULL";
943 
944  $res = $ilDB->query($query);
945  $cat_ids = array();
946  $course_sessions = array();
947  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
948  {
949  $cat_ids[] = $row->cat_id;
950  $course_sessions[$row->crs_id][$row->sess_id] = $row->cat_id;
951  $this->subitem_categories[] = $row->cat_id;
952  }
953 
954  foreach($this->categories as $cat_id)
955  {
956  if(
957  ($this->categories_info[$cat_id]['obj_type'] == 'crs' ||
958  $this->categories_info[$cat_id]['obj_type'] == 'grp' ) &&
959  isset($this->categories_info[$cat_id]['obj_id']) &&
960  isset($course_sessions[$this->categories_info[$cat_id]['obj_id']]) &&
961  is_array($course_sessions[$this->categories_info[$cat_id]['obj_id']]))
962  {
963  foreach($course_sessions[$this->categories_info[$cat_id]['obj_id']] as $sess_id => $sess_cat_id)
964  {
965  $this->categories_info[$cat_id]['subitem_ids'][$sess_id] = $sess_cat_id;
966  $this->categories_info[$cat_id]['subitem_obj_ids'][$sess_cat_id] = $sess_id;
967  }
968  }
969  else
970  {
971  $this->categories_info[$cat_id]['subitem_ids'] = array();
972  $this->categories_info[$cat_id]['subitem_obj_ids'] = array();
973  }
974  }
975  }
976 
983  static function lookupPrivateCategories($a_user_id)
984  {
985  global $ilDB;
986 
987  // First read private calendars of user
988  $set = $ilDB->query("SELECT * FROM cal_categories ".
989  "WHERE type = ".$ilDB->quote(ilCalendarCategory::TYPE_USR ,'integer')." ".
990  "AND obj_id = ".$ilDB->quote($a_user_id,'integer'));
991  $cats = array();
992  while ($rec = $ilDB->fetchAssoc($set))
993  {
994  $cats[] = $rec;
995  }
996  return $cats;
997  }
998 
999 }
1000 ?>
ilCalendarCategories
class for calendar categories
Definition: class.ilCalendarCategories.php:37
ilCalendarCache\getInstance
static getInstance()
get singleton instance
Definition: class.ilCalendarCache.php:32
ilCalendarCategories\readSelectedItemCalendars
readSelectedItemCalendars()
Read categories of selected items.
Definition: class.ilCalendarCategories.php:539
ilCalendarCategories\addSubitemCalendars
addSubitemCalendars()
Add subitem calendars E.g.
Definition: class.ilCalendarCategories.php:920
ilCalendarSettings\_getInstance
static _getInstance()
get singleton instance
Definition: class.ilCalendarSettings.php:110
ilCalendarCategories\_isOwner
static _isOwner($a_usr_id, $a_cal_id)
check if user is owner of a category
Definition: class.ilCalendarCategories.php:137
ilCalendarCategories\wakeup
wakeup($a_ser)
Load from serialize string.
Definition: class.ilCalendarCategories.php:199
ilParticipants\_getMembershipByType
static _getMembershipByType($a_usr_id, $a_type, $a_only_member_role=false)
get membership by type Get course or group membership
Definition: class.ilParticipants.php:137
ilCalendarCategories\setCHUserId
setCHUserId($a_user_id)
Set ch user id.
Definition: class.ilCalendarCategories.php:212
ilCalendarCategories\_lookupCategoryIdByObjId
static _lookupCategoryIdByObjId($a_obj_id)
lookup category by obj_id
Definition: class.ilCalendarCategories.php:111
ilCalendarCategories\sleep
sleep()
Serialize categories.
Definition: class.ilCalendarCategories.php:183
ilCalendarCategories\isVisible
isVisible($a_cat_id)
check if category is visible
Definition: class.ilCalendarCategories.php:481
ilCalendarCategory
Stores calendar categories.
Definition: class.ilCalendarCategory.php:33
ilCalendarCategories\deletePDItemsCache
static deletePDItemsCache($a_usr_id)
Delete cache (add remove desktop item)
Definition: class.ilCalendarCategories.php:154
ilCalendarCategories\readConsultationHoursCalendar
readConsultationHoursCalendar($a_target_ref_id=NULL)
Read personal consultation hours calendar.
Definition: class.ilCalendarCategories.php:744
ilCalendarCategories\initialize
initialize($a_mode, $a_source_ref_id=0, $a_use_cache=false)
initialize visible categories
Definition: class.ilCalendarCategories.php:255
ilCalendarShared
Handles shared calendars.
Definition: class.ilCalendarShared.php:33
ilCalendarSharedStatus\getAcceptedCalendars
getAcceptedCalendars($a_usr_id)
get accepted shared calendars
Definition: class.ilCalendarSharedStatus.php:94
ilObject\_getAllReferences
static _getAllReferences($a_id)
get all reference ids of object
Definition: class.ilObject.php:909
DB_FETCHMODE_OBJECT
const DB_FETCHMODE_OBJECT
Definition: class.ilDB.php:11
ilCalendarCategories\isEditable
isEditable($a_cat_id)
check if category is editable
Definition: class.ilCalendarCategories.php:469
ilCalendarCategories\deleteRepositoryCache
static deleteRepositoryCache($a_usr_id)
Delete cache.
Definition: class.ilCalendarCategories.php:168
ilCalendarCategories\readPublicCalendars
readPublicCalendars()
Read public calendars.
Definition: class.ilCalendarCategories.php:644
$GLOBALS
$GLOBALS['ct_recipient']
Definition: example_form.ajax.php:4
ilCalendarUserSettings\_getInstance
static _getInstance()
get instance for logged in user
Definition: class.ilCalendarUserSettings.php:80
ilObject\_lookupObjId
static _lookupObjId($a_id)
Definition: class.ilObject.php:1028
ilCalendarCategories\getSubitemCategories
getSubitemCategories($a_cat_id)
get subitem categories for a specific category
Definition: class.ilCalendarCategories.php:395
ilCalendarCategories\readSelectedCategories
readSelectedCategories($a_obj_ids)
read selected categories
Definition: class.ilCalendarCategories.php:852
ilCalendarCategories\readSelectedCalendar
readSelectedCalendar($a_cal_id)
Read info about selected calendar.
Definition: class.ilCalendarCategories.php:518
ilCalendarCategories\readBookingCalendar
readBookingCalendar($user_id=NULL)
Read booking manager calendar.
Definition: class.ilCalendarCategories.php:819
ilCalendarCategories\prepareCategoriesOfUserForSelection
prepareCategoriesOfUserForSelection()
prepare categories of users for selection
Definition: class.ilCalendarCategories.php:412
ilCalendarCategories\_getInstance
static _getInstance($a_usr_id=0)
get singleton instance
Definition: class.ilCalendarCategories.php:94
ilObject\_lookupType
static _lookupType($a_id, $a_reference=false)
lookup object type
Definition: class.ilObject.php:1183
ilCalendarCategories\readReposCalendars
readReposCalendars()
Read available repository calendars.
Definition: class.ilCalendarCategories.php:589
ilObjUser\_lookupDesktopItems
static _lookupDesktopItems($user_id, $a_types="")
get all desktop items of user and specified type
Definition: class.ilObjUser.php:3283
$ilUser
global $ilUser
Definition: imgupload.php:15
ilCalendarCategories\getCategories
getCategories($a_include_subitem_calendars=false)
get categories
Definition: class.ilCalendarCategories.php:379
ilCalendarCategories\__construct
__construct($a_usr_id=0)
Singleton instance.
Definition: class.ilCalendarCategories.php:74
$ref_id
$ref_id
Definition: sahs_server.php:39
$lng
global $lng
Definition: privfeed.php:40
ilCalendarCategories\getNotificationCalendars
getNotificationCalendars()
Get all calendars that allow send of notifications (Editable and course group calendars) ...
Definition: class.ilCalendarCategories.php:446
ilCalendarCategories\readPrivateCalendars
readPrivateCalendars()
Read private calendars.
Definition: class.ilCalendarCategories.php:676
ilCalendarCategories\lookupPrivateCategories
static lookupPrivateCategories($a_user_id)
Lookup private categories of user.
Definition: class.ilCalendarCategories.php:983
ilCalendarCategories\readPDCalendars
readPDCalendars()
Read categories of user.
Definition: class.ilCalendarCategories.php:497