dbIndex={{indexQfq:Y}}
form={{form:S}}

1.sql = SELECT id, status,comment, lastRun, lastStatus, nextRun, frequency, inProgress
FROM Cron WHERE '{{form:SE}}' = '' ORDER BY id

1.twig = {% if store.sip.form == '' %}
<table class='table table-hover qfq-table-50'>
  <thead class="qfq-sticky"><tr>
    <tr>
       <th data-sorter="false" class="filter-false">
           {{ ('p:'~store.typo3.pageAlias~'|s|N|U:form=cron') | qfqlink }}
       </th>
       <th>ID</th>
       <th>Next run</th>
       <th>Frequency</th>
       <th>Comment</th>
       <th>Last run</th>
       <th>In Progress</th>
       <th>Status</th>
       <th></th>
    </tr>
  </thead>
  <tbody>
{% for row in result %}
  {% set tr_class = "" %}
  {% set tr_title = "" %}
  {% if row.status != "enable" %}
    {% set tr_class = "text-muted" %}
  {% elseif row.lastStatus[:5] == "Error" %} 
    {% set tr_class = "danger" %}
    {% set tr_title = "Status: Error" %}
  {% elseif row.inProgress != 0 and (row.inProgress|date('U') < "-10 minutes"|date('U')) %}
    {% set tr_class = "warning" %}
    {% set tr_title = "in Progress > 10mins" %}
  {% endif %}

  <tr class="{{tr_class}}" title="{{tr_title}}">
    <td>{{ ('p:'~store.typo3.pageAlias~'|s|E|U:form=cron&r='~row.id) | qfqlink }}</td>
    <td>{{ row.id }}</td>
    <td>{{ row.nextRun != 0 ? row.nextRun|date("Y-m-d H:i:s") : "-" }}</td>
    <td>{{ row.frequency }} </td>
    <td>{{ row.comment }} </td>
    <td>{{ row.lastRun != 0 ? row.lastRun|date("Y-m-d H:i:s") : "-" }}</td>
    <td>{{ row.inProgress != 0 ? (("now"|date("U")-row.inProgress|date("U"))//60~" minutes") : "-" }}</td>
    <td>{{ row.lastStatus[:40] }} </td>
    <td>
        {{ ('u:/typo3conf/ext/qfq/Classes/Api/delete.php'~
            '|s|D|q:Delete Cronjob '~row.id~'?'~
            '|U:_modeAnswer=html&_targetUrl=/index.php?id='~store.typo3.pageAlias~
            '&form=cron&r='~row.id) | qfqlink }}
    </td>
  </tr>
{% endfor %}
  </tbody>
</table>
{% endif %}
