Members: Add searching and sorting to table (ENHC0010037)

[deepsidhu85]

Summary

Currently, the members table for both groups and projects does not have sorting or searching capability. We want to update the table to add this functionality to allow the user to sort and search

Acceptance Criteria

• Since the members listing pages are pretty much identical, convert these over to be a component which will be shared by both the project and groups member index templates
• Search functionality added ( searches username and access level)
• Sort functionality added for all columns except Access Granted and Actions

Note: Take a look at the files within app/components/samples for an example of how this should work.

[ksierks]

After a conversation with Deep today, we've decided to drop searching by access level for now.

For my future reference, we explored the following solutions:

1. convert database to use enums

   CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');
   CREATE TABLE person (
   name text,
   current_mood mood
   );
   INSERT INTO person VALUES ('Moe', 'happy');
   SELECT * FROM person where current_mood::text ILIKE 'ha%';

2. use a dropdown to do access level searching/filtering
3. use a ransacker to do complete name lookup

   ransacker :access_level, formatter: proc { |v| Member::AccessLevel.access_level_options_owner[v] } do |parent|
   parent.table[:access_level]
   end

4. use ransackable_scope

   
   def self.ransackable_scopes(auth = nil)
   %i[access_level_or_email_like]
   end

def self.access_level_or_email_like(term) query = Arel.sql(format("'$.* ? (@ LIKE_REGEX \"(?i).%s.*\")'", term))

expression = Arel::Nodes::InfixOperation.new('@?', Member.arel_table[:access_level], query)

where(User.arel_table[:email].matches("%#{term}%")) end