<?php
    require "heuristics.php";

    function getDistrictFromAddress ($address) {
        $firstComma = mb_stripos($address, ',');
        if (!$firstComma)
            return '';
        $secondComma = mb_stripos($address, ',', $firstComma + 1);
        if (!$secondComma)
            $secondComma = strlen($address);
        return substr($address, $firstComma + 1, $secondComma - $firstComma - 1);
    }
    function getStreetFromAddress ($address) {
        $firstComma = mb_stripos($address, ',');
        if (!$firstComma)
            return '';
        $secondComma = mb_stripos($address, ',', $firstComma + 1);
        if (!$secondComma)
            return '';
        return substr($address, $secondComma + 1);
    }

    function process_line ($line, $parsers) {
        $res = Array();

        $res['id_flat'] = $line['id_aid'];
        /*$res['rent_type'] = 1;
        $res['source'] = $line['source'];
        */
        $res['description'] = $line['description'];
        $res['address'] = $line['address'];
        //$res['room'] = $line['room'];*/
        $res['floor'] = $parsers['floor'] -> parse($line['description']);
        $res['floor_count'] = $parsers['floor_count'] -> parse($line['description']);
        /*$res['total_s'] = $parsers['total_s'] -> parse($line['description']);
        $res['living_s'] = $parsers['living_s'] -> parse($line['description']);
        $res['kitchen_s'] = $parsers['kitchen_s'] -> parse($line['description']);
        $res['building_type'] = $parsers['building_type'] -> parse($line['description']);
        $res['owner_name'] = $line['owner_name'];
        $res['price'] = $line['price'];
        $res['currency'] = $line['currency'];
        $res['datetime'] = $line['datetime'];
        $res['owner_phone'] = $line['owner_phone'];
        $res['city'] = 1;
        $res['status'] = $line['status'];

        $district = $parsers['district'] -> parse (getDistrictFromAddress($line['address']));
        if (!$district) $district = $parsers['district'] -> parse ($line['description']);
        $res['district'] = $district;

        $street = $parsers['street'] -> parse (getStreetFromAddress($line['address']));
        if (!$street) $street = $parsers['street'] -> parse ($line['description']);
        $res['street'] = $street;

        $res['house'] = $parsers['house'] -> parse ($line['description']);

        $metro = $parsers['metro'] -> parse ($line['address']);
        if (!$metro) $metro = $parsers['metro'] -> parse ($line['description']);
        $res['metro'] = $metro;
        */

        return $res;
    }

    include("../config.php");

    $query = "SELECT * FROM flat_inner WHERE `id_aid` >= 3572 AND `id_aid` <= 3672";
    $result = mysql_query ($query)
        or die (mysql_error());

    $new_lines = Array();
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
        array_push ($new_lines, process_line($line, $parsers));
    }

    $districtData = mysql_query("SELECT * FROM district");
    $metroData = mysql_query("SELECT * FROM metro");
    $streetData = mysql_query("SELECT * FROM street");

    $district; $metro; $street;
    while ($line = mysql_fetch_array($districtData, MYSQL_ASSOC)) {
        $district[$line['id_district']] = $line['district'];
    }
    while ($line = mysql_fetch_array($metroData, MYSQL_ASSOC)) {
        $metro[$line['id_metro']] = $line['metro'];
    }
    while ($line = mysql_fetch_array($streetData, MYSQL_ASSOC)) {
        $street[$line['id_street']] = $line['street'];
    }

    foreach ($new_lines as $new_row) {
        foreach ($new_row as $name => $value) {
            if ($name == 'metro')
                $value = $metro[$value];
            if ($name == 'district')
                $value = $district[$value];
            if ($name == 'street')
                $value = $street[$value];
            echo "$name: $value</br>";
        }
        echo "</br>";
    }
?>