117
* @return Object the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Object::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
}
ReportController.php
<?php
namespace app\controllers;
use Yii;
use app\models\Settings;
use yii\web\Controller;
use yii\web\NotFoundHttpException;
use yii\base\UserException;
use yii\filters\VerbFilter;
use yii\filters\AccessControl;
use yii\data\ActiveDataProvider;
use yii\data\ArrayDataProvider;
118
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' => [
119
'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 ();
120
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 ()
{
$Settings = Settings::findOne(Yii::$app->user->identity->id);
121
$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' => [
122
'pageSize' => 20,
],
]);
return $this->render('common', [
'dataProvider' => $dataProvider,
'Settings' => $Settings,
]);
}
}
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;
123
/**
* RequestController implements the CRUD actions for Request model.
*/
class RequestController extends Controller
{
public function behaviors()
{
return [
'access' => [
'class' =>AccessControl::className(),
'rules' =>
[
[
'actions' => ['index', 'view', 'create',
'update', 'delete'],
'allow' => true,
'roles' => ['@'],
'matchCallback' => function ($rule,
$action)
{
return Yii::$app->user-
>identity->IsAdmin || Yii::$app->user->identity->IsExpert;
}
],
],
],
'verbs' => [
'class' =>VerbFilter::className(),
'actions' => [
124
'delete' => ['post'],
],
],
];
}
/**
* Lists all Request models.
* @return mixed
*/
public function actionIndex()
{
$searchModel = new RequestSearch();
$dataProvider = $searchModel->search(Yii::$app->request-
>queryParams);
if (Yii::$app->user->identity->IsAdmin == false)
{
$id = Yii::$app->user->identity->id;
$dataProvider->query->andWhere('id_creator = ' . $id . ' or
id_performer = ' . $id);
}
return $this->render('index', [
'searchModel' => $searchModel,
'dataProvider' => $dataProvider,
]);
}
/**
* Displays a single Request model.
125
* @param integer $id
* @return mixed
*/
public function actionView($id)
{
return $this->render('view', [
'model' => $this->findModel($id),
]);
}
/**
* Creates a new Request model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Request();
if ($model->load(Yii::$app->request->post()) && $model->save())
{
$model->receive_date = date("Y-m-d H:i:s");
$model->id_creator = Yii::$app->user->identity->id;
$model->save();
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('create', [
'model' => $model,
]);
}
}
126
/**
* Updates an existing Request model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
if ($model->id_request_state == 4 && Yii::$app->user->identity-
>IsAdmin == false)
{
throw new UserException ('Закрытую заявку может
редактировать только администратор');
}
$old_state = $model->id_request_state;
if ($model->load(Yii::$app->request->post()) && $model->save())
{
if ($old_state != $model->id_request_state && $model-
>id_request_state > 2)
{
$model->complete_date = date("Y-m-d H:i:s");
$model->save();
}
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('update', [
'model' => $model,
]);