ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a38ed4e734da: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-cash-flow at 2026-06-22 04:07:42 pm by 221.216.117.25

Performance Profiling

Total processing time: 117 ms; Peak memory: 5.116 MB. Show Profiling Timeline

总计10条数据
TimeDurationCategoryInfo
  
16:07:42.5369.0 msyii\db\Command::querySELECT "cash_flow_item_code", COALESCE(sum(in_amount), 0) AS "in_amount", COALESCE(sum(out_amount), 0) AS "out_amount" FROM (SELECT "l".*, CASE WHEN l.ticket_type = 20012 AND ( EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_payment_ticket_settles pts WHERE pts.erp_payment_ticket_id = l.object_id AND pts.sales_contract_id IS NOT NULL) OR EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_payment_tickets pt WHERE pt.id = l.object_id AND pt.sales_contract_id IS NOT NULL) ) THEN '200101' WHEN l.ticket_type = 20013 AND ( EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_collect_ticket_settles cts WHERE cts.erp_collect_ticket_id = l.object_id AND cts.purchase_contract_id IS NOT NULL) OR EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_collect_tickets ct WHERE ct.id = l.object_id AND ct.purchase_contract_id IS NOT NULL) ) THEN '200105' WHEN l.ticket_type = 20013 AND EXISTS ( SELECT 1 FROM a57be577deb434.tbl_erp_collect_ticket_settles cts WHERE cts.erp_collect_ticket_id = l.object_id AND (cts.erp_other_income_ticket_id IS NOT NULL OR cts.erp_other_collect_ticket_id IS NOT NULL) ) THEN '200103' WHEN l.ticket_type = 20013 THEN '200101' WHEN l.ticket_type = 20015 AND EXISTS ( SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships tr LEFT JOIN a57be577deb434.tbl_term_taxonomies tt ON tt.id = tr.taxonomy_id WHERE tr.object_id = l.object_id AND tr.object_type = 14 AND tr.term_id = 20 AND tt.name LIKE '%税费返还%' ) THEN '200102' WHEN l.ticket_type = 20015 THEN '200103' WHEN l.ticket_type = 20012 AND ( EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_payment_ticket_settles pts WHERE pts.erp_payment_ticket_id = l.object_id AND pts.purchase_contract_id IS NOT NULL) OR EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_payment_tickets pt WHERE pt.id = l.object_id AND pt.purchase_contract_id IS NOT NULL) ) THEN '200105' WHEN l.ticket_type = 20019 THEN '200105' WHEN l.ticket_type IN (20023, 20024, 20025, 20027) THEN '200106' WHEN l.ticket_type = 20026 THEN '200107' WHEN l.ticket_type IN (20012, 20018, 20020, 20021) THEN '200108' WHEN l.in_amount IS NOT NULL THEN '200103' ELSE '200108' END AS "cash_flow_item_code" FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" WHERE ("l"."ticket_type" <> 20017) AND (("l"."in_amount" IS NOT NULL) OR ("l"."out_amount" IS NOT NULL)) AND ("l"."settle_at" >= '2026-06-01 00:00:00') AND ("l"."settle_at" <= '2026-06-30 23:59:59')) "cf" GROUP BY "cash_flow_item_code"
16:07:42.5498.9 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_banks"
16:07:42.5688.3 msyii\db\Command::querySELECT "cash_flow_item_code", COALESCE(sum(in_amount), 0) AS "in_amount", COALESCE(sum(out_amount), 0) AS "out_amount" FROM (SELECT "l".*, CASE WHEN l.ticket_type = 20012 AND ( EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_payment_ticket_settles pts WHERE pts.erp_payment_ticket_id = l.object_id AND pts.sales_contract_id IS NOT NULL) OR EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_payment_tickets pt WHERE pt.id = l.object_id AND pt.sales_contract_id IS NOT NULL) ) THEN '200101' WHEN l.ticket_type = 20013 AND ( EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_collect_ticket_settles cts WHERE cts.erp_collect_ticket_id = l.object_id AND cts.purchase_contract_id IS NOT NULL) OR EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_collect_tickets ct WHERE ct.id = l.object_id AND ct.purchase_contract_id IS NOT NULL) ) THEN '200105' WHEN l.ticket_type = 20013 AND EXISTS ( SELECT 1 FROM a57be577deb434.tbl_erp_collect_ticket_settles cts WHERE cts.erp_collect_ticket_id = l.object_id AND (cts.erp_other_income_ticket_id IS NOT NULL OR cts.erp_other_collect_ticket_id IS NOT NULL) ) THEN '200103' WHEN l.ticket_type = 20013 THEN '200101' WHEN l.ticket_type = 20015 AND EXISTS ( SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships tr LEFT JOIN a57be577deb434.tbl_term_taxonomies tt ON tt.id = tr.taxonomy_id WHERE tr.object_id = l.object_id AND tr.object_type = 14 AND tr.term_id = 20 AND tt.name LIKE '%税费返还%' ) THEN '200102' WHEN l.ticket_type = 20015 THEN '200103' WHEN l.ticket_type = 20012 AND ( EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_payment_ticket_settles pts WHERE pts.erp_payment_ticket_id = l.object_id AND pts.purchase_contract_id IS NOT NULL) OR EXISTS (SELECT 1 FROM a57be577deb434.tbl_erp_payment_tickets pt WHERE pt.id = l.object_id AND pt.purchase_contract_id IS NOT NULL) ) THEN '200105' WHEN l.ticket_type = 20019 THEN '200105' WHEN l.ticket_type IN (20023, 20024, 20025, 20027) THEN '200106' WHEN l.ticket_type = 20026 THEN '200107' WHEN l.ticket_type IN (20012, 20018, 20020, 20021) THEN '200108' WHEN l.in_amount IS NOT NULL THEN '200103' ELSE '200108' END AS "cash_flow_item_code" FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" WHERE ("l"."ticket_type" <> 20017) AND (("l"."in_amount" IS NOT NULL) OR ("l"."out_amount" IS NOT NULL)) AND ("l"."settle_at" >= '2026-01-01 00:00:00') AND ("l"."settle_at" <= '2026-06-30 23:59:59')) "cf" GROUP BY "cash_flow_item_code"
16:07:42.4926.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:07:42.5136.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:07:42.5634.0 msyii\db\Command::querySELECT COALESCE(sum(in_amount), 0) AS "in_amount", COALESCE(sum(out_amount), 0) AS "out_amount" FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" WHERE "settle_at" < '2026-06-01 00:00:00'
16:07:42.5801.7 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/erp-analysis/list-cash-flow', '{"period":"2026-06","show_last_year_accumulated":"false"}', '{"code":2000,"result":{"list":[{"line_no":1,"code":"2001","name":"\u4e00\u3001\u7ecf\u8425\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u6807\u9898\u884c","direction":"","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u4e00\u3001\u7ecf\u8425\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf","index":1,"level":0,"month_amount":"","year_amount":""},{"line_no":2,"code":"200101","name":"\u9500\u552e\u5546\u54c1\u3001\u63d0\u4f9b\u52b3\u52a1\u6536\u5230\u7684\u73b0\u91d1","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u9500\u552e\u5546\u54c1\u3001\u63d0\u4f9b\u52b3\u52a1\u6536\u5230\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":10542729.1},{"line_no":3,"code":"200102","name":"\u6536\u5230\u7684\u7a0e\u8d39\u8fd4\u8fd8","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u6536\u5230\u7684\u7a0e\u8d39\u8fd4\u8fd8","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":4,"code":"200103","name":"\u6536\u5230\u5176\u4ed6\u4e0e\u7ecf\u8425\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":1,"out_amount":"0","amount":1,"current_amount":1,"item_name":"\u6536\u5230\u5176\u4ed6\u4e0e\u7ecf\u8425\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":1,"year_amount":711240.49},{"line_no":5,"code":"200104","name":"\u7ecf\u8425\u6d3b\u52a8\u73b0\u91d1\u6d41\u5165\u5c0f\u8ba1","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u5c0f\u8ba1\u884c","direction":"","income_amount":1,"out_amount":"0","amount":1,"current_amount":1,"item_name":"\u7ecf\u8425\u6d3b\u52a8\u73b0\u91d1\u6d41\u5165\u5c0f\u8ba1","index":2,"level":1,"month_amount":1,"year_amount":11253969.59},{"line_no":6,"code":"200105","name":"\u8d2d\u4e70\u5546\u54c1\u3001\u63a5\u53d7\u52b3\u52a1\u652f\u4ed8\u7684\u73b0\u91d1","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":1,"amount":1,"current_amount":1,"item_name":"\u8d2d\u4e70\u5546\u54c1\u3001\u63a5\u53d7\u52b3\u52a1\u652f\u4ed8\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":1,"year_amount":7462489.88},{"line_no":7,"code":"200106","name":"\u652f\u4ed8\u7ed9\u804c\u5de5\u4ee5\u53ca\u4e3a\u804c\u5de5\u652f\u4ed8\u7684\u73b0\u91d1","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":23023,"amount":23023,"current_amount":23023,"item_name":"\u652f\u4ed8\u7ed9\u804c\u5de5\u4ee5\u53ca\u4e3a\u804c\u5de5\u652f\u4ed8\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":23023,"year_amount":1410638.35},{"line_no":8,"code":"200107","name":"\u652f\u4ed8\u7684\u5404\u9879\u7a0e\u8d39","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u652f\u4ed8\u7684\u5404\u9879\u7a0e\u8d39","index":2,"level":1,"month_amount":"0","year_amount":1110.84},{"line_no":9,"code":"200108","name":"\u652f\u4ed8\u5176\u4ed6\u4e0e\u7ecf\u8425\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":8301.01,"amount":8301.01,"current_amount":8301.01,"item_name":"\u652f\u4ed8\u5176\u4ed6\u4e0e\u7ecf\u8425\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":8301.01,"year_amount":1730159.66},{"line_no":10,"code":"200109","name":"\u7ecf\u8425\u6d3b\u52a8\u73b0\u91d1\u6d41\u51fa\u5c0f\u8ba1","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u5c0f\u8ba1\u884c","direction":"","income_amount":"0","out_amount":31325.01,"amount":31325.01,"current_amount":31325.01,"item_name":"\u7ecf\u8425\u6d3b\u52a8\u73b0\u91d1\u6d41\u51fa\u5c0f\u8ba1","index":2,"level":1,"month_amount":31325.01,"year_amount":10604398.73},{"line_no":11,"code":"200110","name":"\u7ecf\u8425\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\u51c0\u989d","category":"\u7ecf\u8425\u6d3b\u52a8","item_type":"\u51c0\u989d\u884c","direction":"","income_amount":"0","out_amount":"0","amount":-31324.01,"current_amount":-31324.01,"item_name":"\u7ecf\u8425\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\u51c0\u989d","index":2,"level":1,"month_amount":-31324.01,"year_amount":649570.86},{"line_no":12,"code":"2002","name":"\u4e8c\u3001\u6295\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u6807\u9898\u884c","direction":"","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u4e8c\u3001\u6295\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf","index":1,"level":0,"month_amount":"","year_amount":""},{"line_no":13,"code":"200201","name":"\u6536\u56de\u6295\u8d44\u6536\u5230\u7684\u73b0\u91d1","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u6536\u56de\u6295\u8d44\u6536\u5230\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":14,"code":"200202","name":"\u53d6\u5f97\u6295\u8d44\u6536\u76ca\u6536\u5230\u7684\u73b0\u91d1","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u53d6\u5f97\u6295\u8d44\u6536\u76ca\u6536\u5230\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":15,"code":"200203","name":"\u5904\u7f6e\u56fa\u5b9a\u8d44\u4ea7\u3001\u65e0\u5f62\u8d44\u4ea7\u548c\u5176\u4ed6\u957f\u671f\u8d44\u4ea7\u6536\u56de\u7684\u73b0\u91d1\u51c0\u989d","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u5904\u7f6e\u56fa\u5b9a\u8d44\u4ea7\u3001\u65e0\u5f62\u8d44\u4ea7\u548c\u5176\u4ed6\u957f\u671f\u8d44\u4ea7\u6536\u56de\u7684\u73b0\u91d1\u51c0\u989d","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":16,"code":"200204","name":"\u5904\u7f6e\u5b50\u516c\u53f8\u53ca\u5176\u4ed6\u8425\u4e1a\u5355\u4f4d\u6536\u5230\u7684\u73b0\u91d1\u51c0\u989d","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u5904\u7f6e\u5b50\u516c\u53f8\u53ca\u5176\u4ed6\u8425\u4e1a\u5355\u4f4d\u6536\u5230\u7684\u73b0\u91d1\u51c0\u989d","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":17,"code":"200205","name":"\u6536\u5230\u5176\u4ed6\u4e0e\u6295\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u6536\u5230\u5176\u4ed6\u4e0e\u6295\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":18,"code":"200206","name":"\u6295\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u5165\u5c0f\u8ba1","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u5c0f\u8ba1\u884c","direction":"","income_amount":0,"out_amount":"0","amount":0,"current_amount":0,"item_name":"\u6295\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u5165\u5c0f\u8ba1","index":2,"level":1,"month_amount":0,"year_amount":0},{"line_no":19,"code":"200207","name":"\u8d2d\u5efa\u56fa\u5b9a\u8d44\u4ea7\u3001\u65e0\u5f62\u8d44\u4ea7\u548c\u5176\u4ed6\u957f\u671f\u8d44\u4ea7\u6240\u652f\u4ed8\u7684\u73b0\u91d1","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u8d2d\u5efa\u56fa\u5b9a\u8d44\u4ea7\u3001\u65e0\u5f62\u8d44\u4ea7\u548c\u5176\u4ed6\u957f\u671f\u8d44\u4ea7\u6240\u652f\u4ed8\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":20,"code":"200208","name":"\u6295\u8d44\u652f\u4ed8\u7684\u73b0\u91d1","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u6295\u8d44\u652f\u4ed8\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":21,"code":"200209","name":"\u53d6\u5f97\u5b50\u516c\u53f8\u53ca\u5176\u4ed6\u8425\u4e1a\u5355\u4f4d\u652f\u4ed8\u7684\u73b0\u91d1\u51c0\u989d","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u53d6\u5f97\u5b50\u516c\u53f8\u53ca\u5176\u4ed6\u8425\u4e1a\u5355\u4f4d\u652f\u4ed8\u7684\u73b0\u91d1\u51c0\u989d","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":22,"code":"200210","name":"\u652f\u4ed8\u7684\u5176\u4ed6\u4e0e\u6295\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u652f\u4ed8\u7684\u5176\u4ed6\u4e0e\u6295\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":23,"code":"200211","name":"\u6295\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u51fa\u5c0f\u8ba1","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u5c0f\u8ba1\u884c","direction":"","income_amount":"0","out_amount":0,"amount":0,"current_amount":0,"item_name":"\u6295\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u51fa\u5c0f\u8ba1","index":2,"level":1,"month_amount":0,"year_amount":0},{"line_no":24,"code":"200212","name":"\u6295\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\u51c0\u989d","category":"\u6295\u8d44\u6d3b\u52a8","item_type":"\u51c0\u989d\u884c","direction":"","income_amount":"0","out_amount":"0","amount":0,"current_amount":0,"item_name":"\u6295\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\u51c0\u989d","index":2,"level":1,"month_amount":0,"year_amount":0},{"line_no":25,"code":"2003","name":"\u4e09\u3001\u7b79\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf","category":"\u7b79\u8d44\u6d3b\u52a8","item_type":"\u6807\u9898\u884c","direction":"","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u4e09\u3001\u7b79\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf","index":1,"level":0,"month_amount":"","year_amount":""},{"line_no":26,"code":"200301","name":"\u5438\u6536\u6295\u8d44\u6536\u5230\u7684\u73b0\u91d1","category":"\u7b79\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u5438\u6536\u6295\u8d44\u6536\u5230\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":27,"code":"200302","name":"\u53d6\u5f97\u501f\u6b3e\u6536\u5230\u7684\u73b0\u91d1","category":"\u7b79\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u53d6\u5f97\u501f\u6b3e\u6536\u5230\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":28,"code":"200303","name":"\u6536\u5230\u5176\u4ed6\u4e0e\u7b79\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","category":"\u7b79\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u6536\u5165","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u6536\u5230\u5176\u4ed6\u4e0e\u7b79\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":29,"code":"200304","name":"\u7b79\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u5165\u5c0f\u8ba1","category":"\u7b79\u8d44\u6d3b\u52a8","item_type":"\u5c0f\u8ba1\u884c","direction":"","income_amount":0,"out_amount":"0","amount":0,"current_amount":0,"item_name":"\u7b79\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u5165\u5c0f\u8ba1","index":2,"level":1,"month_amount":0,"year_amount":0},{"line_no":30,"code":"200305","name":"\u507f\u8fd8\u503a\u52a1\u652f\u4ed8\u7684\u73b0\u91d1","category":"\u7b79\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u507f\u8fd8\u503a\u52a1\u652f\u4ed8\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":31,"code":"200306","name":"\u5206\u914d\u80a1\u5229\u3001\u5229\u6da6\u6216\u507f\u4ed8\u5229\u606f\u652f\u4ed8\u7684\u73b0\u91d1","category":"\u7b79\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u5206\u914d\u80a1\u5229\u3001\u5229\u6da6\u6216\u507f\u4ed8\u5229\u606f\u652f\u4ed8\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":32,"code":"200307","name":"\u652f\u4ed8\u5176\u4ed6\u4e0e\u7b79\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","category":"\u7b79\u8d44\u6d3b\u52a8","item_type":"\u660e\u7ec6\u9879\u76ee","direction":"\u652f\u51fa","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u652f\u4ed8\u5176\u4ed6\u4e0e\u7b79\u8d44\u6d3b\u52a8\u6709\u5173\u7684\u73b0\u91d1","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":33,"code":"200308","name":"\u7b79\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u51fa\u5c0f\u8ba1","category":"\u7b79\u8d44\u6d3b\u52a8","item_type":"\u5c0f\u8ba1\u884c","direction":"","income_amount":"0","out_amount":0,"amount":0,"current_amount":0,"item_name":"\u7b79\u8d44\u6d3b\u52a8\u73b0\u91d1\u6d41\u51fa\u5c0f\u8ba1","index":2,"level":1,"month_amount":0,"year_amount":0},{"line_no":34,"code":"200309","name":"\u7b79\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\u51c0\u989d","category":"\u7b79\u8d44\u6d3b\u52a8","item_type":"\u51c0\u989d\u884c","direction":"","income_amount":"0","out_amount":"0","amount":0,"current_amount":0,"item_name":"\u7b79\u8d44\u6d3b\u52a8\u4ea7\u751f\u7684\u73b0\u91d1\u6d41\u91cf\u51c0\u989d","index":2,"level":1,"month_amount":0,"year_amount":0},{"line_no":35,"code":"2004","name":"\u56db\u3001\u6c47\u7387\u53d8\u52a8\u5bf9\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u7684\u5f71\u54cd","category":"\u6c47\u7387\u5f71\u54cd","item_type":"\u8c03\u6574\u884c","direction":"","income_amount":"0","out_amount":"0","amount":"0","current_amount":"0","item_name":"\u56db\u3001\u6c47\u7387\u53d8\u52a8\u5bf9\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u7684\u5f71\u54cd","index":2,"level":1,"month_amount":"0","year_amount":"0"},{"line_no":36,"code":"2005","name":"\u4e94\u3001\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u51c0\u589e\u52a0\u989d","category":"\u73b0\u91d1\u51c0\u589e\u52a0","item_type":"\u51c0\u989d\u884c","direction":"","income_amount":"0","out_amount":"0","amount":-31324.01,"current_amount":-31324.01,"item_name":"\u4e94\u3001\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u51c0\u589e\u52a0\u989d","index":2,"level":1,"month_amount":-31324.01,"year_amount":649570.86},{"line_no":37,"code":"2006","name":"\u52a0\uff1a\u671f\u521d\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u4f59\u989d","category":"\u73b0\u91d1\u4f59\u989d","item_type":"\u4f59\u989d\u884c","direction":"","income_amount":"0","out_amount":"0","amount":2384771.12,"current_amount":2384771.12,"item_name":"\u52a0\uff1a\u671f\u521d\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u4f59\u989d","index":2,"level":1,"month_amount":2384771.12,"year_amount":1703876.25},{"line_no":38,"code":"2007","name":"\u516d\u3001\u671f\u672b\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u4f59\u989d","category":"\u73b0\u91d1\u4f59\u989d","item_type":"\u4f59\u989d\u884c","direction":"","income_amount":"0","out_amount":"0","amount":2353447.11,"current_amount":2353447.11,"item_name":"\u516d\u3001\u671f\u672b\u73b0\u91d1\u53ca\u73b0\u91d1\u7b49\u4ef7\u7269\u4f59\u989d","index":2,"level":1,"month_amount":2353447.11,"year_amount":2353447.11}],"from":"2026-06-01 00:00:00","to":"2026-06-30 23:59:59","in_amount":1,"out_amount":31325.01,"net_amount":-31324.01,"begin_amount":2384771.12,"end_amount":2353447.11,"period":"2026-06"},"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_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-06-22 16:07:42', 100898048) RETURNING "id"
16:07:42.4901.7 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:07:42.5770.9 msyii\db\Command::querySELECT COALESCE(sum(in_amount), 0) AS "in_amount", COALESCE(sum(out_amount), 0) AS "out_amount" FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" WHERE "settle_at" < '2026-01-01 00:00:00'
16:07:42.5760.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_banks"