//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->idClient = $client->id;
//$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->idAgentIntroducere = $user->id;
//$oferta->IdAgentVanzare=$user->id;
$oferta->DataActualizare = $apartament->DataIntrare;
//$oferta->Vanzare=1;
if ($oferta->Titlu == "") {
//$oferta->Titlu=ucfirst(tip_proprietate($apartament->TipProprietate));
if ($oferta->Vanzare) {
