Код: Выделить всё
public function getUserActivity()
{
$criteria=new CDbCriteria;
$criteria->select = array('user_email,count(*) as count');
$criteria->condition = $this->_condition;
$criteria->addCondition('types_id = 1');
$criteria->group = 'user_email';
$criteria->order = 'count desc';
if($this->count > 0)
{
$criteria->having = 'count(*) >= :count';
}
$criteria->params = $this->_params;
$criteria->with = $this->_with;
$criteria->together = $this->_together;
return new CActiveDataProvider('LogMessage', array(
'criteria'=>$criteria,
'pagination'=>array(
'pageSize'=>30,
),
));
}
Код: Выделить всё
<?php $this->widget('bootstrap.widgets.BsGridView', array(
'id' => 'logs-table',
'type' => 'bordered',
'dataProvider' => $model->getUserActivity(),
'template' => "{summary}\n{items}\n{pager}",
'htmlOptions' => array('class' => 'logs_table admin_table'),
'summaryText' => Yii::app()->getModule('track')->t('Total records') . ': {count}',
'summaryCssClass' => 'pull-right',
'columns' => array(
'user_email',
'count'
),
)); ?>