citywebshop_cms/application/controllers/offices.php

<?php

class offices extends Controller {

    public function index() {
        $model = $this->loadModel('offices_model');
        $view = $this->loadView('offices_list_view');

        $view->set('officeCount',$model->getOfficesCount());
        $view->set('offices',$model->getOfficesList());
        $view->set('city',$model->get_telepulesek());
        $view->set('names',$model->getOfficeNames());

        $view->render();
    }


    public function getrawlist() {
        $model = $this->loadModel('offices_model');
        $data['list'] = $model->getOfficesList();
        echo json_encode($data);
        exit;
    }


    public function reorder($action='') {
        if ($action=='change') {
            $ordering = explode("_",$_REQUEST['order']);
            $_SESSION['storedOfficeOrderField'] = $ordering[0];
            $_SESSION['storedOfficeOrderDirection'] = $ordering[1];
            die('ok');
        }
    }


    public function search($action='') {
        if ($action=='filter') {
            $_SESSION['search']['city'] = $_REQUEST['city'];
            $_SESSION['search']['officename'] = $_REQUEST['name'];
            $_SESSION['search']['category'] = $_SERVER['REQUEST_URI'];
            if ($_REQUEST['from']!=='') $_SESSION['search']['from'] = $_REQUEST['from'];
        }

        $model = $this->loadModel('offices_model');
        $view = $this->loadView('offices_list_view');

        $list = $model->getOfficesListSearch($_SESSION['search']);
        $view->set('offices',$list);
        $view->set('officeCount',$model->getOfficesCountSearch($list));
        $view->set('city',$model->get_telepulesek());
        $view->set('names',$model->getOfficeNames());

        $view->render();
    }


    public function show($id) {
        $temp = explode('-',$id);
        $id = $temp[0];
        $model = $this->loadModel('offices_model');
        $view = $this->loadView('office_view');
        $data = $model->getOffice($id);

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

        $_SESSION['search']['office'] = $data->azonosito;
        
        $view->set('office',$data);
        $view->set('officeProertiesCount',$model->getOfficePropertiesCount($data->azonosito));
        $view->set('officeProperties',$model->getOfficePropertiesList($data->azonosito));
        $view->set('ertekesites',$model->get_ertekesites_tipusok());
        $view->set('jelleg',$model->get_jelleg_tipusok());
        $view->set('city',$model->get_properties_telepulesek());
        $view->set('teruletek',$model->get_teruletek($data->partner));
        $view->set('bemutatkozas',$model->get_bemutatkozas($data->azonosito));
        $view->set('pixelid',$model->get_pixelid($data->azonosito));
        $view->render();
    }


    public function rate($action='') {
        $model = $this->loadModel('office_model');
        if ($action=='set') {
            echo $model->addRate($_REQUEST);
            die();
        }
    }


    public function properties($action='') {
        if ($action=='reorder') {
            $ordering = explode("_",$_REQUEST['order']);
            $_SESSION['storedOrderField'] = $ordering[0];
            $_SESSION['storedOrderDirection'] = $ordering[1];
            die('ok');
        }
        elseif ($action=='filter') {
            $model = $this->loadModel('offices_model');
            $view = $this->loadView('office_properties_view');
            
            $_SESSION['storedPager'] = '0';
            if (isset($_REQUEST['ertekesites'])) {
                $_SESSION['search']['ertekesites'] = $_REQUEST['ertekesites'];
            }
            else {
                $_SESSION['search']['ertekesites'] = '';
            }

            $_SESSION['search']['office'] = $model->getOfficeUserName($_REQUEST['origin']);

            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']['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'];

            $_SESSION['search']['szoba_min'] = $_REQUEST['szoba_min'];
            $_SESSION['search']['szoba_max'] = $_REQUEST['szoba_max'];

            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'] = ''; }
            
            $result = $model->get_property_list_by_filter($_SESSION['search']);
            
            $view->set('officeProperties',$result);
            $view->set('searchResultsCount',sizeof($result));
    
            $view->render();    
        }
    }


    public function sendcontact($officeid) {
        if ($_REQUEST['fname']!='' && $_REQUEST['lname']!='' && $_REQUEST['phone']!='') {
            $model = $this->loadModel('offices_model');
            $office = $model->getOffice($officeid);

            $mail_template = $this->loadView('mail_office_contact');
            
            $mail = new PHPMailer;
            $mail->CharSet = 'UTF-8';
            $mail->From = 'no-reply@rockhome.hu';
            $mail->FromName = 'Rockhome.hu';
            $mail->addAddress($office->email);
            $mail->isHTML(true);
            $mail->Subject = 'Érdeklődés a Rockhome oldaláról';
            
            $mail_template->set('name',$_REQUEST['fname'].' '.$_REQUEST['lname']);
            $mail_template->set('email',$_REQUEST['email']);
            $mail_template->set('tel',$_REQUEST['phone']);
            $mail_template->set('ctype',$_REQUEST['ctype']);
            $mail_template->set('message',$_REQUEST['message']);
            $mail_template->set('office_name',$office->nev);
            
            $mail->Body = $mail_template->getHTML();
            
            $mail->send();
        }
    }


    public function pdfexport($id='') {
        $model = $this->loadModel('offices_model');
        $view = $this->loadView('pdf_office');

        $data = $model->getOffice($id);
        $view->set('data',$data);
        $view->set('agents',$model->getOfficeAgents($data->azonosito));
        $view->set('properties',$model->getOfficePropertiesListShort($data->azonosito));
        $html = $view->getHTML();
        $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;
    }


}