liquid_feedback_frontend
annotate app/main/interest/show_incoming.lua @ 146:77260f05fd4b
implement advanced date searches
date-date in range
since: date
age: 10 timestamp
date-date in range
since: date
age: 10 timestamp
| author | Daniel Poelzleithner <poelzi@poelzi.org> |
|---|---|
| date | Thu Oct 07 03:34:19 2010 +0200 (2010-10-07) |
| parents | 768faea1096d |
| children | b9c8503feff7 |
| rev | line source |
|---|---|
| bsw@3 | 1 local issue = Issue:by_id(param.get("issue_id", atom.integer)) |
| bsw@3 | 2 local member = Member:by_id(param.get("member_id", atom.integer)) |
| bsw@3 | 3 |
| bsw@3 | 4 local members_selector = Member:new_selector() |
| bsw@3 | 5 :join("delegating_interest_snapshot", nil, "delegating_interest_snapshot.member_id = member.id") |
| bsw@3 | 6 :add_where{ "delegating_interest_snapshot.issue_id = ?", issue.id } |
| bsw@3 | 7 :add_where{ "delegating_interest_snapshot.event = ?", issue.latest_snapshot_event } |
| bsw@3 | 8 :add_where{ "delegating_interest_snapshot.delegate_member_ids[1] = ?", member.id } |
| bsw@3 | 9 :add_field{ "delegating_interest_snapshot.weight" } |
| bsw@3 | 10 |
| bsw@3 | 11 execute.view{ |
| bsw@3 | 12 module = "member", |
| bsw@3 | 13 view = "_list", |
| bsw@3 | 14 params = { |
| bsw@3 | 15 members_selector = members_selector, |
| bsw@3 | 16 issue = issue, |
| bsw@3 | 17 trustee = member |
| bsw@3 | 18 } |
| bsw@3 | 19 } |