User Inventory System

// After determining winner from provably fair calculation
const winnerItem = getWinningItem(mappedItems, rollValue)

// Add to user's inventory
await supabase.from('user_items').insert({
  user_id: user.id,
  item_id: winnerItem.id,
  status: 'in_inventory'
})

// Alternative: If using denormalized case_items
// You might need to create the item record first
const { data: itemRecord } = await supabase
  .from('items')
  .select('*')
  .eq('name', winnerItem.name)
  .eq('price', winnerItem.value)
  .single()

if (!itemRecord) {
  // Create item if doesn't exist
  const { data: newItem } = await supabase
    .from('items')
    .insert({
      name: winnerItem.name,
      image_url: winnerItem.image_url,
      rarity: winnerItem.rarity,
      price: winnerItem.value
    })
    .select()
    .single()
  
  await supabase.from('user_items').insert({
    user_id: user.id,
    item_id: newItem.id,
    status: 'in_inventory'
  })
}

import { createClient } from '@/lib/supabase/server'
import { NextResponse } from 'next/server'

export async function POST(request: Request) {
  const supabase = await createClient()
  const { data: { user } } = await supabase.auth.getUser()
  
  if (!user) {
    return NextResponse.json({ error: 'Unauthorized' }, { status: 401 })
  }
  
  const { userItemId } = await request.json()
  
  // 1. Fetch the item with ownership verification
  const { data: userItem, error: fetchError } = await supabase
    .from('user_items')
    .select('*, items(*)')
    .eq('id', userItemId)
    .eq('user_id', user.id)  // Ensure ownership
    .eq('status', 'in_inventory')  // Can only sell items in inventory
    .single()
  
  if (fetchError || !userItem) {
    return NextResponse.json(
      { error: 'Item not found or already sold' },
      { status: 404 }
    )
  }
  
  const itemValue = userItem.items.price
  
  // 2. Update item status to 'sold'
  const { error: updateError } = await supabase
    .from('user_items')
    .update({ status: 'sold' })
    .eq('id', userItemId)
  
  if (updateError) {
    return NextResponse.json(
      { error: 'Failed to update item' },
      { status: 500 }
    )
  }
  
  // 3. Add value to user balance
  const { data: userData } = await supabase
    .from('users')
    .select('balance')
    .eq('id', user.id)
    .single()
  
  await supabase
    .from('users')
    .update({ balance: userData.balance + itemValue })
    .eq('id', user.id)
  
  // 4. Record transaction
  await supabase.from('transactions').insert({
    user_id: user.id,
    amount: itemValue,
    type: 'item_sell',
    reference_id: userItem.item_id
  })
  
  return NextResponse.json({
    success: true,
    item_name: userItem.items.name,
    amount_received: itemValue,
    new_balance: userData.balance + itemValue
  })
}

export async function POST(request: Request) {
  const { userItemId, deliveryDetails } = await request.json()
  
  // Fetch item
  const { data: userItem } = await supabase
    .from('user_items')
    .select('*, items(*)')
    .eq('id', userItemId)
    .eq('user_id', user.id)
    .eq('status', 'in_inventory')
    .single()
  
  if (!userItem) {
    return NextResponse.json(
      { error: 'Item not found' },
      { status: 404 }
    )
  }
  
  // Check minimum withdrawal value
  const MIN_WITHDRAWAL_VALUE = 10000
  if (userItem.items.price < MIN_WITHDRAWAL_VALUE) {
    return NextResponse.json(
      { 
        error: `Items must be worth at least ${MIN_WITHDRAWAL_VALUE} ARS to withdraw` 
      },
      { status: 400 }
    )
  }
  
  // Update status
  await supabase
    .from('user_items')
    .update({ status: 'withdrawn' })
    .eq('id', userItemId)
  
  // Create withdrawal request (new table needed)
  await supabase.from('withdrawal_requests').insert({
    user_id: user.id,
    user_item_id: userItemId,
    delivery_details: deliveryDetails,
    status: 'pending'
  })
  
  return NextResponse.json({
    success: true,
    message: 'Withdrawal request created'
  })
}

'use client'

import { useEffect, useState } from 'react'
import { createClient } from '@/lib/supabase/client'
import { formatCurrency } from '@/lib/utils'

interface InventoryItem {
  id: string
  status: string
  created_at: string
  items: {
    id: string
    name: string
    image_url: string
    rarity: string
    price: number
  }
}

export function InventoryGrid() {
  const [items, setItems] = useState<InventoryItem[]>([])
  const [loading, setLoading] = useState(true)
  const supabase = createClient()
  
  useEffect(() => {
    async function fetchInventory() {
      const { data: { user } } = await supabase.auth.getUser()
      if (!user) return
      
      const { data } = await supabase
        .from('user_items')
        .select('*, items(*)')
        .eq('user_id', user.id)
        .eq('status', 'in_inventory')
        .order('created_at', { ascending: false })
      
      setItems(data || [])
      setLoading(false)
    }
    
    fetchInventory()
  }, [])
  
  const handleSell = async (userItemId: string) => {
    const response = await fetch('/api/inventory/sell', {
      method: 'POST',
      headers: { 'Content-Type': 'application/json' },
      body: JSON.stringify({ userItemId })
    })
    
    if (response.ok) {
      // Remove from UI
      setItems(items.filter(item => item.id !== userItemId))
    }
  }
  
  if (loading) return <div>Loading...</div>
  if (items.length === 0) return <div>No items in inventory</div>
  
  return (
    <div className="grid grid-cols-1 md:grid-cols-3 lg:grid-cols-4 gap-4">
      {items.map(item => (
        <div 
          key={item.id}
          className="bg-[#1a1d26] border border-white/5 rounded-lg p-4"
        >
          <img 
            src={item.items.image_url} 
            alt={item.items.name}
            className="w-full h-40 object-contain"
          />
          <h3 className="text-white font-bold mt-2">
            {item.items.name}
          </h3>
          <p className="text-primary font-bold">
            {formatCurrency(item.items.price)}
          </p>
          <button
            onClick={() => handleSell(item.id)}
            className="btn-primary w-full mt-2"
          >
            Sell
          </button>
        </div>
      ))}
    </div>
  )
}