6a33b0ba51887: GET https://beta.jinchangxiao.com/vue/erp-analysis/list-unit-other-collect at 2026-06-18 04:47:54 pm by 66.249.68.3
Performance Profiling
Total processing time: 214 ms; Peak memory: 4.346 MB. Show Profiling Timeline
总计37条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 16:47:54.535 | 8.9 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-unit-other-collect', '[]', '{"code":2000,"result":{"list":[{"id":63,"supplier_id":431,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-06-11","serial_no":"QTYSD-20260611-00007","ticket_type":20021,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"1","status":2,"settle_amount":"0","un_paid_amount":"1","is_payment_settle":false,"created_at":"2026-06-11 17:30:16","t_type":1,"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"}},"handlerPerson":{"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":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contract_no":"","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":62,"supplier_id":"","client_id":2133,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-06-11","serial_no":"QTYSD-20260611-00006","ticket_type":20021,"abstract":"\u6d4b\u8bd5\u5ba1\u6838\u901a\u8fc7\u65f6\u95f4","description":"","created_by":1001,"handler":1001,"amount":"1","status":2,"settle_amount":"0","un_paid_amount":"1","is_payment_settle":false,"created_at":"2026-06-11 16:53:44","t_type":1,"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"}},"handlerPerson":{"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":2133,"key":2133,"name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":2133,"key":2133,"name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":"","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":61,"supplier_id":431,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4498,"wrote_date":"2026-06-11","serial_no":"QTYSD-20260611-00005","ticket_type":20021,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"0.01","status":2,"settle_amount":"0","un_paid_amount":"0.01","is_payment_settle":false,"created_at":"2026-06-11 15:35:42","t_type":1,"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"}},"handlerPerson":{"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":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4498,"key":4498,"name":"\u6d4b\u8bd5\u5176\u4ed6\u5e94\u6536\u5355"},"ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contract_no":"\u6d4b\u8bd5\u5176\u4ed6\u5e94\u6536\u5355","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":60,"supplier_id":431,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4498,"wrote_date":"2026-06-11","serial_no":"QTYSD-20260611-00004","ticket_type":20021,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"200","status":2,"settle_amount":"1","un_paid_amount":"199","is_payment_settle":false,"created_at":"2026-06-11 15:26:44","t_type":1,"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"}},"handlerPerson":{"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":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4498,"key":4498,"name":"\u6d4b\u8bd5\u5176\u4ed6\u5e94\u6536\u5355"},"ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contract_no":"\u6d4b\u8bd5\u5176\u4ed6\u5e94\u6536\u5355","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":58,"supplier_id":431,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4498,"wrote_date":"2026-06-11","serial_no":"QTYSD-20260611-00002","ticket_type":20021,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"8000","status":2,"settle_amount":"0","un_paid_amount":"8000","is_payment_settle":false,"created_at":"2026-06-11 15:14:31","t_type":1,"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"}},"handlerPerson":{"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":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4498,"key":4498,"name":"\u6d4b\u8bd5\u5176\u4ed6\u5e94\u6536\u5355"},"ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contract_no":"\u6d4b\u8bd5\u5176\u4ed6\u5e94\u6536\u5355","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":57,"supplier_id":"","client_id":1331,"user_id":"","contact_id":"","project_id":"","sales_contract_id":3108,"purchase_contract_id":"","wrote_date":"2026-06-11","serial_no":"QTYSD-20260611-00001","ticket_type":20021,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"100","status":2,"settle_amount":"0","un_paid_amount":"100","is_payment_settle":false,"created_at":"2026-06-11 15:05:54","t_type":1,"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"}},"handlerPerson":{"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":1331,"key":1331,"name":"\u4e09\u76db\u667a\u6167\u6559\u80b2\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":{"id":3108,"key":3108,"name":"TS-SQY-2023122264","from_project":3404,"fromProject":{"id":3404,"key":3404,"name":"\u6df1\u4fe1\u670d+Veeam\u7eed\u4fdd-2023-K"}},"purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":1331,"key":1331,"name":"\u4e09\u76db\u667a\u6167\u6559\u80b2\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8"},"contract_no":"TS-SQY-2023122264","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":53,"supplier_id":"","client_id":2150,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-04-07","serial_no":"QTYSD-20260407-00001","ticket_type":20021,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"111","status":2,"settle_amount":"4","un_paid_amount":"107","is_payment_settle":false,"created_at":"2026-04-07 16:36:35","t_type":1,"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"}},"handlerPerson":{"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":2150,"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":2150,"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)"},"contract_no":"","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":52,"supplier_id":710,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4007,"wrote_date":"2026-04-01","serial_no":"QTYSD-20260401-00001","ticket_type":20021,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"20000","status":2,"settle_amount":"0","un_paid_amount":"20000","is_payment_settle":false,"created_at":"2026-04-01 12:30:37","t_type":3,"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"}},"handlerPerson":{"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":{"id":710,"key":710,"name":"\u8d3e\u4e1c\u71c3"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4007,"key":4007,"name":"\u516c\u53f8\u81ea\u7528\u7c7bTSKJ20250701-HYF-001"},"ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":710,"key":710,"name":"\u8d3e\u4e1c\u71c3"},"contract_no":"\u516c\u53f8\u81ea\u7528\u7c7bTSKJ20250701-HYF-001","t_type_display":"\u5176\u4ed6"},{"id":50,"supplier_id":138,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-03-25","serial_no":"QTYSD-20260325-00002","ticket_type":20021,"abstract":"\u4ed8\u4e50\u6210\u5b66\u6821 \u6df1\u4fe1\u670d\u9632\u706b\u5899\u6d4b\u8bd5\u673a\u62bc\u91d1","description":"","created_by":5252,"handler":5300,"amount":"21488","status":2,"settle_amount":"0","un_paid_amount":"21488","is_payment_settle":false,"created_at":"2026-03-25 10:59:32","t_type":2,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"handlerPerson":{"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":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d \u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d \u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"contract_no":"","t_type_display":"\u501f\u51fa\u6b3e"},{"id":48,"supplier_id":"","client_id":2166,"user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-03-11","serial_no":"QTYSD-20260311-00001","ticket_type":20021,"abstract":"\u4ed8\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d4b\u8bd5\u673a\u62bc\u91d1\uff08\u6c5f\u539f\u521b\u82af\uff09","description":"","created_by":5252,"handler":5300,"amount":"9488","status":2,"settle_amount":"0","un_paid_amount":"9488","is_payment_settle":false,"created_at":"2026-03-11 16:29:08","t_type":2,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"handlerPerson":{"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":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\/\u6df1\u5733\u6c5f\u539f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\/\u6df1\u5733\u6c5f\u539f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":"","t_type_display":"\u501f\u51fa\u6b3e"},{"id":46,"supplier_id":757,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-26","serial_no":"QTYSD-20260126-00001","ticket_type":20021,"abstract":"\u7f51\u94f6\u6c47\u6b3e \u4eac\u4fe1\u670d\uff08\u5b63\u5ea6\u62bc\u91d1\uff09","description":"","created_by":5252,"handler":1011,"amount":"100000","status":2,"settle_amount":"45745.22","un_paid_amount":"54254.78","is_payment_settle":false,"created_at":"2026-01-26 16:23:51","t_type":1,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"handlerPerson":{"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":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":"","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":34,"supplier_id":"","client_id":"","user_id":"","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,"handler":1001,"amount":"100000","status":2,"settle_amount":"0","un_paid_amount":"100000","is_payment_settle":false,"created_at":"2025-09-19 13:30:06","t_type":2,"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"}},"handlerPerson":{"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":"","user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":"","contract_no":"","t_type_display":"\u501f\u51fa\u6b3e"},{"id":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,"handler":1013,"amount":"22508","status":2,"settle_amount":"0","un_paid_amount":"22508","is_payment_settle":false,"created_at":"2025-09-02 14:58:29","t_type":1,"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"}},"handlerPerson":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\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":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":{"id":728,"key":728,"name":"\u9f50\u4e16\u5b89"},"contract_no":"TSKJ20250902-WJC-01","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":12,"supplier_id":"","client_id":"","user_id":"","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,"handler":5388,"amount":"600000","status":2,"settle_amount":"0","un_paid_amount":"600000","is_payment_settle":false,"created_at":"2025-08-08 18:58:13","t_type":2,"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"}},"handlerPerson":{"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":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":"","contract_no":"","t_type_display":"\u501f\u51fa\u6b3e"},{"id":9,"supplier_id":"","client_id":"","user_id":"","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,"handler":5388,"amount":"327600","status":2,"settle_amount":"0","un_paid_amount":"327600","is_payment_settle":false,"created_at":"2025-08-08 18:56:00","t_type":1,"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"}},"handlerPerson":{"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":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":"","contract_no":"","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":8,"supplier_id":"","client_id":"","user_id":"","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,"handler":5388,"amount":"1000","status":2,"settle_amount":"0","un_paid_amount":"1000","is_payment_settle":false,"created_at":"2025-08-08 18:54:44","t_type":1,"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"}},"handlerPerson":{"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":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":"","contract_no":"","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":7,"supplier_id":"","client_id":"","user_id":"","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,"handler":5388,"amount":"1000","status":2,"settle_amount":"0","un_paid_amount":"1000","is_payment_settle":false,"created_at":"2025-08-08 18:53:56","t_type":1,"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"}},"handlerPerson":{"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":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":"","contract_no":"","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":5,"supplier_id":"","client_id":"","user_id":"","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,"handler":5388,"amount":"20000","status":2,"settle_amount":"0","un_paid_amount":"20000","is_payment_settle":false,"created_at":"2025-08-08 18:51:47","t_type":1,"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"}},"handlerPerson":{"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":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u6536\u6b3e","unit":"","contract_no":"","t_type_display":"\u4ed8\u62bc\u91d1"}],"total":"1185746.79","count":18,"pagenation":{"totalcount":18,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"66.249.68.3","ua":"Mozilla\/5.0 (Linux; Android 6.0.1; Nexus 5X Build\/MMB29P) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.7778.96 Mobile Safari\/537.36 (compatible; GoogleOther)"}', FALSE, '2026-06-18 16:47:54', 199773952) RETURNING "id" |
| 16:47:54.516 | 6.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4498, 4007, 4135) |
| 16:47:54.494 | 5.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM (SELECT r.id, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer 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.handler, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_paid_amount, false as is_payment_settle, r.created_at, r.ticket_type as t_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.bank_settle_at IS NOT NULL) AND (r.amount - r.settle_amount > 0)) "sub" ORDER BY created_at DESC) "c" |
| 16:47:54.506 | 2.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5300, 1011, 1013, 5388) |
| 16:47:54.512 | 2.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" AS "name", "from_project" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=3108 |
| 16:47:54.515 | 1.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3404 |
| 16:47:54.501 | 1.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5252, 5388) |
| 16:47:54.509 | 1.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 710, 138, 757, 728) |
| 16:47:54.504 | 1.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 6) |
| 16:47:54.503 | 1.0 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5252, 5388)) |
| 16:47:54.511 | 0.9 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2133, 1331, 2150, 2166) |
| 16:47:54.499 | 0.8 ms | yii\db\Command::query | SELECT * FROM (SELECT r.id, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer 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.handler, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_paid_amount, false as is_payment_settle, r.created_at, r.ticket_type as t_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.bank_settle_at IS NOT NULL) AND (r.amount - r.settle_amount > 0)) "sub" ORDER BY created_at DESC LIMIT 40 |
| 16:47:54.458 | 0.7 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 16:47:54.531 | 0.6 ms | yii\db\Command::query | SELECT SUM(un_paid_amount) FROM (SELECT r.id, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer 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.handler, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_paid_amount, false as is_payment_settle, r.created_at, r.ticket_type as t_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.bank_settle_at IS NOT NULL) AND (r.amount - r.settle_amount > 0)) "sub" |
| 16:47:54.461 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:47:54.532 | 0.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT r.id, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer 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.handler, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_paid_amount, false as is_payment_settle, r.created_at, r.ticket_type as t_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.bank_settle_at IS NOT NULL) AND (r.amount - r.settle_amount > 0)) "sub" |
| 16:47:54.525 | 0.4 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=58 |
| 16:47:54.458 | 0.4 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 16:47:54.526 | 0.3 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=53 |
| 16:47:54.523 | 0.3 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=63 |
| 16:47:54.508 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5388, 1013, 1011, 5300)) |
| 16:47:54.524 | 0.3 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=61 |
| 16:47:54.524 | 0.3 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=62 |
| 16:47:54.530 | 0.3 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=9 |
| 16:47:54.525 | 0.3 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=60 |
| 16:47:54.509 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 6, 7, 3, 1) |
| 16:47:54.526 | 0.3 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=57 |
| 16:47:54.527 | 0.3 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=50 |
| 16:47:54.527 | 0.3 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=52 |
| 16:47:54.528 | 0.3 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=48 |
| 16:47:54.531 | 0.2 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=5 |
| 16:47:54.528 | 0.2 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=46 |
| 16:47:54.528 | 0.2 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=34 |
| 16:47:54.529 | 0.2 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=29 |
| 16:47:54.529 | 0.2 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=12 |
| 16:47:54.530 | 0.2 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=8 |
| 16:47:54.531 | 0.2 ms | yii\db\Command::query | SELECT "bank_settle_at" FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=7 |