Total processing time: 165 ms; Peak memory: 7.599 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 16:42:56.645 | 43.8 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20014) AND ("object_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) GROUP BY "object_id" |
| 16:42:56.689 | 18.3 ms | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20014) AND (remind_user_id = 5064 AND is_read = false) AND ("object_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) GROUP BY "object_id" |
| 16:42:56.638 | 4.0 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (30938, 30941, 30942, 30944, 30960, 31029, 31030, 31112, 31340, 31560, 31678, 31696, 31825, 32096, 32139, 32683, 32684) |
| 16:42:56.752 | 3.4 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', 5064, 5, 'vue/erp-cost-ticket/list', '{"Filter":{"name":"default","sort":"DESC"},"ErpCostTicketSearch":{"wrote_date_period":"","verify_at_period":"","status":"","need_handler":"","handler":"","created_by":""},"page":"1","web_access_token":"66P66ib-3t6D-JRCTEPzE250hI-J5OEu"}', '{"code":2000,"result":{"list":[{"id":57,"serial_no":"FYD-20260512-00003","wrote_date":"2026-04-02","client_id":"","sales_contract_id":"","supplier_id":710,"purchase_contract_id":4007,"status":6,"abstract":"","description":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"","stop_at":"2026-05-12 13:40:42.904694+08","refuse_description":"","is_resubmitted":false,"amount":"1","settle_amount":"0","created_by":1001,"stop_description":"","is_settle":false,"created_at":"2026-05-12 13:40:01","updated_at":"2026-05-12 13:40:42","paid_amount":"","contact_id":"","project_id":"","need_handler":false,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[],"client":{},"salesContract":{},"supplier":{"id":710,"key":710,"name":"\u8d3e\u4e1c\u71c3"},"purchaseContract":{"id":4007,"key":4007,"name":"\u516c\u53f8\u81ea\u7528\u7c7bTSKJ20250701-HYF-001"},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":75,"erp_cost_ticket_id":57,"user_id":1001,"status":3,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":75,"erp_cost_ticket_id":57,"user_id":1001,"status":3,"description":"","verify_at":""},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[{"id":4,"erp_cost_ticket_id":57,"user_id":1001,"status":3,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{"id":4,"erp_cost_ticket_id":57,"user_id":1001,"status":3,"description":"","verify_at":""},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":135591,"object_id":57,"taxonomy_id":323,"term_id":18,"value":"","object_type":9,"extra_int":"183","in_amount":"","out_amount":"1","key":323,"name":"\u5f80\u8fd4\u4ea4\u901a\u8d39","amount":"1","description":"","parent_id":"183","serial_no":"660131","taxonomy":{"id":323,"name":"\u5f80\u8fd4\u4ea4\u901a\u8d39","parent_id":183,"parent":{"id":183,"name":"\u5dee\u65c5\u8d39","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[],"contact":{},"project":{},"commentCount":{"object_id":57,"comment":1},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","handlerAmount":0,"un_settle_amount":1,"can_create_erp_payment_ticket":false,"settleTickets":[]},{"id":53,"serial_no":"FYD-20260512-00002","wrote_date":"2026-05-12","client_id":3303,"sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":6,"abstract":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","description":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-05-12 13:39:46","stop_at":"2026-05-12 13:40:22.380647+08","refuse_description":"","is_resubmitted":false,"amount":"5","settle_amount":"0","created_by":1001,"stop_description":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","is_settle":false,"created_at":"2026-05-12 13:39:32","updated_at":"2026-05-12 13:40:27","paid_amount":"","contact_id":"","project_id":3740,"need_handler":true,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":73,"erp_cost_ticket_id":53,"user_id":1000,"amount":"1","pct":"20","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"name":"\u66f9\u6c38\u751f"},{"id":74,"erp_cost_ticket_id":53,"user_id":5250,"amount":"1","pct":"20","user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"name":"\u8463\u8363"},{"id":75,"erp_cost_ticket_id":53,"user_id":5016,"amount":"1","pct":"20","user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"name":"\u9ad8\u90e1\u9633"},{"id":76,"erp_cost_ticket_id":53,"user_id":5461,"amount":"1","pct":"20","user":{"id":5461,"key":5461,"name":"\u8096\u5e05","sex":"M","department_id":10,"avatar":{"id":165,"user_id":5461,"name":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"name":"\u8096\u5e05"},{"id":77,"erp_cost_ticket_id":53,"user_id":5064,"amount":"1","pct":"20","user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"name":"\u59da\u96ea\u7eaf"}],"client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":72,"erp_cost_ticket_id":53,"user_id":1001,"status":1,"description":"","verify_at":"2026-05-12 13:39:46","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":72,"erp_cost_ticket_id":53,"user_id":1001,"status":1,"description":"","verify_at":"2026-05-12 13:39:46"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[{"id":3,"erp_cost_ticket_id":53,"user_id":1001,"status":1,"description":"","verify_at":"2026-05-12 13:40:27","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{"id":3,"erp_cost_ticket_id":53,"user_id":1001,"status":1,"description":"","verify_at":"2026-05-12 13:40:27"},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":135588,"object_id":53,"taxonomy_id":386,"term_id":18,"value":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","object_type":9,"extra_int":"385","in_amount":"","out_amount":"5","key":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","amount":"5","description":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","parent_id":"385","serial_no":"6115","taxonomy":{"id":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":57649,"object_type":20026,"object_id":53,"attachment_id":32684,"attachment":{"id":32684,"key":32684,"name":"540a6a16-6969-33ce-b776-901bb25ac82a","extension":"pdf","path":"\/vue\/attachment\/view\/540a6a16-6969-33ce-b776-901bb25ac82a\/\u5229\u6da6\u5212\u62e8\u5355_A4_LRHBD-20260316-00001.pdf","orig_name":"\u5229\u6da6\u5212\u62e8\u5355_A4_LRHBD-20260316-00001.pdf"}}],"contact":{},"project":{"id":3740,"key":3740,"name":"\u516c\u6709\u4e91\u8fc1\u79fb\u670d\u52a12"},"commentCount":{"object_id":53,"comment":3},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","handlerAmount":5,"un_settle_amount":5,"can_create_erp_payment_ticket":false,"settleTickets":[]},{"id":54,"serial_no":"FYD-20260512-00001","wrote_date":"2026-05-12","client_id":3303,"sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4ed8\u6b3e\u5355\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","description":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4ed8\u6b3e\u5355\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-05-12 13:40:39","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"1","settle_amount":"1","created_by":1001,"stop_description":"","is_settle":false,"created_at":"2026-05-12 13:36:04","updated_at":"2026-05-12 13:40:39","paid_amount":"","contact_id":"","project_id":3740,"need_handler":false,"print_times":"","all_settle_amount":"1","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[],"client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":68,"erp_cost_ticket_id":54,"user_id":1001,"status":1,"description":"","verify_at":"2026-05-12 13:40:39","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":68,"erp_cost_ticket_id":54,"user_id":1001,"status":1,"description":"","verify_at":"2026-05-12 13:40:39"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":135584,"object_id":54,"taxonomy_id":386,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"1","key":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","amount":"1","description":"","parent_id":"385","serial_no":"6115","taxonomy":{"id":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":57647,"object_type":20026,"object_id":54,"attachment_id":32683,"attachment":{"id":32683,"key":32683,"name":"febd90e3-1774-361e-8df6-17a167973789","extension":"pdf","path":"\/vue\/attachment\/view\/febd90e3-1774-361e-8df6-17a167973789\/\u5ba1\u6279\u7ba1\u7406(62).pdf","orig_name":"\u5ba1\u6279\u7ba1\u7406(62).pdf"}}],"contact":{},"project":{"id":3740,"key":3740,"name":"\u516c\u6709\u4e91\u8fc1\u79fb\u670d\u52a12"},"commentCount":{"object_id":54,"comment":1},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","handlerAmount":0,"un_settle_amount":0,"can_create_erp_payment_ticket":false,"settleTickets":[{"id":39,"id2":39,"supplier_id":"","client_id":3303,"user_id":"","contact_id":"","project_id":"","wrote_date":"2026-05-12","serial_no":"QTSRD-20260512-00001","handler":"","ticket_type":20015,"ticket_type_display":"\u5176\u4ed6\u6536\u5165\u5355","abstract":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","description":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","created_by":1001,"amount":"1","cost_amount":"","status":2,"settle_amount":"5","is_payment_settle":false,"created_at":"2026-05-12 13:42:28","handlers":[{"id":5461,"email":"xiaoshuai@toast.com.cn","name":"\u8096\u5e05","user_status":"1","pinyin_shortcut":"xs","sex":"M","birth_date":"2001-08-20","entry_date":"2025-11-26","department_id":10,"department_position_id":62,"mobile":"13716912663","telephone":"88864628","created_at":"2025-11-26 13:33:48","updated_at":"2025-11-26 14:29:18","id_number":"110111200108203819","native_place":"\u5317\u4eac\u5e02","graduate_school":"\u5317\u6d77\u827a\u672f\u8bbe\u8ba1\u5b66\u9662","specialty":"\u6570\u5b57\u5a92\u4f53\u827a\u672f","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"xiao","pinyin2":"shuai","pinyin3":"","pinyin4":"","namecut1":"\u8096","namecut2":"\u5e05","namecut3":"","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":165,"user_id":5461,"name":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},{"id":5250,"email":"dongrong@jinchangxiao.com","name":"\u8463\u8363","user_status":"1","pinyin_shortcut":"dr","sex":"M","birth_date":"1992-10-05","entry_date":"2020-11-27","department_id":10,"department_position_id":21,"mobile":"18210054154","telephone":"88864628","created_at":"2020-11-27 09:49:55","updated_at":"2025-08-12 15:51:46","id_number":"220283199210052719","native_place":"\u5409\u6797\u7701\u8212\u5170\u5e02","graduate_school":"\u5317\u4eac\u822a\u7a7a\u822a\u5929\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u79d1\u5b66\u4e0e\u6280\u672f","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"dong","pinyin2":"rong","pinyin3":"","pinyin4":"","namecut1":"\u8463","namecut2":"\u8363","namecut3":"","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":false,"view_product_cost":true,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},{"id":1000,"email":"caoyongsheng@toast.com.cn","name":"\u66f9\u6c38\u751f","user_status":"1","pinyin_shortcut":"cys","sex":"M","birth_date":"1986-01-01","entry_date":"2016-07-04","department_id":10,"department_position_id":22,"mobile":"13810260729","telephone":"88864628","created_at":"2017-02-06 12:39:24","updated_at":"2026-04-30 15:41:28","id_number":"372328197810220612","native_place":"\u535a\u5174","graduate_school":"\u6ee8\u5dde\u5e08\u8303\u4e13\u79d1\u5b66\u6821","specialty":"\u6570\u5b66\u6559\u80b2(\u8ba1\u7b97\u673a)","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"813","leave_date":"","pinyin1":"cao","pinyin2":"yong","pinyin3":"sheng","pinyin4":"","namecut1":"\u66f9","namecut2":"\u6c38","namecut3":"\u751f","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":"","work_on_remind":false,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},{"id":5016,"email":"gaojunyang@toast.com.cn","name":"\u9ad8\u90e1\u9633","user_status":"1","pinyin_shortcut":"gjy","sex":"M","birth_date":"1990-02-09","entry_date":"2017-06-12","department_id":10,"department_position_id":21,"mobile":"18202460558","telephone":"88864628","created_at":"2017-07-03 15:10:57","updated_at":"2026-03-30 18:07:41","id_number":"220211199002094218","native_place":"\u5409\u6797","graduate_school":"\u5409\u6797\u7535\u5b50\u4fe1\u606f\u804c\u4e1a\u6280\u672f\u5b66\u9662","specialty":"\u7f51\u7edc\u7cfb\u7edf\u7ba1\u7406","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"888","leave_date":"2026-03-30","pinyin1":"gao","pinyin2":"jun","pinyin3":"yang","pinyin4":"","namecut1":"\u9ad8","namecut2":"\u90e1","namecut3":"\u9633","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":true,"client_lock":false,"view_public":false,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},{"id":5064,"email":"yaoxuechun@jinchangxiao.com","name":"\u59da\u96ea\u7eaf","user_status":"1","pinyin_shortcut":"yxc","sex":"F","birth_date":"1992-08-02","entry_date":"2018-03-06","department_id":10,"department_position_id":25,"mobile":"17610273960","telephone":"88864628","created_at":"2018-03-06 16:55:56","updated_at":"2026-04-23 17:24:00","id_number":"","native_place":"\u4fdd\u5b9a","graduate_school":"","specialty":"","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"845","leave_date":"","pinyin1":"yao","pinyin2":"xue","pinyin3":"chun","pinyin4":"","namecut1":"\u59da","namecut2":"\u96ea","namecut3":"\u7eaf","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}],"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210"}]},{"id":56,"serial_no":"FYD-20260416-00001","wrote_date":"2026-04-16","client_id":2553,"sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-04-16 09:38:58","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"800","settle_amount":"0","created_by":1001,"stop_description":"","is_settle":false,"created_at":"2026-04-16 09:38:52","updated_at":"2026-04-16 09:38:58","paid_amount":"","contact_id":"","project_id":"","need_handler":false,"print_times":"","all_settle_amount":"800","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[],"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":66,"erp_cost_ticket_id":56,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-16 09:38:58","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":66,"erp_cost_ticket_id":56,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-16 09:38:58"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":135370,"object_id":56,"taxonomy_id":386,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"800","key":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","amount":"800","description":"","parent_id":"385","serial_no":"6115","taxonomy":{"id":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[{"id":2391,"erp_payment_ticket_id":2357,"sales_contract_id":"","purchase_contract_id":"","erp_cost_ticket_id":56,"erp_other_payment_ticket_id":"","amount":"800","description":"","erpPaymentTicket":{"id":2357,"serial_no":"FKD-20260512-00005","wrote_date":"2026-05-12","from_date":"","handler":1000,"client_id":2553,"sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-05-12 13:43:51","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"800","settle_amount":"0","created_by":1001,"stop_description":"","is_settle":false,"is_payment_settle":false,"is_old":false,"created_at":"2026-05-12 13:43:51","updated_at":"2026-05-12 13:43:51","paid_amount":"0","contact_id":"","user_id":"","bank_settle_at":"","print_times":"","handlerPerson":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}}}],"attachmentRelationships":[],"files":[],"contact":{},"project":{},"commentCount":{"object_id":56,"comment":17},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#c280ff","status_display":"\u5f85\u4ed8\u6b3e","handlerAmount":0,"un_settle_amount":800,"can_create_erp_payment_ticket":false,"settleTickets":[{"id":2357,"id2":2357,"supplier_id":"","client_id":2553,"user_id":"","contact_id":"","project_id":"","wrote_date":"2026-05-12","serial_no":"FKD-20260512-00005","handler":1000,"ticket_type":20012,"ticket_type_display":"\u4ed8\u6b3e\u5355","abstract":"","description":"","created_by":1001,"amount":"800","cost_amount":"","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-05-12 13:43:51","handlers":[{"id":1000,"email":"caoyongsheng@toast.com.cn","name":"\u66f9\u6c38\u751f","user_status":"1","pinyin_shortcut":"cys","sex":"M","birth_date":"1986-01-01","entry_date":"2016-07-04","department_id":10,"department_position_id":22,"mobile":"13810260729","telephone":"88864628","created_at":"2017-02-06 12:39:24","updated_at":"2026-04-30 15:41:28","id_number":"372328197810220612","native_place":"\u535a\u5174","graduate_school":"\u6ee8\u5dde\u5e08\u8303\u4e13\u79d1\u5b66\u6821","specialty":"\u6570\u5b66\u6559\u80b2(\u8ba1\u7b97\u673a)","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"813","leave_date":"","pinyin1":"cao","pinyin2":"yong","pinyin3":"sheng","pinyin4":"","namecut1":"\u66f9","namecut2":"\u6c38","namecut3":"\u751f","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":"","work_on_remind":false,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}],"bgcolor":"#c280ff","status_display":"\u5f85\u4ed8\u6b3e"}]},{"id":55,"serial_no":"FYD-20260402-00001","wrote_date":"2026-04-02","client_id":"","sales_contract_id":"","supplier_id":710,"purchase_contract_id":4007,"status":4,"abstract":"","description":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-05-12 13:39:56","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"1","settle_amount":"0","created_by":1001,"stop_description":"","is_settle":false,"created_at":"2026-04-02 13:31:02","updated_at":"2026-05-12 13:39:56","paid_amount":"","contact_id":"","project_id":"","need_handler":false,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[],"client":{},"salesContract":{},"supplier":{"id":710,"key":710,"name":"\u8d3e\u4e1c\u71c3"},"purchaseContract":{"id":4007,"key":4007,"name":"\u516c\u53f8\u81ea\u7528\u7c7bTSKJ20250701-HYF-001"},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":74,"erp_cost_ticket_id":55,"user_id":1001,"status":2,"description":"","verify_at":"2026-05-12 13:39:56","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":74,"erp_cost_ticket_id":55,"user_id":1001,"status":2,"description":"","verify_at":"2026-05-12 13:39:56"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":135590,"object_id":55,"taxonomy_id":323,"term_id":18,"value":"","object_type":9,"extra_int":"183","in_amount":"","out_amount":"1","key":323,"name":"\u5f80\u8fd4\u4ea4\u901a\u8d39","amount":"1","description":"","parent_id":"183","serial_no":"660131","taxonomy":{"id":323,"name":"\u5f80\u8fd4\u4ea4\u901a\u8d39","parent_id":183,"parent":{"id":183,"name":"\u5dee\u65c5\u8d39","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[],"contact":{},"project":{},"commentCount":{"object_id":55,"comment":1},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#D9001B","status_display":"\u5df2\u62d2\u7edd","handlerAmount":0,"un_settle_amount":1,"can_create_erp_payment_ticket":false,"settleTickets":[]},{"id":52,"serial_no":"FYD-20260302-00001","wrote_date":"2026-03-02","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u8bb8\u96f7\u8fd4\u6b3e\u5408\u540c\u91d1\u989d20700\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-03-02 21:12:43","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"7000","settle_amount":"7000","created_by":5252,"stop_description":"","is_settle":false,"created_at":"2026-03-02 17:20:08","updated_at":"2026-03-02 21:12:43","paid_amount":"","contact_id":3472,"project_id":4103,"need_handler":true,"print_times":"","all_settle_amount":"7000","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":57,"erp_cost_ticket_id":52,"user_id":5295,"amount":"7000","pct":"100","user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"name":"\u9b4f\u6cfd\u6587"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":61,"erp_cost_ticket_id":52,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-02 21:12:43","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":61,"erp_cost_ticket_id":52,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-02 21:12:43"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":134576,"object_id":52,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"7000","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"7000","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[{"id":2360,"erp_payment_ticket_id":2325,"sales_contract_id":"","purchase_contract_id":"","erp_cost_ticket_id":52,"erp_other_payment_ticket_id":"","amount":"7000","description":"","erpPaymentTicket":{"id":2325,"serial_no":"FKD-20260309-00003","wrote_date":"2026-03-05","from_date":"","handler":5295,"client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u4ed8\u8bb8\u96f7\u8fd4\u6b3e","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-03-09 14:40:29","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"7000","settle_amount":"0","created_by":5252,"stop_description":"","is_settle":false,"is_payment_settle":true,"is_old":false,"created_at":"2026-03-09 13:57:43","updated_at":"2026-03-09 14:40:29","paid_amount":"0","contact_id":3472,"user_id":"","bank_settle_at":"2026-03-09 16:24:50.957679+08","print_times":"","handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}}}],"attachmentRelationships":[],"files":[{"id":56712,"object_type":20026,"object_id":52,"attachment_id":32139,"attachment":{"id":32139,"key":32139,"name":"f84f0f5e-3e79-35a6-b6fb-bf8427e812c7","extension":"jpg","path":"\/vue\/attachment\/view\/f84f0f5e-3e79-35a6-b6fb-bf8427e812c7\/86782abc28fffd2a5e75fad4905d3d0.jpg","orig_name":"86782abc28fffd2a5e75fad4905d3d0.jpg"}}],"contact":{"id":3472,"name":"\u8bb8\u96f7(\u5ba2\u6237\uff1a\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8))","email":"","pinyin_shortcut":"xl","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"56767766","client_id":79,"supplier_id":"","created_by":5209,"created_at":"2020-12-14 15:30:26","updated_at":"2020-12-14 16:24:15","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"oagch6d0ArrxTfJCOx8PiIAwEDkg","pinyin1":"xu","pinyin2":"lei","pinyin3":"","pinyin4":"","namecut1":"\u8bb8","namecut2":"\u96f7","namecut3":"","namecut4":"","is_mp_bind":true,"client":{"id":79,"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)"},"supplier":{}},"project":{"id":4103,"key":4103,"name":"2026\u6df1\u4fe1\u670d\u9632\u706b\u5899\u7eed\u4fdd"},"commentCount":{"object_id":52,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","handlerAmount":7000,"un_settle_amount":0,"can_create_erp_payment_ticket":false,"settleTickets":[{"id":2325,"id2":2325,"supplier_id":"","client_id":"","user_id":"","contact_id":3472,"project_id":"","wrote_date":"2026-03-05","serial_no":"FKD-20260309-00003","handler":5295,"ticket_type":20012,"ticket_type_display":"\u4ed8\u6b3e\u5355","abstract":"\u4ed8\u8bb8\u96f7\u8fd4\u6b3e","description":"","created_by":5252,"amount":"7000","cost_amount":"","status":2,"settle_amount":"0","is_payment_settle":true,"created_at":"2026-03-09 13:57:43","handlers":[{"id":5295,"email":"weizewen@toast.com.cn","name":"\u9b4f\u6cfd\u6587","user_status":"1","pinyin_shortcut":"wzw","sex":"F","birth_date":"1996-07-26","entry_date":"2021-04-07","department_id":1,"department_position_id":2,"mobile":"18601965887","telephone":"88864628","created_at":"2021-04-07 09:21:31","updated_at":"2021-11-29 16:29:49","id_number":"13112219960726282X","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u5929\u6d25\u6e24\u6d77\u804c\u4e1a\u6280\u672f\u5b66\u9662","specialty":"\u836f\u7269\u5236\u5242\u6280\u672f","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"wei","pinyin2":"ze","pinyin3":"wen","pinyin4":"","namecut1":"\u9b4f","namecut2":"\u6cfd","namecut3":"\u6587","namecut4":"","budget_count":"176680.2","profit_count":"37681.430340000000000000","bargain_count":"5","opportunity_budget_count":"623519","opportunity_count":"8","work_log_score":"18","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":true,"view_public":true,"client_remind_alarm_before":4,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}],"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210"}]},{"id":51,"serial_no":"FYD-20260227-00001","wrote_date":"2026-02-27","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":6,"abstract":"\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u8bb8\u96f7\u8fd4\u6b3e\u5408\u540c\u91d1\u989d20700\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-28 08:10:47","stop_at":"2026-03-02 17:16:06.192028+08","refuse_description":"","is_resubmitted":false,"amount":"7000","settle_amount":"0","created_by":5252,"stop_description":"\u5fd8\u8bb0\u5173\u8054\u5546\u673a\u4fe1\u606f","is_settle":false,"created_at":"2026-02-27 17:44:22","updated_at":"2026-03-02 21:12:39","paid_amount":"","contact_id":3472,"project_id":"","need_handler":true,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":55,"erp_cost_ticket_id":51,"user_id":5295,"amount":"7000","pct":"100","user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"name":"\u9b4f\u6cfd\u6587"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":59,"erp_cost_ticket_id":51,"user_id":1001,"status":1,"description":"","verify_at":"2026-02-28 08:10:47","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":59,"erp_cost_ticket_id":51,"user_id":1001,"status":1,"description":"","verify_at":"2026-02-28 08:10:47"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[{"id":1,"erp_cost_ticket_id":51,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-02 21:12:39","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{"id":1,"erp_cost_ticket_id":51,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-02 21:12:39"},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":134517,"object_id":51,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"7000","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"7000","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":56675,"object_type":20026,"object_id":51,"attachment_id":32096,"attachment":{"id":32096,"key":32096,"name":"05ec0cda-7c65-3839-8b60-df8d32df51d8","extension":"jpg","path":"\/vue\/attachment\/view\/05ec0cda-7c65-3839-8b60-df8d32df51d8\/86782abc28fffd2a5e75fad4905d3d0.jpg","orig_name":"86782abc28fffd2a5e75fad4905d3d0.jpg"}}],"contact":{"id":3472,"name":"\u8bb8\u96f7(\u5ba2\u6237\uff1a\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8))","email":"","pinyin_shortcut":"xl","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"56767766","client_id":79,"supplier_id":"","created_by":5209,"created_at":"2020-12-14 15:30:26","updated_at":"2020-12-14 16:24:15","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"oagch6d0ArrxTfJCOx8PiIAwEDkg","pinyin1":"xu","pinyin2":"lei","pinyin3":"","pinyin4":"","namecut1":"\u8bb8","namecut2":"\u96f7","namecut3":"","namecut4":"","is_mp_bind":true,"client":{"id":79,"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)"},"supplier":{}},"project":{},"commentCount":{"object_id":51,"comment":4},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","handlerAmount":7000,"un_settle_amount":7000,"can_create_erp_payment_ticket":false,"settleTickets":[]},{"id":50,"serial_no":"FYD-20260205-00001","wrote_date":"2026-02-05","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"smc\uff08\u4e2d\u56fd\uff09\u5168\u52c7\u7537\u8fd4\u6b3e\u5408\u540c\u91d1\u989d57000\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-05 18:09:05","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"7500","settle_amount":"0","created_by":5252,"stop_description":"","is_settle":false,"created_at":"2026-02-05 17:14:54","updated_at":"2026-02-05 18:09:05","paid_amount":"","contact_id":"","project_id":4094,"need_handler":true,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":53,"erp_cost_ticket_id":50,"user_id":5300,"amount":"7500","pct":"100","user":{"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"}},"name":"\u82cf\u6e05\u4e91"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":57,"erp_cost_ticket_id":50,"user_id":1001,"status":1,"description":"","verify_at":"2026-02-05 18:09:05","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":57,"erp_cost_ticket_id":50,"user_id":1001,"status":1,"description":"","verify_at":"2026-02-05 18:09:05"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":134119,"object_id":50,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"7500","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"7500","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":56305,"object_type":20026,"object_id":50,"attachment_id":31825,"attachment":{"id":31825,"key":31825,"name":"05993f89-c0da-3647-bb5b-a0802bb53565","extension":"jpg","path":"\/vue\/attachment\/view\/05993f89-c0da-3647-bb5b-a0802bb53565\/cb8d4ca1290a1c5c88f3f514aaba8ef.jpg","orig_name":"cb8d4ca1290a1c5c88f3f514aaba8ef.jpg"}}],"contact":{},"project":{"id":4094,"key":4094,"name":"\u6df1\u4fe1\u670d\u865a\u62df\u5316\u6388\u6743\u65b0\u8d2dPOCN26018145-2026"},"commentCount":{"object_id":50,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#c280ff","status_display":"\u5f85\u4ed8\u6b3e","handlerAmount":7500,"un_settle_amount":7500,"can_create_erp_payment_ticket":true,"settleTickets":[]},{"id":49,"serial_no":"FYD-20260202-00001","wrote_date":"2026-02-02","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u5a01\u53d1\u4e16\u7eaa PA\u674e\u777f\u8fd4\u6b3e\u5408\u540c\u91d1\u989d1630000\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-02 13:52:14","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"388713","settle_amount":"0","created_by":5252,"stop_description":"","is_settle":false,"created_at":"2026-02-02 12:46:01","updated_at":"2026-02-02 13:52:14","paid_amount":"","contact_id":6231,"project_id":4098,"need_handler":true,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":50,"erp_cost_ticket_id":49,"user_id":1001,"amount":"388713","pct":"100","user":{"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"}},"name":"\u5218\u4eba\u8bda"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":54,"erp_cost_ticket_id":49,"user_id":1001,"status":1,"description":"","verify_at":"2026-02-02 13:52:14","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":54,"erp_cost_ticket_id":49,"user_id":1001,"status":1,"description":"","verify_at":"2026-02-02 13:52:14"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":134013,"object_id":49,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"388713","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"388713","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":56108,"object_type":20026,"object_id":49,"attachment_id":31696,"attachment":{"id":31696,"key":31696,"name":"cff61865-6c43-31c7-9579-fc4b2319812e","extension":"jpg","path":"\/vue\/attachment\/view\/cff61865-6c43-31c7-9579-fc4b2319812e\/2746e2dd502f2282d1d692a5aa23caab.jpg","orig_name":"2746e2dd502f2282d1d692a5aa23caab.jpg"}}],"contact":{"id":6231,"name":"\u674e\u777f(\u5ba2\u6237\uff1a\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355))","email":"","pinyin_shortcut":"lr","sex":"M","birth_date":"","department":"PA\u5382\u5546","job_position":"\u9500\u552e","mobile":"","telephone":"","client_id":3377,"supplier_id":"","created_by":1001,"created_at":"2026-01-28 14:51:15","updated_at":"2026-01-28 14:51:15","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"rui","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u777f","namecut3":"","namecut4":"","is_mp_bind":false,"client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"supplier":{}},"project":{"id":4098,"key":4098,"name":"PA460\u8bbe\u5907\u7b49\u91c7\u8d2d\u9879\u76ee"},"commentCount":{"object_id":49,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#c280ff","status_display":"\u5f85\u4ed8\u6b3e","handlerAmount":388713,"un_settle_amount":388713,"can_create_erp_payment_ticket":true,"settleTickets":[]},{"id":48,"serial_no":"FYD-20260130-00001","wrote_date":"2026-01-30","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u84dd\u661f\u4e1c\u4e3d\u819c\u9ec4\u5411\u8363\u8fd4\u6b3e\u5408\u540c\u989d58240.2\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-30 16:42:27","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"20000","settle_amount":"20000","created_by":5252,"stop_description":"","is_settle":false,"created_at":"2026-01-30 15:48:09","updated_at":"2026-01-30 16:42:27","paid_amount":"","contact_id":533,"project_id":4101,"need_handler":true,"print_times":"","all_settle_amount":"20000","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":49,"erp_cost_ticket_id":48,"user_id":5295,"amount":"20000","pct":"100","user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"name":"\u9b4f\u6cfd\u6587"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":53,"erp_cost_ticket_id":48,"user_id":1001,"status":1,"description":"","verify_at":"2026-01-30 16:42:27","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":53,"erp_cost_ticket_id":48,"user_id":1001,"status":1,"description":"","verify_at":"2026-01-30 16:42:27"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":133999,"object_id":48,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"20000","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"20000","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[{"id":2323,"erp_payment_ticket_id":2293,"sales_contract_id":"","purchase_contract_id":"","erp_cost_ticket_id":48,"erp_other_payment_ticket_id":"","amount":"20000","description":"","erpPaymentTicket":{"id":2293,"serial_no":"FKD-20260202-00003","wrote_date":"2026-02-02","from_date":"","handler":5295,"client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u4ed8\u9ec4\u5411\u8363\u8fd4\u6b3e","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-02 16:26:18","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"20000","settle_amount":"0","created_by":5252,"stop_description":"","is_settle":false,"is_payment_settle":true,"is_old":false,"created_at":"2026-02-02 16:10:19","updated_at":"2026-02-02 16:26:18","paid_amount":"0","contact_id":533,"user_id":"","bank_settle_at":"2026-02-04 10:10:07.980209+08","print_times":"","handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}}}],"attachmentRelationships":[],"files":[{"id":56079,"object_type":20026,"object_id":48,"attachment_id":31678,"attachment":{"id":31678,"key":31678,"name":"f44765ce-44bd-31b5-9822-0b861cfbacda","extension":"jpg","path":"\/vue\/attachment\/view\/f44765ce-44bd-31b5-9822-0b861cfbacda\/8a279afaf1884c9e7ad927811fb9203.jpg","orig_name":"8a279afaf1884c9e7ad927811fb9203.jpg"}}],"contact":{"id":533,"name":"\u9ec4\u5411\u8363(\u5ba2\u6237\uff1a\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8)","email":"huangxr@tbmc-bj.com","pinyin_shortcut":"hxr","sex":"M","birth_date":"","department":"\u4fe1\u606f\u90e8","job_position":"\u79d1\u957f","mobile":"","telephone":"61468355","client_id":107,"supplier_id":"","created_by":1008,"created_at":"2017-04-28 19:05:10","updated_at":"2024-07-08 14:28:22","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"huang","pinyin2":"xiang","pinyin3":"rong","pinyin4":"","namecut1":"\u9ec4","namecut2":"\u5411","namecut3":"\u8363","namecut4":"","is_mp_bind":true,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"supplier":{}},"project":{"id":4101,"key":4101,"name":"2026veeam\u7eed\u4fdd"},"commentCount":{"object_id":48,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","handlerAmount":20000,"un_settle_amount":0,"can_create_erp_payment_ticket":false,"settleTickets":[{"id":2293,"id2":2293,"supplier_id":"","client_id":"","user_id":"","contact_id":533,"project_id":"","wrote_date":"2026-02-02","serial_no":"FKD-20260202-00003","handler":5295,"ticket_type":20012,"ticket_type_display":"\u4ed8\u6b3e\u5355","abstract":"\u4ed8\u9ec4\u5411\u8363\u8fd4\u6b3e","description":"","created_by":5252,"amount":"20000","cost_amount":"","status":2,"settle_amount":"0","is_payment_settle":true,"created_at":"2026-02-02 16:10:19","handlers":[{"id":5295,"email":"weizewen@toast.com.cn","name":"\u9b4f\u6cfd\u6587","user_status":"1","pinyin_shortcut":"wzw","sex":"F","birth_date":"1996-07-26","entry_date":"2021-04-07","department_id":1,"department_position_id":2,"mobile":"18601965887","telephone":"88864628","created_at":"2021-04-07 09:21:31","updated_at":"2021-11-29 16:29:49","id_number":"13112219960726282X","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u5929\u6d25\u6e24\u6d77\u804c\u4e1a\u6280\u672f\u5b66\u9662","specialty":"\u836f\u7269\u5236\u5242\u6280\u672f","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"wei","pinyin2":"ze","pinyin3":"wen","pinyin4":"","namecut1":"\u9b4f","namecut2":"\u6cfd","namecut3":"\u6587","namecut4":"","budget_count":"176680.2","profit_count":"37681.430340000000000000","bargain_count":"5","opportunity_budget_count":"623519","opportunity_count":"8","work_log_score":"18","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":true,"view_public":true,"client_remind_alarm_before":4,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}],"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210"}]},{"id":47,"serial_no":"FYD-20260123-00001","wrote_date":"2026-01-23","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u84dd\u661f\u4e1c\u4e3d\u819c\u9ec4\u5411\u8363\u8fd4\u6b3e\u5408\u540c\u989d30000\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-23 13:46:14","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"10000","settle_amount":"10000","created_by":5252,"stop_description":"","is_settle":false,"created_at":"2026-01-23 13:40:57","updated_at":"2026-01-23 13:46:14","paid_amount":"","contact_id":533,"project_id":4100,"need_handler":true,"print_times":"","all_settle_amount":"10000","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":48,"erp_cost_ticket_id":47,"user_id":5295,"amount":"10000","pct":"100","user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"name":"\u9b4f\u6cfd\u6587"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":52,"erp_cost_ticket_id":47,"user_id":1001,"status":1,"description":"","verify_at":"2026-01-23 13:46:14","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":52,"erp_cost_ticket_id":47,"user_id":1001,"status":1,"description":"","verify_at":"2026-01-23 13:46:14"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":133876,"object_id":47,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"10000","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"10000","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[{"id":2324,"erp_payment_ticket_id":2294,"sales_contract_id":"","purchase_contract_id":"","erp_cost_ticket_id":47,"erp_other_payment_ticket_id":"","amount":"10000","description":"","erpPaymentTicket":{"id":2294,"serial_no":"FKD-20260202-00004","wrote_date":"2026-02-02","from_date":"","handler":5295,"client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u4ed8\u9ec4\u5411\u8363\u8fd4\u6b3e","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-02 16:26:16","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"10000","settle_amount":"0","created_by":5252,"stop_description":"","is_settle":false,"is_payment_settle":true,"is_old":false,"created_at":"2026-02-02 16:11:10","updated_at":"2026-02-02 16:26:16","paid_amount":"0","contact_id":533,"user_id":"","bank_settle_at":"2026-02-04 10:10:00.492114+08","print_times":"","handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}}}],"attachmentRelationships":[],"files":[{"id":55781,"object_type":20026,"object_id":47,"attachment_id":31560,"attachment":{"id":31560,"key":31560,"name":"2eeb2b6b-c425-33a8-aa81-d12a3b48c887","extension":"jpg","path":"\/vue\/attachment\/view\/2eeb2b6b-c425-33a8-aa81-d12a3b48c887\/ff8cb3f7cd3545d89cc45326cdf50df6.jpg","orig_name":"ff8cb3f7cd3545d89cc45326cdf50df6.jpg"}}],"contact":{"id":533,"name":"\u9ec4\u5411\u8363(\u5ba2\u6237\uff1a\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8)","email":"huangxr@tbmc-bj.com","pinyin_shortcut":"hxr","sex":"M","birth_date":"","department":"\u4fe1\u606f\u90e8","job_position":"\u79d1\u957f","mobile":"","telephone":"61468355","client_id":107,"supplier_id":"","created_by":1008,"created_at":"2017-04-28 19:05:10","updated_at":"2024-07-08 14:28:22","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"huang","pinyin2":"xiang","pinyin3":"rong","pinyin4":"","namecut1":"\u9ec4","namecut2":"\u5411","namecut3":"\u8363","namecut4":"","is_mp_bind":true,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"supplier":{}},"project":{"id":4100,"key":4100,"name":"2026\u6280\u672f\u670d\u52a1"},"commentCount":{"object_id":47,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","handlerAmount":10000,"un_settle_amount":0,"can_create_erp_payment_ticket":false,"settleTickets":[{"id":2294,"id2":2294,"supplier_id":"","client_id":"","user_id":"","contact_id":533,"project_id":"","wrote_date":"2026-02-02","serial_no":"FKD-20260202-00004","handler":5295,"ticket_type":20012,"ticket_type_display":"\u4ed8\u6b3e\u5355","abstract":"\u4ed8\u9ec4\u5411\u8363\u8fd4\u6b3e","description":"","created_by":5252,"amount":"10000","cost_amount":"","status":2,"settle_amount":"0","is_payment_settle":true,"created_at":"2026-02-02 16:11:10","handlers":[{"id":5295,"email":"weizewen@toast.com.cn","name":"\u9b4f\u6cfd\u6587","user_status":"1","pinyin_shortcut":"wzw","sex":"F","birth_date":"1996-07-26","entry_date":"2021-04-07","department_id":1,"department_position_id":2,"mobile":"18601965887","telephone":"88864628","created_at":"2021-04-07 09:21:31","updated_at":"2021-11-29 16:29:49","id_number":"13112219960726282X","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u5929\u6d25\u6e24\u6d77\u804c\u4e1a\u6280\u672f\u5b66\u9662","specialty":"\u836f\u7269\u5236\u5242\u6280\u672f","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"wei","pinyin2":"ze","pinyin3":"wen","pinyin4":"","namecut1":"\u9b4f","namecut2":"\u6cfd","namecut3":"\u6587","namecut4":"","budget_count":"176680.2","profit_count":"37681.430340000000000000","bargain_count":"5","opportunity_budget_count":"623519","opportunity_count":"8","work_log_score":"18","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":true,"view_public":true,"client_remind_alarm_before":4,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}],"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210"}]},{"id":46,"serial_no":"FYD-20260113-00001","wrote_date":"2026-01-13","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u674e\u777f\u8fd4\u6b3e\u5408\u540c\u989d1400\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-13 10:59:38","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"723","settle_amount":"0","created_by":5388,"stop_description":"","is_settle":false,"created_at":"2026-01-13 10:56:12","updated_at":"2026-01-13 10:59:38","paid_amount":"","contact_id":6221,"project_id":4096,"need_handler":true,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":47,"erp_cost_ticket_id":46,"user_id":1001,"amount":"723","pct":"100","user":{"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"}},"name":"\u5218\u4eba\u8bda"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":51,"erp_cost_ticket_id":46,"user_id":1001,"status":1,"description":"","verify_at":"2026-01-13 10:59:38","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":51,"erp_cost_ticket_id":46,"user_id":1001,"status":1,"description":"","verify_at":"2026-01-13 10:59:38"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":133472,"object_id":46,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"723","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"723","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":55255,"object_type":20026,"object_id":46,"attachment_id":31340,"attachment":{"id":31340,"key":31340,"name":"a9de8d97-980d-3da8-81dd-647c1cc8443d","extension":"jpg","path":"\/vue\/attachment\/view\/a9de8d97-980d-3da8-81dd-647c1cc8443d\/0fafffe32bc804572b37616380efb600.jpg","orig_name":"0fafffe32bc804572b37616380efb600.jpg"}}],"contact":{"id":6221,"name":"\u674e\u777f(\u5ba2\u6237\uff1a\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8)","email":"","pinyin_shortcut":"lr","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2553,"supplier_id":"","created_by":1011,"created_at":"2026-01-13 10:53:53","updated_at":"2026-01-13 10:53:53","user_status":2,"description":"\u5382\u5546\u9500\u552e","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"rui","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u777f","namecut3":"","namecut4":"","is_mp_bind":false,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"supplier":{}},"project":{"id":4096,"key":4096,"name":"\u6a21\u5757\u91c7\u8d2d"},"commentCount":{"object_id":46,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#c280ff","status_display":"\u5f85\u4ed8\u6b3e","handlerAmount":723,"un_settle_amount":723,"can_create_erp_payment_ticket":true,"settleTickets":[]},{"id":45,"serial_no":"FYD-20251231-00001","wrote_date":"2025-12-31","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u4e2d\u54a8\u6570\u636e\u738b\u5929\u6cfd\u8fd4\u6b3e\u5408\u540c\u989d256000\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-12-31 12:52:04","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"96000","settle_amount":"0","created_by":5388,"stop_description":"","is_settle":false,"created_at":"2025-12-31 12:51:47","updated_at":"2025-12-31 12:52:04","paid_amount":"","contact_id":1331,"project_id":3923,"need_handler":true,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":45,"erp_cost_ticket_id":45,"user_id":1005,"amount":"96000","pct":"100","user":{"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"}},"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":49,"erp_cost_ticket_id":45,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-31 12:52:04","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":49,"erp_cost_ticket_id":45,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-31 12:52:04"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":133230,"object_id":45,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"96000","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"96000","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":54831,"object_type":20026,"object_id":45,"attachment_id":31112,"attachment":{"id":31112,"key":31112,"name":"d6d28b52-56d5-3de8-9d5f-7c770b5f9ded","extension":"jpg","path":"\/vue\/attachment\/view\/d6d28b52-56d5-3de8-9d5f-7c770b5f9ded\/a0d9985c0538700148c1419c8cfb0469.jpg","orig_name":"a0d9985c0538700148c1419c8cfb0469.jpg"}}],"contact":{"id":1331,"name":"\u738b\u5929\u6cfd(\u5ba2\u6237\uff1a\u4e2d\u56fd\u516c\u8def\u5de5\u7a0b\u54a8\u8be2\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u4e2d\u54a8\u6570\u636e\u6709\u9650\u516c\u53f8))","email":"","pinyin_shortcut":"wtz","sex":"M","birth_date":"","department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f","mobile":"","telephone":"57050666","client_id":101,"supplier_id":"","created_by":1005,"created_at":"2017-11-27 11:27:24","updated_at":"2023-12-28 11:06:28","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"oagch6cTwzSNUMjxr81BmuohmDWI","pinyin1":"wang","pinyin2":"tian","pinyin3":"ze","pinyin4":"","namecut1":"\u738b","namecut2":"\u5929","namecut3":"\u6cfd","namecut4":"","is_mp_bind":true,"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)"},"supplier":{}},"project":{"id":3923,"key":3923,"name":"25\u5e74-26\u5e74\u865a\u62df\u5316\u670d\u52a1"},"commentCount":{"object_id":45,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#c280ff","status_display":"\u5f85\u4ed8\u6b3e","handlerAmount":96000,"un_settle_amount":96000,"can_create_erp_payment_ticket":true,"settleTickets":[]},{"id":44,"serial_no":"FYD-20251230-00007","wrote_date":"2025-12-30","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u4e2d\u56fd\u6c11\u822a\u5e72\u90e8\u5f20\u79b9\u8fd4\u6b3e\u5408\u540c\u989d291000\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-12-30 18:03:55","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"226980","settle_amount":"0","created_by":5388,"stop_description":"","is_settle":false,"created_at":"2025-12-30 18:00:43","updated_at":"2025-12-30 18:03:55","paid_amount":"","contact_id":6209,"project_id":4079,"need_handler":true,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":44,"erp_cost_ticket_id":44,"user_id":1001,"amount":"226980","pct":"100","user":{"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"}},"name":"\u5218\u4eba\u8bda"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":48,"erp_cost_ticket_id":44,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 18:03:55","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":48,"erp_cost_ticket_id":44,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 18:03:55"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":132956,"object_id":44,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"226980","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"226980","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":54699,"object_type":20026,"object_id":44,"attachment_id":31030,"attachment":{"id":31030,"key":31030,"name":"46b589e2-cd7c-3997-a11d-160e11f33b7f","extension":"jpg","path":"\/vue\/attachment\/view\/46b589e2-cd7c-3997-a11d-160e11f33b7f\/b85d492af8bb44edf2ee90839df4f89a.jpg","orig_name":"b85d492af8bb44edf2ee90839df4f89a.jpg"}}],"contact":{"id":6209,"name":"\u5f20\u79b9(\u5ba2\u6237\uff1a\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662)","email":"","pinyin_shortcut":"zy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3432,"supplier_id":"","created_by":1001,"created_at":"2025-12-19 13:44:52","updated_at":"2025-12-19 13:44:52","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"yu","pinyin3":"","pinyin4":"","namecut1":"\u5f20","namecut2":"\u79b9","namecut3":"","namecut4":"","is_mp_bind":false,"client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"supplier":{}},"project":{"id":4079,"key":4079,"name":"\u6c11\u822a\u5b89\u5168\u6cd5\u5f8b\u6cd5\u89c4\u6570\u636e\u5e93\u4f18\u5316\u4e0e\u5b89\u5168\u80dc\u4efb\u529b\u6d4b\u8bc4\u7cfb\u7edf\u5f00\u53d1\u9879\u76ee"},"commentCount":{"object_id":44,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#c280ff","status_display":"\u5f85\u4ed8\u6b3e","handlerAmount":226980,"un_settle_amount":226980,"can_create_erp_payment_ticket":true,"settleTickets":[]},{"id":43,"serial_no":"FYD-20251230-00006","wrote_date":"2025-12-30","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u4e2d\u56fd\u6c11\u822a\u5e72\u90e8\u5f20\u79b9\u8fd4\u6b3e\u5408\u540c\u989d63000\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-12-30 18:00:09","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"49140","settle_amount":"0","created_by":5388,"stop_description":"","is_settle":false,"created_at":"2025-12-30 17:58:52","updated_at":"2025-12-30 18:00:09","paid_amount":"","contact_id":6209,"project_id":4078,"need_handler":true,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":43,"erp_cost_ticket_id":43,"user_id":1001,"amount":"49140","pct":"100","user":{"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"}},"name":"\u5218\u4eba\u8bda"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":47,"erp_cost_ticket_id":43,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 18:00:09","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":47,"erp_cost_ticket_id":43,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 18:00:09"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":132955,"object_id":43,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"49140","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"49140","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":54698,"object_type":20026,"object_id":43,"attachment_id":31029,"attachment":{"id":31029,"key":31029,"name":"108000db-c680-3096-a659-166bc5b0e4a2","extension":"jpg","path":"\/vue\/attachment\/view\/108000db-c680-3096-a659-166bc5b0e4a2\/cf3690f045392e838d46e4eb76bc8137.jpg","orig_name":"cf3690f045392e838d46e4eb76bc8137.jpg"}}],"contact":{"id":6209,"name":"\u5f20\u79b9(\u5ba2\u6237\uff1a\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662)","email":"","pinyin_shortcut":"zy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3432,"supplier_id":"","created_by":1001,"created_at":"2025-12-19 13:44:52","updated_at":"2025-12-19 13:44:52","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"yu","pinyin3":"","pinyin4":"","namecut1":"\u5f20","namecut2":"\u79b9","namecut3":"","namecut4":"","is_mp_bind":false,"client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"supplier":{}},"project":{"id":4078,"key":4078,"name":"2025\u5e74\u6c11\u94f6\u884c\u5b89\u5168\u80fd\u529b\u5efa\u8bbe\u9879\u76ee"},"commentCount":{"object_id":43,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#c280ff","status_display":"\u5f85\u4ed8\u6b3e","handlerAmount":49140,"un_settle_amount":49140,"can_create_erp_payment_ticket":true,"settleTickets":[]},{"id":42,"serial_no":"FYD-20251230-00005","wrote_date":"2025-12-30","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u6731\u8d85\u8fd4\u6b3e\u5408\u540c\u989d2551700\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-12-30 15:48:57","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"375243.18","settle_amount":"0","created_by":5388,"stop_description":"","is_settle":false,"created_at":"2025-12-30 15:04:41","updated_at":"2025-12-30 15:48:57","paid_amount":"","contact_id":5206,"project_id":3963,"need_handler":true,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":42,"erp_cost_ticket_id":42,"user_id":1005,"amount":"375243.18","pct":"100","user":{"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"}},"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":46,"erp_cost_ticket_id":42,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 15:48:57","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":46,"erp_cost_ticket_id":42,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 15:48:57"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":132952,"object_id":42,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"375243.18","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"375243.18","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":54603,"object_type":20026,"object_id":42,"attachment_id":30960,"attachment":{"id":30960,"key":30960,"name":"1cebcdc7-c0fd-32ca-9795-66e0c0d367d4","extension":"jpg","path":"\/vue\/attachment\/view\/1cebcdc7-c0fd-32ca-9795-66e0c0d367d4\/18b4324d7954982f4da884d6eab3c300.jpg","orig_name":"18b4324d7954982f4da884d6eab3c300.jpg"}}],"contact":{"id":5206,"name":"\u6731\u8d85(\u5ba2\u6237\uff1a\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6240\u529e))","email":"","pinyin_shortcut":"zc","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2737,"supplier_id":"","created_by":1005,"created_at":"2024-02-02 09:21:12","updated_at":"2025-09-19 12:48:21","user_status":2,"description":"\u4e0d\u62bd\u70df\uff0c\u4e0d\u559d\u9152\n\u793c\u54c1\u53ef\u4ee5\u53d1\u6240\u91cc\u3002\u4f53\u79ef\u5f97\u5c0f","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhu","pinyin2":"chao","pinyin3":"","pinyin4":"","namecut1":"\u6731","namecut2":"\u8d85","namecut3":"","namecut4":"","is_mp_bind":false,"client":{"id":2737,"key":2737,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6240\u529e)"},"supplier":{}},"project":{"id":3963,"key":3963,"name":"\u4e00\u6240\u7f51\u7edc\u53ca\u4fe1\u606f\u5316\u57fa\u7840\u8bbe\u65bd\u5347\u7ea7\u52a0\u56fa\u91c7\u8d2d\u9879\u76ee\u4e8c\u671f"},"commentCount":{"object_id":42,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#c280ff","status_display":"\u5f85\u4ed8\u6b3e","handlerAmount":375243.18,"un_settle_amount":375243.18,"can_create_erp_payment_ticket":true,"settleTickets":[]},{"id":41,"serial_no":"FYD-20251230-00004","wrote_date":"2025-12-30","client_id":2136,"sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u9500\u552e\u5408\u540c\u989d\u6709\u8bef\u8c03\u51cf\u5e94\u6536\u6b3e\u51cf\u5c11","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-12-30 11:37:21","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"533.6","settle_amount":"533.6","created_by":5388,"stop_description":"","is_settle":false,"created_at":"2025-12-30 10:48:41","updated_at":"2025-12-30 11:37:21","paid_amount":"","contact_id":"","project_id":3951,"need_handler":true,"print_times":"","all_settle_amount":"533.6","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":41,"erp_cost_ticket_id":41,"user_id":5087,"amount":"533.6","pct":"100","user":{"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"}},"name":"\u5218\u5fae"}],"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":45,"erp_cost_ticket_id":41,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 11:37:21","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":45,"erp_cost_ticket_id":41,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 11:37:21"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":132945,"object_id":41,"taxonomy_id":396,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"533.6","key":396,"name":"\u8c03\u8d26\u4e8f\u635f","amount":"533.6","description":"","parent_id":"385","serial_no":"600701","taxonomy":{"id":396,"name":"\u8c03\u8d26\u4e8f\u635f","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":54581,"object_type":20026,"object_id":41,"attachment_id":30944,"attachment":{"id":30944,"key":30944,"name":"80d39917-4e9b-396b-9ddd-a9897094b46f","extension":"jpg","path":"\/vue\/attachment\/view\/80d39917-4e9b-396b-9ddd-a9897094b46f\/22664df1bf4c672ffaea22c417187e4a.jpg","orig_name":"22664df1bf4c672ffaea22c417187e4a.jpg"}}],"contact":{},"project":{"id":3951,"key":3951,"name":"\u8bfb\u5361\u5668\u91c7\u8d2d"},"commentCount":{"object_id":41,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","handlerAmount":533.6,"un_settle_amount":0,"can_create_erp_payment_ticket":false,"settleTickets":[]},{"id":40,"serial_no":"FYD-20251230-00003","wrote_date":"2025-12-30","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u5b59\u51ef\u8fd4\u6b3e\u5408\u540c\u989d140250\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-12-30 12:18:46","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"30000","settle_amount":"30000","created_by":5388,"stop_description":"","is_settle":false,"created_at":"2025-12-30 10:41:06","updated_at":"2025-12-30 12:18:46","paid_amount":"","contact_id":443,"project_id":4055,"need_handler":true,"print_times":"","all_settle_amount":"30000","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":40,"erp_cost_ticket_id":40,"user_id":5295,"amount":"30000","pct":"100","user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"name":"\u9b4f\u6cfd\u6587"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":44,"erp_cost_ticket_id":40,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 12:18:46","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":44,"erp_cost_ticket_id":40,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 12:18:46"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":132944,"object_id":40,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"30000","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"30000","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[{"id":2293,"erp_payment_ticket_id":2268,"sales_contract_id":"","purchase_contract_id":"","erp_cost_ticket_id":40,"erp_other_payment_ticket_id":"","amount":"30000","description":"","erpPaymentTicket":{"id":2268,"serial_no":"FKD-20260105-00004","wrote_date":"2026-01-05","from_date":"","handler":5295,"client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u4ed8\u5b59\u51ef\u8fd4\u6b3e","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-05 18:58:09","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"30000","settle_amount":"0","created_by":5388,"stop_description":"","is_settle":false,"is_payment_settle":true,"is_old":false,"created_at":"2026-01-05 18:57:48","updated_at":"2026-01-05 18:58:09","paid_amount":"0","contact_id":443,"user_id":"","bank_settle_at":"2026-01-08 17:16:53.953164+08","print_times":"","handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}}}],"attachmentRelationships":[],"files":[{"id":54578,"object_type":20026,"object_id":40,"attachment_id":30942,"attachment":{"id":30942,"key":30942,"name":"6752f1c6-c54a-322c-bcc8-4eb8b8f75e2c","extension":"jpg","path":"\/vue\/attachment\/view\/6752f1c6-c54a-322c-bcc8-4eb8b8f75e2c\/0bad595c468b77930c59743ec69658c8.jpg","orig_name":"0bad595c468b77930c59743ec69658c8.jpg"}}],"contact":{"id":443,"name":"\u5b59\u51ef(\u5ba2\u6237\uff1a\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09)","email":"kai.sun@zurich.com","pinyin_shortcut":"sk","sex":"M","birth_date":"","department":"\u4fe1\u606f\u90e8","job_position":"\u4fe1\u606f\u4e2d\u5fc3\u4e3b\u4efb","mobile":"","telephone":"84547860","client_id":90,"supplier_id":"","created_by":1006,"created_at":"2017-03-28 13:39:44","updated_at":"2019-01-11 10:38:19","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"oagch6b--laeW4GGf0v1j0DBFhUc","pinyin1":"sun","pinyin2":"kai","pinyin3":"","pinyin4":"","namecut1":"\u5b59","namecut2":"\u51ef","namecut3":"","namecut4":"","is_mp_bind":true,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":{}},"project":{"id":4055,"key":4055,"name":"2025veeam\u7eed\u4fdd\u53ca\u786c\u4ef6\u7ef4\u4fdd"},"commentCount":{"object_id":40,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","handlerAmount":30000,"un_settle_amount":0,"can_create_erp_payment_ticket":false,"settleTickets":[{"id":2268,"id2":2268,"supplier_id":"","client_id":"","user_id":"","contact_id":443,"project_id":"","wrote_date":"2026-01-05","serial_no":"FKD-20260105-00004","handler":5295,"ticket_type":20012,"ticket_type_display":"\u4ed8\u6b3e\u5355","abstract":"\u4ed8\u5b59\u51ef\u8fd4\u6b3e","description":"","created_by":5388,"amount":"30000","cost_amount":"","status":2,"settle_amount":"0","is_payment_settle":true,"created_at":"2026-01-05 18:57:48","handlers":[{"id":5295,"email":"weizewen@toast.com.cn","name":"\u9b4f\u6cfd\u6587","user_status":"1","pinyin_shortcut":"wzw","sex":"F","birth_date":"1996-07-26","entry_date":"2021-04-07","department_id":1,"department_position_id":2,"mobile":"18601965887","telephone":"88864628","created_at":"2021-04-07 09:21:31","updated_at":"2021-11-29 16:29:49","id_number":"13112219960726282X","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u5929\u6d25\u6e24\u6d77\u804c\u4e1a\u6280\u672f\u5b66\u9662","specialty":"\u836f\u7269\u5236\u5242\u6280\u672f","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"wei","pinyin2":"ze","pinyin3":"wen","pinyin4":"","namecut1":"\u9b4f","namecut2":"\u6cfd","namecut3":"\u6587","namecut4":"","budget_count":"176680.2","profit_count":"37681.430340000000000000","bargain_count":"5","opportunity_budget_count":"623519","opportunity_count":"8","work_log_score":"18","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":true,"view_public":true,"client_remind_alarm_before":4,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}],"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210"}]},{"id":39,"serial_no":"FYD-20251230-00002","wrote_date":"2025-12-30","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u5317\u4eac\u68b5\u7c73\u79d1\u6280\u674e\u7ee7\u822a\u8fd4\u6b3e\u5408\u540c\u989d28000\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-12-30 12:20:21","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"2400","settle_amount":"0","created_by":5388,"stop_description":"","is_settle":false,"created_at":"2025-12-30 10:30:03","updated_at":"2025-12-30 12:20:21","paid_amount":"","contact_id":6205,"project_id":4074,"need_handler":true,"print_times":"","all_settle_amount":"0","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":39,"erp_cost_ticket_id":39,"user_id":1004,"amount":"2400","pct":"100","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"name":"\u4f0a\u5cfb\u8fb0"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":43,"erp_cost_ticket_id":39,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 12:20:21","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":43,"erp_cost_ticket_id":39,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 12:20:21"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":132942,"object_id":39,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"2400","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"2400","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[],"attachmentRelationships":[],"files":[{"id":54576,"object_type":20026,"object_id":39,"attachment_id":30941,"attachment":{"id":30941,"key":30941,"name":"5df729f0-2fec-3cd0-865b-3abe88436f68","extension":"jpg","path":"\/vue\/attachment\/view\/5df729f0-2fec-3cd0-865b-3abe88436f68\/60a591981765b575ad3b534e68d93571.jpg","orig_name":"60a591981765b575ad3b534e68d93571.jpg"}}],"contact":{"id":6205,"name":"PA\u674e\u7ee7\u822a(\u5ba2\u6237\uff1a\u5317\u4eac\u68b5\u7c73\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09)","email":"","pinyin_shortcut":"PAljh","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"88865175","client_id":3431,"supplier_id":"","created_by":1004,"created_at":"2025-12-16 10:48:05","updated_at":"2025-12-16 10:48:05","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"pa","pinyin2":"li","pinyin3":"ji","pinyin4":"hang","namecut1":"p","namecut2":"a","namecut3":"\u674e","namecut4":"\u7ee7","is_mp_bind":false,"client":{"id":3431,"key":3431,"name":"\u5317\u4eac\u68b5\u7c73\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"supplier":{}},"project":{"id":4074,"key":4074,"name":"PA440 \u9632\u706b\u5899\u9879\u76ee\u91c7\u8d2d"},"commentCount":{"object_id":39,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#c280ff","status_display":"\u5f85\u4ed8\u6b3e","handlerAmount":2400,"un_settle_amount":2400,"can_create_erp_payment_ticket":true,"settleTickets":[]},{"id":38,"serial_no":"FYD-20251230-00001","wrote_date":"2025-12-30","client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u8054\u60f3\u51cc\u62d3\u674e\u65b0\u4e1c\u8fd4\u6b3e\u5408\u540c\u989d182056\u5143","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-12-30 12:18:31","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"19042","settle_amount":"19042","created_by":5388,"stop_description":"","is_settle":false,"created_at":"2025-12-30 10:12:51","updated_at":"2025-12-30 12:18:31","paid_amount":"","contact_id":4414,"project_id":3946,"need_handler":true,"print_times":"","all_settle_amount":"19042","need_verify_sort":4,"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"}},"erpCostTicketHandlers":[{"id":38,"erp_cost_ticket_id":38,"user_id":5300,"amount":"19042","pct":"100","user":{"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"}},"name":"\u82cf\u6e05\u4e91"}],"client":{},"salesContract":{},"supplier":{},"purchaseContract":{},"erpCostTicketCarbonCopyRels":[],"erpCostTicketVerifyRels":[{"id":42,"erp_cost_ticket_id":38,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 12:18:31","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"lastErpCostTicketVerifyRel":{},"haveErpCostTicketVerifyRel":{"id":42,"erp_cost_ticket_id":38,"user_id":1001,"status":1,"description":"","verify_at":"2025-12-30 12:18:31"},"selfErpCostTicketVerifyRel":{},"erpCostTicketStopVerifyRels":[],"lastErpCostTicketStopVerifyRel":{},"haveErpCostTicketStopVerifyRel":{},"selfErpCostTicketStopVerifyRel":{},"erpCostTicketAmounts":[{"id":132941,"object_id":38,"taxonomy_id":432,"term_id":18,"value":"","object_type":9,"extra_int":"385","in_amount":"","out_amount":"19042","key":432,"name":"\u56de\u6263\u8fd4\u70b9","amount":"19042","description":"","parent_id":"385","serial_no":"600719","taxonomy":{"id":432,"name":"\u56de\u6263\u8fd4\u70b9","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}],"erpPaymentTicketSettles":[{"id":2279,"erp_payment_ticket_id":2255,"sales_contract_id":"","purchase_contract_id":"","erp_cost_ticket_id":38,"erp_other_payment_ticket_id":"","amount":"19042","description":"","erpPaymentTicket":{"id":2255,"serial_no":"FKD-20251230-00002","wrote_date":"2025-12-30","from_date":"","handler":5300,"client_id":"","sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u4ed8\u674e\u65b0\u4e1c\u8fd4\u6b3e","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-12-30 13:28:16","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"19042","settle_amount":"0","created_by":5388,"stop_description":"","is_settle":false,"is_payment_settle":true,"is_old":false,"created_at":"2025-12-30 13:16:13","updated_at":"2025-12-30 13:28:16","paid_amount":"0","contact_id":4414,"user_id":"","bank_settle_at":"2025-12-30 16:28:45.860776+08","print_times":"","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"}}}}],"attachmentRelationships":[],"files":[{"id":54574,"object_type":20026,"object_id":38,"attachment_id":30938,"attachment":{"id":30938,"key":30938,"name":"7cc53781-1754-36d0-ad47-6357ef0a50dd","extension":"jpg","path":"\/vue\/attachment\/view\/7cc53781-1754-36d0-ad47-6357ef0a50dd\/4a0e68b6937b8b6f2cd35cc70dfafbe5.jpg","orig_name":"4a0e68b6937b8b6f2cd35cc70dfafbe5.jpg"}}],"contact":{"id":4414,"name":"\u674e\u65b0\u4e1c(\u5ba2\u6237\uff1a\u8054\u60f3\u51cc\u62d3\u79d1\u6280\u6709\u9650\u516c\u53f8)","email":"","pinyin_shortcut":"lxd","sex":"M","birth_date":"","department":"\u91c7\u8d2d","job_position":"","mobile":"","telephone":"59293042","client_id":2146,"supplier_id":"","created_by":5300,"created_at":"2022-11-14 19:53:15","updated_at":"2023-11-16 17:30:08","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"xin","pinyin3":"dong","pinyin4":"","namecut1":"\u674e","namecut2":"\u65b0","namecut3":"\u4e1c","namecut4":"","is_mp_bind":false,"client":{"id":2146,"key":2146,"name":"\u8054\u60f3\u51cc\u62d3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"supplier":{}},"project":{"id":3946,"key":3946,"name":"\u601d\u79d1\u786c\u4ef6\u7ef4\u4fdd-k-2025"},"commentCount":{"object_id":38,"comment":2},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","handlerAmount":19042,"un_settle_amount":0,"can_create_erp_payment_ticket":false,"settleTickets":[{"id":2255,"id2":2255,"supplier_id":"","client_id":"","user_id":"","contact_id":4414,"project_id":"","wrote_date":"2025-12-30","serial_no":"FKD-20251230-00002","handler":5300,"ticket_type":20012,"ticket_type_display":"\u4ed8\u6b3e\u5355","abstract":"\u4ed8\u674e\u65b0\u4e1c\u8fd4\u6b3e","description":"","created_by":5388,"amount":"19042","cost_amount":"","status":2,"settle_amount":"0","is_payment_settle":true,"created_at":"2025-12-30 13:16:13","handlers":[{"id":5300,"email":"suqingyun@toast.com.cn","name":"\u82cf\u6e05\u4e91","user_status":"1","pinyin_shortcut":"sqy","sex":"F","birth_date":"1988-11-27","entry_date":"2021-06-28","department_id":1,"department_position_id":2,"mobile":"13889570890","telephone":"88864628","created_at":"2021-06-28 09:26:03","updated_at":"2021-11-29 16:30:12","id_number":"230231198811274721","native_place":"\u9ed1\u9f99\u6c5f\u7701\u62dc\u6cc9\u53bf","graduate_school":"\u9ed1\u9f99\u6c5f\u519c\u4e1a\u7ecf\u6d4e\u804c\u4e1a\u5b66\u9662","specialty":"\u5546\u52a1\u82f1\u8bed","education":"\u5927\u4e13","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"su","pinyin2":"qing","pinyin3":"yun","pinyin4":"","namecut1":"\u82cf","namecut2":"\u6e05","namecut3":"\u4e91","namecut4":"","budget_count":"132220","profit_count":"15156.676000000000000000","bargain_count":"3","opportunity_budget_count":"1000000","opportunity_count":"12","work_log_score":"27","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":true,"client_lock":true,"view_public":true,"client_remind_alarm_before":3,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"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"}}],"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210"}]}],"can_create":true,"pagenation":{"totalcount":57,"thispage":1,"pagesize":20},"count":{"statusCount":[{"count":0,"key":1,"name":"\u5ba1\u6838\u4e2d","color":"#FEF7EC","border":"#FF9200","sum":0},{"count":0,"key":5,"name":"\u7ea2\u5b57\u53cd\u51b2\u5ba1\u6838\u4e2d","color":"#EAF8FE","border":"#81D3F8","sum":0},{"count":17,"key":21,"name":"\u5f85\u4ed8\u6b3e","color":"#F4E8FF","border":"#C280FF","sum":"1218548.18"},{"count":34,"key":22,"name":"\u5df2\u5b8c\u6210","color":"#E7F3D5","border":"#70B603","sum":"725273.1"},{"count":3,"key":4,"name":"\u5df2\u62d2\u7edd","color":"#F9D4D9","border":"#D9001B","sum":"1751"}]}},"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:42:56', 156572928) RETURNING "id" |
| 16:42:56.611 | 2.8 ms | yii\db\Command::query | SELECT r.*, min( CASE WHEN 1 = r.verify_type THEN ( CASE WHEN rvr.status = 0 THEN 1 WHEN rsvr.status = 0 THEN 2 ELSE 4 END ) ELSE ( CASE WHEN rvr.status = 0 AND r.next_verify_user = 5064 THEN 1 WHEN rsvr.status = 0 AND r.next_stop_verify_user = 5064 THEN 2 ELSE 4 END ) END) AS need_verify_sort FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_verify_rels" "rvr" ON rvr.erp_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_cost_ticket_id = r.id WHERE (("r"."created_by"=5064) OR ("rvr"."user_id"=5064) OR ("r"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449, 5461, 5467, 5476))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=5064))) GROUP BY "r"."id" ORDER BY need_verify_sort asc, created_at DESC LIMIT 20 |
| 16:42:56.608 | 2.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT r.*, min( CASE WHEN 1 = r.verify_type THEN ( CASE WHEN rvr.status = 0 THEN 1 WHEN rsvr.status = 0 THEN 2 ELSE 4 END ) ELSE ( CASE WHEN rvr.status = 0 AND r.next_verify_user = 5064 THEN 1 WHEN rsvr.status = 0 AND r.next_stop_verify_user = 5064 THEN 2 ELSE 4 END ) END) AS need_verify_sort FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_verify_rels" "rvr" ON rvr.erp_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_cost_ticket_id = r.id WHERE (("r"."created_by"=5064) OR ("rvr"."user_id"=5064) OR ("r"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449, 5461, 5467, 5476))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=5064))) GROUP BY "r"."id" ORDER BY need_verify_sort asc, created_at DESC) "c" |
| 16:42:56.634 | 2.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20025) AND ("object_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) |
| 16:42:56.636 | 2.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20026) AND ("object_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) |
| 16:42:56.710 | 1.9 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=57) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=57) GROUP BY "r"."id" )) "sub" |
| 16:42:56.643 | 1.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (3472, 6231, 533, 6221, 1331, 6209, 5206, 443, 6205, 4414) |
| 16:42:56.630 | 1.4 ms | yii\db\Command::query | SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."status" IN (2, 5)) AND ("r"."erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) |
| 16:42:56.743 | 1.3 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=39) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=39) GROUP BY "r"."id" )) "sub" |
| 16:42:56.727 | 1.3 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=48) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=48) GROUP BY "r"."id" )) "sub" |
| 16:42:56.717 | 1.3 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=56) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=56) GROUP BY "r"."id" )) "sub" |
| 16:42:56.738 | 1.3 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=42) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=42) GROUP BY "r"."id" )) "sub" |
| 16:42:56.732 | 1.2 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=46) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=46) GROUP BY "r"."id" )) "sub" |
| 16:42:56.712 | 1.2 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=53) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=53) GROUP BY "r"."id" )) "sub" |
| 16:42:56.714 | 1.2 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=54) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=54) GROUP BY "r"."id" )) "sub" |
| 16:42:56.730 | 1.2 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=47) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=47) GROUP BY "r"."id" )) "sub" |
| 16:42:56.740 | 1.2 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=40) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=40) GROUP BY "r"."id" )) "sub" |
| 16:42:56.720 | 1.2 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=52) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=52) GROUP BY "r"."id" )) "sub" |
| 16:42:56.744 | 1.2 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=38) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=38) GROUP BY "r"."id" )) "sub" |
| 16:42:56.723 | 1.2 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=51) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=51) GROUP BY "r"."id" )) "sub" |
| 16:42:56.724 | 1.2 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=50) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=50) GROUP BY "r"."id" )) "sub" |
| 16:42:56.719 | 1.2 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=55) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=55) GROUP BY "r"."id" )) "sub" |
| 16:42:56.736 | 1.1 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=43) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=43) GROUP BY "r"."id" )) "sub" |
| 16:42:56.739 | 1.1 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=41) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=41) GROUP BY "r"."id" )) "sub" |
| 16:42:56.735 | 1.1 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=44) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=44) GROUP BY "r"."id" )) "sub" |
| 16:42:56.726 | 1.1 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=49) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=49) GROUP BY "r"."id" )) "sub" |
| 16:42:56.747 | 1.1 ms | yii\db\Command::query | SELECT count(*) as count, CASE WHEN status = 21 THEN sum(amount - settle_amount) WHEN status = 22 THEN sum(settle_amount) ELSE sum(amount) END as sum, "status" FROM (SELECT r.amount, r.settle_amount, CASE WHEN r.status = 2 and settle_amount < r.amount THEN 21 WHEN r.status = 2 and settle_amount >= r.amount THEN 22 ELSE r.status END as status FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_verify_rels" "rvr" ON rvr.erp_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_cost_ticket_id = r.id WHERE (("r"."created_by"=5064) OR ("rvr"."user_id"=5064) OR ("r"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449, 5461, 5467, 5476))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=5064))) GROUP BY "r"."id") "sub" GROUP BY "status" |
| 16:42:56.733 | 1.1 ms | yii\db\Command::query | SELECT * FROM ((SELECT (r.id::varchar || 20012::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.wrote_date, r.serial_no, r.handler, 20012 as ticket_type, '付款单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_settles" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=45) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20015::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.wrote_date, r.serial_no, null::integer as handler, 20015 as ticket_type, '其他收入单' as ticket_type_display, r.abstract, r.description, r.created_by, sum(t.amount) as amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 5)) AND ("t"."erp_cost_ticket_id"=45) GROUP BY "r"."id" )) "sub" |
| 16:42:56.628 | 1.1 ms | yii\db\Command::query | SELECT pt.*, taxonomy_id as key, tt.name as name, COALESCE(out_amount, 0) as amount, value as description, extra_int as parent_id, tt.serial_no FROM "a57be577deb434"."tbl_term_taxonomy_relationships" "pt" LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON taxonomy_id = tt.id WHERE ("pt"."term_id"=18) AND ("pt"."object_type"=9) AND ("pt"."object_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) ORDER BY "id" |
| 16:42:56.621 | 1.0 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3303, 2553, 2136) |
| 16:42:56.597 | 0.9 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5064 |
| 16:42:56.715 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (SELECT "user_id" FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" WHERE "erp_other_income_ticket_id"=39) |
| 16:42:56.599 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 16:42:56.632 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id" IN (2255, 2268, 2293, 2294, 2325, 2357) |
| 16:42:56.617 | 0.5 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:42:56.618 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 6) |
| 16:42:56.619 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_handlers" WHERE "erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38) |
| 16:42:56.623 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_carbon_copy_rels" WHERE "erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38) |
| 16:42:56.627 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_stop_verify_rels" WHERE ("status"=0) AND ("erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) ORDER BY "id" |
| 16:42:56.722 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 16:42:56.617 | 0.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:42:56.620 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1004, 5295, 5087, 1005, 1001, 1000, 5250, 5016, 5461, 5064) |
| 16:42:56.607 | 0.4 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" ORDER BY "id" |
| 16:42:56.596 | 0.3 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 16:42:56.622 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=710 |
| 16:42:56.718 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:42:56.620 | 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, 5064, 1000, 5295, 5461, 5300, 5250, 5087, 1004, 1005, 5016)) |
| 16:42:56.729 | 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"=5295) |
| 16:42:56.742 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 16:42:56.731 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 16:42:56.624 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_verify_rels" WHERE "erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38) ORDER BY "id" |
| 16:42:56.746 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5300 |
| 16:42:56.728 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 16:42:56.645 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3740, 4103, 4094, 4098, 4101, 4100, 4096, 3923, 4079, 4078, 3963, 3951, 4055, 4074, 3946) |
| 16:42:56.644 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (90, 107, 101, 79, 2146, 2737, 3431, 3432, 2553, 3377) |
| 16:42:56.625 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) ORDER BY "id" |
| 16:42:56.633 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295, 1000) |
| 16:42:56.621 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 10, 1) |
| 16:42:56.630 | 0.2 ms | yii\db\Command::query | SELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id" IN (432, 396, 386, 323) |
| 16:42:56.625 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_verify_rels" WHERE ("status"=0) AND ("erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) ORDER BY "id" |
| 16:42:56.626 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_stop_verify_rels" WHERE "erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38) ORDER BY "id" |
| 16:42:56.747 | 0.2 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" ORDER BY "id" |
| 16:42:56.716 | 0.2 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 (5461, 5250, 1000, 5016, 5064)) |
| 16:42:56.628 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_stop_verify_rels" WHERE ("status" != 0) AND ("erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) ORDER BY "id" |
| 16:42:56.623 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4007 |
| 16:42:56.628 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=5064) AND ("erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) |
| 16:42:56.633 | 0.2 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 (1000, 5295, 5300)) |
| 16:42:56.626 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:42:56.624 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:42:56.626 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_verify_rels" WHERE ("status" = 0) AND ("user_id"=5064) AND ("erp_cost_ticket_id" IN (57, 53, 54, 56, 55, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38)) |
| 16:42:56.722 | 0.2 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"=5295) |
| 16:42:56.742 | 0.2 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"=5295) |
| 16:42:56.630 | 0.2 ms | yii\db\Command::query | SELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id" IN (385, 183) |
| 16:42:56.718 | 0.2 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"=1000) |
| 16:42:56.746 | 0.2 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"=5300) |
| 16:42:56.627 | 0.2 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"=1001) |
| 16:42:56.731 | 0.2 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"=5295) |
| 16:42:56.625 | 0.2 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"=1001) |
| 16:42:56.716 | 0.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 16:42:56.633 | 0.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 1) |
| 16:42:56.729 | 0.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 16:42:56.746 | 0.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 16:42:56.742 | 0.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 16:42:56.719 | 0.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 16:42:56.732 | 0.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 16:42:56.723 | 0.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |