ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1d3e09066ec: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-un-collect at 2026-06-01 04:08:41 pm by 221.216.117.119

Performance Profiling

Total processing time: 101 ms; Peak memory: 4.483 MB. Show Profiling Timeline

总计16条数据
TimeDurationCategoryInfo
  
16:08:41.0787.1 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "sub".* FROM ((SELECT (r.id::varchar || 7::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.signed_at as wrote_date, r.serial_no, 7 as ticket_type, null::text as abstract, r.description as description, r.created_by, r.amount, null::integer as status, erp_settle_amount as settle_amount, erp_un_settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, null::integer as cost_type FROM "a57be577deb434"."tbl_sales_contracts" "r" WHERE ("r"."build_by_project"=TRUE) AND (r.erp_un_settle_amount > 0)) UNION ALL ( SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, null::integer as cost_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.amount - r.settle_amount > 0) ) UNION ALL ( SELECT (r.id::varchar || 13::varchar) as id, r.id as id2, r.supplier_id as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.signed_at as wrote_date, r.serial_no, 13 as ticket_type, null::text as abstract, r.description as description, r.created_by, 0 - erp_un_settle_amount as amount, null::integer as status, 0::numeric as settle_amount, 0 - erp_un_settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, r.cost_type FROM "a57be577deb434"."tbl_purchase_contracts" "r" WHERE (r.is_draft = false) AND (r.is_refuse = false) AND (r.erp_un_settle_amount < 0) )) "sub" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = sub.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = sub.supplier_id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = sub.user_id LEFT JOIN "a57be577deb434"."tbl_contacts" "co" ON co.id = sub.contact_id ORDER BY created_at ASC) "c"
16:08:41.0616.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:08:41.1185.6 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', 5064, 5, 'vue/erp-analysis/list-un-collect', '{"created_at_period":"","status":"0","page":"1","pazeSize":"40","listReload":"true","web_access_token":"66P66ib-3t6D-JRCTEPzE250hI-J5OEu"}', '{"code":2000,"result":{"list":[{"id":2988,"id2":2988,"supplier_id":"","client_id":85,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2023-12-06","serial_no":"","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"23500","status":"","settle_amount":"0","un_settle_amount":"23500","is_payment_settle":false,"created_at":"2023-12-06 12:28:19","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":85,"key":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":85,"key":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240"},"contract_no":""},{"id":2991,"id2":2991,"supplier_id":"","client_id":2727,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2023-12-04","serial_no":"BD2311024","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"103500","status":"","settle_amount":"51750","un_settle_amount":"51750","is_payment_settle":false,"created_at":"2023-12-06 15:33:08","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2727,"key":2727,"name":"\u4e0a\u6d77\u8fb0\u9510\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2727,"key":2727,"name":"\u4e0a\u6d77\u8fb0\u9510\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"contract_no":""},{"id":3005,"id2":3005,"supplier_id":"","client_id":2596,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2024-01-15","serial_no":"XZC20240019852","ticket_type":7,"abstract":"","description":"\u56e0\u8d22\u5e74\u7edf\u8ba1\u95ee\u9898\u4fee\u6539\u6210\u4ea4\u65e5\u671f","created_by":1005,"amount":"597750","status":"","settle_amount":"537975","un_settle_amount":"59775","is_payment_settle":false,"created_at":"2023-12-12 17:17:43","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2596,"key":2596,"name":"\u4eac\u4e1c\u4e91\u8ba1\u7b97\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2596,"key":2596,"name":"\u4eac\u4e1c\u4e91\u8ba1\u7b97\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"contract_no":""},{"id":3102,"id2":3102,"supplier_id":"","client_id":2768,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2024-01-16","serial_no":"TS-ZHY-2024011663","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"328000","status":"","settle_amount":"0","un_settle_amount":"328000","is_payment_settle":false,"created_at":"2024-01-23 18:03:51","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2768,"key":2768,"name":"\u5929\u6d25\u4e94\u4e00\u7cfb\u7edf\u96c6\u6210\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2768,"key":2768,"name":"\u5929\u6d25\u4e94\u4e00\u7cfb\u7edf\u96c6\u6210\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"contract_no":""},{"id":3202,"id2":3202,"supplier_id":"","client_id":2766,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2024-03-26","serial_no":"TS-ZHY-2024032601","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"2880000","status":"","settle_amount":"2389813.44","un_settle_amount":"490186.56","is_payment_settle":false,"created_at":"2024-03-26 10:53:36","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2766,"key":2766,"name":"\u5409\u6797\u7701\u5a01\u58eb\u987f\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2766,"key":2766,"name":"\u5409\u6797\u7701\u5a01\u58eb\u987f\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"contract_no":""},{"id":3421,"id2":3421,"supplier_id":"","client_id":2125,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2024-07-16","serial_no":"2024\/YWL\/ZC-F\/G14761","ticket_type":7,"abstract":"","description":"\u5ba1\u6279\u5df2\u901a\u8fc7\uff0c\u56fd\u5bb6\u6280\u6539\u9879\u76ee\uff0c\u6700\u665a\u660e\u5e74\u5e74\u5e95\u5b8c\u6210\u3002\n\u5bb9\u91cf\u6682\u65f6\u6309200T\u8c03\u7814\uff0c\u7ecf\u8d392\u767e\u5927\u51e0\u5341\u3002","created_by":5087,"amount":"3394950","status":"","settle_amount":"3055455","un_settle_amount":"339495","is_payment_settle":false,"created_at":"2024-07-22 10:57:04","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":3681,"id2":3681,"supplier_id":"","client_id":101,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2024-11-29","serial_no":"TS-ZHY-2024112901","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"273000","status":"","settle_amount":"136500","un_settle_amount":"136500","is_payment_settle":false,"created_at":"2024-12-02 11:58:35","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":101,"key":101,"name":"\u4e2d\u56fd\u516c\u8def\u5de5\u7a0b\u54a8\u8be2\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u4e2d\u54a8\u6570\u636e\u6709\u9650\u516c\u53f8)"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":101,"key":101,"name":"\u4e2d\u56fd\u516c\u8def\u5de5\u7a0b\u54a8\u8be2\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u4e2d\u54a8\u6570\u636e\u6709\u9650\u516c\u53f8)"},"contract_no":""},{"id":3713,"id2":3713,"supplier_id":"","client_id":2526,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2024-12-17","serial_no":"","ticket_type":7,"abstract":"","description":"12-25\u65e5\u4fee\u6539\u91d1\u989d\uff1b\u589e\u52a0950+1350=2300\u5143","created_by":5087,"amount":"21870","status":"","settle_amount":"0","un_settle_amount":"21870","is_payment_settle":false,"created_at":"2024-12-17 09:24:39","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":3795,"id2":3795,"supplier_id":"","client_id":3333,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-02-21","serial_no":"TSKJ20250221-ZHY-001","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"2310000","status":"","settle_amount":"2194500","un_settle_amount":"115500","is_payment_settle":false,"created_at":"2025-02-26 10:24:57","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"contract_no":""},{"id":3883,"id2":3883,"supplier_id":"","client_id":2526,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-04-27","serial_no":"TS-LW-20250427-001","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"5200","status":"","settle_amount":"0","un_settle_amount":"5200","is_payment_settle":false,"created_at":"2025-04-27 16:45:16","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":3892,"id2":3892,"supplier_id":"","client_id":1492,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-05-09","serial_no":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8\u5408\u540c 25GBG035","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"1527000","status":"","settle_amount":"1145250","un_settle_amount":"381750","is_payment_settle":false,"created_at":"2025-05-09 14:44:18","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)"},"contract_no":""},{"id":3910,"id2":3910,"supplier_id":"","client_id":1492,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-05-13","serial_no":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8\u5408\u540c 25GBJCL125","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"173000","status":"","settle_amount":"129750","un_settle_amount":"43250","is_payment_settle":false,"created_at":"2025-05-15 15:32:20","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)"},"contract_no":""},{"id":3911,"id2":3911,"supplier_id":"","client_id":2130,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-05-14","serial_no":"TS-LW-20250514001","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"217000","status":"","settle_amount":"195300","un_settle_amount":"21700","is_payment_settle":false,"created_at":"2025-05-16 09:58:43","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304"},"contract_no":""},{"id":3914,"id2":3914,"supplier_id":"","client_id":2136,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-04-30","serial_no":"0129KB2025F0464","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"615000","status":"","settle_amount":"0","un_settle_amount":"615000","is_payment_settle":false,"created_at":"2025-05-19 15:39:35","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"contract_no":""},{"id":3993,"id2":3993,"supplier_id":"","client_id":2136,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-06-23","serial_no":"TS-LW-20250623-001","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"1500","status":"","settle_amount":"0","un_settle_amount":"1500","is_payment_settle":false,"created_at":"2025-06-23 11:50:51","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"contract_no":""},{"id":4002,"id2":4002,"supplier_id":"","client_id":3376,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-06-30","serial_no":"TSKJ20250630-ZHY-001","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"600000","status":"","settle_amount":"450000","un_settle_amount":"150000","is_payment_settle":false,"created_at":"2025-06-30 12:05:19","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":3376,"key":3376,"name":"\u8fb0\u5c79\u5bf0\u5b87\uff08\u4e0a\u6d77\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":3376,"key":3376,"name":"\u8fb0\u5c79\u5bf0\u5b87\uff08\u4e0a\u6d77\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"contract_no":""},{"id":4007,"id2":4007,"supplier_id":710,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-07-01","serial_no":"\u516c\u53f8\u81ea\u7528\u7c7bTSKJ20250701-HYF-001","ticket_type":13,"abstract":"","description":"\u8d75\u6657\u7131\/\u4f0a\u5cfb\u8fb0 2\u4eba\u6b21 \u8f6f\u8003\u9ad8\u7ea7\u8ba4\u8bc1\u8bc1\u4e66","created_by":1011,"amount":"20000","status":"","settle_amount":"0","un_settle_amount":"20000","is_payment_settle":false,"created_at":"2025-07-01 09:22:11","cost_type":1,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplier":{"id":710,"key":710,"name":"\u8d3e\u4e1c\u71c3"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u91c7\u8d2d\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":710,"key":710,"name":"\u8d3e\u4e1c\u71c3"},"contract_no":""},{"id":4014,"id2":4014,"supplier_id":608,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-07-04","serial_no":"\u8ba2\u5355\u53f7: 4613325807579161702","ticket_type":13,"abstract":"","description":"40G \u6a21\u5757\u4e00\u4e2a","created_by":1011,"amount":"388","status":"","settle_amount":"0","un_settle_amount":"388","is_payment_settle":false,"created_at":"2025-07-04 13:30:27","cost_type":1,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u91c7\u8d2d\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contract_no":""},{"id":4020,"id2":4020,"supplier_id":"","client_id":2526,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-07-10","serial_no":"TSKJ-LW-20250710-01","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"25000","status":"","settle_amount":"0","un_settle_amount":"25000","is_payment_settle":false,"created_at":"2025-07-10 16:33:24","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":4055,"id2":4055,"supplier_id":"","client_id":2553,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-07-21","serial_no":"W-KJ-CG-KXMTYB-20250729-01","ticket_type":7,"abstract":"","description":"","created_by":1001,"amount":"885300","status":"","settle_amount":"858740.72","un_settle_amount":"26559.28","is_payment_settle":false,"created_at":"2025-07-21 14:10:34","cost_type":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":4061,"id2":4061,"supplier_id":"","client_id":2136,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-07-20","serial_no":"0129KB2025F0645","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"45500","status":"","settle_amount":"0","un_settle_amount":"45500","is_payment_settle":false,"created_at":"2025-07-22 17:29:02","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"contract_no":""},{"id":5,"id2":5,"supplier_id":"","client_id":"","user_id":1011,"contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-08","serial_no":"QTYFD-20250808-00005","ticket_type":20021,"abstract":"\u4ed8\u82f1\u8fc8\u7fa4\u6656\u54c1\u724c\u4ee3\u7406\u5546\u62bc\u91d1","description":"","created_by":5388,"amount":"20000","status":2,"settle_amount":"0","un_settle_amount":"20000","is_payment_settle":false,"created_at":"2025-08-08 18:51:47","cost_type":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":"","client":"","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"},"contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"},"contract_no":""},{"id":7,"id2":7,"supplier_id":"","client_id":"","user_id":1013,"contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-08","serial_no":"QTYFD-20250808-00007","ticket_type":20021,"abstract":"\u5f00\u901a\u6dd8\u5b9d\u5e97\u94fa\u4fdd\u8bc1\u91d1","description":"","created_by":5388,"amount":"1000","status":2,"settle_amount":"0","un_settle_amount":"1000","is_payment_settle":false,"created_at":"2025-08-08 18:53:56","cost_type":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":"","client":"","user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"},"contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"},"contract_no":""},{"id":8,"id2":8,"supplier_id":"","client_id":"","user_id":1013,"contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-08","serial_no":"QTYFD-20250808-00008","ticket_type":20021,"abstract":"\u516c\u53f8\u5bbd\u5e26\u91cf\u5b50\u4e92\u8054\u8def\u7531\u5668\u62bc\u91d1","description":"","created_by":5388,"amount":"1000","status":2,"settle_amount":"0","un_settle_amount":"1000","is_payment_settle":false,"created_at":"2025-08-08 18:54:44","cost_type":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":"","client":"","user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"},"contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"},"contract_no":""},{"id":9,"id2":9,"supplier_id":"","client_id":"","user_id":1005,"contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-08","serial_no":"QTYFD-20250808-00009","ticket_type":20021,"abstract":"\u4e00\u6240655.2\u4e07\u5408\u540c\u5c65\u7ea6\u4fdd\u8bc1\u91d1","description":"","created_by":5388,"amount":"327600","status":2,"settle_amount":"0","un_settle_amount":"327600","is_payment_settle":false,"created_at":"2025-08-08 18:56:00","cost_type":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":"","client":"","user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"},"contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"},"contract_no":""},{"id":12,"id2":12,"supplier_id":"","client_id":"","user_id":1005,"contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-08","serial_no":"QTYFD-20250808-00012","ticket_type":20021,"abstract":"\u5357\u4eac\u4e2d\u661f\u822a\u7a7a\uff08\u914d\u5408\u5ba1\u67e5\uff09","description":"","created_by":5388,"amount":"600000","status":2,"settle_amount":"0","un_settle_amount":"600000","is_payment_settle":false,"created_at":"2025-08-08 18:58:13","cost_type":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":"","client":"","user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"},"contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"},"contract_no":""},{"id":4109,"id2":4109,"supplier_id":"","client_id":2136,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-21","serial_no":"\u79d1\u529b\u666e\u8ba2\u5355\u53f7\uff1a2011181999W","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"3680","status":"","settle_amount":"533.6","un_settle_amount":"3146.4","is_payment_settle":false,"created_at":"2025-08-21 14:24:26","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"contract_no":""},{"id":29,"id2":29,"supplier_id":728,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4135,"wrote_date":"2025-09-02","serial_no":"QTYSD-20250902-00002","ticket_type":20021,"abstract":"\u4ed8\u8bfa\u5fb7\u4e2d\u5fc3\u4e00\u671f4\u53f7\u697c2309\u5ba4\u62bc\u91d1","description":"","created_by":5388,"amount":"22508","status":2,"settle_amount":"0","un_settle_amount":"22508","is_payment_settle":false,"created_at":"2025-09-02 14:58:29","cost_type":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":{"id":728,"key":728,"name":"\u9f50\u4e16\u5b89"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4135,"key":4135,"name":"TSKJ20250902-WJC-01"},"ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":728,"key":728,"name":"\u9f50\u4e16\u5b89"},"contract_no":"TSKJ20250902-WJC-01"},{"id":4144,"id2":4144,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-09-05","serial_no":"ZZBRS20252516","ticket_type":7,"abstract":"","description":"","created_by":1001,"amount":"270000","status":"","settle_amount":"180000","un_settle_amount":"90000","is_payment_settle":false,"created_at":"2025-09-05 10:46:37","cost_type":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"contract_no":""},{"id":4165,"id2":4165,"supplier_id":"","client_id":2136,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-09-17","serial_no":"G0129XX2025F0098","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"59500","status":"","settle_amount":"0","un_settle_amount":"59500","is_payment_settle":false,"created_at":"2025-09-17 14:50:31","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"contract_no":""},{"id":34,"id2":34,"supplier_id":"","client_id":"","user_id":1001,"contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-09-19","serial_no":"QTYSD-20250919-00001","ticket_type":20021,"abstract":"\u4e2a\u4eba\u501f\u6b3e","description":"","created_by":5388,"amount":"100000","status":2,"settle_amount":"0","un_settle_amount":"100000","is_payment_settle":false,"created_at":"2025-09-19 13:30:06","cost_type":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":"","client":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},"contract_no":""},{"id":4272,"id2":4272,"supplier_id":"","client_id":2526,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-11-20","serial_no":"2025-11-30-002","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"6000","status":"","settle_amount":"0","un_settle_amount":"6000","is_payment_settle":false,"created_at":"2025-11-30 22:18:25","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":4288,"id2":4288,"supplier_id":"","client_id":2737,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-12-05","serial_no":"2025-12-07-001","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"2551700","status":"","settle_amount":"1786190","un_settle_amount":"765510","is_payment_settle":false,"created_at":"2025-12-07 21:02:18","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2737,"key":2737,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6240\u529e)"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2737,"key":2737,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6240\u529e)"},"contract_no":""},{"id":4289,"id2":4289,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-11-30","serial_no":"2025-12-07-002","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"631660","status":"","settle_amount":"600077","un_settle_amount":"31583","is_payment_settle":false,"created_at":"2025-12-07 22:24:07","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":4301,"id2":4301,"supplier_id":"","client_id":149,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-12-10","serial_no":"FZ-2025-134-ZZ-023","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"40800","status":"","settle_amount":"0","un_settle_amount":"40800","is_payment_settle":false,"created_at":"2025-12-10 16:42:08","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"contract_no":""},{"id":4316,"id2":4316,"supplier_id":"","client_id":2526,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-12-16","serial_no":"2025-12-16-003","ticket_type":7,"abstract":"","description":"","created_by":5087,"amount":"8500","status":"","settle_amount":"0","un_settle_amount":"8500","is_payment_settle":false,"created_at":"2025-12-16 16:51:01","cost_type":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":4321,"id2":4321,"supplier_id":"","client_id":3330,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-12-18","serial_no":"TS-SQY-20251114002","ticket_type":7,"abstract":"","description":"","created_by":5300,"amount":"58000","status":"","settle_amount":"0","un_settle_amount":"58000","is_payment_settle":false,"created_at":"2025-12-18 16:12:56","cost_type":"","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":3330,"key":3330,"name":"\u94a2\u7814\u660a\u666e\u79d1\u6280\u6709\u9650\u516c\u53f8\/ \u94a2\u7814\u660a\u666e\uff08\u82cf\u5dde\uff09\u521b\u65b0\u4e2d\u5fc3\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":3330,"key":3330,"name":"\u94a2\u7814\u660a\u666e\u79d1\u6280\u6709\u9650\u516c\u53f8\/ \u94a2\u7814\u660a\u666e\uff08\u82cf\u5dde\uff09\u521b\u65b0\u4e2d\u5fc3\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":4323,"id2":4323,"supplier_id":"","client_id":3432,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-11-11","serial_no":"2025-12-19-001","ticket_type":7,"abstract":"","description":"","created_by":1001,"amount":"63000","status":"","settle_amount":"0","un_settle_amount":"63000","is_payment_settle":false,"created_at":"2025-12-19 13:53:15","cost_type":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"contract_no":""},{"id":4324,"id2":4324,"supplier_id":"","client_id":3432,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-11-11","serial_no":"2025-12-19-002","ticket_type":7,"abstract":"","description":"","created_by":1001,"amount":"291000","status":"","settle_amount":"0","un_settle_amount":"291000","is_payment_settle":false,"created_at":"2025-12-19 13:53:25","cost_type":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"contract_no":""},{"id":4328,"id2":4328,"supplier_id":"","client_id":2094,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-12-19","serial_no":"JZ2025162","ticket_type":7,"abstract":"","description":"","created_by":1005,"amount":"432000","status":"","settle_amount":"0","un_settle_amount":"432000","is_payment_settle":false,"created_at":"2025-12-21 22:33:41","cost_type":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":"","client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u5408\u540c","bgcolor":"#555555","status_display":"\u8349\u7a3f","unit":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)"},"contract_no":""}],"statusCount":[{"key":1,"name":"\u5e94\u6536\u6b3e","color":"#FEF7EC","border":"#FF9200","sum":27698681.49,"count":74},{"key":2,"name":"\u603b\u91d1\u989d","color":"#E7F3D5","border":"#70B603","sum":"42329552.17","count":74},{"key":3,"name":"\u5df2\u6536\u6b3e","color":"#F1F2F5","border":"#555555","sum":"14630870.68","count":74}],"pagenation":{"totalcount":74,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-01 16:08:41', 90548992) RETURNING "id"
16:08:41.0854.1 msyii\db\Command::querySELECT "sub".* FROM ((SELECT (r.id::varchar || 7::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.signed_at as wrote_date, r.serial_no, 7 as ticket_type, null::text as abstract, r.description as description, r.created_by, r.amount, null::integer as status, erp_settle_amount as settle_amount, erp_un_settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, null::integer as cost_type FROM "a57be577deb434"."tbl_sales_contracts" "r" WHERE ("r"."build_by_project"=TRUE) AND (r.erp_un_settle_amount > 0)) UNION ALL ( SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, null::integer as cost_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.amount - r.settle_amount > 0) ) UNION ALL ( SELECT (r.id::varchar || 13::varchar) as id, r.id as id2, r.supplier_id as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.signed_at as wrote_date, r.serial_no, 13 as ticket_type, null::text as abstract, r.description as description, r.created_by, 0 - erp_un_settle_amount as amount, null::integer as status, 0::numeric as settle_amount, 0 - erp_un_settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, r.cost_type FROM "a57be577deb434"."tbl_purchase_contracts" "r" WHERE (r.is_draft = false) AND (r.is_refuse = false) AND (r.erp_un_settle_amount < 0) )) "sub" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = sub.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = sub.supplier_id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = sub.user_id LEFT JOIN "a57be577deb434"."tbl_contacts" "co" ON co.id = sub.contact_id ORDER BY created_at ASC LIMIT 40
16:08:41.1113.4 msyii\db\Command::querySELECT COUNT(*) FROM ((SELECT (r.id::varchar || 7::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.signed_at as wrote_date, r.serial_no, 7 as ticket_type, null::text as abstract, r.description as description, r.created_by, r.amount, null::integer as status, erp_settle_amount as settle_amount, erp_un_settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, null::integer as cost_type FROM "a57be577deb434"."tbl_sales_contracts" "r" WHERE ("r"."build_by_project"=TRUE) AND (r.erp_un_settle_amount > 0)) UNION ALL ( SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, null::integer as cost_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.amount - r.settle_amount > 0) ) UNION ALL ( SELECT (r.id::varchar || 13::varchar) as id, r.id as id2, r.supplier_id as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.signed_at as wrote_date, r.serial_no, 13 as ticket_type, null::text as abstract, r.description as description, r.created_by, 0 - erp_un_settle_amount as amount, null::integer as status, 0::numeric as settle_amount, 0 - erp_un_settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, r.cost_type FROM "a57be577deb434"."tbl_purchase_contracts" "r" WHERE (r.is_draft = false) AND (r.is_refuse = false) AND (r.erp_un_settle_amount < 0) )) "sub" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = sub.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = sub.supplier_id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = sub.user_id LEFT JOIN "a57be577deb434"."tbl_contacts" "co" ON co.id = sub.contact_id
16:08:41.0682.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5064
16:08:41.1042.8 msyii\db\Command::querySELECT SUM(settle_amount) FROM ((SELECT (r.id::varchar || 7::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.signed_at as wrote_date, r.serial_no, 7 as ticket_type, null::text as abstract, r.description as description, r.created_by, r.amount, null::integer as status, erp_settle_amount as settle_amount, erp_un_settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, null::integer as cost_type FROM "a57be577deb434"."tbl_sales_contracts" "r" WHERE ("r"."build_by_project"=TRUE) AND (r.erp_un_settle_amount > 0)) UNION ALL ( SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, null::integer as cost_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.amount - r.settle_amount > 0) ) UNION ALL ( SELECT (r.id::varchar || 13::varchar) as id, r.id as id2, r.supplier_id as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.signed_at as wrote_date, r.serial_no, 13 as ticket_type, null::text as abstract, r.description as description, r.created_by, 0 - erp_un_settle_amount as amount, null::integer as status, 0::numeric as settle_amount, 0 - erp_un_settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, r.cost_type FROM "a57be577deb434"."tbl_purchase_contracts" "r" WHERE (r.is_draft = false) AND (r.is_refuse = false) AND (r.erp_un_settle_amount < 0) )) "sub" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = sub.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = sub.supplier_id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = sub.user_id LEFT JOIN "a57be577deb434"."tbl_contacts" "co" ON co.id = sub.contact_id
16:08:41.0972.8 msyii\db\Command::querySELECT SUM(amount) FROM ((SELECT (r.id::varchar || 7::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.signed_at as wrote_date, r.serial_no, 7 as ticket_type, null::text as abstract, r.description as description, r.created_by, r.amount, null::integer as status, erp_settle_amount as settle_amount, erp_un_settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, null::integer as cost_type FROM "a57be577deb434"."tbl_sales_contracts" "r" WHERE ("r"."build_by_project"=TRUE) AND (r.erp_un_settle_amount > 0)) UNION ALL ( SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, null::integer as cost_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.amount - r.settle_amount > 0) ) UNION ALL ( SELECT (r.id::varchar || 13::varchar) as id, r.id as id2, r.supplier_id as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.signed_at as wrote_date, r.serial_no, 13 as ticket_type, null::text as abstract, r.description as description, r.created_by, 0 - erp_un_settle_amount as amount, null::integer as status, 0::numeric as settle_amount, 0 - erp_un_settle_amount as un_settle_amount, false as is_payment_settle, r.created_at, r.cost_type FROM "a57be577deb434"."tbl_purchase_contracts" "r" WHERE (r.is_draft = false) AND (r.is_refuse = false) AND (r.erp_un_settle_amount < 0) )) "sub" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = sub.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = sub.supplier_id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = sub.user_id LEFT JOIN "a57be577deb434"."tbl_contacts" "co" ON co.id = sub.contact_id
16:08:41.0722.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
16:08:41.0920.7 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1011, 5300, 5388, 5087, 1005))
16:08:41.0950.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (85, 2727, 2596, 2768, 2766, 2125, 101, 2526, 3333, 1492, 2130, 2136, 3376, 2553, 3389, 2737, 2128, 149, 3330, 3432, 2094)
16:08:41.0910.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1005, 1011, 1001, 5388, 5300)
16:08:41.0930.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 3, 1, 6)
16:08:41.0940.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (710, 608, 728)
16:08:41.0950.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1013, 1005, 1001)
16:08:41.0960.3 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4135