QFQ

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 = '<h2>Status</h2>

<table class="table table-hover qfq-table-50">

{% 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 %}

<tr  class="alert alert-success">

{% else %}

<tr  class="alert alert-warning">

{% endif %}

<th style="width: 30%">{{ labels[key] }}</th>  

<td>  

{% if value != 0 %} 

<span class="glyphicon glyphicon-ok"> {{value}}</span>

 {% endif %}

</td>

</tr>

{% endfor %}

</table>