import { createClient } from '@/lib/supabase/server'
import { getSelectedBranchId } from '@/lib/branch'
import { ReportsClient } from './reports-client'

export default async function ReportsPage() {
  const supabase = await createClient()
  const { data: org } = await supabase.from('organizations').select('id').single()
  if (!org) return <div>Байгууллага олдсонгүй</div>

  const { data: branches } = await supabase
    .from('branches')
    .select('id, name')
    .eq('org_id', org.id)
    .order('created_at')

  const branchId = await getSelectedBranchId(branches ?? [])
  const branchName = (branches ?? []).find(b => b.id === branchId)?.name ?? ''

  const from = new Date()
  from.setDate(from.getDate() - 29)
  from.setHours(0, 0, 0, 0)

  const { data: sales } = await supabase
    .from('sales')
    .select('*, sale_items(product_name, quantity, unit_price, cost_price)')
    .eq('branch_id', branchId ?? '')
    .gte('created_at', from.toISOString())
    .order('created_at', { ascending: true })

  return <ReportsClient sales={sales ?? []} branchName={branchName} />
}