6a1d2fb819075: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-assets at 2026-06-01 03:07:36 pm by 43.224.72.82
Log Messages
总计319条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 15:07:36.101 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:07:36.101 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:07:36.102 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:07:36.102 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:07:36.103 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:07:36.103 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:07:36.103 | info | time tracing start | 1780297656103853824 |
| 15:07:36.104 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:07:36.104 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-analysis/list-assets' |
| 15:07:36.104 | trace | yii\base\Module::getModule | Loading module: vue |
| 15:07:36.106 | info | yii\web\Session::open | Session started |
| 15:07:36.107 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5495 |
| 15:07:36.113 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:07:36.119 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:07:36.120 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:07:36.120 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:07:36.121 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:07:36.121 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495 |
| 15:07:36.124 | trace | yii\base\Controller::runAction | Route to run: vue/erp-analysis/list-assets |
| 15:07:36.125 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:07:36.125 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:07:36.126 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewErpAsset |
| 15:07:36.126 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:07:36.126 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Treasurer |
| 15:07:36.126 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpAnalysisController::actionListAssets() |
| 15:07:36.127 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_settles" WHERE ("date"='2026-6-01') AND ("is_settle"=TRUE) |
| 15:07:36.132 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE) |
| 15:07:36.139 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE ("type"=1) AND (parent_id is null) AND ("is_delete"=FALSE) ORDER BY "is_current" DESC, "sort", "id" |
| 15:07:36.144 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "parent_id" IN (1, 3, 4, 5, 6, 7, 74, 8, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) |
| 15:07:36.145 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.145 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.146 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.148 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.149 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.149 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.152 | info | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "o6a13e2c574d5a"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=73 |
| 15:07:36.157 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:07:36.157 | 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_banks' and d.nspname = 'o6a13e2c574d5a' ORDER BY a.attnum; |
| 15:07:36.163 | 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_banks' and ns.nspname='o6a13e2c574d5a' order by fns.nspname, fc.relname, a.attnum |
| 15:07:36.178 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:07:36.178 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 15:07:36.178 | info | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "o6a13e2c574d5a"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=73 |
| 15:07:36.179 | info | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "o6a13e2c574d5a"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=1 |
| 15:07:36.180 | info | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "o6a13e2c574d5a"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=1 |
| 15:07:36.181 | info | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "o6a13e2c574d5a"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=71 |
| 15:07:36.182 | info | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "o6a13e2c574d5a"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=71 |
| 15:07:36.183 | info | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "o6a13e2c574d5a"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=72 |
| 15:07:36.184 | info | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "o6a13e2c574d5a"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=72 |
| 15:07:36.185 | info | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "o6a13e2c574d5a"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=0 |
| 15:07:36.185 | info | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "o6a13e2c574d5a"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "o6a13e2c574d5a"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=0 |
| 15:07:36.186 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:07:36.186 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:07:36.186 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1101' |
| 15:07:36.187 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:07:36.187 | 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_account_captions' and d.nspname = 'o6a13e2c574d5a' ORDER BY a.attnum; |
| 15:07:36.190 | 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_account_captions' and ns.nspname='o6a13e2c574d5a' order by fns.nspname, fc.relname, a.attnum |
| 15:07:36.203 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:07:36.203 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 15:07:36.203 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1421' |
| 15:07:36.203 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1121' |
| 15:07:36.204 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=TRUE) |
| 15:07:36.205 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" WHERE ("cost_type"=1) AND ("t"."created_at" < '2025-08-08 14:34:58') AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = true) |
| 15:07:36.209 | info | yii\db\Command::query | SELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "o6a13e2c574d5a"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount >= COALESCE(sub.amount, 0)) |
| 15:07:36.219 | info | yii\db\Command::query | SELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "o6a13e2c574d5a"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE ("cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount < COALESCE(sub.amount, 0)) |
| 15:07:36.225 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=TRUE) |
| 15:07:36.225 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" WHERE ("cost_type"=1) AND ("t"."created_at" < '2025-08-08 14:34:58') AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = true) |
| 15:07:36.226 | info | yii\db\Command::query | SELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "o6a13e2c574d5a"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount >= COALESCE(sub.amount, 0)) |
| 15:07:36.228 | info | yii\db\Command::query | SELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "o6a13e2c574d5a"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE ("cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount < COALESCE(sub.amount, 0)) |
| 15:07:36.229 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"=112200 |
| 15:07:36.233 | info | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND ("t"."created_at" >= '2026-05-26 09:52:08') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true)) |
| 15:07:36.242 | info | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND ("t"."created_at" >= '2026-05-26 09:52:08') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND ("t"."created_at" >= '2026-05-26 09:52:08') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true)) |
| 15:07:36.253 | info | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2026-05-26 09:52:08') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true)) |
| 15:07:36.256 | info | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2026-05-26 09:52:08') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2026-05-26 09:52:08') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true)) |
| 15:07:36.259 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("is_payment_settle"=TRUE) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.261 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2026-06-30 23:59:59') |
| 15:07:36.264 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2026-06-30 23:59:59') |
| 15:07:36.266 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("is_payment_settle"=TRUE) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.266 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2025-12-31 23:59:59') |
| 15:07:36.267 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2025-12-31 23:59:59') |
| 15:07:36.267 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (is_start = true) |
| 15:07:36.268 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND (is_start = false) |
| 15:07:36.268 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_other_collect_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.268 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_other_collect_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.270 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE (r.erp_other_collect_ticket_id is not null) AND ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.272 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.erp_other_collect_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.272 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (is_start = true) |
| 15:07:36.272 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND (is_start = false) |
| 15:07:36.273 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_other_collect_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.273 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_other_collect_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.273 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE (r.erp_other_collect_ticket_id is not null) AND ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.274 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.erp_other_collect_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.276 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_starts" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59' |
| 15:07:36.279 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.280 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.282 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.283 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.284 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_purchase_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.285 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.288 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.290 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_losts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_lost_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.291 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.292 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_builds" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_build_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.292 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_disassembles" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_disassemble_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.293 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_starts" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59' |
| 15:07:36.293 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.293 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.294 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.294 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.294 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_purchase_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.295 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.295 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.296 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_losts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_lost_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.296 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.296 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_builds" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_build_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.297 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_disassembles" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_disassemble_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.297 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1481' |
| 15:07:36.298 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1501' |
| 15:07:36.298 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1401' |
| 15:07:36.298 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1503' |
| 15:07:36.299 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1502' |
| 15:07:36.299 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1506' |
| 15:07:36.299 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1511' |
| 15:07:36.300 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1521' |
| 15:07:36.300 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1601' |
| 15:07:36.300 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1604' |
| 15:07:36.300 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1621' |
| 15:07:36.301 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1701' |
| 15:07:36.301 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1531' |
| 15:07:36.302 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1702' |
| 15:07:36.302 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1711' |
| 15:07:36.302 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"=1801 |
| 15:07:36.303 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1811' |
| 15:07:36.303 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='1901' |
| 15:07:36.303 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE ("type"=2) AND (parent_id is null) ORDER BY "is_current" DESC, "sort", "id" |
| 15:07:36.304 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "parent_id" IN (31, 32, 33, 34, 35, 75, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49) |
| 15:07:36.304 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.305 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.305 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.305 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.305 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.306 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.307 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."ticket_type"=3) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.308 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.310 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.311 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."ticket_type"=3) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.311 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.312 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.313 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2101' |
| 15:07:36.313 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2102' |
| 15:07:36.313 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2201' |
| 15:07:36.314 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("t"."cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = false) |
| 15:07:36.314 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=FALSE) |
| 15:07:36.315 | info | yii\db\Command::query | SELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "o6a13e2c574d5a"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount < COALESCE(sub.amount, 0)) |
| 15:07:36.316 | info | yii\db\Command::query | SELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "o6a13e2c574d5a"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."cost_type"=1) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount >= COALESCE(sub.amount, 0)) |
| 15:07:36.318 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("t"."cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = false) |
| 15:07:36.319 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=FALSE) |
| 15:07:36.319 | info | yii\db\Command::query | SELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "o6a13e2c574d5a"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount < COALESCE(sub.amount, 0)) |
| 15:07:36.321 | info | yii\db\Command::query | SELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "o6a13e2c574d5a"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."cost_type"=1) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount >= COALESCE(sub.amount, 0)) |
| 15:07:36.323 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"=220200 |
| 15:07:36.323 | info | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true)) |
| 15:07:36.326 | info | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true)) |
| 15:07:36.329 | info | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "o6a13e2c574d5a"."tbl_purchase_contracts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true)) |
| 15:07:36.332 | info | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2026-05-26 09:52:08') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true)) |
| 15:07:36.335 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2203' |
| 15:07:36.335 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.337 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("r"."settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.339 | info | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.341 | info | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.342 | info | yii\db\Command::query | SELECT SUM(personal_amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.344 | info | yii\db\Command::query | SELECT SUM(personal_amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.344 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.345 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("r"."settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.345 | info | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.346 | info | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.346 | info | yii\db\Command::query | SELECT SUM(personal_amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.347 | info | yii\db\Command::query | SELECT SUM(personal_amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.347 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.348 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.348 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.349 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.349 | info | yii\db\Command::query | SELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.349 | info | yii\db\Command::query | SELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.350 | info | yii\db\Command::query | SELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.350 | info | yii\db\Command::query | SELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.351 | info | yii\db\Command::query | SELECT SUM(company_amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.351 | info | yii\db\Command::query | SELECT SUM(company_amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.352 | info | yii\db\Command::query | SELECT SUM(company_amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.352 | info | yii\db\Command::query | SELECT SUM(company_amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.355 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.359 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.360 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.361 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.363 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.363 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.364 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.365 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.365 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.365 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.366 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND (is_start = true) |
| 15:07:36.366 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND (is_start = false) |
| 15:07:36.367 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.367 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.368 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.368 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.369 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.369 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.370 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.370 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND (is_start = true) |
| 15:07:36.371 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND (is_start = false) |
| 15:07:36.371 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.372 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.372 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.373 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.373 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.374 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.374 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.375 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2245' |
| 15:07:36.375 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2231' |
| 15:07:36.376 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2242' |
| 15:07:36.376 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2701' |
| 15:07:36.376 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2801' |
| 15:07:36.377 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2401' |
| 15:07:36.377 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2401' |
| 15:07:36.377 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='2503' |
| 15:07:36.378 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE ("type"=3) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:07:36.378 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56) |
| 15:07:36.379 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.379 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.379 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.380 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.380 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.380 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.380 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='4001' |
| 15:07:36.381 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='4002' |
| 15:07:36.381 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"=4104 |
| 15:07:36.382 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.382 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.382 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.383 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.385 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.385 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_other_income_ticket_id is not null) AND ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.386 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.386 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" >= '2026-05-26 09:52:08') AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.386 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.387 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.387 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.387 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.388 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.388 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.388 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.389 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.389 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.389 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.390 | info | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.390 | info | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.390 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.391 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.391 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.392 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:07:36.393 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:07:36.394 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.394 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.395 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.395 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.396 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.396 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_other_income_ticket_id is not null) AND ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.397 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.397 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" >= '2026-05-26 09:52:08') AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.397 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.397 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.398 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.398 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.398 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.399 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.399 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.399 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.400 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.400 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.400 | info | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.401 | info | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.401 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.401 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.402 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.403 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:07:36.404 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:07:36.404 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='6111' |
| 15:07:36.405 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "serial_no"='4301' |
| 15:07:36.405 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE ("type"=1) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:07:36.406 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "parent_id" IN (1, 3, 4, 5, 6, 7, 74, 8, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) |
| 15:07:36.406 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.407 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.407 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.407 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.408 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.408 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.408 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_collect_tickets" "t" WHERE "is_start"=TRUE |
| 15:07:36.408 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_inventory_starts" "t" |
| 15:07:36.409 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE ("type"=2) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:07:36.409 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "parent_id" IN (31, 32, 33, 34, 35, 75, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49) |
| 15:07:36.410 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.410 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.410 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.411 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.411 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.411 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.412 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_payment_tickets" "t" WHERE "is_start"=TRUE |
| 15:07:36.412 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE ("type"=3) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:07:36.412 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56) |
| 15:07:36.413 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.413 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.413 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.414 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:07:36.414 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:07:36.414 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:07:36.416 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:07:36.416 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:07:36.417 | 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 (200, 'o6a13e2c574d5a', 5495, 5, 'vue/erp-analysis/list-assets', '{"year":"2026","month":"6","hide":"1","web_access_token":"BVNSh9YfxWIaBBEpqELLGqJuWOoESJvj"}', '{"code":2000,"result":{"list":[{"title":"\u8d44\u4ea7\u7c7b","type":1,"serial_no":"","parent_id":"","amount":"","balance_amount":0,"actual_amount":"","last_actual_amount":"","description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":1,"parent_id":"","title":"\u5e93\u5b58\u73b0\u91d1","serial_no":"1001","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[{"id":73,"parent_id":1,"title":"\u73b0\u91d1","serial_no":"100101","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3}],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":3,"parent_id":"","title":"\u5168\u90e8\u94f6\u884c\u8d26\u6237","serial_no":"1002","amount":"0","balance_amount":"0","actual_amount":99999998100,"description":"","type":1,"sort":2,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[{"id":71,"parent_id":3,"title":"\u652f\u4ed8\u5b9d","serial_no":"100201","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":72,"parent_id":3,"title":"\u94f6\u884c\u5b58\u6b3e","serial_no":"100202","amount":"100000000000","balance_amount":"99999998100","actual_amount":99999998100,"description":"","type":1,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-27 14:09:47","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3}],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"can_stop":false,"index":2},{"id":4,"parent_id":"","title":"\u4ee5\u516c\u5141\u4ef7\u503c\u8ba1\u91cf\u4e14\u5176\u53d8\u52a8\u8ba1\u5165\u5f53\u671f\u635f\u76ca\u7684\u91d1\u878d\u8d44\u4ea7","serial_no":"1101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":3,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":5,"parent_id":"","title":"\u884d\u751f\u91d1\u878d\u8d44\u4ea7","serial_no":"1421","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":4,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":6,"parent_id":"","title":"\u5e94\u6536\u7968\u636e","serial_no":"1121","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":7,"parent_id":"","title":"\u5e94\u6536\u8d26\u6b3e(\u9500\u552e\u5408\u540c)","serial_no":"1122","amount":"0","balance_amount":"0","actual_amount":10000,"description":"","type":1,"sort":6,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"can_stop":false,"index":2},{"id":74,"parent_id":"","title":"\u5e94\u6536\u8d26\u6b3e(\u9500\u552e\u51fa\u5e93\u5355)","serial_no":"112200","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":7,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":8,"parent_id":"","title":"\u9884\u4ed8\u6b3e\u9879","serial_no":"1123","amount":"0","balance_amount":"0","actual_amount":"0.0000000000","description":"","type":1,"sort":8,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":"0.0000000000","can_stop":false,"index":2},{"id":11,"parent_id":"","title":"\u5176\u4ed6\u5e94\u6536\u6b3e","serial_no":"1132","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":11,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":12,"parent_id":"","title":"\u5b58\u8d27","serial_no":"1221","amount":"0","balance_amount":"0","actual_amount":400,"description":"","type":1,"sort":12,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"can_stop":false,"index":2},{"id":13,"parent_id":"","title":"\u6301\u6709\u5f85\u552e\u8d44\u4ea7","serial_no":"1481","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":13,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":14,"parent_id":"","title":"\u4e00\u5e74\u5185\u5230\u671f\u7684\u975e\u6d41\u52a8\u8d44\u4ea7","serial_no":"1501","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":14,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":15,"parent_id":"","title":"\u5176\u4ed6\u6d41\u52a8\u8d44\u4ea7","serial_no":"1401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":15,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"title":"\u6d41\u52a8\u8d44\u4ea7\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":99999998500,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":16,"parent_id":"","title":"\u53ef\u4f9b\u51fa\u552e\u91d1\u878d\u8d44\u4ea7","serial_no":"1503","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":16,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":17,"parent_id":"","title":"\u6301\u6709\u81f3\u5230\u671f\u6295\u8d44","serial_no":"1502","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":17,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":18,"parent_id":"","title":"\u957f\u671f\u5e94\u6536\u6b3e","serial_no":"1506","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":18,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":19,"parent_id":"","title":"\u957f\u671f\u80a1\u6743\u6295\u8d44","serial_no":"1511","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":19,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":20,"parent_id":"","title":"\u6295\u8d44\u6027\u623f\u5730\u4ea7","serial_no":"1521","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":20,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":21,"parent_id":"","title":"\u56fa\u5b9a\u8d44\u4ea7","serial_no":"1601","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":21,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":22,"parent_id":"","title":"\u5728\u5efa\u5de5\u7a0b","serial_no":"1604","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":22,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":23,"parent_id":"","title":"\u751f\u4ea7\u6027\u751f\u7269\u8d44\u4ea7","serial_no":"1621","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":23,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":24,"parent_id":"","title":"\u65e0\u5f62\u8d44\u4ea7","serial_no":"1701","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":24,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":25,"parent_id":"","title":"\u6cb9\u6c14\u8d44\u4ea7","serial_no":"1531","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":25,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":26,"parent_id":"","title":"\u5f00\u53d1\u652f\u51fa","serial_no":"1702","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":26,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":27,"parent_id":"","title":"\u5546\u8a89","serial_no":"1711","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":27,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":28,"parent_id":"","title":"\u957f\u671f\u5f85\u644a\u8d39\u7528","serial_no":"1801","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":28,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":29,"parent_id":"","title":"\u9012\u5ef6\u6240\u5f97\u7a0e\u8d44\u4ea7","serial_no":"1811","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":29,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":30,"parent_id":"","title":"\u5176\u4ed6\u975e\u6d41\u52a8\u8d44\u4ea7","serial_no":"1901","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":30,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"title":"\u975e\u6d41\u52a8\u8d44\u4ea7\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":0,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"title":"\u8d44\u4ea7\u603b\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":99999998500,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1}],"list2":[{"title":"\u8d1f\u503a\u7c7b","type":2,"serial_no":"","parent_id":"","amount":"","balance_amount":0,"actual_amount":"","last_actual_amount":"","description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":31,"parent_id":"","title":"\u77ed\u671f\u501f\u6b3e","serial_no":"2001","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":32,"parent_id":"","title":"\u4ee5\u516c\u5141\u4ef7\u503c\u8ba1\u91cf\u4e14\u5176\u53d8\u52a8\u8ba1\u5165\u5f53\u671f\u635f\u76ca\u7684\u91d1\u878d\u8d1f\u503a","serial_no":"2101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":2,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":33,"parent_id":"","title":"\u884d\u751f\u91d1\u878d\u8d1f\u503a","serial_no":"2102","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":3,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":34,"parent_id":"","title":"\u5e94\u4ed8\u7968\u636e","serial_no":"2201","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":4,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":35,"parent_id":"","title":"\u5e94\u4ed8\u8d26\u6b3e(\u91c7\u8d2d\u5408\u540c)","serial_no":"2202","amount":"0","balance_amount":"0","actual_amount":1470,"description":"","type":2,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"can_stop":false,"index":2},{"id":75,"parent_id":"","title":"\u5e94\u4ed8\u8d26\u6b3e(\u91c7\u8d2d\u5165\u5e93\u5355)","serial_no":"220200","amount":"0","balance_amount":"0","actual_amount":400,"description":"","type":2,"sort":6,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"can_stop":false,"index":2},{"id":36,"parent_id":"","title":"\u9884\u6536\u6b3e\u9879","serial_no":"2203","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":8,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[{"id":57,"parent_id":37,"title":"\u5e94\u4ed8\u804c\u5de5\u5de5\u8d44","serial_no":"221101","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":58,"parent_id":37,"title":"\u5e94\u4ed8\u5956\u91d1","serial_no":"221102","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":59,"parent_id":37,"title":"\u5e94\u4ed8\u793e\u4f1a\u4fdd\u9669\u8d39","serial_no":"221104","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":4,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":60,"parent_id":37,"title":"\u5e94\u4ed8\u4f4f\u623f\u516c\u79ef\u91d1","serial_no":"221105","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":61,"parent_id":37,"title":"\u5de5\u4f1a\u7ecf\u8d39","serial_no":"221106","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":6,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3}],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":38,"parent_id":"","title":"\u5e94\u4ea4\u7a0e\u8d39","serial_no":"2221","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":9,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[{"id":62,"parent_id":38,"title":"\u5e94\u4ea4\u589e\u503c\u7a0e","serial_no":"222101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":"0","index":3},{"id":63,"parent_id":38,"title":"\u5e94\u4ea4\u4e2a\u7a0e","serial_no":"222102","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3}],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":39,"parent_id":"","title":"\u5176\u4ed6\u5e94\u4ed8\u6b3e","serial_no":"2241","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":10,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":40,"parent_id":"","title":"\u6301\u6709\u5f85\u552e\u8d1f\u503a","serial_no":"2245","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":11,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":41,"parent_id":"","title":"\u4e00\u5e74\u5185\u5230\u671f\u975e\u6d41\u52a8\u8d1f\u503a","serial_no":"2231","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":12,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":42,"parent_id":"","title":"\u5176\u4ed6\u6d41\u52a8\u8d1f\u503a","serial_no":"2242","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":13,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"title":"\u6d41\u52a8\u8d1f\u503a\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":400,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":43,"parent_id":"","title":"\u957f\u671f\u501f\u6b3e","serial_no":"2501","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":14,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":44,"parent_id":"","title":"\u5e94\u4ed8\u503a\u5238","serial_no":"2502","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":15,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[{"id":64,"parent_id":44,"title":"\u4f18\u5148\u80a1","serial_no":"250201","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":"0","index":3},{"id":65,"parent_id":44,"title":"\u6c38\u7eed\u503a","serial_no":"250202","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":"0","index":3}],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":45,"parent_id":"","title":"\u957f\u671f\u5e94\u4ed8\u6b3e","serial_no":"2701","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":16,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":46,"parent_id":"","title":"\u9884\u8ba1\u8d1f\u503a","serial_no":"2801","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":17,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":47,"parent_id":"","title":"\u9012\u5ef6\u6536\u76ca","serial_no":"2401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":18,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":48,"parent_id":"","title":"\u9012\u5ef6\u6240\u5f97\u7a0e\u8d1f\u503a","serial_no":"2401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":19,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":49,"parent_id":"","title":"\u5176\u4ed6\u975e\u6d41\u52a8\u8d1f\u503a","serial_no":"2503","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":20,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"title":"\u975e\u6d41\u52a8\u8d1f\u503a\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":0,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"title":"\u8d1f\u503a\u5408\u8ba1","type":2,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":400,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"title":"\u6240\u6709\u8005\u6743\u76ca\uff08\u6216\u80a1\u4e1c\u6743\u76ca\u7c7b\uff09","type":3,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":"","last_actual_amount":"","description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":50,"parent_id":"","title":"\u5b9e\u6536\u8d44\u672c","serial_no":"4001","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":1,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":51,"parent_id":"","title":"\u8d44\u672c\u516c\u79ef","serial_no":"4002","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":52,"parent_id":"","title":"\u76c8\u4f59\u516c\u79ef","serial_no":"4101","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":3,"sort":3,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[{"id":69,"parent_id":52,"title":"\u6cd5\u5b9a\u76c8\u4f59\u516c\u79ef","serial_no":"410101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":"0","index":3},{"id":70,"parent_id":52,"title":"\u4efb\u610f\u76c8\u4f59\u516c\u79ef","serial_no":"410102","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":"0","index":3}],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":53,"parent_id":"","title":"\u672a\u5206\u914d\u5229\u6da6","serial_no":"4104","amount":"0","balance_amount":"0","actual_amount":-1900,"description":"","type":3,"sort":4,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"can_stop":false,"index":2},{"id":54,"parent_id":"","title":"\u5176\u4ed6\u6743\u76ca\u5de5\u5177","serial_no":"6116","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":3,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[{"id":67,"parent_id":54,"title":"\u4f18\u5148\u80a1","serial_no":"611601","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":"0","index":3},{"id":68,"parent_id":54,"title":"\u6c38\u7eed\u503a","serial_no":"611602","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":"0","index":3}],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":55,"parent_id":"","title":"\u5176\u4ed6\u7efc\u5408\u6536\u76ca","serial_no":"6111","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":6,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":56,"parent_id":"","title":"\u4e13\u9879\u50a8\u5907","serial_no":"4301","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5493,"created_at":"2026-05-26 09:52:08","updated_at":"2026-05-26 09:52:08","child":[],"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":"","department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"title":"\u6240\u6709\u8005\u6743\u76ca\uff08\u6216\u80a1\u4e1c\u6743\u76ca\uff09\u5408\u8ba1","type":3,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":-1900,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1}],"count":{"list1_sum":99999998500,"list2_sum":-1500,"last_list1_sum":0,"last_list2_sum":0,"start_list1_sum":100000000000,"start_list2_sum":0},"show_libra":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 15:07:36', 312797184) RETURNING "id" |
| 15:07:36.421 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:07:36.421 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |