1 local mode = param.get("mode")

2 local step = param.get("step", atom.integer)

3

4 local verifications_selector = Verification:new_selector()

5 :add_where("verified_member_id ISNULL")

6 :add_where("denied ISNULL")

7 :add_order_by("requested DESC")

8

9 local title = _"Open requests"

10

11 if mode == "manual_requested" and step == 1 then

12 title = _"Manual verification requested during step 1"

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

14 elseif mode == "manual_requested" and step == 2 then

15 title = _"Manual verification requested during step 2"

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

17 elseif mode == "pin_sent" then

18 title = _"PIN code not entered"

19 verifications_selector:add_where("comment ilike '% sent'")

20 elseif mode == "fiscal_code" then

21 title = _"Fiscal code does not match"

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

23 elseif mode == "mobile_phone" then

24 title = _"Phone number used before"

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

26 elseif mode == "identification" then

27 title = _"Identification used before"

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

29 elseif mode == "invalid_pin" then

30 title = _"Invalid PIN entered"

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

32 elseif mode == "same_name_already_exists" then

33 title = _"Same name already exists"

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

35 elseif mode == "other" then

36 title = _"Other reasons"

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

38 verifications_selector:add_where("not comment ilike '% sent'")

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

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

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

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

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

44 end

45

46 local verifications = verifications_selector:exec()

47

48

49 ui.title(function()

50 ui.link { module = "registration_admin", view = "index", content = _"Usermanagement" }

51 slot.put ( " » " )

52 ui.tag { tag = "span", content = _"Open requests" }

53 end)

54

55 app.html_title.title = _"Usermanagement"

56

57 ui.container{ attr = { class = "mdl-grid" }, content = function()

58 ui.container{ attr = { class = "mdl-cell mdl-cell--12-col" }, content = function()

59

60 ui.container{ attr = { class = "mdl-card mdl-card__fullwidth mdl-shadow--2dp" }, content = function()

61 ui.container{ attr = { class = "mdl-card__title mdl-card--border" }, content = function()

62 ui.heading { attr = { class = "mdl-card__title-text" }, level = 2, content = function()

63 ui.tag{ content = title }

64 end }

65 end }

66

67 ui.container{ attr = { class = "mdl-card__content mdl-card--border" }, content = function()

68

69 if #verifications > 0 then

70 execute.view{ module = "registration_admin", view = "_verification_list", params = { verifications = verifications } }

71 end

72

73 end }

74 end }

75

76 end }

77 end }

78