<!-- //
    show a search form
-->
<form class="CoolForm" action="{request.location()}" method="get">
    <label for="q">Find</label> 
    <input class="Required Border Control TextBox" id="q" name="q" value="{request.query(q)}"/> 
    <br/>
    <input class="Control" type="submit" value="Search"/> 
</form>

{buffer.set(q, string.trim(request.query(q)), rem="Store our search buffer")}

<se:if expression="$q!=''">
    <se:paging id="srs" 
        pagesize="5"
        rem="Create a state machine for our paged search results"
    />

    
    <se:sqlquery 
        pagingid="srs"
        rem="SqlQuery macro bound to paging macro 'srs'"
        save="data"
        resulttype="datatable" 
        sql="select c.nr, c.title,c.description, c.moddate, u.fullname
            from {channel.view()} c 
            join vwUsers u on c.userid=u.nr
            where title like ? order by moddate desc"
        params="{string.concat('%', string.replace($q, '*','%'), '%')}"
    />

    <se:format inputdata="data" rem="Format the subset of the results">
        <se:rowformat>
            <li>
                <a href="{this.location()}">{this.name()}</a><br />
                <small>
                    {sys.iif(this.field(description)!='', string.concat(this.field(description), html.break()), '')}
                    {datetime.format(this.field(moddate), 'd MMM yyyy, HH:mm')} by {this.field(fullname, default='unknown author')}
                </small>
            </li>
        </se:rowformat>
        <se:resultformat>
            <h3>Results for '{buffer.get(q)}'</h3>
         
            <ul>
                {this.result()}
            </ul>
        </se:resultformat>
    </se:format>

    <!--//
        Show the paging navigation
    -->
    <span class="navbar {sys.iif(page.srs.count() == 1, 'hidden')}">
        {page.srs.goto(First)} 
        {page.srs.goto(Previous)}
        {page.srs.goto(Next)}
        {page.srs.goto(Last)}
        page {page.srs.current()} of {page.srs.count()}: 
        {page.srs.offset()} to {math.min(page.srs.totalcount(), page.srs.offset()+page.srs.size()-1)} of {page.srs.totalcount()} items.
    </span>

</se:if>

<se:cache save="key = this.getcachekey()" resulttype="none" >
    <se:sqlquery 
        sql="select nr, title, description from {channel.view()} order by title"
        save="a"
        resulttype="datatable"
    />
    
    <se:xlinks inputdata="a" resulttype="datatable" />
</se:cache>
 
<se:paging 
    id="paging" 
    inputdata="key"
    pagesize="20"
    
/>
 
<se:format inputdata="key"
    maxrows="{page.paging.size()}"
    skiprows="{page.paging.skip()}"  >
    <se:rowformat>
        <li><a href="{this.location()}">{this.field(title)}</a></li>
    </se:rowformat>
    <se:resultformat>
        <ul>{this.result()}</ul>
    </se:resultformat>
</se:format>
 
<span class="navbar">
    {page.paging.goto(First)} 
    {page.paging.goto(Previous)}

    {buffer.set(range, 6, rem="Range of pages to jump to")}
    {buffer.set(start, math.max(page.paging.current()-($range/2),1))}
    <se:for from="{buffer.get(start)}" to="{math.min($start+$range, page.paging.count())}">
        {page.paging.goto(this.index())} 
    </se:for>
    
    {page.paging.goto(Next)}
    {page.paging.goto(Last)}
    
</span>