(김준회) AVL 피드백 반영 (이진용 프로 건)

1 files changed, 17 insertions, 0 deletions

diff --git a/components/common/selectors/place-of-shipping/place-of-shipping-service.tsx b/components/common/selectors/place-of-shipping/place-of-shipping-service.tsx
new file mode 100644
index 00000000..22026739
--- /dev/null
+++ b/components/common/selectors/place-of-shipping/place-of-shipping-service.tsx
@@ -0,0 +1,17 @@
+'use server'
+
+import db from "@/db/db"
+import { placeOfShipping } from "@/db/schema"
+import { eq } from "drizzle-orm"
+
+
+/**
+ * @returns 활성화된 모든 선적지/하역지 코드 및 장소명
+ */
+export async function getPlaceOfShippingForSelection(): Promise<{ code: string; description: string }[]> {
+  const data = await db.select().from(placeOfShipping).where(eq(placeOfShipping.isActive, true)).orderBy(placeOfShipping.code)
+  return data.map((item) => ({
+    code: item.code,
+    description: item.description
+  }))
+}
\ No newline at end of file