1 files changed, 155 insertions, 0 deletions
diff --git a/lib/items-tech/service.ts b/lib/items-tech/service.ts
index 70c664f3..ee2c718d 100644
--- a/lib/items-tech/service.ts
+++ b/lib/items-tech/service.ts
@@ -1008,3 +1008,158 @@ export async function getAllOffshoreItems(): Promise<(ItemOffshoreHull | ItemOff
     throw new Error("Failed to get items");
   }
 }
+
+
+// -----------------------------------------------------------
+//                    기술영업을 위한 로직
+// -----------------------------------------------------------
+
+// 조선 공종 타입
+export type WorkType = '기장' | '전장' | '선실' | '배관' | '철의'
+
+// 조선 아이템 with 공종 정보
+export interface ShipbuildingItem {
+  id: number
+  itemCode: string
+  itemName: string
+  description: string | null
+  workType: WorkType
+  itemList: string | null // 실제 아이템명
+  shipTypes: string
+  createdAt: Date
+  updatedAt: Date
+}
+
+// 공종별 아이템 조회
+export async function getShipbuildingItemsByWorkType(workType?: WorkType) {
+  try {
+    const query = db
+      .select({
+        id: itemShipbuilding.id,
+        itemCode: itemShipbuilding.itemCode,
+        itemName: items.itemName,
+        description: items.description,
+        workType: itemShipbuilding.workType,
+        itemList: itemShipbuilding.itemList,
+        shipTypes: itemShipbuilding.shipTypes,
+        createdAt: itemShipbuilding.createdAt,
+        updatedAt: itemShipbuilding.updatedAt,
+      })
+      .from(itemShipbuilding)
+      .leftJoin(items, eq(itemShipbuilding.itemCode, items.itemCode))
+
+    if (workType) {
+      query.where(eq(itemShipbuilding.workType, workType))
+    }
+
+    const result = await query
+
+    return {
+      data: result as ShipbuildingItem[],
+      error: null
+    }
+  } catch (error) {
+    console.error("조선 아이템 조회 오류:", error)
+    return {
+      data: null,
+      error: error instanceof Error ? error.message : "알 수 없는 오류"
+    }
+  }
+}
+
+// 아이템 검색
+export async function searchShipbuildingItems(searchQuery: string, workType?: WorkType) {
+  try {
+    const searchConditions = [
+      ilike(itemShipbuilding.itemCode, `%${searchQuery}%`),
+      ilike(items.itemName, `%${searchQuery}%`),
+      ilike(items.description, `%${searchQuery}%`),
+      ilike(itemShipbuilding.itemList, `%${searchQuery}%`)
+    ]
+
+    let whereCondition = or(...searchConditions)
+
+    if (workType) {
+      whereCondition = and(
+        eq(itemShipbuilding.workType, workType),
+        or(...searchConditions)
+      )
+    }
+
+    const result = await db
+      .select({
+        id: itemShipbuilding.id,
+        itemCode: itemShipbuilding.itemCode,
+        itemName: items.itemName,
+        description: items.description,
+        workType: itemShipbuilding.workType,
+        itemList: itemShipbuilding.itemList,
+        shipTypes: itemShipbuilding.shipTypes,
+        createdAt: itemShipbuilding.createdAt,
+        updatedAt: itemShipbuilding.updatedAt,
+      })
+      .from(itemShipbuilding)
+      .leftJoin(items, eq(itemShipbuilding.itemCode, items.itemCode))
+      .where(whereCondition)
+
+    return {
+      data: result as ShipbuildingItem[],
+      error: null
+    }
+  } catch (error) {
+    console.error("조선 아이템 검색 오류:", error)
+    return {
+      data: null,
+      error: error instanceof Error ? error.message : "알 수 없는 오류"
+    }
+  }
+}
+
+// 모든 공종 목록 조회
+export async function getWorkTypes() {
+  return [
+    { code: '기장' as WorkType, name: '기장품', description: '기계 장치 및 엔진' },
+    { code: '전장' as WorkType, name: '전장품', description: '전기 장치 및 제어 시스템' },
+    { code: '선실' as WorkType, name: '선실품', description: '선실 및 거주 구역' },
+    { code: '배관' as WorkType, name: '배관품', description: '배관 및 파이프 시스템' },
+    { code: '철의' as WorkType, name: '철의품', description: '선체 구조물 및 강재' },
+  ]
+}
+
+// 특정 아이템 코드들로 아이템 조회
+export async function getShipbuildingItemsByCodes(itemCodes: string[]) {
+  try {
+    const result = await db
+      .select({
+        id: itemShipbuilding.id,
+        itemCode: itemShipbuilding.itemCode,
+        itemName: items.itemName,
+        description: items.description,
+        workType: itemShipbuilding.workType,
+        itemList: itemShipbuilding.itemList,
+        shipTypes: itemShipbuilding.shipTypes,
+        createdAt: itemShipbuilding.createdAt,
+        updatedAt: itemShipbuilding.updatedAt,
+      })
+      .from(itemShipbuilding)
+      .leftJoin(items, eq(itemShipbuilding.itemCode, items.itemCode))
+      .where(
+        or(...itemCodes.map(code => eq(itemShipbuilding.itemCode, code)))
+      )
+
+    return {
+      data: result as ShipbuildingItem[],
+      error: null
+    }
+  } catch (error) {
+    console.error("조선 아이템 코드별 조회 오류:", error)
+    return {
+      data: null,
+      error: error instanceof Error ? error.message : "알 수 없는 오류"
+    }
+  }
+}
+
+// -----------------------------------------------------------
+//                    기술영업을 위한 로직 끝
+// -----------------------------------------------------------
+\ No newline at end of file