blob: a9b14039e5b9db0cb9af38feccbe4c72cb759dfe (
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
|
<?php
/*
* studip_institute.php - base class for institutes
*
* Copyright (C) 2006 - Marco Diedrich (mdiedric@uos.de)
*
* 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.
*/
require_once 'lib/webservices/api/studip_user.php';
class StudipInstituteHelper
{
public static function get_users_by_status($institute_id, $status)
{
$db = DBManager::get();
$stmt = $db->prepare('SELECT au.username FROM user_inst ui
JOIN auth_user_md5 au USING(user_id)
WHERE ui.inst_perms = ? AND ui.Institut_id = ?');
$stmt->execute([$status, $institute_id]);
return $stmt->fetchAll(PDO::FETCH_COLUMN);
}
public static function get_user_status($username, $institute_id)
{
$db = DBManager::get();
$stmt = $db->prepare('SELECT ui.inst_perms FROM user_inst ui
JOIN auth_user_md5 au USING(user_id)
WHERE au.username = ? AND ui.Institut_id = ?');
$stmt->execute([$username, $institute_id]);
return $stmt->fetchColumn();
}
public static function get_admins($institute_id)
{
return StudipInstituteHelper::get_users_by_status($institute_id, 'admin');
}
public static function get_lecturers($institute_id)
{
return StudipInstituteHelper::get_users_by_status($institute_id, 'dozent');
}
public static function get_authors($institute_id)
{
return StudipInstituteHelper::get_users_by_status($institute_id, 'autor');
}
public static function get_users($institute_id)
{
return StudipInstituteHelper::get_users_by_status($institute_id, 'user');
}
public static function get_higher_level_institute($institute_id)
{
$db = DBManager::get();
$stmt = $db->prepare('SELECT i2.Institut_id FROM Institute i
JOIN Institute i2 ON (i.fakultaets_id = i2.Institut_id)
WHERE i.Institut_id = ? AND i2.fakultaets_id != ?');
$stmt->execute([$institute_id, $institute_id]);
return $stmt->fetchColumn();
}
public static function get_admins_upward_recursive($institute_id)
{
$institute_fak = StudipInstituteHelper::get_higher_level_institute($institute_id);
return array_merge(StudipInstituteHelper::get_admins($institute_fak),
StudipInstituteHelper::get_admins($institute_id));
}
}
|
