ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4cafa32ce03: POST https://beta.jinchangxiao.com/vue/voucher-center/bill-list at 2026-07-07 03:49:55 pm by 39.156.194.178

Performance Profiling

Total processing time: 144 ms; Peak memory: 5.372 MB. Show Profiling Timeline

总计13条数据
TimeDurationCategoryInfo
  
15:49:55.22717.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":"20012","generation_scope":"ungenerated","date_from":"2026-01-26","date_to":"2026-03-31"}', '{"code":2000,"result":{"list":[{"id":"20012_2336_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2336,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260323-00003","bill_date":"2026-03-23","completed_at":"","amount":15332.71,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2335_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2335,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260323-00002","bill_date":"2026-03-23","completed_at":"","amount":644.54,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2334_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2334,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260323-00001","bill_date":"2026-03-23","completed_at":"","amount":30000,"partner_name":"\u5317\u4eac\u5609\u8fd0\u8fbe\u79d1\u6280\u5f00\u53d1\u80a1\u4efd\u6709\u9650\u516c\u53f8","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2333_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2333,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260320-00003","bill_date":"2026-03-20","completed_at":"","amount":23040,"partner_name":"\u6570\u529b\uff08\u5929\u6d25\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2332_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2332,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260320-00002","bill_date":"2026-03-20","completed_at":"","amount":35700,"partner_name":"","department":"\u9500\u552e\u90e8","handler_name":"\u5218\u5fae","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2331_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2331,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260320-00001","bill_date":"2026-03-20","completed_at":"","amount":9199,"partner_name":"","department":"\u9500\u552e\u90e8","handler_name":"\u5218\u5fae","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2330_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2330,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260318-00001","bill_date":"2026-03-18","completed_at":"","amount":32000,"partner_name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2329_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2329,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260316-00002","bill_date":"2026-03-16","completed_at":"","amount":1294.41,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2328_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2328,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260316-00001","bill_date":"2026-03-16","completed_at":"","amount":30400,"partner_name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2327_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2327,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260312-00001","bill_date":"2026-03-12","completed_at":"","amount":133000,"partner_name":"\u5317\u4eac\u8239\u6c34\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2326_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2326,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260309-00004","bill_date":"2026-03-09","completed_at":"","amount":5000,"partner_name":"\u5317\u4eac\u65b0\u5174\u9ad8\u79d1\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2324_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2324,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260309-00002","bill_date":"2026-03-09","completed_at":"","amount":3429.3,"partner_name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2323_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2323,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260309-00001","bill_date":"2026-03-09","completed_at":"","amount":3532,"partner_name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2325_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2325,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260309-00003","bill_date":"2026-03-05","completed_at":"","amount":7000,"partner_name":"","department":"\u9500\u552e\u90e8","handler_name":"\u9b4f\u6cfd\u6587","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2322_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2322,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260305-00001","bill_date":"2026-03-05","completed_at":"","amount":1661.92,"partner_name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2321_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2321,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260304-00002","bill_date":"2026-03-04","completed_at":"","amount":5322.61,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2320_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2320,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260304-00001","bill_date":"2026-03-04","completed_at":"","amount":2200,"partner_name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2319_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2319,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260303-00001","bill_date":"2026-03-03","completed_at":"","amount":186480,"partner_name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2318_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2318,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260227-00002","bill_date":"2026-02-27","completed_at":"","amount":25138,"partner_name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2317_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2317,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260227-00001","bill_date":"2026-02-27","completed_at":"","amount":23654,"partner_name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2316_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2316,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260210-00001","bill_date":"2026-02-10","completed_at":"","amount":191143.96,"partner_name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2315_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2315,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260209-00003","bill_date":"2026-02-09","completed_at":"","amount":6000,"partner_name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2314_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2314,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260209-00002","bill_date":"2026-02-09","completed_at":"","amount":300,"partner_name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2313_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2313,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260209-00001","bill_date":"2026-02-09","completed_at":"","amount":12881.61,"partner_name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2312_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2312,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260206-00007","bill_date":"2026-02-06","completed_at":"","amount":6430,"partner_name":"\u5317\u4eac\u5fd7\u8bda\u6cf0\u548c\u4fe1\u606f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2311_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2311,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260206-00006","bill_date":"2026-02-06","completed_at":"","amount":41667,"partner_name":"\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2310_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2310,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260206-00005","bill_date":"2026-02-06","completed_at":"","amount":2900,"partner_name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2309_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2309,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260206-00004","bill_date":"2026-02-06","completed_at":"","amount":1500,"partner_name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2308_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2308,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260206-00003","bill_date":"2026-02-06","completed_at":"","amount":2900,"partner_name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2307_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2307,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260206-00002","bill_date":"2026-02-06","completed_at":"","amount":2900,"partner_name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2306_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2306,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260206-00001","bill_date":"2026-02-06","completed_at":"","amount":2900,"partner_name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2305_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2305,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260205-00003","bill_date":"2026-02-05","completed_at":"","amount":27600,"partner_name":"\u5317\u4eac\u878d\u521b\u777f\u901a\u6280\u672f\u5f00\u53d1\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2304_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2304,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260205-00002","bill_date":"2026-02-05","completed_at":"","amount":198300,"partner_name":"\u4e2d\u6d77\u57ce(\u5317\u4eac)\u5efa\u8bbe\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2303_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2303,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260205-00001","bill_date":"2026-02-05","completed_at":"","amount":2500,"partner_name":"\u4e2d\u5b5a\u5b89\u5168\u6280\u672f\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2302_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2302,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260204-00003","bill_date":"2026-02-04","completed_at":"","amount":27394.96,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2301_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2301,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260204-00002","bill_date":"2026-02-04","completed_at":"","amount":12970,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2300_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2300,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260204-00001","bill_date":"2026-02-04","completed_at":"","amount":640,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2299_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2299,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260203-00003","bill_date":"2026-02-03","completed_at":"","amount":39240,"partner_name":"\u5317\u4eac\u6c47\u6d77\u667a\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2298_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2298,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260203-00002","bill_date":"2026-02-03","completed_at":"","amount":1000,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2297_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2297,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260203-00001","bill_date":"2026-02-03","completed_at":"","amount":9255,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2296_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2296,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260202-00006","bill_date":"2026-02-02","completed_at":"","amount":6950.82,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2295_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2295,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260202-00005","bill_date":"2026-02-02","completed_at":"","amount":2708.61,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2294_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2294,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260202-00004","bill_date":"2026-02-02","completed_at":"","amount":10000,"partner_name":"","department":"\u9500\u552e\u90e8","handler_name":"\u9b4f\u6cfd\u6587","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2293_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2293,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260202-00003","bill_date":"2026-02-02","completed_at":"","amount":20000,"partner_name":"","department":"\u9500\u552e\u90e8","handler_name":"\u9b4f\u6cfd\u6587","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2292_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2292,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260202-00002","bill_date":"2026-02-02","completed_at":"","amount":37122,"partner_name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2291_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2291,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260202-00001","bill_date":"2026-02-02","completed_at":"","amount":72751,"partner_name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2290_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2290,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260127-00002","bill_date":"2026-01-27","completed_at":"","amount":25080,"partner_name":"\u4e2d\u5317\u6c47\u901a(\u5317\u4eac)\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2289_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2289,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260127-00001","bill_date":"2026-01-27","completed_at":"","amount":2290,"partner_name":"\u6dd8\u5b9d\u7f51","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2288_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2288,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260126-00002","bill_date":"2026-01-26","completed_at":"","amount":500000,"partner_name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"20012_2287_0_0","object_type":20012,"object_type_name":"\u4ed8\u6b3e\u5355","object_type_color":"","object_type_tip":"","object_id":2287,"event_type":0,"event_id":0,"business_node":"","bill_no":"FKD-20260126-00001","bill_date":"2026-01-26","completed_at":"","amount":336100,"partner_name":"\u5317\u4eac\u9f50\u4fe1\u5171\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""}],"pagenation":{"totalcount":50,"thispage":1,"pagesize":200},"total_amount":2177453.45},"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 15:49:55', 32671744) RETURNING "id"
15:49:55.26713.6 msyii\db\Command::querySELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko/20100101 Firefox/152.0'
15:49:55.3088.3 msyii\db\Command::executeUPDATE "global"."tbl_browser_ua_statistics" SET "counter"=7900 WHERE "id"=298
15:49:55.2112.0 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT 20012 AS "object_type", "e"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "e"."serial_no" AS "bill_no", "e"."wrote_date" AS "bill_date", NULL::timestamp without time zone AS "completed_at", "e"."amount" AS "amount", "e"."client_id" AS "client_id", "e"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", "e"."handler" AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-01-26') AND ("e"."wrote_date" <= '2026-03-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))
15:49:55.2151.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 20012 AS "object_type", "e"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "e"."serial_no" AS "bill_no", "e"."wrote_date" AS "bill_date", NULL::timestamp without time zone AS "completed_at", "e"."amount" AS "amount", "e"."client_id" AS "client_id", "e"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", "e"."handler" AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-01-26') AND ("e"."wrote_date" <= '2026-03-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
15:49:55.2131.7 msyii\db\Command::querySELECT COALESCE(SUM(b.amount), 0) AS "total_amount" FROM (SELECT 20012 AS "object_type", "e"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "e"."serial_no" AS "bill_no", "e"."wrote_date" AS "bill_date", NULL::timestamp without time zone AS "completed_at", "e"."amount" AS "amount", "e"."client_id" AS "client_id", "e"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", "e"."handler" AS "handler_id", "e"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", true AS "is_verified" FROM "a57be577deb434"."tbl_erp_payment_tickets" "e" WHERE ("e"."status"=2) AND ("e"."wrote_date" >= '2026-01-26') AND ("e"."wrote_date" <= '2026-03-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))
15:49:55.1980.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:49:55.2040.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"
15:49:55.2180.7 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (262, 161, 701, 598, 678, 749, 731, 757, 59, 67, 68, 81, 583, 752, 630, 489, 107, 607, 733, 760, 163, 355, 608, 623)
15:49:55.2030.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:49:55.1970.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:49:55.2190.4 msyii\db\Command::querySELECT "id", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5252, 5087, 5360, 5295)
15:49:55.2200.3 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 3, 6)