ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a42468d91d59: POST https://beta.jinchangxiao.com/vue/voucher-center/bill-list at 2026-06-29 06:18:53 pm by 221.216.117.25

Performance Profiling

Total processing time: 82 ms; Peak memory: 5.273 MB. Show Profiling Timeline

总计14条数据
TimeDurationCategoryInfo
  
18:18:53.6026.0 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
18:18:53.6265.2 msyii\db\Command::querySELECT 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
18:18:53.6354.2 msyii\db\Command::querySELECT "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 ORDER BY "bill_date" DESC, "object_type", "object_id" DESC, "event_type", "event_id" DESC LIMIT 200
18:18:53.6083.4 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
18:18:53.6492.8 msyii\db\Command::queryINSERT 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":"all","date_from":"2026-03-05","date_to":"2026-06-30","web_access_token":"G2-mdsiVx4ajd063Zd6C9RL7pLl9o1cd"}', '{"code":2000,"result":{"list":[{"id":"20018_8489_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8489,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260604-00001","bill_date":"2026-06-04","completed_at":"","amount":1,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8488_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8488,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260527-00002","bill_date":"2026-05-27","completed_at":"","amount":1,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8487_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8487,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260527-00001","bill_date":"2026-05-27","completed_at":"","amount":1,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8486_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8486,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260526-00002","bill_date":"2026-05-26","completed_at":"","amount":1,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8485_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8485,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260526-00001","bill_date":"2026-05-26","completed_at":"","amount":1,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8484_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8484,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260525-00001","bill_date":"2026-05-25","completed_at":"","amount":8,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8482_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8482,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260521-00001","bill_date":"2026-05-21","completed_at":"","amount":100,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u8f6f\u4ef6\u5f00\u53d1","handler_name":"\u8463\u8363","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8480_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8480,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260520-00001","bill_date":"2026-05-20","completed_at":"","amount":600,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u8f6f\u4ef6\u5f00\u53d1","handler_name":"\u8463\u8363","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8474_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8474,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260512-00001","bill_date":"2026-05-12","completed_at":"","amount":1,"partner_name":"","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8435_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8435,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260407-00001","bill_date":"2026-04-07","completed_at":"","amount":333,"partner_name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8421_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8421,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260323-00001","bill_date":"2026-03-23","completed_at":"","amount":700,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8420_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8420,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260320-00028","bill_date":"2026-03-20","completed_at":"","amount":101.65,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8419_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8419,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260320-00027","bill_date":"2026-03-20","completed_at":"","amount":31.5,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8418_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8418,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260320-00026","bill_date":"2026-03-20","completed_at":"","amount":1980,"partner_name":"\u521b\u4e1a\u9ed1\u9a6c\u79d1\u6280\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8367_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8367,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260316-00005","bill_date":"2026-03-16","completed_at":"","amount":4102,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8366_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8366,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260316-00004","bill_date":"2026-03-16","completed_at":"","amount":2765.76,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8365_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8365,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260316-00003","bill_date":"2026-03-16","completed_at":"","amount":4500,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8364_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8364,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260316-00002","bill_date":"2026-03-16","completed_at":"","amount":2500,"partner_name":"\u5317\u4eac\u6613\u540c\u4fe1\u548c\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8363_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8363,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260316-00006","bill_date":"2026-03-16","completed_at":"","amount":2000,"partner_name":"\u5357\u4eac\u9ec4\u89d2\u6811\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8362_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8362,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260316-00001","bill_date":"2026-03-16","completed_at":"","amount":150,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8361_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8361,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260313-00001","bill_date":"2026-03-13","completed_at":"","amount":24.5,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8315_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8315,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260310-00002","bill_date":"2026-03-10","completed_at":"","amount":150,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8314_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8314,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260310-00001","bill_date":"2026-03-10","completed_at":"","amount":2667.27,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8313_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8313,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260309-00003","bill_date":"2026-03-09","completed_at":"","amount":20100,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8312_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8312,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260309-00002","bill_date":"2026-03-09","completed_at":"","amount":12000,"partner_name":"\u4e2d\u56fd\u7f51\u7edc\u5b89\u5168\u5ba1\u6838\u8ba4\u8bc1\u548c\u5e02\u573a\u76d1\u7ba1\u5927\u6570\u636e\u4e2d\u5fc3","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8311_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8311,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260309-00001","bill_date":"2026-03-09","completed_at":"","amount":250,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8310_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8310,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260305-00003","bill_date":"2026-03-05","completed_at":"","amount":14,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20018_8309_0_0","object_type":20018,"object_type_name":"\u73b0\u91d1\u8d39\u7528\u5355","object_type_color":"","object_type_tip":"","object_id":8309,"event_type":0,"event_id":0,"business_node":"","bill_no":"XJFYD-20260305-00002","bill_date":"2026-03-05","completed_at":"","amount":421.54,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u4e0d\u7b26\u5408\u751f\u6210\u6761\u4ef6","can_select":false,"have_invoice":false,"is_verified":true,"is_error":true,"error_code":"no_invoice","error_display":"\u8d39\u7528\u62a5\u9500\u672a\u4e0a\u4f20\u53d1\u7968","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"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":29,"thispage":1,"pagesize":200},"total_amount":108238.55},"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:53', 49683200) RETURNING "id"
18:18:53.6322.6 msyii\db\Command::querySELECT 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
18:18:53.6152.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
18:18:53.6392.2 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2150
18:18:53.6451.9 msyii\db\Command::querySELECT "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" IN (8489, 8488, 8487, 8486, 8485, 8484, 8482, 8480, 8474, 8435, 8421, 8420, 8419, 8418, 8367, 8366, 8365, 8364, 8363, 8362, 8361, 8315, 8314, 8313, 8312, 8311, 8310, 8309, 8308)) AND ("tt"."serial_no" IN (221106, 640301, 640302, 640303, 600704)) GROUP BY "r"."object_id"
18:18:53.6181.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"
18:18:53.6420.7 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 763, 487, 762, 761)
18:18:53.6130.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
18:18:53.6440.6 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 10, 6)
18:18:53.6430.4 msyii\db\Command::querySELECT "id", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5250, 5252)