liquid_feedback_frontend

annotate app/main/registration_admin/_action/update_verification.lua @ 1814:8f431f4cc87f

find changesets by author, revision, files, or words in the commit message
Fixed syntax
author bsw
date Thu Dec 02 13:34:22 2021 +0100 (2021-12-02)
parents f9f3a657d348
children 6246f8249f9f
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@1814 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@1813 102
bsw@1813 103 local identification = param.get("identification")
bsw@1813 104 if identification and #identification == 0 then
bsw@1813 105 identification = nil
bsw@1813 106 end
bsw@1813 107 member.identification = identification
bsw@1813 108
bsw/jbe@1309 109 member.notify_email = param.get("email")
bsw@1812 110 check_db_error(member:try_save())
bsw@1490 111
bsw@1490 112 if config.self_registration.manual_invitation then
bsw@1490 113 local function secret_token()
bsw@1490 114 local parts = {}
bsw@1490 115 for i = 1, 5 do
bsw@1490 116 parts[#parts+1] = multirand.string(5, "23456789bcdfghjkmnpqrstvwxyz")
bsw@1490 117 end
bsw@1490 118 return (table.concat(parts, "-"))
bsw@1490 119 end
bsw@1490 120 member.invite_code = secret_token()
bsw@1490 121 member:save()
bsw@1490 122 else
bsw@1490 123 member:send_invitation()
bsw@1490 124 end
bsw/jbe@1309 125
bsw/jbe@1309 126 for i, unit_id in ipairs(config.self_registration.grant_privileges_for_unit_ids) do
bsw/jbe@1309 127 local privilege = Privilege:new()
bsw/jbe@1309 128 privilege.member_id = member.id
bsw/jbe@1309 129 privilege.unit_id = unit_id
bsw/jbe@1309 130 privilege.initiative_right = true
bsw/jbe@1309 131 privilege.voting_right = true
bsw/jbe@1309 132 privilege:save()
bsw/jbe@1309 133 end
bsw/jbe@1309 134
bsw/jbe@1309 135 update_data()
bsw/jbe@1309 136
bsw/jbe@1309 137 verification.verified_member_id = verification.requesting_member_id
bsw/jbe@1309 138 verification.verifying_member_id = app.session.member_id
bsw/jbe@1309 139 verification.verified = "now"
bsw/jbe@1309 140
bsw/jbe@1309 141 verification:save()
bsw/jbe@1309 142
bsw/jbe@1309 143
bsw/jbe@1309 144 else
bsw/jbe@1309 145
bsw/jbe@1309 146 update_data()
bsw/jbe@1309 147 verification:save()
bsw/jbe@1309 148
bsw/jbe@1309 149 end

Impressum / About Us