fix case-insensitive order search

apps/api/src/orders/order-repository.ts

@@ -35,13 +35,13 @@ function toOrderItemDetail(row: {
 }
 
 export async function listOrderSummaries(context: DatabaseContext, query?: string) {
-  const search = query?.trim();
+  const search = query?.trim().toLowerCase();
 
   const filters = search
     ? or(
-        sql`instr(lower(${orders.orderNumber}), lower(${search})) > 0`,
-        sql`instr(lower(${users.name}), lower(${search})) > 0`,
-        sql`instr(lower(${users.email}), lower(${search})) > 0`
+       sql`instr(lower(${orders.orderNumber}), ${search}) > 0`,
+       sql`instr(lower(${users.name}), ${search}) > 0`,
+       sql`instr(lower(${users.email}), ${search}) > 0`
       )
     : undefined;