/**
* Returt Top 5 Authors by Period and category
*
* @param Period $period
* @param int $category_id
* @return Doctrine_Collection
*/
public function getTopAuthors(Period $period = null, $iCategoryId = 0)
{
if ($iCategoryId == 0) {
$q = UserTable::addPUserQuery();
$q = UserTable::addActiveQuery($q);
$q->andWhere($q->getRootAlias() . '.sells > ?', 0)->orderBy($q->getRootAlias() . '.sells DESC');
} else {
$q = Doctrine_Query::create()->select('u.*, sum(c.purchase_cnt) as sells')->from('User u')->innerJoin('u.Content c')->groupBy('c.id_user')->orderBy('u.sells')->where('c.id_category=?', $iCategoryId)->andWhere('sells > ?', 0);
$q = UserTable::addPUserQuery($q);
$q = UserTable::addActiveQuery($q);
}
$q->limit(5);
return $q->execute();
}
/**
* Enter description here...
*
* @return <Doctrine_Collection>
*/
public static function getPUsersActive()
{
$q = UserTable::addPUserQuery();
$q = UserTable::addActiveQuery($q);
return $q->execute();
}
