'use server'

import db from "@/db/db"
import {
    incoterms, placeOfShipping, paymentTerms
} from "@/db/schema"
import { eq } from "drizzle-orm"

export async function getIncotermsForSelection() {
    try {
        const data = await db
            .select({
                code: incoterms.code,
                description: incoterms.description,
            })
            .from(incoterms)
            .where(eq(incoterms.isActive, true))
            .orderBy(incoterms.code)

        return data

    } catch (error) {
        console.error("Error fetching incoterms:", error)
        throw new Error("Failed to fetch incoterms")
    }
}


export async function getPaymentTermsForSelection() {
    try {
        const data = await db
            .select({
                code: paymentTerms.code,
                description: paymentTerms.description,
            })
            .from(paymentTerms)
            .where(eq(paymentTerms.isActive, true))
            .orderBy(paymentTerms.code)

        return data

    } catch (error) {
        console.error("Error fetching paymentTerms:", error)
        throw new Error("Failed to fetch paymentTerms")
    }
}


export async function getPlaceOfShippingForSelection() {
    try {
        const data = await db
            .select({
                code: placeOfShipping.code,
                description: placeOfShipping.description,
            })
            .from(placeOfShipping)
            .where(eq(placeOfShipping.isActive, true))
            .orderBy(placeOfShipping.code)

        return data

    } catch (error) {
        console.error("Error fetching placeOfShipping:", error)
        throw new Error("Failed to fetch placeOfShipping")
    }
}

export async function getPlaceOfDestinationForSelection() {
    try {
        const data = await db
            .select({
                code: placeOfShipping.code,
                description: placeOfShipping.description,
            })
            .from(placeOfShipping)
            .where(eq(placeOfShipping.isActive, true))
            .orderBy(placeOfShipping.code)

        return data

    } catch (error) {
        console.error("Error fetching placeOfShipping:", error)
        throw new Error("Failed to fetch placeOfShipping")
    }
}