citywebshop_cms/application/models/map_model.php

<?php

class map_model extends Model {

    public function get_map_results($lat_min,$lat_max,$lon_min,$lon_max,$search) {
        //die(print_r($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,',<br> (',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,',<br> (',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,',<br> (',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,',<br> (',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,',<br> (',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,',<br> (',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,',<br> (',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,',<br> (',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,',<br> (',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,',<br> (',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,',<br> (',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,',<br> (',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,',<br> (',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;
    }


}