6a1ea85dcb030: POST https://beta.jinchangxiao.com/vue/project/list-all-status at 2026-06-02 05:54:37 pm by 221.216.117.119
Performance Profiling
Total processing time: 1,028 ms; Peak memory: 5.622 MB. Show Profiling Timeline
总计41条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 17:54:38.762 | 44.8 ms | yii\db\Command::query | 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 17:54:38.653 | 41.1 ms | yii\db\Command::query | 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 17:54:38.493 | 33.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 17:54:38.591 | 32.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 17:54:38.704 | 29.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 17:54:38.624 | 28.4 ms | yii\db\Command::query | SELECT 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 17:54:38.735 | 26.8 ms | yii\db\Command::query | SELECT 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 17:54:38.564 | 9.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) 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" |
| 17:54:38.581 | 9.8 ms | yii\db\Command::query | 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) 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 |
| 17:54:38.833 | 9.6 ms | yii\db\Command::query | 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) 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 |
| 17:54:38.815 | 8.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) 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" |
| 17:54:38.824 | 8.2 ms | yii\db\Command::query | SELECT 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) 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" |
| 17:54:38.540 | 6.5 ms | yii\db\Command::query | 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 17:54:38.574 | 6.2 ms | yii\db\Command::query | SELECT 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) 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" |
| 17:54:38.527 | 6.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 17:54:38.558 | 5.7 ms | yii\db\Command::query | 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 17:54:38.534 | 5.5 ms | yii\db\Command::query | SELECT 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 17:54:38.547 | 4.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 17:54:38.553 | 4.5 ms | yii\db\Command::query | SELECT 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, 5409, 5412, 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 (("p"."project_status"='4') OR ("p"."project_status"='5')) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 17:54:38.850 | 4.1 ms | yii\db\Command::query | INSERT 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":{"project_status":["4","5"],"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":"cqWl2v7GSsFZQDbn2ClfzlZKmEsRTESj"}', '{"code":2000,"result":{"list1count":0,"list1sum":"","list1":[],"list2count":0,"list2sum":"","list2":[],"list3count":0,"list3sum":"","list3":[],"list4count":472,"list4sum":"176920434.10","list4":[{"id":4137,"client_id":3454,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5295,"created_at":"2026-03-10 13:49:38","updated_at":"2026-03-16 13:52:51","engineer_id":"","project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260310001","collected":"0","status_updated_at":"2026-03-16 13:52:51.280374+08","success_rate":"","comment":"\u6df1\u4fe1\u670d\u684c\u9762\u4e91","contract_type":"","progress_updated_at":"2026-03-10 13:49:38.45277+08","forecast_updated_at":"2026-03-10 13:49:38.45277+08","end_at":"2026-03-16 13:52:51","pinyin_shortcut":"xsxssc20260310001","creator":1011,"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":"78 days 04:01:47.375033","progress_remain":"84 days 04:05:00.202637","forecast_remain":"84 days 04:05:00.202637","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"6 days 00:03:12.827604","issued_invoices":"","client":{"id":3454,"key":3454,"name":"\u7a37\u5c71\u53bf\u5b89\u536b\u58eb\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":5295},"usedClient":{},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":4040,"client_id":3423,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5295,"created_at":"2025-11-10 10:04:06","updated_at":"2025-11-24 14:09:11","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-11-24 14:09:11.173476+08","success_rate":"","comment":"2025\/11\/6\u636e\u5317\u4eac\u661f\u5149\u88d5\u534e\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8IT\u90e8\u7ecf\u7406\u97e9\u6674\u4ecb\u7ecd\uff1a\u516c\u53f8\u4f7f\u7528\u534e\u4e3a\uff0c\u534e\u4e09\u4ea7\u54c1\uff0c\u516c\u53f8\u662f\u505a\u667a\u80fd\u56ed\u533a\uff0c\u667a\u80fd\u667a\u6167\u57ce\u5e02\u7684\uff0c\u516c\u53f8\u57282026\u5e74\u4e0a\u534a\u5e74\u4f1a\u91c7\u8d2d\u4ea4\u6362\u673a\uff0c\u9632\u706b\u5899\u9700\u6c42\uff0c\u9884\u7b97\u5728\u4e0a\u767e\u4e07\uff0c\u628a\u8d44\u6599\u53d1\u5fae\u4fe1\u4e0a\uff0c\u540e\u7eed\u4f1a\u7ed9\u63d0\u4f9b\u53c2\u6570\uff0c\u53ef\u4ee5\u63d0\u4f9b\u8be6\u7ec6\u7684\u53c2\u6570\u62a5\u4ef7\uff0c\u63d0\u4f9b\u4ea7\u54c1\u6027\u80fd\uff0c\u5ba2\u6237\u6765\u8bc4\u4f30\u7528\u5728\u4ec0\u4e48\u9879\u76ee\u4e0a\uff0c\u540c\u610f\u540e\u671f\u9500\u552e\u8054\u7cfb\uff0c\u624b\u673a\u53f7:1368311885\u90ae\u7bb1\uff1a1763902513@qq.com","contract_type":"","progress_updated_at":"2025-11-10 10:04:06.664305+08","forecast_updated_at":"2025-11-10 10:04:06.664305+08","end_at":"2025-11-24 14:09:11","pinyin_shortcut":"wsz","creator":1011,"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":"190 days 03:45:27.481931","progress_remain":"204 days 07:50:31.991102","forecast_remain":"204 days 07:50:31.991102","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"14 days 04:05:04.509171","issued_invoices":"","client":{"id":3423,"key":3423,"name":"\u5317\u4eac\u661f\u5149\u88d5\u534e\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8-\u96c6\u6210\u5546","logo":"","client_type":5,"client_class":43,"client_industry":5,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":4035,"client_id":3419,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5295,"created_at":"2025-11-07 14:52:26","updated_at":"2025-12-15 16:12:37","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-12-15 16:12:37.49868+08","success_rate":"","comment":"2025\/11\/5\u636e\u5317\u4eac\u7b51\u9f99\u4f1f\u4e1a\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6570\u636e\u90e8\u7ecf\u7406\u53f2\u6590\u534e\u4ecb\u7ecd\uff1a\u516c\u53f8\u6709\u4f7f\u7528\u7f51\u7edc\u5b89\u5168\u4ea7\u54c1\uff0c\u5bf9\u5916\u7684\u90a3\u4e9b\u6570\u636e\u8f93\u51fa\u8bbf\u95ee\u7b56\u7565\u6709\u6570\u636e\u8d44\u6599\u6cc4\u9732\u51fa\uff0c\u54ea\u5bb6\u7684\u4e0d\u65b9\u4fbf\u900f\u9732\uff0c\u516c\u53f8\u57282026\u5e743-4\u6708\u4efd\u6709\u53ef\u80fd\u4f1a\u91c7\u8d2d\u9632\u706b\u5899\uff0c\u4ea4\u6362\u673a\uff0c\u8def\u7531\u5668\uff0c\u5343\u5146\u7aef\u53e3\uff0c\u9884\u7b97\u672a\u5b9a\uff0c\u91c7\u8d2d\u4e2d\u53ef\u4ee5\u505a\u51b3\u5b9a\uff0c\u540e\u671f\u8003\u8651\u6df1\u4fe1\u670d\u4ea7\u54c1\uff0c\u540c\u610f\u540e\u671f\u9500\u552e\u8054\u7cfb\uff0c\u624b\u673a\u53f7:18734837796\u90ae\u7bb1\uff1a410919623@qq.com","contract_type":"","progress_updated_at":"2025-11-07 14:52:26.145117+08","forecast_updated_at":"2025-11-07 14:52:26.145117+08","end_at":"2025-12-15 16:12:37","pinyin_shortcut":"wsz","creator":1011,"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":"169 days 01:42:01.156727","progress_remain":"207 days 03:02:12.51029","forecast_remain":"207 days 03:02:12.51029","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"38 days 01:20:11.353563","issued_invoices":"","client":{"id":3419,"key":3419,"name":"\u5317\u4eac\u7b51\u9f99\u4f1f\u4e1a\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":5295},"usedClient":{},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":4023,"client_id":3414,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5295,"created_at":"2025-10-28 10:41:29","updated_at":"2025-12-15 16:11:31","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-12-15 16:11:31.768651+08","success_rate":"","comment":"2025-10-23(\u5218\u6c5f)\u662f\u5317\u4eac\u8fea\u5b89\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8\u7684IT\u4eba\u5458\uff0c\u7b80\u5355\u4ecb\u7ecd\u6df1\u4fe1\u670d\u4e4b\u540e\uff0c\u5218\u7ecf\u7406\u8868\u793a\u5bf9\u6df1\u4fe1\u670d\u6ca1\u4ec0\u4e48\u5370\u8c61\u3002\u6c9f\u901a\u4e86\u89e3\u5230:\n1\u3001\u5317\u4eac\u8fd9\u8fb9\u6709\u672c\u5730\u673a\u623f\uff0c\u4f46\u662f\u5927\u90e8\u5206\u4e1a\u52a1\u7cfb\u7edf\u5728\u676d\u5dde\u603b\u90e8\uff0c\u672c\u5730\u4fdd\u7559\u4e86\u5c11\u91cf\u4e1a\u52a1\u548c\u529e\u516c\u7f51\uff0c\u51fa\u53e3\u6709\u9632\u706b\u589923\u5e74\u91c7\u8d2d\u7684\uff0c\u54c1\u724c\u672a\u544a\u77e5\u3002\u5317\u4eac\u516c\u53f8\u529e\u516c\u4eba\u5458\u5927\u7ea6300-400\u4eba\uff0c\u51fa\u53e3\u8fd8\u6ca1\u505a\u884c\u4e3a\u7ba1\u7406\u3002\n2\u3001\u4fe1\u606f\u5316\u5efa\u8bbe\u4eca\u5e74\u6682\u65f6\u6ca1\u6709\u5b89\u6392\uff0c\u4ecb\u7ecd\u4e86\u6211\u4e0e\u676d\u5dde\u603b\u90e8\u7684\u5408\u4f5c\n(EDR\\AF\\MSS\u7b49)\uff0c\u5218\u7ecf\u7406\u8868\u793a\u4ed6\u4eec\u660e\u5e74\u7684\u8ba1\u5212\u8981Q4\u5b63\u5ea6\u5f00\u5b8c\u4f1a\u786e\u5b9a\uff0c\u76ee\u524d\u6bd4\u8f83\u611f\u5174\u8da3\u7684\u4e3b\u8981\u5728\u6570\u636e\u9632\u6cc4\u5bc6\uff0c\u4e3b\u8981\u662f\u5728\u516c\u53f8\u4e0e\u533b\u9662\u4e4b\u95f4\u7684\u6570\u636e\u4f20\u8f93\u5b89\u5168\uff0c\u76ee\u524d\u4f7f\u7528\u7684\u662f\u4e13\u7ebf\uff0c\u4ecb\u7ecd\u4e86\u6df1\u4fe1\u670d\u5bf9\u4e8e\u4e0d\u540c\u5bc6\u7ea7\u7684\u6570\u636e\u9632\u6cc4\u5bc6\u7684\u65b9\u6848\uff0c\u5e76\u8868\u793a\u671f\u5f85\u80fd\u5230\u5ba2\u6237\u5355\u4f4d\u62dc\u8bbf\u4ea4\u6d41\uff0c\u5218\u7ecf\u7406\u8868\u793a\u53ef\u4ee5\u7b49\u4ed6\u4eecQ4\u4f1a\u8bae\u540e\u8fc7\u53bb\u3002","contract_type":"","progress_updated_at":"2025-10-28 10:41:29.898471+08","forecast_updated_at":"2025-10-28 10:41:29.898471+08","end_at":"2025-12-15 16:11:31","pinyin_shortcut":"wsz","creator":1011,"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":"169 days 01:43:06.886756","progress_remain":"217 days 07:13:08.756936","forecast_remain":"217 days 07:13:08.756936","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"48 days 05:30:01.87018","issued_invoices":"","client":{"id":3414,"key":3414,"name":"\u5317\u4eac\u8fea\u5b89\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":3,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":4022,"client_id":3413,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5295,"created_at":"2025-10-28 10:39:51","updated_at":"2025-11-24 14:08:46","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-11-24 14:08:46.068578+08","success_rate":"","comment":"2025-10-22(\u6768\u5065)\u662f\u5317\u4eac\u6c11\u822a\u8bbe\u8ba1\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\u7684IT\u540c\u4e8b\uff0c\u5148\u524d\u6ca1\u6709\u63a5\u89e6\u8fc7\u6df1\u4fe1\u670d\uff0c\u7b80\u5355\u505a\u4e86\u4e00\u4e0b\u4ecb\u7ecd\u3002\u6768\u7ecf\u7406\u8868\u793a\u4ed6\u4eec\u516c\u53f8\u89c4\u6a21\u4e0d\u5927\uff0c\u4e3b\u8981\u662f\u8bbe\u8ba1\u7c7b\u578b\u7684\u516c\u53f8\uff0c\u6570\u636e\u9632\u6cc4\u5bc6\u548c\u9632\u52d2\u7d22\u8fd9\u4e9b\u6709\u7b80\u5355\u505a\u8fc7\uff0c\u4f46\u9ad8\u9636\u7684\u4ea7\u54c1\u548c\u65b9\u6848\u6ca1\u6709\u505a\u8fc7;\u76ee\u524d\u6682\u65f6\u6ca1\u6709\u8fc7\u591a\u9700\u6c42\u3002\u9664\u4e86\u7f51\u7edc\u5b89\u5168\uff0c\u5728\u4e91\u8ba1\u7b97\u65b9\u9762\u6768\u7ecf\u7406\u8868\u793a\u5e94\u8be5\u4f1a\u6709\u4e00\u4e9b\u9700\u6c42\uff0c\u4ed6\u4eec\u5728\u7ed9\u5ba2\u6237\u9879\u76ee\u8fc7\u7a0b\u4e2d\u4f1a\u7ed9\u5ba2\u6237\u505a\u4e91\u8ba1\u7b97\u7684\u65b9\u6848\uff0c\u53ef\u4ee5\u5148\u53d1\u8d44\u6599\u770b\u770b\uff0c\u63d0\u51fa\u5230\u6768\u7ecf\u7406\u5355\u4f4d\u62dc\u8bbf\uff0c\u6768\u7ecf\u7406\u8868\u793a\u76ee\u524d\u6ca1\u5728\u5317\u4eac\uff0c\u9700\u898112\u6708\u624d\u56de\u3002\u5148\u52a0\u5fae\u4fe1\uff0c\u4fdd\u6301\u8054\u7cfb\u3002","contract_type":"","progress_updated_at":"2025-10-28 10:39:51.936048+08","forecast_updated_at":"2025-10-28 10:39:51.936048+08","end_at":"2025-11-24 14:08:46","pinyin_shortcut":"wsz","creator":1011,"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":"190 days 03:45:52.586829","progress_remain":"217 days 07:14:46.719359","forecast_remain":"217 days 07:14:46.719359","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"27 days 03:28:54.13253","issued_invoices":"","client":{"id":3413,"key":3413,"name":"\u534e\u8bbe\u8bbe\u8ba1\u96c6\u56e2\u5317\u4eac\u6c11\u822a\u8bbe\u8ba1\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8-\u96c6\u6210\u5546","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":4021,"client_id":3412,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5300,"created_at":"2025-10-28 10:37:36","updated_at":"2025-12-15 16:29:28","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-12-15 16:29:28.536391+08","success_rate":"","comment":"2025-10-23(\u6768\u6e24)\u662f\u6768\u7ecf\u7406\u672c\u4eba\uff0c\u5df2\u7ecf\u4ece\u4e03\u661f\u534e\u7535\u79d1\u6280\u79bb\u804c\uff0c\u76ee\u524d\u5728\u4e2d\u94f6\u96c6\u56e2\u4e5f\u662f\u4ece\u4e8bIT\u884c\u4e1a\u5185\u5de5\u4f5c\u3002\u77e5\u9053\u4e2d\u94f6\u6709\u4f7f\u7528\u6211\u53f8\u7684\u9632\u706b\u5899\uff0c\u6768\u7ecf\u7406\u8fd9\u8fb9\u4e3b\u8981\u8d1f\u8d23\u53f8\u5e93\u65b9\u9762\u7684\u5de5\u4f5c\uff0c\u60f3\u770b\u4e00\u4e0b\u6211\u53f8\u662f\u5426\u6709\u76f8\u5173\u7684\u4ea7\u54c1\u80fd\u591f\u4ecb\u7ecd\u63a8\u8350\uff0c\u5408\u9002\u7684\u8bdd\u53ef\u4ee5\u78b0\u4e2a\u9762\u4ea4\u6d41\u4e0b\u3002\u8981\u6211\u5148\u52a0\u5fae\u4fe1\uff0c\u628a\u9700\u6c42\u53d1\u8fc7\u6765\u3002---\u5fae\u4fe1\u672a\u901a\u8fc7\n(\u8be5\u5ba2\u6237\u5df2\u4ece\u4e03\u661f\u534e\u7535\u79bb\u804c\uff0c\u8868\u793a\u5728\u4e2d\u94f6\u96c6\u56e2\uff0c\u4f46\u5ba2\u6237\u540d\u79f0\u9700\u8fdb\u884c\u6838\u5b9e\uff0c\u77e5\u6089!)","contract_type":"","progress_updated_at":"2025-10-28 10:37:36.135183+08","forecast_updated_at":"2025-10-28 10:37:36.135183+08","end_at":"2025-12-15 16:29:28","pinyin_shortcut":"wsz","creator":1011,"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":"169 days 01:25:10.119016","progress_remain":"217 days 07:17:02.520224","forecast_remain":"217 days 07:17:02.520224","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"48 days 05:51:52.401208","issued_invoices":"","client":{"id":3412,"key":3412,"name":"\u4e2d\u94f6\u96c6\u56e2","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":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":4019,"client_id":3410,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5295,"created_at":"2025-10-27 17:00:20","updated_at":"2025-12-15 16:11:22","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-12-15 16:11:22.147193+08","success_rate":"","comment":"2025\/10\/24\u5317\u4eac\u4e09\u535a\u8111\u79d1\u533b\u9662\u6709\u9650\u516c\u53f8\u7f51\u7edc\u5b89\u5168\u90e8\u8d1f\u8d23\u4eba\u6881\u6653\u660e\u4ecb\u7ecd\uff1a\u516c\u53f8\u6709\u4f7f\u7528\u76f8\u5173\u7f51\u7edc\u5b89\u5168\u4ea7\u54c1\uff0c\u76ee\u524d\u60f3\u4e86\u89e3\u6df1\u4fe1\u670d\u7684\u7f51\u95f8\u8ddf\u4e0b\u4e00\u4ee3\u9632\u706b\u5899\uff0c\u540e\u7eed\u9632\u706b\u5899\u5927\u6982\u91c7\u8d2d5-6\u53f0\uff0c\u5408\u9002\u7684\u8bdd\u968f\u65f6\u91c7\u8d2d\uff0c\u9884\u7b97\u6839\u636e\u5b9e\u9645\u91c7\u8d2d\u4e3a\u51c6\uff0c\u662f\u5efa\u8bae\u4eba\uff0c\u53ef\u53d1\u76f8\u5173\u8d44\u6599,\u8054\u7cfb\u8868\u793a\u60f3\u5148\u4e86\u89e3\u6df1\u4fe1\u670d\u7684\u4ea7\u54c1\u662f\u5426\u6ee1\u8db3\u516c\u53f8\u9700\u6c42\uff0c\u770b\u8fc7\u4e4b\u540e\u518d\u5efa\u8054\u3002\u624b\u673a\uff1a13810960728\uff08\u540c\u5fae\u4fe1\uff09\u90ae\u7bb1\uff1a76835437@qq.com\u3002","contract_type":"","progress_updated_at":"2025-10-27 17:00:20.676034+08","forecast_updated_at":"2025-10-27 17:00:20.676034+08","end_at":"2025-12-15 16:11:22","pinyin_shortcut":"wsz","creator":1011,"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":"169 days 01:43:16.508214","progress_remain":"218 days 00:54:17.979373","forecast_remain":"218 days 00:54:17.979373","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"48 days 23:11:01.471159","issued_invoices":"","client":{"id":3410,"key":3410,"name":"\u5317\u4eac\u4e09\u535a\u8111\u79d1\u533b\u9662\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":3,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":4013,"client_id":3409,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5300,"created_at":"2025-10-21 09:47:20","updated_at":"2025-12-15 16:29:26","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-12-15 16:29:26.101936+08","success_rate":"","comment":"2025\/10\/17 \u636e\u65e5\u7535\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8IT\u90e8\u7ecf\u7406\u5218\u80dc\u5229\u4ecb\u7ecd\uff1a\u516c\u53f8\u6709\u4f7f\u7528\u6df1\u4fe1\u670d\u4ea7\u54c1\u548c\u5176\u4ed6\u54c1\u724c\uff0c\u516c\u53f82026\u65b0\u5efa\u6570\u636e\u5e93\u4e2d\u5fc3\u4f1a\u4f7f\u7528\u9632\u706b\u5899\uff0c\u4ea4\u6362\u673a\u6210\u5957\u7684\u4ea7\u54c1\uff0c\u9879\u76ee\u5df2\u7acb\u9879\uff0c\u73b0\u5728\u6b63\u5728\u88c5\u4fee\uff0c\u4ec0\u4e48\u65f6\u5019\u91c7\u4e70\u5f97\u770b\u9879\u76ee\u88c5\u4fee\u8fdb\u5ea6\uff0c\u9884\u7b97\u6839\u636e\u91c7\u8d2d\u9700\u6c42\u5b9a\uff0c\u6709\u4e00\u90e8\u5206\u662f\u81ea\u4e3b\u91c7\u8d2d\uff0c\u6709\u4e00\u90e8\u5206\u662f\u7edf\u4e00\u91c7\u8d2d\uff0c\u9009\u578b\u4e2d\u53ef\u4ee5\u63d0\u5efa\u8bae\uff0c\u540e\u671f\u4f1a\u8003\u8651\u6df1\u4fe1\u670d\uff0c\u540e\u671f\u540c\u610f\u540e\u671f\u9500\u552e\u8054\u7cfb\uff0c\u624b\u673a\u53f7:13621231614\u90ae\u7bb1\uff1a402637126@qq.com","contract_type":"","progress_updated_at":"2025-10-21 09:47:20.540749+08","forecast_updated_at":"2025-10-21 09:47:20.540749+08","end_at":"2025-12-15 16:29:26","pinyin_shortcut":"wsz","creator":1011,"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":"169 days 01:25:12.553471","progress_remain":"224 days 08:07:18.114658","forecast_remain":"224 days 08:07:18.114658","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"55 days 06:42:05.561187","issued_invoices":"","client":{"id":3409,"key":3409,"name":"\u65e5\u7535\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":10,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":3715,"client_id":3320,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":1004,"created_at":"2024-11-14 12:52:56","updated_at":"2024-11-17 18:02:34","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2024-11-17 18:02:34.43606+08","success_rate":"","comment":"\u7fa4\u6656\u5b58\u50a8\u5916\u52a0\u5185\u5b58\u548c\u786c\u76d8","contract_type":"","progress_updated_at":"2024-11-14 12:52:56.657952+08","forecast_updated_at":"2024-11-14 12:52:56.657952+08","end_at":"2024-11-17 18:02:34","pinyin_shortcut":"wsz","creator":5413,"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":"561 days 23:52:04.219347","progress_remain":"565 days 05:01:41.997455","forecast_remain":"565 days 05:01:41.997455","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"3 days 05:09:37.778108","issued_invoices":"","client":{"id":3320,"key":3320,"name":"\u56fd\u5bb6\u6c14\u5019\u4e2d\u5fc3","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":3711,"client_id":3318,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":1004,"created_at":"2024-11-12 11:31:02","updated_at":"2024-11-17 18:02:27","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2024-11-17 18:02:27.68113+08","success_rate":"","comment":"\u5b58\u50a8\u8bbe\u5907","contract_type":"","progress_updated_at":"2024-11-12 11:31:02.097807+08","forecast_updated_at":"2024-11-12 11:31:02.097807+08","end_at":"2024-11-17 18:02:27","pinyin_shortcut":"wsz","creator":5413,"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":"561 days 23:52:10.974277","progress_remain":"567 days 06:23:36.5576","forecast_remain":"567 days 06:23:36.5576","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"5 days 06:31:25.583323","issued_invoices":"","client":{"id":3318,"key":3318,"name":"\u4f5c\u5bb6\u51fa\u7248\u793e\u6709\u9650\u516c\u53f8","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":3668,"client_id":3306,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5300,"created_at":"2024-09-23 10:22:46","updated_at":"2024-10-17 14:53:48","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2024-09-29 18:46:27.236074+08","success_rate":"","comment":"\u5185\u5bb9\u9632\u62a4\uff0c\u9632\u5fa1\uff0c\u706b\u773c","contract_type":"","progress_updated_at":"2024-09-23 10:22:46.834714+08","forecast_updated_at":"2024-09-23 10:22:46.834714+08","end_at":"2024-09-29 18:46:27","pinyin_shortcut":"wsz","creator":5413,"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":"610 days 23:08:11.419333","progress_remain":"617 days 07:31:51.820693","forecast_remain":"617 days 07:31:51.820693","lost_contact_days":"616.269197400544","last_contact":"2024-09-24 11:27:00","last_arrive_days":"616.269197400544","last_arrive":"2024-09-24 11:27:00+08","duration":"6 days 08:23:40.40136","issued_invoices":"","client":{"id":3306,"key":3306,"name":"\u5317\u4eac\u534e\u6052\u4fe1\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":3369,"client_id":2716,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5329,"created_at":"2023-11-22 10:38:58","updated_at":"2023-11-27 10:52:17","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2023-11-27 10:52:17.158561+08","success_rate":"","comment":"\u7fa4\u6656\u786c\u76d8\n","contract_type":"","progress_updated_at":"2023-11-22 10:38:58.184873+08","forecast_updated_at":"2023-11-22 10:38:58.184873+08","end_at":"2023-11-27 10:52:17","pinyin_shortcut":"wsz","creator":5015,"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":"918 days 07:02:21.496846","progress_remain":"923 days 07:15:40.470534","forecast_remain":"923 days 07:15:40.470534","lost_contact_days":"923.253225178322","last_contact":"2023-11-22 11:50:00","last_arrive_days":"","last_arrive":"","duration":"5 days 00:13:18.973688","issued_invoices":"","client":{"id":2716,"key":2716,"name":"\u4e2d\u56fd\u91d1\u878d\u57f9\u8bad\u4e2d\u5fc3","logo":"","client_type":"","client_class":"","client_industry":"","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":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":3262,"client_id":2565,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u7fa4\u6656\u5b58\u50a8","created_by":5329,"created_at":"2023-07-20 09:31:32","updated_at":"2024-01-26 18:11:35","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2023-07-24 11:02:58.578771+08","success_rate":"","comment":"\u7fa4\u6656\u5b58\u50a8\r\n","contract_type":"","progress_updated_at":"2023-07-20 09:31:32.375546+08","forecast_updated_at":"2023-07-20 09:31:32.375546+08","end_at":"2024-01-26 18:11:35","pinyin_shortcut":"wsz","creator":5015,"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":"0.00000000000000000000","remain":"1044 days 06:51:40.076636","progress_remain":"1048 days 08:23:06.279861","forecast_remain":"1048 days 08:23:06.279861","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"190 days 08:40:03.311675","issued_invoices":"","client":{"id":2565,"key":2565,"name":"\u4e2d\u56fd\u4fe1\u606f\u79d1\u5b66\u4e2d\u5fc3\uff08\u96c6\u6210\u5546\uff09","logo":"","client_type":5,"client_class":43,"client_industry":20,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":3094,"client_id":2504,"project_status":4,"project_progress":2,"budget":"0","profit_pct":"0","bargain_date":"","description":"\u7269\u8054\u7f51\u5b89\u5168\n","created_by":1005,"created_at":"2023-01-31 10:07:58","updated_at":"2023-02-06 17:47:26","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2023-02-06 17:46:56.197168+08","success_rate":"","comment":"\u7269\u8054\u7f51\u5b89\u5168\n\r\n\u8054\u7cfb\u4e0d\u4e0a\u5ba2\u6237","contract_type":"","progress_updated_at":"2023-02-05 22:24:30.988626+08","forecast_updated_at":"2023-02-06 17:46:56.197168+08","end_at":"2023-02-06 17:47:26","pinyin_shortcut":"wsz","creator":5015,"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":"1212 days 00:07:42.458239","progress_remain":"1212 days 19:30:07.666781","forecast_remain":"1212 days 00:07:42.458239","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"6 days 07:39:28.222332","issued_invoices":"","client":{"id":2504,"key":2504,"name":"\u6d77\u5c14\u79d1\u6280","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":""},"usedClient":{},"salesRep":"","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":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"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":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":2967,"client_id":2241,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"Netapp\u5b58\u50a8FAS8300","created_by":5295,"created_at":"2022-08-30 11:53:43","updated_at":"2022-09-05 19:06:04","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-09-05 19:06:04.880814+08","success_rate":"","comment":"Netapp\u5b58\u50a8FAS8300\r\n","contract_type":"","progress_updated_at":"2022-08-30 11:53:43.050918+08","forecast_updated_at":"2022-08-30 11:53:43.050918+08","end_at":"2022-09-05 19:06:04","pinyin_shortcut":"wsz","creator":1011,"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":"1365 days 22:48:33.774593","progress_remain":"1372 days 06:00:55.604489","forecast_remain":"1372 days 06:00:55.604489","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"6 days 07:12:21.829896","issued_invoices":"","client":{"id":2241,"key":2241,"name":"\u5317\u4eac\u667a\u82af\u4eff\u771f\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":2966,"client_id":2240,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u5355\u4f4d\u8981\u505a\u7f51\u7edc\u5b89\u5168\u7684\u90e8\u7f72\uff0c2023\u5e74\u4e0a\u534a\u5e74\u9700\u8981\u91c7\u8d2d\u9632\u706b\u5899\u548c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\uff0c\u7528\u4e8e\u6570\u636e\u4e2d\u5fc3\u5b89\u5168\u52a0\u56fa\uff0c10\u53f0\u5de6\u53f3\u670d\u52a1\u5668\uff0c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u4e3b\u8981\u89e3\u51b3\u4e0a\u7f51\u884c\u4e3a\u5ba1\u8ba1\u3001\u6d41\u91cf\u9650\u5236\u3001\u6587\u4ef6\u9632\u6cc4\u5bc6\uff0c\u7ba1\u63a7300\u4e2a\u4fe1\u606f\u70b9\u5185\uff0c\u5e26\u5bbd\u662f500\u5146\uff0c\u8003\u8651\u6df1\u4fe1\u670d\u4ea7\u54c1\uff1b\u5e74\u5e95\u505a\u8ba1\u5212\uff0c\u9884\u7b9750\u4e07\u5de6\u53f3","created_by":5295,"created_at":"2022-08-30 09:23:04","updated_at":"2022-09-05 19:06:41","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-09-05 19:06:41.544038+08","success_rate":"","comment":"\u5355\u4f4d\u8981\u505a\u7f51\u7edc\u5b89\u5168\u7684\u90e8\u7f72\uff0c2023\u5e74\u4e0a\u534a\u5e74\u9700\u8981\u91c7\u8d2d\u9632\u706b\u5899\u548c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\uff0c\u7528\u4e8e\u6570\u636e\u4e2d\u5fc3\u5b89\u5168\u52a0\u56fa\uff0c10\u53f0\u5de6\u53f3\u670d\u52a1\u5668\uff0c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u4e3b\u8981\u89e3\u51b3\u4e0a\u7f51\u884c\u4e3a\u5ba1\u8ba1\u3001\u6d41\u91cf\u9650\u5236\u3001\u6587\u4ef6\u9632\u6cc4\u5bc6\uff0c\u7ba1\u63a7300\u4e2a\u4fe1\u606f\u70b9\u5185\uff0c\u5e26\u5bbd\u662f500\u5146\uff0c\u8003\u8651\u6df1\u4fe1\u670d\u4ea7\u54c1\uff1b\u5e74\u5e95\u505a\u8ba1\u5212\uff0c\u9884\u7b9750\u4e07\u5de6\u53f3\r\n","contract_type":"","progress_updated_at":"2022-08-30 09:23:04.941315+08","forecast_updated_at":"2022-08-30 09:23:04.941315+08","end_at":"2022-09-05 19:06:41","pinyin_shortcut":"wsz","creator":5298,"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":"1365 days 22:47:57.111369","progress_remain":"1372 days 08:31:33.714092","forecast_remain":"1372 days 08:31:33.714092","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"6 days 09:43:36.602723","issued_invoices":"","client":{"id":2240,"key":2240,"name":"\u5317\u4eac\u4e2d\u5e86\u878d\u901a\u6295\u8d44\u57fa\u91d1\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":2871,"client_id":2196,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"RS820+ ","created_by":5295,"created_at":"2022-06-13 14:59:22","updated_at":"2022-06-15 10:04:23","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-06-15 10:04:23.618069+08","success_rate":"","comment":"RS820+ \r\n","contract_type":"","progress_updated_at":"2022-06-13 14:59:22.472093+08","forecast_updated_at":"2022-06-13 14:59:22.472093+08","end_at":"2022-06-15 10:04:23","pinyin_shortcut":"wsz","creator":5015,"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":"1448 days 07:50:15.037338","progress_remain":"1450 days 02:55:16.183314","forecast_remain":"1450 days 02:55:16.183314","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"1 day 19:05:01.145976","issued_invoices":"","client":{"id":2196,"key":2196,"name":"\u5317\u4eac\u4e09\u805a\u73af\u4fdd\u65b0\u6750\u6599\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":20,"sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":2675,"client_id":1509,"project_status":4,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"vmware\u865a\u62df\u5316\u96c6\u7fa4","created_by":5329,"created_at":"2021-10-27 12:06:59","updated_at":"2022-10-24 16:15:07","engineer_id":"","project_title":"\u89e3\u51b3\u670d\u52a1\u5668\u96be\u7ba1\u7406\u95ee\u9898","collected":"0","status_updated_at":"2022-10-24 16:15:07.719968+08","success_rate":"","comment":"vmware\u865a\u62df\u5316\u96c6\u7fa4\r\n10\u53f0\u8001\u65e7\u8bbe\u5907\uff0c\u4e3b\u8981\u505a\u8f6f\u4ef6\u6d4b\u8bd5\u5f00\u53d1\uff0c\u7ba1\u7406\u96be\u5ea6\u5927\u3002","contract_type":"","progress_updated_at":"2022-05-20 17:13:02.176769+08","forecast_updated_at":"2022-05-20 17:13:02.176769+08","end_at":"2022-10-24 16:15:07","pinyin_shortcut":"jjfwqnglwt","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":"0.00000000000000000000","remain":"1317 days 01:39:30.935439","progress_remain":"1474 days 00:41:36.478638","forecast_remain":"1474 days 00:41:36.478638","lost_contact_days":"1635.17822517832","last_contact":"2021-12-10 13:38:00","last_arrive_days":"1635.17822517832","last_arrive":"2021-12-10 13:38:00+08","duration":"362 days 04:08:08.050927","issued_invoices":"","client":{"id":1509,"key":1509,"name":"\u4e2d\u79d1\u5927\u8111","logo":"","client_type":6,"client_class":43,"client_industry":1,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":2648,"client_id":656,"project_status":4,"project_progress":1,"budget":"30000","profit_pct":"10","bargain_date":"","description":"\u6df1\u4fe1\u670d\u9632\u706b\u5899 1\u53f0 \u9884\u7b9730000","created_by":5300,"created_at":"2021-09-06 15:47:07","updated_at":"2021-09-06 17:09:51","engineer_id":"","project_title":"\u6df1\u4fe1\u670dAF","collected":"0","status_updated_at":"2021-09-06 17:09:51.32576+08","success_rate":"","comment":"\u6df1\u4fe1\u670d\u9632\u706b\u5899 1\u53f0 \u9884\u7b9730000\r\n\u51b3\u7b56\u6d41\u7a0b\uff1a\n\u89e3\u51b3\u4ec0\u4e48\u95ee\u9898\uff1a\n\u7ade\u4e89\u5bf9\u624b\uff1a","contract_type":1,"progress_updated_at":"2021-09-06 15:47:07.395216+08","forecast_updated_at":"2021-09-06 15:47:07.395216+08","end_at":"2021-09-06 17:09:51","pinyin_shortcut":"sxfAF","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":"3000.0000000000000000","remain":"1730 days 00:44:47.329647","progress_remain":"1730 days 02:07:31.260191","forecast_remain":"1730 days 02:07:31.260191","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"01:22:43.930544","issued_invoices":"","client":{"id":656,"key":656,"name":"\u5317\u4eac\u58f0\u8fc5\u7535\u5b50\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":20,"sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"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":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":1,"key":1,"name":"\u521d\u76f8\u8bc6","description":"\u5411\u5ba2\u6237\u4ecb\u7ecd\u81ea\u8eab\u4ef7\u503c\uff1a\n1.\u4ea7\u54c1\u9009\u578b\n2.\u6210\u672c\u4f18\u5316\n3.\u4ea7\u54c1\u4ea4\u4ed8\n4.\u540e\u671f\u8fd0\u7ef4"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true},{"id":2559,"client_id":121,"project_status":4,"project_progress":2,"budget":"549696","profit_pct":"20","bargain_date":"","description":"\u601d\u79d1\u539f\u5382\u7eed\u4fdd","created_by":5295,"created_at":"2021-05-31 14:27:22","updated_at":"2022-04-06 12:57:08","engineer_id":"","project_title":"\u601d\u79d1\u539f\u5382\u7eed\u4fdd","collected":"0","status_updated_at":"2022-04-06 12:57:08.67104+08","success_rate":"","comment":"\u601d\u79d1\u539f\u5382\u7eed\u4fdd\r\n\u5931\u8d25\u539f\u56e0\uff1a\u4ef7\u683c\u9ad8\uff0c\u540e\u671f\u8bbe\u5907\u4e0d\u7528\u4e86","contract_type":2,"progress_updated_at":"2021-05-31 14:27:22.118932+08","forecast_updated_at":"2021-07-12 14:52:39.058352+08","end_at":"2022-04-06 12:57:08","pinyin_shortcut":"skycxb","creator":5295,"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":"109939.2000000000000000","remain":"1518 days 04:57:29.984367","progress_remain":"1828 days 03:27:16.536475","forecast_remain":"1786 days 03:01:59.597055","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"309 days 22:29:46.552108","issued_invoices":"","client":{"id":121,"key":121,"name":"\u56db\u5ddd\u6d77\u5e95\u635e\u9910\u996e\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u9890\u6d77(\u4e0a\u6d77)\u98df\u54c1\u6709\u9650\u516c\u53f8\u3001\u6d77\u9e3f\u8fbe\u3001\u90d1\u5dde\u8700\u6d77)","logo":"","client_type":1,"client_class":80,"client_industry":6,"sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"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":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"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":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_update":true,"can_delete":true}],"list5count":913,"list5sum":"365269837.27","list5":[{"id":4050,"client_id":3425,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5300,"created_at":"2025-11-21 15:35:28","updated_at":"2025-12-22 14:14:02","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-12-22 14:14:02.647874+08","success_rate":"","comment":"2025\/11\/21\u636e\u667a\u65b0\u672a\u6765\uff08\u5317\u4eac\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\u603b\u7ecf\u7406\u9ad8\u6d77\u9f99\u4ecb\u7ecd\uff1a\u516c\u53f8\u4f7f\u7528\u6df1\u4fe1\u670d\u4ea7\u54c1\uff0c\u57282026\u5e74\u7b2c\u4e8c\u5b63\u5ea6\u4f1a\u66ff\u6362\u5343\u5146\u7aef\u53e32\u5c42\u7684\u4ea4\u6362\u673a\uff0c\u5343\u5146\u7aef\u53e3\u9632\u706b\u5899\uff0c\u54047-8\u53f0\u5de6\u53f3\uff0c\u9884\u7b97100\u4e07\uff0c\u7528\u4e8e\u81ea\u5df1\u7684\u516c\u53f8\u548c\u5ba2\u6237\uff0c\u540c\u65f6\u516c\u53f8\u4e5f\u4f1a\u6709\u4e00\u4e9b\u9879\u76ee\u3002\u540c\u610f\u540e\u671f\u9500\u552e\u8054\u7cfb\uff0c\u624b\u673a\u53f7:18033699871\u90ae\u7bb1\uff1aggary@aliyun.com.com\u3002","contract_type":"","progress_updated_at":"2025-11-21 15:35:28.794836+08","forecast_updated_at":"2025-11-21 15:35:28.794836+08","end_at":"2025-12-22 14:14:02","pinyin_shortcut":"wsz","creator":1011,"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":"162 days 03:40:36.116537","progress_remain":"193 days 02:19:09.969575","forecast_remain":"193 days 02:19:09.969575","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"30 days 22:38:33.853038","issued_invoices":"","client":{"id":3425,"key":3425,"name":"\u667a\u65b0\u672a\u6765\uff08\u5317\u4eac\uff09\u4fe1\u606f\u79d1\u6280\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":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":4039,"client_id":3422,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":1005,"created_at":"2025-11-10 09:49:23","updated_at":"2025-12-21 22:35:18","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-12-21 22:35:18.03231+08","success_rate":"","comment":"2025\/11\/6\u636e\u5317\u4eac\u5929\u822a\u4fe1\u6c11\u822a\u901a\u4fe1\u7f51\u7edc\u53d1\u5c55\u6709\u9650\u516c\u53f8IT\u90e8\u7ecf\u7406\u5316\u5149\u4ecb\u7ecd\uff1a\u516c\u53f8\u4f7f\u7528\u7eff\u76df\u4ea7\u54c1\uff0c\u4f7f\u7528\u4e2d\u4f1a\u9047\u5230\u5361\u987f\uff0c\u9632\u62a4\u8ddf\u4e0d\u4e0a\u60c5\u51b5\uff0c\u57282025\u5e74\u5e74\u5e95\u4f1a\u66ff\u9632\u706b\u5899 IPS IDS\u6001\u52bf\u611f\u77e5 \u5343\u5146\u7aef\u53e3\u9632\u706b\u58997-8\u53f0\uff0c\u652f\u6301400-500\u7ec8\u7aef\uff0c\u9884\u7b97200\u4e07\u5de6\u53f3\uff0c\u5355\u4f4d\u662f\u81ea\u4e3b\u91c7\u8d2d\uff0c\u662f\u51b3\u7b56\u8005\uff0c\u540e\u671f\u4f1a\u8003\u8651\u6df1\u4fe1\u670d\u4ea7\u54c1\uff0c\u540c\u610f\u540e\u671f\u9500\u552e\u8054\u7cfb\uff0c\u624b\u673a\u53f7:13671227373\u90ae\u7bb1\uff1ash59299@sina.com","contract_type":"","progress_updated_at":"2025-11-10 09:49:23.162418+08","forecast_updated_at":"2025-11-10 09:49:23.162418+08","end_at":"2025-12-21 22:35:18","pinyin_shortcut":"wsz","creator":1011,"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":"162 days 19:19:20.732101","progress_remain":"204 days 08:05:15.601993","forecast_remain":"204 days 08:05:15.601993","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"41 days 12:45:54.869892","issued_invoices":"","client":{"id":3422,"key":3422,"name":"\u5317\u4eac\u5929\u822a\u4fe1\u6c11\u822a\u901a\u4fe1\u7f51\u7edc\u53d1\u5c55\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":43,"client_industry":1,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":4038,"client_id":3421,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":1004,"created_at":"2025-11-10 09:48:27","updated_at":"2025-11-14 10:49:52","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-11-10 09:48:27.472379+08","success_rate":"","comment":"2025\/11\/6\u636e\u5317\u4eac\u5e02\u5e94\u6025\u7ba1\u7406\u5c40\u5e94\u6025\u7ba1\u7406\u90e8\u95eb\u7ee7\u519b\u4e3b\u4efb\u4ecb\u7ecd\uff1a\u516c\u53f8\u76ee\u524d\u4f7f\u7528\u6df1\u4fe1\u670d\u4ea7\u54c1\uff0c\u57282026\u5e74\u7b2c\u4e8c\u5b63\u5ea6\u4f1a\u65b0\u589e\u5343\u5146\u7aef\u53e3\u9632\u706b\u58994\u53f0\uff0c\u652f\u63011500\u7ec8\u7aef\uff0c\u6574\u4f53\u9884\u7b972000\u4e07\uff0c\u4ea4\u6362\u673a\u7b49\u6279\u590d\u4e0b\u6765\u624d\u77e5\u9053\u591a\u5c11\u53f0\uff0c\u5355\u4f4d\u662f\u81ea\u4e3b\u91c7\u8d2d\uff0c\u662f\u51b3\u7b56\u8005\uff0c\u540e\u671f\u4f1a\u8003\u8651\u6df1\u4fe1\u670d\u4ea7\u54c1\uff0c\u540c\u610f\u540e\u671f\u9500\u552e\u8054\u7cfb\uff0c\u624b\u673a\u53f7:13701109825\u90ae\u7bb1\uff1a30699369@qq.com\u3002","contract_type":"","progress_updated_at":"2025-11-10 09:48:27.472379+08","forecast_updated_at":"2025-11-10 09:48:27.472379+08","end_at":"2025-11-14 10:49:52","pinyin_shortcut":"wsz","creator":1011,"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":"204 days 08:06:11.292032","progress_remain":"204 days 08:06:11.292032","forecast_remain":"204 days 08:06:11.292032","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"4 days 01:01:24.915854","issued_invoices":"","client":{"id":3421,"key":3421,"name":"\u5317\u4eac\u5e02\u5e94\u6025\u7ba1\u7406\u5c40\u5e94\u6025\u7ba1\u7406\u90e8","logo":"","client_type":6,"client_class":43,"client_industry":1,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":4036,"client_id":3420,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5300,"created_at":"2025-11-07 14:52:29","updated_at":"2025-12-22 14:13:51","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-12-22 14:13:51.876644+08","success_rate":"","comment":"2025\/11\/5\u636e\u4e2d\u822a\u54a8\u8be2\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u7ba1\u7406\u54a8\u8be2\u90e8\u526f\u603b\u7ecf\u7406\u5f20\u5148\u751f\u4ecb\u7ecd\uff1a\u516c\u53f8\u6709\u4f7f\u7528\u7f51\u7edc\u5b89\u5168\u4ea7\u54c1\uff0c\u73b0\u5728\u6b63\u5728\u4e86\u89e3\u9636\u6bb5\uff0c\u8ba1\u5212\u57282026\u5e74\u7b2c\u4e8c\u5b63\u5ea6\u6709\u6269\u5bb9\u9700\u6c42\u91c7\u8d2d\u9632\u706b\u58991-2\u53f0\u4ee5\u53ca\u4ea4\u6362\u673a\u7684\u8ba1\u5212\uff0c\u540c\u610f\u540e\u671f\u9500\u552e\u8054\u7cfb\uff0c\u624b\u673a\u53f7:18600423946\u90ae\u7bb1\uff1a199478441@qq.com\u3002","contract_type":"","progress_updated_at":"2025-11-07 14:52:29.276146+08","forecast_updated_at":"2025-11-07 14:52:29.276146+08","end_at":"2025-12-22 14:13:51","pinyin_shortcut":"wsz","creator":1011,"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":"162 days 03:40:46.887767","progress_remain":"207 days 03:02:09.488265","forecast_remain":"207 days 03:02:09.488265","lost_contact_days":"197.190726439942","last_contact":"2025-11-17 13:20:00","last_arrive_days":"","last_arrive":"","duration":"44 days 23:21:22.600498","issued_invoices":"","client":{"id":3420,"key":3420,"name":"\u4e2d\u822a\u54a8\u8be2\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":20,"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":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":3982,"client_id":3394,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5295,"created_at":"2025-09-22 16:48:37","updated_at":"2025-12-22 13:49:57","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-12-22 13:49:57.719158+08","success_rate":"","comment":"\u516c\u53f8\u4f7f\u7528\u534e\u4e3a\u4ea7\u54c1\uff0c\u516c\u53f8\u540e\u671f\u8981\u91cd\u65b0\u5efa\u8bbe\u5206\u5382\u9700\u8981\u91c7\u8d2d\u9632\u706b\u5899\uff0c\u7f51\u8def\u5b89\u5168\u9632\u62a4\u4ea7\u54c1\uff0c\u7528\u4e8e\u57fa\u672c\u9632\u62a4\u5c31\u53ef\u4ee5\uff0c\u8be5\u9879\u76ee\u5df2\u7acb\u9879\uff0c\u603b\u9884\u7b975\u5343\u4e07\uff0c\u91c7\u8d2d\u4e2d\u53ef\u4ee5\u63d0\u5efa\u8bae\uff0c\u540c\u610f\u540e\u671f\u9500\u552e\u8054\u7cfb","contract_type":"","progress_updated_at":"2025-09-22 16:48:37.40081+08","forecast_updated_at":"2025-09-22 16:48:37.40081+08","end_at":"2025-12-22 13:49:57","pinyin_shortcut":"wsz","creator":1011,"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":"162 days 04:04:41.045253","progress_remain":"253 days 01:06:01.363601","forecast_remain":"253 days 01:06:01.363601","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"90 days 21:01:20.318348","issued_invoices":"","client":{"id":3394,"key":3394,"name":"\u5317\u4eac\u7275\u624b\u679c\u852c\u996e\u54c1\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":17,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":3897,"client_id":3374,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5300,"created_at":"2025-06-23 15:55:41","updated_at":"2025-07-03 11:02:45","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-07-03 11:02:45.686264+08","success_rate":"","comment":"\u670d\u52a1\u5668\u9700\u6c42","contract_type":"","progress_updated_at":"2025-06-23 15:55:41.031605+08","forecast_updated_at":"2025-06-23 15:55:41.031605+08","end_at":"2025-07-03 11:02:45","pinyin_shortcut":"wsz","creator":1011,"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":"334 days 06:51:53.078147","progress_remain":"344 days 01:58:57.732806","forecast_remain":"344 days 01:58:57.732806","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"9 days 19:07:04.654659","issued_invoices":"","client":{"id":3374,"key":3374,"name":"\u4eba\u6c11\u6cd5\u9662\u65b0\u95fb\u4f20\u5a92\u603b\u793e","logo":"","client_type":1,"client_class":43,"client_industry":1,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":3887,"client_id":3371,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"","created_by":5295,"created_at":"2025-06-10 11:17:34","updated_at":"2025-06-16 17:42:40","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2025-06-16 17:42:40.815728+08","success_rate":"","comment":"\u7fa4\u6656DS1821+","contract_type":"","progress_updated_at":"2025-06-10 11:17:34.18041+08","forecast_updated_at":"2025-06-10 11:17:34.18041+08","end_at":"2025-06-16 17:42:40","pinyin_shortcut":"wsz","creator":5445,"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":"351 days 00:11:57.948683","progress_remain":"357 days 06:37:04.584001","forecast_remain":"357 days 06:37:04.584001","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"6 days 06:25:06.635318","issued_invoices":"","client":{"id":3371,"key":3371,"name":"\u4e2d\u79d1\u9662\u5317\u4eac\u57fa\u56e0\u7ec4\u6240","logo":"","client_type":1,"client_class":43,"client_industry":20,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":3066,"client_id":2498,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u9632\u706b\u5899\n","created_by":5295,"created_at":"2022-12-22 15:44:52","updated_at":"2022-12-26 13:55:13","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-12-26 13:55:13.12624+08","success_rate":"","comment":"\u9632\u706b\u5899\n\r\n","contract_type":"","progress_updated_at":"2022-12-22 15:44:52.624791+08","forecast_updated_at":"2022-12-22 15:44:52.624791+08","end_at":"2022-12-26 13:55:13","pinyin_shortcut":"wsz","creator":5015,"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":"1254 days 03:59:25.638171","progress_remain":"1258 days 02:09:46.13962","forecast_remain":"1258 days 02:09:46.13962","lost_contact_days":"1258.28794866216","last_contact":"2022-12-22 11:00:00","last_arrive_days":"","last_arrive":"","duration":"3 days 22:10:20.501449","issued_invoices":"","client":{"id":2498,"key":2498,"name":"\u5317\u4eac\u65f6\u4ee3\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":3005,"client_id":2259,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u91c7\u8d2d\u9632\u706b\u5899\u987a\u5e26\u589e\u52a0\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u4ea7\u54c1\uff08\u770b\u9884\u7b97\uff09\uff0c\u73b0\u5728\u4f7f\u7528\u7684\u9632\u706b\u5899\u65f6\u95f4\u5f88\u957f\u4e86\uff0c\u8f6f\u4ef6\u670d\u52a1\u5df2\u7ecf\u5230\u671f\uff0c\u60f3\u66ff\u6362\u65e7\u8bbe\u5907","created_by":5295,"created_at":"2022-09-30 16:05:57","updated_at":"2022-10-08 16:54:39","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-10-08 16:54:39.273365+08","success_rate":"","comment":"\u91c7\u8d2d\u9632\u706b\u5899\u987a\u5e26\u589e\u52a0\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u4ea7\u54c1\uff08\u770b\u9884\u7b97\uff09\uff0c\u73b0\u5728\u4f7f\u7528\u7684\u9632\u706b\u5899\u65f6\u95f4\u5f88\u957f\u4e86\uff0c\u8f6f\u4ef6\u670d\u52a1\u5df2\u7ecf\u5230\u671f\uff0c\u60f3\u66ff\u6362\u65e7\u8bbe\u5907\r\n","contract_type":"","progress_updated_at":"2022-09-30 16:05:57.458915+08","forecast_updated_at":"2022-09-30 16:05:57.458915+08","end_at":"2022-10-08 16:54:39","pinyin_shortcut":"wsz","creator":5015,"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":"1333 days 00:59:59.491046","progress_remain":"1341 days 01:48:41.305496","forecast_remain":"1341 days 01:48:41.305496","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"8 days 00:48:41.81445","issued_invoices":"","client":{"id":2259,"key":2259,"name":"\u4f20\u5947\u6587\u5316\u53d1\u5c55\u96c6\u56e2\u6709\u9650\u516c\u53f8","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2991,"client_id":2251,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u7fa4\u6656NAS\n","created_by":5295,"created_at":"2022-09-21 09:19:51","updated_at":"2022-09-26 16:42:50","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-09-26 16:42:50.349184+08","success_rate":"","comment":"\u7fa4\u6656NAS\n\r\n","contract_type":"","progress_updated_at":"2022-09-21 09:19:51.778026+08","forecast_updated_at":"2022-09-21 09:19:51.778026+08","end_at":"2022-09-26 16:42:50","pinyin_shortcut":"wsz","creator":5015,"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":"1345 days 01:11:48.415227","progress_remain":"1350 days 08:34:46.986385","forecast_remain":"1350 days 08:34:46.986385","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"5 days 07:22:58.571158","issued_invoices":"","client":{"id":2251,"key":2251,"name":"\u901a\u7ef4(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2985,"client_id":2248,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u6df1\u4fe1\u670d\u684c\u9762\u4e91\n","created_by":5295,"created_at":"2022-09-13 17:11:06","updated_at":"2022-09-19 17:48:28","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-09-19 17:48:28.658818+08","success_rate":"","comment":"\u6df1\u4fe1\u670d\u684c\u9762\u4e91\n\r\n","contract_type":"","progress_updated_at":"2022-09-13 17:11:06.865033+08","forecast_updated_at":"2022-09-13 17:11:06.865033+08","end_at":"2022-09-19 17:48:28","pinyin_shortcut":"wsz","creator":5015,"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":"1352 days 00:06:10.105593","progress_remain":"1358 days 00:43:31.899378","forecast_remain":"1358 days 00:43:31.899378","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"6 days 00:37:21.793785","issued_invoices":"","client":{"id":2248,"key":2248,"name":"\u8d1d\u4e50\u79d1\u6280","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2956,"client_id":2228,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u5ba2\u6237\u5bf9\u7f51\u7edc\u5b89\u5168\u53ef\u80fd\u5b58\u5728\u4e00\u5b9a\u7684\u5174\u8da3\uff1b\u540e\u671f\u53ef\u80fd\u8003\u8651\u5b89\u5168\u5165\u4fb5\u5efa\u8bbe\u9700\u8981\u52a0\u5f3a\uff0c\u4e5f\u4f1a\u6709\u5185\u7f51\u75c5\u6bd2\u68c0\u6d4b\u65b9\u9762\u7684\u4e00\u4e9b\u8003\u8651\uff0c\u4eba\u5458\u6d41\u52a8\u4e14\u79fb\u52a8\u8bbe\u5907\u591a\uff0c\u4f1a\u6709\u4e00\u4e9b\u5b89\u5168\u9690\u60a3\uff1b\u5458\u5de5\u4eba\u5458100\u4eba","created_by":5300,"created_at":"2022-08-23 09:21:59","updated_at":"2022-08-29 14:34:31","engineer_id":"","project_title":"\u5b89\u5168\u52a0\u56fa-\u6df1\u4fe1\u670d\u4ea7\u54c1\u4e86\u89e3(\u9000\u56de)","collected":"0","status_updated_at":"2022-08-29 14:31:46.603029+08","success_rate":"","comment":"\u5ba2\u6237\u5bf9\u7f51\u7edc\u5b89\u5168\u53ef\u80fd\u5b58\u5728\u4e00\u5b9a\u7684\u5174\u8da3\uff1b\u540e\u671f\u53ef\u80fd\u8003\u8651\u5b89\u5168\u5165\u4fb5\u5efa\u8bbe\u9700\u8981\u52a0\u5f3a\uff0c\u4e5f\u4f1a\u6709\u5185\u7f51\u75c5\u6bd2\u68c0\u6d4b\u65b9\u9762\u7684\u4e00\u4e9b\u8003\u8651\uff0c\u4eba\u5458\u6d41\u52a8\u4e14\u79fb\u52a8\u8bbe\u5907\u591a\uff0c\u4f1a\u6709\u4e00\u4e9b\u5b89\u5168\u9690\u60a3\uff1b\u5458\u5de5\u4eba\u5458100\u4eba\r\n","contract_type":"","progress_updated_at":"2022-08-23 09:21:59.024593+08","forecast_updated_at":"2022-08-23 09:21:59.024593+08","end_at":"2022-08-29 14:34:31","pinyin_shortcut":"aqjgsxfcpljth","creator":5015,"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":"1373 days 03:22:52.161382","progress_remain":"1379 days 08:32:39.739818","forecast_remain":"1379 days 08:32:39.739818","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"6 days 05:12:32.642547","issued_invoices":"","client":{"id":2228,"key":2228,"name":"\u98ce\u884c\u89c6\u9891\u6280\u672f(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2940,"client_id":2220,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u7fa4\u6656DS918+\u5347\u7ea7\u5185\u5b58","created_by":5329,"created_at":"2022-08-11 15:12:50","updated_at":"2022-08-22 18:05:30","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-08-22 18:05:30.856365+08","success_rate":"","comment":"\u7fa4\u6656DS918+\u5347\u7ea7\u5185\u5b58\r\n","contract_type":"","progress_updated_at":"2022-08-11 15:12:50.795348+08","forecast_updated_at":"2022-08-11 15:12:50.795348+08","end_at":"2022-08-22 18:05:30","pinyin_shortcut":"wsz","creator":5015,"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":"1379 days 23:49:07.908046","progress_remain":"1391 days 02:41:47.969063","forecast_remain":"1391 days 02:41:47.969063","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"11 days 02:52:40.061017","issued_invoices":"","client":{"id":2220,"key":2220,"name":"\u5317\u4eac\u529b\u901a\u901a\u4fe1\u6709\u9650\u516c\u53f8","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2938,"client_id":2218,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u7fa4\u6656\uff08Synology\uff09DS1621+ \u642d\u914d3\u5757\u5e0c\u6377(Seagate) 12TB\u9177\u72fcpro ST12000NE0008\u786c\u76d8 \u5957\u88c5","created_by":5329,"created_at":"2022-08-09 16:17:30","updated_at":"2022-08-22 18:05:33","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-08-22 18:05:33.298159+08","success_rate":"","comment":"\u7fa4\u6656\uff08Synology\uff09DS1621+ \u642d\u914d3\u5757\u5e0c\u6377(Seagate) 12TB\u9177\u72fcpro ST12000NE0008\u786c\u76d8 \u5957\u88c5\r\n","contract_type":"","progress_updated_at":"2022-08-09 16:17:30.361519+08","forecast_updated_at":"2022-08-09 16:17:30.361519+08","end_at":"2022-08-22 18:05:33","pinyin_shortcut":"wsz","creator":5015,"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":"1379 days 23:49:05.466252","progress_remain":"1393 days 01:37:08.402892","forecast_remain":"1393 days 01:37:08.402892","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"13 days 01:48:02.93664","issued_invoices":"","client":{"id":2218,"key":2218,"name":"\u5317\u4eac\u56fd\u9645\u4e91\u8f6c\u64ad\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":"","client_industry":18,"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":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2932,"client_id":2217,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u5355\u4f4d\u8ba1\u5212\u4e0aVPN\u548c\u9632\u706b\u5899\uff0cVPN\u4e3b\u8981\u5b9e\u73b0\u79fb\u52a8\u529e\u516c\uff0c20\u591a\u4e2a\u4fe1\u606f\u70b9\uff0c\u9632\u706b\u5899\u4e3b\u8981\u7528\u4e8e\u6570\u636e\u5b89\u5168\u52a0\u56fa\u548c\u51fa\u53e3\u5b89\u5168\uff0c\u5e26\u5bbd300M\uff0c\u8003\u8651\u6df1\u4fe1\u670d\u4ea7\u54c1","created_by":5300,"created_at":"2022-08-01 15:28:45","updated_at":"2022-08-15 17:14:04","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-08-15 17:14:04.905614+08","success_rate":"","comment":"\u5355\u4f4d\u8ba1\u5212\u4e0aVPN\u548c\u9632\u706b\u5899\uff0cVPN\u4e3b\u8981\u5b9e\u73b0\u79fb\u52a8\u529e\u516c\uff0c20\u591a\u4e2a\u4fe1\u606f\u70b9\uff0c\u9632\u706b\u5899\u4e3b\u8981\u7528\u4e8e\u6570\u636e\u5b89\u5168\u52a0\u56fa\u548c\u51fa\u53e3\u5b89\u5168\uff0c\u5e26\u5bbd300M\uff0c\u8003\u8651\u6df1\u4fe1\u670d\u4ea7\u54c1\r\n","contract_type":"","progress_updated_at":"2022-08-01 15:28:45.280211+08","forecast_updated_at":"2022-08-01 15:28:45.280211+08","end_at":"2022-08-15 17:14:04","pinyin_shortcut":"wsz","creator":5015,"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":"1387 days 00:40:33.858797","progress_remain":"1401 days 02:25:53.4842","forecast_remain":"1401 days 02:25:53.4842","lost_contact_days":"1400.7462819955","last_contact":"2022-08-02 00:00:00","last_arrive_days":"","last_arrive":"","duration":"14 days 01:45:19.625403","issued_invoices":"","client":{"id":2217,"key":2217,"name":"\u5317\u4eac\u6d77\u6587\u8d44\u4ea7\u7ecf\u8425\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":"","sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2866,"client_id":2195,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u5355\u4f4d\u73b0\u5728\u6709\u4f7f\u7528\u6df1\u4fe1\u670d\u7684\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\uff0c\u76ee\u524d\u7528\u7684\u662f\u6700\u57fa\u7840\u7248\u672c\u7684\uff0c\u4e3b\u8981\u7528\u4e8e\u4e0a\u7f51\u6d41\u91cf\u9650\u5236\u548c\u4e0a\u7f51\u884c\u4e3a\u7684\u4e00\u4e9b\u7ba1\u63a7\uff0c\u76ee\u524d\u53ea\u80fd\u8fdb\u884c\u5b9e\u65f6\u67e5\u770b\uff0c\u60f3\u770b\u5386\u53f2\u6570\u636e\u662f\u770b\u4e0d\u4e86\u7684\uff0c\u5e94\u8be5\u662f\u6ca1\u6709\u8fd9\u4e2a\u6a21\u5757\u3002\u540e\u671f\u6709\u53ef\u80fd\u4f1a\u66f4\u6362\u4e0a\u65b0\u7684\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907","created_by":5295,"created_at":"2022-06-09 15:03:29","updated_at":"2022-06-13 16:42:36","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-06-13 16:42:36.317782+08","success_rate":"","comment":"\u5355\u4f4d\u73b0\u5728\u6709\u4f7f\u7528\u6df1\u4fe1\u670d\u7684\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\uff0c\u76ee\u524d\u7528\u7684\u662f\u6700\u57fa\u7840\u7248\u672c\u7684\uff0c\u4e3b\u8981\u7528\u4e8e\u4e0a\u7f51\u6d41\u91cf\u9650\u5236\u548c\u4e0a\u7f51\u884c\u4e3a\u7684\u4e00\u4e9b\u7ba1\u63a7\uff0c\u76ee\u524d\u53ea\u80fd\u8fdb\u884c\u5b9e\u65f6\u67e5\u770b\uff0c\u60f3\u770b\u5386\u53f2\u6570\u636e\u662f\u770b\u4e0d\u4e86\u7684\uff0c\u5e94\u8be5\u662f\u6ca1\u6709\u8fd9\u4e2a\u6a21\u5757\u3002\u540e\u671f\u6709\u53ef\u80fd\u4f1a\u66f4\u6362\u4e0a\u65b0\u7684\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\r\n","contract_type":"","progress_updated_at":"2022-06-09 15:03:29.271349+08","forecast_updated_at":"2022-06-09 15:03:29.271349+08","end_at":"2022-06-13 16:42:36","pinyin_shortcut":"wsz","creator":5015,"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":"1450 days 01:12:02.446629","progress_remain":"1454 days 02:51:09.493062","forecast_remain":"1454 days 02:51:09.493062","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"4 days 01:39:07.046433","issued_invoices":"","client":{"id":2195,"key":2195,"name":"\u5609\u5eb7\u5229(\u4e2d\u56fd)\u65e5\u7528\u54c1\u6709\u9650\u516c\u53f8","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2803,"client_id":2167,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"PA\u9632\u706b\u5899\n","created_by":5295,"created_at":"2022-03-23 15:58:56","updated_at":"2022-04-06 12:47:08","engineer_id":"","project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-03-27 19:11:33.681628+08","success_rate":"","comment":"PA\u9632\u706b\u5899\n\r\n\u6401\u7f6e\u539f\u56e0\uff1a\u5ba2\u6237\u6ca1\u6709\u7406\u6211\uff0c\u518d\u6c9f\u901a","contract_type":"","progress_updated_at":"2022-03-23 15:58:56.403776+08","forecast_updated_at":"2022-03-23 15:58:56.403776+08","end_at":"2022-04-06 12:47:08","pinyin_shortcut":"wsz","creator":5015,"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":"1527 days 22:43:05.082783","progress_remain":"1532 days 01:55:42.360635","forecast_remain":"1532 days 01:55:42.360635","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"13 days 20:48:11.898799","issued_invoices":"","client":{"id":2167,"key":2167,"name":"\u81ea\u7136\u6797","logo":"","client_type":"","client_class":"","client_industry":"","sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2748,"client_id":111,"project_status":5,"project_progress":2,"budget":"0","profit_pct":"0","bargain_date":"","description":"\u9700\u6c42\uff1a\n\u2460\u5171\u4eab\u6587\u4ef6\u7684\u9010\u7ea7\u8bbf\u95ee\n\u2461\u6743\u9650\u5212\u5206\u4e3a\nA\u6743\u9650\uff0c\u53ef\u5bf9\u6587\u4ef6\u8fdb\u884c\u8bfb\u5199\u3001\u590d\u5236\u3001\u5220\u9664\u3001\u64cd\u4f5c\nB\u6743\u9650\uff0c\u5bf9\u6587\u4ef6\u5b9e\u73b0\u53ea\u8bfb\u64cd\u4f5c\uff0c\u4e0d\u80fd\u7f16\u8f91\uff0c\u4e0d\u80fd\u62f7\u8d1d \u4e0b\u8f7d\uff0c\u4e0d\u80fd\u5220\u9664\n\u2462\u5bf9\u6587\u4ef6\u7684\u8bbf\u95ee\u65e5\u5fd7\u8bb0\u5f55\uff0c\u8bb0\u5f55\u5bf9\u6587\u6863\u7684\u65b0\u5efa\uff0c\u8bfb\u53d6\uff0c\u4e0b\u8f7d\u62f7\u8d1d\uff0c\u7f16\u8f91\u65e5\u5fd7\n\u7ade\u4e89\u5bf9\u624b\uff1a\n\u672a\u77e5","created_by":5309,"created_at":"2022-02-08 09:43:39","updated_at":"2022-05-18 15:26:02","engineer_id":"","project_title":"\u7ec8\u7aef\u6570\u636e\u9632\u6cc4\u9732","collected":"0","status_updated_at":"2022-04-05 12:27:08.50503+08","success_rate":"","comment":"\u9700\u6c42\uff1a\n\u2460\u5171\u4eab\u6587\u4ef6\u7684\u9010\u7ea7\u8bbf\u95ee\n\u2461\u6743\u9650\u5212\u5206\u4e3a\nA\u6743\u9650\uff0c\u53ef\u5bf9\u6587\u4ef6\u8fdb\u884c\u8bfb\u5199\u3001\u590d\u5236\u3001\u5220\u9664\u3001\u64cd\u4f5c\nB\u6743\u9650\uff0c\u5bf9\u6587\u4ef6\u5b9e\u73b0\u53ea\u8bfb\u64cd\u4f5c\uff0c\u4e0d\u80fd\u7f16\u8f91\uff0c\u4e0d\u80fd\u62f7\u8d1d \u4e0b\u8f7d\uff0c\u4e0d\u80fd\u5220\u9664\n\u2462\u5bf9\u6587\u4ef6\u7684\u8bbf\u95ee\u65e5\u5fd7\u8bb0\u5f55\uff0c\u8bb0\u5f55\u5bf9\u6587\u6863\u7684\u65b0\u5efa\uff0c\u8bfb\u53d6\uff0c\u4e0b\u8f7d\u62f7\u8d1d\uff0c\u7f16\u8f91\u65e5\u5fd7\n\u7ade\u4e89\u5bf9\u624b\uff1a\n\u672a\u77e5\r\n\u95ee\u9898\uff1a\n\u6587\u4ef6\u6ca1\u6709\u5408\u89c4\u6027\u7684\u7ba1\u7406\uff0c\u8c01\u90fd\u53ef\u4ee5\u8c03\u7528\u6587\u4ef6\uff0c\u6ca1\u6709\u5206\u6743\u5206\u7ea7\uff0c\u6709\u6570\u636e\u6cc4\u6f0f\u7684\u98ce\u9669\u3002","contract_type":"","progress_updated_at":"2022-02-08 09:43:39.601969+08","forecast_updated_at":"2022-04-05 12:27:08.50503+08","end_at":"2022-04-05 12:27:08","pinyin_shortcut":"zdsjfxl","creator":5309,"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":"1519 days 05:27:30.259381","progress_remain":"1575 days 08:10:59.162442","forecast_remain":"1519 days 05:27:30.259381","lost_contact_days":"1476.11780977328","last_contact":"2022-05-18 15:05:00","last_arrive_days":"1552.24975421772","last_arrive":"2022-03-03 11:55:00+08","duration":"56 days 02:43:28.903061","issued_invoices":"","client":{"id":111,"key":111,"name":"\u5317\u4eac\u67cf\u96c5\u8054\u5408\u836f\u7269\u7814\u7a76\u6240\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":3,"sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"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":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"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":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2722,"client_id":402,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"\u7b49\u4fdd","created_by":5309,"created_at":"2021-12-24 13:30:20","updated_at":"2024-10-08 14:12:45","engineer_id":"","project_title":"\u7b49\u4fdd2.0","collected":"0","status_updated_at":"2021-12-27 17:43:33.929473+08","success_rate":"","comment":"\u7b49\u4fdd\r\n","contract_type":"","progress_updated_at":"2021-12-24 13:30:20.553001+08","forecast_updated_at":"2021-12-24 13:30:20.553001+08","end_at":"2021-12-27 17:43:33","pinyin_shortcut":"db20","creator":5309,"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":"1618 days 00:11:04.834938","progress_remain":"1621 days 04:24:18.21141","forecast_remain":"1621 days 04:24:18.21141","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"3 days 04:13:13.376472","issued_invoices":"","client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":47,"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":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true},{"id":2674,"client_id":12,"project_status":5,"project_progress":"","budget":"0","profit_pct":"0","bargain_date":"","description":"IT\u57fa\u7840\u67b6\u6784\u8fd0\u7ef4\n\u73b0\u6709\u4f9b\u5e94\u5546\u4fbf\u5b9c\uff0c\u4f46\u662f\u6ca1\u6709\u4efb\u4f55\u670d\u52a1\u3002\u5bfb\u627e\u63d0\u4f9b\u8fd0\u7ef4\u670d\u52a1\u7684\u673a\u4f1a\u3002","created_by":1005,"created_at":"2021-10-27 12:03:40","updated_at":"2025-06-26 14:44:11","engineer_id":"","project_title":"\u8fd0\u7ef4\u670d\u52a1","collected":"0","status_updated_at":"2021-11-22 11:22:04.637785+08","success_rate":"","comment":"IT\u57fa\u7840\u67b6\u6784\u8fd0\u7ef4\n\u73b0\u6709\u4f9b\u5e94\u5546\u4fbf\u5b9c\uff0c\u4f46\u662f\u6ca1\u6709\u4efb\u4f55\u670d\u52a1\u3002\u5bfb\u627e\u63d0\u4f9b\u8fd0\u7ef4\u670d\u52a1\u7684\u673a\u4f1a\u3002\r\n","contract_type":"","progress_updated_at":"2021-10-27 12:03:40.437161+08","forecast_updated_at":"2021-10-27 12:03:40.437161+08","end_at":"2021-11-22 11:22:04","pinyin_shortcut":"ywfw","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":"0.00000000000000000000","remain":"1653 days 06:32:34.126626","progress_remain":"1679 days 05:50:58.32725","forecast_remain":"1679 days 05:50:58.32725","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"25 days 23:18:24.200624","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":{},"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_update":true,"can_delete":true}],"list6count":0,"list6sum":"","list6":[],"thisUser":"","can_create":true,"pagenation":{"totalcount":1385,"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-02 17:54:38', 1017840384) RETURNING "id" |
| 17:54:38.696 | 1.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3454, 3423, 3419, 3414, 3413, 3412, 3410, 3409, 3320, 3318, 3306, 2716, 2565, 2504, 2241, 2240, 2196, 1509, 656, 121) |
| 17:54:38.698 | 1.0 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 5295, 1005, 5300)) |
| 17:54:38.699 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4137, 4040, 4035, 4023, 4022, 4021, 4019, 4013, 3715, 3711, 3668, 3369, 3262, 3094, 2967, 2966, 2871, 2675, 2648, 2559) |
| 17:54:38.807 | 0.9 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3425, 3422, 3421, 3420, 3394, 3374, 3371, 2498, 2259, 2251, 2248, 2228, 2220, 2218, 2217, 2195, 2167, 111, 402, 12) |
| 17:54:38.809 | 0.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3425, 3422, 3421, 3420, 3394, 3374, 3371, 2498, 2259, 2251, 2248, 2228, 2220, 2218, 2217, 2195, 2167, 111, 402, 12) |
| 17:54:38.701 | 0.9 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (162, 184, 189, 7, 133, 1, 200, 215, 165, 179, 142, 229, 2, 5, 327, 226, 130, 171, 181, 183, 190, 205, 203, 156, 131, 140, 167, 185, 191, 194, 341, 349, 354, 369, 374, 348, 377, 359, 356, 2100000000, 317)) ORDER BY "sort" |
| 17:54:38.482 | 0.8 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5250 |
| 17:54:38.811 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4050, 4039, 4038, 4036, 3982, 3897, 3887, 3066, 3005, 2991, 2985, 2956, 2940, 2938, 2932, 2866, 2803, 2748, 2722, 2674) |
| 17:54:38.695 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3454, 3423, 3419, 3414, 3413, 3412, 3410, 3409, 3320, 3318, 3306, 2716, 2565, 2504, 2241, 2240, 2196, 1509, 656, 121) |
| 17:54:38.485 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 |
| 17:54:38.703 | 0.5 ms | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (4137, 4040, 4035, 4023, 4022, 4021, 4019, 4013, 3715, 3711, 3668, 3369, 3262, 3094, 2967, 2966, 2871, 2675, 2648, 2559) |
| 17:54:38.814 | 0.5 ms | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (4050, 4039, 4038, 4036, 3982, 3897, 3887, 3066, 3005, 2991, 2985, 2956, 2940, 2938, 2932, 2866, 2803, 2748, 2722, 2674) |
| 17:54:38.812 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (226, 167, 1, 231, 207, 212, 184, 189, 185, 191, 5, 2, 205, 204, 94, 7, 229, 187, 181, 197, 199, 131, 192, 136, 140, 135, 137, 138, 139, 346, 348, 349, 359, 369, 371, 377, 2100000000)) ORDER BY "sort" |
| 17:54:38.702 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=4 |
| 17:54:38.702 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (2, 1) |
| 17:54:38.810 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5311, 1005) |
| 17:54:38.697 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5311, 5300, 5295, 1005) |
| 17:54:38.810 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 1005, 5300)) |
| 17:54:38.813 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=5 |
| 17:54:38.813 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"=2 |
| 17:54:38.482 | 0.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |