6871f8e2b68d4: POST https://beta.jinchangxiao.com/v2/project/list at 2025-07-12 01:55:46 pm by 120.235.117.171
Database Queries
总计84条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 13:55:46.751 | 2.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='LpLquexa4MxJRClJNdb9gPVa_MzadLnu' |
| 13:55:46.754 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:55:46.759 | 10.4 ms | SELECT | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."sales_rep"='1001') GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC) "c" |
| 13:55:46.770 | 11.5 ms | SELECT | SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."sales_rep"='1001') GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC LIMIT 10 OFFSET 10 |
| 13:55:46.782 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2219, 2545, 2836, 2553, 3009, 3327, 1661, 3304) |
| 13:55:46.783 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:55:46.783 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 13:55:46.784 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (5, 6) |
| 13:55:46.784 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=43 |
| 13:55:46.785 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (13, 18, 10) |
| 13:55:46.785 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1 |
| 13:55:46.785 | 0.6 ms | SELECT | SELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_project_architects" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON engineer_id = u.id WHERE "a57be577deb434"."tbl_project_architects"."project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) ORDER BY "contribution" DESC, "engineer_id" |
| 13:55:46.786 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3 |
| 13:55:46.787 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (2, 9, 6, 49) |
| 13:55:46.787 | 0.7 ms | SELECT | SELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) |
| 13:55:46.788 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) |
| 13:55:46.789 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (212, 165, 232, 184, 189, 2, 1, 5, 167, 166, 226, 172, 197, 199, 205, 192, 204, 185, 191, 175, 181, 142, 349, 350, 359, 369, 377)) ORDER BY "sort" |
| 13:55:46.789 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) |
| 13:55:46.790 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (212, 165, 232, 184, 189, 2, 1, 5, 167, 166, 226, 172, 197, 199, 205, 192, 204, 185, 191, 175, 181, 142, 349, 350, 359, 369, 377)) ORDER BY "sort" |
| 13:55:46.790 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) |
| 13:55:46.791 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (212, 165, 232, 184, 189, 2, 1, 5, 167, 166, 226, 172, 197, 199, 205, 192, 204, 185, 191, 175, 181, 142, 349, 350, 359, 369, 377)) ORDER BY "sort" |
| 13:55:46.791 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:55:46.791 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 13:55:46.792 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4 |
| 13:55:46.792 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:55:46.792 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 13:55:46.793 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2219, 2545, 2836, 2553, 3009, 3327, 1661, 3304) |
| 13:55:46.794 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:55:46.794 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 13:55:46.794 | 1.6 ms | SELECT | SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", sum(points) as points FROM "a57be577deb434"."tbl_case_assignments" GROUP BY "case_id") "ca" ON ca.case_id = c.id WHERE "c"."project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) GROUP BY "c"."project_id" |
| 13:55:46.796 | 0.3 ms | SELECT | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744)) GROUP BY "project_id" |
| 13:55:46.796 | 0.9 ms | SELECT | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) GROUP BY "project_id" |
| 13:55:46.798 | 0.4 ms | SELECT | SELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744)) GROUP BY "project_id" |
| 13:55:46.798 | 1.4 ms | SELECT | SELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744)) GROUP BY "c"."project_id" |
| 13:55:46.800 | 1.2 ms | SELECT | SELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744)) GROUP BY "c"."project_id" |
| 13:55:46.801 | 0.4 ms | SELECT | SELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744)) GROUP BY "project_id" |
| 13:55:46.802 | 1.4 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744)) GROUP BY "project_id" |
| 13:55:46.803 | 0.7 ms | SELECT | SELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) |
| 13:55:46.804 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3363, 3703, 3724, 3763, 1558, 3415, 3348, 3502, 3235, 3838)) |
| 13:55:46.806 | 7.0 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5271, 20000, 18741, 20449, 19680, 21308, 23131, 23789, 23436) |
| 13:55:46.813 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3363, 3703, 3724, 3763, 1558, 3415, 3348, 3502, 3235, 3838)) |
| 13:55:46.814 | 4.8 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5320, 21870, 19035, 20030, 20473, 20922, 23594, 24180, 24375) |
| 13:55:46.819 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3363, 3703, 3724, 3763, 1558, 3415, 3348, 3502, 3235, 3838)) |
| 13:55:46.821 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "collected_date" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (3363, 3703, 3724, 3763, 1558, 3415, 3348, 3502, 3235, 3838) ORDER BY "id" |
| 13:55:46.821 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013 |
| 13:55:46.822 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3363, 3703, 3724, 3763, 1558, 3415, 3348, 3502, 3235, 3838) ORDER BY "id" |
| 13:55:46.822 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=5400 |
| 13:55:46.823 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3363, 3703, 3724, 3763, 1558, 3415, 3348, 3502, 3235, 3838) ORDER BY "remind_date" |
| 13:55:46.823 | 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 (3363, 3703, 3724, 3763, 1558, 3415, 3348, 3502, 3235, 3838) |
| 13:55:46.824 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5388, 1001, 1011, 1005) |
| 13:55:46.824 | 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 (1001, 1011, 5295, 5388, 1005)) |
| 13:55:46.825 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3363, 3703, 3724, 3763, 1558, 3415, 3348, 3502, 3235, 3838) |
| 13:55:46.825 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (365, 90, 531, 163, 511, 678) |
| 13:55:46.826 | 4.6 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (1559, 3503, 3574, 3704, 3769, 3727, 3241, 3359, 3422, 3372) |
| 13:55:46.831 | 0.3 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) |
| 13:55:46.831 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:55:46.832 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 13:55:46.832 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) |
| 13:55:46.833 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 531, 81, 163, 511) |
| 13:55:46.833 | 5.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (196, 1303, 1763, 1764, 1766, 1668, 1895, 1896, 1897, 849, 1471, 1340, 989, 1353, 1902, 1903, 1904, 498, 1558, 1559, 1560, 1561, 1562, 1563, 1655, 947) |
| 13:55:46.839 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 3, 4, 2) |
| 13:55:46.840 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (26, 36, 14, 43, 35, 157, 2) |
| 13:55:46.840 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (8, 12, 4) |
| 13:55:46.840 | 5.9 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1344, 1244, 1408, 1419, 975, 1579, 1580, 999, 618, 784, 1583, 165, 315, 801, 615, 806, 804, 1012) |
| 13:55:46.847 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (1, 2, 3, 6, 8) |
| 13:55:46.847 | 18.3 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744)) GROUP BY "object_id" |
| 13:55:46.866 | 15.7 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744)) GROUP BY "object_id" |
| 13:55:46.881 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=1262 |
| 13:55:46.882 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id"=1262 |
| 13:55:46.883 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=100 |
| 13:55:46.883 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) |
| 13:55:46.884 | 0.9 ms | SELECT | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (1262, 4640) |
| 13:55:46.885 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2545 |
| 13:55:46.885 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=100 |
| 13:55:46.885 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((1262, 3503), (4640, 3599), (1262, 3644), (1262, 3723), (4640, 3576), (1262, 3767), (1262, 3744)) |
| 13:55:46.886 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (2939, 3576, 3503, 3644, 3568, 3599, 3767, 1791, 3723, 3744) |
| 13:55:46.887 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3300, 982) |
| 13:55:46.887 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (93, 94, 102) |
| 13:55:46.888 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5250, 5016, 5064, 1001) |
| 13:55:46.888 | 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 (1001, 5250, 5016, 5064, 1000)) |
| 13:55:46.888 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_used_client_id", "remind_date", "amount", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id" IN (93, 94, 102) |
| 13:55:46.889 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (93, 94, 102) |
| 13:55:46.889 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (93, 94, 102) |
| 13:55:46.893 | 4.0 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 0, 263, 'v2/project/list', '{"access_token":"LpLquexa4MxJRClJNdb9gPVa_MzadLnu","ProjectSearch":{"created_by":"1001"},"device_type":"0","version_code":"263","page":"2","token":"723b3bf2d677c9f7478cd2b226971ed5","posttime":"1752299747","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":2939,"client_id":2219,"project_status":3,"project_progress":2,"budget":"322324.06","profit_pct":"37.95","bargain_date":"2022-11-01","description":"PA-3260\u9632\u706b\u5899\u4e00\u53f0","created_by":1001,"created_at":"2022-08-10 14:25:36","updated_at":"2025-06-09 13:48:08","engineer_id":null,"project_title":"PA-3260\u9632\u706b\u5899\u4e00\u5957","collected":"0","status_updated_at":"2025-06-09 13:47:15.128648+08","success_rate":null,"comment":"PA-3260\u9632\u706b\u5899\u4e00\u53f0\r\nPA-3260\u4e3b\u673a\u542bTP\u53ca1\u5e74\u786c\u4ef6\u4fdd\u4fee\u670d\u52a1","contract_type":1,"progress_updated_at":"2024-03-08 10:53:04.085113+08","forecast_updated_at":"2024-03-08 10:53:04.085113+08","end_at":"","pinyin_shortcut":"PA3260fhqyt","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":313,"is_sales_order_ready":false,"collected_plan":0,"profits":"122321.980770000000000000","remain":"33 days 00:08:31.642674","progress_remain":"491 days 03:02:42.686209","forecast_remain":"491 days 03:02:42.686209","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"1066 days 23:30:09.957849","issued_invoices":null,"client":{"id":2219,"key":2219,"name":"\u5317\u4eac\u534e\u9896\u5229\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"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"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"322324.06","pct":"37.95","profit":"122324.06","project_id":2939}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3838,"from_project":2939,"payment_collection_remind_ahead":"1 day","serial_no":null,"is_settle":false,"is_deliver":false,"is_outbound":false,"contractScans":[],"receiptScans":[],"verifyScans":[],"salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8104,"user_id":1005,"key":1005,"contract_id":3838,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},{"id":8105,"user_id":1001,"key":1001,"contract_id":3838,"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"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"1\u5929"},"projectRemindReceivers":[{"id":1463,"user_id":1001,"key":1001,"project_id":2939,"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"}}}],"projectProductRels":[{"id":9053,"project_id":2939,"product_id":947,"amount":"322324.06","number":1,"cost":"200000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"322324.06","total_cost":"200000","supplier":null,"product":{"id":947,"name":"PAN-SVC-BKLN-3260","product_type":5,"product_component":35,"product_brand":8,"product_serie":806,"product_misc":null,"product_qa":null,"pn":"","description":"Partner enabled premium support year 1, PA-3260","created_by":1013,"created_at":"2023-08-03 16:07:54","updated_at":"2024-01-12 15:47:22","pinyin_shortcut":"PANSVCBKLN3260","product_unit":8,"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":806,"key":806,"name":"PA-3260\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}}],"commentCount":{"object_id":2939,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":{"id":102,"project_id":2939,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":33,"progress_remain_display":491,"forecast_remain_display":491,"projectProductTotalAmount":322324.06,"projectProductAllAmount":true,"projectProductTotalCost":200000,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":322324.06,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":1066,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"32.23\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":3576,"client_id":2545,"project_status":3,"project_progress":9,"budget":"38000","profit_pct":"13.45","bargain_date":"2024-06-25","description":"","created_by":1001,"created_at":"2024-06-26 09:21:41","updated_at":"2025-04-19 19:25:54","engineer_id":null,"project_title":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee","collected":"38000","status_updated_at":"2024-06-26 09:21:41.482129+08","success_rate":null,"comment":"999","contract_type":1,"progress_updated_at":"2024-06-26 09:21:41.482129+08","forecast_updated_at":"2024-06-26 09:21:41.482129+08","end_at":"2025-04-19 19:25:54","pinyin_shortcut":"lxSR650esfwqcgxm","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":"7000","paid_contact_point":"7000","project_product_version_id":454,"is_sales_order_ready":true,"collected_plan":38000,"profits":"5111.000000000000000000","remain":"381 days 04:34:05.289193","progress_remain":"381 days 04:34:05.289193","forecast_remain":"381 days 04:34:05.289193","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"297 days 10:04:12.587217","issued_invoices":"38000.00","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":10,"sales_rep":1001,"salesRep":{"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"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"38000.00","pct":"13.45","profit":"5111","project_id":3576}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3576,"sum":"61.95"},"buildContract":{"id":3363,"from_project":3576,"payment_collection_remind_ahead":"1 day","serial_no":"TSC-LRC-2024062501","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":26790,"object_type":105,"object_id":3363,"attachment_id":20000,"attachment":{"id":20000,"key":20000,"name":"edc6afcd-06f5-3494-8375-21ba022cf5f4","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/edc6afcd-06f5-3494-8375-21ba022cf5f4\/2024_06_28_09_56_11.pdf","orig_name":"2024_06_28_09_56_11.pdf"}}],"receiptScans":[{"id":26783,"object_type":106,"object_id":3363,"attachment_id":20030,"attachment":{"id":20030,"key":20030,"name":"93c2e46a-6392-36b0-bbf2-37558a273ca3","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/93c2e46a-6392-36b0-bbf2-37558a273ca3\/\u7b7e\u6536\u5355.pdf","orig_name":"\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":1882,"key":1882,"contract_id":3363,"value":"38000","created_by":1013,"created_at":"2024-06-26 13:53:32","collected_date":"2024-06-26","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1699,"key":1699,"contract_id":3363,"value":"38000.00","attachment_id":null,"from_date":"2024-06-28","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2369,"key":2369,"contract_id":3363,"name":"2024-07-05","value":"38000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":5615,"user_id":5388,"key":5388,"contract_id":3363,"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":5616,"user_id":1001,"key":1001,"contract_id":3363,"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"}}}],"salesSupplierRels":[{"id":2324,"contract_id":3363,"supplier_id":678,"purchase_id":3372,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3372,"key":3372,"serial_no":"20240627"}}],"payment_collection_remind_ahead_display":"1\u5929"},"projectRemindReceivers":[{"id":1452,"user_id":1001,"key":1001,"project_id":3576,"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"}}}],"projectProductRels":[{"id":5350,"project_id":3576,"product_id":498,"amount":"38000","number":1,"cost":"22000","description":"\u4e8c\u624b\u670d\u52a1\u5668\uff1b8163*2\/8*32G","supplier_id":81,"hardware_from":"2024-06-27","software_from":null,"maintenance_from":null,"hardware_to":"2025-06-27","software_to":null,"maintenance_to":null,"total_amount":"38000","total_cost":"22000","supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"product":{"id":498,"name":"\u8054\u60f3 SR650\u670d\u52a1\u5668","product_type":2,"product_component":2,"product_brand":4,"product_serie":315,"product_misc":2,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2018-11-30 13:58:06","updated_at":"2023-08-14 10:20:52","pinyin_shortcut":"lxSR650fwq","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":315,"key":315,"name":"\u8054\u60f3 SR650 \u670d\u52a1\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}}],"commentCount":{"object_id":3576,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":563,"project_id":3576,"contact_id":4640,"point":"7000.00","paid_point":"7000","contact":{"id":4640,"key":4640,"name":"\u5218\u82f1\u6960","client_id":2545,"supplier_id":null,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":104,"project_id":3576,"contact_id":4640,"point":"7000.00","day_at":"2024-07-02","description":"","created_at":"2024-07-02 16:45:42"}],"status_display":"\u5df2\u6838\u9500"}],"projectUsedClient":null,"remain_display":381,"progress_remain_display":381,"forecast_remain_display":381,"projectProductTotalAmount":38000,"projectProductAllAmount":true,"projectProductTotalCost":22000,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":297,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"3.8\u4e07","contact_points_status_display":"\u5df2\u6838\u9500"},{"id":3503,"client_id":2836,"project_status":3,"project_progress":6,"budget":"375748","profit_pct":"-0.64","bargain_date":"2024-04-17","description":"","created_by":1001,"created_at":"2024-04-15 15:22:12","updated_at":"2025-04-19 19:09:05","engineer_id":null,"project_title":"PA1420\u9632\u706b\u58993\u5e74\u670d\u52a1\u9879\u76ee","collected":"375748","status_updated_at":"2024-04-18 09:01:06.210079+08","success_rate":null,"comment":"888","contract_type":1,"progress_updated_at":"2024-04-15 15:22:12.219309+08","forecast_updated_at":"2024-04-15 15:22:12.219309+08","end_at":"2025-04-19 19:09:05","pinyin_shortcut":"PA1420fhq3nfwxm","creator":1001,"used_client":null,"from_contact":1262,"total_contact_point":"76084","paid_contact_point":"76084","project_product_version_id":372,"is_sales_order_ready":true,"collected_plan":375748,"profits":"-2404.787200000000000000","remain":"450 days 04:54:40.561243","progress_remain":"452 days 22:33:34.552013","forecast_remain":"452 days 22:33:34.552013","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"369 days 03:46:53.514223","issued_invoices":"375748.00","client":{"id":2836,"key":2836,"name":"\u5317\u4eac\u4e2d\u8bda\u7f51\u5b89\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"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"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"375748.00","pct":"-0.64","profit":"-2404.7872","project_id":3503}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3235,"from_project":3503,"payment_collection_remind_ahead":null,"serial_no":"TS-HYF-2024041502","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":27335,"object_type":105,"object_id":3235,"attachment_id":18741,"attachment":{"id":18741,"key":18741,"name":"f7f29209-f5b1-390c-9451-b5ee382d8a40","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/f7f29209-f5b1-390c-9451-b5ee382d8a40\/2024_04_18_09_37_56.pdf","orig_name":"2024_04_18_09_37_56.pdf"}}],"receiptScans":[{"id":25601,"object_type":106,"object_id":3235,"attachment_id":19035,"attachment":{"id":19035,"key":19035,"name":"be427822-3d4f-3fac-ad9a-d6373b6b6af2","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/be427822-3d4f-3fac-ad9a-d6373b6b6af2\/2024_05_11_09_36_06.pdf","orig_name":"2024_05_11_09_36_06.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":1900,"key":1900,"contract_id":3235,"value":"375748","created_by":1013,"created_at":"2024-07-15 12:39:15","collected_date":"2024-07-15","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1648,"key":1648,"contract_id":3235,"value":"375748.00","attachment_id":null,"from_date":"2024-05-08","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2368,"key":2368,"contract_id":3235,"name":"2024-07-12","value":"375748","overdue_days":3,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":5828,"user_id":1001,"key":1001,"contract_id":3235,"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"}}}],"salesSupplierRels":[{"id":1543,"contract_id":3235,"supplier_id":163,"purchase_id":3241,"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":3241,"key":3241,"serial_no":"2024WSCN-E-020-C0421"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[{"id":1451,"user_id":1001,"key":1001,"project_id":3503,"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"}}}],"projectProductRels":[{"id":5558,"project_id":3503,"product_id":1558,"amount":"71782","number":1,"cost":"70227.24","description":"","supplier_id":163,"hardware_from":"2024-05-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-05-08","software_to":null,"maintenance_to":null,"total_amount":"71782","total_cost":"70227.24","supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1558,"name":"PAN-PA-1420","product_type":5,"product_component":26,"product_brand":8,"product_serie":1344,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-1420","created_by":1013,"created_at":"2024-04-15 15:38:17","updated_at":"2024-04-26 09:37:18","pinyin_shortcut":"PANPA1420","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1344,"key":1344,"name":"PA-1420\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":5559,"project_id":3503,"product_id":1559,"amount":"65359","number":1,"cost":"38394.01","description":"","supplier_id":163,"hardware_from":null,"software_from":"2024-05-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-05-08","maintenance_to":null,"total_amount":"65359","total_cost":"38394.01","supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1559,"name":"PAN-PA-1420-TP-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1420, Threat prevention subscription, 3 years (36 months) term","created_by":1013,"created_at":"2024-04-15 15:38:59","updated_at":"2024-04-15 15:38:59","pinyin_shortcut":"PANPA1420TP3YR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":5560,"project_id":3503,"product_id":1560,"amount":"98039","number":1,"cost":"57590.45","description":"","supplier_id":163,"hardware_from":null,"software_from":"2024-05-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-05-08","maintenance_to":null,"total_amount":"98039","total_cost":"57590.45","supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1560,"name":"PAN-PA-1420-ADVURL-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1420, Advanced URL Filtering subscription, 3 years (36 months) term","created_by":1013,"created_at":"2024-04-15 15:39:26","updated_at":"2024-04-15 15:39:26","pinyin_shortcut":"PANPA1420ADVURL3YR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":5561,"project_id":3503,"product_id":1561,"amount":"65359","number":1,"cost":"38394.01","description":"","supplier_id":163,"hardware_from":null,"software_from":"2024-05-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-05-08","maintenance_to":null,"total_amount":"65359","total_cost":"38394.01","supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1561,"name":"PAN-PA-1420-DNS-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1420, DNS security subscription, 3 years (36 months) term","created_by":1013,"created_at":"2024-04-15 15:39:55","updated_at":"2024-04-15 15:39:55","pinyin_shortcut":"PANPA1420DNS3YR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":5562,"project_id":3503,"product_id":1562,"amount":"6526","number":1,"cost":"5912.16","description":"","supplier_id":163,"hardware_from":"2024-05-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-05-08","software_to":null,"maintenance_to":null,"total_amount":"6526","total_cost":"5912.16","supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1562,"name":"PAN-PWR-450W-AC","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_misc":null,"product_qa":null,"pn":"","description":"PA-3400,PA-1400, ION 5200 and ION 9200 450W spare power supply","created_by":1013,"created_at":"2024-04-15 15:40:42","updated_at":"2024-04-15 15:40:42","pinyin_shortcut":"PANPWR450WAC","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":5563,"project_id":3503,"product_id":1563,"amount":"68683","number":1,"cost":"58774.69","description":"","supplier_id":163,"hardware_from":null,"software_from":"2024-05-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-05-08","maintenance_to":null,"total_amount":"68683","total_cost":"58774.69","supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1563,"name":"PAN-SVC-BKLN-1420-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1420, Partner enabled premium support, 3 years (36 months) term","created_by":1013,"created_at":"2024-04-15 15:41:18","updated_at":"2024-04-15 15:41:18","pinyin_shortcut":"PANSVCBKLN14203YR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"commentCount":{"object_id":3503,"comment":4},"unreadComments":null,"fromContact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"mobiles":[{"id":6789,"contact_id":1262,"mobile":"15810817538","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[{"id":588,"project_id":3503,"contact_id":1262,"point":"76084.00","paid_point":"76084","contact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPointRels":[{"id":110,"project_id":3503,"contact_id":1262,"point":"76084.00","day_at":"2024-07-24","description":"","created_at":"2024-07-24 11:08:28"}],"status_display":"\u5df2\u6838\u9500"}],"projectUsedClient":null,"remain_display":450,"progress_remain_display":452,"forecast_remain_display":452,"projectProductTotalAmount":375748,"projectProductAllAmount":true,"projectProductTotalCost":269292.56,"projectProductAllCost":true,"projectProductTotalNumber":6,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":369,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"37.57\u4e07","contact_points_status_display":"\u5df2\u6838\u9500"},{"id":3644,"client_id":2553,"project_status":3,"project_progress":6,"budget":"120000","profit_pct":"0.39","bargain_date":"2024-08-28","description":"","created_by":1001,"created_at":"2024-08-28 11:57:23","updated_at":"2025-04-19 19:07:31","engineer_id":null,"project_title":"PA820\u9632\u706b\u58993\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","collected":"120000","status_updated_at":"2024-08-28 11:57:23.285881+08","success_rate":null,"comment":"777","contract_type":1,"progress_updated_at":"2024-08-28 11:57:23.285881+08","forecast_updated_at":"2024-08-28 11:57:23.285881+08","end_at":"2025-04-19 19:07:31","pinyin_shortcut":"PA820fhq3nfwcgxm","creator":1001,"used_client":null,"from_contact":1262,"total_contact_point":"8719","paid_contact_point":"8719","project_product_version_id":548,"is_sales_order_ready":true,"collected_plan":120000,"profits":"468.000000000000000000","remain":"318 days 01:58:23.485441","progress_remain":"318 days 01:58:23.485441","forecast_remain":"318 days 01:58:23.485441","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"234 days 07:10:08.209286","issued_invoices":"120000.00","client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"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"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"120000.00","pct":"0.39","profit":"468","project_id":3644}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3502,"from_project":3644,"payment_collection_remind_ahead":"2 days","serial_no":"W-KJ-CG-ZBL-20240902-01","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":32993,"object_type":105,"object_id":3502,"attachment_id":21308,"attachment":{"id":21308,"key":21308,"name":"61215821-6952-33fb-9308-bf5a871115a5","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/61215821-6952-33fb-9308-bf5a871115a5\/\u91c7\u8d2d\u5408\u540c--\u6c99\u7279\u6731\u62dc\u52d2\u7f51\u7edc\u5b89\u5168\u9632\u706b\u5899.pdf","orig_name":"\u91c7\u8d2d\u5408\u540c--\u6c99\u7279\u6731\u62dc\u52d2\u7f51\u7edc\u5b89\u5168\u9632\u706b\u5899.pdf"}}],"receiptScans":[{"id":29183,"object_type":106,"object_id":3502,"attachment_id":21870,"attachment":{"id":21870,"key":21870,"name":"c7eff294-4ccf-3537-ba7a-da02e16ee5a2","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/c7eff294-4ccf-3537-ba7a-da02e16ee5a2\/\u9752\u5c9b.pdf","orig_name":"\u9752\u5c9b.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":2093,"key":2093,"contract_id":3502,"value":"120000","created_by":1013,"created_at":"2025-01-24 10:45:26","collected_date":"2025-01-24","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1846,"key":1846,"contract_id":3502,"value":"120000.00","attachment_id":null,"from_date":"2024-10-30","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2367,"key":2367,"contract_id":3502,"name":"2024-11-15","value":"120000","overdue_days":70,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8051,"user_id":5295,"key":5295,"contract_id":3502,"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":8052,"user_id":5388,"key":5388,"contract_id":3502,"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":8053,"user_id":1001,"key":1001,"contract_id":3502,"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"}}}],"salesSupplierRels":[{"id":2507,"contract_id":3502,"supplier_id":90,"purchase_id":3503,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3503,"key":3503,"serial_no":"X_2024SBQ22541"}},{"id":2508,"contract_id":3502,"supplier_id":531,"purchase_id":3574,"supplier":{"id":531,"key":531,"name":"\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3574,"key":3574,"serial_no":"TSKJ20241009-HYF-002"}}],"payment_collection_remind_ahead_display":"2\u5929"},"projectRemindReceivers":[{"id":1450,"user_id":1001,"key":1001,"project_id":3644,"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"}}}],"projectProductRels":[{"id":8998,"project_id":3644,"product_id":196,"amount":"32452","number":1,"cost":"17849","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"32452","total_cost":"17849","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":196,"name":"PAN-PA-820","product_type":5,"product_component":26,"product_brand":8,"product_serie":165,"product_misc":5,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-05-16 10:42:17","updated_at":"2024-01-12 14:13:38","pinyin_shortcut":"PANPA820","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":165,"key":165,"name":"PA820\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8999,"project_id":3644,"product_id":1303,"amount":"23210","number":1,"cost":"22746","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"23210","total_cost":"22746","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1303,"name":"PAN-SVC-PREM-820-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":804,"product_misc":null,"product_qa":null,"pn":"","description":"Premium support 3-year term, PA-820","created_by":1013,"created_at":"2024-01-23 14:00:39","updated_at":"2024-01-23 14:00:39","pinyin_shortcut":"PANSVCPREM8203YR","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":804,"key":804,"name":"PA-820\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9000,"project_id":3644,"product_id":1763,"amount":"16138","number":1,"cost":"15816","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"16138","total_cost":"15816","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1763,"name":"PAN-PA-820-TP-3YR-HA2","product_type":5,"product_component":36,"product_brand":8,"product_serie":975,"product_misc":null,"product_qa":null,"pn":"","description":"Threat prevention subscription 3-year term for device in an HA pair, PA-820","created_by":1013,"created_at":"2024-08-28 16:56:26","updated_at":"2024-08-28 16:56:26","pinyin_shortcut":"PANPA820TP3YRHA2","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":975,"key":975,"name":"PA820\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9001,"project_id":3644,"product_id":1764,"amount":"24100","number":1,"cost":"23782","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"24100","total_cost":"23782","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1764,"name":"PAN-PA-820-ADVURL-3YR-HA2","product_type":5,"product_component":36,"product_brand":8,"product_serie":975,"product_misc":null,"product_qa":null,"pn":"","description":"Advanced URL Filtering Subscription, 3-year, PA-820 HA Pair","created_by":1013,"created_at":"2024-08-28 16:57:19","updated_at":"2024-08-28 16:57:19","pinyin_shortcut":"PANPA820ADVURL3YRHA2","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":975,"key":975,"name":"PA820\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9002,"project_id":3644,"product_id":1766,"amount":"24100","number":1,"cost":"23782","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"24100","total_cost":"23782","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1766,"name":"PAN-PA-820-AWF-3YR-HA2","product_type":5,"product_component":36,"product_brand":8,"product_serie":975,"product_misc":null,"product_qa":null,"pn":"","description":"Advanced WildFire subscription 3-year term for device in an HA pair, PA-820","created_by":1013,"created_at":"2024-08-28 17:00:07","updated_at":"2024-08-28 17:00:07","pinyin_shortcut":"PANPA820AWF3YRHA2","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":975,"key":975,"name":"PA820\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9003,"project_id":3644,"product_id":1668,"amount":"0","number":2,"cost":"600","description":"","supplier_id":531,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"1200","supplier":{"id":531,"key":531,"name":"\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1668,"name":"PAN-SFP-CG\u7b2c\u4e09\u65b9\u6a21\u5757","product_type":4,"product_component":43,"product_brand":8,"product_serie":1419,"product_misc":null,"product_qa":null,"pn":"","description":"SFP form factor.1Gb copper transceiver,100m over Cat5 RJ-45.IEEE802.3ab 1000BASE-T","created_by":1013,"created_at":"2024-07-09 14:17:00","updated_at":"2024-07-09 14:17:00","pinyin_shortcut":"PANSFPCGdsfmk","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1419,"key":1419,"name":"PAN-SFP-CG"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"commentCount":{"object_id":3644,"comment":3},"unreadComments":null,"fromContact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"mobiles":[{"id":6789,"contact_id":1262,"mobile":"15810817538","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[{"id":914,"project_id":3644,"contact_id":1262,"point":"8719.00","paid_point":"8719","contact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPointRels":[{"id":128,"project_id":3644,"contact_id":1262,"point":"2104.00","day_at":"2024-11-28","description":"\u7528\u6237\u8d27\u6b3e\u672a\u6536\u56de\uff0c\u6263\u96642\u4e2a\u70b9\u8d44\u91d1\u5360\u7528\u8d39\u3002","created_at":"2024-11-28 11:17:43"},{"id":173,"project_id":3644,"contact_id":1262,"point":"247.50","day_at":"2025-03-17","description":"\u5ef6\u8fdf\u6536\u6b3e\uff0c\u6263\u9664\u8d39\u7528\u3002","created_at":"2025-03-17 16:42:32"},{"id":174,"project_id":3644,"contact_id":1262,"point":"6367.50","day_at":"2025-03-17","description":"","created_at":"2025-03-17 16:42:32"}],"status_display":"\u5df2\u6838\u9500"}],"projectUsedClient":null,"remain_display":318,"progress_remain_display":318,"forecast_remain_display":318,"projectProductTotalAmount":120000,"projectProductAllAmount":true,"projectProductTotalCost":105175,"projectProductAllCost":true,"projectProductTotalNumber":7,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":234,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"12\u4e07","contact_points_status_display":"\u5df2\u6838\u9500"},{"id":3568,"client_id":3009,"project_status":3,"project_progress":9,"budget":"949200","profit_pct":"0.61","bargain_date":"2024-06-13","description":"","created_by":1001,"created_at":"2024-06-13 10:45:30","updated_at":"2025-04-19 19:03:49","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u5206\u5e03\u5f0f\u5b58\u50a8\u91c7\u8d2d\u9879\u76ee","collected":"949200","status_updated_at":"2024-06-13 10:45:30.859303+08","success_rate":null,"comment":"666","contract_type":1,"progress_updated_at":"2024-06-13 10:45:30.859303+08","forecast_updated_at":"2024-06-13 10:45:30.859303+08","end_at":"2025-04-19 19:03:49","pinyin_shortcut":"sxffbscccgxm","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":449,"is_sales_order_ready":true,"collected_plan":949200,"profits":"5790.120000000000000000","remain":"394 days 03:10:15.912019","progress_remain":"394 days 03:10:15.912019","forecast_remain":"394 days 03:10:15.912019","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"310 days 08:18:18.249238","issued_invoices":"949200.00","client":{"id":3009,"key":3009,"name":"\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":43,"client_industry":18,"sales_rep":1001,"salesRep":{"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"}},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":18,"key":18,"name":"\u5a92\u4f53"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"949200.00","pct":"0.61","profit":"5790.12","project_id":3568}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3348,"from_project":3568,"payment_collection_remind_ahead":"7 days","serial_no":"2024SZCB-0795-220893","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":27877,"object_type":105,"object_id":3348,"attachment_id":19680,"attachment":{"id":19680,"key":19680,"name":"3049ca84-484d-3da7-96f3-dadc8a5de3f7","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/3049ca84-484d-3da7-96f3-dadc8a5de3f7\/2024_06_07_11_03_12.pdf","orig_name":"2024_06_07_11_03_12.pdf"}}],"receiptScans":[{"id":27870,"object_type":106,"object_id":3348,"attachment_id":20922,"attachment":{"id":20922,"key":20922,"name":"fe74c1e8-84a6-3046-98e4-d8ff2e5ea5ed","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/fe74c1e8-84a6-3046-98e4-d8ff2e5ea5ed\/\u8ba2\u5355\u7f16\u53f7220873 \u5b58\u50a8\u9a8c\u6536\u5355.pdf","orig_name":"\u8ba2\u5355\u7f16\u53f7220873 \u5b58\u50a8\u9a8c\u6536\u5355.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":1965,"key":1965,"contract_id":3348,"value":"949200","created_by":1013,"created_at":"2024-09-19 16:29:39","collected_date":"2024-09-19","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1749,"key":1749,"contract_id":3348,"value":"949200.00","attachment_id":null,"from_date":"2024-08-14","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2366,"key":2366,"contract_id":3348,"name":"2024-09-28","value":"949200","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":6205,"user_id":5388,"key":5388,"contract_id":3348,"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":6206,"user_id":1001,"key":1001,"contract_id":3348,"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"}}}],"salesSupplierRels":[{"id":1657,"contract_id":3348,"supplier_id":511,"purchase_id":3359,"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchase":{"id":3359,"key":3359,"serial_no":"TSKJ20240620-HYF-002"}}],"payment_collection_remind_ahead_display":"7\u5929"},"projectRemindReceivers":[{"id":1449,"user_id":1001,"key":1001,"project_id":3568,"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"}}}],"projectProductRels":[{"id":5941,"project_id":3568,"product_id":1655,"amount":"949200","number":1,"cost":"920724","description":"","supplier_id":511,"hardware_from":"2024-06-25","software_from":null,"maintenance_from":null,"hardware_to":"2029-06-24","software_to":null,"maintenance_to":null,"total_amount":"949200","total_cost":"920724","supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1655,"name":"aStor-EDS3650-W","product_type":3,"product_component":14,"product_brand":12,"product_serie":1408,"product_misc":null,"product_qa":null,"pn":"","description":"\u6df1\u4fe1\u670d\u4f01\u4e1a\u7ea7\u5206\u5e03\u5b58\u50a8aStor-EDS3650-W\n\u603b\u5b9e\u9645\u53ef\u7528\u5bb9\u91cf500TB\u652f\u6301\u5168\u95ea\u6027\u80fd\u5149\u53e3\u5b58\u50a8\uff0c\u5355\u8bbe\u5907\u63a5\u53e3\u81f3\u5c11\u6ee1\u8db3\uff1a2\u5343\u5146\u7535\u53e3+2\u4e07\u5146\u5149\u53e3+2\u4e07\u5146\u5149\u53e3(mellanox 25G)\uff0c\u6ee1\u914d\u5149\u6a21\u5757\u548c\u5149\u7ea4\u7ebf\uff0c\u5e26\u75c5\u6bd2\u68c0\u67e5\u548c\u5904\u7f6e\u529f\u80fd\uff0c\u80fd\u591f\u63a5\u5165\u672c\u5730\u5b89\u5168\u8fd0\u8425\u4e2d\u5fc3\u8fdb\u884c\u6570\u636e\u5b89\u5168\u534f\u540c\u9632\u62a4\uff0c\u5305\u62ec\u96c6\u7fa4\u5185100Gb\u7f51\u7edc\u4e92\u8054\u548c\u5916\u8054100Gb\u7f51\u7edc\u4e92\u8054\u63a5\u53e3\u3001\u6a21\u5757\u3001\u7ebf\u7f06\u548c\u4e92\u8054\u8bbe\u65bd\uff0832\u53e3+\uff09\u3002\n2\u3001\u8f6f\u4ef6\u914d\u7f6e\u89c4\u683c\uff1a\u6574\u4f53\u96c6\u7fa4\u4e0d\u4f4e\u4e8e1PB\u8f6f\u4ef6\u88f8\u5bb9\u91cf\u6388\u6743\uff0c\u4e00\u4e2a\u96c6\u7fa4\u5e73\u53f0\u540c\u65f6\u652f\u6301\u5757\u3001\u6587\u4ef6\u3001\u5bf9\u8c61\u591a\u79cd\u5b58\u50a8\u670d\u52a1\uff0c\u5177\u4f53\u5404\u9879\u7c7b\u578b\u5b58\u50a8\u4f7f\u7528\u91cf\u53ef\u5728\u5b9e\u9645\u4f7f\u7528\u4e2d\u52a8\u6001\u7075\u6d3b\u8c03\u6574\uff1b\n3\u30015\u5e74\u4ea7\u54c1\u8d28\u4fdd\u53ca\u4e13\u5c5e\u5907\u4ef6\u5907\u673a\u670d\u52a1\uff1a\u63d0\u4f9b\u786c\u4ef6\u8bbe\u5907\u6545\u969c\u8fd4\u5382\u7ef4\u4fee\u670d\u52a1\uff1b5\u5e74\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff1a\u5206\u5e03\u5f0f\u5b58\u50a8\u8f6f\u4ef6\u5168\u529f\u80fd\u7248\u672c\u5347\u7ea7\uff1b5\u5e74\u8bbe\u5907\u5de1\u68c0\u670d\u52a1\uff1a\u6bcf\u6708\u81f3\u5c11\u4e00\u6b21\u539f\u5382\u5de5\u7a0b\u5e08\u4e0a\u95e8\u6392\u67e5\u68c0\u4fee\u670d\u52a1\uff1b\u4ea7\u54c1\u64cd\u4f5c\u57f9\u8bad\u670d\u52a1\uff1a\u8bbe\u5907\u4e0a\u67b6\u521d\u671f2\u4e2a\u6708\u5185\u81f3\u5c11\u63d0\u4f9b15\u4eba\u5929\u7684\u539f\u5382\u9a7b\u573a\u57f9\u8bad\u64cd\u4f5c\u670d\u52a1\uff0c\u540e\u671f\u6bcf\u6708\u81f3\u5c11\u4e00\u6b21\u539f\u5382\u5de5\u7a0b\u5e08\u4e0a\u95e8\u57f9\u8bad\u64cd\u4f5c\u670d\u52a1\uff1b5\u5e74400\u6280\u672f\u652f\u6301\u670d\u52a1\uff1a7*24\u5c0f\u65f6\u7684\u7ebf\u4e0a\u4e13\u5c5e\u7ba1\u5bb6\u652f\u6301\u670d\u52a1\uff1b","created_by":1013,"created_at":"2024-06-21 14:17:08","updated_at":"2024-06-21 14:17:08","pinyin_shortcut":"aStorEDS3650W","product_unit":2,"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":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1408,"key":1408,"name":"\u6df1\u4fe1\u670d\u4f01\u4e1a\u7ea7\u5206\u5e03\u5b58\u50a8aStor-EDS3650-W"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"commentCount":{"object_id":3568,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":394,"progress_remain_display":394,"forecast_remain_display":394,"projectProductTotalAmount":949200,"projectProductAllAmount":true,"projectProductTotalCost":920724,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":310,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"94.92\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":3599,"client_id":2545,"project_status":3,"project_progress":6,"budget":"38000","profit_pct":"13.45","bargain_date":"2024-07-16","description":"","created_by":1001,"created_at":"2024-07-16 17:00:45","updated_at":"2025-04-19 19:03:10","engineer_id":null,"project_title":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u4e8c","collected":"38000","status_updated_at":"2024-07-18 11:02:34.435078+08","success_rate":null,"comment":"\u53ef\u53ef\u53ef","contract_type":1,"progress_updated_at":"2024-07-16 17:00:45.181291+08","forecast_updated_at":"2024-07-16 17:00:45.181291+08","end_at":"2025-04-19 19:03:10","pinyin_shortcut":"lxSR650esfwqcgxme","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":"7000","paid_contact_point":"7000","project_product_version_id":489,"is_sales_order_ready":true,"collected_plan":0,"profits":"5111.000000000000000000","remain":"359 days 02:53:12.336244","progress_remain":"360 days 20:55:01.590031","forecast_remain":"360 days 20:55:01.590031","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"277 days 02:02:24.987069","issued_invoices":"38000.00","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":10,"sales_rep":1001,"salesRep":{"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"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"38000.00","pct":"13.45","profit":"5111","project_id":3599}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3599,"sum":"41.44"},"buildContract":{"id":3415,"from_project":3599,"payment_collection_remind_ahead":"1 day","serial_no":"TSC-LRC-2024071601","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":27462,"object_type":105,"object_id":3415,"attachment_id":20449,"attachment":{"id":20449,"key":20449,"name":"f685ca10-e9fd-3fb4-a198-c1653f16e3d3","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/f685ca10-e9fd-3fb4-a198-c1653f16e3d3\/\u8d44\u821f\u8d44\u4ea7\u7ba1\u740620240716.pdf","orig_name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u740620240716.pdf"}}],"receiptScans":[{"id":27298,"object_type":106,"object_id":3415,"attachment_id":20473,"attachment":{"id":20473,"key":20473,"name":"cd9cc732-f346-3724-9b31-8c06ff88db9d","extension":"jpeg","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/cd9cc732-f346-3724-9b31-8c06ff88db9d\/WechatIMG6.jpeg","orig_name":"WechatIMG6.jpeg"}}],"verifyScans":[],"salesContractPayments":[{"id":1905,"key":1905,"contract_id":3415,"value":"38000","created_by":1013,"created_at":"2024-07-18 15:27:07","collected_date":"2024-07-18","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1722,"key":1722,"contract_id":3415,"value":"38000.00","attachment_id":null,"from_date":"2024-07-24","attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":5962,"user_id":1001,"key":1001,"contract_id":3415,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":5963,"user_id":5388,"key":5388,"contract_id":3415,"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"}}}],"salesSupplierRels":[{"id":2323,"contract_id":3415,"supplier_id":678,"purchase_id":3422,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3422,"key":3422,"serial_no":"YTYG2024"}}],"payment_collection_remind_ahead_display":"1\u5929"},"projectRemindReceivers":[{"id":1448,"user_id":1001,"key":1001,"project_id":3599,"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"}}}],"projectProductRels":[{"id":5649,"project_id":3599,"product_id":498,"amount":"38000","number":1,"cost":"22000","description":"","supplier_id":81,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"38000","total_cost":"22000","supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"product":{"id":498,"name":"\u8054\u60f3 SR650\u670d\u52a1\u5668","product_type":2,"product_component":2,"product_brand":4,"product_serie":315,"product_misc":2,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2018-11-30 13:58:06","updated_at":"2023-08-14 10:20:52","pinyin_shortcut":"lxSR650fwq","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":315,"key":315,"name":"\u8054\u60f3 SR650 \u670d\u52a1\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}}],"commentCount":{"object_id":3599,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":600,"project_id":3599,"contact_id":4640,"point":"7000.00","paid_point":"7000","contact":{"id":4640,"key":4640,"name":"\u5218\u82f1\u6960","client_id":2545,"supplier_id":null,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":112,"project_id":3599,"contact_id":4640,"point":"7000.00","day_at":"2024-07-29","description":"","created_at":"2024-07-29 15:47:53"}],"status_display":"\u5df2\u6838\u9500"}],"projectUsedClient":null,"remain_display":359,"progress_remain_display":360,"forecast_remain_display":360,"projectProductTotalAmount":38000,"projectProductAllAmount":true,"projectProductTotalCost":22000,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":277,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"3.8\u4e07","contact_points_status_display":"\u5df2\u6838\u9500"},{"id":3767,"client_id":3327,"project_status":3,"project_progress":6,"budget":"121361","profit_pct":"0.65","bargain_date":"2025-01-16","description":"","created_by":1001,"created_at":"2025-01-16 10:05:08","updated_at":"2025-04-19 17:01:38","engineer_id":null,"project_title":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","collected":"121361","status_updated_at":"2025-01-16 15:05:08.316552+08","success_rate":null,"comment":"\u5566\u5566\u5566","contract_type":1,"progress_updated_at":"2025-01-16 10:05:08.667191+08","forecast_updated_at":"2025-04-08 14:45:55.867721+08","end_at":"2025-04-19 17:01:38","pinyin_shortcut":"PA4402tsbxgxme","creator":1001,"used_client":null,"from_contact":1262,"total_contact_point":"40095","paid_contact_point":"40095","project_product_version_id":763,"is_sales_order_ready":true,"collected_plan":121361,"profits":"788.846500000000000000","remain":"176 days 22:50:38.45477","progress_remain":"177 days 03:50:38.104131","forecast_remain":"94 days 23:09:50.903601","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"93 days 06:56:30.156475","issued_invoices":"121361.00","client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"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"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"121361.00","pct":"0.65","profit":"788.8465","project_id":3767}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3763,"from_project":3767,"payment_collection_remind_ahead":null,"serial_no":"TS-LRC-2025011601","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":32996,"object_type":105,"object_id":3763,"attachment_id":23789,"attachment":{"id":23789,"key":23789,"name":"4964731d-7fe6-354d-bf67-08965f467b9d","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/4964731d-7fe6-354d-bf67-08965f467b9d\/\u53cc\u7ae0\u5408\u540c20250116.pdf","orig_name":"\u53cc\u7ae0\u5408\u540c20250116.pdf"}}],"receiptScans":[{"id":32656,"object_type":106,"object_id":3763,"attachment_id":24375,"attachment":{"id":24375,"key":24375,"name":"e1567dde-1ae8-331b-891a-85c3cdf83653","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/e1567dde-1ae8-331b-891a-85c3cdf83653\/\u6587\u6863\u626b\u63cf_20250304140534995.pdf","orig_name":"\u6587\u6863\u626b\u63cf_20250304140534995.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":2079,"key":2079,"contract_id":3763,"value":"24272.2","created_by":1013,"created_at":"2025-01-17 14:36:58","collected_date":"2025-01-17","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":20},{"id":2120,"key":2120,"contract_id":3763,"value":"84952.7","created_by":1013,"created_at":"2025-03-05 11:48:47","collected_date":"2025-03-05","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":70},{"id":2134,"key":2134,"contract_id":3763,"value":"12136.1","created_by":1013,"created_at":"2025-03-12 17:16:37","collected_date":"2025-03-12","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":10}],"salesContractInvoices":[{"id":1976,"key":1976,"contract_id":3763,"value":"121361.00","attachment_id":null,"from_date":"2025-03-11","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2365,"key":2365,"contract_id":3763,"name":"2025-01-24","value":"24272.2","overdue_days":null,"pct":20,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2363,"key":2363,"contract_id":3763,"name":"2025-03-14","value":"84952.7","overdue_days":null,"pct":70,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2364,"key":2364,"contract_id":3763,"name":"2025-03-28","value":"12136.1","overdue_days":null,"pct":10,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8059,"user_id":1001,"key":1001,"contract_id":3763,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":8060,"user_id":1011,"key":1011,"contract_id":3763,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":8061,"user_id":5388,"key":5388,"contract_id":3763,"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"}}}],"salesSupplierRels":[{"id":2511,"contract_id":3763,"supplier_id":90,"purchase_id":3769,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3769,"key":3769,"serial_no":"X_2025SBQ01556"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[{"id":1447,"user_id":1001,"key":1001,"project_id":3767,"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"}}}],"projectProductRels":[{"id":9011,"project_id":3767,"product_id":849,"amount":"12181.43","number":2,"cost":"5872.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"24362.86","total_cost":"11744","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":849,"name":"PAN-PA-440","product_type":5,"product_component":26,"product_brand":8,"product_serie":801,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-440","created_by":1013,"created_at":"2022-07-25 15:54:45","updated_at":"2024-01-12 15:21:09","pinyin_shortcut":"PANPA440","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":801,"key":801,"name":"PA-440\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":9012,"project_id":3767,"product_id":1471,"amount":"24278.57","number":2,"cost":"11702.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"48557.14","total_cost":"23404","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1471,"name":"PAN-PA-440-BND-CORESEC-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":999,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Core Security Subscription Bundle\n(Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, DNS Security and SD-WAN), 3 years (36 months)term","created_by":1013,"created_at":"2024-03-01 17:41:36","updated_at":"2024-03-01 17:41:52","pinyin_shortcut":"PANPA440BNDCORESEC3YR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":999,"key":999,"name":"PA440\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9013,"project_id":3767,"product_id":1340,"amount":"1201.43","number":2,"cost":"785.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2402.86","total_cost":"1570","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1340,"name":"PAN-PWR-50W-AC","product_type":5,"product_component":157,"product_brand":8,"product_serie":1012,"product_misc":null,"product_qa":null,"pn":"","description":"50W AC power adapter for PA-440 PA-450 and PA-460","created_by":1013,"created_at":"2024-01-25 09:26:04","updated_at":"2024-01-25 09:26:04","pinyin_shortcut":"PANPWR50WAC","product_unit":3,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1012,"key":1012,"name":"PA-440\/450\/460\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":9014,"project_id":3767,"product_id":989,"amount":"1221","number":1,"cost":"1177.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1221.00","total_cost":"1177","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":989,"name":"PAN-PA-400-RACKTRAY","product_type":5,"product_component":157,"product_brand":8,"product_serie":615,"product_misc":null,"product_qa":null,"pn":"","description":"Rack mountable tray for up to two PA-400s and 4 power adapters for a 4 post rack mount (PA-440\/450\/460 models only)","created_by":1013,"created_at":"2023-08-09 16:14:38","updated_at":"2024-01-12 15:11:56","pinyin_shortcut":"PANPA400RACKTRAY","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":615,"key":615,"name":"PA-440\/450\/460\u5bfc\u8f68"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9015,"project_id":3767,"product_id":1353,"amount":"9008.57","number":2,"cost":"6782.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"18017.14","total_cost":"13564","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1353,"name":"PAN-PA-440-BND-CORESEC","product_type":5,"product_component":36,"product_brand":8,"product_serie":999,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Core Security Subscription Renewal Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, DNS Security and SD-WAN), 1 years (12 months) term","created_by":1013,"created_at":"2024-01-26 11:18:43","updated_at":"2024-12-17 17:12:20","pinyin_shortcut":"PANPA440BNDCORESEC","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":999,"key":999,"name":"PA440\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9016,"project_id":3767,"product_id":1902,"amount":"3350.00","number":2,"cost":"4342.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"6700","total_cost":"8684","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1902,"name":"PAN-SVC-PREM-440","product_type":5,"product_component":35,"product_brand":8,"product_serie":618,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Premium support, 1 year (12 months), term.","created_by":1013,"created_at":"2024-12-17 17:15:24","updated_at":"2024-12-17 17:15:24","pinyin_shortcut":"PANSVCPREM440","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":618,"key":618,"name":"PA440\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9017,"project_id":3767,"product_id":1903,"amount":"10050.00","number":2,"cost":"2261.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"20100","total_cost":"4522","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1903,"name":"PAN-SVC-PREM-440-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":784,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Premium support, 3 years (36 months), term.","created_by":1013,"created_at":"2024-12-17 17:16:11","updated_at":"2024-12-17 17:16:11","pinyin_shortcut":"PANSVCPREM4403YR","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":784,"key":784,"name":"PA440\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"commentCount":{"object_id":3767,"comment":4},"unreadComments":null,"fromContact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"mobiles":[{"id":6789,"contact_id":1262,"mobile":"15810817538","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[{"id":917,"project_id":3767,"contact_id":1262,"point":"40095.00","paid_point":"40095","contact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPointRels":[{"id":177,"project_id":3767,"contact_id":1262,"point":"40095.00","day_at":"2025-03-17","description":"","created_at":"2025-03-17 16:45:08"}],"status_display":"\u5df2\u6838\u9500"}],"projectUsedClient":{"id":93,"project_id":3767,"used_client":3300,"budget":"20000","profit":"18000","profit_pct":"90","collected_plan":"2398","remind_ahead":"2 days","usedClient":{"id":3300,"name":"\u4e2d\u56fd\u822a\u5929\u7cfb\u7edf\u5de5\u7a0b\u6709\u9650\u516c\u53f8\uff08\u822a\u5929\u6d4b\u63a7\u4e0a\u7ea7\u5355\u4f4d\uff09","abbr":null,"pinyin_shortcut":"zghtxtgcyxgshtcksjdw","description":"","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":null,"reg_address":null,"working_address":null,"telephone":"","fax":"","scale":null,"branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":5,"client_type":6,"sales_rep":5087,"main_contact":null,"created_by":5087,"created_at":"2024-09-04 16:05:44","updated_at":"2025-06-03 17:43:37","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-09-04 16:05:44","it_budget":null,"deployment_mode":null,"it_per_num":null,"public_relations_difficulty":null,"it_status":null,"decision_process":null,"coach":null,"competitor":null,"peers":null,"supplier":null,"main_product":null,"client_base_info_count":1,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null},"projectUsedClientPaymentCollectionRemindReceivers":[{"id":6,"project_used_client_id":93,"user_id":1000,"user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}},{"id":7,"project_used_client_id":93,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}},{"id":8,"project_used_client_id":93,"user_id":5016,"user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}},{"id":9,"project_used_client_id":93,"user_id":5064,"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}},{"id":10,"project_used_client_id":93,"user_id":1001,"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"}}}],"projectUsedClientPaymentCollectionRemindDates":[{"id":3,"key":3,"project_used_client_id":93,"remind_date":"2025-04-10","amount":55,"name":"2025-04-10","value":55,"overdue_days":null,"pct":0.28,"collect_status":"\u903e\u671f93\u5929"},{"id":4,"key":4,"project_used_client_id":93,"remind_date":"2025-04-07","amount":2343,"name":"2025-04-07","value":2343,"overdue_days":null,"pct":11.72,"collect_status":"\u903e\u671f96\u5929"}],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":20000,"un_collected":20000,"remind_ahead_display":"2\u5929","project_used_client_collected_plan":2398,"project_used_client_collected_plan_pct":11.99},"remain_display":176,"progress_remain_display":177,"forecast_remain_display":94,"projectProductTotalAmount":121361,"projectProductAllAmount":true,"projectProductTotalCost":64665,"projectProductAllCost":true,"projectProductTotalNumber":13,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":93,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"12.14\u4e07","contact_points_status_display":"\u5df2\u6838\u9500"},{"id":1791,"client_id":1661,"project_status":3,"project_progress":49,"budget":"514761","profit_pct":"0.56","bargain_date":"2020-06-03","description":"1\u53f05500VX-HW\u8bbe\u5907","created_by":1001,"created_at":"2020-06-23 16:32:19","updated_at":"2025-04-08 14:52:10","engineer_id":null,"project_title":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee","collected":"514761.00","status_updated_at":"2020-08-10 17:52:12.720678+08","success_rate":null,"comment":"1\u53f05500VX-HW\u8bbe\u5907\r\n1.\n2.\n3.\n","contract_type":1,"progress_updated_at":"2022-10-19 23:06:35.395931+08","forecast_updated_at":"2021-04-19 22:25:38.787859+08","end_at":"2025-04-08 14:52:10","pinyin_shortcut":"hy5500VXcgxm","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":514761,"profits":"2882.661600000000000000","remain":"1796 days 20:03:34.050644","progress_remain":"996 days 14:49:11.375391","forecast_remain":"1544 days 15:30:07.983463","lost_contact_days":"1400.10193022363","last_contact":"2021-09-11 11:29:00","last_arrive_days":null,"last_arrive":null,"duration":"1749 days 22:19:51.007842","issued_invoices":"514761.00","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"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"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"514761.00","pct":"0.56","profit":"2882.6616","project_id":1791}],"salesForecast":{"id":175,"key":175,"name":"100%","description":"\u6210\u529f\u7b7e\u8ba2\u5408\u540c"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":{"project_id":1791,"count":2},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":{"project_id":1791,"hours":"0","times":1},"reimbursementAmountSum":null,"buildContract":{"id":1558,"from_project":1791,"payment_collection_remind_ahead":"1 day","serial_no":"TSKJ20200602-HYF-004","is_settle":false,"is_deliver":false,"is_outbound":false,"contractScans":[{"id":12313,"object_type":105,"object_id":1558,"attachment_id":5271,"attachment":{"id":5271,"key":5271,"name":"1727e634-855f-3aa3-86ce-f19c5df0e9dd","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/1727e634-855f-3aa3-86ce-f19c5df0e9dd\/2020_06_29_09_03_56.pdf","orig_name":"2020_06_29_09_03_56.pdf"}}],"receiptScans":[{"id":13085,"object_type":106,"object_id":1558,"attachment_id":5320,"attachment":{"id":5320,"key":5320,"name":"b0db54c2-4b7d-3b26-b333-1bcd84fc2666","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/b0db54c2-4b7d-3b26-b333-1bcd84fc2666\/\u626b\u63cf\u5168\u80fd\u738b 2020-07-08 14.11.10.pdf","orig_name":"\u626b\u63cf\u5168\u80fd\u738b 2020-07-08 14.11.10.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":909,"key":909,"contract_id":1558,"value":"514761.00","created_by":null,"created_at":"","collected_date":null,"createdBy":null,"pct":100}],"salesContractInvoices":[{"id":854,"key":854,"contract_id":1558,"value":"514761.00","attachment_id":5400,"from_date":"2020-07-15","attachment":{"id":5400,"key":5400,"name":"b0be27a4-0269-36ec-99ed-ef2ca596d429","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/b0be27a4-0269-36ec-99ed-ef2ca596d429\/2020_07_15_11_35_57.pdf","orig_name":"2020_07_15_11_35_57.pdf"}}],"salesContractPaymentCollectionRemindDates":[{"id":2362,"key":2362,"contract_id":1558,"name":"2020-08-11","value":"514761","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8068,"user_id":1001,"key":1001,"contract_id":1558,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":8069,"user_id":1011,"key":1011,"contract_id":1558,"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"}}}],"salesSupplierRels":[{"id":635,"contract_id":1558,"supplier_id":365,"purchase_id":1559,"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":1559,"key":1559,"serial_no":"TSKJ20200603-HYF-002"}}],"payment_collection_remind_ahead_display":"1\u5929"},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":1791,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":{"id":94,"project_id":1791,"used_client":982,"budget":"45346345","profit":"44","profit_pct":"0","collected_plan":null,"remind_ahead":null,"usedClient":{"id":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","abbr":null,"pinyin_shortcut":"zgxxaqyjs","description":"","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":"","reg_address":null,"working_address":null,"telephone":"01062305540","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":3,"client_class":1,"client_industry":4,"client_type":6,"sales_rep":1001,"main_contact":null,"created_by":5076,"created_at":"2018-05-16 18:55:46","updated_at":"2025-07-10 10:21:20","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-06-27 14:45:57","it_budget":"800","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":2,"client_key_info_count":1,"contact_count":62,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null},"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":45346345,"un_collected":45346345,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":0},"remain_display":1796,"progress_remain_display":996,"forecast_remain_display":1544,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":1749,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"3\u5e74\u524d","can_view_product":true,"budget_display":"51.48\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":3723,"client_id":3304,"project_status":3,"project_progress":6,"budget":"319460.45","profit_pct":"0.36","bargain_date":"2024-12-11","description":"","created_by":1001,"created_at":"2024-11-26 10:22:44","updated_at":"2025-03-03 10:24:33","engineer_id":null,"project_title":"PAN-M-300\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","collected":"319460.45","status_updated_at":"2024-12-11 10:33:14.82619+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-11-26 10:22:44.148711+08","forecast_updated_at":"2024-11-26 10:22:44.148711+08","end_at":"2025-02-24 10:15:41","pinyin_shortcut":"PANM300sbcgxm","creator":1001,"used_client":null,"from_contact":1262,"total_contact_point":"14351","paid_contact_point":"14351","project_product_version_id":703,"is_sales_order_ready":true,"collected_plan":319460.45,"profits":"1150.057620000000000000","remain":"213 days 03:22:31.945132","progress_remain":"228 days 03:33:02.622611","forecast_remain":"228 days 03:33:02.622611","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"89 days 23:52:57.128544","issued_invoices":"319460.45","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"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"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"319460.45","pct":"0.36","profit":"1150.05762","project_id":3723}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3703,"from_project":3723,"payment_collection_remind_ahead":"2 days","serial_no":"TS-LRC-20241211001","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":32995,"object_type":105,"object_id":3703,"attachment_id":23131,"attachment":{"id":23131,"key":23131,"name":"b8de52a8-dac7-3039-9f15-cb2e96646d45","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/b8de52a8-dac7-3039-9f15-cb2e96646d45\/2024_12_12_09_19_57.pdf","orig_name":"2024_12_12_09_19_57.pdf"}}],"receiptScans":[{"id":31635,"object_type":106,"object_id":3703,"attachment_id":23594,"attachment":{"id":23594,"key":23594,"name":"0f2e2b61-0062-3af4-a515-c0bf17237292","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/0f2e2b61-0062-3af4-a515-c0bf17237292\/\u6708\u521d\u7b7e\u6536\u5355.pdf","orig_name":"\u6708\u521d\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":2114,"key":2114,"contract_id":3703,"value":"319460.45","created_by":1013,"created_at":"2025-02-24 10:15:41","collected_date":"2025-02-20","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1942,"key":1942,"contract_id":3703,"value":"319460.45","attachment_id":null,"from_date":"2025-01-17","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2301,"key":2301,"contract_id":3703,"name":"2025-02-22","value":"319460.45","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8057,"user_id":1001,"key":1001,"contract_id":3703,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":8058,"user_id":5388,"key":5388,"contract_id":3703,"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"}}}],"salesSupplierRels":[{"id":2510,"contract_id":3703,"supplier_id":90,"purchase_id":3704,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3704,"key":3704,"serial_no":"X_2024SBQ32972"}}],"payment_collection_remind_ahead_display":"2\u5929"},"projectRemindReceivers":[{"id":1313,"user_id":1001,"key":1001,"project_id":3723,"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"}}}],"projectProductRels":[{"id":9008,"project_id":3723,"product_id":1895,"amount":"142435.17","number":1,"cost":"100000.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"142435.17","total_cost":"100000","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1895,"name":"PAN-M-300","product_type":5,"product_component":26,"product_brand":8,"product_serie":1579,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks M-300, 16TB RAID storage (4 8TB RAID certified drives preinstalled). Rack mount rails included.","created_by":1013,"created_at":"2024-12-11 10:53:38","updated_at":"2024-12-11 10:53:38","pinyin_shortcut":"PANM300","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1579,"key":1579,"name":"PAN-M-300\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":9009,"project_id":3723,"product_id":1896,"amount":"40695.76","number":1,"cost":"41807.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"40695.76","total_cost":"41807","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1896,"name":"PAN-M-300-P-25","product_type":5,"product_component":36,"product_brand":8,"product_serie":1580,"product_misc":null,"product_qa":null,"pn":"","description":"Panorama central management software license, 25 devices or log collector for the M-300","created_by":1013,"created_at":"2024-12-11 10:55:06","updated_at":"2024-12-11 10:55:06","pinyin_shortcut":"PANM300P25","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1580,"key":1580,"name":"PAN-M-300\u8f6f\u4ef6\u6388\u6743\u8bb8\u53ef"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9010,"project_id":3723,"product_id":1897,"amount":"136329.52","number":1,"cost":"150000.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"136329.52","total_cost":"150000","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1897,"name":"PAN-SVC-BKLN-M-300-P-25-3Y","product_type":5,"product_component":36,"product_brand":8,"product_serie":1580,"product_misc":null,"product_qa":null,"pn":"","description":"Partner enabled premium support 3-year term, Panorama M-300 25 devices or log collector 36\u4e2a\u6708\u8ba2\u9605\u5f0f","created_by":1013,"created_at":"2024-12-11 10:55:48","updated_at":"2024-12-11 10:55:48","pinyin_shortcut":"PANSVCBKLNM300P253Y","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1580,"key":1580,"name":"PAN-M-300\u8f6f\u4ef6\u6388\u6743\u8bb8\u53ef"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"commentCount":{"object_id":3723,"comment":4},"unreadComments":null,"fromContact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"mobiles":[{"id":6789,"contact_id":1262,"mobile":"15810817538","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[{"id":916,"project_id":3723,"contact_id":1262,"point":"14351.00","paid_point":"14351","contact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPointRels":[{"id":176,"project_id":3723,"contact_id":1262,"point":"14351.00","day_at":"2025-03-17","description":"","created_at":"2025-03-17 16:44:24"}],"status_display":"\u5df2\u6838\u9500"}],"projectUsedClient":null,"remain_display":213,"progress_remain_display":228,"forecast_remain_display":228,"projectProductTotalAmount":319460.45,"projectProductAllAmount":true,"projectProductTotalCost":291807,"projectProductAllCost":true,"projectProductTotalNumber":3,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":89,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"31.95\u4e07","contact_points_status_display":"\u5df2\u6838\u9500"},{"id":3744,"client_id":3327,"project_status":3,"project_progress":9,"budget":"126009","profit_pct":"0.65","bargain_date":"2024-12-25","description":"","created_by":1001,"created_at":"2024-12-17 17:03:55","updated_at":"2025-02-27 10:39:50","engineer_id":null,"project_title":"PA440 2\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","collected":"126009","status_updated_at":"2024-12-25 13:59:01.83268+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-12-17 17:03:55.937462+08","forecast_updated_at":"2024-12-17 17:03:55.937462+08","end_at":"2025-03-12 17:16:52","pinyin_shortcut":"PA4402tsbcgxm","creator":1001,"used_client":null,"from_contact":1262,"total_contact_point":"41291","paid_contact_point":"41291","project_product_version_id":727,"is_sales_order_ready":true,"collected_plan":126009,"profits":"819.058500000000000000","remain":"198 days 23:56:44.938642","progress_remain":"206 days 20:51:50.83386","forecast_remain":"206 days 20:51:50.83386","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"85 days 00:12:56.261973","issued_invoices":"126009.00","client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"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"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"126009.00","pct":"0.65","profit":"819.0585","project_id":3744}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3724,"from_project":3744,"payment_collection_remind_ahead":"2 days","serial_no":"TS-LRC-2024122501","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":32998,"object_type":105,"object_id":3724,"attachment_id":23436,"attachment":{"id":23436,"key":23436,"name":"e1868899-cb9d-3e5c-81ba-f1469cba78f6","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/e1868899-cb9d-3e5c-81ba-f1469cba78f6\/\u4fe1\u8054.pdf","orig_name":"\u4fe1\u8054.pdf"}}],"receiptScans":[{"id":32366,"object_type":106,"object_id":3724,"attachment_id":24180,"attachment":{"id":24180,"key":24180,"name":"397da7f1-009c-31b4-821e-02b5a217b780","extension":"pdf","path":"\/v2\/attachment\/preview\/LpLquexa4MxJRClJNdb9gPVa_MzadLnu\/397da7f1-009c-31b4-821e-02b5a217b780\/\u6587\u6863\u626b\u63cf_20250218133722477.pdf","orig_name":"\u6587\u6863\u626b\u63cf_20250218133722477.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":2068,"key":2068,"contract_id":3724,"value":"25201.8","created_by":1013,"created_at":"2025-01-07 16:52:25","collected_date":"2025-01-07","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":20},{"id":2106,"key":2106,"contract_id":3724,"value":"88206.3","created_by":1013,"created_at":"2025-02-10 15:25:51","collected_date":"2025-02-10","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":70},{"id":2135,"key":2135,"contract_id":3724,"value":"12600.9","created_by":1013,"created_at":"2025-03-12 17:16:52","collected_date":"2025-03-12","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":10}],"salesContractInvoices":[{"id":1964,"key":1964,"contract_id":3724,"value":"126009.00","attachment_id":null,"from_date":"2025-02-27","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2229,"key":2229,"contract_id":3724,"name":"2025-01-10","value":"25201.7","overdue_days":null,"pct":20,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2230,"key":2230,"contract_id":3724,"name":"2025-02-28","value":"88206.3","overdue_days":null,"pct":70,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2231,"key":2231,"contract_id":3724,"name":"2025-03-10","value":"12601","overdue_days":2,"pct":10,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8065,"user_id":1001,"key":1001,"contract_id":3724,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":8066,"user_id":1011,"key":1011,"contract_id":3724,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":8067,"user_id":5388,"key":5388,"contract_id":3724,"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"}}}],"salesSupplierRels":[{"id":2513,"contract_id":3724,"supplier_id":90,"purchase_id":3727,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3727,"key":3727,"serial_no":"X_2024SBQ36962"}}],"payment_collection_remind_ahead_display":"2\u5929"},"projectRemindReceivers":[{"id":1337,"user_id":1001,"key":1001,"project_id":3744,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"projectProductRels":[{"id":9021,"project_id":3744,"product_id":849,"amount":"12181.43","number":2,"cost":"6000.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"24362.86","total_cost":"12000","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":849,"name":"PAN-PA-440","product_type":5,"product_component":26,"product_brand":8,"product_serie":801,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-440","created_by":1013,"created_at":"2022-07-25 15:54:45","updated_at":"2024-01-12 15:21:09","pinyin_shortcut":"PANPA440","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":801,"key":801,"name":"PA-440\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":9022,"project_id":3744,"product_id":1471,"amount":"24278.57","number":2,"cost":"11000.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"48557.14","total_cost":"22000","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1471,"name":"PAN-PA-440-BND-CORESEC-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":999,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Core Security Subscription Bundle\n(Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, DNS Security and SD-WAN), 3 years (36 months)term","created_by":1013,"created_at":"2024-03-01 17:41:36","updated_at":"2024-03-01 17:41:52","pinyin_shortcut":"PANPA440BNDCORESEC3YR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":999,"key":999,"name":"PA440\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9023,"project_id":3744,"product_id":1340,"amount":"1201.43","number":2,"cost":"850.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2402.86","total_cost":"1700","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1340,"name":"PAN-PWR-50W-AC","product_type":5,"product_component":157,"product_brand":8,"product_serie":1012,"product_misc":null,"product_qa":null,"pn":"","description":"50W AC power adapter for PA-440 PA-450 and PA-460","created_by":1013,"created_at":"2024-01-25 09:26:04","updated_at":"2024-01-25 09:26:04","pinyin_shortcut":"PANPWR50WAC","product_unit":3,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1012,"key":1012,"name":"PA-440\/450\/460\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":9024,"project_id":3744,"product_id":989,"amount":"1221.00","number":1,"cost":"1294.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1221","total_cost":"1294","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":989,"name":"PAN-PA-400-RACKTRAY","product_type":5,"product_component":157,"product_brand":8,"product_serie":615,"product_misc":null,"product_qa":null,"pn":"","description":"Rack mountable tray for up to two PA-400s and 4 power adapters for a 4 post rack mount (PA-440\/450\/460 models only)","created_by":1013,"created_at":"2023-08-09 16:14:38","updated_at":"2024-01-12 15:11:56","pinyin_shortcut":"PANPA400RACKTRAY","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":615,"key":615,"name":"PA-440\/450\/460\u5bfc\u8f68"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9025,"project_id":3744,"product_id":1353,"amount":"9008.57","number":2,"cost":"4400.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"18017.14","total_cost":"8800","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1353,"name":"PAN-PA-440-BND-CORESEC","product_type":5,"product_component":36,"product_brand":8,"product_serie":999,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Core Security Subscription Renewal Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, DNS Security and SD-WAN), 1 years (12 months) term","created_by":1013,"created_at":"2024-01-26 11:18:43","updated_at":"2024-12-17 17:12:20","pinyin_shortcut":"PANPA440BNDCORESEC","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":999,"key":999,"name":"PA440\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9026,"project_id":3744,"product_id":1902,"amount":"3350.00","number":2,"cost":"2500.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"6700","total_cost":"5000","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1902,"name":"PAN-SVC-PREM-440","product_type":5,"product_component":35,"product_brand":8,"product_serie":618,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Premium support, 1 year (12 months), term.","created_by":1013,"created_at":"2024-12-17 17:15:24","updated_at":"2024-12-17 17:15:24","pinyin_shortcut":"PANSVCPREM440","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":618,"key":618,"name":"PA440\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9027,"project_id":3744,"product_id":1903,"amount":"10050.00","number":2,"cost":"6500.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"20100","total_cost":"13000","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1903,"name":"PAN-SVC-PREM-440-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":784,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Premium support, 3 years (36 months), term.","created_by":1013,"created_at":"2024-12-17 17:16:11","updated_at":"2024-12-17 17:16:11","pinyin_shortcut":"PANSVCPREM4403YR","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":784,"key":784,"name":"PA440\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9028,"project_id":3744,"product_id":1904,"amount":"1162.00","number":4,"cost":"950.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"4648","total_cost":"3800","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1904,"name":"PAN-PA-400-ACC","product_type":5,"product_component":157,"product_brand":8,"product_serie":1583,"product_misc":null,"product_qa":null,"pn":"","description":"Replacement accessory kit for PA-440, PA-450 and PA-460. This kit is included in the system.","created_by":1013,"created_at":"2024-12-17 17:18:18","updated_at":"2024-12-25 13:55:41","pinyin_shortcut":"PANPA400ACC","product_unit":6,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1583,"key":1583,"name":"PA-440\/450\/460\u7535\u6e90\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}}],"commentCount":{"object_id":3744,"comment":5},"unreadComments":null,"fromContact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"mobiles":[{"id":6789,"contact_id":1262,"mobile":"15810817538","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[{"id":919,"project_id":3744,"contact_id":1262,"point":"41291.00","paid_point":"41291","contact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPointRels":[{"id":179,"project_id":3744,"contact_id":1262,"point":"41291.00","day_at":"2025-03-17","description":"","created_at":"2025-03-17 16:46:13"}],"status_display":"\u5df2\u6838\u9500"}],"projectUsedClient":null,"remain_display":198,"progress_remain_display":206,"forecast_remain_display":206,"projectProductTotalAmount":126009,"projectProductAllAmount":true,"projectProductTotalCost":67594,"projectProductAllCost":true,"projectProductTotalNumber":17,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":85,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"12.6\u4e07","contact_points_status_display":"\u5df2\u6838\u9500"}],"pagenation":{"totalcount":94,"thispage":2,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-12 13:55:46') RETURNING "id" |