'use server'

import db from '@/db/db'
import {
    biddings,
    biddingListView,
    biddingNoticeTemplate,
    projects,
    biddingDocuments,
    prItemsForBidding,
    specificationMeetings
} from '@/db/schema'
import {
    eq,
    desc,
    asc,
    and,
    or,
    count,
    sql,
    ilike,
    gte,
    lte,
    SQL
} from 'drizzle-orm'
import { revalidatePath } from 'next/cache'
import { BiddingListItem } from '@/db/schema'
import { filterColumns } from '@/lib/filter-columns'
import { CreateBiddingSchema, GetBiddingsSchema, UpdateBiddingSchema } from './validation'
import { saveFile } from '../file-stroage'


export async function getBiddingNoticeTemplate() {
    try {
        const result = await db
            .select()
            .from(biddingNoticeTemplate)
            .where(eq(biddingNoticeTemplate.type, 'standard'))
            .limit(1)

        return result[0] || null
    } catch (error) {
        console.error('Failed to get bidding notice template:', error)
        throw new Error('입찰공고문 템플릿을 불러오는데 실패했습니다.')
    }
}

export async function saveBiddingNoticeTemplate(formData: {
    title: string
    content: string
}) {
    try {
        const { title, content } = formData

        // 기존 템플릿 확인
        const existing = await db
            .select()
            .from(biddingNoticeTemplate)
            .where(eq(biddingNoticeTemplate.type, 'standard'))
            .limit(1)

        if (existing.length > 0) {
            // 업데이트
            await db
                .update(biddingNoticeTemplate)
                .set({
                    title,
                    content,
                    updatedAt: new Date(),
                })
                .where(eq(biddingNoticeTemplate.type, 'standard'))
        } else {
            // 새로 생성
            await db.insert(biddingNoticeTemplate).values({
                type: 'standard',
                title,
                content,
            })
        }

        revalidatePath('/admin/bidding-notice')
        return { success: true, message: '입찰공고문 템플릿이 저장되었습니다.' }
    } catch (error) {
        console.error('Failed to save bidding notice template:', error)
        throw new Error('입찰공고문 템플릿 저장에 실패했습니다.')
    }
}


export async function getBiddings(input: GetBiddingsSchema) {
    try {
        const offset = (input.page - 1) * input.perPage

        // ✅ 1) 고급 필터 조건
        let advancedWhere: SQL<unknown> | undefined = undefined
        if (input.filters && input.filters.length > 0) {
            advancedWhere = filterColumns({
                table: biddingListView,
                filters: input.filters,
                joinOperator: input.joinOperator || 'and',
            })
        }

        // ✅ 2) 기본 필터 조건들
        const basicConditions: SQL<unknown>[] = []

        if (input.biddingNumber) {
            basicConditions.push(ilike(biddingListView.biddingNumber, `%${input.biddingNumber}%`))
        }

        if (input.status && input.status.length > 0) {
            basicConditions.push(
                or(...input.status.map(status => eq(biddingListView.status, status)))!
            )
        }

        if (input.biddingType && input.biddingType.length > 0) {
            basicConditions.push(
                or(...input.biddingType.map(type => eq(biddingListView.biddingType, type)))!
            )
        }

        if (input.contractType && input.contractType.length > 0) {
            basicConditions.push(
                or(...input.contractType.map(type => eq(biddingListView.contractType, type)))!
            )
        }

        if (input.managerName) {
            basicConditions.push(ilike(biddingListView.managerName, `%${input.managerName}%`))
        }

        // 날짜 필터들
        if (input.preQuoteDateFrom) {
            basicConditions.push(gte(biddingListView.preQuoteDate, input.preQuoteDateFrom))
        }
        if (input.preQuoteDateTo) {
            basicConditions.push(lte(biddingListView.preQuoteDate, input.preQuoteDateTo))
        }

        if (input.submissionDateFrom) {
            basicConditions.push(gte(biddingListView.submissionStartDate, input.submissionDateFrom))
        }
        if (input.submissionDateTo) {
            basicConditions.push(lte(biddingListView.submissionEndDate, input.submissionDateTo))
        }

        if (input.createdAtFrom) {
            basicConditions.push(gte(biddingListView.createdAt, input.createdAtFrom))
        }
        if (input.createdAtTo) {
            basicConditions.push(lte(biddingListView.createdAt, input.createdAtTo))
        }

        // 가격 범위 필터
        if (input.budgetMin) {
            basicConditions.push(gte(biddingListView.budget, input.budgetMin))
        }
        if (input.budgetMax) {
            basicConditions.push(lte(biddingListView.budget, input.budgetMax))
        }

        // Boolean 필터
        if (input.hasSpecificationMeeting === "true") {
            basicConditions.push(eq(biddingListView.hasSpecificationMeeting, true))
        } else if (input.hasSpecificationMeeting === "false") {
            basicConditions.push(eq(biddingListView.hasSpecificationMeeting, false))
        }

        if (input.hasPrDocument === "true") {
            basicConditions.push(eq(biddingListView.hasPrDocument, true))
        } else if (input.hasPrDocument === "false") {
            basicConditions.push(eq(biddingListView.hasPrDocument, false))
        }

        const basicWhere = basicConditions.length > 0 ? and(...basicConditions) : undefined

        // ✅ 3) 글로벌 검색 조건
        let globalWhere: SQL<unknown> | undefined = undefined
        if (input.search) {
            const s = `%${input.search}%`
            const searchConditions = [
                ilike(biddingListView.biddingNumber, s),
                ilike(biddingListView.title, s),
                ilike(biddingListView.projectName, s),
                ilike(biddingListView.itemName, s),
                ilike(biddingListView.managerName, s),
                ilike(biddingListView.prNumber, s),
                ilike(biddingListView.remarks, s),
            ]
            globalWhere = or(...searchConditions)
        }

        // ✅ 4) 최종 WHERE 조건
        const whereConditions: SQL<unknown>[] = []
        if (advancedWhere) whereConditions.push(advancedWhere)
        if (basicWhere) whereConditions.push(basicWhere)
        if (globalWhere) whereConditions.push(globalWhere)

        const finalWhere = whereConditions.length > 0 ? and(...whereConditions) : undefined

        // ✅ 5) 전체 개수 조회
        const totalResult = await db
            .select({ count: count() })
            .from(biddingListView)
            .where(finalWhere)

        const total = totalResult[0]?.count || 0

        if (total === 0) {
            return { data: [], pageCount: 0, total: 0 }
        }

        console.log("Total biddings:", total)

        // ✅ 6) 정렬 및 페이징
        const orderByColumns = input.sort.map((sort) => {
            const column = sort.id as keyof typeof biddingListView.$inferSelect
            return sort.desc ? desc(biddingListView[column]) : asc(biddingListView[column])
        })

        if (orderByColumns.length === 0) {
            orderByColumns.push(desc(biddingListView.createdAt))
        }

        // ✅ 7) 메인 쿼리 - 매우 간단해짐!
        const data = await db
            .select()
            .from(biddingListView)
            .where(finalWhere)
            .orderBy(...orderByColumns)
            .limit(input.perPage)
            .offset(offset)

        const pageCount = Math.ceil(total / input.perPage)

        // ✅ 8) 포맷팅 불필요 - 뷰에서 이미 완성된 데이터!
        return { data, pageCount, total }

    } catch (err) {
        console.error("Error in getBiddings:", err)
        return { data: [], pageCount: 0, total: 0 }
    }
}
// 상태별 개수 집계
export async function getBiddingStatusCounts() {
    try {
        const counts = await db
            .select({
                status: biddings.status,
                count: count(),
            })
            .from(biddings)
            .groupBy(biddings.status)

        return counts.reduce((acc, { status, count }) => {
            acc[status] = count
            return acc
        }, {} as Record<string, number>)
    } catch (error) {
        console.error('Failed to get bidding status counts:', error)
        return {}
    }
}

// 입찰유형별 개수 집계
export async function getBiddingTypeCounts() {
    try {
        const counts = await db
            .select({
                biddingType: biddings.biddingType,
                count: count(),
            })
            .from(biddings)
            .groupBy(biddings.biddingType)

        return counts.reduce((acc, { biddingType, count }) => {
            acc[biddingType] = count
            return acc
        }, {} as Record<string, number>)
    } catch (error) {
        console.error('Failed to get bidding type counts:', error)
        return {}
    }
}

// 담당자별 개수 집계
export async function getBiddingManagerCounts() {
    try {
        const counts = await db
            .select({
                managerName: biddings.managerName,
                count: count(),
            })
            .from(biddings)
            .where(sql`${biddings.managerName} IS NOT NULL AND ${biddings.managerName} != ''`)
            .groupBy(biddings.managerName)

        return counts.reduce((acc, { managerName, count }) => {
            if (managerName) {
                acc[managerName] = count
            }
            return acc
        }, {} as Record<string, number>)
    } catch (error) {
        console.error('Failed to get bidding manager counts:', error)
        return {}
    }
}

// 월별 입찰 생성 통계
export async function getBiddingMonthlyStats(year: number = new Date().getFullYear()) {
    try {
        const stats = await db
            .select({
                month: sql<number>`EXTRACT(MONTH FROM ${biddings.createdAt})`.as('month'),
                count: count(),
            })
            .from(biddings)
            .where(sql`EXTRACT(YEAR FROM ${biddings.createdAt}) = ${year}`)
            .groupBy(sql`EXTRACT(MONTH FROM ${biddings.createdAt})`)
            .orderBy(sql`EXTRACT(MONTH FROM ${biddings.createdAt})`)

        // 1-12월 전체 배열 생성 (없는 월은 0으로)
        const monthlyData = Array.from({ length: 12 }, (_, i) => {
            const month = i + 1
            const found = stats.find(stat => stat.month === month)
            return {
                month,
                count: found?.count || 0,
            }
        })

        return monthlyData
    } catch (error) {
        console.error('Failed to get bidding monthly stats:', error)
        return []
    }
}

export interface CreateBiddingInput extends CreateBiddingSchema {
    // 사양설명회 정보 (선택사항)
    specificationMeeting?: {
      meetingDate: string
      meetingTime: string
      location: string
      address: string
      contactPerson: string
      contactPhone: string
      contactEmail: string
      agenda: string
      materials: string
      notes: string
      isRequired: boolean
    } | null
  
    // PR 아이템들 (선택사항)
    prItemsForBidding?: Array<{
      itemNumber: string
      projectInfo: string
      itemInfo: string
      shi: string
      requestedDeliveryDate: string
      annualUnitPrice: string
      currency: string
      quantity: string
      quantityUnit: string
      totalWeight: string
      weightUnit: string
      materialDescription: string
      prNumber: string
      specFiles: File[]
    }>
  }

export interface UpdateBiddingInput extends UpdateBiddingSchema {
  id: number
}

// 자동 입찰번호 생성
async function generateBiddingNumber(biddingType: string): Promise<string> {
  const year = new Date().getFullYear()
  const typePrefix = {
    'equipment': 'EQ',
    'construction': 'CT', 
    'service': 'SV',
    'lease': 'LS',
    'steel_stock': 'SS',
    'piping': 'PP',
    'transport': 'TP',
    'waste': 'WS',
    'sale': 'SL'
  }[biddingType] || 'GN'

  // 해당 연도의 마지막 번호 조회
  const lastBidding = await db
    .select({ biddingNumber: biddings.biddingNumber })
    .from(biddings)
    .where(eq(biddings.biddingNumber, `${year}${typePrefix}%`))
    .orderBy(biddings.biddingNumber)
    .limit(1)

  let sequence = 1
  if (lastBidding.length > 0) {
    const lastNumber = lastBidding[0].biddingNumber
    const lastSequence = parseInt(lastNumber.slice(-4))
    sequence = lastSequence + 1
  }

  return `${year}${typePrefix}${sequence.toString().padStart(4, '0')}`
}

// 입찰 생성
export async function createBidding(input: CreateBiddingInput, userId: string) {
    try {
      return await db.transaction(async (tx) => {
        // 자동 입찰번호 생성
        const biddingNumber = await generateBiddingNumber(input.biddingType)
  
        // 프로젝트 정보 조회
        let projectName = input.projectName
        if (input.projectId && !projectName) {
          const project = await tx
            .select({ code: projects.code, name: projects.name })
            .from(projects)
            .where(eq(projects.id, input.projectId))
            .limit(1)
          
          if (project.length > 0) {
            projectName = `${project[0].code} (${project[0].name})`
          }
        }
  
        // 표준 공고문 템플릿 가져오기
        let standardContent = ''
        if (!input.content) {
          try {
            const template = await tx
              .select({ content: biddingNoticeTemplate.content })
              .from(biddingNoticeTemplate)
              .where(eq(biddingNoticeTemplate.type, 'standard'))
              .limit(1)
            
            if (template.length > 0) {
              standardContent = template[0].content
            }
          } catch (error) {
            console.warn('Failed to load standard template:', error)
          }
        }
  
        // 날짜 변환 함수
        const parseDate = (dateStr?: string) => {
          if (!dateStr) return null
          try {
            return new Date(dateStr)
          } catch {
            return null
          }
        }
  
        // 1. 입찰 생성
        const [newBidding] = await tx
          .insert(biddings)
          .values({
            biddingNumber,
            revision: input.revision || 0,
            
            // 프로젝트 정보
            projectId: input.projectId,
            projectName,
            
            itemName: input.itemName,
            title: input.title,
            description: input.description,
            content: input.content || standardContent,
            
            contractType: input.contractType,
            biddingType: input.biddingType,
            awardCount: input.awardCount,
            contractPeriod: input.contractPeriod,
            
            // 자동 등록일 설정
            biddingRegistrationDate: new Date(),
            submissionStartDate: parseDate(input.submissionStartDate),
            submissionEndDate: parseDate(input.submissionEndDate),
            evaluationDate: parseDate(input.evaluationDate),
            
            hasSpecificationMeeting: input.hasSpecificationMeeting || false,
            hasPrDocument: input.hasPrDocument || false,
            prNumber: input.prNumber,
            
            currency: input.currency,
            budget: input.budget ? parseFloat(input.budget) : null,
            targetPrice: input.targetPrice ? parseFloat(input.targetPrice) : null,
            finalBidPrice: input.finalBidPrice ? parseFloat(input.finalBidPrice) : null,
            
            status: input.status || 'bidding_generated',
            isPublic: input.isPublic || false,
            managerName: input.managerName,
            managerEmail: input.managerEmail,
            managerPhone: input.managerPhone,
            
            remarks: input.remarks,
            createdBy: userId,
            updatedBy: userId,
          })
          .returning({ id: biddings.id })
  
        const biddingId = newBidding.id
  
        // 2. 사양설명회 정보 저장 (있는 경우)
        if (input.specificationMeeting) {
          const [newSpecMeeting] = await tx
            .insert(specificationMeetings)
            .values({
              biddingId,
              meetingDate: new Date(input.specificationMeeting.meetingDate),
              meetingTime: input.specificationMeeting.meetingTime,
              location: input.specificationMeeting.location,
              address: input.specificationMeeting.address,
              contactPerson: input.specificationMeeting.contactPerson,
              contactPhone: input.specificationMeeting.contactPhone,
              contactEmail: input.specificationMeeting.contactEmail,
              agenda: input.specificationMeeting.agenda,
              materials: input.specificationMeeting.materials,
              notes: input.specificationMeeting.notes,
              isRequired: input.specificationMeeting.isRequired,
            })
            .returning({ id: specificationMeetings.id })
  
          // 2-1. 사양설명회 첨부파일 저장
          if (input.specificationMeeting.meetingFiles && input.specificationMeeting.meetingFiles.length > 0) {
            for (const file of input.specificationMeeting.meetingFiles) {
              try {
                const saveResult = await saveFile({
                  file,
                  directory: `biddings/${biddingId}/specification-meeting`,
                  originalName: file.name,
                  userId
                })
  
                if (saveResult.success) {
                  await tx.insert(biddingDocuments).values({
                    biddingId,
                    specificationMeetingId: newSpecMeeting.id,
                    documentType: 'specification_meeting',
                    fileName: saveResult.fileName!,
                    originalFileName: saveResult.originalName!,
                    fileSize: saveResult.fileSize!,
                    mimeType: file.type,
                    filePath: saveResult.filePath!,
                    publicPath: saveResult.publicPath,
                    title: `사양설명회 - ${file.name}`,
                    isPublic: false,
                    isRequired: false,
                    uploadedBy: userId,
                  })
                } else {
                  console.error(`Failed to save specification meeting file: ${file.name}`, saveResult.error)
                  // 파일 저장 실패해도 전체 트랜잭션은 계속 진행
                }
              } catch (error) {
                console.error(`Error saving specification meeting file: ${file.name}`, error)
              }
            }
          }
        }
  
        // 3. PR 아이템들 저장 (있는 경우)
        if (input.prItems && input.prItems.length > 0) {
          for (const prItem of input.prItems) {
            // PR 아이템 저장
            const [newPrItem] = await tx.insert(prItemsForBidding).values({
              biddingId,
              itemNumber: prItem.itemCode, // itemCode를 itemNumber로 매핑
              projectInfo: '', // 필요시 추가
              itemInfo: prItem.itemInfo,
              shi: '', // 필요시 추가
              requestedDeliveryDate: prItem.requestedDeliveryDate ? new Date(prItem.requestedDeliveryDate) : null,
              annualUnitPrice: null, // 필요시 추가
              currency: 'KRW', // 기본값 또는 입력받은 값
              quantity: prItem.quantity ? parseFloat(prItem.quantity) : null,
              quantityUnit: prItem.quantityUnit as any, // enum 타입에 맞게
              totalWeight: null, // 필요시 추가
              weightUnit: null, // 필요시 추가
              materialDescription: '', // 필요시 추가
              prNumber: prItem.prNumber,
              hasSpecDocument: prItem.specFiles.length > 0,
              isRepresentative: prItem.isRepresentative,
            }).returning({ id: prItemsForBidding.id })
  
            // 3-1. 스펙 파일들 저장 (있는 경우)
            if (prItem.specFiles.length > 0) {
              for (let fileIndex = 0; fileIndex < prItem.specFiles.length; fileIndex++) {
                const file = prItem.specFiles[fileIndex]
                try {
                  const saveResult = await saveFile({
                    file,
                    directory: `biddings/${biddingId}/pr-items/${newPrItem.id}/specs`,
                    originalName: file.name,
                    userId
                  })
  
                  if (saveResult.success) {
                    await tx.insert(biddingDocuments).values({
                      biddingId,
                      prItemId: newPrItem.id,
                      documentType: 'spec',
                      fileName: saveResult.fileName!,
                      originalFileName: saveResult.originalName!,
                      fileSize: saveResult.fileSize!,
                      mimeType: file.type,
                      filePath: saveResult.filePath!,
                      publicPath: saveResult.publicPath,
                      title: `${prItem.itemInfo || prItem.itemCode} 스펙 - ${file.name}`,
                      description: `PR ${prItem.prNumber}의 스펙 문서`,
                      isPublic: false,
                      isRequired: false,
                      uploadedBy: userId,
                      displayOrder: fileIndex + 1,
                    })
                  } else {
                    console.error(`Failed to save spec file: ${file.name}`, saveResult.error)
                    // 파일 저장 실패해도 전체 트랜잭션은 계속 진행
                  }
                } catch (error) {
                  console.error(`Error saving spec file: ${file.name}`, error)
                }
              }
            }
          }
        }
  
        // 캐시 무효화
        revalidatePath('/evcp/bid')
  
        return {
          success: true,
          message: '입찰이 성공적으로 생성되었습니다.',
          data: { id: biddingId, biddingNumber }
        }
      })
    } catch (error) {
      console.error('Error creating bidding:', error)
      return {
        success: false,
        error: error instanceof Error ? error.message : '입찰 생성 중 오류가 발생했습니다.'
      }
    }
  }
// 입찰 수정
export async function updateBidding(input: UpdateBiddingInput, userId: string) {
  try {
    // 존재 여부 확인
    const existing = await db
      .select({ id: biddings.id })
      .from(biddings)
      .where(eq(biddings.id, input.id))
      .limit(1)

    if (existing.length === 0) {
      return {
        success: false,
        error: '존재하지 않는 입찰입니다.'
      }
    }

    // 입찰번호 중복 체크 (다른 레코드에서)
    if (input.biddingNumber) {
      const duplicate = await db
        .select({ id: biddings.id })
        .from(biddings)
        .where(eq(biddings.biddingNumber, input.biddingNumber))
        .limit(1)

      if (duplicate.length > 0 && duplicate[0].id !== input.id) {
        return {
          success: false,
          error: '이미 존재하는 입찰번호입니다.'
        }
      }
    }

    // 날짜 문자열을 Date 객체로 변환
    const parseDate = (dateStr?: string) => {
      if (!dateStr) return undefined
      try {
        return new Date(dateStr)
      } catch {
        return undefined
      }
    }

    // 업데이트할 데이터 준비
    const updateData: any = {
      updatedAt: new Date(),
      updatedBy: userId,
    }

    // 정의된 필드들만 업데이트
    if (input.biddingNumber !== undefined) updateData.biddingNumber = input.biddingNumber
    if (input.revision !== undefined) updateData.revision = input.revision
    if (input.projectName !== undefined) updateData.projectName = input.projectName
    if (input.itemName !== undefined) updateData.itemName = input.itemName
    if (input.title !== undefined) updateData.title = input.title
    if (input.description !== undefined) updateData.description = input.description
    if (input.content !== undefined) updateData.content = input.content
    
    if (input.contractType !== undefined) updateData.contractType = input.contractType
    if (input.biddingType !== undefined) updateData.biddingType = input.biddingType
    if (input.awardCount !== undefined) updateData.awardCount = input.awardCount
    if (input.contractPeriod !== undefined) updateData.contractPeriod = input.contractPeriod
    
    if (input.preQuoteDate !== undefined) updateData.preQuoteDate = parseDate(input.preQuoteDate)
    if (input.biddingRegistrationDate !== undefined) updateData.biddingRegistrationDate = parseDate(input.biddingRegistrationDate)
    if (input.submissionStartDate !== undefined) updateData.submissionStartDate = parseDate(input.submissionStartDate)
    if (input.submissionEndDate !== undefined) updateData.submissionEndDate = parseDate(input.submissionEndDate)
    if (input.evaluationDate !== undefined) updateData.evaluationDate = parseDate(input.evaluationDate)
    
    if (input.hasSpecificationMeeting !== undefined) updateData.hasSpecificationMeeting = input.hasSpecificationMeeting
    if (input.hasPrDocument !== undefined) updateData.hasPrDocument = input.hasPrDocument
    if (input.prNumber !== undefined) updateData.prNumber = input.prNumber
    
    if (input.currency !== undefined) updateData.currency = input.currency
    if (input.budget !== undefined) updateData.budget = input.budget ? parseFloat(input.budget) : null
    if (input.targetPrice !== undefined) updateData.targetPrice = input.targetPrice ? parseFloat(input.targetPrice) : null
    if (input.finalBidPrice !== undefined) updateData.finalBidPrice = input.finalBidPrice ? parseFloat(input.finalBidPrice) : null
    
    if (input.status !== undefined) updateData.status = input.status
    if (input.isPublic !== undefined) updateData.isPublic = input.isPublic
    if (input.managerName !== undefined) updateData.managerName = input.managerName
    if (input.managerEmail !== undefined) updateData.managerEmail = input.managerEmail
    if (input.managerPhone !== undefined) updateData.managerPhone = input.managerPhone
    
    if (input.remarks !== undefined) updateData.remarks = input.remarks

    // 입찰 수정
    await db
      .update(biddings)
      .set(updateData)
      .where(eq(biddings.id, input.id))

    revalidatePath('/admin/biddings')
    revalidatePath(`/admin/biddings/${input.id}`)

    return {
      success: true,
      message: '입찰이 성공적으로 수정되었습니다.'
    }

  } catch (error) {
    console.error('Error updating bidding:', error)
    return {
      success: false,
      error: '입찰 수정 중 오류가 발생했습니다.'
    }
  }
}

// 입찰 삭제
export async function deleteBidding(id: number) {
  try {
    const existing = await db
      .select({ id: biddings.id })
      .from(biddings)
      .where(eq(biddings.id, id))
      .limit(1)

    if (existing.length === 0) {
      return {
        success: false,
        error: '존재하지 않는 입찰입니다.'
      }
    }

    await db
      .delete(biddings)
      .where(eq(biddings.id, id))

    revalidatePath('/admin/biddings')

    return {
      success: true,
      message: '입찰이 성공적으로 삭제되었습니다.'
    }

  } catch (error) {
    console.error('Error deleting bidding:', error)
    return {
      success: false,
      error: '입찰 삭제 중 오류가 발생했습니다.'
    }
  }
}

// 단일 입찰 조회
export async function getBiddingById(id: number) {
  try {
    const bidding = await db
      .select()
      .from(biddings)
      .where(eq(biddings.id, id))
      .limit(1)

    if (bidding.length === 0) {
      return null
    }

    return bidding[0]
  } catch (error) {
    console.error('Error getting bidding:', error)
    return null
  }
}