30.sql = SELECT reg_done, check_head_done, check_studentaffairs_done, check_division_done, defense_processed, validation_done, scheduled_for_ceremony FROM phd_graduation WHERE id='...'
30.twig = '
Status
{% set row = context.0 %}
{% set labels = {'reg_done': "Registration by Student", 'check_head_done': "Check by Head of Committee", 'check_studentaffairs_done': "Check by Office of Student Affairs", 'check_division_done': "Processed by Division", 'defense_processed': "Defense Processed", 'validation_done': "Validated by Faculty", 'scheduled_for_ceremony': "Scheduled for Ceremony" } %}
{% for key, value in row %}
{% if value != 0 %}
{% else %}
{% endif %}
{{ labels[key] }} |
{% if value != 0 %}
{{value}}
{% endif %}
|
{% endfor %}