liquid_feedback_frontend

changeset 302:12a578e75f3e

Added missing join on clause for delegations selection
author bsw
date Sun Feb 26 14:20:00 2012 +0100 (2012-02-26)
parents 22e4e26717ac
children 805bb2f70b0a
files app/main/unit/show.lua
line diff
     1.1 --- a/app/main/unit/show.lua	Sun Feb 26 14:15:27 2012 +0100
     1.2 +++ b/app/main/unit/show.lua	Sun Feb 26 14:20:00 2012 +0100
     1.3 @@ -39,9 +39,9 @@
     1.4  
     1.5  local delegations_selector = Delegation:new_selector()
     1.6    :join("member", "truster", "truster.id = delegation.truster_id AND truster.active")
     1.7 -  :join("privilege", "truster_privilege", "truster_privilege.member_id = truster.id AND truster_privilege.voting_right")
     1.8 +  :join("privilege", "truster_privilege", "truster_privilege.member_id = truster.id AND truster_privilege.unit_id = delegation.unit_id AND truster_privilege.voting_right")
     1.9    :join("member", "trustee", "trustee.id = delegation.trustee_id AND truster.active")
    1.10 -  :join("privilege", "trustee_privilege", "trustee_privilege.member_id = trustee.id AND trustee_privilege.voting_right")
    1.11 +  :join("privilege", "trustee_privilege", "trustee_privilege.member_id = trustee.id AND trustee_privilege.unit_id = delegation.unit_id AND trustee_privilege.voting_right")
    1.12    :add_where{ "delegation.unit_id = ?", unit.id }
    1.13  
    1.14  local issues_selector = Issue:new_selector()

Impressum / About Us