def get_total_adm_for(hc_code, cap, age, period=None, year=None, month=None):
from database import Period, Report
if not period:
period = Period.from_date(date(year, month, 1))
# return real data from report if it exist in DB.
if Report.filter(period=period, hc_code=hc_code,
status=Report.STATUS_VALIDATED).count():
report = Report.filter(period=period, hc_code=hc_code).get()
return getattr(report.get_pec_report(cap), '%s_admitted' % age)
else:
# if not a report not in DB
if not hc_code in gao_data.PEC_ADM:
return None
# retrieve value from flat data
try:
if period.year in (2009, 2010, 2011):
return gao_data.PEC_ADM[hc_code][period.year][period.month][cap][age]
else:
return get_avg_adm_for(hc_code, period.month, cap, age)
except KeyError:
return None # TODO
def from_period(cls, period, hc_code, cap):
# TODO: report???
from nutclient.database import Report
if Report.filter(period=period, hc_code=hc_code).count():
report = Report.filter(period=period, hc_code=hc_code).get()
return cls.from_sub_report(report.get_cons_report(cap))
else:
return cls.build_for_period(period, hc_code, cap)
def confirm(self):
period_date = self.date_field.date().toPyDate()
period = Period.from_date(period_date)
# a report exist for that period.
if Report.filter(period=period).count() == 1:
report = Report.filter(period=period).get()
else:
report = Report.create_safe(period=period, user=self.user)
self.parent.view_widget.report = report
self.close()
def viewForm():
title = st.text_input("Report Title")
desc = st.text_area('Report Description')
btn = st.button("Submit")
if btn:
report1 = Report(title=title, desc=desc, data="")
sess.add(report1)
sess.commit()
st.success('Report Saved')
def set_data_for(self, *args):
if args:
reports = []
for prod in Product.all():
try:
reports.append(
Report.filter(Report.product == prod, Report.date > args[0][
0], Report.date < args[0][1]).order_by(Report.date.desc()).get())
except:
pass
self.data = [(rap.product.name, rap.remaining,
rap.selling_price, rap.remaining * rap.selling_price)
for rap in reports]
def save_report_form(fig):
generateReport()
if current_report['save_report']:
with st.spinner("Saving Report..."):
try:
path = 'reports/'+current_report['img_name']+'.png'
fig.write_image(path)
report = Report(
title=current_report['title'], desc=current_report['desc'], img_name=path)
sess.add(report)
sess.commit()
st.success('Report Saved')
except Exception as e:
st.error('Something went Wrong')
print(e)
def set_data_for(self, *args):
if args:
reports = []
for prod in Product.all():
try:
reports.append(
Report.filter(Report.product == prod,
Report.date > args[0][0],
Report.date < args[0][1]).order_by(
Report.date.desc()).get())
except:
pass
self.data = [(rap.product.name, rap.remaining, rap.selling_price,
rap.remaining * rap.selling_price)
for rap in reports]
def __init__(self, parent):
super(InProgressTable, self).__init__(parent)
def edit_report(ident):
from report import ReportWidget
self.parentWidget().change_main_context(ReportWidget,
report=Report.filter(id=ident).get())
date_fmt = '%d %B, %Hh%M'
for report in Report.opened():
self.data.append((report.verbose_status(),
report.__unicode__(),
report.created_on.strftime(date_fmt),
report.modified_on.strftime(date_fmt),
LinkButton(u"Éditer", edit_report, report.id)))
self.hheaders = [u"Statut", u"Rapport",
u"Créé le", u"Modifié le", u"Action"]
self.stretch_columns = [1,]
self.align_map = {0: 'l', 1: 'l'}
self.max_rows = 5
self.refresh()
def __init__(self, parent):
def edit_report(ident):
from report import ReportWidget
self.parentWidget().change_main_context(ReportWidget,
report=Report.filter(id=ident).get())
def preview(ident):
self.parentWidget().open_dialog(ReportPreview,
modal=True,
report=Report.filter(id=ident).get())
super(ArchivesTable, self).__init__(parent)
self.hheaders = [u"Période",
u"Statut",
u"UREN",
u"Dernière modif.",
u"PEC début",
u"PEC fin",
u"Aperçu",
u"Éditer"]
for report in Report.select():
self.data.append((report.period.__unicode__(),
report.verbose_status(),
report.verbose_caps(),
report.modified_on.strftime('%d %B, %H:%M'),
report.sum_for_field('all_total_beginning'),
report.sum_for_field('all_total_end'),
LinkButton(u"Aperçu", preview, report.id),
LinkButton(u"Éditer", edit_report, report.id)))
self.display_vheaders = False
self.stretch_columns = [0,]
self.align_map = {0: 'l', 1: 'l'}
self.refresh()
room_id=room_id,
description=Markup(room.description))
@app.route('/room/<room_id>//get', strict_slashes=False)
def test_room_api(room_id):
room = Room.query.filter_by(id=room_id).first()
code = request.args.get('text', '')
tests = tuple(case.test for case in room.test_cases)
expects = tuple(case.expect for case in room.test_cases)
results = test_runner(code, tests, expects)
ratio = len([r for r in results if r["state"]]) / len(results) * 100
report = json.loads(request.args.get('report', '{}'))
if report.get('contact') is not None:
report = Report(room_id, report.get('contact', ''), code,
report.get('about', ''))
DB.session.add(report)
DB.session.commit()
for result, case in zip(results, room.test_cases):
if result['state']:
report.passed.append(case)
else:
report.failed.append(case)
DB.session.commit()
return json.dumps({"results": results, "ratio": round(ratio)})
@app.route('/create/')
def edit_report(ident):
from report import ReportWidget
self.parentWidget().change_main_context(ReportWidget,
report=Report.filter(id=ident).get())
def preview(ident):
self.parentWidget().open_dialog(ReportPreview,
modal=True,
report=Report.filter(id=ident).get())
