/*
$files=ftp_nlist($ftp_conn,NEW_FTP_PATH);
foreach ($files as $file)
{
if (($file!=".")&&($file!="..")) ftp_delete($ftp_conn, NEW_FTP_PATH.DS.$file);
}
*/
// conectare BD site
$conexiune2 = mysql_connect(NEW_SITE_SERVER, NEW_SITE_USER, NEW_SITE_PASSWORD, TRUE);
$dbselect2 = mysql_select_db(NEW_SITE_DB, $conexiune2);
// refresh agenti
sync_Agenti();
// refresh CategorieDotari
sync_CategorieDotari();
// refresh Dotari
sync_Dotari();
// sync oferte
//sync_Oferta(1565);
$sql = "SELECT * FROM Oferta WHERE OfertaWeb>0 AND OfertaWeb<4";
// status oferta:
// 0 - nu se exporta
// 1 - creare
// 2 - update
// 3 - delete
// 4 - exportat
$oferte = Oferta::find_by_sql($sql);
if (!empty($oferte)) {
foreach ($oferte as $oferta) {
echo "Sincronizare oferta cu ID {$oferta->id}" . PHP_EOL;
sync_Oferta($oferta->id);
}
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);
}