a:13:{s:6:"config";s:1908:"a:5:{s:10:"phpVersion";s:5:"7.3.0";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:5:"7.3.0";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:7:{s:14:"sizeg/yii2-jwt";a:3:{s:4:"name";s:14:"sizeg/yii2-jwt";s:7:"version";s:7:"2.0.2.0";s:5:"alias";a:1:{s:10:"@sizeg/jwt";s:56:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt";}}s:23:"yiisoft/yii2-bootstrap4";a:3:{s:4:"name";s:23:"yiisoft/yii2-bootstrap4";s:7:"version";s:8:"2.0.12.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap4";s:69:"/opt/lampp/htdocs/farmacia.apirest/vendor/yiisoft/yii2-bootstrap4/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:64:"/opt/lampp/htdocs/farmacia.apirest/vendor/yiisoft/yii2-faker/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:64:"/opt/lampp/htdocs/farmacia.apirest/vendor/yiisoft/yii2-debug/src";}}s:23:"yiisoft/yii2-httpclient";a:3:{s:4:"name";s:23:"yiisoft/yii2-httpclient";s:7:"version";s:8:"2.0.16.0";s:5:"alias";a:1:{s:15:"@yii/httpclient";s:69:"/opt/lampp/htdocs/farmacia.apirest/vendor/yiisoft/yii2-httpclient/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.7.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:62:"/opt/lampp/htdocs/farmacia.apirest/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:70:"/opt/lampp/htdocs/farmacia.apirest/vendor/yiisoft/yii2-swiftmailer/src";}}}}";s:3:"log";s:20965:"a:1:{s:8:"messages";a:26:{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:1794983700.6419990062713623046875;i:4;a:0:{}i:5;i:2743056;}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:1794983700.6420180797576904296875;i:4;a:0:{}i:5;i:2744232;}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:1794983700.6495819091796875;i:4;a:0:{}i:5;i:3495600;}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:1794983700.6522729396820068359375;i:4;a:0:{}i:5;i:3882224;}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:1794983700.6525371074676513671875;i:4;a:0:{}i:5;i:3907112;}i:12;a:6:{i:0;s:29:"Route requested: 'apiv1/sale'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1794983700.654315948486328125;i:4;a:0:{}i:5;i:4290072;}i:13;a:6:{i:0;s:21:"Loading module: apiv1";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1794983700.654323101043701171875;i:4;a:0:{}i:5;i:4291688;}i:14;a:6:{i:0;s:30:"Route to run: apiv1/sale/index";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1794983700.659288883209228515625;i:4;a:0:{}i:5;i:4942400;}i:15;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=2.24.217.134;dbname=0_iooxs_access";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1794983700.673551082611083984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6598616;}i:18;a:6:{i:0;s:2796:"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)  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 = 'cruge_user'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.6874620914459228515625;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6737520;}i:21;a:6:{i:0;s:878:"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='cruge_user'
    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:1794983700.69997406005859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6788352;}i:24;a:6:{i:0;s:48:"SELECT * FROM "cruge_user" WHERE "iduser"='2778'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.7061560153961181640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUserQuery.php";s:4:"line";i:32;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:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:7153336;}i:27;a:6:{i:0;s:62:"User '2778' logged in from 104.22.182.11. Session not enabled.";i:1;i:4;i:2;s:19:"yii\web\User::login";i:3;d:1794983700.713141918182373046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:7472000;}i:28;a:6:{i:0;s:65:"Rate limit skipped: "user" does not implement RateLimitInterface.";i:1;i:4;i:2;s:37:"yii\filters\RateLimiter::beforeAction";i:3;d:1794983700.714045047760009765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/BaseController.php";s:4:"line";i:26;s:8:"function";s:12:"beforeAction";s:5:"class";s:18:"yii\web\Controller";s:4:"type";s:2:"->";}}i:5;i:7542968;}i:29;a:6:{i:0;s:75:"Running action: app\modules\apiv1\controllers\SaleController::actionIndex()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1794983700.7140820026397705078125;i:4;a:0:{}i:5;i:7607352;}i:30;a:6:{i:0;s:77:"Opening DB connection: pgsql:host=2.24.217.134;dbname=farmacia_medicenter_sb0";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1794983700.73626708984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:262;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:8813400;}i:33;a:6:{i:0;s:370:"SELECT SUM("sale"."montoTotal") FROM "sale" "sale" LEFT JOIN "cfg"."viewCustomer" "vc" ON "sale"."idcustomer" = "vc"."id" LEFT JOIN "invoice" "invd" ON "sale"."id" = "invd"."idsale" WHERE ("sale"."recycleBin"=FALSE) AND ("invoice"=TRUE) AND ("sale"."dateCreate" >= '2026-11-18 00:00:00') AND ("sale"."dateCreate" <= '2026-11-18 23:59:59') AND ("sale"."idsiatBranch"=310)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.745604038238525390625;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:262;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:8816120;}i:36;a:6:{i:0;s:68:"SELECT * FROM "paymentMethod" WHERE "recycleBin"=FALSE ORDER BY "id"";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.7982280254364013671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8847376;}i:37;a:6:{i:0;s:73:"Opening DB connection: pgsql:host=2.24.217.134;dbname=farmacia_medicenter";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1794983700.79825305938720703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8850464;}i:42;a:6:{i:0;s:2799:"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)  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 = 'paymentMethod'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.820991992950439453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8864664;}i:45;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='paymentMethod'
    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:1794983700.83917903900146484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8876968;}i:48;a:6:{i:0;s:482:"SELECT "codigoMetodoPago", SUM("monto") AS "monto" FROM "salePaymentMethods" WHERE "idsale" IN (SELECT "sale"."id" FROM "sale" "sale" LEFT JOIN "cfg"."viewCustomer" "vc" ON "sale"."idcustomer" = "vc"."id" LEFT JOIN "invoice" "invd" ON "sale"."id" = "invd"."idsale" WHERE ("sale"."recycleBin"=FALSE) AND ("invoice"=TRUE) AND ("sale"."dateCreate" >= '2026-11-18 00:00:00') AND ("sale"."dateCreate" <= '2026-11-18 23:59:59') AND ("sale"."idsiatBranch"=310)) GROUP BY "codigoMetodoPago"";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.84469509124755859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:289;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8915568;}i:51;a:6:{i:0;s:354:"SELECT COUNT(*) FROM "sale" "sale" LEFT JOIN "cfg"."viewCustomer" "vc" ON "sale"."idcustomer" = "vc"."id" LEFT JOIN "invoice" "invd" ON "sale"."id" = "invd"."idsale" WHERE ("sale"."recycleBin"=FALSE) AND ("invoice"=TRUE) AND ("sale"."dateCreate" >= '2026-11-18 00:00:00') AND ("sale"."dateCreate" <= '2026-11-18 23:59:59') AND ("sale"."idsiatBranch"=310)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.863893032073974609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:298;s:8:"function";s:13:"getTotalCount";s:5:"class";s:25:"yii\data\BaseDataProvider";s:4:"type";s:2:"->";}}i:5;i:8922872;}i:54;a:6:{i:0;s:2790:"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)  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 = 'sale'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.8786790370941162109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:299;s:8:"function";s:9:"getModels";s:5:"class";s:25:"yii\data\BaseDataProvider";s:4:"type";s:2:"->";}}i:5;i:8925008;}i:57;a:6:{i:0;s:872:"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='sale'
    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:1794983700.892097949981689453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:299;s:8:"function";s:9:"getModels";s:5:"class";s:25:"yii\data\BaseDataProvider";s:4:"type";s:2:"->";}}i:5;i:8961944;}i:60;a:6:{i:0;s:102:"Access to debugger is denied due to IP address restriction. The requesting IP address is 104.22.182.11";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1794983700.8970019817352294921875;i:4;a:0:{}i:5;i:9064608;}}}";s:9:"profiling";s:36799:"a:3:{s:6:"memory";i:9430896;s:4:"time";d:0.285064220428466796875;s:8:"messages";a:28:{i:16;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=2.24.217.134;dbname=0_iooxs_access";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1794983700.6735770702362060546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6600120;}i:17;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=2.24.217.134;dbname=0_iooxs_access";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1794983700.686131000518798828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6603064;}i:19;a:6:{i:0;s:2796:"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)  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 = 'cruge_user'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.6875379085540771484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6748680;}i:20;a:6:{i:0;s:2796:"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)  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 = 'cruge_user'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.698645114898681640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6787592;}i:22;a:6:{i:0;s:878:"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='cruge_user'
    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:1794983700.7000119686126708984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6793032;}i:23;a:6:{i:0;s:878:"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='cruge_user'
    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:1794983700.7020719051361083984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6794976;}i:25;a:6:{i:0;s:48:"SELECT * FROM "cruge_user" WHERE "iduser"='2778'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.70740604400634765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUserQuery.php";s:4:"line";i:32;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:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:7156560;}i:26;a:6:{i:0;s:48:"SELECT * FROM "cruge_user" WHERE "iduser"='2778'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.7094089984893798828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUserQuery.php";s:4:"line";i:32;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:68:"/opt/lampp/htdocs/farmacia.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:78:"/opt/lampp/htdocs/farmacia.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:7161768;}i:31;a:6:{i:0;s:77:"Opening DB connection: pgsql:host=2.24.217.134;dbname=farmacia_medicenter_sb0";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1794983700.7362880706787109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:262;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:8814528;}i:32;a:6:{i:0;s:77:"Opening DB connection: pgsql:host=2.24.217.134;dbname=farmacia_medicenter_sb0";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1794983700.7455310821533203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:262;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:8816472;}i:34;a:6:{i:0;s:370:"SELECT SUM("sale"."montoTotal") FROM "sale" "sale" LEFT JOIN "cfg"."viewCustomer" "vc" ON "sale"."idcustomer" = "vc"."id" LEFT JOIN "invoice" "invd" ON "sale"."id" = "invd"."idsale" WHERE ("sale"."recycleBin"=FALSE) AND ("invoice"=TRUE) AND ("sale"."dateCreate" >= '2026-11-18 00:00:00') AND ("sale"."dateCreate" <= '2026-11-18 23:59:59') AND ("sale"."idsiatBranch"=310)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.745635986328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:262;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:8818776;}i:35;a:6:{i:0;s:370:"SELECT SUM("sale"."montoTotal") FROM "sale" "sale" LEFT JOIN "cfg"."viewCustomer" "vc" ON "sale"."idcustomer" = "vc"."id" LEFT JOIN "invoice" "invd" ON "sale"."id" = "invd"."idsale" WHERE ("sale"."recycleBin"=FALSE) AND ("invoice"=TRUE) AND ("sale"."dateCreate" >= '2026-11-18 00:00:00') AND ("sale"."dateCreate" <= '2026-11-18 23:59:59') AND ("sale"."idsiatBranch"=310)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.797267913818359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:262;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:8820200;}i:38;a:6:{i:0;s:73:"Opening DB connection: pgsql:host=2.24.217.134;dbname=farmacia_medicenter";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1794983700.7982590198516845703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8851592;}i:39;a:6:{i:0;s:73:"Opening DB connection: pgsql:host=2.24.217.134;dbname=farmacia_medicenter";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1794983700.8124759197235107421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8854168;}i:40;a:6:{i:0;s:68:"SELECT * FROM "paymentMethod" WHERE "recycleBin"=FALSE ORDER BY "id"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.812808990478515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8854944;}i:41;a:6:{i:0;s:68:"SELECT * FROM "paymentMethod" WHERE "recycleBin"=FALSE ORDER BY "id"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.81947803497314453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8858472;}i:43;a:6:{i:0;s:2799:"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)  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 = 'paymentMethod'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.8210299015045166015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8875368;}i:44;a:6:{i:0;s:2799:"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)  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 = 'paymentMethod'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.8382389545440673828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8889352;}i:46;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='paymentMethod'
    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:1794983700.8392269611358642578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8881272;}i:47;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='paymentMethod'
    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:1794983700.8431949615478515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:275;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8882840;}i:49;a:6:{i:0;s:482:"SELECT "codigoMetodoPago", SUM("monto") AS "monto" FROM "salePaymentMethods" WHERE "idsale" IN (SELECT "sale"."id" FROM "sale" "sale" LEFT JOIN "cfg"."viewCustomer" "vc" ON "sale"."idcustomer" = "vc"."id" LEFT JOIN "invoice" "invd" ON "sale"."id" = "invd"."idsale" WHERE ("sale"."recycleBin"=FALSE) AND ("invoice"=TRUE) AND ("sale"."dateCreate" >= '2026-11-18 00:00:00') AND ("sale"."dateCreate" <= '2026-11-18 23:59:59') AND ("sale"."idsiatBranch"=310)) GROUP BY "codigoMetodoPago"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.844728946685791015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:289;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8918528;}i:50;a:6:{i:0;s:482:"SELECT "codigoMetodoPago", SUM("monto") AS "monto" FROM "salePaymentMethods" WHERE "idsale" IN (SELECT "sale"."id" FROM "sale" "sale" LEFT JOIN "cfg"."viewCustomer" "vc" ON "sale"."idcustomer" = "vc"."id" LEFT JOIN "invoice" "invd" ON "sale"."id" = "invd"."idsale" WHERE ("sale"."recycleBin"=FALSE) AND ("invoice"=TRUE) AND ("sale"."dateCreate" >= '2026-11-18 00:00:00') AND ("sale"."dateCreate" <= '2026-11-18 23:59:59') AND ("sale"."idsiatBranch"=310)) GROUP BY "codigoMetodoPago"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.86324310302734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:289;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:8920088;}i:52;a:6:{i:0;s:354:"SELECT COUNT(*) FROM "sale" "sale" LEFT JOIN "cfg"."viewCustomer" "vc" ON "sale"."idcustomer" = "vc"."id" LEFT JOIN "invoice" "invd" ON "sale"."id" = "invd"."idsale" WHERE ("sale"."recycleBin"=FALSE) AND ("invoice"=TRUE) AND ("sale"."dateCreate" >= '2026-11-18 00:00:00') AND ("sale"."dateCreate" <= '2026-11-18 23:59:59') AND ("sale"."idsiatBranch"=310)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.863933086395263671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:298;s:8:"function";s:13:"getTotalCount";s:5:"class";s:25:"yii\data\BaseDataProvider";s:4:"type";s:2:"->";}}i:5;i:8924808;}i:53;a:6:{i:0;s:354:"SELECT COUNT(*) FROM "sale" "sale" LEFT JOIN "cfg"."viewCustomer" "vc" ON "sale"."idcustomer" = "vc"."id" LEFT JOIN "invoice" "invd" ON "sale"."id" = "invd"."idsale" WHERE ("sale"."recycleBin"=FALSE) AND ("invoice"=TRUE) AND ("sale"."dateCreate" >= '2026-11-18 00:00:00') AND ("sale"."dateCreate" <= '2026-11-18 23:59:59') AND ("sale"."idsiatBranch"=310)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.8781280517578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:298;s:8:"function";s:13:"getTotalCount";s:5:"class";s:25:"yii\data\BaseDataProvider";s:4:"type";s:2:"->";}}i:5;i:8926232;}i:55;a:6:{i:0;s:2790:"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)  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 = 'sale'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.8787190914154052734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:299;s:8:"function";s:9:"getModels";s:5:"class";s:25:"yii\data\BaseDataProvider";s:4:"type";s:2:"->";}}i:5;i:8935712;}i:56;a:6:{i:0;s:2790:"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)  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 = 'sale'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794983700.8913118839263916015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:299;s:8:"function";s:9:"getModels";s:5:"class";s:25:"yii\data\BaseDataProvider";s:4:"type";s:2:"->";}}i:5;i:9039272;}i:58;a:6:{i:0;s:872:"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='sale'
    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:1794983700.8921349048614501953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:299;s:8:"function";s:9:"getModels";s:5:"class";s:25:"yii\data\BaseDataProvider";s:4:"type";s:2:"->";}}i:5;i:8966248;}i:59;a:6:{i:0;s:872:"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='sale'
    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:1794983700.8956520557403564453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/farmacia.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:299;s:8:"function";s:9:"getModels";s:5:"class";s:25:"yii\data\BaseDataProvider";s:4:"type";s:2:"->";}}i:5;i:8967816;}}}";s:5:"event";s:6404:"a:33:{i:0;a:5:{s:4:"time";d:1794983700.65412998199462890625;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:1794983700.65940189361572265625;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:1794983700.6696979999542236328125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:38:"app\modules\core\models\CrugeUserQuery";}i:3;a:5:{s:4:"time";d:1794983700.68611907958984375;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:4;a:5:{s:4:"time";d:1794983700.709886074066162109375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"app\modules\core\models\CrugeUser";}i:5;a:5:{s:4:"time";d:1794983700.7099440097808837890625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"app\modules\core\models\CrugeUser";}i:6;a:5:{s:4:"time";d:1794983700.71006107330322265625;s:4:"name";s:11:"beforeLogin";s:5:"class";s:17:"yii\web\UserEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\User";}i:7;a:5:{s:4:"time";d:1794983700.713169097900390625;s:4:"name";s:10:"afterLogin";s:5:"class";s:17:"yii\web\UserEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\User";}i:8;a:5:{s:4:"time";d:1794983700.7132289409637451171875;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:29:"app\modules\apiv1\Apiv1Module";}i:9;a:5:{s:4:"time";d:1794983700.7140629291534423828125;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:44:"app\modules\apiv1\controllers\SaleController";}i:10;a:5:{s:4:"time";d:1794983700.71700000762939453125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"app\modules\core\models\SaleQuery";}i:11;a:5:{s:4:"time";d:1794983700.71827602386474609375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:41:"app\modules\apiv1\models\entities\SaleAdm";}i:12;a:5:{s:4:"time";d:1794983700.719400882720947265625;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:1794983700.73511505126953125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:14;a:5:{s:4:"time";d:1794983700.745521068572998046875;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:15;a:5:{s:4:"time";d:1794983700.798038005828857421875;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:1794983700.812467098236083984375;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:17;a:5:{s:4:"time";d:1794983700.820889949798583984375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:37:"app\modules\core\models\PaymentMethod";}i:18;a:5:{s:4:"time";d:1794983700.8435819149017333984375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:37:"app\modules\core\models\PaymentMethod";}i:19;a:5:{s:4:"time";d:1794983700.8436000347137451171875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:37:"app\modules\core\models\PaymentMethod";}i:20;a:5:{s:4:"time";d:1794983700.8436129093170166015625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:37:"app\modules\core\models\PaymentMethod";}i:21;a:5:{s:4:"time";d:1794983700.843615055084228515625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:37:"app\modules\core\models\PaymentMethod";}i:22;a:5:{s:4:"time";d:1794983700.843616962432861328125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:37:"app\modules\core\models\PaymentMethod";}i:23;a:5:{s:4:"time";d:1794983700.843902111053466796875;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:24;a:5:{s:4:"time";d:1794983700.863667011260986328125;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:25;a:5:{s:4:"time";d:1794983700.8637230396270751953125;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:1794983700.8960659503936767578125;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:44:"app\modules\apiv1\controllers\SaleController";}i:27;a:5:{s:4:"time";d:1794983700.89665508270263671875;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:29:"app\modules\apiv1\Apiv1Module";}i:28;a:5:{s:4:"time";d:1794983700.8966639041900634765625;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:29;a:5:{s:4:"time";d:1794983700.8966720104217529296875;s:4:"name";s:12:"afterRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:30;a:5:{s:4:"time";d:1794983700.896678924560546875;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:31;a:5:{s:4:"time";d:1794983700.897017002105712890625;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:32;a:5:{s:4:"time";d:1794983700.8970959186553955078125;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:122:"a:3:{s:5:"start";d:1794983700.614348888397216796875;s:3:"end";d:1794983700.8995530605316162109375;s:6:"memory";i:9430896;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:1556:"a:3:{s:8:"messages";a:7:{i:5;a:6:{i:0;a:3:{s:4:"rule";s:3:"gii";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1794983700.6542799472808837890625;i:4;a:0:{}i:5;i:4285560;}i:6;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/<id:\w+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1794983700.6542909145355224609375;i:4;a:0:{}i:5;i:4286312;}i:7;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1794983700.65429592132568359375;i:4;a:0:{}i:5;i:4287064;}i:8;a:6:{i:0;a:3:{s:4:"rule";s:5:"debug";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1794983700.6542999744415283203125;i:4;a:0:{}i:5;i:4287816;}i:9;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1794983700.654304027557373046875;i:4;a:0:{}i:5;i:4288888;}i:10;a:6:{i:0;a:3:{s:4:"rule";s:5:"class";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1794983700.654306888580322265625;i:4;a:0:{}i:5;i:4289640;}i:11;a:6:{i:0;s:55:"No matching URL rules. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1794983700.6543090343475341796875;i:4;a:0:{}i:5;i:4290016;}}s:5:"route";s:16:"apiv1/sale/index";s:6:"action";s:59:"app\modules\apiv1\controllers\SaleController::actionIndex()";}";s:7:"request";s:5889:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:23:{s:8:"priority";s:6:"u=1, i";s:18:"sec-ch-ua-platform";s:9:""Windows"";s:13:"authorization";s:327:"Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiIsImp0aSI6IlVOSVFVRS1KV1QtSURFTlRJRklFUiJ9.eyJpc3MiOiJodHRwczpcL1wvYXBpLmV4YW1wbGUuY29tIiwiYXVkIjoiaHR0cHM6XC9cL2Zyb250ZW5kLmV4YW1wbGUuY29tIiwianRpIjoiVU5JUVVFLUpXVC1JREVOVElGSUVSIiwiaWF0IjoxNzk0OTY5MjE4LCJleHAiOjE3OTUwNTU2MTgsInVpZCI6Mjc3OH0.gyQ9xt3Jb2PY483QddnY-CW-eMQMLbsddndXREQXUSY";s:10:"user-agent";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/157.0.0.0 Safari/537.36";s:6:"accept";s:33:"application/json, text/plain, */*";s:9:"sec-ch-ua";s:65:""Not-A.Brand";v="99", "Google Chrome";v="157", "Chromium";v="157"";s:12:"content-type";s:16:"application/json";s:16:"sec-ch-ua-mobile";s:2:"?0";s:6:"origin";s:26:"https://farmacia.velooz.io";s:14:"sec-fetch-site";s:9:"same-site";s:14:"sec-fetch-mode";s:4:"cors";s:14:"sec-fetch-dest";s:5:"empty";s:7:"referer";s:27:"https://farmacia.velooz.io/";s:15:"accept-encoding";s:8:"gzip, br";s:15:"accept-language";s:27:"es-419,es-VE;q=0.9,es;q=0.8";s:10:"connection";s:10:"Keep-Alive";s:6:"cf-ray";s:20:"a5c4f3e05d1aec05-GRU";s:8:"cdn-loop";s:19:"cloudflare; loops=1";s:16:"cf-connecting-ip";s:13:"45.226.35.232";s:12:"cf-ipcountry";s:2:"BO";s:10:"cf-visitor";s:18:"{"scheme":"https"}";s:14:"content-length";s:1:"2";s:4:"host";s:26:"farmacia-apirest.velooz.io";}s:15:"responseHeaders";a:8:{s:12:"X-Powered-By";s:9:"PHP/7.3.0";s:27:"Access-Control-Allow-Origin";s:26:"https://farmacia.velooz.io";s:32:"Access-Control-Allow-Credentials";s:4:"true";s:29:"Access-Control-Expose-Headers";s:25:"X-Pagination-Current-Page";s:28:"Access-Control-Allow-Headers";s:45:"authorization, X-Requested-With, content-type";s:4:"Vary";s:6:"Accept";s:12:"Content-Type";s:31:"application/json; charset=UTF-8";s:10:"Set-Cookie";s:204:"_csrf=f0f97430bd7dedd8b50a03008c596506e236ce6d86ab11e580c933ed3b5cd3e2a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%220j2CoxauXjCg4SWX9WDZhKPoo_H55LeC%22%3B%7D; path=/; HttpOnly; SameSite=Lax";}s:5:"route";s:16:"apiv1/sale/index";s:6:"action";s:59:"app\modules\apiv1\controllers\SaleController::actionIndex()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:3:"PUT";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:3:{s:12:"Content Type";s:16:"application/json";s:3:"Raw";s:2:"{}";s:7:"Decoded";a:0:{}}s:6:"SERVER";a:57:{s:18:"REDIRECT_UNIQUE_ID";s:27:"av1HFPdwoCRCApw-tuwlNwAAABU";s:14:"REDIRECT_HTTPS";s:2:"on";s:20:"REDIRECT_SSL_TLS_SNI";s:26:"farmacia-apirest.velooz.io";s:15:"REDIRECT_STATUS";s:3:"200";s:9:"UNIQUE_ID";s:27:"av1HFPdwoCRCApw-tuwlNwAAABU";s:5:"HTTPS";s:2:"on";s:11:"SSL_TLS_SNI";s:26:"farmacia-apirest.velooz.io";s:13:"HTTP_PRIORITY";s:6:"u=1, i";s:20:"HTTP_X_FORWARDED_FOR";s:13:"45.226.35.232";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:9:""Windows"";s:15:"HTTP_USER_AGENT";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/157.0.0.0 Safari/537.36";s:11:"HTTP_ACCEPT";s:33:"application/json, text/plain, */*";s:14:"HTTP_SEC_CH_UA";s:65:""Not-A.Brand";v="99", "Google Chrome";v="157", "Chromium";v="157"";s:12:"CONTENT_TYPE";s:16:"application/json";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?0";s:11:"HTTP_ORIGIN";s:26:"https://farmacia.velooz.io";s:19:"HTTP_SEC_FETCH_SITE";s:9:"same-site";s:19:"HTTP_SEC_FETCH_MODE";s:4:"cors";s:19:"HTTP_SEC_FETCH_DEST";s:5:"empty";s:12:"HTTP_REFERER";s:27:"https://farmacia.velooz.io/";s:20:"HTTP_ACCEPT_ENCODING";s:8:"gzip, br";s:20:"HTTP_ACCEPT_LANGUAGE";s:27:"es-419,es-VE;q=0.9,es;q=0.8";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:11:"HTTP_CF_RAY";s:20:"a5c4f3e05d1aec05-GRU";s:13:"HTTP_CDN_LOOP";s:19:"cloudflare; loops=1";s:21:"HTTP_CF_CONNECTING_IP";s:13:"45.226.35.232";s:17:"HTTP_CF_IPCOUNTRY";s:2:"BO";s:15:"HTTP_CF_VISITOR";s:18:"{"scheme":"https"}";s:22:"HTTP_X_FORWARDED_PROTO";s:5:"https";s:14:"CONTENT_LENGTH";s:1:"2";s:9:"HTTP_HOST";s:26:"farmacia-apirest.velooz.io";s:4:"PATH";s:98:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin";s:15:"LD_LIBRARY_PATH";s:29:"/opt/lampp/lib:/opt/lampp/lib";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:77:"Apache/2.4.37 (Unix) OpenSSL/1.0.2q PHP/7.3.0 mod_perl/2.0.8-dev Perl/v5.16.3";s:11:"SERVER_NAME";s:26:"farmacia-apirest.velooz.io";s:11:"SERVER_ADDR";s:12:"2.24.217.134";s:11:"SERVER_PORT";s:3:"443";s:11:"REMOTE_ADDR";s:13:"104.22.182.11";s:13:"DOCUMENT_ROOT";s:34:"/opt/lampp/htdocs/farmacia.apirest";s:14:"REQUEST_SCHEME";s:5:"https";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:34:"/opt/lampp/htdocs/farmacia.apirest";s:12:"SERVER_ADMIN";s:15:"you@example.com";s:15:"SCRIPT_FILENAME";s:48:"/opt/lampp/htdocs/farmacia.apirest/web/index.php";s:11:"REMOTE_PORT";s:5:"12902";s:12:"REDIRECT_URL";s:15:"/web/apiv1/sale";s:21:"REDIRECT_QUERY_STRING";s:97:"page=1&pageSize=25&filter=0&start=2026-11-18+00:00:00&end=2026-11-18+23:59:59&idsiatBranchs=[310]";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:3:"PUT";s:12:"QUERY_STRING";s:97:"page=1&pageSize=25&filter=0&start=2026-11-18+00:00:00&end=2026-11-18+23:59:59&idsiatBranchs=[310]";s:11:"REQUEST_URI";s:113:"/web/apiv1/sale?page=1&pageSize=25&filter=0&start=2026-11-18+00:00:00&end=2026-11-18+23:59:59&idsiatBranchs=[310]";s:11:"SCRIPT_NAME";s:14:"/web/index.php";s:8:"PHP_SELF";s:14:"/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1794983700.6070001125335693359375;s:12:"REQUEST_TIME";i:1794983700;}s:3:"GET";a:6:{s:4:"page";s:1:"1";s:8:"pageSize";s:2:"25";s:6:"filter";s:1:"0";s:5:"start";s:19:"2026-11-18 00:00:00";s:3:"end";s:19:"2026-11-18 23:59:59";s:13:"idsiatBranchs";s:5:"[310]";}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:4:"user";s:2441:"a:5:{s:2:"id";i:2778;s:8:"identity";a:22:{s:6:"iduser";s:4:"2778";s:7:"regdate";s:4:"null";s:7:"actdate";s:10:"1760476584";s:9:"logondate";s:10:"1763581318";s:8:"username";s:28:"'farmacia_medicenter_angela'";s:5:"email";s:40:"'pamelagabrielaalconfernandez@gmail.com'";s:8:"password";s:34:"'4c31042c10624c84fd8ac705b275646b'";s:7:"authkey";s:4:"null";s:5:"state";s:1:"1";s:19:"totalsessioncounter";s:1:"0";s:21:"currentsessioncounter";s:1:"0";s:8:"temporal";s:5:"false";s:8:"fullname";s:24:"'ANGELA GONZALES CHAGAS'";s:4:"name";s:8:"'ANGELA'";s:8:"lastname";s:8:"'CHAGAS'";s:7:"surname";s:10:"'GONZALES'";s:13:"resetPassword";s:4:"true";s:5:"phone";s:2:"''";s:21:"recoveryTokenPassword";s:4:"null";s:4:"role";s:4:"null";s:6:"idrole";s:2:"75";s:10:"superAdmin";s:5:"false";}s:10:"attributes";a:22:{i:0;a:2:{s:9:"attribute";s:6:"iduser";s:5:"label";s:7:"ID User";}i:1;a:2:{s:9:"attribute";s:7:"regdate";s:5:"label";s:17:"Registration Date";}i:2;a:2:{s:9:"attribute";s:7:"actdate";s:5:"label";s:15:"Activation Date";}i:3;a:2:{s:9:"attribute";s:9:"logondate";s:5:"label";s:10:"Logon Date";}i:4;a:2:{s:9:"attribute";s:8:"username";s:5:"label";s:8:"Username";}i:5;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:5:"Email";}i:6;a:2:{s:9:"attribute";s:8:"password";s:5:"label";s:8:"Password";}i:7;a:2:{s:9:"attribute";s:7:"authkey";s:5:"label";s:8:"Auth Key";}i:8;a:2:{s:9:"attribute";s:5:"state";s:5:"label";s:5:"State";}i:9;a:2:{s:9:"attribute";s:19:"totalsessioncounter";s:5:"label";s:21:"Total Session Counter";}i:10;a:2:{s:9:"attribute";s:21:"currentsessioncounter";s:5:"label";s:23:"Current Session Counter";}i:11;a:2:{s:9:"attribute";s:8:"temporal";s:5:"label";s:8:"Temporal";}i:12;a:2:{s:9:"attribute";s:8:"fullname";s:5:"label";s:9:"Full Name";}i:13;a:2:{s:9:"attribute";s:4:"name";s:5:"label";s:4:"Name";}i:14;a:2:{s:9:"attribute";s:8:"lastname";s:5:"label";s:9:"Last Name";}i:15;a:2:{s:9:"attribute";s:7:"surname";s:5:"label";s:7:"Surname";}i:16;a:2:{s:9:"attribute";s:13:"resetPassword";s:5:"label";s:14:"Reset Password";}i:17;a:2:{s:9:"attribute";s:5:"phone";s:5:"label";s:5:"Phone";}i:18;a:2:{s:9:"attribute";s:21:"recoveryTokenPassword";s:5:"label";s:23:"Recovery Token Password";}i:19;a:2:{s:9:"attribute";s:4:"role";s:5:"label";s:4:"Role";}i:20;a:2:{s:9:"attribute";s:6:"idrole";s:5:"label";s:6:"idrole";}i:21;a:2:{s:9:"attribute";s:10:"superAdmin";s:5:"label";s:10:"superAdmin";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6afd47149eade";s:3:"url";s:147:"https://farmacia-apirest.velooz.io/web/apiv1/sale?page=1&pageSize=25&filter=0&start=2026-11-18+00:00:00&end=2026-11-18+23:59:59&idsiatBranchs=[310]";s:4:"ajax";i:0;s:6:"method";s:3:"PUT";s:2:"ip";s:13:"104.22.182.11";s:4:"time";d:1794983700.6070001125335693359375;s:10:"statusCode";i:200;s:8:"sqlCount";i:0;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:9430896;s:14:"processingTime";d:0.285064220428466796875;}s:10:"exceptions";a:0:{}}