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
|
<?php
/**
* @license GPL2 or any later version
*
* @property string $id alias column for thread_id
* @property string $thread_id database column
* @property string $context_type database column
* @property string $context_id database column
* @property string $user_id database column
* @property int $external_contact database column
* @property string|null $content database column
* @property string|null $display_class database column
* @property int $visible_in_stream database column
* @property int $commentable database column
* @property JSONArrayObject|null $metadata database column
* @property int|null $chdate database column
* @property int|null $mkdate database column
* @property SimpleORMapCollection<BlubberComment> $comments has_many BlubberComment
* @property SimpleORMapCollection<BlubberMention> $mentions has_many BlubberMention
* @property SimpleORMapCollection<ObjectUserVisit> $visits has_many ObjectUserVisit
* @property Statusgruppen $statusgruppe belongs_to Statusgruppen
* @property User $user belongs_to User
*/
class BlubberStatusgruppeThread extends BlubberThread
{
protected static function configure($config = [])
{
$config['belongs_to']['statusgruppe'] = [
'class_name' => Statusgruppen::class,
'foreign_key' => function ($thread) {
return $thread['metadata']['statusgruppe_id'];
}
];
parent::configure($config);
}
public static function findByStatusgruppe_id($statusgruppe_id)
{
$condition = "INNER JOIN statusgruppen ON (statusgruppen.range_id = context_id)
WHERE context_type = 'course'
AND statusgruppen.statusgruppe_id = :statusgruppe_id
AND display_class = 'BlubberStatusgruppeThread'
AND metadata LIKE :like";
$threads = self::findBySQL($condition, [
'statusgruppe_id' => $statusgruppe_id,
'like' => "%{$statusgruppe_id}%"
]);
foreach ($threads as $thread) {
if ($thread['metadata']['statusgruppe_id'] === $statusgruppe_id) {
return $thread;
}
}
return null;
}
public function isReadable(string $user_id = null)
{
$user_id = $user_id ?? $GLOBALS['user']->id;
if ($GLOBALS['perm']->have_studip_perm("tutor", $this['context_id'], $user_id)) {
return true;
}
$query = "SELECT 1
FROM statusgruppe_user
WHERE statusgruppe_id = :statusgruppe_id
AND user_id = :user_id";
return (bool) DBManager::get()->fetchColumn($query, [
'statusgruppe_id' => $this['metadata']['statusgruppe_id'],
'user_id' => $user_id
]);
}
public function getName()
{
$name = sprintf(_('%s in %s'), $this->statusgruppe->name, Course::find($this['context_id'])->name);
return $name;
}
public function getContextTemplate()
{
$template = $GLOBALS['template_factory']->open('blubber/coursegroup_context');
$template->members = $this->statusgruppe->members;
$template->course = Course::find($this['context_id']);
$template->thread = $this;
return $template;
}
public function notifyUsersForNewComment($comment)
{
$query = "SELECT statusgruppe_user.user_id
FROM statusgruppe_user
WHERE statusgruppe_id = :statusgruppe_id
AND user_id != :me
UNION DISTINCT
SELECT seminar_user.user_id
FROM seminar_user
INNER JOIN statusgruppen ON (statusgruppen.range_id = seminar_user.Seminar_id)
WHERE statusgruppen.statusgruppe_id = :statusgruppe_id
AND seminar_user.status IN ('dozent', 'tutor')
AND seminar_user.user_id != :me";
$user_ids = DBManager::get()->fetchFirst($query, [
'statusgruppe_id' => $this['metadata']['statusgruppe_id'],
'me' => $GLOBALS['user']->id
]);
PersonalNotifications::add(
$user_ids,
$this->getURL(),
sprintf(_('%s hat eine Nachricht geschrieben.'), get_fullname()),
'blubberthread_' . $this->getId(),
Icon::create('blubber'),
true
);
}
}
|
