From 10aa3d34bc599232af07d8a643c9938be14cb5bf Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Mon, 8 Sep 2025 10:33:01 +0000
Subject: (김준회) 입찰 인터페이스 처리, 자재그룹명 매핑 수정, 자재그룹 뷰
 수정, 부서별 도메인 할당시 동기화 처리, 도메인 부서 할당 다이얼로그 부서목록
 스크롤 처리, 삼성중공업 사용자 global search 개선
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/material/material-group-service.ts | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'lib/material')

diff --git a/lib/material/material-group-service.ts b/lib/material/material-group-service.ts
index 216cd0e6..50ab5164 100644
--- a/lib/material/material-group-service.ts
+++ b/lib/material/material-group-service.ts
@@ -6,7 +6,7 @@ import { materialSearchView } from "@/db/schema/items";
 
 export interface MaterialSearchItem {
   materialGroupCode: string;
-  materialName: string;
+  materialGroupDesc: string;
   displayText: string;
 }
 
@@ -40,7 +40,7 @@ export async function searchMaterialsForSelector(
       const searchPattern = `%${query.trim()}%`;
       searchWhere = sql`(
         ${materialSearchView.materialGroupCode} ILIKE ${searchPattern} OR 
-        ${materialSearchView.materialName} ILIKE ${searchPattern} OR 
+        ${materialSearchView.materialGroupDesc} ILIKE ${searchPattern} OR 
         ${materialSearchView.displayText} ILIKE ${searchPattern}
       )`;
     }
@@ -51,7 +51,7 @@ export async function searchMaterialsForSelector(
         .select()
         .from(materialSearchView)
         .where(searchWhere)
-        .orderBy(materialSearchView.materialGroupCode, materialSearchView.materialName)
+        .orderBy(materialSearchView.materialGroupCode, materialSearchView.materialGroupDesc)
         .limit(perPage)
         .offset(offset);
 
@@ -66,7 +66,7 @@ export async function searchMaterialsForSelector(
       return {
         data: data.map((row) => ({
           materialGroupCode: row.materialGroupCode,
-          materialName: row.materialName,
+          materialGroupDesc: row.materialGroupDesc,
           displayText: row.displayText,
         })),
         total,
-- 
cgit v1.2.3