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 == '' %} {% 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 %} {% endfor %}
{{ ('p:'~store.typo3.pageAlias~'|s|N|U:form=cron') | qfqlink }} ID Next run Frequency Comment Last run In Progress Status
{{ ('p:'~store.typo3.pageAlias~'|s|E|U:form=cron&r='~row.id) | qfqlink }} {{ row.id }} {{ row.nextRun != 0 ? row.nextRun|date("Y-m-d H:i:s") : "-" }} {{ row.frequency }} {{ row.comment }} {{ row.lastRun != 0 ? row.lastRun|date("Y-m-d H:i:s") : "-" }} {{ row.inProgress != 0 ? (("now"|date("U")-row.inProgress|date("U"))//60~" minutes") : "-" }} {{ row.lastStatus[:40] }} {{ ('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 }}
{% endif %}