def get(self):
sql_statement= """
SELECT `t0`.`id` AS `lev0_id`, `t0`.`name_french` AS `lev0_name_fr`, `t0`.`name_english` AS `lev0_name_en`, `t1`.`id` AS `lev1_id`, `t1`.`name_french` AS `lev1_name_fr`, `t1`.`name_english` AS `lev1_name_en`, `t1`.`name_safe_short` AS `lev1_name_short`, `t1`.`access` AS `lev1_access`, `t1`.`html_form_type` AS `lev1_type`, `t2`.`id` AS `lev2_id`, `t2`.`name_french` AS `lev2_name_fr`, `t2`.`name_english` AS `lev2_name_en`, `t2`.`name_safe_short` AS `lev2_name_short`, `t2`.`access` AS `lev2_access`, `t2`.`html_form_type` AS `lev2_type`, `t3`.`id` AS `lev3_id`, `t3`.`name_french` AS `lev3_name_fr`, `t3`.`name_english` AS `lev3_name_en`, `t3`.`name_safe_short` AS `lev3_name_short`, `t3`.`access` AS `lev3_access`, `t3`.`html_form_type` AS `lev3_type`
FROM `section` AS `t0`
LEFT JOIN `attribute` AS `t1` ON `t1`.`section_id` = `t0`.`id`
LEFT JOIN `attribute` AS `t2` ON `t2`.`parent_id` = `t1`.`id`
LEFT JOIN `attribute` AS `t3` ON `t3`.`parent_id` = `t2`.`id`
WHERE `t1`.`parent_id` = 0
AND `t1`.`is_depreciated` = 0;
"""
better_sql = """
SELECT `name_safe_short`, `name_french`, `name_english` FROM `attribute` WHERE `is_depreciated` = 0 AND `section_id` < 16;
"""
records = QueryHandler.execute_query(sql_statement)
# raise Exception(records[23][8])
better_records = QueryHandler.execute_query(better_sql)
better_html = better_form(better_records)
html_string = form_builder(records)
role = self.session.get('role')
user_session = self.session.get("user")
if role != "admin" and role != "staff":
self.redirect("/users/login?message={0}".format("You are not authorized to view this page"))
return
form = Record.RecordForm()
template_values = {
"form": form,
"user_session": user_session,
"html_string": html_string,
"better_html": better_html,
"message": self.request.get("message")
}
language = None
if "language" in self.request.cookies:
language = self.request.cookies["language"]
else:
language = "fr"
self.response.set_cookie("language", "fr")
language = language.replace('"', '').replace("'", "")
if language == "fr":
LEGACY_TEMPLATE = JINJA_ENVIRONMENT.get_template('fr_new_record.html')
else:
LEGACY_TEMPLATE = JINJA_ENVIRONMENT.get_template('new_record.html')
self.response.write(LEGACY_TEMPLATE.render(template_values))
def post(self, record_id):
role = self.session.get('role')
user_session = self.session.get("user")
if role != "admin":
self.redirect("/users/login?message={0}".format("You are not authorized to view this page"))
return
record = Record.Record.get_by_id(int(record_id))
if not record:
self.response.write(LEGACY_TEMPLATE.render({"form": form, "message": "Unable to find program. Please contact administrator."}))
form = Record.RecordForm(self.request.POST)
if form.validate():
Record.update(self, LEGACY_TEMPLATE, form, record_id)
else:
self.response.write(LEGACY_TEMPLATE.render({"form": form}))
def get(self, record_id):
role = self.session.get('role')
user_session = self.session.get("user")
if role != "admin" and role != "staff":
self.redirect("/users/login?message={0}".format("You are not authorized to view this page"))
return
record = Record.Record.get_by_id(int(record_id))
if not record:
self.response.write(TEMPLATE.render({"form": form, "message": "Unable to find Record. Please contact administrator."}))
form = Record.RecordForm()
record_dict = record.to_dict()
for obj in record_dict:
try:
form[obj].data = record_dict[obj]
except:
pass
template_values = {
"message": self.request.get("message"),
"user_session": user_session,
"form": form,
"record": record,
}
language = None
if "language" in self.request.cookies:
language = self.request.cookies["language"]
else:
language = "fr"
self.response.set_cookie("language", "fr")
language = language.replace('"', '').replace("'", "")
if language == "fr":
LEGACY_TEMPLATE = JINJA_ENVIRONMENT.get_template('fr_edit_record.html')
else:
LEGACY_TEMPLATE = JINJA_ENVIRONMENT.get_template('edit_record.html')
self.response.write(LEGACY_TEMPLATE.render(template_values))
def get(self):
role = self.session.get('role')
user_session = self.session.get("user")
if role != "admin" and role != "staff":
self.redirect("/users/login?message={0}".format(
"You are not authorized to view this page"))
return
org_id = self.request.get("record")
sql_statement = "SELECT 1_nom FROM organization WHERE id={0} LIMIT 1".format(
org_id)
org = QueryHandler.execute_query(sql_statement)
form = Record.RecordForm()
template_values = {
"form": form,
"user_session": user_session,
"org_id": self.request.get("record"),
"org_name": org[0][0]
}
language = None
if "language" in self.request.cookies:
language = self.request.cookies["language"]
else:
language = "fr"
self.response.set_cookie("language", "fr")
language = language.replace('"', '').replace("'", "")
if language == "fr":
LEGACY_TEMPLATE = JINJA_ENVIRONMENT.get_template(
'fr_new_programs.html')
else:
LEGACY_TEMPLATE = JINJA_ENVIRONMENT.get_template(
'new_programs.html')
self.response.write(LEGACY_TEMPLATE.render(template_values))
def get(self):
role = self.session.get('role')
user_session = self.session.get("user")
if role != "admin" and role != "staff":
self.redirect("/users/login?message={0}".format(
"You are not authorized to view this page"))
return
url = self.request.url
index = url.index("=")
record_id = url[index + 1:]
form = Record.RecordForm()
template_values = {
"form": form,
"user_session": user_session,
"org_id": self.request.get("record"),
"record_id": record_id
}
language = None
if "language" in self.request.cookies:
language = self.request.cookies["language"]
else:
language = "fr"
self.response.set_cookie("language", "fr")
language = language.replace('"', '').replace("'", "")
if language == "fr":
LEGACY_TEMPLATE = JINJA_ENVIRONMENT.get_template(
'fr_new_services.html')
else:
LEGACY_TEMPLATE = JINJA_ENVIRONMENT.get_template(
'new_services.html')
self.response.write(LEGACY_TEMPLATE.render(template_values))