@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])

@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])
    
    <div class="container-fluid py-4">
        <div class="card mb-4">
            <div class="card-body">
                <h6 class="text-uppercase text-sm mb-3">Filter Applied</h6>
                <div class="row">
                    <div class="col-md-4">
                        <strong>Kategori:</strong> 
                        @php
                            $kategoriMap = [
                                'CPU' => 'CPU',
                                'LCD' => 'Monitor',
                                'PRN' => 'Printer',
                                'SCN' => 'Scanner',
                                'SWT' => 'Switch',
                                'OTH' => 'Others',
                                'ALL' => 'ALL'
                            ];
                            echo $filter['kategori'] ?  ($kategoriMap[$filter['kategori']] ?? $filter['kategori']) : 'ALL';
                        @endphp
                    </div>
                    <div class="col-md-3">
                        <strong>Department:</strong> {{ $filter['dept'] ?: 'ALL' }}
                    </div>
                    <div class="col-md-3">
                        <strong>Code:</strong> {{ $filter['code'] ??  'ALL' }}
                    </div>
                    <div class="col-md-3">
                            <strong>User/Location:</strong> 
                            @if(! empty($filter['userName']))
                                {{ $filter['userName'] }}
                            @elseif(!empty($filter['locationName']))
                                {{ $filter['locationName'] }}
                            @elseif(!empty($filter['locationText']))
                                {{ $filter['locationText'] }}
                            @else
                                ALL
                            @endif
                        </div>
                    </div>
                     <div class="row mt-2">
                        <div class="col-md-6">
                            <strong>Date Range:</strong> 
                            @if($filter['startDate'] && $filter['endDate'])
                                {{ date('d/m/Y', strtotime($filter['startDate'])) }} - {{ date('d/m/Y', strtotime($filter['endDate'])) }}
                            @elseif($filter['startDate'])
                                From {{ date('d/m/Y', strtotime($filter['startDate'])) }}
                            @elseif($filter['endDate'])
                                Until {{ date('d/m/Y', strtotime($filter['endDate'])) }}
                            @else
                                ALL
                            @endif
                        </div>
                    </div>
                <div class="mt-3">
                    <a href="{{ url($url_menu) }}" class="btn btn-secondary">
                        <i class="fas fa-arrow-left me-1"></i> Back to Filter
                    </a>
                    <button onclick="window.print()" class="btn btn-info">
                        <i class="fas fa-print me-1"></i>
                    </button>
                    <button onclick="exportToExcel()" class="btn btn-success">
                        <i class="fas fa-file-excel me-1"></i>
                    </button>
                </div>
            </div>
        </div>

        <!-- Results - Grouped by Asset Code -->
        <div class="card">
            <div class="card-header pb-0">
                <h6>Movement Report Results ({{ $groupedMovements->count() }} Assets)</h6>
            </div>
            <div class="card-body px-0 pt-0 pb-2">
                @php
                    $sortedMovements = $groupedMovements->sortByDesc(function($movements) {
                        foreach($movements as $mov) {
                            $isDefect = stripos($mov->remark, 'DF') !== false || 
                                    stripos($mov->remark, 'defect') !== false || 
                                    stripos($mov->remark, 'rusak') !== false ||
                                    ($mov->move_type ??  '') === 'DF';
                            if ($isDefect) {
                                return 1;
                            }
                        }
                        return 0;
                    });
                @endphp
                @forelse($sortedMovements as $code => $movements)
                    @php
                        $firstMovement = $movements->first();
                        $lastMovement = $movements->last();
                        $secondLastMovement = $movements->skip(1)->first();
                        $totalMovements = $movements->count();
                        $kategoriDisplay = $kategoriMap[$lastMovement->kategori] ?? $lastMovement->kategori;
                        $displayOldCode = $secondLastMovement ? $secondLastMovement->new_code : $lastMovement->code;
                        $displayNewCode = $firstMovement->new_code;
                        
                        // Code asset paling awal (original code sebelum ada perpindahan)
                        $originalAssetCode = $lastMovement->code;
                        
                        // Check ALL movements if any is defect
                        $hasDefect = false;
                        $defectMovement = null;
                        $defectCode = null;
                        
                        foreach($movements as $mov) {
                            $isDefectRemark = stripos($mov->remark, 'DF') !== false || 
                                             stripos($mov->remark, 'defect') !== false || 
                                             stripos($mov->remark, 'rusak') !== false ||
                                             ($mov->move_type ?? '') === 'DF';
                            if ($isDefectRemark) {
                                $hasDefect = true;
                                if (!$defectMovement) { // Ambil yang pertama (paling baru)
                                    $defectMovement = $mov;
                                    $defectCode = $mov->new_code ?: $mov->code;
                                }
                            }
                        }
                        
                        // Header code: jika defect tampilkan code defect, jika tidak tampilkan original code
                        if ($hasDefect && $defectCode) {
                            $headerCode = $defectCode;
                        } else {
                            $headerCode = $originalAssetCode;
                        }
                    @endphp
                    
                    <div class="asset-card" style="margin: 1rem; padding: 1.25rem; background-color: #ffffff; border: 2px solid {{ $hasDefect ? '#f5365c' : '#e3e6f0' }}; border-radius: 8px; display: flex; flex-direction: column; height: 100%;">
                        <div>
                        <!-- Asset Header -->
                        <div class="row mb-3">
                            <div class="col-12">
                                <h6 class="mb-2">
                                    <span class="badge bg-gradient-primary me-2">{{ $kategoriDisplay }}</span>
                                    <strong>{{ $originalAssetCode }}</strong>
                                    <i class="fas fa-arrow-right mx-2" style="color: #6c757d;"></i>
                                    @if($hasDefect)
                                        <strong class="text-danger">{{ $headerCode }}</strong>
                                        <span class="badge bg-danger ms-3">
                                            <i class="fas fa-exclamation-triangle me-1"></i>
                                            RUSAK
                                        </span>
                                    @else
                                        <strong style="color: #28a745;">
                                            {{ $firstMovement->new_code ?: $firstMovement->code }}
                                        </strong>
                                        <span class="badge bg-success ms-3">
                                            <i class="fas fa-check-circle me-1"></i>
                                            CURRENT CODE
                                        </span>
                                    @endif
                                </h6>
                                
                                <!-- Movement Statistics -->
                                <div class="text-sm text-muted">
                                    <span class="me-3">
                                        <i class="fas fa-history me-1"></i>
                                        <strong>Total Movements:</strong> {{ $totalMovements }}
                                    </span>
                                    <span class="me-3">
                                        <strong>First Movement:</strong>
                                        @php
                                            $firstMovementDate = $lastMovement->master_date ??  $lastMovement->date;
                                        @endphp
                                        {{ $firstMovementDate ? date('d/m/Y', strtotime($firstMovementDate)) : '-' }}
                                    </span>
                                    <span class="{{ $hasDefect ? 'text-danger font-weight-bold' : '' }}">
                                        <strong>{{ $hasDefect ? 'Defect Date' : 'Last Movement' }}:</strong> 
                                        @php
                                            if ($hasDefect && $defectMovement) {
                                                // Untuk defect, gunakan date dari master table defect code
                                                $lastMovementDate = $defectMovement->new_code_master_date ?? $defectMovement->master_date ??  $defectMovement->date;
                                            } else {
                                                // Untuk normal, gunakan date dari master table new code (first movement dalam urutan DESC)
                                                $lastMovementDate = $firstMovement->new_code_master_date ?? $firstMovement->master_date ??  $firstMovement->date;
                                            }
                                        @endphp
                                        {{ $lastMovementDate ? date('d/m/Y', strtotime($lastMovementDate)) : '-' }}
                                    </span>
                                </div>
                            </div>
                        </div>

                        <!-- Movement History - Show ALL movements -->
                        <div class="row">
                            <div class="col-12">
                                <h6 class="text-uppercase text-xs font-weight-bolder mb-2">
                                    <i class="fas fa-exchange-alt me-1"></i>
                                    Movement History
                                </h6>
                                
                                <div class="table-responsive">
                                    <table class="table table-sm align-items-center mb-0">
                                        <thead class="bg-light">
                                            <tr>
                                                <th class="text-uppercase text-secondary text-xxs font-weight-bolder">Old Code</th>
                                                <th class="text-uppercase text-secondary text-xxs font-weight-bolder">From</th>
                                                <th class="text-uppercase text-secondary text-xxs font-weight-bolder">Duration</th>
                                                <th class="text-uppercase text-secondary text-xxs font-weight-bolder text-center">
                                                    <i class="fas fa-arrow-right"></i>
                                                </th>
                                                <th class="text-uppercase text-secondary text-xxs font-weight-bolder">New Code</th>
                                                <th class="text-uppercase text-secondary text-xxs font-weight-bolder">To</th>
                                                <th class="text-uppercase text-secondary text-xxs font-weight-bolder">Date Posting</th>
                                                {{-- <th class="text-uppercase text-secondary text-xxs font-weight-bolder">Duration</th> --}}
                                                <th class="text-uppercase text-secondary text-xxs font-weight-bolder">Kode SAP</th>
                                                <th class="text-uppercase text-secondary text-xxs font-weight-bolder">Remark</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $movementsAsc = $movements->reverse()->values();
                                                $totalCount = $movementsAsc->count();
                                            @endphp
                                            @foreach($movementsAsc as $index => $movement)
                                                @php
                                                    $isLastMovement = ($index == $totalCount - 1);
                                                    $nextMovement = $movementsAsc->get($index + 1);
                                                    $prevMovement = $index > 0 ?  $movementsAsc->get($index - 1) : null;
                                                    
                                                    $periodStart = date('d/m/Y', strtotime($movement->date));
                                                    if ($nextMovement) {
                                                        $periodEnd = date('d/m/Y', strtotime($nextMovement->date));
                                                    } else {
                                                        $periodEnd = $periodStart;
                                                    }
                                                    
                                                    $oldCode = $movement->code;
                                                    $newCode = $movement->new_code;
                                                    $isDefect = stripos($movement->remark, 'DF') !== false || 
                                                            stripos($movement->remark, 'defect') !== false || 
                                                            stripos($movement->remark, 'rusak') !== false ||
                                                                ($movement->move_type ??  '') === 'DF';
                                                    $rowClass = $isDefect ? 'table-danger bg-light-danger' : '';
                                                @endphp
                                                <tr class="{{ $rowClass }}">
                                                    <td class="text-xs">
                                                        <strong>{{ $oldCode }}</strong>
                                                    </td>
                                                    <td class="text-xs">
                                                        <div class="d-flex flex-column">
                                                            @if($movement->from_user_name)
                                                                <span class="mb-1">
                                                                    <i class="fas fa-user text-primary me-1"></i>
                                                                    <strong>{{ $movement->from_user_name }}</strong>
                                                                </span>
                                                            @elseif($movement->from_location_name)
                                                                <span class="mb-1">
                                                                    <i class="fas fa-warehouse text-warning me-1"></i>
                                                                    <strong>{{ $movement->from_location_name }}</strong>
                                                                </span>
                                                            @else
                                                                <span class="text-muted">-</span>
                                                            @endif
                                                            <small class="text-muted">
                                                                {{ $movement->from_dept }} | {{ $movement->from_area }}
                                                            </small>
                                                        </div>
                                                    </td>
                                                    <td class="text-xs">
                                                        <strong>{{ $movement->durasi_pemakaian ??  '-' }}</strong>
                                                        @if($movement->master_date_nonaktif)
                                                            <br><small class="text-muted">(Non-aktif: {{ date('d/m/Y', strtotime($movement->master_date_nonaktif)) }})</small>
                                                        @else
                                                            <br><small class="text-success">(Masih Aktif)</small>
                                                        @endif
                                                    </td>
                                                    <td class="text-center">
                                                        <i class="fas fa-arrow-right {{ $isDefect ? 'text-danger' : 'text-success' }}"></i>
                                                    </td>
                                                    <td class="text-xs">
                                                        @php
                                                            $isDefect = stripos($movement->remark, 'DF') !== false || 
                                                                        stripos($movement->remark, 'defect') !== false || 
                                                                        stripos($movement->remark, 'rusak') !== false ||
                                                                        ($movement->move_type ?? '') === 'DF';
                                                        @endphp

                                                        @if($isDefect)
                                                            <span class="badge bg-danger text-white">
                                                                <i class="fas fa-exclamation-triangle me-1"></i>
                                                                <strong class="text">RUSAK</strong>
                                                            </span>
                                                        @else
                                                            <strong>{{ $newCode ?: $oldCode }}</strong>
                                                        @endif
                                                    </td>
                                                    <td class="text-xs">
                                                        <div class="d-flex flex-column">
                                                            @if($movement->to_user_name)
                                                                <span class="mb-1">
                                                                    <i class="fas fa-user text-primary me-1"></i>
                                                                    <strong>{{ $movement->to_user_name }}</strong>
                                                                </span>
                                                            @elseif($movement->to_location_name)
                                                                <span class="mb-1">
                                                                    <i class="fas fa-warehouse text-warning me-1"></i>
                                                                    <strong>{{ $movement->to_location_name }}</strong>
                                                                </span>
                                                            @else
                                                                <span class="text-muted">-</span>
                                                            @endif
                                                            <small class="text-muted">
                                                                {{ $movement->to_dept_display }} | {{ $movement->to_area_display }}
                                                            </small>
                                                        </div>
                                                    </td>
                                                    <td class="text-xs">
                                                            {{-- <span class="badge badge-sm {{ $hasDefect ? 'bg-gradient-secondary' : ($isLastMovement ? 'bg-gradient-success' : 'bg-gradient-secondary') }}">
                                                                {{ $periodStart }}
                                                            </span> --}}
                                                            {{-- <span class="badge badge-sm bg-gradient-secondary">
                                                                {{ $periodStart }}
                                                            </span> --}}
                                                            <div class="d-flex flex-column align-items-start">
                                                                <span class="badge badge-sm {{ $hasDefect ? 'bg-gradient-secondary' : ($isLastMovement ? 'bg-gradient-success' : 'bg-gradient-secondary') }}">
                                                                    {{ $periodStart }}
                                                                </span>
                                                                
                                                                @if($isDefect && $isLastMovement)
                                                                    <small class="text-danger mt-1">
                                                                        <i class="fas fa-exclamation-triangle me-1"></i>
                                                                        Sudah Rusak
                                                                    </small>
                                                                @elseif($isLastMovement)
                                                                    <small class="text-success mt-1">
                                                                        <i class="fas fa-check-circle me-1"></i>
                                                                        Sedang Digunakan
                                                                    </small>
                                                                @else
                                                                    <small class="text-muted mt-1">
                                                                        <i class="fas fa-history me-1"></i>
                                                                        Sudah Tidak Digunakan
                                                                    </small>
                                                                @endif
                                                            </div>
                                                    </td>
                                                    {{-- <td class="text-xs">
                                                        <strong></strong>
                                                    </td> --}}
                                                    <td class="text-xs">
                                                        <strong>{{ $movement->kode_sap ?? '-' }}</strong>
                                                    </td>
                                                    <td class="text-xs">
                                                        @if($isDefect)
                                                            <span class="badge bg-danger text-white">
                                                                <i class="fas fa-exclamation-triangle me-1"></i>
                                                                {{ $movement->remark ?: '-' }}
                                                            </span>
                                                        @else
                                                            {{ $movement->remark ?: '-' }}
                                                        @endif
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                    </div>
                @empty
                    <div class="text-center py-5">
                        <i class="fas fa-inbox fa-3x text-secondary mb-3"></i>
                        <p class="text-secondary mb-0">No movement data found</p>
                    </div>
                @endforelse
            </div>
        </div>
    </div>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js"></script>
    <script>
        function exportToExcel() {
            const wb = XLSX.utils.book_new();
            
            const data = [];
            
            data.push(['Movement Report']);
            data.push(['Kategori', '{{ $kategoriMap[$filter["kategori"]] ?? "ALL" }}']);
            data.push(['Department', '{{ $filter["dept"] ?:  "ALL" }}']);
            data.push(['Code', '{{ $filter["code"] ?? "ALL" }}']);
            
            // Update User/Location display in Excel
            @if(!empty($filter['userName']))
                data.push(['User/Location', '{{ $filter["userName"] }}']);
            @elseif(!empty($filter['locationName']))
                data.push(['User/Location', '{{ $filter["locationName"] }}']);
            @elseif(!empty($filter['locationText']))
                data.push(['User/Location', '{{ $filter["locationText"] }}']);
            @else
                data.push(['User/Location', 'ALL']);
            @endif
            
            data.push(['Date Range', '@if($filter["startDate"] && $filter["endDate"]){{ date("d/m/Y", strtotime($filter["startDate"])) }} - {{ date("d/m/Y", strtotime($filter["endDate"])) }}@else ALL @endif']);
            data.push([]);
            
            data.push(['Old Code', 'New Code', 'Kategori', 'Total Movements', 'First Movement', 'Last Movement']);
            
            @foreach($groupedMovements as $code => $movements)
                @php
                    $firstMovement = $movements->first();
                    $lastMovement = $movements->last();
                    $displayOldCode = $lastMovement->code;
                    $displayNewCode = $lastMovement->new_code;
                @endphp
                data.push([
                    '{{ $displayOldCode }}',
                    '{{ $displayNewCode ??  "-" }}',
                    '{{ $firstMovement->kategori }}',
                    '{{ $movements->count() }}',
                    '{{ date("d/m/Y", strtotime($firstMovement->date)) }}',
                    '{{ date("d/m/Y", strtotime($lastMovement->date)) }}'
                ]);
                
                data.push([]);
                data.push(['Movement History']);
                data.push(['Date', 'From User/Location', 'From Dept', 'From Area', 'To User/Location', 'To Dept', 'To Area', 'Remark']);
                
                @foreach($movements as $movement)
                    data.push([
                        '{{ date("d/m/Y", strtotime($movement->date)) }}',
                        '{{ $movement->from_user_name ?? $movement->from_location_name ??  "-" }}',
                        '{{ $movement->from_dept }}',
                        '{{ $movement->from_area }}',
                        '{{ $movement->to_user_name ?? $movement->to_location_name ?? "-" }}',
                        '{{ $movement->to_dept_display }}',
                        '{{ $movement->to_area_display }}',
                        '{{ $movement->remark ??  "-" }}'
                    ]);
                @endforeach
                
                data.push([]);
            @endforeach
            
            // Create worksheet
            const ws = XLSX.utils.aoa_to_sheet(data);
            
            // Add worksheet to workbook
            XLSX. utils.book_append_sheet(wb, ws, "Movement Report");
            
            // Save file
            const filename = 'Movement_Report_' + new Date().toISOString().slice(0,10) + '.xlsx';
            XLSX.writeFile(wb, filename);
        }
    </script>

    <style>
        .table-danger {
            background-color: #ffe5e5 !important;
        }
        
        .bg-light-danger {
            background-color: #fff5f5;
        }
        
        .table tbody tr.table-danger {
            border-left: 4px solid #dc3545;
        }
        
        .table tbody tr.table-danger td {
            border-bottom-color: #f8d7da;
        }
        
        @media print {
            .btn,
            .nav,
            .sidenav,
            .navbar {
                display: none !important;
            }
            
            .card {
                box-shadow: none !important;
                border: 1px solid #dee2e6 !important;
                page-break-inside: avoid;
            }
            
            .border-bottom {
                page-break-inside: avoid;
            }
            
            .table-danger {
                background-color: #ffe5e5 !important;
            }
        }
        
        .border-bottom:last-child {
            border-bottom: none !important;
        }
    </style>
@endsection