ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a424151b2d5d: POST https://beta.jinchangxiao.com/ledger/ticket/save-new at 2026-06-29 05:56:33 pm by 221.216.117.25

Log Messages

总计101条数据
TimeLevelCategoryMessage
 
17:56:33.731traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:56:33.731traceyii\base\Module::getModuleLoading module: debug
17:56:33.732traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:56:33.732traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:56:33.733traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:56:33.733traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:33.733infotime tracing start1782726993733895168
17:56:33.734traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:56:33.734traceyii\web\Application::handleRequestRoute requested: 'ledger/ticket/save-new'
17:56:33.734traceyii\base\Module::getModuleLoading module: ledger
17:56:33.735infoyii\web\Session::openSession started
17:56:33.736infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:56:33.736infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:56:33.738traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:33.738traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:33.739infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "ledger_access_token"='O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV'
17:56:33.740traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:33.741traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:33.741infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
17:56:33.742infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'
17:56:33.742traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:33.742traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:33.742traceyii\base\Controller::runActionRoute to run: ledger/ticket/save-new
17:56:33.743traceyii\base\InlineAction::runWithParamsRunning action: app\modules\ledger\controllers\TicketController::actionSaveNew()
17:56:33.744traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'items' in 'app\models\LedgerTickets'.
17:56:33.744traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:33.744traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:33.745traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:33.745traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:33.746infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.746infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.747infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.748infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='117')
17:56:33.748infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='117') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.748infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='117') AND ("is_delete"=FALSE))
17:56:33.749infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='124')
17:56:33.750infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='124') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.750infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='124') AND ("is_delete"=FALSE))
17:56:33.751infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.751infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.752infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.753infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.753infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.754infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.754infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='131')
17:56:33.755infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='131') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.755infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='131') AND ("is_delete"=FALSE))
17:56:33.756infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='141')
17:56:33.757infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='141') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.757infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='141') AND ("is_delete"=FALSE))
17:56:33.758infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.758infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.759infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.759infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='152')
17:56:33.760infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='152') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.760infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='152') AND ("is_delete"=FALSE))
17:56:33.761infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.761infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.762infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.762infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='104')
17:56:33.763infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='104') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.763infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='104') AND ("is_delete"=FALSE))
17:56:33.764infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"='168')
17:56:33.765infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("id"='168') AND ("ledger_id"='1') AND ("is_delete"=FALSE)
17:56:33.765infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("parent_id"='168') AND ("is_delete"=FALSE))
17:56:33.766infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'
17:56:33.766infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_settles" WHERE (("ledger_id"='1') AND ("is_settle"=TRUE)) AND ((("start_date" <= '2026-05-31') AND ("end_date" >= '2026-05-31')) OR (("date"='2026-05-01') AND (("start_date" IS NULL) OR ("end_date" IS NULL)))))
17:56:33.767infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_tickets" WHERE ("ledger_id"='1') AND ("ticket_date"='2026-05-31') AND ("ticket_word"='3') AND ("serial_no"='23'))
17:56:33.768infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'
17:56:33.768infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_tickets" WHERE ("ledger_id"='1') AND ("type"=2) AND ("settle_month"='2026-05-01') AND ("settle_caption_id"='8'))
17:56:33.769infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1')
17:56:33.769infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252)
17:56:33.770infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252)
17:56:33.770traceyii\db\Transaction::beginBegin transaction
17:56:33.771infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_ledger_tickets" ("ticket_word", "serial_no", "ticket_date", "ticket_count", "type", "status", "settle_month", "settle_caption_id", "ledger_id", "created_by", "created_at", "booked_by", "is_settle", "updated_at") VALUES (3, 23, '2026-05-31', 0, 2, 1, '2026-05-01', 8, 1, 5252, 'now()', 5252, FALSE, 'now()') RETURNING "id"
17:56:33.772traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:33.772traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:33.772infoyii\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\LedgerTickets', 37, 'a:15:{s:2:"id";i:37;s:9:"ledger_id";s:1:"1";s:11:"ticket_word";s:1:"3";s:9:"serial_no";s:2:"23";s:12:"ticket_count";s:1:"0";s:11:"ticket_date";s:10:"2026-05-31";s:4:"type";s:1:"2";s:6:"status";s:1:"1";s:9:"is_settle";b:0;s:12:"settle_month";s:10:"2026-05-01";s:17:"settle_caption_id";s:1:"8";s:10:"created_by";i:5252;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";s:19:"1970-01-01 08:00:00";s:9:"booked_by";i:5252;}', '', 5252, '221.216.117.25')
17:56:33.773infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_ledger_ticket_items" WHERE "ledger_ticket_id"=37
17:56:33.774infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_ledger_ticket_items" ("ledger_ticket_id", "summary", "ledger_account_caption_id", "auxiliary_item_id", "debit_amount", "credit_amount", "sort", "created_at", "updated_at") VALUES (37, '结转本期损益', 104, NULL, '8695524', '0', 1, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 117, NULL, '0', '8695524', 2, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 124, NULL, '234738', '0', 3, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 104, NULL, '0', '234738', 4, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 104, NULL, '8318446.31', '0', 5, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 131, NULL, '0', '8318446.31', 6, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 141, NULL, '23', '0', 7, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 104, NULL, '0', '23', 8, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 152, NULL, '5', '0', 9, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 104, NULL, '0', '5', 10, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 104, NULL, '1', '0', 11, '2026-06-29 17:56:33', '2026-06-29 17:56:33'), (37, '结转本期损益', 168, NULL, '0', '1', 12, '2026-06-29 17:56:33', '2026-06-29 17:56:33')
17:56:33.776infoyii\db\Command::querySELECT "ledger_account_caption_id" FROM "a57be577deb434"."tbl_ledger_ticket_items" WHERE ("ledger_ticket_id"=37) AND (NOT ("ledger_account_caption_id" IS NULL))
17:56:33.776infoyii\db\Command::querySELECT "id", "parent_id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"='1'
17:56:33.777infoyii\db\Command::querySELECT "id", "parent_id", "amount", "direction", "actual_amount" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND (("id" IN (124, 141, 152)) OR ("parent_id" IN (124, 141, 152))) ORDER BY "id"
17:56:33.777infoyii\db\Command::querySELECT "i"."ledger_account_caption_id", COALESCE(sum(i.debit_amount), 0) AS "debit_amount", COALESCE(sum(i.credit_amount), 0) AS "credit_amount" FROM "a57be577deb434"."tbl_ledger_ticket_items" "i" LEFT JOIN "a57be577deb434"."tbl_ledger_tickets" "t" ON i.ledger_ticket_id = t.id WHERE (("t"."ledger_id"='1') AND ("t"."status"=1)) AND ("i"."ledger_account_caption_id" IN (124, 141, 152)) GROUP BY "i"."ledger_account_caption_id"
17:56:33.779infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("id" IN (124, 141, 152))
17:56:33.779traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:33.780traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:33.780infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_ledger_account_captions" SET "actual_amount"='0', "updated_at"='2026-06-29 17:56:33' WHERE "id"=124
17:56:33.780infoyii\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\LedgerAccountCaptions', 124, 'a:1:{s:13:"actual_amount";s:6:"234738";}', '', 5252, '221.216.117.25')
17:56:33.781infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_ledger_account_captions" SET "actual_amount"='0', "updated_at"='2026-06-29 17:56:33' WHERE "id"=141
17:56:33.782infoyii\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\LedgerAccountCaptions', 141, 'a:1:{s:13:"actual_amount";s:3:"-23";}', '', 5252, '221.216.117.25')
17:56:33.782infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_ledger_account_captions" SET "actual_amount"='0', "updated_at"='2026-06-29 17:56:33' WHERE "id"=152
17:56:33.783infoyii\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\LedgerAccountCaptions', 152, 'a:1:{s:13:"actual_amount";s:2:"-5";}', '', 5252, '221.216.117.25')
17:56:33.783infoyii\db\Command::querySELECT "id", "parent_id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"='1'
17:56:33.784infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledger_banks" WHERE ("ledger_id"='1') AND ("ledger_account_caption_id" IN (124, 141, 152))
17:56:33.785traceyii\db\Transaction::commitCommit transaction
17:56:33.786traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:33.786traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:33.786infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 5252, 6, 'ledger/ticket/save-new', '{"access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV","ledger_id":"1","LedgerTickets":{"items":[{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"8695524","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"117","auxiliary_item_id":"","debit_amount":"0","credit_amount":"8695524"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"124","auxiliary_item_id":"","debit_amount":"234738","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"0","credit_amount":"234738"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"8318446.31","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"131","auxiliary_item_id":"","debit_amount":"0","credit_amount":"8318446.31"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"141","auxiliary_item_id":"","debit_amount":"23","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"0","credit_amount":"23"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"152","auxiliary_item_id":"","debit_amount":"5","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"0","credit_amount":"5"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"104","auxiliary_item_id":"","debit_amount":"1","credit_amount":"0"},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":"168","auxiliary_item_id":"","debit_amount":"0","credit_amount":"1"}],"ticket_word":"3","serial_no":"23","ticket_date":"2026-05-31","ticket_count":"0","type":"2","status":"1","settle_month":"2026-05-01","settle_caption_id":"8"},"web_access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV"}', '{"code":2000,"result":{"id":37},"status":1,"msg":[{"name":"success","success":"\u65b0\u51ed\u8bc1\u5df2\u521b\u5efa\u6210\u529f","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-29 17:56:33', 52904960) RETURNING "id"
17:56:33.788traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:33.788traceyii\redis\Connection::executeCommandExecuting Redis Command: SET