*/ trait Activecampaign_For_Woocommerce_Admin_Historical_Sync { use Activecampaign_For_Woocommerce_Admin_Utilities; use Activecampaign_For_Woocommerce_Synced_Status_Handler; use Activecampaign_For_Woocommerce_Historical_Utilities; /** * Fetches the historical sync page view. * * @since 1.5.0 */ public function fetch_historical_sync_page() { wp_enqueue_script( $this->plugin_name . 'historical-sync' ); require_once plugin_dir_path( __FILE__ ) . 'views/activecampaign-for-woocommerce-historical-sync.php'; } public function get_has_subscriptions() { if ( function_exists( 'is_plugin_active' ) && is_plugin_active( 'woocommerce-subscriptions/woocommerce-subscriptions.php' ) ) { return true; } return false; } /** * Fetches the next historical sync cron time. * * @return array */ public function get_next_historical_sync() { $logger = new Logger(); $data = null; $historical_order_schedule = AC_Scheduler::get_schedule( AC_Scheduler::RECURRING_HISTORICAL_SYNC ); if ( ! $historical_order_schedule ) { $data['historical_order_schedule']['error'] = true; $logger->warning( 'Historical order sync is not scheduled.', array( 'historical_order_schedule' => $historical_order_schedule, ) ); } elseif (is_int( $historical_order_schedule ) ) { $data['historical_order_schedule']['error'] = false; $data['historical_order_schedule']['timestamp'] = wp_date( DATE_ATOM, $historical_order_schedule ); $data['historical_order_schedule']['schedule'] = false; $data['historical_order_schedule']['next_scheduled'] = false; } else { $data['historical_order_schedule']['error'] = false; $data['historical_order_schedule']['timestamp'] = wp_date( DATE_ATOM, $historical_order_schedule->timestamp ); $data['historical_order_schedule']['schedule'] = $historical_order_schedule->schedule; if ( $historical_order_schedule->timestamp && $historical_order_schedule->interval ) { $next = $historical_order_schedule->timestamp + $historical_order_schedule->interval - time(); $data['historical_order_schedule']['next_scheduled'] = $next; } } return $data; } /** * Schedules the bulk historical sync to run as a background job. Called via ajax from historical sync page. * * @since 1.6.0 */ public function schedule_bulk_historical_sync() { $logger = new Logger(); $this->schedule_cron_syncs(); try { delete_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_RUNNING_STATUS_NAME ); delete_transient( 'activecampaign_for_woocommerce_hs_contacts' ); $sync_contacts = self::get_request_data( 'syncContacts' ); if ( isset( $sync_contacts ) && $sync_contacts ) { // Sync all the contacts from the orders do_action( 'activecampaign_for_woocommerce_run_historical_sync_contacts' ); update_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_SCHEDULED_STATUS_NAME, array( 'orders' => 'scheduled', 'contacts' => 'scheduled', ) ); } else { update_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_SCHEDULED_STATUS_NAME, array( 'orders' => 'scheduled', 'contacts' => 'not selected', ) ); } do_action( 'activecampaign_for_woocommerce_ready_existing_historical_data' ); // schedule activecampaign_for_woocommerce_prep_historical_data AC_Scheduler::schedule_ac_event( AC_Scheduler::PREP_HISTORICAL_SYNC, array('current_page' => 0), false, false ); wp_send_json_success( 'Historical sync scheduled.' ); } catch ( Throwable $t ) { $logger->warning( 'There was an issue running the historical sync prep.', array( 'message' => $t->getMessage(), 'trace' => $t->getTrace(), 'function' => 'schedule_bulk_historical_sync', ) ); wp_send_json_error( 'There was an issue scheduling historical sync.' ); } } private function update_sync_running_status( $type, $status ) { $run_sync = get_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_SCHEDULED_STATUS_NAME ); $run_sync[ $type ] = $status; update_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_SCHEDULED_STATUS_NAME, $run_sync ); } /** * Checks the status of historical sync and returns the result. * * @since 1.5.0 */ public function check_historical_sync_status() { $logger = new Logger(); global $wpdb; try { $status = json_decode( get_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_RUNNING_STATUS_NAME ), 'array' ); $run_sync = get_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_SCHEDULED_STATUS_NAME ); $stop_status = get_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_STOP_CHECK_NAME ); if ( is_null( $status ) ) { $status = array(); } // status types $status['synced'] = 0; $status['prepared'] = 0; $status['pending'] = 0; $status['error'] = 0; $status['incompatible'] = 0; $status['subsynced'] = 0; $status['subprepared'] = 0; $status['subpending'] = 0; $status['suberror'] = 0; $status['subincomp'] = 0; // conditionals $status['stuck'] = false; $status['is_running'] = false; $status['run_sync'] = $run_sync; // counts $status['total_orders'] = $this->get_sync_ready_order_count(); if ( isset( $status['incompatible_order_id_array'] ) ) { $status['incompatible'] = count( $status['incompatible_order_id_array'] ); } } catch ( Throwable $t ) { $logger->warning( 'There was an issue getting the historical sync status', array( 'message' => $t->getMessage(), 'function' => 'check_historical_sync_status', ) ); } try { // phpcs:disable $sync_counts = $wpdb->get_row( 'SELECT count(id) as total, count(if(synced_to_ac = 4,1,null)) as prepared, count(if(synced_to_ac = 3,1,null)) as pending, count(if(synced_to_ac = 1,1,null)) as synced, count(if(synced_to_ac = 6,1,null)) as incompatible, count(if(synced_to_ac = 9,1,null)) as error, count(if(synced_to_ac = 33,1,null)) as subprepared, count(if(synced_to_ac = 32,1,null)) as subpending, count(if(synced_to_ac = 35,1,null)) as subsynced, count(if(synced_to_ac = 38,1,null)) as subincomp, count(if(synced_to_ac = 39,1,null)) as suberror FROM `' . $wpdb->prefix . ACTIVECAMPAIGN_FOR_WOOCOMMERCE_TABLE_NAME . '`;', ARRAY_A ); // phpcs:enable if ( isset( $sync_counts ) ) { $status['synced'] = $sync_counts['synced']; $status['prepared'] = $sync_counts['prepared']; $status['incompatible'] = $sync_counts['incompatible']; $status['pending'] = $sync_counts['pending']; $status['error'] = $sync_counts['error']; // subscriptions $status['subprepared'] = $sync_counts['subprepared']; $status['subpending'] = $sync_counts['subpending']; $status['subsynced'] = $sync_counts['subsynced']; $status['subincomp'] = $sync_counts['subincomp']; $status['suberror'] = $sync_counts['suberror']; } } catch ( Throwable $t ) { $this->logger->debug( 'There was an issue collecting the historical sync counts from the ActiveCampaign table.', array( 'message' => $t->getMessage(), ) ); } try { // If there is pending and the last update was more than 30 minutes ago then this is a stuck sync if ( ( $status['pending'] > 0 || $status['prepared'] > 0 ) && empty( $stop_status ) ) { $status['is_running'] = true; if ( isset( $status['last_update'], $status['pending'], $status['prepared'] ) ) { $last_update = ( $status['last_update'] - time() ) / 60; if ( $last_update > 120 && ( ! isset( $status['stop_type_name'] ) || $status['pending'] > 0 || $status['prepared'] > 0 ) ) { $status['stuck'] = true; $status['is_running'] = false; $run_sync['orders'] = 'stuck'; } } } if ( isset( $run_sync['orders'] ) && 'stuck' !== $run_sync['orders'] && 'syncing' === $run_sync['orders'] && empty( $sync_counts['pending'] ) && empty( $sync_counts['prepared'] ) ) { $run_sync['orders'] = 'finished'; } if ( $stop_status ) { $status['stop_status'] = true; } update_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_SCHEDULED_STATUS_NAME, $run_sync ); // If the sync is scheduled but has not run $data = (object) array( 'status' => $status, ); } catch ( Throwable $t ) { $logger->warning( 'There was an issue getting the historical sync status', array( 'message' => $t->getMessage(), 'function' => 'check_historical_sync_status', ) ); } if ( isset( $data ) ) { wp_send_json_success( $data ); } else { wp_send_json_error(); } } /** * Sets a stop for the historical sync with a condition of cancel or pause. * * @since 1.5.0 */ public function stop_historical_sync() { $logger = new Logger(); try { $stop_type = self::get_request_data( 'type' ); $user = wp_get_current_user(); if ( ! empty( $stop_type ) ) { if ( in_array( $stop_type, array( 2, '2' ), true ) ) { delete_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_STOP_CHECK_NAME ); $status = json_decode( get_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_RUNNING_STATUS_NAME ), 'array' ); $status['stuck'] = false; $status['is_running'] = true; $status['last_update'] = time(); update_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_RUNNING_STATUS_NAME, wp_json_encode( $status ) ); wp_send_json_success( 'Continue requested...' ); } $logger->alert( 'Historical sync stop requested', array( 'stop_type' => $stop_type, 'requested by user' => array( 'user_id' => isset( $user->ID ) ? $user->ID : null, 'user_email' => isset( $user->data->user_email ) ? $user->data->user_email : null, ), ) ); update_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_STOP_CHECK_NAME, true, false ); wp_send_json_success( 'Stop requested...' ); } else { wp_send_json_success( 'No argument provided' ); } } catch ( Throwable $t ) { $logger->warning( 'There was an issue stopping the historical sync.', array( 'message' => $t->getMessage(), 'function' => 'stop_historical_sync', ) ); } } /** * Resets the historical sync if it gets in a stuck position. * * @since 1.5.0 */ public function reset_historical_sync() { delete_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_RUNNING_STATUS_NAME ); delete_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_SCHEDULED_STATUS_NAME ); delete_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_HISTORICAL_SYNC_LAST_STATUS_NAME ); delete_transient( 'activecampaign_for_woocommerce_hs_contacts' ); $this->clean_bad_data_from_table(); $this->clean_all_old_historical_syncs(); wp_send_json_success( 'Sync statuses cleared.' ); } }