Count where not defined

Question

Count where not defined

GunslerRage Mar '17

Created Mar '17	Last Reply Mar '17	Replies 3	Views 54	Votes 0

GunslerRage 11.3k

Mar '17

I have two tables

Notifications Notifications_seen

if notifcation is seen a row is added to notification_seen

But I need to count how many notifcations that's not seen. How do I do this? Any suggestions ?

Jonathan Aaron Steel · Answer 1 · 2017-03-06T10:13:54-07:00

Just call count() method on your model object?

https://docs.phalconphp.com/en/latest/reference/models.html#generating-calculations

GunslerRage · Answer 2 · 2017-03-06T10:25:46-07:00

GunslerRage
11.3k

Mar '17

But how? Where not exist ?

Nikolay Mihaylov · Answer 3 · 2017-03-06T13:20:19-07:00

Hmmm why not just have column for that in the notifications table and remove the second table? Isseen(tinyint) or seenat (timestamp) ?

If you really want to have two tables look here.

PolDeveloper · Answer 4 · 2017-03-07T05:46:01-07:00

Hmmm why not just have column for that in the notifications table and remove the second table? Isseen(tinyint) or seenat (timestamp) ?

If you really want to have two tables look here.

I think it's the best option.

is_seen -> default value is 0, when seen it's become 1.

So every seen -> count all where is_seen = 1

every unseen -> count all where is_seen = 0