Frontend for cross-project pipeline triggers

See merge request !1985

EE compatible version of bulk edit sidebar.

See merge request !2025

Add primary node clone URL to Geo secondary 'How to work faster with Geo' popover

Closes #2555

See merge request !2027

Resolve "Broken master"

Closes #2597

See merge request !2047

Use the current node configuration to populate suggested new URL for Geo node

Closes #1416

See merge request !2038

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

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

Split Jenkins docs

See merge request !2045

Add PowerShell to CI variable docs

See merge request !2044

Speed up checking for approvers remaining

Closes #1843 and #2448

See merge request !2032

Stop using sidekiq-cron for scheduling all project mirror pull and move to adaptive scheduling

Closes gitlab-ce#29218

See merge request !1853

Implement server-wide Audit Logging admin screen

Closes #2336

See merge request !1852

Resolve "Approvers don't appear when MR is created from a fork"

Closes #2556

See merge request !2035

Remove references to old settings location

See merge request !2043

re-add avatar url to approver avatar

Closes #2560

See merge request !2034

The `users_select_tag` helper defaults to using `@project`, which in this case
is the source project, not the target project. Explicitly use the target project
to get the right list of users.

1. Use the ProjectAuthorization model to find users with developer access to
   this project. This is dramatically faster than the old version, with the
   complicated ORs, on staging: ~10ms vs ~800ms.
2. Use `to_a` explicitly when checking `any?` on a relation. Refactoring out the
   `any?` checks would be painful, but as we often use the results anyway,
   `to_a` lets us save a query.

Adding this up gets us the below (for a MR on the gitlab-ce project in staging).

Before:

    Project Load (2.3ms) SELECT "projects".* FROM "projects" WHERE
    "projects"."pending_delete" = 'f' AND "projects"."id" = 13083 ORDER BY
    "projects"."id" DESC LIMIT 1 [["pending_delete", false], ["id", 13083]]

    Approver Exists (1.2ms) SELECT 1 AS one FROM "approvers" WHERE
    "approvers"."target_id" = 2294769 AND "approvers"."target_type" =
    'MergeRequest' LIMIT 1 [["target_id", 2294769], ["target_type",
    "MergeRequest"]]

    ApproverGroup Exists (0.8ms) SELECT 1 AS one FROM "approver_groups" WHERE
    "approver_groups"."target_id" = 2294769 AND "approver_groups"."target_type"
    = 'MergeRequest' LIMIT 1 [["target_id", 2294769], ["target_type",
    "MergeRequest"]]

    User Load (2.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = 840794
    ORDER BY "users"."id" DESC LIMIT 1 [["id", 840794]]

    Approver Load (0.9ms) SELECT "approvers".* FROM "approvers" WHERE
    "approvers"."target_id" = 13083 AND "approvers"."target_type" = 'Project'
    AND ("approvers"."user_id" != 840794) [["target_id", 13083], ["target_type",
    "Project"], ["user_id", 840794]]

    Approver Exists (0.6ms) SELECT 1 AS one FROM "approvers" WHERE
    "approvers"."target_id" = 2294769 AND "approvers"."target_type" =
    'MergeRequest' LIMIT 1 [["target_id", 2294769], ["target_type",
    "MergeRequest"]]

    ApproverGroup Exists (0.6ms) SELECT 1 AS one FROM "approver_groups" WHERE
    "approver_groups"."target_id" = 2294769 AND "approver_groups"."target_type"
    = 'MergeRequest' LIMIT 1 [["target_id", 2294769], ["target_type",
    "MergeRequest"]]

    ApproverGroup Load (0.7ms) SELECT "approver_groups".* FROM "approver_groups"
    WHERE "approver_groups"."target_id" = 13083 AND
    "approver_groups"."target_type" = 'Project' [["target_id", 13083],
    ["target_type", "Project"]]

    Group Load (1.3ms) SELECT "namespaces".* FROM "namespaces" WHERE
    "namespaces"."deleted_at" IS NULL AND "namespaces"."type" IN ('Group') AND
    "namespaces"."id" = 9970 AND "namespaces"."type" IN ('Group') AND
    "namespaces"."type" = 'Group' ORDER BY "namespaces"."id" DESC LIMIT 1
    [["id", 9970], ["type", "Group"]]

    (1222.4ms) SELECT COUNT(*) FROM "users" WHERE ("users"."state"
    IN ('active')) AND ("users"."ghost" = 'f' OR "users"."ghost" IS NULL)
    AND ("users"."support_bot" = 'f' OR "users"."support_bot" IS NULL) AND ((id
    IN (SELECT "members"."user_id" FROM "members" WHERE "members"."source_type"
    = 'Project' AND "members"."type" IN ('ProjectMember') AND
    "members"."source_id" = 13083 AND "members"."source_type" = 'Project' AND
    "members"."type" IN ('ProjectMember') AND "members"."requested_at" IS NULL
    AND (access_level > 20) ORDER BY "members"."id" DESC) OR id IN (SELECT
    "members"."user_id" FROM "members" WHERE "members"."source_type" =
    'Namespace' AND "members"."type" IN ('GroupMember') AND
    "members"."source_id" = 9970 AND "members"."source_type" = 'Namespace' AND
    "members"."type" IN ('GroupMember') AND "members"."requested_at" IS NULL
    AND (access_level > 20) ORDER BY "members"."id" DESC)) AND id NOT IN (SELECT
    "approvals"."user_id" FROM "approvals" WHERE "approvals"."merge_request_id"
    = 2294769)) AND ("users"."id" != 840794) [["id", 840794]]

After:

    Project Load (2.5ms) SELECT "projects".* FROM "projects" WHERE
    "projects"."pending_delete" = 'f' AND "projects"."id" = 13083 ORDER BY
    "projects"."id" DESC LIMIT 1 [["pending_delete", false], ["id", 13083]]

    Approver Load (1.3ms) SELECT "approvers".* FROM "approvers" WHERE
    "approvers"."target_id" = 2294769 AND "approvers"."target_type" =
    'MergeRequest' [["target_id", 2294769], ["target_type", "MergeRequest"]]

    ApproverGroup Load (1.5ms) SELECT "approver_groups".* FROM "approver_groups"
    WHERE "approver_groups"."target_id" = 2294769 AND
    "approver_groups"."target_type" = 'MergeRequest' [["target_id", 2294769],
    ["target_type", "MergeRequest"]]

    User Load (2.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = 840794
    ORDER BY "users"."id" DESC LIMIT 1 [["id", 840794]]

    Approver Load (0.9ms) SELECT "approvers".* FROM "approvers" WHERE
    "approvers"."target_id" = 13083 AND "approvers"."target_type" = 'Project'
    AND ("approvers"."user_id" != 840794) [["target_id", 13083], ["target_type",
    "Project"], ["user_id", 840794]]

    ApproverGroup Load (0.7ms) SELECT "approver_groups".* FROM "approver_groups"
    WHERE "approver_groups"."target_id" = 13083 AND
    "approver_groups"."target_type" = 'Project' [["target_id", 13083],
    ["target_type", "Project"]]

    (6.2ms) SELECT COUNT(*) FROM "users" WHERE ("users"."state" IN ('active'))
    AND ("users"."ghost" = 'f' OR "users"."ghost" IS NULL)
    AND ("users"."support_bot" = 'f' OR "users"."support_bot" IS NULL) AND ((id
    IN (SELECT "project_authorizations"."user_id" FROM "project_authorizations"
    WHERE (project_id = 13083 AND access_level > 20))) AND id NOT IN (SELECT
    "approvals"."user_id" FROM "approvals" WHERE "approvals"."merge_request_id"
    = 2294769)) AND ("users"."id" != 840794) [["id", 840794]]

Users attempting to add a new GeoNode with HTTPS would be suggested
to use an HTTP endpoint, which caused a misconfiguration for one user.

Closes #1416