Database Queries

总计34条数据
TimeDurationTypeQuery
  
10:18:31.9096.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA'

10:18:31.9171.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

10:18:31.9325.2 msSELECTSELECT COUNT(*) FROM (SELECT c.* FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE (("client"."sales_rep" IN (5295, 5311)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295)) OR ("pcr"."id" IS NULL)) AND ("pcr"."client_id"='90') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"

10:18:31.9373.3 msSELECTSELECT c.* FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE (("client"."sales_rep" IN (5295, 5311)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295)) OR ("pcr"."id" IS NULL)) AND ("pcr"."client_id"='90') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10

10:18:31.9420.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (262, 165, 489, 659, 298, 671, 608)

10:18:31.9420.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011

10:18:31.9430.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)

10:18:31.9430.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3

10:18:31.9440.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011

10:18:31.9440.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)

10:18:31.94421.7 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288)) GROUP BY "object_id"

10:18:31.9660.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288) ORDER BY "id"

10:18:31.9670.3 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (90, 57, 1492)

10:18:31.9670.5 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3446, 3567, 3677, 3731, 3431)

10:18:31.9683.4 msSELECTSELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "collected_date", "created_at", "created_by", "description" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) )) "sub") "r" WHERE "contract_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288) ORDER BY "id" DESC

10:18:31.9720.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013

10:18:31.9720.8 msSELECTSELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288) ORDER BY "id"

10:18:31.9762.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (1750, 1751, 1786, 1999, 2020, 2030, 2081, 2100, 2172, 2249, 2250, 2251, 2252, 2253, 2254, 2255, 2265, 2266, 2267, 2277, 2278, 2279))

10:18:31.9791.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (1750, 1751, 1786, 1999, 2020, 2030, 2081, 2100, 2172, 2249, 2250, 2251, 2252, 2253, 2254, 2255, 2265, 2266, 2267, 2277, 2278, 2279))

10:18:31.9810.5 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22640, 22797, 22376, 19700, 19703, 19704, 19705, 20174, 23343, 23612, 24514, 25870, 25871, 25876, 25874, 25873, 25872, 25875, 25896, 25898, 25897, 25931, 25933, 25932)

10:18:31.9821.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288))

10:18:31.9830.2 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22735, 22218, 19095, 19699, 19701, 23364, 23614, 25851, 25852, 25853, 25854, 25855)

10:18:31.9831.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288))

10:18:31.9850.2 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22348, 23335, 23615)

10:18:31.9850.4 msSELECTSELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288)

10:18:31.9860.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)

10:18:31.9860.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5360))

10:18:31.9860.4 msSELECTSELECT "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 (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288) ORDER BY "remind_date"

10:18:31.9871.8 msSELECTSELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) AND ("r"."purchase_contract_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288)) GROUP BY "r"."id"

10:18:31.9890.7 msSELECTSELECT "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 (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288)) ORDER BY "id"

10:18:31.99016.9 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288)) GROUP BY "object_id"

10:18:32.0070.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288)

10:18:32.0080.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (3938, 3827, 3688, 3718, 3667, 3643, 3599, 3352, 3351, 3288)

10:18:32.0112.8 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1146, 'v2/purchase-contract/of-client', '{"access_token":"qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA","device_type":"2","id":"90","page":"1","posttime":"1754619520","token":"d183ecdc572571f36262181d793cf986","version_code":"1146"}', '{"code":200,"data":{"list":[{"id":3938,"supplier_id":262,"contract_type":1,"signed_at":"2025-05-28","amount":"4002.84","handler":1011,"description":"\u7aef\u5348\u8282\u793c\u54c1","contract_scan":null,"created_by":1011,"created_at":"2025-05-29 11:30:33","updated_at":"2025-05-29 11:31:40","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"\u8ba2\u5355\u53f7\uff1a 318600351430","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-05-29 11:30:45","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"4002.84","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contractScan":null,"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"}},"handlerPerson":{"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"}},"commentCount":{"object_id":3938,"comment":5},"purchaseClientRels":[{"id":3333,"contract_id":3938,"client_id":90,"project_id":3731,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"clickable":1},"project":{"id":3731,"key":3731,"name":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1382","key":"1382","contract_id":3938,"value":"4002.84","collected_date":"2025-05-30 15:15:27","created_at":"2025-05-30 15:15:27","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2249,"key":2249,"contract_id":3938,"amount":"166.22","value":"166.22","attachment_id":null,"from_date":"2025-05-28","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":34483,"object_type":103,"object_id":2249,"attachment_id":25870,"attachment":{"id":25870,"key":25870,"name":"c31a634b-f286-3c38-8494-42ed30f654e1","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/c31a634b-f286-3c38-8494-42ed30f654e1\/166.22-1.pdf","orig_name":"166.22-1.pdf"}}]},{"id":2250,"key":2250,"contract_id":3938,"amount":"166.22","value":"166.22","attachment_id":null,"from_date":"2025-05-28","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":34484,"object_type":103,"object_id":2250,"attachment_id":25871,"attachment":{"id":25871,"key":25871,"name":"62015c56-8ab8-34d6-bac2-dbb6149d514e","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/62015c56-8ab8-34d6-bac2-dbb6149d514e\/166.22-2.pdf","orig_name":"166.22-2.pdf"}}]},{"id":2251,"key":2251,"contract_id":3938,"amount":"166.22","value":"166.22","attachment_id":null,"from_date":"2025-05-29","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34494,"object_type":103,"object_id":2251,"attachment_id":25872,"attachment":{"id":25872,"key":25872,"name":"87e6c2cc-2cd5-3ae9-ade6-5244dcd32f59","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/87e6c2cc-2cd5-3ae9-ade6-5244dcd32f59\/166.22-3.pdf","orig_name":"166.22-3.pdf"}}]},{"id":2252,"key":2252,"contract_id":3938,"amount":"166.22","value":"166.22","attachment_id":null,"from_date":"2025-05-29","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34493,"object_type":103,"object_id":2252,"attachment_id":25873,"attachment":{"id":25873,"key":25873,"name":"6dbf2669-6f4d-39d7-9e7d-c3738f719f30","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/6dbf2669-6f4d-39d7-9e7d-c3738f719f30\/166.22-4.pdf","orig_name":"166.22-4.pdf"}}]},{"id":2253,"key":2253,"contract_id":3938,"amount":"849.42","value":"849.42","attachment_id":null,"from_date":"2025-05-29","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34492,"object_type":103,"object_id":2253,"attachment_id":25874,"attachment":{"id":25874,"key":25874,"name":"651ebdf3-3cf9-39cc-b73d-716fa7fd7564","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/651ebdf3-3cf9-39cc-b73d-716fa7fd7564\/849.42.pdf","orig_name":"849.42.pdf"}}]},{"id":2254,"key":2254,"contract_id":3938,"amount":"176.22","value":"176.22","attachment_id":null,"from_date":"2025-05-29","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34502,"object_type":103,"object_id":2254,"attachment_id":25875,"attachment":{"id":25875,"key":25875,"name":"16156de2-c0f5-37f9-b79e-6ac484170526","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/16156de2-c0f5-37f9-b79e-6ac484170526\/176.22-2.pdf","orig_name":"176.22-2.pdf"}}]},{"id":2255,"key":2255,"contract_id":3938,"amount":"176.22","value":"176.22","attachment_id":null,"from_date":"2025-05-29","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34490,"object_type":103,"object_id":2255,"attachment_id":25876,"attachment":{"id":25876,"key":25876,"name":"c4905003-e4ee-3ae9-b852-13bd1a211fbe","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/c4905003-e4ee-3ae9-b852-13bd1a211fbe\/176.22.pdf","orig_name":"176.22.pdf"}}]},{"id":2265,"key":2265,"contract_id":3938,"amount":"166.22","value":"166.22","attachment_id":null,"from_date":"2025-05-30","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34522,"object_type":103,"object_id":2265,"attachment_id":25896,"attachment":{"id":25896,"key":25896,"name":"84d24ac1-6993-3006-9a18-7889f9adfcb3","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/84d24ac1-6993-3006-9a18-7889f9adfcb3\/digital_25117000000746285321.pdf","orig_name":"digital_25117000000746285321.pdf"}}]},{"id":2266,"key":2266,"contract_id":3938,"amount":"166.22","value":"166.22","attachment_id":null,"from_date":"2025-05-29","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34525,"object_type":103,"object_id":2266,"attachment_id":25897,"attachment":{"id":25897,"key":25897,"name":"15264dc4-79c4-345d-8df2-ccae25a1fabc","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/15264dc4-79c4-345d-8df2-ccae25a1fabc\/digital_25117000000741614238.pdf","orig_name":"digital_25117000000741614238.pdf"}}]},{"id":2267,"key":2267,"contract_id":3938,"amount":"166.22","value":"166.22","attachment_id":null,"from_date":"2025-05-29","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34523,"object_type":103,"object_id":2267,"attachment_id":25898,"attachment":{"id":25898,"key":25898,"name":"4d43f77a-3c70-3a50-af31-5c609f18dd94","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/4d43f77a-3c70-3a50-af31-5c609f18dd94\/digital_25117000000741614261.pdf","orig_name":"digital_25117000000741614261.pdf"}}]},{"id":2277,"key":2277,"contract_id":3938,"amount":"1305","value":"1305","attachment_id":null,"from_date":"2025-05-30","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34573,"object_type":103,"object_id":2277,"attachment_id":25931,"attachment":{"id":25931,"key":25931,"name":"c5308680-815e-346f-9059-1292a6795abb","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/c5308680-815e-346f-9059-1292a6795abb\/dzfp_25112000000111403042_\u5317\u4eac\u521b\u4eab\u4e92\u8054\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8_20250530170213.pdf","orig_name":"dzfp_25112000000111403042_\u5317\u4eac\u521b\u4eab\u4e92\u8054\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8_20250530170213.pdf"}}]},{"id":2278,"key":2278,"contract_id":3938,"amount":"166.22","value":"166.22","attachment_id":null,"from_date":"2025-05-29","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34577,"object_type":103,"object_id":2278,"attachment_id":25932,"attachment":{"id":25932,"key":25932,"name":"2e1aec43-b4b2-3515-afb2-bf32d511f640","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/2e1aec43-b4b2-3515-afb2-bf32d511f640\/digital_25117000000740880222.pdf","orig_name":"digital_25117000000740880222.pdf"}}]},{"id":2279,"key":2279,"contract_id":3938,"amount":"166.22","value":"166.22","attachment_id":null,"from_date":"2025-05-29","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":34576,"object_type":103,"object_id":2279,"attachment_id":25933,"attachment":{"id":25933,"key":25933,"name":"06017a27-8b76-3985-b0cf-3ead0d4fece6","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/06017a27-8b76-3985-b0cf-3ead0d4fece6\/digital_25117000000740223389.pdf","orig_name":"digital_25117000000740223389.pdf"}}]}],"contractScans":[{"id":34459,"object_type":108,"object_id":3938,"attachment_id":25851,"attachment":{"id":25851,"key":25851,"name":"23f6f855-4a3b-3fd2-83b0-9ae8187cf4e0","extension":"png","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/23f6f855-4a3b-3fd2-83b0-9ae8187cf4e0\/image.png","orig_name":"image.png"}},{"id":34460,"object_type":108,"object_id":3938,"attachment_id":25852,"attachment":{"id":25852,"key":25852,"name":"0fba942c-8277-3165-b3c7-3c6b79bd7751","extension":"png","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/0fba942c-8277-3165-b3c7-3c6b79bd7751\/image.png","orig_name":"image.png"}},{"id":34461,"object_type":108,"object_id":3938,"attachment_id":25853,"attachment":{"id":25853,"key":25853,"name":"7499a8bc-8fc0-36b7-ae92-12a0a95c4d1a","extension":"png","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/7499a8bc-8fc0-36b7-ae92-12a0a95c4d1a\/image.png","orig_name":"image.png"}},{"id":34462,"object_type":108,"object_id":3938,"attachment_id":25854,"attachment":{"id":25854,"key":25854,"name":"26bd95ff-b068-3edc-9b23-45e2d7fbc3f2","extension":"png","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/26bd95ff-b068-3edc-9b23-45e2d7fbc3f2\/image.png","orig_name":"image.png"}},{"id":34463,"object_type":108,"object_id":3938,"attachment_id":25855,"attachment":{"id":25855,"key":25855,"name":"eea26beb-937d-3ada-bd9f-3b4d9ac56f98","extension":"png","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/eea26beb-937d-3ada-bd9f-3b4d9ac56f98\/image.png","orig_name":"image.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1161,"user_id":1011,"key":1011,"contract_id":3938,"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":1162,"user_id":5360,"key":5360,"contract_id":3938,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":696,"key":696,"contract_id":3938,"name":"2025-05-30","value":"4002.84","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1916,"client_id":90,"project_id":3731,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce(\u4e2a\u4eba\u5df2\u57ab\u4ed8)","status":2,"next_verify_user":null,"verify_at":"2025-05-30 10:22:16","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6cfd\u6587\u7aef\u5348\u793c\u54c1\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe54002.84.\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838~","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-05-30 10:10:56","updated_at":"2025-05-30 10:22:16","supplier_id":262,"purchase_contract_id":3938,"amount":"4002.84","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"4002.84","erp_payment_un_settle_amount":"-4002.84","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":4002.84,"approve_amount":4002.84,"un_approve_amount":0,"un_invoiced":9.0949470177293e-13,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"4002.84","un_collected":0,"collected_plan":4002.84,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3827,"supplier_id":165,"contract_type":1,"signed_at":"2025-02-13","amount":"600.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-03-12 11:46:49","updated_at":"2025-03-12 11:46:58","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"20250213","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-12 11:46:58","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"600","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"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"}},"handlerPerson":{"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"}},"commentCount":{"object_id":3827,"comment":4},"purchaseClientRels":[{"id":3092,"contract_id":3827,"client_id":90,"project_id":3731,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"clickable":1},"project":{"id":3731,"key":3731,"name":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1339","key":"1339","contract_id":3827,"value":"600.00","collected_date":"2025-03-14 11:40:00","created_at":"2025-03-14 11:40:00","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2172,"key":2172,"contract_id":3827,"amount":"600","value":"600","attachment_id":null,"from_date":"2025-03-12","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32848,"object_type":103,"object_id":2172,"attachment_id":24514,"attachment":{"id":24514,"key":24514,"name":"4201c92a-de99-3485-9055-280034ec574e","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/4201c92a-de99-3485-9055-280034ec574e\/dzfp_25112000000035848744_\u4eac\u4e1c\u4e91\u8ba1\u7b97\u6709\u9650\u516c\u53f8_20250224161012.pdf","orig_name":"dzfp_25112000000035848744_\u4eac\u4e1c\u4e91\u8ba1\u7b97\u6709\u9650\u516c\u53f8_20250224161012.pdf"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1007,"user_id":1011,"key":1011,"contract_id":3827,"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":1008,"user_id":5360,"key":5360,"contract_id":3827,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":618,"key":618,"contract_id":3827,"name":"2025-03-13","value":"600","overdue_days":1,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1711,"client_id":90,"project_id":3731,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-03-12 23:29:09","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u82cf\u9ece\u4e16\u2014\u5b58\u50a8\u552e\u540e\u786c\u76d8\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d600\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2025-03-12 13:39:55","updated_at":"2025-03-12 23:29:09","supplier_id":165,"purchase_contract_id":3827,"amount":"600","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"600","erp_payment_un_settle_amount":"-600","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":600,"approve_amount":600,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"600","un_collected":0,"collected_plan":600,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3688,"supplier_id":489,"contract_type":1,"signed_at":"2025-01-09","amount":"9500.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-12-03 17:46:01","updated_at":"2025-01-09 16:25:40","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20241203-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-09 13:56:04","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"9500","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"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"}},"handlerPerson":{"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"}},"commentCount":{"object_id":3688,"comment":6},"purchaseClientRels":[{"id":2922,"contract_id":3688,"client_id":90,"project_id":3731,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"clickable":1},"project":{"id":3731,"key":3731,"name":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd","project_status":3,"clickable":1}},{"id":2923,"contract_id":3688,"client_id":1492,"project_id":3431,"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)","sales_rep":1005,"clickable":0,"msg":"\u60a8\u65e0\u6743\u8bbf\u95ee\u6b64\u5ba2\u6237"},"project":{"id":3431,"key":3431,"name":"2024\u5e74\u5b58\u50a8\u7ef4\u4fdd\u670d\u52a1","project_status":3,"clickable":0,"msg":"\u60a8\u65e0\u6743\u8bbf\u95ee\u6b64\u5546\u673a"}}],"purchaseContractPayments":[{"id":"1292","key":"1292","contract_id":3688,"value":"9500.00","collected_date":"2025-01-22 15:30:34","created_at":"2025-01-22 15:30:34","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2100,"key":2100,"contract_id":3688,"amount":"9500","value":"9500","attachment_id":null,"from_date":"2025-01-09","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31664,"object_type":103,"object_id":2100,"attachment_id":23612,"attachment":{"id":23612,"key":23612,"name":"6e7de63f-7448-325c-a372-3d52fd5e77f2","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/6e7de63f-7448-325c-a372-3d52fd5e77f2\/dzfp_25112000000007271322_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250109155338.pdf","orig_name":"dzfp_25112000000007271322_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250109155338.pdf"}}]}],"contractScans":[{"id":31665,"object_type":108,"object_id":3688,"attachment_id":23614,"attachment":{"id":23614,"key":23614,"name":"2fa1457a-ebf8-3038-b909-101941071210","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/2fa1457a-ebf8-3038-b909-101941071210\/2025_01_09_16_23_32 2.pdf","orig_name":"2025_01_09_16_23_32 2.pdf"}}],"receiptScans":[{"id":31666,"object_type":111,"object_id":3688,"attachment_id":23615,"attachment":{"id":23615,"key":23615,"name":"b1a00221-f9f5-3fd3-84ae-c772f3f82b7a","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/b1a00221-f9f5-3fd3-84ae-c772f3f82b7a\/2025_01_09_16_23_32.pdf","orig_name":"2025_01_09_16_23_32.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":885,"user_id":1011,"key":1011,"contract_id":3688,"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":886,"user_id":5360,"key":5360,"contract_id":3688,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":547,"key":547,"contract_id":3688,"name":"2025-01-17","value":"9500","overdue_days":5,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1584,"client_id":1492,"project_id":3431,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-01-14 14:40:49","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u8d1d\u745e-\u5b58\u50a8\u552e\u540e\u786c\u76d8\u91c7\u8d2d\u8d27\u6b3e8700\u5143\uff0c\u82cf\u9ece\u4e16-\u5b58\u50a8\u786c\u76d8\u91c7\u8d2d\u8d27\u6b3e800\u5143\uff0c\u5171\u8ba19500\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2025-01-14 13:38:46","updated_at":"2025-01-14 14:40:49","supplier_id":489,"purchase_contract_id":3688,"amount":"9500","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"9500","erp_payment_un_settle_amount":"-9500","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":9500,"approve_amount":9500,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"9500","un_collected":0,"collected_plan":9500,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3718,"supplier_id":659,"contract_type":1,"signed_at":"2024-12-18","amount":"51199.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-12-18 14:20:03","updated_at":"2024-12-24 12:01:53","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"XM2024121700120","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-18 14:20:28","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"51199","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"contractScan":null,"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"}},"handlerPerson":{"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"}},"commentCount":{"object_id":3718,"comment":4},"purchaseClientRels":[{"id":2902,"contract_id":3718,"client_id":90,"project_id":3731,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"clickable":1},"project":{"id":3731,"key":3731,"name":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1286","key":"1286","contract_id":3718,"value":"51199.00","collected_date":"2025-01-24 09:38:04","created_at":"2025-01-24 09:38:04","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2081,"key":2081,"contract_id":3718,"amount":"51199","value":"51199","attachment_id":null,"from_date":"2024-12-20","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31263,"object_type":103,"object_id":2081,"attachment_id":23343,"attachment":{"id":23343,"key":23343,"name":"71148f9d-c2fe-3863-a359-9f1771bde636","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/71148f9d-c2fe-3863-a359-9f1771bde636\/dzfp_24112000000217393726_\u4f73\u6770\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8_20241223092739.pdf","orig_name":"dzfp_24112000000217393726_\u4f73\u6770\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8_20241223092739.pdf"}}]}],"contractScans":[{"id":31288,"object_type":108,"object_id":3718,"attachment_id":23364,"attachment":{"id":23364,"key":23364,"name":"f87d784a-dff3-3aa8-8582-c949e83b8ff6","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/f87d784a-dff3-3aa8-8582-c949e83b8ff6\/2024_12_24_11_10_01\uff08\u88ab\u62d6\u79fb\uff09.pdf","orig_name":"2024_12_24_11_10_01\uff08\u88ab\u62d6\u79fb\uff09.pdf"}}],"receiptScans":[{"id":31251,"object_type":111,"object_id":3718,"attachment_id":23335,"attachment":{"id":23335,"key":23335,"name":"1af776e2-5502-3ee0-a338-57f08ae735d1","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/1af776e2-5502-3ee0-a338-57f08ae735d1\/\u4f1f\u4ed5\u4f73\u6770\u8d27\u7269\u7b7e\u6536\u5355[1].pdf","orig_name":"\u4f1f\u4ed5\u4f73\u6770\u8d27\u7269\u7b7e\u6536\u5355[1].pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":837,"user_id":1011,"key":1011,"contract_id":3718,"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":838,"user_id":5360,"key":5360,"contract_id":3718,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":519,"key":519,"contract_id":3718,"name":"2025-01-23","value":"51199","overdue_days":1,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1604,"client_id":90,"project_id":3731,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-01-21 10:51:50","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u82cf\u9ece\u4e16-veeam\u7eed\u4fdd\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d51199\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2025-01-21 10:50:59","updated_at":"2025-01-21 10:51:50","supplier_id":659,"purchase_contract_id":3718,"amount":"51199","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"51199","erp_payment_un_settle_amount":"-51199","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":51199,"approve_amount":51199,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"51199","un_collected":0,"collected_plan":51199,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3667,"supplier_id":262,"contract_type":1,"signed_at":"2024-11-18","amount":"75.57","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-11-18 11:45:14","updated_at":"2024-11-18 11:45:25","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"305882210752","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-11-18 11:45:25","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"75.57","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contractScan":null,"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"}},"handlerPerson":{"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"}},"commentCount":{"object_id":3667,"comment":3},"purchaseClientRels":[{"id":2778,"contract_id":3667,"client_id":90,"project_id":3677,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"clickable":1},"project":{"id":3677,"key":3677,"name":"\u65b0\u8d2d\u6234\u5c14\u5b58\u50a8","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1236","key":"1236","contract_id":3667,"value":"75.57","collected_date":"2024-11-22 15:46:38","created_at":"2024-11-22 15:46:38","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2030,"key":2030,"contract_id":3667,"amount":"75.57","value":"75.57","attachment_id":null,"from_date":"2024-11-18","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":30621,"object_type":103,"object_id":2030,"attachment_id":22797,"attachment":{"id":22797,"key":22797,"name":"f242c8e8-aec9-34c8-be3c-94d6d3e844eb","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/f242c8e8-aec9-34c8-be3c-94d6d3e844eb\/75.57-\u5149\u7ea4\u7ebf.pdf","orig_name":"75.57-\u5149\u7ea4\u7ebf.pdf"}}]}],"contractScans":[{"id":30451,"object_type":108,"object_id":3667,"attachment_id":22735,"attachment":{"id":22735,"key":22735,"name":"b6d81d34-d3ce-3c30-86fa-d8189951f162","extension":"jpg","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/b6d81d34-d3ce-3c30-86fa-d8189951f162\/40411731901508_.pic.jpg","orig_name":"40411731901508_.pic.jpg"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":757,"user_id":1011,"key":1011,"contract_id":3667,"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":758,"user_id":5360,"key":5360,"contract_id":3667,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":469,"key":469,"contract_id":3667,"name":"2024-11-22","value":"75.57","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1409,"client_id":90,"project_id":3677,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":null,"verify_at":"2024-11-19 09:14:01","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u9879\u76ee\u6240\u9700\u7ebf\u7f06\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe575.57\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2024-11-19 09:12:25","updated_at":"2024-11-19 09:14:01","supplier_id":262,"purchase_contract_id":3667,"amount":"75.57","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"75.57","erp_payment_un_settle_amount":"-75.57","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":75.57,"approve_amount":75.57,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"75.57","un_collected":0,"collected_plan":75.57,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3643,"supplier_id":298,"contract_type":1,"signed_at":"2024-11-01","amount":"214.40","handler":1011,"description":"\u8d60\u90014\u676110M\u5149\u7ea4\u7ebf\uff0c2\u68395M\u7f51\u7ebf","contract_scan":null,"created_by":1011,"created_at":"2024-11-01 15:05:06","updated_at":"2024-11-01 15:58:21","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20241101-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-11-01 15:58:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"214.4","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":298,"key":298,"name":"\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"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"}},"handlerPerson":{"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"}},"commentCount":{"object_id":3643,"comment":3},"purchaseClientRels":[{"id":2777,"contract_id":3643,"client_id":90,"project_id":3677,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"clickable":1},"project":{"id":3677,"key":3677,"name":"\u65b0\u8d2d\u6234\u5c14\u5b58\u50a8","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1207","key":"1207","contract_id":3643,"value":"214.40","collected_date":"2024-11-08 16:49:13","created_at":"2024-11-08 16:49:13","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2020,"key":2020,"contract_id":3643,"amount":"214.4","value":"214.4","attachment_id":null,"from_date":"2024-11-11","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":30306,"object_type":103,"object_id":2020,"attachment_id":22640,"attachment":{"id":22640,"key":22640,"name":"c34056c5-9681-3199-8f3f-ba7c16066e65","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/c34056c5-9681-3199-8f3f-ba7c16066e65\/\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8(1)(2).pdf","orig_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8(1)(2).pdf"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":707,"user_id":1011,"key":1011,"contract_id":3643,"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":708,"user_id":5360,"key":5360,"contract_id":3643,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":445,"key":445,"contract_id":3643,"name":"2024-11-08","value":"214.4","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1392,"client_id":90,"project_id":3677,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2024-11-12 10:56:45","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u91c7\u8d2d\u7ebf\u7f06\u8d27\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5214.4\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2024-11-12 10:37:36","updated_at":"2024-11-12 10:56:45","supplier_id":298,"purchase_contract_id":3643,"amount":"214.4","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":214.4,"approve_amount":214.4,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"214.4","un_collected":0,"collected_plan":214.4,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3599,"supplier_id":671,"contract_type":1,"signed_at":"2024-10-16","amount":"278000.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-10-16 11:14:49","updated_at":"2024-12-09 11:13:23","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20241016-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-03 10:30:22","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"278000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":671,"key":671,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u6570\u5b57\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":null,"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"}},"handlerPerson":{"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"}},"commentCount":{"object_id":3599,"comment":3},"purchaseClientRels":[{"id":2779,"contract_id":3599,"client_id":90,"project_id":3677,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"clickable":1},"project":{"id":3677,"key":3677,"name":"\u65b0\u8d2d\u6234\u5c14\u5b58\u50a8","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1255","key":"1255","contract_id":3599,"value":"278000.00","collected_date":"2024-12-12 09:26:31","created_at":"2024-12-12 09:26:31","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1999,"key":1999,"contract_id":3599,"amount":"278000","value":"278000","attachment_id":null,"from_date":"2024-10-31","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":29840,"object_type":103,"object_id":1999,"attachment_id":22376,"attachment":{"id":22376,"key":22376,"name":"50301168-0715-3b32-bf44-6215e6e303f2","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/50301168-0715-3b32-bf44-6215e6e303f2\/24512000000234930654.pdf","orig_name":"24512000000234930654.pdf"}}]}],"contractScans":[{"id":30963,"object_type":108,"object_id":3599,"attachment_id":22218,"attachment":{"id":22218,"key":22218,"name":"2a8c33ce-72c8-304b-a135-2ea3746e242e","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/2a8c33ce-72c8-304b-a135-2ea3746e242e\/2024_10_25_11_13_27.pdf","orig_name":"2024_10_25_11_13_27.pdf"}}],"receiptScans":[{"id":30964,"object_type":111,"object_id":3599,"attachment_id":22348,"attachment":{"id":22348,"key":22348,"name":"cac01866-490a-3fe2-a34e-ac134bcc9c54","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/cac01866-490a-3fe2-a34e-ac134bcc9c54\/2024_10_30_11_35_38.pdf","orig_name":"2024_10_30_11_35_38.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":791,"user_id":1011,"key":1011,"contract_id":3599,"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":792,"user_id":5360,"key":5360,"contract_id":3599,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":488,"key":488,"contract_id":3599,"name":"2024-12-12","value":"278000","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1474,"client_id":90,"project_id":3677,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u56db\u5ddd\u957f\u8679\u4f73\u534e\u6570\u5b57\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2024-12-09 09:57:34","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u82cf\u9ece\u4e16\u2014dell\u5b58\u50a8\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d278000\u5143\uff0c\u671f\u671b12\u670812\u65e5\uff08\u5468\u56db\uff09\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2024-12-09 09:57:23","updated_at":"2024-12-09 09:57:34","supplier_id":116,"purchase_contract_id":3599,"amount":"278000","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"278000","erp_payment_un_settle_amount":"-278000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":278000,"approve_amount":278000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"278000","un_collected":0,"collected_plan":278000,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3352,"supplier_id":262,"contract_type":1,"signed_at":"2024-06-13","amount":"253.90","handler":1011,"description":"\u8d60\u9001\u8c03\u8bd5\u7ebf\u7f06","contract_scan":null,"created_by":1011,"created_at":"2024-06-14 11:16:43","updated_at":"2024-06-14 11:16:52","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"297018766565","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-06-14 11:16:52","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"253.9","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contractScan":null,"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"}},"handlerPerson":{"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"}},"commentCount":{"object_id":3352,"comment":3},"purchaseClientRels":[{"id":2044,"contract_id":3352,"client_id":90,"project_id":3446,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"clickable":1},"project":{"id":3446,"key":3446,"name":"\u601d\u79d1\u670d\u52a1\u5668\u65b0\u8d2d+\u6570\u636e\u8fc1\u79fb","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1105","key":"1105","contract_id":3352,"value":"253.90","collected_date":"2024-07-08 12:20:12","created_at":"2024-07-08 12:20:12","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1751,"key":1751,"contract_id":3352,"amount":"253.90","value":"253.90","attachment_id":null,"from_date":"2024-06-14","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":26440,"object_type":103,"object_id":1751,"attachment_id":19703,"attachment":{"id":19703,"key":19703,"name":"7579d712-ce48-330b-ad08-5895e1e08263","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/7579d712-ce48-330b-ad08-5895e1e08263\/45.47-1.pdf","orig_name":"45.47-1.pdf"}},{"id":26441,"object_type":103,"object_id":1751,"attachment_id":19704,"attachment":{"id":19704,"key":19704,"name":"cdf798cb-289e-3510-8c05-8baac8dff795","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/cdf798cb-289e-3510-8c05-8baac8dff795\/45.57-2.pdf","orig_name":"45.57-2.pdf"}},{"id":26442,"object_type":103,"object_id":1751,"attachment_id":19705,"attachment":{"id":19705,"key":19705,"name":"0a867090-1de5-35b4-9a10-956310a9a56b","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/0a867090-1de5-35b4-9a10-956310a9a56b\/162.76.pdf","orig_name":"162.76.pdf"}}]}],"contractScans":[{"id":26438,"object_type":108,"object_id":3352,"attachment_id":19701,"attachment":{"id":19701,"key":19701,"name":"5e04fcea-5fd7-3f33-bcf4-20bbc94cee56","extension":"jpg","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/5e04fcea-5fd7-3f33-bcf4-20bbc94cee56\/35241718334982_.pic.jpg","orig_name":"35241718334982_.pic.jpg"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":237,"user_id":1011,"key":1011,"contract_id":3352,"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":238,"user_id":5360,"key":5360,"contract_id":3352,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":166,"key":166,"contract_id":3352,"name":"2024-06-21","value":"253.9","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":253.9,"approve_amount":0,"un_approve_amount":253.9,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"253.9","un_collected":0,"collected_plan":253.9,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3351,"supplier_id":262,"contract_type":1,"signed_at":"2024-06-11","amount":"29.62","handler":1011,"description":"\u4fdd\u8bfa2\u5305\u6346\u624e\u5e26\uff1b\n\u82cf\u9ece\u4e162\u5305\u6346\u624e\u5e26","contract_scan":null,"created_by":1011,"created_at":"2024-06-14 11:15:10","updated_at":"2024-06-14 11:15:21","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"294035220947","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-06-14 11:15:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"29.62","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contractScan":null,"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"}},"handlerPerson":{"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"}},"commentCount":{"object_id":3351,"comment":3},"purchaseClientRels":[{"id":2043,"contract_id":3351,"client_id":90,"project_id":3446,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"clickable":1},"project":{"id":3446,"key":3446,"name":"\u601d\u79d1\u670d\u52a1\u5668\u65b0\u8d2d+\u6570\u636e\u8fc1\u79fb","project_status":3,"clickable":1}},{"id":2733,"contract_id":3351,"client_id":57,"project_id":3567,"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":1005,"clickable":0,"msg":"\u60a8\u65e0\u6743\u8bbf\u95ee\u6b64\u5ba2\u6237"},"project":{"id":3567,"key":3567,"name":"\u4e0a\u6d77-\u78c1\u5e26\u5e93-\u4e0a\u6d77\u6da6\u8bfa\u8ba2\u5355-PO#20240607060-064","project_status":3,"clickable":0,"msg":"\u60a8\u65e0\u6743\u8bbf\u95ee\u6b64\u5546\u673a"}}],"purchaseContractPayments":[{"id":"144","key":"144","contract_id":3351,"value":"29.62","collected_date":"2024-07-08 12:18:50","created_at":"2024-07-08 12:18:50","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1750,"key":1750,"contract_id":3351,"amount":"29.62","value":"29.62","attachment_id":null,"from_date":"2024-06-12","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":26437,"object_type":103,"object_id":1750,"attachment_id":19700,"attachment":{"id":19700,"key":19700,"name":"f6a9f74b-75ab-3ef4-9320-5a26d1bf044e","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/f6a9f74b-75ab-3ef4-9320-5a26d1bf044e\/29.62.pdf","orig_name":"29.62.pdf"}}]}],"contractScans":[{"id":26436,"object_type":108,"object_id":3351,"attachment_id":19699,"attachment":{"id":19699,"key":19699,"name":"99bf915e-153c-3fb6-b67b-d54e37be8b7e","extension":"jpg","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/99bf915e-153c-3fb6-b67b-d54e37be8b7e\/35231718334850_.pic.jpg","orig_name":"35231718334850_.pic.jpg"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":235,"user_id":1011,"key":1011,"contract_id":3351,"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":236,"user_id":5360,"key":5360,"contract_id":3351,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":165,"key":165,"contract_id":3351,"name":"2024-06-21","value":"29.62","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":29.62,"approve_amount":0,"un_approve_amount":29.62,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"29.62","un_collected":0,"collected_plan":29.62,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3288,"supplier_id":608,"contract_type":1,"signed_at":"2024-05-13","amount":"116.00","handler":1011,"description":"\u8d60\u9001\uff0c4\u6761\u7535\u6e90\u7ebf","contract_scan":null,"created_by":1011,"created_at":"2024-05-13 15:50:25","updated_at":"2024-05-15 13:40:27","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"\u8ba2\u5355\u53f7: 3886093334225161702","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-05-15 13:40:27","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"116","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contractScan":null,"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"}},"handlerPerson":{"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"}},"commentCount":{"object_id":3288,"comment":2},"purchaseClientRels":[{"id":2039,"contract_id":3288,"client_id":90,"project_id":3446,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","sales_rep":5295,"clickable":1},"project":{"id":3446,"key":3446,"name":"\u601d\u79d1\u670d\u52a1\u5668\u65b0\u8d2d+\u6570\u636e\u8fc1\u79fb","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1104","key":"1104","contract_id":3288,"value":"116.00","collected_date":"2024-07-08 12:09:42","created_at":"2024-07-08 12:09:42","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1786,"key":1786,"contract_id":3288,"amount":"116.00","value":"116.00","attachment_id":null,"from_date":"2024-05-20","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":26961,"object_type":103,"object_id":1786,"attachment_id":20174,"attachment":{"id":20174,"key":20174,"name":"bd9ccd3c-677d-32cf-adb9-bb220e064d16","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/bd9ccd3c-677d-32cf-adb9-bb220e064d16\/_24952000000070142707.pdf","orig_name":"_24952000000070142707.pdf"}}]}],"contractScans":[{"id":25676,"object_type":108,"object_id":3288,"attachment_id":19095,"attachment":{"id":19095,"key":19095,"name":"760f593b-4820-3a9d-a188-4baa140560d8","extension":"jpg","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/760f593b-4820-3a9d-a188-4baa140560d8\/33771715586595_.pic.jpg","orig_name":"33771715586595_.pic.jpg"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":143,"user_id":1011,"key":1011,"contract_id":3288,"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":144,"user_id":5360,"key":5360,"contract_id":3288,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":109,"key":109,"contract_id":3288,"name":"2024-05-23","value":"116","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":116,"approve_amount":0,"un_approve_amount":116,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"116","un_collected":0,"collected_plan":116,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false}],"pagenation":{"totalcount":46,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-08 10:18:32') RETURNING "id"