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