app.py

from flask import Flask, render_template, request, session, redirect, url_for, flash
from database import DBhandler
import hashlib
import sys

application = Flask(__name__)
application.config["SECRET_KEY"] = "greenpower"
DB = DBhandler()

# 라우팅
@application.route("/")
def hello():
    return render_template("main.html")

@application.route("/login")
def login():
    return render_template("login.html")

@application.route("/todo")
def read_todo():
    group_activities = DB.get_group_activities()
    personal_activities = DB.get_personal_activities()
    group_todos = {}
    for activity in group_activities:
        todos = DB.get_group_todos_by_activity_id(activity['id'])
        group_todos[activity['id']] = todos
    return render_template("todo.html", group_activities=group_activities, personal_activities=personal_activities, group_todos=group_todos)

@application.route("/portfolio_write")
def read_todo_portfolio():
    return render_template("todo_portfoliowrite.html")

@application.route("/portfolio")
def todo_portfolio():
    return render_template("todo_portfolio.html")


# group_todo_insert의 활동 정보 Read
@application.route("/group_todo_insert")
def group_insert_todo():
    activity_id = request.args.get('id')
    if activity_id:
        group_activity = DB.get_group_activity_by_id(activity_id)
        if group_activity is None:
            flash('해당 활동을 찾을 수 없습니다.')
            return redirect(url_for('read_todo'))
    else:
        flash('활동 ID가 제공되지 않았습니다.')
        return redirect(url_for('read_todo'))
    # 조회한 활동 데이터를 템플릿으로 전달
    return render_template("/group_todo_insert.html", group_activity=group_activity)


# personal_todo_insert의 활동 정보 Read
# group_todo_insert랑 한 함수로 합칠 수 없으려나...
@application.route("/personal_todo_insert")
def personal_insert_todo():
    activity_id = request.args.get('id')
    if activity_id:
        personal_activity =  DB.get_personal_activity_by_id(activity_id)
    else:
        personal_activity = {'kind':'', 'name':''}
    return render_template("/personal_todo_insert.html", personal_activity=personal_activity)

@application.route("/group_insert")
def insert_group_activity():
    return render_template("group_insert.html")

@application.route("/personal_insert")
def insert_personal_activity():
    return render_template("personal_insert.html")


# 로그인
@application.route("/login_confirm", methods=['POST'])
def login_user():
    id = request.form['id']
    password = request.form['password']
    password_hash = hashlib.sha256(password.encode('utf-8')).hexdigest()

    user_found, user_name = DB.find_user(id, password_hash)
    if user_found:
        session['id' ] = id
        session['name'] = user_name
        return redirect(url_for("hello"))  # Redirect to the route that serves main.html
    else:
        error_message = "잘못된 ID 혹은 password를 입력하셨습니다."
        return render_template("login.html", error=error_message)


# group_activity db 전송
@application.route("/add_group_activity", methods=['POST'])
def add_group_activity():
    activity_kind = request.form['activity_kind']
    activity_name = request.form['activity_name']

    DB.add_group_activity(activity_kind, activity_name)

    flash('단체 활동이 성공적으로 등록되었습니다.')
    return redirect(url_for('read_todo'))
    

# personal_activity db 전송
@application.route("/add_personal_activity", methods=['POST'])
def add_personal_activity():
    activity_kind = request.form['activity_kind']
    activity_name = request.form['activity_name']

    DB.add_personal_activity(activity_kind, activity_name)

    flash('개인 활동이 성공적으로 등록되었습니다.')
    return redirect(url_for('read_todo'))
    
# 
@application.route("/submit_group_todo", methods=['POST'])
def submit_group_todo():
    activity_id = request.form['activity_id']
    task1 = request.form['task1']
    task2 = request.form['task2']
    task3 = request.form['task3']
    takeaway = request.form['takeaway']

    DB.add_group_todo(activity_id, task1, task2, task3, takeaway)

    flash('단체 활동 Todo가 성공적으로 등록되었습니다.')
    return redirect(url_for('read_todo'))

if __name__ == "__main__":
    application.run(host='0.0.0.0', debug=True)