/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Cities::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['idcities' => $this->idcities, 'idstates' => $this->idstates]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'longitude', $this->longitude])->andFilterWhere(['like', 'latitude', $this->latitude])->andFilterWhere(['like', 'wikilink', $this->wikilink]);
return $dataProvider;
}
public function actionIndex()
{
// return "ok";
$params = yii::$app->getRequest()->getQueryParams();
if (empty($params['province_id']) && empty($params['province_id'])) {
$query = Provinces::find();
}
if (!empty($params['province_id'])) {
$query = Cities::find()->where(['province_id' => $params['province_id']]);
}
if (!empty($params['city_id'])) {
$query = Districts::find()->where(['city_id' => $params['city_id']]);
}
return new yii\data\ActiveDataProvider(['query' => $query, 'pagination' => array('pageSize' => 50)]);
}
public function actionCity()
{
$stateId = $_POST['state_id'];
$citydata = \common\models\Cities::find()->where(['stateID' => $stateId])->orderBy(['name' => SORT_ASC])->all();
//return "asdasd";
//$citydata = CHtml::listData($citydata, 'id', 'name');
$citylist = "<option value=''>Select City</option>";
if (count($citydata) > 0) {
foreach ($citydata as $city) {
$citylist .= "<option value='" . $city->id . "'>" . $city->name . "</option>";
}
} else {
$citylist = "<option>-</option>";
}
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['citylist' => $citylist, 'code' => 100];
}
