@php
$regular_invoices_data = $contract->getRegularInvoicesData();
$downpayment_invoices_data = $contract->getDownpaymentInvoicesData();
$tax_authority_invoices_data = $contract->getTaxAuthorityInvoicesData();

// Calculate total unpaid
$total_invoiced = ($regular_invoices_data['total_invoiced'] + $tax_authority_invoices_data['total_invoiced']) ?? 0;
$total_paid = ($regular_invoices_data['total_paid'] + $tax_authority_invoices_data['total_paid']) ?? 0;
$total_unpaid = $total_invoiced - $total_paid; // Calculate total unpaid
@endphp

@php
// $total_phase_value = DB::table('contract_phases')
//     ->where('contract_id', $contract->id)
//     ->sum(DB::raw("
//         contract_phases.estimated_cost + (
//             SELECT COALESCE(SUM(
//                 CASE
//                     WHEN phase_taxes.manual_amount IS NOT NULL
//                     THEN phase_taxes.manual_amount
//                     ELSE phase_taxes.calculated_amount
//                 END
//             ), 0)
//             FROM phase_taxes
//             WHERE phase_taxes.contract_phase_id = contract_phases.id
//             AND phase_taxes.category IN (1,3)
//         )
//     "));
$contractPhaseData = DB::table('contract_phases')
    ->where('contract_id', $contract->id)
    ->selectRaw("
        COALESCE(SUM(contract_phases.estimated_cost), 0) AS total_estimated_cost,
        (
            SELECT COALESCE(SUM(
                CASE
                    WHEN pt.manual_amount IS NOT NULL AND pt.manual_amount > 0 
                    THEN pt.manual_amount
                    ELSE pt.calculated_amount
                END
            ), 0)
            FROM phase_taxes pt
            INNER JOIN contract_phases cp ON pt.contract_phase_id = cp.id
            WHERE cp.contract_id = ?
            AND pt.category IN (1,3)
        ) AS total_phase_taxes
    ", [$contract->id])
    ->groupBy('contract_phases.contract_id') // ✅ Fixes GROUP BY issue
    ->first();



@endphp

{{-- <div class="my-0 d-flex"><span class="text-info">Total Phase Value:</span>{{ $total_phase_value }}</div> --}}
<div class="my-0 d-flex">
  <span class="text-info">Total Estimated Cost:</span>
  {{ ($contractPhaseData->total_estimated_cost ?? 0) / 100 }}
</div>
<div class="my-0 d-flex">
  <span class="text-warning">Total Phase Taxes:</span>
  {{ ($contractPhaseData->total_phase_taxes ?? 0) / 100 }}
</div>
<div class="my-0 d-flex">
  <span class="text-warning">Total Phase Cost :</span>
  {{ (($contractPhaseData->total_estimated_cost ?? 0) + ($contractPhaseData->total_phase_taxes ?? 0)) / 100 }}
</div>

<div class="my-0 d-flex"> <span>Value:</span>
  @cMoney($contract->value ?? 0, $contract->currency, true)
</div>
<div class="my-0 d-flex"><span class="text-warning">Invoiced:</span> @cMoney($total_invoiced, $contract->currency ?? 'SAR', true)</div>
{{-- 
<div class="my-0 d-flex"><span class="text-muted">Tax:</span> @cMoney($contract->total_tax ?? 0, $contract->currency, true)</div>
--}}
<div class="my-0 d-flex"><span class="text-success">Paid:</span> @cMoney($total_paid, $contract->currency ?? 'SAR', true)</div>
<div class="my-0 d-flex"><span class="text-danger">UnPaid:</span> @cMoney($total_unpaid, $contract->currency, true)</div>
<div class="my-0 d-flex"><span class="text-warning">Retention:</span> @cMoney($regular_invoices_data['total_retention'] ?? 0, $contract->currency ?? 'SAR', true)</div>

@if ($downpayment_invoices_data['total_invoiced'] > 0)
    <div class="my-0 d-flex"><span class="text-success">Down Payment:</span> <span> @cMoney($downpayment_invoices_data['total_invoiced'] ?? 0, $contract->currency ?? 'SAR', true) </span></div>
    <div class="my-0 d-flex"><span class="text-warning">Deductible Remaining:</span> <span> @cMoney($downpayment_invoices_data['remaining_deductible'] ?? 0, $contract->currency ?? 'SAR', true)</span></div>
@endif