1 files changed, 6 insertions, 1 deletions
diff --git a/app/lib/db.server.ts b/app/lib/db.server.ts
index a4671b4..82a0025 100644
--- a/app/lib/db.server.ts
+++ b/app/lib/db.server.ts
@@ -172,12 +172,13 @@ export interface QueryEventsParams {
   venue_id?: string;
   keyword?: string;
   capacity_range?: CapacityRange;
+  area?: string;
   limit?: number;
   offset?: number;
 }
 
 export function queryEvents(params: QueryEventsParams = {}): Event[] {
-  const { date_from, date_to, venue_id, keyword, capacity_range, limit = 60, offset = 0 } =
+  const { date_from, date_to, venue_id, keyword, capacity_range, area, limit = 60, offset = 0 } =
     params;
 
   const clauses: string[] = [];
@@ -206,6 +207,10 @@ export function queryEvents(params: QueryEventsParams = {}): Event[] {
   } else if (capacity_range === "large") {
     clauses.push("v.capacity >= 300");
   }
+  if (area) {
+    clauses.push("v.area = ?");
+    args.push(area);
+  }
 
   const where = clauses.length ? `WHERE ${clauses.join(" AND ")}` : "";