bsw/jbe@1309: local mode = param.get("mode")
bsw/jbe@1309: local step = param.get("step", atom.integer)
bsw/jbe@1309: 
bsw/jbe@1309: local verifications_selector = Verification:new_selector()
bsw/jbe@1309:   :add_where("verified_member_id ISNULL")
bsw/jbe@1309:   :add_where("denied ISNULL")
bsw/jbe@1309:   :add_order_by("requested DESC")
bsw/jbe@1309: 
bsw/jbe@1309: local title = _"Open requests"
bsw/jbe@1309:   
bsw/jbe@1309: if mode == "manual_requested" and step == 1 then
bsw/jbe@1309:   title = _"Manual verification requested during step 1"
bsw/jbe@1309:   verifications_selector:add_where("comment ilike '%User requested manual verification (during step 1)'")
bsw/jbe@1309: elseif mode == "manual_requested" and step == 2 then
bsw/jbe@1309:   title = _"Manual verification requested during step 2"
bsw/jbe@1309:   verifications_selector:add_where("comment ilike '%User requested manual verification (during step 2)'")
bsw/jbe@1309: elseif mode == "pin_sent" then
bsw/jbe@1309:   title = _"PIN code not entered"
bsw/jbe@1309:   verifications_selector:add_where("comment ilike '% sent'")
bsw/jbe@1309: elseif mode == "fiscal_code" then
bsw/jbe@1309:   title = _"Fiscal code does not match"
bsw/jbe@1309:   verifications_selector:add_where("comment similar to '%fiscal code does not match[^/]*'")
bsw/jbe@1309: elseif mode == "mobile_phone" then
bsw/jbe@1309:   title = _"Phone number used before"
bsw/jbe@1309:   verifications_selector:add_where("comment ilike '%mobile phone number already used before'")
bsw/jbe@1309: elseif mode == "identification" then
bsw/jbe@1309:   title = _"Identification used before"
bsw/jbe@1309:   verifications_selector:add_where("comment ilike '%user with same name already exist'")
bsw/jbe@1309: elseif mode == "invalid_pin" then
bsw/jbe@1309:   title = _"Invalid PIN entered"
bsw/jbe@1309:   verifications_selector:add_where("comment ilike '%user entered invalid PIN three times'")
bsw/jbe@1309: elseif mode == "same_name_already_exists" then
bsw/jbe@1309:   title = _"Same name already exists"
bsw/jbe@1309:   verifications_selector:add_where("comment ilike '%user with same name already exists'")
bsw/jbe@1309: elseif mode == "other" then
bsw/jbe@1309:   title = _"Other reasons"
bsw@1323:   verifications_selector:add_where("not comment ilike '%User requested manual verification (during step 1)'")
bsw@1323:   verifications_selector:add_where("not comment ilike '%User requested manual verification (during step 2)'")
bsw/jbe@1309:   verifications_selector:add_where("not comment ilike '%User requested manual verification'")
bsw/jbe@1309:   verifications_selector:add_where("not comment ilike '% sent'")
bsw/jbe@1309:   verifications_selector:add_where("not comment similar to '%fiscal code does not match[^/]*'")
bsw/jbe@1309:   verifications_selector:add_where("not comment ilike '%mobile phone number already used before'")
bsw/jbe@1309:   verifications_selector:add_where("not comment ilike '%user with same name already exist'")
bsw/jbe@1309:   verifications_selector:add_where("not comment ilike '%user entered invalid PIN three times'")
bsw/jbe@1309:   verifications_selector:add_where("not comment ilike '%user with same name already exists'")
bsw/jbe@1309: end
bsw/jbe@1309: 
bsw/jbe@1309: local verifications = verifications_selector:exec()
bsw/jbe@1309:   
bsw/jbe@1309: 
bsw/jbe@1309: ui.title(function()
bsw@1326:   ui.link { module = "registration_admin", view = "index", content = _"User management" }
bsw/jbe@1309:   slot.put ( " » " )
bsw/jbe@1309:   ui.tag { tag = "span", content = _"Open requests" }
bsw/jbe@1309: end)
bsw/jbe@1309: 
bsw@1326: app.html_title.title = _"User management"
bsw/jbe@1309: 
bsw/jbe@1309: ui.container{ attr = { class = "mdl-grid" }, content = function()
bsw/jbe@1309:   ui.container{ attr = { class = "mdl-cell mdl-cell--12-col" }, content = function()
bsw/jbe@1309: 
bsw/jbe@1309:     ui.container{ attr = { class = "mdl-card mdl-card__fullwidth mdl-shadow--2dp" }, content = function()
bsw/jbe@1309:       ui.container{ attr = { class = "mdl-card__title mdl-card--border" }, content = function()
bsw/jbe@1309:         ui.heading { attr = { class = "mdl-card__title-text" }, level = 2, content = function()
bsw/jbe@1309:           ui.tag{ content = title }
bsw/jbe@1309:         end }
bsw/jbe@1309:       end }
bsw/jbe@1309: 
bsw/jbe@1309:       ui.container{ attr = { class = "mdl-card__content mdl-card--border" }, content = function()
bsw/jbe@1309: 
bsw/jbe@1309:         if #verifications > 0 then
bsw/jbe@1309:           execute.view{ module = "registration_admin", view = "_verification_list", params = { verifications = verifications } }
bsw/jbe@1309:         end
bsw/jbe@1309:       
bsw/jbe@1309:       end }
bsw/jbe@1309:     end }
bsw/jbe@1309: 
bsw/jbe@1309:   end }
bsw/jbe@1309: end }
bsw/jbe@1309: