Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F117734280
PhabricatorFeedStoryNotification.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Sun, Jun 15, 14:35
Size
1 KB
Mime Type
text/x-php
Expires
Tue, Jun 17, 14:35 (2 d)
Engine
blob
Format
Raw Data
Handle
26773516
Attached To
rPH Phabricator
PhabricatorFeedStoryNotification.php
View Options
<?php
final
class
PhabricatorFeedStoryNotification
extends
PhabricatorFeedDAO
{
protected
$userPHID
;
protected
$primaryObjectPHID
;
protected
$chronologicalKey
;
protected
$hasViewed
;
protected
function
getConfiguration
()
{
return
array
(
self
::
CONFIG_IDS
=>
self
::
IDS_MANUAL
,
self
::
CONFIG_TIMESTAMPS
=>
false
,
self
::
CONFIG_COLUMN_SCHEMA
=>
array
(
'chronologicalKey'
=>
'uint64'
,
'hasViewed'
=>
'bool'
,
'id'
=>
null
,
),
self
::
CONFIG_KEY_SCHEMA
=>
array
(
'PRIMARY'
=>
null
,
'userPHID'
=>
array
(
'columns'
=>
array
(
'userPHID'
,
'chronologicalKey'
),
'unique'
=>
true
,
),
'userPHID_2'
=>
array
(
'columns'
=>
array
(
'userPHID'
,
'hasViewed'
,
'primaryObjectPHID'
),
),
'key_object'
=>
array
(
'columns'
=>
array
(
'primaryObjectPHID'
),
),
'key_chronological'
=>
array
(
'columns'
=>
array
(
'chronologicalKey'
),
),
),
)
+
parent
::
getConfiguration
();
}
public
static
function
updateObjectNotificationViews
(
PhabricatorUser
$user
,
$object_phid
)
{
if
(
PhabricatorEnv
::
isReadOnly
())
{
return
;
}
$unguarded
=
AphrontWriteGuard
::
beginScopedUnguardedWrites
();
$notification_table
=
new
PhabricatorFeedStoryNotification
();
$conn
=
$notification_table
->
establishConnection
(
'w'
);
queryfx
(
$conn
,
'UPDATE %T
SET hasViewed = 1
WHERE userPHID = %s
AND primaryObjectPHID = %s
AND hasViewed = 0'
,
$notification_table
->
getTableName
(),
$user
->
getPHID
(),
$object_phid
);
unset
(
$unguarded
);
}
public
function
countUnread
(
PhabricatorUser
$user
)
{
$conn
=
$this
->
establishConnection
(
'r'
);
$data
=
queryfx_one
(
$conn
,
'SELECT COUNT(*) as count
FROM %T
WHERE userPHID = %s AND hasViewed = 0'
,
$this
->
getTableName
(),
$user
->
getPHID
());
return
$data
[
'count'
];
}
}
Event Timeline
Log In to Comment