def statistics():
default_date = datetime.now()
default_date_array = {'year': str(default_date.year), 'month': str(default_date.strftime('%m')), 'day':str(default_date.strftime('%d'))}
gs = GenerateStats()
# Chosenyear, chosenmonth, chosenday
# Fetch the data from the database.
users = User.query.all()
event = Tagevent
week_day_name = default_date.strftime('%A')
month_name = default_date.strftime('%B')
custom_date_day = {'weekday': week_day_name + ' ' + str(default_date.day) + '/' + str(default_date.month) + '/' +
str(default_date.year)}
custom_date_month = {'month': month_name + ' ' + str(default_date.year)}
# Send the data to a method who returns an multi dimensional array with statistics.
ret = gs.get_data(users, event, default_date_array)
return render_template('statistics.html',
plot_paths='',
data=ret,
data2=custom_date_day,
data3=custom_date_month)
def statistics_by_date(_month, _day, _year):
chosen_date_array = {'year': _year, 'month': _month, 'day': _day}
gs = GenerateStats()
# Chosenyear, chosenmonth, chosenday
# Fetch the data from the database.
users = User.query.all()
event = Tagevent
default_date = datetime.now()
selected_date = default_date.replace(day=int(_day), month=int(_month), year=int(_year))
week_day_name = selected_date.strftime('%A')
month_name = selected_date.strftime('%B')
custom_date_day = {'weekday': week_day_name + ' ' + str(selected_date.day) + '/' + str(selected_date.month) + '/' + str(selected_date.year)}
custom_date_month = {'month': month_name + ' ' + str(selected_date.year)}
# Send the data to a method who returns an multi dimensional array with statistics.
ret = gs.get_data(users, event, chosen_date_array)
return render_template('statistics.html',
plot_paths='',
data=ret,
data2=custom_date_day,
data3=custom_date_month)
def get_events_from_user_by_tag_id(tag_id):
try:
gs = GenerateStats()
current_year = gs.get_current_year_string()
counter = 0
now = datetime.now()
users_tagins = Tagevent.query.filter(Tagevent.tag_id.contains(tag_id)).\
filter(Tagevent.timestamp.contains(current_year)).filter(Tagevent.uid != '').filter(Tagevent.uid is not None)
for tag_event in users_tagins:
for days in range(1, 32):
if tag_event.timestamp.month == now.month:
if tag_event.timestamp.day == days:
counter += 1
break
return {"value": counter}
except:
return {"value": 0}