public static function getOnlineList($page = 1)
{
$query = Doctrine_Query::create()->select('u.*')->from('sfGuardUser u, u.Profile p')->where('time_to_sec(timediff(now(), u.last_login)) < ?', sfConfig::get('app_user_online_period', 480))->andWhere('u.is_active = ?', true)->orderBy('time_to_sec(timediff(now(), u.last_login)) asc');
if ($page !== 'count') {
$query = new Doctrine_Pager($query, $page, sfConfig::get('app_users_per_page', 10));
return $query->execute();
} else {
return $query->count();
}
}
public static function getDateLine($date, $page = 1)
{
$query = Doctrine_Query::create()->select('p.*')->from('Post p, p.User u')->where('date(p.created_at) = date(?)', $date)->andWhere('u.is_active = ?', 1)->andWhere('p.type = ?', "post")->orderBy('p.created_at desc');
if (sfContext::getInstance()->getUser()->isAnonymous()) {
$query->addWhere('p.rating >= ?', sfConfig::get('app_post_worstpage_threshold'));
}
if ($page !== 'count') {
$query = new Doctrine_Pager($query, $page, sfConfig::get('app_posts_per_page', 10));
return $query->execute();
} else {
return $query->count();
}
}
public static function getList($page = 1)
{
$query = Doctrine_Query::create()->select()->from('Blog b')->orderBy('b.best desc, b.count desc');
if ($page !== 'count') {
$query = new Doctrine_Pager($query, $page, sfConfig::get('app_blogs_per_page'));
return $query->execute();
} else {
return $query->count();
}
}
