/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = RoomRecord::find();
$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, 'LastSysLogID' => $this->LastSysLogID, 'LastFinLogID' => $this->LastFinLogID, 'Enabled' => $this->Enabled, 'Available' => $this->Available, 'LastSync' => $this->LastSync, 'Color' => $this->Color]);
$query->andFilterWhere(['like', 'Name', $this->Name])->andFilterWhere(['like', 'URL', $this->URL]);
return $dataProvider;
}
echo $form->field($model, 'ObjectGroupID')->textInput();
?>
<?php
echo $form->field($model, 'PersonGroupID')->textInput();
?>
<?php
echo $form->field($model, 'Coins')->textInput();
?>
<?php
echo $form->field($model, 'Safe')->textInput();
?>
<?php
echo $form->field($model, 'RoomID')->dropdownList(\common\models\cf\RoomRecord::find()->select(['Name', 'ID'])->indexBy('ID')->column());
?>
<div class="form-group">
<?php
echo Html::submitButton($model->isNewRecord ? Yii::t('app', 'Create') : Yii::t('app', 'Update'), ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
<?php
ActiveForm::end();
?>
</div>
use yii\bootstrap\ActiveForm;
use yii\helpers\Html;
use yii\grid\GridView;
/* @var $this yii\web\View */
/* @var $searchModel common\models\cf\ObjectSearch */
/* @var $dataProvider yii\data\ActiveDataProvider */
?>
<div class="well well-sm">
<?php
$form = ActiveForm::begin(['layout' => 'inline', 'enableAjaxValidation' => false, 'method' => 'get']);
?>
<?php
echo $form->field($searchModel, 'Name', ['inputOptions' => ['placeholder' => \Yii::t('app', 'Search by object\'s name')]]);
?>
<?php
echo $form->field($searchModel, 'RoomID', ['inputOptions' => ['placeholder' => \Yii::t('app', 'Search object by room\'s name')]])->dropdownList(\common\models\cf\RoomRecord::find()->select(['Name', 'ID'])->indexBy('ID')->column(), ['prompt' => 'Любой зал']);
?>
<?php
echo Html::submitButton('<span class="glyphicon glyphicon-search"></span>', ['class' => 'btn btn-default']);
?>
<?php
ActiveForm::end();
?>
</div>
<div class="object-record-index">
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'rowOptions' => function ($model, $key, $index, $grid) {
return ['class' => $model->Disabled ? 'danger' : ''];
}, 'columns' => [['class' => '\\common\\components\\DisableActionColumn'], 'Name', 'HardID', 'CoinPrice:currency', ['label' => Yii::t('app', 'Object price'), 'value' => function ($model) {
if (!empty($model->functions)) {
return $model->CoinPrice * $model->functions[0]->Price;
