diff options
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) |