/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Drivers::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, 'drivers_title' => $this->drivers_title, 'appilcant_id' => $this->appilcant_id, 'docs' => $this->docs, 'status' => $this->status, 'blacklist_status' => $this->blacklist_status, 'create_at' => $this->create_at, 'create_by' => $this->create_by, 'update_at' => $this->update_at, 'update_by' => $this->update_by]); $query->andFilterWhere(['like', 'drivers_name', $this->drivers_name])->andFilterWhere(['like', 'drivers_lastname', $this->drivers_lastname])->andFilterWhere(['like', 'drivers_passport', $this->drivers_passport])->andFilterWhere(['like', 'drivers_licence', $this->drivers_licence])->andFilterWhere(['like', 'blacklist_date', $this->blacklist_date])->andFilterWhere(['like', 'comment', $this->comment]); return $dataProvider; }
<?php echo GridView::widget(['dataProvider' => $dataProvider, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'fullname', ['label' => 'Passport', 'value' => function ($model) { return $model->passport; }, 'options' => ['style' => 'width:60px;']], ['header' => 'ทะเบียนรถ', 'value' => function ($model) { return $model->plates_number; }, 'options' => ['style' => 'width:20px;']], ['label' => 'วดป(เข้า)', 'value' => function ($model) { //return $model->start_date; Yii::$app->formatter->locale = 'th_TH'; return Yii::$app->formatter->asDate($model->start_date, 'short'); }], ['label' => 'วดป(ออก)', 'value' => function ($model) { //return $model->start_date; return Yii::$app->formatter->asDate($model->end_date, 'medium'); }], ['header' => 'ปลายทางที่', 'value' => function ($model) { return $model->targetProvince->PRV_DESC; }], ['header' => 'คนขับ', 'format' => 'raw', 'value' => function ($data) { $count = Drivers::find()->where(['appilcant_id' => $data->id])->count(); if (!empty($count)) { return Html::a($count, ['detail', 'app_id' => $data->id], ['data-toggle' => "modal", 'data-target' => "#myModal", 'data-title' => "Detail Data"]); // ubah ini } else { return "-"; } }], ['options' => ['style' => 'width:50px;'], 'format' => 'raw', 'label' => 'วัน', 'value' => function ($model) { return $model->dateDiff(); }], ['class' => 'yii\\grid\\ActionColumn', 'options' => ['style' => 'width:150px;'], 'template' => '<div class="btn-group btn-group-sm" role="group" aria-label="...">{create-mpdf}{view}{update}{delete}</div>', 'buttons' => ['create-mpdf' => function ($url, $model, $key) { return Html::a('<i class="fa fa-print"></i>', $url, ['class' => 'btn btn-default', 'target' => 'blank']); }, 'view' => function ($url, $model, $key) { return Html::a('<i class="glyphicon glyphicon-eye-open"></i>', $url, ['class' => 'btn btn-default']); }, 'update' => function ($url, $model, $key) { return Html::a('<i class="glyphicon glyphicon-pencil"></i>', $url, ['class' => 'btn btn-default']); }, 'delete' => function ($url, $model, $key) {
private function removeUploadDirDriver($dir) { BaseFileHelper::removeDirectory(Drivers::getUploadPath() . $dir); }