public function getListCites($params)
{
// var_dump($params);die;
//select c.id as id, c.name as city, r.name as region from geobase_city as c left join geobase_region as r on r.id=c.region_id')->query();
// var_dump($params);die;
// $query=CityList::findBySql(
////// "set @g1=(select point from geobase_city where name='Казань');
////
//'select
// c.id as id,
// c.name as name,
// -- r.name as regionName,
// st_distance((select point from geobase_city where id=:id), c.point) dist
//from geobase_city as c
// left join geobase_region as r on r.id=c.region_id
//order by dist asc'.((isset($params[':lcount']))?' limit :lcount':'').';',$params);
$query = new CitySearch();
$dataProvider = $query->search(Yii::$app->request->queryParams);
// $dataProvider = new ActiveDataProvider([
// 'query' => $query,
// ]);
return $dataProvider;
// var_dump($dataProvider);die;
// foreach ($query as $row) {
// $city[$row['region']][$row['id']] = ['id'=>$row['id'],'city'=>$row['city']];
// }
// $html = '<div>';
// foreach ($city as $key => $cs) {
// $html .= '<div class="region">' . $key .'<br>';
// foreach ($cs as $c) {
//// Html::a(['options'=>['value'=>$c]]);
// $html .= Html::button($c['city'], ['class' => '', 'onclick' => "setCookies('city','" . $c['id'] . "')"]);
// }
// $html .= '</div>';
// }
// $html .= '</div>';
// $html.=(isset($params['limit']))?Html::a('Показать все','/'):'';
// return $html;
}
/**
* Lists all City models.
* @return mixed
*/
public function actionIndex()
{
$searchModel = new CitySearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
}
