ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a42415098409: POST https://beta.jinchangxiao.com/ledger/ticket/get-new at 2026-06-29 05:56:32 pm by 221.216.117.25

Log Messages

总计38条数据
TimeLevelCategoryMessage
 
17:56:32.622traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:56:32.622traceyii\base\Module::getModuleLoading module: debug
17:56:32.623traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:56:32.623traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:56:32.624traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:56:32.624traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:32.624infotime tracing start1782726992624967936
17:56:32.625traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:56:32.625traceyii\web\Application::handleRequestRoute requested: 'ledger/ticket/get-new'
17:56:32.625traceyii\base\Module::getModuleLoading module: ledger
17:56:32.626infoyii\web\Session::openSession started
17:56:32.627infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:56:32.627infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:56:32.629traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:32.629traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:32.630infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "ledger_access_token"='O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV'
17:56:32.631traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:32.632traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:32.632infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
17:56:32.633infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'
17:56:32.633traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:32.633traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:32.634traceyii\base\Controller::runActionRoute to run: ledger/ticket/get-new
17:56:32.634traceyii\base\InlineAction::runWithParamsRunning action: app\modules\ledger\controllers\TicketController::actionGetNew()
17:56:32.634infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledger_settles" WHERE ("ledger_id"='1') AND ("is_settle"=TRUE) ORDER BY "end_date" DESC, "date" DESC
17:56:32.635infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
17:56:32.636infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)
17:56:32.636infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6
17:56:32.637infoyii\db\Command::querySELECT COALESCE(max("serial_no"), 0) + 1 FROM "a57be577deb434"."tbl_ledger_tickets" WHERE ("ledger_id"='1') AND ("ticket_date"='2026-06-29') AND ("ticket_word"=4)
17:56:32.638infoyii\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:32.638infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND ("is_delete"=FALSE) ORDER BY "serial_no", "id"
17:56:32.640infoyii\db\Command::querySELECT "i"."ledger_account_caption_id" AS "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" INNER JOIN "a57be577deb434"."tbl_ledger_tickets" "t" ON i.ledger_ticket_id = t.id WHERE (("t"."ledger_id"='1') AND ("t"."status"=1)) AND ("t"."ticket_date" >= '2026-05-01') AND ("t"."ticket_date" <= '2026-05-31') AND (("t"."type"=1) OR (("t"."type"=2) AND ("t"."settle_caption_id" IN (1, 2, 3, 4, 5, 6, 7)))) GROUP BY "i"."ledger_account_caption_id"
17:56:32.642infoyii\db\Command::querySELECT COALESCE(max("serial_no"), 0) + 1 FROM "a57be577deb434"."tbl_ledger_tickets" WHERE ("ledger_id"='1') AND ("ticket_date"='2026-05-31') AND ("ticket_word"=3)
17:56:32.643traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:32.644traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:56:32.644infoyii\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/get-new', '{"access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV","ledger_id":"1","type":"2","settle_month":"2026-05-01","settle_caption_id":"8","web_access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV"}', '{"code":2000,"result":{"model":{"id":"","ledger_id":"1","ticket_word":3,"serial_no":23,"ticket_count":0,"ticket_date":"2026-05-31","type":2,"status":1,"is_settle":false,"settle_month":"2026-05-01","settle_caption_id":8,"created_by":5252,"booked_by":5252,"created_at":"","updated_at":"","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"bookedBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"ledger":{"id":"1","verify_name":"","bookkeeper_name":"","cashier_name":""},"items":[{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":104,"auxiliary_item_id":"","debit_amount":8695524,"credit_amount":0,"sort":1,"accountCaption":{"key":104,"name":"\u672c\u5e74\u5229\u6da6","serial_no":"3103","title":"\u672c\u5e74\u5229\u6da6","balance":"0","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":117,"auxiliary_item_id":"","debit_amount":0,"credit_amount":8695524,"sort":2,"accountCaption":{"key":117,"name":"\u4e3b\u8425\u4e1a\u52a1\u6536\u5165","serial_no":"5001","title":"\u4e3b\u8425\u4e1a\u52a1\u6536\u5165","balance":"0","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":124,"auxiliary_item_id":"","debit_amount":234738,"credit_amount":0,"sort":3,"accountCaption":{"key":124,"name":"\u76d8\u76c8\u6536\u76ca","serial_no":"530104","title":"\u76d8\u76c8\u6536\u76ca","balance":"234738","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":104,"auxiliary_item_id":"","debit_amount":0,"credit_amount":234738,"sort":4,"accountCaption":{"key":104,"name":"\u672c\u5e74\u5229\u6da6","serial_no":"3103","title":"\u672c\u5e74\u5229\u6da6","balance":"0","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":104,"auxiliary_item_id":"","debit_amount":8318446.31,"credit_amount":0,"sort":5,"accountCaption":{"key":104,"name":"\u672c\u5e74\u5229\u6da6","serial_no":"3103","title":"\u672c\u5e74\u5229\u6da6","balance":"0","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":131,"auxiliary_item_id":"","debit_amount":0,"credit_amount":8318446.31,"sort":6,"accountCaption":{"key":131,"name":"\u4e3b\u8425\u4e1a\u52a1\u6210\u672c","serial_no":"5401","title":"\u4e3b\u8425\u4e1a\u52a1\u6210\u672c","balance":"0","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":141,"auxiliary_item_id":"","debit_amount":23,"credit_amount":0,"sort":7,"accountCaption":{"key":141,"name":"\u7ba1\u7406\u4eba\u5458\u804c\u5de5\u85aa\u916c","serial_no":"560201","title":"\u7ba1\u7406\u4eba\u5458\u804c\u5de5\u85aa\u916c","balance":"-23","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":104,"auxiliary_item_id":"","debit_amount":0,"credit_amount":23,"sort":8,"accountCaption":{"key":104,"name":"\u672c\u5e74\u5229\u6da6","serial_no":"3103","title":"\u672c\u5e74\u5229\u6da6","balance":"0","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":152,"auxiliary_item_id":"","debit_amount":5,"credit_amount":0,"sort":9,"accountCaption":{"key":152,"name":"\u5229\u606f\u8d39\u7528","serial_no":"560301","title":"\u5229\u606f\u8d39\u7528","balance":"-5","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":104,"auxiliary_item_id":"","debit_amount":0,"credit_amount":5,"sort":10,"accountCaption":{"key":104,"name":"\u672c\u5e74\u5229\u6da6","serial_no":"3103","title":"\u672c\u5e74\u5229\u6da6","balance":"0","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":104,"auxiliary_item_id":"","debit_amount":1,"credit_amount":0,"sort":11,"accountCaption":{"key":104,"name":"\u672c\u5e74\u5229\u6da6","serial_no":"3103","title":"\u672c\u5e74\u5229\u6da6","balance":"0","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}},{"summary":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","ledger_account_caption_id":168,"auxiliary_item_id":"","debit_amount":0,"credit_amount":1,"sort":12,"accountCaption":{"key":168,"name":"\u6240\u5f97\u7a0e\u8d39\u7528","serial_no":"5801","title":"\u6240\u5f97\u7a0e\u8d39\u7528","balance":"0","auxiliary_types":[],"auxiliary_type_display":"","can_auxiliary":false,"is_cash_equivalent":false},"cashItem":{}}],"files":[],"ticket_word_display":"\u8f6c","type_display":"\u79d1\u76ee\u8c03\u6574\u51ed\u8bc1","status_display":"\u5df2\u8bb0\u8d26","serial_no_display":"023","ticket_no_display":"\u8f6c-023","settle_month_display":"2026-05","settle_caption_title":"\u7ed3\u8f6c\u672c\u671f\u635f\u76ca","verify_status_display":"\u5ba1\u6838\u901a\u8fc7","verify_name_display":"- -","verify_display":"\u5ba1\u6838\u901a\u8fc7 - -","cashier_name_display":"","can_update":true,"can_delete":true,"is_settle_display":"\u672a\u7ed3\u7b97","attachment_count":0,"debit_total":17248737.31,"credit_total":17248737.31},"options":{"LedgerTickets[ticket_word]":{"key":"LedgerTickets[ticket_word]","name":"\u51ed\u8bc1\u5b57","value":[{"id":4,"key":4,"name":"\u8bb0"},{"id":2,"key":2,"name":"\u4ed8"},{"id":3,"key":3,"name":"\u8f6c"},{"id":1,"key":1,"name":"\u6536"}],"default":""},"LedgerTickets[status]":{"key":"LedgerTickets[status]","name":"\u51ed\u8bc1\u72b6\u6001","value":[{"id":0,"key":0,"name":"\u8349\u7a3f"},{"id":1,"key":1,"name":"\u5df2\u8bb0\u8d26"}],"default":""}},"can_create":true,"disableMonth":{"minTime":"","maxTime":"","disabledRanges":[]}},"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-29 17:56:32', 19432192) RETURNING "id"
17:56:32.647traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:56:32.647traceyii\redis\Connection::executeCommandExecuting Redis Command: SET