@include('updown.headers')

Main Campus Overall Result

@csrf
@if(isset($selectedType) && $selectedType !== 'all' && isset($rangeintype->earliest_date) && isset($rangeintype->latest_date))

Date Range for {{ $selectedType == 1 ? 'External' : 'Internal' }}: {{ \Carbon\Carbon::parse($rangeintype->earliest_date)->format('F j, Y') }} to {{ \Carbon\Carbon::parse($rangeintype->latest_date)->format('F j, Y') }}

@elseif($selectedType === 'all' && isset($rangeintype->earliest_date) && isset($rangeintype->latest_date))

Overall Date Range: {{ \Carbon\Carbon::parse($rangeintype->earliest_date)->format('F j, Y') }} to {{ \Carbon\Carbon::parse($rangeintype->latest_date)->format('F j, Y') }}

@elseif(request('start-date') && request('end-date'))

Date Range: {{ \Carbon\Carbon::parse(request('start-date'))->format('F j, Y') }} to {{ \Carbon\Carbon::parse(request('end-date'))->format('F j, Y') }}

@else

No data available for this type or date range.

@endif
SQD 0 All Offices
@foreach($offices as $office) @endforeach
Strongly Agree Agree Neither Agree nor Disagree Disagree Strongly Disagree N/A Total Response Overall
{{ $office->office_name }} {{ $office->strongly_agree }} {{ $office->agree }} {{ $office->neutral }} {{ $office->disagree }} {{ $office->strongly_disagree }} {{ $office->na }} {{ $office->total_responses }} {{ number_format($office->overall_rating_percentage, 2) }}%
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-8 Summary for All Offices
@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 Type 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
Sex Type Responses Overall
Male {{ $gender->male }} {{ $gender->total_responses > 0 ? number_format(($gender->male / $gender->total_responses) * 100, 2) : '0.00' }}%
Female {{ $gender->female }} {{ $gender->total_responses > 0 ? number_format(($gender->female / $gender->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')