1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
|
<?php
/**
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License as
* published by the Free Software Foundation; either version 2 of
* the License, or (at your option) any later version.
*
* @author Peter Thienel <thienel@data-quest.de>
* @copyright 2014 Stud.IP Core-Group
* @license http://www.gnu.org/licenses/gpl-2.0.html GPL version 2
* @category Stud.IP
*
*/
class CourseCancelledEvent extends CourseEvent
{
protected static function configure($config = [])
{
$config['alias_fields']['ex_description'] = 'content';
if (!self::TableScheme('ex_termine')) {
throw new Exception('Cannot obtain table meta data for table "ex_termine"');
}
$config['db_fields'] = self::$schemes['ex_termine']['db_fields'];
$config['pk'] = self::$schemes['ex_termine']['pk'];
parent::configure($config);
self::$config['CourseCancelledEvent']['db_table'] = 'ex_termine';
}
/**
* Returns all CourseCancelledEvents in the given time range for the given range_id.
*
* @param string $user_id Id of Stud.IP object from type user, course, inst
* @param DateTime $start The start date time.
* @param DateTime $end The end date time.
* @return SimpleORMapCollection Collection of found CourseCancelledEvents.
*/
public static function getEventsByInterval($user_id, DateTime $start, dateTime $end)
{
$stmt = DBManager::get()->prepare('SELECT ex_termine.* FROM seminar_user '
. 'INNER JOIN ex_termine ON seminar_id = range_id '
. 'WHERE ex_termine.content <> \'\' AND user_id = :user_id '
. 'AND date BETWEEN :start AND :end '
. "AND (IFNULL(metadate_id, '') = '' "
. 'OR metadate_id NOT IN ( '
. 'SELECT metadate_id FROM schedule_seminare '
. 'WHERE user_id = :user_id AND visible = 0) ) '
. 'ORDER BY date ASC');
$stmt->execute([
':user_id' => $user_id,
':start' => $start->getTimestamp(),
':end' => $end->getTimestamp()
]);
$event_collection = [];
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
$event = new CourseCancelledEvent();
$event->setData($row);
$event->setNew(false);
// related persons (dozenten) or groups
if (self::checkRelated($event, $user_id)) {
$event_collection[] = $event;
}
}
$event_collection = SimpleORMapCollection::createFromArray($event_collection, false);
$event_collection->setClassName('Event');
return $event_collection;
}
/**
* Returns the title of this event.
* The title of a course event is the name of the course or if a topic is
* assigned, the title of this topic. If the user has not the permission
* Event::PERMISSION_READABLE, the title is "Keine Berechtigung.".
*
* @return string
*/
public function getTitle()
{
$title = parent::getTitle();
if ($this->havePermission(Event::PERMISSION_READABLE)) {
$title .= ' ' . _('(fällt aus)');
}
return $title;
}
/**
* Returns the index of the category.
* If the user has no permission, 255 is returned.
*
* TODO remove? use getStudipCategory instead?
*
* @see config/config.inc.php $TERMIN_TYP
* @return int The index of the category
*/
public function getCategory()
{
return 255;
}
public function getDescription()
{
if ($this->havePermission(Event::PERMISSION_READABLE)) {
return $this->ex_description;
}
return '';
}
}
|
