// /api/attachment-delete/route.ts

import { NextRequest, NextResponse } from 'next/server'
import db from '@/db/db'
import { documentAttachments, changeLogs } from '@/db/schema'
import { eq, and } from 'drizzle-orm'
import { getServerSession } from 'next-auth';
import { authOptions } from '@/app/api/auth/[...nextauth]/route';

export async function DELETE(request: NextRequest) {
  try {

    const session = await getServerSession(authOptions);
    if (!session?.user?.id) {
      return NextResponse.json(
        { error: '인증이 필요합니다' },
        { status: 401 }
      );
    }

    const { attachmentId, revisionId } = await request.json()

    if (!attachmentId || !revisionId) {
      return NextResponse.json(
        { error: 'attachmentId and revisionId are required' },
        { status: 400 }
      )
    }

    // 1. 데이터베이스에서 첨부파일 정보 조회
    const attachment = await db
      .select()
      .from(documentAttachments)
      .where(
        and(
          eq(documentAttachments.id, attachmentId),
          eq(documentAttachments.revisionId, revisionId)
        )
      )
      .limit(1)

    if (!attachment || attachment.length === 0) {
      return NextResponse.json(
        { error: 'Attachment not found' },
        { status: 404 }
      )
    }

    const attachmentData = attachment[0]

    // 2. dolceFilePath 체크 - 있으면 삭제 불가
    if (attachmentData.dolceFilePath && attachmentData.dolceFilePath.trim() !== '') {
      return NextResponse.json(
        { error: 'Cannot delete processed file' },
        { status: 403 }
      )
    }

    // 3. 트랜잭션으로 첨부파일과 changeLogs 함께 삭제
    await db.transaction(async (tx) => {
      // 3-1. changeLogs에서 해당 attachment 관련 로그 삭제
      await tx
        .delete(changeLogs)
        .where(
          and(
            eq(changeLogs.entityType, 'attachment'),
            eq(changeLogs.entityId, attachmentId)
          )
        )

      // 3-2. 첨부파일 레코드 삭제
      await tx
        .delete(documentAttachments)
        .where(
          and(
            eq(documentAttachments.id, attachmentId),
            eq(documentAttachments.revisionId, revisionId)
          )
        )
    })

    return NextResponse.json({
      success: true,
      message: 'Attachment and related logs deleted successfully',
      deletedAttachmentId: attachmentId
    })

  } catch (error) {
    console.error('Attachment deletion error:', error)
    return NextResponse.json(
      { 
        error: 'Internal server error',
        details: error instanceof Error ? error.message : 'Unknown error'
      },
      { status: 500 }
    )
  }
}