Telegram bot for managing changes and tasks

Telegram bot for automating the management of work shifts, tracking task completion, and coordinating the team. Supports automatic reminders and an interactive marking system.
Main functionality
Group management

Registration of work groups via the command /start
Administration system with access levels (ROOT, MAIN, ADMIN)
Support for time zones
Management of administrators and their roles

Participant management

Adding/removing shift participants
Binding employees to shift types
Automatic tracking via username

Shift types

Creating different types of shifts with start/end times
Distribution of employees across shifts
Support for parallel shifts

Task templates

Creating text templates with dynamic variables
Support for HTML and Markdown formatting
Global templates for all groups

Attendance system

Personalized buttons for each participant
Automatic status update
Alternative marking methods (command /me, text "complete")
Visual indication of completed tasks

Automation

Automatic reminders based on templates
Recurring reminders with intervals
Reminders at specific times
Automatic stop when all tasks are completed

Technical stack

Python 3.9+
aiogram 3.x (asynchronous Telegram Bot API)
SQLAlchemy 2.x (ORM)
SQLite/PostgreSQL
asyncio
FSM (Finite State Machine)

Key features

Asynchronous architecture for high performance
Modular code structure
Cascading deletion of related records
Access rights verification
User input validation
Intuitive navigation through inline keyboards
HTML formatting of messages
Indexing tables for fast queries

Advantages

Automation of routine processes
Transparent control of task completion
Scalability for teams of any size
Working directly in Telegram without additional software
Support for multiple groups simultaneously
Reduction of time spent on team coordination

Expansion capabilities

Exporting statistics to Excel/PDF
Integration with calendars
Analytical dashboard with graphs
Multilingual support
REST API for integration