liquid_feedback_frontend

annotate app/main/registration_admin/_action/update_verification.lua @ 1812:fc3f15316a68

find changesets by author, revision, files, or words in the commit message
Better error handling also for creating new accounts
author bsw
date Thu Dec 02 13:33:05 2021 +0100 (2021-12-02)
parents c8fe2498a1af
children f9f3a657d348
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@1812 53 local function check_db_error(db_error)
bsw@1812 54 if db_error then
bsw@1812 55 if db_error.is_kind_of("IntegrityConstraintViolation.UniqueViolation") then
bsw@1812 56 slot.select("error", function()
bsw@1812 57 ui.tag{ content = _"Identification unique violation: This identification is already in use for another member." }
bsw@1812 58 end )
bsw@1812 59 return false
bsw@1812 60 else
bsw@1812 61 error(db_error)
bsw@1812 62 end
bsw@1812 63 end
bsw@1812 64 end
bsw@1812 65
bsw/jbe@1309 66 if verification.verified_member_id then
bsw/jbe@1309 67
bsw/jbe@1309 68 local member = Member:by_id(verification.verified_member_id)
bsw/jbe@1309 69
bsw/jbe@1309 70 if param.get("cancel") then
bsw/jbe@1309 71 db:query({ "SELECT delete_member(?)", member.id })
bsw/jbe@1309 72 return
bsw/jbe@1309 73 end
bsw/jbe@1309 74
bsw@1810 75 local identification = param.get("identification")
bsw@1809 76 if identification and #identification == 0 then
bsw@1809 77 identification = nil
bsw@1809 78 end
bsw@1809 79 member.identification = identification
bsw@1809 80
bsw/jbe@1309 81 member.notify_email = param.get("email")
bsw@1812 82
bsw@1812 83 check_db_error(member:try_save())
bsw@1812 84
bsw/jbe@1309 85 update_data()
bsw@1812 86
bsw/jbe@1309 87 verification:save()
bsw/jbe@1309 88
bsw/jbe@1309 89 if param.get("invite") then
bsw/jbe@1309 90 member:send_invitation()
bsw/jbe@1309 91 end
bsw/jbe@1309 92
bsw/jbe@1309 93 elseif param.get("drop") then
bsw/jbe@1309 94
bsw/jbe@1309 95 verification.denied = "now"
bsw/jbe@1309 96 verification:save()
bsw/jbe@1309 97 return
bsw/jbe@1309 98
bsw/jbe@1309 99 elseif param.get("accredit") then
bsw/jbe@1309 100
bsw/jbe@1309 101 local member = Member:by_id(verification.requesting_member_id)
bsw/jbe@1309 102 member.identification = param.get("identification")
bsw/jbe@1309 103 member.notify_email = param.get("email")
bsw@1812 104 check_db_error(member:try_save())
bsw@1490 105
bsw@1490 106 if config.self_registration.manual_invitation then
bsw@1490 107 local function secret_token()
bsw@1490 108 local parts = {}
bsw@1490 109 for i = 1, 5 do
bsw@1490 110 parts[#parts+1] = multirand.string(5, "23456789bcdfghjkmnpqrstvwxyz")
bsw@1490 111 end
bsw@1490 112 return (table.concat(parts, "-"))
bsw@1490 113 end
bsw@1490 114 member.invite_code = secret_token()
bsw@1490 115 member:save()
bsw@1490 116 else
bsw@1490 117 member:send_invitation()
bsw@1490 118 end
bsw/jbe@1309 119
bsw/jbe@1309 120 for i, unit_id in ipairs(config.self_registration.grant_privileges_for_unit_ids) do
bsw/jbe@1309 121 local privilege = Privilege:new()
bsw/jbe@1309 122 privilege.member_id = member.id
bsw/jbe@1309 123 privilege.unit_id = unit_id
bsw/jbe@1309 124 privilege.initiative_right = true
bsw/jbe@1309 125 privilege.voting_right = true
bsw/jbe@1309 126 privilege:save()
bsw/jbe@1309 127 end
bsw/jbe@1309 128
bsw/jbe@1309 129 update_data()
bsw/jbe@1309 130
bsw/jbe@1309 131 verification.verified_member_id = verification.requesting_member_id
bsw/jbe@1309 132 verification.verifying_member_id = app.session.member_id
bsw/jbe@1309 133 verification.verified = "now"
bsw/jbe@1309 134
bsw/jbe@1309 135 verification:save()
bsw/jbe@1309 136
bsw/jbe@1309 137
bsw/jbe@1309 138 else
bsw/jbe@1309 139
bsw/jbe@1309 140 update_data()
bsw/jbe@1309 141 verification:save()
bsw/jbe@1309 142
bsw/jbe@1309 143 end

Impressum / About Us