/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Towerdetail::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, 'Latitude' => $this->Latitude, 'Longitude' => $this->Longitude, 'Placement' => $this->Placement, 'Current' => $this->Current, 'Remain' => $this->Remain, 'Over' => $this->Over, 'TimeRecord' => $this->TimeRecord]);
$query->andFilterWhere(['like', 'TowerID', $this->TowerID])->andFilterWhere(['like', 'tower_id', $this->tower_id])->andFilterWhere(['like', 'SiteCode', $this->SiteCode])->andFilterWhere(['like', 'TowerName', $this->TowerName])->andFilterWhere(['like', 'SubDistrict', $this->SubDistrict])->andFilterWhere(['like', 'District', $this->District])->andFilterWhere(['like', 'Province', $this->Province])->andFilterWhere(['like', 'Region', $this->Region])->andFilterWhere(['like', 'TowerType', $this->TowerType])->andFilterWhere(['like', 'TowerHeight', $this->TowerHeight])->andFilterWhere(['like', 'AreaType', $this->AreaType])->andFilterWhere(['like', 'LandOwner', $this->LandOwner])->andFilterWhere(['like', 'Project', $this->Project])->andFilterWhere(['like', 'TowerOwner', $this->TowerOwner])->andFilterWhere(['like', 'SubTowerOwner', $this->SubTowerOwner])->andFilterWhere(['like', 'TowerStatus', $this->TowerStatus])->andFilterWhere(['like', 'ServiceType', $this->ServiceType])->andFilterWhere(['like', 'Remark', $this->Remark])->andFilterWhere(['like', 'UserName', $this->UserName]);
return $dataProvider;
}
/**
* Finds the Towerdetail model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param string $id
* @return Towerdetail the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Towerdetail::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
