6a3e2e4d250a1: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-assets at 2026-06-26 03:46:21 pm by 221.216.117.25
Log Messages
总计372条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 15:46:21.150 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:46:21.150 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:46:21.151 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:46:21.152 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:46:21.152 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:46:21.153 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:46:21.153 | info | time tracing start | 1782459981153833984 |
| 15:46:21.154 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:46:21.154 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-analysis/list-assets' |
| 15:46:21.154 | trace | yii\base\Module::getModule | Loading module: vue |
| 15:46:21.157 | info | yii\web\Session::open | Session started |
| 15:46:21.159 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 15:46:21.159 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:46:21.168 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:46:21.169 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:46:21.170 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 15:46:21.171 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:46:21.171 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:46:21.172 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:46:21.175 | trace | yii\base\Controller::runAction | Route to run: vue/erp-analysis/list-assets |
| 15:46:21.175 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:46:21.178 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:46:21.178 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpAnalysisController::actionListAssets() |
| 15:46:21.181 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-6-01') AND ("is_settle"=TRUE) |
| 15:46:21.183 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE) |
| 15:46:21.185 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=1) AND (parent_id is null) AND ("is_delete"=FALSE) ORDER BY "is_current" DESC, "sort", "id" |
| 15:46:21.187 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."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:46:21.188 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5064, 1001) |
| 15:46:21.189 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1001, 5064)) |
| 15:46:21.190 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4) |
| 15:46:21.191 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:46:21.191 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:46:21.192 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:46:21.192 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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:46:21.205 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:46:21.205 | 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 = 'a57be577deb434' ORDER BY a.attnum; |
| 15:46:21.212 | 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='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 15:46:21.217 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:46:21.217 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 15:46:21.218 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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:46:21.220 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=103 |
| 15:46:21.222 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=103 |
| 15:46:21.224 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=104 |
| 15:46:21.225 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=104 |
| 15:46:21.227 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=102 |
| 15:46:21.228 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=102 |
| 15:46:21.230 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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:46:21.232 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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:46:21.233 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=101 |
| 15:46:21.235 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=101 |
| 15:46:21.237 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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:46:21.238 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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:46:21.240 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=105 |
| 15:46:21.241 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=105 |
| 15:46:21.243 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=106 |
| 15:46:21.245 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=106 |
| 15:46:21.246 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=107 |
| 15:46:21.248 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=107 |
| 15:46:21.249 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=108 |
| 15:46:21.251 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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"=108 |
| 15:46:21.252 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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:46:21.254 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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:46:21.256 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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:46:21.257 | 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 "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."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 "a57be577deb434"."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:46:21.259 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:46:21.261 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:46:21.263 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1101' |
| 15:46:21.263 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:46:21.264 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:46:21.264 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1101' |
| 15:46:21.265 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1421' |
| 15:46:21.265 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1421' |
| 15:46:21.265 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1121' |
| 15:46:21.266 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1121' |
| 15:46:21.267 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=TRUE) |
| 15:46:21.269 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."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:46:21.276 | 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 "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.290 | 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 "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.301 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=TRUE) |
| 15:46:21.303 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."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:46:21.304 | 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 "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.308 | 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 "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.313 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=112200 |
| 15:46:21.315 | info | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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:46:21.332 | info | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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:46:21.362 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=112200 |
| 15:46:21.364 | info | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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:46:21.372 | info | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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:46:21.379 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."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:46:21.383 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."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:46:21.388 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."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:46:21.391 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."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:46:21.391 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."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:46:21.392 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."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:46:21.393 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (is_start = true) |
| 15:46:21.393 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') AND (t.is_start = false) |
| 15:46:21.394 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:46:21.395 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:46:21.397 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.401 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:46:21.402 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (is_start = true) |
| 15:46:21.403 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') AND (t.is_start = false) |
| 15:46:21.403 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:46:21.404 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:46:21.406 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.406 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:46:21.408 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_starts" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59' |
| 15:46:21.413 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.413 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.414 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.415 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.416 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.417 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."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:46:21.418 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."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:46:21.419 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" LEFT JOIN "a57be577deb434"."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:46:21.421 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.422 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" LEFT JOIN "a57be577deb434"."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:46:21.423 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" LEFT JOIN "a57be577deb434"."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:46:21.424 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_starts" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59' |
| 15:46:21.424 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.425 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.425 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.426 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.426 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.426 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."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:46:21.427 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."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:46:21.428 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" LEFT JOIN "a57be577deb434"."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:46:21.429 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.429 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" LEFT JOIN "a57be577deb434"."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:46:21.430 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" LEFT JOIN "a57be577deb434"."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:46:21.431 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1481' |
| 15:46:21.431 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1481' |
| 15:46:21.432 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1501' |
| 15:46:21.432 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1501' |
| 15:46:21.433 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1401' |
| 15:46:21.433 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1401' |
| 15:46:21.434 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1503' |
| 15:46:21.434 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1503' |
| 15:46:21.435 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1502' |
| 15:46:21.435 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1502' |
| 15:46:21.436 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1506' |
| 15:46:21.436 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1506' |
| 15:46:21.436 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1511' |
| 15:46:21.437 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1511' |
| 15:46:21.437 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1521' |
| 15:46:21.438 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1521' |
| 15:46:21.438 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1601' |
| 15:46:21.439 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1601' |
| 15:46:21.439 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1604' |
| 15:46:21.440 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1604' |
| 15:46:21.440 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1621' |
| 15:46:21.441 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1621' |
| 15:46:21.441 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1701' |
| 15:46:21.442 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1701' |
| 15:46:21.442 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1531' |
| 15:46:21.443 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1531' |
| 15:46:21.443 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1702' |
| 15:46:21.444 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1702' |
| 15:46:21.444 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1711' |
| 15:46:21.445 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1711' |
| 15:46:21.445 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=1801 |
| 15:46:21.446 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=1801 |
| 15:46:21.446 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1811' |
| 15:46:21.447 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1811' |
| 15:46:21.447 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1901' |
| 15:46:21.448 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1901' |
| 15:46:21.448 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=2) AND (parent_id is null) ORDER BY "is_current" DESC, "sort", "id" |
| 15:46:21.449 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."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:46:21.449 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:46:21.450 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:46:21.450 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:46:21.451 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:46:21.451 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:46:21.452 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:46:21.452 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."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:46:21.454 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.455 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.456 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."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:46:21.457 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.458 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.459 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2101' |
| 15:46:21.459 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2101' |
| 15:46:21.460 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2102' |
| 15:46:21.460 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2102' |
| 15:46:21.461 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2201' |
| 15:46:21.461 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2201' |
| 15:46:21.462 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."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:46:21.463 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=FALSE) |
| 15:46:21.464 | 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 "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.469 | 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 "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.474 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."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:46:21.475 | info | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=FALSE) |
| 15:46:21.476 | 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 "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.480 | 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 "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.484 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=220200 |
| 15:46:21.485 | info | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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:46:21.493 | info | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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:46:21.500 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=220200 |
| 15:46:21.501 | info | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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:46:21.508 | info | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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" >= '2025-08-08 14:34:58') 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:46:21.514 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2203' |
| 15:46:21.515 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2203' |
| 15:46:21.515 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.517 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."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:46:21.523 | info | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.527 | info | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.530 | info | yii\db\Command::query | SELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.535 | info | yii\db\Command::query | SELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.536 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.536 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."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:46:21.537 | info | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.538 | info | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.538 | info | yii\db\Command::query | SELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.539 | info | yii\db\Command::query | SELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.540 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.541 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:46:21.542 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.542 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:46:21.543 | 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 "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.544 | 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 "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.544 | 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 "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.545 | 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 "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.546 | info | yii\db\Command::query | SELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.547 | info | yii\db\Command::query | SELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.547 | info | yii\db\Command::query | SELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.548 | info | yii\db\Command::query | SELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."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:46:21.552 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."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:46:21.556 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."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:46:21.564 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."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:46:21.573 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."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:46:21.576 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."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:46:21.586 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."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:46:21.594 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.595 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:46:21.596 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.596 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:46:21.597 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.is_start = false) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND (("t"."bank_settle_at" IS NULL) OR ("t"."bank_settle_at" > '2026-06-30 23:59:59')) |
| 15:46:21.598 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND (is_start = true) |
| 15:46:21.598 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."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:46:21.599 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.600 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.602 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.603 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.603 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.604 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.605 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.606 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.is_start = false) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND (("t"."bank_settle_at" IS NULL) OR ("t"."bank_settle_at" > '2025-12-31 23:59:59')) |
| 15:46:21.607 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND (is_start = true) |
| 15:46:21.607 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."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:46:21.608 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.609 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.611 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.611 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.612 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.613 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.615 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."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:46:21.616 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2245' |
| 15:46:21.617 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2245' |
| 15:46:21.617 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2231' |
| 15:46:21.618 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2231' |
| 15:46:21.618 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2242' |
| 15:46:21.619 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2242' |
| 15:46:21.619 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2701' |
| 15:46:21.620 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2701' |
| 15:46:21.620 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2801' |
| 15:46:21.621 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2801' |
| 15:46:21.621 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401' |
| 15:46:21.622 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401' |
| 15:46:21.622 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401' |
| 15:46:21.623 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401' |
| 15:46:21.626 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2503' |
| 15:46:21.627 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2503' |
| 15:46:21.627 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=3) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:46:21.628 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56) |
| 15:46:21.628 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:46:21.629 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:46:21.630 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:46:21.630 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:46:21.631 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:46:21.631 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:46:21.631 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4001' |
| 15:46:21.632 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4001' |
| 15:46:21.632 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4002' |
| 15:46:21.633 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4002' |
| 15:46:21.633 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=4104 |
| 15:46:21.634 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.635 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."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:46:21.637 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.639 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."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:46:21.642 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.643 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.644 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.645 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" >= '2025-08-08 14:34:58') AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:46:21.648 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.648 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.649 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.650 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.650 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."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:46:21.651 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.651 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.652 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.652 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_social_insurances" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.653 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_provident_funds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.654 | info | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.654 | info | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.655 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.655 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:46:21.656 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."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:46:21.658 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."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:46:21.666 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."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:46:21.674 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=4104 |
| 15:46:21.674 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.675 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."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:46:21.676 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.676 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."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:46:21.677 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.678 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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:46:21.679 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.679 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" >= '2025-08-08 14:34:58') AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:46:21.682 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.682 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.683 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.683 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.684 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."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:46:21.684 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.685 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.685 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.686 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_social_insurances" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.686 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_provident_funds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.687 | info | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.687 | info | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.688 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.688 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:46:21.689 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."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:46:21.696 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."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:46:21.704 | info | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."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:46:21.712 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='6111' |
| 15:46:21.712 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='6111' |
| 15:46:21.713 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4301' |
| 15:46:21.713 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4301' |
| 15:46:21.714 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=1) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:46:21.715 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."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:46:21.715 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5064, 1001) |
| 15:46:21.716 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1001, 5064)) |
| 15:46:21.716 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4) |
| 15:46:21.717 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:46:21.717 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:46:21.718 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:46:21.719 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "is_start"=TRUE |
| 15:46:21.719 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_starts" "t" |
| 15:46:21.720 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=2) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:46:21.721 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."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:46:21.721 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:46:21.722 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:46:21.722 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:46:21.723 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:46:21.723 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:46:21.724 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:46:21.724 | info | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "is_start"=TRUE |
| 15:46:21.725 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=3) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:46:21.725 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56) |
| 15:46:21.726 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:46:21.726 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:46:21.727 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:46:21.727 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:46:21.728 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:46:21.728 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:46:21.731 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:46:21.732 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:46:21.733 | 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, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-assets', '{"year":"2026","month":"6","hide":"1","web_access_token":"r0J-lCBFZ2oBNvygnaGJSmtE8O_U85dp"}', '{"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":798908.16,"description":"","type":1,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":73,"parent_id":1,"title":"\u73b0\u91d1","serial_no":"100101","amount":"3480","balance_amount":"8610","actual_amount":8610,"description":"","type":1,"sort":4,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-08 15:39:57","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":4460,"index":3},{"id":103,"parent_id":1,"title":"\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c\u7fc1\u5bb6\u6210 6217000010081010749","serial_no":"100103","amount":"19445.25","balance_amount":"345.48","actual_amount":345.48,"description":"","type":1,"sort":6,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":5064,"created_at":"2025-08-08 15:36:06","updated_at":"2025-12-16 17:12:36","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":365.25,"index":3},{"id":104,"parent_id":1,"title":"\u6dd8\u5b9d\u7f51","serial_no":"100104","amount":"258.78","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":8,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":true,"is_current":false,"created_by":1001,"created_at":"2025-08-08 17:47:02","updated_at":"2025-12-29 17:52:40","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":102,"parent_id":1,"title":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062","serial_no":"100102","amount":"458031.1","balance_amount":"789952.68","actual_amount":789952.68,"description":"","type":1,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":5064,"created_at":"2025-08-08 15:35:40","updated_at":"2025-08-08 15:37:37","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":1033558.73,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":1038383.98,"can_stop":false,"index":2},{"id":3,"parent_id":"","title":"\u5168\u90e8\u94f6\u884c\u8d26\u6237","serial_no":"1002","amount":"0","balance_amount":"0","actual_amount":1554538.95,"description":"","type":1,"sort":2,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":101,"parent_id":3,"title":"\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d77\u6dc0\u897f\u533a\u4e16\u7eaa\u91d1\u6e90\u652f\u884c0200069919100105717","serial_no":"100203","amount":"93723.6","balance_amount":"55209.98","actual_amount":55209.98,"description":"","type":1,"sort":3,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":5064,"created_at":"2025-08-08 15:34:38","updated_at":"2025-08-11 19:33:40","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":709.98,"index":3},{"id":72,"parent_id":3,"title":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495","serial_no":"100202","amount":"632136.5","balance_amount":"23097.26","actual_amount":23097.26,"description":"","type":1,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-18 17:24:17","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":22393.66,"index":3},{"id":105,"parent_id":3,"title":"22222222","serial_no":"22222","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":8,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":1001,"created_at":"2026-06-22 14:12:00","updated_at":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":106,"parent_id":3,"title":"222","serial_no":"assa","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":9,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":1001,"created_at":"2026-06-22 14:13:28","updated_at":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":107,"parent_id":3,"title":"2222","serial_no":"222","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":10,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":1001,"created_at":"2026-06-22 14:18:28","updated_at":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":108,"parent_id":3,"title":"2223","serial_no":"22222","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":11,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":1001,"created_at":"2026-06-22 14:19:16","updated_at":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":71,"parent_id":3,"title":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","serial_no":"100201","amount":"2875779.6","balance_amount":"1476232.71","actual_amount":1476231.71,"description":"","type":1,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-08 18:50:15","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":642388.63,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":665492.27,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":92703234.71,"description":"","type":1,"sort":6,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":12589970.44,"can_stop":false,"index":2},{"id":74,"parent_id":"","title":"\u5e94\u6536\u8d26\u6b3e(\u9500\u552e\u51fa\u5e93\u5355)","serial_no":"112200","amount":"5500","balance_amount":"5500","actual_amount":21115759.64,"description":"","type":1,"sort":7,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2026-01-23 16:05:33","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":11371505.84,"can_stop":false,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1185749.79,"description":"","type":1,"sort":11,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":1153343,"can_stop":false,"index":2},{"id":12,"parent_id":"","title":"\u5b58\u8d27","serial_no":"1221","amount":"0","balance_amount":"0","actual_amount":550165.61166667,"description":"","type":1,"sort":12,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":98336.77,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":25205122.151667,"last_actual_amount":14327061.86,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":28,"parent_id":"","title":"\u957f\u671f\u5f85\u644a\u8d39\u7528","serial_no":"1801","amount":"222","balance_amount":"222","actual_amount":"222","description":"","type":1,"sort":28,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"222","can_stop":false,"index":2},{"id":29,"parent_id":"","title":"\u9012\u5ef6\u6240\u5f97\u7a0e\u8d44\u4ea7","serial_no":"1811","amount":"2","balance_amount":"2","actual_amount":"2","description":"","type":1,"sort":29,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"2","can_stop":false,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":224,"last_actual_amount":224,"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":25205346.151667,"last_actual_amount":14327285.86,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":10239466.08,"description":"","type":2,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":11472011.72,"can_stop":false,"index":2},{"id":75,"parent_id":"","title":"\u5e94\u4ed8\u8d26\u6b3e(\u91c7\u8d2d\u5165\u5e93\u5355)","serial_no":"220200","amount":"33","balance_amount":"33","actual_amount":5693609.49,"description":"","type":2,"sort":6,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2026-01-23 16:05:33","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":6725499.98,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":-2481663.42,"description":"","type":2,"sort":8,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":57,"parent_id":37,"title":"\u5e94\u4ed8\u804c\u5de5\u5de5\u8d44","serial_no":"221101","amount":"0","balance_amount":"0","actual_amount":-2619663.42,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":-1956321.62,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":115000,"description":"","type":2,"sort":4,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":23000,"description":"","type":2,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":7,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":-1956321.62,"can_stop":false,"index":2},{"id":38,"parent_id":"","title":"\u5e94\u4ea4\u7a0e\u8d39","serial_no":"2221","amount":"0","balance_amount":"0","actual_amount":13000,"description":"","type":2,"sort":9,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":13000,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"can_stop":false,"index":2},{"id":39,"parent_id":"","title":"\u5176\u4ed6\u5e94\u4ed8\u6b3e","serial_no":"2241","amount":"0","balance_amount":"0","actual_amount":2266768.33,"description":"","type":2,"sort":10,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":2168715.33,"can_stop":false,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":5491714.4,"last_actual_amount":6937893.69,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":true,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":5491714.4,"last_actual_amount":6937893.69,"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":"222","balance_amount":"222","actual_amount":"222","description":"","type":3,"sort":1,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"222","can_stop":false,"index":2},{"id":51,"parent_id":"","title":"\u8d44\u672c\u516c\u79ef","serial_no":"4002","amount":"3333","balance_amount":"3333","actual_amount":"3333","description":"","type":3,"sort":2,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"3333","can_stop":false,"index":2},{"id":52,"parent_id":"","title":"\u76c8\u4f59\u516c\u79ef","serial_no":"4101","amount":"0","balance_amount":"0","actual_amount":244444,"description":"","type":3,"sort":3,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":70,"parent_id":52,"title":"\u4efb\u610f\u76c8\u4f59\u516c\u79ef","serial_no":"410102","amount":"222222","balance_amount":"222222","actual_amount":"222222","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"222222","index":3},{"id":69,"parent_id":52,"title":"\u6cd5\u5b9a\u76c8\u4f59\u516c\u79ef","serial_no":"410101","amount":"22222","balance_amount":"22222","actual_amount":"22222","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"22222","index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":244444,"can_stop":false,"index":2},{"id":53,"parent_id":"","title":"\u672a\u5206\u914d\u5229\u6da6","serial_no":"4104","amount":"-2082915.66","balance_amount":"-2082915.66","actual_amount":13981429.251667,"description":"","type":3,"sort":4,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":1400879.28,"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":14229428.251667,"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":25205346.151667,"list2_sum":19721142.651667,"last_list1_sum":14327285.86,"last_list2_sum":8586771.97,"start_list1_sum":6566526.43,"start_list2_sum":143761.74},"show_libra":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-06-26 15:46:21', 578938112) RETURNING "id" |
| 15:46:21.739 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:46:21.739 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |