/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$this->load($params);
$query = Location::find();
$query->select(['*', 'uid' => 'location.uid', 'name' => 'city_translation.name', 'language' => 'city.language_id']);
$query->innerJoin('city', 'location.city_id=city.id');
$query->leftJoin('city_translation', 'city_translation.city_id=city.id');
//$query->andWhere(['city.language_id' => 'city_translation.language_id']);
// $query->joinWith('city');
// $query->joinWith('city.localisedIdentification');
if (isset($this->uid)) {
$this->pageSize = 1;
}
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => $this->pagination ? ['pageSize' => $this->pageSize] : FALSE, 'sort' => ['attributes' => ['name', 'postcode', 'language']]]);
if (isset($this->uid)) {
// uncomment the following line if you do not want to return any records when validation fails
$query->where(['location.uid' => $this->uid]);
return $dataProvider;
}
if (!$this->validate() || !isset($this->country_id)) {
// uncomment the following line if you do not want to return any records when validation fails
$query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['country_id' => $this->country_id]);
$query->andFilterWhere(['NOT IN', 'postcode', ['-1', '0']]);
$query->andFilterWhere(['or', ['like', 'postcode', $this->q], ['like', 'city_translation.name', $this->q]]);
return $dataProvider;
}
public static function findRemote($uid)
{
$model = self::findOne(['uid' => $uid]);
if (!isset($model)) {
$model = new Location(['uid' => $uid]);
$model->download();
}
return $model;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getLocations()
{
return $this->hasMany(Location::className(), ['country_id' => 'iso_2']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getLocation()
{
return $this->hasOne(Location::className(), ['id' => 'location_id']);
}
/**
* Finds the Location model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Location the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Location::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getLocations()
{
return $this->hasMany(Location::className(), ['city_id' => 'id']);
}
private function _dummyLocation($countryId, $name, $postCode)
{
//CityTranslation::find()->where(['language_id' => 'EN', 'name' => $name])->queryScalar();
$dummyCity = new \humanized\location\models\location\City(['language_id' => 'EN']);
try {
$dummyCity->save();
try {
$dummyCityTranslation = new \humanized\location\models\translation\CityTranslation(['language_id' => 'EN', 'city_id' => $dummyCity->id, 'name' => $name]);
$dummyCityTranslation->save();
try {
$dummyLocation = new \humanized\location\models\location\Location(['postcode' => $postCode, 'city_id' => $dummyCity->id, 'country_id' => $countryId]);
$dummyLocation->save();
} catch (Exception $ex) {
}
} catch (Exception $ex) {
}
} catch (\Exception $ex) {
}
}
public function actionMatchNuts()
{
Location::find()->all();
}