1 ui.title(_"User management")

2 app.html_title.title = _"User management"

3

4 ui.container{ attr = { class = "mdl-grid" }, content = function()

5 ui.container{ attr = { class = "mdl-cell mdl-cell--12-col" }, content = function()

6

7 ui.container{ attr = { class = "mdl-card mdl-card__fullwidth mdl-shadow--2dp" }, content = function()

8 ui.container{ attr = { class = "mdl-card__title mdl-card--border" }, content = function()

9 ui.heading { attr = { class = "mdl-card__title-text" }, level = 2, content = function()

10 ui.tag{ content = _"User management" }

11 end }

12 end }

13

14 ui.container{ attr = { class = "mdl-card__content mdl-card--border" }, content = function()

15

16 ui.container{ content = _"User accounts" }

17

18 ui.tag{ tag = "ul", content = function()

19

20 local count = Verification:new_selector()

21 :add_where("verified_member_id ISNULL")

22 :add_where("denied ISNULL")

23 :count()

24 ui.tag{ tag = "li", content = function()

25 ui.link{ module = "registration_admin", view = "verification_requests", content = _("Open requests (#{count})", { count = count }) }

26 end }

27

28 ui.tag{ tag = "ul", content = function()

29

30 local count = Verification:new_selector()

31 :add_where("verified_member_id ISNULL")

32 :add_where("denied ISNULL")

33 :add_where("comment ilike '%User requested manual verification (during step 1)'")

34 :count()

35 ui.tag{ tag = "li", content = function()

36 ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "manual_requested", step = 1 }, content = _("Manual verification requested during step 1 (#{count})", { count = count }) }

37 end }

38

39 if config.self_registration.sms_id then

40 local count = Verification:new_selector()

41 :add_where("verified_member_id ISNULL")

42 :add_where("denied ISNULL")

43 :add_where("comment ilike '%User requested manual verification (during step 2)'")

44 :count()

45 ui.tag{ tag = "li", content = function()

46 ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "manual_requested", step = 2 }, content = _("Manual verification requested during step 2 (#{count})", { count = count }) }

47 end }

48

49 local count = Verification:new_selector()

50 :add_where("verified_member_id ISNULL")

51 :add_where("denied ISNULL")

52 :add_where("comment ilike '% sent'")

53 :count()

54 ui.tag{ tag = "li", content = function()

55 ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "pin_sent" }, content = _("PIN code not entered (yet) (#{count})", { count = count }) }

56 end }

57

58 local count = Verification:new_selector()

59 :add_where("verified_member_id ISNULL")

60 :add_where("denied ISNULL")

61 :add_where("comment ilike '%user entered invalid PIN three times'")

62 :count()

63 ui.tag{ tag = "li", content = function()

64 ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "invalid_pin" }, content = _("Invalid PIN entered (#{count})", { count = count }) }

65 end }

66 end

67

68 if config.self_registration.check_for_italian_fiscal_code then

69 local count = Verification:new_selector()

70 :add_where("verified_member_id ISNULL")

71 :add_where("denied ISNULL")

72 :add_where("comment similar to '%fiscal code does not match[^/]*'")

73 :count()

74 ui.tag{ tag = "li", content = function()

75 ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "fiscal_code" }, content = _("Fiscal code does not match (#{count})", { count = count }) }

76 end }

77 end

78

79 local count = Verification:new_selector()

80 :add_where("verified_member_id ISNULL")

81 :add_where("denied ISNULL")

82 :add_where("comment ilike '%mobile phone number already used before'")

83 :count()

84 ui.tag{ tag = "li", content = function()

85 ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "mobile_phone" }, content = _("Phone number used before (#{count})", { count = count }) }

86 end }

87

88 local count = Verification:new_selector()

89 :add_where("verified_member_id ISNULL")

90 :add_where("denied ISNULL")

91 :add_where("comment ilike '%user with same name already exist'")

92 :count()

93 ui.tag{ tag = "li", content = function()

94 ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "identification" }, content = _("Identification used before (#{count})", { count = count }) }

95 end }

96

97

98 local count = Verification:new_selector()

99 :add_where("verified_member_id ISNULL")

100 :add_where("denied ISNULL")

101 :add_where("comment ilike '%user with same name already exists'")

102 :count()

103 ui.tag{ tag = "li", content = function()

104 ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "same_name_already_exists" }, content = _("User with same name already exists (#{count})", { count = count }) }

105 end }

106

107 local count = Verification:new_selector()

108 :add_where("verified_member_id ISNULL")

109 :add_where("denied ISNULL")

110 :add_where("not comment ilike '%User requested manual verification (during step 1)'")

111 :add_where("not comment ilike '%User requested manual verification (during step 2)'")

112 :add_where("not comment ilike '%User requested manual verification'")

113 :add_where("not comment ilike '% sent'")

114 :add_where("not comment similar to '%fiscal code does not match[^/]*'")

115 :add_where("not comment ilike '%mobile phone number already used before'")

116 :add_where("not comment ilike '%user with same name already exist'")

117 :add_where("not comment ilike '%user entered invalid PIN three times'")

118 :add_where("not comment ilike '%user with same name already exists'")

119 :count()

120 ui.tag{ tag = "li", content = function()

121 ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "other" }, content = _("other reasons (#{count})", { count = count }) }

122 end }

123 end }

124

125 local count = Verification:new_selector()

126 :join("member", nil, "member.id = verification.verified_member_id")

127 :count()

128 ui.tag{ tag = "li", content = function()

129 ui.link{ module = "registration_admin", view = "verification_accredited", content = _("Accredited (#{count})", { count = count }) }

130 ui.tag{ tag = "ul", content = function()

131

132 local count = Verification:new_selector()

133 :join("member", nil, "member.id = verification.verified_member_id")

134 :add_where("member.activated ISNULL")

135 :add_where("member.deleted ISNULL")

136 :count()

137 ui.tag{ tag = "li", content = function()

138 ui.link{ module = "registration_admin", view = "verification_accredited", params = { mode = "not_activated" }, content = _("Account not activated (yet) (#{count})", { count = count }) }

139 end }

140

141 local count = Verification:new_selector()

142 :join("member", nil, "member.id = verification.verified_member_id")

143 :add_where("member.activated NOTNULL")

144 :add_where("member.deleted ISNULL")

145 :count()

146 ui.tag{ tag = "li", content = function()

147 ui.link{ module = "registration_admin", view = "verification_accredited", params = { mode = "activated" }, content = _("Activated accounts (#{count})", { count = count }) }

148 end }

149

150 local count = Verification:new_selector()

151 :join("member", nil, "member.id = verification.verified_member_id")

152 :add_where("member.deleted NOTNULL")

153 :count()

154 ui.tag{ tag = "li", content = function()

155 ui.link{ module = "registration_admin", view = "verification_cancelled", content = _("Cancelled accounts (#{count})", { count = count }) }

156 end }

157 end }

158 end }

159

160 local count = Verification:new_selector()

161 :add_where("denied NOTNULL")

162 :count()

163 ui.tag{ tag = "li", content = function()

164 ui.link{ module = "registration_admin", view = "verification_rejected", content = _("Rejected requests (#{count})", { count = count }) }

165 end }

166

167 end }

168

169 ui.container{ content = _"Role accounts" }

170

171 ui.tag{ tag = "ul", content = function()

172

173 local count = RoleVerification:new_selector()

174 :add_where("verified ISNULL")

175 :add_where("denied ISNULL")

176 :count()

177 ui.tag{ tag = "li", content = function()

178 ui.link{ module = "registration_admin", view = "role_verification_requests", content = _("Open requests (#{count})", { count = count }) }

179 end }

180

181 local count = RoleVerification:new_selector()

182 :add_where("verified NOTNULL")

183 :add_where("denied ISNULL")

184 :join("member", nil, "member.id = role_verification.verified_member_id")

185 :add_where("member.deleted ISNULL")

186 :count()

187 ui.tag{ tag = "li", content = function()

188 ui.link{ module = "registration_admin", view = "role_verification_accredited", content = _("Accredited (#{count})", { count = count }) }

189 end }

190

191 local count = RoleVerification:new_selector()

192 :add_where("verified NOTNULL")

193 :add_where("denied ISNULL")

194 :join("member", nil, "member.id = role_verification.verified_member_id")

195 :add_where("member.deleted NOTNULL")

196 :count()

197 ui.tag{ tag = "li", content = function()

198 ui.link{ module = "registration_admin", view = "role_verification_cancelled", content = _("Cancelled (#{count})", { count = count }) }

199 end }

200

201 local count = RoleVerification:new_selector()

202 :add_where("verified ISNULL")

203 :add_where("denied NOTNULL")

204 :count()

205 ui.tag{ tag = "li", content = function()

206 ui.link{ module = "registration_admin", view = "role_verification_rejected", content = _("Rejected (#{count})", { count = count }) }

207 end }

208

209

210 end }

211

212 end }

213 end }

214

215

216

217 end }

218 end }

219