Implement custom ticket/issue reports

[adiroiban]

Original report https://github.com/chevah/server/issues/1273

We need a report that is based on this priority https://geck.chevah.com/product/tickets.html#work-priority

The current GitHub reports for issues and PR have many inconveniences with default behaviour

• there is no priority
• the generic reports show things for all organizations - we want to filter by default only for one org
• the generic reports are split on issues and pr... we want all in one report. in the future including discussions
• if an issue is assigned to you but it has a PR, it is still very visible. If the issue has a PR, the focus should be on the PR.
• If did all the for for an issue or a PR and it needs-review, the should not be very visible , as there is not much you can do other than wait for the team to review it

[adiroiban]

I guess that this can be done with a simple HTML/JS page that will use GitHub API and will apply our "advanced" custom filters.

It would be interesting to create it as an OAuth GitHub App

The idea is to make it in such a way that it can be used for other (open source) projects

[adiroiban]

To implement the custom report we might need extra helpers.

For example, is an issue has a PR, add a label "has-pr" or something like that so that can filter tickets with that label from a certain report.