From 2430eaeca66a6825206b40af904a268b27bc1561 Mon Sep 17 00:00:00 2001
From: Rafi Zadanly <zadanlyr@gmail.com>
Date: Tue, 21 Nov 2023 15:40:12 +0700
Subject: Add order by name on location and product api

---
 src/app/api/location/route.tsx | 3 ++-
 src/app/api/product/route.tsx  | 3 ++-
 2 files changed, 4 insertions(+), 2 deletions(-)

(limited to 'src')

diff --git a/src/app/api/location/route.tsx b/src/app/api/location/route.tsx
index 7139c6d..1b5cb43 100644
--- a/src/app/api/location/route.tsx
+++ b/src/app/api/location/route.tsx
@@ -17,7 +17,8 @@ export async function GET(request: NextRequest) {
       companyId,
       name: { mode: 'insensitive', contains: search ?? '' }
     },
-    take: 20
+    take: 20,
+    orderBy: { name: 'asc' }
   })
 
   return NextResponse.json(locations)
diff --git a/src/app/api/product/route.tsx b/src/app/api/product/route.tsx
index d28a543..1a28315 100644
--- a/src/app/api/product/route.tsx
+++ b/src/app/api/product/route.tsx
@@ -32,7 +32,8 @@ export async function GET(request: NextRequest) {
     where,
     include: { company: true },
     take: PAGE_SIZE,
-    skip: (intPage - 1) * PAGE_SIZE
+    skip: (intPage - 1) * PAGE_SIZE,
+    orderBy: { name: 'asc' }
   })
 
   const count = await prisma.product.count({ where })
-- 
cgit v1.2.3