116
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
$dataProvider = new ActiveDataProvider([
'query' => Request::find()->where ('date_reg >= :date1 and date_reg
< :date2', [':date1'=>$User->report_date_1, ':date2'=>$User->report_date_2])
->andFilterWhere(['id_user'=>$User->report_id_user,
'id_defect'=>$User->report_id_defect, 'id_client'=>$User->report_id_client])
,
]);
return $this->render('report-request-journal', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
}
public function actionClaimJournal()
{
Yii::$app->user->identity->AccessAdminManager;
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
$dataProvider = new ActiveDataProvider([
'query' => RequestClaim::find()->
where ('date_reg >= :date1 and date_reg < :date2',
[':date1'=>$User->report_date_1, ':date2'=>$User->report_date_2])
->andFilterWhere(['id_request'=>$User-
>report_id_request])
117
,
]);
return $this->render('report-claim-journal', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
}
public function actionCompletedRequest()
{
Yii::$app->user->identity->AccessAdminManager;
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
$dataProvider = new ActiveDataProvider([
'query' => Request::find()->where ('id_status = 2 and date_reg >= :date1
and date_reg < :date2', [':date1'=>$User->report_date_1, ':date2'=>$User-
>report_date_2])
->andFilterWhere(['id_user'=>$User->report_id_user,
'id_defect'=>$User->report_id_defect, 'id_client'=>$User->report_id_client])
,
]);
return $this->render('report-completed-request', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
}
118
public function actionOpenRequest()
{
Yii::$app->user->identity->AccessAdminManager;
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
$dataProvider = new ActiveDataProvider([
'query' => Request::find()->where ('id_status <> 2 and date_reg
>= :date1 and date_reg < :date2', [':date1'=>$User->report_date_1, ':date2'=>$User-
>report_date_2])
->andFilterWhere(['id_user'=>$User->report_id_user,
'id_defect'=>$User->report_id_defect, 'id_client'=>$User->report_id_client])
,
]);
return $this->render('report-open-request', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
}
public function actionServices()
{
Yii::$app->user->identity->AccessAdminManager;
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
119
$dataProvider = new ActiveDataProvider([
'query' => RequestService::find()-
>andFilterWhere(['id_request'=>$User->report_id_request])
,
]);
return $this->render('report-services', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
}
public function actionStaffWorkTime()
{
Yii::$app->user->identity->AccessAdminManager;
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
$dataProvider = new ActiveDataProvider([
'query' => StaffWork::find()->where ('day >= :date1 and day < :date2',
[':date1'=>$User->report_date_1, ':date2'=>$User->report_date_2])
->andFilterWhere(['id_user'=>$User->report_id_user])
,
]);
return $this->render('report-staff-work-time', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
120
}
public function actionDefectCount()
{
Yii::$app->user->identity->AccessAdminManager;
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
$Q = new Yii\db\Query ();
$Q->select('defect.id, defect.title, count(defect.id) as
defect_count')->from(['defect', 'request'])->
andWhere ('defect.id = request.id_defect')->
andWhere ('request.date_reg >= :date1 and request.date_reg
< :date2')->
groupby('defect.id, defect.title')->
orderby('defect.title')->
params([':date1'=>$User->report_date_1, ':date2'=>$User-
>report_date_2])
;
$dataProvider = new ActiveDataProvider([
'query' => $Q
,
]);
return $this->render('report-defect-count', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
121
}
public function actionStaffWork()
{
Yii::$app->user->identity->AccessAdminManager;
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
$Q = new Yii\db\Query ();
$Q->select([
'user.id',
'user.last_name',
'user.first_name',
'user.middle_name',
'(select title from staff_function where id =
user.id_staff_function) as staff_function',
'(sum(if(request.id_status <> 2, 1, 0))) as
open_request_count',
'(sum(if(request.id_status = 2, 1, 0))) as
closed_request_count',
]
)->
from(['user', 'request'])->
andWhere ('user.id_user_type <> 3')->
andWhere ('user.id = request.id_user')->
andWhere ('request.date_reg >= :date1 and request.date_reg
< :date2')->
groupby (['user.id', 'user.last_name', 'user.first_name',
'user.middle_name'])->
122
orderby('user.last_name, user.first_name, user.middle_name')->
params ([':date1'=>$User->report_date_1, ':date2'=>$User-
>report_date_2])
;
$dataProvider = new ActiveDataProvider([
'query' => $Q
,
]);
return $this->render('report-staff-work', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
}
public function actionClients()
{
Yii::$app->user->identity->AccessAdminManager;
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
$Q = new Yii\db\Query ();
$Q->select([
'user.id',
'user.organization_name',
'user.last_name',
'user.first_name',
123
'user.middle_name',
'(select title from staff_function where id =
user.id_staff_function) as staff_function',
'(sum(if(request.id_status <> 2, 1, 0))) as
open_request_count',
'(sum(if(request.id_status = 2, 1, 0))) as
closed_request_count',
]
)->
from(['user', 'request'])->
andWhere ('user.id_user_type = 3')->
andWhere ('user.id = request.id_client')->
andWhere ('request.date_reg >= :date1 and request.date_reg
< :date2')->
groupby (['user.id', 'user.last_name', 'user.first_name',
'user.middle_name'])->
orderby('user.last_name, user.first_name, user.middle_name')->
//orderby('user.organization_name')->
params ([':date1'=>$User->report_date_1, ':date2'=>$User-
>report_date_2])
;
$dataProvider = new ActiveDataProvider([
'query' => $Q
,
]);
return $this->render('report-clients', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
124
}
public function actionServicesStat()
{
Yii::$app->user->identity->AccessAdminManager;
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
$Q = new Yii\db\Query ();
$Q->select([
'service.id',
'service.title',
'service.cost',
'sum(request_service.amount) as service_count',
'sum(request_service.amount)*service.cost as
service_total',
])->
from(['service', 'request_service', 'request'])->
andWhere ('service.id = request_service.id_service')->
andWhere ('request.id = request_service.id_request')->
andWhere ('request.date_reg >= :date1 and request.date_reg
< :date2')->
groupby (['service.id', 'service.title', 'service.cost'])->
orderby('service.title')->
params ([':date1'=>$User->report_date_1, ':date2'=>$User-
>report_date_2])
;
125
$dataProvider = new ActiveDataProvider([
'query' => $Q
,
]);
return $this->render('report-services-stat', [
'dataProvider' => $dataProvider,
'ReportParams' => User::findOne(Yii::$app->user-
>identity->id),
]);
}
public function actionClaimStat()
{
Yii::$app->user->identity->AccessAdminManager;
$User = User::find()->where (['id'=> Yii::$app->user->identity-
>id])->one();
$Q = new Yii\db\Query ();
$Q->select([
'claim_type.id',
'claim_type.title',
'count(claim_type.id) as claim_count',
'sum(if(request_claim.closed,1,0)) as
closed_claim_count',
'sum(if(request_claim.closed,0,1)) as
open_claim_count',