liquid_feedback_frontend
annotate model/initiative.lua @ 137:43ac94c7575b
add potential/full support filter into supported initiatives tab
fixes bug #47
fixes bug #47
| author | Daniel Poelzleithner <poelzi@poelzi.org> |
|---|---|
| date | Wed Oct 06 13:05:30 2010 +0200 (2010-10-06) |
| 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 |