escapeString($lat_min);
$lon_min = $this->escapeString($lon_min);
$lat_max = $this->escapeString($lat_max);
$lon_max = $this->escapeString($lon_max);
$_SESSION['lat_min'] = $lat_min;
$_SESSION['lat_max'] = $lat_max;
$_SESSION['lon_min'] = $lon_min;
$_SESSION['lon_max'] = $lon_max;
if ($_SESSION['storedOrderField']=='') $_SESSION['storedOrderField'] = 'letrehozva';
if ($_SESSION['storedOrderDirection']=='') $_SESSION['storedOrderDirection'] = 'DESC';
$queryPostfix = $this->getInactiveOffices()." ORDER BY ".$_SESSION['storedOrderField']." ".$_SESSION['storedOrderDirection'];
if ($_SESSION['lat_min']!='' && $_SESSION['lat_max']!='' && $_SESSION['lon_min']!='' && $_SESSION['lon_max']!='') {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
googlelat>='".$_SESSION['lat_min']."' AND
googlelat<='".$_SESSION['lat_max']."' AND
googlelon>='".$_SESSION['lon_min']."' AND
googlelon<='".$_SESSION['lon_max']."' AND
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
else {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
if ($_SESSION['statusz_switch']=='uj') $tempSQL.= " AND jogi_statusz='uj'";
if ($_SESSION['statusz_switch']=='legujabb') $tempSQL.= " AND letrehozva >= DATE(NOW()) - INTERVAL 14 DAY";
if ($search['ertekesites']!='') $tempSQL.= " AND ertekesites='".$search['ertekesites']."'";
//if ($search['jelleg']!='') $tempSQL.= " AND jelleg='".$search['jelleg']."'";
if ($_SESSION['wtf']!='') $tempSQL.= " AND jelleg='".$_SESSION['wtf']."'";
if ($search['tipus']!='') $tempSQL.= " AND tipus='".$search['tipus']."'";
if ($search['ertekesites']=='elado') {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000000'";
}
else {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000'";
}
if ($search['meret_netto_min']!='') $tempSQL.= " AND meret_brutto>='".$search['meret_netto_min']."'";
if ($search['meret_netto_max']!='') $tempSQL.= " AND meret_brutto<='".$search['meret_netto_max']."'";
if ($search['altipus']!='') {
$list = explode(",",$search['altipus']);
$altipusok = "";
foreach ($list as $altipus) {
$altipusok.= "'".$altipus."',";
}
$altipusok = rtrim($altipusok,',');
$tempSQL.= " AND altipus IN (".$altipusok.")";
}
if ($search['jogi_statusz']!='') $tempSQL.= " AND jogi_statusz='".$search['jogi_statusz']."'";
//if ($search['szoba_min']!='') $tempSQL.= " AND szoba>='".$search['szoba_min']."'";
//if ($search['szoba_max']!='') $tempSQL.= " AND szoba<='".$search['szoba_max']."'";
if ($search['kilatas']!='') {
$list = explode(",",$search['kilatas']);
$kilatasok = "";
foreach ($list as $kilatas) {
$kilatasok.= "'".$kilatas."',";
}
$kilatasok = rtrim($kilatasok,',');
$tempSQL.= " AND kilatas IN (".$kilatasok.")";
}
if ($search['futes']!='') {
$list = explode(",",$search['futes']);
$futesek = "";
foreach ($list as $futes) {
$futesek.= "'".$futes."',";
}
$futesek = rtrim($futesek,',');
$tempSQL.= " AND futes IN (".$futesek.")";
}
if ($search['tajolas']!='') {
$list = explode(",",$search['tajolas']);
$tajolasok = "";
foreach ($list as $tajolas) {
$tajolasok.= "'".$tajolas."',";
}
$tajolasok = rtrim($tajolasok,',');
$tempSQL.= " AND tajolas IN (".$tajolasok.")";
}
if ($search['allapot']!='') {
$list = explode(",",$search['allapot']);
$allapotok = "";
foreach ($list as $allapot) {
$allapotok.= "'".$allapot."',";
}
$allapotok = rtrim($allapotok,',');
$tempSQL.= " AND ingatlan_allapota IN (".$allapotok.")";
}
if ($search['kornyek']!='') {
$list = explode(",",$search['kornyek']);
$kornyekek = "";
foreach ($list as $kornyek) {
$kornyekek.= "'".$kornyek."',";
}
$kornyekek = rtrim($kornyekek,',');
$tempSQL.= " AND kornyek IN (".$kornyekek.")";
}
if ($search['epites_eve_min']!='') $tempSQL.= " AND epites_eve>='".$search['epites_eve_min']."'";
if ($search['epites_eve_max']!='') $tempSQL.= " AND epites_eve<='".$search['epites_eve_max']."'";
if ($search['telek_min']!='') $tempSQL.= " AND meret_telek>='".$search['telek_min']."'";
if ($search['telek_max']!='') $tempSQL.= " AND meret_telek<='".$search['telek_max']."'";
if ($search['ferohely_garazs_min']!='') $tempSQL.= " AND ferohely_garazs>='".$search['ferohely_garazs_min']."'";
if ($search['ferohely_garazs_max']!='') $tempSQL.= " AND ferohely_garazs<='".$search['ferohely_garazs_max']."'";
if ($search['kulon_nyilo_szobak']=='1') $tempSQL.= " AND kulon_nyilo_szobak='1'";
if ($search['terasz']=='1') $tempSQL.= " AND terasz='1'";
if ($search['erkely']=='1') $tempSQL.= " AND erkely='1'";
if ($search['pince']=='1') $tempSQL.= " AND pince='1'";
if ($search['tarolo']=='1') $tempSQL.= " AND tarolo='1'";
if ($search['garazs']=='1') $tempSQL.= " AND garazs='1'";
if ($search['ferohely_fedettbeallo']=='1') $tempSQL.= " AND ferohely_fedettbeallo='1'";
if ($search['kertkapcsolatos']=='1') $tempSQL.= " AND kertkapcsolatos='1'";
if ($search['viz']=='1') $tempSQL.= " AND viz='1'";
if ($search['gaz']=='1') $tempSQL.= " AND gaz='1'";
if ($search['villany']=='1') $tempSQL.= " AND villany='1'";
if ($search['csatorna']=='1') $tempSQL.= " AND csatorna='1'";
if ($search['lift']=='1') $tempSQL.= " AND lift='1'";
//die($tempSQL." ".$queryPostfix.$this->lazy_loader());
$result = $this->query($tempSQL." ".$queryPostfix.$this->lazy_loader());
$all = $this->query($tempSQL." ".$queryPostfix);
if ($search['szoba_min']!='' || $search['szoba_max']!='') {
foreach ($result as $row) {
$szoba = $row->szoba_fel+$row->szoba_egesz;
if ($szoba>=$search['szoba_min'] && $szoba<=$search['szoba_max']) {
$return[] = $row;
}
}
$result = $return;
}
if ($_SESSION['statusz_switch']=='arcsokkent') {
$return = null;
foreach ($all as $row) {
if ($this->isArcsokkent($row->regszam)) {
$return[] = $row;
}
}
$result = $return;
}
return $result;
}
public function getInactiveOffices() {
$check = $this->query("SELECT * FROM irodak where active='0';");
foreach ($check as $row) {
$temp[] = $row->office_id;
}
if (count($temp)>0) {
return ' AND iroda NOT IN (\''.implode('\',\'',$temp).'\')';
}
else {
return '';
}
}
public function get_map_results_circle($search) {
if ($_SESSION['storedOrderField']=='') $_SESSION['storedOrderField'] = 'letrehozva';
if ($_SESSION['storedOrderDirection']=='') $_SESSION['storedOrderDirection'] = 'DESC';
$queryPostfix = $this->getInactiveOffices()." ORDER BY ".$_SESSION['storedOrderField']." ".$_SESSION['storedOrderDirection'];
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
if ($search['ertekesites']!='') $tempSQL.= " AND ertekesites='".$search['ertekesites']."'";
//if ($search['jelleg']!='') $tempSQL.= " AND jelleg='".$search['jelleg']."'";
if ($_SESSION['wtf']!='') $tempSQL.= " AND jelleg='".$_SESSION['wtf']."'";
if ($search['tipus']!='') $tempSQL.= " AND tipus='".$search['tipus']."'";
if ($search['ertekesites']=='elado') {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000000'";
}
else {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000'";
}
if ($_SESSION['statusz_switch']=='uj') $tempSQL.= " AND jogi_statusz='uj'";
if ($_SESSION['statusz_switch']=='legujabb') $tempSQL.= " AND letrehozva >= DATE(NOW()) - INTERVAL 14 DAY";
if ($search['meret_netto_min']!='') $tempSQL.= " AND meret_brutto>='".$search['meret_netto_min']."'";
if ($search['meret_netto_max']!='') $tempSQL.= " AND meret_brutto<='".$search['meret_netto_max']."'";
if ($search['altipus']!='') {
$list = explode(",",$search['altipus']);
$altipusok = "";
foreach ($list as $altipus) {
$altipusok.= "'".$altipus."',";
}
$altipusok = rtrim($altipusok,',');
$tempSQL.= " AND altipus IN (".$altipusok.")";
}
if ($search['jogi_statusz']!='') $tempSQL.= " AND jogi_statusz='".$search['jogi_statusz']."'";
//if ($search['szoba_min']!='') $tempSQL.= " AND szoba>='".$search['szoba_min']."'";
//if ($search['szoba_max']!='') $tempSQL.= " AND szoba<='".$search['szoba_max']."'";
if ($search['kilatas']!='') {
$list = explode(",",$search['kilatas']);
$kilatasok = "";
foreach ($list as $kilatas) {
$kilatasok.= "'".$kilatas."',";
}
$kilatasok = rtrim($kilatasok,',');
$tempSQL.= " AND kilatas IN (".$kilatasok.")";
}
if ($search['futes']!='') {
$list = explode(",",$search['futes']);
$futesek = "";
foreach ($list as $futes) {
$futesek.= "'".$futes."',";
}
$futesek = rtrim($futesek,',');
$tempSQL.= " AND futes IN (".$futesek.")";
}
if ($search['tajolas']!='') {
$list = explode(",",$search['tajolas']);
$tajolasok = "";
foreach ($list as $tajolas) {
$tajolasok.= "'".$tajolas."',";
}
$tajolasok = rtrim($tajolasok,',');
$tempSQL.= " AND tajolas IN (".$tajolasok.")";
}
if ($search['allapot']!='') {
$list = explode(",",$search['allapot']);
$allapotok = "";
foreach ($list as $allapot) {
$allapotok.= "'".$allapot."',";
}
$allapotok = rtrim($allapotok,',');
$tempSQL.= " AND ingatlan_allapota IN (".$allapotok.")";
}
if ($search['kornyek']!='') {
$list = explode(",",$search['kornyek']);
$kornyekek = "";
foreach ($list as $kornyek) {
$kornyekek.= "'".$kornyek."',";
}
$kornyekek = rtrim($kornyekek,',');
$tempSQL.= " AND kornyek IN (".$kornyekek.")";
}
if ($search['epites_eve_min']!='') $tempSQL.= " AND epites_eve>='".$search['epites_eve_min']."'";
if ($search['epites_eve_max']!='') $tempSQL.= " AND epites_eve<='".$search['epites_eve_max']."'";
if ($search['telek_min']!='') $tempSQL.= " AND meret_telek>='".$search['telek_min']."'";
if ($search['telek_max']!='') $tempSQL.= " AND meret_telek<='".$search['telek_max']."'";
if ($search['ferohely_garazs_min']!='') $tempSQL.= " AND ferohely_garazs>='".$search['ferohely_garazs_min']."'";
if ($search['ferohely_garazs_max']!='') $tempSQL.= " AND ferohely_garazs<='".$search['ferohely_garazs_max']."'";
if ($search['kulon_nyilo_szobak']=='1') $tempSQL.= " AND kulon_nyilo_szobak='1'";
if ($search['terasz']=='1') $tempSQL.= " AND terasz='1'";
if ($search['erkely']=='1') $tempSQL.= " AND erkely='1'";
if ($search['pince']=='1') $tempSQL.= " AND pince='1'";
if ($search['tarolo']=='1') $tempSQL.= " AND tarolo='1'";
if ($search['garazs']=='1') $tempSQL.= " AND garazs='1'";
if ($search['ferohely_fedettbeallo']=='1') $tempSQL.= " AND ferohely_fedettbeallo='1'";
if ($search['kertkapcsolatos']=='1') $tempSQL.= " AND kertkapcsolatos='1'";
if ($search['viz']=='1') $tempSQL.= " AND viz='1'";
if ($search['gaz']=='1') $tempSQL.= " AND gaz='1'";
if ($search['villany']=='1') $tempSQL.= " AND villany='1'";
if ($search['csatorna']=='1') $tempSQL.= " AND csatorna='1'";
if ($search['lift']=='1') $tempSQL.= " AND lift='1'";
$result = $this->query($tempSQL." ".$queryPostfix);
if ($search['szoba_min']!='' || $search['szoba_max']!='') {
foreach ($result as $row) {
$szoba = $row->szoba_fel+$row->szoba_egesz;
if ($szoba>=$search['szoba_min'] && $szoba<=$search['szoba_max']) {
$return[] = $row;
}
}
$result = $return;
}
if ($_SESSION['statusz_switch']=='arcsokkent') {
$return = null;
foreach ($result as $row) {
if ($this->isArcsokkent($row->regszam)) {
$return[] = $row;
}
}
$result = $return;
}
return $result;
}
public function get_map_results_all($lat_min,$lat_max,$lon_min,$lon_max,$search) {
$lat_min = $this->escapeString($lat_min);
$lon_min = $this->escapeString($lon_min);
$lat_max = $this->escapeString($lat_max);
$lon_max = $this->escapeString($lon_max);
$_SESSION['lat_min'] = $lat_min;
$_SESSION['lat_max'] = $lat_max;
$_SESSION['lon_min'] = $lon_min;
$_SESSION['lon_max'] = $lon_max;
if ($_SESSION['storedOrderField']=='') $_SESSION['storedOrderField'] = 'letrehozva';
if ($_SESSION['storedOrderDirection']=='') $_SESSION['storedOrderDirection'] = 'DESC';
$queryPostfix = $this->getInactiveOffices()." ORDER BY ".$_SESSION['storedOrderField']." ".$_SESSION['storedOrderDirection'];
if ($_SESSION['lat_min']!='' && $_SESSION['lat_max']!='' && $_SESSION['lon_min']!='' && $_SESSION['lon_max']!='') {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
googlelat>='".$_SESSION['lat_min']."' AND
googlelat<='".$_SESSION['lat_max']."' AND
googlelon>='".$_SESSION['lon_min']."' AND
googlelon<='".$_SESSION['lon_max']."' AND
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
else {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
if ($search['ertekesites']!='') $tempSQL.= " AND ertekesites='".$search['ertekesites']."'";
//if ($search['jelleg']!='') $tempSQL.= " AND jelleg='".$search['jelleg']."'";
if ($_SESSION['wtf']!='') $tempSQL.= " AND jelleg='".$_SESSION['wtf']."'";
if ($search['tipus']!='') $tempSQL.= " AND tipus='".$search['tipus']."'";
if ($_SESSION['statusz_switch']=='uj') $tempSQL.= " AND jogi_statusz='uj'";
if ($_SESSION['statusz_switch']=='legujabb') $tempSQL.= " AND letrehozva >= DATE(NOW()) - INTERVAL 14 DAY";
if ($search['ertekesites']=='elado') {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000000'";
}
else {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000'";
}
if ($search['meret_netto_min']!='') $tempSQL.= " AND meret_brutto>='".$search['meret_netto_min']."'";
if ($search['meret_netto_max']!='') $tempSQL.= " AND meret_brutto<='".$search['meret_netto_max']."'";
if ($search['altipus']!='') {
$list = explode(",",$search['altipus']);
$altipusok = "";
foreach ($list as $altipus) {
$altipusok.= "'".$altipus."',";
}
$altipusok = rtrim($altipusok,',');
$tempSQL.= " AND altipus IN (".$altipusok.")";
}
if ($search['jogi_statusz']!='') $tempSQL.= " AND jogi_statusz='".$search['jogi_statusz']."'";
//if ($search['szoba_min']!='') $tempSQL.= " AND szoba>='".$search['szoba_min']."'";
//if ($search['szoba_max']!='') $tempSQL.= " AND szoba<='".$search['szoba_max']."'";
if ($search['kilatas']!='') {
$list = explode(",",$search['kilatas']);
$kilatasok = "";
foreach ($list as $kilatas) {
$kilatasok.= "'".$kilatas."',";
}
$kilatasok = rtrim($kilatasok,',');
$tempSQL.= " AND kilatas IN (".$kilatasok.")";
}
if ($search['futes']!='') {
$list = explode(",",$search['futes']);
$futesek = "";
foreach ($list as $futes) {
$futesek.= "'".$futes."',";
}
$futesek = rtrim($futesek,',');
$tempSQL.= " AND futes IN (".$futesek.")";
}
if ($search['tajolas']!='') {
$list = explode(",",$search['tajolas']);
$tajolasok = "";
foreach ($list as $tajolas) {
$tajolasok.= "'".$tajolas."',";
}
$tajolasok = rtrim($tajolasok,',');
$tempSQL.= " AND tajolas IN (".$tajolasok.")";
}
if ($search['allapot']!='') {
$list = explode(",",$search['allapot']);
$allapotok = "";
foreach ($list as $allapot) {
$allapotok.= "'".$allapot."',";
}
$allapotok = rtrim($allapotok,',');
$tempSQL.= " AND ingatlan_allapota IN (".$allapotok.")";
}
if ($search['kornyek']!='') {
$list = explode(",",$search['kornyek']);
$kornyekek = "";
foreach ($list as $kornyek) {
$kornyekek.= "'".$kornyek."',";
}
$kornyekek = rtrim($kornyekek,',');
$tempSQL.= " AND kornyek IN (".$kornyekek.")";
}
if ($search['epites_eve_min']!='') $tempSQL.= " AND epites_eve>='".$search['epites_eve_min']."'";
if ($search['epites_eve_max']!='') $tempSQL.= " AND epites_eve<='".$search['epites_eve_max']."'";
if ($search['telek_min']!='') $tempSQL.= " AND meret_telek>='".$search['telek_min']."'";
if ($search['telek_max']!='') $tempSQL.= " AND meret_telek<='".$search['telek_max']."'";
if ($search['ferohely_garazs_min']!='') $tempSQL.= " AND ferohely_garazs>='".$search['ferohely_garazs_min']."'";
if ($search['ferohely_garazs_max']!='') $tempSQL.= " AND ferohely_garazs<='".$search['ferohely_garazs_max']."'";
if ($search['kulon_nyilo_szobak']=='1') $tempSQL.= " AND kulon_nyilo_szobak='1'";
if ($search['terasz']=='1') $tempSQL.= " AND terasz='1'";
if ($search['erkely']=='1') $tempSQL.= " AND erkely='1'";
if ($search['pince']=='1') $tempSQL.= " AND pince='1'";
if ($search['tarolo']=='1') $tempSQL.= " AND tarolo='1'";
if ($search['garazs']=='1') $tempSQL.= " AND garazs='1'";
if ($search['ferohely_fedettbeallo']=='1') $tempSQL.= " AND ferohely_fedettbeallo='1'";
if ($search['kertkapcsolatos']=='1') $tempSQL.= " AND kertkapcsolatos='1'";
if ($search['viz']=='1') $tempSQL.= " AND viz='1'";
if ($search['gaz']=='1') $tempSQL.= " AND gaz='1'";
if ($search['villany']=='1') $tempSQL.= " AND villany='1'";
if ($search['csatorna']=='1') $tempSQL.= " AND csatorna='1'";
if ($search['lift']=='1') $tempSQL.= " AND lift='1'";
$result = $this->query($tempSQL." ".$queryPostfix);
if ($search['szoba_min']!='' || $search['szoba_max']!='') {
foreach ($result as $row) {
$szoba = $row->szoba_fel+$row->szoba_egesz;
if ($szoba>=$search['szoba_min'] && $szoba<=$search['szoba_max']) {
$return[] = $row;
}
}
$result = $return;
}
if ($_SESSION['statusz_switch']=='arcsokkent') {
$return = null;
foreach ($result as $row) {
if ($this->isArcsokkent($row->regszam)) {
$return[] = $row;
}
}
$result = $return;
}
return $result;
}
public function lazy_loader() {
if ($_SESSION['storedPager']=='') $_SESSION['storedPager'] = '0';
return " LIMIT ".$_SESSION['storedPager'].",5;";
}
public function lazy_has_more($search) {
if ($_SESSION['lat_min']!='' && $_SESSION['lat_max']!='' && $_SESSION['lon_min']!='' && $_SESSION['lon_max']!='') {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
googlelat>='".$_SESSION['lat_min']."' AND
googlelat<='".$_SESSION['lat_max']."' AND
googlelon>='".$_SESSION['lon_min']."' AND
googlelon<='".$_SESSION['lon_max']."' AND
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
else {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
if ($search['ertekesites']!='') $tempSQL.= " AND ertekesites='".$search['ertekesites']."'";
//if ($search['jelleg']!='') $tempSQL.= " AND jelleg='".$search['jelleg']."'";
if ($_SESSION['wtf']!='') $tempSQL.= " AND jelleg='".$_SESSION['wtf']."'";
if ($search['tipus']!='') $tempSQL.= " AND tipus='".$search['tipus']."'";
if ($_SESSION['statusz_switch']=='uj') $tempSQL.= " AND jogi_statusz='uj'";
if ($_SESSION['statusz_switch']=='legujabb') $tempSQL.= " AND letrehozva >= DATE(NOW()) - INTERVAL 14 DAY";
if ($search['ertekesites']=='elado') {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000000'";
}
else {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000'";
}
if ($search['meret_netto_min']!='') $tempSQL.= " AND meret_brutto>='".$search['meret_netto_min']."'";
if ($search['meret_netto_max']!='') $tempSQL.= " AND meret_brutto<='".$search['meret_netto_max']."'";
if ($search['altipus']!='') {
$list = explode(",",$search['altipus']);
$altipusok = "";
foreach ($list as $altipus) {
$altipusok.= "'".$altipus."',";
}
$altipusok = rtrim($altipusok,',');
$tempSQL.= " AND altipus IN (".$altipusok.")";
}
if ($search['jogi_statusz']!='') $tempSQL.= " AND jogi_statusz='".$search['jogi_statusz']."'";
//if ($search['szoba_min']!='') $tempSQL.= " AND szoba>='".$search['szoba_min']."'";
//if ($search['szoba_max']!='') $tempSQL.= " AND szoba<='".$search['szoba_max']."'";
if ($search['kilatas']!='') {
$list = explode(",",$search['kilatas']);
$kilatasok = "";
foreach ($list as $kilatas) {
$kilatasok.= "'".$kilatas."',";
}
$kilatasok = rtrim($kilatasok,',');
$tempSQL.= " AND kilatas IN (".$kilatasok.")";
}
if ($search['futes']!='') {
$list = explode(",",$search['futes']);
$futesek = "";
foreach ($list as $futes) {
$futesek.= "'".$futes."',";
}
$futesek = rtrim($futesek,',');
$tempSQL.= " AND futes IN (".$futesek.")";
}
if ($search['tajolas']!='') {
$list = explode(",",$search['tajolas']);
$tajolasok = "";
foreach ($list as $tajolas) {
$tajolasok.= "'".$tajolas."',";
}
$tajolasok = rtrim($tajolasok,',');
$tempSQL.= " AND tajolas IN (".$tajolasok.")";
}
if ($search['allapot']!='') {
$list = explode(",",$search['allapot']);
$allapotok = "";
foreach ($list as $allapot) {
$allapotok.= "'".$allapot."',";
}
$allapotok = rtrim($allapotok,',');
$tempSQL.= " AND ingatlan_allapota IN (".$allapotok.")";
}
if ($search['kornyek']!='') {
$list = explode(",",$search['kornyek']);
$kornyekek = "";
foreach ($list as $kornyek) {
$kornyekek.= "'".$kornyek."',";
}
$kornyekek = rtrim($kornyekek,',');
$tempSQL.= " AND kornyek IN (".$kornyekek.")";
}
if ($search['epites_eve_min']!='') $tempSQL.= " AND epites_eve>='".$search['epites_eve_min']."'";
if ($search['epites_eve_max']!='') $tempSQL.= " AND epites_eve<='".$search['epites_eve_max']."'";
if ($search['telek_min']!='') $tempSQL.= " AND meret_telek>='".$search['telek_min']."'";
if ($search['telek_max']!='') $tempSQL.= " AND meret_telek<='".$search['telek_max']."'";
if ($search['ferohely_garazs_min']!='') $tempSQL.= " AND ferohely_garazs>='".$search['ferohely_garazs_min']."'";
if ($search['ferohely_garazs_max']!='') $tempSQL.= " AND ferohely_garazs<='".$search['ferohely_garazs_max']."'";
if ($search['kulon_nyilo_szobak']=='1') $tempSQL.= " AND kulon_nyilo_szobak='1'";
if ($search['terasz']=='1') $tempSQL.= " AND terasz='1'";
if ($search['erkely']=='1') $tempSQL.= " AND erkely='1'";
if ($search['pince']=='1') $tempSQL.= " AND pince='1'";
if ($search['tarolo']=='1') $tempSQL.= " AND tarolo='1'";
if ($search['garazs']=='1') $tempSQL.= " AND garazs='1'";
if ($search['ferohely_fedettbeallo']=='1') $tempSQL.= " AND ferohely_fedettbeallo='1'";
if ($search['kertkapcsolatos']=='1') $tempSQL.= " AND kertkapcsolatos='1'";
if ($search['viz']=='1') $tempSQL.= " AND viz='1'";
if ($search['gaz']=='1') $tempSQL.= " AND gaz='1'";
if ($search['villany']=='1') $tempSQL.= " AND villany='1'";
if ($search['csatorna']=='1') $tempSQL.= " AND csatorna='1'";
if ($search['lift']=='1') $tempSQL.= " AND lift='1'";
if ($_SESSION['storedPager']=='') $_SESSION['storedPager'] = '0';
$testPager = $_SESSION['storedPager']+5;
$queryPostfix = $tempSQL.$this->getInactiveOffices()." ORDER BY ".$_SESSION['storedOrderField']." ".$_SESSION['storedOrderDirection'];
$result = $this->query($queryPostfix." LIMIT ".$testPager.",5;");
$all = $this->query($queryPostfix.";");
//die($queryPostfix." LIMIT ".$testPager.",5;");
if ($search['szoba_min']!='' || $search['szoba_max']!='') {
foreach ($result as $row) {
$szoba = $row->szoba_fel+$row->szoba_egesz;
if ($szoba>=$search['szoba_min'] && $szoba<=$search['szoba_max']) {
$return[] = $row;
}
}
$result = $return;
}
if ($_SESSION['statusz_switch']=='arcsokkent') {
$return = null;
foreach ($all as $row) {
if ($this->isArcsokkent($row->regszam)) {
$return[] = $row;
}
}
$result = $return;
}
if (sizeof($result)>0) {
return true;
}
else {
return false;
}
}
public function lazy_jumper() {
$_SESSION['storedPager'] = $_SESSION['storedPager']+5;
return true;
}
public function reload_stored_query($search,$nolimit=false) {
$tempSQL = '';
if ($_SESSION['lat_min']!='' && $_SESSION['lat_max']!='' && $_SESSION['lon_min']!='' && $_SESSION['lon_max']!='') {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
googlelat>='".$_SESSION['lat_min']."' AND
googlelat<='".$_SESSION['lat_max']."' AND
googlelon>='".$_SESSION['lon_min']."' AND
googlelon<='".$_SESSION['lon_max']."' AND
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
else {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
if ($search['ertekesites']!='') $tempSQL.= " AND ertekesites='".$search['ertekesites']."'";
//if ($search['jelleg']!='') $tempSQL.= " AND jelleg='".$search['jelleg']."'";
if ($_SESSION['wtf']!='') $tempSQL.= " AND jelleg='".$_SESSION['wtf']."'";
if ($search['tipus']!='') $tempSQL.= " AND tipus='".$search['tipus']."'";
if ($_SESSION['statusz_switch']=='uj') $tempSQL.= " AND jogi_statusz='uj'";
if ($_SESSION['statusz_switch']=='legujabb') $tempSQL.= " AND letrehozva >= DATE(NOW()) - INTERVAL 14 DAY";
if ($search['ertekesites']=='elado') {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000000'";
}
else {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000'";
}
if ($search['meret_netto_min']!='') $tempSQL.= " AND meret_brutto>='".$search['meret_netto_min']."'";
if ($search['meret_netto_max']!='') $tempSQL.= " AND meret_brutto<='".$search['meret_netto_max']."'";
if ($search['altipus']!='') {
$list = explode(",",$search['altipus']);
$altipusok = "";
foreach ($list as $altipus) {
$altipusok.= "'".$altipus."',";
}
$altipusok = rtrim($altipusok,',');
$tempSQL.= " AND altipus IN (".$altipusok.")";
}
if ($search['city']!='') {
$list = explode(",",$search['city']);
$cities = "";
foreach ($list as $city) {
if ($city!='Budapest' && stristr($city," (")==false) {
$cities.= "'".$city."',";
}
}
$cities = rtrim($cities,',');
if ($cities!='') {
$tempSQL.= " AND (telepules IN (".$cities.")";
}
}
if ($search['city']!='') {
$list = explode(",",$search['city']);
$cities = "";
$hasStreet = false;
$utcaSQL = "";
foreach ($list as $city) {
if ($city=='Budapest') {
$tempSQL.= " OR megye='budapest'";
}
elseif (stristr($city," (")) {
if ($hasStreet==false) {
$utcaSQL.= " AND (";
}
$hasStreet = true;
$dtemp = explode(" (",$city);
$varosTemp = str_replace(")","",$dtemp[1]);
$utcaTemp = $dtemp[0];
$utcaSQL.= "(utcanev='".$utcaTemp."' AND telepules='".$varosTemp."') OR ";
}
}
$tempSQL.= ")";
$utcaSQL = rtrim($utcaSQL," OR ");
if ($utcaSQL!='') {
$utcaSQL.= ")";
}
$tempSQL.= $utcaSQL;
}
if ($search['jogi_statusz']!='') $tempSQL.= " AND jogi_statusz='".$search['jogi_statusz']."'";
//if ($search['szoba_min']!='') $tempSQL.= " AND szoba_egesz>='".$search['szoba_min']."'";
//if ($search['szoba_max']!='') $tempSQL.= " AND szoba_egesz<='".$search['szoba_max']."'";
if ($search['kilatas']!='') {
$list = explode(",",$search['kilatas']);
$kilatasok = "";
foreach ($list as $kilatas) {
$kilatasok.= "'".$kilatas."',";
}
$kilatasok = rtrim($kilatasok,',');
$tempSQL.= " AND kilatas IN (".$kilatasok.")";
}
if ($search['futes']!='') {
$list = explode(",",$search['futes']);
$futesek = "";
foreach ($list as $futes) {
$futesek.= "'".$futes."',";
}
$futesek = rtrim($futesek,',');
$tempSQL.= " AND futes IN (".$futesek.")";
}
if ($search['tajolas']!='') {
$list = explode(",",$search['tajolas']);
$tajolasok = "";
foreach ($list as $tajolas) {
$tajolasok.= "'".$tajolas."',";
}
$tajolasok = rtrim($tajolasok,',');
$tempSQL.= " AND tajolas IN (".$tajolasok.")";
}
if ($search['allapot']!='') {
$list = explode(",",$search['allapot']);
$allapotok = "";
foreach ($list as $allapot) {
$allapotok.= "'".$allapot."',";
}
$allapotok = rtrim($allapotok,',');
$tempSQL.= " AND ingatlan_allapota IN (".$allapotok.")";
}
if ($search['kornyek']!='') {
$list = explode(",",$search['kornyek']);
$kornyekek = "";
foreach ($list as $kornyek) {
$kornyekek.= "'".$kornyek."',";
}
$kornyekek = rtrim($kornyekek,',');
$tempSQL.= " AND kornyek IN (".$kornyekek.")";
}
if ($search['epites_eve_min']!='') $tempSQL.= " AND epites_eve>='".$search['epites_eve_min']."'";
if ($search['epites_eve_max']!='') $tempSQL.= " AND epites_eve<='".$search['epites_eve_max']."'";
if ($search['telek_min']!='') $tempSQL.= " AND meret_telek>='".$search['telek_min']."'";
if ($search['telek_max']!='') $tempSQL.= " AND meret_telek<='".$search['telek_max']."'";
if ($search['ferohely_garazs_min']!='') $tempSQL.= " AND ferohely_garazs>='".$search['ferohely_garazs_min']."'";
if ($search['ferohely_garazs_max']!='') $tempSQL.= " AND ferohely_garazs<='".$search['ferohely_garazs_max']."'";
if ($search['kulon_nyilo_szobak']=='1') $tempSQL.= " AND kulon_nyilo_szobak='1'";
if ($search['terasz']=='1') $tempSQL.= " AND terasz='1'";
if ($search['erkely']=='1') $tempSQL.= " AND erkely='1'";
if ($search['pince']=='1') $tempSQL.= " AND pince='1'";
if ($search['tarolo']=='1') $tempSQL.= " AND tarolo='1'";
if ($search['garazs']=='1') $tempSQL.= " AND garazs='1'";
if ($search['ferohely_fedettbeallo']=='1') $tempSQL.= " AND ferohely_fedettbeallo='1'";
if ($search['kertkapcsolatos']=='1') $tempSQL.= " AND kertkapcsolatos='1'";
if ($search['viz']=='1') $tempSQL.= " AND viz='1'";
if ($search['gaz']=='1') $tempSQL.= " AND gaz='1'";
if ($search['villany']=='1') $tempSQL.= " AND villany='1'";
if ($search['csatorna']=='1') $tempSQL.= " AND csatorna='1'";
if ($search['lift']=='1') $tempSQL.= " AND lift='1'";
if ($_SESSION['storedOrderField']=='') $_SESSION['storedOrderField'] = 'letrehozva';
if ($_SESSION['storedOrderDirection']=='') $_SESSION['storedOrderDirection'] = 'DESC';
$queryPostfix = $this->getInactiveOffices()." ORDER BY ".$_SESSION['storedOrderField']." ".$_SESSION['storedOrderDirection'];
//die($tempSQL." ".$queryPostfix);
$tempSQL = str_replace("' OR megye='budapest')","' AND megye='budapest'",$tempSQL);
if ($nolimit) {
$result = $this->query($tempSQL." ".$queryPostfix);
}
else {
$result = $this->query($tempSQL." ".$queryPostfix.$this->lazy_loader());
}
$all = $this->query($tempSQL." ".$queryPostfix);
if ($search['szoba_min']!='' || $search['szoba_max']!='') {
foreach ($result as $row) {
$szoba = $row->szoba_fel+$row->szoba_egesz;
if ($szoba>=$search['szoba_min'] && $szoba<=$search['szoba_max']) {
$return[] = $row;
}
}
$result = $return;
}
if ($_SESSION['statusz_switch']=='arcsokkent') {
$return = null;
foreach ($all as $row) {
if ($this->isArcsokkent($row->regszam)) {
$return[] = $row;
}
}
$result = $return;
}
return $result;
}
public function get_map_all_results($search) {
$tempSQL = '';
if ($_SESSION['lat_min']!='' && $_SESSION['lat_max']!='' && $_SESSION['lon_min']!='' && $_SESSION['lon_max']!='') {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
googlelat>='".$_SESSION['lat_min']."' AND
googlelat<='".$_SESSION['lat_max']."' AND
googlelon>='".$_SESSION['lon_min']."' AND
googlelon<='".$_SESSION['lon_max']."' AND
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
else {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
if ($search['ertekesites']!='') $tempSQL.= " AND ertekesites='".$search['ertekesites']."'";
//if ($search['jelleg']!='') $tempSQL.= " AND jelleg='".$search['jelleg']."'";
if ($_SESSION['wtf']!='') $tempSQL.= " AND jelleg='".$_SESSION['wtf']."'";
if ($search['tipus']!='') $tempSQL.= " AND tipus='".$search['tipus']."'";
if ($_SESSION['statusz_switch']=='uj') $tempSQL.= " AND jogi_statusz='uj'";
if ($_SESSION['statusz_switch']=='legujabb') $tempSQL.= " AND letrehozva >= DATE(NOW()) - INTERVAL 14 DAY";
if ($search['ertekesites']=='elado') {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000000'";
}
else {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000'";
}
if ($search['meret_netto_min']!='') $tempSQL.= " AND meret_brutto>='".$search['meret_netto_min']."'";
if ($search['meret_netto_max']!='') $tempSQL.= " AND meret_brutto<='".$search['meret_netto_max']."'";
if ($search['altipus']!='') {
$list = explode(",",$search['altipus']);
$altipusok = "";
foreach ($list as $altipus) {
$altipusok.= "'".$altipus."',";
}
$altipusok = rtrim($altipusok,',');
$tempSQL.= " AND altipus IN (".$altipusok.")";
}
if ($search['jogi_statusz']!='') $tempSQL.= " AND jogi_statusz='".$search['jogi_statusz']."'";
//if ($search['szoba_min']!='') $tempSQL.= " AND szoba>='".$search['szoba_min']."'";
//if ($search['szoba_max']!='') $tempSQL.= " AND szoba<='".$search['szoba_max']."'";
if ($search['kilatas']!='') {
$list = explode(",",$search['kilatas']);
$kilatasok = "";
foreach ($list as $kilatas) {
$kilatasok.= "'".$kilatas."',";
}
$kilatasok = rtrim($kilatasok,',');
$tempSQL.= " AND kilatas IN (".$kilatasok.")";
}
if ($search['futes']!='') {
$list = explode(",",$search['futes']);
$futesek = "";
foreach ($list as $futes) {
$futesek.= "'".$futes."',";
}
$futesek = rtrim($futesek,',');
$tempSQL.= " AND futes IN (".$futesek.")";
}
if ($search['tajolas']!='') {
$list = explode(",",$search['tajolas']);
$tajolasok = "";
foreach ($list as $tajolas) {
$tajolasok.= "'".$tajolas."',";
}
$tajolasok = rtrim($tajolasok,',');
$tempSQL.= " AND tajolas IN (".$tajolasok.")";
}
if ($search['allapot']!='') {
$list = explode(",",$search['allapot']);
$allapotok = "";
foreach ($list as $allapot) {
$allapotok.= "'".$allapot."',";
}
$allapotok = rtrim($allapotok,',');
$tempSQL.= " AND ingatlan_allapota IN (".$allapotok.")";
}
if ($search['kornyek']!='') {
$list = explode(",",$search['kornyek']);
$kornyekek = "";
foreach ($list as $kornyek) {
$kornyekek.= "'".$kornyek."',";
}
$kornyekek = rtrim($kornyekek,',');
$tempSQL.= " AND kornyek IN (".$kornyekek.")";
}
if ($search['epites_eve_min']!='') $tempSQL.= " AND epites_eve>='".$search['epites_eve_min']."'";
if ($search['epites_eve_max']!='') $tempSQL.= " AND epites_eve<='".$search['epites_eve_max']."'";
if ($search['telek_min']!='') $tempSQL.= " AND meret_telek>='".$search['telek_min']."'";
if ($search['telek_max']!='') $tempSQL.= " AND meret_telek<='".$search['telek_max']."'";
if ($search['ferohely_garazs_min']!='') $tempSQL.= " AND ferohely_garazs>='".$search['ferohely_garazs_min']."'";
if ($search['ferohely_garazs_max']!='') $tempSQL.= " AND ferohely_garazs<='".$search['ferohely_garazs_max']."'";
if ($search['kulon_nyilo_szobak']=='1') $tempSQL.= " AND kulon_nyilo_szobak='1'";
if ($search['terasz']=='1') $tempSQL.= " AND terasz='1'";
if ($search['erkely']=='1') $tempSQL.= " AND erkely='1'";
if ($search['pince']=='1') $tempSQL.= " AND pince='1'";
if ($search['tarolo']=='1') $tempSQL.= " AND tarolo='1'";
if ($search['garazs']=='1') $tempSQL.= " AND garazs='1'";
if ($search['ferohely_fedettbeallo']=='1') $tempSQL.= " AND ferohely_fedettbeallo='1'";
if ($search['kertkapcsolatos']=='1') $tempSQL.= " AND kertkapcsolatos='1'";
if ($search['viz']=='1') $tempSQL.= " AND viz='1'";
if ($search['gaz']=='1') $tempSQL.= " AND gaz='1'";
if ($search['villany']=='1') $tempSQL.= " AND villany='1'";
if ($search['csatorna']=='1') $tempSQL.= " AND csatorna='1'";
if ($search['lift']=='1') $tempSQL.= " AND lift='1'";
$_SESSION['storedPager'] = 0;
if ($_SESSION['storedOrderField']=='') $_SESSION['storedOrderField'] = 'letrehozva';
if ($_SESSION['storedOrderDirection']=='') $_SESSION['storedOrderDirection'] = 'DESC';
//die($tempSQL);
$queryPostfix = $tempSQL.$this->getInactiveOffices()." ORDER BY ".$_SESSION['storedOrderField']." ".$_SESSION['storedOrderDirection'];
$result = $this->query($queryPostfix." ".$this->lazy_loader());
$all = $this->query($queryPostfix.";");
//die('debug: '.count($all));
if ($search['szoba_min']!='' || $search['szoba_max']!='') {
foreach ($result as $row) {
$szoba = $row->szoba_fel+$row->szoba_egesz;
if ($szoba>=$search['szoba_min'] && $szoba<=$search['szoba_max']) {
$return[] = $row;
}
}
$result = $return;
}
if ($_SESSION['statusz_switch']=='arcsokkent') {
$return = null;
foreach ($all as $row) {
if ($this->isArcsokkent($row->regszam)) {
$return[] = $row;
}
}
$result = $return;
}
return $result;
}
public function get_map_all_results_count($search) {
$tempSQL = '';
if ($_SESSION['lat_min']!='' && $_SESSION['lat_max']!='' && $_SESSION['lon_min']!='' && $_SESSION['lon_max']!='') {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
googlelat>='".$_SESSION['lat_min']."' AND
googlelat<='".$_SESSION['lat_max']."' AND
googlelon>='".$_SESSION['lon_min']."' AND
googlelon<='".$_SESSION['lon_max']."' AND
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
else {
$tempSQL = "SELECT *,
CONCAT(iranyitoszam,'.',telepules,',
(',korzet,') ',utcanev) AS name,
googlelat AS lat,
googlelon AS lng FROM
hiper_ingatlan WHERE
statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0')";
}
if ($search['ertekesites']!='') $tempSQL.= " AND ertekesites='".$search['ertekesites']."'";
//if ($search['jelleg']!='') $tempSQL.= " AND jelleg='".$search['jelleg']."'";
if ($_SESSION['wtf']!='') $tempSQL.= " AND jelleg='".$_SESSION['wtf']."'";
if ($search['tipus']!='') $tempSQL.= " AND tipus='".$search['tipus']."'";
if ($_SESSION['statusz_switch']=='uj') $tempSQL.= " AND jogi_statusz='uj'";
if ($_SESSION['statusz_switch']=='legujabb') $tempSQL.= " AND letrehozva >= DATE(NOW()) - INTERVAL 14 DAY";
if ($search['ertekesites']=='elado') {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000000'";
}
else {
if ($search['iranyar_min']!='') $tempSQL.= " AND iranyar>='".$search['iranyar_min']."000'";
if ($search['iranyar_max']!='') $tempSQL.= " AND iranyar<='".$search['iranyar_max']."000'";
}
if ($search['meret_netto_min']!='') $tempSQL.= " AND meret_brutto>='".$search['meret_netto_min']."'";
if ($search['meret_netto_max']!='') $tempSQL.= " AND meret_brutto<='".$search['meret_netto_max']."'";
if ($search['altipus']!='') {
$list = explode(",",$search['altipus']);
$altipusok = "";
foreach ($list as $altipus) {
$altipusok.= "'".$altipus."',";
}
$altipusok = rtrim($altipusok,',');
$tempSQL.= " AND altipus IN (".$altipusok.")";
}
if ($search['jogi_statusz']!='') $tempSQL.= " AND jogi_statusz='".$search['jogi_statusz']."'";
//if ($search['szoba_min']!='') $tempSQL.= " AND szoba>='".$search['szoba_min']."'";
//if ($search['szoba_max']!='') $tempSQL.= " AND szoba<='".$search['szoba_max']."'";
if ($search['kilatas']!='') {
$list = explode(",",$search['kilatas']);
$kilatasok = "";
foreach ($list as $kilatas) {
$kilatasok.= "'".$kilatas."',";
}
$kilatasok = rtrim($kilatasok,',');
$tempSQL.= " AND kilatas IN (".$kilatasok.")";
}
if ($search['futes']!='') {
$list = explode(",",$search['futes']);
$futesek = "";
foreach ($list as $futes) {
$futesek.= "'".$futes."',";
}
$futesek = rtrim($futesek,',');
$tempSQL.= " AND futes IN (".$futesek.")";
}
if ($search['tajolas']!='') {
$list = explode(",",$search['tajolas']);
$tajolasok = "";
foreach ($list as $tajolas) {
$tajolasok.= "'".$tajolas."',";
}
$tajolasok = rtrim($tajolasok,',');
$tempSQL.= " AND tajolas IN (".$tajolasok.")";
}
if ($search['allapot']!='') {
$list = explode(",",$search['allapot']);
$allapotok = "";
foreach ($list as $allapot) {
$allapotok.= "'".$allapot."',";
}
$allapotok = rtrim($allapotok,',');
$tempSQL.= " AND ingatlan_allapota IN (".$allapotok.")";
}
if ($search['kornyek']!='') {
$list = explode(",",$search['kornyek']);
$kornyekek = "";
foreach ($list as $kornyek) {
$kornyekek.= "'".$kornyek."',";
}
$kornyekek = rtrim($kornyekek,',');
$tempSQL.= " AND kornyek IN (".$kornyekek.")";
}
if ($search['epites_eve_min']!='') $tempSQL.= " AND epites_eve>='".$search['epites_eve_min']."'";
if ($search['epites_eve_max']!='') $tempSQL.= " AND epites_eve<='".$search['epites_eve_max']."'";
if ($search['telek_min']!='') $tempSQL.= " AND meret_telek>='".$search['telek_min']."'";
if ($search['telek_max']!='') $tempSQL.= " AND meret_telek<='".$search['telek_max']."'";
if ($search['ferohely_garazs_min']!='') $tempSQL.= " AND ferohely_garazs>='".$search['ferohely_garazs_min']."'";
if ($search['ferohely_garazs_max']!='') $tempSQL.= " AND ferohely_garazs<='".$search['ferohely_garazs_max']."'";
if ($search['kulon_nyilo_szobak']=='1') $tempSQL.= " AND kulon_nyilo_szobak='1'";
if ($search['terasz']=='1') $tempSQL.= " AND terasz='1'";
if ($search['erkely']=='1') $tempSQL.= " AND erkely='1'";
if ($search['pince']=='1') $tempSQL.= " AND pince='1'";
if ($search['tarolo']=='1') $tempSQL.= " AND tarolo='1'";
if ($search['garazs']=='1') $tempSQL.= " AND garazs='1'";
if ($search['ferohely_fedettbeallo']=='1') $tempSQL.= " AND ferohely_fedettbeallo='1'";
if ($search['kertkapcsolatos']=='1') $tempSQL.= " AND kertkapcsolatos='1'";
if ($search['viz']=='1') $tempSQL.= " AND viz='1'";
if ($search['gaz']=='1') $tempSQL.= " AND gaz='1'";
if ($search['villany']=='1') $tempSQL.= " AND villany='1'";
if ($search['csatorna']=='1') $tempSQL.= " AND csatorna='1'";
if ($search['lift']=='1') $tempSQL.= " AND lift='1'";
if ($_SESSION['storedOrderField']=='') $_SESSION['storedOrderField'] = 'letrehozva';
if ($_SESSION['storedOrderDirection']=='') $_SESSION['storedOrderDirection'] = 'DESC';
$queryPostfix = $this->getInactiveOffices()." ORDER BY ".$_SESSION['storedOrderField']." ".$_SESSION['storedOrderDirection'];
$result = $this->query($tempSQL." ".$queryPostfix);
if ($search['szoba_min']!='' || $search['szoba_max']!='') {
foreach ($result as $row) {
$szoba = $row->szoba_fel+$row->szoba_egesz;
if ($szoba>=$search['szoba_min'] && $szoba<=$search['szoba_max']) {
$return[] = $row;
}
}
$result = $return;
}
if ($_SESSION['statusz_switch']=='arcsokkent') {
$return = null;
foreach ($result as $row) {
if ($this->isArcsokkent($row->regszam)) {
$return[] = $row;
}
}
$result = $return;
}
return $result;
}
public function get_ertekesites_tipusok() {
$result = $this->query("SELECT ertekesites FROM hiper_ingatlan WHERE ertekesites<>'' AND statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0') GROUP BY ertekesites ORDER BY ertekesites ASC;");
return $result;
}
public function get_jelleg_tipusok() {
$resultx = $this->query("SELECT tipus FROM hiper_ingatlan WHERE tipus<>'' AND statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0') GROUP BY tipus ORDER BY tipus ASC;");
$resulty = $this->query("SELECT jelleg FROM hiper_ingatlan WHERE jelleg<>'lakoingatlan' AND statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0') GROUP BY jelleg ORDER BY jelleg ASC;");
foreach ($resultx as $row) {
if ($row->tipus=='tarsashazi') {
$row->jelleg = 'Lakóingatlan - '.$row->tipus;
$result[] = $row;
}
}
foreach ($resultx as $row) {
if ($row->tipus!='tarsashazi') {
$row->jelleg = 'Lakóingatlan - '.$row->tipus;
$result[] = $row;
}
}
foreach ($resulty as $row) {
$result[] = $row;
}
return $result;
}
public function get_telepulesek() {
$result = $this->query("SELECT telepules FROM hiper_ingatlan WHERE telepules<>'' AND statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0') GROUP BY telepules ORDER BY telepules ASC;");
return $result;
}
public function isArcsokkent($code) {
if ($code!='') {
$check = $this->query("SELECT * FROM hiper_ingatlan_ertekesites WHERE regszam='".$code."' AND arcsokkenes='1';");
if ($check[0]->arcsokkenes=='1') {
return true;
}
else {
return false;
}
}
else {
return false;
}
}
public function getSearchString() {
if ($_SESSION['search']['ertekesites']=='elado') {
$string = 'Eladó';
}
else {
$string = 'Kiadó';
}
if ($_SESSION['search']['tipus']=='tarsashazi') {
$string.= ' lakás';
}
elseif ($_SESSION['search']['tipus']=='csaladihaz') {
$string.= ' családi ház';
}
elseif ($_SESSION['search']['tipus']=='epuletresz') {
$string.= ' épületrész';
}
elseif ($_SESSION['search']['tipus']=='hazresz') {
$string.= ' házrész';
}
elseif ($_SESSION['search']['tipus']=='ikerhaz') {
$string.= ' ikerház';
}
elseif ($_SESSION['search']['tipus']=='onalloepulet') {
$string.= ' önálló épület';
}
elseif ($_SESSION['search']['tipus']=='teljesepulet') {
$string.= ' teljes épület';
}
elseif ($_SESSION['search']['tipus']=='beruhazasi') {
$string.= ' beruházás';
}
elseif ($_SESSION['search']['tipus']=='garazs') {
$string.= ' garázs';
}
elseif ($_SESSION['search']['tipus']=='kereskedelmi') {
$string.= ' kereskedelmi';
}
elseif ($_SESSION['search']['tipus']=='mezogazdasagi') {
$string.= ' mezőgazdasági';
}
elseif ($_SESSION['search']['tipus']=='tarolo') {
$string.= ' tároló';
}
elseif ($_SESSION['search']['tipus']=='telek') {
$string.= ' telek';
}
$string.= ', ';
$actives = explode(",",$_SESSION['search']['city']);
foreach ($actives as $item) {
if (stristr($item,"Budapest")) {
$string.= $item.'. kerület, ';
}
else {
$string.= $item.', ';
}
}
$string = trim($string,", ");
return $string;
}
}