VetsLab

MODULE: Registration Report
Navigation: Login → Sidebar → Reports → Registration Report
🎯 TASK OBJECTIVE:
Develop a Professional Registration Report Module with:
Modern UI layout
Advanced filtering
Summary dashboard cards
Server-side pagination
Sorting
Global search
Export (Excel, PDF, Print)
Enterprise-wise data isolation
High performance for large datasets
This should look like a modern hospital reporting dashboard, not a basic HTML table.

🖥 PART 1 — FRONTEND IMPLEMENTATION
✅ 1️⃣ Page Layout Structure
The page must contain:
Section 1 — Header
Title: Registration Report
Breadcrumb: Home / Reports / Registration Report

Section 2 — Filter Card (Top Section)
Filters Required:
Today
Date From (Date picker) - Date To (Date picker)
Species (Dropdown – dynamic)
Breed (Dropdown – dynamic)
Sample Type (Dropdown – dynamic)
Owner Name (Text input)
Mobile (Text input)

Buttons:
Apply Filters
Reset
Export Excel
Export PDF
All filters must call backend API with query parameters.

Section 3 — Summary Cards (Below Filters)
Create 4 dashboard cards:
Total Registrations
Today Registrations
Total Revenue

These must update based on filters applied.

Section 4 — Report Table
Columns:
Patient ID
Date
Patient Name
Sample Type
Species
Breed
Owner Name
Mobile
Consultation Fee

Features required:
✔ Sticky header
✔ Column sorting (server-side)
✔ Pagination (server-side)
✔ Column resizing
✔ Row hover highlight
✔ Alternating row color
✔ Global search input above table
✔ Rows per page selector

Section 5 — Pagination Footer
Display:
Showing 1–10 of 14,908 records
With:
Previous | 1 2 3 ... | Next

✅ 2️⃣ Backend Logic

Filter by enterprise_id from session
Apply all filters
Apply sorting
Apply pagination
Return total count
Return filtered summary statistics

✅ 3️⃣ Response Format
{
"total": 14908,
"page": 1,
"page_size": 10,
"summary": {
"total_registrations": 14908,
"today_registrations": 34,
"total_revenue": 345000,
"average_fee": 860
},
"results": [ ... ]
}

📊 PART 3 — EXPORT FUNCTIONALITY
Excel Export:
Export filtered data only.

PDF Export:
Clean A4 landscape format.
Print

Frontend printable layout:
Proper header
Date range display
Filter info visible
No sidebar in print view

🔐 VALIDATIONS
✔ Enterprise isolation mandatory
✔ Must handle 10,000+ records efficiently
✔ No loading full dataset at once

📈 PERFORMANCE REQUIREMENTS
Server-side pagination only
Optimized SQL joins
Select only required columns
Avoid N+1 queries

🔄 SYSTEM FLOW
User opens Registration Report
→ Default Today loaded
→ User applies filters
→ Backend processes filtered query
→ Summary cards update
→ Table updates
→ User exports if needed

✅ COMPLETION CRITERIA
✔ Professional UI implemented
✔ Filters working
✔ Summary cards dynamic
✔ Server-side pagination working
✔ Sorting working
✔ Global search working
✔ Excel export working
✔ PDF export working
✔ Print layout correct
✔ Enterprise filtering working
✔ Performance optimized