ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4efaaec0353: POST https://beta.jinchangxiao.com/vue/voucher-center/bill-list at 2026-07-09 09:34:38 am by 39.156.194.178

Database Queries

总计14条数据
TimeDurationTypeQuery
  
09:34:38.7910.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
09:34:38.7940.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
09:34:38.7950.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
09:34:38.7970.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"

[+] Explain
09:34:38.8035.4 msSELECTSELECT COUNT(*) FROM ((SELECT 20021 AS "object_type", "t"."id" AS "object_id", 1 AS "event_type", "e"."id" AS "event_id", '付款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(e.settle_at AS date) AS "bill_date", "e"."settle_at" AS "completed_at", "e"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", "e"."erp_bank_id" AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" INNER JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "e" ON e.erp_other_collect_ticket_id = t.id WHERE ("t"."status" IN (2, 5)) AND (NOT ("e"."settle_at" IS NULL)) AND ("e"."amount" > 0) AND ("e"."settle_at" >= '2026-02-01') AND ("e"."settle_at" <= '2026-07-31 23:59:59')) UNION ALL ( SELECT 20021 AS "object_type", "t"."id" AS "object_id", 2 AS "event_type", "p"."id" AS "event_id", '收款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(t.bank_settle_at AS date) AS "bill_date", "t"."bank_settle_at" AS "completed_at", "p"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" INNER JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "p" ON p.erp_other_collect_ticket_id = t.id WHERE ("t"."status" IN (2, 5)) AND (NOT ("t"."bank_settle_at" IS NULL)) AND ("p"."amount" > 0) AND ("t"."bank_settle_at" >= '2026-02-01') AND ("t"."bank_settle_at" <= '2026-07-31 23:59:59') )) "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
09:34:38.8092.2 msSELECTSELECT COALESCE(SUM(b.amount), 0) AS "total_amount" FROM ((SELECT 20021 AS "object_type", "t"."id" AS "object_id", 1 AS "event_type", "e"."id" AS "event_id", '付款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(e.settle_at AS date) AS "bill_date", "e"."settle_at" AS "completed_at", "e"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", "e"."erp_bank_id" AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" INNER JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "e" ON e.erp_other_collect_ticket_id = t.id WHERE ("t"."status" IN (2, 5)) AND (NOT ("e"."settle_at" IS NULL)) AND ("e"."amount" > 0) AND ("e"."settle_at" >= '2026-02-01') AND ("e"."settle_at" <= '2026-07-31 23:59:59')) UNION ALL ( SELECT 20021 AS "object_type", "t"."id" AS "object_id", 2 AS "event_type", "p"."id" AS "event_id", '收款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(t.bank_settle_at AS date) AS "bill_date", "t"."bank_settle_at" AS "completed_at", "p"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" INNER JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "p" ON p.erp_other_collect_ticket_id = t.id WHERE ("t"."status" IN (2, 5)) AND (NOT ("t"."bank_settle_at" IS NULL)) AND ("p"."amount" > 0) AND ("t"."bank_settle_at" >= '2026-02-01') AND ("t"."bank_settle_at" <= '2026-07-31 23:59:59') )) "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
09:34:38.8122.7 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 20021 AS "object_type", "t"."id" AS "object_id", 1 AS "event_type", "e"."id" AS "event_id", '付款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(e.settle_at AS date) AS "bill_date", "e"."settle_at" AS "completed_at", "e"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", "e"."erp_bank_id" AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" INNER JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "e" ON e.erp_other_collect_ticket_id = t.id WHERE ("t"."status" IN (2, 5)) AND (NOT ("e"."settle_at" IS NULL)) AND ("e"."amount" > 0) AND ("e"."settle_at" >= '2026-02-01') AND ("e"."settle_at" <= '2026-07-31 23:59:59')) UNION ALL ( SELECT 20021 AS "object_type", "t"."id" AS "object_id", 2 AS "event_type", "p"."id" AS "event_id", '收款'::text AS "business_node", "t"."serial_no" AS "bill_no", CAST(t.bank_settle_at AS date) AS "bill_date", "t"."bank_settle_at" AS "completed_at", "p"."amount" AS "amount", "t"."client_id" AS "client_id", "t"."supplier_id" AS "supplier_id", "t"."contact_id" AS "contact_id", NULL::integer AS "department_id", "t"."handler" AS "handler_id", "t"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" INNER JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "p" ON p.erp_other_collect_ticket_id = t.id WHERE ("t"."status" IN (2, 5)) AND (NOT ("t"."bank_settle_at" IS NULL)) AND ("p"."amount" > 0) AND ("t"."bank_settle_at" >= '2026-02-01') AND ("t"."bank_settle_at" <= '2026-07-31 23:59:59') )) "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
09:34:38.8150.9 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3351, 2133, 1331, 2150, 2166)

[+] Explain
09:34:38.8170.6 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 45, 138)

[+] Explain
09:34:38.8170.3 msSELECTSELECT "id", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5300)

[+] Explain
09:34:38.8180.6 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 4)

[+] Explain
09:34:38.8190.5 msSELECTSELECT "id", "title", "serial_no" FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1

[+] Explain
09:34:38.8200.7 msSELECTSELECT "serial_no", "title" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"=1) AND ("serial_no"='100201') AND ("is_delete"=FALSE)

[+] Explain
09:34:38.8221.8 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":"20021","generation_scope":"ungenerated","date_from":"2026-02-01","date_to":"2026-07-31","web_access_token":"1miv9vbRO-laHXjWHcrxyLIdOPR3NCIy"}', '{"code":2000,"result":{"list":[{"id":"20021_64_1_75","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":64,"event_type":1,"event_id":75,"business_node":"\u4ed8\u6b3e","bill_no":"QTYSD-20260615-00001","bill_date":"2026-06-15","completed_at":"2026-06-15 10:30:25","amount":10,"partner_name":"\u4e2d\u56fd\u8239\u8236\u96c6\u56e2\u98ce\u7535\u53d1\u5c55\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","fund_account_caption_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","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":"20021_61_1_74","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":61,"event_type":1,"event_id":74,"business_node":"\u4ed8\u6b3e","bill_no":"QTYSD-20260611-00005","bill_date":"2026-06-15","completed_at":"2026-06-15 10:10:55","amount":0.01,"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":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","fund_account_caption_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","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":"20021_63_2_1","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":63,"event_type":2,"event_id":1,"business_node":"\u6536\u6b3e","bill_no":"QTYSD-20260611-00007","bill_date":"2026-06-11","completed_at":"2026-06-11 17:44:12","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":"\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":"20021_62_1_73","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":62,"event_type":1,"event_id":73,"business_node":"\u4ed8\u6b3e","bill_no":"QTYSD-20260611-00006","bill_date":"2026-06-11","completed_at":"2026-06-11 17:44:48","amount":1,"partner_name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","fund_account_caption_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","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":"20021_60_1_69","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":60,"event_type":1,"event_id":69,"business_node":"\u4ed8\u6b3e","bill_no":"QTYSD-20260611-00004","bill_date":"2026-06-11","completed_at":"2026-06-11 15:47:09","amount":200,"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":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","fund_account_caption_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","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":"20021_58_1_70","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":58,"event_type":1,"event_id":70,"business_node":"\u4ed8\u6b3e","bill_no":"QTYSD-20260611-00002","bill_date":"2026-06-11","completed_at":"2026-06-11 15:52:59","amount":8000,"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":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","fund_account_caption_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","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":"20021_57_1_62","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":57,"event_type":1,"event_id":62,"business_node":"\u4ed8\u6b3e","bill_no":"QTYSD-20260611-00001","bill_date":"2026-06-11","completed_at":"2026-06-11 15:12:45","amount":100,"partner_name":"\u4e09\u76db\u667a\u6167\u6559\u80b2\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","fund_account_caption_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","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":"20021_54_1_56","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":54,"event_type":1,"event_id":56,"business_node":"\u4ed8\u6b3e","bill_no":"QTYSD-20260408-00001","bill_date":"2026-04-08","completed_at":"2026-04-08 15:30:13","amount":50000,"partner_name":"\u8054\u5f3a\u56fd\u9645\u8d38\u6613(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","fund_account_caption_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","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":"20021_53_1_55","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":53,"event_type":1,"event_id":55,"business_node":"\u4ed8\u6b3e","bill_no":"QTYSD-20260407-00001","bill_date":"2026-04-07","completed_at":"2026-04-07 16:36:36","amount":111,"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":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","fund_account_caption_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","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":"20021_50_1_53","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":50,"event_type":1,"event_id":53,"business_node":"\u4ed8\u6b3e","bill_no":"QTYSD-20260325-00002","bill_date":"2026-03-25","completed_at":"2026-03-25 10:59:32","amount":21488,"partner_name":"\u6df1\u4fe1\u670d \u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","department":"\u9500\u552e\u90e8","handler_name":"\u82cf\u6e05\u4e91","fund_account_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","fund_account_caption_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","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":"20021_48_1_50","object_type":20021,"object_type_name":"\u5176\u4ed6\u5e94\u6536\u5355","object_type_color":"","object_type_tip":"","object_id":48,"event_type":1,"event_id":50,"business_node":"\u4ed8\u6b3e","bill_no":"QTYSD-20260311-00001","bill_date":"2026-03-11","completed_at":"2026-03-11 16:29:08","amount":9488,"partner_name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\/\u6df1\u5733\u6c5f\u539f\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u9500\u552e\u90e8","handler_name":"\u82cf\u6e05\u4e91","fund_account_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","fund_account_caption_name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","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":11,"thispage":1,"pagesize":200},"total_amount":89399.01},"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-09 09:34:38', 33906944) RETURNING "id"

[+] Explain