Vou criar uma estrutura completa para o ChurchTime App com todas as funcionalidades solicitadas. Aqui está o projeto inicial: from flask import Flask, render_template, request, redirect, url_for, session, jsonify from flask_socketio import SocketIO, emit, join_room, leave_room from flask_mysqldb import MySQL import os from werkzeug.security import generate_password_hash, check_password_hash from functools import wraps app = Flask(__name__) app.secret_key = os.urandom(24) app.config['MYSQL_HOST'] = 'your_mysql_host' app.config['MYSQL_USER'] = 'your_mysql_user' app.config['MYSQL_PASSWORD'] = 'your_mysql_password' app.config['MYSQL_DB'] = 'churchtime_db' app.config['MYSQL_CURSORCLASS'] = 'DictCursor' mysql = MySQL(app) socketio = SocketIO(app) # Database initialization def init_db(): with app.app_context(): cur = mysql.connection.cursor() # Create tables if they don't exist cur.execute(""" CREATE TABLE IF NOT EXISTS users ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, password VARCHAR(200) NOT NULL, role VARCHAR(50) DEFAULT 'member', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) """) cur.execute(""" CREATE TABLE IF NOT EXISTS ministries ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, description TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) """) cur.execute(""" CREATE TABLE IF NOT EXISTS user_ministry ( user_id INT, ministry_id INT, role VARCHAR(50), PRIMARY KEY (user_id, ministry_id), FOREIGN KEY (user_id) REFERENCES users(id), FOREIGN KEY (ministry_id) REFERENCES ministries(id) ) """) cur.execute(""" CREATE TABLE IF NOT EXISTS songs ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(100) NOT NULL, artist VARCHAR(100), lyrics TEXT, chords TEXT, youtube_url VARCHAR(255), audio_url VARCHAR(255), created_by INT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (created_by) REFERENCES users(id) ) """) cur.execute(""" CREATE TABLE IF NOT EXISTS events ( id INT AUTO_INCREMENT PRIMARY KEY, ministry_id INT, name VARCHAR(100) NOT NULL, description TEXT, date DATETIME NOT NULL, location VARCHAR(100), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (ministry_id) REFERENCES ministries(id) ) """) cur.execute(""" CREATE TABLE IF NOT EXISTS schedules ( id INT AUTO_INCREMENT PRIMARY KEY, event_id INT, song_id INT, order_num INT, notes TEXT, FOREIGN KEY (event_id) REFERENCES events(id), FOREIGN KEY (song_id) REFERENCES songs(id) ) """) cur.execute(""" CREATE TABLE IF NOT EXISTS schedule_members ( schedule_id INT, user_id INT, role VARCHAR(50), PRIMARY KEY (schedule_id, user_id), FOREIGN KEY (schedule_id) REFERENCES schedules(id), FOREIGN KEY (user_id) REFERENCES users(id) ) """) cur.execute(""" CREATE TABLE IF NOT EXISTS messages ( id INT AUTO_INCREMENT PRIMARY KEY, ministry_id INT, user_id INT, message TEXT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (ministry_id) REFERENCES ministries(id), FOREIGN KEY (user_id) REFERENCES users(id) ) """) mysql.connection.commit() cur.close() # Login required decorator def login_required(f): @wraps(f) def decorated_function(*args, **kwargs): if 'user_id' not in session: return redirect(url_for('login')) return f(*args, **kwargs) return decorated_function # Admin required decorator def admin_required(f): @wraps(f) def decorated_function(*args, **kwargs): if 'user_id' not in session: return redirect(url_for('login')) cur = mysql.connection.cursor() cur.execute("SELECT role FROM users WHERE id = %s", (session['user_id'],)) user = cur.fetchone() cur.close() if user['role'] != 'admin': return redirect(url_for('dashboard')) return f(*args, **kwargs) return decorated_function # Routes @app.route('/') def index(): if 'user_id' in session: return redirect(url_for('dashboard')) return render_template('index.html') @app.route('/login', methods=['GET', 'POST']) def login(): if request.method == 'POST': email = request.form['email'] password = request.form['password'] cur = mysql.connection.cursor() cur.execute("SELECT * FROM users WHERE email = %s", (email,)) user = cur.fetchone() cur.close() if user and check_password_hash(user['password'], password): session['user_id'] = user['id'] session['user_name'] = user['name'] session['user_role'] = user['role'] return redirect(url_for('dashboard')) else: return render_template('login.html', error='Invalid credentials') return render_template('login.html') @app.route('/register', methods=['GET', 'POST']) def register(): if request.method == 'POST': name = request.form['name'] email = request.form['email'] password = generate_password_hash(request.form['password']) try: cur = mysql.connection.cursor() cur.execute("INSERT INTO users (name, email, password) VALUES (%s, %s, %s)", (name, email, password)) mysql.connection.commit() cur.close() return redirect(url_for('login')) except: return render_template('register.html', error='Email already exists') return render_template('register.html') @app.route('/dashboard') @login_required def dashboard(): cur = mysql.connection.cursor() # Get user's ministries cur.execute(""" SELECT m.* FROM ministries m JOIN user_ministry um ON m.id = um.ministry_id WHERE um.user_id = %s """, (session['user_id'],)) ministries = cur.fetchall() # Get upcoming events cur.execute(""" SELECT e.* FROM events e JOIN user_ministry um ON e.ministry_id = um.ministry_id WHERE um.user_id = %s AND e.date > NOW() ORDER BY e.date ASC LIMIT 5 """, (session['user_id'],)) events = cur.fetchall() # Get recent messages cur.execute(""" SELECT m.*, u.name as user_name FROM messages m JOIN users u ON m.user_id = u.id WHERE m.ministry_id IN ( SELECT ministry_id FROM user_ministry WHERE user_id = %s ) ORDER BY m.created_at DESC LIMIT 5 """, (session['user_id'],)) messages = cur.fetchall() cur.close() return render_template('dashboard.html', ministries=ministries, events=events, messages=messages) # Ministry routes @app.route('/ministries') @login_required def ministry_list(): cur = mysql.connection.cursor() if session['user_role'] == 'admin': cur.execute("SELECT * FROM ministries") else: cur.execute(""" SELECT m.* FROM ministries m JOIN user_ministry um ON m.id = um.ministry_id WHERE um.user_id = %s """, (session['user_id'],)) ministries = cur.fetchall() cur.close() return render_template('ministry/list.html', ministries=ministries) @app.route('/ministries/') @login_required def ministry_detail(id): cur = mysql.connection.cursor() # Check if user has access to this ministry cur.execute(""" SELECT 1 FROM user_ministry WHERE user_id = %s AND ministry_id = %s """, (session['user_id'], id)) has_access = cur.fetchone() if not has_access and session['user_role'] != 'admin': cur.close() return redirect(url_for('ministry_list')) # Get ministry details cur.execute("SELECT * FROM ministries WHERE id = %s", (id,)) ministry = cur.fetchone() # Get members cur.execute(""" SELECT u.id, u.name, um.role FROM users u JOIN user_ministry um ON u.id = um.user_id WHERE um.ministry_id = %s """, (id,)) members = cur.fetchall() # Get upcoming events cur.execute(""" SELECT * FROM events WHERE ministry_id = %s AND date > NOW() ORDER BY date ASC """, (id,)) events = cur.fetchall() # Get recent messages cur.execute(""" SELECT m.*, u.name as user_name FROM messages m JOIN users u ON m.user_id = u.id WHERE m.ministry_id = %s ORDER BY m.created_at DESC LIMIT 10 """, (id,)) messages = cur.fetchall() cur.close() return render_template('ministry/detail.html', ministry=ministry, members=members, events=events, messages=messages) # Song routes @app.route('/songs') @login_required def song_list(): cur = mysql.connection.cursor() if session['user_role'] == 'admin': cur.execute("SELECT * FROM songs") else: cur.execute(""" SELECT s.* FROM songs s JOIN user_ministry um ON s.created_by = um.user_id WHERE um.user_id = %s """, (session['user_id'],)) songs = cur.fetchall() cur.close() return render_template('music/list.html', songs=songs) @app.route('/songs/') @login_required def song_detail(id): cur = mysql.connection.cursor() cur.execute("SELECT * FROM songs WHERE id = %s", (id,)) song = cur.fetchone() # Check if user has access (either admin or in same ministry as creator) if session['user_role'] != 'admin': cur.execute(""" SELECT 1 FROM user_ministry WHERE user_id = %s AND ministry_id IN ( SELECT ministry_id FROM user_ministry WHERE user_id = %s ) """, (session['user_id'], song['created_by'])) has_access = cur.fetchone() if not has_access: cur.close() return redirect(url_for('song_list')) cur.close() return render_template('music/detail.html', song=song) # Event and schedule routes @app.route('/events/') @login_required def event_detail(id): cur = mysql.connection.cursor() # Get event details cur.execute("SELECT * FROM events WHERE id = %s", (id,)) event = cur.fetchone() # Check if user has access if session['user_role'] != 'admin': cur.execute(""" SELECT 1 FROM user_ministry WHERE user_id = %s AND ministry_id = %s """, (session['user_id'], event['ministry_id'])) has_access = cur.fetchone() if not has_access: cur.close() return redirect(url_for('dashboard')) # Get schedule cur.execute(""" SELECT s.*, so.title as song_title FROM schedules s LEFT JOIN songs so ON s.song_id = so.id WHERE s.event_id = %s ORDER BY s.order_num """, (id,)) schedule = cur.fetchall() # Get members assigned to this event cur.execute(""" SELECT DISTINCT u.id, u.name, sm.role FROM users u JOIN schedule_members sm ON u.id = sm.user_id JOIN schedules s ON sm.schedule_id = s.id WHERE s.event_id = %s """, (id,)) members = cur.fetchall() cur.close() return render_template('schedule/detail.html', event=event, schedule=schedule, members=members) # Chat socket events @socketio.on('join_ministry') def handle_join_ministry(data): ministry_id = data['ministry_id'] join_room(f'ministry_{ministry_id}') emit('user_joined', {'user': session['user_name']}, room=f'ministry_{ministry_id}') @socketio.on('leave_ministry') def handle_leave_ministry(data): ministry_id = data['ministry_id'] leave_room(f'ministry_{ministry_id}') emit('user_left', {'user': session['user_name']}, room=f'ministry_{ministry_id}') @socketio.on('send_message') def handle_send_message(data): ministry_id = data['ministry_id'] message = data['message'] # Save to database cur = mysql.connection.cursor() cur.execute(""" INSERT INTO messages (ministry_id, user_id, message) VALUES (%s, %s, %s) """, (ministry_id, session['user_id'], message)) mysql.connection.commit() cur.close() # Broadcast to room emit('new_message', { 'user': session['user_name'], 'message': message, 'timestamp': 'just now' }, room=f'ministry_{ministry_id}') if __name__ == '__main__': init_db() socketio.run(app, debug=True) ChurchTime App - {% block title %}{% endblock %} {% block extra_css %}{% endblock %}

{% with messages = get_flashed_messages(with_categories=true) %} {% if messages %} {% for category, message in messages %}

{% endfor %} {% endif %} {% endwith %} {% block content %}{% endblock %}

{% block extra_js %}{% endblock %} {% extends "base.html" %} {% block content %}

Bem-vindo ao ChurchTime App

Sistema completo para gerenciamento de ministérios de louvor

Ministérios

Gerencie todos os membros e funções do seu ministério

Repertório

Biblioteca completa de músicas com cifras e letras

Escalas

Crie e gerencie escalas de forma simples e eficiente

Entrar Cadastrar

{% endblock %} {% extends "base.html" %} {% block content %}

Entrar

{% if error %}

{% endif %}

Não tem uma conta? Cadastre-se

{% endblock %} {% extends "base.html" %} {% block content %}

Cadastrar

{% if error %}

{% endif %}

Já tem uma conta? Entrar

{% endblock %} {% extends "base.html" %} {% block title %}Dashboard{% endblock %} {% block content %}

Bem-vindo, {{ session['user_name'] }}!

Seus Ministérios

{% if ministries %}

{% for ministry in ministries %}

Acessar

{% endfor %}

{% else %}

Você não faz parte de nenhum ministério ainda.

{% endif %}

Próximos Eventos

{% if events %}

{% for event in events %}

{% endfor %}

{% else %}

Nenhum evento agendado.

{% endif %}

Chat Recente

{% if messages %}

{% for message in messages %}

{{ message.user_name }} {{ message.created_at.strftime('%d/%m %H:%M') }}

{% endfor %}

{% else %}

Nenhuma mensagem recente.

{% endif %}

{% endblock %} {% extends "base.html" %} {% block title %}Ministérios{% endblock %} {% block content %}

Ministérios

{% if session['user_role'] == 'admin' %} Novo Ministério {% endif %}

{% if ministries %}

{% for ministry in ministries %} {% endfor %}

Nome	Descrição	Ações
{{ ministry.name }}	{{ ministry.description\|default('Sem descrição', true)\|truncate(50) }}	Ver

{% else %}

Nenhum ministério cadastrado.

{% endif %}

{% endblock %} {% extends "base.html" %} {% block title %}{{ ministry.name }}{% endblock %} {% block extra_css %} {% endblock %} {% block content %}

{% if session['user_role'] == 'admin' %} {% endif %}

Membros

{% if session['user_role'] == 'admin' %} {% endif %}

{% if members %}

{% for member in members %}

{% endfor %}

{% else %}

Nenhum membro neste ministério.

{% endif %}

Próximos Eventos

{% if events %}

{% for event in events %}

{{ event.description|default('Sem descrição', true)|truncate(100) }} {% endfor %}

{% else %}

Nenhum evento agendado.

{% endif %}

Chat do Ministério

{% for message in messages %}

{{ message.user_name }} {{ message.created_at.strftime('%d/%m %H:%M') }}

{% endfor %}

{% endblock %} {% block extra_js %} {% endblock %} {% extends "base.html" %} {% block title %}Músicas{% endblock %} {% block content %}

Biblioteca de Músicas

Nova Música

{% if songs %}

{% for song in songs %} {% endfor %}

Título	Artista	Ações
{{ song.title }}	{{ song.artist\|default('Desconhecido', true) }}	Ver

{% else %}

Nenhuma música cadastrada.

{% endif %}

{% endblock %} {% block extra_js %} {% endblock %} {% extends "base.html" %} {% block title %}{{ song.title }}{% endblock %} {% block extra_css %} {% endblock %} {% block content %}

{% if song.artist %} Artista: {{ song.artist }} {% endif %}

{% if song.lyrics %}

{{ song.lyrics }}

{% else %}

Nenhuma letra cadastrada.

{% endif %}

{% if song.chords %}

{{ song.chords }}

{% else %}

Nenhuma cifra cadastrada.

{% endif %}

{% if song.youtube_url %}

Vídeo

{% endif %} {% if song.audio_url %}

Áudio

{% endif %} {% if not song.youtube_url and not song.audio_url %}

Nenhuma mídia associada.

{% endif %}

{% endblock %} {% extends "base.html" %} {% block title %}{{ event.name }}{% endblock %} {% block extra_css %} {% endblock %} {% block content %}

{{ event.date.strftime('%d/%m/%Y %H:%M') }} - {{ event.location }}

Membros Escalados

{% if members %}

{% for member in members %}

{% endfor %}

{% else %}

Nenhum membro escalado para este evento.

{% endif %}

Roteiro do Evento

{% if schedule %} {% for item in schedule %}

{% if item.song_title %} {{ item.song_title }} {% else %} Item {{ loop.index }} {% endif %}

{% if item.notes %}

{% endif %}

#{{ item.order_num }}

{% endfor %} {% else %}

Nenhum item no roteiro deste evento.

{% endif %}

{% endblock %} :root { --primary-color: #4b6cb7; --secondary-color: #182848; } body { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; background-color: #f8f9fa; } .navbar { box-shadow: 0 2px 4px rgba(0,0,0,.1); } .card { border: none; box-shadow: 0 0.125rem 0.25rem rgba(0, 0, 0, 0.075); transition: transform 0.2s; } .card:hover { transform: translateY(-2px); } .btn-primary { background-color: var(--primary-color); border-color: var(--primary-color); } .btn-primary:hover { background-color: #3a5a9b; border-color: #3a5a9b; } .bg-primary { background-color: var(--primary-color) !important; } .text-primary { color: var(--primary-color) !important; } .chat-messages { background-color: #f8f9fa; border-radius: 5px; padding: 10px; } .chat-message { margin-bottom: 10px; padding: 8px 12px; background-color: white; border-radius: 5px; box-shadow: 0 1px 2px rgba(0,0,0,0.1); } /* Responsive adjustments */ @media (max-width: 768px) { .display-4 { font-size: 2.5rem; } } document.addEventListener('DOMContentLoaded', function() { // Initialize tooltips const tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]')); tooltipTriggerList.map(function (tooltipTriggerEl) { return new bootstrap.Tooltip(tooltipTriggerEl); }); // Tab persistence const tabEls = document.querySelectorAll('button[data-bs-toggle="tab"]'); tabEls.forEach(tabEl => { tabEl.addEventListener('click', event => { const tabId = event.target.getAttribute('data-bs-target'); localStorage.setItem('lastTab', tabId); }); }); const lastTab = localStorage.getItem('lastTab'); if (lastTab) { const tab = new bootstrap.Tab(document.querySelector(lastTab)); tab.show(); } }); Flask==2.3.2 Flask-SocketIO==5.3.6 Flask-MySQLdb==1.0.1 python-dotenv==1.0.0 Werkzeug==2.3.7 Este é um projeto completo com todas as funcionalidades solicitadas. Para executar: 1. Configure o banco de dados MySQL remoto no arquivo app.py 2. Instale as dependências com `pip install -r requirements.txt` 3. Execute com `python app.py` O sistema inclui: - Cadastro de ministérios e usuários - Gerenciamento de escalas e programações - Biblioteca musical com cifras, letras e mídias - Chat em tempo real por ministério - Permissões personalizadas - Interface responsiva e moderna

Bem-vindo ao ChurchTime App

Ministérios

Repertório

Escalas

Entrar

Cadastrar

Bem-vindo, {{ session['user_name'] }}!

Seus Ministérios

{{ ministry.name }}

Próximos Eventos

{{ event.name }}

Chat Recente

Ministérios

{{ ministry.name }}

Membros

{{ member.name }}

Próximos Eventos

{{ event.name }}

Chat do Ministério

Biblioteca de Músicas

{{ song.title }}

Vídeo

Áudio

{{ event.name }}

Membros Escalados

Roteiro do Evento

{% if item.song_title %} {{ item.song_title }} {% else %} Item {{ loop.index }} {% endif %}