/**
* @return array
*/
public function originFilter()
{
$origin = AuditJavascript::getDb()->cache(function () {
return AuditJavascript::find()->distinct(true)->select('origin')->where(['entry_id' => $this->entry_id])->andWhere(['is not', 'origin', null])->groupBy('origin')->orderBy('origin ASC')->column();
}, 30);
return array_combine($origin, $origin);
}
/* @var $this yii\web\View */
/* @var $dataProvider yii\data\ActiveDataProvider */
$this->title = Yii::t('audit', 'Audit Module');
$this->params['breadcrumbs'][] = $this->title;
$this->registerCss('canvas {width: 100% !important;height: 400px;}');
$dataSet = ['fillColor' => "rgba(151,187,205,0.5)", 'strokeColor' => "rgba(151,187,205,1)", 'pointColor' => "rgba(151,187,205,1)", 'pointStrokeColor' => "#fff"];
$options = ['height' => 400, 'width' => 400];
$days = [];
$count = ['entry' => [], 'trail' => [], 'javascript' => [], 'error' => []];
foreach (range(-6, 0) as $day) {
$date = strtotime($day . 'days');
$days[] = date('D: Y-m-d', $date);
$count['entry'][] = AuditEntry::find()->where(['between', 'created', date('Y-m-d 00:00:00', $date), date('Y-m-d 23:59:59', $date)])->count();
$count['trail'][] = AuditTrail::find()->where(['between', 'created', date('Y-m-d 00:00:00', $date), date('Y-m-d 23:59:59', $date)])->count();
$count['mail'][] = AuditMail::find()->where(['between', 'created', date('Y-m-d 00:00:00', $date), date('Y-m-d 23:59:59', $date)])->count();
$count['javascript'][] = AuditJavascript::find()->where(['between', 'created', date('Y-m-d 00:00:00', $date), date('Y-m-d 23:59:59', $date)])->count();
$count['error'][] = AuditError::find()->where(['between', 'created', date('Y-m-d 00:00:00', $date), date('Y-m-d 23:59:59', $date)])->count();
}
//fake data
//foreach ($count as $type => $data) {
// foreach ($data as $k => $v) {
// if (!$v) {
// $v = $type == 'entry' ? rand(100, 1000) : rand(0, 100);
// $count[$type][$k] = $v;
// }
// }
//}
?>
<div class="audit-index">
<h1><?php
