$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);
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); }
<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 . ")"; ?> >
<?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) {