@extends('layouts.admin')
@section('title', 'Trial Balance')
@section('content')
@php $currency = \App\Models\Hotel::query()->value('currency') ?? 'USD'; @endphp
<x-page-header title="Trial Balance"><x-slot:actions><a href="{{ route('admin.accounting.profit-loss') }}" class="btn btn-hp-outline btn-sm">P&amp;L</a></x-slot:actions></x-page-header>
<form class="row g-2 mb-3" method="GET">
<div class="col-md-3"><label class="form-label">As of</label><input type="date" name="as_of" class="form-control" value="{{ $asOf->format('Y-m-d') }}"></div>
<div class="col-auto align-self-end"><button class="btn btn-hp-primary">Run</button></div>
</form>
<div class="hp-card"><div class="table-responsive"><table class="table hp-table mb-0"><thead><tr><th>Code</th><th>Account</th><th>Type</th><th class="text-end">Debit</th><th class="text-end">Credit</th></tr></thead>
<tbody>@php $totalDebit = 0; $totalCredit = 0; @endphp
@foreach($rows as $row)@php $totalDebit += $row->total_debit; $totalCredit += $row->total_credit; @endphp
@if($row->total_debit > 0 || $row->total_credit > 0)<tr><td>{{ $row->code }}</td><td>{{ $row->name }}</td><td>{{ ucfirst($row->type) }}</td>
<td class="text-end">{{ number_format($row->total_debit, 2) }}</td><td class="text-end">{{ number_format($row->total_credit, 2) }}</td></tr>@endif @endforeach
<tr class="fw-bold"><td colspan="3">Totals</td><td class="text-end">{{ $currency }} {{ number_format($totalDebit, 2) }}</td><td class="text-end">{{ $currency }} {{ number_format($totalCredit, 2) }}</td></tr></tbody></table></div></div>
@endsection