diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-10-23 04:46:56 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-10-23 04:46:56 +0000 |
| commit | b83f22dcd593c80f0feadc3b3703aab30da296c5 (patch) | |
| tree | c899a97b643932f033be1fce744e01e2fd900bd9 /lib/owner-companies/service.ts | |
| parent | b41ec18c5a40357e71d2c79c89d7baabe33fed79 (diff) | |
(김기만) 데이터룸 발주처 목록 수정
Diffstat (limited to 'lib/owner-companies/service.ts')
| -rw-r--r-- | lib/owner-companies/service.ts | 27 |
1 files changed, 25 insertions, 2 deletions
diff --git a/lib/owner-companies/service.ts b/lib/owner-companies/service.ts index 2f3e914f..1242e603 100644 --- a/lib/owner-companies/service.ts +++ b/lib/owner-companies/service.ts @@ -1,9 +1,12 @@ // lib/owner-companies/service.ts "use server"; +// export const dynamic = "force-dynamic"; +// export const runtime = "nodejs"; + import db from "@/db/db"; import { ownerCompanies, users } from "@/db/schema"; -import { revalidatePath } from "next/cache"; +import { revalidatePath, unstable_noStore } from "next/cache"; import { eq } from "drizzle-orm"; export async function createOwnerCompany(data: { name: string }) { @@ -73,5 +76,25 @@ export async function getOwnerCompanyUsers(companyId: number) { return await db .select() .from(users) - .where(eq(users.ownerCompanyId, companyId)); + .where(eq(users.ownerCompanyId, companyId)) + .orderBy(users.createdAt); +} + +export const getOwnerCompanyList = async() => { + unstable_noStore() + + const companies = await db.select().from(ownerCompanies).orderBy(ownerCompanies.createdAt); + + return comcompanies +} + + +export const getTargetOwnerCompany = async(companyId:number) => { + const [company] = await db + .select() + .from(ownerCompanies) + .where(eq(ownerCompanies.id, companyId)) + .limit(1); + + return company }
\ No newline at end of file |
