/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Trip::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => Yii::$app->request->cookies->getValue('_grid_page_size', 20)], 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]);
$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, 'type' => $this->type, 'date' => $this->date, 'vehicle' => $this->vehicle, 'wifi' => $this->wifi, 'fridge' => $this->fridge, 'conditioner' => $this->conditioner, 'luggage' => $this->luggage, 'status' => $this->status, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
$query->andFilterWhere(['like', 'city_from', $this->city_from])->andFilterWhere(['like', 'city_to', $this->city_to])->andFilterWhere(['like', 'city_between', $this->city_between])->andFilterWhere(['like', 'schedule', $this->schedule])->andFilterWhere(['like', 'price', $this->price])->andFilterWhere(['like', 'vehicle_model', $this->vehicle_model])->andFilterWhere(['like', 'contacts', $this->contacts])->andFilterWhere(['like', 'details', $this->details]);
return $dataProvider;
}
public function getCommentsCount()
{
try {
return Comment::find()->where(['model' => Trip::className()])->andWhere(['model_id' => $this->primaryKey])->andWhere(['status' => Comment::STATUS_APPROVED])->count();
} catch (Exception $exc) {
return 0;
}
}
</div>
<div class="col-sm-6 text-right">
<?php
echo GridPageSize::widget(['pjaxId' => 'trip-grid-pjax']);
?>
</div>
</div>
<?php
Pjax::begin(['id' => 'trip-grid-pjax']);
?>
<?php
echo GridView::widget(['id' => 'trip-grid', 'dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'bulkActionOptions' => ['gridId' => 'trip-grid', 'actions' => [Url::to(['bulk-delete']) => Yii::t('yee', 'Delete')]], 'columns' => [['class' => 'yeesoft\\grid\\CheckboxColumn', 'options' => ['style' => 'width:10px']], ['attribute' => 'vehicle_model', 'class' => 'yeesoft\\grid\\columns\\TitleActionColumn', 'controller' => '/trip/default', 'title' => function (Trip $model) {
$vehicle = $model->getVehicles()[$model->vehicle] . ' > ' . Html::encode($model->vehicle_model);
return Html::a($vehicle, ['update', 'id' => $model->id], ['data-pjax' => 0]);
}, 'buttonsTemplate' => '{update} {delete}', 'options' => ['style' => 'width:260px']], 'city_from', 'city_to', ['attribute' => 'created_by', 'filter' => User::getUsersList(), 'value' => function (Trip $model) {
return Html::a(Html::encode($model->author->username), ['/user/default/update', 'id' => $model->created_by], ['data-pjax' => 0]);
}, 'format' => 'raw', 'visible' => User::hasPermission('viewUsers')], ['class' => 'yeesoft\\grid\\columns\\StatusColumn', 'attribute' => 'type', 'optionsArray' => Trip::getTypeOptionsList(), 'options' => ['style' => 'width:60px']], ['class' => 'yeesoft\\grid\\columns\\StatusColumn', 'attribute' => 'status', 'optionsArray' => Trip::getStatusOptionsList(), 'options' => ['style' => 'width:60px']]]]);
?>
<?php
Pjax::end();
?>
</div>
</div>
</div>
echo $form->field($model, 'wifi')->checkbox();
?>
<?php
echo $form->field($model, 'fridge')->checkbox();
?>
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-body">
<div class="record-info">
<?php
echo $form->field($model, 'status')->dropDownList(Trip::getStatusList());
?>
<?php
if (!$model->isNewRecord) {
?>
<div class="form-group clearfix">
<label class="control-label"
style="float: left; padding-right: 5px;"><?php
echo $model->attributeLabels()['id'];
?>
: </label>
<span><?php
echo $model->id;
?>
