How sahbimlesh007/employee-support-ticket-tracker works
This Streamlit helpdesk lets employees and support staff create tickets, browse and search records, update ticket status, and review ticket and priority analytics. The main entry point, app.py, dispatches UI actions to ticket-operation modules; those modules obtain connections through db.py and query MySQL. The dashboard computes metrics from fetched tickets, while the ticket view supports filtering, sorting, and CSV export. README capabilities are included where documented; source excerpts show the concrete call paths, but do not establish wiring for every documented reporting capability.
Main entry points: search_ticket.py Fetch and search tickets · app.py Application navigation · create_ticket.py Create ticket · update_ticket.py Update ticket status
Components 13
Streamlit interface
- Application navigation
app.py - Ticket entry form
app.py - Ticket list and export
app.py - Ticket search form
app.py - Status update form
app.py - Dashboard metrics and charts
app.py
Ticket workflows
- Create ticket
create_ticket.py - Fetch and search tickets
search_ticket.py - Update ticket status
update_ticket.py
Persistence and analytics
- Database connection
db.py - MySQL tickets store
- Tickets table schema
MySQL/table.sql
Other components
- Employee / support user
Connections 24
- Employee / support user → Application navigation: uses
- Application navigation → Ticket entry form: dispatches
- Application navigation → Ticket list and export: dispatches
- Application navigation → Ticket search form: dispatches
- Application navigation → Status update form: dispatches
- Application navigation → Dashboard metrics and charts: dispatches
- Ticket entry form → Create ticket: submits
- Create ticket → Database connection: opens connection
- Create ticket → MySQL tickets store: inserts ticket
- Ticket list and export → Fetch and search tickets: fetches tickets
- Dashboard metrics and charts → Fetch and search tickets: fetches tickets
- Ticket search form → Fetch and search tickets: searches tickets
- Fetch and search tickets → Database connection: opens connection
- Fetch and search tickets → MySQL tickets store: reads tickets
- Status update form → Update ticket status: submits status
- Update ticket status → Database connection: opens connection
- Update ticket status → MySQL tickets store: updates status
- MySQL tickets store → Fetch and search tickets: returns rows
- Fetch and search tickets → Ticket list and export: returns records
- Fetch and search tickets → Dashboard metrics and charts: returns records
- Fetch and search tickets → Ticket search form: returns matches
- Dashboard metrics and charts → Employee / support user: shows analytics
- Ticket list and export → Employee / support user: shows / exports CSV
- Tickets table schema → MySQL tickets store: defines table