Class: BlackStack::User

Inherits:
Object
  • Object
show all
Defined in:
lib/user.rb

Instance Method Summary collapse

Instance Method Details

#division ⇒ Object

retorna la primera division habilitada a la que pertenezca este usuario



14
15
16
17
18
19
20
21
22
23
 
# 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