Telegram bot for barber shop

A Telegram bot for booking appointments with a master, featuring functionality for both clients and administrators. Clients can schedule a haircut by choosing a convenient date and time from the master's schedule, confirm or cancel the appointment. Automatic reminders are sent before and after the visit: one day before, one hour before, and two weeks after. There is a survey available regarding the condition of hair or beard, as well as the option to leave feedback and receive a one-time discount for participation. The bot allows viewing the price list of services and prices, browsing the master's portfolio (photos and videos from the media library), and automatically sends greetings and birthday discounts.

For the administrator, a flexible schedule management system is implemented (adding and editing working days), a complete client database with pagination and user cards, editing the price list and media, and setting discounts. Additionally, there is an option to mark whether the client has arrived and collect feedback in the form of a rating from 1 to 5 stars.

Technically, the bot is built on the Telegram Bot API using ConversationHandler and InlineKeyboard for dialogues and buttons. All interactions with the MySQL database are performed asynchronously using aiomysql. Data about clients, appointments, surveys, settings, and media files are stored. To ensure stability, logging and error handling are implemented.