/** * 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]; }