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 (during step 1)'")

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

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

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

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

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

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

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

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

46 end

47

48 local verifications = verifications_selector:exec()

49

50

51 ui.title(function()

52 ui.link { module = "registration_admin", view = "index", content = _"User management" }

53 slot.put ( " » " )

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

55 end)

56

57 app.html_title.title = _"User management"

58

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

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

61

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

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

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

65 ui.tag{ content = title }

66 end }

67 end }

68

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

70

71 if #verifications > 0 then

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

73 end

74

75 end }

76 end }

77

78 end }

79 end }

80