68955e760e7e9: POST https://beta.jinchangxiao.com/v2/sales-contract/of-client at 2025-08-08 10:18:30 am by 223.104.39.199
Database Queries
总计60条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:18:31.769 | 3.9 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA' |
| 10:18:31.775 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:18:31.779 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='90') AND ("deleted"=FALSE) |
| 10:18:31.784 | 8.0 ms | SELECT | SELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='90' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 10:18:31.793 | 5.7 ms | SELECT | SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='90' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 |
| 10:18:31.799 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=90 |
| 10:18:31.800 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:18:31.800 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 10:18:31.801 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5015) |
| 10:18:31.801 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5015)) |
| 10:18:31.801 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 9) |
| 10:18:31.802 | 19.8 ms | SELECT | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544)) GROUP BY "object_id" |
| 10:18:31.822 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3731, 3677, 3446, 3481, 3415, 3296, 3236, 3114, 3099, 3080) |
| 10:18:31.822 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3080, 3099, 3114, 3236, 3296, 3415, 3446, 3481, 3677, 3731)) |
| 10:18:31.823 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "description", "total_contact_point", "paid_contact_point", "is_sales_order_ready", "project_product_version_id", "bargain_date", "collected", "profit_pct", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3731, 3677, 3446, 3481, 3415, 3296, 3236, 3114, 3099, 3080) |
| 10:18:31.824 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3080, 3099, 3114, 3236, 3296, 3415, 3446, 3481, 3677, 3731)) |
| 10:18:31.825 | 0.7 ms | SELECT | SELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3080, 3099, 3114, 3236, 3296, 3415, 3446, 3481, 3677, 3731) |
| 10:18:31.825 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3080, 3099, 3114, 3236, 3296, 3415, 3446, 3481, 3677, 3731) |
| 10:18:31.826 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (116, 262, 659, 489, 165, 503, 313) |
| 10:18:31.827 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1034, 1834, 941, 1852, 1531, 1511, 1890, 1891, 237, 9, 505, 1541, 1542, 1543, 1544, 151, 229) |
| 10:18:31.828 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 4, 2, 19, 5, 3) |
| 10:18:31.828 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (30, 47, 43, 12, 13, 19, 151, 35, 14, 15) |
| 10:18:31.829 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (16, 3, 133, 8, 9, 173, 6, 47) |
| 10:18:31.829 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1240, 1332, 1321, 68, 783, 1331, 592, 630, 1545, 1559, 61, 1149, 1058, 831, 1051, 1025) |
| 10:18:31.830 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 8, 4, 1, 7, 6, 3) |
| 10:18:31.830 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3080, 3099, 3114, 3236, 3296, 3415, 3446, 3481, 3677, 3731) |
| 10:18:31.831 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=443 |
| 10:18:31.831 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=90 |
| 10:18:31.832 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((443, 3296), (443, 3114), (443, 3236), (443, 3446), (443, 3731), (443, 3677)) |
| 10:18:31.832 | 2.1 ms | SELECT | SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3080, 3099, 3114, 3236, 3296, 3415, 3446, 3481, 3677, 3731)) |
| 10:18:31.834 | 1.6 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3080, 3099, 3114, 3236, 3296, 3415, 3446, 3481, 3677, 3731)) GROUP BY "project_id" |
| 10:18:31.836 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544) |
| 10:18:31.837 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (165, 262, 608, 313, 503, 659, 68, 298, 671, 489) |
| 10:18:31.837 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3093, 3827, 3213, 3090, 3288, 3217, 3262, 3216, 3351, 3352, 3037, 2731, 3036, 3643, 3667, 3599, 3938, 3718, 3688) |
| 10:18:31.838 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (2, 1) |
| 10:18:31.838 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:18:31.839 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 10:18:31.839 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544)) ORDER BY "remind_date" |
| 10:18:31.839 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544) |
| 10:18:31.840 | 0.4 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544) |
| 10:18:31.840 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1011) |
| 10:18:31.841 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5295)) |
| 10:18:31.841 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544) |
| 10:18:31.841 | 0.4 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544) |
| 10:18:31.842 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5388, 1001) |
| 10:18:31.842 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5388, 1001)) |
| 10:18:31.843 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544) ORDER BY "remind_date" |
| 10:18:31.843 | 3.5 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "r" WHERE "contract_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544) ORDER BY "id" DESC |
| 10:18:31.847 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1014) |
| 10:18:31.847 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544) ORDER BY "id" |
| 10:18:31.848 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1334, 1347, 1362, 1437, 1565, 1579, 1618, 1626, 1672, 1837, 1838, 1839, 1872, 1893)) |
| 10:18:31.850 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1334, 1347, 1362, 1437, 1565, 1579, 1618, 1626, 1672, 1837, 1838, 1839, 1872, 1893)) |
| 10:18:31.851 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (11909, 12085, 12435, 23092, 13994, 22875, 16779, 17069, 22220, 18247, 18392, 19542, 22222) |
| 10:18:31.852 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544)) |
| 10:18:31.853 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (11905, 12436, 12084, 16770, 13993, 17070, 18329, 22148, 18240, 23080) |
| 10:18:31.854 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544)) |
| 10:18:31.855 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (12438, 14433, 22532, 17157, 17181, 18432, 19001, 23355) |
| 10:18:31.855 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544)) |
| 10:18:31.857 | 16.9 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id" IN (3696, 3597, 3188, 3200, 3061, 3027, 2753, 2563, 2593, 2544)) GROUP BY "object_id" |
| 10:18:31.877 | 3.6 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1146, 'v2/sales-contract/of-client', '{"access_token":"qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA","device_type":"2","id":"90","page":"1","posttime":"1754619520","token":"d183ecdc572571f36262181d793cf986","version_code":"1146"}', '{"code":200,"data":{"list":[{"id":3696,"client_id":90,"signed_at":"2024-11-29","amount":"229600","handler":5295,"description":"","created_by":5295,"created_at":"2024-12-06 10:29:06","updated_at":"2025-01-02 14:36:47","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3731,"valid_date":null,"expire_date":"2026-12-31","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"TS-WZW-2024112901","payment_collection_remind_ahead":"7 days","from_project":3731,"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-20 16:26:42","is_verify":false,"is_draft":false,"erp_settle_amount":"229600","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":510,"passed":2,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3696,"comment":8},"project":{"id":3731,"key":3731,"name":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd","erpSalesOrder":null},"fromProject":{"id":3731,"key":3731,"name":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd","description":"","total_contact_point":"39000","paid_contact_point":"39000","is_sales_order_ready":true,"project_product_version_id":779,"bargain_date":"2024-11-29","collected":"229600","profit_pct":"48.22","budget":"229600","erpSalesOrder":null,"projectProductTypes":[{"id":5852,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"229600.00","pct":"48.22","project_id":3731,"profit":"110713.12"}],"projectProductRels":[{"id":8802,"project_id":3731,"product_id":1511,"amount":"31800.00","number":1,"cost":"10008.00","description":"","supplier_id":659,"hardware_from":null,"software_from":"2024-12-22","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-20","maintenance_to":null,"total_amount":"31800","total_cost":"10008","erp_sales_order_product_id":null,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":null,"product_qa":null,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2024-03-13 17:49:30","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":null},{"id":8803,"project_id":3731,"product_id":1511,"amount":"31800.00","number":3,"cost":"10008.00","description":"","supplier_id":659,"hardware_from":null,"software_from":"2025-01-21","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-20","maintenance_to":null,"total_amount":"95400","total_cost":"30024","erp_sales_order_product_id":null,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":null,"product_qa":null,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2024-03-13 17:49:30","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":null},{"id":8804,"project_id":3731,"product_id":1890,"amount":"31800.00","number":1,"cost":"11167.00","description":"","supplier_id":659,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"31800","total_cost":"11167","erp_sales_order_product_id":null,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1890,"name":"V-FDNVUL-0I-SU1YP-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":61,"product_misc":null,"product_qa":null,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 10 instance pack. 1 Year Subscription Upfront Billing & Production (24\/7) Support.","created_by":1013,"created_at":"2024-12-10 11:30:30","updated_at":"2024-12-10 11:30:30","pinyin_shortcut":"VFDNVUL0ISU1YP00","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":16,"key":16,"name":"Veeam"},"productSerie":{"id":61,"key":61,"name":"Veeam \u865a\u62df\u5316\u5907\u4efd"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":null},{"id":8805,"project_id":3731,"product_id":941,"amount":"1900.00","number":12,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"22800","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null},{"id":8806,"project_id":3731,"product_id":941,"amount":"11000.00","number":1,"cost":"0","description":"Netapp E2724","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"11000","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null},{"id":8807,"project_id":3731,"product_id":941,"amount":"17000.00","number":1,"cost":"0","description":"Netapp FAS2750","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"17000","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null},{"id":8808,"project_id":3731,"product_id":941,"amount":"14000.00","number":1,"cost":"0","description":"Netapp FAS2650","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"14000","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null},{"id":8809,"project_id":3731,"product_id":941,"amount":"2800.00","number":1,"cost":"0","description":"HPE DL388G9","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"2800","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null},{"id":8810,"project_id":3731,"product_id":941,"amount":"1500.00","number":2,"cost":"0","description":"\u601d\u79d19148S","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"3000","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null},{"id":8811,"project_id":3731,"product_id":1891,"amount":"0","number":1,"cost":"800.00","description":"FAS2650\u7ef4\u4fdd\u5907\u4ef6\u76d8","supplier_id":489,"hardware_from":"2024-12-03","software_from":null,"maintenance_from":null,"hardware_to":"2025-12-02","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"800","erp_sales_order_product_id":null,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1891,"name":"X426A-R6","product_type":3,"product_component":15,"product_brand":6,"product_serie":1149,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-12-10 13:33:21","updated_at":"2024-12-10 13:33:21","pinyin_shortcut":"X426AR6","product_unit":4,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1149,"key":1149,"name":"1.8T 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":null},{"id":8812,"project_id":3731,"product_id":1891,"amount":"0","number":1,"cost":"600.00","description":"FAS2750\u7ef4\u4fdd\u5907\u4ef6\u76d8","supplier_id":165,"hardware_from":"2025-02-13","software_from":null,"maintenance_from":null,"hardware_to":"2026-02-12","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"600","erp_sales_order_product_id":null,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1891,"name":"X426A-R6","product_type":3,"product_component":15,"product_brand":6,"product_serie":1149,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-12-10 13:33:21","updated_at":"2024-12-10 13:33:21","pinyin_shortcut":"X426AR6","product_unit":4,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1149,"key":1149,"name":"1.8T 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":null}],"projectContactPoints":[{"id":841,"project_id":3731,"contact_id":443,"point":"39000.00","paid_point":"39000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":148,"project_id":3731,"contact_id":443,"point":"39000.00","day_at":"2025-01-02","description":"","created_at":"2025-01-02 14:36:47"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12380,"project_id":3731},{"id":12379,"project_id":3731},{"id":12378,"project_id":3731},{"id":12377,"project_id":3731},{"id":12376,"project_id":3731},{"id":12375,"project_id":3731},{"id":12374,"project_id":3731},{"id":12381,"project_id":3731},{"id":12383,"project_id":3731},{"id":12382,"project_id":3731},{"id":12628,"project_id":3731}],"reimbursementAmountSum":{"project_id":3731,"sum":"820.95"},"profit":110713.12,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":2497,"contract_id":3696,"supplier_id":165,"purchase_id":3827,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3827,"key":3827,"serial_no":"20250213"}},{"id":2738,"contract_id":3696,"supplier_id":262,"purchase_id":3938,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3938,"key":3938,"serial_no":"\u8ba2\u5355\u53f7\uff1a 318600351430"}},{"id":2309,"contract_id":3696,"supplier_id":659,"purchase_id":3718,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":3718,"key":3718,"serial_no":"XM2024121700120"}},{"id":2328,"contract_id":3696,"supplier_id":489,"purchase_id":3688,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3688,"key":3688,"serial_no":"TSKJ20241203-HYF-001"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8266,"user_id":5295,"key":5295,"contract_id":3696,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":8267,"user_id":1011,"key":1011,"contract_id":3696,"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":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7659,"user_id":5295,"key":5295,"contract_id":3696,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":7660,"user_id":5388,"key":5388,"contract_id":3696,"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":7661,"user_id":1001,"key":1001,"contract_id":3696,"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":2219,"key":2219,"contract_id":3696,"name":"2024-12-20","value":"229600","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1185","key":"1185","contract_id":3696,"value":"229600","created_by":1013,"created_at":"2024-12-13 09:12:00","description":null,"collected_date":"2024-12-13 09:12:00","amount":"229600","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1893,"key":1893,"contract_id":3696,"value":"229600.00","attachment_id":null,"from_date":"2024-12-09","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":30957,"object_type":102,"object_id":1893,"attachment_id":23092,"attachment":{"id":23092,"key":23092,"name":"a9118e59-86f2-3af0-8538-b0864f11f8fb","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/a9118e59-86f2-3af0-8538-b0864f11f8fb\/dzfp_24112000000204391664_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20241209094412.pdf","orig_name":"dzfp_24112000000204391664_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20241209094412.pdf"}}]}],"contractScans":[{"id":31527,"object_type":105,"object_id":3696,"attachment_id":23080,"attachment":{"id":23080,"key":23080,"name":"66ed48f1-eb01-3824-b927-c13490953ee7","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/66ed48f1-eb01-3824-b927-c13490953ee7\/\u82cf\u9ece\u4e16.pdf","orig_name":"\u82cf\u9ece\u4e16.pdf"}}],"receiptScans":[{"id":31279,"object_type":106,"object_id":3696,"attachment_id":23355,"attachment":{"id":23355,"key":23355,"name":"7fde2264-7c5d-3d1a-a93d-01a838dfd18f","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/7fde2264-7c5d-3d1a-a93d-01a838dfd18f\/\u82cf\u9ece\u4e16-\u8d27\u7269\u7b7e\u6536\u535520241220.pdf","orig_name":"\u82cf\u9ece\u4e16-\u8d27\u7269\u7b7e\u6536\u535520241220.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":229600,"projectProductTotalAmount":229600,"projectProductAllAmount":true,"projectProductTotalCost":52599,"projectProductAllCost":true,"projectProductTotalCount":25,"invoiced":229600,"un_invoiced":0,"collected":"229600","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":3597,"client_id":90,"signed_at":"2024-10-12","amount":"406550","handler":5295,"description":"","created_by":5295,"created_at":"2024-10-15 16:17:44","updated_at":"2024-12-12 14:44:55","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3677,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WEW2024101201","payment_collection_remind_ahead":"7 days","from_project":3677,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-11-01 15:46:01","is_verify":false,"is_draft":false,"erp_settle_amount":"406550","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"passed":1,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3597,"comment":12},"project":{"id":3677,"key":3677,"name":"\u65b0\u8d2d\u6234\u5c14\u5b58\u50a8","erpSalesOrder":null},"fromProject":{"id":3677,"key":3677,"name":"\u65b0\u8d2d\u6234\u5c14\u5b58\u50a8","description":"","total_contact_point":"65000","paid_contact_point":"65000","is_sales_order_ready":true,"project_product_version_id":678,"bargain_date":"2024-10-12","collected":"406550","profit_pct":"7.87","budget":"406550","erpSalesOrder":null,"projectProductTypes":[{"id":5696,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"406550","pct":"7.87","project_id":3677,"profit":"31995.485"}],"projectProductRels":[{"id":7894,"project_id":3677,"product_id":1834,"amount":"367550","number":1,"cost":"278000","description":"","supplier_id":116,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"367550","total_cost":"278000","erp_sales_order_product_id":null,"supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"product":{"id":1834,"name":"Unity XT 480","product_type":3,"product_component":14,"product_brand":9,"product_serie":1545,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-10-16 09:35:39","updated_at":"2024-10-16 09:35:39","pinyin_shortcut":"UnityXT480","product_unit":1,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":9,"key":9,"name":"\u6234\u5c14\uff08DELL\uff09"},"productSerie":{"id":1545,"key":1545,"name":"DELL EMC Unity XT 480 \u5b58\u50a8\u9635\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":null},{"id":7895,"project_id":3677,"product_id":941,"amount":"39000","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":"39000","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null},{"id":7896,"project_id":3677,"product_id":1852,"amount":"0","number":2,"cost":"37.79","description":"","supplier_id":262,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"75.57","erp_sales_order_product_id":null,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"product":{"id":1852,"name":"\u5c71\u6cfd LC-LC\u591a\u6a21\u53cc\u82afOM3-300\u4e07\u5146\u5149\u7ea4\u8df3\u7ebf15\u7c73\uff08G3-LCLC1\uff095","product_type":4,"product_component":43,"product_brand":173,"product_serie":1559,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-10-30 10:53:53","updated_at":"2024-10-30 10:53:53","pinyin_shortcut":"szLCLCdmsxOM3300wzgxtx15mG3LCLC15","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":173,"key":173,"name":"\u5c71\u6cfd"},"productSerie":{"id":1559,"key":1559,"name":"\u5149\u7ea4\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":null}],"projectContactPoints":[{"id":766,"project_id":3677,"contact_id":443,"point":"65000.00","paid_point":"65000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":130,"project_id":3677,"contact_id":443,"point":"65000.00","day_at":"2024-12-12","description":"","created_at":"2024-12-12 14:44:55"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12318,"project_id":3677},{"id":12130,"project_id":3677},{"id":12131,"project_id":3677}],"reimbursementAmountSum":{"project_id":3677,"sum":"5504.11"},"profit":31995.485,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":2187,"contract_id":3597,"supplier_id":298,"purchase_id":3643,"supplier":{"id":298,"key":298,"name":"\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3643,"key":3643,"serial_no":"TSKJ20241101-HYF-001"}},{"id":2188,"contract_id":3597,"supplier_id":262,"purchase_id":3667,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3667,"key":3667,"serial_no":"305882210752"}},{"id":2189,"contract_id":3597,"supplier_id":671,"purchase_id":3599,"supplier":{"id":671,"key":671,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u6570\u5b57\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3599,"key":3599,"serial_no":"TSKJ20241016-HYF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7300,"user_id":5295,"key":5295,"contract_id":3597,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":7301,"user_id":5388,"key":5388,"contract_id":3597,"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":7302,"user_id":1001,"key":1001,"contract_id":3597,"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":2122,"key":2122,"contract_id":3597,"name":"2024-12-31","value":"406550","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1171","key":"1171","contract_id":3597,"value":"203275","created_by":1013,"created_at":"2024-12-06 11:20:28","description":null,"collected_date":"2024-12-06 11:20:28","amount":"203275","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50},{"id":"1170","key":"1170","contract_id":3597,"value":"203275","created_by":1013,"created_at":"2024-11-07 17:07:22","description":null,"collected_date":"2024-11-07 17:07:22","amount":"203275","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50}],"salesContractInvoices":[{"id":1837,"key":1837,"contract_id":3597,"value":"406550.00","attachment_id":null,"from_date":"2024-10-24","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":29595,"object_type":102,"object_id":1837,"attachment_id":22220,"attachment":{"id":22220,"key":22220,"name":"943f0bc3-4ac5-3265-a4ff-60c3bab035be","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/943f0bc3-4ac5-3265-a4ff-60c3bab035be\/dzfp_24112000000162663225_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20241025155058.pdf","orig_name":"dzfp_24112000000162663225_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20241025155058.pdf"}}]},{"id":1838,"key":1838,"contract_id":3597,"value":"-406550.00","attachment_id":null,"from_date":"2024-10-25","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[]},{"id":1839,"key":1839,"contract_id":3597,"value":"203275.00","attachment_id":null,"from_date":"2024-10-25","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":29870,"object_type":102,"object_id":1839,"attachment_id":22222,"attachment":{"id":22222,"key":22222,"name":"30dfec03-03af-3496-aae9-e3cf16941075","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/30dfec03-03af-3496-aae9-e3cf16941075\/dzfp_24112000000162645432_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20241025155331.pdf","orig_name":"dzfp_24112000000162645432_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20241025155331.pdf"}}]},{"id":1872,"key":1872,"contract_id":3597,"value":"203275.00","attachment_id":null,"from_date":"2024-11-22","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":30620,"object_type":102,"object_id":1872,"attachment_id":22875,"attachment":{"id":22875,"key":22875,"name":"8f4850b0-93ff-3a85-93c6-58e4a74388ff","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/8f4850b0-93ff-3a85-93c6-58e4a74388ff\/dzfp_24112000000189001902_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20241122150658.pdf","orig_name":"dzfp_24112000000189001902_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20241122150658.pdf"}}]}],"contractScans":[{"id":31031,"object_type":105,"object_id":3597,"attachment_id":22148,"attachment":{"id":22148,"key":22148,"name":"047ad9f8-df0e-3b2d-8b0b-24cc18c44e4d","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/047ad9f8-df0e-3b2d-8b0b-24cc18c44e4d\/\u82cf\u9ece\u4e16.pdf","orig_name":"\u82cf\u9ece\u4e16.pdf"}}],"receiptScans":[{"id":30052,"object_type":106,"object_id":3597,"attachment_id":22532,"attachment":{"id":22532,"key":22532,"name":"042f6008-f596-334b-bee8-d01714881696","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/042f6008-f596-334b-bee8-d01714881696\/\u82cf\u9ece\u4e16.pdf","orig_name":"\u82cf\u9ece\u4e16.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":406550,"projectProductTotalAmount":406550,"projectProductAllAmount":true,"projectProductTotalCost":278075.57,"projectProductAllCost":true,"projectProductTotalCount":4,"invoiced":406550,"un_invoiced":0,"collected":"406550","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":3188,"client_id":90,"signed_at":"2024-03-20","amount":"455400","handler":5295,"description":"","created_by":5295,"created_at":"2024-03-20 14:40:18","updated_at":"2024-07-02 16:36:59","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3446,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SLS-SLKX20240312","payment_collection_remind_ahead":"","from_project":3446,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"455400","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"passed":1,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3188,"comment":10},"project":{"id":3446,"key":3446,"name":"\u601d\u79d1\u670d\u52a1\u5668\u65b0\u8d2d+\u6570\u636e\u8fc1\u79fb","erpSalesOrder":null},"fromProject":{"id":3446,"key":3446,"name":"\u601d\u79d1\u670d\u52a1\u5668\u65b0\u8d2d+\u6570\u636e\u8fc1\u79fb","description":"","total_contact_point":"110000","paid_contact_point":"110000","is_sales_order_ready":true,"project_product_version_id":324,"bargain_date":"2024-03-20","collected":"455400","profit_pct":"29.79","budget":"455400","erpSalesOrder":null,"projectProductTypes":[{"id":4397,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"455400.00","pct":"29.79","project_id":3446,"profit":"135663.66"}],"projectProductRels":[{"id":5341,"project_id":3446,"product_id":1541,"amount":"91600","number":1,"cost":"50000","description":"","supplier_id":503,"hardware_from":"2024-04-10","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-10","software_to":null,"maintenance_to":null,"total_amount":"91600","total_cost":"50000","erp_sales_order_product_id":null,"supplier":{"id":503,"key":503,"name":"\u5e7f\u4e1c\u82f1\u901a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1541,"name":"UCS-SP-5108-AC3","product_type":2,"product_component":12,"product_brand":3,"product_serie":68,"product_misc":null,"product_qa":null,"pn":"","description":"Select 5108 AC2 Chassisw\/2304 IO,4x SFPcab 3m","created_by":1013,"created_at":"2024-04-08 10:45:27","updated_at":"2024-04-08 10:45:27","pinyin_shortcut":"UCSSP5108AC3","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":12,"key":12,"name":"\u670d\u52a1\u5668\u5200\u7247\u673a\u7bb1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":68,"key":68,"name":"\u601d\u79d1UCS5108\u5200\u7247\u673a\u7bb1"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":null},{"id":5342,"project_id":3446,"product_id":1542,"amount":"1900","number":1,"cost":"0","description":"\u4ee3\u7406\u5546\u8d28\u4fdd\u4e00\u5e74","supplier_id":503,"hardware_from":"2024-04-10","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-10","software_to":null,"maintenance_to":null,"total_amount":"1900","total_cost":"0","erp_sales_order_product_id":null,"supplier":{"id":503,"key":503,"name":"\u5e7f\u4e1c\u82f1\u901a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1542,"name":"CON-SNT-5108AC3","product_type":2,"product_component":13,"product_brand":3,"product_serie":783,"product_misc":null,"product_qa":null,"pn":"","description":"SMARTNET 8X5XNBD, UCS SP Select 5108 AC2 Chassis w\/2304 IO,","created_by":1013,"created_at":"2024-04-08 10:46:26","updated_at":"2024-04-08 10:46:26","pinyin_shortcut":"CONSNT5108AC3","product_unit":8,"is_renew":true,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":13,"key":13,"name":"\u670d\u52a1\u5668\u91d1\u724c\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":783,"key":783,"name":"\u601d\u79d1 5108\u5200\u7bb1\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":null},{"id":5343,"project_id":3446,"product_id":1543,"amount":"119500","number":2,"cost":"40000","description":"","supplier_id":503,"hardware_from":"2024-04-10","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-10","software_to":null,"maintenance_to":null,"total_amount":"239000","total_cost":"80000","erp_sales_order_product_id":null,"supplier":{"id":503,"key":503,"name":"\u5e7f\u4e1c\u82f1\u901a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1543,"name":"UCS-FI-6332-16UP","product_type":4,"product_component":19,"product_brand":3,"product_serie":1331,"product_misc":null,"product_qa":null,"pn":"","description":"UCS 6332-16UP 1RU FI\/No PSU\/24 QSFP+ 16UP\/4x40G Lic\/8xUP Lic","created_by":1013,"created_at":"2024-04-08 10:48:44","updated_at":"2024-04-08 10:48:44","pinyin_shortcut":"UCSFI633216UP","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1331,"key":1331,"name":"\u601d\u79d1UCS-FI-6332-16UP\u4e92\u8054\u77e9\u9635\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":null},{"id":5344,"project_id":3446,"product_id":1544,"amount":"20750","number":2,"cost":"0","description":"\u4ee3\u7406\u5546\u8d28\u4fdd\u4e00\u5e74","supplier_id":503,"hardware_from":"2024-04-10","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-10","software_to":null,"maintenance_to":null,"total_amount":"41500","total_cost":"0","erp_sales_order_product_id":null,"supplier":{"id":503,"key":503,"name":"\u5e7f\u4e1c\u82f1\u901a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1544,"name":"CON-SNT-633216UP","product_type":4,"product_component":47,"product_brand":3,"product_serie":1332,"product_misc":null,"product_qa":null,"pn":"","description":"SMARTNET 8X5XNBD, UCS 6332-16UP 1RU FI\/No PSU\/24 QSFP+ 16UP\/","created_by":1013,"created_at":"2024-04-08 10:49:45","updated_at":"2024-04-08 10:49:45","pinyin_shortcut":"CONSNT633216UP","product_unit":8,"is_renew":true,"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":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1332,"key":1332,"name":"\u601d\u79d1UCS-FI-6332-16UP\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":null},{"id":5345,"project_id":3446,"product_id":151,"amount":"0","number":4,"cost":"450","description":"","supplier_id":313,"hardware_from":"2024-04-10","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-10","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"1800","erp_sales_order_product_id":null,"supplier":{"id":313,"key":313,"name":"\u5317\u4eac\u6c49\u91d1\u82f1\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"product":{"id":151,"name":"DS-SFP-FC16G-SW=","product_type":4,"product_component":43,"product_brand":3,"product_serie":1025,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-03-23 12:12:45","updated_at":"2024-01-26 11:30:11","pinyin_shortcut":"DSSFPFC16GSW","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1025,"key":1025,"name":"\u601d\u79d1DS-SFP-FC16G-SW\u5149\u7ea4\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":null},{"id":5346,"project_id":3446,"product_id":229,"amount":"950","number":12,"cost":"950","description":"\u5e93\u5b58","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-04-10","hardware_to":null,"software_to":null,"maintenance_to":"2025-04-10","total_amount":"11400","total_cost":"11400","erp_sales_order_product_id":null,"supplier":null,"product":{"id":229,"name":"SFP-10G-SR=","product_type":4,"product_component":43,"product_brand":3,"product_serie":1058,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-07-01 12:25:14","updated_at":"2024-01-30 16:00:59","pinyin_shortcut":"SFP10GSR","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1058,"key":1058,"name":"\u601d\u79d1SFP-10G-SR\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":null},{"id":5347,"project_id":3446,"product_id":941,"amount":"70000","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-04-10","hardware_to":null,"software_to":null,"maintenance_to":"2025-04-10","total_amount":"70000","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null}],"projectContactPoints":[{"id":562,"project_id":3446,"contact_id":443,"point":"110000.00","paid_point":"110000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":103,"project_id":3446,"contact_id":443,"point":"110000.00","day_at":"2024-07-02","description":"","created_at":"2024-07-02 16:36:59"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":11610,"project_id":3446},{"id":11596,"project_id":3446},{"id":11613,"project_id":3446},{"id":11615,"project_id":3446},{"id":11618,"project_id":3446},{"id":11611,"project_id":3446},{"id":11612,"project_id":3446},{"id":11616,"project_id":3446},{"id":11614,"project_id":3446},{"id":11597,"project_id":3446},{"id":11617,"project_id":3446},{"id":11601,"project_id":3446},{"id":11608,"project_id":3446},{"id":11604,"project_id":3446},{"id":11598,"project_id":3446},{"id":11602,"project_id":3446},{"id":11606,"project_id":3446},{"id":11599,"project_id":3446},{"id":11607,"project_id":3446},{"id":11603,"project_id":3446},{"id":11605,"project_id":3446},{"id":11600,"project_id":3446},{"id":11609,"project_id":3446}],"reimbursementAmountSum":{"project_id":3446,"sum":"10614.89"},"profit":135663.66,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":1468,"contract_id":3188,"supplier_id":608,"purchase_id":3288,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":3288,"key":3288,"serial_no":"\u8ba2\u5355\u53f7: 3886093334225161702"}},{"id":1469,"contract_id":3188,"supplier_id":313,"purchase_id":3217,"supplier":{"id":313,"key":313,"name":"\u5317\u4eac\u6c49\u91d1\u82f1\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":3217,"key":3217,"serial_no":"HJY20240409"}},{"id":1470,"contract_id":3188,"supplier_id":262,"purchase_id":3262,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3262,"key":3262,"serial_no":" 293099050913"}},{"id":1471,"contract_id":3188,"supplier_id":503,"purchase_id":3216,"supplier":{"id":503,"key":503,"name":"\u5e7f\u4e1c\u82f1\u901a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3216,"key":3216,"serial_no":"XS\/20240403\/JXM01"}},{"id":1472,"contract_id":3188,"supplier_id":262,"purchase_id":3351,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3351,"key":3351,"serial_no":"294035220947"}},{"id":1473,"contract_id":3188,"supplier_id":262,"purchase_id":3352,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3352,"key":3352,"serial_no":"297018766565"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":5609,"user_id":5295,"key":5295,"contract_id":3188,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1595,"key":1595,"contract_id":3188,"name":"2024-05-31","value":"455400","overdue_days":14,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"120","key":"120","contract_id":3188,"value":"227700","created_by":1013,"created_at":"2024-06-14 11:18:48","description":null,"collected_date":"2024-06-14 11:18:48","amount":"227700","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50},{"id":"11744","key":"11744","contract_id":3188,"value":"227700","created_by":1013,"created_at":"2024-04-22 15:09:59","description":null,"collected_date":"2024-04-22 15:09:59","amount":"227700","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50}],"salesContractInvoices":[{"id":1618,"key":1618,"contract_id":3188,"value":"227700.00","attachment_id":null,"from_date":"2024-03-21","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":24700,"object_type":102,"object_id":1618,"attachment_id":18247,"attachment":{"id":18247,"key":18247,"name":"ca5ee4cf-f3ce-3a82-9df8-e8ebe4a3fc1d","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ca5ee4cf-f3ce-3a82-9df8-e8ebe4a3fc1d\/2024_03_21_14_45_23.pdf","orig_name":"2024_03_21_14_45_23.pdf"}}]},{"id":1672,"key":1672,"contract_id":3188,"value":"227700.00","attachment_id":null,"from_date":"2024-06-03","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":26228,"object_type":102,"object_id":1672,"attachment_id":19542,"attachment":{"id":19542,"key":19542,"name":"a73cf4b0-1870-3a23-92d4-8fcd6e702f50","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/a73cf4b0-1870-3a23-92d4-8fcd6e702f50\/dzfp_24112000000052907894_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20240603141530.pdf","orig_name":"dzfp_24112000000052907894_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20240603141530.pdf"}}]}],"contractScans":[{"id":26788,"object_type":105,"object_id":3188,"attachment_id":18240,"attachment":{"id":18240,"key":18240,"name":"a639526b-da7b-3686-b748-5de2e52bfff0","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/a639526b-da7b-3686-b748-5de2e52bfff0\/2024_03_20_14_10_23.pdf","orig_name":"2024_03_20_14_10_23.pdf"}}],"receiptScans":[{"id":25574,"object_type":106,"object_id":3188,"attachment_id":19001,"attachment":{"id":19001,"key":19001,"name":"1db31c32-f50b-328a-b7c9-36a55c6107f1","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/1db31c32-f50b-328a-b7c9-36a55c6107f1\/\u8d27\u7269\u7b7e\u6536\u5355.pdf","orig_name":"\u8d27\u7269\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":455400,"projectProductTotalAmount":455400,"projectProductAllAmount":true,"projectProductTotalCost":143200,"projectProductAllCost":true,"projectProductTotalCount":23,"invoiced":455400,"un_invoiced":0,"collected":"455400","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":3200,"client_id":90,"signed_at":"2024-03-11","amount":"5300","handler":5295,"description":"","created_by":5015,"created_at":"2024-03-25 21:43:02","updated_at":"2024-04-03 15:58:33","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3481,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2024031145","payment_collection_remind_ahead":"","from_project":3481,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"5300","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"passed":1,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":3200,"comment":5},"project":{"id":3481,"key":3481,"name":"\u65b0\u8d2d\u601d\u79d1\u4ea4\u6362\u673a\u6269\u5c55\u5361","erpSalesOrder":null},"fromProject":{"id":3481,"key":3481,"name":"\u65b0\u8d2d\u601d\u79d1\u4ea4\u6362\u673a\u6269\u5c55\u5361","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":310,"bargain_date":"2024-03-11","collected":"5300","profit_pct":"35.75","budget":"5300","erpSalesOrder":null,"projectProductTypes":[{"id":3853,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"5300","pct":"35.75","project_id":3481,"profit":"1894.75"}],"projectProductRels":[{"id":4093,"project_id":3481,"product_id":1531,"amount":"5300","number":1,"cost":"3000","description":"\u6dd8\u5b9d\u8d2d\u4e70\uff0c\u672a\u7a0e","supplier_id":262,"hardware_from":"2024-03-26","software_from":null,"maintenance_from":null,"hardware_to":"2025-03-25","software_to":null,"maintenance_to":null,"total_amount":"5300","total_cost":"3000","erp_sales_order_product_id":null,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"product":{"id":1531,"name":"NIM-2GE-CU-SFP=","product_type":4,"product_component":43,"product_brand":3,"product_serie":1321,"product_misc":null,"product_qa":null,"pn":"","description":"2-port GE WAN NIM, dual-mode RJ45 &SFP\n\u601d\u79d1ISR4331\u6269\u5c55\u677f\u5361","created_by":1013,"created_at":"2024-03-26 16:27:50","updated_at":"2024-03-28 14:59:34","pinyin_shortcut":"NIM2GECUSFP","product_unit":4,"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":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1321,"key":1321,"name":"NIM-2GE-CU-SFP\u6269\u5c55\u677f\u5361"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":null}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":8995,"project_id":3481}],"reimbursementAmountSum":null,"profit":1894.75,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1081,"contract_id":3200,"supplier_id":262,"purchase_id":3213,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3213,"key":3213,"serial_no":"3827458874642161702"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4955,"user_id":5295,"key":5295,"contract_id":3200,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1584,"key":1584,"contract_id":3200,"name":"2024-05-10","value":"5300","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1839","key":"1839","contract_id":3200,"value":"5300","created_by":1013,"created_at":"2024-04-30 14:58:30","description":null,"collected_date":"2024-04-30 14:58:30","amount":"5300","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1626,"key":1626,"contract_id":3200,"value":"5300.00","attachment_id":null,"from_date":"2024-03-28","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":24841,"object_type":102,"object_id":1626,"attachment_id":18392,"attachment":{"id":18392,"key":18392,"name":"9016cca6-cfc6-327b-a479-16a959bfc8c9","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/9016cca6-cfc6-327b-a479-16a959bfc8c9\/dzfp_24112000000015796523_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8_20240328171725.pdf","orig_name":"dzfp_24112000000015796523_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8_20240328171725.pdf"}}]}],"contractScans":[{"id":24935,"object_type":105,"object_id":3200,"attachment_id":18329,"attachment":{"id":18329,"key":18329,"name":"38682b96-476b-3b59-b534-b6a2c45542e4","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/38682b96-476b-3b59-b534-b6a2c45542e4\/2024_03_26_13_51_39.pdf","orig_name":"2024_03_26_13_51_39.pdf"}}],"receiptScans":[{"id":24883,"object_type":106,"object_id":3200,"attachment_id":18432,"attachment":{"id":18432,"key":18432,"name":"d2ab809b-e237-3cca-9625-65e9d5f9e4ae","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/d2ab809b-e237-3cca-9625-65e9d5f9e4ae\/2024_04_01_09_34_37.pdf","orig_name":"2024_04_01_09_34_37.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":5300,"projectProductTotalAmount":5300,"projectProductAllAmount":true,"projectProductTotalCost":3000,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":5300,"un_invoiced":0,"collected":"5300","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":3061,"client_id":90,"signed_at":"2024-01-04","amount":"1800","handler":5295,"description":"","created_by":5295,"created_at":"2024-01-04 14:58:43","updated_at":"2024-02-19 15:52:10","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3415,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2024010403","payment_collection_remind_ahead":"","from_project":3415,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"1800","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"passed":1,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3061,"comment":3},"project":{"id":3415,"key":3415,"name":"\u65b0\u8d2d\u9632\u706b\u5899\u6a21\u5757","erpSalesOrder":null},"fromProject":{"id":3415,"key":3415,"name":"\u65b0\u8d2d\u9632\u706b\u5899\u6a21\u5757","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":244,"bargain_date":"2024-01-04","collected":"1800","profit_pct":"-508.25","budget":"1800","erpSalesOrder":null,"projectProductTypes":[{"id":4921,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"1800.00","pct":"-508.25","project_id":3415,"profit":"-9148.5"}],"projectProductRels":[{"id":3402,"project_id":3415,"product_id":505,"amount":"900","number":2,"cost":"144.3","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1800","total_cost":"288.6","erp_sales_order_product_id":null,"supplier":null,"product":{"id":505,"name":"MC3208411-T","product_type":4,"product_component":43,"product_brand":47,"product_serie":831,"product_misc":5,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2018-12-06 11:27:37","updated_at":"2024-01-15 14:52:49","pinyin_shortcut":"MC3208411T","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":47,"key":47,"name":"\u8fc8\u7edc\u601d"},"productSerie":{"id":831,"key":831,"name":"\u5343\u5146\u7535\u53e3\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":null}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":5360,"project_id":3415},{"id":5361,"project_id":3415}],"reimbursementAmountSum":null,"profit":-9148.5,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1216,"contract_id":3061,"supplier_id":262,"purchase_id":3090,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3090,"key":3090,"serial_no":"3720041499068161702"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4835,"user_id":5295,"key":5295,"contract_id":3061,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1501,"key":1501,"contract_id":3061,"name":"2024-01-31","value":"1800","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1543","key":"1543","contract_id":3061,"value":"1800","created_by":1014,"created_at":"2024-01-18 17:31:00","description":null,"collected_date":"2024-01-18 17:31:00","amount":"1800","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1579,"key":1579,"contract_id":3061,"value":"1800.00","attachment_id":null,"from_date":"2024-01-08","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":22941,"object_type":102,"object_id":1579,"attachment_id":17069,"attachment":{"id":17069,"key":17069,"name":"3ff1df16-c343-3d84-aae8-1608308fcf3e","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/3ff1df16-c343-3d84-aae8-1608308fcf3e\/dzfp_24112000000000665584_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20240108173249.pdf","orig_name":"dzfp_24112000000000665584_\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8_20240108173249.pdf"}}]}],"contractScans":[{"id":23955,"object_type":105,"object_id":3061,"attachment_id":17070,"attachment":{"id":17070,"key":17070,"name":"0b69b17c-dcd1-3d8c-84fb-bd3f5fa79944","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/0b69b17c-dcd1-3d8c-84fb-bd3f5fa79944\/2024_01_08_17_35_25.pdf","orig_name":"2024_01_08_17_35_25.pdf"}}],"receiptScans":[{"id":23132,"object_type":106,"object_id":3061,"attachment_id":17157,"attachment":{"id":17157,"key":17157,"name":"7daac9fa-78af-3988-8c04-e857d219e159","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/7daac9fa-78af-3988-8c04-e857d219e159\/2024_01_15_10_44_25.pdf","orig_name":"2024_01_15_10_44_25.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":1800,"projectProductTotalAmount":1800,"projectProductAllAmount":true,"projectProductTotalCost":288.6,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":1800,"un_invoiced":0,"collected":"1800","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":3027,"client_id":90,"signed_at":"2023-12-20","amount":"229840","handler":5295,"description":"","created_by":5295,"created_at":"2023-12-20 14:58:21","updated_at":"2024-01-30 15:50:14","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3296,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2023121145","payment_collection_remind_ahead":"","from_project":3296,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"229840","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"passed":1,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3027,"comment":3},"project":{"id":3296,"key":3296,"name":"veeam\u5907\u4efd\u7eed\u4fdd+PA\u9632\u706b\u5899\u6280\u672f\u670d\u52a1+\u786c\u4ef6\u8bbe\u5907\u7ef4\u4fdd","erpSalesOrder":null},"fromProject":{"id":3296,"key":3296,"name":"veeam\u5907\u4efd\u7eed\u4fdd+PA\u9632\u706b\u5899\u6280\u672f\u670d\u52a1+\u786c\u4ef6\u8bbe\u5907\u7ef4\u4fdd","description":"","total_contact_point":"50000","paid_contact_point":"50000","is_sales_order_ready":false,"project_product_version_id":180,"bargain_date":"2023-12-20","collected":"229840","profit_pct":"48.15","budget":"229840","erpSalesOrder":null,"projectProductTypes":[{"id":2720,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"229840.00","pct":"48.15","project_id":3296,"profit":"110667.96"}],"projectProductRels":[{"id":2978,"project_id":3296,"product_id":237,"amount":"35360","number":3,"cost":"8267","description":"V-FDNVUL-0I-SU1AR-00 ","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"106080","total_cost":"24801","erp_sales_order_product_id":null,"supplier":null,"product":{"id":237,"name":"Veeam\u865a\u62df\u5316\u5907\u4efd\u7eed\u4fdd\u670d\u52a1","product_type":7,"product_component":30,"product_brand":16,"product_serie":61,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-07-13 17:27:26","updated_at":"2023-08-14 15:55:11","pinyin_shortcut":"Veeamxnhbfxbfw","product_unit":8,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":61,"key":61,"name":"Veeam \u865a\u62df\u5316\u5907\u4efd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":null},{"id":2979,"project_id":3296,"product_id":9,"amount":"35360","number":1,"cost":"10300","description":"V-FDNVUL-0I- SU1YP-00","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"35360","total_cost":"10300","erp_sales_order_product_id":null,"supplier":null,"product":{"id":9,"name":"V-FDNVUL-0I- SU1YP-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1051,"product_misc":5,"product_qa":2,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 10 instance pack. 1 Year Subscription Upfront Billing & Production (24\/7) Support. ","created_by":1013,"created_at":"2017-02-09 17:00:55","updated_at":"2024-01-26 17:18:42","pinyin_shortcut":"VFDNVUL0ISU1YP00","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":16,"key":16,"name":"Veeam"},"productSerie":{"id":1051,"key":1051,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":null},{"id":2980,"project_id":3296,"product_id":941,"amount":"88400","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":"88400","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null}],"projectContactPoints":[{"id":335,"project_id":3296,"contact_id":443,"point":"50000.00","paid_point":"50000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":39,"project_id":3296,"contact_id":443,"point":"50000.00","day_at":"2024-01-11","description":"\u7fc1\u5bb6\u6210\u9001\u73b0\u91d1","created_at":"2024-01-11 15:34:35"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3296,"sum":"3468.08"},"profit":110667.96,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":65,"contract_id":3027,"supplier_id":165,"purchase_id":3093,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3093,"key":3093,"serial_no":""}},{"id":2057,"contract_id":3027,"supplier_id":659,"purchase_id":3037,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":3037,"key":3037,"serial_no":"XM20231221000645"}},{"id":2056,"contract_id":3027,"supplier_id":659,"purchase_id":3036,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":3036,"key":3036,"serial_no":"XM20231221000544"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4735,"user_id":5295,"key":5295,"contract_id":3027,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1473,"key":1473,"contract_id":3027,"name":"2024-02-29","value":"229840","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"11551","key":"11551","contract_id":3027,"value":"229840","created_by":1014,"created_at":"2024-01-05 15:54:06","description":null,"collected_date":"2024-01-05 15:54:06","amount":"229840","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1565,"key":1565,"contract_id":3027,"value":"229840.00","attachment_id":null,"from_date":"2023-12-20","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":22589,"object_type":102,"object_id":1565,"attachment_id":16779,"attachment":{"id":16779,"key":16779,"name":"700ebd64-384c-385f-a776-e1ca0aaf57f3","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/700ebd64-384c-385f-a776-e1ca0aaf57f3\/2023_12_20_18_03_09.pdf","orig_name":"2023_12_20_18_03_09.pdf"}}]}],"contractScans":[{"id":23603,"object_type":105,"object_id":3027,"attachment_id":16770,"attachment":{"id":16770,"key":16770,"name":"e1af474e-5629-381f-9728-6719fd02e3b2","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/e1af474e-5629-381f-9728-6719fd02e3b2\/2023_12_20_10_56_25.pdf","orig_name":"2023_12_20_10_56_25.pdf"}}],"receiptScans":[{"id":23156,"object_type":106,"object_id":3027,"attachment_id":17181,"attachment":{"id":17181,"key":17181,"name":"59a01f5e-5813-3fdf-aefb-cf617f2ce432","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/59a01f5e-5813-3fdf-aefb-cf617f2ce432\/\u7b7e\u6536\u5355.pdf","orig_name":"\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":229840,"projectProductTotalAmount":229840,"projectProductAllAmount":true,"projectProductTotalCost":35101,"projectProductAllCost":true,"projectProductTotalCount":5,"invoiced":229840,"un_invoiced":0,"collected":"229840","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":2753,"client_id":90,"signed_at":"2023-07-11","amount":"249830","handler":5295,"description":"Prisma\u7528\u6237\u65b0\u8d2d","created_by":5295,"created_at":"2023-07-18 10:42:59","updated_at":"2024-01-26 15:13:41","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3236,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2023071145","payment_collection_remind_ahead":"","from_project":3236,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"249830","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"passed":1,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2753,"comment":3},"project":{"id":3236,"key":3236,"name":"PA\u4ea7\u54c1\u65b0\u8d2d-C","erpSalesOrder":null},"fromProject":{"id":3236,"key":3236,"name":"PA\u4ea7\u54c1\u65b0\u8d2d-C","description":"Prisma\u7528\u6237\u65b0\u8d2d","total_contact_point":"40000","paid_contact_point":"40000","is_sales_order_ready":true,"project_product_version_id":236,"bargain_date":"2023-07-11","collected":"249830","profit_pct":"-2.91","budget":"249830","erpSalesOrder":null,"projectProductTypes":[{"id":4915,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"249830","pct":"-2.91","project_id":3236,"profit":"-7270.053"}],"projectProductRels":[{"id":3326,"project_id":3236,"product_id":1034,"amount":"249830","number":1,"cost":"192000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"249830","total_cost":"192000","erp_sales_order_product_id":null,"supplier":null,"product":{"id":1034,"name":"PA-\u4e13\u4e1a\u8ba2\u5236\u56fd\u5185\u6388\u6743\u548c\u670d\u52a1","product_type":5,"product_component":35,"product_brand":8,"product_serie":630,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-09-08 17:27:31","updated_at":"2023-09-08 17:27:31","pinyin_shortcut":"PAzydzgnsqhfw","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":630,"key":630,"name":"PA-China-Prisma"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":null}],"projectContactPoints":[{"id":366,"project_id":3236,"contact_id":443,"point":"40000.00","paid_point":"40000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":38,"project_id":3236,"contact_id":443,"point":"40000.00","day_at":"2023-08-09","description":"","created_at":"2024-01-11 15:32:48"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3236,"sum":"88.90"},"profit":-7270.053,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":2105,"contract_id":2753,"supplier_id":68,"purchase_id":2731,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2731,"key":2731,"serial_no":"BJ7067-PA-MJ-20230627"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4806,"user_id":5295,"key":5295,"contract_id":2753,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1285,"key":1285,"contract_id":2753,"name":"2023-09-18","value":"249830","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"11469","key":"11469","contract_id":2753,"value":"249830","created_by":1014,"created_at":"2023-07-28 15:10:57","description":null,"collected_date":"2023-07-28 15:10:57","amount":"249830","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1437,"key":1437,"contract_id":2753,"value":"249830.00","attachment_id":null,"from_date":"2023-07-19","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":19417,"object_type":102,"object_id":1437,"attachment_id":13994,"attachment":{"id":13994,"key":13994,"name":"713680c6-88a5-35b2-80c9-26ca94a46580","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/713680c6-88a5-35b2-80c9-26ca94a46580\/2023_07_19_09_55_24.pdf","orig_name":"2023_07_19_09_55_24.pdf"}}]}],"contractScans":[{"id":23756,"object_type":105,"object_id":2753,"attachment_id":13993,"attachment":{"id":13993,"key":13993,"name":"d720ea91-ac06-32d7-8bd6-95e4e3bc541f","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/d720ea91-ac06-32d7-8bd6-95e4e3bc541f\/2023_07_19_10_22_27.pdf","orig_name":"2023_07_19_10_22_27.pdf"}}],"receiptScans":[{"id":19932,"object_type":106,"object_id":2753,"attachment_id":14433,"attachment":{"id":14433,"key":14433,"name":"13f18fb1-f0c5-35b7-bce1-b70a322816a3","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/13f18fb1-f0c5-35b7-bce1-b70a322816a3\/20230815141500289.pdf","orig_name":"20230815141500289.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":249830,"projectProductTotalAmount":249830,"projectProductAllAmount":true,"projectProductTotalCost":192000,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":249830,"un_invoiced":0,"collected":"249830","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":2563,"client_id":90,"signed_at":"2023-02-14","amount":"26808","handler":5295,"description":"\u601d\u79d1\u7f51\u7edc\u4ea7\u54c1\u7eed\u4fdd","created_by":5015,"created_at":"2023-02-14 17:16:12","updated_at":"2024-01-11 15:31:58","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3114,"valid_date":null,"expire_date":"2023-06-30","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"TS-WZW-20211001\u8865\u5145\u534f\u8bae-3","payment_collection_remind_ahead":"","from_project":3114,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"26808","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":770,"passed":2,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":2563,"comment":4},"project":{"id":3114,"key":3114,"name":"\u7f51\u7edc\u4ea7\u54c1\u7eed\u4fdd2023-2","erpSalesOrder":null},"fromProject":{"id":3114,"key":3114,"name":"\u7f51\u7edc\u4ea7\u54c1\u7eed\u4fdd2023-2","description":"\u601d\u79d1\u7f51\u7edc\u4ea7\u54c1\u7eed\u4fdd","total_contact_point":"24000","paid_contact_point":"24000","is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2023-02-14","collected":"26808","profit_pct":"41.52","budget":"26808","erpSalesOrder":null,"projectProductTypes":[{"id":2200,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"26808","pct":"41.52","project_id":3114,"profit":"11130.6816"}],"projectProductRels":[{"id":2121,"project_id":3114,"product_id":941,"amount":"26808","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":"26808","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null}],"projectContactPoints":[{"id":176,"project_id":3114,"contact_id":443,"point":"24000.00","paid_point":"24000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":37,"project_id":3114,"contact_id":443,"point":"24000.00","day_at":"2023-04-19","description":"","created_at":"2024-01-11 15:31:58"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":11130.6816,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4461,"user_id":5295,"key":5295,"contract_id":2563,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1161,"key":1161,"contract_id":2563,"name":"2023-04-14","value":"26808","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"11143","key":"11143","contract_id":2563,"value":"26808","created_by":1014,"created_at":"2023-04-13 17:41:36","description":null,"collected_date":"2023-04-13 17:41:36","amount":"26808","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1347,"key":1347,"contract_id":2563,"value":"26808.00","attachment_id":null,"from_date":"2023-02-15","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":17302,"object_type":102,"object_id":1347,"attachment_id":12085,"attachment":{"id":12085,"key":12085,"name":"b8e3025c-6ce0-333a-b567-823e871f9e12","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/b8e3025c-6ce0-333a-b567-823e871f9e12\/2023_02_15_10_51_24.pdf","orig_name":"2023_02_15_10_51_24.pdf"}}]}],"contractScans":[{"id":23010,"object_type":105,"object_id":2563,"attachment_id":12084,"attachment":{"id":12084,"key":12084,"name":"623661c7-d956-3a42-b16e-432e8d01081a","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/623661c7-d956-3a42-b16e-432e8d01081a\/2022_09_13_15_37_22.pdf","orig_name":"2022_09_13_15_37_22.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":26808,"projectProductTotalAmount":26808,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":26808,"un_invoiced":0,"collected":"26808","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":2593,"client_id":90,"signed_at":"2023-02-07","amount":"4000","handler":5295,"description":"\u79df\u7528\u601d\u79d1\u4ea4\u6362\u673a","created_by":5295,"created_at":"2023-03-16 10:54:26","updated_at":"2023-12-07 18:24:05","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3099,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2023020715","payment_collection_remind_ahead":"","from_project":3099,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"4000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"passed":1,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2593,"comment":3},"project":{"id":3099,"key":3099,"name":"\u79df\u7528\u4ea4\u6362\u673a","erpSalesOrder":null},"fromProject":{"id":3099,"key":3099,"name":"\u79df\u7528\u4ea4\u6362\u673a","description":"\u79df\u7528\u601d\u79d1\u4ea4\u6362\u673a","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2023-02-07","collected":"4000","profit_pct":"93","budget":"4000","erpSalesOrder":null,"projectProductTypes":[{"id":2193,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"4000.00","pct":"93","project_id":3099,"profit":"3720"}],"projectProductRels":[{"id":20,"project_id":3099,"product_id":941,"amount":"2000","number":2,"cost":"0","description":null,"supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"4000","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3099,"sum":"97"},"profit":3720,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":3682,"user_id":5295,"key":5295,"contract_id":2593,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1182,"key":1182,"contract_id":2593,"name":"2023-04-30","value":"4000","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1478","key":"1478","contract_id":2593,"value":"4000","created_by":1014,"created_at":"2023-03-31 09:45:21","description":null,"collected_date":"2023-03-31 09:45:21","amount":"4000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1362,"key":1362,"contract_id":2593,"value":"4000.00","attachment_id":null,"from_date":"2023-03-16","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":17750,"object_type":102,"object_id":1362,"attachment_id":12435,"attachment":{"id":12435,"key":12435,"name":"6c9f2cfa-b66e-31f9-a11c-3cf2d464c890","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/6c9f2cfa-b66e-31f9-a11c-3cf2d464c890\/2023_03_16_11_24_28.pdf","orig_name":"2023_03_16_11_24_28.pdf"}}]}],"contractScans":[{"id":17887,"object_type":105,"object_id":2593,"attachment_id":12436,"attachment":{"id":12436,"key":12436,"name":"16b642d7-301f-3440-af28-a1ce7ab15530","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/16b642d7-301f-3440-af28-a1ce7ab15530\/2023_03_16_11_27_46.pdf","orig_name":"2023_03_16_11_27_46.pdf"}}],"receiptScans":[{"id":17754,"object_type":106,"object_id":2593,"attachment_id":12438,"attachment":{"id":12438,"key":12438,"name":"5e2a409c-b12b-3648-b1eb-c38824e96854","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/5e2a409c-b12b-3648-b1eb-c38824e96854\/\u82cf\u9ece\u4e16.pdf","orig_name":"\u82cf\u9ece\u4e16.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":4000,"projectProductTotalAmount":4000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":4000,"un_invoiced":0,"collected":"4000","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":2544,"client_id":90,"signed_at":"2023-01-10","amount":"26808","handler":5295,"description":"\u601d\u79d1\u7f51\u7edc\u4ea7\u54c1\u7eed\u4fdd","created_by":5295,"created_at":"2023-01-10 09:45:53","updated_at":"2023-12-07 18:22:44","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3080,"valid_date":null,"expire_date":"2023-03-31","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"TS-WZW-20211001\u8865\u5145\u534f\u8bae-2","payment_collection_remind_ahead":"","from_project":3080,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"26808","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":861,"passed":2,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2544,"comment":4},"project":{"id":3080,"key":3080,"name":"\u7f51\u7edc\u7eed\u4fdd2023-1","erpSalesOrder":null},"fromProject":{"id":3080,"key":3080,"name":"\u7f51\u7edc\u7eed\u4fdd2023-1","description":"\u601d\u79d1\u7f51\u7edc\u4ea7\u54c1\u7eed\u4fdd","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2023-01-10","collected":"26808","profit_pct":"41.52","budget":"26808","erpSalesOrder":null,"projectProductTypes":[{"id":2187,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"26808.00","pct":"41.52","project_id":3080,"profit":"11130.6816"}],"projectProductRels":[{"id":15,"project_id":3080,"product_id":941,"amount":"26808","number":1,"cost":"0","description":null,"supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"26808","total_cost":"0","erp_sales_order_product_id":null,"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"}},"erpSalesOrderProduct":null}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":11130.6816,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":3591,"user_id":5295,"key":5295,"contract_id":2544,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1140,"key":1140,"contract_id":2544,"name":"2023-03-31","value":"26808","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1499","key":"1499","contract_id":2544,"value":"26808","created_by":1014,"created_at":"2023-02-02 16:53:37","description":null,"collected_date":"2023-02-02 16:53:37","amount":"26808","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1334,"key":1334,"contract_id":2544,"value":"26808.00","attachment_id":null,"from_date":"2023-01-10","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":17113,"object_type":102,"object_id":1334,"attachment_id":11909,"attachment":{"id":11909,"key":11909,"name":"262098f4-5639-3b13-9394-629c68840305","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/262098f4-5639-3b13-9394-629c68840305\/2023_01_10_11_30_43.pdf","orig_name":"2023_01_10_11_30_43.pdf"}}]}],"contractScans":[{"id":17194,"object_type":105,"object_id":2544,"attachment_id":11905,"attachment":{"id":11905,"key":11905,"name":"01a17260-cfdb-3a77-a34e-3df894ceff31","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/01a17260-cfdb-3a77-a34e-3df894ceff31\/2022_09_13_15_37_22.pdf","orig_name":"2022_09_13_15_37_22.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":26808,"projectProductTotalAmount":26808,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":26808,"un_invoiced":0,"collected":"26808","un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false}],"pagenation":{"totalcount":34,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-08 10:18:31') RETURNING "id" |