1 local verification = Verification:by_id(param.get_id())

2

3 local function update_data()

4 local old_verification_data = verification.verification_data or {}

5 verification.verification_data = json.object()

6

7 for i, field in ipairs(config.self_registration.fields) do

8 local value = param.get(field.name)

9 if field.name == "fiscal_code" then

10 value = string.gsub(value, "[^A-Z0-9]", "")

11 elseif field.name == "mobile_phone" then

12 value = string.gsub(value, "[^0-9]", "")

13 elseif field.name == "unit" then

14 value = string.gsub(value, "[^0-9]", "")

15 if old_verification_data.unit and old_verification_data.unit ~= "" then

16 local old_unit_privilege = Privilege:by_pk(old_verification_data.unit, verification.verified_member_id)

17 if old_unit_privilege then

18 old_unit_privilege:destroy()

19 end

20 end

21 if value ~= old_verification_data.unit and value ~= "" then

22 local unit_privilege = Privilege:new()

23 unit_privilege.member_id = verification.verified_member_id

24 unit_privilege.unit_id = tonumber(value)

25 unit_privilege.voting_right = true

26 unit_privilege.initiative_right = true

27 unit_privilege:save()

28 end

29 elseif field.type ~= "image" then

30 value = string.gsub(value, "^%s+", "")

31 value = string.gsub(value, "%s+$", "")

32 value = string.gsub(value, "%s+", " ")

33 elseif field.name == "sequential_number" then

34 value = old_verification_data.sequential_number

35 end

36 verification.verification_data[field.name] = value

37 end

38 end

39

40 if verification.verified_member_id then

41

42 local member = Member:by_id(verification.verified_member_id)

43

44 if param.get("cancel") then

45 db:query({ "SELECT delete_member(?)", member.id })

46 return

47 end

48

49 member.identification = param.get("identification")

50 member.notify_email = param.get("email")

51 member:save()

52

53 update_data()

54

55 verification:save()

56

57 if param.get("invite") then

58 member:send_invitation()

59 end

60

61 elseif param.get("drop") then

62

63 verification.denied = "now"

64 verification:save()

65 return

66

67 elseif param.get("accredit") then

68

69 local member = Member:by_id(verification.requesting_member_id)

70 member.identification = param.get("identification")

71 member.notify_email = param.get("email")

72 member:save()

73 member:send_invitation()

74

75 for i, unit_id in ipairs(config.self_registration.grant_privileges_for_unit_ids) do

76 local privilege = Privilege:new()

77 privilege.member_id = member.id

78 privilege.unit_id = unit_id

79 privilege.initiative_right = true

80 privilege.voting_right = true

81 privilege:save()

82 end

83

84 update_data()

85

86 verification.verified_member_id = verification.requesting_member_id

87 verification.verifying_member_id = app.session.member_id

88 verification.verified = "now"

89

90 verification:save()

91

92

93 else

94

95 update_data()

96 verification:save()

97

98 end