company bidder query

query.rb

class Companies::CompanyUsersQuery

def initialize()
  @scope = CompanyUser
end
  
def add_includes
  scope = scope.include([:credentials, :company])
  self
end
  
def merge_with_companies_scope(companies_scope)
  scope = scope.merge(companies_scope)
  self
end

def with_last_active_time
  scope = scope.merge(Credential.with_last)
  self
end

def sort_by_last_active_time
  scope = scope.order(last_active_time: :asc)
  self
end

private

attr_accessor :scope

end

use.rb

def last_active_users
  group_company_users = Companies::CompanyUsersQuery.new(CompanyUser)
    .add_includes
    .filter_by_companies(companies_scope)
    .with_last_active_time
    .sort_by_last_active_time
    .group_by(:company)
  group_company_users.map(&:last)
end