1 files changed, 59 insertions, 0 deletions
diff --git a/fnme/station.py b/fnme/station.py
index e69de29..e5112c3 100644
--- a/fnme/station.py
+++ b/fnme/station.py
@@ -0,0 +1,59 @@
+import argparse
+import math
+from typing import Any, Dict, List, Tuple
+
+import numpy as np
+import pandas as pd
+from constants import SORT_KV
+
+
+def filter_df(
+    dframe: pd.DataFrame, arguments: argparse.Namespace, loc: Tuple[float, float]
+) -> List[Dict[str, Any]]:
+
+    def bounding_box() -> pd.DataFrame:
+        lat, lon = loc
+        deg_lat = arguments.radius / 69.0
+        deg_lon = arguments.radius / (69.0 * math.cos(math.radians(lat)))
+        return dframe[
+            dframe["forecourts.location.latitude"].between(lat - deg_lat, lat + deg_lat)
+            & dframe["forecourts.location.longitude"].between(
+                lon - deg_lon, lon + deg_lon
+            )
+        ]
+
+    def haversine_miles(lat2: np.ndarray, lon2: np.ndarray) -> np.ndarray:
+        R = 3958.8
+        lat1, lon1 = np.radians(loc[0]), np.radians(loc[1])
+        lat2, lon2 = np.radians(lat2), np.radians(lon2)
+        dlat = lat2 - lat1
+        dlon = lon2 - lon1
+        a = np.sin(dlat / 2) ** 2 + np.cos(lat1) * np.cos(lat2) * np.sin(dlon / 2) ** 2
+        return R * 2 * np.arcsin(np.sqrt(a))
+
+    def pence_to_pounds(col: pd.Series) -> pd.Series:
+        return (col / 100).round(2).where(col.notna(), other="N/A")
+
+    df = bounding_box().copy()
+
+    df["distance"] = haversine_miles(
+        df["forecourts.location.latitude"].to_numpy(),
+        df["forecourts.location.longitude"].to_numpy(),
+    ).round(1)
+
+    df = df[df["distance"] < arguments.radius]
+
+    df = df.assign(
+        e5_price=pence_to_pounds(df["forecourts.fuel_price.E5"]),
+        e10_price=pence_to_pounds(df["forecourts.fuel_price.E10"]),
+        diesel_price=pence_to_pounds(df["forecourts.fuel_price.B7S"]),
+    )
+
+    return df.rename(columns={"forecourts.trading_name": "station_name"})[
+        ["station_name", "distance", "e5_price", "e10_price", "diesel_price"]
+    ].to_dict(orient="records")
+
+
+def sort_stations(stations: list[dict], sort: str) -> list[dict]:
+    sort_key = SORT_KV[sort]
+    return sorted(stations, key=lambda d: d[sort_key] if d[sort_key] != "N/A" else 999)