citywebshop_cms/application/models/suggests_model.php

<?php

class suggests_model extends Model {

    public function getSuggestsProperties($keyword,$limit=true) {
        if ($keyword!='') {
            $keyword = $this->escapeString($keyword);

            if ($limit==true) {
                $postfix = ' LIMIT 0,3';
            }
            else {
                $postfix = '';
            }

            $result = $this->query("SELECT * FROM hiper_ingatlan WHERE 
            statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0') AND (
            regszam LIKE '%".$keyword."%' OR 
            telepules LIKE '%".$keyword."%' OR 
            utcanev LIKE '%".$keyword."%' OR 
            korzet LIKE '%".$keyword."%') ORDER BY id DESC".$postfix.";");

            if (sizeof($result)>0) {
                return $result;
            }
            else {
                return false;
            }
        }
        else {
            return false;
        }
    }


    public function getSuggestsOffices($keyword,$limit=true) {
        if ($keyword!='') {
            $keyword = $this->escapeString($keyword);
            
            if ($limit==true) {
                $postfix = ' LIMIT 0,3';
            }
            else {
                $postfix = '';
            }

            $result = $this->query("SELECT * FROM hiper_iroda WHERE 
            nev LIKE '%".$keyword."%' AND aktiv='1' ORDER BY id DESC".$postfix.";");

            if (sizeof($result)>0) {
                return $result;
            }
            else {
                return false;
            }
        }
        else {
            return false;
        }
    }


    public function getSuggestsAgents($keyword,$limit=true) {
        if ($keyword!='') {
            $keyword = $this->escapeString($keyword);
            
            if ($limit==true) {
                $postfix = ' LIMIT 0,3';
            }
            else {
                $postfix = '';
            }

            $result = $this->query("SELECT * FROM hiper_munkatars WHERE 
            nev LIKE '%".$keyword."%' AND aktiv='1' ORDER BY id DESC".$postfix.";");

            if (sizeof($result)>0) {
                return $result;
            }
            else {
                return false;
            }
        }
        else {
            return false;
        }
    }


    public function getSuggestsPages($keyword,$limit=true) {
        if ($keyword!='') {
            $keyword = $this->escapeString($keyword);
            
            if ($limit==true) {
                $postfix = ' LIMIT 0,3';
            }
            else {
                $postfix = '';
            }

            $result = $this->query("SELECT * FROM azonics_pages WHERE 
            page_status='1' AND 
            (page_title LIKE '%".$keyword."%' OR 
            page_content LIKE '%".$keyword."%') ORDER BY page_id DESC".$postfix.";");

            if (sizeof($result)>0) {
                return $result;
            }
            else {
                return false;
            }
        }
        else {
            return false;
        }
    }


    public function getSugessions($keyword='') {
        if ($keyword!='') {
            $keyword = $this->escapeString($keyword);
            $result1 = $this->query("SELECT telepules AS dataText FROM hiper_ingatlan WHERE telepules LIKE '".$keyword."%' AND statusz='aktualis' AND (rockhomera_mehet='1' OR rockhomera_mehet='0') GROUP BY telepules ORDER BY telepules ASC LIMIT 0,5;");
            $result2 = $this->query("SELECT CONCAT(utcanev,\" (\",telepules,\")\") AS dataText FROM hiper_ingatlan WHERE utcanev LIKE '".$keyword."%' AND (rockhomera_mehet='1' OR rockhomera_mehet='0') AND statusz='aktualis' GROUP BY utcanev ORDER BY utcanev ASC LIMIT 0,5;");
            $result = array_merge($result1,$result2);
            return $result;
        }
        else {
            return false;
        }
    }


}