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-groups/services.ts | |
| parent | f93493f68c9f368e10f1c3379f1c1384068e3b14 (diff) | |
(김준회) 입찰 인터페이스 처리, 자재그룹명 매핑 수정, 자재그룹 뷰 수정, 부서별 도메인 할당시 동기화 처리, 도메인 부서 할당 다이얼로그 부서목록 스크롤 처리, 삼성중공업 사용자 global search 개선
Diffstat (limited to 'lib/material-groups/services.ts')
| -rw-r--r-- | lib/material-groups/services.ts | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/lib/material-groups/services.ts b/lib/material-groups/services.ts index 4b7e9dea..ff2b7f70 100644 --- a/lib/material-groups/services.ts +++ b/lib/material-groups/services.ts @@ -22,7 +22,7 @@ export interface GetMaterialGroupsInput { /** * 자재그룹 목록을 조회합니다. - * materialSearchView를 사용하여 MATKL(자재그룹코드)와 ZZNAME(자재그룹명)의 고유한 조합을 조회 + * materialSearchView를 사용하여 MATKL(자재그룹코드)와 ATWTB(자재그룹 설명)의 고유한 조합을 조회 */ export async function getMaterialGroups(input: GetMaterialGroupsInput) { const safePerPage = Math.min(input.perPage, 100); @@ -43,7 +43,7 @@ export async function getMaterialGroups(input: GetMaterialGroupsInput) { const s = `%${input.search}%`; globalWhere = or( ilike(materialSearchView.materialGroupCode, s), // 자재그룹코드 - ilike(materialSearchView.materialName, s), // 자재그룹명 + ilike(materialSearchView.materialGroupDesc, s), // 자재그룹 설명 ilike(materialSearchView.displayText, s), // 표시 텍스트 ); } @@ -63,7 +63,7 @@ export async function getMaterialGroups(input: GetMaterialGroupsInput) { const data = await tx .select({ materialGroupCode: materialSearchView.materialGroupCode, - materialName: materialSearchView.materialName, + materialGroupDesc: materialSearchView.materialGroupDesc, displayText: materialSearchView.displayText, }) .from(materialSearchView) @@ -113,7 +113,7 @@ export async function getMaterialGroupsInfinite(input: GetMaterialGroupsInfinite const s = `%${input.search}%`; globalWhere = or( ilike(materialSearchView.materialGroupCode, s), - ilike(materialSearchView.materialName, s), + ilike(materialSearchView.materialGroupDesc, s), ilike(materialSearchView.displayText, s), ); } @@ -132,7 +132,7 @@ export async function getMaterialGroupsInfinite(input: GetMaterialGroupsInfinite const data = await db .select({ materialGroupCode: materialSearchView.materialGroupCode, - materialName: materialSearchView.materialName, + materialGroupDesc: materialSearchView.materialGroupDesc, displayText: materialSearchView.displayText, }) .from(materialSearchView) |