LP.from_page_id = :from_page_id
			ORDER BY
				LP.order_index
				";
 
		$rows = BuxusDB::get()->fetchAll($query, array(':property_id' => $property_id, ':from_page_id' => $page_id));
 
		return $rows;
	}
 
	/**
	 * Nacitanie vlastnosti z DB (skopirovane z SetOwnProperties a UpdateProperties)
	 *
	 * @param int $page_id
	 * @return array
	 */
	public function readPageProperties($page_id)
	{
		// Nacitanie zakladnych vlastnosti
		$properties = $this->readGeneralProperties($page_id);
 
		if (! empty($properties))
		{ // Nasla sa dana stranka
			// Nacitanie rozsirenych vlastnosti
			$properties_extended = $this->readExtendedProperties($page_id);
			$properties = array_merge($properties, $properties_extended);
 
			if ($properties['page_type_id'] != '') {
                $properties_link = $this->readPageLinkProperties($page_id, $properties['page_type_id']);
                $properties = array_merge($properties, $properties_link);
            }
 
			$draft_properties = PageDrafts::getPropertiesValues($page_id);
			$properties = array_merge($properties, $draft_properties);
		}
 
		// Inherit properties
		$inherit_property_config = BuxusInheritPropertyConfigFactory::getInstance();
		if ($inherit_property_config->inheritProperties())
		{ // The properties should by inherited

	 *
	 * @var array
	 */
	protected $defined_properties_tags = array();
 
	/**
	 * Konstruktor
	 *
	 * @param int $page_id
	 */
	public function __construct($page_id)
	{
		$this->page_id = (int) $page_id;
 
		// Read properties
		$cache = BuxusPagePropertiesCacheFactory::getInstance();
		$tmp = $cache->get($this->page_id);
		if (! is_array($tmp))
		{ // The data was not in cache
			$this->properties = self::readPageProperties($this->page_id);
			$cache->set($this->page_id, array('properties' => $this->properties, 'defined_properties_tags' => $this->defined_properties_tags));
		}
		else
		{ // The data was in cache
			$this->properties = $tmp['properties'];
			$this->defined_properties_tags = $tmp['defined_properties_tags'];
		}
	}
 
	/**
	 * Nacitanie zakladnych vlastnosti
	 *
	 * @param int $page_id
	 * @return array
	 */
	protected static function readGeneralProperties($page_id)
	{
		$query = "
			SELECT
				*

<?php
namespace App\Page;
 
use Eshop\Product\ProductFactory;
use PTCI;
 
class PageFactory
{
	/**
	 * @param $id
	 * @param null $page_type_id
	 * @param bool $not_from_cache
	 *
	 * @return FinalPage
	 */
	public static function get($id, $page_type_id = null, $not_from_cache = false)
	{
        if ($page_type_id === null) {
            $page = new FinalPage($id);
            $page_type_id = $page->getProperty('page_type_id');
        }
 
        if ($page_type_id == PTCI::ESHOP_PRODUCT_ID) {
            return ProductFactory::get($id);
        }
 
        return new FinalPage($id);
	}
}

	 * @var array
	 */
	public $subitems = array();
 
	/**
	 * Podpolozky ako ListBase items
	 *
	 * @var ListBase
	 */
	protected $list_subitems;
 
 
	/**
	 * Constructor
	 *
	 * @param int $page_id
	 */
	public function __construct($page_id)
	{
		$this->page = PageFactory::get($page_id);
	}
 
	/**
	 * Vrati property stranky
	 *
	 * @param $tag
	 *
	 * @return mixed
	 */
	public function getProperty($tag)
	{
		return $this->page->getProperty($tag);
	}
 
	/**
	 * Vrati objekt stranky
	 *
	 * @return PageFactory
	 */
	public function getPage()

		return $this->items_objects[$item];
	}

	/**
	 * Get current item
	 * @return DefaultIterator
	 */
	public function current()
	{
		return $this->prepareItem(current($this->items));
	}

	public function setFactoryFunction($factory)
	{
		$this->factory_function = $factory;
	}

	public function defaultFactoryFunction($page_id)
	{
		return new ListItem($page_id);
	}

	/**
	 * Get key of item
	 * @return int
	 */
	public function key()
	{
		return key($this->items);
	}

	/**
	 * Get next item
	 * @return DefaultIterator
	 */
	public function next()
	{
		return next($this->items);
	}

	{
		if (is_null($this->factory_function)) {
			$this->setFactoryFunction(array($this,'defaultFactoryFunction'));
		}
	}

	protected function prepareItem($item)
	{
		if (is_object($item) || $item === false || is_array($item)) {
			return $item;
		}

		if (array_key_exists($item, $this->items_objects) && is_object($this->items_objects[$item])) {
			return $this->items_objects[$item];
		}

		$this->setDefaultFactoryFunction();

		if (is_callable($this->factory_function)) {
			$this->items_objects[$item] = call_user_func($this->factory_function,$item);
		}
		return $this->items_objects[$item];
	}

	/**
	 * Get current item
	 * @return DefaultIterator
	 */
	public function current()
	{
		return $this->prepareItem(current($this->items));
	}

	public function setFactoryFunction($factory)
	{
		$this->factory_function = $factory;
	}

	public function defaultFactoryFunction($page_id)
	{

	{
		if (is_null($this->factory_function)) {
			$this->setFactoryFunction(array($this,'defaultFactoryFunction'));
		}
	}

	protected function prepareItem($item)
	{
		if (is_object($item) || $item === false || is_array($item)) {
			return $item;
		}

		if (array_key_exists($item, $this->items_objects) && is_object($this->items_objects[$item])) {
			return $this->items_objects[$item];
		}

		$this->setDefaultFactoryFunction();

		if (is_callable($this->factory_function)) {
			$this->items_objects[$item] = call_user_func($this->factory_function,$item);
		}
		return $this->items_objects[$item];
	}

	/**
	 * Get current item
	 * @return DefaultIterator
	 */
	public function current()
	{
		return $this->prepareItem(current($this->items));
	}

	public function setFactoryFunction($factory)
	{
		$this->factory_function = $factory;
	}

	public function defaultFactoryFunction($page_id)
	{

		if (array_key_exists($item, $this->items_objects) && is_object($this->items_objects[$item])) {
			return $this->items_objects[$item];
		}

		$this->setDefaultFactoryFunction();

		if (is_callable($this->factory_function)) {
			$this->items_objects[$item] = call_user_func($this->factory_function,$item);
		}
		return $this->items_objects[$item];
	}

	/**
	 * Get current item
	 * @return DefaultIterator
	 */
	public function current()
	{
		return $this->prepareItem(current($this->items));
	}

	public function setFactoryFunction($factory)
	{
		$this->factory_function = $factory;
	}

	public function defaultFactoryFunction($page_id)
	{
		return new ListItem($page_id);
	}

	/**
	 * Get key of item
	 * @return int
	 */
	public function key()
	{
		return key($this->items);
	}

	{
		return key($this->items);
	}

	/**
	 * Get next item
	 * @return DefaultIterator
	 */
	public function next()
	{
		return next($this->items);
	}

	/**
	 * Return true if the current item is valid
	 * @return bool
	 */
	public function valid()
	{
		return ($this->current() !== false);
	}
}
 

                    <div class="morePost row featuredPostContainer style2 row--top-margin">
                        <h3 class="section-title style2 text-center"><span><?php echo \Trans::str('common',
                                    'ODPORÚČAME'); ?></span></h3>
                        <div class="row xsResponse categoryProduct">
                            <?php foreach ($this->novinky as $item_product): ?>
                                <?php if (($item_product->getProperty(PCT::ESHOP_EUR_PRICE_INCLUDING_VAT_HU_TAG) !== false && PH::isHu()) || (PH::isCz() || PH::isSk())): ?>
                                    <div class="item col-lg-4 col-md-4 col-sm-4 col-xs-6">
                                        <?php echo $this->partial('eshop/catalog/partials/product.phtml',
                                            ['product' => $item_product, 'size' => 'product_hp_card']) ?>
                                    </div>
                                <?php endif; ?>
                            <?php endforeach; ?>
                        </div>
                    </div>
                <?php endif; ?>
            <?php endif; ?>
            <div class="morePost row featuredPostContainer style2">
                <h3 class="section-title style2 text-center"><span><?php echo $this->escape($this->label) ?></span></h3>
                <div class="row xsResponse categoryProduct">
                    <?php foreach ($this->naposledy as $item_product): ?>
                        <?php if (($item_product->getProperty(PCT::ESHOP_EUR_PRICE_INCLUDING_VAT_HU_TAG) !== false && PH::isHu()) || (PH::isCz() || PH::isSk())): ?>
                            <div class="item col-lg-3 col-md-3 col-sm-3 col-xs-6">
                                <?php echo $this->partial('eshop/catalog/partials/product.phtml',
                                    ['product' => $item_product->getPage(), 'size' => 'product_hp_card']) ?>
                            </div>
                        <?php endif; ?>
                    <?php endforeach; ?>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <?php if ($this->page->hasPageListSet(PCT::NAJPREDAVANEJSIE_TAG)): ?>
                <div class="bestsellers">
                    <div class="bestsellers__heading"><?php echo \Trans::str('common', 'NAJPREDÁVANEJŠIE'); ?></div>
                    <?php $counter = 1; ?>
                    <?php foreach ($this->page->getPageListSet(PCT::NAJPREDAVANEJSIE_TAG) as $item): ?>
 
 
                        <?php if (($item->getProperty(PCT::ESHOP_EUR_PRICE_INCLUDING_VAT_HU_TAG) !== false && PH::isHu()) || (PH::isCz() || PH::isSk())): ?>
                            <div class="row bestsellers__item">

     * Should the stream wrapper be used if short_open_tag is off?
     *
     * @return bool
     */
    public function useStreamWrapper()
    {
        return $this->_useStreamWrapper;
    }
 
    /**
     * Includes the view script in a scope with only public $this variables.
     *
     * @param string The view script to execute.
     */
    protected function _run()
    {
        if ($this->_useViewStream && $this->useStreamWrapper()) {
            include 'zend.view://' . func_get_arg(0);
        } else {
            include func_get_arg(0);
        }
    }
}
 

            if ('_' != substr($key, 0, 1)) {
                unset($this->$key);
            }
        }
    }
 
    /**
     * Processes a view script and returns the output.
     *
     * @param string $name The script name to process.
     * @return string The script output.
     */
    public function render($name)
    {
        // find the script file name using the parent private method
        $this->_file = $this->_script($name);
        unset($name); // remove $name from local scope
 
        ob_start();
        $this->_run($this->_file);
 
        return $this->_filter(ob_get_clean()); // filter output
    }
 
    /**
     * Escapes a value for output in a view script.
     *
     * If escaping mechanism is one of htmlspecialchars or htmlentities, uses
     * {@link $_encoding} setting.
     *
     * @param mixed $var The output to escape.
     * @return mixed The escaped value.
     */
    public function escape($var)
    {
        if (in_array($this->_escape, array('htmlspecialchars', 'htmlentities'))) {
            return call_user_func($this->_escape, $var, ENT_COMPAT, $this->_encoding);
        }
 
        if (1 == func_num_args()) {

        return $filtered;
    }
 
    /**
     * Render a view script (optionally to a named response segment)
     *
     * Sets the noRender flag to true when called.
     *
     * @param  string $script
     * @param  string $name
     * @return void
     */
    public function renderScript($script, $name = null)
    {
        if (null === $name) {
            $name = $this->getResponseSegment();
        }
 
        $this->getResponse()->appendBody(
            $this->view->render($script),
            $name
        );
 
        $this->setNoRender();
    }
 
    /**
     * Render a view based on path specifications
     *
     * Renders a view based on the view script path specifications.
     *
     * @param  string  $action
     * @param  string  $name
     * @param  boolean $noController
     * @return void
     */
    public function render($action = null, $name = null, $noController = null)
    {
        $this->setRender($action, $name, $noController);
        $path = $this->getViewScript();

        );
 
        $this->setNoRender();
    }
 
    /**
     * Render a view based on path specifications
     *
     * Renders a view based on the view script path specifications.
     *
     * @param  string  $action
     * @param  string  $name
     * @param  boolean $noController
     * @return void
     */
    public function render($action = null, $name = null, $noController = null)
    {
        $this->setRender($action, $name, $noController);
        $path = $this->getViewScript();
        $this->renderScript($path, $name);
    }
 
    /**
     * Render a script based on specification variables
     *
     * Pass an action, and one or more specification variables (view script suffix)
     * to determine the view script path, and render that script.
     *
     * @param  string $action
     * @param  array  $vars
     * @param  string $name
     * @return void
     */
    public function renderBySpec($action = null, array $vars = array(), $name = null)
    {
        if (null !== $name) {
            $this->setResponseSegment($name);
        }
 
        $path = $this->getViewScript($action, $vars);

        $path = $this->getViewScript($action, $vars);
 
        $this->renderScript($path);
    }
 
    /**
     * postDispatch - auto render a view
     *
     * Only autorenders if:
     * - _noRender is false
     * - action controller is present
     * - request has not been re-dispatched (i.e., _forward() has not been called)
     * - response is not a redirect
     *
     * @return void
     */
    public function postDispatch()
    {
        if ($this->_shouldRender()) {
            $this->render();
        }
    }
 
    /**
     * Should the ViewRenderer render a view script?
     *
     * @return boolean
     */
    protected function _shouldRender()
    {
        return (!$this->getFrontController()->getParam('noViewRenderer')
            && !$this->_neverRender
            && !$this->_noRender
            && (null !== $this->_actionController)
            && $this->getRequest()->isDispatched()
            && !$this->getResponse()->isRedirect()
        );
    }
 
    /**

     * notifyPreDispatch() - called by action controller dispatch method
     *
     * @return void
     */
    public function notifyPreDispatch()
    {
        foreach (self::getStack() as $helper) {
            $helper->preDispatch();
        }
    }
 
    /**
     * notifyPostDispatch() - called by action controller dispatch method
     *
     * @return void
     */
    public function notifyPostDispatch()
    {
        foreach (self::getStack() as $helper) {
            $helper->postDispatch();
        }
    }
 
    /**
     * getHelper() - get helper by name
     *
     * @param  string $name
     * @return Zend_Controller_Action_Helper_Abstract
     */
    public function getHelper($name)
    {
        $name  = self::_normalizeHelperName($name);
        $stack = self::getStack();
 
        if (!isset($stack->{$name})) {
            self::_loadHelper($name);
        }
 
        $helper = $stack->{$name};
 

            // If pre-dispatch hooks introduced a redirect then stop dispatch
            // @see ZF-7496
            if (!($this->getResponse()->isRedirect())) {
                // preDispatch() didn't change the action, so we can continue
                if ($this->getInvokeArg('useCaseSensitiveActions') || in_array($action, $this->_classMethods)) {
                    if ($this->getInvokeArg('useCaseSensitiveActions')) {
                        trigger_error('Using case sensitive actions without word separators is deprecated; please do not rely on this "feature"');
                    }
                    $this->$action();
                } else {
                    $this->__call($action, array());
                }
            }
            $this->postDispatch();
        }
 
        // whats actually important here is that this action controller is
        // shutting down, regardless of dispatching; notify the helpers of this
        // state
        $this->_helper->notifyPostDispatch();
    }
 
    /**
     * Call the action specified in the request object, and return a response
     *
     * Not used in the Action Controller implementation, but left for usage in
     * Page Controller implementations. Dispatches a method based on the
     * request.
     *
     * Returns a Zend_Controller_Response_Abstract object, instantiating one
     * prior to execution if none exists in the controller.
     *
     * {@link preDispatch()} is called prior to the action,
     * {@link postDispatch()} is called following it.
     *
     * @param null|Zend_Controller_Request_Abstract $request Optional request
     * object to use
     * @param null|Zend_Controller_Response_Abstract $response Optional response
     * object to use
     * @return Zend_Controller_Response_Abstract

 
        /**
         * Retrieve the action name
         */
        $action = $this->getActionMethod($request);
 
        /**
         * Dispatch the method call
         */
        $request->setDispatched(true);
 
        // by default, buffer output
        $disableOb = $this->getParam('disableOutputBuffering');
        $obLevel   = ob_get_level();
        if (empty($disableOb)) {
            ob_start();
        }
 
        try {
            $controller->dispatch($action);
        } catch (Exception $e) {
            // Clean output buffer on error
            $curObLevel = ob_get_level();
            if ($curObLevel > $obLevel) {
                do {
                    ob_get_clean();
                    $curObLevel = ob_get_level();
                } while ($curObLevel > $obLevel);
            }
            throw $e;
        }
 
        if (empty($disableOb)) {
            $content = ob_get_clean();
            $response->appendBody($content);
        }
 
        // Destroy the page controller instance and reflection objects
        $controller = null;
    }

            do {
                $this->_request->setDispatched(true);
 
                /**
                 * Notify plugins of dispatch startup
                 */
                $this->_plugins->preDispatch($this->_request);
 
                /**
                 * Skip requested action if preDispatch() has reset it
                 */
                if (!$this->_request->isDispatched()) {
                    continue;
                }
 
                /**
                 * Dispatch request
                 */
                try {
                    $dispatcher->dispatch($this->_request, $this->_response);
                } catch (Exception $e) {
                    if ($this->throwExceptions()) {
                        throw $e;
                    }
                    $this->_response->setException($e);
                }
 
                /**
                 * Notify plugins of dispatch completion
                 */
                $this->_plugins->postDispatch($this->_request);
            } while (!$this->_request->isDispatched());
        } catch (Exception $e) {
            if ($this->throwExceptions()) {
                throw $e;
            }
 
            $this->_response->setException($e);
        }
 

 
		// Set router
		$front->setRouter(new ControllerRouter());
 
		// Set controller and action
		$request = new Zend_Controller_Request_Http();
		$request->setControllerName($controller_name);
		$request->setActionName($controller_action);
 
        \Buxus\Event\BuxusEvent::fire(new \Buxus\Event\MvcStartedEvent());
 
        // add registered view helpers
        //$view = \Zend_Layout::getMvcInstance()->getView();
 
/*        $module_view_helper_paths = \Buxus\Module\BuxusModule::helperPaths();
        foreach ($module_view_helper_paths as $helper_path) {
            $view->addHelperPath($helper_path['path'], $helper_path['prefix']);
        }*/
 
		$front->dispatch($request);
    }
}
 
function CreateUrlForPageName ($page_name, $url_parameter="", $quotes = "'")
{
  global $as_static;
  $page_dsc = BuxusDB::get()->fetchAll("SELECT tblPages.page_id FROM tblPages WHERE tblPages.page_name = :page_name", array(':page_name' => $page_name));
  $i = 0;
  foreach($page_dsc as $page_row)
  {
    $page_id = $page_row["page_id"];
    $i++;
  }
  if ($i>1)
    //echo "What now? There are more than one unique page with given name.";
  if ($i == 0) { $page_id = 0; }
  if ($as_static != '')
    return ($quotes.GetSystemOption("C_static_url_prefix")."page_$page_id.htm".$url_parameter.$quotes);
  else
    return ($quotes.config('buxus_core.base_url')."generate_page.php?page_id=$page_id".$url_parameter.$quotes);

	$page_name = (isset($_GET['page_name']) ? $_GET['page_name'] : '');
		
	if (!empty($page_name)) {
		//funckia skonci, ak nenajde, alebo najde viac
		$page_id = GetPageIdByPageName($page_name);
	} else {
		if (!showCustomError('404')) {
			header('HTTP/1.0 404 Not Found');
  			echo 'Wrong page ID specified.';
  		}
  		exit;
  	}
} else {
    $wrong_page_id = C_True;
}
 
$_REQUEST['page_id'] = $page_id;
$_GET['page_id'] = $page_id;
 
GeneratePage($page_id);
 
\Buxus\Event\BuxusEvent::fire(new \Buxus\Event\FrontendRequestFinishedEvent());
 
exit;

            echo '<html><head><title>maintenance</title></head><body>This BUXUS application is undergoing maintenance. Please try again later</body></html>';
        } else {
            include $template_path;
        }
    }
 
    public function dispatch($request_uri) {
        if ($this->app->isDownForMaintenance()) {
            $this->display503();
            exit;
        }
 
        $script = $this->getScript($request_uri);
 
        foreach ($this->auto_scripts as $auto_script) {
            include($auto_script);
        }
 
        if (!empty($script)) {
            include($script);
        }
 
        if ($this->default_script != $script) {
            include($this->default_script);
        }
 
        header('HTTP/1.0 404 Not Found');
        echo '404 Not Found';
        exit;
    }
}

<?php
define('BASE_BUXUS_DIR', realpath(__DIR__ . '/../'));
require_once __DIR__ . '/../vendor/autoload.php';
require_once CORE_BUXUS_DIR . '/src/buxus_bootstrap.php';
$router = app('buxus-router');
$router->dispatch($_SERVER['REQUEST_URI']);