Zend_Db_Statement_Exception (42)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'evuc_live.tblFSCache_fsi' doesn't exist SQL: SELECT ROUND( 1.609344 * 6377.83027 * ACOS(ROUND( SIN( 48.9377114*PI()/180 ) * SIN( REPLACE(lat.property_value,',','.') * PI()/180 ) + COS( 48.9377114*PI()/180 ) * COS( REPLACE(lat.property_value,',','.') * PI()/180 ) * COS( (REPLACE(lon.property_value,',','.') * PI()/180) - (18.1157547*PI()/180) ) ,15) ) , 1) AS distance, page.page_id AS page_id FROM tblPages AS page LEFT JOIN tblPagePropertyValues AS lat ON page.page_id = lat.page_id AND lat.property_id = 149 LEFT JOIN tblPagePropertyValues AS lon ON page.page_id = lon.page_id AND lon.property_id = 150 LEFT JOIN tblPages AS mesto ON page.parent_page_id = mesto.page_id LEFT JOIN tblPages AS rubrika ON mesto.parent_page_id = rubrika.page_id LEFT JOIN tblPages AS sekcia ON rubrika.parent_page_id = sekcia.page_id LEFT JOIN tblPages AS kraj ON sekcia.parent_page_id = kraj.page_id LEFT JOIN tblFSCache_fsi AS evuc_index ON evuc_index.page_id = page.page_id WHERE page.page_type_id = 26 AND page.page_state_id = 1 AND page.page_id != 63103 AND lat.property_value != '' AND kraj.page_state_id = 1 AND sekcia.page_state_id = 1 AND rubrika.page_state_id = 1 AND mesto.page_state_id = 1 AND evuc_index.typ_zariadenia IN (65843) HAVING distance < 100 ORDER BY distance ASC, page.page_id DESC LIMIT 0, 10 PARAMS: array ( )
Previous exceptions
  • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'evuc_live.tblFSCache_fsi' doesn't exist (42S02)
Zend_Db_Statement_Exception thrown with message "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'evuc_live.tblFSCache_fsi' doesn't exist SQL: SELECT ROUND( 1.609344 * 6377.83027 * ACOS(ROUND( SIN( 48.9377114*PI()/180 ) * SIN( REPLACE(lat.property_value,',','.') * PI()/180 ) + COS( 48.9377114*PI()/180 ) * COS( REPLACE(lat.property_value,',','.') * PI()/180 ) * COS( (REPLACE(lon.property_value,',','.') * PI()/180) - (18.1157547*PI()/180) ) ,15) ) , 1) AS distance, page.page_id AS page_id FROM tblPages AS page LEFT JOIN tblPagePropertyValues AS lat ON page.page_id = lat.page_id AND lat.property_id = 149 LEFT JOIN tblPagePropertyValues AS lon ON page.page_id = lon.page_id AND lon.property_id = 150 LEFT JOIN tblPages AS mesto ON page.parent_page_id = mesto.page_id LEFT JOIN tblPages AS rubrika ON mesto.parent_page_id = rubrika.page_id LEFT JOIN tblPages AS sekcia ON rubrika.parent_page_id = sekcia.page_id LEFT JOIN tblPages AS kraj ON sekcia.parent_page_id = kraj.page_id LEFT JOIN tblFSCache_fsi AS evuc_index ON evuc_index.page_id = page.page_id WHERE page.page_type_id = 26 AND page.page_state_id = 1 AND page.page_id != 63103 AND lat.property_value != '' AND kraj.page_state_id = 1 AND sekcia.page_state_id = 1 AND rubrika.page_state_id = 1 AND mesto.page_state_id = 1 AND evuc_index.typ_zariadenia IN (65843) HAVING distance < 100 ORDER BY distance ASC, page.page_id DESC LIMIT 0, 10 PARAMS: array ( )" Stacktrace: #25 Zend_Db_Statement_Exception in /home/evuc/live/releases/20220124095935/vendor/buxus/legacy-base/buxus/includes/classes/db/buxus_db_statement_pdo.php:24 #24 PDOException in /home/evuc/live/releases/20220124095935/vendor/buxus/legacy-base/buxus/includes/classes/db/buxus_db_statement_pdo.php:18 #23 PDOStatement:execute in /home/evuc/live/releases/20220124095935/vendor/buxus/legacy-base/buxus/includes/classes/db/buxus_db_statement_pdo.php:18 #22 BuxusDB_Statement_PDO:_execute in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Db/Statement.php:303 #21 Zend_Db_Statement:execute in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php:480 #20 Zend_Db_Adapter_Abstract:query in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238 #19 Zend_Db_Adapter_Pdo_Abstract:query in /home/evuc/live/releases/20220124095935/vendor/buxus/legacy-base/buxus/includes/classes/db/buxus_db_adapter_mysql.php:92 #18 BuxusDB_Adapter_Mysql:query in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php:737 #17 Zend_Db_Adapter_Abstract:fetchAll in /home/evuc/live/releases/20220124095935/buxus/application/models/Api/BasicList.php:174 #16 Api\BasicList:searchNearest in /home/evuc/live/releases/20220124095935/buxus/application/models/App/NajblizsieZariadeniaList.php:16 #15 App\NajblizsieZariadeniaList:getItems in /home/evuc/live/releases/20220124095935/buxus/application/models/App/Page/ZdravotnickeZariadeniePage.php:30 #14 App\Page\ZdravotnickeZariadeniePage:getNajblizsie in /home/evuc/live/releases/20220124095935/buxus/application/models/App/Page/ZdravotnickeZariadeniePage.php:22 #13 App\Page\ZdravotnickeZariadeniePage:hasNajblizsie in /home/evuc/live/releases/20220124095935/buxus/application/views/scripts/index/index.phtml:84 #12 include in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/View.php:157 #11 Zend_View:_run in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/View/Abstract.php:888 #10 Zend_View_Abstract:render in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Controller/Action/Helper/ViewRenderer.php:912 #9 Zend_Controller_Action_Helper_ViewRenderer:renderScript in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Controller/Action/Helper/ViewRenderer.php:933 #8 Zend_Controller_Action_Helper_ViewRenderer:render in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Controller/Action/Helper/ViewRenderer.php:972 #7 Zend_Controller_Action_Helper_ViewRenderer:postDispatch in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Controller/Action/HelperBroker.php:277 #6 Zend_Controller_Action_HelperBroker:notifyPostDispatch in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php:527 #5 Zend_Controller_Action:dispatch in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Controller/Dispatcher/Standard.php:308 #4 Zend_Controller_Dispatcher_Standard:dispatch in /home/evuc/live/releases/20220124095935/vendor/zendframework/zendframework1/library/Zend/Controller/Front.php:954 #3 Zend_Controller_Front:dispatch in /home/evuc/live/releases/20220124095935/vendor/buxus/legacy-base/buxus/includes/generate_functions.php:151 #2 GeneratePage in /home/evuc/live/releases/20220124095935/vendor/buxus/core/src/handler/generate_page.php:47 #1 include in /home/evuc/live/releases/20220124095935/vendor/buxus/core/src/Buxus/Router/BuxusRouter.php:86 #0 Buxus\Router\BuxusRouter:dispatch in /home/evuc/live/releases/20220124095935/public/buxus.php:10
Stack frames (26)
25
Zend_Db_Statement_Exception
/
vendor
/
buxus
/
legacy-base
/
buxus
/
includes
/
classes
/
db
/
buxus_db_statement_pdo.php
24
24
PDOException
/
vendor
/
buxus
/
legacy-base
/
buxus
/
includes
/
classes
/
db
/
buxus_db_statement_pdo.php
18
23
PDOStatement
execute
/
vendor
/
buxus
/
legacy-base
/
buxus
/
includes
/
classes
/
db
/
buxus_db_statement_pdo.php
18
22
BuxusDB_Statement_PDO
_execute
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Db
/
Statement.php
303
21
Zend_Db_Statement
execute
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Db
/
Adapter
/
Abstract.php
480
20
Zend_Db_Adapter_Abstract
query
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Db
/
Adapter
/
Pdo
/
Abstract.php
238
19
Zend_Db_Adapter_Pdo_Abstract
query
/
vendor
/
buxus
/
legacy-base
/
buxus
/
includes
/
classes
/
db
/
buxus_db_adapter_mysql.php
92
18
BuxusDB_Adapter_Mysql
query
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Db
/
Adapter
/
Abstract.php
737
17
Zend_Db_Adapter_Abstract
fetchAll
/
buxus
/
application
/
models
/
Api
/
BasicList.php
174
16
Api
\
BasicList
searchNearest
/
buxus
/
application
/
models
/
App
/
NajblizsieZariadeniaList.php
16
15
App
\
NajblizsieZariadeniaList
getItems
/
buxus
/
application
/
models
/
App
/
Page
/
ZdravotnickeZariadeniePage.php
30
14
App
\
Page
\
ZdravotnickeZariadeniePage
getNajblizsie
/
buxus
/
application
/
models
/
App
/
Page
/
ZdravotnickeZariadeniePage.php
22
13
App
\
Page
\
ZdravotnickeZariadeniePage
hasNajblizsie
/
buxus
/
application
/
views
/
scripts
/
index
/
index.phtml
84
12
include
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
View.php
157
11
Zend_View
_run
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
View
/
Abstract.php
888
10
Zend_View_Abstract
render
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Action
/
Helper
/
ViewRenderer.php
912
9
Zend_Controller_Action_Helper_ViewRenderer
renderScript
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Action
/
Helper
/
ViewRenderer.php
933
8
Zend_Controller_Action_Helper_ViewRenderer
render
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Action
/
Helper
/
ViewRenderer.php
972
7
Zend_Controller_Action_Helper_ViewRenderer
postDispatch
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Action
/
HelperBroker.php
277
6
Zend_Controller_Action_HelperBroker
notifyPostDispatch
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Action.php
527
5
Zend_Controller_Action
dispatch
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Dispatcher
/
Standard.php
308
4
Zend_Controller_Dispatcher_Standard
dispatch
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Front.php
954
3
Zend_Controller_Front
dispatch
/
vendor
/
buxus
/
legacy-base
/
buxus
/
includes
/
generate_functions.php
151
2
GeneratePage
/
vendor
/
buxus
/
core
/
src
/
handler
/
generate_page.php
47
1
include
/
vendor
/
buxus
/
core
/
src
/
Buxus
/
Router
/
BuxusRouter.php
86
0
Buxus
\
Router
\
BuxusRouter
dispatch
/
public
/
buxus.php
10
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
buxus
/
legacy-base
/
buxus
/
includes
/
classes
/
db
/
buxus_db_statement_pdo.php
     * Executes a prepared statement.
     *
     * @param array $params OPTIONAL Values to bind to parameter placeholders.
     * @return bool
     * @throws Zend_Db_Statement_Exception
     */
    public function _execute(array $params = null) {
        $_previous_error_level = error_reporting();
        error_reporting(0);
 
        $_start = microtime(true);
        try {
            if ($params !== null) {
                $result = $this->_stmt->execute($params);
            } else {
                $result = $this->_stmt->execute();
            }
        } catch (PDOException $e) {
            error_reporting($_previous_error_level);
            throw new Zend_Db_Statement_Exception($e->getMessage() . ' SQL: ' . $this->_stmt->queryString . ' PARAMS: ' . var_export($params, true), (int) $e->getCode(), $e);
        }
 
        error_reporting($_previous_error_level);
        \Buxus\Event\BuxusEvent::fire(new \Buxus\Event\Database\QueryExecuted($this->_stmt->queryString, $params, (microtime(true) - $_start)));
        return $result;
    }
}
 
Arguments
  1. """
    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'evuc_live.tblFSCache_fsi' doesn't exist SQL: \r\n
                SELECT\r\n
                    ROUND(\r\n
                            1.609344 *\r\n
                            6377.83027 *\r\n
                            ACOS(ROUND(\r\n
                                SIN( 48.9377114*PI()/180 ) * SIN( REPLACE(lat.property_value,',','.') * PI()/180 )\r\n
                                + COS( 48.9377114*PI()/180 ) * COS( REPLACE(lat.property_value,',','.') * PI()/180 )  *  COS( (REPLACE(lon.property_value,',','.') * PI()/180) - (18.1157547*PI()/180) )\r\n
                                ,15)\r\n
                            )\r\n
                    , 1)\r\n
                    AS distance,\r\n
                    page.page_id AS page_id\r\n
                FROM\r\n
                  tblPages AS page\r\n
                LEFT JOIN tblPagePropertyValues AS lat\r\n
                    ON page.page_id = lat.page_id\r\n
                    AND lat.property_id = 149\r\n
                LEFT JOIN tblPagePropertyValues AS lon\r\n
                    ON page.page_id = lon.page_id\r\n
                    AND lon.property_id = 150\r\n
                LEFT JOIN\r\n
                    tblPages AS mesto\r\n
                    ON page.parent_page_id = mesto.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS rubrika\r\n
                    ON mesto.parent_page_id = rubrika.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS sekcia\r\n
                    ON rubrika.parent_page_id = sekcia.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS kraj\r\n
                    ON sekcia.parent_page_id = kraj.page_id\r\n
            \r\n
                    LEFT JOIN\r\n
                        tblFSCache_fsi AS evuc_index\r\n
                        ON evuc_index.page_id = page.page_id\r\n
    \t\t    \r\n
                WHERE\r\n
                    page.page_type_id = 26\r\n
                AND\r\n
                    page.page_state_id = 1\r\n
                AND\r\n
                    page.page_id != 63103\r\n
                AND\r\n
                    lat.property_value != ''\r\n
                AND\r\n
                    kraj.page_state_id = 1\r\n
                AND\r\n
                    sekcia.page_state_id = 1\r\n
                AND\r\n
                    rubrika.page_state_id = 1\r\n
                AND\r\n
                    mesto.page_state_id = 1\r\n
            \r\n
                    AND\r\n
                        evuc_index.typ_zariadenia IN (65843)\r\n
    \t\t    \r\n
                HAVING\r\n
                    distance < 100\r\n
                ORDER BY\r\n
                    distance ASC, page.page_id DESC\r\n
                LIMIT\r\n
                    0, 10\r\n
    \t\t PARAMS: array (\n
    )
    """
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
buxus
/
legacy-base
/
buxus
/
includes
/
classes
/
db
/
buxus_db_statement_pdo.php
<?php
 
class BuxusDB_Statement_PDO extends Zend_Db_Statement_Pdo {
    /**
     * Executes a prepared statement.
     *
     * @param array $params OPTIONAL Values to bind to parameter placeholders.
     * @return bool
     * @throws Zend_Db_Statement_Exception
     */
    public function _execute(array $params = null) {
        $_previous_error_level = error_reporting();
        error_reporting(0);
 
        $_start = microtime(true);
        try {
            if ($params !== null) {
                $result = $this->_stmt->execute($params);
            } else {
                $result = $this->_stmt->execute();
            }
        } catch (PDOException $e) {
            error_reporting($_previous_error_level);
            throw new Zend_Db_Statement_Exception($e->getMessage() . ' SQL: ' . $this->_stmt->queryString . ' PARAMS: ' . var_export($params, true), (int) $e->getCode(), $e);
        }
 
        error_reporting($_previous_error_level);
        \Buxus\Event\BuxusEvent::fire(new \Buxus\Event\Database\QueryExecuted($this->_stmt->queryString, $params, (microtime(true) - $_start)));
        return $result;
    }
}
 
Arguments
  1. "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'evuc_live.tblFSCache_fsi' doesn't exist"
    
Exception message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'evuc_live.tblFSCache_fsi' doesn't exist
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
buxus
/
legacy-base
/
buxus
/
includes
/
classes
/
db
/
buxus_db_statement_pdo.php
<?php
 
class BuxusDB_Statement_PDO extends Zend_Db_Statement_Pdo {
    /**
     * Executes a prepared statement.
     *
     * @param array $params OPTIONAL Values to bind to parameter placeholders.
     * @return bool
     * @throws Zend_Db_Statement_Exception
     */
    public function _execute(array $params = null) {
        $_previous_error_level = error_reporting();
        error_reporting(0);
 
        $_start = microtime(true);
        try {
            if ($params !== null) {
                $result = $this->_stmt->execute($params);
            } else {
                $result = $this->_stmt->execute();
            }
        } catch (PDOException $e) {
            error_reporting($_previous_error_level);
            throw new Zend_Db_Statement_Exception($e->getMessage() . ' SQL: ' . $this->_stmt->queryString . ' PARAMS: ' . var_export($params, true), (int) $e->getCode(), $e);
        }
 
        error_reporting($_previous_error_level);
        \Buxus\Event\BuxusEvent::fire(new \Buxus\Event\Database\QueryExecuted($this->_stmt->queryString, $params, (microtime(true) - $_start)));
        return $result;
    }
}
 
Arguments
  1. []
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Db
/
Statement.php
     * @return bool
     */
    public function bindValue($parameter, $value, $type = null)
    {
        return $this->bindParam($parameter, $value, $type);
    }
 
    /**
     * Executes a prepared statement.
     *
     * @param array $params OPTIONAL Values to bind to parameter placeholders.
     * @return bool
     */
    public function execute(array $params = null)
    {
        /*
         * Simple case - no query profiler to manage.
         */
        if ($this->_queryId === null) {
            return $this->_execute($params);
        }
 
        /*
         * Do the same thing, but with query profiler
         * management before and after the execute.
         */
        $prof = $this->_adapter->getProfiler();
        $qp = $prof->getQueryProfile($this->_queryId);
        if ($qp->hasEnded()) {
            $this->_queryId = $prof->queryClone($qp);
            $qp = $prof->getQueryProfile($this->_queryId);
        }
        if ($params !== null) {
            $qp->bindParams($params);
        } else {
            $qp->bindParams($this->_bindParam);
        }
        $qp->start($this->_queryId);
 
        $retval = $this->_execute($params);
Arguments
  1. []
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Db
/
Adapter
/
Abstract.php
 
        // is the $sql a Zend_Db_Select object?
        if ($sql instanceof Zend_Db_Select) {
            if (empty($bind)) {
                $bind = $sql->getBind();
            }
 
            $sql = $sql->assemble();
        }
 
        // make sure $bind to an array;
        // don't use (array) typecasting because
        // because $bind may be a Zend_Db_Expr object
        if (!is_array($bind)) {
            $bind = array($bind);
        }
 
        // prepare and execute the statement with profiling
        $stmt = $this->prepare($sql);
        $stmt->execute($bind);
 
        // return the results embedded in the prepared statement object
        $stmt->setFetchMode($this->_fetchMode);
        return $stmt;
    }
 
    /**
     * Leave autocommit mode and begin a transaction.
     *
     * @return Zend_Db_Adapter_Abstract
     */
    public function beginTransaction()
    {
        $this->_connect();
        $q = $this->_profiler->queryStart('begin', Zend_Db_Profiler::TRANSACTION);
        $this->_beginTransaction();
        $this->_profiler->queryEnd($q);
        return $this;
    }
 
Arguments
  1. []
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Db
/
Adapter
/
Pdo
/
Abstract.php
     * @throws Zend_Db_Adapter_Exception To re-throw PDOException.
     */
    public function query($sql, $bind = array())
    {
        if (empty($bind) && $sql instanceof Zend_Db_Select) {
            $bind = $sql->getBind();
        }
 
        if (is_array($bind)) {
            foreach ($bind as $name => $value) {
                if (!is_int($name) && !preg_match('/^:/', $name)) {
                    $newName = ":$name";
                    unset($bind[$name]);
                    $bind[$newName] = $value;
                }
            }
        }
 
        try {
            return parent::query($sql, $bind);
        } catch (PDOException $e) {
            /**
             * @see Zend_Db_Statement_Exception
             */
            require_once 'Zend/Db/Statement/Exception.php';
            throw new Zend_Db_Statement_Exception($e->getMessage(), $e->getCode(), $e);
        }
    }
 
    /**
     * Executes an SQL statement and return the number of affected rows
     *
     * @param  mixed  $sql  The SQL statement with placeholders.
     *                      May be a string or Zend_Db_Select.
     * @return integer      Number of rows that were modified
     *                      or deleted by the SQL statement
     */
    public function exec($sql)
    {
        if ($sql instanceof Zend_Db_Select) {
Arguments
  1. """
    \r\n
                SELECT\r\n
                    ROUND(\r\n
                            1.609344 *\r\n
                            6377.83027 *\r\n
                            ACOS(ROUND(\r\n
                                SIN( 48.9377114*PI()/180 ) * SIN( REPLACE(lat.property_value,',','.') * PI()/180 )\r\n
                                + COS( 48.9377114*PI()/180 ) * COS( REPLACE(lat.property_value,',','.') * PI()/180 )  *  COS( (REPLACE(lon.property_value,',','.') * PI()/180) - (18.1157547*PI()/180) )\r\n
                                ,15)\r\n
                            )\r\n
                    , 1)\r\n
                    AS distance,\r\n
                    page.page_id AS page_id\r\n
                FROM\r\n
                  tblPages AS page\r\n
                LEFT JOIN tblPagePropertyValues AS lat\r\n
                    ON page.page_id = lat.page_id\r\n
                    AND lat.property_id = 149\r\n
                LEFT JOIN tblPagePropertyValues AS lon\r\n
                    ON page.page_id = lon.page_id\r\n
                    AND lon.property_id = 150\r\n
                LEFT JOIN\r\n
                    tblPages AS mesto\r\n
                    ON page.parent_page_id = mesto.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS rubrika\r\n
                    ON mesto.parent_page_id = rubrika.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS sekcia\r\n
                    ON rubrika.parent_page_id = sekcia.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS kraj\r\n
                    ON sekcia.parent_page_id = kraj.page_id\r\n
            \r\n
                    LEFT JOIN\r\n
                        tblFSCache_fsi AS evuc_index\r\n
                        ON evuc_index.page_id = page.page_id\r\n
    \t\t    \r\n
                WHERE\r\n
                    page.page_type_id = 26\r\n
                AND\r\n
                    page.page_state_id = 1\r\n
                AND\r\n
                    page.page_id != 63103\r\n
                AND\r\n
                    lat.property_value != ''\r\n
                AND\r\n
                    kraj.page_state_id = 1\r\n
                AND\r\n
                    sekcia.page_state_id = 1\r\n
                AND\r\n
                    rubrika.page_state_id = 1\r\n
                AND\r\n
                    mesto.page_state_id = 1\r\n
            \r\n
                    AND\r\n
                        evuc_index.typ_zariadenia IN (65843)\r\n
    \t\t    \r\n
                HAVING\r\n
                    distance < 100\r\n
                ORDER BY\r\n
                    distance ASC, page.page_id DESC\r\n
                LIMIT\r\n
                    0, 10\r\n
    \t\t
    """
    
  2. []
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
buxus
/
legacy-base
/
buxus
/
includes
/
classes
/
db
/
buxus_db_adapter_mysql.php
        $this->_connection = null;
        $this->_connect();
    }
 
    public function disconnect()
    {
        $this->_connection = null;
    }
 
    public function query($sql, $bind = array()) {
        try {
            if (is_array($bind)) {
                foreach ($bind as $key => $value) {
                    if (is_string($key) && is_array($value)) {
                        $sql = preg_replace('@' . preg_quote($key) . '@', implode(',', $value), $sql);
                        unset($bind[$key]);
                    }
                }
            }
            $result = parent::query($sql, $bind);
        } catch (\Exception $e)  {
            if ($this->causedByLostConnection($e)) {
                $this->reconnect();
                $result = parent::query($sql, $bind);
            } else {
                throw $e;
            }
        }
 
        return $result;
    }
 
 
}
 
Arguments
  1. """
    \r\n
                SELECT\r\n
                    ROUND(\r\n
                            1.609344 *\r\n
                            6377.83027 *\r\n
                            ACOS(ROUND(\r\n
                                SIN( 48.9377114*PI()/180 ) * SIN( REPLACE(lat.property_value,',','.') * PI()/180 )\r\n
                                + COS( 48.9377114*PI()/180 ) * COS( REPLACE(lat.property_value,',','.') * PI()/180 )  *  COS( (REPLACE(lon.property_value,',','.') * PI()/180) - (18.1157547*PI()/180) )\r\n
                                ,15)\r\n
                            )\r\n
                    , 1)\r\n
                    AS distance,\r\n
                    page.page_id AS page_id\r\n
                FROM\r\n
                  tblPages AS page\r\n
                LEFT JOIN tblPagePropertyValues AS lat\r\n
                    ON page.page_id = lat.page_id\r\n
                    AND lat.property_id = 149\r\n
                LEFT JOIN tblPagePropertyValues AS lon\r\n
                    ON page.page_id = lon.page_id\r\n
                    AND lon.property_id = 150\r\n
                LEFT JOIN\r\n
                    tblPages AS mesto\r\n
                    ON page.parent_page_id = mesto.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS rubrika\r\n
                    ON mesto.parent_page_id = rubrika.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS sekcia\r\n
                    ON rubrika.parent_page_id = sekcia.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS kraj\r\n
                    ON sekcia.parent_page_id = kraj.page_id\r\n
            \r\n
                    LEFT JOIN\r\n
                        tblFSCache_fsi AS evuc_index\r\n
                        ON evuc_index.page_id = page.page_id\r\n
    \t\t    \r\n
                WHERE\r\n
                    page.page_type_id = 26\r\n
                AND\r\n
                    page.page_state_id = 1\r\n
                AND\r\n
                    page.page_id != 63103\r\n
                AND\r\n
                    lat.property_value != ''\r\n
                AND\r\n
                    kraj.page_state_id = 1\r\n
                AND\r\n
                    sekcia.page_state_id = 1\r\n
                AND\r\n
                    rubrika.page_state_id = 1\r\n
                AND\r\n
                    mesto.page_state_id = 1\r\n
            \r\n
                    AND\r\n
                        evuc_index.typ_zariadenia IN (65843)\r\n
    \t\t    \r\n
                HAVING\r\n
                    distance < 100\r\n
                ORDER BY\r\n
                    distance ASC, page.page_id DESC\r\n
                LIMIT\r\n
                    0, 10\r\n
    \t\t
    """
    
  2. []
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Db
/
Adapter
/
Abstract.php
    public function getFetchMode()
    {
        return $this->_fetchMode;
    }
 
    /**
     * Fetches all SQL result rows as a sequential array.
     * Uses the current fetchMode for the adapter.
     *
     * @param string|Zend_Db_Select $sql  An SQL SELECT statement.
     * @param mixed                 $bind Data to bind into SELECT placeholders.
     * @param mixed                 $fetchMode Override current fetch mode.
     * @return array
     */
    public function fetchAll($sql, $bind = array(), $fetchMode = null)
    {
        if ($fetchMode === null) {
            $fetchMode = $this->_fetchMode;
        }
        $stmt = $this->query($sql, $bind);
        $result = $stmt->fetchAll($fetchMode);
        return $result;
    }
 
    /**
     * Fetches the first row of the SQL result.
     * Uses the current fetchMode for the adapter.
     *
     * @param string|Zend_Db_Select $sql An SQL SELECT statement.
     * @param mixed $bind Data to bind into SELECT placeholders.
     * @param mixed                 $fetchMode Override current fetch mode.
     * @return mixed Array, object, or scalar depending on fetch mode.
     */
    public function fetchRow($sql, $bind = array(), $fetchMode = null)
    {
        if ($fetchMode === null) {
            $fetchMode = $this->_fetchMode;
        }
        $stmt = $this->query($sql, $bind);
        $result = $stmt->fetch($fetchMode);
Arguments
  1. """
    \r\n
                SELECT\r\n
                    ROUND(\r\n
                            1.609344 *\r\n
                            6377.83027 *\r\n
                            ACOS(ROUND(\r\n
                                SIN( 48.9377114*PI()/180 ) * SIN( REPLACE(lat.property_value,',','.') * PI()/180 )\r\n
                                + COS( 48.9377114*PI()/180 ) * COS( REPLACE(lat.property_value,',','.') * PI()/180 )  *  COS( (REPLACE(lon.property_value,',','.') * PI()/180) - (18.1157547*PI()/180) )\r\n
                                ,15)\r\n
                            )\r\n
                    , 1)\r\n
                    AS distance,\r\n
                    page.page_id AS page_id\r\n
                FROM\r\n
                  tblPages AS page\r\n
                LEFT JOIN tblPagePropertyValues AS lat\r\n
                    ON page.page_id = lat.page_id\r\n
                    AND lat.property_id = 149\r\n
                LEFT JOIN tblPagePropertyValues AS lon\r\n
                    ON page.page_id = lon.page_id\r\n
                    AND lon.property_id = 150\r\n
                LEFT JOIN\r\n
                    tblPages AS mesto\r\n
                    ON page.parent_page_id = mesto.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS rubrika\r\n
                    ON mesto.parent_page_id = rubrika.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS sekcia\r\n
                    ON rubrika.parent_page_id = sekcia.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS kraj\r\n
                    ON sekcia.parent_page_id = kraj.page_id\r\n
            \r\n
                    LEFT JOIN\r\n
                        tblFSCache_fsi AS evuc_index\r\n
                        ON evuc_index.page_id = page.page_id\r\n
    \t\t    \r\n
                WHERE\r\n
                    page.page_type_id = 26\r\n
                AND\r\n
                    page.page_state_id = 1\r\n
                AND\r\n
                    page.page_id != 63103\r\n
                AND\r\n
                    lat.property_value != ''\r\n
                AND\r\n
                    kraj.page_state_id = 1\r\n
                AND\r\n
                    sekcia.page_state_id = 1\r\n
                AND\r\n
                    rubrika.page_state_id = 1\r\n
                AND\r\n
                    mesto.page_state_id = 1\r\n
            \r\n
                    AND\r\n
                        evuc_index.typ_zariadenia IN (65843)\r\n
    \t\t    \r\n
                HAVING\r\n
                    distance < 100\r\n
                ORDER BY\r\n
                    distance ASC, page.page_id DESC\r\n
                LIMIT\r\n
                    0, 10\r\n
    \t\t
    """
    
  2. []
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
buxus
/
application
/
models
/
Api
/
BasicList.php
                .= "
                AND
                    page.page_id IN (".$ids.")
            ";
        }

        $q
            .= "
            HAVING
                distance < " . $this->distance . "
            ORDER BY
                distance ASC, page.page_id DESC
            LIMIT
                " . $this->from_item . ", " . $this->per_page . "
        ";
        if (H::isDebug()) {
        \Buxus::log('LOG: '.$q);
        }

        return \BuxusDB::get()->fetchAll($q);
    }

    public function getResult()
    {
        return $this->result;
    }

    public function getErrorMessage()
    {
        return $this->error_msg;
    }

}
 
Arguments
  1. """
    \r\n
                SELECT\r\n
                    ROUND(\r\n
                            1.609344 *\r\n
                            6377.83027 *\r\n
                            ACOS(ROUND(\r\n
                                SIN( 48.9377114*PI()/180 ) * SIN( REPLACE(lat.property_value,',','.') * PI()/180 )\r\n
                                + COS( 48.9377114*PI()/180 ) * COS( REPLACE(lat.property_value,',','.') * PI()/180 )  *  COS( (REPLACE(lon.property_value,',','.') * PI()/180) - (18.1157547*PI()/180) )\r\n
                                ,15)\r\n
                            )\r\n
                    , 1)\r\n
                    AS distance,\r\n
                    page.page_id AS page_id\r\n
                FROM\r\n
                  tblPages AS page\r\n
                LEFT JOIN tblPagePropertyValues AS lat\r\n
                    ON page.page_id = lat.page_id\r\n
                    AND lat.property_id = 149\r\n
                LEFT JOIN tblPagePropertyValues AS lon\r\n
                    ON page.page_id = lon.page_id\r\n
                    AND lon.property_id = 150\r\n
                LEFT JOIN\r\n
                    tblPages AS mesto\r\n
                    ON page.parent_page_id = mesto.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS rubrika\r\n
                    ON mesto.parent_page_id = rubrika.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS sekcia\r\n
                    ON rubrika.parent_page_id = sekcia.page_id\r\n
                LEFT JOIN\r\n
                    tblPages AS kraj\r\n
                    ON sekcia.parent_page_id = kraj.page_id\r\n
            \r\n
                    LEFT JOIN\r\n
                        tblFSCache_fsi AS evuc_index\r\n
                        ON evuc_index.page_id = page.page_id\r\n
    \t\t    \r\n
                WHERE\r\n
                    page.page_type_id = 26\r\n
                AND\r\n
                    page.page_state_id = 1\r\n
                AND\r\n
                    page.page_id != 63103\r\n
                AND\r\n
                    lat.property_value != ''\r\n
                AND\r\n
                    kraj.page_state_id = 1\r\n
                AND\r\n
                    sekcia.page_state_id = 1\r\n
                AND\r\n
                    rubrika.page_state_id = 1\r\n
                AND\r\n
                    mesto.page_state_id = 1\r\n
            \r\n
                    AND\r\n
                        evuc_index.typ_zariadenia IN (65843)\r\n
    \t\t    \r\n
                HAVING\r\n
                    distance < 100\r\n
                ORDER BY\r\n
                    distance ASC, page.page_id DESC\r\n
                LIMIT\r\n
                    0, 10\r\n
    \t\t
    """
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
buxus
/
application
/
models
/
App
/
NajblizsieZariadeniaList.php
<?php
namespace App;
 
use Api\BasicList;
use PTCI;
use H;
 
class NajblizsieZariadeniaList extends BasicList
{
    public function getItems($typ_id = null)
    {
        $list_base = new ListBase();
        if (!is_null($this->lat) && !is_null($this->lon)) {
        //do 100km
            $this->setNearestDistance(100);
            $list = $this->searchNearest(PTCI::ZDRAVOTNICKE_ZARIADENIE_ID, $typ_id);
            if (H::notEmptyA($list)) {
                foreach ($list as $item) {
                    $list_base->addItem($item['page_id']);
                }
            }
        }
 
        return $list_base;
    }
}
 
Arguments
  1. 26
    
  2. array:1 [
      0 => "65843"
    ]
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
buxus
/
application
/
models
/
App
/
Page
/
ZdravotnickeZariadeniePage.php
{
    protected $najblizsie;

    /**
     * Pole EvucPage
     * @var array
     */
    public $podtyp_zariadenia;

    public function hasNajblizsie()
    {
        return ($this->getNajblizsie() !== false);
    }

    public function getNajblizsie()
    {
        if (is_null($this->najblizsie)) {
            $this->najblizsie = false;
            $search_list = new NajblizsieZariadeniaList($this->getValue(PCT::GM_LAT_TAG),$this->getValue(PCT::GM_LON_TAG),10);
            $list_base = $search_list->getItems(array($this->getValue(PCT::TYP_ZARIADENIA_TAG)));
            if ($list_base->hasItems()) {
                $this->najblizsie = $list_base;
            }

        }
        return $this->najblizsie;
    }

    public function getCennikPath()
    {
        $cennik_hash = trim($this->getValue(PropertyTag::CENNIK_TAG()));
        if ($cennik_hash == '') {
            return false;
        }
        $file_path = GetSystemOption('C_download_url_docs_prefix') . 'cennik';
        $file_path .= '/' . $cennik_hash.'.pdf';
        if (!file_exists($file_path)) {
            return false;
        }
        return $file_path;
Arguments
  1. array:1 [
      0 => "65843"
    ]
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
buxus
/
application
/
models
/
App
/
Page
/
ZdravotnickeZariadeniePage.php
use App\NajblizsieZariadeniaList;
use App\PageIds;
use Buxus\Util\PropertyTag;
use Buxus\Util\Url;
use PCT;

class ZdravotnickeZariadeniePage extends \EvucPage
{
    protected $najblizsie;

    /**
     * Pole EvucPage
     * @var array
     */
    public $podtyp_zariadenia;

    public function hasNajblizsie()
    {
        return ($this->getNajblizsie() !== false);
    }

    public function getNajblizsie()
    {
        if (is_null($this->najblizsie)) {
            $this->najblizsie = false;
            $search_list = new NajblizsieZariadeniaList($this->getValue(PCT::GM_LAT_TAG),$this->getValue(PCT::GM_LON_TAG),10);
            $list_base = $search_list->getItems(array($this->getValue(PCT::TYP_ZARIADENIA_TAG)));
            if ($list_base->hasItems()) {
                $this->najblizsie = $list_base;
            }

        }
        return $this->najblizsie;
    }

    public function getCennikPath()
    {
        $cennik_hash = trim($this->getValue(PropertyTag::CENNIK_TAG()));
        if ($cennik_hash == '') {
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
buxus
/
application
/
views
/
scripts
/
index
/
index.phtml
        <a class="ebutton ebutton--lg ebutton--right ebutton--green" href="<?php echo F::pUrl(\Buxus\Util\PageIds::getAktuality()) ?>">Všetky aktuality</a>
    <?php endif; ?>

    <div class="row" <?php if ($this->evuc_page->jeZrusena()): ?>style="opacity:0.1"<?php endif; ?>>
        <?php if ($this->evuc_page->isPharmacy()): ?>
            <div class="col-md-6"><?php echo $this->partial('healthcare/pharmacy-index.phtml', array('evuc_page' => $this->evuc_page)); ?></div>
        <?php elseif ($this->evuc_page->isPrivateFacility()): ?>
            <div class="col-md-6"><?php echo $this->partial('healthcare/private-facility-index.phtml', array('evuc_page' => $this->evuc_page,'is_iframe' => $this->is_iframe)); ?></div>
        <?php elseif ($this->evuc_page->isNemocnica()): ?>
            <div class="col-md-6"><?php echo $this->partial('healthcare/zdravotnicke-zariadenie-index.phtml', array('evuc_page' => $this->evuc_page)); ?></div>
        <?php elseif ($this->evuc_page->isSocialCare() || $this->evuc_page->isPoradovnik()): ?>
            <div class="col-md-6"><?php echo $this->partial('socialcare/socialna-sluzba.phtml', array('evuc_page' => $this->evuc_page)); ?></div>
        <?php elseif ($this->evuc_page->isPrevadzkaMiesto()): ?>
            <div class="col-md-6"><?php echo $this->partial('healthcare/miesto-prevadzkovania-index.phtml', array('evuc_page' => $this->evuc_page)); ?></div>
        <?php endif; ?>

        <?php if (!$this->evuc_page->isVyjazdovaLspp() && !$this->evuc_page->jeZrusena()): ?>
            <div class="col-md-6 content-right">
                <?php echo $this->googleMap($this->evuc_page); ?>
                <?php if ($this->evuc_page->hasNajblizsie()): ?>
                    <h2 class="h2_heading" style="margin-top: 20px;">Podobné <?php if ($this->evuc_page->isPharmacy()): ?>lekárne<?php else: ?>zariadenia<?php endif; ?> v okolí</h2>
                    <?php foreach ($this->evuc_page->getNajblizsie() as $item): ?>
                        <?php if ($item->getPage()->jeZrusena()): ?>
                            <?php continue; ?>
                        <?php endif; ?>
                        <div style="line-height: 18px;margin-bottom: 10px;">
                            <a href="<?php echo $item->getPage()->getUrl() ?>"><?php echo $item->getPage()->getValue($item->getPage()->getTitleTag()); ?></a>
                        </div>
                    <?php endforeach; ?>
                <?php endif; ?>
            </div>
        <?php endif; ?>
    </div>

    <?php if ($this->evuc_page->getValue(PCT::INDIKACNE_ZAMERANIE_TAG) != ''): ?>
        <div class="row">
            <div class="col-md-12">
                <h2>Indikačné zameranie</h2>
                <?php echo $this->renderHtmlProperty($this->evuc_page, (PCT::INDIKACNE_ZAMERANIE_TAG)) ?>
            </div>
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
View.php
     * 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);
        }
    }
}
 
Arguments
  1. "/home/evuc/live/releases/20220124095935/buxus/application/views/scripts/index/index.phtml"
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
View
/
Abstract.php
            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()) {
Arguments
  1. "/home/evuc/live/releases/20220124095935/buxus/application/views/scripts/index/index.phtml"
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Action
/
Helper
/
ViewRenderer.php
        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();
Arguments
  1. null
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Action
/
Helper
/
ViewRenderer.php
        );
 
        $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);
Arguments
  1. "index/index.phtml"
    
  2. null
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Action
/
Helper
/
ViewRenderer.php
        $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()
        );
    }
 
    /**
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Action
/
HelperBroker.php
     * 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};
 
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Action.php
            // 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
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Dispatcher
/
Standard.php
 
        /**
         * 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;
    }
Arguments
  1. "indexAction"
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
zendframework
/
zendframework1
/
library
/
Zend
/
Controller
/
Front.php
            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);
        }
 
Arguments
  1. Zend_Controller_Request_Http {#2627}
    
  2. Zend_Controller_Response_Http {#2628}
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
buxus
/
legacy-base
/
buxus
/
includes
/
generate_functions.php
 
        // 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);
Arguments
  1. Zend_Controller_Request_Http {#2627}
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
buxus
/
core
/
src
/
handler
/
generate_page.php
    $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;
Arguments
  1. "63103"
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
vendor
/
buxus
/
core
/
src
/
Buxus
/
Router
/
BuxusRouter.php
            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;
    }
}
Arguments
  1. "/home/evuc/live/releases/20220124095935/vendor/buxus/core/src/handler/generate_page.php"
    
/
home
/
evuc
/
live
/
releases
/
20220124095935
/
public
/
buxus.php
<?php
define('BASE_BUXUS_DIR', realpath(__DIR__ . '/../'));
require_once __DIR__ . '/../vendor/autoload.php';
require_once CORE_BUXUS_DIR . '/src/buxus_bootstrap.php';
 
require_once '../vendor/buxus/legacy-base/buxus/includes/database.php';
 
 
$router = app('buxus-router');
$router->dispatch($_SERVER['REQUEST_URI']);
 
Arguments
  1. "/tsk/zdravotnictvo/ambulantne-zdravotnicke-zariadenia/trencin/ambulancia-zubneho-lekarstva-mudr.-slavomir-tholt-trencianska-tepla-st-dental.html?page_id=63103&https=1"
    

Environment & details:

Key Value
page_id
"63103"
https
"1"
empty
empty
Key Value
evuc_live
"g782qnuh4a0eoo6ntff2rhfalm"
Key Value
buxus
array:1 [
  "BUXUS_RUNNING" => null
]
empty
empty
0. Whoops\Handler\PrettyPageHandler