LGU GradFlow: Transforming Academic Management Through Automation
About the Project
https://lgu-gradflow.web.app/login
LGU GradFlow is a comprehensive academic management system designed for Lahore Garrison University that digitizes and automates the entire Final Year Project (FYP) lifecycle and degree completion workflow. This platform eliminates manual paperwork, reduces processing delays, and provides transparent, real-time tracking for students, faculty, and administrators.
What Inspired This Project
The inspiration for LGU GradFlow came from recognizing the inefficiencies in traditional academic management systems. Students often face delays due to manual clearance processes, lost documents, and lack of visibility into their application status. Faculty members struggle with paper-based workflows, making it difficult to track and manage multiple student projects simultaneously.
The goal was to create a unified digital platform that:
- Eliminates paperwork: All submissions, approvals, and clearances happen digitally
- Provides transparency: Students can track their progress at every stage
- Reduces delays: Automated notifications and workflow management ensure timely processing
- Ensures security: Role-based access control prevents unauthorized access
- Improves accountability: Complete audit trail of all actions and decisions
What I Learned
Building LGU GradFlow was an incredible learning journey that covered multiple aspects of modern web development:
Technical Skills
- React Ecosystem: Mastered React 18 with Vite, React Router v6, and Context API for state management
- Firebase Integration: Implemented Firebase Authentication and Firestore for real-time data management
- Supabase Storage: Learned to integrate Supabase for file storage while using Firestore for structured data
- Modern UI/UX: Created a responsive, accessible interface with Tailwind CSS and dark mode support
- Workflow Automation: Designed complex multi-stage approval workflows with proper state management
Architecture & Design
- Modular Architecture: Built a scalable, maintainable codebase with clear separation of concerns
- Service Layer Pattern: Created reusable service modules for FYP operations, clearances, and notifications
- Role-Based Access Control: Implemented comprehensive permission system for 8 different user roles
- Real-time Updates: Leveraged Firestore's real-time capabilities for instant status updates
Problem-Solving
- Composite Index Challenges: Learned to work around Firestore's indexing requirements with JavaScript fallbacks
- User Approval Workflow: Solved the chicken-and-egg problem of needing an admin to approve other admins
- File Upload Management: Integrated Supabase Storage seamlessly with Firebase authentication
- State Synchronization: Ensured consistent data across multiple components and pages
How I Built the Project
Phase 1: Foundation & Authentication
I started by setting up the React Vite project with Tailwind CSS for styling. The authentication system was built using Firebase Auth, with a custom AuthContext that manages user sessions and role-based access. I implemented a user approval system where non-student accounts require admin approval before they can log in.
Phase 2: Core FYP Workflow
The FYP management system was built with a clear workflow:
- Idea Submission: Students submit FYP ideas with descriptions, objectives, and technologies
- Supervisor Review: Supervisors can see all pending ideas and approve/reject them
- Supervisor Selection: Students select supervisors for approved ideas
- Enrollment: HOD approves the FYP enrollment
- Document Uploads: Students upload Proposal, SRS, and Final Documentation at appropriate stages
- Supervisor Reviews: Supervisors review and approve each document
- Evaluation: Internal and External examiners evaluate the completed projects
Phase 3: Degree Clearance System
I created a unified clearance system that replaces 4 separate manual forms:
- Department Clearance: HOD approval
- Academic Clearance: Dean approval
- Student Affairs Clearance: Hostel/Library/Lab clearance
- Accounts Clearance: Financial dues verification
All clearances are tracked in real-time, and students receive notifications at each stage.
Phase 4: File Management & Storage
To handle file uploads efficiently, I integrated Supabase Storage for document management. All proposals, SRS documents, and final theses are stored securely in Supabase, while metadata and status information are stored in Firestore for fast queries and real-time updates.
Phase 5: Notification System
A comprehensive notification system keeps all users informed:
- Students receive notifications for approvals, rejections, and stage progressions
- Supervisors are notified when students submit documents
- Admins receive notifications for new user registration requests
- All notifications are stored in Firestore and displayed in a dropdown interface
Phase 6: UI/UX Enhancement
I implemented:
- Dark Mode: Complete dark mode support across all pages
- Responsive Design: Mobile-first approach with collapsible sidebar
- Status Indicators: Color-coded status badges and icons
- Progress Tracking: Visual progress indicators for FYP stages
- Intuitive Navigation: Role-based navigation menus
Challenges Faced
1. Firestore Composite Index Requirements
Challenge: Firestore requires composite indexes when using where and orderBy on different fields, which can cause queries to fail in production.
Solution: Implemented JavaScript-based sorting as a fallback, and designed queries to minimize index requirements. Added error handling to gracefully fall back to client-side filtering when needed.
2. User Approval Workflow
Challenge: Creating an admin account required an existing admin to approve it, creating a chicken-and-egg problem.
Solution: Implemented auto-approval logic for the first admin account. If no approved admins exist, the first admin registration is automatically approved.
3. Real-time Data Synchronization
Challenge: Ensuring that data updates are reflected immediately across all components without manual refreshes.
Solution: Leveraged Firestore's real-time listeners and React's useEffect hooks to automatically refresh data when changes occur. Added proper dependency arrays to prevent unnecessary re-renders.
4. File Upload Integration
Challenge: Integrating Supabase Storage with Firebase authentication while maintaining security and proper file organization.
Solution: Created a dedicated storageService that handles all file operations. Files are organized by type (proposals, SRS, final documents) and linked to Firestore documents via URLs.
5. Complex Workflow State Management
Challenge: Managing the state of multi-stage workflows where each stage depends on previous approvals.
Solution: Created clear status fields for each stage (status, supervisor_status, enrollment_status, etc.) and implemented conditional logic to determine when users can perform actions. Added visual indicators and helpful messages to guide users.
6. Role-Based Access Control
Challenge: Ensuring that users can only access features appropriate for their role, while maintaining a clean, intuitive interface.
Solution: Implemented ProtectedRoute components that check both authentication and role. Created dynamic navigation menus that show only relevant options for each role.
Key Features
- ✅ Multi-Role System: 8 distinct user roles with role-specific dashboards and permissions
- ✅ FYP Lifecycle Management: Complete workflow from idea submission to final evaluation
- ✅ Document Management: Secure file uploads with Supabase Storage integration
- ✅ Real-time Tracking: Live status updates for all processes
- ✅ Notification System: Comprehensive notification system for all stakeholders
- ✅ Degree Clearance: Unified digital clearance replacing 4 manual forms
- ✅ User Approval System: Admin-controlled account creation for privileged roles
- ✅ Dark Mode: Full dark mode support for better user experience
- ✅ Responsive Design: Works seamlessly on desktop, tablet, and mobile devices
Technology Stack
- Frontend: React 18, Vite, Tailwind CSS
- Authentication: Firebase Authentication
- Database: Firebase Firestore
- File Storage: Supabase Storage
- Routing: React Router v6
- Icons: Lucide React
- State Management: React Context API
Future Enhancements
- Analytics dashboard with charts and statistics
- Email notifications in addition to in-app notifications
- Document versioning and revision history
- Plagiarism check integration
- Mobile app development
- Advanced reporting and export features
Conclusion
LGU GradFlow represents a complete transformation of academic management processes. By digitizing workflows that were previously manual and paper-based, the platform significantly improves efficiency, transparency, and user experience for all stakeholders. The project demonstrates the power of modern web technologies in solving real-world problems and creating meaningful impact in educational institutions.
Built with ❤️ for Lahore Garrison University