SELECT r0_.idrow AS idrow_0, r0_.hash AS hash_1, r0_.name AS name_2, r0_.email AS email_3,
r0_.personal_number AS personal_number_4, r0_.global_id AS global_id_5, r0_.inactive AS inactive_6,
MAX(a1_.idrow) AS sclr_7 
FROM responsible_person r0_ 
LEFT JOIN asset a1_ ON (a1_.manager_id = r0_.personal_number AND (a1_.refused = false OR a1_.refused
IS NULL) AND a1_.assstate = 'Neověřeno') 
WHERE EXISTS (
SELECT m2_.branch 
FROM manager_branch m2_ 
WHERE m2_.manager_id = r0_.personal_number) 
GROUP BY r0_.idrow 
ORDER BY r0_.name ASC 
LIMIT 15

1. .../dbal/lib/Doctrine/DBAL/DBALException.php:172 source  Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException(arguments)

   162:        /**
   163:         * @return self
   164:         */
   165:        private static function wrapException(Driver $driver, Throwable $driverEx, string $msg)
   166:        {
   167:            if ($driverEx instanceof DriverException) {
   168:                return $driverEx;
   169:            }
   170:    
   171:            if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DriverExceptionInterface) {
   172:                return $driver->convertException($msg, $driverEx);
   173:            }
   174:    
   175:            return new self($msg, 0, $driverEx);
   176:        }
   

   $message	"An exception occurred while executing 'SELECT r0_.idrow AS idrow_0, r0_.hash AS hash_1, r0_.name AS name_2, r0_.email AS email_3, r0_.personal_number ... " (821)
   $exception

2. .../dbal/lib/Doctrine/DBAL/DBALException.php:151 source  Doctrine\DBAL\DBALException::wrapException(arguments)

   141:         */
   142:        public static function driverExceptionDuringQuery(Driver $driver, Throwable $driverEx, $sql, array $params = [])
   143:        {
   144:            $msg = "An exception occurred while executing '" . $sql . "'";
   145:            if ($params) {
   146:                $msg .= ' with params ' . self::formatParameters($params);
   147:            }
   148:    
   149:            $msg .= ":\n\n" . $driverEx->getMessage();
   150:    
   151:            return static::wrapException($driver, $driverEx, $msg);
   152:        }
   153:    
   154:        /**
   155:         * @return self
   

   $driver
   $driverEx
   $msg	"An exception occurred while executing 'SELECT r0_.idrow AS idrow_0, r0_.hash AS hash_1, r0_.name AS name_2, r0_.email AS email_3, r0_.personal_number ... " (821)

3. .../dbal/lib/Doctrine/DBAL/Connection.php:918 source  Doctrine\DBAL\DBALException::driverExceptionDuringQuery(arguments)

   908:                        $stmt->execute($params);
   909:                    }
   910:                } else {
   911:                    $stmt = $connection->query($sql);
   912:                }
   913:            } catch (Throwable $ex) {
   914:                throw DBALException::driverExceptionDuringQuery(
   915:                    $this->_driver,
   916:                    $ex,
   917:                    $sql,
   918:                    $this->resolveParams($params, $types)
   919:                );
   920:            }
   921:    
   922:            $stmt->setFetchMode($this->defaultFetchMode);
   

   $driver
   $driverEx
   $sql	"SELECT r0_.idrow AS idrow_0, r0_.hash AS hash_1, r0_.name AS name_2, r0_.email AS email_3, r0_.personal_number AS personal_number_4, r0_.global_id AS ... " (525)
   $params

4. .../src/Kdyby/Doctrine/Connection.php:151 source  Doctrine\DBAL\Connection->executeQuery(arguments)

   141:        }
   142:    
   143:    
   144:    
   145:        /**
   146:         * {@inheritdoc}
   147:         */
   148:        public function executeQuery($query, array $params = [], $types = [], Doctrine\DBAL\Cache\QueryCacheProfile $qcp = NULL)
   149:        {
   150:            try {
   151:                return parent::executeQuery($query, $params, $types, $qcp);
   152:    
   153:            } catch (\Exception $e) {
   154:                throw $this->resolveException($e, $query, $params);
   155:            }
   

   $sql	"SELECT r0_.idrow AS idrow_0, r0_.hash AS hash_1, r0_.name AS name_2, r0_.email AS email_3, r0_.personal_number AS personal_number_4, r0_.global_id AS ... " (525)
   $params
   $types
   $qcp	null

5. .../ORM/Query/Exec/SingleSelectExecutor.php:50 source  Kdyby\Doctrine\Connection->executeQuery(arguments)

   40:        public function __construct(SelectStatement $AST, SqlWalker $sqlWalker)
   41:        {
   42:            $this->_sqlStatements = $sqlWalker->walkSelectStatement($AST);
   43:        }
   44:    
   45:        /**
   46:         * {@inheritDoc}
   47:         */
   48:        public function execute(Connection $conn, array $params, array $types)
   49:        {
   50:            return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
   51:        }
   52:    }
   53:    
   

   $query	"SELECT r0_.idrow AS idrow_0, r0_.hash AS hash_1, r0_.name AS name_2, r0_.email AS email_3, r0_.personal_number AS personal_number_4, r0_.global_id AS ... " (525)
   $params
   $types
   $qcp	null

6. .../doctrine/orm/lib/Doctrine/ORM/Query.php:338 source  Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(arguments)

   328:    
   329:            [$sqlParams, $types] = $this->processParameterMappings($paramMappings);
   330:    
   331:            $this->evictResultSetCache(
   332:                $executor,
   333:                $sqlParams,
   334:                $types,
   335:                $this->_em->getConnection()->getParams()
   336:            );
   337:    
   338:            return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
   339:        }
   340:    
   341:        private function evictResultSetCache(
   342:            AbstractSqlExecutor $executor,
   

   $conn
   $params
   $types

7. .../orm/lib/Doctrine/ORM/AbstractQuery.php:1000 source  Doctrine\ORM\Query->_doExecute()

    990:                    $result = [];
    991:                }
    992:    
    993:                $setCacheEntry = static function ($data) use ($cache, $result, $cacheKey, $realCacheKey, $queryCacheProfile) : void {
    994:                    $result[$realCacheKey] = $data;
    995:    
    996:                    $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
    997:                };
    998:            }
    999:    
   1000:            $stmt = $this->_doExecute();
   1001:    
   1002:            if (is_numeric($stmt)) {
   1003:                $setCacheEntry($stmt);
   1004:    
   

8. .../orm/lib/Doctrine/ORM/AbstractQuery.php:954 source  Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(arguments)

   944:         * @param string|int|null            $hydrationMode Processing mode to be used during the hydration process.
   945:         *
   946:         * @return mixed
   947:         */
   948:        public function execute($parameters = null, $hydrationMode = null)
   949:        {
   950:            if ($this->cacheable && $this->isCacheEnabled()) {
   951:                return $this->executeUsingQueryCache($parameters, $hydrationMode);
   952:            }
   953:    
   954:            return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
   955:        }
   956:    
   957:        /**
   958:         * Execute query ignoring second level cache.
   

   $parameters	null
   $hydrationMode	3

9. .../orm/lib/Doctrine/ORM/AbstractQuery.php:781 source  Doctrine\ORM\AbstractQuery->execute(arguments)

   771:    
   772:        /**
   773:         * Gets the scalar results for the query.
   774:         *
   775:         * Alias for execute(null, HYDRATE_SCALAR).
   776:         *
   777:         * @return array
   778:         */
   779:        public function getScalarResult()
   780:        {
   781:            return $this->execute(null, self::HYDRATE_SCALAR);
   782:        }
   783:    
   784:        /**
   785:         * Get exactly one result or null.
   

   $parameters	null
   $hydrationMode	3

10. .../src/DataSource/OrmDataSource.php:213 source  Doctrine\ORM\AbstractQuery->getScalarResult()

    203:                $qb->addOrderBy($this->getColumnNameForOrder($qb, $col), strtoupper($ord));
    204:            }
    205:    
    206:            $query = $qb->getQuery();
    207:    
    208:            if ($paginator)
    209:            {
    210:                $query->setFirstResult($paginator->getOffset())->setMaxResults($paginator->getItemsPerPage());
    211:            }
    212:    
    213:            $data = $query->getScalarResult();
    214:            foreach ($data as &$row)
    215:            {
    216:                $row = (object) $row;
    217:    
    

11. .../vendor/dantem/datagrid/src/Datagrid.php:1472 source  Dantem\Datagrid\DataSource\OrmDataSource->getData(arguments)

    1462:    
    1463:                $onlyRow = $key && $this->presenter->isAjax();
    1464:                $paginatorAble = (!$onlyRow && !$nopaginator && $this->paginator);
    1465:    
    1466:                if ($paginatorAble && $this->paginator->page != $this->page)
    1467:                {
    1468:                    $this->paginator->page = $this->page = 1;
    1469:                }
    1470:    
    1471:                $this->data = $dataSource->getData(
    1472:                  $filters, $sortOrder, $paginatorAble ? $this->paginator : null, $this->getFilterLogicElem()
    1473:                );
    1474:    
    1475:                if ($paginatorAble)
    1476:                {
    

    $filters	array ()
    $order
    $paginator
    $logicElem	"AND" (3)

12. .../vendor/dantem/datagrid/src/Datagrid.php:962 source  Dantem\Datagrid\Datagrid->getData()

    952:            $this->template->globalActions = $this->getGlobalActions();
    953:            $this->template->actions = $this->getActions();
    954:    
    955:            $this->template->enabledFixedColumns = $this->enabledFixedColumns;
    956:    
    957:            if (!$this->enabledFixedColumns)
    958:            {
    959:                $this->fixedColumns = 0;
    960:            }
    961:    
    962:            $this->template->data = $this->getData();
    963:    
    964:            $this->template->columns = $this->getVisibleColumns();
    965:            $this->template->headers = $this->getHeaders();
    966:    
    

13. /var/www/csob_1.9.4/temp/cache/latte/templates-Emails-form.latte--e6b6938466.php:98 source  Dantem\Datagrid\Datagrid->render()

     88:    
     89:        E-maily lze poslat na kartě <a href="<?php echo LR\Filters::escapeHtmlAttr($this->global->uiControl->link("history")) ?>">E-maily - Log odeslaných</a> po 250 v jedné várce.
     90:    </p>
     91:    <?php
     92:            }
     93:    ?>
     94:    
     95:    <?php
     96:            /* line 44 */ $_tmp = $this->global->uiControl->getComponent("userGrid");
     97:            if ($_tmp instanceof Nette\Application\UI\IRenderable) $_tmp->redrawControl(null, false);
     98:            $_tmp->render();
     99:    ?>
    100:    
    101:    <div id="<?php echo htmlSpecialChars($this->global->snippetDriver->getHtmlId('form')) ?>"><?php $this->renderBlock('_form', $this->params) ?></div><?php
    102:            
    

14. .../latte/src/Latte/Runtime/Template.php:282 source  Templatee6b6938466->blockContent(arguments)

    272:            }
    273:    
    274:            $block = reset($this->blockQueue[$name]);
    275:            if ($mod && $mod !== ($blockType = $this->blockTypes[$name])) {
    276:                if ($filter = (is_string($mod) ? Filters::getConvertor($blockType, $mod) : $mod)) {
    277:                    echo $filter($this->capture(function () use ($block, $params) { $block($params); }), $blockType);
    278:                    return;
    279:                }
    280:                trigger_error("Including block $name with content type " . strtoupper($blockType) . ' into incompatible type ' . strtoupper($mod) . '.', E_USER_WARNING);
    281:            }
    282:            $block($params);
    283:        }
    284:    
    285:    
    286:        /**
    

    $_args

15. /var/www/csob_1.9.4/temp/cache/latte/Presenters-templates-@layout.latte--022382a9c0.php:280 source  Latte\Runtime\Template->renderBlock(arguments)

    270:        </div>
    271:    </div>
    272:    
    273:    <div class="container<?php
    274:            if ($contentFluid) {
    275:                ?>-fluid<?php
    276:            }
    277:    ?>" style="margin-top: 1em;">
    278:    <div id="<?php echo htmlSpecialChars($this->global->snippetDriver->getHtmlId('flashes')) ?>"><?php $this->renderBlock('_flashes', $this->params) ?></div>
    279:    <?php
    280:            $this->renderBlock('content', $this->params, 'html');
    281:    ?>
    282:    
    283:        <div style="clear:both; font-size: 90%; line-height: 1.2em; margin-top: 20px; margin-bottom: 20px;">
    284:            <div style="clear: both;">
    

    $name	"content" (7)
    $params
    $mod	"html" (4)

16. .../latte/src/Latte/Runtime/Template.php:198 source  Template022382a9c0->main()

    188:            // old accumulators for back compatibility
    189:            $this->params['_l'] = new \stdClass;
    190:            $this->params['_g'] = $this->global;
    191:            $this->params['_b'] = (object) ['blocks' => &$this->blockQueue, 'types' => &$this->blockTypes];
    192:            if (isset($this->global->snippetDriver) && $this->global->snippetBridge->isSnippetMode()) {
    193:                if ($this->global->snippetDriver->renderSnippets($this->blockQueue, $this->params)) {
    194:                    return;
    195:                }
    196:            }
    197:    
    198:            $this->main();
    199:        }
    200:    
    201:    
    202:        /**
    

17. .../latte/src/Latte/Runtime/Template.php:176 source  Latte\Runtime\Template->render()

    166:            if ($this->referenceType === 'import') {
    167:                if ($this->parentName) {
    168:                    $this->createTemplate($this->parentName, [], 'import')->render();
    169:                }
    170:                return;
    171:    
    172:            } elseif ($this->parentName) { // extends
    173:                ob_start(function () {});
    174:                $params = $this->main();
    175:                ob_end_clean();
    176:                $this->createTemplate($this->parentName, $params, 'extends')->render();
    177:                return;
    178:    
    179:            } elseif (!empty($this->params['_renderblock'])) { // single block rendering
    180:                $tmp = $this;
    

18. .../vendor/latte/latte/src/Latte/Engine.php:70 source  Latte\Runtime\Template->render()

    60:        }
    61:    
    62:    
    63:        /**
    64:         * Renders template to output.
    65:         * @return void
    66:         */
    67:        public function render($name, array $params = [], $block = null)
    68:        {
    69:            $this->createTemplate($name, $params + ['_renderblock' => $block])
    70:                ->render();
    71:        }
    72:    
    73:    
    74:        /**
    

19. .../Bridges/ApplicationLatte/Template.php:52 source  Latte\Engine->render(arguments)

    42:            return $this->latte;
    43:        }
    44:    
    45:    
    46:        /**
    47:         * Renders template to output.
    48:         * @return void
    49:         */
    50:        public function render($file = null, array $params = [])
    51:        {
    52:            $this->latte->render($file ?: $this->file, $params + $this->params);
    53:        }
    54:    
    55:    
    56:        /**
    

    $name	"/var/www/csob_1.9.4/src/Presenters/templates/Emails/form.latte" (62)
    $params

20. .../Application/Responses/TextResponse.php:49 source  Nette\Bridges\ApplicationLatte\Template->render()

    39:        }
    40:    
    41:    
    42:        /**
    43:         * Sends response to output.
    44:         * @return void
    45:         */
    46:        public function send(Nette\Http\IRequest $httpRequest, Nette\Http\IResponse $httpResponse)
    47:        {
    48:            if ($this->source instanceof Nette\Application\UI\ITemplate) {
    49:                $this->source->render();
    50:    
    51:            } else {
    52:                echo $this->source;
    53:            }
    

21. .../src/Application/Application.php:157 source  Nette\Application\Responses\TextResponse->send(arguments)

    147:            }
    148:            $this->onPresenter($this, $this->presenter);
    149:            $response = $this->presenter->run(clone $request);
    150:    
    151:            if ($response instanceof Responses\ForwardResponse) {
    152:                $request = $response->getRequest();
    153:                goto process;
    154:    
    155:            } elseif ($response) {
    156:                $this->onResponse($this, $response);
    157:                $response->send($this->httpRequest, $this->httpResponse);
    158:            }
    159:        }
    160:    
    161:    
    

    $httpRequest
    $httpResponse

22. .../src/Application/Application.php:83 source  Nette\Application\Application->processRequest(arguments)

    73:    
    74:    
    75:        /**
    76:         * Dispatch a HTTP request to a front controller.
    77:         * @return void
    78:         */
    79:        public function run()
    80:        {
    81:            try {
    82:                $this->onStartup($this);
    83:                $this->processRequest($this->createInitialRequest());
    84:                $this->onShutdown($this);
    85:    
    86:            } catch (\Exception $e) {
    87:            } catch (\Throwable $e) {
    

    $request

23. /var/www/csob_1.9.4/www/index.php:8 source  Nette\Application\Application->run()

    1:    <?php
    2:    
    3:    // uncomment this line if you must temporarily take down your site for maintenance
    4:    //require '.maintenance.php';
    5:    
    6:    // load bootstrap file
    7:    $container = require __DIR__ . '/../app/bootstrap.php';
    8:    $container->getByType(Nette\Application\Application::class)->run();
    9: