def nabidky_mapa():
free_vaccines = queries.find_free_vaccines_available()
free_vaccines_vaccine_options = queries.find_free_vaccines_vaccine_options(
)
return render_template(
'nabidky_mapa.html',
last_update=_last_import_modified(),
now=_now(),
free_vaccines=free_vaccines,
free_vaccines_vaccine_options=free_vaccines_vaccine_options)
def praktik_detail(nrpzs_kod):
doctor_offices = queries.find_doctor_offices(nrpzs_kod)
if len(doctor_offices) == 0:
abort(404)
free_vaccines = queries.find_free_vaccines_available(nrpzs_kod=nrpzs_kod)
return render_template('praktik.html',
last_update=_last_import_modified(),
now=_now(),
doctor_offices=doctor_offices,
free_vaccines=free_vaccines)
def kraj_detail(kraj_name):
kraj = db.session.query(Kraj).filter(
Kraj.nazev_kratky == kraj_name).one_or_none()
if kraj is None:
abort(404)
mista = queries.find_centers(Kraj.id, kraj.id)
third_doses_centers = queries.find_third_doses_centers()
centers_vaccine_options = queries.find_centers_vaccine_options()
doctors = queries.find_doctors(kraj_id=kraj.id)
doctors_vaccine_options = queries.find_doctors_vaccine_options()
free_vaccines = queries.find_free_vaccines_available(kraj_id=kraj.id)
free_vaccines_vaccine_options = queries.find_free_vaccines_vaccine_options(
)
metriky = db.session.query(KrajMetriky) \
.filter(KrajMetriky.kraj_id == kraj.id, KrajMetriky.datum == get_import_date()) \
.one_or_none()
registrations = queries.count_registrations('kraj_id', kraj.id)
vaccines = queries.count_vaccines_kraj(kraj.id)
vaccinated = queries.count_vaccinated(kraj.id)
queue_graph_data = queries.get_queue_graph_data(kraj_id=kraj.id)
return render_template(
'kraj.html',
last_update=_last_import_modified(),
now=_now(),
kraj=kraj,
mista=mista,
third_doses_centers=third_doses_centers,
centers_vaccine_options=centers_vaccine_options,
doctors=doctors,
doctors_vaccine_options=doctors_vaccine_options,
free_vaccines=free_vaccines,
free_vaccines_vaccine_options=free_vaccines_vaccine_options,
metriky=metriky,
vaccines=vaccines,
registrations=registrations,
vaccinated=vaccinated,
queue_graph_data=queue_graph_data)
def okres_detail(okres_name):
okres = db.session.query(Okres).filter(
Okres.nazev == okres_name).one_or_none()
if okres is None:
abort(404)
mista = queries.find_centers(Okres.id, okres.id)
third_doses_centers = queries.find_third_doses_centers()
centers_vaccine_options = queries.find_centers_vaccine_options()
doctors = queries.find_doctors(okres_id=okres.id)
doctors_vaccine_options = queries.find_doctors_vaccine_options()
free_vaccines = queries.find_free_vaccines_available(okres_id=okres.id)
free_vaccines_vaccine_options = queries.find_free_vaccines_vaccine_options(
)
metriky = db.session.query(OkresMetriky) \
.filter(OkresMetriky.okres_id == okres.id, OkresMetriky.datum == get_import_date()) \
.one_or_none()
registrations = queries.count_registrations('okres_id', okres.id)
return render_template(
'okres.html',
last_update=_last_import_modified(),
now=_now(),
okres=okres,
mista=mista,
third_doses_centers=third_doses_centers,
centers_vaccine_options=centers_vaccine_options,
doctors=doctors,
doctors_vaccine_options=doctors_vaccine_options,
free_vaccines=free_vaccines,
free_vaccines_vaccine_options=free_vaccines_vaccine_options,
metriky=metriky,
registrations=registrations)
def praktici_admin():
if session.get('user_id') is not None and session.get(
'user_passwd') is not None:
user = db.session.query(PrakticiLogin.zdravotnicke_zarizeni_kod, PrakticiLogin.heslo,
ZdravotnickeStredisko.nazev_cely) \
.join(ZdravotnickeStredisko,
ZdravotnickeStredisko.zdravotnicke_zarizeni_kod == PrakticiLogin.zdravotnicke_zarizeni_kod) \
.filter(PrakticiLogin.zdravotnicke_zarizeni_kod == session['user_id']) \
.filter(PrakticiLogin.heslo == session['user_passwd']) \
.one_or_none()
user_vaccines = db.session.query(PrakticiKapacity) \
.join(Vakcina, Vakcina.vyrobce == PrakticiKapacity.typ_vakciny) \
.filter(PrakticiKapacity.zdravotnicke_zarizeni_kod == session['user_id']) \
.filter(Vakcina.aktivni == True) \
.order_by(PrakticiKapacity.typ_vakciny) \
.all()
else:
user = None
user_vaccines = None
free_vaccines = queries.find_free_vaccines_available()
free_vaccines_vaccine_options = queries.find_free_vaccines_vaccine_options(
)
kraj_options = queries.find_kraj_options()
return render_template(
'praktici_admin.html',
last_update=_last_import_modified(),
now=_now(),
user=user,
user_vaccines=user_vaccines,
all_vaccines=free_vaccines,
free_vaccines_vaccine_options=free_vaccines_vaccine_options,
kraj_options=kraj_options)