a:11:{s:6:"config";s:12813:"a:5:{s:10:"phpVersion";s:37:"5.6.39-1+ubuntu14.04.1+deb.sury.org+1";s:10:"yiiVersion";s:8:"2.0.11.2";s:11:"application";a:8:{s:3:"yii";s:8:"2.0.11.2";s:4:"name";s:9:"iResidenz";s:7:"version";s:3:"1.0";s:8:"language";s:5:"en-US";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:37:"5.6.39-1+ubuntu14.04.1+deb.sury.org+1";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:57:{s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.0.6.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:49:"/var/www/residenz/vendor/yiisoft/yii2-swiftmailer";}}s:16:"yiisoft/yii2-jui";a:3:{s:4:"name";s:16:"yiisoft/yii2-jui";s:7:"version";s:7:"2.0.7.0";s:5:"alias";a:1:{s:8:"@yii/jui";s:41:"/var/www/residenz/vendor/yiisoft/yii2-jui";}}s:22:"yiisoft/yii2-bootstrap";a:3:{s:4:"name";s:22:"yiisoft/yii2-bootstrap";s:7:"version";s:7:"2.0.6.0";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:47:"/var/www/residenz/vendor/yiisoft/yii2-bootstrap";}}s:23:"iutbay/yii2-fontawesome";a:3:{s:4:"name";s:23:"iutbay/yii2-fontawesome";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:23:"@iutbay/yii2fontawesome";s:48:"/var/www/residenz/vendor/iutbay/yii2-fontawesome";}}s:20:"iutbay/yii2-kcfinder";a:3:{s:4:"name";s:20:"iutbay/yii2-kcfinder";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:20:"@iutbay/yii2kcfinder";s:45:"/var/www/residenz/vendor/iutbay/yii2-kcfinder";}}s:27:"garyjl/yii2-simple_html_dom";a:3:{s:4:"name";s:27:"garyjl/yii2-simple_html_dom";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:21:"@garyjl/simplehtmldom";s:52:"/var/www/residenz/vendor/garyjl/yii2-simple_html_dom";}}s:31:"kartik-v/yii2-widget-timepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-timepicker";s:7:"version";s:7:"1.0.3.0";s:5:"alias";a:1:{s:12:"@kartik/time";s:56:"/var/www/residenz/vendor/kartik-v/yii2-widget-timepicker";}}s:32:"kartik-v/yii2-widget-switchinput";a:3:{s:4:"name";s:32:"kartik-v/yii2-widget-switchinput";s:7:"version";s:7:"1.3.1.0";s:5:"alias";a:1:{s:19:"@kartik/switchinput";s:57:"/var/www/residenz/vendor/kartik-v/yii2-widget-switchinput";}}s:28:"kartik-v/yii2-widget-spinner";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-spinner";s:7:"version";s:7:"1.0.0.0";s:5:"alias";a:1:{s:15:"@kartik/spinner";s:53:"/var/www/residenz/vendor/kartik-v/yii2-widget-spinner";}}s:28:"kartik-v/yii2-widget-sidenav";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-sidenav";s:7:"version";s:7:"1.0.0.0";s:5:"alias";a:1:{s:15:"@kartik/sidenav";s:53:"/var/www/residenz/vendor/kartik-v/yii2-widget-sidenav";}}s:26:"kartik-v/yii2-widget-growl";a:3:{s:4:"name";s:26:"kartik-v/yii2-widget-growl";s:7:"version";s:7:"1.1.1.0";s:5:"alias";a:1:{s:13:"@kartik/growl";s:51:"/var/www/residenz/vendor/kartik-v/yii2-widget-growl";}}s:28:"kartik-v/yii2-widget-depdrop";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-depdrop";s:7:"version";s:7:"1.0.4.0";s:5:"alias";a:1:{s:15:"@kartik/depdrop";s:53:"/var/www/residenz/vendor/kartik-v/yii2-widget-depdrop";}}s:35:"kartik-v/yii2-widget-datetimepicker";a:3:{s:4:"name";s:35:"kartik-v/yii2-widget-datetimepicker";s:7:"version";s:7:"1.4.4.0";s:5:"alias";a:1:{s:16:"@kartik/datetime";s:60:"/var/www/residenz/vendor/kartik-v/yii2-widget-datetimepicker";}}s:26:"kartik-v/yii2-widget-alert";a:3:{s:4:"name";s:26:"kartik-v/yii2-widget-alert";s:7:"version";s:7:"1.1.1.0";s:5:"alias";a:1:{s:13:"@kartik/alert";s:51:"/var/www/residenz/vendor/kartik-v/yii2-widget-alert";}}s:26:"kartik-v/yii2-widget-affix";a:3:{s:4:"name";s:26:"kartik-v/yii2-widget-affix";s:7:"version";s:7:"1.0.0.0";s:5:"alias";a:1:{s:13:"@kartik/affix";s:51:"/var/www/residenz/vendor/kartik-v/yii2-widget-affix";}}s:21:"kartik-v/yii2-widgets";a:3:{s:4:"name";s:21:"kartik-v/yii2-widgets";s:7:"version";s:7:"3.4.0.0";s:5:"alias";a:1:{s:15:"@kartik/widgets";s:46:"/var/www/residenz/vendor/kartik-v/yii2-widgets";}}s:20:"yiisoft/yii2-imagine";a:3:{s:4:"name";s:20:"yiisoft/yii2-imagine";s:7:"version";s:7:"2.1.1.0";s:5:"alias";a:1:{s:12:"@yii/imagine";s:49:"/var/www/residenz/vendor/yiisoft/yii2-imagine/src";}}s:20:"budyaga/yii2-cropper";a:3:{s:4:"name";s:20:"budyaga/yii2-cropper";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:16:"@budyaga/cropper";s:45:"/var/www/residenz/vendor/budyaga/yii2-cropper";}}s:25:"bupy7/yii2-widget-cropbox";a:3:{s:4:"name";s:25:"bupy7/yii2-widget-cropbox";s:7:"version";s:7:"4.1.1.0";s:5:"alias";a:1:{s:14:"@bupy7/cropbox";s:50:"/var/www/residenz/vendor/bupy7/yii2-widget-cropbox";}}s:18:"kartik-v/yii2-mpdf";a:3:{s:4:"name";s:18:"kartik-v/yii2-mpdf";s:7:"version";s:7:"1.0.1.0";s:5:"alias";a:1:{s:12:"@kartik/mpdf";s:43:"/var/www/residenz/vendor/kartik-v/yii2-mpdf";}}s:20:"kartik-v/yii2-export";a:3:{s:4:"name";s:20:"kartik-v/yii2-export";s:7:"version";s:7:"1.2.7.0";s:5:"alias";a:1:{s:14:"@kartik/export";s:45:"/var/www/residenz/vendor/kartik-v/yii2-export";}}s:31:"philippfrenzel/yii2fullcalendar";a:3:{s:4:"name";s:31:"philippfrenzel/yii2fullcalendar";s:7:"version";s:7:"2.1.1.0";s:5:"alias";a:1:{s:17:"@yii2fullcalendar";s:56:"/var/www/residenz/vendor/philippfrenzel/yii2fullcalendar";}}s:32:"wadeshuler/yii2-sliderrevolution";a:3:{s:4:"name";s:32:"wadeshuler/yii2-sliderrevolution";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:28:"@wadeshuler/sliderrevolution";s:57:"/var/www/residenz/vendor/wadeshuler/yii2-sliderrevolution";}}s:26:"moonlandsoft/yii2-phpexcel";a:3:{s:4:"name";s:26:"moonlandsoft/yii2-phpexcel";s:7:"version";s:7:"1.1.0.0";s:5:"alias";a:1:{s:18:"@moonland/phpexcel";s:51:"/var/www/residenz/vendor/moonlandsoft/yii2-phpexcel";}}s:26:"wbraganca/yii2-dynamicform";a:3:{s:4:"name";s:26:"wbraganca/yii2-dynamicform";s:7:"version";s:7:"2.0.2.0";s:5:"alias";a:1:{s:22:"@wbraganca/dynamicform";s:51:"/var/www/residenz/vendor/wbraganca/yii2-dynamicform";}}s:24:"borales/yii2-phone-input";a:3:{s:4:"name";s:24:"borales/yii2-phone-input";s:7:"version";s:7:"0.0.5.0";s:5:"alias";a:1:{s:30:"@borales/extensions/phoneInput";s:53:"/var/www/residenz/vendor/borales/yii2-phone-input/src";}}s:22:"sammaye/yii2-mailchimp";a:3:{s:4:"name";s:22:"sammaye/yii2-mailchimp";s:7:"version";s:7:"0.1.2.0";s:5:"alias";a:1:{s:18:"@sammaye/mailchimp";s:47:"/var/www/residenz/vendor/sammaye/yii2-mailchimp";}}s:22:"2amigos/qrcode-library";a:3:{s:4:"name";s:22:"2amigos/qrcode-library";s:7:"version";s:7:"1.1.2.0";s:5:"alias";a:1:{s:10:"@Da/QrCode";s:51:"/var/www/residenz/vendor/2amigos/qrcode-library/src";}}s:34:"miloschuman/yii2-highcharts-widget";a:3:{s:4:"name";s:34:"miloschuman/yii2-highcharts-widget";s:7:"version";s:7:"6.0.0.0";s:5:"alias";a:1:{s:23:"@miloschuman/highcharts";s:63:"/var/www/residenz/vendor/miloschuman/yii2-highcharts-widget/src";}}s:24:"yiisoft/yii2-codeception";a:3:{s:4:"name";s:24:"yiisoft/yii2-codeception";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:16:"@yii/codeception";s:49:"/var/www/residenz/vendor/yiisoft/yii2-codeception";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.0.10.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:43:"/var/www/residenz/vendor/yiisoft/yii2-debug";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:41:"/var/www/residenz/vendor/yiisoft/yii2-gii";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.3.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:43:"/var/www/residenz/vendor/yiisoft/yii2-faker";}}s:28:"2amigos/yii2-ckeditor-widget";a:3:{s:4:"name";s:28:"2amigos/yii2-ckeditor-widget";s:7:"version";s:7:"1.0.4.0";s:5:"alias";a:1:{s:19:"@dosamigos/ckeditor";s:57:"/var/www/residenz/vendor/2amigos/yii2-ckeditor-widget/src";}}s:23:"mdmsoft/yii2-autonumber";a:4:{s:4:"name";s:23:"mdmsoft/yii2-autonumber";s:7:"version";s:7:"1.4.0.0";s:5:"alias";a:1:{s:15:"@mdm/autonumber";s:48:"/var/www/residenz/vendor/mdmsoft/yii2-autonumber";}s:9:"bootstrap";s:24:"mdm\autonumber\Bootstrap";}s:20:"kartik-v/yii2-dialog";a:3:{s:4:"name";s:20:"kartik-v/yii2-dialog";s:7:"version";s:7:"1.0.1.0";s:5:"alias";a:1:{s:14:"@kartik/dialog";s:45:"/var/www/residenz/vendor/kartik-v/yii2-dialog";}}s:18:"kartik-v/yii2-grid";a:3:{s:4:"name";s:18:"kartik-v/yii2-grid";s:7:"version";s:7:"3.1.3.0";s:5:"alias";a:1:{s:12:"@kartik/grid";s:43:"/var/www/residenz/vendor/kartik-v/yii2-grid";}}s:22:"kartik-v/yii2-dynagrid";a:3:{s:4:"name";s:22:"kartik-v/yii2-dynagrid";s:7:"version";s:7:"1.4.5.0";s:5:"alias";a:1:{s:16:"@kartik/dynagrid";s:47:"/var/www/residenz/vendor/kartik-v/yii2-dynagrid";}}s:23:"raoul2000/yii2-workflow";a:3:{s:4:"name";s:23:"raoul2000/yii2-workflow";s:7:"version";s:7:"1.1.0.0";s:5:"alias";a:1:{s:19:"@raoul2000/workflow";s:52:"/var/www/residenz/vendor/raoul2000/yii2-workflow/src";}}s:32:"cornernote/yii2-workflow-manager";a:3:{s:4:"name";s:32:"cornernote/yii2-workflow-manager";s:7:"version";s:7:"1.0.1.0";s:5:"alias";a:1:{s:28:"@cornernote/workflow/manager";s:61:"/var/www/residenz/vendor/cornernote/yii2-workflow-manager/src";}}s:25:"kartik-v/yii2-krajee-base";a:3:{s:4:"name";s:25:"kartik-v/yii2-krajee-base";s:7:"version";s:7:"1.9.9.0";s:5:"alias";a:1:{s:12:"@kartik/base";s:54:"/var/www/residenz/vendor/kartik-v/yii2-krajee-base/src";}}s:25:"kartik-v/yii2-field-range";a:3:{s:4:"name";s:25:"kartik-v/yii2-field-range";s:7:"version";s:7:"1.3.1.0";s:5:"alias";a:1:{s:13:"@kartik/field";s:50:"/var/www/residenz/vendor/kartik-v/yii2-field-range";}}s:24:"kartik-v/yii2-date-range";a:3:{s:4:"name";s:24:"kartik-v/yii2-date-range";s:7:"version";s:7:"1.6.9.0";s:5:"alias";a:1:{s:17:"@kartik/daterange";s:49:"/var/www/residenz/vendor/kartik-v/yii2-date-range";}}s:28:"kartik-v/yii2-widget-select2";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-select2";s:7:"version";s:7:"2.1.3.0";s:5:"alias";a:1:{s:15:"@kartik/select2";s:57:"/var/www/residenz/vendor/kartik-v/yii2-widget-select2/src";}}s:28:"raoul2000/yii2-workflow-view";a:3:{s:4:"name";s:28:"raoul2000/yii2-workflow-view";s:7:"version";s:7:"0.0.2.0";s:5:"alias";a:1:{s:24:"@raoul2000/workflow/view";s:57:"/var/www/residenz/vendor/raoul2000/yii2-workflow-view/src";}}s:22:"kartik-v/yii2-sortable";a:3:{s:4:"name";s:22:"kartik-v/yii2-sortable";s:7:"version";s:7:"1.2.1.0";s:5:"alias";a:1:{s:16:"@kartik/sortable";s:51:"/var/www/residenz/vendor/kartik-v/yii2-sortable/src";}}s:31:"kartik-v/yii2-widget-activeform";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-activeform";s:7:"version";s:7:"1.5.7.0";s:5:"alias";a:1:{s:12:"@kartik/form";s:60:"/var/www/residenz/vendor/kartik-v/yii2-widget-activeform/src";}}s:31:"kartik-v/yii2-widget-colorinput";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-colorinput";s:7:"version";s:7:"1.0.5.0";s:5:"alias";a:1:{s:13:"@kartik/color";s:60:"/var/www/residenz/vendor/kartik-v/yii2-widget-colorinput/src";}}s:31:"kartik-v/yii2-widget-datepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-datepicker";s:7:"version";s:7:"1.4.6.0";s:5:"alias";a:1:{s:12:"@kartik/date";s:60:"/var/www/residenz/vendor/kartik-v/yii2-widget-datepicker/src";}}s:30:"kartik-v/yii2-widget-fileinput";a:3:{s:4:"name";s:30:"kartik-v/yii2-widget-fileinput";s:7:"version";s:7:"1.0.8.0";s:5:"alias";a:1:{s:12:"@kartik/file";s:59:"/var/www/residenz/vendor/kartik-v/yii2-widget-fileinput/src";}}s:31:"kartik-v/yii2-widget-rangeinput";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-rangeinput";s:7:"version";s:7:"1.0.2.0";s:5:"alias";a:1:{s:13:"@kartik/range";s:60:"/var/www/residenz/vendor/kartik-v/yii2-widget-rangeinput/src";}}s:27:"kartik-v/yii2-widget-rating";a:3:{s:4:"name";s:27:"kartik-v/yii2-widget-rating";s:7:"version";s:7:"1.0.4.0";s:5:"alias";a:1:{s:14:"@kartik/rating";s:56:"/var/www/residenz/vendor/kartik-v/yii2-widget-rating/src";}}s:30:"kartik-v/yii2-widget-touchspin";a:3:{s:4:"name";s:30:"kartik-v/yii2-widget-touchspin";s:7:"version";s:7:"1.2.3.0";s:5:"alias";a:1:{s:17:"@kartik/touchspin";s:59:"/var/www/residenz/vendor/kartik-v/yii2-widget-touchspin/src";}}s:30:"kartik-v/yii2-widget-typeahead";a:3:{s:4:"name";s:30:"kartik-v/yii2-widget-typeahead";s:7:"version";s:7:"1.0.2.0";s:5:"alias";a:1:{s:17:"@kartik/typeahead";s:59:"/var/www/residenz/vendor/kartik-v/yii2-widget-typeahead/src";}}s:23:"sadovojav/yii2-ckeditor";a:3:{s:4:"name";s:23:"sadovojav/yii2-ckeditor";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:19:"@sadovojav/ckeditor";s:48:"/var/www/residenz/vendor/sadovojav/yii2-ckeditor";}}s:20:"kartik-v/yii2-social";a:3:{s:4:"name";s:20:"kartik-v/yii2-social";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:14:"@kartik/social";s:49:"/var/www/residenz/vendor/kartik-v/yii2-social/src";}}s:27:"vova07/yii2-imperavi-widget";a:3:{s:4:"name";s:27:"vova07/yii2-imperavi-widget";s:7:"version";s:8:"2.0.11.0";s:5:"alias";a:2:{s:16:"@vova07/imperavi";s:56:"/var/www/residenz/vendor/vova07/yii2-imperavi-widget/src";s:22:"@vova07/imperavi/tests";s:58:"/var/www/residenz/vendor/vova07/yii2-imperavi-widget/tests";}}}}";s:7:"request";s:3712:"a:14:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:16:{s:12:"content-type";s:33:"application/x-www-form-urlencoded";s:14:"content-length";s:0:"";s:4:"host";s:17:"api.iresidenz.com";s:10:"connection";s:10:"keep-alive";s:18:"sec-ch-ua-platform";s:9:""Android"";s:10:"user-agent";s:157:"Mozilla/5.0 (Linux; Android 15; REA-NX9 Build/HONORREA-N39; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/151.0.7922.199 Mobile Safari/537.36";s:9:"sec-ch-ua";s:67:""Not=A?Brand";v="99", "Android WebView";v="151", "Chromium";v="151"";s:16:"sec-ch-ua-mobile";s:2:"?1";s:6:"accept";s:3:"*/*";s:16:"x-requested-with";s:34:"com.ionicframework.iresidenz955183";s:14:"sec-fetch-site";s:10:"cross-site";s:14:"sec-fetch-mode";s:4:"cors";s:14:"sec-fetch-dest";s:5:"empty";s:15:"accept-encoding";s:23:"gzip, deflate, br, zstd";s:15:"accept-language";s:47:"zh-MY,zh;q=0.9,en-MY;q=0.8,en-US;q=0.7,en;q=0.6";s:6:"cookie";s:36:"PHPSESSID=9ei6h6ce038296urhcq3khnig3";}s:15:"responseHeaders";a:2:{s:32:"Access-Control-Allow-Credentials";s:4:"true";s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:25:"bills-statements/billscsv";s:6:"action";s:70:"api\modules\v1\controllers\BillsStatementsController::actionBillscsv()";s:12:"actionParams";a:0:{}s:11:"requestBody";a:0:{}s:6:"SERVER";a:41:{s:4:"USER";s:8:"www-data";s:4:"HOME";s:8:"/var/www";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:12:"QUERY_STRING";s:87:"year=2026&access-token=1S8TAgQVI3kheZBhg0eo3NjhDpmQYgv-&condo_id=86&condo_unit_id=30759";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"CONTENT_TYPE";s:33:"application/x-www-form-urlencoded";s:14:"CONTENT_LENGTH";s:0:"";s:15:"SCRIPT_FILENAME";s:35:"/var/www/residenz/api/web/index.php";s:11:"SCRIPT_NAME";s:10:"/index.php";s:11:"REQUEST_URI";s:114:"/bills-statements/billscsv?year=2026&access-token=1S8TAgQVI3kheZBhg0eo3NjhDpmQYgv-&condo_id=86&condo_unit_id=30759";s:12:"DOCUMENT_URI";s:10:"/index.php";s:13:"DOCUMENT_ROOT";s:25:"/var/www/residenz/api/web";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_SOFTWARE";s:11:"nginx/1.4.6";s:11:"REMOTE_ADDR";s:13:"113.210.106.5";s:11:"REMOTE_PORT";s:5:"22355";s:11:"SERVER_ADDR";s:15:"128.199.245.231";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_NAME";s:17:"api.iresidenz.com";s:5:"HTTPS";s:2:"on";s:15:"REDIRECT_STATUS";s:3:"200";s:9:"PATH_INFO";s:10:"/index.php";s:9:"HTTP_HOST";s:17:"api.iresidenz.com";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:9:""Android"";s:15:"HTTP_USER_AGENT";s:157:"Mozilla/5.0 (Linux; Android 15; REA-NX9 Build/HONORREA-N39; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/151.0.7922.199 Mobile Safari/537.36";s:14:"HTTP_SEC_CH_UA";s:67:""Not=A?Brand";v="99", "Android WebView";v="151", "Chromium";v="151"";s:17:"HTTP_CONTENT_TYPE";s:33:"application/x-www-form-urlencoded";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?1";s:11:"HTTP_ACCEPT";s:3:"*/*";s:21:"HTTP_X_REQUESTED_WITH";s:34:"com.ionicframework.iresidenz955183";s:19:"HTTP_SEC_FETCH_SITE";s:10:"cross-site";s:19:"HTTP_SEC_FETCH_MODE";s:4:"cors";s:19:"HTTP_SEC_FETCH_DEST";s:5:"empty";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:20:"HTTP_ACCEPT_LANGUAGE";s:47:"zh-MY,zh;q=0.9,en-MY;q=0.8,en-US;q=0.7,en;q=0.6";s:11:"HTTP_COOKIE";s:36:"PHPSESSID=9ei6h6ce038296urhcq3khnig3";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1788242179.7192171;s:12:"REQUEST_TIME";i:1788242179;}s:3:"GET";a:4:{s:4:"year";s:4:"2026";s:12:"access-token";s:32:"1S8TAgQVI3kheZBhg0eo3NjhDpmQYgv-";s:8:"condo_id";s:2:"86";s:13:"condo_unit_id";s:5:"30759";}s:4:"POST";a:0:{}s:6:"COOKIE";a:1:{s:9:"PHPSESSID";s:26:"9ei6h6ce038296urhcq3khnig3";}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:3:"log";s:13881:"a:1:{s:8:"messages";a:31:{i:0;a:6:{i:0;s:52:"Bootstrap with mdm\autonumber\Bootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1788242179.721343;i:4;a:0:{}i:5;i:1210624;}i:1;a:6:{i:0;s:33:"Bootstrap with yii\log\Dispatcher";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1788242179.7219729;i:4;a:0:{}i:5;i:1357440;}i:2;a:6:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1788242179.7220221;i:4;a:0:{}i:5;i:1360272;}i:3;a:6:{i:0;s:44:"Bootstrap with yii\debug\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1788242179.723315;i:4;a:0:{}i:5;i:1856312;}i:4;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1788242179.7248759;i:4;a:0:{}i:5;i:2225912;}i:5;a:6:{i:0;s:42:"Bootstrap with yii\gii\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1788242179.7250161;i:4;a:0:{}i:5;i:2260776;}i:13;a:6:{i:0;s:44:"Route requested: 'bills-statements/billscsv'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1788242179.7255659;i:4;a:0:{}i:5;i:2334664;}i:14;a:6:{i:0;s:39:"Route to run: bills-statements/billscsv";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1788242179.725884;i:4;a:0:{}i:5;i:2474072;}i:15;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=residenz";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1788242179.7275479;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3195528;}i:18;a:6:{i:0;s:76:"SELECT * FROM `user` WHERE `access_token`='1S8TAgQVI3kheZBhg0eo3NjhDpmQYgv-'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.728205;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3204264;}i:21;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.728596;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3236232;}i:24;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'user' AND kcu.table_name = 'user'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7305579;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3279304;}i:27;a:6:{i:0;s:63:"SELECT COUNT(*) FROM `vms_login_accounts` WHERE `user_id`=18410";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.734272;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:78;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:3336744;}i:30;a:6:{i:0;s:63:"User '18410' logged in from 113.210.106.5. Session not enabled.";i:1;i:4;i:2;s:19:"yii\web\User::login";i:3;d:1788242179.7347021;i:4;a:0:{}i:5;i:3346344;}i:31;a:6:{i:0;s:65:"Rate limit skipped: "user" does not implement RateLimitInterface.";i:1;i:4;i:2;s:37:"yii\filters\RateLimiter::beforeAction";i:3;d:1788242179.734786;i:4;a:0:{}i:5;i:3342264;}i:32;a:6:{i:0;s:86:"Running action: api\modules\v1\controllers\BillsStatementsController::actionBillscsv()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1788242179.7348509;i:4;a:0:{}i:5;i:3339352;}i:33;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `condo`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7350881;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3418608;}i:36;a:6:{i:0;s:597:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'condo' AND kcu.table_name = 'condo'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7385089;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3481744;}i:39;a:6:{i:0;s:37:"SELECT * FROM `condo` WHERE `id`='86'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.739583;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3483416;}i:42;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `actionlog`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.740747;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:58;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3651440;}i:45;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'actionlog' AND kcu.table_name = 'actionlog'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.742768;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:58;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3680952;}i:48;a:6:{i:0;s:437:"INSERT INTO `actionlog` (`user_id`, `condo_id`, `unit_id`, `user_remote`, `action`, `category`, `status`, `message`, `user_agent`, `time`) VALUES (18410, 86, 30759, '113.210.106.5', 'billscsv', 'bills-statements|api-v1', 'info', 's:27:\"View bill csv for year=2026\";', 'Mozilla/5.0 (Linux; Android 15; REA-NX9 Build/HONORREA-N39; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/151.0.7922.199 Mobile Safari/537.36', NOW())";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1788242179.8472769;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:72;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3712112;}i:51;a:6:{i:0;s:91:"SELECT * FROM `user_role` WHERE condo_id = 86 AND condo_unit_id = 30759 AND user_id = 18410";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8575909;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3781992;}i:54;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `user_role`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8580179;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3808504;}i:57;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'user_role' AND kcu.table_name = 'user_role'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8593371;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3828784;}i:60;a:6:{i:0;s:35:"SELECT * FROM `role` WHERE `id`=498";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8674481;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3883888;}i:63;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `role`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8678851;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3909080;}i:66;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'role' AND kcu.table_name = 'role'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.869174;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3928000;}i:69;a:6:{i:0;s:132:"SELECT * FROM `condo_unit_bill_csv` WHERE condo_id = 86 AND condo_unit_id = 30759 AND (date_trnx LIKE '%2026%') ORDER BY `date_trnx`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.870672;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:464;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3978160;}i:72;a:6:{i:0;s:315:"SELECT DISTINCT `bill_id` FROM `badge_bill_csv` LEFT JOIN `condo_unit_bill_csv` ON condo_unit_bill_csv.billcsvid = badge_bill_csv.bill_id WHERE (`badge_bill_csv`.`user_id`=18410) AND (`badge_bill_csv`.`read_status`='U') AND (`condo_unit_bill_csv`.`condo_id`='86') AND (`condo_unit_bill_csv`.`condo_unit_id`='30759')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.871928;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/frontend/components/BadgeHelper.php";s:4:"line";i:191;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:475;s:8:"function";s:12:"getUnreadIds";s:5:"class";s:31:"frontend\components\BadgeHelper";s:4:"type";s:2:"->";}}i:5;i:4061144;}i:75;a:6:{i:0;s:102:"Access to debugger is denied due to IP address restriction. The requesting IP address is 113.210.106.5";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1788242179.8724639;i:4;a:0:{}i:5;i:4100456;}}}";s:9:"profiling";s:23693:"a:3:{s:6:"memory";i:4160552;s:4:"time";d:0.15467095375061035;s:8:"messages";a:38:{i:16;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=residenz";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1788242179.727648;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3198040;}i:17;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=residenz";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1788242179.7280841;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3209184;}i:19;a:6:{i:0;s:76:"SELECT * FROM `user` WHERE `access_token`='1S8TAgQVI3kheZBhg0eo3NjhDpmQYgv-'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7282741;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3208176;}i:20;a:6:{i:0;s:76:"SELECT * FROM `user` WHERE `access_token`='1S8TAgQVI3kheZBhg0eo3NjhDpmQYgv-'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7284131;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3216472;}i:22;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.728667;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3239400;}i:23;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.729686;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3280040;}i:25;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'user' AND kcu.table_name = 'user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.730653;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3283456;}i:26;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'user' AND kcu.table_name = 'user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7334809;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3286392;}i:28;a:6:{i:0;s:63:"SELECT COUNT(*) FROM `vms_login_accounts` WHERE `user_id`=18410";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.734376;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:78;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:3339920;}i:29;a:6:{i:0;s:63:"SELECT COUNT(*) FROM `vms_login_accounts` WHERE `user_id`=18410";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.734539;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:78;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:3342536;}i:34;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `condo`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.735148;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3421808;}i:35;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `condo`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7368109;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3535672;}i:37;a:6:{i:0;s:597:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'condo' AND kcu.table_name = 'condo'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7385881;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3485920;}i:38;a:6:{i:0;s:597:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'condo' AND kcu.table_name = 'condo'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.739265;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3488880;}i:40;a:6:{i:0;s:37:"SELECT * FROM `condo` WHERE `id`='86'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7396369;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3486608;}i:41;a:6:{i:0;s:37:"SELECT * FROM `condo` WHERE `id`='86'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.739841;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3526856;}i:43;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `actionlog`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7408259;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:58;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3657104;}i:44;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `actionlog`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.741818;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:58;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3686392;}i:46;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'actionlog' AND kcu.table_name = 'actionlog'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7428589;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:58;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3687568;}i:47;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'actionlog' AND kcu.table_name = 'actionlog'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8466499;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:58;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3692968;}i:49;a:6:{i:0;s:437:"INSERT INTO `actionlog` (`user_id`, `condo_id`, `unit_id`, `user_remote`, `action`, `category`, `status`, `message`, `user_agent`, `time`) VALUES (18410, 86, 30759, '113.210.106.5', 'billscsv', 'bills-statements|api-v1', 'info', 's:27:\"View bill csv for year=2026\";', 'Mozilla/5.0 (Linux; Android 15; REA-NX9 Build/HONORREA-N39; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/151.0.7922.199 Mobile Safari/537.36', NOW())";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788242179.847342;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:72;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3716544;}i:50;a:6:{i:0;s:437:"INSERT INTO `actionlog` (`user_id`, `condo_id`, `unit_id`, `user_remote`, `action`, `category`, `status`, `message`, `user_agent`, `time`) VALUES (18410, 86, 30759, '113.210.106.5', 'billscsv', 'bills-statements|api-v1', 'info', 's:27:\"View bill csv for year=2026\";', 'Mozilla/5.0 (Linux; Android 15; REA-NX9 Build/HONORREA-N39; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/151.0.7922.199 Mobile Safari/537.36', NOW())";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788242179.857033;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:72;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3721536;}i:52;a:6:{i:0;s:91:"SELECT * FROM `user_role` WHERE condo_id = 86 AND condo_unit_id = 30759 AND user_id = 18410";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8576839;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3785328;}i:53;a:6:{i:0;s:91:"SELECT * FROM `user_role` WHERE condo_id = 86 AND condo_unit_id = 30759 AND user_id = 18410";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8578129;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3790752;}i:55;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `user_role`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.858077;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3811728;}i:56;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `user_role`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.858891;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3834528;}i:58;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'user_role' AND kcu.table_name = 'user_role'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.859391;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3832960;}i:59;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'user_role' AND kcu.table_name = 'user_role'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.866823;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3835944;}i:61;a:6:{i:0;s:35:"SELECT * FROM `role` WHERE `id`=498";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.867522;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3887048;}i:62;a:6:{i:0;s:35:"SELECT * FROM `role` WHERE `id`=498";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.867671;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3891896;}i:64;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `role`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8679521;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3912288;}i:65;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `role`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8686991;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3931744;}i:67;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'role' AND kcu.table_name = 'role'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8692379;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3932176;}i:68;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'role' AND kcu.table_name = 'role'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.870163;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3935136;}i:70;a:6:{i:0;s:132:"SELECT * FROM `condo_unit_bill_csv` WHERE condo_id = 86 AND condo_unit_id = 30759 AND (date_trnx LIKE '%2026%') ORDER BY `date_trnx`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8707311;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:464;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3981576;}i:71;a:6:{i:0;s:132:"SELECT * FROM `condo_unit_bill_csv` WHERE condo_id = 86 AND condo_unit_id = 30759 AND (date_trnx LIKE '%2026%') ORDER BY `date_trnx`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8713679;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:464;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3986312;}i:73;a:6:{i:0;s:315:"SELECT DISTINCT `bill_id` FROM `badge_bill_csv` LEFT JOIN `condo_unit_bill_csv` ON condo_unit_bill_csv.billcsvid = badge_bill_csv.bill_id WHERE (`badge_bill_csv`.`user_id`=18410) AND (`badge_bill_csv`.`read_status`='U') AND (`condo_unit_bill_csv`.`condo_id`='86') AND (`condo_unit_bill_csv`.`condo_unit_id`='30759')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.871989;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/frontend/components/BadgeHelper.php";s:4:"line";i:191;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:475;s:8:"function";s:12:"getUnreadIds";s:5:"class";s:31:"frontend\components\BadgeHelper";s:4:"type";s:2:"->";}}i:5;i:4065496;}i:74;a:6:{i:0;s:315:"SELECT DISTINCT `bill_id` FROM `badge_bill_csv` LEFT JOIN `condo_unit_bill_csv` ON condo_unit_bill_csv.billcsvid = badge_bill_csv.bill_id WHERE (`badge_bill_csv`.`user_id`=18410) AND (`badge_bill_csv`.`read_status`='U') AND (`condo_unit_bill_csv`.`condo_id`='86') AND (`condo_unit_bill_csv`.`condo_unit_id`='30759')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.872087;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/frontend/components/BadgeHelper.php";s:4:"line";i:191;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:475;s:8:"function";s:12:"getUnreadIds";s:5:"class";s:31:"frontend\components\BadgeHelper";s:4:"type";s:2:"->";}}i:5;i:4069416;}}}";s:2:"db";s:22918:"a:1:{s:8:"messages";a:36:{i:19;a:6:{i:0;s:76:"SELECT * FROM `user` WHERE `access_token`='1S8TAgQVI3kheZBhg0eo3NjhDpmQYgv-'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7282741;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3208176;}i:20;a:6:{i:0;s:76:"SELECT * FROM `user` WHERE `access_token`='1S8TAgQVI3kheZBhg0eo3NjhDpmQYgv-'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7284131;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3216472;}i:22;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.728667;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3239400;}i:23;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.729686;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3280040;}i:25;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'user' AND kcu.table_name = 'user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.730653;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3283456;}i:26;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'user' AND kcu.table_name = 'user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7334809;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:75;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3286392;}i:28;a:6:{i:0;s:63:"SELECT COUNT(*) FROM `vms_login_accounts` WHERE `user_id`=18410";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.734376;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:78;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:3339920;}i:29;a:6:{i:0;s:63:"SELECT COUNT(*) FROM `vms_login_accounts` WHERE `user_id`=18410";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.734539;i:4;a:1:{i:0;a:5:{s:4:"file";s:48:"/var/www/residenz/api/modules/v1/models/User.php";s:4:"line";i:78;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:3342536;}i:34;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `condo`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.735148;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3421808;}i:35;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `condo`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7368109;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3535672;}i:37;a:6:{i:0;s:597:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'condo' AND kcu.table_name = 'condo'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7385881;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3485920;}i:38;a:6:{i:0;s:597:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'condo' AND kcu.table_name = 'condo'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.739265;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3488880;}i:40;a:6:{i:0;s:37:"SELECT * FROM `condo` WHERE `id`='86'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7396369;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3486608;}i:41;a:6:{i:0;s:37:"SELECT * FROM `condo` WHERE `id`='86'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.739841;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:451;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:3526856;}i:43;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `actionlog`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7408259;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:58;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3657104;}i:44;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `actionlog`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.741818;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:58;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3686392;}i:46;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'actionlog' AND kcu.table_name = 'actionlog'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.7428589;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:58;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3687568;}i:47;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'actionlog' AND kcu.table_name = 'actionlog'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8466499;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:58;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3692968;}i:49;a:6:{i:0;s:437:"INSERT INTO `actionlog` (`user_id`, `condo_id`, `unit_id`, `user_remote`, `action`, `category`, `status`, `message`, `user_agent`, `time`) VALUES (18410, 86, 30759, '113.210.106.5', 'billscsv', 'bills-statements|api-v1', 'info', 's:27:\"View bill csv for year=2026\";', 'Mozilla/5.0 (Linux; Android 15; REA-NX9 Build/HONORREA-N39; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/151.0.7922.199 Mobile Safari/537.36', NOW())";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1788242179.847342;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:72;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3716544;}i:50;a:6:{i:0;s:437:"INSERT INTO `actionlog` (`user_id`, `condo_id`, `unit_id`, `user_remote`, `action`, `category`, `status`, `message`, `user_agent`, `time`) VALUES (18410, 86, 30759, '113.210.106.5', 'billscsv', 'bills-statements|api-v1', 'info', 's:27:\"View bill csv for year=2026\";', 'Mozilla/5.0 (Linux; Android 15; REA-NX9 Build/HONORREA-N39; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/151.0.7922.199 Mobile Safari/537.36', NOW())";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1788242179.857033;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/api/modules/v1/models/ActionLog.php";s:4:"line";i:72;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/residenz/api/modules/v1/components/Helpers.php";s:4:"line";i:1204;s:8:"function";s:8:"addtolog";s:5:"class";s:31:"api\modules\v1\models\ActionLog";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:453;s:8:"function";s:8:"addtolog";s:5:"class";s:33:"api\modules\v1\components\Helpers";s:4:"type";s:2:"::";}}i:5;i:3721536;}i:52;a:6:{i:0;s:91:"SELECT * FROM `user_role` WHERE condo_id = 86 AND condo_unit_id = 30759 AND user_id = 18410";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8576839;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3785328;}i:53;a:6:{i:0;s:91:"SELECT * FROM `user_role` WHERE condo_id = 86 AND condo_unit_id = 30759 AND user_id = 18410";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8578129;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3790752;}i:55;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `user_role`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.858077;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3811728;}i:56;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `user_role`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.858891;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3834528;}i:58;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'user_role' AND kcu.table_name = 'user_role'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.859391;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3832960;}i:59;a:6:{i:0;s:605:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'user_role' AND kcu.table_name = 'user_role'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.866823;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:457;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3835944;}i:61;a:6:{i:0;s:35:"SELECT * FROM `role` WHERE `id`=498";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.867522;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3887048;}i:62;a:6:{i:0;s:35:"SELECT * FROM `role` WHERE `id`=498";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.867671;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3891896;}i:64;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `role`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8679521;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3912288;}i:65;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `role`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8686991;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3931744;}i:67;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'role' AND kcu.table_name = 'role'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8692379;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3932176;}i:68;a:6:{i:0;s:595:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'role' AND kcu.table_name = 'role'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.870163;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:459;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:3935136;}i:70;a:6:{i:0;s:132:"SELECT * FROM `condo_unit_bill_csv` WHERE condo_id = 86 AND condo_unit_id = 30759 AND (date_trnx LIKE '%2026%') ORDER BY `date_trnx`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8707311;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:464;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3981576;}i:71;a:6:{i:0;s:132:"SELECT * FROM `condo_unit_bill_csv` WHERE condo_id = 86 AND condo_unit_id = 30759 AND (date_trnx LIKE '%2026%') ORDER BY `date_trnx`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.8713679;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:464;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:3986312;}i:73;a:6:{i:0;s:315:"SELECT DISTINCT `bill_id` FROM `badge_bill_csv` LEFT JOIN `condo_unit_bill_csv` ON condo_unit_bill_csv.billcsvid = badge_bill_csv.bill_id WHERE (`badge_bill_csv`.`user_id`=18410) AND (`badge_bill_csv`.`read_status`='U') AND (`condo_unit_bill_csv`.`condo_id`='86') AND (`condo_unit_bill_csv`.`condo_unit_id`='30759')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.871989;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/frontend/components/BadgeHelper.php";s:4:"line";i:191;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:475;s:8:"function";s:12:"getUnreadIds";s:5:"class";s:31:"frontend\components\BadgeHelper";s:4:"type";s:2:"->";}}i:5;i:4065496;}i:74;a:6:{i:0;s:315:"SELECT DISTINCT `bill_id` FROM `badge_bill_csv` LEFT JOIN `condo_unit_bill_csv` ON condo_unit_bill_csv.billcsvid = badge_bill_csv.bill_id WHERE (`badge_bill_csv`.`user_id`=18410) AND (`badge_bill_csv`.`read_status`='U') AND (`condo_unit_bill_csv`.`condo_id`='86') AND (`condo_unit_bill_csv`.`condo_unit_id`='30759')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1788242179.872087;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/residenz/frontend/components/BadgeHelper.php";s:4:"line";i:191;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:74:"/var/www/residenz/api/modules/v1/controllers/BillsStatementsController.php";s:4:"line";i:475;s:8:"function";s:12:"getUnreadIds";s:5:"class";s:31:"frontend\components\BadgeHelper";s:4:"type";s:2:"->";}}i:5;i:4069416;}}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:91:"a:3:{s:5:"start";d:1788242179.719764;s:3:"end";d:1788242179.875061;s:6:"memory";i:4160552;}";s:4:"user";s:2417:"a:4:{s:8:"identity";a:19:{s:2:"id";s:5:"18410";s:8:"username";s:14:"'Ling Ung Wei'";s:8:"auth_key";s:34:"'vBhs24JEVzbA2Ug8fcKZaDJQ9eBga6Fp'";s:13:"password_hash";s:62:"'$2y$13$iJAtB5pBfQx0NfpzxN9QoeKjrMo4Qp5XV911HaAdrCHR2ppQiocky'";s:18:"password_generated";s:8:"'2f1747'";s:20:"password_reset_token";s:4:"null";s:5:"email";s:26:"'lingungwei1962@gmail.com'";s:12:"email_status";s:4:"null";s:6:"mobile";s:15:"'+601116597163'";s:6:"status";s:3:"'A'";s:15:"date_last_login";s:21:"'2025-03-28 05:55:40'";s:20:"password_sent_status";s:3:"'Y'";s:26:"welcome_email_sent_counter";s:1:"0";s:14:"activation_key";s:4:"null";s:16:"created_datetime";s:21:"'2018-01-02 16:55:21'";s:16:"updated_datetime";s:21:"'2026-08-04 10:03:11'";s:10:"created_by";s:5:"15804";s:10:"updated_by";s:5:"36826";s:12:"access_token";s:34:"'1S8TAgQVI3kheZBhg0eo3NjhDpmQYgv-'";}s:10:"attributes";a:19:{i:0;a:2:{s:9:"attribute";s:2:"id";s:5:"label";s:2:"Id";}i:1;a:2:{s:9:"attribute";s:8:"username";s:5:"label";s:8:"Username";}i:2;a:2:{s:9:"attribute";s:8:"auth_key";s:5:"label";s:8:"Auth Key";}i:3;a:2:{s:9:"attribute";s:13:"password_hash";s:5:"label";s:13:"Password Hash";}i:4;a:2:{s:9:"attribute";s:18:"password_generated";s:5:"label";s:18:"Password Generated";}i:5;a:2:{s:9:"attribute";s:20:"password_reset_token";s:5:"label";s:20:"Password Reset Token";}i:6;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:5:"Email";}i:7;a:2:{s:9:"attribute";s:12:"email_status";s:5:"label";s:12:"Email Status";}i:8;a:2:{s:9:"attribute";s:6:"mobile";s:5:"label";s:6:"Mobile";}i:9;a:2:{s:9:"attribute";s:6:"status";s:5:"label";s:6:"Status";}i:10;a:2:{s:9:"attribute";s:15:"date_last_login";s:5:"label";s:15:"Date Last Login";}i:11;a:2:{s:9:"attribute";s:20:"password_sent_status";s:5:"label";s:20:"Password Sent Status";}i:12;a:2:{s:9:"attribute";s:26:"welcome_email_sent_counter";s:5:"label";s:26:"Welcome Email Sent Counter";}i:13;a:2:{s:9:"attribute";s:14:"activation_key";s:5:"label";s:14:"Activation Key";}i:14;a:2:{s:9:"attribute";s:16:"created_datetime";s:5:"label";s:16:"Created Datetime";}i:15;a:2:{s:9:"attribute";s:16:"updated_datetime";s:5:"label";s:16:"Updated Datetime";}i:16;a:2:{s:9:"attribute";s:10:"created_by";s:5:"label";s:10:"Created By";}i:17;a:2:{s:9:"attribute";s:10:"updated_by";s:5:"label";s:10:"Updated By";}i:18;a:2:{s:9:"attribute";s:12:"access_token";s:5:"label";s:12:"Access Token";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:6:"router";s:1350:"a:1:{s:8:"messages";a:7:{i:6;a:6:{i:0;a:3:{s:4:"rule";s:3:"gii";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1788242179.7254241;i:4;a:0:{}i:5;i:2324616;}i:7;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1788242179.7254541;i:4;a:0:{}i:5;i:2326432;}i:8;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii//";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1788242179.7254729;i:4;a:0:{}i:5;i:2328280;}i:9;a:6:{i:0;a:3:{s:4:"rule";s:5:"debug";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1788242179.725491;i:4;a:0:{}i:5;i:2330160;}i:10;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug//";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1788242179.725507;i:4;a:0:{}i:5;i:2332008;}i:11;a:6:{i:0;a:3:{s:4:"rule";s:16:"yii\rest\UrlRule";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1788242179.7255311;i:4;a:0:{}i:5;i:2333984;}i:12;a:6:{i:0;s:55:"No matching URL rules. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1788242179.7255449;i:4;a:0:{}i:5;i:2335192;}}}";s:7:"summary";a:9:{s:3:"tag";s:13:"6a966903b0ab8";s:3:"url";s:139:"https://api.iresidenz.com/bills-statements/billscsv?year=2026&access-token=1S8TAgQVI3kheZBhg0eo3NjhDpmQYgv-&condo_id=86&condo_unit_id=30759";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:13:"113.210.106.5";s:4:"time";d:1788242179.7192171;s:10:"statusCode";i:200;s:8:"sqlCount";i:18;s:9:"mailCount";i:0;}s:10:"exceptions";a:0:{}}