WcPagantis::pagantisActivation()

Complexity

Conditions	17
Paths	192

Size

Total Lines	104
Code Lines	65

Duplication

Lines	0
Ratio	0 %

Importance

Changes	4
Bugs	0	Features	0

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

        $tableName = $wpdb->prefix.self::CONCURRENCY_TABLE;
        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.self::CONFIG_TABLE;

        //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')
                        );
                    }
                }
            }
        }

        //Adapting selector to array < v8.2.2
        $tableName = $wpdb->prefix.self::CONFIG_TABLE;
        $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'));
        }

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

        // Convert a multimple 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?

    }