public function getByParent($parent, $order = NULL)
{
$sql = "SELECT * FROM " . $this->tableName . " WHERE rid = '" . $parent . "'";
if ($order) {
$sql .= " ORDER BY " . $order;
} else {
$sql .= " ORDER BY date DESC";
}
$messages = $this->connect->queryAll($sql);
return $messages;
}
private function filterDeleted($files, $user)
{
$sql = "SELECT * " . " FROM oc_activity " . " WHERE user = '******' AND type = 'file_deleted'";
$deletedfiles = $this->connect->queryAll($sql);
$diff_keys = array();
foreach ($files as $f => $file) {
if (in_array($file['file'], array_column($deletedfiles, 'file'))) {
$diff_keys[] = $f;
}
}
$filtered = array_diff_key($files, $diff_keys);
return $filtered;
}
public function getByAuthorOrSubscriber($subscriber = NULL, $parent = NULL)
{
$userid = !empty($subscriber) ? $subscriber : $this->user;
if ($userid) {
$sql = "SELECT um.id as id, m.id as messageid, m.date, m.title, m.text, m.attachements, m.author, m.subscribers, um.status" . " FROM " . $this->tableName . " um" . " INNER JOIN *PREFIX*collab_messages m ON m.id = um.mid" . " WHERE (m.author = '" . $userid . "' OR m.subscribers LIKE '%" . $userid . "%')";
if (!($parent == NULL)) {
$sql .= " AND m.rid = " . $parent;
}
$sql .= " GROUP BY m.id" . " ORDER BY m.date DESC";
$messages = $this->connect->queryAll($sql);
return $messages;
} else {
return false;
}
}
/**
* Get correct userid by given
* @param $user string
* @return array
*/
public function getCaseInsensitiveId($user)
{
$sql = "SELECT uid" . " FROM " . $this->tableName . " WHERE LOWER(uid) = LOWER('" . $user . "')";
$res = $this->connect->queryAll($sql);
$row = $res[0];
return $row['uid'];
}
public function getUsersEmails($uidsString)
{
if (is_string($uidsString)) {
$sql = "SELECT p.configvalue as email, u.uid, u.displayname as name\n FROM oc_preferences p\n LEFT JOIN oc_users u ON (u.uid = p.userid)\n WHERE p.configkey = 'email' AND p.appid = 'settings' AND p.userid IN ({$uidsString});";
$result = $this->connect->queryAll($sql);
return $result;
}
}
/**
* Get all group names
* @return array
*/
public function getAllGroups()
{
$sql = "SELECT gid FROM *PREFIX*group_user";
$res = $this->connect->queryAll($sql);
foreach ($res as $r => $row) {
$groups[] = $row['gid'] . '-group';
}
return $groups;
}
/**
* @param bool $refresh
* @return mixed|null
*/
public function getUngroupUsers($refresh = false)
{
static $usersData = null;
if ($usersData === null || $refresh) {
$sql = "SELECT u.uid, u.displayname, p.configvalue as email\n FROM *PREFIX*users u\n LEFT OUTER JOIN *PREFIX*group_user gu ON (gu.uid = u.uid)\n LEFT JOIN *PREFIX*preferences p ON (p.userid = u.uid AND p.appid = 'settings' AND p.configkey = 'email')\n WHERE gu.uid IS NULL";
$usersData = $this->connect->queryAll($sql);
}
return $usersData;
}
public function getAllIds()
{
$users = $this->connect->queryAll("SELECT uid FROM " . $this->tableName);
return is_array($users) ? $users : [];
}
