11 and etaj<>etaj_max)";
}
//ordonare ==============================================
if ($ord0_gas){ //in left_oras.php am cautat sirul ordonare si in ord0 am pozitia dupa ordonare_
//$pord=strlen($url);$pord=$pord-$ord0_gas; echo $pord;
//$urlord=substr($url,0,$ord0_gas);//am facut +9 pt ca initial nu are ordonare url-ul ord00_gas
//$urlord=str_replace($id_loca_,"",$urlord); //elimin id_loca, il concatez dupa aia in selectul de ordonare
//echo $urlord;
//$ord00_gas=$ord0_gas-1;$urlord0=substr($url,0,$ord00_gas); //$urlord0 imi tb pt ordonarea "aleator"
}
else
$urlord=$url."-";
$orderby="";
if ($ordonare=="data" && $asc_desc=="asc") $orderby=" order by data_anunt asc ";
if ($ordonare=="data" && $asc_desc=="desc") $orderby=" order by data_anunt desc ";
if ($ordonare=="pret" && $asc_desc=="asc") $orderby=" order by pret asc ";
if ($ordonare=="pret" && $asc_desc=="desc") $orderby=" order by pret desc ";
if ($idcateg==1 || $idcateg==3 || $idcateg==6){
if ($ordonare=="camere" && $asc_desc=="asc") $orderby=" order by nr_cam asc ";
if ($ordonare=="camere" && $asc_desc=="desc") $orderby=" order by nr_cam desc ";
}
if ($ordonare=="suprafata" && $asc_desc=="asc") $orderby=" order by sup_util asc ";
if ($ordonare=="suprafata" && $asc_desc=="desc") $orderby=" order by sup_util desc ";
if ($idcateg==3 || $idcateg==6 || $idcateg==7 || $idcateg==8 || $idcateg==9){
if ($ordonare=="an_constructie" && $asc_desc=="asc") $orderby=" order by an_constr asc ";
if ($ordonare=="an_constructie" && $asc_desc=="desc") $orderby=" order by an_constr desc ";
}
//end ord===========================================
if($pagina)
$lim=$pagina*10; //3 insemana cate anunturi sunt pe pagina. E de proba. Vor fi mai multe
else
$lim="";
if ($lim){
$lim0=$lim-10;
$lim_trimis=$lim;
}
else{
$lim0=0;$lim=10;
$lim_trimis=0;
}
if (empty($id_judet))
$loca_jud=" id_loca=".$id_loca;
else
$loca_jud=" id_judet=".$id_judet;
//echo "select SQL_CALC_FOUND_ROWS id,(select nume from imob_categ where id=ia.idcateg) categ,userid,id_agentie,registerDate data_anunt,imob_proprietar,imagini,nr_cam, titlu,strada,id_loca id_loca_db,(select localitate from localitati where id=ia.id_loca) localit,zona, pret ".$stmt_part." moneda,tip_tranz from imob_anunturi ia where id_agentie=".$id_agentie." and publicat=1 ".$where.$orderby." limit ".$lim0.",10 ";
$result_o = mysql_query("select SQL_CALC_FOUND_ROWS id,(select nume from imob_categ where id=ia.idcateg) categ,userid,id_agentie,registerDate data_anunt,imob_proprietar,imagini,nr_cam, titlu,strada,id_loca id_loca_db,(select localitate from localitati where id=ia.id_loca) localit,zona, pret ".$stmt_part." moneda,tip_tranz from imob_anunturi ia where id_agentie=".$id_agentie." and publicat=1 ".$where.$orderby." limit ".$lim0.",10 ");
//echo "select SQL_CALC_FOUND_ROWS id,(select nume from imob_categ where id=ia.idcateg) categ,userid,id_agentie,registerDate data,imob_proprietar,imagini,nr_cam, titlu,strada,(select localitate from localitati where id=ia.id_loca) localit, pret ".$stmt_part." moneda from imob_anunturi ia where publicat=1 ".$where.$orderby." limit ".$lim0.",3 ";
$res = mysql_query("SELECT FOUND_ROWS()");
list($total) = mysql_fetch_array($res);
if ($lim_trimis==0) $lim_trimis=10;
$pagini=round($total/10);
$pag_curr=$lim_trimis/10;
$i=0;
$i_afis=0;
//if ($idcateg0)
?>
';
echo '
Anunturi imobiliare din ( anunturi)
( anunturi)
';
echo 'Pagina ';
for($i = 0; $i < $total; $i++){
if ($i==0 || $i%10==0){
$i_afis=$i_afis+1;
$lim=$i_afis*10; //echo $lim_trimis.'|'; echo $lim;
if($i_afis>1) //la prima pagina nu mai pun in url pag_1
$nr_pag_txt='-pag_'.$i_afis;
else
$nr_pag_txt='';
if ($lim_trimis==$lim)
echo ' '.$i_afis.' ';
else{
if ($pagini<=7 || $i_afis==1 || $i_afis==$pagini || ($pag_curr-$i_afis<=10 && $pag_curr-$i_afis>0) || ($i_afis-$pag_curr<=10 && $i_afis-$pag_curr>0) ) {
echo $lnk_pag.$sir_ordonare.$nr_pag_txt.$id_loca_.'" title="Anunturi imobiliare- pagina '.$i_afis.'"> '.$i_afis.' ';}
else{
if ($i_afis==2 || $i_afis==$pagini-1)
echo "...";
}
}
}
}
echo '
';
echo ' ';
echo '';
echo '
";
?>';
?>Ordoneaza dupa
';
echo "";
echo '
';
//$i2=0;
$exista_ofe="";
while ($row = mysql_fetch_assoc($result_o)) {
$exista_ofe=1;
//if ($i2==0 || $i2%3==0){
echo "";
//}
//echo '
";
//}
//$i2=$i2+1;
}
//if (fmod($i2,3)<>0)
//echo "';
$n_subc=$row["categ"];
$id_subc=$row["categid"];
$n_subc2=$row["subcateg"];
$id_subc2=$row["subcategid"];
$row["etaj"]=intval($row["etaj"]);
if ($row["imagini"])
$img_anunt=$row["imagini"];
else
$img_anunt='fara_img.jpg';
//=====construiesc url-ul====
if ($row["tip_tranz"]==1)
$tip_tranz_txt='anunt-vanzare-';
elseif ($row["tip_tranz"]==2)
$tip_tranz_txt='anunt-inchiriere-';
elseif ($row["tip_tranz"]==3)
$tip_tranz_txt='anunt-schimb-';
$strarray_ctg=array(" sau ", " pentru "," ");
$categ_txt=strtolower(str_replace($strarray_ctg,"-",$row["categ"])."-");
$localit_txt=str_replace(" ","-",$loca_agentie);
//$localit_txt=str_replace(" ","_",$localit_txt);
$zona_txt="-".str_replace(" ","_",$row["zona"]);
if ($row["nr_cam"])
$cam_txt="-".$row["nr_cam"]."-camere";
else
$cam_txt='';
$url_part_txt=$tip_tranz_txt.$categ_txt.$localit_txt.$zona_txt.$cam_txt;
$url_part_alt=str_replace("-"," ",$url_part_txt);
//==========================
//echo '
';
echo '';
//echo '
';
echo "";
//if ($i2%3==2){
// echo "'.$row["titlu"].'
'; echo ''.$row["titlu"].'
'; //echo ''.$row["titlu"].'
'; if ($row["strada"]) //satele de ex pot sa nu aiba strada echo 'Str. '.$row["strada"].', '; if (empty($id_judet)) echo $row["localit"].'
'; else{ $lik_loca= 'http://imobiliare.casesigradini.ro/categ_localit.php?'.$row["localit"].$found_vanz_inc.$found_imob_categ_.$found_imob_prop_.$found_imob_pret_.$found_imob_cam_.$found_imob_etaj_.'-'.$row["id_loca_db"]; echo ''.$row["localit"].''; } if ($row["nr_cam"]==1) $camere='o camera, '; else $camere=$row["nr_cam"].' camere, '; if ($tip_propriet==1 || $tip_propriet==2) //daca nu e teren echo ''.$camere.'suprafata '.$row["sup_util"].' mp, '; if ($tip_propriet==1){ //daca e apartament sau garsoniera if ($row["etaj"] && $row["etaj_max"]) echo 'etaj '.$row["etaj"].' din '.$row["etaj_max"].'
'; if ($row["etaj"] && empty($row["etaj_max"])) echo 'etaj '.$row["etaj"].''; if (empty($row["etaj"]) && $row["etaj_max"]) echo 'imobil cu '.$row["etaj_max"].' etaje'; } if ($tip_propriet==2) //daca e casa, pensiune, spatiu birou, spatiu industrial nivel_txt,sup_teren,front_str echo $row["nivel_txt"].''; if ($tip_propriet==2 || $tip_propriet==3){ //daca e casa, pensiune, spatiu birou, spatiu industrial sau teren echo ''.'teren '.$row["sup_teren"].' mp'; if ($row["front_str"]) echo ', front stradal '.$row["front_str"].' m'; echo '
'; } if ($row["imob_proprietar"]==2) $tip_prop='Vanzare prin agentie imobiliara'; if ($row["imob_proprietar"]==1) $tip_prop='Vanzare directa de catre proprietar'; echo ''.$tip_prop.'
'; echo 'Pret: '.str_replace(".",",",$row["pret"]).' '.$row["moneda"].'
'; //echo ""; echo ""; echo '