| rev |
line source |
|
bsw/jbe@1309
|
1 local verification = Verification:by_id(param.get_id())
|
|
bsw/jbe@1309
|
2
|
|
bsw/jbe@1309
|
3 local function update_data()
|
|
bsw@1356
|
4 local old_verification_data = verification.verification_data or {}
|
|
bsw/jbe@1309
|
5 verification.verification_data = json.object()
|
|
bsw/jbe@1309
|
6
|
|
bsw/jbe@1309
|
7 for i, field in ipairs(config.self_registration.fields) do
|
|
bsw/jbe@1309
|
8 local value = param.get(field.name)
|
|
bsw/jbe@1309
|
9 if field.name == "fiscal_code" then
|
|
bsw/jbe@1309
|
10 value = string.gsub(value, "[^A-Z0-9]", "")
|
|
bsw/jbe@1309
|
11 elseif field.name == "mobile_phone" then
|
|
bsw/jbe@1309
|
12 value = string.gsub(value, "[^0-9]", "")
|
|
bsw@1352
|
13 elseif field.name == "unit" then
|
|
bsw@1352
|
14 value = string.gsub(value, "[^0-9]", "")
|
|
bsw@1356
|
15 if old_verification_data.unit and old_verification_data.unit ~= "" then
|
|
bsw@1366
|
16 local old_unit_privilege = Privilege:by_pk(old_verification_data.unit, verification.requesting_member_id)
|
|
bsw@1357
|
17 if old_unit_privilege then
|
|
bsw@1357
|
18 old_unit_privilege:destroy()
|
|
bsw@1357
|
19 end
|
|
bsw@1356
|
20 end
|
|
bsw@1356
|
21 if value ~= old_verification_data.unit and value ~= "" then
|
|
bsw@1353
|
22 local unit_privilege = Privilege:new()
|
|
bsw@1366
|
23 unit_privilege.member_id = verification.requesting_member_id
|
|
bsw@1355
|
24 unit_privilege.unit_id = tonumber(value)
|
|
bsw@1352
|
25 unit_privilege.voting_right = true
|
|
bsw@1352
|
26 unit_privilege.initiative_right = true
|
|
bsw@1354
|
27 unit_privilege:save()
|
|
bsw@1352
|
28 end
|
|
bsw@1359
|
29 elseif field.name == "sequential_number" then
|
|
bsw@1359
|
30 value = old_verification_data.sequential_number
|
|
bsw@1362
|
31 if not value then
|
|
bsw@1362
|
32 local last_sequential_number = 0
|
|
bsw@1362
|
33 db:query('LOCK TABLE "verification" IN SHARE ROW EXCLUSIVE MODE')
|
|
bsw@1364
|
34 local record = Verification:new_selector()
|
|
bsw@1362
|
35 :reset_fields()
|
|
bsw@1364
|
36 :add_field("max((verification_data->>'sequential_number')::int8)", "max_sequential_number")
|
|
bsw@1362
|
37 :optional_object_mode()
|
|
bsw@1362
|
38 :exec()
|
|
bsw@1365
|
39 if record and record.max_sequential_number then
|
|
bsw@1364
|
40 last_sequential_number = record.max_sequential_number
|
|
bsw@1362
|
41 end
|
|
bsw@1362
|
42 value = last_sequential_number + 1
|
|
bsw@1362
|
43 end
|
|
bsw@1363
|
44 elseif field.type ~= "image" then
|
|
bsw@1363
|
45 value = string.gsub(value, "^%s+", "")
|
|
bsw@1363
|
46 value = string.gsub(value, "%s+$", "")
|
|
bsw@1363
|
47 value = string.gsub(value, "%s+", " ")
|
|
bsw/jbe@1309
|
48 end
|
|
bsw/jbe@1309
|
49 verification.verification_data[field.name] = value
|
|
bsw/jbe@1309
|
50 end
|
|
bsw/jbe@1309
|
51 end
|
|
bsw/jbe@1309
|
52
|
|
bsw/jbe@1309
|
53 if verification.verified_member_id then
|
|
bsw/jbe@1309
|
54
|
|
bsw/jbe@1309
|
55 local member = Member:by_id(verification.verified_member_id)
|
|
bsw/jbe@1309
|
56
|
|
bsw/jbe@1309
|
57 if param.get("cancel") then
|
|
bsw/jbe@1309
|
58 db:query({ "SELECT delete_member(?)", member.id })
|
|
bsw/jbe@1309
|
59 return
|
|
bsw/jbe@1309
|
60 end
|
|
bsw/jbe@1309
|
61
|
|
bsw/jbe@1309
|
62 member.identification = param.get("identification")
|
|
bsw/jbe@1309
|
63 member.notify_email = param.get("email")
|
|
bsw/jbe@1309
|
64 member:save()
|
|
bsw/jbe@1309
|
65
|
|
bsw/jbe@1309
|
66 update_data()
|
|
bsw/jbe@1309
|
67
|
|
bsw/jbe@1309
|
68 verification:save()
|
|
bsw/jbe@1309
|
69
|
|
bsw/jbe@1309
|
70 if param.get("invite") then
|
|
bsw/jbe@1309
|
71 member:send_invitation()
|
|
bsw/jbe@1309
|
72 end
|
|
bsw/jbe@1309
|
73
|
|
bsw/jbe@1309
|
74 elseif param.get("drop") then
|
|
bsw/jbe@1309
|
75
|
|
bsw/jbe@1309
|
76 verification.denied = "now"
|
|
bsw/jbe@1309
|
77 verification:save()
|
|
bsw/jbe@1309
|
78 return
|
|
bsw/jbe@1309
|
79
|
|
bsw/jbe@1309
|
80 elseif param.get("accredit") then
|
|
bsw/jbe@1309
|
81
|
|
bsw/jbe@1309
|
82 local member = Member:by_id(verification.requesting_member_id)
|
|
bsw/jbe@1309
|
83 member.identification = param.get("identification")
|
|
bsw/jbe@1309
|
84 member.notify_email = param.get("email")
|
|
bsw/jbe@1309
|
85 member:save()
|
|
bsw@1490
|
86
|
|
bsw@1490
|
87 if config.self_registration.manual_invitation then
|
|
bsw@1490
|
88 local function secret_token()
|
|
bsw@1490
|
89 local parts = {}
|
|
bsw@1490
|
90 for i = 1, 5 do
|
|
bsw@1490
|
91 parts[#parts+1] = multirand.string(5, "23456789bcdfghjkmnpqrstvwxyz")
|
|
bsw@1490
|
92 end
|
|
bsw@1490
|
93 return (table.concat(parts, "-"))
|
|
bsw@1490
|
94 end
|
|
bsw@1490
|
95 member.invite_code = secret_token()
|
|
bsw@1490
|
96 member:save()
|
|
bsw@1490
|
97 else
|
|
bsw@1490
|
98 member:send_invitation()
|
|
bsw@1490
|
99 end
|
|
bsw/jbe@1309
|
100
|
|
bsw/jbe@1309
|
101 for i, unit_id in ipairs(config.self_registration.grant_privileges_for_unit_ids) do
|
|
bsw/jbe@1309
|
102 local privilege = Privilege:new()
|
|
bsw/jbe@1309
|
103 privilege.member_id = member.id
|
|
bsw/jbe@1309
|
104 privilege.unit_id = unit_id
|
|
bsw/jbe@1309
|
105 privilege.initiative_right = true
|
|
bsw/jbe@1309
|
106 privilege.voting_right = true
|
|
bsw/jbe@1309
|
107 privilege:save()
|
|
bsw/jbe@1309
|
108 end
|
|
bsw/jbe@1309
|
109
|
|
bsw/jbe@1309
|
110 update_data()
|
|
bsw/jbe@1309
|
111
|
|
bsw/jbe@1309
|
112 verification.verified_member_id = verification.requesting_member_id
|
|
bsw/jbe@1309
|
113 verification.verifying_member_id = app.session.member_id
|
|
bsw/jbe@1309
|
114 verification.verified = "now"
|
|
bsw/jbe@1309
|
115
|
|
bsw/jbe@1309
|
116 verification:save()
|
|
bsw/jbe@1309
|
117
|
|
bsw/jbe@1309
|
118
|
|
bsw/jbe@1309
|
119 else
|
|
bsw/jbe@1309
|
120
|
|
bsw/jbe@1309
|
121 update_data()
|
|
bsw/jbe@1309
|
122 verification:save()
|
|
bsw/jbe@1309
|
123
|
|
bsw/jbe@1309
|
124 end
|