$clean[$key] = trim($value);
}
$sql .= "AND (A.id=" . implode(" OR A.id=", $clean) . ") ";
}
if ($Strada != "") {
$sql .= "AND S.Denumire LIKE '%" . str_replace("%20", " ", $Strada) . "%' ";
}
if ($Agent != "") {
$sql .= "AND U.id=" . $Agent . " ";
}
if ($Proprietar != "") {
$sql .= "AND ((C.Nume LIKE '%" . $Proprietar . "%') OR (C.Prenume LIKE '%" . $Proprietar . "%')) ";
}
$sql .= "ORDER BY O.DataActualizare " . ($tipSortareActualizare == 1 ? "DESC" : "");
//echo htmlentities($sql);
$ofertaList = $oferta->find_by_sql($sql);
if (!empty($ofertaList)) {
?>
<div id="oferte" class="view">
<h3>Oferte gasite</h3>
<table width="100%">
<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>
$record["Descriere"] = $tmp->Descriere;
$record["idCategorieDotari"] = $tmp->idCategorieDotari;
$record["Implicit"] = $tmp->Implicit;
$sql .= "('" . join("', '", array_values($record)) . "'),";
}
$sql = substr($sql, 0, strlen($sql) - 1);
$result = execute_querry($sql, $conexiune2);
$ftp_file = array();
$sql_proprietate = "INSERT INTO Proprietate (id,idSubzona,idAgent,TipProprietate,Titlu,Descriere,Vanzare,";
$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)) {
<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) {
$sql = "SELECT * FROM Foto WHERE idApartament={$apartament->id} ORDER BY Ordin LIMIT 1";
$fotos = Foto::find_by_sql($sql);
$sql = "SELECT * FROM Oferta WHERE idApartament='{$apartament->id}'";
$ofertaList = Oferta::find_by_sql($sql);
$strada = Strada::find_by_id($apartament->idStrada);
if (!empty($ofertaList)) {
foreach ($ofertaList as $oferta) {
$i++;
$class = $i % 2 ? "impar" : "par";
?>
<tr id="<?php
echo $oferta->id;
?>
" class="<?php
echo $class;
?>
" style="font-weight: bold;" onmouseover="this.style.cursor='pointer';onOver(<?php
echo $oferta->id;
?>