Instead of doing n queries for n states, do one query to get all the
counts grouped by state, and figure out what the count is for each state
is from that. We can still cache the individual counts (it can't hurt),
but this will help with initial load.

Note that the `opened` scope on `Issuable` includes the `opened` and
`reopened` states, which is why there's a special case.

`any?` on an AR relation performs a `SELECT COUNT`, which we don't need.

1. We are very likely to have issues or MRs, so the `SELECT COUNT` is
   often unnecessary.
2. Even where there are no items returned, the overhead of the
   `SELECT *` instead of `SELECT COUNT` is relatively small.

Calling `to_a` on the relation lets us use `Enumerable#any?`, which will
return immediately if there are objects returned.

Expose add-ons associated to the license in /license endpoint.

Closes #1286

See merge request !907

[ci skip]

[ci skip]

Move EE helper to proper namespace

See merge request !933

Document the need to use a PAT with Registry when 2FA is on

GitLab 8.12 introduced a new permissions model which tightened the
security of Container Registry. It is now required to use a personal
token if 2FA is enabled.

[ci skip]

See merge request !934

GitLab 8.12 introduced a new permissions model which tightened the
security of Container Registry. It is now required to use a personal
token if 2FA is enabled.

[ci skip]

Signed-off-by: Rémy Coutable <remy@rymai.me>

[EE] Refactor branch chooser in issuable form

Continuation of gitlab-org/gitlab-ce#23864.

Brother of gitlab-org/gitlab-ce!7852.

See merge request !930

Improve the "Guidelines for implementing Enterprise Edition feature" document

See merge request !910

Get rid of user activities table and replace it with Redis

Fixes https://gitlab.com/gitlab-org/gitlab-ee/issues/1158

See merge request !915

[EE] Add `null: true` to timestamps in migrations that does not define it

gitlab-org/gitlab-ce!7791 didn't take care of the EE-specific migrations.

I've also included the changes from gitlab-org/gitlab-ce!7845 (to make the `downtime_check` task happy).

See merge request !929

Refactor the Git submodules with CI docs

See merge request !932

[ci skip]

Signed-off-by: Rémy Coutable <remy@rymai.me>

This is to ensure that migrations will still be consitent when we will
upgrade to Rails 5 which default to `null: false` for timestamps
columns.

Fixes #23666.
Signed-off-by: Rémy Coutable <remy@rymai.me>

Refactored specs and added a post deployment migration to remove the activity users table.

Signed-off-by: Rémy Coutable <remy@rymai.me>

Refactor issuable description and metadata form sections

Continuation of https://gitlab.com/gitlab-org/gitlab-ce/issues/23864.

Brother of gitlab-org/gitlab-ce!7758.

See merge request !916

Geo: Display Custom Avatars in secondary nodes

This MR introduces some small patches for `User`, `Project` and `Group` models and related classes to build the avatar URL pointing to the primary node.
We should be able to remove this in the future when we start replicating local assets in Geo (#76).

For the changes to take effect on all pages, it's required to run:

```
# for Omnibus GitLab installs:
gitlab-rake cache:clear

# for Source installs:
RAILS_ENV=production bundle exec rake cache:clear
```

Closes #1128

See merge request !904

Merge branch '1291-documentation-about-lfs-objects-not-being-copied-when-mirroring-is-active' into 'master'

Add notes about LFS/Annex objects not being synced

Closes https://gitlab.com/gitlab-org/gitlab-ee/issues/1291

- [x] Change docs
- [x] Change views

See merge request !917

[ci skip]

Signed-off-by: Rémy Coutable <remy@rymai.me>

Signed-off-by: Rémy Coutable <remy@rymai.me>

Refactor issuable_filters_present to reduce duplications

Port of gitlab-org/gitlab-ce!7776

Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/23546

See merge request !921

small but mighty confusing typo

See merge request !920

Fixing typo & Clarifying Key name

There was a small typo in this file and the key type was incorrect. Fixed both. 🎂

See merge request !923

Speed up Group security access specs

This is the Group equivalent of gitlab-org/gitlab-ce@13ad9a745a392e0bf0cedd0e1f318c1acee9b969

EE version of https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/7813

See merge request !924

Clarify where the settings are in Pages docs

Fixes https://gitlab.com/gitlab-org/gitlab-ee/issues/1333

[ci skip]

See merge request !925

Fixes https://gitlab.com/gitlab-org/gitlab-ee/issues/1333

[ci skip]

This is the Group equivalent of 13ad9a74

Speed up Project security access specs

Prior, every single test was creating four `ProjectMember` objects, each
of which created one `User` record, even though each test only used
_one_ of those Users, if any.

Now each test only creates the single user record it needs, if it needs
one. This shaves minutes off of each spec file changed here.

EE version of https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/7779

See merge request !919

Prior, every single test was creating four `ProjectMember` objects, each
of which created one `User` record, even though each test only used
_one_ of those Users, if any.

Now each test only creates the single user record it needs, if it needs
one. This shaves minutes off of each spec file changed here.

CE upstream

See merge request !912

[ci skip]