<?php

/**
 * Subclass for performing query and update operations on the 'st_notification' table.
 *
 * 
 *
 * @package plugins.stNotificationPlugin.lib.model
 */ 
class NotificationPeer extends \BaseNotificationPeer
{
    public static function doCountUnread()
    {
        $c = new Criteria();
        $c->add(self::IS_MARKED_AS_READ, false);

        return self::doCount($c);
    }

    public static function doSelectUnread(\Criteria $c)
    {
        $c = clone $c;
        $c->add(self::IS_MARKED_AS_READ, false);
        $c->addDescendingOrderByColumn(self::TYPE);
        $c->addDescendingOrderByColumn(self::CREATED_AT);

        return self::doSelect($c);
    }

    public static function retrieveByMessageId($id)
    {
        $c = new Criteria();
        $c->add(self::MESSAGE_ID, $id);

        return self::doSelectOne($c);
    }
}