liquid_feedback_frontend
view app/main/member/show_tab.lua @ 436:852962dd9bb0
Fixed typo in german translation
| author | bsw | 
|---|---|
| date | Sun Mar 11 12:21:54 2012 +0100 (2012-03-11) | 
| parents | 699b9fa7bc36 | 
| children | bbd0dcb5be63 | 
 line source
     1 local show_as_homepage = param.get("show_as_homepage", atom.boolean)
     3 local member
     5 if request.get_json_request_slots() then
     6   member = Member:by_id(param.get("member_id"))
     7 else
     8   member = param.get("member", "table")
     9 end
    11 local tabs = {
    12   module = "member",
    13   view = "show_tab",
    14   static_params = {
    15     member_id = member.id,
    16     show_as_homepage = show_as_homepage
    17   }
    18 }
    20 if show_as_homepage and app.session.member_id == member.id then
    22   if app.session.member.notify_email_unconfirmed then
    23     tabs[#tabs+1] = {
    24       class = "yellow",
    25       name = "email_unconfirmed",
    26       label = _"Email unconfirmed",
    27       module = "member",
    28       view = "_email_unconfirmed",
    29       params = {}
    30     }
    31   end
    33   if app.session.member.notify_level == nil then
    34     tabs[#tabs+1] = {
    35       class = "yellow",
    36       name = "notify_level_not_set",
    37       label = _"Notifications",
    38       module = "member",
    39       view = "_notify_level_not_set"
    40     }
    41   end
    43   if config.motd_intern then
    44     tabs[#tabs+1] = {
    45       class = "yellow",
    46       name = "motd",
    47       label = _"Message of the day",
    48       module = "index",
    49       view = "_motd",
    50       params = {}
    51     }
    52   end
    54   local broken_delegations = Delegation:new_selector()
    55     :join("issue", nil, "issue.id = delegation.issue_id AND issue.closed ISNULL")
    56     :join("member", nil, "delegation.trustee_id = member.id")
    57     :add_where{"delegation.truster_id = ?", member.id}
    58     :add_where{"member.active = 'f' OR (member.last_activity IS NULL OR age(member.last_activity) > ?::interval)", config.delegation_warning_time }
    60   if broken_delegations:count() > 0 then
    61     tabs[#tabs+1] = {
    62       class = "red",
    63       name = "broken_delegations",
    64       label = _"Delegation problems" .. " (" .. tostring(broken_delegations:count()) .. ")",
    65       icon = { static = "icons/16/table_go.png" },
    66       module = "delegation",
    67       view = "_list",
    68       params = { delegations_selector = broken_delegations, outgoing = true },
    69     }
    70   end
    72   local selector = Area:new_selector()
    73     :reset_fields()
    74     :join("privilege", nil, { "privilege.unit_id = area.unit_id AND privilege.member_id = ? AND privilege.voting_right", app.session.member_id })
    75     :add_field("area.id", nil, { "grouped" })
    76     :add_field("area.name", nil, { "grouped" })
    77     :add_field("membership.member_id NOTNULL", "is_member", { "grouped" })
    78     :add_field("count(issue.id)", "issues_to_vote_count")
    79     :add_field("count(interest.member_id)", "interested_issues_to_vote_count")
    80     :add_field("count(interest.member_id NOTNULL OR interest.member_id NOTNULL)", "issues_to_vote_count_sum")
    81     :join("issue", nil, "issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL")
    82     :left_join("direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", app.session.member.id })
    83     :add_where{ "direct_voter.member_id ISNULL" }
    84     :left_join("interest", nil, { "interest.issue_id = issue.id AND interest.member_id = ?", app.session.member.id })
    85     :left_join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ? ", app.session.member.id })
    87   local not_voted_areas = {}
    88   local issues_to_vote_count = 0
    89   for i, area in ipairs(selector:exec()) do
    90     if area.is_member or area.interested_issues_to_vote_count > 0 then
    91       not_voted_areas[#not_voted_areas+1] = area
    92     end
    93     if area.is_member then
    94       issues_to_vote_count = issues_to_vote_count + area.issues_to_vote_count_sum
    95     end
    96   end
    98   if issues_to_vote_count > 0 then
    99     tabs[#tabs+1] = {
   100       class = "yellow",
   101       name = "not_voted_issues",
   102       label = _"Not voted issues" .. " (" .. tostring(issues_to_vote_count) .. ")",
   103       icon = { static = "icons/16/email_open.png" },
   104       module = "index",
   105       view = "_not_voted_issues",
   106       params = {
   107         areas = not_voted_areas
   108       }
   109     }
   110   end
   112   local initiator_invites_selector = Initiative:new_selector()
   113     :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id")
   114     :join("initiator", nil, { "initiator.initiative_id = initiative.id AND initiator.member_id = ? AND initiator.accepted ISNULL", app.session.member.id })
   115     :add_where("_issue_state.closed ISNULL AND _issue_state.half_frozen ISNULL")
   117   if initiator_invites_selector:count() > 0 then
   118     tabs[#tabs+1] = {
   119       class = "yellow",
   120       name = "initiator_invites",
   121       label = _"Initiator invites" .. " (" .. tostring(initiator_invites_selector:count()) .. ")",
   122       icon = { static = "icons/16/user_add.png" },
   123       module = "index",
   124       view = "_initiator_invites",
   125       params = {
   126         initiatives_selector = initiator_invites_selector
   127       }
   128     }
   129   end
   131   local updated_drafts_selector = Initiative:new_selector()
   132     :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id AND _issue_state.closed ISNULL AND _issue_state.fully_frozen ISNULL")
   133     :join("current_draft", "_current_draft", "_current_draft.initiative_id = initiative.id")
   134     :join("supporter", "supporter", { "supporter.member_id = ? AND supporter.initiative_id = initiative.id AND supporter.draft_id < _current_draft.id", app.session.member_id })
   135     :add_where("initiative.revoked ISNULL")
   137   if updated_drafts_selector:count() > 0 then
   138     tabs[#tabs+1] = {
   139       class = "yellow",
   140       name = "updated_drafts",
   141       label = _"Updated drafts" .. " (" .. tostring(updated_drafts_selector:count()) .. ")",
   142       icon = { static = "icons/16/script.png" },
   143       module = "index",
   144       view = "_updated_drafts",
   145       params = {
   146         initiatives_selector = updated_drafts_selector
   147       }
   148     }
   149   end
   150 end
   152 if not show_as_homepage then
   153   tabs[#tabs+1] = {
   154     name = "profile",
   155     label = _"Profile",
   156     icon = { static = "icons/16/application_form.png" },
   157     module = "member",
   158     view = "_profile",
   159     params = { member = member },
   160   }
   161 end
   163 local areas_selector = member:get_reference_selector("areas")
   164 tabs[#tabs+1] = {
   165   name = "areas",
   166   label = _"Areas",
   167   icon = { static = "icons/16/package.png" },
   168   module = "member",
   169   view = "_area_list",
   170   params = { areas_selector = areas_selector, member = member },
   171 }
   172 --[[
   173 local issues_selector = Issue:new_selector()
   174 tabs[#tabs+1] = {
   175   name = "issues",
   176   label = _"Issues",
   177   icon = { static = "icons/16/folder.png" },
   178   module = "issue",
   179   view = "_list",
   180   params = {
   181     issues_selector = issues_selector, for_member = member,
   182   },
   183   link_params = {
   184     filter_interest = (member.id ~= app.session.member_id) and "my" or nil,
   185   },
   186 }
   187 --]]
   188 if show_as_homepage then
   189   tabs[#tabs+1] = {
   190     name = "timeline",
   191     label = _"Events",
   192     module = "member",
   193     view = "_event_list",
   194     params = { }
   195   }
   196 else
   197   tabs[#tabs+1] = {
   198     name = "timeline",
   199     label = _"Events",
   200     module = "event",
   201     view = "_list",
   202     params = { for_member = member }
   203   }
   204 end
   206 tabs[#tabs+1] = {
   207   name = "open",
   208   label = _"Open issues",
   209   module = "issue",
   210   view = "_list",
   211   params = {
   212     for_state = "open",
   213     issues_selector = Issue:new_selector()
   214       :add_where("issue.closed ISNULL")
   215       :add_order_by("coalesce(issue.fully_frozen + issue.voting_time, issue.half_frozen + issue.verification_time, issue.accepted + issue.discussion_time, issue.created + issue.admission_time) - now()")
   216   }
   217 }
   218 tabs[#tabs+1] = {
   219   name = "closed",
   220   label = _"Closed issues",
   221   module = "issue",
   222   view = "_list",
   223   params = {
   224     for_state = "closed",
   225     issues_selector = Issue:new_selector()
   226       :add_where("issue.closed NOTNULL")
   227       :add_order_by("issue.closed DESC")
   229   }
   230 }
   232 if not show_as_homepage then
   233   local outgoing_delegations_selector = member:get_reference_selector("outgoing_delegations")
   234     :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id")
   235     :add_where("_member_showtab_issue.closed ISNULL")
   236   tabs[#tabs+1] = {
   237     name = "outgoing_delegations",
   238     label = _"Outgoing delegations" .. " (" .. tostring(outgoing_delegations_selector:count()) .. ")",
   239     icon = { static = "icons/16/table_go.png" },
   240     module = "delegation",
   241     view = "_list",
   242     params = { delegations_selector = outgoing_delegations_selector, outgoing = true },
   243   }
   245   local incoming_delegations_selector = member:get_reference_selector("incoming_delegations")
   246     :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id")
   247     :add_where("_member_showtab_issue.closed ISNULL")
   248   tabs[#tabs+1] = {
   249     name = "incoming_delegations",
   250     label = _"Incoming delegations" .. " (" .. tostring(incoming_delegations_selector:count()) .. ")",
   251     icon = { static = "icons/16/table_go.png" },
   252     module = "delegation",
   253     view = "_list",
   254     params = { delegations_selector = incoming_delegations_selector, incoming = true },
   255   }
   257   local contacts_selector = member:get_reference_selector("saved_members"):add_where("public")
   258   tabs[#tabs+1] = {
   259     name = "contacts",
   260     label = _"Contacts" .. " (" .. tostring(contacts_selector:count()) .. ")",
   261     icon = { static = "icons/16/book_edit.png" },
   262     module = "member",
   263     view = "_list",
   264     params = { members_selector = contacts_selector },
   265   }
   266 end
   268 ui.tabs(tabs)
