*/ class Activecampaign_For_Woocommerce_New_Subscription_Sync_Job implements Executable, Synced_Status { use Activecampaign_For_Woocommerce_Data_Validation; use Activecampaign_For_Woocommerce_Order_Data_Gathering; use Activecampaign_For_Woocommerce_Subscription_Data_Gathering; use Activecampaign_For_Woocommerce_Contact_Data_Handler; use Activecampaign_For_Woocommerce_Synced_Status_Handler; use Activecampaign_For_Woocommerce_Global_Utilities; /** * The custom ActiveCampaign logger * * @var Activecampaign_For_Woocommerce_Logger */ private $logger; /** * The Ecom Order Repo * * @var Activecampaign_For_Woocommerce_Ecom_Order_Repository */ private $order_repository; /** * The Cofe Order Repo * * @var Activecampaign_For_Woocommerce_Cofe_Order_Repository */ private $cofe_order_repository; /** * The order utilities functions. * * @var Activecampaign_For_Woocommerce_Customer_Utilities */ private $customer_utilities; /** * The Ecom Customer Repo * * @var Activecampaign_For_Woocommerce_Ecom_Customer_Repository */ private $customer_repository; /** * The Ecom Connection ID * * @var mixed */ private $connection_id; /** * Sets source for active or not. * Source 1 = run automations. * Source 0 = do not run automations. * * @var int */ private $source = 1; /** * Activecampaign_For_Woocommerce_Historical_Sync_Job constructor. * * @param Activecampaign_For_Woocommerce_Logger|null $logger The logger object. * @param Activecampaign_For_Woocommerce_Customer_Utilities $customer_utilities The customer utility class. * @param Activecampaign_For_Woocommerce_Ecom_Customer_Repository $customer_repository The customer repository object. * @param Activecampaign_For_Woocommerce_Cofe_Order_Repository $cofe_order_repository The cofe order repository object. */ public function __construct( Logger $logger, Customer_Utilities $customer_utilities, Customer_Repository $customer_repository, Cofe_Order_Repository $cofe_order_repository ) { if ( ! $logger ) { $this->logger = new Logger(); } else { $this->logger = $logger; } $this->customer_repository = $customer_repository; $this->cofe_order_repository = $cofe_order_repository; $this->customer_utilities = $customer_utilities; $admin_storage = get_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_DB_CONNECTION_STORAGE_NAME ); if ( ! empty( $admin_storage ) && isset( $admin_storage['connection_id'] ) ) { $this->connection_id = $admin_storage['connection_id']; } } /** * Sync any new/live orders. * Triggered from a hook call. * * @param mixed ...$args The passed args. */ public function execute( ...$args ) { if ( ! $this->logger ) { $this->logger = new Logger(); } if ( ! $this->is_configured() || ! $this->is_connected() ) { $this->logger->debug( 'Subscription sync skipped: plugin not configured or connected.' ); return; } $unsynced_order_data = null; $recovered_orders = null; try { if ( isset( $args[0] ) && is_int( $args[0] ) ) { $wc_order_id = $args[0]; } if ( isset( $args[0]['wc_order_id'] ) ) { $wc_order_id = $args[0]['wc_order_id']; } if ( isset( $args['wc_order_id'] ) ) { $wc_order_id = $args['wc_order_id']; } if ( isset( $wc_order_id ) ) { // We're just syncing one row by order id $wc_subscription = $this->get_wc_subscription( $wc_order_id ); if ( false === $wc_subscription || ! $this->order_has_required_data( $wc_subscription ) ) { $this->mark_order_as_incompatible( $wc_order_id ); return false; } else { $ac_customer_id = $this->get_ac_customer_id( $wc_subscription->get_billing_email() ); $ac_order = $this->single_sync_subscription_cofe_data( $wc_subscription, false, $ac_customer_id ); if ( ! isset( $ac_order ) || ! $ac_order ) { $this->logger->warning( 'The order may have failed to sync to cofe', array( 'order_id' => $wc_order_id, 'sync_data' => $ac_order, 'ac_code' => 'SSJ_158', ) ); $this->mark_subscription_as_failed( $wc_order_id ); } else { $ac_id = null; if ( self::validate_object( $ac_order, 'get_id' ) ) { $ac_id = $ac_order->get_id(); } $this->add_meta_to_subscription( $wc_subscription ); $this->add_update_notes( $wc_order_id, $ac_id, $wc_subscription->get_status() ); $this->mark_single_order_synced( $wc_order_id ); $this->update_last_subscription_sync(); } } } } catch ( Throwable $t ) { $this->logger->error( 'Activecampaign_For_Woocommerce_New_Order_Sync: There was an error processing the order data by wc_order_id.', array( 'args' => $args, 'message' => $t->getMessage(), 'stack_trace' => $t->getTrace(), 'ac_code' => 'SSJ_186', ) ); if ( isset( $wc_order_id ) && ! empty( $wc_order_id ) ) { $this->mark_order_as_incompatible( $wc_order_id ); } } try { if ( isset( $args[0]['row_id'] ) ) { $row_id = $args[0]['row_id']; } if ( isset( $args['row_id'] ) ) { $row_id = $args['row_id']; } if ( isset( $row_id ) ) { // We're just syncing one row by row id $unsynced_order_data = $this->get_unsynced_subscriptions_from_table( $row_id, false ); } else { // This is a general sync, get all records $now = date_create( 'NOW' ); $last_run = get_option( 'activecampaign_for_woocommerce_subscription_sync_last_run' ); // Try and keep this event from running too many times. // The cron will run every minute but this needs to run every 10 instead. if ( false !== $last_run ) { $interval = date_diff( $now, $last_run ); $interval_minutes = $interval->format( '%i' ); } else { $interval_minutes = 10; } // if ( ! isset( $interval_minutes ) || empty( $interval_minutes ) || $interval_minutes >= 10 ) { $unsynced_order_data = $this->get_unsynced_subscriptions_from_table( null, false ); // } } } catch ( Throwable $t ) { $this->logger->warning( 'Activecampaign_For_Woocommerce_New_Order_Sync: There was an error processing the order data.', array( 'args' => $args, 'message' => $t->getMessage(), 'stack_trace' => $t->getTrace(), ) ); if ( isset( $wc_order_id ) && ! empty( $wc_order_id ) ) { $this->mark_subscription_as_incompatible( $wc_order_id ); } } try { if ( ( is_array( $unsynced_order_data ) && count( $unsynced_order_data ) > 0 ) || ( is_array( $recovered_orders ) && count( $recovered_orders ) > 0 ) ) { $this->iterate_subscription_data( $unsynced_order_data, $recovered_orders ); } } catch ( Throwable $t ) { $this->logger->warning( 'Activecampaign_For_Woocommerce_New_Order_Sync: There was an error processing the order data.', array( 'message' => $t->getMessage(), 'stack_trace' => $t->getTrace(), ) ); } } private function mark_single_order_synced( $wc_order_id ) { global $wpdb; if ( isset( $wc_order_id ) ) { $table_data = $this->get_unsynced_subscriptions_from_table( $wc_order_id, false, true ); if ( ! isset( $table_data[0]->id ) ) { $table_data = $this->get_unsynced_subscriptions_from_table( $wc_order_id, true, true ); } if ( isset( $table_data[0]->id, $table_data[0]->synced_to_ac ) && $table_data[0]->synced_to_ac >= self::STATUS_SUBSCRIPTION_SYNCED && $table_data[0]->synced_to_ac <= self::STATUS_SUBSCRIPTION_FAILED_SYNC ) { $wpdb->update( $wpdb->prefix . ACTIVECAMPAIGN_FOR_WOOCOMMERCE_TABLE_NAME, array( 'synced_to_ac' => self::STATUS_SUBSCRIPTION_SYNCED ), array( 'id' => $table_data[0]->id, ) ); } elseif ( isset( $table_data[0]->id ) ) { $wpdb->update( $wpdb->prefix . ACTIVECAMPAIGN_FOR_WOOCOMMERCE_TABLE_NAME, array( 'synced_to_ac' => self::STATUS_SUBSCRIPTION_SYNCED ), array( 'id' => $table_data[0]->id, ) ); } } } public function iterate_subscription_data( $unsynced_order_data, $recovered_orders ) { // Iterate through standard orders if ( ! empty( $unsynced_order_data ) && count( $unsynced_order_data ) > 0 ) { // Iterate through the unsynced order data foreach ( $unsynced_order_data as $prep_order ) { $wc_order = $this->get_wc_order( $prep_order->wc_order_id ); if ( false === $wc_order || ! $this->order_has_required_data( $wc_order ) ) { $this->mark_subscription_as_incompatible( $prep_order->wc_order_id ); // fail this order but keep going continue; } try { $extract_email = $this->extract_email_from_order( $wc_order ); if ( ! empty( $extract_email ) ) { $ac_customer_id = $this->get_ac_customer_id( $extract_email ); } elseif ( isset( $prep_order->customer_email ) && ! empty( $prep_order->customer_email ) ) { $ac_customer_id = $this->get_ac_customer_id( $prep_order->customer_email ); } $ac_order = $this->single_sync_subscription_cofe_data( $wc_order, false, $ac_customer_id ); if ( ! isset( $ac_order ) ) { $this->mark_subscription_as_failed( $prep_order->wc_order_id ); } else { $ac_id = null; if ( isset( $ac_order ) && self::validate_object( $ac_order, 'get_id' ) ) { $ac_id = $ac_order->get_id(); } $this->add_update_notes( $prep_order->wc_order_id, $ac_id, $wc_order->get_status() ); $this->mark_single_order_synced( $prep_order->wc_order_id ); } } catch ( Throwable $t ) { $this->logger->warning( 'New Order Sync: This order failed to process via COFE code. It will not be synced.', array( 'prep_order' => isset( $prep_order ) ? $prep_order : null, 'message' => $t->getMessage(), 'stack_trace' => $this->logger->clean_trace( $t->getTrace() ), ) ); } if ( ! isset( $ac_order ) ) { $this->mark_subscription_as_failed( $prep_order->wc_order_id ); } } } // Iterate through recovered orders if ( ! empty( $recovered_orders ) && count( $recovered_orders ) > 0 ) { foreach ( $recovered_orders as $unsynced_recovered_order ) { $wc_order = $this->get_wc_order( wc_get_order( $unsynced_recovered_order->wc_order_id ) ); if ( false === $wc_order || ! $this->order_has_required_data( $wc_order ) ) { $this->mark_order_as_incompatible( $unsynced_recovered_order->wc_order_id ); continue; } try { // RECOVERED $extract_email = $this->extract_email_from_order( $wc_order ); if ( ! empty( $extract_email ) ) { $ac_customer_id = $this->get_ac_customer_id( $extract_email ); } elseif ( isset( $unsynced_recovered_order->customer_email ) && ! empty( $unsynced_recovered_order->customer_email ) ) { $ac_customer_id = $this->get_ac_customer_id( $unsynced_recovered_order->customer_email ); } $ac_order = $this->single_sync_subscription_cofe_data( $wc_order, $unsynced_recovered_order->ac_externalcheckoutid, $ac_customer_id ); } catch ( Throwable $t ) { $this->logger->warning( 'New Order Sync: This recovered order failed to process via COFE code. It will not be synced.', array( 'prep_order' => $prep_order, 'message' => $t->getMessage(), 'stack_trace' => $this->logger->clean_trace( $t->getTrace() ), ) ); } if ( ! isset( $ac_order ) ) { $this->mark_subscription_as_failed( $unsynced_recovered_order->wc_order_id ); } else { $ac_id = null; if ( self::validate_object( $ac_order, 'get_id' ) ) { $ac_id = $ac_order->get_id(); } $this->add_update_notes( $unsynced_recovered_order->wc_order_id, $ac_id, $wc_order->get_status() ); $this->mark_single_order_synced( $unsynced_recovered_order->wc_order_id ); } } } $this->logger->debug( 'New order sync job finished' ); } /** * Process to sync a single record for subscription sync. * * @param WC_Subscription $wc_subscription The WC subscription. * @param string $externalcheckoutid The external checkout ID passed only if it's recovered order. * * @return false|void */ public function single_sync_subscription_cofe_data( $wc_subscription, $externalcheckoutid = false, $ac_customer_id = null ) { if ( ! isset( $wc_subscription ) ) { return false; } $ecom_contact = new AC_Contact(); if ( $ecom_contact->create_ecom_contact_from_order( $wc_subscription ) ) { $ecom_contact->set_connectionid( $this->connection_id ); } $this->sync_contact_to_ac( $ecom_contact ); if ( isset( $wc_subscription ) && self::validate_object( $wc_subscription, 'get_id' ) && ! empty( $wc_subscription->get_id() ) ) { // Data for cofe order sync $ecom_subscription = $this->setup_cofe_subscription_from_table( $wc_subscription, $this->source ); if ( is_null( $ecom_subscription ) ) { $this->logger->warning( 'Setup COFE order returned null. Something may have gone wrong or the data may not be missing/incompatible with AC.' ); return false; } $result = $this->cofe_order_repository->create_bulk( array( $ecom_subscription->serialize_to_array() ), 'subscriptions' ); // Change this to return the response from AC if we have a data response return $result; } } /** * Updates the last subscription sync time. */ private function update_last_subscription_sync() { $created_date = new DateTime( 'NOW', new DateTimeZone( 'UTC' ) ); update_option( 'activecampaign_for_woocommerce_last_subscription_sync', $created_date ); } /** * Add update notes to the order. * * @param string|int $wc_order_id The WC order ID. * @param string|null $ac_order_id The AC order ID. * @param string|null $sent_status The status we are sending. */ private function add_update_notes( $wc_order_id, $ac_order_id = null, $sent_status = null ) { $note = 'ActiveCampaign for WC synced subscription'; if ( isset( $ac_order_id ) && ! empty( $ac_order_id ) ) { $note .= ' (ID: ' . $ac_order_id . ')'; } if ( isset( $sent_status ) && ! empty( $sent_status ) ) { $note .= ' [Status: ' . $sent_status . ']'; } wc_create_order_note( $wc_order_id, $note ); } /** * Get all of the unsynced orders from the table. * * @param int|null $id The row id. * @param bool $recovered If this is a recovered call. * @param bool $is_wc_order_id If this is a WC order id instead of a row id. * * @return array|bool|object|null */ private function get_unsynced_subscriptions_from_table( $id = null, $recovered = false, $is_wc_order_id = false ) { global $wpdb; try { // Get the subscriptions from our table if ( null !== $id ) { $where = 'synced_to_ac = ' . self::STATUS_SUBSCRIPTION_UNSYNCED; $id_type = 'id'; if ( $is_wc_order_id ) { $id_type = 'wc_order_id'; } // phpcs:disable $orders = $wpdb->get_results( $wpdb->prepare( 'SELECT id, wc_order_id, customer_email, abandoned_date, ac_customer_id FROM `' . $wpdb->prefix . ACTIVECAMPAIGN_FOR_WOOCOMMERCE_TABLE_NAME . '` WHERE ' . $where . ' AND ' . $id_type . ' = %d LIMIT 1', $id ) ); // phpcs:enable } else { $orders = $wpdb->get_results( // phpcs:disable $wpdb->prepare( 'SELECT id, wc_order_id, ac_externalcheckoutid, customer_email, abandoned_date, ac_customer_id FROM `' . $wpdb->prefix . ACTIVECAMPAIGN_FOR_WOOCOMMERCE_TABLE_NAME . '` WHERE wc_order_id IS NOT NULL AND synced_to_ac = %d ORDER BY id ASC LIMIT 100', self::STATUS_SUBSCRIPTION_UNSYNCED ) // phpcs:enable ); } if ( $wpdb->last_error ) { $this->logger->error( 'Subscription sync: There was an error getting results for subscription records.', array( 'query' => $wpdb->last_query, 'wpdb_last_error' => $wpdb->last_error, 'ac_code' => 'SSJ_514', ) ); } if ( ! empty( $orders ) ) { return $orders; } else { return false; } } catch ( Throwable $t ) { $this->logger->error( 'Order Sync: There was an error with preparing or getting order results.', array( 'message' => $t->getMessage(), 'trace' => $this->logger->clean_trace( $t->getTrace() ), 'ac_code' => 'SSJ_528', ) ); } } /** * Gets the customer id by email from Hosted. * * @param string $email The billing email. * * @return mixed|null */ private function get_ac_customer_id( $email ) { $ac_customer_id = null; try { if ( isset( $email ) ) { $ac_customer = $this->customer_repository->find_by_email_and_connection_id( $email, $this->connection_id ); if ( self::validate_object( $ac_customer, 'get_id' ) ) { $ac_customer_id = $ac_customer->get_id(); } } } catch ( Throwable $t ) { $this->logger->warning( 'Check synced order failed to get ID from ac_order', array( 'unsynced_order' => $email, 'ac_customer_id' => $ac_customer_id, 'ac_code' => 'SSJ_555', ) ); } return $ac_customer_id; } public function execute_one_historical( ...$args ) { if ( ! $this->logger ) { $this->logger = new Logger(); } if ( isset( $args[0] ) && is_int( $args[0] ) ) { $wc_order_id = $args[0]; } if ( isset( $args[0]['wc_order_id'] ) ) { $wc_order_id = $args[0]['wc_order_id']; } if ( isset( $args['wc_order_id'] ) ) { $wc_order_id = $args['wc_order_id']; } $this->source = 0; if ( isset( $wc_order_id ) && ! empty( $wc_order_id ) ) { $this->execute( array( 'wc_order_id' => $wc_order_id ) ); return $args; } else { return false; } } /** * @param WC_Subscription $wc_subscription The WooCommerce order object. */ private function add_meta_to_subscription( $wc_subscription ) { // save the status so update checks do not sync the same data $wc_subscription->add_meta_data( 'ac_last_synced_status', $wc_subscription->get_status(), true ); $last_sync_time = $wc_subscription->get_meta( 'ac_order_last_synced_time' ); $ac_datahash = $wc_subscription->get_meta( 'ac_datahash' ); if ( ! empty( $last_sync_time ) ) { $wc_subscription->update_meta_data( 'ac_order_last_synced_time', time() ); } else { $wc_subscription->add_meta_data( 'ac_order_last_synced_time', time(), true ); } if ( ! empty( $ac_datahash ) ) { $wc_subscription->update_meta_data( 'ac_datahash', md5( json_encode( $wc_subscription->get_data() ) ) ); } else { $wc_subscription->add_meta_data( 'ac_datahash', md5( json_encode( $wc_subscription->get_data() ) ), true ); } $settings = get_option( ACTIVECAMPAIGN_FOR_WOOCOMMERCE_DB_SETTINGS_NAME ); if ( isset( $settings['disable_meta_save'] ) && 1 === $settings['disable_meta_save'] ) { return; } $wc_subscription->save_meta_data(); } }