blob: 59bb035aa1f3948d68d336a1462416a93870b6fb (
plain)
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
|
<?php
/**
* StgteilVersionCondition.php
*
* All conditions concerning the Studiengangteil-Versionen in Stud.IP can be specified here.
*
* 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 Timo Hartge <hartge@data-quest.de>
* @license http://www.gnu.org/licenses/gpl-2.0.html GPL version 2
* @category Stud.IP
*/
namespace UserFilterFields;
class StgteilVersionCondition extends \UserFilterField
{
// --- ATTRIBUTES ---
public $valuesDbTable = 'mvv_stgteilversion';
public $valuesDbIdField = 'version_id';
public $valuesDbNameField = 'code';
public $userDataDbTable = 'user_studiengang';
public $userDataDbField = 'version_id';
public static $sortOrder = 5;
public static $isParameterized = true;
public static function getParameterizedTypes()
{
if (\Config::get()->DISPLAY_STGTEILVERSION_USERFILTER) {
$filter = new StgteilVersionCondition();
$fields['StgteilVersionCondition'] = $filter->getName();
return $fields;
} else {
return [];
}
}
/**
* @see UserFilterField::__construct
*/
public function __construct($fieldId = '')
{
$this->validCompareOperators = [
'=' => _('ist'),
'!=' => _('ist nicht')
];
if ($this->valuesDbNameField) {
// Get all available values from database.
$stmt = \DBManager::get()->query(
"SELECT DISTINCT `version_id`, `fach`.`name` ".
"FROM `mvv_stgteilversion` LEFT JOIN mvv_stgteil USING (stgteil_id)".
"LEFT JOIN fach USING (fach_id)".
"WHERE `mvv_stgteilversion`.`stat` = 'genehmigt' ORDER BY `fach`.`name` ASC");
while ($current = $stmt->fetch(\PDO::FETCH_ASSOC)) {
$this->validValues[$current[$this->valuesDbIdField]] = $current[$this->valuesDbNameField];
}
}
if ($fieldId) {
$this->id = $fieldId;
$this->load();
} else {
$this->id = $this->generateId();
}
foreach ($this->validValues as $version_id => $name) {
$stgteilversion = \StgteilVersion::find($version_id);
$this->validValues[$version_id] = $stgteilversion->getDisplayName();
}
}
/**
* Get this field's display name.
*
* @return String
*/
public function getName()
{
return _('Studiengangteil-Version');
}
}
|
