Дипломная работа: Автоматизация обработки заявок в АО «ТЭК-Торг»

Скачать

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
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),
]);
Источник: https://baza.diplomsite.ru/previewfile/1859

Смотрите также:

_1966(~1
"Логистическая технология JIT"
«Дизайнерские дети» как профилактика инвалидизации общества
[2 курс] Определения
00438
00463
1 Аминокислоты. Белки
1_8ДХафф
1-23
1. Автотрансформаторы, их назначение 1 Автотрансформатор, его история