121
$searchModel = new \app\models\UserSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('user', [
'searchModel' => $searchModel,
'dataProvider' => $dataProvider,
'Settings' => $Settings,
]);
}
public function RequestCountСreated ($date)
{
$Q = new Yii\db\Query ();
return $Q->select('*')->from(['request'])->where('receive_date >= :date1 and
receive_date < :date2')
->params ([':date1'=>date('Y-m-d', $date), ':date2'=>date('Y-m-d',
strtotime(date('Y-m-d', $date) . ' +1 day'))])->count();
}
public function RequestCountClosed ($date)
{
$Q = new Yii\db\Query ();
return $Q->select('*')->from(['request'])->where('id_request_state = 4 and
complete_date >= :date1 and complete_date < :date2')
->params ([':date1'=>date('Y-m-d', $date), ':date2'=>date('Y-m-d',
strtotime(date('Y-m-d', $date) . ' +1 day'))])->count();
}
public function RequestCountProcessing ($date)
{
$Q = new Yii\db\Query ();
return $Q->select('*')->from(['request'])->where('id_request_state <> 4 and
receive_date >= :date1 and receive_date < :date2')
->params ([':date1'=>date('Y-m-d', $date), ':date2'=>date('Y-m-d',
strtotime(date('Y-m-d', $date) . ' +1 day'))])->count();
}
public function actionCommon ()
122
{
$Settings = Settings::findOne(Yii::$app->user->identity->id);
$date1 = date('Y-m-d', strtotime($Settings->report_date_1));
$date2 = date('Y-m-d', strtotime($Settings->report_date_2));
$data = [];
for ($i = 0; true; $i ++)
{
$record = [];
$date = strtotime($date1 . ' +' . $i . ' day');
if ($date > strtotime($date2))
break;
$record['date'] = $date;
$record['created'] = $this->RequestCountСreated($date);
$record['closed'] = $this->RequestCountClosed($date);
$record['processing'] = $this->RequestCountProcessing($date);
$data[] = $record;
}
$dataProvider = new ArrayDataProvider([
'allModels' => $data,
'sort' => [
'attributes' => ['date', 'created', 'closed', 'processing'],
],
'pagination' => [
'pageSize' => 20,
],
]);
return $this->render('common', [
'dataProvider' => $dataProvider,
'Settings' => $Settings,
]);
}
}
