CiviCampaign - Move serialized contents of civicrm_survey.recontact_interval into...
authorcolemanw <coleman@civicrm.org>
Sun, 3 Sep 2023 02:24:56 +0000 (22:24 -0400)
committercolemanw <coleman@civicrm.org>
Sun, 3 Sep 2023 03:08:05 +0000 (23:08 -0400)
commit43b7eed54611d1b55e2c04ab4bb119178341196b
tree30abc3efa95388b8a059d74efd31f1ea906387df
parent09b811307615fb3e20462436aa63fc56c4f3833c
CiviCampaign - Move serialized contents of civicrm_survey.recontact_interval into civicrm_option_value.filter

Refactors out a thoroughly strange data structure.

Each option value associated with a survey has an associated recontact_interval, which is an integer
storing the number of days before the respondent should be recontacted.

Before: A serialized array was being stored in the survey with keys matching  the option LABEL!

After: There was an unused integer column, civicrm_option_value.filter which works fine for storing
the number directly for each option_value with no messy mapping needed.
CRM/Campaign/BAO/Query.php
CRM/Campaign/DAO/Survey.php
CRM/Campaign/Form/Survey/Main.php
CRM/Campaign/Form/Survey/Results.php
CRM/Campaign/Page/AJAX.php
CRM/Upgrade/Incremental/php/FiveSixtySix.php
xml/schema/Campaign/Survey.xml