# == Schema Information
# Schema version: 20
#
# Table name: people
#
# id :integer(11) not null, primary key
# email :string(255)
# name :string(255)
# remember_token :string(255)
# crypted_password :string(255)
# description :text
# remember_token_expires_at :datetime
# last_contacted_at :datetime
# last_logged_in_at :datetime
# forum_posts_count :integer(11) default(0), not null
# blog_post_comments_count :integer(11) default(0), not null
# wall_comments_count :integer(11) default(0), not null
# created_at :datetime
# updated_at :datetime
# admin :boolean(1) not null
# deactivated :boolean(1) not null
#
class Person < ActiveRecord::Base
include ActivityLogger
extend PreferencesHelper
attr_accessor :password, :verify_password, :new_password,
:sorted_photos
attr_accessible :email, :password, :password_confirmation, :name,
:description
acts_as_ferret :fields => [ :name, :description ] if search?
MAX_EMAIL = MAX_PASSWORD = SMALL_STRING_LENGTH
MAX_NAME = SMALL_STRING_LENGTH
EMAIL_REGEX = /\A[A-Z0-9\._%-]+@([A-Z0-9-]+\.)+[A-Z]{2,4}\z/i
DESCRIPTION_LENGTH = 2000
TRASH_TIME_AGO = 1.month.ago
SEARCH_LIMIT = 20
SEARCH_PER_PAGE = 8
MESSAGES_PER_PAGE = 5
NUM_RECENT_MESSAGES = 4
NUM_WALL_COMMENTS = 10
NUM_RECENT = 8
FEED_SIZE = 10
has_one :blog
has_many :email_verifications
has_many :comments, :as => :commentable, :order => 'created_at DESC',
:limit => NUM_WALL_COMMENTS
has_many :connections
has_many :contacts, :through => :connections,
:conditions => [%(status = #{Connection::ACCEPTED} AND
deactivated = ?), false],
:order => 'people.created_at DESC'
has_many :photos, :dependent => :destroy, :order => 'created_at'
has_many :requested_contacts, :through => :connections,
:source => :contact,
:conditions => "status = #{Connection::REQUESTED}"
with_options :class_name => "Message", :dependent => :destroy,
:order => 'created_at DESC' do |person|
person.has_many :_sent_messages, :foreign_key => "sender_id",
:conditions => "sender_deleted_at IS NULL"
person.has_many :_received_messages, :foreign_key => "recipient_id",
:conditions => "recipient_deleted_at IS NULL"
end
has_many :feeds
has_many :activities, :through => :feeds, :order => 'created_at DESC',
:limit => FEED_SIZE
validates_presence_of :email, :name
validates_presence_of :password, :if => :password_required?
validates_presence_of :password_confirmation, :if => :password_required?
validates_length_of :password, :within => 4..MAX_PASSWORD,
:if => :password_required?
validates_confirmation_of :password, :if => :password_required?
validates_length_of :email, :within => 6..MAX_EMAIL
validates_length_of :name, :maximum => MAX_NAME
validates_format_of :email,
:with => EMAIL_REGEX,
:message => "must be a valid email address"
validates_uniqueness_of :email
before_create :create_blog
before_save :downcase_email, :encrypt_password
after_create :connect_to_admin
before_update :set_old_description
after_update :log_activity_description_changed
## Class methods
# SELECT people.* FROM people INNER JOIN connections ON people.id =
# connections.contact_id WHERE ((connections.person_id = 1) AND ((status = 0)))
# ORDER BY people.created_at DESC
# def contacts
# find(:all,
# :joins => "INNER JOIN people p ON activities.person_id = p.id",
# :conditions => ["p.deactivated = ?", false],
# :order => 'activities.created_at DESC',
# :limit => GLOBAL_FEED_SIZE)
# end
class << self
# Return the active users.
def active(page = 1)
paginate(:all, :page => page,
:per_page => RASTER_PER_PAGE,
:conditions => ["deactivated = ?", false])
end
# People search.
def search(options = {})
query = options[:q]
return [].paginate if query.blank? or query == "*"
# This is inefficient. We'll fix it when we move to Sphinx.
conditions = ["deactivated = ?", false]
results = find_by_contents(query, {}, :conditions => conditions)
results[0...SEARCH_LIMIT].paginate(:page => options[:page],
:per_page => SEARCH_PER_PAGE)
end
def find_recent
find(:all, :order => "people.created_at DESC",
:include => :photos, :limit => NUM_RECENT)
end
# Return the first admin created.
# We suggest using this admin as the primary administrative contact.
def find_first_admin
find(:first, :conditions => ["admin = ?", true],
:order => :created_at)
end
end
# Params for use in urls.
# Profile urls have the form '/people/1-michael-hartl'.
# This works automagically because Person.find(params[:id]) implicitly
# converts params[:id] into an int, and in Ruby
# '1-michael-hartl'.to_i == 1
def to_param
"#{id}-#{name.to_safe_uri}"
end
## Feeds
# Return a person-specific activity feed.
# TODO: put some algorithms in here to improve feed quality.
def feed
len = activities.length
if len < FEED_SIZE
# Mix in some global activities for smaller feeds.
global = Activity.global_feed[0...(Activity::GLOBAL_FEED_SIZE-len)]
(activities + global).uniq.sort_by { |a| a.created_at }.reverse
else
activities
end
end
def recent_activity
Activity.find_all_by_person_id(self, :order => 'created_at DESC',
:limit => FEED_SIZE)
end
## For the home page...
# Return some contacts for the home page.
def some_contacts
contacts[(0...12)]
end
# Contact links for the contact image raster.
def requested_contact_links
requested_contacts.map do |p|
conn = Connection.conn(self, p)
edit_connection_path(conn)
end
end
## Message methods
def received_messages(page = 1)
_received_messages.paginate(:page => page, :per_page => MESSAGES_PER_PAGE)
end
def sent_messages(page = 1)
_sent_messages.paginate(:page => page, :per_page => MESSAGES_PER_PAGE)
end
def trashed_messages(page = 1)
conditions = [%((sender_id = :person AND sender_deleted_at > :t) OR
(recipient_id = :person AND recipient_deleted_at > :t)),
{ :person => id, :t => TRASH_TIME_AGO }]
order = 'created_at DESC'
trashed = Message.paginate(:all, :conditions => conditions,
:order => order,
:page => page,
:per_page => MESSAGES_PER_PAGE)
end
def recent_messages
Message.find(:all,
:conditions => [%(recipient_id = ? AND
recipient_deleted_at IS NULL), id],
:order => "created_at DESC",
:limit => NUM_RECENT_MESSAGES)
end
## Photo helpers
def photo
# This should only have one entry, but be paranoid.
photos.find_all_by_primary(true).first
end
# Return all the photos other than the primary one
def other_photos
photos.length > 1 ? photos - [photo] : []
end
def main_photo
photo.nil? ? "default.png" : photo.public_filename
end
def thumbnail
photo.nil? ? "default_thumbnail.png" : photo.public_filename(:thumbnail)
end
def icon
photo.nil? ? "default_icon.png" : photo.public_filename(:icon)
end
def bounded_icon
photo.nil? ? "default_icon.png" : photo.public_filename(:bounded_icon)
end
# Return the photos ordered by primary first, then by created_at.
# They are already ordered by created_at as per the has_many association.
def sorted_photos
# The call to partition ensures that the primary photo comes first.
# photos.partition(&:primary) => [[primary], [other one, another one]]
# flatten yields [primary, other one, another one]
@sorted_photos ||= photos.partition(&:primary).flatten
end
## Authentication methods
# Authenticates a user by their email address and unencrypted password.
# Returns the user or nil.
def self.authenticate(email, password)
u = find_by_email(email.downcase) # need to get the salt
u && u.authenticated?(password) ? u : nil
end
def self.encrypt(password)
Crypto::Key.from_file('rsa_key.pub').encrypt(password)
end
# Encrypts the password with the user salt
def encrypt(password)
self.class.encrypt(password)
end
def decrypt(password)
Crypto::Key.from_file('rsa_key').decrypt(password)
end
def authenticated?(password)
unencrypted_password == password
end
def unencrypted_password
# The gsub trickery is to unescape the key from the DB.
decrypt(crypted_password)#.gsub(/\\n/, "\n")
end
def remember_token?
remember_token_expires_at && Time.now.utc < remember_token_expires_at
end
# These create and unset the fields required for remembering users
# between browser closes
def remember_me
remember_me_for 2.years
end
def remember_me_for(time)
remember_me_until time.from_now.utc
end
def remember_me_until(time)
self.remember_token_expires_at = time
key = "#{email}--#{remember_token_expires_at}"
self.remember_token = Digest::SHA1.hexdigest(key)
save(false)
end
def forget_me
self.remember_token_expires_at = nil
self.remember_token = nil
save(false)
end
def change_password?(passwords)
self.password_confirmation = passwords[:password_confirmation]
self.verify_password = passwords[:verify_password]
unless verify_password == unencrypted_password
errors.add(:password, "is incorrect")
return false
end
unless passwords[:new_password] == password_confirmation
errors.add(:password, "does not match confirmation")
return false
end
self.password = passwords[:new_password]
save
end
# Return true if the person is the last remaining active admin.
def last_admin?
num_admins = Person.count(:conditions => ["admin = ? AND deactivated = ?",
true, false])
admin? and num_admins == 1
end
def active?
not deactivated?
end
# Return the common connections with the given person.
def common_connections_with(person, page = 1)
sql = %(SELECT connections.*, COUNT(contact_id) FROM `connections`
INNER JOIN people contact ON connections.contact_id = contact.id
WHERE ((person_id = ? OR person_id = ?)
AND status = ? AND contact.deactivated = ?)
GROUP BY contact_id
HAVING count(contact_id) = 2)
conditions = [sql, id, person.id, Connection::ACCEPTED, false]
opts = { :page => page, :per_page => RASTER_PER_PAGE }
@common_connections ||= Connection.paginate_by_sql(conditions, opts)
end
protected
## Callbacks
def downcase_email
self.email = email.downcase
end
def encrypt_password
return if password.blank?
self.crypted_password = encrypt(password)
end
def set_old_description
@old_description = Person.find(self).description
end
def log_activity_description_changed
unless @old_description == description
add_activities(:item => self, :person => self)
end
end
# Connect new users to "Tom".
def connect_to_admin
# Find the first admin created.
# The ununitiated should Google "tom myspace".
tom = Person.find_first_admin
unless tom.nil? or tom == self
Connection.connect(self, tom)
end
end
## Other private method(s)
def password_required?
crypted_password.blank? || !password.blank? || !verify_password.nil?
end
end
) is private.
