ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4ca30f4c3bf: POST https://beta.jinchangxiao.com/vue/voucher-center/bill-list at 2026-07-07 02:56:15 pm by 39.156.194.178

Database Queries

总计12条数据
TimeDurationTypeQuery
  
14:56:15.3181.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:56:15.3200.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:56:15.3220.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:56:15.3230.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"

[+] Explain
14:56:15.3313.0 msSELECTSELECT COUNT(*) FROM (SELECT 20012 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", "e"."handler" AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-03-01') AND ("e"."wrote_date" <= '2026-07-31')) "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))

[+] Explain
14:56:15.3341.7 msSELECTSELECT COALESCE(SUM(b.amount), 0) AS "total_amount" FROM (SELECT 20012 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", "e"."handler" AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-03-01') AND ("e"."wrote_date" <= '2026-07-31')) "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))

[+] Explain
14:56:15.3362.0 msSELECTSELECT "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 20012 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", "e"."handler" AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-03-01') AND ("e"."wrote_date" <= '2026-07-31')) "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

[+] Explain
14:56:15.3390.5 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3457, 3451, 2115)

[+] Explain
14:56:15.3400.9 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (45, 46, 268, 262, 161, 701, 598, 678, 749, 731, 757, 59, 67)

[+] Explain
14:56:15.3410.3 msSELECTSELECT "id", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1001, 5087, 5252, 5360, 5295)

[+] Explain
14:56:15.3410.6 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 3, 6, 4)

[+] Explain
14:56:15.3442.9 msINSERTINSERT 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":"20012","generation_scope":"ungenerated","date_from":"2026-03-01","date_to":"2026-07-31","web_access_token":"ukNwOz-BjUcQL9I3n8iWo2JcLwCMuHVk"}', '{"code":2000,"result":{"list":[{"id":"20012_2350_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2350,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260409-00001","bill_date":"2026-04-09","completed_at":"","amount":55,"partner_name":"\u8054\u5f3a\u56fd\u9645\u8d38\u6613(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2349_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2349,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260408-00002","bill_date":"2026-04-08","completed_at":"","amount":0.32,"partner_name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2348_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2348,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260408-00001","bill_date":"2026-04-08","completed_at":"","amount":1,"partner_name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2347_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2347,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260403-00001","bill_date":"2026-04-03","completed_at":"","amount":67,"partner_name":"\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2346_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2346,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260402-00001","bill_date":"2026-04-02","completed_at":"","amount":1,"partner_name":"","department":"\u9500\u552e\u90e8","handler_name":"\u5218\u5fae","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2345_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2345,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260401-00003","bill_date":"2026-04-01","completed_at":"","amount":1,"partner_name":"\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2343_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2343,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260401-00001","bill_date":"2026-04-01","completed_at":"","amount":4000,"partner_name":"\u5e38\u9752\u6cf0\u8fbe(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2336_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2336,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260323-00003","bill_date":"2026-03-23","completed_at":"","amount":15332.71,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2335_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2335,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260323-00002","bill_date":"2026-03-23","completed_at":"","amount":644.54,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2334_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2334,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260323-00001","bill_date":"2026-03-23","completed_at":"","amount":30000,"partner_name":"\u5317\u4eac\u5609\u8fd0\u8fbe\u79d1\u6280\u5f00\u53d1\u80a1\u4efd\u6709\u9650\u516c\u53f8","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":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2333_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2333,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260320-00003","bill_date":"2026-03-20","completed_at":"","amount":23040,"partner_name":"\u6570\u529b\uff08\u5929\u6d25\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2332_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2332,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260320-00002","bill_date":"2026-03-20","completed_at":"","amount":35700,"partner_name":"","department":"\u9500\u552e\u90e8","handler_name":"\u5218\u5fae","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2331_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2331,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260320-00001","bill_date":"2026-03-20","completed_at":"","amount":9199,"partner_name":"","department":"\u9500\u552e\u90e8","handler_name":"\u5218\u5fae","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2330_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2330,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260318-00001","bill_date":"2026-03-18","completed_at":"","amount":32000,"partner_name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2329_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2329,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260316-00002","bill_date":"2026-03-16","completed_at":"","amount":1294.41,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2328_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2328,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260316-00001","bill_date":"2026-03-16","completed_at":"","amount":30400,"partner_name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2327_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2327,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260312-00001","bill_date":"2026-03-12","completed_at":"","amount":133000,"partner_name":"\u5317\u4eac\u8239\u6c34\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2326_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2326,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260309-00004","bill_date":"2026-03-09","completed_at":"","amount":5000,"partner_name":"\u5317\u4eac\u65b0\u5174\u9ad8\u79d1\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2324_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2324,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260309-00002","bill_date":"2026-03-09","completed_at":"","amount":3429.3,"partner_name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2323_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2323,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260309-00001","bill_date":"2026-03-09","completed_at":"","amount":3532,"partner_name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2325_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2325,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260309-00003","bill_date":"2026-03-05","completed_at":"","amount":7000,"partner_name":"","department":"\u9500\u552e\u90e8","handler_name":"\u9b4f\u6cfd\u6587","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2322_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2322,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260305-00001","bill_date":"2026-03-05","completed_at":"","amount":1661.92,"partner_name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2321_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2321,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260304-00002","bill_date":"2026-03-04","completed_at":"","amount":5322.61,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2320_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2320,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260304-00001","bill_date":"2026-03-04","completed_at":"","amount":2200,"partner_name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2319_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2319,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260303-00001","bill_date":"2026-03-03","completed_at":"","amount":186480,"partner_name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""}],"pagenation":{"totalcount":25,"thispage":1,"pagesize":200},"total_amount":529361.81},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-07 14:56:15', 30705920) RETURNING "id"

[+] Explain