@extends('admin.layouts.app')

@section('title', 'Margin')

@section('content')
    <h1>Profit margin</h1>

    <form method="GET" style="display:flex; gap:12px; align-items:flex-end; margin-bottom: 20px;">
        <div style="flex:1;">
            <label for="from">From</label>
            <input type="date" id="from" name="from" value="{{ $from }}">
        </div>
        <div style="flex:1;">
            <label for="to">To</label>
            <input type="date" id="to" name="to" value="{{ $to }}">
        </div>
        <button type="submit" class="btn" style="margin-bottom:16px;">Filter</button>
    </form>

    <div class="stat-row">
        <div class="stat">
            <div class="label" style="margin:0 0 6px;">Revenue</div>
            <div class="num">៛{{ number_format($totalRevenueRiel, 0) }}</div>
            <div class="sub">${{ number_format($totalRevenueRiel / $rielRate, 2) }}</div>
        </div>
        <div class="stat">
            <div class="label" style="margin:0 0 6px;">Profit</div>
            <div class="num">៛{{ number_format($totalProfitRiel, 0) }}</div>
            <div class="sub">${{ number_format($totalProfitRiel / $rielRate, 2) }}</div>
        </div>
    </div>

    <table>
        <tr>
            <th>Fuel type</th>
            <th>Liters sold</th>
            <th>Revenue (៛)</th>
            <th>Revenue (USD)</th>
            <th>Profit (៛)</th>
            <th>Profit (USD)</th>
            <th>Profit / liter (៛)</th>
        </tr>
        @forelse ($byFuel as $row)
            <tr>
                <td>{{ $row['name'] }}</td>
                <td>{{ number_format($row['liters'], 2) }}</td>
                <td>៛{{ number_format($row['revenue_riel'], 0) }}</td>
                <td>${{ number_format($row['revenue_riel'] / $rielRate, 2) }}</td>
                <td style="{{ $row['profit_riel'] < 0 ? 'color:#B3261E; font-weight:600;' : '' }}">
                    ៛{{ number_format($row['profit_riel'], 0) }}
                </td>
                <td style="{{ $row['profit_riel'] < 0 ? 'color:#B3261E; font-weight:600;' : '' }}">
                    ${{ number_format($row['profit_riel'] / $rielRate, 2) }}
                </td>
                <td>៛{{ $row['liters'] > 0 ? number_format($row['profit_riel'] / $row['liters'], 0) : 0 }}</td>
            </tr>
        @empty
            <tr><td colspan="7">No sales in this range.</td></tr>
        @endforelse
    </table>
@endsection