File "class-wc-install.php"

Full path: /home/kosmetik/public_html/wp-content/plugins/woocommerce/includes/class-wc-install.php
File size: 50.53 B
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor   Back

<?php

use Automattic\Jetpack\Constants;
use Automattic\WooCommerce\Internal\WCCom\ConnectionHelper as WCConnectionHelper;
defined('ABSPATH') || exit;
class WC_Install
{
    private static $db_updates = array('2.0.0' => array('wc_update_200_file_paths', 'wc_update_200_permalinks', 'wc_update_200_subcat_display', 'wc_update_200_taxrates', 'wc_update_200_line_items', 'wc_update_200_images', 'wc_update_200_db_version'), '2.0.9' => array('wc_update_209_brazillian_state', 'wc_update_209_db_version'), '2.1.0' => array('wc_update_210_remove_pages', 'wc_update_210_file_paths', 'wc_update_210_db_version'), '2.2.0' => array('wc_update_220_shipping', 'wc_update_220_order_status', 'wc_update_220_variations', 'wc_update_220_attributes', 'wc_update_220_db_version'), '2.3.0' => array('wc_update_230_options', 'wc_update_230_db_version'), '2.4.0' => array('wc_update_240_options', 'wc_update_240_shipping_methods', 'wc_update_240_api_keys', 'wc_update_240_refunds', 'wc_update_240_db_version'), '2.4.1' => array('wc_update_241_variations', 'wc_update_241_db_version'), '2.5.0' => array('wc_update_250_currency', 'wc_update_250_db_version'), '2.6.0' => array('wc_update_260_options', 'wc_update_260_termmeta', 'wc_update_260_zones', 'wc_update_260_zone_methods', 'wc_update_260_refunds', 'wc_update_260_db_version'), '3.0.0' => array('wc_update_300_grouped_products', 'wc_update_300_settings', 'wc_update_300_product_visibility', 'wc_update_300_db_version'), '3.1.0' => array('wc_update_310_downloadable_products', 'wc_update_310_old_comments', 'wc_update_310_db_version'), '3.1.2' => array('wc_update_312_shop_manager_capabilities', 'wc_update_312_db_version'), '3.2.0' => array('wc_update_320_mexican_states', 'wc_update_320_db_version'), '3.3.0' => array('wc_update_330_image_options', 'wc_update_330_webhooks', 'wc_update_330_product_stock_status', 'wc_update_330_set_default_product_cat', 'wc_update_330_clear_transients', 'wc_update_330_set_paypal_sandbox_credentials', 'wc_update_330_db_version'), '3.4.0' => array('wc_update_340_states', 'wc_update_340_state', 'wc_update_340_last_active', 'wc_update_340_db_version'), '3.4.3' => array('wc_update_343_cleanup_foreign_keys', 'wc_update_343_db_version'), '3.4.4' => array('wc_update_344_recreate_roles', 'wc_update_344_db_version'), '3.5.0' => array('wc_update_350_reviews_comment_type', 'wc_update_350_db_version'), '3.5.2' => array('wc_update_352_drop_download_log_fk'), '3.5.4' => array('wc_update_354_modify_shop_manager_caps', 'wc_update_354_db_version'), '3.6.0' => array('wc_update_360_product_lookup_tables', 'wc_update_360_term_meta', 'wc_update_360_downloadable_product_permissions_index', 'wc_update_360_db_version'), '3.7.0' => array('wc_update_370_tax_rate_classes', 'wc_update_370_mro_std_currency', 'wc_update_370_db_version'), '3.9.0' => array('wc_update_390_move_maxmind_database', 'wc_update_390_change_geolocation_database_update_cron', 'wc_update_390_db_version'), '4.0.0' => array('wc_update_product_lookup_tables', 'wc_update_400_increase_size_of_column', 'wc_update_400_reset_action_scheduler_migration_status', 'wc_update_400_db_version'), '4.4.0' => array('wc_update_440_insert_attribute_terms_for_variable_products', 'wc_update_440_db_version'), '4.5.0' => array('wc_update_450_sanitize_coupons_code', 'wc_update_450_db_version'), '5.0.0' => array('wc_update_500_fix_product_review_count', 'wc_update_500_db_version'), '5.6.0' => array('wc_update_560_create_refund_returns_page', 'wc_update_560_db_version'));
    public static function init()
    {
        add_action('init', array(__CLASS__, 'check_version'), 5);
        add_action('init', array(__CLASS__, 'manual_database_update'), 20);
        add_action('admin_init', array(__CLASS__, 'wc_admin_db_update_notice'));
        add_action('admin_init', array(__CLASS__, 'add_admin_note_after_page_created'));
        add_action('woocommerce_run_update_callback', array(__CLASS__, 'run_update_callback'));
        add_action('admin_init', array(__CLASS__, 'install_actions'));
        add_action('woocommerce_page_created', array(__CLASS__, 'page_created'), 10, 2);
        add_filter('plugin_action_links_' . WC_PLUGIN_BASENAME, array(__CLASS__, 'plugin_action_links'));
        add_filter('plugin_row_meta', array(__CLASS__, 'plugin_row_meta'), 10, 2);
        add_filter('wpmu_drop_tables', array(__CLASS__, 'wpmu_drop_tables'));
        add_filter('cron_schedules', array(__CLASS__, 'cron_schedules'));
    }
    public static function check_version()
    {
        if (!Constants::is_defined('IFRAME_REQUEST') && version_compare(get_option('woocommerce_version'), WC()->version, '<')) {
            self::install();
            do_action('woocommerce_updated');
        }
    }
    public static function manual_database_update()
    {
        $blog_id = get_current_blog_id();
        add_action('wp_' . $blog_id . '_wc_updater_cron', array(__CLASS__, 'run_manual_database_update'));
    }
    public static function wc_admin_db_update_notice()
    {
        if (WC()->is_wc_admin_active() && false !== get_option('woocommerce_admin_install_timestamp')) {
            new WC_Notes_Run_Db_Update();
        }
    }
    public static function run_manual_database_update()
    {
        self::update();
    }
    public static function run_update_callback($update_callback)
    {
        include_once dirname(__FILE__) . '/wc-update-functions.php';
        if (is_callable($update_callback)) {
            self::run_update_callback_start($update_callback);
            $result = (bool) call_user_func($update_callback);
            self::run_update_callback_end($update_callback, $result);
        }
    }
    protected static function run_update_callback_start($callback)
    {
        wc_maybe_define_constant('WC_UPDATING', true);
    }
    protected static function run_update_callback_end($callback, $result)
    {
        if ($result) {
            WC()->queue()->add('woocommerce_run_update_callback', array('update_callback' => $callback), 'woocommerce-db-updates');
        }
    }
    public static function install_actions()
    {
        if (!empty($_GET['do_update_woocommerce'])) {
            check_admin_referer('wc_db_update', 'wc_db_update_nonce');
            self::update();
            WC_Admin_Notices::add_notice('update', true);
        }
    }
    public static function install()
    {
        if (!is_blog_installed()) {
            return;
        }
        if ('yes' === get_transient('wc_installing')) {
            return;
        }
        set_transient('wc_installing', 'yes', MINUTE_IN_SECONDS * 10);
        wc_maybe_define_constant('WC_INSTALLING', true);
        WC()->wpdb_table_fix();
        self::remove_admin_notices();
        self::create_tables();
        self::verify_base_tables();
        self::create_options();
        self::create_roles();
        self::setup_environment();
        self::create_terms();
        self::create_cron_jobs();
        self::create_files();
        self::maybe_create_pages();
        self::maybe_set_activation_transients();
        self::set_paypal_standard_load_eligibility();
        self::update_wc_version();
        self::maybe_update_db_version();
        delete_transient('wc_installing');
        do_action('woocommerce_flush_rewrite_rules');
        do_action('woocommerce_installed');
    }
    public static function verify_base_tables($modify_notice = true, $execute = false)
    {
        require_once ABSPATH . 'wp-admin/includes/upgrade.php';
        if ($execute) {
            self::create_tables();
        }
        $queries = dbDelta(self::get_schema(), false);
        $missing_tables = array();
        foreach ($queries as $table_name => $result) {
            if ("Created table {$table_name}" === $result) {
                $missing_tables[] = $table_name;
            }
        }
        if (0 < count($missing_tables)) {
            if ($modify_notice) {
                WC_Admin_Notices::add_notice('base_tables_missing');
            }
            update_option('woocommerce_schema_missing_tables', $missing_tables);
        } else {
            if ($modify_notice) {
                WC_Admin_Notices::remove_notice('base_tables_missing');
            }
            update_option('woocommerce_schema_version', WC()->db_version);
            delete_option('woocommerce_schema_missing_tables');
        }
        return $missing_tables;
    }
    private static function remove_admin_notices()
    {
        include_once dirname(__FILE__) . '/admin/class-wc-admin-notices.php';
        WC_Admin_Notices::remove_all_notices();
    }
    private static function setup_environment()
    {
        WC_Post_types::register_post_types();
        WC_Post_types::register_taxonomies();
        WC()->query->init_query_vars();
        WC()->query->add_endpoints();
        WC_API::add_endpoint();
        WC_Auth::add_endpoint();
    }
    public static function is_new_install()
    {
        $product_count = array_sum((array) wp_count_posts('product'));
        return is_null(get_option('woocommerce_version', null)) || 0 === $product_count && -1 === wc_get_page_id('shop');
    }
    public static function needs_db_update()
    {
        $current_db_version = get_option('woocommerce_db_version', null);
        $updates = self::get_db_update_callbacks();
        $update_versions = array_keys($updates);
        usort($update_versions, 'version_compare');
        return !is_null($current_db_version) && version_compare($current_db_version, end($update_versions), '<');
    }
    private static function maybe_set_activation_transients()
    {
        if (self::is_new_install()) {
            set_transient('_wc_activation_redirect', 1, 30);
        }
    }
    private static function maybe_update_db_version()
    {
        if (self::needs_db_update()) {
            if (apply_filters('woocommerce_enable_auto_update_db', false)) {
                self::update();
            } else {
                WC_Admin_Notices::add_notice('update', true);
            }
        } else {
            self::update_db_version();
        }
    }
    private static function update_wc_version()
    {
        update_option('woocommerce_version', WC()->version);
    }
    public static function get_db_update_callbacks()
    {
        return self::$db_updates;
    }
    private static function update()
    {
        $current_db_version = get_option('woocommerce_db_version');
        $loop = 0;
        foreach (self::get_db_update_callbacks() as $version => $update_callbacks) {
            if (version_compare($current_db_version, $version, '<')) {
                foreach ($update_callbacks as $update_callback) {
                    WC()->queue()->schedule_single(time() + $loop, 'woocommerce_run_update_callback', array('update_callback' => $update_callback), 'woocommerce-db-updates');
                    $loop++;
                }
            }
        }
    }
    public static function update_db_version($version = null)
    {
        update_option('woocommerce_db_version', is_null($version) ? WC()->version : $version);
    }
    public static function cron_schedules($schedules)
    {
        $schedules['monthly'] = array('interval' => 2635200, 'display' => __('Monthly', 'woocommerce'));
        $schedules['fifteendays'] = array('interval' => 1296000, 'display' => __('Every 15 Days', 'woocommerce'));
        return $schedules;
    }
    private static function create_cron_jobs()
    {
        wp_clear_scheduled_hook('woocommerce_scheduled_sales');
        wp_clear_scheduled_hook('woocommerce_cancel_unpaid_orders');
        wp_clear_scheduled_hook('woocommerce_cleanup_sessions');
        wp_clear_scheduled_hook('woocommerce_cleanup_personal_data');
        wp_clear_scheduled_hook('woocommerce_cleanup_logs');
        wp_clear_scheduled_hook('woocommerce_geoip_updater');
        wp_clear_scheduled_hook('woocommerce_tracker_send_event');
        $ve = get_option('gmt_offset') > 0 ? '-' : '+';
        wp_schedule_event(strtotime('00:00 tomorrow ' . $ve . absint(get_option('gmt_offset')) . ' HOURS'), 'daily', 'woocommerce_scheduled_sales');
        $held_duration = get_option('woocommerce_hold_stock_minutes', '60');
        if ('' !== $held_duration) {
            $cancel_unpaid_interval = apply_filters('woocommerce_cancel_unpaid_orders_interval_minutes', absint($held_duration));
            wp_schedule_single_event(time() + absint($cancel_unpaid_interval) * 60, 'woocommerce_cancel_unpaid_orders');
        }
        wp_schedule_event(time() + 10, 'daily', 'woocommerce_cleanup_personal_data');
        wp_schedule_event(time() + 3 * HOUR_IN_SECONDS, 'daily', 'woocommerce_cleanup_logs');
        wp_schedule_event(time() + 6 * HOUR_IN_SECONDS, 'twicedaily', 'woocommerce_cleanup_sessions');
        wp_schedule_event(time() + MINUTE_IN_SECONDS, 'fifteendays', 'woocommerce_geoip_updater');
        wp_schedule_event(time() + 10, apply_filters('woocommerce_tracker_event_recurrence', 'daily'), 'woocommerce_tracker_send_event');
    }
    public static function maybe_create_pages()
    {
        if (empty(get_option('woocommerce_db_version'))) {
            self::create_pages();
        }
    }
    public static function create_pages()
    {
        include_once dirname(__FILE__) . '/admin/wc-admin-functions.php';
        $pages = apply_filters('woocommerce_create_pages', array('shop' => array('name' => _x('shop', 'Page slug', 'woocommerce'), 'title' => _x('Shop', 'Page title', 'woocommerce'), 'content' => ''), 'cart' => array('name' => _x('cart', 'Page slug', 'woocommerce'), 'title' => _x('Cart', 'Page title', 'woocommerce'), 'content' => '<!-- wp:shortcode -->[' . apply_filters('woocommerce_cart_shortcode_tag', 'woocommerce_cart') . ']<!-- /wp:shortcode -->'), 'checkout' => array('name' => _x('checkout', 'Page slug', 'woocommerce'), 'title' => _x('Checkout', 'Page title', 'woocommerce'), 'content' => '<!-- wp:shortcode -->[' . apply_filters('woocommerce_checkout_shortcode_tag', 'woocommerce_checkout') . ']<!-- /wp:shortcode -->'), 'myaccount' => array('name' => _x('my-account', 'Page slug', 'woocommerce'), 'title' => _x('My account', 'Page title', 'woocommerce'), 'content' => '<!-- wp:shortcode -->[' . apply_filters('woocommerce_my_account_shortcode_tag', 'woocommerce_my_account') . ']<!-- /wp:shortcode -->'), 'refund_returns' => array('name' => _x('refund_returns', 'Page slug', 'woocommerce'), 'title' => _x('Refund and Returns Policy', 'Page title', 'woocommerce'), 'content' => self::get_refunds_return_policy_page_content(), 'post_status' => 'draft')));
        foreach ($pages as $key => $page) {
            wc_create_page(esc_sql($page['name']), 'woocommerce_' . $key . '_page_id', $page['title'], $page['content'], !empty($page['parent']) ? wc_get_page_id($page['parent']) : '', !empty($page['post_status']) ? $page['post_status'] : 'publish');
        }
    }
    private static function create_options()
    {
        include_once dirname(__FILE__) . '/admin/class-wc-admin-settings.php';
        $settings = WC_Admin_Settings::get_settings_pages();
        foreach ($settings as $section) {
            if (!method_exists($section, 'get_settings')) {
                continue;
            }
            $subsections = array_unique(array_merge(array(''), array_keys($section->get_sections())));
            foreach ($subsections as $subsection) {
                foreach ($section->get_settings($subsection) as $value) {
                    if (isset($value['default']) && isset($value['id'])) {
                        $autoload = isset($value['autoload']) ? (bool) $value['autoload'] : true;
                        add_option($value['id'], $value['default'], '', $autoload ? 'yes' : 'no');
                    }
                }
            }
        }
        add_option('woocommerce_single_image_width', '600', '', 'yes');
        add_option('woocommerce_thumbnail_image_width', '300', '', 'yes');
        add_option('woocommerce_checkout_highlight_required_fields', 'yes', '', 'yes');
        add_option('woocommerce_demo_store', 'no', '', 'no');
        if (self::is_new_install()) {
            WC_Tax::create_tax_class(__('Reduced rate', 'woocommerce'));
            WC_Tax::create_tax_class(__('Zero rate', 'woocommerce'));
        }
    }
    public static function create_terms()
    {
        $taxonomies = array('product_type' => array('simple', 'grouped', 'variable', 'external'), 'product_visibility' => array('exclude-from-search', 'exclude-from-catalog', 'featured', 'outofstock', 'rated-1', 'rated-2', 'rated-3', 'rated-4', 'rated-5'));
        foreach ($taxonomies as $taxonomy => $terms) {
            foreach ($terms as $term) {
                if (!get_term_by('name', $term, $taxonomy)) {
                    wp_insert_term($term, $taxonomy);
                }
            }
        }
        $woocommerce_default_category = (int) get_option('default_product_cat', 0);
        if (!$woocommerce_default_category || !term_exists($woocommerce_default_category, 'product_cat')) {
            $default_product_cat_id = 0;
            $default_product_cat_slug = sanitize_title(_x('Uncategorized', 'Default category slug', 'woocommerce'));
            $default_product_cat = get_term_by('slug', $default_product_cat_slug, 'product_cat');
            if ($default_product_cat) {
                $default_product_cat_id = absint($default_product_cat->term_taxonomy_id);
            } else {
                $result = wp_insert_term(_x('Uncategorized', 'Default category slug', 'woocommerce'), 'product_cat', array('slug' => $default_product_cat_slug));
                if (!is_wp_error($result) && !empty($result['term_taxonomy_id'])) {
                    $default_product_cat_id = absint($result['term_taxonomy_id']);
                }
            }
            if ($default_product_cat_id) {
                update_option('default_product_cat', $default_product_cat_id);
            }
        }
    }
    private static function create_tables()
    {
        global $wpdb;
        $wpdb->hide_errors();
        require_once ABSPATH . 'wp-admin/includes/upgrade.php';
        if ($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->prefix}woocommerce_downloadable_product_permissions';")) {
            if (!$wpdb->get_var("SHOW COLUMNS FROM `{$wpdb->prefix}woocommerce_downloadable_product_permissions` LIKE 'permission_id';")) {
                $wpdb->query("ALTER TABLE {$wpdb->prefix}woocommerce_downloadable_product_permissions DROP PRIMARY KEY, ADD `permission_id` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;");
            }
        }
        if ($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->prefix}woocommerce_sessions'")) {
            if (!$wpdb->get_var("SHOW KEYS FROM {$wpdb->prefix}woocommerce_sessions WHERE Key_name = 'PRIMARY' AND Column_name = 'session_id'")) {
                $wpdb->query("ALTER TABLE `{$wpdb->prefix}woocommerce_sessions` DROP PRIMARY KEY, DROP KEY `session_id`, ADD PRIMARY KEY(`session_id`), ADD UNIQUE KEY(`session_key`)");
            }
        }
        dbDelta(self::get_schema());
        $index_exists = $wpdb->get_row("SHOW INDEX FROM {$wpdb->comments} WHERE column_name = 'comment_type' and key_name = 'woo_idx_comment_type'");
        if (is_null($index_exists)) {
            $wpdb->query("ALTER TABLE {$wpdb->comments} ADD INDEX woo_idx_comment_type (comment_type)");
        }
        $download_log_columns = $wpdb->get_results("SHOW COLUMNS FROM {$wpdb->prefix}wc_download_log WHERE Field = 'permission_id'", ARRAY_A);
        $download_log_column_type = '';
        if (isset($download_log_columns[0]['Type'])) {
            $download_log_column_type = $download_log_columns[0]['Type'];
        }
        $download_permissions_columns = $wpdb->get_results("SHOW COLUMNS FROM {$wpdb->prefix}woocommerce_downloadable_product_permissions WHERE Field = 'permission_id'", ARRAY_A);
        $download_permissions_column_type = '';
        if (isset($download_permissions_columns[0]['Type'])) {
            $download_permissions_column_type = $download_permissions_columns[0]['Type'];
        }
        if (!empty($download_permissions_column_type) && !empty($download_log_column_type) && $download_permissions_column_type === $download_log_column_type) {
            $fk_result = $wpdb->get_row("SHOW CREATE TABLE {$wpdb->prefix}wc_download_log");
            if (false === strpos($fk_result->{'Create Table'}, "fk_{$wpdb->prefix}wc_download_log_permission_id")) {
                $wpdb->query("ALTER TABLE `{$wpdb->prefix}wc_download_log`\n\t\t\t\t\tADD CONSTRAINT `fk_{$wpdb->prefix}wc_download_log_permission_id`\n\t\t\t\t\tFOREIGN KEY (`permission_id`)\n\t\t\t\t\tREFERENCES `{$wpdb->prefix}woocommerce_downloadable_product_permissions` (`permission_id`) ON DELETE CASCADE;");
            }
        }
        delete_transient('wc_attribute_taxonomies');
    }
    private static function get_schema()
    {
        global $wpdb;
        $collate = '';
        if ($wpdb->has_cap('collation')) {
            $collate = $wpdb->get_charset_collate();
        }
        $max_index_length = 191;
        $tables = "\nCREATE TABLE {$wpdb->prefix}woocommerce_sessions (\n  session_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n  session_key char(32) NOT NULL,\n  session_value longtext NOT NULL,\n  session_expiry BIGINT UNSIGNED NOT NULL,\n  PRIMARY KEY  (session_id),\n  UNIQUE KEY session_key (session_key)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_api_keys (\n  key_id BIGINT UNSIGNED NOT NULL auto_increment,\n  user_id BIGINT UNSIGNED NOT NULL,\n  description varchar(200) NULL,\n  permissions varchar(10) NOT NULL,\n  consumer_key char(64) NOT NULL,\n  consumer_secret char(43) NOT NULL,\n  nonces longtext NULL,\n  truncated_key char(7) NOT NULL,\n  last_access datetime NULL default null,\n  PRIMARY KEY  (key_id),\n  KEY consumer_key (consumer_key),\n  KEY consumer_secret (consumer_secret)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_attribute_taxonomies (\n  attribute_id BIGINT UNSIGNED NOT NULL auto_increment,\n  attribute_name varchar(200) NOT NULL,\n  attribute_label varchar(200) NULL,\n  attribute_type varchar(20) NOT NULL,\n  attribute_orderby varchar(20) NOT NULL,\n  attribute_public int(1) NOT NULL DEFAULT 1,\n  PRIMARY KEY  (attribute_id),\n  KEY attribute_name (attribute_name(20))\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_downloadable_product_permissions (\n  permission_id BIGINT UNSIGNED NOT NULL auto_increment,\n  download_id varchar(36) NOT NULL,\n  product_id BIGINT UNSIGNED NOT NULL,\n  order_id BIGINT UNSIGNED NOT NULL DEFAULT 0,\n  order_key varchar(200) NOT NULL,\n  user_email varchar(200) NOT NULL,\n  user_id BIGINT UNSIGNED NULL,\n  downloads_remaining varchar(9) NULL,\n  access_granted datetime NOT NULL default '0000-00-00 00:00:00',\n  access_expires datetime NULL default null,\n  download_count BIGINT UNSIGNED NOT NULL DEFAULT 0,\n  PRIMARY KEY  (permission_id),\n  KEY download_order_key_product (product_id,order_id,order_key(16),download_id),\n  KEY download_order_product (download_id,order_id,product_id),\n  KEY order_id (order_id),\n  KEY user_order_remaining_expires (user_id,order_id,downloads_remaining,access_expires)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_order_items (\n  order_item_id BIGINT UNSIGNED NOT NULL auto_increment,\n  order_item_name TEXT NOT NULL,\n  order_item_type varchar(200) NOT NULL DEFAULT '',\n  order_id BIGINT UNSIGNED NOT NULL,\n  PRIMARY KEY  (order_item_id),\n  KEY order_id (order_id)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_order_itemmeta (\n  meta_id BIGINT UNSIGNED NOT NULL auto_increment,\n  order_item_id BIGINT UNSIGNED NOT NULL,\n  meta_key varchar(255) default NULL,\n  meta_value longtext NULL,\n  PRIMARY KEY  (meta_id),\n  KEY order_item_id (order_item_id),\n  KEY meta_key (meta_key(32))\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_tax_rates (\n  tax_rate_id BIGINT UNSIGNED NOT NULL auto_increment,\n  tax_rate_country varchar(2) NOT NULL DEFAULT '',\n  tax_rate_state varchar(200) NOT NULL DEFAULT '',\n  tax_rate varchar(8) NOT NULL DEFAULT '',\n  tax_rate_name varchar(200) NOT NULL DEFAULT '',\n  tax_rate_priority BIGINT UNSIGNED NOT NULL,\n  tax_rate_compound int(1) NOT NULL DEFAULT 0,\n  tax_rate_shipping int(1) NOT NULL DEFAULT 1,\n  tax_rate_order BIGINT UNSIGNED NOT NULL,\n  tax_rate_class varchar(200) NOT NULL DEFAULT '',\n  PRIMARY KEY  (tax_rate_id),\n  KEY tax_rate_country (tax_rate_country),\n  KEY tax_rate_state (tax_rate_state(2)),\n  KEY tax_rate_class (tax_rate_class(10)),\n  KEY tax_rate_priority (tax_rate_priority)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_tax_rate_locations (\n  location_id BIGINT UNSIGNED NOT NULL auto_increment,\n  location_code varchar(200) NOT NULL,\n  tax_rate_id BIGINT UNSIGNED NOT NULL,\n  location_type varchar(40) NOT NULL,\n  PRIMARY KEY  (location_id),\n  KEY tax_rate_id (tax_rate_id),\n  KEY location_type_code (location_type(10),location_code(20))\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_shipping_zones (\n  zone_id BIGINT UNSIGNED NOT NULL auto_increment,\n  zone_name varchar(200) NOT NULL,\n  zone_order BIGINT UNSIGNED NOT NULL,\n  PRIMARY KEY  (zone_id)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_shipping_zone_locations (\n  location_id BIGINT UNSIGNED NOT NULL auto_increment,\n  zone_id BIGINT UNSIGNED NOT NULL,\n  location_code varchar(200) NOT NULL,\n  location_type varchar(40) NOT NULL,\n  PRIMARY KEY  (location_id),\n  KEY location_id (location_id),\n  KEY location_type_code (location_type(10),location_code(20))\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_shipping_zone_methods (\n  zone_id BIGINT UNSIGNED NOT NULL,\n  instance_id BIGINT UNSIGNED NOT NULL auto_increment,\n  method_id varchar(200) NOT NULL,\n  method_order BIGINT UNSIGNED NOT NULL,\n  is_enabled tinyint(1) NOT NULL DEFAULT '1',\n  PRIMARY KEY  (instance_id)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_payment_tokens (\n  token_id BIGINT UNSIGNED NOT NULL auto_increment,\n  gateway_id varchar(200) NOT NULL,\n  token text NOT NULL,\n  user_id BIGINT UNSIGNED NOT NULL DEFAULT '0',\n  type varchar(200) NOT NULL,\n  is_default tinyint(1) NOT NULL DEFAULT '0',\n  PRIMARY KEY  (token_id),\n  KEY user_id (user_id)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_payment_tokenmeta (\n  meta_id BIGINT UNSIGNED NOT NULL auto_increment,\n  payment_token_id BIGINT UNSIGNED NOT NULL,\n  meta_key varchar(255) NULL,\n  meta_value longtext NULL,\n  PRIMARY KEY  (meta_id),\n  KEY payment_token_id (payment_token_id),\n  KEY meta_key (meta_key(32))\n) {$collate};\nCREATE TABLE {$wpdb->prefix}woocommerce_log (\n  log_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n  timestamp datetime NOT NULL,\n  level smallint(4) NOT NULL,\n  source varchar(200) NOT NULL,\n  message longtext NOT NULL,\n  context longtext NULL,\n  PRIMARY KEY (log_id),\n  KEY level (level)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}wc_webhooks (\n  webhook_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n  status varchar(200) NOT NULL,\n  name text NOT NULL,\n  user_id BIGINT UNSIGNED NOT NULL,\n  delivery_url text NOT NULL,\n  secret text NOT NULL,\n  topic varchar(200) NOT NULL,\n  date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  date_created_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  date_modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  date_modified_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  api_version smallint(4) NOT NULL,\n  failure_count smallint(10) NOT NULL DEFAULT '0',\n  pending_delivery tinyint(1) NOT NULL DEFAULT '0',\n  PRIMARY KEY  (webhook_id),\n  KEY user_id (user_id)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}wc_download_log (\n  download_log_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n  timestamp datetime NOT NULL,\n  permission_id BIGINT UNSIGNED NOT NULL,\n  user_id BIGINT UNSIGNED NULL,\n  user_ip_address VARCHAR(100) NULL DEFAULT '',\n  PRIMARY KEY  (download_log_id),\n  KEY permission_id (permission_id),\n  KEY timestamp (timestamp)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}wc_product_meta_lookup (\n  `product_id` bigint(20) NOT NULL,\n  `sku` varchar(100) NULL default '',\n  `virtual` tinyint(1) NULL default 0,\n  `downloadable` tinyint(1) NULL default 0,\n  `min_price` decimal(19,4) NULL default NULL,\n  `max_price` decimal(19,4) NULL default NULL,\n  `onsale` tinyint(1) NULL default 0,\n  `stock_quantity` double NULL default NULL,\n  `stock_status` varchar(100) NULL default 'instock',\n  `rating_count` bigint(20) NULL default 0,\n  `average_rating` decimal(3,2) NULL default 0.00,\n  `total_sales` bigint(20) NULL default 0,\n  `tax_status` varchar(100) NULL default 'taxable',\n  `tax_class` varchar(100) NULL default '',\n  PRIMARY KEY  (`product_id`),\n  KEY `virtual` (`virtual`),\n  KEY `downloadable` (`downloadable`),\n  KEY `stock_status` (`stock_status`),\n  KEY `stock_quantity` (`stock_quantity`),\n  KEY `onsale` (`onsale`),\n  KEY min_max_price (`min_price`, `max_price`)\n) {$collate};\nCREATE TABLE {$wpdb->prefix}wc_tax_rate_classes (\n  tax_rate_class_id BIGINT UNSIGNED NOT NULL auto_increment,\n  name varchar(200) NOT NULL DEFAULT '',\n  slug varchar(200) NOT NULL DEFAULT '',\n  PRIMARY KEY  (tax_rate_class_id),\n  UNIQUE KEY slug (slug({$max_index_length}))\n) {$collate};\nCREATE TABLE {$wpdb->prefix}wc_reserved_stock (\n\t`order_id` bigint(20) NOT NULL,\n\t`product_id` bigint(20) NOT NULL,\n\t`stock_quantity` double NOT NULL DEFAULT 0,\n\t`timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n\t`expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n\tPRIMARY KEY  (`order_id`, `product_id`)\n) {$collate};\n\t\t";
        return $tables;
    }
    public static function get_tables()
    {
        global $wpdb;
        $tables = array("{$wpdb->prefix}wc_download_log", "{$wpdb->prefix}wc_product_meta_lookup", "{$wpdb->prefix}wc_tax_rate_classes", "{$wpdb->prefix}wc_webhooks", "{$wpdb->prefix}woocommerce_api_keys", "{$wpdb->prefix}woocommerce_attribute_taxonomies", "{$wpdb->prefix}woocommerce_downloadable_product_permissions", "{$wpdb->prefix}woocommerce_log", "{$wpdb->prefix}woocommerce_order_itemmeta", "{$wpdb->prefix}woocommerce_order_items", "{$wpdb->prefix}woocommerce_payment_tokenmeta", "{$wpdb->prefix}woocommerce_payment_tokens", "{$wpdb->prefix}woocommerce_sessions", "{$wpdb->prefix}woocommerce_shipping_zone_locations", "{$wpdb->prefix}woocommerce_shipping_zone_methods", "{$wpdb->prefix}woocommerce_shipping_zones", "{$wpdb->prefix}woocommerce_tax_rate_locations", "{$wpdb->prefix}woocommerce_tax_rates", "{$wpdb->prefix}wc_reserved_stock");
        $tables = apply_filters('woocommerce_install_get_tables', $tables);
        return $tables;
    }
    public static function drop_tables()
    {
        global $wpdb;
        $tables = self::get_tables();
        foreach ($tables as $table) {
            $wpdb->query("DROP TABLE IF EXISTS {$table}");
        }
    }
    public static function wpmu_drop_tables($tables)
    {
        return array_merge($tables, self::get_tables());
    }
    public static function create_roles()
    {
        global $wp_roles;
        if (!class_exists('WP_Roles')) {
            return;
        }
        if (!isset($wp_roles)) {
            $wp_roles = new WP_Roles();
        }
        _x('Customer', 'User role', 'woocommerce');
        _x('Shop manager', 'User role', 'woocommerce');
        add_role('customer', 'Customer', array('read' => true));
        add_role('shop_manager', 'Shop manager', array('level_9' => true, 'level_8' => true, 'level_7' => true, 'level_6' => true, 'level_5' => true, 'level_4' => true, 'level_3' => true, 'level_2' => true, 'level_1' => true, 'level_0' => true, 'read' => true, 'read_private_pages' => true, 'read_private_posts' => true, 'edit_posts' => true, 'edit_pages' => true, 'edit_published_posts' => true, 'edit_published_pages' => true, 'edit_private_pages' => true, 'edit_private_posts' => true, 'edit_others_posts' => true, 'edit_others_pages' => true, 'publish_posts' => true, 'publish_pages' => true, 'delete_posts' => true, 'delete_pages' => true, 'delete_private_pages' => true, 'delete_private_posts' => true, 'delete_published_pages' => true, 'delete_published_posts' => true, 'delete_others_posts' => true, 'delete_others_pages' => true, 'manage_categories' => true, 'manage_links' => true, 'moderate_comments' => true, 'upload_files' => true, 'export' => true, 'import' => true, 'list_users' => true, 'edit_theme_options' => true));
        $capabilities = self::get_core_capabilities();
        foreach ($capabilities as $cap_group) {
            foreach ($cap_group as $cap) {
                $wp_roles->add_cap('shop_manager', $cap);
                $wp_roles->add_cap('administrator', $cap);
            }
        }
    }
    public static function get_core_capabilities()
    {
        $capabilities = array();
        $capabilities['core'] = array('manage_woocommerce', 'view_woocommerce_reports');
        $capability_types = array('product', 'shop_order', 'shop_coupon');
        foreach ($capability_types as $capability_type) {
            $capabilities[$capability_type] = array("edit_{$capability_type}", "read_{$capability_type}", "delete_{$capability_type}", "edit_{$capability_type}s", "edit_others_{$capability_type}s", "publish_{$capability_type}s", "read_private_{$capability_type}s", "delete_{$capability_type}s", "delete_private_{$capability_type}s", "delete_published_{$capability_type}s", "delete_others_{$capability_type}s", "edit_private_{$capability_type}s", "edit_published_{$capability_type}s", "manage_{$capability_type}_terms", "edit_{$capability_type}_terms", "delete_{$capability_type}_terms", "assign_{$capability_type}_terms");
        }
        return $capabilities;
    }
    public static function remove_roles()
    {
        global $wp_roles;
        if (!class_exists('WP_Roles')) {
            return;
        }
        if (!isset($wp_roles)) {
            $wp_roles = new WP_Roles();
        }
        $capabilities = self::get_core_capabilities();
        foreach ($capabilities as $cap_group) {
            foreach ($cap_group as $cap) {
                $wp_roles->remove_cap('shop_manager', $cap);
                $wp_roles->remove_cap('administrator', $cap);
            }
        }
        remove_role('customer');
        remove_role('shop_manager');
    }
    private static function create_files()
    {
        if (apply_filters('woocommerce_install_skip_create_files', false)) {
            return;
        }
        $upload_dir = wp_get_upload_dir();
        $download_method = get_option('woocommerce_file_download_method', 'force');
        $files = array(array('base' => $upload_dir['basedir'] . '/woocommerce_uploads', 'file' => 'index.html', 'content' => ''), array('base' => WC_LOG_DIR, 'file' => '.htaccess', 'content' => 'deny from all'), array('base' => WC_LOG_DIR, 'file' => 'index.html', 'content' => ''), array('base' => $upload_dir['basedir'] . '/woocommerce_uploads', 'file' => '.htaccess', 'content' => 'redirect' === $download_method ? 'Options -Indexes' : 'deny from all'));
        foreach ($files as $file) {
            if (wp_mkdir_p($file['base']) && !file_exists(trailingslashit($file['base']) . $file['file'])) {
                $file_handle = @fopen(trailingslashit($file['base']) . $file['file'], 'wb');
                if ($file_handle) {
                    fwrite($file_handle, $file['content']);
                    fclose($file_handle);
                }
            }
        }
        self::create_placeholder_image();
    }
    private static function create_placeholder_image()
    {
        $placeholder_image = get_option('woocommerce_placeholder_image', 0);
        if (!empty($placeholder_image)) {
            if (!is_numeric($placeholder_image)) {
                return;
            } elseif ($placeholder_image && wp_attachment_is_image($placeholder_image)) {
                return;
            }
        }
        $upload_dir = wp_upload_dir();
        $source = WC()->plugin_path() . '/assets/images/placeholder-attachment.png';
        $filename = $upload_dir['basedir'] . '/woocommerce-placeholder.png';
        if (!file_exists($filename)) {
            copy($source, $filename);
        }
        if (!file_exists($filename)) {
            update_option('woocommerce_placeholder_image', 0);
            return;
        }
        $filetype = wp_check_filetype(basename($filename), null);
        $attachment = array('guid' => $upload_dir['url'] . '/' . basename($filename), 'post_mime_type' => $filetype['type'], 'post_title' => preg_replace('/\\.[^.]+$/', '', basename($filename)), 'post_content' => '', 'post_status' => 'inherit');
        $attach_id = wp_insert_attachment($attachment, $filename);
        if (is_wp_error($attach_id)) {
            update_option('woocommerce_placeholder_image', 0);
            return;
        }
        update_option('woocommerce_placeholder_image', $attach_id);
        require_once ABSPATH . 'wp-admin/includes/image.php';
        $attach_data = wp_generate_attachment_metadata($attach_id, $filename);
        wp_update_attachment_metadata($attach_id, $attach_data);
    }
    public static function plugin_action_links($links)
    {
        $action_links = array('settings' => '<a href="' . admin_url('admin.php?page=wc-settings') . '" aria-label="' . esc_attr__('View WooCommerce settings', 'woocommerce') . '">' . esc_html__('Settings', 'woocommerce') . '</a>');
        return array_merge($action_links, $links);
    }
    public static function plugin_row_meta($links, $file)
    {
        if (WC_PLUGIN_BASENAME !== $file) {
            return $links;
        }
        $row_meta = array('docs' => '<a href="' . esc_url(apply_filters('woocommerce_docs_url', 'https://docs.woocommerce.com/documentation/plugins/woocommerce/')) . '" aria-label="' . esc_attr__('View WooCommerce documentation', 'woocommerce') . '">' . esc_html__('Docs', 'woocommerce') . '</a>', 'apidocs' => '<a href="' . esc_url(apply_filters('woocommerce_apidocs_url', 'https://docs.woocommerce.com/wc-apidocs/')) . '" aria-label="' . esc_attr__('View WooCommerce API docs', 'woocommerce') . '">' . esc_html__('API docs', 'woocommerce') . '</a>', 'support' => '<a href="' . esc_url(apply_filters('woocommerce_community_support_url', 'https://wordpress.org/support/plugin/woocommerce/')) . '" aria-label="' . esc_attr__('Visit community forums', 'woocommerce') . '">' . esc_html__('Community support', 'woocommerce') . '</a>');
        if (WCConnectionHelper::is_connected()) {
            $row_meta['premium_support'] = '<a href="' . esc_url(apply_filters('woocommerce_support_url', 'https://woocommerce.com/my-account/create-a-ticket/')) . '" aria-label="' . esc_attr__('Visit premium customer support', 'woocommerce') . '">' . esc_html__('Premium support', 'woocommerce') . '</a>';
        }
        return array_merge($links, $row_meta);
    }
    private static function associate_plugin_file($plugins, $key)
    {
        $path = explode('/', $key);
        $filename = end($path);
        $plugins[$filename] = $key;
        return $plugins;
    }
    public static function background_installer($plugin_to_install_id, $plugin_to_install)
    {
        $args = func_get_args();
        if (!empty($plugin_to_install['repo-slug'])) {
            require_once ABSPATH . 'wp-admin/includes/file.php';
            require_once ABSPATH . 'wp-admin/includes/plugin-install.php';
            require_once ABSPATH . 'wp-admin/includes/class-wp-upgrader.php';
            require_once ABSPATH . 'wp-admin/includes/plugin.php';
            WP_Filesystem();
            $skin = new Automatic_Upgrader_Skin();
            $upgrader = new WP_Upgrader($skin);
            $installed_plugins = array_reduce(array_keys(get_plugins()), array(__CLASS__, 'associate_plugin_file'));
            if (empty($installed_plugins)) {
                $installed_plugins = array();
            }
            $plugin_slug = $plugin_to_install['repo-slug'];
            $plugin_file = isset($plugin_to_install['file']) ? $plugin_to_install['file'] : $plugin_slug . '.php';
            $installed = false;
            $activate = false;
            if (isset($installed_plugins[$plugin_file])) {
                $installed = true;
                $activate = !is_plugin_active($installed_plugins[$plugin_file]);
            }
            if (!$installed) {
                ob_start();
                try {
                    $plugin_information = plugins_api('plugin_information', array('slug' => $plugin_slug, 'fields' => array('short_description' => false, 'sections' => false, 'requires' => false, 'rating' => false, 'ratings' => false, 'downloaded' => false, 'last_updated' => false, 'added' => false, 'tags' => false, 'homepage' => false, 'donate_link' => false, 'author_profile' => false, 'author' => false)));
                    if (is_wp_error($plugin_information)) {
                        throw new Exception($plugin_information->get_error_message());
                    }
                    $package = $plugin_information->download_link;
                    $download = $upgrader->download_package($package);
                    if (is_wp_error($download)) {
                        throw new Exception($download->get_error_message());
                    }
                    $working_dir = $upgrader->unpack_package($download, true);
                    if (is_wp_error($working_dir)) {
                        throw new Exception($working_dir->get_error_message());
                    }
                    $result = $upgrader->install_package(array('source' => $working_dir, 'destination' => WP_PLUGIN_DIR, 'clear_destination' => false, 'abort_if_destination_exists' => false, 'clear_working' => true, 'hook_extra' => array('type' => 'plugin', 'action' => 'install')));
                    if (is_wp_error($result)) {
                        throw new Exception($result->get_error_message());
                    }
                    $activate = true;
                } catch (Exception $e) {
                    WC_Admin_Notices::add_custom_notice($plugin_to_install_id . '_install_error', sprintf(__('%1$s could not be installed (%2$s). <a href="%3$s">Please install it manually by clicking here.</a>', 'woocommerce'), $plugin_to_install['name'], $e->getMessage(), esc_url(admin_url('index.php?wc-install-plugin-redirect=' . $plugin_slug))));
                }
                ob_end_clean();
            }
            wp_clean_plugins_cache();
            if ($activate) {
                try {
                    add_action('add_option_mailchimp_woocommerce_plugin_do_activation_redirect', array(__CLASS__, 'remove_mailchimps_redirect'), 10, 2);
                    $result = activate_plugin($installed ? $installed_plugins[$plugin_file] : $plugin_slug . '/' . $plugin_file);
                    if (is_wp_error($result)) {
                        throw new Exception($result->get_error_message());
                    }
                } catch (Exception $e) {
                    WC_Admin_Notices::add_custom_notice($plugin_to_install_id . '_install_error', sprintf(__('%1$s was installed but could not be activated. <a href="%2$s">Please activate it manually by clicking here.</a>', 'woocommerce'), $plugin_to_install['name'], admin_url('plugins.php')));
                }
            }
        }
    }
    public static function remove_mailchimps_redirect($option, $value)
    {
        remove_action('add_option_mailchimp_woocommerce_plugin_do_activation_redirect', array(__CLASS__, 'remove_mailchimps_redirect'));
        update_option('mailchimp_woocommerce_plugin_do_activation_redirect', false);
    }
    public static function theme_background_installer($theme_slug)
    {
        $args = func_get_args();
        if (!empty($theme_slug)) {
            ob_start();
            try {
                $theme = wp_get_theme($theme_slug);
                if (!$theme->exists()) {
                    require_once ABSPATH . 'wp-admin/includes/file.php';
                    include_once ABSPATH . 'wp-admin/includes/class-wp-upgrader.php';
                    include_once ABSPATH . 'wp-admin/includes/theme.php';
                    WP_Filesystem();
                    $skin = new Automatic_Upgrader_Skin();
                    $upgrader = new Theme_Upgrader($skin);
                    $api = themes_api('theme_information', array('slug' => $theme_slug, 'fields' => array('sections' => false)));
                    $result = $upgrader->install($api->download_link);
                    if (is_wp_error($result)) {
                        throw new Exception($result->get_error_message());
                    } elseif (is_wp_error($skin->result)) {
                        throw new Exception($skin->result->get_error_message());
                    } elseif (is_null($result)) {
                        throw new Exception('Unable to connect to the filesystem. Please confirm your credentials.');
                    }
                }
                switch_theme($theme_slug);
            } catch (Exception $e) {
                WC_Admin_Notices::add_custom_notice($theme_slug . '_install_error', sprintf(__('%1$s could not be installed (%2$s). <a href="%3$s">Please install it manually by clicking here.</a>', 'woocommerce'), $theme_slug, $e->getMessage(), esc_url(admin_url('update.php?action=install-theme&theme=' . $theme_slug . '&_wpnonce=' . wp_create_nonce('install-theme_' . $theme_slug)))));
            }
            ob_end_clean();
        }
    }
    private static function set_paypal_standard_load_eligibility()
    {
        if (class_exists('WC_Gateway_Paypal')) {
            (new WC_Gateway_Paypal())->should_load();
        }
    }
    private static function get_refunds_return_policy_page_content()
    {
        return <<<EOT
<!-- wp:paragraph -->
<p><b>This is a sample page.</b></p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<h3>Overview</h3>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Our refund and returns policy lasts 30 days. If 30 days have passed since your purchase, we can’t offer you a full refund or exchange.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>To be eligible for a return, your item must be unused and in the same condition that you received it. It must also be in the original packaging.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Several types of goods are exempt from being returned. Perishable goods such as food, flowers, newspapers or magazines cannot be returned. We also do not accept products that are intimate or sanitary goods, hazardous materials, or flammable liquids or gases.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Additional non-returnable items:</p>
<!-- /wp:paragraph -->

<!-- wp:list -->
<ul>
<li>Gift cards</li>
<li>Downloadable software products</li>
<li>Some health and personal care items</li>
</ul>
<!-- /wp:list -->

<!-- wp:paragraph -->
<p>To complete your return, we require a receipt or proof of purchase.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Please do not send your purchase back to the manufacturer.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>There are certain situations where only partial refunds are granted:</p>
<!-- /wp:paragraph -->

<!-- wp:list -->
<ul>
<li>Book with obvious signs of use</li>
<li>CD, DVD, VHS tape, software, video game, cassette tape, or vinyl record that has been opened.</li>
<li>Any item not in its original condition, is damaged or missing parts for reasons not due to our error.</li>
<li>Any item that is returned more than 30 days after delivery</li>
</ul>
<!-- /wp:list -->

<!-- wp:paragraph -->
<h2>Refunds</h2>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Once your return is received and inspected, we will send you an email to notify you that we have received your returned item. We will also notify you of the approval or rejection of your refund.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>If you are approved, then your refund will be processed, and a credit will automatically be applied to your credit card or original method of payment, within a certain amount of days.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<b>Late or missing refunds</b>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>If you haven’t received a refund yet, first check your bank account again.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Then contact your credit card company, it may take some time before your refund is officially posted.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Next contact your bank. There is often some processing time before a refund is posted.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>If you’ve done all of this and you still have not received your refund yet, please contact us at {email address}.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<b>Sale items</b>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Only regular priced items may be refunded. Sale items cannot be refunded.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<h2>Exchanges</h2>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>We only replace items if they are defective or damaged. If you need to exchange it for the same item, send us an email at {email address} and send your item to: {physical address}.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<h2>Gifts</h2>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>If the item was marked as a gift when purchased and shipped directly to you, you’ll receive a gift credit for the value of your return. Once the returned item is received, a gift certificate will be mailed to you.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>If the item wasn’t marked as a gift when purchased, or the gift giver had the order shipped to themselves to give to you later, we will send a refund to the gift giver and they will find out about your return.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<h2>Shipping returns</h2>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>To return your product, you should mail your product to: {physical address}.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>You will be responsible for paying for your own shipping costs for returning your item. Shipping costs are non-refundable. If you receive a refund, the cost of return shipping will be deducted from your refund.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Depending on where you live, the time it may take for your exchanged product to reach you may vary.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>If you are returning more expensive items, you may consider using a trackable shipping service or purchasing shipping insurance. We don’t guarantee that we will receive your returned item.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<h2>Need help?</h2>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Contact us at {email} for questions related to refunds and returns.</p>
<!-- /wp:paragraph -->
EOT;
    }
    public static function add_admin_note_after_page_created()
    {
        if (!WC()->is_wc_admin_active()) {
            return;
        }
        $page_id = get_option('woocommerce_refund_returns_page_created', null);
        if (null === $page_id) {
            return;
        }
        WC_Notes_Refund_Returns::possibly_add_note($page_id);
    }
    public static function page_created($page_id, $page_data)
    {
        if ('refund_returns' === $page_data['post_name']) {
            delete_option('woocommerce_refund_returns_page_created');
            add_option('woocommerce_refund_returns_page_created', $page_id, '', false);
        }
    }
}
WC_Install::init();