@extends('layouts.main')

@push('styles')
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/dataTables.bootstrap5.min.css">
@endpush

@section('content')
<div class="container-fluid">
    <h1 class="h4 mb-4">Bricks Production Summary</h1>

    <div class="card">
        <div class="card mb-4">
            <div class="card-body">
                <form method="GET" id="filterForm" class="row g-3 align-items-end">
                    <div class="col-md-5">
                        <label for="start_date" class="form-label">Start Date</label>
                        <input type="date" name="start_date" id="start_date" class="form-control" value="{{ request('start_date') }}">
                    </div>
                    <div class="col-md-5">
                        <label for="end_date" class="form-label">End Date</label>
                        <input type="date" name="end_date" id="end_date" class="form-control" value="{{ request('end_date') }}">
                    </div>
                    <div class="col-md-2">
                        <button type="submit" class="btn btn-primary w-100">Filter</button>
                    </div>
                </form>
            </div>
        </div>

        <div class="card-body">
            <h5 class="mb-3">Open vs Closed Output</h5>
            <div class="table-responsive">
                <table class="table table-bordered table-striped">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Brick Type</th>
                            <th class="text-end">Open Stock Output</th>
                            <th class="text-end">Closed Stock Output</th>
                            <th class="text-end">Total Output</th>
                            <th class="text-end">Sold</th>
                            <th class="text-end">Current Stock</th>
                        </tr>
                    </thead>
                    <tbody id="summaryBody">
                        @foreach ($summary as $index => $item)
                            @php
                                $totalOutput = (int) $item->open_output + (int) $item->closed_output;
                                $sold = (int) ($item->sold_qty ?? 0);
                                $current = (int) ($item->current_stock ?? ($totalOutput - $sold));
                            @endphp
                            <tr>
                                <td>{{ $index + 1 }}</td>
                                <td>{{ $item->brickType->name ?? 'Unknown' }}</td>
                                <td class="text-end">{{ number_format($item->open_output) }}</td>
                                <td class="text-end">{{ number_format($item->closed_output) }}</td>
                                <td class="text-end">{{ number_format($totalOutput) }}</td>
                                <td class="text-end">{{ number_format($sold) }}</td>
                                <td class="text-end fw-bold {{ $current >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ number_format($current) }}
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <h4 class="mt-5">Expected vs Actual Output</h4>
    <div class="card">
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-bordered table-striped">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Brick Type</th>
                            <th class="text-end">Expected Output</th>
                            <th class="text-end">Actual Output</th>
                            <th class="text-end">Extra/Short Output</th>
                            <th class="text-end">Sold</th>
                            <th class="text-end">Current Stock</th>
                        </tr>
                    </thead>
                    <tbody id="totalsBody">
                        @foreach ($totals as $index => $item)
                            @php
                                $diff = (int)$item->actual_output - (int)$item->expected_output;
                                $class = $diff >= 0 ? 'text-success' : 'text-danger';
                                $prefix = $diff >= 0 ? '+' : '-';

                                $sold = (int) ($item->sold_qty ?? 0);
                                $current = (int) ($item->current_stock ?? ((int)$item->actual_output - $sold));
                            @endphp
                            <tr>
                                <td>{{ $index + 1 }}</td>
                                <td>{{ $item->brickType->name ?? 'Unknown' }}</td>
                                <td class="text-end">{{ number_format($item->expected_output) }}</td>
                                <td class="text-end">{{ number_format($item->actual_output) }}</td>
                                <td class="text-end">
                                    <span class="{{ $class }}">{{ $prefix }}{{ number_format(abs($diff)) }}</span>
                                </td>
                                <td class="text-end">{{ number_format($sold) }}</td>
                                <td class="text-end fw-bold {{ $current >= 0 ? 'text-success' : 'text-danger' }}">
                                    {{ number_format($current) }}
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection