@extends('layouts.app')

@section('page-title', 'Sales Report - Dashboard')

@section('content')

<div class="container-fluid">
	<div class="row">
		 <!-- Filters -->
    <div class="card mb-4">
        <div class="card-body">
            <form method="GET" action="{{ route('reports.sales') }}" class="row g-3">
                <div class="col-md-3">
                    <label for="month" class="form-label">Month</label>
                    <select class="form-select" id="month" name="month">
                        @foreach(['01' => 'January', '02' => 'February', '03' => 'March', '04' => 'April', '05' => 'May', '06' => 'June', '07' => 'July', '08' => 'August', '09' => 'September', '10' => 'October', '11' => 'November', '12' => 'December'] as $value => $label)
                            <option value="{{ $value }}" {{ $month == $value ? 'selected' : '' }}>{{ $label }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3">
                    <label for="year" class="form-label">Year</label>
                    <select class="form-select" id="year" name="year">
                        @for($y = now()->year; $y >= now()->year - 5; $y--)
                            <option value="{{ $y }}" {{ $year == $y ? 'selected' : '' }}>{{ $y }}</option>
                        @endfor
                    </select>
                </div>
                <div class="col-md-3 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary w-100">Generate Report</button>
                </div>
                <div class="col-md-3 d-flex align-items-end">
                    <a href="{{ route('reports.sales-print', ['month' => $month, 'year' => $year]) }}" target="_blank" class="btn btn-secondary w-100">
                        <i class="fas fa-print"></i> Print Report
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Main Content Area - Two Column Layout -->
    <div class="row g-4">
        <!-- LEFT SIDE: Sales Table -->
        <div class="col-lg-8">
            <div class="card h-100">
                <div class="card-header bg-white py-3">
                    <h5 class="mb-0 fw-bold text-dark">Sales Details - {{ \Carbon\Carbon::createFromDate($year, $month, 1)->format('F Y') }}</h5>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-sm table-bordered mb-0" style="font-size: 12px;">
                            <thead class="table-light">
                                <tr>
                                    <th class="text-start" style="width: 50px;">Date</th>
                                    <th class="text-start" style="width: 80px;">Invoice</th>
                                    <th class="text-start">Product</th>
                                    <th class="text-center" style="width: 50px;">QTY</th>
                                    <th class="text-end">Sales</th>
                                    <th class="text-start">Particulars</th>
                                    <th class="text-center">Payment</th>
                                    <th class="text-end">Due</th>
                                    <th class="text-end">COGS</th>
                                    <th class="text-end">Gross Profit</th>
                                    <th class="text-end" style="width: 50px;">%</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($salesLines as $line)
                                    <tr>
                                        <td>{{ $line['date']->format('j') }}</td>
                                        <td class="fw-medium">{{ $line['invoice_no'] }}</td>
                                        <td>{{ substr($line['product_name'], 0, 15) }}</td>
                                        <td class="text-center">{{ $line['qty'] }}</td>
                                        <td class="text-end">{{ number_format($line['total_sales'], 0) }}</td>
                                        <td>Payment</td>
                                        <td class="text-center">
                                            @if($line['payment_method'] === 'Paid')
                                                <span class="badge bg-success">{{ number_format($line['paid']) }}</span>
                                            @elseif($line['payment_method'] === 'Partial')
                                                <span class="badge bg-warning text-dark">{{ number_format($line['paid']) }}</span>
                                            @else
                                                <span class="badge bg-secondary">-</span>
                                            @endif
                                        </td>
                                        <td class="text-end">{{ number_format($line['due'], 0) }}</td>
                                        <td class="text-end">{{ number_format($line['cogs'], 0) }}</td>
                                        <td class="text-end">{{ number_format($line['gross_profit'], 0) }}</td>
                                        <td class="text-end">{{ number_format($line['percentage'], 0) }}%</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="11" class="text-center text-muted py-4">No sales data found for the selected period.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>

        <!-- RIGHT SIDE: Dashboard -->
        <div class="col-lg-4">
            <!-- Sales Summary Cards -->
            <div class="card mb-4">
                <div class="card-header bg-white py-3">
                    <h6 class="mb-0 fw-bold text-dark">Dashboard</h6>
                </div>
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center pb-3 mb-3 border-bottom">
                        <span class="text-muted small">Sales</span>
                        <span class="fw-bold text-success fs-5">{{ number_format($summary['total_sales'], 0) }}</span>
                    </div>
                    <div class="d-flex justify-content-between align-items-center pb-3 mb-3 border-bottom">
                        <span class="text-muted small">Cash Received By</span>
                        <span class="fw-bold text-primary fs-5">{{ number_format($summary['total_paid'], 0) }}</span>
                    </div>
                    <div class="d-flex justify-content-between align-items-center pb-3 mb-3 border-bottom">
                        <span class="text-muted small">Previous Due</span>
                        <span class="fw-bold text-secondary fs-5">-</span>
                    </div>
                    <div class="d-flex justify-content-between align-items-center pb-3 mb-3 border-bottom">
                        <span class="text-muted small">Others</span>
                        <span class="fw-bold text-secondary fs-5">-</span>
                    </div>
                    <div class="d-flex justify-content-between align-items-center pb-3 mb-3 border-bottom">
                        <span class="text-muted small">Total Income</span>
                        <span class="fw-bold text-info fs-5">{{ number_format($summary['total_paid'], 0) }}</span>
                    </div>
                    <div class="d-flex justify-content-between align-items-center">
                        <span class="text-muted small">Due</span>
                        <span class="fw-bold text-danger fs-5">{{ number_format($summary['total_due'], 0) }}</span>
                    </div>
                </div>
            </div>

            <!-- Payment Method Breakdown -->
            <div class="card mb-4">
                <div class="card-header bg-white py-3">
                    <h6 class="mb-0 fw-bold text-dark">Cash Received By</h6>
                </div>
                <div class="card-body p-0">
                    <table class="table table-sm mb-0" style="font-size: 12px;">
                        <thead class="table-light">
                            <tr>
                                <th class="text-start">Payment</th>
                                <th class="text-end">Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($paymentBreakdown as $method => $data)
                                <tr>
                                    <td>{{ $method }}</td>
                                    <td class="text-end fw-medium">{{ number_format($data['total'], 0) }}</td>
                                </tr>
                            @endforeach
                            <tr class="table-light fw-bold">
                                <td>Total</td>
                                <td class="text-end">{{ number_format($summary['total_paid'], 0) }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>

            <!-- Day Wise Sales -->
            <div class="card mb-4">
                <div class="card-header bg-white py-3">
                    <h6 class="mb-0 fw-bold text-dark">Day Wise Sales</h6>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive" style="max-height: 300px;">
                        <table class="table table-sm table-bordered mb-0" style="font-size: 11px;">
                            <thead class="table-light position-sticky top-0">
                                <tr>
                                    <th class="text-center">Date</th>
                                    <th class="text-center">Qty</th>
                                    <th class="text-end">Amount</th>
                                    <th class="text-end">Costing</th>
                                    <th class="text-end">Cost PP</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($dayWiseSales as $day)
                                    <tr>
                                        <td class="text-center">{{ $day['day'] }}</td>
                                        <td class="text-center">{{ $day['qty'] }}</td>
                                        <td class="text-end">{{ number_format($day['amount'], 0) }}</td>
                                        <td class="text-end">{{ number_format($day['cogs'], 1) }}</td>
                                        <td class="text-end">{{ number_format($day['cost_per_item'], 1) }}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="5" class="text-center text-muted py-3">No data</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>

            <!-- Segment Wise Sale -->
            <div class="card">
                <div class="card-header bg-white py-3">
                    <h6 class="mb-0 fw-bold text-dark">Segment Wise Sale</h6>
                </div>
                <div class="card-body p-0">
                    <table class="table table-sm table-bordered mb-0" style="font-size: 11px;">
                        <thead class="table-light">
                            <tr>
                                <th class="text-start">Segment</th>
                                <th class="text-center">QTY</th>
                                <th class="text-end">Amount</th>
                                <th class="text-center">KPI</th>
                                <th class="text-end">Revenue</th>
                                <th class="text-end">Achiv</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($segmentWiseSales as $segment)
                                @php
                                    $hasSegmentData = $segmentWiseSales->contains(function($seg) {
                                        return $seg['qty'] > 0 || $seg['amount'] > 0;
                                    });
                                @endphp
                                @if($loop->first && !$hasSegmentData)
                                    <tr>
                                        <td colspan="6" class="text-center text-muted py-3">No segment data</td>
                                    </tr>
                                    @break
                                @endif
                                <tr>
                                    <td>{{ $segment['segment_name'] }}</td>
                                    <td class="text-center">{{ $segment['qty'] }}</td>
                                    <td class="text-end">{{ number_format($segment['amount'], 0) }}</td>
                                    <td class="text-center">{{ $segment['kpi'] }}</td>
                                    <td class="text-end">{{ number_format($segment['revenue'], 0) }}</td>
                                    <td class="text-end">{{ $segment['achievement'] }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="6" class="text-center text-muted py-3">No segment data</td>
                                </tr>
                            @endforelse
                            <tr class="table-light fw-bold">
                                <td>Total</td>
                                <td class="text-center">-</td>
                                <td class="text-end">-</td>
                                <td class="text-center">-</td>
                                <td class="text-end">-</td>
                                <td class="text-end">-</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>


	</div>
</div>
@endsection