ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4da7bb99eaf: POST https://beta.jinchangxiao.com/vue/erp-cash-cost-ticket/save-settle at 2026-07-08 09:28:27 am by 39.156.194.178

Log Messages

总计108条数据
TimeLevelCategoryMessage
 
09:28:27.629traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
09:28:27.629traceyii\base\Module::getModuleLoading module: debug
09:28:27.630traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
09:28:27.630traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
09:28:27.631traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
09:28:27.631traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.631infotime tracing start1783474107631952128
09:28:27.632traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
09:28:27.632traceyii\web\Application::handleRequestRoute requested: 'vue/erp-cash-cost-ticket/save-settle'
09:28:27.632traceyii\base\Module::getModuleLoading module: vue
09:28:27.633infoyii\web\Session::openSession started
09:28:27.635infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
09:28:27.635infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
09:28:27.637traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.638traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.638traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.638traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.639infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:28:27.640traceyii\base\Controller::runActionRoute to run: vue/erp-cash-cost-ticket/save-settle
09:28:27.640traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.643traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
09:28:27.643traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpCashCostTicketController::actionSaveSettle()
09:28:27.643infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"='8490'
09:28:27.645traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.645traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.645traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.647traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.648traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.648traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.649infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
09:28:27.650traceyii\db\Transaction::beginBegin transaction
09:28:27.650infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_cash_cost_tickets" SET "is_payment_settle"=TRUE WHERE "id"=8490
09:28:27.652traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.652traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.652infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpCashCostTickets', 8490, 'a:0:{}', '', 1001, '39.156.194.178')
09:28:27.653infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_cash_cost_tickets" SET "bank_settle_at"='now()' WHERE "id"=8490
09:28:27.655infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpCashCostTickets', 8490, 'a:1:{s:14:"bank_settle_at";s:5:"now()";}', '', 1001, '39.156.194.178')
09:28:27.656infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_cash_cost_ticket_id"=8490 ORDER BY "id"
09:28:27.657traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.657traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.657infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_cash_cost_ticket_id"=8490
09:28:27.657infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" ("erp_cash_cost_ticket_id", "erp_bank_id", "amount", "description", "settle_at", "settle_by") VALUES (8490, 1, '1', '', 'now()', 1001)
09:28:27.658infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" WHERE "erp_cash_cost_ticket_id"=8490
09:28:27.659infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20032) AND ("object_id"=8490)
09:28:27.663infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20032) AND ("object_id"=8490)
09:28:27.670infoyii\db\Command::querySELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 20013::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20013 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, t.amount as in_amount, null::numeric as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "t" ON t.erp_collect_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null)) "sub") UNION ALL ( SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20015::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20015 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, t.amount as in_amount, null::numeric as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20017::varchar || 1::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20017 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, t.amount as in_amount, null::numeric as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_bank_transfer_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "t" ON t.erp_bank_transfer_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20017::varchar || 2::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20017 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_bank_transfer_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "t" ON t.erp_bank_transfer_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "t" ON t.erp_cash_cost_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20019::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "t" ON t.erp_advance_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20020 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, t.amount as in_amount, null::numeric as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "t" ON t.erp_other_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20021::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "t" ON t.erp_other_collect_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (r.bank_settle_at IS NOT NULL) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "t" ON t.erp_wage_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "t" ON t.erp_social_insurance_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "t" ON t.erp_provident_fund_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "t" ON t.erp_personal_tax_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "t" ON t.erp_wage_prize_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) )) "sub" WHERE ("sub"."id2"=8490) AND ("sub"."ticket_type"=20018) ORDER BY "settle_at"
09:28:27.683infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks"
09:28:27.683infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8490
09:28:27.684infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" WHERE "erp_cash_cost_ticket_id"=8490
09:28:27.685traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.686traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.686traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.686traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.686infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_bank_amount_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "amount", "client_id", "supplier_id", "contact_id", "user_id", "created_by", "created_at", "updated_at", "object_id", "verify_at", "settle_at", "in_amount", "out_amount", "erp_bank_id", "balance_amount") VALUES (2, 20018, 'XJFYD-20260708-00001', '2026-07-08', NULL, '测试结算合同', '1', 3462, NULL, NULL, NULL, 1001, '2026-07-08 09:26:47', '2026-07-08 09:26:47', 8490, '2026-07-08 09:26:47.529756+08', '2026-07-08 09:28:27.650585+08', NULL, '1', 1, '1475422.71') RETURNING "id"
09:28:27.690infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpBankAmountChangeLogs', 1764, 'a:22:{s:2:"id";i:1764;s:9:"object_id";i:8490;s:11:"ticket_type";i:20018;s:9:"serial_no";s:20:"XJFYD-20260708-00001";s:11:"erp_bank_id";i:1;s:10:"wrote_date";s:10:"2026-07-08";s:6:"status";i:2;s:6:"amount";s:1:"1";s:9:"in_amount";N;s:10:"out_amount";s:1:"1";s:14:"balance_amount";d:1475422.71;s:11:"supplier_id";N;s:9:"client_id";i:3462;s:10:"contact_id";N;s:7:"user_id";N;s:8:"abstract";s:18:"测试结算合同";s:11:"description";N;s:9:"settle_at";s:29:"2026-07-08 09:28:27.650585+08";s:9:"verify_at";s:29:"2026-07-08 09:26:47.529756+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-07-08 09:26:47";s:10:"updated_at";s:19:"2026-07-08 09:26:47";}', '', 1001, '39.156.194.178')
09:28:27.691traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.691infoyii\db\Command::querySELECT 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_bank_amount_change_log_handlers' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
09:28:27.696infoyii\db\Command::queryselect 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_bank_amount_change_log_handlers' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
09:28:27.708traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.708traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
09:28:27.708infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" ("erp_bank_amount_change_log_id", "user_id") VALUES (1764, 1001)
09:28:27.713infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8490
09:28:27.714infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_cash_cost_ticket_id"=8490
09:28:27.714infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" WHERE "erp_cash_cost_ticket_id"=8490
09:28:27.715infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_cash_cost_tickets" SET "settle_amount"='1' WHERE "id"=8490
09:28:27.716infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpCashCostTickets', 8490, 'a:1:{s:13:"settle_amount";s:1:"0";}', '', 1001, '39.156.194.178')
09:28:27.716infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" WHERE "erp_cash_cost_ticket_id"=8490 ORDER BY "id"
09:28:27.717infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=8490 ORDER BY "id"
09:28:27.717infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_cash_cost_ticket_id"=8490 ORDER BY "id"
09:28:27.718infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
09:28:27.719infoyii\db\Command::querySELECT 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 ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
09:28:27.719infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
09:28:27.720infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
09:28:27.721infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
09:28:27.725infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" ON r.erp_advance_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
09:28:27.726infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON r.erp_other_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
09:28:27.726infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND (t.bank_settle_at IS NOT NULL)
09:28:27.727infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
09:28:27.729infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
09:28:27.730infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON r.erp_social_insurance_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
09:28:27.731infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON r.erp_provident_fund_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
09:28:27.731infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON r.erp_personal_tax_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
09:28:27.732infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON r.erp_wage_prize_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
09:28:27.733infoyii\db\Command::querySELECT 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 ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
09:28:27.734infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='1475422.71' WHERE "id"=1
09:28:27.734infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpBanks', 1, 'a:1:{s:14:"balance_amount";d:1475422.71;}', '', 1001, '39.156.194.178')
09:28:27.735infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
09:28:27.736infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71
09:28:27.736traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.737traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.737infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_account_captions" SET "balance_amount"='1475422.71', "created_at"='2025-08-01 23:14:45', "updated_at"='2025-08-08 18:50:15' WHERE "id"=71
09:28:27.738infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAccountCaptions', 71, 'a:1:{s:14:"balance_amount";s:10:"1475422.71";}', '', 1001, '39.156.194.178')
09:28:27.740infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpBanks', 1, 'a:0:{}', '', 1001, '39.156.194.178')
09:28:27.742infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_approve_payment_settles" WHERE "erp_cash_cost_ticket_id"=8490 ORDER BY "id"
09:28:27.743infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8490
09:28:27.744infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_cash_cost_ticket_id"=8490 ORDER BY "id"
09:28:27.744infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
09:28:27.745infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:28:27.746traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.746traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.746infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (9, 'status', 8490, 20018, 1001, 'now()', '["\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530:\uffe51;"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7ed3\u7b97\u4fe1\u606f","d4":["\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530:\uffe51;"]}')
09:28:27.747infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE (purchase_contract_id is not null) AND ("erp_cash_cost_ticket_id"=8490) ORDER BY "id"
09:28:27.748traceyii\db\Transaction::commitCommit transaction
09:28:27.753traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.753traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:28:27.753infoyii\db\Command::queryINSERT 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-cash-cost-ticket/save-settle', '{"id":"8490","files":"","erpCashCostTicketBankOuts":[{"amount":"1","id":"1","description":""}],"ErpCashCostTickets":{"erpCashCostTicketSalesContractSettles":""}}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u7ed3\u7b97\u6210\u529f","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-08 09:28:27', 121666816) RETURNING "id"
09:28:27.757traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:28:27.757traceyii\redis\Connection::executeCommandExecuting Redis Command: SET