/**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = AnswerList::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $sort = $dataProvider->getSort();
     $sort->attributes['officeName'] = ['asc' => ['questionlist_office.name' => SORT_ASC], 'desc' => ['questionlist_office.name' => SORT_DESC], 'label' => 'Отделение'];
     $sort->attributes['statusName'] = ['asc' => ['status' => SORT_ASC], 'desc' => ['status' => SORT_DESC], 'label' => 'Статус'];
     $dataProvider->setSort($sort);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         $query->joinWith(['questionlist_office']);
         return $dataProvider;
     }
     $query->joinWith('questionList');
     $query->andFilterWhere(['id' => $this->id, 'question_list_id' => $this->question_list_id, 'scores' => $this->scores, 'date' => $this->date]);
     $query->andFilterWhere(['>=', 'date_from', $this->date_from])->andFilterWhere(['<=', 'date_to', $this->date_to]);
     if (!$this->statusName) {
         $query->andFilterWhere(['not like', 'status', 'archive']);
     } else {
         $query->andFilterWhere(['like', 'status', $this->statusName]);
     }
     $query->joinWith(['office' => function ($q) {
         $q->andFilterWhere(['like', 'questionlist_office.name', $this->officeName]);
     }]);
     return $dataProvider;
 }
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = AnswerList::find()->with('questionList')->orderBy('status');
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id, 'question_list_id' => $this->question_list_id, 'date_from' => $this->date_from, 'date_to' => $this->date_to, 'date' => $this->date, 'do_id' => $this->officeName, 'scores' => $this->scores]);
     if ($this->statusName) {
         $query->andFilterWhere(['like', 'status', $this->statusName]);
     } else {
         $query->andFilterWhere(['not like', 'status', 'archive']);
     }
     return $dataProvider;
 }
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     // Если админ, то выбираем все опросы.
     if ($isAdmin = Users::findOne(['profile_id' => Yii::$app->user->identity->username, 'profile_office_role' => 'admin'])) {
         $officeIds = ArrayHelper::map(Office::find()->all(), 'id', 'id');
     } elseif ($isCommercialDirector = Users::findAll(['profile_id' => Yii::$app->user->identity->username, 'profile_office_role' => 'commercial_director'])) {
         // берем ID отделений, где регион отделения === региону, где пользователь коммерч.директор
         $regionIds = ArrayHelper::map($isCommercialDirector, 'region_id', 'region_id');
         $officeIds = ArrayHelper::map(Office::findAll(['region_id' => $regionIds]), 'id', 'id');
     } else {
         // берем ID отделений, где пользователь является управляющим, или где он назначен им.
         $officeIds = $this->getOffiсeIds(Yii::$app->user->identity->username);
     }
     $query = AnswerList::find()->joinWith('questionList')->where(['do_id' => $officeIds]);
     //$query = AnswerList::find()->innerJoinWith('questionList');
     $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]);
     $sort = $dataProvider->getSort();
     $sort->attributes['officeName'] = ['asc' => ['questionlist_office.name' => SORT_ASC], 'desc' => ['questionlist_office.name' => SORT_DESC], 'label' => 'Отделение'];
     $sort->attributes['statusName'] = ['asc' => ['status' => SORT_ASC], 'desc' => ['status' => SORT_DESC], 'label' => 'Статус'];
     $dataProvider->setSort($sort);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         $query->joinWith(['questionlist_office']);
         return $dataProvider;
     }
     $query->andFilterWhere(['questionlist_answer_list.id' => $this->id, 'question_list_id' => $this->question_list_id, 'scores' => $this->scores]);
     $query->andFilterWhere(['>=', 'date_from', $this->date_from])->andFilterWhere(['<=', 'date_to', $this->date_to]);
     if ($this->statusName) {
         $query->andFilterWhere(['like', 'status', $this->statusName]);
     } else {
         $query->andFilterWhere(['not like', 'status', 'archive']);
     }
     $query->joinWith(['office' => function ($q) {
         $q->andFilterWhere(['like', 'questionlist_office.name', $this->officeName]);
     }]);
     return $dataProvider;
 }
Example #4
0
<?php

use yii\widgets\DetailView;
use yii\grid\GridView;
use app\modules\unicred\questionlist\models\AnswerList;
/* @var $this yii\web\View */
/* @var $model app\modules\unicred\questionlist\models\AnswerList */
$statusList = AnswerList::getStatusList();
?>
<div class="answer-list-delete">
    <p> Данный опрос находится в статусе <b>"<?php 
echo $model->statusName;
?>
"</b>.<br/>
        Перенести в архив невозможно.
        <?php 
if ($model->status == 'archive') {
    ?>
            Опрос уже находится в данной группе.
        <?php 
}
?>
    </p>
    <p> Для переноса в архив, опрос должен быть в статусе <br>
        <b>"<?php 
echo $statusList['done'];
?>
"</b>. </p>
</div>
 /**
  * Проверка, можно ли изменять содержание опроса, после того,
  * как он назначен отделениям.
  */
 public function canCreateQuestion($question_list_id)
 {
     // Назначен ли опрос отделениям
     $modelsAnswerList = AnswerList::findAll(['question_list_id' => $question_list_id]);
     return !$modelsAnswerList;
 }
 /**
  * Finds the AnswerList model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return AnswerList the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModelWithRelations($id)
 {
     $query = AnswerList::find(['id' => $id])->with(['answers' => function ($q) {
         $q->with(['question' => function ($q) {
             $q->with('answerVariants');
         }]);
     }]);
     $model = $query->one();
     if ($model !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
Example #7
0
 public function getAnswerLists()
 {
     return $this->hasMany(AnswerList::className(), ['question_list_id' => 'id']);
 }
Example #8
0
<div class="answer-list-form">

    <?php 
$form = ActiveForm::begin();
?>

    <?php 
echo $form->field($model, "question_list_id")->dropDownList($questionLists, [$model->question_list_id => ['selected' => 'selected']]);
?>

    <?php 
if (!$model->isNewRecord) {
    ?>
        <?php 
    echo $form->field($model, "status")->dropDownList(AnswerList::getStatusList(), [$model->status => ['selected' => 'selected']]);
    ?>
    <?php 
}
?>
    <?php 
echo $form->field($model, "do_id")->dropDownList($DoList, [$model->question_list_id => ['selected' => 'selected']]);
?>

    <div class="form-group field-answerlist-dates">
        <?php 
echo DatePicker::widget(['name' => 'date_from', 'type' => DatePicker::TYPE_RANGE, 'name2' => 'date_to', 'form' => $form, 'model' => $model, 'attribute' => 'date_from', 'attribute2' => 'date_to', 'language' => 'ru', 'separator' => ' - ', 'pluginOptions' => ['format' => 'yyyy-mm-dd']]);
?>
    </div>

    <?php 
Example #9
0
<?php

use yii\helpers\Url;
use yii\helpers\ArrayHelper;
use app\modules\unicred\questionlist\models\Office;
use app\modules\unicred\questionlist\models\AnswerList;
use yii\helpers\Html;
return [['class' => 'kartik\\grid\\SerialColumn', 'width' => '30px'], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'questionList.title'], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'date_from'], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'date_to'], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'statusName', 'filter' => AnswerList::getStatusList()], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'officeName', 'filter' => ArrayHelper::map(Office::find()->all(), 'id', 'name')], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'date'], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'author'], ['class' => '\\kartik\\grid\\ActionColumn', 'template' => '{confirm}', 'buttons' => ['confirm' => function ($url, $model) {
    return Html::a('<span class="glyphicon glyphicon-list"></span>', Url::toRoute(['confirm', 'id' => $model->id]));
}]]];
 protected function findAnswerListModel($answer_list_id)
 {
     $model = AnswerList::findOne($answer_list_id);
     return $model;
 }
 protected function findModelAnswerList($id)
 {
     $model = AnswerList::findOne($id);
     if (!$model) {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
     if ($model->status == 'clear') {
         return $model;
     }
     $query = AnswerList::find(['id' => $id])->with(['questionList' => function ($query) {
         $query->with('questions');
     }])->joinWith(['answers' => function ($q) {
         $q->with(['question' => function ($q) {
             $q->with('answerVariants');
         }]);
     }])->where(['questionlist_answer_list.id' => $id, 'questionlist_answers.answer_list_id' => $id]);
     $model = $query->one();
     if ($model) {
         return $model;
     } else {
         throw new NotFoundHttpException('Не найдено.');
     }
 }