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-groups/services.ts | 4 ----
 1 file changed, 4 deletions(-)

(limited to 'lib/material-groups/services.ts')

diff --git a/lib/material-groups/services.ts b/lib/material-groups/services.ts
index ff2b7f70..ecbbc9e8 100644
--- a/lib/material-groups/services.ts
+++ b/lib/material-groups/services.ts
@@ -44,7 +44,6 @@ export async function getMaterialGroups(input: GetMaterialGroupsInput) {
       globalWhere = or(
         ilike(materialSearchView.materialGroupCode, s),      // 자재그룹코드
         ilike(materialSearchView.materialGroupDesc, s),     // 자재그룹 설명
-        ilike(materialSearchView.displayText, s),            // 표시 텍스트
       );
     }
 
@@ -64,7 +63,6 @@ export async function getMaterialGroups(input: GetMaterialGroupsInput) {
         .select({
           materialGroupCode: materialSearchView.materialGroupCode,
           materialGroupDesc: materialSearchView.materialGroupDesc,
-          displayText: materialSearchView.displayText,
         })
         .from(materialSearchView)
         .where(finalWhere)
@@ -114,7 +112,6 @@ export async function getMaterialGroupsInfinite(input: GetMaterialGroupsInfinite
       globalWhere = or(
         ilike(materialSearchView.materialGroupCode, s),
         ilike(materialSearchView.materialGroupDesc, s),
-        ilike(materialSearchView.displayText, s),
       );
     }
 
@@ -133,7 +130,6 @@ export async function getMaterialGroupsInfinite(input: GetMaterialGroupsInfinite
       .select({
         materialGroupCode: materialSearchView.materialGroupCode,
         materialGroupDesc: materialSearchView.materialGroupDesc,
-        displayText: materialSearchView.displayText,
       })
       .from(materialSearchView)
       .where(finalWhere)
-- 
cgit v1.2.3