Array
(
    [cookie] => Array
        (
        )

    [env] => Array
        (
            [.env.test] => .env.test
            [APP_URL] => https://test-vpmk.visc.gov.lv
            [LOGIN] => 2
            [REALM_LATVIA] => urn:via:vpmk
            [REPLY_LATVIA] => https://vpmk.visc.gov.lv/no_vpm.php
            [URL_LATVIA] => https://vpm.viss.gov.lv/LVP.STS/wsfed
            [VPMK_DB_DATABASE] => db_vpm_test_live_data
            [VPMK_DB_HOST] => mysql
            [VPMK_DB_LIVE_DATA] => db_vpm_test_live_data
            [VPMK_DB_PASSWORD] => 6+SJIeyOxkd61QuforY93B8zjAg7mgUSeDNRIcIyr0M=
            [VPMK_DB_USERNAME] => root
            [VPMK_MDB_VPMK] => 1
            [VPMK_MDB_VPMK_CMS] => 0
            [_APP_URL] => https://test-vpmk.visc.gov.lv
            [db_t] => 
        )

    [files] => Array
        (
        )

    [get] => Array
        (
        )

    [post] => Array
        (
        )

    [server] => Array
        (
            [CONTENT_LENGTH] => 
            [CONTENT_TYPE] => 
            [DOCUMENT_ROOT] => /var/www/html
            [DOCUMENT_URI] => /index.php
            [FCGI_ROLE] => RESPONDER
            [GATEWAY_INTERFACE] => CGI/1.1
            [GPG_KEYS] => 39B641343D8C104B2B146DC3F9C39DC0B9698544 E60913E4DF209907D8E30D96659A97C9CF2A795A 1198C0117593497A5EC5C199286AF1F9897469DC
            [HOME] => /var/www
            [HOSTNAME] => 0a55a1060538
            [HTTPS] => on
            [HTTP_ACCEPT] => */*
            [HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
            [HTTP_CONNECTION] => close
            [HTTP_HOST] => test-vpmk.visc.gov.lv
            [HTTP_REFERER] => http://test-vpmk.visc.gov.lv/
            [HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
            [HTTP_X_FORWARDED_FOR] => 216.73.217.36
            [HTTP_X_FORWARDED_HOST] => test-vpmk.visc.gov.lv
            [HTTP_X_FORWARDED_PORT] => 443
            [HTTP_X_FORWARDED_PROTO] => https
            [HTTP_X_FORWARDED_SSL] => on
            [HTTP_X_ORIGINAL_URI] => /
            [HTTP_X_REAL_IP] => 216.73.217.36
            [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
            [PHPIZE_DEPS] => autoconf 		dpkg-dev 		file 		g++ 		gcc 		libc-dev 		make 		pkg-config 		re2c
            [PHP_ASC_URL] => https://www.php.net/distributions/php-8.2.29.tar.xz.asc
            [PHP_CFLAGS] => -fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
            [PHP_CPPFLAGS] => -fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
            [PHP_INI_DIR] => /usr/local/etc/php
            [PHP_LDFLAGS] => -Wl,-O1 -pie
            [PHP_SELF] => /index.php
            [PHP_SHA256] => 475f991afd2d5b901fb410be407d929bc00c46285d3f439a02c59e8b6fe3589c
            [PHP_URL] => https://www.php.net/distributions/php-8.2.29.tar.xz
            [PHP_VERSION] => 8.2.29
            [PWD] => /var/www/html
            [QUERY_STRING] => 
            [REDIRECT_STATUS] => 200
            [REMOTE_ADDR] => 172.31.0.6
            [REMOTE_PORT] => 59030
            [REQUEST_METHOD] => GET
            [REQUEST_SCHEME] => https
            [REQUEST_TIME] => 1787991554
            [REQUEST_TIME_FLOAT] => 1787991554.1553
            [REQUEST_URI] => /
            [SCRIPT_FILENAME] => /var/www/html/index.php
            [SCRIPT_NAME] => /index.php
            [SERVER_ADDR] => 172.31.0.3
            [SERVER_NAME] => test-vpmk.visc.gov.lv
            [SERVER_PORT] => 443
            [SERVER_PROTOCOL] => HTTP/1.1
            [SERVER_SOFTWARE] => nginx/1.25.3
            [USER] => www-data
            [VPMK_APP_ENV] => TEST
            [VPMK_DB_HOST] => mysql
            [VPMK_DB_LIVE_DATA] => db_vpm_test_live_data
            [VPMK_DB_PASSWORD_FILE] => /run/secrets/vpmk_db_rootpw
            [VPMK_DB_TEST_DATA] => db_vpm_test_test_data
        )

    [session] => Array
        (
            [fingerprint] => fac378ac3b3d3886829021b3309d4fd1
            [ip] => 216.73.217.36
            [last_activity] => 1787991554
        )

)

Array
(
    [php] => 8.2.29
    [os] => Linux 0a55a1060538 4.12.14-lp151.28.4-default #1 SMP Fri May 24 07:57:46 UTC 2019 (af35fd1) x86_64
    [extensions] => Array
        (
            [0] => Core (8.2.29)
            [1] => date (8.2.29)
            [2] => libxml (8.2.29)
            [3] => openssl (8.2.29)
            [4] => pcre (8.2.29)
            [5] => sqlite3 (8.2.29)
            [6] => zlib (8.2.29)
            [7] => ctype (8.2.29)
            [8] => curl (8.2.29)
            [9] => dom (20031129)
            [10] => fileinfo (8.2.29)
            [11] => filter (8.2.29)
            [12] => hash (8.2.29)
            [13] => iconv (8.2.29)
            [14] => json (8.2.29)
            [15] => mbstring (8.2.29)
            [16] => SPL (8.2.29)
            [17] => session (8.2.29)
            [18] => PDO (8.2.29)
            [19] => pdo_sqlite (8.2.29)
            [20] => standard (8.2.29)
            [21] => posix (8.2.29)
            [22] => random (8.2.29)
            [23] => readline (8.2.29)
            [24] => Reflection (8.2.29)
            [25] => Phar (8.2.29)
            [26] => SimpleXML (8.2.29)
            [27] => tokenizer (8.2.29)
            [28] => xml (8.2.29)
            [29] => xmlreader (8.2.29)
            [30] => xmlwriter (8.2.29)
            [31] => mysqlnd (mysqlnd 8.2.29)
            [32] => cgi-fcgi (8.2.29)
            [33] => apcu (5.1.26)
            [34] => gd (8.2.29)
            [35] => mysqli (8.2.29)
            [36] => pdo_mysql (8.2.29)
            [37] => soap (8.2.29)
            [38] => sodium (8.2.29)
            [39] => zip (1.21.1)
            [40] => Zend OPcache (8.2.29)
        )

)

1. [ ] SELECT * FROM vpm_notes where active=1 and event_type=1 and ('2026-08-29 11:19:14'>=event_from and (event_to >= '2026-08-29 11:19:14' or event_to is null))