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; } }