{% set myemail = request.args.get('email') %} {% if myemail is none %} {% extends 'includes/layout.html' %} {% else %} {% endif %} {% block body %} {% if myemail is none %}
{% for mymsg in reportmsg['header'] %} {{ mymsg|safe }}
{% endfor %}


{% for mymsg in reportmsg['body'] %} {{ mymsg|safe }}
{% endfor %}
{% else %} {% endif %}
{% if mydisformat.upper().find("SINGLE") >= 0 %} {% if data|length > 0 %} {% for column in mycolumns %} {% endfor %} {% endif %} {% for row in data %} {% endfor %}
No. {{column}} SupID SupName
{{ loop.index }}. {{ row['timedate']|chknull }} {{ row['cardno']|chknull }} {{ row['emp_id']|chknull }} {{ row['emp_name']|chknull }} {{ row['dept_id']|chknull }} {{ row['sm']|chknull }} {{ row['result']|chknull }} {{ row['smval']|chknull|to_decimal_normalize_x }} {{ row['smlo']|chknull|to_decimal_normalize_x }} {{ row['smhi']|chknull|to_decimal_normalize_x }} {{ row['sup_id']|chknull }} {{ row['supname']|chknull }}
{% else %} {% set ns = namespace(lastsupid="yyy") %} {% set ns = namespace(currsupid="xxx") %} {% set ns = namespace(myindex=1) %} {% set ns.lastsupid = "yyy" %} {% set ns.currsupid = "xxx" %} {% set ns.myindex = 1 %} {% for row in data %} {% set ns.currsupid = row['sup_id'] %} {% if ns.lastsupid != ns.currsupid %} {% if ns.lastsupid != "yyy" %}

{% endif %} {% if row['sup_id'] is not none and myemail is not none %} Dear {{row['sup_id']}},

The following ESD Smock Test Report has been generated for you:

{% endif %} {% if data|length > 0 %} {% for column in mycolumns %} {% endfor %} {% endif %} {% endif %} {% set ns.lastsupid = ns.currsupid %} {% set ns.myindex = ns.myindex + 1 %} {% endfor %}
Supervisor: {{row['sup_id']}}   {{row['supname']}}   {{row['supemail']}}
No. {{column}}
{{ ns.myindex }}. {{ row['timedate']|chknull }} {{ row['cardno']|chknull }} {{ row['emp_id']|chknull }} {{ row['emp_name']|chknull }} {{ row['dept_id']|chknull }} {{ row['sm']|chknull }} {{ row['result']|chknull }} {{ row['smval']|chknull|to_decimal_normalize_x }} {{ row['smlo']|chknull|to_decimal_normalize_x }} {{ row['smhi']|chknull|to_decimal_normalize_x }}
{% endif %}


{% if myemail is none %}
{% endif %}

{% endblock %}