@extends('layouts.app')
@section('title', 'স্টক রিপোর্ট')
@section('page-title', 'স্টক রিপোর্ট')

@section('content')

{{-- Report Nav --}}
<div class="d-flex gap-2 mb-4 flex-wrap">
    <a href="{{ route('admin.reports.sales') }}" class="btn btn-outline-primary btn-sm rounded-pill">
        <i class="bi bi-graph-up me-1"></i>বিক্রয়
    </a>
    <a href="{{ route('admin.reports.stock') }}" class="btn btn-warning btn-sm rounded-pill">
        <i class="bi bi-fire me-1"></i>স্টক
    </a>
    <a href="{{ route('admin.reports.due-customers') }}" class="btn btn-outline-danger btn-sm rounded-pill">
        <i class="bi bi-exclamation-circle me-1"></i>বকেয়া গ্রাহক
    </a>
    <a href="{{ route('admin.reports.delivery') }}" class="btn btn-outline-info btn-sm rounded-pill">
        <i class="bi bi-bicycle me-1"></i>ডেলিভারি
    </a>
</div>

{{-- Overall Stats --}}
<div class="row g-3 mb-4">
    @foreach([
        ['label'=>'মোট সিলিন্ডার','key'=>'total','color'=>'primary','icon'=>'fire'],
        ['label'=>'ভর্তি','key'=>'full','color'=>'success','icon'=>'check-circle-fill'],
        ['label'=>'খালি','key'=>'empty','color'=>'secondary','icon'=>'circle'],
        ['label'=>'পরিবহনে','key'=>'in_transit','color'=>'warning','icon'=>'truck'],
        ['label'=>'ক্ষতিগ্রস্ত','key'=>'damaged','color'=>'danger','icon'=>'x-circle-fill'],
        ['label'=>'গ্রাহকে','key'=>'with_customer','color'=>'info','icon'=>'person-check-fill'],
        ['label'=>'গুদামে','key'=>'in_warehouse','color'=>'dark','icon'=>'house-fill'],
    ] as $s)
    <div class="col-6 col-md" style="min-width:120px">
        <div class="card stat-card text-center py-3">
            <i class="bi bi-{{ $s['icon'] }} text-{{ $s['color'] }} mb-1" style="font-size:1.5rem"></i>
            <div class="fs-3 fw-bold">{{ $overallStats[$s['key']] }}</div>
            <div class="small text-muted">{{ $s['label'] }}</div>
        </div>
    </div>
    @endforeach
</div>

{{-- Per Type Breakdown --}}
<div class="card stat-card mb-4">
    <div class="card-header bg-white border-0 pt-3">
        <h6 class="fw-semibold mb-0"><i class="bi bi-bar-chart text-primary me-2"></i>টাইপ অনুযায়ী স্টক</h6>
    </div>
    <div class="card-body">
        <canvas id="stockChart" height="80"></canvas>
    </div>
</div>

<div class="row g-4 mb-4">
    {{-- Type Table --}}
    <div class="col-lg-8">
        <div class="card stat-card h-100">
            <div class="card-header bg-white border-0 pt-3">
                <h6 class="fw-semibold mb-0">বিস্তারিত স্টক টেবিল</h6>
            </div>
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table class="table mb-0 align-middle">
                        <thead class="table-light">
                            <tr>
                                <th>টাইপ</th>
                                <th class="text-center text-success">ভর্তি</th>
                                <th class="text-center">খালি</th>
                                <th class="text-center text-warning">ট্রানজিট</th>
                                <th class="text-center text-danger">ক্ষতিগ্রস্ত</th>
                                <th class="text-center text-info">গ্রাহকে</th>
                                <th class="text-center">গুদামে</th>
                                <th class="text-center fw-bold">মোট</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($typeStock as $t)
                            <tr>
                                <td>
                                    <div class="fw-semibold">{{ $t->name }}</div>
                                    <small class="text-muted">৳{{ number_format($t->selling_price, 0) }}</small>
                                </td>
                                <td class="text-center"><span class="badge bg-success">{{ $t->full_count }}</span></td>
                                <td class="text-center"><span class="badge bg-secondary">{{ $t->empty_count }}</span></td>
                                <td class="text-center"><span class="badge bg-warning text-dark">{{ $t->in_transit_count }}</span></td>
                                <td class="text-center"><span class="badge bg-danger">{{ $t->damaged_count }}</span></td>
                                <td class="text-center"><span class="badge bg-info">{{ $t->with_customer_count }}</span></td>
                                <td class="text-center"><span class="badge bg-dark">{{ $t->in_warehouse_count }}</span></td>
                                <td class="text-center fw-bold fs-6">{{ $t->cylinders_count }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    {{-- Movement Trend Chart --}}
    <div class="col-lg-4">
        <div class="card stat-card h-100">
            <div class="card-header bg-white border-0 pt-3">
                <h6 class="fw-semibold mb-0"><i class="bi bi-arrow-left-right text-muted me-2"></i>মুভমেন্ট ট্রেন্ড (৬ মাস)</h6>
            </div>
            <div class="card-body">
                <canvas id="movementChart"></canvas>
            </div>
        </div>
    </div>
</div>

{{-- Cylinders at Customers --}}
<div class="card stat-card">
    <div class="card-header bg-white border-0 pt-3 d-flex justify-content-between align-items-center">
        <h6 class="fw-semibold mb-0">
            <i class="bi bi-person-check-fill text-info me-2"></i>গ্রাহকের কাছে থাকা সিলিন্ডার
            <span class="badge bg-info ms-2">{{ count($cylindersAtCustomers) }}</span>
        </h6>
        <a href="{{ route('admin.cylinders.tracking') }}" class="btn btn-sm btn-outline-info">
            লাইভ ট্র্যাকিং →
        </a>
    </div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-hover mb-0 align-middle small">
                <thead class="table-light">
                    <tr>
                        <th>সিলিন্ডার #</th>
                        <th>টাইপ</th>
                        <th>সিরিয়াল</th>
                        <th>গ্রাহকের নাম</th>
                        <th>গ্রাহকের ফোন</th>
                        <th>স্ট্যাটাস</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($cylindersAtCustomers as $cyl)
                    <tr>
                        <td><a href="{{ route('admin.cylinders.show', $cyl) }}" class="text-decoration-none fw-semibold">#{{ $cyl->id }}</a></td>
                        <td>{{ $cyl->cylinderType->name }}</td>
                        <td class="text-muted">{{ $cyl->serial_number ?? '—' }}</td>
                        <td class="fw-semibold">{{ $cyl->holder_model?->name ?? '—' }}</td>
                        <td class="text-muted">{{ $cyl->holder_model?->phone ?? '—' }}</td>
                        <td><span class="badge bg-{{ $cyl->status_color }}">{{ $cyl->status_label }}</span></td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="6" class="text-center text-muted py-4">সব সিলিন্ডার গুদামে আছে।</td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>

@endsection

@push('scripts')
<script src="https://cdn.jsdelivr.net/npm/chart.js@4.4.0/dist/chart.umd.min.js"></script>
<script>
// Stock Bar Chart
const typeLabels = @json($typeStock->pluck('name')->toArray());
new Chart(document.getElementById('stockChart'), {
    type: 'bar',
    data: {
        labels: typeLabels,
        datasets: [
            { label: 'ভর্তি',       data: @json($typeStock->pluck('full_count')->toArray()),          backgroundColor: '#198754' },
            { label: 'খালি',        data: @json($typeStock->pluck('empty_count')->toArray()),         backgroundColor: '#6c757d' },
            { label: 'পরিবহনে',     data: @json($typeStock->pluck('in_transit_count')->toArray()),    backgroundColor: '#ffc107' },
            { label: 'ক্ষতিগ্রস্ত', data: @json($typeStock->pluck('damaged_count')->toArray()),      backgroundColor: '#dc3545' },
            { label: 'গ্রাহকে',     data: @json($typeStock->pluck('with_customer_count')->toArray()), backgroundColor: '#0dcaf0' },
        ]
    },
    options: { responsive: true, plugins: { legend: { position: 'top' } }, scales: { x: { stacked: true }, y: { stacked: true, beginAtZero: true } } }
});

// Movement Trend
new Chart(document.getElementById('movementChart'), {
    type: 'line',
    data: {
        labels: @json($trendLabels),
        datasets: [
            { label: 'ইস্যু',   data: @json($trendIssued),   borderColor: '#0d6efd', backgroundColor: 'rgba(13,110,253,.1)', fill: true, tension: .4 },
            { label: 'ফেরত',    data: @json($trendReturned), borderColor: '#198754', backgroundColor: 'rgba(25,135,84,.1)',  fill: true, tension: .4 },
            { label: 'রিফিল',   data: @json($trendRefilled), borderColor: '#ffc107', backgroundColor: 'rgba(255,193,7,.1)',  fill: true, tension: .4 },
        ]
    },
    options: { responsive: true, plugins: { legend: { position: 'bottom', labels: { boxWidth: 12 } } }, scales: { y: { beginAtZero: true } } }
});
</script>
@endpush