<?php

class ADFOIN_Zohosheet extends Advanced_Form_Integration_OAuth2 {

    protected $platform_slug = 'zohosheet';

    const authorization_endpoint = 'https://accounts.zoho.com/oauth/v2/auth';
    const token_endpoint         = 'https://accounts.zoho.com/oauth/v2/token';
    const refresh_token_endpoint = 'https://accounts.zoho.com/oauth/v2/token';

    public $data_center;
    private static $instance;

    public static function get_instance() {

        if ( empty( self::$instance ) ) {
            self::$instance = new self;
        }

        return self::$instance;
    }

    public function __construct() {

        $this->authorization_endpoint = self::authorization_endpoint;
        $this->token_endpoint         = self::token_endpoint;
        $this->refresh_token_endpoint = self::refresh_token_endpoint;

        add_action( 'admin_init', array( $this, 'auth_redirect' ) );
        add_filter( 'adfoin_action_providers', array( $this, 'adfoin_zohosheet_actions' ), 10, 1 );
        add_filter( 'adfoin_settings_tabs', array( $this, 'adfoin_zohosheet_settings_tab' ), 10, 1 );
        add_action( 'adfoin_settings_view', array( $this, 'adfoin_zohosheet_settings_view' ), 10, 1 );
        add_action( 'adfoin_action_fields', array( $this, 'action_fields' ), 10, 1 );
        add_action( 'wp_ajax_adfoin_get_zohosheet_workbooks', array( $this, 'get_workbooks' ), 10, 0 );
        add_action( 'wp_ajax_adfoin_get_zohosheet_worksheets', array( $this, 'get_worksheets' ), 10, 0 );
        add_action( 'wp_ajax_adfoin_get_zohosheet_fields', array( $this, 'get_fields' ) );
        add_action( 'wp_ajax_adfoin_get_zohosheet_credentials', array( $this, 'get_credentials' ), 10, 0 );
        add_filter( 'adfoin_get_credentials', array( $this, 'modify_credentials' ), 10, 2);
        add_action( 'wp_ajax_adfoin_save_zohosheet_credentials', array( $this, 'save_credentials' ), 10, 0 );
        add_action( 'wp_ajax_adfoin_test_zohosheet_connection', array( $this, 'test_connection' ), 10, 0 );
        add_action( 'rest_api_init', array( $this, 'create_webhook_route' ) );
    }

    public function create_webhook_route() {
        register_rest_route( 'advancedformintegration', '/zohosheet',
            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'] ) : '';
        $state = isset( $params['state'] ) ? trim( $params['state'] ) : '';
        $context = self::consume_oauth_state( $state, 'zohosheet' );
        $state   = $context ? $context['cred_id'] : '';
        $this->cred_id = $state;

        if ( $code ) {
            // This is the REST API callback.
            // We need to process the token and then return HTML to close the popup.
            
            // 1. Set credentials context
            $zoho_credentials = adfoin_read_credentials( 'zohosheet' );
            foreach( $zoho_credentials as $value ) {
                if( $value['id'] == $state ) {
                    $this->data_center   = isset( $value['data_center'] ) ? $value['data_center'] : ( $value['dataCenter'] ?? 'com' );
                    $this->client_id     = isset( $value['client_id'] ) ? $value['client_id'] : ( $value['clientId'] ?? '' );
                    $this->client_secret = isset( $value['client_secret'] ) ? $value['client_secret'] : ( $value['clientSecret'] ?? '' );
                    $this->update_oauth_endpoints( $this->data_center );
                }
            }

            // 2. Request Token
            $response = $this->request_token( $code );
            
            // 3. Check success
            $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';
            }

            // 4. Output Close Popup HTML
            require_once plugin_dir_path( __FILE__ ) . '../../includes/class-adfoin-oauth-manager.php';
            ADFOIN_OAuth_Manager::handle_callback_close_popup( $success, $message );
            exit;
        }
    }

    public function adfoin_zohosheet_actions( $actions ) {

        $actions['zohosheet'] = array(
            'title' => __( 'Zoho Sheet', 'advanced-form-integration' ),
            'tasks' => array(
                'add_row'   => __( 'Add new record', 'advanced-form-integration' )
            )
        );

        return $actions;
    }

    /**
     * Verify an account's tokens by hitting a cheap authenticated endpoint.
     */
    public function test_connection() {
        $this->run_test_connection_ajax( function () {
            return $this->zohosheet_request( 'workbooks?method=workbook.list' );
        } );
    }

    function get_credentials() {
        adfoin_verify_nonce();

        wp_send_json_success( $this->safe_credentials_list() );
    }

    function modify_credentials( $credentials, $platform ) {

        if ( 'zohosheet' == $platform && empty( $credentials ) ) {
            $option = (array) maybe_unserialize( get_option( 'adfoin_zohosheet_keys' ) );

            if ( isset( $option['data_center'] ) && isset( $option['client_id'] ) && isset( $option['client_secret'] ) ) {
                $credentials[] = array(
                    'id'            => 'legacy',
                    'title'         => __( 'Legacy Account', 'advanced-form-integration' ),
                    'data_center'   => $option['data_center'],
                    '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 Zoho Sheet credentials
    */
    function save_credentials() {
        // Security Check
        adfoin_verify_nonce();

        $platform = 'zohosheet';
        $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] ) ) {
                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'] ) ) : '';
        $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'] ) ) : '';
        $data_center = isset( $_POST['data_center'] ) ? sanitize_text_field( wp_unslash( $_POST['data_center'] ) ) : 'com';

        if ( empty( $id ) ) {
            $id = wp_generate_uuid4();
            $new_entry = true;
        } else {
            $new_entry = false;
        }

        // Preserve previously-saved values when the edit form submits an
        // empty client_id/client_secret.
        $existing = null;
        foreach ( $credentials as $cred_check ) {
            if ( isset( $cred_check['id'] ) && $cred_check['id'] == $id ) {
                $existing = $cred_check;
                break;
            }
        }
        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'];
            }
        } elseif ( '' === $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,
            'client_id' => $client_id,
            'client_secret' => $client_secret,
            'data_center' => $data_center,
            'access_token' => '', // Reset on save/update
            'refresh_token' => ''
        );

        // If updating, preserve tokens if client ID/Secret haven't changed
        $found = false;
        foreach ( $credentials as &$cred ) {
            if ( $cred['id'] == $id ) {
                // Preserve tokens if not explicitly clearing them
                if ( isset($cred['client_id']) && $cred['client_id'] == $client_id && 
                     isset($cred['client_secret']) && $cred['client_secret'] == $client_secret && 
                     isset($cred['data_center']) && $cred['data_center'] == $data_center ) {
                     $new_data['access_token'] = isset($cred['access_token']) ? $cred['access_token'] : '';
                     $new_data['refresh_token'] = isset($cred['refresh_token']) ? $cred['refresh_token'] : '';
                }
                $cred = $new_data;
                $found = true;
                break;
            }
        }

        if ( ! $found ) {
            $credentials[] = $new_data;
        }

        adfoin_save_credentials( $platform, $credentials );

        // Generate Auth URL
        $redirect_uri = $this->get_redirect_uri();
        $scope = 'ZohoSheet.dataAPI.READ,ZohoSheet.dataAPI.UPDATE';
        
        $auth_endpoint = $this->get_oauth_endpoint( 'auth', $data_center );

        $auth_url = add_query_arg( array(
            'response_type' => 'code',
            'client_id'     => $client_id,
            'access_type'   => 'offline',
            'redirect_uri'  => $redirect_uri,
            'scope'         => $scope,
            'state'         => self::issue_oauth_state( 'zohosheet', $id )
        ), $auth_endpoint );

        wp_send_json_success( array( 'auth_url' => $auth_url ) );
    }

    public function adfoin_zohosheet_settings_tab( $providers ) {
        $providers['zohosheet'] = __( 'Zoho Sheet', 'advanced-form-integration' );

        return $providers;
    }

    public function adfoin_zohosheet_settings_view( $current_tab ) {
        if( $current_tab != 'zohosheet' ) {
            return;
        }
        
        $redirect_uri = $this->get_redirect_uri();
        
        // Define fields
        $fields = array(
            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' ),
            ),
            array(
                'name'          => 'data_center',
                'label'         => __( 'Data Center', 'advanced-form-integration' ),
                'type'          => 'select',
                'required'      => false,
                'show_in_table' => false,
                'options'       => array(
                    'com'          => 'zoho.com',
                    'eu'           => 'zoho.eu',
                    'in'           => 'zoho.in',
                    'com.cn'       => 'zoho.com.cn',
                    'com.au'       => 'zoho.com.au',
                    'jp'           => 'zoho.jp',
                    'sa'           => 'zoho.sa',
                    'zohocloud.ca' => 'zohocloud.ca',
                ),
            ),
        );
        
        // Instructions
        $instructions = '<ol class="afi-instructions-list">';
        $instructions .= '<li>' . sprintf( __('Go to %s.', 'advanced-form-integration'), '<a target="_blank" rel="noopener noreferrer" href="https://api-console.zoho.com/">Zoho Sheet API Console</a>' ) . '</li>';
        $instructions .= '<li>' . __('Click Add Client, Choose Server-based Applications.', 'advanced-form-integration') . '</li>';
        $instructions .= '<li>' . __('Insert a suitable Client Name.', 'advanced-form-integration') . '</li>';
        $instructions .= '<li>' . __('Insert URL of your website as Homepage URL.', 'advanced-form-integration') . '</li>';
        $instructions .= '<li>' . __('Copy the Redirect URI below and paste in Authorized Redirect URIs input box.', 'advanced-form-integration') . '</li>';
        $instructions .= '<li><code class="afi-code-block">' . esc_html( $redirect_uri ) . '</code></li>';
        $instructions .= '<li>' . __('Click CREATE.', 'advanced-form-integration') . '</li>';
        $instructions .= '<li>' . __('Copy Client ID and Client Secret and paste in the Add Account form.', 'advanced-form-integration') . '</li>';
        $instructions .= '</ol>';
        
        // Configuration
        $config = array(
            'show_status'  => true,
            'enable_test'  => true,
            'modal_title'  => __( 'Connect Zoho Sheet', '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( 'zohosheet', 'Zoho Sheet', $fields, $instructions, $config );
    }

    protected function request_token( $authorization_code ) {

        $tok_endpoint = $this->get_oauth_endpoint( 'token', $this->data_center );

        // Zoho's /oauth/v2/token requires credentials in the POST body.
        // Basic Auth here returns 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 = json_decode( wp_remote_retrieve_body( $response ), true );

        if ( 401 == $response_code ) {
            $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->get_oauth_endpoint( 'token', $this->data_center );

        $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 = json_decode( wp_remote_retrieve_body( $response ), true );

        if ( 401 == $response_code ) {
            $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 get_credentials_list() {
        $html = '';
        $credentials = adfoin_read_credentials( 'zohosheet' );
    
        foreach( $credentials as $option ) {
            $html .= '<option value="'. $option['id'] .'">' . $option['title'] . '</option>';
        }
    
        echo $html;
    }

    function get_credentials_by_id( $cred_id ) {
        $credentials     = array();
        $all_credentials = adfoin_read_credentials( 'zohosheet' );
    
        if( is_array( $all_credentials ) && ! empty( $all_credentials ) ) {
            $credentials = $all_credentials[0];
    
            foreach( $all_credentials as $single ) {
                if( $cred_id && $cred_id == $single['id'] ) {
                    $credentials = $single;
                }
            }
        }
    
        return $credentials;
    }

    public function action_fields() {
        ?>
        <script type="text/template" id="zohosheet-action-template">
            <table class="form-table">
                <tr valign="top" v-if="action.task == 'add_row'">
                    <th scope="row">
                        <?php esc_attr_e( 'Map Fields', 'advanced-form-integration' ); ?>
                    </th>
                    <td scope="row">
                    <div class="afi-spinner" v-bind:class="{'is-active': fieldLoading}"></div>
                    </td>
                </tr>

                <tr valign="top" class="alternate" v-if="action.task == 'add_row'">
                    <td scope="row-title">
                        <label for="tablecell">
                            <?php esc_attr_e( 'Zoho Account', 'advanced-form-integration' ); ?>
                        </label>
                    </td>
                    <td>
                        <select name="fieldData[credId]" v-model="fielddata.credId" @change="getWorkbooks">
                        <option value=""> <?php _e( 'Select Account...', 'advanced-form-integration' ); ?> </option>
                            <option v-for="cred in credentialsList" :value="cred.id">{{ cred.title }}</option>
                        </select>
                        <span v-if="credentialLoading"><img src="<?php echo esc_url( admin_url( 'images/spinner-2x.gif' ) ); ?>" style="width:20px;vertical-align:middle;" /></span>
                        <a href="<?php echo admin_url( 'admin.php?page=advanced-form-integration-settings&tab=zohosheet' ); ?>" target="_blank" style="margin-left: 10px; text-decoration: none;">
                            <span class="dashicons dashicons-admin-settings" style="margin-top: 3px;"></span> <?php esc_html_e( 'Manage Accounts', 'advanced-form-integration' ); ?>
                        </a>
                    </td>
                </tr>

                <tr valign="top" class="alternate" v-if="action.task == 'add_row'">
                    <td scope="row-title">
                        <label for="tablecell">
                            <?php esc_attr_e( 'Workbook', 'advanced-form-integration' ); ?>
                        </label>
                    </td>
                    <td>
                        <select name="fieldData[workbookId]" v-model="fielddata.workbookId" required="required" @change="getWorksheets">
                            <option value=""> <?php _e( 'Select Workbook...', 'advanced-form-integration' ); ?> </option>
                            <option v-for="(item, index) in fielddata.workbooks" :value="index" > {{item}}  </option>
                        </select>
                        <div class="afi-spinner" v-bind:class="{'is-active': workbookLoading}"></div>
                    </td>
                </tr>

                <tr valign="top" class="alternate" v-if="action.task == 'add_row'">
                    <td scope="row-title">
                        <label for="tablecell">
                            <?php esc_attr_e( 'Worksheet', 'advanced-form-integration' ); ?>
                        </label>
                    </td>
                    <td>
                        <select name="fieldData[worksheetId]" v-model="fielddata.worksheetId" required="required" @change="getFields">
                            <option value=""> <?php _e( 'Select Worksheet...', 'advanced-form-integration' ); ?> </option>
                            <option v-for="(item, index) in fielddata.worksheets" :value="index" > {{item}}  </option>
                        </select>
                        <div class="afi-spinner" v-bind:class="{'is-active': worksheetLoading}"></div>
                    </td>
                </tr>

                <editable-field v-for="field in fields" v-bind:key="field.value" v-bind:field="field" v-bind:trigger="trigger" v-bind:action="action" v-bind:fielddata="fielddata"></editable-field>
                <?php adfoin_pro_feature_notice( 'add_row', 'Zoho Sheet [PRO]', 'updating existing rows' ); ?>

            </table>
        </script>
        <?php
    }

    public function auth_redirect() {

        $action = isset( $_GET['action'] ) ? sanitize_text_field( wp_unslash( $_GET['action'] ) ) : '';

        if ( 'adfoin_zohosheet_auth_redirect' == $action ) {
            $code   = isset( $_GET['code'] ) ? sanitize_text_field( wp_unslash( $_GET['code'] ) ) : '';
            $state = isset( $_GET['state'] ) ? sanitize_text_field( wp_unslash( $_GET['state'] ) ) : '';
            $context = self::consume_oauth_state( $state, 'zohosheet' );
            $state   = $context ? $context['cred_id'] : '';

            if( $state && $code ) {
                $this->cred_id = $state;
                $zoho_credentials = adfoin_read_credentials( 'zohosheet' );
                foreach( $zoho_credentials as $value ) {
                    if( $value['id'] == $state ) {
                        $this->data_center   = isset( $value['data_center'] ) ? $value['data_center'] : ( $value['dataCenter'] ?? 'com' );
                        $this->client_id     = isset( $value['client_id'] ) ? $value['client_id'] : ( $value['clientId'] ?? '' );
                        $this->client_secret = isset( $value['client_secret'] ) ? $value['client_secret'] : ( $value['clientSecret'] ?? '' );
                        $this->update_oauth_endpoints( $this->data_center );
                    }
                }
                
                $this->request_token( $code );
                
                require_once plugin_dir_path( __FILE__ ) . '../../includes/class-adfoin-oauth-manager.php';
                ADFOIN_OAuth_Manager::handle_callback_close_popup( true, 'Connected via Legacy Redirect' );
            }
        }
    }

    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/zohosheet' );
    }

    /**
     * Resolve Zoho Accounts base URL by data center.
     */
    protected function get_accounts_base( $data_center = 'com' ) {
        $map = array(
            'com'          => 'https://accounts.zoho.com',
            'eu'           => 'https://accounts.zoho.eu',
            'in'           => 'https://accounts.zoho.in',
            'com.cn'       => 'https://accounts.zoho.com.cn',
            'com.au'       => 'https://accounts.zoho.com.au',
            'jp'           => 'https://accounts.zoho.jp',
            'sa'           => 'https://accounts.zoho.sa',
            'zohocloud.ca' => 'https://accounts.zohocloud.ca',
            'ca'           => 'https://accounts.zohocloud.ca',
        );

        return $map[ $data_center ] ?? $map['com'];
    }

    /**
     * Resolve full OAuth endpoint (auth/token) by data center.
     */
    protected function get_oauth_endpoint( $path = 'auth', $data_center = '' ) {
        $base = $this->get_accounts_base( $data_center ? $data_center : $this->data_center );
        return trailingslashit( $base ) . 'oauth/v2/' . $path;
    }

    /**
     * Update stored OAuth endpoints to match a data center.
     */
    protected function update_oauth_endpoints( $data_center ) {
        $this->authorization_endpoint = $this->get_oauth_endpoint( 'auth', $data_center );
        $this->token_endpoint         = $this->get_oauth_endpoint( 'token', $data_center );
        $this->refresh_token_endpoint = $this->token_endpoint;
    }

    public function set_credentials( $cred_id ) {
        $credentials = $this->get_credentials_by_id( $cred_id );

        if( empty( $credentials ) ) {
            return;
        }

        $this->data_center   = $credentials['data_center'] ?? ( $credentials['dataCenter'] ?? 'com' );
        $this->client_id     = $credentials['client_id'] ?? ( $credentials['clientId'] ?? '' );
        $this->client_secret = $credentials['client_secret'] ?? ( $credentials['clientSecret'] ?? '' );
        $this->access_token  = $credentials['access_token'] ?? ( $credentials['accessToken'] ?? '' );
        $this->refresh_token = $credentials['refresh_token'] ?? ( $credentials['refreshToken'] ?? '' );
        $this->cred_id       = $credentials['id'];
        $this->update_oauth_endpoints( $this->data_center );
    }

    public function zohosheet_request($endpoint, $method = 'GET', $data = array(), $record = array() ) {

        $base_url = 'https://sheet.zoho.com/api/v2/';
    
    
        if( $this->data_center && $this->data_center !== 'com' ) {
            $dc_tld   = ( 'zohocloud.ca' === $this->data_center || 'ca' === $this->data_center ) ? 'ca' : $this->data_center;
            $base_url = str_replace( 'zoho.com', 'zoho.' . $dc_tld, $base_url );
        }
    
        $url = $base_url . $endpoint;
    
        $args = array(
            'method'  => $method,
            'timeout' => 30,
            'headers' => array(
                'Content-Type' => 'application/json'
            ),
        );
    
        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() ) {
    
        static $refreshed = false;
    
        $request = wp_parse_args( $request, [ ] );
    
        $request['headers'] = array_merge(
            $request['headers'],
            array( 'Authorization' => $this->get_http_authorization_header( 'bearer' ), )
            
        );
    
        $response = wp_remote_request( $url, $request );
    
        if ( 401 === wp_remote_retrieve_response_code( $response )
            and !$refreshed
        ) {
            $this->refresh_token();
            $refreshed = true;
    
            $response = $this->remote_request( $url, $request );
        }
    
        // Retry on rate limiting (HTTP 429), honouring Retry-After.
        $rl_attempts = 0;
        while ( 429 === wp_remote_retrieve_response_code( $response ) && $rl_attempts < 2 ) {
            $retry_after = (int) wp_remote_retrieve_header( $response, 'retry-after' );
            $retry_after = ( $retry_after > 0 && $retry_after <= 10 ) ? $retry_after : 3;
            sleep( $retry_after );
            $rl_attempts++;
            $response = wp_remote_request( esc_url_raw( $url ), $request );
        }

        if( $record ) {
            adfoin_add_to_log( $response, $url, $request, $record );
        }
    
        return $response;
    }

    /*
    * Get zohosheet Workbook List
    */
    public function get_workbooks() {
        // Security Check
        adfoin_verify_nonce();

        $cred_id = isset( $_POST['credId'] ) ? sanitize_text_field( wp_unslash( $_POST['credId'] ) ) : '';
        $this->set_credentials( $cred_id );

        $data = $this->zohosheet_request( 'workbooks?method=workbook.list' );

        if( is_wp_error( $data ) ) {
            wp_send_json_error();
        }

        $body      = json_decode( wp_remote_retrieve_body( $data ), true );
        $workbooks = array();

        if( isset( $body['workbooks'] ) && is_array( $body['workbooks'] ) ) {
            foreach( $body['workbooks'] as $workbook ) {
                $workbooks[$workbook['resource_id']] = $workbook['workbook_name'];
            }
        }

        wp_send_json_success( $workbooks );
    }

    /*
    * Get Worksheets
    */
    function get_worksheets() {
        // Security Check
        adfoin_verify_nonce();

        $cred_id = isset( $_POST['credId'] ) ? sanitize_text_field( wp_unslash( $_POST['credId'] ) ) : '';
        $workbook_id = isset( $_POST['workbookId'] ) ? $_POST['workbookId'] : '';
        $this->set_credentials( $cred_id );

        $data        = $this->zohosheet_request( $workbook_id . '?method=worksheet.list' );

        if( is_wp_error( $data ) ) {
            wp_send_json_error();
        }

        $body       = json_decode( wp_remote_retrieve_body( $data ), true );
        $worksheets = array();

        if( isset( $body['worksheet_names'] ) && is_array( $body['worksheet_names'] ) ) {
            foreach( $body['worksheet_names'] as $worksheet ) {
                $worksheets[$worksheet['worksheet_name']] = $worksheet['worksheet_name'];
            }
        }

        wp_send_json_success( $worksheets );
    }

    /*
    * Get zohosheet Fields
    */
    function get_fields() {
        // Security Check
        adfoin_verify_nonce();

        $cred_id = isset( $_POST['credId'] ) ? sanitize_text_field( wp_unslash( $_POST['credId'] ) ) : '';
        $workbook_id  = isset( $_POST['workbookId'] ) ? $_POST['workbookId'] : '';
        $worksheet_id = isset( $_POST['worksheetId'] ) ? $_POST['worksheetId'] : '';
        $this->set_credentials( $cred_id );

        $data         = $this->zohosheet_request( $workbook_id . '?method=range.content.get&worksheet_name=' . $worksheet_id . '&start_row=1&start_column=1&end_row=1&end_column=1024' );

        if( is_wp_error( $data ) ) {
            wp_send_json_error();
        }

        $body   = json_decode( wp_remote_retrieve_body( $data ), true );
        $fields = array();

        if( isset( $body['range_details'] ) && 
        is_array( $body['range_details'] ) && 
        isset( $body['range_details'][0] ) && 
        isset( $body['range_details'][0]['row_details'] ) ) {

            $header_row = $body['range_details'][0]['row_details'];

            if( is_array( $header_row ) ) {
                foreach( $header_row as $header ) {
                    array_push( $fields, array(
                        'key'         => $header['content'],
                        'value'       => $header['content'],
                        'description' => ''
                    ));
                }
            }
        }

        wp_send_json_success( $fields );
    }

}

$zohosheet = ADFOIN_Zohosheet::get_instance();

add_action( 'adfoin_zohosheet_job_queue', 'adfoin_zohosheet_job_queue', 10, 1 );

function adfoin_zohosheet_job_queue( $data ) {
    adfoin_zohosheet_send_data( $data['record'], $data['posted_data'] );
}

/*
 * Handles sending data to zohosheet API
 */
function adfoin_zohosheet_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'];
    $workbook_id  = $data['workbookId'];
    $worksheet_id = $data['worksheetId'];
    $cred_id = isset( $data['credId'] ) ? $data['credId'] : '';
    $task         = $record['task'];

    // Backward compatibility: If no credId, use the first available credential
    if ( empty( $cred_id ) ) {
        $credentials = adfoin_read_credentials( 'zohosheet' );
        if ( ! empty( $credentials ) && is_array( $credentials ) ) {
            $first_credential = reset( $credentials );
            $cred_id = isset( $first_credential['id'] ) ? $first_credential['id'] : '';
        }
    }

    if( $task == 'add_row' ) {

        unset( $data['workbookId'] );
        unset( $data['worksheetId'] );
        unset( $data['workbooks'] );
        unset( $data['worksheets'] );
        unset( $data['credId'] );

        $zohosheet = ADFOIN_Zohosheet::get_instance();
        $zohosheet->set_credentials( $cred_id );
        $holder    = array();

        foreach ( $data as $key => $value ) {
            if( $value ) {
                $parsed_value = adfoin_get_parsed_values( $value, $posted_data );
                $holder[$key] = $parsed_value;
            }
            
        }

        $endpoint = $workbook_id . '?method=worksheet.records.add&worksheet_name=' . $worksheet_id . '&json_data=[' . wp_json_encode( $holder ) . ']';

        $endpont = 'https://sheet.zoho.com/api/v2/5q2yj4d27fcabc7d544cfb9668387966083aa?method=worksheet.records.add&worksheet_name=Sheet1&header_row=1&json_data=[{"Email":"manna@pluginja.com","First Name":"Manna","Last Name":"Salwa"}]';

        $return = $zohosheet->zohosheet_request( $endpoint, 'POST', array(), $record );
    }

    return;
}