1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/app/main/registration_admin/index.lua	Sun Jul 15 14:07:29 2018 +0200
     1.3 @@ -0,0 +1,212 @@
     1.4 +ui.title(_"Usermanagement")
     1.5 +app.html_title.title = _"Usermanagement"
     1.6 +
     1.7 +ui.container{ attr = { class = "mdl-grid" }, content = function()
     1.8 +  ui.container{ attr = { class = "mdl-cell mdl-cell--12-col" }, content = function()
     1.9 +
    1.10 +    ui.container{ attr = { class = "mdl-card mdl-card__fullwidth mdl-shadow--2dp" }, content = function()
    1.11 +      ui.container{ attr = { class = "mdl-card__title mdl-card--border" }, content = function()
    1.12 +        ui.heading { attr = { class = "mdl-card__title-text" }, level = 2, content = function()
    1.13 +          ui.tag{ content = _"Usermanagement" }
    1.14 +        end }
    1.15 +      end }
    1.16 +
    1.17 +      ui.container{ attr = { class = "mdl-card__content mdl-card--border" }, content = function()
    1.18 +
    1.19 +        ui.container{ content = _"User accounts" }
    1.20 +      
    1.21 +        ui.tag{ tag = "ul", content = function()
    1.22 +
    1.23 +          local count = Verification:new_selector()
    1.24 +            :add_where("verified_member_id ISNULL")
    1.25 +            :add_where("denied ISNULL")
    1.26 +            :count()
    1.27 +          ui.tag{ tag = "li", content = function()
    1.28 +            ui.link{ module = "registration_admin", view = "verification_requests", content = _("Open requests (#{count})", { count = count }) }
    1.29 +          end }
    1.30 +          
    1.31 +          ui.tag{ tag = "ul", content = function()
    1.32 +          
    1.33 +            local count = Verification:new_selector()
    1.34 +              :add_where("verified_member_id ISNULL")
    1.35 +              :add_where("denied ISNULL")
    1.36 +              :add_where("comment ilike '%User requested manual verification (during step 1)'")
    1.37 +              :count()
    1.38 +            ui.tag{ tag = "li", content = function()
    1.39 +              ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "manual_requested", step = 1 }, content = _("Manual verification requested during step 1 (#{count})", { count = count }) }
    1.40 +            end }
    1.41 +            
    1.42 +            local count = Verification:new_selector()
    1.43 +              :add_where("verified_member_id ISNULL")
    1.44 +              :add_where("denied ISNULL")
    1.45 +              :add_where("comment ilike '%User requested manual verification (during step 2)'")
    1.46 +              :count()
    1.47 +            ui.tag{ tag = "li", content = function()
    1.48 +              ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "manual_requested", step = 2 }, content = _("Manual verification requested during step 2 (#{count})", { count = count }) }
    1.49 +            end }
    1.50 +            
    1.51 +            local count = Verification:new_selector()
    1.52 +              :add_where("verified_member_id ISNULL")
    1.53 +              :add_where("denied ISNULL")
    1.54 +              :add_where("comment ilike '% sent'")
    1.55 +              :count()
    1.56 +            ui.tag{ tag = "li", content = function()
    1.57 +              ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "pin_sent" }, content = _("PIN code not entered (yet) (#{count})", { count = count }) }
    1.58 +            end }
    1.59 +            
    1.60 +            local count = Verification:new_selector()
    1.61 +              :add_where("verified_member_id ISNULL")
    1.62 +              :add_where("denied ISNULL")
    1.63 +              :add_where("comment similar to '%fiscal code does not match[^/]*'")
    1.64 +              :count()
    1.65 +            ui.tag{ tag = "li", content = function()
    1.66 +              ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "fiscal_code" }, content = _("Fiscal code does not match (#{count})", { count = count }) }
    1.67 +            end }
    1.68 +            
    1.69 +            local count = Verification:new_selector()
    1.70 +              :add_where("verified_member_id ISNULL")
    1.71 +              :add_where("denied ISNULL")
    1.72 +              :add_where("comment ilike '%mobile phone number already used before'")
    1.73 +              :count()
    1.74 +            ui.tag{ tag = "li", content = function()
    1.75 +              ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "mobile_phone" }, content = _("Phone number used before (#{count})", { count = count }) }
    1.76 +            end }
    1.77 +            
    1.78 +            local count = Verification:new_selector()
    1.79 +              :add_where("verified_member_id ISNULL")
    1.80 +              :add_where("denied ISNULL")
    1.81 +              :add_where("comment ilike '%user with same name already exist'")
    1.82 +              :count()
    1.83 +            ui.tag{ tag = "li", content = function()
    1.84 +              ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "identification" }, content = _("Identification used before (#{count})", { count = count }) }
    1.85 +            end }
    1.86 +            
    1.87 +            local count = Verification:new_selector()
    1.88 +              :add_where("verified_member_id ISNULL")
    1.89 +              :add_where("denied ISNULL")
    1.90 +              :add_where("comment ilike '%user entered invalid PIN three times'")
    1.91 +              :count()
    1.92 +            ui.tag{ tag = "li", content = function()
    1.93 +              ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "invalid_pin" }, content = _("Invalid PIN entered (#{count})", { count = count }) }
    1.94 +            end }
    1.95 +            
    1.96 +            local count = Verification:new_selector()
    1.97 +              :add_where("verified_member_id ISNULL")
    1.98 +              :add_where("denied ISNULL")
    1.99 +              :add_where("comment ilike '%user with same name already exists'")
   1.100 +              :count()
   1.101 +            ui.tag{ tag = "li", content = function()
   1.102 +              ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "same_name_already_exists" }, content = _("User with same name already exists (#{count})", { count = count }) }
   1.103 +            end }
   1.104 +            
   1.105 +            local count = Verification:new_selector()
   1.106 +              :add_where("verified_member_id ISNULL")
   1.107 +              :add_where("denied ISNULL")
   1.108 +              :add_where("not comment ilike '%User requested manual verification'")
   1.109 +              :add_where("not comment ilike '% sent'")
   1.110 +              :add_where("not comment similar to '%fiscal code does not match[^/]*'")
   1.111 +              :add_where("not comment ilike '%mobile phone number already used before'")
   1.112 +              :add_where("not comment ilike '%user with same name already exist'")
   1.113 +              :add_where("not comment ilike '%user entered invalid PIN three times'")
   1.114 +              :add_where("not comment ilike '%user with same name already exists'")
   1.115 +              :count()
   1.116 +            ui.tag{ tag = "li", content = function()
   1.117 +              ui.link{ module = "registration_admin", view = "verification_requests", params = { mode = "other" }, content = _("other reasons (#{count})", { count = count }) }
   1.118 +            end }
   1.119 +          end }
   1.120 +          
   1.121 +          local count = Verification:new_selector()
   1.122 +            :join("member", nil, "member.id = verification.verified_member_id")
   1.123 +            :count()
   1.124 +          ui.tag{ tag = "li", content = function()
   1.125 +            ui.link{ module = "registration_admin", view = "verification_accredited", content = _("Accredited (#{count})", { count = count }) }
   1.126 +            ui.tag{ tag = "ul", content = function()
   1.127 +            
   1.128 +              local count = Verification:new_selector()
   1.129 +                :join("member", nil, "member.id = verification.verified_member_id")
   1.130 +                :add_where("member.activated ISNULL")
   1.131 +                :add_where("member.deleted ISNULL")
   1.132 +                :count()
   1.133 +              ui.tag{ tag = "li", content = function()
   1.134 +                ui.link{ module = "registration_admin", view = "verification_accredited", params = { mode = "not_activated" }, content = _("Account not activated (yet) (#{count})", { count = count }) }
   1.135 +              end }
   1.136 +              
   1.137 +              local count = Verification:new_selector()
   1.138 +                :join("member", nil, "member.id = verification.verified_member_id")
   1.139 +                :add_where("member.activated NOTNULL")
   1.140 +                :add_where("member.deleted ISNULL")
   1.141 +                :count()
   1.142 +              ui.tag{ tag = "li", content = function()
   1.143 +                ui.link{ module = "registration_admin", view = "verification_accredited", params = { mode = "activated" }, content = _("Activated accounts (#{count})", { count = count }) }
   1.144 +              end }
   1.145 +              
   1.146 +              local count = Verification:new_selector()
   1.147 +                :join("member", nil, "member.id = verification.verified_member_id")
   1.148 +                :add_where("member.deleted NOTNULL")
   1.149 +                :count()
   1.150 +              ui.tag{ tag = "li", content = function()
   1.151 +                ui.link{ module = "registration_admin", view = "verification_cancelled", content = _("Cancelled accounts (#{count})", { count = count }) }
   1.152 +              end }
   1.153 +            end }
   1.154 +          end }
   1.155 +          
   1.156 +          local count = Verification:new_selector()
   1.157 +            :add_where("denied NOTNULL")
   1.158 +            :count()
   1.159 +          ui.tag{ tag = "li", content = function()
   1.160 +            ui.link{ module = "registration_admin", view = "verification_rejected", content = _("Rejected requests (#{count})", { count = count }) }
   1.161 +          end }
   1.162 +          
   1.163 +        end }
   1.164 +
   1.165 +        ui.container{ content = _"Role accounts" }
   1.166 +      
   1.167 +        ui.tag{ tag = "ul", content = function()
   1.168 +
   1.169 +          local count = RoleVerification:new_selector()
   1.170 +            :add_where("verified ISNULL")
   1.171 +            :add_where("denied ISNULL")
   1.172 +            :count()
   1.173 +          ui.tag{ tag = "li", content = function()
   1.174 +            ui.link{ module = "registration_admin", view = "role_verification_requests", content = _("Open requests (#{count})", { count = count }) }
   1.175 +          end }
   1.176 +          
   1.177 +          local count = RoleVerification:new_selector()
   1.178 +            :add_where("verified NOTNULL")
   1.179 +            :add_where("denied ISNULL")
   1.180 +            :join("member", nil, "member.id = role_verification.verified_member_id")
   1.181 +            :add_where("member.deleted ISNULL")
   1.182 +            :count()
   1.183 +          ui.tag{ tag = "li", content = function()
   1.184 +            ui.link{ module = "registration_admin", view = "role_verification_accredited", content = _("Accredited (#{count})", { count = count }) }
   1.185 +          end }
   1.186 +          
   1.187 +          local count = RoleVerification:new_selector()
   1.188 +            :add_where("verified NOTNULL")
   1.189 +            :add_where("denied ISNULL")
   1.190 +            :join("member", nil, "member.id = role_verification.verified_member_id")
   1.191 +            :add_where("member.deleted NOTNULL")
   1.192 +            :count()
   1.193 +          ui.tag{ tag = "li", content = function()
   1.194 +            ui.link{ module = "registration_admin", view = "role_verification_cancelled", content = _("Cancelled (#{count})", { count = count }) }
   1.195 +          end }
   1.196 +          
   1.197 +          local count = RoleVerification:new_selector()
   1.198 +            :add_where("verified ISNULL")
   1.199 +            :add_where("denied NOTNULL")
   1.200 +            :count()
   1.201 +          ui.tag{ tag = "li", content = function()
   1.202 +            ui.link{ module = "registration_admin", view = "role_verification_rejected", content = _("Rejected (#{count})", { count = count }) }
   1.203 +          end }
   1.204 +          
   1.205 +          
   1.206 +        end }
   1.207 +
   1.208 +      end }
   1.209 +    end }
   1.210 +
   1.211 +
   1.212 +
   1.213 +  end }
   1.214 +end }
   1.215 +