6a42466e2e10c: POST https://beta.jinchangxiao.com/vue/voucher-center/bill-list at 2026-06-29 06:18:22 pm by 221.216.117.25
Log Messages
总计39条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 18:18:22.187 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 18:18:22.187 | trace | yii\base\Module::getModule | Loading module: debug |
| 18:18:22.188 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 18:18:22.189 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 18:18:22.189 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 18:18:22.189 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:18:22.190 | info | time tracing start | 1782728302190547968 |
| 18:18:22.190 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 18:18:22.191 | trace | yii\web\Application::handleRequest | Route requested: 'vue/voucher-center/bill-list' |
| 18:18:22.191 | trace | yii\base\Module::getModule | Loading module: vue |
| 18:18:22.192 | info | yii\web\Session::open | Session started |
| 18:18:22.194 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 18:18:22.194 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 18:18:22.196 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:18:22.196 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:18:22.197 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 18:18:22.198 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:18:22.198 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:18:22.199 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 18:18:22.200 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id" |
| 18:18:22.201 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:18:22.201 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:18:22.201 | trace | yii\base\Controller::runAction | Route to run: vue/voucher-center/bill-list |
| 18:18:22.202 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:18:22.204 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 18:18:22.204 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\VoucherCenterController::actionBillList() |
| 18:18:22.204 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:18:22.205 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:18:22.207 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT 20018 AS "object_type", "e"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "e"."serial_no" AS "bill_no", "e"."wrote_date" AS "bill_date", NULL::timestamp without time zone AS "completed_at", "e"."amount" AS "amount", "e"."client_id" AS "client_id", "e"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", NULL::integer AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", "e"."have_invoice" AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-03-05') AND ("e"."wrote_date" <= '2026-06-30')) "b" LEFT JOIN (SELECT "v"."object_type" AS "object_type", "v"."object_id" AS "object_id", COALESCE(v.event_type, 0) AS "event_type", COALESCE(v.event_id, 0) AS "event_id", COUNT(*) FILTER (WHERE v.status = 1) AS "success_count", COUNT(*) FILTER (WHERE v.status = 0) AS "fail_count", MAX(v.book_date) FILTER (WHERE v.status = 1) AS "last_book_date" FROM "a57be577deb434"."tbl_voucher_gen_items" "v" WHERE "v"."ledger_id"=1 GROUP BY "v"."object_type", "v"."object_id", COALESCE(v.event_type, 0), COALESCE(v.event_id, 0)) "g" ON g.object_type = b.object_type AND g.object_id = b.object_id AND g.event_type = b.event_type AND g.event_id = b.event_id WHERE (("g"."success_count" IS NULL) OR ("g"."success_count"=0)) AND (("b"."object_type" NOT IN (20, 20018)) OR ("b"."have_invoice"=TRUE) OR (EXISTS (SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships r INNER JOIN a57be577deb434.tbl_term_taxonomies tt ON r.taxonomy_id = tt.id WHERE r.term_id = 18 AND r.object_id = b.object_id AND tt.serial_no IN ('221106','640301','640302','640303','600704') AND ((b.object_type = 20 AND r.object_type = 7) OR (b.object_type = 20018 AND r.object_type = 11))))) AND ("b"."amount" > 0) AND (("b"."object_type" <> 109) OR ("b"."is_verified"=TRUE)) |
| 18:18:22.216 | info | yii\db\Command::query | SELECT COALESCE(SUM(b.amount), 0) AS "total_amount" FROM (SELECT 20018 AS "object_type", "e"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "e"."serial_no" AS "bill_no", "e"."wrote_date" AS "bill_date", NULL::timestamp without time zone AS "completed_at", "e"."amount" AS "amount", "e"."client_id" AS "client_id", "e"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", NULL::integer AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", "e"."have_invoice" AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-03-05') AND ("e"."wrote_date" <= '2026-06-30')) "b" LEFT JOIN (SELECT "v"."object_type" AS "object_type", "v"."object_id" AS "object_id", COALESCE(v.event_type, 0) AS "event_type", COALESCE(v.event_id, 0) AS "event_id", COUNT(*) FILTER (WHERE v.status = 1) AS "success_count", COUNT(*) FILTER (WHERE v.status = 0) AS "fail_count", MAX(v.book_date) FILTER (WHERE v.status = 1) AS "last_book_date" FROM "a57be577deb434"."tbl_voucher_gen_items" "v" WHERE "v"."ledger_id"=1 GROUP BY "v"."object_type", "v"."object_id", COALESCE(v.event_type, 0), COALESCE(v.event_id, 0)) "g" ON g.object_type = b.object_type AND g.object_id = b.object_id AND g.event_type = b.event_type AND g.event_id = b.event_id WHERE (("g"."success_count" IS NULL) OR ("g"."success_count"=0)) AND (("b"."object_type" NOT IN (20, 20018)) OR ("b"."have_invoice"=TRUE) OR (EXISTS (SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships r INNER JOIN a57be577deb434.tbl_term_taxonomies tt ON r.taxonomy_id = tt.id WHERE r.term_id = 18 AND r.object_id = b.object_id AND tt.serial_no IN ('221106','640301','640302','640303','600704') AND ((b.object_type = 20 AND r.object_type = 7) OR (b.object_type = 20018 AND r.object_type = 11))))) AND ("b"."amount" > 0) AND (("b"."object_type" <> 109) OR ("b"."is_verified"=TRUE)) |
| 18:18:22.222 | info | yii\db\Command::query | SELECT "b"."object_type" AS "object_type", "b"."object_id" AS "object_id", "b"."event_type" AS "event_type", "b"."event_id" AS "event_id", "b"."business_node" AS "business_node", "b"."bill_no" AS "bill_no", "b"."bill_date" AS "bill_date", "b"."completed_at" AS "completed_at", "b"."amount" AS "amount", "b"."client_id" AS "client_id", "b"."supplier_id" AS "supplier_id", "b"."contact_id" AS "contact_id", "b"."department_id" AS "department_id", "b"."handler_id" AS "handler_id", "b"."created_by" AS "created_by", "b"."erp_bank_id" AS "erp_bank_id", "b"."have_invoice" AS "have_invoice", "b"."is_verified" AS "is_verified", COALESCE(g.success_count, 0) AS "gen_success_count", COALESCE(g.fail_count, 0) AS "gen_fail_count", COALESCE(CAST(g.last_book_date AS text), '') AS "gen_book_date" FROM (SELECT 20018 AS "object_type", "e"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "e"."serial_no" AS "bill_no", "e"."wrote_date" AS "bill_date", NULL::timestamp without time zone AS "completed_at", "e"."amount" AS "amount", "e"."client_id" AS "client_id", "e"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", NULL::integer AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", "e"."have_invoice" AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-03-05') AND ("e"."wrote_date" <= '2026-06-30')) "b" LEFT JOIN (SELECT "v"."object_type" AS "object_type", "v"."object_id" AS "object_id", COALESCE(v.event_type, 0) AS "event_type", COALESCE(v.event_id, 0) AS "event_id", COUNT(*) FILTER (WHERE v.status = 1) AS "success_count", COUNT(*) FILTER (WHERE v.status = 0) AS "fail_count", MAX(v.book_date) FILTER (WHERE v.status = 1) AS "last_book_date" FROM "a57be577deb434"."tbl_voucher_gen_items" "v" WHERE "v"."ledger_id"=1 GROUP BY "v"."object_type", "v"."object_id", COALESCE(v.event_type, 0), COALESCE(v.event_id, 0)) "g" ON g.object_type = b.object_type AND g.object_id = b.object_id AND g.event_type = b.event_type AND g.event_id = b.event_id WHERE (("g"."success_count" IS NULL) OR ("g"."success_count"=0)) AND (("b"."object_type" NOT IN (20, 20018)) OR ("b"."have_invoice"=TRUE) OR (EXISTS (SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships r INNER JOIN a57be577deb434.tbl_term_taxonomies tt ON r.taxonomy_id = tt.id WHERE r.term_id = 18 AND r.object_id = b.object_id AND tt.serial_no IN ('221106','640301','640302','640303','600704') AND ((b.object_type = 20 AND r.object_type = 7) OR (b.object_type = 20018 AND r.object_type = 11))))) AND ("b"."amount" > 0) AND (("b"."object_type" <> 109) OR ("b"."is_verified"=TRUE)) ORDER BY "bill_date" DESC, "object_type", "object_id" DESC, "event_type", "event_id" DESC LIMIT 200 |
| 18:18:22.227 | info | yii\db\Command::query | SELECT "id", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
| 18:18:22.228 | info | yii\db\Command::query | SELECT "id", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6 |
| 18:18:22.229 | info | yii\db\Command::query | SELECT "r"."object_id" AS "object_id" FROM "a57be577deb434"."tbl_term_taxonomy_relationships" "r" INNER JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON r.taxonomy_id = tt.id WHERE ("r"."term_id"=18) AND ("r"."object_type"=11) AND ("r"."object_id"=8308) AND ("tt"."serial_no" IN (221106, 640301, 640302, 640303, 600704)) GROUP BY "r"."object_id" |
| 18:18:22.230 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:18:22.231 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 18:18:22.231 | 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', 1001, 5, 'vue/voucher-center/bill-list', '{"page":"1","pageSize":"200","object_type":"20018","generation_scope":"ungenerated","date_from":"2026-03-05","date_to":"2026-06-30","web_access_token":"G2-mdsiVx4ajd063Zd6C9RL7pLl9o1cd"}', '{"code":2000,"result":{"list":[{"id":"20018_8308_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8308,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260305-00001","bill_date":"2026-03-05","completed_at":"","amount":52733.33,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":false,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""}],"pagenation":{"totalcount":1,"thispage":1,"pagesize":200},"total_amount":52733.33},"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:18:22', 40764928) RETURNING "id" |
| 18:18:22.236 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 18:18:22.236 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |