system/modules/hideaway/classes/Hideaway.php line 490

Open in your IDE?
  1. <?php
  3. /**
  4. * Contao Open Source CMS
  5. *
  6. * Copyright (c) 2005-2014 Leo Feyer
  7. *
  8. * @package hideaway
  9. * @author hideaway
  10. * @license hideaway
  11. * @copyright hideaway
  12. */
  15. /**
  16. * Namespace
  17. */
  18. namespace hideaway;
  21. /**
  22. * Class Hideaway
  23. *
  24. * @copyright hideaway
  25. * @author hideaway
  26. * @package Devtools
  27. */
  28. class Hideaway extends \Backend
  29. {
  31. /**
  32. * Template
  33. * @var string
  34. */
  35. protected $strTemplate = '';
  38. public function __construct()
  39. {
  40. parent::__construct();
  41. }
  43. public function generateAlias($varValue, \DataContainer $dc)
  44. {
  45. $autoAlias = false;
  47. // Generate an alias if there is none
  48. if ($varValue == '')
  49. {
  50. $autoAlias = true;
  51. $varValue = standardize(\StringUtil::restoreBasicEntities($dc->activeRecord->title));
  52. }
  54. $objAlias = $this->Database->prepare("SELECT id FROM ".$dc->table." WHERE alias=?")
  55. ->execute($varValue);
  57. // Check whether the page alias exists
  58. if ($objAlias->numRows > 1)
  59. {
  60. $varValue .= '-' . $dc->id;
  61. }
  63. return $varValue;
  64. }
  67. public function getCombiOptions()
  68. {
  69. $ret = array('0'=>'');
  70. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_hotel WHERE published=1 ORDER BY title")
  71. ->execute();
  72. while($obj->next())
  73. {
  74. $ret['h_'.$obj->id] = 'Hotel: '.$obj->title;
  75. }
  77. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_travel WHERE published=1 ORDER BY title")
  78. ->execute();
  79. while($obj->next())
  80. {
  81. $ret['t_'.$obj->id] = 'Reise: '.$obj->title;
  82. }
  84. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_trip WHERE published=1 ORDER BY title")
  85. ->execute();
  86. while($obj->next())
  87. {
  88. $ret['tr_'.$obj->id] = 'Ausflug: '.$obj->title;
  89. }
  91. return $ret;
  92. }
  94. public function getNavigation($countryPage, $regionPage)
  95. {
  97. $ret = array();
  98. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_country WHERE published=1 ORDER BY sorting")
  99. ->execute();
  101. $objParent = \PageModel::findById($countryPage);
  103. while ($obj->next())
  104. {
  105. $row = $obj->row();
  107. $t = array(
  108. 'row' => $row,
  109. // 'url' => $this->generateFrontendUrl($objParent->row(), ($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$row['alias'], $objParent->language),
  110. 'url' => '/reisen/'.$row['alias'].'/',
  111. 'regions' => $this->getRegionNavigation($regionPage, $row['id'], $row['alias'])
  112. );
  113. if($obj->single_region > 0)
  114. $t['regions'] = array();
  116. array_push($ret, $t);
  117. }
  119. return $ret;
  120. }
  122. public function getFilter()
  123. {
  124. $regions = array();
  125. $types = array();
  127. /*
  128. if(!$this->Input->cookie('ceFilterBaseUri'))
  129. \System::setCookie('ceFilterBaseUri', $this->Environment->requestUri, 86400000);
  130. */
  132. $objRegion = $this->Database->prepare(" SELECT region.*, country.title as country_title
  133. FROM tl_hideaway_region as region, tl_hideaway_country as country
  134. WHERE country.id=region.country AND region.published=1
  135. ORDER BY region.country, region.title")
  136. ->execute();
  138. while ($objRegion->next())
  139. {
  140. $row = $objRegion->row();
  141. array_push($regions, array(
  142. 'row' => $row,
  143. 'url' => $this->Input->cookie('ceFilterBaseUri').($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$row['alias'].'/',
  144. 'data-filter' => 'region_id_'.$row['id']
  145. )
  146. );
  147. }
  150. foreach ($GLOBALS['hideaway']['types'] as $key => $value )
  151. {
  152. array_push($types, array(
  153. 'title' => $value['title'],
  154. 'url' => $this->Input->cookie('ceFilterBaseUri').'type/'.$key.'/',
  155. 'data-filter' => $key
  156. )
  157. );
  158. }
  160. $ret['regions'] = $regions;
  161. $ret['types'] = $types;
  164. return $ret;
  165. }
  167. public function getNavigationExperience($jumpToPage, $filter_target=false)
  168. {
  169. $ret = array();
  171. if ($filter_target)
  172. {
  173. // Get target alias for prefiltering
  174. $obj = $this->Database->prepare("SELECT alias FROM tl_hideaway_target WHERE id=?")
  175. ->execute($filter_target);
  177. $row = $obj->row();
  178. $targetAlias = $row['alias'];
  179. }
  181. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_experience WHERE published=1 ORDER BY title")
  182. ->execute();
  184. $objParent = \PageModel::findById($jumpToPage);
  186. while ($obj->next())
  187. {
  188. $row = $obj->row();
  189. $preview_image = \FilesModel::findByUuid($row['preview_image']);
  190. $page_image = \FilesModel::findByUuid($row['pageimage']);
  193. if ($targetAlias)
  194. {
  195. $url = $this->generateFrontendUrl($objParent->row(), '/erlebnis/'.$row['alias'].'/gruppe/'.$targetAlias, $objParent->language);
  196. $url = '/reiseerlebnis/'.$row['alias'].'/gruppe/'.$targetAlias.'/';
  197. }
  198. else
  199. {
  200. $url = $this->generateFrontendUrl($objParent->row(), '/erlebnis/'.$row['alias'], $objParent->language);
  201. $url = '/reiseerlebnis/'.$row['alias'].'/';
  202. }
  205. array_push($ret, array(
  206. 'row' => $row,
  207. 'url' => $url,
  208. 'preview_image_path'=>$preview_image->path,
  209. 'preview_image_meta' => unserialize($preview_image->meta),
  210. 'page_image_path'=>$page_image->path,
  211. 'page_image_meta' => unserialize($page_image->meta)
  212. )
  213. );
  214. }
  216. return $ret;
  217. }
  219. public function getRegionNavigation($regionPage, $countryId, $countryAlias)
  220. {
  221. $ret = array();
  222. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_region WHERE published=1 AND country=? ORDER BY title")
  223. ->execute($countryId);
  225. $objParentRegion = \PageModel::findById($regionPage);
  228. while ($obj->next())
  229. {
  232. $row = $obj->row();
  233. array_push($ret, array(
  234. 'row' => $row,
  235. // 'url' => $this->generateFrontendUrl($objParentRegion->row(), ($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$row['alias'], $objParent->language)
  236. 'url' => '/reisen/'.$countryAlias.'/'.$row['alias'].'/'
  237. )
  238. );
  239. }
  241. return $ret;
  242. }
  244. public function getCountryList($jumpToPage)
  245. {
  247. $ret = array();
  248. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_country WHERE published=1 ORDER BY sorting")
  249. ->execute();
  251. $objParent = \PageModel::findById($jumpToPage);
  253. while ($obj->next())
  254. {
  255. $row = $obj->row();
  256. $preview_image = \FilesModel::findByUuid($row['preview_image']);
  257. $page_image = \FilesModel::findByUuid($row['pageimage']);
  259. array_push($ret, array(
  260. 'row' => $row,
  261. // 'url' => $this->generateFrontendUrl($objParent->row(), ($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$row['alias'], $objParent->language),
  262. 'url' => '/reisen/'.$row['alias'].'/',
  263. 'preview_image_path'=>$preview_image->path,
  264. 'preview_image_meta' => unserialize($preview_image->meta),
  265. 'page_image_path'=>$page_image->path,
  266. 'page_image_meta' => unserialize($page_image->meta)
  267. )
  268. );
  269. }
  271. return $ret;
  272. }
  274. public function getTargetList($jumpToPage)
  275. {
  277. $ret = array();
  278. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_target WHERE published=1 ORDER BY title")
  279. ->execute();
  281. $objParent = \PageModel::findById($jumpToPage);
  283. while ($obj->next())
  284. {
  285. $row = $obj->row();
  287. if ($row['jumpto_target'])
  288. {
  289. $objParent = \PageModel::findById($row['jumpto_target']);
  290. $url = $this->generateFrontendUrl($objParent->row(), false, $objParent->language);
  291. }
  292. else
  293. {
  294. $url = $this->generateFrontendUrl($objParent->row(), '/gruppe/'.$row['alias'], $objParent->language);
  295. }
  297. $preview_image = \FilesModel::findByUuid($row['preview_image']);
  298. $page_image = \FilesModel::findByUuid($row['pageimage']);
  300. array_push($ret, array(
  301. 'row' => $row,
  302. 'url' => $url,
  303. 'preview_image_path'=>$preview_image->path,
  304. 'preview_image_meta' => unserialize($preview_image->meta),
  305. 'page_image_path'=>$page_image->path,
  306. 'page_image_meta' => unserialize($page_image->meta)
  307. )
  308. );
  309. }
  311. return $ret;
  312. }
  314. public function getList($page=1,$limit=5, $types=array(), $targets=array(), $region=false, $feature=false, $target=false, $experience=false, $highlight=false)
  315. {
  316. //var_dump($GLOBALS['hideaway']['hotel_reader_id']);
  317. $ret = array();
  318. $cnt = 0;
  319. $pages = 1;
  321. /*$obj = $this->Database->prepare("SELECT COUNT(id) as cnt FROM tl_admk_event WHERE published=1")
  322. ->execute();
  323. if($obj->next())
  324. {
  325. $r = $obj->row();
  326. $cnt = $r['cnt'];
  327. $pages = ceil($cnt/$limit);
  329. }*/
  331. // HOTELS
  332. if(in_array('hotel', $types))
  333. {
  334. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_hotel WHERE published=1 ORDER BY title")
  335. ->execute();
  336. $objParent = \PageModel::findById($GLOBALS['hideaway']['hotel_reader_id']);
  338. while ($obj->next())
  339. {
  340. $row = $obj->row();
  341. $t = array('row'=>$row, 'type'=>'hotel');
  343. $objModel = \FilesModel::findByUuid($row['image']);
  344. $t['image_path'] = $objModel->path;
  345. $t['image_meta'] = unserialize($objModel->meta);
  346. // $t['url'] = $this->generateFrontendUrl($objParent->row(), ($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$row['alias'], $objParent->language);
  347. $t['url'] = $this->generateUrl($row, 'hotel');
  349. if ($targets)
  350. {
  351. foreach ($targets as $target)
  352. {
  353. if ($highlight)
  354. {
  355. $highlight_targets = unserialize($row['highlight']);
  356. if ($highlight_targets)
  357. {
  358. if (in_array($target, $highlight_targets))
  359. {
  360. $ret[] = $t;
  361. break;
  362. }
  363. }
  364. }
  365. else
  366. {
  367. if (in_array($target, unserialize($row['targets'])))
  368. {
  369. $ret[] = $t;
  370. break;
  371. }
  372. }
  373. }
  374. }
  375. else $ret[] = $t;
  376. }
  377. }
  379. // TRAVELS
  380. if(in_array('travel', $types))
  381. {
  382. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_travel WHERE published=1 ORDER BY title")
  383. ->execute();
  384. $objParent = \PageModel::findById($GLOBALS['hideaway']['travel_reader_id']);
  386. while ($obj->next())
  387. {
  388. $row = $obj->row();
  389. $t = array('row'=>$row, 'type'=>'travel');
  391. $objModel = \FilesModel::findByUuid($row['image']);
  392. $t['image_path'] = $objModel->path;
  393. $t['image_meta'] = unserialize($objModel->meta);
  394. // $t['url'] = $this->generateFrontendUrl($objParent->row(), ($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$row['alias'], $objParent->language);
  395. $t['url'] = $this->generateUrl($row, 'travel');
  397. if ($targets)
  398. {
  399. foreach ($targets as $target)
  400. {
  401. if ($highlight)
  402. {
  403. $highlight_targets = unserialize($row['highlight']);
  404. if ($highlight_targets)
  405. {
  406. if (in_array($target, $highlight_targets))
  407. {
  408. $ret[] = $t;
  409. break;
  410. }
  411. }
  412. }
  413. else
  414. {
  415. if (in_array($target, unserialize($row['targets'])))
  416. {
  417. $ret[] = $t;
  418. break;
  419. }
  420. }
  421. }
  422. }
  423. else $ret[] = $t;
  424. }
  425. }
  427. // TRIPS
  428. if(in_array('trip', $types))
  429. {
  430. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_trip WHERE published=1 ORDER BY title")
  431. ->execute();
  432. $objParent = \PageModel::findById($GLOBALS['hideaway']['trip_reader_id']);
  434. while ($obj->next())
  435. {
  436. $row = $obj->row();
  437. $t = array('row'=>$row, 'type'=>'trip');
  439. $objModel = \FilesModel::findByUuid($row['image']);
  440. $t['image_path'] = $objModel->path;
  441. $t['image_meta'] = unserialize($objModel->meta);
  442. // $t['url'] = $this->generateFrontendUrl($objParent->row(), ($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$row['alias'], $objParent->language);
  443. $t['url'] = $this->generateUrl($row, 'trip');
  445. if ($targets)
  446. {
  447. foreach ($targets as $target)
  448. {
  449. if ($highlight)
  450. {
  451. $highlight_targets = unserialize($row['highlight']);
  452. if ($highlight_targets)
  453. {
  454. if (in_array($target, $highlight_targets))
  455. {
  456. $ret[] = $t;
  457. break;
  458. }
  459. }
  460. }
  461. else
  462. {
  463. if (in_array($target, unserialize($row['targets'])))
  464. {
  465. $ret[] = $t;
  466. break;
  467. }
  468. }
  469. }
  470. }
  471. else $ret[] = $t;
  472. }
  473. }
  475. // COMBIS
  476. if(in_array('combi', $types))
  477. {
  478. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_combis WHERE published=1 ORDER BY title")
  479. ->execute();
  480. $objParent = \PageModel::findById($GLOBALS['hideaway']['combi_reader_id']);
  482. while ($obj->next())
  483. {
  484. $row = $obj->row();
  485. $t = array('row'=>$row, 'type'=>'combi');
  487. $objModel = \FilesModel::findByUuid($row['image']);
  488. $t['image_path'] = $objModel->path;
  489. $t['image_meta'] = unserialize($objModel->meta);
  490. $t['url'] = $this->generateFrontendUrl($objParent->row(), ($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$row['alias'], $objParent->language);
  492. if ($targets)
  493. {
  494. foreach ($targets as $target)
  495. {
  496. if ($highlight)
  497. {
  498. $highlight_targets = unserialize($row['highlight']);
  499. if ($highlight_targets)
  500. {
  501. if (in_array($target, $highlight_targets))
  502. {
  503. $ret[] = $t;
  504. break;
  505. }
  506. }
  507. }
  508. else
  509. {
  510. if (in_array($target, unserialize($row['targets'])))
  511. {
  512. $ret[] = $t;
  513. break;
  514. }
  515. }
  516. }
  517. }
  518. else $ret[] = $t;
  519. }
  520. }
  522. if($feature)
  523. {
  524. $features = explode(",", $feature);
  525. foreach($features as $feature)
  526. {
  527. $feat = $this->getFeature($feature);
  528. foreach($ret as $k=>$val)
  529. {
  530. $fs = unserialize($val['row']['features']);
  531. if(is_array($fs))
  532. {
  533. if(!in_array($feat['id'], $fs))
  534. {
  535. unset($ret[$k]);
  536. }
  537. }
  538. else unset($ret[$k]);
  539. }
  540. }
  541. }
  543. if($experience)
  544. {
  545. $experiences = explode(",", $experience);
  546. foreach($experiences as $experience)
  547. {
  548. $feat = $this->getExperience($experience);
  549. foreach($ret as $k=>$val)
  550. {
  551. $fs = unserialize($val['row']['experiences']);
  552. if(is_array($fs))
  553. {
  554. if(!in_array($feat['id'], $fs))
  555. {
  556. unset($ret[$k]);
  557. }
  558. }
  559. else unset($ret[$k]);
  560. }
  561. }
  562. }
  564. if($region)
  565. {
  566. $regions = explode(",", $region);
  567. foreach($regions as $region)
  568. {
  569. $feat = $this->getRegion($region);
  570. foreach($ret as $k=>$val)
  571. {
  572. // echo $val['row']['title'].' / '.$val['row']['region'].' !== '.$feat.'<br>';
  573. if($val['row']['region'] !== $feat['id']) unset($ret[$k]);
  574. }
  575. }
  576. }
  578. if($target)
  579. {
  580. $targets = explode(",", $target);
  581. foreach($targets as $target)
  582. {
  583. $feat = $this->getTarget($target);
  584. foreach($ret as $k=>$val)
  585. {
  586. $fs = unserialize($val['row']['targets']);
  587. if(is_array($fs))
  588. {
  589. if(!in_array($feat['id'], $fs))
  590. {
  591. unset($ret[$k]);
  592. }
  593. }
  594. else unset($ret[$k]);
  595. }
  596. }
  597. }
  600. return array('objs'=>$ret, 'cnt'=>1, 'pages'=>1, 'page'=>1);
  601. }
  603. public function getFeature($id=0)
  604. {
  605. $ret = array();
  606. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_feature WHERE published=1 AND id = ? OR alias = ?")
  607. ->execute($id, $id);
  608. if ($obj->next())
  609. {
  610. $row = $obj->row();
  612. return $row;
  613. }
  615. return false;
  616. }
  618. public function getTarget($id=0)
  619. {
  620. $ret = array();
  621. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_target WHERE published=1 AND id = ? OR alias = ?")
  622. ->execute($id, $id);
  623. if ($obj->next())
  624. {
  625. $row = $obj->row();
  627. return $row;
  628. }
  630. return false;
  631. }
  633. public function getTargetIdByInternalAlias($alias='')
  634. {
  635. $obj = $this->Database->prepare("SELECT id FROM tl_hideaway_target WHERE internal_alias=?")
  636. ->execute($alias);
  638. if ($obj->next())
  639. {
  640. $row = $obj->row();
  642. return $row['id'];
  643. }
  645. return false;
  646. }
  648. public function getRegion($id=0)
  649. {
  650. $ret = array();
  651. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_region WHERE published=1 AND id = ? OR alias = ?")
  652. ->execute($id, $id);
  653. if ($obj->next())
  654. {
  655. $row = $obj->row();
  657. return $row;
  658. }
  660. return false;
  661. }
  663. public function getExperience($id=0)
  664. {
  665. $ret = array();
  666. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_experience WHERE published=1 AND id = ? OR alias = ?")
  667. ->execute($id, $id);
  668. if ($obj->next())
  669. {
  670. $row = $obj->row();
  672. return $row;
  673. }
  675. return false;
  676. }
  678. public function getHotelEntry($id=0, $bGallery = false)
  679. {
  680. $obj = $this->Database->prepare("SELECT * FROM tl_page WHERE id = ?")
  681. ->execute($GLOBALS['hideaway']['hotel_reader_id']);
  682. $obj->next();
  684. $url = $obj->alias;
  686. $ret = array();
  687. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_hotel WHERE published=1 AND id = ? OR alias = ?")
  688. ->execute($id, $id);
  689. if ($obj->next())
  690. {
  691. $row = $obj->row();
  693. $objModel = \FilesModel::findByUuid($row['image']);
  694. $ret = array(
  695. 'row' => $row,
  696. 'image_path' => $objModel->path,
  697. 'image_meta' => unserialize($objModel->meta),
  698. // 'url' => $url.($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$obj->alias.'/',
  699. 'url' => $this->generateUrl($row, 'hotel'),
  700. 'gallery' => false,
  701. 'breadcrumb' => $this->getBreadcrumb($row)
  702. );
  704. if($bGallery && $row['images'])
  705. {
  706. $ret['gallery'] = $this->getGallery($row);
  707. }
  709. return $ret;
  710. }
  712. return false;
  713. }
  715. private function getGallery($row)
  716. {
  717. $a = unserialize($row['images']);
  718. $gal = array();
  719. foreach($a as $i=>$im)
  720. {
  721. $fi = \FilesModel::findByUuid($im);
  722. if($fi->path)
  723. {
  724. //var_dump($fi->path);
  725. array_push($gal, array(
  726. 'uuid'=>$im,
  727. 'path' => $fi->path,
  728. 'meta' => unserialize($fi->meta)
  729. )
  730. );
  731. }
  732. }
  735. $tmp = deserialize($row['orderSRC']);
  736. if(is_array($tmp))
  737. {
  738. $tmpGal = array();
  739. foreach($tmp as $tid)
  740. {
  741. foreach($gal as $k=>$v)
  742. {
  743. if($v['uuid']==$tid)
  744. {
  745. $tmpGal[] = $v;
  746. }
  747. }
  748. }
  749. $gal = $tmpGal;//$gal;
  750. }
  752. return $gal;
  753. }
  755. public function getCombiEntry($id=0, $bGallery = false)
  756. {
  757. $obj = $this->Database->prepare("SELECT * FROM tl_page WHERE id = ?")
  758. ->execute($GLOBALS['hideaway']['combi_reader_id']);
  759. $obj->next();
  761. $url = $obj->alias;
  763. $ret = array();
  764. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_combis WHERE published=1 AND id = ? OR alias = ?")
  765. ->execute($id, $id);
  766. if ($obj->next())
  767. {
  768. $row = $obj->row();
  769. $row['regions'] = unserialize($row['regions']);
  770. $objModel = \FilesModel::findByUuid($row['image']);
  771. $ret = array(
  772. 'row' => $row,
  773. 'image_path' => $objModel->path,
  774. 'image_meta' => unserialize($objModel->meta),
  775. 'url' => $url.($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$obj->alias.'/',
  776. 'breadcrumb' => $this->getBreadcrumb($row)
  777. );
  779. if($bGallery && $row['images'])
  780. {
  781. $ret['gallery'] = $this->getGallery($row);
  782. }
  784. return $ret;
  785. }
  787. return false;
  788. }
  790. public function getTravelEntry($id=0, $bGallery = false)
  791. {
  793. $obj = $this->Database->prepare("SELECT * FROM tl_page WHERE id = ?")
  794. ->execute($GLOBALS['hideaway']['travel_reader_id']);
  795. $obj->next();
  797. $url = $obj->alias;
  799. $ret = array();
  800. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_travel WHERE published=1 AND id = ? OR alias = ?")
  801. ->execute($id, $id);
  802. if ($obj->next())
  803. {
  804. $row = $obj->row();
  805. $row['regions'] = unserialize($row['regions']);
  806. $objModel = \FilesModel::findByUuid($row['image']);
  807. $ret = array(
  808. 'row' => $row,
  809. 'image_path' => $objModel->path,
  810. 'image_meta' => unserialize($objModel->meta),
  811. // 'url' => $url.($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$obj->alias.'/',
  812. 'url' => $this->generateUrl($row, 'travel'),
  813. 'breadcrumb' => $this->getBreadcrumb($row)
  814. );
  817. if($bGallery && $row['images'])
  818. {
  819. $ret['gallery'] = $this->getGallery($row);
  820. }
  822. return $ret;
  823. }
  825. return false;
  826. }
  829. public function iEntry($id=0, $bGallery = false)
  830. {
  831. $obj = $this->Database->prepare("SELECT * FROM tl_page WHERE id = ?")
  832. ->execute($GLOBALS['hideaway']['combi_reader_id']);
  833. $obj->next();
  835. $url = $obj->alias;
  837. $ret = array();
  838. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_combis WHERE published=1 AND id = ? OR alias = ?")
  839. ->execute($id, $id);
  840. if ($obj->next())
  841. {
  842. $row = $obj->row();
  843. $row['regions'] = unserialize($row['regions']);
  844. $objModel = \FilesModel::findByUuid($row['image']);
  845. $ret = array(
  846. 'row' => $row,
  847. 'image_path' => $objModel->path,
  848. 'image_meta' => unserialize($objModel->meta),
  849. 'url' => $url.($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$obj->alias.'/',
  850. 'breadcrumb' => $this->getBreadcrumb($row)
  851. );
  853. if($bGallery && $row['images'])
  854. {
  855. $ret['gallery'] = $this->getGallery($row);
  856. }
  858. return $ret;
  859. }
  861. return false;
  862. }
  864. public function getTripEntry($id=0, $bGallery = false)
  865. {
  866. $obj = $this->Database->prepare("SELECT * FROM tl_page WHERE id = ?")
  867. ->execute($GLOBALS['hideaway']['trip_reader_id']);
  868. $obj->next();
  870. $url = $obj->alias;
  873. $ret = array();
  874. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_trip WHERE published=1 AND id = ? OR alias = ?")
  875. ->execute($id, $id);
  876. if ($obj->next())
  877. {
  878. $row = $obj->row();
  879. $row['regions'] = unserialize($row['regions']);
  880. $objModel = \FilesModel::findByUuid($row['image']);
  881. $ret = array(
  882. 'row' => $row,
  883. 'image_path' => $objModel->path,
  884. 'image_meta' => unserialize($objModel->meta),
  885. // 'url' => $url.($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$obj->alias.'/',
  886. 'url' => $this->generateUrl($row, 'trip'),
  887. 'breadcrumb' => $this->getBreadcrumb($row)
  888. );
  892. if($bGallery && $row['images'])
  893. {
  894. $ret['gallery'] = $this->getGallery($row);
  895. }
  897. return $ret;
  898. }
  900. return false;
  901. }
  904. public function getCountryEntry($id=0)
  905. {
  906. $ret = array();
  907. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_country WHERE published=1 AND id = ?")
  908. ->execute($id);
  910. if ($obj->next())
  911. {
  912. $row = $obj->row();
  914. $objModel = \FilesModel::findByUuid($row['pageimage']);
  915. $ret = array(
  916. 'row' => $row,
  917. 'image_path' => $objModel->path,
  918. 'image_meta' => unserialize($objModel->meta),
  919. );
  921. return $ret;
  922. }
  924. return false;
  925. }
  928. public function getRegionEntry($id=0)
  929. {
  930. $ret = array();
  931. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_region WHERE published=1 AND id = ?")
  932. ->execute($id, $id);
  933. if ($obj->next())
  934. {
  935. $row = $obj->row();
  937. $objModel = \FilesModel::findByUuid($row['pageimage']);
  938. $ret = array(
  939. 'row' => $row,
  940. 'image_path' => $objModel->path,
  941. 'image_meta' => unserialize($objModel->meta)
  942. );
  944. return $ret;
  945. }
  947. return false;
  948. }
  951. public function getRegionByUrl()
  952. {
  953. $alias = $this->Input->get('items');
  955. $ret = array();
  956. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_region WHERE published=1 AND alias = ?")
  957. ->execute($alias);
  958. if ($obj->next())
  959. {
  960. $row = $obj->row();
  962. $map = \FilesModel::findByUuid($row['map']);
  963. $image = \FilesModel::findByUuid($row['pageimage']);
  964. $ret = array(
  965. 'row' => $row,
  966. 'map_path' => $map->path,
  967. 'map_meta' => unserialize($map->meta),
  968. 'image_path' => $image->path,
  969. 'image_meta' => unserialize($image->meta),
  970. 'breadcrumb' => $this->getRegionBreadcrumb($row)
  971. );
  973. return $ret;
  974. }
  976. return false;
  977. }
  980. public function getCountryByUrl()
  981. {
  982. $alias = $this->Input->get('items');
  984. $ret = array();
  985. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_country WHERE published=1 AND alias = ?")
  986. ->execute($alias);
  987. if ($obj->next())
  988. {
  989. $row = $obj->row();
  991. $map = \FilesModel::findByUuid($row['map']);
  992. $image = \FilesModel::findByUuid($row['pageimage']);
  993. $ret = array(
  994. 'row' => $row,
  995. 'map_path' => $map->path,
  996. 'map_meta' => unserialize($map->meta),
  997. 'image_path'=>$image->path,
  998. 'image_meta' => unserialize($image->meta),
  999. 'breadcrumb' => $this->getCountryBreadcrumb($row)
  1000. );
  1002. return $ret;
  1003. }
  1005. return false;
  1006. }
  1009. public function getExperienceByUrl()
  1010. {
  1011. $alias = $this->Input->get('erlebnis');
  1013. $ret = array();
  1014. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_experience WHERE published=1 AND alias = ?")
  1015. ->execute($alias);
  1016. if ($obj->next())
  1017. {
  1018. $row = $obj->row();
  1020. $page_image = \FilesModel::findByUuid($row['pageimage']);
  1021. $preview_image = \FilesModel::findByUuid($row['preview_image']);
  1023. $ret = array(
  1024. 'row' => $row,
  1025. 'map_path' => $map->path,
  1026. 'map_meta' => unserialize($map->meta),
  1027. 'page_image_path' => $page_image->path,
  1028. 'page_image_meta' => unserialize($page_image->meta),
  1029. 'preview_image_path' => $preview_image->path,
  1030. 'preview_image_meta' => unserialize($preview_image->meta),
  1031. );
  1033. return $ret;
  1034. }
  1036. return false;
  1037. }
  1040. public function getTargetByUrl()
  1041. {
  1042. $alias = $this->Input->get('gruppe');
  1044. $ret = array();
  1045. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_target WHERE published=1 AND alias = ?")
  1046. ->execute($alias);
  1047. if ($obj->next())
  1048. {
  1049. $row = $obj->row();
  1051. $page_image = \FilesModel::findByUuid($row['pageimage']);
  1052. $preview_image = \FilesModel::findByUuid($row['preview_image']);
  1054. $ret = array(
  1055. 'row' => $row,
  1056. 'map_path' => $map->path,
  1057. 'map_meta' => unserialize($map->meta),
  1058. 'page_image_path' => $page_image->path,
  1059. 'page_image_meta' => unserialize($page_image->meta),
  1060. 'preview_image_path' => $preview_image->path,
  1061. 'preview_image_meta' => unserialize($preview_image->meta),
  1062. );
  1064. return $ret;
  1065. }
  1067. return false;
  1068. }
  1070. public function getHotelsByRegionId($id)
  1071. {
  1072. if ($_COOKIE['target']) $targetId = $this->getTargetIdByInternalAlias($_COOKIE['target']);
  1074. $ret = array();
  1075. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_hotel WHERE published=1 AND region = ?")
  1076. ->execute($id);
  1077. while ($obj->next())
  1078. {
  1079. if ($targetId)
  1080. {
  1081. $targets = unserialize($obj->targets);
  1082. if ($targets)
  1083. {
  1084. if (in_array($targetId, $targets))
  1085. {
  1086. $ret[] = $this->getHotelEntry($obj->id);
  1087. }
  1088. }
  1089. }
  1090. else $ret[] = $this->getHotelEntry($obj->id);
  1091. }
  1092. return $ret;
  1093. }
  1095. public function getTravelsByRegionId($id)
  1096. {
  1097. if ($_COOKIE['target']) $targetId = $this->getTargetIdByInternalAlias($_COOKIE['target']);
  1099. $ret = array();
  1100. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_travel WHERE published=1 AND regions LIKE ?")
  1101. ->execute('%"'.$id.'"%');
  1102. while ($obj->next())
  1103. {
  1104. $addEntry = false;
  1105. if ($targetId)
  1106. {
  1107. $targets = unserialize($obj->targets);
  1108. if ($targets && in_array($targetId, $targets))
  1109. {
  1110. $addEntry = true;
  1111. }
  1112. }
  1113. else $addEntry = true;
  1115. if ($addEntry)
  1116. {
  1117. $entry = $this->getTravelEntry($obj->id);
  1118. $stations = array();
  1119. for ($i = 1; $i <= 21; $i++)
  1120. {
  1121. if ($entry['row']['day_'.$i.'_location'] != '')
  1122. {
  1123. $stations[] = array(
  1124. 'pos' => $i,
  1125. 'location' => $entry['row']['day_'.$i.'_location'],
  1126. 'teaser' => $entry['row']['day_'.$i.'_teaser'],
  1127. );
  1128. }
  1129. }
  1130. $entry['stations'] = $stations;
  1131. $ret[] = $entry;
  1132. }
  1133. }
  1134. return $ret;
  1135. }
  1137. public function getTripsByRegionId($id)
  1138. {
  1139. if ($_COOKIE['target']) $targetId = $this->getTargetIdByInternalAlias($_COOKIE['target']);
  1141. $ret = array();
  1142. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_trip WHERE published=1 AND regions LIKE ?")
  1143. ->execute('%"'.$id.'"%');
  1144. while ($obj->next())
  1145. {
  1146. if ($targetId)
  1147. {
  1148. $targets = unserialize($obj->targets);
  1149. if ($targets)
  1150. {
  1151. if (in_array($targetId, $targets))
  1152. {
  1153. $ret[] = $this->getTripEntry($obj->id);
  1154. }
  1155. }
  1156. }
  1157. else $ret[] = $this->getTripEntry($obj->id);
  1158. }
  1159. return $ret;
  1160. }
  1162. public function getTripsByCountryId($id)
  1163. {
  1164. $regionObj = $this->Database->prepare("SELECT id FROM tl_hideaway_region WHERE published=1 AND country = ?")
  1165. ->execute($id);
  1167. $tripsByCountry = array();
  1169. while ($regionObj->next())
  1170. {
  1171. $trips = $this->getTripsByRegionId($regionObj->id);
  1172. if ($trips)
  1173. {
  1174. foreach ($trips as $trip)
  1175. {
  1176. $inList = false;
  1177. foreach ($tripsByCountry as $t)
  1178. {
  1179. if ($t['row']['id'] == $trip['row']['id'])
  1180. {
  1181. $inList = true;
  1182. break;
  1183. }
  1184. }
  1185. if (!$inList)
  1186. $tripsByCountry[] = $trip;
  1187. }
  1188. }
  1189. }
  1191. return count($tripsByCountry) ? $tripsByCountry : false;
  1192. }
  1194. public function getCombisByCountryId($id)
  1195. {
  1196. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_region WHERE published=1 AND country = ?")
  1197. ->execute($id);
  1199. $combisByCountry = array();
  1201. while ($obj->next())
  1202. {
  1203. // Get Combis by Region and check if not already in combisByCountry-list
  1204. if ($this->getCombisByRegionId($obj->id))
  1205. {
  1206. // echo "getCombisByRegionId fired!";
  1207. foreach ($this->getCombisByRegionId($obj->id) as $combi)
  1208. {
  1209. if (count($combisByCountry))
  1210. {
  1211. $in_list = false;
  1212. foreach ($combisByCountry as $c)
  1213. {
  1214. if ($c['row']['id'] == $combi['row']['id'])
  1215. $in_list = true;
  1216. }
  1217. if ($in_list == false)
  1218. array_push($combisByCountry, $combi);
  1219. }
  1220. else
  1221. {
  1222. array_push($combisByCountry, $combi);
  1223. }
  1224. }
  1225. }
  1226. }
  1227. // var_dump($combisByCountry); exit;
  1228. return $combisByCountry;
  1229. }
  1231. public function getCombisByRegionId($id)
  1232. {
  1233. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_combis WHERE published=1 ORDER BY title")
  1234. ->execute();
  1236. $objParent = \PageModel::findById($GLOBALS['hideaway']['combi_reader_id']);
  1238. while ($obj->next())
  1239. {
  1240. $regions = unserialize($obj->regions);
  1241. if (!in_array($id, $regions)) continue;
  1243. $row = $obj->row();
  1244. $t = array('row'=>$row, 'type'=>'combi');
  1246. $objModel = \FilesModel::findByUuid($row['image']);
  1247. $t['image_path'] = $objModel->path;
  1248. $t['image_meta'] = unserialize($objModel->meta);
  1249. $t['url'] = $this->generateFrontendUrl($objParent->row(), ($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$row['alias'], $objParent->language);
  1251. if ($targets)
  1252. {
  1253. foreach ($targets as $target)
  1254. {
  1255. if ($highlight)
  1256. {
  1257. $highlight_targets = unserialize($row['highlight']);
  1258. if ($highlight_targets)
  1259. {
  1260. if (in_array($target, $highlight_targets))
  1261. {
  1262. $ret[] = $t;
  1263. break;
  1264. }
  1265. }
  1266. }
  1267. else
  1268. {
  1269. if (in_array($target, unserialize($row['targets'])))
  1270. {
  1271. $ret[] = $t;
  1272. break;
  1273. }
  1274. }
  1275. }
  1276. }
  1277. else $ret[] = $t;
  1278. }
  1279. return $ret;
  1280. }
  1282. public function getRegionsByCountryId($id, $reader_id = 0)
  1283. {
  1284. $ret = array();
  1285. $url = false;
  1287. if($reader_id > 0)
  1288. {
  1289. $obj = $this->Database->prepare("SELECT * FROM tl_page WHERE id = ?")
  1290. ->execute($reader_id);
  1291. $obj->next();
  1293. $url = $obj->alias;
  1295. }
  1297. $obj = $this->Database->prepare("SELECT * FROM tl_hideaway_region WHERE published=1 AND country = ?")
  1298. ->execute($id);
  1299. while ($obj->next())
  1300. {
  1301. $row = $obj->row();
  1303. $image = \FilesModel::findByUuid($row['pageimage']);
  1304. $row['image_path'] = $image->path;
  1305. $row['image_meta'] = unserialize($image->meta);
  1306. $row['url'] = false;
  1307. $country = $this->getCountryEntry($row['country']);
  1308. //die($country['row']['alias']);
  1309. if($url)
  1310. {
  1311. // $row['url'] = $url.($GLOBALS['TL_CONFIG']['useAutoItem'] ? '/' : '/items/').$row['alias'].'/';
  1312. $row['url'] = '/reisen/'.$country['row']['alias'].'/'.$row['alias'].'/';
  1313. }
  1314. $ret[] = $row;
  1315. }
  1317. return $ret;
  1318. }
  1320. public function getCountryAndRegionByReference($row)
  1321. {
  1322. if ($row['main_region'])
  1323. {
  1324. $regid = $row['main_region'];
  1325. }
  1326. else
  1327. {
  1328. if ($row['region'] > 0)
  1329. $regid = $row['region'];
  1331. else if (is_array($row['regions']))
  1332. $regid = $row['regions'][0];
  1333. }
  1335. $region = $this->getRegionEntry($regid);
  1336. $country = $this->getCountryEntry($region['row']['country']);
  1338. return array(
  1339. 'region' => $region,
  1340. 'country' => $country
  1341. );
  1342. }
  1344. public function generateUrl($row, $type='hotel')
  1345. {
  1346. $arr = $this->getCountryAndRegionByReference($row);
  1348. $region = $arr['region'];
  1349. $country = $arr['country'];
  1351. if((int)$country['row']['single_region'] > 0)
  1352. {
  1354. switch ($type) {
  1355. case 'hotel':
  1356. $url = '/reisen/'.$country['row']['alias'].'/'.'hotels-'.str_replace(array('-urlaub','-reisen'), '', $country['row']['alias']).'/'.$row['alias'].'/';
  1357. break;
  1359. case 'trip':
  1360. $url = '/reisen/'.$country['row']['alias'].'/'.str_replace(array('-urlaub','-reisen'), '', $country['row']['alias']).'-ausfluege'.'/'.$row['alias'].'/';
  1361. break;
  1363. case 'travel':
  1364. $url = '/reisen/'.$country['row']['alias'].'/'.str_replace(array('-urlaub','-reisen'), '', $country['row']['alias']).'-rundreise'.'/'.$row['alias'].'/';
  1365. break;
  1367. default:
  1368. # code...
  1369. break;
  1370. }
  1371. //die($url);
  1372. }
  1373. else
  1374. {
  1375. switch ($type) {
  1376. case 'hotel':
  1377. $url = '/reisen/'.$country['row']['alias'].'/'.$region['row']['alias'].'/'.'hotels-'.str_replace('-urlaub', '', $region['row']['alias']).'/'.$row['alias'].'/';
  1378. break;
  1380. case 'trip':
  1381. $url = '/reisen/'.$country['row']['alias'].'/'.$region['row']['alias'].'/'.str_replace('-urlaub', '', $region['row']['alias']).'-ausfluege'.'/'.$row['alias'].'/';
  1382. break;
  1384. case 'travel':
  1385. $url = '/reisen/'.$country['row']['alias'].'/'.$region['row']['alias'].'/'.str_replace('-urlaub', '', $region['row']['alias']).'-rundreise'.'/'.$row['alias'].'/';
  1386. break;
  1388. default:
  1389. # code...
  1390. break;
  1391. }
  1392. }
  1396. return $url;
  1397. }
  1400. private function getCountryBreadcrumb($row)
  1401. {
  1402. $country = $this->getCountryEntry($row['country']);
  1403. $ret = array(
  1404. array(
  1405. 'title' => 'Reiseziele',
  1406. 'url' => '/reisen-suedostasien/'
  1407. )
  1408. );
  1410. return $ret;
  1411. }
  1413. private function getRegionBreadcrumb($row)
  1414. {
  1415. $country = $this->getCountryEntry($row['country']);
  1416. $ret = array(
  1417. array(
  1418. 'title' => 'Reiseziele',
  1419. 'url' => '/reisen-suedostasien/'
  1420. ),
  1421. array(
  1422. 'title' => $country['row']['title'],
  1423. 'url' => '/reisen/'.$country['row']['alias'].'/'
  1424. )
  1425. );
  1427. return $ret;
  1428. }
  1430. private function getBreadcrumb($row)
  1431. {
  1432. global $GLOBALS;
  1434. $arr = $this->getCountryAndRegionByReference($row);
  1436. $region = $arr['region'];
  1437. $country = $arr['country'];
  1439. //var_dump($country);
  1441. if($country['row']['single_region'] > 0)
  1442. {
  1443. $ret = array(
  1444. array(
  1445. 'title' => 'Reiseziele',
  1446. 'url' => '/reisen-suedostasien/'
  1447. ),
  1448. array(
  1449. 'title' => $country['row']['title'],
  1450. 'url' => '/reisen/'.$country['row']['alias'].'/'
  1451. )
  1452. );
  1453. }
  1454. else
  1455. {
  1456. $ret = array(
  1457. array(
  1458. 'title' => 'Reiseziele',
  1459. 'url' => '/reisen-suedostasien/'
  1460. ),
  1461. array(
  1462. 'title' => $country['row']['title'],
  1463. 'url' => '/reisen/'.$country['row']['alias'].'/'
  1464. ),
  1465. array(
  1466. 'title' => $region['row']['title'],
  1467. 'url' => '/reisen/'.$country['row']['alias'].'/'.$region['row']['alias'].'/'
  1468. )
  1469. );
  1470. }
  1473. return $ret;
  1474. }
  1475. }