mysociety/alaveteli

# == Schema Information
# Schema version: 20220225214524
#
# Table name: user_sign_ins
#
#  id         :bigint           not null, primary key
#  user_id    :bigint
#  ip         :inet
#  created_at :datetime         not null
#  updated_at :datetime         not null
#  country    :string
#

# Record medadata about User sign in activity
class User::SignIn < ApplicationRecord
  default_scope { order(created_at: :desc) }

  belongs_to :user, inverse_of: :sign_ins

  before_create :create?

  def self.purge
    where('created_at < ?', retention_days.days.ago).destroy_all
  end

  def self.search(query)
    joins(:user).references(:users).where(<<~SQL, query: query)
      lower(user_sign_ins.ip::text) LIKE lower('%'||:query||'%') OR
      lower(user_sign_ins.country) LIKE lower('%'||:query||'%') OR
      lower(users.name) LIKE lower('%'||:query||'%') OR
      lower(users.email) LIKE lower('%'||:query||'%')
    SQL
  end

  def self.retain_signins?
    retention_days >= 1
  end

  def self.retention_days
    AlaveteliConfiguration.user_sign_in_activity_retention_days
  end

  def other_users
    User.distinct.joins(:sign_ins).
      where(user_sign_ins: { ip: ip }).
      where.not(id: user_id)
  end

  private

  def create?
    throw :abort unless self.class.retain_signins?
  end
end