<%

  # API

  my $api = gitprep_api;

  # Parameters

  my $user_id = param('user');

  my $project_id = param('project');

  my $is = param('is');

  my $open = $is eq 'closed' ? 0 : 1;

  # Git

  my $git = $self->app->git;

  # Issues which have pull request

  my $issues = app->dbi->model('issue')->select(

    [

      {__MY__ => '*'},

      {open_user => ['id']},

      {pull_request => ['target_branch']}

    ],

    where => [

      ['and', ':issue.open{=}', ':pull_request{<>}', ':project.id{=}'],

      {'issue.open' => $open, pull_request => 0, 'project.id' => $project_id}

    ]

  )->all;

  # Open count

  my $open_count = app->dbi->model('issue')->select(

    'count(*)',

    where => [

      ['and', ':issue.open{=}', ':pull_request{<>}', ':project.id{=}'],

      {'issue.open' => 1, pull_request => 0, 'project.id' => $project_id}

    ]

  )->value;

  # Close count

  my $close_count = app->dbi->model('issue')->select(

    'count(*)',

    where => [

      ['and', ':issue.open{=}', ':pull_request{<>}', ':project.id{=}'],

      {'issue.open' => 0, pull_request => 0, 'project.id' => $project_id}

    ]

  )->value;

%>

% layout 'common', title => "Pull Requests Tags \x{30fb} $user_id/$project_id";

  %= include '/include/header';

  <div class="container">

    <div class="pulls-button-container">

      <a href="<%= url_for("/$user_id/$project_id/compare") %>" class="btn btn-success">New pull request</a>

    </div>

    <div class="pulls">

      <div class="pulls-header">

        % if ($open) {

          <b><%= $open_count %> Open</b>

          <a href="<%= url_with->query([is => 'closed']) %>" style="margin-left:5px;color:#767676"><%= "\x{2714}" %><%= $close_count %> Closed</a>

        % } else {

          <a  style="margin-left:5px;color:#767676" href="<%= url_with->query([is => undef]) %>"><%= $open_count %> Open</a>

          <b>

            <span style="margin-left:5px;color:#767676"><%= "\x{2714}" %><%= $close_count %> Closed</span>

          </b>

        % }

      </div>

      <div class="pulls-body">

        % if (@$issues) {

          <ul>

            % for my $issue (@$issues) {

              <%

                my $target_branch = $issue->{'pull_request.target_branch'};

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

                my $open_time = $issue->{open_time};

                my $open_time_age = Time::Moment->now->epoch - $open_time;

                my $open_time_age_string = $self->app->git->_age_string($open_time_age);

              %>

              <li>

                <div class="pulls-title">

                  <a href="<%= "/$user_id/$project_id/pull/$issue->{row_id}" %>">

                    <b><%= $issue->{title} %></b>

                  </a>

                </div>

                <div class="pulls-description">

                  #<%= $issue->{row_id} %> <%= $issue->{open} ? 'opened' : 'closed' %>

                  <%= $open_time_age_string %>

                  by <%= $issue->{'open_user.id'} %>

                </div>

              </li>

            % }

          </ul>

        % } else {

          <div class="pulls-no-request">

            <div style="font-size:18px"><b>There aren’t any open pull requests.</b></div>

          </div>

        % }

      </div>

    </div>

  </div>

  %= include '/include/footer';