liquid_feedback_frontend

annotate app/main/registration_admin/_action/update_verification.lua @ 1811:c8fe2498a1af

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

Impressum / About Us