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

Database Queries

总计11条数据
TimeDurationTypeQuery
  
18:06:38.9970.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
18:06:39.0000.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
18:06:39.0020.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
18:06:39.0030.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"

[+] Explain
18:06:39.0092.0 msSELECTSELECT COUNT(*) FROM (SELECT 20008 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", CASE WHEN COALESCE(e.amount, 0) > 0 THEN COALESCE(e.amount, 0) ELSE COALESCE(SUM(s.actual_total_amount), 0) END AS "amount", "e"."client_id" AS "client_id", NULL::integer 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_sales_outbounds" "e" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "s" ON s.erp_sales_outbound_id = e.id WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-02-01') AND ("e"."wrote_date" <= '2026-06-30') GROUP BY "e"."id", "e"."serial_no", "e"."wrote_date", "e"."amount", "e"."client_id", "e"."handler", "e"."created_by") "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
18:06:39.0121.7 msSELECTSELECT COALESCE(SUM(b.amount), 0) AS "total_amount" FROM (SELECT 20008 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", CASE WHEN COALESCE(e.amount, 0) > 0 THEN COALESCE(e.amount, 0) ELSE COALESCE(SUM(s.actual_total_amount), 0) END AS "amount", "e"."client_id" AS "client_id", NULL::integer 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_sales_outbounds" "e" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "s" ON s.erp_sales_outbound_id = e.id WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-02-01') AND ("e"."wrote_date" <= '2026-06-30') GROUP BY "e"."id", "e"."serial_no", "e"."wrote_date", "e"."amount", "e"."client_id", "e"."handler", "e"."created_by") "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
18:06:39.0141.8 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 20008 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", CASE WHEN COALESCE(e.amount, 0) > 0 THEN COALESCE(e.amount, 0) ELSE COALESCE(SUM(s.actual_total_amount), 0) END AS "amount", "e"."client_id" AS "client_id", NULL::integer 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_sales_outbounds" "e" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "s" ON s.erp_sales_outbound_id = e.id WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-02-01') AND ("e"."wrote_date" <= '2026-06-30') GROUP BY "e"."id", "e"."serial_no", "e"."wrote_date", "e"."amount", "e"."client_id", "e"."handler", "e"."created_by") "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
18:06:39.0160.4 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (982, 3359, 2032, 3448, 2021, 89, 79, 2125, 3281, 2526, 3443, 12, 3438, 3377)

[+] Explain
18:06:39.0160.3 msSELECTSELECT "id", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005, 5295, 5300, 5087)

[+] Explain
18:06:39.0170.3 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)

[+] Explain
18:06:39.0192.2 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":"20008","generation_scope":"ungenerated","date_from":"2026-02-01","date_to":"2026-06-30","web_access_token":"G2-mdsiVx4ajd063Zd6C9RL7pLl9o1cd"}', '{"code":2000,"result":{"list":[{"id":"20008_150_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":150,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260423-00001","bill_date":"2026-04-23","completed_at":"","amount":4234324,"partner_name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","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":"20008_149_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":149,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260408-00003","bill_date":"2026-04-08","completed_at":"","amount":24238558,"partner_name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","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":"20008_145_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":145,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260311-00001","bill_date":"2026-03-11","completed_at":"","amount":137520,"partner_name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u9500\u552e\u90e8","handler_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","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":"20008_144_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":144,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260310-00001","bill_date":"2026-03-10","completed_at":"","amount":3900,"partner_name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","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":"20008_143_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":143,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260304-00002","bill_date":"2026-03-04","completed_at":"","amount":2400,"partner_name":"\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","department":"\u9500\u552e\u90e8","handler_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","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":"20008_142_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":142,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260304-00001","bill_date":"2026-03-04","completed_at":"","amount":720,"partner_name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","department":"\u9500\u552e\u90e8","handler_name":"\u82cf\u6e05\u4e91","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":"20008_141_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":141,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260302-00001","bill_date":"2026-03-02","completed_at":"","amount":18600,"partner_name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","department":"\u9500\u552e\u90e8","handler_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","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":"20008_140_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":140,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260227-00001","bill_date":"2026-02-27","completed_at":"","amount":20700,"partner_name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)","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":"20008_139_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":139,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260210-00001","bill_date":"2026-02-10","completed_at":"","amount":312000,"partner_name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","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":"20008_138_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":138,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260209-00001","bill_date":"2026-02-09","completed_at":"","amount":63840,"partner_name":"\u5bd2\u5e8f\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8(EDA)","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":"20008_137_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":137,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260206-00001","bill_date":"2026-02-06","completed_at":"","amount":3000,"partner_name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","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":"20008_136_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":136,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260205-00002","bill_date":"2026-02-05","completed_at":"","amount":10000,"partner_name":"\u5317\u4eac\u534e\u5b87\u65f6\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8","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":"20008_135_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":135,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260205-00001","bill_date":"2026-02-05","completed_at":"","amount":57000,"partner_name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","department":"\u9500\u552e\u90e8","handler_name":"\u82cf\u6e05\u4e91","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":"20008_134_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":134,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260204-00001","bill_date":"2026-02-04","completed_at":"","amount":21880,"partner_name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","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":"20008_133_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":133,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260203-00001","bill_date":"2026-02-03","completed_at":"","amount":3837034,"partner_name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","department":"\u9500\u552e\u90e8","handler_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","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":"20008_132_0_0","object_type":20008,"object_type_name":"\u9500\u552e\u51fa\u5e93\u5355","object_type_color":"","object_type_tip":"","object_id":132,"event_type":0,"event_id":0,"business_node":"","bill_no":"XSCKD-20260202-00001","bill_date":"2026-02-02","completed_at":"","amount":1630000,"partner_name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","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":""}],"pagenation":{"totalcount":16,"thispage":1,"pagesize":200},"total_amount":34591476},"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:06:39', 24445184) RETURNING "id"

[+] Explain