<%

  # 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;

  # Project row id

  my $project_row_id = $api->get_project_row_id($user_id, $project_id);

  # Issues(which don't have pull request)

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

    [

      {__MY__ => '*'},

      {open_user => ['id']},

    ],

    where => [

      ['and', ':issue.open{=}', 'pull_request = 0', ':project{=}'],

      {'issue.open' => $open, project => $project_row_id}

    ]

  )->all;

  # Open count

  my $open_count = $api->get_open_issue_count($user_id, $project_id);

  # Close count

  my $close_count = $api->get_close_issue_count($user_id, $project_id);

  # Initialize labels if there are no labels

  my $labels_count = app->dbi->model('label')->select('count(*)', where => {'user.id' => $user_id, 'project.id' => $project_id})->value;

  if ($labels_count == 0) {

    my @labels = (

      {id => 'bug', color => '#fc2929'},

      {id => 'duplicate', color => '#cccccc'},

      {id => 'enhancement', color => '#84b6eb'},

      {id => 'invalid', color => '#e6e6e6'},

      {id => 'question', color => '#cc317c'},

      {id => 'wontfix', color => '#ffffff'}

    );

    for my $label (@labels) {

      my $project_row_id = app->dbi->model('project')->select(

        'project.row_id',

        where => {'user.id' => $user_id, 'project.id' => $project_id}

      )->value;

      $label->{project} = $project_row_id;

      app->dbi->model('label')->insert($label);

    }

  }

  layout 'common', title => "Issues - $user_id/$project_id";

%>

  %= include '/include/header';

  <div class="container">

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

      <div class="issues-button-container-left">

        <div class="issues-labels"><a href="<%= url_for("/$user_id/$project_id/labels") %>">Labels</a></div>

      </div>

      <div class="issues-button-container-right">

        % if ($api->logined) {

          <a href="<%= url_for("/$user_id/$project_id/issues/new") %>" class="btn btn-success">New issue</a>

        % }

      </div>

    </div>

    <div class="issues">

      <div class="issues-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="issues-body">

        % if (@$issues) {

          <ul>

            % for my $issue (@$issues) {

              <%

                my $issue_labels = app->dbi->model('issue_label')->select(

                  {label => ['id', 'color']},

                  where => {issue => $issue->{row_id}}

                )->all;

              %>

              <%

                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="issues-title">

                  <a href="<%= url_for("/$user_id/$project_id/issues/$issue->{number}") %>">

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

                  </a>

                  <ul class="issues-label-pallet">

                    % for my $issue_label (@$issue_labels) {

                      <li style="background:<%= $issue_label->{'label.color'} %>">

                        <%= $issue_label->{'label.id'} %>

                      </li>

                    % }

                  </ul>

                </div>

                <div class="issues-description">

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

                  <%= $open_time_age_string %>

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

                </div>

              </li>

            % }

          </ul>

        % } else {

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

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

          </div>

        % }

      </div>

    </div>

  </div>

  %= include '/include/footer';