sub jobstatus :Local {
    my ($self, $c) = @_;

sub showJobStatus :Local {
    my ($c, $builds) = @_;

    $c->stash->{latestBuilds} = [$c->model('DB::Builds')->search(undef,

    $c->stash->{latestBuilds} = [$builds->search({},

        , where => "finished != 0 and timestamp = (select max(timestamp) from Builds " .
            "where project == me.project and attrName == me.attrName and finished != 0 and system == me.system)"

        , where => {
            finished => { "!=", 0 },
            timestamp => \ (
                "= (select max(timestamp) from Builds " .
                "where project == me.project and attrName == me.attrName and finished != 0 and system == me.system)"),
          }

sub all :Local {
    my ($self, $c, $page) = @_;

sub jobstatus :Local {
    my ($self, $c) = @_;
    showJobStatus($c, $c->model('DB::Builds'));
}
sub showAllBuilds {
    my ($c, $baseUri, $page, $builds) = @_;

    my $nrBuilds = scalar($c->model('DB::Builds')->search({finished => 1}));

    my $nrBuilds = scalar($builds->search({finished => 1}));

    $c->stash->{baseUri} = $baseUri;

    $c->stash->{builds} = [$c->model('DB::Builds')->search(

    $c->stash->{builds} = [$builds->search(

sub all :Local {
    my ($self, $c, $page) = @_;
    showAllBuilds($c, $c->uri_for("/all"), $page, $c->model('DB::Builds'));
}

    my ($self, $c, $projectName, $subcommand) = @_;

    my ($self, $c, $projectName, $subcommand, $arg) = @_;

    $c->stash->{curProject} = $project;
    

    if ($subcommand eq "jobstatus") {
        return showJobStatus($c, scalar $project->builds);
    }

    if ($subcommand ne "") {

    elsif ($subcommand eq "all") {
        return showAllBuilds($c, $c->uri_for("/project", $projectName, "all"),
            $arg, scalar $project->builds);
    }
    elsif ($subcommand ne "") {

    $c->stash->{curProject} = $project;
    

<h1>All Builds</h1>

<h1>All Builds[% IF curProject %] in Project <tt>[% curProject.name %]</tt>[% END %]</h1>

[<a href="[% c.uri_for('/all' 1) %]">First</a>]

[<a href="[% "$baseUri/1" %]">First</a>]

  [<a href="[% c.uri_for('/all' (page - 1)) %]">Prev</a>]

  [<a href="[% "$baseUri/"; (page - 1) %]">Prev</a>]

  [<a href="[% c.uri_for('/all' (page + 1)) %]">Next</a>]

  [<a href="[% "$baseUri/"; (page + 1) %]">Next</a>]

[<a href="[% c.uri_for('/all' (totalBuilds - 1) div resultsPerPage + 1) %]">Last</a>]

[<a href="[% "$baseUri/"; (totalBuilds - 1) div resultsPerPage + 1 %]">Last</a>]

<h1>Job Status</h1>

<h1>Job Status[% IF curProject %] in Project <tt>[% curProject.name %]</tt>[% END %]</h1>

                      [% INCLUDE makeLink uri = c.uri_for('/project' project.name 'status') title = "Status" %]

                      [% INCLUDE makeLink uri = c.uri_for('/project' project.name 'jobstatus') title = "Job status" %]