@php
    use App\Services\SiboBreathTestService;

    $LabCategoryPackageResults = \App\Models\ENDUSERLABORDERPACKAGERESULT::where('END_USER_PACKAGE_ID', $Package->ID)
        ->with('Result')
        ->get();

    $Values = [];
    foreach ($LabCategoryPackageResults as $Row) {
        if (empty($Row->Result) || empty($Row->Result->CODE)) continue;
        $Values[$Row->Result->CODE] = $Row->RESULT;
    }

    $SiboService = new SiboBreathTestService();
    $Evaluation  = $SiboService->evaluate($Values);
    $H2  = $Evaluation['h2'];
    $CH4 = $Evaluation['ch4'];

    // The narrative cells are open text: show what the lab stored, and fall back to
    // the derived wording for results saved before the cells were auto filled.
    $StoredResult         = trim((string) ($Values[SiboBreathTestService::RESULT_CODE] ?? ''));
    $StoredDetection      = trim((string) ($Values[SiboBreathTestService::DETECTION_CODE] ?? ''));
    $StoredConclusion     = trim((string) ($Values[SiboBreathTestService::CONCLUSION_CODE] ?? ''));
    $StoredRecommendation = trim((string) ($Values[SiboBreathTestService::RECOMMENDATION_CODE] ?? ''));

    $ResultText     = $StoredResult !== '' ? $StoredResult : $Evaluation['result'];
    $DetectionText  = $StoredDetection !== '' ? $StoredDetection : $Evaluation['detection'];
    $ConclusionText = $StoredConclusion !== '' ? $StoredConclusion : $Evaluation['conclusion'];

    // A hand written recommendation replaces the lead and its bullets entirely.
    // Matching on the lead rather than the whole paragraph keeps auto filled results
    // rendering as bullets even after the bullet wording is edited.
    $CustomRecommendation = $StoredRecommendation !== ''
        && $Evaluation['recommendation_lead'] !== ''
        && !str_starts_with($StoredRecommendation, $Evaluation['recommendation_lead']);

    $Positive = $Evaluation['positive'];
    $Danger   = '#E9473A';
    $Normal   = '#1FA345';
    $Navy     = '#1F3864';
    $Orange   = '#F5A623';

    $ppm = function ($value) {
        if ($value === null) return '--';
        return rtrim(rtrim(number_format((float) $value, 2, '.', ''), '0'), '.');
    };
    $signed = function ($value) use ($ppm) {
        if ($value === null) return '--';
        return ($value > 0 ? '+' : '') . $ppm($value);
    };

    // The report-wide stylesheet forces white cells, centred text and grey borders on
    // every table with !important, so the coloured blocks have to out-shout it inline.
    $th   = 'background-color:' . $Navy . ' !important; color:#fff !important; font-weight:700; padding:6px 8px !important;';
    $plain = 'border:none !important; background-color:transparent !important; text-align:left !important; vertical-align:top;';

    $TimeLabels = ['Baseline', '30 Min', '60 Min', '75 Min', '90 Min'];
    $TimeMins   = [0, 30, 60, 75, 90];
@endphp

<style>
    .sibo-grid td, .sibo-grid th { padding: 5px 6px !important; line-height: 1.25; }
    .sibo-card-head { padding: 6px 10px; color: #fff; font-weight: 700; font-size: 13px; }
    .sibo-card-body { border: 1px solid #d5d5d5; border-top: none; padding: 8px 10px; font-size: 12.5px; line-height: 1.5; }
    .sibo-section { font-weight: 700; font-size: 13px; color: {{ $Navy }}; letter-spacing: .04em; margin-bottom: 4px; }
    .sibo-bullets { margin: 4px 0 0 0; padding-left: 16px; font-size: 12.5px; line-height: 1.7; }
</style>

{{-- ── Result banner + conclusion ─────────────────────────────────────────── --}}
<table style="width:100%; margin-top:6px; page-break-inside:avoid;">
    <tr>
        <td width="38%" style="border:none !important; border-left:6px solid {{ $Positive ? $Danger : $Normal }} !important; background-color:{{ $Positive ? '#FDF2F1' : '#F2FAF5' }} !important; padding:14px 10px !important;">
            <div style="font-size:30px; font-weight:700; color:{{ $Positive ? $Danger : $Normal }}; line-height:1.1;">
                {{ $ResultText }}
            </div>
            <div style="font-size:12.5px; color:{{ $Positive ? $Danger : $Normal }}; margin-top:2px;">
                {{ $DetectionText }}
            </div>
        </td>
        <td width="62%" style="{{ $plain }} padding:14px 0 14px 16px !important;">
            <div class="sibo-section">Conclusion</div>
            <div style="font-size:12.5px; line-height:1.55;">{!! nl2br(e($ConclusionText)) !!}</div>
        </td>
    </tr>
</table>

{{-- ── Gas readings ───────────────────────────────────────────────────────── --}}
<div class="sibo-section" style="margin-top:14px;">GAS READINGS</div>
<table class="sibo-grid" style="width:100%; font-size:12.5px;">
    <thead>
    <tr>
        <th style="{{ $th }}">Time Point</th>
        <th style="{{ $th }}">Time (min)</th>
        <th style="{{ $th }}">H2 (ppm)</th>
        <th style="{{ $th }}">CH4 (ppm)</th>
        <th style="{{ $th }}">H2 Status</th>
        <th style="{{ $th }}">CH4 Status</th>
    </tr>
    </thead>
    <tbody>
    @foreach($TimeLabels as $Index => $Label)
        @php
            $H2Point  = $H2['points'][$Index]  ?? ['value' => null, 'positive' => false];
            $CH4Point = $CH4['points'][$Index] ?? ['value' => null, 'positive' => false];
            $Rise     = ($H2Point['value'] === null || $H2['baseline'] === null) ? null : $H2Point['value'] - $H2['baseline'];
        @endphp
        <tr>
            <td style="font-weight:{{ $Index === 0 ? 700 : 400 }};">{{ $Label }}</td>
            <td>{{ $TimeMins[$Index] }}</td>
            <td style="font-weight:700; color:{{ !empty($H2Point['positive']) ? $Danger : '#19213D' }};">{{ $ppm($H2Point['value']) }}</td>
            <td style="font-weight:700; color:{{ !empty($CH4Point['positive']) ? $Danger : '#19213D' }};">{{ $ppm($CH4Point['value']) }}</td>
            <td style="color:{{ !empty($H2Point['positive']) ? $Danger : $Normal }};">
                @if($H2Point['value'] === null)
                    --
                @elseif($Index === 0)
                    <span style="color:#5D6481;">Baseline</span>
                @else
                    {{ $signed($Rise) }} &middot; {{ !empty($H2Point['positive']) ? 'Above threshold' : 'Normal' }}
                @endif
            </td>
            <td style="color:{{ !empty($CH4Point['positive']) ? $Danger : $Normal }};">
                {{ $CH4Point['value'] === null ? '--' : (!empty($CH4Point['positive']) ? 'Above threshold' : 'Normal') }}
            </td>
        </tr>
    @endforeach
    </tbody>
</table>

{{-- ── Chart ──────────────────────────────────────────────────────── --}}
@php
    $ChartSvg = view('pdf.normal_report.components.analysis_tests.sibo_chart', ['h2' => $H2, 'ch4' => $CH4])->render();
    $ChartSrc = 'data:image/svg+xml;base64,' . base64_encode($ChartSvg);
@endphp
<div style="page-break-inside:avoid;">
<div class="sibo-section" style="margin-top:14px;">GAS LEVELS OVER TIME</div>
<div style="border:1px solid #d5d5d5;">
    <img src="{{ $ChartSrc }}" alt="Gas levels over time" style="width:100%; display:block;"/>
</div>
</div>

{{-- ── Interpretation cards ───────────────────────────────────────────────── --}}
<div style="page-break-inside:avoid;">
<div class="sibo-section" style="margin-top:14px;">INTERPRETATION</div>
<table style="width:100%;">
    <tr>
        <td width="50%" style="{{ $plain }} padding:0 8px 0 0 !important;">
            <div class="sibo-card-head" style="background-color:{{ $Orange }};">Hydrogen (H2) Result</div>
            <div class="sibo-card-body">
                Baseline: <b>{{ $ppm($H2['baseline']) }} ppm</b> &nbsp; Peak: <b>{{ $ppm($H2['peak']) }} ppm</b>@if($H2['peak_label']) at {{ $H2['peak_label'] }}@endif<br>
                Rise above baseline: <b>{{ $signed($H2['peak_rise']) }} ppm</b><br><br>
                Diagnostic threshold: <b>{{ $ppm($H2['threshold']) }} ppm or more</b> rise above baseline<br><br>
                <span style="color:{{ $H2['positive'] ? $Danger : $Normal }}; font-weight:700;">
                    {{ $H2['positive'] ? 'Above threshold' : 'Below threshold — Normal' }}
                </span><br>
                {{ $H2['positive']
                    ? 'Suggests hydrogen-producing bacteria in the small intestine.'
                    : 'No hydrogen-producing bacteria in the small intestine.' }}
            </div>
        </td>
        <td width="50%" style="{{ $plain }} padding:0 0 0 8px !important;">
            <div class="sibo-card-head" style="background-color:{{ $Normal }};">Methane (CH4) Result</div>
            <div class="sibo-card-body">
                Baseline: <b>{{ $ppm($CH4['baseline']) }} ppm</b> &nbsp; Peak: <b>{{ $ppm($CH4['peak']) }} ppm</b>@if($CH4['peak_label']) at {{ $CH4['peak_label'] }}@endif<br>
                &nbsp;<br><br>
                Diagnostic threshold: <b>{{ $ppm($CH4['threshold']) }} ppm or more</b> at any point<br><br>
                <span style="color:{{ $CH4['positive'] ? $Danger : $Normal }}; font-weight:700;">
                    {{ $CH4['positive'] ? 'Above threshold' : 'Below threshold — Normal' }}
                </span><br>
                {{ $CH4['positive']
                    ? 'Small intestinal methanogen overgrowth (IMO) detected.'
                    : 'No small intestinal methanogen overgrowth (IMO) detected.' }}
            </div>
        </td>
    </tr>
</table>
</div>

{{-- ── Reference ranges ───────────────────────────────────────────────────── --}}
<div style="page-break-inside:avoid;">
<div class="sibo-section" style="margin-top:14px;">REFERENCE RANGES</div>
<table class="sibo-grid" style="width:100%; font-size:12.5px;">
    <thead>
    <tr>
        <th style="{{ $th }}">Gas</th>
        <th style="{{ $th }}">Normal Range</th>
        <th style="{{ $th }}">Diagnostic Threshold</th>
        <th style="{{ $th }}">Patient Result</th>
        <th style="{{ $th }}">Status</th>
    </tr>
    </thead>
    <tbody>
    <tr>
        <td>Hydrogen (H2)</td>
        <td>&lt; {{ $ppm($H2['threshold']) }} ppm rise</td>
        <td>{{ $ppm($H2['threshold']) }} ppm above baseline</td>
        <td style="color:{{ $H2['positive'] ? $Danger : $Orange }}; font-weight:700;">
            {{ $signed($H2['peak_rise']) }} ppm / Peak {{ $ppm($H2['peak']) }}
        </td>
        <td style="color:{{ $H2['positive'] ? $Danger : $Normal }}; font-weight:700;">
            {{ $H2['positive'] ? 'Above threshold' : 'Normal' }}
        </td>
    </tr>
    <tr>
        <td>Methane (CH4)</td>
        <td>&lt; {{ $ppm($CH4['threshold']) }} ppm</td>
        <td>{{ $ppm($CH4['threshold']) }} ppm at any point</td>
        <td style="color:{{ $CH4['positive'] ? $Danger : $Normal }}; font-weight:700;">{{ $ppm($CH4['peak']) }} ppm</td>
        <td style="color:{{ $CH4['positive'] ? $Danger : $Normal }}; font-weight:700;">
            {{ $CH4['positive'] ? 'Above threshold' : 'Normal' }}
        </td>
    </tr>
    </tbody>
</table>
</div>

{{-- ── Recommendation ─────────────────────────────────────────────────────── --}}
<div style="page-break-inside:avoid;">
<div class="sibo-section" style="margin-top:14px;">RECOMMENDATION</div>
<table style="width:100%;">
    <tr>
        <td width="{{ $CustomRecommendation ? 100 : 50 }}%"
            style="border:none !important; border-left:4px solid {{ $Positive ? $Danger : $Normal }} !important; background-color:#F7F9FA !important; text-align:left !important; vertical-align:top; padding:10px 12px !important; font-size:12.5px; line-height:1.55;">
            <div style="font-weight:700; margin-bottom:6px;">Clinical Recommendation</div>
            @if($CustomRecommendation)
                {!! nl2br(e($StoredRecommendation)) !!}
            @else
                {{ $Evaluation['recommendation_lead'] }}
            @endif
        </td>
        @if(!$CustomRecommendation)
            <td width="50%" style="border:none !important; background-color:#F7F9FA !important; text-align:left !important; vertical-align:top; padding:10px 12px !important;">
                <ul class="sibo-bullets">
                    @foreach($Evaluation['recommendation_points'] as $Point)
                        <li>{{ $Point }}</li>
                    @endforeach
                </ul>
            </td>
        @endif
    </tr>
</table>
</div>

<div style="font-size:10.5px; font-style:italic; color:#5D6481; text-align:center; margin-top:8px;">
    Breath test performed in accordance with North American Consensus (2017) diagnostic criteria.
</div>

@include('pdf.normal_report.components.analysis_tests.layout.comment')