class BlackStack::User

Public Instance Methods

division() click to toggle source

retorna la primera division habilitada a la que pertenezca este usuario

# File lib/user.rb, line 14
def division
  row = DB[
  "SELECT d.id " +
  "FROM division d WITH (NOLOCK) " +
  "JOIN user_division ud WITH (NOLOCK) ON (d.id=ud.id_division AND ud.id_user='#{self.id}') " +
  "WHERE ISNULL(d.available,0) = 1 "
  ].first
  return nil if row.nil?
  return BlackStack::Division.where(:id=>row[:id]).first if !row.nil?
end