(대표님) 작업사항 - rfqLast, tbeLast, pdfTron, userAuth

1 files changed, 4 insertions, 3 deletions

diff --git a/lib/users/repository.ts b/lib/users/repository.ts
index 121a1eaa..46ee1e48 100644
--- a/lib/users/repository.ts
+++ b/lib/users/repository.ts
@@ -2,7 +2,7 @@
 import db from '@/db/db';
 import { users, otps, type User, Role, roles, userRoles } from '@/db/schema/users';
 import { Otp } from '@/types/user';
-import { eq,and ,asc} from 'drizzle-orm';
+import { eq,and ,asc,sql} from 'drizzle-orm';
 
 // 모든 사용자 조회
 export const getAllUsers = async (): Promise<User[]> => {
@@ -55,12 +55,13 @@ export const getUserByEmail = async (
 ): Promise<User | null> => {
   const { includeInactive = false } = options
   
-  let whereCondition = eq(users.email, email)
+  let whereCondition =  sql`LOWER(${users.email}) = LOWER(${email})`
   
   // 기본적으로 활성 사용자만 조회
   if (!includeInactive) {
     whereCondition = and(
-      eq(users.email, email),
+      // eq(users.email, email),
+      sql`LOWER(${users.email}) = LOWER(${email})`, 
       eq(users.isActive, true)
     )!
   }