citywebshop_cms/application/controllers/property.php

<?php

class property extends Controller {

    public function index() {
        //noope
    }

    public function show($id) {
        $temp = explode('-',$id);
        $id = $temp[0];
        
        $model = $this->loadModel('property_model');
        $view = $this->loadView('property_view');
        $data = $model->get_property($id);
        $data->regszam = $data->uniqazonosito;

        if ($model->checkOffice($data->iroda)==false) {
            header("Location: /");
            die();
        }

        if ($data->statusz!='aktualis') {
            header("Location: /");
            die();
        }

        $view->set('data',$data);
        $view->set('id',$id);
        $view->set('leiras',$model->get_property_description($data->regszam));
        $view->set('szlogen',$model->get_property_szlogen($data->regszam));
        if ($data->iroda=='rhp') $data->tanacsado = 'totmel';
        $view->set('agent',$model->get_property_sales($data->tanacsado));
        $view->set('images',$model->get_property_images($data->regszam));
        $view->render();
    }


    public function share($id) {
        $model = $this->loadModel('property_model');
        $data = $model->get_property($id);

        $mail_template = $this->loadView('email_property_view');

        $mail_template->set('data',$data);
        $mail_template->set('nev',$_REQUEST['nev']);
        $mail_template->set('email',$_REQUEST['email']);
        $mail_template->set('leiras',$model->get_property_description($data->regszam));
        if ($data->iroda=='rhp') $data->tanacsado = 'totmel';
        $mail_template->set('agent',$model->get_property_sales($data->tanacsado));

        $mail = new PHPMailer;
        $mail->CharSet = 'UTF-8';
        $mail->isSMTP();
        $mail->Host = 'rockholding.renewcloud.net';
        $mail->SMTPAuth = true;
        $mail->Username = 'rockhome@rockholding.renewcloud.net';
        $mail->Password = 'RBrjH7tmL_8i';
        //$mail->SMTPSecure = 'tls';
        $mail->Port = 25;
        $mail->SMTPDebug  = 0;        

        $mail->From = 'no-reply@rockhome.hu';
        $mail->FromName = 'Rockhome';
        $mail->addAddress($_REQUEST['email']);
        $mail->isHTML(true);
        $mail->Subject = 'Ingatlanhirdetés megosztása';
                
        $mail->Body = $mail_template->getHTML();
        
        $mail->send();

        die('sent');
    }


    public function search($action='') {
        $_SESSION['storedPager']='';
        $model = $this->loadModel('property_model');

        if ($_REQUEST['statusz']=='uj') {
            $_SESSION['statusz_switch'] = 'uj';
        }
        elseif ($_REQUEST['statusz']=='arcsokkent') {
            $_SESSION['statusz_switch'] = 'arcsokkent';
        }
        elseif ($_REQUEST['statusz']=='legujabb') {
            $_SESSION['statusz_switch'] = 'legujabb';
        }
        elseif ($_REQUEST['statusz']=='off') {
            $_SESSION['statusz_switch'] = '';
        }

        if ($action=='loadhistory') {
            $_SESSION['storedPager'] = '0';
            $_SESSION['search'] = $model->getSearchObject($_REQUEST['id']);
        }

        if ($action=='filter' && $_SESSION['search']['jelleg']!=$_REQUEST['jelleg']) {
            $_SESSION['storedPager'] = '0';
            $_SESSION['search'] = null;
        }

        $_SESSION['search']['agent'] = '';
        $_SESSION['search']['office'] = '';

        if ($action=='reorder') {
            $_SESSION['storedPager'] = '0';
            $ordering = explode("_",$_REQUEST['order']);
            $_SESSION['storedOrderField'] = $ordering[0];
            $_SESSION['storedOrderDirection'] = $ordering[1];
            die('ok');
        }
        
        if ($_REQUEST['agent']!='') {
            $_SESSION['storedPager'] = '0';
            $_SESSION['search']['agent'] = $_REQUEST['agent'];
        }

        if ($action=='filter') {
            $_SESSION['storedPager'] = '0';
            if (isset($_REQUEST['ertekesites'])) {
                $_SESSION['search']['ertekesites'] = $_REQUEST['ertekesites'];
            }
            else {
                $_SESSION['search']['ertekesites'] = '';
            }

            if (stristr($_REQUEST['jelleg'],'Lakóingatlan - ')) {
                $temp = explode(" - ",$_REQUEST['jelleg']);
                $_SESSION['search']['jelleg'] = 'lakoingatlan';
                $_SESSION['search']['tipus'] = $temp[1];
            }
            else {
                $_SESSION['search']['jelleg'] = $_REQUEST['jelleg'];
                $_SESSION['search']['tipus'] = '';
            }
            
            if (is_array($_REQUEST['city'])) {
                $_SESSION['search']['city'] = implode(",",$_REQUEST['city']);
            }
            else {
                $_SESSION['search']['city'] = $_REQUEST['city'];
            }

            $_SESSION['search']['city'] = str_replace("budapest","Budapest",$_SESSION['search']['city']);

            $_SESSION['search']['iranyar_min'] = $_REQUEST['iranyar_min'];
            $_SESSION['search']['iranyar_max'] = $_REQUEST['iranyar_max'];
            $_SESSION['search']['meret_netto_min'] = $_REQUEST['meret_netto_min'];
            $_SESSION['search']['meret_netto_max'] = $_REQUEST['meret_netto_max'];
            $_SESSION['search']['category'] = $_SERVER['REQUEST_URI'];

            if ($_REQUEST['from']!='') $_SESSION['search']['from'] = $_REQUEST['from'];
            
            if (isset($_REQUEST['altipus']) && $_REQUEST['altipus']!='undefined') {
                if (is_array($_REQUEST['altipus'])) {
                    $_SESSION['search']['altipus'] = implode(",",$_REQUEST['altipus']);
                }
                else {
                    $_SESSION['search']['altipus'] = $_REQUEST['altipus'];
                }
            }
            else {
                $_SESSION['search']['altipus'] = '';
            }

            if (isset($_REQUEST['jogi_statusz']) && $_REQUEST['jogi_statusz']!='undefined') { $_SESSION['search']['jogi_statusz'] = $_REQUEST['jogi_statusz']; } else { $_SESSION['search']['jogi_statusz'] = ''; }
            if (isset($_REQUEST['szoba_min']) && $_REQUEST['szoba_min']!='undefined') { $_SESSION['search']['szoba_min'] = $_REQUEST['szoba_min']; } else { $_SESSION['search']['szoba_min'] = ''; }
            if (isset($_REQUEST['szoba_max']) && $_REQUEST['szoba_max']!='undefined') { $_SESSION['search']['szoba_max'] = $_REQUEST['szoba_max']; } else { $_SESSION['search']['szoba_max'] = ''; }
            if (isset($_REQUEST['kilatas']) && $_REQUEST['kilatas']!='undefined') { $_SESSION['search']['kilatas'] = $_REQUEST['kilatas']; } else { $_SESSION['search']['kilatas'] = ''; }
            if (isset($_REQUEST['futes']) && $_REQUEST['futes']!='undefined') { $_SESSION['search']['futes'] = $_REQUEST['futes']; } else { $_SESSION['search']['futes'] = ''; }
            if (isset($_REQUEST['epites_eve_min']) && $_REQUEST['epites_eve_min']!='undefined') { $_SESSION['search']['epites_eve_min'] = $_REQUEST['epites_eve_min']; } else { $_SESSION['search']['epites_eve_min'] = ''; }
            if (isset($_REQUEST['epites_eve_max']) && $_REQUEST['epites_eve_max']!='undefined') { $_SESSION['search']['epites_eve_max'] = $_REQUEST['epites_eve_max']; } else { $_SESSION['search']['epites_eve_max'] = ''; }
            if (isset($_REQUEST['ferohely_garazs_min']) && $_REQUEST['ferohely_garazs_min']!='undefined') { $_SESSION['search']['ferohely_garazs_min'] = $_REQUEST['ferohely_garazs_min']; } else { $_SESSION['search']['ferohely_garazs_min'] = ''; }
            if (isset($_REQUEST['ferohely_garazs_max']) && $_REQUEST['ferohely_garazs_max']!='undefined') { $_SESSION['search']['ferohely_garazs_max'] = $_REQUEST['ferohely_garazs_max']; } else { $_SESSION['search']['ferohely_garazs_max'] = ''; }

            if (isset($_REQUEST['kulon_nyilo_szobak']) && $_REQUEST['kulon_nyilo_szobak']!='undefined') { $_SESSION['search']['kulon_nyilo_szobak'] = $_REQUEST['kulon_nyilo_szobak']; } else { $_SESSION['search']['kulon_nyilo_szobak'] = ''; }
            if (isset($_REQUEST['terasz']) && $_REQUEST['terasz']!='undefined') { $_SESSION['search']['terasz'] = $_REQUEST['terasz']; } else { $_SESSION['search']['terasz'] = ''; }
            if (isset($_REQUEST['erkely']) && $_REQUEST['erkely']!='undefined') { $_SESSION['search']['erkely'] = $_REQUEST['erkely']; } else { $_SESSION['search']['erkely'] = ''; }
            if (isset($_REQUEST['pince']) && $_REQUEST['pince']!='undefined') { $_SESSION['search']['pince'] = $_REQUEST['pince']; } else { $_SESSION['search']['pince'] = ''; }
            if (isset($_REQUEST['tarolo']) && $_REQUEST['tarolo']!='undefined') { $_SESSION['search']['tarolo'] = $_REQUEST['tarolo']; } else { $_SESSION['search']['tarolo'] = ''; }
            if (isset($_REQUEST['garazs']) && $_REQUEST['garazs']!='undefined') { $_SESSION['search']['garazs'] = $_REQUEST['garazs']; } else { $_SESSION['search']['garazs'] = ''; }
            if (isset($_REQUEST['ferohely_fedettbeallo']) && $_REQUEST['ferohely_fedettbeallo']!='undefined') { $_SESSION['search']['ferohely_fedettbeallo'] = $_REQUEST['ferohely_fedettbeallo']; } else { $_SESSION['search']['ferohely_fedettbeallo'] = ''; }
            if (isset($_REQUEST['kertkapcsolatos']) && $_REQUEST['kertkapcsolatos']!='undefined') { $_SESSION['search']['kertkapcsolatos'] = $_REQUEST['kertkapcsolatos']; } else { $_SESSION['search']['kertkapcsolatos'] = ''; }
            if (isset($_REQUEST['viz']) && $_REQUEST['viz']!='undefined') { $_SESSION['search']['viz'] = $_REQUEST['viz']; } else { $_SESSION['search']['viz'] = ''; }
            if (isset($_REQUEST['gaz']) && $_REQUEST['gaz']!='undefined') { $_SESSION['search']['gaz'] = $_REQUEST['gaz']; } else { $_SESSION['search']['gaz'] = ''; }
            if (isset($_REQUEST['villany']) && $_REQUEST['villany']!='undefined') { $_SESSION['search']['villany'] = $_REQUEST['villany']; } else { $_SESSION['search']['villany'] = ''; }
            if (isset($_REQUEST['csatorna']) && $_REQUEST['csatorna']!='undefined') { $_SESSION['search']['csatorna'] = $_REQUEST['csatorna']; } else { $_SESSION['search']['csatorna'] = ''; }
            if (isset($_REQUEST['lift']) && $_REQUEST['lift']!='undefined') { $_SESSION['search']['lift'] = $_REQUEST['lift']; } else { $_SESSION['search']['lift'] = ''; }

            if (isset($_REQUEST['tajolas']) && $_REQUEST['tajolas']!='undefined') { $_SESSION['search']['tajolas'] = $_REQUEST['tajolas']; } else { $_SESSION['search']['tajolas'] = ''; }
            if (isset($_REQUEST['allapot']) && $_REQUEST['allapot']!='undefined') { $_SESSION['search']['allapot'] = $_REQUEST['allapot']; } else { $_SESSION['search']['allapot'] = ''; }
            if (isset($_REQUEST['kornyek']) && $_REQUEST['kornyek']!='undefined') { $_SESSION['search']['kornyek'] = $_REQUEST['kornyek']; } else { $_SESSION['search']['kornyek'] = ''; }
            if (isset($_REQUEST['telek_min']) && $_REQUEST['telek_min']!='undefined') { $_SESSION['search']['telek_min'] = $_REQUEST['telek_min']; } else { $_SESSION['search']['telek_min'] = ''; }
            if (isset($_REQUEST['telek_max']) && $_REQUEST['telek_max']!='undefined') { $_SESSION['search']['telek_max'] = $_REQUEST['telek_max']; } else { $_SESSION['search']['telek_max'] = ''; }
            if (isset($_REQUEST['ovezet']) && $_REQUEST['ovezet']!='undefined') { $_SESSION['search']['ovezet'] = $_REQUEST['ovezet']; } else { $_SESSION['search']['ovezet'] = ''; }
        }

        $view = $this->loadView('property_grid_view');
        $result = $model->get_property_list($_SESSION['search']);
        
        if ($model->lazy_has_more($_SESSION['search'])) {
            $view->set('loaderBtn','<button class="btn-black showmore" name="show_more" id="show_more" onclick="lazyShowMoreGrid($(this))">További találatok mutatása</button>');
        }
        else {
            $view->set('loaderBtn','');
        }

        $view->set('ajax',$_REQUEST['ajax']);
        $view->set('properties',$result['list']);
        $view->set('searchTitle',$result['title']);
        $view->set('searchResultsCount',$result['count']);
        $view->set('ertekesites',$model->get_ertekesites_tipusok());
        $view->set('jelleg',$model->get_jelleg_tipusok());
        $view->set('city',$model->get_telepulesek());
        $view->set('altipus',$model->get_altipusok($_SESSION['search']['tipus']));
        $view->set('jog',$model->get_jog());
        $view->set('kilatas',$model->get_kilatas());
        $view->set('futes',$model->get_futes());
        $view->set('ovezet',$model->get_ovezet());
        
        $view->set('keresesi_szoveg',$model->getSearchString());

        $view->render();
    }


    public function lazyLoad($action='') {
        $model = $this->loadModel('property_model');
        $model->lazy_jumper();

        if ($action=='justmobile') {
            $view = $this->loadView('ajax_grid_mobile_view');
        }
        else {
            $view = $this->loadView('ajax_grid_view');
        }
        
        if ($model->lazy_has_more($_SESSION['search'])) {
            //$view->set('loaderBtn','<button class="btn-black showmore" name="show_more" id="show_more" onclick="lazyShowMoreGrid($(this))">További találatok mutatása</button>');
            $result = $model->get_property_list($_SESSION['search']);
            $view->set('loaderBtn','');
        }
        else {
            $result['list'] = null;
            $view->set('loaderBtn','');
        }

        $view->set('properties',$result['list']);
        $view->render();
    }


    public function setdetailed($do='') {
        $model = $this->loadModel('property_model');
        $tipus = $_REQUEST['tipus'];
        $origin = $_REQUEST['origin'];

        if ($tipus!='') {
            if (stristr($tipus,'Lakóingatlan - ')) {
                $temp = explode(" - ",$tipus);
                $_SESSION['search']['jelleg'] = 'lakoingatlan';
                $_SESSION['search']['tipus'] = $temp[1];
            }
            else {
                $_SESSION['search']['jelleg'] = $_REQUEST['jelleg'];
                $_SESSION['search']['tipus'] = '';
            }
        }

        if (stristr($tipus,'Lakóingatlan - ')) {
            if ($tipus=='Lakóingatlan - tarsashazi') {
                $view = $this->loadView('property_detailed_search_tarsashaz');
            }
            else {
                $view = $this->loadView('property_detailed_search_csaladihaz');
            }
        }
        else {
            $view = $this->loadView('property_detailed_search_'.$tipus);
        }

        $_SESSION['search']['altipus'] = '';
        $_SESSION['search']['jogi_statusz'] = '';
        $_SESSION['search']['szoba_min'] = '';
        $_SESSION['search']['szoba_max'] = '';
        $_SESSION['search']['kilatas'] = '';
        $_SESSION['search']['futes'] = '';
        $_SESSION['search']['epites_eve_min'] = '';
        $_SESSION['search']['epites_eve_max'] = '';
        $_SESSION['search']['ferohely_garazs_min'] = '';
        $_SESSION['search']['ferohely_garazs_max'] = '';

        $_SESSION['search']['kulon_nyilo_szobak'] = '';
        $_SESSION['search']['terasz'] = '';
        $_SESSION['search']['erkely'] = '';
        $_SESSION['search']['pince'] = '';
        $_SESSION['search']['tarolo'] = '';
        $_SESSION['search']['garazs'] = '';
        $_SESSION['search']['ferohely_fedettbeallo'] = '';
        $_SESSION['search']['kertkapcsolatos'] = '';
        $_SESSION['search']['viz'] = '';
        $_SESSION['search']['gaz'] = '';
        $_SESSION['search']['villany'] = '';
        $_SESSION['search']['csatorna'] = '';
        $_SESSION['search']['lift'] = '';

        $_SESSION['search']['tajolas'] = '';
        $_SESSION['search']['allapot'] = '';
        $_SESSION['search']['kornyek'] = '';
        $_SESSION['search']['ovezet'] = '';
        $_SESSION['search']['telek_min'] = '';
        $_SESSION['search']['telek_max'] = '';

        $view->set('altipus',$model->get_altipusok($_SESSION['search']['tipus']));
        $view->set('jog',$model->get_jog());
        $view->set('kilatas',$model->get_kilatas());
        $view->set('futes',$model->get_futes());
        $view->set('ovezet',$model->get_ovezet());

        if ($origin=='map') {
            $view->set('action','/map/search/filter/');
        }
        elseif ($origin=='offices') {
            $view->set('action','/offices/properties/filter/');
        }
        elseif ($origin=='agents') {
            $view->set('action','/agents/properties/filter/');
        }
        else {
            $view->set('action','/property/search/filter/');
        }

        $view->render();
    }


    public function detailed($do='') {
        $model = $this->loadModel('property_model');
        $tipus = $_REQUEST['tipus'];
        $origin = $_REQUEST['origin'];

        if ($tipus!='') {
            if (stristr($tipus,'Lakóingatlan - ')) {
                $temp = explode(" - ",$tipus);
                $_SESSION['search']['jelleg'] = 'lakoingatlan';
                $_SESSION['search']['tipus'] = $temp[1];
            }
            else {
                if ($_REQUEST['jelleg']!='') {
                    $_SESSION['search']['jelleg'] = $_REQUEST['jelleg'];
                }
                $_SESSION['search']['tipus'] = '';
            }
        }

        if (stristr($tipus,'Lakóingatlan - ')) {
            if ($tipus=='Lakóingatlan - tarsashazi') {
                $view = $this->loadView('property_detailed_search_tarsashaz');
            }
            else {
                $view = $this->loadView('property_detailed_search_csaladihaz');
            }
        }
        else {
            $view = $this->loadView('property_detailed_search_'.$tipus);
        }

        $view->set('altipus',$model->get_altipusok($_SESSION['search']['tipus']));
        $view->set('jog',$model->get_jog());
        $view->set('kilatas',$model->get_kilatas());
        $view->set('futes',$model->get_futes());
        $view->set('ovezet',$model->get_ovezet());

        if ($origin=='map') {
            $view->set('action','/map/search/filter/');
        }
        elseif ($origin=='offices') {
            $view->set('action','/offices/properties/filter/');
        }
        elseif ($origin=='agents') {
            $view->set('action','/agents/properties/filter/');
        }
        else {
            $view->set('action','/property/search/filter/');
        }

        $view->render();
    }


    public function clearsearch() {
        $jelleg = $_SESSION['search']['jelleg'];
        $tipus = $_SESSION['search']['tipus'];
        $ertekesites = $_SESSION['search']['ertekesites'];
        $_SESSION['search'] = null;
        $_SESSION['search']['jelleg'] = $jelleg;
        $_SESSION['search']['tipus'] = $tipus;
        $_SESSION['search']['ertekesites'] = $ertekesites;
        echo 'ok';
    }


    public function sendcontact($propid) {
        $model = $this->loadModel('property_model');

        if ($_REQUEST['fname']!='' && $_REQUEST['lname']!='' && $_REQUEST['phone']!='') {
            $property = $model->get_property($propid);
            if ($property->iroda=='rhp') $property->tanacsado = 'totmel';
            $agent = $model->get_property_sales($property->tanacsado);
            print_r($agent);
            die();

            $mail_template = $this->loadView('mail_agent_contact_property');

            $mail = new PHPMailer;
            $mail->CharSet = 'UTF-8';
            $mail->From = 'no-reply@rockhome.hu';
            $mail->FromName = 'Rockhome';
            $mail->addAddress($agent->email);
            $mail->addBCC('szisz1982@gmail.com');
            $mail->isHTML(true);
            $mail->Subject = 'Kapcsolat felvétel';
            
            $mail_template->set('agent',$agent);
            $mail_template->set('property',$property);
            $mail_template->set('ctype',$_REQUEST['ctype']);
            $mail_template->set('fname',$_REQUEST['fname']);
            $mail_template->set('lname',$_REQUEST['lname']);
            $mail_template->set('email',$_REQUEST['email']);
            $mail_template->set('phone',$_REQUEST['phone']);
            $mail_template->set('message',$_REQUEST['message']);
            
            $mail->Body = $mail_template->getHTML();
            
            $mail->send();
        }
    }


    public function pdfexport($id='') {
        $model = $this->loadModel('property_model');
        if ($_REQUEST['landscape']=='y') {
            $view = $this->loadView('pdf_property_landscape');
        }
        else {
            $view = $this->loadView('pdf_property');
        }

        $data = $model->get_property($id);
        $images = $model->get_property_images($data->regszam);
        $alap = $model->get_property_alaprajz($data->regszam);
        $view->set('data',$data);
        $view->set('leiras',$model->get_property_description($data->regszam));
        $view->set('szlogen',$model->get_property_szlogen($data->regszam));
        if ($data->iroda=='rhp') $data->tanacsado = 'totmel';
        $view->set('agent',$model->get_property_sales($data->tanacsado));
        $view->set('office',$model->get_office($data->iroda));
        $view->set('img1',$images[0]->fajlnev);
        $view->set('img2',$images[1]->fajlnev);
        $view->set('img3',$images[2]->fajlnev);
        $view->set('alaprajz',$alap[0]->fajlnev);
        $view->set('price',formatize::currency_in_million($data->iranyar));
        $view->set('price_postfix',' Ft');
        $view->set('print',$_REQUEST['print']);
        
        $html = $view->getHTML();
        die($html);

        /*$pdf = new HTML2PDF('P','A4','fr',true,'UTF-8',array(5,5,5,5));
        $pdf->WriteHTML($html);
        $fname = "static/pdf/".time().".pdf";
        $pdf->Output($fname,'F');
        echo $fname;*/
    }


    public function download($action='') {
        $filePath = $_REQUEST['file'];
        if(file_exists($filePath)) {
            $fileName = basename($filePath);
            $fileSize = filesize($filePath);
            header("Cache-Control: private");
            header("Content-Type: application/stream");
            header("Content-Length: ".$fileSize);
            header("Content-Disposition: attachment; filename=".$fileName);
            readfile($filePath);
            exit();
        }
        else {
            die('Hiba a fájl letöltésekor...');
        }
    }


}