wpinv_v119_upgrades() - Code Metrics - Inspection of "payment form improvements" - AyeCode/invoicing - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — master ( 6621fa...568391 )

by Brian
created 2020-10-01 10:24 UTC
wpinv_v119_upgrades() A

↳ Parent: Project
Complexity

Conditions	1
Paths	1
Size

Total Lines	3
Code Lines	2
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	1
eloc	2
nc	1
nop	0
dl	0
loc	3
rs	10
c	0
b	0
f	0
<?php
/**
 * Upgrade related functions.
 *
 * @since 1.0.0
 */

/**
 * Perform automatic upgrades when necessary.
 *
 * @since 1.0.0
*/
function wpinv_automatic_upgrade() {
    $wpi_version = get_option( 'wpinv_version' );

    // Update tables.
    if ( ! get_option( 'getpaid_created_invoice_tables' ) ) {
        wpinv_v119_upgrades();
        update_option( 'getpaid_created_invoice_tables', true );
    }

    if ( $wpi_version == WPINV_VERSION ) {
        return;
    }

    if ( version_compare( $wpi_version, '0.0.5', '<' ) ) {
    if ( version_compare( /** @scrutinizer ignore-type */ $wpi_version, '0.0.5', '<' ) ) {
        wpinv_v005_upgrades();
    }

    if ( version_compare( $wpi_version, '1.0.3', '<' ) ) {
        wpinv_v110_upgrades();
    }

    update_option( 'wpinv_version', WPINV_VERSION );
}
add_action( 'admin_init', 'wpinv_automatic_upgrade' );

function wpinv_v005_upgrades() {
    global $wpdb;

    // Invoices status
    $results = $wpdb->get_results( "SELECT ID FROM " . $wpdb->posts . " WHERE post_type = 'wpi_invoice' AND post_status IN( 'pending', 'processing', 'onhold', 'refunded', 'cancelled', 'failed', 'renewal' )" );
    if ( !empty( $results ) ) {
        $wpdb->query( "UPDATE " . $wpdb->posts . " SET post_status = CONCAT( 'wpi-', post_status ) WHERE post_type = 'wpi_invoice' AND post_status IN( 'pending', 'processing', 'onhold', 'refunded', 'cancelled', 'failed', 'renewal' )" );

        // Clean post cache
        foreach ( $results as $row ) {
            clean_post_cache( $row->ID );
        }
    }

    // Item meta key changes
    $query = "SELECT DISTINCT post_id FROM " . $wpdb->postmeta . " WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id', '_wpinv_cpt_name', '_wpinv_cpt_singular_name' )";
    $results = $wpdb->get_results( $query );

    if ( !empty( $results ) ) {
        $wpdb->query( "UPDATE " . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_id' WHERE meta_key IN( '_wpinv_item_id', '_wpinv_package_id', '_wpinv_post_id' )" );
        $wpdb->query( "UPDATE " . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_name' WHERE meta_key = '_wpinv_cpt_name'" );
        $wpdb->query( "UPDATE " . $wpdb->postmeta . " SET meta_key = '_wpinv_custom_singular_name' WHERE meta_key = '_wpinv_cpt_singular_name'" );
        
        foreach ( $results as $row ) {
            clean_post_cache( $row->post_id );
        }
    }

    wpinv_add_admin_caps();
}

function wpinv_v110_upgrades() {

    // Add Subscription tables
    $db = new WPInv_Subscriptions_DB;
    /** @scrutinizer ignore-unhandled */ @$db->create_table();
class A
{
    function getObject()
    {
        return null;
    }

}

$a = new A();
if ($a->getObject()) {

}

/**
 * Version 119 upgrades.
 */
function wpinv_v119_upgrades() {
    wpinv_create_invoices_table();
    wpinv_convert_old_invoices();
}

/**
 * Creates the invoices table.
 */
function wpinv_create_invoices_table() {
    global $wpdb;

    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );

    // Create invoices table.
    $table = $wpdb->prefix . 'getpaid_invoices';
    $sql   = "CREATE TABLE $table (

            post_id BIGINT(20) NOT NULL,
            `number` VARCHAR(100),
            `key` VARCHAR(100),
            `type` VARCHAR(100) NOT NULL DEFAULT 'invoice',
            mode VARCHAR(100) NOT NULL DEFAULT 'live',

            user_ip VARCHAR(100),
            first_name VARCHAR(100),
            last_name VARCHAR(100),
            `address` VARCHAR(100),
            city VARCHAR(100),
            `state` VARCHAR(100),
            country VARCHAR(100),
            zip VARCHAR(100),
            adddress_confirmed INT(10),

            gateway VARCHAR(100),
            transaction_id VARCHAR(100),
            currency VARCHAR(10),
            subtotal FLOAT NOT NULL DEFAULT 0,
            tax FLOAT NOT NULL DEFAULT 0,
            fees_total FLOAT NOT NULL DEFAULT 0,
            total FLOAT NOT NULL DEFAULT 0,
            discount FLOAT NOT NULL DEFAULT 0,
            discount_code VARCHAR(100),
            disable_taxes INT(2) NOT NULL DEFAULT 0,
            due_date DATETIME,
            completed_date DATETIME,
            company VARCHAR(100),
            vat_number VARCHAR(100),
            vat_rate VARCHAR(100),

            custom_meta TEXT,
            PRIMARY KEY  (post_id),
            KEY number (number),
            KEY `key` ( `key` )
            ) CHARACTER SET utf8 COLLATE utf8_general_ci;";

    dbDelta( $sql );

    // Create invoice items table.
    $table = $wpdb->prefix . 'getpaid_invoice_items';
    $sql   = "CREATE TABLE $table (
            ID BIGINT(20) NOT NULL AUTO_INCREMENT,
            post_id BIGINT(20) NOT NULL,

            item_id BIGINT(20) NOT NULL,
            item_name TEXT NOT NULL,
            item_description TEXT NOT NULL,

            vat_rate FLOAT NOT NULL DEFAULT 0,
            vat_class VARCHAR(100),
            tax FLOAT NOT NULL DEFAULT 0,
            item_price FLOAT NOT NULL DEFAULT 0,
            custom_price FLOAT NOT NULL DEFAULT 0,
            quantity INT(20) NOT NULL DEFAULT 1,
            discount FLOAT NOT NULL DEFAULT 0,
            subtotal FLOAT NOT NULL DEFAULT 0,
            price FLOAT NOT NULL DEFAULT 0,
            meta TEXT,
            fees TEXT,
            PRIMARY KEY  (ID),
            KEY item_id (item_id),
            KEY post_id ( post_id )
            ) CHARACTER SET utf8 COLLATE utf8_general_ci;";

    dbDelta( $sql );
}

/**
 * Copies data from meta tables to our custom tables.
 */
function wpinv_convert_old_invoices() {
    global $wpdb;

    $invoices = array_unique(
        get_posts(
            array(
                'post_type'      => array( 'wpi_invoice', 'wpi_quote' ),
                'posts_per_page' => -1,
                'fields'         => 'ids',
                'post_status'    => array_keys( wpinv_get_invoice_statuses( true ) ),
            )
        )
    );
    $invoices_table = $wpdb->prefix . 'getpaid_invoices';
    $invoice_items_table = $wpdb->prefix . 'getpaid_invoice_items';

    if ( ! class_exists( 'WPInv_Legacy_Invoice' ) ) {
        require_once( WPINV_PLUGIN_DIR . 'includes/class-wpinv-legacy-invoice.php' );
    }

    $invoice_rows = array();
    foreach ( $invoices as $invoice ) {

        $invoice = new WPInv_Legacy_Invoice( $invoice );
        $fields = array (
            'post_id'        => $invoice->ID,
            'number'         => $invoice->get_number(),
            'key'            => $invoice->get_key(),
            'type'           => str_replace( 'wpi_', '', $invoice->post_type ),
            'mode'           => $invoice->mode,
            'user_ip'        => $invoice->get_ip(),
            'first_name'     => $invoice->get_first_name(),
            'last_name'      => $invoice->get_last_name(),
            'address'        => $invoice->get_address(),
            'city'           => $invoice->city,
            'state'          => $invoice->state,
            'country'        => $invoice->country,
            'zip'            => $invoice->zip,
            'adddress_confirmed' => (int) $invoice->adddress_confirmed,
            'gateway'        => $invoice->get_gateway(),
            'transaction_id' => $invoice->get_transaction_id(),
            'currency'       => $invoice->get_currency(),
            'subtotal'       => $invoice->get_subtotal(),
            'tax'            => $invoice->get_tax(),
            'fees_total'     => $invoice->get_fees_total(),
            'total'          => $invoice->get_total(),
            'discount'       => $invoice->get_discount(),
            'discount_code'  => $invoice->get_discount_code(),
            'disable_taxes'  => $invoice->disable_taxes,
            'due_date'       => $invoice->get_due_date(),
            'completed_date' => $invoice->get_completed_date(),
            'company'        => $invoice->company,
            'vat_number'     => $invoice->vat_number,
            'vat_rate'       => $invoice->vat_rate,
            'custom_meta'    => $invoice->payment_meta
        );

        foreach ( $fields as $key => $val ) {
            if ( is_null( $val ) ) {
                $val = '';
            }
            $val = maybe_serialize( $val );
            $fields[ $key ] = $wpdb->prepare( '%s', $val );
        }

        $fields = implode( ', ', $fields );
        $invoice_rows[] = "($fields)";

        $item_rows    = array();
        $item_columns = array();
        foreach ( $invoice->get_cart_details() as $details ) {
            $fields = array(
                'post_id'          => $invoice->ID,
                'item_id'          => $details['id'],
                'item_name'        => $details['name'],
                'item_description' => empty( $details['meta']['description'] ) ? '' : $details['meta']['description'],
                'vat_rate'         => $details['vat_rate'],
                'vat_class'        => empty( $details['vat_class'] ) ? '_standard' : $details['vat_class'],
                'tax'              => $details['tax'],
                'item_price'       => $details['item_price'],
                'custom_price'     => $details['custom_price'],
                'quantity'         => $details['quantity'],
                'discount'         => $details['discount'],
                'subtotal'         => $details['subtotal'],
                'price'            => $details['price'],
                'meta'             => $details['meta'],
                'fees'             => $details['fees'],
            );

            $item_columns = array_keys ( $fields );

            foreach ( $fields as $key => $val ) {
                if ( is_null( $val ) ) {
                    $val = '';
                }
                $val = maybe_serialize( $val );
                $fields[ $key ] = $wpdb->prepare( '%s', $val );
            }

            $fields = implode( ', ', $fields );
            $item_rows[] = "($fields)";
        }

        $item_rows    = implode( ', ', $item_rows );
        $item_columns = implode( ', ', $item_columns );
        $wpdb->query( "INSERT INTO $invoice_items_table ($item_columns) VALUES $item_rows" );
    }

    $invoice_rows = implode( ', ', $invoice_rows );
    $wpdb->query( "INSERT INTO $invoices_table VALUES $invoice_rows" );

}

AyeCode / invoicing

Push — master ( 6621fa...568391 )

wpinv_v119_upgrades() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
