ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4cce4995dc3: POST https://beta.jinchangxiao.com/vue/voucher-center/bill-list at 2026-07-07 06:00:41 pm by 39.156.194.178

Performance Profiling

Total processing time: 48 ms; Peak memory: 5.208 MB. Show Profiling Timeline

总计12条数据
TimeDurationCategoryInfo
  
18:00:41.6488.4 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/voucher-center/bill-list', '{"page":"1","pageSize":"200","object_type":"20013","generation_scope":"ungenerated","date_from":"2026-02-01","date_to":"2026-07-31"}', '{"code":2000,"result":{"list":[{"id":"20013_2199_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2199,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260611-00001","bill_date":"2026-06-11","completed_at":"","amount":1,"partner_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","department":"\u603b\u7ecf\u7406","handler_name":"\u5218\u4eba\u8bda","fund_account_name":"","fund_account_caption_name":"","gen_status":"\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":"20013_2194_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2194,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260414-00001","bill_date":"2026-04-14","completed_at":"","amount":2,"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":"20013_2192_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2192,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260408-00002","bill_date":"2026-04-08","completed_at":"","amount":555,"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":"20013_2191_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2191,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260408-00001","bill_date":"2026-04-08","completed_at":"","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":"","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":"20013_2193_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2193,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260408-00003","bill_date":"2026-04-06","completed_at":"","amount":2,"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":"20013_2185_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2185,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260325-00001","bill_date":"2026-03-25","completed_at":"","amount":600077,"partner_name":"\u5317\u4eac\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":"20013_2184_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2184,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260320-00001","bill_date":"2026-03-20","completed_at":"","amount":300,"partner_name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\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":"20013_2183_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2183,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260319-00001","bill_date":"2026-03-19","completed_at":"","amount":13750,"partner_name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\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":"20013_2182_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2182,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260312-00001","bill_date":"2026-03-12","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":"20013_2181_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2181,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260311-00002","bill_date":"2026-03-11","completed_at":"","amount":140000,"partner_name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","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":"20013_2180_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2180,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260311-00001","bill_date":"2026-03-11","completed_at":"","amount":500,"partner_name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\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":"20013_2179_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2179,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260310-00003","bill_date":"2026-03-10","completed_at":"","amount":71269.8,"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":"20013_2178_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2178,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260310-00002","bill_date":"2026-03-10","completed_at":"","amount":50828.4,"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":"20013_2177_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2177,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260310-00001","bill_date":"2026-03-10","completed_at":"","amount":47880,"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":"20013_2176_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2176,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260309-00004","bill_date":"2026-03-09","completed_at":"","amount":30000,"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":"20013_2175_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2175,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260309-00003","bill_date":"2026-03-09","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":"20013_2174_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2174,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260309-00002","bill_date":"2026-03-09","completed_at":"","amount":114270,"partner_name":"\u5148\u6b63\u8fbe\u751f\u7269\u79d1\u6280(\u4e2d\u56fd);\u5148\u6b63\u8fbe(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8;\u5317\u4eac\u65ed\u65e5\u4f73\u4e1a\u7f51\u7edc\u6709\u9650\u516c\u53f8\/\u4e2d\u5316\u79cd\u4e1a\u521b\u65b0\u4e2d\u5fc3\u6709\u9650\u516c\u53f8\uff08CAE\/EDA\/BIO\uff09","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":"20013_2173_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2173,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260309-00001","bill_date":"2026-03-09","completed_at":"","amount":61234,"partner_name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\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":"20013_2172_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2172,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260303-00002","bill_date":"2026-03-03","completed_at":"","amount":100686.7,"partner_name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\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":"20013_2171_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2171,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260303-00001","bill_date":"2026-03-03","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":"20013_2170_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2170,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260302-00001","bill_date":"2026-03-02","completed_at":"","amount":49140,"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":"20013_2169_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2169,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260228-00002","bill_date":"2026-02-28","completed_at":"","amount":54600,"partner_name":"\u4e2d\u56fd\u516c\u8def\u5de5\u7a0b\u54a8\u8be2\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u4e2d\u54a8\u6570\u636e\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":"20013_2168_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2168,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260228-00001","bill_date":"2026-02-28","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":"20013_2167_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2167,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260226-00004","bill_date":"2026-02-26","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":"20013_2166_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2166,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260226-00003","bill_date":"2026-02-26","completed_at":"","amount":180475,"partner_name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\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":"20013_2165_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2165,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260226-00002","bill_date":"2026-02-26","completed_at":"","amount":195300,"partner_name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","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":"20013_2164_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2164,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260226-00001","bill_date":"2026-02-26","completed_at":"","amount":227328,"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":"20013_2163_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2163,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260209-00001","bill_date":"2026-02-09","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":"20013_2162_0_0","object_type":20013,"object_type_name":"\u6536\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2162,"event_type":0,"event_id":0,"business_node":"","bill_no":"SKD-20260206-00001","bill_date":"2026-02-06","completed_at":"","amount":35800,"partner_name":"\u58f9\u8fdb\u5236\uff08\u5382\u5546\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":""}],"pagenation":{"totalcount":29,"thispage":1,"pagesize":200},"total_amount":2118718.9},"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 18:00:41', 33399040) RETURNING "id"
18:00:41.6377.0 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (982, 3457, 2128, 918, 57, 12, 1663, 20, 3281, 2032, 1181, 107, 3436, 3448, 3359, 101, 2021, 79, 2130, 2125, 3443, 3336)
18:00:41.6292.9 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT 20013 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_collect_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-02-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))
18:00:41.6351.9 msyii\db\Command::querySELECT "b"."object_type" AS "object_type", "b"."object_id" AS "object_id", "b"."event_type" AS "event_type", "b"."event_id" AS "event_id", "b"."business_node" AS "business_node", "b"."bill_no" AS "bill_no", "b"."bill_date" AS "bill_date", "b"."completed_at" AS "completed_at", "b"."amount" AS "amount", "b"."client_id" AS "client_id", "b"."supplier_id" AS "supplier_id", "b"."contact_id" AS "contact_id", "b"."department_id" AS "department_id", "b"."handler_id" AS "handler_id", "b"."created_by" AS "created_by", "b"."erp_bank_id" AS "erp_bank_id", "b"."have_invoice" AS "have_invoice", "b"."is_verified" AS "is_verified", COALESCE(g.success_count, 0) AS "gen_success_count", COALESCE(g.fail_count, 0) AS "gen_fail_count", COALESCE(CAST(g.last_book_date AS text), '') AS "gen_book_date" FROM (SELECT 20013 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_collect_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-02-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
18:00:41.6331.6 msyii\db\Command::querySELECT COALESCE(SUM(b.amount), 0) AS "total_amount" FROM (SELECT 20013 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_collect_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-02-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))
18:00:41.6180.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
18:00:41.6220.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"
18:00:41.6210.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
18:00:41.6460.6 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 4)
18:00:41.6440.4 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 45)
18:00:41.6180.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
18:00:41.6450.3 msyii\db\Command::querySELECT "id", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5087, 1005, 5300, 5295)