liquid_feedback_frontend
diff model/area.lua @ 211:4993b71b383f
First checkin of lf2 (frontend second generation) prototype
| author | bsw |
|---|---|
| date | Wed Mar 02 20:06:26 2011 +0100 (2011-03-02) |
| parents | 46351752814f |
| children | 3e4ad069847a |
line diff
1.1 --- a/model/area.lua Sat Feb 05 20:01:09 2011 +0100 1.2 +++ b/model/area.lua Wed Mar 02 20:06:26 2011 +0100 1.3 @@ -63,5 +63,12 @@ 1.4 if args.active ~= nil then 1.5 selector:add_where{ "active = ?", args.active } 1.6 end 1.7 + if args.member_id then 1.8 + selector:join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ?", args.member_id }) 1.9 + end 1.10 + if args.not_member_id then 1.11 + selector:left_join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ?", args.not_member_id }) 1.12 + selector:add_where{ "membership.member_id ISNULL" } 1.13 + end 1.14 return selector 1.15 end