@extends('layouts.app')
@section('title','Trial Balance')
@section('content')
<div class="page-head"><div><h1>Trial balance</h1><p>Posted account balances through the selected date.</p></div><form><div class="input-group input-group-sm"><input type="date" name="date_to" class="form-control" value="{{ request('date_to',now()->toDateString()) }}"><button class="btn btn-dark">Run</button></div></form></div><div class="card-erp"><div class="table-responsive"><table class="table table-dense"><thead><tr><th>Code</th><th>Account</th><th>Type</th><th class="text-end">Debit</th><th class="text-end">Credit</th><th class="text-end">Net</th></tr></thead><tbody>@php $td=0;$tc=0; @endphp @foreach($balances as $a) @php $td+=(float)$a->debit;$tc+=(float)$a->credit; @endphp @if((float)$a->debit||(float)$a->credit)<tr><td>{{ $a->code }}</td><td>{{ $a->name_en }}</td><td>{{ strtoupper($a->type) }}</td><td class="text-end">{{ number_format((float)$a->debit,2) }}</td><td class="text-end">{{ number_format((float)$a->credit,2) }}</td><td class="text-end fw-bold">{{ number_format((float)$a->debit-(float)$a->credit,2) }}</td></tr>@endif @endforeach</tbody><tfoot><tr><th colspan="3" class="text-end">TOTAL</th><th class="text-end">{{ number_format($td,2) }}</th><th class="text-end">{{ number_format($tc,2) }}</th><th class="text-end {{ abs($td-$tc)<.01?'text-success':'text-danger' }}">Difference {{ number_format($td-$tc,2) }}</th></tr></tfoot></table></div></div>
@endsection