diff options
Diffstat (limited to 'lib/items')
| -rw-r--r-- | lib/items/service.ts | 3 | ||||
| -rw-r--r-- | lib/items/table/items-table.tsx | 50 |
2 files changed, 14 insertions, 39 deletions
diff --git a/lib/items/service.ts b/lib/items/service.ts index c841efad..1b6d7e09 100644 --- a/lib/items/service.ts +++ b/lib/items/service.ts @@ -42,13 +42,12 @@ export async function getItems(input: GetItemsSchema) { if (input.search) { const s = `%${input.search}%`; globalWhere = or( - ilike(items.itemLevel, s), + ilike(items.ProjectNo, s), ilike(items.itemCode, s), ilike(items.itemName, s), ilike(items.smCode, s), ilike(items.packageCode, s), ilike(items.description, s), - ilike(items.changeDate, s) ); } diff --git a/lib/items/table/items-table.tsx b/lib/items/table/items-table.tsx index 92f805eb..8baaf69c 100644 --- a/lib/items/table/items-table.tsx +++ b/lib/items/table/items-table.tsx @@ -59,60 +59,36 @@ export function ItemsTable({ promises }: ItemsTableProps) { const advancedFilterFields: DataTableAdvancedFilterField<Item>[] = [ { - id: "itemLevel", - label: "레벨", - type: "number", - }, - { - id: "itemCode", - label: "자재그룹코드", + id: "ProjectNo", + label: "Project No", type: "text", }, { - id: "itemName", - label: "자재그룹이름", + id: "itemCode", + label: "PKG Code(PK)", type: "text", }, { id: "description", - label: "상세", + label: "PKG Code Decription", type: "text", }, { - id: "parentItemCode", - label: "부모 아이템 코드", + id: "packageCode", + label: "PKG Code", type: "text", }, { - id: "deleteFlag", - label: "삭제 플래그", - type: "text", - }, - { - id: "unitOfMeasure", - label: "단위", - type: "text", - }, - { - id: "steelType", - label: "강종", - type: "text", - }, - { - id: "gradeMaterial", - label: "등급 재질", - type: "text", - }, - { - id: "changeDate", - label: "변경일자", - type: "text", + id: "itemName", + label: "패키지 이름", + type: "text" }, { - id: "baseUnitOfMeasure", - label: "기본단위", + id: "smCode", + label: "SM Code", type: "text", }, + ] // 확장된 useDataTable 훅 사용 (pageSize 기반 자동 전환) |