1.1 --- a/model/delegation.lua	Wed Mar 20 09:26:11 2013 +0100
     1.2 +++ b/model/delegation.lua	Sat Apr 20 18:40:34 2013 +0200
     1.3 @@ -70,4 +70,25 @@
     1.4      :add_where{"delegation.truster_id = ?", member_id}
     1.5      :add_where{"member.active = 'f' OR (member.last_activity IS NULL OR age(member.last_activity) > ?::interval)", config.delegation_warning_time }
     1.6  end
     1.7 -  
     1.8 \ No newline at end of file
     1.9 +
    1.10 +function Delegation:delegations_to_check_for_member_id(member_id, for_update)
    1.11 +
    1.12 +  Member:new_selector():add_where({ "id = ?", member_id }):for_update():exec()
    1.13 +  
    1.14 +  local selector =  Delegation:new_selector()
    1.15 +    :add_field("member.name", "member_name")
    1.16 +    :add_field("unit.name", "unit_name")
    1.17 +    :add_field("area.name", "area_name")
    1.18 +    :left_join("area", nil, "area.active AND area.id = delegation.area_id")
    1.19 +    :join("unit", nil, "unit.active AND (unit.id = delegation.unit_id OR unit.id = area.unit_id)")
    1.20 +    :left_join("member", nil, "member.id = delegation.trustee_id")
    1.21 +    :add_where({ "delegation.truster_id = ?", member_id })
    1.22 +    :add_order_by("unit.name, area.name NULLS FIRST")
    1.23 +    
    1.24 +  if for_update then
    1.25 +    selector:for_update_of("delegation")
    1.26 +  end
    1.27 +    
    1.28 +  return selector:exec()
    1.29 +  
    1.30 +end 
    1.31 \ No newline at end of file