| 15:15:04.700 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:15:04.700 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:15:04.701 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:15:04.701 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:15:04.702 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:15:04.702 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.702 | info | time tracing start | 1781162104702667008 |
| 15:15:04.702 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:15:04.702 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-analysis/list-bank-view' |
| 15:15:04.702 | trace | yii\base\Module::getModule | Loading module: vue |
| 15:15:04.704 | info | yii\web\Session::open | Session started |
| 15:15:04.705 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 15:15:04.705 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:15:04.708 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.708 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:15:04.709 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.709 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:15:04.709 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:15:04.710 | trace | yii\base\Controller::runAction | Route to run: vue/erp-analysis/list-bank-view |
| 15:15:04.710 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.715 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:15:04.715 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpAnalysisController::actionListBankView() |
| 15:15:04.715 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.716 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.718 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='1') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') GROUP BY "l"."id" ORDER BY settle_at DESC) "c" |
| 15:15:04.724 | info | yii\db\Command::query | SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='1') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') GROUP BY "l"."id" ORDER BY settle_at DESC LIMIT 40 |
| 15:15:04.727 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.727 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:15:04.728 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1000, 5252, 5064) |
| 15:15:04.729 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5064, 1000, 5252)) |
| 15:15:04.730 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 10, 6) |
| 15:15:04.731 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 722, 756, 45) |
| 15:15:04.731 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1331, 982, 3432, 3303, 2150, 3278, 3457, 1661) |
| 15:15:04.732 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 15:15:04.733 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" WHERE "erp_bank_amount_change_log_id" IN (1750, 1749, 1748, 1747, 1746, 1745, 1744, 1743, 1740, 1739, 1738, 1737, 1736, 1735, 1734, 1733, 1732, 1731, 1730, 1729, 1728, 1727, 1726, 1725, 1724, 1723, 1722, 1721, 1720, 1719, 1718, 1717, 1716, 1715, 1714, 1713, 1712, 1711, 1710, 1709) |
| 15:15:04.734 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5064, 1000, 5250, 5016, 5461, 5332, 1003, 1011) |
| 15:15:04.735 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8488 |
| 15:15:04.735 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.735 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
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,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') 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
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_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 c.relname = 'tbl_erp_cash_cost_tickets'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 15:15:04.742 | info | yii\db\Command::query | 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='tbl_erp_cash_cost_tickets'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 15:15:04.772 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:15:04.772 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 15:15:04.773 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=8488 ORDER BY "id" |
| 15:15:04.774 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.774 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
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,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') 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
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_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 c.relname = 'tbl_erp_cash_cost_ticket_purchase_contract_settles'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 15:15:04.777 | info | yii\db\Command::query | 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='tbl_erp_cash_cost_ticket_purchase_contract_settles'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 15:15:04.795 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:15:04.796 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 15:15:04.796 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4475 |
| 15:15:04.797 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.797 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:15:04.798 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8487 |
| 15:15:04.798 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=8487 ORDER BY "id" |
| 15:15:04.808 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4475 |
| 15:15:04.818 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8485 |
| 15:15:04.828 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=8485 ORDER BY "id" |
| 15:15:04.836 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4475 |
| 15:15:04.849 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8486 |
| 15:15:04.864 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=8486 ORDER BY "id" |
| 15:15:04.870 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4475 |
| 15:15:04.871 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8484 |
| 15:15:04.872 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=8484 ORDER BY "id" |
| 15:15:04.872 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4482 |
| 15:15:04.873 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=2198 |
| 15:15:04.877 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.877 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
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,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') 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
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_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 c.relname = 'tbl_erp_collect_tickets'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 15:15:04.881 | info | yii\db\Command::query | 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='tbl_erp_collect_tickets'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 15:15:04.917 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:15:04.917 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 15:15:04.917 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=2198 ORDER BY "id" |
| 15:15:04.919 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.919 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
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,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') 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
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_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 c.relname = 'tbl_erp_collect_ticket_settles'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 15:15:04.923 | info | yii\db\Command::query | 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='tbl_erp_collect_ticket_settles'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 15:15:04.947 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:15:04.947 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 15:15:04.948 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4476 |
| 15:15:04.949 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.949 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:15:04.950 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8478 |
| 15:15:04.950 | error | yii\base\ErrorException:8 | yii\base\ErrorException: Trying to get property of non-object in /var/www/beta/modules/vue/controllers/traits/erpanalysis/ErpAnalysisBankTraits.php:737
Stack trace:
#0 /var/www/beta/modules/vue/controllers/traits/erpanalysis/ErpAnalysisBankTraits.php(737): yii\base\ErrorHandler->handleError(8, 'Trying to get p...', '/var/www/beta/m...', 737, Array)
#1 [internal function]: app\modules\vue\controllers\ErpAnalysisController->actionListBankView()
#2 /var/www/beta/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#3 /var/www/beta/vendor/yiisoft/yii2/base/Controller.php(156): yii\base\InlineAction->runWithParams(Array)
#4 /var/www/beta/vendor/yiisoft/yii2/base/Module.php(522): yii\base\Controller->runAction('list-bank-view', Array)
#5 /var/www/beta/vendor/yiisoft/yii2/web/Application.php(102): yii\base\Module->runAction('vue/erp-analysi...', Array)
#6 /var/www/beta/vendor/yiisoft/yii2/base/Application.php(379): yii\web\Application->handleRequest(Object(yii\web\Request))
#7 /var/www/beta/web/index.php(32): yii\base\Application->run()
#8 {main} |
| 15:15:04.951 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.951 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:15:04.951 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (500, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-bank-view', '{"created_at_period":"currentfascalyear","not_zero":"","is_delete":"","erp_bank_id":"1","keyword":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":500,"data":null,"status":0,"msg":[{"name":"error","success":"","error":"Trying to get property of non-object","trace":{"name":"PHP Notice","message":"Trying to get property of non-object","code":8,"type":"yii\\base\\ErrorException","file":"\/var\/www\/beta\/modules\/vue\/controllers\/traits\/erpanalysis\/ErpAnalysisBankTraits.php","line":737,"stack-trace":["#0 \/var\/www\/beta\/modules\/vue\/controllers\/traits\/erpanalysis\/ErpAnalysisBankTraits.php(737): yii\\base\\ErrorHandler->handleError(8, ''Trying to get p...'', ''\/var\/www\/beta\/m...'', 737, Array)","#1 [internal function]: app\\modules\\vue\\controllers\\ErpAnalysisController->actionListBankView()","#2 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(57): call_user_func_array(Array, Array)","#3 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Controller.php(156): yii\\base\\InlineAction->runWithParams(Array)","#4 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Module.php(522): yii\\base\\Controller->runAction(''list-bank-view'', Array)","#5 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/web\/Application.php(102): yii\\base\\Module->runAction(''vue\/erp-analysi...'', Array)","#6 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Application.php(379): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#7 \/var\/www\/beta\/web\/index.php(32): yii\\base\\Application->run()","#8 {main}"]}}]}', TRUE, '2026-06-11 15:15:04', 248902912) RETURNING "id" |
| 15:15:04.956 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:15:04.956 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |