(대표님) 벤더 문서 변경사항, data-table 변경, sync 변경

1 files changed, 9 insertions, 7 deletions

diff --git a/app/api/revision-attachment/route.ts b/app/api/revision-attachment/route.ts
index 12834085..092eed8d 100644
--- a/app/api/revision-attachment/route.ts
+++ b/app/api/revision-attachment/route.ts
@@ -10,6 +10,7 @@ import {
   documents,
   revisions,
   documentAttachments,
+  issueStages,
 } from "@/db/schema/vendorDocu"
 import { eq } from "drizzle-orm"
 
@@ -50,10 +51,11 @@ export async function POST(request: NextRequest) {
         usage: revisions.usage,
         usageType: revisions.usageType,
         issueStageId: revisions.issueStageId,
-        contractId: documents.contractId,
+        projectId: documents.projectId,
       })
       .from(revisions)
-      .leftJoin(documents, eq(documents.id, revisions.issueStageId))
+      .innerJoin(issueStages, eq(revisions.issueStageId, issueStages.id))
+      .innerJoin(documents, eq(issueStages.documentId, documents.id))
       .where(eq(revisions.id, revisionId))
       .limit(1)
 
@@ -95,7 +97,7 @@ export async function POST(request: NextRequest) {
 
         // change_logs: attachment CREATE
         await logAttachmentChange(
-          revisionInfo.contractId,
+          revisionInfo.projectId,
           att.id,
           "CREATE",
           att,
@@ -117,16 +119,16 @@ export async function POST(request: NextRequest) {
         usage: revisionInfo.usage,
         usageType: revisionInfo.usageType,
         uploadedFiles,
-        contractId: revisionInfo.contractId
+        projectId: revisionInfo.projectId
       }
     })
 
     // 캐시 무효화
     try {
-    //   revalidateTag(`enhanced-documents-${result.contractId}`)
-      revalidateTag(`sync-status-${result.contractId}`)
+    //   revalidateTag(`enhanced-documents-${result.projectId}`)
+      revalidateTag(`sync-status-${result.projectId}`)
       
-      console.log(`✅ Cache invalidated for contract ${result.contractId}`)
+      console.log(`✅ Cache invalidated for contract ${result.projectId}`)
     } catch (cacheError) {
       console.warn('⚠️ Cache invalidation failed:', cacheError)
     }