WcPagantis::pagantisActivation()

Complexity

Conditions	29
Paths	> 20000

Size

Total Lines	189
Code Lines	117

Duplication

Lines	0
Ratio	0 %

Importance

Changes	14
Bugs	0	Features	1

<?php
    public function pagantisActivation()
    {
        global $wpdb;

        $tableName = $wpdb->prefix.PG_CONCURRENCY_TABLE_NAME;
        if ($wpdb->get_var("SHOW TABLES LIKE '$tableName'") != $tableName) {
            $charset_collate = $wpdb->get_charset_collate();
            $sql = "CREATE TABLE $tableName ( order_id int NOT NULL,  
                    createdAt timestamp DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY id (order_id)) $charset_collate";
            require_once(ABSPATH.'wp-admin/includes/upgrade.php');

The constant ABSPATH was not found. Maybe you did not declare it correctly or list all dependencies?

            dbDelta($sql);

The function dbDelta was not found. Maybe you did not declare it correctly or list all dependencies?

        }

        $tableName = $wpdb->prefix.PG_CONFIG_TABLE_NAME;

        //Check if table exists
        $tableExists = $wpdb->get_var("SHOW TABLES LIKE '$tableName'") != $tableName;
        if ($tableExists) {
            $charset_collate = $wpdb->get_charset_collate();
            $sql = "CREATE TABLE IF NOT EXISTS $tableName (
                                id int NOT NULL AUTO_INCREMENT, 
                                config varchar(60) NOT NULL, 
                                value varchar(1000) NOT NULL, 
                                UNIQUE KEY id(id)) $charset_collate";

            require_once(ABSPATH.'wp-admin/includes/upgrade.php');
            dbDelta($sql);
        } else {
            //Updated value field to adapt to new length < v8.0.1
            $query = "select COLUMN_TYPE FROM information_schema.COLUMNS where TABLE_NAME='$tableName' AND COLUMN_NAME='value'";
            $results = $wpdb->get_results($query, ARRAY_A);

The constant ARRAY_A was not found. Maybe you did not declare it correctly or list all dependencies?

            if ($results['0']['COLUMN_TYPE'] == 'varchar(100)') {
                $sql = "ALTER TABLE $tableName MODIFY value varchar(1000)";
                $wpdb->query($sql);
            }

            //Adapting selector to array < v8.1.1
            $query = "select * from $tableName where config='PAGANTIS_SIMULATOR_CSS_QUANTITY_SELECTOR' 
                               or config='PAGANTIS_SIMULATOR_CSS_PRICE_SELECTOR'";
            $dbCurrentConfig = $wpdb->get_results($query, ARRAY_A);
            foreach ($dbCurrentConfig as $item) {
                if ($item['config'] == 'PAGANTIS_SIMULATOR_CSS_PRICE_SELECTOR') {
                    $css_price_selector = $this->preparePriceSelector($item['value']);
                    if ($item['value'] != $css_price_selector) {
                        $wpdb->update(
                            $tableName,
                            array('value' => stripslashes($css_price_selector)),
                            array('config' => 'PAGANTIS_SIMULATOR_CSS_PRICE_SELECTOR'),
                            array('%s'),
                            array('%s')
                        );
                    }
                } elseif ($item['config'] == 'PAGANTIS_SIMULATOR_CSS_QUANTITY_SELECTOR') {
                    $css_quantity_selector = $this->prepareQuantitySelector($item['value']);
                    if ($item['value'] != $css_quantity_selector) {
                        $wpdb->update(
                            $tableName,
                            array('value' => stripslashes($css_quantity_selector)),
                            array('config' => 'PAGANTIS_SIMULATOR_CSS_QUANTITY_SELECTOR'),
                            array('%s'),
                            array('%s')
                        );
                    }
                }
            }
        }

        // Making sure DB tables are created < v8.6.9
        if (!isPgTableCreated(PG_LOGS_TABLE_NAME)){
            createLogsTable();
        }
        if (isPgTableCreated(PG_CART_PROCESS_TABLE)){
            alterCartProcessTable();
        }

        if (!isPgTableCreated(PG_CART_PROCESS_TABLE)) {
            checkCartProcessTable();
        }

        //Adapting selector to array < v8.2.2
        $tableName = $wpdb->prefix.PG_CONFIG_TABLE_NAME;
        $query = "select * from $tableName where config='PAGANTIS_SIMULATOR_THOUSANDS_SEPARATOR'";
        $results = $wpdb->get_results($query, ARRAY_A);
        if (count($results) == 0) {
            $wpdb->insert($tableName, array('config' => 'PAGANTIS_SIMULATOR_THOUSANDS_SEPARATOR', 'value'  => '.'), array('%s', '%s'));
            $wpdb->insert($tableName, array('config' => 'PAGANTIS_SIMULATOR_DECIMAL_SEPARATOR', 'value'  => ','), array('%s', '%s'));
        }

        //Adding new selector < v8.3.0
        $tableName = $wpdb->prefix.PG_CONFIG_TABLE_NAME;
        $query = "select * from $tableName where config='PAGANTIS_DISPLAY_MAX_AMOUNT'";
        $results = $wpdb->get_results($query, ARRAY_A);
        if (count($results) == 0) {
            $wpdb->insert($tableName, array('config' => 'PAGANTIS_DISPLAY_MAX_AMOUNT', 'value'  => '0'), array('%s', '%s'));
        }

        //Adding new selector < v8.3.2
        $tableName = $wpdb->prefix.PG_CONFIG_TABLE_NAME;
        $query = "select * from $tableName where config='PAGANTIS_SIMULATOR_DISPLAY_SITUATION'";
        $results = $wpdb->get_results($query, ARRAY_A);
        if (count($results) == 0) {
            $wpdb->insert($tableName, array('config' => 'PAGANTIS_SIMULATOR_DISPLAY_SITUATION', 'value'  => 'default'), array('%s', '%s'));
            $wpdb->insert($tableName, array('config' => 'PAGANTIS_SIMULATOR_SELECTOR_VARIATION', 'value'  => 'default'), array('%s', '%s'));
        }


        //Adding new selector < v8.3.3
        $tableName = $wpdb->prefix.PG_CONFIG_TABLE_NAME;
        $query = "select * from $tableName where config='PAGANTIS_SIMULATOR_DISPLAY_TYPE_CHECKOUT'";
        $results = $wpdb->get_results($query, ARRAY_A);
        if (count($results) == 0) {
            $wpdb->insert($tableName, array('config' => 'PAGANTIS_SIMULATOR_DISPLAY_TYPE_CHECKOUT', 'value'  => 'sdk.simulator.types.CHECKOUT_PAGE'), array('%s', '%s'));
            $wpdb->update($tableName, array('value' => 'sdk.simulator.types.PRODUCT_PAGE'), array('config' => 'PAGANTIS_SIMULATOR_DISPLAY_TYPE'), array('%s'), array('%s'));
        }

        //Adapting to variable selector < v8.3.6
        $variableSelector="div.summary div.woocommerce-variation.single_variation > div.woocommerce-variation-price span.price";
        $tableName = $wpdb->prefix.PG_CONFIG_TABLE_NAME;
        $query = "select * from $tableName where config='PAGANTIS_SIMULATOR_SELECTOR_VARIATION' and value='default'";
        $results = $wpdb->get_results($query, ARRAY_A);
        if (count($results) == 0) {
            $wpdb->update($tableName, array('value' => $variableSelector), array('config' => 'PAGANTIS_SIMULATOR_SELECTOR_VARIATION'), array('%s'), array('%s'));
        }

        //Adapting vars to 4x < v8.6.x
        $tableName = $wpdb->prefix.PG_CONFIG_TABLE_NAME;
        $query = "select * from $tableName where config='PAGANTIS_TITLE_4x'";
        $results = $wpdb->get_results($query, ARRAY_A);
        if (count($results) == 0) {
            $wpdb->insert($tableName, array('config' => 'PAGANTIS_TITLE_4x', 'value'  => 'Until 4 installments, without fees'), array('%s', '%s'));
            $wpdb->insert($tableName, array('config' => 'PAGANTIS_DISPLAY_MIN_AMOUNT_4x', 'value'  => 1), array('%s', '%s'));
            $wpdb->insert($tableName, array('config' => 'PAGANTIS_DISPLAY_MAX_AMOUNT_4x', 'value'  => 800), array('%s', '%s'));

            $wpdb->update($tableName, array('value' => 'Instant financing'), array('config' => 'PAGANTIS_TITLE'), array('%s'), array('%s'));
            $wpdb->update($tableName, array('value' => 1500), array('config' => 'PAGANTIS_DISPLAY_MAX_AMOUNT'), array('%s'), array('%s'));
        }

        //Adapting situation var of 4x < v8.6.2
        $tableName = $wpdb->prefix.PG_CONFIG_TABLE_NAME;
        $query = "select * from $tableName where config='PAGANTIS_SIMULATOR_CSS_POSITION_SELECTOR_4X'";
        $results = $wpdb->get_results($query, ARRAY_A);
        if (count($results) == 0) {
            $wpdb->insert($tableName, array('config' => 'PAGANTIS_SIMULATOR_CSS_POSITION_SELECTOR_4X', 'value'  => 'default'), array('%s', '%s'));
        }

        //Adding WC price separator verifications to adapt extra config dynamically < v8.3.9
        if (!areDecimalSeparatorEqual()) {
            updateDecimalSeparatorDbConfig();
        }
        if (!areThousandsSeparatorEqual()) {
            updateThousandsSeparatorDbConfig();
        }

        //Adapting product price selector < v8.6.7
        $tableName = $wpdb->prefix.PG_CONFIG_TABLE_NAME;
        $query = "select * from $tableName where config='PAGANTIS_SIMULATOR_CSS_PRICE_SELECTOR'";
        $results = $wpdb->get_results($query, ARRAY_A);
        if (count($results) == 0) {
            $wpdb->update($tableName, array('value' => 'a:4:{i:0;s:52:"div.summary *:not(del)>.woocommerce-Price-amount bdi";i:1;s:48:"div.summary *:not(del)>.woocommerce-Price-amount";i:2;s:54:"div.entry-summary *:not(del)>.woocommerce-Price-amount";i:3;s:36:"*:not(del)>.woocommerce-Price-amount";}'), array('config' => 'PAGANTIS_SIMULATOR_CSS_PRICE_SELECTOR'), array('%s'), array('%s'));
        }

        $dbConfigs = $wpdb->get_results("select * from $tableName", ARRAY_A);

        // Convert a multiple dimension array for SQL insert statements into a simple key/value
        $simpleDbConfigs = array();
        foreach ($dbConfigs as $config) {
            $simpleDbConfigs[$config['config']] = $config['value'];
        }
        $newConfigs = array_diff_key($this->defaultConfigs, $simpleDbConfigs);
        if (!empty($newConfigs)) {
            foreach ($newConfigs as $key => $value) {
                $wpdb->insert($tableName, array('config' => $key, 'value'  => $value), array('%s', '%s'));
            }
        }

        //Current plugin config: pagantis_public_key => New field --- public_key => Old field
        $settings = get_option('woocommerce_pagantis_settings');

The function get_option was not found. Maybe you did not declare it correctly or list all dependencies?

        if (!isset($settings['pagantis_public_key']) && $settings['public_key']) {
            $settings['pagantis_public_key'] = $settings['public_key'];
            unset($settings['public_key']);
        }

        if (!isset($settings['pagantis_private_key']) && $settings['secret_key']) {
            $settings['pagantis_private_key'] = $settings['secret_key'];
            unset($settings['secret_key']);
        }

        update_option('woocommerce_pagantis_settings', $settings);

The function update_option was not found. Maybe you did not declare it correctly or list all dependencies?

    }