126
])->
from(['claim_type', 'request_claim', 'request'])->
andWhere ('claim_type.id = request_claim.id_claim_type')->
andWhere ('request.id = request_claim.id_request')->
andWhere ('request.date_reg >= :date1 and request.date_reg
< :date2')->
groupby (['claim_type.id', 'claim_type.title'])->
orderby('claim_type.title')->
params ([':date1'=>$User->report_date_1, ':date2'=>$User-
>report_date_2])
;
$dataProvider = new ActiveDataProvider([
'query' => $Q
,
]);
return $this->render('report-claim-stat', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
}
/**
* Finds the Request model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
127
* @param integer $id
* @return Request the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Request::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not
exist.');
}
}
}
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;
/**
* RequestController implements the CRUD actions for Request model.
*/
128
class RequestController extends Controller
{
public function behaviors()
{
return [
'verbs' => [
'class' => VerbFilter::className(),
'actions' => [
'delete' => ['post'],
],
],
'access' => [
'class' => AccessControl::className(),
'rules' => [
[
'actions' => ['index', 'view', 'create', 'update',
'delete'],
'allow' => true,
'roles' => ['@'],
],
],
],
];
}
/**
* Lists all Request models.
* @return mixed
*/
129
public function actionIndex()
{
Yii::$app->user->identity->accessAdminManagerClient;
$searchModel = new RequestSearch();
if (Yii::$app->user->identity->isClient)
{
$searchModel->id_client = Yii::$app->user->identity->id;
}
$dataProvider = $searchModel->search(Yii::$app->request-
>queryParams);
return $this->render('index', [
'searchModel' => $searchModel,
'dataProvider' => $dataProvider,
]);
}
/**
* Displays a single Request model.
* @param integer $id
* @return mixed
*/
public function actionView($id)
{
Yii::$app->user->identity->accessAdminManagerClient;
return $this->render('view', [
'model' => $this->findModel($id),
]);
}
/**
130
* Creates a new Request model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
Yii::$app->user->identity->accessAdminManagerClient;
$model = new Request();
if (Yii::$app->user->identity->isClient)
{
$model->id_client = Yii::$app->user->identity->id;
}
if (!Yii::$app->user->identity->isClient)
{
$model->id_user = Yii::$app->user->identity->id;
}
if ($model->load(Yii::$app->request->post()) && $model->save())
{
if (empty ($model->date_reg))
{
$model->date_reg = date("Y-m-d H:i:s");
$model->save();
}
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render(Yii::$app->user->identity->isClient ? 'client_create'
: 'create', [
'model' => $model,
]);
131
}
}
/**
* 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)
{
Yii::$app->user->identity->accessAdminManagerClient;
$model = $this->findModel($id);
if ($model->load(Yii::$app->request->post()) && $model->save())
{
if (!Yii::$app->user->identity->isClient)
{
if (empty($model->id_user))
{
$model->id_user = Yii::$app->user->identity-
>id;
$model->save();
}
}
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render(Yii::$app->user->identity->isClient ?
'client_update' : 'update', [
'model' => $model,
]);
}
132
}
/**
* Deletes an existing Request model.
* If deletion is successful, the browser will be redirected to the 'index' page.
* @param integer $id
* @return mixed
*/
public function actionDelete($id)
{
Yii::$app->user->identity->accessAdminManagerClient;
$this->findModel($id)->delete();
return $this->redirect(['index']);
}
/**
* Finds the Request model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Request the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Request::findOne($id)) !== null)
{
if (Yii::$app->user->identity->isClient)
{
if ($model->id_client <> Yii::$app->user->identity-
>id)
{
133
Yii::$app->user->getAccess ([]);
}
}
return $model;
} else {
throw new NotFoundHttpException('The requested page does not
exist.');
}
}
}
ServiceController.php
<?php
namespace app\controllers;
use Yii;
use app\models\Service;
use yii\data\ActiveDataProvider;
use yii\web\Controller;
use yii\web\NotFoundHttpException;
use yii\filters\VerbFilter;
use yii\filters\AccessControl;
/**
* ServiceController implements the CRUD actions for Service model.
*/
class ServiceController extends Controller
134
{
public function behaviors()
{
return [
'verbs' => [
'class' => VerbFilter::className(),
'actions' => [
'delete' => ['post'],
],
],
'access' => [
'class' => AccessControl::className(),
'rules' => [
[
'actions' => ['index', 'view', 'create', 'update',
'delete'],
'allow' => true,
'roles' => ['@'],
],
],
],
];
}
/**
* Lists all Service models.
* @return mixed
*/
public function actionIndex()
135
{
Yii::$app->user->identity->accessAdminOnly;
$dataProvider = new ActiveDataProvider([
'query' => Service::find(),
]);
return $this->render('index', [
'dataProvider' => $dataProvider,
]);
}
/**
* Displays a single Service model.
* @param integer $id
* @return mixed
*/
public function actionView($id)
{
Yii::$app->user->identity->accessAdminOnly;
return $this->render('view', [
'model' => $this->findModel($id),
]);
}
/**
* Creates a new Service model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
Yii::$app->user->identity->accessAdminOnly;