liquid_feedback_frontend
annotate model/initiative.lua @ 111:bf885faf3452
add initiator support in delegation
if a delegation is issued from the initiative view, the initiators
from that one are added to the delegation target list. this makes it easier to delegate to the author without the need to add him to the contact list.
if a delegation is issued from the initiative view, the initiators
from that one are added to the delegation target list. this makes it easier to delegate to the author without the need to add him to the contact list.
| author | Daniel Poelzleithner <poelzi@poelzi.org> |
|---|---|
| date | Mon Sep 20 20:32:04 2010 +0200 (2010-09-20) |
| parents | 88ac7798b562 |
| children | f460555c9896 |
| rev | line source |
|---|---|
| bsw/jbe@0 | 1 Initiative = mondelefant.new_class() |
| bsw/jbe@0 | 2 Initiative.table = 'initiative' |
| bsw/jbe@0 | 3 |
| bsw/jbe@0 | 4 Initiative:add_reference{ |
| bsw/jbe@0 | 5 mode = 'm1', |
| bsw/jbe@0 | 6 to = "Issue", |
| bsw/jbe@0 | 7 this_key = 'issue_id', |
| bsw/jbe@0 | 8 that_key = 'id', |
| bsw/jbe@0 | 9 ref = 'issue', |
| bsw/jbe@0 | 10 } |
| bsw/jbe@0 | 11 |
| bsw/jbe@0 | 12 Initiative:add_reference{ |
| bsw/jbe@0 | 13 mode = '1m', |
| bsw/jbe@0 | 14 to = "Draft", |
| bsw/jbe@0 | 15 this_key = 'id', |
| bsw/jbe@0 | 16 that_key = 'initiative_id', |
| bsw/jbe@0 | 17 ref = 'drafts', |
| bsw/jbe@0 | 18 back_ref = 'initiative', |
| bsw/jbe@19 | 19 default_order = '"id" DESC' |
| bsw/jbe@0 | 20 } |
| bsw/jbe@0 | 21 |
| bsw/jbe@0 | 22 Initiative:add_reference{ |
| bsw/jbe@0 | 23 mode = '1m', |
| bsw/jbe@0 | 24 to = "Suggestion", |
| bsw/jbe@0 | 25 this_key = 'id', |
| bsw/jbe@0 | 26 that_key = 'initiative_id', |
| bsw/jbe@0 | 27 ref = 'suggestions', |
| bsw/jbe@0 | 28 back_ref = 'initiative', |
| bsw/jbe@0 | 29 } |
| bsw/jbe@0 | 30 |
| bsw/jbe@0 | 31 Initiative:add_reference{ |
| bsw/jbe@0 | 32 mode = '1m', |
| bsw/jbe@0 | 33 to = "Initiator", |
| bsw/jbe@0 | 34 this_key = 'id', |
| bsw/jbe@0 | 35 that_key = 'initiative_id', |
| bsw/jbe@0 | 36 ref = 'initiators', |
| bsw@10 | 37 back_ref = 'initiative' |
| bsw/jbe@0 | 38 } |
| bsw/jbe@0 | 39 |
| bsw/jbe@0 | 40 Initiative:add_reference{ |
| bsw/jbe@0 | 41 mode = '1m', |
| bsw/jbe@0 | 42 to = "Supporter", |
| bsw/jbe@0 | 43 this_key = 'id', |
| bsw/jbe@0 | 44 that_key = 'initiative_id', |
| bsw/jbe@0 | 45 ref = 'supporters', |
| bsw/jbe@0 | 46 back_ref = 'initiative', |
| bsw/jbe@0 | 47 default_order = '"id"' |
| bsw/jbe@0 | 48 } |
| bsw/jbe@0 | 49 |
| bsw/jbe@0 | 50 Initiative:add_reference{ |
| bsw/jbe@0 | 51 mode = '1m', |
| bsw/jbe@0 | 52 to = "Opinion", |
| bsw/jbe@0 | 53 this_key = 'id', |
| bsw/jbe@0 | 54 that_key = 'initiative_id', |
| bsw/jbe@0 | 55 ref = 'opinions', |
| bsw/jbe@0 | 56 back_ref = 'initiative', |
| bsw/jbe@0 | 57 default_order = '"id"' |
| bsw/jbe@0 | 58 } |
| bsw/jbe@0 | 59 |
| bsw/jbe@0 | 60 Initiative:add_reference{ |
| bsw/jbe@0 | 61 mode = '1m', |
| bsw/jbe@0 | 62 to = "Vote", |
| bsw/jbe@0 | 63 this_key = 'id', |
| bsw/jbe@0 | 64 that_key = 'initiative_id', |
| bsw/jbe@0 | 65 ref = 'votes', |
| bsw/jbe@0 | 66 back_ref = 'initiative', |
| bsw/jbe@0 | 67 default_order = '"member_id"' |
| bsw/jbe@0 | 68 } |
| bsw/jbe@0 | 69 |
| bsw/jbe@0 | 70 Initiative:add_reference{ |
| bsw@10 | 71 mode = 'm1', |
| bsw@10 | 72 to = "Initiative", |
| bsw@10 | 73 this_key = 'suggested_initiative_id', |
| bsw@10 | 74 that_key = 'id', |
| bsw@10 | 75 ref = 'suggested_initiative', |
| bsw@10 | 76 } |
| bsw@10 | 77 |
| bsw@10 | 78 Initiative:add_reference{ |
| bsw/jbe@0 | 79 mode = 'mm', |
| bsw/jbe@0 | 80 to = "Member", |
| bsw/jbe@0 | 81 this_key = 'id', |
| bsw/jbe@0 | 82 that_key = 'id', |
| bsw/jbe@0 | 83 connected_by_table = '"initiator"', |
| bsw/jbe@0 | 84 connected_by_this_key = 'initiative_id', |
| bsw/jbe@0 | 85 connected_by_that_key = 'member_id', |
| bsw/jbe@0 | 86 ref = 'initiating_members' |
| bsw/jbe@0 | 87 } |
| bsw/jbe@0 | 88 |
| bsw/jbe@0 | 89 Initiative:add_reference{ |
| bsw/jbe@0 | 90 mode = 'mm', |
| bsw/jbe@0 | 91 to = "Member", |
| bsw/jbe@0 | 92 this_key = 'id', |
| bsw/jbe@0 | 93 that_key = 'id', |
| bsw/jbe@0 | 94 connected_by_table = '"supporter"', |
| bsw/jbe@0 | 95 connected_by_this_key = 'initiative_id', |
| bsw/jbe@0 | 96 connected_by_that_key = 'member_id', |
| bsw/jbe@0 | 97 ref = 'supporting_members' |
| bsw/jbe@0 | 98 } |
| bsw/jbe@0 | 99 |
| bsw@3 | 100 Initiative:add_reference{ |
| bsw@3 | 101 mode = 'mm', |
| bsw@3 | 102 to = "Member", |
| bsw@3 | 103 this_key = 'id', |
| bsw@3 | 104 that_key = 'id', |
| bsw@3 | 105 connected_by_table = 'direct_supporter_snapshot', |
| bsw@3 | 106 connected_by_this_key = 'initiative_id', |
| bsw@3 | 107 connected_by_that_key = 'member_id', |
| bsw@3 | 108 ref = 'supporting_members_snapshot' |
| bsw@3 | 109 } |
| bsw@3 | 110 |
| bsw/jbe@6 | 111 |
| bsw@2 | 112 function Initiative:get_search_selector(search_string) |
| bsw/jbe@0 | 113 return self:new_selector() |
| bsw/jbe@6 | 114 :join("draft", nil, "draft.initiative_id = initiative.id") |
| bsw@2 | 115 :add_field( {'"highlight"("initiative"."name", ?)', search_string }, "name_highlighted") |
| bsw/jbe@6 | 116 :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?) OR "draft"."text_search_data" @@ "text_search_query"(?)', search_string, search_string } |
| bsw/jbe@6 | 117 :add_group_by('"initiative"."id"') |
| bsw/jbe@6 | 118 :add_group_by('"initiative"."issue_id"') |
| bsw/jbe@6 | 119 :add_group_by('"initiative"."name"') |
| bsw/jbe@6 | 120 :add_group_by('"initiative"."discussion_url"') |
| bsw/jbe@6 | 121 :add_group_by('"initiative"."created"') |
| bsw/jbe@6 | 122 :add_group_by('"initiative"."revoked"') |
| bsw/jbe@6 | 123 :add_group_by('"initiative"."admitted"') |
| bsw/jbe@6 | 124 :add_group_by('"initiative"."supporter_count"') |
| bsw/jbe@6 | 125 :add_group_by('"initiative"."informed_supporter_count"') |
| bsw/jbe@6 | 126 :add_group_by('"initiative"."satisfied_supporter_count"') |
| bsw/jbe@6 | 127 :add_group_by('"initiative"."satisfied_informed_supporter_count"') |
| bsw/jbe@6 | 128 :add_group_by('"initiative"."positive_votes"') |
| bsw/jbe@6 | 129 :add_group_by('"initiative"."negative_votes"') |
| bsw/jbe@6 | 130 :add_group_by('"initiative"."agreed"') |
| bsw/jbe@6 | 131 :add_group_by('"initiative"."rank"') |
| bsw/jbe@19 | 132 :add_group_by('"initiative"."suggested_initiative_id"') |
| bsw/jbe@6 | 133 :add_group_by('"initiative"."text_search_data"') |
| bsw/jbe@6 | 134 :add_group_by('"issue"."population"') |
| bsw/jbe@19 | 135 :add_group_by("_initiator.member_id") |
| bsw/jbe@19 | 136 :add_group_by("_supporter.member_id") |
| bsw/jbe@0 | 137 end |
| bsw/jbe@0 | 138 |
| bsw@51 | 139 --function Member:get_search_selector(search_string) |
| bsw@51 | 140 -- return self:new_selector() |
| bsw@51 | 141 -- :add_where("active") |
| bsw@51 | 142 --end |
| bsw@2 | 143 |
| bsw@2 | 144 |
| bsw/jbe@0 | 145 function Initiative.object_get:current_draft() |
| bsw/jbe@0 | 146 return Draft:new_selector() |
| bsw/jbe@0 | 147 :add_where{ '"initiative_id" = ?', self.id } |
| bsw/jbe@0 | 148 :add_order_by('"id" DESC') |
| bsw/jbe@0 | 149 :single_object_mode() |
| bsw/jbe@0 | 150 :exec() |
| bsw/jbe@0 | 151 end |
| bsw/jbe@0 | 152 |
| bsw/jbe@0 | 153 function Initiative.object_get:shortened_name() |
| bsw/jbe@0 | 154 local name = self.name |
| bsw/jbe@0 | 155 if #name > 100 then |
| bsw/jbe@0 | 156 name = name:sub(1,100) .. "..." |
| bsw/jbe@0 | 157 end |
| bsw/jbe@0 | 158 return name |
| bsw/jbe@0 | 159 end |
| bsw/jbe@52 | 160 |
| bsw/jbe@52 | 161 function Initiative.object_get:initiator_names() |
| bsw/jbe@52 | 162 local members = Member:new_selector() |
| bsw/jbe@52 | 163 :join("initiator", nil, "initiator.member_id = member.id") |
| bsw/jbe@52 | 164 :add_where{ "initiator.initiative_id = ?", self.id } |
| bsw/jbe@52 | 165 :add_where{ "initiator.accepted" } |
| bsw/jbe@52 | 166 :exec() |
| bsw/jbe@52 | 167 |
| bsw/jbe@52 | 168 local member_names = {} |
| bsw/jbe@52 | 169 for i, member in ipairs(members) do |
| bsw/jbe@52 | 170 member_names[#member_names+1] = member.name |
| bsw/jbe@52 | 171 end |
| bsw/jbe@52 | 172 return member_names |
| bsw/jbe@52 | 173 end |
| bsw/jbe@52 | 174 |