is_gravityforms_supported() ) { // Load the MailChimp API library. if ( ! class_exists( 'GF_MailChimp_API' ) ) { require_once( 'includes/class-gf-mailchimp-api.php' ); } } } /** * Plugin starting point. Handles hooks, loading of language files and PayPal delayed payment support. * * @since 3.0 * @access public * * @uses GFFeedAddOn::add_delayed_payment_support() */ public function init() { parent::init(); $this->add_delayed_payment_support( array( 'option_label' => esc_html__( 'Subscribe user to MailChimp only when payment is received.', 'gravityformsmailchimp' ), ) ); } /** * Remove unneeded settings. * * @since 4.0 * @access public */ public function uninstall() { parent::uninstall(); GFCache::delete( 'mailchimp_plugin_settings' ); delete_option( 'gf_mailchimp_settings' ); delete_option( 'gf_mailchimp_version' ); } /** * Register needed styles. * * @since 4.0 * @access public * * @return array */ public function styles() { $styles = array( array( 'handle' => $this->_slug . '_form_settings', 'src' => $this->get_base_url() . '/css/form_settings.css', 'version' => $this->_version, 'enqueue' => array( array( 'admin_page' => array( 'form_settings' ) ), ), ), ); return array_merge( parent::styles(), $styles ); } // # PLUGIN SETTINGS ----------------------------------------------------------------------------------------------- /** * Configures the settings which should be rendered on the add-on settings tab. * * @since 3.0 * @access public * * @return array */ public function plugin_settings_fields() { return array( array( 'description' => '

' . sprintf( esc_html__( 'MailChimp makes it easy to send email newsletters to your customers, manage your subscriber lists, and track campaign performance. Use Gravity Forms to collect customer information and automatically add it to your MailChimp subscriber list. If you don\'t have a MailChimp account, you can %1$ssign up for one here.%2$s', 'gravityformsmailchimp' ), '', '' ) . '

', 'fields' => array( array( 'name' => 'apiKey', 'label' => esc_html__( 'MailChimp API Key', 'gravityformsmailchimp' ), 'type' => 'text', 'class' => 'medium', 'feedback_callback' => array( $this, 'initialize_api' ), ), ), ), ); } // # FEED SETTINGS ------------------------------------------------------------------------------------------------- /** * Configures the settings which should be rendered on the feed edit page. * * @since 3.0 * @access public * * @return array */ public function feed_settings_fields() { return array( array( 'title' => esc_html__( 'MailChimp Feed Settings', 'gravityformsmailchimp' ), 'fields' => array( array( 'name' => 'feedName', 'label' => esc_html__( 'Name', 'gravityformsmailchimp' ), 'type' => 'text', 'required' => true, 'class' => 'medium', 'tooltip' => sprintf( '
%s
%s', esc_html__( 'Name', 'gravityformsmailchimp' ), esc_html__( 'Enter a feed name to uniquely identify this setup.', 'gravityformsmailchimp' ) ), ), array( 'name' => 'mailchimpList', 'label' => esc_html__( 'MailChimp List', 'gravityformsmailchimp' ), 'type' => 'mailchimp_list', 'required' => true, 'tooltip' => sprintf( '
%s
%s', esc_html__( 'MailChimp List', 'gravityformsmailchimp' ), esc_html__( 'Select the MailChimp list you would like to add your contacts to.', 'gravityformsmailchimp' ) ), ), ), ), array( 'dependency' => 'mailchimpList', 'fields' => array( array( 'name' => 'mappedFields', 'label' => esc_html__( 'Map Fields', 'gravityformsmailchimp' ), 'type' => 'field_map', 'field_map' => $this->merge_vars_field_map(), 'tooltip' => sprintf( '
%s
%s', esc_html__( 'Map Fields', 'gravityformsmailchimp' ), esc_html__( 'Associate your MailChimp merge tags to the appropriate Gravity Form fields by selecting the appropriate form field from the list.', 'gravityformsmailchimp' ) ), ), array( 'name' => 'interestCategories', 'label' => esc_html__( 'Groups', 'gravityformsmailchimp' ), 'dependency' => array( $this, 'has_interest_categories' ), 'type' => 'interest_categories', 'tooltip' => sprintf( '
%s
%s', esc_html__( 'Groups', 'gravityformsmailchimp' ), esc_html__( 'When one or more groups are enabled, users will be assigned to the groups in addition to being subscribed to the MailChimp list. When disabled, users will not be assigned to groups.', 'gravityformsmailchimp' ) ), ), array( 'name' => 'options', 'label' => esc_html__( 'Options', 'gravityformsmailchimp' ), 'type' => 'checkbox', 'choices' => array( array( 'name' => 'double_optin', 'label' => esc_html__( 'Double Opt-In', 'gravityformsmailchimp' ), 'default_value' => 1, 'onclick' => 'if(this.checked){jQuery("#mailchimp_doubleoptin_warning").hide();} else{jQuery("#mailchimp_doubleoptin_warning").show();}', 'tooltip' => sprintf( '
%s
%s', esc_html__( 'Double Opt-In', 'gravityformsmailchimp' ), esc_html__( 'When the double opt-in option is enabled, MailChimp will send a confirmation email to the user and will only add them to your MailChimp list upon confirmation.', 'gravityformsmailchimp' ) ), ), array( 'name' => 'markAsVIP', 'label' => esc_html__( 'Mark subscriber as VIP', 'gravityformsmailchimp' ), ), ), ), array( 'name' => 'note', 'type' => 'textarea', 'class' => 'medium merge-tag-support mt-position-right mt-hide_all_fields', 'label' => esc_html__( 'Note', 'gravityformsmailchimp' ), ), array( 'name' => 'optinCondition', 'label' => esc_html__( 'Conditional Logic', 'gravityformsmailchimp' ), 'type' => 'feed_condition', 'tooltip' => sprintf( '
%s
%s', esc_html__( 'Conditional Logic', 'gravityformsmailchimp' ), esc_html__( 'When conditional logic is enabled, form submissions will only be exported to MailChimp when the conditions are met. When disabled all form submissions will be exported.', 'gravityformsmailchimp' ) ), ), array( 'type' => 'save' ), ), ), ); } /** * Define the markup for the mailchimp_list type field. * * @since 3.0 * @access public * * @param array $field The field properties. * @param bool $echo Should the setting markup be echoed. Defaults to true. * * @return string */ public function settings_mailchimp_list( $field, $echo = true ) { // Initialize HTML string. $html = ''; // If API is not initialized, return. if ( ! $this->initialize_api() ) { return $html; } // Prepare list request parameters. $params = array( 'start' => 0, 'limit' => 100 ); // Filter parameters. $params = apply_filters( 'gform_mailchimp_lists_params', $params ); // Convert start parameter to 3.0. if ( isset( $params['start'] ) ) { $params['offset'] = $params['start']; unset( $params['start'] ); } // Convert limit parameter to 3.0. if ( isset( $params['limit'] ) ) { $params['count'] = $params['limit']; unset( $params['limit'] ); } try { // Log contact lists request parameters. $this->log_debug( __METHOD__ . '(): Retrieving contact lists; params: ' . print_r( $params, true ) ); // Get lists. $lists = $this->api->get_lists( $params ); } catch ( Exception $e ) { // Log that contact lists could not be obtained. $this->log_error( __METHOD__ . '(): Could not retrieve MailChimp contact lists; ' . $e->getMessage() ); // Display error message. printf( esc_html__( 'Could not load MailChimp contact lists. %sError: %s', 'gravityformsmailchimp' ), '
', $e->getMessage() ); return; } // If no lists were found, display error message. if ( 0 === $lists['total_items'] ) { // Log that no lists were found. $this->log_error( __METHOD__ . '(): Could not load MailChimp contact lists; no lists found.' ); // Display error message. printf( esc_html__( 'Could not load MailChimp contact lists. %sError: %s', 'gravityformsmailchimp' ), '
', esc_html__( 'No lists found.', 'gravityformsmailchimp' ) ); return; } // Log number of lists retrieved. $this->log_debug( __METHOD__ . '(): Number of lists: ' . count( $lists['lists'] ) ); // Initialize select options. $options = array( array( 'label' => esc_html__( 'Select a MailChimp List', 'gravityformsmailchimp' ), 'value' => '', ), ); // Loop through MailChimp lists. foreach ( $lists['lists'] as $list ) { // Add list to select options. $options[] = array( 'label' => esc_html( $list['name'] ), 'value' => esc_attr( $list['id'] ), ); } // Add select field properties. $field['type'] = 'select'; $field['choices'] = $options; $field['onchange'] = 'jQuery(this).parents("form").submit();'; // Generate select field. $html = $this->settings_select( $field, false ); if ( $echo ) { echo $html; } return $html; } /** * Return an array of MailChimp list fields which can be mapped to the Form fields/entry meta. * * @since 3.0 * @access public * * @return array */ public function merge_vars_field_map() { // Initialize field map array. $field_map = array( 'EMAIL' => array( 'name' => 'EMAIL', 'label' => esc_html__( 'Email Address', 'gravityformsmailchimp' ), 'required' => true, 'field_type' => array( 'email', 'hidden' ), ), ); // If unable to initialize API, return field map. if ( ! $this->initialize_api() ) { return $field_map; } // Get current list ID. $list_id = $this->get_setting( 'mailchimpList' ); // Get merge fields. $merge_fields = $this->get_list_merge_fields( $list_id ); // If merge fields exist, add to field map. if ( ! empty( $merge_fields['merge_fields'] ) ) { // Loop through merge fields. foreach ( $merge_fields['merge_fields'] as $merge_field ) { // Define required field type. $field_type = null; // If this is an email merge field, set field types to "email" or "hidden". if ( 'EMAIL' === strtoupper( $merge_field['tag'] ) ) { $field_type = array( 'email', 'hidden' ); } // If this is an address merge field, set field type to "address". if ( 'address' === $merge_field['type'] ) { $field_type = array( 'address' ); } // Add to field map. $field_map[ $merge_field['tag'] ] = array( 'name' => $merge_field['tag'], 'label' => $merge_field['name'], 'required' => $merge_field['required'], 'field_type' => $field_type, ); } } return $field_map; } /** * Prevent feeds being listed or created if the API key isn't valid. * * @since 3.0 * @access public * * @return bool */ public function can_create_feed() { return $this->initialize_api(); } /** * Configures which columns should be displayed on the feed list page. * * @since 3.0 * @access public * * @return array */ public function feed_list_columns() { return array( 'feedName' => esc_html__( 'Name', 'gravityformsmailchimp' ), 'mailchimp_list_name' => esc_html__( 'MailChimp List', 'gravityformsmailchimp' ), ); } /** * Returns the value to be displayed in the MailChimp List column. * * @since 3.0 * @access public * * @param array $feed The feed being included in the feed list. * * @return string */ public function get_column_value_mailchimp_list_name( $feed ) { // If unable to initialize API, return the list ID. if ( ! $this->initialize_api() ) { return rgars( $feed, 'meta/mailchimpList' ); } try { // Get list. $list = $this->api->get_list( rgars( $feed, 'meta/mailchimpList' ) ); // Return list name. return rgar( $list, 'name' ); } catch ( Exception $e ) { // Log error. $this->log_error( __METHOD__ . '(): Unable to get MailChimp list for feed list; ' . $e->getMessage() ); // Return list ID. return rgars( $feed, 'meta/mailchimpList' ); } } /** * Define the markup for the interest categories type field. * * @since 4.0 * @access public * * @param array $field The field properties. * @param bool $echo Should the setting markup be echoed. * * @return string|void */ public function settings_interest_categories( $field, $echo = true ) { // Get interest categories. $categories = $this->get_interest_categories(); // If no categories are found, return. if ( empty( $categories ) ) { $this->log_debug( __METHOD__ . '(): No categories found.' ); return; } // Start field markup. $html = "
"; // Loop through interest categories. foreach ( $categories as $category ) { // Open category container. $html .= '
'; // Define label. $label = rgar( $category, 'title' ); // Display category label. $html .= '
' . esc_html( $label ) . '
'; // Get interests category interests. $interests = $this->api->get_interest_category_interests( $category['list_id'], $category['id'] ); // Loop through interests. foreach ( $interests as $interest ) { // Define interest key. $interest_key = 'interestCategory_' . $interest['id']; // Define enabled checkbox key. $enabled_key = $interest_key . '_enabled'; // Get interest checkbox markup. $html .= $this->settings_checkbox( array( 'name' => esc_html( $interest['name'] ), 'type' => 'checkbox', 'onclick' => "if(this.checked){jQuery('#{$interest_key}_condition_container').slideDown();} else{jQuery('#{$interest_key}_condition_container').slideUp();}", 'choices' => array( array( 'name' => $enabled_key, 'label' => esc_html( $interest['name'] ), ), ), ), false ); $html .= $this->interest_category_condition( $interest_key ); } $html .= '
'; } $html .= '
'; if ( $echo ) { echo $html; } return $html; } /** * Define the markup for the interest category conditional logic. * * @since 4.0 * @access public * * @param string $setting_name_root The category setting key. * * @return string */ public function interest_category_condition( $setting_name_root ) { $condition_enabled_setting = "{$setting_name_root}_enabled"; $is_enabled = $this->get_setting( $condition_enabled_setting ) == '1'; $container_style = ! $is_enabled ? "style='display:none;'" : ''; $str = "
" . esc_html__( 'Assign to group:', 'gravityformsmailchimp' ) . ' '; $str .= $this->settings_select( array( 'name' => "{$setting_name_root}_decision", 'type' => 'select', 'choices' => array( array( 'value' => 'always', 'label' => esc_html__( 'Always', 'gravityformsmailchimp' ) ), array( 'value' => 'if', 'label' => esc_html__( 'If', 'gravityformsmailchimp' ) ), ), 'onchange' => "if(jQuery(this).val() == 'if'){jQuery('#{$setting_name_root}_decision_container').show();}else{jQuery('#{$setting_name_root}_decision_container').hide();}", ), false ); $decision = $this->get_setting( "{$setting_name_root}_decision" ); if ( empty( $decision ) ) { $decision = 'always'; } $conditional_style = $decision == 'always' ? "style='display:none;'" : ''; $str .= '
' . $this->simple_condition( $setting_name_root, $is_enabled ) . ' ' . '
'; return $str; } /** * Define which field types can be used for the group conditional logic. * * @since 3.0 * @access public * * @uses GFAddOn::get_current_form() * @uses GFCommon::get_label() * @uses GF_Field::get_entry_inputs() * @uses GF_Field::get_input_type() * @uses GF_Field::is_conditional_logic_supported() * * @return array */ public function get_conditional_logic_fields() { // Initialize conditional logic fields array. $fields = array(); // Get the current form. $form = $this->get_current_form(); // Loop through the form fields. foreach ( $form['fields'] as $field ) { // If this field does not support conditional logic, skip it. if ( ! $field->is_conditional_logic_supported() ) { continue; } // Get field inputs. $inputs = $field->get_entry_inputs(); // If field has multiple inputs, add them as individual field options. if ( $inputs && 'checkbox' !== $field->get_input_type() ) { // Loop through the inputs. foreach ( $inputs as $input ) { // If this is a hidden input, skip it. if ( rgar( $input, 'isHidden' ) ) { continue; } // Add input to conditional logic fields array. $fields[] = array( 'value' => $input['id'], 'label' => GFCommon::get_label( $field, $input['id'] ), ); } } else { // Add field to conditional logic fields array. $fields[] = array( 'value' => $field->id, 'label' => GFCommon::get_label( $field ), ); } } return $fields; } /** * Define the markup for the double_optin checkbox input. * * @since 3.0 * @access public * * @param array $choice The choice properties. * @param string $attributes The attributes for the input tag. * @param string $value Is choice selected (1 if field has been checked. 0 or null otherwise). * @param string $tooltip The tooltip for this checkbox item. * * @return string */ public function checkbox_input_double_optin( $choice, $attributes, $value, $tooltip ) { // Get checkbox input markup. $markup = $this->checkbox_input( $choice, $attributes, $value, $tooltip ); // Define visibility status of warning. $display = $value ? 'none' : 'block-inline'; // Add warning to checkbox markup. $markup .= '(' . esc_html__( 'Abusing this may cause your MailChimp account to be suspended.', 'gravityformsmailchimp' ) . ')'; return $markup; } // # FEED PROCESSING ----------------------------------------------------------------------------------------------- /** * Process the feed, subscribe the user to the list. * * @since 3.0 * @access public * * @param array $feed The feed object to be processed. * @param array $entry The entry object currently being processed. * @param array $form The form object currently being processed. * * @return array */ public function process_feed( $feed, $entry, $form ) { // Log that we are processing feed. $this->log_debug( __METHOD__ . '(): Processing feed.' ); // If unable to initialize API, log error and return. if ( ! $this->initialize_api() ) { $this->add_feed_error( esc_html__( 'Unable to process feed because API could not be initialized.', 'gravityformsmailchimp' ), $feed, $entry, $form ); return $entry; } // Set current merge variable name. $this->merge_var_name = 'EMAIL'; // Get field map values. $field_map = $this->get_field_map_fields( $feed, 'mappedFields' ); // Get mapped email address. $email = $this->get_field_value( $form, $entry, $field_map['EMAIL'] ); // If email address is invalid, log error and return. if ( GFCommon::is_invalid_or_empty_email( $email ) ) { $this->add_feed_error( esc_html__( 'A valid Email address must be provided.', 'gravityformsmailchimp' ), $feed, $entry, $form ); return $entry; } /** * Prevent empty form fields erasing values already stored in the mapped MailChimp MMERGE fields * when updating an existing subscriber. * * @param bool $override If the merge field should be overridden. * @param array $form The form object. * @param array $entry The entry object. * @param array $feed The feed object. */ $override_empty_fields = gf_apply_filters( 'gform_mailchimp_override_empty_fields', array( $form['id'] ), true, $form, $entry, $feed ); // Log that empty fields will not be overridden. if ( ! $override_empty_fields ) { $this->log_debug( __METHOD__ . '(): Empty fields will not be overridden.' ); } // Initialize array to store merge vars. $merge_vars = array(); // Loop through field map. foreach ( $field_map as $name => $field_id ) { // If no field is mapped, skip it. if ( rgblank( $field_id ) ) { continue; } // If this is the email field, skip it. if ( strtoupper( $name ) === 'EMAIL' ) { continue; } // Set merge var name to current field map name. $this->merge_var_name = $name; // Get field object. $field = GFFormsModel::get_field( $form, $field_id ); // Get field value. $field_value = $this->get_field_value( $form, $entry, $field_id ); // If field value is empty and we are not overriding empty fields, skip it. if ( empty( $field_value ) && ( ! $override_empty_fields || ( is_object( $field ) && 'address' === $field->get_input_type() ) ) ) { continue; } // Get merge field. $merge_field = $this->get_list_merge_field( $feed['meta']['mailchimpList'], $name ); // Format date field. if ( ! empty( $field_value ) && ! empty( $merge_field ) && in_array( $merge_field['type'], array( 'date', 'birthday' ) ) ) { // Get date format. $date_format = $merge_field['options']['date_format']; // Convert field value to timestamp. $field_value_timestamp = strtotime( $field_value ); // Format date. switch( $date_format ) { case 'DD/MM': $field_value = date( 'd/m', $field_value_timestamp ); break; case 'MM/DD': $field_value = date( 'm/d', $field_value_timestamp ); break; case 'DD/MM/YYYY': case 'MM/DD/YYYY': $field_value = date( 'm/d/Y', $field_value_timestamp ); break; } } $merge_vars[ $name ] = $field_value; } // Define initial member, member found and member status variables. $member = false; $member_found = false; $member_status = null; try { // Log that we are checking if user is already subscribed to list. $this->log_debug( __METHOD__ . "(): Checking to see if $email is already on the list." ); // Get member info. $member = $this->api->get_list_member( $feed['meta']['mailchimpList'], $email ); // Set member found status to true. $member_found = true; // Set member status. $member_status = $member['status']; // Log member status. $this->log_debug( __METHOD__ . "(): $email was found on list. Status: $member_status" ); } catch ( Exception $e ) { // If the exception code is not 404, abort feed processing. if ( 404 !== $e->getCode() ) { // Log that we could not get the member information. $this->add_feed_error( sprintf( esc_html__( 'Unable to check if email address is already used by a member: %s', 'gravityformsmailchimp' ), $e->getMessage() ), $feed, $entry, $form ); return $entry; } // Log member status. $this->log_debug( __METHOD__ . "(): $email was not found on list." ); } /** * Modify whether a user that currently has a status of unsubscribed on your list is resubscribed. * By default, the user is resubscribed. * * @param bool $allow_resubscription If the user should be resubscribed. * @param array $form The form object. * @param array $entry The entry object. * @param array $feed The feed object. */ $allow_resubscription = gf_apply_filters( array( 'gform_mailchimp_allow_resubscription', $form['id'] ), true, $form, $entry, $feed ); // If member is unsubscribed and resubscription is not allowed, exit. if ( 'unsubscribed' == $member_status && ! $allow_resubscription ) { $this->log_debug( __METHOD__ . '(): User is unsubscribed and resubscription is not allowed.' ); return; } /** * Modify whether a user that is already subscribed to your list has their groups replaced when submitting the form a second time. * * @since 1.9 * * @param bool $keep_existing_interests Should user keep existing interest categories? * @param array $form The form object. * @param array $entry The entry object. * @param array $feed The feed object. */ $keep_existing_interests = gf_apply_filters( array( 'gform_mailchimp_keep_existing_groups', $form['id'] ), true, $form, $entry, $feed ); // Initialize interests to keep array. $interests_to_keep = array(); // Initialize interests array. $interests = $existing_interests = rgar( $member, 'interests', array() ); // If member was found, has existing interests and we are not keeping existing interest categories, remove them. if ( $member_found && $existing_interests ) { // Loop through existing interests. foreach ( $existing_interests as $interest_id => $interest_enabled ) { // If interest is not enabled, skip it. if ( ! $interest_enabled ) { continue; } // If we are keeping existing interests, add to array. if ( $keep_existing_interests ) { $interests_to_keep[] = $interest_id; continue; } else if ( ! $keep_existing_interests ) { // Disable interest in new subscription. $interests[ $interest_id ] = false; } } } // Get interest categories. $categories = $this->get_feed_interest_categories( $feed ); // Loop through categories. foreach ( $categories as $category_id => $category_meta ) { // If category is not enabled or the category is one we are keeping, skip it. if ( ! rgar( $category_meta, 'enabled' ) || in_array( $category_id, $interests_to_keep ) ) { continue; } // Log that we are evaluating the category conditions. $this->log_debug( __METHOD__ . '(): Evaluating condition for interest category "' . $category_id . '": ' . print_r( $category_meta, true ) ); // Get condition evaluation. $condition_evaluation = $this->is_category_condition_met( $category_meta, $form, $entry ); // Set interest category based on evaluation. $interests[ $category_id ] = $condition_evaluation; } // If member status is not defined or is anything other than pending, set to subscribed. $member_status = isset( $member_status ) && $member_status === 'pending' ? $member_status : 'subscribed'; // Prepare subscription arguments. $subscription = array( 'id' => $feed['meta']['mailchimpList'], 'email' => array( 'email' => $email ), 'merge_vars' => $merge_vars, 'interests' => $interests, 'email_type' => 'html', 'double_optin' => rgars( $feed, 'meta/double_optin' ) ? true : false, 'status' => $member_status, 'ip_signup' => rgar( $entry, 'ip' ), 'vip' => rgars( $feed, 'meta/markAsVIP' ) ? true : false, 'note' => rgars( $feed, 'meta/note' ), ); // Prepare transaction type for filter. $transaction = $member_found ? 'Update' : 'Subscribe'; /** * Modify the subscription object before it is executed. * * @deprecated 4.0 @use gform_mailchimp_subscription * * @param array $subscription Subscription arguments. * @param array $form The form object. * @param array $entry The entry object. * @param array $feed The feed object. * @param string $transaction Transaction type. Defaults to Subscribe. */ $subscription = gf_apply_filters( array( 'gform_mailchimp_args_pre_subscribe', $form['id'] ), $subscription, $form, $entry, $feed, $transaction ); // Convert merge vars. $subscription['merge_fields'] = $subscription['merge_vars']; unset( $subscription['merge_vars'] ); // Convert double optin. $subscription['status'] = $subscription['double_optin'] ? 'pending' : $subscription['status']; unset( $subscription['double_optin'] ); // Extract list ID. $list_id = $subscription['id']; unset( $subscription['id'] ); // Convert email address. $subscription['email_address'] = $subscription['email']['email']; unset( $subscription['email'] ); /** * Modify the subscription object before it is executed. * * @since 4.1.9 Added existing member object as $member parameter. * * @param array $subscription Subscription arguments. * @param string $list_id MailChimp list ID. * @param array $form The form object. * @param array $entry The entry object. * @param array $feed The feed object. * @param array|false $member The existing member object. (False if member does not currently exist in MailChimp.) */ $subscription = gf_apply_filters( array( 'gform_mailchimp_subscription', $form['id'] ), $subscription, $list_id, $form, $entry, $feed, $member ); // Remove merge_fields if none are defined. if ( empty( $subscription['merge_fields'] ) ) { unset( $subscription['merge_fields'] ); } // Remove interests if none are defined. if ( empty( $subscription['interests'] ) ) { unset( $subscription['interests'] ); } // Remove VIP if not enabled. if ( ! $subscription['vip'] ) { unset( $subscription['vip'] ); } // Remove note from the subscription object and process any merge tags. $note = GFCommon::replace_variables( $subscription['note'], $form, $entry, false, true, false, 'text' ); unset( $subscription['note'] ); $action = $member_found ? 'updated' : 'added'; try { // Log the subscriber to be added or updated. $this->log_debug( __METHOD__ . "(): Subscriber to be {$action}: " . print_r( $subscription, true ) ); // Add or update subscriber. $this->api->update_list_member( $list_id, $subscription['email_address'], $subscription ); // Log that the subscription was added or updated. $this->log_debug( __METHOD__ . "(): Subscriber successfully {$action}." ); } catch ( Exception $e ) { // Log that subscription could not be added or updated. $this->add_feed_error( sprintf( esc_html__( 'Unable to add/update subscriber: %s', 'gravityformsmailchimp' ), $e->getMessage() ), $feed, $entry, $form ); // Log field errors. if ( $e->hasErrors() ) { $this->log_error( __METHOD__ . '(): Field errors when attempting subscription: ' . print_r( $e->getErrors(), true ) ); } return; } if ( ! $note ) { // Abort as there is no note to process. return; } try { // Add the note to the member. $this->api->add_member_note( $list_id, $subscription['email_address'], $note ); $this->log_debug( __METHOD__ . '(): Note successfully added to subscriber.' ); } catch ( Exception $e ) { // Log that the note could not be added. $this->add_feed_error( sprintf( esc_html__( 'Unable to add note to subscriber: %s', 'gravityformsmailchimp' ), $e->getMessage() ), $feed, $entry, $form ); return; } } /** * Returns the value of the selected field. * * @since 3.0 * @access public * * @param array $form The form object currently being processed. * @param array $entry The entry object currently being processed. * @param string $field_id The ID of the field being processed. * * @uses GFAddOn::get_full_name() * @uses GF_Field::get_value_export() * @uses GFFormsModel::get_field() * @uses GFFormsModel::get_input_type() * @uses GFMailChimp::get_full_address() * @uses GFMailChimp::maybe_override_field_value() * * @return array|string */ public function get_field_value( $form, $entry, $field_id ) { // Set initial field value. $field_value = ''; // Set field value based on field ID. switch ( strtolower( $field_id ) ) { // Form title. case 'form_title': $field_value = rgar( $form, 'title' ); break; // Entry creation date. case 'date_created': // Get entry creation date from entry. $date_created = rgar( $entry, strtolower( $field_id ) ); // If date is not populated, get current date. $field_value = empty( $date_created ) ? gmdate( 'Y-m-d H:i:s' ) : $date_created; break; // Entry IP and source URL. case 'ip': case 'source_url': $field_value = rgar( $entry, strtolower( $field_id ) ); break; default: // Get field object. $field = GFFormsModel::get_field( $form, $field_id ); if ( is_object( $field ) ) { // Check if field ID is integer to ensure field does not have child inputs. $is_integer = $field_id == intval( $field_id ); // Get field input type. $input_type = GFFormsModel::get_input_type( $field ); if ( $is_integer && 'address' === $input_type ) { // Get full address for field value. $field_value = $this->get_full_address( $entry, $field_id ); } else if ( $is_integer && 'name' === $input_type ) { // Get full name for field value. $field_value = $this->get_full_name( $entry, $field_id ); } else if ( $is_integer && 'checkbox' === $input_type ) { // Initialize selected options array. $selected = array(); // Loop through checkbox inputs. foreach ( $field->inputs as $input ) { $index = (string) $input['id']; if ( ! rgempty( $index, $entry ) ) { $selected[] = $this->maybe_override_field_value( rgar( $entry, $index ), $form, $entry, $index ); } } // Convert selected options array to comma separated string. $field_value = implode( ', ', $selected ); } else if ( 'phone' === $input_type && $field->phoneFormat == 'standard' ) { // Get field value. $field_value = rgar( $entry, $field_id ); // Reformat standard format phone to match MailChimp format. // Format: NPA-NXX-LINE (404-555-1212) when US/CAN. if ( ! empty( $field_value ) && preg_match( '/^\D?(\d{3})\D?\D?(\d{3})\D?(\d{4})$/', $field_value, $matches ) ) { $field_value = sprintf( '%s-%s-%s', $matches[1], $matches[2], $matches[3] ); } } else { // Use export value if method exists for field. if ( is_callable( array( 'GF_Field', 'get_value_export' ) ) ) { $field_value = $field->get_value_export( $entry, $field_id ); } else { $field_value = rgar( $entry, $field_id ); } } } else { // Get field value from entry. $field_value = rgar( $entry, $field_id ); } } return $this->maybe_override_field_value( $field_value, $form, $entry, $field_id ); } /** * Use the legacy gform_mailchimp_field_value filter instead of the framework gform_SLUG_field_value filter. * * @since 3.0 * @access public * * @param string $field_value The field value. * @param array $form The form object currently being processed. * @param array $entry The entry object currently being processed. * @param string $field_id The ID of the field being processed. * * @return string */ public function maybe_override_field_value( $field_value, $form, $entry, $field_id ) { return gf_apply_filters( 'gform_mailchimp_field_value', array( $form['id'], $field_id ), $field_value, $form['id'], $field_id, $entry, $this->merge_var_name ); } // # HELPERS ------------------------------------------------------------------------------------------------------- /** * Initializes MailChimp API if credentials are valid. * * @since 4.0 * @access public * * @param string $api_key MailChimp API key. * * @uses GFAddOn::get_plugin_setting() * @uses GFAddOn::log_debug() * @uses GFAddOn::log_error() * @uses GF_MailChimp_API::account_details() * * @return bool|null */ public function initialize_api( $api_key = null ) { // If API is alredy initialized, return true. if ( ! is_null( $this->api ) ) { return true; } // Get the API key. if ( rgblank( $api_key ) ) { $api_key = $this->get_plugin_setting( 'apiKey' ); } // If the API key is blank, do not run a validation check. if ( rgblank( $api_key ) ) { return null; } // Log validation step. $this->log_debug( __METHOD__ . '(): Validating API Info.' ); // Setup a new MailChimp object with the API credentials. $mc = new GF_MailChimp_API( $api_key ); try { // Retrieve account information. $mc->account_details(); // Assign API library to class. $this->api = $mc; // Log that authentication test passed. $this->log_debug( __METHOD__ . '(): MailChimp successfully authenticated.' ); return true; } catch ( Exception $e ) { // Log that authentication test failed. $this->log_error( __METHOD__ . '(): Unable to authenticate with MailChimp; '. $e->getMessage() ); return false; } } /** * Retrieve the interest groups for the list. * * @since 4.0 * @access public * * @param string $list_id MailChimp list ID. * * @return array|bool */ private function get_interest_categories( $list_id = null ) { // If API is not initialized, return false. if ( ! $this->initialize_api() ) { return false; } // Get MailChimp list ID. if ( rgblank( $list_id ) ) { $list_id = $this->get_setting( 'mailchimpList' ); } // If MailChimp list ID is not defined, return. if ( rgblank( $list_id ) ) { // Log that list ID was not defined. $this->log_error( __METHOD__ . '(): Could not get MailChimp interest categories because list ID was not defined.' ); return false; } try { // Get groups. $categories = $this->api->get_list_interest_categories( $list_id ); } catch ( Exception $e ) { // Log error. $this->log_error( __METHOD__ . '(): Unable to get interest categories for list "' . $list_id . '"; ' . $e->getMessage() ); return array(); } return $categories; } /** * Determines if MailChimp list has any defined interest categories. * * @since 4.0 * @access public * * @return bool */ public function has_interest_categories() { // Get interest categories. $categories = $this->get_interest_categories(); return ! empty( $categories ); } /** * Retrieve the enabled interest categories for a feed. * * @since 4.0 * @access public * * @param array $feed The feed object. * @param bool $enabled Return only enabled categories. Defaults to true. * * @return array */ public function get_feed_interest_categories( $feed, $enabled = true ) { // Initialize categories array. $categories = array(); // Loop through feed meta. foreach ( $feed['meta'] as $key => $value ) { // If this is not an interest category, skip it. if ( 0 !== strpos( $key, 'interestCategory_' ) ) { continue; } // Explode the meta key. $key = explode( '_', $key ); // Add value to categories array. $categories[ $key[1] ][ $key[2] ] = $value; } // If we are only returning enabled categories, remove disabled categories. if ( $enabled ) { // Loop through categories. foreach ( $categories as $category_id => $category_meta ) { // If category is enabled, skip it. if ( '1' == $category_meta['enabled'] ) { continue; } // Remove category. unset( $categories[ $category_id ] ); } } return $categories; } /** * Determine if the user should be subscribed to the interest category. * * @since 4.0 * @access public * * @param array $category The interest category properties. * @param array $form The form currently being processed. * @param array $entry The entry currently being processed. * * @uses GFFormsModel::get_field() * @uses GFFormsModel::is_value_match() * @uses GFMailChimp::get_field_value() * * @return bool */ public function is_category_condition_met( $category, $form, $entry ) { if ( ! $category['enabled'] ) { $this->log_debug( __METHOD__ . '(): Interest category not enabled. Returning false.' ); return false; } else if ( $category['decision'] == 'always' ) { $this->log_debug( __METHOD__ . '(): Interest category decision is always. Returning true.' ); return true; } $field = GFFormsModel::get_field( $form, $category['field'] ); if ( ! is_object( $field ) ) { $this->log_debug( __METHOD__ . "(): Field #{$category['field']} not found. Returning true." ); return true; } else { $field_value = GFFormsModel::get_lead_field_value( $entry, $field ); $is_value_match = GFFormsModel::is_value_match( $field_value, $category['value'], $category['operator'] ); $this->log_debug( __METHOD__ . "(): Add to interest category if field #{$category['field']} value {$category['operator']} '{$category['value']}'. Is value match? " . var_export( $is_value_match, 1 ) ); return $is_value_match; } } /** * Returns the combined value of the specified Address field. * Street 2 and Country are the only inputs not required by MailChimp. * If other inputs are missing MailChimp will not store the field value, we will pass a hyphen when an input is empty. * MailChimp requires the inputs be delimited by 2 spaces. * * @since 3.0 * @access public * * @param array $entry The entry currently being processed. * @param string $field_id The ID of the field to retrieve the value for. * * @return array|null */ public function get_full_address( $entry, $field_id ) { // Initialize address array. $address = array( 'addr1' => str_replace( ' ', ' ', trim( rgar( $entry, $field_id . '.1' ) ) ), 'addr2' => str_replace( ' ', ' ', trim( rgar( $entry, $field_id . '.2' ) ) ), 'city' => str_replace( ' ', ' ', trim( rgar( $entry, $field_id . '.3' ) ) ), 'state' => str_replace( ' ', ' ', trim( rgar( $entry, $field_id . '.4' ) ) ), 'zip' => trim( rgar( $entry, $field_id . '.5' ) ), 'country' => trim( rgar( $entry, $field_id . '.6' ) ), ); // Get address parts. $address_parts = array_values( $address ); // Remove empty address parts. $address_parts = array_filter( $address_parts ); // If no address parts exist, return null. if ( empty( $address_parts ) ) { return null; } // Replace country with country code. if ( ! empty( $address['country'] ) ) { $address['country'] = GF_Fields::get( 'address' )->get_country_code( $address['country'] ); } return $address; } /** * Get MailChimp merge fields for list. * * @since 4.2.4 * @access public * * @param string $list_id List ID to get merge fields for. * * @uses GFMailChimp::initialize_api() * @uses GF_MailChimp_API::get_list_merge_fields() * * @return array */ public function get_list_merge_fields( $list_id = '' ) { // If no list ID was provided or if API cannot be initialized, return. if ( rgblank( $list_id ) || ! $this->initialize_api() ) { return array(); } // If merge fields have already been retrieved, return. if ( isset( $this->merge_fields[ $list_id ] ) ) { return $this->merge_fields[ $list_id ]; } try { // Get merge fields. $this->merge_fields[ $list_id ] = $this->api->get_list_merge_fields( $list_id ); } catch ( Exception $e ) { // Log error. $this->log_error( __METHOD__ . '(): Unable to get merge fields for MailChimp list; ' . $e->getMessage() ); $this->merge_fields[ $list_id ] = array(); } return $this->merge_fields[ $list_id ]; } /** * Get specific MailChimp merge field by tag. * * @since 4.2.4 * @access public * * @param string $list_id List ID to get merge fields for. * @param string $tag Merge field tag. * * @uses GFMailChimp::get_list_merge_fields() * * @return array */ public function get_list_merge_field( $list_id = '', $tag = '' ) { // Get the merge fields for list. $merge_fields = $this->get_list_merge_fields( $list_id ); // If no merge fields were provided, return. if ( empty( $merge_fields ) || ! isset( $merge_fields['merge_fields'] ) ) { return; } // Loop through merge fields. foreach ( $merge_fields['merge_fields'] as $merge_field ) { // If this is not the merge field we are looking for, skip. if ( $tag !== $merge_field['tag'] ) { continue; } return $merge_field; } return array(); } // # UPGRADES ------------------------------------------------------------------------------------------------------ /** * Checks if a previous version was installed and if the feeds need migrating to the framework structure. * * @since 3.0 * @access public * * @param string $previous_version The version number of the previously installed version. */ public function upgrade( $previous_version ) { // If previous version is not defined, set it to the version stored in the options table. if ( empty( $previous_version ) ) { $previous_version = get_option( 'gf_mailchimp_version' ); } // Run upgrade routine checks. $previous_is_pre_40 = ! empty( $previous_version ) && version_compare( $previous_version, '4.0', '<' ); $previous_is_pre_addon_framework = ! empty( $previous_version ) && version_compare( $previous_version, '3.0.dev1', '<' ); if ( $previous_is_pre_addon_framework ) { $this->upgrade_to_addon_framework(); } if ( $previous_is_pre_40 ) { $this->convert_groups_to_categories(); } } /** * Convert groups in feed meta to interest categories. * * @since 4.0 * @access public * * @uses GFAddOn::log_error() * @uses GFAddOn::get_plugin_settings() * @uses GFAddOn::update_plugin_settings() * @uses GFCache::delete() * @uses GFFeedAddOn::get_feeds() * @uses GFFeedAddOn::update_feed_meta() * @uses GFMailChimp::initialize_api() * @uses GF_MailChimp_API::get_interest_category_interests() * @uses GF_MailChimp_API::get_list_interest_categories() */ public function convert_groups_to_categories() { // If API cannot be initialized, exit. if ( ! $this->initialize_api() ) { $this->log_error( __METHOD__ . '(): Unable to convert MailChimp groups to interest categories because API could not be initialized.' ); return; } // Get plugin settings. $settings = $this->get_plugin_settings(); // Get MailChimp feeds. $feeds = $this->get_feeds(); $list_interest_categories = array(); $interest_category_interests = array(); // Loop through MailChimp feeds. foreach ( $feeds as $feed ) { // If no list ID is set, skip it. if ( ! rgars( $feed, 'meta/mailchimpList' ) ) { continue; } // Initialize categories array. $categories = array(); try { $list_id = $feed['meta']['mailchimpList']; if ( ! isset( $list_interest_categories[ $list_id ] ) ) { // Get interest categories for list. $list_interest_categories[ $list_id ] = $this->api->get_list_interest_categories( $list_id ); } $interest_categories = rgar( $list_interest_categories, $list_id, array() ); } catch ( Exception $e ) { // Log that we could not get interest categories. $this->log_error( __METHOD__ . '(): Unable to updated feed #' . $feed['id'] . ' because interest categories could not be retrieved for MailChimp list ' . $feed['meta']['mailchimpList'] ); continue; } // Loop through interest categories. foreach ( $interest_categories as $interest_category ) { $category_id = $interest_category['id']; if ( ! isset( $interest_category_interests[ $category_id ] ) ) { // Get interests for interest category. $interest_category_interests[ $category_id ] = $this->api->get_interest_category_interests( $list_id, $category_id ); } $interests = rgar( $list_interest_categories, $category_id, array() ); // Loop through interests. foreach ( $interests as $interest ) { // Add interest to categories array using sanitized name. $categories[ $interest['id'] ] = sanitize_title_with_dashes( $interest['name'] ); } } // Loop through feed meta. foreach ( $feed['meta'] as $key => $value ) { // If this is not a MailChimp group key, skip it. if ( 0 !== strpos( $key, 'mc_group_' ) ) { continue; } // Explode meta key. $exploded_key = explode( '_', $key ); // Get MailChimp group key. $mc_key = $exploded_key[0] . '_' . $exploded_key[1] . '_' . $exploded_key[2]; unset( $exploded_key[0], $exploded_key[1], $exploded_key[2] ); // Get meta key without group name. $meta_key = implode( '_', $exploded_key ); // Get settings key for MailChimp group key. $settings_key = array_search( $mc_key, $settings ); // Get sanitized group name. $sanitized_group_name = substr( $settings_key, strrpos( $settings_key, '_' ) + 1 ); // Get new category ID. $category_id = array_search( $sanitized_group_name, $categories ); // If category ID exists, migrate group setting. if ( $category_id ) { $feed['meta'][ 'interestCategory_' . $category_id . '_' . $meta_key ] = $value; unset( $feed['meta'][ $key ] ); } } // Save feed. $this->update_feed_meta( $feed['id'], $feed['meta'] ); } // Reset plugin settings to just API key. $settings = array( 'apiKey' => $settings['apiKey'] ); // Save plugin settings. $this->update_plugin_settings( $settings ); // Delete cache. GFCache::delete( 'mailchimp_plugin_settings' ); } /** * Upgrade versions of MailChimp Add-On before 3.0 to the Add-On Framework. * * @since 4.0 * @access public */ public function upgrade_to_addon_framework() { //get old plugin settings $old_settings = get_option( 'gf_mailchimp_settings' ); //remove username and password from the old settings; these were very old legacy api settings that we do not support anymore if ( is_array( $old_settings ) ) { foreach ( $old_settings as $id => $setting ) { if ( $id != 'username' && $id != 'password' ) { if ( $id == 'apikey' ) { $id = 'apiKey'; } $new_settings[ $id ] = $setting; } } $this->update_plugin_settings( $new_settings ); } //get old feeds $old_feeds = $this->get_old_feeds(); if ( $old_feeds ) { $counter = 1; foreach ( $old_feeds as $old_feed ) { $feed_name = 'Feed ' . $counter; $form_id = $old_feed['form_id']; $is_active = rgar( $old_feed, 'is_active' ) ? '1' : '0'; $field_maps = rgar( $old_feed['meta'], 'field_map' ); $groups = rgar( $old_feed['meta'], 'groups' ); $list_id = rgar( $old_feed['meta'], 'contact_list_id' ); $new_meta = array( 'feedName' => $feed_name, 'mailchimpList' => $list_id, 'double_optin' => rgar( $old_feed['meta'], 'double_optin' ) ? '1' : '0', 'sendWelcomeEmail' => rgar( $old_feed['meta'], 'welcome_email' ) ? '1' : '0', ); //add mappings foreach ( $field_maps as $key => $mapping ) { $new_meta[ 'mappedFields_' . $key ] = $mapping; } if ( ! empty( $groups ) ) { $group_id = 0; //add groups to meta //get the groups from mailchimp because we need to use the main group id to build the key used to map the fields //old data only has the text, use the text to get the id $mailchimp_groupings = $this->get_interest_categories( $list_id ); //loop through the existing feed data to create mappings for new tables foreach ( $groups as $key => $group ) { //get the name of the top level group so the id can be retrieved from the mailchimp data foreach ( $mailchimp_groupings as $mailchimp_group ) { if ( str_replace( '%', '', sanitize_title_with_dashes( $mailchimp_group['name'] ) ) == $key ) { $group_id = $mailchimp_group['id']; break; } } if ( is_array( $group ) ) { foreach ( $group as $subkey => $subgroup ) { $setting_key_root = $this->get_group_setting_key( $group_id, $subgroup['group_label'] ); $new_meta[ $setting_key_root . '_enabled' ] = rgar( $subgroup, 'enabled' ) ? '1' : '0'; $new_meta[ $setting_key_root . '_decision' ] = rgar( $subgroup, 'decision' ); $new_meta[ $setting_key_root . '_field_id' ] = rgar( $subgroup, 'field_id' ); $new_meta[ $setting_key_root . '_operator' ] = rgar( $subgroup, 'operator' ); $new_meta[ $setting_key_root . '_value' ] = rgar( $subgroup, 'value' ); } } } } //add conditional logic, legacy only allowed one condition $conditional_enabled = rgar( $old_feed['meta'], 'optin_enabled' ); if ( $conditional_enabled ) { $new_meta['feed_condition_conditional_logic'] = 1; $new_meta['feed_condition_conditional_logic_object'] = array( 'conditionalLogic' => array( 'actionType' => 'show', 'logicType' => 'all', 'rules' => array( array( 'fieldId' => rgar( $old_feed['meta'], 'optin_field_id' ), 'operator' => rgar( $old_feed['meta'], 'optin_operator' ), 'value' => rgar( $old_feed['meta'], 'optin_value' ) ), ) ) ); } else { $new_meta['feed_condition_conditional_logic'] = 0; } $this->insert_feed( $form_id, $is_active, $new_meta ); $counter ++; } //set paypal delay setting $this->update_paypal_delay_settings( 'delay_mailchimp_subscription' ); } // Delete old options. delete_option( 'gf_mailchimp_settings' ); delete_option( 'gf_mailchimp_version' ); } /** * Migrate the delayed payment setting for the PayPal add-on integration. * * @since 3.0 * @access public * * @param string $old_delay_setting_name Old PayPal delay settings name. * * @uses GFAddon::log_debug() * @uses GFFeedAddOn::get_feeds_by_slug() * @uses GFFeedAddOn::update_feed_meta() * @uses GFMailChimp::get_old_paypal_feeds() * @uses wpdb::update() */ public function update_paypal_delay_settings( $old_delay_setting_name ) { global $wpdb; // Log that we are checking for delay settings for migration. $this->log_debug( __METHOD__ . '(): Checking to see if there are any delay settings that need to be migrated for PayPal Standard.' ); $new_delay_setting_name = 'delay_' . $this->_slug; // Get paypal feeds from old table. $paypal_feeds_old = $this->get_old_paypal_feeds(); // Loop through feeds and look for delay setting and create duplicate with new delay setting for the framework version of PayPal Standard if ( ! empty( $paypal_feeds_old ) ) { $this->log_debug( __METHOD__ . '(): Old feeds found for ' . $this->_slug . ' - copying over delay settings.' ); foreach ( $paypal_feeds_old as $old_feed ) { $meta = $old_feed['meta']; if ( ! rgempty( $old_delay_setting_name, $meta ) ) { $meta[ $new_delay_setting_name ] = $meta[ $old_delay_setting_name ]; //Update paypal meta to have new setting $meta = maybe_serialize( $meta ); $wpdb->update( "{$wpdb->prefix}rg_paypal", array( 'meta' => $meta ), array( 'id' => $old_feed['id'] ), array( '%s' ), array( '%d' ) ); } } } // Get paypal feeds from new framework table. $paypal_feeds = $this->get_feeds_by_slug( 'gravityformspaypal' ); if ( ! empty( $paypal_feeds ) ) { $this->log_debug( __METHOD__ . '(): New feeds found for ' . $this->_slug . ' - copying over delay settings.' ); foreach ( $paypal_feeds as $feed ) { $meta = $feed['meta']; if ( ! rgempty( $old_delay_setting_name, $meta ) ) { $meta[ $new_delay_setting_name ] = $meta[ $old_delay_setting_name ]; $this->update_feed_meta( $feed['id'], $meta ); } } } } /** * Retrieve any old PayPal feeds. * * @since 3.0 * @access public * * @uses GFAddOn::log_debug() * @uses GFAddOn::table_exists() * @uses GFFormsModel::get_form_table_name() * @uses wpdb::get_results() * * @return bool|array */ public function get_old_paypal_feeds() { global $wpdb; // Get old PayPal Add-On table name. $table_name = $wpdb->prefix . 'rg_paypal'; // If the table does not exist, exit. if ( ! $this->table_exists( $table_name ) ) { return false; } $form_table_name = GFFormsModel::get_form_table_name(); $sql = "SELECT s.id, s.is_active, s.form_id, s.meta, f.title as form_title FROM {$table_name} s INNER JOIN {$form_table_name} f ON s.form_id = f.id"; $this->log_debug( __METHOD__ . "(): getting old paypal feeds: {$sql}" ); $results = $wpdb->get_results( $sql, ARRAY_A ); $this->log_debug( __METHOD__ . "(): error?: {$wpdb->last_error}" ); $count = count( $results ); $this->log_debug( __METHOD__ . "(): count: {$count}" ); for ( $i = 0; $i < $count; $i ++ ) { $results[ $i ]['meta'] = maybe_unserialize( $results[ $i ]['meta'] ); } return $results; } /** * Retrieve any old feeds which need migrating to the Feed Add-On Framework. * * @since 3.0 * @access public * * @uses GFAddOn::table_exists() * @uses GFFormsModel::get_form_table_name() * @uses wpdb::get_results() * * @return bool|array */ public function get_old_feeds() { global $wpdb; // Get pre-3.0 table name. $table_name = $wpdb->prefix . 'rg_mailchimp'; // If the table does not exist, exit. if ( ! $this->table_exists( $table_name ) ) { return false; } $form_table_name = GFFormsModel::get_form_table_name(); $sql = "SELECT s.id, s.is_active, s.form_id, s.meta, f.title as form_title FROM $table_name s INNER JOIN $form_table_name f ON s.form_id = f.id"; $results = $wpdb->get_results( $sql, ARRAY_A ); $count = count( $results ); for ( $i = 0; $i < $count; $i ++ ) { $results[ $i ]['meta'] = maybe_unserialize( $results[ $i ]['meta'] ); } return $results; } /** * Retrieve the group setting key. * * @param string $grouping_id The group ID. * @param string $group_name The group name. * * @return string */ public function get_group_setting_key( $grouping_id, $group_name ) { $plugin_settings = GFCache::get( 'mailchimp_plugin_settings' ); if ( empty( $plugin_settings ) ) { $plugin_settings = $this->get_plugin_settings(); GFCache::set( 'mailchimp_plugin_settings', $plugin_settings ); } $key = 'group_key_' . $grouping_id . '_' . str_replace( '%', '', sanitize_title_with_dashes( $group_name ) ); if ( ! isset( $plugin_settings[ $key ] ) ) { $group_key = sanitize_key( uniqid( 'mc_group_', true ) ); $plugin_settings[ $key ] = $group_key; $this->update_plugin_settings( $plugin_settings ); GFCache::set( 'mailchimp_plugin_settings', $plugin_settings ); } return $plugin_settings[ $key ]; } }