/**
* @param integer $region_id
* @param string $city_name
* @throws Exception
* @return static
*/
public static function upsert($attributes)
{
if (isset(self::$_models[$attributes['city_id']])) {
return self::$_models[$attributes['city_id']];
} else {
$model = City::findOne($attributes['city_id']);
if (!$model) {
$model = new City();
}
$model->setAttributes($attributes);
$model->save(false);
return self::$_models[$attributes['city_id']] = $model;
}
}
public function actionIndex()
{
$temp = new Temporary('geoip');
$zipArchive = $temp->file();
file_put_contents($zipArchive, fopen('http://ipgeobase.ru/files/db/Main/geo_files.zip', 'r'));
if (file_exists($zipArchive)) {
$tran = \Yii::$app->db->beginTransaction();
// Rewrite all
Range::deleteAll();
City::deleteAll();
if (($handle = fopen('zip://' . $zipArchive . '#cities.txt', "r")) !== FALSE) {
stream_filter_append($handle, 'convert.iconv.Windows-1251/UTF-8');
while (($data = fgetcsv($handle, 4096, "\t")) !== FALSE) {
$district = District::getsert($data[3]);
$region = Region::getsert($district->district_id, $data[2]);
$city = City::upsert(['city_id' => $data[0], 'city_name' => $data[1], 'region_id' => $region->region_id, 'lat' => $data[4], 'lng' => $data[5]]);
}
fclose($handle);
}
if (($handle = fopen('zip://' . $zipArchive . '#cidr_optim.txt', "r")) !== FALSE) {
stream_filter_append($handle, 'convert.iconv.Windows-1251/UTF-8');
$rows = [];
$time = time();
while (($data = fgetcsv($handle, 4096, "\t")) !== FALSE) {
$rows[] = ['ip_start' => $data[0], 'ip_end' => $data[1], 'ip_range' => $data[2] == '-' ? null : $data[2], 'ip_country' => $data[3], 'city_id' => $data[4] == '-' ? null : $data[4], 'created_at' => $time, 'updated_at' => $time];
if (count($rows) == 1000) {
Range::batchInsert($rows);
$rows = [];
}
}
if (count($rows) > 0) {
Range::batchInsert($rows);
}
fclose($handle);
}
$tran->commit();
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getCities()
{
return $this->hasMany(City::className(), ['region_id' => 'region_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getCity()
{
return $this->hasOne(City::className(), ['city_id' => 'city_id']);
}
