SELECT r.*, l.code as languageCode 
FROM app_condition_form_group_results r 
INNER JOIN languages_languages l ON l.id = r.languageId 
WHERE groupId IN (
SELECT g.id 
FROM app_condition_form_groups g 
WHERE g.id NOT IN (
SELECT DISTINCT cc.groupId 
FROM app_condition_form_group_conditions cc 
WHERE cc.id NOT IN ( 
SELECT c.id 
from app_condition_form_group_conditions c
INNER JOIN `valueTable` a ON a.param = c.param AND c.groupId IN (19829,19830,19831)
WHERE
 ('<' = c.operator AND cast(a.value as double) < cast(c.value as double)) OR
 ('<=' = c.operator AND cast(a.value as double) <= cast(c.value as double)) OR
 ('>' = c.operator AND cast(a.value as double) > cast(c.value as double)) OR
 ('>=' = c.operator AND cast(a.value as double) >= cast(c.value as double)) OR
 ('=' = c.operator AND a.value = c.value) OR
 ('!=' = c.operator AND a.value <> c.value) OR
 ('ISNULL' = c.operator AND a.value IS NULL) OR
 ('NOTNULL' = c.operator AND a.value IS NOT NULL))) 
ORDER BY g.id ASC) 
ORDER BY groupId ASC

1. .../vendor/dibi/dibi/src/Dibi/Drivers/MySqliDriver.php:152 source  Dibi\Drivers\MySqliDriver::createException(arguments)

   142:         * Executes the SQL query.
   143:         * @param  string      SQL statement.
   144:         * @return Dibi\ResultDriver|null
   145:         * @throws Dibi\DriverException
   146:         */
   147:        public function query($sql)
   148:        {
   149:            $res = @mysqli_query($this->connection, $sql, $this->buffered ? MYSQLI_STORE_RESULT : MYSQLI_USE_RESULT); // intentionally @
   150:    
   151:            if ($code = mysqli_errno($this->connection)) {
   152:                throw static::createException(mysqli_error($this->connection), $code, $sql);
   153:    
   154:            } elseif (is_object($res)) {
   155:                return $this->createResultDriver($res);
   156:            }
   

   $message	"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'double) < cast( ... " (226)
   $code	1064
   $sql	"SELECT r.*, l.code as languageCode FROM app_condition_form_group_results r INNER JOIN languages_languages l ON l.id = r.languageId WHERE groupId IN (S ... " (1155)

2. .../vendor/dibi/dibi/src/Dibi/Connection.php:321 source  Dibi\Drivers\MySqliDriver->query(arguments)

   311:         */
   312:        final public function nativeQuery($sql)
   313:        {
   314:            if (!$this->connected) {
   315:                $this->connect();
   316:            }
   317:    
   318:            \dibi::$sql = $sql;
   319:            $event = $this->onEvent ? new Event($this, Event::QUERY, $sql) : null;
   320:            try {
   321:                $res = $this->driver->query($sql);
   322:    
   323:            } catch (Exception $e) {
   324:                if ($event) {
   325:                    $this->onEvent($event->done($e));
   

   $sql	"SELECT r.*, l.code as languageCode FROM app_condition_form_group_results r INNER JOIN languages_languages l ON l.id = r.languageId WHERE groupId IN (S ... " (1155)

3. .../vendor/dibi/dibi/src/Dibi/Connection.php:235 source  Dibi\Connection->nativeQuery(arguments)

   225:    
   226:        /**
   227:         * Generates (translates) and executes SQL query.
   228:         * @param  array|mixed      one or more arguments
   229:         * @return Result|int   result set or number of affected rows
   230:         * @throws Exception
   231:         */
   232:        final public function query($args)
   233:        {
   234:            $args = func_get_args();
   235:            return $this->nativeQuery($this->translateArgs($args));
   236:        }
   237:    
   238:    
   239:        /**
   

   $sql	"SELECT r.*, l.code as languageCode FROM app_condition_form_group_results r INNER JOIN languages_languages l ON l.id = r.languageId WHERE groupId IN (S ... " (1155)

4. .../v1/model/repository/ConditionFormRepository.php:160 source  Dibi\Connection->query(arguments)

   150:                    ('='  = c.operator AND a.value = c.value) OR
   151:                    ('!=' = c.operator AND a.value <> c.value) OR
   152:                    ('ISNULL' = c.operator AND a.value IS NULL) OR
   153:                    ('NOTNULL' = c.operator AND a.value IS NOT NULL)
   154:    SQL;
   155:            $groupsNotMatchingAllConditions = "SELECT DISTINCT cc.groupId FROM $condTable cc WHERE cc.id NOT IN ($conditionsMatchingValues)";
   156:            $resultGroup = "SELECT g.id FROM $groupTable g WHERE g.id NOT IN ($groupsNotMatchingAllConditions) ORDER BY g.id ASC";
   157:            $resultSQL = "SELECT r.*, l.code as languageCode FROM $resultTable r INNER JOIN $langTable l ON l.id = r.languageId WHERE groupId IN ($resultGroup) ORDER BY groupId ASC";
   158:    
   159:            // use the final query and tranform it to look like {[groupId]: {[name]: {[code]: "value"}}}
   160:            $results = $this->connection->query($resultSQL)->fetchAssoc('groupId|name|languageCode=value');
   161:            // remove groupId infromation -> [{[name]: {[code]: "value"}}, ...]
   162:            $results = array_values($results);
   163:            // drop temporary table (for the case of multiple operations in one session)
   164:            $this->connection->query('DROP TABLE `valueTable`');
   

   $args

5. .../2025-03-14_08-06-06/app/api/app/v1/model/User.php:571 source  MySasy\Api\App\v1\Model\Repository\ConditionForm->getResults(arguments)

   561:                'daysToExpiration' => $daysToExpiration,
   562:                'hasPromotion' => $hasPromotion,
   563:                'isBeta' => $user->requestBeta,
   564:                'tfmax' => $user->tfmax,
   565:                'vo2max' => $user->vo2max,
   566:                'sport' => $user->sport,
   567:                'sportLevel' => $user->sportLevel,
   568:                'tallness' => $user->tallness,
   569:                'weight' => $user->weight,
   570:            ];
   571:            $matchingNotifications = $this->conditionFormRepository->getResults('userNotifications', $values, true);
   572:            if (count($matchingNotifications) >= 1) {
   573:                // show only one at a time
   574:                $keyForToday = array_rand($matchingNotifications, 1);
   575:                return $matchingNotifications[$keyForToday];
   

   $formName	"userNotifications" (17)
   $values
   $allowMultiple	true

6. .../2025-03-14_08-06-06/app/api/app/v1/model/User.php:400 source  MySasy\Api\App\v1\Model\User->getNotification(arguments)

   390:            $lastMeasurement = !empty($last2measurements) ? (count($last2measurements) > 1 ? $last2measurements[1] : $last2measurements[0]) : null;
   391:            $user->lastMeasurement = $lastMeasurement;
   392:            $user->currentRecommendation = $this->measurementModel->getUserRecommendation($last2measurements);
   393:            $user->recommendedTraining = $this->measurementModel->getUserRecommendedTraining($user->id, $lastMeasurement);
   394:    
   395:            $user->countAllValidStandardMeasurements = $this->getCountAllvalidStandardMeasurements($user->id);
   396:            $user->countAllValidStandardMeasurementsForLast60Days = $this->getCountAllvalidStandardMeasurementsForLast60Days($user->id);
   397:    
   398:            // notifications
   399:            $user->promotionExpiration = $this->productRepository->getUserPromotionExpiration($user->id);
   400:            $user->notification = $this->getNotification($user);
   401:    
   402:            $user->canRequestShortMeasurement = 1; // currently always true - they can request it for anyone
   403:            $user->isEligibleToShortMeasure = $this->isEligibleToShortMeasure($user);
   404:            // repeated measurement
   

   $user

7. .../releases/2025-03-14_08-06-06/app/api/app/v1/Me.php:173 source  MySasy\Api\App\v1\Model\User->assignAdditionalInfo(arguments)

   163:    
   164:            if (!empty($_GET['setEmailVerified'])) {
   165:                // set that email address is verified (if not verified, cannot even log in, so this cannot be spoofed)
   166:                $this->userModel->setVerified($this->authUserId);
   167:    
   168:                if (!$user->verified) {
   169:                    $this->personalizedMessages->sendRegistrationMessage($this->authUserId); //send welcome message after verification
   170:                }
   171:            }
   172:    
   173:            $this->userModel->assignAdditionalInfo($user, $this->getHttpRequest()->getHeaders());
   174:    
   175:            return $user;
   176:        }
   177:    
   

   $user
   $httpHeaders

8. .../releases/2025-03-14_08-06-06/app/api/app/v1/Me.php:125 source  MySasy\Api\App\v1\Presenters\Me->getMeInformation()

   115:    
   116:                    case 'recommendation':
   117:                        $date = !empty($_GET['date']) ? $_GET['date'] . " 23:00:00" : null;
   118:                        $last2measurements = $this->measurementModel->getLast2Measurements($this->authUserId, $date);
   119:                        $result = $this->measurementModel->getUserRecommendation($last2measurements);
   120:                        break;
   121:    
   122:                    case null:
   123:                        $this->extendCurrentlyUsedToken();
   124:                        $this->updateLastSeen();
   125:                        $result = $this->getMeInformation();
   126:                        break;
   127:    
   128:                    default:
   129:                        throw new Exception\NotImplementedException();
   

9. inner-code MySasy\Api\App\v1\Presenters\Me->actionRead()

10. .../nette/application/src/Application/UI/Component.php:92 source  ReflectionMethod->invokeArgs(arguments)

    82:         * @param  array
    83:         * @return bool  does method exist?
    84:         */
    85:        protected function tryCall($method, array $params)
    86:        {
    87:            $rc = $this->getReflection();
    88:            if ($rc->hasMethod($method)) {
    89:                $rm = $rc->getMethod($method);
    90:                if ($rm->isPublic() && !$rm->isAbstract() && !$rm->isStatic()) {
    91:                    $this->checkRequirements($rm);
    92:                    $rm->invokeArgs($this, $rc->combineArgs($rm, $params));
    93:                    return true;
    94:                }
    95:            }
    96:            return false;
    

    $object
    $args	array ()

11. .../nette/application/src/Application/UI/Presenter.php:193 source  Nette\Application\UI\Component->tryCall(arguments)

    183:    
    184:                $this->initGlobalParameters();
    185:                $this->checkRequirements($this->getReflection());
    186:                $this->onStartup($this);
    187:                $this->startup();
    188:                if (!$this->startupCheck) {
    189:                    $class = $this->getReflection()->getMethod('startup')->getDeclaringClass()->getName();
    190:                    throw new Nette\InvalidStateException("Method $class::startup() or its descendant doesn't call parent::startup().");
    191:                }
    192:                // calls $this->action<Action>()
    193:                $this->tryCall($this->formatActionMethod($this->action), $this->params);
    194:    
    195:                // autoload components
    196:                foreach ($this->globalParams as $id => $foo) {
    197:                    $this->getComponent((string) $id, false);
    

    $method	"actionread" (10)
    $params

12. .../nette/application/src/Application/Application.php:149 source  Nette\Application\UI\Presenter->run(arguments)

    139:            if (!$request->isMethod($request::FORWARD) && !strcasecmp($request->getPresenterName(), $this->errorPresenter)) {
    140:                throw new BadRequestException('Invalid request. Presenter is not achievable.');
    141:            }
    142:    
    143:            try {
    144:                $this->presenter = $this->presenterFactory->createPresenter($request->getPresenterName());
    145:            } catch (InvalidPresenterException $e) {
    146:                throw count($this->requests) > 1 ? $e : new BadRequestException($e->getMessage(), 0, $e);
    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;
    

    $request

13. .../nette/application/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

14. .../application/releases/2025-03-14_08-06-06/index.php:20 source  Nette\Application\Application->run()

    10:    
    11:    if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS' || $_SERVER['REQUEST_METHOD'] == 'HEAD') {
    12:        die();
    13:    }
    14:    
    15:    // Uncomment this line if you must temporarily take down your site for maintenance.
    16:    // require __DIR__ . '/.maintenance.php';
    17:    
    18:    $container = require __DIR__ . '/app/bootstrap.php';
    19:    
    20:    $container->getByType('Nette\Application\Application')->run();
    21: