@extends('layout')@section('c')
<div class="head"><h1>Reports</h1><form method="get">From <input type="date" name="from" value="{{ $from }}"> to <input type="date" name="to" value="{{ $to }}"><button>Apply</button></form></div>
<div class="kpis"><div class="kpi"><span>Income</span><b>{{ number_format($tin,2) }}</b></div><div class="kpi"><span>Company expenses</span><b>{{ number_format($tex,2) }}</b></div><div class="kpi"><span>Net profit</span><b style="color:{{ $tin-$tex>=0?'var(--ok)':'var(--bad)' }}">{{ number_format($tin-$tex,2) }}</b></div></div>
<div class="grid2"><div class="card"><h3>Monthly summary</h3><table><tr><th>Month</th><th>Income</th><th>Expenses</th><th>Net</th></tr>@foreach($months as $m)<tr><td>{{ $m['label'] }}</td><td>{{ number_format($m['in'],2) }}</td><td>{{ number_format($m['ex'],2) }}</td><td>{{ number_format($m['in']-$m['ex'],2) }}</td></tr>@endforeach</table></div>
<div class="card"><h3>Company expenses by category</h3><table><tr><th>Category</th><th>Amount</th></tr>@foreach($cats as $m)<tr><td>{{ $m['label'] }}</td><td>{{ number_format($m['ex'],2) }}</td></tr>@endforeach</table></div></div>
<div class="card"><h3>Profit by employer / agency</h3><table><tr><th>Employer</th><th>Income</th><th>Expenses</th><th>Net</th></tr>@foreach($emps as $m)<tr><td>{{ $m['label'] }}</td><td>{{ number_format($m['in'],2) }}</td><td>{{ number_format($m['ex'],2) }}</td><td>{{ number_format($m['in']-$m['ex'],2) }}</td></tr>@endforeach</table></div>
<div class="card"><h3>Profit by candidate</h3><table><tr><th>Candidate</th><th>Income</th><th>Expenses</th><th>Net</th></tr>@foreach($cands as $k=>$m)<tr><td>@if($k)<a href="{{ url('/') }}/candidates/{{ $k }}">{{ $m['label'] }}</a>@else{{ $m['label'] }}@endif</td><td>{{ number_format($m['in'],2) }}</td><td>{{ number_format($m['ex'],2) }}</td><td style="color:{{ $m['in']-$m['ex']>=0?'var(--ok)':'var(--bad)' }}">{{ number_format($m['in']-$m['ex'],2) }}</td></tr>@endforeach</table>
<small>Only company-paid expenses count. Expenses paid by a self-sponsored candidate are excluded.</small></div>
@endsection