[%
# Generate Process and Queries tables
USE Api2;
SET timestamp = FORM.timestamp;
SET snapshot_one = timestamp == 0 ? {
        data={
                snapshots=[{
                                snap_proc={},
                                snap_sql={},
                                snap_http={}
                            }]
            }
    } :  Api2.exec("LVEInfo", "snapshot_one", {'timestamp'=timestamp}).0;
SET proc_headers = ['PID', 'CMD', 'CPU', 'MEM'];
SET sql_headers = ['CMD', 'Duration', 'SQL-query'];
SET http_headers = ['Method', 'Duration', 'URL'];
SET snap_proc = snapshot_one.data.snapshots.0.snap_proc;
SET snap_sql = snapshot_one.data.snapshots.0.snap_sql;
SET snap_http = snapshot_one.data.snapshots.0.snap_http;
%]

<p></p><h4 class="table-title">Process List</h4>
<table id="table-ps-snapshot" class="display">
<thead>
   <tr>
   [% FOREACH col IN proc_headers %]
       <th>[% col %]</th>
   [% END %]
   </tr>
</thead>
<tbody>
   [% FOREACH proc_id IN snap_proc.keys() %]
       [% proc_data = snap_proc.item(proc_id); proc_data.PID = proc_id %]
           <tr>[% FOR col IN  proc_headers %]
              <td>[% proc_data.item(col) %]</td>
               [% END %]
          </tr>
   [% END %]
</tbody>
</table>

<h4 class="table-title">Database Queries Snapshot</h4>
<table id="table-sql-snapshot" class="display">
<thead>
   <tr>
   [% FOREACH col IN sql_headers %]
       <th>[% col %]</th>
   [% END %]
   </tr>
</thead>
<tbody>
   [% FOREACH snap_sql_line IN snap_sql %]
       <tr>[% FOREACH cell IN snap_sql_line %]<td>[% cell %]</td>[% END %]</tr>
   [% END %]
</tbody>
</table>

<h4 class="table-title">HTTP Queries Snapshot</h4>
<table id="table-http-snapshot" class="display">
<thead>
   <tr>
   [% FOREACH col IN http_headers %]
       <th>[% col %]</th>
   [% END %]
   </tr>
</thead>
<tbody>
   [% FOREACH snap_http_line IN snap_http %]
       <tr>
            <td>[% snap_http_line.item(2) %]</td> <!-- method -->
            <td>[% snap_http_line.item(5) %]s</td> <!-- time (duration -->
            <td>http://[% snap_http_line.item(1) %][% snap_http_line.item(3)%]</td>  <!-- url = domain + path -->
       </tr>
   [% END %]
</tbody>
</table>