$sql .= "AND ((C.Nume LIKE '%{$ClientNume}%') OR (C.Prenume LIKE '%{$ClientNume}%')) ";
}
if ($ClientCod != "") {
$sql .= "AND C.id='{$ClientCod}' ";
}
if ($Agent != "") {
$sql .= "AND U.id='{$Agent}' ";
}
if ($Stare != "") {
$sql .= "AND X.Stare='{$Stare}' ";
}
if (isset($subZonaChecked)) {
$sql = $sql . "AND (" . build_query_zone($subZonaChecked, "Zona") . ") ";
}
$sql .= "ORDER BY X.DataCreare DESC ";
$cerereList = Cerere::find_by_sql($sql);
if (!empty($cerereList)) {
?>
<div id="oferte" class="view">
<h3>Cereri gasite</h3>
<table width="100%">
<tr >
<td class="header" width="5%">Cod</td>
<td class="header" width="15%">Client</td>
<td class="header" width="10%">Telefon</td>
<td class="header" width="5%">Tip proprietate</td>
<td class="header" width="5%">Camere</td>
<td class="header" width="10%">Tip ap.</td>
<td class="header" width="5%">Etaje</td>
<td class="header" width="30%">Zone</td>
<td class="header" width="10%">Buget</td>
