ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1ea85c6a926: POST https://beta.jinchangxiao.com/vue/project/list-all-status at 2026-06-02 05:54:36 pm by 221.216.117.119

Performance Profiling

Total processing time: 622 ms; Peak memory: 5.412 MB. Show Profiling Timeline

总计32条数据
TimeDurationCategoryInfo
  
17:54:36.96339.7 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
17:54:36.89335.8 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
17:54:36.93032.8 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
17:54:36.82123.6 msyii\db\Command::querySELECT 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')) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
17:54:36.8866.9 msyii\db\Command::querySELECT 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')) 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:37.0426.0 msyii\db\Command::querySELECT 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')) 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:37.0236.0 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
17:54:36.8555.8 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
17:54:37.0115.6 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
17:54:37.0365.4 msyii\db\Command::querySELECT 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')) 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:37.0175.4 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
17:54:36.8715.2 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
17:54:37.0304.5 msyii\db\Command::querySELECT 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')) 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:36.8614.5 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
17:54:36.8504.3 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
17:54:36.8454.1 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
17:54:36.8774.1 msyii\db\Command::querySELECT 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')) 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:36.8664.0 msyii\db\Command::querySELECT 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')) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
17:54:36.8813.9 msyii\db\Command::querySELECT 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')) 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:37.0503.0 msyii\db\Command::queryINSERT 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"],"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:45.685195","progress_remain":"84 days 04:04:58.512799","forecast_remain":"84 days 04:04:58.512799","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:25.792093","progress_remain":"204 days 07:50:30.301264","forecast_remain":"204 days 07:50:30.301264","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:41:59.466889","progress_remain":"207 days 03:02:10.820452","forecast_remain":"207 days 03:02:10.820452","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:05.196918","progress_remain":"217 days 07:13:07.067098","forecast_remain":"217 days 07:13:07.067098","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:50.896991","progress_remain":"217 days 07:14:45.029521","forecast_remain":"217 days 07:14:45.029521","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:08.429178","progress_remain":"217 days 07:17:00.830386","forecast_remain":"217 days 07:17:00.830386","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:14.818376","progress_remain":"218 days 00:54:16.289535","forecast_remain":"218 days 00:54:16.289535","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:10.863633","progress_remain":"224 days 08:07:16.42482","forecast_remain":"224 days 08:07:16.42482","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:02.529509","progress_remain":"565 days 05:01:40.307617","forecast_remain":"565 days 05:01:40.307617","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:09.284439","progress_remain":"567 days 06:23:34.867762","forecast_remain":"567 days 06:23:34.867762","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:09.729495","progress_remain":"617 days 07:31:50.130855","forecast_remain":"617 days 07:31:50.130855","lost_contact_days":"616.269177842234","last_contact":"2024-09-24 11:27:00","last_arrive_days":"616.269177842234","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:19.807008","progress_remain":"923 days 07:15:38.780696","forecast_remain":"923 days 07:15:38.780696","lost_contact_days":"923.253205620012","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:38.386798","progress_remain":"1048 days 08:23:04.590023","forecast_remain":"1048 days 08:23:04.590023","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:40.768401","progress_remain":"1212 days 19:30:05.976943","forecast_remain":"1212 days 00:07:40.768401","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:32.084755","progress_remain":"1372 days 06:00:53.914651","forecast_remain":"1372 days 06:00:53.914651","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:55.421531","progress_remain":"1372 days 08:31:32.024254","forecast_remain":"1372 days 08:31:32.024254","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:13.3475","progress_remain":"1450 days 02:55:14.493476","forecast_remain":"1450 days 02:55:14.493476","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:29.245601","progress_remain":"1474 days 00:41:34.7888","forecast_remain":"1474 days 00:41:34.7888","lost_contact_days":"1635.17820562001","last_contact":"2021-12-10 13:38:00","last_arrive_days":"1635.17820562001","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:45.639809","progress_remain":"1730 days 02:07:29.570353","forecast_remain":"1730 days 02:07:29.570353","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:28.294529","progress_remain":"1828 days 03:27:14.846637","forecast_remain":"1786 days 03:01:57.907217","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":0,"list5sum":"","list5":[],"list6count":0,"list6sum":"","list6":[],"thisUser":"","can_create":true,"pagenation":{"totalcount":472,"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:37', 599282176) RETURNING "id"
17:54:36.8081.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5250
17:54:37.0070.9 msyii\db\Command::querySELECT * 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:37.0040.9 msyii\db\Command::querySELECT * 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:37.0040.5 msyii\db\Command::querySELECT "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:37.0080.5 msyii\db\Command::querySELECT "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:36.8110.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
17:54:37.0090.5 msyii\db\Command::querySELECT "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:37.0060.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5311, 5300, 5295, 1005)
17:54:37.0060.3 msyii\db\Command::querySELECT "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:37.0090.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (2, 1)
17:54:37.0090.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=4
17:54:36.8080.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta