$result = execute_querry($sql, $conexiune2);
}
$td = $td + (time() - $td1);
}
$ti1 = time();
if ($oferta->OfertaWeb == 1 && $oferta->Stare == "de actualitate") {
$proprietate = array();
$proprietate["id"] = $oferta->id;
$subzona = Subzona::find_by_id($apartament->idSubzona);
$proprietate["idSubzona"] = $subzona->idCartier;
$proprietate["idAgent"] = $client->idUtilizator;
$proprietate["TipProprietate"] = $apartament->TipProprietate;
$proprietate["Titlu"] = $oferta->Titlu;
if ($proprietate["Titlu"] == "") {
$proprietate["Titlu"] = $apartament->NumarCamere > 1 ? "Apartament " . $apartament->NumarCamere . " camere " : "Garsoniera ";
$zona = Subzona::find_by_id($apartament->idSubzona);
$proprietate["Titlu"] .= $zona->Denumire;
if ($apartament->PunctReper != "") {
$proprietate["Titlu"] .= " - " . $apartament->PunctReper;
}
}
$proprietate["Descriere"] = $apartament->Detalii;
$proprietate["Vanzare"] = $oferta->Vanzare;
$proprietate["Inchiriere"] = $oferta->Inchiriere;
$proprietate["Pret"] = $oferta->Pret;
$proprietate["PretChirie"] = $oferta->PretChirie;
$proprietate["Moneda"] = $oferta->Moneda;
$proprietate["NumarCamere"] = $apartament->NumarCamere;
$proprietate["Confort"] = $apartament->Confort;
$proprietate["TipApartament"] = $apartament->TipApartament;
$proprietate["Etaj"] = $apartament->Etaj;
$idCartier = $subzona->idCartier;
$idPitagora = $subzona->idPitagora;
$idImobiliare = $subzona->idImobiliare;
$idMC = $subzona->idMC;
$idImopedia = $subzona->idImopedia;
$_SESSION['curentIdSubzona'] = $subzona->id;
}
if (isset($_POST['submit'])) {
$subzona = new Subzona();
$Denumire = $_POST['Denumire'];
$idCartier = $_POST['idCartier'];
$idPitagora = $_POST['idPitagora'];
$idImobiliare = $_POST['idImobiliare'];
$idMC = $_POST['idMC'];
$idImopedia = $_POST['idImopedia'];
$subzona = Subzona::find_by_id($_SESSION['curentIdSubzona']);
unset($_SESSION['curentIdSubzona']);
$subzona->Denumire = $Denumire;
$subzona->idCartier = $idCartier;
$subzona->idPitagora = $idPitagora;
$subzona->idImobiliare = $idImobiliare;
$subzona->idMC = $idMC;
$subzona->idImopedia = $idImopedia;
$subzona->save();
$message = "salvat";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ro" lang="ro">
<head>
}
}
}
$i = $i + 1;
$class = $i % 2 ? "impar" : "par";
echo "<tr id='" . $cerere->id . "' class='" . $class . "' ondblclick=cerereView(" . $cerere->id . ") onmouseover=this.style.cursor='pointer';onOver(" . $cerere->id . ",1," . $i . ") onmouseout=onOver(" . $cerere->id . ",0," . $i . ") style=\"height:30px;font-weight:bold;\">";
echo "<td>" . $cerere->id . "</td>";
echo "<td>" . $client->full_name() . "</td>";
echo "<td>" . $client->TelefonMobil . "</td>";
echo "<td>" . $TipProprietateList . "</td>";
echo "<td align=\"center\">" . substr($cerere->NumarCamere, 1, -1) . "</td>";
echo "<td>" . substr($cerere->TipApartament, 1, -1) . "</td>";
echo "<td>" . ($cerere->EtajMinim > 0 ? $cerere->EtajMinim : "P") . " -> " . ($cerere->EtajMaxim ? $cerere->EtajMaxim : "-") . "</td>";
echo "<td>";
foreach ($zoneIdList as $zonaId) {
if ($zonaId != "") {
$zona = Subzona::find_by_id($zonaId);
echo $zona->Denumire . ",";
}
}
echo "</td>";
echo "<td align=\"right\">" . $cerere->Buget . " " . $cerere->Moneda . "</td>";
echo "<td>" . ($cerere->Credit == 1 ? "credit" : "cash") . "</td>";
echo "</tr>";
}
?>
</table>
</div>
<?php
}
}
<script>
hide("extraClient");
</script>
<div id="Zone" class="view">
<h3>Detalii apartament</h3>
<table>
<tr>
<td class="label">Zone:</td>
<td>
<?php
$zone = "";
if (strlen($cerere->Zona) > 0) {
$zoneList = explode(",", $cerere->Zona);
foreach ($zoneList as $idZona) {
$zona = Subzona::find_by_id($idZona);
if ($zone != "") {
$zone .= ", {$zona->Denumire}";
} else {
$zone = $zona->Denumire;
}
}
}
echo $zone;
?>
</td>
</tr>
<tr>
<td class="label">Tip proprietate:</td>
<td><?php
$tmp = "";
require_once ".././include/initialize.php";
if (!$session->is_logged_in()) {
redirect_to("login.php");
}
include_layout_template('admin_header.php');
?>
<script type="text/javascript">
<!--
function back(){
document.location = ("subzona_list.php");
}
//-->
</script>
<?php
$subzona = Subzona::find_by_id($_GET['id']);
$subzona->delete();
?>
<h3>Subzona <?php
echo $subzona->Denumire;
?>
a fost stearsa.</h3>
<div id="butoane" class="butoane">
<input type="button" name="submit" value="Inapoi" onclick="back()" />
</div>
<?php
include_layout_template('admin_footer.php');
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);
}
