liquid_feedback_frontend

annotate app/main/member/show_tab.lua @ 210:2c422bcb79de

find changesets by author, revision, files, or words in the commit message
Added tag beta31 for changeset bfd8d88f72fc
- Added support to lock inactive member
- Added esperanto translations for new phrases
- Improved and corrected some esperanto phrases
- Display delegation warnings only for open issues
- Refactored code: admin, area, contact and delegation module
- Translated admin menu
- Added policy editor to admin area
- Save and display last login date
- Small fixes
author bsw
date Sat Feb 05 20:01:09 2011 +0100 (2011-02-05)
parents bfd8d88f72fc
children 2dc13655afca
rev   line source
bsw@57 1 local show_as_homepage = param.get("show_as_homepage", atom.boolean)
bsw@57 2
bsw/jbe@19 3 local member
bsw/jbe@19 4
bsw/jbe@19 5 if request.get_json_request_slots() then
bsw/jbe@19 6 member = Member:by_id(param.get("member_id"))
bsw/jbe@19 7 else
bsw/jbe@19 8 member = param.get("member", "table")
bsw/jbe@19 9 end
bsw/jbe@19 10
bsw@57 11 local tabs = {
bsw@57 12 module = "member",
bsw@57 13 view = "show_tab",
bsw@57 14 static_params = {
bsw@57 15 member_id = member.id,
bsw@57 16 show_as_homepage = show_as_homepage
bsw@57 17 }
bsw@57 18 }
bsw@57 19
bsw@57 20 if show_as_homepage and app.session.member_id == member.id then
bsw@62 21
bsw@75 22 if app.session.member.notify_email_unconfirmed then
bsw@75 23 tabs[#tabs+1] = {
bsw@75 24 class = "yellow",
bsw@75 25 name = "email_unconfirmed",
bsw@75 26 label = _"Email unconfirmed",
bsw@75 27 icon = { static = "icons/16/bell.png" },
bsw@75 28 module = "member",
bsw@75 29 view = "_email_unconfirmed",
bsw@75 30 params = {}
bsw@75 31 }
bsw@75 32 end
bsw@75 33
bsw@69 34 if config.motd_intern then
bsw@62 35 tabs[#tabs+1] = {
bsw@62 36 class = "yellow",
bsw@62 37 name = "motd",
bsw@62 38 label = _"Message of the day",
bsw@62 39 icon = { static = "icons/16/bell.png" },
bsw@62 40 module = "index",
bsw@62 41 view = "_motd",
bsw@62 42 params = {}
bsw@62 43 }
bsw@62 44 end
bsw@57 45
poelzi@151 46 local broken_delegations = Delegation:new_selector()
bsw@209 47 :join("issue", nil, "issue.id = delegation.issue_id AND issue.closed ISNULL")
poelzi@151 48 :join("member", nil, "delegation.trustee_id = member.id")
poelzi@152 49 :add_where{"delegation.truster_id = ?", member.id}
bsw@203 50 :add_where{"member.active = 'f' OR (member.last_login_public IS NULL OR age(member.last_login) > ?::interval)", config.delegation_warning_time }
poelzi@151 51
poelzi@155 52 if broken_delegations:count() > 0 then
poelzi@151 53 tabs[#tabs+1] = {
poelzi@151 54 class = "red",
bsw@203 55 name = "broken_delegations",
poelzi@151 56 label = _"Delegation problems" .. " (" .. tostring(broken_delegations:count()) .. ")",
poelzi@151 57 icon = { static = "icons/16/table_go.png" },
poelzi@151 58 module = "delegation",
poelzi@151 59 view = "_list",
poelzi@151 60 params = { delegations_selector = broken_delegations, outgoing = true },
poelzi@151 61 }
poelzi@151 62 end
poelzi@151 63
bsw@57 64 local selector = Area:new_selector()
bsw@57 65 :reset_fields()
bsw@57 66 :add_field("area.id", nil, { "grouped" })
bsw@57 67 :add_field("area.name", nil, { "grouped" })
bsw@57 68 :add_field("membership.member_id NOTNULL", "is_member", { "grouped" })
bsw@57 69 :add_field("count(issue.id)", "issues_to_vote_count")
bsw@57 70 :add_field("count(interest.member_id)", "interested_issues_to_vote_count")
bsw@57 71 :add_field("count(interest.member_id NOTNULL OR interest.member_id NOTNULL)", "issues_to_vote_count_sum")
bsw@57 72 :join("issue", nil, "issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL")
bsw@57 73 :left_join("direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", app.session.member.id })
bsw@57 74 :add_where{ "direct_voter.member_id ISNULL" }
bsw@57 75 :left_join("interest", nil, { "interest.issue_id = issue.id AND interest.member_id = ?", app.session.member.id })
bsw@57 76 :left_join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ? ", app.session.member.id })
bsw@57 77
bsw@57 78 local not_voted_areas = {}
bsw@57 79 local issues_to_vote_count = 0
bsw@57 80 for i, area in ipairs(selector:exec()) do
bsw@57 81 if area.is_member or area.interested_issues_to_vote_count > 0 then
bsw@57 82 not_voted_areas[#not_voted_areas+1] = area
bsw@57 83 end
bsw@67 84 if area.is_member then
bsw@67 85 issues_to_vote_count = issues_to_vote_count + area.issues_to_vote_count_sum
bsw@67 86 end
bsw@57 87 end
bsw@57 88
bsw@57 89 if issues_to_vote_count > 0 then
bsw@57 90 tabs[#tabs+1] = {
bsw@57 91 class = "yellow",
bsw@57 92 name = "not_voted_issues",
bsw@57 93 label = _"Not voted issues" .. " (" .. tostring(issues_to_vote_count) .. ")",
bsw@57 94 icon = { static = "icons/16/email_open.png" },
bsw@57 95 module = "index",
bsw@57 96 view = "_not_voted_issues",
bsw@57 97 params = {
bsw@57 98 areas = not_voted_areas
bsw@57 99 }
bsw@57 100 }
bsw@57 101 end
bsw@57 102
bsw@57 103 local initiator_invites_selector = Initiative:new_selector()
bsw@57 104 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id")
bsw@57 105 :join("initiator", nil, { "initiator.initiative_id = initiative.id AND initiator.member_id = ? AND initiator.accepted ISNULL", app.session.member.id })
bsw@57 106 :add_where("_issue_state.closed ISNULL AND _issue_state.half_frozen ISNULL")
bsw@57 107
bsw@57 108 if initiator_invites_selector:count() > 0 then
bsw@57 109 tabs[#tabs+1] = {
bsw@57 110 class = "yellow",
bsw@57 111 name = "initiator_invites",
bsw@57 112 label = _"Initiator invites" .. " (" .. tostring(initiator_invites_selector:count()) .. ")",
bsw@57 113 icon = { static = "icons/16/user_add.png" },
bsw@57 114 module = "index",
bsw@57 115 view = "_initiator_invites",
bsw@57 116 params = {
bsw@57 117 initiatives_selector = initiator_invites_selector
bsw@57 118 }
bsw@57 119 }
bsw@57 120 end
bsw@57 121
bsw@57 122 local updated_drafts_selector = Initiative:new_selector()
bsw@57 123 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id AND _issue_state.closed ISNULL AND _issue_state.fully_frozen ISNULL")
bsw@57 124 :join("current_draft", "_current_draft", "_current_draft.initiative_id = initiative.id")
bsw@57 125 :join("supporter", "supporter", { "supporter.member_id = ? AND supporter.initiative_id = initiative.id AND supporter.draft_id < _current_draft.id", app.session.member_id })
bsw@75 126 :add_where("initiative.revoked ISNULL")
bsw@57 127
bsw@57 128 if updated_drafts_selector:count() > 0 then
bsw@57 129 tabs[#tabs+1] = {
bsw@57 130 class = "yellow",
bsw@57 131 name = "updated_drafts",
bsw@57 132 label = _"Updated drafts" .. " (" .. tostring(updated_drafts_selector:count()) .. ")",
bsw@57 133 icon = { static = "icons/16/script.png" },
bsw@57 134 module = "index",
bsw@57 135 view = "_updated_drafts",
bsw@57 136 params = {
bsw@57 137 initiatives_selector = updated_drafts_selector
bsw@57 138 }
bsw@57 139 }
bsw@57 140 end
bsw@57 141 end
bsw@57 142
bsw@57 143 tabs[#tabs+1] = {
bsw@57 144 name = "profile",
bsw@57 145 label = _"Profile",
bsw@57 146 icon = { static = "icons/16/application_form.png" },
bsw@57 147 module = "member",
bsw@57 148 view = "_profile",
bsw@57 149 params = { member = member },
bsw@57 150 }
bsw@57 151
bsw/jbe@19 152 local areas_selector = member:get_reference_selector("areas")
bsw@57 153 tabs[#tabs+1] = {
bsw@57 154 name = "areas",
bsw@57 155 label = _"Areas" .. " (" .. tostring(areas_selector:count()) .. ")",
bsw@57 156 icon = { static = "icons/16/package.png" },
bsw@57 157 module = "area",
bsw@57 158 view = "_list",
bsw@57 159 params = { areas_selector = areas_selector },
bsw@57 160 }
bsw@57 161
bsw/jbe@19 162 local issues_selector = member:get_reference_selector("issues")
bsw@57 163 tabs[#tabs+1] = {
bsw@57 164 name = "issues",
bsw@57 165 label = _"Issues" .. " (" .. tostring(issues_selector:count()) .. ")",
bsw@57 166 icon = { static = "icons/16/folder.png" },
bsw@57 167 module = "issue",
bsw@57 168 view = "_list",
bsw@57 169 params = { issues_selector = issues_selector },
bsw@57 170 }
bsw@57 171
bsw/jbe@19 172 local supported_initiatives_selector = member:get_reference_selector("supported_initiatives")
bsw@95 173
bsw@57 174 tabs[#tabs+1] = {
bsw@57 175 name = "supported_initiatives",
bsw@57 176 label = _"Supported initiatives" .. " (" .. tostring(supported_initiatives_selector:count()) .. ")",
bsw@57 177 icon = { static = "icons/16/thumb_up_green.png" },
bsw@95 178 module = "member",
bsw@95 179 view = "_list_supported_initiatives",
poelzi@137 180 params = { initiatives_selector = supported_initiatives_selector,
poelzi@137 181 member = member },
bsw@57 182 }
bsw@57 183
bsw/jbe@19 184 local initiated_initiatives_selector = member:get_reference_selector("initiated_initiatives"):add_where("initiator.accepted = true")
bsw@57 185 tabs[#tabs+1] = {
bsw@57 186 name = "initiatied_initiatives",
bsw@57 187 label = _"Initiated initiatives" .. " (" .. tostring(initiated_initiatives_selector:count()) .. ")",
bsw@57 188 icon = { static = "icons/16/user_edit.png" },
bsw@95 189 module = "member",
bsw@95 190 view = "_list_supported_initiatives",
poelzi@137 191 params = { initiatives_selector = initiated_initiatives_selector,
poelzi@137 192 member = member},
bsw@57 193 }
bsw@57 194
bsw/jbe@19 195 local incoming_delegations_selector = member:get_reference_selector("incoming_delegations")
bsw/jbe@19 196 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id")
bsw/jbe@19 197 :add_where("_member_showtab_issue.closed ISNULL")
bsw@57 198 tabs[#tabs+1] = {
bsw@57 199 name = "incoming_delegations",
bsw@57 200 label = _"Incoming delegations" .. " (" .. tostring(incoming_delegations_selector:count()) .. ")",
bsw@57 201 icon = { static = "icons/16/table_go.png" },
bsw@57 202 module = "delegation",
bsw@57 203 view = "_list",
bsw@57 204 params = { delegations_selector = incoming_delegations_selector, incoming = true },
bsw@57 205 }
bsw@57 206
bsw/jbe@19 207 local outgoing_delegations_selector = member:get_reference_selector("outgoing_delegations")
bsw/jbe@19 208 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id")
bsw/jbe@19 209 :add_where("_member_showtab_issue.closed ISNULL")
bsw@57 210 tabs[#tabs+1] = {
bsw@57 211 name = "outgoing_delegations",
bsw@57 212 label = _"Outgoing delegations" .. " (" .. tostring(outgoing_delegations_selector:count()) .. ")",
bsw@57 213 icon = { static = "icons/16/table_go.png" },
bsw@57 214 module = "delegation",
bsw@57 215 view = "_list",
bsw@57 216 params = { delegations_selector = outgoing_delegations_selector, outgoing = true },
bsw@57 217 }
bsw/jbe@19 218
bsw@57 219 local contacts_selector = member:get_reference_selector("saved_members"):add_where("public")
bsw@57 220 tabs[#tabs+1] = {
bsw@57 221 name = "contacts",
bsw@57 222 label = _"Contacts" .. " (" .. tostring(contacts_selector:count()) .. ")",
bsw@57 223 icon = { static = "icons/16/book_edit.png" },
bsw/jbe@19 224 module = "member",
bsw@57 225 view = "_list",
bsw@57 226 params = { members_selector = contacts_selector },
bsw/jbe@19 227 }
bsw@57 228
bsw@57 229 ui.tabs(tabs)

Impressum / About Us