function scrieDotari($categorie, $idApartament) { $ret = ""; $sql = "SELECT * FROM CategorieDotari WHERE TipProprietate=1 AND Descriere='{$categorie}'"; $CatDotList = CategorieDotari::find_by_sql($sql); if (!empty($CatDotList)) { $CatDot = array_shift($CatDotList); $sql = "SELECT * FROM Dotare WHERE idCategorieDotari='{$CatDot->id}'"; $DotList = Dotare::find_by_sql($sql); if (!empty($DotList)) { foreach ($DotList as $Dot) { $sql = "SELECT * FROM DotareApartament WHERE idDotare='{$Dot->id}' AND idApartament='{$idApartament}'"; $DotApList = Dotareapartament::find_by_sql($sql); if (!empty($DotApList)) { $ret .= ", " . $Dot->Descriere; } } } } return $ret; }
//$idProprietate=mysql_insert_id($conexiune2); } else { $tu1 = time(); $attribute_pairs = array(); foreach ($proprietate as $key => $value) { $attribute_pairs[] = "{$key}='{$value}'"; } $sql_upd_proprietate = "UPDATE Proprietate SET " . join(", ", $attribute_pairs) . " WHERE id=" . $idProprietate; $result = execute_querry($sql_upd_proprietate, $conexiune2); $tu = $tu + (time() - $tu1); } $oferta->Exportat = 1; $oferta->save(); // sincronizare dotari $sql = "SELECT * FROM DotareApartament WHERE idApartament='{$apartament->id}'"; $dotariApartament = Dotareapartament::find_by_sql($sql); if (!empty($dotariApartament)) { foreach ($dotariApartament as $dotareApartament) { $da["idApartament"] = $oferta->id; $da["idDotare"] = $dotareApartament->idDotare; $sql_dotare .= "('" . join("', '", array_values($da)) . "'),"; } } //sincronizare poze $sql = "SELECT * FROM Foto WHERE idApartament='{$apartament->id}'"; $fotografii = Foto::find_by_sql($sql); if (!empty($fotografii)) { foreach ($fotografii as $foto) { $f["idProprietate"] = $oferta->id; $f["NumeFisier"] = $foto->NumeFisier; $f["Tip"] = $foto->Tip;
$sql = "SELECT * FROM Strada WHERE Denumire='" . str_replace("%20", " ", $client->idStrada) . "' LIMIT 1"; //print_r($_POST); $stradaLc = Strada::find_by_sql($sql); $strada = array_shift($stradaLc); $client->idStrada = $strada->id; $client->save(); $sql = "SELECT * FROM DotareApartament WHERE idApartament='{$apartament->id}'"; $DAList = Dotareapartament::find_by_sql($sql); if (!empty($DAList)) { foreach ($DAList as $dotAP) { $dotAP->delete(); } } if (!empty($dotariList)) { foreach ($dotariList as $dotare) { $dotAp = new Dotareapartament(); $dotAp->idApartament = $apartament->id; $dotAp->idDotare = $dotare; $dotAp->save(); } } redirect_to("oferta_view.php?id=" . $oferta->id); } else { $xOfertaId = $_GET['id']; $oferta = Oferta::find_by_id($xOfertaId); $apartament = Apartament::find_by_id($oferta->idApartament); $client = Client::find_by_id($apartament->idClient); $agent = User::find_by_id($client->idUtilizator); $agentIntroducere = User::find_by_id($oferta->idAgentIntroducere); $agentVizionare = User::find_by_id($oferta->idAgentInchiriere); $agentLucreaza = User::find_by_id($oferta->IdAgentVanzare);
$cartier = Cartier::find_by_id($subzona->idCartier); $oras = Zona::find_by_id($cartier->idZona); $sursa = Sursa::find_by_id($apartament->idSursa); $agentIntroducere = User::find_by_id($oferta->idAgentIntroducere); $agentInchiriere = User::find_by_id($oferta->idAgentInchiriere); $agentVanzare = User::find_by_id($oferta->IdAgentVanzare); $sql = "SELECT * FROM CategorieDotari WHERE TipProprietate=1 ORDER BY Prioritate"; $CatDotList = CategorieDotari::find_by_sql($sql); if (!empty($CatDotList)) { foreach ($CatDotList as $CatDot) { $sql = "SELECT * FROM Dotare WHERE idCategorieDotari='{$CatDot->id}'"; $DotList = Dotare::find_by_sql($sql); if (!empty($DotList)) { foreach ($DotList as $Dot) { $sql = "SELECT * FROM DotareApartament WHERE idDotare='{$Dot->id}' AND idApartament='{$apartament->id}'"; $DotApList = Dotareapartament::find_by_sql($sql); if (!empty($DotApList)) { foreach ($DotApList as $DotAp) { if (!isset($dotString[$CatDot->id])) { $dotCat[$CatDot->id] = $CatDot->Descriere; $dotString[$CatDot->id] = $Dot->Descriere; } else { $dotString[$CatDot->id] .= ", " . $Dot->Descriere; } } } } } } } $sql = "SELECT * FROM Foto WHERE idApartament={$apartament->id} ORDER BY Ordin";
function sync_Oferta($id) { global $conexiune2; global $ftp_conn; $ftp_conn = ftp_connect(FTP_SERVER) or die("Could not connect to ftp location"); $login_result = ftp_login($ftp_conn, FTP_USER, FTP_PASSWORD); $oferta_fields = array("id", "idApartament", "IdAgentVanzare", "idAgentInchiriere", "Pret", "Moneda", "Negociabil", "DataActualizare", "OfertaSpeciala", "Exclusivitate", "Vanzare", "Stare", "ComisionClient", "ComisionCumparatorZero", "Inchiriere", "PretChirie", "Titlu"); $apartament_fields = array("id", "DataIntrare", "TipProprietate", "NumarCamere", "Confort", "TipApartament", "Duplex", "Etaj", "EtajeBloc", "TipConstructie", "Subsol", "Demisol", "Parter", "Etaje", "Mansarda", "Pod", "Oras", "Zona", "Subzona", "AnConstructie", "AnRenovare", "NrGrupuriSanitare", "Detalii", "SuprafataUtila", "SuprafataConstruita", "SuprafataTerasa", "SuprafataEtaj1", "SuprafataEtaj2", "SuprafataEtaj3", "SuprafataCurte", "AmprentaSol", "Deschidere", "NumarDeschideri", "TipCurte", "TipIntrare", "NumarBalcoane", "NumarBucatarii", "NumarTerase", "NumarParcari", "NumarGaraje", "ProiectNefinalizat", "Lat", "Lng", "LatimeDrumAcces", "POT", "CUT", "Inclinatie", "ConstructiePeTeren", "Destinatie", "TipTeren", "Clasificare", "Localizare", "TipSpatiu", "Inaltime", "Vitrina", "ClasaBirouri", "youtube"); $oferta = Oferta::find_by_id($id); $apartament = Apartament::find_by_id($id); // sincronizare dotari sync_CategorieDotari(); sync_Dotari(); //echo $oferta->OfertaWeb; if ($oferta->OfertaWeb == 2 || $oferta->OfertaWeb == 3) { $sql = "SELECT NumeFisier FROM fes_Foto WHERE idApartament='{$apartament->id}'"; $result = execute_querry($sql, $conexiune2); while ($row = mysql_fetch_array($result)) { ftp_delete($ftp_conn, NEW_FTP_PATH . DS . $row[0]); } $sql = "DELETE FROM fes_Apartament WHERE id='{$apartament->id}'"; $result = execute_querry($sql, $conexiune2); $sql = "DELETE FROM fes_Oferta WHERE id='{$oferta->id}'"; $result = execute_querry($sql, $conexiune2); $sql = "DELETE FROM fes_DotareApartament WHERE idApartament='{$apartament->id}'"; $result = execute_querry($sql, $conexiune2); $sql = "DELETE FROM fes_Foto WHERE idApartament='{$apartament->id}'"; $result = execute_querry($sql, $conexiune2); if ($oferta->OfertaWeb == 3) { $oferta->OfertaWeb = 0; $oferta->save(); return; } } $subzona = Subzona::find_by_id($apartament->idSubzona); $cartier = Cartier::find_by_id($subzona->idCartier); $oras = Zona::find_by_id($cartier->idZona); foreach ($oferta_fields as $field) { switch ($field) { case "Stare": $site_oferta[] = site_stare($oferta->Stare); break; default: $site_oferta[] = $oferta->{$field}; break; } } foreach ($apartament_fields as $field) { switch ($field) { case "Oras": $site_apartament[] = $oras->Denumire; break; case "Zona": $site_apartament[] = $cartier->Denumire; break; case "Subzona": $site_apartament[] = $subzona->Denumire; break; default: $site_apartament[] = $apartament->{$field}; break; } } $sql_oferta = "INSERT INTO fes_Oferta "; $sql_oferta .= "(" . join(",", array_values($oferta_fields)) . ")"; $sql_oferta .= " VALUES ('" . join("','", array_values($site_oferta)) . "')"; $sql_apartament = "INSERT INTO fes_Apartament "; $sql_apartament .= "(" . join(",", array_values($apartament_fields)) . ")"; $sql_apartament .= " VALUES ('" . join("','", array_values($site_apartament)) . "')"; $result = execute_querry($sql_apartament, $conexiune2); $result = execute_querry($sql_oferta, $conexiune2); // sincronizare dotari $sql = "SELECT * FROM DotareApartament WHERE idApartament='{$apartament->id}'"; $dotariApartament = Dotareapartament::find_by_sql($sql); if (!empty($dotariApartament)) { $sql_dotare = "INSERT INTO fes_DotareApartament (idApartament,idDotare) VALUES "; foreach ($dotariApartament as $dotareApartament) { $da["idApartament"] = $oferta->id; $da["idDotare"] = $dotareApartament->idDotare; $sql_dotare .= "('" . join("', '", array_values($da)) . "'),"; } $sql_dotare = substr($sql_dotare, 0, strlen($sql_dotare) - 1); $result = execute_querry($sql_dotare, $conexiune2); } //sincronizare poze if ($oferta->Vanzare) { if ($oferta->Inchiriere) { $pozaPrefix = "Vanzare-Inchiriere-"; } else { $pozaPrefix = "Vanzare-"; } } else { $pozaPrefix = "Inchiriere-"; } if ($apartament->TipProprietate < 2) { $pozaPrefix .= $apartament->NumarCamere > 1 ? ucfirst(tip_proprietate($apartament->TipProprietate)) . " " . $apartament->NumarCamere . " camere " : "Garsoniera "; } else { if ($apartament->TipProprietate == 2) { $pozaPrefix .= ($apartament->Etaje < 1 ? "Casa " : "Vila ") . $apartament->NumarCamere . " camere "; } else { $pozaPrefix .= ucfirst(tip_proprietate($apartament->TipProprietate)) . " "; if ($apartament->TipProprietate == 4) { $pozaPrefix .= $apartament->TipSpatiu . " "; } } } $zona = Zona::find_by_id($cartier->idZona); $pozaPrefix .= $zona->Denumire . "-" . $cartier->Denumire . "-" . $subzona->Denumire; $sql = "SELECT * FROM Foto WHERE idApartament='{$apartament->id}'"; $fotografii = Foto::find_by_sql($sql); if (!empty($fotografii)) { $sql_foto = "INSERT INTO fes_Foto (idApartament, NumeFisier, Detalii, Ordin, Schita) VALUES "; foreach ($fotografii as $foto) { $f["idProprietate"] = $oferta->id; $f["NumeFisier"] = str_replace(" ", "-", $pozaPrefix) . "-" . $foto->NumeFisier; $f["Detalii"] = $foto->Detalii; $f["Ordin"] = $foto->Ordin; $f["Schita"] = $foto->Schita; $sql_foto .= "('" . join("', '", array_values($f)) . "'),"; $ftp_file[] = $foto->NumeFisier; if (!ftp_put($ftp_conn, NEW_FTP_PATH . DS . $f["NumeFisier"], ".." . DS . "images" . DS . $foto->NumeFisier, FTP_BINARY)) { echo "Nu am reusit sa transfer foto {$foto->NumeFisier} al proprietatii {$oferta->id}"; } } $sql_foto = substr($sql_foto, 0, strlen($sql_foto) - 1); $result = execute_querry($sql_foto, $conexiune2); } //echo $sql_apartament."</br>"; //echo $sql_oferta."</br"; //echo $sql_dotare."</br"; switch ($oferta->OfertaWeb) { case 1: $oferta->OfertaWeb = 4; break; case 2: $oferta->OfertaWeb = 4; break; case 3: $oferta->OfertaWeb = 0; break; } $oferta->save(); ftp_close($ftp_conn); }