liquid_feedback_frontend

annotate app/main/registration_admin/_action/update_verification.lua @ 1810:0a243b9aac6b

find changesets by author, revision, files, or words in the commit message
Added missing local statement
author bsw
date Thu Dec 02 13:22:15 2021 +0100 (2021-12-02)
parents 5425f77466ec
children c8fe2498a1af
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@1690 15 if old_verification_data.unit and old_verification_data.unit ~= "" and old_verification_data.unit ~= value 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@1810 62 local identification = param.get("identification")
bsw@1809 63 if identification and #identification == 0 then
bsw@1809 64 identification = nil
bsw@1809 65 end
bsw@1809 66 member.identification = identification
bsw@1809 67
bsw/jbe@1309 68 member.notify_email = param.get("email")
bsw/jbe@1309 69 member:save()
bsw/jbe@1309 70
bsw/jbe@1309 71 update_data()
bsw/jbe@1309 72
bsw/jbe@1309 73 verification:save()
bsw/jbe@1309 74
bsw/jbe@1309 75 if param.get("invite") then
bsw/jbe@1309 76 member:send_invitation()
bsw/jbe@1309 77 end
bsw/jbe@1309 78
bsw/jbe@1309 79 elseif param.get("drop") then
bsw/jbe@1309 80
bsw/jbe@1309 81 verification.denied = "now"
bsw/jbe@1309 82 verification:save()
bsw/jbe@1309 83 return
bsw/jbe@1309 84
bsw/jbe@1309 85 elseif param.get("accredit") then
bsw/jbe@1309 86
bsw/jbe@1309 87 local member = Member:by_id(verification.requesting_member_id)
bsw/jbe@1309 88 member.identification = param.get("identification")
bsw/jbe@1309 89 member.notify_email = param.get("email")
bsw/jbe@1309 90 member:save()
bsw@1490 91
bsw@1490 92 if config.self_registration.manual_invitation then
bsw@1490 93 local function secret_token()
bsw@1490 94 local parts = {}
bsw@1490 95 for i = 1, 5 do
bsw@1490 96 parts[#parts+1] = multirand.string(5, "23456789bcdfghjkmnpqrstvwxyz")
bsw@1490 97 end
bsw@1490 98 return (table.concat(parts, "-"))
bsw@1490 99 end
bsw@1490 100 member.invite_code = secret_token()
bsw@1490 101 member:save()
bsw@1490 102 else
bsw@1490 103 member:send_invitation()
bsw@1490 104 end
bsw/jbe@1309 105
bsw/jbe@1309 106 for i, unit_id in ipairs(config.self_registration.grant_privileges_for_unit_ids) do
bsw/jbe@1309 107 local privilege = Privilege:new()
bsw/jbe@1309 108 privilege.member_id = member.id
bsw/jbe@1309 109 privilege.unit_id = unit_id
bsw/jbe@1309 110 privilege.initiative_right = true
bsw/jbe@1309 111 privilege.voting_right = true
bsw/jbe@1309 112 privilege:save()
bsw/jbe@1309 113 end
bsw/jbe@1309 114
bsw/jbe@1309 115 update_data()
bsw/jbe@1309 116
bsw/jbe@1309 117 verification.verified_member_id = verification.requesting_member_id
bsw/jbe@1309 118 verification.verifying_member_id = app.session.member_id
bsw/jbe@1309 119 verification.verified = "now"
bsw/jbe@1309 120
bsw/jbe@1309 121 verification:save()
bsw/jbe@1309 122
bsw/jbe@1309 123
bsw/jbe@1309 124 else
bsw/jbe@1309 125
bsw/jbe@1309 126 update_data()
bsw/jbe@1309 127 verification:save()
bsw/jbe@1309 128
bsw/jbe@1309 129 end

Impressum / About Us