Дипломная работа: Автоматизация приема и анализа технической поддержки ООО "Мой Магазин"
Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
131
use yii\base\UserException;
use yii\filters\VerbFilter;
use yii\filters\AccessControl;
use yii\data\ActiveDataProvider;
use yii\data\ArrayDataProvider;
class ReportController extends \yii\web\Controller
{
public function behaviors()
{
return [
'access' => [
'class' => AccessControl::className(),
'rules' =>
[
[
'actions' => ['user', 'common'],
'allow' => true,
'roles' => ['@'],
'matchCallback' => function ($rule, $action)
{
return Yii::$app->user->identity->IsAdmin;
}
],
],
],
'verbs' => [
132
'class' => VerbFilter::className(),
'actions' => [
'delete' => ['post'],
],
],
];
}
public function actionUser()
{
$Settings = Settings::findOne(Yii::$app->user->identity->id);
$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 re-
ceive_date < :date2')
->params ( [':date1'=>date('Y-m-d', $date), ':date2'=>date('Y-m-d', strto-
time(date('Y-m-d', $date) . ' +1 day'))])->count();
133
}
public function RequestCountClosed ($date)
{
$Q = new Yii\db\Query ();
return $Q->select('*')->from( ['request'])->where('id_request_state = 4 and com-
plete_date >= :date1 and complete_date < :date2')
->params ( [':date1'=>date('Y-m-d', $date), ':date2'=>date('Y-m-d', strto-
time(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 re-
ceive_date >= :date1 and receive_date < :date2')
->params ( [':date1'=>date('Y-m-d', $date), ':date2'=>date('Y-m-d', strto-
time(date('Y-m-d', $date) . ' +1 day'))])->count();
}
public function actionCommon ()
{
$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 ++)
134
{
$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,
]);
}
135
}
RequestController.php
<?php
namespace app\controllers;
use Yii;
use app\models\Request;
use app\models\RequestSearch;
use yii\web\Controller;
use yii\web\NotFoundHttpException;
use yii\filters\VerbFilter;
use yii\filters\AccessControl;
use yii\base\UserException;
/**
* RequestController implements the CRUD actions for Request model.
*/
class RequestController extends Controller
{
public function behaviors()
{
return [
'access' => [
'class' => AccessControl::className(),
'rules' =>
[
Источник: https://baza.diplomsite.ru/previewfile/1961