@extends('admin.layouts.app')

@section('title', 'Cashbook')
@section('page_title', 'Cashbook Report')

@section('content')
<div class="card">
    <div class="card-header">
        <h5 class="mb-0">Cashbook Report</h5>
    </div>
    <div class="card-body">
        <form method="GET" action="{{ route('cashbook.index') }}" class="mb-4">
            <div class="row">
                <div class="col-md-3">
                    <label class="form-label">Start Date</label>
                    <input type="date" name="start_date" class="form-control @error('start_date') is-invalid @enderror" value="{{ request('start_date', date('Y-m-01')) }}">
                    @error('start_date')
                        <div class="invalid-feedback">{{ $message }}</div>
                    @enderror
                </div>
                <div class="col-md-3">
                    <label class="form-label">End Date</label>
                    <input type="date" name="end_date" class="form-control @error('end_date') is-invalid @enderror" value="{{ request('end_date', date('Y-m-d')) }}">
                    @error('end_date')
                        <div class="invalid-feedback">{{ $message }}</div>
                    @enderror
                </div>
                <div class="col-md-3">
                    <label class="form-label">Type</label>
                    <select name="type" class="form-select">
                        <option value="">All</option>
                        <option value="payment" {{ request('type') == 'payment' ? 'selected' : '' }}>Payment</option>
                        <option value="receipt" {{ request('type') == 'receipt' ? 'selected' : '' }}>Receipt</option>
                    </select>
                </div>
                <div class="col-md-3">
                    <label class="form-label">&nbsp;</label>
                    <button type="submit" class="btn btn-primary w-100">Search</button>
                </div>
            </div>
        </form>
        
        <div class="table-responsive">
            <table class="table table-bordered table-striped" style="font-size: 12px;">
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>Date</th>
                        <th>Type</th>
                        <th>Description</th>
                        <th>Reference</th>
                        <th class="text-end">Debit</th>
                        <th class="text-end">Credit</th>
                        <th class="text-end">Balance</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                        $balance = (float)($openingBalance ?? 0);
                        $grouped = $cashbooks->groupBy(function($item) {
                            return $item->date;
                        });
                        $currentDate = null;
                    @endphp
                    
                    @forelse($grouped as $date => $entries)
                        @php
                            $dayOpening = $balance;
                            $dayDebit = $entries->sum('debit');
                            $dayCredit = $entries->sum('credit');
                        @endphp
                        <tr class="table-light">
                            <td>-</td>
                            <td><strong>{{ date('d-m-Y', strtotime($date)) }}</strong></td>
                            <td>-</td>
                            <td><strong>Opening Balance</strong></td>
                            <td>-</td>
                            <td class="text-end">-</td>
                            <td class="text-end">-</td>
                            <td class="text-end"><strong>{{ number_format($dayOpening, 2) }}</strong></td>
                        </tr>
                        @foreach($entries as $entry)
                            @php
                                $balance = $balance + (float)$entry->credit - (float)$entry->debit;
                            @endphp
                            <tr>
                                <td>{{ $entry->id }}</td>
                                <td>{{ date('d-m-Y', strtotime($entry->date)) }}</td>
                                <td>
                                    @if($entry->type == 'receipt')
                                        <span class="badge bg-success">Receipt</span>
                                    @else
                                        <span class="badge bg-danger">Payment</span>
                                    @endif
                                </td>
                                <td>{{ $entry->description }}</td>
                                <td>{{ $entry->reference_type ? $entry->reference_type . ' #' . $entry->reference_id : '-' }}</td>
                                <td class="text-end">{{ $entry->debit > 0 ? number_format($entry->debit, 2) : '0.00' }}</td>
                                <td class="text-end">{{ $entry->credit > 0 ? number_format($entry->credit, 2) : '0.00' }}</td>
                                <td class="text-end {{ $balance < 0 ? 'text-danger' : '' }}"><strong>{{ number_format($balance, 2) }}</strong></td>
                            </tr>
                        @endforeach
                        <tr class="table-secondary" style="border-top: 2px solid #999;">
                            <td>-</td>
                            <td><strong>{{ date('d-m-Y', strtotime($date)) }}</strong></td>
                            <td>-</td>
                            <td><strong>Closing Balance</strong></td>
                            <td>-</td>
                            <td class="text-end"><strong>{{ number_format($dayDebit, 2) }}</strong></td>
                            <td class="text-end"><strong>{{ number_format($dayCredit, 2) }}</strong></td>
                            <td class="text-end"><strong class="{{ $balance < 0 ? 'text-danger' : 'text-success' }}">{{ number_format($balance, 2) }}</strong></td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="8" class="text-center">No entries found</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot>
                    <tr class="table-info">
                        <td colspan="5" class="text-end"><strong>Total:</strong></td>
                        <td class="text-end"><strong>{{ number_format($cashbooks->sum('debit'), 2) }}</strong></td>
                        <td class="text-end"><strong>{{ number_format($cashbooks->sum('credit'), 2) }}</strong></td>
                        <td></td>
                    </tr>
                    <tr class="table-info">
                        <td colspan="5" class="text-end"><strong>Closing Balance:</strong></td>
                        <td class="text-end">-</td>
                        <td class="text-end">-</td>
                        <td class="text-end"><strong class="{{ $balance < 0 ? 'text-danger' : 'text-success' }}">{{ number_format($balance, 2) }}</strong></td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>
@endsection