<%

  use Data::Page ();

  use Data::Page::Navigation ();

  # Parameters

  my $type = param('type');

  my $q = param('q');

  my $page = param('page');

  my $type_exists = $type ? 1 : 0;

  $type ||= 'repositories';

  my $q_exists = defined $q ? 1 : 0;

  # DBI

  my $dbi = app->dbi;

  # Limit

  $page ||= 1;

  my $count = 20;

  my $offset = ($page - 1) * $count;

  my $rows;

  my $tabel;

  my $table;

  my $where = $dbi->where;

  my $total;

  if ($q_exists) {

    if ($type eq 'users') {

      $table = 'user';

      $where->clause(':id{like}');

      $where->param({id => "%$q%"});

      $rows = $dbi->model($table)->select(

        where => $where,

        append => "order by id limit $offset, $count"

      )->all;

    } elsif ($type eq 'repositories') {

      $table = 'project';

      $where->clause(':project.id{like}');

      $where->param({'project.id' => "%$q%"});

      $rows = $dbi->model($table)->select(

        [

          {__MY__ => '*'},

          {user => ['id']}

        ],

        where => $where,

        append => "order by project.id, user.id limit $offset, $count"

      )->all;

    }

    $total = $dbi->model($table)->select(

      'count(*)',

      where => $where,

    )->value;

  }

  $rows //= [];

  $total //= 0;

  # Pager

  my $pager = Data::Page->new($total, $count, $page);

  my @pages = $pager->pages_in_navigation(10);

%>

% layout 'common', title => 'Search';

  %= include '/include/header', title => 'Gitprep';

  <!-- Index page -->

  <div class="container">

    <div class="search-top">

      <div>Search</div>

      <form action="<%= url_for %>">

        <%= text_field 'q', style => "width:600px;margin-top:10px;margin-right:3px" %>

        <input class="btn" type="submit" value="Search">

        % if ($type_exists) {

          %= hidden_field type => $type;

        % }

      </form>

    </div>

  </div>

  <div class="container">

    <div class="search-result">

      <div class="left">

        <ul>

          <li class="<%= $type eq 'repositories' ? 'active' : '' %>">

            <a href="<%= url_with->query([type => 'repositories']) %>">Repositories</a>

          </li>

          <li class="<%= $type eq 'users' ? 'active' : '' %>">

            <a href="<%= url_with->query([type => 'users']) %>">Users</a>

          </li>

        </ul>

      </div>

      <div class="right">

        % if ($type eq 'users') {

          % if (@$rows) {

            <div>

              We've found <%= $total %> user results

            </div>

            <ul>

              % for my $user (@$rows) {

                % my $user_id = $user->{id};

                <li>

                  <div>

                    <a style="font-size:19px" href="<%= url_for("/$user_id") %>"><%= $user_id %></a>

                  </div>

                </li>

              % }

            </ul>

          % } else {

            <div>

              We couldn't find any users matching '<%= $q %>'

            </div>

          % }

        % } else {

          % if (@$rows) {

            <div>

              We've found <%= $total %> repository results

            </div>

            <ul>

              % for my $project (@$rows) {

                <%

                  my $user_id = $project->{'user.id'};

                  my $project_id = $project->{id};

                  my $rev = app->manager->default_branch($user_id, $project_id);

                  my $desc = app->git->description(app->rep_info($user_id, $project_id));

                  my $branches = app->git->branches($self->app->rep_info($user_id, $project_id));

                  my $commit;

                  if (@$branches) {

                    $commit = app->git->get_commit(app->rep_info($user_id, $project_id), $rev);

                  }

                %>

                <li>

                  <div>

                    <a style="font-size:19px" href="<%= url_for("/$user_id/$project_id") %>"><%= $user_id %>/<%= $project_id %></a>

                  </div>

                  <div>

                    <%= $desc %>

                  </div>

                  <div class="text-gray" style="font-size:13px;">

                    % if ($commit) {

                      <span title="<%= $commit->{age_string_datetime_local} %>"><%= $commit->{age_string} %>

                    % } else {

                      <span >Repositry is not yet created.

                    % }

                  </div>

                </li>

              % }

            </ul>

          % } else {

            <div>

              We couldn't find any repositories matching '<%= $q %>'

            </div>

          % }

        % }

        % if (@$rows && $pager->last_page != 1) {

          <div class="pagination-num">

            <ul>

              % if ($pager->previous_page) {

                <li><a href="<%= url_with->query([page => $pager->previous_page]) %>">&laquo;</a></li>

              % } else {

                <li class="disabled"><a href="#">&laquo;</a></li>

              % }

              % for my $p (@pages) {

                % if ($p eq $pager->current_page) {

                  <li class="active"><a href="#"><%= $p %></a></li>

                % } else {

                  <li><a href="<%= url_with->query([page => $p]) %>"><%= $p %></a></li>

                % }

              % }

              % if ($pager->next_page) {

                <li><a href="<%= url_with->query([page => $pager->next_page]) %>">&raquo;</a></li>

              % } else {

                <li class="disabled"><a href="#">&raquo;</a></li>

              % }

            </ul>

          </div>

        % }

      </div>

    </div>

  </div>

  %= include '/include/footer';