@extends('layouts.app')

@section('title', 'Bank Transaction Report Detail')

@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-chart-line"></i> Bank Transaction Report Detail
                    </h3>
                    <button onclick="history.back()" class="btn btn-secondary">
                        <i class="fas fa-arrow-left"></i> Back
                    </button>
                </div>
                
                <div class="card-body">
                    <!-- Bank Information -->
                    <div class="card mb-4 border-primary">
                        <div class="card-header bg-primary text-white">
                            <h5 class="mb-0">
                                <i class="fas fa-university"></i> Bank Information
                            </h5>
                        </div>
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-6">
                                    <p><strong>Bank Name:</strong> {{ $bankAccount->bank_name }}</p>
                                    <p><strong>Account Number:</strong> {{ $bankAccount->account_number }}</p>
                                    @if($bankAccount->account_name)
                                        <p><strong>Account Name:</strong> {{ $bankAccount->account_name }}</p>
                                    @endif
                                </div>
                                <div class="col-md-6">
                                    @if($bankAccount->branch_name)
                                        <p><strong>Branch:</strong> {{ $bankAccount->branch_name }}</p>
                                    @endif
                                    @if($bankAccount->account_type)
                                        <p><strong>Account Type:</strong> {{ $bankAccount->account_type }}</p>
                                    @endif
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Filter Form -->
                    <form method="GET" action="{{ route('bank-information.report-detail', $bankAccount->id) }}" class="mb-4">
                        <div class="row">
                            <div class="col-md-3">
                                <label class="small mb-1">Period Type</label>
                                <select name="period_type" class="form-control">
                                    <option value="daily" {{ $periodType == 'daily' ? 'selected' : '' }}>Daily</option>
                                    <option value="monthly" {{ $periodType == 'monthly' ? 'selected' : '' }}>Monthly</option>
                                    <option value="yearly" {{ $periodType == 'yearly' ? 'selected' : '' }}>Yearly</option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <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-3">
                                <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-3">
                                <label class="small mb-1">&nbsp;</label>
                                <div>
                                    <button type="submit" class="btn btn-primary btn-block">
                                        <i class="fas fa-filter"></i> Filter
                                    </button>
                                </div>
                            </div>
                        </div>
                    </form>

                    <!-- Summary Cards -->
                    <div class="row mb-4">
                        <div class="col-md-4">
                            <div class="card bg-success text-white">
                                <div class="card-body text-center">
                                    <h4 class="mb-1">৳{{ number_format($totalDeposit, 2) }}</h4>
                                    <small>Total Deposit</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="card bg-danger text-white">
                                <div class="card-body text-center">
                                    <h4 class="mb-1">৳{{ number_format($totalWithdrawal, 2) }}</h4>
                                    <small>Total Withdrawal</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="card bg-info text-white">
                                <div class="card-body text-center">
                                    <h4 class="mb-1">৳{{ number_format($totalDeposit - $totalWithdrawal, 2) }}</h4>
                                    <small>Net Balance</small>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Detailed Report Table -->
                    @if(count($periods) > 0)
                        <div class="card">
                            <div class="card-header bg-primary text-white">
                                <h5 class="mb-0">
                                    <i class="fas fa-chart-bar"></i> Detailed Breakdown
                                </h5>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-bordered table-striped">
                                        <thead class="thead-light">
                                            <tr>
                                                <th>Period</th>
                                                <th class="text-right">Deposit</th>
                                                <th class="text-right">Withdrawal</th>
                                                <th class="text-right">Net</th>
                                                <th class="text-center">Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach($periods as $periodData)
                                                <tr>
                                                    <td>
                                                        <strong>{{ $periodLabels[$periodData['period']] ?? $periodData['period'] }}</strong>
                                                    </td>
                                                    <td class="text-right text-success">
                                                        <strong>৳{{ number_format($periodData['deposit'], 2) }}</strong>
                                                    </td>
                                                    <td class="text-right text-danger">
                                                        <strong>৳{{ number_format($periodData['withdrawal'], 2) }}</strong>
                                                    </td>
                                                    <td class="text-right">
                                                        <strong class="{{ ($periodData['deposit'] - $periodData['withdrawal']) >= 0 ? 'text-success' : 'text-danger' }}">
                                                            ৳{{ number_format($periodData['deposit'] - $periodData['withdrawal'], 2) }}
                                                        </strong>
                                                    </td>
                                                    <td class="text-center">
                                                        @php
                                                            // Determine the date range for daily details based on period type
                                                            if ($periodType == 'daily') {
                                                                $detailDateFrom = $periodData['period'];
                                                                $detailDateTo = $periodData['period'];
                                                            } elseif ($periodType == 'monthly') {
                                                                $detailDateFrom = \Carbon\Carbon::createFromFormat('Y-m', $periodData['period'])->startOfMonth()->format('Y-m-d');
                                                                $detailDateTo = \Carbon\Carbon::createFromFormat('Y-m', $periodData['period'])->endOfMonth()->format('Y-m-d');
                                                            } else { // yearly
                                                                $detailDateFrom = $periodData['period'] . '-01-01';
                                                                $detailDateTo = $periodData['period'] . '-12-31';
                                                            }
                                                        @endphp
                                                        <a href="{{ route('bank-information.report-daily', ['bankId' => $bankAccount->id, 'date_from' => $detailDateFrom, 'date_to' => $detailDateTo]) }}" 
                                                           class="btn btn-sm btn-info" title="View Daily Details">
                                                            <i class="fas fa-eye"></i>
                                                        </a>
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                        <tfoot class="table-info">
                                            <tr>
                                                <th><strong>Total</strong></th>
                                                <th class="text-right">
                                                    <strong class="text-success">৳{{ number_format($totalDeposit, 2) }}</strong>
                                                </th>
                                                <th class="text-right">
                                                    <strong class="text-danger">৳{{ number_format($totalWithdrawal, 2) }}</strong>
                                                </th>
                                                <th class="text-right">
                                                    <strong class="{{ ($totalDeposit - $totalWithdrawal) >= 0 ? 'text-success' : 'text-danger' }}">
                                                        ৳{{ number_format($totalDeposit - $totalWithdrawal, 2) }}
                                                    </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 period.
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>
@endsection