1. Introduction

1.1 Purpose

The Pneumonia Data Visualization System is a comprehensive web-based platform designed to monitor, analyze, and visualize pneumonia cases across La Union province. This system enables health officials and administrators to make data-driven decisions for public health interventions.

1.2 Target Users

• Public Users: View statistics, dashboards, and maps
• Health Officers: Upload monthly reports and access detailed analytics
• Administrators: Full system access including data management and user administration

1.3 Key Benefits

2. System Overview

2.1 System Architecture

The system is built using modern web technologies:

• Backend: Laravel PHP Framework
• Frontend: Blade Templates with Tailwind CSS
• Database: MySQL
• Charts: Chart.js
• Maps: Interactive SVG with JavaScript

2.2 Supported Browsers

3. Getting Started

3.1 Accessing the System

1. Open your web browser
2. Navigate to the system URL
3. The home page displays current pneumonia statistics

3.2 Navigation

The main navigation menu includes:

• Home: Overview and latest statistics
• Dashboard: Detailed analytics and charts
• Maps: Geographic visualization
• About: System information
• Login: Access for administrators (top-right)

4. User Roles & Permissions

4.1 Public Users (Guest)

4.2 Administrators

5. Features Guide

5.1 Live Data Statistics

The home page displays real-time statistics:

• Total Cases: All pneumonia cases recorded
• Morbidity Cases: Non-fatal pneumonia cases
• Mortality Cases: Pneumonia-related deaths
• Fatality Rate: Percentage of deaths vs total cases

5.2 Dashboard Analytics

Interactive dashboard features:

• 📊 Municipality comparison charts
• 📈 Yearly and monthly trend analysis
• 🎯 Morbidity vs Mortality breakdown
• 👥 Age group distribution
• ⚧ Gender-based analysis
• 🔍 Advanced filtering options

5.3 Interactive Maps

Geographic visualization features:

• 🗺️ Color-coded municipality intensity
• 🖱️ Hover tooltips with case counts
• 📍 Click for detailed municipality data
• 🎨 Dynamic color scaling based on case density

5.4 Mobile Responsiveness

The system is fully optimized for mobile devices:

• 📱 Responsive Design: Automatically adapts to all screen sizes (mobile, tablet, desktop)
• 🍔 Mobile Menu: Hamburger menu with easy navigation on small screens
• 👆 Touch-Friendly: Large tap targets and optimized button sizes for mobile use
• 📊 Adaptive Tables: Tables automatically hide less critical columns on mobile for better readability
• 🎯 Optimized Layouts: Content stacks vertically on mobile for easy scrolling
• ✨ Smooth Interactions: Tooltips and hover effects work seamlessly on touch devices

6. File Upload Guide

6.1 File Format Requirements

Required Format:

• File Type: .xlsx or .csv
• Maximum Size: 10MB (Monthly), 20MB (Annual)
• Required Sheets: M2 (Morbidity) and M3 (Mortality)
• Must include TOTAL columns for male and female
• Follow exact column headers as shown in FormatGuide.xlsx

6.2 File Naming Convention

6.3 Municipality Codes

6.4 Upload Process (Members & Admin)

1. Login to your account
2. Navigate to "Manage Files" (Members) or "Manage Files" (Admin)
3. Select month from dropdown
4. Select year from dropdown
5. Choose file (must follow format guide)
6. Important: File name month and year MUST match dropdown selections
7. Click "Upload File"
8. Wait for processing (10-30 seconds)
9. Verify success message

6.5 File Status Tracking

Members can track their files through different statuses:

• Pending: File uploaded, awaiting admin approval
• Approved: File approved and data processed into system
• Rejected: File rejected (view reason by clicking "View Reason")
• Deletion Requested: Member requested deletion, awaiting admin action

6.6 Requesting File Deletion (Members Only)

Members can request deletion of approved files:

1. Go to "Manage Files" page
2. Find the approved file you want to delete
3. Click "Request Deletion" button
4. Enter a detailed reason (minimum 10 characters)
5. Click "Submit Request"
6. File moves to "Deletion Requests" tab
7. Wait for admin to review and approve deletion

7. Dashboard Guide

7.1 Filter Options

The dashboard provides multiple filtering options:

View Period Selection

• Monthly: View data by individual months
• Quarterly: View data grouped by quarters (Q1, Q2, Q3, Q4)
• Yearly: View annual aggregated data

Time Period Filters

• Year: Select specific year or "All Years"
• Month: Select specific month or "All Months" (Monthly view only)
• Quarter: Select Q1, Q2, Q3, Q4, or multiple quarters (Quarterly view only)

Location Filters

• Municipality: Filter by specific municipality or view all

Case Type Filters

• Case Type: Morbidity, Mortality, or All
• Disease Type: Specific pneumonia types

Demographic Filters

• Age Group: Filter by age ranges
• Gender: Male, Female, or All

7.2 Understanding Charts

Municipality Comparison Chart

Bar chart showing total cases per municipality, sorted from highest to lowest.

Yearly Trends Chart

Line chart displaying pneumonia trends across multiple years (2020-2025).

Morbidity vs Mortality Chart

Stacked bar chart comparing morbidity and mortality cases.

Age Group Distribution

Pie chart showing case distribution across age groups.

8. Interactive Maps

8.1 Map Features

• Color Intensity: Darker colors indicate higher case counts
• Hover Tooltips: Move your mouse over any municipality to see its name and case count instantly
• Click Details: Click on a municipality to open a detailed modal with full statistics
• Dynamic Filters: Filter by year, month, case type, disease, and age group
• Real-time Updates: Map colors update automatically when filters are applied

8.2 Color Legend (Updated for Higher Case Volumes)

The intensity scale is designed to handle thousands of cases over multiple years:

9. Reports & Export (Admin Only)

9.1 CSV Export

How to Export:

1. Apply desired filters on dashboard
2. Click "Export CSV" button
3. File downloads automatically
4. Open in Excel or Google Sheets

9.2 FHSIS Report Generation

How to Generate Monthly Report:

1. Select "Monthly" view period
2. Select desired month and year
3. Apply other filters (municipality, case type)
4. Click "Generate Report" button
5. Report opens in new tab with selected month
6. Click "Print Report" or use Ctrl+P
7. Select "Save as PDF" or print directly

How to Generate Quarterly Report:

1. Select "Quarterly" view period
2. Select desired quarter(s) - Q1, Q2, Q3, or Q4
3. Select year
4. Apply other filters (municipality, case type)
5. Click "Generate Report" button
6. Report opens showing selected quarter(s) in header
7. Data includes all months within selected quarter(s)
8. Click "Print Report" or use Ctrl+P to save as PDF

9.3 Report Features

• Official FHSIS header format
• Province: LA UNION
• Dynamic period display (month, quarter, or year)
• Includes all relevant charts and visualizations
• Grouped by municipality and disease type
• Summary statistics included
• Signature sections for approval
• Print-optimized layout

10. Troubleshooting

10.1 Common Issues

Issue: Cannot see data on dashboard

Solution:

• Check if filters are too restrictive
• Try selecting "All" for year and municipality
• Verify data has been uploaded for selected period

Issue: File upload fails

Solution:

• Verify file follows FormatGuide.xlsx structure
• Check file size (must be under 10MB)
• Ensure file name follows naming convention
• Verify M2 and M3 sheets exist
• Check month/year match: File name month and year MUST match dropdown selections
• Example: If you select "APRIL 2025", file must be named "XXX-APRIL-2025.xlsx"

Issue: Cannot request file deletion

Solution:

• Only approved files can have deletion requests
• Pending or rejected files cannot be deleted via request
• Ensure you're logged in as a member (not admin)
• Check if deletion request already exists for that file

Issue: Quarterly view shows no data

Solution:

• Verify data exists for months within selected quarter
• Check if year filter is correctly set
• Try selecting multiple quarters to see more data
• Ensure municipality filter isn't too restrictive
• Check for TOTAL columns in both sheets

Issue: Map not showing municipality

Solution:

• Verify data exists for that municipality
• Check if filters are excluding the data
• Try refreshing the page

Issue: Export/Report buttons not visible

Solution:

• These features are admin-only
• Login with admin credentials
• Buttons will appear after login

11. Frequently Asked Questions

Q: How often should data be uploaded?

A: Monthly reports should be uploaded at the end of each month or as soon as data is available.

Q: Can I upload data for previous years?

A: Yes, the system accepts data from 2020 onwards. Use the appropriate year in the file name and upload form.

Q: What pneumonia types are tracked?

A: The system tracks all pneumonia types including:

• Pediatric Community Acquired Pneumonia A (PCAP A)
• Pediatric Community Acquired Pneumonia B (PCAP B)
• Community Acquired Pneumonia (CAP)
• Pneumonia (Unspecified)
• Other pneumonia types

Q: How is fatality rate calculated?

A: Fatality Rate = (Mortality Cases ÷ Total Cases) × 100

Q: Can I download the user manual?

A: Yes! Click the "Print / Save as PDF" button at the top-right of this page, then select "Save as PDF" in the print dialog.

Q: What's the difference between quarterly and monthly view?

A: Monthly view shows data for individual months, while quarterly view groups data into 3-month periods (Q1: Jan-Mar, Q2: Apr-Jun, Q3: Jul-Sep, Q4: Oct-Dec). Quarterly view is useful for identifying seasonal trends and comparing performance across quarters.

Q: Can members delete their uploaded files?

A: Members cannot directly delete files. Instead, they can request deletion by clicking "Request Deletion" on approved files and providing a reason. The admin will review and approve the deletion request.

Q: What happens if I upload a file with the wrong month in the filename?

A: The system will reject the upload with an error message. The month and year in your filename must exactly match the month and year you selected in the dropdown menus. For example, if you select "APRIL 2025" from the dropdowns, your file must be named "XXX-APRIL-2025.xlsx".

Q: Can I cancel a deletion request?

A: Yes! Members can cancel deletion requests anytime before the admin acts on them. Go to the "Deletion Requests" tab in your Manage Files page and click "Cancel Request".

Q: How do I generate a report for multiple quarters?

A: Select "Quarterly" view period, then hold Ctrl (Windows) or Cmd (Mac) while clicking multiple quarters (e.g., Q1 and Q2). Click "Generate Report" and the report will include data from all selected quarters.

Q: Where can I find the file format template?

A: The FormatGuide.xlsx template is available for download on the "Manage Files" page. Look for the blue download button at the top of the upload form. This template shows the exact structure, column headers, and sheet names (M2 for Morbidity, M3 for Mortality) required for successful file uploads.

Q: Do I need to follow the FormatGuide.xlsx exactly?

A: Yes! The system requires exact column headers and sheet names as shown in the FormatGuide.xlsx. Any deviation may cause upload errors or data processing failures. Download the template and use it as a reference when preparing your data files.

12. Appendix

12.1 Keyboard Shortcuts

12.2 Contact Information

12.3 Glossary