prefix . 'aieo_dmm_order_cancellations'; } public static function table_lines() { global $wpdb; return $wpdb->prefix . 'aieo_dmm_order_line_refunds'; } const CRON_DAILY_RECOMPUTE = 'aieo_dmm_metrics_daily_recompute'; public static function bootstrap() { static $done = false; if ($done) { return; } $done = true; add_action('woocommerce_order_status_changed', array(__CLASS__, 'on_order_status_changed'), 20, 4); add_action('woocommerce_order_refunded', array(__CLASS__, 'on_order_refunded'), 20, 2); add_action(self::CRON_DAILY_RECOMPUTE, array(__CLASS__, 'cron_daily_recompute')); aieo_schedule_at_init(static function () { if (!wp_next_scheduled(self::CRON_DAILY_RECOMPUTE)) { wp_schedule_event(time() + HOUR_IN_SECONDS, 'daily', self::CRON_DAILY_RECOMPUTE); } }); if (!is_admin()) { return; } add_action('add_meta_boxes_woocommerce_page_wc-orders', array(__CLASS__, 'register_metabox')); add_action('add_meta_boxes_shop_order', array(__CLASS__, 'register_metabox')); add_action('woocommerce_process_shop_order_meta', array(__CLASS__, 'save_metabox_legacy'), 20, 2); add_action('woocommerce_update_order', array(__CLASS__, 'save_metabox_hpos'), 20, 1); add_action('admin_init', array(__CLASS__, 'maybe_repair_line_refund_reasons'), 45); } public static function on_order_status_changed($order_id, $status_before, $status_after, $order = null) { if (!in_array((string) $status_after, self::$cancel_statuses, true)) { return; } if (!$order) { $order = wc_get_order($order_id); } if (!$order || !is_object($order)) { return; } global $wpdb; $order_id = (int) $order->get_id(); $reason_slug = (string) $order->get_meta(self::META_REASON_SLUG, true); $reason_note = (string) $order->get_meta(self::META_REASON_NOTE, true); if ($reason_slug === '') { $reason_slug = 'other'; } if (class_exists('AIEO_DMM_Cancellation_Reasons_Data')) { $found = AIEO_DMM_Cancellation_Reasons_Data::get($reason_slug); if (!$found || (int) $found['enabled'] === 0) { $reason_slug = 'other'; } } $entry_channel = (string) $order->get_meta('_aieo_entry_channel', true); $entry_branch_id = self::resolve_branch_id_for_order($order); $entry_campaign_id = self::resolve_campaign_id_for_order($order); $all_product_ids = array(); foreach ($order->get_items() as $line) { $pid = (int) $line->get_product_id(); if ($pid > 0) { $all_product_ids[] = $pid; } } $all_product_ids = array_values(array_unique($all_product_ids)); $returned_meta = (string) $order->get_meta(self::META_RETURNED_PRODUCTS, true); $returned_ids = array(); if ($returned_meta !== '') { $parsed = array_filter(array_map('intval', explode(',', $returned_meta))); $returned_ids = array_values(array_intersect($all_product_ids, $parsed)); } if (empty($returned_ids)) { $returned_ids = $all_product_ids; } $is_full_cancel = (count($returned_ids) === count($all_product_ids)) ? 1 : 0; $event_kind = self::resolve_event_kind($order, $status_after, $reason_slug); $instigator = self::resolve_instigator($order, $reason_slug); $frame = self::resolve_frame($order, $reason_slug); $outbound_cost = null; $return_cost = null; if ($event_kind !== self::KIND_CANCELLATION) { $outbound_meta = (string) $order->get_meta(self::META_OUTBOUND_SHIP_COST, true); $outbound_cost = ($outbound_meta !== '' && is_numeric($outbound_meta)) ? round((float) $outbound_meta, 2) : self::compute_outbound_cost_for_order($order); } if ($event_kind === self::KIND_RETURNED || $event_kind === self::KIND_REFUSED) { $return_meta = (string) $order->get_meta(self::META_RETURN_SHIP_COST, true); if ($return_meta !== '' && is_numeric($return_meta)) { $return_cost = round((float) $return_meta, 2); } elseif ($event_kind === self::KIND_REFUSED) { $return_cost = $outbound_cost; } } $row = array( 'order_id' => $order_id, 'user_id' => (int) $order->get_user_id(), 'reason_slug' => $reason_slug, 'reason_note' => $reason_note !== '' ? $reason_note : null, 'status_before' => (string) $status_before, 'status_after' => (string) $status_after, 'order_total' => (float) $order->get_total(), 'product_ids' => wp_json_encode($returned_ids), 'is_full_cancel' => $is_full_cancel, 'entry_channel' => $entry_channel !== '' ? $entry_channel : null, 'entry_campaign_id' => $entry_campaign_id, 'entry_branch_id' => $entry_branch_id, 'event_kind' => (int) $event_kind, 'instigator' => $instigator, 'frame' => $frame, 'outbound_shipping_cost' => $outbound_cost, 'return_shipping_cost' => $return_cost, 'cancelled_by_user_id' => (int) get_current_user_id(), 'cancelled_at' => current_time('mysql', true), ); $tbl = self::table_orders(); $existing_id = $wpdb->get_var($wpdb->prepare( "SELECT id FROM {$tbl} WHERE order_id = %d LIMIT 1", $order_id )); if ($existing_id) { $wpdb->update($tbl, $row, array('id' => (int) $existing_id)); } else { $wpdb->insert($tbl, $row); } do_action('aieo_dmm_order_cancellation_logged', $order_id, $row); do_action('aieo_dmm_recompute_behavior_metrics_for_user', (int) $row['user_id']); foreach ($returned_ids as $pid) { do_action('aieo_dmm_recompute_behavior_metrics_for_product', (int) $pid); } } public static function on_order_refunded($order_id, $refund_id) { $order_id = (int) $order_id; $refund_id = (int) $refund_id; if ($order_id <= 0 || $refund_id <= 0) { return; } $refund = wc_get_order($refund_id); if (!$refund) { return; } $order = wc_get_order($order_id); if (!$order) { return; } global $wpdb; $tbl = self::table_lines(); $refund_reason = method_exists($refund, 'get_reason') ? (string) $refund->get_reason() : ''; list($reason_slug, $reason_note) = self::reason_for_refund($order, $refund_reason); $now = current_time('mysql', true); $user_id = (int) $order->get_user_id(); $touched_products = array(); foreach ($refund->get_items() as $line) { $product_id = (int) $line->get_product_id(); if ($product_id <= 0) { continue; } $variation_id = (int) $line->get_variation_id(); $qty = abs((int) $line->get_quantity()); $amount = abs((float) $line->get_total()); if ($qty <= 0 && $amount <= 0) { continue; } $wpdb->query($wpdb->prepare( "INSERT INTO {$tbl} (order_id, refund_id, user_id, product_id, variation_id, qty_refunded, amount_refunded, reason_slug, reason_note, refunded_at) VALUES (%d, %d, %d, %d, %d, %d, %f, %s, %s, %s) ON DUPLICATE KEY UPDATE qty_refunded = VALUES(qty_refunded), amount_refunded = VALUES(amount_refunded), reason_slug = VALUES(reason_slug), reason_note = VALUES(reason_note)", $order_id, $refund_id, $user_id, $product_id, $variation_id, $qty, $amount, $reason_slug, $reason_note, $now )); $touched_products[] = $product_id; } do_action('aieo_dmm_order_refund_logged', $order_id, $refund_id); if ($user_id > 0) { do_action('aieo_dmm_recompute_behavior_metrics_for_user', $user_id); } foreach (array_unique($touched_products) as $pid) { do_action('aieo_dmm_recompute_behavior_metrics_for_product', (int) $pid); } } public static function reason_for_refund($order, $text) { $text = trim((string) $text); $note = '' !== $text ? $text : null; if (!class_exists('AIEO_DMM_Cancellation_Reasons_Data')) { return array('other', $note); } if ('' !== $text) { $named = self::reason_named_by($text); if ('' !== $named) { return array($named, null); } } $box = ($order && is_object($order) && method_exists($order, 'get_meta')) ? sanitize_key((string) $order->get_meta(self::META_REASON_SLUG, true)) : ''; if ('' !== $box && 'other' !== $box) { $found = AIEO_DMM_Cancellation_Reasons_Data::get($box); if ($found && 1 === (int) $found['enabled']) { return array($box, $note); } } return array('other', $note); } public static function reason_named_by($text) { $text = trim((string) $text); if ('' === $text || !class_exists('AIEO_DMM_Cancellation_Reasons_Data')) { return ''; } $slug = sanitize_key($text); $found = AIEO_DMM_Cancellation_Reasons_Data::get($slug); if ($found && 1 === (int) $found['enabled'] && $slug === strtolower($text)) { return $slug; } $norm = static function ($s) { $s = preg_replace('/\s+/u', ' ', trim((string) $s)); $s = rtrim((string) $s, " .!:;\xC2\xB7"); return function_exists('mb_strtolower') ? mb_strtolower($s, 'UTF-8') : strtolower($s); }; $want = $norm($text); foreach (AIEO_DMM_Cancellation_Reasons_Data::enabled() as $s => $row) { if ('' !== (string) $row['label'] && $norm($row['label']) === $want) { return (string) $s; } } return ''; } const OPTION_LINE_REASONS_REPAIRED = 'aieo_dmm_line_refund_reasons_repaired'; const LINE_REASONS_REPAIR_VERSION = '1'; public static function maybe_repair_line_refund_reasons() { if (self::LINE_REASONS_REPAIR_VERSION === (string) get_option(self::OPTION_LINE_REASONS_REPAIRED, '')) { return 0; } global $wpdb; $tbl = self::table_lines(); if ($tbl !== $wpdb->get_var($wpdb->prepare('SHOW TABLES LIKE %s', $tbl)) || !class_exists('AIEO_DMM_Cancellation_Reasons_Data')) { return 0; } $refunds = $wpdb->get_results( "SELECT refund_id, MIN(order_id) AS order_id, MIN(reason_note) AS note FROM `{$tbl}` WHERE reason_slug = 'other' GROUP BY refund_id ORDER BY refund_id LIMIT 500" ); $moved = 0; $users = array(); $products = array(); foreach ((array) $refunds as $r) { $order = function_exists('wc_get_order') ? wc_get_order((int) $r->order_id) : null; list($slug, $note) = self::reason_for_refund($order ?: null, (string) $r->note); if ('other' === $slug) { continue; } $wpdb->query($wpdb->prepare( "UPDATE `{$tbl}` SET reason_slug = %s, reason_note = %s WHERE refund_id = %d AND reason_slug = 'other'", $slug, (string) $note, (int) $r->refund_id )); if (null === $note) { $wpdb->query($wpdb->prepare("UPDATE `{$tbl}` SET reason_note = NULL WHERE refund_id = %d", (int) $r->refund_id)); } ++$moved; foreach ((array) $wpdb->get_results($wpdb->prepare("SELECT DISTINCT user_id, product_id FROM `{$tbl}` WHERE refund_id = %d", (int) $r->refund_id)) as $l) { $users[(int) $l->user_id] = true; $products[(int) $l->product_id] = true; } } if (count((array) $refunds) < 500 || 0 === $moved) { update_option(self::OPTION_LINE_REASONS_REPAIRED, self::LINE_REASONS_REPAIR_VERSION, false); } foreach (array_keys($users) as $uid) { if ($uid > 0) { do_action('aieo_dmm_recompute_behavior_metrics_for_user', $uid); } } foreach (array_keys($products) as $pid) { do_action('aieo_dmm_recompute_behavior_metrics_for_product', $pid); } return $moved; } public static function register_metabox($post_or_order) { $is_hpos = class_exists('\Automattic\WooCommerce\Utilities\OrderUtil') && method_exists('\Automattic\WooCommerce\Utilities\OrderUtil', 'custom_orders_table_usage_is_enabled') && \Automattic\WooCommerce\Utilities\OrderUtil::custom_orders_table_usage_is_enabled(); $screen = $is_hpos ? wc_get_page_screen_id('shop-order') : 'shop_order'; add_meta_box( 'aieo_dmm_cancellation_reason', __('Cancellation Reason', 'ai-eshop-optimizer'), array(__CLASS__, 'render_metabox'), $screen, 'side', 'default' ); } public static function render_metabox($post_or_order) { $order = $post_or_order instanceof WC_Order ? $post_or_order : wc_get_order(is_object($post_or_order) ? $post_or_order->ID : 0); if (!$order) { echo '

' . esc_html__('Order not loaded.', 'ai-eshop-optimizer') . '

'; return; } $current_slug = (string) $order->get_meta(self::META_REASON_SLUG, true); $current_note = (string) $order->get_meta(self::META_REASON_NOTE, true); $current_returned = (string) $order->get_meta(self::META_RETURNED_PRODUCTS, true); $current_returned_ids = array_filter(array_map('intval', explode(',', $current_returned))); $current_outbound = (string) $order->get_meta(self::META_OUTBOUND_SHIP_COST, true); $current_return = (string) $order->get_meta(self::META_RETURN_SHIP_COST, true); $current_kind_meta = (string) $order->get_meta(self::META_EVENT_KIND, true); $resolved_kind = self::resolve_event_kind($order, $order->get_status(), $current_slug); $lines = array(); foreach ($order->get_items() as $item_id => $line) { $pid = (int) $line->get_product_id(); if ($pid <= 0) { continue; } $lines[] = array( 'product_id' => $pid, 'name' => $line->get_name(), 'qty' => max(1, (int) $line->get_quantity()), 'total' => (float) $line->get_total(), ); } $is_multi_line = count($lines) > 1; $outbound_default = ($current_outbound !== '' && is_numeric($current_outbound)) ? (float) $current_outbound : (float) $order->get_shipping_total(); wp_nonce_field('aieo_dmm_cancel_meta_' . $order->get_id(), 'aieo_dmm_cancel_nonce'); $reasons = class_exists('AIEO_DMM_Cancellation_Reasons_Data') ? AIEO_DMM_Cancellation_Reasons_Data::enabled() : array(); $reason_kind_map = array(); $reason_meta_map = array(); foreach ($reasons as $slug => $r) { $reason_kind_map[$slug] = isset($r['default_event_kind']) && $r['default_event_kind'] !== null ? (int) $r['default_event_kind'] : null; $reason_meta_map[$slug] = array( 'kind' => $reason_kind_map[$slug], 'instigator' => isset($r['default_instigator']) ? (string) $r['default_instigator'] : '', 'frame' => isset($r['default_frame']) ? (string) $r['default_frame'] : '', ); } $resolved_instigator = self::resolve_instigator($order, $current_slug); $resolved_frame = self::resolve_frame($order, $current_slug); $kind_labels = self::kind_labels(); $groups = array(); foreach ($reasons as $slug => $r) { $k = isset($r['default_event_kind']) && $r['default_event_kind'] !== null ? (int) $r['default_event_kind'] : -1; $groups[$k][$slug] = $r; } ksort($groups); ?>

get_status(), self::$cancel_statuses, true)) { self::on_order_status_changed($order->get_id(), $order->get_status(), $order->get_status(), $order); } } public static function save_metabox_hpos($order_id) { if (!isset($_POST['aieo_dmm_cancel_nonce']) || !wp_verify_nonce( sanitize_key(wp_unslash($_POST['aieo_dmm_cancel_nonce'])), 'aieo_dmm_cancel_meta_' . (int) $order_id )) { return; } $order = wc_get_order((int) $order_id); if (!$order) { return; } self::persist_metabox_values($order); if (in_array($order->get_status(), self::$cancel_statuses, true)) { self::on_order_status_changed($order->get_id(), $order->get_status(), $order->get_status(), $order); } } private static function persist_metabox_values($order) { $slug = isset($_POST['aieo_dmm_cancel_reason']) ? sanitize_key(wp_unslash($_POST['aieo_dmm_cancel_reason'])) : ''; $note = isset($_POST['aieo_dmm_cancel_note']) ? sanitize_textarea_field(wp_unslash($_POST['aieo_dmm_cancel_note'])) : ''; if ($slug === '') { $order->delete_meta_data(self::META_REASON_SLUG); } else { $order->update_meta_data(self::META_REASON_SLUG, $slug); } if ($note === '') { $order->delete_meta_data(self::META_REASON_NOTE); } else { $order->update_meta_data(self::META_REASON_NOTE, substr($note, 0, 500)); } if (isset($_POST['aieo_dmm_cancel_kind'])) { $kind = (int) $_POST['aieo_dmm_cancel_kind']; if (in_array($kind, array(0, 1, 2, 3, 4), true)) { $order->update_meta_data(self::META_EVENT_KIND, (string) $kind); } else { $order->delete_meta_data(self::META_EVENT_KIND); } } if (isset($_POST['aieo_dmm_cancel_instigator'])) { $inst = sanitize_key(wp_unslash($_POST['aieo_dmm_cancel_instigator'])); if (in_array($inst, array(self::INSTIGATOR_CUSTOMER, self::INSTIGATOR_SHOP), true)) { $order->update_meta_data(self::META_INSTIGATOR, $inst); } else { $order->delete_meta_data(self::META_INSTIGATOR); } } if (isset($_POST['aieo_dmm_cancel_frame'])) { $frame = sanitize_key(wp_unslash($_POST['aieo_dmm_cancel_frame'])); if (in_array($frame, array(self::FRAME_WITHDRAWAL, self::FRAME_FAULTY_GOODS, self::FRAME_NON_DELIVERY, self::FRAME_NONE), true)) { $order->update_meta_data(self::META_FRAME, $frame); } else { $order->delete_meta_data(self::META_FRAME); } } $returned = isset($_POST['aieo_dmm_cancel_returned']) && is_array($_POST['aieo_dmm_cancel_returned']) ? array_filter(array_map('intval', wp_unslash($_POST['aieo_dmm_cancel_returned']))) : array(); if (empty($returned)) { $order->delete_meta_data(self::META_RETURNED_PRODUCTS); } else { $order->update_meta_data(self::META_RETURNED_PRODUCTS, implode(',', array_unique($returned))); } if (isset($_POST['aieo_dmm_cancel_return'])) { $val = trim((string) wp_unslash($_POST['aieo_dmm_cancel_return'])); if ($val === '' || !is_numeric($val)) { $order->delete_meta_data(self::META_RETURN_SHIP_COST); } else { $order->update_meta_data(self::META_RETURN_SHIP_COST, (string) round((float) $val, 2)); } } if (isset($_POST['aieo_dmm_cancel_outbound'])) { $val = trim((string) wp_unslash($_POST['aieo_dmm_cancel_outbound'])); if ($val === '' || !is_numeric($val)) { $order->delete_meta_data(self::META_OUTBOUND_SHIP_COST); } else { $order->update_meta_data(self::META_OUTBOUND_SHIP_COST, (string) round((float) $val, 2)); } } $order->save_meta_data(); } public static function cron_daily_recompute() { if (class_exists('AIEO_DMM_Module_Base') && !AIEO_DMM_Module_Base::is_aieo_pro_user()) { return; } $cap = (int) apply_filters('aieo_dmm_metrics_daily_cap', 200); if (class_exists('AIEO_DMM_Product_Behavior_Metrics')) { AIEO_DMM_Product_Behavior_Metrics::recompute_stale(24, $cap); } if (class_exists('AIEO_DMM_User_Behavior_Metrics')) { AIEO_DMM_User_Behavior_Metrics::recompute_stale(24, $cap); } } public static function resolve_event_kind($order, $status_after, $reason_slug) { $override = (string) $order->get_meta(self::META_EVENT_KIND, true); if (in_array($override, array('0', '1', '2', '3', '4'), true)) { return (int) $override; } if ($reason_slug !== '' && class_exists('AIEO_DMM_Cancellation_Reasons_Data')) { $row = AIEO_DMM_Cancellation_Reasons_Data::get($reason_slug); if (is_array($row) && isset($row['default_event_kind']) && $row['default_event_kind'] !== null && $row['default_event_kind'] !== '') { return (int) $row['default_event_kind']; } } return ((string) $status_after === 'refunded') ? self::KIND_RETURNED : self::KIND_CANCELLATION; } public static function resolve_instigator($order, $reason_slug) { $valid = array(self::INSTIGATOR_CUSTOMER, self::INSTIGATOR_SHOP); if (is_object($order)) { $override = (string) $order->get_meta(self::META_INSTIGATOR, true); if (in_array($override, $valid, true)) { return $override; } } if ($reason_slug !== '' && class_exists('AIEO_DMM_Cancellation_Reasons_Data')) { $row = AIEO_DMM_Cancellation_Reasons_Data::get($reason_slug); if (is_array($row) && isset($row['default_instigator']) && in_array((string) $row['default_instigator'], $valid, true)) { return (string) $row['default_instigator']; } } return ''; } public static function resolve_frame($order, $reason_slug) { $valid = array(self::FRAME_WITHDRAWAL, self::FRAME_FAULTY_GOODS, self::FRAME_NON_DELIVERY, self::FRAME_NONE); if (is_object($order)) { $override = (string) $order->get_meta(self::META_FRAME, true); if (in_array($override, $valid, true)) { return $override; } } if ($reason_slug !== '' && class_exists('AIEO_DMM_Cancellation_Reasons_Data')) { $row = AIEO_DMM_Cancellation_Reasons_Data::get($reason_slug); if (is_array($row) && isset($row['default_frame']) && in_array((string) $row['default_frame'], $valid, true)) { return (string) $row['default_frame']; } } return ''; } public static function instigator_labels() { return array( self::INSTIGATOR_CUSTOMER => __('Customer', 'ai-eshop-optimizer'), self::INSTIGATOR_SHOP => __('Shop', 'ai-eshop-optimizer'), ); } public static function frame_labels() { return array( self::FRAME_WITHDRAWAL => __('Withdrawal', 'ai-eshop-optimizer'), self::FRAME_FAULTY_GOODS => __('Faulty goods', 'ai-eshop-optimizer'), self::FRAME_NON_DELIVERY => __('Non-delivery', 'ai-eshop-optimizer'), self::FRAME_NONE => __('No consumer right in play', 'ai-eshop-optimizer'), ); } public static function kind_labels() { return array( self::KIND_CANCELLATION => __('Cancellation — voided before shipping', 'ai-eshop-optimizer'), self::KIND_RETURNED => __('Returned (after receipt)', 'ai-eshop-optimizer'), self::KIND_KEPT => __('Kept (refund only)', 'ai-eshop-optimizer'), self::KIND_REFUSED => __('Refused (never received)', 'ai-eshop-optimizer'), self::KIND_LOST => __('Lost (shipped, never arrived)', 'ai-eshop-optimizer'), ); } public static function compute_outbound_cost_for_order($order) { if (!is_object($order)) { return 0.0; } if (!class_exists('AIEO_DMM_Shipping_Cost_Resolver')) { return round((float) $order->get_shipping_total(), 2); } $r = AIEO_DMM_Shipping_Cost_Resolver::instance()->resolve_for_order((int) $order->get_id()); if (is_array($r) && isset($r['cost'])) { return round((float) $r['cost'], 2); } return 0.0; } public static function backfill_outbound_costs_batch($batch_size = 100) { global $wpdb; $tbl = self::table_orders(); $t0 = microtime(true); $rows = $wpdb->get_results($wpdb->prepare( "SELECT id, order_id FROM {$tbl} WHERE event_kind > 0 AND (outbound_shipping_cost IS NULL OR outbound_shipping_cost = 0) ORDER BY id ASC LIMIT %d", (int) $batch_size ), ARRAY_A); if (empty($rows)) { $remaining = (int) $wpdb->get_var( "SELECT COUNT(*) FROM {$tbl} WHERE event_kind > 0 AND (outbound_shipping_cost IS NULL OR outbound_shipping_cost = 0)" ); return array('processed' => 0, 'remaining' => $remaining, 'elapsed_ms' => 0); } $processed = 0; foreach ($rows as $r) { $order = function_exists('wc_get_order') ? wc_get_order((int) $r['order_id']) : null; if (!$order) { $wpdb->update($tbl, array('outbound_shipping_cost' => 0.01), array('id' => (int) $r['id'])); $processed++; continue; } $cost = self::compute_outbound_cost_for_order($order); if ($cost <= 0) { $cost = 0.01; } $wpdb->update($tbl, array('outbound_shipping_cost' => $cost), array('id' => (int) $r['id'])); $processed++; } $remaining = (int) $wpdb->get_var( "SELECT COUNT(*) FROM {$tbl} WHERE event_kind > 0 AND (outbound_shipping_cost IS NULL OR outbound_shipping_cost = 0)" ); return array( 'processed' => $processed, 'remaining' => $remaining, 'elapsed_ms' => (int) round((microtime(true) - $t0) * 1000), ); } private static function resolve_campaign_id_for_order($order) { $slug = (string) $order->get_meta('_aieo_entry_campaign', true); if ($slug === '') { return null; } if (!class_exists('AIEO_DMM_Campaigns')) { return null; } $id = AIEO_DMM_Campaigns::touch($slug); return $id ? (int) $id : null; } private static function resolve_branch_id_for_order($order) { $erp = trim((string) $order->get_meta('soft1_branches', true)); if ($erp === '') { return null; } if (strpos($erp, ',') !== false) { $parts = array_filter(array_map('trim', explode(',', $erp))); $erp = (string) reset($parts); } if ($erp === '') { return null; } global $wpdb; $tbl = $wpdb->prefix . 'aieo_dmm_branches'; if ($wpdb->get_var($wpdb->prepare('SHOW TABLES LIKE %s', $tbl)) !== $tbl) { return null; } $branch_id = $wpdb->get_var($wpdb->prepare( "SELECT id FROM {$tbl} WHERE erp_id = %s LIMIT 1", $erp )); return $branch_id ? (int) $branch_id : null; } }