QFQ

20.sql = SELECT position, member_type, head, leitung, title, firstname, lastname, university, department, address, mail FROM committee WHERE student='...'

20.twig = '

<h2>PhD Committee</h2>

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

{% for row in context|sort %}

<tr>

{% for value in row|slice(4,3) %}

<td>{{ value }}</td>

{% endfor %}

<td>

{% if row.head and row.leitung %}

(Vorsitz und Leitung)

{% elseif row.head %}

(Vorsitz)

{% elseif row.leitung %}

(Leitung)

{% endif %}

</td>

<td>

{% if row.member_type == 1 %}

<span class="label label-info" data-toggle="tooltip" data-placement="top" title="Has the right to confer a PhD">

confer PhD

</span>

{% elseif row.university %}

<span class="label label-info" data-toggle="tooltip" data-placement="top" title="{{ row.university }} - {{ row.department }} - {{ row.address|default('no address stored') }}">

external

</span>

{% endif %}

<td> 

{% if row.mail %}

<a href="mailto:{{ row.mail }}">{{ row.mail }}</a>

{% endif %}

</td>

</tr>

{% endfor %}

</table>