6a4242cdade6e: POST https://beta.jinchangxiao.com/ledger/report/list-income-statement at 2026-06-29 06:02:53 pm by 221.216.117.25
Log Messages
总计39条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 18:02:53.711 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 18:02:53.711 | trace | yii\base\Module::getModule | Loading module: debug |
| 18:02:53.712 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 18:02:53.712 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 18:02:53.712 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 18:02:53.713 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:02:53.713 | info | time tracing start | 1782727373713665024 |
| 18:02:53.713 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 18:02:53.713 | trace | yii\web\Application::handleRequest | Route requested: 'ledger/report/list-income-statement' |
| 18:02:53.713 | trace | yii\base\Module::getModule | Loading module: ledger |
| 18:02:53.715 | info | yii\web\Session::open | Session started |
| 18:02:53.717 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 18:02:53.717 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 18:02:53.718 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:02:53.720 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:02:53.720 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "ledger_access_token"='O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV' |
| 18:02:53.722 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:02:53.722 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:02:53.722 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
| 18:02:53.723 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1' |
| 18:02:53.724 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:02:53.724 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:02:53.724 | trace | yii\base\Controller::runAction | Route to run: ledger/report/list-income-statement |
| 18:02:53.724 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\ledger\controllers\ReportController::actionListIncomeStatement() |
| 18:02:53.725 | info | yii\db\Command::query | SELECT "id", "parent_id", "serial_no", "title", "type", "amount", "year_debit_amount", "year_credit_amount" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"='1' ORDER BY "serial_no", "id" |
| 18:02:53.726 | info | yii\db\Command::query | SELECT "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-06-01') AND ("t"."ticket_date" <= '2026-06-30') AND (NOT (("t"."type"=2) AND ("t"."settle_caption_id"=8))) GROUP BY "i"."ledger_account_caption_id" |
| 18:02:53.727 | info | yii\db\Command::query | SELECT "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-06-30') AND (NOT (("t"."type"=2) AND ("t"."settle_caption_id"=8))) GROUP BY "i"."ledger_account_caption_id" |
| 18:02:53.732 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_settles" WHERE ("ledger_id"='1') AND ("date"='2026-06-01') AND ("is_settle"=TRUE)) |
| 18:02:53.733 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_tickets" WHERE (("ledger_id"='1') AND ("type"=2) AND ("settle_caption_id"=8) AND ("status"=1)) AND ("settle_month"='2026-06-01')) |
| 18:02:53.733 | info | yii\db\Command::query | SELECT "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-06-01') GROUP BY "i"."ledger_account_caption_id" |
| 18:02:53.735 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:02:53.735 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:02:53.736 | 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', 5252, 6, 'ledger/report/list-income-statement', '{"access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV","ledger_id":"1","period_start":"2026-06","period_end":"2026-06","web_access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV"}', '{"code":2000,"result":{"settle_status":{"code":"not_carried","name":"\u672a\u7ed3\u8f6c\u635f\u76ca","color":"orange","tips":[]},"list":[{"item_name":"\u4e00\u3001\u8425\u4e1a\u6536\u5165","line_no":1,"index":1,"level":0,"year_amount":-8695524,"month_amount":""},{"item_name":"\u51cf\uff1a\u8425\u4e1a\u6210\u672c","line_no":2,"index":2,"level":1,"year_amount":8318446.31,"month_amount":""},{"item_name":"\u7a0e\u91d1\u53ca\u9644\u52a0","line_no":3,"index":2,"level":1,"year_amount":"","month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u6d88\u8d39\u7a0e","line_no":4,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u8425\u4e1a\u7a0e","line_no":5,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u57ce\u5e02\u7ef4\u62a4\u5efa\u8bbe\u7a0e","line_no":6,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u8d44\u6e90\u7a0e","line_no":7,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u571f\u5730\u589e\u503c\u7a0e","line_no":8,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u57ce\u9547\u571f\u5730\u4f7f\u7528\u7a0e\u3001\u623f\u4ea7\u7a0e\u3001\u8f66\u8239\u7a0e\u3001\u5370\u82b1\u7a0e","line_no":9,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u6559\u80b2\u8d39\u9644\u52a0\u3001\u77ff\u4ea7\u8d44\u6e90\u8865\u507f\u8d39\u3001\u6392\u6c61\u8d39","line_no":10,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u9500\u552e\u8d39\u7528","line_no":11,"index":2,"level":1,"year_amount":"","month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u5546\u54c1\u7ef4\u4fee\u8d39","line_no":12,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u5e7f\u544a\u8d39\u548c\u4e1a\u52a1\u5ba3\u4f20\u8d39","line_no":13,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u7ba1\u7406\u8d39\u7528","line_no":14,"index":2,"level":1,"year_amount":-23,"month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u5f00\u529e\u8d39","line_no":15,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u4e1a\u52a1\u62db\u5f85\u8d39","line_no":16,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u7814\u7a76\u8d39\u7528","line_no":17,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u8d22\u52a1\u8d39\u7528","line_no":18,"index":2,"level":1,"year_amount":-5,"month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u5229\u606f\u8d39\u7528\uff08\u6536\u5165\u4ee5\u201c-\u201d\u53f7\u586b\u5217\uff09","line_no":19,"index":2,"level":2,"year_amount":-5,"month_amount":""},{"item_name":"\u52a0\uff1a\u6295\u8d44\u6536\u76ca\uff08\u635f\u5931\u4ee5\u201c-\u201d\u53f7\u586b\u5217\uff09","line_no":20,"index":2,"level":1,"year_amount":"","month_amount":""},{"item_name":"\u4e8c\u3001\u8425\u4e1a\u5229\u6da6\uff08\u4e8f\u635f\u4ee5\u201c-\u201d\u53f7\u586b\u5217\uff09","line_no":21,"index":1,"level":0,"year_amount":-17013942.31,"month_amount":0},{"item_name":"\u52a0\uff1a\u8425\u4e1a\u5916\u6536\u5165","line_no":22,"index":2,"level":1,"year_amount":234738,"month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u653f\u5e9c\u8865\u52a9","line_no":23,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u51cf\uff1a\u8425\u4e1a\u5916\u652f\u51fa","line_no":24,"index":2,"level":1,"year_amount":"","month_amount":""},{"item_name":"\u5176\u4e2d\uff1a\u574f\u8d26\u635f\u5931","line_no":25,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u65e0\u6cd5\u6536\u56de\u7684\u957f\u671f\u503a\u5238\u6295\u8d44\u635f\u5931","line_no":26,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u65e0\u6cd5\u6536\u56de\u7684\u957f\u671f\u80a1\u6743\u6295\u8d44\u635f\u5931","line_no":27,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u81ea\u7136\u707e\u5bb3\u7b49\u4e0d\u53ef\u6297\u529b\u56e0\u7d20\u9020\u6210\u7684\u635f\u5931","line_no":28,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u7a0e\u6536\u6ede\u7eb3\u91d1","line_no":29,"index":2,"level":2,"year_amount":"","month_amount":""},{"item_name":"\u4e09\u3001\u5229\u6da6\u603b\u989d\uff08\u4e8f\u635f\u603b\u989d\u4ee5\u201c-\u201d\u53f7\u586b\u5217\uff09","line_no":30,"index":1,"level":0,"year_amount":-16779204.31,"month_amount":0},{"item_name":"\u51cf\uff1a\u6240\u5f97\u7a0e\u8d39\u7528","line_no":31,"index":2,"level":1,"year_amount":1,"month_amount":""},{"item_name":"\u56db\u3001\u51c0\u5229\u6da6\uff08\u51c0\u4e8f\u635f\u4ee5\u201c-\u201d\u53f7\u586b\u5217\uff09","line_no":32,"index":1,"level":0,"year_amount":-16779205.31,"month_amount":0}]},"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 18:02:53', 22334976) RETURNING "id" |
| 18:02:53.738 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:02:53.739 | info | yii\db\Command::query | SELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko/20100101 Firefox/152.0' |
| 18:02:53.739 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:02:53.740 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:02:53.740 | info | yii\db\Command::execute | UPDATE "global"."tbl_browser_ua_statistics" SET "counter"=2500 WHERE "id"=298 |
| 18:02:53.741 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |