Corporate Bot with Admin Panel and Broadcasting (Aiogram 3)

Development of a corporate chat bot for ViknaDOMI company. The solution combines a private product catalog, a knowledge base, and an administrator panel for content management without code access.

Tech Stack: Python 3.11, Aiogram 3.x, SQLAlchemy (PostgreSQL/SQLite).

Security and Access Control (ACL):
— Phone Verification: Access is granted only via contact sharing to prevent unauthorized entry.
— Manual Moderation: Administrators receive join requests directly in the chat with options to approve or decline.
— Privacy: Full blocking of menus and content until the employee/partner is verified.
— Dynamic Interface: Command visibility (e.g., /admin) changes in real-time based on the user's role.
Admin Panel (In-bot CMS):
— Content Management: Administrators can add and delete photos, videos, and PDF files directly through the bot interface.
— Broadcasting: Mass messaging with media attachments to the user base with delivery reports.
— User Management: View user list, instant ban/unban capabilities.
— Support Mode: Reply to user inquiries directly via the message forwarding mechanism.
User Features:
— Tree-Structured Menu: Convenient navigation through categories.
— Media Galleries: Dynamic photo/video scrolling (pagination) implemented within a single message.
— Knowledge Base: Direct access to technical documentation and PDF blueprints.

Result:
Built an autonomous tool that allows the company to securely distribute internal information and manage employee access without involving a developer for routine tasks.
#python #aiogram #telegrambot #adminpanel #backend #botdevelopment