prefix . Rule::TABLE_NAME; $sql = "SELECT id, conditions FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); $rows = array_map(function ($item) { $result = array( 'id' => $item->id, 'conditions' => unserialize($item->conditions), ); return $result; }, $rows); foreach ($rows as &$row) { $prev_row = $row; foreach ($row['conditions'] as &$condition) { if ('amount_' === substr($condition['type'], 0, strlen('amount_')) && 3 === count($condition['options'])) { array_unshift($condition['options'], 'in_list'); } } if ($prev_row != $row) { $row['conditions'] = serialize($row['conditions']); // phpcs:ignore WordPress.DB.DirectDatabaseQuery $result = $wpdb->update($table, array('conditions' => $row['conditions']), array('id' => $row['id'])); } } } public static function migrateTo_3_0_0() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, conditions, limits, cart_adjustments FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); $rows = array_map(function ($item) { $result = array( 'id' => $item->id, 'conditions' => unserialize($item->conditions), 'limits' => unserialize($item->limits), 'cart_adjustments' => unserialize($item->cart_adjustments), ); return $result; }, $rows); foreach ($rows as &$row) { $prev_row = $row; foreach ($row['conditions'] as &$data) { $data = OptionsConverter::convertCondition($data); } foreach ($row['cart_adjustments'] as &$data) { $data = OptionsConverter::convertCartAdj($data); } foreach ($row['limits'] as &$data) { $data = OptionsConverter::convertLimit($data); } if ($prev_row != $row) { $row['conditions'] = serialize($row['conditions']); $row['cart_adjustments'] = serialize($row['cart_adjustments']); $row['limits'] = serialize($row['limits']); // phpcs:ignore WordPress.DB.DirectDatabaseQuery $result = $wpdb->update($table, array( 'conditions' => $row['conditions'], 'cart_adjustments' => $row['cart_adjustments'], 'limits' => $row['limits'], ), array('id' => $row['id'])); } } } public static function migrateOptionsTo_3_1_0() { $context = new Context(); $settings = $context->getSettings(); $disableExternalCouponsValue = $settings->getOption('disable_external_coupons'); if ($disableExternalCouponsValue === "dont_disable") { if ( ! $settings->getOption('apply_external_coupons_only_to_unmodified_products')) { $settings->set("external_coupons_behavior", "apply"); } else { $settings->set("external_coupons_behavior", "apply_to_unmodified_only"); } } elseif ($disableExternalCouponsValue === "if_any_rule_applied") { $settings->set("external_coupons_behavior", "disable_if_any_rule_applied"); } elseif ($disableExternalCouponsValue === "if_any_of_cart_items_updated") { $settings->set("external_coupons_behavior", "disable_if_any_of_cart_items_updated"); } $context->getSettings()->save(); } public static function migrateFreeProductsTo_3_1_0() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, get_products FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); $rows = array_filter(array_map(function ($item) { $result = array( 'id' => $item->id, 'get_products' => unserialize($item->get_products), ); if (empty($result['get_products'])) { return false; } return $result; }, $rows)); foreach ($rows as &$row) { $values = isset($row['get_products']['value']) ? $row['get_products']['value'] : array(); foreach ($values as &$value) { $giftMode = isset($value['gift_mode']) ? $value['gift_mode'] : "giftable_products"; $useProductFromFilter = isset($value['use_product_from_filter']) ? $value['use_product_from_filter'] === 'on' : false; if ($useProductFromFilter) { $giftMode = "use_product_from_filter"; } $value['gift_mode'] = $giftMode; unset($value['use_product_from_filter']); } $row['get_products']['value'] = $values; // phpcs:ignore WordPress.DB.DirectDatabaseQuery $result = $wpdb->update($table, array('get_products' => serialize($row['get_products'])), array('id' => $row['id'])); } } public static function migrate_options_to_3_2_1() { $context = new Context(); $settings = $context->getSettings(); $replaceVariationPriceOption = $settings->getOption('replace_price_with_min_variation_price'); if ($replaceVariationPriceOption) { $replaceVariationPriceCategoryOption = $settings->tryGetOption('replace_price_with_min_variation_price_category'); if ($replaceVariationPriceCategoryOption && ! $replaceVariationPriceCategoryOption->isValueInstalled()) { $replaceVariationPriceCategoryOption->set(true); } } if ($replaceVariationPriceTemplateOption = $settings->getOption('replace_price_with_min_variation_price_template')) { $replaceVariationPriceCategoryTemplateOption = $settings->tryGetOption('replace_price_with_min_variation_price_category_template'); if ($replaceVariationPriceCategoryTemplateOption && ! $replaceVariationPriceCategoryTemplateOption->isValueInstalled()) { $replaceVariationPriceCategoryTemplateOption->set($replaceVariationPriceTemplateOption); } } $replaceLwestBulkPriceOption = $settings->getOption('replace_price_with_min_bulk_price'); if ($replaceLwestBulkPriceOption) { $replaceLwestBulkPriceCategoryOption = $settings->tryGetOption('replace_price_with_min_bulk_price_category'); if ($replaceLwestBulkPriceCategoryOption && ! $replaceLwestBulkPriceCategoryOption->isValueInstalled()) { $replaceLwestBulkPriceCategoryOption->set(true); } } if ($replaceLwestBulkPriceTemplateOption = $settings->getOption('replace_price_with_min_bulk_price_template')) { $replaceLwestBulkPriceCategoryTemplateOption = $settings->tryGetOption('replace_price_with_min_bulk_price_category_template'); if ($replaceLwestBulkPriceCategoryTemplateOption && ! $replaceLwestBulkPriceCategoryTemplateOption->isValueInstalled()) { $replaceLwestBulkPriceCategoryTemplateOption->set($replaceLwestBulkPriceTemplateOption); } } $context->getSettings()->save(); } public static function migrateFreeProductsTo_3_2_6() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, get_products FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); $rows = array_filter(array_map(function ($item) { $result = array( 'id' => $item->id, 'get_products' => unserialize($item->get_products), ); if (empty($result['get_products'])) { return false; } return $result; }, $rows)); foreach ($rows as &$row) { $values = isset($row['get_products']['value']) ? $row['get_products']['value'] : array(); foreach ($values as &$value) { $giftMode = isset($value['gift_mode']) ? $value['gift_mode'] : "giftable_products"; if ($giftMode === 'giftable_products_in_random') { $giftMode = 'giftable_products_in_rotation'; } $value['gift_mode'] = $giftMode; } $row['get_products']['value'] = $values; // phpcs:ignore WordPress.DB.DirectDatabaseQuery $result = $wpdb->update($table, array('get_products' => serialize($row['get_products'])), array('id' => $row['id'])); } } public static function migrateConditionsTo_4_0_0() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, conditions FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); $rows = array_filter(array_map(function ($item) { $result = array( 'id' => $item->id, 'conditions' => unserialize($item->conditions), ); if (empty($result['conditions'])) { return false; } return $result; }, $rows)); foreach ($rows as &$row) { $prev_row = $row; foreach ($row['conditions'] as $index => $data) { try { $row['conditions'][$index] = OptionsConverter::convertCondition($data); } catch (\Exception $e) { unset($row['conditions'][$index]); } } if ($prev_row != $row) { $row['conditions'] = serialize($row['conditions']); // phpcs:ignore WordPress.DB.DirectDatabaseQuery $wpdb->update($table, array( 'conditions' => $row['conditions'], ), array('id' => $row['id'])); } } } public static function migrateRuleTypeTo_4_0_0() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, exclusive FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql, ARRAY_A); foreach ($rows as $row) { $rule_type = $row['exclusive'] ? RuleTypeEnum::EXCLUSIVE()->getValue() : RuleTypeEnum::COMMON()->getValue(); // phpcs:ignore WordPress.DB.DirectDatabaseQuery $wpdb->update($table, array( 'rule_type' => $rule_type, ), array('id' => $row['id'])); } } public static function migrateOptionsTo_3_3_1() { $context = new Context(); $settings = $context->getSettings(); $externalCouponsBehavior = $settings->getOption('external_coupons_behavior'); $settings->set('external_product_coupons_behavior', $externalCouponsBehavior); $settings->set('external_cart_coupons_behavior', $externalCouponsBehavior); $settings->save(); } public static function migrateOptionsTo_4_0_0() { $context = new Context(); $settings = $context->getSettings(); $allowToMergeCartItems = $settings->getOption('allow_to_merge_cart_items'); $settings->set('split_same_product_if_diff_costs', ! $allowToMergeCartItems); $settings->save(); } public static function migrateSplitDiscountByTo_4_0_0() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, product_adjustments, bulk_adjustments FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); $rows = array_filter(array_map(function ($item) { $result = array( 'id' => $item->id, 'product_adjustments' => unserialize($item->product_adjustments), 'bulk_adjustments' => unserialize($item->bulk_adjustments), ); if (empty($result['product_adjustments'])) { return false; } return $result; }, $rows)); foreach ($rows as $row) { $changes = array(); $prodAdjSplitDiscountBy = $row['product_adjustments']['split_discount_by'] ?? false; if ($prodAdjSplitDiscountBy instanceof \__PHP_Incomplete_Class) { $objArray = (array)$prodAdjSplitDiscountBy; foreach ($objArray as $k => $v) { if ($k == '__PHP_Incomplete_Class_Name') { continue; } $parts = explode(chr(0), $k); $key = $parts[0] == $k ? $k : $parts[2]; if ($key == 'value') { $row['product_adjustments']['split_discount_by'] = $v; $changes['product_adjustments'] = serialize($row['product_adjustments']); break; } } } $bulkAdjSplitDiscountBy = $row['bulk_adjustments']['split_discount_by'] ?? false; if ($bulkAdjSplitDiscountBy instanceof \__PHP_Incomplete_Class) { $objArray = (array)$bulkAdjSplitDiscountBy; foreach ($objArray as $k => $v) { if ($k == '__PHP_Incomplete_Class_Name') { continue; } $parts = explode(chr(0), $k); $key = $parts[0] == $k ? $k : $parts[2]; if ($key == 'value') { $row['bulk_adjustments']['split_discount_by'] = $v; $changes['bulk_adjustments'] = serialize($row['bulk_adjustments']); break; } } } if (!empty($changes)) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery $wpdb->update($table, $changes, array('id' => $row['id'])); } } } public static function migrateSummaryTo_4_1_0() { $ruleRepository = new RuleRepository(); foreach ($ruleRepository->getRules() as $rule) { $ruleRepository->storeRule($rule); } } public static function migrateConditionsTo_4_1_3() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, conditions FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); $rows = array_filter(array_map(function ($item) { $result = array( 'id' => $item->id, 'conditions' => unserialize($item->conditions), ); if (empty($result['conditions'])) { return false; } return $result; }, $rows)); $conditionsLoader = Factory::get("Core_Rule_CartCondition_ConditionsLoader"); $qtyKey = ProductMeasure::MEASURE_QTY()->getValue(); $sumKey = ProductMeasure::MEASURE_SUM()->getValue(); $weightKey = ProductMeasure::MEASURE_WEIGHT()->getValue(); foreach ($rows as &$row) { $prev_row = $row; foreach ($row['conditions'] as &$data) { $type = preg_replace(array("/^{$sumKey}_/","/^{$weightKey}_/"), '', $data['type']); if (strpos($type, 'custom_taxonomy') !== false) { $type = substr_replace($type, '_all', strpos($type, 'custom_taxonomy') + strlen('custom_taxonomy'), 0); } else { $type .= '_all'; } try { $condition = $conditionsLoader->create($type); } catch (\Exception $e) { continue; //if it's not a product condition } if ($condition instanceof ProductAll) { $productMeasure = $qtyKey; if (preg_match("/^{$sumKey}_/", $data['type'])) { $productMeasure = $sumKey; } elseif (preg_match("/^{$weightKey}_/", $data['type'])) { $productMeasure = $weightKey; } $data['type'] = $type; $data['options'][ProductAll::PRODUCT_MEASURE_KEY] = $productMeasure; } } if ($prev_row != $row) { $row['conditions'] = serialize($row['conditions']); // phpcs:ignore WordPress.DB.DirectDatabaseQuery $wpdb->update($table, array( 'conditions' => $row['conditions'], ), array('id' => $row['id'])); } } } public static function migrateSummaryTo_4_1_6() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, advertising FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); $rows = array_map(function ($item) { $result = array( 'id' => $item->id, 'advertising' => unserialize($item->advertising), ); return $result; }, $rows); foreach ($rows as &$row) { $row['advertising']['discount_message_cart_item'] = $row['advertising']['discount_message'] ?? ""; // phpcs:ignore WordPress.DB.DirectDatabaseQuery $result = $wpdb->update( $table, array( 'advertising' => serialize($row['advertising'])), array('id' => $row['id']) ); } } public static function migrateCompatibilityOptionsTo_4_1_6() { global $wpdb; $cnxt = adp_context(); $cnxt->getCompatibilitySettings()->set("dont_apply_discount_to_addons", $cnxt->getOption("dont_apply_discount_to_addons")); $cnxt->getCompatibilitySettings()->set("enable_wc_product_bundles_cmp", $cnxt->getOption("enable_wc_product_bundles_cmp")); $cnxt->getCompatibilitySettings()->save(); } public static function migratethemeOptionsTo_4_4_3() { $themeModificationsRepository = new ThemeModificationsRepository(); $attrOptions = $themeModificationsRepository->getModifications(); $options = $attrOptions[AdvertisingThemeProperties::KEY] ?? []; $context = new Context(); $settings = $context->getSettings(); $keys = [ 'is_enable_cart_amount_saved' => AdvertisingThemeProperties\CartMenu::KEY, 'is_enable_minicart_amount_saved' => AdvertisingThemeProperties\MiniCartMenu::KEY, 'is_enable_checkout_amount_saved' => AdvertisingThemeProperties\CheckoutMenu::KEY, 'is_enable_backend_order_amount_saved' => "wdp_discount_message-edit-order", ]; if( class_exists('\ADP\ProVersion\Includes\CustomizerExtensions\AdvertisingThemeProperties\EmailOrderMenu') && class_exists('\ADP\ProVersion\Includes\CustomizerExtensions\AdvertisingThemeProperties\OrderPageMenu') ) { $keys = array_merge($keys, [ 'is_enable_order_amount_saved' => \ADP\ProVersion\Includes\CustomizerExtensions\AdvertisingThemeProperties\OrderPageMenu::KEY, 'is_enable_email_order_amount_saved' => \ADP\ProVersion\Includes\CustomizerExtensions\AdvertisingThemeProperties\EmailOrderMenu::KEY, ]); } foreach($keys as $newOptionName => $key) { $enable = $options[$key]['enable'] ?? false; $settings->set($newOptionName, $enable); } $settings->save(); } public static function migratePostalCodesConditionsTo_4_5_3() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, conditions FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); $rows = array_filter(array_map(function ($item) { $result = array( 'id' => $item->id, 'conditions' => unserialize($item->conditions), ); if (empty($result['conditions'])) { return false; } return $result; }, $rows)); foreach ($rows as &$row) { $hasTypeCustomerPostcode = false; foreach ($row['conditions'] as &$data) { if('customer_postcode' !== $data['type']) { continue; } $hasTypeCustomerPostcode = true; $data['options'][ValueComparisonCondition::COMPARISON_VALUE_METHOD_KEY] = $data['options'][ListComparisonCondition::COMPARISON_LIST_METHOD_KEY]; $data['options'][ValueComparisonCondition::COMPARISON_VALUE_KEY] = $data['options'][ListComparisonCondition::COMPARISON_LIST_KEY]; unset($data['options'][ListComparisonCondition::COMPARISON_LIST_METHOD_KEY]); unset($data['options'][ListComparisonCondition::COMPARISON_LIST_KEY]); } if($hasTypeCustomerPostcode) { $row['conditions'] = serialize($row['conditions']); // phpcs:ignore WordPress.DB.DirectDatabaseQuery $wpdb->update($table, array( 'conditions' => $row['conditions'], ), array('id' => $row['id'])); } } } public static function migrateSpentConditionsTo_4_5_3() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, conditions FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); $rows = array_filter(array_map(function ($item) { $result = array( 'id' => $item->id, 'conditions' => unserialize($item->conditions), ); if (empty($result['conditions'])) { return false; } $hasSpentConditions = false; foreach($result['conditions'] as $data) { if(in_array($data['type'], ['customer_spent_and_subtotal', 'customer_spent_and_subtotal_inc_vat'])) { $hasSpentConditions = true; } } if(!$hasSpentConditions) { return false; } return $result; }, $rows)); foreach ($rows as &$row) { foreach ($row['conditions'] as &$data) { if(!in_array($data['type'], ['customer_spent_and_subtotal', 'customer_spent_and_subtotal_inc_vat'])) { continue; } $data['options']['time_range'] = 'all_time'; } $row['conditions'] = serialize($row['conditions']); // phpcs:ignore WordPress.DB.DirectDatabaseQuery $wpdb->update($table, array( 'conditions' => $row['conditions'], ), array('id' => $row['id'])); } } public static function migrateSummaryTo_4_10_4() { global $wpdb; if(!class_exists('\ADP\ProVersion\Includes\Database\Models\Collection')) { return; } $table = $wpdb->prefix . \ADP\ProVersion\Includes\Database\Models\Collection::TABLE_NAME; //phpcs:disable WordPress.DB.DirectDatabaseQuery $column_exists = $wpdb->get_results( //phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared $wpdb->prepare("SHOW COLUMNS FROM {$table} LIKE %s", 'conditions_relationship') ); if (empty($column_exists)) { //phpcs:disable WordPress.DB.PreparedSQL, WordPress.DB.DirectDatabaseQuery $wpdb->query("ALTER TABLE {$table} ADD COLUMN conditions_relationship BOOLEAN DEFAULT TRUE"); //phpcs:disable WordPress.DB.PreparedSQL, WordPress.DB.DirectDatabaseQuery $wpdb->query("UPDATE {$table} SET conditions_relationship = TRUE"); } //phpcs:disable WordPress.DB.DirectDatabaseQuery $column_exists = $wpdb->get_results( //phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared $wpdb->prepare("SHOW COLUMNS FROM {$table} LIKE %s", 'summary') ); if (empty($column_exists)) { //phpcs:disable WordPress.DB.PreparedSQL, WordPress.DB.DirectDatabaseQuery $wpdb->query("ALTER TABLE {$table} ADD COLUMN summary TEXT DEFAULT NULL"); } if (!class_exists("\ADP\ProVersion\Includes\Database\Repository\CollectionRepository")) { return; } $productCollections = \ADP\ProVersion\Includes\Database\Repository\CollectionRepository::getProductCollections(); foreach ($productCollections as $collection) { \ADP\ProVersion\Includes\Database\Repository\CollectionRepository::storeProductCollection($collection); } } public static function migrateSummaryTo_4_12_0() { global $wpdb; $table = $wpdb->prefix . Rule::TABLE_NAME; $sql = "SELECT id, filters FROM $table"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared $rows = $wpdb->get_results($sql); foreach ($rows as $item) { $id = $item->id; $filters = unserialize($item->filters); if(empty($filters)) { continue; } $changed = false; foreach ($filters as &$filter) { $excludes = []; if(isset($filter['method']) && $filter['method'] === 'not_in_list') { $excludes[$filter['type']] = [ 'type' => $filter['type'], 'value' => $filter['value'] ]; $filter['type'] = 'any'; $filter['method'] = ''; $filter['value'] = ''; $changed = true; } if(isset($filter['product_exclude']) && isset($filter['product_exclude']['values']) && is_array($filter['product_exclude']['values']) && !empty($filter['product_exclude']['values'])) { if(isset($excludes['products'])) { $excludes['products']['value'] = array_unique( array_merge( $excludes['products']['value'], $filter['product_exclude']['values'] ) ); } else { $excludes['products'] = [ 'type' => 'products', 'value' => $filter['product_exclude']['values'] ]; } unset($filter['product_exclude']['values']); $changed = true; } if(isset($filter['collections_exclude']) && isset($filter['collections_exclude']['values']) && is_array($filter['collections_exclude']['values']) && !empty($filter['collections_exclude']['values'])) { if(isset($excludes['product_collections'])) { $excludes['product_collections']['value'] = array_unique( array_merge( $excludes['product_collections']['value'], $filter['collections_exclude']['values'] ) ); } else { $excludes['product_collections'] = [ 'type' => 'product_collections', 'value' => $filter['collections_exclude']['values'] ]; } unset($filter['collections_exclude']); $changed = true; } if($changed) { $filter['excludes'] = array_values($excludes); } } if($changed) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery $wpdb->update($table, [ 'filters' => serialize($filters), ], ['id' => $id]); } } } }