| 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 
 |