def recent_frequency_items(frequency):
# form = Form()
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
return render_template('recent_items.html', title='Recent Items', file_info=[file_info[0], file_info[1]],
subtitle=frequency,
items=info_requester.get_recent_items_for('expense', frequency=frequency))
def items(category):
# form = Form()
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
return render_template('items.html', title='All Items', file_info=[file_info[0], file_info[1]],
subtitle=category,
items=info_requester.get_items_for(category=category))
def summary_tag_categories(summary_tag):
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
categories_for_summary_tag = info_requester.get_categories(summary_tag=summary_tag)
return render_template('summary_tag_categories.html', title='summary of categories for ' + summary_tag,
file_info=[file_info[0], file_info[1]],
summary_tag=summary_tag,
metadata=info_requester.get_category_metadata_list(categories=categories_for_summary_tag))
def frequency_categories(frequency):
# form = Form()
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
categories_for_frequency = info_requester.get_categories(category_type='expense', frequency=frequency)
return render_template('frequency_categories.html', title='summary of categories for ' + frequency,
file_info=[file_info[0], file_info[1]],
frequency=frequency,
metadata=info_requester.get_category_metadata_list(categories=categories_for_frequency))
def summary_tag_items(summary_tag):
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
if not file_info:
return redirect(url_for('upload_file')) # someday need to abstract this
return render_template('summary_tag_items.html',
title=summary_tag,
file_info=file_info,
items=info_requester.get_items_for(summary_tag=summary_tag))
def categories():
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
if not file_info:
return redirect(url_for('upload_file')) # someday need to abstract this
return render_template('categories.html',
file_info=[file_info[0], file_info[1]],
title='Categories',
today=date.today(),
metadata=info_requester.get_category_metadata_list())
def spending_analysis():
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
if not file_info:
return redirect(url_for('upload_file')) # someday need to abstract this
return render_template('spending_analysis.html',
file_info=[file_info[0], file_info[1]],
title='Home',
today=date.today(),
annual_budget=info_requester.get_budget_for(category_type='expense') * 12,
spending_summary_info=info_requester.get_freq_summary_spending_info())
def file_admin():
form = FileAdminForm()
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
if not file_info:
return redirect(url_for('upload_file')) # someday need to abstract this
form.files.choices = [(f.id, f.filename + "; " + str(f.uploaded_timestamp)) for f in
info_requester.get_source_list()]
if request.method == 'POST':
if form.select.data:
info_requester.set_recent_file_details([int(form.files.data)])
elif form.delete.data:
info_requester.delete_source([int(form.files.data)])
elif form.delete_all.data:
info_requester.delete_all_sources()
return redirect(url_for('upload_file'))
return redirect(url_for('index'))
return render_template('file_admin.html',
title='files...',
form=form,
file_info=file_info)
def state_admin():
form = StateAdminForm()
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
if not file_info:
return redirect(url_for('upload_file')) # someday need to abstract this
if request.method == 'POST':
if form.new_state.data:
info_requester.add_lookup_state(state=form.new_state.data, desc=form.new_state_description.data)
elif form.delete.data:
info_requester.delete_lookup_states([int(form.states.data)])
redirect(url_for('state_admin'))
form.states.choices = [(s.id, str(s.id) + ': ' + s.state) for s in (info_requester.get_state_lookups() or [])]
return render_template('state_admin.html',
title='files...',
form=form,
file_info=file_info,
categories_by_state=info_requester.get_categories_by_current_state())
def upload_file():
form = UploadForm()
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
if form.validate_on_submit():
filename = secure_filename(form.file.data.filename)
data = form.file.data.read()
file_id = info_requester.add_new_file([filename, data])
info_requester.set_recent_file_details([file_id])
return redirect(url_for('index'))
return render_template('upload_file.html', title='Upload file with budget data', form=form,
file_info=file_info)
def index():
if 'categories_to_be_examined' not in session:
session['categories_to_be_examined'] = []
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
if not file_info:
return redirect(url_for('upload_file')) # someday need to abstract this
return render_template('index.html',
file_info=[file_info[0], file_info[1]],
title='Home',
today=date.today(),
annual_budget=info_requester.get_budget_for(category_type='expense') * 12,
topline_spending_summary=info_requester.get_top_line_spending_info(),
overspent_cat_metadata_by_summary_tag=
info_requester.get_overspent_cat_metadata_by_summary_tag(),
categories_by_state=info_requester.get_categories_by_current_state())
def category(cat):
form = CategorySummaryForm()
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
if not file_info:
return redirect(url_for('upload_file')) # someday need to abstract this
if not info_requester.is_category_included(category=cat):
flash('category is no longer in the dataset')
return redirect(request.referrer)
# few categories will have existing state
if request.method == 'POST':
if form.change_state.data:
info_requester.set_category_current_state(cat, form.state_radio_button.data)
elif form.delete_prev_states_button.data:
info_requester.delete_category_states(cat)
redirect(url_for('category', cat=cat))
form.state_radio_button.choices = [(s.id, s.state) for s in (info_requester.get_state_lookups() or [])]
form.state_radio_button.default = info_requester.get_current_state_id(cat) or 0
form.prev_states.choices = [(index, str(s.StateLookup.state) + ' @ ' + str(s.CategoryState.timestamp))
for s in (info_requester.get_category_state_info(cat))]
form.process()
return render_template('category_summary.html',
form=form,
file_info=[file_info[0], file_info[1]],
title=cat + ' summary',
today=date.today(),
category=cat,
frequency=info_requester.get_frequency(cat),
spending_summary_info=info_requester.get_cat_summary_spending_info(list_of_categories=[cat]),
metadata=info_requester.get_category_metadata_list(categories=[cat]),
items=info_requester.get_items_for(category=cat))
def info():
info_requester = InfoRequestHandler(current_user.id)
file_info = info_requester.get_file_details()
return render_template('info.html',
file_info=[file_info[0], file_info[1]])