def show(fund_url,category_url):
if not installed():
return redirect(url_for('index.show'))
# get all the categories with these identifiers
categories = Category.get_url_fund(category_url,fund_url)
# setup yearly category plot
plot_data = []
plotted = {}
series = Series()
for category in categories:
for item in category.items:
if item.code in plotted:
continue
plotted[item.code] = True
data = Data(name=item.name)
for i in Item.get_code(item.code):
data.add([i.category.fund.year.date,i.amount])
plot_data.append(data)
sorted_data = sorted(plot_data, key = lambda data: max(data.data['data'], key = lambda x: x[1])[1],reverse=True)
for data in sorted_data:
series.add(data)
return render_template('trend.html',active="trend",subactive="",
city=city,fund=categories[0].fund,
category=categories[0],
series=series.jsonify())
def show():
if installed():
# get year
year = Year.get_recent()
if not year:
# No funds added yet.
session['auth'] = 'Install'
return render_template('setup.html',city=city,active='home')
# get all the funds for this year
year_funds = Fund.get_year(year.date)
# setup revenue and expenditures plot
years = Year.all()
series = Series()
revenue = Data(name='Revenue')
expenditures = Data(name='Expenditures')
import datetime
import time
for year in years:
revenue.add([year.date,year.total_revenue])
expenditures.add([year.date,year.total_expenditures])
series.add(revenue)
series.add(expenditures)
print series.jsonify()
return render_template('index.html',active='home',subactive='',
city=city,year=year,fund=year_funds[1],
year_funds=year_funds,
series=series.jsonify(),
charts=show_year(year.date))
# create database
create_db()
users = User.all()
return render_template('install.html',
city=city,
users=users,
user_form=UserForm())
def show(url,date):
if not installed():
return redirect(url_for('index.show'))
# get year
year = Year.get_date(date)
# get all the funds for this year
year_funds = Fund.get_year(date)
# setup yearly fund plot
fund = Fund.get_url_year(url=url,date=date)
funds = Fund.get_name(fund.name)
series = Series()
revenue = Data(name='Revenue')
expenditures = Data(name='Expenditures')
for f in funds:
revenue.add([f.year.date,f.total_revenue])
expenditures.add([f.year.date,f.total_expenditures])
series.add(revenue)
series.add(expenditures)
# setup fund revenue and expenditures plots
revenueSeries = Series()
data = Data()
for category in fund.revenues():
data.add([category.name,category.total])
# data.reverse()
revenueSeries.add(data)
expendituresSeries = Series()
data = Data()
for category in fund.expenditures():
data.add([category.name,category.total])
# data.reverse()
expendituresSeries.add(data)
return render_template('year.html',active="fund",subactive=fund.url,
city=city,year=year,fund=fund,
year_funds=year_funds,
series=series.jsonify(),
revenueSeries=revenueSeries.jsonify(),
expendituresSeries=expendituresSeries.jsonify())