/**
* Manages all models.
*/
public function actionIndex()
{
//$pageSize = Yii::app()->request->getParam('pageSize',Yii::app()->params['pageSize']);
//Yii::app()->user->setState('pageSize',$pageSize);
$model = new GameEventReportAllModel('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['GameEventReportAllModel'])) {
$model->attributes = $_GET['GameEventReportAllModel'];
}
$date = trim($_GET['GameEventReportAllModel']['date']);
$splited = explode("-", $date);
if (count($splited) > 1) {
$fromDate = DateTime::createFromFormat('m/j/Y', trim($splited[0]))->format('Y-m-j');
$toDate = DateTime::createFromFormat('m/j/Y', trim($splited[1]))->format('Y-m-j');
$model->date = array($fromDate . ' 0:0:0', $toDate . ' 23:59:59');
} else {
if ($date != "") {
$model->date = DateTime::createFromFormat('m/j/Y', $date)->format('Y-m-j');
}
}
$data = $model->searchTotal();
$total = array('total_sub' => 0, 'total_unsub' => 0, 'access_event' => 0, 'access_play' => 0, 'total_play_all' => 0, 'total_msisdn_valid' => 0, 'listen_music' => 0, 'download_music' => 0, 'play_video' => 0, 'download_video' => 0, 'have_transaction' => 0);
foreach ($data as $row) {
$total['total_sub'] += $row['total_sub'];
$total['total_unsub'] += $row['total_unsub'];
$total['access_event'] += $row['access_event'];
$total['access_play'] += $row['access_play'];
$total['total_play_all'] += $row['total_play_all'];
$total['total_msisdn_valid'] += $row['total_msisdn_valid'];
$total['listen_music'] += $row['listen_music'];
$total['download_music'] += $row['download_music'];
$total['play_video'] += $row['play_video'];
$total['download_video'] += $row['download_video'];
$total['have_transaction'] += $row['have_transaction'];
}
$this->render('index', array('model' => $model, 'data' => $data, 'total' => $total));
}
