{{-- Daily Sales Review Tab --}}
@php
    $reviewDateFrom = request()->query('ds_from', now()->startOfMonth()->toDateString());
    $reviewDateTo = request()->query('ds_to', now()->toDateString());
    
    $dailySalesRows = \App\Models\Transaction::query()
        ->where('txn_type', 'DailySales')
        ->where('status', 'Active')
        ->when(session('location_id'), function ($q) {
            $q->where(function ($w) {
                $w->where('location_id', session('location_id'))
                    ->orWhereNull('location_id');
            });
        })
        ->whereDate('txn_date', '>=', $reviewDateFrom)
        ->whereDate('txn_date', '<=', $reviewDateTo)
        ->orderByDesc('txn_date')
        ->get(['id', 'txn_date', 'amount', 'cash_amount', 'pos_amount', 'credit_amount', 'description', 'auto_note', 'user_id']);
    
    // Get offpos data for these dates
    $offposData = [];
    if (\Illuminate\Support\Facades\Schema::hasTable('offpos_day_summaries')) {
        $offposRows = \Illuminate\Support\Facades\DB::table('offpos_day_summaries')
            ->where('location_id', session('location_id'))
            ->whereBetween('sale_date', [$reviewDateFrom, $reviewDateTo])
            ->get(['sale_date', 'offpos_cash_total', 'offpos_card_total', 'genie_card_total']);
        foreach ($offposRows as $opr) {
            $offposData[$opr->sale_date] = $opr;
        }
    }
    
    // Calculate totals
    $totalCash = $dailySalesRows->sum('cash_amount');
    $totalPos = $dailySalesRows->sum('pos_amount');
    $totalCredit = $dailySalesRows->sum('credit_amount');
    $grandTotal = $dailySalesRows->sum('amount');
    $totalOffposCash = array_sum(array_column($offposData, 'offpos_cash_total'));
    $totalOffposCard = array_sum(array_column($offposData, 'offpos_card_total'));
@endphp

<div class="app-card overflow-hidden">
    <div class="p-6 text-gray-900 space-y-4">
        <form method="GET" action="{{ url('/accounting/history') }}" class="flex flex-wrap gap-4 items-end">
            <input type="hidden" name="tab" value="daily-sales">
            <div>
                <label class="block text-sm font-medium text-gray-700">From</label>
                <input type="date" name="ds_from" value="{{ $reviewDateFrom }}" class="mt-1 rounded border-gray-300">
            </div>
            <div>
                <label class="block text-sm font-medium text-gray-700">To</label>
                <input type="date" name="ds_to" value="{{ $reviewDateTo }}" class="mt-1 rounded border-gray-300">
            </div>
            <div class="flex gap-2">
                <button type="submit" class="px-4 py-2 bg-gray-800 text-white rounded">Load</button>
                <a href="{{ url('/accounting/history') }}?tab=daily-sales&ds_from={{ now()->startOfMonth()->toDateString() }}&ds_to={{ now()->toDateString() }}" 
                   class="px-4 py-2 bg-gray-100 text-gray-800 rounded">This Month</a>
                <a href="{{ url('/accounting/history') }}?tab=daily-sales&ds_from={{ now()->subMonth()->startOfMonth()->toDateString() }}&ds_to={{ now()->subMonth()->endOfMonth()->toDateString() }}" 
                   class="px-4 py-2 bg-gray-100 text-gray-800 rounded">Last Month</a>
            </div>
        </form>

        {{-- Summary Cards --}}
        <div class="grid grid-cols-2 md:grid-cols-6 gap-4">
            <div class="p-4 bg-green-50 rounded-lg">
                <div class="text-xs text-green-600 uppercase font-medium">Total Cash</div>
                <div class="text-xl font-bold text-green-700">{{ number_format($totalCash, 2) }}</div>
            </div>
            <div class="p-4 bg-blue-50 rounded-lg">
                <div class="text-xs text-blue-600 uppercase font-medium">Total POS/Card</div>
                <div class="text-xl font-bold text-blue-700">{{ number_format($totalPos, 2) }}</div>
            </div>
            <div class="p-4 bg-amber-50 rounded-lg">
                <div class="text-xs text-amber-600 uppercase font-medium">Total Credit</div>
                <div class="text-xl font-bold text-amber-700">{{ number_format($totalCredit, 2) }}</div>
            </div>
            <div class="p-4 bg-purple-50 rounded-lg">
                <div class="text-xs text-purple-600 uppercase font-medium">Off-POS Cash</div>
                <div class="text-xl font-bold text-purple-700">{{ number_format($totalOffposCash, 2) }}</div>
            </div>
            <div class="p-4 bg-indigo-50 rounded-lg">
                <div class="text-xs text-indigo-600 uppercase font-medium">Off-POS Card</div>
                <div class="text-xl font-bold text-indigo-700">{{ number_format($totalOffposCard, 2) }}</div>
            </div>
            <div class="p-4 bg-gray-100 rounded-lg">
                <div class="text-xs text-gray-600 uppercase font-medium">Grand Total</div>
                <div class="text-xl font-bold text-gray-800">{{ number_format($grandTotal, 2) }}</div>
            </div>
        </div>

        {{-- Daily Sales Table --}}
        <div class="overflow-x-auto">
            <table class="min-w-full divide-y divide-gray-200 text-sm">
                <thead class="bg-gray-50">
                    <tr>
                        <th class="px-3 py-2 text-left font-medium text-gray-500 uppercase tracking-wider">Date</th>
                        <th class="px-3 py-2 text-right font-medium text-gray-500 uppercase tracking-wider">Cash</th>
                        <th class="px-3 py-2 text-right font-medium text-gray-500 uppercase tracking-wider">POS/Card</th>
                        <th class="px-3 py-2 text-right font-medium text-gray-500 uppercase tracking-wider">Credit</th>
                        <th class="px-3 py-2 text-right font-medium text-gray-500 uppercase tracking-wider">Total</th>
                        <th class="px-3 py-2 text-right font-medium text-gray-500 uppercase tracking-wider">Off-POS Cash</th>
                        <th class="px-3 py-2 text-right font-medium text-gray-500 uppercase tracking-wider">Off-POS Card</th>
                        <th class="px-3 py-2 text-left font-medium text-gray-500 uppercase tracking-wider">Note</th>
                        <th class="px-3 py-2 text-center font-medium text-gray-500 uppercase tracking-wider">Action</th>
                    </tr>
                </thead>
                <tbody class="bg-white divide-y divide-gray-200">
                    @forelse ($dailySalesRows as $ds)
                        @php
                            $txnDateOnly = \Carbon\Carbon::parse($ds->txn_date)->format('Y-m-d');
                            $offpos = $offposData[$txnDateOnly] ?? null;
                            $offposCash = $offpos ? (float) $offpos->offpos_cash_total : 0;
                            $offposCard = $offpos ? (float) $offpos->offpos_card_total : 0;
                        @endphp
                        <tr class="hover:bg-gray-50">
                            <td class="px-3 py-2 whitespace-nowrap font-medium">
                                {{ \Carbon\Carbon::parse($ds->txn_date)->format('M d, Y') }}
                                <div class="text-xs text-gray-500">{{ \Carbon\Carbon::parse($ds->txn_date)->format('l') }}</div>
                            </td>
                            <td class="px-3 py-2 text-right whitespace-nowrap text-green-700">
                                {{ number_format((float) $ds->cash_amount, 2) }}
                            </td>
                            <td class="px-3 py-2 text-right whitespace-nowrap text-blue-700">
                                {{ number_format((float) $ds->pos_amount, 2) }}
                            </td>
                            <td class="px-3 py-2 text-right whitespace-nowrap text-amber-700">
                                {{ number_format((float) $ds->credit_amount, 2) }}
                            </td>
                            <td class="px-3 py-2 text-right whitespace-nowrap font-semibold">
                                {{ number_format((float) $ds->amount, 2) }}
                            </td>
                            <td class="px-3 py-2 text-right whitespace-nowrap text-purple-600">
                                @if($offposCash > 0)
                                    {{ number_format($offposCash, 2) }}
                                @else
                                    <span class="text-gray-400">-</span>
                                @endif
                            </td>
                            <td class="px-3 py-2 text-right whitespace-nowrap text-indigo-600">
                                @if($offposCard > 0)
                                    {{ number_format($offposCard, 2) }}
                                @else
                                    <span class="text-gray-400">-</span>
                                @endif
                            </td>
                            <td class="px-3 py-2 max-w-xs truncate" title="{{ $ds->description }}">
                                {{ $ds->description ?? '-' }}
                            </td>
                            <td class="px-3 py-2 text-center whitespace-nowrap">
                                <a href="{{ url('/accounting/daily-sales') }}?date={{ $txnDateOnly }}" 
                                   class="text-xs text-indigo-600 underline">View</a>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="9" class="px-3 py-8 text-center text-sm text-gray-500">
                                No daily sales found for this period.
                            </td>
                        </tr>
                    @endforelse
                </tbody>
                @if($dailySalesRows->count() > 0)
                    <tfoot class="bg-gray-50 font-semibold">
                        <tr>
                            <td class="px-3 py-2">Total ({{ $dailySalesRows->count() }} days)</td>
                            <td class="px-3 py-2 text-right text-green-700">{{ number_format($totalCash, 2) }}</td>
                            <td class="px-3 py-2 text-right text-blue-700">{{ number_format($totalPos, 2) }}</td>
                            <td class="px-3 py-2 text-right text-amber-700">{{ number_format($totalCredit, 2) }}</td>
                            <td class="px-3 py-2 text-right">{{ number_format($grandTotal, 2) }}</td>
                            <td class="px-3 py-2 text-right text-purple-600">{{ number_format($totalOffposCash, 2) }}</td>
                            <td class="px-3 py-2 text-right text-indigo-600">{{ number_format($totalOffposCard, 2) }}</td>
                            <td colspan="2"></td>
                        </tr>
                    </tfoot>
                @endif
            </table>
        </div>

        <div class="text-xs text-gray-500">
            <strong>Note:</strong> Off-POS amounts are from the Off-POS day summaries (captured during Daily Sales submission).
            Cash and POS totals include both system sales and Off-POS amounts.
        </div>
    </div>
</div>