@php
    $category = $row->client?->client_profile?->project_category;
    
    // $value contains raw_data from the column binding
    // raw_data structure: ['clients' => [...], 'project' => [...]]
    $rawData = $value ?? $row->raw_data ?? [];
    $projectData = $rawData['project'] ?? [];
    
    // Get project info from raw_data
    $duration = $projectData['duration'] ?? null;
    $cashflowAmount = $projectData['cashflow_amount'] ?? null;
    $totalPropertyValue = $projectData['total_property_value'] ?? null;
    $propertyZipcode = $projectData['property_zipcode'] ?? null;
    $projectCategoryId = $projectData['category'] ?? null;
    $monthlyConsoAmount = $projectData['monthly_conso_amount'] ?? null;
    $monthlyImmoAmount = $projectData['monthly_immo_amount'] ?? null;
    $othersDebtsAmount = $projectData['others_debts_amount'] ?? null;
    
    // Debt counts and amounts
    $debtsConsoCount = $projectData['debts_conso_count'] ?? 0;
    $debtsImmoCount = $projectData['debts_immo_count'] ?? 0;
    $crdConso = $projectData['debts_conso_amount'] ?? 0;
    $crdImmo = $projectData['debts_immo_amount'] ?? 0;
    $crdTotal = $projectData['credit_amount'] ?? ($crdConso + $crdImmo);
    
    // Get primary client info from clients array
    $clientsData = $rawData['clients'] ?? [];
    $primaryClient = $clientsData[0] ?? [];
    $coClient = $clientsData[1] ?? null;
    $totalIncome = 0;
    foreach ($clientsData as $client) {
        $totalIncome += $client['total_income'] ?? 0;
    }
    $totalClaims = $primaryClient['total_claims'] ?? null;
    
    // Residential status
    $isOwner = $totalPropertyValue && $totalPropertyValue > 0;
    
    // Unique ID for collapse
    $collapseId = 'project-collapse-' . ($row->id ?? uniqid());
@endphp

<div class="project-data-cell" x-data="{ expanded: false }">
    {{-- Project Category Badge --}}
    @if($category)
        <div class="mb-2">
            <span class="badge badge-dim bg-primary rounded-pill">
                <x-ui.nicon :name="$category->icon ?? 'briefcase'" class="me-1"/>
                {{ $category->name }}
            </span>
        </div>
    @elseif($projectCategoryId)
        <div class="mb-2">
            <span class="badge badge-dim bg-primary rounded-pill">
                <x-ui.nicon name="briefcase" class="me-1"/>
                {{ $projectCategoryId == 1 ? __('Regroupement de crédits') : __('Crédit conso') }}
            </span>
        </div>
    @endif
    
    {{-- Collapsible Summary Header --}}
    <div class="project-summary-header" x-on:click="expanded = !expanded">
        <div class="project-summary-content">
            <div class="project-summary-item">
                <span class="project-summary-label">CRD</span>
                <span class="project-summary-value text-primary fw-bold">{{ number_format($crdTotal, 0) }}€</span>
            </div>
            <div class="project-summary-divider"></div>
            <div class="project-summary-item">
                <span class="project-summary-label">{{ $isOwner ? 'Proprio' : 'Loc.' }}</span>
                <x-ui.nicon :name="$isOwner ? 'home' : 'building'" :class="$isOwner ? 'text-success' : 'text-muted'" style="font-size: 14px;"/>
            </div>
            @if($totalIncome > 0)
                <div class="project-summary-divider"></div>
                <div class="project-summary-item">
                    <span class="project-summary-label">Rev.</span>
                    <span class="project-summary-value text-success">{{ number_format($totalIncome/1000, 0) }}k€</span>
                </div>
            @endif
        </div>
        <div class="project-summary-toggle" x-bind:class="{ 'expanded': expanded }">
            <x-ui.nicon name="chevron-down"/>
        </div>
    </div>
    
    {{-- Collapsible Mini Table --}}
    <div class="project-collapse-wrapper" x-show="expanded" x-collapse x-cloak>
        <table class="table table-sm table-borderless mb-0 project-mini-table">
            <tbody>
                {{-- Statut --}}
                <tr>
                    <td class="project-cell-icon">
                        @if($isOwner)
                            <x-ui.nicon name="home" class="text-success"/>
                        @else
                            <x-ui.nicon name="building" class="text-muted"/>
                        @endif
                    </td>
                    <td class="project-cell-label text-muted">{{ __('Statut résidentiel') }}</td>
                    <td class="project-cell-value {{ $isOwner ? 'text-success fw-semibold' : 'text-muted' }}">
                        {{ $isOwner ? __('Propriétaire') : __('Locataire') }}
                    </td>
                </tr>
                
                {{-- Crédits Conso --}}
                <tr>
                    <td class="project-cell-icon"><x-ui.nicon name="cc-alt2" class="text-info"/></td>
                    <td class="project-cell-label text-muted">{{ __('Conso') }}</td>
                    <td class="project-cell-value">
                        <span class="fw-semibold">{{ $debtsConsoCount }}</span>
                        @if($crdConso > 0)
                            <span class="text-info ms-1">{{ number_format($crdConso, 0) }}€</span>
                        @endif
                    </td>
                </tr>
                
                {{-- Crédits Immo --}}
                <tr>
                    <td class="project-cell-icon"><x-ui.nicon name="home-alt" class="text-info"/></td>
                    <td class="project-cell-label text-muted">{{ __('Immo') }}</td>
                    <td class="project-cell-value">
                        <span class="fw-semibold">{{ $debtsImmoCount }}</span>
                        @if($crdImmo > 0)
                            <span class="text-info ms-1">{{ number_format($crdImmo, 0) }}€</span>
                        @endif
                    </td>
                </tr>
                
                {{-- CRD Total --}}
                <tr class="project-row-highlight">
                    <td class="project-cell-icon"><x-ui.nicon name="coins" class="text-primary"/></td>
                    <td class="project-cell-label text-muted">{{ __('CRD') }}</td>
                    <td class="project-cell-value text-primary fw-bold">{{ number_format($crdTotal, 0) }}€</td>
                </tr>
                
                {{-- Revenus --}}
                @if($totalIncome > 0)
                    <tr>
                        <td class="project-cell-icon"><x-ui.nicon name="wallet" class="text-success"/></td>
                        <td class="project-cell-label text-muted">{{ __('Revenus') }}</td>
                        <td class="project-cell-value text-success fw-semibold">{{ number_format($totalIncome, 0, ',', ' ') }}€</td>
                    </tr>
                @endif
                
                {{-- Durée --}}
                @if($duration)
                    <tr>
                        <td class="project-cell-icon"><x-ui.nicon name="clock" class="text-secondary"/></td>
                        <td class="project-cell-label text-muted">{{ __('Durée') }}</td>
                        <td class="project-cell-value">{{ $duration }} <small class="text-muted">mois</small></td>
                    </tr>
                @endif
                
                {{-- Trésorerie --}}
                @if($cashflowAmount && $cashflowAmount > 0)
                    <tr>
                        <td class="project-cell-icon"><x-ui.nicon name="money" class="text-info"/></td>
                        <td class="project-cell-label text-muted">{{ __('Trés.') }}</td>
                        <td class="project-cell-value text-info">{{ number_format($cashflowAmount/1000, 0) }}k€</td>
                    </tr>
                @endif
                
                {{-- Valeur Bien --}}
                @if($totalPropertyValue && $totalPropertyValue > 0)
                    <tr>
                        <td class="project-cell-icon"><x-ui.nicon name="building" class="text-primary"/></td>
                        <td class="project-cell-label text-muted">{{ __('Bien') }}</td>
                        <td class="project-cell-value text-primary">{{ number_format($totalPropertyValue/1000, 0) }}k€</td>
                    </tr>
                @endif
                
                {{-- Code Postal --}}
                @if($propertyZipcode)
                    <tr>
                        <td class="project-cell-icon"><x-ui.nicon name="map-pin" class="text-secondary"/></td>
                        <td class="project-cell-label text-muted">{{ __('CP') }}</td>
                        <td class="project-cell-value">{{ $propertyZipcode }}</td>
                    </tr>
                @endif
                
                {{-- Charges --}}
                @if($totalClaims && $totalClaims > 0)
                    <tr>
                        <td class="project-cell-icon"><x-ui.nicon name="minus-circle" class="text-danger"/></td>
                        <td class="project-cell-label text-muted">{{ __('Charges') }}</td>
                        <td class="project-cell-value text-danger">{{ number_format($totalClaims, 0, ',', ' ') }}€</td>
                    </tr>
                @endif
                
                {{-- Co-emprunteur --}}
                @if($coClient)
                    <tr>
                        <td class="project-cell-icon"><x-ui.nicon name="users" class="text-info"/></td>
                        <td class="project-cell-label text-muted">{{ __('Co-emp') }}</td>
                        <td class="project-cell-value">
                            <span class="badge bg-info bg-opacity-10 text-info rounded-pill px-2">{{ __('Oui') }}</span>
                        </td>
                    </tr>
                @endif
            </tbody>
        </table>
    </div>
</div>

<style>
/* Summary Header */
.project-summary-header {
    display: flex;
    align-items: center;
    justify-content: space-between;
    padding: 8px 10px;
    background: linear-gradient(135deg, rgba(99, 102, 241, 0.08) 0%, rgba(99, 102, 241, 0.03) 100%);
    border: 1px solid rgba(99, 102, 241, 0.15);
    border-radius: 8px;
    cursor: pointer;
    transition: all 0.2s ease;
    min-width: 200px;
}
.project-summary-header:hover {
    background: linear-gradient(135deg, rgba(99, 102, 241, 0.12) 0%, rgba(99, 102, 241, 0.06) 100%);
    border-color: rgba(99, 102, 241, 0.25);
    box-shadow: 0 2px 8px rgba(99, 102, 241, 0.1);
}
.project-summary-content {
    display: flex;
    align-items: center;
    gap: 8px;
    flex-wrap: wrap;
}
.project-summary-item {
    display: flex;
    align-items: center;
    gap: 4px;
}
.project-summary-label {
    font-size: 9px;
    text-transform: uppercase;
    letter-spacing: 0.3px;
    color: #6b7280;
    font-weight: 500;
}
.project-summary-value {
    font-size: 12px;
    font-weight: 600;
}
.project-summary-divider {
    width: 1px;
    height: 16px;
    background: rgba(99, 102, 241, 0.2);
}
.project-summary-toggle {
    display: flex;
    align-items: center;
    justify-content: center;
    width: 20px;
    height: 20px;
    border-radius: 50%;
    background: rgba(99, 102, 241, 0.1);
    color: #6366f1;
    transition: all 0.3s ease;
}
.project-summary-toggle .icon {
    width: 12px;
    height: 12px;
    transition: transform 0.3s ease;
}
.project-summary-toggle.expanded {
    background: #6366f1;
    color: white;
}
.project-summary-toggle.expanded .icon {
    transform: rotate(180deg);
}

/* Collapse Wrapper */
.project-collapse-wrapper {
    margin-top: 8px;
    overflow: hidden;
}

/* Mini Table */
.project-mini-table {
    font-size: 11px;
    line-height: 1.3;
    min-width: 180px;
    background: linear-gradient(135deg, rgba(255,255,255,0.95) 0%, rgba(248,250,252,0.9) 100%);
    border-radius: 8px;
    overflow: hidden;
    box-shadow: 0 1px 3px rgba(0,0,0,0.04), 0 1px 2px rgba(0,0,0,0.06);
    border: 1px solid rgba(0,0,0,0.05);
}
.project-mini-table tbody tr {
    transition: background-color 0.15s ease;
}
.project-mini-table tbody tr:hover {
    background-color: rgba(99, 102, 241, 0.04);
}
.project-mini-table td {
    padding: 4px 6px !important;
    vertical-align: middle;
    border: none !important;
}
.project-cell-icon {
    width: 20px;
    text-align: center;
}
.project-cell-icon .icon {
    width: 14px;
    height: 14px;
    opacity: 0.8;
}
.project-cell-label {
    font-size: 10px;
    text-transform: uppercase;
    letter-spacing: 0.3px;
    width: 50px;
    opacity: 0.7;
}
.project-cell-value {
    text-align: right;
    font-weight: 500;
    white-space: nowrap;
}
.project-row-highlight {
    background: linear-gradient(90deg, rgba(99, 102, 241, 0.08) 0%, rgba(99, 102, 241, 0.03) 100%);
}
.project-row-highlight td {
    padding-top: 6px !important;
    padding-bottom: 6px !important;
}

/* Dark Mode */
.dark-mode .project-summary-header {
    background: linear-gradient(135deg, rgba(99, 102, 241, 0.15) 0%, rgba(99, 102, 241, 0.05) 100%);
    border-color: rgba(99, 102, 241, 0.25);
}
.dark-mode .project-summary-header:hover {
    background: linear-gradient(135deg, rgba(99, 102, 241, 0.2) 0%, rgba(99, 102, 241, 0.1) 100%);
}
.dark-mode .project-summary-label {
    color: #9ca3af;
}
.dark-mode .project-summary-divider {
    background: rgba(99, 102, 241, 0.3);
}
.dark-mode .project-mini-table {
    background: linear-gradient(135deg, rgba(30,32,40,0.95) 0%, rgba(25,27,35,0.9) 100%);
    box-shadow: 0 1px 3px rgba(0,0,0,0.2), 0 1px 2px rgba(0,0,0,0.15);
    border-color: rgba(255,255,255,0.08);
}
.dark-mode .project-mini-table tbody tr:hover {
    background-color: rgba(99, 102, 241, 0.1);
}
.dark-mode .project-row-highlight {
    background: linear-gradient(90deg, rgba(99, 102, 241, 0.15) 0%, rgba(99, 102, 241, 0.05) 100%);
}
</style>