@extends('layouts.app')
@section('title', 'Dashboard de Costos')
@section('page-title', 'Costos Operativos')
@section('breadcrumb')
    <li class="breadcrumb-item active">Costos</li>
@endsection
@section('content')

{{-- ═══ FILTRO ═══ --}}
<form method="GET" class="mb-3">
    <div class="card card-outline card-primary">
        <div class="card-body py-2">
            <div class="row align-items-center">
                <div class="col-auto">
                    <label class="small mb-0">Año</label>
                    <select name="year" class="form-control form-control-sm">
                        @for($y = now()->year; $y >= now()->year - 3; $y--)
                        <option value="{{ $y }}" {{ $y == $year ? 'selected' : '' }}>{{ $y }}</option>
                        @endfor
                    </select>
                </div>
                <div class="col-auto">
                    <label class="small mb-0">Mes</label>
                    <select name="month" class="form-control form-control-sm">
                        @foreach(['Enero','Febrero','Marzo','Abril','Mayo','Junio','Julio','Agosto','Septiembre','Octubre','Noviembre','Diciembre'] as $i => $m)
                        <option value="{{ $i+1 }}" {{ ($i+1)==$month ? 'selected' : '' }}>{{ $m }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-auto mt-3">
                    <button class="btn btn-primary btn-sm"><i class="fas fa-search mr-1"></i>Filtrar</button>
                </div>
                <div class="col-auto mt-3 ml-auto">
                    <a href="{{ route('costos.gastos.create') }}" class="btn btn-outline-warning btn-sm mr-1">
                        <i class="fas fa-plus mr-1"></i>Registrar Gasto
                    </a>
                    <a href="{{ route('costos.despachos.create') }}" class="btn btn-outline-success btn-sm mr-1">
                        <i class="fas fa-dolly mr-1"></i>Nuevo Despacho
                    </a>
                    <a href="{{ route('costos.pdf.reporte', ['year' => request('year', now()->year), 'month' => request('month', now()->month)]) }}"
                       target="_blank" class="btn btn-danger btn-sm">
                        <i class="fas fa-file-pdf mr-1"></i>PDF Reporte
                    </a>
                </div>
            </div>
        </div>
    </div>
</form>

{{-- ═══ KPIs RESUMEN ═══ --}}
<div class="row">
    <div class="col-lg-2 col-md-4 col-6">
        <div class="small-box bg-danger">
            <div class="inner">
                <h4>S/ {{ number_format($totalCostos, 0) }}</h4>
                <p>Costo Total</p>
            </div>
            <div class="icon"><i class="fas fa-receipt"></i></div>
        </div>
    </div>
    <div class="col-lg-2 col-md-4 col-6">
        <div class="small-box bg-success">
            <div class="inner">
                <h4>S/ {{ number_format($totalVentas, 0) }}</h4>
                <p>Ventas del Mes</p>
            </div>
            <div class="icon"><i class="fas fa-chart-line"></i></div>
        </div>
    </div>
    <div class="col-lg-2 col-md-4 col-6">
        <div class="small-box {{ $resultado >= 0 ? 'bg-success' : 'bg-danger' }}">
            <div class="inner">
                <h4>S/ {{ number_format(abs($resultado), 0) }}</h4>
                <p>{{ $resultado >= 0 ? 'Resultado (+)' : 'Pérdida (-)' }}</p>
            </div>
            <div class="icon"><i class="fas fa-balance-scale"></i></div>
        </div>
    </div>
    <div class="col-lg-2 col-md-4 col-6">
        <div class="small-box {{ $margenGlobal >= 20 ? 'bg-success' : ($margenGlobal >= 0 ? 'bg-warning' : 'bg-danger') }}">
            <div class="inner">
                <h4>{{ number_format($margenGlobal, 1) }}%</h4>
                <p>Margen Neto</p>
            </div>
            <div class="icon"><i class="fas fa-percent"></i></div>
        </div>
    </div>
    <div class="col-lg-2 col-md-4 col-6">
        <div class="small-box bg-info">
            <div class="inner">
                <h4>{{ $numOPs }}</h4>
                <p>OPs del Mes</p>
            </div>
            <div class="icon"><i class="fas fa-industry"></i></div>
        </div>
    </div>
    <div class="col-lg-2 col-md-4 col-6">
        <div class="small-box bg-warning">
            <div class="inner">
                <h4>S/ {{ number_format($totalGastosFijos, 0) }}</h4>
                <p>Gastos Fijos</p>
            </div>
            <div class="icon"><i class="fas fa-building"></i></div>
        </div>
    </div>
</div>

<div class="row">
    {{-- ═══ DESGLOSE DE COSTOS ═══ --}}
    <div class="col-md-5">
        <div class="card">
            <div class="card-header py-2">
                <h6 class="mb-0"><i class="fas fa-chart-pie mr-2 text-danger"></i>Desglose de Costos del Mes</h6>
            </div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0">
                    <thead class="thead-light">
                        <tr><th>Concepto</th><th class="text-right">Monto</th><th class="text-right">%</th></tr>
                    </thead>
                    <tbody>
                    @php
                        $filas = [
                            ['Materia Prima',          $totalMP,            'text-primary',  'fas fa-apple-alt'],
                            ['Insumos Químicos',        $totalInsumos,       'text-info',     'fas fa-flask'],
                            ['Envases / Empaques',      $totalEnvases,       'text-secondary','fas fa-box'],
                            ['Mano de Obra Directa',    $totalMOD,           'text-success',  'fas fa-hard-hat'],
                            ['Mano de Obra Indirecta',  $totalMOI,           'text-warning',  'fas fa-user-tie'],
                        ];
                        $catLabels = \App\Models\GastoOperativo::$CATEGORIAS;
                    @endphp
                    @foreach($filas as [$label, $monto, $color, $icon])
                    <tr>
                        <td><i class="{{ $icon }} {{ $color }} mr-1"></i>{{ $label }}</td>
                        <td class="text-right font-weight-bold">S/ {{ number_format($monto, 2) }}</td>
                        <td class="text-right text-muted small">
                            {{ $totalCostos > 0 ? number_format(($monto/$totalCostos)*100, 1).'%' : '—' }}
                        </td>
                    </tr>
                    @endforeach
                    @foreach($gastosPorCategoria as $cat => $monto)
                    <tr>
                        <td>
                            <i class="fas fa-{{ $catLabels[$cat]['icon'] ?? 'circle' }} text-muted mr-1"></i>
                            {{ $catLabels[$cat]['label'] ?? $cat }}
                        </td>
                        <td class="text-right font-weight-bold">S/ {{ number_format($monto, 2) }}</td>
                        <td class="text-right text-muted small">
                            {{ $totalCostos > 0 ? number_format(($monto/$totalCostos)*100, 1).'%' : '—' }}
                        </td>
                    </tr>
                    @endforeach
                    </tbody>
                    <tfoot class="table-secondary font-weight-bold">
                        <tr>
                            <td>TOTAL COSTOS</td>
                            <td class="text-right">S/ {{ number_format($totalCostos, 2) }}</td>
                            <td class="text-right">100%</td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>

        {{-- Gastos Fijos registrados --}}
        <div class="card">
            <div class="card-header py-2 d-flex justify-content-between align-items-center">
                <h6 class="mb-0"><i class="fas fa-file-invoice-dollar mr-2 text-warning"></i>Gastos Operativos Registrados</h6>
                <a href="{{ route('costos.gastos.index', ['year'=>$year,'month'=>$month]) }}"
                   class="btn btn-outline-secondary btn-xs">Ver todos</a>
            </div>
            <div class="card-body p-0">
                @if($totalGastosFijos == 0)
                <div class="p-3 text-muted small text-center">
                    <i class="fas fa-exclamation-circle mr-1"></i>
                    No hay gastos registrados para este período.
                    <a href="{{ route('costos.gastos.create') }}">Registrar ahora</a>
                </div>
                @else
                <table class="table table-xs table-sm mb-0">
                    @foreach($gastosPorCategoria as $cat => $monto)
                    <tr>
                        <td class="pl-3">
                            <span class="badge badge-secondary">{{ \App\Models\GastoOperativo::$CATEGORIAS[$cat]['label'] ?? $cat }}</span>
                        </td>
                        <td class="text-right pr-3 font-weight-bold text-warning">S/ {{ number_format($monto, 2) }}</td>
                    </tr>
                    @endforeach
                </table>
                @endif
            </div>
        </div>
    </div>

    {{-- ═══ COSTO POR OP ═══ --}}
    <div class="col-md-7">
        <div class="card">
            <div class="card-header py-2">
                <h6 class="mb-0"><i class="fas fa-industry mr-2 text-primary"></i>Rentabilidad por Orden de Producción</h6>
            </div>
            <div class="card-body p-0">
                @if($resumenOPs->isEmpty())
                <div class="p-3 text-muted text-center small">No hay órdenes de producción en este período.</div>
                @else
                <div class="table-responsive">
                    <table class="table table-sm table-hover mb-0">
                        <thead class="thead-light">
                            <tr>
                                <th>OP</th>
                                <th class="text-right">C. Directo</th>
                                <th class="text-right">C. Indirecto</th>
                                <th class="text-right">Total Costo</th>
                                <th class="text-right">Venta</th>
                                <th class="text-right">Margen</th>
                                <th class="text-center">%</th>
                            </tr>
                        </thead>
                        <tbody>
                        @foreach($resumenOPs as $r)
                        @php
                            $pct = $r['margen_pct'];
                            $cls = is_null($pct) ? 'secondary' : ($pct >= 20 ? 'success' : ($pct >= 0 ? 'warning' : 'danger'));
                        @endphp
                        <tr>
                            <td>
                                <a href="{{ route('produccion.ordenes.show', $r['op']->id) }}" class="font-weight-bold">
                                    {{ $r['op']->numero }}
                                </a>
                                <div class="text-muted" style="font-size:.72rem">{{ $r['op']->tipo_produccion }}</div>
                            </td>
                            <td class="text-right small">S/ {{ number_format($r['costo_directo'], 2) }}</td>
                            <td class="text-right small">S/ {{ number_format($r['costo_moi'], 2) }}</td>
                            <td class="text-right font-weight-bold">S/ {{ number_format($r['costo_total'], 2) }}</td>
                            <td class="text-right text-success font-weight-bold">
                                {{ $r['precio_venta'] > 0 ? 'S/ '.number_format($r['precio_venta'], 2) : '—' }}
                            </td>
                            <td class="text-right font-weight-bold {{ $r['margen'] >= 0 ? 'text-success' : 'text-danger' }}">
                                {{ $r['precio_venta'] > 0 ? 'S/ '.number_format($r['margen'], 2) : '—' }}
                            </td>
                            <td class="text-center">
                                @if(!is_null($pct))
                                <span class="badge badge-{{ $cls }}">{{ number_format($pct, 1) }}%</span>
                                @else
                                <span class="text-muted small">—</span>
                                @endif
                            </td>
                        </tr>
                        {{-- Detalle costos expandible --}}
                        <tr class="table-light" style="font-size:.78rem">
                            <td class="pl-3 text-muted" colspan="2">
                                MP: S/ {{ number_format($r['costo_mp'],2) }} |
                                Ins: S/ {{ number_format($r['costo_insumos'],2) }} |
                                Env: S/ {{ number_format($r['costo_envases'],2) }}
                            </td>
                            <td colspan="5" class="text-muted">
                                MOD: S/ {{ number_format($r['costo_mod'],2) }}
                                (prorateado {{ $numOPs }} OP{{ $numOPs>1?'s':'' }})
                            </td>
                        </tr>
                        @endforeach
                        </tbody>
                        <tfoot class="table-secondary font-weight-bold">
                            <tr>
                                <td>TOTAL MES</td>
                                <td colspan="2"></td>
                                <td class="text-right">S/ {{ number_format($totalCostos, 2) }}</td>
                                <td class="text-right text-success">S/ {{ number_format($totalVentas, 2) }}</td>
                                <td class="text-right {{ $resultado >= 0 ? 'text-success' : 'text-danger' }}">
                                    S/ {{ number_format($resultado, 2) }}
                                </td>
                                <td class="text-center">
                                    <span class="badge badge-{{ $margenGlobal >= 20 ? 'success' : ($margenGlobal >= 0 ? 'warning' : 'danger') }}">
                                        {{ number_format($margenGlobal, 1) }}%
                                    </span>
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
                @endif
            </div>
        </div>

        {{-- Despachos del mes --}}
        <div class="card">
            <div class="card-header py-2 d-flex justify-content-between align-items-center">
                <h6 class="mb-0"><i class="fas fa-dolly mr-2 text-success"></i>Despachos de Materiales a Producción</h6>
                <a href="{{ route('costos.despachos.index') }}" class="btn btn-outline-secondary btn-xs">Ver todos</a>
            </div>
            <div class="card-body p-0">
                @if($despachosMes->isEmpty())
                <div class="p-3 text-muted small text-center">Sin despachos en este período.</div>
                @else
                <table class="table table-xs table-sm mb-0">
                    <thead class="thead-light">
                        <tr><th>N°</th><th>OP</th><th>Fecha</th><th>Estado</th><th class="text-right">Costo</th></tr>
                    </thead>
                    <tbody>
                    @foreach($despachosMes as $d)
                    <tr>
                        <td><a href="{{ route('costos.despachos.show', $d) }}">{{ $d->numero }}</a></td>
                        <td>{{ $d->ordenProduccion?->numero ?? '—' }}</td>
                        <td>{{ $d->fecha->format('d/m') }}</td>
                        <td>
                            <span class="badge badge-{{ $d->estado === 'entregado' ? 'success' : ($d->estado === 'parcial' ? 'warning' : 'secondary') }}">
                                {{ ucfirst($d->estado) }}
                            </span>
                        </td>
                        <td class="text-right font-weight-bold">S/ {{ number_format($d->costo_total, 2) }}</td>
                    </tr>
                    @endforeach
                    </tbody>
                </table>
                @endif
            </div>
        </div>
    </div>
</div>

@endsection