Data Comparison
Compare raw sheet metric values from raw_metrics_structured against final values from final_access_data and final_quality_data.
@php
// Force the included filters partial to render the "sector" variant
// (shows sector + business checkbox list) instead of the 3-business selects.
$currentRouteName = 'platform.members.monthly.report.sector';
// The partial expects $selectedSector; map our selectedSectorId into it.
$selectedSector = $selectedSectorId ?? null;
@endphp
@if($selectedBusinessId && $businessName)
Business: {{ $businessName }} @if($sectorName) | Sector: {{ $sectorName }}@endif | Period: {{ $selectedYearMonth }}
@endif
@if(!empty($comparisonGroups))
Sector: {{ $sectorName ?? 'Selected' }} | Period: {{ $selectedYearMonth }}
Comparison Results
| # |
Business |
Access Sheet Value |
Access System Value |
Access Diff |
Quality Sheet Value |
Quality System Value |
Quality Diff |
@foreach($comparisonGroups as $group)
@php
$metrics = collect($group['comparisonData'])->keyBy('metric_id');
$access = $metrics[1] ?? null;
$quality = $metrics[61] ?? null;
$accessRaw = $access['raw_value'] ?? null;
$accessFinal = $access['final_access_value'] ?? null;
$qualityRaw = $quality['raw_value'] ?? null;
$qualityFinal = $quality['final_quality_value'] ?? null;
$accessRawDisplay = $accessRaw !== null ? app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($accessRaw, $access['metric_data_type'] ?? 'decimal') : null;
$accessFinalDisplay = $accessFinal !== null ? app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($accessFinal, $access['metric_data_type'] ?? 'decimal') : null;
$qualityRawDisplay = $qualityRaw !== null ? app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($qualityRaw, $quality['metric_data_type'] ?? 'decimal') : null;
$qualityFinalDisplay = $qualityFinal !== null ? app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($qualityFinal, $quality['metric_data_type'] ?? 'decimal') : null;
$accessDiff = null;
$qualityDiff = null;
$accessDiff = null;
$qualityDiff = null;
$accessClass = '';
$qualityClass = '';
$accessDiffDisplay = 'No data found';
$qualityDiffDisplay = 'No data found';
// Treat as same if the formatted displays match (so 58.1% == 58.1%)
if ($accessRawDisplay !== null && $accessFinalDisplay !== null) {
if ($accessRawDisplay === $accessFinalDisplay) {
$accessClass = 'difference-same';
$accessDiffDisplay = 'Same';
} else if (is_numeric($accessRaw) && is_numeric($accessFinal)) {
$accessDiff = $accessFinal - $accessRaw;
$accessClass = 'difference-mismatch';
$accessDiffDisplay = app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($accessDiff, $access['metric_data_type'] ?? 'decimal');
}
}
if ($qualityRawDisplay !== null && $qualityFinalDisplay !== null) {
if ($qualityRawDisplay === $qualityFinalDisplay) {
$qualityClass = 'difference-same';
$qualityDiffDisplay = 'Same';
} else if (is_numeric($qualityRaw) && is_numeric($qualityFinal)) {
$qualityDiff = $qualityFinal - $qualityRaw;
$qualityClass = 'difference-mismatch';
$qualityDiffDisplay = app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($qualityDiff, $quality['metric_data_type'] ?? 'decimal');
}
}
@endphp
{{ $loop->iteration }} |
{{ $group['business_name'] }} |
{{ $accessRawDisplay ?? '-' }} |
{{ $accessFinalDisplay ?? '-' }} |
{{ $accessDiffDisplay }} |
{{ $qualityRawDisplay ?? '-' }} |
{{ $qualityFinalDisplay ?? '-' }} |
{{ $qualityDiffDisplay }} |
@endforeach
@if(empty($comparisonGroups))
No businesses found for the selected sector. Please select a sector with businesses or choose a specific business.
@endif
@elseif(!empty($comparisonData))
Comparison Results
| Metric |
Sheet Value |
Access System Value |
Access Diff |
Quality System Value |
Quality Diff |
@foreach($comparisonData as $row)
@php
$rawDisplay = $row['raw_value'] !== null ? app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($row['raw_value'], $row['metric_data_type']) : '-';
$accessDisplay = $row['final_access_value'] !== null ? app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($row['final_access_value'], $row['metric_data_type']) : '-';
$qualityDisplay = $row['final_quality_value'] !== null ? app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($row['final_quality_value'], $row['metric_data_type']) : '-';
$accessDiff = null;
$qualityDiff = null;
$accessClass = '';
$qualityClass = '';
$accessDiffDisplay = 'No data found';
$qualityDiffDisplay = 'No data found';
$rawDisplay = $row['raw_value'] !== null ? app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($row['raw_value'], $row['metric_data_type']) : null;
$accessFinalDisplay = $row['final_access_value'] !== null ? app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($row['final_access_value'], $row['metric_data_type']) : null;
$qualityFinalDisplay = $row['final_quality_value'] !== null ? app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($row['final_quality_value'], $row['metric_data_type']) : null;
if ($rawDisplay !== null && $accessFinalDisplay !== null) {
if ($rawDisplay === $accessFinalDisplay) {
$accessClass = 'difference-same';
$accessDiffDisplay = 'Same';
} else if (is_numeric($row['raw_value']) && is_numeric($row['final_access_value'])) {
$accessDiff = $row['final_access_value'] - $row['raw_value'];
$accessClass = 'difference-mismatch';
$accessDiffDisplay = app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($accessDiff, $row['metric_data_type']);
}
}
if ($rawDisplay !== null && $qualityFinalDisplay !== null) {
if ($rawDisplay === $qualityFinalDisplay) {
$qualityClass = 'difference-same';
$qualityDiffDisplay = 'Same';
} else if (is_numeric($row['raw_value']) && is_numeric($row['final_quality_value'])) {
$qualityDiff = $row['final_quality_value'] - $row['raw_value'];
$qualityClass = 'difference-mismatch';
$qualityDiffDisplay = app(\App\Orchid\Screens\Admin\DataComparisonReportScreen::class)->formatMetricValue($qualityDiff, $row['metric_data_type']);
}
}
@endphp
| {{ $row['metric_name'] }} |
{{ $rawDisplay ?? '-' }} |
{{ $accessDisplay ?? '-' }} |
{{ $accessDiffDisplay }} |
{{ $qualityDisplay ?? '-' }} |
{{ $qualityDiffDisplay }} |
@endforeach
@elseif($selectedBusinessId > 0)
No comparison data found for the selected business and period.
@elseif(!empty($submitted) && !$selectedBusinessId)
Please select a business from the dropdown and click Compare to view comparison results.
@endif