6868c19b9a05a: POST https://beta.jinchangxiao.com/vue/analysis/open-project-list at 2025-07-05 02:09:31 pm by 223.72.35.175
Database Queries
总计49条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:09:31.634 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=5250 |
| 14:09:31.637 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 |
| 14:09:31.642 | 10.8 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 ("p"."project_status"='3') AND ("c"."client_industry"='13') AND ("p"."created_by" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 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)) GROUP BY "p"."id" ORDER BY lost_contact_days ASC NULLS LAST, "p"."created_at" DESC) "c" |
| 14:09:31.653 | 11.7 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 ("p"."project_status"='3') AND ("c"."client_industry"='13') AND ("p"."created_by" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 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)) GROUP BY "p"."id" ORDER BY lost_contact_days ASC NULLS LAST, "p"."created_at" DESC LIMIT 20 |
| 14:09:31.666 | 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 (2021, 3328, 3274, 2819, 2497, 1152, 2099, 1661, 1641, 1638, 1936, 1640, 3304, 3278, 3334) |
| 14:09:31.666 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (5, 6, 2, 1) |
| 14:09:31.667 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=43 |
| 14:09:31.667 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=13 |
| 14:09:31.668 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=287 |
| 14:09:31.668 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 14:09:31.668 | 0.6 ms | SELECT | SELECT "project_id", "contribution" AS "value", "engineer_id", "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 (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786) |
| 14:09:31.669 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1022, 1016, 1023, 1015, 1017) |
| 14:09:31.670 | 0.6 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1022, 1015, 1023, 1017, 1016)) |
| 14:09:31.670 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3 |
| 14:09:31.671 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_progress" AS "name" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (9, 5, 10, 7, 1, 49, 2) |
| 14:09:31.671 | 0.9 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 (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786) |
| 14:09:31.672 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786) |
| 14:09:31.673 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (153, 224, 2, 213, 5, 135, 140, 185, 191, 164, 131, 172, 1, 215, 136, 139, 184, 189, 226, 227, 165, 132, 167, 175, 166, 179, 178, 174, 197, 199, 142, 181, 130, 196, 204, 308, 198, 202, 324, 340, 349, 363, 369, 377, 2100000000)) ORDER BY "sort" |
| 14:09:31.674 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786) |
| 14:09:31.675 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (153, 224, 2, 213, 5, 135, 140, 185, 191, 164, 131, 172, 1, 215, 136, 139, 184, 189, 226, 227, 165, 132, 167, 175, 166, 179, 178, 174, 197, 199, 142, 181, 130, 196, 204, 308, 198, 202, 324, 340, 349, 363, 369, 377, 2100000000)) ORDER BY "sort" |
| 14:09:31.675 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786) |
| 14:09:31.676 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (153, 224, 2, 213, 5, 135, 140, 185, 191, 164, 131, 172, 1, 215, 136, 139, 184, 189, 226, 227, 165, 132, 167, 175, 166, 179, 178, 174, 197, 199, 142, 181, 130, 196, 204, 308, 198, 202, 324, 340, 349, 363, 369, 377, 2100000000)) ORDER BY "sort" |
| 14:09:31.676 | 3.6 ms | SELECT | SELECT id, client_id, project_id, schedule_title, end_at, created_by, is_complete, is_closed, complete_description, set_top_at, CASE WHEN is_complete = true THEN 3 WHEN is_complete = false AND end_at <= NOW() THEN 2 ELSE 1 END AS sort FROM "a57be577deb434"."tbl_schedules" WHERE (("is_complete"=FALSE) OR ("end_at" >= '2025-06-21')) AND ((("is_public"=1) AND ("created_by" != 5250)) OR ("created_by"=5250)) AND ("project_id" IN (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786)) ORDER BY set_top_at DESC nulls last, sort ASC, case when is_complete = true then complete_at END desc, case when is_complete = false then end_at END asc, end_at DESC |
| 14:09:31.680 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5412, 5364, 5329, 5299, 1001, 5096, 1005, 1003) |
| 14:09:31.681 | 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, 5096, 5412, 5299, 5329, 5364, 1005, 5300, 1003)) |
| 14:09:31.681 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1) |
| 14:09:31.682 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5412, 5364, 5329, 5299, 1001, 5096, 1005, 1003) |
| 14:09:31.682 | 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, 5096, 5412, 5299, 5329, 5364, 1005, 5300, 1003)) |
| 14:09:31.682 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2021, 3328, 3274, 2819, 2497, 1152, 2099, 1661, 1641, 1638, 1936, 1640, 3304, 3278, 3334) |
| 14:09:31.683 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5300, 5329, 5311) |
| 14:09:31.683 | 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, 5311, 5329, 5300)) |
| 14:09:31.684 | 0.5 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 (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786)) GROUP BY "project_id" |
| 14:09:31.685 | 5.7 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 (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786)) GROUP BY "c"."project_id" |
| 14:09:31.691 | 2.3 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 (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786)) GROUP BY "c"."project_id" |
| 14:09:31.693 | 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 (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786)) GROUP BY "project_id" |
| 14:09:31.694 | 1.4 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786)) GROUP BY "project_id" |
| 14:09:31.696 | 0.7 ms | SELECT | SELECT "id", "from_project", "payment_collection_remind_ahead" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786) |
| 14:09:31.697 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (3354, 3740, 3749, 2247, 2270, 1424, 1502, 2086, 2536, 1875, 2448, 2522, 3205, 1733, 1558, 3841, 3803, 3840, 3844, 3843) ORDER BY "id" |
| 14:09:31.697 | 0.7 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 (3354, 3740, 3749, 2247, 2270, 1424, 1502, 2086, 2536, 1875, 2448, 2522, 3205, 1733, 1558, 3841, 3803, 3840, 3844, 3843) ORDER BY "id" |
| 14:09:31.698 | 3.7 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5135, 5223, 5265, 5280, 5400, 6137, 7218, 8470) |
| 14:09:31.702 | 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 (3354, 3740, 3749, 2247, 2270, 1424, 1502, 2086, 2536, 1875, 2448, 2522, 3205, 1733, 1558, 3841, 3803, 3840, 3844, 3843) ORDER BY "remind_date" |
| 14:09:31.703 | 0.3 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786) |
| 14:09:31.703 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005, 5329, 5332, 5420, 5087, 5300, 5295, 5404, 1004) |
| 14:09:31.704 | 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, 5420, 5404, 5332, 5295, 5329, 1005, 5087, 1004, 5300)) |
| 14:09:31.704 | 17.9 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786)) GROUP BY "object_id" |
| 14:09:31.722 | 15.5 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 5250 AND is_read = false) AND ("object_id" IN (3763, 3755, 3570, 3483, 3063, 3074, 2976, 2855, 2830, 2612, 1791, 2423, 1736, 1942, 1741, 3809, 3808, 3807, 3801, 3786)) GROUP BY "object_id" |
| 14:09:31.741 | 3.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05') |
| 14:09:31.744 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=176, "last_visit_at"='now()' WHERE "id"=49799 |
| 14:09:31.746 | 3.2 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/open-project-list', '{"page":"1","period":"","dataUserId":"","client_industry":"13","status":"3","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":3763,"client_id":2021,"project_status":3,"project_progress":9,"budget":"600","profit_pct":"63.25","bargain_date":"2025-01-09","description":"","created_by":5300,"created_at":"2025-01-09 18:29:21","updated_at":"2025-02-11 15:20:25","engineer_id":"","project_title":"\u786c\u76d8SAS300GB10K-G-2025","collected":"600","status_updated_at":"2025-01-09 18:29:21.846599+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-01-09 18:29:21.846599+08","forecast_updated_at":"2025-01-09 18:29:21.846599+08","end_at":"2025-01-13 15:16:00","pinyin_shortcut":"ypSAS300GB10KG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":747,"is_sales_order_ready":true,"collected_plan":600,"profits":"379.500000000000000000","remain":"176 days 19:40:09.807903","progress_remain":"176 days 19:40:09.807903","forecast_remain":"176 days 19:40:09.807903","lost_contact_days":"176.839949704884","last_contact":"2025-01-09 18:00:00","last_arrive_days":"","last_arrive":"","duration":"3 days 20:46:38.850748","issued_invoices":"600.00","client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":5311,"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":"","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"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"600","pct":"63.25","profit":"379.5","project_id":3763}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"schedules":[],"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3749,"from_project":3763,"payment_collection_remind_ahead":"00:00:00","salesContractPayments":[{"id":2071,"key":2071,"contract_id":3749,"value":"600"}],"salesContractInvoices":[{"id":1944,"key":1944,"contract_id":3749,"value":"600.00","attachment_id":"","from_date":"2025-01-21","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2305,"key":2305,"contract_id":3749,"name":"2025-01-09","value":"600","overdue_days":0}]},"projectRemindReceivers":[{"id":1364,"user_id":1001,"key":1001,"project_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"}}}],"commentCount":{"object_id":3763,"comment":2},"unreadComments":{},"lost_contact_days_display":"5\u4e2a\u6708\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":176,"progress_remain_display":176,"forecast_remain_display":176,"duration_display":3,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"600"},{"id":3755,"client_id":3328,"project_status":3,"project_progress":5,"budget":"537370","profit_pct":"19.37","bargain_date":"2024-12-31","description":"","created_by":5300,"created_at":"2024-12-30 10:19:49","updated_at":"2025-01-02 14:26:22","engineer_id":"","project_title":"\u9f50\u6cbb\u5821\u5792\u673a\u65b0\u8d2d-K-224","collected":"0","status_updated_at":"2024-12-30 16:17:03.198647+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-12-30 10:19:49.65271+08","forecast_updated_at":"2024-12-30 10:19:49.65271+08","end_at":"","pinyin_shortcut":"qzbljxgK224","creator":5300,"used_client":287,"from_contact":"","total_contact_point":"80000","paid_contact_point":"","project_product_version_id":741,"is_sales_order_ready":false,"collected_plan":537370,"profits":"104088.569000000000000000","remain":"186 days 21:52:28.455855","progress_remain":"187 days 03:49:42.001792","forecast_remain":"187 days 03:49:42.001792","lost_contact_days":"186.839949704884","last_contact":"2024-12-30 18:00:00","last_arrive_days":"","last_arrive":"","duration":"187 days 03:49:42.001792","issued_invoices":"","client":{"id":3328,"key":3328,"name":"\u8fc7\u5355-\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8\u4e0a\u6d77\u5206\u516c\u53f8-\u5317\u4eac\u5954\u9a70","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":5300,"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":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09"},"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":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"537370.00","pct":"19.37","profit":"104088.569","project_id":3755}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"schedules":[],"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3740,"from_project":3755,"payment_collection_remind_ahead":"7 days","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2290,"key":2290,"contract_id":3740,"name":"2025-05-31","value":"537370","overdue_days":""}]},"projectRemindReceivers":[{"id":1355,"user_id":1001,"key":1001,"project_id":3755,"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"}}}],"commentCount":{"object_id":3755,"comment":2},"unreadComments":{},"lost_contact_days_display":"6\u4e2a\u6708\u524d","unissued_invoice":537370,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":186,"progress_remain_display":187,"forecast_remain_display":187,"duration_display":187,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"53.74\u4e07"},{"id":3570,"client_id":3274,"project_status":3,"project_progress":10,"budget":"900","profit_pct":"93","bargain_date":"2024-06-12","description":"","created_by":5412,"created_at":"2024-06-17 10:40:37","updated_at":"2024-10-17 16:06:26","engineer_id":"","project_title":"\u8fc7\u4fddZStack\u4e91\u4e3b\u673a\u95ee\u9898\u6392\u67e5\u53ca\u9501\u5b9a","collected":"900","status_updated_at":"2024-06-17 10:40:37.536134+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2024-06-17 10:40:37.536134+08","forecast_updated_at":"2024-06-17 10:40:37.536134+08","end_at":"2024-07-10 09:52:01","pinyin_shortcut":"gbZStackyzjwtpcjsd","creator":5412,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":466,"is_sales_order_ready":true,"collected_plan":900,"profits":"837.0000000000000000","remain":"383 days 03:28:54.118368","progress_remain":"383 days 03:28:54.118368","forecast_remain":"383 days 03:28:54.118368","lost_contact_days":"385.839949704884","last_contact":"2024-06-14 18:00:00","last_arrive_days":"","last_arrive":"","duration":"22 days 23:11:23.878172","issued_invoices":"900.00","client":{"id":3274,"key":3274,"name":"\u5317\u4eac\u4e92\u8054\u4e92\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":"","client_industry":13,"sales_rep":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":"","contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[{"project_id":3570,"value":"1","engineer_id":1015,"key":1015,"name":"\u5434\u660a","engineer":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}}}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"900.00","pct":"93","profit":"837","project_id":3570}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"schedules":[],"createdBy":{"id":5412,"key":5412,"name":"\u5f20\u78ca","sex":"M","department_id":1,"avatar":{},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5412,"key":5412,"name":"\u5f20\u78ca","sex":"M","department_id":1,"avatar":{}},"salesRep":{},"salesTimeCount":{},"implementTimeCount":{"project_id":3570,"sum":"5.37861111111111","times":"1"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3570,"sum":"52.10"},"buildContract":{"id":3354,"from_project":3570,"payment_collection_remind_ahead":"2 days","salesContractPayments":[{"id":1895,"key":1895,"contract_id":3354,"value":"900"}],"salesContractInvoices":[{"id":1702,"key":1702,"contract_id":3354,"value":"900.00","attachment_id":"","from_date":"2024-07-02","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":1809,"key":1809,"contract_id":3354,"name":"2024-07-09","value":"900","overdue_days":1}]},"projectRemindReceivers":[],"commentCount":{"object_id":3570,"comment":6},"unreadComments":{},"lost_contact_days_display":"1\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":383,"progress_remain_display":383,"forecast_remain_display":383,"duration_display":22,"last_arrive_days_display":"","contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"budget_display":"900"},{"id":3483,"client_id":2819,"project_status":3,"project_progress":10,"budget":"36900","profit_pct":"24.17","bargain_date":"2024-03-26","description":"","created_by":5364,"created_at":"2024-03-26 23:51:09","updated_at":"2024-11-14 11:50:28","engineer_id":"","project_title":"\u534e\u4e3a\u4ea4\u6362\u673a","collected":"36900","status_updated_at":"2024-04-08 17:11:04.134019+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-04-08 17:11:04.134019+08","forecast_updated_at":"2024-04-08 17:11:04.134019+08","end_at":"2024-04-29 10:14:13","pinyin_shortcut":"hwjhj","creator":5364,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":622,"is_sales_order_ready":true,"collected_plan":0,"profits":"8918.730000000000000000","remain":"452 days 20:58:27.520483","progress_remain":"452 days 20:58:27.520483","forecast_remain":"452 days 20:58:27.520483","lost_contact_days":"438.089949704884","last_contact":"2024-04-23 12:00:00","last_arrive_days":"","last_arrive":"","duration":"33 days 10:23:04.431641","issued_invoices":"36900.00","client":{"id":2819,"key":2819,"name":"\u5317\u4eac\u4e03\u7ef4\u65f6\u4ee3\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":"","client_industry":13,"sales_rep":"","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":"","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":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"36900.00","pct":"24.17","profit":"8918.73","project_id":3483}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"schedules":[],"createdBy":{"id":5364,"key":5364,"name":"\u738b\u827a\u742e","sex":"F","department_id":1,"avatar":{"id":154,"user_id":5364,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a0b46fdc-d67f-305c-82e5-5b2e01c08e21.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5364,"key":5364,"name":"\u738b\u827a\u742e","sex":"F","department_id":1,"avatar":{"id":154,"user_id":5364,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a0b46fdc-d67f-305c-82e5-5b2e01c08e21.png"}},"salesRep":{},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3205,"from_project":3483,"payment_collection_remind_ahead":"00:00:00","salesContractPayments":[{"id":1820,"key":1820,"contract_id":3205,"value":"34800"},{"id":1833,"key":1833,"contract_id":3205,"value":"2100"}],"salesContractInvoices":[{"id":1628,"key":1628,"contract_id":3205,"value":"36900.00","attachment_id":"","from_date":"2024-04-23","attachment":{}}],"salesContractPaymentCollectionRemindDates":[]},"projectRemindReceivers":[],"commentCount":{"object_id":3483,"comment":4},"unreadComments":{},"lost_contact_days_display":"1\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":452,"progress_remain_display":452,"forecast_remain_display":452,"duration_display":33,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"budget_display":"3.69\u4e07"},{"id":3063,"client_id":2497,"project_status":3,"project_progress":10,"budget":"181893","profit_pct":"1.37","bargain_date":"2022-12-19","description":"PA 450 \u53f0\nPAN-PA-450\tPalo Alto Networks PA-450\nPAN-PA-450-BND-PRO-3YR\tPA-450, Professional Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering, Wildfire, DNS Security and SD-WAN), 3 years (36 months) term\nPAN-SVC-BKLN-450-3YR\tPA-450, Partner enabled premium support, 3 years (36 months), term.","created_by":5300,"created_at":"2022-12-19 16:02:04","updated_at":"2023-10-24 08:21:19","engineer_id":"","project_title":"PA450-3\u53f0-2022","collected":"181893","status_updated_at":"2022-12-26 12:01:08.244858+08","success_rate":"","comment":"PA 450 \u53f0\nPAN-PA-450\tPalo Alto Networks PA-450\nPAN-PA-450-BND-PRO-3YR\tPA-450, Professional Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering, Wildfire, DNS Security and SD-WAN), 3 years (36 months) term\nPAN-SVC-BKLN-450-3YR\tPA-450, Partner enabled premium support, 3 years (36 months), term.\r\n","contract_type":1,"progress_updated_at":"2022-12-26 12:00:45.587308+08","forecast_updated_at":"2023-01-03 17:09:28.753335+08","end_at":"2023-02-23 17:24:21","pinyin_shortcut":"PA4503t2022","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":181893,"profits":"2491.934100000000000000","remain":"922 days 02:08:23.409644","progress_remain":"922 days 02:08:46.067194","forecast_remain":"913 days 21:00:02.901167","lost_contact_days":"621.162171927106","last_contact":"2023-10-23 10:16:00","last_arrive_days":"","last_arrive":"","duration":"66 days 01:22:17.551309","issued_invoices":"181893.00","client":{"id":2497,"key":2497,"name":"\u5317\u4eac\u9f0e\u4fe1\u6cf0\u5fb7\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":"","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":"","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":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"181893.00","pct":"1.37","profit":"2491.9341","project_id":3063}],"salesForecast":{"id":178,"key":178,"name":"90%"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"schedules":[],"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesRep":{},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":2522,"from_project":3063,"payment_collection_remind_ahead":"7 days","salesContractPayments":[{"id":1494,"key":1494,"contract_id":2522,"value":"181893"}],"salesContractInvoices":[{"id":1344,"key":1344,"contract_id":2522,"value":"181893.00","attachment_id":"","from_date":"2023-02-10","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":1115,"key":1115,"contract_id":2522,"name":"2023-02-28","value":"181893","overdue_days":""}]},"projectRemindReceivers":[{"id":354,"user_id":1001,"key":1001,"project_id":3063,"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"}}}],"commentCount":{"object_id":3063,"comment":4},"unreadComments":{},"lost_contact_days_display":"1\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":922,"progress_remain_display":922,"forecast_remain_display":913,"duration_display":66,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"budget_display":"18.19\u4e07"},{"id":3074,"client_id":2021,"project_status":3,"project_progress":9,"budget":"1440","profit_pct":"24.58","bargain_date":"2022-12-30","description":"\u786c\u76d82\u5757\uff1a\nHP StorageWorks P2000-SAS 450GB Dual Port 15K(480939-001)","created_by":5300,"created_at":"2022-12-30 11:42:52","updated_at":"2024-01-22 11:23:31","engineer_id":"","project_title":"\u786c\u76d8\u65b0\u8d2d-20221230","collected":"1440","status_updated_at":"2022-12-30 13:28:20.769801+08","success_rate":"","comment":"\u786c\u76d82\u5757\uff1a\nHP StorageWorks P2000-SAS 450GB Dual Port 15K(480939-001)\r\n","contract_type":1,"progress_updated_at":"2022-12-30 11:42:52.613464+08","forecast_updated_at":"2022-12-30 11:42:52.613464+08","end_at":"2022-12-30 14:15:29","pinyin_shortcut":"ypxg20221230","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"profits":"353.952000000000000000","remain":"918 days 00:41:10.884701","progress_remain":"918 days 02:26:39.041038","forecast_remain":"918 days 02:26:39.041038","lost_contact_days":"917.756616371551","last_contact":"2022-12-30 20:00:00","last_arrive_days":"","last_arrive":"","duration":"02:32:36.684099","issued_invoices":"1440.00","client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":5311,"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":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3074,"value":"1","engineer_id":1015,"key":1015,"name":"\u5434\u660a","engineer":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}}}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"1440.00","pct":"24.58","profit":"353.952","project_id":3074}],"salesForecast":{"id":178,"key":178,"name":"90%"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"schedules":[],"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":2536,"from_project":3074,"payment_collection_remind_ahead":"00:00:00","salesContractPayments":[{"id":1461,"key":1461,"contract_id":2536,"value":"1440"}],"salesContractInvoices":[{"id":1352,"key":1352,"contract_id":2536,"value":"1440.00","attachment_id":"","from_date":"2023-03-01","attachment":{}}],"salesContractPaymentCollectionRemindDates":[]},"projectRemindReceivers":[{"id":361,"user_id":1001,"key":1001,"project_id":3074,"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"}}}],"commentCount":{"object_id":3074,"comment":3},"unreadComments":{},"lost_contact_days_display":"2\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":918,"progress_remain_display":918,"forecast_remain_display":918,"duration_display":1,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"1440"},{"id":2976,"client_id":1152,"project_status":3,"project_progress":10,"budget":"29997","profit_pct":"12.49","bargain_date":"2022-10-18","description":"\u6df1\u4fe1\u670d\u7eed\u4fdd","created_by":5329,"created_at":"2022-09-07 16:11:20","updated_at":"2022-10-27 10:23:28","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u8bbe\u5907\u7eed\u4fdd2022\u5e74","collected":"29997","status_updated_at":"2022-10-24 15:44:43.547307+08","success_rate":"","comment":"\u6df1\u4fe1\u670d\u7eed\u4fdd\r\n\u6700\u7ec8\u7528\u6237\uff1a\u4e2d\u6cb9\u56fd\u9645\uff08\u5c3c\u65e5\u5c14\uff09\u6709\u9650\u8d23\u4efb\u516c\u53f8","contract_type":2,"progress_updated_at":"2022-10-24 15:41:32.810912+08","forecast_updated_at":"2022-10-08 16:31:00.891495+08","end_at":"2022-10-26 11:34:12","pinyin_shortcut":"sxfsbxb2022n","creator":5329,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":29997,"profits":"3746.625300000000000000","remain":"984 days 22:24:48.107195","progress_remain":"984 days 22:27:58.84359","forecast_remain":"1000 days 21:38:30.763007","lost_contact_days":"983.030921927107","last_contact":"2022-10-26 13:25:00","last_arrive_days":"","last_arrive":"","duration":"48 days 19:22:51.809108","issued_invoices":"29997.00","client":{"id":1152,"key":1152,"name":"\u5317\u4eac\u6c49\u672c\u8f6f\u4ef6\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":2,"client_class":43,"client_industry":13,"sales_rep":"","clientType":{"id":2,"key":2,"name":"\u7cfb\u7edf\u96c6\u6210\u5546"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":"","contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"29997.00","pct":"12.49","profit":"3746.6253","project_id":2976}],"salesForecast":{"id":178,"key":178,"name":"90%"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"schedules":[],"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"salesRep":{},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":2448,"from_project":2976,"payment_collection_remind_ahead":"00:00:00","salesContractPayments":[{"id":1416,"key":1416,"contract_id":2448,"value":"29997"}],"salesContractInvoices":[{"id":1295,"key":1295,"contract_id":2448,"value":"29997.00","attachment_id":"","from_date":"2022-10-27","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":1061,"key":1061,"contract_id":2448,"name":"2022-10-19","value":"29997","overdue_days":0}]},"projectRemindReceivers":[{"id":268,"user_id":1005,"key":1005,"project_id":2976,"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"}}}],"commentCount":{"object_id":2976,"comment":4},"unreadComments":{},"lost_contact_days_display":"2\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":984,"progress_remain_display":984,"forecast_remain_display":1000,"duration_display":48,"last_arrive_days_display":"","contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"budget_display":"3\u4e07"},{"id":2855,"client_id":2021,"project_status":3,"project_progress":7,"budget":"600","profit_pct":"47.3","bargain_date":"2022-05-30","description":" \u786c\u76d8\tHP DL380PGEN8 SAS300GB 10K\uff08653955\uff09 1\u5757","created_by":5300,"created_at":"2022-05-25 14:22:28","updated_at":"2022-07-19 11:49:37","engineer_id":"","project_title":"\u786c\u76d820220525","collected":"600","status_updated_at":"2022-06-06 10:07:59.439906+08","success_rate":"","comment":" \u786c\u76d8\tHP DL380PGEN8 SAS300GB 10K\uff08653955\uff09 1\u5757\r\n\u786c\u76d8\tHP DL380PGEN8 SAS300GB 10K\uff08653955\uff09 1\u5757","contract_type":1,"progress_updated_at":"2022-05-25 14:22:28.500888+08","forecast_updated_at":"2022-05-25 14:22:28.500888+08","end_at":"2022-06-06 11:57:12","pinyin_shortcut":"yp20220525","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"profits":"283.80000000000000000","remain":"1125 days 04:01:32.214596","progress_remain":"1136 days 23:47:03.153614","forecast_remain":"1136 days 23:47:03.153614","lost_contact_days":"1130.58994970488","last_contact":"2022-06-01 00:00:00","last_arrive_days":"","last_arrive":"","duration":"11 days 21:34:44.343944","issued_invoices":"600.00","client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":5311,"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":"","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":7,"key":7,"name":"\u8fbe\u6210\u610f\u5411"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"600.00","pct":"47.3","profit":"283.8","project_id":2855}],"salesForecast":{"id":175,"key":175,"name":"100%"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"schedules":[],"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":2270,"from_project":2855,"payment_collection_remind_ahead":"00:00:00","salesContractPayments":[{"id":1323,"key":1323,"contract_id":2270,"value":"600"}],"salesContractInvoices":[{"id":1202,"key":1202,"contract_id":2270,"value":"600.00","attachment_id":"","from_date":"2022-06-06","attachment":{}}],"salesContractPaymentCollectionRemindDates":[]},"projectRemindReceivers":[{"id":46,"user_id":1001,"key":1001,"project_id":2855,"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"}}}],"commentCount":{"object_id":2855,"comment":3},"unreadComments":{},"lost_contact_days_display":"3\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":1125,"progress_remain_display":1136,"forecast_remain_display":1136,"duration_display":11,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"600"},{"id":2830,"client_id":2021,"project_status":3,"project_progress":10,"budget":"600","profit_pct":"47.3","bargain_date":"2022-04-20","description":"\u786c\u76d8\tHP DL380PGEN8 SAS300GB 10K\uff08653955\uff091\u5757","created_by":5300,"created_at":"2022-04-21 18:27:14","updated_at":"2024-01-18 14:24:13","engineer_id":"","project_title":"\u786c\u76d820220420","collected":"600","status_updated_at":"2022-04-21 18:28:21.954009+08","success_rate":"","comment":"\u786c\u76d8\tHP DL380PGEN8 SAS300GB 10K\uff08653955\uff091\u5757\r\n\u786c\u76d8\tHP DL380PGEN8 SAS300GB 10K\uff08653955\uff09 1\u5757","contract_type":1,"progress_updated_at":"2022-04-21 18:27:14.320618+08","forecast_updated_at":"2022-04-21 18:27:14.320618+08","end_at":"2022-04-22 10:30:12","pinyin_shortcut":"yp20220420","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"profits":"283.80000000000000000","remain":"1170 days 19:41:09.700493","progress_remain":"1170 days 19:42:17.333884","forecast_remain":"1170 days 19:42:17.333884","lost_contact_days":"1166.58994970488","last_contact":"2022-04-26 00:00:00","last_arrive_days":"","last_arrive":"","duration":"16:02:58.41647","issued_invoices":"600.00","client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":5311,"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":"","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":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"600.00","pct":"47.3","profit":"283.8","project_id":2830}],"salesForecast":{"id":175,"key":175,"name":"100%"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"schedules":[],"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":2247,"from_project":2830,"payment_collection_remind_ahead":"00:00:00","salesContractPayments":[{"id":1318,"key":1318,"contract_id":2247,"value":"600"}],"salesContractInvoices":[{"id":1194,"key":1194,"contract_id":2247,"value":"600.00","attachment_id":"","from_date":"2022-04-20","attachment":{}}],"salesContractPaymentCollectionRemindDates":[]},"projectRemindReceivers":[],"commentCount":{"object_id":2830,"comment":1},"unreadComments":{},"lost_contact_days_display":"3\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":1170,"progress_remain_display":1170,"forecast_remain_display":1170,"duration_display":1,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"600"},{"id":2612,"client_id":2099,"project_status":3,"project_progress":1,"budget":"19210","profit_pct":"13.44","bargain_date":"2021-09-08","description":"Dell PowerVault MD1200 \u78c1\u76d8\u67dc\u7535\u6e90\nDS1621+ 6\u76d8\u4f4dNAS","created_by":5299,"created_at":"2021-07-26 17:25:20","updated_at":"2022-04-28 16:08:25","engineer_id":"","project_title":"\u5b58\u50a8\u670d\u52a1\u5668\u53ca\u914d\u4ef6","collected":"19210","status_updated_at":"2021-09-14 11:18:10.594213+08","success_rate":"","comment":"Dell PowerVault MD1200 \u78c1\u76d8\u67dc\u7535\u6e90\nDS1621+ 6\u76d8\u4f4dNAS\r\n\u51b3\u7b56\u6d41\u7a0b\uff1a\u6280\u672f\u90e8\u63d0\u4ea4\u65b9\u6848--\u9886\u5bfc\u5ba1\u6279--\u91c7\u8d2d\n\u89e3\u51b3\u4ec0\u4e48\u95ee\u9898\uff1a\u6570\u636e\u5b89\u5168\n\u7ade\u4e89\u5bf9\u624b\uff1a","contract_type":1,"progress_updated_at":"2021-07-26 17:25:20.255363+08","forecast_updated_at":"2021-09-14 11:17:45.433099+08","end_at":"2021-10-27 15:40:00","pinyin_shortcut":"ccfwqjpj","creator":5299,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"profits":"2581.824000000000000000","remain":"1390 days 02:51:21.060289","progress_remain":"1439 days 20:44:11.399139","forecast_remain":"1390 days 02:51:46.221403","lost_contact_days":"1376.08994970488","last_contact":"2021-09-28 12:00:00","last_arrive_days":"1439.04760016785","last_arrive":"2021-07-27 13:00:59+08","duration":"92 days 22:14:40.05708","issued_invoices":"19210.00","client":{"id":2099,"key":2099,"name":"\u5317\u4eac\u4e2d\u5143\u745e\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":43,"client_industry":13,"sales_rep":5311,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":2612,"value":"1","engineer_id":1023,"key":1023,"name":"\u5468\u5b50\u5065","engineer":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"}}}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":1,"key":1,"name":"\u521d\u76f8\u8bc6"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"19210.00","pct":"13.44","profit":"2581.824","project_id":2612}],"salesForecast":{"id":178,"key":178,"name":"90%"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"schedules":[],"createdBy":{"id":5299,"key":5299,"name":"\u4f55\u806a","sex":"M","department_id":1,"avatar":{"id":139,"user_id":5299,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a99798df-3541-322a-a63b-2f6c43e4dfb9.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5299,"key":5299,"name":"\u4f55\u806a","sex":"M","department_id":1,"avatar":{"id":139,"user_id":5299,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a99798df-3541-322a-a63b-2f6c43e4dfb9.jpg"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesTimeCount":{"project_id":2612,"hours":"2.82916666666667","times":1},"implementTimeCount":{"project_id":2612,"sum":"5.2","times":"3"},"presalesTimeCount":{"project_id":2612,"sum":"4.59888888888889","times":"1"},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":2612,"sum":"438.53"},"buildContract":{"id":2086,"from_project":2612,"payment_collection_remind_ahead":"15 days","salesContractPayments":[{"id":1242,"key":1242,"contract_id":2086,"value":"19210"}],"salesContractInvoices":[{"id":1120,"key":1120,"contract_id":2086,"value":"19210.00","attachment_id":8470,"from_date":"2021-09-13","attachment":{"id":8470,"key":8470,"name":"87ee287f-1d40-3f9c-b053-174244d9dee8","extension":"pdf","path":"\/vue\/attachment\/preview\/87ee287f-1d40-3f9c-b053-174244d9dee8\/\u4e2d\u5143\u745e\u8baf\u53d1\u7968.pdf","orig_name":"\u4e2d\u5143\u745e\u8baf\u53d1\u7968.pdf"}}],"salesContractPaymentCollectionRemindDates":[]},"projectRemindReceivers":[],"commentCount":{"object_id":2612,"comment":1},"unreadComments":{},"lost_contact_days_display":"3\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":1390,"progress_remain_display":1439,"forecast_remain_display":1390,"duration_display":92,"last_arrive_days_display":"3\u5e74\u524d","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"1.92\u4e07"},{"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":"","project_title":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee","collected":"514761.00","status_updated_at":"2020-08-10 17:52:12.720678+08","success_rate":"","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":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":514761,"profits":"2882.661600000000000000","remain":"1789 days 20:17:18.933824","progress_remain":"989 days 15:02:56.258571","forecast_remain":"1537 days 15:43:52.866643","lost_contact_days":"1393.11147748266","last_contact":"2021-09-11 11:29:00","last_arrive_days":"","last_arrive":"","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":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"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":"","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"},"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%"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"schedules":[],"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"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{"project_id":1791,"hours":"0","times":1},"reimbursementAmountSum":{},"buildContract":{"id":1558,"from_project":1791,"payment_collection_remind_ahead":"1 day","salesContractPayments":[{"id":909,"key":909,"contract_id":1558,"value":"514761.00"}],"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":"\/vue\/attachment\/preview\/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":""}]},"projectRemindReceivers":[],"commentCount":{"object_id":1791,"comment":1},"unreadComments":{},"lost_contact_days_display":"3\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":1789,"progress_remain_display":989,"forecast_remain_display":1537,"duration_display":1749,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"51.48\u4e07"},{"id":2423,"client_id":1641,"project_status":3,"project_progress":2,"budget":"78900","profit_pct":"15.63","bargain_date":"2021-03-03","description":"PA820\u4e00\u53f0\u3001TP\u3001URL\u6388\u6743\uff0c\u4e09\u5e74\u670d\u52a1\n\u6700\u7ec8\u5ba2\u6237\uff1a\u5317\u4eac\u5b89\u5fb7\u533b\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u548c\u5317\u4eac\u6e90\u5174\u667a\u6cfd\u79d1\u6280\u6709\u9650\u516c\u53f8\u662f\u4e00\u5bb6\uff09","created_by":5096,"created_at":"2021-03-03 12:19:46","updated_at":"2021-08-19 15:31:07","engineer_id":"","project_title":"PA820","collected":"78900.00","status_updated_at":"2021-03-05 15:53:38.461869+08","success_rate":"","comment":"PA820\u4e00\u53f0\u3001TP\u3001URL\u6388\u6743\uff0c\u4e09\u5e74\u670d\u52a1\n\u6700\u7ec8\u5ba2\u6237\uff1a\u5317\u4eac\u5b89\u5fb7\u533b\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u548c\u5317\u4eac\u6e90\u5174\u667a\u6cfd\u79d1\u6280\u6709\u9650\u516c\u53f8\u662f\u4e00\u5bb6\uff09\r\n","contract_type":1,"progress_updated_at":"2021-04-12 17:30:52.923949+08","forecast_updated_at":"2021-04-12 17:30:52.923949+08","end_at":"2021-08-19 15:31:07","pinyin_shortcut":"PA820","creator":5096,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"profits":"12332.070000000000000000","remain":"1582 days 22:15:53.192633","progress_remain":"1544 days 20:38:38.730553","forecast_remain":"1544 days 20:38:38.730553","lost_contact_days":"1518.94411637155","last_contact":"2021-05-08 15:30:00","last_arrive_days":"","last_arrive":"","duration":"169 days 03:11:21.634733","issued_invoices":"78900.00","client":{"id":1641,"key":1641,"name":"\u5317\u4eac\u5b89\u817e\u601d\u8def\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","logo":"","client_type":2,"client_class":"","client_industry":13,"sales_rep":5311,"clientType":{"id":2,"key":2,"name":"\u7cfb\u7edf\u96c6\u6210\u5546"},"clientClass":{},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":2423,"value":"1","engineer_id":1022,"key":1022,"name":"\u5f90\u7855","engineer":{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","department_id":2,"avatar":{"id":6,"user_id":1022,"name":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"}}}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"78900","pct":"15.63","profit":"12332.07","project_id":2423}],"salesForecast":{"id":174,"key":174,"name":"80%"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"schedules":[],"createdBy":{"id":5096,"key":5096,"name":"\u674e\u6c5f\u661f","sex":"F","department_id":1,"avatar":{"id":55,"user_id":5096,"name":"\/files\/cdn\/a57be577deb434\/avatar\/dfb8e15a-c62e-3531-a805-e436f46176e6.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5096,"key":5096,"name":"\u674e\u6c5f\u661f","sex":"F","department_id":1,"avatar":{"id":55,"user_id":5096,"name":"\/files\/cdn\/a57be577deb434\/avatar\/dfb8e15a-c62e-3531-a805-e436f46176e6.jpg"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesTimeCount":{},"implementTimeCount":{"project_id":2423,"sum":"5.73333333333333","times":"3"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":2423,"sum":"358"},"buildContract":{"id":1875,"from_project":2423,"payment_collection_remind_ahead":"00:00:00","salesContractPayments":[{"id":1074,"key":1074,"contract_id":1875,"value":"23670.00"},{"id":1148,"key":1148,"contract_id":1875,"value":"55230.00"}],"salesContractInvoices":[{"id":1039,"key":1039,"contract_id":1875,"value":"78900.00","attachment_id":7218,"from_date":"2021-04-07","attachment":{"id":7218,"key":7218,"name":"e3d07846-97e8-337f-96c2-04159a058667","extension":"pdf","path":"\/vue\/attachment\/preview\/e3d07846-97e8-337f-96c2-04159a058667\/2021_04_07_14_39_31.pdf","orig_name":"2021_04_07_14_39_31.pdf"}}],"salesContractPaymentCollectionRemindDates":[]},"projectRemindReceivers":[],"commentCount":{"object_id":2423,"comment":1},"unreadComments":{},"lost_contact_days_display":"4\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":1582,"progress_remain_display":1544,"forecast_remain_display":1544,"duration_display":169,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"7.89\u4e07"},{"id":1736,"client_id":1638,"project_status":3,"project_progress":10,"budget":"808973.80","profit_pct":"1","bargain_date":"2020-03-25","description":"1.\u706b\u773c2500NX1-HW*1\u5957\n2.\u706b\u773c3500EX-HW*1\u5957\n3.\u706b\u773c4502HX-HW*1\u5957\n4.\u706b\u773c4500CM-HW*1\u5957","created_by":1001,"created_at":"2020-03-30 11:25:30","updated_at":"2021-05-08 13:51:17","engineer_id":"","project_title":"FireEye\u5b89\u5168\u9879\u76ee","collected":"808973.80","status_updated_at":"2020-06-03 17:01:27.977117+08","success_rate":"","comment":"1.\u706b\u773c2500NX1-HW*1\u5957\n2.\u706b\u773c3500EX-HW*1\u5957\n3.\u706b\u773c4502HX-HW*1\u5957\n4.\u706b\u773c4500CM-HW*1\u5957\r\n","contract_type":1,"progress_updated_at":"2021-04-07 19:42:41.722056+08","forecast_updated_at":"2021-04-19 22:26:19.042049+08","end_at":"2021-05-08 13:51:17","pinyin_shortcut":"FireEyeaqxm","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":808973.8,"profits":"8089.7380000000000000","remain":"1857 days 21:08:03.677385","progress_remain":"1549 days 18:26:49.932446","forecast_remain":"1537 days 15:43:12.612453","lost_contact_days":"1551.56911637155","last_contact":"2021-04-06 00:30:00","last_arrive_days":"","last_arrive":"","duration":"404 days 02:25:47.181108","issued_invoices":"808973.80","client":{"id":1638,"key":1638,"name":"\u4e0a\u6d77\u5353\u5b9c\u901a\u4fe1\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":"","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":"","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":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"808973.80","pct":"1","profit":"8089.738","project_id":1736}],"salesForecast":{"id":175,"key":175,"name":"100%"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"schedules":[],"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":{},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":1424,"from_project":1736,"payment_collection_remind_ahead":"1 day","salesContractPayments":[{"id":77,"key":77,"contract_id":1424,"value":"308973.80"},{"id":707,"key":707,"contract_id":1424,"value":"500000.00"}],"salesContractInvoices":[{"id":674,"key":674,"contract_id":1424,"value":"808973.80","attachment_id":5223,"from_date":"2020-05-15","attachment":{"id":5223,"key":5223,"name":"9401d7ca-97f3-3796-9e32-b35b8abe2256","extension":"pdf","path":"\/vue\/attachment\/preview\/9401d7ca-97f3-3796-9e32-b35b8abe2256\/2020_06_23_17_57_57.pdf","orig_name":"2020_06_23_17_57_57.pdf"}}],"salesContractPaymentCollectionRemindDates":[{"id":887,"key":887,"contract_id":1424,"name":"2020-06-30","value":"808973.80","overdue_days":""}]},"projectRemindReceivers":[],"commentCount":{"object_id":1736,"comment":3},"unreadComments":{},"lost_contact_days_display":"4\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":1857,"progress_remain_display":1549,"forecast_remain_display":1537,"duration_display":404,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"budget_display":"80.9\u4e07"},{"id":1942,"client_id":1936,"project_status":3,"project_progress":10,"budget":"13400","profit_pct":"1.97","bargain_date":"2020-10-29","description":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\n","created_by":1005,"created_at":"2020-10-18 11:30:26","updated_at":"2021-09-28 15:09:42","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u9632\u706b\u5899)","collected":"13400.00","status_updated_at":"2020-11-10 11:34:34.611268+08","success_rate":"","comment":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\n\r\n","contract_type":1,"progress_updated_at":"2021-01-04 17:00:06.070304+08","forecast_updated_at":"2021-01-04 17:00:06.070304+08","end_at":"2021-01-04 17:00:06","pinyin_shortcut":"sxffhq","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":13400,"profits":"263.980000000000000000","remain":"1698 days 02:34:57.043234","progress_remain":"1642 days 21:09:25.584198","forecast_remain":"1642 days 21:09:25.584198","lost_contact_days":"1722.91633859377","last_contact":"2020-10-16 16:10:00","last_arrive_days":"","last_arrive":"","duration":"78 days 05:29:39.849018","issued_invoices":"13400.00","client":{"id":1936,"key":1936,"name":"\u5317\u4eac\u5723\u5b89\u4f2f\u7cfb\u7edf\u96c6\u6210\u6709\u9650\u516c\u53f8-\u96c6\u6210\u5546","logo":"","client_type":2,"client_class":43,"client_industry":13,"sales_rep":"","clientType":{"id":2,"key":2,"name":"\u7cfb\u7edf\u96c6\u6210\u5546"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":"","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":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"13400.00","pct":"1.97","profit":"263.98","project_id":1942}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{"id":131,"key":131,"name":"\u5e7f\u544a\u63a8\u5e7f"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"schedules":[],"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":1733,"from_project":1942,"payment_collection_remind_ahead":"1 day","salesContractPayments":[{"id":986,"key":986,"contract_id":1733,"value":"13400.00"}],"salesContractInvoices":[{"id":921,"key":921,"contract_id":1733,"value":"13400.00","attachment_id":6137,"from_date":"2020-11-03","attachment":{"id":6137,"key":6137,"name":"f8802aa4-9e81-387c-822d-30816c3120f6","extension":"pdf","path":"\/vue\/attachment\/preview\/f8802aa4-9e81-387c-822d-30816c3120f6\/\u5723\u5b89\u4f2f\u53d1\u7968.pdf","orig_name":"\u5723\u5b89\u4f2f\u53d1\u7968.pdf"}}],"salesContractPaymentCollectionRemindDates":[{"id":705,"key":705,"contract_id":1733,"name":"2020-11-10","value":"13400.00","overdue_days":0}]},"projectRemindReceivers":[],"commentCount":{"object_id":1942,"comment":1},"unreadComments":{},"lost_contact_days_display":"4\u5e74\u524d","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":1698,"progress_remain_display":1642,"forecast_remain_display":1642,"duration_display":78,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"budget_display":"1.34\u4e07"},{"id":1741,"client_id":1640,"project_status":3,"project_progress":10,"budget":"643000","profit_pct":"12.33","bargain_date":"2020-05-11","description":"1.X3650 \u91d1\u724c5220*1\/2\/512BM\/600*2 5\u53f0\n2.FAS2750 960*4\u52a01.8*24 1\u53f0\n3.IBM B24\u6a21\u5757 16\u4e2a\n4.\u7fa4\u6656 10TB NSA 1\u53f0\n5.\u62d3\u5b9e\u79d1\u6280\u8fc1\u79fb\u670d\u52a1\u52a0\u7ef4\u4fdd\u670d\u52a1\u4e00\u5e74\u3002","created_by":1003,"created_at":"2020-04-05 21:49:09","updated_at":"2024-02-01 11:17:51","engineer_id":"","project_title":"\u4e2d\u90fd\u7269\u6d41\u6570\u636e\u4e2d\u5fc3\u9879\u76ee","collected":"643000.00","status_updated_at":"2020-12-16 17:44:17.653583+08","success_rate":"","comment":"1.X3650 \u91d1\u724c5220*1\/2\/512BM\/600*2 5\u53f0\n2.FAS2750 960*4\u52a01.8*24 1\u53f0\n3.IBM B24\u6a21\u5757 16\u4e2a\n4.\u7fa4\u6656 10TB NSA 1\u53f0\n5.\u62d3\u5b9e\u79d1\u6280\u8fc1\u79fb\u670d\u52a1\u52a0\u7ef4\u4fdd\u670d\u52a1\u4e00\u5e74\u3002\r\n1. \u5ba2\u6237\u5173\u6ce8\u70b9\uff1a\u4e1a\u52a1\u7cfb\u7edf\u9ad8\u53ef\u7528\uff0c\u652f\u6301\u4e1a\u52a1\u7684\u81ea\u52a8\u8fc1\u79fb \n2. \u8d62\u5355\u5173\u952e\u6761\u4ef6\uff1a\u6700\u4f18\u7684\u6280\u672f\u65b9\u6848\uff0c\u5408\u7406\u7684\u4ef7\u683c \n3. \u9879\u76ee\u89e3\u51b3\u7684\u95ee\u9898\uff1a\u73b0\u6709\u6570\u636e\u4e2d\u5fc3\u7684\u9ad8\u53ef\u7528\uff0c\u6027\u80fd\u53ef\u4ee5\u652f\u6301\u670d\u52a1\u5668\u5b95\u673a\u540e\u53ef\u4ee5\u8fc1\u79fb\uff0c\u7a33\u5b9a\u8fd0\u884c \n4. \u5ba2\u6237\u503e\u5411\u7684\u65b9\u6848\u662f\uff1a\u5ba2\u6237\u81ea\u9009\uff1f\u6211\u4eec\u63a8\u8350\uff1f\u7ade\u4e89\u5bf9\u624b\u65b9\u6848\uff1f\u6211\u4eec\u63a8\u8350 \n5. \u7ade\u4e89\u5bf9\u624b\u7684\u65b9\u6848\uff1a\u7531\u6211\u4eec\u56f4\u6807\u63d0\u4f9b\u5bf9\u6bd4\u65b9\u6848 \n6. \u662f\u5426\u6709\u9886\u8def\u4eba\uff1a\u6709 \n7. \u5ba2\u6237\u5173\u952e\u4eba\u662f\u5426\u652f\u6301\u6211\u4eec\uff1a\u652f\u6301 \n8. \u5382\u5546\u662f\u5426\u652f\u6301\u6211\u4eec\uff1a\u4e0d\u9700\u8981\u5382\u5546 \n9. \u5408\u4f5c\u65b9\u5f0f\uff1a\u5ba2\u6237\u6346\u7ed1\uff1f\u5382\u5546\u6346\u7ed1\uff1f\u8ddf\u5ba2\u6237\u6346\u7ed1\u3002 \n10. \u4ed8\u6b3e\u65b9\u5f0f\uff1a30\u5929 \n11. \u51b3\u7b56\u6d41\u7a0b\uff1a\u6280\u672f\u90e8\u51b3\u5b9a\u6280\u672f\u65b9\u6848\u548c\u7ecf\u9500\u5546\u3002 \n12. \u6211\u7684\u95ee\u9898\uff1a\u6682\u65e0","contract_type":1,"progress_updated_at":"2020-12-16 17:44:17.653583+08","forecast_updated_at":"2020-12-16 17:44:17.653583+08","end_at":"2020-12-16 17:44:17","pinyin_shortcut":"zdwlsjzxxm","creator":1003,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":64300,"profits":"79281.900000000000000000","remain":"1661 days 20:25:14.000919","progress_remain":"1661 days 20:25:14.000919","forecast_remain":"1661 days 20:25:14.000919","lost_contact_days":"1779.82953303822","last_contact":"2020-08-20 18:15:00","last_arrive_days":"","last_arrive":"","duration":"254 days 19:55:07.991092","issued_invoices":"1929000","client":{"id":1640,"key":1640,"name":"\u5317\u6c7d\u84dd\u8c37\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":43,"client_industry":13,"sales_rep":5329,"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":13,"key":13,"name":"SI\/ISV"}},"usedClient":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":1741,"value":"1","engineer_id":1016,"key":1016,"name":"\u8346\u626c","engineer":{"id":1016,"key":1016,"name":"\u8346\u626c","sex":"M","department_id":2,"avatar":{"id":9,"user_id":1016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f8c4e875-66be-3d04-849b-eef73fa66ebc.png"}}}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"4560.00","pct":"12","profit":"547.2","project_id":1741},{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"295490.00","pct":"12","profit":"35458.8","project_id":1741},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"46550.00","pct":"12","profit":"5586","project_id":1741},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"296400.00","pct":"12","profit":"35568","project_id":1741}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{"id":132,"key":132,"name":"\u5ba2\u6237\u4ecb\u7ecd"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"schedules":[],"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}},"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":1741,"sum":"360.4"},"buildContract":{"id":1502,"from_project":1741,"payment_collection_remind_ahead":"1 day","salesContractPayments":[{"id":885,"key":885,"contract_id":1502,"value":"192900.00"},{"id":965,"key":965,"contract_id":1502,"value":"385800.00"},{"id":1013,"key":1013,"contract_id":1502,"value":"64300.00"}],"salesContractInvoices":[{"id":12,"key":12,"contract_id":1502,"value":"192900.00","attachment_id":5135,"from_date":"2020-06-09","attachment":{"id":5135,"key":5135,"name":"2757f271-77b8-356c-bccb-f3c113215f62","extension":"pdf","path":"\/vue\/attachment\/preview\/2757f271-77b8-356c-bccb-f3c113215f62\/2020_06_22_13_56_36.pdf","orig_name":"2020_06_22_13_56_36.pdf"}},{"id":840,"key":840,"contract_id":1502,"value":"385800.00","attachment_id":5265,"from_date":"2020-06-28","attachment":{"id":5265,"key":5265,"name":"85318584-680e-3414-accd-e357f8a25bf8","extension":"pdf","path":"\/vue\/attachment\/preview\/85318584-680e-3414-accd-e357f8a25bf8\/2020_06_28_14_40_41.pdf","orig_name":"2020_06_28_14_40_41.pdf"}},{"id":842,"key":842,"contract_id":1502,"value":"64300.00","attachment_id":5280,"from_date":"2020-06-29","attachment":{"id":5280,"key":5280,"name":"76488510-7dcc-3e24-ab75-a3733616cf22","extension":"pdf","path":"\/vue\/attachment\/preview\/76488510-7dcc-3e24-ab75-a3733616cf22\/2020_06_29_15_41_21.pdf","orig_name":"2020_06_29_15_41_21.pdf"}}],"salesContractPaymentCollectionRemindDates":[{"id":648,"key":648,"contract_id":1502,"name":"2020-10-30","value":"64300.00","overdue_days":47}]},"projectRemindReceivers":[],"commentCount":{"object_id":1741,"comment":4},"unreadComments":{},"lost_contact_days_display":"4\u5e74\u524d","unissued_invoice":-1286000,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":1661,"progress_remain_display":1661,"forecast_remain_display":1661,"duration_display":254,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"64.3\u4e07"},{"id":3809,"client_id":3304,"project_status":3,"project_progress":9,"budget":"1","profit_pct":"100","bargain_date":"2025-06-11","description":"","created_by":1001,"created_at":"2025-06-11 10:59:46","updated_at":"2025-06-27 14:39:02","engineer_id":"","project_title":"\u6d4b\u8bd5\u9ed8\u8ba4\u9009\u4e2d\u660e\u786e\u9700\u6c42","collected":"0","status_updated_at":"2025-06-11 11:06:41.464262+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-11 10:59:46.429638+08","forecast_updated_at":"2025-06-11 11:10:21.558113+08","end_at":"2025-06-11 11:10:21","pinyin_shortcut":"csmrxzmqxq","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":3000,"profits":"1.00000000000000000000","remain":"24 days 03:02:50.19024","progress_remain":"24 days 03:09:45.224864","forecast_remain":"24 days 02:59:10.096389","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"00:10:35.128475","issued_invoices":"","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"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":"","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"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"1","pct":"100","profit":"1","project_id":3809}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"schedules":[],"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"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3843,"from_project":3809,"payment_collection_remind_ahead":"1 day","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2382,"key":2382,"contract_id":3843,"name":"2025-06-11","value":"3000","overdue_days":""}]},"projectRemindReceivers":[{"id":1537,"user_id":1001,"key":1001,"project_id":3809,"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"}}}],"commentCount":{"object_id":3809,"comment":2},"unreadComments":{},"lost_contact_days_display":"","unissued_invoice":1,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":24,"progress_remain_display":24,"forecast_remain_display":24,"duration_display":1,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"1"},{"id":3808,"client_id":3304,"project_status":3,"project_progress":9,"budget":"0","profit_pct":"0","bargain_date":"2025-06-10","description":"","created_by":1001,"created_at":"2025-06-10 16:16:48","updated_at":"2025-06-11 11:03:55","engineer_id":"","project_title":"\u7684\u662f\u5426\u5730\u65b9\u6492","collected":"0","status_updated_at":"2025-06-10 16:16:48.920685+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-10 16:16:48.920685+08","forecast_updated_at":"2025-06-11 11:03:55.947909+08","end_at":"2025-06-11 11:03:55","pinyin_shortcut":"dsfdfs","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":811,"is_sales_order_ready":false,"collected_plan":2000,"profits":"0.00000000000000000000","remain":"24 days 21:52:42.733817","progress_remain":"24 days 21:52:42.733817","forecast_remain":"24 days 03:05:35.706593","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"18:47:07.027224","issued_invoices":"","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"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":"","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"},"projectProductTypes":[],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"schedules":[],"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"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3841,"from_project":3808,"payment_collection_remind_ahead":"1 day","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2378,"key":2378,"contract_id":3841,"name":"2025-06-11","value":"2000","overdue_days":""}]},"projectRemindReceivers":[{"id":1533,"user_id":1001,"key":1001,"project_id":3808,"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"}}}],"commentCount":{"object_id":3808,"comment":1},"unreadComments":{},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":24,"progress_remain_display":24,"forecast_remain_display":24,"duration_display":1,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"0"},{"id":3807,"client_id":3304,"project_status":3,"project_progress":9,"budget":"34000","profit_pct":"80","bargain_date":"2025-06-09","description":"","created_by":1001,"created_at":"2025-06-09 17:25:30","updated_at":"2025-06-11 11:23:11","engineer_id":"","project_title":"\u6d4b\u8bd5 \u4f3c\u61c2\u975e\u61c2\u8212\u670d\u8303\u5fb7\u8428\u4e0a","collected":"34000","status_updated_at":"2025-06-09 17:26:40.485552+08","success_rate":"","comment":"\u7ed9\u5927\u59d1","contract_type":1,"progress_updated_at":"2025-06-09 17:25:30.577264+08","forecast_updated_at":"2025-06-09 17:25:30.577264+08","end_at":"2025-06-09 18:05:34","pinyin_shortcut":"cssdfdsffdss","creator":1001,"used_client":"","from_contact":6006,"total_contact_point":"","paid_contact_point":"","project_product_version_id":812,"is_sales_order_ready":false,"collected_plan":4222,"profits":"27200.0000000000000000","remain":"25 days 20:42:51.16895","progress_remain":"25 days 20:44:01.077238","forecast_remain":"25 days 20:44:01.077238","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"00:40:04.063371","issued_invoices":"","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"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":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3807,"value":"1","engineer_id":1017,"key":1017,"name":"\u8f66\u660e\u98de","engineer":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","department_id":2,"avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"34000","pct":"80","profit":"27200","project_id":3807}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"schedules":[],"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"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3840,"from_project":3807,"payment_collection_remind_ahead":"2 days","salesContractPayments":[{"id":2162,"key":2162,"contract_id":3840,"value":"34000"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2398,"key":2398,"contract_id":3840,"name":"2025-06-11","value":"222","overdue_days":""},{"id":2399,"key":2399,"contract_id":3840,"name":"2025-06-12","value":"4000","overdue_days":""}]},"projectRemindReceivers":[{"id":1532,"user_id":1001,"key":1001,"project_id":3807,"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"}}}],"commentCount":{"object_id":3807,"comment":3},"unreadComments":{},"lost_contact_days_display":"","unissued_invoice":34000,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":25,"progress_remain_display":25,"forecast_remain_display":25,"duration_display":1,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"3.4\u4e07"},{"id":3801,"client_id":3278,"project_status":3,"project_progress":9,"budget":"8000","profit_pct":"93.75","bargain_date":"2025-04-09","description":"\u6d4b\u8bd5","created_by":1001,"created_at":"2025-04-09 16:16:54","updated_at":"2025-06-11 15:29:06","engineer_id":"","project_title":"\u8d1f\u6570\u95ee\u9898","collected":"1","status_updated_at":"2025-06-11 11:14:46.224284+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-04-09 16:16:54.248165+08","forecast_updated_at":"2025-06-11 15:25:07.922296+08","end_at":"","pinyin_shortcut":"fswt","creator":1001,"used_client":"","from_contact":5934,"total_contact_point":"","paid_contact_point":"","project_product_version_id":808,"is_sales_order_ready":false,"collected_plan":8000,"profits":"7500.000000000000000000","remain":"24 days 02:54:45.430218","progress_remain":"86 days 21:52:37.406337","forecast_remain":"23 days 22:44:23.732206","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"86 days 21:52:37.406337","issued_invoices":"","client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"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":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3801,"value":"1","engineer_id":1017,"key":1017,"name":"\u8f66\u660e\u98de","engineer":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","department_id":2,"avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"8000","pct":"93.75","profit":"7500","project_id":3801}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"schedules":[],"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"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3844,"from_project":3801,"payment_collection_remind_ahead":"","salesContractPayments":[{"id":2163,"key":2163,"contract_id":3844,"value":"1"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2426,"key":2426,"contract_id":3844,"name":"2025-06-11","value":"4000","overdue_days":""},{"id":2427,"key":2427,"contract_id":3844,"name":"2025-06-19","value":"3000","overdue_days":""},{"id":2428,"key":2428,"contract_id":3844,"name":"2025-06-20","value":"1000","overdue_days":""}]},"projectRemindReceivers":[{"id":1590,"user_id":1001,"key":1001,"project_id":3801,"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":1591,"user_id":5329,"key":5329,"project_id":3801,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},{"id":1592,"user_id":5332,"key":5332,"project_id":3801,"user":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}}},{"id":1593,"user_id":5420,"key":5420,"project_id":3801,"user":{"id":5420,"key":5420,"name":"\u674e\u6ea6","sex":"M","avatar":{"id":161,"user_id":5420,"name":"\/files\/cdn\/a57be577deb434\/avatar\/030adffb-15cf-3504-a6fe-49ad56425387.png"}}},{"id":1594,"user_id":5087,"key":5087,"project_id":3801,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},{"id":1595,"user_id":5300,"key":5300,"project_id":3801,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":1596,"user_id":5295,"key":5295,"project_id":3801,"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":1597,"user_id":5404,"key":5404,"project_id":3801,"user":{"id":5404,"key":5404,"name":"\u6b66\u51ef","sex":"M","avatar":{}}},{"id":1598,"user_id":1004,"key":1004,"project_id":3801,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},{"id":1599,"user_id":1005,"key":1005,"project_id":3801,"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"}}}],"commentCount":{"object_id":3801,"comment":7},"unreadComments":{},"lost_contact_days_display":"","unissued_invoice":8000,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":24,"progress_remain_display":86,"forecast_remain_display":23,"duration_display":86,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"8000"},{"id":3786,"client_id":3334,"project_status":3,"project_progress":9,"budget":"3593747","profit_pct":"1.7","bargain_date":"2025-02-28","description":"","created_by":1001,"created_at":"2025-02-28 16:22:00","updated_at":"2025-07-04 14:19:12","engineer_id":"","project_title":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","collected":"-1","status_updated_at":"2025-02-28 16:22:00.848979+08","success_rate":"","comment":"\u7d2b\u5149\u6768\u534e\u63a8\u8350","contract_type":1,"progress_updated_at":"2025-02-28 16:22:00.848979+08","forecast_updated_at":"2025-04-08 14:42:27.53319+08","end_at":"","pinyin_shortcut":"yjrjgcjkcp","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":788,"is_sales_order_ready":true,"collected_plan":3048205,"profits":"61093.6990000000000","remain":"126 days 21:47:30.805523","progress_remain":"126 days 21:47:30.805523","forecast_remain":"87 days 23:27:04.121312","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"126 days 21:47:30.805523","issued_invoices":"","client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"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":"","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"},"projectProductTypes":[{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"3048204","pct":"1.99","profit":"60964","project_id":3786},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"545543","pct":"0.1","profit":"547","project_id":3786}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"schedules":[],"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"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3786,"sum":"","times":""},"presalesTimeCount":{"project_id":3786,"sum":"","times":""},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3803,"from_project":3786,"payment_collection_remind_ahead":"","salesContractPayments":[{"id":2156,"key":2156,"contract_id":3803,"value":"-1"}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2396,"key":2396,"contract_id":3803,"name":"2025-03-31","value":"3048204","overdue_days":""},{"id":2397,"key":2397,"contract_id":3803,"name":"2025-06-11","value":"1","overdue_days":""}]},"projectRemindReceivers":[{"id":1417,"user_id":1001,"key":1001,"project_id":3786,"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"}}}],"commentCount":{"object_id":3786,"comment":3},"unreadComments":{},"lost_contact_days_display":"","unissued_invoice":3593747,"is_exceeded":false,"can_update":true,"can_delete":true,"can_invoice":true,"can_payment":true,"unread":0,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":126,"progress_remain_display":126,"forecast_remain_display":87,"duration_display":126,"last_arrive_days_display":"","contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"359.37\u4e07"}],"pagenation":{"totalcount":102,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:09:31') RETURNING "id" |