Telegram bot + web panel for managing construction projects (VSM Construction)

🏗️ 1. Project Meta

Create an internal company management system that will allow:

• to plan employees on projects
• to record actual work
• to receive daily reports from sites
• to control tasks after meetings
• to calculate person-days
• to calculate employee salaries
• to calculate project expenses
• to see the profitability of each project

👉 the system should be simple, fast, and convenient to work with on a phone

⚙️ 2. Architecture

The system consists of:

1. Telegram bot

For:

• employees
• foremen
• project manager

👉 information input

2. Web panel

For the manager

👉 control, analytics, management

👥 3. User Roles

• Manager — full access
• Project Manager — manages projects and tasks
• Foreman — reports, planning, tasks
• Employee — work attendance

🏗️ 4. Module: Projects

Fields:

name

• address
• start date
• end date
• responsible

Additionally:

• project amount (mandatory)
• additional expenses (optional)

Status:

• active
• paused
• completed

👷 5. Module: Employees

Fields:

• name
• role
• daily rate (mandatory)

📅 6. Module: Planning (key)

Function:

👉 “Plan for tomorrow”

Ability:

• to select a project
• to add employees
• to specify a date

👉 a team is formed for the day

✅ 7. Module: Actual Work

Employee or foreman:

• confirms attendance

Specifies:

• project
• full day / half day

📊 8. Person-Days

The system calculates:

• how many employees worked
• how many days
• total labor costs for the project

💰 9. Employee Salaries

Accounting:

• full day = 1
• half day = 0.5

Calculation:

Salary = days × rate

📌 Example:

Taras = 23 days × 120€ = 2760€

Additionally:

• bonuses
• penalties
• advances

Final salary:

salary + bonuses – penalties – advances

📊 10. Employee Expenses

The system:

• links employees to projects
• calculates expenses for each project

📈 11. Project Profitability

The system calculates:

• employee expenses
• additional expenses
• total expenses
• profit
• profitability (%)

📸 12. Daily Report

The foreman enters every day:

• what has been done
• how many people worked
• problems
• photos

📷 13. Photos

• stored by project
• by dates
• accessible in the panel

📋 14. Tasks After Meetings (important)

The project manager adds:

• Project
• task description
• deadline
• responsible

Statuses:

• not started
• in progress
• completed
• overdue

🔔 15. Task Control

The system:

• shows tasks for today
• shows overdue ones
• sends reminders

📱 16. Telegram Bot

Buttons:

• Plan for tomorrow
• Confirm attendance
• Add daily report
• Add photo
• Report a problem
• My tasks
• Complete task

💻 17. Web Panel

Dashboard:

• active projects
• problems
• overdue tasks

Projects:

• list
• expenses
• profit

Employees:

• list
• worked days
• salary

Finances:

• expenses
• profitability

🔐 18. Security

• login / password
• role-based access

📱 19. Requirements

• adaptation for phone
• simple interface
• fast operation