def save():
ProjectSave = Project(title=request.form['titleform'],
type=request.form['typeform'],
start_date=request.form['startdateform'],
end_date=request.form['enddateform'],
description=request.form['descriptionform'],
amount=request.form['amountform'],
status=request.form['statusform'])
ProjectSave.save()
return redirect(url_for('home'))
def update(id):
project = Project.get(Project.id == id)
project.title = request.form['titleform']
project.type = request.form['typeform']
project.start_date = request.form['startdateform']
project.save()
flash('Record Updated Successfully')
return redirect(url_for('home'))
def home():
if authenticator():
projects = Project.select().order_by(Project.id)
return render_template('index.html',
pie_data=pieChart(),
graph_data=barChart(),
projectsHtml=projects)
else:
return render_template('authentication.html')
def barChart():
bar_chart = pygal.Bar()
#Then create a bar graph object
data = []
projects = Project.select()
for row in projects:
data.append(row.amount)
bar_chart = pygal.Bar()
label = 'Project Amount'
bar_chart.add(label, data)
bar_chart.render_to_file('bar_chart.svg')
bar_data = bar_chart.render_data_uri()
return bar_data
def pieChart():
pie_chart = pygal.Pie()
pie_chart.title = 'Project Type'
internal = 0
external = 0
projects = Project.select()
for row in projects:
if row.type == 'Internal':
internal = internal + 1
else:
external = external + 1
pie_chart.add('Internal', internal)
pie_chart.add('External', external) # Add some values
pie_chart.render_to_file('bar_chart.svg')
pie_data = pie_chart.render_data_uri()
return pie_data
from newapp import Project
# project1 = Project(title='classroom construction', type='internal', start_date='2018-03-12', end_date='2019-03-17', description='class 7', amount=4000000, status=1)
# project1.save()
#
# project2 = Project(title='toilet construction', type='internal', start_date='2019-05-10', end_date='2019-12-12', description='lower block', amount=700000, status=1)
# project2.save()
#
# project3 = Project(title='dormitory construction', type='internal', start_date='2018-03-17', end_date='2019-09-17', description ='main dormitory', amount=12000000, status=2)
# project3.save()
# project1 = Project.select().where(Project.id == 1).get()
# print(project1.id, project1.title, project1.type, project1.start_date, project1.end_date, project1.description, project1.amount, project1.status)
for project in Project.select():
#print(project.id, project.title, project.type, project.start_date, project.end_date, project.description, project.amount, project.status)
print(project.amount)
from flask import Flask, render_template, request, url_for, redirect
from newapp import Project
import pygal
app = Flask(__name__)
projects = Project.select()
@app.route('/')
def home():
return render_template('index.html',
pie_data=pieChart(),
graph_data=barChart(),
projectsHtml=projects)
@app.route('/save', methods=['POST'])
def save():
ProjectSave = Project(title=request.form['titleform'],
type=request.form['typeform'],
start_date=request.form['startdateform'],
end_date=request.form['enddateform'],
description=request.form['descriptionform'],
amount=request.form['amountform'],
status=request.form['statusform'])
ProjectSave.save()
return redirect(url_for('home'))
@app.route('/update/<int:id>', methods=['POST', 'GET'])
def update(id):