1 ui.title(_"Usermanagement")

2 app.html_title.title = _"Usermanagement"

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 = _"Usermanagement" }

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 local count = Verification:new_selector()

40 :add_where("verified_member_id ISNULL")

41 :add_where("denied ISNULL")

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

43 :count()

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

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

46 end }

47

48 local count = Verification:new_selector()

49 :add_where("verified_member_id ISNULL")

50 :add_where("denied ISNULL")

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

52 :count()

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

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

55 end }

56

57 local count = Verification:new_selector()

58 :add_where("verified_member_id ISNULL")

59 :add_where("denied ISNULL")

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

61 :count()

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

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

64 end }

65

66 local count = Verification:new_selector()

67 :add_where("verified_member_id ISNULL")

68 :add_where("denied ISNULL")

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

70 :count()

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

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

73 end }

74

75 local count = Verification:new_selector()

76 :add_where("verified_member_id ISNULL")

77 :add_where("denied ISNULL")

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

79 :count()

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

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

82 end }

83

84 local count = Verification:new_selector()

85 :add_where("verified_member_id ISNULL")

86 :add_where("denied ISNULL")

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

88 :count()

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

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

91 end }

92

93 local count = Verification:new_selector()

94 :add_where("verified_member_id ISNULL")

95 :add_where("denied ISNULL")

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

97 :count()

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

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

100 end }

101

102 local count = Verification:new_selector()

103 :add_where("verified_member_id ISNULL")

104 :add_where("denied ISNULL")

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

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

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

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

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

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

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

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

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

114 :count()

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

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

117 end }

118 end }

119

120 local count = Verification:new_selector()

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

122 :count()

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

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

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

126

127 local count = Verification:new_selector()

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

129 :add_where("member.activated ISNULL")

130 :add_where("member.deleted ISNULL")

131 :count()

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

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

134 end }

135

136 local count = Verification:new_selector()

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

138 :add_where("member.activated NOTNULL")

139 :add_where("member.deleted ISNULL")

140 :count()

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

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

143 end }

144

145 local count = Verification:new_selector()

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

147 :add_where("member.deleted NOTNULL")

148 :count()

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

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

151 end }

152 end }

153 end }

154

155 local count = Verification:new_selector()

156 :add_where("denied NOTNULL")

157 :count()

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

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

160 end }

161

162 end }

163

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

165

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

167

168 local count = RoleVerification:new_selector()

169 :add_where("verified ISNULL")

170 :add_where("denied ISNULL")

171 :count()

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

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

174 end }

175

176 local count = RoleVerification:new_selector()

177 :add_where("verified NOTNULL")

178 :add_where("denied ISNULL")

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

180 :add_where("member.deleted ISNULL")

181 :count()

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

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

184 end }

185

186 local count = RoleVerification:new_selector()

187 :add_where("verified NOTNULL")

188 :add_where("denied ISNULL")

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

190 :add_where("member.deleted NOTNULL")

191 :count()

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

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

194 end }

195

196 local count = RoleVerification:new_selector()

197 :add_where("verified ISNULL")

198 :add_where("denied NOTNULL")

199 :count()

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

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

202 end }

203

204

205 end }

206

207 end }

208 end }

209

210

211

212 end }

213 end }

214