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.

Request flow

From click to database

Browser / TVWeb UI, polling for chat, presence & notifications
/go dispatcherValidates session, loads permissions, picks v1 or v2 UI
Page modulesmpages/ (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
Technology

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.

Data model

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

PathHandlerPurpose
/loginlogin.jspSign-in page
/loginvvalidate.jspCredential check, session & remember-me cookie
/registerregister.jspInvitation-based self-registration
/gomainPage.jspMain dispatcher — renders every in-app page via ?linkname=
/uploadmpages/ticket_attachment_upload.jspMultipart uploads up to 1 GB
/mediampages/ticket_media_serve.jspAttachment streaming
/usersearchmpages/user_search.jsp@mention user lookup (AJAX)
/notifactionmpages/notification_action.jspMark notifications read (AJAX)

Mobile API (/mapi)

EndpointPurpose
api_login.jspAuthenticate and return user & organisation
api_dashboard.jspDashboard statistics
api_tickets.jspTicket lists
api_ticket_detail.jspSingle ticket with details
api_tags.jspOrganisation tags
api_update_token.jspRegister an FCM device token
api_test_push.jspSend a test push notification

Now see what it does

Explore the 29 features this architecture powers.

Browse features