Total processing time: 137 ms; Peak memory: 5.956 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
13:23:00.675 | 20.3 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049)) GROUP BY "object_id" |
13:23:00.638 | 18.2 ms | yii\db\Command::query | SELECT count(object_id) as count FROM "a57be577deb434"."tbl_unread_comments" "uc" LEFT JOIN "a57be577deb434"."tbl_approves" "r" ON uc.object_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE (object_id = r.id AND object_type = '37' AND remind_user_id = '1001' AND is_read = false) AND ("rccr"."user_id"=1001) AND ("r"."status" != 0) GROUP BY "object_id" |
13:23:00.696 | 16.7 ms | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=37) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049)) GROUP BY "object_id" |
13:23:00.664 | 8.6 ms | yii\db\Command::query | SELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE ("dt1"."taxonomy_id"='2100000000') AND ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001)) AND ("r"."status"=2) AND ("dt1"."taxonomy_id"=2100000000) AND (r.erp_payment_un_settle_amount <= 0) GROUP BY "r"."id" ORDER BY case when r.status = 1 then 0 else 1 end asc, case when r.status = 1 then r.created_at else r.verify_at end DESC, r.created_at DESC LIMIT 20 |
13:23:00.628 | 7.9 ms | yii\db\Command::query | SELECT count(*) as count, sum(case when "sub".status=1 then 1 else 0 end) countStatus1, sum(case when "sub".status=2 then 1 else 0 end) countStatus2, sum(case when "sub".status=4 then 1 else 0 end) countStatus4 FROM (SELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE ("dt1"."taxonomy_id"='2100000000') AND ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001)) AND ("r"."status"=2) AND ("dt1"."taxonomy_id"=2100000000) AND (r.erp_payment_un_settle_amount <= 0) GROUP BY "r"."id") "sub" |
13:23:00.657 | 7.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE ("dt1"."taxonomy_id"='2100000000') AND ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001)) AND ("r"."status"=2) AND ("dt1"."taxonomy_id"=2100000000) AND (r.erp_payment_un_settle_amount <= 0) GROUP BY "r"."id" ORDER BY case when r.status = 1 then 0 else 1 end asc, case when r.status = 1 then r.created_at else r.verify_at end DESC, r.created_at DESC) "c" |
13:23:00.743 | 4.8 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/approve/list', '{"ApproveSearch":{"form_type":["2100000000"],"filter":"all","form_department":"","created_by":"","form_approveVerifyRels":"","status":"","created_at_period":"","verify_at_period":"","borrow_collect_status":"","erp_payment_settle_amount":"1"},"Filter":{"name":"","sort":""},"page":"1","web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":{"list":[{"id":2105,"client_id":"","project_id":"","title":"\u6d4b\u8bd5","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:34:31","description":"\u6d4b\u8bd5","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:32:56","updated_at":"2025-08-04 11:34:31","supplier_id":431,"purchase_contract_id":4072,"amount":"2222","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"2222","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","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"}},"commentCount":{"object_id":2105,"comment":1},"unreadComments":{"object_id":2105,"unread":1},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7545,"approve_id":2105,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"approveVerifyRels":[{"id":2739,"approve_id":2105,"user_id":5252,"status":1,"description":"\u6d4b\u8bd5","verify_at":"2025-08-04 11:34:31","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2739,"approve_id":2105,"user_id":5252,"status":1,"description":"\u6d4b\u8bd5","verify_at":"2025-08-04 11:34:31"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4072,"key":4072,"name":"\u6d4b\u8bd5\u8c01\u662f\u8c01","handler":1011,"cost_type":1,"erp_un_settle_amount":"46109","created_at":"2025-08-04 11:00:32","amount":"53400","serial_no":"\u6d4b\u8bd5\u8c01\u662f\u8c01","purchaseContractPaymentCollectionRemindDates":[],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":1,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2103,"client_id":"","project_id":"","title":"\u6d4b\u8bd5","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:30:10","description":"\u5403","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:03:30","updated_at":"2025-08-04 11:30:10","supplier_id":431,"purchase_contract_id":4072,"amount":"4000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"5068","erp_payment_un_settle_amount":"-1068","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","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"}},"commentCount":{"object_id":2103,"comment":2},"unreadComments":{"object_id":2103,"unread":2},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7544,"approve_id":2103,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"approveVerifyRels":[{"id":2738,"approve_id":2103,"user_id":5252,"status":1,"description":"","verify_at":"2025-08-04 11:30:10","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2738,"approve_id":2103,"user_id":5252,"status":1,"description":"","verify_at":"2025-08-04 11:30:10"},"attachmentRelationships":[{"id":37345,"object_type":28,"object_id":2103,"attachment_id":27143,"attachment":{"id":27143,"key":27143,"name":"be83c968-2963-3390-8bea-7fd4edb49161","extension":"png","path":"\/vue\/attachment\/view\/be83c968-2963-3390-8bea-7fd4edb49161\/\u622a\u5c4f2025-08-04 10.34.45.png","orig_name":"\u622a\u5c4f2025-08-04 10.34.45.png"}}],"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4072,"key":4072,"name":"\u6d4b\u8bd5\u8c01\u662f\u8c01","handler":1011,"cost_type":1,"erp_un_settle_amount":"46109","created_at":"2025-08-04 11:00:32","amount":"53400","serial_no":"\u6d4b\u8bd5\u8c01\u662f\u8c01","purchaseContractPaymentCollectionRemindDates":[],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":2,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2097,"client_id":12,"project_id":3930,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-28 17:55:50","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u56fa\u6001\u76d8\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5130\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-28 17:55:34","updated_at":"2025-07-28 17:55:50","supplier_id":608,"purchase_contract_id":4069,"amount":"130","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2097,"comment":2},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7537,"approve_id":2097,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7538,"approve_id":2097,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7539,"approve_id":2097,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2733,"approve_id":2097,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 17:55:50","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2733,"approve_id":2097,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 17:55:50"},"attachmentRelationships":[],"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3930,"key":3930,"name":"POTJ25078337-\u56fa\u6001\u786c\u76d8-2025","buildContract":{"id":4068,"from_project":3930,"serial_no":"SMC\u5929\u6d25POTJ25078337"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContract":{"id":4069,"key":4069,"name":"\u8ba2\u5355\u53f7: 4651203278745161702\t","handler":1011,"cost_type":1,"erp_un_settle_amount":"130","created_at":"2025-07-25 16:45:53","amount":"130.00","serial_no":"\u8ba2\u5355\u53f7: 4651203278745161702\t","purchaseContractPaymentCollectionRemindDates":[{"id":806,"key":806,"contract_id":4069,"name":"2025-07-31","value":"130","overdue_days":"","status":0}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":36098,"object_type":29,"object_id":2097,"attachment_id":27103,"attachment":{"id":27103,"key":27103,"name":"0186417a-90af-3f39-ba73-82a4ee437d40","extension":"pdf","path":"\/vue\/attachment\/view\/0186417a-90af-3f39-ba73-82a4ee437d40\/2025_07_25_17_08_57.pdf","orig_name":"2025_07_25_17_08_57.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2101,"client_id":2136,"project_id":3922,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-28 11:40:00","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6df1\u4fe1\u670d\u8bbe\u5907AC-1000-B1100-4D\u91c7\u8d2d\u6b3e\u7528\u4e8e\u8ba2\u8d27\uff0c\u91d1\u989d\uff1a\uffe518000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-28 10:36:44","updated_at":"2025-07-28 11:40:00","supplier_id":138,"purchase_contract_id":4070,"amount":"18000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2101,"comment":2},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7533,"approve_id":2101,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7534,"approve_id":2101,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7535,"approve_id":2101,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2731,"approve_id":2101,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 11:40:00","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2731,"approve_id":2101,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 11:40:00"},"attachmentRelationships":[],"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"project":{"id":3922,"key":3922,"name":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","buildContract":{"id":4061,"from_project":3922,"serial_no":""}},"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4070,"key":4070,"name":"H202507255159","handler":1011,"cost_type":1,"erp_un_settle_amount":"18000","created_at":"2025-07-25 17:04:56","amount":"18000.00","serial_no":"H202507255159","purchaseContractPaymentCollectionRemindDates":[{"id":807,"key":807,"contract_id":4070,"name":"2025-07-28","value":"18000","overdue_days":"","status":0}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":36083,"object_type":29,"object_id":2101,"attachment_id":27120,"attachment":{"id":27120,"key":27120,"name":"8ce3195d-9492-333e-8ead-949255c38ee4","extension":"pdf","path":"\/vue\/attachment\/view\/8ce3195d-9492-333e-8ead-949255c38ee4\/2025_07_28_10_34_36.pdf","orig_name":"2025_07_28_10_34_36.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2090,"client_id":2205,"project_id":3831,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u82f1\u8fc8","status":2,"next_verify_user":"","verify_at":"2025-07-28 09:43:45","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u6613\u8f66\u4fe1\u606f-PA\u9632\u706b\u5899\u7eed\u4fdd\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d113344.8\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf77.28\u65e5\uff08\u5468\u4e00\uff09\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-07-24 13:27:04","updated_at":"2025-07-28 09:43:45","supplier_id":68,"purchase_contract_id":3963,"amount":"113344.8","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"113344.8","erp_payment_un_settle_amount":"-113344.8","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2090,"comment":4},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7496,"approve_id":2090,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7497,"approve_id":2090,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"approveVerifyRels":[{"id":2715,"approve_id":2090,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-28 09:24:38","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachmentRelationships":[],"files":[]},{"id":2716,"approve_id":2090,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 09:43:45","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2715,"approve_id":2090,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-28 09:24:38"},"attachmentRelationships":[],"client":{"id":2205,"key":2205,"name":"\u5317\u4eac\u6613\u8f66\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":3831,"key":3831,"name":"PA\u9632\u706b\u5899\u7eed\u4fdd","buildContract":{"id":3960,"from_project":3831,"serial_no":"P00186867"}},"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":3963,"key":3963,"name":"PA20250606SSS","handler":1011,"cost_type":1,"erp_un_settle_amount":"0","created_at":"2025-06-06 16:06:33","amount":"113344.80","serial_no":"PA20250606SSS","purchaseContractPaymentCollectionRemindDates":[{"id":803,"key":803,"contract_id":3963,"name":"2025-07-28","value":"113344.8","overdue_days":0,"status":1}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":36024,"object_type":29,"object_id":2090,"attachment_id":27075,"attachment":{"id":27075,"key":27075,"name":"4a9eb223-1fef-3252-adb6-2286846af718","extension":"jpg","path":"\/vue\/attachment\/view\/4a9eb223-1fef-3252-adb6-2286846af718\/17561753334645_.pic_hd.jpg","orig_name":"17561753334645_.pic_hd.jpg"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2094,"client_id":12,"project_id":3929,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u652f\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-28 09:43:41","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8SMC\u20144\u5757\u786c\u76d8\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d520\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-07-25 13:49:16","updated_at":"2025-07-28 09:43:41","supplier_id":608,"purchase_contract_id":4066,"amount":"520","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2094,"comment":3},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7505,"approve_id":2094,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7506,"approve_id":2094,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"approveVerifyRels":[{"id":2720,"approve_id":2094,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-25 13:53:38","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachmentRelationships":[],"files":[]},{"id":2721,"approve_id":2094,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 09:43:41","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2720,"approve_id":2094,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-25 13:53:38"},"attachmentRelationships":[],"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3929,"key":3929,"name":"OTJ25077468-\u56fa\u6001\u786c\u76d8-G-2025","buildContract":{"id":4065,"from_project":3929,"serial_no":"SMC\u5929\u6d25POTJ25077468"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContract":{"id":4066,"key":4066,"name":"\u8ba2\u5355\u53f7: 4649415087350592710","handler":5360,"cost_type":1,"erp_un_settle_amount":"520","created_at":"2025-07-24 13:51:17","amount":"520.00","serial_no":"\u8ba2\u5355\u53f7: 4649415087350592710","purchaseContractPaymentCollectionRemindDates":[{"id":804,"key":804,"contract_id":4066,"name":"2025-08-08","value":"520","overdue_days":"","status":0}],"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":36047,"object_type":29,"object_id":2094,"attachment_id":27096,"attachment":{"id":27096,"key":27096,"name":"a7b631ef-9b59-3c3c-a227-96a07c147b34","extension":"jpg","path":"\/vue\/attachment\/view\/a7b631ef-9b59-3c3c-a227-96a07c147b34\/17611753422447_.pic_hd.jpg","orig_name":"17611753422447_.pic_hd.jpg"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2098,"client_id":1181,"project_id":3847,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-28 09:43:37","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8PA\u7ef4\u4fdd\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe577637\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-28 09:29:09","updated_at":"2025-07-28 09:43:37","supplier_id":90,"purchase_contract_id":3940,"amount":"77637","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"77637","erp_payment_un_settle_amount":"-77637","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2098,"comment":3},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7518,"approve_id":2098,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7519,"approve_id":2098,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7520,"approve_id":2098,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2726,"approve_id":2098,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 09:43:37","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2726,"approve_id":2098,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 09:43:37"},"attachmentRelationships":[],"client":{"id":1181,"key":1181,"name":"\u5148\u6b63\u8fbe\u751f\u7269\u79d1\u6280(\u4e2d\u56fd);\u5148\u6b63\u8fbe(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8;\u5317\u4eac\u65ed\u65e5\u4f73\u4e1a\u7f51\u7edc\u6709\u9650\u516c\u53f8\uff08CAE\/EDA\/BIO\uff09"},"project":{"id":3847,"key":3847,"name":"PA850\u7eed\u4fdd-K-2025","buildContract":{"id":3925,"from_project":3847,"serial_no":"1100534666"}},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":3940,"key":3940,"name":"X_2025SBQ13270","handler":1011,"cost_type":1,"erp_un_settle_amount":"0","created_at":"2025-05-29 12:58:29","amount":"77637.00","serial_no":"X_2025SBQ13270","purchaseContractPaymentCollectionRemindDates":[{"id":700,"key":700,"contract_id":3940,"name":"2025-07-28","value":"77637","overdue_days":0,"status":1}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2099,"client_id":1663,"project_id":3827,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-28 09:43:33","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8PA\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe514001\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-28 09:33:16","updated_at":"2025-07-28 09:43:33","supplier_id":90,"purchase_contract_id":3928,"amount":"14001","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"14001","erp_payment_un_settle_amount":"-14001","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2099,"comment":3},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7524,"approve_id":2099,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7525,"approve_id":2099,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7526,"approve_id":2099,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2728,"approve_id":2099,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 09:43:33","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2728,"approve_id":2099,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 09:43:33"},"attachmentRelationships":[],"client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011"},"project":{"id":3827,"key":3827,"name":"PA\u7eed\u4fdd1\u5e74-C-2025","buildContract":{"id":3926,"from_project":3827,"serial_no":"ATPE-2025018"}},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":3928,"key":3928,"name":"X_2025SBQ13223","handler":1011,"cost_type":1,"erp_un_settle_amount":"0","created_at":"2025-05-27 14:25:33","amount":"14001.00","serial_no":"X_2025SBQ13223","purchaseContractPaymentCollectionRemindDates":[{"id":698,"key":698,"contract_id":3928,"name":"2025-07-28","value":"14001","overdue_days":0,"status":1}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2100,"client_id":1663,"project_id":3827,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-28 09:43:29","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8PA\u4ea7\u54c1\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5135000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-28 09:42:32","updated_at":"2025-07-28 09:43:29","supplier_id":90,"purchase_contract_id":3927,"amount":"135000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"135000","erp_payment_un_settle_amount":"-135000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2100,"comment":3},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7530,"approve_id":2100,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7531,"approve_id":2100,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7532,"approve_id":2100,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2730,"approve_id":2100,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 09:43:29","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2730,"approve_id":2100,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 09:43:29"},"attachmentRelationships":[],"client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011"},"project":{"id":3827,"key":3827,"name":"PA\u7eed\u4fdd1\u5e74-C-2025","buildContract":{"id":3926,"from_project":3827,"serial_no":"ATPE-2025018"}},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":3927,"key":3927,"name":"X_2025SBQ13217","handler":1011,"cost_type":1,"erp_un_settle_amount":"0","created_at":"2025-05-27 14:24:29","amount":"135000.00","serial_no":"X_2025SBQ13217","purchaseContractPaymentCollectionRemindDates":[{"id":699,"key":699,"contract_id":3927,"name":"2025-07-28","value":"135000","overdue_days":0,"status":1}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2088,"client_id":12,"project_id":3924,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u652f\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-25 11:32:13","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8SMC\u2014\u786c\u76d8\u3001\u5185\u5b58\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d658.63\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-07-23 11:06:21","updated_at":"2025-07-25 11:32:13","supplier_id":608,"purchase_contract_id":4052,"amount":"658.63","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2088,"comment":3},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7492,"approve_id":2088,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7493,"approve_id":2088,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"approveVerifyRels":[{"id":2712,"approve_id":2088,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-23 11:12:01","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachmentRelationships":[],"files":[]},{"id":2713,"approve_id":2088,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-25 11:32:13","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2712,"approve_id":2088,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-23 11:12:01"},"attachmentRelationships":[],"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3924,"key":3924,"name":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","buildContract":{"id":4049,"from_project":3924,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25076163"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContract":{"id":4052,"key":4052,"name":"\u8ba2\u5355\u53f7: 4643512058994592710\/4643515981688592710","handler":5360,"cost_type":1,"erp_un_settle_amount":"658.63","created_at":"2025-07-21 11:21:01","amount":"658.63","serial_no":"\u8ba2\u5355\u53f7: 4643512058994592710\/4643515981688592710","purchaseContractPaymentCollectionRemindDates":[{"id":790,"key":790,"contract_id":4052,"name":"2025-07-31","value":"658.63","overdue_days":"","status":0}],"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":35979,"object_type":29,"object_id":2088,"attachment_id":27038,"attachment":{"id":27038,"key":27038,"name":"fb36e72f-31c9-3e14-a3ae-2b73fc1203d0","extension":"jpg","path":"\/vue\/attachment\/view\/fb36e72f-31c9-3e14-a3ae-2b73fc1203d0\/17471753239622_.pic_hd.jpg","orig_name":"17471753239622_.pic_hd.jpg"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2093,"client_id":1492,"project_id":3810,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-24 15:40:33","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u8d1d\u745e\u6536\u8d27\u7ef4\u4fdd\u5185\u9700\u6c42\u4e00\u4e2a40G\u6a21\u5757\uff0c\u91c7\u8d2d\u91d1\u989d\uff1a\uffe5397.01\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-24 15:38:07","updated_at":"2025-07-24 15:40:33","supplier_id":262,"purchase_contract_id":4067,"amount":"397.01","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2093,"comment":2},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7502,"approve_id":2093,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7503,"approve_id":2093,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7504,"approve_id":2093,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2719,"approve_id":2093,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-24 15:40:33","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2719,"approve_id":2093,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-24 15:40:33"},"attachmentRelationships":[],"client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)"},"project":{"id":3810,"key":3810,"name":"NETAPP\u5b58\u50a8\u7eed\u4fdd\u670d\u52a1-2025\u5e74","buildContract":{"id":3892,"from_project":3810,"serial_no":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8\u5408\u540c 25GBG035"}},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContract":{"id":4067,"key":4067,"name":"\u8ba2\u5355\u53f7\uff1a327559652672","handler":1011,"cost_type":1,"erp_un_settle_amount":"397.01","created_at":"2025-07-24 14:55:07","amount":"397.01","serial_no":"\u8ba2\u5355\u53f7\uff1a327559652672","purchaseContractPaymentCollectionRemindDates":[{"id":805,"key":805,"contract_id":4067,"name":"2025-07-25","value":"397.01","overdue_days":"","status":0}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":36036,"object_type":29,"object_id":2093,"attachment_id":27086,"attachment":{"id":27086,"key":27086,"name":"c8f88094-ced2-32c2-9195-c9f8eaad01a2","extension":"pdf","path":"\/vue\/attachment\/view\/c8f88094-ced2-32c2-9195-c9f8eaad01a2\/\u652f\u51fa.pdf","orig_name":"\u652f\u51fa.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2087,"client_id":12,"project_id":3920,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u652f\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-23 12:23:59","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8SMC\u2014\u5185\u5b58\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d197.75\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-07-23 11:04:56","updated_at":"2025-07-23 12:23:59","supplier_id":608,"purchase_contract_id":4045,"amount":"197.75","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2087,"comment":3},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7490,"approve_id":2087,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7491,"approve_id":2087,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"approveVerifyRels":[{"id":2710,"approve_id":2087,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-23 11:12:31","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachmentRelationships":[],"files":[]},{"id":2711,"approve_id":2087,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-23 12:23:59","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2710,"approve_id":2087,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-23 11:12:31"},"attachmentRelationships":[],"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3920,"key":3920,"name":"OTJ25075740-\u5185\u5b58-2025","buildContract":{"id":4043,"from_project":3920,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25075740"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContract":{"id":4045,"key":4045,"name":"\u8ba2\u5355\u53f7: 4635961815999592710","handler":5360,"cost_type":1,"erp_un_settle_amount":"197.75","created_at":"2025-07-17 13:18:04","amount":"197.75","serial_no":"\u8ba2\u5355\u53f7: 4635961815999592710","purchaseContractPaymentCollectionRemindDates":[{"id":786,"key":786,"contract_id":4045,"name":"2025-07-25","value":"197.75","overdue_days":"","status":0}],"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":35978,"object_type":29,"object_id":2087,"attachment_id":27037,"attachment":{"id":27037,"key":27037,"name":"ece78bed-1d3b-3487-97e0-6a1425ff81d0","extension":"jpg","path":"\/vue\/attachment\/view\/ece78bed-1d3b-3487-97e0-6a1425ff81d0\/17461753239617_.pic_hd.jpg","orig_name":"17461753239617_.pic_hd.jpg"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2086,"client_id":2177,"project_id":3865,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-23 10:55:24","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u4eac\u4e1c\u5361\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe52000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-23 10:53:57","updated_at":"2025-07-23 10:55:24","supplier_id":262,"purchase_contract_id":4062,"amount":"2000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2086,"comment":2},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7487,"approve_id":2086,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7488,"approve_id":2086,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7489,"approve_id":2086,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2709,"approve_id":2086,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-23 10:55:24","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2709,"approve_id":2086,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-23 10:55:24"},"attachmentRelationships":[],"client":{"id":2177,"key":2177,"name":"\u4e2d\u79cd\u56fd\u9645\u79cd\u5b50\u6709\u9650\u516c\u53f8"},"project":{"id":3865,"key":3865,"name":"2025\u5353\u8c6a\u8fd0\u7ef4\u8f6f\u4ef6\u65b0\u8d2d\u548c\u7eed\u4fdd","buildContract":{"id":3930,"from_project":3865,"serial_no":"SER-I7-20250102"}},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContract":{"id":4062,"key":4062,"name":"\u8ba2\u5355\u53f7\uff1a 327609705325","handler":1011,"cost_type":1,"erp_un_settle_amount":"2000","created_at":"2025-07-23 10:52:39","amount":"2000.00","serial_no":"\u8ba2\u5355\u53f7\uff1a 327609705325","purchaseContractPaymentCollectionRemindDates":[{"id":801,"key":801,"contract_id":4062,"name":"2025-07-25","value":"2000","overdue_days":"","status":0}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":35975,"object_type":29,"object_id":2086,"attachment_id":27035,"attachment":{"id":27035,"key":27035,"name":"6472d686-862e-3bff-8e95-75dc1e28a1a2","extension":"pdf","path":"\/vue\/attachment\/view\/6472d686-862e-3bff-8e95-75dc1e28a1a2\/2025_07_23_10_50_10.pdf","orig_name":"2025_07_23_10_50_10.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2080,"client_id":1301,"project_id":3835,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-21 17:35:36","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u591a\u7ef4\u8054\u5408\u2014\u6df1\u4fe1\u670d\u8bbe\u5907\u7eed\u4fdd\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d47000\u5143\uff0c\u7533\u8bf7\u73b0\u7ed3\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-07-21 17:17:43","updated_at":"2025-07-21 17:35:36","supplier_id":236,"purchase_contract_id":4059,"amount":"47000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"47000","erp_payment_un_settle_amount":"-47000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2080,"comment":4},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7438,"approve_id":2080,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7439,"approve_id":2080,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"approveVerifyRels":[{"id":2695,"approve_id":2080,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-21 17:19:56","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachmentRelationships":[],"files":[]},{"id":2696,"approve_id":2080,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-21 17:35:36","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2695,"approve_id":2080,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-21 17:19:56"},"attachmentRelationships":[],"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"project":{"id":3835,"key":3835,"name":"2025\u6df1\u4fe1\u670d\u8bbe\u5907\u7eed\u4fdd","buildContract":{"id":4028,"from_project":3835,"serial_no":"TS-WZW-20250709001"}},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4059,"key":4059,"name":"TSKJ20250721-ZHF-001","handler":5360,"cost_type":1,"erp_un_settle_amount":"0","created_at":"2025-07-21 17:15:57","amount":"47000.00","serial_no":"TSKJ20250721-ZHF-001","purchaseContractPaymentCollectionRemindDates":[{"id":796,"key":796,"contract_id":4059,"name":"2025-07-22","value":"47000","overdue_days":"","status":1}],"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":35936,"object_type":29,"object_id":2080,"attachment_id":27002,"attachment":{"id":27002,"key":27002,"name":"891e9a3f-49de-3c7a-8e44-318e41ad6285","extension":"jpg","path":"\/vue\/attachment\/view\/891e9a3f-49de-3c7a-8e44-318e41ad6285\/17301753089186_.pic_hd.jpg","orig_name":"17301753089186_.pic_hd.jpg"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2075,"client_id":"","project_id":"","title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-21 13:29:17","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6280\u672f\u91c7\u8d2d\u5149\u76d8\u4e00\u76d2\u6b3e\u9879\uff0c\u91d1\u989d\uff1a\uffe5107.46\u5143\uff0c\u8bf7\u5ba1\u6279\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-21 13:13:22","updated_at":"2025-07-21 13:29:17","supplier_id":262,"purchase_contract_id":4041,"amount":"107.46","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2075,"comment":2},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7418,"approve_id":2075,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7419,"approve_id":2075,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7420,"approve_id":2075,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2688,"approve_id":2075,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-21 13:29:17","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2688,"approve_id":2075,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-21 13:29:17"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContract":{"id":4041,"key":4041,"name":"\u8ba2\u5355\u53f7\uff1a 326492438280","handler":1011,"cost_type":2,"erp_un_settle_amount":"107.46","created_at":"2025-07-16 15:45:43","amount":"107.46","serial_no":"\u8ba2\u5355\u53f7\uff1a 326492438280","purchaseContractPaymentCollectionRemindDates":[{"id":783,"key":783,"contract_id":4041,"name":"2025-07-18","value":"107.46","overdue_days":"","status":0}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[{"id":120452,"object_id":4041,"taxonomy_id":356,"term_id":18,"value":"","object_type":8,"extra_int":"307","in_amount":"","out_amount":"107.46","key":356,"name":"\u529e\u516c\u7528\u54c1","amount":"107.46","description":"","parent_id":"307","serial_no":"","taxonomy":{"id":356,"name":"\u529e\u516c\u7528\u54c1","parent_id":307,"parent":{"id":307,"name":"\u65e5\u5e38\u529e\u516c","parent_id":""}}}]},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2076,"client_id":"","project_id":"","title":"\u4ed8\u6b3e\u7533\u8bf7-\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-21 13:29:13","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6280\u672f\u90e8\u5149\u9a71\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5260.52\uff0c\u8bf7\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-21 13:15:01","updated_at":"2025-07-21 13:29:13","supplier_id":608,"purchase_contract_id":4042,"amount":"260.52","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2076,"comment":2},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7421,"approve_id":2076,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7422,"approve_id":2076,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7423,"approve_id":2076,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2689,"approve_id":2076,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-21 13:29:13","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2689,"approve_id":2076,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-21 13:29:13"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContract":{"id":4042,"key":4042,"name":"\u8ba2\u5355\u53f7: 4634557275452161702","handler":1011,"cost_type":2,"erp_un_settle_amount":"260.52","created_at":"2025-07-16 15:47:04","amount":"260.52","serial_no":"\u8ba2\u5355\u53f7: 4634557275452161702","purchaseContractPaymentCollectionRemindDates":[{"id":784,"key":784,"contract_id":4042,"name":"2025-07-18","value":"260.52","overdue_days":"","status":0}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[{"id":120779,"object_id":4042,"taxonomy_id":356,"term_id":18,"value":"\u6d4b\u8bd5","object_type":8,"extra_int":"307","in_amount":"","out_amount":"260.52","key":356,"name":"\u529e\u516c\u7528\u54c1","amount":"260.52","description":"\u6d4b\u8bd5","parent_id":"307","serial_no":"","taxonomy":{"id":356,"name":"\u529e\u516c\u7528\u54c1","parent_id":307,"parent":{"id":307,"name":"\u65e5\u5e38\u529e\u516c","parent_id":""}}}]},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2074,"client_id":2094,"project_id":3704,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-21 11:28:51","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6df1\u4fe1\u670d 3\u4e2a\u6d4b\u8bd5Ukey\u635f\u8017\u8d39\uff0c\u91d1\u989d\uffe5900\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u5f00\u6237\u94f6\u884c\uff1a\u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6df1\u5733\u9ad8\u65b0\u56ed\u79d1\u521b\u652f\u884c\n\u5e10\u6237\u540d\u79f0\uff1a\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\n\u5e10\u53f7\uff1a811980479210001\n\n\u5907\u6ce8\uff1a\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-21 11:28:35","updated_at":"2025-07-21 11:28:51","supplier_id":138,"purchase_contract_id":4051,"amount":"900","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"900","erp_payment_un_settle_amount":"-900","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2074,"comment":3},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7415,"approve_id":2074,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7416,"approve_id":2074,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7417,"approve_id":2074,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2687,"approve_id":2074,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-21 11:28:51","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2687,"approve_id":2074,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-21 11:28:51"},"attachmentRelationships":[],"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)"},"project":{"id":3704,"key":3704,"name":"\u5ba2\u6237\u81ea\u7528-\u6df1\u4fe1\u670d\u9632\u706b\u5899\uff0c\u8d1f\u8f7d\uff0c\u4ea4\u6362\u673a","buildContract":{"id":3649,"from_project":3704,"serial_no":"TS-ZHY-2024110401"}},"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4051,"key":4051,"name":"TSKJ20250721-HYF-001","handler":1011,"cost_type":1,"erp_un_settle_amount":"0","created_at":"2025-07-21 11:18:14","amount":"900.00","serial_no":"TSKJ20250721-HYF-001","purchaseContractPaymentCollectionRemindDates":[{"id":788,"key":788,"contract_id":4051,"name":"2025-07-21","value":"900","overdue_days":1,"status":1}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":35920,"object_type":29,"object_id":2074,"attachment_id":26983,"attachment":{"id":26983,"key":26983,"name":"b52e9511-8c71-37fc-a410-a106ebeee901","extension":"pdf","path":"\/vue\/attachment\/view\/b52e9511-8c71-37fc-a410-a106ebeee901\/2025_07_21_11_28_24.pdf","orig_name":"2025_07_21_11_28_24.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2073,"client_id":"","project_id":"","title":"\u6df1\u4fe1\u670d\u6d4b\u8bd5\u8bbe\u5907\u6d4b\u8f6c\u9500","status":2,"next_verify_user":"","verify_at":"2025-07-21 11:13:15","description":"\u6df1\u4fe1\u670d\u67093\u4e2akey\uff0c\u5ba2\u6237\u6d4b\u8bd5\u540e\u627e\u4e0d\u5230\u4e86\uff0c\u73b0\u5728\u9700\u8981\u628a\u6d4b\u8bd5\u8bbe\u5907\u8f6c\u9500\u552e\uff0c\u603b\u8ba1900\u5143\uff0c\u4ece\u738b\u660e\u4eae\u8d39\u7528\u4e2d\u652f\u51fa\u3002","refuse_description":"","is_resubmited":false,"created_by":1005,"created_at":"2025-07-21 11:11:26","updated_at":"2025-07-21 11:13:15","supplier_id":"","purchase_contract_id":"","amount":"900","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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"}},"commentCount":{"object_id":2073,"comment":2},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7409,"approve_id":2073,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":7410,"approve_id":2073,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7411,"approve_id":2073,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"approveVerifyRels":[{"id":2685,"approve_id":2073,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-21 11:13:15","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2685,"approve_id":2073,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-21 11:13:15"},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":{},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2062,"client_id":12,"project_id":3912,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u652f\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-18 14:52:47","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8SMC\u2014\u786c\u76d8\u3001\u5185\u5b58\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d457.75\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-07-18 12:05:46","updated_at":"2025-07-18 14:52:47","supplier_id":608,"purchase_contract_id":4023,"amount":"457.75","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"457.75","erp_payment_un_settle_amount":"-457.75","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2062,"comment":4},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7376,"approve_id":2062,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7377,"approve_id":2062,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"approveVerifyRels":[{"id":2671,"approve_id":2062,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-18 13:20:51","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachmentRelationships":[],"files":[]},{"id":2672,"approve_id":2062,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-18 14:52:47","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2671,"approve_id":2062,"user_id":1011,"status":1,"description":"","verify_at":"2025-07-18 13:20:51"},"attachmentRelationships":[],"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3912,"key":3912,"name":"OTJ25072858-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","buildContract":{"id":4021,"from_project":3912,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25072858"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContract":{"id":4023,"key":4023,"name":"\u8ba2\u5355\u53f7: 4625229891877592710\/4625146693309592710","handler":5360,"cost_type":1,"erp_un_settle_amount":"0","created_at":"2025-07-11 10:00:03","amount":"457.75","serial_no":"\u8ba2\u5355\u53f7: 4625229891877592710\/4625146693309592710","purchaseContractPaymentCollectionRemindDates":[{"id":768,"key":768,"contract_id":4023,"name":"2025-07-18","value":"457.75","overdue_days":3,"status":1}],"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":35832,"object_type":29,"object_id":2062,"attachment_id":26902,"attachment":{"id":26902,"key":26902,"name":"1104d1d5-160f-3cf7-a619-ec3b60806d40","extension":"jpg","path":"\/vue\/attachment\/view\/1104d1d5-160f-3cf7-a619-ec3b60806d40\/17241752811378_.pic.jpg","orig_name":"17241752811378_.pic.jpg"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2049,"client_id":1301,"project_id":3900,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-18 13:20:08","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u82f1\u7279\u5c14\u7f51\u5361\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5730\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-18 13:19:58","updated_at":"2025-07-18 13:20:08","supplier_id":608,"purchase_contract_id":4033,"amount":"730","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"730","erp_payment_un_settle_amount":"-730","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2049,"comment":3},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7378,"approve_id":2049,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7379,"approve_id":2049,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7380,"approve_id":2049,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2673,"approve_id":2049,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-18 13:20:08","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2673,"approve_id":2049,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-18 13:20:08"},"attachmentRelationships":[],"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"project":{"id":3900,"key":3900,"name":"2025\u5e74\u670d\u52a1\u5668\u7f51\u5361","buildContract":{"id":4027,"from_project":3900,"serial_no":"TS-WZW-20250709002"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContract":{"id":4033,"key":4033,"name":"\u8ba2\u5355\u53f7: 4632399036474161702","handler":1011,"cost_type":1,"erp_un_settle_amount":"0","created_at":"2025-07-15 11:01:15","amount":"730.00","serial_no":"\u8ba2\u5355\u53f7: 4632399036474161702","purchaseContractPaymentCollectionRemindDates":[{"id":774,"key":774,"contract_id":4033,"name":"2025-07-18","value":"730","overdue_days":10,"status":1}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"files":[{"id":35839,"object_type":29,"object_id":2049,"attachment_id":26847,"attachment":{"id":26847,"key":26847,"name":"37064238-5562-3f62-9135-3ac17e570f3a","extension":"pdf","path":"\/vue\/attachment\/view\/37064238-5562-3f62-9135-3ac17e570f3a\/2025_07_15_14_25_34.pdf","orig_name":"2025_07_15_14_25_34.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""}],"countArr":[{"key":"all","name":"\u5168\u90e8","count":495},{"key":1,"name":"\u5ba1\u6279\u4e2d","count":0},{"key":2,"name":"\u5df2\u901a\u8fc7","count":495},{"key":4,"name":"\u5df2\u62d2\u7edd","count":0}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":1},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":5}],"can_create":true,"pagenation":{"totalcount":495,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-04 13:23:00') RETURNING "id" |
13:23:00.738 | 3.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=37) AND ("visit_date"='2025-08-04') |
13:23:00.616 | 2.5 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
13:23:00.618 | 2.3 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
13:23:00.622 | 1.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
13:23:00.719 | 1.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id" IN (2671, 2672, 2673, 2685, 2687, 2688, 2689, 2695, 2696, 2709, 2710, 2711, 2712, 2713, 2715, 2716, 2719, 2720, 2721, 2726, 2728, 2730, 2731, 2733, 2738, 2739)) |
13:23:00.713 | 1.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049) |
13:23:00.734 | 1.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (26902, 26847, 26983, 27002, 27035, 27037, 27038, 27075, 27086, 27096, 27120, 27103) |
13:23:00.732 | 1.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049)) |
13:23:00.721 | 1.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id" IN (2671, 2672, 2673, 2685, 2687, 2688, 2689, 2695, 2696, 2709, 2710, 2711, 2712, 2713, 2715, 2716, 2719, 2720, 2721, 2726, 2728, 2730, 2731, 2733, 2738, 2739)) |
13:23:00.723 | 1.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049)) |
13:23:00.636 | 1.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM "a57be577deb434"."tbl_approves" WHERE ("next_verify_user"=1001) AND ("status" != 0) |
13:23:00.716 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049) |
13:23:00.627 | 0.9 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
13:23:00.727 | 0.9 ms | yii\db\Command::query | SELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3704, 3865, 3827, 3847, 3810, 3835, 3912, 3831, 3920, 3900, 3929, 3924, 3922, 3930) |
13:23:00.742 | 0.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=4, "last_visit_at"='now()' WHERE "id"=54925 |
13:23:00.729 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4072, 4070, 4042, 4062, 4052, 4059, 4066, 4067, 4051, 3940, 3928, 3927, 3963, 4041, 4069, 4023, 4045, 4033) ORDER BY "remind_date" |
13:23:00.718 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049) ORDER BY "id" |
13:23:00.730 | 0.6 ms | yii\db\Command::query | SELECT "pt".*, "taxonomy_id" AS "key", "tt"."name" AS "name", "out_amount" 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"=8) AND ("pt"."object_id" IN (4072, 4070, 4042, 4062, 4052, 4059, 4066, 4067, 4051, 3940, 3928, 3927, 3963, 4041, 4069, 4023, 4045, 4033)) ORDER BY "id" |
13:23:00.723 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049)) ORDER BY "id" |
13:23:00.715 | 0.6 ms | yii\db\Command::query | SELECT "id", "name", "approve_verify_user", "approve_carbon_copy_user" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (326, 155, 136, 133, 137, 135, 166, 140, 139, 156, 157, 165, 179, 175, 197, 194, 196, 204, 128, 173, 184, 189, 200, 131, 199, 205, 203, 129, 5, 130, 176, 164, 177, 153, 181, 212, 167, 174, 215, 210, 226, 213, 2, 1, 6, 172, 331, 340, 341, 349, 359, 374, 377, 2100000000)) |
13:23:00.728 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" AS "name", "handler", "cost_type", "erp_un_settle_amount", "created_at", "amount", "erp_un_settle_amount", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4072, 4069, 4070, 3963, 4066, 3940, 3928, 3927, 4052, 4067, 4045, 4062, 4059, 4041, 4042, 4051, 4023, 4033) |
13:23:00.726 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3930, 3922, 3831, 3929, 3847, 3827, 3924, 3810, 3920, 3865, 3835, 3704, 3912, 3900) |
13:23:00.674 | 0.4 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 (1011, 5252, 1005, 5360)) |
13:23:00.728 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 608, 138, 68, 90, 262, 236) |
13:23:00.722 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049)) ORDER BY "id" |
13:23:00.725 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=27143 |
13:23:00.675 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 6, 1) |
13:23:00.674 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5252, 1011, 5360, 1005) |
13:23:00.735 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049) |
13:23:00.726 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 2136, 2205, 1181, 1663, 1492, 2177, 1301, 2094) |
13:23:00.717 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1013, 5360, 1011, 1001) |
13:23:00.718 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1001, 5252) |
13:23:00.730 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360) |
13:23:00.731 | 0.2 ms | yii\db\Command::query | SELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=356 |
13:23:00.717 | 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 (1011, 1001, 5388, 1013, 5360)) |
13:23:00.736 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2105, 2103, 2097, 2101, 2090, 2094, 2098, 2099, 2100, 2088, 2093, 2087, 2086, 2080, 2075, 2076, 2074, 2073, 2062, 2049) |
13:23:00.719 | 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 (1011, 1001, 5252)) |
13:23:00.732 | 0.2 ms | yii\db\Command::query | SELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=307 |