1 files changed, 17 insertions, 15 deletions
diff --git a/lib/forms-plant/stat.ts b/lib/forms-plant/stat.ts
index f13bab61..f734e782 100644
--- a/lib/forms-plant/stat.ts
+++ b/lib/forms-plant/stat.ts
@@ -1,7 +1,7 @@
 "use server"
 
 import db from "@/db/db"
-import { vendors, contracts, contractItems, forms, formEntries, formMetas, tags, tagClasses, tagClassAttributes, projects } from "@/db/schema"
+import { vendors, contracts, contractItems, forms,formsPlant,formEntriesPlant, formEntries, formMetas, tags,tagsPlant, tagClasses, tagClassAttributes, projects } from "@/db/schema"
 import { eq, and, inArray } from "drizzle-orm"
 import { getEditableFieldsByTag } from "./services"
 import { getServerSession } from "next-auth/next"
@@ -218,7 +218,7 @@ export async function getVendorFormStatus(projectId?: number): Promise<VendorFor
 
 
 
-export async function getFormStatusByVendor(projectId: number, contractItemId: number, formCode: string): Promise<FormStatusByVendor[]> {
+export async function getFormStatusByVendor(projectId: number, projectCode: string, packageCode: string, formCode: string): Promise<FormStatusByVendor[]> {
   try {
     const session = await getServerSession(authOptions)
     if (!session?.user?.id) {
@@ -244,15 +244,16 @@ export async function getFormStatusByVendor(projectId: number, contractItemId: n
     // 4. contractItem별 forms 조회
     const formsList = await db
       .select({
-        id: forms.id,
-        formCode: forms.formCode,
-        contractItemId: forms.contractItemId
+        id: formsPlant.id,
+        formCode: formsPlant.formCode,
+        contractItemId: formsPlant.contractItemId
       })
-      .from(forms)
+      .from(formsPlant)
       .where(
         and(
-          eq(forms.contractItemId, contractItemId),
-          eq(forms.formCode, formCode)
+          eq(formsPlant.projectCode, projectCode),
+          eq(formsPlant.packageCode, packageCode),
+          eq(formsPlant.formCode, formCode)
         )
       )
 
@@ -261,20 +262,21 @@ export async function getFormStatusByVendor(projectId: number, contractItemId: n
     // 5. formEntries 조회
     const entriesList = await db
       .select({
-        id: formEntries.id,
-        formCode: formEntries.formCode,
-        data: formEntries.data
+        id: formEntriesPlant.id,
+        formCode: formEntriesPlant.formCode,
+        data: formEntriesPlant.data
       })
-      .from(formEntries)
+      .from(formEntriesPlant)
       .where(
         and(
-          eq(formEntries.contractItemId, contractItemId),
-          eq(formEntries.formCode, formCode)
+          eq(formEntriesPlant.packageCode, packageCode),
+          eq(formEntriesPlant.projectCode, projectCode),
+          eq(formEntriesPlant.formCode, formCode)
         )
       )
 
     // 6. TAG별 편집 가능 필드 조회
-    const editableFieldsByTag = await getEditableFieldsByTag(contractItemId, projectId)
+    const editableFieldsByTag = await getEditableFieldsByTag(projectCode,packageCode, projectId)
 
     const vendorStatusList: VendorFormStatus[] = []