@extends('layouts.app')

@section('title', 'মিল রেট রিপোর্ট')

@php
    $monthLabel = date('F Y', mktime(0, 0, 0, (int) $selectedMonth, 1, (int) $selectedYear));
@endphp

@section('content')
<div class="page-controls">
    <div class="pc-left">
        <a href="{{ url('/admin/dashboard') }}" class="btn btn-outline btn-sm"><i class="fas fa-arrow-left"></i> পিছনের পেজ</a>
    </div>
    <div class="pc-right">
        <form method="GET" action="{{ url('/admin/meal-rate-report') }}" class="inline-form">
            <select name="month" onchange="this.form.submit()" class="input-inline">
                @for ($m = 1; $m <= 12; $m++)
                    <option value="{{ $m }}" {{ $m === $selectedMonth ? 'selected' : '' }}>{{ date('F', mktime(0, 0, 0, $m, 1)) }}</option>
                @endfor
            </select>
            <select name="year" onchange="this.form.submit()" class="input-inline">
                @for ($y = date('Y'); $y >= date('Y') - 2; $y--)
                    <option value="{{ $y }}" {{ $y === $selectedYear ? 'selected' : '' }}>{{ $y }}</option>
                @endfor
            </select>
        </form>
        @if (\App\Services\Feature::isActive('excel_export') && (!\App\Services\Feature::isSuperAdminOnly('excel_export') || ($currentUser->role ?? '') === 'superadmin'))
            <a href="{{ url('/admin/meal-rate-report/export') }}?month={{ $selectedMonth }}&year={{ $selectedYear }}" class="btn btn-success btn-sm"><i class="fas fa-file-excel"></i> এক্সেল ডাউনলোড</a>
        @endif
    </div>
</div>

<!-- KPI Cards -->
<div class="kpi-grid">
    <div class="kpi-card kpi-primary">
        <div class="kpi-icon"><i class="fas fa-calculator"></i></div>
        <div class="kpi-value">৳{{ number_format($realRate, 2) }}</div>
        <div class="kpi-label">মুল মিল রেট (প্রতি মিল)</div>
        <div class="kpi-bar"><span style="width:70%"></span></div>
    </div>
    <div class="kpi-card kpi-green">
        <div class="kpi-icon"><i class="fas fa-user"></i></div>
        <div class="kpi-value">৳{{ number_format($empRate, 2) }}</div>
        <div class="kpi-label">এমপ্লয়ি রেট (সদস্য দেবে)</div>
        <div class="kpi-bar"><span style="width:60%"></span></div>
    </div>
    <div class="kpi-card kpi-orange">
        <div class="kpi-icon"><i class="fas fa-building"></i></div>
        <div class="kpi-value">৳{{ number_format($companyRate, 2) }}</div>
        <div class="kpi-label">কোম্পানি রেট (সাবসিডি)</div>
        <div class="kpi-bar"><span style="width:45%"></span></div>
    </div>
    <div class="kpi-card kpi-pink">
        <div class="kpi-icon"><i class="fas fa-utensils"></i></div>
        <div class="kpi-value">{{ number_format($totalMeals, 1) }}</div>
        <div class="kpi-label">মোট মিল ({{ $monthLabel }})</div>
        <div class="kpi-bar"><span style="width:80%"></span></div>
    </div>
</div>

<!-- Daily Meal Rate Breakdown -->
<div class="card mt-4">
    <div class="card-head">
        <div class="card-title"><i class="fas fa-calendar-day icon-green"></i> প্রতিদিনের মিল রেট — {{ $monthLabel }}</div>
    </div>
    <div class="card-body card-body-table">
        <table class="table sortable-table">
            <thead>
                <tr>
                    <th>তারিখ</th>
                    <th class="text-right">মোট খরচ</th>
                    <th class="text-right">মোট মিল</th>
                    <th class="text-right">মিল রেট</th>
                    <th class="text-right">সদস্যের ভাগ (৳{{ number_format($empRate, 2) }}/মিল)</th>
                    <th class="text-right">কোম্পানি সাবসিডি</th>
                </tr>
            </thead>
            <tbody>
                @if (empty($dailyRows))
                    <tr><td colspan="6" class="empty-state"><i class="fas fa-chart-line"></i> এই মাসে কোনো খরচের ডেটা নেই।</td></tr>
                @else
                    @php $tExpense = 0; $tMeals = 0; $tEmp = 0; $tComp = 0; @endphp
                    @foreach ($dailyRows as $d)
                        @php
                            $tExpense += (float) $d['expense'];
                            $tMeals   += (float) $d['meals'];
                            $tEmp     += (float) $d['employee_share'];
                            $tComp    += (float) $d['company_share'];
                        @endphp
                        <tr>
                            <td data-sort="{{ $d['date'] }}"><strong>{{ date('d M Y', strtotime($d['date'])) }}</strong></td>
                            <td class="text-right">৳{{ number_format((float) $d['expense']) }}</td>
                            <td class="text-right">{{ number_format((float) $d['meals'], 1) }}</td>
                            <td class="text-right"><strong>৳{{ number_format((float) $d['rate'], 2) }}</strong></td>
                            <td class="text-right">৳{{ number_format((float) $d['employee_share']) }}</td>
                            <td class="text-right">
                                <span class="{{ (float) $d['company_share'] >= 0 ? 'text-success' : 'text-danger' }}">৳{{ number_format((float) $d['company_share']) }}</span>
                            </td>
                        </tr>
                    @endforeach
                    <tr class="table-footer">
                        <td><strong>মোট</strong></td>
                        <td class="text-right"><strong>৳{{ number_format($tExpense) }}</strong></td>
                        <td class="text-right"><strong>{{ number_format($tMeals, 1) }}</strong></td>
                        <td class="text-right"><strong>৳{{ $tMeals > 0 ? number_format($tExpense / $tMeals, 2) : '0' }}</strong></td>
                        <td class="text-right"><strong>৳{{ number_format($tEmp) }}</strong></td>
                        <td class="text-right"><strong>৳{{ number_format($tComp) }}</strong></td>
                    </tr>
                @endif
            </tbody>
        </table>
    </div>
</div>

<!-- Per Member Monthly Meal Rate -->
<div class="card mt-4">
    <div class="card-head">
        <div class="card-title"><i class="fas fa-file-invoice icon-primary"></i> সদস্য ও ম্যানেজার ওয়াইজ মিল রেট রিপোর্ট — {{ $monthLabel }}</div>
    </div>
    <div class="card-body card-body-table">
        <table class="table sortable-table">
            <thead>
                <tr>
                    <th>নাম</th>
                    <th>মিল</th>
                    <th class="text-right">সদস্যের ভাগ<br><small>(৳{{ number_format($empRate, 2) }} × মিল)</small></th>
                    <th class="text-right">কোম্পানি সাবসিডি</th>
                    <th class="text-right">টোটাল মিল রেট<br><small>(৳{{ number_format($realRate, 2) }} × মিল)</small></th>
                    <th class="text-right">জমা</th>
                    <th class="text-right">ডিউ / অগ্রিম</th>
                </tr>
            </thead>
            <tbody>
                @if (empty($rows))
                    <tr><td colspan="7" class="empty-state"><i class="fas fa-utensils"></i> এই মাসে কোনো মিল ডেটা নেই।</td></tr>
                @else
                    @php $mMeals = 0; $mEmp = 0; $mComp = 0; $mTotal = 0; $mPaid = 0; $mDue = 0; @endphp
                    @foreach ($rows as $r)
                        @php
                            $memberDue = (float) $r['payable'] - (float) $r['total_paid'];
                            $mMeals  += (float) $r['meals'];
                            $mEmp    += (float) $r['payable'];
                            $mComp   += (float) $r['company_subsidy'];
                            $mTotal  += (float) $r['total_meal_rate'];
                            $mPaid   += (float) $r['total_paid'];
                            $mDue    += $memberDue;
                        @endphp
                        <tr>
                            <td>
                                <div class="user-cell">
                                    <div class="user-avatar {{ ['avatar-green','avatar-orange','avatar-pink','avatar-red','avatar-blue','avatar-teal'][abs(crc32($r['name'])) % 6] }}" data-initial="{{ mb_substr($r['name'], 0, 1) }}"></div>
                                    <div class="user-meta-main">
                                        <strong>{{ $r['name'] }}</strong>
                                        <small>{{ $r['company_id'] }} {{ $r['designation'] ? '• ' . $r['designation'] : '' }}</small>
                                    </div>
                                </div>
                            </td>
                            <td>{{ number_format((float) $r['meals'], 1) }}</td>
                            <td class="text-right">৳{{ number_format((float) $r['payable']) }}</td>
                            <td class="text-right">
                                <span class="{{ (float) $r['company_subsidy'] >= 0 ? 'text-success' : 'text-danger' }}">৳{{ number_format((float) $r['company_subsidy']) }}</span>
                            </td>
                            <td class="text-right">৳{{ number_format((float) $r['total_meal_rate']) }}</td>
                            <td class="text-right">৳{{ number_format((float) $r['total_paid']) }}</td>
                            <td class="text-right">
                                <strong class="{{ $memberDue >= 0 ? 'text-danger' : 'text-success' }}">
                                    ৳{{ number_format(abs($memberDue)) }} {{ $memberDue >= 0 ? '(বকেয়া)' : '(অগ্রিম)' }}
                                </strong>
                            </td>
                        </tr>
                    @endforeach
                    <tr class="table-footer">
                        <td><strong>মোট</strong></td>
                        <td><strong>{{ number_format($mMeals, 1) }}</strong></td>
                        <td class="text-right"><strong>৳{{ number_format($mEmp) }}</strong></td>
                        <td class="text-right"><strong>৳{{ number_format($mComp) }}</strong></td>
                        <td class="text-right"><strong>৳{{ number_format($mTotal) }}</strong></td>
                        <td class="text-right"><strong>৳{{ number_format($mPaid) }}</strong></td>
                        <td class="text-right"><strong>৳{{ number_format(abs($mDue)) }}</strong></td>
                    </tr>
                @endif
            </tbody>
        </table>
    </div>
</div>
@endsection