<?elements
class grid name "tasklist"
bind STATUS lb "Status" lookup "task_status" sort
bind KIND lb "Kind" lookup "task_kind" sort
bind PRIORITY lb "Priority" lookup "priority" sort
string CREATED_AT lb "Created" date sort
string LASTMOD_AT lb "Lastmod" date sort
number PRICE lb "Price" format "2,."
bind ASSIGNED_TO lb "Assigned to" query "select ID,NAME from TASKMAN_USERS" sort
bind HI_KIND list "1,red" field "KIND"
bind HI_PRIORITY list "3,bold" field "PRIORITY"
bind HI_MOD list "1,yellow,0,transparent"
bind CLS_STATUS list "1,st-open,2,st-progress,3,st-open,4,st-fin" field "STATUS"
string MSG size "50"
pager pager size "10" pglen "30" nohide
?>
<h2>List of bugs and feature requests</h2>
<table id="tasklist" class="grid">
<tr>
<th>Task</th>
<th>{KIND.lb}</th>
<th>{PRIORITY.lb}</th>
<th>{STATUS.lb}</th>
<th>{CREATED_AT.lb}</th>
<th>{LASTMOD_AT.lb}<sup>*)</sup></th>
<th>{PRICE.lb}</th>
<th>{ASSIGNED_TO.lb}</th>
</tr>
{BLOCK items}
<tr class="{CLS_STATUS}">
<td >{MSG}</td>
<td><span style="color:{HI_KIND}">{KIND}</span></td>
<td><span style="font-weight:{HI_PRIORITY}">{PRIORITY}</span></td>
<td>{STATUS}</td>
<td>{CREATED_AT}</td>
<td><span style="background-color:{HI_MOD}">{LASTMOD_AT}</span></td>
<td align="right">{PRICE},-</td>
<td align="right">{ASSIGNED_TO}</td>
</tr>
{/BLOCK}
</table>
<div class="pager">Page {pager.page} of {pager.maxpage} {pager.first} {pager.last} | {pager.pages} | Total rows: {pager.total} {pager.all}</div><br>
*) Yellow means that item changed since your last visit.<br>
It is not working in this simple example - LASTMOD is compared with constant date
<p class="blue">
<b>How data in database table are stored?</b><br>
<code class="example">
MSG KIND PRIORITY STATUS PRICE CREATED_AT LASTMOD_AT ASSIGNED_TO
=======================================================================
In tabl.. 1 2 3 1220 2006-07-31 2006-07-31 1
Further.. 2 2 2 640 2006-07-31 2006-07-31 1
...
</code>
<p>
Elapsed time: 0.97 ms