/**
* @brief get the number of unread notifications for the logged in user
* @param $uid user id
* @return number of unread notifications, 0 if not logged in
*/
public static function getUnreadNumber($uid = null)
{
if (is_null($uid)) {
if (OCP\User::isLoggedIn()) {
$uid = OCP\User::getUser();
} else {
return 0;
}
}
if (!isset(self::$unreadNumStmt)) {
self::$unreadNumStmt = OCP\DB::prepare("SELECT COUNT(*) FROM *PREFIX*notifications WHERE read = 0 AND uid = ?");
}
return self::$unreadNumStmt->execute(array($uid))->fetchOne();
}
