liquid_feedback_frontend

changeset 1818:2d4136357989

Final version of survey
author bsw
date Tue Jan 04 14:31:01 2022 +0100 (2022-01-04)
parents 757a87af4c83
children 85ca5a7e46ec
files app/main/survey/_action/participate.lua db/survey.sql
line diff
     1.1 --- a/app/main/survey/_action/participate.lua	Mon Dec 13 11:57:35 2021 +0100
     1.2 +++ b/app/main/survey/_action/participate.lua	Tue Jan 04 14:31:01 2022 +0100
     1.3 @@ -40,6 +40,15 @@
     1.4    local answer_set = SurveyAnswerSet:new()
     1.5    answer_set.ident = random_string()
     1.6    answer_set.survey_id = survey.id
     1.7 +  local verification = Verification:new_selector()
     1.8 +    :add_where{ "verified_member_id = ?", app.session.member_id }
     1.9 +    :optional_object_mode()
    1.10 +    :exec()
    1.11 +  if verification then
    1.12 +    answer_set.data = verification.request_data
    1.13 +    answer_set.data.name = nil
    1.14 +    answer_set.data.email = nil
    1.15 +  end
    1.16    answer_set:save()
    1.17    survey_member.survey_answer_set_ident = answer_set.ident
    1.18  end
     2.1 --- a/db/survey.sql	Mon Dec 13 11:57:35 2021 +0100
     2.2 +++ b/db/survey.sql	Tue Jan 04 14:31:01 2022 +0100
     2.3 @@ -21,7 +21,8 @@
     2.4  
     2.5  CREATE TABLE survey_answer_set (
     2.6    ident TEXT NOT NULL PRIMARY KEY,
     2.7 -  survey_id INT4 NOT NULL REFERENCES survey(id)
     2.8 +  survey_id INT4 NOT NULL REFERENCES survey(id),
     2.9 +  data JSON
    2.10  );
    2.11  
    2.12  CREATE TABLE survey_answer (

Impressum / About Us