forked from ComputerScienceHouse/conditional
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdashboard.py
More file actions
182 lines (156 loc) · 6.56 KB
/
dashboard.py
File metadata and controls
182 lines (156 loc) · 6.56 KB
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
import structlog
from flask import Blueprint, request
from conditional import start_of_year, auth
from conditional.models.models import Conditional, MajorProject
from conditional.models.models import HouseMeeting
from conditional.models.models import MemberHouseMeetingAttendance
from conditional.models.models import MemberSeminarAttendance
from conditional.models.models import MemberSeminarHost
from conditional.models.models import TechnicalSeminar
from conditional.models.models import SpringEval
from conditional.util.auth import get_user
from conditional.util.flask import render_template
from conditional.util.housing import get_queue_position
from conditional.util.major_project import get_project_list
from conditional.util.member import gatekeep_values, get_active_members, get_freshman_data, get_voting_members, \
get_cm, get_hm, is_gatekeep_active, req_cm
from conditional.util.user_dict import user_dict_is_active, user_dict_is_bad_standing, user_dict_is_intromember, \
user_dict_is_onfloor
logger = structlog.get_logger()
dashboard_bp = Blueprint('dashboard_bp', __name__)
def is_seminar_attendance_valid(attendance):
seminar = TechnicalSeminar.query.filter(
TechnicalSeminar.id == attendance.seminar_id).first()
return seminar and seminar.approved and seminar.timestamp > start_of_year()
# pylint: disable=too-many-statements
@dashboard_bp.route('/dashboard/')
@auth.oidc_auth("default")
@get_user
def display_dashboard(user_dict=None):
log = logger.new(request=request, auth_dict=user_dict)
log.info('display dashboard')
uid = user_dict["username"]
can_vote = get_voting_members()
on_floor = user_dict_is_onfloor(user_dict)
data = {}
data['username'] = uid
data['active'] = user_dict_is_active(user_dict)
data['bad_standing'] = user_dict_is_bad_standing(user_dict)
data['onfloor'] = on_floor
data['voting'] = bool(uid in can_vote)
data['voting_count'] = {"Voting Members": len(can_vote),
"Active Members": len(get_active_members())}
# freshman shit
if user_dict_is_intromember(user_dict):
data['freshman'] = get_freshman_data(uid)
else:
data['freshman'] = None
spring = {}
c_meetings = get_cm(user_dict['account'])
spring['committee_meetings'] = len(c_meetings)
spring['req_meetings'] = req_cm(uid)
h_meetings = [(m.meeting_id, m.attendance_status) for m in get_hm(user_dict['account'])]
spring['hm_missed'] = len([h for h in h_meetings if h[1] == "Absent"])
eval_entry = SpringEval.query.filter(SpringEval.uid == uid,
SpringEval.date_created > start_of_year(),
SpringEval.active == True).first() # pylint: disable=singleton-comparison
if eval_entry is not None:
spring['status'] = eval_entry.status
else:
spring['status'] = None
data['spring'] = spring
# only show housing if member has onfloor status
if on_floor:
housing = {}
housing['points'] = user_dict['account'].housingPoints
housing['room'] = user_dict['account'].roomNumber
housing['queue_pos'] = get_queue_position(uid)
else:
housing = None
data['housing'] = housing
data['major_projects'] = [
{
"id": p.id,
"date": p.date,
"name": p.name,
"proj_name": p.name,
"tldr": p.tldr,
"time_spent": p.time_spent,
"skills": p.skills,
"desc": p.description,
"links": [] if p.links is None else list(filter(None, p.links.split("\n"))),
"status": p.status,
}
for p in get_project_list().filter(MajorProject.uid == uid)
]
data['major_projects_count'] = len(data['major_projects'])
# technical seminar total
t_seminars = [s.seminar_id for s in
MemberSeminarAttendance.query.filter(
MemberSeminarAttendance.uid == uid,
) if is_seminar_attendance_valid(s)]
data['ts_total'] = len(t_seminars)
# technical seminars hosted
t_seminars_hosted = [s.seminar_id for s in
MemberSeminarHost.query.filter(
MemberSeminarHost.uid == uid,
) if is_seminar_attendance_valid(s)]
data['ts_hosted_total'] = len(t_seminars_hosted)
attendance = [m.name for m in TechnicalSeminar.query.filter(
TechnicalSeminar.id.in_(t_seminars)
)]
hosted = [m.name for m in TechnicalSeminar.query.filter(
TechnicalSeminar.id.in_(t_seminars_hosted)
)]
data['ts_list'] = attendance
data['ts_hosted'] = hosted
spring['mp_status'] = "Failed"
for mp in data['major_projects']:
if mp['status'] == "Pending":
spring['mp_status'] = 'Pending'
continue
if mp['status'] == "Passed":
spring['mp_status'] = 'Passed'
break
conditionals = [
{
'date_created': c.date_created,
'date_due': c.date_due,
'description': c.description,
'status': c.status
} for c in
Conditional.query.filter(
Conditional.uid == uid,
Conditional.date_due > start_of_year())]
data['conditionals'] = conditionals
data['conditionals_len'] = len(conditionals)
hm_attendance = [
{
'reason': m.excuse,
'datetime': m.date
} for m in
MemberHouseMeetingAttendance.query.outerjoin(
HouseMeeting,
MemberHouseMeetingAttendance.meeting_id == HouseMeeting.id).with_entities(
MemberHouseMeetingAttendance.excuse,
HouseMeeting.date).filter(
MemberHouseMeetingAttendance.uid == uid,
MemberHouseMeetingAttendance.attendance_status == "Absent",
HouseMeeting.date > start_of_year())]
data['cm_attendance'] = c_meetings
data['cm_attendance_len'] = len(c_meetings)
data['hm_attendance'] = hm_attendance
data['hm_attendance_len'] = len(hm_attendance)
gatekeep_info = gatekeep_values(uid)
gatekeep_result = 'disenfranchised'
if gatekeep_info['result']:
gatekeep_result = 'passing'
data['gatekeep_active'] = is_gatekeep_active()
data['gatekeep'] = {
'status': gatekeep_result,
'committee_meetings': gatekeep_info['c_meetings'],
'technical_seminars': gatekeep_info['t_seminars'],
'technical_seminars_hosted': gatekeep_info['t_seminars_hosted'],
'hm_missed': gatekeep_info['h_meetings_missed']
}
return render_template('dashboard.html', **data)