@include('updown.user_header')

Report

@if(isset($startDate) && isset($endDate)) Date Range: {{ date('F j, Y', strtotime($startDate)) }} to {{ date('F j, Y', strtotime($endDate)) }} @elseif(isset($selectedType) && $selectedType == 1 && isset($externalDateRange)) Date Range: {{ date('F j, Y', strtotime($externalDateRange->earliest_date)) }} to {{ date('F j, Y', strtotime($externalDateRange->latest_date)) }} (Filtered by Type: External) @elseif(isset($selectedType) && $selectedType == 2 && isset($internalDateRange)) Date Range: {{ date('F j, Y', strtotime($internalDateRange->earliest_date)) }} to {{ date('F j, Y', strtotime($internalDateRange->latest_date)) }} (Filtered by Type: Internal) @elseif(isset($dateRanges) && $dateRanges->earliest_date && $dateRanges->latest_date) Date Range: {{ date('F j, Y', strtotime($dateRanges->earliest_date)) }} to {{ date('F j, Y', strtotime($dateRanges->latest_date)) }} @else No data available for this date range. @endif

SQD 0
Strongly Agree Agree Neutral Disagree Strongly Disagree N/A Total Response Overall
Overall {{ $overall->total_strongly_agree }} {{ $overall->total_agree }} {{ $overall->total_neutral }} {{ $overall->total_disagree }} {{ $overall->total_strongly_disagree }} {{ $overall->total_na }} {{ $overall->total_responses }} {{ number_format($overall->overall_rating_percentage, 2) }}%
SQD 1 to 8
@php // Initialize summary totals $summary_totals = [ 'strongly_agree' => 0, 'agree' => 0, 'neutral' => 0, 'disagree' => 0, 'strongly_disagree' => 0, 'na' => 0, 'total_responses' => 0, ]; // Overall totals initialization $overall_totals = [ 'strongly_agree' => 0, 'agree' => 0, 'neutral' => 0, 'disagree' => 0, 'strongly_disagree' => 0, 'na' => 0, 'total_responses' => 0, ]; // Categories mapping $categories = [ 'Responsiveness' => 'sqdone', 'Reliability' => 'sqdtwo', 'Access and Facilities' => 'sqdthree', 'Communication' => 'sqdfour', 'Costs' => 'sqdfive', 'Integrity' => 'sqdsix', 'Assurance' => 'sqdseven', 'Outcome' => 'sqdeight', ]; @endphp @foreach($categories as $display_name => $category) @foreach($offices as $office) @php // Sum the values for the current category $summary_totals['strongly_agree'] += $office->{$category . '_strongly_agree'}; $summary_totals['agree'] += $office->{$category . '_agree'}; $summary_totals['neutral'] += $office->{$category . '_neutral'}; $summary_totals['disagree'] += $office->{$category . '_disagree'}; $summary_totals['strongly_disagree'] += $office->{$category . '_strongly_disagree'}; $summary_totals['na'] += $office->{$category . '_na'}; $summary_totals['total_responses'] += $office->{$category . '_total_responses'}; // Accumulate to overall totals $overall_totals['strongly_agree'] += $office->{$category . '_strongly_agree'}; $overall_totals['agree'] += $office->{$category . '_agree'}; $overall_totals['neutral'] += $office->{$category . '_neutral'}; $overall_totals['disagree'] += $office->{$category . '_disagree'}; $overall_totals['strongly_disagree'] += $office->{$category . '_strongly_disagree'}; $overall_totals['na'] += $office->{$category . '_na'}; $overall_totals['total_responses'] += $office->{$category . '_total_responses'}; @endphp @endforeach @php // Reset summary totals for the next category $summary_totals = array_map(function() { return 0; }, $summary_totals); @endphp @endforeach
Strongly Agree Agree Neither Agree nor Disagree Disagree Strongly Disagree N/A Total Response Overall
{{ $display_name }} {{ $summary_totals['strongly_agree'] }} {{ $summary_totals['agree'] }} {{ $summary_totals['neutral'] }} {{ $summary_totals['disagree'] }} {{ $summary_totals['strongly_disagree'] }} {{ $summary_totals['na'] }} {{ $summary_totals['total_responses'] }} {{ $summary_totals['total_responses'] > 0 ? number_format(($summary_totals['strongly_agree'] + $summary_totals['agree']) / $summary_totals['total_responses'] * 100, 2) : 0 }}%
Overall {{ $overall_totals['strongly_agree'] }} {{ $overall_totals['agree'] }} {{ $overall_totals['neutral'] }} {{ $overall_totals['disagree'] }} {{ $overall_totals['strongly_disagree'] }} {{ $overall_totals['na'] }} {{ $overall_totals['total_responses'] }} {{ $overall_totals['total_responses'] > 0 ? number_format(($overall_totals['strongly_agree'] + $overall_totals['agree']) / $overall_totals['total_responses'] * 100, 2) : 0 }}%
CC Result
Citizen’s Charter Answers Responses Overall
CC1. Which of the following describes your awareness of the CC?
1. I know what a CC is and I saw this office’s CC. {{ $CC->i_know_i_saw_cc1 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->i_know_i_saw_cc1 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
2. I know what a CC is but I did not see this office’s CC. {{ $CC->i_know_cc_cc1 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->i_know_cc_cc1 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
3. I learned of the CC only when I saw this office’s CC. {{ $CC->only_i_saw_office_cc1 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->only_i_saw_office_cc1 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
4. I do not know what a CC is and I did not see this office’s CC. {{ $CC->didnt_see_office_cc1 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->didnt_see_office_cc1 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
5. N/A {{ $CC->na_cc1 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->na_cc1 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
CC2. If aware of CC, would you say that the CC of this office was…?
1. Easy to see {{ $CC->easy_to_see_cc2 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->easy_to_see_cc2 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
2. Somewhat easy to see {{ $CC->somewhat_easy_to_see_cc2 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->somewhat_easy_to_see_cc2 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
3. Difficult to see {{ $CC->difficult_to_see_cc2 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->difficult_to_see_cc2 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
4. Not visible {{ $CC->not_visible_cc2 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->not_visible_cc2 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
5. N/A {{ $CC->na_cc2 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->na_cc2 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
CC3. How would you rate the helpfulness of the CC?
1. Helped very much {{ $CC->na_cc3 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->na_cc3 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
2. Somewhat helped {{ $CC->did_not_help_cc3 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->did_not_help_cc3 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
3. Did not help {{ $CC->somewhat_help_cc3 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->somewhat_help_cc3 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
4. N/A {{ $CC->helped_very_much_cc3 }} {{ $CC->total_responses_cc1 > 0 ? number_format(($CC->helped_very_much_cc3 / $CC->total_responses_cc1) * 100, 2) : '0.00' }}%
Client Type
Client Responses Overall
Citizen {{ $type->citizen }} {{ $type->total_responses > 0 ? number_format(($type->citizen / $type->total_responses) * 100, 2) : '0.00' }}%
Business {{ $type->business }} {{ $type->total_responses > 0 ? number_format(($type->business / $type->total_responses) * 100, 2) : '0.00' }}%
Government {{ $type->government }} {{ $type->total_responses > 0 ? number_format(($type->government / $type->total_responses) * 100, 2) : '0.00' }}%
Sex
Gender Responses Overall
Male {{ $genderData->male }} {{ $genderData->total_responses > 0 ? number_format(($genderData->male / $genderData->total_responses) * 100, 2) : '0.00' }}%
Female {{ $genderData->female }} {{ $genderData->total_responses > 0 ? number_format(($genderData->female / $genderData->total_responses) * 100, 2) : '0.00' }}%
Age
@php $totalResponses = $demograpic->age_19_or_lower + $demograpic->age_20_34 + $demograpic->age_35_49 + $demograpic->age_50_64 + $demograpic->age_65_or_higher + $demograpic->age_did_not_specify; @endphp
Age Range Responses Overall
19 or lower {{ $demograpic->age_19_or_lower }} {{ number_format(($totalResponses > 0) ? ($demograpic->age_19_or_lower / $totalResponses) * 100 : 0, 2) }}%
20-34 {{ $demograpic->age_20_34 }} {{ number_format(($totalResponses > 0) ? ($demograpic->age_20_34 / $totalResponses) * 100 : 0, 2) }}%
35-49 {{ $demograpic->age_35_49 }} {{ number_format(($totalResponses > 0) ? ($demograpic->age_35_49 / $totalResponses) * 100 : 0, 2) }}%
50-64 {{ $demograpic->age_50_64 }} {{ number_format(($totalResponses > 0) ? ($demograpic->age_50_64 / $totalResponses) * 100 : 0, 2) }}%
65 or higher {{ $demograpic->age_65_or_higher }} {{ number_format(($totalResponses > 0) ? ($demograpic->age_65_or_higher / $totalResponses) * 100 : 0, 2) }}%
Did not specify {{ $demograpic->age_did_not_specify }} {{ number_format(($totalResponses > 0) ? ($demograpic->age_did_not_specify / $totalResponses) * 100 : 0, 2) }}%
Region
Regions Responses Overall
Region I {{ $region->regionone }} {{ $region->total_responses > 0 ? number_format(($region->regionone / $region->total_responses) * 100, 2) : '0.00' }}%
Region II {{ $region->regiontwo }} {{ $region->total_responses > 0 ? number_format(($region->regiontwo / $region->total_responses) * 100, 2) : '0.00' }}%
Region III {{ $region->regionthree }} {{ $region->total_responses > 0 ? number_format(($region->regionthree / $region->total_responses) * 100, 2) : '0.00' }}%
Region IV-A {{ $region->regionfour }} {{ $region->total_responses > 0 ? number_format(($region->regionfour / $region->total_responses) * 100, 2) : '0.00' }}%
MIMAROPA {{ $region->mimaropa }} {{ $region->total_responses > 0 ? number_format(($region->mimaropa / $region->total_responses) * 100, 2) : '0.00' }}%
Region V {{ $region->regionfive }} {{ $region->total_responses > 0 ? number_format(($region->regionfive / $region->total_responses) * 100, 2) : '0.00' }}%
Region VI {{ $region->regionsix }} {{ $region->total_responses > 0 ? number_format(($region->regionsix / $region->total_responses) * 100, 2) : '0.00' }}%
Region VII {{ $region->regionseven }} {{ $region->total_responses > 0 ? number_format(($region->regionseven / $region->total_responses) * 100, 2) : '0.00' }}%
Region VIII {{ $region->regioneight }} {{ $region->total_responses > 0 ? number_format(($region->regioneight / $region->total_responses) * 100, 2) : '0.00' }}%
Region IX {{ $region->regionnine }} {{ $region->total_responses > 0 ? number_format(($region->regionnine / $region->total_responses) * 100, 2) : '0.00' }}%
Region X {{ $region->regionten }} {{ $region->total_responses > 0 ? number_format(($region->regionten / $region->total_responses) * 100, 2) : '0.00' }}%
Region XI {{ $region->regioneleven }} {{ $region->total_responses > 0 ? number_format(($region->regioneleven / $region->total_responses) * 100, 2) : '0.00' }}%
Region XII {{ $region->regiontwelve }} {{ $region->total_responses > 0 ? number_format(($region->regiontwelve / $region->total_responses) * 100, 2) : '0.00' }}%
Region XIII {{ $region->regiontirten }} {{ $region->total_responses > 0 ? number_format(($region->regiontirten / $region->total_responses) * 100, 2) : '0.00' }}%
NCR {{ $region->ncr }} {{ $region->total_responses > 0 ? number_format(($region->ncr / $region->total_responses) * 100, 2) : '0.00' }}%
CAR {{ $region->car }} {{ $region->total_responses > 0 ? number_format(($region->car / $region->total_responses) * 100, 2) : '0.00' }}%
BARMM {{ $region->barmm }} {{ $region->total_responses > 0 ? number_format(($region->barmm / $region->total_responses) * 100, 2) : '0.00' }}%
@include('updown.footers')