Database Queries

总计63条数据
TimeDurationTypeQuery
  
13:30:31.6565.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF'

13:30:31.6625.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005

13:30:31.67415.2 msSELECTSELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_sales_contracts' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

13:30:31.69027.3 msSELECTselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_sales_contracts' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

13:30:31.72557.6 msSELECTSELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND (("client"."sales_rep"=1005) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1005))) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"

13:30:31.78321.8 msSELECTSELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND (("client"."sales_rep"=1005) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1005))) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10

13:30:31.8181.1 msSELECTSELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (918, 20, 3333, 149, 2548, 93)

13:30:31.8200.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005

13:30:31.82014.8 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)

13:30:31.8397.9 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5250, 1005)

13:30:31.8539.8 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 1005))

13:30:31.86612.9 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 1)

13:30:31.88483.8 msSELECTSELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705)) GROUP BY "object_id"

13:30:31.97243.0 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3461, 3792, 3783, 3547, 3721, 3757, 3720, 3750, 3666, 3699)

13:30:32.0199.8 msSELECTSELECT "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 (3461, 3792, 3783, 3547, 3721, 3757, 3720, 3750, 3666, 3699)

13:30:32.03321.8 msSELECTSELECT "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 (3666, 3547, 3720, 3699, 3721, 3750, 3757, 3792, 3783, 3461)

13:30:32.0587.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3666, 3547, 3720, 3699, 3721, 3750, 3757, 3792, 3783, 3461)

13:30:32.0675.0 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (516, 138, 478, 59, 355, 74, 684, 614, 534, 81)

13:30:32.07220.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (941, 950, 1009, 1943, 1944, 1945, 1922, 1941, 1942, 942, 853, 855, 329, 1876, 1881, 1877, 1737, 1148, 1879, 1880, 1878, 960, 1801, 1882, 922, 1625, 1626, 275)

13:30:32.0963.8 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 19, 22, 4, 2, 7, 18)

13:30:32.1003.8 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (26, 35, 151, 200, 189, 51, 5, 2, 30, 43, 6, 144, 47, 152)

13:30:32.1043.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (40, 134, 133, 12, 20, 227, 191, 4, 124, 136)

13:30:32.1089.0 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1383, 1384, 593, 592, 1024, 1470, 1514, 1570, 1573, 1318, 1572, 1590, 1599, 1600, 813, 47, 231, 546, 544, 602, 596, 713, 103)

13:30:32.1171.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (1, 2, 7, 8, 4, 6, 5)

13:30:32.1191.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3666, 3547, 3720, 3699, 3721, 3750, 3757, 3792, 3783, 3461)

13:30:32.1245.4 msSELECTSELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (4125, 1848)

13:30:32.1290.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (918, 149)

13:30:32.1302.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((4125, 3720), (1848, 3666))

13:30:32.13310.1 msSELECTSELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3666, 3547, 3720, 3699, 3721, 3750, 3757, 3792, 3783, 3461))

13:30:32.14316.6 msSELECTSELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (3666, 3547, 3720, 3699, 3721, 3750, 3757, 3792, 3783, 3461)) GROUP BY "project_id"

13:30:32.1619.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705)

13:30:32.1710.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (355, 59, 534, 684, 685, 81, 138, 516, 614)

13:30:32.1727.1 msSELECTSELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3785, 3817, 3818, 3821, 3813, 3774, 3706, 3766, 3721, 3723)

13:30:32.1791.0 msSELECTSELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)

13:30:32.1800.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005

13:30:32.1810.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)

13:30:32.1814.8 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705)) ORDER BY "remind_date"

13:30:32.1860.7 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705)

13:30:32.1876.1 msSELECTSELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705)

13:30:32.1940.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1011)

13:30:32.1940.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1005))

13:30:32.1952.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705)

13:30:32.1970.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005

13:30:32.1970.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)

13:30:32.1984.8 msSELECTSELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705)

13:30:32.2030.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5388, 1001)

13:30:32.2030.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5388, 1005))

13:30:32.2043.0 msSELECTSELECT "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 (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705) ORDER BY "remind_date"

13:30:32.2073.5 msSELECTSELECT "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 (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705) ORDER BY "id"

13:30:32.2110.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013

13:30:32.2112.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (2078, 2089, 2103, 2110, 2127))

13:30:32.2147.7 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23795, 23903, 23969, 24184, 24424)

13:30:32.2238.6 msSELECTSELECT "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 (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705) ORDER BY "id"

13:30:32.2321.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1868, 1921, 1923, 1930, 1932, 1943, 1950, 1965))

13:30:32.2341.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1868, 1921, 1923, 1930, 1932, 1943, 1950, 1965))

13:30:32.2363.7 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22836, 23524, 23526, 23611, 23819, 23609, 24172, 24409)

13:30:32.2401.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705))

13:30:32.2424.3 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23487, 22710, 23140, 23558, 23793, 23918, 23888, 24293, 24556)

13:30:32.2462.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705))

13:30:32.2491.1 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23652, 24527, 24557)

13:30:32.2502.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705))

13:30:32.25317.4 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1005 AND is_read = false) AND ("object_id" IN (3845, 3812, 3795, 3764, 3745, 3744, 3736, 3735, 3664, 3705)) GROUP BY "object_id"

13:30:32.27510.2 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1005, 0, 263, 'v2/sales-contract/list', '{"access_token":"ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF","device_type":"0","version_code":"263","page":"1","token":"d179aa9d6eeee5b3613a9fb44038d1cc","posttime":"1751693433"}', '{"code":200,"data":{"list":[{"id":3845,"client_id":918,"signed_at":"2025-06-03","amount":"1000000","handler":1005,"description":"","created_by":5250,"created_at":"2025-06-11 11:37:57","updated_at":"2025-06-11 11:37:57","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3461,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":null,"payment_collection_remind_ahead":"7 days","from_project":3461,"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":"2025-06-11 11:41:41.655689+08","b_date":null,"passed":1,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\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":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":null,"project":{"id":3461,"key":3461,"name":"\u6570\u636e\u5907\u4efd\u65b9\u6848\uff08\u542b\u5b9e\u9a8c\u5ba4\uff09-\u4f55\u5ca9\u9879\u76ee"},"fromProject":{"id":3461,"key":3461,"name":"\u6570\u636e\u5907\u4efd\u65b9\u6848\uff08\u542b\u5b9e\u9a8c\u5ba4\uff09-\u4f55\u5ca9\u9879\u76ee","description":null,"total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":null,"bargain_date":"2025-06-03","collected":"0","profit_pct":"20","budget":"1000000","projectProductTypes":[{"id":6249,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1000000.00","pct":"20","project_id":3461,"profit":"200000"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3461,"sum":"249.95"},"profit":200000,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"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":8203,"user_id":1005,"key":1005,"contract_id":3845,"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":8204,"user_id":1001,"key":1001,"contract_id":3845,"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":2410,"key":2410,"contract_id":3845,"name":"2025-06-11","value":"12322","overdue_days":null,"pct":1.23,"collect_status":"\u903e\u671f24\u5929"}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":12322,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":0,"un_invoiced":1000000,"collected":0,"un_collected":1000000,"is_collected":false,"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":3812,"client_id":20,"signed_at":"2025-03-06","amount":"500","handler":1005,"description":"","created_by":1005,"created_at":"2025-03-06 09:01:21","updated_at":"2025-03-14 15:15:11","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3792,"valid_date":null,"expire_date":"2026-03-04","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"","from_project":3792,"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":false,"save_collection_at":null,"b_date":242,"passed":2,"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\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":3812,"comment":8},"project":{"id":3792,"key":3792,"name":"IBM\u7535\u6e90\u66f4\u6362"},"fromProject":{"id":3792,"key":3792,"name":"IBM\u7535\u6e90\u66f4\u6362","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":794,"bargain_date":"2025-03-06","collected":"0","profit_pct":"32.8","budget":"500","projectProductTypes":[{"id":6081,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"500.00","pct":"32.8","project_id":3792,"profit":"164"}],"projectProductRels":[{"id":8957,"project_id":3792,"product_id":275,"amount":"500.00","number":1,"cost":"300.00","description":"","supplier_id":81,"hardware_from":"2025-03-04","software_from":null,"maintenance_from":null,"hardware_to":"2026-03-04","software_to":null,"maintenance_to":null,"total_amount":"500","total_cost":"300","supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"product":{"id":275,"name":"\u8054\u60f3 750W","product_type":2,"product_component":6,"product_brand":4,"product_serie":47,"product_misc":4,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-09-07 17:25:11","updated_at":"2023-08-14 15:35:21","pinyin_shortcut":"lx750W","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":6,"key":6,"name":"\u670d\u52a1\u5668\u7535\u6e90"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":47,"key":47,"name":"\u8054\u60f3X3650M5"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12693,"project_id":3792}],"reimbursementAmountSum":null,"profit":164,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2481,"contract_id":3812,"supplier_id":81,"purchase_id":3813,"supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"purchase":{"id":3813,"key":3813,"serial_no":"TSKJ20250304-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":8008,"user_id":1005,"key":1005,"contract_id":3812,"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":2354,"key":2354,"contract_id":3812,"name":"2025-04-06","value":"500","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f90\u5929"}],"salesContractPayments":[],"salesContractInvoices":[{"id":1965,"key":1965,"contract_id":3812,"value":"500.00","attachment_id":null,"from_date":"2025-03-06","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32693,"object_type":102,"object_id":1965,"attachment_id":24409,"attachment":{"id":24409,"key":24409,"name":"2a02aa7d-f016-3163-9269-8b86a3d2d8a6","extension":"pdf","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/2a02aa7d-f016-3163-9269-8b86a3d2d8a6\/dzfp_25112000000044439082_\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8_20250306093600.pdf","orig_name":"dzfp_25112000000044439082_\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8_20250306093600.pdf"}}]}],"contractScans":[{"id":32901,"object_type":105,"object_id":3812,"attachment_id":24556,"attachment":{"id":24556,"key":24556,"name":"d2cd80bc-8e02-3473-a4f4-d35a688ac6e4","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/d2cd80bc-8e02-3473-a4f4-d35a688ac6e4\/\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8.pdf","orig_name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8.pdf"}}],"receiptScans":[{"id":32902,"object_type":106,"object_id":3812,"attachment_id":24527,"attachment":{"id":24527,"key":24527,"name":"f2ba2c4b-2411-363a-a99e-20e3a30965ff","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/f2ba2c4b-2411-363a-a99e-20e3a30965ff\/DOC031225-03122025155101 2.pdf","orig_name":"DOC031225-03122025155101 2.pdf"}},{"id":32903,"object_type":106,"object_id":3812,"attachment_id":24557,"attachment":{"id":24557,"key":24557,"name":"ca30c67d-7c9c-3001-9f7f-648e4e12d250","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/ca30c67d-7c9c-3001-9f7f-648e4e12d250\/DOC031225-03122025155101.pdf","orig_name":"DOC031225-03122025155101.pdf"}}],"verifyScans":[],"unreadComments":{"object_id":3812,"unread":5},"collected_plan":500,"projectProductTotalAmount":500,"projectProductAllAmount":true,"projectProductTotalCost":300,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":500,"un_invoiced":0,"collected":0,"un_collected":500,"is_collected":false,"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":5,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3795,"client_id":3333,"signed_at":"2025-02-21","amount":"2310000","handler":1005,"description":"","created_by":1005,"created_at":"2025-02-26 10:24:57","updated_at":"2025-02-26 11:58:32","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3783,"valid_date":null,"expire_date":"2028-02-21","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSKJ20250221-ZHY-001","payment_collection_remind_ahead":"1 day","from_project":3783,"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":"2025-02-26 10:24:57.496964+08","b_date":961,"passed":2,"client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":null,"sales_rep":null,"salesRep":null},"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":3795,"comment":1},"project":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355"},"fromProject":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":795,"bargain_date":"2025-02-21","collected":"0","profit_pct":"2","budget":"2310000","projectProductTypes":[{"id":6018,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"2310000.00","pct":"2","project_id":3783,"profit":"46200"}],"projectProductRels":[{"id":8916,"project_id":3783,"product_id":1941,"amount":"96000.00","number":3,"cost":"76286.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"288000","total_cost":"228858","supplier":null,"product":{"id":1941,"name":"UnaDPM3036","product_type":2,"product_component":2,"product_brand":227,"product_serie":1599,"product_misc":null,"product_qa":null,"pn":"","description":"\u786c\u4ef6\u57fa\u7840\u5e73\u53f0\uff1a\n1.\u89c4\u683c\uff1a4U36\u76d8\u4f4d\u673a\u7bb1,\u542b\u5bfc\u8f68 \n2.CPU\uff1a32\u6838\u9cb2\u9e4f920 2.6GHz*2\uff1b \n3.\u5185\u5b58\uff1a128G DDR4 \n4.\u786c\u76d8\uff1aSSD\uff1a960G SSD*2\uff1bSAS\uff1a3.5\u5bf8 7200RPM\/\u8fd1\u7ebf SAS(NL-SAS)*30\uff08\u542b\u786c\u76d8\u67b6\uff09\n5.RAID\u5361\uff1a1G\u7f13\u5b58\u7684\u786cRAID\u5361*1.\u652f\u6301raid0,1,5, 6, 10, 50, 60\uff1b \n6.\u6389\u7535\u4fdd\u62a4\uff1a1G\u9635\u5217\u5361\u5bf9\u5e94\u6389\u7535\u4fdd\u62a4 \n7.\u5197\u4f59\u7535\u6e90\uff1b \n8.\u7f51\u7edc\u63a5\u53e3\uff1a2\u4e2a\u5343\u5146\u7535\u53e3\uff1b\n9.\u786c\u76d8\u4e0d\u8fd4\u8fd8\u670d\u52a1","created_by":1013,"created_at":"2025-02-26 10:58:31","updated_at":"2025-02-26 10:58:31","pinyin_shortcut":"UnaDPM3036","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1599,"key":1599,"name":"\u58f9\u8fdb\u5236\u670d\u52a1\u5668\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8917,"project_id":3783,"product_id":1942,"amount":"2022000.00","number":1,"cost":"1606742.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2022000","total_cost":"1606742","supplier":null,"product":{"id":1942,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6","product_type":7,"product_component":30,"product_brand":227,"product_serie":1600,"product_misc":null,"product_qa":null,"pn":"","description":"\"\u8f6f\u4ef6\u57fa\u7840\u5e73\u53f0\uff1a\n64bit \u4f01\u4e1a\u7ea7 Linux \u5185\u6838\uff0c\u57fa\u4e8eWEB \u754c\u9762\u7684\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf \u8f6f\u4ef6\uff0c\u6807\u914d\u6587\u4ef6\/\u6570\u636e\u5e93\n\/Windows\/Linux\/\u865a\u62df\u5316\u5b9a\u65f6\u5907\u4efd\u529f\u80fd\u3002\n\u5bb9\u91cf\u6388\u6743\uff1a\nUnaRDP-1P\uff1a1P \u5b9a\u65f6\u5907\u4efd\u5bb9\u91cf\u6388\u6743\u3002\n\u9ad8\u7ea7\u529f\u80fd\u6388\u6743\uff1a\nUnaDedupe-LIC*3\uff1a3\u4e2a\u91cd\u5220\u529f\u80fd \u6388\u6743\uff0c\u542b\u6e90\u7aef\u548c\u76ee\u6807\u7aef\u91cd\u5220\uff1b\u5b9e \u65f6\u5907\u4efd\u5bb9\u91cf\u4e0d\u652f\u6301\u91cd\u5220\u529f\u80fd\uff1bCDM \u529f\u80fd\u6253\u5f00\u65f6\u4ec5\u652f\u6301\u76ee\u6807\u7aef\u91cd\u5220\u3002\n(\u6ce8\uff1a\u5982\u679c\u9009\u62e9\u91cd\u5220\u529f\u80fd\uff0c\u5fc5\u987b\u589e \u914d RAID \u5361\u6389\u7535\u4fdd\u62a4)\u3002\nUnaD2D2R-LIC*3\uff1a3\u4e2a\u4e24\u53f0\u9ed1\u65b9\u670d \u52a1\u5668\u4e4b\u95f4\u7684\u6570\u636e\u5f02\u5730\u540c\u6b65\u901a\u9053\u6388 \u6743\uff0c\u652f\u6301\u5c06\u672c\u5730\u9ed1\u65b9\u670d\u52a1\u5668\u4e2d\u5907 \u4efd\u6216\u5bb9\u707e\u6570\u636e\u96c6\u540c\u6b65\u81f3\u5f02\u5730\u9ed1\u65b9 \u670d\u52a1\u5668\u3002\u76ee\u7684\u7aef\u53ea\u9700\u786e\u4fdd\u914d\u7f6e\u57fa \u672c\u4ef6\uff0c\u65e0\u9700\u914d\u7f6e\u8fdc\u7a0b\u590d\u5236\u4ee3\u7406\u3002\u8fdc\u7a0b\u590d\u5236\u4ee3\u7406\u6570\u91cf\u7531\u6e90\u7aef\u7ba1\u7406\u63a7 \u5236\u53f0\u7684\u6570\u91cf\u51b3\u5b9a\u3002\"\n","created_by":1013,"created_at":"2025-02-26 11:00:56","updated_at":"2025-02-26 11:00:56","pinyin_shortcut":"yjzhfrzbfyhfxtrjV6","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1600,"key":1600,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3783,"sum":"123"},"profit":46200,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2480,"contract_id":3795,"supplier_id":685,"purchase_id":3821,"supplier":{"id":685,"key":685,"name":"\u5317\u4eac\u4e2d\u73af\u4e00\u94ed\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3821,"key":3821,"serial_no":"TSKJ20250305-ZHY-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":7914,"user_id":1005,"key":1005,"contract_id":3795,"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":2342,"key":2342,"contract_id":3795,"name":"2025-03-26","value":"693000","overdue_days":null,"pct":30,"collect_status":"\u903e\u671f101\u5929"},{"id":2343,"key":2343,"contract_id":3795,"name":"2025-04-30","value":"1501500","overdue_days":null,"pct":65,"collect_status":"\u903e\u671f66\u5929"},{"id":2344,"key":2344,"contract_id":3795,"name":"2028-02-29","value":"115500","overdue_days":null,"pct":5,"collect_status":""}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":32531,"object_type":105,"object_id":3795,"attachment_id":24293,"attachment":{"id":24293,"key":24293,"name":"98c9d421-1520-342e-92b2-c664cbb76842","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/98c9d421-1520-342e-92b2-c664cbb76842\/\u8d75\u6657\u7131-\u822a\u5929\u56db\u521b-2310000.pdf","orig_name":"\u8d75\u6657\u7131-\u822a\u5929\u56db\u521b-2310000.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":{"object_id":3795,"unread":1},"collected_plan":2310000,"projectProductTotalAmount":2310000,"projectProductAllAmount":true,"projectProductTotalCost":1835600,"projectProductAllCost":true,"projectProductTotalCount":4,"invoiced":0,"un_invoiced":2310000,"collected":0,"un_collected":2310000,"is_collected":false,"handlerPerson":null,"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":false,"can_delete":false,"unread":1,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3764,"client_id":149,"signed_at":"2025-01-13","amount":"205900","handler":1005,"description":"","created_by":1005,"created_at":"2025-01-17 12:57:21","updated_at":"2025-01-17 13:28:03","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3547,"valid_date":null,"expire_date":"2026-05-31","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"FZ-2024-137-SC-004","payment_collection_remind_ahead":"","from_project":3547,"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":false,"save_collection_at":null,"b_date":330,"passed":2,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09","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":3764,"comment":1},"project":{"id":3547,"key":3547,"name":"\u79d1\u7814\u7ecf\u8d39\u8f6f\u4ef6\u5f00\u53d1\u9879\u76ee"},"fromProject":{"id":3547,"key":3547,"name":"\u79d1\u7814\u7ecf\u8d39\u8f6f\u4ef6\u5f00\u53d1\u9879\u76ee","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":768,"bargain_date":"2025-01-13","collected":"0","profit_pct":"50","budget":"205900","projectProductTypes":[{"id":5918,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"205900.00","pct":"50","project_id":3547,"profit":"102950"}],"projectProductRels":[{"id":8744,"project_id":3547,"product_id":941,"amount":"205900.00","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":"205900","total_cost":"0","supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":102950,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"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":[{"id":8288,"user_id":1005,"key":1005,"contract_id":3764,"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":7746,"user_id":1005,"key":1005,"contract_id":3764,"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":2318,"key":2318,"contract_id":3764,"name":"2025-04-17","value":"205900","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f79\u5929"}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":31898,"object_type":105,"object_id":3764,"attachment_id":23793,"attachment":{"id":23793,"key":23793,"name":"16659143-832f-326b-a605-da7330b15868","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/16659143-832f-326b-a605-da7330b15868\/\u4e00\u6240-\u53cc\u7ae0.pdf","orig_name":"\u4e00\u6240-\u53cc\u7ae0.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":{"object_id":3764,"unread":1},"collected_plan":205900,"projectProductTotalAmount":205900,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":0,"un_invoiced":205900,"collected":0,"un_collected":205900,"is_collected":false,"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":1,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3745,"client_id":20,"signed_at":"2025-01-03","amount":"117000","handler":1005,"description":"","created_by":1005,"created_at":"2025-01-05 21:03:56","updated_at":"2025-01-24 16:17:06","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3721,"valid_date":null,"expire_date":"2026-01-29","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHY-20250122","payment_collection_remind_ahead":"1 day","from_project":3721,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-01-21 14:55:03.815555+08","b_date":208,"passed":2,"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\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":3745,"comment":8},"project":{"id":3721,"key":3721,"name":"MSS24-25\u5e74\u7eed\u4fdd"},"fromProject":{"id":3721,"key":3721,"name":"MSS24-25\u5e74\u7eed\u4fdd","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":765,"bargain_date":"2025-01-03","collected":"117000","profit_pct":"27.8","budget":"117000","projectProductTypes":[{"id":5952,"product_type_id":16,"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1","budget":"117000.00","pct":"27.8","project_id":3721,"profit":"32526"}],"projectProductRels":[{"id":8763,"project_id":3721,"product_id":1009,"amount":"117000.00","number":1,"cost":"76920.00","description":"","supplier_id":138,"hardware_from":null,"software_from":"2025-01-30","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-29","maintenance_to":null,"total_amount":"117000","total_cost":"76920","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":1009,"name":"\u5b89\u5168\u6258\u7ba1\u670d\u52a1MSS-40","product_type":19,"product_component":151,"product_brand":12,"product_serie":713,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-23 10:41:22","updated_at":"2023-12-27 17:12:17","pinyin_shortcut":"aqtgfwMSS40","product_unit":8,"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":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":713,"key":713,"name":"\u6258\u7ba1\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12589,"project_id":3721}],"reimbursementAmountSum":{"project_id":3721,"sum":"84.62"},"profit":32526,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2399,"contract_id":3745,"supplier_id":138,"purchase_id":3766,"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":3766,"key":3766,"serial_no":"SFSSFWH202501200015"}}],"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":7819,"user_id":1005,"key":1005,"contract_id":3745,"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":7820,"user_id":5388,"key":5388,"contract_id":3745,"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":7821,"user_id":1001,"key":1001,"contract_id":3745,"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":2323,"key":2323,"contract_id":3745,"name":"2025-03-07","value":"117000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2127,"key":2127,"contract_id":3745,"value":"117000","created_by":1013,"created_at":"2025-03-06 17:01:51","description":"","collected_date":"2025-03-06","amount":"117000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32711,"object_type":109,"object_id":2127,"attachment_id":24424,"attachment":{"id":24424,"key":24424,"name":"11992697-0dd6-36dd-bfbe-5164dce8569f","extension":"png","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/11992697-0dd6-36dd-bfbe-5164dce8569f\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1950,"key":1950,"contract_id":3745,"value":"117000.00","attachment_id":null,"from_date":"2025-02-18","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32353,"object_type":102,"object_id":1950,"attachment_id":24172,"attachment":{"id":24172,"key":24172,"name":"bfbb13a6-6274-37f0-ab52-22aa23000e5b","extension":"pdf","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/bfbb13a6-6274-37f0-ab52-22aa23000e5b\/dzfp_25112000000030816178_\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8_20250218094937.pdf","orig_name":"dzfp_25112000000030816178_\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8_20250218094937.pdf"}}]}],"contractScans":[{"id":32090,"object_type":105,"object_id":3745,"attachment_id":23888,"attachment":{"id":23888,"key":23888,"name":"2449b19b-d8ce-3519-9ec2-74cbb5bd585d","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/2449b19b-d8ce-3519-9ec2-74cbb5bd585d\/\u91cd\u578b\u673a\u68b0 117000\u5408\u540c.pdf","orig_name":"\u91cd\u578b\u673a\u68b0 117000\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":{"object_id":3745,"unread":5},"collected_plan":117000,"projectProductTotalAmount":117000,"projectProductAllAmount":true,"projectProductTotalCost":76920,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":117000,"un_invoiced":0,"collected":117000,"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\u524d1\u5929","can_update":false,"can_delete":false,"unread":5,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3744,"client_id":918,"signed_at":"2025-01-03","amount":"700","handler":1005,"description":"","created_by":1005,"created_at":"2025-01-03 13:49:53","updated_at":"2025-01-13 09:49:53","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3757,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSC-ZHY-2025010301","payment_collection_remind_ahead":"7 days","from_project":3757,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-01-07 10:58:38.336515+08","b_date":null,"passed":1,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\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":3744,"comment":7},"project":{"id":3757,"key":3757,"name":"H3C\u670d\u52a1\u5668\u786c\u76d8\u6362\u65b0"},"fromProject":{"id":3757,"key":3757,"name":"H3C\u670d\u52a1\u5668\u786c\u76d8\u6362\u65b0","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":745,"bargain_date":"2025-01-03","collected":"700","profit_pct":"41.5","budget":"700","projectProductTypes":[{"id":5887,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"700.00","pct":"41.5","project_id":3757,"profit":"290.5"}],"projectProductRels":[{"id":8495,"project_id":3757,"product_id":1922,"amount":"700.00","number":1,"cost":"350.00","description":"","supplier_id":59,"hardware_from":"2025-01-03","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-02","software_to":null,"maintenance_to":null,"total_amount":"700","total_cost":"350","supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":1922,"name":"0231A6KE","product_type":2,"product_component":5,"product_brand":20,"product_serie":1590,"product_misc":null,"product_qa":null,"pn":"","description":"600G 10K 2.5 SAS \u786c\u76d8","created_by":1013,"created_at":"2025-01-03 15:31:20","updated_at":"2025-01-03 15:31:20","pinyin_shortcut":"0231A6KE","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1590,"key":1590,"name":"SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12461,"project_id":3757}],"reimbursementAmountSum":null,"profit":290.5,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2336,"contract_id":3744,"supplier_id":59,"purchase_id":null,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":null},{"id":2407,"contract_id":3744,"supplier_id":59,"purchase_id":3721,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":3721,"key":3721,"serial_no":"TSKJ20250110-HYF-001"}}],"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":7687,"user_id":1005,"key":1005,"contract_id":3744,"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":7688,"user_id":5388,"key":5388,"contract_id":3744,"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":7689,"user_id":1001,"key":1001,"contract_id":3744,"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":2300,"key":2300,"contract_id":3744,"name":"2025-01-31","value":"700","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2078,"key":2078,"contract_id":3744,"value":"700","created_by":1013,"created_at":"2025-01-17 14:35:10","description":"","collected_date":"2025-01-17","amount":"700","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":31903,"object_type":109,"object_id":2078,"attachment_id":23795,"attachment":{"id":23795,"key":23795,"name":"926df2c2-9362-3827-a3c7-492f4398409e","extension":"png","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/926df2c2-9362-3827-a3c7-492f4398409e\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1921,"key":1921,"contract_id":3744,"value":"700.00","attachment_id":null,"from_date":"2025-01-03","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31532,"object_type":102,"object_id":1921,"attachment_id":23524,"attachment":{"id":23524,"key":23524,"name":"4f3aef01-90d0-31df-805b-1cf2bd4f5e7d","extension":"pdf","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/4f3aef01-90d0-31df-805b-1cf2bd4f5e7d\/dzfp_25112000000001858232_\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8_20250103140006.pdf","orig_name":"dzfp_25112000000001858232_\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8_20250103140006.pdf"}}]}],"contractScans":[{"id":31726,"object_type":105,"object_id":3744,"attachment_id":23558,"attachment":{"id":23558,"key":23558,"name":"fc332533-a0d1-30f7-be8c-aea22e98047d","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/fc332533-a0d1-30f7-be8c-aea22e98047d\/\u786c\u76d8.pdf","orig_name":"\u786c\u76d8.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":{"object_id":3744,"unread":4},"collected_plan":700,"projectProductTotalAmount":700,"projectProductAllAmount":true,"projectProductTotalCost":350,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":700,"un_invoiced":0,"collected":700,"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":4,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3736,"client_id":149,"signed_at":"2024-12-24","amount":"905150","handler":1005,"description":"","created_by":1005,"created_at":"2024-12-30 13:59:19","updated_at":"2025-01-02 10:41:15","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3720,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"FZ-2024-145-SC-007","payment_collection_remind_ahead":"7 days","from_project":3720,"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-30 15:44:22.474232+08","b_date":null,"passed":1,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09","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":3736,"comment":10},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"fromProject":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f","description":"","total_contact_point":"150000","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":785,"bargain_date":"2024-12-24","collected":"362060","profit_pct":"6.59","budget":"905150","projectProductTypes":[{"id":5839,"product_type_id":17,"key":17,"name":"\u5de5\u63a7\u673a","budget":"905150.00","pct":"6.59","project_id":3720,"profit":"59649.385"}],"projectProductRels":[{"id":8846,"project_id":3720,"product_id":950,"amount":"905150.00","number":1,"cost":"617500.00","description":"","supplier_id":516,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"905150","total_cost":"617500","supplier":{"id":516,"key":516,"name":"\u5929\u6d25\u665f\u6e90\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":950,"name":"\u4e8c\u4ee3\u8bc1\u751f\u4ea7\u81ea\u52a8\u5316\u8bbe\u5907","product_type":18,"product_component":152,"product_brand":136,"product_serie":596,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 16:25:49","updated_at":"2023-08-11 16:01:35","pinyin_shortcut":"edzsczdhsb","product_unit":5,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":152,"key":152,"name":"\u751f\u4ea7\u8f66\u95f4\u8bbe\u5907"},"productBrand":{"id":136,"key":136,"name":"\u665f\u6e90"},"productSerie":{"id":596,"key":596,"name":"\u81ea\u52a8\u5316\u8f66\u95f4\u751f\u4ea7\u8bbe\u5907"},"productUnit":{"id":5,"key":5,"name":"\u6279"}}},{"id":8847,"project_id":3720,"product_id":1943,"amount":"0","number":15,"cost":"15.00","description":"","supplier_id":478,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"225","supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1943,"name":"\u8d85\u516d\u7c7b\u7f51\u7ebf 5M","product_type":4,"product_component":43,"product_brand":191,"product_serie":813,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-02-26 15:20:21","updated_at":"2025-02-26 15:20:21","pinyin_shortcut":"cllwx5M","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":191,"key":191,"name":"\u957f\u987a\u7f51\u8054"},"productSerie":{"id":813,"key":813,"name":"\u8d85\u516d\u7c7b\u7f51\u7edc\u7ebf\u7f06"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}},{"id":8848,"project_id":3720,"product_id":1944,"amount":"0","number":10,"cost":"25.00","description":"","supplier_id":478,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"250","supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1944,"name":"\u8d85\u516d\u7c7b\u7f51\u7ebf 10M","product_type":4,"product_component":43,"product_brand":191,"product_serie":813,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-02-26 15:20:50","updated_at":"2025-02-26 15:20:50","pinyin_shortcut":"cllwx10M","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":191,"key":191,"name":"\u957f\u987a\u7f51\u8054"},"productSerie":{"id":813,"key":813,"name":"\u8d85\u516d\u7c7b\u7f51\u7edc\u7ebf\u7f06"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}},{"id":8849,"project_id":3720,"product_id":1945,"amount":"0","number":10,"cost":"35.00","description":"","supplier_id":478,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"350","supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1945,"name":"\u8d85\u516d\u7c7b\u7f51\u7ebf 15M","product_type":4,"product_component":43,"product_brand":191,"product_serie":813,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-02-26 15:21:14","updated_at":"2025-02-26 15:21:14","pinyin_shortcut":"cllwx15M","product_unit":null,"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":191,"key":191,"name":"\u957f\u987a\u7f51\u8054"},"productSerie":{"id":813,"key":813,"name":"\u8d85\u516d\u7c7b\u7f51\u7edc\u7ebf\u7f06"},"productUnit":null}}],"projectContactPoints":[{"id":833,"project_id":3720,"contact_id":4125,"point":"150000.00","paid_point":null,"contact":{"id":4125,"key":4125,"name":"\u738b\u5411\u4e1c","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":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":12670,"project_id":3720},{"id":12669,"project_id":3720},{"id":12668,"project_id":3720},{"id":12667,"project_id":3720}],"reimbursementAmountSum":{"project_id":3720,"sum":"190.20"},"profit":59649.385,"contact_points_status_display":"\u672a\u6838\u9500"},"salesSupplierRels":[{"id":2297,"contract_id":3736,"supplier_id":516,"purchase_id":3706,"supplier":{"id":516,"key":516,"name":"\u5929\u6d25\u665f\u6e90\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":3706,"key":3706,"serial_no":"TSKJ20241212-ZHY-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":7620,"user_id":1005,"key":1005,"contract_id":3736,"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":7621,"user_id":5388,"key":5388,"contract_id":3736,"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":7622,"user_id":1001,"key":1001,"contract_id":3736,"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":2283,"key":2283,"contract_id":3736,"name":"2025-01-30","value":"362060","overdue_days":11,"pct":40,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2284,"key":2284,"contract_id":3736,"name":"2025-03-20","value":"452575","overdue_days":null,"pct":50,"collect_status":"\u903e\u671f107\u5929"},{"id":2285,"key":2285,"contract_id":3736,"name":"2025-04-30","value":"90515","overdue_days":null,"pct":10,"collect_status":"\u903e\u671f66\u5929"}],"salesContractPayments":[{"id":2103,"key":2103,"contract_id":3736,"value":"362060","created_by":1013,"created_at":"2025-02-10 13:20:52","description":"","collected_date":"2025-02-10","amount":"362060","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32120,"object_type":109,"object_id":2103,"attachment_id":23969,"attachment":{"id":23969,"key":23969,"name":"2017dcfe-3a46-3a08-8a4f-67afc4d6683a","extension":"png","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/2017dcfe-3a46-3a08-8a4f-67afc4d6683a\/image.png","orig_name":"image.png"}}],"pct":40}],"salesContractInvoices":[{"id":1932,"key":1932,"contract_id":3736,"value":"362060.00","attachment_id":null,"from_date":"2025-01-09","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31661,"object_type":102,"object_id":1932,"attachment_id":23611,"attachment":{"id":23611,"key":23611,"name":"ba551459-45f5-3379-ab22-21fb0ddc2a89","extension":"pdf","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/ba551459-45f5-3379-ab22-21fb0ddc2a89\/dzfp_25112000000007050246_\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240_20250109151854.pdf","orig_name":"dzfp_25112000000007050246_\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240_20250109151854.pdf"}}]}],"contractScans":[{"id":31506,"object_type":105,"object_id":3736,"attachment_id":23487,"attachment":{"id":23487,"key":23487,"name":"25e09143-24cd-3f30-9cfd-9f71748a479a","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/25e09143-24cd-3f30-9cfd-9f71748a479a\/\u516c\u5b89\u90e8\u4e00\u6240-\u62d3\u5b9e.pdf","orig_name":"\u516c\u5b89\u90e8\u4e00\u6240-\u62d3\u5b9e.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":{"object_id":3736,"unread":6},"collected_plan":905150,"projectProductTotalAmount":905150,"projectProductAllAmount":true,"projectProductTotalCost":618325,"projectProductAllCost":true,"projectProductTotalCount":36,"invoiced":362060,"un_invoiced":543090,"collected":362060,"un_collected":543090,"is_collected":false,"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":6,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3735,"client_id":2548,"signed_at":"2024-12-16","amount":"774255","handler":1005,"description":"","created_by":1005,"created_at":"2024-12-30 13:53:11","updated_at":"2025-01-23 11:10:03","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3750,"valid_date":null,"expire_date":"2025-12-16","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHY-2024121601","payment_collection_remind_ahead":"7 days","from_project":3750,"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-30 15:32:02.266835+08","b_date":164,"passed":2,"client":{"id":2548,"key":2548,"name":"\u5317\u4eac\u6da6\u7fd4\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","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":3735,"comment":14},"project":{"id":3750,"key":3750,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"fromProject":{"id":3750,"key":3750,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":733,"bargain_date":"2024-12-16","collected":"309702","profit_pct":"15.61","budget":"774255","projectProductTypes":[{"id":5946,"product_type_id":17,"key":17,"name":"\u5de5\u63a7\u673a","budget":"774255.00","pct":"15.61","project_id":3750,"profit":"120861.2055"}],"projectProductRels":[{"id":8758,"project_id":3750,"product_id":950,"amount":"774255.00","number":1,"cost":"617500.00","description":"","supplier_id":516,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"774255","total_cost":"617500","supplier":{"id":516,"key":516,"name":"\u5929\u6d25\u665f\u6e90\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":950,"name":"\u4e8c\u4ee3\u8bc1\u751f\u4ea7\u81ea\u52a8\u5316\u8bbe\u5907","product_type":18,"product_component":152,"product_brand":136,"product_serie":596,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 16:25:49","updated_at":"2023-08-11 16:01:35","pinyin_shortcut":"edzsczdhsb","product_unit":5,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":152,"key":152,"name":"\u751f\u4ea7\u8f66\u95f4\u8bbe\u5907"},"productBrand":{"id":136,"key":136,"name":"\u665f\u6e90"},"productSerie":{"id":596,"key":596,"name":"\u81ea\u52a8\u5316\u8f66\u95f4\u751f\u4ea7\u8bbe\u5907"},"productUnit":{"id":5,"key":5,"name":"\u6279"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12708,"project_id":3750}],"reimbursementAmountSum":null,"profit":120861.2055,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2395,"contract_id":3735,"supplier_id":516,"purchase_id":3706,"supplier":{"id":516,"key":516,"name":"\u5929\u6d25\u665f\u6e90\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":3706,"key":3706,"serial_no":"TSKJ20241212-ZHY-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":7809,"user_id":1005,"key":1005,"contract_id":3735,"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":7810,"user_id":5388,"key":5388,"contract_id":3735,"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":7811,"user_id":1001,"key":1001,"contract_id":3735,"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":2280,"key":2280,"contract_id":3735,"name":"2025-01-31","value":"309702","overdue_days":18,"pct":40,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2281,"key":2281,"contract_id":3735,"name":"2025-03-20","value":"387127.5","overdue_days":null,"pct":50,"collect_status":"\u903e\u671f107\u5929"},{"id":2282,"key":2282,"contract_id":3735,"name":"2025-04-30","value":"77425.5","overdue_days":null,"pct":10,"collect_status":"\u903e\u671f66\u5929"}],"salesContractPayments":[{"id":2110,"key":2110,"contract_id":3735,"value":"309702","created_by":1013,"created_at":"2025-02-18 14:24:27","description":"","collected_date":"2025-02-18","amount":"309702","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32372,"object_type":109,"object_id":2110,"attachment_id":24184,"attachment":{"id":24184,"key":24184,"name":"22b4c2b8-33ad-3459-a6ff-914ebfd288b8","extension":"png","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/22b4c2b8-33ad-3459-a6ff-914ebfd288b8\/image.png","orig_name":"image.png"}}],"pct":40}],"salesContractInvoices":[{"id":1930,"key":1930,"contract_id":3735,"value":"309702.00","attachment_id":null,"from_date":"2025-01-09","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31963,"object_type":102,"object_id":1930,"attachment_id":23609,"attachment":{"id":23609,"key":23609,"name":"7fc35375-3021-3d2c-ba3b-8bac67ffeee9","extension":"pdf","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/7fc35375-3021-3d2c-ba3b-8bac67ffeee9\/dzfp_25112000000006979273_\u5317\u4eac\u6da6\u7fd4\u79d1\u6280\u6709\u9650\u516c\u53f8_20250109152620.pdf","orig_name":"dzfp_25112000000006979273_\u5317\u4eac\u6da6\u7fd4\u79d1\u6280\u6709\u9650\u516c\u53f8_20250109152620.pdf"}}]}],"contractScans":[{"id":32058,"object_type":105,"object_id":3735,"attachment_id":23918,"attachment":{"id":23918,"key":23918,"name":"84aebe73-4dea-3d9c-9230-4295966cfbcd","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/84aebe73-4dea-3d9c-9230-4295966cfbcd\/2025_01_23_11_02_45.pdf","orig_name":"2025_01_23_11_02_45.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":{"object_id":3735,"unread":11},"collected_plan":774255,"projectProductTotalAmount":774255,"projectProductAllAmount":true,"projectProductTotalCost":617500,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":309702,"un_invoiced":464553,"collected":309702,"un_collected":464553,"is_collected":false,"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":11,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3664,"client_id":918,"signed_at":"2024-11-30","amount":"387250","handler":1005,"description":"","created_by":1005,"created_at":"2024-11-15 10:43:29","updated_at":"2025-01-02 10:55:04","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3666,"valid_date":null,"expire_date":"2025-11-29","sla":"\u5de1\u68c0\u65f6\u95f4\u4e0d\u56fa\u5b9a\uff0c\u89c6\u5b9e\u9645\u60c5\u51b5\u53d8\u5316\u3002","remind_ahead":"7 days","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"TS-ZHY-2024113001","payment_collection_remind_ahead":"7 days","from_project":3666,"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-30 14:16:17.868947+08","b_date":147,"passed":2,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\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":3664,"comment":11},"project":{"id":3666,"key":3666,"name":"24-25\u5e74\u7eed\u4fdd\u9879\u76ee"},"fromProject":{"id":3666,"key":3666,"name":"24-25\u5e74\u7eed\u4fdd\u9879\u76ee","description":"","total_contact_point":"50000","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":801,"bargain_date":"2024-11-30","collected":"193625","profit_pct":"25.15","budget":"387250","projectProductTypes":[{"id":5844,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"387250.00","pct":"25.15","project_id":3666,"profit":"97393.375"}],"projectProductRels":[{"id":8930,"project_id":3666,"product_id":941,"amount":"100000","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":"100000","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"}}},{"id":8931,"project_id":3666,"product_id":942,"amount":"10000","number":1,"cost":"6000","description":"","supplier_id":355,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"10000","total_cost":"6000","supplier":{"id":355,"key":355,"name":"\u4e2d\u5317\u6c47\u901a(\u5317\u4eac)\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"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"}}},{"id":8932,"project_id":3666,"product_id":941,"amount":"1100","number":1,"cost":"0","description":"\u574f\u4e86\u518d\u627e\u4eba\u4fee","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1100","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"}}},{"id":8933,"project_id":3666,"product_id":853,"amount":"40500","number":1,"cost":"20400","description":"","supplier_id":74,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"40500","total_cost":"20400","supplier":{"id":74,"key":74,"name":"\u65b0\u534e\u4e09\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":853,"name":"H3C SDN(SNA Center,MAC\u7cfb\u7edf)\u539f\u5382\u7eed\u4fdd","product_type":4,"product_component":47,"product_brand":20,"product_serie":544,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2022-07-25 16:53:52","updated_at":"2023-08-11 16:13:49","pinyin_shortcut":"H3CSDNSNACenterMACxtycxb","product_unit":8,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":47,"key":47,"name":"\u7f51\u7edc\u8bbe\u5907\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":544,"key":544,"name":"H3C SDN\u7eed\u4fdd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}},{"id":8934,"project_id":3666,"product_id":941,"amount":"16500","number":1,"cost":"0","description":"\u5907\u4efd\u8f6f\u4ef6\u539f\u5382\u7eed\u4fdd","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"16500","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"}}},{"id":8935,"project_id":3666,"product_id":855,"amount":"36000","number":1,"cost":"19080","description":"","supplier_id":355,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"36000","total_cost":"19080","supplier":{"id":355,"key":355,"name":"\u4e2d\u5317\u6c47\u901a(\u5317\u4eac)\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":855,"name":"\u7ef4\u8c1b\u673a\u623f\u7cbe\u5bc6\u7a7a\u8c03\u4e00\u5e74\u7eed\u4fdd","product_type":18,"product_component":144,"product_brand":124,"product_serie":546,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2022-07-26 10:59:54","updated_at":"2023-08-11 16:13:35","pinyin_shortcut":"wdjfjmktynxb","product_unit":8,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":144,"key":144,"name":"\u7a7a\u8c03"},"productBrand":{"id":124,"key":124,"name":"\u7ef4\u8c1b"},"productSerie":{"id":546,"key":546,"name":"\u673a\u623f\u7a7a\u8c03\u7eed\u4fdd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}},{"id":8936,"project_id":3666,"product_id":329,"amount":"8700","number":1,"cost":"5548","description":"","supplier_id":138,"hardware_from":null,"software_from":"2025-02-01","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-31","maintenance_to":null,"total_amount":"8700","total_cost":"5548","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":329,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2018-01-04 11:22:48","updated_at":"2023-08-14 15:03:51","pinyin_shortcut":"sxfURLxtrjV50","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":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8937,"project_id":3666,"product_id":1876,"amount":"0","number":1,"cost":"8277","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"0","total_cost":"8277","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":1876,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-E600-BU\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1570,"product_misc":null,"product_qa":null,"pn":"","description":"400\u8fdc\u7a0b\u6280\u672f\u652f\u6301+\u8f6f\u4ef6\u5347\u7ea7+\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09","created_by":1013,"created_at":"2024-11-15 13:15:52","updated_at":"2024-11-15 13:15:52","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000E600BU","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1570,"key":1570,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-E600-BU\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8938,"project_id":3666,"product_id":1881,"amount":"8700","number":1,"cost":"3787","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"8700","total_cost":"3787","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":1881,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eVPN-1000-B400-BU\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":null,"product_misc":null,"product_qa":null,"pn":"","description":"400\u8fdc\u7a0b\u6280\u672f\u652f\u6301+\u8f6f\u4ef6\u5347\u7ea7+\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09","created_by":1013,"created_at":"2024-11-15 13:25:47","updated_at":"2024-11-15 13:25:47","pinyin_shortcut":"sxfcpzbrjsjfwsyyVPN1000B400BU","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":null,"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8939,"project_id":3666,"product_id":1877,"amount":"0","number":2,"cost":"7436","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"0","total_cost":"14872.00","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":1877,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-F640-BU\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":null,"product_misc":null,"product_qa":null,"pn":"","description":"400\u8fdc\u7a0b\u6280\u672f\u652f\u6301+\u8f6f\u4ef6\u5347\u7ea7+\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09","created_by":1013,"created_at":"2024-11-15 13:17:18","updated_at":"2024-11-15 13:17:18","pinyin_shortcut":"sxfcpzbrjsjfwsyyAF1000F640BU","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":null,"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8940,"project_id":3666,"product_id":1737,"amount":"7875","number":2,"cost":"5116","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"15750","total_cost":"10232.00","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":1737,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0 \u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1470,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-12 13:18:49","updated_at":"2024-08-12 13:18:49","pinyin_shortcut":"sxfwgsdrjV60xbfw","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1470,"key":1470,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0 \u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8941,"project_id":3666,"product_id":1148,"amount":"7875","number":2,"cost":"5116","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"15750","total_cost":"10232.00","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":1148,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6 V8.0","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":"2023-12-13 14:20:48","updated_at":"2023-12-13 14:20:48","pinyin_shortcut":"sxfaqynyzdyrjV80","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":8942,"project_id":3666,"product_id":1879,"amount":"0","number":2,"cost":"3081","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"0","total_cost":"6162","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":1879,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-D440-BU\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1573,"product_misc":null,"product_qa":null,"pn":"","description":"400\u8fdc\u7a0b\u6280\u672f\u652f\u6301+\u8f6f\u4ef6\u5347\u7ea7+\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09","created_by":1013,"created_at":"2024-11-15 13:23:01","updated_at":"2024-11-15 13:23:01","pinyin_shortcut":"sxfcpzbrjsjfwsyyAF1000D440BU","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1573,"key":1573,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-D440-BU\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8943,"project_id":3666,"product_id":1737,"amount":"4500","number":2,"cost":"1926","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"9000","total_cost":"3852","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":1737,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0 \u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1470,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-12 13:18:49","updated_at":"2024-08-12 13:18:49","pinyin_shortcut":"sxfwgsdrjV60xbfw","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1470,"key":1470,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0 \u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8944,"project_id":3666,"product_id":1148,"amount":"4500","number":2,"cost":"1926","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"9000","total_cost":"3852","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":1148,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6 V8.0","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":"2023-12-13 14:20:48","updated_at":"2023-12-13 14:20:48","pinyin_shortcut":"sxfaqynyzdyrjV80","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":8945,"project_id":3666,"product_id":1880,"amount":"8850","number":2,"cost":"3108.5","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"17700","total_cost":"6217","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":1880,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd\u670d\u52a1\uff08\u9002\u7528\u4e8eSdSec-1000-A600\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":null,"product_misc":null,"product_qa":null,"pn":"","description":"\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09+400\u8fdc\u7a0b\u6280\u672f\u652f\u6301","created_by":1013,"created_at":"2024-11-15 13:24:44","updated_at":"2024-11-15 13:24:44","pinyin_shortcut":"sxfcpzbfwsyySdSec1000A600","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":null,"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8946,"project_id":3666,"product_id":1878,"amount":"0","number":1,"cost":"5018","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"0","total_cost":"5018","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":1878,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eSTA-100-B420-BU\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1572,"product_misc":null,"product_qa":null,"pn":"","description":"400\u8fdc\u7a0b\u6280\u672f\u652f\u6301+\u8f6f\u4ef6\u5347\u7ea7+\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09","created_by":1013,"created_at":"2024-11-15 13:18:32","updated_at":"2024-11-15 13:18:32","pinyin_shortcut":"sxfcpzbrjsjfwsyySTA100B420BU","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1572,"key":1572,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eSTA-100-B420-BU\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8947,"project_id":3666,"product_id":960,"amount":"7950","number":1,"cost":"3136","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"7950","total_cost":"3136","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":960,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u611f\u77e5\u7cfb\u7edf\u63a2\u9488\u7279\u5f81\u5e93\u8f6f\u4ef6V2.0","product_type":4,"product_component":51,"product_brand":12,"product_serie":602,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-04 11:07:29","updated_at":"2023-08-11 15:59:57","pinyin_shortcut":"sxfaqgzxttztzkrjV20","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":602,"key":602,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u611f\u77e5\u7cfb\u7edf\u63a2\u9488\u7279\u5f81\u5e93\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8948,"project_id":3666,"product_id":1801,"amount":"0","number":1,"cost":"27174","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"0","total_cost":"27174","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":1801,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08SIP-1000-B400\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1514,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-09-29 16:10:27","updated_at":"2024-09-29 16:10:27","pinyin_shortcut":"sxfcpzbrjsjfwSIP1000B400","product_unit":8,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1514,"key":1514,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eSIP-1000-B400\uff09"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}},{"id":8949,"project_id":3666,"product_id":1882,"amount":"51000","number":1,"cost":"18234","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"51000","total_cost":"18234","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":1882,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u611f\u77e5\u7cfb\u7edf\u5e73\u53f0\u7279\u5f81\u5e93\u8f6f\u4ef6V2.0(\u9002\u7528\u4e8eSIP-1000-B400-BU)","product_type":4,"product_component":51,"product_brand":12,"product_serie":1318,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-15 14:13:40","updated_at":"2024-11-15 14:13:40","pinyin_shortcut":"sxfaqgzxtpttzkrjV20syySIP1000B400BU","product_unit":2,"is_renew":true,"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":1318,"key":1318,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u611f\u77e5\u7cfb\u7edf\u5e73\u53f0\u7279\u5f81\u5e93\u8f6f\u4ef6V2.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8950,"project_id":3666,"product_id":922,"amount":"39600.00","number":1,"cost":"38840.00","description":"","supplier_id":138,"hardware_from":null,"software_from":"2025-02-01","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-31","maintenance_to":null,"total_amount":"39600","total_cost":"38840","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":922,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1024,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:11:04","updated_at":"2024-01-25 15:18:25","pinyin_shortcut":"sxfzdjcxyptEDRxbfw","product_unit":2,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1024,"key":1024,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8951,"project_id":3666,"product_id":922,"amount":"0","number":1,"cost":"3500.00","description":"\u7f51\u5173ID\uff1a6616425403\uff0c\u7248\u672c\u662f6.0.2R1","supplier_id":684,"hardware_from":null,"software_from":"2025-03-07","maintenance_from":null,"hardware_to":null,"software_to":"2026-03-07","maintenance_to":null,"total_amount":"0","total_cost":"3500","supplier":{"id":684,"key":684,"name":"\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":922,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1024,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:11:04","updated_at":"2024-01-25 15:18:25","pinyin_shortcut":"sxfzdjcxyptEDRxbfw","product_unit":2,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1024,"key":1024,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[{"id":834,"project_id":3666,"contact_id":1848,"point":"50000.00","paid_point":null,"contact":{"id":1848,"key":1848,"name":"\u674e\u58a8","client_id":918,"supplier_id":null,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":12612,"project_id":3666},{"id":12611,"project_id":3666},{"id":12614,"project_id":3666},{"id":12615,"project_id":3666},{"id":12616,"project_id":3666},{"id":12617,"project_id":3666},{"id":12618,"project_id":3666},{"id":12613,"project_id":3666},{"id":12610,"project_id":3666},{"id":12605,"project_id":3666},{"id":12604,"project_id":3666},{"id":12599,"project_id":3666},{"id":12598,"project_id":3666},{"id":12597,"project_id":3666},{"id":12595,"project_id":3666},{"id":12594,"project_id":3666},{"id":12609,"project_id":3666},{"id":12608,"project_id":3666},{"id":12607,"project_id":3666},{"id":12606,"project_id":3666},{"id":12603,"project_id":3666},{"id":12601,"project_id":3666},{"id":12602,"project_id":3666},{"id":12600,"project_id":3666},{"id":12596,"project_id":3666},{"id":12619,"project_id":3666},{"id":12620,"project_id":3666},{"id":12593,"project_id":3666},{"id":12703,"project_id":3666}],"reimbursementAmountSum":{"project_id":3666,"sum":"189.13"},"profit":97393.375,"contact_points_status_display":"\u672a\u6838\u9500"},"salesSupplierRels":[{"id":2419,"contract_id":3664,"supplier_id":355,"purchase_id":3785,"supplier":{"id":355,"key":355,"name":"\u4e2d\u5317\u6c47\u901a(\u5317\u4eac)\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3785,"key":3785,"serial_no":"ZBHT2025021301"}},{"id":2475,"contract_id":3664,"supplier_id":684,"purchase_id":3818,"supplier":{"id":684,"key":684,"name":"\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3818,"key":3818,"serial_no":"SFSHFWH202503060228"}},{"id":2389,"contract_id":3664,"supplier_id":138,"purchase_id":3774,"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":3774,"key":3774,"serial_no":"SFJDFWH202501220039"}}],"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":{"id":549,"key":549,"contract_id":3664,"remind_date":"2025-04-30"},"serviceContractRemindDates":[{"id":549,"key":549,"contract_id":3664,"name":"2025-04-30"},{"id":550,"key":550,"contract_id":3664,"name":"2025-07-31"},{"id":551,"key":551,"contract_id":3664,"name":"2025-10-31"},{"id":548,"key":548,"contract_id":3664,"name":"2025-01-31"}],"salesContractRemindReceivers":[{"id":8264,"user_id":1005,"key":1005,"contract_id":3664,"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":8265,"user_id":1011,"key":1011,"contract_id":3664,"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"}}}],"serviceContractRemindReceivers":[{"id":468,"contract_id":3664,"user_id":1005,"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"}}}],"salesContractPaymentCollectionRemindReceivers":[{"id":7635,"user_id":1005,"key":1005,"contract_id":3664,"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":7636,"user_id":5388,"key":5388,"contract_id":3664,"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":7637,"user_id":1001,"key":1001,"contract_id":3664,"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":2271,"key":2271,"contract_id":3664,"name":"2025-01-30","value":"193625","overdue_days":null,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2272,"key":2272,"contract_id":3664,"name":"2025-05-15","value":"154900","overdue_days":null,"pct":40,"collect_status":"\u903e\u671f51\u5929"},{"id":2273,"key":2273,"contract_id":3664,"name":"2025-11-30","value":"38725","overdue_days":null,"pct":10,"collect_status":""}],"salesContractPayments":[{"id":2089,"key":2089,"contract_id":3664,"value":"193625","created_by":1013,"created_at":"2025-01-22 15:24:17","description":"","collected_date":"2025-01-22","amount":"193625","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32038,"object_type":109,"object_id":2089,"attachment_id":23903,"attachment":{"id":23903,"key":23903,"name":"08f03f04-3dec-3701-b1d3-bcbe9511d519","extension":"png","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/08f03f04-3dec-3701-b1d3-bcbe9511d519\/image.png","orig_name":"image.png"}}],"pct":50}],"salesContractInvoices":[{"id":1868,"key":1868,"contract_id":3664,"value":"193625.00","attachment_id":null,"from_date":"2024-11-21","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":30569,"object_type":102,"object_id":1868,"attachment_id":22836,"attachment":{"id":22836,"key":22836,"name":"a662e7a5-3c92-3596-871f-35f9597c4a8c","extension":"pdf","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/a662e7a5-3c92-3596-871f-35f9597c4a8c\/dzfp_24112000000187343651_\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8_20241121094928.pdf","orig_name":"dzfp_24112000000187343651_\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8_20241121094928.pdf"}}]},{"id":1923,"key":1923,"contract_id":3664,"value":"-193625.00","attachment_id":null,"from_date":"2025-01-03","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31533,"object_type":102,"object_id":1923,"attachment_id":23526,"attachment":{"id":23526,"key":23526,"name":"201c191b-f8e8-3250-b6e3-9df4ff7f468a","extension":"pdf","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/201c191b-f8e8-3250-b6e3-9df4ff7f468a\/dzfp_25112000000001808825_\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8_20250103140503.pdf","orig_name":"dzfp_25112000000001808825_\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8_20250103140503.pdf"}}]},{"id":1943,"key":1943,"contract_id":3664,"value":"193625.00","attachment_id":null,"from_date":"2025-01-20","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31932,"object_type":102,"object_id":1943,"attachment_id":23819,"attachment":{"id":23819,"key":23819,"name":"ad85bd9a-6226-3116-b765-ca6991dbf8e0","extension":"pdf","path":"\/v2\/attachment\/view\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/ad85bd9a-6226-3116-b765-ca6991dbf8e0\/dzfp_25112000000015489943_\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8_20250120101004.pdf","orig_name":"dzfp_25112000000015489943_\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8_20250120101004.pdf"}}]}],"contractScans":[{"id":31511,"object_type":105,"object_id":3664,"attachment_id":22710,"attachment":{"id":22710,"key":22710,"name":"6fe0be15-6902-38a6-8c5c-2ed7eb8a2a13","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/6fe0be15-6902-38a6-8c5c-2ed7eb8a2a13\/\u571f\u6728\u6280\u672f\u670d\u52a1.pdf","orig_name":"\u571f\u6728\u6280\u672f\u670d\u52a1.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":{"object_id":3664,"unread":3},"collected_plan":387250,"projectProductTotalAmount":387250,"projectProductAllAmount":true,"projectProductTotalCost":214413,"projectProductAllCost":true,"projectProductTotalCount":29,"invoiced":193625,"un_invoiced":193625,"collected":193625,"un_collected":193625,"is_collected":false,"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":"2025-04-30","remind_ahead_display":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":3,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3705,"client_id":93,"signed_at":"2024-11-29","amount":"458000","handler":1005,"description":"","created_by":1005,"created_at":"2024-12-12 13:39:18","updated_at":"2025-01-13 09:32:37","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3699,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"C202411290020","payment_collection_remind_ahead":"7 days","from_project":3699,"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-30 11:50:43.459323+08","b_date":null,"passed":1,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","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":3705,"comment":7},"project":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854"},"fromProject":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":802,"bargain_date":"2024-11-29","collected":"0","profit_pct":"11.13","budget":"458000","projectProductTypes":[{"id":5845,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"458000.00","pct":"11.13","project_id":3699,"profit":"50975.4"}],"projectProductRels":[{"id":8952,"project_id":3699,"product_id":1625,"amount":"72983.00","number":2,"cost":"62866.00","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"145966","total_cost":"125732","supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1625,"name":"FG-401F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1383,"product_misc":null,"product_qa":null,"pn":"","description":"FG-401F 18 x GE RJ45 ports (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 8 x GE SFP slots, 8 x 10GE SFP+ slots, SPU NP7 and CP9 hardware accelerated, 960GB onboard SSD storage, dual AC power supplies","created_by":1013,"created_at":"2024-05-31 16:02:22","updated_at":"2024-05-31 16:02:22","pinyin_shortcut":"FG401F","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1383,"key":1383,"name":"FG-401F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8953,"project_id":3699,"product_id":1626,"amount":"153265.00","number":2,"cost":"131830.00","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"306530","total_cost":"263660","supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1626,"name":"FC-10-0401F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1384,"product_misc":null,"product_qa":null,"pn":"","description":"FG-401F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium) -3Year","created_by":1013,"created_at":"2024-05-31 16:04:08","updated_at":"2024-05-31 16:04:08","pinyin_shortcut":"FC100401F9500236","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1384,"key":1384,"name":"FG-401F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8954,"project_id":3699,"product_id":941,"amount":"5504.00","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":"5504","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"}}},{"id":8955,"project_id":3699,"product_id":942,"amount":"0","number":1,"cost":"31000.00","description":"","supplier_id":534,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"31000","supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"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":12464,"project_id":3699},{"id":12465,"project_id":3699},{"id":12467,"project_id":3699},{"id":12466,"project_id":3699},{"id":12463,"project_id":3699},{"id":12704,"project_id":3699}],"reimbursementAmountSum":{"project_id":3699,"sum":"137"},"profit":50975.4,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2474,"contract_id":3705,"supplier_id":534,"purchase_id":3817,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3817,"key":3817,"serial_no":"2025022801-TSZHY5"}},{"id":2300,"contract_id":3705,"supplier_id":614,"purchase_id":3723,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3723,"key":3723,"serial_no":"BQ-S-2024-12-07-P"}}],"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":7638,"user_id":1005,"key":1005,"contract_id":3705,"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":7639,"user_id":5388,"key":5388,"contract_id":3705,"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":7640,"user_id":1001,"key":1001,"contract_id":3705,"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":2254,"key":2254,"contract_id":3705,"name":"2025-02-28","value":"458000","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f127\u5929"}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":31512,"object_type":105,"object_id":3705,"attachment_id":23140,"attachment":{"id":23140,"key":23140,"name":"221be467-2e34-378b-a893-1dc8bbcc49c3","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/221be467-2e34-378b-a893-1dc8bbcc49c3\/\u5eb7\u9f99\u5316\u6210.pdf","orig_name":"\u5eb7\u9f99\u5316\u6210.pdf"}}],"receiptScans":[{"id":31723,"object_type":106,"object_id":3705,"attachment_id":23652,"attachment":{"id":23652,"key":23652,"name":"a0dbfb7d-deaa-30cb-ac43-f293a9cd8d43","extension":"pdf","path":"\/v2\/attachment\/preview\/ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF\/a0dbfb7d-deaa-30cb-ac43-f293a9cd8d43\/\u9632\u706b\u5899.pdf","orig_name":"\u9632\u706b\u5899.pdf"}}],"verifyScans":[],"unreadComments":{"object_id":3705,"unread":3},"collected_plan":458000,"projectProductTotalAmount":458000,"projectProductAllAmount":true,"projectProductTotalCost":420392,"projectProductAllCost":true,"projectProductTotalCount":6,"invoiced":0,"un_invoiced":458000,"collected":0,"un_collected":458000,"is_collected":false,"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":3,"bgcolor":"#89c541","can_view_product":true,"can_progress":true}],"pagenation":{"totalcount":434,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-05 13:30:32') RETURNING "id"