annotate app/main/supporter/show_incoming.lua @ 959:1d9e48ecd254
Ordering of suggestions by harmonic weight
| author |
bsw |
| date |
Sat Feb 02 22:16:10 2013 +0100 (2013-02-02) |
| parents |
b9c8503feff7 |
| children |
|
| rev |
line source |
|
bsw@3
|
1 local initiative = Initiative:by_id(param.get("initiative_id", atom.integer))
|
|
bsw@3
|
2 local issue = initiative.issue
|
|
bsw@3
|
3 local member = Member:by_id(param.get("member_id", atom.integer))
|
|
bsw@3
|
4
|
|
bsw@3
|
5 local members_selector = Member:new_selector()
|
|
bsw/jbe@4
|
6 :join("delegating_interest_snapshot", nil, "delegating_interest_snapshot.member_id = member.id")
|
|
bsw@177
|
7 :join("issue", nil, "issue.id = delegating_interest_snapshot.issue_id")
|
|
bsw/jbe@4
|
8 :add_where{ "delegating_interest_snapshot.issue_id = ?", issue.id }
|
|
bsw/jbe@4
|
9 :add_where{ "delegating_interest_snapshot.event = ?", issue.latest_snapshot_event }
|
|
bsw/jbe@4
|
10 :add_where{ "delegating_interest_snapshot.delegate_member_ids[1] = ?", member.id }
|
|
bsw/jbe@4
|
11 :add_field{ "delegating_interest_snapshot.weight" }
|
|
bsw@3
|
12
|
|
bsw@3
|
13 execute.view{
|
|
bsw@3
|
14 module = "member",
|
|
bsw@3
|
15 view = "_list",
|
|
bsw@3
|
16 params = {
|
|
bsw@3
|
17 members_selector = members_selector,
|
|
bsw@3
|
18 issue = issue,
|
|
bsw@3
|
19 trustee = member
|
|
bsw@3
|
20 }
|
|
bsw@3
|
21 } |