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
127
128
129
130
131
132
133
134
|
<?php
namespace Studip\Forms;
class NewsRangesInput extends Input
{
public function render()
{
$context = $this->getContextObject();
$sql = "SELECT CONCAT(`Seminar_id`, '__seminar') AS `range_id`, `name` FROM `seminare` WHERE `name` LIKE :input ";
if ($GLOBALS['perm']->have_perm('admin')) {
$sql .= "UNION SELECT CONCAT(`Institut_id`, '__institute') AS `range_id`, `Name` AS `name` FROM Institute WHERE `name` LIKE :input ";
if (!$GLOBALS['perm']->have_perm('root')) {
$sql .= "AND ";
}
}
if ($GLOBALS['perm']->have_perm('root')) {
$sql .= "UNION SELECT * FROM (SELECT CAST('studip__home' AS BINARY) AS `range_id`, '"._('Stud.IP-Startseite')."' AS `name`) as tmp_global_table WHERE `name` LIKE :input ";
$sql .= "UNION SELECT CONCAT(`user_id`, '__person') AS `range_id`, CONCAT(`Vorname`, ' ', `Nachname`) AS `name` FROM `auth_user_md5` WHERE CONCAT(`Vorname`, ' ', `Nachname`) LIKE :input ";
} else {
$sql .= "UNION SELECT * FROM (SELECT CAST('".\User::findCurrent()->id."__person' AS BINARY) AS `range_id`, '".\addslashes(\User::findCurrent()->getFullName()." - "._('Profilseite'))."' AS `name`) as tmp_user_table WHERE `name` LIKE :input ";
}
$searchtype = new \SQLSearch($sql, _('Bereich suchen'));
$items = [];
$icons = [
'global' => 'home',
'sem' => 'seminar',
'inst' => 'institute',
'user' => 'person'
];
foreach ($context->{$this->name} as $newsrange) {
$items[] = [
'value' => $newsrange->range_id,
'name' => (string) $newsrange->name,
'icon' => $icons[$newsrange->type],
'deletable' => \StudipNews::haveRangePermission('edit', $newsrange->range_id)
];
}
$selectable = [];
$studip_options = [];
if ($GLOBALS['perm']->have_perm('root')) {
$studip_options[] = [
'value' => 'studip__home',
'name' => _('Stud.IP-Startseite'),
];
}
$studip_options[] = [
'value' => \User::findCurrent()->id . '__person',
'name' => _('Meine Profilseite')
];
$selectable[] = [
'label' => _('Stud.IP'),
'options' => $studip_options
];
if ($GLOBALS['perm']->have_perm('admin')) {
$inst_options = [];
foreach (\Institute::getMyInstitutes() as $institut) {
$inst_options[] = [
'value' => $institut['Institut_id'] . '__institute',
'name' => (string) $institut['Name'],
];
}
if (count($inst_options)) {
$selectable[] = [
'label' => _('Einrichtungen'),
'options' => $inst_options
];
}
} else {
$course_options = [];
foreach (\Course::findByUser(\User::findCurrent()->id) as $course) {
$course_options[] = [
'value' => $course->getId()."__seminar",
'name' => (string) $course['name']
];
}
if (count($course_options)) {
$selectable[] = [
'label' => _('Veranstaltungen'),
'options' => $course_options
];
}
}
$template = $GLOBALS['template_factory']->open('forms/news_ranges_input');
$template->name = $this->name;
$template->items = $items;
$template->searchtype = $searchtype;
$template->selectable = $selectable;
$template->category_order = ['home', 'institute', 'seminar', 'person'];
return $template->render();
}
public function getRequestValue()
{
$new_ranges = \Request::getArray($this->name);
$context = $this->getContextObject();
if ($context) {
$options = $context->getRelationOptions($this->name);
$old_ranges = array_map(function ($r) {
return $r['range_id'];
}, $context[$this->name]->getArrayCopy());
foreach ($new_ranges as $index => $range_id) {
if (!in_array($range_id, $old_ranges)) {
if (!\StudipNews::haveRangePermission('edit', $range_id)) {
unset($new_ranges[$index]);
}
}
}
foreach ($old_ranges as $index => $range_id) {
if (!in_array($range_id, $new_ranges)) {
if (!\StudipNews::haveRangePermission('edit', $range_id)) {
$new_ranges[] = $range_id;
}
}
}
$class = $options['class_name'];
return array_map(function ($id) use ($class, $context) {
$range = new $class();
$range['range_id'] = $id;
if (!$context->id) {
$context->setId($context->getNewId());
}
$range['news_id'] = $context->id;
return $range;
}, $new_ranges);
}
return [];
}
}
|
