From caa01b321311de3983fb8bcf65bb20a6c047cf57 Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Tue, 9 Sep 2025 10:40:11 +0000
Subject: (김준회) 자재그룹코드 및 자재그룹명에 대해 별도 테이블 생성, 동기화
 로직 작성(일회성 사용이며 수신시점에는 자동저장하므로 추후 사용 불필요),
 자재그룹 선택기를 변경사항에 맞춰 업데이트, 자재그룹명은 MAKTX 로 김학의 프로
 답변에 따라 변경
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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

(limited to 'lib/material/material-group-service.ts')

diff --git a/lib/material/material-group-service.ts b/lib/material/material-group-service.ts
index 50ab5164..ae0ca725 100644
--- a/lib/material/material-group-service.ts
+++ b/lib/material/material-group-service.ts
@@ -7,7 +7,7 @@ import { materialSearchView } from "@/db/schema/items";
 export interface MaterialSearchItem {
   materialGroupCode: string;
   materialGroupDesc: string;
-  displayText: string;
+  displayText: string; // 애플리케이션 레벨에서 계산된 필드
 }
 
 export interface MaterialSearchResult {
@@ -40,8 +40,7 @@ export async function searchMaterialsForSelector(
       const searchPattern = `%${query.trim()}%`;
       searchWhere = sql`(
         ${materialSearchView.materialGroupCode} ILIKE ${searchPattern} OR 
-        ${materialSearchView.materialGroupDesc} ILIKE ${searchPattern} OR 
-        ${materialSearchView.displayText} ILIKE ${searchPattern}
+        ${materialSearchView.materialGroupDesc} ILIKE ${searchPattern}
       )`;
     }
 
@@ -67,7 +66,7 @@ export async function searchMaterialsForSelector(
         data: data.map((row) => ({
           materialGroupCode: row.materialGroupCode,
           materialGroupDesc: row.materialGroupDesc,
-          displayText: row.displayText,
+          displayText: `${row.materialGroupCode || ''} - ${row.materialGroupDesc || ''}`, // 애플리케이션 레벨에서 생성
         })),
         total,
       };
-- 
cgit v1.2.3