Under the hood
How TaskFlow is built
A pragmatic, server-rendered Java web application with a clean data model, a single request dispatcher and a JSON API for mobile.
From click to database
Browser / TVWeb UI, polling for chat, presence & notifications
/go dispatcherValidates session, loads permissions, picks v1 or v2 UI
Page modules
mpages/ (v1) · v2/ (modern)DAO classesConnection pool · prepared statements
MySQLOrganisation-scoped data
Mobile appJSON over HTTP
/mapiLogin, dashboard, tickets, tags, tokens
Firebase FCMPush notifications to devices
The stack
Java & JSP
Server-rendered pages on a Servlet 3.1 container (e.g. Apache Tomcat).
MySQL / MariaDB
InnoDB schema with foreign keys and utf8mb4 support.
DAO layer
Data-access classes (TicketDAO, ProjectDAO, UserDAO…) over a connection pool.
Bootstrap 4 & CSS
Grid utilities plus a custom design system with light & dark themes.
Frappe Gantt
Interactive timeline for the roadmap.
Chart.js & plugins
Charts, FullCalendar, Select2, Summernote, SweetAlert2, Toastr and DataTables.
Firebase (FCM)
Push notifications to the mobile app.
Font Awesome
Consistent iconography across every screen.
Tables at a glance
Grouped by responsibility. Core tables carry an organization_id for multi-tenancy.
Work
-
projects -
tickets -
sprints -
ticket_assignees -
tags -
ticket_tags
Collaboration
-
comments -
ticket_mentions -
ticket_attachments -
chat_messages -
notifications -
ticket_forward_history
People
-
users -
teams -
team_members -
team_settings -
project_members -
project_teams -
user_invitations
Access
-
roles -
permissions -
role_permissions
Operations
-
activity_log -
scheduled_tasks -
app_settings -
user_device_tokens
Web routes
| Path | Handler | Purpose |
|---|---|---|
/login | login.jsp | Sign-in page |
/loginv | validate.jsp | Credential check, session & remember-me cookie |
/register | register.jsp | Invitation-based self-registration |
/go | mainPage.jsp | Main dispatcher — renders every in-app page via ?linkname= |
/upload | mpages/ticket_attachment_upload.jsp | Multipart uploads up to 1 GB |
/media | mpages/ticket_media_serve.jsp | Attachment streaming |
/usersearch | mpages/user_search.jsp | @mention user lookup (AJAX) |
/notifaction | mpages/notification_action.jsp | Mark notifications read (AJAX) |
Mobile API (/mapi)
| Endpoint | Purpose |
|---|---|
api_login.jsp | Authenticate and return user & organisation |
api_dashboard.jsp | Dashboard statistics |
api_tickets.jsp | Ticket lists |
api_ticket_detail.jsp | Single ticket with details |
api_tags.jsp | Organisation tags |
api_update_token.jsp | Register an FCM device token |
api_test_push.jsp | Send a test push notification |
Now see what it does
Explore the 29 features this architecture powers.