diff options
Diffstat (limited to 'lib/material/material-group-service.ts')
| -rw-r--r-- | lib/material/material-group-service.ts | 7 |
1 files changed, 3 insertions, 4 deletions
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, }; |