<?php

namespace App\Http\Controllers;

use App\Models\Sale;
use App\Models\SaleItem;
use Modules\Inventory\Entities\Product;
use App\Models\Account;
use Illuminate\Http\Request;

class SaleController extends Controller
{
    /**
     * Display a listing of the resource.
     */
    public function index() {
        $sales = Sale::with('account')->latest()->paginate(10);
        return view('sales.index', compact('sales'));
    }

    public function create() {
        $customers = Account::all();
        $products = Product::all();
        return view('sales.create', compact('customers','products'));
    }

    public function store(Request $request) {
        $data = $request->validate([
            'account_id'=>'required',
            'sale_date'=>'required|date',
            'items.*.product_id'=>'required',
            'items.*.quantity'=>'required|integer|min:1',
            'items.*.price'=>'required|numeric',
            'items.*.discount'=>'nullable|numeric',
        ]);

        $total = 0;
        foreach ($request->items as $item) {
            $subtotal = ($item['price'] * $item['quantity']) - $item['discount'];
            $total += $subtotal;
        }

        $sale = Sale::create([
            'account_id'=>$request->account_id,
            'sale_date'=>$request->sale_date,
            'total_amount'=>$total,
            'payment_status'=>'paid',
            'warranty_start_date'=>$request->sale_date,
            'warranty_end_date'=>now()->addMonths(12) // default 1 year
        ]);

        
        foreach ($request->items as $item) {
            $subtotal = ($item['price'] * $item['quantity']) - $item['discount'];
            SaleItem::create([
                'sale_id'=>$sale->id,
                'product_id'=>$item['product_id'],
                'quantity'=>$item['quantity'],
                'price'=>$item['price'],
                'discount'=>$item['discount'] ?? 0,
                'subtotal'=>$subtotal
            ]);
            //Product::where('id',$item['product_id'])->decrement('stock',$item['quantity']);
        }

        return redirect()->route('sales.index')->with('success','Sale recorded.');
    }

    public function show(Sale $sale) {
        $sale->load('items.product','customer');
        return view('sales.show', compact('sale'));
    }
}