| rev | line source | 
| bsw/jbe@1309 | 1 local mode = param.get("mode") | 
| bsw/jbe@1309 | 2 local step = param.get("step", atom.integer) | 
| bsw/jbe@1309 | 3 | 
| bsw/jbe@1309 | 4 local verifications_selector = Verification:new_selector() | 
| bsw/jbe@1309 | 5   :add_where("verified_member_id ISNULL") | 
| bsw/jbe@1309 | 6   :add_where("denied ISNULL") | 
| bsw/jbe@1309 | 7   :add_order_by("requested DESC") | 
| bsw/jbe@1309 | 8 | 
| bsw/jbe@1309 | 9 local title = _"Open requests" | 
| bsw/jbe@1309 | 10 | 
| bsw/jbe@1309 | 11 if mode == "manual_requested" and step == 1 then | 
| bsw/jbe@1309 | 12   title = _"Manual verification requested during step 1" | 
| bsw/jbe@1309 | 13   verifications_selector:add_where("comment ilike '%User requested manual verification (during step 1)'") | 
| bsw/jbe@1309 | 14 elseif mode == "manual_requested" and step == 2 then | 
| bsw/jbe@1309 | 15   title = _"Manual verification requested during step 2" | 
| bsw/jbe@1309 | 16   verifications_selector:add_where("comment ilike '%User requested manual verification (during step 2)'") | 
| bsw/jbe@1309 | 17 elseif mode == "pin_sent" then | 
| bsw/jbe@1309 | 18   title = _"PIN code not entered" | 
| bsw/jbe@1309 | 19   verifications_selector:add_where("comment ilike '% sent'") | 
| bsw/jbe@1309 | 20 elseif mode == "fiscal_code" then | 
| bsw/jbe@1309 | 21   title = _"Fiscal code does not match" | 
| bsw/jbe@1309 | 22   verifications_selector:add_where("comment similar to '%fiscal code does not match[^/]*'") | 
| bsw/jbe@1309 | 23 elseif mode == "mobile_phone" then | 
| bsw/jbe@1309 | 24   title = _"Phone number used before" | 
| bsw/jbe@1309 | 25   verifications_selector:add_where("comment ilike '%mobile phone number already used before'") | 
| bsw/jbe@1309 | 26 elseif mode == "identification" then | 
| bsw/jbe@1309 | 27   title = _"Identification used before" | 
| bsw/jbe@1309 | 28   verifications_selector:add_where("comment ilike '%user with same name already exist'") | 
| bsw/jbe@1309 | 29 elseif mode == "invalid_pin" then | 
| bsw/jbe@1309 | 30   title = _"Invalid PIN entered" | 
| bsw/jbe@1309 | 31   verifications_selector:add_where("comment ilike '%user entered invalid PIN three times'") | 
| bsw/jbe@1309 | 32 elseif mode == "same_name_already_exists" then | 
| bsw/jbe@1309 | 33   title = _"Same name already exists" | 
| bsw/jbe@1309 | 34   verifications_selector:add_where("comment ilike '%user with same name already exists'") | 
| bsw/jbe@1309 | 35 elseif mode == "other" then | 
| bsw/jbe@1309 | 36   title = _"Other reasons" | 
| bsw@1323 | 37   verifications_selector:add_where("not comment ilike '%User requested manual verification (during step 1)'") | 
| bsw@1323 | 38   verifications_selector:add_where("not comment ilike '%User requested manual verification (during step 2)'") | 
| bsw/jbe@1309 | 39   verifications_selector:add_where("not comment ilike '%User requested manual verification'") | 
| bsw/jbe@1309 | 40   verifications_selector:add_where("not comment ilike '% sent'") | 
| bsw/jbe@1309 | 41   verifications_selector:add_where("not comment similar to '%fiscal code does not match[^/]*'") | 
| bsw/jbe@1309 | 42   verifications_selector:add_where("not comment ilike '%mobile phone number already used before'") | 
| bsw/jbe@1309 | 43   verifications_selector:add_where("not comment ilike '%user with same name already exist'") | 
| bsw/jbe@1309 | 44   verifications_selector:add_where("not comment ilike '%user entered invalid PIN three times'") | 
| bsw/jbe@1309 | 45   verifications_selector:add_where("not comment ilike '%user with same name already exists'") | 
| bsw/jbe@1309 | 46 end | 
| bsw/jbe@1309 | 47 | 
| bsw/jbe@1309 | 48 local verifications = verifications_selector:exec() | 
| bsw/jbe@1309 | 49 | 
| bsw/jbe@1309 | 50 | 
| bsw/jbe@1309 | 51 ui.title(function() | 
| bsw@1326 | 52   ui.link { module = "registration_admin", view = "index", content = _"User management" } | 
| bsw/jbe@1309 | 53   slot.put ( " ยป " ) | 
| bsw/jbe@1309 | 54   ui.tag { tag = "span", content = _"Open requests" } | 
| bsw/jbe@1309 | 55 end) | 
| bsw/jbe@1309 | 56 | 
| bsw@1326 | 57 app.html_title.title = _"User management" | 
| bsw/jbe@1309 | 58 | 
| bsw/jbe@1309 | 59 ui.container{ attr = { class = "mdl-grid" }, content = function() | 
| bsw/jbe@1309 | 60   ui.container{ attr = { class = "mdl-cell mdl-cell--12-col" }, content = function() | 
| bsw/jbe@1309 | 61 | 
| bsw/jbe@1309 | 62     ui.container{ attr = { class = "mdl-card mdl-card__fullwidth mdl-shadow--2dp" }, content = function() | 
| bsw/jbe@1309 | 63       ui.container{ attr = { class = "mdl-card__title mdl-card--border" }, content = function() | 
| bsw/jbe@1309 | 64         ui.heading { attr = { class = "mdl-card__title-text" }, level = 2, content = function() | 
| bsw/jbe@1309 | 65           ui.tag{ content = title } | 
| bsw/jbe@1309 | 66         end } | 
| bsw/jbe@1309 | 67       end } | 
| bsw/jbe@1309 | 68 | 
| bsw/jbe@1309 | 69       ui.container{ attr = { class = "mdl-card__content mdl-card--border" }, content = function() | 
| bsw/jbe@1309 | 70 | 
| bsw/jbe@1309 | 71         if #verifications > 0 then | 
| bsw/jbe@1309 | 72           execute.view{ module = "registration_admin", view = "_verification_list", params = { verifications = verifications } } | 
| bsw/jbe@1309 | 73         end | 
| bsw/jbe@1309 | 74 | 
| bsw/jbe@1309 | 75       end } | 
| bsw/jbe@1309 | 76     end } | 
| bsw/jbe@1309 | 77 | 
| bsw/jbe@1309 | 78   end } | 
| bsw/jbe@1309 | 79 end } | 
| bsw/jbe@1309 | 80 |