Build an Admin Panel for a Telegram Chatbot SaaS Platform (PHP + MySQL Based)

Core Requirements:

Authentication & Roles:

Admin login (separate from user login)

Role-based access control (Super Admin, Support Staff, Billing Staff)

User Management:

View all registered users (with filters: active, trial, expired, etc.)

Edit user details: name, email, status, subscription plan, bot usage

Suspend/ban user access

Reset password manually

Export user list (CSV/Excel)

Subscription & Pricing System:

Define multiple plans (e.g., Free Trial, Basic, Premium)

Set limits for each plan:

Max bots allowed

Max API calls per day/month

Features access (webhooks, custom reply, media, etc.)

All prices should be in INR ₹

Include 5-day Free Trial by default for new users

Setup for auto plan expiration

Payment & Invoicing:

Manual pricing system first (store data in DB)

Show pricing in INR

Allow invoice generation and management:

Mark invoice as paid/unpaid

Send invoice reminder emails automatically 1 day before due and on due date

Block bot activity once subscription expires or invoice unpaid

Store invoice PDFs for download

Bot Usage Monitoring:

View all bots created per user

Check bot status (active/inactive)

Track monthly usage (messages, commands triggered)

Option to deactivate or delete any bot manually

Announcements / Alerts:

Add an admin notice section to display announcements on user dashboard

Schedule alerts (e.g., maintenance, downtime, new feature)

Logs & History:

Admin activity log (login, user updates, pricing edits)

User action log (bot created, plan changed, login timestamps)

Dashboard Summary:

Total users, bots, active trials, paid users

Earnings this month

Plan distribution chart

Button to add new user manually

Security:

All admin routes protected

Session timeout after inactivity

Login attempt limiter and IP logging

Tech Stack Guidelines:

PHP (Core, no frameworks)

MySQL for DB

Bootstrap or Tailwind CSS for UI

jQuery or Vanilla JS for basic interactions

Clean MVC-like folder structure