| Server IP : 14.207.165.8 / Your IP : 216.73.216.26 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/ppaobm/backend/modules/booking_data/models/ |
Upload File : |
<?php
namespace backend\modules\booking_data\models;
use yii\base\Model;
use yii\data\ActiveDataProvider;
use backend\modules\booking_data\models\BookingData;
/**
* BookingDataSearch represents the model behind the search form of `backend\modules\booking_data\models\BookingData`.
*/
class BookingDataSearch extends BookingData
{
/**
* {@inheritdoc}
*/
public function rules()
{
return [
[['id', 'department_type_id', 'location_center_id', 'location_room_id', 'num_user', 'cost', 'status', 'user_id'], 'integer'],
[['dateon', 'datein', 'name', 'pin', 'department_name', 'tel', 'picture', 'title', 'comment', 'cancel', 'waivefees', 'file', 'created_at', 'updated_at'], 'safe'],
];
}
/**
* {@inheritdoc}
*/
public function scenarios()
{
// bypass scenarios() implementation in the parent class
return Model::scenarios();
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = BookingData::find();
// add conditions that should always apply here
$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;
}
// grid filtering conditions
$query->andFilterWhere([
'id' => $this->id,
// 'dateon' => $this->dateon,
// 'datein' => $this->datein,
'department_type_id' => $this->department_type_id,
'location_center_id' => $this->location_center_id,
'location_room_id' => $this->location_room_id,
'title' => $this->title,
'num_user' => $this->num_user,
'cost' => $this->cost,
'status' => $this->status,
'created_at' => $this->created_at,
'updated_at' => $this->updated_at,
'user_id' => $this->user_id,
]);
$query->andFilterWhere(['like', 'name', $this->name])
->andFilterWhere(['like', 'dateon', $this->dateon])
->andFilterWhere(['like', 'datein', $this->datein])
->andFilterWhere(['like', 'pin', $this->pin])
->andFilterWhere(['like', 'department_name', $this->department_name])
->andFilterWhere(['like', 'title', $this->title])
->andFilterWhere(['like', 'tel', $this->tel])
->andFilterWhere(['like', 'picture', $this->picture])
->andFilterWhere(['like', 'comment', $this->comment])
->andFilterWhere(['like', 'cancel', $this->cancel])
->andFilterWhere(['like', 'waivefees', $this->waivefees])
->andFilterWhere(['like', 'filename', $this->filename]);
return $dataProvider;
}
}