Fix stock opname and product search where

1 files changed, 6 insertions, 5 deletions

diff --git a/src/app/api/stock-opname/route.tsx b/src/app/api/stock-opname/route.tsx
index 3aa9d06..ef4e1d5 100644
--- a/src/app/api/stock-opname/route.tsx
+++ b/src/app/api/stock-opname/route.tsx
@@ -1,5 +1,5 @@
 import { StockOpnameLocationRes, StockOpnameRequest } from "@/common/types/stockOpname";
-import { Team } from "@prisma/client";
+import { Prisma, Team } from "@prisma/client";
 import { NextRequest, NextResponse } from "next/server";
 import { prisma } from "prisma/client";
 import _ from "lodash"
@@ -23,15 +23,16 @@ export async function GET(request: NextRequest) {
     return NextResponse.json({ error: 'Bad Request. Missing companyId' }, { status: 400 })
   }
 
-  const where = {
+  const where: Prisma.ProductWhereInput = {
     AND: {
       stockOpnames: { some: {} },
       companyId: parseInt(companyId),
       isDifferent: show ? (show == 'diff' ? true : false) : undefined,
       OR: [
-        { name: { contains: search ?? '' } },
-        { itemCode: { contains: search ?? '' } },
-        { barcode: { contains: search ?? '' } },
+        { name: { mode: 'insensitive', contains: search ?? '' } },
+        { itemCode: { mode: 'insensitive', contains: search ?? '' } },
+        { barcode: { mode: 'insensitive', contains: search ?? '' } },
+        { stockOpnames: { some: { location: { name: { mode: 'insensitive', contains: search ?? '' } } } } },
       ]
     }
   }