@extends('layouts.app')

@section('title', 'Day-wise Summary Report')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h3 class="card-title">
                        <i class="fas fa-calendar-alt"></i> Day-wise Summary Report
                    </h3>
                    <a href="{{ route('bank-transactions.index') }}" class="btn btn-secondary">
                        <i class="fas fa-arrow-left"></i> Back to Transactions
                    </a>
                </div>
                
                <div class="card-body">
                    <!-- Filter Form -->
                    <form method="GET" action="{{ route('bank-transactions.day-wise-summary') }}" class="mb-4">
                        <div class="row">
                            <div class="col-md-4">
                                <label class="small mb-1">Date From</label>
                                <input type="date" name="date_from" class="form-control" value="{{ $dateFrom->format('Y-m-d') }}">
                            </div>
                            <div class="col-md-4">
                                <label class="small mb-1">Date To</label>
                                <input type="date" name="date_to" class="form-control" value="{{ $dateTo->format('Y-m-d') }}">
                            </div>
                            <div class="col-md-4">
                                <label class="small mb-1">&nbsp;</label>
                                <div>
                                    <button type="submit" class="btn btn-primary">
                                        <i class="fas fa-filter"></i> Filter
                                    </button>
                                    <a href="{{ route('bank-transactions.day-wise-summary') }}" class="btn btn-secondary">
                                        <i class="fas fa-undo"></i> Reset
                                    </a>
                                </div>
                            </div>
                        </div>
                    </form>

                    <!-- Summary Cards -->
                    <div class="row mb-4">
                        <div class="col-md-3">
                            <div class="card bg-success text-white h-100">
                                <div class="card-body text-center d-flex flex-column justify-content-center" style="min-height: 120px;">
                                    <h4 class="mb-1">৳{{ number_format($grandTotalDeposit, 2) }}</h4>
                                    <small>Total Deposit</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card bg-danger text-white h-100">
                                <div class="card-body text-center d-flex flex-column justify-content-center" style="min-height: 120px;">
                                    <h4 class="mb-1">৳{{ number_format($grandTotalWithdrawal, 2) }}</h4>
                                    <small>Total Withdrawal</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card bg-info text-white h-100">
                                <div class="card-body text-center d-flex flex-column justify-content-center" style="min-height: 120px;">
                                    <h4 class="mb-1">৳{{ number_format($grandNetBalance, 2) }}</h4>
                                    <small>Net Balance</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card bg-primary text-white h-100">
                                <div class="card-body text-center d-flex flex-column justify-content-center" style="min-height: 120px;">
                                    <h4 class="mb-1">{{ $grandTotalTransactions }}</h4>
                                    <small>Total Transactions</small>
                                    <div class="mt-2">
                                        <small>
                                            <i class="fas fa-check-circle"></i> {{ $grandApprovedCount }} Approved<br>
                                            <i class="fas fa-times-circle"></i> {{ $grandUnapprovedCount }} Unapproved
                                        </small>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Day-wise Summary Table -->
                    @if(count($dayWiseData) > 0)
                        <div class="card">
                            <div class="card-header bg-primary text-white">
                                <h5 class="mb-0">
                                    <i class="fas fa-table"></i> Day-wise Summary
                                </h5>
                            </div>
                            <div class="card-body p-0">
                                <div class="table-responsive">
                                    <table class="table table-bordered table-striped mb-0">
                                        <thead class="thead-light">
                                            <tr>
                                                <th style="width: 5%;">#</th>
                                                <th style="width: 15%;">Date</th>
                                                <th style="width: 15%;" class="text-right">Total Deposit</th>
                                                <th style="width: 15%;" class="text-right">Total Withdrawal</th>
                                                <th style="width: 15%;" class="text-right">Net Balance</th>
                                                <th style="width: 10%;" class="text-center">Transactions</th>
                                                <th style="width: 12%;" class="text-center">Approved</th>
                                                <th style="width: 12%;" class="text-center">Unapproved</th>
                                                <th style="width: 1%;">Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach($dayWiseData as $dateKey => $dayData)
                                                @php
                                                    $deposit = (float)($dayData['deposit'] ?? 0);
                                                    $withdrawal = (float)($dayData['withdrawal'] ?? 0);
                                                    $netBalance = $deposit - $withdrawal;
                                                @endphp
                                                <tr>
                                                    <td>{{ $loop->iteration }}</td>
                                                    <td>
                                                        <strong>{{ $dayData['date']->format('d M Y') }}</strong><br>
                                                        <small class="text-muted">{{ $dayData['date']->format('l') }}</small>
                                                    </td>
                                                    <td class="text-right text-success">
                                                        <strong>৳{{ number_format($deposit, 2) }}</strong>
                                                    </td>
                                                    <td class="text-right text-danger">
                                                        <strong>৳{{ number_format($withdrawal, 2) }}</strong>
                                                    </td>
                                                    <td class="text-right">
                                                        <strong class="{{ $netBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                                            ৳{{ number_format($netBalance, 2) }}
                                                        </strong>
                                                    </td>
                                                    <td class="text-center">
                                                        <span class="badge badge-primary">{{ $dayData['transaction_count'] }}</span>
                                                    </td>
                                                    <td class="text-center">
                                                        <span class="badge badge-success">
                                                            <i class="fas fa-check-circle"></i> {{ $dayData['approved_count'] }}
                                                        </span>
                                                    </td>
                                                    <td class="text-center">
                                                        <span class="badge badge-warning">
                                                            <i class="fas fa-times-circle"></i> {{ $dayData['unapproved_count'] }}
                                                        </span>
                                                    </td>
                                                    <td class="text-center">
                                                        <a href="{{ route('bank-transactions.index', ['date_from' => $dayData['date']->format('Y-m-d'), 'date_to' => $dayData['date']->format('Y-m-d')]) }}" 
                                                           class="btn btn-sm btn-info" title="View All Transactions for this Date">
                                                            <i class="fas fa-eye"></i>
                                                        </a>
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                        <tfoot class="table-info">
                                            <tr>
                                                <th colspan="2"><strong>Grand Total</strong></th>
                                                <th class="text-right">
                                                    <strong class="text-success">৳{{ number_format($grandTotalDeposit, 2) }}</strong>
                                                </th>
                                                <th class="text-right">
                                                    <strong class="text-danger">৳{{ number_format($grandTotalWithdrawal, 2) }}</strong>
                                                </th>
                                                <th class="text-right">
                                                    <strong class="{{ $grandNetBalance >= 0 ? 'text-success' : 'text-danger' }}">
                                                        ৳{{ number_format($grandNetBalance, 2) }}
                                                    </strong>
                                                </th>
                                                <th class="text-center">
                                                    <strong>{{ $grandTotalTransactions }}</strong>
                                                </th>
                                                <th class="text-center">
                                                    <strong class="text-success">{{ $grandApprovedCount }}</strong>
                                                </th>
                                                <th class="text-center">
                                                    <strong class="text-warning">{{ $grandUnapprovedCount }}</strong>
                                                </th>
                                                <th></th>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                    @else
                        <div class="alert alert-info text-center">
                            <i class="fas fa-info-circle"></i> No transactions found for the selected date range.
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>
@endsection