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
|
<?php
# Lifter007: TODO
# Lifter003: TEST
# Lifter010: TODO
// +---------------------------------------------------------------------------+
// This file is part of Stud.IP
//
// Copyright (C) 2005 Tobias Thelen , <tthelen@uni-osnabrueck.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 any later version.
// +---------------------------------------------------------------------------+
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
// +---------------------------------------------------------------------------+
/**
* StudipComment.class.php
*
*
*
*
* @author André Noack <noack@data-quest>, Suchi & Berg GmbH <info@data-quest.de>
* @access public
*
* @property string $id alias column for comment_id
* @property string $comment_id database column
* @property string $object_id database column
* @property string $user_id database column
* @property string $content database column
* @property int $mkdate database column
* @property int $chdate database column
* @property StudipNews $news belongs_to StudipNews
*/
class StudipComment extends SimpleORMap implements PrivacyObject
{
protected static function configure($config = [])
{
$config['db_table'] = 'comments';
$config['belongs_to']['news'] = [
'class_name' => StudipNews::class,
'foreign_key' => 'object_id',
];
parent::configure($config);
}
public static function NumCommentsForObject($object_id)
{
return self::countBySql('object_id = ?', [$object_id]);
}
public static function NumCommentsForObjectSinceLastVisit($object_id, $comments_since = 0, $exclude_user_id = null)
{
$query = "object_id = ?";
$query .= " AND chdate > ?";
if ($exclude_user_id) {
$query .= " AND user_id != ?";
}
return self::countBySql($query, [$object_id, $comments_since, $exclude_user_id]);
}
public static function GetCommentsForObject($object_id)
{
global $_fullname_sql;
$query = "SELECT comments.content, {$_fullname_sql['full']} AS fullname,
a.username, comments.mkdate, comments.comment_id
FROM comments
LEFT JOIN auth_user_md5 AS a USING (user_id)
LEFT JOIN user_info USING (user_id)
WHERE object_id = ?
ORDER BY comments.mkdate";
$statement = DBManager::get()->prepare($query);
$statement->execute([$object_id]);
return $statement->fetchAll(PDO::FETCH_BOTH);
}
public static function DeleteCommentsByObject($object_ids)
{
if (!is_array($object_ids)) {
$object_ids = [$object_ids];
}
$where = "object_id IN (?)";
return self::deleteBySQL($where, [$object_ids]);
}
/**
* Export available data of a given user into a storage object
* (an instance of the StoredUserData class) for that user.
*
* @param StoredUserData $storage object to store data into
*/
public static function exportUserData(StoredUserData $storage)
{
$sorm = self::findBySQL("user_id = ?", [$storage->user_id]);
if ($sorm) {
$field_data = [];
foreach ($sorm as $row) {
$field_data[] = $row->toRawArray();
}
if ($field_data) {
$storage->addTabularData(_('Ankündigungen Kommentare'), 'comments', $field_data);
}
}
}
}
|
