@extends('layouts.inspinia')

@section('title', 'Cash Movement Summary')

@section('content_header', 'Cash Movement Summary')

@section('breadcrumb')
    <li class="breadcrumb-item"><a href="{{ route('accounting-reports.index') }}">Accounting Reports</a></li>
    <li class="breadcrumb-item active"><strong>Cash Movement</strong></li>
@endsection

@section('content')

<div class="alert alert-warning border-left border-warning py-2 mb-3">
    <i class="fas fa-exclamation-triangle mr-1"></i>
    <strong>Important:</strong>
    This is an <strong>operational cash movement summary</strong>, not a reconciled bank or cashbook statement.
    Opening balances are <strong>not</strong> calculated in this phase.
    Inflows = posted customer receipts (base TZS). Outflows = posted supplier payments + posted expenses.
</div>

{{-- Filter Form --}}
<div class="card card-outline card-success">
    <div class="card-header"><h5 class="card-title mb-0"><i class="fas fa-filter mr-1"></i>Filters</h5></div>
    <div class="card-body py-2">
        <form method="GET" action="{{ route('accounting-reports.cash-movement') }}">
            <div class="row align-items-end">
                <div class="col-md-3">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">From Date</label>
                        <input type="date" name="from_date" class="form-control form-control-sm" value="{{ $from }}">
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">To Date</label>
                        <input type="date" name="to_date" class="form-control form-control-sm" value="{{ $to }}">
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">Payment Method</label>
                        <select name="payment_method" class="form-control form-control-sm">
                            <option value="">All Methods</option>
                            @foreach($paymentMethods as $pm)
                                <option value="{{ $pm }}" {{ $methodFilter === $pm ? 'selected' : '' }}>{{ ucfirst(str_replace('_', ' ', $pm)) }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-md-3">
                    <button type="submit" class="btn btn-sm btn-success"><i class="fas fa-search mr-1"></i>Apply</button>
                    <a href="{{ route('accounting-reports.cash-movement') }}" class="btn btn-sm btn-secondary ml-1"><i class="fas fa-times mr-1"></i>Reset</a>
                </div>
            </div>
        </form>
    </div>
</div>

{{-- Net Position Cards --}}
<div class="row">
    <div class="col-md-4 col-sm-6 col-12 mb-3">
        <div class="small-box bg-success">
            <div class="inner">
                <h4>{{ number_format($totalInflows, 2) }}</h4>
                <p>Total Inflows (TZS) <small class="d-block">{{ $inflowCount }} receipts</small></p>
            </div>
            <div class="icon"><i class="fas fa-arrow-circle-down"></i></div>
        </div>
    </div>
    <div class="col-md-4 col-sm-6 col-12 mb-3">
        <div class="small-box bg-danger">
            <div class="inner">
                <h4>{{ number_format($totalOutflows, 2) }}</h4>
                <p>Total Outflows <small class="d-block">{{ $supplierOutCount + $expenseOutCount }} transactions</small></p>
            </div>
            <div class="icon"><i class="fas fa-arrow-circle-up"></i></div>
        </div>
    </div>
    <div class="col-md-4 col-sm-6 col-12 mb-3">
        <div class="small-box {{ $netMovement >= 0 ? 'bg-primary' : 'bg-warning' }}">
            <div class="inner">
                <h4>{{ number_format($netMovement, 2) }}</h4>
                <p>Net Movement {{ $netMovement >= 0 ? '(Surplus)' : '(Deficit)' }}</p>
            </div>
            <div class="icon"><i class="fas fa-exchange-alt"></i></div>
        </div>
    </div>
</div>

<div class="row">
    {{-- Inflows by Method --}}
    <div class="col-md-4 mb-3">
        <div class="card card-outline card-success">
            <div class="card-header py-2"><h6 class="card-title mb-0"><i class="fas fa-arrow-down mr-1 text-success"></i>Inflows by Method</h6></div>
            <div class="card-body p-0">
                @if($inflowsByMethod->isEmpty())
                    <div class="p-3 text-muted text-center small">No inflows in period</div>
                @else
                <table class="table table-sm table-bordered mb-0">
                    <thead class="thead-light"><tr><th>Method</th><th class="text-right">TZS</th><th class="text-right">Cnt</th></tr></thead>
                    <tbody>
                        @foreach($inflowsByMethod as $row)
                        <tr>
                            <td>{{ ucfirst(str_replace('_', ' ', $row->payment_method ?? 'N/A')) }}</td>
                            <td class="text-right text-success">{{ number_format($row->total, 2) }}</td>
                            <td class="text-right">{{ $row->cnt }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
                @endif
            </div>
        </div>
    </div>

    {{-- Supplier Outflows by Method --}}
    <div class="col-md-4 mb-3">
        <div class="card card-outline card-danger">
            <div class="card-header py-2"><h6 class="card-title mb-0"><i class="fas fa-arrow-up mr-1 text-danger"></i>Supplier Payments by Method</h6></div>
            <div class="card-body p-0">
                @if($supplierOutByMethod->isEmpty())
                    <div class="p-3 text-muted text-center small">No supplier payments in period</div>
                @else
                <table class="table table-sm table-bordered mb-0">
                    <thead class="thead-light"><tr><th>Method</th><th class="text-right">Amount</th><th class="text-right">Cnt</th></tr></thead>
                    <tbody>
                        @foreach($supplierOutByMethod as $row)
                        <tr>
                            <td>{{ ucfirst(str_replace('_', ' ', $row->payment_method ?? 'N/A')) }}</td>
                            <td class="text-right text-danger">{{ number_format($row->total, 2) }}</td>
                            <td class="text-right">{{ $row->cnt }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
                @endif
            </div>
        </div>
    </div>

    {{-- Expense Outflows by Method --}}
    <div class="col-md-4 mb-3">
        <div class="card card-outline card-warning">
            <div class="card-header py-2"><h6 class="card-title mb-0"><i class="fas fa-arrow-up mr-1 text-warning"></i>Expenses by Method</h6></div>
            <div class="card-body p-0">
                @if($expenseOutByMethod->isEmpty())
                    <div class="p-3 text-muted text-center small">No expenses in period</div>
                @else
                <table class="table table-sm table-bordered mb-0">
                    <thead class="thead-light"><tr><th>Method</th><th class="text-right">Amount</th><th class="text-right">Cnt</th></tr></thead>
                    <tbody>
                        @foreach($expenseOutByMethod as $row)
                        <tr>
                            <td>{{ ucfirst(str_replace('_', ' ', $row->payment_method ?? 'N/A')) }}</td>
                            <td class="text-right text-warning">{{ number_format($row->total, 2) }}</td>
                            <td class="text-right">{{ $row->cnt }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
                @endif
            </div>
        </div>
    </div>
</div>

{{-- Summary Statement --}}
<div class="card card-outline card-primary">
    <div class="card-header py-2"><h5 class="card-title mb-0">Movement Statement — {{ $from }} to {{ $to }}</h5></div>
    <div class="card-body p-0">
        <table class="table table-sm mb-0">
            <tbody>
                <tr class="table-success">
                    <td><strong>Inflows</strong></td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td class="pl-4">Customer Receipts (Base TZS)</td>
                    <td class="text-right">{{ $inflowCount }} receipts</td>
                    <td class="text-right font-weight-bold text-success">{{ number_format($totalInflows, 2) }}</td>
                </tr>
                <tr class="table-danger">
                    <td><strong>Outflows</strong></td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td class="pl-4">Supplier Payments</td>
                    <td class="text-right">{{ $supplierOutCount }} payments</td>
                    <td class="text-right text-danger">{{ number_format($totalSupplierOut, 2) }}</td>
                </tr>
                <tr>
                    <td class="pl-4">Expenses</td>
                    <td class="text-right">{{ $expenseOutCount }} expenses</td>
                    <td class="text-right text-danger">{{ number_format($totalExpenseOut, 2) }}</td>
                </tr>
                <tr class="border-top">
                    <td class="pl-4 font-weight-bold">Total Outflows</td>
                    <td></td>
                    <td class="text-right font-weight-bold text-danger">{{ number_format($totalOutflows, 2) }}</td>
                </tr>
                <tr class="{{ $netMovement >= 0 ? 'table-primary' : 'table-warning' }}">
                    <td><strong>Net Movement</strong></td>
                    <td></td>
                    <td class="text-right font-weight-bold">{{ number_format($netMovement, 2) }}</td>
                </tr>
            </tbody>
        </table>
    </div>
</div>

{{-- Daily Inflow Trend --}}
@if($inflowsByDate->isNotEmpty())
<div class="card card-outline card-success mt-3">
    <div class="card-header py-2"><h6 class="card-title mb-0">Daily Inflow Trend</h6></div>
    <div class="card-body p-0">
        <div class="table-responsive" style="max-height:300px;overflow-y:auto;">
            <table class="table table-sm table-bordered mb-0">
                <thead class="thead-light sticky-top">
                    <tr><th>Date</th><th class="text-right">Base (TZS)</th><th class="text-right">Receipts</th></tr>
                </thead>
                <tbody>
                    @foreach($inflowsByDate as $row)
                    <tr>
                        <td>{{ $row->txn_date }}</td>
                        <td class="text-right text-success">{{ number_format($row->total, 2) }}</td>
                        <td class="text-right">{{ $row->cnt }}</td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
</div>
@endif

@endsection