citywebshop_cms/application/controllers/agents.php

<?php

class agents extends Controller {

    public function index() {
        if ($id!=='') {
            $model = $this->loadModel('agents_model');
            $view = $this->loadView('agents_list_view');

            $_SESSION['activeOffice'] = '';

            $office = $model->getOffice($id);

            $view->set('agents',$model->getAgentsList());
            $view->set('officeName',$office->nev);
            $view->set('agentsCount',$model->getAgentsCount());
            $view->set('city',$model->get_telepulesek());
            $view->set('names',$model->get_names());

            $view->render();
        }
    }


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


    public function search($action='') {
        if ($action=='filter') {
            if (isset($_REQUEST['city'])) {
                $_SESSION['search']['city'] = $_REQUEST['city'];
            }
            else {
                $_SESSION['search']['city'] = '';
            }

            $_SESSION['search']['category'] = $_SERVER['REQUEST_URI'];
            if ($_REQUEST['from']!='') $_SESSION['search']['from'] = $_REQUEST['from'];
            
            if (isset($_REQUEST['name'])) {
                $_SESSION['search']['name'] = $_REQUEST['name'];
            }
            else {
                $_SESSION['search']['name'] = '';
            }
        }

        $model = $this->loadModel('agents_model');
        $view = $this->loadView('agents_list_view');

        $list = $model->getAgentsListSearch($_SESSION['search']);
        $view->set('agents',$list);
        $view->set('agentsCount',$model->getAgentsCountSearch($list));
        $view->set('city',$model->get_telepulesek());
        $view->set('names',$model->get_names());

        $view->render();
    }


    public function office($id) {
        if ($id!=='') {
            $_SESSION['activeOffice'] = $id;

            $model = $this->loadModel('agents_model');
            $view = $this->loadView('agents_list_office_view');

            $office = $model->getOffice($id);

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

            $view->set('agents',$model->getAgentsByOffice($id));
            $view->set('officeName',$office->nev);
            $view->set('agentsCount',$model->getAgentsCountByOffice($id));
            $view->set('city',$model->get_telepulesek());
            $view->set('names',$model->get_names());

            $view->render();
        }
    }


    public function show($id) {
        $temp = explode('-',$id);
        $id = $temp[0];

        $model = $this->loadModel('agents_model');
        $view = $this->loadView('agent_view');

        $agent = $model->getAgent($id);
        $office = $model->getOffice($agent->iroda);

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

        $properties = $model->getPropertiesList($agent->felhasznalonev);
        $view->set('agent',$agent);
        $view->set('officeName',$office->nev);
        $view->set('properties',$properties);
        $view->set('agentPropertiesCount',$model->getAgentPropertiesCount($agent->felhasznalonev));
        $view->set('ertekesites',$model->get_ertekesites_tipusok());
        $view->set('jelleg',$model->get_jelleg_tipusok());
        $view->set('city',$model->get_properties_telepulesek());
        $view->set('comments',$model->get_comments($id));
        $view->set('referens',$model->get_referens($id));
        $view->set('languages',implode(', ',$model->get_agent_languages($agent->felhasznalonev)));

        $view->render();
    }


    public function vcard($agentid) {
        $model = $this->loadModel('agents_model');
        $agent = $model->getAgent($agentid);
        $fname = $agent->nev;
        $fullname = $agent->nev;
        $iroda = $model->getOffice($agent->iroda);
    
        header('Content-Type: text/x-vcard');
        header('Content-Disposition: inline; filename="'.$fname.'.vcf"');
        
$vcard = "BEGIN:VCARD
VERSION:3.0
FN;CHARSET=UTF-8:".$fullname." ".$iroda->nev."
EMAIL;CHARSET=UTF-8;type=HOME,INTERNET:".$agent->email."
EMAIL;CHARSET=UTF-8;type=WORK,INTERNET:".$agent->email."
PHOTO;ENCODING=b;TYPE=JPG:".base64_encode(file_get_contents('https://prod.rockhome.hu/pictures/munkatars/'.$agent->felhasznalonev.'.jpg'))."
TEL;TYPE=HOME,VOICE:".$agent->cc_telefon."
TEL;TYPE=WORK,VOICE:".$agent->telefon."
ADR;CHARSET=UTF-8;TYPE=HOME:;;".$agent->cim_utca_hazszam.";".$agent->cim_telepules.";Magyarország;".$agent->cim_iranyitoszam.";Magyarország
TITLE;CHARSET=UTF-8:".$agent->titulus_tipus."
ORG;CHARSET=UTF-8:".$fullname." ".$iroda->nev."
URL;type=WORK;CHARSET=UTF-8:https://www.rockhome.hu
REV:2023-06-30T08:52:37.398Z
END:VCARD
";
    
        echo $vcard;
    }


    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('agents_model');
            $view = $this->loadView('agent_properties_view');

            $_SESSION['storedPager'] = '0';
            
            $_SESSION['search']['agent'] = $model->getAgentUserName($_REQUEST['origin']);

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


    public function sendcontact($agentid) {
        if ($_REQUEST['fname']!='' && $_REQUEST['lname']!='' && $_REQUEST['phone']!='') {
            $model = $this->loadModel('agents_model');
            $agent = $model->getAgent($agentid);

            $mail_template = $this->loadView('mail_agent_contact');
            
            $mail = new PHPMailer;
            $mail->CharSet = 'UTF-8';
            $mail->From = 'no-reply@rockhome.hu';
            $mail->FromName = 'Rockhome.hu';
            $mail->addAddress($agent->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('agent_name',$agent->nev);
            
            $mail->Body = $mail_template->getHTML();

            $mail->send();
        }
    }



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

        $data = $model->getAgent($id);
        $view->set('data',$data);
        $view->set('office',$model->getOffice($data->iroda));
        $view->set('properties',$model->getPropertiesListShort($data->felhasznalonev));
        $view->set('referens',$model->get_referens($data->id));
        $view->set('comments',$model->get_comments($data->id));
        
        $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;
    }

    
}