authorization_endpoint = self::authorization_endpoint; $this->token_endpoint = self::token_endpoint; $this->refresh_token_endpoint = self::refresh_token_endpoint; // Load legacy credentials for backward compatibility $this->load_legacy_credentials(); add_action( 'admin_init', array( $this, 'auth_redirect' ) ); add_action( 'rest_api_init', array( $this, 'create_webhook_route' ) ); add_filter( 'adfoin_action_providers', array( $this, 'adfoin_bigin_actions' ), 10, 1 ); add_filter( 'adfoin_settings_tabs', array( $this, 'adfoin_bigin_settings_tab' ), 10, 1 ); add_action( 'adfoin_settings_view', array( $this, 'adfoin_bigin_settings_view' ), 10, 1 ); add_action( 'adfoin_action_fields', array( $this, 'action_fields' ), 10, 1 ); add_action( 'wp_ajax_adfoin_get_bigin_users', array( $this, 'get_users' ), 10, 0 ); add_action( 'wp_ajax_adfoin_get_bigin_modules', array( $this, 'get_modules' ), 10, 0 ); add_action( 'wp_ajax_adfoin_get_bigin_module_fields', array( $this, 'get_fields' ) ); add_action( 'wp_ajax_adfoin_get_bigin_credentials', array( $this, 'get_credentials' ), 10, 0 ); add_filter( 'adfoin_get_credentials', array( $this, 'modify_credentials' ), 10, 2 ); add_action( 'wp_ajax_adfoin_save_bigin_credentials', array( $this, 'save_credentials' ), 10, 0 ); add_action( 'wp_ajax_adfoin_test_bigin_connection', array( $this, 'test_connection' ), 10, 0 ); } /** * Test a credential by hitting a minimal Bigin endpoint. Used by the * "Test Connection" button on the accounts table — gives the admin a * single-click signal that OAuth still works, before a real form is * submitted. */ public function test_connection() { adfoin_require_manage_options(); if ( ! wp_verify_nonce( $_POST['_nonce'] ?? '', 'advanced-form-integration' ) ) { wp_send_json_error( array( 'message' => __( 'Security check failed', 'advanced-form-integration' ) ) ); } $cred_id = isset( $_POST['credId'] ) ? sanitize_text_field( wp_unslash( $_POST['credId'] ) ) : ''; if ( ! $cred_id ) { wp_send_json_error( array( 'message' => __( 'Missing credential id', 'advanced-form-integration' ) ) ); } if ( ! $this->load_credentials( $cred_id ) ) { wp_send_json_error( array( 'message' => __( 'Credential not found', 'advanced-form-integration' ) ) ); } if ( empty( $this->access_token ) ) { wp_send_json_error( array( 'message' => __( 'Account not authorized', 'advanced-form-integration' ) ) ); } $response = $this->bigin_request( 'settings/modules' ); if ( is_wp_error( $response ) ) { wp_send_json_error( array( 'message' => $response->get_error_message() ) ); } $code = wp_remote_retrieve_response_code( $response ); if ( 200 !== (int) $code ) { $body = json_decode( wp_remote_retrieve_body( $response ), true ); $msg = is_array( $body ) && isset( $body['message'] ) ? $body['message'] : sprintf( 'HTTP %d', $code ); wp_send_json_error( array( 'message' => $msg ) ); } wp_send_json_success( array( 'message' => __( 'Connection OK', 'advanced-form-integration' ) ) ); } /** * Load legacy credentials from old option for backward compatibility */ protected function load_legacy_credentials() { $option = (array) maybe_unserialize( get_option( 'adfoin_bigin_keys' ) ); if ( isset( $option['data_center'] ) ) { $this->data_center = $option['data_center']; } if ( isset( $option['client_id'] ) ) { $this->client_id = $option['client_id']; } if ( isset( $option['client_secret'] ) ) { $this->client_secret = $option['client_secret']; } if ( isset( $option['access_token'] ) ) { $this->access_token = $option['access_token']; } if ( isset( $option['refresh_token'] ) ) { $this->refresh_token = $option['refresh_token']; } } /** * Load credentials for a specific account */ public function load_credentials( $cred_id ) { if ( empty( $cred_id ) ) { return false; } // Handle legacy credential ID if ( strpos( $cred_id, 'legacy_' ) === 0 ) { $this->load_legacy_credentials(); return true; } // Load from OAuth Manager $credentials = adfoin_read_credentials( 'bigin' ); foreach ( $credentials as $credential ) { if ( isset( $credential['id'] ) && $credential['id'] == $cred_id ) { $this->cred_id = $cred_id; $this->data_center = isset( $credential['data_center'] ) ? $credential['data_center'] : 'com'; $this->client_id = isset( $credential['client_id'] ) ? $credential['client_id'] : ''; $this->client_secret = isset( $credential['client_secret'] ) ? $credential['client_secret'] : ''; $this->access_token = isset( $credential['access_token'] ) ? $credential['access_token'] : ''; $this->refresh_token = isset( $credential['refresh_token'] ) ? $credential['refresh_token'] : ''; return true; } } return false; } public function create_webhook_route() { register_rest_route( 'advancedformintegration', '/bigin', array( 'methods' => 'GET', 'callback' => array( $this, 'get_webhook_data' ), 'permission_callback' => '__return_true' ) ); } public function get_webhook_data( $request ) { $params = $request->get_params(); $code = isset( $params['code'] ) ? trim( $params['code'] ) : ''; $raw_state = isset( $params['state'] ) ? trim( $params['state'] ) : ''; if ( ! $code ) { return; } // OAuth Manager flow: a state token is round-tripped. Validate it, // exchange the code for tokens, and close the popup. if ( $raw_state ) { $context = self::consume_oauth_state( $raw_state, 'bigin' ); $cred_id = $context ? $context['cred_id'] : ''; require_once plugin_dir_path( __FILE__ ) . '../../includes/class-adfoin-oauth-manager.php'; if ( ! $cred_id ) { // State was provided but couldn't be validated (expired, // already used, or user mismatch). Surface the failure in // the popup instead of falling through to the legacy // admin redirect — the state transient has already been // consumed and can't be recovered there. ADFOIN_OAuth_Manager::handle_callback_close_popup( false, __( 'OAuth state invalid or expired. Please try again.', 'advanced-form-integration' ) ); exit; } $this->cred_id = $cred_id; $credentials = adfoin_read_credentials( 'bigin' ); foreach ( $credentials as $value ) { if ( $value['id'] == $cred_id ) { $this->data_center = isset( $value['data_center'] ) ? $value['data_center'] : 'com'; $this->client_id = isset( $value['client_id'] ) ? $value['client_id'] : ''; $this->client_secret = isset( $value['client_secret'] ) ? $value['client_secret'] : ''; } } $response = $this->request_token( $code ); $success = false; $message = 'Unknown error'; if ( ! is_wp_error( $response ) && wp_remote_retrieve_response_code( $response ) == 200 ) { $body = json_decode( wp_remote_retrieve_body( $response ), true ); if ( isset( $body['access_token'] ) ) { $success = true; $message = 'Connected successfully!'; } else { $message = isset( $body['error'] ) ? $body['error'] : 'Token exchange failed.'; } } else { $message = is_wp_error( $response ) ? $response->get_error_message() : 'HTTP Error'; } ADFOIN_OAuth_Manager::handle_callback_close_popup( $success, $message ); exit; } // Legacy flow - redirect to admin (no state provided at all) $redirect_to = add_query_arg( array( 'service' => 'authorize', 'action' => 'adfoin_bigin_auth_redirect', 'code' => $code, ), admin_url( 'admin.php?page=advanced-form-integration' ) ); wp_safe_redirect( $redirect_to ); exit(); } public function adfoin_bigin_actions( $actions ) { $actions['bigin'] = array( 'title' => __( 'Bigin', 'advanced-form-integration' ), 'tasks' => array( 'subscribe' => __( 'Add new record', 'advanced-form-integration' ) ) ); return $actions; } public function adfoin_bigin_settings_tab( $providers ) { $providers['bigin'] = __( 'Bigin', 'advanced-form-integration' ); return $providers; } public function adfoin_bigin_settings_view( $current_tab ) { if( $current_tab != 'bigin' ) { return; } $redirect_uri = $this->get_redirect_uri(); // Define fields for OAuth Manager $fields = array( array( 'name' => 'data_center', 'label' => __( 'Data Center', 'advanced-form-integration' ), 'type' => 'select', 'required' => true, 'mask' => false, 'show_in_table' => true, 'options' => array( 'com' => 'zoho.com', 'eu' => 'zoho.eu', 'in' => 'zoho.in', 'com.cn' => 'zoho.com.cn', 'com.au' => 'zoho.com.au', 'jp' => 'zoho.jp', ), ), array( 'name' => 'client_id', 'label' => __( 'Client ID', 'advanced-form-integration' ), 'type' => 'text', 'required' => true, 'mask' => true, 'show_in_table' => true, ), array( 'name' => 'client_secret', 'label' => __( 'Client Secret', 'advanced-form-integration' ), 'type' => 'text', 'required' => false, 'mask' => true, 'show_in_table' => true, 'placeholder' => __( 'Leave blank to keep current', 'advanced-form-integration' ), ), ); // Instructions $instructions = '
    '; $instructions .= '
  1. ' . sprintf( __( 'Go to %s and create a Server-based Application.', 'advanced-form-integration' ), 'Zoho API Console' ) . '
  2. '; $instructions .= '
  3. ' . __( 'Insert a suitable Client Name and your website URL as Homepage URL.', 'advanced-form-integration' ) . '
  4. '; $instructions .= '
  5. ' . __( 'Copy the Redirect URI below and paste in Authorized Redirect URIs:', 'advanced-form-integration' ) . '
  6. '; $instructions .= '
  7. ' . esc_html( $redirect_uri ) . '
  8. '; $instructions .= '
  9. ' . __( 'Copy Client ID and Client Secret and paste in the Add Account form.', 'advanced-form-integration' ) . '
  10. '; $instructions .= '
  11. ' . __( 'Select the correct data center for your Zoho account.', 'advanced-form-integration' ) . '
  12. '; $instructions .= '
'; // Configuration $config = array( 'show_status' => true, 'enable_test' => true, 'modal_title' => __( 'Connect Bigin', 'advanced-form-integration' ), 'submit_text' => __( 'Save & Authorize', 'advanced-form-integration' ), ); // Render using OAuth Manager require_once plugin_dir_path( __FILE__ ) . '../../includes/class-adfoin-oauth-manager.php'; ADFOIN_OAuth_Manager::render_oauth_settings_view( 'bigin', 'Bigin', $fields, $instructions, $config ); } /** * Get credentials via AJAX * * safe_credentials_list() strips client_id/client_secret. We merge them * back so the OAuth Manager table can display them (masked client-side) * and the edit form can pre-fill them. */ public function get_credentials() { adfoin_require_manage_options(); if ( ! wp_verify_nonce( isset( $_POST['_nonce'] ) ? $_POST['_nonce'] : '', 'advanced-form-integration' ) ) { wp_send_json_error( array( 'message' => __( 'Security check failed', 'advanced-form-integration' ) ) ); } $list = $this->safe_credentials_list(); $raw = adfoin_read_credentials( 'bigin' ); if ( is_array( $raw ) ) { $by_id = array(); foreach ( $raw as $cred ) { if ( is_array( $cred ) && isset( $cred['id'] ) ) { $by_id[ (string) $cred['id'] ] = $cred; } } foreach ( $list as &$row ) { $id = isset( $row['id'] ) ? (string) $row['id'] : ''; if ( $id && isset( $by_id[ $id ] ) ) { // client_id is OK to ship to the browser — it appears in // OAuth auth URLs anyway. The table masks it client-side, // and the edit form needs it to pre-fill. if ( isset( $by_id[ $id ]['client_id'] ) ) { $row['client_id'] = $by_id[ $id ]['client_id']; } // client_secret stays out of the response entirely. The // edit form shows it as blank with a "leave blank to keep // current" placeholder; save_credentials preserves the // stored value when an empty client_secret is submitted. unset( $row['client_secret'] ); } } unset( $row ); } wp_send_json_success( $list ); } /** * Modify credentials to include legacy data for backward compatibility */ public function modify_credentials( $credentials, $platform ) { if ( 'bigin' == $platform && empty( $credentials ) ) { $option = (array) maybe_unserialize( get_option( 'adfoin_bigin_keys' ) ); if ( isset( $option['client_id'] ) && isset( $option['client_secret'] ) && ! empty( $option['client_id'] ) ) { $credentials[] = array( 'id' => 'legacy_123456', 'title' => __( 'Default Account (Legacy)', 'advanced-form-integration' ), 'data_center' => isset( $option['data_center'] ) ? $option['data_center'] : 'com', 'client_id' => $option['client_id'], 'client_secret' => $option['client_secret'], 'access_token' => isset( $option['access_token'] ) ? $option['access_token'] : '', 'refresh_token' => isset( $option['refresh_token'] ) ? $option['refresh_token'] : '', ); } } return $credentials; } /** * Save credentials via AJAX */ public function save_credentials() { adfoin_require_manage_options(); if ( ! wp_verify_nonce( $_POST['_nonce'], 'advanced-form-integration' ) ) { die( __( 'Security check Failed', 'advanced-form-integration' ) ); } $platform = 'bigin'; $credentials = adfoin_read_credentials( $platform ); if ( ! is_array( $credentials ) ) { $credentials = array(); } // Handle Deletion if ( isset( $_POST['delete_index'] ) ) { $index = intval( wp_unslash( $_POST['delete_index'] ) ); if ( isset( $credentials[ $index ] ) ) { // If deleting legacy credential, also clear the old option if ( isset( $credentials[ $index ]['id'] ) && strpos( $credentials[ $index ]['id'], 'legacy_' ) === 0 ) { delete_option( 'adfoin_bigin_keys' ); } array_splice( $credentials, $index, 1 ); adfoin_save_credentials( $platform, $credentials ); wp_send_json_success( array( 'message' => 'Deleted' ) ); } wp_send_json_error( __( 'Invalid index', 'advanced-form-integration' ) ); } // Handle Save/Update $id = isset( $_POST['id'] ) ? sanitize_text_field( wp_unslash( $_POST['id'] ) ) : ''; $title = isset( $_POST['title'] ) ? sanitize_text_field( wp_unslash( $_POST['title'] ) ) : ''; $data_center = isset( $_POST['data_center'] ) ? sanitize_text_field( wp_unslash( $_POST['data_center'] ) ) : 'com'; $client_id = isset( $_POST['client_id'] ) ? sanitize_text_field( wp_unslash( $_POST['client_id'] ) ) : ''; $client_secret = isset( $_POST['client_secret'] ) ? sanitize_text_field( wp_unslash( $_POST['client_secret'] ) ) : ''; if ( empty( $id ) ) { $id = wp_generate_uuid4(); } // Check if updating existing credential $found = false; $existing = null; foreach ( $credentials as $cred ) { if ( isset( $cred['id'] ) && $cred['id'] == $id ) { $existing = $cred; $found = true; break; } } // Defensive: an update submitted with empty client_id/client_secret // (can happen on legacy rows or stale form state, and is the normal // case for client_secret which we never ship to the browser) must // not wipe out the previously-saved values. if ( $existing ) { if ( '' === $client_id && ! empty( $existing['client_id'] ) ) { $client_id = $existing['client_id']; } if ( '' === $client_secret && ! empty( $existing['client_secret'] ) ) { $client_secret = $existing['client_secret']; } } else { // New account creation: both fields are mandatory. if ( '' === $client_id || '' === $client_secret ) { wp_send_json_error( array( 'message' => __( 'Client ID and Client Secret are required.', 'advanced-form-integration' ), ) ); } } $new_data = array( 'id' => $id, 'title' => $title, 'data_center' => $data_center, 'client_id' => $client_id, 'client_secret' => $client_secret, 'access_token' => '', 'refresh_token' => '', ); if ( $existing ) { // Preserve tokens if credentials haven't changed if ( isset( $existing['client_id'] ) && $existing['client_id'] == $client_id && isset( $existing['client_secret'] ) && $existing['client_secret'] == $client_secret && isset( $existing['data_center'] ) && $existing['data_center'] == $data_center ) { $new_data['access_token'] = isset( $existing['access_token'] ) ? $existing['access_token'] : ''; $new_data['refresh_token'] = isset( $existing['refresh_token'] ) ? $existing['refresh_token'] : ''; } foreach ( $credentials as &$cred ) { if ( isset( $cred['id'] ) && $cred['id'] == $id ) { $cred = $new_data; break; } } unset( $cred ); } else { $credentials[] = $new_data; } adfoin_save_credentials( $platform, $credentials ); // Generate Auth URL $scope = 'ZohoBigin.modules.ALL,ZohoBigin.org.ALL,ZohoBigin.settings.ALL,ZohoBigin.users.ALL,ZohoBigin.coql.READ'; $auth_endpoint = $this->authorization_endpoint; if ( $data_center && $data_center !== 'com' ) { $auth_endpoint = str_replace( 'com', $data_center, $this->authorization_endpoint ); } $auth_url = add_query_arg( array( 'response_type' => 'code', 'client_id' => $client_id, 'access_type' => 'offline', 'redirect_uri' => $this->get_redirect_uri(), 'scope' => $scope, 'state' => self::issue_oauth_state( 'bigin', $id ), ), $auth_endpoint ); wp_send_json_success( array( 'auth_url' => $auth_url ) ); } public function auth_redirect() { $action = isset( $_GET['action'] ) ? trim( $_GET['action'] ) : ''; $code = isset( $_GET['code'] ) ? trim( $_GET['code'] ) : ''; $state = isset( $_GET['state'] ) ? trim( $_GET['state'] ) : ''; $context = self::consume_oauth_state( $state, 'bigin' ); $state = $context ? $context['cred_id'] : ''; if ( 'adfoin_bigin_auth_redirect' == $action ) { // admin_init fires for every logged-in user; only an admin should // be able to complete this OAuth flow (CWE-862). if ( ! current_user_can( 'manage_options' ) ) { return; } if ( $code ) { // If state exists, use new credential system if ( $state ) { $this->cred_id = $state; $credentials = adfoin_read_credentials( 'bigin' ); foreach ( $credentials as $value ) { if ( $value['id'] == $state ) { $this->data_center = isset( $value['data_center'] ) ? $value['data_center'] : 'com'; $this->client_id = isset( $value['client_id'] ) ? $value['client_id'] : ''; $this->client_secret = isset( $value['client_secret'] ) ? $value['client_secret'] : ''; } } } $this->request_token( $code ); // For popup flow if ( $state ) { require_once plugin_dir_path( __FILE__ ) . '../../includes/class-adfoin-oauth-manager.php'; ADFOIN_OAuth_Manager::handle_callback_close_popup( true, 'Connected via Legacy Redirect' ); exit; } } wp_safe_redirect( admin_url( 'admin.php?page=advanced-form-integration-settings&tab=bigin' ) ); exit(); } } protected function request_token( $authorization_code ) { $tok_endpoint = $this->token_endpoint; if( $this->data_center && $this->data_center !== 'com' ) { $tok_endpoint = str_replace( 'com', $this->data_center, $this->token_endpoint ); } // Zoho's /oauth/v2/token requires credentials in the POST body — // Basic Auth is rejected with invalid_client. $request = array( 'timeout' => 30, 'body' => array( 'code' => $authorization_code, 'client_id' => $this->client_id, 'client_secret' => $this->client_secret, 'redirect_uri' => $this->get_redirect_uri(), 'grant_type' => 'authorization_code', ), ); $response = wp_remote_post( esc_url_raw( $tok_endpoint ), $request ); $response_code = (int) wp_remote_retrieve_response_code( $response ); $response_body = wp_remote_retrieve_body( $response ); $response_body = json_decode( $response_body, true ); if ( 401 == $response_code ) { // Unauthorized $this->access_token = null; $this->refresh_token = null; } else { $this->apply_token_response( $response_body ); } $this->save_data(); return $response; } protected function refresh_token() { $ref_endpoint = $this->refresh_token_endpoint; if( $this->data_center && $this->data_center !== 'com' ) { $ref_endpoint = str_replace( 'com', $this->data_center, $this->refresh_token_endpoint ); } $request = array( 'timeout' => 30, 'body' => array( 'refresh_token' => $this->refresh_token, 'client_id' => $this->client_id, 'client_secret' => $this->client_secret, 'grant_type' => 'refresh_token', ), ); $response = wp_remote_post( esc_url_raw( $ref_endpoint ), $request ); $response_code = (int) wp_remote_retrieve_response_code( $response ); $response_body = wp_remote_retrieve_body( $response ); $response_body = json_decode( $response_body, true ); if ( 401 == $response_code ) { // Unauthorized $this->access_token = null; $this->refresh_token = null; $this->mark_connection_failed( 'refresh_token_revoked' ); } else { $this->apply_token_response( $response_body ); } $this->save_data(); return $response; } public function action_fields() { ?> cred_id ) && strpos( $this->cred_id, 'legacy_' ) !== 0 ) { $this->persist_token_to_credential(); return; } // Legacy save method for backward compatibility $data = (array) maybe_unserialize( get_option( 'adfoin_bigin_keys' ) ); $option = array_merge( $data, array( 'data_center' => $this->data_center, 'client_id' => $this->client_id, 'client_secret' => $this->client_secret, 'access_token' => $this->access_token, 'refresh_token' => $this->refresh_token ) ); update_option( 'adfoin_bigin_keys', maybe_serialize( $option ) ); } protected function reset_data() { $this->data_center = 'com'; $this->client_id = ''; $this->client_secret = ''; $this->access_token = ''; $this->refresh_token = ''; $this->save_data(); } protected function get_redirect_uri() { return site_url( '/wp-json/advancedformintegration/bigin' ); } public function bigin_request($endpoint, $method = 'GET', $data = array(), $record = array() ) { $base_url = 'https://www.zohoapis.com/bigin/v2/'; // Target the host token precisely so the data-center swap can't touch // any other "com" substring (now or in a future endpoint path). if( $this->data_center && $this->data_center !== 'com' ) { $base_url = str_replace( 'zohoapis.com', 'zohoapis.' . $this->data_center, $base_url ); } $url = $base_url . $endpoint; $args = array( 'timeout' => 30, 'method' => $method, 'headers' => array( 'Accept' => 'application/json', 'Content-Type' => 'application/json; charset=utf-8', ), ); if ('POST' == $method || 'PUT' == $method) { if( $data ) { $args['body'] = wp_json_encode( $data ); } } $response = $this->remote_request($url, $args, $record ); return $response; } protected function remote_request( $url, $request = array(), $record = array() ) { // Shared refresh-and-retry: refreshes once per call on 401 and // rebuilds the Bearer header from the new token. $response = $this->request_with_token_refresh( $url, $request, null, $sent_args ); if( $record ) { adfoin_add_to_log( $response, $url, $sent_args, $record ); } return $response; } /* * Get Owners */ public function get_users() { // Security Check adfoin_require_manage_options(); if (! wp_verify_nonce( $_POST['_nonce'], 'advanced-form-integration' ) ) { die( __( 'Security check Failed', 'advanced-form-integration' ) ); } $cred_id = isset( $_POST['credId'] ) ? sanitize_text_field( wp_unslash( $_POST['credId'] ) ) : ''; if ( empty( $cred_id ) ) { wp_send_json_error( __( 'No account selected', 'advanced-form-integration' ) ); } // Load credentials for the selected account $this->load_credentials( $cred_id ); if ( empty( $this->access_token ) ) { wp_send_json_error( __( 'Account not connected', 'advanced-form-integration' ) ); } $response = $this->bigin_request( 'users?type=AdminUsers' ); $response_body = json_decode( wp_remote_retrieve_body( $response ), true ); if ( empty( $response_body ) ) { wp_send_json_error(); } if ( !empty( $response_body['users'] ) && is_array( $response_body['users'] ) ) { $users = array(); foreach ( $response_body['users'] as $value ){ $users[$value['id']] = $value['full_name']; } wp_send_json_success( $users ); } else { wp_send_json_error(); } } /* * Get Modules */ public function get_modules() { // Security Check adfoin_require_manage_options(); if (! wp_verify_nonce( $_POST['_nonce'], 'advanced-form-integration' ) ) { die( __( 'Security check Failed', 'advanced-form-integration' ) ); } $cred_id = isset( $_POST['credId'] ) ? sanitize_text_field( wp_unslash( $_POST['credId'] ) ) : ''; if ( empty( $cred_id ) ) { wp_send_json_error( __( 'No account selected', 'advanced-form-integration' ) ); } // Load credentials for the selected account $this->load_credentials( $cred_id ); if ( empty( $this->access_token ) ) { wp_send_json_error( __( 'Account not connected', 'advanced-form-integration' ) ); } $response = $this->bigin_request( 'settings/modules' ); $code = (int) wp_remote_retrieve_response_code( $response ); $response_body = json_decode( wp_remote_retrieve_body( $response ), true ); if ( 200 !== $code || empty( $response_body['modules'] ) || ! is_array( $response_body['modules'] ) ) { // Surface Bigin's own error (e.g. INVALID_TOKEN) instead of a bare // failure, so a wrong-data-center connection that "shows Connected // but pulls no data" tells the user what's actually wrong. wp_send_json_error( $this->bigin_error_message( $response_body, $code ) ); } $skip_list = array( 'Calls' ); $modules = array(); foreach ( $response_body['modules'] as $single ){ if( in_array( $single['api_name'], $skip_list ) ) { continue; } if( isset( $single['editable'] ) && true == $single['editable'] && 'Associated_Products' != $single['api_name'] ) { $modules[$single['api_name']] = $single['plural_label']; } } wp_send_json_success( $modules ); } /** * Build a human-readable message from a Bigin API error body so AJAX * handlers can tell the user why a fetch failed (rather than silently * returning an empty dropdown). Adds a data-center hint on auth failures, * which are nearly always a wrong DC selection. */ protected function bigin_error_message( $response_body, $code = 0 ) { $message = ''; if ( is_array( $response_body ) ) { if ( ! empty( $response_body['message'] ) ) { $message = $response_body['message']; } if ( ! empty( $response_body['code'] ) ) { $message = trim( $response_body['code'] . ( $message ? ': ' . $message : '' ) ); } } $is_auth = ( 401 === (int) $code ) || ( is_array( $response_body ) && isset( $response_body['code'] ) && 'INVALID_TOKEN' === $response_body['code'] ); if ( '' === $message && $code ) { $message = sprintf( __( 'Bigin API returned HTTP %d.', 'advanced-form-integration' ), $code ); } if ( $is_auth ) { $message = trim( $message . ' ' . __( 'Check that the selected Data Center matches your Bigin account.', 'advanced-form-integration' ) ); } return $message ? $message : __( 'Could not load data from Bigin.', 'advanced-form-integration' ); } /* * Get Module Fields */ function get_fields() { // Security Check adfoin_require_manage_options(); if (! wp_verify_nonce( $_POST['_nonce'], 'advanced-form-integration' ) ) { die( __( 'Security check Failed', 'advanced-form-integration' ) ); } $final_data = array(); $module = isset( $_POST['module'] ) ? $_POST['module'] : ''; $cred_id = isset( $_POST['credId'] ) ? sanitize_text_field( wp_unslash( $_POST['credId'] ) ) : ''; if( $module ) { // Load credentials for the selected account if ( $cred_id ) { $this->load_credentials( $cred_id ); } $response = $this->bigin_request( "settings/fields?module={$module}&type=all" ); $code = (int) wp_remote_retrieve_response_code( $response ); $body = json_decode( wp_remote_retrieve_body( $response ), true ); if( 200 !== $code || ! isset( $body['fields'] ) || ! is_array( $body['fields'] ) ) { wp_send_json_error( $this->bigin_error_message( $body, $code ) ); } if( isset( $body['fields'] ) && is_array( $body['fields'] ) ) { $suppression_list = array( 'Created_By', 'Modified_By', 'Created_Time', 'Modified_Time', 'Layout', 'Tag', 'Recurring_Activity', 'BEST_TIME', 'What_Id', 'Record_Image' ); foreach( $body['fields'] as $field ) { $helptext = ''; $data_type = $field['data_type']; $api_name = $field['api_name']; $display_label = $field['display_label']; if( isset( $field['field_read_only'] ) && $field['field_read_only'] == true ) { continue; } if( in_array( $api_name, $suppression_list ) ) { continue; } if( $field['custom_field'] == true ) { continue; } if( 'Contact_Name' == $api_name || 'Who_Id' == $api_name ) { $display_label = 'Contact Email'; } if( 'bigint' == $data_type && 'Participants' == $api_name ) { $helptext = 'Example: lead--john@example.com,contact--david@example.com'; } if( 'multiselectpicklist' == $data_type && 'Tax' == $api_name ) { $items = array(); if( isset( $field['pick_list_values'] ) && is_array( $field['pick_list_values'] ) ) { foreach( $field['pick_list_values'] as $pick ) { $items[] = $pick['display_value'] . ': ' . $pick['id']; } } $helptext = implode( ', ', $items ); } if( 'picklist' == $data_type && is_array( $field['pick_list_values'] ) ) { $picklist = wp_list_pluck( $field['pick_list_values'], 'actual_value' ); $helptext = implode( ' | ', $picklist ); } // Flag system-mandatory fields so users know what they MUST // map — e.g. Pipelines needs Deal_Name, Stage and Sub_Pipeline, // and omitting any of them makes Bigin reject the record. if( ! empty( $field['system_mandatory'] ) ) { $display_label .= ' (required)'; } array_push( $final_data, array( 'key' => $data_type . '__' . $api_name, 'value' => $display_label, 'description' => $helptext ) ); } if( 'Tasks' == $module || 'Events' == $module ) { array_push( $final_data, array( 'key' => 'text__$se_module', 'value' => 'Module Name', 'description' => 'Accounts | Pipelines' ) ); array_push( $final_data, array( 'key' => 'text__What_Id', 'value' => 'Module Record', 'description' => 'Account Name | Deal Name' ) ); } } } wp_send_json_success( $final_data ); } public function search_record( $module, $search_key, $search_value, $record ) { $result = array( 'id' => '', 'data' => array() ); // Escape single quotes so values like O'Brien don't break the COQL. $escaped_value = str_replace( "'", "\\'", (string) $search_value ); $body = array( 'select_query' => "select {$search_key}, id, Tag from {$module} where {$search_key} = '{$escaped_value}'", ); // Single fast lookup by default. The retry-on-empty below only helps // when Zoho's COQL index hasn't caught up to a write from a sibling // integration — but the common case is a genuinely-new contact/account, // where every retry misses and just burns wall-clock. With the old // default (4 attempts, sleep 2s) a single missing lookup cost ~10s, and // a deal mapping both a Contact and an Account lookup pushed form // submissions past 15s. The create paths read the new id straight from // the create response, so no post-create re-search is needed. Sites // that genuinely need the index-catch-up retry can opt back in via the // filters below. $delay = (int) apply_filters( 'adfoin_bigin_search_delay', 2, $module ); $attempts = (int) apply_filters( 'adfoin_bigin_search_attempts', 1, $module ); if ( $delay < 0 ) { $delay = 0; } if ( $attempts < 1 ) { $attempts = 1; } for ( $i = 0; $i < $attempts; $i++ ) { $response = $this->bigin_request( 'coql', 'POST', $body, $record ); $decoded = json_decode( wp_remote_retrieve_body( $response ), true ); if ( isset( $decoded['data'], $decoded['data'][0], $decoded['data'][0]['id'] ) ) { $result['id'] = $decoded['data'][0]['id']; $result['data'] = $decoded['data'][0]; return $result; } // Last attempt: don't sleep, return empty. if ( $i < $attempts - 1 && $delay > 0 ) { sleep( $delay ); } } return $result; } /** * Bigin's Pipelines module requires a Sub_Pipeline on EVERY record (it is * system-mandatory). When the user hasn't mapped one, fall back to the * org's default sub-pipeline so the deal isn't rejected with * MANDATORY_NOT_FOUND (a recurring "can't send a pipeline deal" report). * The result is cached per credential + data center so this doesn't add a * settings/fields round-trip to every submission. */ public function get_default_sub_pipeline( $module = 'Pipelines' ) { $cache_key = 'adfoin_bigin_subpipe_' . md5( (string) $this->cred_id . '|' . (string) $this->data_center . '|' . $module ); $cached = get_transient( $cache_key ); if ( false !== $cached ) { return $cached; } $default = ''; $response = $this->bigin_request( "settings/fields?module={$module}&type=all" ); $body = json_decode( wp_remote_retrieve_body( $response ), true ); if ( isset( $body['fields'] ) && is_array( $body['fields'] ) ) { foreach ( $body['fields'] as $field ) { if ( 'Sub_Pipeline' !== ( isset( $field['api_name'] ) ? $field['api_name'] : '' ) ) { continue; } if ( ! empty( $field['default_value'] ) ) { $default = $field['default_value']; break; } if ( ! empty( $field['pick_list_values'] ) && is_array( $field['pick_list_values'] ) ) { foreach ( $field['pick_list_values'] as $pick ) { $val = isset( $pick['actual_value'] ) ? $pick['actual_value'] : ''; if ( $val && '-None-' !== $val ) { $default = $val; break; } } } break; } } // Cache even an empty result (briefly) so a misconfigured org doesn't // refetch on every submission; a real value is cached for longer. set_transient( $cache_key, $default, $default ? 12 * HOUR_IN_SECONDS : 5 * MINUTE_IN_SECONDS ); return $default; } } $bigin = ADFOIN_Bigin::get_instance(); add_action( 'adfoin_bigin_job_queue', 'adfoin_bigin_job_queue', 10, 1 ); function adfoin_bigin_job_queue( $data ) { adfoin_bigin_send_data( $data['record'], $data['posted_data'] ); } /* * Handles sending data to Bigin API */ function adfoin_bigin_send_data( $record, $posted_data ) { $record_data = json_decode( $record['data'], true ); if ( adfoin_check_conditional_logic( $record_data['action_data']['cl'] ?? array(), $posted_data ) ) { return; } $data = $record_data['field_data']; $cred_id = isset( $data['credId'] ) ? $data['credId'] : ''; $owner = isset( $data['userId'] ) ? $data['userId'] : ''; $module = isset( $data['moduleId'] ) ? $data['moduleId'] : ''; $task = $record['task']; // Backward compatibility: If no credId, try to get first available credential if ( empty( $cred_id ) ) { $credentials = adfoin_read_credentials( 'bigin' ); if ( ! empty( $credentials ) && is_array( $credentials ) ) { $first_credential = reset( $credentials ); $cred_id = isset( $first_credential['id'] ) ? $first_credential['id'] : ''; } } unset( $data['credId'] ); unset( $data['userId'] ); unset( $data['moduleId'] ); if( $task == 'subscribe' ) { $bigin = ADFOIN_Bigin::get_instance(); // Load credentials for the selected account if ( $cred_id ) { $bigin->load_credentials( $cred_id ); } $holder = array(); $account_id = ''; $contact_id = ''; $campaign_id = ''; $task_module = ''; $account_lookups = array( 'Parent_Account', 'Account_Name' ); $contact_lookups = array( 'Contact_Name', 'Who_Id', 'Related_To' ); $campaign_lookups = array( 'Parent_Campaign', 'Campaign_Source' ); foreach ( $data as $key => $value ) { list( $data_type, $original_key ) = explode( '__', $key ); $value = adfoin_get_parsed_values( $value, $posted_data ); if( 'datetime' == $data_type && $value ) { // if( 'Start_DateTime' == $original_key || 'End_DateTime' == $original_key ) { $timezone = wp_timezone(); $date = date_create( $value, $timezone ); if( $date ) { $value = date_format( $date, 'c' ); } // } } if( 'multiselectpicklist' == $data_type && $value ) { if( 'Tax' == $original_key ) { $formatted_tax_ids = array(); $tax_ids = explode( ',', $value ); foreach( $tax_ids as $tax_id ) { array_push( $formatted_tax_ids, array( 'id' => $tax_id ) ); } $value = $formatted_tax_ids; } } if( 'bigint' == $data_type && $value ) { if( 'Participants' == $original_key ) { $participants = array(); $raw_participants = explode( ',', $value ); foreach( $raw_participants as $single ) { list( $type, $email ) = explode( '--', $single ); if( 'contact' == $type ) { $participant_id = $bigin->search_record( 'Contacts', 'Email', $email, $record )['id']; if( $participant_id ) { array_push( $participants, array( 'type' => 'contact', 'participant' => $participant_id ) ); } } } $value = $participants; } } if( 'lookup' == $data_type && $value ) { if( in_array( $original_key, $account_lookups ) ) { $account_id = $bigin->search_record( 'Accounts', 'Account_Name', $value, $record )['id']; if( ! $account_id ) { // Auto-create the Account when missing so the record // isn't left unlinked (parity with Bigin [PRO]). $return = $bigin->bigin_request( 'Accounts', 'POST', array( 'data' => array( array( 'Account_Name' => $value, 'owner' => $owner ) ) ), $record ); $body = json_decode( wp_remote_retrieve_body( $return ), true ); $account_id = isset( $body['data'], $body['data'][0], $body['data'][0]['details'], $body['data'][0]['details']['id'] ) ? $body['data'][0]['details']['id'] : ''; } if( $account_id ) { $value = $account_id; } } if( in_array( $original_key, $contact_lookups ) ) { if ( ! is_email( $value ) ) { continue; } $contact_id = $bigin->search_record( 'Contacts', 'Email', $value, $record )['id']; if( ! $contact_id ) { // Auto-create when missing so the deal isn't left // unlinked. Mirrors the Pro behavior for Accounts. $local = strstr( $value, '@', true ); $last_name = $local ?: $value; $contact_payload = array( 'data' => array( array( 'Email' => $value, 'Last_Name' => $last_name, 'owner' => $owner, ) ), 'duplicate_check_fields' => array( 'Email' ), ); $return = $bigin->bigin_request( 'Contacts/upsert', 'POST', $contact_payload, $record ); $body = json_decode( wp_remote_retrieve_body( $return ), true ); $contact_id = isset( $body['data'], $body['data'][0], $body['data'][0]['details'], $body['data'][0]['details']['id'] ) ? $body['data'][0]['details']['id'] : ''; } if( $contact_id ) { $value = $contact_id; } } if( in_array( $original_key, $campaign_lookups ) ) { $campaign_id = $bigin->search_record( 'Campaigns', 'Campaign_Name', $value, $record )['id']; if( $campaign_id ) { $value = $campaign_id; } } if( 'Product_Name' == $original_key ) { $product_id = $bigin->search_record( 'Products', 'Product_Name', $value, $record )['id']; if( $product_id ) { $value = $product_id; } } if( 'Deal_Name' == $original_key ) { // Bigin's deal module is "Pipelines" (not "Deals" as in // Zoho CRM); querying "Deals" via COQL errors out. $deal_id = $bigin->search_record( 'Pipelines', 'Deal_Name', $value, $record )['id']; if( $deal_id ) { $value = $deal_id; } } if( 'Reporting_To' == $original_key && $account_id ) { $contacts_response = $bigin->bigin_request( 'Accounts/' . $account_id . '/Contacts?fields=id,First_Name,Last_Name' ); $contacts_body = json_decode( wp_remote_retrieve_body( $contacts_response ), true ); if( isset( $contacts_body['data'] ) && is_array( $contacts_body['data'] ) ) { foreach( $contacts_body['data'] as $contact ) { $contact_name = $contact['First_Name'] . ' ' . $contact['Last_Name']; $contact_id = $contact_name == $value ? $contact['id'] : ''; if( $contact_id ) { $value = $contact_id; } } } } } if( 'boolean' == $data_type ) { if( strtolower( $value ) == 'true' ) { $value = true; } else { $value = false; } } if( '$se_module' == $original_key ) { $task_module = $value; } if( 'What_Id' == $original_key ) { if( 'Accounts' == $task_module ) { $account_id = $bigin->search_record( 'Accounts', 'Account_Name', $value, $record )['id']; if( $account_id ) { $value = $account_id; } } } $holder[$original_key] = $value; } if( $owner ) { $holder['Owner'] = "{$owner}"; } if( $module && $holder ) { // Pipelines records require a system-mandatory Sub_Pipeline. If the // user didn't map one, default to the org's sub-pipeline so the deal // isn't rejected with MANDATORY_NOT_FOUND. if ( 'Pipelines' === $module && empty( $holder['Sub_Pipeline'] ) ) { $default_sub_pipeline = $bigin->get_default_sub_pipeline(); if ( $default_sub_pipeline ) { $holder['Sub_Pipeline'] = $default_sub_pipeline; } } $request_data = array( 'data' => array( array_filter( $holder ) ) ); $return = $bigin->bigin_request( $module . '/upsert', 'POST', $request_data, $record ); } } return; }