diff options
Diffstat (limited to 'lib/items-tech')
23 files changed, 5406 insertions, 0 deletions
diff --git a/lib/items-tech/repository.ts b/lib/items-tech/repository.ts new file mode 100644 index 00000000..550e6b1d --- /dev/null +++ b/lib/items-tech/repository.ts @@ -0,0 +1,125 @@ +// src/lib/items/repository.ts +import db from "@/db/db"; +import { Item, items } from "@/db/schema/items"; +import { + eq, + inArray, + not, + asc, + desc, + and, + ilike, + gte, + lte, + count, + gt, +} from "drizzle-orm"; +import { PgTransaction } from "drizzle-orm/pg-core"; +export type NewItem = typeof items.$inferInsert + +/** + * 단건/복수 조회 시 공통으로 사용 가능한 SELECT 함수 예시 + * - 트랜잭션(tx)을 받아서 사용하도록 구현 + */ +export async function selectItems( + tx: PgTransaction<any, any, any>, + params: { + where?: any; // drizzle-orm의 조건식 (and, eq...) 등 + orderBy?: (ReturnType<typeof asc> | ReturnType<typeof desc>)[]; + offset?: number; + limit?: number; + } +) { + const { where, orderBy, offset = 0, limit = 10 } = params; + + return tx + .select() + .from(items) + .where(where) + .orderBy(...(orderBy ?? [])) + .offset(offset) + .limit(limit); +} +/** 총 개수 count */ +export async function countItems( + tx: PgTransaction<any, any, any>, + where?: any +) { + const res = await tx.select({ count: count() }).from(items).where(where); + return res[0]?.count ?? 0; +} + +/** 단건 Insert 예시 */ +export async function insertItem( + tx: PgTransaction<any, any, any>, + data: NewItem // DB와 동일한 insert 가능한 타입 +) { + // returning() 사용 시 배열로 돌아오므로 [0]만 리턴 + return tx + .insert(items) + .values(data) + .returning({ id: items.id, createdAt: items.createdAt }); +} + +/** 복수 Insert 예시 */ +export async function insertItems( + tx: PgTransaction<any, any, any>, + data: Item[] +) { + return tx.insert(items).values(data).onConflictDoNothing(); +} + + + +/** 단건 삭제 */ +export async function deleteItemById( + tx: PgTransaction<any, any, any>, + itemId: number +) { + return tx.delete(items).where(eq(items.id, itemId)); +} + +/** 복수 삭제 */ +export async function deleteItemsByIds( + tx: PgTransaction<any, any, any>, + ids: number[] +) { + return tx.delete(items).where(inArray(items.id, ids)); +} + +/** 전체 삭제 */ +export async function deleteAllItems( + tx: PgTransaction<any, any, any>, +) { + return tx.delete(items); +} + +/** 단건 업데이트 */ +export async function updateItem( + tx: PgTransaction<any, any, any>, + itemId: number, + data: Partial<Item> +) { + return tx + .update(items) + .set(data) + .where(eq(items.id, itemId)) + .returning({ id: items.id, createdAt: items.createdAt }); +} + +/** 복수 업데이트 */ +export async function updateItems( + tx: PgTransaction<any, any, any>, + ids: number[], + data: Partial<Item> +) { + return tx + .update(items) + .set(data) + .where(inArray(items.id, ids)) + .returning({ id: items.id, createdAt: items.createdAt }); +} + +export async function findAllItems(): Promise<Item[]> { + return db.select().from(items).orderBy(asc(items.itemCode)); +} diff --git a/lib/items-tech/service.ts b/lib/items-tech/service.ts new file mode 100644 index 00000000..97aacfba --- /dev/null +++ b/lib/items-tech/service.ts @@ -0,0 +1,1139 @@ +// src/lib/items-ship/service.ts
+"use server"; // Next.js 서버 액션에서 직접 import하려면 (선택)
+
+import { revalidateTag, unstable_noStore } from "next/cache";
+import db from "@/db/db";
+
+import { filterColumns } from "@/lib/filter-columns";
+import { unstable_cache } from "@/lib/unstable-cache";
+import { getErrorMessage } from "@/lib/handle-error";
+
+import { asc, desc, ilike, and, or, eq, count, inArray, sql } from "drizzle-orm";
+import { GetItemsSchema, UpdateItemSchema, ShipbuildingItemCreateData, TypedItemCreateData, OffshoreTopItemCreateData, OffshoreHullItemCreateData } from "./validations";
+import { Item, items, itemShipbuilding, itemOffshoreTop, itemOffshoreHull } from "@/db/schema/items";
+import { findAllItems, insertItem, updateItem } from "./repository";
+
+/* -----------------------------------------------------
+ 1) 조회 관련
+----------------------------------------------------- */
+
+/**
+ * 복잡한 조건으로 Item 목록을 조회 (+ pagination) 하고,
+ * 총 개수에 따라 pageCount를 계산해서 리턴.
+ * Next.js의 unstable_cache를 사용해 일정 시간 캐시.
+ */
+export async function getShipbuildingItems(input: GetItemsSchema) {
+ return unstable_cache(
+ async () => {
+ try {
+ const offset = (input.page - 1) * input.perPage;
+
+ // advancedTable 모드면 filterColumns()로 where 절 구성
+ const advancedWhere = filterColumns({
+ table: items,
+ filters: input.filters,
+ joinOperator: input.joinOperator,
+ });
+
+ let globalWhere;
+ if (input.search) {
+ const s = `%${input.search}%`;
+ globalWhere = or(
+ ilike(items.itemCode, s),
+ ilike(items.itemName, s),
+ ilike(items.description, s)
+ );
+ }
+
+ const finalWhere = and(
+ advancedWhere,
+ globalWhere
+ );
+
+ const where = finalWhere;
+
+ const orderBy =
+ input.sort.length > 0
+ ? input.sort.map((item) =>
+ item.desc ? desc(items[item.id]) : asc(items[item.id])
+ )
+ : [asc(items.createdAt)];
+
+ // 조선 아이템 테이블과 기본 아이템 테이블 조인하여 조회
+ const result = await db.select({
+ id: itemShipbuilding.id,
+ itemId: itemShipbuilding.itemId,
+ workType: itemShipbuilding.workType,
+ shipTypes: itemShipbuilding.shipTypes,
+ itemCode: items.itemCode,
+ itemName: items.itemName,
+ description: items.description,
+ createdAt: itemShipbuilding.createdAt,
+ updatedAt: itemShipbuilding.updatedAt,
+ })
+ .from(itemShipbuilding)
+ .innerJoin(items, eq(itemShipbuilding.itemId, items.id))
+ .where(where)
+ .orderBy(...orderBy)
+ .offset(offset)
+ .limit(input.perPage);
+
+ // 전체 데이터 개수 조회
+ const [{ count: total }] = await db.select({
+ count: count()
+ })
+ .from(itemShipbuilding)
+ .innerJoin(items, eq(itemShipbuilding.itemId, items.id))
+ .where(where);
+
+ const pageCount = Math.ceil(Number(total) / input.perPage);
+
+ return { data: result, pageCount };
+ } catch (err) {
+ console.error("Error fetching shipbuilding items:", err);
+ return { data: [], pageCount: 0 };
+ }
+ },
+ [JSON.stringify(input)],
+ {
+ revalidate: 3600,
+ tags: ["items"],
+ }
+ )();
+}
+
+export async function getOffshoreTopItems(input: GetItemsSchema) {
+ return unstable_cache(
+ async () => {
+ try {
+ const offset = (input.page - 1) * input.perPage;
+
+ // advancedTable 모드면 filterColumns()로 where 절 구성
+ const advancedWhere = filterColumns({
+ table: items,
+ filters: input.filters,
+ joinOperator: input.joinOperator,
+ });
+
+ let globalWhere;
+ if (input.search) {
+ const s = `%${input.search}%`;
+ globalWhere = or(
+ ilike(items.itemCode, s),
+ ilike(items.itemName, s),
+ ilike(items.description, s)
+ );
+ }
+
+ const finalWhere = and(
+ advancedWhere,
+ globalWhere
+ );
+
+ const where = finalWhere;
+
+ const orderBy =
+ input.sort.length > 0
+ ? input.sort.map((item) =>
+ item.desc ? desc(items[item.id]) : asc(items[item.id])
+ )
+ : [asc(items.createdAt)];
+
+ // 해양 TOP 아이템 테이블과 기본 아이템 테이블 조인하여 조회
+ const result = await db.select({
+ id: itemOffshoreTop.id,
+ itemId: itemOffshoreTop.itemId,
+ workType: itemOffshoreTop.workType,
+ itemList1: itemOffshoreTop.itemList1,
+ itemList2: itemOffshoreTop.itemList2,
+ itemList3: itemOffshoreTop.itemList3,
+ itemList4: itemOffshoreTop.itemList4,
+ itemCode: items.itemCode,
+ itemName: items.itemName,
+ description: items.description,
+ createdAt: itemOffshoreTop.createdAt,
+ updatedAt: itemOffshoreTop.updatedAt,
+ })
+ .from(itemOffshoreTop)
+ .innerJoin(items, eq(itemOffshoreTop.itemId, items.id))
+ .where(where)
+ .orderBy(...orderBy)
+ .offset(offset)
+ .limit(input.perPage);
+
+ // 전체 데이터 개수 조회
+ const [{ count: total }] = await db.select({
+ count: count()
+ })
+ .from(itemOffshoreTop)
+ .innerJoin(items, eq(itemOffshoreTop.itemId, items.id))
+ .where(where);
+
+ const pageCount = Math.ceil(Number(total) / input.perPage);
+
+ return { data: result, pageCount };
+ } catch (err) {
+ console.error("Error fetching offshore top items:", err);
+ return { data: [], pageCount: 0 };
+ }
+ },
+ [JSON.stringify(input)],
+ {
+ revalidate: 3600,
+ tags: ["items"],
+ }
+ )();
+}
+
+export async function getOffshoreHullItems(input: GetItemsSchema) {
+ return unstable_cache(
+ async () => {
+ try {
+ const offset = (input.page - 1) * input.perPage;
+
+ // advancedTable 모드면 filterColumns()로 where 절 구성
+ const advancedWhere = filterColumns({
+ table: items,
+ filters: input.filters,
+ joinOperator: input.joinOperator,
+ });
+
+ let globalWhere;
+ if (input.search) {
+ const s = `%${input.search}%`;
+ globalWhere = or(
+ ilike(items.itemCode, s),
+ ilike(items.itemName, s),
+ ilike(items.description, s)
+ );
+ }
+
+ const finalWhere = and(
+ advancedWhere,
+ globalWhere
+ );
+
+ const where = finalWhere;
+
+ const orderBy =
+ input.sort.length > 0
+ ? input.sort.map((item) =>
+ item.desc ? desc(items[item.id]) : asc(items[item.id])
+ )
+ : [asc(items.createdAt)];
+
+ // 해양 HULL 아이템 테이블과 기본 아이템 테이블 조인하여 조회
+ const result = await db.select({
+ id: itemOffshoreHull.id,
+ itemId: itemOffshoreHull.itemId,
+ workType: itemOffshoreHull.workType,
+ itemList1: itemOffshoreHull.itemList1,
+ itemList2: itemOffshoreHull.itemList2,
+ itemList3: itemOffshoreHull.itemList3,
+ itemList4: itemOffshoreHull.itemList4,
+ itemCode: items.itemCode,
+ itemName: items.itemName,
+ description: items.description,
+ createdAt: itemOffshoreHull.createdAt,
+ updatedAt: itemOffshoreHull.updatedAt,
+ })
+ .from(itemOffshoreHull)
+ .innerJoin(items, eq(itemOffshoreHull.itemId, items.id))
+ .where(where)
+ .orderBy(...orderBy)
+ .offset(offset)
+ .limit(input.perPage);
+
+ // 전체 데이터 개수 조회
+ const [{ count: total }] = await db.select({
+ count: count()
+ })
+ .from(itemOffshoreHull)
+ .innerJoin(items, eq(itemOffshoreHull.itemId, items.id))
+ .where(where);
+
+ const pageCount = Math.ceil(Number(total) / input.perPage);
+
+ return { data: result, pageCount };
+ } catch (err) {
+ console.error("Error fetching offshore hull items:", err);
+ return { data: [], pageCount: 0 };
+ }
+ },
+ [JSON.stringify(input)],
+ {
+ revalidate: 3600,
+ tags: ["items"],
+ }
+ )();
+}
+
+/* -----------------------------------------------------
+ 2) 생성(Create)
+----------------------------------------------------- */
+
+/**
+ * Item 생성 - 아이템 타입에 따라 해당 테이블에 데이터 삽입
+ */
+export async function createShipbuildingItem(input: TypedItemCreateData) {
+ unstable_noStore()
+
+ try {
+ if (!input.itemCode || !input.itemName) {
+ return {
+ success: false,
+ message: "아이템 코드와 아이템 명은 필수입니다",
+ data: null,
+ error: "필수 필드 누락"
+ }
+ }
+ const result = await db.transaction(async (tx) => {
+ // 1. itemCode 정규화해서 직접 쿼리
+ const existRows = await tx.select().from(items)
+ .where(eq(items.itemCode, input.itemCode));
+ const existingItem = existRows[0];
+
+ let itemId: number;
+ let itemResult;
+
+ if (existingItem) {
+ // 이미 있으면 업데이트
+ itemResult = await updateItem(tx, existingItem.id, {
+ itemName: input.itemName,
+ description: input.description,
+ });
+ itemId = existingItem.id;
+ } else {
+ // 없으면 새로 생성
+ // 현재 가장 큰 ID 값 가져오기
+ const maxIdResult = await tx.select({ maxId: sql`MAX(id)` }).from(items);
+ const maxId = maxIdResult[0]?.maxId || 0;
+ const newId = Number(maxId) + 1;
+
+ // 새 ID로 아이템 생성
+ itemResult = await tx.insert(items).values({
+ id: newId,
+ itemCode: input.itemCode,
+ itemName: input.itemName,
+ description: input.description,
+ }).returning();
+
+ itemId = itemResult[0].id;
+ }
+
+ const shipData = input as ShipbuildingItemCreateData;
+ const typeResult = await tx.insert(itemShipbuilding).values({
+ itemId: itemId,
+ workType: shipData.workType ? (shipData.workType as '기장' | '전장' | '선실' | '배관' | '철의') : '기장',
+ shipTypes: shipData.shipTypes || '',
+ createdAt: new Date(),
+ updatedAt: new Date()
+ }).returning();
+
+ return { itemData: itemResult[0], shipbuildingData: typeResult[0] };
+ })
+
+ revalidateTag("items")
+
+ return {
+ success: true,
+ data: result || null,
+ error: null
+ }
+ } catch (err) {
+ console.error("아이템 생성/업데이트 오류:", err)
+
+ if (err instanceof Error && err.message.includes("unique constraint")) {
+ return {
+ success: false,
+ message: "이미 존재하는 아이템 코드입니다",
+ data: null,
+ error: "중복 키 오류"
+ }
+ }
+
+ return {
+ success: false,
+ message: getErrorMessage(err),
+ data: null,
+ error: getErrorMessage(err)
+ }
+ }
+}
+
+/**
+ * Excel import를 위한 조선 아이템 생성 함수
+ * 하나의 아이템 코드에 대해 여러 선종을 처리 (1:N 관계)
+ */
+export async function createShipbuildingImportItem(input: {
+ itemCode: string;
+ itemName: string;
+ workType: '기장' | '전장' | '선실' | '배관' | '철의';
+ description?: string | null;
+ shipTypes: Record<string, boolean>;
+}) {
+ unstable_noStore();
+
+ try {
+
+ if (!input.itemCode || !input.itemName) {
+ return {
+ success: false,
+ message: "아이템 코드와 아이템 명은 필수입니다",
+ data: null,
+ error: "필수 필드 누락"
+ }
+ }
+ const results = await db.transaction(async (tx) => {
+ // 1. itemCode 정규화해서 직접 쿼리
+ const existRows = await tx.select().from(items)
+ .where(eq(items.itemCode, input.itemCode));
+ const existingItem = existRows[0];
+
+ console.log('DB에서 직접 조회한 기존 아이템:', existingItem);
+
+ let itemId: number;
+
+ if (existingItem) {
+ // 이미 있으면 업데이트
+ await updateItem(tx, existingItem.id, {
+ itemName: input.itemName,
+ description: input.description,
+ });
+ itemId = existingItem.id;
+ console.log('기존 아이템 업데이트, id:', itemId);
+ } else {
+ // 없으면 새로 생성
+ // 현재 가장 큰 ID 값 가져오기
+ const maxIdResult = await tx.select({ maxId: sql`MAX(id)` }).from(items);
+ const maxId = maxIdResult[0]?.maxId || 0;
+ const newId = Number(maxId) + 1;
+ console.log('새 아이템 생성을 위한 ID 계산:', { maxId, newId });
+
+ // 새 ID로 아이템 생성
+ const insertResult = await tx.insert(items).values({
+ id: newId,
+ itemCode: input.itemCode,
+ itemName: input.itemName,
+ description: input.description,
+ }).returning();
+
+ itemId = insertResult[0].id;
+ console.log('새 아이템 생성 완료, id:', itemId);
+ }
+
+ const createdItems = [];
+ for (const shipType of Object.keys(input.shipTypes)) {
+ // 그대로 선종명 string으로 저장
+ const existShip = await tx.select().from(itemShipbuilding)
+ .where(
+ and(
+ eq(itemShipbuilding.itemId, itemId),
+ eq(itemShipbuilding.shipTypes, shipType)
+ )
+ );
+ if (!existShip[0]) {
+ const shipbuildingResult = await tx.insert(itemShipbuilding).values({
+ itemId: itemId,
+ workType: input.workType,
+ shipTypes: shipType,
+ createdAt: new Date(),
+ updatedAt: new Date()
+ }).returning();
+ createdItems.push({
+ ...shipbuildingResult[0]
+ });
+ console.log('조선아이템 생성:', shipType, shipbuildingResult[0]);
+ } else {
+ console.log('이미 존재하는 조선아이템:', shipType);
+ }
+ }
+ return createdItems;
+ });
+
+ revalidateTag("items");
+
+ return {
+ success: true,
+ data: results,
+ error: null
+ }
+ } catch (err) {
+
+ return {
+ success: false,
+ message: getErrorMessage(err),
+ data: null,
+ error: getErrorMessage(err)
+ }
+ }
+}
+
+export async function createOffshoreTopItem(data: OffshoreTopItemCreateData) {
+ unstable_noStore()
+
+ try {
+ if (!data.itemCode || !data.itemName) {
+ return {
+ success: false,
+ message: "아이템 코드와 아이템 명은 필수입니다",
+ data: null,
+ error: "필수 필드 누락"
+ }
+ }
+
+ // 트랜잭션 내에서 처리
+ const result = await db.transaction(async (tx) => {
+ // 1. itemCode 정규화해서 직접 쿼리
+ const existRows = await tx.select().from(items)
+ .where(eq(items.itemCode, data.itemCode));
+ const existingItem = existRows[0];
+
+ let itemId: number;
+ let itemResult;
+
+ if (existingItem) {
+ // 이미 있으면 업데이트
+ itemResult = await updateItem(tx, existingItem.id, {
+ itemName: data.itemName,
+ description: data.description,
+ });
+ itemId = existingItem.id;
+ } else {
+ // 없으면 새로 생성
+ // 현재 가장 큰 ID 값 가져오기
+ const maxIdResult = await tx.select({ maxId: sql`MAX(id)` }).from(items);
+ const maxId = maxIdResult[0]?.maxId || 0;
+ const newId = Number(maxId) + 1;
+
+ // 새 ID로 아이템 생성
+ itemResult = await tx.insert(items).values({
+ id: newId,
+ itemCode: data.itemCode,
+ itemName: data.itemName,
+ description: data.description,
+ }).returning();
+
+ itemId = itemResult[0].id;
+ }
+
+ const [offshoreTop] = await tx
+ .insert(itemOffshoreTop)
+ .values({
+ itemId: itemId,
+ workType: data.workType,
+ itemList1: data.itemList1 || null,
+ itemList2: data.itemList2 || null,
+ itemList3: data.itemList3 || null,
+ itemList4: data.itemList4 || null,
+ createdAt: new Date(),
+ updatedAt: new Date()
+ })
+ .returning();
+
+ return { itemData: itemResult[0], offshoreTopData: offshoreTop };
+ })
+
+ revalidateTag("items")
+
+ return {
+ success: true,
+ data: result,
+ error: null
+ }
+ } catch (err) {
+ console.error("아이템 생성/업데이트 오류:", err)
+
+ if (err instanceof Error && err.message.includes("unique constraint")) {
+ return {
+ success: false,
+ message: "이미 존재하는 아이템 코드입니다",
+ data: null,
+ error: "중복 키 오류"
+ }
+ }
+
+ return {
+ success: false,
+ message: getErrorMessage(err),
+ data: null,
+ error: getErrorMessage(err)
+ }
+ }
+}
+
+export async function createOffshoreHullItem(data: OffshoreHullItemCreateData) {
+ unstable_noStore()
+
+ try {
+ if (!data.itemCode || !data.itemName) {
+ return {
+ success: false,
+ message: "아이템 코드와 아이템 명은 필수입니다",
+ data: null,
+ error: "필수 필드 누락"
+ }
+ }
+
+ // 트랜잭션 내에서 처리
+ const result = await db.transaction(async (tx) => {
+ // 1. itemCode 정규화해서 직접 쿼리
+ const existRows = await tx.select().from(items)
+ .where(eq(items.itemCode, data.itemCode));
+ const existingItem = existRows[0];
+
+ let itemId: number;
+ let itemResult;
+
+ if (existingItem) {
+ // 이미 있으면 업데이트
+ itemResult = await updateItem(tx, existingItem.id, {
+ itemName: data.itemName,
+ description: data.description,
+ });
+ itemId = existingItem.id;
+ } else {
+ // 없으면 새로 생성
+ // 현재 가장 큰 ID 값 가져오기
+ const maxIdResult = await tx.select({ maxId: sql`MAX(id)` }).from(items);
+ const maxId = maxIdResult[0]?.maxId || 0;
+ const newId = Number(maxId) + 1;
+
+ // 새 ID로 아이템 생성
+ itemResult = await tx.insert(items).values({
+ id: newId,
+ itemCode: data.itemCode,
+ itemName: data.itemName,
+ description: data.description,
+ }).returning();
+
+ itemId = itemResult[0].id;
+ }
+
+ const [offshoreHull] = await tx
+ .insert(itemOffshoreHull)
+ .values({
+ itemId: itemId,
+ workType: data.workType,
+ itemList1: data.itemList1 || null,
+ itemList2: data.itemList2 || null,
+ itemList3: data.itemList3 || null,
+ itemList4: data.itemList4 || null,
+ createdAt: new Date(),
+ updatedAt: new Date()
+ })
+ .returning();
+
+ return { itemData: itemResult[0], offshoreHullData: offshoreHull };
+ })
+
+ revalidateTag("items")
+
+ return {
+ success: true,
+ data: result,
+ error: null
+ }
+ } catch (err) {
+ console.error("아이템 생성/업데이트 오류:", err)
+
+ if (err instanceof Error && err.message.includes("unique constraint")) {
+ return {
+ success: false,
+ message: "이미 존재하는 아이템 코드입니다",
+ data: null,
+ error: "중복 키 오류"
+ }
+ }
+
+ return {
+ success: false,
+ message: getErrorMessage(err),
+ data: null,
+ error: getErrorMessage(err)
+ }
+ }
+}
+
+/* -----------------------------------------------------
+ 3) 업데이트
+----------------------------------------------------- */
+
+// 업데이트 타입 정의 인터페이스
+interface UpdateShipbuildingItemInput extends UpdateItemSchema {
+ id: number;
+ workType?: string;
+ shipTypes?: string;
+ itemCode?: string;
+ itemName?: string;
+ description?: string;
+}
+
+/** 단건 업데이트 */
+export async function modifyShipbuildingItem(input: UpdateShipbuildingItemInput) {
+ unstable_noStore();
+ try {
+ const result = await db.transaction(async (tx) => {
+ // 기존 아이템 조회
+ const existingShipbuilding = await tx.query.itemShipbuilding.findFirst({
+ where: eq(itemShipbuilding.id, input.id),
+ with: {
+ item: true
+ }
+ });
+
+ if (!existingShipbuilding) {
+ throw new Error("아이템을 찾을 수 없습니다.");
+ }
+
+ const existingItem = existingShipbuilding.item;
+
+ // 아이템 테이블 정보가 변경되었는지 확인
+ const isItemChanged =
+ (input.itemCode && input.itemCode !== existingItem.itemCode) ||
+ (input.itemName && input.itemName !== existingItem.itemName) ||
+ (input.description !== undefined && input.description !== existingItem.description);
+
+ // 세부 아이템 정보만 변경된 경우
+ if (!isItemChanged) {
+ // 조선 아이템 테이블 업데이트
+ if (input.workType || input.shipTypes) {
+ await tx.update(itemShipbuilding)
+ .set({
+ workType: input.workType as '기장' | '전장' | '선실' | '배관' | '철의',
+ shipTypes: input.shipTypes
+ })
+ .where(eq(itemShipbuilding.id, input.id));
+ }
+
+ return {
+ data: { id: input.id },
+ error: null,
+ success: true,
+ message: "아이템이 성공적으로 업데이트되었습니다."
+ };
+ }
+ // 아이템 테이블 정보가 변경된 경우 - 새 아이템 생성하고 세부 아이템 연결
+ else {
+ // 새 아이템 생성
+ const [newItem] = await insertItem(tx, {
+ itemCode: input.itemCode || existingItem.itemCode,
+ itemName: input.itemName || existingItem.itemName,
+ description: input.description !== undefined ? input.description : existingItem.description,
+ });
+
+ // 세부 아이템 테이블 정보를 새 아이템에 연결
+ await tx.update(itemShipbuilding)
+ .set({
+ itemId: newItem.id,
+ workType: input.workType ? (input.workType as '기장' | '전장' | '선실' | '배관' | '철의') : existingShipbuilding.workType,
+ shipTypes: input.shipTypes || existingShipbuilding.shipTypes
+ })
+ .where(eq(itemShipbuilding.id, input.id));
+
+ return {
+ data: { id: input.id },
+ error: null,
+ success: true,
+ message: "새 아이템이 생성되고 세부 정보가 업데이트되었습니다."
+ };
+ }
+ });
+
+ // 캐시 무효화
+ revalidateTag("items");
+
+ return result;
+ } catch (err) {
+ return {
+ data: null,
+ error: getErrorMessage(err),
+ success: false,
+ message: "아이템 업데이트 중 오류가 발생했습니다."
+ };
+ }
+}
+
+// Offshore TOP 업데이트 타입 정의 인터페이스
+interface UpdateOffshoreTopItemInput extends UpdateItemSchema {
+ id: number;
+ workType?: string;
+ itemList1?: string;
+ itemList2?: string;
+ itemList3?: string;
+ itemList4?: string;
+ itemCode?: string;
+ itemName?: string;
+ description?: string;
+}
+
+/** Offshore TOP 단건 업데이트 */
+export async function modifyOffshoreTopItem(input: UpdateOffshoreTopItemInput) {
+ unstable_noStore();
+ try {
+ const result = await db.transaction(async (tx) => {
+ // 기존 아이템 조회
+ const existingOffshoreTop = await tx.query.itemOffshoreTop.findFirst({
+ where: eq(itemOffshoreTop.id, input.id),
+ with: {
+ item: true
+ }
+ });
+
+ if (!existingOffshoreTop) {
+ throw new Error("아이템을 찾을 수 없습니다.");
+ }
+
+ const existingItem = existingOffshoreTop.item;
+
+ // 아이템 테이블 정보가 변경되었는지 확인
+ const isItemChanged =
+ (input.itemCode && input.itemCode !== existingItem.itemCode) ||
+ (input.itemName && input.itemName !== existingItem.itemName) ||
+ (input.description !== undefined && input.description !== existingItem.description);
+
+ // 세부 아이템 정보만 변경된 경우
+ if (!isItemChanged) {
+ // Offshore TOP 아이템 테이블 업데이트
+ const updateData: Record<string, unknown> = {};
+
+ if (input.workType) updateData.workType = input.workType as 'TM' | 'TS' | 'TE' | 'TP';
+ if (input.itemList1 !== undefined) updateData.itemList1 = input.itemList1;
+ if (input.itemList2 !== undefined) updateData.itemList2 = input.itemList2;
+ if (input.itemList3 !== undefined) updateData.itemList3 = input.itemList3;
+ if (input.itemList4 !== undefined) updateData.itemList4 = input.itemList4;
+
+ if (Object.keys(updateData).length > 0) {
+ await tx.update(itemOffshoreTop)
+ .set(updateData)
+ .where(eq(itemOffshoreTop.id, input.id));
+ }
+
+ return {
+ data: { id: input.id },
+ error: null,
+ success: true,
+ message: "아이템이 성공적으로 업데이트되었습니다."
+ };
+ }
+ // 아이템 테이블 정보가 변경된 경우 - 새 아이템 생성하고 세부 아이템 연결
+ else {
+ // 새 아이템 생성
+ const [newItem] = await insertItem(tx, {
+ itemCode: input.itemCode || existingItem.itemCode,
+ itemName: input.itemName || existingItem.itemName,
+ description: input.description !== undefined ? input.description : existingItem.description,
+ });
+
+ // 세부 아이템 테이블 정보를 새 아이템에 연결
+ const updateData: Record<string, unknown> = {
+ itemId: newItem.id
+ };
+
+ if (input.workType) updateData.workType = input.workType as 'TM' | 'TS' | 'TE' | 'TP';
+ if (input.itemList1 !== undefined) updateData.itemList1 = input.itemList1;
+ if (input.itemList2 !== undefined) updateData.itemList2 = input.itemList2;
+ if (input.itemList3 !== undefined) updateData.itemList3 = input.itemList3;
+ if (input.itemList4 !== undefined) updateData.itemList4 = input.itemList4;
+
+ await tx.update(itemOffshoreTop)
+ .set(updateData)
+ .where(eq(itemOffshoreTop.id, input.id));
+
+ return {
+ data: { id: input.id },
+ error: null,
+ success: true,
+ message: "새 아이템이 생성되고 세부 정보가 업데이트되었습니다."
+ };
+ }
+ });
+
+ // 캐시 무효화
+ revalidateTag("items");
+
+ return result;
+ } catch (err) {
+ return {
+ data: null,
+ error: getErrorMessage(err),
+ success: false,
+ message: "아이템 업데이트 중 오류가 발생했습니다."
+ };
+ }
+}
+
+// Offshore HULL 업데이트 타입 정의 인터페이스
+interface UpdateOffshoreHullItemInput extends UpdateItemSchema {
+ id: number;
+ workType?: string;
+ itemList1?: string;
+ itemList2?: string;
+ itemList3?: string;
+ itemList4?: string;
+ itemCode?: string;
+ itemName?: string;
+ description?: string;
+}
+
+/** Offshore HULL 단건 업데이트 */
+export async function modifyOffshoreHullItem(input: UpdateOffshoreHullItemInput) {
+ unstable_noStore();
+ try {
+ const result = await db.transaction(async (tx) => {
+ // 기존 아이템 조회
+ const existingOffshoreHull = await tx.query.itemOffshoreHull.findFirst({
+ where: eq(itemOffshoreHull.id, input.id),
+ with: {
+ item: true
+ }
+ });
+
+ if (!existingOffshoreHull) {
+ throw new Error("아이템을 찾을 수 없습니다.");
+ }
+
+ const existingItem = existingOffshoreHull.item;
+
+ // 아이템 테이블 정보가 변경되었는지 확인
+ const isItemChanged =
+ (input.itemCode && input.itemCode !== existingItem.itemCode) ||
+ (input.itemName && input.itemName !== existingItem.itemName) ||
+ (input.description !== undefined && input.description !== existingItem.description);
+
+ // 세부 아이템 정보만 변경된 경우
+ if (!isItemChanged) {
+ // Offshore HULL 아이템 테이블 업데이트
+ const updateData: Record<string, unknown> = {};
+
+ if (input.workType) updateData.workType = input.workType as 'HA' | 'HE' | 'HH' | 'HM' | 'NC';
+ if (input.itemList1 !== undefined) updateData.itemList1 = input.itemList1;
+ if (input.itemList2 !== undefined) updateData.itemList2 = input.itemList2;
+ if (input.itemList3 !== undefined) updateData.itemList3 = input.itemList3;
+ if (input.itemList4 !== undefined) updateData.itemList4 = input.itemList4;
+
+ if (Object.keys(updateData).length > 0) {
+ await tx.update(itemOffshoreHull)
+ .set(updateData)
+ .where(eq(itemOffshoreHull.id, input.id));
+ }
+
+ return {
+ data: { id: input.id },
+ error: null,
+ success: true,
+ message: "아이템이 성공적으로 업데이트되었습니다."
+ };
+ }
+ // 아이템 테이블 정보가 변경된 경우 - 새 아이템 생성하고 세부 아이템 연결
+ else {
+ // 새 아이템 생성
+ const [newItem] = await insertItem(tx, {
+ itemCode: input.itemCode || existingItem.itemCode,
+ itemName: input.itemName || existingItem.itemName,
+ description: input.description !== undefined ? input.description : existingItem.description,
+ });
+
+ // 세부 아이템 테이블 정보를 새 아이템에 연결
+ const updateData: Record<string, unknown> = {
+ itemId: newItem.id
+ };
+
+ if (input.workType) updateData.workType = input.workType as 'HA' | 'HE' | 'HH' | 'HM' | 'NC';
+ if (input.itemList1 !== undefined) updateData.itemList1 = input.itemList1;
+ if (input.itemList2 !== undefined) updateData.itemList2 = input.itemList2;
+ if (input.itemList3 !== undefined) updateData.itemList3 = input.itemList3;
+ if (input.itemList4 !== undefined) updateData.itemList4 = input.itemList4;
+
+ await tx.update(itemOffshoreHull)
+ .set(updateData)
+ .where(eq(itemOffshoreHull.id, input.id));
+
+ return {
+ data: { id: input.id },
+ error: null,
+ success: true,
+ message: "새 아이템이 생성되고 세부 정보가 업데이트되었습니다."
+ };
+ }
+ });
+
+ // 캐시 무효화
+ revalidateTag("items");
+
+ return result;
+ } catch (err) {
+ return {
+ data: null,
+ error: getErrorMessage(err),
+ success: false,
+ message: "아이템 업데이트 중 오류가 발생했습니다."
+ };
+ }
+}
+
+/* -----------------------------------------------------
+ 4) 삭제
+----------------------------------------------------- */
+
+// 삭제 타입 정의 인터페이스
+interface DeleteItemInput {
+ id: number;
+}
+
+interface DeleteItemsInput {
+ ids: number[];
+}
+
+/** 단건 삭제 */
+export async function removeShipbuildingItem(input: DeleteItemInput) {
+ unstable_noStore();
+ try {
+ await db.transaction(async (tx) => {
+ // 세부 아이템만 삭제 (아이템 테이블은 유지)
+ await tx.delete(itemShipbuilding)
+ .where(eq(itemShipbuilding.id, input.id));
+ });
+
+ revalidateTag("items");
+
+ return {
+ data: null,
+ error: null,
+ success: true,
+ message: "아이템이 성공적으로 삭제되었습니다."
+ };
+ } catch (err) {
+ return {
+ data: null,
+ error: getErrorMessage(err),
+ success: false,
+ message: "아이템 삭제 중 오류가 발생했습니다."
+ };
+ }
+}
+
+/** 복수 삭제 */
+export async function removeShipbuildingItems(input: DeleteItemsInput) {
+ unstable_noStore();
+ try {
+ await db.transaction(async (tx) => {
+ if (input.ids.length > 0) {
+ // 세부 아이템만 삭제 (아이템 테이블은 유지)
+ await tx.delete(itemShipbuilding)
+ .where(inArray(itemShipbuilding.id, input.ids));
+ }
+ });
+
+ revalidateTag("items");
+
+ return { data: null, error: null, success: true, message: "아이템이 성공적으로 삭제되었습니다." };
+ } catch (err) {
+ return { data: null, error: getErrorMessage(err), success: false, message: "아이템 삭제 중 오류가 발생했습니다." };
+ }
+}
+
+/** Offshore TOP 단건 삭제 */
+export async function removeOffshoreTopItem(input: DeleteItemInput) {
+ unstable_noStore();
+ try {
+ await db.transaction(async (tx) => {
+ // 세부 아이템만 삭제 (아이템 테이블은 유지)
+ await tx.delete(itemOffshoreTop)
+ .where(eq(itemOffshoreTop.id, input.id));
+ });
+
+ revalidateTag("items");
+
+ return {
+ data: null,
+ error: null,
+ success: true,
+ message: "아이템이 성공적으로 삭제되었습니다."
+ };
+ } catch (err) {
+ return {
+ data: null,
+ error: getErrorMessage(err),
+ success: false,
+ message: "아이템 삭제 중 오류가 발생했습니다."
+ };
+ }
+}
+
+/** Offshore TOP 복수 삭제 */
+export async function removeOffshoreTopItems(input: DeleteItemsInput) {
+ unstable_noStore();
+ try {
+ await db.transaction(async (tx) => {
+ if (input.ids.length > 0) {
+ // 세부 아이템만 삭제 (아이템 테이블은 유지)
+ await tx.delete(itemOffshoreTop)
+ .where(inArray(itemOffshoreTop.id, input.ids));
+ }
+ });
+
+ revalidateTag("items");
+
+ return { data: null, error: null, success: true, message: "아이템이 성공적으로 삭제되었습니다." };
+ } catch (err) {
+ return { data: null, error: getErrorMessage(err), success: false, message: "아이템 삭제 중 오류가 발생했습니다." };
+ }
+}
+
+/** Offshore HULL 단건 삭제 */
+export async function removeOffshoreHullItem(input: DeleteItemInput) {
+ unstable_noStore();
+ try {
+ await db.transaction(async (tx) => {
+ // 세부 아이템만 삭제 (아이템 테이블은 유지)
+ await tx.delete(itemOffshoreHull)
+ .where(eq(itemOffshoreHull.id, input.id));
+ });
+
+ revalidateTag("items");
+
+ return {
+ data: null,
+ error: null,
+ success: true,
+ message: "아이템이 성공적으로 삭제되었습니다."
+ };
+ } catch (err) {
+ return {
+ data: null,
+ error: getErrorMessage(err),
+ success: false,
+ message: "아이템 삭제 중 오류가 발생했습니다."
+ };
+ }
+}
+
+/** Offshore HULL 복수 삭제 */
+export async function removeOffshoreHullItems(input: DeleteItemsInput) {
+ unstable_noStore();
+ try {
+ await db.transaction(async (tx) => {
+ if (input.ids.length > 0) {
+ // 세부 아이템만 삭제 (아이템 테이블은 유지)
+ await tx.delete(itemOffshoreHull)
+ .where(inArray(itemOffshoreHull.id, input.ids));
+ }
+ });
+
+ revalidateTag("items");
+
+ return { data: null, error: null, success: true, message: "아이템이 성공적으로 삭제되었습니다." };
+ } catch (err) {
+ return { data: null, error: getErrorMessage(err), success: false, message: "아이템 삭제 중 오류가 발생했습니다." };
+ }
+}
+
+export async function getAllShipbuildingItems(): Promise<Item[]> {
+ try {
+ return await findAllItems();
+ } catch (error) {
+ console.error("Failed to get items:", error);
+ throw new Error("Failed to get items");
+ }
+}
diff --git a/lib/items-tech/table/add-items-dialog.tsx b/lib/items-tech/table/add-items-dialog.tsx new file mode 100644 index 00000000..86333189 --- /dev/null +++ b/lib/items-tech/table/add-items-dialog.tsx @@ -0,0 +1,400 @@ +"use client"
+
+import * as React from "react"
+import { useRouter } from "next/navigation"
+import { zodResolver } from "@hookform/resolvers/zod"
+import { useForm } from "react-hook-form"
+import { Plus } from "lucide-react"
+import * as z from "zod"
+
+import { Button } from "@/components/ui/button"
+import {
+ Dialog,
+ DialogContent,
+ DialogDescription,
+ DialogHeader,
+ DialogTitle,
+ DialogTrigger,
+} from "@/components/ui/dialog"
+import {
+ Form,
+ FormControl,
+ FormField,
+ FormItem,
+ FormLabel,
+ FormMessage,
+} from "@/components/ui/form"
+import { Input } from "@/components/ui/input"
+import {
+ Select,
+ SelectContent,
+ SelectItem,
+ SelectTrigger,
+ SelectValue,
+} from "@/components/ui/select"
+import { Textarea } from "@/components/ui/textarea"
+import { toast } from "sonner"
+
+import { createShipbuildingItem, createOffshoreTopItem, createOffshoreHullItem } from "../service"
+import { ItemType } from "./delete-items-dialog"
+
+// 조선 공종 유형 정의
+const shipbuildingWorkTypes = [
+ { label: "기장", value: "기장" },
+ { label: "전장", value: "전장" },
+ { label: "선실", value: "선실" },
+ { label: "배관", value: "배관" },
+ { label: "철의", value: "철의" },
+] as const
+
+// 선종 유형 정의
+const shipTypes = [
+ { label: "A-MAX", value: "A-MAX" },
+ { label: "S-MAX", value: "S-MAX" },
+ { label: "LNGC", value: "LNGC" },
+ { label: "VLCC", value: "VLCC" },
+ { label: "CONT", value: "CONT" },
+] as const
+
+// 해양 TOP 공종 유형 정의
+const offshoreTopWorkTypes = [
+ { label: "TM", value: "TM" },
+ { label: "TS", value: "TS" },
+ { label: "TE", value: "TE" },
+ { label: "TP", value: "TP" },
+] as const
+
+// 해양 HULL 공종 유형 정의
+const offshoreHullWorkTypes = [
+ { label: "HA", value: "HA" },
+ { label: "HE", value: "HE" },
+ { label: "HH", value: "HH" },
+ { label: "HM", value: "HM" },
+ { label: "NC", value: "NC" },
+] as const
+
+// 기본 아이템 스키마
+const itemFormSchema = z.object({
+ itemCode: z.string().min(1, "아이템 코드는 필수입니다"),
+ itemName: z.string().min(1, "아이템 명은 필수입니다"),
+ description: z.string().optional(),
+ workType: z.string().min(1, "공종은 필수입니다"),
+ // 조선 아이템 전용 필드
+ shipTypes: z.string().optional(),
+ // 해양 아이템 전용 필드
+ itemList1: z.string().optional(),
+ itemList2: z.string().optional(),
+ itemList3: z.string().optional(),
+ itemList4: z.string().optional(),
+})
+
+type ItemFormValues = z.infer<typeof itemFormSchema>
+
+interface AddItemDialogProps {
+ itemType: ItemType
+}
+
+export function AddItemDialog({ itemType }: AddItemDialogProps) {
+ const router = useRouter()
+ const [open, setOpen] = React.useState(false)
+
+ // 기본값 설정
+ const getDefaultValues = () => {
+ const defaults: ItemFormValues = {
+ itemCode: "",
+ itemName: "",
+ description: "",
+ workType: getDefaultWorkType(),
+ }
+
+ if (itemType === 'shipbuilding') {
+ defaults.shipTypes = "A-MAX"
+ } else {
+ defaults.itemList1 = ""
+ defaults.itemList2 = ""
+ defaults.itemList3 = ""
+ defaults.itemList4 = ""
+ }
+
+ return defaults
+ }
+
+ const getDefaultWorkType = () => {
+ switch (itemType) {
+ case 'shipbuilding':
+ return "기장"
+ case 'offshoreTop':
+ return "TM"
+ case 'offshoreHull':
+ return "HA"
+ default:
+ return ""
+ }
+ }
+
+ const form = useForm<ItemFormValues>({
+ resolver: zodResolver(itemFormSchema),
+ defaultValues: getDefaultValues(),
+ })
+
+ const onSubmit = async (data: ItemFormValues) => {
+ try {
+ switch (itemType) {
+ case 'shipbuilding':
+ if (!data.shipTypes) {
+ toast.error("선종은 필수입니다")
+ return
+ }
+
+ await createShipbuildingItem({
+ itemCode: data.itemCode,
+ itemName: data.itemName,
+ workType: data.workType,
+ shipTypes: data.shipTypes,
+ description: data.description || null
+ });
+ break;
+
+ case 'offshoreTop':
+ await createOffshoreTopItem({
+ itemCode: data.itemCode,
+ itemName: data.itemName,
+ workType: data.workType as "TM" | "TS" | "TE" | "TP",
+ description: data.description || null,
+ itemList1: data.itemList1 || null,
+ itemList2: data.itemList2 || null,
+ itemList3: data.itemList3 || null,
+ itemList4: data.itemList4 || null
+ });
+ break;
+
+ case 'offshoreHull':
+ await createOffshoreHullItem({
+ itemCode: data.itemCode,
+ itemName: data.itemName,
+ workType: data.workType as "HA" | "HE" | "HH" | "HM" | "NC",
+ description: data.description || null,
+ itemList1: data.itemList1 || null,
+ itemList2: data.itemList2 || null,
+ itemList3: data.itemList3 || null,
+ itemList4: data.itemList4 || null
+ });
+ break;
+
+ default:
+ toast.error("지원하지 않는 아이템 타입입니다");
+ return;
+ }
+
+ toast.success("아이템이 성공적으로 추가되었습니다")
+ setOpen(false)
+ form.reset(getDefaultValues())
+ router.refresh()
+ } catch (error) {
+ toast.error("아이템 추가 중 오류가 발생했습니다")
+ console.error(error)
+ }
+ }
+
+ const getItemTypeLabel = () => {
+ switch (itemType) {
+ case 'shipbuilding':
+ return '조선 아이템';
+ case 'offshoreTop':
+ return '해양 TOP 아이템';
+ case 'offshoreHull':
+ return '해양 HULL 아이템';
+ default:
+ return '아이템';
+ }
+ }
+
+ const getWorkTypeOptions = () => {
+ switch (itemType) {
+ case 'shipbuilding':
+ return shipbuildingWorkTypes;
+ case 'offshoreTop':
+ return offshoreTopWorkTypes;
+ case 'offshoreHull':
+ return offshoreHullWorkTypes;
+ default:
+ return [];
+ }
+ }
+
+ return (
+ <Dialog open={open} onOpenChange={setOpen}>
+ <DialogTrigger asChild>
+ <Button>
+ <Plus className="mr-2 h-4 w-4" />
+ {getItemTypeLabel()} 추가
+ </Button>
+ </DialogTrigger>
+ <DialogContent>
+ <DialogHeader>
+ <DialogTitle>
+ {getItemTypeLabel()} 추가
+ </DialogTitle>
+ <DialogDescription>
+ 새로운 {getItemTypeLabel()}을 추가합니다.
+ </DialogDescription>
+ </DialogHeader>
+ <Form {...form}>
+ <form onSubmit={form.handleSubmit(onSubmit)} className="space-y-4">
+ <FormField
+ control={form.control}
+ name="itemCode"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>아이템 코드</FormLabel>
+ <FormControl>
+ <Input {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <FormField
+ control={form.control}
+ name="itemName"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>아이템 명</FormLabel>
+ <FormControl>
+ <Input {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <FormField
+ control={form.control}
+ name="workType"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>공종</FormLabel>
+ <Select onValueChange={field.onChange} defaultValue={field.value}>
+ <FormControl>
+ <SelectTrigger>
+ <SelectValue placeholder="공종을 선택하세요" />
+ </SelectTrigger>
+ </FormControl>
+ <SelectContent>
+ {getWorkTypeOptions().map((type) => (
+ <SelectItem key={type.value} value={type.value}>
+ {type.label}
+ </SelectItem>
+ ))}
+ </SelectContent>
+ </Select>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ {itemType === 'shipbuilding' && (
+ <FormField
+ control={form.control}
+ name="shipTypes"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>선종</FormLabel>
+ <Select onValueChange={field.onChange} defaultValue={field.value}>
+ <FormControl>
+ <SelectTrigger>
+ <SelectValue placeholder="선종을 선택하세요" />
+ </SelectTrigger>
+ </FormControl>
+ <SelectContent>
+ {shipTypes.map((type) => (
+ <SelectItem key={type.value} value={type.value}>
+ {type.label}
+ </SelectItem>
+ ))}
+ </SelectContent>
+ </Select>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ )}
+ {(itemType === 'offshoreTop' || itemType === 'offshoreHull') && (
+ <>
+ <FormField
+ control={form.control}
+ name="itemList1"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>아이템 리스트 1</FormLabel>
+ <FormControl>
+ <Input {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <FormField
+ control={form.control}
+ name="itemList2"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>아이템 리스트 2</FormLabel>
+ <FormControl>
+ <Input {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <FormField
+ control={form.control}
+ name="itemList3"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>아이템 리스트 3</FormLabel>
+ <FormControl>
+ <Input {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <FormField
+ control={form.control}
+ name="itemList4"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>아이템 리스트 4</FormLabel>
+ <FormControl>
+ <Input {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ </>
+ )}
+ <FormField
+ control={form.control}
+ name="description"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>설명</FormLabel>
+ <FormControl>
+ <Textarea {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <div className="flex justify-end space-x-2">
+ <Button type="button" variant="outline" onClick={() => setOpen(false)}>
+ 취소
+ </Button>
+ <Button type="submit">추가</Button>
+ </div>
+ </form>
+ </Form>
+ </DialogContent>
+ </Dialog>
+ )
+}
\ No newline at end of file diff --git a/lib/items-tech/table/delete-items-dialog.tsx b/lib/items-tech/table/delete-items-dialog.tsx new file mode 100644 index 00000000..b94a2333 --- /dev/null +++ b/lib/items-tech/table/delete-items-dialog.tsx @@ -0,0 +1,194 @@ +"use client" + +import * as React from "react" +import { type Row } from "@tanstack/react-table" +import { Loader, Trash } from "lucide-react" +import { toast } from "sonner" + +import { useMediaQuery } from "@/hooks/use-media-query" +import { Button } from "@/components/ui/button" +import { + Dialog, + DialogClose, + DialogContent, + DialogDescription, + DialogFooter, + DialogHeader, + DialogTitle, + DialogTrigger, +} from "@/components/ui/dialog" +import { + Drawer, + DrawerClose, + DrawerContent, + DrawerDescription, + DrawerFooter, + DrawerHeader, + DrawerTitle, + DrawerTrigger, +} from "@/components/ui/drawer" + +import { Item } from "@/db/schema/items" +import { + removeShipbuildingItems, + removeOffshoreTopItems, + removeOffshoreHullItems +} from "../service" + +export type ItemType = 'shipbuilding' | 'offshoreTop' | 'offshoreHull'; + +interface DeleteItemsDialogProps + extends React.ComponentPropsWithoutRef<typeof Dialog> { + items: Row<Item>["original"][] + showTrigger?: boolean + onSuccess?: () => void + itemType: ItemType +} + +export function DeleteItemsDialog({ + items, + showTrigger = true, + onSuccess, + itemType, + ...props +}: DeleteItemsDialogProps) { + const [isDeletePending, startDeleteTransition] = React.useTransition() + const isDesktop = useMediaQuery("(min-width: 640px)") + + const getItemTypeLabel = () => { + switch (itemType) { + case 'shipbuilding': + return '조선 아이템'; + case 'offshoreTop': + return '해양 TOP 아이템'; + case 'offshoreHull': + return '해양 HULL 아이템'; + default: + return '아이템'; + } + } + + async function onDelete() { + try { + startDeleteTransition(async () => { + let result; + + switch (itemType) { + case 'shipbuilding': + result = await removeShipbuildingItems({ + ids: items.map((item) => item.id), + }); + break; + case 'offshoreTop': + result = await removeOffshoreTopItems({ + ids: items.map((item) => item.id), + }); + break; + case 'offshoreHull': + result = await removeOffshoreHullItems({ + ids: items.map((item) => item.id), + }); + break; + default: + toast.error("지원하지 않는 아이템 타입입니다"); + return; + } + + if (result.error) { + toast.error(result.error) + return + } + + props.onOpenChange?.(false) + toast.success("아이템 삭제 완료") + onSuccess?.() + }) + } catch (error) { + toast.error("오류가 발생했습니다.") + console.error(error) + } + } + + if (isDesktop) { + return ( + <Dialog {...props}> + {showTrigger ? ( + <DialogTrigger asChild> + <Button variant="outline" size="sm"> + <Trash className="mr-2 size-4" aria-hidden="true" /> + 삭제 ({items.length}) + </Button> + </DialogTrigger> + ) : null} + <DialogContent> + <DialogHeader> + <DialogTitle>정말로 삭제하시겠습니까?</DialogTitle> + <DialogDescription> + 이 작업은 되돌릴 수 없습니다. 선택한{" "} + <span className="font-medium">{items.length}</span> + 개의 {getItemTypeLabel()}이(가) 영구적으로 삭제됩니다. + </DialogDescription> + </DialogHeader> + <DialogFooter className="gap-2 sm:space-x-0"> + <DialogClose asChild> + <Button variant="outline">취소</Button> + </DialogClose> + <Button + aria-label="삭제 확인" + variant="destructive" + onClick={onDelete} + disabled={isDeletePending} + > + {isDeletePending && ( + <Loader + className="mr-2 size-4 animate-spin" + aria-hidden="true" + /> + )} + 삭제 + </Button> + </DialogFooter> + </DialogContent> + </Dialog> + ) + } + + return ( + <Drawer {...props}> + {showTrigger ? ( + <DrawerTrigger asChild> + <Button variant="outline" size="sm"> + <Trash className="mr-2 size-4" aria-hidden="true" /> + 삭제 ({items.length}) + </Button> + </DrawerTrigger> + ) : null} + <DrawerContent> + <DrawerHeader> + <DrawerTitle>정말로 삭제하시겠습니까?</DrawerTitle> + <DrawerDescription> + 이 작업은 되돌릴 수 없습니다. 선택한{" "} + <span className="font-medium">{items.length}</span> + 개의 {getItemTypeLabel()}이(가) 영구적으로 삭제됩니다. + </DrawerDescription> + </DrawerHeader> + <DrawerFooter className="gap-2 sm:space-x-0"> + <DrawerClose asChild> + <Button variant="outline">취소</Button> + </DrawerClose> + <Button + aria-label="삭제 확인" + variant="destructive" + onClick={onDelete} + disabled={isDeletePending} + > + {isDeletePending && ( + <Loader className="mr-2 size-4 animate-spin" aria-hidden="true" /> + )} + 삭제 + </Button> + </DrawerFooter> + </DrawerContent> + </Drawer> + ) +} diff --git a/lib/items-tech/table/feature-flags.tsx b/lib/items-tech/table/feature-flags.tsx new file mode 100644 index 00000000..aaae6af2 --- /dev/null +++ b/lib/items-tech/table/feature-flags.tsx @@ -0,0 +1,96 @@ +"use client" + +import * as React from "react" +import { useQueryState } from "nuqs" + +import { dataTableConfig, type DataTableConfig } from "@/config/data-table" +import { ToggleGroup, ToggleGroupItem } from "@/components/ui/toggle-group" +import { + Tooltip, + TooltipContent, + TooltipTrigger, +} from "@/components/ui/tooltip" + +type FeatureFlagValue = DataTableConfig["featureFlags"][number]["value"] + +interface TasksTableContextProps { + featureFlags: FeatureFlagValue[] + setFeatureFlags: (value: FeatureFlagValue[]) => void +} + +const TasksTableContext = React.createContext<TasksTableContextProps>({ + featureFlags: [], + setFeatureFlags: () => {}, +}) + +export function useTasksTable() { + const context = React.useContext(TasksTableContext) + if (!context) { + throw new Error("useTasksTable must be used within a TasksTableProvider") + } + return context +} + +export function TasksTableProvider({ children }: React.PropsWithChildren) { + const [featureFlags, setFeatureFlags] = useQueryState<FeatureFlagValue[]>( + "featureFlags", + { + defaultValue: [], + parse: (value) => value.split(",") as FeatureFlagValue[], + serialize: (value) => value.join(","), + eq: (a, b) => + a.length === b.length && a.every((value, index) => value === b[index]), + clearOnDefault: true, + } + ) + + return ( + <TasksTableContext.Provider + value={{ + featureFlags, + setFeatureFlags: (value) => void setFeatureFlags(value), + }} + > + <div className="w-full overflow-x-auto"> + <ToggleGroup + type="multiple" + variant="outline" + size="sm" + value={featureFlags} + onValueChange={(value: FeatureFlagValue[]) => setFeatureFlags(value)} + className="w-fit" + > + {dataTableConfig.featureFlags.map((flag) => ( + <Tooltip key={flag.value}> + <ToggleGroupItem + value={flag.value} + className="whitespace-nowrap px-3 text-xs" + asChild + > + <TooltipTrigger> + <flag.icon + className="mr-2 size-3.5 shrink-0" + aria-hidden="true" + /> + {flag.label} + </TooltipTrigger> + </ToggleGroupItem> + <TooltipContent + align="start" + side="bottom" + sideOffset={6} + className="flex max-w-60 flex-col space-y-1.5 border bg-background py-2 font-semibold text-foreground" + > + <div>{flag.tooltipTitle}</div> + <div className="text-xs text-muted-foreground"> + {flag.tooltipDescription} + </div> + </TooltipContent> + </Tooltip> + ))} + </ToggleGroup> + </div> + {children} + </TasksTableContext.Provider> + ) +} diff --git a/lib/items-tech/table/hull/import-item-handler.tsx b/lib/items-tech/table/hull/import-item-handler.tsx new file mode 100644 index 00000000..40070769 --- /dev/null +++ b/lib/items-tech/table/hull/import-item-handler.tsx @@ -0,0 +1,143 @@ +"use client" + +import { z } from "zod" +import { createOffshoreHullItem } from "../../service" + +// 해양 HULL 기능(공종) 유형 enum +const HULL_WORK_TYPES = ["HA", "HE", "HH", "HM", "NC"] as const; + +// 아이템 데이터 검증을 위한 Zod 스키마 +const itemSchema = z.object({ + itemCode: z.string().min(1, "아이템 코드는 필수입니다"), + itemName: z.string().min(1, "아이템 명은 필수입니다"), + workType: z.enum(HULL_WORK_TYPES, { + required_error: "기능(공종)은 필수입니다", + }), + description: z.string().nullable().optional(), + itemList1: z.string().nullable().optional(), + itemList2: z.string().nullable().optional(), + itemList3: z.string().nullable().optional(), + itemList4: z.string().nullable().optional(), +}); + +interface ProcessResult { + successCount: number; + errorCount: number; + errors?: Array<{ row: number; message: string }>; +} + +/** + * Excel 파일에서 가져온 해양 HULL 아이템 데이터 처리하는 함수 + */ +export async function processHullFileImport( + jsonData: any[], + progressCallback?: (current: number, total: number) => void +): Promise<ProcessResult> { + // 결과 카운터 초기화 + let successCount = 0; + let errorCount = 0; + const errors: Array<{ row: number; message: string }> = []; + + // 빈 행 등 필터링 + const dataRows = jsonData.filter(row => { + // 빈 행 건너뛰기 + if (Object.values(row).every(val => !val)) { + return false; + } + return true; + }); + + // 데이터 행이 없으면 빈 결과 반환 + if (dataRows.length === 0) { + return { successCount: 0, errorCount: 0 }; + } + + // 각 행에 대해 처리 + for (let i = 0; i < dataRows.length; i++) { + const row = dataRows[i]; + const rowIndex = i + 1; // 사용자에게 표시할 행 번호는 1부터 시작 + + // 진행 상황 콜백 호출 + if (progressCallback) { + progressCallback(i + 1, dataRows.length); + } + + try { + // 필드 매핑 (한글/영문 필드명 모두 지원) + const itemCode = row["아이템 코드"] || row["itemCode"] || ""; + const itemName = row["아이템 명"] || row["itemName"] || ""; + const workType = row["기능(공종)"] || row["workType"] || ""; + const description = row["설명"] || row["description"] || null; + const itemList1 = row["항목1"] || row["itemList1"] || null; + const itemList2 = row["항목2"] || row["itemList2"] || null; + const itemList3 = row["항목3"] || row["itemList3"] || null; + const itemList4 = row["항목4"] || row["itemList4"] || null; + + // 데이터 정제 + const cleanedRow = { + itemCode: typeof itemCode === 'string' ? itemCode.trim() : String(itemCode).trim(), + itemName: typeof itemName === 'string' ? itemName.trim() : String(itemName).trim(), + workType: typeof workType === 'string' ? workType.trim() : String(workType).trim(), + description: description ? (typeof description === 'string' ? description : String(description)) : null, + itemList1: itemList1 ? (typeof itemList1 === 'string' ? itemList1 : String(itemList1)) : null, + itemList2: itemList2 ? (typeof itemList2 === 'string' ? itemList2 : String(itemList2)) : null, + itemList3: itemList3 ? (typeof itemList3 === 'string' ? itemList3 : String(itemList3)) : null, + itemList4: itemList4 ? (typeof itemList4 === 'string' ? itemList4 : String(itemList4)) : null, + }; + + // 데이터 유효성 검사 + const validationResult = itemSchema.safeParse(cleanedRow); + + if (!validationResult.success) { + const errorMessage = validationResult.error.errors.map( + err => `${err.path.join('.')}: ${err.message}` + ).join(', '); + + errors.push({ row: rowIndex, message: errorMessage }); + errorCount++; + continue; + } + + // 해양 HULL 아이템 생성 + const result = await createOffshoreHullItem({ + itemCode: cleanedRow.itemCode, + itemName: cleanedRow.itemName, + workType: cleanedRow.workType as "HA" | "HE" | "HH" | "HM" | "NC", + description: cleanedRow.description, + itemList1: cleanedRow.itemList1, + itemList2: cleanedRow.itemList2, + itemList3: cleanedRow.itemList3, + itemList4: cleanedRow.itemList4, + }); + + if (result.success) { + successCount++; + } else { + errors.push({ + row: rowIndex, + message: result.message || result.error || "알 수 없는 오류" + }); + errorCount++; + } + } catch (error) { + console.error(`${rowIndex}행 처리 오류:`, error); + errors.push({ + row: rowIndex, + message: error instanceof Error ? error.message : "알 수 없는 오류" + }); + errorCount++; + } + + // 비동기 작업 쓰로틀링 + if (i % 5 === 0) { + await new Promise(resolve => setTimeout(resolve, 10)); + } + } + + // 처리 결과 반환 + return { + successCount, + errorCount, + errors: errors.length > 0 ? errors : undefined + }; +} diff --git a/lib/items-tech/table/hull/item-excel-template.tsx b/lib/items-tech/table/hull/item-excel-template.tsx new file mode 100644 index 00000000..f38bb9dc --- /dev/null +++ b/lib/items-tech/table/hull/item-excel-template.tsx @@ -0,0 +1,125 @@ +import * as ExcelJS from 'exceljs'; +import { saveAs } from "file-saver"; + +// 해양 HULL 기능(공종) 유형 +const HULL_WORK_TYPES = ["HA", "HE", "HH", "HM", "NC"] as const; + +/** + * 해양 HULL 아이템 데이터 가져오기를 위한 Excel 템플릿 파일 생성 및 다운로드 + */ +export async function exportHullItemTemplate() { + // 워크북 생성 + const workbook = new ExcelJS.Workbook(); + workbook.creator = 'Offshore HULL Item Management System'; + workbook.created = new Date(); + + // 워크시트 생성 + const worksheet = workbook.addWorksheet('해양 HULL 아이템'); + + // 컬럼 헤더 정의 및 스타일 적용 + worksheet.columns = [ + { header: '아이템 코드', key: 'itemCode', width: 15 }, + { header: '아이템 명', key: 'itemName', width: 30 }, + { header: '기능(공종)', key: 'workType', width: 15 }, + { header: '설명', key: 'description', width: 50 }, + { header: '항목1', key: 'itemList1', width: 20 }, + { header: '항목2', key: 'itemList2', width: 20 }, + { header: '항목3', key: 'itemList3', width: 20 }, + { header: '항목4', key: 'itemList4', width: 20 }, + ]; + + // 헤더 스타일 적용 + const headerRow = worksheet.getRow(1); + headerRow.font = { bold: true }; + headerRow.fill = { + type: 'pattern', + pattern: 'solid', + fgColor: { argb: 'FFE0E0E0' } + }; + headerRow.alignment = { vertical: 'middle', horizontal: 'center' }; + + // 테두리 스타일 적용 + headerRow.eachCell((cell) => { + cell.border = { + top: { style: 'thin' }, + left: { style: 'thin' }, + bottom: { style: 'thin' }, + right: { style: 'thin' } + }; + }); + + // 샘플 데이터 추가 + const sampleData = [ + { + itemCode: 'HULL001', + itemName: 'HULL 샘플 아이템 1', + workType: 'HA', + description: '이것은 해양 HULL 샘플 아이템 1의 설명입니다.', + itemList1: '항목1 샘플 데이터', + itemList2: '항목2 샘플 데이터', + itemList3: '항목3 샘플 데이터', + itemList4: '항목4 샘플 데이터' + }, + { + itemCode: 'HULL002', + itemName: 'HULL 샘플 아이템 2', + workType: 'HE', + description: '이것은 해양 HULL 샘플 아이템 2의 설명입니다.', + itemList1: '항목1 샘플 데이터', + itemList2: '항목2 샘플 데이터', + itemList3: '', + itemList4: '' + } + ]; + + // 데이터 행 추가 + sampleData.forEach(item => { + worksheet.addRow(item); + }); + + // 데이터 행 스타일 적용 + worksheet.eachRow((row, rowNumber) => { + if (rowNumber > 1) { // 헤더를 제외한 데이터 행 + row.eachCell((cell) => { + cell.border = { + top: { style: 'thin' }, + left: { style: 'thin' }, + bottom: { style: 'thin' }, + right: { style: 'thin' } + }; + }); + } + }); + + // 워크시트에 공종 유형 관련 메모 추가 + const infoRow = worksheet.addRow(['공종 유형 안내: ' + HULL_WORK_TYPES.join(', ')]); + infoRow.font = { bold: true, color: { argb: 'FF0000FF' } }; + worksheet.mergeCells(`A${infoRow.number}:H${infoRow.number}`); + + // 워크시트 보호 (선택적) + worksheet.protect('', { + selectLockedCells: true, + selectUnlockedCells: true, + formatColumns: true, + formatRows: true, + insertColumns: false, + insertRows: true, + insertHyperlinks: false, + deleteColumns: false, + deleteRows: true, + sort: true, + autoFilter: true, + pivotTables: false + }); + + try { + // 워크북을 Blob으로 변환 + const buffer = await workbook.xlsx.writeBuffer(); + const blob = new Blob([buffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' }); + saveAs(blob, 'offshore-hull-item-template.xlsx'); + return true; + } catch (error) { + console.error('Excel 템플릿 생성 오류:', error); + throw error; + } +} diff --git a/lib/items-tech/table/hull/offshore-hull-table-columns.tsx b/lib/items-tech/table/hull/offshore-hull-table-columns.tsx new file mode 100644 index 00000000..f5db40d8 --- /dev/null +++ b/lib/items-tech/table/hull/offshore-hull-table-columns.tsx @@ -0,0 +1,282 @@ +"use client"
+
+import * as React from "react"
+import { type DataTableRowAction } from "@/types/table"
+import { type ColumnDef } from "@tanstack/react-table"
+import { Ellipsis } from "lucide-react"
+
+import { formatDate } from "@/lib/utils"
+import { Button } from "@/components/ui/button"
+import { Checkbox } from "@/components/ui/checkbox"
+import {
+ DropdownMenu,
+ DropdownMenuContent,
+ DropdownMenuItem,
+ DropdownMenuSeparator,
+ DropdownMenuShortcut,
+ DropdownMenuTrigger,
+} from "@/components/ui/dropdown-menu"
+import { DataTableColumnHeaderSimple } from "@/components/data-table/data-table-column-simple-header"
+
+// 테이블 표시에 필요한 데이터 타입 정의
+interface OffshoreHullTableItem {
+ id: number;
+ itemId: number;
+ workType: "HA" | "HE" | "HH" | "HM" | "NC";
+ itemList1: string | null;
+ itemList2: string | null;
+ itemList3: string | null;
+ itemList4: string | null;
+ itemCode: string;
+ itemName: string;
+ description: string | null;
+ createdAt: Date;
+ updatedAt: Date;
+}
+
+interface GetColumnsProps {
+ setRowAction: React.Dispatch<React.SetStateAction<DataTableRowAction<OffshoreHullTableItem> | null>>
+}
+
+export function getOffshoreHullColumns({ setRowAction }: GetColumnsProps): ColumnDef<OffshoreHullTableItem>[] {
+ // ----------------------------------------------------------------
+ // 1) select 컬럼 (체크박스)
+ // ----------------------------------------------------------------
+ const selectColumn: ColumnDef<OffshoreHullTableItem> = {
+ id: "select",
+ header: ({ table }) => (
+ <Checkbox
+ checked={
+ table.getIsAllPageRowsSelected() ||
+ (table.getIsSomePageRowsSelected() && "indeterminate")
+ }
+ onCheckedChange={(value) => table.toggleAllPageRowsSelected(!!value)}
+ aria-label="Select all"
+ className="translate-y-0.5"
+ />
+ ),
+ cell: ({ row }) => (
+ <Checkbox
+ checked={row.getIsSelected()}
+ onCheckedChange={(value) => row.toggleSelected(!!value)}
+ aria-label="Select row"
+ className="translate-y-0.5"
+ />
+ ),
+ size: 40,
+ enableSorting: false,
+ enableHiding: false,
+ }
+
+ // ----------------------------------------------------------------
+ // 2) actions 컬럼 (Dropdown 메뉴)
+ // ----------------------------------------------------------------
+ const actionsColumn: ColumnDef<OffshoreHullTableItem> = {
+ id: "actions",
+ cell: ({ row }) => (
+ <DropdownMenu>
+ <DropdownMenuTrigger asChild>
+ <Button
+ aria-label="Open menu"
+ variant="ghost"
+ className="flex size-8 p-0 data-[state=open]:bg-muted"
+ >
+ <Ellipsis className="size-4" aria-hidden="true" />
+ </Button>
+ </DropdownMenuTrigger>
+ <DropdownMenuContent align="end" className="w-40">
+ <DropdownMenuItem
+ onSelect={() => setRowAction({ row, type: "update" })}
+ >
+ 수정
+ </DropdownMenuItem>
+ <DropdownMenuSeparator />
+ <DropdownMenuItem
+ onSelect={() => setRowAction({ row, type: "delete" })}
+ className="text-destructive"
+ >
+ 삭제
+ <DropdownMenuShortcut>⌘⌫</DropdownMenuShortcut>
+ </DropdownMenuItem>
+ </DropdownMenuContent>
+ </DropdownMenu>
+ ),
+ size: 40,
+ enableSorting: false,
+ enableHiding: false,
+ }
+
+ // ----------------------------------------------------------------
+ // 3) 데이터 컬럼들을 그룹별로 구성
+ // ----------------------------------------------------------------
+
+ // 3-1) 기본 정보 그룹 컬럼
+ const basicInfoColumns: ColumnDef<OffshoreHullTableItem>[] = [
+ {
+ accessorKey: "itemCode",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="Material Group" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemCode}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "Material Group",
+ group: "기본 정보",
+ },
+ },
+ {
+ accessorKey: "itemName",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="Description" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemName}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "Description",
+ group: "기본 정보",
+ },
+ },
+ {
+ accessorKey: "workType",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="기능(공종)" />
+ ),
+ cell: ({ row }) => <div>{row.original.workType}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "기능(공종)",
+ group: "기본 정보",
+ },
+ },
+ {
+ accessorKey: "description",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="Size/Dimension" />
+ ),
+ cell: ({ row }) => <div>{row.original.description || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "Size/Dimension",
+ group: "기본 정보",
+ },
+ },
+ ]
+
+ // 3-2) 아이템 리스트 그룹 컬럼
+ const itemListColumns: ColumnDef<OffshoreHullTableItem>[] = [
+ {
+ accessorKey: "itemList1",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="아이템 리스트 1" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemList1 || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "아이템 리스트 1",
+ group: "아이템 리스트",
+ },
+ },
+ {
+ accessorKey: "itemList2",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="아이템 리스트 2" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemList2 || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "아이템 리스트 2",
+ group: "아이템 리스트",
+ },
+ },
+ {
+ accessorKey: "itemList3",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="아이템 리스트 3" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemList3 || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "아이템 리스트 3",
+ group: "아이템 리스트",
+ },
+ },
+ {
+ accessorKey: "itemList4",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="아이템 리스트 4" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemList4 || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "아이템 리스트 4",
+ group: "아이템 리스트",
+ },
+ },
+ ]
+
+ // 3-3) 메타데이터 그룹 컬럼
+ const metadataColumns: ColumnDef<OffshoreHullTableItem>[] = [
+ {
+ accessorKey: "createdAt",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="생성일" />
+ ),
+ cell: ({ row }) => formatDate(row.original.createdAt),
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "생성일",
+ group: "Metadata",
+ },
+ },
+ {
+ accessorKey: "updatedAt",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="수정일" />
+ ),
+ cell: ({ row }) => formatDate(row.original.updatedAt),
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "수정일",
+ group: "Metadata",
+ },
+ }
+ ]
+
+ // 3-4) 그룹별 컬럼 구성
+ const groupedColumns: ColumnDef<OffshoreHullTableItem>[] = [
+ {
+ id: "기본 정보",
+ header: "기본 정보",
+ columns: basicInfoColumns,
+ },
+ {
+ id: "아이템 리스트",
+ header: "아이템 리스트",
+ columns: itemListColumns,
+ },
+ {
+ id: "Metadata",
+ header: "Metadata",
+ columns: metadataColumns,
+ }
+ ]
+
+ // ----------------------------------------------------------------
+ // 4) 최종 컬럼 배열: select, groupedColumns, actions
+ // ----------------------------------------------------------------
+ return [
+ selectColumn,
+ ...groupedColumns,
+ actionsColumn,
+ ]
+}
\ No newline at end of file diff --git a/lib/items-tech/table/hull/offshore-hull-table-toolbar-actions.tsx b/lib/items-tech/table/hull/offshore-hull-table-toolbar-actions.tsx new file mode 100644 index 00000000..f5324cb1 --- /dev/null +++ b/lib/items-tech/table/hull/offshore-hull-table-toolbar-actions.tsx @@ -0,0 +1,184 @@ +"use client"
+
+import * as React from "react"
+import { type Table } from "@tanstack/react-table"
+import { Download, FileDown } from "lucide-react"
+import * as ExcelJS from 'exceljs'
+import { saveAs } from "file-saver"
+
+import { Button } from "@/components/ui/button"
+import {
+ DropdownMenu,
+ DropdownMenuContent,
+ DropdownMenuItem,
+ DropdownMenuTrigger,
+} from "@/components/ui/dropdown-menu"
+
+import { DeleteItemsDialog } from "../delete-items-dialog"
+import { AddItemDialog } from "../add-items-dialog"
+import { exportHullItemTemplate } from "./item-excel-template"
+import { ImportItemButton } from "../import-excel-button"
+
+// 해양 HULL 아이템 타입 정의
+interface OffshoreHullItem {
+ id: number;
+ itemId: number;
+ workType: "HA" | "HE" | "HH" | "HM" | "NC";
+ itemList1: string | null;
+ itemList2: string | null;
+ itemList3: string | null;
+ itemList4: string | null;
+ itemCode: string;
+ itemName: string;
+ description: string | null;
+ createdAt: Date;
+ updatedAt: Date;
+}
+
+interface OffshoreHullTableToolbarActionsProps {
+ table: Table<OffshoreHullItem>
+}
+
+export function OffshoreHullTableToolbarActions({ table }: OffshoreHullTableToolbarActionsProps) {
+ const [refreshKey, setRefreshKey] = React.useState(0)
+
+ // 가져오기 성공 후 테이블 갱신
+ const handleImportSuccess = () => {
+ setRefreshKey(prev => prev + 1)
+ }
+
+ // Excel 내보내기 함수
+ const exportTableToExcel = async (
+ table: Table<OffshoreHullItem>,
+ options: {
+ filename: string;
+ excludeColumns?: string[];
+ sheetName?: string;
+ }
+ ) => {
+ const { filename, excludeColumns = [], sheetName = "해양 HULL 아이템 목록" } = options;
+
+ // 워크북 생성
+ const workbook = new ExcelJS.Workbook();
+ workbook.creator = 'Offshore Item Management System';
+ workbook.created = new Date();
+
+ // 워크시트 생성
+ const worksheet = workbook.addWorksheet(sheetName);
+
+ // 테이블 데이터 가져오기
+ const data = table.getFilteredRowModel().rows.map(row => row.original);
+ console.log("내보내기 데이터:", data);
+
+ // 필요한 헤더 직접 정의 (필터링 문제 해결)
+ const headers = [
+ { key: 'itemCode', header: '아이템 코드' },
+ { key: 'itemName', header: '아이템 명' },
+ { key: 'description', header: '설명' },
+ { key: 'workType', header: '기능(공종)' },
+ { key: 'itemList1', header: '아이템 리스트 1' },
+ { key: 'itemList2', header: '아이템 리스트 2' },
+ { key: 'itemList3', header: '아이템 리스트 3' },
+ { key: 'itemList4', header: '아이템 리스트 4' }
+ ].filter(header => !excludeColumns.includes(header.key));
+
+ console.log("내보내기 헤더:", headers);
+ // 컬럼 정의
+ worksheet.columns = headers.map(header => ({
+ header: header.header,
+ key: header.key,
+ width: 20 // 기본 너비
+ }));
+
+ // 스타일 적용
+ const headerRow = worksheet.getRow(1);
+ headerRow.font = { bold: true };
+ headerRow.fill = {
+ type: 'pattern',
+ pattern: 'solid',
+ fgColor: { argb: 'FFE0E0E0' }
+ };
+ headerRow.alignment = { vertical: 'middle', horizontal: 'center' };
+
+ // 데이터 행 추가
+ data.forEach(item => {
+ const row: Record<string, any> = {};
+ headers.forEach(header => {
+ row[header.key] = item[header.key as keyof OffshoreHullItem];
+ });
+ worksheet.addRow(row);
+ });
+
+ // 전체 셀에 테두리 추가
+ worksheet.eachRow((row) => {
+ row.eachCell((cell) => {
+ cell.border = {
+ top: { style: 'thin' },
+ left: { style: 'thin' },
+ bottom: { style: 'thin' },
+ right: { style: 'thin' }
+ };
+ });
+ });
+
+ try {
+ // 워크북을 Blob으로 변환
+ const buffer = await workbook.xlsx.writeBuffer();
+ const blob = new Blob([buffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
+ saveAs(blob, `${filename}.xlsx`);
+ return true;
+ } catch (error) {
+ console.error("Excel 내보내기 오류:", error);
+ return false;
+ }
+ }
+
+ return (
+ <div className="flex items-center gap-2">
+ {/* 선택된 로우가 있으면 삭제 다이얼로그 */}
+ {table.getFilteredSelectedRowModel().rows.length > 0 ? (
+ <DeleteItemsDialog
+ items={table
+ .getFilteredSelectedRowModel()
+ .rows.map((row) => row.original)}
+ onSuccess={() => table.toggleAllRowsSelected(false)}
+ itemType="offshoreHull"
+ />
+ ) : null}
+
+ {/* 새 아이템 추가 다이얼로그 */}
+ <AddItemDialog itemType="offshoreHull" />
+
+ {/* Import 버튼 */}
+ <ImportItemButton itemType="hull" onSuccess={handleImportSuccess} />
+
+ {/* Export 드롭다운 메뉴 */}
+ <DropdownMenu>
+ <DropdownMenuTrigger asChild>
+ <Button variant="outline" size="sm" className="gap-2">
+ <Download className="size-4" aria-hidden="true" />
+ <span className="hidden sm:inline">Export</span>
+ </Button>
+ </DropdownMenuTrigger>
+ <DropdownMenuContent align="end">
+ <DropdownMenuItem
+ onClick={() =>
+ exportTableToExcel(table, {
+ filename: "offshore_hull_items",
+ excludeColumns: ["select", "actions"],
+ sheetName: "해양 HULL 아이템 목록"
+ })
+ }
+ >
+ <FileDown className="mr-2 h-4 w-4" />
+ <span>현재 데이터 내보내기</span>
+ </DropdownMenuItem>
+ <DropdownMenuItem onClick={() => exportHullItemTemplate()}>
+ <FileDown className="mr-2 h-4 w-4" />
+ <span>템플릿 다운로드</span>
+ </DropdownMenuItem>
+ </DropdownMenuContent>
+ </DropdownMenu>
+ </div>
+ )
+}
\ No newline at end of file diff --git a/lib/items-tech/table/hull/offshore-hull-table.tsx b/lib/items-tech/table/hull/offshore-hull-table.tsx new file mode 100644 index 00000000..8efa9c81 --- /dev/null +++ b/lib/items-tech/table/hull/offshore-hull-table.tsx @@ -0,0 +1,152 @@ +"use client"
+
+import * as React from "react"
+import type {
+ DataTableFilterField,
+ DataTableAdvancedFilterField,
+ DataTableRowAction,
+} from "@/types/table"
+
+import { useDataTable } from "@/hooks/use-data-table"
+import { DataTable } from "@/components/data-table/data-table"
+import { DataTableAdvancedToolbar } from "@/components/data-table/data-table-advanced-toolbar"
+import { getOffshoreHullItems } from "../../service"
+import { getOffshoreHullColumns } from "./offshore-hull-table-columns"
+import { OffshoreHullTableToolbarActions } from "./offshore-hull-table-toolbar-actions"
+import { DeleteItemsDialog } from "../delete-items-dialog"
+import { UpdateItemSheet } from "../update-items-sheet"
+
+// 서비스에서 반환하는 데이터 타입 정의
+type OffshoreHullItem = {
+ id: number;
+ itemId: number;
+ workType: "HA" | "HE" | "HH" | "HM" | "NC";
+ itemList1: string | null;
+ itemList2: string | null;
+ itemList3: string | null;
+ itemList4: string | null;
+ itemCode: string;
+ itemName: string;
+ description: string | null;
+ createdAt: Date;
+ updatedAt: Date;
+}
+
+interface OffshoreHullTableProps {
+ promises: Promise<Awaited<ReturnType<typeof getOffshoreHullItems>>>
+}
+
+export function OffshoreHullTable({ promises }: OffshoreHullTableProps) {
+ const { data, pageCount } = React.use(promises)
+
+ // 아이템 타입에 따른 행 액션 상태 관리
+ const [rowAction, setRowAction] = React.useState<DataTableRowAction<OffshoreHullItem> | null>(null)
+ const columns = getOffshoreHullColumns({ setRowAction })
+ const filterFields: DataTableFilterField<OffshoreHullItem>[] = [
+ {
+ id: "itemCode",
+ label: "Item Code",
+ },
+ {
+ id: "itemName",
+ label: "Item Name",
+ },
+ {
+ id: "workType",
+ label: "기능(공종)",
+ },
+ {
+ id: "itemList1",
+ label: "아이템 리스트 1",
+ },
+ ]
+
+ const advancedFilterFields: DataTableAdvancedFilterField<OffshoreHullItem>[] = [
+ {
+ id: "itemCode",
+ label: "Item Code",
+ type: "text",
+ },
+ {
+ id: "itemName",
+ label: "Item Name",
+ type: "text",
+ },
+ {
+ id: "description",
+ label: "Description",
+ type: "text",
+ },
+ {
+ id: "workType",
+ label: "기능(공종)",
+ type: "text",
+ },
+ {
+ id: "itemList1",
+ label: "아이템 리스트 1",
+ type: "text",
+ },
+ {
+ id: "itemList2",
+ label: "아이템 리스트 2",
+ type: "text",
+ },
+ {
+ id: "itemList3",
+ label: "아이템 리스트 3",
+ type: "text",
+ },
+ {
+ id: "itemList4",
+ label: "아이템 리스트 4",
+ type: "text",
+ },
+ ]
+
+ const { table } = useDataTable({
+ data: data as OffshoreHullItem[],
+ columns,
+ pageCount,
+ filterFields,
+ enablePinning: true,
+ enableAdvancedFilter: true,
+ initialState: {
+ sorting: [{ id: "createdAt", desc: true }],
+ columnPinning: { right: ["actions"] },
+ },
+ getRowId: (originalRow) => String(originalRow.id),
+ shallow: false,
+ clearOnDefault: true,
+ })
+
+ return (
+ <>
+ <DataTable table={table}>
+ <DataTableAdvancedToolbar
+ table={table}
+ filterFields={advancedFilterFields}
+ shallow={false}
+ >
+ <OffshoreHullTableToolbarActions table={table} />
+ </DataTableAdvancedToolbar>
+ </DataTable>
+ <DeleteItemsDialog
+ open={rowAction?.type === "delete"}
+ onOpenChange={() => setRowAction(null)}
+ items={rowAction?.row.original ? [rowAction?.row.original] : []}
+ showTrigger={false}
+ onSuccess={() => rowAction?.row.toggleSelected(false)}
+ itemType="offshoreHull"
+ />
+ {rowAction?.type === "update" && rowAction.row.original && (
+ <UpdateItemSheet
+ item={rowAction.row.original}
+ itemType="offshoreHull"
+ open={true}
+ onOpenChange={() => setRowAction(null)}
+ />
+ )}
+ </>
+ )
+}
\ No newline at end of file diff --git a/lib/items-tech/table/import-excel-button.tsx b/lib/items-tech/table/import-excel-button.tsx new file mode 100644 index 00000000..8c4a9e16 --- /dev/null +++ b/lib/items-tech/table/import-excel-button.tsx @@ -0,0 +1,298 @@ +"use client" + +import * as React from "react" +import { Upload } from "lucide-react" +import { toast } from "sonner" +import * as ExcelJS from 'exceljs' + +import { Button } from "@/components/ui/button" +import { + Dialog, + DialogContent, + DialogDescription, + DialogFooter, + DialogHeader, + DialogTitle, + DialogTrigger, +} from "@/components/ui/dialog" +import { Progress } from "@/components/ui/progress" +import { processFileImport } from "./ship/import-item-handler" +import { processTopFileImport } from "./top/import-item-handler" +import { processHullFileImport } from "./hull/import-item-handler" + + +// 선박 아이템 타입 +type ItemType = "ship" | "top" | "hull"; + +const ITEM_TYPE_NAMES = { + ship: "조선 아이템", + top: "해양 TOP 아이템", + hull: "해양 HULL 아이템", +}; + +interface ImportItemButtonProps { + itemType: ItemType; + onSuccess?: () => void; +} + +export function ImportItemButton({ itemType, onSuccess }: ImportItemButtonProps) { + const [open, setOpen] = React.useState(false); + const [file, setFile] = React.useState<File | null>(null); + const [isUploading, setIsUploading] = React.useState(false); + const [progress, setProgress] = React.useState(0); + const [error, setError] = React.useState<string | null>(null); + + const fileInputRef = React.useRef<HTMLInputElement>(null); + + // 파일 선택 처리 + const handleFileChange = (e: React.ChangeEvent<HTMLInputElement>) => { + const selectedFile = e.target.files?.[0]; + if (!selectedFile) return; + + if (!selectedFile.name.endsWith('.xlsx') && !selectedFile.name.endsWith('.xls')) { + setError("Excel 파일(.xlsx 또는 .xls)만 가능합니다."); + return; + } + + setFile(selectedFile); + setError(null); + }; + + + // 데이터 가져오기 처리 + const handleImport = async () => { + if (!file) { + setError("가져올 파일을 선택해주세요."); + return; + } + + try { + setIsUploading(true); + setProgress(0); + setError(null); + + // 파일을 ArrayBuffer로 읽기 + const arrayBuffer = await file.arrayBuffer(); + + // ExcelJS 워크북 로드 + const workbook = new ExcelJS.Workbook(); + await workbook.xlsx.load(arrayBuffer); + + // 첫 번째 워크시트 가져오기 + const worksheet = workbook.worksheets[0]; + if (!worksheet) { + throw new Error("Excel 파일에 워크시트가 없습니다."); + } + + // 헤더 행 찾기 + let headerRowIndex = 1; + let headerRow: ExcelJS.Row | undefined; + let headerValues: (string | null)[] = []; + + worksheet.eachRow((row, rowNumber) => { + const values = row.values as (string | null)[]; + if (!headerRow && values.some(v => v === "아이템 코드" || v === "itemCode" || v === "item_code")) { + headerRowIndex = rowNumber; + headerRow = row; + headerValues = [...values]; + } + }); + + if (!headerRow) { + throw new Error("Excel 파일에서 헤더 행을 찾을 수 없습니다."); + } + + // 헤더를 기반으로 인덱스 매핑 생성 + const headerMapping: Record<string, number> = {}; + headerValues.forEach((value, index) => { + if (typeof value === 'string') { + headerMapping[value] = index; + } + }); + + // 필수 헤더 확인 (타입별 구분) + let requiredHeaders: string[] = ["아이템 코드", "아이템 명", "기능(공종)"]; + + // 해양 TOP 및 HULL의 경우 선종 헤더는 필요 없음 + if (itemType === "ship") { + requiredHeaders = [...requiredHeaders, "A-MAX", "S-MAX", "LNGC", "VLCC", "CONT"]; + } + + const alternativeHeaders = { + "아이템 코드": ["itemCode", "item_code"], + "아이템 명": ["itemName", "item_name"], + "기능(공종)": ["workType"], + "설명": ["description"], + "항목1": ["itemList1"], + "항목2": ["itemList2"], + "항목3": ["itemList3"], + "항목4": ["itemList4"] + }; + + // 헤더 매핑 확인 (대체 이름 포함) + const missingHeaders = requiredHeaders.filter(header => { + const alternatives = alternativeHeaders[header as keyof typeof alternativeHeaders] || []; + return !(header in headerMapping) && + !alternatives.some(alt => alt in headerMapping); + }); + + if (missingHeaders.length > 0) { + throw new Error(`다음 필수 헤더가 누락되었습니다: ${missingHeaders.join(", ")}`); + } + + // 데이터 행 추출 (헤더 이후 행부터) + const dataRows: Record<string, any>[] = []; + + worksheet.eachRow((row, rowNumber) => { + if (rowNumber > headerRowIndex) { + const rowData: Record<string, any> = {}; + const values = row.values as (string | null | undefined)[]; + + // 헤더 매핑에 따라 데이터 추출 + Object.entries(headerMapping).forEach(([header, index]) => { + rowData[header] = values[index] || ""; + }); + + // 빈 행이 아닌 경우만 추가 + if (Object.values(rowData).some(value => value && value.toString().trim() !== "")) { + dataRows.push(rowData); + } + } + }); + + if (dataRows.length === 0) { + throw new Error("Excel 파일에 가져올 데이터가 없습니다."); + } + + // 진행 상황 업데이트를 위한 콜백 + const updateProgress = (current: number, total: number) => { + const percentage = Math.round((current / total) * 100); + setProgress(percentage); + }; + + // 선택된 타입에 따라 적절한 프로세스 함수 호출 + let result; + if (itemType === "top") { + result = await processTopFileImport(dataRows, updateProgress); + } else if (itemType === "hull") { + result = await processHullFileImport(dataRows, updateProgress); + } else { + result = await processFileImport(dataRows, updateProgress); + } + + toast.success(`${result.successCount}개의 ${ITEM_TYPE_NAMES[itemType]}이(가) 성공적으로 가져와졌습니다.`); + + if (result.errorCount > 0) { + toast.warning(`${result.errorCount}개의 항목은 처리할 수 없었습니다.`); + } + + // 상태 초기화 및 다이얼로그 닫기 + setFile(null); + setOpen(false); + + // 성공 콜백 호출 + if (onSuccess) { + onSuccess(); + } + } catch (error) { + console.error("Excel 파일 처리 중 오류 발생:", error); + setError(error instanceof Error ? error.message : "파일 처리 중 오류가 발생했습니다."); + } finally { + setIsUploading(false); + } + }; + + + + // 다이얼로그 열기/닫기 핸들러 + const handleOpenChange = (newOpen: boolean) => { + if (!newOpen) { + // 닫을 때 상태 초기화 + setFile(null); + setError(null); + setProgress(0); + if (fileInputRef.current) { + fileInputRef.current.value = ""; + } + } + setOpen(newOpen); + }; + + return ( + <> + <Button + variant="outline" + size="sm" + className="gap-2" + onClick={() => setOpen(true)} + disabled={isUploading} + > + <Upload className="size-4" aria-hidden="true" /> + <span className="hidden sm:inline">Import</span> + </Button> + + <Dialog open={open} onOpenChange={handleOpenChange}> + <DialogContent className="sm:max-w-[500px]"> + <DialogHeader> + <DialogTitle>{ITEM_TYPE_NAMES[itemType]} 가져오기</DialogTitle> + <DialogDescription> + {ITEM_TYPE_NAMES[itemType]}을 Excel 파일에서 가져옵니다. + <br /> + 올바른 형식의 Excel 파일(.xlsx)을 업로드하세요. + </DialogDescription> + </DialogHeader> + + <div className="space-y-4 py-4"> + <div className="flex items-center gap-4"> + <input + type="file" + ref={fileInputRef} + className="flex h-10 w-full rounded-md border border-input bg-background px-3 py-2 text-sm file:border-0 file:bg-transparent file:text-foreground file:font-medium" + accept=".xlsx,.xls" + onChange={handleFileChange} + disabled={isUploading} + /> + </div> + + {file && ( + <div className="text-sm text-muted-foreground"> + 선택된 파일: <span className="font-medium">{file.name}</span> ({(file.size / 1024).toFixed(1)} KB) + </div> + )} + + {isUploading && ( + <div className="space-y-2"> + <Progress value={progress} /> + <p className="text-sm text-muted-foreground text-center"> + {progress}% 완료 + </p> + </div> + )} + + {error && ( + <div className="text-sm font-medium text-destructive"> + {error} + </div> + )} + </div> + + <DialogFooter> + <Button + variant="outline" + onClick={() => setOpen(false)} + disabled={isUploading} + > + 취소 + </Button> + <Button + onClick={handleImport} + disabled={!file || isUploading} + > + {isUploading ? "처리 중..." : "가져오기"} + </Button> + </DialogFooter> + </DialogContent> + </Dialog> + </> + ); +}
\ No newline at end of file diff --git a/lib/items-tech/table/ship/Items-ship-table.tsx b/lib/items-tech/table/ship/Items-ship-table.tsx new file mode 100644 index 00000000..aee90cfc --- /dev/null +++ b/lib/items-tech/table/ship/Items-ship-table.tsx @@ -0,0 +1,146 @@ +"use client"
+
+import * as React from "react"
+import type {
+ DataTableFilterField,
+ DataTableAdvancedFilterField,
+ DataTableRowAction,
+} from "@/types/table"
+
+import { useDataTable } from "@/hooks/use-data-table"
+import { DataTable } from "@/components/data-table/data-table"
+import { DataTableAdvancedToolbar } from "@/components/data-table/data-table-advanced-toolbar"
+import { getShipbuildingItems } from "../../service"
+import { getShipbuildingColumns } from "./items-ship-table-columns"
+import { ItemsTableToolbarActions } from "./items-table-toolbar-actions"
+import { DeleteItemsDialog } from "../delete-items-dialog"
+import { UpdateItemSheet } from "../update-items-sheet"
+
+// 서비스에서 반환하는 데이터 타입 정의
+type ShipbuildingItem = {
+ id: number;
+ itemId: number;
+ workType: "기장" | "전장" | "선실" | "배관" | "철의";
+ shipTypes: string;
+ itemCode: string;
+ itemName: string;
+ description: string | null;
+ createdAt: Date;
+ updatedAt: Date;
+}
+
+interface ItemsTableProps {
+ promises: Promise<Awaited<ReturnType<typeof getShipbuildingItems>>>
+}
+
+export function ItemsShipTable({ promises }: ItemsTableProps) {
+ const { data, pageCount } = React.use(promises)
+
+ // 아이템 타입에 따른 행 액션 상태 관리
+ const [rowAction, setRowAction] = React.useState<DataTableRowAction<ShipbuildingItem> | null>(null)
+ const columns = getShipbuildingColumns({ setRowAction })
+ const filterFields: DataTableFilterField<ShipbuildingItem>[] = [
+ {
+ id: "itemCode",
+ label: "Item Code",
+ },
+ {
+ id: "itemName",
+ label: "Item Name",
+ },
+ {
+ id: "workType",
+ label: "기능(공종)",
+ },
+ {
+ id: "shipTypes",
+ label: "선종",
+ },
+ ]
+
+ /**
+ * Advanced filter fields for the data table.
+ * These fields provide more complex filtering options compared to the regular filterFields.
+ *
+ * Key differences from regular filterFields:
+ * 1. More field types: Includes 'text', 'multi-select', 'date', and 'boolean'.
+ * 2. Enhanced flexibility: Allows for more precise and varied filtering options.
+ * 3. Used with DataTableAdvancedToolbar: Enables a more sophisticated filtering UI.
+ * 4. Date and boolean types: Adds support for filtering by date ranges and boolean values.
+ */
+
+ const advancedFilterFields: DataTableAdvancedFilterField<ShipbuildingItem>[] = [
+ {
+ id: "itemCode",
+ label: "Item Code",
+ type: "text",
+ },
+ {
+ id: "itemName",
+ label: "Item Name",
+ type: "text",
+ },
+ {
+ id: "description",
+ label: "Description",
+ type: "text",
+ },
+ {
+ id: "workType",
+ label: "기능(공종)",
+ type: "text",
+ },
+ {
+ id: "shipTypes",
+ label: "선종",
+ type: "text",
+ },
+ ]
+
+ const { table } = useDataTable({
+ data: data as ShipbuildingItem[],
+ columns,
+ pageCount,
+ filterFields,
+ enablePinning: true,
+ enableAdvancedFilter: true,
+ initialState: {
+ sorting: [{ id: "createdAt", desc: true }],
+ columnPinning: { right: ["actions"] },
+ },
+ getRowId: (originalRow) => String(originalRow.id),
+ shallow: false,
+ clearOnDefault: true,
+ })
+
+ return (
+ <>
+ <DataTable table={table}>
+ <DataTableAdvancedToolbar
+ table={table}
+ filterFields={advancedFilterFields}
+ shallow={false}
+ >
+ <ItemsTableToolbarActions table={table} />
+ </DataTableAdvancedToolbar>
+ </DataTable>
+ <DeleteItemsDialog
+ open={rowAction?.type === "delete"}
+ onOpenChange={() => setRowAction(null)}
+ items={rowAction?.row.original ? [rowAction?.row.original] : []}
+ showTrigger={false}
+ onSuccess={() => rowAction?.row.toggleSelected(false)}
+ itemType="shipbuilding"
+ />
+
+ {rowAction?.type === "update" && rowAction.row.original && (
+ <UpdateItemSheet
+ item={rowAction.row.original}
+ itemType="shipbuilding"
+ open={true}
+ onOpenChange={() => setRowAction(null)}
+ />
+ )}
+ </>
+ )
+}
diff --git a/lib/items-tech/table/ship/import-item-handler.tsx b/lib/items-tech/table/ship/import-item-handler.tsx new file mode 100644 index 00000000..6ad24398 --- /dev/null +++ b/lib/items-tech/table/ship/import-item-handler.tsx @@ -0,0 +1,145 @@ +"use client" + +import { z } from "zod" +import { createShipbuildingImportItem } from "../../service" // 아이템 생성 서버 액션 + +const SHIP_TYPES = ['A-MAX', 'S-MAX', 'LNGC', 'VLCC', 'CONT'] as const; + +// 아이템 데이터 검증을 위한 Zod 스키마 +const itemSchema = z.object({ + itemCode: z.string().min(1, "아이템 코드는 필수입니다"), + itemName: z.string().min(1, "아이템 명은 필수입니다"), + workType: z.enum(["기장", "전장", "선실", "배관", "철의"], { + required_error: "기능(공종)은 필수입니다", + }), + description: z.string().nullable().optional(), +}); + +interface ProcessResult { + successCount: number; + errorCount: number; + errors?: Array<{ row: number; message: string }>; +} + +/** + * Excel 파일에서 가져온 조선 아이템 데이터 처리하는 함수 + */ +export async function processFileImport( + jsonData: any[], + progressCallback?: (current: number, total: number) => void +): Promise<ProcessResult> { + // 결과 카운터 초기화 + let successCount = 0; + let errorCount = 0; + const errors: Array<{ row: number; message: string }> = []; + + // 빈 행 등 필터링 + const dataRows = jsonData.filter(row => { + // 빈 행 건너뛰기 + if (Object.values(row).every(val => !val)) { + return false; + } + return true; + }); + + // 데이터 행이 없으면 빈 결과 반환 + if (dataRows.length === 0) { + return { successCount: 0, errorCount: 0 }; + } + + // 각 행에 대해 처리 + for (let i = 0; i < dataRows.length; i++) { + const row = dataRows[i]; + const rowIndex = i + 1; // 사용자에게 표시할 행 번호는 1부터 시작 + + // 진행 상황 콜백 호출 + if (progressCallback) { + progressCallback(i + 1, dataRows.length); + } + + try { + // 필드 매핑 (한글/영문 필드명 모두 지원) + const itemCode = row["아이템 코드"] || row["itemCode"] || ""; + const itemName = row["아이템 명"] || row["itemName"] || ""; + const workType = row["기능(공종)"] || row["workType"] || ""; + const description = row["설명"] || row["description"] || null; + + // 데이터 정제 + const cleanedRow = { + itemCode: typeof itemCode === 'string' ? itemCode.trim() : String(itemCode).trim(), + itemName: typeof itemName === 'string' ? itemName.trim() : String(itemName).trim(), + workType: typeof workType === 'string' ? workType.trim() : String(workType).trim(), + description: description ? (typeof description === 'string' ? description : String(description)) : null, + }; + + // 데이터 유효성 검사 + const validationResult = itemSchema.safeParse(cleanedRow); + + if (!validationResult.success) { + const errorMessage = validationResult.error.errors.map( + err => `${err.path.join('.')}: ${err.message}` + ).join(', '); + + errors.push({ row: rowIndex, message: errorMessage }); + errorCount++; + continue; + } + + // 선종 데이터 처리 + const shipTypeEntries = SHIP_TYPES.map(type => ({ + type, + value: row[type]?.toUpperCase() === 'O' + })).filter(entry => entry.value); + console.log('shipTypeEntries:', shipTypeEntries); + + if (shipTypeEntries.length === 0) { + errors.push({ + row: rowIndex, + message: "최소 하나 이상의 선종이 'O'로 지정되어야 합니다." + }); + errorCount++; + continue; + } + + // 각 선종에 대해 아이템 생성 + for (const { type } of shipTypeEntries) { + const result = await createShipbuildingImportItem({ + itemCode: cleanedRow.itemCode, + itemName: cleanedRow.itemName, + workType: cleanedRow.workType as "기장" | "전장" | "선실" | "배관" | "철의", + shipTypes: { [type]: true }, + description: cleanedRow.description, + }); + + if (result.success || !result.error) { + successCount++; + } else { + errors.push({ + row: rowIndex, + message: `${type}: ${result.message || result.error || "알 수 없는 오류"}` + }); + errorCount++; + } + } + } catch (error) { + console.error(`${rowIndex}행 처리 오류:`, error); + errors.push({ + row: rowIndex, + message: error instanceof Error ? error.message : "알 수 없는 오류" + }); + errorCount++; + } + + // 비동기 작업 쓰로틀링 + if (i % 5 === 0) { + await new Promise(resolve => setTimeout(resolve, 10)); + } + } + + // 처리 결과 반환 + return { + successCount, + errorCount, + errors: errors.length > 0 ? errors : undefined + }; +}
\ No newline at end of file diff --git a/lib/items-tech/table/ship/item-excel-template.tsx b/lib/items-tech/table/ship/item-excel-template.tsx new file mode 100644 index 00000000..127a1dea --- /dev/null +++ b/lib/items-tech/table/ship/item-excel-template.tsx @@ -0,0 +1,122 @@ +import * as ExcelJS from 'exceljs'; +import { saveAs } from "file-saver"; + +const SHIP_TYPES = ['A-MAX', 'S-MAX', 'LNGC', 'VLCC', 'CONT'] as const; + +/** + * 조선 아이템 데이터 가져오기를 위한 Excel 템플릿 파일 생성 및 다운로드 + */ +export async function exportItemTemplate() { + // 워크북 생성 + const workbook = new ExcelJS.Workbook(); + workbook.creator = 'Shipbuilding Item Management System'; + workbook.created = new Date(); + + // 워크시트 생성 + const worksheet = workbook.addWorksheet('조선 아이템'); + + // 컬럼 헤더 정의 및 스타일 적용 + worksheet.columns = [ + { header: '아이템 코드', key: 'itemCode', width: 15 }, + { header: '아이템 명', key: 'itemName', width: 30 }, + { header: '기능(공종)', key: 'workType', width: 15 }, + { header: '설명', key: 'description', width: 50 }, + ...SHIP_TYPES.map(type => ({ + header: type, + key: type, + width: 10 + })) + ]; + + // 헤더 스타일 적용 + const headerRow = worksheet.getRow(1); + headerRow.font = { bold: true }; + headerRow.fill = { + type: 'pattern', + pattern: 'solid', + fgColor: { argb: 'FFE0E0E0' } + }; + headerRow.alignment = { vertical: 'middle', horizontal: 'center' }; + + // 테두리 스타일 적용 + headerRow.eachCell((cell) => { + cell.border = { + top: { style: 'thin' }, + left: { style: 'thin' }, + bottom: { style: 'thin' }, + right: { style: 'thin' } + }; + }); + + // 샘플 데이터 추가 + const sampleData = [ + { + itemCode: 'BG0001', + itemName: '샘플 아이템 1', + workType: '기장', + description: '이것은 샘플 아이템 1의 설명입니다.', + 'A-MAX': 'O', + 'S-MAX': 'O', + 'LNGC': 'O', + 'VLCC': 'X', + 'CONT': 'X' + }, + { + itemCode: 'BG0002', + itemName: '샘플 아이템 2', + workType: '전장', + description: '이것은 샘플 아이템 2의 설명입니다.', + 'A-MAX': 'O', + 'S-MAX': 'X', + 'LNGC': 'O', + 'VLCC': 'O', + 'CONT': 'X' + } + ]; + + // 데이터 행 추가 + sampleData.forEach(item => { + worksheet.addRow(item); + }); + + // 데이터 행 스타일 적용 + worksheet.eachRow((row, rowNumber) => { + if (rowNumber > 1) { // 헤더를 제외한 데이터 행 + row.eachCell((cell) => { + cell.border = { + top: { style: 'thin' }, + left: { style: 'thin' }, + bottom: { style: 'thin' }, + right: { style: 'thin' } + }; + }); + } + }); + + // 워크시트 보호 (선택적) + worksheet.protect('', { + selectLockedCells: true, + selectUnlockedCells: true, + formatColumns: true, + formatRows: true, + insertColumns: false, + insertRows: true, + insertHyperlinks: false, + deleteColumns: false, + deleteRows: true, + sort: true, + autoFilter: true, + pivotTables: false + }); + + try { + // 워크북을 Blob으로 변환 + const buffer = await workbook.xlsx.writeBuffer(); + const blob = new Blob([buffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' }); + saveAs(blob, 'shipbuilding-item-template.xlsx'); + return true; + } catch (error) { + console.error('Excel 템플릿 생성 오류:', error); + throw error; + } +}
\ No newline at end of file diff --git a/lib/items-tech/table/ship/items-ship-table-columns.tsx b/lib/items-tech/table/ship/items-ship-table-columns.tsx new file mode 100644 index 00000000..2b46db92 --- /dev/null +++ b/lib/items-tech/table/ship/items-ship-table-columns.tsx @@ -0,0 +1,244 @@ +"use client"
+
+import * as React from "react"
+import { type DataTableRowAction } from "@/types/table"
+import { type ColumnDef } from "@tanstack/react-table"
+import { Ellipsis } from "lucide-react"
+
+import { formatDate } from "@/lib/utils"
+import { Button } from "@/components/ui/button"
+import { Checkbox } from "@/components/ui/checkbox"
+import {
+ DropdownMenu,
+ DropdownMenuContent,
+ DropdownMenuItem,
+ DropdownMenuSeparator,
+ DropdownMenuShortcut,
+ DropdownMenuTrigger,
+} from "@/components/ui/dropdown-menu"
+import { DataTableColumnHeaderSimple } from "@/components/data-table/data-table-column-simple-header"
+
+// 테이블 표시에 필요한 데이터 타입 정의
+interface ShipbuildingTableItem {
+ id: number;
+ itemId: number;
+ workType: "기장" | "전장" | "선실" | "배관" | "철의";
+ shipTypes: string;
+ itemCode: string;
+ itemName: string;
+ description: string | null;
+ createdAt: Date;
+ updatedAt: Date;
+}
+
+interface GetColumnsProps {
+ setRowAction: React.Dispatch<React.SetStateAction<DataTableRowAction<ShipbuildingTableItem> | null>>
+}
+
+/**
+ * 조선 아이템 테이블 컬럼 정의
+ */
+export function getShipbuildingColumns({ setRowAction }: GetColumnsProps): ColumnDef<ShipbuildingTableItem>[] {
+ // ----------------------------------------------------------------
+ // 1) select 컬럼 (체크박스)
+ // ----------------------------------------------------------------
+ const selectColumn: ColumnDef<ShipbuildingTableItem> = {
+ id: "select",
+ header: ({ table }) => (
+ <Checkbox
+ checked={
+ table.getIsAllPageRowsSelected() ||
+ (table.getIsSomePageRowsSelected() && "indeterminate")
+ }
+ onCheckedChange={(value) => table.toggleAllPageRowsSelected(!!value)}
+ aria-label="Select all"
+ className="translate-y-0.5"
+ />
+ ),
+ cell: ({ row }) => (
+ <Checkbox
+ checked={row.getIsSelected()}
+ onCheckedChange={(value) => row.toggleSelected(!!value)}
+ aria-label="Select row"
+ className="translate-y-0.5"
+ />
+ ),
+ size: 40,
+ enableSorting: false,
+ enableHiding: false,
+ }
+
+ // ----------------------------------------------------------------
+ // 2) actions 컬럼 (Dropdown 메뉴)
+ // ----------------------------------------------------------------
+ const actionsColumn: ColumnDef<ShipbuildingTableItem> = {
+ id: "actions",
+ cell: ({ row }) => (
+ <DropdownMenu>
+ <DropdownMenuTrigger asChild>
+ <Button
+ aria-label="Open menu"
+ variant="ghost"
+ className="flex size-8 p-0 data-[state=open]:bg-muted"
+ >
+ <Ellipsis className="size-4" aria-hidden="true" />
+ </Button>
+ </DropdownMenuTrigger>
+ <DropdownMenuContent align="end" className="w-40">
+ <DropdownMenuItem
+ onSelect={() => setRowAction({ row, type: "update" })}
+ >
+ 수정
+ </DropdownMenuItem>
+ <DropdownMenuSeparator />
+ <DropdownMenuItem
+ onSelect={() => setRowAction({ row, type: "delete" })}
+ className="text-destructive"
+ >
+ 삭제
+ <DropdownMenuShortcut>⌘⌫</DropdownMenuShortcut>
+ </DropdownMenuItem>
+ </DropdownMenuContent>
+ </DropdownMenu>
+ ),
+ size: 40,
+ enableSorting: false,
+ enableHiding: false,
+ }
+
+ // ----------------------------------------------------------------
+ // 3) 데이터 컬럼들을 그룹별로 구성
+ // ----------------------------------------------------------------
+
+ // 3-1) 기본 정보 그룹 컬럼
+ const basicInfoColumns: ColumnDef<ShipbuildingTableItem>[] = [
+ {
+ accessorKey: "itemCode",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="Material Group" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemCode}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "Material Group",
+ group: "기본 정보",
+ },
+ },
+ {
+ accessorKey: "itemName",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="Description" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemName}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "Description",
+ group: "기본 정보",
+ },
+ },
+ {
+ accessorKey: "workType",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="기능(공종)" />
+ ),
+ cell: ({ row }) => <div>{row.original.workType}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "기능(공종)",
+ group: "기본 정보",
+ },
+ },
+ {
+ accessorKey: "description",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="Size/Dimension" />
+ ),
+ cell: ({ row }) => <div>{row.original.description || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "Size/Dimension",
+ group: "기본 정보",
+ },
+ },
+ ]
+
+ // 3-2) 선종 정보 그룹 컬럼
+ const shipTypesColumns: ColumnDef<ShipbuildingTableItem>[] = [
+ {
+ accessorKey: "shipTypes",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="선종" />
+ ),
+ cell: ({ row }) => <div>{row.original.shipTypes}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "선종",
+ group: "선종",
+ },
+ },
+ ]
+
+ // 3-3) 메타데이터 그룹 컬럼
+ const metadataColumns: ColumnDef<ShipbuildingTableItem>[] = [
+
+ {
+ accessorKey: "createdAt",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="생성일" />
+ ),
+ cell: ({ row }) => formatDate(row.original.createdAt),
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "생성일",
+ group: "Metadata",
+ },
+ },
+ {
+ accessorKey: "updatedAt",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="수정일" />
+ ),
+ cell: ({ row }) => formatDate(row.original.updatedAt),
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "수정일",
+ group: "Metadata",
+ },
+ }
+ ]
+
+ // 3-4) 그룹별 컬럼 구성
+ const groupedColumns: ColumnDef<ShipbuildingTableItem>[] = [
+ {
+ id: "기본 정보",
+ header: "기본 정보",
+ columns: basicInfoColumns,
+ },
+ {
+ id: "선종",
+ header: "선종",
+ columns: shipTypesColumns,
+ },
+ {
+ id: "Metadata",
+ header: "Metadata",
+ columns: metadataColumns,
+ }
+ ]
+
+ // ----------------------------------------------------------------
+ // 4) 최종 컬럼 배열: select, groupedColumns, actions
+ // ----------------------------------------------------------------
+ return [
+ selectColumn,
+ ...groupedColumns,
+ actionsColumn,
+ ]
+}
\ No newline at end of file diff --git a/lib/items-tech/table/ship/items-table-toolbar-actions.tsx b/lib/items-tech/table/ship/items-table-toolbar-actions.tsx new file mode 100644 index 00000000..6cae61af --- /dev/null +++ b/lib/items-tech/table/ship/items-table-toolbar-actions.tsx @@ -0,0 +1,178 @@ +"use client" + +import * as React from "react" +import { type Table } from "@tanstack/react-table" +import { Download, FileDown } from "lucide-react" +import * as ExcelJS from 'exceljs' +import { saveAs } from "file-saver" + +import { Button } from "@/components/ui/button" +import { + DropdownMenu, + DropdownMenuContent, + DropdownMenuItem, + DropdownMenuTrigger, +} from "@/components/ui/dropdown-menu" + +import { DeleteItemsDialog } from "../delete-items-dialog" +import { AddItemDialog } from "../add-items-dialog" +import { exportItemTemplate } from "./item-excel-template" +import { ImportItemButton } from "../import-excel-button" + +// 조선 아이템 타입 정의 +interface ShipbuildingItem { + id: number; + itemId: number; + workType: "기장" | "전장" | "선실" | "배관" | "철의"; + shipTypes: string; + itemCode: string; + itemName: string; + description: string | null; + createdAt: Date; + updatedAt: Date; +} + +interface ItemsTableToolbarActionsProps { + table: Table<ShipbuildingItem> +} + +export function ItemsTableToolbarActions({ table }: ItemsTableToolbarActionsProps) { + const [refreshKey, setRefreshKey] = React.useState(0) + + // 가져오기 성공 후 테이블 갱신 + const handleImportSuccess = () => { + setRefreshKey(prev => prev + 1) + } + + // Excel 내보내기 함수 + const exportTableToExcel = async ( + table: Table<ShipbuildingItem>, + options: { + filename: string; + excludeColumns?: string[]; + sheetName?: string; + } + ) => { + const { filename, excludeColumns = [], sheetName = "조선 아이템 목록" } = options; + + // 워크북 생성 + const workbook = new ExcelJS.Workbook(); + workbook.creator = 'Shipbuilding Item Management System'; + workbook.created = new Date(); + + // 워크시트 생성 + const worksheet = workbook.addWorksheet(sheetName); + + // 테이블 데이터 가져오기 + const data = table.getFilteredRowModel().rows.map(row => row.original); + console.log("내보내기 데이터:", data); + + // 필요한 헤더 직접 정의 (필터링 문제 해결) + const headers = [ + { key: 'itemCode', header: '아이템 코드' }, + { key: 'itemName', header: '아이템 명' }, + { key: 'description', header: '설명' }, + { key: 'workType', header: '기능(공종)' }, + { key: 'shipTypes', header: '선종' } + ].filter(header => !excludeColumns.includes(header.key)); + + console.log("내보내기 헤더:", headers); + // 컬럼 정의 + worksheet.columns = headers.map(header => ({ + header: header.header, + key: header.key, + width: 20 // 기본 너비 + })); + + // 스타일 적용 + const headerRow = worksheet.getRow(1); + headerRow.font = { bold: true }; + headerRow.fill = { + type: 'pattern', + pattern: 'solid', + fgColor: { argb: 'FFE0E0E0' } + }; + headerRow.alignment = { vertical: 'middle', horizontal: 'center' }; + + // 데이터 행 추가 + data.forEach(item => { + const row: Record<string, any> = {}; + headers.forEach(header => { + row[header.key] = item[header.key as keyof ShipbuildingItem]; + }); + worksheet.addRow(row); + }); + + // 전체 셀에 테두리 추가 + worksheet.eachRow((row) => { + row.eachCell((cell) => { + cell.border = { + top: { style: 'thin' }, + left: { style: 'thin' }, + bottom: { style: 'thin' }, + right: { style: 'thin' } + }; + }); + }); + + try { + // 워크북을 Blob으로 변환 + const buffer = await workbook.xlsx.writeBuffer(); + const blob = new Blob([buffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' }); + saveAs(blob, `${filename}.xlsx`); + return true; + } catch (error) { + console.error("Excel 내보내기 오류:", error); + return false; + } + } + + return ( + <div className="flex items-center gap-2"> + {/* 선택된 로우가 있으면 삭제 다이얼로그 */} + {table.getFilteredSelectedRowModel().rows.length > 0 ? ( + <DeleteItemsDialog + items={table + .getFilteredSelectedRowModel() + .rows.map((row) => row.original)} + onSuccess={() => table.toggleAllRowsSelected(false)} + itemType="shipbuilding" + /> + ) : null} + + {/* 새 아이템 추가 다이얼로그 */} + <AddItemDialog itemType="shipbuilding" /> + + {/* Import 버튼 */} + <ImportItemButton itemType="ship" onSuccess={handleImportSuccess} /> + + {/* Export 드롭다운 메뉴 */} + <DropdownMenu> + <DropdownMenuTrigger asChild> + <Button variant="outline" size="sm" className="gap-2"> + <Download className="size-4" aria-hidden="true" /> + <span className="hidden sm:inline">Export</span> + </Button> + </DropdownMenuTrigger> + <DropdownMenuContent align="end"> + <DropdownMenuItem + onClick={() => + exportTableToExcel(table, { + filename: "shipbuilding_items", + excludeColumns: ["select", "actions"], + sheetName: "조선 아이템 목록" + }) + } + > + <FileDown className="mr-2 h-4 w-4" /> + <span>현재 데이터 내보내기</span> + </DropdownMenuItem> + <DropdownMenuItem onClick={() => exportItemTemplate()}> + <FileDown className="mr-2 h-4 w-4" /> + <span>템플릿 다운로드</span> + </DropdownMenuItem> + </DropdownMenuContent> + </DropdownMenu> + </div> + ) +}
\ No newline at end of file diff --git a/lib/items-tech/table/top/import-item-handler.tsx b/lib/items-tech/table/top/import-item-handler.tsx new file mode 100644 index 00000000..de1638a8 --- /dev/null +++ b/lib/items-tech/table/top/import-item-handler.tsx @@ -0,0 +1,143 @@ +"use client" + +import { z } from "zod" +import { createOffshoreTopItem } from "../../service" + +// 해양 TOP 기능(공종) 유형 enum +const TOP_WORK_TYPES = ["TM", "TS", "TE", "TP"] as const; + +// 아이템 데이터 검증을 위한 Zod 스키마 +const itemSchema = z.object({ + itemCode: z.string().min(1, "아이템 코드는 필수입니다"), + itemName: z.string().min(1, "아이템 명은 필수입니다"), + workType: z.enum(TOP_WORK_TYPES, { + required_error: "기능(공종)은 필수입니다", + }), + description: z.string().nullable().optional(), + itemList1: z.string().nullable().optional(), + itemList2: z.string().nullable().optional(), + itemList3: z.string().nullable().optional(), + itemList4: z.string().nullable().optional(), +}); + +interface ProcessResult { + successCount: number; + errorCount: number; + errors?: Array<{ row: number; message: string }>; +} + +/** + * Excel 파일에서 가져온 해양 TOP 아이템 데이터 처리하는 함수 + */ +export async function processTopFileImport( + jsonData: any[], + progressCallback?: (current: number, total: number) => void +): Promise<ProcessResult> { + // 결과 카운터 초기화 + let successCount = 0; + let errorCount = 0; + const errors: Array<{ row: number; message: string }> = []; + + // 빈 행 등 필터링 + const dataRows = jsonData.filter(row => { + // 빈 행 건너뛰기 + if (Object.values(row).every(val => !val)) { + return false; + } + return true; + }); + + // 데이터 행이 없으면 빈 결과 반환 + if (dataRows.length === 0) { + return { successCount: 0, errorCount: 0 }; + } + + // 각 행에 대해 처리 + for (let i = 0; i < dataRows.length; i++) { + const row = dataRows[i]; + const rowIndex = i + 1; // 사용자에게 표시할 행 번호는 1부터 시작 + + // 진행 상황 콜백 호출 + if (progressCallback) { + progressCallback(i + 1, dataRows.length); + } + + try { + // 필드 매핑 (한글/영문 필드명 모두 지원) + const itemCode = row["아이템 코드"] || row["itemCode"] || ""; + const itemName = row["아이템 명"] || row["itemName"] || ""; + const workType = row["기능(공종)"] || row["workType"] || ""; + const description = row["설명"] || row["description"] || null; + const itemList1 = row["항목1"] || row["itemList1"] || null; + const itemList2 = row["항목2"] || row["itemList2"] || null; + const itemList3 = row["항목3"] || row["itemList3"] || null; + const itemList4 = row["항목4"] || row["itemList4"] || null; + + // 데이터 정제 + const cleanedRow = { + itemCode: typeof itemCode === 'string' ? itemCode.trim() : String(itemCode).trim(), + itemName: typeof itemName === 'string' ? itemName.trim() : String(itemName).trim(), + workType: typeof workType === 'string' ? workType.trim() : String(workType).trim(), + description: description ? (typeof description === 'string' ? description : String(description)) : null, + itemList1: itemList1 ? (typeof itemList1 === 'string' ? itemList1 : String(itemList1)) : null, + itemList2: itemList2 ? (typeof itemList2 === 'string' ? itemList2 : String(itemList2)) : null, + itemList3: itemList3 ? (typeof itemList3 === 'string' ? itemList3 : String(itemList3)) : null, + itemList4: itemList4 ? (typeof itemList4 === 'string' ? itemList4 : String(itemList4)) : null, + }; + + // 데이터 유효성 검사 + const validationResult = itemSchema.safeParse(cleanedRow); + + if (!validationResult.success) { + const errorMessage = validationResult.error.errors.map( + err => `${err.path.join('.')}: ${err.message}` + ).join(', '); + + errors.push({ row: rowIndex, message: errorMessage }); + errorCount++; + continue; + } + + // 해양 TOP 아이템 생성 + const result = await createOffshoreTopItem({ + itemCode: cleanedRow.itemCode, + itemName: cleanedRow.itemName, + workType: cleanedRow.workType as "TM" | "TS" | "TE" | "TP", + description: cleanedRow.description, + itemList1: cleanedRow.itemList1, + itemList2: cleanedRow.itemList2, + itemList3: cleanedRow.itemList3, + itemList4: cleanedRow.itemList4, + }); + + if (result.success) { + successCount++; + } else { + errors.push({ + row: rowIndex, + message: result.message || result.error || "알 수 없는 오류" + }); + errorCount++; + } + } catch (error) { + console.error(`${rowIndex}행 처리 오류:`, error); + errors.push({ + row: rowIndex, + message: error instanceof Error ? error.message : "알 수 없는 오류" + }); + errorCount++; + } + + // 비동기 작업 쓰로틀링 + if (i % 5 === 0) { + await new Promise(resolve => setTimeout(resolve, 10)); + } + } + + // 처리 결과 반환 + return { + successCount, + errorCount, + errors: errors.length > 0 ? errors : undefined + }; +} diff --git a/lib/items-tech/table/top/item-excel-template.tsx b/lib/items-tech/table/top/item-excel-template.tsx new file mode 100644 index 00000000..4514af59 --- /dev/null +++ b/lib/items-tech/table/top/item-excel-template.tsx @@ -0,0 +1,125 @@ +import * as ExcelJS from 'exceljs'; +import { saveAs } from "file-saver"; + +// 해양 TOP 기능(공종) 유형 +const TOP_WORK_TYPES = ["TM", "TS", "TE", "TP"] as const; + +/** + * 해양 TOP 아이템 데이터 가져오기를 위한 Excel 템플릿 파일 생성 및 다운로드 + */ +export async function exportTopItemTemplate() { + // 워크북 생성 + const workbook = new ExcelJS.Workbook(); + workbook.creator = 'Offshore TOP Item Management System'; + workbook.created = new Date(); + + // 워크시트 생성 + const worksheet = workbook.addWorksheet('해양 TOP 아이템'); + + // 컬럼 헤더 정의 및 스타일 적용 + worksheet.columns = [ + { header: '아이템 코드', key: 'itemCode', width: 15 }, + { header: '아이템 명', key: 'itemName', width: 30 }, + { header: '기능(공종)', key: 'workType', width: 15 }, + { header: '설명', key: 'description', width: 50 }, + { header: '항목1', key: 'itemList1', width: 20 }, + { header: '항목2', key: 'itemList2', width: 20 }, + { header: '항목3', key: 'itemList3', width: 20 }, + { header: '항목4', key: 'itemList4', width: 20 }, + ]; + + // 헤더 스타일 적용 + const headerRow = worksheet.getRow(1); + headerRow.font = { bold: true }; + headerRow.fill = { + type: 'pattern', + pattern: 'solid', + fgColor: { argb: 'FFE0E0E0' } + }; + headerRow.alignment = { vertical: 'middle', horizontal: 'center' }; + + // 테두리 스타일 적용 + headerRow.eachCell((cell) => { + cell.border = { + top: { style: 'thin' }, + left: { style: 'thin' }, + bottom: { style: 'thin' }, + right: { style: 'thin' } + }; + }); + + // 샘플 데이터 추가 + const sampleData = [ + { + itemCode: 'TOP001', + itemName: 'TOP 샘플 아이템 1', + workType: 'TM', + description: '이것은 해양 TOP 샘플 아이템 1의 설명입니다.', + itemList1: '항목1 샘플 데이터', + itemList2: '항목2 샘플 데이터', + itemList3: '항목3 샘플 데이터', + itemList4: '항목4 샘플 데이터' + }, + { + itemCode: 'TOP002', + itemName: 'TOP 샘플 아이템 2', + workType: 'TS', + description: '이것은 해양 TOP 샘플 아이템 2의 설명입니다.', + itemList1: '항목1 샘플 데이터', + itemList2: '항목2 샘플 데이터', + itemList3: '', + itemList4: '' + } + ]; + + // 데이터 행 추가 + sampleData.forEach(item => { + worksheet.addRow(item); + }); + + // 데이터 행 스타일 적용 + worksheet.eachRow((row, rowNumber) => { + if (rowNumber > 1) { // 헤더를 제외한 데이터 행 + row.eachCell((cell) => { + cell.border = { + top: { style: 'thin' }, + left: { style: 'thin' }, + bottom: { style: 'thin' }, + right: { style: 'thin' } + }; + }); + } + }); + + // 워크시트에 공종 유형 관련 메모 추가 + const infoRow = worksheet.addRow(['공종 유형 안내: ' + TOP_WORK_TYPES.join(', ')]); + infoRow.font = { bold: true, color: { argb: 'FF0000FF' } }; + worksheet.mergeCells(`A${infoRow.number}:H${infoRow.number}`); + + // 워크시트 보호 (선택적) + worksheet.protect('', { + selectLockedCells: true, + selectUnlockedCells: true, + formatColumns: true, + formatRows: true, + insertColumns: false, + insertRows: true, + insertHyperlinks: false, + deleteColumns: false, + deleteRows: true, + sort: true, + autoFilter: true, + pivotTables: false + }); + + try { + // 워크북을 Blob으로 변환 + const buffer = await workbook.xlsx.writeBuffer(); + const blob = new Blob([buffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' }); + saveAs(blob, 'offshore-top-item-template.xlsx'); + return true; + } catch (error) { + console.error('Excel 템플릿 생성 오류:', error); + throw error; + } +} diff --git a/lib/items-tech/table/top/offshore-top-table-columns.tsx b/lib/items-tech/table/top/offshore-top-table-columns.tsx new file mode 100644 index 00000000..4ccb2003 --- /dev/null +++ b/lib/items-tech/table/top/offshore-top-table-columns.tsx @@ -0,0 +1,282 @@ +"use client"
+
+import * as React from "react"
+import { type DataTableRowAction } from "@/types/table"
+import { type ColumnDef } from "@tanstack/react-table"
+import { Ellipsis } from "lucide-react"
+
+import { formatDate } from "@/lib/utils"
+import { Button } from "@/components/ui/button"
+import { Checkbox } from "@/components/ui/checkbox"
+import {
+ DropdownMenu,
+ DropdownMenuContent,
+ DropdownMenuItem,
+ DropdownMenuSeparator,
+ DropdownMenuShortcut,
+ DropdownMenuTrigger,
+} from "@/components/ui/dropdown-menu"
+import { DataTableColumnHeaderSimple } from "@/components/data-table/data-table-column-simple-header"
+
+// 테이블 표시에 필요한 데이터 타입 정의
+interface OffshoreTopTableItem {
+ id: number;
+ itemId: number;
+ workType: "TM" | "TS" | "TE" | "TP";
+ itemList1: string | null;
+ itemList2: string | null;
+ itemList3: string | null;
+ itemList4: string | null;
+ itemCode: string;
+ itemName: string;
+ description: string | null;
+ createdAt: Date;
+ updatedAt: Date;
+}
+
+interface GetColumnsProps {
+ setRowAction: React.Dispatch<React.SetStateAction<DataTableRowAction<OffshoreTopTableItem> | null>>
+}
+
+export function getOffshoreTopColumns({ setRowAction }: GetColumnsProps): ColumnDef<OffshoreTopTableItem>[] {
+ // ----------------------------------------------------------------
+ // 1) select 컬럼 (체크박스)
+ // ----------------------------------------------------------------
+ const selectColumn: ColumnDef<OffshoreTopTableItem> = {
+ id: "select",
+ header: ({ table }) => (
+ <Checkbox
+ checked={
+ table.getIsAllPageRowsSelected() ||
+ (table.getIsSomePageRowsSelected() && "indeterminate")
+ }
+ onCheckedChange={(value) => table.toggleAllPageRowsSelected(!!value)}
+ aria-label="Select all"
+ className="translate-y-0.5"
+ />
+ ),
+ cell: ({ row }) => (
+ <Checkbox
+ checked={row.getIsSelected()}
+ onCheckedChange={(value) => row.toggleSelected(!!value)}
+ aria-label="Select row"
+ className="translate-y-0.5"
+ />
+ ),
+ size: 40,
+ enableSorting: false,
+ enableHiding: false,
+ }
+
+ // ----------------------------------------------------------------
+ // 2) actions 컬럼 (Dropdown 메뉴)
+ // ----------------------------------------------------------------
+ const actionsColumn: ColumnDef<OffshoreTopTableItem> = {
+ id: "actions",
+ cell: ({ row }) => (
+ <DropdownMenu>
+ <DropdownMenuTrigger asChild>
+ <Button
+ aria-label="Open menu"
+ variant="ghost"
+ className="flex size-8 p-0 data-[state=open]:bg-muted"
+ >
+ <Ellipsis className="size-4" aria-hidden="true" />
+ </Button>
+ </DropdownMenuTrigger>
+ <DropdownMenuContent align="end" className="w-40">
+ <DropdownMenuItem
+ onSelect={() => setRowAction({ row, type: "update" })}
+ >
+ 수정
+ </DropdownMenuItem>
+ <DropdownMenuSeparator />
+ <DropdownMenuItem
+ onSelect={() => setRowAction({ row, type: "delete" })}
+ className="text-destructive"
+ >
+ 삭제
+ <DropdownMenuShortcut>⌘⌫</DropdownMenuShortcut>
+ </DropdownMenuItem>
+ </DropdownMenuContent>
+ </DropdownMenu>
+ ),
+ size: 40,
+ enableSorting: false,
+ enableHiding: false,
+ }
+
+ // ----------------------------------------------------------------
+ // 3) 데이터 컬럼들을 그룹별로 구성
+ // ----------------------------------------------------------------
+
+ // 3-1) 기본 정보 그룹 컬럼
+ const basicInfoColumns: ColumnDef<OffshoreTopTableItem>[] = [
+ {
+ accessorKey: "itemCode",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="Material Group" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemCode}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "Material Group",
+ group: "기본 정보",
+ },
+ },
+ {
+ accessorKey: "itemName",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="Description" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemName}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "Description",
+ group: "기본 정보",
+ },
+ },
+ {
+ accessorKey: "workType",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="기능(공종)" />
+ ),
+ cell: ({ row }) => <div>{row.original.workType}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "기능(공종)",
+ group: "기본 정보",
+ },
+ },
+ {
+ accessorKey: "description",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="Size/Dimension" />
+ ),
+ cell: ({ row }) => <div>{row.original.description || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "Size/Dimension",
+ group: "기본 정보",
+ },
+ },
+ ]
+
+ // 3-2) 아이템 리스트 그룹 컬럼
+ const itemListColumns: ColumnDef<OffshoreTopTableItem>[] = [
+ {
+ accessorKey: "itemList1",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="아이템 리스트 1" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemList1 || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "아이템 리스트 1",
+ group: "아이템 리스트",
+ },
+ },
+ {
+ accessorKey: "itemList2",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="아이템 리스트 2" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemList2 || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "아이템 리스트 2",
+ group: "아이템 리스트",
+ },
+ },
+ {
+ accessorKey: "itemList3",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="아이템 리스트 3" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemList3 || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "아이템 리스트 3",
+ group: "아이템 리스트",
+ },
+ },
+ {
+ accessorKey: "itemList4",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="아이템 리스트 4" />
+ ),
+ cell: ({ row }) => <div>{row.original.itemList4 || "-"}</div>,
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "아이템 리스트 4",
+ group: "아이템 리스트",
+ },
+ },
+ ]
+
+ // 3-3) 메타데이터 그룹 컬럼
+ const metadataColumns: ColumnDef<OffshoreTopTableItem>[] = [
+ {
+ accessorKey: "createdAt",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="생성일" />
+ ),
+ cell: ({ row }) => formatDate(row.original.createdAt),
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "생성일",
+ group: "Metadata",
+ },
+ },
+ {
+ accessorKey: "updatedAt",
+ header: ({ column }) => (
+ <DataTableColumnHeaderSimple column={column} title="수정일" />
+ ),
+ cell: ({ row }) => formatDate(row.original.updatedAt),
+ enableSorting: true,
+ enableHiding: true,
+ meta: {
+ excelHeader: "수정일",
+ group: "Metadata",
+ },
+ }
+ ]
+
+ // 3-4) 그룹별 컬럼 구성
+ const groupedColumns: ColumnDef<OffshoreTopTableItem>[] = [
+ {
+ id: "기본 정보",
+ header: "기본 정보",
+ columns: basicInfoColumns,
+ },
+ {
+ id: "아이템 리스트",
+ header: "아이템 리스트",
+ columns: itemListColumns,
+ },
+ {
+ id: "Metadata",
+ header: "Metadata",
+ columns: metadataColumns,
+ }
+ ]
+
+ // ----------------------------------------------------------------
+ // 4) 최종 컬럼 배열: select, groupedColumns, actions
+ // ----------------------------------------------------------------
+ return [
+ selectColumn,
+ ...groupedColumns,
+ actionsColumn,
+ ]
+}
\ No newline at end of file diff --git a/lib/items-tech/table/top/offshore-top-table-toolbar-actions.tsx b/lib/items-tech/table/top/offshore-top-table-toolbar-actions.tsx new file mode 100644 index 00000000..324312aa --- /dev/null +++ b/lib/items-tech/table/top/offshore-top-table-toolbar-actions.tsx @@ -0,0 +1,184 @@ +"use client"
+
+import * as React from "react"
+import { type Table } from "@tanstack/react-table"
+import { Download, FileDown } from "lucide-react"
+import * as ExcelJS from 'exceljs'
+import { saveAs } from "file-saver"
+
+import { Button } from "@/components/ui/button"
+import {
+ DropdownMenu,
+ DropdownMenuContent,
+ DropdownMenuItem,
+ DropdownMenuTrigger,
+} from "@/components/ui/dropdown-menu"
+
+import { DeleteItemsDialog } from "../delete-items-dialog"
+import { AddItemDialog } from "../add-items-dialog"
+import { exportTopItemTemplate } from "./item-excel-template"
+import { ImportItemButton } from "../import-excel-button"
+
+// 해양 TOP 아이템 타입 정의
+interface OffshoreTopItem {
+ id: number;
+ itemId: number;
+ workType: "TM" | "TS" | "TE" | "TP";
+ itemList1: string | null;
+ itemList2: string | null;
+ itemList3: string | null;
+ itemList4: string | null;
+ itemCode: string;
+ itemName: string;
+ description: string | null;
+ createdAt: Date;
+ updatedAt: Date;
+}
+
+interface OffshoreTopTableToolbarActionsProps {
+ table: Table<OffshoreTopItem>
+}
+
+export function OffshoreTopTableToolbarActions({ table }: OffshoreTopTableToolbarActionsProps) {
+ const [refreshKey, setRefreshKey] = React.useState(0)
+
+ // 가져오기 성공 후 테이블 갱신
+ const handleImportSuccess = () => {
+ setRefreshKey(prev => prev + 1)
+ }
+
+ // Excel 내보내기 함수
+ const exportTableToExcel = async (
+ table: Table<OffshoreTopItem>,
+ options: {
+ filename: string;
+ excludeColumns?: string[];
+ sheetName?: string;
+ }
+ ) => {
+ const { filename, excludeColumns = [], sheetName = "해양 TOP 아이템 목록" } = options;
+
+ // 워크북 생성
+ const workbook = new ExcelJS.Workbook();
+ workbook.creator = 'Offshore Item Management System';
+ workbook.created = new Date();
+
+ // 워크시트 생성
+ const worksheet = workbook.addWorksheet(sheetName);
+
+ // 테이블 데이터 가져오기
+ const data = table.getFilteredRowModel().rows.map(row => row.original);
+ console.log("내보내기 데이터:", data);
+
+ // 필요한 헤더 직접 정의 (필터링 문제 해결)
+ const headers = [
+ { key: 'itemCode', header: '아이템 코드' },
+ { key: 'itemName', header: '아이템 명' },
+ { key: 'description', header: '설명' },
+ { key: 'workType', header: '기능(공종)' },
+ { key: 'itemList1', header: '아이템 리스트 1' },
+ { key: 'itemList2', header: '아이템 리스트 2' },
+ { key: 'itemList3', header: '아이템 리스트 3' },
+ { key: 'itemList4', header: '아이템 리스트 4' }
+ ].filter(header => !excludeColumns.includes(header.key));
+
+ console.log("내보내기 헤더:", headers);
+ // 컬럼 정의
+ worksheet.columns = headers.map(header => ({
+ header: header.header,
+ key: header.key,
+ width: 20 // 기본 너비
+ }));
+
+ // 스타일 적용
+ const headerRow = worksheet.getRow(1);
+ headerRow.font = { bold: true };
+ headerRow.fill = {
+ type: 'pattern',
+ pattern: 'solid',
+ fgColor: { argb: 'FFE0E0E0' }
+ };
+ headerRow.alignment = { vertical: 'middle', horizontal: 'center' };
+
+ // 데이터 행 추가
+ data.forEach(item => {
+ const row: Record<string, any> = {};
+ headers.forEach(header => {
+ row[header.key] = item[header.key as keyof OffshoreTopItem];
+ });
+ worksheet.addRow(row);
+ });
+
+ // 전체 셀에 테두리 추가
+ worksheet.eachRow((row) => {
+ row.eachCell((cell) => {
+ cell.border = {
+ top: { style: 'thin' },
+ left: { style: 'thin' },
+ bottom: { style: 'thin' },
+ right: { style: 'thin' }
+ };
+ });
+ });
+
+ try {
+ // 워크북을 Blob으로 변환
+ const buffer = await workbook.xlsx.writeBuffer();
+ const blob = new Blob([buffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
+ saveAs(blob, `${filename}.xlsx`);
+ return true;
+ } catch (error) {
+ console.error("Excel 내보내기 오류:", error);
+ return false;
+ }
+ }
+
+ return (
+ <div className="flex items-center gap-2">
+ {/* 선택된 로우가 있으면 삭제 다이얼로그 */}
+ {table.getFilteredSelectedRowModel().rows.length > 0 ? (
+ <DeleteItemsDialog
+ items={table
+ .getFilteredSelectedRowModel()
+ .rows.map((row) => row.original)}
+ onSuccess={() => table.toggleAllRowsSelected(false)}
+ itemType="offshoreTop"
+ />
+ ) : null}
+
+ {/* 새 아이템 추가 다이얼로그 */}
+ <AddItemDialog itemType="offshoreTop" />
+
+ {/* Import 버튼 */}
+ <ImportItemButton itemType="top" onSuccess={handleImportSuccess} />
+
+ {/* Export 드롭다운 메뉴 */}
+ <DropdownMenu>
+ <DropdownMenuTrigger asChild>
+ <Button variant="outline" size="sm" className="gap-2">
+ <Download className="size-4" aria-hidden="true" />
+ <span className="hidden sm:inline">Export</span>
+ </Button>
+ </DropdownMenuTrigger>
+ <DropdownMenuContent align="end">
+ <DropdownMenuItem
+ onClick={() =>
+ exportTableToExcel(table, {
+ filename: "offshore_top_items",
+ excludeColumns: ["select", "actions"],
+ sheetName: "해양 TOP 아이템 목록"
+ })
+ }
+ >
+ <FileDown className="mr-2 h-4 w-4" />
+ <span>현재 데이터 내보내기</span>
+ </DropdownMenuItem>
+ <DropdownMenuItem onClick={() => exportTopItemTemplate()}>
+ <FileDown className="mr-2 h-4 w-4" />
+ <span>템플릿 다운로드</span>
+ </DropdownMenuItem>
+ </DropdownMenuContent>
+ </DropdownMenu>
+ </div>
+ )
+}
\ No newline at end of file diff --git a/lib/items-tech/table/top/offshore-top-table.tsx b/lib/items-tech/table/top/offshore-top-table.tsx new file mode 100644 index 00000000..dedf766a --- /dev/null +++ b/lib/items-tech/table/top/offshore-top-table.tsx @@ -0,0 +1,153 @@ +"use client"
+
+import * as React from "react"
+import type {
+ DataTableFilterField,
+ DataTableAdvancedFilterField,
+ DataTableRowAction,
+} from "@/types/table"
+
+import { useDataTable } from "@/hooks/use-data-table"
+import { DataTable } from "@/components/data-table/data-table"
+import { DataTableAdvancedToolbar } from "@/components/data-table/data-table-advanced-toolbar"
+import { getOffshoreTopItems } from "../../service"
+import { getOffshoreTopColumns } from "./offshore-top-table-columns"
+import { OffshoreTopTableToolbarActions } from "./offshore-top-table-toolbar-actions"
+import { DeleteItemsDialog } from "../delete-items-dialog"
+import { UpdateItemSheet } from "../update-items-sheet"
+
+// 서비스에서 반환하는 데이터 타입 정의
+type OffshoreTopItem = {
+ id: number;
+ itemId: number;
+ workType: "TM" | "TS" | "TE" | "TP";
+ itemList1: string | null;
+ itemList2: string | null;
+ itemList3: string | null;
+ itemList4: string | null;
+ itemCode: string;
+ itemName: string;
+ description: string | null;
+ createdAt: Date;
+ updatedAt: Date;
+}
+
+interface OffshoreTopTableProps {
+ promises: Promise<Awaited<ReturnType<typeof getOffshoreTopItems>>>
+}
+
+export function OffshoreTopTable({ promises }: OffshoreTopTableProps) {
+ const { data, pageCount } = React.use(promises)
+
+ // 아이템 타입에 따른 행 액션 상태 관리
+ const [rowAction, setRowAction] = React.useState<DataTableRowAction<OffshoreTopItem> | null>(null)
+ const columns = getOffshoreTopColumns({ setRowAction })
+ const filterFields: DataTableFilterField<OffshoreTopItem>[] = [
+ {
+ id: "itemCode",
+ label: "Item Code",
+ },
+ {
+ id: "itemName",
+ label: "Item Name",
+ },
+ {
+ id: "workType",
+ label: "기능(공종)",
+ },
+ {
+ id: "itemList1",
+ label: "아이템 리스트 1",
+ },
+ ]
+
+ const advancedFilterFields: DataTableAdvancedFilterField<OffshoreTopItem>[] = [
+ {
+ id: "itemCode",
+ label: "Item Code",
+ type: "text",
+ },
+ {
+ id: "itemName",
+ label: "Item Name",
+ type: "text",
+ },
+ {
+ id: "description",
+ label: "Description",
+ type: "text",
+ },
+ {
+ id: "workType",
+ label: "기능(공종)",
+ type: "text",
+ },
+ {
+ id: "itemList1",
+ label: "아이템 리스트 1",
+ type: "text",
+ },
+ {
+ id: "itemList2",
+ label: "아이템 리스트 2",
+ type: "text",
+ },
+ {
+ id: "itemList3",
+ label: "아이템 리스트 3",
+ type: "text",
+ },
+ {
+ id: "itemList4",
+ label: "아이템 리스트 4",
+ type: "text",
+ },
+ ]
+
+ const { table } = useDataTable({
+ data: data as OffshoreTopItem[],
+ columns,
+ pageCount,
+ filterFields,
+ enablePinning: true,
+ enableAdvancedFilter: true,
+ initialState: {
+ sorting: [{ id: "createdAt", desc: true }],
+ columnPinning: { right: ["actions"] },
+ },
+ getRowId: (originalRow) => String(originalRow.id),
+ shallow: false,
+ clearOnDefault: true,
+ })
+
+ return (
+ <>
+ <DataTable table={table}>
+ <DataTableAdvancedToolbar
+ table={table}
+ filterFields={advancedFilterFields}
+ shallow={false}
+ >
+ <OffshoreTopTableToolbarActions table={table} />
+ </DataTableAdvancedToolbar>
+ </DataTable>
+ <DeleteItemsDialog
+ open={rowAction?.type === "delete"}
+ onOpenChange={() => setRowAction(null)}
+ items={rowAction?.row.original ? [rowAction?.row.original] : []}
+ showTrigger={false}
+ onSuccess={() => rowAction?.row.toggleSelected(false)}
+ itemType="offshoreTop"
+ />
+
+ {rowAction?.type === "update" && rowAction.row.original && (
+ <UpdateItemSheet
+ item={rowAction.row.original}
+ itemType="offshoreTop"
+ open={true}
+ onOpenChange={() => setRowAction(null)}
+ />
+ )}
+ </>
+ )
+}
\ No newline at end of file diff --git a/lib/items-tech/table/update-items-sheet.tsx b/lib/items-tech/table/update-items-sheet.tsx new file mode 100644 index 00000000..2db3b193 --- /dev/null +++ b/lib/items-tech/table/update-items-sheet.tsx @@ -0,0 +1,390 @@ +"use client"
+
+import * as React from "react"
+import { useForm } from "react-hook-form"
+
+import { Button } from "@/components/ui/button"
+import {
+ Sheet,
+ SheetClose,
+ SheetContent,
+ SheetDescription,
+ SheetFooter,
+ SheetHeader,
+ SheetTitle,
+} from "@/components/ui/sheet"
+import {
+ Form,
+ FormControl,
+ FormField,
+ FormItem,
+ FormLabel,
+ FormMessage,
+} from "@/components/ui/form"
+import { Input } from "@/components/ui/input"
+import {
+ Select,
+ SelectContent,
+ SelectItem,
+ SelectTrigger,
+ SelectValue,
+} from "@/components/ui/select"
+import { Textarea } from "@/components/ui/textarea"
+import { toast } from "sonner"
+
+import {
+ modifyShipbuildingItem,
+ modifyOffshoreTopItem,
+ modifyOffshoreHullItem
+} from "../service"
+import { ItemType } from "./delete-items-dialog"
+
+const shipbuildingWorkTypes = [
+ { value: "기장", label: "기장" },
+ { value: "전장", label: "전장" },
+ { value: "선실", label: "선실" },
+ { value: "배관", label: "배관" },
+ { value: "철의", label: "철의" },
+] as const
+
+const offshoreTopWorkTypes = [
+ { value: "TM", label: "TM" },
+ { value: "TS", label: "TS" },
+ { value: "TE", label: "TE" },
+ { value: "TP", label: "TP" },
+] as const
+
+const offshoreHullWorkTypes = [
+ { value: "HA", label: "HA" },
+ { value: "HE", label: "HE" },
+ { value: "HH", label: "HH" },
+ { value: "HM", label: "HM" },
+ { value: "NC", label: "NC" },
+] as const
+
+interface CommonItemFields {
+ id: number
+ itemId: number
+ itemCode: string
+ itemName: string
+ description: string | null
+ createdAt: Date
+ updatedAt: Date
+}
+
+type ShipbuildingItem = CommonItemFields & {
+ workType: "기장" | "전장" | "선실" | "배관" | "철의"
+ shipTypes: string
+}
+
+type OffshoreTopItem = CommonItemFields & {
+ workType: "TM" | "TS" | "TE" | "TP"
+ itemList1: string | null
+ itemList2: string | null
+ itemList3: string | null
+ itemList4: string | null
+}
+
+type OffshoreHullItem = CommonItemFields & {
+ workType: "HA" | "HE" | "HH" | "HM" | "NC"
+ itemList1: string | null
+ itemList2: string | null
+ itemList3: string | null
+ itemList4: string | null
+}
+
+type UpdateItemSchema = {
+ itemCode?: string
+ itemName?: string
+ description?: string
+ workType?: string
+ shipTypes?: string
+ itemList1?: string
+ itemList2?: string
+ itemList3?: string
+ itemList4?: string
+}
+
+interface UpdateItemSheetProps {
+ item: ShipbuildingItem | OffshoreTopItem | OffshoreHullItem
+ itemType: ItemType
+ open: boolean
+ onOpenChange: (open: boolean) => void
+}
+
+export function UpdateItemSheet({ item, itemType, open, onOpenChange }: UpdateItemSheetProps) {
+ const [isSubmitting, setIsSubmitting] = React.useState(false)
+
+ // 초기값 설정
+ const form = useForm<UpdateItemSchema>({
+ defaultValues: {
+ itemCode: item.itemCode,
+ itemName: item.itemName,
+ description: item.description || "",
+ workType: item.workType,
+ ...getItemTypeSpecificDefaults(item, itemType),
+ },
+ })
+
+ function getItemTypeSpecificDefaults(
+ item: ShipbuildingItem | OffshoreTopItem | OffshoreHullItem,
+ itemType: ItemType
+ ) {
+ switch (itemType) {
+ case 'shipbuilding':
+ return {
+ shipTypes: (item as ShipbuildingItem).shipTypes
+ };
+ case 'offshoreTop':
+ case 'offshoreHull':
+ const offshoreItem = item as OffshoreTopItem | OffshoreHullItem;
+ return {
+ itemList1: offshoreItem.itemList1 || "",
+ itemList2: offshoreItem.itemList2 || "",
+ itemList3: offshoreItem.itemList3 || "",
+ itemList4: offshoreItem.itemList4 || "",
+ };
+ default:
+ return {};
+ }
+ }
+
+ async function onSubmit(data: UpdateItemSchema) {
+ try {
+ setIsSubmitting(true)
+ let result;
+
+ switch (itemType) {
+ case 'shipbuilding':
+ result = await modifyShipbuildingItem({
+ ...data,
+ id: item.id
+ });
+ break;
+ case 'offshoreTop':
+ result = await modifyOffshoreTopItem({
+ ...data,
+ id: item.id
+ });
+ break;
+ case 'offshoreHull':
+ result = await modifyOffshoreHullItem({
+ ...data,
+ id: item.id
+ });
+ break;
+ default:
+ toast.error("지원하지 않는 아이템 타입입니다");
+ return;
+ }
+
+ if (result.success) {
+ toast.success(result.message || "아이템이 수정되었습니다.")
+ onOpenChange(false)
+ } else {
+ toast.error(result.error || "아이템 수정 중 오류가 발생했습니다. 다시 시도해주세요.")
+ }
+ } catch (error) {
+ toast.error("오류가 발생했습니다.")
+ console.error(error)
+ } finally {
+ setIsSubmitting(false)
+ }
+ }
+
+ const getItemTypeLabel = () => {
+ switch (itemType) {
+ case 'shipbuilding':
+ return '조선 아이템';
+ case 'offshoreTop':
+ return '해양 TOP 아이템';
+ case 'offshoreHull':
+ return '해양 HULL 아이템';
+ default:
+ return '아이템';
+ }
+ }
+
+ const getWorkTypeOptions = () => {
+ switch (itemType) {
+ case 'shipbuilding':
+ return shipbuildingWorkTypes;
+ case 'offshoreTop':
+ return offshoreTopWorkTypes;
+ case 'offshoreHull':
+ return offshoreHullWorkTypes;
+ default:
+ return [];
+ }
+ }
+
+ return (
+ <Sheet open={open} onOpenChange={onOpenChange}>
+ <SheetContent>
+ <SheetHeader>
+ <SheetTitle>{getItemTypeLabel()} 수정</SheetTitle>
+ <SheetDescription>
+ {getItemTypeLabel()} 정보를 수정합니다. 수정할 필드를 입력해주세요.
+ </SheetDescription>
+ </SheetHeader>
+ <Form {...form}>
+ <form onSubmit={form.handleSubmit(onSubmit)} className="space-y-4">
+ <FormField
+ control={form.control}
+ name="itemCode"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>Material Group</FormLabel>
+ <FormControl>
+ <Input placeholder="Material Group을 입력하세요" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <FormField
+ control={form.control}
+ name="itemName"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>Description</FormLabel>
+ <FormControl>
+ <Input placeholder="Description을 입력하세요" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <FormField
+ control={form.control}
+ name="workType"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>기능(공종)</FormLabel>
+ <Select
+ onValueChange={field.onChange}
+ defaultValue={field.value}
+ >
+ <FormControl>
+ <SelectTrigger>
+ <SelectValue placeholder="기능(공종)을 선택하세요" />
+ </SelectTrigger>
+ </FormControl>
+ <SelectContent>
+ {getWorkTypeOptions().map((type) => (
+ <SelectItem key={type.value} value={type.value}>
+ {type.label}
+ </SelectItem>
+ ))}
+ </SelectContent>
+ </Select>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+
+ {/* 조선 아이템 전용 필드 */}
+ {itemType === 'shipbuilding' && (
+ <FormField
+ control={form.control}
+ name="shipTypes"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>선종</FormLabel>
+ <FormControl>
+ <Input placeholder="선종을 입력하세요" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ )}
+
+ {/* 해양 TOP 또는 HULL 아이템 전용 필드 */}
+ {(itemType === 'offshoreTop' || itemType === 'offshoreHull') && (
+ <>
+ <FormField
+ control={form.control}
+ name="itemList1"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>Item List 1</FormLabel>
+ <FormControl>
+ <Input placeholder="Item List 1을 입력하세요" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <FormField
+ control={form.control}
+ name="itemList2"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>Item List 2</FormLabel>
+ <FormControl>
+ <Input placeholder="Item List 2를 입력하세요" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <FormField
+ control={form.control}
+ name="itemList3"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>Item List 3</FormLabel>
+ <FormControl>
+ <Input placeholder="Item List 3을 입력하세요" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <FormField
+ control={form.control}
+ name="itemList4"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>Item List 4</FormLabel>
+ <FormControl>
+ <Input placeholder="Item List 4를 입력하세요" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ </>
+ )}
+
+ <FormField
+ control={form.control}
+ name="description"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>Size/Dimension</FormLabel>
+ <FormControl>
+ <Textarea
+ placeholder="Size/Dimension을 입력하세요"
+ {...field}
+ />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ <SheetFooter>
+ <SheetClose asChild>
+ <Button variant="outline">취소</Button>
+ </SheetClose>
+ <Button type="submit" disabled={isSubmitting}>
+ {isSubmitting ? "수정 중..." : "수정"}
+ </Button>
+ </SheetFooter>
+ </form>
+ </Form>
+ </SheetContent>
+ </Sheet>
+ )
+}
\ No newline at end of file diff --git a/lib/items-tech/validations.ts b/lib/items-tech/validations.ts new file mode 100644 index 00000000..7c8a58f9 --- /dev/null +++ b/lib/items-tech/validations.ts @@ -0,0 +1,156 @@ +import {
+ createSearchParamsCache,
+ parseAsArrayOf,
+ parseAsInteger,
+ parseAsString,
+ parseAsStringEnum,
+} from "nuqs/server"
+import * as z from "zod"
+
+import { getFiltersStateParser, getSortingStateParser } from "@/lib/parsers"
+import { Item } from "@/db/schema/items";
+
+export const searchParamsCache = createSearchParamsCache({
+ flags: parseAsArrayOf(z.enum(["advancedTable", "floatingBar"])).withDefault(
+ []
+ ),
+ page: parseAsInteger.withDefault(1),
+ perPage: parseAsInteger.withDefault(10),
+ sort: getSortingStateParser<Item>().withDefault([
+ { id: "createdAt", desc: true },
+ ]),
+ itemCode: parseAsString.withDefault(""),
+ itemName: parseAsString.withDefault(""),
+ description: parseAsString.withDefault(""),
+
+ // advanced filter
+ filters: getFiltersStateParser().withDefault([]),
+ joinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
+ search: parseAsString.withDefault(""),
+})
+
+export const createItemSchema = z.object({
+ itemCode: z.string(),
+ itemName: z.string(),
+ description: z.string(),
+})
+
+export const updateItemSchema = z.object({
+ itemCode: z.string().optional(),
+ itemName: z.string().optional(),
+ description: z.string().nullish(),
+})
+
+// 조선 아이템 업데이트 스키마
+export const updateShipbuildingItemSchema = z.object({
+ itemCode: z.string(),
+ itemName: z.string().optional(),
+ description: z.string().optional(),
+ workType: z.string().optional(),
+ shipTypes: z.string().optional(),
+})
+
+export type GetItemsSchema = Awaited<ReturnType<typeof searchParamsCache.parse>>
+export type CreateItemSchema = z.infer<typeof createItemSchema>
+export type UpdateItemSchema = z.infer<typeof updateItemSchema>
+export type UpdateShipbuildingItemSchema = z.infer<typeof updateShipbuildingItemSchema>
+
+// 조선 아이템 스키마
+export const createShipbuildingItemSchema = z.object({
+ itemCode: z.string(),
+ itemName: z.string(),
+ description: z.string(),
+ workType: z.string(),
+ shipTypes: z.string(),
+})
+
+export type CreateShipbuildingItemSchema = z.infer<typeof createShipbuildingItemSchema>
+
+// 기본 아이템 생성 데이터 타입
+export interface ItemCreateData {
+ itemCode: string
+ itemName: string
+ description: string | null
+}
+
+// 조선 아이템 생성 데이터 타입
+export interface ShipbuildingItemCreateData extends ItemCreateData {
+ workType: string | null
+ shipTypes: string | null
+}
+
+// 아이템 타입에 따른 생성 데이터 타입
+export type TypedItemCreateData = ShipbuildingItemCreateData
+
+// 해양 TOP 아이템 스키마
+export const createOffshoreTopItemSchema = z.object({
+ itemCode: z.string(),
+ itemName: z.string(),
+ description: z.string(),
+ workType: z.enum(["TM", "TS", "TE", "TP"]),
+ itemList1: z.string().optional(),
+ itemList2: z.string().optional(),
+ itemList3: z.string().optional(),
+ itemList4: z.string().optional(),
+})
+
+// 해양 HULL 아이템 스키마
+export const createOffshoreHullItemSchema = z.object({
+ itemCode: z.string(),
+ itemName: z.string(),
+ description: z.string(),
+ workType: z.enum(["HA", "HE", "HH", "HM", "NC"]),
+ itemList1: z.string().optional(),
+ itemList2: z.string().optional(),
+ itemList3: z.string().optional(),
+ itemList4: z.string().optional(),
+})
+
+export type CreateOffshoreTopItemSchema = z.infer<typeof createOffshoreTopItemSchema>
+export type CreateOffshoreHullItemSchema = z.infer<typeof createOffshoreHullItemSchema>
+
+// 해양 TOP 아이템 업데이트 스키마
+export const updateOffshoreTopItemSchema = z.object({
+ itemCode: z.string(),
+ itemName: z.string().optional(),
+ description: z.string().optional(),
+ workType: z.enum(["TM", "TS", "TE", "TP"]).optional(),
+ itemList1: z.string().optional(),
+ itemList2: z.string().optional(),
+ itemList3: z.string().optional(),
+ itemList4: z.string().optional(),
+})
+
+// 해양 HULL 아이템 업데이트 스키마
+export const updateOffshoreHullItemSchema = z.object({
+ itemCode: z.string(),
+ itemName: z.string().optional(),
+ description: z.string().optional(),
+ workType: z.enum(["HA", "HE", "HH", "HM", "NC"]).optional(),
+ itemList1: z.string().optional(),
+ itemList2: z.string().optional(),
+ itemList3: z.string().optional(),
+ itemList4: z.string().optional(),
+})
+
+export type UpdateOffshoreTopItemSchema = z.infer<typeof updateOffshoreTopItemSchema>
+export type UpdateOffshoreHullItemSchema = z.infer<typeof updateOffshoreHullItemSchema>
+
+// 해양 TOP 아이템 생성 데이터 타입
+export interface OffshoreTopItemCreateData extends ItemCreateData {
+ workType: "TM" | "TS" | "TE" | "TP"
+ itemList1?: string | null
+ itemList2?: string | null
+ itemList3?: string | null
+ itemList4?: string | null
+}
+
+// 해양 HULL 아이템 생성 데이터 타입
+export interface OffshoreHullItemCreateData extends ItemCreateData {
+ workType: "HA" | "HE" | "HH" | "HM" | "NC"
+ itemList1?: string | null
+ itemList2?: string | null
+ itemList3?: string | null
+ itemList4?: string | null
+}
+
|