FM / tools

/var/www/myprog.com.ua/site/tools/

/var/www/myprog.com.ua/site/tools

Name	Size	Mode	Actions
call.html	5314	0644	edit dl rm
clear_adres.php	1958	0644	edit dl rm
create_adres_alias.php	1702	0644	edit dl rm
create_house_alias.php	1906	0644	edit dl rm
del_adr.php	1005	0644	edit dl rm
house.php	4517	0644	edit dl rm
kiev.php	2248	0644	edit dl rm
node_driver_test.html	12666	0644	edit dl rm
oconverter.php	6230	0644	edit dl rm
simple_html_dom.php	63317	0644	edit dl rm
street.php	10426	0644	edit dl rm
update_perm.php	6984	0644	edit dl rm

Edit: /var/www/myprog.com.ua/site/tools/street.php (10426B)

<?php
header('Content-Type: text/html; charset=utf-8');
require_once('../include/config.php');
require_once('../include/func.php');
ignore_user_abort(1);
set_time_limit(0);
mb_internal_encoding("UTF-8");

if ($_FILES['txt_file']['error'] === 0 && is_numeric($_POST['city_id'])) {
    $key = '2fe566ef07c6ab7526b153d161a30ce3';

// получить имя и ИД города, страны
    $sql = "SELECT `c`.`id_city`,  `c`.`id_country`, `c`.`city_name_ru`, `k`.`country_name_ru`
            FROM `city_` `c`
            LEFT JOIN `country_` `k` on `k`.`id_country`=`c`.`id_country`
            WHERE `c`.`id_city`='{$_POST['city_id']}'
            LIMIT 1";

$result = db_fetch(db_query($sql), MYSQL_ASSOC);

if (mysql_errno() == 0 && isset($result[0]['city_name_ru']) && isset($result[0]['country_name_ru'])) {
        // имя города и станы
        $city = mb_strtolower(trim($result[0]['city_name_ru']));
        //$city = strtolower(trim($result[0]['city_name_ru']));
        $country = mb_strtolower(trim($result[0]['country_name_ru']));
        //$country = strtolower(trim($result[0]['country_name_ru']));

// прочитать список улиц из файла
        $fr = fopen($_FILES['txt_file']['tmp_name'], "r");
        while (!feof($fr)) {
            $streets[] = fgets($fr, 4096);
        }
        fclose($fr);
    }
//var_dump($_POST['city_id']);
//var_dump($streets);
//var_dump($country);

foreach ($streets as $s) {

$s = str_replace("\r", '', $s);
        $s = str_replace("\n", '', $s);
        $s = str_replace(" Ул.", '', $s);
        $s = str_replace(" Пер.", '', $s);
        $s = str_replace(".", '', $s);
        $s = mb_strtolower($s);
        //$s = strtolower($s);

//var_dump($s);
        // поиск в локальной базе
        $sql = "SELECT count(`ah`.`id`) as `count`
                FROM `adres_list` `al`
                LEFT JOIN `adres_houses` `ah` ON `ah`.`adres_id`=`al`.`aid`
                WHERE `al`.`city_id`='{$_POST['city_id']}'
                AND `al`.`adres` LIKE '$s%'";
        $result = db_fetch(db_query($sql), MYSQL_ASSOC);
        //var_dump($result);

// если нет улицы с домами
        if ($result[0]['count'] == 0) {

if (isset($_POST['yandex'])) {
                // Поиск улицы яндекс

// параметры запроса
                $key = "ABtQB1kBAAAA2TX5UAMA4487UD7VU23-1UOwDPgyb_6fz6MAAAAAAAAAAACS9hbLsh9_45c3ImWl7WwjWt-Q4A==";
                $params = array(
                    'geocode' => $country . ', ' . $city.' '.$s,                              // адрес
                    'format' => 'json',                          // формат ответа
                    'results' => 1,                               // количество выводимых результатов
                    //'key'     => $key,                           // ваш api key
                );
                var_dump($params);

// запрос яндексу
                $response = json_decode(file_get_contents('http://geocode-maps.yandex.ru/1.x/?' . http_build_query($params, '', '&')));
                //var_dump($response);

// если пришел ответ
                if ($response->response->GeoObjectCollection->metaDataProperty->GeocoderResponseMetaData->found > 0) {
                    $pos = explode(' ', $response->response->GeoObjectCollection->featureMember[0]->GeoObject->Point->pos);
                    // взять координаты
                    $result_y['la'] = $pos[1];
                    $result_y['lo'] = $pos[0];
                    //var_dump($response->response->GeoObjectCollection->featureMember[0]->GeoObject->metaDataProperty->GeocoderMetaData->Address->Components);
                    $result_y['name'] = $response->response->GeoObjectCollection->featureMember[0]->GeoObject->name;
                } else {
                    echo 'yandex not found --> ' . $q.'<br>';
                }
                //var_dump($result);

if (isset($result_y)) {
                    // добавить улицу
                    //var_dump($street);
                    $name = $street->properties->name . " " . $street->properties->type;
                    $sql = "INSERT INTO `adres_list` (`adres`, `object_id`, `city_id`, `la`, `lo`, `confirmed`) 
                                        VALUES ('{$s}', '0', '{$_POST['city_id']}', '{$result_y['la']}', '{$result_y['lo']}', '0')";

db_query($sql);
                    if (mysql_errno() == 0) {
                        echo 'Insert ok    --> ' . $name.'<br>';
                    } else {
                        echo 'insert error --> ' . $name.'<br>';
                    }

}
            } else {
                    // поиск улицы Visicom
                    $u_country = urlencode($country);
                    $u_street = urlencode(trim($s));
                    $u_city = urlencode($city);
                    $url = "http://api.visicom.ua/data-api/2.0/ru/search/adr_street.json?text=$u_country%20,$u_city,%20$u_street&key=$key";

var_dump($url);
                    if ($curl = curl_init()) {
                        curl_setopt($curl, CURLOPT_URL, $url);
                        curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
                        $result = curl_exec($curl);
                        //var_dump($result);
                        curl_close($curl);
                        if ($result) {
                            $street = json_decode($result);
                            //var_dump($street);

if (isset($street->url) &&
                                mb_strtolower($street->properties->country) == $country &&
                                //strtolower($street->properties->country) == $country &&
                                mb_strtolower($street->properties->settlement) == $city
                                //strtolower($street->properties->settlement) == $city
                            ) {
                                //var_dump($street);

// поиск домов
                                $url = $street->url . "?key=$key";
                                //var_dump($url);
                                if ($curl = curl_init()) {
                                    curl_setopt($curl, CURLOPT_URL, $url);
                                    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
                                    $result = curl_exec($curl);
                                    if ($result) {
                                        $street = json_decode($result);
                                        if (isset($street->url) &&
                                            mb_strtolower($street->properties->country) == $country &&
                                            //strtolower($street->properties->country) == $country &&
                                            mb_strtolower($street->properties->settlement) == $city
                                            //strtolower($street->properties->settlement) == $city
                                        ) {

// добавить улицу
                                            //var_dump($street);
                                            $name = $street->properties->name . " " . $street->properties->type;
                                            $sql = "INSERT INTO `adres_list` (`adres`, `object_id`, `city_id`, `la`, `lo`, `confirmed`) 
                                        VALUES ('$name', '0', '{$_POST['city_id']}', '{$street->geo_centroid->coordinates[1]}', '{$street->geo_centroid->coordinates[0]}', '0')";

db_query($sql);
                                            $adr_id = mysql_insert_id();
                                            if ($adr_id > 0) {
                                                // добавить дома
                                                foreach ($street->properties->address as $a) {
                                                    //var_dump($a->name);
                                                    $adr_name = strtolower($a->name);
                                                    $sql = "INSERT INTO `adres_houses` (`adres_id`, `name`, `la`, `lo`, `confirmed`) 
                                            VALUES ('$adr_id', '$adr_name', '{$street->geo_centroid->coordinates[1]}', '{$street->geo_centroid->coordinates[0]}', '0')";
                                                    //var_dump($sql);
                                                    $r = db_query($sql);
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            sleep(1);
        }
    }
}
if (!isset($_POST['yandex']) && isset($_POST['get_houses'])) {
    include 'house.php';
}
?>
<h2>Импорт улиц из файла</h2>

<form enctype="multipart/form-data" action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST">
    <div class="label">ИД города:</div>
    <input type="text" name="city_id" autofocus/><br>
    
    <input type="hidden" name="MAX_FILE_SIZE" value="1677216"/>
    
    <div class="label">Файл:</div>
    <input name="txt_file" type="file"/><br>
    <div class="label">Поиск домов ?</div>
    <input name="get_houses" type="checkbox">
    <br>
    <div class="label">Искачть через Yandex</div>
    <input name="yandex" type="checkbox">
    <br>
    <input type="submit" value="Начать"/>
    <p>Формат <b>txt</b>, кодировка <b>UTF-8</b>, размер файла < 16 Mb</p>
</form>
<style>
    .label {
        float: left;
        width: 150px;
    }
</style>

$country . ', ' . $city.' '.$s, // адрес 'format' => 'json', // формат ответа 'results' => 1, // количество выводимых результатов //'key' => $key, // ваш api key ); var_dump($params); // запрос яндексу $response = json_decode(file_get_contents('http://geocode-maps.yandex.ru/1.x/?' . http_build_query($params, '', '&'))); //var_dump($response); // если пришел ответ if ($response->response->GeoObjectCollection->metaDataProperty->GeocoderResponseMetaData->found > 0) { $pos = explode(' ', $response->response->GeoObjectCollection->featureMember[0]->GeoObject->Point->pos); // взять координаты $result_y['la'] = $pos[1]; $result_y['lo'] = $pos[0]; //var_dump($response->response->GeoObjectCollection->featureMember[0]->GeoObject->metaDataProperty->GeocoderMetaData->Address->Components); $result_y['name'] = $response->response->GeoObjectCollection->featureMember[0]->GeoObject->name; } else { echo 'yandex not found --> ' . $q.'
'; } //var_dump($result); if (isset($result_y)) { // добавить улицу //var_dump($street); $name = $street->properties->name . " " . $street->properties->type; $sql = "INSERT INTO `adres_list` (`adres`, `object_id`, `city_id`, `la`, `lo`, `confirmed`) VALUES ('{$s}', '0', '{$_POST['city_id']}', '{$result_y['la']}', '{$result_y['lo']}', '0')"; db_query($sql); if (mysql_errno() == 0) { echo 'Insert ok --> ' . $name.'
'; } else { echo 'insert error --> ' . $name.'
'; } } } else { // поиск улицы Visicom $u_country = urlencode($country); $u_street = urlencode(trim($s)); $u_city = urlencode($city); $url = "http://api.visicom.ua/data-api/2.0/ru/search/adr_street.json?text=$u_country%20,$u_city,%20$u_street&key=$key"; var_dump($url); if ($curl = curl_init()) { curl_setopt($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); $result = curl_exec($curl); //var_dump($result); curl_close($curl); if ($result) { $street = json_decode($result); //var_dump($street); if (isset($street->url) && mb_strtolower($street->properties->country) == $country && //strtolower($street->properties->country) == $country && mb_strtolower($street->properties->settlement) == $city //strtolower($street->properties->settlement) == $city ) { //var_dump($street); // поиск домов $url = $street->url . "?key=$key"; //var_dump($url); if ($curl = curl_init()) { curl_setopt($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); $result = curl_exec($curl); if ($result) { $street = json_decode($result); if (isset($street->url) && mb_strtolower($street->properties->country) == $country && //strtolower($street->properties->country) == $country && mb_strtolower($street->properties->settlement) == $city //strtolower($street->properties->settlement) == $city ) { // добавить улицу //var_dump($street); $name = $street->properties->name . " " . $street->properties->type; $sql = "INSERT INTO `adres_list` (`adres`, `object_id`, `city_id`, `la`, `lo`, `confirmed`) VALUES ('$name', '0', '{$_POST['city_id']}', '{$street->geo_centroid->coordinates[1]}', '{$street->geo_centroid->coordinates[0]}', '0')"; db_query($sql); $adr_id = mysql_insert_id(); if ($adr_id > 0) { // добавить дома foreach ($street->properties->address as $a) { //var_dump($a->name); $adr_name = strtolower($a->name); $sql = "INSERT INTO `adres_houses` (`adres_id`, `name`, `la`, `lo`, `confirmed`) VALUES ('$adr_id', '$adr_name', '{$street->geo_centroid->coordinates[1]}', '{$street->geo_centroid->coordinates[0]}', '0')"; //var_dump($sql); $r = db_query($sql); } } } } } } } } } sleep(1); } } } if (!isset($_POST['yandex']) && isset($_POST['get_houses'])) { include 'house.php'; } ?>