diff options
| author | joonhoekim <26rote@gmail.com> | 2025-09-08 10:33:01 +0000 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-09-08 10:33:01 +0000 |
| commit | 10aa3d34bc599232af07d8a643c9938be14cb5bf (patch) | |
| tree | 9e9a94e89642e80024647de175de6f217daab682 /lib/material | |
| parent | f93493f68c9f368e10f1c3379f1c1384068e3b14 (diff) | |
(김준회) 입찰 인터페이스 처리, 자재그룹명 매핑 수정, 자재그룹 뷰 수정, 부서별 도메인 할당시 동기화 처리, 도메인 부서 할당 다이얼로그 부서목록 스크롤 처리, 삼성중공업 사용자 global search 개선
Diffstat (limited to 'lib/material')
| -rw-r--r-- | lib/material/material-group-service.ts | 8 |
1 files changed, 4 insertions, 4 deletions
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, |