685fbf2f6e1c3: POST https://beta.jinchangxiao.com/v2/approve/of-client at 2025-06-28 06:08:47 pm by 211.137.80.11
Database Queries
总计31条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 18:08:47.456 | 4.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u' |
| 18:08:47.462 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 18:08:47.465 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='3304') AND ("deleted"=FALSE) |
| 18:08:47.470 | 1.7 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
| 18:08:47.472 | 4.0 ms | SELECT | 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 ("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, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("rccr"."user_id"=1000) OR ("rvr"."user_id"=1000)) AND ("r"."client_id"='3304') GROUP BY "r"."id" ORDER BY "r"."status", "r"."created_at" DESC) "c" |
| 18:08:47.477 | 2.4 ms | SELECT | 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 ("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, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("rccr"."user_id"=1000) OR ("rvr"."user_id"=1000)) AND ("r"."client_id"='3304') GROUP BY "r"."id" ORDER BY "r"."status", "r"."created_at" DESC LIMIT 20 |
| 18:08:47.480 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5360, 1011) |
| 18:08:47.481 | 0.6 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5360)) |
| 18:08:47.482 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3 |
| 18:08:47.483 | 24.2 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id" IN (1671, 1594, 1371, 1312)) GROUP BY "object_id" |
| 18:08:47.507 | 19.1 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=37) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (1671, 1594, 1371, 1312)) GROUP BY "object_id" |
| 18:08:47.526 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1671, 1594, 1371, 1312) |
| 18:08:47.528 | 0.7 ms | SELECT | SELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (97, 205, 204, 164, 131, 181, 46, 197, 194, 136, 137, 139, 2, 196, 5, 154, 153, 203, 167, 165, 179, 232, 142, 231, 207, 229, 1, 224, 223, 214, 8, 219, 9, 208, 210, 211, 226, 227, 7, 216, 6, 93, 228, 11, 209, 94, 217, 230, 218, 10, 213, 221, 225, 215, 222, 212, 319, 2100000000, 326, 340, 341, 359)) |
| 18:08:47.529 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id" IN (1671, 1594, 1371, 1312) |
| 18:08:47.530 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1013, 5360, 5252, 5413) |
| 18:08:47.530 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5252, 5413, 5388, 1013, 5360)) |
| 18:08:47.531 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id" IN (1671, 1594, 1371, 1312) ORDER BY "id" |
| 18:08:47.532 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011) |
| 18:08:47.532 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1011)) |
| 18:08:47.532 | 2.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id" IN (1696, 1770, 2046, 2148, 2149)) |
| 18:08:47.535 | 2.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id" IN (1696, 1770, 2046, 2148, 2149)) |
| 18:08:47.537 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (1671, 1594, 1371, 1312)) ORDER BY "id" |
| 18:08:47.538 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (1671, 1594, 1371, 1312)) ORDER BY "id" |
| 18:08:47.538 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id" IN (1671, 1594, 1371, 1312)) |
| 18:08:47.541 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3304 |
| 18:08:47.541 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3723, 3661) |
| 18:08:47.542 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 46) |
| 18:08:47.542 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3704, 3610) |
| 18:08:47.543 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id" IN (1671, 1594, 1371, 1312)) |
| 18:08:47.545 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23799, 24343) |
| 18:08:47.547 | 2.0 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/approve/of-client', '{"access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"2","id":"3304","posttime":"1751105280","token":"1014e4ee3f405178161751a95a162740","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":1671,"client_id":3304,"project_id":3723,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-03 10:24:33","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u6708\u521d\u79d1\u6280\u2014PA\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d291807\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf73\u67084\u65e5\uff08\u5468\u4e8c\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-03-03 09:20:51","updated_at":"2025-03-03 10:24:33","supplier_id":90,"purchase_contract_id":3704,"amount":"291807","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","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":1671,"comment":4},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":6060,"approve_id":1671,"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":6061,"approve_id":1671,"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":2148,"approve_id":1671,"user_id":1011,"status":1,"description":"","verify_at":"2025-03-03 10:24:13","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":2149,"approve_id":1671,"user_id":1001,"status":1,"description":"","verify_at":"2025-03-03 10:24: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":2148,"approve_id":1671,"user_id":1011,"status":1,"description":"","verify_at":"2025-03-03 10:24:13"},"attachmentRelationships":[],"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3723,"key":3723,"name":"PAN-M-300\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":3704,"key":3704,"name":"X_2024SBQ32972"},"files":[{"id":32597,"object_type":29,"object_id":1671,"attachment_id":24343,"attachment":{"id":24343,"key":24343,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/03\/a7dd9ef0-ff1d-33de-b78c-b9b556ea34a6.jpg","extension":"jpg","orig_name":"13031740964407_.pic_hd.jpg"}}],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","can_borrow":false,"borrow_expire_day":""},{"id":1594,"client_id":3304,"project_id":3723,"title":"\u5f00\u53d1\u7968-\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-01-17 15:17:10","description":"\u7b11\u7b11\uff0c\u6309\u7167\u7528\u6237\u5408\u540c\u5f00\u5177\u5373\u53ef\u3002\n\n*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1* PALO ALTO\u670d\u52a1\u5668 PAN-M-300\n*\u8f6f\u4ef6*PALO ALTO\u8bb8\u53ef PAN-M-300-P-25\n*\u8f6f\u4ef6*PALO ALTO\u8bb8\u53ef PAN-SVC-BKLN-M-300-P-25-3Y\n","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-01-17 15:17:03","updated_at":"2025-01-17 15:17:10","supplier_id":90,"purchase_contract_id":3704,"amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","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":1594,"comment":2},"unreadComments":{},"type":{"id":319,"name":"\u6b63\u5e38\u5f00\u7968"},"approveCarbonCopyRels":[{"id":5801,"approve_id":1594,"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"}}},{"id":5802,"approve_id":1594,"user_id":5252,"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"}}},{"id":5803,"approve_id":1594,"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":5804,"approve_id":1594,"user_id":5413,"user":{"id":5413,"key":5413,"name":"\u8096\u6167\u4e3d","sex":"F","avatar":{"id":159,"user_id":5413,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ca02da0e-7d82-3904-be85-f050ca37c3c5.jpg"}}}],"approveVerifyRels":[{"id":2046,"approve_id":1594,"user_id":1011,"status":1,"description":"","verify_at":"2025-01-17 15:17:10","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":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2046,"approve_id":1594,"user_id":1011,"status":1,"description":"","verify_at":"2025-01-17 15:17:10"},"attachmentRelationships":[],"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3723,"key":3723,"name":"PAN-M-300\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":3704,"key":3704,"name":"X_2024SBQ32972"},"files":[{"id":31907,"object_type":29,"object_id":1594,"attachment_id":23799,"attachment":{"id":23799,"key":23799,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/01\/45abe503-c42a-30ff-9c60-8a9082929beb.jpg","extension":"jpg","orig_name":"2731737096504_.pic.jpg"}}],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","can_borrow":false,"borrow_expire_day":""},{"id":1371,"client_id":3304,"project_id":3661,"title":"\u5f00\u53d1\u7968-\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-11-04 11:25:46","description":"\u7b11\u7b11\uff0c\u5e2e\u5f00\u5177\u4e00\u4e0b\u53d1\u7968\uff1b\n\n\u5185\u5bb9\uff1a*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PAN-PA-440\u9632\u706b\u5899 Palo Alto Networks 4\u5957\uff1b\n\u5907\u6ce8\uff1a\u5305\u542b\u4e09\u5e74\u8f6f\u4ef6\u6388\u6743\u548c\u7535\u6e90\u7b49\u4ea7\u54c1\n\n\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8 \n\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a 91110111MA01RP4H80 \n\u5730\u5740\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u623f\u5c71\u533a\u62f1\u8fb0\u8857\u9053\u6708\u534e\u5927\u88571\u53f7A8-667 13717705170 \n\u5f00\u6237\u94f6\u884c\u53ca\u5e10\u53f7\uff1a \u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5174\u5b9c\u652f\u884c 0200 3014 0910 0054 430","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2024-11-04 11:25:39","updated_at":"2024-11-04 11:25:46","supplier_id":46,"purchase_contract_id":3610,"amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","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":1371,"comment":2},"unreadComments":{},"type":{"id":319,"name":"\u6b63\u5e38\u5f00\u7968"},"approveCarbonCopyRels":[{"id":4923,"approve_id":1371,"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"}}},{"id":4924,"approve_id":1371,"user_id":5252,"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"}}},{"id":4925,"approve_id":1371,"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":4926,"approve_id":1371,"user_id":5413,"user":{"id":5413,"key":5413,"name":"\u8096\u6167\u4e3d","sex":"F","avatar":{"id":159,"user_id":5413,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ca02da0e-7d82-3904-be85-f050ca37c3c5.jpg"}}}],"approveVerifyRels":[{"id":1770,"approve_id":1371,"user_id":1011,"status":1,"description":"","verify_at":"2024-11-04 11:25:46","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":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":1770,"approve_id":1371,"user_id":1011,"status":1,"description":"","verify_at":"2024-11-04 11:25:46"},"attachmentRelationships":[],"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3661,"key":3661,"name":"4\u53f0 PA440\u5957\u5305\u4ea7\u54c1\u91c7\u8d2d\u9879\u76ee"},"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":3610,"key":3610,"name":"DZ202409201129580"},"files":[],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","can_borrow":false,"borrow_expire_day":""},{"id":1312,"client_id":3304,"project_id":3661,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5f00\u5ef6\u652f-\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-10-21 13:03:12","description":"Tristen\uff0c\u7533\u8bf7\u4eca\u5929\u5f00\u5177\u4e00\u5f2055\u5929\u7684\u5ef6\u652f\uff0c\u91d1\u989d\uff1a\uffe5132320\uff0c\u65e5\u671f\uff1a2024\u5e7412\u670816\u65e5\u3002\u7528\u4e8e\u63d0\u8d27\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2024-10-21 12:51:05","updated_at":"2024-10-21 13:03:12","supplier_id":46,"purchase_contract_id":3610,"amount":"132320","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","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":1312,"comment":3},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":4692,"approve_id":1312,"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":4693,"approve_id":1312,"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":4694,"approve_id":1312,"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":1696,"approve_id":1312,"user_id":1001,"status":1,"description":"","verify_at":"2024-10-21 13:03:12","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":1696,"approve_id":1312,"user_id":1001,"status":1,"description":"","verify_at":"2024-10-21 13:03:12"},"attachmentRelationships":[],"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3661,"key":3661,"name":"4\u53f0 PA440\u5957\u5305\u4ea7\u54c1\u91c7\u8d2d\u9879\u76ee"},"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":3610,"key":3610,"name":"DZ202409201129580"},"files":[],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","can_borrow":false,"borrow_expire_day":""}],"can_create":true,"pagenation":{"totalcount":4,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-28 18:08:47') RETURNING "id" |