-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.py
31 lines (22 loc) · 997 Bytes
/
app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
from flask import Flask, render_template, request
import sqlite3
from datetime import datetime
app = Flask(__name__)
@app.route('/')
def index():
return render_template('index.html', selected_date='', no_data=False)
@app.route('/attendance', methods=['POST'])
def attendance():
selected_date = request.form.get('selected_date')
selected_date_obj = datetime.strptime(selected_date, '%Y-%m-%d')
formatted_date = selected_date_obj.strftime('%Y-%m-%d')
conn = sqlite3.connect('attendance.db')
cursor = conn.cursor()
cursor.execute("SELECT name, time FROM attendance WHERE date = ?", (formatted_date,))
attendance_data = cursor.fetchall()
conn.close()
if not attendance_data:
return render_template('index.html', selected_date=selected_date, no_data=True)
return render_template('index.html', selected_date=selected_date, attendance_data=attendance_data)
if __name__ == '__main__':
app.run(debug=True)