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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
<?php
/**
* GlobalSearchModule for room bookings
*
* @author Thomas Hackl <thomas.hackl@uni-passau.de>
* @license http://www.gnu.org/licenses/gpl-2.0.html GPL version 2
* @category Stud.IP
* @since 4.1
*/
class GlobalSearchRoomBookings extends GlobalSearchModule
{
/**
* Returns the displayname for this module
*
* @return string
*/
public static function getName()
{
return _('Raumbuchungen');
}
/**
* Returns the URL that can be called for a full search.
*
* @param string $searchterm what to search for?
* @return string URL to the full search, containing the searchterm and the category
*/
public static function getSearchURL($searchterm)
{
return URLHelper::getURL('dispatch.php/search/globalsearch', [
'q' => $searchterm,
'category' => self::class
]);
}
/**
* Search freetext resource bookings for the given search term.
*
* @param string $search The term or date to search for. You can either use
* part of the room bookings free text or a date.
* @param array $filter an array with search limiting filter information (e.g. 'category', 'semester', etc.)
* @return null|string
*/
public static function getSQL($search, $filter, $limit)
{
if (!Config::get()->RESOURCES_ENABLE || !$search || !$GLOBALS['perm']->have_perm('root')) {
return null;
}
$query = DBManager::get()->quote('%' . trim($search) . '%');
$sql = "SELECT SQL_CALC_FOUND_ROWS DISTINCT a.`id`, a.`description`, r.`id`, r.`name`, a.`begin`, a.`end`
FROM `resource_bookings` a
JOIN `resources` r
ON a.`resource_id` = r.`id`
WHERE a.`description` != ''
AND a.`description` IS NOT NULL
AND (a.`description` LIKE {$query}";
$datefilter = '';
foreach (explode(' ', $search) as $part) {
if (is_numeric($part)) {
$datefilter .= " AND (FROM_UNIXTIME(a.`begin`, '%Y') = " . DBManager::get()->quote($part) .
" OR FROM_UNIXTIME(a.`end`, '%Y') = " . DBManager::get()->quote($part) . ")";
$search = str_replace([$part . ' ', ' ' . $part], '', $search);
} else if (preg_match('/\d+\.\d+\.\d+/', $part)) {
$datefilter .= " AND (FROM_UNIXTIME(a.`begin`, '%d.%m.%Y') = " . DBManager::get()->quote($part) .
" OR FROM_UNIXTIME(a.`end`, '%d.%m.%Y') = " . DBManager::get()->quote($part) . ")";
$search = str_replace([$part . ' ', ' ' . $part], '', $search);
}
}
$search = DBManager::get()->quote('%' . $search . '%');
$sql .= " OR a.`description` LIKE $search)";
if ($datefilter != '') {
$sql .= $datefilter;
}
$sql .= " ORDER BY `begin` DESC, `description` LIMIT " .
$limit;
return $sql;
}
/**
* Returns an array of information for the found element. Following informations (key: description) are necessary
*
* - name: The name of the object
* - url: The url to send the user to when he clicks the link
*
* Additional informations are:
*
* - additional: Subtitle for the hit
* - expand: Url if the user further expands the search
* - img: Avatar for the
*
* @param array $res
* @param string $search
* @return array
*/
public static function filter($res, $search)
{
$additional = $res['name'] . ', ';
$additional .= date('d.m.Y H:i', $res['begin']) . ' - ';
$additional .= date('d.m.Y H:i', $res['end']);
return [
'name' => self::mark($res['name'], $search),
'url' => URLHelper::getURL(
'dispatch.php/resources/room_planning/booking_plan/' . $res['id'],
[
'defaultDate' => date('Y-m-d', strtotime('last monday', $res['begin'] + 24 * 60 * 60)),
'display_all_requests' => true,
],
true
),
'img' => Icon::create('room-clear')->asImagePath(),
'additional' => self::mark($additional, $search),
'expand' => null
];
}
}
|
