$sql_proprietate .= "Inchiriere,Pret,PretChirie,Moneda,NumarCamere,Confort,TipApartament,Etaj,EtajeBloc,";
$sql_proprietate .= "TipConstructie,NrGrupuriSanitare,NumarBalcoane,SuprafataTerasa,CodBazaDate,AnConstructie,";
$sql_proprietate .= "DataActualizare,SuprafataUtila,SuprafataConstruita,OfertaSpeciala) VALUES ";
$sql_dotare = "INSERT INTO DotareApartament (idApartament,idDotare) VALUES ";
$sql_foto = "INSERT INTO Foto (idProprietate, NumeFisier, Tip, Marime, Detalii, Ordin, Schita) VALUES ";
$sql = "SELECT * FROM Oferta WHERE (Exportat<>1 OR Exportat=NULL)";
$oferte = Oferta::find_by_sql($sql);
//$oferta=array_shift($oferte);
$td = 0;
$ti = 0;
$tu = 0;
$sync = 0;
$insert = 0;
foreach ($oferte as $oferta) {
$sync++;
$apartament = Apartament::find_by_id($oferta->id);
$client = Client::find_by_id($apartament->idClient);
$agent = User::find_by_id($client->idUtilizator);
$sql = "SELECT * FROM Proprietate WHERE CodBazaDate={$oferta->id}";
$update = 0;
$result = mysql_query($sql, $conexiune2);
if ($row = mysql_fetch_array($result)) {
$update = 1;
$idProprietate = $row["id"];
}
if ($update) {
$td1 = time();
$sql = "DELETE FROM DotareApartament WHERE idApartament={$idProprietate}";
$result = execute_querry($sql, $conexiune2);
//$sql="ALTER TABLE DotareApartament AUTO_INCREMENT = 1";
//$result=execute_querry($sql, $conexiune2);
<tr >
<td class="header" align="center" width="5%">Cod</td>
<td class="header" align="center" width="10%">Camere</td>
<td class="header" width="70%">Detalii</td>
<td class="header" align="center" width="10%"><?php
echo $tipOferta == 1 ? "Pret" : "Chirie";
?>
</td>
<td class="header" align="center" width="5%">Foto</td>
</tr>
<?php
$i = 0;
foreach ($ofertaList as $ofertax) {
$i = $i + 1;
$class = $i % 2 ? "impar" : "par";
$apartament = Apartament::find_by_id($ofertax->idApartament);
$strada = Strada::find_by_id($apartament->idStrada);
$subzona = Subzona::find_by_id($apartament->idSubzona);
if ($i % 2) {
$color = "#ffffff";
} else {
$color = "#CCCCCC";
}
$sql = "SELECT * FROM Foto WHERE idApartament={$apartament->id} ORDER BY Ordin LIMIT 1";
$fotos = Foto::find_by_sql($sql);
?>
<tr <?php
echo "id='" . $ofertax->id . "' class='" . $class . "' ondblclick=ofertaView(" . $ofertax->id . ") onmouseover=this.style.cursor='pointer';onOver(" . $ofertax->id . ",1," . $i . ") onmouseout=onOver(" . $ofertax->id . ",0," . $i . ")";
?>
>
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);
}
<td align="right">
<input type="button" value="Modifica client" onclick="document.location = ('client_update.php?id=' + <?php
echo $client->id;
?>
)" />
<input type="button" value="Detalii client" <?php
echo "onclick='clientView(" . $client->id . ")'";
?>
/>
</td>
</tr>
</table>
</div>
<?php
$sql = "SELECT * FROM Apartament WHERE idClient='{$client->id}'";
$apList = Apartament::find_by_sql($sql);
if (!empty($apList)) {
?>
<div id="oferte" class="view">
<h3 onclick="showHide('listaOferte')" onmouseover="this.style.cursor='pointer'">Oferte ale clientului</h3>
<table width="100%" id="listaOferte">
<tr >
<td class="header" width="5%" align="center">Cod</td>
<td class="header" width="10%" align="center">Camere</td>
<td class="header" width="70%">Detalii</td>
<td class="header" width="10%" align="center">Pret</td>
<td class="header" width="5%" align="center">Foto</td>
</tr>
<?php
$i = 0;
foreach ($apList as $apartament) {
<?php
require_once ".././include/initialize.php";
if (!$session->is_logged_in()) {
redirect_to("login.php");
}
$message = "";
require_once "sync_site_lib.php";
if (isset($_GET['id'])) {
$idApartament = $_GET['id'];
$idOferta = $_GET['idOferta'];
$apartament = Apartament::find_by_id($idApartament);
$oferta = Oferta::find_by_id($idOferta);
}
if (isset($_POST['submit'])) {
$apartament = Apartament::find_by_id($_POST['idApartament']);
$oferta = Oferta::find_by_id($_POST['idOferta']);
$apartament->youtube = $_POST['youtube'];
$apartament->save();
$syncList = array('ExportPitagora', 'ExportImobiliare', 'ExportCI', 'ExportRoImobile', 'ExportRomimo', 'ExportNorc', 'ExportMC');
foreach ($syncList as $sync) {
if ($oferta->{$sync} == 4) {
$oferta->{$sync} = 2;
}
}
if ($oferta->OfertaWeb == 4) {
$oferta->OfertaWeb = 2;
}
$oferta->save();
// sincronizare site
if ($oferta->OfertaWeb > 0) {
$telefon = $client->TelefonFix;
} else {
if ($client->TelefonServici != "") {
$telefon = $client->TelefonServici;
} else {
if ($client->TelefonFax != "") {
$telefon = $client->TelefonFax;
}
}
}
}
}
if (isset($_POST['submit']) || isset($_POST['actualizare'])) {
//print_r($_POST);
$OfertaId = $_POST['xOfertaId'];
$apartament = new Apartament();
$oferta = new Oferta();
$client = Client::find_by_id($_POST['ClientId']);
$agent = User::find_by_id($client->idUtilizator);
$dotariList = array();
$syncList = array('ExportPitagora', 'ExportImobiliare', 'ExportRoImobile', 'ExportRomimo', 'ExportMC', 'ExportImopedia');
$postlist = array_keys($_POST);
foreach ($postlist as $variable) {
if ($variable != "submit") {
${$variable} = $_POST[$variable];
}
$atribut = substr(array_shift(explode("_", $variable)), 2);
//echo $variable."\n";
if (substr($variable, 0, 2) == "Ap") {
$apartament->{$atribut} = ${$variable};
}
