/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = DeviceType::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['title' => SORT_ASC]]]); $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, 'comp' => $this->comp]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'synonyms', $this->synonyms]); return $dataProvider; }
if ($id_wp > 0) { $model->workplace_id = $id_wp; } ?> <?php echo $form->field($model, 'workplace_id')->dropDownList(ArrayHelper::map(Workplaces::find()->all(), 'id', function ($model_wp) { $snp = ''; if ($model_wp->owner) { $snp = $model_wp->owner[0]['snp']; } return '"' . $model_wp->workplaces_title . '" ' . $snp; }), ['prompt' => 'Выберите рабочее место...']); ?> <?php echo $form->field($model, 'type_id')->dropDownList(ArrayHelper::map(DeviceType::find()->orderBy('title')->all(), 'id', 'title'), ['prompt' => 'Выберите тип устройства...']); ?> <?php echo $form->field($model, 'brand')->textInput(['maxlength' => true])->widget(AutoComplete::className(), ['clientOptions' => ['source' => $model::arrayBrands()], 'options' => ['class' => 'form-control']]); ?> <?php echo $form->field($model, 'model')->textInput(['maxlength' => true])->widget(AutoComplete::className(), ['clientOptions' => ['source' => $model::arrayModels()], 'options' => ['class' => 'form-control']]); ?> <?php echo $form->field($model, 'sn')->textInput(['maxlength' => true])->widget(AutoComplete::className(), ['clientOptions' => ['source' => $model::arraySns()], 'options' => ['class' => 'form-control']]); ?> <?php echo $form->field($model, 'imei1')->textInput(['maxlength' => true])->widget(AutoComplete::className(), ['clientOptions' => ['source' => $model::arrayImei1()], 'options' => ['class' => 'form-control']]); ?>
<?php echo Html::a('Добавить устройство', ['create', 'param' => $query], ['class' => 'btn btn-success']); ?> <?php echo Html::a('Комплектующие автоматом', ['autocomp'], ['class' => 'btn btn-success', 'data' => ['confirm' => "Произвести автоматическую установку комплектуюдщих \r\n для одиноких системников?"]]); ?> <?php echo Html::a(Html::img('/admin/img/search.png', ['width' => '16px']) . 'Общий склад', ['index?' . $query . '&DevicesSearch%5Bworkplace_id%5D=1'], ['class' => 'btn btn-default']); ?> <?php echo Html::a(Html::img('/admin/img/cross.png', ['style' => 'height: 14px; margin: 0px 1px 3px 0px;']) . ' Сбросить фильтр', ['index?' . $query], ['class' => 'btn btn-default', 'style' => 'float:right;']); ?> </p> <?php $cols = ['id', ['attribute' => 'dt_title', 'filter' => ArrayHelper::map(DeviceType::find()->all(), 'title', 'title')], ['attribute' => 'dev_comp', 'value' => function ($model) { return $model->dev_comp ? 'Да' : 'Нет'; }, 'filter' => ['Нет', 'Да']], 'brand', 'model', 'sn', 'specification', 'imei1', ['attribute' => 'parent_device_id', 'value' => function ($model) { return Html::a($model->parent_device_id, ['devices/view', 'id' => $model->parent_device_id]); }, 'format' => 'raw'], 'device_note', ['class' => Column::className(), 'content' => function ($model) use($mode) { //if ($model->workplace) { //if($model->employee) $snp = $model->employee->snp; if ($model->workplace_id == 1 || $model->workplace_id == null) { return ''; } if ($mode != 'def') { return Html::img('/admin/img/man.png', ['style' => 'height:24px;', 'title' => $model->workplace_id . ' ' . $model->wp_title]); } else { if ($mode == 'def') { return Html::a(Html::img('/admin/img/man.png', ['style' => 'height:24px;']), ['workplaces/view', 'id' => $model->workplace_id], ['title' => $model->workplace_id . ' ' . $model->wp_title . "\n" . $model->snp]); }