68737ab4b6ea5: POST https://beta.jinchangxiao.com/v2/sales-contract/of-client at 2025-07-13 05:21:56 pm by 120.244.156.33
Database Queries
总计62条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 17:21:56.753 | 3.1 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc' |
| 17:21:56.757 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 17:21:56.762 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='2094') AND ("deleted"=FALSE) |
| 17:21:56.771 | 7.6 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 "client"."id"='2094' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 17:21:56.779 | 9.1 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 "client"."id"='2094' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 |
| 17:21:56.789 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2094 |
| 17:21:56.790 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005 |
| 17:21:56.790 | 0.4 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005) |
| 17:21:56.791 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=8114 |
| 17:21:56.792 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005 |
| 17:21:56.792 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005) |
| 17:21:56.792 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 17:21:56.793 | 21.1 ms | SELECT | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3649, 3636, 3170, 2732, 2733, 2551, 2014)) GROUP BY "object_id" |
| 17:21:56.814 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2590) |
| 17:21:56.815 | 0.5 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 (3704, 3701, 3468, 3241, 3242, 3086, 2590) |
| 17:21:56.816 | 1.1 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 (2590, 3086, 3241, 3242, 3468, 3701, 3704) |
| 17:21:56.817 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (2590, 3086, 3241, 3242, 3468, 3701, 3704) |
| 17:21:56.819 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (496, 138, 316) |
| 17:21:56.819 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1862, 1871, 1872, 1863, 1864, 1865, 1866, 1867, 1868, 1873, 1874, 1196, 1197, 1869, 1870, 942, 1850, 1615, 625, 909, 916, 917, 941) |
| 17:21:56.820 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 19, 5, 7) |
| 17:21:56.821 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (19, 151, 20, 35, 26, 43, 188, 68, 51, 24) |
| 17:21:56.822 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (7, 134, 133, 12, 88) |
| 17:21:56.822 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1376, 593, 592, 1558, 104, 1565, 1033, 103, 1566, 749, 744, 377, 1449, 1567, 1568, 572, 577, 1232, 748) |
| 17:21:56.823 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (1, 7, 2, 6, 3) |
| 17:21:56.824 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (2590, 3086, 3241, 3242, 3468, 3701, 3704) |
| 17:21:56.824 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (4844, 1314) |
| 17:21:56.825 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (149, 2598) |
| 17:21:56.825 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((4844, 3468), (1314, 3704), (1314, 3701)) |
| 17:21:56.826 | 3.8 ms | SELECT | SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (2590, 3086, 3241, 3242, 3468, 3701, 3704)) |
| 17:21:56.830 | 2.4 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (2590, 3086, 3241, 3242, 3468, 3701, 3704)) GROUP BY "project_id" |
| 17:21:56.833 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3649, 3636, 3170, 2732, 2733, 2551, 2014) |
| 17:21:56.834 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (123, 496, 138, 425, 424, 665, 314) |
| 17:21:56.834 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (2082, 2567, 2012, 2036, 2046, 2017, 2728, 2729, 3641, 2016, 2714, 3650, 3654, 3707) |
| 17:21:56.835 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 17:21:56.835 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005 |
| 17:21:56.836 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005) |
| 17:21:56.836 | 0.5 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 (3649, 3636, 3170, 2732, 2733, 2551, 2014)) ORDER BY "remind_date" |
| 17:21:56.837 | 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 (3649, 3636, 3170, 2732, 2733, 2551, 2014) |
| 17:21:56.837 | 0.7 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3649, 3636, 3170, 2732, 2733, 2551, 2014) |
| 17:21:56.838 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1005) |
| 17:21:56.839 | 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 (1011, 1005)) |
| 17:21:56.839 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3649, 3636, 3170, 2732, 2733, 2551, 2014) |
| 17:21:56.840 | 0.6 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 (3649, 3636, 3170, 2732, 2733, 2551, 2014) |
| 17:21:56.840 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5388, 1001) |
| 17:21:56.848 | 4.1 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5388, 1005)) |
| 17:21:56.855 | 2.9 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 (3649, 3636, 3170, 2732, 2733, 2551, 2014) ORDER BY "remind_date" |
| 17:21:56.859 | 0.8 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 (3649, 3636, 3170, 2732, 2733, 2551, 2014) ORDER BY "id" |
| 17:21:56.860 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1014, 1013) |
| 17:21:56.860 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (1201, 1555, 1577, 1598, 1801, 1828, 2016, 2022)) |
| 17:21:56.862 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22881, 18032, 18785, 22809) |
| 17:21:56.863 | 0.9 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3649, 3636, 3170, 2732, 2733, 2551, 2014) ORDER BY "id" |
| 17:21:56.864 | 1.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=8031 |
| 17:21:56.866 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1096, 1351, 1433, 1442, 1613, 1631, 1854, 1861)) |
| 17:21:56.868 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1096, 1351, 1433, 1442, 1613, 1631, 1854, 1861)) |
| 17:21:56.870 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (8031, 12147, 13923, 14104, 22700, 22522, 17898, 18554) |
| 17:21:56.870 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3649, 3636, 3170, 2732, 2733, 2551, 2014)) |
| 17:21:56.872 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (8114, 22513, 17887, 13794, 13795, 12073, 22334) |
| 17:21:56.873 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3649, 3636, 3170, 2732, 2733, 2551, 2014)) |
| 17:21:56.875 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (11249, 12770, 14028, 14569, 23354) |
| 17:21:56.876 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3649, 3636, 3170, 2732, 2733, 2551, 2014)) |
| 17:21:56.878 | 27.5 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1004 AND is_read = false) AND ("object_id" IN (3649, 3636, 3170, 2732, 2733, 2551, 2014)) GROUP BY "object_id" |
| 17:21:56.909 | 4.0 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1004, 2, 1141, 'v2/sales-contract/of-client', '{"access_token":"NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc","device_type":"2","id":"2094","page":"1","posttime":"1752398464","token":"3c4b10916ba7ae8eba027d87f520fbc0","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":3649,"client_id":2094,"signed_at":"2024-11-04","amount":"217500","handler":1005,"description":"","created_by":1005,"created_at":"2024-11-06 09:37:20","updated_at":"2024-11-18 09:46:09","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3704,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHY-2024110401","payment_collection_remind_ahead":"7 days","from_project":3704,"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-18 11:01:22.730605+08","b_date":null,"passed":1,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3649,"comment":7},"project":{"id":3704,"key":3704,"name":"\u5ba2\u6237\u81ea\u7528-\u6df1\u4fe1\u670d\u9632\u706b\u5899\uff0c\u8d1f\u8f7d\uff0c\u4ea4\u6362\u673a"},"fromProject":{"id":3704,"key":3704,"name":"\u5ba2\u6237\u81ea\u7528-\u6df1\u4fe1\u670d\u9632\u706b\u5899\uff0c\u8d1f\u8f7d\uff0c\u4ea4\u6362\u673a","description":"","total_contact_point":"7575","paid_contact_point":"7575","is_sales_order_ready":true,"project_product_version_id":707,"bargain_date":"2024-11-04","collected":"217500","profit_pct":"24.99","budget":"217500","projectProductTypes":[{"id":5727,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"84700.00","pct":"24.99","project_id":3704,"profit":"21166.53"},{"id":5728,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"132800.00","pct":"24.99","project_id":3704,"profit":"33186.72"}],"projectProductRels":[{"id":7998,"project_id":3704,"product_id":1862,"amount":"33900","number":2,"cost":"31064","description":"","supplier_id":496,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"67800","total_cost":"62128","supplier":{"id":496,"key":496,"name":"\u5317\u4eac\u839e\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1862,"name":"RS6300-50Q-EI-24X","product_type":4,"product_component":19,"product_brand":88,"product_serie":1565,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 09:41:39","updated_at":"2024-11-08 09:41:39","pinyin_shortcut":"RS630050QEI24X","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":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":1565,"key":1565,"name":"\u4fe1\u9510RS6300\u5b89\u89c6\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":7999,"project_id":3704,"product_id":1871,"amount":"0","number":24,"cost":"289","description":"","supplier_id":496,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"6936","supplier":{"id":496,"key":496,"name":"\u5317\u4eac\u839e\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1871,"name":"SFP-10G-MM850","product_type":4,"product_component":43,"product_brand":88,"product_serie":1567,"product_misc":null,"product_qa":null,"pn":"","description":"\u4fe1\u9510\u591a\u6a21\u5149\u7ea4\u6a21\u5757","created_by":1013,"created_at":"2024-11-08 11:10:04","updated_at":"2024-11-08 11:10:44","pinyin_shortcut":"SFP10GMM850","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":1567,"key":1567,"name":"\u4fe1\u9510\u4e07\u5146\u591a\u6a21\u5343\u5146\u5149\u7ea4\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":8000,"project_id":3704,"product_id":1872,"amount":"0","number":24,"cost":"39","description":"","supplier_id":496,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"936","supplier":{"id":496,"key":496,"name":"\u5317\u4eac\u839e\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1872,"name":"\u5149\u7ea4\u8df3\u7ebf-\u53cc\u8054-\u591a\u6a21-LC-LC-3M","product_type":4,"product_component":43,"product_brand":88,"product_serie":1568,"product_misc":null,"product_qa":null,"pn":"","description":"\u5149\u7ea4\u8df3\u7ebf","created_by":1013,"created_at":"2024-11-08 11:12:13","updated_at":"2024-11-08 11:12:13","pinyin_shortcut":"gxtxsldmLCLC3M","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":1568,"key":1568,"name":"\u4fe1\u95103M LC-LC\u5149\u7ea4\u8df3\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}},{"id":8001,"project_id":3704,"product_id":1863,"amount":"32500","number":2,"cost":"2126","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"65000","total_cost":"4252","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1863,"name":"AF-1000-FH1600B-VX","product_type":5,"product_component":26,"product_brand":12,"product_serie":1033,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:40:03","updated_at":"2024-11-08 10:40:03","pinyin_shortcut":"AF1000FH1600BVX","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1033,"key":1033,"name":"\u6df1\u4fe1\u670d AF-1000\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8002,"project_id":3704,"product_id":1864,"amount":"0","number":2,"cost":"5200.49","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"10400.98","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1864,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B-VX\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:42:14","updated_at":"2024-11-08 10:42:14","pinyin_shortcut":"sxffhqrjV80syyAF1000FH1600BVX","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8003,"project_id":3704,"product_id":1865,"amount":"0","number":2,"cost":"759.04","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"1518.08","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1865,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u589e\u5f3a\u7ea7\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B-VX\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:42:57","updated_at":"2024-11-08 10:42:57","pinyin_shortcut":"sxffhqzqjrjV80syyAF1000FH1600BVX","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8004,"project_id":3704,"product_id":1866,"amount":"0","number":6,"cost":"759.04","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"4554.24","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1866,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0\uff08\u7f51\u5173\u6740\u6bd2\u66f4\u65b0\uff09\uff08\u9002\u7528\u4e8eAF-1000-FH1600B-VX\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":1566,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:49:40","updated_at":"2024-11-08 10:49:40","pinyin_shortcut":"sxfwgsdrjV60wgsdgxsyyAF1000FH1600BVX","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1566,"key":1566,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8005,"project_id":3704,"product_id":1867,"amount":"0","number":2,"cost":"759.04","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"1518.08","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1867,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0\uff08\u7f51\u5173\u6740\u6bd2\u6a21\u5757\uff09\uff08\u9002\u7528\u4e8eAF-1000-FH1600B-VX\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":1566,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:50:35","updated_at":"2024-11-08 10:50:35","pinyin_shortcut":"sxfwgsdrjV60wgsdmksyyAF1000FH1600BVX","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1566,"key":1566,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8006,"project_id":3704,"product_id":1868,"amount":"0","number":6,"cost":"759.04","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"4554.24","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1868,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B-VX\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-11-08 10:51:47","updated_at":"2024-11-08 10:51:47","pinyin_shortcut":"sxfaqynyzdyrjV80syyAF1000FH1600BVX","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":8007,"project_id":3704,"product_id":1873,"amount":"0","number":2,"cost":"1831.1","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"3662.2","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1873,"name":"\u6df1\u4fe1\u670dSSL VPN\u8f6f\u4ef6V6.0","product_type":5,"product_component":35,"product_brand":12,"product_serie":104,"product_misc":null,"product_qa":null,"pn":"","description":"\u79fb\u52a8\u63a5\u5165\u6388\u6743\u6a21\u5757","created_by":1013,"created_at":"2024-11-08 11:16:40","updated_at":"2024-11-08 11:16:40","pinyin_shortcut":"sxfSSLVPNrjV60","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":104,"key":104,"name":"\u6df1\u4fe1\u670dVPN\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8008,"project_id":3704,"product_id":1874,"amount":"0","number":50,"cost":"82.55","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"4127.50","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1874,"name":"\u6df1\u4fe1\u670dSSL VPN\u6388\u6743\u8f6f\u4ef6 V6.0","product_type":5,"product_component":35,"product_brand":12,"product_serie":104,"product_misc":null,"product_qa":null,"pn":"","description":"\u79fb\u52a8\u63a5\u5165\u6388\u6743","created_by":1013,"created_at":"2024-11-08 11:17:07","updated_at":"2024-11-08 11:17:07","pinyin_shortcut":"sxfSSLVPNsqrjV60","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":104,"key":104,"name":"\u6df1\u4fe1\u670dVPN\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8009,"project_id":3704,"product_id":1196,"amount":"0","number":4,"cost":"244","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"976","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1196,"name":"\u5343\u5146\u591a\u6a21-850-550m-\u53cc\u7ea4","product_type":4,"product_component":43,"product_brand":12,"product_serie":748,"product_misc":null,"product_qa":null,"pn":"","description":"SFP\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757\uff0c\u901f\u7387\uff1a1.25Gb\/s\uff0c\u6ce2\u957f\uff1a850nm\uff0c\u4f20\u8f93\u8ddd\u79bb\uff1a0.55km\uff0c\u53ccLC\u63a5\u53e3","created_by":1013,"created_at":"2024-01-09 16:10:20","updated_at":"2024-01-09 16:10:20","pinyin_shortcut":"qzdm850550msx","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":748,"key":748,"name":"\u6df1\u4fe1\u670d\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":8010,"project_id":3704,"product_id":1197,"amount":"0","number":4,"cost":"48","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"192","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1197,"name":"\u5149\u7ea4\u7ebf-\u591a\u6a21-LC-LC-3M","product_type":4,"product_component":43,"product_brand":12,"product_serie":749,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-09 16:12:21","updated_at":"2024-01-09 16:12:21","pinyin_shortcut":"gxxdmLCLC3M","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":749,"key":749,"name":"\u6df1\u4fe1\u670d\u591a\u6a21-LC-LC\u5149\u7ea4\u8df3\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}},{"id":8011,"project_id":3704,"product_id":1869,"amount":"42350","number":2,"cost":"2879","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"84700","total_cost":"5758","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1869,"name":"AD-1000-B1200-VX","product_type":4,"product_component":68,"product_brand":12,"product_serie":377,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:53:07","updated_at":"2024-11-08 10:53:07","pinyin_shortcut":"AD1000B1200VX","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":68,"key":68,"name":"\u5e94\u7528\u4ea4\u4ed8\u7f51\u5173"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":377,"key":377,"name":"AD-1000\u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8012,"project_id":3704,"product_id":1870,"amount":"0","number":2,"cost":"13659.34","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"27318.68","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1870,"name":"\u6df1\u4fe1\u670d\u5e94\u7528\u4ea4\u4ed8\u8f6f\u4ef6V7.0\uff08\u9002\u7528\u4e8eAD-1000-B1200-VX\uff09","product_type":4,"product_component":51,"product_brand":12,"product_serie":1449,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:57:53","updated_at":"2024-11-08 10:57:53","pinyin_shortcut":"sxfyyjfrjV70syyAD1000B1200VX","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1449,"key":1449,"name":"\u6df1\u4fe1\u670d\u5e94\u7528\u4ea4\u4ed8\u8f6f\u4ef6V7.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8013,"project_id":3704,"product_id":1872,"amount":"0","number":4,"cost":"48","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"192","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1872,"name":"\u5149\u7ea4\u8df3\u7ebf-\u53cc\u8054-\u591a\u6a21-LC-LC-3M","product_type":4,"product_component":43,"product_brand":88,"product_serie":1568,"product_misc":null,"product_qa":null,"pn":"","description":"\u5149\u7ea4\u8df3\u7ebf","created_by":1013,"created_at":"2024-11-08 11:12:13","updated_at":"2024-11-08 11:12:13","pinyin_shortcut":"gxtxsldmLCLC3M","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":1568,"key":1568,"name":"\u4fe1\u95103M LC-LC\u5149\u7ea4\u8df3\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}},{"id":8014,"project_id":3704,"product_id":1196,"amount":"0","number":4,"cost":"244","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"976","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1196,"name":"\u5343\u5146\u591a\u6a21-850-550m-\u53cc\u7ea4","product_type":4,"product_component":43,"product_brand":12,"product_serie":748,"product_misc":null,"product_qa":null,"pn":"","description":"SFP\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757\uff0c\u901f\u7387\uff1a1.25Gb\/s\uff0c\u6ce2\u957f\uff1a850nm\uff0c\u4f20\u8f93\u8ddd\u79bb\uff1a0.55km\uff0c\u53ccLC\u63a5\u53e3","created_by":1013,"created_at":"2024-01-09 16:10:20","updated_at":"2024-01-09 16:10:20","pinyin_shortcut":"qzdm850550msx","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":748,"key":748,"name":"\u6df1\u4fe1\u670d\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":8015,"project_id":3704,"product_id":942,"amount":"0","number":1,"cost":"292.91","description":"\u8bbe\u5907\u5230\u4ed8\u5feb\u9012\u8d39","supplier_id":138,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"292.91","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","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":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}}],"projectContactPoints":[{"id":779,"project_id":3704,"contact_id":1314,"point":"7575.00","paid_point":"7575","contact":{"id":1314,"key":1314,"name":"\u8d3a\u840c\u840c","client_id":149,"supplier_id":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09"},"supplier":null},"projectContactPointRels":[{"id":140,"project_id":3704,"contact_id":1314,"point":"7575.00","day_at":"2024-12-18","description":"","created_at":"2024-12-18 11:01:22"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12246,"project_id":3704},{"id":12247,"project_id":3704},{"id":12256,"project_id":3704},{"id":12260,"project_id":3704},{"id":12259,"project_id":3704},{"id":12255,"project_id":3704},{"id":12254,"project_id":3704},{"id":12253,"project_id":3704},{"id":12252,"project_id":3704},{"id":12251,"project_id":3704},{"id":12250,"project_id":3704},{"id":12249,"project_id":3704},{"id":12248,"project_id":3704},{"id":12245,"project_id":3704},{"id":12244,"project_id":3704},{"id":12243,"project_id":3704},{"id":12257,"project_id":3704},{"id":12262,"project_id":3704},{"id":12261,"project_id":3704},{"id":12258,"project_id":3704},{"id":12328,"project_id":3704}],"reimbursementAmountSum":null,"profit":54353.25,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":2102,"contract_id":3649,"supplier_id":496,"purchase_id":3650,"supplier":{"id":496,"key":496,"name":"\u5317\u4eac\u839e\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3650,"key":3650,"serial_no":"TSKJ20241106-HYF-001"}},{"id":2103,"contract_id":3649,"supplier_id":138,"purchase_id":3654,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":3654,"key":3654,"serial_no":"SFXSH202411080052"}},{"id":2190,"contract_id":3649,"supplier_id":138,"purchase_id":3707,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":3707,"key":3707,"serial_no":"SXF-LX-20241212994"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7361,"user_id":1005,"key":1005,"contract_id":3649,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},{"id":7362,"user_id":5388,"key":5388,"contract_id":3649,"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":7363,"user_id":1001,"key":1001,"contract_id":3649,"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":2211,"key":2211,"contract_id":3649,"name":"2024-12-06","value":"217500","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2016,"key":2016,"contract_id":3649,"value":"217500","created_by":1013,"created_at":"2024-11-19 11:16:31","description":"","collected_date":"2024-11-19","amount":"217500","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":30529,"object_type":109,"object_id":2016,"attachment_id":22809,"attachment":{"id":22809,"key":22809,"name":"a01ba5ab-0224-32e6-9f2c-a60566f97161","extension":"png","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/a01ba5ab-0224-32e6-9f2c-a60566f97161\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1861,"key":1861,"contract_id":3649,"value":"217500.00","attachment_id":null,"from_date":"2024-11-15","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":30412,"object_type":102,"object_id":1861,"attachment_id":22700,"attachment":{"id":22700,"key":22700,"name":"8a0ac7d7-a305-3d36-b302-ffdb03e502ca","extension":"pdf","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/8a0ac7d7-a305-3d36-b302-ffdb03e502ca\/dzfp_24112000000182031075_\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8_20241115111348.pdf","orig_name":"dzfp_24112000000182031075_\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8_20241115111348.pdf"}}]}],"contractScans":[{"id":30423,"object_type":105,"object_id":3649,"attachment_id":22513,"attachment":{"id":22513,"key":22513,"name":"20c595ed-4407-322e-bc97-ca90d4d620f8","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/20c595ed-4407-322e-bc97-ca90d4d620f8\/\u4e2d\u5929\u950b217500.pdf","orig_name":"\u4e2d\u5929\u950b217500.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":217500,"projectProductTotalAmount":217500,"projectProductAllAmount":true,"projectProductTotalCost":140292.91,"projectProductAllCost":true,"projectProductTotalCount":143,"invoiced":217500,"un_invoiced":0,"collected":217500,"un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"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":3636,"client_id":2094,"signed_at":"2024-10-28","amount":"19350","handler":1005,"description":"","created_by":1005,"created_at":"2024-10-30 09:37:05","updated_at":"2024-12-23 15:35:15","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3701,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHY-2024102801","payment_collection_remind_ahead":"7 days","from_project":3701,"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-18 11:01:55.567697+08","b_date":null,"passed":1,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3636,"comment":8},"project":{"id":3701,"key":3701,"name":"\u5ba2\u6237\u81ea\u7528-\u534e\u4e3a\u7f51\u7edc\u8bbe\u5907-2024 \u5e74"},"fromProject":{"id":3701,"key":3701,"name":"\u5ba2\u6237\u81ea\u7528-\u534e\u4e3a\u7f51\u7edc\u8bbe\u5907-2024 \u5e74","description":"","total_contact_point":"4687.5","paid_contact_point":"4687.5","is_sales_order_ready":true,"project_product_version_id":642,"bargain_date":"2024-10-28","collected":"19350","profit_pct":"4.27","budget":"19350","projectProductTypes":[{"id":5729,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"19350.00","pct":"4.27","project_id":3701,"profit":"826.245"}],"projectProductRels":[{"id":8016,"project_id":3701,"product_id":1850,"amount":"4900","number":3,"cost":"2250","description":"","supplier_id":316,"hardware_from":"2024-11-03","software_from":null,"maintenance_from":null,"hardware_to":"2025-11-02","software_to":null,"maintenance_to":null,"total_amount":"14700","total_cost":"6750","supplier":{"id":316,"key":316,"name":"\u5317\u4eac\u6c38\u8d8a\u660c\u76db\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1850,"name":"AR6121EC-S","product_type":4,"product_component":20,"product_brand":7,"product_serie":1558,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-10-30 10:19:35","updated_at":"2024-10-30 10:19:35","pinyin_shortcut":"AR6121ECS","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":20,"key":20,"name":"\u8def\u7531\u5668"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1558,"key":1558,"name":"\u534e\u4e3a NetEngine AR6100\u7cfb\u5217\u4f01\u4e1a\u8def\u7531\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8017,"project_id":3701,"product_id":1615,"amount":"1550","number":3,"cost":"1670","description":"","supplier_id":316,"hardware_from":"2024-09-28","software_from":null,"maintenance_from":null,"hardware_to":"2025-09-27","software_to":null,"maintenance_to":null,"total_amount":"4650","total_cost":"5010","supplier":{"id":316,"key":316,"name":"\u5317\u4eac\u6c38\u8d8a\u660c\u76db\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1615,"name":"S5735S-S24T4S-XA","product_type":4,"product_component":19,"product_brand":7,"product_serie":1376,"product_misc":null,"product_qa":null,"pn":"","description":"S5735S-S24T4S-X\u7ec4\u5408\u914d\u7f6e(24\u4e2a10\/100\/1000BASE-T\u4ee5\u592a\u7f51\u7aef\u53e3,4\u4e2a\u5343\u5146SFP,\u542b1\u4e2a\u4ea4\u6d41\u7535\u6e90)","created_by":1013,"created_at":"2024-05-14 09:10:14","updated_at":"2024-05-14 09:10:14","pinyin_shortcut":"S5735SS24T4SXA","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":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1376,"key":1376,"name":"\u534e\u4e3aS5735S-S24T4S-XA\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}}],"projectContactPoints":[{"id":780,"project_id":3701,"contact_id":1314,"point":"4687.50","paid_point":"4687.5","contact":{"id":1314,"key":1314,"name":"\u8d3a\u840c\u840c","client_id":149,"supplier_id":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09"},"supplier":null},"projectContactPointRels":[{"id":141,"project_id":3701,"contact_id":1314,"point":"4687.50","day_at":"2024-12-18","description":"","created_at":"2024-12-18 11:01:55"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12005,"project_id":3701},{"id":12004,"project_id":3701},{"id":12003,"project_id":3701},{"id":12002,"project_id":3701},{"id":12001,"project_id":3701},{"id":12000,"project_id":3701}],"reimbursementAmountSum":{"project_id":3701,"sum":"105.34"},"profit":826.245,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":2121,"contract_id":3636,"supplier_id":665,"purchase_id":3641,"supplier":{"id":665,"key":665,"name":"\u5317\u4eac\u4fe1\u62d3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3641,"key":3641,"serial_no":"\u4fe1\u62d3TSKJ20241030-HYF-006"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7364,"user_id":1005,"key":1005,"contract_id":3636,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},{"id":7365,"user_id":5388,"key":5388,"contract_id":3636,"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":7366,"user_id":1001,"key":1001,"contract_id":3636,"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":2212,"key":2212,"contract_id":3636,"name":"2024-12-31","value":"19350","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2022,"key":2022,"contract_id":3636,"value":"19350","created_by":1013,"created_at":"2024-11-22 16:26:08","description":"","collected_date":"2024-11-22","amount":"19350","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":30628,"object_type":109,"object_id":2022,"attachment_id":22881,"attachment":{"id":22881,"key":22881,"name":"6a571444-84f6-319e-89e8-1dba09004ba0","extension":"png","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/6a571444-84f6-319e-89e8-1dba09004ba0\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1854,"key":1854,"contract_id":3636,"value":"19350.00","attachment_id":null,"from_date":"2024-11-06","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":30043,"object_type":102,"object_id":1854,"attachment_id":22522,"attachment":{"id":22522,"key":22522,"name":"26b0f15d-b4dc-32da-9802-3c4845b682a3","extension":"pdf","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/26b0f15d-b4dc-32da-9802-3c4845b682a3\/dzfp_24112000000173443034_\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8_20241106135205.pdf","orig_name":"dzfp_24112000000173443034_\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8_20241106135205.pdf"}}]}],"contractScans":[{"id":30280,"object_type":105,"object_id":3636,"attachment_id":22334,"attachment":{"id":22334,"key":22334,"name":"fd52cfa2-3aa8-3d4f-9546-b5afc31e5cf1","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/fd52cfa2-3aa8-3d4f-9546-b5afc31e5cf1\/\u4e2d\u5929\u950b.pdf","orig_name":"\u4e2d\u5929\u950b.pdf"}}],"receiptScans":[{"id":31278,"object_type":106,"object_id":3636,"attachment_id":23354,"attachment":{"id":23354,"key":23354,"name":"4cee6a3d-545d-3080-a947-b3f2ff91ba85","extension":"jpeg","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/4cee6a3d-545d-3080-a947-b3f2ff91ba85\/2024\u5e7412\u670823\u65e5\u56db\u53f0\u8bbe\u5907\u7684\u7b7e\u6536\u5355.jpeg","orig_name":"2024\u5e7412\u670823\u65e5\u56db\u53f0\u8bbe\u5907\u7684\u7b7e\u6536\u5355.jpeg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":19350,"projectProductTotalAmount":19350,"projectProductAllAmount":true,"projectProductTotalCost":11760,"projectProductAllCost":true,"projectProductTotalCount":6,"invoiced":19350,"un_invoiced":0,"collected":19350,"un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"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":3170,"client_id":2094,"signed_at":"2024-02-27","amount":"176660","handler":1005,"description":"","created_by":1005,"created_at":"2024-03-07 17:52:28","updated_at":"2024-10-28 17:56:21","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3468,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHY-2024022701","payment_collection_remind_ahead":"","from_project":3468,"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-28 11:33:54.793832+08","b_date":null,"passed":1,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3170,"comment":5},"project":{"id":3468,"key":3468,"name":"\u786c\u4ef6\u52a0\u5de5\u96c6\u6210\uff0c\u4ea7\u54c1\u6837\u673a\u6574\u4f53\u8054\u8c03\u670d\u52a1"},"fromProject":{"id":3468,"key":3468,"name":"\u786c\u4ef6\u52a0\u5de5\u96c6\u6210\uff0c\u4ea7\u54c1\u6837\u673a\u6574\u4f53\u8054\u8c03\u670d\u52a1","description":"","total_contact_point":"6267.15","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":626,"bargain_date":"2024-02-27","collected":"176660","profit_pct":"88.92","budget":"176660","projectProductTypes":[{"id":5459,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"176660.00","pct":"88.92","project_id":3468,"profit":"157086.072"}],"projectProductRels":[{"id":7044,"project_id":3468,"product_id":941,"amount":"176660","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"176660","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":[{"id":699,"project_id":3468,"contact_id":4844,"point":"6267.15","paid_point":null,"contact":{"id":4844,"key":4844,"name":"\u738b\u660e\u4eae","client_id":2598,"supplier_id":null,"client":{"id":2598,"key":2598,"name":"\u5173\u7cfb\u6237"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":11874,"project_id":3468}],"reimbursementAmountSum":null,"profit":157086.072,"contact_points_status_display":"\u672a\u6838\u9500"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":6905,"user_id":1005,"key":1005,"contract_id":3170,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2095,"key":2095,"contract_id":3170,"name":"2024-03-31","value":"52998","overdue_days":null,"pct":30,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2096,"key":2096,"contract_id":3170,"name":"2024-04-30","value":"123662","overdue_days":null,"pct":70,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1801,"key":1801,"contract_id":3170,"value":"52998","created_by":1013,"created_at":"2024-03-18 11:29:32","description":"","collected_date":"2024-03-18","amount":"52998","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":24473,"object_type":109,"object_id":1801,"attachment_id":18032,"attachment":{"id":18032,"key":18032,"name":"40549a84-c928-3077-85c4-3cdd77a9acbb","extension":"png","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/40549a84-c928-3077-85c4-3cdd77a9acbb\/image.png","orig_name":"image.png"}}],"pct":30},{"id":1828,"key":1828,"contract_id":3170,"value":"123662","created_by":1013,"created_at":"2024-04-22 17:47:01","description":"","collected_date":"2024-04-22","amount":"123662","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":25297,"object_type":109,"object_id":1828,"attachment_id":18785,"attachment":{"id":18785,"key":18785,"name":"3aed2893-e454-33b7-a466-abf0ef6873ba","extension":"png","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/3aed2893-e454-33b7-a466-abf0ef6873ba\/image.png","orig_name":"image.png"}}],"pct":70}],"salesContractInvoices":[{"id":1613,"key":1613,"contract_id":3170,"value":"52998.00","attachment_id":null,"from_date":"2024-03-08","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":24326,"object_type":102,"object_id":1613,"attachment_id":17898,"attachment":{"id":17898,"key":17898,"name":"bc83820e-e459-3e96-8a22-32335f29ad11","extension":"pdf","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/bc83820e-e459-3e96-8a22-32335f29ad11\/dzfp_24112000000009096419_\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240_20240308121327.pdf","orig_name":"dzfp_24112000000009096419_\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240_20240308121327.pdf"}}]},{"id":1631,"key":1631,"contract_id":3170,"value":"123662.00","attachment_id":null,"from_date":"2024-04-12","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":25058,"object_type":102,"object_id":1631,"attachment_id":18554,"attachment":{"id":18554,"key":18554,"name":"84173a22-9ce9-3bec-ad47-342542df6312","extension":"pdf","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/84173a22-9ce9-3bec-ad47-342542df6312\/dzfp_24112000000022063529_\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240_20240412111219.pdf","orig_name":"dzfp_24112000000022063529_\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240_20240412111219.pdf"}}]}],"contractScans":[{"id":29652,"object_type":105,"object_id":3170,"attachment_id":17887,"attachment":{"id":17887,"key":17887,"name":"11557230-fc85-3771-8c01-9e73046b437a","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/11557230-fc85-3771-8c01-9e73046b437a\/\u4e00\u6240.pdf","orig_name":"\u4e00\u6240.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":176660,"projectProductTotalAmount":176660,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":176660,"un_invoiced":0,"collected":176660,"un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"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":2732,"client_id":2094,"signed_at":"2023-06-27","amount":"87000","handler":1005,"description":"AD-1000-B1800-TP1\u53f0","created_by":1005,"created_at":"2023-07-04 09:53:32","updated_at":"2024-01-23 16:26:47","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3241,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"HT23061625106520","payment_collection_remind_ahead":"","from_project":3241,"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":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2732,"comment":3},"project":{"id":3241,"key":3241,"name":"\u6df1\u4fe1\u670d\u8d1f\u8f7d\u5747\u8861\u9879\u76ee"},"fromProject":{"id":3241,"key":3241,"name":"\u6df1\u4fe1\u670d\u8d1f\u8f7d\u5747\u8861\u9879\u76ee","description":"AD-1000-B1800-TP1\u53f0","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":87,"bargain_date":"2023-06-27","collected":"87000","profit_pct":"32.8","budget":"87000","projectProductTypes":[{"id":4864,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"87000.00","pct":"32.8","project_id":3241,"profit":"28536"}],"projectProductRels":[{"id":2671,"project_id":3241,"product_id":625,"amount":"87000","number":1,"cost":"44000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"87000","total_cost":"44000","supplier":null,"product":{"id":625,"name":"AD-1000","product_type":4,"product_component":68,"product_brand":12,"product_serie":377,"product_misc":5,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2020-01-03 15:28:29","updated_at":"2023-08-14 10:06:32","pinyin_shortcut":"AD1000","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":68,"key":68,"name":"\u5e94\u7528\u4ea4\u4ed8\u7f51\u5173"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":377,"key":377,"name":"AD-1000\u7cfb\u5217"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":8756,"project_id":3241}],"reimbursementAmountSum":{"project_id":3241,"sum":"53.45"},"profit":28536,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1408,"contract_id":2732,"supplier_id":138,"purchase_id":2714,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":2714,"key":2714,"serial_no":"SFXSH202106180019"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4634,"user_id":1005,"key":1005,"contract_id":2732,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1273,"key":1273,"contract_id":2732,"name":"2023-08-04","value":"87000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1577,"key":1577,"contract_id":2732,"value":"87000","created_by":1014,"created_at":"2023-07-24 17:00:26","description":null,"collected_date":"2023-07-24","amount":"87000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1433,"key":1433,"contract_id":2732,"value":"87000.00","attachment_id":null,"from_date":"2023-07-14","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":19347,"object_type":102,"object_id":1433,"attachment_id":13923,"attachment":{"id":13923,"key":13923,"name":"0fa1906e-285a-3b97-aa12-d465d4f40b89","extension":"pdf","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/0fa1906e-285a-3b97-aa12-d465d4f40b89\/2023_07_14_10_00_38.pdf","orig_name":"2023_07_14_10_00_38.pdf"}}]}],"contractScans":[{"id":23429,"object_type":105,"object_id":2732,"attachment_id":13794,"attachment":{"id":13794,"key":13794,"name":"cade6b35-e271-3f6f-8da2-7b35b40e424e","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/cade6b35-e271-3f6f-8da2-7b35b40e424e\/\u4e00\u624087000\u5408\u540c.pdf","orig_name":"\u4e00\u624087000\u5408\u540c.pdf"}}],"receiptScans":[{"id":19461,"object_type":106,"object_id":2732,"attachment_id":14028,"attachment":{"id":14028,"key":14028,"name":"394a9f77-2b14-388d-822e-91af19820acf","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/394a9f77-2b14-388d-822e-91af19820acf\/2023_07_20_16_20_31.pdf","orig_name":"2023_07_20_16_20_31.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":87000,"projectProductTotalAmount":87000,"projectProductAllAmount":true,"projectProductTotalCost":44000,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":87000,"un_invoiced":0,"collected":87000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"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":2733,"client_id":2094,"signed_at":"2023-06-21","amount":"89000","handler":1005,"description":"YJ-1000-VX(\u6df1\u4fe1\u670d\u4e91\u955c\u7f51\u7edc\u8d44\u4ea7\u8106\u5f31\u6027\u626b\u63cf\u7cfb\u7edf\u8f6f\u4ef6V3.0)","created_by":1005,"created_at":"2023-07-04 09:59:38","updated_at":"2024-01-23 16:27:04","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3242,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"HW20230615275","payment_collection_remind_ahead":"","from_project":3242,"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":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2733,"comment":3},"project":{"id":3242,"key":3242,"name":"\u6df1\u4fe1\u670d\u4e91\u955c"},"fromProject":{"id":3242,"key":3242,"name":"\u6df1\u4fe1\u670d\u4e91\u955c","description":"YJ-1000-VX(\u6df1\u4fe1\u670d\u4e91\u955c\u7f51\u7edc\u8d44\u4ea7\u8106\u5f31\u6027\u626b\u63cf\u7cfb\u7edf\u8f6f\u4ef6V3.0)","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":88,"bargain_date":"2023-06-21","collected":"89000","profit_pct":"27.93","budget":"89000","projectProductTypes":[{"id":4865,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"89000.00","pct":"27.93","project_id":3242,"profit":"24857.7"}],"projectProductRels":[{"id":2672,"project_id":3242,"product_id":909,"amount":"89000","number":1,"cost":"25800","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"89000","total_cost":"25800","supplier":null,"product":{"id":909,"name":"YJ-1000-B1120","product_type":4,"product_component":24,"product_brand":12,"product_serie":572,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-03-14 14:59:12","updated_at":"2024-03-11 14:08:28","pinyin_shortcut":"YJ1000B1120","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":24,"key":24,"name":"\u6f0f\u6d1e\u626b\u63cf\u7cfb\u7edf"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":572,"key":572,"name":"YJ-1000-B1120"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":2673,"project_id":3242,"product_id":942,"amount":"0","number":1,"cost":"24200","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"24200","supplier":null,"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","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":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":8759,"project_id":3242},{"id":8760,"project_id":3242}],"reimbursementAmountSum":null,"profit":24857.7,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":918,"contract_id":2733,"supplier_id":138,"purchase_id":2728,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":2728,"key":2728,"serial_no":"SFPSFWCGH202306210113"}},{"id":995,"contract_id":2733,"supplier_id":138,"purchase_id":2729,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":2729,"key":2729,"serial_no":"SFXSH202306210113"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4635,"user_id":1005,"key":1005,"contract_id":2733,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1272,"key":1272,"contract_id":2733,"name":"2023-08-11","value":"89000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1598,"key":1598,"contract_id":2733,"value":"89000","created_by":1014,"created_at":"2023-08-08 15:16:54","description":null,"collected_date":"2023-08-08","amount":"89000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1442,"key":1442,"contract_id":2733,"value":"89000.00","attachment_id":null,"from_date":"2023-07-25","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":19539,"object_type":102,"object_id":1442,"attachment_id":14104,"attachment":{"id":14104,"key":14104,"name":"f2e5872e-ee15-3a80-bc4e-eaf6d7cc0e3d","extension":"pdf","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/f2e5872e-ee15-3a80-bc4e-eaf6d7cc0e3d\/2023_07_25_10_56_43.pdf","orig_name":"2023_07_25_10_56_43.pdf"}}]}],"contractScans":[{"id":23430,"object_type":105,"object_id":2733,"attachment_id":13795,"attachment":{"id":13795,"key":13795,"name":"889c8520-c5ea-3c37-8be4-188853be4fd7","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/889c8520-c5ea-3c37-8be4-188853be4fd7\/\u4e00\u624089000\u5408\u540c.pdf","orig_name":"\u4e00\u624089000\u5408\u540c.pdf"}}],"receiptScans":[{"id":20067,"object_type":106,"object_id":2733,"attachment_id":14569,"attachment":{"id":14569,"key":14569,"name":"ef664a60-c632-3f9b-afd8-ce9b84fbaf38","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/ef664a60-c632-3f9b-afd8-ce9b84fbaf38\/\u8d27\u7269\u7b7e\u6536\u5355(1).pdf","orig_name":"\u8d27\u7269\u7b7e\u6536\u5355(1).pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":89000,"projectProductTotalAmount":89000,"projectProductAllAmount":true,"projectProductTotalCost":50000,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":89000,"un_invoiced":0,"collected":89000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"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":2551,"client_id":2094,"signed_at":"2023-02-13","amount":"144400","handler":1005,"description":"\u62d3\u5b9e\u62a5\u4ef7\uff1a\n\u4fe1\u9510 RS5300-52T-4F-D,\u62a5\u4ef7\uff1a35200*4\uff1b\u4fe1\u9510 RS3320-12M-LI\uff0c\u62a5\u4ef7\uff1a1200*4\uff0c\u603b\u4ef7\uff1a145600\n\n\u5176\u4f59\u4e24\u5bb6\uff1a\n35800*4+1200*4=148000\n36000*4+1100*4=148400","created_by":1005,"created_at":"2023-01-30 17:09:03","updated_at":"2024-01-23 16:27:18","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3086,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"HT23013029114920","payment_collection_remind_ahead":"","from_project":3086,"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":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2551,"comment":4},"project":{"id":3086,"key":3086,"name":"\u56ed\u533a\u63a5\u5165\u4ea4\u6362\u673a\u7535\u5b50\u7ade\u4ef7 DZJJ230105100154920"},"fromProject":{"id":3086,"key":3086,"name":"\u56ed\u533a\u63a5\u5165\u4ea4\u6362\u673a\u7535\u5b50\u7ade\u4ef7 DZJJ230105100154920","description":"\u62d3\u5b9e\u62a5\u4ef7\uff1a\n\u4fe1\u9510 RS5300-52T-4F-D,\u62a5\u4ef7\uff1a35200*4\uff1b\u4fe1\u9510 RS3320-12M-LI\uff0c\u62a5\u4ef7\uff1a1200*4\uff0c\u603b\u4ef7\uff1a145600\n\n\u5176\u4f59\u4e24\u5bb6\uff1a\n35800*4+1200*4=148000\n36000*4+1100*4=148400","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":89,"bargain_date":"2023-02-13","collected":"144400","profit_pct":"50.05","budget":"144400","projectProductTypes":[{"id":3836,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"144400.00","pct":"50.05","project_id":3086,"profit":"72272.2"}],"projectProductRels":[{"id":2674,"project_id":3086,"product_id":916,"amount":"35000","number":4,"cost":"8800","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"140000","total_cost":"35200","supplier":null,"product":{"id":916,"name":"RS5300","product_type":4,"product_component":19,"product_brand":88,"product_serie":1232,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-04-12 15:09:59","updated_at":"2024-02-22 17:14:25","pinyin_shortcut":"RS5300","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":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":1232,"key":1232,"name":"\u4fe1\u9510RS5300\u5b89\u89c6\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":2675,"project_id":3086,"product_id":917,"amount":"1100","number":4,"cost":"2300","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"4400","total_cost":"9200","supplier":null,"product":{"id":917,"name":"RS3320","product_type":4,"product_component":19,"product_brand":88,"product_serie":577,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-04-12 15:11:00","updated_at":"2024-02-22 17:14:54","pinyin_shortcut":"RS3320","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":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":577,"key":577,"name":"\u4fe1\u9510RS3320\u5b89\u89c6\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":72272.2,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":225,"contract_id":2551,"supplier_id":496,"purchase_id":2567,"supplier":{"id":496,"key":496,"name":"\u5317\u4eac\u839e\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2567,"key":2567,"serial_no":"TSKJ20230216-HYF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4636,"user_id":1005,"key":1005,"contract_id":2551,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1159,"key":1159,"contract_id":2551,"name":"2023-03-31","value":"144400","overdue_days":81,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1555,"key":1555,"contract_id":2551,"value":"144400","created_by":1014,"created_at":"2023-06-20 17:12:07","description":null,"collected_date":"2023-06-20","amount":"144400","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1351,"key":1351,"contract_id":2551,"value":"144400.00","attachment_id":null,"from_date":"2023-02-27","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":17378,"object_type":102,"object_id":1351,"attachment_id":12147,"attachment":{"id":12147,"key":12147,"name":"88e0f4e6-23ce-3db8-b7f2-58ce582d296f","extension":"pdf","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/88e0f4e6-23ce-3db8-b7f2-58ce582d296f\/2023_02_27_11_46_42\uff08\u88ab\u62d6\u79fb\uff09.pdf","orig_name":"2023_02_27_11_46_42\uff08\u88ab\u62d6\u79fb\uff09.pdf"}}]}],"contractScans":[{"id":23431,"object_type":105,"object_id":2551,"attachment_id":12073,"attachment":{"id":12073,"key":12073,"name":"b210e7d0-8975-3963-bdd9-116eb12e02d8","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/b210e7d0-8975-3963-bdd9-116eb12e02d8\/2023_02_14_10_17_12.pdf","orig_name":"2023_02_14_10_17_12.pdf"}}],"receiptScans":[{"id":18074,"object_type":106,"object_id":2551,"attachment_id":12770,"attachment":{"id":12770,"key":12770,"name":"fde6648d-8907-38e2-84a8-90e958de4b58","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/fde6648d-8907-38e2-84a8-90e958de4b58\/2023_04_18_17_14_17.pdf","orig_name":"2023_04_18_17_14_17.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":144400,"projectProductTotalAmount":144400,"projectProductAllAmount":true,"projectProductTotalCost":44400,"projectProductAllCost":true,"projectProductTotalCount":8,"invoiced":144400,"un_invoiced":0,"collected":144400,"un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"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":2014,"client_id":2094,"signed_at":"2021-08-02","amount":"1421100","handler":1005,"description":"AF-2000-B2130(\u6df1\u4fe1\u670d\u9632\u706b\u5899)\t2\nEDR(\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0\u8f6f\u4ef6V3.0)\t1\n\u76db\u90a6\u5b89\u5168 \u6297DDOS\u8bbe\u5907 RayADS-4000(\u5f02\u5e38\u6d41\u91cf\u6e05\u6d17\u4e0e\u6297\u62d2\u7edd\u670d\u52a1\u7cfb\u7edf)\t1\naServer-R-2205(\u8d85\u878d\u5408\u4e00\u4f53\u673a)\t4\naRack-1200-42U(\u673a\u67dc)\t2\nRS6300-26Q-EI-24X\t2\nRS3300-28T-4F\t3\n\u5b89\u5168\u9694\u79bb\u4e0e\u5355\u5411\u4f20\u8f93\u7cfb\u7edf\t2\n\u5b89\u5168\u6570\u636e\u4ea4\u6362\u7cfb\u7edf \t1\nDC\u8bf7\u6c42\u4e0e\u54cd\u5e94\u4ea4\u6362\u6a21\u5757\u6388\u6743\t1\n\u96c6\u4e2d\u76d1\u63a7\u7ba1\u7406\u7cfb\u7edf\t1\n\u96c6\u4e2d\u76d1\u63a7\u7ba1\u7406\u63a2\u9488\u7cfb\u7edf\t1","created_by":1005,"created_at":"2021-06-24 15:44:17","updated_at":"2022-10-18 09:40:57","contract_scan":8114,"receipt_scan":null,"contract_type":1,"project_id":2590,"valid_date":null,"expire_date":"2024-08-01","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-ZHY_20210715T5","payment_collection_remind_ahead":"2 days","from_project":2590,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":346,"passed":2,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":{"id":8114,"key":8114,"name":"0eba5644-681f-31b2-9d77-020667f3a67f","orig_name":"2021_08_10_10_35_50.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/0eba5644-681f-31b2-9d77-020667f3a67f\/2021_08_10_10_35_50.pdf","download":"\/vue\/attachment\/download?name=0eba5644-681f-31b2-9d77-020667f3a67f"},"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2014,"comment":1},"project":{"id":2590,"key":2590,"name":"\u5927\u6570\u636e\u5e73\u53f0\u65b0\u5efa"},"fromProject":{"id":2590,"key":2590,"name":"\u5927\u6570\u636e\u5e73\u53f0\u65b0\u5efa","description":"AF-2000-B2130(\u6df1\u4fe1\u670d\u9632\u706b\u5899)\t2\nEDR(\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0\u8f6f\u4ef6V3.0)\t1\n\u76db\u90a6\u5b89\u5168 \u6297DDOS\u8bbe\u5907 RayADS-4000(\u5f02\u5e38\u6d41\u91cf\u6e05\u6d17\u4e0e\u6297\u62d2\u7edd\u670d\u52a1\u7cfb\u7edf)\t1\naServer-R-2205(\u8d85\u878d\u5408\u4e00\u4f53\u673a)\t4\naRack-1200-42U(\u673a\u67dc)\t2\nRS6300-26Q-EI-24X\t2\nRS3300-28T-4F\t3\n\u5b89\u5168\u9694\u79bb\u4e0e\u5355\u5411\u4f20\u8f93\u7cfb\u7edf\t2\n\u5b89\u5168\u6570\u636e\u4ea4\u6362\u7cfb\u7edf \t1\nDC\u8bf7\u6c42\u4e0e\u54cd\u5e94\u4ea4\u6362\u6a21\u5757\u6388\u6743\t1\n\u96c6\u4e2d\u76d1\u63a7\u7ba1\u7406\u7cfb\u7edf\t1\n\u96c6\u4e2d\u76d1\u63a7\u7ba1\u7406\u63a2\u9488\u7cfb\u7edf\t1","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2021-08-02","collected":"1421100","profit_pct":"3.39","budget":"1421100","projectProductTypes":[{"id":3662,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"697100.00","pct":"3.39","project_id":2590,"profit":"23631.69"},{"id":4537,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"724000.00","pct":"3.39","project_id":2590,"profit":"24543.6"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2590,"sum":"2030.05"},"profit":48175.29,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":52,"contract_id":2014,"supplier_id":123,"purchase_id":2082,"supplier":{"id":123,"key":123,"name":"\u667a\u76df\u4e16\u7eaa(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u5317\u8054\u84dd\u8baf\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":2082,"key":2082,"serial_no":"--"}},{"id":240,"contract_id":2014,"supplier_id":138,"purchase_id":2012,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":2012,"key":2012,"serial_no":"SFXSH202106230348"}},{"id":468,"contract_id":2014,"supplier_id":425,"purchase_id":2036,"supplier":{"id":425,"key":425,"name":"\u5317\u4eac\u6770\u521b\u8bda\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2036,"key":2036,"serial_no":"TSKJ20210715-HYF-001"}},{"id":642,"contract_id":2014,"supplier_id":138,"purchase_id":2046,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":2046,"key":2046,"serial_no":"SFXSH202107210185"}},{"id":854,"contract_id":2014,"supplier_id":424,"purchase_id":2017,"supplier":{"id":424,"key":424,"name":"\u5317\u4eac\u76db\u4e16\u7f51\u8fbe\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":2017,"key":2017,"serial_no":"TSKJ20210616-HYF-002"}},{"id":1294,"contract_id":2014,"supplier_id":314,"purchase_id":2016,"supplier":{"id":314,"key":314,"name":"\u5317\u4eac\u745e\u79d1\u8fdc\u4e1c\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2016,"key":2016,"serial_no":"rkyd20210618001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":6130,"user_id":1011,"key":1011,"contract_id":2014,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":6131,"user_id":1005,"key":1005,"contract_id":2014,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":2854,"user_id":1005,"key":1005,"contract_id":2014,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":904,"key":904,"contract_id":2014,"name":"2021-07-02","value":"952770","overdue_days":42,"pct":67.04,"collect_status":"\u5df2\u5b8c\u6210"},{"id":905,"key":905,"contract_id":2014,"name":"2021-07-25","value":"408330","overdue_days":19,"pct":28.73,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1201,"key":1201,"contract_id":2014,"value":"1421100","created_by":1001,"created_at":"2021-08-13 09:40:43","description":null,"collected_date":"2021-08-13","amount":"1421100","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[],"pct":100}],"salesContractInvoices":[{"id":1096,"key":1096,"contract_id":2014,"value":"1421100.00","attachment_id":8031,"from_date":"2021-07-19","description":null,"is_draft":true,"attachment":{"id":8031,"key":8031,"name":"a55627c6-6a6b-3e38-ab7a-da36ba668bcb","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/a55627c6-6a6b-3e38-ab7a-da36ba668bcb\/\u4e2d\u5929\u950b\u53d1\u7968.pdf","orig_name":"\u4e2d\u5929\u950b\u53d1\u7968.pdf"},"attachmentRelationships":[],"files":[{"id":6530,"object_type":102,"object_id":1096,"attachment_id":8031,"attachment":{"id":8031,"key":8031,"name":"a55627c6-6a6b-3e38-ab7a-da36ba668bcb","extension":"pdf","path":"\/v2\/attachment\/view\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/a55627c6-6a6b-3e38-ab7a-da36ba668bcb\/\u4e2d\u5929\u950b\u53d1\u7968.pdf","orig_name":"\u4e2d\u5929\u950b\u53d1\u7968.pdf"}}]}],"contractScans":[{"id":12243,"object_type":105,"object_id":2014,"attachment_id":8114,"attachment":{"id":8114,"key":8114,"name":"0eba5644-681f-31b2-9d77-020667f3a67f","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/0eba5644-681f-31b2-9d77-020667f3a67f\/2021_08_10_10_35_50.pdf","orig_name":"2021_08_10_10_35_50.pdf"}}],"receiptScans":[{"id":16349,"object_type":106,"object_id":2014,"attachment_id":11249,"attachment":{"id":11249,"key":11249,"name":"d9891cf8-049e-3b82-9f05-2db5b0e3f708","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/d9891cf8-049e-3b82-9f05-2db5b0e3f708\/\u5df2\u90ae\u4ef6\u7533\u8bf7\u4e0d\u6536\u56de\u7b7e\u6536\u5355.pdf","orig_name":"\u5df2\u90ae\u4ef6\u7533\u8bf7\u4e0d\u6536\u56de\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":1361100,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":1421100,"un_invoiced":0,"collected":1421100,"un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true}],"pagenation":{"totalcount":7,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-13 17:21:56') RETURNING "id" |