def report_event_post():
form = ReportForm(CombinedMultiDict((request.files, request.form)))
if form.validate():
image_extension = form.image.data.filename.split('.')[-1] if form.image.data else None
ev = Event(
timestamp=str(form.timestamp.data),
latitude=form.latitude.data,
longitude=form.longitude.data,
alert_code=AlertCode.from_name(form.type.data),
description=form.description.data,
image_extension=image_extension
)
MongoDatabase.insert_event(ev)
if ev.has_image():
MongoDatabase.insert_photo(ev.get_image_name(), form.image.data)
msg = EvrMail.create_new_event_message(Config.ADMIN_EMAILS, ev)
EvrMail.send_message(msg)
flash('Event reported')
return redirect(url_for('event.show_events'))
return render_template('event/report.html', form=form)
def report():
form = ReportForm()
if form.validate_on_submit():
session["startdate"] = form.startdate.data
session["enddate"] = form.enddate.data
return redirect(url_for("expense"))
return render_template("report.html", form=form)
def report(cert_id):
"""
Return template for report page
"""
cert = Cert.query.get(cert_id)
if cert.file_id is None:
urls = [url_for('static', filename=os.path.join('img', "missing.png"))]
else:
if not cert.file.converted:
cert.file.convert()
urls = cert.file.pngs
form = ReportForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
form_completed = False
for key, value in form.data.items():
if value != "" and key is not 'csrf_token' and key is not 'submit':
form_completed = True
if not form_completed:
flash("Please complete at least one form field.",
category="warning")
return render_template('report_issue.html',
form=form,
cert=cert,
urls=urls)
else:
form_fields = {
name: data
for name, data in {
'county': form.county.data,
'month': form.month.data,
'day': form.day.data,
'year': form.year.data,
'age': form.age.data,
'number': form.number.data,
'soundex': form.soundex.data,
'first_name': form.first_name.data,
'last_name': form.last_name.data,
'comments': form.comments.data
}.items() if data
}
report = Report(cert_id=cert_id,
user_id=current_user.id,
values=form_fields)
db.session.add(report)
db.session.commit()
flash("Your report has been submitted.", category="success")
return redirect('/')
else:
flash("An error has occurred.")
print(form.errors)
return render_template('report_issue.html',
form=form,
cert=cert,
urls=urls)
def report_article():
form = ReportForm()
if request.method == 'POST':
if form.validate() == False:
return 'Vul alstublieft alle velden in <p><a href="/contact">Probeer het opnieuw!!! </a></p>'
else:
mail.send(msg)
return redirect(url_for('count_logins'))
elif request.method == 'GET':
url = request.args.to_dict()['article']
form.lead.data = "Probleem met artikel " + url
return render_template('report_article.html', form=form, url=url)
def report(user_id):
user = User.query.get(user_id)
form = ReportForm()
if form.validate_on_submit():
report = Report(title = form.title.data, username = current_user.username, body = form.body.data)
db.session.add(report)
db.session.commit()
report.add_report(user, current_user)
db.session.commit()
flash('Your report has been recorded.')
return redirect('/clear_search')
return render_template('report.html', title='Report User', form=form)
def create(data, ascii_url_code) -> JsonResponse:
"""
Create "Report"
:param data: data for the ReportForm.
:param ascii_url_code: url code for "GeneratedASCII" object, passed from url.
:return: Fully built JsonResponse with errors if occurred.
"""
form = ReportForm(data)
try:
generated_ascii = GeneratedASCII.objects.get(url_code=ascii_url_code)
except GeneratedASCII.DoesNotExist:
return JsonResponse({'errors': {'captcha': [_("Can't find object to report.")]}}, status=400)
if form.is_valid():
Report.objects.create(text=form.cleaned_data['text'],
email=form.cleaned_data['email'],
generated_ascii=generated_ascii)
return JsonResponse({}, status=200)
return JsonResponse({'errors': form.errors}, status=400)
def general_report():
form0 = SearchProfileForm()
form = ReportForm()
if form.validate_on_submit():
prev_url = request.args.get('prev')
if url_parse(prev_url).netloc != '':
return redirect(url_for('index'))
report = Report(reason=form.reason.data,
page_of_report=prev_url,
author=current_user)
db.session.add(report)
db.session.commit()
flash('Your report has been submitted. Thank you for your feedback!')
return redirect(prev_url)
return render_template('general_report.html',
form=form,
form0=form0,
title='Report')
def report_for_month():
form = ReportForm()
if form.validate_on_submit():
orders, global_sum = controllers.count_month(form.year.data,
form.month.data)
return render_template('report_for_month.html',
year=form.year.data,
month=controllers.find_month(form.month.data),
orders=orders,
global_sum=global_sum,
form=form)
else:
return render_template('report_for_month.html',
year=0,
month=0,
orders=[],
global_sum=0,
form=form)
def createReport(request):
if request.method == 'POST':
create_form = ReportForm(request.POST)
if create_form.is_valid(): # Se va todo bien
create_form.save()
return redirect('index') # redigirir a la página principal
else:
create_form = ReportForm()
return render(request, 'create_form.html', {'create_form': create_form})
def reports():
form = ReportForm()
export = ExportForm()
if form.validate_on_submit():
# Make global so we can export these results to CSV
global report
report = db_functions.read_from_database(form)
for rp in report:
# Convert from 24 hr time (stored in db) to 12 hr time for display
twenty_four_hr_time = datetime.datetime.strptime(rp.time, "%H:%M")
# strip leading zeroes from hour for presentation purposes
rp.time = twenty_four_hr_time.strftime("%I:%M %p").lstrip(
"0").replace(" 0", "")
return render_template('reports.html',
title="Reports",
form=form,
report=report,
total=len(report),
export=export)
return render_template('reports.html', title="Reports", form=form)
def editReport(request, id):
report = MonitoringReports.objects.get(id=id)
if request.method == 'GET':
edit_form = ReportForm(instance=report)
else:
edit_form = ReportForm(request.POST, instance=report)
if edit_form.is_valid():
edit_form.save()
return redirect('index') # redigirir a la página principal
return render(request, 'create_form.html', {'edit_form': report})
def publish(request):
# if this is a POST request we need to process the form data
if request.method == 'POST':
# create a form instance and populate it with data from the request:
form = ReportForm(request.POST, request.FILES)
# check whether it's valid:
if form.is_valid():
if form.cleaned_data['latitude'] and form.cleaned_data['longitude']:
instance = form.save(commit=False)
instance.save()
report_id = str(instance.id)
request.session['pp_publish'] = True
request.session['pp_tweet'] = True
# redirect to another view where is the report id
return redirect('success', report_id=report_id)
else:
messages.error(request, "Es necesario una ubicación, por favor marque un punto en el mapa")
else:
messages.error(request, "Por favor verifique los datos del formulario")
else:
form = ReportForm()
context = {'form': form}
return render(request, 'publicar.html', context)
def report():
if Configuration.query.count() == 0:
#TODO return 404 somehow
pass
form = ReportForm()
form.config_id.choices =[(c.id, c.config_name) for c in Configuration.\
query.with_entities(Configuration.id,
Configuration.config_name).all()]
if form.validate_on_submit():
report = Report(report_name=form.report_name.data,
config_id=form.config_id.data,
hour=form.hour.data,
day=form.day.data,
minute=form.minute.data,
query_text=form.query_text.data)
db.session.add(report)
db.session.commit()
# keep this redirect here for a bit till I figure out what to do
# with it
return redirect(url_for('index'))
return render_template('report.html', form=form)
def specific_report(id):
form = ReportForm()
if form.validate_on_submit():
prev_url = request.args.get('prev')
report_type = request.args.get('type')
if url_parse(prev_url).netloc != '':
return redirect('index')
if report_type.find('post') != -1:
report = Report(reason=form.reason.data,
author=current_user,
post_id=id)
elif report_type.find('comment') != -1:
report = Report(reason=form.reason.data,
author=current_user,
comment_id=id)
else:
report = Report(reason=form.reason.data,
author=current_user,
profile_id=id)
db.session.add(report)
db.session.commit()
flash('Your report has been submitted. Thank you for your feedback!')
return redirect(prev_url)
return render_template('specific_report.html', title='Report', form=form)
def submit_report():
"""
Create and submit report
"""
form = ReportForm()
form.main_teacher.choices = Teacher.get_teachers_for_choices()
form.assistant_teacher.choices = Teacher.get_teachers_for_choices()
form.submitted_by.choices = Teacher.get_teachers_for_choices()
if form.validate_on_submit():
report = Report(main_teacher_id=form.main_teacher.data,
assistant_teacher_id=form.assistant_teacher.data,
teaching_date=form.teaching_date.data,
teaching_content=form.teaching_content.data,
student_attendance=form.student_attendance.data,
submitted_by_id=form.submitted_by.data)
db.session.add(report)
db.session.commit()
flash(message='Report is successfully submitted.', category='success')
return redirect(url_for('index'))
return render_template('report_submit.html',
title='Submit a Report',
form=form)
def report_view(request):
user_instance = request.user
if request.method == "POST":
report = user_instance.report_set.first()
form = ReportForm(request.POST, instance=report)
if form.is_valid():
report = form.save(commit=False)
report.user = user_instance
report.save()
messages.success(request, "Информация о работе сохранена.")
else:
form = ReportForm(instance=user_instance.report_set.first())
return render(request, "report.html", {"form": form})
def report():
if not session['logged_in']:
return redirect(url_for('index'))
form = ReportForm()
if request.method == "POST":
# alpha = request.form['by_cat']
# alpha = request.form['startdate']
# beta = request.form['enddate']
#
is_checked = request.form.get('by_cat')
single_cat_id = request.form.get('single_cat_id')
if is_checked:
# return render_template('404.html')
cat_list = Report.expenses_by_cat(request.form['startdate'], request.form['enddate'])
return render_template('report_cats.html', cats=cat_list, header_text="Category totals")
elif single_cat_id:
single_list = Report.expenses_single_cat(request.form['startdate'], request.form['enddate'], single_cat_id)
# return render_template('report_cats.html', cats=cat_list, header_text="Category totals")
return render_template('expenses.html', expense_list=single_list,
header_text="Expenses for cat {}".format(single_cat_id))
else:
expense_list = Report.expense_report(request.form['startdate'], request.form['enddate'])
#
# r = Report(
# request.form['startdate'],
# request.form['enddate'],
# request.form['by_cat']
# )
# cats = [{"cat":"alpha", "total":"111.11"}, {"cat":"beta", "total":"222.2"}]
# cats = r.exp_report_by_cat()
return render_template('report_results.html', expense_list=expense_list, bankitems=bankitems,
header_text="Expenses")
return render_template('report.html', form=form, header_text="Reports")
def get_form() -> ReportForm:
return ReportForm()
def report_generate():
form = ReportForm()
date_list = []
result = []
row_count = 0
end_date = form.enddate.data
begin_date = form.begindate.data
query = ''
for i in range(0, (end_date - begin_date).days + 1):
date_list.append((begin_date + timedelta(days=i)).strftime('%m-%d'))
if i == (end_date - begin_date).days:
query += 'SUM(sr.score) FILTER (where date=\'{0}\') as \"{0}\" '.format(
begin_date + timedelta(days=i))
else:
query += 'SUM(sr.score) FILTER (where date=\'{0}\') as \"{0}\",'.format(
begin_date + timedelta(days=i))
query = (
'select sur.name as sport, sum(sr.score), sr.parameter_1, ' + (query) +
'from surveyresult as sr join users as u on sr.id_users=u.id join surveys as sur on sr.id_surveys=sur.id '
+ 'where sr.date >=\'{}\' and sr.date <= \'{}\' and u.id={} '.format(
begin_date, end_date, current_user.id) +
'group by (sport, sr.parameter_1) order by 2 desc;')
colscount = len(date_list) + 2
result = db.engine.execute(query)
if form.validate_on_submit():
end_date = form.enddate.data
begin_date = form.begindate.data
query = ''
date_list = []
for i in range(0, (end_date - begin_date).days + 1):
date_list.append(
(begin_date + timedelta(days=i)).strftime('%m-%d'))
if i == (end_date - begin_date).days:
query += 'SUM(sr.score) FILTER (where date=\'{0}\') as \"{0}\" '.format(
begin_date + timedelta(days=i))
else:
query += 'SUM(sr.score) FILTER (where date=\'{0}\') as \"{0}\",'.format(
begin_date + timedelta(days=i))
query = (
'select sur.name as sport, sum(sr.score), sr.parameter_1, ' +
(query) +
'from surveyresult as sr join users as u on sr.id_users=u.id join surveys as sur on sr.id_surveys=sur.id '
+ 'where sr.date >=\'{}\' and sr.date <= \'{}\' and u.id={} '.
format(begin_date, end_date, current_user.id) +
'group by (sport, sr.parameter_1) order by 2 desc;')
result = db.engine.execute(query)
row_count = result.rowcount
colscount = len(date_list) + 2
return render_template('report.html',
title='Report',
form=form,
result=result,
date_list=date_list,
rows=row_count,
cols=colscount)
return render_template('report.html',
title='Report',
form=form,
result=result,
date_list=date_list,
rows=row_count,
cols=colscount)
def reportPrint():
form = ReportForm()
return render_template('reportPrint.html', form=form)
def add_report():
add_report = True
form = ReportForm()
if form.validate_on_submit():
report = Report(
title=form.title.data,
#CEP
education=form.education.data,
pss=form.pss.data,
livelihood=form.livelihood.data,
spiritual=form.spiritual.data,
numhomevisit=form.numhomevisit.data,
homevisit=form.homevisit.data,
donorbond=form.donorbond.data,
lifeskill=form.lifeskill.data,
#BS
numschool=form.numschool.data,
numstud=form.numstud.data,
student=form.student.data,
numchurch=form.numchurch.data,
church=form.church.data,
#Community Development
igas=form.igas.data,
numloanstaken=form.numloanstaken.data,
numloansback=form.numloansback.data,
notesonloans=form.notesonloans.data,
#PWDs
trainings=form.trainings.data,
newentrants=form.newentrants.data,
salestracking=form.salestracking.data,
#CD, PWDs
saving=form.saving.data,
dbspartnership=form.dbspartnership.data,
#DBs
numdbs=form.numdbs.data,
numnewdbs=form.numnewdbs.data,
newdbs=form.newdbs.data,
attendance=form.attendance.data,
schministries=form.schministries.data,
otherministries=form.otherministries.data,
#BS, CD, PWDs, DBs
numfollowup=form.numfollowup.data,
notesfollowup=form.notesfollowup.data,
#orphanage
security=form.security.data,
childdiet=form.childdiet.data,
childsanitation=form.childsanitation.data,
childhealth=form.childhealth.data,
#RM
activities=form.activities.data,
policies=form.policies.data,
implementation=form.implementation.data,
#Social Work
numchild=form.numchild.data,
childphysicalhealth=form.childphysicalhealth.data,
resettlement=form.resettlement.data,
legalsupport=form.legalsupport.data,
fostercare=form.fostercare.data,
#general fields
achieved=form.achieved.data,
challenge=form.challenge.data,
othernote=form.othernote.data,
department_id=current_user.department_id,
user_id=current_user.id)
db.session.add(report)
db.session.commit()
flash('Your report has succesfully been sent.', 'success')
return redirect(url_for('list_reports'))
return render_template('report.html',
form=form,
action="Add",
add_report=add_report,
title='Write Report')
def edit_report(id):
add_report = False
report = Report.query.get_or_404(id)
form = ReportForm(obj=report)
if form.validate_on_submit():
report.title = form.title.data
#CEP
report.education = form.education.data
report.pss = form.pss.data
report.livelihood = form.livelihood.data
report.spiritual = form.spiritual.data
report.numhomevisit = form.numhomevisit.data
report.homevisit = form.homevisit.data
report.donorbond = form.donorbond.data
report.lifeskill = form.lifeskill.data
#BS
report.numschool = form.numschool.data
report.numstud = form.numstud.data
report.student = form.student.data
report.numchurch = form.numchurch.data
report.church = form.church.data
#Community Development
report.igas = form.igas.data
report.numloanstaken = form.numloanstaken.data
report.numloansback = form.numloansback.data
report.notesonloans = form.notesonloans.data
#PWDs
report.trainings = form.trainings.data
report.newentrants = form.newentrants.data
report.salestracking = form.salestracking.data
#CD, PWDs
report.saving = form.saving.data
report.dbspartnership = form.dbspartnership.data
#DBs
report.numdbs = form.numdbs.data
report.numnewdbs = form.numnewdbs.data
report.newdbs = form.newdbs.data
report.attendance = form.attendance.data
report.schministries = form.schministries.data
report.otherministries = form.otherministries.data
#BS, CD, PWDs, DBs
report.numfollowup = form.numfollowup.data
report.notesfollowup = form.notesfollowup.data
#orphanage
report.security = form.security.data
report.childdiet = form.childdiet.data
report.childsanitation = form.childsanitation.data
report.childhealth = form.childhealth.data
#RM
report.activities = form.activities.data
report.policies = form.policies.data
report.implementation = form.implementation.data
#Social Work
report.numchild = form.numchild.data,
report.childphysicalhealth = form.childphysicalhealth.data
report.resettlement = form.resettlement.data
report.legalsupport = form.legalsupport.data
report.fostercare = form.fostercare.data
#general fields
report.achieved = form.achieved.data
report.challenge = form.challenge.data
report.othernote = form.othernote.data
db.session.add(report)
db.session.commit()
flash('You have successfully edited the report', 'success')
return redirect(url_for('list_reports'))
form.title.data = report.title
#CEP
form.education.data = report.education
form.pss.data = report.pss
form.livelihood.data = report.livelihood
form.spiritual.data = report.spiritual
form.numhomevisit.data = report.numhomevisit
form.homevisit.data = report.homevisit
form.donorbond.data = report.donorbond
form.lifeskill.data = report.lifeskill
#BS
form.numschool.data = report.numschool
form.numstud.data = report.numstud
report.student = form.student.data
return render_template('admin/report.html',
add_report=add_report,
form=form,
title='Edit Report')
def report_event():
form = ReportForm()
return render_template('event/report.html', form=form)
