a:14:{s:6:"config";s:1451:"a:5:{s:10:"phpVersion";s:6:"8.0.30";s:10:"yiiVersion";s:6:"2.0.52";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.52";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:5:{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:60:"/var/www/html/api-hl7-ilab/vendor/yiisoft/yii2-bootstrap/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.26.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:56:"/var/www/html/api-hl7-ilab/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:56:"/var/www/html/api-hl7-ilab/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:54:"/var/www/html/api-hl7-ilab/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:62:"/var/www/html/api-hl7-ilab/vendor/yiisoft/yii2-swiftmailer/src";}}}}";s:3:"log";s:22145:"a:1:{s:8:"messages";a:24:{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:1789460717.608449;i:4;a:0:{}i:5;i:874224;}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:1789460717.608476;i:4;a:0:{}i:5;i:875400;}i:2;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:1789460717.609363;i:4;a:0:{}i:5;i:1134608;}i:3;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1789460717.609488;i:4;a:0:{}i:5;i:1148648;}i:4;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:1789460717.609548;i:4;a:0:{}i:5;i:1154208;}i:6;a:6:{i:0;s:32:"Route requested: 'order/addilab'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1789460717.609683;i:4;a:0:{}i:5;i:1163320;}i:7;a:6:{i:0;s:27:"Route to run: order/addilab";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1789460717.60987;i:4;a:0:{}i:5;i:1180640;}i:8;a:6:{i:0;s:68:"Running action: backend\controllers\OrderController::actionAddilab()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1789460717.609943;i:4;a:0:{}i:5;i:1251760;}i:9;a:6:{i:0;s:80:"Opening DB connection: pgsql:host=10.10.172.231;port=5234;dbname=db_ilab_running";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1789460717.610537;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1434872;}i:12;a:6:{i:0;s:2819:"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 = 'paramsistem_k'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.629625;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1518120;}i:15;a:6:{i:0;s:881:"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='paramsistem_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:1789460717.651594;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1544552;}i:18;a:6:{i:0;s:42:"SELECT * FROM "paramsistem_k" WHERE "id"=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.660988;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1574856;}i:21;a:6:{i:0;s:50:"SELECT * FROM "ruangan_m" WHERE "kode_bridging"=''";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.663352;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:108;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1597072;}i:24;a:6:{i:0;s:56:"SELECT * FROM "pasien_m" WHERE "no_rekam_medik"='015720'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.666681;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1617952;}i:27;a:6:{i:0;s:2814:"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 = 'pasien_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.671868;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1641672;}i:30;a:6:{i:0;s:876:"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='pasien_m'
    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:1789460717.697938;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1697160;}i:33;a:6:{i:0;s:142:"SELECT kelompokumur_id, kelompokumur_nama FROM kelompokumur_m 
                WHERE 12 BETWEEN kelompokumur_minimal AND kelompokumur_maksimal";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.707011;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:322;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:129;s:8:"function";s:15:"getKelompokUmur";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1809848;}i:36;a:6:{i:0;s:96:"SELECT "pasien_m"."pasien_id" FROM "pasien_m" WHERE "pasien_m"."no_rekam_medik"='015720' LIMIT 2";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.710726;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:138;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:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1886648;}i:39;a:6:{i:0;s:85:"UPDATE "pasien_m" SET "tgl_rekam_medik"='2026-09-15 15:25:17' WHERE "pasien_id"=15353";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1789460717.712758;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:138;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:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1879224;}i:42;a:6:{i:0;s:67:"SELECT * FROM "pendaftaran_t" WHERE "no_pendaftaran"='RJ2509260001'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.721256;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:141;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1900016;}i:45;a:6:{i:0;s:2819:"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 = 'pendaftaran_t'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.725864;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:145;s:8:"function";s:7:"__isset";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1909096;}i:48;a:6:{i:0;s:881:"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='pendaftaran_t'
    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:1789460717.758514;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:145;s:8:"function";s:7:"__isset";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1975032;}i:51;a:6:{i:0;s:1111:"yii\base\ErrorException: Attempt to read property "ruangan_nama" on null in /var/www/html/api-hl7-ilab/backend/controllers/OrderController.php:153
Stack trace:
#0 /var/www/html/api-hl7-ilab/backend/controllers/OrderController.php(153): yii\base\ErrorHandler->handleError()
#1 /var/www/html/api-hl7-ilab/backend/controllers/OrderController.php(51): backend\controllers\OrderController->addPatientlab()
#2 [internal function]: backend\controllers\OrderController->actionAddilab()
#3 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#4 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
#5 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction()
#6 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction()
#7 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest()
#8 /var/www/html/api-hl7-ilab/backend/web/index.php(17): yii\base\Application->run()
#9 {main}";i:1;i:1;i:2;s:25:"yii\base\ErrorException:2";i:3;d:1789460717.767103;i:4;a:0:{}i:5;i:1685768;}i:52;a:6:{i:0;s:101:"Access to debugger is denied due to IP address restriction. The requesting IP address is 10.10.172.25";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1789460717.76941;i:4;a:0:{}i:5;i:1836656;}}}";s:9:"profiling";s:38950:"a:3:{s:6:"memory";i:2139688;s:4:"time";d:0.16560101509094238;s:8:"messages";a:28:{i:10;a:6:{i:0;s:80:"Opening DB connection: pgsql:host=10.10.172.231;port=5234;dbname=db_ilab_running";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1789460717.610564;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1436376;}i:11;a:6:{i:0;s:80:"Opening DB connection: pgsql:host=10.10.172.231;port=5234;dbname=db_ilab_running";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1789460717.629459;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1438760;}i:13;a:6:{i:0;s:2819:"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 = 'paramsistem_k'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.629684;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1529288;}i:14;a:6:{i:0;s:2819:"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 = 'paramsistem_k'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.650791;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1569656;}i:16;a:6:{i:0;s:881:"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='paramsistem_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:1789460717.651639;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1549232;}i:17;a:6:{i:0;s:881:"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='paramsistem_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:1789460717.660252;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1551816;}i:19;a:6:{i:0;s:42:"SELECT * FROM "paramsistem_k" WHERE "id"=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.661063;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1577696;}i:20;a:6:{i:0;s:42:"SELECT * FROM "paramsistem_k" WHERE "id"=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.662583;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1582736;}i:22;a:6:{i:0;s:50:"SELECT * FROM "ruangan_m" WHERE "kode_bridging"=''";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.663391;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:108;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1599928;}i:23;a:6:{i:0;s:50:"SELECT * FROM "ruangan_m" WHERE "kode_bridging"=''";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.666021;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:108;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1604176;}i:25;a:6:{i:0;s:56:"SELECT * FROM "pasien_m" WHERE "no_rekam_medik"='015720'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.66672;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1620808;}i:26;a:6:{i:0;s:56:"SELECT * FROM "pasien_m" WHERE "no_rekam_medik"='015720'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.67135;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1638072;}i:28;a:6:{i:0;s:2814:"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 = 'pasien_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.671926;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1652752;}i:29;a:6:{i:0;s:2814:"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 = 'pasien_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.696737;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1805152;}i:31;a:6:{i:0;s:876:"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='pasien_m'
    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:1789460717.697985;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1701840;}i:32;a:6:{i:0;s:876:"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='pasien_m'
    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:1789460717.705785;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1715008;}i:34;a:6:{i:0;s:142:"SELECT kelompokumur_id, kelompokumur_nama FROM kelompokumur_m 
                WHERE 12 BETWEEN kelompokumur_minimal AND kelompokumur_maksimal";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.707085;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:322;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:129;s:8:"function";s:15:"getKelompokUmur";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1813656;}i:35;a:6:{i:0;s:142:"SELECT kelompokumur_id, kelompokumur_nama FROM kelompokumur_m 
                WHERE 12 BETWEEN kelompokumur_minimal AND kelompokumur_maksimal";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.708637;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:322;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:129;s:8:"function";s:15:"getKelompokUmur";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1816144;}i:37;a:6:{i:0;s:96:"SELECT "pasien_m"."pasien_id" FROM "pasien_m" WHERE "pasien_m"."no_rekam_medik"='015720' LIMIT 2";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.710771;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:138;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:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1889632;}i:38;a:6:{i:0;s:96:"SELECT "pasien_m"."pasien_id" FROM "pasien_m" WHERE "pasien_m"."no_rekam_medik"='015720' LIMIT 2";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.712055;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:138;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:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1892000;}i:40;a:6:{i:0;s:85:"UPDATE "pasien_m" SET "tgl_rekam_medik"='2026-09-15 15:25:17' WHERE "pasien_id"=15353";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1789460717.712798;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:138;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:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1881928;}i:41;a:6:{i:0;s:85:"UPDATE "pasien_m" SET "tgl_rekam_medik"='2026-09-15 15:25:17' WHERE "pasien_id"=15353";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1789460717.720466;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:138;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:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1883560;}i:43;a:6:{i:0;s:67:"SELECT * FROM "pendaftaran_t" WHERE "no_pendaftaran"='RJ2509260001'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.721312;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:141;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1902904;}i:44;a:6:{i:0;s:67:"SELECT * FROM "pendaftaran_t" WHERE "no_pendaftaran"='RJ2509260001'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.725307;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:141;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1913360;}i:46;a:6:{i:0;s:2819:"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 = 'pendaftaran_t'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.725962;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:145;s:8:"function";s:7:"__isset";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1920176;}i:47;a:6:{i:0;s:2819:"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 = 'pendaftaran_t'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.757141;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:145;s:8:"function";s:7:"__isset";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:2107416;}i:49;a:6:{i:0;s:881:"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='pendaftaran_t'
    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:1789460717.758561;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:145;s:8:"function";s:7:"__isset";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1979712;}i:50;a:6:{i:0;s:881:"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='pendaftaran_t'
    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:1789460717.766394;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:145;s:8:"function";s:7:"__isset";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1993616;}}}";s:2:"db";s:37652:"a:1:{s:8:"messages";a:26:{i:13;a:6:{i:0;s:2819:"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 = 'paramsistem_k'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.629684;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1529288;}i:14;a:6:{i:0;s:2819:"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 = 'paramsistem_k'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.650791;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1569656;}i:16;a:6:{i:0;s:881:"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='paramsistem_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:1789460717.651639;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1549232;}i:17;a:6:{i:0;s:881:"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='paramsistem_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:1789460717.660252;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1551816;}i:19;a:6:{i:0;s:42:"SELECT * FROM "paramsistem_k" WHERE "id"=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.661063;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1577696;}i:20;a:6:{i:0;s:42:"SELECT * FROM "paramsistem_k" WHERE "id"=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.662583;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:105;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1582736;}i:22;a:6:{i:0;s:50:"SELECT * FROM "ruangan_m" WHERE "kode_bridging"=''";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.663391;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:108;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1599928;}i:23;a:6:{i:0;s:50:"SELECT * FROM "ruangan_m" WHERE "kode_bridging"=''";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.666021;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:108;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1604176;}i:25;a:6:{i:0;s:56:"SELECT * FROM "pasien_m" WHERE "no_rekam_medik"='015720'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.66672;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1620808;}i:26;a:6:{i:0;s:56:"SELECT * FROM "pasien_m" WHERE "no_rekam_medik"='015720'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.67135;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1638072;}i:28;a:6:{i:0;s:2814:"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 = 'pasien_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.671926;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1652752;}i:29;a:6:{i:0;s:2814:"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 = 'pasien_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.696737;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1805152;}i:31;a:6:{i:0;s:876:"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='pasien_m'
    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:1789460717.697985;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1701840;}i:32;a:6:{i:0;s:876:"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='pasien_m'
    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:1789460717.705785;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:115;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1715008;}i:34;a:6:{i:0;s:142:"SELECT kelompokumur_id, kelompokumur_nama FROM kelompokumur_m 
                WHERE 12 BETWEEN kelompokumur_minimal AND kelompokumur_maksimal";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.707085;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:322;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:129;s:8:"function";s:15:"getKelompokUmur";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1813656;}i:35;a:6:{i:0;s:142:"SELECT kelompokumur_id, kelompokumur_nama FROM kelompokumur_m 
                WHERE 12 BETWEEN kelompokumur_minimal AND kelompokumur_maksimal";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.708637;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:322;s:8:"function";s:8:"queryOne";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:129;s:8:"function";s:15:"getKelompokUmur";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1816144;}i:37;a:6:{i:0;s:96:"SELECT "pasien_m"."pasien_id" FROM "pasien_m" WHERE "pasien_m"."no_rekam_medik"='015720' LIMIT 2";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.710771;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:138;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:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1889632;}i:38;a:6:{i:0;s:96:"SELECT "pasien_m"."pasien_id" FROM "pasien_m" WHERE "pasien_m"."no_rekam_medik"='015720' LIMIT 2";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.712055;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:138;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:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1892000;}i:40;a:6:{i:0;s:85:"UPDATE "pasien_m" SET "tgl_rekam_medik"='2026-09-15 15:25:17' WHERE "pasien_id"=15353";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1789460717.712798;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:138;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:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1881928;}i:41;a:6:{i:0;s:85:"UPDATE "pasien_m" SET "tgl_rekam_medik"='2026-09-15 15:25:17' WHERE "pasien_id"=15353";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1789460717.720466;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:138;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:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1883560;}i:43;a:6:{i:0;s:67:"SELECT * FROM "pendaftaran_t" WHERE "no_pendaftaran"='RJ2509260001'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.721312;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:141;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1902904;}i:44;a:6:{i:0;s:67:"SELECT * FROM "pendaftaran_t" WHERE "no_pendaftaran"='RJ2509260001'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.725307;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:141;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1913360;}i:46;a:6:{i:0;s:2819:"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 = 'pendaftaran_t'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.725962;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:145;s:8:"function";s:7:"__isset";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1920176;}i:47;a:6:{i:0;s:2819:"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 = 'pendaftaran_t'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1789460717.757141;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:145;s:8:"function";s:7:"__isset";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:2107416;}i:49;a:6:{i:0;s:881:"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='pendaftaran_t'
    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:1789460717.758561;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:145;s:8:"function";s:7:"__isset";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1979712;}i:50;a:6:{i:0;s:881:"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='pendaftaran_t'
    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:1789460717.766394;i:4;a:2:{i:0;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:145;s:8:"function";s:7:"__isset";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:66:"/var/www/html/api-hl7-ilab/backend/controllers/OrderController.php";s:4:"line";i:51;s:8:"function";s:13:"addPatientlab";s:5:"class";s:35:"backend\controllers\OrderController";s:4:"type";s:2:"->";}}i:5;i:1993616;}}}";s:5:"event";s:4002:"a:23:{i:0;a:5:{s:4:"time";d:1789460717.609647;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:1789460717.609916;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:1789460717.609934;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:35:"backend\controllers\OrderController";}i:3;a:5:{s:4:"time";d:1789460717.61035;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:1789460717.629445;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:1789460717.663013;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"common\models\ParamsistemK";}i:6;a:5:{s:4:"time";d:1789460717.663123;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"common\models\ParamsistemK";}i:7;a:5:{s:4:"time";d:1789460717.663232;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:8;a:5:{s:4:"time";d:1789460717.666526;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\PasienM";}i:9;a:5:{s:4:"time";d:1789460717.666559;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:10;a:5:{s:4:"time";d:1789460717.671777;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\PasienM";}i:11;a:5:{s:4:"time";d:1789460717.706408;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\PasienM";}i:12;a:5:{s:4:"time";d:1789460717.709124;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\PasienM";}i:13;a:5:{s:4:"time";d:1789460717.710391;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:14;a:5:{s:4:"time";d:1789460717.710496;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:15;a:5:{s:4:"time";d:1789460717.712516;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\PasienM";}i:16;a:5:{s:4:"time";d:1789460717.712541;s:4:"name";s:12:"beforeUpdate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\PasienM";}i:17;a:5:{s:4:"time";d:1789460717.720929;s:4:"name";s:11:"afterUpdate";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\PasienM";}i:18;a:5:{s:4:"time";d:1789460717.721073;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:19;a:5:{s:4:"time";d:1789460717.725768;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"common\models\PendaftaranT";}i:20;a:5:{s:4:"time";d:1789460717.769158;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:21;a:5:{s:4:"time";d:1789460717.769439;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:22;a:5:{s:4:"time";d:1789460717.769991;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:90:"a:3:{s:5:"start";d:1789460717.607496;s:3:"end";d:1789460717.77342;s:6:"memory";i:2139688;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:311:"a:3:{s:8:"messages";a:1:{i:5;a:6:{i:0;s:56:"Pretty URL not enabled. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1789460717.609663;i:4;a:0:{}i:5;i:1163256;}}s:5:"route";s:13:"order/addilab";s:6:"action";s:52:"backend\controllers\OrderController::actionAddilab()";}";s:7:"request";s:4060:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:500;s:14:"requestHeaders";a:6:{s:4:"host";s:13:"10.10.172.231";s:6:"accept";s:3:"*/*";s:15:"accept-encoding";s:23:"deflate, gzip, br, zstd";s:12:"content-type";s:16:"application/json";s:13:"cache-control";s:8:"no-cache";s:14:"content-length";s:3:"758";}s:15:"responseHeaders";a:1:{s:12:"Content-Type";s:24:"text/html; charset=UTF-8";}s:5:"route";s:13:"order/addilab";s:6:"action";s:52:"backend\controllers\OrderController::actionAddilab()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:4:"POST";s:6:"isAjax";b:0;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:16:"application/json";s:3:"Raw";s:758:"{"data":{"nama_pasien":"AHMAD SIDIQ MUTAQIN","jeniskelamin":"M","no_rekam_medik":"015720","no_mobile_pasien":"08950378424","kecamatan_id":"1462","kabupaten_id":"94","propinsi_id":"9","no_pendaftaran":"RJ2509260001","agama":"ISLAM","warga_negara":"WNI","loginpemakai_id":"1070","tanggal_lahir":"2014-06-24","alamat_pasien":"Jl. Mawar Kav. Barokah RT 008 RW 014 Bahagia Babelan","pemeriksaanlab":[{"pemeriksaanlab_kode":"MCU-01","is_cyto":"no"}],"is_cyto":"no","instalasi_singkatan":"LB","kode_bridging":"","tgl_kirimpasien":"2026-09-15 15:25:17","carabayar_id":"2","penjamin_id":"7","pegawai_id":"106","kelaspelayanan_id":"6","ruangan_id":"433","ruangan_nama":"Poli Anak","jeniskasuspenyakit_id":"31","jeniskasuspenyakit_nama":"Laboratorium"},"command":"ADD"}";s:7:"Decoded";a:2:{s:4:"data";a:26:{s:11:"nama_pasien";s:19:"AHMAD SIDIQ MUTAQIN";s:12:"jeniskelamin";s:1:"M";s:14:"no_rekam_medik";s:6:"015720";s:16:"no_mobile_pasien";s:11:"08950378424";s:12:"kecamatan_id";s:4:"1462";s:12:"kabupaten_id";s:2:"94";s:11:"propinsi_id";s:1:"9";s:14:"no_pendaftaran";s:12:"RJ2509260001";s:5:"agama";s:5:"ISLAM";s:12:"warga_negara";s:3:"WNI";s:15:"loginpemakai_id";s:4:"1070";s:13:"tanggal_lahir";s:10:"2014-06-24";s:13:"alamat_pasien";s:52:"Jl. Mawar Kav. Barokah RT 008 RW 014 Bahagia Babelan";s:14:"pemeriksaanlab";a:1:{i:0;a:2:{s:19:"pemeriksaanlab_kode";s:6:"MCU-01";s:7:"is_cyto";s:2:"no";}}s:7:"is_cyto";s:2:"no";s:19:"instalasi_singkatan";s:2:"LB";s:13:"kode_bridging";s:0:"";s:15:"tgl_kirimpasien";s:19:"2026-09-15 15:25:17";s:12:"carabayar_id";s:1:"2";s:11:"penjamin_id";s:1:"7";s:10:"pegawai_id";s:3:"106";s:17:"kelaspelayanan_id";s:1:"6";s:10:"ruangan_id";s:3:"433";s:12:"ruangan_nama";s:9:"Poli Anak";s:21:"jeniskasuspenyakit_id";s:2:"31";s:23:"jeniskasuspenyakit_nama";s:12:"Laboratorium";}s:7:"command";s:3:"ADD";}}s:6:"SERVER";a:29:{s:9:"HTTP_HOST";s:13:"10.10.172.231";s:11:"HTTP_ACCEPT";s:3:"*/*";s:20:"HTTP_ACCEPT_ENCODING";s:23:"deflate, gzip, br, zstd";s:12:"CONTENT_TYPE";s:16:"application/json";s:18:"HTTP_CACHE_CONTROL";s:8:"no-cache";s:14:"CONTENT_LENGTH";s:3:"758";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 10.10.172.231 Port 80</address>
";s:15:"SERVER_SOFTWARE";s:22:"Apache/2.4.52 (Ubuntu)";s:11:"SERVER_NAME";s:13:"10.10.172.231";s:11:"SERVER_ADDR";s:13:"10.10.172.231";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:12:"10.10.172.25";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:48:"/var/www/html/api-hl7-ilab/backend/web/index.php";s:11:"REMOTE_PORT";s:5:"40348";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:15:"r=order/addilab";s:11:"REQUEST_URI";s:51:"/api-hl7-ilab/backend/web/index.php?r=order/addilab";s:11:"SCRIPT_NAME";s:35:"/api-hl7-ilab/backend/web/index.php";s:8:"PHP_SELF";s:35:"/api-hl7-ilab/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1789460717.606888;s:12:"REQUEST_TIME";i:1789460717;}s:3:"GET";a:1:{s:1:"r";s:13:"order/addilab";}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:4:"user";s:2:"N;";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6aa900ed94c94";s:3:"url";s:71:"http://10.10.172.231/api-hl7-ilab/backend/web/index.php?r=order/addilab";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"10.10.172.25";s:4:"time";d:1789460717.606888;s:10:"statusCode";i:500;s:8:"sqlCount";i:13;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2139688;s:14:"processingTime";d:0.16560101509094238;}s:10:"exceptions";a:0:{}}