Creating an advanced Office Management System (OMS) involves designing a robust database structure and implementing a Flask application with Bootstrap 5 for the frontend. Below is a comprehensive guide to help you set up the project.

Database Structure

We'll use SQLAlchemy for ORM in Flask. Here’s a suggested database schema:

Tables

• Users: Stores user information (trainers, trainees, and admins).
• Departments: Stores department information.
• Meetings: Stores meeting details.
• Tasks: Stores task details.
• Documents: Stores document details.

Database Models

from flask_sqlalchemy import SQLAlchemy
from datetime import datetime
db = SQLAlchemy()
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    password_hash = db.Column(db.String(128), nullable=False)
    role = db.Column(db.String(50), nullable=False)  # e.g., 'admin', 'employee'
    created_at = db.Column(db.DateTime, default=datetime.utcnow)
class Department(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), unique=True, nullable=False)
    employees = db.relationship('User ', backref='department', lazy=True)
class Meeting(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(200), nullable=False)
    description = db.Column(db.Text, nullable=True)
    start_time = db.Column(db.DateTime, nullable=False)
    end_time = db.Column(db.DateTime, nullable=False)
    created_by = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
    created_at = db.Column(db.DateTime, default=datetime.utcnow)
    participants = db.relationship('MeetingParticipant', backref='meeting', lazy=True)
class MeetingParticipant(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    meeting_id = db.Column(db.Integer, db.ForeignKey('meeting.id'), nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class Task(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(200), nullable=False)
    description = db.Column(db.Text, nullable=True)
    assigned_to = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
    due_date = db.Column(db.DateTime, nullable=False)
    status = db.Column(db.String(50), default='Pending')  # e.g., 'Pending', 'Completed'
    created_at = db.Column(db.DateTime, default=datetime.utcnow)
class Document(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(200), nullable=False)
    file_path = db.Column(db.String(500), nullable=False)
    uploaded_by = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
    uploaded_at = db.Column(db.DateTime, default=datetime.utcnow)

Flask Application Structure

Here’s a basic structure for your Flask application:

office_management_system/
│
├── app.py
├── config.py
├── models.py
├── forms.py
├── static/
│   └── css/
│       └── styles.css
│   └── js/
│       └── scripts.js
└── templates/
    ├── base.html
    ├── index.html
    ├── login.html
    ├── dashboard.html
    ├── meetings.html
    ├── tasks.html
    └── documents.html

Flask Application Code

app.py

from flask import Flask, render_template, redirect, url_for, flash, request
from flask_sqlalchemy import SQLAlchemy
from flask_login import LoginManager, UserMixin, login_user, login_required, logout_user, current_user
from werkzeug.security import generate_password_hash, check_password_hash
from forms import LoginForm, RegistrationForm
from models import db, User, Department, Meeting, Task, Document
app = Flask(__name__)
app.config.from_object('config.Config')
db.init_app(app)
login_manager = LoginManager()
login_manager.init_app(app)
login_manager.login_view = 'login'
@login_manager.user_loader
def load_user(user_id):
    return User.query.get(int(user_id))
@app.route('/')
def index():
    return render_template('index.html')
@app.route('/login', methods=['GET', 'POST'])
def login():
    form = LoginForm()
    if form.validate_on_submit():
        user = User.query.filter_by(email=form.email.data).first()
        if user and check_password_hash(user.password_hash, form.password.data):
            login_user(user)
            return redirect(url_for('dashboard'))
        flash('Login Unsuccessful. Please check email and password', 'danger')
    return render_template('login.html', form=form)
@app.route('/dashboard')
@login_required
def dashboard():
    return render_template('dashboard.html')
@app.route('/meetings', methods=['GET', 'POST'])
@login_required
def meetings():
    if request.method == 'POST':
        title = request.form['title']
        description = request.form['description']
        start_time = request.form['start_time']
        end_time = request.form['end_time']
        new_meeting = Meeting(title=title, description=description, start_time=start_time, end_time=end_time, created_by=current_user.id)
        db.session.add(new_meeting)
        db.session.commit()
        flash('Meeting created successfully!', 'success')
        return redirect(url_for('meetings'))
    all_meetings = Meeting.query.all()
    return render_template('meetings.html', meetings=all_meetings)
@app.route('/tasks', methods=['GET', 'POST'])
@login_required
def tasks():
    if request.method == 'POST':
        title = request.form['title']
        description = request.form['description']
        due_date = request.form['due_date']
        new_task = Task(title=title, description=description, assigned_to=current_user.id, due_date=due_date)
        db.session.add(new_task)
        db.session.commit()
        flash('Task created successfully!', 'success')
        return redirect(url_for('tasks'))
    all_tasks = Task.query.all()
    return render_template('tasks.html', tasks=all_tasks)
@app.route('/documents', methods=['GET', 'POST'])
@login_required
def documents():
    if request.method == 'POST':
        title = request.form['title']
        file = request.files['file']
        file_path = f'static/uploads/{file.filename}'
        file.save(file_path)
        new_document = Document(title=title, file_path=file_path, uploaded_by=current_user.id)
        db.session.add(new_document)
        db.session.commit()
        flash('Document uploaded successfully!', 'success')
        return redirect(url_for('documents'))
    all_documents = Document.query.all()
    return render_template('documents.html', documents=all_documents)
if __name__ == '__main__':
    app.run(debug=True)

HTML Templates

templates/base.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="{{ url_for('static', filename='css/styles.css') }}">
    <title>{% block title %}Office Management System{% endblock %}</title>
</head>
<body>
    <nav class="navbar navbar-expand-lg navbar-light bg-light">
        <div class="container-fluid">
            <a class="navbar-brand" href="{{ url_for('index') }}">OMS</a>
            <div class="collapse navbar-collapse">
                <ul class="navbar-nav me-auto mb-2 mb-lg-0">
                    <li class="nav-item"><a class="nav-link" href="{{ url_for('dashboard') }}">Dashboard</a></li>
                    <li class="nav-item"><a class="nav-link" href="{{ url_for('meetings') }}">Meetings</a></li>
                    <li class="nav-item"><a class="nav-link" href="{{ url_for('tasks') }}">Tasks</a></li>
                    <li class="nav-item"><a class="nav-link" href="{{ url_for('documents') }}">Documents</a></li>
                </ul>
                <ul class="navbar-nav">
                    {% if current_user.is_authenticated %}
                        <li class="nav-item"><a class="nav-link" href="{{ url_for('logout') }}">Logout</a></li>
                    {% else %}
                        <li class="nav-item"><a class="nav-link" href="{{ url_for('login') }}">Login</a></li>
                    {% endif %}
                </ul>
            </div>
        </div>
    </nav>
    <div class="container mt-4">
        {% with messages = get_flashed_messages() %}
            {% if messages %}
                <div class="alert alert-warning" role="alert">
                    {% for message in messages %}
                        {{ message }}<br>
                    {% endfor %}
                </div>
            {% endif %}
        {% endwith %}
        {% block content %}{% endblock %}
    </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

templates/index.html

{% extends 'base.html' %}
{% block title %}Home{% endblock %}
{% block content %}
<h1>Welcome to the Office Management System</h1>
<p>This is a platform to manage your office tasks, meetings, and documents efficiently.</p>
{% endblock %}

templates/login.html

{% extends 'base.html' %}
{% block title %}Login{% endblock %}
{% block content %}
<h2>Login</h2>
<form method="POST">
    {{ form.hidden_tag() }}
    <div class="mb-3">
        {{ form.email.label(class="form-label") }}
        {{ form.email(class="form-control") }}
    </div>
    <div class="mb-3">
        {{ form.password.label(class="form-label") }}
        {{ form.password(class="form-control") }}
    </div>
    <button type="submit" class="btn btn-primary">Login</button>
</form>
{% endblock %}

templates/dashboard.html

{% extends 'base.html' %}
{% block title %}Dashboard{% endblock %}
{% block content %}
<h2>Dashboard</h2>
<p>Welcome, {{ current_user.username }}! Here you can manage your tasks, meetings, and documents.</p>
{% endblock %}

templates/meetings.html

{% extends 'base.html' %}
{% block title %}Meetings{% endblock %}
{% block content %}
<h2>Meetings</h2>
<form method="POST">
    <div class="mb-3">
        <label for="title" class="form-label">Meeting Title</label>
        <input type="text" class="form-control" name="title" required>
    </div>
    <div class="mb-3">
        <label for="description" class="form-label">Description</label>
        <textarea class="form-control" name="description"></textarea>
    </div>
    <div class="mb-3">
        <label for="start_time" class="form-label">Start Time</label>
        <input type="datetime-local" class="form-control" name="start_time" required>
    </div>
    <div class="mb-3">
        <label for="end_time" class="form-label">End Time</label>
        <input type="datetime-local" class="form-control" name="end_time" required>
    </div>
    <button type="submit" class="btn btn-primary">Create Meeting</button>
</form>
<h3>Upcoming Meetings</h3>
<ul class="list-group mt-3">
    {% for meeting in meetings %}
        <li class="list-group-item">
            <strong>{{ meeting.title }}</strong> - {{ meeting.start_time }} to {{ meeting.end_time }}
            <p>{{ meeting.description }}</p>
        </li>
    {% endfor %}
</ul>
{% endblock %}

templates/tasks.html

{% extends 'base.html' %}
{% block title %}Tasks{% endblock %}
{% block content %}
<h2>Tasks</h2>
<form method="POST">
    <div class="mb-3">
        <label for="title" class="form-label">Task Title</label>
        <input type="text" class="form-control" name="title" required>
    </div>
    <div class="mb-3">
        <label for="description" class="form-label">Description</label>
        <textarea class="form-control" name="description"></textarea>
    </div>
    <div class="mb-3">
        <label for="due_date" class="form-label">Due Date</label>
        <input type="date" class="form-control" name="due_date" required>
    </div>
    <button type="submit" class="btn btn-primary">Create Task</button>
</form>
<h3>All Tasks</h3>
<ul class="list-group mt-3">
    {% for task in tasks %}
        <li class="list-group-item">
            <strong>{{ task.title }}</strong> - Due: {{ task.due_date }} - Status: {{ task.status }}
            <p>{{ task.description }}</p>
        </li>
    {% endfor %}
</ul>
{% endblock %}

templates/documents.html

{% extends 'base.html' %}
{% block title %}Documents{% endblock %}
{% block content %}
<h2>Documents</h2>
<form method="POST" enctype="multipart/form-data">
    <div class="mb-3">
        <label for="title" class="form-label">Document Title</label>
        <input type="text" class="form-control" name="title" required>
    </div>
    <div class="mb-3">
        <label for="file" class="form-label">Upload Document</label>
        <input type="file" class="form-control" name="file" required>
    </div>
    <button type="submit" class="btn btn-primary">Upload Document</button>
</form>
<h3>Uploaded Documents</h3>
<ul class="list-group mt-3">
    {% for document in documents %}
        <li class="list-group-item">
            <strong>{{ document.title }}</strong> - <a href="{{ url_for('static', filename=document.file_path) }}">Download</a>
        </li>
    {% endfor %}
</ul>
{% endblock %}

Additional Files

config.py

import os
class Config:
    SECRET_KEY = os.environ.get('SECRET_KEY') or 'your_secret_key'
    SQLALCHEMY_DATABASE_URI = os.environ.get('DATABASE_URL') or 'sqlite:///site.db'
    SQLALCHEMY_TRACK_MODIFICATIONS = False
    

forms.py

from flask_wtf import FlaskForm
from wtforms import StringField, PasswordField, SubmitField, TextAreaField, DateTimeField
from wtforms.validators import DataRequired, Email, EqualTo
class LoginForm(FlaskForm):
    email = StringField('Email', validators=[DataRequired(), Email()])
    password = PasswordField('Password', validators=[DataRequired()])
    submit = SubmitField('Login')
class RegistrationForm(FlaskForm):
    username = StringField('Username', validators=[DataRequired()])
    email = StringField('Email', validators=[DataRequired(), Email()])
    password = PasswordField('Password', validators=[DataRequired()])
    confirm_password = PasswordField('Confirm Password', validators=[DataRequired(), EqualTo('password')])
    submit = SubmitField('Register')

Running the Application

Install Dependencies: Make sure you have Flask and other required packages installed. You can do this using pip:

pip install Flask Flask-SQLAlchemy Flask-Login Flask-WTF

Initialize the Database: Before running the application, you need to create the database. You can do this by running the following commands in a Python shell:

from app import db
db.create_all()

Run the Application: Start the Flask application by running:

python app.py

Access the Application: Open your web browser and go to http://127.0.0.1:5000/ to access the Office Management System.

This setup provides a solid foundation for an advanced Office Management System using Flask and Bootstrap 5. You can further enhance it by adding features like user roles, notifications, and more complex task management functionalities.