6a42433deb62a: POST https://beta.jinchangxiao.com/ledger/dashboard/get-tax-dashboard at 2026-06-29 06:04:45 pm by 221.216.117.25
Log Messages
总计42条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 18:04:45.963 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 18:04:45.963 | trace | yii\base\Module::getModule | Loading module: debug |
| 18:04:45.964 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 18:04:45.964 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 18:04:45.964 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 18:04:45.964 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:04:45.965 | info | time tracing start | 1782727485965379840 |
| 18:04:45.965 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 18:04:45.965 | trace | yii\web\Application::handleRequest | Route requested: 'ledger/dashboard/get-tax-dashboard' |
| 18:04:45.965 | trace | yii\base\Module::getModule | Loading module: ledger |
| 18:04:45.966 | info | yii\web\Session::open | Session started |
| 18:04:45.968 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 18:04:45.968 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 18:04:45.969 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:04:45.970 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:04:45.970 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "ledger_access_token"='O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV' |
| 18:04:45.971 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:04:45.972 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:04:45.972 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
| 18:04:45.973 | trace | yii\base\Controller::runAction | Route to run: ledger/dashboard/get-tax-dashboard |
| 18:04:45.973 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\ledger\controllers\DashboardController::actionGetTaxDashboard() |
| 18:04:45.973 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1' |
| 18:04:45.974 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:04:45.974 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:04:45.974 | info | yii\db\Command::query | SELECT "id", "parent_id", "title", "serial_no", "type", "direction" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"=1) AND ("is_delete"=FALSE) ORDER BY "serial_no", "id" |
| 18:04:45.976 | info | yii\db\Command::query | SELECT "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 ("t"."ticket_date" >= '2026-05-01') AND ("t"."ticket_date" <= '2026-05-31') AND (NOT (("t"."type"=2) AND ("t"."settle_caption_id"=8))) GROUP BY "i"."ledger_account_caption_id" |
| 18:04:45.977 | info | yii\db\Command::query | SELECT "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 ("t"."ticket_date" <= '2026-05-31') GROUP BY "i"."ledger_account_caption_id" |
| 18:04:45.978 | info | yii\db\Command::query | SELECT "id", "parent_id", "direction", "amount", "year_debit_amount", "year_credit_amount" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"=1 ORDER BY "id" |
| 18:04:45.982 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:04:45.984 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:04:45.985 | info | yii\db\Command::query | SELECT SUM(tax_amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE (("is_verify"=TRUE) AND ("is_draft"=FALSE)) AND ("verify_at" >= '2026-05-01 00:00:00') AND ("verify_at" <= '2026-05-31 23:59:59') |
| 18:04:45.987 | info | yii\db\Command::query | SELECT SUM(tax_amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE ("is_draft"=FALSE) AND ("from_date" >= '2026-05-01 00:00:00') AND ("from_date" <= '2026-05-31 23:59:59') |
| 18:04:45.988 | info | yii\db\Command::query | SELECT "id", "ledger_account_caption_id", "erp_bank_id" FROM "a57be577deb434"."tbl_ledger_banks" WHERE (("ledger_id"=1) AND ("is_delete"=FALSE)) AND (NOT ("erp_bank_id" IS NULL)) |
| 18:04:45.989 | info | yii\db\Command::query | SELECT "erp_bank_id", COALESCE(sum(in_amount), 0) - COALESCE(sum(out_amount), 0) AS "amount" FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" WHERE ("erp_bank_id" IN (8, 9, 10, 11, 3, 6, 7, 1, 5, 2, 4)) AND ("settle_at" <= '2026-05-31 23:59:59') GROUP BY "erp_bank_id" |
| 18:04:45.991 | info | yii\db\Command::query | SELECT "id", "amount" FROM "a57be577deb434"."tbl_erp_banks" WHERE ("id" IN (8, 9, 10, 11, 3, 6, 7, 1, 5, 2, 4)) AND ("created_at" <= '2026-05-31 23:59:59') |
| 18:04:45.992 | info | yii\db\Command::query | SELECT COUNT(*) FROM "a57be577deb434"."tbl_ledger_tickets" WHERE ("ledger_id"=1) AND ("status" != 0) AND ("ticket_date" >= '2026-05-01') AND ("ticket_date" <= '2026-05-31') |
| 18:04:45.993 | info | yii\db\Command::query | SELECT COUNT(*) FROM "a57be577deb434"."tbl_ledger_tickets" WHERE (("ledger_id"=1) AND ("status"=0)) AND ("ticket_date" >= '2026-05-01') AND ("ticket_date" <= '2026-05-31') |
| 18:04:45.994 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:04:45.994 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:04:45.995 | 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/dashboard/get-tax-dashboard', '{"access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV","ledger_id":"1","web_access_token":"O6Vr7bn3kQPZ5hlF6w1MM7SX_Njw-iTV"}', '{"code":2000,"result":{"date":"2026-05","status_list":[{"key":"input_tax","name":"\u8fdb\u9879\u7a0e\u989d","value":"\u76f8\u7b26","status":"matched","book_display":"\u660e\u7ec6\u8d26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":58,"end_account_caption_id":58,"start_account_caption":{"id":58,"serial_no":"22210101","title":"\u8fdb\u9879\u7a0e\u989d","name":"22210101 \u8fdb\u9879\u7a0e\u989d"},"end_account_caption":{"id":58,"serial_no":"22210101","title":"\u8fdb\u9879\u7a0e\u989d","name":"22210101 \u8fdb\u9879\u7a0e\u989d"}}}},{"key":"output_tax","name":"\u9500\u9879\u7a0e\u989d","value":"\u76f8\u7b26","status":"matched","book_display":"\u660e\u7ec6\u8d26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":64,"end_account_caption_id":64,"start_account_caption":{"id":64,"serial_no":"22210107","title":"\u9500\u9879\u7a0e\u989d","name":"22210107 \u9500\u9879\u7a0e\u989d"},"end_account_caption":{"id":64,"serial_no":"22210107","title":"\u9500\u9879\u7a0e\u989d","name":"22210107 \u9500\u9879\u7a0e\u989d"}}}},{"key":"cash_bank_balance","name":"\u94f6\u884c\u4f59\u989d","value":"\u4e0d\u76f8\u7b26","status":"unmatched","book_display":"\u660e\u7ec6\u8d26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":1,"end_account_caption_id":177,"start_account_caption":{"id":1,"serial_no":"1001","title":"\u5e93\u5b58\u73b0\u91d1","name":"1001 \u5e93\u5b58\u73b0\u91d1"},"end_account_caption":{"id":177,"serial_no":"100207","title":"2223","name":"100207 2223"}}}},{"key":"gross_margin_rate","name":"\u9500\u552e\u6bdb\u5229\u7387","value":"195.66%","status":"none","book_display":"\u79d1\u76ee\u6c47\u603b\u8868","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05"}}},{"key":"net_margin_rate","name":"\u9500\u552e\u51c0\u5229\u7387","value":"192.96%","status":"none","book_display":"\u79d1\u76ee\u6c47\u603b\u8868","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":1,"end_account_caption_id":167,"start_account_caption":{"id":1,"serial_no":"1001","title":"\u5e93\u5b58\u73b0\u91d1","name":"1001 \u5e93\u5b58\u73b0\u91d1"},"end_account_caption":{"id":167,"serial_no":"571111","title":"\u7f5a\u6ca1\u635f\u5931","name":"571111 \u7f5a\u6ca1\u635f\u5931"}}}}],"voucher_result":{"date":"2026-05","posted_count":38,"draft_count":0,"total_count":38,"posted_target":{"LedgerTicketSearch":{"ticket_date_from":"2026-05-01","ticket_date_to":"2026-05-31","status":1}},"draft_target":{"LedgerTicketSearch":{"ticket_date_from":"2026-05-01","ticket_date_to":"2026-05-31","status":0}}},"profit_structure":{"date":"2026-05","list":[{"key":"operating_revenue","title":"\u8425\u4e1a\u6536\u5165","amount":-8695524,"progress":51.1},{"key":"operating_cost","title":"\u8425\u4e1a\u6210\u672c","amount":8318446.31,"progress":48.89},{"key":"gross_profit","title":"\u9500\u552e\u6bdb\u5229","amount":-17013970.31,"progress":100},{"key":"period_expense","title":"\u671f\u95f4\u8d39\u7528","amount":-28,"progress":0},{"key":"net_profit","title":"\u51c0\u5229\u6da6","amount":-16779205.31,"progress":98.62}]},"cash_bank_balance":{"date":"2026-05","compare_enabled":true,"list":[{"account_code":"100101","account_name":"\u73b0\u91d1","book_amount":8610,"source_amount":8610,"diff_amount":0,"status":"matched","status_text":"\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":170,"end_account_caption_id":170,"start_account_caption":{"id":170,"serial_no":"100101","title":"\u73b0\u91d1","name":"100101 \u73b0\u91d1"},"end_account_caption":{"id":170,"serial_no":"100101","title":"\u73b0\u91d1","name":"100101 \u73b0\u91d1"}}}},{"account_code":"100102","account_name":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062","book_amount":790652.68,"source_amount":789952.68,"diff_amount":700,"status":"unmatched","status_text":"\u4e0d\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":171,"end_account_caption_id":171,"start_account_caption":{"id":171,"serial_no":"100102","title":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062","name":"100102 \u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062"},"end_account_caption":{"id":171,"serial_no":"100102","title":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062","name":"100102 \u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062"}}}},{"account_code":"100103","account_name":"\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c\u7fc1\u5bb6\u6210 6217000010081010749","book_amount":345.48,"source_amount":345.48,"diff_amount":0,"status":"matched","status_text":"\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":172,"end_account_caption_id":172,"start_account_caption":{"id":172,"serial_no":"100103","title":"\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c\u7fc1\u5bb6\u6210 6217000010081010749","name":"100103 \u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c\u7fc1\u5bb6\u6210 6217000010081010749"},"end_account_caption":{"id":172,"serial_no":"100103","title":"\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c\u7fc1\u5bb6\u6210 6217000010081010749","name":"100103 \u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c\u7fc1\u5bb6\u6210 6217000010081010749"}}}},{"account_code":"100104","account_name":"\u6dd8\u5b9d\u7f51","book_amount":0,"source_amount":0,"diff_amount":0,"status":"matched","status_text":"\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":173,"end_account_caption_id":173,"start_account_caption":{"id":173,"serial_no":"100104","title":"\u6dd8\u5b9d\u7f51","name":"100104 \u6dd8\u5b9d\u7f51"},"end_account_caption":{"id":173,"serial_no":"100104","title":"\u6dd8\u5b9d\u7f51","name":"100104 \u6dd8\u5b9d\u7f51"}}}},{"account_code":"100201","account_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","book_amount":1512811.93,"source_amount":1507555.72,"diff_amount":5256.21,"status":"unmatched","status_text":"\u4e0d\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":3,"end_account_caption_id":3,"start_account_caption":{"id":3,"serial_no":"100201","title":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","name":"100201 \u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"end_account_caption":{"id":3,"serial_no":"100201","title":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","name":"100201 \u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"}}}},{"account_code":"100202","account_name":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495","book_amount":23097.26,"source_amount":23097.26,"diff_amount":0,"status":"matched","status_text":"\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":4,"end_account_caption_id":4,"start_account_caption":{"id":4,"serial_no":"100202","title":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495","name":"100202 \u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495"},"end_account_caption":{"id":4,"serial_no":"100202","title":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495","name":"100202 \u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495"}}}},{"account_code":"100203","account_name":"\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d77\u6dc0\u897f\u533a\u4e16\u7eaa\u91d1\u6e90\u652f\u884c0200069919100105717","book_amount":55209.98,"source_amount":55209.98,"diff_amount":0,"status":"matched","status_text":"\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":169,"end_account_caption_id":169,"start_account_caption":{"id":169,"serial_no":"100203","title":"\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d77\u6dc0\u897f\u533a\u4e16\u7eaa\u91d1\u6e90\u652f\u884c0200069919100105717","name":"100203 \u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d77\u6dc0\u897f\u533a\u4e16\u7eaa\u91d1\u6e90\u652f\u884c0200069919100105717"},"end_account_caption":{"id":169,"serial_no":"100203","title":"\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d77\u6dc0\u897f\u533a\u4e16\u7eaa\u91d1\u6e90\u652f\u884c0200069919100105717","name":"100203 \u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d77\u6dc0\u897f\u533a\u4e16\u7eaa\u91d1\u6e90\u652f\u884c0200069919100105717"}}}},{"account_code":"100204","account_name":"22222222","book_amount":0,"source_amount":0,"diff_amount":0,"status":"matched","status_text":"\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":174,"end_account_caption_id":174,"start_account_caption":{"id":174,"serial_no":"100204","title":"22222222","name":"100204 22222222"},"end_account_caption":{"id":174,"serial_no":"100204","title":"22222222","name":"100204 22222222"}}}},{"account_code":"100205","account_name":"222","book_amount":0,"source_amount":0,"diff_amount":0,"status":"matched","status_text":"\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":175,"end_account_caption_id":175,"start_account_caption":{"id":175,"serial_no":"100205","title":"222","name":"100205 222"},"end_account_caption":{"id":175,"serial_no":"100205","title":"222","name":"100205 222"}}}},{"account_code":"100206","account_name":"2222","book_amount":0,"source_amount":0,"diff_amount":0,"status":"matched","status_text":"\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":176,"end_account_caption_id":176,"start_account_caption":{"id":176,"serial_no":"100206","title":"2222","name":"100206 2222"},"end_account_caption":{"id":176,"serial_no":"100206","title":"2222","name":"100206 2222"}}}},{"account_code":"100207","account_name":"2223","book_amount":0,"source_amount":0,"diff_amount":0,"status":"matched","status_text":"\u76f8\u7b26","target":{"LedgerBookSearch":{"period_start":"2026-05","period_end":"2026-05","start_account_caption_id":177,"end_account_caption_id":177,"start_account_caption":{"id":177,"serial_no":"100207","title":"2223","name":"100207 2223"},"end_account_caption":{"id":177,"serial_no":"100207","title":"2223","name":"100207 2223"}}}}]}},"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:04:45', 29420288) RETURNING "id" |
| 18:04:45.998 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:04:45.999 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |