Changeset 87c9f1e for src/app/api/customers/route.ts

Timestamp:

02/27/25 00:42:38 (5 weeks ago)

Author:

Naum Shapkarovski <naumshapkarovski@…>

Branches:

main

Children:

32e9876

Parents:

3c5302a

Message:

update the seed script. update the prisma schema, use mapping

File:

• src/app/api/customers/route.ts (modified) (3 diffs)

src/app/api/customers/route.ts

@@ -3 +3 @@
 import prisma from 'src/lib/prisma';
 import { authenticateRequest } from 'src/lib/auth-middleware';
-import { CustomerStatus } from '@prisma/client';
-import { Prisma } from '@prisma/client';
+import { Prisma, ClientStatus } from '@prisma/client';
 
 export async function GET(request: NextRequest) {
@@ -25 +24 @@
     const validatedFilters = customerTableFiltersSchema.parse(filters);
 
-    // Replace Prisma query with raw SQL
-    const customers = await prisma.$queryRaw`
-      SELECT * FROM "Client"
-      WHERE "tenantId" = ${tenantId}
-        AND LOWER(name) LIKE LOWER(${`%${validatedFilters.name}%`})
-        ${
-          validatedFilters.status
-            ? Prisma.sql`AND status = ${validatedFilters.status}::"CustomerStatus"`
-            : Prisma.sql`AND TRUE`
-        }
-    `;
+    //   const customers = await prisma.$queryRaw`
+    //   SELECT * FROM "Client"
+    //   WHERE "tenant_id" = ${tenantId}
+    //     AND LOWER(name) LIKE LOWER(${`%${validatedFilters.name}%`})
+    //     ${
+    //       validatedFilters.status
+    //         ? Prisma.sql`AND status = ${validatedFilters.status}::"CustomerStatus"`
+    //         : Prisma.sql`AND TRUE`
+    //     }
+    // `;
+
+    const customers = await prisma.client.findMany({
+      where: {
+        tenantId,
+        name: {
+          contains: validatedFilters.name,
+          mode: 'insensitive',
+        },
+        ...(validatedFilters.status && {
+          status: validatedFilters.status as ClientStatus,
+        }),
+      },
+    });
 
     return NextResponse.json(customers);
@@ -60 +71 @@
       data: {
         ...validatedData,
-        // userId,
         tenantId,
       },