ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2104fbc7d0e: POST https://beta.jinchangxiao.com/vue/project/list-all-status at 2026-06-04 12:54:19 pm by 221.216.117.119

Database Queries

总计47条数据
TimeDurationTypeQuery
  
12:54:19.9750.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5250

[+] Explain
12:54:19.9830.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250

[+] Explain
12:54:19.99111.9 msSELECTSELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.0038.7 msSELECTSELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.0136.1 msSELECTSELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.02010.6 msSELECTSELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
12:54:20.0310.4 msSELECTSELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3354, 2130, 3434, 3437, 3447, 2526, 149, 2202, 2492, 520, 85)

[+] Explain
12:54:20.0320.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2128, 85, 2130)

[+] Explain
12:54:20.0330.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3354, 2130, 3434, 3437, 3447, 2526, 149, 2202, 2492, 520, 85)

[+] Explain
12:54:20.0330.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5087, 5300)

[+] Explain
12:54:20.0340.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5087, 1005, 5300))

[+] Explain
12:54:20.0351.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4177, 3957, 4097, 4114, 4120, 4042, 3287, 3463, 3329, 3203, 3137, 3136, 3126, 3190, 3110, 3037)

[+] Explain
12:54:20.0361.3 msSELECTSELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (160, 140, 5, 1, 226, 164, 132, 172, 2, 205, 204, 135, 184, 200, 185, 191, 192, 331, 197, 199, 215, 229, 189, 130, 179, 181, 142, 348, 349, 359, 369, 374, 377, 356, 128)) ORDER BY "sort"

[+] Explain
12:54:20.0380.2 msSELECTSELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=1

[+] Explain
12:54:20.0381.1 msSELECTSELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (2, 9, 5, 3)

[+] Explain
12:54:20.0390.4 msSELECTSELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (4177, 3957, 4097, 4114, 4120, 4042, 3287, 3463, 3329, 3203, 3137, 3136, 3126, 3190, 3110, 3037)

[+] Explain
12:54:20.0400.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
12:54:20.0400.7 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
12:54:20.0429.8 msSELECTSELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.0529.1 msSELECTSELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.06216.6 msSELECTSELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
12:54:20.0790.4 msSELECTSELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3463, 2128, 2125, 93, 2205, 2202, 2166, 1492, 12, 3452, 3449, 3179, 85, 89, 97)

[+] Explain
12:54:20.0800.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3463, 2128, 2125, 93, 2205, 2202, 2166, 1492, 12, 3452, 3449, 3179, 85, 89, 97)

[+] Explain
12:54:20.0810.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5300, 5087, 1001)

[+] Explain
12:54:20.0810.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5087, 1005, 5300))

[+] Explain
12:54:20.0820.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4175, 3854, 3796, 4146, 4005, 4149, 4136, 4133, 4165, 4163, 4147, 4134, 4131, 4125, 4109, 4088, 4083, 3976, 3778, 4162)

[+] Explain
12:54:20.0830.5 msSELECTSELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (326, 2, 5, 1, 226, 215, 136, 140, 135, 160, 184, 189, 197, 199, 194, 183, 188, 187, 196, 204, 185, 191, 340, 323, 349, 369, 371, 377, 356, 350, 333, 380, 164, 142, 165, 172, 181, 128)) ORDER BY "sort"

[+] Explain
12:54:20.0840.2 msSELECTSELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2

[+] Explain
12:54:20.0840.2 msSELECTSELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (2, 3, 5, 4, 9)

[+] Explain
12:54:20.0850.5 msSELECTSELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (4175, 3854, 3796, 4146, 4005, 4149, 4136, 4133, 4165, 4163, 4147, 4134, 4131, 4125, 4109, 4088, 4083, 3976, 3778, 4162)

[+] Explain
12:54:20.0850.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005)

[+] Explain
12:54:20.0860.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1005))

[+] Explain
12:54:20.0876.9 msSELECTSELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.0946.9 msSELECTSELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.1026.3 msSELECTSELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
12:54:20.1095.1 msSELECTSELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.1155.8 msSELECTSELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.1216.8 msSELECTSELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
12:54:20.1296.3 msSELECTSELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.1366.4 msSELECTSELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.1436.3 msSELECTSELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
12:54:20.1506.8 msSELECTSELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.1577.0 msSELECTSELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
12:54:20.1659.0 msSELECTSELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5250) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5250))) AND (("c"."sales_rep"='5087') OR ("c"."sales_rep"='1013') OR ("c"."sales_rep"='1004') OR ("c"."sales_rep"='1005') OR ("c"."sales_rep"='1001') OR ("c"."sales_rep"='5300') OR ("c"."sales_rep"='5311') OR ("c"."sales_rep"='5295') OR ("c"."sales_rep"='5332') OR ("c"."sales_rep"='5476')) AND (("p"."project_status"='2') OR ("p"."project_status"='1')) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
12:54:20.1740.3 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN ('5087', '1013', '1004', '1005', '1001', '5300', '5311', '5295', '5332', '5476')

[+] Explain
12:54:20.1740.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5311)

[+] Explain
12:54:20.1796.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/project/list-all-status', '{"ProjectSearch":{"created_by":["5087","1013","1004","1005","1001","5300","5311","5295","5332","5476"],"project_status":["2","1"],"group":"","creator":"","purchaseType":"","engineer_group":"","period":"","budget":"","profit_pct":"","invoice_status":"","payment_status":"","collected_plan":"","project_progress":"","salesForecast":"","projectProductTypes":"","contact_point_status":"","from_contact_name":"","from_contact":"","contract_type":"","is_sales_order_ready":"","created_period":""},"Filter":{"name":"bargain_date","sort":"DESC","Tsort":"","Tname":""},"page":"1","web_access_token":"4PRqkvfbFxlQtWIcg4m99LDGwofOdZol"}', '{"code":2000,"result":{"list1count":16,"list1sum":"27134400","list1":[{"id":4177,"client_id":3354,"project_status":1,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":1005,"created_at":"2026-06-04 12:40:43","updated_at":"2026-06-04 12:49:02","engineer_id":"","project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260604001","collected":"0","status_updated_at":"2026-06-04 12:40:43.616079+08","success_rate":"","comment":"\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5","contract_type":"","progress_updated_at":"2026-06-04 12:40:43.616079+08","forecast_updated_at":"2026-06-04 12:40:43.616079+08","end_at":"","pinyin_shortcut":"xsxssc20260604001","creator":1001,"used_client":"","from_contact":3649,"total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"0.00000000000000000000","remain":"00:13:36.40624","progress_remain":"00:13:36.40624","forecast_remain":"00:13:36.40624","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"00:13:36.40624","issued_invoices":"","client":{"id":3354,"key":3354,"name":"\u822a\u5929\u79d1\u6280\u4e00\u966215\u6240","logo":"","client_type":6,"client_class":47,"client_industry":58,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3957,"client_id":2130,"project_status":1,"project_progress":2,"budget":"20000000","profit_pct":"20","bargain_date":"2026-10-31","description":"","created_by":5087,"created_at":"2025-08-29 11:38:51","updated_at":"2025-08-29 11:38:51","engineer_id":"","project_title":"\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd","collected":"0","status_updated_at":"2025-08-29 11:38:51.97137+08","success_rate":"","comment":"\u9884\u7b972000\u4e07","contract_type":1,"progress_updated_at":"2025-08-29 11:38:51.97137+08","forecast_updated_at":"2025-08-29 11:38:51.97137+08","end_at":"","pinyin_shortcut":"zgrmjfjzcmbdwsyyjsszgcgxn","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"4000000.000000000000","remain":"279 days 01:15:28.050949","progress_remain":"279 days 01:15:28.050949","forecast_remain":"279 days 01:15:28.050949","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"279 days 01:15:28.050949","issued_invoices":"","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[{"id":1762,"user_id":1001,"key":1001,"project_id":3957,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":4097,"client_id":3434,"project_status":1,"project_progress":2,"budget":"29800","profit_pct":"50","bargain_date":"2026-05-31","description":"","created_by":1005,"created_at":"2026-01-09 14:39:26","updated_at":"2026-02-26 10:13:21","engineer_id":"","project_title":"\u91d1\u7545\u900dERP\u91c7\u8d2d","collected":"0","status_updated_at":"2026-02-26 10:13:21.286281+08","success_rate":"","comment":"2026\/1\/7 \u636e\u56fd\u884c\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u516c\u53f8\u7ba1\u7406CEO\u5e2d\u4f5c\u4eae\u4ecb\u7ecd\uff1a\u76ee\u524d\u8fd8\u6ca1\u6709ERP\uff0c\u51c6\u5907\u8981\u4e0a\u8fd9\u65b9\u9762\u7684\u7cfb\u7edf\uff0c\u4e3b\u8981\u662f\u8d22\u52a1\u548c\u7ba1\u7406\u7cfb\u7edf\uff0c\u5e74\u5e95\u633a\u5fd9\u7684\uff0c\u5f97\u8282\u540e\u53ef\u4ee5\u7ebf\u4e0b\u62dc\u8bbf\uff0c\u540c\u610f\u53d1\u8d44\u6599\u4e86\u89e3\u4e00\u4e0b\uff0c\u5982\u679c\u4ea7\u54c1\u5408\u9002\u7684\u8bdd\uff0c\u4f1a\u8003\u8651\u4e00\u4e0b\u4ef7\u683c\u53ca\u4f18\u52bf\uff0c\u9884\u8ba14-5\u6708\u4efd\u90e8\u7f72\uff0c\u51b3\u7b56\u4eba\uff0c\u529e\u516c\u4eba\u6570\u4e0d\u65b9\u4fbf\u900f\u9732\u3002\u624b\u673a\u53f7\u540c\u5fae\u4fe1\uff1a18001369885 \u90ae\u7bb1\uff1a18001369885@163.com","contract_type":1,"progress_updated_at":"2026-01-18 21:58:09.100628+08","forecast_updated_at":"2026-02-26 10:13:21.286281+08","end_at":"","pinyin_shortcut":"jcxERPcg","creator":1011,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"14900.0000000000000000","remain":"98 days 02:40:58.736038","progress_remain":"136 days 14:56:10.921691","forecast_remain":"98 days 02:40:58.736038","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"145 days 22:14:53.502327","issued_invoices":"","client":{"id":3434,"key":3434,"name":"\u56fd\u884c\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08\u91d1\u7545\u900d\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":4114,"client_id":3437,"project_status":1,"project_progress":2,"budget":"29800","profit_pct":"50","bargain_date":"2026-03-31","description":"","created_by":1005,"created_at":"2026-01-23 14:56:28","updated_at":"2026-02-26 10:13:14","engineer_id":"","project_title":"\u91d1\u7545\u900d\u91c7\u8d2d","collected":"0","status_updated_at":"2026-02-26 10:13:14.196642+08","success_rate":"","comment":"H3C\uff0c\u534e\u4e3a\u4ee3\u7406\u5546\u3002150\u4eba\u5de6\u53f3\u3002\u76ee\u524d\u53ea\u6709\u8d22\u52a1\u8f6f\u4ef6C8\uff0c\u60f3\u4e70\u4e2a all in one\u7684\u4ea7\u54c1\u3002","contract_type":1,"progress_updated_at":"2026-01-23 14:56:28.195747+08","forecast_updated_at":"2026-02-26 10:13:14.196642+08","end_at":"","pinyin_shortcut":"jcxcg","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"14900.0000000000000000","remain":"98 days 02:41:05.825677","progress_remain":"131 days 21:57:51.826572","forecast_remain":"98 days 02:41:05.825677","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"131 days 21:57:51.826572","issued_invoices":"","client":{"id":3437,"key":3437,"name":"\u676d\u5dde\u4eae\u901a\u7f51\u7edc\u5de5\u7a0b\u6709\u9650\u516c\u53f8\uff08\u91d1\u7545\u900d\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":4120,"client_id":3447,"project_status":1,"project_progress":2,"budget":"29800","profit_pct":"0.33","bargain_date":"2026-02-26","description":"","created_by":1005,"created_at":"2026-02-26 10:16:04","updated_at":"2026-03-01 23:08:09","engineer_id":"","project_title":"\u91d1\u7545\u900d","collected":"0","status_updated_at":"2026-03-01 23:08:09.087634+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-02-26 10:16:04.219313+08","forecast_updated_at":"2026-03-01 23:08:09.087634+08","end_at":"","pinyin_shortcut":"jcx","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"98.340000000000000000","remain":"94 days 13:46:10.934685","progress_remain":"98 days 02:38:15.803006","forecast_remain":"94 days 13:46:10.934685","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"98 days 02:38:15.803006","issued_invoices":"","client":{"id":3447,"key":3447,"name":"\u5317\u4eac\u4ec1\u79d1","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":4042,"client_id":2526,"project_status":1,"project_progress":9,"budget":"95000","profit_pct":"25","bargain_date":"2025-12-15","description":"","created_by":5087,"created_at":"2025-11-11 14:32:23","updated_at":"2025-11-16 23:35:08","engineer_id":"","project_title":"\u5907\u4efd\u7cfb\u7edf-\u5206\u4fdd","collected":"0","status_updated_at":"2025-11-16 23:35:08.894314+08","success_rate":"","comment":"\u4e09\u5bb6\u4ee3\u7406\u5546 \u78a7\u6c34\u9f99\u8dc3 \u5317\u4eac\u82f1\u5c71\u5728\u7ebf \n\u9879\u76ee\u60c5\u51b5\uff1a\u6d4b\u63a7-\u7cfb\u7edf\u516c\u53f8 \u4e0a\u4f20\u56fd\u7c73\u7f512\u4e2a\u7cfb\u7edf OA+\u90ae\u5bc4 \u52a0\u8d77\u6765\u51e0\u767eG \u91c7\u8d2d2T\u5b9a\u65f6\u5907\u4efd 1\u4e2a\u5f02\u5730\u540c\u6b65\u901a\u9053\u6388\u6743 3\u5e74\u8d28\u4fdd \uff0c\u4eca\u5e74\u9700\u8fc7\u5206\u4fdd \u9884\u8ba1\u6708\u5e95\u8bbe\u5907\u5230\u4f4d","contract_type":1,"progress_updated_at":"2025-11-11 14:32:23.625008+08","forecast_updated_at":"2025-11-16 23:35:08.894314+08","end_at":"","pinyin_shortcut":"bfxtfb","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"23750.0000000000000000","remain":"199 days 13:19:11.128005","progress_remain":"204 days 22:21:56.397311","forecast_remain":"199 days 13:19:11.128005","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"204 days 22:21:56.397311","issued_invoices":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":43,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[{"id":1903,"user_id":1001,"key":1001,"project_id":4042,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3287,"client_id":149,"project_status":1,"project_progress":2,"budget":"3000000","profit_pct":"10","bargain_date":"2024-12-31","description":"","created_by":1005,"created_at":"2023-08-13 16:30:53","updated_at":"2024-11-11 13:52:18","engineer_id":"","project_title":"\u6cd5\u8bc1\u65b0\u5de5\u5382","collected":"0","status_updated_at":"2023-08-13 16:30:53.331424+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2023-08-13 16:30:53.331424+08","forecast_updated_at":"2023-08-13 16:30:53.331424+08","end_at":"","pinyin_shortcut":"fzxgc","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"300000.000000000000","remain":"1025 days 20:23:26.690895","progress_remain":"1025 days 20:23:26.690895","forecast_remain":"1025 days 20:23:26.690895","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"1025 days 20:23:26.690895","issued_invoices":"","client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)","logo":"","client_type":1,"client_class":47,"client_industry":1,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3463,"client_id":2202,"project_status":1,"project_progress":5,"budget":"100000","profit_pct":"10","bargain_date":"2024-07-31","description":"","created_by":5300,"created_at":"2024-03-05 14:13:06","updated_at":"2024-04-29 09:53:05","engineer_id":"","project_title":"\u52d2\u7d22\u75c5\u6bd2\u9632\u62a4\u65b9\u6848-\u9752\u85e4npatch+\u4e07\u76f8\uff08\u6d4b\u8bd5\uff09","collected":"0","status_updated_at":"2024-03-05 14:13:06.178873+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-03-05 14:13:06.178873+08","forecast_updated_at":"2024-03-05 14:13:06.178873+08","end_at":"","pinyin_shortcut":"lsbdfhfaqtnpatchwxcs","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"10000.0000000000000000","remain":"820 days 22:41:13.843446","progress_remain":"820 days 22:41:13.843446","forecast_remain":"820 days 22:41:13.843446","lost_contact_days":"813.081481739803","last_contact":"2024-03-13 10:57:00","last_arrive_days":"813.081481739803","last_arrive":"2024-03-13 10:57:00+08","duration":"820 days 22:41:13.843446","issued_invoices":"","client":{"id":2202,"key":2202,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5b66\u6821\uff08\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5e7c\u513f\u56ed\uff09","logo":"","client_type":5,"client_class":43,"client_industry":24,"sales_rep":5300},"usedClient":{},"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"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3329,"client_id":2492,"project_status":1,"project_progress":2,"budget":"600000","profit_pct":"30","bargain_date":"2024-05-31","description":"","created_by":5087,"created_at":"2023-10-15 19:57:32","updated_at":"2026-02-28 13:31:16","engineer_id":"","project_title":"\u9662\u5185\u865a\u62df\u5316\u5efa\u8bbe-K","collected":"0","status_updated_at":"2023-12-03 21:46:59.123311+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2023-10-15 19:57:32.636686+08","forecast_updated_at":"2023-12-03 21:46:59.123311+08","end_at":"","pinyin_shortcut":"ynxnhjsK","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"180000.0000000000000000","remain":"913 days 15:07:20.899008","progress_remain":"962 days 16:56:47.385633","forecast_remain":"913 days 15:07:20.899008","lost_contact_days":"906.705787295359","last_contact":"2023-12-10 19:58:00","last_arrive_days":"","last_arrive":"","duration":"962 days 16:56:47.385633","issued_invoices":"","client":{"id":2492,"key":2492,"name":"\u822a\u5929\u79d1\u5de5\u96c6\u56e2\u667a\u80fd\u79d1\u6280\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3203,"client_id":520,"project_status":1,"project_progress":3,"budget":"200000","profit_pct":"10","bargain_date":"2024-03-31","description":"SDP+\u5b89\u5168\u5de5\u4f5c\u7a7a\u95f4\n\u529e\u516c\u7ec8\u7aef\u6570\u91cf130-150","created_by":5300,"created_at":"2023-05-19 15:59:41","updated_at":"2024-09-06 20:38:59","engineer_id":"","project_title":"\u5b89\u5168\u5de5\u4f5c\u7a7a\u95f4-2023-K","collected":"0","status_updated_at":"2024-03-18 10:50:02.128522+08","success_rate":"","comment":"SDP+\u5b89\u5168\u5de5\u4f5c\u7a7a\u95f4\n\u529e\u516c\u7ec8\u7aef\u6570\u91cf130-150\r\n","contract_type":1,"progress_updated_at":"2023-05-19 15:59:41.173448+08","forecast_updated_at":"2024-03-18 10:50:02.128522+08","end_at":"","pinyin_shortcut":"aqgzkj2023K","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"20000.0000000000000000","remain":"808 days 02:04:17.893797","progress_remain":"1111 days 20:54:38.848871","forecast_remain":"808 days 02:04:17.893797","lost_contact_days":"636.037731739803","last_contact":"2024-09-06 12:00:00","last_arrive_days":"818.83564840647","last_arrive":"2024-03-07 16:51:00+08","duration":"1111 days 20:54:38.848871","issued_invoices":"","client":{"id":520,"key":520,"name":"\u5317\u4eac\u4f18\u80fd\u535a\u534e\u6295\u8d44\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":10,"sales_rep":5300},"usedClient":{},"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectRemindReceivers":[{"id":835,"user_id":1001,"key":1001,"project_id":3203,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3137,"client_id":2130,"project_status":1,"project_progress":3,"budget":"2000000","profit_pct":"15","bargain_date":"2023-12-31","description":"33\u6240\u60ef\u6027\u516c\u53f8\uff0c\u4e0e\u9662\u7f51\u8fde\u63a5\uff0c\u8d2d\u4e70\u52a0\u5bc6\u673a\u548c\u9632\u706b\u5899\u7b49\u7f51\u7edc\u8bbe\u5907\u3002","created_by":5087,"created_at":"2023-03-06 16:32:45","updated_at":"2023-09-18 16:36:05","engineer_id":"","project_title":"\u60ef\u6027\u516c\u53f8\u8054\u7f51\u8bbe\u5907","collected":"0","status_updated_at":"2023-03-27 20:49:05.468689+08","success_rate":"","comment":"33\u6240\u60ef\u6027\u516c\u53f8\uff0c\u4e0e\u9662\u7f51\u8fde\u63a5\uff0c\u8d2d\u4e70\u52a0\u5bc6\u673a\u548c\u9632\u706b\u5899\u7b49\u7f51\u7edc\u8bbe\u5907\u3002\r\n","contract_type":1,"progress_updated_at":"2023-03-12 21:57:55.785099+08","forecast_updated_at":"2023-05-15 11:40:18.906738+08","end_at":"","pinyin_shortcut":"gxgslwsb","creator":5087,"used_client":2128,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"300000.000000000000","remain":"1164 days 16:05:14.55363","progress_remain":"1179 days 14:56:24.23722","forecast_remain":"1116 days 01:14:01.115581","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"1185 days 20:21:34.693","issued_invoices":"","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"salesRep":{"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"}},"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3136,"client_id":2130,"project_status":1,"project_progress":5,"budget":"150000","profit_pct":"50","bargain_date":"2023-12-31","description":"31 NAS \u5b58\u50a8\u7eed\u4fdd 8\u4e07 \/SAN\u5b58\u50a8\u7eed\u4fdd 7\u4e07","created_by":5087,"created_at":"2023-03-06 14:33:33","updated_at":"2023-09-18 16:36:05","engineer_id":"","project_title":"2023\u5e74\u5b58\u50a8\u7eed\u4fdd-K","collected":"0","status_updated_at":"2023-05-08 20:36:07.746351+08","success_rate":"","comment":"31 NAS \u5b58\u50a8\u7eed\u4fdd 8\u4e07 \/SAN\u5b58\u50a8\u7eed\u4fdd 7\u4e07\r\n","contract_type":1,"progress_updated_at":"2023-03-06 14:38:12.823874+08","forecast_updated_at":"2023-05-08 20:36:07.746351+08","end_at":"","pinyin_shortcut":"2023nccxbK","creator":5087,"used_client":85,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"75000.0000000000000000","remain":"1122 days 16:18:12.275968","progress_remain":"1185 days 22:16:07.198445","forecast_remain":"1122 days 16:18:12.275968","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"1185 days 22:20:46.245107","issued_invoices":"","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{"id":85,"key":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240"},"salesRep":{"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"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3126,"client_id":2130,"project_status":1,"project_progress":3,"budget":"0","profit_pct":"0","bargain_date":"2023-12-31","description":"304\u6240\u5e2e\u9662\u91cc\u8c03\u7814\u8fd0\u7ef4\u7cfb\u7edf\uff0c\u76ee\u7684\u662f\u89e3\u51b3\u9662\u91cc\u8fd0\u7ef4\u7cfb\u7edf\u4e0d\u80fd\u7edf\u7ba1\u56fd\u4ea7\u81ea\u4e3b\u53ef\u63a7\u8bbe\u5907\uff0c\u4e1c\u897f\u8d8a\u6765\u8d8a\u591a\u4e0d\u65b9\u4fbf\uff0c\u540c\u65f6\u9662\u91cc\u4e5f\u6709\u96c6\u4e2d\u7ba1\u63a7\u7684\u60f3\u6cd5\uff0c\u5728\u8c03\u7814\u3002","created_by":5087,"created_at":"2023-02-27 02:46:33","updated_at":"2023-10-23 00:35:47","engineer_id":"","project_title":"\u8fd0\u7ef4\u7ba1\u7406\u7cfb\u7edf","collected":"0","status_updated_at":"2023-02-27 02:46:33.832345+08","success_rate":"","comment":"304\u6240\u5e2e\u9662\u91cc\u8c03\u7814\u8fd0\u7ef4\u7cfb\u7edf\uff0c\u76ee\u7684\u662f\u89e3\u51b3\u9662\u91cc\u8fd0\u7ef4\u7cfb\u7edf\u4e0d\u80fd\u7edf\u7ba1\u56fd\u4ea7\u81ea\u4e3b\u53ef\u63a7\u8bbe\u5907\uff0c\u4e1c\u897f\u8d8a\u6765\u8d8a\u591a\u4e0d\u65b9\u4fbf\uff0c\u540c\u65f6\u9662\u91cc\u4e5f\u6709\u96c6\u4e2d\u7ba1\u63a7\u7684\u60f3\u6cd5\uff0c\u5728\u8c03\u7814\u3002\r\n","contract_type":1,"progress_updated_at":"2023-02-27 02:46:33.832345+08","forecast_updated_at":"2023-05-15 11:40:41.852321+08","end_at":"","pinyin_shortcut":"ywglxt","creator":5087,"used_client":2130,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"0.00000000000000000000","remain":"1193 days 10:07:46.189974","progress_remain":"1193 days 10:07:46.189974","forecast_remain":"1116 days 01:13:38.169998","lost_contact_days":"1105.91759285091","last_contact":"2023-05-25 14:53:00","last_arrive_days":"","last_arrive":"","duration":"1193 days 10:07:46.189974","issued_invoices":"","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304"},"salesRep":{"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"}},"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3190,"client_id":2130,"project_status":1,"project_progress":3,"budget":"200000","profit_pct":"25","bargain_date":"2023-06-30","description":"","created_by":5087,"created_at":"2023-05-08 20:30:27","updated_at":"2023-09-18 16:36:05","engineer_id":"","project_title":"\u4e91\u79d14250\u6269\u5bb9-K","collected":"0","status_updated_at":"2023-05-08 20:35:56.412757+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2023-05-08 20:30:27.216933+08","forecast_updated_at":"2023-05-08 20:35:56.412757+08","end_at":"","pinyin_shortcut":"yk4250krK","creator":5087,"used_client":85,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"50000.0000000000000000","remain":"1122 days 16:18:23.609562","progress_remain":"1122 days 16:23:52.805386","forecast_remain":"1122 days 16:18:23.609562","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"1122 days 16:23:52.805386","issued_invoices":"","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{"id":85,"key":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240"},"salesRep":{"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3110,"client_id":2130,"project_status":1,"project_progress":2,"budget":"200000","profit_pct":"15","bargain_date":"2023-06-30","description":"\u6d89\u5bc6\u76d1\u63a7\u91cc\u9762\u534e\u4e3a\u4ea4\u6362\u673a \u9632\u706b\u5899 pc\u673a\uff0c\u5218\u52d6\u5165\u4fb5\u68c0\u6d4b \u548c\u9632\u706b\u5899\u3002304\u6240\u548c\u79d1\u628012\u9662\u3002","created_by":5087,"created_at":"2023-02-12 23:20:11","updated_at":"2023-09-18 16:36:05","engineer_id":"","project_title":"\u5b89\u5168\u4ea7\u54c1\u91c7\u8d2d-K","collected":"0","status_updated_at":"2023-05-08 20:35:20.099847+08","success_rate":"","comment":"\u6d89\u5bc6\u76d1\u63a7\u91cc\u9762\u534e\u4e3a\u4ea4\u6362\u673a \u9632\u706b\u5899 pc\u673a\uff0c\u5218\u52d6\u5165\u4fb5\u68c0\u6d4b \u548c\u9632\u706b\u5899\u3002304\u6240\u548c\u79d1\u628012\u9662\u3002\r\n","contract_type":1,"progress_updated_at":"2023-02-27 12:49:46.128566+08","forecast_updated_at":"2023-05-08 20:35:20.099847+08","end_at":"","pinyin_shortcut":"aqcpcgK","creator":5087,"used_client":2128,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"30000.0000000000000000","remain":"1122 days 16:18:59.922472","progress_remain":"1193 days 00:04:33.893753","forecast_remain":"1122 days 16:18:59.922472","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"1207 days 13:34:08.704515","issued_invoices":"","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"salesRep":{"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"}},"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true},{"id":3037,"client_id":85,"project_status":1,"project_progress":2,"budget":"500000","profit_pct":"20","bargain_date":"2023-06-30","description":"ZStack\u4fe1\u521b\u4e91","created_by":5087,"created_at":"2022-11-14 10:16:38","updated_at":"2023-06-05 11:58:18","engineer_id":"","project_title":"\u82cf\u5dde\u79c1\u6709\u4e91\u9879\u76ee","collected":"0","status_updated_at":"2023-02-13 19:13:52.059703+08","success_rate":"","comment":"ZStack\u4fe1\u521b\u4e91\r\n","contract_type":1,"progress_updated_at":"2022-11-14 10:16:38.860229+08","forecast_updated_at":"2023-05-15 11:41:02.727942+08","end_at":"","pinyin_shortcut":"szsyyxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"100000.0000000000000000","remain":"1206 days 17:40:27.962616","progress_remain":"1298 days 02:37:41.16209","forecast_remain":"1116 days 01:13:17.294377","lost_contact_days":"1259.50300951758","last_contact":"2022-12-23 00:50:00","last_arrive_days":"","last_arrive":"","duration":"1298 days 02:37:41.16209","issued_invoices":"","client":{"id":85,"key":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240","logo":"","client_type":1,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u9690\u6027\u9700\u6c42","is_collected":false,"bgcolor":"#ffc000","can_update":true,"can_delete":true}],"list2count":51,"list2sum":"73265232.06","list2":[{"id":4175,"client_id":3463,"project_status":2,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":1001,"created_at":"2026-06-02 16:54:10","updated_at":"2026-06-02 16:54:10","engineer_id":"","project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602002","collected":"0","status_updated_at":"2026-06-02 16:54:10.331403+08","success_rate":"","comment":"\u5bf9\u65b9\u8bf4\u7684","contract_type":"","progress_updated_at":"2026-06-02 16:54:10.331403+08","forecast_updated_at":"2026-06-02 16:54:10.331403+08","end_at":"","pinyin_shortcut":"xsxssc20260602002","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"0.00000000000000000000","remain":"1 day 20:00:09.732822","progress_remain":"1 day 20:00:09.732822","forecast_remain":"1 day 20:00:09.732822","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"1 day 20:00:09.732822","issued_invoices":"","client":{"id":3463,"key":3463,"name":"3","logo":"","client_type":1,"client_class":1,"client_industry":57,"sales_rep":1001},"usedClient":{},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"salesForecast":{},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":3854,"client_id":2128,"project_status":2,"project_progress":2,"budget":"44540520","profit_pct":"25","bargain_date":"2026-12-31","description":"","created_by":5087,"created_at":"2025-05-13 09:35:09","updated_at":"2026-06-04 12:36:37","engineer_id":"","project_title":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","collected":"0","status_updated_at":"2026-06-04 12:35:02.427663+08","success_rate":"","comment":"\u4e8c\u671f\u6269\u5bb9","contract_type":1,"progress_updated_at":"2026-06-04 12:35:02.427663+08","forecast_updated_at":"2026-06-04 12:35:02.427663+08","end_at":"","pinyin_shortcut":"bfxmeq","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1349,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"11135130.000000000000","remain":"00:19:17.636562","progress_remain":"00:19:17.636562","forecast_remain":"00:19:17.636562","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"387 days 03:19:10.534301","issued_invoices":"","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":3796,"client_id":2125,"project_status":2,"project_progress":3,"budget":"790000","profit_pct":"25","bargain_date":"2026-12-31","description":"","created_by":5087,"created_at":"2025-03-09 10:00:35","updated_at":"2026-04-22 15:46:14","engineer_id":"","project_title":"deepseek\u79c1\u6709\u5316\u90e8\u7f72","collected":"0","status_updated_at":"2025-05-25 16:43:18.119966+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-05-25 16:43:18.119966+08","forecast_updated_at":"2025-05-25 16:43:18.119966+08","end_at":"","pinyin_shortcut":"deepseeksyhbs","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"197500.0000000000000000","remain":"374 days 20:11:01.944259","progress_remain":"374 days 20:11:01.944259","forecast_remain":"374 days 20:11:01.944259","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"452 days 02:53:44.932706","issued_invoices":"","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectRemindReceivers":[{"id":2178,"user_id":1001,"key":1001,"project_id":3796,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4146,"client_id":93,"project_status":2,"project_progress":3,"budget":"500000","profit_pct":"15","bargain_date":"2026-09-30","description":"","created_by":1005,"created_at":"2026-03-20 13:31:49","updated_at":"2026-03-22 19:39:57","engineer_id":"","project_title":"\u98de\u5854\u96f6\u4fe1\u4efb\u65b0\u8d2d","collected":"0","status_updated_at":"2026-03-20 13:31:49.105412+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-03-20 13:31:49.105412+08","forecast_updated_at":"2026-03-20 13:31:49.105412+08","end_at":"","pinyin_shortcut":"ftlxrxg","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"75000.0000000000000000","remain":"75 days 23:22:30.958813","progress_remain":"75 days 23:22:30.958813","forecast_remain":"75 days 23:22:30.958813","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"75 days 23:22:30.958813","issued_invoices":"","client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4005,"client_id":2205,"project_status":2,"project_progress":5,"budget":"400000","profit_pct":"15","bargain_date":"2026-09-30","description":"","created_by":1005,"created_at":"2025-10-17 11:13:22","updated_at":"2026-03-22 19:37:34","engineer_id":"","project_title":"PA1410 \u66ff\u63623220","collected":"0","status_updated_at":"2025-10-17 11:13:22.218161+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-10-17 11:13:22.218161+08","forecast_updated_at":"2025-10-17 11:13:22.218161+08","end_at":"","pinyin_shortcut":"PA1410th3220","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"60000.0000000000000000","remain":"230 days 01:40:57.846064","progress_remain":"230 days 01:40:57.846064","forecast_remain":"230 days 01:40:57.846064","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"230 days 01:40:57.846064","issued_invoices":"","client":{"id":2205,"key":2205,"name":"\u5317\u4eac\u6613\u8f66\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":47,"client_industry":19,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4149,"client_id":2202,"project_status":2,"project_progress":4,"budget":"20000","profit_pct":"10","bargain_date":"2026-08-31","description":"","created_by":5300,"created_at":"2026-03-23 13:46:23","updated_at":"2026-03-25 10:21:19","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u65b0\u8d2d-2026","collected":"0","status_updated_at":"2026-03-23 13:46:23.79812+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-03-23 13:46:23.79812+08","forecast_updated_at":"2026-03-23 13:46:23.79812+08","end_at":"","pinyin_shortcut":"sxffhqxg2026","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"2000.0000000000000000","remain":"72 days 23:07:56.266105","progress_remain":"72 days 23:07:56.266105","forecast_remain":"72 days 23:07:56.266105","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"72 days 23:07:56.266105","issued_invoices":"","client":{"id":2202,"key":2202,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5b66\u6821\uff08\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5e7c\u513f\u56ed\uff09","logo":"","client_type":5,"client_class":43,"client_industry":24,"sales_rep":5300},"usedClient":{},"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"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectRemindReceivers":[{"id":2164,"user_id":1001,"key":1001,"project_id":4149,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":2165,"user_id":1005,"key":1005,"project_id":4149,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4136,"client_id":2166,"project_status":2,"project_progress":4,"budget":"50000","profit_pct":"10","bargain_date":"2026-07-31","description":"","created_by":5300,"created_at":"2026-03-10 09:37:01","updated_at":"2026-03-25 21:27:56","engineer_id":"","project_title":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u65b0\u8d2d-2026","collected":"0","status_updated_at":"2026-03-10 09:37:01.707719+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-03-10 09:37:01.707719+08","forecast_updated_at":"2026-03-10 09:37:01.707719+08","end_at":"","pinyin_shortcut":"swxwglxg2026","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"5000.0000000000000000","remain":"86 days 03:17:18.356506","progress_remain":"86 days 03:17:18.356506","forecast_remain":"86 days 03:17:18.356506","lost_contact_days":"70.8974544470486","last_contact":"2026-03-25 15:22:00","last_arrive_days":"70.8974544470486","last_arrive":"2026-03-25 15:22:00+08","duration":"86 days 03:17:18.356506","issued_invoices":"","client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\/\u6df1\u5733\u6c5f\u539f\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":43,"client_industry":5,"sales_rep":5300},"usedClient":{},"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"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectRemindReceivers":[{"id":2145,"user_id":1001,"key":1001,"project_id":4136,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":2146,"user_id":1005,"key":1005,"project_id":4136,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4133,"client_id":2128,"project_status":2,"project_progress":5,"budget":"4350000","profit_pct":"16","bargain_date":"2026-07-31","description":"","created_by":5087,"created_at":"2026-03-05 18:23:59","updated_at":"2026-03-22 19:40:06","engineer_id":"","project_title":"\u5e94\u7528\u7cfb\u7edf\u670d\u52a1\u5668\u91c7\u8d2d-K","collected":"0","status_updated_at":"2026-03-09 00:13:53.573869+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-03-09 00:13:53.573869+08","forecast_updated_at":"2026-03-09 00:13:53.573869+08","end_at":"","pinyin_shortcut":"yyxtfwqcgK","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"696000.000000000000","remain":"87 days 12:40:26.490356","progress_remain":"87 days 12:40:26.490356","forecast_remain":"87 days 12:40:26.490356","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"90 days 18:30:20.244821","issued_invoices":"","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectRemindReceivers":[{"id":2134,"user_id":1001,"key":1001,"project_id":4133,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4165,"client_id":2128,"project_status":2,"project_progress":2,"budget":"1000000","profit_pct":"5","bargain_date":"2026-07-01","description":"","created_by":5087,"created_at":"2026-04-08 12:16:03","updated_at":"2026-04-08 12:16:03","engineer_id":"","project_title":"\u667a\u7b97\u670d\u52a1\u5668\u91c7\u8d2d","collected":"0","status_updated_at":"2026-04-08 12:16:03.944425+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-04-08 12:16:03.944425+08","forecast_updated_at":"2026-04-08 12:16:03.944425+08","end_at":"","pinyin_shortcut":"zsfwqcg","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"50000.0000000000000000","remain":"57 days 00:38:16.1198","progress_remain":"57 days 00:38:16.1198","forecast_remain":"57 days 00:38:16.1198","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"57 days 00:38:16.1198","issued_invoices":"","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4163,"client_id":2125,"project_status":2,"project_progress":5,"budget":"1000000","profit_pct":"20","bargain_date":"2026-07-01","description":"","created_by":5087,"created_at":"2026-04-01 23:20:25","updated_at":"2026-04-01 23:20:25","engineer_id":"","project_title":"2026\u5e74\u667a\u7b97\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee","collected":"0","status_updated_at":"2026-04-01 23:20:25.403138+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-04-01 23:20:25.403138+08","forecast_updated_at":"2026-04-01 23:20:25.403138+08","end_at":"","pinyin_shortcut":"2026nzsfwqcgxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"200000.0000000000000000","remain":"63 days 13:33:54.661087","progress_remain":"63 days 13:33:54.661087","forecast_remain":"63 days 13:33:54.661087","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"63 days 13:33:54.661087","issued_invoices":"","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4147,"client_id":1492,"project_status":2,"project_progress":5,"budget":"1500000","profit_pct":"50","bargain_date":"2026-06-30","description":"","created_by":1005,"created_at":"2026-03-20 13:33:19","updated_at":"2026-03-22 19:36:46","engineer_id":"","project_title":"26\u5e74-27\u5e74\u5b58\u50a8\u7eed\u4fdd","collected":"0","status_updated_at":"2026-03-20 13:33:19.778416+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2026-03-20 13:33:19.778416+08","forecast_updated_at":"2026-03-20 13:33:19.778416+08","end_at":"","pinyin_shortcut":"26n27nccxb","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"750000.000000000000","remain":"75 days 23:21:00.285809","progress_remain":"75 days 23:21:00.285809","forecast_remain":"75 days 23:21:00.285809","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"75 days 23:21:00.285809","issued_invoices":"","client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)","logo":"","client_type":5,"client_class":47,"client_industry":5,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4134,"client_id":12,"project_status":2,"project_progress":4,"budget":"200000","profit_pct":"10","bargain_date":"2026-06-30","description":"","created_by":5300,"created_at":"2026-03-06 10:36:34","updated_at":"2026-03-23 14:22:53","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u8d85\u878d\u5408\u65b0\u8d2d-\u5929\u6d25-2026","collected":"0","status_updated_at":"2026-03-06 10:36:34.439476+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-03-06 10:36:34.439476+08","forecast_updated_at":"2026-03-23 14:22:53.714282+08","end_at":"","pinyin_shortcut":"sxfcrhxgtj2026","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"20000.0000000000000000","remain":"90 days 02:17:45.624749","progress_remain":"90 days 02:17:45.624749","forecast_remain":"72 days 22:31:26.349943","lost_contact_days":"76.0363433359375","last_contact":"2026-03-20 12:02:00","last_arrive_days":"76.0363433359375","last_arrive":"2026-03-20 12:02:00+08","duration":"90 days 02:17:45.624749","issued_invoices":"","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":5,"sales_rep":5300},"usedClient":{},"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectRemindReceivers":[{"id":2143,"user_id":1001,"key":1001,"project_id":4134,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":2144,"user_id":1005,"key":1005,"project_id":4134,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4131,"client_id":3452,"project_status":2,"project_progress":2,"budget":"20000","profit_pct":"10","bargain_date":"2026-06-30","description":"","created_by":5300,"created_at":"2026-03-05 09:04:55","updated_at":"2026-03-23 10:45:05","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u65b0\u8d2d-2026","collected":"0","status_updated_at":"2026-03-05 11:23:45.916358+08","success_rate":"","comment":"VPN\u4ea7\u54c1\uff0c\u603b\u90e8\u548c5\u4e2a\u5206\u90e8\u60f3\u5b9e\u73b0\u7f51\u7edc\u6253\u901a\uff0c\u4e3b\u8981\u662f\u603b\u90e8\u8fd9\u8fb9\u540e\u7eed\u4f1a\u62c9\u8d44\u6e90\u8bbf\u95ee\u6d77\u5916\uff0c\u60f3\u8981\u5206\u652f\u53ef\u4ee5\u540c\u65f6\u4f7f\u7528\u603b\u90e8\u8d44\u6e90\uff0c\u60f3\u770b\u4e0b\u662f\u7ec4\u7f51\u65b9\u6848\u5408\u9002\uff0c\u8fd8\u662f\u96f6\u4fe1\u4efb\u4e5f\u53ef\u4ee5\u6ee1\u8db3\uff0c\u5206\u652f\u5f88\u5206\u6563\uff0c\u6bcf\u4e2a\u5e97\u5c31\u51e0\u4e2a\u4eba\uff0c\u5e76\u53d1\u63a5\u5165\u6570\u4e0d\u8d85\u8fc750\n\u4e0b\u4e00\u6b65\u9700\u534f\u52a9\uff1a\u5728\u5317\u4eac\uff0c\u5e0c\u671b\u9500\u552e\u5b89\u6392\u6280\u672f\u804a\u4e0b\uff0c\u770b\u6211\u53f8\u80fd\u5426\u6ee1\u8db3","contract_type":1,"progress_updated_at":"2026-03-05 11:23:45.916358+08","forecast_updated_at":"2026-03-05 11:23:45.916358+08","end_at":"","pinyin_shortcut":"sxflxrxg2026","creator":1011,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"2000.0000000000000000","remain":"91 days 01:30:34.147867","progress_remain":"91 days 01:30:34.147867","forecast_remain":"91 days 01:30:34.147867","lost_contact_days":"75.9418988914931","last_contact":"2026-03-20 14:18:00","last_arrive_days":"75.9418988914931","last_arrive":"2026-03-20 14:18:00+08","duration":"91 days 03:49:24.963522","issued_invoices":"","client":{"id":3452,"key":3452,"name":"\u5317\u4eac\u9a8f\u4e00\u5b75\u5316\u5668\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":5300},"usedClient":{},"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"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4125,"client_id":3449,"project_status":2,"project_progress":2,"budget":"50000","profit_pct":"10","bargain_date":"2026-06-30","description":"","created_by":5300,"created_at":"2026-02-28 14:55:26","updated_at":"2026-03-23 10:34:52","engineer_id":"","project_title":"\u4e91\u684c\u9762-2026","collected":"0","status_updated_at":"2026-03-02 10:50:57.589908+08","success_rate":"","comment":"\u684c\u9762\u4e91","contract_type":1,"progress_updated_at":"2026-03-02 10:50:57.589908+08","forecast_updated_at":"2026-03-02 10:50:57.589908+08","end_at":"","pinyin_shortcut":"yzm2026","creator":1011,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"5000.0000000000000000","remain":"94 days 02:03:22.474317","progress_remain":"94 days 02:03:22.474317","forecast_remain":"94 days 02:03:22.474317","lost_contact_days":"94.0863433359375","last_contact":"2026-03-02 10:50:00","last_arrive_days":"","last_arrive":"","duration":"95 days 21:58:53.148634","issued_invoices":"","client":{"id":3449,"key":3449,"name":"\u9c81\u4fe1\u5929\u5730\u4eba\u73af\u5883\u79d1\u6280\uff08\u5b89\u5fbd\uff09\u96c6\u56e2\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":16,"sales_rep":5300},"usedClient":{},"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"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4109,"client_id":2128,"project_status":2,"project_progress":2,"budget":"516000","profit_pct":"25","bargain_date":"2026-06-30","description":"","created_by":5087,"created_at":"2026-01-18 20:32:27","updated_at":"2026-03-22 19:37:00","engineer_id":"","project_title":"\u865a\u62df\u684c\u9762\u5efa\u8bbe-K","collected":"0","status_updated_at":"2026-01-18 20:32:27.86405+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-18 20:32:27.86405+08","forecast_updated_at":"2026-01-18 20:32:27.86405+08","end_at":"","pinyin_shortcut":"xnzmjsK","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"129000.0000000000000000","remain":"136 days 16:21:52.200175","progress_remain":"136 days 16:21:52.200175","forecast_remain":"136 days 16:21:52.200175","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"136 days 16:21:52.200175","issued_invoices":"","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectRemindReceivers":[{"id":2083,"user_id":1001,"key":1001,"project_id":4109,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4088,"client_id":3179,"project_status":2,"project_progress":3,"budget":"20000","profit_pct":"10","bargain_date":"2026-06-30","description":"","created_by":5300,"created_at":"2026-01-04 11:29:52","updated_at":"2026-03-23 10:34:19","engineer_id":"","project_title":"\u5907\u4efd\u65b9\u6848\u65b0\u8d2d-2025","collected":"0","status_updated_at":"2026-01-12 10:23:47.700022+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-12 10:23:47.700022+08","forecast_updated_at":"2026-01-12 10:23:47.700022+08","end_at":"","pinyin_shortcut":"bffaxg2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"2000.0000000000000000","remain":"143 days 02:30:32.364203","progress_remain":"143 days 02:30:32.364203","forecast_remain":"143 days 02:30:32.364203","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"151 days 01:24:27.6696","issued_invoices":"","client":{"id":3179,"key":3179,"name":"\u4e2d\u79d1\u9a6d\u6570\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":57,"sales_rep":5300},"usedClient":{},"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"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectRemindReceivers":[{"id":2049,"user_id":1001,"key":1001,"project_id":4088,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":2050,"user_id":1005,"key":1005,"project_id":4088,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4083,"client_id":85,"project_status":2,"project_progress":5,"budget":"270000","profit_pct":"100","bargain_date":"2026-06-30","description":"","created_by":5087,"created_at":"2025-12-22 00:03:52","updated_at":"2026-03-22 19:36:19","engineer_id":"","project_title":"\u5b58\u50a8\u7eed\u4fdd-k","collected":"0","status_updated_at":"2025-12-22 00:41:41.848711+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2025-12-22 00:41:41.848711+08","forecast_updated_at":"2025-12-22 00:41:41.848711+08","end_at":"","pinyin_shortcut":"ccxbk","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"270000.0000000000000000","remain":"164 days 12:12:38.215514","progress_remain":"164 days 12:12:38.215514","forecast_remain":"164 days 12:12:38.215514","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"164 days 12:50:27.574682","issued_invoices":"","client":{"id":85,"key":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240","logo":"","client_type":1,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectRemindReceivers":[{"id":2037,"user_id":1001,"key":1001,"project_id":4083,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":3976,"client_id":89,"project_status":2,"project_progress":3,"budget":"1000000","profit_pct":"10","bargain_date":"2026-06-30","description":"","created_by":1005,"created_at":"2025-09-19 16:57:30","updated_at":"2026-03-24 15:14:58","engineer_id":"","project_title":"\u865a\u62df\u5316\u6269\u5bb9\uff0c\u6838\u5fc3\u7f51\u7edc\u6539\u9020","collected":"0","status_updated_at":"2025-09-19 16:57:30.325713+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-09-19 16:57:30.325713+08","forecast_updated_at":"2025-09-19 16:57:30.325713+08","end_at":"","pinyin_shortcut":"xnhkrhxwlgz","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"100000.0000000000000000","remain":"257 days 19:56:49.738512","progress_remain":"257 days 19:56:49.738512","forecast_remain":"257 days 19:56:49.738512","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"257 days 19:56:49.738512","issued_invoices":"","client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","logo":"","client_type":6,"client_class":47,"client_industry":16,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":3778,"client_id":97,"project_status":2,"project_progress":9,"budget":"230000","profit_pct":"35.86","bargain_date":"2026-06-30","description":"","created_by":5300,"created_at":"2025-02-17 11:25:43","updated_at":"2026-03-24 09:51:43","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u8d85\u878d\u5408\u65b0\u8d2d-G-2026","collected":"0","status_updated_at":"2025-08-18 10:15:00.786909+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-18 10:15:00.786909+08","forecast_updated_at":"2025-08-18 10:15:00.786909+08","end_at":"","pinyin_shortcut":"sxfcrhxgG2026","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"82478.000000000000000000","remain":"290 days 02:39:19.277316","progress_remain":"290 days 02:39:19.277316","forecast_remain":"290 days 02:39:19.277316","lost_contact_days":"79.0773155581597","last_contact":"2026-03-17 11:03:00","last_arrive_days":"79.0773155581597","last_arrive":"2026-03-17 11:03:00+08","duration":"472 days 01:28:36.37466","issued_invoices":"","client":{"id":97,"key":97,"name":"\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u5c71\u897f\u534e\u745e\u7164\u4e1a\u6709\u9650\u516c\u53f8)","logo":"","client_type":5,"client_class":43,"client_industry":16,"sales_rep":5300},"usedClient":{},"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"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[{"id":2117,"user_id":1001,"key":1001,"project_id":3778,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true},{"id":4162,"client_id":2125,"project_status":2,"project_progress":5,"budget":"1000000","profit_pct":"40","bargain_date":"2026-06-01","description":"","created_by":5087,"created_at":"2026-04-01 23:09:58","updated_at":"2026-04-01 23:09:58","engineer_id":"","project_title":"26\u5e74\u667a\u80fd\u4f53\u91c7\u8d2d\u9879\u76ee","collected":"0","status_updated_at":"2026-04-01 23:09:58.928848+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-04-01 23:09:58.928848+08","forecast_updated_at":"2026-04-01 23:09:58.928848+08","end_at":"","pinyin_shortcut":"26nzntcgxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"400000.0000000000000000","remain":"63 days 13:44:21.135377","progress_remain":"63 days 13:44:21.135377","forecast_remain":"63 days 13:44:21.135377","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"63 days 13:44:21.135377","issued_invoices":"","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087},"usedClient":{},"salesRep":{"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"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_update":true,"can_delete":true}],"list3count":0,"list3sum":"","list3":[],"list4count":0,"list4sum":"","list4":[],"list5count":0,"list5sum":"","list5":[],"list6count":0,"list6sum":"","list6":[],"thisUser":{"id":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"can_create":true,"pagenation":{"totalcount":67,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-04 12:54:20', 353187840) RETURNING "id"

[+] Explain