SoundSoftware Code Site

      base.class_eval do

        # adapted from the app/models/principals_model.rb

        # to remove the email address from the search

        scope :name_like, lambda {|q|

          q = q.to_s

          if q.blank?

            where({})

          else

            pattern = "%#{q}%"

            sql = %w(login firstname lastname).map {|column| "LOWER(#{  table_name}.    #{column}) LIKE LOWER(:p)"}.join(" OR ")

            params = {:p => pattern}

            if q =~ /^(.+)\s+(.+)$/

              a, b = "#{$1}%", "#{$2}%"

              sql << " OR (LOWER(#{table_name}.firstname) LIKE LOWER(:a) AND  LOWER    (#{table_name}.lastname) LIKE LOWER(:b))"

              sql << " OR (LOWER(#{table_name}.firstname) LIKE LOWER(:b) AND  LOWER    (#{table_name}.lastname) LIKE LOWER(:a))"

              params.merge!(:a => a, :b => b)

            end

          where(sql, params)

          end

        }

      end #base.class_eval

      # todo: deprecated? ~lf.20131011