Nevillealee/cs_prepaid_app

class Customer < ApplicationRecord
  include Requestable
 
  has_many :subscriptions
  has_many :addresses
  has_many :orders
 
  # returns search result on customers table
  #
  # @param query [String] search parameter
  # @return [Array<ActiveRecord::Relation>] matching or all customers in asc order
Method `search` has a Cognitive Complexity of 11 (exceeds 5 allowed). Consider refactoring.
  def self.search(query)
    if query.present?
      my_query = query.strip
      puts "made it inside condition"
      puts my_query
      if /^[a-zA-Z .]*$/.match(my_query) || /@/.match(my_query) || /^([0-9]*[a-zA-Z][a-zA-Z0-9_]*)$/.match(my_query)
        queries = my_query.split(' ')
        puts "multi string query"
        if queries.size > 1
          joins(:orders).where(:orders => {:status => "QUEUED"}).where("customers.first_name ilike ? AND customers.last_name ilike ?", "%#{queries[0]}%", "%#{queries[1]}%").order(first_name: :asc)
        else
          puts "email query"
          joins(:orders).where(:orders => {:status => "QUEUED"}).where("customers.first_name ilike ? OR customers.last_name ilike ? OR customers.email ilike ?",
            "#{queries[0]}%", "#{queries[0]}%", "%#{queries[0]}%"
          ).order(first_name: :asc)
        end
      elsif /^[\d\s]+$/.match(my_query)
        puts "number query"
        joins(:orders).where(:orders => {:status => "QUEUED"}).where("customers.shopify_customer_id = ? OR orders.id = ?", "#{my_query}", "#{my_query}").order(first_name: :asc).uniq
      else
        joins(:orders).where(:orders => {:status => "QUEUED"}).order(first_name: :asc).uniq
      end
    else
      puts "non string or number query"
      joins(:orders).where(:orders => {:status => "QUEUED"}).order(first_name: :asc).uniq
    end
  end
end