6882ee74df63d: POST https://beta.jinchangxiao.com/v2/sales-contract/list at 2025-07-25 10:39:48 am by 117.176.187.42
Database Queries
总计59条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:39:48.925 | 11.0 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b' |
| 10:39:48.937 | 5.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:39:48.951 | 77.7 ms | SELECT | SELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project 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 = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND ("client"."sales_rep"='5311') AND ("client"."sales_rep"='5311') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 10:39:49.029 | 12.8 ms | SELECT | SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project 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 = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND ("client"."sales_rep"='5311') AND ("client"."sales_rep"='5311') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 |
| 10:39:49.043 | 0.7 ms | SELECT | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (531, 2021, 42, 2088, 3271, 2839, 1331) |
| 10:39:49.044 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5311 |
| 10:39:49.045 | 0.5 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5311) |
| 10:39:49.046 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295, 5311, 5015, 5364) |
| 10:39:49.046 | 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 (5015, 5311, 5295, 5364, 5300)) |
| 10:39:49.047 | 7.9 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (9, 2, 1) |
| 10:39:49.055 | 50.9 ms | SELECT | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108)) GROUP BY "object_id" |
| 10:39:49.106 | 7.5 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3791, 3763, 3738, 3717, 3675, 3620, 3560, 3545, 3509, 3404) |
| 10:39:49.114 | 0.8 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "description", "total_contact_point", "paid_contact_point", "is_sales_order_ready", "project_product_version_id", "bargain_date", "collected", "profit_pct", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3791, 3763, 3738, 3717, 3675, 3620, 3560, 3545, 3509, 3404) |
| 10:39:49.116 | 1.9 ms | SELECT | SELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3620, 3675, 3545, 3717, 3738, 3763, 3791, 3560, 3509, 3404) |
| 10:39:49.118 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3620, 3675, 3545, 3717, 3738, 3763, 3791, 3560, 3509, 3404) |
| 10:39:49.120 | 1.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (608, 500, 236, 59, 678, 212, 280, 505) |
| 10:39:49.121 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (276, 542, 1512, 1883, 1924, 1813, 941, 1492, 1493, 1494, 1495, 1511, 1578, 1579, 904, 1621) |
| 10:39:49.124 | 1.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 22, 2, 4, 11, 19, 3) |
| 10:39:49.125 | 1.1 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (30, 200, 2, 19, 154, 151, 41, 5, 188, 15, 33, 189) |
| 10:39:49.127 | 1.0 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (16, 12, 9, 20, 4, 133, 2) |
| 10:39:49.128 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1240, 1307, 1353, 1354, 1381, 592, 1524, 1198, 743, 889, 1125, 567, 744, 739, 523) |
| 10:39:49.131 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 8, 1, 7, 4) |
| 10:39:49.132 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3620, 3675, 3545, 3717, 3738, 3763, 3791, 3560, 3509, 3404) |
| 10:39:49.133 | 2.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (2916, 1188) |
| 10:39:49.136 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (531, 1331) |
| 10:39:49.136 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((2916, 3404), (1188, 3791), (1188, 3717)) |
| 10:39:49.137 | 9.5 ms | SELECT | SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3620, 3675, 3545, 3717, 3738, 3763, 3791, 3560, 3509, 3404)) |
| 10:39:49.147 | 16.3 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (3620, 3675, 3545, 3717, 3738, 3763, 3791, 3560, 3509, 3404)) GROUP BY "project_id" |
| 10:39:49.164 | 2.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108) |
| 10:39:49.170 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (608, 236, 280, 212, 500, 678, 59, 505, 659, 689) |
| 10:39:49.171 | 1.3 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3304, 3144, 3305, 3307, 3672, 3671, 3814, 3721, 3391, 3178, 3589, 3702, 3850) |
| 10:39:49.172 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 10:39:49.173 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295, 5311, 5364) |
| 10:39:49.174 | 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 (5311, 5295, 5364, 5300)) |
| 10:39:49.174 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108)) ORDER BY "remind_date" |
| 10:39:49.175 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108) |
| 10:39:49.176 | 0.8 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108) |
| 10:39:49.177 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5311 |
| 10:39:49.177 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5311) |
| 10:39:49.178 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108) |
| 10:39:49.178 | 0.7 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108) |
| 10:39:49.179 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5388, 1001, 5300) |
| 10:39:49.180 | 0.5 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 5388, 5300)) |
| 10:39:49.180 | 0.8 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108) ORDER BY "remind_date" |
| 10:39:49.181 | 1.3 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108) ORDER BY "id" |
| 10:39:49.183 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 1013) |
| 10:39:49.183 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (1788, 1864, 1869, 1893, 1955, 1983, 2021, 2066, 2071, 2131)) |
| 10:39:49.185 | 0.9 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22878, 21888, 17774, 19626, 19666, 20078, 21284, 23586, 23711, 24457) |
| 10:39:49.186 | 1.5 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108) ORDER BY "id" |
| 10:39:49.188 | 4.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1590, 1671, 1679, 1681, 1775, 1867, 1912, 1944, 1971, 1978, 1979)) |
| 10:39:49.193 | 2.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1590, 1671, 1679, 1681, 1775, 1867, 1912, 1944, 1971, 1978, 1979)) |
| 10:39:49.196 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (17432, 19484, 19609, 19658, 22833, 21242, 23417, 23890, 24432, 24541, 24542) |
| 10:39:49.197 | 2.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108)) |
| 10:39:49.199 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21824, 17421, 19341, 18914, 19372, 19607, 23128, 20890, 22835, 23622, 24403) |
| 10:39:49.200 | 2.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108)) |
| 10:39:49.203 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22870, 23110, 19409, 20175, 23446, 23801) |
| 10:39:49.204 | 2.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108)) |
| 10:39:49.206 | 36.9 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id" IN (3811, 3749, 3701, 3670, 3580, 3465, 3337, 3302, 3246, 3108)) GROUP BY "object_id" |
| 10:39:49.253 | 15.4 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', 5295, 2, 1143, 'v2/sales-contract/list', '{"Filter":{"name":"","sort":""},"SalesContractSearch":{"contract_type":"","handler":"5311"},"access_token":"aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b","device_type":"2","posttime":"1753411200","token":"558af3cf9aeecdd2557c99123b9753c3","version_code":"1143"}', '{"code":200,"data":{"list":[{"id":3811,"client_id":531,"signed_at":"2025-03-05","amount":"3150","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-05 17:28:13","updated_at":"2025-03-12 13:59:08","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3791,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-20250305001","payment_collection_remind_ahead":"","from_project":3791,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-05 17:28:35.841072+08","b_date":null,"passed":1,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3811,"comment":8},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025"},"fromProject":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025","description":"","total_contact_point":"880","paid_contact_point":"880","is_sales_order_ready":true,"project_product_version_id":797,"bargain_date":"2025-03-05","collected":"3150","profit_pct":"16.97","budget":"3150","projectProductTypes":[{"id":6097,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"3150.00","pct":"16.97","project_id":3791,"profit":"534.555"}],"projectProductRels":[{"id":8988,"project_id":3791,"product_id":542,"amount":"3150.00","number":1,"cost":"1300.00","description":"","supplier_id":678,"hardware_from":"2025-03-05","software_from":null,"maintenance_from":null,"hardware_to":"2025-03-06","software_to":null,"maintenance_to":null,"total_amount":"3150","total_cost":"1300","supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":542,"name":"00YK017","product_type":2,"product_component":5,"product_brand":4,"product_serie":1198,"product_misc":8,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2019-01-04 15:33:52","updated_at":"2024-11-20 14:45:21","pinyin_shortcut":"00YK017","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1198,"key":1198,"name":"1.8T 10K 2.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[{"id":910,"project_id":3791,"contact_id":1188,"point":"880.00","paid_point":"880","contact":{"id":1188,"key":1188,"name":"\u5f20\u9a70","client_id":531,"supplier_id":null,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[{"id":172,"project_id":3791,"contact_id":1188,"point":"880.00","day_at":"2025-03-12","description":"","created_at":"2025-03-12 13:59:08"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12702,"project_id":3791}],"reimbursementAmountSum":null,"profit":534.555,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":2499,"contract_id":3811,"supplier_id":678,"purchase_id":3814,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3814,"key":3814,"serial_no":"YTYG20250306"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8353,"user_id":5311,"key":5311,"contract_id":3811,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8032,"user_id":5300,"key":5300,"contract_id":3811,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":8033,"user_id":5388,"key":5388,"contract_id":3811,"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":8034,"user_id":1001,"key":1001,"contract_id":3811,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2353,"key":2353,"contract_id":3811,"name":"2025-03-21","value":"3150","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2131,"key":2131,"contract_id":3811,"value":"3150","created_by":1013,"created_at":"2025-03-10 11:16:35","description":"","collected_date":"2025-03-10","amount":"3150","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32762,"object_type":109,"object_id":2131,"attachment_id":24457,"attachment":{"id":24457,"key":24457,"name":"ebc27b61-a8f1-3743-a4db-9d0eb0fd512c","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/ebc27b61-a8f1-3743-a4db-9d0eb0fd512c\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1971,"key":1971,"contract_id":3811,"value":"3150.00","attachment_id":null,"from_date":"2025-03-07","attachment":null,"attachmentRelationships":[],"files":[{"id":32726,"object_type":102,"object_id":1971,"attachment_id":24432,"attachment":{"id":24432,"key":24432,"name":"dff9deda-3114-397c-95f4-432d3284169a","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/dff9deda-3114-397c-95f4-432d3284169a\/dzfp_25112000000045420958_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250307094835.pdf","orig_name":"dzfp_25112000000045420958_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250307094835.pdf"}}]},{"id":1978,"key":1978,"contract_id":3811,"value":"-3150.00","attachment_id":null,"from_date":"2025-03-14","attachment":null,"attachmentRelationships":[],"files":[{"id":32884,"object_type":102,"object_id":1978,"attachment_id":24541,"attachment":{"id":24541,"key":24541,"name":"38801acf-9469-312a-8a19-cb4c57246891","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/38801acf-9469-312a-8a19-cb4c57246891\/dzfp_25112000000049433908_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101729.pdf","orig_name":"dzfp_25112000000049433908_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101729.pdf"}}]},{"id":1979,"key":1979,"contract_id":3811,"value":"3150.00","attachment_id":null,"from_date":"2025-03-14","attachment":null,"attachmentRelationships":[],"files":[{"id":32899,"object_type":102,"object_id":1979,"attachment_id":24542,"attachment":{"id":24542,"key":24542,"name":"4974f2a1-62b1-32e9-ac1c-15fc300eb35c","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/4974f2a1-62b1-32e9-ac1c-15fc300eb35c\/dzfp_25112000000050933384_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101355.pdf","orig_name":"dzfp_25112000000050933384_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101355.pdf"}}]}],"contractScans":[{"id":32858,"object_type":105,"object_id":3811,"attachment_id":24403,"attachment":{"id":24403,"key":24403,"name":"6cc3b4ca-81f0-31e8-acd4-7f33b1c59fe9","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/6cc3b4ca-81f0-31e8-acd4-7f33b1c59fe9\/2025.3.5\u62d3\u5b9e\u79d1\u6280\u786c\u76d8.pdf","orig_name":"2025.3.5\u62d3\u5b9e\u79d1\u6280\u786c\u76d8.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":3150,"projectProductTotalAmount":3150,"projectProductAllAmount":true,"projectProductTotalCost":1300,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":3150,"un_invoiced":0,"collected":3150,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3749,"client_id":2021,"signed_at":"2025-01-09","amount":"600","handler":5300,"description":"","created_by":5300,"created_at":"2025-01-09 18:29:21","updated_at":"2025-01-17 16:02:39","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3763,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-2025010901","payment_collection_remind_ahead":"","from_project":3763,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-01-09 18:29:22.010601+08","b_date":null,"passed":1,"client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3749,"comment":9},"project":{"id":3763,"key":3763,"name":"\u786c\u76d8SAS300GB10K-G-2025"},"fromProject":{"id":3763,"key":3763,"name":"\u786c\u76d8SAS300GB10K-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":747,"bargain_date":"2025-01-09","collected":"600","profit_pct":"63.25","budget":"600","projectProductTypes":[{"id":5886,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"600","pct":"63.25","project_id":3763,"profit":"379.5"}],"projectProductRels":[{"id":8494,"project_id":3763,"product_id":1924,"amount":"600.00","number":1,"cost":"150.00","description":"","supplier_id":59,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"600","total_cost":"150","supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":1924,"name":"653955-001","product_type":2,"product_component":5,"product_brand":2,"product_serie":889,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-01-10 09:23:09","updated_at":"2025-01-10 09:23:09","pinyin_shortcut":"653955001","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":889,"key":889,"name":"300G 10K 2.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12468,"project_id":3763}],"reimbursementAmountSum":null,"profit":379.5,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2408,"contract_id":3749,"supplier_id":59,"purchase_id":3721,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":3721,"key":3721,"serial_no":"TSKJ20250110-HYF-001"}},{"id":2335,"contract_id":3749,"supplier_id":59,"purchase_id":null,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":null}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8290,"user_id":5311,"key":5311,"contract_id":3749,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":2305,"key":2305,"contract_id":3749,"name":"2025-01-09","value":"600","overdue_days":0,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2071,"key":2071,"contract_id":3749,"value":"600","created_by":1013,"created_at":"2025-01-13 15:16:00","description":"","collected_date":"2025-01-09","amount":"600","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":31796,"object_type":109,"object_id":2071,"attachment_id":23711,"attachment":{"id":23711,"key":23711,"name":"da5083cf-2108-33a5-ac1e-623a701d5ba0","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/da5083cf-2108-33a5-ac1e-623a701d5ba0\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1944,"key":1944,"contract_id":3749,"value":"600.00","attachment_id":null,"from_date":"2025-01-21","attachment":null,"attachmentRelationships":[],"files":[{"id":32024,"object_type":102,"object_id":1944,"attachment_id":23890,"attachment":{"id":23890,"key":23890,"name":"17875b15-9e68-31b0-93e1-a719d33ef994","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/17875b15-9e68-31b0-93e1-a719d33ef994\/dzfp_25112000000017444338_\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8_20250121155724.pdf","orig_name":"dzfp_25112000000017444338_\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8_20250121155724.pdf"}}]}],"contractScans":[{"id":31725,"object_type":105,"object_id":3749,"attachment_id":23622,"attachment":{"id":23622,"key":23622,"name":"1b7e2f68-1127-3ba1-89f4-c00c040929f0","extension":"jpeg","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/1b7e2f68-1127-3ba1-89f4-c00c040929f0\/\u65b0\u7586.jpeg","orig_name":"\u65b0\u7586.jpeg"}}],"receiptScans":[{"id":31913,"object_type":106,"object_id":3749,"attachment_id":23801,"attachment":{"id":23801,"key":23801,"name":"ad47126c-bdb1-3b8f-8d33-f9db987a20b6","extension":"jpg","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/ad47126c-bdb1-3b8f-8d33-f9db987a20b6\/22701737100278_.pic.jpg","orig_name":"22701737100278_.pic.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":600,"projectProductTotalAmount":600,"projectProductAllAmount":true,"projectProductTotalCost":150,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":600,"un_invoiced":0,"collected":600,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3701,"client_id":42,"signed_at":"2024-12-10","amount":"1400","handler":5295,"description":"","created_by":5295,"created_at":"2024-12-10 16:13:41","updated_at":"2024-12-30 10:37:19","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3738,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2024121001","payment_collection_remind_ahead":"7 days","from_project":3738,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-12-13 12:00:43.880593+08","b_date":null,"passed":1,"client":{"id":42,"key":42,"name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3701,"comment":8},"project":{"id":3738,"key":3738,"name":"\u65b0\u8d2d2\u5757\u5b58\u50a8\u786c\u76d8-2"},"fromProject":{"id":3738,"key":3738,"name":"\u65b0\u8d2d2\u5757\u5b58\u50a8\u786c\u76d8-2","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":704,"bargain_date":"2024-12-10","collected":"1400","profit_pct":"60.45","budget":"1400","projectProductTypes":[{"id":5706,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1400.00","pct":"60.45","project_id":3738,"profit":"846.3"}],"projectProductRels":[{"id":7954,"project_id":3738,"product_id":276,"amount":"700.00","number":2,"cost":"197.50","description":"","supplier_id":608,"hardware_from":"2024-12-11","software_from":null,"maintenance_from":null,"hardware_to":"2025-03-10","software_to":null,"maintenance_to":null,"total_amount":"1400","total_cost":"395","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":276,"name":"49Y1860","product_type":3,"product_component":15,"product_brand":4,"product_serie":1125,"product_misc":4,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-09-12 18:57:28","updated_at":"2024-02-01 10:55:25","pinyin_shortcut":"49Y1860","product_unit":4,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1125,"key":1125,"name":"\u8054\u60f3300G 15K 3.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12326,"project_id":3738},{"id":12327,"project_id":3738}],"reimbursementAmountSum":{"project_id":3738,"sum":"41.10"},"profit":846.3,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2200,"contract_id":3701,"supplier_id":608,"purchase_id":3702,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":3702,"key":3702,"serial_no":"\u8ba2\u5355\u53f7: 4160019673796161702"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8306,"user_id":5311,"key":5311,"contract_id":3701,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7326,"user_id":5295,"key":5295,"contract_id":3701,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":7327,"user_id":5388,"key":5388,"contract_id":3701,"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":7328,"user_id":1001,"key":1001,"contract_id":3701,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2197,"key":2197,"contract_id":3701,"name":"2025-01-27","value":"1400","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2066,"key":2066,"contract_id":3701,"value":"1400","created_by":1013,"created_at":"2025-01-07 16:50:00","description":"","collected_date":"2025-01-07","amount":"1400","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":31622,"object_type":109,"object_id":2066,"attachment_id":23586,"attachment":{"id":23586,"key":23586,"name":"d73a9521-8dfe-357b-b0e2-473c3cf02c0b","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/d73a9521-8dfe-357b-b0e2-473c3cf02c0b\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1912,"key":1912,"contract_id":3701,"value":"1400.00","attachment_id":null,"from_date":"2024-12-27","attachment":null,"attachmentRelationships":[],"files":[{"id":31378,"object_type":102,"object_id":1912,"attachment_id":23417,"attachment":{"id":23417,"key":23417,"name":"f4f97b06-91a1-33b9-932b-46ffd4b9fb87","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/f4f97b06-91a1-33b9-932b-46ffd4b9fb87\/dzfp_24112000000223846056_\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8_20241227140835.pdf","orig_name":"dzfp_24112000000223846056_\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8_20241227140835.pdf"}}]}],"contractScans":[{"id":31071,"object_type":105,"object_id":3701,"attachment_id":23128,"attachment":{"id":23128,"key":23128,"name":"fee692c5-f353-3100-b702-e96575f1c192","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/fee692c5-f353-3100-b702-e96575f1c192\/\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8.pdf","orig_name":"\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8.pdf"}}],"receiptScans":[{"id":31410,"object_type":106,"object_id":3701,"attachment_id":23446,"attachment":{"id":23446,"key":23446,"name":"9d7f2663-5c8d-3cbb-98ed-2a99d3702382","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/9d7f2663-5c8d-3cbb-98ed-2a99d3702382\/20241227173448.pdf","orig_name":"20241227173448.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":1400,"projectProductTotalAmount":1400,"projectProductAllAmount":true,"projectProductTotalCost":395,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":1400,"un_invoiced":0,"collected":1400,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3670,"client_id":531,"signed_at":"2024-11-20","amount":"8950","handler":5300,"description":"","created_by":5300,"created_at":"2024-11-20 11:23:37","updated_at":"2024-11-29 14:39:27","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3717,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSC-SQY-2024111801","payment_collection_remind_ahead":"7 days","from_project":3717,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-11-21 11:29:34.927309+08","b_date":null,"passed":1,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3670,"comment":8},"project":{"id":3717,"key":3717,"name":"\u6df1\u4fe1\u670d\u7eed\u4fdd1\u5e74-K-2024"},"fromProject":{"id":3717,"key":3717,"name":"\u6df1\u4fe1\u670d\u7eed\u4fdd1\u5e74-K-2024","description":"","total_contact_point":"2850","paid_contact_point":"2850","is_sales_order_ready":true,"project_product_version_id":680,"bargain_date":"2024-11-20","collected":"8950","profit_pct":"20.22","budget":"8950","projectProductTypes":[{"id":5617,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"8950","pct":"20.22","project_id":3717,"profit":"1809.69"}],"projectProductRels":[{"id":7740,"project_id":3717,"product_id":542,"amount":"3150.00","number":1,"cost":"1150.00","description":"","supplier_id":500,"hardware_from":"2024-11-20","software_from":null,"maintenance_from":null,"hardware_to":"2025-11-19","software_to":null,"maintenance_to":null,"total_amount":"3150","total_cost":"1150","supplier":{"id":500,"key":500,"name":"\u5317\u4eac\u817e\u76db\u672a\u6765\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":542,"name":"00YK017","product_type":2,"product_component":5,"product_brand":4,"product_serie":1198,"product_misc":8,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2019-01-04 15:33:52","updated_at":"2024-11-20 14:45:21","pinyin_shortcut":"00YK017","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1198,"key":1198,"name":"1.8T 10K 2.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}},{"id":7741,"project_id":3717,"product_id":1512,"amount":"0","number":1,"cost":"1034.00","description":"","supplier_id":236,"hardware_from":"2024-11-20","software_from":null,"maintenance_from":null,"hardware_to":"2025-11-20","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"1034","supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1512,"name":"\u6df1\u4fe1\u670dAF-1000-L4175\u9632\u706b\u5899\u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1307,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-03-15 16:35:51","updated_at":"2024-03-15 16:35:51","pinyin_shortcut":"sxfAF1000L4175fhqxbfw","product_unit":8,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1307,"key":1307,"name":"\u6df1\u4fe1\u670dAF-1000-L4175\u9632\u706b\u5899\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}},{"id":7742,"project_id":3717,"product_id":1883,"amount":"5800.00","number":1,"cost":"713.00","description":"","supplier_id":236,"hardware_from":null,"software_from":"2024-11-20","maintenance_from":null,"hardware_to":null,"software_to":"2025-11-20","maintenance_to":null,"total_amount":"5800","total_cost":"713","supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1883,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-L4175\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":743,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-20 14:49:17","updated_at":"2024-11-20 14:49:17","pinyin_shortcut":"sxfaqynyzdyrjV80syyAF1000L4175","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":743,"key":743,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[{"id":754,"project_id":3717,"contact_id":1188,"point":"2850.00","paid_point":"2850","contact":{"id":1188,"key":1188,"name":"\u5f20\u9a70","client_id":531,"supplier_id":null,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[{"id":129,"project_id":3717,"contact_id":1188,"point":"2850.00","day_at":"2024-11-29","description":"","created_at":"2024-11-29 14:39:27"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12299,"project_id":3717},{"id":12297,"project_id":3717},{"id":12298,"project_id":3717}],"reimbursementAmountSum":null,"profit":1809.69,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":2128,"contract_id":3670,"supplier_id":500,"purchase_id":3672,"supplier":{"id":500,"key":500,"name":"\u5317\u4eac\u817e\u76db\u672a\u6765\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3672,"key":3672,"serial_no":"BJTSWL-2024-11-21"}},{"id":2129,"contract_id":3670,"supplier_id":236,"purchase_id":3671,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3671,"key":3671,"serial_no":"TSKJ20241120-ZHF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8352,"user_id":5311,"key":5311,"contract_id":3670,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7162,"user_id":5300,"key":5300,"contract_id":3670,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7163,"user_id":5388,"key":5388,"contract_id":3670,"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":7164,"user_id":1001,"key":1001,"contract_id":3670,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2161,"key":2161,"contract_id":3670,"name":"2024-12-20","value":"8950","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2021,"key":2021,"contract_id":3670,"value":"8950","created_by":1013,"created_at":"2024-11-22 15:54:36","description":"","collected_date":"2024-11-22","amount":"8950","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":30624,"object_type":109,"object_id":2021,"attachment_id":22878,"attachment":{"id":22878,"key":22878,"name":"b91e8db1-5c6e-3528-91a4-0f79329ccaf5","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/b91e8db1-5c6e-3528-91a4-0f79329ccaf5\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1867,"key":1867,"contract_id":3670,"value":"8950.00","attachment_id":null,"from_date":"2024-11-20","attachment":null,"attachmentRelationships":[],"files":[{"id":30730,"object_type":102,"object_id":1867,"attachment_id":22833,"attachment":{"id":22833,"key":22833,"name":"6e23c1b8-fa2c-3637-a0d2-ca60f78bc3a5","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/6e23c1b8-fa2c-3637-a0d2-ca60f78bc3a5\/dzfp_24112000000186872449_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20241120155925.pdf","orig_name":"dzfp_24112000000186872449_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20241120155925.pdf"}}]}],"contractScans":[{"id":30741,"object_type":105,"object_id":3670,"attachment_id":22835,"attachment":{"id":22835,"key":22835,"name":"2ee7b463-5ee0-3c1f-a44d-b1224d6c20af","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/2ee7b463-5ee0-3c1f-a44d-b1224d6c20af\/2024_11_20_17_21_32.pdf","orig_name":"2024_11_20_17_21_32.pdf"}}],"receiptScans":[{"id":30611,"object_type":106,"object_id":3670,"attachment_id":22870,"attachment":{"id":22870,"key":22870,"name":"eb68186f-26f9-30af-a777-2837694bdd05","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/eb68186f-26f9-30af-a777-2837694bdd05\/MX-M502N_20241122_040153.pdf","orig_name":"MX-M502N_20241122_040153.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":8950,"projectProductTotalAmount":8950,"projectProductAllAmount":true,"projectProductTotalCost":2897,"projectProductAllCost":true,"projectProductTotalCount":3,"invoiced":8950,"un_invoiced":0,"collected":8950,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3580,"client_id":2088,"signed_at":"2024-10-10","amount":"22000","handler":5311,"description":"","created_by":5311,"created_at":"2024-10-10 10:44:07","updated_at":"2024-12-10 10:30:05","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3675,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2024100801","payment_collection_remind_ahead":"","from_project":3675,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-10-16 13:29:43.617803+08","b_date":null,"passed":1,"client":{"id":2088,"key":2088,"name":"\u5317\u4eac\u827e\u7ef4\u955d\u751f\u7269\u6280\u672f\u6709\u9650\u8d23\u4efb\u516c\u53f8","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","department_id":2,"avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":3580,"comment":6},"project":{"id":3675,"key":3675,"name":"\u65b0\u8d2dXDLP"},"fromProject":{"id":3675,"key":3675,"name":"\u65b0\u8d2dXDLP","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":612,"bargain_date":"2024-10-10","collected":"22000","profit_pct":"34.5","budget":"22000","projectProductTypes":[{"id":5398,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"22000.00","pct":"34.5","project_id":3675,"profit":"7590"}],"projectProductRels":[{"id":6821,"project_id":3675,"product_id":1813,"amount":"440","number":50,"cost":"255.42","description":"50\u4e2a\u8ba2\u9605\u5f0f3\u5e74\u670d\u52a1","supplier_id":236,"hardware_from":null,"software_from":"2024-10-12","maintenance_from":null,"hardware_to":null,"software_to":"2027-10-11","maintenance_to":null,"total_amount":"22000","total_cost":"12771.00","supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1813,"name":"\u6df1\u4fe1\u670dXDLP\u53ef\u6269\u5c55\u6570\u636e\u9632\u6cc4\u6f0f\u7ba1\u63a7\u4e0e\u5206\u6790\u8f6f\u4ef6V3.0(\u9002\u7528\u4e8eSASE-XDLP)","product_type":7,"product_component":41,"product_brand":12,"product_serie":1524,"product_misc":null,"product_qa":null,"pn":"","description":"1\u3001\u6df1\u4fe1\u670dXDLP\u6570\u636e\u9632\u6cc4\u6f0f\u7ba1\u63a7\u4e0e\u5206\u6790\u8f6f\u4ef6\uff0c\u5305\u542b\u7ec8\u7aef\u9632\u6cc4\u5bc6\u5ba1\u8ba1\u80fd\u529b\u3001\u7ec8\u7aef\u9632\u6cc4\u5bc6\u7ba1\u63a7\u80fd\u529b\u3001\u6570\u636e\u9632\u6cc4\u6f0f\u5206\u6790\u5e73\u53f0\u3002\n2\u3001\u63d0\u4f9bUSB\u3001\u84dd\u7259\u7b49\u7ec8\u7aef\u7ba1\u7406\u4e0e\u5916\u53d1\u5ba1\u8ba1\u80fd\u529b\uff0c\u63d0\u4f9b\u8fdc\u7a0b\u5de5\u5177\u3001IM\u804a\u5929\u7b49\u7ec8\u7aef\u5e94\u7528\u7a0b\u5e8f\u6570\u636e\u5916\u53d1\u901a\u8def\u7ba1\u63a7\u4e0e\u5ba1\u8ba1\u80fd\u529b\u3002","created_by":1013,"created_at":"2024-10-11 17:48:49","updated_at":"2024-10-11 17:49:07","pinyin_shortcut":"sxfXDLPkkzsjfxlgkyfxrjV30syySASEXDLP","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1524,"key":1524,"name":"\u6df1\u4fe1\u670dXDLP\u53ef\u6269\u5c55\u6570\u636e\u9632\u6cc4\u6f0f\u7ba1\u63a7\u4e0e\u5206\u6790\u8f6f\u4ef6V3.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":9819,"project_id":3675},{"id":10211,"project_id":3675},{"id":10212,"project_id":3675},{"id":10213,"project_id":3675},{"id":10214,"project_id":3675},{"id":10215,"project_id":3675},{"id":10216,"project_id":3675},{"id":10217,"project_id":3675},{"id":10218,"project_id":3675},{"id":10219,"project_id":3675},{"id":10220,"project_id":3675},{"id":10221,"project_id":3675},{"id":10222,"project_id":3675},{"id":10223,"project_id":3675},{"id":10224,"project_id":3675},{"id":10225,"project_id":3675},{"id":10226,"project_id":3675},{"id":10227,"project_id":3675},{"id":10228,"project_id":3675},{"id":10229,"project_id":3675},{"id":10230,"project_id":3675},{"id":10231,"project_id":3675},{"id":10232,"project_id":3675},{"id":10233,"project_id":3675},{"id":10234,"project_id":3675},{"id":10235,"project_id":3675},{"id":10236,"project_id":3675},{"id":10237,"project_id":3675},{"id":10238,"project_id":3675},{"id":10239,"project_id":3675},{"id":10240,"project_id":3675},{"id":10241,"project_id":3675},{"id":10242,"project_id":3675},{"id":10243,"project_id":3675},{"id":10244,"project_id":3675},{"id":10245,"project_id":3675},{"id":10246,"project_id":3675},{"id":10247,"project_id":3675},{"id":10248,"project_id":3675},{"id":10249,"project_id":3675},{"id":10250,"project_id":3675},{"id":10251,"project_id":3675},{"id":10252,"project_id":3675},{"id":10253,"project_id":3675},{"id":10254,"project_id":3675},{"id":10255,"project_id":3675},{"id":10256,"project_id":3675},{"id":10257,"project_id":3675},{"id":10258,"project_id":3675},{"id":10259,"project_id":3675}],"reimbursementAmountSum":null,"profit":7590,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1899,"contract_id":3580,"supplier_id":236,"purchase_id":3589,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3589,"key":3589,"serial_no":"TSKJ20241012-HYF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","department_id":2,"avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8282,"user_id":5311,"key":5311,"contract_id":3580,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":6821,"user_id":5295,"key":5295,"contract_id":3580,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":6822,"user_id":5388,"key":5388,"contract_id":3580,"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":6823,"user_id":1001,"key":1001,"contract_id":3580,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2081,"key":2081,"contract_id":3580,"name":"2024-10-17","value":"22000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1983,"key":1983,"contract_id":3580,"value":"22000","created_by":1013,"created_at":"2024-10-11 17:22:27","description":"","collected_date":"2024-10-11","amount":"22000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":29203,"object_type":109,"object_id":1983,"attachment_id":21888,"attachment":{"id":21888,"key":21888,"name":"956e3a66-87f0-34ee-8ce8-9e84b83b5977","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/956e3a66-87f0-34ee-8ce8-9e84b83b5977\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[],"contractScans":[{"id":29421,"object_type":105,"object_id":3580,"attachment_id":21824,"attachment":{"id":21824,"key":21824,"name":"43868fa9-a246-3315-b005-092cfb8f503d","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/43868fa9-a246-3315-b005-092cfb8f503d\/\u827e\u7ef4\u955d22000.pdf","orig_name":"\u827e\u7ef4\u955d22000.pdf"}}],"receiptScans":[{"id":30986,"object_type":106,"object_id":3580,"attachment_id":23110,"attachment":{"id":23110,"key":23110,"name":"76b5a04e-d0e5-301f-8559-f5080120e7ca","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/76b5a04e-d0e5-301f-8559-f5080120e7ca\/\u6df1\u4fe1\u670d-\u7b7e\u6536\u5355.pdf","orig_name":"\u6df1\u4fe1\u670d-\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":22000,"projectProductTotalAmount":22000,"projectProductAllAmount":true,"projectProductTotalCost":12771,"projectProductAllCost":true,"projectProductTotalCount":50,"invoiced":0,"un_invoiced":22000,"collected":22000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3465,"client_id":3271,"signed_at":"2024-07-30","amount":"7500","handler":5295,"description":"","created_by":5295,"created_at":"2024-08-12 19:31:05","updated_at":"2024-09-03 16:11:49","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3620,"valid_date":null,"expire_date":"2024-08-30","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TSC-WZW-2024073006","payment_collection_remind_ahead":"7 days","from_project":3620,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-09-03 13:13:43.648746+08","b_date":329,"passed":2,"client":{"id":3271,"key":3271,"name":"\u4e2d\u6d77\u6210\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3465,"comment":7},"project":{"id":3620,"key":3620,"name":"\u6280\u672f\u670d\u52a1-2"},"fromProject":{"id":3620,"key":3620,"name":"\u6280\u672f\u670d\u52a1-2","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":557,"bargain_date":"2024-07-30","collected":"7500","profit_pct":"93","budget":"7500","projectProductTypes":[{"id":2287,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"7500","pct":"93","project_id":3620,"profit":"6975"}],"projectProductRels":[{"id":6254,"project_id":3620,"product_id":941,"amount":"7500","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-07-30","hardware_to":null,"software_to":null,"maintenance_to":"2024-08-30","total_amount":"7500","total_cost":"0","supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":11060,"project_id":3620}],"reimbursementAmountSum":{"project_id":3620,"sum":"304.50"},"profit":6975,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8285,"user_id":5311,"key":5311,"contract_id":3465,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":6452,"user_id":5295,"key":5295,"contract_id":3465,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":6453,"user_id":5388,"key":5388,"contract_id":3465,"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":6454,"user_id":1001,"key":1001,"contract_id":3465,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2014,"key":2014,"contract_id":3465,"name":"2024-10-30","value":"7500","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1955,"key":1955,"contract_id":3465,"value":"7500","created_by":1013,"created_at":"2024-09-05 15:44:19","description":"","collected_date":"2024-09-05","amount":"7500","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":28426,"object_type":109,"object_id":1955,"attachment_id":21284,"attachment":{"id":21284,"key":21284,"name":"09430fe0-750f-3de9-9534-6567a00ed405","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/09430fe0-750f-3de9-9534-6567a00ed405\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1775,"key":1775,"contract_id":3465,"value":"7500.00","attachment_id":null,"from_date":"2024-09-03","attachment":null,"attachmentRelationships":[],"files":[{"id":28370,"object_type":102,"object_id":1775,"attachment_id":21242,"attachment":{"id":21242,"key":21242,"name":"4a82099e-5c63-3b61-8ea6-3e2ae50af841","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/4a82099e-5c63-3b61-8ea6-3e2ae50af841\/dzfp_24112000000120609464_\u4e2d\u6d77\u6210\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8_20240903094409.pdf","orig_name":"dzfp_24112000000120609464_\u4e2d\u6d77\u6210\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8_20240903094409.pdf"}}]}],"contractScans":[{"id":28387,"object_type":105,"object_id":3465,"attachment_id":20890,"attachment":{"id":20890,"key":20890,"name":"de2dca7f-c1cb-3b3f-bcf2-b5eb798dd38c","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/de2dca7f-c1cb-3b3f-bcf2-b5eb798dd38c\/\u4e2d\u6d77\u6210.pdf","orig_name":"\u4e2d\u6d77\u6210.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":7500,"projectProductTotalAmount":7500,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":7500,"un_invoiced":0,"collected":7500,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3337,"client_id":3271,"signed_at":"2024-06-04","amount":"7500","handler":5295,"description":"","created_by":5295,"created_at":"2024-06-06 10:42:15","updated_at":"2024-07-25 15:05:53","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3560,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSC-WZW-2024060415","payment_collection_remind_ahead":"7 days","from_project":3560,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-06-06 10:43:20.370887+08","b_date":null,"passed":1,"client":{"id":3271,"key":3271,"name":"\u4e2d\u6d77\u6210\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3337,"comment":5},"project":{"id":3560,"key":3560,"name":"\u6280\u672f\u670d\u52a1"},"fromProject":{"id":3560,"key":3560,"name":"\u6280\u672f\u670d\u52a1","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":437,"bargain_date":"2024-06-04","collected":"7500","profit_pct":"93","budget":"7500","projectProductTypes":[{"id":2273,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"7500","pct":"93","project_id":3560,"profit":"6975"}],"projectProductRels":[{"id":5599,"project_id":3560,"product_id":941,"amount":"7500","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-06-04","hardware_to":null,"software_to":null,"maintenance_to":"2024-06-30","total_amount":"7500","total_cost":"0","supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":11301,"project_id":3560}],"reimbursementAmountSum":{"project_id":3560,"sum":"662.99"},"profit":6975,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8284,"user_id":5311,"key":5311,"contract_id":3337,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":5882,"user_id":5295,"key":5295,"contract_id":3337,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":5883,"user_id":1001,"key":1001,"contract_id":3337,"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"}}},{"id":5884,"user_id":5388,"key":5388,"contract_id":3337,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1732,"key":1732,"contract_id":3337,"name":"2024-08-05","value":"7500","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1864,"key":1864,"contract_id":3337,"value":"7500","created_by":1013,"created_at":"2024-06-07 14:21:57","description":"","collected_date":"2024-06-07","amount":"7500","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":26357,"object_type":109,"object_id":1864,"attachment_id":19626,"attachment":{"id":19626,"key":19626,"name":"fbd2a1c6-016f-365b-acdd-2dffbfef9b6e","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/fbd2a1c6-016f-365b-acdd-2dffbfef9b6e\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1679,"key":1679,"contract_id":3337,"value":"7500.00","attachment_id":null,"from_date":"2024-06-06","attachment":null,"attachmentRelationships":[],"files":[{"id":26337,"object_type":102,"object_id":1679,"attachment_id":19609,"attachment":{"id":19609,"key":19609,"name":"84bbb710-b54c-3cf1-85c4-ab794e9dc4db","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/84bbb710-b54c-3cf1-85c4-ab794e9dc4db\/dzfp_24112000000055557084_\u4e2d\u6d77\u6210\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8_20240606134459.pdf","orig_name":"dzfp_24112000000055557084_\u4e2d\u6d77\u6210\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8_20240606134459.pdf"}}]}],"contractScans":[{"id":27380,"object_type":105,"object_id":3337,"attachment_id":19607,"attachment":{"id":19607,"key":19607,"name":"e132f900-62f0-322d-ad3a-6e38dc66d581","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/e132f900-62f0-322d-ad3a-6e38dc66d581\/2024_06_06_10_45_47.pdf","orig_name":"2024_06_06_10_45_47.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":7500,"projectProductTotalAmount":7500,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":7500,"un_invoiced":0,"collected":7500,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3302,"client_id":42,"signed_at":"2024-05-21","amount":"1400","handler":5295,"description":"","created_by":5015,"created_at":"2024-05-20 17:53:57","updated_at":"2024-06-04 09:58:32","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3545,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2024052159","payment_collection_remind_ahead":"7 days","from_project":3545,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-05-21 11:26:11.140995+08","b_date":null,"passed":1,"client":{"id":42,"key":42,"name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":3302,"comment":6},"project":{"id":3545,"key":3545,"name":"\u65b0\u8d2d2\u5757\u786c\u76d8-G"},"fromProject":{"id":3545,"key":3545,"name":"\u65b0\u8d2d2\u5757\u786c\u76d8-G","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":404,"bargain_date":"2024-05-21","collected":"1400","profit_pct":"60.14","budget":"1400","projectProductTypes":[{"id":2742,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1400","pct":"60.14","project_id":3545,"profit":"841.96"}],"projectProductRels":[{"id":4990,"project_id":3545,"product_id":276,"amount":"700","number":2,"cost":"200","description":"","supplier_id":608,"hardware_from":"2024-05-21","software_from":null,"maintenance_from":null,"hardware_to":"2027-05-20","software_to":null,"maintenance_to":null,"total_amount":"1400","total_cost":"400","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":276,"name":"49Y1860","product_type":3,"product_component":15,"product_brand":4,"product_serie":1125,"product_misc":4,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-09-12 18:57:28","updated_at":"2024-02-01 10:55:25","pinyin_shortcut":"49Y1860","product_unit":4,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1125,"key":1125,"name":"\u8054\u60f3300G 15K 3.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":9226,"project_id":3545},{"id":9225,"project_id":3545}],"reimbursementAmountSum":null,"profit":841.96,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":442,"contract_id":3302,"supplier_id":608,"purchase_id":3304,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":3304,"key":3304,"serial_no":"\u8ba2\u5355\u53f7: 3897591337104161702"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8305,"user_id":5311,"key":5311,"contract_id":3302,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":5265,"user_id":5295,"key":5295,"contract_id":3302,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":5266,"user_id":1001,"key":1001,"contract_id":3302,"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"}}},{"id":5267,"user_id":5388,"key":5388,"contract_id":3302,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1671,"key":1671,"contract_id":3302,"name":"2024-07-05","value":"1400","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1869,"key":1869,"contract_id":3302,"value":"1400","created_by":1013,"created_at":"2024-06-12 11:09:33","description":"","collected_date":"2024-06-12","amount":"1400","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":26401,"object_type":109,"object_id":1869,"attachment_id":19666,"attachment":{"id":19666,"key":19666,"name":"de05bda0-7ead-30ac-a3e3-4a76d5ab44ac","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/de05bda0-7ead-30ac-a3e3-4a76d5ab44ac\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1671,"key":1671,"contract_id":3302,"value":"1400.00","attachment_id":null,"from_date":"2024-05-29","attachment":null,"attachmentRelationships":[],"files":[{"id":26165,"object_type":102,"object_id":1671,"attachment_id":19484,"attachment":{"id":19484,"key":19484,"name":"ea0e4e20-f0d5-388e-97b7-f03463950950","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/ea0e4e20-f0d5-388e-97b7-f03463950950\/dzfp_24112000000049395688_\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8_20240529100849.pdf","orig_name":"dzfp_24112000000049395688_\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8_20240529100849.pdf"}}]}],"contractScans":[{"id":26273,"object_type":105,"object_id":3302,"attachment_id":19341,"attachment":{"id":19341,"key":19341,"name":"29c3a73f-c27a-3dbc-b586-09e487629e6b","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/29c3a73f-c27a-3dbc-b586-09e487629e6b\/2024_05_21_09_47_45.pdf","orig_name":"2024_05_21_09_47_45.pdf"}}],"receiptScans":[{"id":26073,"object_type":106,"object_id":3302,"attachment_id":19409,"attachment":{"id":19409,"key":19409,"name":"2785127c-402c-3258-bba9-4f69937981f2","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/2785127c-402c-3258-bba9-4f69937981f2\/2024_05_24_09_31_37.pdf","orig_name":"2024_05_24_09_31_37.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":1400,"projectProductTotalAmount":1400,"projectProductAllAmount":true,"projectProductTotalCost":400,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":1400,"un_invoiced":0,"collected":1400,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3246,"client_id":2839,"signed_at":"2024-04-24","amount":"21358","handler":5364,"description":"","created_by":5364,"created_at":"2024-04-24 15:26:29","updated_at":"2024-07-09 17:06:31","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3509,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSKJ20240429-WYC-001","payment_collection_remind_ahead":"7 days","from_project":3509,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-05-24 16:30:45.871052+08","b_date":null,"passed":1,"client":{"id":2839,"key":2839,"name":"\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5364,"key":5364,"name":"\u738b\u827a\u742e","sex":"F","department_id":1,"avatar":{"id":154,"user_id":5364,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a0b46fdc-d67f-305c-82e5-5b2e01c08e21.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3246,"comment":6},"project":{"id":3509,"key":3509,"name":"\u670d\u52a1\u5668\u91c7\u8d2d"},"fromProject":{"id":3509,"key":3509,"name":"\u670d\u52a1\u5668\u91c7\u8d2d","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":413,"bargain_date":"2024-04-24","collected":"21358","profit_pct":"6.83","budget":"21358","projectProductTypes":[{"id":3858,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"829","pct":"6.83","project_id":3509,"profit":"56.6207"},{"id":4395,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"20529","pct":"6.83","project_id":3509,"profit":"1402.1307"}],"projectProductRels":[{"id":5076,"project_id":3509,"product_id":1578,"amount":"8400","number":1,"cost":"6700","description":"","supplier_id":212,"hardware_from":"2024-04-12","software_from":null,"maintenance_from":null,"hardware_to":"2027-04-15","software_to":null,"maintenance_to":null,"total_amount":"8400","total_cost":"6700","supplier":{"id":212,"key":212,"name":"\u5317\u4eac\u91d1\u9a6c\u65f6\u4ee3\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u4e2d\u521b\u6da6\u9526\uff08\u5317\u4eac\uff09\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1578,"name":"PowerEdge T150","product_type":2,"product_component":2,"product_brand":9,"product_serie":1353,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-04-25 10:59:02","updated_at":"2024-04-25 10:59:02","pinyin_shortcut":"PowerEdgeT150","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":9,"key":9,"name":"\u6234\u5c14\uff08DELL\uff09"},"productSerie":{"id":1353,"key":1353,"name":"PowerEdge T150 \u5854\u5f0f\u670d\u52a1\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":5077,"project_id":3509,"product_id":1579,"amount":"829","number":1,"cost":"790","description":"","supplier_id":280,"hardware_from":"2024-05-22","software_from":null,"maintenance_from":null,"hardware_to":"2025-05-22","software_to":null,"maintenance_to":null,"total_amount":"829","total_cost":"790","supplier":{"id":280,"key":280,"name":"\u5317\u4eac\u6210\u6d77\u661f\u6cb3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1579,"name":"S5024PV5-El","product_type":4,"product_component":19,"product_brand":20,"product_serie":1354,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-04-25 11:01:38","updated_at":"2024-04-25 11:01:38","pinyin_shortcut":"S5024PV5El","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1354,"key":1354,"name":"H3C S5024PV5-El \u4ee5\u592a\u7f51\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":5078,"project_id":3509,"product_id":904,"amount":"4043","number":3,"cost":"3450","description":"","supplier_id":505,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"12129","total_cost":"10350","supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u795e\u5dde\u540c\u6b63\u8ba1\u7b97\u673a\u8bbe\u5907\u6709\u9650\u516c\u53f8"},"product":{"id":904,"name":"ECI-521","product_type":11,"product_component":33,"product_brand":4,"product_serie":567,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-03-09 10:45:39","updated_at":"2024-02-01 14:35:11","pinyin_shortcut":"ECI521","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":33,"key":33,"name":"\u53f0\u5f0f\u673a\u4e3b\u673a"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":567,"key":567,"name":"\u8054\u60f3ECI-521\u53f0\u5f0f\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":5079,"project_id":3509,"product_id":1621,"amount":"0","number":3,"cost":"450","description":"","supplier_id":505,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"1350","supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u795e\u5dde\u540c\u6b63\u8ba1\u7b97\u673a\u8bbe\u5907\u6709\u9650\u516c\u53f8"},"product":{"id":1621,"name":"HU23238FB0","product_type":11,"product_component":154,"product_brand":4,"product_serie":1381,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-22 11:15:29","updated_at":"2024-05-22 11:15:29","pinyin_shortcut":"HU23238FB0","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":154,"key":154,"name":"\u663e\u793a\u5668"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1381,"key":1381,"name":"\u8054\u60f3 23.8\u5bf8\u6765\u9177\u6db2\u6676\u663e\u793a\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":9245,"project_id":3509},{"id":9244,"project_id":3509},{"id":9243,"project_id":3509},{"id":9242,"project_id":3509},{"id":9241,"project_id":3509},{"id":9240,"project_id":3509},{"id":9239,"project_id":3509},{"id":9238,"project_id":3509}],"reimbursementAmountSum":null,"profit":1458.7514,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":620,"contract_id":3246,"supplier_id":280,"purchase_id":3305,"supplier":{"id":280,"key":280,"name":"\u5317\u4eac\u6210\u6d77\u661f\u6cb3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3305,"key":3305,"serial_no":"A20240521"}},{"id":709,"contract_id":3246,"supplier_id":212,"purchase_id":3307,"supplier":{"id":212,"key":212,"name":"\u5317\u4eac\u91d1\u9a6c\u65f6\u4ee3\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u4e2d\u521b\u6da6\u9526\uff08\u5317\u4eac\uff09\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3307,"key":3307,"serial_no":"TSKJ20240521-ZHF-001"}},{"id":1492,"contract_id":3246,"supplier_id":505,"purchase_id":3391,"supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u795e\u5dde\u540c\u6b63\u8ba1\u7b97\u673a\u8bbe\u5907\u6709\u9650\u516c\u53f8"},"purchase":{"id":3391,"key":3391,"serial_no":"TSKJ20240521-ZHF-002"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5364,"key":5364,"name":"\u738b\u827a\u742e","sex":"F","department_id":1,"avatar":{"id":154,"user_id":5364,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a0b46fdc-d67f-305c-82e5-5b2e01c08e21.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8151,"user_id":5311,"key":5311,"contract_id":3246,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":5317,"user_id":1001,"key":1001,"contract_id":3246,"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"}}},{"id":5318,"user_id":5388,"key":5388,"contract_id":3246,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1680,"key":1680,"contract_id":3246,"name":"2024-07-08","value":"21358","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1893,"key":1893,"contract_id":3246,"value":"21358","created_by":1013,"created_at":"2024-07-05 14:27:34","description":"","collected_date":"2024-07-05","amount":"21358","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":26839,"object_type":109,"object_id":1893,"attachment_id":20078,"attachment":{"id":20078,"key":20078,"name":"22ec9ee3-6f92-3e5c-abff-819b5b149642","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/22ec9ee3-6f92-3e5c-abff-819b5b149642\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1681,"key":1681,"contract_id":3246,"value":"21358.00","attachment_id":null,"from_date":"2024-06-11","attachment":null,"attachmentRelationships":[],"files":[{"id":26391,"object_type":102,"object_id":1681,"attachment_id":19658,"attachment":{"id":19658,"key":19658,"name":"b9d2bc42-5366-3d24-b454-bca72a670993","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/b9d2bc42-5366-3d24-b454-bca72a670993\/dzfp_24112000000058055963_\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20240611141838.pdf","orig_name":"dzfp_24112000000058055963_\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20240611141838.pdf"}}]}],"contractScans":[{"id":26299,"object_type":105,"object_id":3246,"attachment_id":18914,"attachment":{"id":18914,"key":18914,"name":"da955a80-8f3a-37d9-bb5c-70f8765b5f2b","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/da955a80-8f3a-37d9-bb5c-70f8765b5f2b\/2024_04_29_17_54_40.pdf","orig_name":"2024_04_29_17_54_40.pdf"}},{"id":26300,"object_type":105,"object_id":3246,"attachment_id":19372,"attachment":{"id":19372,"key":19372,"name":"c1c25abf-7834-3056-8f82-d04a3559ccfe","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/c1c25abf-7834-3056-8f82-d04a3559ccfe\/\u53d8\u66f4\u534f\u8bae.pdf","orig_name":"\u53d8\u66f4\u534f\u8bae.pdf"}}],"receiptScans":[{"id":26962,"object_type":106,"object_id":3246,"attachment_id":20175,"attachment":{"id":20175,"key":20175,"name":"41201bc0-3163-312c-91fa-def8b202a8f6","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/41201bc0-3163-312c-91fa-def8b202a8f6\/\u62d3\u5b9e\u8bbe\u5907\u7b7e\u6536.pdf","orig_name":"\u62d3\u5b9e\u8bbe\u5907\u7b7e\u6536.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":21358,"projectProductTotalAmount":21358,"projectProductAllAmount":true,"projectProductTotalCost":19190,"projectProductAllCost":true,"projectProductTotalCount":8,"invoiced":21358,"un_invoiced":0,"collected":21358,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3108,"client_id":1331,"signed_at":"2024-01-23","amount":"25860","handler":5300,"description":"","created_by":5300,"created_at":"2024-01-25 23:19:14","updated_at":"2024-04-03 16:04:42","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3404,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-2023122264","payment_collection_remind_ahead":"7 days","from_project":3404,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":1331,"key":1331,"name":"\u4e09\u76db\u667a\u6167\u6559\u80b2\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3108,"comment":5},"project":{"id":3404,"key":3404,"name":"\u6df1\u4fe1\u670d+Veeam\u7eed\u4fdd-2023-K"},"fromProject":{"id":3404,"key":3404,"name":"\u6df1\u4fe1\u670d+Veeam\u7eed\u4fdd-2023-K","description":"","total_contact_point":"8350","paid_contact_point":"8350","is_sales_order_ready":true,"project_product_version_id":290,"bargain_date":"2024-01-23","collected":"25860","profit_pct":"-5.12","budget":"25860","projectProductTypes":[{"id":4941,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"25860.00","pct":"-5.12","project_id":3404,"profit":"-1324.032"}],"projectProductRels":[{"id":4123,"project_id":3404,"product_id":1492,"amount":"1350","number":1,"cost":"1178","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1350","total_cost":"1178","supplier":null,"product":{"id":1492,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1300A\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":743,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-03-05 17:56:36","updated_at":"2024-03-05 17:56:36","pinyin_shortcut":"sxfaqynyzdyrjV80syyAF1000FH1300A","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":743,"key":743,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":4124,"project_id":3404,"product_id":1493,"amount":"1350","number":1,"cost":"1178","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1350","total_cost":"1178","supplier":null,"product":{"id":1493,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u9274\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1300A\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":744,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-03-05 17:57:19","updated_at":"2024-03-05 17:57:19","pinyin_shortcut":"sxfaqynyjdyrjV80syyAF1000FH1300A","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":744,"key":744,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u9274\u8ba2\u9605\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":4125,"project_id":3404,"product_id":1494,"amount":"1060","number":1,"cost":"942","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1060","total_cost":"942","supplier":null,"product":{"id":1494,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08AF-1000-FH1300A\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":739,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-03-05 17:59:36","updated_at":"2024-03-05 17:59:36","pinyin_shortcut":"sxfcpzbrjsjfwAF1000FH1300A","product_unit":8,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":739,"key":739,"name":"\u6df1\u4fe1\u670d\u8f6f\u4ef6\u786c\u4ef6\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}},{"id":4126,"project_id":3404,"product_id":1495,"amount":"6100","number":1,"cost":"2700","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"6100","total_cost":"2700","supplier":null,"product":{"id":1495,"name":"EDR","product_type":7,"product_component":41,"product_brand":12,"product_serie":523,"product_misc":null,"product_qa":null,"pn":"","description":"15\u4e2aPC\u9ad8\u7ea7\u7248\uff0c15\u4e2a\u670d\u52a1\u5668\u65d7\u8230\u7248","created_by":1013,"created_at":"2024-03-05 18:02:19","updated_at":"2024-03-05 18:02:19","pinyin_shortcut":"EDR","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":523,"key":523,"name":"EDR\u5e73\u53f0\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":4127,"project_id":3404,"product_id":1511,"amount":"16000","number":1,"cost":"9717","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"16000","total_cost":"9717","supplier":null,"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":null,"product_qa":null,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2024-03-13 17:49:30","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[{"id":440,"project_id":3404,"contact_id":2916,"point":"8350.00","paid_point":"8350","contact":{"id":2916,"key":2916,"name":"\u9ad8\u78ca","client_id":1331,"supplier_id":null,"client":{"id":1331,"key":1331,"name":"\u4e09\u76db\u667a\u6167\u6559\u80b2\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":81,"project_id":3404,"contact_id":2916,"point":"8350.00","day_at":"2024-03-29","description":"","created_at":"2024-03-29 13:36:27"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":8932,"project_id":3404},{"id":8933,"project_id":3404},{"id":8934,"project_id":3404},{"id":8935,"project_id":3404},{"id":8931,"project_id":3404}],"reimbursementAmountSum":{"project_id":3404,"sum":"30"},"profit":-1324.032,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":444,"contract_id":3108,"supplier_id":236,"purchase_id":3144,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3144,"key":3144,"serial_no":"TSKJ20240222-ZHF-001"}},{"id":1989,"contract_id":3108,"supplier_id":659,"purchase_id":3178,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":3178,"key":3178,"serial_no":"XM20240312000200"}},{"id":2538,"contract_id":3108,"supplier_id":689,"purchase_id":3850,"supplier":{"id":689,"key":689,"name":"\u8d39\u7528\u5408\u540c\u65b0\u5efa"},"purchase":{"id":3850,"key":3850,"serial_no":"\u8d39\u7528\u5408\u540c\u7f16\u53f7"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8261,"user_id":5311,"key":5311,"contract_id":3108,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4966,"user_id":5300,"key":5300,"contract_id":3108,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1540,"key":1540,"contract_id":3108,"name":"2024-02-29","value":"25860","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1788,"key":1788,"contract_id":3108,"value":"25860","created_by":1014,"created_at":"2024-02-27 15:10:54","description":"","collected_date":"2024-02-27","amount":"25860","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[{"id":24162,"object_type":109,"object_id":1788,"attachment_id":17774,"attachment":{"id":17774,"key":17774,"name":"70096745-1af0-36c1-a696-6b04bcfe7a56","extension":"png","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/70096745-1af0-36c1-a696-6b04bcfe7a56\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1590,"key":1590,"contract_id":3108,"value":"25860.00","attachment_id":null,"from_date":"2024-01-26","attachment":null,"attachmentRelationships":[],"files":[{"id":23766,"object_type":102,"object_id":1590,"attachment_id":17432,"attachment":{"id":17432,"key":17432,"name":"77ed0b7d-16cd-3621-a34e-89396163dd36","extension":"pdf","path":"\/v2\/attachment\/view\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/77ed0b7d-16cd-3621-a34e-89396163dd36\/dzfp_24112000000003222226_\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8_20240126160731.pdf","orig_name":"dzfp_24112000000003222226_\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8_20240126160731.pdf"}}]}],"contractScans":[{"id":24945,"object_type":105,"object_id":3108,"attachment_id":17421,"attachment":{"id":17421,"key":17421,"name":"d70772ed-61b3-3e29-9a2a-ee29ecef272a","extension":"pdf","path":"\/v2\/attachment\/preview\/aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b\/d70772ed-61b3-3e29-9a2a-ee29ecef272a\/\u6c47\u51a0\u89e6\u6478.pdf","orig_name":"\u6c47\u51a0\u89e6\u6478.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":25860,"projectProductTotalAmount":25860,"projectProductAllAmount":true,"projectProductTotalCost":15715,"projectProductAllCost":true,"projectProductTotalCount":5,"invoiced":25860,"un_invoiced":0,"collected":25860,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true}],"pagenation":{"totalcount":181,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-25 10:39:49') RETURNING "id" |