@extends('layouts.dashboard.superadminapp')

@section('title', 'Machine Report')

@section('styles')
<style>
    div.dt-buttons {
        float: left;
        display: flex !important;
    }
    .dataTable {
        overflow-x: auto !important;
        display: table !important;
    }
    .dt-buttons .btn {
        margin-right: 0.5rem !important;
        padding: 0.25rem 0.75rem !important;
        font-size: 0.95rem !important;
    }
    .stat-card {
        border-radius: 10px;
        padding: 20px;
        text-align: center;
        color: #fff;
        transition: transform 0.2s;
    }
    .stat-card:hover {
        transform: translateY(-3px);
    }
    .stat-card .stat-value {
        font-size: 1.8rem;
        font-weight: bold;
    }
    .stat-card .stat-label {
        font-size: 0.85rem;
        opacity: 0.9;
    }
    .bg-total { background: linear-gradient(135deg, #4e73df 0%, #224abe 100%); }
    .bg-active { background: linear-gradient(135deg, #1cc88a 0%, #13855c 100%); }
    .bg-process { background: linear-gradient(135deg, #36b9cc 0%, #258391 100%); }
    .bg-hours { background: linear-gradient(135deg, #f6c23e 0%, #dda20a 100%); }
    .bg-idle { background: linear-gradient(135deg, #e74a3b 0%, #be2617 100%); }
</style>
@endsection

@section('content')

<!-- Page Heading -->
<div class="bg-white p-2 d-sm-flex align-items-center justify-content-between mb-4">
    <h1 class="h5 mb-0 text-gray-800">UEPL | Machine Report</h1>
    <div class="display-date">
        <span id="day">day</span>,
        <span id="daynum">00</span>
        <span id="month">month</span>
        <span id="year">0000</span>
    </div>
    <div class="display-time"></div>
</div>

<!-- Alerts -->
@if(session('success'))
    <div class="alert alert-success alert-dismissible fade show" role="alert">
        <i class="fas fa-check-circle mr-2"></i>{{ session('success') }}
        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
            <span aria-hidden="true">&times;</span>
        </button>
    </div>
@endif
@if(session('error'))
    <div class="alert alert-danger alert-dismissible fade show" role="alert">
        <i class="fas fa-exclamation-circle mr-2"></i>{{ session('error') }}
        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
            <span aria-hidden="true">&times;</span>
        </button>
    </div>
@endif

<!-- Filter Card -->
<div class="card shadow mb-4">
    <div class="card-header py-3" style="background: linear-gradient(135deg, #6c757d 0%, #495057 100%);">
        <h6 class="m-0 font-weight-bold text-white">
            <i class="fas fa-filter mr-2"></i> Filter Options
        </h6>
    </div>
    <div class="card-body">
        <form id="machineReportFilters" method="POST" action="{{ route('superadmin.report.machinereport') }}">
            @csrf
            <div class="row align-items-end">
                <div class="col-md-4 mb-3">
                    <label class="small font-weight-bold">Select Machine</label>
                    <select name="machine_id" id="machine_id" class="form-control">
                        <option value="">All Machines</option>
                        @foreach($machineNames as $id => $name)
                            <option value="{{ $id }}" {{ $selectedMachine == $id ? 'selected' : '' }}>
                                {{ $name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-4 mb-3">
                    <button type="submit" class="btn btn-primary btn-sm mr-2">
                        <i class="fas fa-search mr-1"></i> Apply Filter
                    </button>
                    <a href="{{ route('superadmin.report.machinereport') }}" class="btn btn-secondary btn-sm">
                        <i class="fas fa-redo mr-1"></i> Reset
                    </a>
                </div>
                <div class="col-md-4 mb-3 text-right">
                    <button type="button" class="btn btn-success btn-sm" id="exportExcelBtn">
                        <i class="fas fa-file-excel mr-1"></i> Export to Excel
                    </button>
                </div>
            </div>
        </form>
    </div>
</div>

@php
    $totalMachines = $machines->count();
    $machinesWithProcess = $machines->filter(fn($m) => $m->routeProcesses->count() > 0)->count();
    $totalProcesses = $machines->sum(fn($m) => $m->routeProcesses->count());
    $totalCycleHours = 0;
    $totalCycleMinutes = 0;

    foreach($machines as $machine) {
        foreach($machine->routeProcesses as $proc) {
            $totalCycleHours += (int)($proc->cycle_hours ?? 0);
            $totalCycleMinutes += (int)($proc->cycle_minutes ?? 0);
        }
    }
    // Convert excess minutes to hours
    $totalCycleHours += floor($totalCycleMinutes / 60);
    $totalCycleMinutes = $totalCycleMinutes % 60;
@endphp

<!-- Summary Statistics -->
<div class="row mb-4">
    <div class="col-xl-3 col-md-6 mb-3">
        <div class="stat-card bg-total">
            <div class="stat-value">{{ $totalMachines }}</div>
            <div class="stat-label"><i class="fas fa-cogs mr-1"></i> Total Machines</div>
        </div>
    </div>
    <div class="col-xl-3 col-md-6 mb-3">
        <div class="stat-card bg-active">
            <div class="stat-value">{{ $machinesWithProcess }}</div>
            <div class="stat-label"><i class="fas fa-check-circle mr-1"></i> Active Machines</div>
        </div>
    </div>
    <div class="col-xl-3 col-md-6 mb-3">
        <div class="stat-card bg-process">
            <div class="stat-value">{{ $totalProcesses }}</div>
            <div class="stat-label"><i class="fas fa-tasks mr-1"></i> Total Processes</div>
        </div>
    </div>
    <div class="col-xl-3 col-md-6 mb-3">
        <div class="stat-card bg-hours">
            <div class="stat-value">{{ $totalCycleHours }}:{{ str_pad($totalCycleMinutes, 2, '0', STR_PAD_LEFT) }}</div>
            <div class="stat-label"><i class="fas fa-clock mr-1"></i> Total Cycle Time</div>
        </div>
    </div>
</div>

<!-- Machine Report Table -->
<div class="card shadow mb-4">
    <div class="card-header py-3" style="background: linear-gradient(135deg, #4e73df 0%, #224abe 100%);">
        <h6 class="m-0 font-weight-bold text-white">
            <i class="fas fa-industry mr-2"></i> Machine Production Report
        </h6>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table id="machineTable" class="table table-bordered table-striped table-sm" width="100%">
                <thead class="thead-light">
                    <tr class="text-center">
                        <th>Machine Name</th>
                        <th>Serial No</th>
                        <th>Make</th>
                        <th>Model</th>
                        <th>Diameter</th>
                        <th>Length</th>
                        <th>Weight</th>
                        <th>Route Card No</th>
                        <th>Route Date</th>
                        <th>Order No</th>
                        <th>Process</th>
                        <th>Operator</th>
                        <th>Cycle Time</th>
                        <th>Start Date</th>
                        <th>End Date</th>
                        <th>Status</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($machines as $machine)
                        @if($machine->routeProcesses->count())
                            @foreach($machine->routeProcesses as $proc)
                                <tr class="text-center">
                                    <td class="text-left font-weight-bold">{{ $machine->machine_name }}</td>
                                    <td>{{ $machine->machine_sl_no ?? '-' }}</td>
                                    <td>{{ $machine->make ?? '-' }}</td>
                                    <td>{{ $machine->model_type ?? '-' }}</td>
                                    <td>{{ $machine->diameter ?? '-' }}</td>
                                    <td>{{ $machine->length ?? '-' }}</td>
                                    <td>{{ $machine->weight ?? '-' }}</td>
                                    <td>
                                        @if($proc->routeCard)
                                            <span class="badge badge-primary">{{ $proc->routeCard->route_no }}</span>
                                        @else
                                            -
                                        @endif
                                    </td>
                                    <td>{{ $proc->routeCard->route_date ? \Carbon\Carbon::parse($proc->routeCard->route_date)->format('d-m-Y') : '-' }}</td>
                                    <td>{{ $proc->routeCard->order_no ?? '-' }}</td>
                                    <td class="text-left">{{ $proc->process ?? '-' }}</td>
                                    <td>{{ $proc->operatorUser->name ?? '-' }}</td>
                                    <td>
                                        @if($proc->cycle_hours || $proc->cycle_minutes)
                                            <span class="badge badge-info">
                                                {{ $proc->cycle_hours ?? 0 }}h {{ $proc->cycle_minutes ?? 0 }}m
                                            </span>
                                        @else
                                            -
                                        @endif
                                    </td>
                                    <td>{{ $proc->start_date ? \Carbon\Carbon::parse($proc->start_date)->format('d-m-Y') : '-' }}</td>
                                    <td>{{ $proc->end_date ? \Carbon\Carbon::parse($proc->end_date)->format('d-m-Y') : '-' }}</td>
                                    <td>
                                        @if($proc->end_date)
                                            <span class="badge badge-success">Completed</span>
                                        @elseif($proc->start_date)
                                            <span class="badge badge-warning">In Progress</span>
                                        @else
                                            <span class="badge badge-secondary">Pending</span>
                                        @endif
                                    </td>
                                </tr>
                            @endforeach
                        @else
                            <tr class="text-center">
                                <td class="text-left font-weight-bold">{{ $machine->machine_name }}</td>
                                <td>{{ $machine->machine_sl_no ?? '-' }}</td>
                                <td>{{ $machine->make ?? '-' }}</td>
                                <td>{{ $machine->model_type ?? '-' }}</td>
                                <td>{{ $machine->diameter ?? '-' }}</td>
                                <td>{{ $machine->length ?? '-' }}</td>
                                <td>{{ $machine->weight ?? '-' }}</td>
                                <td>-</td>
                                <td>-</td>
                                <td>-</td>
                                <td class="text-muted"><i class="fas fa-info-circle"></i> No process</td>
                                <td>-</td>
                                <td>-</td>
                                <td>-</td>
                                <td>-</td>
                                <td><span class="badge badge-secondary">Idle</span></td>
                            </tr>
                        @endif
                    @empty
                        <tr>
                            <td colspan="16" class="text-center text-muted py-4">
                                <i class="fas fa-inbox fa-2x mb-2 d-block"></i>
                                No machine records found.
                            </td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>

<!-- Machine Summary by Status -->
<div class="row">
    <div class="col-md-6">
        <div class="card shadow mb-4">
            <div class="card-header py-3" style="background: linear-gradient(135deg, #1cc88a 0%, #13855c 100%);">
                <h6 class="m-0 font-weight-bold text-white">
                    <i class="fas fa-chart-pie mr-2"></i> Machines with Active Processes
                </h6>
            </div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0">
                    <thead class="thead-light">
                        <tr>
                            <th>Machine</th>
                            <th class="text-center">Processes</th>
                            <th class="text-center">Total Cycle Time</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $activeMachines = $machines->filter(fn($m) => $m->routeProcesses->count() > 0)->take(5);
                        @endphp
                        @forelse($activeMachines as $machine)
                            @php
                                $machineHours = 0;
                                $machineMinutes = 0;
                                foreach($machine->routeProcesses as $proc) {
                                    $machineHours += (int)($proc->cycle_hours ?? 0);
                                    $machineMinutes += (int)($proc->cycle_minutes ?? 0);
                                }
                                $machineHours += floor($machineMinutes / 60);
                                $machineMinutes = $machineMinutes % 60;
                            @endphp
                            <tr>
                                <td>{{ $machine->machine_name }}</td>
                                <td class="text-center">
                                    <span class="badge badge-primary">{{ $machine->routeProcesses->count() }}</span>
                                </td>
                                <td class="text-center">
                                    <span class="badge badge-info">{{ $machineHours }}h {{ $machineMinutes }}m</span>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="3" class="text-center text-muted">No active machines</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <div class="col-md-6">
        <div class="card shadow mb-4">
            <div class="card-header py-3" style="background: linear-gradient(135deg, #e74a3b 0%, #be2617 100%);">
                <h6 class="m-0 font-weight-bold text-white">
                    <i class="fas fa-exclamation-triangle mr-2"></i> Idle Machines (No Process)
                </h6>
            </div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0">
                    <thead class="thead-light">
                        <tr>
                            <th>Machine</th>
                            <th>Serial No</th>
                            <th>Make/Model</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $idleMachines = $machines->filter(fn($m) => $m->routeProcesses->count() == 0)->take(5);
                        @endphp
                        @forelse($idleMachines as $machine)
                            <tr>
                                <td>{{ $machine->machine_name }}</td>
                                <td>{{ $machine->machine_sl_no ?? '-' }}</td>
                                <td>{{ $machine->make ?? '-' }} / {{ $machine->model_type ?? '-' }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="3" class="text-center text-muted">All machines are active</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

@endsection

@section('scripts')
<script>
$(document).ready(function() {
    $('#machineTable').DataTable({
        dom: 'Bfrtip',
        buttons: [
            { extend: 'copy', className: 'btn btn-secondary btn-sm' },
            { extend: 'csv', className: 'btn btn-secondary btn-sm' },
            { extend: 'excel', className: 'btn btn-secondary btn-sm' },
            { extend: 'pdf', className: 'btn btn-secondary btn-sm' },
            { extend: 'print', className: 'btn btn-secondary btn-sm' },
            { extend: 'colvis', className: 'btn btn-secondary btn-sm' }
        ],
        pageLength: 25,
        responsive: true,
        order: [[0, 'asc']],
        language: {
            emptyTable: "No machine records found"
        }
    });

    // Export Excel logic
    $('#exportExcelBtn').click(function() {
        let form = $('#machineReportFilters');
        let originalAction = form.attr('action');
        form.attr('action', '{{ route('superadmin.report.machinereport.export') }}');
        form.attr('target', '_blank');
        form.submit();
        setTimeout(function() {
            form.attr('action', originalAction);
            form.removeAttr('target');
        }, 100);
    });
});
</script>
@endsection