/** * @inheritdoc */ public function rules() { $rulesArray = [[['user_id', 'startdate'], 'required'], [['user_id', 'ticket_id'], 'integer'], [['cash', 'bonus_cash'], 'number', 'min' => 0, 'max' => 100000000], [['create_at', 'current_cost', 'residual'], 'safe'], [['residual'], 'safe', 'on' => 'pay-create'], [['residual'], 'integer', 'integerOnly' => true, 'min' => 0, 'on' => 'pay-edit'], [['comment'], 'string', 'max' => 255], ['user_id', 'exist', 'targetAttribute' => 'user_id', 'targetClass' => Profile::className()], ['ticket_id', 'exist', 'targetAttribute' => 'id', 'targetClass' => SeasonTicket::className()], ['ticket_id', 'notEmptyBoth'], ['groups', 'in', 'range' => array_keys(Group::getGroupArray()), 'allowArray' => true], ['startdate', 'date', 'format' => 'php:d.m.Y'], [['cash', 'bonus_cash'], 'default', 'value' => '0.00']]; if ($this->maxBonusBalance) { $rulesArray[] = ['bonus_cash', 'number', 'min' => 0, 'max' => $this->maxBonusBalance, 'tooBig' => Module::t('pay-admin', 'Insufficient funds in the bonus account')]; } else { $rulesArray[] = ['bonus_cash', 'validateBonusCash']; } return $rulesArray; }
/** * Lists all PaidEmployment models. * @return mixed */ public function actionIndex() { $groupsArray = ArrayHelper::map(Group::find()->asArray()->select('id, name')->orderBy('name')->all(), 'id', 'name'); $searchModel = new EmploymentSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); if (!empty($searchModel->userFullName)) { $filterUserDataArray = [$searchModel->userFullName => \common\models\Profile::getFullNameByUserId($searchModel->userFullName)]; } else { $filterUserDataArray = []; } return $this->render('index', compact(['searchModel', 'dataProvider', 'groupsArray', 'filterUserDataArray'])); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Group::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = PaidEmployment::find()->joinWith(['pay.profile', 'pay', 'timetable', 'timetable.group']); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['date' => SORT_DESC]]]); $dataProvider->sort->attributes['pay.profile.fullName'] = ['asc' => [Profile::tableName() . '.name' => SORT_ASC, Profile::tableName() . '.surname' => SORT_ASC], 'desc' => [Profile::tableName() . '.name' => SORT_DESC, Profile::tableName() . '.surname' => SORT_DESC]]; $dataProvider->sort->attributes['timetable.group.name'] = ['asc' => [Group::tableName() . '.name' => SORT_ASC], 'desc' => [Group::tableName() . '.name' => SORT_DESC]]; $dataProvider->sort->attributes['timetable.start'] = ['asc' => [Timetable::tableName() . '.start' => SORT_ASC], 'desc' => [Timetable::tableName() . '.start' => SORT_DESC]]; $dataProvider->sort->attributes['timetable.end'] = ['asc' => [Timetable::tableName() . '.end' => SORT_ASC], 'desc' => [Timetable::tableName() . '.end' => SORT_DESC]]; $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'date' => $this->date, 'pay_id' => $this->pay_id, 'pay.user_id' => $this->userFullName, 'timetable.group_id' => $this->timetableGroupId]); return $dataProvider; }
?> </div> </div> <div class="row"> <div class="col-sm-12"> <?php echo $form->field($model, 'description')->textArea(['maxlength' => 255]); ?> </div> </div> <div class="row"> <div class="col-sm-12"> <?php echo $form->field($model, 'status')->dropDownList(\backend\modules\group\models\Group::getStatusArray()); ?> </div> </div> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? Module::t('group-admin', 'Create') : Module::t('group-admin', 'Update'), ['class' => $model->isNewRecord ? 'btn btn-primary btn-large' : 'btn btn-success btn-large']); ?> </div> <?php ActiveForm::end(); ?> </div>
<?php use backend\modules\timetable\widgets\GroupGridView as GridView; use backend\modules\group\models\Group; echo GridView::widget(['id' => 'show-timetable', 'dataProvider' => $dataProvider, 'layout' => '{items}', 'tableOptions' => ['class' => 'table table-bordered text-center'], 'headerRowOptions' => ['class' => 'active'], 'mergeColumns' => ['week_day'], 'columns' => [['attribute' => 'week_day', 'options' => ['class' => 'col-xs-3'], 'contentOptions' => ['style' => 'vertical-align: middle;'], 'value' => function ($model) { return $model->weekArray[$model->week_day]; }], ['attribute' => 'start', 'options' => ['class' => 'col-xs-2'], 'contentOptions' => ['style' => 'vertical-align: middle;']], ['attribute' => 'end', 'options' => ['class' => 'col-xs-2'], 'contentOptions' => ['style' => 'vertical-align: middle;']], ['attribute' => 'group_id', 'options' => ['class' => 'col-xs-5'], 'value' => function ($model) { return Group::getGroupArray()[$model->group_id]; }]]]);
/** * Creates a new Pay model. * If creation is successful, the browser will be redirected to the 'view' page. * @param integer $user_id * @return mixed */ public function actionCreate($user_id = false) { if ($user_id) { $profile = Profile::findOne(['user_id' => $user_id]); if (!$profile) { throw new HttpException(404); } $model = new Pay(); $model->setScenario('pay-create'); $model->maxBonusBalance = $profile->bonus_balance; $tickets = SeasonTicket::getTicketArray(); //ajax validation if (Yii::$app->request->isAjax && $model->load(Yii::$app->request->post())) { Yii::$app->response->format = Response::FORMAT_JSON; return ActiveForm::validate($model); } if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->id]); } else { $groups = Group::getGroupArray(); return $this->render('create', ['model' => $model, 'profile' => $profile, 'tickets' => $tickets, 'groups' => $groups]); } } else { $searchModel = new UserSearch(); $dataProvider = $searchModel->search(Yii::$app->request->get()); return $this->render('listusers', ['dataProvider' => $dataProvider, 'searchModel' => $searchModel]); } }
/** * Finds the Group model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Group the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModelAll($id) { if (($model = Group::find()->where(['id' => $id])->all()) !== null) { return $model; } else { throw new HttpException(404); } }
/** * @return \yii\db\ActiveQuery */ public function getGroup() { return $this->hasOne(Group::className(), ['id' => 'group_id']); }
<?php echo Html::a('<i class="fa fa-eye"></i>', ['view'], ['class' => 'btn btn-default btn-sm', 'title' => Module::t('timetable-admin', 'View')]); ?> <?php echo Html::a('<i class="fa fa-leanpub"></i>', ['publish'], ['class' => 'btn btn-warning btn-sm', 'title' => Module::t('timetable-admin', 'Publish')]); ?> <?php echo Html::a('<i class="fa fa-plus"></i>', ['create'], ['class' => 'btn btn-primary btn-sm', 'title' => Module::t('timetable-admin', 'Create')]); ?> <?php echo Html::a('<i class="fa fa-ban"></i>', ['cancel-lessons'], ['class' => 'btn btn-danger btn-sm', 'title' => Module::t('timetable-admin', 'Cancel lessons')]); ?> <?php echo Html::a('<i class="fa fa-trash"></i>', ['batch-delete'], ['class' => 'btn btn-danger btn-sm', 'id' => 'batch-delete', 'title' => Module::t('timetable-admin', 'Delete selected')]); ?> </div> </div> <div class="box-body"> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'id' => $gridId, 'filterModel' => $searchModel, 'export' => false, 'columns' => [['class' => CheckboxColumn::classname()], ['attribute' => 'week_day', 'pageSummary' => true, 'class' => 'kartik\\grid\\EditableColumn', 'editableOptions' => ['inputType' => 'dropDownList', 'type' => 'post', 'formOptions' => ['action' => Url::toRoute('edit'), 'id' => 'timetable-form'], 'data' => Timetable::getWeekArray()], 'value' => function ($model) { return $model->weekArray[$model->week_day]; }, 'filter' => Html::activeDropDownList($searchModel, 'week_day', Timetable::getWeekArray(), ['class' => 'form-control', 'prompt' => ''])], ['attribute' => 'start', 'filter' => false, 'class' => 'kartik\\grid\\EditableColumn', 'editableOptions' => ['inputType' => 'textInput', 'type' => 'post', 'formOptions' => ['action' => Url::toRoute('edit'), 'id' => 'timetable-form']]], ['attribute' => 'end', 'filter' => false, 'class' => 'kartik\\grid\\EditableColumn', 'editableOptions' => ['inputType' => 'textInput', 'type' => 'post', 'formOptions' => ['action' => Url::toRoute('edit'), 'id' => 'timetable-form']]], ['attribute' => 'group_id', 'class' => 'kartik\\grid\\EditableColumn', 'format' => 'html', 'editableOptions' => ['inputType' => 'dropDownList', 'data' => Group::getGroupArray(), 'type' => 'post', 'formOptions' => ['action' => Url::toRoute('edit'), 'id' => 'timetable-form']], 'value' => function ($model) { return Group::getGroupArray()[$model->group_id]; }, 'filter' => Html::activeDropDownList($searchModel, 'group_id', Group::getGroupArray(), ['class' => 'form-control', 'prompt' => ''])], ['class' => 'yii\\grid\\ActionColumn', 'buttons' => ['clone' => function ($url) { return Html::a('<i class="fa fa-files-o"></i>', $url, ['title' => Module::t('timetable-admin', 'Clone row'), 'class' => 'btn btn-default btn-xs']); }], 'template' => '{clone} {update} {delete}', 'buttonOptions' => ['class' => 'btn btn-default btn-xs'], 'headerOptions' => ['style' => 'width:100px;'], 'header' => Module::t('timetable-admin', 'Actions')]]]); ?> </div> </div> </div>
$this->registerJs("jQuery(document).on('click', '#batch-delete', function (evt) {" . "evt.preventDefault();" . "var keys = jQuery('#" . $gridId . "').yiiGridView('getSelectedRows');" . "if (keys == '') {" . "alert('" . Module::t('group-admin', 'You need to select at least one item.') . "');" . "} else {" . "if (confirm('" . Module::t('group-admin', 'Are you sure you want to delete selected items?') . "')) {" . "jQuery.ajax({" . "type: 'POST'," . "url: jQuery(this).attr('href')," . "data: {ids: keys}" . "});" . "}" . "}" . "});"); ?> <div class="<?php echo $gridId; ?> "> <div class="box box-default"> <div class="box-header"> <div class="pull-right"> <?php echo Html::a('<i class="fa fa-plus"></i>', ['create'], ['class' => 'btn btn-primary btn-sm', 'title' => Module::t('group-admin', 'Create')]); ?> <?php echo Html::a('<i class="fa fa-trash"></i>', ['batch-delete'], ['class' => 'btn btn-danger btn-sm', 'id' => 'batch-delete', 'title' => Module::t('group-admin', 'Delete selected')]); ?> </div> </div> <div class="box-body"> <?php // echo $this->render('_search', ['model' => $searchModel]); ?> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'id' => $gridId, 'filterModel' => $searchModel, 'columns' => [['class' => CheckboxColumn::classname()], 'name', 'description:html', ['attribute' => 'status', 'value' => function ($data) { return Group::getStatusArray()[$data->status]; }, 'filter' => Html::activeDropDownList($searchModel, 'status', Group::getStatusArray(), ['class' => 'form-control', 'prompt' => ''])], ['class' => 'yii\\grid\\ActionColumn', 'buttonOptions' => ['class' => 'btn btn-default btn-xs'], 'headerOptions' => ['style' => 'width:95px;'], 'header' => Module::t('group-admin', 'Actions')]]]); ?> </div> </div> </div>
/** * Updates an existing Timetable model. * If update is successful, the browser will be redirected to the 'view' page * @return mixed */ public function actionEdit() { if (Yii::$app->request->post('hasEditable') && Yii::$app->request->post('editableKey')) { $model = $this->findModel(Yii::$app->request->post('editableKey')); $model->setScenario('timetable-edit'); $postEditableIndex = Yii::$app->request->post('editableIndex'); $postTimetable = Yii::$app->request->post('Timetable')[$postEditableIndex]; $output = ''; $message = ''; if (is_array($postTimetable)) { foreach ($postTimetable as $key => $value) { if (isset($model->{$key})) { $model->{$key} = $output = $value; if ('week_day' === (string) $key) { $output = Timetable::getWeekArray()[$value]; } if ('group_id' === (string) $key) { $output = Group::getGroupArray()[$value]; } if (!$model->validate() || !$model->save(false)) { echo Json::encode(['output' => $output, 'message' => $model->errors[$key]]); } else { echo Json::encode(['output' => $output, 'message' => '']); } break; } } } } }