@extends('layouts.app')
@section('title', __('Daily Report'))

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">{{ __('Daily Report') }}</h1>
</section>

<!-- Main content -->
<section class="content">
    <div class="row no-print">
        <div class="col-md-12">
            @component('components.widget', ['title' => __('report.filters')])
                <form action="{{ route('dailyReports.index') }}" method="GET">
                    <div class="row">
                        <!-- Location Filter -->
                        
                        
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="location">{{ __('Location') }}</label>
                                <select name="location" id="location" class="form-control" onchange="this.form.submit()">
                                    <option value="">{{ __('All Locations') }}</option>
                                    @foreach($locations as $id => $name)
                                        <option value="{{ $id }}" {{ request('location') == $id ? 'selected' : '' }}>{{ $name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>

                        <!-- User Filter -->
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="user">{{ __('User') }}</label>
                                <select name="user" id="user" class="form-control" onchange="this.form.submit()">
                                    <option value="">{{ __('All Users') }}</option>
                                    @foreach($users as $id => $username)
                                        <option value="{{ $id }}" {{ request('user') == $id ? 'selected' : '' }}>{{ $username }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
		
                        <!-- Date Filter -->
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="date_filter">{{ __('Date Filter') }}</label>
                                <select name="date_filter" id="date_filter" class="form-control" onchange="this.form.submit()">
                                    <option value="">{{ __('All Dates') }}</option>
                                    <option value="today" {{ request('date_filter') == 'today' ? 'selected' : '' }}>{{ __('Today') }}</option>
                                    <option value="yesterday" {{ request('date_filter') == 'yesterday' ? 'selected' : '' }}>{{ __('Yesterday') }}</option>
                                    <option value="custom" {{ request('date_filter') == 'custom' ? 'selected' : '' }}>{{ __('Custom Date Range') }}</option>
                                </select>
                            </div>
                        </div>
	
		<div class="col-md-3"style="margin-top:15px;">
		    
<!-- Export Buttons -->
<div class="row no-print mt-5" >
    <div class="col-md-12">
        <div class="pull-right">
            <a href="{{ route('dailyReports.export.excel') . '?' . http_build_query(request()->query()) }}" 
               class="btn btn-success">
                <i class="fa fa-file-excel-o"></i> Export to Excel
            </a>
            
            <a href="{{ route('dailyReports.export.pdf') . '?' . http_build_query(request()->query()) }}" 
               class="btn btn-danger" 
               style="margin-left: 10px;">
                <i class="fa fa-file-pdf-o"></i> Export to PDF
            </a>
        </div>
    </div>
</div>
		</div>
		
		</div>
		
		<div class="row" >
		
                        <!-- Custom Date Range -->
                        <div class="col-md-3" id="custom_dates" style="{{ request('date_filter') != 'custom' ? 'display: none;' : '' }}">
                            <div class="form-group">
                                <label for="start_date">{{ __('Start Date') }}</label>
                                <input type="date" name="start_date" id="start_date" class="form-control" value="{{ request('start_date') }}" onchange="this.form.submit()">
                            </div>
                            </div>
                             <div class="col-md-3" id="custom_dates" style="{{ request('date_filter') != 'custom' ? 'display: none;' : '' }}">
                            <div class="form-group">
                                <label for="end_date">{{ __('End Date') }}</label>
                                <input type="date" name="end_date" id="end_date" class="form-control" value="{{ request('end_date') }}" onchange="this.form.submit()">
                            </div>
                        </div>

                    </div>
                    </div>
                </form>
            @endcomponent
        </div>
    </div>

    <div class="row">
        <div class="col-md-12">
            @component('components.widget', ['class' => 'box-primary'])
                <!-- Filter for number of rows to display -->
                <div class="row mb-3">
                    <div class="col-md-2" style="width:150px;">
                        <form action="{{ route('dailyReports.index') }}" method="GET">
                            <div class="form-group">
                                <label for="limit">Show rows:</label>
                                <select name="limit" id="limit" class="form-control" onchange="this.form.submit()">
                                    <option value="25" {{ request('limit') == 25 ? 'selected' : '' }}>25</option>
                                    <option value="50" {{ request('limit') == 50 ? 'selected' : '' }}>50</option>
                                    <option value="100" {{ request('limit') == 100 ? 'selected' : '' }}>100</option>
                                    <option value="200" {{ request('limit') == 200 ? 'selected' : '' }}>200</option>
                                    <option value="500" {{ request('limit') == 500 ? 'selected' : '' }}>500</option>
                                    <option value="1000" {{ request('limit') == 1000 ? 'selected' : '' }}>1000</option>
                                    <option value="10000" {{ request('limit') == 10000 ? 'selected' : '' }}>10000+</option>
                                </select>
                            </div>
                        </form>
                    </div>
                </div>

                <!-- Table to display transaction data -->
                <div style="max-height: 400px; overflow-y: auto; margin-bottom:-20px;"> <!-- Scrollable div for excess rows -->
                    <table class="table table-bordered">
                        <thead style="position: sticky; top: 0; background-color: white; z-index: 1; padding: 10px 0; font-weight: bold;">
                            <tr>
                                <th>#</th>
                                <th>Invoice No</th>
                                <th>Location</th>
                                <th>Date</th>
                                <th>Amount</th>
                                <th>Added By</th> 
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($transactions as $transaction)
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ $transaction->invoice_no }}</td>
                                    <td>{{ $transaction->location_name }}</td>
                                    <td>{{ \Carbon\Carbon::parse($transaction->transaction_date)->format('d/m/Y H:i') }}</td>
                                    <td>{{ number_format($transaction->final_total, 2) }}</td>
                                    <td>{{ $transaction->added_by }}</td>  <!-- Display "Added By" -->
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>

                <!-- Total Footer (Sticky) -->
                <div class="table-footer" style="position: sticky; bottom: 0; background-color: white; z-index: 1; padding: 10px 0; font-weight: bold;">
                    <table class="table">
                        <tfoot>
                            <tr>
                                <td colspan="5"></td>
                                 <td style="color:white;" ><strong>.</strong></td>
                                <td style="color:white;" ><strong>.</strong></td>
                                <td style="color:white;" ><strong>.</strong></td>
                                <td style="color:white;" ><strong>.</strong></td>
                                <td style="color:white;" ><strong>.</strong></td>
                                <td style="color:white;" ><strong>.</strong></td>
                                <td style="color:white;" ><strong>.</strong></td>
                                <td style="color:white;" ><strong>.</strong></td>
                                 <td style="color:white;" ><strong>.</strong></td>
                                <td><strong>Total:</strong></td>
                                <td><strong>{{ number_format($totalAmount, 2) }}</strong></td> 
                            </tr>
                        </tfoot>
                    </table>
                    
                    <!-- Pagination links -->
                <div class="pagination">
                    {{ $transactions->appends(request()->query())->links() }}
                </div>
                
                </div>
                <hr>
                
                 

                <!-- ============================================================= -->
<!-- NEW TABLE – CREDIT PAYMENTS (WITH TRANSACTION DATE & TIME) -->
<!-- ============================================================= -->
<div class="" style="margin-top:-10px;">
    <h4 class="tw-font-bold tw-text-lg">{{ __('Credit Payments') }}</h4>
    <div style="max-height: 400px; overflow-y: auto;">
        <table class="table table-bordered table-striped">
            <thead style="position: sticky; top: 0; background:#f8f9fa; z-index:1;">
                <tr>
                    <th>#</th>
                    <th>{{ __('Invoice No') }}</th>
                    <th>{{ __('Transaction Date') }}</th> <!-- NEW -->
                    <th>{{ __('Customer') }}</th>
                    <th>{{ __('Payment Method') }}</th>
                    <th>{{ __('Amount') }}</th>
                    <th>{{ __('Paid On') }}</th>
                </tr>
            </thead>
            <tbody>
               @forelse($creditPayments as $cp)
    @php
        // === PAYMENT METHOD – SAME LOGIC AS PAYMENT & EXPENSE SUMMARY ===
        $rawMethod = $cp->method;
        $method = ucfirst($rawMethod);

        if (in_array($method, ['Cash', 'Card', 'Bank Transfer', 'Cheque', 'Other'])) {
            // Standard method – keep as-is
        } else {
            // Custom method: use label from business settings
            $method = $customLabels[$rawMethod] ?? ucfirst(str_replace('_', ' ', $rawMethod));
        }

        $customer = $cp->customer_name ?? $cp->supplier_business_name ?? '-';
    @endphp
    <tr>
        <td>{{ $loop->iteration }}</td>
        <td>{{ $cp->invoice_no }}</td>
        <td>{{ $cp->sell_date?->format('d/m/Y H:i') ?? '-' }}</td>
        <td>{{ $customer }}</td>
        <td>{{ $method }}</td> <!-- NOW SHOWS M-Pesa, UPI, etc. -->
        <td>{{ number_format($cp->amount, 2) }}</td>
        <td>{{ $cp->paid_on?->format('d/m/Y H:i') ?? '-' }}</td>
    </tr>
@empty
    <tr>
        <td colspan="7" class="text-center text-muted">
            {{ __('No credit payments found for the selected filters.') }}
        </td>
    </tr>
@endforelse
            </tbody>
            <tfoot>
                <tr class="font-weight-bold bg-light">
                    <td colspan="5" class="text-right">{{ __('Total Credit Payments') }}:</td>
                    <td>{{ number_format($totalCreditAmount, 2) }}</td>
                    <td></td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>
                <hr>
                <!-- ============================================================= -->
                <!--  END OF NEW TABLE                                            -->
                <!-- ============================================================= -->
 
                
<!-- Payment Methods (Custom and Regular) -->
<div class="row">
    <div class="col-md-6" style="max-height: 500px; overflow-y: auto;">
        @component('components.widget', ['class' => 'box-primary'])
            <!-- Payment Methods -->
            <div class="card mt-3">
                <div class="card-header">
                    <h3 class="card-title">{{ __('Payment Summary') }}</h3>
                </div>
                <div class="card-body">
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th>Payment Method</th>
                                <th>Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($paymentMethodsFormatted as $method => $amount)
                                <tr>
                                    <td>{{ $method }}</td>
                                    <td>{{ number_format($amount, 2) }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        @endcomponent
    </div>

    <div class="col-md-6" style="max-height: 500px; overflow-y: auto;">
        @component('components.widget', ['class' => 'box-primary'])
            <!-- Expense Summary -->
            <div class="card mt-3">
                <div class="card-header">
                    <h3 class="card-title">{{ __('Expense Summary') }}</h3>
                </div>
                <div class="card-body">
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th>Expense Category</th>
                                <th>Amount</th>
                                <th>Payment Method</th>
                                
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($expensesFormatted as $expense)
                                <tr>
                                    <td>{{ $expense['category_name'] }}</td>
                                    <td>{{ number_format($expense['total_expense'], 2) }}</td>
                                    <td>{{ $expense['method'] }}</td>
                                    
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        @endcomponent
    </div>
</div>
<br>
<br>
<hr>
            <div class="row">
    <div class="col-md-12">
        @component('components.widget', ['class' => 'box-primary'])
            <div class="card mt-3">
                <div class="card-header">
                    <h3 class="card-title">{{ __('Money in Hand') }}</h3>
                </div>
                <div class="card-body">
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th>Payment Method</th>
                                <th style="display:none;">Amount</th>
                                <th>Amount in Hand</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $totalAmountInHand = 0; // Variable to keep track of the total amount in hand
                                // Get all unique payment methods from both summaries
                                $allPaymentMethods = collect($paymentMethodsFormatted)->keys()->merge(collect($expensesFormatted)->pluck('method'))->unique();
                            @endphp

                            @foreach($allPaymentMethods as $method)
                                @php
                                    // Get the payment amount for the current method, default to 0 if not found
                                    $paymentAmount = $paymentMethodsFormatted[$method] ?? 0;

                                    // Get all expenses for the current payment method, default to 0 if not found
                                    $matchingExpenses = collect($expensesFormatted)->filter(function($expense) use ($method) {
                                        return $expense['method'] == $method;
                                    });
                                    
                                    // Sum the total expense for the current payment method, default to 0 if not found
                                    $totalExpense = $matchingExpenses->sum('total_expense');
                                    
                                    // Calculate remaining amount (amount in hand)
                                    $remainingAmount = $paymentAmount - $totalExpense;
                                    $totalAmountInHand += $remainingAmount; // Add to the total
                                @endphp

                                <!-- Start a new row for each payment method -->
                                <tr>
                                    <!-- Payment Method and Amount (only shown once) -->
                                    <td>{{ $method }}</td>
                                    <td style="display:none;">{{ number_format($paymentAmount, 2) }}</td>
                                    <td>{{ number_format($remainingAmount, 2) }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                        <!-- Table Footer for total "Amount in Hand" -->
                        <tfoot>
                            <tr>
                                <td colspan="" class="text-right"><strong>{{ __('Total Amount in Hand') }}</strong></td>
                                <td><strong>{{ number_format($totalAmountInHand, 2) }}</strong></td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        @endcomponent
    </div>
</div>




               
            @endcomponent
        </div>
    </div>
</section>

@endsection

@section('javascript')
    <script>
        // JavaScript for handling custom date range toggle
        document.getElementById('date_filter').addEventListener('change', function() {
            var customDates = document.getElementById('custom_dates');
            if (this.value == 'custom') {
                customDates.style.display = 'block';
            } else {
                customDates.style.display = 'none';
            }
        });
    </script>
@endsection