1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/app/main/index/show_tab.lua	Sat Apr 17 21:59:02 2010 +0200
     1.3 @@ -0,0 +1,72 @@
     1.4 +local tabs = {
     1.5 +  module = "index",
     1.6 +  view = "show_tab"
     1.7 +}
     1.8 +
     1.9 +local selector = Area:new_selector()
    1.10 +  :reset_fields()
    1.11 +  :add_field("area.id", nil, { "grouped" })
    1.12 +  :add_field("area.name", nil, { "grouped" })
    1.13 +  :add_field("membership.member_id NOTNULL", "is_member", { "grouped" })
    1.14 +  :add_field("count(issue.id)", "issues_to_vote_count")
    1.15 +  :add_field("count(interest.member_id)", "interested_issues_to_vote_count")
    1.16 +  :add_field("count(interest.member_id NOTNULL OR interest.member_id NOTNULL)", "issues_to_vote_count_sum")
    1.17 +  :join("issue", nil, "issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL")
    1.18 +  :left_join("direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", app.session.member.id })
    1.19 +  :add_where{ "direct_voter.member_id ISNULL" }
    1.20 +  :left_join("interest", nil, { "interest.issue_id = issue.id AND interest.member_id = ?", app.session.member.id })
    1.21 +  :left_join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ? ", app.session.member.id })
    1.22 +
    1.23 +local not_voted_areas = {}
    1.24 +local issues_to_vote_count = 0
    1.25 +for i, area in ipairs(selector:exec()) do
    1.26 +  if area.is_member or area.interested_issues_to_vote_count > 0 then
    1.27 +    not_voted_areas[#not_voted_areas+1] = area
    1.28 +  end
    1.29 +  issues_to_vote_count = issues_to_vote_count + area.issues_to_vote_count_sum
    1.30 +end
    1.31 +
    1.32 +tabs[#tabs+1] = {
    1.33 +  name = "not_voted_issues",
    1.34 +  label = _"Not voted issues" .. " (" .. tostring(issues_to_vote_count) .. ")",
    1.35 +  icon = { static = "icons/16/email_open.png" },
    1.36 +  module = "index",
    1.37 +  view = "_not_voted_issues",
    1.38 +  params = {
    1.39 +    areas = not_voted_areas
    1.40 +  }
    1.41 +}
    1.42 +
    1.43 +local initiator_invites_selector = Initiative:new_selector()
    1.44 +  :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id")
    1.45 +  :join("initiator", nil, { "initiator.initiative_id = initiative.id AND initiator.member_id = ? AND initiator.accepted ISNULL", app.session.member.id })
    1.46 +  :add_where("_issue_state.closed ISNULL AND _issue_state.half_frozen ISNULL")
    1.47 +
    1.48 +tabs[#tabs+1] = {
    1.49 +  name = "initiator_invites",
    1.50 +  label = _"Initiator invites" .. " (" .. tostring(initiator_invites_selector:count()) .. ")",
    1.51 +  icon = { static = "icons/16/email_open.png" },
    1.52 +  module = "index",
    1.53 +  view = "_initiator_invites",
    1.54 +  params = {
    1.55 +    initiatives_selector = initiator_invites_selector
    1.56 +  }
    1.57 +}
    1.58 +
    1.59 +local updated_drafts_selector = Initiative:new_selector()
    1.60 +  :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id AND _issue_state.closed ISNULL AND _issue_state.fully_frozen ISNULL")
    1.61 +  :join("current_draft", "_current_draft", "_current_draft.initiative_id = initiative.id")
    1.62 +  :join("supporter", "supporter", { "supporter.member_id = ? AND supporter.initiative_id = initiative.id AND supporter.draft_id < _current_draft.id", app.session.member_id })
    1.63 +
    1.64 +tabs[#tabs+1] = {
    1.65 +  name = "updated_drafts",
    1.66 +  label = _"Updated drafts" .. " (" .. tostring(updated_drafts_selector:count()) .. ")",
    1.67 +  icon = { static = "icons/16/email_open.png" },
    1.68 +  module = "index",
    1.69 +  view = "_updated_drafts",
    1.70 +  params = {
    1.71 +    initiatives_selector = updated_drafts_selector
    1.72 +  }
    1.73 +}
    1.74 +
    1.75 +ui.tabs(tabs)
    1.76 \ No newline at end of file