/**
* @package CRM
- * @copyright CiviCRM LLC (c) 2004-2018
+ * @copyright CiviCRM LLC (c) 2004-2019
*
* Generated from xml/schema/CRM/Campaign/Survey.xml
* DO NOT EDIT. Generated by CRM_Core_CodeGen
- * (GenCodeChecksum:bf281972fa5b1efaa8801eb9a47e42ae)
+ * (GenCodeChecksum:ad39991f1177492db1fd47cbaacf676a)
*/
/**
*
* @var string
*/
- static $_tableName = 'civicrm_survey';
+ public static $_tableName = 'civicrm_survey';
/**
* Should CiviCRM log any modifications to this table in the civicrm_log table.
*
* @var bool
*/
- static $_log = FALSE;
+ public static $_log = FALSE;
/**
* Survey id.
*
- * @var int unsigned
+ * @var int
*/
public $id;
/**
* Foreign key to the Campaign.
*
- * @var int unsigned
+ * @var int
*/
public $campaign_id;
/**
* Implicit FK to civicrm_option_value where option_group = activity_type
*
- * @var int unsigned
+ * @var int
*/
public $activity_type_id;
/**
* Number of days for recurrence of release.
*
- * @var int unsigned
+ * @var int
*/
public $release_frequency;
/**
* Maximum number of contacts to allow for survey.
*
- * @var int unsigned
+ * @var int
*/
public $max_number_of_contacts;
/**
* Default number of contacts to allow for survey.
*
- * @var int unsigned
+ * @var int
*/
public $default_number_of_contacts;
/**
* Is this survey enabled or disabled/cancelled?
*
- * @var boolean
+ * @var bool
*/
public $is_active;
/**
* Is this default survey?
*
- * @var boolean
+ * @var bool
*/
public $is_default;
/**
* FK to civicrm_contact, who created this Survey.
*
- * @var int unsigned
+ * @var int
*/
public $created_id;
/**
* FK to civicrm_contact, who recently edited this Survey.
*
- * @var int unsigned
+ * @var int
*/
public $last_modified_id;
/**
* Used to store option group id.
*
- * @var int unsigned
+ * @var int
*/
public $result_id;
/**
* Bypass the email verification.
*
- * @var boolean
+ * @var bool
*/
public $bypass_confirm;
/**
* Can people share the petition through social media?
*
- * @var boolean
+ * @var bool
*/
public $is_share;
*/
public static function getReferenceColumns() {
if (!isset(Civi::$statics[__CLASS__]['links'])) {
- Civi::$statics[__CLASS__]['links'] = static ::createReferenceColumns(__CLASS__);
+ Civi::$statics[__CLASS__]['links'] = static::createReferenceColumns(__CLASS__);
Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'campaign_id', 'civicrm_campaign', 'id');
Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'created_id', 'civicrm_contact', 'id');
Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'last_modified_id', 'civicrm_contact', 'id');
'title' => ts('Survey ID'),
'description' => ts('Survey id.'),
'required' => TRUE,
+ 'where' => 'civicrm_survey.id',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'bao' => 'CRM_Campaign_BAO_Survey',
'size' => CRM_Utils_Type::HUGE,
'import' => TRUE,
'where' => 'civicrm_survey.title',
- 'headerPattern' => '',
- 'dataPattern' => '',
'export' => TRUE,
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Survey Campaign ID'),
'description' => ts('Foreign key to the Campaign.'),
+ 'where' => 'civicrm_survey.campaign_id',
'default' => 'NULL',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'table' => 'civicrm_campaign',
'keyColumn' => 'id',
'labelColumn' => 'title',
- ]
+ ],
],
'activity_type_id' => [
'name' => 'activity_type_id',
'description' => ts('Implicit FK to civicrm_option_value where option_group = activity_type'),
'import' => TRUE,
'where' => 'civicrm_survey.activity_type_id',
- 'headerPattern' => '',
- 'dataPattern' => '',
'export' => TRUE,
'default' => 'NULL',
'table_name' => 'civicrm_survey',
'pseudoconstant' => [
'optionGroupName' => 'activity_type',
'optionEditPath' => 'civicrm/admin/options/activity_type',
- ]
+ ],
],
'recontact_interval' => [
'name' => 'recontact_interval',
'description' => ts('Recontact intervals for each status.'),
'rows' => 20,
'cols' => 80,
+ 'where' => 'civicrm_survey.recontact_interval',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'bao' => 'CRM_Campaign_BAO_Survey',
'description' => ts('Script instructions for volunteers to use for the survey.'),
'rows' => 20,
'cols' => 80,
+ 'where' => 'civicrm_survey.instructions',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'bao' => 'CRM_Campaign_BAO_Survey',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Survey Hold Duration'),
'description' => ts('Number of days for recurrence of release.'),
+ 'where' => 'civicrm_survey.release_frequency',
'default' => 'NULL',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Maximum number of contacts'),
'description' => ts('Maximum number of contacts to allow for survey.'),
+ 'where' => 'civicrm_survey.max_number_of_contacts',
'default' => 'NULL',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Default number of contacts'),
'description' => ts('Default number of contacts to allow for survey.'),
+ 'where' => 'civicrm_survey.default_number_of_contacts',
'default' => 'NULL',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Survey Is Active'),
'description' => ts('Is this survey enabled or disabled/cancelled?'),
+ 'where' => 'civicrm_survey.is_active',
'default' => '1',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Is Default Survey'),
'description' => ts('Is this default survey?'),
+ 'where' => 'civicrm_survey.is_default',
'default' => '0',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Survey Created By'),
'description' => ts('FK to civicrm_contact, who created this Survey.'),
+ 'where' => 'civicrm_survey.created_id',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'bao' => 'CRM_Campaign_BAO_Survey',
'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
'title' => ts('Campaign Created Date'),
'description' => ts('Date and time that Survey was created.'),
+ 'where' => 'civicrm_survey.created_date',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'bao' => 'CRM_Campaign_BAO_Survey',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Survey Modified'),
'description' => ts('FK to civicrm_contact, who recently edited this Survey.'),
+ 'where' => 'civicrm_survey.last_modified_id',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'bao' => 'CRM_Campaign_BAO_Survey',
'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
'title' => ts('Survey Modified On'),
'description' => ts('Date and time that Survey was edited last time.'),
+ 'where' => 'civicrm_survey.last_modified_date',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'bao' => 'CRM_Campaign_BAO_Survey',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Survey Result'),
'description' => ts('Used to store option group id.'),
+ 'where' => 'civicrm_survey.result_id',
'default' => 'NULL',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('No Email Verification'),
'description' => ts('Bypass the email verification.'),
+ 'where' => 'civicrm_survey.bypass_confirm',
'default' => '0',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'description' => ts('Title for Thank-you page (header title tag, and display at the top of the page).'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_survey.thankyou_title',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'bao' => 'CRM_Campaign_BAO_Survey',
'description' => ts('text and html allowed. displayed above result on success page'),
'rows' => 8,
'cols' => 60,
+ 'where' => 'civicrm_survey.thankyou_text',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',
'bao' => 'CRM_Campaign_BAO_Survey',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Is shared through social media'),
'description' => ts('Can people share the petition through social media?'),
+ 'where' => 'civicrm_survey.is_share',
'default' => '1',
'table_name' => 'civicrm_survey',
'entity' => 'Survey',