ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
class.ilSessionOverviewGUI.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 
33 {
34  protected $course_ref_id = null;
35  protected $course_id = null;
36 
37  protected $lng;
38  protected $tpl;
39  protected $ctrl;
40 
48  public function __construct($a_crs_ref_id, ilParticipants $a_members)
49  {
50  global $tpl, $ilCtrl, $lng;
51 
52  $this->ctrl = $ilCtrl;
53  $this->tpl = $tpl;
54  $this->lng = $lng;
55  $this->lng->loadLanguageModule('event');
56  $this->lng->loadLanguageModule('crs');
57 
58  $this->course_ref_id = $a_crs_ref_id;
59  $this->course_id = ilObject::_lookupObjId($this->course_ref_id);
60  $this->members_obj = $a_members;
61  }
62 
70  public function executeCommand()
71  {
72  $next_class = $this->ctrl->getNextClass($this);
73  $cmd = $this->ctrl->getCmd();
74 
75  switch ($next_class) {
76  default:
77  if (!$cmd) {
78  $cmd = "listSessions";
79  }
80  $this->$cmd();
81  break;
82  }
83  }
91  public function listSessions()
92  {
93  global $ilToolbar,$ilErr;
94 
95  if (!$GLOBALS['DIC']->access()->checkRbacOrPositionPermissionAccess('manage_members', 'manage_members', $this->course_ref_id)) {
96  $ilErr->raiseError($this->lng->txt('msg_no_perm_read'), $ilErr->MESSAGE);
97  }
98 
99  $ilToolbar->addButton(
100  $this->lng->txt('event_csv_export'),
101  $this->ctrl->getLinkTarget($this, 'exportCSV')
102  );
103 
104  include_once 'Modules/Session/classes/class.ilSessionOverviewTableGUI.php';
105 
106  $part = $this->members_obj->getParticipants();
107  $part = $GLOBALS['DIC']->access()->filterUserIdsByRbacOrPositionOfCurrentUser(
108  'manage_members',
109  'manage_members',
110  $this->course_ref_id,
111  $part
112  );
113 
114  $tbl = new ilSessionOverviewTableGUI($this, 'listSessions', $this->course_ref_id, $part);
115  $this->tpl->setContent($tbl->getHTML());
116  }
117 
125  public function exportCSV()
126  {
127  global $tree,$ilAccess;
128 
129  include_once('Services/Utilities/classes/class.ilCSVWriter.php');
130  include_once 'Modules/Session/classes/class.ilEventParticipants.php';
131 
132  $part = $GLOBALS['DIC']->access()->filterUserIdsByRbacOrPositionOfCurrentUser(
133  'manage_members',
134  'manage_members',
135  $this->course_ref_id,
136  $this->members_obj->getParticipants()
137  );
138  $members = ilUtil::_sortIds($part, 'usr_data', 'lastname', 'usr_id');
139 
140  $events = array();
141  foreach ($tree->getSubtree($tree->getNodeData($this->course_ref_id), false, 'sess') as $event_id) {
142  $tmp_event = ilObjectFactory::getInstanceByRefId($event_id, false);
143  if (!is_object($tmp_event) or !$ilAccess->checkAccess('write', '', $event_id)) {
144  continue;
145  }
146  $events[] = $tmp_event;
147  }
148 
149  $this->csv = new ilCSVWriter();
150  $this->csv->addColumn($this->lng->txt("lastname"));
151  $this->csv->addColumn($this->lng->txt("firstname"));
152  $this->csv->addColumn($this->lng->txt("login"));
153 
154  foreach ($events as $event_obj) {
155  // TODO: do not export relative dates
156  $this->csv->addColumn($event_obj->getTitle() . ' (' . $event_obj->getFirstAppointment()->appointmentToString() . ')');
157  }
158 
159  $this->csv->addRow();
160 
161  foreach ($members as $user_id) {
162  $name = ilObjUser::_lookupName($user_id);
163 
164  $this->csv->addColumn($name['lastname']);
165  $this->csv->addColumn($name['firstname']);
166  $this->csv->addColumn(ilObjUser::_lookupLogin($user_id));
167 
168  foreach ($events as $event_obj) {
169  $event_part = new ilEventParticipants((int) $event_obj->getId());
170 
171  $this->csv->addColumn($event_part->hasParticipated($user_id) ?
172  $this->lng->txt('event_participated') :
173  $this->lng->txt('event_not_participated'));
174  }
175 
176  $this->csv->addRow();
177  }
178  $date = new ilDate(time(), IL_CAL_UNIX);
179  ilUtil::deliverData($this->csv->getCSVString(), $date->get(IL_CAL_FKT_DATE, 'Y-m-d') . "_course_events.csv", "text/csv");
180  }
181 }
static _lookupLogin($a_user_id)
lookup login
static _lookupName($a_user_id)
lookup user name
global $ilErr
Definition: raiseError.php:16
static deliverData($a_data, $a_filename, $mime="application/octet-stream", $charset="")
deliver data for download via browser.
Helper class to generate CSV files.
$tbl
Definition: example_048.php:81
$GLOBALS['loaded']
Global hash that tracks already loaded includes.
__construct($a_crs_ref_id, ilParticipants $a_members)
constructor
Table presentation for session overview.
const IL_CAL_UNIX
global $ilCtrl
Definition: ilias.php:18
if($format !==null) $name
Definition: metadata.php:146
Class for single dates.
static _sortIds($a_ids, $a_table, $a_field, $a_id_name)
Function that sorts ids by a given table field using WHERE IN E.g: __sort(array(6,7),&#39;usr_data&#39;,&#39;lastname&#39;,&#39;usr_id&#39;) => sorts by lastname.
static _lookupObjId($a_id)
const IL_CAL_FKT_DATE
exportCSV()
Events List CSV Export.
Create styles array
The data for the language used.
listSessions()
list sessions of all user
static getInstanceByRefId($a_ref_id, $stop_on_error=true)
get an instance of an Ilias object by reference id
Add data(end) time
Method that wraps PHPs time in order to allow simulations with the workflow.