From cf8dac0c6490469dab88a560004b0c07dbd48612 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Thu, 18 Sep 2025 00:23:40 +0000
Subject: (대표님) rfq, 계약, 서명 등
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/items/service.ts | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

(limited to 'lib/items')

diff --git a/lib/items/service.ts b/lib/items/service.ts
index 1eab3e25..f4865cfa 100644
--- a/lib/items/service.ts
+++ b/lib/items/service.ts
@@ -457,3 +457,35 @@ export async function searchItemsForPQ(query: string): Promise<{ itemCode: strin
     return [];
   }
 }
+
+
+export interface PackageItem {
+  packageCode: string;
+  description: string;
+  smCode: string | null;
+}
+
+export async function getPackagesByProject(projectNo: string): Promise<PackageItem[]> {
+  try {
+    // selectDistinct를 사용하여 중복 제거
+    const result = await db
+      .selectDistinct({
+        packageCode: items.packageCode,
+        description: items.description,
+        smCode: items.smCode,
+      })
+      .from(items)
+      .where(eq(items.ProjectNo, projectNo))
+      .orderBy(items.packageCode);
+
+    // null 값을 처리하고 타입을 정리
+    return result.map(item => ({
+      packageCode: item.packageCode,
+      description: item.description || item.packageCode,
+      smCode: item.smCode || null
+    }));
+  } catch (error) {
+    console.error("Failed to fetch packages:", error);
+    return [];
+  }
+}
\ No newline at end of file
-- 
cgit v1.2.3