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:48861:"a:1:{s:8:"messages";a:56:{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:1792570185.338979;i:4;a:0:{}i:5;i:878272;}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:1792570185.339041;i:4;a:0:{}i:5;i:879448;}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:1792570185.341;i:4;a:0:{}i:5;i:1138640;}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:1792570185.341254;i:4;a:0:{}i:5;i:1152680;}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:1792570185.341433;i:4;a:0:{}i:5;i:1158240;}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:1792570185.341797;i:4;a:0:{}i:5;i:1167352;}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:1792570185.342254;i:4;a:0:{}i:5;i:1184672;}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:1792570185.342375;i:4;a:0:{}i:5;i:1255792;}i:9;a:6:{i:0;s:77:"Opening DB connection: pgsql:host=10.10.172.3;port=5433;dbname=db_ilab_biolab";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1792570185.345045;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:66;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:1540144;}i:12;a:6:{i:0;s:69:"SELECT * FROM "pasienkirimkeunitlain_t" WHERE "no_sample"='326100001'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.39877;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:66;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:1542736;}i:15;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:1792570185.407185;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:1567248;}i:18;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:1792570185.468219;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:1591672;}i:21;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:1792570185.479637;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:1596104;}i:24;a:6:{i:0;s:53:"SELECT * FROM "ruangan_m" WHERE "kode_bridging"='LAB'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.520313;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:1618640;}i:27;a:6:{i:0;s:2815:"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 = 'ruangan_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.526636;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:1633992;}i:30;a:6:{i:0;s:877:"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='ruangan_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:1792570185.554025;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:1658200;}i:33;a:6:{i:0;s:58:"SELECT * FROM "pasien_m" WHERE "no_rekam_medik"='00112233'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.563269;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:1679824;}i:36;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:1792570185.571915;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:119;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s: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:1688304;}i:39;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:1792570185.620466;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:119;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s: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:1743792;}i:42;a:6:{i:0;s:142:"SELECT kelompokumur_id, kelompokumur_nama FROM kelompokumur_m 
                WHERE 27 BETWEEN kelompokumur_minimal AND kelompokumur_maksimal";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.631569;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:1849544;}i:45;a:6:{i:0;s:84:"SELECT EXISTS(SELECT * FROM "pasien_m" WHERE "pasien_m"."no_rekam_medik"='00112233')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.639042;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:1927024;}i:48;a:6:{i:0;s:801:"INSERT INTO "pasien_m" ("nama_pasien", "kecamatan_id", "kabupaten_id", "propinsi_id", "no_rekam_medik", "jeniskelamin", "tanggal_lahir", "tgl_rekam_medik", "kelompokumur_id", "create_time", "create_loginpemakai_id", "alamat_pasien", "agama", "warga_negara", "statusrekammedis", "ispasienluar", "pendidikan_id", "profilrs_id", "kelurahan_id", "loginpemakai_id", "suku_id", "pekerjaan_id", "dokrekammedis_id", "rt", "rw", "anakke", "jumlah_bersaudara", "update_loginpemakai_id", "create_ruangan", "pegawai_id") VALUES ('RAIN LECLERC', 999999, 999999, 999999, '00112233', 'LAKI-LAKI', '1999-10-05', '2026-10-21 15:09:45', 3, '2026-10-21 15:09:45', 1, 'ALAMAT PASIEN', 'ISLAM', 'WNI', 'AKTIF', TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pasien_id"";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.643941;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:1937168;}i:51;a:6:{i:0;s:69:"SELECT * FROM "pendaftaran_t" WHERE "no_pendaftaran"='LB202610200001'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.714535;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:1942672;}i:54;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:1792570185.722706;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:1951752;}i:57;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:1792570185.802983;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:2018600;}i:60;a:6:{i:0;s:138:"SELECT golonganumur_id, golonganumur_nama FROM golonganumur_m 
            WHERE 27 BETWEEN golonganumur_minimal AND golonganumur_maksimal";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.813607;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:463;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:162;s:8:"function";s:15:"getGolonganUmur";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:2034392;}i:63;a:6:{i:0;s:47:"SELECT * FROM "ruangan_m" WHERE "ruangan_id"=53";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.8183;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:398;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:167;s:8:"function";s:9:"noAntrian";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:2041720;}i:66;a:6:{i:0;s:164:"SELECT MAX(no_urutantri) AS nomaksimal
                 FROM pendaftaran_t 
                 WHERE DATE(tgl_pendaftaran) = '2026-10-21 15:09:45' AND ruangan_id = 53";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.82257;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:410;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:167;s:8:"function";s:9:"noAntrian";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:2055768;}i:69;a:6:{i:0;s:179:"SELECT MAX(no_antrianjanji) AS nomaksimal
                      FROM buatjanjipoli_t 
                      WHERE DATE(tgljadwal) = '2026-10-21 15:09:45'::date AND ruangan_id = 53";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.827827;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:418;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:167;s:8:"function";s:9:"noAntrian";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:2062080;}i:72;a:6:{i:0;s:50:"SELECT * FROM "carabayar_m" WHERE "carabayar_id"=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.833631;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:171;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:2078744;}i:75;a:6:{i:0;s:2817:"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 = 'carabayar_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.838757;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:171;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:2091160;}i:78;a:6:{i:0;s:879:"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='carabayar_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:1792570185.854266;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:171;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:2104280;}i:81;a:6:{i:0;s:100:"SELECT EXISTS(SELECT * FROM "pendaftaran_t" WHERE "pendaftaran_t"."no_pendaftaran"='LB202610200001')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.864875;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:176;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:2140976;}i:84;a:6:{i:0;s:1464:"INSERT INTO "pendaftaran_t" ("statuspasien", "no_pendaftaran", "tgl_pendaftaran", "create_time", "kunjungan", "ruangan_id", "statusmasuk", "panggilantrian", "penjamin_id", "kelaspelayanan_id", "pasien_id", "create_loginpemakai_id", "kelompokumur_id", "golonganumur_id", "statusperiksa", "pegawai_id", "no_urutantri", "umur", "carabayar_id", "pasienpulang_id", "pasienbatalperiksa_id", "penanggungjawab_id", "shift_id", "persalinan_id", "instalasi_id", "caramasuk_id", "pengirimanrm_id", "peminjamanrm_id", "jeniskasuspenyakit_id", "pembayaranpelayanan_id", "pasienadmisi_id", "rujukan_id", "antrian_id", "karcis_id", "update_loginpemakai_id", "create_ruangan", "asuransipasien_id", "sep_id", "ruangankontrol_id", "jml_panggil", "tat_pelayanan_pasien", "kamarruangan_id", "jadwalhemodialisa_id", "ppjp_id", "skp_id", "nursestation_id", "jml_panggildokter", "doktertujuankontrol_id", "buatjanjipoli_id", "skalaprioritas_id", "perawatpjp", "sep_get_id", "renjanjipoli_id", "statuspasien_id", "jeniskasuspenyakitdet_id") VALUES ('PENGUNJUNG BARU', 'LB202610200001', '2026-10-21 15:09:45', '2026-10-21 15:09:45', 'Patologi Klinik', 53, 'BRIDGING', FALSE, 583, 6, 644, 1, 3, 3, 'ANTRIAN', 1028, '007', '27 Thn 00 Bln 16 Hr', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pendaftaran_id"";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.870597;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:176;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:2161160;}i:87;a:6:{i:0;s:5833:"PDOException: SQLSTATE[23503]: Foreign key violation: 7 ERROR:  insert or update on table "pendaftaran_t" violates foreign key constraint "fk_pendafta_relations_penjamin"
DETAIL:  Key (penjamin_id)=(583) is not present in table "penjaminpasien_m". in /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/Command.php:1320
Stack trace:
#0 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/Command.php(1320): PDOStatement->execute()
#1 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/Command.php(1186): yii\db\Command->internalExecute()
#2 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/Command.php(431): yii\db\Command->queryInternal()
#3 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/pgsql/Schema.php(646): yii\db\Command->queryOne()
#4 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/ActiveRecord.php(604): yii\db\pgsql\Schema->insert()
#5 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/ActiveRecord.php(570): yii\db\ActiveRecord->insertInternal()
#6 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/BaseActiveRecord.php(688): yii\db\ActiveRecord->insert()
#7 /var/www/html/api-hl7-ilab/backend/controllers/OrderController.php(176): yii\db\BaseActiveRecord->save()
#8 /var/www/html/api-hl7-ilab/backend/controllers/OrderController.php(51): backend\controllers\OrderController->addPatientlab()
#9 [internal function]: backend\controllers\OrderController->actionAddilab()
#10 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#11 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
#12 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction()
#13 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction()
#14 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest()
#15 /var/www/html/api-hl7-ilab/backend/web/index.php(17): yii\base\Application->run()
#16 {main}

Next yii\db\IntegrityException: SQLSTATE[23503]: Foreign key violation: 7 ERROR:  insert or update on table "pendaftaran_t" violates foreign key constraint "fk_pendafta_relations_penjamin"
DETAIL:  Key (penjamin_id)=(583) is not present in table "penjaminpasien_m".
The SQL being executed was: INSERT INTO "pendaftaran_t" ("statuspasien", "no_pendaftaran", "tgl_pendaftaran", "create_time", "kunjungan", "ruangan_id", "statusmasuk", "panggilantrian", "penjamin_id", "kelaspelayanan_id", "pasien_id", "create_loginpemakai_id", "kelompokumur_id", "golonganumur_id", "statusperiksa", "pegawai_id", "no_urutantri", "umur", "carabayar_id", "pasienpulang_id", "pasienbatalperiksa_id", "penanggungjawab_id", "shift_id", "persalinan_id", "instalasi_id", "caramasuk_id", "pengirimanrm_id", "peminjamanrm_id", "jeniskasuspenyakit_id", "pembayaranpelayanan_id", "pasienadmisi_id", "rujukan_id", "antrian_id", "karcis_id", "update_loginpemakai_id", "create_ruangan", "asuransipasien_id", "sep_id", "ruangankontrol_id", "jml_panggil", "tat_pelayanan_pasien", "kamarruangan_id", "jadwalhemodialisa_id", "ppjp_id", "skp_id", "nursestation_id", "jml_panggildokter", "doktertujuankontrol_id", "buatjanjipoli_id", "skalaprioritas_id", "perawatpjp", "sep_get_id", "renjanjipoli_id", "statuspasien_id", "jeniskasuspenyakitdet_id") VALUES ('PENGUNJUNG BARU', 'LB202610200001', '2026-10-21 15:09:45', '2026-10-21 15:09:45', 'Patologi Klinik', 53, 'BRIDGING', FALSE, 583, 6, 644, 1, 3, 3, 'ANTRIAN', 1028, '007', '27 Thn 00 Bln 16 Hr', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pendaftaran_id" in /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/Schema.php:676
Stack trace:
#0 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/Command.php(1325): yii\db\Schema->convertException()
#1 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/Command.php(1186): yii\db\Command->internalExecute()
#2 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/Command.php(431): yii\db\Command->queryInternal()
#3 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/pgsql/Schema.php(646): yii\db\Command->queryOne()
#4 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/ActiveRecord.php(604): yii\db\pgsql\Schema->insert()
#5 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/ActiveRecord.php(570): yii\db\ActiveRecord->insertInternal()
#6 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/db/BaseActiveRecord.php(688): yii\db\ActiveRecord->insert()
#7 /var/www/html/api-hl7-ilab/backend/controllers/OrderController.php(176): yii\db\BaseActiveRecord->save()
#8 /var/www/html/api-hl7-ilab/backend/controllers/OrderController.php(51): backend\controllers\OrderController->addPatientlab()
#9 [internal function]: backend\controllers\OrderController->actionAddilab()
#10 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#11 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
#12 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction()
#13 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction()
#14 /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest()
#15 /var/www/html/api-hl7-ilab/backend/web/index.php(17): yii\base\Application->run()
#16 {main}
Additional Information:
Array
(
    [0] => 23503
    [1] => 7
    [2] => ERROR:  insert or update on table "pendaftaran_t" violates foreign key constraint "fk_pendafta_relations_penjamin"
DETAIL:  Key (penjamin_id)=(583) is not present in table "penjaminpasien_m".
)
";i:1;i:1;i:2;s:25:"yii\db\IntegrityException";i:3;d:1792570185.91359;i:4;a:0:{}i:5;i:1910552;}i:88;a:6:{i:0;s:100:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/exception.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.914119;i:4;a:0:{}i:5;i:1917456;}i:89;a:6:{i:0;s:108:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/previousException.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.914721;i:4;a:0:{}i:5;i:1980760;}i:90;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.920928;i:4;a:0:{}i:5;i:2078352;}i:91;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.921522;i:4;a:0:{}i:5;i:2152160;}i:92;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.921886;i:4;a:0:{}i:5;i:2158568;}i:93;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.922197;i:4;a:0:{}i:5;i:2159856;}i:94;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.922512;i:4;a:0:{}i:5;i:2088120;}i:95;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.929414;i:4;a:0:{}i:5;i:2094968;}i:96;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.929726;i:4;a:0:{}i:5;i:2100352;}i:97;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.950543;i:4;a:0:{}i:5;i:2209760;}i:98;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.968661;i:4;a:0:{}i:5;i:2070656;}i:99;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.968942;i:4;a:0:{}i:5;i:2076040;}i:100;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.969066;i:4;a:0:{}i:5;i:2020664;}i:101;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.969209;i:4;a:0:{}i:5;i:2028344;}i:102;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.969517;i:4;a:0:{}i:5;i:2105048;}i:103;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.969813;i:4;a:0:{}i:5;i:2118856;}i:104;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.970015;i:4;a:0:{}i:5;i:2063896;}i:105;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.970343;i:4;a:0:{}i:5;i:2122848;}i:106;a:6:{i:0;s:104:"Rendering view file: /var/www/html/api-hl7-ilab/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1792570185.970528;i:4;a:0:{}i:5;i:2048816;}i:107;a:6:{i:0;s:100:"Access to debugger is denied due to IP address restriction. The requesting IP address is 10.10.172.7";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1792570185.971086;i:4;a:0:{}i:5;i:2085144;}i:108;a:6:{i:0;s:100:"Access to debugger is denied due to IP address restriction. The requesting IP address is 10.10.172.7";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1792570185.972323;i:4;a:0:{}i:5;i:2062592;}}}";s:9:"profiling";s:74109:"a:3:{s:6:"memory";i:2519936;s:4:"time";d:0.6427600383758545;s:8:"messages";a:52:{i:10;a:6:{i:0;s:77:"Opening DB connection: pgsql:host=10.10.172.3;port=5433;dbname=db_ilab_biolab";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1792570185.345071;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:66;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:1541648;}i:11;a:6:{i:0;s:77:"Opening DB connection: pgsql:host=10.10.172.3;port=5433;dbname=db_ilab_biolab";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1792570185.398673;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:66;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:1544032;}i:13;a:6:{i:0;s:69:"SELECT * FROM "pasienkirimkeunitlain_t" WHERE "no_sample"='326100001'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.398877;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:66;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:1545728;}i:14;a:6:{i:0;s:69:"SELECT * FROM "pasienkirimkeunitlain_t" WHERE "no_sample"='326100001'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.405495;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:66;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:1550232;}i:16;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:1792570185.407248;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:1578328;}i:17;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:1792570185.46652;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:1619336;}i:19;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:1792570185.468315;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:1596352;}i:20;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:1792570185.478157;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:1598296;}i:22;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:1792570185.479679;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:1598944;}i:23;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:1792570185.518473;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:1603984;}i:25;a:6:{i:0;s:53:"SELECT * FROM "ruangan_m" WHERE "kode_bridging"='LAB'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.520381;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:1621496;}i:26;a:6:{i:0;s:53:"SELECT * FROM "ruangan_m" WHERE "kode_bridging"='LAB'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.525206;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:1628792;}i:28;a:6:{i:0;s:2815:"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 = 'ruangan_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.526716;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:1645072;}i:29;a:6:{i:0;s:2815:"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 = 'ruangan_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.552608;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:1704232;}i:31;a:6:{i:0;s:877:"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='ruangan_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:1792570185.554066;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:1662880;}i:32;a:6:{i:0;s:877:"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='ruangan_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:1792570185.561493;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:1666336;}i:34;a:6:{i:0;s:58:"SELECT * FROM "pasien_m" WHERE "no_rekam_medik"='00112233'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.563308;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:1682680;}i:35;a:6:{i:0;s:58:"SELECT * FROM "pasien_m" WHERE "no_rekam_medik"='00112233'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.570601;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:1691048;}i:37;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:1792570185.57197;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:119;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s: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:1699384;}i:38;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:1792570185.618257;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:119;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s: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:1851784;}i:40;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:1792570185.620511;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:119;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s: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:1748472;}i:41;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:1792570185.6289;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:119;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s: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:1761640;}i:43;a:6:{i:0;s:142:"SELECT kelompokumur_id, kelompokumur_nama FROM kelompokumur_m 
                WHERE 27 BETWEEN kelompokumur_minimal AND kelompokumur_maksimal";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.63161;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:1853352;}i:44;a:6:{i:0;s:142:"SELECT kelompokumur_id, kelompokumur_nama FROM kelompokumur_m 
                WHERE 27 BETWEEN kelompokumur_minimal AND kelompokumur_maksimal";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.63524;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:1855832;}i:46;a:6:{i:0;s:84:"SELECT EXISTS(SELECT * FROM "pasien_m" WHERE "pasien_m"."no_rekam_medik"='00112233')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.63913;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:1929976;}i:47;a:6:{i:0;s:84:"SELECT EXISTS(SELECT * FROM "pasien_m" WHERE "pasien_m"."no_rekam_medik"='00112233')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.642123;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:1931584;}i:49;a:6:{i:0;s:801:"INSERT INTO "pasien_m" ("nama_pasien", "kecamatan_id", "kabupaten_id", "propinsi_id", "no_rekam_medik", "jeniskelamin", "tanggal_lahir", "tgl_rekam_medik", "kelompokumur_id", "create_time", "create_loginpemakai_id", "alamat_pasien", "agama", "warga_negara", "statusrekammedis", "ispasienluar", "pendidikan_id", "profilrs_id", "kelurahan_id", "loginpemakai_id", "suku_id", "pekerjaan_id", "dokrekammedis_id", "rt", "rw", "anakke", "jumlah_bersaudara", "update_loginpemakai_id", "create_ruangan", "pegawai_id") VALUES ('RAIN LECLERC', 999999, 999999, 999999, '00112233', 'LAKI-LAKI', '1999-10-05', '2026-10-21 15:09:45', 3, '2026-10-21 15:09:45', 1, 'ALAMAT PASIEN', 'ISLAM', 'WNI', 'AKTIF', TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pasien_id"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.643967;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:1937656;}i:50;a:6:{i:0;s:801:"INSERT INTO "pasien_m" ("nama_pasien", "kecamatan_id", "kabupaten_id", "propinsi_id", "no_rekam_medik", "jeniskelamin", "tanggal_lahir", "tgl_rekam_medik", "kelompokumur_id", "create_time", "create_loginpemakai_id", "alamat_pasien", "agama", "warga_negara", "statusrekammedis", "ispasienluar", "pendidikan_id", "profilrs_id", "kelurahan_id", "loginpemakai_id", "suku_id", "pekerjaan_id", "dokrekammedis_id", "rt", "rw", "anakke", "jumlah_bersaudara", "update_loginpemakai_id", "create_ruangan", "pegawai_id") VALUES ('RAIN LECLERC', 999999, 999999, 999999, '00112233', 'LAKI-LAKI', '1999-10-05', '2026-10-21 15:09:45', 3, '2026-10-21 15:09:45', 1, 'ALAMAT PASIEN', 'ISLAM', 'WNI', 'AKTIF', TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pasien_id"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.712704;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:1940984;}i:52;a:6:{i:0;s:69:"SELECT * FROM "pendaftaran_t" WHERE "no_pendaftaran"='LB202610200001'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.714576;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:1945560;}i:53;a:6:{i:0;s:69:"SELECT * FROM "pendaftaran_t" WHERE "no_pendaftaran"='LB202610200001'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.721349;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:1956096;}i:55;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:1792570185.722762;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:1962832;}i:56;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:1792570185.800467;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:2153240;}i:58;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:1792570185.803029;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:2023280;}i:59;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:1792570185.811905;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:2035328;}i:61;a:6:{i:0;s:138:"SELECT golonganumur_id, golonganumur_nama FROM golonganumur_m 
            WHERE 27 BETWEEN golonganumur_minimal AND golonganumur_maksimal";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.81363;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:463;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:162;s:8:"function";s:15:"getGolonganUmur";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:2035896;}i:62;a:6:{i:0;s:138:"SELECT golonganumur_id, golonganumur_nama FROM golonganumur_m 
            WHERE 27 BETWEEN golonganumur_minimal AND golonganumur_maksimal";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.816878;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:463;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:162;s:8:"function";s:15:"getGolonganUmur";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:2038632;}i:64;a:6:{i:0;s:47:"SELECT * FROM "ruangan_m" WHERE "ruangan_id"=53";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.81836;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:398;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:167;s:8:"function";s:9:"noAntrian";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:2044312;}i:65;a:6:{i:0;s:47:"SELECT * FROM "ruangan_m" WHERE "ruangan_id"=53";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.821127;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:398;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:167;s:8:"function";s:9:"noAntrian";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:2057648;}i:67;a:6:{i:0;s:164:"SELECT MAX(no_urutantri) AS nomaksimal
                 FROM pendaftaran_t 
                 WHERE DATE(tgl_pendaftaran) = '2026-10-21 15:09:45' AND ruangan_id = 53";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.822615;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:410;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:167;s:8:"function";s:9:"noAntrian";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:2059152;}i:68;a:6:{i:0;s:164:"SELECT MAX(no_urutantri) AS nomaksimal
                 FROM pendaftaran_t 
                 WHERE DATE(tgl_pendaftaran) = '2026-10-21 15:09:45' AND ruangan_id = 53";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.826559;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:410;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:167;s:8:"function";s:9:"noAntrian";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:2061624;}i:70;a:6:{i:0;s:179:"SELECT MAX(no_antrianjanji) AS nomaksimal
                      FROM buatjanjipoli_t 
                      WHERE DATE(tgljadwal) = '2026-10-21 15:09:45'::date AND ruangan_id = 53";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.827902;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:418;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:167;s:8:"function";s:9:"noAntrian";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:2065528;}i:71;a:6:{i:0;s:179:"SELECT MAX(no_antrianjanji) AS nomaksimal
                      FROM buatjanjipoli_t 
                      WHERE DATE(tgljadwal) = '2026-10-21 15:09:45'::date AND ruangan_id = 53";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.831964;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:418;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:167;s:8:"function";s:9:"noAntrian";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:2067968;}i:73;a:6:{i:0;s:50:"SELECT * FROM "carabayar_m" WHERE "carabayar_id"=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.83367;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:171;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:2081600;}i:74;a:6:{i:0;s:50:"SELECT * FROM "carabayar_m" WHERE "carabayar_id"=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.837396;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:171;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:2085160;}i:76;a:6:{i:0;s:2817:"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 = 'carabayar_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.838812;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:171;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:2102240;}i:77;a:6:{i:0;s:2817:"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 = 'carabayar_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.852807;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:171;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:2128144;}i:79;a:6:{i:0;s:879:"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='carabayar_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:1792570185.854311;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:171;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:2108960;}i:80;a:6:{i:0;s:879:"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='carabayar_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:1792570185.861435;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:171;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:2110904;}i:82;a:6:{i:0;s:100:"SELECT EXISTS(SELECT * FROM "pendaftaran_t" WHERE "pendaftaran_t"."no_pendaftaran"='LB202610200001')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.864945;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:176;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:2143960;}i:83;a:6:{i:0;s:100:"SELECT EXISTS(SELECT * FROM "pendaftaran_t" WHERE "pendaftaran_t"."no_pendaftaran"='LB202610200001')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.868449;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:176;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:2145568;}i:85;a:6:{i:0;s:1464:"INSERT INTO "pendaftaran_t" ("statuspasien", "no_pendaftaran", "tgl_pendaftaran", "create_time", "kunjungan", "ruangan_id", "statusmasuk", "panggilantrian", "penjamin_id", "kelaspelayanan_id", "pasien_id", "create_loginpemakai_id", "kelompokumur_id", "golonganumur_id", "statusperiksa", "pegawai_id", "no_urutantri", "umur", "carabayar_id", "pasienpulang_id", "pasienbatalperiksa_id", "penanggungjawab_id", "shift_id", "persalinan_id", "instalasi_id", "caramasuk_id", "pengirimanrm_id", "peminjamanrm_id", "jeniskasuspenyakit_id", "pembayaranpelayanan_id", "pasienadmisi_id", "rujukan_id", "antrian_id", "karcis_id", "update_loginpemakai_id", "create_ruangan", "asuransipasien_id", "sep_id", "ruangankontrol_id", "jml_panggil", "tat_pelayanan_pasien", "kamarruangan_id", "jadwalhemodialisa_id", "ppjp_id", "skp_id", "nursestation_id", "jml_panggildokter", "doktertujuankontrol_id", "buatjanjipoli_id", "skalaprioritas_id", "perawatpjp", "sep_get_id", "renjanjipoli_id", "statuspasien_id", "jeniskasuspenyakitdet_id") VALUES ('PENGUNJUNG BARU', 'LB202610200001', '2026-10-21 15:09:45', '2026-10-21 15:09:45', 'Patologi Klinik', 53, 'BRIDGING', FALSE, 583, 6, 644, 1, 3, 3, 'ANTRIAN', 1028, '007', '27 Thn 00 Bln 16 Hr', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pendaftaran_id"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.870624;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:176;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:2161648;}i:86;a:6:{i:0;s:1464:"INSERT INTO "pendaftaran_t" ("statuspasien", "no_pendaftaran", "tgl_pendaftaran", "create_time", "kunjungan", "ruangan_id", "statusmasuk", "panggilantrian", "penjamin_id", "kelaspelayanan_id", "pasien_id", "create_loginpemakai_id", "kelompokumur_id", "golonganumur_id", "statusperiksa", "pegawai_id", "no_urutantri", "umur", "carabayar_id", "pasienpulang_id", "pasienbatalperiksa_id", "penanggungjawab_id", "shift_id", "persalinan_id", "instalasi_id", "caramasuk_id", "pengirimanrm_id", "peminjamanrm_id", "jeniskasuspenyakit_id", "pembayaranpelayanan_id", "pasienadmisi_id", "rujukan_id", "antrian_id", "karcis_id", "update_loginpemakai_id", "create_ruangan", "asuransipasien_id", "sep_id", "ruangankontrol_id", "jml_panggil", "tat_pelayanan_pasien", "kamarruangan_id", "jadwalhemodialisa_id", "ppjp_id", "skp_id", "nursestation_id", "jml_panggildokter", "doktertujuankontrol_id", "buatjanjipoli_id", "skalaprioritas_id", "perawatpjp", "sep_get_id", "renjanjipoli_id", "statuspasien_id", "jeniskasuspenyakitdet_id") VALUES ('PENGUNJUNG BARU', 'LB202610200001', '2026-10-21 15:09:45', '2026-10-21 15:09:45', 'Patologi Klinik', 53, 'BRIDGING', FALSE, 583, 6, 644, 1, 3, 3, 'ANTRIAN', 1028, '007', '27 Thn 00 Bln 16 Hr', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pendaftaran_id"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.911156;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:176;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:2256112;}}}";s:2:"db";s:72838:"a:1:{s:8:"messages";a:50:{i:13;a:6:{i:0;s:69:"SELECT * FROM "pasienkirimkeunitlain_t" WHERE "no_sample"='326100001'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.398877;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:66;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:1545728;}i:14;a:6:{i:0;s:69:"SELECT * FROM "pasienkirimkeunitlain_t" WHERE "no_sample"='326100001'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.405495;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:66;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:1550232;}i:16;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:1792570185.407248;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:1578328;}i:17;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:1792570185.46652;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:1619336;}i:19;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:1792570185.468315;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:1596352;}i:20;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:1792570185.478157;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:1598296;}i:22;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:1792570185.479679;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:1598944;}i:23;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:1792570185.518473;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:1603984;}i:25;a:6:{i:0;s:53:"SELECT * FROM "ruangan_m" WHERE "kode_bridging"='LAB'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.520381;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:1621496;}i:26;a:6:{i:0;s:53:"SELECT * FROM "ruangan_m" WHERE "kode_bridging"='LAB'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.525206;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:1628792;}i:28;a:6:{i:0;s:2815:"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 = 'ruangan_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.526716;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:1645072;}i:29;a:6:{i:0;s:2815:"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 = 'ruangan_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.552608;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:1704232;}i:31;a:6:{i:0;s:877:"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='ruangan_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:1792570185.554066;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:1662880;}i:32;a:6:{i:0;s:877:"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='ruangan_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:1792570185.561493;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:1666336;}i:34;a:6:{i:0;s:58:"SELECT * FROM "pasien_m" WHERE "no_rekam_medik"='00112233'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.563308;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:1682680;}i:35;a:6:{i:0;s:58:"SELECT * FROM "pasien_m" WHERE "no_rekam_medik"='00112233'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.570601;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:1691048;}i:37;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:1792570185.57197;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:119;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s: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:1699384;}i:38;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:1792570185.618257;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:119;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s: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:1851784;}i:40;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:1792570185.620511;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:119;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s: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:1748472;}i:41;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:1792570185.6289;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:119;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s: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:1761640;}i:43;a:6:{i:0;s:142:"SELECT kelompokumur_id, kelompokumur_nama FROM kelompokumur_m 
                WHERE 27 BETWEEN kelompokumur_minimal AND kelompokumur_maksimal";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.63161;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:1853352;}i:44;a:6:{i:0;s:142:"SELECT kelompokumur_id, kelompokumur_nama FROM kelompokumur_m 
                WHERE 27 BETWEEN kelompokumur_minimal AND kelompokumur_maksimal";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.63524;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:1855832;}i:46;a:6:{i:0;s:84:"SELECT EXISTS(SELECT * FROM "pasien_m" WHERE "pasien_m"."no_rekam_medik"='00112233')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.63913;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:1929976;}i:47;a:6:{i:0;s:84:"SELECT EXISTS(SELECT * FROM "pasien_m" WHERE "pasien_m"."no_rekam_medik"='00112233')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.642123;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:1931584;}i:49;a:6:{i:0;s:801:"INSERT INTO "pasien_m" ("nama_pasien", "kecamatan_id", "kabupaten_id", "propinsi_id", "no_rekam_medik", "jeniskelamin", "tanggal_lahir", "tgl_rekam_medik", "kelompokumur_id", "create_time", "create_loginpemakai_id", "alamat_pasien", "agama", "warga_negara", "statusrekammedis", "ispasienluar", "pendidikan_id", "profilrs_id", "kelurahan_id", "loginpemakai_id", "suku_id", "pekerjaan_id", "dokrekammedis_id", "rt", "rw", "anakke", "jumlah_bersaudara", "update_loginpemakai_id", "create_ruangan", "pegawai_id") VALUES ('RAIN LECLERC', 999999, 999999, 999999, '00112233', 'LAKI-LAKI', '1999-10-05', '2026-10-21 15:09:45', 3, '2026-10-21 15:09:45', 1, 'ALAMAT PASIEN', 'ISLAM', 'WNI', 'AKTIF', TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pasien_id"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.643967;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:1937656;}i:50;a:6:{i:0;s:801:"INSERT INTO "pasien_m" ("nama_pasien", "kecamatan_id", "kabupaten_id", "propinsi_id", "no_rekam_medik", "jeniskelamin", "tanggal_lahir", "tgl_rekam_medik", "kelompokumur_id", "create_time", "create_loginpemakai_id", "alamat_pasien", "agama", "warga_negara", "statusrekammedis", "ispasienluar", "pendidikan_id", "profilrs_id", "kelurahan_id", "loginpemakai_id", "suku_id", "pekerjaan_id", "dokrekammedis_id", "rt", "rw", "anakke", "jumlah_bersaudara", "update_loginpemakai_id", "create_ruangan", "pegawai_id") VALUES ('RAIN LECLERC', 999999, 999999, 999999, '00112233', 'LAKI-LAKI', '1999-10-05', '2026-10-21 15:09:45', 3, '2026-10-21 15:09:45', 1, 'ALAMAT PASIEN', 'ISLAM', 'WNI', 'AKTIF', TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pasien_id"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.712704;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:1940984;}i:52;a:6:{i:0;s:69:"SELECT * FROM "pendaftaran_t" WHERE "no_pendaftaran"='LB202610200001'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.714576;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:1945560;}i:53;a:6:{i:0;s:69:"SELECT * FROM "pendaftaran_t" WHERE "no_pendaftaran"='LB202610200001'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.721349;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:1956096;}i:55;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:1792570185.722762;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:1962832;}i:56;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:1792570185.800467;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:2153240;}i:58;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:1792570185.803029;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:2023280;}i:59;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:1792570185.811905;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:2035328;}i:61;a:6:{i:0;s:138:"SELECT golonganumur_id, golonganumur_nama FROM golonganumur_m 
            WHERE 27 BETWEEN golonganumur_minimal AND golonganumur_maksimal";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.81363;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:463;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:162;s:8:"function";s:15:"getGolonganUmur";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:2035896;}i:62;a:6:{i:0;s:138:"SELECT golonganumur_id, golonganumur_nama FROM golonganumur_m 
            WHERE 27 BETWEEN golonganumur_minimal AND golonganumur_maksimal";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.816878;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:463;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:162;s:8:"function";s:15:"getGolonganUmur";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:2038632;}i:64;a:6:{i:0;s:47:"SELECT * FROM "ruangan_m" WHERE "ruangan_id"=53";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.81836;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:398;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:167;s:8:"function";s:9:"noAntrian";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:2044312;}i:65;a:6:{i:0;s:47:"SELECT * FROM "ruangan_m" WHERE "ruangan_id"=53";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.821127;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:398;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:167;s:8:"function";s:9:"noAntrian";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:2057648;}i:67;a:6:{i:0;s:164:"SELECT MAX(no_urutantri) AS nomaksimal
                 FROM pendaftaran_t 
                 WHERE DATE(tgl_pendaftaran) = '2026-10-21 15:09:45' AND ruangan_id = 53";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.822615;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:410;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:167;s:8:"function";s:9:"noAntrian";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:2059152;}i:68;a:6:{i:0;s:164:"SELECT MAX(no_urutantri) AS nomaksimal
                 FROM pendaftaran_t 
                 WHERE DATE(tgl_pendaftaran) = '2026-10-21 15:09:45' AND ruangan_id = 53";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.826559;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:410;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:167;s:8:"function";s:9:"noAntrian";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:2061624;}i:70;a:6:{i:0;s:179:"SELECT MAX(no_antrianjanji) AS nomaksimal
                      FROM buatjanjipoli_t 
                      WHERE DATE(tgljadwal) = '2026-10-21 15:09:45'::date AND ruangan_id = 53";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.827902;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:418;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:167;s:8:"function";s:9:"noAntrian";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:2065528;}i:71;a:6:{i:0;s:179:"SELECT MAX(no_antrianjanji) AS nomaksimal
                      FROM buatjanjipoli_t 
                      WHERE DATE(tgljadwal) = '2026-10-21 15:09:45'::date AND ruangan_id = 53";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.831964;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:418;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:167;s:8:"function";s:9:"noAntrian";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:2067968;}i:73;a:6:{i:0;s:50:"SELECT * FROM "carabayar_m" WHERE "carabayar_id"=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.83367;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:171;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:2081600;}i:74;a:6:{i:0;s:50:"SELECT * FROM "carabayar_m" WHERE "carabayar_id"=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.837396;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:171;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:2085160;}i:76;a:6:{i:0;s:2817:"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 = 'carabayar_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.838812;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:171;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:2102240;}i:77;a:6:{i:0;s:2817:"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 = 'carabayar_m'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.852807;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:171;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:2128144;}i:79;a:6:{i:0;s:879:"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='carabayar_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:1792570185.854311;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:171;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:2108960;}i:80;a:6:{i:0;s:879:"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='carabayar_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:1792570185.861435;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:171;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:2110904;}i:82;a:6:{i:0;s:100:"SELECT EXISTS(SELECT * FROM "pendaftaran_t" WHERE "pendaftaran_t"."no_pendaftaran"='LB202610200001')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.864945;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:176;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:2143960;}i:83;a:6:{i:0;s:100:"SELECT EXISTS(SELECT * FROM "pendaftaran_t" WHERE "pendaftaran_t"."no_pendaftaran"='LB202610200001')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.868449;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:176;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:2145568;}i:85;a:6:{i:0;s:1464:"INSERT INTO "pendaftaran_t" ("statuspasien", "no_pendaftaran", "tgl_pendaftaran", "create_time", "kunjungan", "ruangan_id", "statusmasuk", "panggilantrian", "penjamin_id", "kelaspelayanan_id", "pasien_id", "create_loginpemakai_id", "kelompokumur_id", "golonganumur_id", "statusperiksa", "pegawai_id", "no_urutantri", "umur", "carabayar_id", "pasienpulang_id", "pasienbatalperiksa_id", "penanggungjawab_id", "shift_id", "persalinan_id", "instalasi_id", "caramasuk_id", "pengirimanrm_id", "peminjamanrm_id", "jeniskasuspenyakit_id", "pembayaranpelayanan_id", "pasienadmisi_id", "rujukan_id", "antrian_id", "karcis_id", "update_loginpemakai_id", "create_ruangan", "asuransipasien_id", "sep_id", "ruangankontrol_id", "jml_panggil", "tat_pelayanan_pasien", "kamarruangan_id", "jadwalhemodialisa_id", "ppjp_id", "skp_id", "nursestation_id", "jml_panggildokter", "doktertujuankontrol_id", "buatjanjipoli_id", "skalaprioritas_id", "perawatpjp", "sep_get_id", "renjanjipoli_id", "statuspasien_id", "jeniskasuspenyakitdet_id") VALUES ('PENGUNJUNG BARU', 'LB202610200001', '2026-10-21 15:09:45', '2026-10-21 15:09:45', 'Patologi Klinik', 53, 'BRIDGING', FALSE, 583, 6, 644, 1, 3, 3, 'ANTRIAN', 1028, '007', '27 Thn 00 Bln 16 Hr', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pendaftaran_id"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.870624;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:176;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:2161648;}i:86;a:6:{i:0;s:1464:"INSERT INTO "pendaftaran_t" ("statuspasien", "no_pendaftaran", "tgl_pendaftaran", "create_time", "kunjungan", "ruangan_id", "statusmasuk", "panggilantrian", "penjamin_id", "kelaspelayanan_id", "pasien_id", "create_loginpemakai_id", "kelompokumur_id", "golonganumur_id", "statusperiksa", "pegawai_id", "no_urutantri", "umur", "carabayar_id", "pasienpulang_id", "pasienbatalperiksa_id", "penanggungjawab_id", "shift_id", "persalinan_id", "instalasi_id", "caramasuk_id", "pengirimanrm_id", "peminjamanrm_id", "jeniskasuspenyakit_id", "pembayaranpelayanan_id", "pasienadmisi_id", "rujukan_id", "antrian_id", "karcis_id", "update_loginpemakai_id", "create_ruangan", "asuransipasien_id", "sep_id", "ruangankontrol_id", "jml_panggil", "tat_pelayanan_pasien", "kamarruangan_id", "jadwalhemodialisa_id", "ppjp_id", "skp_id", "nursestation_id", "jml_panggildokter", "doktertujuankontrol_id", "buatjanjipoli_id", "skalaprioritas_id", "perawatpjp", "sep_get_id", "renjanjipoli_id", "statuspasien_id", "jeniskasuspenyakitdet_id") VALUES ('PENGUNJUNG BARU', 'LB202610200001', '2026-10-21 15:09:45', '2026-10-21 15:09:45', 'Patologi Klinik', 53, 'BRIDGING', FALSE, 583, 6, 644, 1, 3, 3, 'ANTRIAN', 1028, '007', '27 Thn 00 Bln 16 Hr', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "pendaftaran_id"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792570185.911156;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:176;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:2256112;}}}";s:5:"event";s:13303:"a:77:{i:0;a:5:{s:4:"time";d:1792570185.341737;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:1792570185.342343;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:1792570185.342367;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:1792570185.343706;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:1792570185.398652;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:1792570185.406993;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:6;a:5:{s:4:"time";d:1792570185.519944;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:7;a:5:{s:4:"time";d:1792570185.520062;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:8;a:5:{s:4:"time";d:1792570185.520193;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:9;a:5:{s:4:"time";d:1792570185.526547;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\RuanganM";}i:10;a:5:{s:4:"time";d:1792570185.562964;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\RuanganM";}i:11;a:5:{s:4:"time";d:1792570185.563121;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:12;a:5:{s:4:"time";d:1792570185.563149;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:13;a:5:{s:4:"time";d:1792570185.571821;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:14;a:5:{s:4:"time";d:1792570185.636639;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:15;a:5:{s:4:"time";d:1792570185.638596;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:16;a:5:{s:4:"time";d:1792570185.638727;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:17;a:5:{s:4:"time";d:1792570185.643472;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:18;a:5:{s:4:"time";d:1792570185.643533;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\PasienM";}i:19;a:5:{s:4:"time";d:1792570185.714233;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\PasienM";}i:20;a:5:{s:4:"time";d:1792570185.714405;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:21;a:5:{s:4:"time";d:1792570185.722612;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:22;a:5:{s:4:"time";d:1792570185.818165;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:23;a:5:{s:4:"time";d:1792570185.822405;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\RuanganM";}i:24;a:5:{s:4:"time";d:1792570185.822494;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\RuanganM";}i:25;a:5:{s:4:"time";d:1792570185.833522;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:26;a:5:{s:4:"time";d:1792570185.838667;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\CarabayarM";}i:27;a:5:{s:4:"time";d:1792570185.862846;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"common\models\CarabayarM";}i:28;a:5:{s:4:"time";d:1792570185.862906;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"common\models\PendaftaranT";}i:29;a:5:{s:4:"time";d:1792570185.864679;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:30;a:5:{s:4:"time";d:1792570185.864744;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:31;a:5:{s:4:"time";d:1792570185.870017;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"common\models\PendaftaranT";}i:32;a:5:{s:4:"time";d:1792570185.870042;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"common\models\PendaftaranT";}i:33;a:5:{s:4:"time";d:1792570185.91411;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:34;a:5:{s:4:"time";d:1792570185.914226;s:4:"name";s:9:"beginPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:35;a:5:{s:4:"time";d:1792570185.914714;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:36;a:5:{s:4:"time";d:1792570185.920644;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:37;a:5:{s:4:"time";d:1792570185.920921;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:38;a:5:{s:4:"time";d:1792570185.921055;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:39;a:5:{s:4:"time";d:1792570185.921516;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:40;a:5:{s:4:"time";d:1792570185.921653;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:41;a:5:{s:4:"time";d:1792570185.921882;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:42;a:5:{s:4:"time";d:1792570185.921975;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:43;a:5:{s:4:"time";d:1792570185.922193;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:44;a:5:{s:4:"time";d:1792570185.922283;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:45;a:5:{s:4:"time";d:1792570185.922507;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:46;a:5:{s:4:"time";d:1792570185.922596;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:47;a:5:{s:4:"time";d:1792570185.929405;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:48;a:5:{s:4:"time";d:1792570185.929539;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:49;a:5:{s:4:"time";d:1792570185.929721;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:50;a:5:{s:4:"time";d:1792570185.929818;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:51;a:5:{s:4:"time";d:1792570185.950534;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:52;a:5:{s:4:"time";d:1792570185.950687;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:53;a:5:{s:4:"time";d:1792570185.968651;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:54;a:5:{s:4:"time";d:1792570185.968796;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:55;a:5:{s:4:"time";d:1792570185.968937;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:56;a:5:{s:4:"time";d:1792570185.969031;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:57;a:5:{s:4:"time";d:1792570185.969063;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:58;a:5:{s:4:"time";d:1792570185.969113;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:59;a:5:{s:4:"time";d:1792570185.969205;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:60;a:5:{s:4:"time";d:1792570185.969305;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:61;a:5:{s:4:"time";d:1792570185.969512;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:62;a:5:{s:4:"time";d:1792570185.969605;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:63;a:5:{s:4:"time";d:1792570185.969808;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:64;a:5:{s:4:"time";d:1792570185.969896;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:65;a:5:{s:4:"time";d:1792570185.970011;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:66;a:5:{s:4:"time";d:1792570185.970096;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:67;a:5:{s:4:"time";d:1792570185.970321;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:68;a:5:{s:4:"time";d:1792570185.97043;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:69;a:5:{s:4:"time";d:1792570185.970524;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:70;a:5:{s:4:"time";d:1792570185.970597;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:71;a:5:{s:4:"time";d:1792570185.97111;s:4:"name";s:7:"endBody";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:72;a:5:{s:4:"time";d:1792570185.971132;s:4:"name";s:7:"endPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:73;a:5:{s:4:"time";d:1792570185.972175;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:74;a:5:{s:4:"time";d:1792570185.972191;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:75;a:5:{s:4:"time";d:1792570185.972359;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:76;a:5:{s:4:"time";d:1792570185.972954;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:91:"a:3:{s:5:"start";d:1792570185.335437;s:3:"end";d:1792570185.978824;s:6:"memory";i:2519936;}";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:1792570185.341768;i:4;a:0:{}i:5;i:1167288;}}s:5:"route";s:13:"order/addilab";s:6:"action";s:52:"backend\controllers\OrderController::actionAddilab()";}";s:7:"request";s:3881:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:500;s:14:"requestHeaders";a:10:{s:10:"connection";s:7:"upgrade";s:4:"host";s:20:"api-hl7.ihospital.id";s:9:"x-real-ip";s:11:"10.10.172.2";s:14:"content-length";s:3:"520";s:13:"cache-control";s:8:"no-cache";s:13:"postman-token";s:36:"e7fc00f6-fdf8-4679-937c-e5a1e81da278";s:12:"content-type";s:16:"application/json";s:10:"user-agent";s:21:"PostmanRuntime/2.12.0";s:6:"accept";s:3:"*/*";s:15:"accept-encoding";s:17:"gzip, deflate, br";}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:520:"{ 
  "data": { 
    "nama_pasien": "RAIN LECLERC", 
    "jeniskelamin": "LAKI-LAKI", 
    "no_rekam_medik": "00112233", 
    "no_pendaftaran": "LB202610200001", 
    "tanggal_lahir": "1999-10-05", 
    "alamat_pasien": "ALAMAT PASIEN", 
    "carabayar_id": 1,
    "pemeriksaanlab": [ 
      { "pemeriksaanlab_kode": "LAB-305" }, 
      { "pemeriksaanlab_kode": "LAB-306" } 
    ], 
    "instalasi_singkatan": "LB", 
    "kode_bridging": "LAB", 
    "no_sample": "326100001" 
  }, 
  "command": "ADD" 
}";s:7:"Decoded";a:2:{s:4:"data";a:11:{s:11:"nama_pasien";s:12:"RAIN LECLERC";s:12:"jeniskelamin";s:9:"LAKI-LAKI";s:14:"no_rekam_medik";s:8:"00112233";s:14:"no_pendaftaran";s:14:"LB202610200001";s:13:"tanggal_lahir";s:10:"1999-10-05";s:13:"alamat_pasien";s:13:"ALAMAT PASIEN";s:12:"carabayar_id";i:1;s:14:"pemeriksaanlab";a:2:{i:0;a:1:{s:19:"pemeriksaanlab_kode";s:7:"LAB-305";}i:1;a:1:{s:19:"pemeriksaanlab_kode";s:7:"LAB-306";}}s:19:"instalasi_singkatan";s:2:"LB";s:13:"kode_bridging";s:3:"LAB";s:9:"no_sample";s:9:"326100001";}s:7:"command";s:3:"ADD";}}s:6:"SERVER";a:37:{s:15:"HTTP_CONNECTION";s:7:"upgrade";s:9:"HTTP_HOST";s:20:"api-hl7.ihospital.id";s:14:"HTTP_X_REAL_IP";s:11:"10.10.172.2";s:20:"HTTP_X_FORWARDED_FOR";s:11:"10.10.172.2";s:22:"HTTP_X_FORWARDED_PROTO";s:4:"http";s:21:"HTTP_X_FORWARDED_HOST";s:20:"api-hl7.ihospital.id";s:21:"HTTP_X_FORWARDED_PORT";s:2:"80";s:14:"CONTENT_LENGTH";s:3:"520";s:18:"HTTP_CACHE_CONTROL";s:8:"no-cache";s:18:"HTTP_POSTMAN_TOKEN";s:36:"e7fc00f6-fdf8-4679-937c-e5a1e81da278";s:12:"CONTENT_TYPE";s:16:"application/json";s:15:"HTTP_USER_AGENT";s:21:"PostmanRuntime/2.12.0";s:11:"HTTP_ACCEPT";s:3:"*/*";s:20:"HTTP_ACCEPT_ENCODING";s:17:"gzip, deflate, br";s:4:"PATH";s:70:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin";s:16:"SERVER_SIGNATURE";s:81:"<address>Apache/2.4.52 (Ubuntu) Server at api-hl7.ihospital.id Port 80</address>
";s:15:"SERVER_SOFTWARE";s:22:"Apache/2.4.52 (Ubuntu)";s:11:"SERVER_NAME";s:20:"api-hl7.ihospital.id";s:11:"SERVER_ADDR";s:13:"10.10.172.231";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:11:"10.10.172.7";s:13:"DOCUMENT_ROOT";s:26:"/var/www/html/api-hl7-ilab";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:26:"/var/www/html/api-hl7-ilab";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:"50754";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:38:"/backend/web/index.php?r=order/addilab";s:11:"SCRIPT_NAME";s:22:"/backend/web/index.php";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1792570185.332907;s:12:"REQUEST_TIME";i:1792570185;}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:"6ad873495346c";s:3:"url";s:65:"http://api-hl7.ihospital.id/backend/web/index.php?r=order/addilab";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:11:"10.10.172.7";s:4:"time";d:1792570185.332907;s:10:"statusCode";i:500;s:8:"sqlCount";i:25;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2519936;s:14:"processingTime";d:0.6427600383758545;}s:10:"exceptions";a:0:{}}