<?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;