a:14:{s:6:"config";s:14059:"a:5:{s:10:"phpVersion";s:6:"8.0.30";s:10:"yiiVersion";s:6:"2.0.47";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.47";s:4:"name";s:14:"My Application";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:6:"8.0.30";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:59:{s:28:"2amigos/yii2-ckeditor-widget";a:3:{s:4:"name";s:28:"2amigos/yii2-ckeditor-widget";s:7:"version";s:7:"2.1.0.0";s:5:"alias";a:1:{s:19:"@dosamigos/ckeditor";s:77:"/var/www/html/satusehat-rsaws-staging/vendor/2amigos/yii2-ckeditor-widget/src";}}s:30:"2amigos/yii2-highcharts-widget";a:3:{s:4:"name";s:30:"2amigos/yii2-highcharts-widget";s:7:"version";s:7:"1.0.3.0";s:5:"alias";a:1:{s:21:"@dosamigos/highcharts";s:79:"/var/www/html/satusehat-rsaws-staging/vendor/2amigos/yii2-highcharts-widget/src";}}s:21:"abushamleh/yii2-toast";a:3:{s:4:"name";s:21:"abushamleh/yii2-toast";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:17:"@abushamleh/toast";s:66:"/var/www/html/satusehat-rsaws-staging/vendor/abushamleh/yii2-toast";}}s:28:"buttflattery/yii2-formwizard";a:3:{s:4:"name";s:28:"buttflattery/yii2-formwizard";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:24:"@buttflattery/formwizard";s:5:"//src";}}s:27:"2amigos/yii2-chartjs-widget";a:3:{s:4:"name";s:27:"2amigos/yii2-chartjs-widget";s:7:"version";s:7:"2.1.3.0";s:5:"alias";a:1:{s:18:"@dosamigos/chartjs";s:76:"/var/www/html/satusehat-rsaws-staging/vendor/2amigos/yii2-chartjs-widget/src";}}s:22:"yiisoft/yii2-bootstrap";a:3:{s:4:"name";s:22:"yiisoft/yii2-bootstrap";s:7:"version";s:8:"2.0.11.0";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:71:"/var/www/html/satusehat-rsaws-staging/vendor/yiisoft/yii2-bootstrap/src";}}s:18:"cebe/yii2-gravatar";a:3:{s:4:"name";s:18:"cebe/yii2-gravatar";s:7:"version";s:7:"1.1.0.0";s:5:"alias";a:1:{s:14:"@cebe/gravatar";s:77:"/var/www/html/satusehat-rsaws-staging/vendor/cebe/yii2-gravatar/cebe/gravatar";}}s:24:"rmrevin/yii2-fontawesome";a:3:{s:4:"name";s:24:"rmrevin/yii2-fontawesome";s:7:"version";s:8:"2.17.1.0";s:5:"alias";a:1:{s:24:"@rmrevin/yii/fontawesome";s:69:"/var/www/html/satusehat-rsaws-staging/vendor/rmrevin/yii2-fontawesome";}}s:24:"drsdre/yii2-wizardwidget";a:3:{s:4:"name";s:24:"drsdre/yii2-wizardwidget";s:7:"version";s:7:"1.2.3.0";s:5:"alias";a:1:{s:20:"@drsdre/wizardwidget";s:69:"/var/www/html/satusehat-rsaws-staging/vendor/drsdre/yii2-wizardwidget";}}s:25:"dmstr/yii2-adminlte-asset";a:3:{s:4:"name";s:25:"dmstr/yii2-adminlte-asset";s:7:"version";s:7:"2.6.2.0";s:5:"alias";a:1:{s:6:"@dmstr";s:70:"/var/www/html/satusehat-rsaws-staging/vendor/dmstr/yii2-adminlte-asset";}}s:31:"et-soft/yii2-widget-select-year";a:3:{s:4:"name";s:31:"et-soft/yii2-widget-select-year";s:7:"version";s:7:"1.0.0.0";s:5:"alias";a:1:{s:15:"@etsoft/widgets";s:76:"/var/www/html/satusehat-rsaws-staging/vendor/et-soft/yii2-widget-select-year";}}s:23:"extead/yii2-autonumeric";a:3:{s:4:"name";s:23:"extead/yii2-autonumeric";s:7:"version";s:7:"0.1.2.0";s:5:"alias";a:1:{s:19:"@extead/autonumeric";s:68:"/var/www/html/satusehat-rsaws-staging/vendor/extead/yii2-autonumeric";}}s:30:"insolita/yii2-adminlte-widgets";a:3:{s:4:"name";s:30:"insolita/yii2-adminlte-widgets";s:7:"version";s:7:"3.2.3.0";s:5:"alias";a:1:{s:20:"@insolita/wgadminlte";s:75:"/var/www/html/satusehat-rsaws-staging/vendor/insolita/yii2-adminlte-widgets";}}s:25:"kartik-v/yii2-krajee-base";a:3:{s:4:"name";s:25:"kartik-v/yii2-krajee-base";s:7:"version";s:7:"3.0.5.0";s:5:"alias";a:1:{s:12:"@kartik/base";s:74:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-krajee-base/src";}}s:33:"kartik-v/yii2-bootstrap4-dropdown";a:3:{s:4:"name";s:33:"kartik-v/yii2-bootstrap4-dropdown";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:19:"@kartik/bs4dropdown";s:82:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-bootstrap4-dropdown/src";}}s:24:"kartik-v/yii2-date-range";a:3:{s:4:"name";s:24:"kartik-v/yii2-date-range";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:17:"@kartik/daterange";s:73:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-date-range/src";}}s:31:"kartik-v/yii2-widget-activeform";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-activeform";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:12:"@kartik/form";s:80:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-activeform/src";}}s:20:"kartik-v/yii2-dialog";a:3:{s:4:"name";s:20:"kartik-v/yii2-dialog";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:14:"@kartik/dialog";s:69:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-dialog/src";}}s:25:"kartik-v/yii2-detail-view";a:3:{s:4:"name";s:25:"kartik-v/yii2-detail-view";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:14:"@kartik/detail";s:74:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-detail-view/src";}}s:28:"kartik-v/yii2-widget-select2";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-select2";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:15:"@kartik/select2";s:77:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-select2/src";}}s:18:"kartik-v/yii2-mpdf";a:3:{s:4:"name";s:18:"kartik-v/yii2-mpdf";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:12:"@kartik/mpdf";s:67:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-mpdf/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.2.0";s:5:"alias";a:1:{s:16:"@kartik/sortable";s:71:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-sortable/src";}}s:20:"kartik-v/yii2-export";a:3:{s:4:"name";s:20:"kartik-v/yii2-export";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:14:"@kartik/export";s:69:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-export/src";}}s:20:"kartik-v/yii2-number";a:3:{s:4:"name";s:20:"kartik-v/yii2-number";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:14:"@kartik/number";s:69:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-number/src";}}s:18:"kartik-v/yii2-grid";a:3:{s:4:"name";s:18:"kartik-v/yii2-grid";s:7:"version";s:7:"3.5.0.0";s:5:"alias";a:1:{s:12:"@kartik/grid";s:67:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-grid/src";}}s:22:"kartik-v/yii2-dynagrid";a:3:{s:4:"name";s:22:"kartik-v/yii2-dynagrid";s:7:"version";s:7:"1.5.4.0";s:5:"alias";a:1:{s:16:"@kartik/dynagrid";s:71:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-dynagrid/src";}}s:20:"kartik-v/yii2-slider";a:3:{s:4:"name";s:20:"kartik-v/yii2-slider";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:14:"@kartik/slider";s:69:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-slider/src";}}s:20:"kartik-v/yii2-tabs-x";a:3:{s:4:"name";s:20:"kartik-v/yii2-tabs-x";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:12:"@kartik/tabs";s:69:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-tabs-x/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.4.0";s:5:"alias";a:1:{s:17:"@kartik/typeahead";s:79:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-typeahead/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.4.0";s:5:"alias";a:1:{s:17:"@kartik/touchspin";s:79:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-touchspin/src";}}s:31:"kartik-v/yii2-widget-timepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-timepicker";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:12:"@kartik/time";s:80:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-timepicker/src";}}s:28:"kartik-v/yii2-widget-spinner";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-spinner";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:15:"@kartik/spinner";s:77:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-spinner/src";}}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.1.0";s:5:"alias";a:1:{s:15:"@kartik/sidenav";s:73:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-sidenav";}}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:77:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-switchinput";}}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.5.0";s:5:"alias";a:1:{s:14:"@kartik/rating";s:76:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-rating/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:80:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-rangeinput/src";}}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.2.0";s:5:"alias";a:1:{s:13:"@kartik/growl";s:75:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-growl/src";}}s:30:"kartik-v/yii2-widget-fileinput";a:3:{s:4:"name";s:30:"kartik-v/yii2-widget-fileinput";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:12:"@kartik/file";s:79:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-fileinput/src";}}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.6.0";s:5:"alias";a:1:{s:15:"@kartik/depdrop";s:77:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-depdrop/src";}}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.5.1.0";s:5:"alias";a:1:{s:16:"@kartik/datetime";s:84:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-datetimepicker/src";}}s:31:"kartik-v/yii2-widget-datepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-datepicker";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:12:"@kartik/date";s:80:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-datepicker/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.6.0";s:5:"alias";a:1:{s:13:"@kartik/color";s:80:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-colorinput/src";}}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.5.0";s:5:"alias";a:1:{s:13:"@kartik/alert";s:75:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widget-alert/src";}}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:71:"/var/www/html/satusehat-rsaws-staging/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:10:"dev-master";s:5:"alias";a:1:{s:15:"@kartik/widgets";s:70:"/var/www/html/satusehat-rsaws-staging/vendor/kartik-v/yii2-widgets/src";}}s:21:"kongoon/yii2-orgchart";a:3:{s:4:"name";s:21:"kongoon/yii2-orgchart";s:7:"version";s:7:"0.0.2.0";s:5:"alias";a:1:{s:17:"@kongoon/orgchart";s:66:"/var/www/html/satusehat-rsaws-staging/vendor/kongoon/yii2-orgchart";}}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:61:"/var/www/html/satusehat-rsaws-staging/vendor/yiisoft/yii2-jui";}}s:18:"mdmsoft/yii2-admin";a:3:{s:4:"name";s:18:"mdmsoft/yii2-admin";s:7:"version";s:8:"2.12.0.0";s:5:"alias";a:1:{s:10:"@mdm/admin";s:63:"/var/www/html/satusehat-rsaws-staging/vendor/mdmsoft/yii2-admin";}}s:25:"pheme/yii2-jui-timepicker";a:3:{s:4:"name";s:25:"pheme/yii2-jui-timepicker";s:7:"version";s:7:"1.0.0.0";s:5:"alias";a:1:{s:10:"@pheme/jui";s:70:"/var/www/html/satusehat-rsaws-staging/vendor/pheme/yii2-jui-timepicker";}}s:32:"vilochane/yii2-barcode-generator";a:3:{s:4:"name";s:32:"vilochane/yii2-barcode-generator";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:16:"@barcode/barcode";s:77:"/var/www/html/satusehat-rsaws-staging/vendor/vilochane/yii2-barcode-generator";}}s:17:"yii2tech/csv-grid";a:3:{s:4:"name";s:17:"yii2tech/csv-grid";s:7:"version";s:7:"1.0.5.0";s:5:"alias";a:1:{s:17:"@yii2tech/csvgrid";s:66:"/var/www/html/satusehat-rsaws-staging/vendor/yii2tech/csv-grid/src";}}s:20:"yiidoc/yii2-redactor";a:3:{s:4:"name";s:20:"yiidoc/yii2-redactor";s:7:"version";s:7:"2.0.1.0";s:5:"alias";a:1:{s:13:"@yii/redactor";s:1:"/";}}s:23:"yiisoft/yii2-bootstrap4";a:3:{s:4:"name";s:23:"yiisoft/yii2-bootstrap4";s:7:"version";s:8:"2.0.10.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap4";s:72:"/var/www/html/satusehat-rsaws-staging/vendor/yiisoft/yii2-bootstrap4/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.22.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:67:"/var/www/html/satusehat-rsaws-staging/vendor/yiisoft/yii2-debug/src";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:67:"/var/www/html/satusehat-rsaws-staging/vendor/yiisoft/yii2-faker/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.1.4.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:65:"/var/www/html/satusehat-rsaws-staging/vendor/yiisoft/yii2-gii/src";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.1.3.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:73:"/var/www/html/satusehat-rsaws-staging/vendor/yiisoft/yii2-swiftmailer/src";}}s:20:"yiisoft/yii2-imagine";a:3:{s:4:"name";s:20:"yiisoft/yii2-imagine";s:7:"version";s:7:"2.2.0.0";s:5:"alias";a:1:{s:12:"@yii/imagine";s:69:"/var/www/html/satusehat-rsaws-staging/vendor/yiisoft/yii2-imagine/src";}}s:23:"yiisoft/yii2-httpclient";a:3:{s:4:"name";s:23:"yiisoft/yii2-httpclient";s:7:"version";s:8:"2.0.15.0";s:5:"alias";a:1:{s:15:"@yii/httpclient";s:72:"/var/www/html/satusehat-rsaws-staging/vendor/yiisoft/yii2-httpclient/src";}}}}";s:3:"log";s:7132:"a:1:{s:8:"messages";a:14:{i:0;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:1745129839.151601;i:4;a:0:{}i:5;i:959488;}i:1;a:6:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1745129839.151626;i:4;a:0:{}i:5;i:960664;}i:2;a:6:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1745129839.152275;i:4;a:0:{}i:5;i:1134600;}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:1745129839.15248;i:4;a:0:{}i:5;i:1217264;}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:1745129839.152675;i:4;a:0:{}i:5;i:1249192;}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:1745129839.152704;i:4;a:0:{}i:5;i:1254720;}i:13;a:6:{i:0;s:47:"Route requested: 'action-dynamic/gen-instalasi'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1745129839.152888;i:4;a:0:{}i:5;i:1351016;}i:14;a:6:{i:0;s:42:"Route to run: action-dynamic/gen-instalasi";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1745129839.152977;i:4;a:0:{}i:5;i:1368384;}i:15;a:6:{i:0;s:81:"Running action: backend\controllers\ActionDynamicController::actionGenInstalasi()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1745129839.153118;i:4;a:0:{}i:5;i:1382568;}i:16;a:6:{i:0;s:82:"Opening DB connection: pgsql:host=192.168.15.27;port=5432;dbname=db_rsaws_simulasi";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1745129839.153555;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1730192;}i:19;a:6:{i:0;s:373:"SELECT "i"."instalasi_id", "i"."instalasi_nama" FROM "loginpemakai_k" "t" JOIN "ruanganpemakai_k" "rp" ON rp.loginpemakai_id=t.loginpemakai_id JOIN "ruangan_m" "r" ON r.ruangan_id=rp.ruangan_id JOIN "instalasi_m" "i" ON i.instalasi_id=r.instalasi_id WHERE "t"."nama_pemakai" ILIKE '%sysadmin%' GROUP BY "i"."instalasi_id", "i"."instalasi_nama" ORDER BY "i"."instalasi_nama"";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.176208;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1732656;}i:22;a:6:{i:0;s:2820:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'loginpemakai_k'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.187379;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1753152;}i:25;a:6:{i:0;s:882:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='loginpemakai_k'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.195272;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1778528;}i:28;a:6:{i:0;s:100:"Access to debugger is denied due to IP address restriction. The requesting IP address is 10.16.1.113";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1745129839.201321;i:4;a:0:{}i:5;i:1865536;}}}";s:9:"profiling";s:11018:"a:3:{s:6:"memory";i:1865536;s:4:"time";d:0.058055877685546875;s:8:"messages";a:8:{i:17;a:6:{i:0;s:82:"Opening DB connection: pgsql:host=192.168.15.27;port=5432;dbname=db_rsaws_simulasi";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1745129839.153568;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1731960;}i:18;a:6:{i:0;s:82:"Opening DB connection: pgsql:host=192.168.15.27;port=5432;dbname=db_rsaws_simulasi";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1745129839.176183;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1733976;}i:20;a:6:{i:0;s:373:"SELECT "i"."instalasi_id", "i"."instalasi_nama" FROM "loginpemakai_k" "t" JOIN "ruanganpemakai_k" "rp" ON rp.loginpemakai_id=t.loginpemakai_id JOIN "ruangan_m" "r" ON r.ruangan_id=rp.ruangan_id JOIN "instalasi_m" "i" ON i.instalasi_id=r.instalasi_id WHERE "t"."nama_pemakai" ILIKE '%sysadmin%' GROUP BY "i"."instalasi_id", "i"."instalasi_nama" ORDER BY "i"."instalasi_nama"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.176236;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1736248;}i:21;a:6:{i:0;s:373:"SELECT "i"."instalasi_id", "i"."instalasi_nama" FROM "loginpemakai_k" "t" JOIN "ruanganpemakai_k" "rp" ON rp.loginpemakai_id=t.loginpemakai_id JOIN "ruangan_m" "r" ON r.ruangan_id=rp.ruangan_id JOIN "instalasi_m" "i" ON i.instalasi_id=r.instalasi_id WHERE "t"."nama_pemakai" ILIKE '%sysadmin%' GROUP BY "i"."instalasi_id", "i"."instalasi_nama" ORDER BY "i"."instalasi_nama"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.187182;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1747632;}i:23;a:6:{i:0;s:2820:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'loginpemakai_k'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.187404;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1763856;}i:24;a:6:{i:0;s:2820:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'loginpemakai_k'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.194829;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1812112;}i:26;a:6:{i:0;s:882:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='loginpemakai_k'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.195304;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1782832;}i:27;a:6:{i:0;s:882:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='loginpemakai_k'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.200915;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1787656;}}}";s:2:"db";s:10141:"a:1:{s:8:"messages";a:6:{i:20;a:6:{i:0;s:373:"SELECT "i"."instalasi_id", "i"."instalasi_nama" FROM "loginpemakai_k" "t" JOIN "ruanganpemakai_k" "rp" ON rp.loginpemakai_id=t.loginpemakai_id JOIN "ruangan_m" "r" ON r.ruangan_id=rp.ruangan_id JOIN "instalasi_m" "i" ON i.instalasi_id=r.instalasi_id WHERE "t"."nama_pemakai" ILIKE '%sysadmin%' GROUP BY "i"."instalasi_id", "i"."instalasi_nama" ORDER BY "i"."instalasi_nama"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.176236;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1736248;}i:21;a:6:{i:0;s:373:"SELECT "i"."instalasi_id", "i"."instalasi_nama" FROM "loginpemakai_k" "t" JOIN "ruanganpemakai_k" "rp" ON rp.loginpemakai_id=t.loginpemakai_id JOIN "ruangan_m" "r" ON r.ruangan_id=rp.ruangan_id JOIN "instalasi_m" "i" ON i.instalasi_id=r.instalasi_id WHERE "t"."nama_pemakai" ILIKE '%sysadmin%' GROUP BY "i"."instalasi_id", "i"."instalasi_nama" ORDER BY "i"."instalasi_nama"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.187182;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1747632;}i:23;a:6:{i:0;s:2820:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'loginpemakai_k'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.187404;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1763856;}i:24;a:6:{i:0;s:2820:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'loginpemakai_k'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.194829;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1812112;}i:26;a:6:{i:0;s:882:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='loginpemakai_k'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.195304;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1782832;}i:27;a:6:{i:0;s:882:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='loginpemakai_k'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1745129839.200915;i:4;a:1:{i:0;a:5:{s:4:"file";s:85:"/var/www/html/satusehat-rsaws-staging/backend/controllers/ActionDynamicController.php";s:4:"line";i:45;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:1787656;}}}";s:5:"event";s:1972:"a:11:{i:0;a:5:{s:4:"time";d:1745129839.152795;s:4:"name";s:13:"beforeRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:1;a:5:{s:4:"time";d:1745129839.152998;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:2;a:5:{s:4:"time";d:1745129839.153006;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:43:"backend\controllers\ActionDynamicController";}i:3;a:5:{s:4:"time";d:1745129839.153276;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:4;a:5:{s:4:"time";d:1745129839.176177;s:4:"name";s:9:"afterOpen";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:5;a:5:{s:4:"time";d:1745129839.201108;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:43:"backend\controllers\ActionDynamicController";}i:6;a:5:{s:4:"time";d:1745129839.20112;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:7;a:5:{s:4:"time";d:1745129839.201127;s:4:"name";s:12:"afterRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:8;a:5:{s:4:"time";d:1745129839.201135;s:4:"name";s:10:"beforeSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:9;a:5:{s:4:"time";d:1745129839.201332;s:4:"name";s:12:"afterPrepare";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:10;a:5:{s:4:"time";d:1745129839.201361;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:91:"a:3:{s:5:"start";d:1745129839.143826;s:3:"end";d:1745129839.201941;s:6:"memory";i:1865536;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:1463:"a:3:{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:1745129839.152855;i:4;a:0:{}i:5;i:1346800;}i:7;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/<id:\w+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1745129839.152863;i:4;a:0:{}i:5;i:1347552;}i:8;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1745129839.152868;i:4;a:0:{}i:5;i:1348304;}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:1745129839.152872;i:4;a:0:{}i:5;i:1349376;}i:10;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1745129839.152876;i:4;a:0:{}i:5;i:1350128;}i:11;a:6:{i:0;a:3:{s:4:"rule";s:1:"/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1745129839.152879;i:4;a:0:{}i:5;i:1350880;}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:1745129839.152881;i:4;a:0:{}i:5;i:1351256;}}s:5:"route";s:28:"action-dynamic/gen-instalasi";s:6:"action";s:65:"backend\controllers\ActionDynamicController::actionGenInstalasi()";}";s:7:"request";s:4576:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:13:{s:4:"host";s:13:"192.168.15.27";s:10:"connection";s:10:"keep-alive";s:14:"content-length";s:2:"11";s:12:"x-csrf-token";s:88:"BCE5a8nj5AZ9AAvMHeS96If9IGwhzP_R7KKuwYwsmNd2SlUisYKcRApEZvpS1OWl4c9sHU2nyOap7PSKtW-stA==";s:16:"x-requested-with";s:14:"XMLHttpRequest";s:10:"user-agent";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36";s:6:"accept";s:46:"application/json, text/javascript, */*; q=0.01";s:12:"content-type";s:48:"application/x-www-form-urlencoded; charset=UTF-8";s:6:"origin";s:20:"http://192.168.15.27";s:7:"referer";s:67:"http://192.168.15.27/satusehat-rsaws-staging/backend/web/index.php/";s:15:"accept-encoding";s:13:"gzip, deflate";s:15:"accept-language";s:14:"en-US,en;q=0.9";s:6:"cookie";s:234:"advanced-backend=hk8n6gafrfa0u7v0iolsunjb1i; _csrf-backend=bf7418702f367c470075c884381ecba80f6220ab51d7b486465bbbe04c87a358a%3A2%3A%7Bi%3A0%3Bs%3A13%3A%22_csrf-backend%22%3Bi%3A1%3Bs%3A32%3A%22rklIxaxBwDm6O0XMf2Lqlk77ENZK9C4c%22%3B%7D";}s:15:"responseHeaders";a:4:{s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:35:"no-store, no-cache, must-revalidate";s:6:"Pragma";s:8:"no-cache";s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:28:"action-dynamic/gen-instalasi";s:6:"action";s:65:"backend\controllers\ActionDynamicController::actionGenInstalasi()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:4:"POST";s:6:"isAjax";b:1;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:0;}s:11:"requestBody";a:3:{s:12:"Content Type";s:48:"application/x-www-form-urlencoded; charset=UTF-8";s:3:"Raw";s:11:"id=sysadmin";s:7:"Decoded";a:1:{s:2:"id";s:8:"sysadmin";}}s:6:"SERVER";a:38:{s:9:"HTTP_HOST";s:13:"192.168.15.27";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:14:"CONTENT_LENGTH";s:2:"11";s:17:"HTTP_X_CSRF_TOKEN";s:88:"BCE5a8nj5AZ9AAvMHeS96If9IGwhzP_R7KKuwYwsmNd2SlUisYKcRApEZvpS1OWl4c9sHU2nyOap7PSKtW-stA==";s:21:"HTTP_X_REQUESTED_WITH";s:14:"XMLHttpRequest";s:15:"HTTP_USER_AGENT";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36";s:11:"HTTP_ACCEPT";s:46:"application/json, text/javascript, */*; q=0.01";s:12:"CONTENT_TYPE";s:48:"application/x-www-form-urlencoded; charset=UTF-8";s:11:"HTTP_ORIGIN";s:20:"http://192.168.15.27";s:12:"HTTP_REFERER";s:67:"http://192.168.15.27/satusehat-rsaws-staging/backend/web/index.php/";s:20:"HTTP_ACCEPT_ENCODING";s:13:"gzip, deflate";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"en-US,en;q=0.9";s:11:"HTTP_COOKIE";s:234:"advanced-backend=hk8n6gafrfa0u7v0iolsunjb1i; _csrf-backend=bf7418702f367c470075c884381ecba80f6220ab51d7b486465bbbe04c87a358a%3A2%3A%7Bi%3A0%3Bs%3A13%3A%22_csrf-backend%22%3Bi%3A1%3Bs%3A32%3A%22rklIxaxBwDm6O0XMf2Lqlk77ENZK9C4c%22%3B%7D";s:4:"PATH";s:70:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin";s:16:"SERVER_SIGNATURE";s:74:"<address>Apache/2.4.52 (Ubuntu) Server at 192.168.15.27 Port 80</address>
";s:15:"SERVER_SOFTWARE";s:22:"Apache/2.4.52 (Ubuntu)";s:11:"SERVER_NAME";s:13:"192.168.15.27";s:11:"SERVER_ADDR";s:13:"192.168.15.27";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:11:"10.16.1.113";s:13:"DOCUMENT_ROOT";s:13:"/var/www/html";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:13:"/var/www/html";s:12:"SERVER_ADMIN";s:19:"webmaster@localhost";s:15:"SCRIPT_FILENAME";s:59:"/var/www/html/satusehat-rsaws-staging/backend/web/index.php";s:11:"REMOTE_PORT";s:5:"64893";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:4:"POST";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:75:"/satusehat-rsaws-staging/backend/web/index.php/action-dynamic/gen-instalasi";s:11:"SCRIPT_NAME";s:46:"/satusehat-rsaws-staging/backend/web/index.php";s:9:"PATH_INFO";s:29:"/action-dynamic/gen-instalasi";s:15:"PATH_TRANSLATED";s:42:"/var/www/html/action-dynamic/gen-instalasi";s:8:"PHP_SELF";s:75:"/satusehat-rsaws-staging/backend/web/index.php/action-dynamic/gen-instalasi";s:18:"REQUEST_TIME_FLOAT";d:1745129839.143095;s:12:"REQUEST_TIME";i:1745129839;}s:3:"GET";a:0:{}s:4:"POST";a:1:{s:2:"id";s:8:"sysadmin";}s:6:"COOKIE";a:2:{s:16:"advanced-backend";s:26:"hk8n6gafrfa0u7v0iolsunjb1i";s:13:"_csrf-backend";s:139:"bf7418702f367c470075c884381ecba80f6220ab51d7b486465bbbe04c87a358a:2:{i:0;s:13:"_csrf-backend";i:1;s:32:"rklIxaxBwDm6O0XMf2Lqlk77ENZK9C4c";}";}s:5:"FILES";a:0:{}s:7:"SESSION";a:1:{s:7:"__flash";a:0:{}}}";s:4:"user";s:2:"N;";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:12:{s:3:"tag";s:13:"6804916f253b9";s:3:"url";s:95:"http://192.168.15.27/satusehat-rsaws-staging/backend/web/index.php/action-dynamic/gen-instalasi";s:4:"ajax";i:1;s:6:"method";s:4:"POST";s:2:"ip";s:11:"10.16.1.113";s:4:"time";d:1745129839.143095;s:10:"statusCode";i:200;s:8:"sqlCount";i:3;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1865536;s:14:"processingTime";d:0.058055877685546875;}s:10:"exceptions";a:0:{}}