@extends('layouts.app')

@section('title', 'تقرير الربحية')
@section('page_title', 'تقرير الربحية')
@section('breadcrumb')
<li class="breadcrumb-item"><a href="{{ route('reports.index') }}">التقارير</a></li>
<li class="breadcrumb-item active">الربحية</li>
@endsection

@section('content')
<form method="GET" class="card">
    <div class="card-body row align-items-end">
        <div class="col-md-3 form-group">
            <label>الصيدلية</label>
            <select name="pharmacy_id" class="form-control select2">
                <option value="">— كل الصيدليات —</option>
                @foreach ($pharmacies as $p)
                    <option value="{{ $p->id }}" {{ request('pharmacy_id') == $p->id ? 'selected' : '' }}>{{ $p->name }}</option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3 form-group"><label>من</label><input type="date" name="from" value="{{ $from }}" class="form-control"></div>
        <div class="col-md-3 form-group"><label>إلى</label><input type="date" name="to"   value="{{ $to }}"   class="form-control"></div>
        <div class="col-md-2"><button class="btn btn-primary"><i class="fas fa-search"></i> عرض</button></div>
    </div>
</form>

<div class="row">
    <div class="col-md-3"><div class="small-box bg-success"><div class="inner"><h4>{{ number_format($totals['revenue'], 2) }}</h4><p>الإيراد (Revenue)</p></div></div></div>
    <div class="col-md-3"><div class="small-box bg-warning"><div class="inner"><h4>{{ number_format($totals['cost'], 2) }}</h4><p>التكلفة (COGS)</p></div></div></div>
    <div class="col-md-3"><div class="small-box bg-primary"><div class="inner"><h4>{{ number_format($totals['profit'], 2) }}</h4><p>الربح</p></div></div></div>
    <div class="col-md-3"><div class="small-box bg-info"><div class="inner"><h4>{{ number_format($totals['margin'], 2) }}%</h4><p>هامش الربح</p></div></div></div>
</div>

<div class="card">
    <div class="card-header"><h5 class="m-0">أعلى الأصناف ربحاً</h5></div>
    <div class="card-body p-0">
        <table class="table table-bordered table-striped m-0">
            <thead class="thead-light">
                <tr><th>الكود</th><th>الصنف</th><th>الكمية المُباعة</th><th>الإيراد</th><th>التكلفة</th><th>الربح</th><th>الهامش %</th></tr>
            </thead>
            <tbody>
                @forelse ($rows as $r)
                @php $margin = $r->revenue > 0 ? ($r->profit / $r->revenue * 100) : 0; @endphp
                <tr>
                    <td>{{ $r->code }}</td>
                    <td>{{ $r->name }}</td>
                    <td>{{ number_format((float) $r->qty, 2) }}</td>
                    <td>{{ number_format((float) $r->revenue, 2) }}</td>
                    <td>{{ number_format((float) $r->cost, 2) }}</td>
                    <td><strong class="{{ $r->profit >= 0 ? 'text-success' : 'text-danger' }}">{{ number_format((float) $r->profit, 2) }}</strong></td>
                    <td>{{ number_format($margin, 2) }}%</td>
                </tr>
                @empty
                <tr><td colspan="7" class="text-muted text-center p-3">لا توجد بيانات.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>
@endsection