get_results( "SELECT p.ID\n FROM {$wpdb->posts} AS p\n INNER JOIN {$wpdb->postmeta} AS pm\n ON p.ID = pm.post_id AND pm.meta_key = '_elementor_edit_mode'\n WHERE pm.meta_value = 'builder'\n AND p.post_status = 'publish'", ARRAY_A ); foreach ( $result as $single_post ) { $elementor_data = get_post_meta( $single_post['ID'], '_elementor_data', true ); if ( !is_array( $elementor_data ) ) { $elementor_data = json_decode( $elementor_data, true ); } if ( is_array( $elementor_data ) ) { if ( count( $elementor_data ) > 1 ) { foreach ( $elementor_data as $element ) { adfoin_elementorpro_find_element_recursive( array($element), $single_post['ID'] ); } } else { adfoin_elementorpro_find_element_recursive( $elementor_data, $single_post['ID'] ); } } } $only_forms = array_filter( (array) $only_forms ); $form_list = array(); if ( $only_forms ) { foreach ( $only_forms as $single ) { $form_list[$single['post_id'] . '_' . $single['id']] = $single['post_id'] . ' ' . $single['settings']['form_name']; } } set_transient( 'adfoin_elementorpro_forms', $form_list, DAY_IN_SECONDS ); return $form_list; } /** * Invalidate the cached Elementor Pro form list whenever an Elementor * document is saved, or when a post with Elementor data is updated/deleted. */ function adfoin_elementorpro_clear_forms_cache() { delete_transient( 'adfoin_elementorpro_forms' ); } add_action( 'elementor/document/after_save', 'adfoin_elementorpro_clear_forms_cache' ); add_action( 'save_post', 'adfoin_elementorpro_clear_forms_cache' ); add_action( 'deleted_post', 'adfoin_elementorpro_clear_forms_cache' ); add_action( 'trashed_post', 'adfoin_elementorpro_clear_forms_cache' ); function adfoin_elementorpro_find_element_recursive( $elements, $post_id ) { global $only_forms; foreach ( $elements as $element ) { if ( isset( $element['widgetType'] ) ) { if ( 'form' === $element['widgetType'] ) { $element['post_id'] = $post_id; $only_forms[] = $element; } } if ( !empty( $element['elements'] ) ) { adfoin_elementorpro_find_element_recursive( $element['elements'], $post_id ); } } } function adfoin_elementorpro_get_form_fields( $form_provider, $form_id ) { if ( $form_provider != 'elementorpro' ) { return; } $ids = explode( '_', $form_id ); $post_id = ( isset( $ids[0] ) ? $ids[0] : '' ); $widget_id = ( isset( $ids[1] ) ? $ids[1] : '' ); $form_fields = array(); // Resolve the form's fields defensively: the post may have been deleted, may // not be an Elementor document, or the form widget may no longer exist. if ( $post_id && $widget_id ) { $elementor = \ElementorPro\Plugin::elementor(); $document = $elementor->documents->get( $post_id ); if ( $document ) { $form = \ElementorPro\Modules\Forms\Module::find_element_recursive( $document->get_elements_data(), $widget_id ); if ( is_array( $form ) && isset( $form['settings']['form_fields'] ) && is_array( $form['settings']['form_fields'] ) ) { $form_fields = $form['settings']['form_fields']; } } } $fields = array(); foreach ( $form_fields as $single ) { $field_label = ''; if ( isset( $single['field_label'] ) ) { $field_label = $single['field_label']; } if ( !$field_label ) { if ( isset( $single['placeholder'] ) ) { $field_label = $single['placeholder']; } } if ( !$field_label ) { if ( isset( $single['field_type'] ) ) { $field_label = $single['field_type']; } } if ( adfoin_fs()->is_not_paying() ) { // Free plan: single line (text) + email fields only — matches the // submission handler and the upgrade notice. if ( isset( $single['field_type'] ) ) { if ( in_array( $single['field_type'], array('text', 'email'), true ) ) { $fields[$single['custom_id']] = $field_label; } } else { $fields[$single['custom_id']] = $field_label; } } } $fields['form_id'] = __( 'Form ID', 'advanced-form-integration' ); $special_tags = adfoin_get_special_tags(); if ( is_array( $fields ) && is_array( $special_tags ) ) { $fields = $fields + $special_tags; } return $fields; } function adfoin_elementorpro_get_form_name( $form_provider, $form_id ) { if ( $form_provider != 'elementorpro' ) { return; } $ids = explode( '_', $form_id ); $post_id = ( isset( $ids[0] ) ? $ids[0] : '' ); $widget_id = ( isset( $ids[1] ) ? $ids[1] : '' ); if ( !$post_id || !$widget_id ) { return ''; } $elementor = \ElementorPro\Plugin::elementor(); $document = $elementor->documents->get( $post_id ); if ( !$document ) { return ''; } $form = \ElementorPro\Modules\Forms\Module::find_element_recursive( $document->get_elements_data(), $widget_id ); return ( is_array( $form ) && isset( $form['settings']['form_name'] ) ? $form['settings']['form_name'] : '' ); } /** * Track integration IDs already dispatched during this request and return only * those not yet dispatched. Both the new_record trigger handler and the * "Advanced Form Integration" form action can match the same integration; this * (request-scoped) guard guarantees each fires at most once per submission. */ function adfoin_elementorpro_filter_dispatched( $records ) { static $dispatched = array(); if ( !is_array( $records ) ) { return array(); } $fresh = array(); foreach ( $records as $record ) { $id = ( isset( $record['id'] ) ? $record['id'] : null ); if ( null === $id ) { $fresh[] = $record; continue; } if ( !isset( $dispatched[$id] ) ) { $dispatched[$id] = true; $fresh[] = $record; } } return $fresh; } add_action( 'elementor_pro/forms/new_record', 'adfoin_elementorpro_submission', 10, 10 ); function adfoin_elementorpro_submission( $record, $form ) { if ( !isset( $_POST['post_id'] ) || !isset( $_POST['form_id'] ) ) { return; } global $wpdb; $post_id = ( isset( $_POST['post_id'] ) ? sanitize_text_field( wp_unslash( $_POST['post_id'] ) ) : '' ); $form_id = ( isset( $_POST['form_id'] ) ? sanitize_text_field( wp_unslash( $_POST['form_id'] ) ) : '' ); $integration = new Advanced_Form_Integration_Integration(); $saved_records = $integration->get_by_trigger( 'elementorpro', $post_id . '_' . $form_id ); if ( empty( $saved_records ) ) { $saved_records = $integration->get_by_trigger_partial( 'elementorpro', $form_id ); if ( empty( $saved_records ) ) { return; } } $posted_data = array(); $fields = $record->get( 'fields' ); foreach ( $fields as $field ) { if ( adfoin_fs()->is_not_paying() ) { if ( 'text' == $field['type'] || 'email' == $field['type'] ) { $posted_data[$field['id']] = adfoin_sanitize_text_or_array_field( $field['value'] ); } } } $post = get_post( $post_id, 'OBJECT' ); $special_tag_values = adfoin_get_special_tags_values( $post ); if ( is_array( $posted_data ) && is_array( $special_tag_values ) ) { $posted_data = $posted_data + $special_tag_values; } $posted_data['submission_date'] = current_time( 'mysql' ); $posted_data['user_ip'] = adfoin_get_user_ip(); $posted_data['form_id'] = $form_id; $posted_data['post_id'] = $post_id; // Skip integrations already dispatched this request (e.g. also handled by the // "Advanced Form Integration" form action) so nothing fires twice. $saved_records = adfoin_elementorpro_filter_dispatched( $saved_records ); if ( empty( $saved_records ) ) { return; } adfoin_dispatch_integrations( $saved_records, $posted_data ); return; } if ( adfoin_fs()->is_not_paying() ) { add_action( 'adfoin_trigger_extra_fields', 'adfoin_elementorpro_trigger_fields' ); } function adfoin_elementorpro_trigger_fields() { ?>