<?php
require_once ".././include/initialize.php";
$q = $_GET["q"];
$result = "";
if (strlen($q) > 2) {
$sql = "SELECT * FROM Subzona WHERE Denumire LIKE '%" . $q . "%' ";
$subzonaList = Subzona::find_by_sql($sql);
if (!empty($subzonaList)) {
$i = 0;
$result = "<table width=\"200px\">";
foreach ($subzonaList as $subzona) {
$i++;
$Denumire = mysql_real_escape_string($subzona->Denumire);
$class = $i % 2 ? "impar" : "par";
$result .= "<tr id=\"SubHint{$subzona->id}\" class=\"{$class}\" onclick=subzonaHintSelect('" . str_replace(" ", "%20", $Denumire) . "','divSubzonaHint') onmouseover=\"this.style.cursor='hand';subzonaHintOnOver('SubHint{$subzona->id}',1,{$i})\" onmouseout=\"subzonaHintOnOver('SubHint{$subzona->id}',0,{$i})\"><td>{$subzona->Denumire}</td></tr>";
}
$result .= "</table>";
}
}
echo $result;
}
}
foreach ($syncList as $sync) {
if (!isset(${"Of" . $sync})) {
$oferta->{$sync} = $oferta->{$sync} > 1 ? 3 : 0;
}
}
//print_r($apartament);
//print_r($client);
// creare/actializare apartament
$sql = "SELECT * FROM Strada WHERE Denumire='" . str_replace("%20", " ", $apartament->idStrada) . "' LIMIT 1";
$stradaL = Strada::find_by_sql($sql);
$strada = array_shift($stradaL);
$apartament->idStrada = $strada->id;
$sql = "SELECT * FROM Subzona WHERE Denumire='" . str_replace("%20", " ", $apartament->idSubzona) . "' LIMIT 1";
$SubzonaL = Subzona::find_by_sql($sql);
$subzona = array_shift($SubzonaL);
$apartament->idSubzona = $subzona->id;
//$apartament->idClient=$ClientId;
$apartament->DataIntrare = convert_date($apartament->DataIntrare, 1);
//$apartament->DataActualizare=date("Y-m-d");
$apartament->save();
// actializare oferta
$oferta->idApartament = $apartament->id;
$oferta->Data = convert_date($oferta->Data, 1);
if (isset($_POST['actualizare'])) {
$oferta->DataActualizare = date("Y-m-d");
} else {
$oferta->DataActualizare = convert_date($oferta->DataActualizare, 1);
}
//$oferta->Vanzare=1;
