@extends('layouts.app')
@section('title','Reports • JAN Enterprises ERP')
@section('page_title','Business Reports')
@section('page_subtitle','Company profitability, monthly performance and receivable ageing')
@section('content')
<div class="kpis"><div class="neo kpi"><small>Total Investment</small><strong>₹{{ number_format($totals['investment'],0) }}</strong></div><div class="neo kpi"><small>Total Billing</small><strong>₹{{ number_format($totals['billing'],0) }}</strong></div><div class="neo kpi"><small>Gross Profit</small><strong class="green">₹{{ number_format($totals['profit'],0) }}</strong></div><div class="neo kpi"><small>Invoice Receivable</small><strong class="red">₹{{ number_format($totals['receivable'],0) }}</strong></div></div>
<div class="grid2"><section class="neo section"><div class="section-title"><div><h3>Company Performance</h3><span>All historical orders</span></div></div><div class="tablewrap"><table><thead><tr><th>Company</th><th>Orders</th><th>Investment</th><th>Billing</th><th>Profit</th><th>Margin</th></tr></thead><tbody>@foreach($companyRows as $r)<tr><td><a href="{{ route('companies.show',$r['company']) }}"><b>{{ $r['company']->name }}</b></a></td><td>{{ $r['orders'] }}</td><td>₹{{ number_format($r['investment'],0) }}</td><td>₹{{ number_format($r['billing'],0) }}</td><td class="green">₹{{ number_format($r['profit'],0) }}</td><td>{{ $r['investment']>0?number_format($r['profit']/$r['investment']*100,1):0 }}%</td></tr>@endforeach</tbody></table></div></section>
<section class="neo section"><div class="section-title"><div><h3>Monthly Performance</h3><span>Investment vs billing vs profit</span></div></div><div class="tablewrap"><table><thead><tr><th>Month</th><th>Orders</th><th>Investment</th><th>Billing</th><th>Profit</th></tr></thead><tbody>@foreach($monthly as $r)<tr><td><b>{{ $r['month'] }}</b></td><td>{{ $r['orders'] }}</td><td>₹{{ number_format($r['investment'],0) }}</td><td>₹{{ number_format($r['billing'],0) }}</td><td class="green">₹{{ number_format($r['profit'],0) }}</td></tr>@endforeach</tbody></table></div></section></div>
<section class="neo section" style="margin-top:17px"><div class="section-title"><div><h3>Receivable Ageing</h3><span>Open invoice balances</span></div></div><div class="tablewrap"><table><thead><tr><th>Invoice</th><th>Company</th><th>Due Date</th><th>Invoice Total</th><th>Paid</th><th>Balance</th><th>Age</th></tr></thead><tbody>@forelse($receivables as $i)@php $days=$i->due_date?now()->startOfDay()->diffInDays($i->due_date,false):null; @endphp<tr><td><a href="{{ route('invoices.show',$i) }}"><b>{{ $i->invoice_no }}</b></a></td><td>{{ $i->order->company->name }}</td><td>{{ $i->due_date?->format('d M Y') ?? '—' }}</td><td>₹{{ number_format((float)$i->total_amount,0) }}</td><td class="green">₹{{ number_format($i->paid_amount,0) }}</td><td class="red">₹{{ number_format($i->balance,0) }}</td><td>@if($days===null)—@elseif($days<0)<span class="danger-text">{{ abs($days) }} days overdue</span>@else{{ $days }} days to due@endif</td></tr>@empty<tr><td colspan="7" class="empty">No open invoice receivables.</td></tr>@endforelse</tbody></table></div></section>
@endsection